{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Annex C","Annex D","Annex E"],"not_rendered":{"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Annex C","index":0,"n_rows":38,"n_cols":15,"rows_kept":38,"merged":[[6,3,6,6],[6,13,7,14],[7,3,7,6],[8,3,8,8],[9,3,9,6],[10,3,10,6],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":14},"SATS 1286.2011"]
[null,"Annex C"]
[]
[null,"Local Content Declaration - Summary Schedule "]
[]
["(C1)","Tender No.",null,"WCR 04/2022",{"$nulls":9},"Note: VAT to be excluded from all calculations"]
["(C2)","Tender description: ",null,"Supply and delivery of Building Material"]
["(C3)","Designated product(s)",null,"Steel, Fabraicated Steel, Cement, Plastic Pipes, Electrical Wire Cables "]
["(C4)","Tender Authority:",null,"George Correctional Centre"]
["(C5)","Tendering Entity name:"]
["(C6)","Tender Exchange Rate:",null,"Pula",null,"EU",null,"GBP"]
["(C7)","Specified local content %",null,{"v":1,"d":"100%"}]
[{"$nulls":4},"Calculation of local content",{"$nulls":6},"Tender  summary"]
[null,"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"]
[null,"(C8)","(C9)",null,"(C10)","(C11)","(C12)","(C13)","(C14)","(C15)",null,"(C16)","(C17)","(C18)","(C19)"]
[null,"1.3","Passive  ring shank nails, 75mm"]
[null,"1.4","Chipboard screws, 6mmx25mm"]
[null,"1.11","Hinges, stailess steel, heavy duty, 100mmx75mmx2mm"]
[null,"1.14","Nails, steel, 40mm"]
[null,"1.22","Shaft steel door, 759x2032mm"]
[null,"2.6","Gladded nails, galvanized, 32mm"]
[null,3,"Trusses "]
[null,"4.3","Cement, 42.5mpa "]
[null,"4.8","Butterfly ties galvanized"]
[null,"4.9 & 4.10","Brick force galvanized"]
[null,"4.13","Welded mesh, steel"]
[null,"5.36; 5.42; 5.47","PVC Pipes"]
[null,"5.49-5.56; 5.60-5.62","Eletrical Housewire cables"]
[null,"7.24-7.26","Pex (HDPE) Pipes "]
[null,"7.44-7.50","PVC Pipes "]
[{"$nulls":11}," (C20)  Total tender  value",{"v":0,"d":"R  0"}]
[null,"Signature of tenderer from Annex B",{"$nulls":10},"(C21) Total Exempt imported content",{"v":0,"d":"R  0"}]
[{"$nulls":12},"(C22) Total Tender value net of exempt imported content",{"v":0,"d":"R  0"}]
[{"$nulls":13},"(C23) Total Imported content",{"v":0,"d":"R  0"}]
[null,"______________________________________________",{"$nulls":11},"(C24) Total local content",{"v":0,"d":"R  0"}]
[{"$nulls":13},"(C25) Average local content % of tender"]
[null,"Date: _______________________"]

{"sheet":"Annex D","index":1,"n_rows":72,"n_cols":16,"rows_kept":72,"merged":[[6,4,6,7],[6,10,8,11],[7,4,7,7],[8,4,8,7],[9,4,9,7],[10,4,10,7],[13,2,13,6],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[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],[33,13,34,15],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[49,2,49,6],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[60,6,60,7],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[70,13,71,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.",null,"WCR 04/2022",{"$nulls":5},"Note: VAT to be excluded from all calculations"]
[null,"(D2)","Tender description: ",null,"Supply and delivery of Building Material"]
[null,"(D3)","Designated Products:",null,"Steel, Fabraicated Steel, Cement, Plastic Pipes, Electrical Wire Cables "]
[null,"(D4)","Tender Authority:",null,"Goerge Correctional Centre"]
[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)"]
[null,null,"1.3","Passive  ring shank nails, 75mm"]
[null,null,"1.4","Chipboard screws, 6mmx25mm"]
[null,null,"1.11","Hinges, stailess steel, heavy duty, 100mmx75mmx2mm"]
[null,null,"1.14","Nails, steel, 40mm"]
[null,null,"1.22","Shaft steel door, 759x2032mm"]
[null,null,"2.6","Gladded nails, galvanized, 32mm"]
[null,null,3,"Trusses "]
[null,null,"4.3","Cement, 42.5mpa "]
[null,null,"4.8","Butterfly ties galvanized"]
[null,null,"4.9 & 4.10","Brick force galvanized"]
[null,null,"4.13","Welded mesh, steel"]
[null,null,"5.36; 5.42; 5.47","PVC Pipes"]
[null,null,"5.49-5.56,    5.60-5.62","Eletrical Housewire cables"]
[null,null,"7.24-7.26","Pex (HDPE) Pipes "]
[null,null,"7.44-7.50","PVC Pipes "]
[]
[{"$nulls":14}," (D19) Total exempt imported value",{"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",{"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",{"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",{"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":47,"n_cols":10,"rows_kept":47,"merged":[[2,2,2,8],[4,2,4,9],[6,7,7,8],[7,4,7,6],[8,4,8,7],[9,4,9,7],[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,5],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[40,7,40,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.",null,"WCR 04/2022",null,null,"Note: VAT to be excluded from all calculations"]
[null,"(E2)","Tender description: ",null,"Supply and delivery of Building Materialt"]
[null,"(E3)","Designated products:",null,"Steel, Fabraicated Steel, Cement, Plastic Pipes, Electrical Wire Cables "]
[null,"(E4)","Tender Authority:",null,"George Correctional Centre"]
[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)"]
[{"$nulls":4},"Passive  ring shank nails, 75mm"]
[{"$nulls":4},"Chipboard screws, 6mmx25mm"]
[{"$nulls":4},"Hinges, stailess steel, heavy duty, 100mmx75mmx2mm"]
[{"$nulls":4},"Nails, steel, 40mm"]
[{"$nulls":4},"Shaft steel door, 759x2032mm"]
[{"$nulls":4},"Gladded nails, galvanized, 32mm"]
[{"$nulls":4},"Trusses "]
[{"$nulls":4},"Cement, 42.5mpa "]
[{"$nulls":4},"Butterfly ties galvanized"]
[{"$nulls":4},"Brick force galvanized"]
[{"$nulls":4},"Welded mesh, steel"]
[{"$nulls":4},"PVC Pipes"]
[{"$nulls":4},"Eletrical Housewire cables"]
[{"$nulls":4},"Pex (HDPE) Pipes "]
[{"$nulls":4},"PVC Pipes "]
[]
[{"$nulls":7},"(E9) Total local products (Goods, Services and Works)",{"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: "]