Spreadsheet: 878334d1725412226-weekly-updating-excel-from-new-data-dump-week-ahead-schedule-testing_basic-data
Sheet: Current Projects

 | 2 WEEK ACTION PLAN
 | PUES Labour | 8
 | [NAME] | 0
 | DAY WORKS
 | 26th to 30th of August
 | MYER |  | 9458 |  | 149C tenancy, DB install |  |  |  |  | 10
 |  |  | 9465 |  | Jabiru | [NAME] | 80
 | Gas Works |  | 9544 |  | New D/L | Sean | 1 |  |  |  | Waiting on materials
 | Gas Works |  | 9531 |  | New D/L | Sean | 1 |  |  |  | Waiting on materials
 | [NAME] |  | 9563 |  | Energex Meeting | Sean | 1.5 |  |  |  | Is Sean the best person for this?
 | [NAME] |  | 9560 |  | Myer Audit | Sean | 2.5 |  |  |  | Do we want to fine tune/audit sheet of paper
 | ISC |  | 9572 |  | Test & Tag | Windy | 3 |  |  |  | Monday or Wednesday
 | ISC |  |  |  | [NAME] One | Windy |  |  |  | 10 | Looks like we will need to attend on Wed & Fri
 | [NAME] |  |  |  | Oxley Swim Club | Windy |  |  |  | 4 | Need to complete quote, and get rest of the works approved
 | ISC |  | 9513 |  | Sewer & Storm Water Pumps |  |  |  |  | 0 | [NAME] to advise
 | ISC |  | 9514 |  | Lvl 1 Water Meters |  |  |  |  | 0
 | [NAME]
 | MYER |  | 9470 |  | SB Labelling |  |  |  |  | 0
 | [NAME] |  |  |  | Phone patching | [NAME] |  |  |  | 0 | Likely to be next week now [NAME] on night shift
 | Carindale |  |  |  | Phone patching | [NAME] |  |  |  | 0 | Likely to be next week now [NAME] on night shift
 | ANGUS & COOTE |  |  |  | Barretts - Elec Works | Sean | 16
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 112
 | 26th  to 30th of August
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | MYER |  |  |  | ENERGEX WORKS | Windy? | 8 |  |  |  | To be completed 26th/27th I believe at the start on the night shift
 | [NAME] |  |  |  | Prime Signs |  |  |  |  | 4 | Disconnecting power
 | QP |  | 9379 |  | [NAME] 1B Awning |  | 8 |  |  |  | NIGHT WORKS
 | QP |  | 9550 |  | Cage Power |  |  |  |  |  | Replace the breaker? Do we need to advise someone of shutdown
 | Warner |  | 9574 |  | Warner |  |  |  |  | 8 | Do take off and enter in pricigns & check and stock
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 40
 | DAY WORKS
 | 2nd to 6th September
 | Musk & Mulberry |  | 9457 |  | Replace contactor | Windy | 1 |  |  |  | Waiting on part
 | Box & Co Milton |  | 9587 |  | Reinstall power & data & RCD | Windy | 2 |  |  |  | Waiting on client to advise
 | Jabiru |  | 9465 |  | Project Works | [NAME] | 40
 | Angus & Coote Springfield |  | 9521 |  | Finish fitoff | Sean or [NAME] | 24 |  |  |  | Might only need 1 day, but plenty of hours still on the job
 | ISC |  |  |  | [NAME] One | Windy |  |  |  | 10 | Need to reattend
 | ISC |  |  |  | [NAME] |  |  |  |  | 0 | Do we need to go back?
 | ISC |  |  |  | Voip | [NAME] | 4
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 120
 | 2nd to 6th September
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | Warner |  | 9574 |  | RCD Upgrade |  | 16 |  |  |  | Next nightshift works. Will need to provide isolation notices
 | ISC |  |  |  | Car Park Works |  | 20
 | ISC |  |  |  | Barbers/Water |  | 18
 | [NAME] One
 | ISC |  |  |  | [NAME] GPO |  | 2
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 0
 | DAY WORKS
 | 9nd to 13th September
 | ISC |  | 9602 |  | Floor box replacement |  | 2
 | Gas Works |  | 9609 |  | [NAME] |  | 2
 | Gas Works |  | 9598 |  | [NAME] |  | 1
 | T3003 |  | 9599 |  |  | Windy | 20
 | Allgon |  | 9520/ 9407 |  | Elec Upgrade |  |  |  |  | 8
 | Gas Works |  | 9604 |  | Lights |  | 1 |  |  |  | Needs to be booked in early - same time as 9598
 | Loreal Academy West End |  | 9548 |  | Data Rack | Dale/Fadden | 18 |  |  |  | Need to order Data Rack
 | Jabiru |  | 9468 |  | Jabiru | [NAME] | 80 |  |  |  | Continue on with project works
 | ISC |  | 9625 |  | Dock 8 Lights | Dale
 | QP |  | 9622 |  | [NAME] | Dale |  |  |  | 3 | Booked for Tuesday
 | Gas Works |  | 9620 |  | Light repairs | Dale | 1
 | Gas Works |  | 9624 |  | Light repairs | Dale | 1
 | DJ1 |  | 9556 |  | Phone Patch | [NAME] | 1.5 |  |  |  | Booked for Friday 13/9
 | ISC |  | 9593 |  | [NAME] |  | 1 |  |  |  | Do we need to walk them through on site?
 | Buranda |  |  |  | EM Testing |  |  |  |  |  | BURAP:191
 | [NAME] |  | 9577 |  | [NAME] |  | 1.5
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 160
 | 9nd to 13th September
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | Warner |  | 9574 |  | RCD Upgrade |  |  |  |  |  | Next nightshift works. Will need to provide isolation notices
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 0
 | DAY WORKS
 | 16th to 20th September
 | HS Brothers [NAME] |  |  |  | Phone Patching |  |  |  |  |  | Waiting on payment
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 160
 | 16th to 20th September
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | Warner |  |  |  | RCD Upgrade |  | 16 |  |  |  | Next nightshift works. Will need to provide isolation notices
 | Buranda |  |  |  | [NAME] |  | 23 |  |  |  | 16th September
 | Buranda |  |  |  | [NAME] |  |  |  |  |  | ChemPro said they were going to email us
 | [NAME] |  |  |  | Awning Install |  | 16
 | ISC |  |  |  | Light Repairs |  | 20
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 80
 | DAY WORKS
 | 30th of Sep to 4th of Oct
 | Jabiru |  | 9465 |  | Project Works | [NAME] | 80 |  |  |  | Already scheduled, might need more techs
 | ISC |  | 9612 |  | Rork Projects - Barbers | jason | 2 |  |  |  | Unsure on date yet
 | ISC |  | 9590 |  | Plant Room Lights | Sean/Thai | 80
 | ISC |  | 9617 |  | Stair Well Lights | Sean/Thai | 8
 | Mt Ommaney |  | 9432 |  | Install BOH lights | [NAME] preferable | 4
 | [NAME] |  | 9504 |  | Power for signs | Windy | 2 |  |  |  | Dale would be best, is work a Vari?
 | [NAME] |  | 9682 |  | Compliance Inspection | Windy | 2
 | [NAME] |  | 9654 |  | Repair Sign/ Tombstone/ | Windy | 2 |  |  |  | [NAME] doing quote and email [NAME]
 | Gas Works |  | 9678 |  | Light Repair | Windy | 2
 | Gas Works |  | 9677 |  | Light Repair | Windy | 1
 | Gas Works |  | 9679 |  | Light Repair | Windy | 1
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 160
 | 30th of Sep to 4th of Oct
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | QP |  | 9379 |  | Install 1 xlight, 1 hours worth of work |  | 1 |  |  |  | Will be late next week. Likely a 5am job
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 0
 | 14th of October to 18th of October
 | ISC |  | [NAME] |  | Relamp exit sign | Dale | 1
 | ISC |  | [NAME] |  | Dock 10 New Lights | Dale | 5
 | ISC |  | J9684 |  | Test & Tag | Dale | 2
 | ISC |  | J9513 |  | Sewer & Storm Water Pump Control | Dale | 2.5
 | [NAME] |  | J9725 |  | [NAME] | Sean | 17
 | [NAME] |  | J9731 |  | Isolation of ATM |  | 3
 | [NAME] |  | [NAME] |  | Ex Sumo Salad |  | 32
 | [NAME] |  | [NAME] |  | Install of hand dryer |  |  |  |  | 2
 | ISC |  | [NAME] |  | Sports Girl Phone Patching | [NAME] | 2
 | ISC |  | [NAME] |  | Cleaners Lunch Room |  |  |  |  | 0
 | Mt Om |  | J9643 |  | Best & Less |  |  |  |  | 2
 | ISC |  | J9564 |  | [NAME] |  |  |  |  | 32
 | Jabiru |  | J9465 |  | Project Works | [NAME] | 80
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 200
 | 14th of October to 18th of October
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | ISC |  | J9732 |  | [NAME] |  |  |  |  | 20 | Don’t have PO limit yet. Waiting for [NAME] to confirm
 | ISC |  | J9724 |  | [NAME] |  |  |  |  | 20
 | [NAME] |  | J9725 |  | [NAME] |  | 4 |  |  |  | [NAME] installation
 | [NAME] |  | [NAME] |  | Ex Sumo Salad |  | 4 |  |  |  | [NAME] installation
 | [NAME] |  | J9731 |  | Removal of cabling. |  | 3
 | [NAME] |  | J9693 |  | Install 2 x lamps for green wall |  | 1
 | [NAME]
 | Gas Works |  | J9672 |  | RCD Upgrade |  | 40
 | Gas Works |  | J9679 |  | Relamp Light |  | 1
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 80
 | 21st of October to 25th of October
 | ISC |  | 9757 |  | ISC Back of house
 | ISC |  | 9754 |  | [NAME] tenancy |  | 6 |  |  |  | 70w lamps. Investigate
 | ISC |  | 9753 |  | DJ Sign |  | 3
 | ISC |  | 9752 |  | Hard Wire Control Box |  | 2 |  |  |  | Investigate and call [NAME] from site
 | ISC |  | 9718 |  | Lvl 3 cleaners lunch room - security |  | 5 |  |  | 0 | Anything we can prep for security company
 | ISC |  | 9716 |  | Lvl 3 - Plantroom 3.6 Refurbishment | [NAME] | 70 |  |  |  | [NAME]. Find out mechnicam complete and when we can attend site.
 | ISC |  | 9741 |  | RCD Upgrade |  |  |  |  | 0
 | ISC |  | 9740 |  | RCD upgrade - Audit, legend etc |  |  |  |  | 0
 | ISC |  | 9739 |  | RCD Upgrade - 688 Units |  |  |  |  | 0
 | Gas Works |  | 9738 |  | Metering Project |  |  |  |  | 0
 | Gas Works |  | 9701 |  | NHVR |  | 1.5 |  |  |  | Downlight - Replacement
 | Gas Works |  | 9755 |  | Fix timer/sensor |  | 1 |  |  |  | [NAME]
 | Buranda |  | 9756 |  | Car park Light |  | 2 |  |  |  | On hold
 | [NAME] |  | [NAME] |  | Install of hand dryer |  | 2 |  |  |  | Check parts will fit.
 | [NAME] |  | J9745 |  | [NAME] |  | 4 |  |  |  | Awaiting parts
 | ISC |  | J9564 |  | [NAME] |  |  |  |  | 0
 | GC - Barrets |  | TBA |  | Millionlife Gold Coast |  |  |  |  | 0
 | Jabiru |  | J9465 |  | Project Works |  | 80
 | Warner |  | [NAME] |  | Meters |  | 3
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 184
 | 21st of October to 25th of October
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | Cook Medical |  | 9746 |  | Install Power | [NAME] | 12 |  |  |  | Need to order materials
 | Formula Interiors |  | 9748 |  | Car Park Works | [NAME] | 16
 | ISC |  | 9742 |  | Barrets - Col Naylor |  | 4
 | ISC |  | 9716 |  | Isolation - Cleaners Lunchroom |  | 4 |  |  |  | Wednesday night 12am
 | ISC |  | 9724 |  | Car Park Light |  | 6 |  |  |  | $1230 Still to spend. 6 hours x $200
 | ISC |  | 9732 |  | [NAME] | [NAME] | 30
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 80
 | 11th November to 15th of November
 | Million [NAME] |  | J9825 |  | Rough in | [NAME] | 20
 | [NAME] |  | J9835 |  | Relocation of SB | Windy | 12
 | Buranda |  | J9788 |  | Upgrade of Ivy Nails |  | 10
 | ISC |  | J9564 |  | Metering Upgrade |  | 60 |  |  |  | [NAME] duos
 | Gas Works |  | J9809 |  | Light Repair | [NAME] | 1
 | Gas Works |  | J9801 |  | Light Repair | [NAME] | 1
 | Gas Works |  | J9770 |  | Gas Ring Refurbishment | Sean L & Fadden | 80
 | Jabiru |  | 9465 |  | Project Works | [NAME] | 32
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 224
 | 11th November to 15th of November
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | ISC |  | J9827 |  | Lvl 2 GPO Install |  | 6
 | Warner |  | [NAME] |  | Tenancy Meters |  | 4
 | [NAME] |  | J9830 |  | Shells Nail |  | 20
 | [NAME] |  | [NAME] |  | Emergency Lights |  | 6
 | [NAME] |  | J9835 |  | Relocation of SB |  | 2
 | [NAME] |  | J9768 |  | [NAME] |  | 10
 | ISC |  | J9564 |  | Metering Upgrade |  | 10
 | ISC |  | awaiting PO |  | [NAME] |  | 20
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 80
 | 18th November to 22nd of November
 | Gas Works |  | J9854 |  | Lift 10 Outage | Sean | 1 |  |  |  | Complete intial investigation
 | Gas Works |  | J9851 |  | Lift 12 & 13 Outage | Sean | 1 |  |  |  | Complete intial investigation
 | Gas Works |  | J9826 |  | Replacing Surge Drivter |  | 2 |  |  |  | Waiting on part to arrive.
 | Gas Works |  | J9810 |  | [NAME] light | Sean |  |  |  | 2 | provided pricing, awaiting for approval
 | Gas Works |  | JAAC |  | Repair/Replace Lamps | Sean |  |  |  | 2 | KC to sort parts
 | Gas Works |  | J9853 |  |  |  |  |  |  |  | What type of poles are we looking, Sean will have no clue
 | ISC |  | J9732 |  | Change over a ballast in lvl 6 |  | 1 |  |  |  | Waiting on ballast info from dave
 | ISC |  | J9856 |  | Signcepts |  | 300
 | ISC |  | J9850
 | ISC |  | [NAME] |  | Foot Locker Phone patch |  |  |  |  | 4 | awaiting payment
 | ISC |  | J9845 |  | Voip - phone patching |  | 4
 | ISC |  |  |  | Gazman - Phone patching |  | 4
 | ISC |  |  |  | Replace LED bulbs in new mall |  |  |  |  | 10 | Possible early morning works
 | ISC |  | [NAME] |  | Any more works of emergency lighting?
 | ISC |  | [NAME] |  | Install Door |  | 1 |  |  |  | Could be done at night if needed
 | ISC |  |  |  | Test & Tag |  | 8 |  |  |  | Could be longer than a day
 |  |  | J |  | Pandora |  |  |  |  |  | Replacelamps & driver - KC sorting gear
 |  |  | Buranda |  | Conduct emergency testing |  | 1.5 |  |  |  | Testing power to Ex Ivy nails tenancy.
 | [NAME]
 | [NAME] |  | J9803 |  | Replacement SB doors |  |  |  |  | 12 | When are parts arriving?
 | Jabiru |  | J9465 |  | Project Works |  | 80
 | Flotilla |  | J9437 |  | Project Works
 | Darra |  | J9831 |  | Thermoscan Repairs | Sean | 13 |  |  |  | KC - to order parts
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 224
 | 18th November to 22nd of November
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | ISC |  | J9850 |  | Install new GPO | Dale | 9
 | ISC |  | J9852 |  | Repair Lamp | Dale | 2
 | [NAME] |  | [NAME] |  | Lighting Install | Dale | 60
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 80
 | 25th November to 29th November
 | Gas Works |  | J9854 |  | Lift 10 Outage |  | 2 |  |  |  | Get lift tech in and change over any drivers
 | Gas Works |  | J9851 |  | Lift 12 & 13 Outage |  | 2 |  |  |  | Get lift tech in and change over any drivers
 | [NAME] |  |  |  | Fitoff and install |  | 70 |  |  |  | KC - to order parts
 | ISC |  | J9856 |  | Signcepts |  | 300
 | Jabiru |  | J9465 |  | Project Works |  | 80
 | Flotilla |  | J9437 |  | Project Works
 | ECCO Shoes |  | J9806 |  | Lamp replacements |  |  |  |  | 5 | awaiting payment
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 224
 | 25th November to 29th November
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | ISC |  | J9848 |  | Works on TMDB 6.1A |  | 20 |  |  |  | TB - can you order parts
 | [NAME] |  |  |  | Ex Aust Clinics tenancy 195 |  | 20 |  |  |  | Awaiting PO approval
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 80
 | 2nd December to 6th December
 | 141 Logan Rd |  | 9891 |  | Replaced 2 x RCD |  | 2 |  |  |  | Tenatively scheduled 3/12
 | QP |  | 9806 |  | Replace lamps |  | 3
 | Springfied |  | 9878 |  | Replace Emergency lighting |  | 2
 | [NAME] |  |  |  | Millionlife Browns Plains |  |  |  |  | 40 | KC to order parts
 | [NAME] |  | 9825 |  | [NAME] |  |  |  |  | 8 | I reckon we will need to back to site next week
 | ISC |  | 9842 |  | T2061 - Nail Society |  |  |  |  | 2
 | ISC |  | 9886 |  | T1057 Reconfiguration |  |  |  |  | 17 | 17 hours day works - 27 hours night [NAME] hours 4 techs
 | ISC |  | 9837 |  | Foot Lock Phone Patch |  |  |  |  | 3
 | ISC |  | 9889 |  | [NAME] Patch |  |  |  |  | 3 | Awaiting payment
 | ISC |  |  |  | J Shinsen Phone Patch |  |  |  |  | 3
 | ISC |  |  |  | Signcepts |  | 200 |  |  |  | excludes labour hire
 | Jabiru |  |  |  | Jabiru |  | 120 |  |  |  | excludes labour hire
 | 344 [NAME] |  |  |  | Finish off works |  |  |  |  |  | KC to go through and see what lights need to be done and where the rest of the gear is
 | [NAME] |  |  |  | GPOs for UPS |  |  |  |  | 6 | Have you made a quote/job for this
 | [NAME] |  | 9774 |  | [NAME] |  | 2
 | [NAME] |  | 9892 |  | Install new isolator |  | 3 |  |  |  | Tenatively scheduled 3/12
 | myer |  | 9803 |  | Install SB Doors
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 224
 | 2nd December to 6th December
 | Site |  |  |  | Night | Tech | Hours |  |  |  | Notes
 | ISC |  | 9894 |  | Portal Ambience Upgrade - Aldi |  |  |  |  | 0 | Completed by 17/12
 | ISC |  | 9886 |  | T1057 Reconfiguration |  |  |  |  | 27 | 17 hours day works - 27 hours night works
 | ISC |  | 9844 |  | Investigate fancy branch tree |  |  |  |  | 8
 | [NAME] |  |  |  | GPOs for UPS |  |  |  |  | 6 | Have you made a quote/job for this
 | [NAME] |  | 9766 |  | Generator Maintenace |  |  |  |  | 10 | Do we need to get Test mats etc ready?
 | ISC |  |  |  | [NAME] display not working |  |  |  |  |  | Possibely some works to go ahead
 | ISC |  |  |  | Formulas - P1 & P2 |  |  |  |  | 20
 |  |  |  |  | Lighting repairs |  |  |  |  | 16
 |  |  |  |  | RCD Testing |  |  |  |  | 56
 |  |  |  |  | Data run |  |  |  |  | 6
 |  |  |  |  | toilet lighting |  |  |  |  | 6
 |  |  |  |  | PAR 38 LIGHT REPAIR |  |  |  |  | 4
 |  |  |  |  | DOCK 8 lighting repairs |  |  |  |  | 12
 | TOTAL |  | TECH HOURS REQ (MIN) |  | 80
 | DAY WORKS
 | Job Description | Site | Job Num |  | Works | Tech | week 1 | Week 2 | Week 3 |  | Notes
 | PROJECTS
 | Highpoint Childcare |  | 12204 |  |  |  | 0 | 0 | 0
 | Myer Emg Lighting Upgrade |  |  |  |  |  | 160 | 80 | 120
 | Indro Batteries |  |  |  |  |  | 0 | 40
 | Teneo Yard |  |  |  | On Hold |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0
 | Service
 | Blkue C-Park ped crossing | Grand Plaza | 13356 |  |  |  | 0
 | [NAME] ped crossing | Grand Plaza | 13358 |  |  |  | 0
 | Gray C-Park ped crossing | Grand Plaza | 13359 |  |  |  | 0
 | GP Floorboxes Coles | Grand Plaza |  |  | Nights - 1 Night approved |  | 16
 | [NAME] | Grand Plaza |  |  |  |  | 8
 | Test and Tag | Grand Plaza |  |  | Monday or Friday |  | 16
 | Orange Carpark isolators | Grand Plaza |  |  |  |  | 8
 | Training/Covid
 | Service |  |  |  |  |  | 0
 | Tafe/Training |  |  |  | Week 1 - Carlon, Week 2 - Thai, Sean D, Carlon |  | 24
 | Leave
 | Covid
 | TOTAL WEEK 1 |  | Number of techs required
 | TOTAL WEEK 2 |  | Number of techs required
 | Based on a 40 hour working week |  |  |  | + or - Hours
 | [NAME] |  | 7 |  | [NAME] | 8
 | Callam |  | HP / TRAINING | 1 | Callam |  |  |  | Red | Need to find work
 | Caleb |  | MCB | 2 | [NAME] |  |  |  | Green | Need to find labour or [NAME] work
 | [NAME] |  |  | 7 | [NAME]
 | Temanea |  | MCB | 3 | Mitchell Long
 | Carlon |  |  | 4 | [NAME]
 | Dale |  | Leave |  | [NAME]
 | Brennan |  | HP | 5 | [NAME]
 |  |  |  |  | [NAME]
 | Mitch |  | BATTERIES | 6