Converting the Budget Workbook into a Forecast Workbook
Click this link to view training video: https://mckibbonhotels.sharepoint.com/hotel_properties/help/SiteAssets/Videos/Convert%20Budget%20to%20Forecast.mp4
UPDATE FOR 2024
In the video, it references running an Actual/Budget/Forecast....please note that the DEFAULT ABF has been renamed to *MH ACT/BUD/FCT USALI V.11
Please use this format for your ABF-Fct, ABF-Bud, ABF-PY, and related Acck Dump tabs
Additionally, if this is the first forecast of the new calendar year.....
Paste the Budget ABF into BOTH the Acck ABF-Bud as well as the Acck ABF-Fct tabs to update the year the workbook is seeking. This will prevent your HPR tab from showing the "N/A" errors as the formula is not seeing any dates in the Acck ABF-Fct tab.
Related Articles
Updating the Budget/Forecast Workbook Addin Module
To update the Addin required to run the Bud/Fct workbook, please follow the instructions below.... YOU MUST HAVE ACCESS TO McKibbon Sharepoint. If you do NOT have access please contact the Support Team First, go get the updated BudFctAddin file from ...MS Excel Handling Circular References
You've entered a formula, but it’s not working. Instead, you’ve got this message about a “circular reference.” Millions of people have the same problem and it happens because your formula is trying to calculate itself. Here's what it looks like: The ...How To Enable Macros in Excel
Please read this article on how to enable macros on Excel spreadsheets: How to Enable Macros in Microsoft Excel: 7 Steps (with Pictures) (wikihow.com) If you are interested in learning more on this subject, please read this ...Mapping your Budget into your Daily Report Module
Click this link to view training video: Mapping your Budget into your Daily Report ModuleInstalling the BudFctAddin for Workbook
Click this link to view training video: https://mckibbonhotels.sharepoint.com/hotel_properties/help/SiteAssets/Videos/Installing%20the%20BudFctAddin.mp4