Spreadsheet: 878267d1725341692-weekly-updating-excel-from-new-data-dump-week-ahead-schedule-testing_basic-data
Sheet: Current Works

Job Num | Job Name | Status | Customer | Site | Project Mgr | Tech | 2024-09-09 00:00:00 |  |  | Est. Hrs |  |  |  | Works / Notes |  | Job No. | Job Name | Status | Customer | Site | Project Manager | Est. Hours | Actual Hours | Scheduled | Scheduling Issues
 |  |  |  |  |  |  | 4 | 4 | 4 |  |  |  |  | ON GOING |  | 1. Change date at H1, to next Monday's date (note the date will update I1, J1, L1, M1, N1, C133, H133, C150, H150, C167, H167
 |  |  |  |  |  |  | 8 | 8 | 8 |  |  |  |  | ON GOING |  | 2. Move hours in I and J to H and I (shifting the hours with the date change
 |  |  |  |  |  |  | 4 | 4 | 4 |  |  |  |  | ON GOING |  | 3. Move hours in M and N to L and M (shifting hours with the date change
 |  |  |  |  |  |  | 16 | 16 | 16 |  |  |  |  | ON GOING |  | 4. Clear descriptions next to Technicians in all weeks (at bottom of job list)
 |  |  |  |  |  |  | 8 | 8 | 8 |  |  |  |  | ON GOING
 |  |  |  |  |  |  | 8 | 8 | 8 |  |  |  |  | ON GOING |  | 6. Export the Pending and Progress list from simpro, past corresponding data into columns on Service Data tab; which will populate the XLOOKUPs in Q to U columns
 |  |  |  |  |  |  | 8 | 8 | 8 |  |  |  |  | ON GOING |  | 7. Add new jobs to bottom of the job list in Current Works and sort by Project Manager, then site, then customer, then Job number
 |  |  |  |  |  |  | 0 | 76 | 0
18377 | [NAME] | Job: Scheduled | Customer14 | Site47 | [NAME] |  | 0 | 0
18139 | Job Name14 | Preventative Maintenance | Customer14 | Site14 | [NAME] |  | 0 | 0 |  | 31.9 | 0 | 0 | 0
18216 | Job Name22 | Job: Scheduled | Customer22 | Site22 | [NAME] |  | 0 | 0
18217 | Job Name23 | Job: Scheduled | Customer23 | Site23 | [NAME] |  | 0 | 0
18218 | Job Name24 | Job: Scheduled | Customer24 | Site24 | Proj Mgr3 |  | 0 | 0
18413 | Job Name61 | Job: End of Day - Check notes, change status | Customer28 | Site12 | [NAME] |  |  |  |  | 8
Q11117 | NOT FOUND | NOT FOUND | NOT FOUND | NOT FOUND
18412 | Job Name60 | Job: Scheduled | Customer27 | Site11 | [NAME] |  |  |  |  | 5
16743 | Job Name1 | Job: To Be Scheduled - Days | Customer1 | Site1 | [NAME] |  | 0 | 0 |  | 125.53
18031 | Job Name6 | Job: Awaiting Parts | Customer6 | Site6 | Proj Mgr3 |  | 0 | 0 |  | 38.08 | 40 | 0 | 0
18035 | Job Name7 | Job: Awaiting Client Instruction | Customer7 | Site7 | [NAME] |  | 0 | 0 |  | 10
18140 | Job Name15 | Preventative Maintenance | Customer15 | Site15 | Proj Mgr3 |  | 0 | 0 |  | 123.14 | 0 | 0 | 0
18259 | Job Name35 | Job: Awaiting Parts | Customer2 | Site35 | [NAME] |  | 0 | 0 |  | 48.92 | 0 | 49 | 0
18278 | Job Name36 | Job: To Be Scheduled - Days | Customer3 | Site36 | Proj Mgr3 |  | 0 | 0 |  | 9
18340 | Job Name38 | Job: Awaiting Parts | Customer5 | Site38 | [NAME] |  | 0 | 0
18386 | Job Name51 | Job: Awaiting Client Instruction | Customer18 | Site2 | Proj Mgr3 |  | 0 | 0
17999 | Job Name5 | Job: Awaiting Client Instruction | Customer5 | Site5 | [NAME] |  | 0 | 0 |  | 39.2
18427 | Job [NAME] | Job: Scheduled | Customer1 | Site18 | [NAME] |  |  |  |  | 16
18141 | Job Name16 | Preventative Maintenance | Customer16 | [NAME] | [NAME] |  | 0 | 0 |  | 98.73 | 0 | 0 | 0
18219 | Job Name25 | Job: Scheduled | Customer25 | Site25 | [NAME] |  | 0 | 0
18220 | Job Name26 | Job: Scheduled | Customer26 | Site26 | [NAME] |  | 0 | 0
18221 | Job Name27 | Job: Scheduled | Customer27 | Site27 | Proj Mgr3 |  | 0 | 0
18135 | Job Name11 | Job: Awaiting Client Instruction | Customer11 | Site11 | [NAME] |  | 0 | 0 |  | 126
18138 | Job Name13 | Preventative Maintenance | Customer13 | Site13 | [NAME] |  | 0 | 0 |  | 124.17
18202 | Job Name19 | Job: Complete - SMgr to review | Customer19 | Site19 | [NAME] |  | 0 | 0 |  | 8.25
18213 | Job Name20 | Job: Awaiting Client Instruction | Customer20 | Site20 | [NAME] |  | 0 | 0 |  | 10.5
18214 | Job Name21 | Job: Awaiting Parts | Customer21 | Site21 | Proj Mgr3 |  | 0 | 0
18222 | [NAME] | Job: Scheduled | Customer28 | Site28 | [NAME] |  | 0 | 0
18223 | Job Name29 | Job: Scheduled | Customer29 | Site29 | [NAME] |  | 0 | 0
18224 | Job Name30 | Job: Scheduled | Customer30 | Site30 | Proj Mgr3 |  | 0 | 0
18227 | Job Name32 | Preventative Maintenance | Customer32 | Site32 | [NAME] |  | 0 | 0 |  | 165.83
18233 | Job Name33 | Job: Scheduled | Customer33 | Site33 | Proj Mgr3 |  | 0 | 0 |  | 4
18398 | Job Name54 | Job: Scheduled | Customer21 | Site5 | [NAME] |  | 0 | 0 |  | 2.75
18422 | Job Name64 | Job: Complete - SMgr to review | Customer31 | Site15 | [NAME] |  |  |  |  | 6
18423 | Job Name65 | Job: Complete - Inv notes to be written up | Customer32 | [NAME] | Proj Mgr3 |  |  |  |  | 3.25
18143 | Job Name18 | Preventative Maintenance | Customer18 | Site18 | Proj Mgr3 |  | 0 | 0 |  | 35.7
18142 | Job Name17 | Preventative Maintenance | Customer17 | Site17 | [NAME] |  | 0 | 0 |  | 49.53
18406 | Job Name58 | Job: Tech Travelling | Customer25 | Site9 | [NAME] |  | 0 | 0 |  | 16
18365 | Job Name41 | Job: Materials to Be Ordered | Customer8 | Site41 | [NAME] |  | 0 | 0 |  | 16
18374 | Job Name46 | Job: Scheduled | Customer13 | Site46 | [NAME] |  | 4 | 4
Petbarn | NOT FOUND | NOT FOUND | NOT FOUND | NOT FOUND |  |  | 0 | 0
18283 | Job Name37 | Job: Complete - SMgr to review | Customer4 | Site37 | [NAME] |  | 0 |  |  | 3
18367 | Job Name42 | Job: Materials to Be Ordered | Customer9 | Site42 | Proj Mgr3 |  | 0 |  |  | 37.13
18137 | Job Name12 | JOB ON HOLD | Customer12 | Site12 | Proj Mgr3 |  | 0 |  |  | 68.75
18369 | Job Name43 | Job: Tech On Site | Customer10 | Site43 | [NAME] |  | 0 |  |  | 163.97
17731 | Job Name3 | Job: Scheduled | Customer3 | Site3 | Proj Mgr3 |  | 0 |  |  | 111
18416 | Job Name62 | Job: Complete - SMgr to review | Customer29 | Site13 | Proj Mgr3 |  |  |  |  | 1.5
18123 | Job Name10 | JOB ON HOLD | Customer10 | Site10 | [NAME] |  | 0 |  |  | 32.5
17561 | Job Name2 | Office work required | Customer2 | Site2 | [NAME] |  | 0 |  |  | 80
17927 | Job Name4 | Job: Tech Travelling | Customer4 | [NAME] | [NAME] |  | 0 |  |  | 3
18380 | Job Name49 | Job: Materials to Be Ordered | Customer16 | Site49 | [NAME] |  | 0 |  |  | 6
18432 | Job Name69 | Job: End of Day - Check notes, change status | Customer3 | Site20 | [NAME] |  |  |  |  | 4
18437 | Job Name72 | Job: Scheduled | Customer6 | Site23 | [NAME] |  |  |  |  | 0
Gen Test | NOT FOUND | NOT FOUND | NOT FOUND | NOT FOUND |  |  | 0 |  |  | 4
18091 | Job Name9 | Preventative Maintenance | Customer9 | Site9 | Proj Mgr3 |  | 0 |  |  | 1325.84 | 0 | 0 | 0
18247 | Job Name34 | Job: To Be Scheduled - Days | Customer1 | Site34 | [NAME] |  | 0
18348 | Job Name39 | Job: End of Day - Check notes, change status | Customer6 | Site39 | Proj Mgr3 |  | 0
18372 | Job Name45 | Job: Materials to Be Ordered | Customer12 | Site45 | Proj Mgr3 |  | 0
18379 | Job Name48 | Job: Complete - SMgr to review | Customer15 | Site48 | Proj Mgr3 |  | 0
18391 | Job Name52 | JOB ON HOLD | Customer19 | Site3 | [NAME] |  | 0 |  |  | 24
18393 | Job Name53 | JOB ON HOLD | Customer20 | [NAME] | [NAME] |  | 0
18409 | Job Name59 | Job: Scheduled | Customer26 | Site10 | Proj Mgr3 |  | 0
18426 | Job Name66 | Job: Materials to Be Ordered | Customer33 | Site17 | [NAME] |  |  |  |  | 4
18429 | Job Name68 | Job: To Be Scheduled - Days | Customer2 | Site19 | Proj Mgr3 |  |  |  |  | 0
18435 | Job Name70 | Job: End of Day - Check notes, change status | Customer4 | Site21 | [NAME] |  |  |  |  | 12
18438 | Job [NAME] | Job: To Be Scheduled - Days | Customer7 | Site24 | Proj Mgr3 |  |  |  |  | 12
Q10990? | NOT FOUND | NOT FOUND | NOT FOUND | NOT FOUND |  |  | 8
18370 | Job Name44 | Job: Awaiting Info from Tech | Customer11 | Site44 | [NAME] |  | 0 |  |  | 3.75
18404 | Job Name56 | Job: Tech On Site | Customer23 | Site7 | Proj Mgr3 |  | 38 | 38
18405 | Job Name57 | Job: Complete - SMgr to review | Customer24 | Site8 | [NAME] |  | 0
18401 | Job Name55 | Job: Scheduled | Customer22 | Site6 | [NAME] |  | 0
18420 | Job Name63 | Job: Complete - SMgr to review | Customer30 | Site14 | [NAME]
18436 | Job Name71 | Job: To Be Scheduled - Days | Customer5 | Site22 | [NAME] |  |  |  |  | 719.25
18352 | Job Name40 | Job: Scheduled | Customer7 | Site40 | [NAME] |  | 0 | 38 |  | 40