Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
items:item_basics:tab_usage [2025/02/05 14:58] – [Projections] Gary Willettsitems:item_basics:tab_usage [2025/02/05 15:15] (current) – [Projections] Gary Willetts
Line 62: Line 62:
   * **Modifying an existing projection:** You can use the **Modify selected cell** button to increase or decrease a column or some cells in a column by a certain percentage. For example, you might have entered values for 2025, and then decide your 2026 values should be the 2025 values plus 8%. To do this:   * **Modifying an existing projection:** You can use the **Modify selected cell** button to increase or decrease a column or some cells in a column by a certain percentage. For example, you might have entered values for 2025, and then decide your 2026 values should be the 2025 values plus 8%. To do this:
     * Fill in your 2025 column values     * Fill in your 2025 column values
-    * Add a column for 2026 if one doesn't already exist+    * Add a column for 2026 if one doesn't already exist (click on the **Add year button**)
     * Use the **Copy values** button to copy 2025 to 2026     * Use the **Copy values** button to copy 2025 to 2026
-    * Drag to highlight all rows in the 2026 column+    * Click on the top row of the Shift click the bottom row to highlight all rows in the 2026 column
     * Enter ''8'' in the percentage field, then click on the **Modify selected cell** button to increase the 2026 values by 8%.     * Enter ''8'' in the percentage field, then click on the **Modify selected cell** button to increase the 2026 values by 8%.
 +
 +**Good things to remember when you're using projections:**
 +  - Use the **Add year** button to add another year (for both projection A and projection B).
 +  - Click the **Save projection** button when you want to save any projections (they will all be saved when you click this button). IF YOU DON'T CLICK THIS BUTTON YOUR PROJECTION WILL NOT BE SAVED! There is no auto-save of projections when you leave this window. So, if you want to undo any projection changes leave this window without clicking on the **Save projection** button.
 +  - If you have added extra years, they will not be shown when you first open the Projections window. Just click on the **Add year** button to show the years you want to see.
 +  - If you want to go back to the usage view click on the **Hide Projection** button.
  
 <WRAP center round alert 60%> <WRAP center round alert 60%>
  • Last modified: 2025/02/05 14:58
  • by Gary Willetts