Page Comparison

The Available in budget and forecast workbooks, the Manual Entry driver tab is sometimes referred to as the “miscellaneous driver”. You might want to add this driver if you have assumptions that miscellaneous driver. It is useful for managing key reference data common to different parts of your budget or forecast that you want to use for assumptions. As these assumptions typically change at various times during the budget or forecast period, but it is easier to have them in a separate tab, so you don’t want to have to drill down into your main worksheet Main tab to find where you have referenced them; you simply want to have this information at hand, in one central location (worksheet tab).Depending on how you prefer to work, you can add multiple Manual Entry driver tabs, one for each assumption, or put all your assumptions on one Manual Entry driver tab..

Enter data and use it in formulas to drive budget or forecast values, then when you adjust the data, your changes will flow through to all the driven values. As you progress in the budgeting process and firm up your assumptions, you can adjust that data accordingly, and use the updated data when you switch to forecasting mode.

For example, if your vehicle quantity and related costs are likely to fluctuate over the year, you can add a Manual Entry driver tab to drive the Repairs and Maintenance account on your Main tab. As Enter the number of vehicles and the maintenance costs per month, then adjust that data as the number of vehicles and the cost of maintenance and repairs changes change over the year, you make the adjustments in the Manual Entry driver tab and the . The driven values in the Maintab will update be updated accordingly.

TipIf there is already a Manual Entry driver tab in the workbook, you might prefer to clone that tab rather than follow the steps below to add a new one from scratch
Depending on how you prefer to work, you can add multiple Manual Entry tabs, one for each assumption, or put all your assumptions on one tab.
Tip
Do you need to add a new Manual Entry tab? If there’s already one in the workbook, save time by adding additional rows in that tab or cloning that tab and editing its setup.
Click the Add button next to the Main tab.
Image Removed
Enter , then enter a name for the tab, select the Manual Entry tab type, then and click Add.
Image RemovedImage Added
In the new tab, enter the driver data. Click Add New Row to add additional rows. In this example, you add one row for the number of vehicles and another row for the maintenance cost per vehicle.:
Image RemovedImage Added
Use the driver data in formulas on other tabs to drive budget values. In this example, you enter a formula in the Repairs & Maintenance account row in the Main tab that refers to the data in the new driver tab.
Image Removed