{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["P&G","B.o.Q","SUMMARY","Paid to date"],"not_rendered":{"external_links":4,"defined_names":193,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"P&G","index":0,"n_rows":42,"n_cols":8,"rows_kept":42,"merged":[[1,1,1,7],[3,1,3,7],[5,3,6,3],[5,4,6,4],[5,7,6,7],[16,6,17,6],[16,7,17,7],[41,1,41,6]]}
[]
[null,"LOWVELD NATIONAL BOTANICAL GARDENI TENDER XXX"]
[]
[null,"LOWVELD NATIONAL BOTANICAL GARDENI  XXX:  SECTION A "]
[]
[null,"ITEM","PAYMENT",null,"UNIT","BILL","SELLING ","SCHEDULED AMOUNT"]
[null,"NO.","REFERS",null,null,"QTY","RATE"]
[null,null,"SABS 1200 AA","SECTION A: PRELIMINARY & GENERAL"]
[]
[null,"A.1",null,"FIXED CHARGE ITEMS"]
[null,"A.1.1",null,"Contractual Requirements","Sum",1,null,{"$f":"F11*G11","v":0}]
[]
[null,"A.1.3",null,"Facilities for contractor"]
[{"$nulls":3},"Office and storage sheds","Sum",1,null,{"$f":"F14*G14","v":0}]
[{"$nulls":3},"Ablution and latrine facilities","Sum",1,null,0]
[{"$nulls":3},"Tools and equipment","Sum",1,null,0]
[{"$nulls":3},"Water supplies, electric power and","Sum",1,null,0]
[{"$nulls":3},"communications"]
[{"$nulls":3},"Camp area","Sum",1,null,{"$f":"F19*G19","v":0}]
[]
[null,"A.1.4",null,"Other fixed-charge obligations","Sum",1,null,{"$f":"F21*G21","v":0}]
[{"$nulls":3},"Environmental Management Programme - The rate shall cover all costs necessary in complying generally with the Environmental Management Plan","Sum",1,null,{"$f":"F22*G22","v":0}]
[{"$nulls":3},"Environmental Assessment Professional ","PC Sum",1,{"v":180000,"d":"R180,000.00"}]
[{"$nulls":3},"Handling costs and profit in respect of subitem above","%",null,{"$f":"I22","v":0}]
[{"$nulls":3},"Health & Safety plan - The sum shall cover all initial costs necessary in complying with the Occupational Health and Safety Act and the Construction Regulations, and preparation of a Health and Safety Plan","Sum",1,null,{"$f":"F25*G25","v":0}]
[]
[null,"A.1.5",null,"Removal of Site Establishment","Sum",1,null,{"$f":"F27*G27","v":0}]
[]
[null,"A.2",null,"TIME RELATED ITEMS"]
[null,"A.2.1",null,"Contractual requirements","Mons",2,null,{"$f":"F30*G30","v":0}]
[null,"A.2.2",null,"Operate and maintain facilities on site","Mons",2,null,{"$f":"F31*G31","v":0}]
[]
[]
[]
[null,"A.2.6",null,"Supervision for duration of the contract","Mons",2,null,{"$f":"F35*G35","v":0}]
[null,"A.2.7",null,"Employer's Occupational Health & Safety Agent ","PC Sum",1,{"v":50000,"d":"R50,000.00"}]
[{"$nulls":3},"Handling costs and profit in respect of subitem above","%",null,{"$f":"I35","v":0}]
[]
[{"$nulls":3},"Detection  and relocation of Existing services as directed by the employer","Sum",1,null,{"$f":"F39*G39","v":0}]
[]
[]
[null,"TOTAL FOR SECTION A TO SUMMARY SHEET"]

{"sheet":"B.o.Q","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"merged":[[1,1,1,7],[3,1,3,7],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,7,6,7],[39,1,39,6],[42,1,42,6]]}
[]
[null,{"$f":"'P&G'!B2:H2","v":"LOWVELD NATIONAL BOTANICAL GARDENI TENDER XXX"}]
[]
[null,"LOWVELD NATIONAL BOTANICAL GARDENI  XXX: SECTION B"]
[]
[null,"ITEM","PAYMENT",null,"UNIT","BILL","SELLING ","SCHEDULED AMOUNT"]
[null,"NO.","REFERS",null,null,"QTY","RATE"]
[{"$nulls":3},"SURVEYING"]
[{"$nulls":3},"Conduct survey in terms of the Land Survey Act and peg out site boundary and produce a construction drawing and as-built drawing.","Sum",1,null,{"$f":"F9*G9","v":0}]
[{"$nulls":3},"GABIONS  "]
[null,null,"1200 C","SITE CLEARANCE"]
[null,null,821,"Clear and grub stream bed and sides","m2",108,null,{"$f":"F12*G12","v":0}]
[]
[null,null,"1200 DA","EARTHWORKS (SMALL WORKS)"]
[null,null,832,"Excavate in all materials and backfill or place in embankment and com- pact","m3",{"$f":"(F12*0.6)*0.6","v":38.879999999999995},null,{"$f":"F15*G15","v":0}]
[null,null,834,"Import material from commercial sources to complete embankment","m³",{"$f":"(F12*0.3)*0.4","v":12.96},null,{"$f":"F16*G16","v":0}]
[null,null,"1200 DK","GABIONS & RINO MATTRESSES"]
[null,null,821,"Dismantle of the exiting gabions,pile the stones for future use and transport gabion cage to the disposal site.","m³",68,null,{"$f":"F18*G18","v":0}]
[null,null,"821a","Import G5 material from commercial sources to complete embankment","m³",10]
[null,null,"821b","Soilcrete to edge of slopes at top of Gabion structures","m3",10]
[null,null,822,"Surface preparation for bedding of gabions","m²",108,null,{"$f":"F21*G21","v":0}]
[null,null,823,"Construct gabions using galvanised PVC coated wire mesh"]
[{"$nulls":3},"108 (1 x 1 x 0.5 m) Gabion baskets Class A galvanised hexagonal mesh unit , filled champaign gabion rocks at the front rows. ranging from 100mm to 250mm sizes,neatly packed.","m³",54,null,{"$f":"F23*G23","v":0}]
[]
[{"$nulls":3},"108 (0.5 x 0.5 x 1 m) Gabion baskets Class A galvanised hexagonal mesh unit , filled with existing gabion rocks at the back rows. ranging from 100mm to 250mm sizes,neatly packed. ","m³",27,null,{"$f":"F25*G25","v":0}]
[]
[{"$nulls":3},"33 (1 x 1 x 1 m) Gabion baskets class A galvanised hexagonal mesh unit , filled with existing gabion rocks at the back rows. ranging from 100mm to 250mm sizes,neatly packed. ","m³",{"$f":"(1*1*1*33)","v":33},null,{"$f":"F27*G27","v":0}]
[]
[{"$nulls":3},"33 (1.5 x 1 x 1 m ) Gabion baskets Class A galvanised hexagonal mesh unit , filled with existing gabion rocks at the back rows. ranging from 100mm to 250mm sizes,neatly packed. ","m³",{"$f":"(1.5*1*1*33)","v":{"v":49.5,"d":"50"}},null,{"$f":"F29*G29","v":0}]
[]
[{"$nulls":3},"1x1x0.3m (108) Reno mattres of section ","m³",32,null,{"$f":"F31*G31","v":0}]
[]
[null,null,824,"Extra over items 3.2.2 & 3.2.3 for selected stone on wall face facing stream.","m²",1]
[]
[]
[null,null,825,"Geotextile Bidum A5 (or similar)"]
[{"$nulls":3},"Below matress & baskets","m²",108,null,{"$f":"F37*G37","v":0}]
[{"$nulls":3},"Behind gabions wall","m²",108,null,{"$f":"F38*G38","v":0}]
[]
[null,"Sub Total A",{"$nulls":5},{"$f":"H38+H37+H31+H29+H27+H25+H23+H21+H18+H18+H18+H18+H16+H15+H12+H9","v":0}]
[]
[]
[null,"TOTAL OF SECTION M TO SUMMARY SHEET (A+B)",{"$nulls":5},{"$f":"H40","v":0}]

{"sheet":"SUMMARY","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"merged":[[1,1,1,3]]}
[]
[null,"SUMMARY OF SCHEDULES"]
[null,"SECTION ","DESCRIPTION","AMOUNT"]
[null,1,{"$f":"'P&G'!D8","v":"SECTION A: PRELIMINARY & GENERAL"}]
[]
[null,2,"SECTION B: GABIONS & MATTRESSES"]
[]
[null,null,"SUB TOTAL A"]
[]
[null,null,"CONTINGENCIES AT 10%"]
[]
[null,null,"SUB TOTAL B"]
[]
[null,null,"VAT @ 15%"]
[]
[null,null,"TOTAL CARRIED TO FORM OF OFFER"]

{"sheet":"Paid to date","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true,"merged":[[2,0,2,2],[2,3,2,4],[3,0,3,2],[3,3,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,2],[6,3,6,4],[7,0,7,2],[8,0,8,2],[9,0,9,2]]}
["Paid to date (as per KP 06.12.2011)"]
[]
["TCP Professional Service",null,null,{"v":740000,"d":"R 740,000.00"}]
["Design & Review",null,null,{"$f":"211200+423808","v":{"v":635008,"d":"R 635,008.00"}}]
["Project Management",null,null,{"v":213305,"d":"R 213,305.00"}]
["Firm Commitment (FOREX)",null,null,{"v":-658105.45,"d":"-R 658,105.45"}]
[{"$nulls":3},{"$f":"SUM(D3:E6)","v":{"v":930207.55,"d":"R 930,207.55"}}]