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

# | Date Requested | Job Reference | PUES Job Reference | AMP Contact | Notes | Cost Raised | Cost Required | TB Comment
1 | 2021-05-06 00:00:00 | INDOSC2101225 | 11641 | JG | JG to raise Job to close out | $      500.00 | $         750.00 | Complete
2 | 2021-05-06 00:00:00 | INDOSC2101233 | n/a | PM/SS | [NAME] further info from AMP | $   1,000.00
3 | 2021-05-14 00:00:00 | INDOSC2101324 | 11676 | AL/PM | Column Glass Install - Request to Raise Invoice 7/6 as per Quote approved | $      900.00 | $     2,380.00
4 | 2021-05-22 00:00:00 | INDOSC2101394 | 11711 | SS | Quote 8490 - Carpark Repairs Scheduled 14/6 to commence. Works scheduled to be completed by 18/6 | $   3,514.37
5 | 2021-05-27 00:00:00 | INDOSC2101444 | 11722 | PM | DB 7.9 CB14 - Circuit Fault - Inspection to date.  Requires a Scissor lift to rectify faults.  Notes in PAC | $      500.00 | $         260.00 | Quote required for LED upgrade requested 16/6
6 | 2021-05-27 00:00:00 | INDOSC2101458 | 11700 | GN/SS | Quoted 18/5 - Dock Works - GN requested update 14/6.  Job to be scheduled | $   1,550.00 | 1390
7 |  | INDOSC2101470 | 11721 | PM | Job Closed Out - Awaiting AMP Approval | $      350.00
8 | 2021-05-31 00:00:00 | INDOSC2101503 | 11717 | PM/SS | Floorbox replacement - scheduled 14/6 | $   1,000.00 |  | complete
9 | 2021-06-01 00:00:00 | INDOSC2101536 | 11724 | SS | CMO T&T, Lighting, GPO, [NAME] Downlight Install to Occur and Costing Update.  To be closed out 18/6 | $   1,000.00 |  | notes indicate completion 25/6
10 | 2021-06-03 00:00:00 | INDOSC2101555 | 11742 | PM/SS | 15 x [NAME] update & Scheduling required - Scheduled. Awaiting Plans from AMP | 15000 |  | no update since 15/6
11 | 2021-06-04 00:00:00 | INDOSC2101572 | 11728 | JG/AL | Foundary Lighting not working - Cost Updated in PAC to $190.00 + GST for JG to approve | $              - | $         190.00
12 | 2021-06-04 00:00:00 | INDOSC2101576 | 11752 | JG | Tenancy Light 10/6 - Attended 15/6.  Completed - update Cost | $              - | $         165.00
13 | 2021-06-04 00:00:00 | INDOSC2101577 | 11731 | AL/PM | Exit/Signage Repair in carpark - 15/6 attended, reattend 16/6 for further fault finding | $   1,000.00 |  | no notes
14 | 2021-06-08 00:00:00 | INDOSC2101620 | 11761 | [NAME] | Compliance T&T - Received 11/6 - Scheduled 16/6 | $      900.00 |  | no notes since 15/6 was scheduled 16/6
15 | 2021-06-08 00:00:00 | INDOSC2101635 | 11751 | JG | CMO - Flickering Lightin in POD - Job Completed - Cost Raise to $495 required | $              - | $         495.00 | Replacement sensors ordered ETA
16 | 2021-06-10 00:00:00 | INDOSC2101667 | 11762 | GN/SS | Lord of the Wings Signage removal - Station Rd - received 11/6 - Job to be completed by 18/6 | $      600.00 |  | requested EWP 18/6
17 |  |  | 11695 | JG | King of Knives Signage Disconnection – JG to supply  PO or PAC number | $      190.00
18 | 2021-06-10 00:00:00 | INDOSC2101725 | 11739 | JG | Level 1 - Asian Shop - S&R - 7 x Shop [NAME] to finalise Costs and request from JG | $              -
19 |  | INDOSC2101255 | 11645 | AL/SS | Yes closed off at $190 | $      190.00 | $      190.00 | Archived
20 | 2021-06-17 00:00:00 | INDOSC2101737 | 11811 | JG | Assett capture - Lighting | 19872.5 |  | Meeting Thursday 1st July - updated
21 | 2021-06-16 00:00:00 | INDOSC2101726 |  | AL | BOH Light outside cleaners room | 0 |  | no notes - scheduled 24/6 - updated
22 | 2021-06-16 00:00:00 | INDOSC2101721 |  | SS | Replace hand dryer level 2 | 1000 |  | no notes - scheduled next week - updated
23 | 2021-06-10 00:00:00 | INDOSC2101658 |  | PM | Screen install in CMO | 1000 |  | No notes - scheduled 24/6 - updated
24 | 2021-06-10 00:00:00 | INDOSC2101667 |  | SS | Removal of lord of the wings sign | 600 |  | No notes since 18/6 - complete
25 | 2021-06-18 00:00:00 | INDOSC2101752 |  | PM | Level 1 Truck tunnel power fault | 1000 |  | No notes - complete
26 | 2021-06-18 00:00:00 | INDOSC2101751 |  | AL | Tripped circuit breaker level 5 staff carpark | 0 |  | No notes - next week - updated
27 | 2021-06-21 00:00:00 | INDOSC2101781 |  | AL | Lights behind fruit shop repair | 600 |  | Complete - requested PAC raise $785.00
28 | 2021-06-21 00:00:00 | INDOSC2101780 | 11808 | JG | Lantos place LED strip lighting | 0 |  | Complete - requested PAC raise $1,1100
29 | 2021-06-21 00:00:00 | INDOSC2101785 |  | JG | STX139B - Storeroom power | 415 |  | No notes - scheduled 1/7 - updated
30 | 2021-06-21 00:00:00 | INDOSC2101787 |  | JG | Replacment lighting - T2035 | 1770 |  | No notes - scheduled 1/7 (estimated)