Forum Discussion
Any ideas on what's wrong with my forecasting?
I've noticed that the forecast takes a dip in 2024 instead of rising steadily. Any ideas why? My formula is =FORECAST.LINEAR(R6,B7:Q7,B6:Q6)
| Year | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 |
| Sq Ft LOGS | 15990 | 15990 | 16590 | 16590 | 16590 | 16590 | 16590 | 16590 | 16590 | 16590 | 16590 | 16590 | 16590 | 21660 | 22620 | 22940 | 20683.25 | 21210.3125 | 21751.80937 | 22388.17266 | 23054.58152 | 23742.63829 | 24441.09471 | 25135.34928 | 25806.89013 | 26432.68245 |
| % Change | 0.00% | 3.75% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 30.56% | 4.43% | 1.41% | -9.84% | 2.55% | 2.55% | 2.93% | 2.98% | 2.98% | 2.94% | 2.84% | 2.67% | 2.42% | |
| **bleep** % Change | 0.00% | 3.75% | 3.75% | 3.75% | 3.75% | 3.75% | 3.75% | 3.75% | 3.75% | 3.75% | 3.75% | 3.75% | 34.31% | 38.75% | 40.16% | 30.32% | 32.87% | 35.42% | 38.35% | 41.33% | 44.31% | 47.25% | 50.09% | 52.76% | 55.19% |
1 Reply
- Hard to say. The table you posted, where is the top-left cell located on the sheet? And it looks as if the table does not show the actual forecast numbers?
