Spreadsheet: 868285d1715012452-power-query-nested-subgroups-index-on-3-sublevels-pq_complete-dataset
Sheet: CostCentreData

Headers | Subheaders | Items Description | Cost Type | Header Code | Subheader Code | Item Code | Cost Type Code | Cubit Code
Fees and Insurance | Long Service Leave Corporation |  | OT | 1 | 01 | 00 | 5 | 101005OT
Fees and Insurance | Bank Guarantees |  | OT | 1 | 02 | 00 | 5 | 102005OT
Fees and Insurance | Council & Statutory Fees |  | OT | 1 | 03 | 00 | 5 | 103005OT
Fees and Insurance | Insurances |  | OT | 1 | 04 | 00 | 5 | 104005OT
Preliminaries | Cleaning and Waste | [NAME] General 10m3 | MT | 2 | 01 | 01 | 3 | 201013MT
Preliminaries | Cleaning and Waste | [NAME] 10m3 | MT | 2 | 01 | 02 | 3 | 201023MT
Preliminaries | Cleaning and Waste | Final clean (Floor Area) | MT | 2 | 01 | 03 | 3 | 201033MT
Preliminaries | Cleaning and Waste | Periodic clean | MT | 2 | 01 | 04 | 3 | 201043MT
Preliminaries | Cleaning and Waste | [NAME] General 10m3 | MT | 2 | 01 | 05 | 3 | 201053MT
Preliminaries | Cleaning and Waste | [NAME] 10m3 | MT | 2 | 01 | 06 | 3 | 201063MT
Preliminaries | Cleaning and Waste | Final clean (Floor Area) | MT | 2 | 01 | 07 | 3 | 201073MT
Preliminaries | Cleaning and Waste | Periodic clean | MT | 2 | 01 | 08 | 3 | 201083MT
Preliminaries | Site establishment and Protection | Protection to Existing Structure | OT | 2 | 02 | 01 | 5 | 202015OT
Preliminaries | Site establishment and Protection | Dilapidation Report | OT | 2 | 02 | 02 | 5 | 202025OT
Preliminaries | Site establishment and Protection | Survey | OT | 2 | 02 | 03 | 5 | 202035OT
Preliminaries | Site establishment and Protection | Setout/ Profile Material | OT | 2 | 02 | 04 | 5 | 202045OT
Preliminaries | Site establishment and Protection | A Class Hoardings | OT | 2 | 02 | 05 | 5 | 202055OT
Preliminaries | Site establishment and Protection | Site Fence 1800[NAME] high, with mesh | OT | 2 | 02 | 06 | 5 | 202065OT
Preliminaries | Site establishment and Protection | Site Fence 1800[NAME] high, clad with waterproof ply | OT | 2 | 02 | 07 | 5 | 202075OT
Preliminaries | Site establishment and Protection | Builders Site Sign | OT | 2 | 02 | 08 | 5 | 202085OT
Preliminaries | Site Labour | Site Manager - Day | LB | 2 | 03 | 01 | 2 | 203012LB
Preliminaries | Site Labour | Site Manager - Night | SC | 2 | 03 | 02 | 1 | 203021SC
Preliminaries | Site Labour | Site Supervisor - Day | LB | 2 | 03 | 03 | 2 | 203032LB
Preliminaries | Site Labour | Site Supervisor - Night | SC | 2 | 03 | 04 | 1 | 203041SC
Preliminaries | Site Labour | Foreman / Leading Hand Carpenters - Day | LB | 2 | 03 | 05 | 2 | 203052LB
Preliminaries | Site Labour | Foreman / Leading Hand Carpenters - Night | LB | 2 | 03 | 06 | 2 | 203062LB
Preliminaries | Site Labour | Carpenter - Day | LB | 2 | 03 | 07 | 2 | 203072LB
Preliminaries | Site Labour | Carpenter - Night | LB | 2 | 03 | 08 | 2 | 203082LB
Preliminaries | Site Labour | Apprentice - Day ( Either all as one or Split into 1st, 2nd, 3rd and 4th yr......) | LB | 2 | 03 | 09 | 2 | 203092LB
Preliminaries | Site Labour | General [NAME] | LB | 2 | 03 | 10 | 2 | 203102LB
Preliminaries | Site Labour | General [NAME] | LB | 2 | 03 | 11 | 2 | 203112LB
Preliminaries | Site Labour | Project Allowances (incl LAFHA) | LB | 2 | 03 | 12 | 2 | 203122LB
Preliminaries | Temporary Services | Temporary Power & water: Site Sheds Connections. | OT | 2 | 04 | 01 | 5 | 204015OT
Preliminaries | Temporary Services | Temporary Power & water: Over site | OT | 2 | 04 | 02 | 5 | 204025OT
Preliminaries | Temporary Services | Electricity Connections | OT | 2 | 04 | 03 | 5 | 204035OT
Preliminaries | Temporary Services | Electricity Charges/Tariffs | OT | 2 | 04 | 04 | 5 | 204045OT
Preliminaries | Temporary Services | Telephone Connections | OT | 2 | 04 | 05 | 5 | 204055OT
Preliminaries | Temporary Services | Telephone Charges/Tariffs | OT | 2 | 04 | 06 | 5 | 204065OT
Preliminaries | Temporary Services | Water & Sewer Connections | OT | 2 | 04 | 07 | 5 | 204075OT
Preliminaries | Temporary Services | Water & Sewer Charges/Tariffs | OT | 2 | 04 | 08 | 5 | 204085OT
Preliminaries | Temporary Services | Internet Connection & Support | OT | 2 | 04 | 09 | 5 | 204095OT
Preliminaries | Temporary Services | Internet monthly charges | OT | 2 | 04 | 10 | 5 | 204105OT
Preliminaries | Temporary Services | Site lighting | OT | 2 | 04 | 11 | 5 | 204115OT
Preliminaries | Temporary Services | Monthly lead Checks | OT | 2 | 04 | 12 | 5 | 204125OT
Preliminaries | Access Equipment | EWP / Scissor Lift - Weekly Hire | PL | 2 | 05 | 01 | 4 | 205014PL
Preliminaries | Access Equipment | EWP / Scissor Lift - Transport & Pick-up | PL | 2 | 05 | 02 | 4 | 205024PL
Preliminaries | Access Equipment | Boom Lift - Weekly Hire | PL | 2 | 05 | 03 | 4 | 205034PL
Preliminaries | Access Equipment | Boom Lift - Transport & Pick-up | PL | 2 | 05 | 04 | 4 | 205044PL
Preliminaries | Access Equipment | Mobile Scaffold | PL | 2 | 05 | 05 | 4 | 205054PL
Preliminaries | Access Equipment | Internal Scaffold - Contract | PL | 2 | 05 | 06 | 4 | 205064PL
Preliminaries | Access Equipment | Internal [NAME] | PL | 2 | 05 | 07 | 4 | 205074PL
Preliminaries | Access Equipment | Internal Scaffold Erection | PL | 2 | 05 | 08 | 4 | 205084PL
Preliminaries | Access Equipment | External Scaffold - Contract | PL | 2 | 05 | 09 | 4 | 205094PL
Preliminaries | Access Equipment | External [NAME] | PL | 2 | 05 | 10 | 4 | 205104PL
Preliminaries | Access Equipment | External [NAME] | PL | 2 | 05 | 11 | 4 | 205114PL
Preliminaries | Builder Equipment | Fork Lift - Weekly Hire | PL | 2 | 06 | 01 | 4 | 206014PL
Preliminaries | Builder Equipment | Fork Lift - Transport & Pick-up | PL | 2 | 06 | 02 | 4 | 206024PL
Preliminaries | Builder Equipment | Pallet Jack | PL | 2 | 06 | 03 | 4 | 206034PL
Preliminaries | Builder Equipment | Dewater Pump | PL | 2 | 06 | 04 | 4 | 206044PL
Preliminaries | Builder Equipment | Generator | PL | 2 | 06 | 05 | 4 | 206054PL
Preliminaries | Builder Equipment | Compressor | PL | 2 | 06 | 06 | 4 | 206064PL
Preliminaries | Builder Equipment | Brick/Block Saw | PL | 2 | 06 | 07 | 4 | 206074PL
Preliminaries | Builder Equipment | Small Tools Hire | PL | 2 | 06 | 08 | 4 | 206084PL
Preliminaries | Builder Equipment | Small Tools Purchase | PL | 2 | 06 | 09 | 4 | 206094PL
Preliminaries | Builder Equipment | Builders Sundry Fixings | PL | 2 | 06 | 10 | 4 | 206104PL
Preliminaries | Builder Equipment | Fuel | PL | 2 | 06 | 11 | 4 | 206114PL
Preliminaries | Builder Equipment | Miscellaneous Plant | PL | 2 | 06 | 12 | 4 | 206124PL
Preliminaries | [NAME] | Tower Crane - Contract | PL | 2 | 07 | 01 | 4 | 207014PL
Preliminaries | [NAME] | Mobile Crane - Contract | PL | 2 | 07 | 02 | 4 | 207024PL
Preliminaries | [NAME] | Hoist - Contract | PL | 2 | 07 | 03 | 4 | 207034PL
Preliminaries | [NAME] | Hoist - Material Hire | PL | 2 | 07 | 04 | 4 | 207044PL
Preliminaries | [NAME] | Hoist - Personnel Hire | PL | 2 | 07 | 05 | 4 | 207054PL
Preliminaries | [NAME] | Hoist - Barrow Hire | PL | 2 | 07 | 06 | 4 | 207064PL
Preliminaries | [NAME] | Hoist - Erection & Dismantle | PL | 2 | 07 | 07 | 4 | 207074PL
Preliminaries | [NAME] | [NAME] | PL | 2 | 07 | 08 | 4 | 207084PL
Preliminaries | Off Site Labour | Construction Manager | PL | 2 | 08 | 01 | 4 | 208014PL
Preliminaries | Off Site Labour | Project Manager | PL | 2 | 08 | 02 | 4 | 208024PL
Preliminaries | Off Site Labour | Contract Administrator | PL | 2 | 08 | 03 | 4 | 208034PL
Preliminaries | Off Site Labour | Project Coordinator | PL | 2 | 08 | 04 | 4 | 208044PL
Preliminaries | Off Site Labour | Estimator | PL | 2 | 08 | 05 | 4 | 208054PL
Preliminaries | Off Site Labour | OH&S Officer | PL | 2 | 08 | 06 | 4 | 208064PL
Preliminaries | Shedding and Facilities | Site Sheds - Weekly Hire | PL | 2 | 09 | 01 | 4 | 209014PL
Preliminaries | Shedding and Facilities | Site Sheds - Transport & Pick-up | PL | 2 | 09 | 02 | 4 | 209024PL
Preliminaries | Shedding and Facilities | Site container - Weekly Hire | PL | 2 | 09 | 03 | 4 | 209034PL
Preliminaries | Shedding and Facilities | Site container - Transport & Pick-up | PL | 2 | 09 | 04 | 4 | 209044PL
Preliminaries | Shedding and Facilities | Portaloo - Weekly Hire | PL | 2 | 09 | 05 | 4 | 209054PL
Preliminaries | Shedding and Facilities | Portaloo - Transport & Pick-up | PL | 2 | 09 | 06 | 4 | 209064PL
Preliminaries | Shedding and Facilities | Amenities - Weekly Hire | PL | 2 | 09 | 07 | 4 | 209074PL
Preliminaries | Shedding and Facilities | Amenities - Transport & Pick-up | PL | 2 | 09 | 08 | 4 | 209084PL
Preliminaries | Shedding and Facilities | Build Temp Internal Sheds and remove on completion | PL | 2 | 09 | 09 | 4 | 209094PL
Preliminaries | Shedding and Facilities | Other Rental Accommodation | PL | 2 | 09 | 10 | 4 | 209104PL
Preliminaries | Shedding and Facilities | Car parking | PL | 2 | 09 | 11 | 4 | 209114PL
Preliminaries | Shedding and Facilities | Furniture | PL | 2 | 09 | 12 | 4 | 209124PL
Preliminaries | Shedding and Facilities | Beverages (Tea/Coffee etc.) | PL | 2 | 09 | 13 | 4 | 209134PL
Preliminaries | Shedding and Facilities | Water Coolers | PL | 2 | 09 | 14 | 4 | 209144PL
Preliminaries | Shedding and Facilities | Safety & First Aid Box | PL | 2 | 09 | 15 | 4 | 209154PL
Trades | Tiling |  | SC | 3 | 01 | 00 | 1 | 301001SC
Trades | Concrete Works |  | SC | 3 | 02 | 00 | 1 | 302001SC
Trades | Masonry Repair Work |  | SC | 3 | 03 | 00 | 1 | 303001SC
Trades | Demolition |  | SC | 3 | 04 | 00 | 1 | 304001SC
Trades | Painting |  | SC | 3 | 05 | 00 | 1 | 305001SC
Trades | Stonework |  | SC | 3 | 06 | 00 | 1 | 306001SC
Trades | Carpentry |  | SC | 3 | 07 | 00 | 1 | 307001SC
Trades | Cladding & Rendering |  | SC | 3 | 08 | 00 | 1 | 308001SC
Services | Blinds & Curtains |  | SC | 4 | 01 | 00 | 1 | 401001SC
Services | Balustrading |  | SC | 4 | 02 | 00 | 1 | 402001SC
Services | Blockwork / Brickwork |  | SC | 4 | 03 | 00 | 1 | 403001SC
Services | [NAME] |  | SC | 4 | 04 | 00 | 1 | 404001SC
Services | Ceiling Work |  | SC | 4 | 05 | 00 | 1 | 405001SC
Services | Glass / Glazing |  | SC | 4 | 06 | 00 | 1 | 406001SC
Services | Hydraulic/Plumbing |  | SC | 4 | 07 | 00 | 1 | 407001SC
Services | Demolition |  | SC | 4 | 08 | 00 | 1 | 408001SC
Services | Doors & Windows |  | SC | 4 | 09 | 00 | 1 | 409001SC
Services | [NAME] |  | SC | 4 | 10 | 00 | 1 | 410001SC
Services | Electrical Services |  | SC | 4 | 11 | 00 | 1 | 411001SC
Services | Kitchen |  | SC | 4 | 12 | 00 | 1 | 412001SC
Services | Access Floors |  | SC | 4 | 13 | 00 | 1 | 413001SC
Services | Landscaping / External Works |  | SC | 4 | 14 | 00 | 1 | 414001SC
Services | Fire Services |  | SC | 4 | 15 | 00 | 1 | 415001SC
Services | Mechanical Services |  | SC | 4 | 16 | 00 | 1 | 416001SC
Services | Metal Works |  | SC | 4 | 17 | 00 | 1 | 417001SC
Services | Partitions / Ceilings / Doors |  | SC | 4 | 18 | 00 | 1 | 418001SC
Services | Roofing |  | SC | 4 | 19 | 00 | 1 | 419001SC
Services | Security |  | SC | 4 | 20 | 00 | 1 | 420001SC
Services | Special Doors |  | SC | 4 | 21 | 00 | 1 | 421001SC
Services | Stairs |  | SC | 4 | 22 | 00 | 1 | 422001SC
Services | Structural Works |  | SC | 4 | 23 | 00 | 1 | 423001SC
Services | Toilet Partitions |  | SC | 4 | 24 | 00 | 1 | 424001SC
Services | Waterproofing Work |  | SC | 4 | 25 | 00 | 1 | 425001SC
Consultants | Concrete Scanning |  | OT | 5 | 01 | 00 | 5 | 501005OT
Consultants | Design |  | OT | 5 | 02 | 00 | 5 | 502005OT
[NAME] or General | Appliances/Whitegoods |  | MT | 6 | 01 | 00 | 3 | 601003MT
[NAME] or General | Loose Furniture |  | MT | 6 | 02 | 00 | 3 | 602003MT
[NAME] or General | Other |  | OT | 6 | 03 | 00 | 5 | 603005OT