Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

The Budgeting module may can store multiple scenarios.  Generally, though generally, a single scenario will be sufficient.  However, special circumstances may require multiple scenarios based on different assumptions.  For example, you may wish to create a scenario for "Assuming Levy Passes" and another "Assuming Levy Fails".   

...

Note

Please note that once a scenario is promoted, any successive scenario that is promoted will overwrite a prior scenario's amounts. For example, you create a scenario for HS budget amounts and promote it. You then promote another scenario containing Elementary Budget amounts. The HS budget amounts will be removed and the elementary budget amounts will be uploaded. So instead of creating separate scenarios, we recommend creating separate worksheets within the same scenario.


Create a Scenario

  1. From the menu, select 'Budgeting' and click on 'Scenarios'. This will display the existing scenarios on the grid.  
  2. To create a scenario, click on
    1. Enter a name for the scenario.  
    2. Enter a description of the scenario.
      1. NOTE: There is no limit to the number of characters, numbers or spaces you want to use in the name.
        Image RemovedImage Added
  3. 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.

...

  1. Select the type of Budgeting Sheet: Budget or Anticipated Revenue.
  2. A predefined set of properties are displayed.  From there, you can add or remove the properties you would like included on the spreadsheet.  
    Image RemovedImage Added

  3. Click on 'Configure Filters' tab if you would like to filter data being extracted.
      Image RemovedImage Added

  4. To save the spreadsheet, enter a name under 'Sheet Name'.  Click on to save your budgeting sheet to the scenario.  A 'Confirm Sheet Creation' box will appear.  Click on  to add the new spreadsheet to your existing scenario.
    Image RemovedImage Added



4. The new budgeting sheet will be displayed under the Budgeting Sheets table.  Click on  to save the changes made to the scenario.

Image RemovedImage Added

Download Scenario Spreadsheets to Excel

  1. Click on  to view the scenario.
  2. Click on    to download a specific spreadsheet in the scenario to your computer. Save the spreaadsheet and open it in EXCEL.
  3. Enter in your proposed amounts. The spreadsheet will provide a column for your proposed amounts. 'PA-YYYY'.  Proposed amounts can be ‘next year’ amounts or ‘current year’ amounts depending on the fiscal year usedFor this example, the NYP-2018 For example, if my current FY is 2019:
    1. My Next Year Proposed Amounts column header needs to be PA-2020
    2. My Current Year Proposed Amounts: column header needs to be PA-2019
    3. For the example below, the PA-2019 is used to enter
    next year
    1. proposed amounts for
    FY2018
    1. FY2019. You can enter each
    NYP
    1. amount manually or, in my example below, use a calculated formula (highlighted in yellow), to mass-calculate a percentage.  
  4. Once completed, save the change to the Excel spreadsheet.
    Image Removed
    Image Added  

Upload and Replace a Scenario spreadsheet

  1. Click on  to edit the Scenario you want to upload the spreadsheet into.
  2. Click on to upload and replace the existing budgeting spreadsheet. A confirmation box is displayed stating it will overwrite the existing spreaadsheetspreadsheet.
    Image RemovedImage RemovedImage Added

  3. A 'Budgeting Scenario' box will then be displayed.  Click on  to upload the saved spreadsheet on your computer.
    Image Removed
    Image Added
  4.  Next, click on .  The existing budgeting sheet has now been updated.
  5. Click on to save the changes to your scenario.

...

  1. Click on  to promote all spreadsheets in the scenario to proposed amounts.   A 'Confirm Promote' box will appear warning that if any existing proposed amounts exist, they will be replaced with the new figures. Click on .

    Image RemovedImage RemovedImage Added

    Image Added

  2. Once the amounts have been promoted, they will be available to view under the Proposed Amounts option under Budgeting.  Click on Proposed Amounts for more information about the 'Proposed Amounts' option under the Budgeting menu.

...

  1. Image Added

Delete a Scenario

  1. Search desired scenario to delete.
  2. Click on  to delete the scenario.  Click on 'delete' to confirm deletion.

...