🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 168 (from laksa098)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa168.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://learn.microsoft.com/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula\')), getAhrefsUnparsedNoserviceFromURL(\'https://learn.microsoft.com/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/5110518\/use-of-exponential-smoothing-formula","crawl_time":1756120840,"first_indexed_time":0,"http_code":200,"src_unparsed":"com,microsoft!learn,\/en-us\/answers\/questions\/5110518\/use-of-exponential-smoothing-formula s443","src_root_hash":"14615152987638977768","history_drop_reason":null,"meta_title":"use of exponential smoothing formula - Microsoft Q&A","meta_descriptions":["Hi I am trying to get the FORECAST.ETS formula to work but its returning me a #NUM! error. My formula is =FORECAST.ETS($A1005,$B$2:$B$1004,$A$2:$A$1004,1,1,1) $A$1005 refers to the target date while $B$2:$B$1004 is the data values range and $A$2:$A$1004…"],"attrs_boilerpipe_text":"Hi I am trying to get the FORECAST.ETS formula to work but its returning me a #NUM! error. My formula is =FORECAST.ETS($A1005,$B$2:$B$1004,$A$2:$A$1004,1,1,1) $A$1005 refers to the target date while $B$2:$B$1004 is the data values range and $A$2:$A$1004 is the time range. The linear method with formula =FORECAST.LINEAR($A1005,$B$2:$B$1004,$A$2:$A$1004) works perfectly so it would seem the arguments are correct. I'm wondering if the dd\/mm\/yyyy formatted time range could be the problem? Is that a supported time range?","attrs_markdown":"[Skip to main content](https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/5110518\/use-of-exponential-smoothing-formula#main)\n\nThis browser is no longer supported.\n\nUpgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.\n\n[Download Microsoft Edge](https:\/\/go.microsoft.com\/fwlink\/p\/?LinkID=2092881%20)   [More info about Internet Explorer and Microsoft Edge](https:\/\/learn.microsoft.com\/en-us\/lifecycle\/faq\/internet-explorer-microsoft-edge)\n\nAdd\n\nAdd\n\n#### Share via\n[Facebook](https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula%0A%09%09%09%09%09%09%09%09%09%09%09)   [x.com](https:\/\/twitter.com\/intent\/tweet?original_referer=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula%0A%09%09%09%09%09%09%09%09%09%09%09&text=use%20of%20exponential%20smoothing%20formula%0A%09%09%09%09%09%09%09%09%09%09%09&tw_p=tweetbutton&url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula)   [LinkedIn](https:\/\/www.linkedin.com\/cws\/share?url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula)   [Email](<mailto:?subject=&#10;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9;%5BShared%20Question%5D%20use%20of%20exponential%20smoothing%20formula&body=use of exponential smoothing formulahttps%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula>)\n# use of exponential smoothing formula\n![](<data:image\/svg+xml, %3Csvg xmlns='http:\/\/www.w3.org\/2000\/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px \"SegoeUI\", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' \/%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C\/text%3E%3C\/svg%3E>)\n\nAnonymous\n\n2021-02-07T08:20:39+00:00\n\nHi I am trying to get the FORECAST.ETS formula to work but its returning me a \\#NUM! error.\n\nMy formula is =FORECAST.ETS(\\$A1005,\\$B\\$2:\\$B\\$1004,\\$A\\$2:\\$A\\$1004,1,1,1)\n\n\\$A\\$1005 refers to the target date while \\$B\\$2:\\$B\\$1004 is the data values range and \\$A\\$2:\\$A\\$1004 is the time range.\n\nThe linear method with formula =FORECAST.LINEAR(\\$A1005,\\$B\\$2:\\$B\\$1004,\\$A\\$2:\\$A\\$1004) works perfectly so it would seem the arguments are correct.\n\nI'm wondering if the dd\/mm\/yyyy formatted time range could be the problem? Is that a supported time range?\n\nMicrosoft 365 and Office \\| Excel \\| For home \\| Windows\n\n[Microsoft 365 and Office \\| Excel \\| For home \\| Windows](https:\/\/learn.microsoft.com\/en-us\/answers\/tags\/1168\/m365-office-office-excel-home-platform-windows\/)\n\n![](https:\/\/learn.microsoft.com\/answers\/media\/logo-ms-social.png)\n\nSign in to follow\n\nLocked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.\n\n0 comments No comments\n\nReport a concern\n\nI have the same question\n\nI have the same question\n\n0 {count} votes\n\n## 4 answers\nSort by:  Most helpful\n\n[Most helpful](https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/5110518\/use-of-exponential-smoothing-formula?orderby=helpful&page=1#answers) [Newest](https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/5110518\/use-of-exponential-smoothing-formula?orderby=newest&page=1#answers) [Oldest](https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/5110518\/use-of-exponential-smoothing-formula?orderby=oldest&page=1#answers)\n\n1. ![](https:\/\/techprofile.blob.core.windows.net\/images\/dQLghcQVf0iX-PuiJC7CFg.png?8DCAF1)\n   \n   [HansV](https:\/\/learn.microsoft.com\/en-us\/users\/na\/?userid=85e00275-15c4-487f-97f8-fba2242ec216)  •\n   \n   461\\.6K Reputation points • MVP • Volunteer Moderator\n   \n   2021-02-07T13:28:10+00:00\n   \n   The formula itself is OK; it might be a peculiarity of your dates. According to the documentation for FORECAST.ETS:\n   \n   \"The dates in the timeline must have a consistent step between them and can’t be zero. The timeline isn't required to be sorted, as FORECAST.ETS will sort it implicitly for calculations. If a constant step can't be identified in the provided timeline, Forecast.ETS will return the \\#NUM! error.\"\n   \n   0 comments No comments\n   \n   Report a concern\n2. ![](<data:image\/svg+xml, %3Csvg xmlns='http:\/\/www.w3.org\/2000\/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px \"SegoeUI\", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' \/%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C\/text%3E%3C\/svg%3E>)\n   \n   Anonymous\n   \n   2021-02-07T13:49:28+00:00\n   \n   Thanks Hans. I did see that earlier although I didn't understand what \"constant step can't be identified\" means - like how do we even know it exists and solve for it.\n   \n   Anyway I solved it by replacing the dates with a numerical sequence with step of 1 from 1 to N and that seemed to have done the trick\\!\n   \n   I think it should work with dates but for some reason didn't at least in my case. Not sure if there's a bug but I hope Microsoft takes note of this on future releases.\n   \n   0 comments No comments\n   \n   Report a concern\n3. Deleted\n   \n   This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our [Code of Conduct](https:\/\/aka.ms\/msftqacodeconduct) for more information.\n   ***\n   Comments have been turned off. [Learn more](https:\/\/aka.ms\/msftqadelete)\n4. ![](<data:image\/svg+xml, %3Csvg xmlns='http:\/\/www.w3.org\/2000\/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px \"SegoeUI\", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' \/%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C\/text%3E%3C\/svg%3E>)\n   \n   Anonymous\n   \n   2021-02-07T21:40:21+00:00\n   \n   Fortunately in my case the dates are indeed daily so I think the fix I made is correct. I also read somewhere that FORECASTING.ETS can also work with numeric sequences that correspond to time periods but the intervals need to be the same, not necessarily a day for each date. They could be weeks, months or days as long as the time intervals are consistent.\n   \n   I'm more concerned about why it failed to work for dates when it should have. I'm not sure if the failure was due to dates that were not spaced exactly a day apart at the dates corresponded to stock trading days which would essentially be business days but the formula should have adjusted for that. But the data points would have been consecutive as each stock trading day even if they end on a weekday and therefore skip weekend dates would have been consecutive business days and thus converting to a numeric sequence of 1 apart might be the workaround.\n   \n   0 comments No comments\n   \n   Report a concern\n\n***\n## Additional resources\n\n[en-us](https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/5110518\/use-of-exponential-smoothing-formula)\n\n[Your Privacy Choices](https:\/\/aka.ms\/yourcaliforniaprivacychoices)\n\nTheme\n\n- Light\n- Dark\n- High contrast\n\n- [AI Disclaimer](https:\/\/learn.microsoft.com\/en-us\/principles-for-ai-generated-content)\n- [Previous Versions](https:\/\/learn.microsoft.com\/en-us\/previous-versions\/)\n- [Blog](https:\/\/techcommunity.microsoft.com\/t5\/microsoft-learn-blog\/bg-p\/MicrosoftLearnBlog)\n- [Contribute](https:\/\/learn.microsoft.com\/en-us\/contribute)\n- [Privacy](https:\/\/go.microsoft.com\/fwlink\/?LinkId=521839)\n- [Terms of Use](https:\/\/learn.microsoft.com\/en-us\/legal\/termsofuse)\n- [Code of Conduct](https:\/\/aka.ms\/msftqacodeconduct)\n- [Trademarks](https:\/\/www.microsoft.com\/legal\/intellectualproperty\/Trademarks\/)\n- © Microsoft 2025","attrs_readable_markdown":null,"meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

