4 / How To Populate The Time Analysis Spreadsheet

You will need two windows open at the same time to populate the Time Analysis Spreadsheet:

• The Time Analysis Spreadsheet you are editing (the new version created in step 1 of this process)

• The Detailed Time Report you exported from Harvest (created in step 2 of this process)

1. In the Time Analysis Spreadsheet, select the tab/sheet for the month that you are invoicing for.

Note: If the month that you require is not visible, you will need to unhide it by hovering over the sheets at the bottom and right-clicking. Select Unhide, select the month from the options displayed, and then click on OK. It will now be displayed along the bottom with the other sheets. 

2. When you are in the sheet for the month you want to edit, select all data (Ctrl + A)

3. Right-click and select Clear Contents

4. Keeping all the data selected:

• On the Home tab, remove any highlighted fields by selecting No fill (see pic below)

• On the Home tab, remove any borders by selecting No borders (see pic below)

• On the Review tab, in the Comments section select Delete - this will delete all the pre-existing comments on this sheet (see pic below)

5. Select cell A1 in the Time Analysis Spreadsheet, ready to insert the data from the Detailed Time Report

6. Go to the Detailed Time Report (you should have this open in a separate window)

7. Select all data (Ctrl + A) and copy (Ctrl + C)

8. Return to the Time Analysis Spreadsheet and paste the data (Ctrl + V) into cell A1

The Time Analysis Spreadsheet should look something like this after you have pasted the data from the Detailed Time Report:

9. Close the detailed time report and return to the Time Analysis Spreadsheet to continue editing

10. Scroll to the bottom of the pasted data in the month you are currently editing - this is where you will insert the template data 

11. Select the Templates tab/sheet and select cell A18

12. Scroll down and across to cell BK270 - do not click on it yet

13. Hold down Shift and click on cell BK270 - this will highlight all the cells in between

14. Copy the highlight data (Ctrl + C) and return to the sheet for the month that you are editing

15. Select the first empty cell in column A (at the bottom of the previously pasted data) and paste the template data (Ctrl + V)

The Time Analysis Spreadsheet should look something like this after you have pasted the data from the template tab/sheet: