Spreadsheet: 882948d1731425807-construction-example-data-need-to-split-data-from-columns-into-rows-subs-extract
Sheet: Example

 | [NAME] |  |  |  |  |  |  |  |  |  | DESIRED OUTPUT
 | Ref | Description | Sum | % | Applied | Comments |  |  |  |  | Ref | Division | Sub 1 | Sub 2 | Sub 3 | Description | Sum | % | Applied
 |  | D GROUNDWORK |  |  |  |  |  |  |  |  | 3/1/C | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Basements and the like | maximum depth not exceeding 10.00m; commencing from formation level | 8320 | 0.8168798076923077
 |  | D20: EXCAVATING AND FILLING |  |  |  |  |  |  |  |  | 3/1/D | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Basements and the like | maximum depth not exceeding 12.00m; commencing from formation level | 12200 | 0.9680622950819671
 |  | Excavating |  |  |  |  |  |  |  |  | 3/1/E | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Basements and the like | rock | 85429.5 | 0.9067641325536062
 |  | Basements and the like |  |  |  |  |  |  |  |  |  | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Basements and the like | VE: Quantity by 25% | -21352.5 | 0.9067641325536062
 | 3/1/C | maximum depth not exceeding 10.00m; commencing from formation level | 8320 |  |  |  |  |  |  |  | 3/1/F | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Breaking out existing floor slabs; extra over any types of excavating irrespective of depth | reinforced concrete 200 thick | 1470 | 1
 | 3/1/D | maximum depth not exceeding 12.00m; commencing from formation level | 12200 |  |  |  |  |  |  |  | 3/1/G | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Working space allowance to excavation; including additional earthwork support, disposal and backfilling with plain in-situ concrete; B.S.8500, designed mix GEN 3, 20N/mm2, 20 aggregate; formwork to one side to provide flush finish | reduced levels basements and the like | Elsewhere |  | 0
 |  | Breaking out existing materials; extra over any types of excavation irrespective of depth |  |  |  |  |  |  |  |  | 3/1/H | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Earthwork support | maximum depth not exceeding 1.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  | 0
 | 3/1/E | rock | 85429.5 |  |  |  |  |  |  |  |  | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Earthwork support | VE: BGR excavate staircases as progress nailing / pinning | -1768 | 0.94235
 |  | VE: Quantity by 25% | -21352.5 |  |  |  |  |  |  |  | 3/2/A | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Earthwork support | maximum depth not exceeding 2.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  | 0
 |  | Breaking out existing floor slabs; extra over any types of excavating irrespective of depth |  |  |  |  |  |  |  |  | 3/2/B | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Earthwork support | maximum depth not exceeding 4.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  | 0
 | 3/1/F | reinforced concrete 200 thick | 1470 | 1 |  |  |  |  |  |  | 3/2/C | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Earthwork support | maximum depth not exceeding 10.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  | 0
 |  | Working space allowance to excavation; including additional earthwork support, disposal and backfilling with plain in-situ concrete; B.S.8500, designed mix GEN 3, 20N/mm2, 20 aggregate; formwork to one side to provide flush finish |  |  |  |  |  |  |  |  | 3/2/D | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Earthwork support | maximum depth not exceeding 12.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  | 0
 | 3/1/G | reduced levels basements and the like | Elsewhere |  |  |  |  |  |  |  | 3/2/E | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Disposal of water | surface water | Elsewhere |  | 0
 |  | Earthwork support |  |  |  |  |  |  |  |  | 3/2/F | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Trimming | rock to produce fair or exposed face | Elsewhere |  | 0
 | 3/1/H | maximum depth not exceeding 1.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  |  |  |  |  |  |  | 3/2/G1 | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Disposal of excavated material | off site; RATE ONLY | 0
 |  | VE: BGR excavate staircases as progress nailing / pinning | -1768 |  |  |  |  |  |  |  | 3/2/G2 | D GROUNDWORK | D20: EXCAVATING AND FILLING | Excavating | Disposal of excavated material | on site; adjacent field | 194940 | 0.9067641325536062
 | 3/2/A | maximum depth not exceeding 2.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  |  |  |  |  |  |  | 3/2/H | D GROUNDWORK | D30: PILING | Piling; this section of the [NAME] is to be covered by the Contractor's Design Portion of the JCT Standard Building Contract as amended. All in accordance with Rothwell's specification and drawings | Design and Preliminary Costs | include for pre and post contract design and preliminary costs associated with this section of the Works | Elsewhere |  | 0
 | 3/2/B | maximum depth not exceeding 4.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  |  |  |  |  |  |  | 3/2/I | D GROUNDWORK | D30: PILING | Piling; this section of the [NAME] is to be covered by the Contractor's Design Portion of the JCT Standard Building Contract as amended. All in accordance with Rothwell's specification and drawings | Piling | piling as Structural Engineer's drawing No. 14169/L00 | Elsewhere |  | 0
 | 3/2/C | maximum depth not exceeding 10.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  |  |  |  |  |  |  | 3/2/K | D GROUNDWORK | D30: PILING | Piling; this section of the [NAME] is to be covered by the Contractor's Design Portion of the JCT Standard Building Contract as amended. All in accordance with Rothwell's specification and drawings | Piling | protection of all the foregoing works | Elsewhere |  | 0
 | 3/2/D | maximum depth not exceeding 12.00m; distance between opposing faces exceeding 4.00m | Elsewhere |  |  |  |  |  |  |  | 3/4/A | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Beds; poured on or against earth or unblinded hardcore | thickness not exceeding 150 | 9487.75 | 0
 |  | Disposal of water |  |  |  |  |  |  |  |  | 3/4/B | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Beds | thickness exceeding 450 | 115185 | 0
 | 3/2/E | surface water | Elsewhere |  |  |  |  |  |  |  |  | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Slabs | VE: Thickness 600mm to 500mm (100mm reduction) | -25410 | 0
 |  | Trimming |  |  |  |  |  |  |  |  | 3/4/C | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Slabs | thickness exceeding 450 | 79477.65 | 0
 | 3/2/F | rock to produce fair or exposed face | Elsewhere |  |  |  |  |  |  |  |  | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Slabs | VE: Thickness 600mm to 500mm (100mm reduction) | -17532.9 | 0
 |  | Disposal of excavated material |  |  |  |  |  |  |  |  | 3/4/D | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Slabs | thickness 150-450 | 6625.62 | 0
 | 3/2/G1 | off site; RATE ONLY | 0 |  |  |  |  |  |  |  | 3/4/E | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Walls | thickness exceeding 450 | 232336.8 | 0
 | 3/2/G2 | on site; adjacent field | 194940 |  |  |  |  |  |  |  |  | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Walls | VE: Thickness 600mm to 300mm (300mm reduction) | -145962.63 | 0
 |  | D30: PILING |  |  |  |  |  |  |  |  | 3/4/F | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Walls | thickness 150-450 | 58051.08 | 0
 |  | Piling; this section of the [NAME] is to be covered by the Contractor's Design Portion of the JCT Standard Building Contract as amended. All in accordance with Rothwell's specification and drawings |  |  |  |  |  |  |  |  | 3/4/G | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate | Testing Concrete | in accordance with B.S.1881 and specification clauses | 286.31 | 0
 |  | Design and Preliminary Costs |  |  |  |  |  |  |  |  | 3/4/H | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Edges of suspended slabs; plain vertical | height 250 - 500 | 1319.37 | 0
 | 3/2/H | include for pre and post contract design and preliminary costs associated with this section of the Works | Elsewhere |  |  |  |  |  |  |  | 3/4/J | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Edges of suspended slabs; plain vertical | height 500 - 1.00m | 2551.68 | 0
 |  | Piling |  |  |  |  |  |  |  |  | 3/4/K | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Steps in top surfaces; plain vertical | height not exceeding 250 | 203 | 0
 | 3/2/I | piling as Structural Engineer's drawing No. 14169/L00 | Elsewhere |  |  |  |  |  |  |  | 3/4/L | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Steps in soffits; plain vertical | height 250 - 500 | 276.75 | 0
 | 3/2/K | protection of all the foregoing works | Elsewhere |  |  |  |  |  |  |  | 3/4/M | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Soffits of slabs; horizontal | slab thickness 200 - 300; height to soffit 6.00 - 7.50m | 6197.89 | 0
 |  |  |  |  |  |  |  |  |  |  | 3/4/N | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Soffits of slabs; horizontal | slab thickness 500 - 600; height to soffit 6.00 - 7.50m | 49585.23 | 0
 |  | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE |  |  |  |  |  |  |  |  | 3/4/P | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Walls; vertical | plain | 1019.76 | 0
 |  | E10: MIXING/CASTING/CURING/IN-SITU CONCRETE |  |  |  |  |  |  |  |  | 3/5/A | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Walls; vertical | plain; to one side only; wall 600 thick; other side upheld by formwork and fair finish (formwork and fair finish measured elsewhere) | 885.36 | 0
 |  | Plain in-situ concrete; B.S.8500, designed mix GEN 1, 10N/mm2, 20 aggregate |  |  |  |  |  |  |  |  | 3/5/B | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork and basic finish | Wall kickers | straight | 104.2 | 0
 |  | Beds; poured on or against earth or unblinded hardcore |  |  |  |  |  |  |  |  | 3/5/C | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Walls; vertical | plain | 3132.12 | 0
 | 3/4/A | thickness not exceeding 150 | 9487.75 | 0 |  |  |  |  |  |  | 3/5/D | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Walls; vertical | plain; to one side only; wall 250 thick; other side upheld by insulation | 24592.2 | 0
 |  | Reinforced Sika waterproof in-situ concrete; B.S.8500, designed mix RC32/40, 35N/mm2, 20 aggregate; vibrated |  |  |  |  |  |  |  |  | 3/5/E | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Walls; vertical | plain; to one side only; wall 300 thick; other side upheld by insulation | 28787.34 | 0
 |  | Beds |  |  |  |  |  |  |  |  | 3/5/F | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Walls; vertical | plain; to one side only; wall 350 thick; other side upheld by insulation | 10994.16 | 0
 | 3/4/B | thickness exceeding 450 | 115185 | 0 |  |  |  |  |  |  | 3/5/G | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Walls; vertical | plain; to one side only; wall 480 thick; other side upheld by insulation | 5017.04 | 0
 |  | Slabs |  |  |  |  |  |  |  |  | 3/5/H | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Walls; vertical | plain; to one side only; wall 600 thick; other side upheld by insulation | 129705.24 | 0
 |  | VE: Thickness 600mm to 500mm (100mm reduction) | -25410 | 0 |  |  |  |  |  |  | 3/5/J | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Walls; vertical | plain; to one side only; wall 600 thick; other side upheld by formwork and basic finish (formwork and basic finish measured elsewhere) | 655.5600000000001 | 0
 | 3/4/C | thickness exceeding 450 | 79477.65 | 0 |  |  |  |  |  |  | 3/5/K | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Walls; vertical | extra; pockets; profile as Engineer's drawing No. 14169/S01; pocket detail; 3nr | 1230.24 | 0
 |  | VE: Thickness 600mm to 500mm (100mm reduction) | -17532.9 | 0 |  |  |  |  |  |  | 3/5/L | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Wall kickers | straight | 416.8 | 0
 | 3/4/D | thickness 150-450 | 6625.62 | 0 |  |  |  |  |  |  | 3/5/M | E IN-SITU CONCRETE / LARGE PRECAST CONCRETE | E20: FORMWORK FOR IN-SITU CONCRETE | Formwork NBS E20/640 | Suspended wall kickers | straight | 4393.1 | 0
 |  | Walls
 | 3/4/E | thickness exceeding 450 | 232336.8 | 0
 |  | VE: Thickness 600mm to 300mm (300mm reduction) | -145962.63 | 0
 | 3/4/F | thickness 150-450 | 58051.08 | 0
 |  | Testing Concrete
 |  | Allow for providing concrete test cubes
 | 3/4/G | in accordance with B.S.1881 and specification clauses | 286.31
 |  | E20: FORMWORK FOR IN-SITU CONCRETE
 |  | Formwork and basic finish
 |  | Edges of suspended slabs; plain vertical
 | 3/4/H | height 250 - 500 | 1319.37 | 0
 | 3/4/J | height 500 - 1.00m | 2551.68 | 0
 |  | Steps in top surfaces; plain vertical
 | 3/4/K | height not exceeding 250 | 203 | 0
 |  | Steps in soffits; plain vertical
 | 3/4/L | height 250 - 500 | 276.75 | 0
 |  | Soffits of slabs; horizontal
 | 3/4/M | slab thickness 200 - 300; height to soffit 6.00 - 7.50m | 6197.89 | 0
 | 3/4/N | slab thickness 500 - 600; height to soffit 6.00 - 7.50m | 49585.23 | 0
 |  | Walls; vertical
 | 3/4/P | plain | 1019.76 | 0
 | 3/5/A | plain; to one side only; wall 600 thick; other side upheld by formwork and fair finish (formwork and fair finish measured elsewhere) | 885.36 | 0
 |  | Wall kickers
 | 3/5/B | straight | 104.2 | 0
 |  | Formwork NBS E20/640
 |  | Walls; vertical
 | 3/5/C | plain | 3132.12 | 0
 | 3/5/D | plain; to one side only; wall 250 thick; other side upheld by insulation | 24592.2 | 0
 | 3/5/E | plain; to one side only; wall 300 thick; other side upheld by insulation | 28787.34 | 0
 | 3/5/F | plain; to one side only; wall 350 thick; other side upheld by insulation | 10994.16 | 0
 | 3/5/G | plain; to one side only; wall 480 thick; other side upheld by insulation | 5017.04 | 0
 | 3/5/H | plain; to one side only; wall 600 thick; other side upheld by insulation | 129705.24 | 0
 | 3/5/J | plain; to one side only; wall 600 thick; other side upheld by formwork and basic finish (formwork and basic finish measured elsewhere) | 655.5600000000001 | 0
 | 3/5/K | extra; pockets; profile as Engineer's drawing No. 14169/S01; pocket detail; 3nr | 1230.24 | 0
 |  | Wall kickers
 | 3/5/L | straight | 416.8 | 0
 |  | Suspended wall kickers
 | 3/5/M | straight | 4393.1 | 0
 | Carried forward to Summary