{"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":61,"n_cols":17,"rows_kept":61,"merged":[[2,3,2,17],[6,5,6,8],[6,15,7,16],[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],[23,4,23,5],[36,4,36,5]]}
[]
[{"$nulls":16},"SATS 1286.2011"]
[{"$nulls":3},"Annex C"]
[]
[{"$nulls":3},"Local Content Declaration - Summary Schedule "]
[]
[null,null,"(C1)","Tender No.",null,"RFP/LOG/2023/18",{"$nulls":9},"Note: VAT to be excluded from all calculations"]
[null,null,"(C2)","Tender description: ",null,"THE APPOINTMENT OF A CONTRACTOR TO UPGRADE LIFTS AND ESCALATORS AT THE SABC AUCKLAND PARK OFFICES FOR FIVE (05) YEARS WITH FIVE (5) YEAR MAINTENANCE PLAN"]
[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},1,"Brick reinforcement 110mm wide",{"$nulls":8},{"v":450,"d":"450.0"}]
[{"$nulls":3},2,"Brick reinforcement  220mm wide",{"$nulls":8},{"v":1973,"d":"1973.0"}]
[{"$nulls":3},3,"Stainless steel cladding",{"$nulls":8},{"v":439,"d":"439.0"}]
[{"$nulls":3},4,"254 x 146 x 31kg/m Universal Beam",{"$nulls":8},{"v":653,"d":"653.0"}]
[{"$nulls":3},5,"152 x 152 x 30kg/m UC",{"$nulls":8},{"v":2290,"d":"2290.0"}]
[{"$nulls":3},6,"Parallel channel IPE 200 x 100",{"$nulls":8},{"v":245,"d":"245.0"}]
[{"$nulls":3},7,"Parallel channel IPE 230 x 90 x 32kglm ",{"$nulls":8},{"$f":"72+119+181","v":{"v":372,"d":"372.0"}}]
[{"$nulls":3},8,"Parallel channel IPE 120 x 64",{"$nulls":8},{"v":18,"d":"18.0"}]
[{"$nulls":3},9,"90x90x8kg/m steel angle",{"$nulls":8},{"$f":"80","v":{"v":80,"d":"80.0"}}]
[{"$nulls":3},10,"10x145 Steel plate",{"$nulls":8},{"$f":"5","v":{"v":5,"d":"5.0"}}]
[{"$nulls":3},11,"10 x 145 Steel plates",{"$nulls":8},{"v":74,"d":"74.0"}]
[{"$nulls":3},12,"12mm End plate",{"$nulls":8},{"v":100,"d":"100.0"}]
[{"$nulls":3},13,"16mm Base plate",{"$nulls":8},{"v":100,"d":"100.0"}]
[{"$nulls":3},14,"Steel flat bars FL 16 x 300",{"$nulls":8},{"v":32,"d":"32.0"}]
[{"$nulls":3},15,"Steel flat bars FL 10 x 100",{"$nulls":8},{"v":13,"d":"13.0"}]
[{"$nulls":3},16,"Steel flat bars FL 10 x 70",{"$nulls":8},{"v":3,"d":"3.0"}]
[{"$nulls":3},17,"4 x M20 (8.8) Bolts",{"$nulls":8},{"v":352,"d":"352.0"}]
[{"$nulls":3},18,"4 x M24 HD bolts",{"$nulls":8},{"v":156,"d":"156.0"}]
[{"$nulls":3},19,"Low voltage power cables 16mm² x 4 core PVC/SWA/ CU",{"$nulls":8},{"v":300,"d":"300.0"}]
[{"$nulls":3},20,"Low voltage power cables 10mm² x 4 core PVC/SWA/ CU",{"$nulls":8},{"v":60,"d":"60.0"}]
[{"$nulls":3},21,"Low voltage power cables 70mm² x 4 core (N)HXCH-FE 180/E 90 FIRE RATED cable",{"$nulls":8},{"v":450,"d":"450.0"}]
[{"$nulls":3},22,"Mild steel reinforcement 0.8mm diameter bars",{"$nulls":8},{"v":0.03,"d":"0.0"}]
[{"$nulls":3},23,"Mild steel reinforcement 10mm diameter bars",{"$nulls":8},{"v":0.15,"d":"0.2"}]
[{"$nulls":3},24,"Mild steel reinforcement 16mm diameter bars",{"$nulls":8},{"v":1.35,"d":"1.4"}]
[{"$nulls":3},25,"High yield steel reinforcement 10mm diameter bars",{"$nulls":8},{"v":0.08,"d":"0.1"}]
[{"$nulls":3},26,"High yield steel reinforcement 12mm diameter bars",{"$nulls":8},{"v":1.72,"d":"1.7"}]
[{"$nulls":3},27,"High yield steel reinforcement 16mm diameter bars",{"$nulls":8},5.9]
[{"$nulls":3},28,"High yield steel reinforcement 20mm diameter bars",{"$nulls":8},{"v":2.16,"d":"2.2"}]
[{"$nulls":3},29,"Type Ref 193 fabric reinforcement in concrete surface beds, slabs, etc",{"$nulls":8},{"v":177,"d":"177.0"}]
[{"$nulls":3},30,"Type Ref 311 fabric reinforcement in concrete surface beds, slabs, etc",{"$nulls":8},{"v":36,"d":"36.0"}]
[{"$nulls":3},31,"16mm² PVC insulated copper conductor",{"$nulls":8},{"v":300,"d":"300.0"}]
[{"$nulls":3},32,"10mm² PVC insulated copper conductor",{"$nulls":8},{"v":60,"d":"60.0"}]
[{"$nulls":3},33,"70mm² PVC insulated copper conductor",{"$nulls":8},{"v":405,"d":"405.0"}]
[{"$nulls":3},34,"70mm² PVC insulated copper conductor with fire rated cable",{"$nulls":8},{"v":305,"d":"305.0"}]
[{"$nulls":3},35,"3040 x 2125mm, 1.6mm Steel frame as per manufacturer",{"$nulls":8},{"v":22,"d":"22.0"}]
[{"$nulls":3},36,"2896 x 2125, 1.6mm Steel frame as per manufacture",{"$nulls":8},{"v":22,"d":"22.0"}]
[{"$nulls":3},37,"1990 x 2125mm, 1.6mm Steel frame as per manufacture ",{"$nulls":8},{"v":7,"d":"7.0"}]
[{"$nulls":3},38,"1896 x 2125mm, 1.6mm Steel frame as per manufacture",{"$nulls":8},{"v":7,"d":"7.0"}]
[{"$nulls":3},39,"3152 x 2550mm, 1.6mm Steel frame as per manufacturer ",{"$nulls":8},{"v":3,"d":"3.0"}]
[{"$nulls":13}," (C20)  Total tender  value"]
[{"$nulls":3},"Signature of tenderer from Annex B",{"$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":77,"n_cols":16,"rows_kept":77,"merged":[[6,14,8,15],[13,2,13,6],[14,3,14,4],[15,3,15,4],[20,3,20,4],[21,3,21,4],[23,3,23,4],[25,13,26,15],[29,3,29,4],[30,3,30,4],[31,3,31,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],[47,2,47,6],[48,2,48,3],[49,2,49,3],[50,2,50,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[61,6,61,7],[62,2,62,3],[63,2,63,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[75,13,76,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,"RFP/LOG/2022/8","RFP/LOG/2023/18",{"$nulls":8},"Note: VAT to be excluded from all calculations"]
[null,"(D2)","Tender description: ",null,"THE APPOINTMENT OF A CONTRACTOR TO UPGRADE THE LIFTS AND ESCALATORS AT THE SABC AUCKLAND PARK OFFICES FOR THREE (03) YEARS","THE APPOINTMENT OF A CONTRACTOR TO UPGRADE LIFTS AND ESCALATORS AT THE SABC AUCKLAND PARK OFFICES FOR FIVE (05) YEARS WITH FIVE (5) YEAR MAINTENANCE PLAN"]
[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":13},{"$f":"72+119+181","v":{"v":372,"d":"R  372"}}]
[]
[{"$nulls":14}," (D19) Total exempt imported value",{"$f":"SUM(P21:P22)","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","Foreign 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":13}
[{"$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,null,"(D35)","(D36)","(D37)","(D38)","(D39)","(D40)","(D41)","(D42)",null,"(D43)","(D44)"]
{"$rows_empty":8}
[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)"]
{"$rows_empty":8}
[{"$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"]
[{"$nulls":13},"This total must correspond with Annex C  - C 23"]
[null,null,"Date: "]

{"sheet":"Annex E","index":2,"n_rows":44,"n_cols":10,"rows_kept":44,"merged":[[2,2,2,8],[4,2,4,9],[6,4,6,7],[6,8,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],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[37,7,37,8]]}
[]
[{"$nulls":8},"SATS 1286.2011"]
[null,null,"Annexure E"]
[]
[null,null,"Local Content Declaration - Supporting Schedule to Annex C"]
[]
[null,"(E1)","Tender No.",null,"RFP/LOG/2022/8",{"$nulls":3},"Note: VAT to be excluded from all calculations"]
[null,"(E2)","Tender description: ",null,{"$f":"'Annex C'!F8","v":"THE APPOINTMENT OF A CONTRACTOR TO UPGRADE LIFTS AND ESCALATORS AT THE SABC AUCKLAND PARK OFFICES FOR FIVE (05) YEARS WITH FIVE (5) YEAR MAINTENANCE PLAN"},"THE APPOINTMENT OF A CONTRACTOR TO UPGRADE LIFTS AND ESCALATORS AT THE SABC AUCKLAND PARK OFFICES FOR FIVE (05) YEARS WITH FIVE (5) YEAR MAINTENANCE PLAN"]
[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":13}
[{"$nulls":7},"(E9) Total local products (Goods, Services and Works)"]
[]
[null,null,"(E10)","Manpower costs"]
[]
[null,null,"(E11)","Factory overheads"]
[]
[null,null,"(E12)","Administration overheads and mark-up","Low voltage power cables 70mm² x 4 core (N)HXCH-FE 180/E 90 FIRE RATED cable","(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 from Annex B"]
[]
[]
[]
[null,null,"Date: "]