78 Plan Regions

From KiwiCodes-wiki
Jump to: navigation, search


Welcome to this demonstration on Bonus Tools – 78 Plan Regions. This tool allows you to bulk copy Plan Regions between Views.

  1. To run the tool, navigate to the Bonus Tools Tab and select Plan Regions.
  2. Sheet and View Manipulation

    78 Plan Regions 00

  3. The Plan Regions dialog will appear.
  4. 78 Plan Regions 00

    Note: The dialog when opened will display all the saved From and To View maps within the grid; at the bottom right is the total count in the grid. Within grid you can see the From View, To View and Select.

  5. Click Add to add a Row.
  6. You add Rows and map between From Views and To Views.


    From View To View

  7. Select a From View.
  8. 78 Plan Regions 00

    Note: Only Views with Plan Regions are visible.

  9. Select a To View.
  10. 78 Plan Regions 00

  11. Add as many Rows as you want.
  12. 78 Plan Regions 00

  13. You select the Rows and click the Delete Selected or Updated Selected button.
    1. To select the Rows you can either; tick the check boxes individually or highlight the rows using standard mouse drag and control key operations and click Select Selected button.
    2. Note: the Total selected is updating.

    3. or click Select All button to select all Rows in the grid.
    4. or click Select None button to deselect all Rows.
  14. Click Update Selected.
  15. 78 Plan Regions 00

  16. Two dialogs will appear, one with the overall results and another with a break-down.
  17. 78 Plan Regions 00

    Note: If a View already contains Plan Regions, they will be deleted to make way for the new/updated Plan Regions.

  18. Plan Regions also allow you to Export the Grid to a CSV file to bulk add Rows, then Import from Excel to load the Rows into the Grid.
  19. Export to Excel

    Import from Excel

Thank you for viewing this demonstration on Bonus Tools - Plan Regions.