items:item_basics:tab_usage

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:55] – Gary Willettsitems:item_basics:tab_usage [2025/02/05 15:15] (current) – [Projections] Gary Willetts
Line 53: Line 53:
 You can enter projections in a number of ways: You can enter projections in a number of ways:
  
-  * **Manually entering projections:** Click //once// on a cell that contains a projection (rather than a cell containing historical data) to select it then click on it once again to edit the cell's value. Don't double-click: you need to click once, wait for a second, then click again. Repeat for each cell you want to enter a value in.+  * **Manually entering projections:** Click //once// on a cell that contains a projection (these are cells in the columns with a blue rather than grey background) and edit the cell's value. Don't double-click!
  
 <WRAP center round tip 60%> <WRAP center round tip 60%>
-Press the //Tab// key on the keyboard to move from editing once cell to immediately editing another without having to click twice.+Press the //Tab// key on the keyboard to move from editing once cell to immediately editing another without having to click again.
 </WRAP> </WRAP>
  
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:55
  • by Gary Willetts