Spreadsheet: 868146d1714900802-power-query-nested-subgroups-index-on-3-sublevels-complete-dataset
Sheet: CostCentreData

Headers | Subheaders | Items Description | Cost Type | Header Code | Subheader Code | Item Code | Cost Type Code | Cubit Cost Centre | Jobpac Cost centre | Jobpac Cost type
Fees and Insurance | Long Service Leave Corporation |  | OT | 1 | 01 | 00 | 5 | 101005OT | 101005 | OT
Fees and Insurance | Bank Guarantees |  | OT | 1 | 02 | 00 | 5 | 102005OT | 102005 | OT
Fees and Insurance | Council & Statutory Fees |  | OT | 1 | 03 | 00 | 5 | 103005OT | 103005 | OT
Fees and Insurance | Insurances |  | OT | 1 | 04 | 00 | 5 | 104005OT | 104005 | OT
Preliminaries | Cleaning and Waste | [NAME] General 10m3 | MT | 2 | 01 | 01 | 3 | 201013MT | 201013 | MT
Preliminaries | Cleaning and Waste | [NAME] General 10m3 | MT | 2 | 01 | 01 | 3 | 201013MT | 201013 | MT
Preliminaries | Cleaning and Waste | [NAME] 10m3 | MT | 2 | 01 | 02 | 3 | 201023MT | 201023 | MT
Preliminaries | Cleaning and Waste | [NAME] 10m3 | MT | 2 | 01 | 02 | 3 | 201023MT | 201023 | MT
Preliminaries | Cleaning and Waste | Final clean (Floor Area) | MT | 2 | 01 | 03 | 3 | 201033MT | 201033 | MT
Preliminaries | Cleaning and Waste | Final clean (Floor Area) | MT | 2 | 01 | 03 | 3 | 201033MT | 201033 | MT
Preliminaries | Cleaning and Waste | Periodic clean | MT | 2 | 01 | 04 | 3 | 201043MT | 201043 | MT
Preliminaries | Cleaning and Waste | Periodic clean | MT | 2 | 01 | 04 | 3 | 201043MT | 201043 | MT
Preliminaries | Site establishment and Protection | Protection to Existing Structure | OT | 2 | 02 | 01 | 5 | 202015OT | 202015 | OT
Preliminaries | Site establishment and Protection | Dilapidation Report | OT | 2 | 02 | 02 | 5 | 202025OT | 202025 | OT
Preliminaries | Site establishment and Protection | Survey | OT | 2 | 02 | 03 | 5 | 202035OT | 202035 | OT
Preliminaries | Site establishment and Protection | Setout/ Profile Material | OT | 2 | 02 | 04 | 5 | 202045OT | 202045 | OT
Preliminaries | Site establishment and Protection | A Class Hoardings | OT | 2 | 02 | 05 | 5 | 202055OT | 202055 | OT
Preliminaries | Site establishment and Protection | Site Fence 1800[NAME] high, with mesh | OT | 2 | 02 | 06 | 5 | 202065OT | 202065 | OT
Preliminaries | Site establishment and Protection | Site Fence 1800[NAME] high, clad with waterproof ply | OT | 2 | 02 | 07 | 5 | 202075OT | 202075 | OT
Preliminaries | Site establishment and Protection | Builders Site Sign | OT | 2 | 02 | 08 | 5 | 202085OT | 202085 | OT
Preliminaries | Site Labour | Site Manager - Day | LB | 2 | 03 | 01 | 2 | 203012LB | 203012 | LB
Preliminaries | Site Labour | Site Manager - Night | SC | 2 | 03 | 02 | 1 | 203021SC | 203021 | SC
Preliminaries | Site Labour | Site Supervisor - Day | LB | 2 | 03 | 03 | 2 | 203032LB | 203032 | LB
Preliminaries | Site Labour | Site Supervisor - Night | SC | 2 | 03 | 04 | 1 | 203041SC | 203041 | SC
Preliminaries | Site Labour | Foreman / Leading Hand Carpenters - Day | LB | 2 | 03 | 05 | 2 | 203052LB | 203052 | LB
Preliminaries | Site Labour | Foreman / Leading Hand Carpenters - Night | LB | 2 | 03 | 06 | 2 | 203062LB | 203062 | LB
Preliminaries | Site Labour | Carpenter - Day | LB | 2 | 03 | 07 | 2 | 203072LB | 203072 | LB
Preliminaries | Site Labour | Carpenter - Night | LB | 2 | 03 | 08 | 2 | 203082LB | 203082 | LB
Preliminaries | Site Labour | Apprentice - Day ( Either all as one or Split into 1st, 2nd, 3rd and 4th yr......) | LB | 2 | 03 | 09 | 2 | 203092LB | 203092 | LB
Preliminaries | Site Labour | General [NAME] | LB | 2 | 03 | 010 | 2 | 2030102LB | 2030102 | LB
Preliminaries | Site Labour | General [NAME] | LB | 2 | 03 | 011 | 2 | 2030112LB | 2030112 | LB
Preliminaries | Site Labour | Project Allowances (incl LAFHA) | LB | 2 | 03 | 012 | 2 | 2030122LB | 2030122 | LB
Preliminaries | Temporary Services | Temporary Power & water: Site Sheds Connections. | OT | 2 | 04 | 01 | 5 | 204015OT | 204015 | OT
Preliminaries | Temporary Services | Temporary Power & water: Over site | OT | 2 | 04 | 02 | 5 | 204025OT | 204025 | OT
Preliminaries | Temporary Services | Electricity Connections | OT | 2 | 04 | 03 | 5 | 204035OT | 204035 | OT
Preliminaries | Temporary Services | Electricity Charges/Tariffs | OT | 2 | 04 | 04 | 5 | 204045OT | 204045 | OT
Preliminaries | Temporary Services | Telephone Connections | OT | 2 | 04 | 05 | 5 | 204055OT | 204055 | OT
Preliminaries | Temporary Services | Telephone Charges/Tariffs | OT | 2 | 04 | 06 | 5 | 204065OT | 204065 | OT
Preliminaries | Temporary Services | Water & Sewer Connections | OT | 2 | 04 | 07 | 5 | 204075OT | 204075 | OT
Preliminaries | Temporary Services | Water & Sewer Charges/Tariffs | OT | 2 | 04 | 08 | 5 | 204085OT | 204085 | OT
Preliminaries | Temporary Services | Internet Connection & Support | OT | 2 | 04 | 09 | 5 | 204095OT | 204095 | OT
Preliminaries | Temporary Services | Internet monthly charges | OT | 2 | 04 | 010 | 5 | 2040105OT | 2040105 | OT
Preliminaries | Temporary Services | Site lighting | OT | 2 | 04 | 011 | 5 | 2040115OT | 2040115 | OT
Preliminaries | Temporary Services | Monthly lead Checks | OT | 2 | 04 | 012 | 5 | 2040125OT | 2040125 | OT
Preliminaries | Access Equipment | EWP / Scissor Lift - Weekly Hire | PL | 2 | 05 | 01 | 4 | 205014PL | 205014 | PL
Preliminaries | Access Equipment | EWP / Scissor Lift - Transport & Pick-up | PL | 2 | 05 | 02 | 4 | 205024PL | 205024 | PL
Preliminaries | Access Equipment | Boom Lift - Weekly Hire | PL | 2 | 05 | 03 | 4 | 205034PL | 205034 | PL
Preliminaries | Access Equipment | Boom Lift - Transport & Pick-up | PL | 2 | 05 | 04 | 4 | 205044PL | 205044 | PL
Preliminaries | Access Equipment | Mobile Scaffold | PL | 2 | 05 | 05 | 4 | 205054PL | 205054 | PL
Preliminaries | Access Equipment | Internal Scaffold - Contract | PL | 2 | 05 | 06 | 4 | 205064PL | 205064 | PL
Preliminaries | Access Equipment | Internal [NAME] | PL | 2 | 05 | 07 | 4 | 205074PL | 205074 | PL
Preliminaries | Access Equipment | Internal Scaffold Erection | PL | 2 | 05 | 08 | 4 | 205084PL | 205084 | PL
Preliminaries | Access Equipment | External Scaffold - Contract | PL | 2 | 05 | 09 | 4 | 205094PL | 205094 | PL
Preliminaries | Access Equipment | External [NAME] | PL | 2 | 05 | 010 | 4 | 2050104PL | 2050104 | PL
Preliminaries | Access Equipment | External [NAME] | PL | 2 | 05 | 011 | 4 | 2050114PL | 2050114 | PL
Preliminaries | Builder Equipment | Fork Lift - Weekly Hire | PL | 2 | 06 | 01 | 4 | 206014PL | 206014 | PL
Preliminaries | Builder Equipment | Fork Lift - Transport & Pick-up | PL | 2 | 06 | 02 | 4 | 206024PL | 206024 | PL
Preliminaries | Builder Equipment | Pallet Jack | PL | 2 | 06 | 03 | 4 | 206034PL | 206034 | PL
Preliminaries | Builder Equipment | Dewater Pump | PL | 2 | 06 | 04 | 4 | 206044PL | 206044 | PL
Preliminaries | Builder Equipment | Generator | PL | 2 | 06 | 05 | 4 | 206054PL | 206054 | PL
Preliminaries | Builder Equipment | Compressor | PL | 2 | 06 | 06 | 4 | 206064PL | 206064 | PL
Preliminaries | Builder Equipment | Brick/Block Saw | PL | 2 | 06 | 07 | 4 | 206074PL | 206074 | PL
Preliminaries | Builder Equipment | Small Tools Hire | PL | 2 | 06 | 08 | 4 | 206084PL | 206084 | PL
Preliminaries | Builder Equipment | Small Tools Purchase | PL | 2 | 06 | 09 | 4 | 206094PL | 206094 | PL
Preliminaries | Builder Equipment | Builders Sundry Fixings | PL | 2 | 06 | 010 | 4 | 2060104PL | 2060104 | PL
Preliminaries | Builder Equipment | Fuel | PL | 2 | 06 | 011 | 4 | 2060114PL | 2060114 | PL
Preliminaries | Builder Equipment | Miscellaneous Plant | PL | 2 | 06 | 012 | 4 | 2060124PL | 2060124 | PL
Preliminaries | [NAME] | Tower Crane - Contract | PL | 2 | 07 | 01 | 4 | 207014PL | 207014 | PL
Preliminaries | [NAME] | Mobile Crane - Contract | PL | 2 | 07 | 02 | 4 | 207024PL | 207024 | PL
Preliminaries | [NAME] | Hoist - Contract | PL | 2 | 07 | 03 | 4 | 207034PL | 207034 | PL
Preliminaries | [NAME] | Hoist - Material Hire | PL | 2 | 07 | 04 | 4 | 207044PL | 207044 | PL
Preliminaries | [NAME] | Hoist - Personnel Hire | PL | 2 | 07 | 05 | 4 | 207054PL | 207054 | PL
Preliminaries | [NAME] | Hoist - Barrow Hire | PL | 2 | 07 | 06 | 4 | 207064PL | 207064 | PL
Preliminaries | [NAME] | Hoist - Erection & Dismantle | PL | 2 | 07 | 07 | 4 | 207074PL | 207074 | PL
Preliminaries | [NAME] | [NAME] | PL | 2 | 07 | 08 | 4 | 207084PL | 207084 | PL
Preliminaries | Off Site Labour | Construction Manager | PL | 2 | 08 | 01 | 4 | 208014PL | 208014 | PL
Preliminaries | Off Site Labour | Project Manager | PL | 2 | 08 | 02 | 4 | 208024PL | 208024 | PL
Preliminaries | Off Site Labour | Contract Administrator | PL | 2 | 08 | 03 | 4 | 208034PL | 208034 | PL
Preliminaries | Off Site Labour | Project Coordinator | PL | 2 | 08 | 04 | 4 | 208044PL | 208044 | PL
Preliminaries | Off Site Labour | Estimator | PL | 2 | 08 | 05 | 4 | 208054PL | 208054 | PL
Preliminaries | Off Site Labour | OH&S Officer | PL | 2 | 08 | 06 | 4 | 208064PL | 208064 | PL
Preliminaries | Shedding and Facilities | Site Sheds - Weekly Hire | PL | 2 | 09 | 01 | 4 | 209014PL | 209014 | PL
Preliminaries | Shedding and Facilities | Site Sheds - Transport & Pick-up | PL | 2 | 09 | 02 | 4 | 209024PL | 209024 | PL
Preliminaries | Shedding and Facilities | Site container - Weekly Hire | PL | 2 | 09 | 03 | 4 | 209034PL | 209034 | PL
Preliminaries | Shedding and Facilities | Site container - Transport & Pick-up | PL | 2 | 09 | 04 | 4 | 209044PL | 209044 | PL
Preliminaries | Shedding and Facilities | Portaloo - Weekly Hire | PL | 2 | 09 | 05 | 4 | 209054PL | 209054 | PL
Preliminaries | Shedding and Facilities | Portaloo - Transport & Pick-up | PL | 2 | 09 | 06 | 4 | 209064PL | 209064 | PL
Preliminaries | Shedding and Facilities | Amenities - Weekly Hire | PL | 2 | 09 | 07 | 4 | 209074PL | 209074 | PL
Preliminaries | Shedding and Facilities | Amenities - Transport & Pick-up | PL | 2 | 09 | 08 | 4 | 209084PL | 209084 | PL
Preliminaries | Shedding and Facilities | Build Temp Internal Sheds and remove on completion | PL | 2 | 09 | 09 | 4 | 209094PL | 209094 | PL
Preliminaries | Shedding and Facilities | Other Rental Accommodation | PL | 2 | 09 | 010 | 4 | 2090104PL | 2090104 | PL
Preliminaries | Shedding and Facilities | Car parking | PL | 2 | 09 | 011 | 4 | 2090114PL | 2090114 | PL
Preliminaries | Shedding and Facilities | Furniture | PL | 2 | 09 | 012 | 4 | 2090124PL | 2090124 | PL
Preliminaries | Shedding and Facilities | Beverages (Tea/Coffee etc.) | PL | 2 | 09 | 013 | 4 | 2090134PL | 2090134 | PL
Preliminaries | Shedding and Facilities | Water Coolers | PL | 2 | 09 | 014 | 4 | 2090144PL | 2090144 | PL
Preliminaries | Shedding and Facilities | Safety & First Aid Box | PL | 2 | 09 | 015 | 4 | 2090154PL | 2090154 | PL
Trades | Tiling |  | SC | 3 | 01 | 00 | 1 | 301001SC | 301001 | SC
Trades | Concrete Works |  | SC | 3 | 02 | 00 | 1 | 302001SC | 302001 | SC
Trades | Masonry Repair Work |  | SC | 3 | 03 | 00 | 1 | 303001SC | 303001 | SC
Trades | Demolition |  | SC | 3 | 04 | 00 | 1 | 304001SC | 304001 | SC
Trades | Painting |  | SC | 3 | 05 | 00 | 1 | 305001SC | 305001 | SC
Trades | Stonework |  | SC | 3 | 06 | 00 | 1 | 306001SC | 306001 | SC
Trades | Carpentry |  | SC | 3 | 07 | 00 | 1 | 307001SC | 307001 | SC
Trades | Cladding & Rendering |  | SC | 3 | 08 | 00 | 1 | 308001SC | 308001 | SC
Services | Blinds & Curtains |  | SC | 4 | 01 | 00 | 1 | 401001SC | 401001 | SC
Services | Balustrading |  | SC | 4 | 02 | 00 | 1 | 402001SC | 402001 | SC
Services | Blockwork / Brickwork |  | SC | 4 | 03 | 00 | 1 | 403001SC | 403001 | SC
Services | [NAME] |  | SC | 4 | 04 | 00 | 1 | 404001SC | 404001 | SC
Services | Ceiling Work |  | SC | 4 | 05 | 00 | 1 | 405001SC | 405001 | SC
Services | Glass / Glazing |  | SC | 4 | 06 | 00 | 1 | 406001SC | 406001 | SC
Services | Hydraulic/Plumbing |  | SC | 4 | 07 | 00 | 1 | 407001SC | 407001 | SC
Services | Demolition |  | SC | 4 | 08 | 00 | 1 | 408001SC | 408001 | SC
Services | Doors & Windows |  | SC | 4 | 09 | 00 | 1 | 409001SC | 409001 | SC
Services | [NAME] |  | SC | 4 | 010 | 00 | 1 | 4010001SC | 4010001 | SC
Services | Electrical Services |  | SC | 4 | 011 | 00 | 1 | 4011001SC | 4011001 | SC
Services | Kitchen |  | SC | 4 | 012 | 00 | 1 | 4012001SC | 4012001 | SC
Services | Access Floors |  | SC | 4 | 013 | 00 | 1 | 4013001SC | 4013001 | SC
Services | Landscaping / External Works |  | SC | 4 | 014 | 00 | 1 | 4014001SC | 4014001 | SC
Services | Fire Services |  | SC | 4 | 015 | 00 | 1 | 4015001SC | 4015001 | SC
Services | Mechanical Services |  | SC | 4 | 016 | 00 | 1 | 4016001SC | 4016001 | SC
Services | Metal Works |  | SC | 4 | 017 | 00 | 1 | 4017001SC | 4017001 | SC
Services | Partitions / Ceilings / Doors |  | SC | 4 | 018 | 00 | 1 | 4018001SC | 4018001 | SC
Services | Roofing |  | SC | 4 | 019 | 00 | 1 | 4019001SC | 4019001 | SC
Services | Security |  | SC | 4 | 020 | 00 | 1 | 4020001SC | 4020001 | SC
Services | Special Doors |  | SC | 4 | 021 | 00 | 1 | 4021001SC | 4021001 | SC
Services | Stairs |  | SC | 4 | 022 | 00 | 1 | 4022001SC | 4022001 | SC
Services | Structural Works |  | SC | 4 | 023 | 00 | 1 | 4023001SC | 4023001 | SC
Services | Toilet Partitions |  | SC | 4 | 024 | 00 | 1 | 4024001SC | 4024001 | SC
Services | Waterproofing Work |  | SC | 4 | 025 | 00 | 1 | 4025001SC | 4025001 | SC
Consultants | Concrete Scanning |  | OT | 5 | 01 | 00 | 5 | 501005OT | 501005 | OT
Consultants | Design |  | OT | 5 | 02 | 00 | 5 | 502005OT | 502005 | OT
[NAME] or General | Appliances/Whitegoods |  | MT | 6 | 01 | 00 | 3 | 601003MT | 601003 | MT
[NAME] or General | Loose Furniture |  | MT | 6 | 02 | 00 | 3 | 602003MT | 602003 | MT
[NAME] or General | Other |  | OT | 6 | 03 | 00 | 5 | 603005OT | 603005 | OT