Rolling Models Over From Forecast to Forecast – Quick Time-Saving Tips

Blog post by Jill King – Anaplan Pre-Sales

Rolling models from forecast to forecast is always a large undertaking every forecast period when working in excel. My old employer would have us take our 20 models and save them as a new version for the next forecast. Our next step would be to create an extensive macro to update the formulas and links. After all of reworking of the 20 models, we would begin analysis.

ROLLING MODELS OVER FROM FORECAST TO FORECAST

Inevitably, we incurred time out issues because the macro didn’t work on a section of accounts or wouldn’t perform the action requested (such as hiding or unhiding columns).  As those issues were discovered, we would review our 20 models to make additional updates.

This process generally took about 4-5 days for each forecast (4 times a year)

Anaplan Solution
To create the next version of the forecast in Anaplan, a user would open the versions tab and insert a new version. After inserting the new version, access the time setting and change the rollover month from actual to forecast to the correct time period (literally a click of the button).  That’s it!

Since Anaplan’s formulas automatically update and all that is needed for an Analyst to worry about is making the relevant changes to your forecast rather than monkeying with the excel spreadsheets.

Estimated Monthly time savings = 8-10 hours (30-40 hours per quarter)

Note: Quick Time-Saving Tips is new and will be updated every Monday on the Anaplan Blog . Interested in having Jill @jilleking review a tedious task or want to submit your own Time-Saving Tip  –  Tweet us at @anaplan and let us know!

Related Posts

Anaplan awarded best-in-class ‘Integrated Business... Anaplan, the Smart Business Platform™, received the CIO HONOUR® award for best-in-class “Integrated Business Planning Platform” as voted on by Singapore’s CIO c...
Anaplan App Hub: Your premier destination for plan... What if we told you that a place exists where high productivity and fast planning are fueled by data and unlimited apps that span all departments and industries...
Anaplan’s 2nd release of 2015: The best of both wo... Personal productivity tools, like Office® Excel, have their limitations. Take, for example, revenue forecasting for a typical products and services company. For...

Share this Story

Leave a Reply