{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Annex C","Annex D","Annex E"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Annex C","index":0,"n_rows":65,"n_cols":17,"rows_kept":65,"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],[17,4,17,5],[18,4,18,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[56,4,56,5],[57,4,57,5],[58,4,58,5]]}
[]
[{"$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)"]
[{"$nulls":3},"C2.1"]
[{"$nulls":3},"C2.1.12.2","Concrete aggregate (37,5 mm aggregate size)"]
[{"$nulls":3},"C2.1.13.4","Cement (CEM II B-L (V-S) 32,5N)"]
[{"$nulls":3},"C3.3"]
[{"$nulls":3},"C3.3.2.1 (b)","Figure 7 semi-mountable kerb, as shown on drawing"]
[{"$nulls":3},"C3.3.2.1 (c)","Figure 3 non-mountable kerb, as shown on drawing"]
[{"$nulls":3},"C3.3.3.1 (b)","Figure 7 semi-mountable kerb"]
[{"$nulls":3},"PC3.3.17 (a) (i)","Inlet structure (Figure 3 Kerb-and-channel)"]
[{"$nulls":3},"C5.3"]
[{"$nulls":3},"C4.4.4.1","Cement (CEM II B-L 32.5N)"]
[{"$nulls":3},"C4.4.4.2","Road lime"]
[{"$nulls":3},"C5.4.5.2 (a)","Cement (CEM II B-L 32.5N)"]
[{"$nulls":3},"C5.4.5.2 (b)","Road lime"]
[{"$nulls":3},"C8.6.1.2","Sealing cracks / joints with geosynthetic over areas (cationic bitumen emulsion)"]
[{"$nulls":3},"C5.5"]
[{"$nulls":3},"C4.4.4.1","Cement (CEM II B-L 32,5N)"]
[{"$nulls":3},"C5.4.5.2 (a)","Cement (subbase layer)"]
[{"$nulls":3},"C11.1"]
[{"$nulls":3},"PC11.1.6","Concrete edge beam (300mm x 200mm, Class C24/30-20 concrete, U2 surface finish)"]
[{"$nulls":3},"C11.4"]
[{"$nulls":3},"PC11.4.1.1 (a)","On timber posts as per drawings"]
[{"$nulls":3},"C11.4.6.1","Steel plates"]
[{"$nulls":3},"C11.4.11.1","Guardrails, 3,81m compliant to SANS 1350"]
[{"$nulls":3},"C11.4.11.4","Reflective plates"]
[{"$nulls":3},"C11.4.11.6","Splice bolt complete with nut and washer compliant to SANS 1350"]
[{"$nulls":3},"C11.4.11.7","Post bolt complete with nut and washer compliant to SANS 1350"]
[{"$nulls":3},"C11.4.11.8","Reinforcing plates (As shown on drawing) "]
[{"$nulls":3},"C11.4.14","NAILING OF GANG NAIL PLATES ON TOP OF TIMBER GUARDRAIL POSTS"]
[{"$nulls":3},"C11.5"]
[{"$nulls":3},"C11.5.1.1","Zinc-coated barbed wire (High-tensile grade, single-strand 3,15 mm x 2,5 mm oval-shaped wire, fully galvanized)"]
[{"$nulls":3},"C11.5.1.7","Standards (1,850 m x 2,5 kg/m mild steel \"y\"-section)"]
[{"$nulls":3},"C11.5.1.8","Droppers (1,400 m x 0.56kg/m mild steel ridge back section)"]
[{"$nulls":3},"C11.5.1.9 (a) (i)","Steel straining posts (2,130 m x 100 mm x 3,0 mm mild steel tubing with steel cap and 230 x 230 x 3 mm base plate, fully galvanized)"]
[{"$nulls":3},"C11.5.1.9 (b) (i)","Steel stays and anchors (2,130 m x 60 mm diameter x 3,0 mm mild steel tubing with 230 x 230 x 3 mm base plate, fully galvanized)"]
[{"$nulls":3},"C11.5.1.9 (b) (ii)","Wire stays and anchors - Fully Galvanized (mild steel, 4 strands-strand, doubled and twisted to take strain (SANS 675)"]
[{"$nulls":3},"C11.5.1.9 (c) (i)","Steel stays and anchors (2,4 m x 60 mm diameter x 2,95 mm mild steel tubing bent and flattened as shown, fully galvanized; ends press flat to ± 8 mm)"]
[{"$nulls":3},"C11.5.9.1","Stock-proof fences"]
[{"$nulls":3},"C11.6"]
[{"$nulls":3},"C11.6.4.2","Kilometre markers on posts as shown on drawing "]
[{"$nulls":3},"C11.6.8.1","Size 200 x 800mm (50x50x2mm Galvanized square tube post)"]
[{"$nulls":3},"C14.9"]
[{"$nulls":3},"PC14.9.3.1 (a)","Replace bridge joint with new buried joint – 100 kN/m Polyester Asphalt Grid - See drawing for details"]
[]
[{"$nulls":13}," (C20)  Total tender  value",{"$f":"SUM(O18:O59)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":3},"Signature of tenderer from Annex B",{"$nulls":10},"(C21) Total Exempt imported content",{"$f":"SUM(P18:P60)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":14},"(C22) Total Tender value net of exempt imported content",{"$f":"+O60-P61","v":{"v":0,"d":"R  0"}}]
[{"$nulls":15},"(C23) Total Imported content",{"$f":"SUM(Q18:Q59)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":15},"(C24) Total local content",{"$f":"+P62-Q63","v":{"v":0,"d":"R  0"}}]
[{"$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]]}
[]
[{"$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",{"v":9,"d":"R  9.00"},"GBP",{"v":12,"d":"R  12.00"}]
[]
[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",{"$f":"SUM(P17:P18)","v":{"v":0,"d":"R  0"}}]
[{"$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",{"$f":"SUM(P27:P34)","v":{"v":0,"d":"R  0"}}]
[]
[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",{"$f":"SUM(P40:P45)","v":{"v":0,"d":"R  0"}}]
[]
[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 from Annex B"]
[{"$nulls":14},"(D53) Total of imported content & foreign currency payments - (D32), (D45) & (D52) above",{"$f":"+P35+P46+P55","v":{"v":0,"d":"R  0"}}]
[{"$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]]}
[]
[{"$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)",{"$f":"SUM(I16:I27)","v":{"v":0,"d":"R 0"}}]
[]
[null,null,"(E10)","Manpower costs","( Tenderer's manpower cost)",{"$nulls":3},{"v":0,"d":"R 0"}]
[]
[null,null,"(E11)","Factory overheads","(Rental, depreciation & amortisation, utility costs, consumables etc.)",{"$nulls":3},{"v":0,"d":"R 0"}]
[]
[null,null,"(E12)","Administration overheads and mark-up",null,"(Marketing, insurance, financing, interest etc.)",null,null,{"v":0,"d":"R 0"}]
[]
[{"$nulls":7},"(E13)  Total local content",{"v":0,"d":"R 0"}]
[{"$nulls":7},"This total must correspond with Annex C  - C24"]
[]
[null,null,"Signature of tenderer from Annex B"]
[]
[]
[]
[null,null,"Date: "]