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

{"sheet":"Annex C","index":0,"n_rows":209,"n_cols":17,"rows_kept":209,"merged":[[6,5,6,8],[6,15,7,16],[7,5,7,11],[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],[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],[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],[132,4,132,5],[133,4,133,5],[134,4,134,5],[135,4,135,5],[136,4,136,5],[137,4,137,5],[138,4,138,5],[139,4,139,5],[140,4,140,5],[141,4,141,5],[142,4,142,5],[143,4,143,5],[144,4,144,5],[145,4,145,5],[146,4,146,5],[147,4,147,5],[148,4,148,5],[149,4,149,5],[150,4,150,5],[151,4,151,5],[152,4,152,5],[153,4,153,5],[154,4,154,5],[155,4,155,5],[156,4,156,5],[157,4,157,5],[158,4,158,5],[159,4,159,5],[160,4,160,5],[161,4,161,5],[162,4,162,5],[163,4,163,5],[164,4,164,5],[165,4,165,5],[166,4,166,5],[167,4,167,5],[168,4,168,5],[169,4,169,5],[170,4,170,5],[171,4,171,5],[172,4,172,5],[173,4,173,5],[174,4,174,5],[175,4,175,5],[176,4,176,5],[177,4,177,5],[178,4,178,5],[179,4,179,5],[180,4,180,5],[181,4,181,5],[182,4,182,5],[183,4,183,5],[184,4,184,5],[185,4,185,5],[186,4,186,5],[187,4,187,5],[188,4,188,5],[189,4,189,5],[190,4,190,5],[191,4,191,5],[192,4,192,5],[193,4,193,5],[194,4,194,5],[195,4,195,5],[196,4,196,5],[197,4,197,5],[198,4,198,5],[199,4,199,5],[200,4,200,5],[201,4,201,5],[202,4,202,5]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":16},"SATS 1286.2011"]
[{"$nulls":3},"Annex C"]
[]
[{"$nulls":3},"Local Content Declaration - Summary Schedule "]
[]
[null,null,"(C1)","Tender No.",null,"ADAB 10/2021",{"$nulls":9},"Note: VAT to be excluded from all calculations"]
[null,null,"(C2)","Tender description: ",null,"Contracting of an electrical contractor to render preventative maintenance services of electrical works for a period of twelve (12) months"]
[null,null,"(C3)","Designated product(s)",null,"Air insulated medium voltage switchgear products."]
[null,null,"(C4)","Tender Authority:",null,"Agribusiness Development Agency"]
[null,null,"(C5)","Tendering Entity name:"]
[null,null,"(C6)","Tender Exchange Rate:",null,"Pula",null,"EU",null,"GBP"]
[null,null,"(C7)","Specified local content %",null," 15% - for Instrument transformers and 5% for switching devices"]
[{"$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":4},"P1 PUMP STATION (ELECTRICAL SPARES)"]
[{"$nulls":3},"P1.1","Star delta timer (EM E48 - A/M 230V)"]
[{"$nulls":3},"P1.2","Current sensor (Rockwell bul 825-MCM (180-630A))"]
[{"$nulls":3},"P1.3","Overload Relay (Rockwell bul 825 ( MLV card)"]
[{"$nulls":3},"P1.4","Control fuses (GEC NSH & NS 2) 2A"]
[{"$nulls":3},"P1.5","Lockstop ON light (MC KRE 222 F (230V Amber))"]
[{"$nulls":3},"P1.6","Stop light (MC KRE 222 F (230V Red))"]
[{"$nulls":3},"P1.7","Overload trip light (MC KRE 22F (230V Amber))"]
[{"$nulls":3},"P1.8","Lamp test relay (Finder 55,34 230V)"]
[{"$nulls":3},"P1.9","Motor “stopped’’ relay (Finder 55,32 230V)"]
[{"$nulls":3},"P1.10","Lamp “running” relay (Finder 55,32 230V)"]
[{"$nulls":3},"P1.11","Overload trip relay (Finder 55,32 230V)"]
[{"$nulls":3},"P1.12","Lockstop “Ok” relay (Finder 55,32 230V)"]
[{"$nulls":3},"P1.13","Main contactor and coil (TM LC1-F150 220V & LADN 31)"]
[{"$nulls":3},"P1.14","Main contactor and coil (TM LC1-F185 220V & LADN 31)"]
[{"$nulls":3},"P1.15","Main contactor and coil (TM LC1-F225 220V & LADN 31)"]
[{"$nulls":3},"P1.16","Delta contactor and coil (TM LC1-F150 220V & LAN 22)"]
[{"$nulls":3},"P1.17","Delta contactor and coil (TM LC1-F185 220V & LAN 22)"]
[{"$nulls":3},"P1.18","Delta contactor and coil (TM LC1-F225 220V & LAN 22)"]
[{"$nulls":3},"P1.19","Star contactor and coil (TM LC1-F150 220V & LAN 22)"]
[{"$nulls":3},"P1.20","Star contactor and coil (TM LC1-F185 220V & LAN 22)"]
[{"$nulls":3},"P1.21","Star contactor and coil (TM LC1-F225 220V & LAN 22)"]
[{"$nulls":3},"P1.22","Mechanical interlock (TM LA9-FF970)"]
[{"$nulls":3},"P1.23","Ammeter (FbiA 96 250/5A)"]
[{"$nulls":3},"P1.24","Ammeter (FbiA 96 300/5A)"]
[{"$nulls":3},"P1.25","Main circuit breaker (M&G NS250N MA220 & VDH & Aux contacts)"]
[{"$nulls":3},"P1.26","Main circuit breaker (M&G NS400N MA320 & VDH & Aux contacts)"]
[{"$nulls":3},"P1.27","Control circuit breaker (M&G C45 10A)"]
[{"$nulls":3},"P1.28","Surge Arrestor (Soule P40)"]
[{"$nulls":3},"P1.29","MCC Stop push button (TM 2B2-BA4 & BC102)"]
[{"$nulls":3},"P1.30","MCC Start push button (TM 2B2-BA4 & BC101)"]
[{"$nulls":3},"P1.31","Current Transformer (Ring 250/5A class 1)"]
[{"$nulls":3},"P1.32","Current Transformer (Ring 300/5A class 1)"]
[{"$nulls":3},"P1.33","Capacitors (100 kvar, 440 V, C54-108/100, EN 60831-1/2, IEC 031-1/2)"]
[{"$nulls":3},"P1.34","Capacitors (50 kvar, 440 V, C54-108/100, EN 60831-1/2, IEC 031-1/2)"]
[{"$nulls":3},"P1.35","Fuses (NH00, gL-gG 160A 500 V, I=120 kA (EN 60 269, IEC 60269, VDE=0636)) "]
[{"$nulls":3},"P1.36","Contactor and coil (LC1 D80 220V) with its auxiliary contacts complete. (its for 37 kW motor)"]
[{"$nulls":3},"P1.37","Contactor and coil (LC1 D65 220V) with its auxiliary contacts complete. (its for 37 kW motor)"]
[{"$nulls":4},"P4 PUMP STATION (ELECTRICAL SPARES)"]
[{"$nulls":3},"P4.1","AB11:D50mmter (FA96 550/5A)"]
[{"$nulls":3},"P4.2","Combined fuse switch (LK NES-QSA 630-IEC 408)"]
[{"$nulls":3},"P4.3","Main contactor and coil (TM LC1-F500 220V & LADN 31))"]
[{"$nulls":3},"P4.4","Delta contactor and coil (TM LC1-F500 220V & LAN 22)"]
[{"$nulls":3},"P4.5","Star contactor and coil (TM LC1-F400 220V & LAN 22)"]
[{"$nulls":3},"P4.6","Current sensor (S&S CW3 5A)"]
[{"$nulls":3},"P4.7","Overload relay (S&S CET3-02)"]
[{"$nulls":3},"P4.8","Current transformer (Ring 550/5A 5P 10 10VA)"]
[{"$nulls":3},"P4.9","Hour meter (ATW 72 X 72 220V)"]
[{"$nulls":3},"P4.10","Lock stop Eng relay (S&S CS4 31Z 220V)"]
[{"$nulls":3},"P4.11","Lockstop “on” Light (SEL-LD-22D_A_230V)"]
[{"$nulls":3},"P4.12","Lamp test relay (S&S CS4 40E & Aux 04 220V)"]
[{"$nulls":3},"P4.13","Control circuit breaker (M&G C45 10A)"]
[{"$nulls":3},"P4.14","Overload trip relay (S&S CS4 40E 220V)"]
[{"$nulls":3},"P4.15","Run light (SEL-LD 22D-G 230V)"]
[{"$nulls":3},"P4.16","MCC Start push button (TM ZB2-BA3 & BZ 101)"]
[{"$nulls":3},"P4.17","MCC Stop push button (TM ZB2-BA4 & BZ 102)"]
[{"$nulls":3},"P4.18","Stop light (SEL-LD-22D-R-230V)"]
[{"$nulls":3},"P4.19","Overload trip light (SEL-LD-22D-A-230V)"]
[{"$nulls":3},"P4.20","Stardelta timer (S&S CS4 222 & CRZY4 220V)"]
[{"$nulls":3},"P4.21","Ammter (FBia 96 60/5A)"]
[{"$nulls":3},"P4.22","Combined fuse switch (K QSA T00N1)"]
[{"$nulls":3},"P4.23","Main contactor (Riker CA3-60 N11 220V)"]
[{"$nulls":3},"P4.24","Current sensor (S&S CW3 5A)"]
[{"$nulls":3},"P4.25","Overload relay (S&S CET3-02)"]
[{"$nulls":3},"P4.26","Current transformer (Ring 60/5A 5P 10 10VA)"]
[{"$nulls":3},"P4.27","Hour meter (ATM 72 X 72 220V)"]
[{"$nulls":3},"P4.28","Lock stop Eng relay (S&S CS4 40E 220V)"]
[{"$nulls":3},"P4.29","Lamp test relay (S&S CS4 40E & Aux 04)"]
[{"$nulls":3},"P4.30","Control circuit breaker (M&G C45 5A)"]
[{"$nulls":3},"P4.31","Overload trip relay (S&S CS4 40E 220V)"]
[{"$nulls":3},"P4.32","Lockstop “Ok” relay (Finder 55,32 230V)"]
[{"$nulls":3},"P4.33","Run light (SEL-LD 22D-G 2304)"]
[{"$nulls":3},"P4.34","MCC Start push button (TM ZB2-BA3 & BZ 101)"]
[{"$nulls":3},"P4.35","MCC Stop push button (TM ZB2-BA4 & BZ 102)"]
[{"$nulls":3},"P4.36","Stop light (SEL-LD-22D-R-230V)"]
[{"$nulls":3},"P4.37","Overload trip light (SEL-LD-22D-A-230V)"]
[{"$nulls":3},"P4.38","Current sensor (Rockwell Bul 825-MCM (180-630A))"]
[{"$nulls":3},"P4.39","Overload Relay (Rockwell Bul.825 & MLV Card)"]
[{"$nulls":3},"P4.40","Surge arrestor (Soule P40)"]
[{"$nulls":3},"P4.41","Control fuse (GEC NSH & NS)  for 630A"]
[{"$nulls":3},"P4.42","NH3  630 Fuse 630A"]
[{"$nulls":3},"P4.43","FF630 Fuse 630A"]
[{"$nulls":3},"P4.44","Thermal Overload relay RF 383800, 32.0-38.0 (18.5kw)"]
[{"$nulls":3},"P4.45","Thermal Overload relay RF 383800, 32.0-60.0 (60kw)"]
[{"$nulls":3},"P4.46","Smart motor manager"]
[{"$nulls":3},"P4.47","Current sensor (Rockwell Bul 825-MCM (180-630A)"]
[{"$nulls":3},"P4.48","Control fuse 8apms (GEC NSH & NS2)"]
[{"$nulls":3},"P4.49","Overload Relay (Rockwell Bul.825 & MLV Card)"]
[{"$nulls":3},"P4.50","Surge arrestor (Soule P40)"]
[{"$nulls":3},"P4.51","Motor protection relays (LT6 - P0M005)"]
[{"$nulls":3},"P4.52","PFC Capacitors (2x15KVAR)"]
[{"$nulls":3},"P4.53","Current sensor (S&S CW3-5A)"]
[{"$nulls":3},"P4.54","Overload Relay (S&S CET3-02)"]
[{"$nulls":3},"P4.55","Overload Trip Relay (S&S CS4 40E 220v)"]
[{"$nulls":4},"CENTRAL PUMP STATION (ELECTRICAL SPARES)"]
[{"$nulls":3},"PC.1","CB11:B42B11:B40ircuit breakers (NS400-300A)"]
[{"$nulls":3},"PC.2","PFC Circuit breakers (C60N 63A TP)"]
[{"$nulls":3},"PC.3","Pushbuttons (ZB4 –B2 + BA)"]
[{"$nulls":3},"PC.4","Relays (56.32 – 220V)"]
[{"$nulls":3},"PC.5","Circuit breaker (C60 6Â DP (10kA))"]
[{"$nulls":3},"PC.6","Motor Protection Relays (LT6 – P0M005)"]
[{"$nulls":3},"PC.7","Current transformers (300/1A Ring)"]
[{"$nulls":3},"PC.8","Ammeters (Fa96 300/1A)"]
[{"$nulls":3},"PC.9","Hourmeters (RH48, 220V)"]
[{"$nulls":3},"PC.10","Indicating lights (XB4 –BV)"]
[{"$nulls":3},"PC.11","PFC Capacitors (2 x 15 KVAR)"]
[{"$nulls":3},"PC.12","Timer (T2M – 220V)"]
[{"$nulls":3},"PC.13","Thermistor Relays (BC511 – 220V)"]
[{"$nulls":3},"PC.14","Relays (MK3 – P 220V)"]
[{"$nulls":3},"PC.15","Circuit breaker (C60 6A DP (10kA)"]
[{"$nulls":3},"PC.16","Siren (Eagle S2, 220V)"]
[{"$nulls":3},"PC.17","Level Relay (61F – GP 220V)"]
[{"$nulls":3},"PC.18","Timer (H3BA – 8)"]
[{"$nulls":3},"PC.19","Circuit breaker (TM63D 63A (25 kA))"]
[{"$nulls":3},"PC.20","Circuit breaker (C60N 16A TP (10 kA))"]
[{"$nulls":3},"PC.21","Circuit breaker (C60N 10A SP (10 kA))"]
[{"$nulls":3},"PC.22","Circuit breaker (C60N 63A SP (10 kA))"]
[{"$nulls":3},"PC.23","Circuit breaker (C60N 15A DP + 30 mA E/L (10 kA))"]
[{"$nulls":3},"PC.24","Main incomer ACB (C1250N 1250A, 25 kA)"]
[{"$nulls":3},"PC.25","Voltmeter Selector Switch (C10 – A007)"]
[{"$nulls":3},"PC.26","Voltmeter Circuit breakers (GV2 – P10)"]
[{"$nulls":3},"PC.27","Current Transformers 1500/5A"]
[{"$nulls":3},"PC.28","Voltmeter (Fv96 0-500V)"]
[{"$nulls":3},"PC.29","Ammeters (Fa96 1500/5A)"]
[{"$nulls":3},"PC.30","Kwh Meter (MH-36H/5A)"]
[{"$nulls":3},"PC.31","Surge Arrestors (8142-01-26)"]
[{"$nulls":3},"PC.32","Adaptors 3 way (3 x 16A)"]
[{"$nulls":3},"PC.33","160A T/P Circuit breaker complete with shaft."]
[{"$nulls":3},"PC.34","60A contactor"]
[{"$nulls":3},"PC.35","Thermistor with 8 pin"]
[{"$nulls":3},"PC.36","Flow switch"]
[{"$nulls":3},"PC.37","Current Transformer (15A, 300:1)"]
[{"$nulls":3},"PC.38","Emergency stop buttons complete with bases shroud yellow (CEPY 1-0)"]
[{"$nulls":3},"PC.39","Mushroom push buttons (MPM1-10R M/R mom 40mm no MCBH&MCB BB)"]
[{"$nulls":3},"PC.40","16A Rubber 3 pin plug"]
[{"$nulls":3},"PC.41","Schuko Extensions cords 16A 1.5mm x 3 core cable with 4 socket outlet."]
[{"$nulls":3},"PC.42","Cable marker kit (1 beech case, 1 tool, 1 hook and 1000 cable markers with number 0-9 and letters from A-Z +- earth"]
[{"$nulls":3},"PC.43","Capacitors (100 kvar, 440 V, C54-108/100, EN 60831-1/2, IEC 031-1/2)"]
[{"$nulls":4},"P14 PUMP STATION (ELECTRICAL SPARES)"]
[{"$nulls":3},"P14.1","Circuit breakers (NS400-300A)"]
[{"$nulls":3},"P14.2","Motor Protection Relays (LT6 – P0M005)(Telemecanique) x 1"]
[{"$nulls":3},"P14.3","Timer (Delay on energise)"]
[{"$nulls":3},"P14.4","Timer multi range"]
[{"$nulls":3},"P14.5","Main contractor, auxiliary and coil (TM LCF1-F225 220V)"]
[{"$nulls":3},"P14.6","Delta contractor, auxiliary and coil (TM LCF1-F225 220V)"]
[{"$nulls":3},"P14.7","Star contractor, auxiliary and coil (TM LCF1-F225 220V)"]
[{"$nulls":3},"P14.8","Surge Arrestors (8142-01-26)"]
[{"$nulls":3},"P14.9","Current transformers (300/1A Ring)"]
[{"$nulls":3},"P14.10","Circuit breakers (NS250-300A)"]
[{"$nulls":3},"P14.11","Motor Protection Relays (LT6 – P0M005)"]
[{"$nulls":3},"P14.12","Star contactor and coil (TM LC1-F185 220V & LAN 22)"]
[{"$nulls":3},"P14.13","Ammter (FBia 96 60/5A)"]
[{"$nulls":3},"P14.14","Contactor and coil (LC1 D80 220V) with its auxiliary contacts complete. (its for 37 kW motor)"]
[{"$nulls":3},"P14.15","Contactor and coil (LC1 D65 220V) with its auxiliary contacts complete. (its for 37 kW motor)"]
[{"$nulls":4},"P12 PUMP STATION (ELECTRICAL SPARES)"]
[{"$nulls":3},"P12.1","Contactor and coil (LC1 D80 220V) with its auxiliary contacts complete. (its for 37 kW motor)"]
[{"$nulls":3},"P12.2","Contactor and coil (LC1 D65 220V) with its auxiliary contacts complete. (its for 37 kW motor)"]
[{"$nulls":3},"P12.3","Timer (Delay on energise)"]
[{"$nulls":3},"P12.4","Timer multi range"]
[{"$nulls":3},"P12.5","Main contractor, auxiliary and coil (TM LCF1-F225 220V)"]
[{"$nulls":3},"P12.6","Delta contractor, auxiliary and coil (TM LCF1-F225 220V)"]
[{"$nulls":3},"P12.7","Star contractor, auxiliary and coil (TM LCF1-F225 220V)"]
[{"$nulls":3},"P12.8","Surge Arrestors (8142-01-26)"]
[{"$nulls":3},"P12.9","Current transformers (300/1A Ring)"]
[{"$nulls":3},"P12.10","Circuit breakers (NS250-300A)"]
[{"$nulls":3},"P12.11","Motor Protection Relays (LT6 – P0M005)"]
[{"$nulls":3},"P12.12","Star contactor and coil (TM LC1-F185 220V & LAN 22)"]
[{"$nulls":3},"P12.13","Ammter (FBia 96 60/5A)"]
[{"$nulls":4},"BLOCK 6,7 & 8 PUMP STATION (ELECTRICAL SPARES)"]
[{"$nulls":3},"BLK1","MEC GMC - 100 contactors (LG)"]
[{"$nulls":3},"BLK2","MEC GMC - 65 contactors (LG)"]
[{"$nulls":3},"BLK3","Relay DP 1 Delay on energise (Dynamics)"]
[{"$nulls":3},"BLK4","Relay IAP 1 Interval timer pulse start (Dynamics"]
[{"$nulls":3},"BLK5","Star delta timer SDT (Avanti)"]
[{"$nulls":3},"BLK6","Electronic overload Relay EOLR (Avanti)"]
[{"$nulls":3},"BLK7","Taliana Rele (D4N-230AC)"]
[{"$nulls":3},"BLK8","Distance control unit float output 24V D.C (DCU)"]
[{"$nulls":3},"BLK9","Surge Arrestors (8142-01-26)"]
[{"$nulls":3},"BLK10","Circuit breakers (NS250-300A)"]
[{"$nulls":3},"BLK11","Motor Protection Relays (LT6 – P0M005)"]
[{"$nulls":3},"BLK12","Star contactor and coil (TM LC1-F185 220V & LAN 22)"]
[{"$nulls":3},"BLK13","Ammter (FBia 96 60/5A)"]
[{"$nulls":3},"BLK14","Contactor and coil (LC1 D80 220V) with its auxiliary contacts complete. (its for 37 kW motor)"]
[{"$nulls":3},"BLK15","Contactor and coil (LC1 D65 220V) with its auxiliary contacts complete. (its for 37 kW motor)"]
[{"$nulls":3},"BLK16","Thermal Overload relay RF 383800, 32.0-38.0 (18.5kw)"]
[{"$nulls":3},"BLK17","Thermal Overload relay RF 383800, 32.0-60.0 (60kw)"]
[]
[{"$nulls":13}," (C20)  Total tender  value",{"v":0,"d":"R  0"}]
[{"$nulls":3},"Signature of tenderer from Annex B",{"$nulls":10},"(C21) Total Exempt imported content",{"v":0,"d":"R  0"}]
[{"$nulls":14},"(C22) Total Tender value net of exempt imported content",{"v":0,"d":"R  0"}]
[{"$nulls":15},"(C23) Total Imported content",{"v":0,"d":"R  0"}]
[{"$nulls":15},"(C24) Total local content",{"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,4,6,7],[6,10,8,11],[7,4,7,9],[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],[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]],"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,"ADAB 10/2021",{"$nulls":5},"Note: VAT to be excluded from all calculations"]
[null,"(D2)","Tender description: ",null,"Contracting of an electrical contractor to render preventative maintenance services of electrical works for a period of twelve (12) months"]
[null,"(D3)","Designated Products:"]
[null,"(D4)","Tender Authority:",null,"Agribusiness Development Agency"]
[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",{"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":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]],"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.",{"$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)",{"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: "]