{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["Annex C","Annex D","Annex E","Building & Plumbing BOQ","Electrical BOQ","Mechanical BOQ"],"not_rendered":{"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Annex C","index":0,"n_rows":30,"n_cols":17,"rows_kept":30,"merged":[[6,5,6,8],[6,15,7,16],[7,5,7,8],[8,5,8,8],[9,5,9,8],[10,5,10,8],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":16},"SATS 1286.2011"]
[{"$nulls":3},"Annex C"]
[]
[{"$nulls":3},"Local Content Declaration - Summary Schedule "]
[]
[null,null,"(C1)","Tender No.",{"$nulls":11},"Note: VAT to be excluded from all calculations"]
[null,null,"(C2)","Tender description: "]
[null,null,"(C3)","Designated product(s)"]
[null,null,"(C4)","Tender Authority:"]
[null,null,"(C5)","Tendering Entity name:"]
[null,null,"(C6)","Tender Exchange Rate:",null,"Pula",null,"EU",null,"GBP"]
[null,null,"(C7)","Specified local content %"]
[{"$nulls":6},"Calculation of local content",{"$nulls":6},"Tender  summary"]
[{"$nulls":3},"Tender item no's","List of items",null,"Tender price - each \n(excl VAT)","Exempted imported value","Tender value  net of exempted imported  content","Imported value","Local value","Local content % (per item)",null,"Tender Qty","Total tender value","Total exempted imported content","Total Imported content"]
[{"$nulls":3},"(C8)","(C9)",null,"(C10)","(C11)","(C12)","(C13)","(C14)","(C15)",null,"(C16)","(C17)","(C18)","(C19)"]
{"$rows_empty":8}
[{"$nulls":13}," (C20)  Total tender  value"]
[{"$nulls":3},"Signature of tenderer ",{"$nulls":10},"(C21) Total Exempt imported content"]
[{"$nulls":14},"(C22) Total Tender value net of exempt imported content"]
[{"$nulls":15},"(C23) Total Imported content"]
[{"$nulls":15},"(C24) Total local content"]
[{"$nulls":3},"Date: ",{"$nulls":11},"(C25) Average local content % of tender"]

{"sheet":"Annex D","index":1,"n_rows":59,"n_cols":16,"rows_kept":59,"merged":[[6,10,8,11],[13,2,13,6],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[20,13,21,15],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[36,2,36,6],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[47,6,47,7],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[57,13,58,15]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":15},"SATS 1286.2011"]
[null,null,"Annex D"]
[]
[null,null,"Imported Content Declaration - Supporting Schedule to Annex C"]
[]
[null,"(D1)","Tender No.",{"$nulls":7},"Note: VAT to be excluded from all calculations"]
[null,"(D2)","Tender description: "]
[null,"(D3)","Designated Products:"]
[null,"(D4)","Tender Authority:"]
[null,"(D5)","Tendering Entity name:"]
[null,"(D6)","Tender Exchange Rate:",null,"Pula",null,"EU",null,"GBP"]
[]
[null,null,"A. Exempted imported content",{"$nulls":4},"Calculation of imported content",{"$nulls":6},"Summary"]
[null,null,"Tender item no's","Description of imported content",null,"Local supplier","Overseas Supplier","Forign currency value as per Commercial Invoice","Tender   Exchange Rate","Local value of imports","Freight costs to port of entry","All locally incurred landing costs & duties","Total landed cost excl VAT",null,"Tender Qty","Exempted imported value"]
[null,null,"(D7)","(D8)",null,"(D9)","(D10)","(D11)","(D12)","(D13)","(D14)","(D15)","(D16)",null,"(D17)","(D18)"]
[]
[]
[]
[{"$nulls":14}," (D19) Total exempt imported value"]
[{"$nulls":13},"This total must correspond with Annex C - C 21"]
[]
[]
[null,null,"B. Imported directly by the Tenderer",{"$nulls":4},"Calculation of imported content",{"$nulls":6},"Summary"]
[null,null,"Tender item no's","Description of imported content",null,"Unit of measure","Overseas Supplier","Forign currency value as per Commercial Invoice","Tender Rate of Exchange","Local value of imports","Freight costs to port of entry","All locally incurred landing costs & duties","Total landed cost excl VAT",null,"Tender Qty","Total imported value"]
[null,null,"(D20)","(D21)",null,"(D22)","(D23)","(D24)","(D25)","(D26)","(D27)","(D28)","(D29)",null,"(D30)","(D31)"]
{"$rows_empty":7}
[{"$nulls":3},"`"]
[{"$nulls":14},"(D32)Total imported value by tenderer"]
[]
[null,null,"C. Imported by a 3rd party and supplied to the Tenderer",{"$nulls":4},"Calculation of imported content",{"$nulls":6},"Summary"]
[null,null,"Description of imported content",null,"Unit of measure","Local supplier","Overseas Supplier","Forign currency value as per Commercial Invoice","Tender Rate of Exchange","Local value of imports","Freight costs to port of entry","All locally incurred landing costs & duties","Total landed cost excl VAT",null,"Quantity imported","Total imported value"]
[null,null,"(D33)",null,"(D34)","(D35)","(D36)","(D37)","(D38)","(D39)","(D40)","(D41)","(D42)",null,"(D43)","(D44)"]
[]
[]
[]
[]
[]
[null,null,"`"]
[{"$nulls":14},"(D45) Total imported value by 3rd party"]
[]
[null,null,"D. Other foreign currency payments",{"$nulls":3},"Calculation of foreign currency payments",{"$nulls":8},"Summary of payments"]
[null,null,"Type of payment",null,"Local supplier making the payment","Overseas beneficiary","Foreign currency value paid","Tender Rate of Exchange",{"$nulls":7},"Local value of payments"]
[null,null,"(D46)",null,"(D47)","(D48)","(D49)","(D50)",{"$nulls":7},"(D51)"]
[]
[]
[]
[]
[{"$nulls":14},"(D52) Total of  foreign currency payments declared by tenderer and/or 3rd party"]
[null,null,"Signature of tenderer "]
[{"$nulls":14},"(D53) Total of imported content & foreign currency payments - (D32), (D45) & (D52) above"]
[{"$nulls":13},"This total must correspond with Annex C  - C 23"]
[null,null,"Date: "]

{"sheet":"Annex E","index":2,"n_rows":43,"n_cols":10,"rows_kept":43,"merged":[[2,2,2,8],[4,2,4,9],[6,7,7,8],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[36,7,36,8]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":8},"SATS 1286.2011"]
[null,null,"Annex E"]
[]
[null,null,"Local Content Declaration - Supporting Schedule to Annex C"]
[]
[null,"(E1)","Tender No.",{"$nulls":4},"Note: VAT to be excluded from all calculations"]
[null,"(E2)","Tender description: "]
[null,"(E3)","Designated products:"]
[null,"(E4)","Tender Authority:"]
[null,"(E5)","Tendering Entity name:"]
[]
[]
[{"$nulls":3},"Local Products (Goods, Services and Works)","Description of items purchased",null,null,"Local suppliers","Value","% of LC"]
[{"$nulls":4},"(E6)",null,null,"(E7)","(E8)"]
{"$rows_empty":12}
[{"$nulls":7},"(E9) Total local products (Goods, Services and Works)"]
[]
[null,null,"(E10)","Manpower costs","( Tenderer's manpower cost)"]
[]
[null,null,"(E11)","Factory overheads","(Rental, depreciation & amortisation, utility costs, consumables etc.)"]
[]
[null,null,"(E12)","Administration overheads and mark-up",null,"(Marketing, insurance, financing, interest etc.)"]
[]
[{"$nulls":7},"(E13)  Total local content"]
[{"$nulls":7},"This total must correspond with Annex C  - C24"]
[]
[null,null,"Signature of tenderer "]
[]
[]
[]
[null,null,"Date: "]

{"sheet":"Building & Plumbing BOQ","index":3,"n_rows":51,"n_cols":5,"rows_kept":51,"merged":[[48,2,48,3],[49,2,49,3],[50,2,50,3]],"flags":["formulas_cached_only"]}
[null,"Building, Plumbing and Civil"]
[null,"The project cost must be inclusive of all chargeable costs to Joburg Market"]
[null,"Any materials not covered/specified on the pricing list will have a 15% mark up"]
[null,"ANNEXURE 1"]
[null,"Item","Discription","Quantity","RATE:"]
[null,1,"50kg Premix (Cold Mix)",1]
[null,2,"Heavy duty(Industrial) Drain  Rods(2m x8mm)",1]
[null,3,"Cement (50KG)",1]
[null,4,"cationic premix grade bitumen emulsion – 200L drum ",1]
[null,5,"Lockset with handles (heavy duty)",1]
[null,6,"Cylinder lockset",1]
[null,7,"Mortice lock powder coated 4-lever union",1]
[null,8,"Lock body and cylinder CHR/P",1]
[null,9,"Euro cylinder standard finish 30 *30 mm standers",1]
[null,10,"Cylinder mortice lock(SABS approved) Lock body only chrome",1]
[null,11,"Painting trays set 13 piece",1]
[null,12,"Primer Red Oxide 20L",1]
[null,13,"Paint 20L Rock Grip",1]
[null,14,"225 mm Roller ",1]
[null,15," 50 mm Brush ",1]
[null,16," 125 mm Brush ",1]
[null,17,"Senior flush master full set (cobra) ",1]
[null,18,"Junior flush master full set (cobra)",1]
[null,19,"Flexi pipes long ",1]
[null,20,"Gate valves 22mm ",1]
[null,21,"Gate valves 15mm ",1]
[null,22,"Mixer flexi pipes ",1]
[null,23,"Stop end male x50 22mm (galvanise)",1]
[null,24,"Stop end female x50 22mm (galvanise)",1]
[null,25,"Garden taps brass (cobra) 22mm x20",1]
[null,26,"Mixer taps for hand basin  (cobra)",1]
[null,27,"Mixer taps for zink  (cobra)",1]
[null,28,"star taps for hand basin ",1]
[null,29,"Bottle traps for urinals ",1]
[null,30,"Wax seal",1]
[null,31,"Builders male to female 15mm ",1]
[null,32,"Compressic stop end 22mm ",1]
[null,33,"Flush master kits for senior ",1]
[null,34,"Flush master kits for junior ",1]
[null,35,"32mm hose gate ",1]
[null,36,"Copper pipe 22mmx6 meter ",1]
[null,37,"Copper pipe 15mmx6meter",1]
[null,38,"Cascade clamps( 22mmx20 ) (32mmx20 )",1]
[null,39,"Angle stop valve, chrome. Including 350mm braided flexi hose.",1]
[null,40,"Adaptor PVC 50mm",1]
[null,41,"Adaptor PVC 110mm",1]
[null,42,"Plumbing Tool Box",1]
[null,43,"Delivery of materials","per KM "]
[null,null,"SUB-TOTAL "]
[null,null,"VAT @ 15%"]
[null,null,"GRAND TOTAL"]

{"sheet":"Electrical BOQ","index":4,"n_rows":73,"n_cols":5,"rows_kept":73,"merged":[[70,2,70,3],[71,2,71,3],[72,2,72,3]],"flags":["formulas_cached_only"]}
[null,"Electrical"]
[null,"The project cost must be inclusive of all chargeable costs to Joburg Market"]
[null,"Any materials not covered/specified on the pricing list will have a 15% mark up"]
[null,"Item","Description","Quantity","RATE:"]
[null,1,"Double Pole 63A Earth Leakage CBI",1]
[null,2,"Double Pole 63A Circuit Breaker CBI",1]
[null,3,"20A Circuit Breaker CBI",1]
[null,4,"10A Circuit Breaker CBI",1]
[null,5,"Double Pole 63A Din Rail Earth Leakage",1]
[null,6,"Double Pole 63A Din Rail Circuit Breaker",1]
[null,7,"20A Din Rail Circuit Breaker",1]
[null,8,"10A Din Rail Circuit Breaker",1]
[null,9,"16A 4by4 Double Plug and Covers Crabtree",1]
[null,10,"16A 4by 4 Dedicated Double Plug and Covers Crabtree",1]
[null,11,"16A 4by2 Single Plug and Cover Crabtree",1]
[null,12,"16A 4by2 Single Plug and Cover Crabtree",1]
[null,13,"LED Florescent fitting 4 foot",1]
[null,14,"LED Florescent fitting 5 foot",1]
[null,15,"LED Florescent tubes 4 foot",1]
[null,16,"LED Florescent tubes 5 foot",1]
[null,17,"2x58w Electronic Ballast",1]
[null,18,"2x36w Electronic Ballast",1]
[null,19,"3x36w Electronic Ballast",1]
[null,20,"Digital Programmable Timers CBI",1]
[null,21,"Day and Night switch Waco",1]
[null,22,"220v Electrical Contactor",1]
[null,23,"380v Electrical Contactor",1]
[null,24,"220v 50w Down light",1]
[null,25,"12v 50w Down light",1]
[null,26,"1 Lever switch CBI",1]
[null,27,"2 Lever Switch CBI",1]
[null,28,"1 Lever 2 way Switch",1]
[null,29,"60A Double Pole Isolator Crabtree",1]
[null,30,"E27 2 Pin Energy Saver Bulbs",1]
[null,31,"E27 Screw Energy Saver Bulbs",1]
[null,32,"1.5mm Twin and Earth Cable 100m",1]
[null,33,"2.5mm Twin and Earth Cable 100m",1]
[null,34,"4by4 Extension box",1]
[null,35,"4by2 Extension box",1]
[null,36,"Electrical Gloves",1]
[null,37,"Electrical Googles",1]
[null,38,"30m wheel extension cord",1]
[null,39,"20mm whole saw",1]
[null,40,"25mm whole saw",1]
[null,41,"20mm Compression Glands",1]
[null,42,"25mm Compression Glands",1]
[null,43,"Self tape screw",1]
[null,44,"Butterfly screws",1]
[null,45,"Dry wall screws 5mm",1]
[null,46,"Cable Clips for 2.5mm flat cable",1]
[null,47,"Cable Clips for 1.5mm flat cable",1]
[null,48,"Cable Ties Medium Size Pack",1]
[null,49,"T10 Starters",1]
[null,50,"LED Starters",1]
[null,51,"3pole 63A C/B CBI",1]
[null,52,"3 pole 63A C/B Din rail",1]
[null,53,"T5 28W led tubes",1]
[null,54,"T5 54w florescent tubes",1]
[null,55,"30A c/b CBI",1]
[null,56,"30A C/B Din rail",1]
[null,57,"Mx2 joint kit",1]
[null,58,"16mm 4 core and earth armoured cable",1]
[null,59,"3pole MMCB 200A",1]
[null,60,"3POLE MMCB 250A",1]
[null,61,"12V  Industrial Diesel Pump 120L/min",1]
[null,62,"150 W High bay LED Lights",1]
[null,63,"100 W High bay LED Lights",1]
[null,64,"400W LED High Mast Lights",1]
[null,65,"Electrical Tool Box",1]
[null,66,"Delivery of Materials","per KM "]
[null,null,"SUB-TOTAL "]
[null,null,"VAT @ 15%"]
[null,null,"GRAND TOTAL"]

{"sheet":"Mechanical BOQ","index":5,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[27,2,27,3],[28,2,28,3],[29,2,29,3]],"flags":["formulas_cached_only"]}
[{"$nulls":4},"Mechanical "]
[{"$nulls":4},"The project cost must be inclusive of all chargeable costs to Joburg Market"]
[{"$nulls":4},"Any materials not covered/specified on the pricing list will have a 15% mark up "]
[null,"Item","Discription","Quantity","RATE:"]
[null,1,"Roller Chain: Banana Ripening door roller chain 08B-Ix3M.Fig1",1]
[null,2,"Spring Lift Cable 2M .Fig2",1]
[null,3,".Rod End Nut: For joining wieght and chain .Fig3",1]
[null,4,"Door Motor: 0.37 kw,50hz,1400r/min. Fig4",1]
[null,5,"Gearbox : Type :NMRV40.Fig4",1]
[null,6,"Limit Switch  Electronic door limit switch .Fig5",1]
[null,7," Brazing Rods Copper to Copper brazing rods 2mmx3mm",1]
[null,8,"Cold Room door handles with emergency lock .Fig6",1]
[null,9,"Sulfur Stick: Ammonia leak detecting stick ",1]
[null,10,"Ammonia Plant Cooling towers V-Belts SPA 3350",1]
[null,11,"Angle Grinder for cutting 230v-50hz ",1]
[null,12,"Generator (5.5 kva, 4 strokes) with wheels ",1]
[null,13,"Cutting Disks: 20X industrial grinder",1]
[null,14,"baby grinder",1]
[null,15," Uncoated Grating RS40 25 X 4.5",1]
[null,16,"Sulfur Sticks (for detecting ammonia leak) ",1]
[null,17,"Refilling of portable acetylene (0.9kg) and oxygen (1.2 kg net, 200 bar) Afrox cylinders ",1]
[null,18,"Welding Rods 3mm X1 pack ",1]
[null,19,"R410A refrigerant gas ",1]
[null,20,"air conditioner condensate pumps (EE1800) ",1]
[null,21,"Cooling towers V-Belts SPA 3350",1]
[null,22," Multimeter tester batteries (1604S 6F22 9V)",1]
[null,23,"Delivery of materials","per KM "]
[null,null,"SUB-TOTAL "]
[null,null,"VAT @ 15%"]
[null,null,"GRAND TOTAL"]