Spreadsheet: 776620d1649831619-extracting-text-strings-of-uneven-length-in-excel-extracting-text-strings-of-uneven-length-in-excel
Sheet: Sheet1

Labour
12256   B      55814  [NAME], [NAME]    3/28/2022 | [NAME], [NAME]
95% PRX
12256   B      55814  [NAME], Ivan    3/29/2022 | [NAME], [NAME]
PBL new pump, hydraulic analysis
12256   B      55814  [NAME], Ivan    3/30/2022 | [NAME], [NAME]
100% PRX; PBL new pump
12256   B      55814  [NAME], Ivan    3/31/2022 | [NAME], [NAME]
100% PRX
12256   B      55814  [NAME], [NAME]    4/1/2022 | [NAME], [NAME]
95% CMC; PBL new pump
Total for 55814
12256   B      59964  [NAME], Marina    3/28/2022 | [NAME], Marina
1 hr - team coordination meeting, 2 hrs - drafting
12256   B      59964  [NAME], Marina    3/30/2022 | [NAME], Marina
drafting
12256   B      59964  [NAME], Marina    3/31/2022
coordination
Total for 59964
12259   B      63412  Nishio, [NAME]
Bloor SWPS new pump
12259   B      63412  Nishio, [NAME]
Bloor SWPS new pump
12259   B      63412  Nishio, Jonathan    3/31/2022
Bloor SWPS new pump
Total for 63412
12296   B      69979  Liegey, Stephane    3/28/2022
Progress Meeting with City, Internal Progress Review
12296   B      69979  Liegey, Stephane    3/29/2022
Project Coordination
12296   B      69979  Liegey, Stephane    3/30/2022
Project Coordination including Roxborough Submission & Permits
12296   B      69979  Liegey, Stephane    3/31/2022
Project Coordination & Management
12296   B      69979  Liegey, Stephane    4/1/2022
70% [NAME] and Project Coordination
Total for 69979
12347   B      71848  Bualat, Jenan    3/30/2022
Todmorden SPS - archaeological/heritage meeting, permits and approvals
12347   B      71848  Bualat, Jenan    4/1/2022
permits and approvals, response to building permit comments
Total for 71848
12359   B      74688  [NAME], Hany    3/28/2022
workshops, PCRs and meetings
12359   B      74688  [NAME], Hany    3/29/2022
workshops, PCRs and meetings
12359   B      74688  [NAME], Hany    3/31/2022
workshops, PCRs and meetings
12359   B      74688  [NAME], Hany    4/1/2022
workshops, PCRs and meetings
Total for 74688
12360   B      76461  [NAME], Jordan    3/29/2022
Worked on the permitting and approvals excel spreadsheet for [NAME]. Gathered info from different CoT sites on each SPS.
Total for Labour
Total for Overhead
Total for Labour and Overhead
Total for 01
Sub-Phase Number: 02 Mechanical
Labour
12251   B      20110  [NAME], Samuel    3/29/2022
Electrical CAD Design - PTD
12251   B      20110  [NAME], [NAME]
Electrical CAD Design - PTD
12251   B      20110  [NAME], [NAME]
Electrical CAD Design - PRX
12251   B      20110  [NAME], [NAME]
Electrical CAD Design - PRX
Total for 20110
12347   B      71215  [NAME], [NAME]
Reviewing current state of Roxborough station drawings.
12360   B      76563  McLeod, Daniel    3/28/2022
Revit revisions
Total for Labour
Total for Overhead
Total for Labour and Overhead
Total for 02
Sub-Phase Number: 03 Electrical
Labour
12259   B      64041  [NAME], [NAME]    3/28/2022
Roxborough PS
12259   B      64041  [NAME], [NAME]    3/29/2022
Roxborough PS
12259   B      64041  [NAME], [NAME]    4/1/2022
[NAME] workshop
Total for 64041
12347   B      74096  Arcuri, Christian    3/28/2022
Arc Flash Coordiantion
Total for Labour
Total for Overhead
Total for Labour and Overhead
Total for 03
Sub-Phase Number: 04 Arc Flash / Coord Review
Labour and Overhead
Total for Overhead
Total for 04
Sub-Phase Number: 05 I&C
Labour
12256   B      57322  Sambotelecan, Alexander    3/29/2022
full review + QA/QC
12359   B      74883  Sun, Wenbin    3/31/2022
Updated the PRX 100% DD: Updated the rung number, Scada Architecture, Power distribution.
12359   B      74883  Sun, Wenbin    4/1/2022
Updated the PRX 100% DD: updated the loop drawing, Location drawning and Miscellaneous P&ID
Total for 74883
Total for Labour
Total for Overhead
Total for Labour and Overhead
Total for 05
Sub-Phase Number: 06 I&C - Coordination (Proj. Eng)
Labour and Overhead
Total for Overhead
Total for 06
Sub-Phase Number: 07 Civil
Labour and Overhead
Total for Overhead
Total for 07
Sub-Phase Number: 07A Civil-Kingston
Labour and Overhead
Total for Overhead
Total for 07A
Sub-Phase Number: 08 Linear
Labour and Overhead
Total for Overhead
Total for 08
Sub-Phase Number: 09 Hydraulic Study
Labour and Overhead
Total for Overhead
Total for 09
Sub-Phase Number: 10 PSR
Sub-Phase Number: 11 DSS
Sub-Phase Number: 12 *DNU* - Landscaping / Tree Assmt
Sub-Phase Number: 12Z Landscaping / Tree Assmt
Labour and Overhead
Total for Overhead
Total for 12Z
Sub-Phase Number: 13 HAZOP
Sub-Phase Number: 14 Aviation
Sub-Phase Number: 15 CCE
Sub-Phase Number: 16 Tender Phase
Sub-Phase Number: 17 Expenses
Sub-Phase Number: 18 QA/QC
Sub-Phase Number: 19 Structural / Arch
Labour
12251   B      20105  Ip, [NAME]    3/28/2022
Roxborough
12251   B      20105  Ip, [NAME]    3/29/2022
Roxborough, specs, cost estimate
12251   B      20105  Ip, [NAME]
Roxborough, specs, cost estimate
12251   B      20105  Ip, [NAME]
Roxborough, [NAME], specs, cost estimate
12251   B      20105  Ip, [NAME]    4/1/2022
Roxborough, [NAME], specs, cost estimate
Total for 20105
12296   B      69379  Lam, Wing Fai    3/29/2022
PRX / PMG - coating note revised for 100%
Total for Labour
Total for Overhead
Total for Labour and Overhead
Total for 19
Total for 02
Phase Number: 03 Construction
Sub-Phase Number: 01 Process
Sub-Phase Number: 02 Mechanical
Sub-Phase Number: 03 Electrical
Sub-Phase Number: 04 Structural / Arch
Sub-Phase Number: 05 I&C
Sub-Phase Number: 06 I&C - Coordination (Proj. Eng)
Sub-Phase Number: 07 Civil
Sub-Phase Number: 08 Linear
Sub-Phase Number: 09 Hydraulic Study
Sub-Phase Number: 10 PSR
Sub-Phase Number: 11 DSS
Sub-Phase Number: 12 *DNU* - Landscaping / Tree Assmt
Sub-Phase Number: 12Z Landscaping / Tree Assmt
Sub-Phase Number: 13 HAZOP
Sub-Phase Number: 14 Site Inspector
Sub-Phase Number: 15 Expenses
Sub-Phase Number: 1A Process (Comm)
Total for 03
Phase Number: 04 Post Construction
Sub-Phase Number: 01 Process
Sub-Phase Number: 02 Electrical
Sub-Phase Number: 03 I&C
Sub-Phase Number: 04 I&C - Coordination (Proj. Eng)
Sub-Phase Number: 05 Linear
Sub-Phase Number: 06 DSS
Sub-Phase Number: 07 *DNU* - Landscaping / Tree Assmt
Sub-Phase Number: 07Z Landscaping / Tree Assmt
Sub-Phase Number: 08 Scanning
Sub-Phase Number: 08.GV Scanning
Sub-Phase Number: 09 Site Inspector
Sub-Phase Number: 10 Expenses
Total for 04
Phase Number: 05 PCR-01
Sub-Phase Number: 0341120 CDN-GT-Markham-Vertical Infrastructure
Labour and Overhead
Total for Overhead
Total for 0341120
Total for 05
Phase Number: 06 PCR-02
Sub-Phase Number: 0341120 Safety Scope
Phase Number: 07 PCR-04
Sub-Phase Number: 01 Hydrogeological Services
Labour
12251   B      20342  Brunner, Derek    3/29/2022
Follow up re: draft hydroG report
12251   B      20342  Brunner, Derek    3/31/2022
Meeting re: hydroG report
Total for 20342
Total for Labour
Total for Overhead
Total for Labour and Overhead
Total for 01
Total for 07
Phase Number: 08 PCR-05
Sub-Phase Number: 01 Topographic and SUE
Phase Number: 09 PCR-06
Sub-Phase Number: 01 Strachan SPS Arborist Services
Sub-Phase Number: 02 Disbursements
Total for 09
Phase Number: 10 PCR-03 Geotechnical Study
Sub-Phase Number: 01A Hanlans Pt - Labour
Labour and Overhead
Total for Overhead
Total for 01A
Sub-Phase Number: 01B Hanlans Pt - Subcontractor
Labour and Overhead
Total for Overhead
Total for 01B
Sub-Phase Number: 01C Hanlans Pt - Exp & Lab Fees
Labour and Overhead
Total for 01C
Sub-Phase Number: 02A Bloor - Labour
Labour and Overhead
Total for Overhead
Total for 02A
Sub-Phase Number: 02B Bloor - Subcontractor
Labour and Overhead
Total for 02B
Sub-Phase Number: 02C Bloor - Exp & Lab Fees
Sub-Phase Number: 03A Islington - Labour
Labour and Overhead
Total for Overhead
Total for 03A
Sub-Phase Number: 03B Islington - Subcontractor
Labour and Overhead
Total for 03B
Sub-Phase Number: 03C Islington - Exp & Lab Fees
Sub-Phase Number: 04A [NAME]
Labour and Overhead
Total for Overhead
Total for 04A
Sub-Phase Number: 04B [NAME]
Sub-Phase Number: 04C [NAME]
Sub-Phase Number: 05A Roxborough - Labour
Labour and Overhead
Total for Overhead
Total for 05A
Sub-Phase Number: 05B Roxborough - Subcontractor
Sub-Phase Number: 05C Roxborough - Exp & Lab Fees
Sub-Phase Number: 06A Todmorden - Labour
Labour and Overhead
Total for Overhead
Total for 06A
Sub-Phase Number: 06B Todmorden - Subcontractor
Sub-Phase Number: 06C Todmorden - Exp & Lab Fees
Sub-Phase Number: 07A Kenilworth - Labour
Labour and Overhead
Total for Overhead
Total for 07A
Sub-Phase Number: 07B Kenilworth - Subcontractor
Sub-Phase Number: 07C Kenilworth - Exp & Lab Fees
Labour and Overhead
Total for Overhead
Total for 07C
Sub-Phase Number: 08A Maclean - Labour
Labour and Overhead
Total for Overhead
Total for 08A
Sub-Phase Number: 08B Maclean - Subcontractor
Sub-Phase Number: 08C Maclean - Exp & Lab Fees
Total for 10
Phase Number: 11 PCR 07
Sub-Phase Number: 01 Hanlans - Additional BH 6
Labour and Overhead
Total for Overhead
Total for 01
Sub-Phase Number: 02 Kenilworth Additional BH4
Labour and Overhead
Total for Overhead
Total for 02
Total for 11
Phase Number: 12 PCR 08 - Extra Tender & Prequal Services
Sub-Phase Number: 01 Additional Tender & GC Prequal
Labour and Overhead
Total for Overhead
Total for 01
Total for 12
Phase Number: 13 PCR 09 - PHA Design Modifications
Sub-Phase Number: 01 PHA Design Modifications-Item 3
Labour and Overhead
Total for Overhead
Total for 01
Sub-Phase Number: 02 PHA Design Modifications-Item 6
Labour and Overhead
Total for Overhead
Total for 02
Sub-Phase Number: 03 Hydraulics - Budget Recovery
Sub-Phase Number: 04 Landscaping - Budget Recovery
Sub-Phase Number: 05 PCR 09 - Items 1,2,4,5
Labour and Overhead
Total for Overhead
Total for 05
Total for 13
Phase Number: 14 PCR 10  - PHA F/M Routing Modifications
Sub-Phase Number: 01 PHA F/M Routing Modifications
Labour and Overhead
Total for Overhead
Total for 01
Total for 14
Phase Number: 15 PCR 11 - PIT Design Modifications
Sub-Phase Number: 01 PIT Design Modifications - Items 1-4
Labour and Overhead
Total for Overhead
Total for 01
Sub-Phase Number: 02 PIT Design-Item 5 & Budget Recovery
Labour
12251   B      35236  Truscott-Rumsey, [NAME]    4/1/2022
Roxborough drawing clean-up
12347   B      73862  [NAME], Hayden    3/28/2022
100% revisions
12359   B      75164  Pan, Zhidong    3/31/2022
Roxborough PS 100% submission review
12359   B      75164  Pan, Zhidong    4/1/2022
Roxborough PS 100% submission review
Total for 75164
12360   B      76722  Burden, Jessica    3/28/2022
Weekly meeting
12360   B      76722  Burden, Jessica    3/31/2022
Reviewing 95% drawings and preparing for 100% submission
12360   B      76722  Burden, Jessica    4/1/2022
[NAME] 70% review meeting   Review of retention tanks (Kenilworth and MacLean)
Total for 76722
Total for Labour
Total for Overhead
Total for Labour and Overhead
Total for 02
Total for 15
Phase Number: 16 PCR 12 - PBL Design Modifications
Sub-Phase Number: 01 PBL Design Modifications - Items 1 & 3
Labour and Overhead
Total for Overhead
Total for 01
Sub-Phase Number: 02 PBL Design Modifications - Item 2-DNU
Labour and Overhead
Total for Overhead
Total for 02
Sub-Phase Number: 02A Inactive
Labour and Overhead
Total for Overhead
Total for 02A
Sub-Phase Number: 03 Municipal Engineering-Civil
Labour and Overhead
Total for Overhead
Total for 03
Total for 16
Phase Number: 17 PCR 13 - PMG Design Modifications
Sub-Phase Number: 01 PCR 13-Item 1-DNU
Sub-Phase Number: 01A Inactive
Labour and Overhead
Total for Overhead
Total for 01A
Sub-Phase Number: 01A. WWW Team
Labour and Overhead
Total for Overhead
Total for 01A.
Sub-Phase Number: 02 PCR 13-Item 2-DNU
Sub-Phase Number: 02A Municipal Engineering-Civil
Labour and Overhead
Total for Overhead
Total for 02A
Sub-Phase Number: 03 PCR 13-Item 3-DNU
Sub-Phase Number: 04 PCR 13-Item 4-DNU
Total for 17
Phase Number: 18 PCR 14 - KWDT Design Modifications
Sub-Phase Number: 01 PCR 14-Labour-DNU
Sub-Phase Number: 01A Inactive
Labour and Overhead
Total for Overhead
Total for 01A
Sub-Phase Number: 01A. WWW Team
Labour and Overhead
Total for Overhead
Total for 01A.
Sub-Phase Number: 02 Disbursement
Sub-Phase Number: 03 Municipal Engineering-Civil
Total for 18
Phase Number: 19 PCR 15 - MCDT Design Modifications
Sub-Phase Number: 01 PCR 15-Item 1-DNU
Sub-Phase Number: 01A Inactive
Labour and Overhead
Total for 01A
Sub-Phase Number: 01A. WWW Team
Labour and Overhead
Total for Overhead
Total for 01A.
Sub-Phase Number: 02 PCR 15-Item 2-DNU
Sub-Phase Number: 02A Municipal Engineering-Civil
Labour and Overhead
Total for Overhead
Total for 02A
Sub-Phase Number: 03 PCR 15-Item 3-DNU
Sub-Phase Number: 03A Landscaping
Sub-Phase Number: 04 PCR 15-Item 4-DNU
Sub-Phase Number: 04A Disbursement
Sub-Phase Number: 05 PCR 15-Item 5-DNU
Total for 19
Phase Number: 20 PCR 17 - Bloor & Islington BHs
Sub-Phase Number: 01 Bloor - Additional BH
Labour and Overhead
Total for 01
Sub-Phase Number: 02 Islington - Additional BH
Total for 20
Phase Number: 21 PCR 18 - Extra Hydrogeological Services
Sub-Phase Number: 01 Labour - PM, Field, Analysis & Report
Sub-Phase Number: 02 Disbursement, Equipment & Lab Fees
Sub-Phase Number: 03 Provisional - PTTW Application & Fee
Sub-Phase Number: 04 Provisional - EASR Application & Fee
Total for 21
Phase Number: 22 PCR 16 - Toronto Island - Feasibility St
Sub-Phase Number: 01 PCR 16 in review ($ 19,118.00)
Phase Number: 50 PMP - Financial
Sub-Phase Number: 01 PMP - Financial
Labour and Overhead
Total for Overhead
Total for 01
Sub-Phase Number: 02 Invoicing - iCRC
Labour and Overhead
Total for Overhead
Total for 02
Total for 50
Phase Number: 99 BIM
Sub-Phase Number: 0341120 CDN-GT-Markham-Vertical Infrastructure
Labour and Overhead
Total for 0341120
Total for 99