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

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 | 10 | 2 | 203102LB | 203102 | LB
Preliminaries | Site Labour | General [NAME] | LB | 2 | 03 | 11 | 2 | 203112LB | 203112 | LB
Preliminaries | Site Labour | Project Allowances (incl LAFHA) | LB | 2 | 03 | 12 | 2 | 203122LB | 203122 | 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 | 10 | 5 | 204105OT | 204105 | OT
Preliminaries | Temporary Services | Site lighting | OT | 2 | 04 | 11 | 5 | 204115OT | 204115 | OT
Preliminaries | Temporary Services | Monthly lead Checks | OT | 2 | 04 | 12 | 5 | 204125OT | 204125 | 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 | 10 | 4 | 205104PL | 205104 | PL
Preliminaries | Access Equipment | External [NAME] | PL | 2 | 05 | 11 | 4 | 205114PL | 205114 | 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 | 10 | 4 | 206104PL | 206104 | PL
Preliminaries | Builder Equipment | Fuel | PL | 2 | 06 | 11 | 4 | 206114PL | 206114 | PL
Preliminaries | Builder Equipment | Miscellaneous Plant | PL | 2 | 06 | 12 | 4 | 206124PL | 206124 | 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 | 10 | 4 | 209104PL | 209104 | PL
Preliminaries | Shedding and Facilities | Car parking | PL | 2 | 09 | 11 | 4 | 209114PL | 209114 | PL
Preliminaries | Shedding and Facilities | Furniture | PL | 2 | 09 | 12 | 4 | 209124PL | 209124 | PL
Preliminaries | Shedding and Facilities | Beverages (Tea/Coffee etc.) | PL | 2 | 09 | 13 | 4 | 209134PL | 209134 | PL
Preliminaries | Shedding and Facilities | Water Coolers | PL | 2 | 09 | 14 | 4 | 209144PL | 209144 | PL
Preliminaries | Shedding and Facilities | Safety & First Aid Box | PL | 2 | 09 | 15 | 4 | 209154PL | 209154 | 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 | 10 | 00 | 1 | 410001SC | 410001 | SC
Services | Electrical Services |  | SC | 4 | 11 | 00 | 1 | 411001SC | 411001 | SC
Services | Kitchen |  | SC | 4 | 12 | 00 | 1 | 412001SC | 412001 | SC
Services | Access Floors |  | SC | 4 | 13 | 00 | 1 | 413001SC | 413001 | SC
Services | Landscaping / External Works |  | SC | 4 | 14 | 00 | 1 | 414001SC | 414001 | SC
Services | Fire Services |  | SC | 4 | 15 | 00 | 1 | 415001SC | 415001 | SC
Services | Mechanical Services |  | SC | 4 | 16 | 00 | 1 | 416001SC | 416001 | SC
Services | Metal Works |  | SC | 4 | 17 | 00 | 1 | 417001SC | 417001 | SC
Services | Partitions / Ceilings / Doors |  | SC | 4 | 18 | 00 | 1 | 418001SC | 418001 | SC
Services | Roofing |  | SC | 4 | 19 | 00 | 1 | 419001SC | 419001 | SC
Services | Security |  | SC | 4 | 20 | 00 | 1 | 420001SC | 420001 | SC
Services | Special Doors |  | SC | 4 | 21 | 00 | 1 | 421001SC | 421001 | SC
Services | Stairs |  | SC | 4 | 22 | 00 | 1 | 422001SC | 422001 | SC
Services | Structural Works |  | SC | 4 | 23 | 00 | 1 | 423001SC | 423001 | SC
Services | Toilet Partitions |  | SC | 4 | 24 | 00 | 1 | 424001SC | 424001 | SC
Services | Waterproofing Work |  | SC | 4 | 25 | 00 | 1 | 425001SC | 425001 | 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