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

{"sheet":"Annex C","index":0,"n_rows":32,"n_cols":17,"rows_kept":32,"merged":[[6,15,7,16],[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],[24,4,24,5],[25,4,25,5]]}
[]
[{"$nulls":16},"SATS 1286.2011"]
[{"$nulls":3},"Annex C"]
[]
[{"$nulls":3},"Local Content Declaration - Summary Schedule "]
[]
[null,null,"(C1)","Tender No.",null,"1021/19/08/2022",{"$nulls":9},"Note: VAT to be excluded from all calculations"]
[null,null,"(C2)","Tender description: ",null,"The construction of experimental house in the CSIR Test Site"]
[null,null,"(C3)","Designated product(s)",null,"Steel Products and Components for Construction, Cement,  Electrical Cable Products, and Plastic Pipes"]
[null,null,"(C4)","Tender Authority:",null,"CSIR"]
[null,null,"(C5)","Tendering Entity name:"]
[null,null,"(C6)","Tender Exchange Rate:",null,null,"Pula",null,"EU",null,"GBP",null,null,"Other (Specfiy)"]
[null,null,"(C7)","Specified local content %",null,"Various%"]
[{"$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},1,"Steel Products e.g., joining components, Frames, fasteners etc",{"$nulls":3},{"$f":"G17-H17","v":{"v":0,"d":"R 0.00"}},null,{"$f":"I17-J17","v":{"v":0,"d":"R 0.00"}},{"$f":"K17/I17","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N17*G17","v":{"v":0,"d":"R  0"}},{"$f":"N17*H17","v":{"v":0,"d":"R  0"}},{"$f":"N17*J17","v":{"v":0,"d":"R  0"}}]
[{"$nulls":3},2,"Cement",{"$nulls":3},{"$f":"G18-H18","v":{"v":0,"d":"R 0.00"}},null,{"$f":"I18-J18","v":{"v":0,"d":"R 0.00"}},{"$f":"K18/I18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N18*G18","v":{"v":0,"d":"R  0"}},{"$f":"N18*H18","v":{"v":0,"d":"R  0"}},{"$f":"N18*J18","v":{"v":0,"d":"R  0"}}]
[{"$nulls":3},3,"Electrical Cables",{"$nulls":3},{"v":0,"d":"R 0.00"},null,{"v":0,"d":"R 0.00"},{"$error":"#DIV/0!"},null,null,{"v":0,"d":"R  0"},{"v":0,"d":"R  0"},{"v":0,"d":"R  0"}]
[{"$nulls":3},4,"PVC Pipes",{"$nulls":3},{"v":0,"d":"R 0.00"},null,{"v":0,"d":"R 0.00"},{"$error":"#DIV/0!"},null,null,{"v":0,"d":"R  0"},{"v":0,"d":"R  0"},{"v":0,"d":"R  0"}]
[{"$nulls":3},5,{"$nulls":4},{"v":0,"d":"R 0.00"},null,{"v":0,"d":"R 0.00"},{"$error":"#DIV/0!"},null,null,{"v":0,"d":"R  0"},{"v":0,"d":"R  0"},{"v":0,"d":"R  0"}]
[{"$nulls":3},6,{"$nulls":4},{"v":0,"d":"R 0.00"},null,{"v":0,"d":"R 0.00"},{"$error":"#DIV/0!"},null,null,{"v":0,"d":"R  0"},{"v":0,"d":"R  0"},{"v":0,"d":"R  0"}]
[{"$nulls":3},7,{"$nulls":4},{"v":0,"d":"R 0.00"},null,{"v":0,"d":"R 0.00"},{"$error":"#DIV/0!"},null,null,{"v":0,"d":"R  0"},{"v":0,"d":"R  0"},{"v":0,"d":"R  0"}]
[{"$nulls":3},8,{"$nulls":4},{"v":0,"d":"R 0.00"},null,{"v":0,"d":"R 0.00"},{"$error":"#DIV/0!"},null,null,{"v":0,"d":"R  0"},{"v":0,"d":"R  0"},{"v":0,"d":"R  0"}]
[{"$nulls":3},9,{"$nulls":4},{"v":0,"d":"R 0.00"},null,{"v":0,"d":"R 0.00"},{"$error":"#DIV/0!"},null,null,{"v":0,"d":"R  0"},{"v":0,"d":"R  0"},{"v":0,"d":"R  0"}]
[{"$nulls":3},10,{"$nulls":4},{"v":0,"d":"R 0.00"},null,{"v":0,"d":"R 0.00"},{"$error":"#DIV/0!"},null,null,{"v":0,"d":"R  0"},{"v":0,"d":"R  0"},{"v":0,"d":"R  0"}]
[{"$nulls":13}," (C20)  Total tender  value",{"$f":"SUM(O17:O26)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":3},"Signature of tenderer from Annex B",{"$nulls":10},"(C21) Total Exempt imported content",{"$f":"SUM(P17:P27)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":14},"(C22) Total Tender value net of exempt imported content",{"$f":"+O27-P28","v":{"v":0,"d":"R  0"}}]
[{"$nulls":15},"(C23) Total Imported content",{"$f":"SUM(Q17:Q26)","v":{"v":0,"d":"R  0"}}]
[{"$nulls":15},"(C24) Total local content",{"$f":"+P29-Q30","v":{"v":0,"d":"R  0"}}]
[{"$nulls":3},"Date: ",{"$nulls":11},"(C25) Average local content % of tender",{"$f":"Q31/P29","v":{"$error":"#DIV/0!"}}]

{"sheet":"Annex D","index":1,"n_rows":68,"n_cols":16,"rows_kept":68,"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],[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],[27,13,28,15],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[45,2,45,6],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[56,6,56,7],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[66,13,67,15]]}
[]
[{"$nulls":15},"SATS 1286.2011"]
[null,null,"Annex D"]
[]
[null,null,"Imported Content Declaration - Supporting Schedule to Annex C"]
[]
[null,"(D1)","Tender No.",null,{"$f":"'Annex C'!F7","v":"1021/19/08/2022"},{"$nulls":5},"Note: VAT to be excluded from all calculations"]
[null,"(D2)","Tender description: ",null,{"$f":"'Annex C'!F8","v":"The construction of experimental house in the CSIR Test Site"}]
[null,"(D3)","Designated Products:",null,{"$f":"'Annex C'!F9","v":"Steel Products and Components for Construction, Cement,  Electrical Cable Products, and Plastic Pipes"}]
[null,"(D4)","Tender Authority:",null,{"$f":"'Annex C'!F10","v":"CSIR"}]
[null,"(D5)","Tendering Entity name:",null,{"$f":"'Annex C'!F11","v":0}]
[null,"(D6)","Tender Exchange Rate:",null,null,"Pula",{"$f":"'Annex C'!H12","v":{"v":0,"d":"R  0.00"}},"EU",{"$f":"'Annex C'!J12","v":{"v":0,"d":"R  0.00"}},"GBP",{"$f":"'Annex C'!L12","v":{"v":0,"d":"R  0.00"}},{"$nulls":3},"Other (Specfiy)",{"$f":"'Annex C'!O12","v":{"v":0,"d":"R  0.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)"]
[null,null,1,{"$f":"'Annex C'!E17:E17","v":"Steel Products e.g., joining components, Frames, fasteners etc"}]
[null,null,2,{"$f":"'Annex C'!E18:E18","v":"Cement"}]
[null,null,3,{"$f":"'Annex C'!E19:E19","v":"Electrical Cables"}]
[null,null,4,{"$f":"'Annex C'!E20:E20","v":"PVC Pipes"}]
[null,null,5,{"$f":"'Annex C'!E21:E21","v":0}]
[null,null,6,{"$f":"'Annex C'!E22:E22","v":0}]
[null,null,7,{"$f":"'Annex C'!E23:E23","v":0}]
[null,null,8,{"$f":"'Annex C'!E24:E24","v":0}]
[null,null,9,{"$f":"'Annex C'!E25:E25","v":0}]
[null,null,10,{"$f":"'Annex C'!E26:E26","v":0}]
[{"$nulls":14}," (D19) Total exempt imported value",{"$f":"SUM(P24:P25)","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)"]
[null,null,1,{"$f":"D17","v":"Steel Products e.g., joining components, Frames, fasteners etc"}]
[null,null,2,"Cement"]
[null,null,3,"Electrical Cables"]
[null,null,4,"PVC Pipes"]
[null,null,5,0]
[null,null,6,0]
[null,null,7,0]
[null,null,8,0]
[null,null,9,0]
[null,null,10,0]
[{"$nulls":14},"(D32)Total imported value by tenderer",{"$f":"SUM(P34:P43)","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)"]
[]
[]
[]
[]
[]
[]
[{"$nulls":14},"(D45) Total imported value by 3rd party",{"$f":"SUM(P49:P54)","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":"+P44+P55+P64","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":41,"n_cols":10,"rows_kept":41,"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],[34,7,34,8]]}
[]
[{"$nulls":8},"SATS 1286.2011"]
[null,null,"Annex E"]
[]
[null,null,"Local Content Declaration - Supporting Schedule to Annex C"]
[]
[null,"(E1)","Tender No.",null,{"$f":"'Annex C'!F7","v":"1021/19/08/2022"},null,null,"Note: VAT to be excluded from all calculations"]
[null,"(E2)","Tender description: ",null,{"$f":"'Annex C'!F8","v":"The construction of experimental house in the CSIR Test Site"}]
[null,"(E3)","Designated products:",null,{"$f":"'Annex C'!F9","v":"Steel Products and Components for Construction, Cement,  Electrical Cable Products, and Plastic Pipes"}]
[null,"(E4)","Tender Authority:",null,{"$f":"'Annex C'!F10","v":"CSIR"}]
[null,"(E5)","Tendering Entity name:",null,{"$f":"'Annex D'!E11","v":0}]
[]
[]
[{"$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},{"$f":"'Annex C'!E17:E17","v":"Steel Products e.g., joining components, Frames, fasteners etc"}]
[{"$nulls":4},{"$f":"'Annex C'!E18:E18","v":"Cement"}]
[{"$nulls":4},{"$f":"'Annex C'!E19:E19","v":"Electrical Cables"}]
[{"$nulls":4},{"$f":"'Annex C'!E20:E20","v":"PVC Pipes"}]
[{"$nulls":4},{"$f":"'Annex C'!E21:E21","v":0}]
[{"$nulls":4},{"$f":"'Annex C'!E22:E22","v":0}]
[{"$nulls":4},{"$f":"'Annex C'!E23:E23","v":0}]
[{"$nulls":4},{"$f":"'Annex C'!E24:E24","v":0}]
[{"$nulls":4},{"$f":"'Annex C'!E25:E25","v":0}]
[{"$nulls":4},{"$f":"'Annex C'!E26:E26","v":0}]
[{"$nulls":7},"(E9) Total local products (Goods, Services and Works)",{"$f":"SUM(I16:I25)","v":{"v":0,"d":"R 0"}}]
[]
[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",{"$f":"I26+I28+I30+I32","v":{"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: "]