...
Once a scenario is completed and approved, a scenario can be "promoted" to the proposed amounts on the budget and revenue accounts.
Create a Scenario
- From the menu, select 'Budgeting' and click on 'Scenarios'. This will display the existing scenarios on the grid.
- To create a scenario, click on
- Enter a name for the scenario.
- Enter a description of the scenario.
- NOTE: There is no limit to the number of characters, numbers or spaces you want to use in the name.
- NOTE: There is no limit to the number of characters, numbers or spaces you want to use in the name.
- At this point, you can either save the scenario by clicking on and create budgeting spreadsheets at a later time; or continue on by creating budgeting spreadsheets for this scenario using the option.
...
4. The new budgeting sheet will be displayed under the Budgeting Sheets table. Click on to save the changes made to the scenario.
Download Scenario Spreadsheets to Excel
- Click on to view the scenario.
- Click on to download a specific spreadsheet in the scenario to your computer. Save the spreaadsheet and open it in EXCEL.
- Enter in your proposed amounts. For this example, the NYP-2018 is used to enter next year proposed amounts for FY2018. You can enter each NYP amount manually or, in my example below, use a calculated formula (highlighted in yellow), to mass-calculate a percentage.
- Once completed, save the change to the Excel spreadsheet.
Upload and Replace a Scenario spreadsheet
- Click on to edit the Scenario you want to upload the spreadsheet into.
- Click on to upload and replace the existing budgeting spreadsheet. A confirmation box is displayed stating it will overwrite the existing spreaadsheet.
- A 'Budgeting Scenario' box will then be displayed. Click on to upload the saved spreadsheet on your computer.
- Next, click on . The existing budgeting sheet has now been updated.
- Click on to save the changes to your scenario.
Promote a Scenario
- Click on to promote all spreadsheets in the scenario to proposed amounts. Once the amounts have been promoted, they will be available to view under the Proposed Amounts option under Budgeting.
View a Scenario
- Click on to view the scenario.
- If you would like to download an existing budgeting sheet in order to edit it in EXCEL, click on the Download icon .
3. Once the spreaadsheet has been saved, open it in EXCEL and enter your proposed amounts.
Edit a Scenario
...
- import budgeting sheets
- download budgeting sheets
- Depending on your browser's settings, save or open the extracted data. (Most will default to open in EXCEL).
- Enter the proposed amounts and save the spreadsheet
- delete budgeting sheets
...
Delete a Scenario
- Search desired scenario to delete.
- Click on to delete the scenario. Click on 'delete' to confirm deletion.
...