Click on ‘Forecast Model’ to deep dive
Access the calculations behind the graphs by clicking here to see the numbers in an editable spreadsheet format.
-
Change how you want view data
You can view forecasts in daily/weekly/monthly forecast buckets while also
toggling the forecast horizon to 1 week/1 month/3 months/6 months. -
Override the automated forecast with manual inputs
You have just received information that AR inflows from EMEA will fall by ~20% between Jun 22 to Jul 26 due to supply chain issues.
-
Use filters for better visibility
Select region EMEA and also the countries whose forecast you want to change.
-
Manually add the changes to your forecast
In the ‘Manual Override’ column, change the value by entering an absolute number or a formula as shown here i.e., B7=-(0.2*B6)
-
Apply it over the cells, just like Excel
You can manually copy paste the formula from Jun 22(Col.B) to Jul 26(Col.F)
-
View the forecast with the changes
Once the values are modified, switch to the previous tab and toggle the ‘Manual Override’ button to see how the forecast has changed.
