Versions Compared

Key

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

...

  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.
    Click on Image Removed to
      1. Image Added
  3. At this point, you can either save the scenario by clicking on Image Added and create budgeting spreadsheets at a later time; or continue on by creating budgeting spreadsheets for this scenario using the Image Added option.

Creating spreadsheets for a Scenario

When editing a scenario, click on Image Added at the bottom of the screen to create a budgeting sheet

...

for the scenario.

  1. Enter Select the Type 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.  Click   
    Image Added

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

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

...

  1. Image Added



4. The new budgeting sheet will be displayed under the Budgeting Sheets table.  Click on  to add the scenario to the grid, click on CANCEL to not post the scenario and return to the grid.Image Removed to save the changes made to the scenario.

Image Added

Download Scenario Spreadsheets to Excel

  1. Click on Image Added to view the scenario.
  2. Click on   Image Added 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.  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.  
  4. Once completed, save the change to the Excel spreadsheet.

    Image Added  

Upload and Replace a Scenario spreadsheet

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

  3. A 'Budgeting Scenario' box will then be displayed.  Click on Image Added to upload the saved spreadsheet on your computer.

    Image Added
  4.  Next, click on Image Added.  The existing budgeting sheet has now been updated.
  5. Click on Image Addedto save the changes to your scenario.

Promote a Scenario

  1. Click on Image Added 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.

Image Added

View a Scenario

  1. Click on  to view the scenario.
  2. If you would like to download a an existing budgeting sheet in order to edit it via in EXCEL,  click on on the Download icon  .

...

  1.   

Image Added

3. Once the spreaadsheet has been saved, open it in EXCEL and enter your proposed amounts.

Edit a Scenario

  1. Click on  to edit the scenario in order to

    1. import budgeting sheets 
    2. download budgeting sheets
      1. Depending on your browser's settings, save or open the extracted data.  (Most will default to open in EXCEL).
      2. Enter the proposed amounts and save the spreadsheet
    3. delete budgeting sheets
Info



Delete a Scenario

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

Promote a Scenario

  1. Click on Image Removed to promote all spreadsheets in the scenario to a proposed amounts.  Once the amounts have been promoted, they will be available to view under the Proposed Amounts option under Budgeting.
  2. Image Removed