{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["concession"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"concession","index":0,"n_rows":166,"n_cols":8,"rows_kept":166,"cut":false,"hidden":false,"merged":[[4,1,5,1]]}
[]
[]
[]
[null,"Name of Health Facility -------------Concession Hospital"]
[null,"Item Description","Quantity required","Unit","Unit Cost ","Total Cost","VAT (if Any)","Total Cost "]
[{"$nulls":4},"       $","       $"]
["Annexure 1","Preliminary ",1,"Sum",null,{"$f":"E7*C7","v":0},null,{"$f":"G7+F7","v":0}]
[]
[null,"Brickwork "]
[]
[null,"Brick up window opening with one brick wall ",3,"m2",null,{"$f":"C11*E11","v":0},null,{"$f":"G11+F11","v":0}]
[null,"brick reinforcement ",8,"m",null,{"$f":"C12*E12","v":0},null,{"$f":"G12+F12","v":0}]
[{"$nulls":5},0,null,0]
[{"$nulls":5},0,null,0]
[{"$nulls":5},0,null,0]
[{"$nulls":5},0,null,0]
[{"$nulls":5},0,null,0]
[{"$nulls":5},0,null,0]
[]
[]
[]
[{"$nulls":5},{"$f":"C22*E22","v":0},null,{"$f":"G22+F22","v":0}]
[{"$nulls":5},0,null,0]
[null,"Supply & fitting of lead lined operators booth",null,null,null,0,null,0]
["Annexure 2","lead lined sliding door 1500*2030mm",1,"No.",null,0,null,0]
[null,"lead lined white mellamine control booth 2030mm ",1,"No.",null,0,null,0]
[null,"computer shelving ",1,"No.",null,0,null,0]
[null,"iron mongery ",null,null,null,0,null,0]
[null,"sliding door lock ",1,"No.",null,0,null,0]
[null,"radiation warning sign in three languages ",3,"No.",null,0,null,0]
[{"$nulls":5},0,null,0]
[null,"plastering and wall linings ",null,null,null,0,null,0]
[null,"plastering on walls",3,"m2",null,0,null,0]
[null,"ditto in narrow width",1,"m2",null,0,null,0]
[{"$nulls":5},0,null,0]
[null,"ceramic wall tiles",1,"m2",null,0,null,0]
[{"$nulls":5},0,null,0]
[null,"Pavings and floor covering ",null,null,null,0,null,0]
[null,"continuous vnyl sheet flooring ",null,null,null,0,null,0]
[null,"on floors",38,"m2",null,0,null,0]
[null,"labour and material in turning tiles up covered fillet for a height of 100metres",30,"m2",null,0,null,0]
[null,"alluminium division strip ",4,"m",null,0,null,0]
[{"$nulls":5},0,null,0]
[null,"sheet metal work rainwater disposal plumbing and drainage",1,"Item",null,0,null,0]
[null,"allow for testing",1,"Item",null,0,null,0]
[{"$nulls":5},0,null,0]
[null,"Painting ",null,null,null,0,null,0]
[null,"on prepared walls ",33,"m2",null,0,null,0]
[null,"on prepared ceilings and cornices ",35,"m2",null,0,null,0]
[null,"touch up and clean paint work ",1,"Item",null,0,null,0]
[{"$nulls":5},0,null,0]
[null,"Demolitions and alterations",1,"Item",null,0,null,0]
[{"$nulls":5},0,null,0]
[{"$nulls":5},0,null,0]
[{"$nulls":5},0,null,0]
["Annexure 3","Supply & fitting of power distribution Cabinet",1,"Item",null,0,null,0]
[null,"·         Enclosure DB",null,null,null,0,null,0]
[null,"·         MCB 100A Triple Pole",null,null,null,0,null,0]
[null,"           On/Off Switch",null,null,null,0,null,0]
[null,"           Indicator Lamps",null,null,null,0,null,0]
[null,"           100A 3 pole breaker",null,null,null,0,null,0]
[null,"·         Contactor 100A Triple Pole",null,null,null,0,null,0]
[null,"Electricals ",null,null,null,0,null,0]
[null,"Supply and lay 3 phase wiring to DB",null,null,null,0,null,0]
[null,"25mm 4 Core swa cable 100m ",100,"m",null,0,null,0]
[null,"25 sbcc",100,"m",null,0,null,0]
[null,"25sqmm SBCC Separate earth ",100,"m",null,0,null,0]
[{"$nulls":5},0,null,0]
[null,"2.5sqmm single core conductor (cafca or similar approved type) Red",100,"m",null,0,null,0]
[null,"2.5sqmm single core conductor (cafca or similar approved type) Earthwire",100,"m",null,0,null,0]
[null,"2.5sqmm single core conductor (cafca or similar approved type) Black",100,"m",null,0,null,0]
[null,"MCBs & Isolators ",null,null,null,0,null,0]
[null,"100A Triple pole MCB",1,"No.",null,0,null,0]
[null,"20A Single pole MCB",1,"No.",null,0,null,0]
[null,"10A Single pole  MCB ",2,"No.",null,0,null,0]
[null,"10A Single pole  isolator extractor fan",2,"No.",null,0,null,0]
[null,"100A Triple pole isolator",1,"No.",null,0,null,0]
[null,"Trunking and Cable tray",null,null,null,0,null,0]
[null,"1 compartment 75mm *50mm skirting",2,"No.",null,0,null,0]
[null,"I compartment skirting trunking 90",1,"No.",null,0,null,0]
[null,"I compartment skirting  T piece",1,"No.",null,0,null,0]
[null,"I compartment trunking end cap",3,"No.",null,0,null,0]
[null,"50mm cable tray",4,"No.",null,0,null,0]
[null,"50mm cable tray mounting space bars",10,"No.",null,0,null,0]
[null,"50mm cable tray 90 degree bend ",2,"No.",null,0,null,0]
[null,"50mm cable tray T piece ",1,"No.",null,0,null,0]
[null,"50*50 trunking ",4,"No.",null,0,null,0]
[null,"Socket outlets",null,null,null,0,null,0]
[null,"Double socket outlet",3,"No.",null,0,null,0]
[null,"double 36w 1200mm fluo fitting",3,"No.",null,0,null,0]
[null,"double 18w 600m fluo c/w tubes",1,"No.",null,0,null,0]
[null,"5A gang 1 way switch",1,"No.",null,0,null,0]
[null,"Accessories ",null,null,null,0,null,0]
[null,"SF6 Fisher plugs ",2,"No.",null,0,null,0]
[null,"100mm cable ties ",30,"No.",null,0,null,0]
[null,"4mm*35mm woodscrews",1,"No.",null,0,null,0]
[null,"BE Saddles 20mm",50,"No.",null,0,null,0]
[null,"20mm pvc conduits",12,"Lengths",null,0,null,0]
[null,"20mm pvc coupling",50,"No.",null,0,null,0]
[null,"20mm pvc nipples ",50,"No.",null,0,null,0]
[null,"20mm pvc adaptor",1,"No.",null,0,null,0]
[null,"verandah bolts 10mm*50mm",10,"No.",null,0,null,0]
[null,"expansion bolts 10mm*50mm ",4,"No.",null,0,null,0]
[null,"size gland shroud",8,"No.",null,0,null,0]
[{"$nulls":5},0,null,0]
[null,"Additional ",null,null,null,0,null,0]
[null,"16mm 4 core swa cable",30,"m",null,{"$f":"C107*E107","v":0},null,{"$f":"G107+F107","v":0}]
[null,"16mm  earthwire",30,"m",null,0,null,0]
[null,"PVC grey trunking ",5,"m",null,0,null,0]
[null,"M8*65mm Rawl bolts*20",20,"No.",null,0,null,0]
[null,"extractor fan",2,"No.",null,0,null,0]
[{"$nulls":5},0,null,0]
[]
[]
[]
[]
[{"$nulls":5},0,null,0]
[null,"Total",null,null,null,{"$f":"SUM(F55:F117)","v":0},{"$f":"SUM(G55:G117)","v":0},{"$f":"SUM(H7:H117)","v":0}]
[]
[null,"contigency 5%",{"$nulls":5},{"$f":"H118*0.05","v":0}]
[null,"Price on bill of quantities."]
[null,"Electricals",14373]
[null,"  Bill 1.               preliminary and generally                      ",4094.2]
[null,"Bill 2.                brickwork",166.46]
[null,"Bill 3.                 Joinery and iron mongery",11746.83]
[null,"Bill 4.                Metal work",96.84]
[null,"Bill 5.                 Paving and floor covering",5271.8]
[null,"Bill 6.                 plastering and wall lining",385]
[null,"Bill 7.                  painting ",1118]
[null,"Bill 8.                 Demoliation and alteration ",1261.3599999999999]
[null,null,{"$f":"SUM(C122:C130)","v":38513.49}]
[null,"contigency 10%",{"$f":"C131*0.1","v":3851.3490000000002}]
[null,null,{"$f":"SUM(C131:C132)","v":42364.839}]
[null,"vat 15%",{"$f":"C133*0.15","v":6354.7258499999998}]
[null,"Total ",{"$f":"SUM(C133:C134)","v":48719.564850000002}]
[]
[]
[]
[]
[{"$nulls":5},"Expected profit"]
[null,"Deinstallation",50,null,50,{"$f":"E141-C141","v":0}]
[null,"electricals ",{"$f":"9149-985","v":8164},null,{"$f":"14373-985+150","v":13538},{"$f":"E142-C142","v":5374}]
[null,"eletrician cost ",900,null,900,0]
[null,"fitting booth",{"$f":"4200-985","v":3215},null,{"$f":"6253-985","v":5268},2053]
[null,"lead double doors ",{"$f":"3000-984","v":2016},null,{"$f":"4653.45-984","v":3669.45},1653.4499999999998]
[null,"computer shelf",546,null,{"$f":"C146*1.5","v":819},273]
[null,"tiler ",1245,null,1867.5,622.5]
[null,"tile and carpet ",2797,null,4195.5,1398.5]
[null,"building material ",2549,null,3823.5,1274.5]
[null,"builder",800,null,1200,400]
[null,"extractor fans ",1610,null,2415,805]
[null,"Labour 7days @50/day",3220,null,3220,0]
[null,"accommodation $60*3",1449,null,1449,0]
[null,"mileage             114*0.3",43,null,null,-43]
[null,null,{"$f":"SUM(C142:C154)","v":28554},null,{"$f":"SUM(E142:E154)","v":42364.95},13810.949999999997]
[{"$nulls":4},{"$f":"E155-C133","v":0.11099999999714782}]
[]
[]
[{"$nulls":4},{"$f":"E156/3","v":3.6999999999049273E-2}]
[]
[]
[null,"Subtotal A ",{"$nulls":5},{"$f":"H118+H120","v":0}]
[]
[null,"Vat 15%",{"$nulls":5},{"$f":"H162*0.15","v":0}]
[]
[null,"Grand Total ",{"$nulls":5},{"$f":"H162+H164","v":0}]