7 months ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	7.9 months ago (distributed domain, exempt)
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://learn.microsoft.com/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula
Last Crawled	2025-08-25 11:20:40 (7 months ago)
First Indexed	not set
HTTP Status Code	200
Meta Title	use of exponential smoothing formula - Microsoft Q&A
Meta Description	Hi I am trying to get the FORECAST.ETS formula to work but its returning me a #NUM! error. My formula is =FORECAST.ETS($A1005,$B$2:$B$1004,$A$2:$A$1004,1,1,1) $A$1005 refers to the target date while $B$2:$B$1004 is the data values range and $A$2:$A$1004…
Meta Canonical	null
Boilerpipe Text	Hi I am trying to get the FORECAST.ETS formula to work but its returning me a #NUM! error. My formula is =FORECAST.ETS($A1005,$B$2:$B$1004,$A$2:$A$1004,1,1,1) $A$1005 refers to the target date while $B$2:$B$1004 is the data values range and $A$2:$A$1004 is the time range. The linear method with formula =FORECAST.LINEAR($A1005,$B$2:$B$1004,$A$2:$A$1004) works perfectly so it would seem the arguments are correct. I'm wondering if the dd/mm/yyyy formatted time range could be the problem? Is that a supported time range?
Markdown	[Skip to main content](https://learn.microsoft.com/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula#main) This browser is no longer supported. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. [Download Microsoft Edge](https://go.microsoft.com/fwlink/p/?LinkID=2092881%20) [More info about Internet Explorer and Microsoft Edge](https://learn.microsoft.com/en-us/lifecycle/faq/internet-explorer-microsoft-edge) Add Add #### Share via [Facebook](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula%0A%09%09%09%09%09%09%09%09%09%09%09) [x.com](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula%0A%09%09%09%09%09%09%09%09%09%09%09&text=use%20of%20exponential%20smoothing%20formula%0A%09%09%09%09%09%09%09%09%09%09%09&tw_p=tweetbutton&url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula) [LinkedIn](https://www.linkedin.com/cws/share?url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula) [Email](<mailto:?subject= %5BShared%20Question%5D%20use%20of%20exponential%20smoothing%20formula&body=use of exponential smoothing formulahttps%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F5110518%2Fuse-of-exponential-smoothing-formula>) # use of exponential smoothing formula ![](<data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E>) Anonymous 2021-02-07T08:20:39+00:00 Hi I am trying to get the FORECAST.ETS formula to work but its returning me a \#NUM! error. My formula is =FORECAST.ETS(\$A1005,\$B\$2:\$B\$1004,\$A\$2:\$A\$1004,1,1,1) \$A\$1005 refers to the target date while \$B\$2:\$B\$1004 is the data values range and \$A\$2:\$A\$1004 is the time range. The linear method with formula =FORECAST.LINEAR(\$A1005,\$B\$2:\$B\$1004,\$A\$2:\$A\$1004) works perfectly so it would seem the arguments are correct. I'm wondering if the dd/mm/yyyy formatted time range could be the problem? Is that a supported time range? Microsoft 365 and Office \\| Excel \\| For home \\| Windows [Microsoft 365 and Office \\| Excel \\| For home \\| Windows](https://learn.microsoft.com/en-us/answers/tags/1168/m365-office-office-excel-home-platform-windows/) ![](https://learn.microsoft.com/answers/media/logo-ms-social.png) Sign in to follow Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. 0 comments No comments Report a concern I have the same question I have the same question 0 {count} votes ## 4 answers Sort by: Most helpful [Most helpful](https://learn.microsoft.com/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula?orderby=helpful&page=1#answers) [Newest](https://learn.microsoft.com/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula?orderby=newest&page=1#answers) [Oldest](https://learn.microsoft.com/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula?orderby=oldest&page=1#answers) 1. ![](https://techprofile.blob.core.windows.net/images/dQLghcQVf0iX-PuiJC7CFg.png?8DCAF1) [HansV](https://learn.microsoft.com/en-us/users/na/?userid=85e00275-15c4-487f-97f8-fba2242ec216) • 461\.6K Reputation points • MVP • Volunteer Moderator 2021-02-07T13:28:10+00:00 The formula itself is OK; it might be a peculiarity of your dates. According to the documentation for FORECAST.ETS: "The dates in the timeline must have a consistent step between them and can’t be zero. The timeline isn't required to be sorted, as FORECAST.ETS will sort it implicitly for calculations. If a constant step can't be identified in the provided timeline, Forecast.ETS will return the \#NUM! error." 0 comments No comments Report a concern 2. ![](<data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E>) Anonymous 2021-02-07T13:49:28+00:00 Thanks Hans. I did see that earlier although I didn't understand what "constant step can't be identified" means - like how do we even know it exists and solve for it. Anyway I solved it by replacing the dates with a numerical sequence with step of 1 from 1 to N and that seemed to have done the trick\! I think it should work with dates but for some reason didn't at least in my case. Not sure if there's a bug but I hope Microsoft takes note of this on future releases. 0 comments No comments Report a concern 3. Deleted This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our [Code of Conduct](https://aka.ms/msftqacodeconduct) for more information. * Comments have been turned off. [Learn more](https://aka.ms/msftqadelete) 4. ![](<data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E>) Anonymous 2021-02-07T21:40:21+00:00 Fortunately in my case the dates are indeed daily so I think the fix I made is correct. I also read somewhere that FORECASTING.ETS can also work with numeric sequences that correspond to time periods but the intervals need to be the same, not necessarily a day for each date. They could be weeks, months or days as long as the time intervals are consistent. I'm more concerned about why it failed to work for dates when it should have. I'm not sure if the failure was due to dates that were not spaced exactly a day apart at the dates corresponded to stock trading days which would essentially be business days but the formula should have adjusted for that. But the data points would have been consecutive as each stock trading day even if they end on a weekday and therefore skip weekend dates would have been consecutive business days and thus converting to a numeric sequence of 1 apart might be the workaround. 0 comments No comments Report a concern * ## Additional resources [en-us](https://learn.microsoft.com/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula) [Your Privacy Choices](https://aka.ms/yourcaliforniaprivacychoices) Theme - Light - Dark - High contrast - [AI Disclaimer](https://learn.microsoft.com/en-us/principles-for-ai-generated-content) - [Previous Versions](https://learn.microsoft.com/en-us/previous-versions/) - [Blog](https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog) - [Contribute](https://learn.microsoft.com/en-us/contribute) - [Privacy](https://go.microsoft.com/fwlink/?LinkId=521839) - [Terms of Use](https://learn.microsoft.com/en-us/legal/termsofuse) - [Code of Conduct](https://aka.ms/msftqacodeconduct) - [Trademarks](https://www.microsoft.com/legal/intellectualproperty/Trademarks/) - © Microsoft 2025
Readable Markdown	null
Shard	168 (laksa)
Root Hash	14615152987638977768
Unparsed URL	com,microsoft!learn,/en-us/answers/questions/5110518/use-of-exponential-smoothing-formula s443