{"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":138,"n_cols":17,"rows_kept":138,"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],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,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],[59,4,59,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[66,4,66,5],[67,4,67,5],[68,4,68,5],[69,4,69,5],[70,4,70,5],[71,4,71,5],[72,4,72,5],[73,4,73,5],[74,4,74,5],[75,4,75,5],[76,4,76,5],[77,4,77,5],[78,4,78,5],[79,4,79,5],[80,4,80,5],[81,4,81,5],[82,4,82,5],[83,4,83,5],[84,4,84,5],[85,4,85,5],[86,4,86,5],[87,4,87,5],[88,4,88,5],[89,4,89,5],[90,4,90,5],[91,4,91,5],[92,4,92,5],[93,4,93,5],[94,4,94,5],[95,4,95,5],[96,4,96,5],[97,4,97,5],[98,4,98,5],[99,4,99,5],[100,4,100,5],[101,4,101,5],[102,4,102,5],[103,4,103,5],[104,4,104,5],[105,4,105,5],[106,4,106,5],[107,4,107,5],[108,4,108,5],[109,4,109,5],[110,4,110,5],[111,4,111,5],[112,4,112,5],[113,4,113,5],[114,4,114,5],[115,4,115,5],[116,4,116,5],[117,4,117,5],[118,4,118,5],[119,4,119,5],[120,4,120,5],[121,4,121,5],[122,4,122,5],[123,4,123,5],[124,4,124,5],[125,4,125,5],[126,4,126,5],[127,4,127,5],[128,4,128,5],[129,4,129,5],[130,4,130,5],[131,4,131,5]]}
[]
[{"$nulls":16},"SATS 1286.2011"]
[{"$nulls":3},"Annex C"]
[]
[{"$nulls":3},"Local Content Declaration - Summary Schedule "]
[]
[null,null,"(C1)","Tender No.",null,"LNW 02/21/22",{"$nulls":9},"Note: VAT to be excluded from all calculations"]
[null,null,"(C2)","Tender description: ",null,"Phase 1A:-Construction Of Musiphana Pipeline"]
[null,null,"(C3)","Designated product(s)",null,"Steel and uPVC pipe, fittings and valves"]
[null,null,"(C4)","Tender Authority:",null,"Lepelle Northern Water"]
[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 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},"F-1.1.1","160mm NB uPVC PN16 ",{"$nulls":8},"5685m"]
[{"$nulls":3},"F-1.1.2","300mm NB Steel PN40",{"$nulls":8},"7363m"]
[{"$nulls":3},"F-1.1.3","315mm OD HDPE PN16",{"$nulls":8},"2000m"]
[{"$nulls":3},"F-1.1.4","160mm NB uPVC PN16 Bend\nBends up to 3°\nCombined bend (C) ",{"$nulls":8},6]
[{"$nulls":3},"F-1.1.5","160mm NB uPVC PN16 Bend\nBends up to 3° up to 11.25°\nOne dimensional bends",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.6","160mm NB uPVC PN16 Bend\nBends up to 3° up to 11.25°\nCombined bend (C) ",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.7","160mm NB uPVC PN16 Bend\nBends 11.25° up to 22.5°\nOne dimensional bends ",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.8","160mm NB uPVC PN16 Bend\nBends 11.25° up to 22.5°\nCombined bend (C) ",{"$nulls":8},2]
[{"$nulls":3},"F-1.1.9","160mm NB uPVC PN16 Bend\nBends up to 22.5° up to 45°\nCombined bend (C) ",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.10","160mm NB uPVC PN16 Bend\nBends up to 45° up to 90°\nCombined bend (C) ",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.11","300mm NB Steel PN40 Bends- Angle of 12°- 22.5°",{"$nulls":8},10]
[{"$nulls":3},"F-1.1.12","300mm NB Steel PN40 Bends-Angle of 22.5°- 45°",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.13","300mm NB Steel PN40 Bends-Angle of 45°- 67.5°",{"$nulls":8},4]
[{"$nulls":3},"F-1.1.14","300mm NB Steel PN40 Bends-Angle of 67.5°- 90°",{"$nulls":8},1]
[]
[]
[]
[]
[{"$nulls":3},"Tender 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},"F-1.1.15","Air Valve Tee, 3000kPa, Steel X42, 300NB",{"$nulls":8},3]
[{"$nulls":3},"F-1.1.16","50mm NB stainless steel nipple, 300mm NB",{"$nulls":8},3]
[{"$nulls":3},"F-1.1.17","50mm NB SS Ball valve, full port screwed, PN16",{"$nulls":8},3]
[{"$nulls":3},"F-1.1.18","50mm NB SS double orifice air valve, anti-shock mechanism PN16",{"$nulls":8},3]
[{"$nulls":3},"F-1.1.19","Air Valve Tee both ends plain, restraining flanges as shown, 3000kPa, Steel X42, 300NB",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.20","50mm NB stainless steel nipple, 300mm NB",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.21","50mm NB SS Ball valve, full port screwed, PN16",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.22","50mm NB SS double orifice air valve, anti-shock mechanism PN16",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.23","150mm SG Flange adaptor PN16",{"$nulls":8},14]
[{"$nulls":3},"F-1.1.24","150mm Steel Straight pipe 1550mm long, one end flanged, other for cutting on site to suit PN16",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.25","150mm Mild steel NB Flange adaptor PN16",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.26","150mm Steel Air valve tee flanged PN16",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.27","25mm NB SS Nippel, 100mm long in the centre of a blank flange 150mm NB, PN16",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.28","25mm NB SS Ball valve, full port screwed, PN16",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.29","25mm NB SS double orifice air valve, anti-shock mechanism PN16",{"$nulls":8},7]
[{"$nulls":3},"F-1.1.30","150mm Steel Straight pipe both ends flanged, PN16",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.31","300/324mm Steel Straight pipe one end flanged, other for cutting on site to suit",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.32","300/324mm Steel Unequal lateral 45, one end flanged, others for cutting to suit on site, PN40",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.33","300mm MS Flange adaptor, PN40",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.34","300/324mm Steel Straight pipe one end flanged, other for cutting on site to suit, restraining flange as indicated",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.36","80mm MS wedge gate valve, flanged, PN40",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.37","80mm MS Flange adaptor, PN40",{"$nulls":8},1]
[{"$nulls":3},"Tender 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},"F-1.1.38","80/89mm Steel Straight pipe one end flanged, other for cutting on site to suit",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.39","80mm MS sleeve valve including hydraulic actuator, flanged, PN40",{"$nulls":8},1]
[{"$nulls":3},"F-1.1.40","300/324mm Steel Straight pipe one end flanged, other for cutting on site to suit",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.41","300/324mm Steel Unequal lateral 45, one end flanged, others for cutting to suit on site, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.42","300mm MS Flange adaptor, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.43","300/324mm Steel Straight pipe one end flanged, other for cutting on site to suit, restraining flange as indicated",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.44","80mm Steel elbow 45, flanged, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.45","80mm MS wedge gate valve, flanged, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.46","80mm MS Flange adaptor, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.47","80/89mm Steel Unequal lateral 45, one end flanged, others for cutting to suit on site, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.48","80/89mm Steel Straight pipe both ends flanged, restraining flange, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.49","80mm MS sleeve valve including hydraulic actuator, flanged, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.50","50mm MS Flange adaptor, PN40",{"$nulls":8},10]
[{"$nulls":3},"F-1.1.51","50mm MS wedge gate valve, flanged, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.52","50/65mm Steel Elbow 45, flanged, PN40",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.53","50/65mm Steel Elbow 45, one end flanged, other for cutting to suit on site",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.54","150mm NB SG Flange adaptor, PN16",{"$nulls":8},10]
[{"$nulls":3},"F-1.1.55","150/165mm Steel Straight pipe one end flanged, other for cutting on site to suit",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.56","150/165mm MS Flange adaptor, PN16",{"$nulls":8},5]
[{"$nulls":3},"F-1.1.57","Unequal tee rotated 45 downwards, flanged, PN16",{"$nulls":8},{"v":5,"d":"5 "}]
[{"$nulls":3},"F-1.1.58","150/165mm Steel Straight pipe both ends flanged.",{"$nulls":8},{"v":5,"d":"5 "}]
[{"$nulls":3},"F-1.1.59","300/324mm Steel Straight pipe both ends plain, restraining flanges as indicated, PN40",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"F-1.1.60","150mm NB SG flange adaptor PN16",{"$nulls":8},{"v":6,"d":"6 "}]
[{"$nulls":3},"F-1.1.61","150mm Steel Straight pipe one end flanged, other for cutting on site to suit PN16",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"Tender 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},"F-1.1.62","150mm NB MS flange adaptor PN16",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"F-1.1.63","Steel Unequal tee 150/100mm NB flanged, PN 16",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"F-1.1.64","150/166mm Steel Straight pipe both ends flanged",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"F-1.1.65","100mm NB Steel Resilient seal gate valve flanged, PN16",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"F-1.1.66","100mm NB MS flange adaptor PN16",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"F-1.1.67","100mm Steel straight pipe one end flanged, other for cutting on site to suit PN16 ",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"F-1.1.68","100mm NB SG flange adaptor PN16",{"$nulls":8},{"v":3,"d":"3 "}]
[{"$nulls":3},"F-1.1.69","300mm steel straight pipe one end flanged, other for cutting on site to suit,restrained flange as shown, PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.70","Blank flange PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.71","300mm steel straight pipe one end flanged, other for cutting on site to suit PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.72","300mm NB MS flange adaptor PN25",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.73","300mm NB,Three segments 45° elbow, both ends flanged, PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.74","Lateral 45|, 300/150 mm NB; Air Valve Stub 300 mm NB, 305 mm long; eccentric reducer 300/150 mm NB.",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.75","50mm NB SS nippel, 150mm long in the centre of a blank flange 300mm NB PN25, PN25",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.76","50mm NB SS ball valve, full port screwed PN25",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.77","50mm NB SS double orifice air valve, anti-shock mechanism PN25",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.78","150mm NB SS butterfly valve PN25",{"$nulls":8},{"v":4,"d":"4 "}]
[{"$nulls":3},"F-1.1.79","1150mm NB MS flange adaptor PN16",{"$nulls":8},{"v":4,"d":"4 "}]
[{"$nulls":3},"F-1.1.80","150mm steel straight pipe one end flanged, other for cutting on site to suit PN25",{"$nulls":8},{"v":4,"d":"4 "}]
[{"$nulls":3},"F-1.1.81","Strainer, flanged, PN25",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.82","150mm NB Pressure reducing, flow control valve, flanged, PN25",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.83","150mm NBLateral 45°, equal, Flanged, PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.84","250/150mm Eccentric Reducer, Flanged, PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.85","250mm steel straight pipe one end flanged, other for cutting on site to suit,restrained flange as shown, PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"Tender 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},"F-1.1.86","150mm NB, 45° elbow, both ends flanged, PN25",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.87","Air Valve Tee both ends plain, restraining flanges as shown, PN25, 300NB",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.88","Lateral 60 Equal rotated 45 downwards of horizontal plane flanged.  PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.89","300mm steel straight pipe one end flanged, other for cutting on site to suit PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.90","300mm NB SS butterfly valve PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.91","300mm steel straight pipe one end flanged, other for cutting on site to suit,restrained flange as shown, PN25",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.92","150mm NB SG flange adaptor PN16",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.93","150mm steel straight pipe one end flanged, other for cutting on site to suit PN16",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.94","150mm NB MS flange adaptor PN16",{"$nulls":8},{"v":2,"d":"2 "}]
[{"$nulls":3},"F-1.1.95","150mm turbine flow meter, flanged PN16",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.96","150mm steel straight pipe both ends flanged PN16",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.97","150mm Steel air valve tee flanged PN16",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.98","25mm NB SS nippel, 100mm long in the centre of a blank flange 150mm NB PN16",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.99","25mm NB SS ball valve, full port screwed PN16",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.100","25mm NB SS double orifice air valve, anti-shock mechanism screwed PN16",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.101","150mm NB resilient seal gate valve flanged PN16",{"$nulls":8},{"v":1,"d":"1 "}]
[{"$nulls":3},"F-1.1.102","Inlet Ventilator",{"$nulls":8},{"v":27,"d":"27 "}]
[{"$nulls":3},"F-1.1.103","Outlet Ventilator",{"$nulls":8},{"v":27,"d":"27 "}]
[{"$nulls":3},"F-1.1.104","Steel Ladder (as per specifications)",{"$nulls":8},{"v":27,"d":"27 "}]
[{"$nulls":3},"F-1.1.105","Manhole Cover",{"$nulls":8},{"v":27,"d":"27 "}]
[{"$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":69,"n_cols":16,"rows_kept":69,"merged":[[6,10,8,11],[8,4,8,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],[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],[46,2,46,6],[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],[54,2,54,3],[57,6,57,7],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[67,13,68,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,"LNW 02/21/22",{"$nulls":5},"Note: VAT to be excluded from all calculations"]
[null,"(D2)","Tender description: ",null,"Phase 1A:-Construction Of Musiphana Pipeline"]
[null,"(D3)","Designated Products:",null,"Steel and uPVC pipe, fittings and valves"]
[null,"(D4)","Tender Authority:",null,"Lepelle Northern Water"]
[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,null,"Total imported value"]
[null,null,"(D20)","(D21)",null,"(D22)","(D23)","(D24)","(D25)","(D26)","(D27)","(D28)","(D29)",null,"(D30)"]
{"$rows_empty":7}
[{"$nulls":3},"`"]
[{"$nulls":14},"(D32)Total imported value by tenderer"]
{"$rows_empty":11}
[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 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":43,"n_cols":10,"rows_kept":43,"merged":[[2,2,2,8],[4,2,4,9],[6,7,7,8],[8,4,8,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,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.",null,"LNW 02/21/22",null,null,"Note: VAT to be excluded from all calculations"]
[null,"(E2)","Tender description: ",null,"Phase 1A:-Construction Of Musiphana Pipeline"]
[null,"(E3)","Designated products:",null,"Steel and uPVC pipe, fittings and valves"]
[null,"(E4)","Tender Authority:",null,"Lepelle Northern Water"]
[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 from Annex B"]
[]
[]
[]
[null,null,"Date: "]