{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Cover","PS5","PS5 Summary","Transport and Offloading Matrix","CPA Formula","Exchnge Rates"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":41,"n_cols":1,"rows_kept":41,"merged":[[28,0,28,1],[31,0,31,1]]}
{"$rows_empty":10}
["PRICING INFORMATION"]
[]
["INVITATION TO TENDER"]
[]
[" ENQUIRY No. "]
["FOR"]
["Description:"]
[]
[]
[]
["TENDERER’S NAME:  "]
[]
[]
[]
["THE PRICE:  IN RAND (excluding VAT) :"]
["THE PRICE:  IN RAND (Including VAT) :"]
["RAND VALUE IN WORDS EXCLUDING VAT"]
[]
["Estimated value: "]
[]
["RAND VALUE IN WORDS INCLUDING VAT"]
["Estimated value: "]
[]
["DATE :"]
[]
[]
["AUTHORISED SIGNATORY "]
[]
["NAME :"]
[]
["DESIGNATION :"]

{"sheet":"PS5","index":1,"n_rows":89,"n_cols":37,"rows_kept":89,"merged":[[7,9,9,9],[7,10,9,10],[7,11,9,11],[7,12,9,12],[7,13,9,13],[7,14,9,14],[7,15,9,15],[7,16,9,16],[7,17,9,17],[7,18,9,18],[7,19,9,19],[7,20,9,20],[7,21,9,21],[7,22,9,22],[7,23,9,23],[7,24,9,24],[7,25,9,25],[7,26,9,26],[7,27,9,27],[7,28,9,28],[7,29,9,29],[7,30,9,30],[7,31,9,31],[7,32,9,32],[7,33,9,33],[7,34,9,34],[7,35,9,35],[7,36,9,36],[55,9,57,9],[55,10,57,10],[55,11,57,11],[55,12,57,12],[55,13,57,13],[55,14,57,14],[55,15,57,15],[55,16,57,16],[55,17,57,17],[55,18,57,18],[55,19,57,19],[55,20,57,20],[55,21,57,21],[55,22,57,22],[55,23,57,23],[55,24,57,24],[55,25,57,25],[55,26,57,26],[55,27,57,27],[55,28,57,28],[55,29,57,29],[55,30,57,30],[55,31,57,31],[55,32,57,32],[55,33,57,33],[55,34,57,34],[55,35,57,35],[55,36,57,36]]}
["ENQUIRY NUMBER :",{"$nulls":3},"                                      PRICES INCLUSIVE OF VAT (VALUE ADDED TAX)"]
[]
[" PRICE SCHEDULE : C (PS5) :   ",{"$nulls":34},"SUPPLIER:"]
[]
[" PRICE SCHEDULE FOR GOODS MANUFACTURED IN AND OUTSIDE THE R.S.A.  PRICE PER UNIT FOR SUPPLY, DELIVERY AND OFF LOADING.  ALL AMOUNTS EXPRESSED IN RANDS"]
[]
[" REMARKS",{"$nulls":5},"                       ITEM NO",null,null,"Item 1","Item 2","Item 3","Item 4","Item 5","Item 6","Item 7","Item 8","Item 9","Item 10","Item 11","Item 12","Item 13","Item 14","Item 15","Item 16","Item 17","Item 18","Item 19","Item 20","Item 21","Item 22","Item 23","Item 24","Item 25","Item 26","Item 27","Item 28"]
[" *Eskom may effect this insurance which includes war",{"$nulls":5},"                  ITEM DESCRIPTION",null,null,"0000663307-Specific: 48 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663301-Specific: 110 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663304-Specific: 220 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663309-Specific: 48 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663412-Specific: 110 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663416-Specific: 220 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663417-Specific: 48 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663418-Specific: 110 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663277-Specific: 220 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663303-Specific: 48 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663306-Specific: 110 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663289-Specific: 220 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663483-48V DC Power Supply - G3LI","0000663482-110V DC Power Supply - G3LK 100V to 250V DC","0000663480-220V DC Power Supply - G3LK 100V to 230V DC","0000663419-X.21 Communications Module - G3LD","0000663420-FO Driver Module 1310nm - 30km","0000663423-FO Driver Module 1310nm - 60km","0000663421-FO Driver Module 1550nm - 120km","0000663426-E1 2.048Mbps Communications Module - G1LE","0000663424-Ethernet/LAN Communications Module - G3LE","0000663507-CPU and Module Rack - G7BI","0000663427-Channel/Relay Interface (input/output) - G3LRa","0000663509-LED Alarm/Trip Indications Module - Built into Item 22 G7BI","0000663310-HMI Software including instruction manual on CD.","0000663428-Instruction Manual/Handbooks - Hardcopy","0000663486-HMI cable and USB/serial adapter","0000663508-Protection Interface Adaptor (with wiring)"]
["   risk insurance"]
["**Please specify"]
[{"$nulls":9},10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37]
["SUPPLIED FROM OUTSIDE R.S.A.:",{"$nulls":7},"(In ZAR)"]
["1: F.O.B. PRICE",{"$nulls":7},"(In ZAR)"]
["2: COST OF SEA  FREIGHT",{"$nulls":7},"(In ZAR)"]
["3: COST OF AIR  FREIGHT",{"$nulls":7},"(In ZAR)"]
["4: COST OF MARINE INSURANCES *",{"$nulls":7},"(In ZAR)"]
["5: TOTAL PRICE DELIVERED PORT R.S.A. ...",{"$nulls":5},"(1+2+3+4)",null,"(In ZAR)",{"$f":"SUM(J13:J16)","v":0},{"$f":"SUM(K13:K16)","v":0},{"$f":"SUM(L13:L16)","v":0},{"$f":"SUM(M13:M16)","v":0},{"$f":"SUM(N13:N16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AJ13:AJ16)","v":0},{"$f":"SUM(AK13:AK16)","v":0}]
["6: WHARFAGE",{"$nulls":7},"(In ZAR)"]
["7: LANDING CHARGES",{"$nulls":7},"(In ZAR)"]
["8: CUSTOMS DUTIES",{"$nulls":7},"(In ZAR)"]
["9: IMPORT SURCHARGE",{"$nulls":7},"(In ZAR)"]
["10: OTHER**",{"$nulls":7},"(In ZAR)"]
["11: COST OF IMPORTATION ...",{"$nulls":5},"(6+7+8+9+10)",null,"(In ZAR)",{"$f":"SUM(J18:J22)","v":0},{"$f":"SUM(K18:K22)","v":0},{"$f":"SUM(L18:L22)","v":0},{"$f":"SUM(M18:M22)","v":0},{"$f":"SUM(N18:N22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AJ18:AJ22)","v":0},{"$f":"SUM(AK18:AK22)","v":0}]
["12: COST OF RAIL TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
["13: COST OF ROAD TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
["14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ...",{"$nulls":5},"(12+13)",null,"(In ZAR)",{"$f":"SUM(J24:J25)","v":0},{"$f":"SUM(K24:K25)","v":0},{"$f":"SUM(L24:L25)","v":0},{"$f":"SUM(M24:M25)","v":0},{"$f":"SUM(N24:N25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AJ24:AJ25)","v":0},{"$f":"SUM(AK24:AK25)","v":0}]
["15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE...",{"$nulls":5},"(5+11+14)",null,"(In ZAR)",{"$f":"J17+J23+J26","v":0},{"$f":"K17+K23+K26","v":0},{"$f":"L17+L23+L26","v":0},{"$f":"M17+M23+M26","v":0},{"$f":"N17+N23+N26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AJ17+AJ23+AJ26","v":0},{"$f":"AK17+AK23+AK26","v":0}]
[]
["SUPPLIED FROM INSIDE R.S.A."]
["16: F.O.R. PRICE-GOODS MANUFACTURED INSIDE R.S.A."]
["17: F.O.R. PRICE-GOODS SUPPLIED FROM IMPORTED ITEMS"]
["18: TOTAL F.O.R. PRICE ...",{"$nulls":5},"(16+17)",null,null,{"$f":"SUM(J30:J31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K30:K31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L30:L31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M30:M31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N30:N31)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(AJ30:AJ31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AK30:AK31)","v":{"v":0,"d":"0.00"}}]
["19: COST OF RAIL TRANSPORT"]
["20: COST OF ROAD TRANSPORT"]
["21: COST OF TRANSPORT WORKS TO SITE ...          ",{"$nulls":5},"(19+20)",null,null,{"$f":"SUM(J33:J34)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K33:K34)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L33:L34)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M33:M34)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N33:N34)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(AJ33:AJ34)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AK33:AK34)","v":{"v":0,"d":"0.00"}}]
["22: PRICE (F.O.R.) DELIVERED TO SITE ...          ",{"$nulls":5},"(18+21)",null,null,{"$f":"J32+J35","v":{"v":0,"d":"0.00"}},{"$f":"K32+K35","v":{"v":0,"d":"0.00"}},{"$f":"L32+L35","v":{"v":0,"d":"0.00"}},{"$f":"M32+M35","v":{"v":0,"d":"0.00"}},{"$f":"N32+N35","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"AJ32+AJ35","v":{"v":0,"d":"0.00"}},{"$f":"AK32+AK35","v":{"v":0,"d":"0.00"}}]
[" SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) "]
["23: LOCAL LABOUR"]
["24: EXPATRIATE  LABOUR"]
["25: TOTAL PRICE FOR SITE WORK ...          ",{"$nulls":5},"(23+24)",null,null,{"$f":"SUM(J38:J39)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K38:K39)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L38:L39)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M38:M39)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N38:N39)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(AJ38:AJ39)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AK38:AK39)","v":{"v":0,"d":"0.00"}}]
["26: OVERSEAS ENGINEERING SERVICES"]
["27: LOCAL ENGINEERING SERVICES"]
["28: TOTAL PRICE FOR ENGINEERING SERVICES...",{"$nulls":5},"(26+27)",null,null,{"$f":"SUM(J41:J42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K41:K42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L41:L42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M41:M42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N41:N42)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(AJ41:AJ42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AK41:AK42)","v":{"v":0,"d":"0.00"}}]
["29: TOTAL PRICE EXCLUDING VAT",{"$nulls":8},{"$f":"J27+J36+J43+J40","v":{"v":0,"d":"0.00"}},{"$f":"K27+K36+K43+K40","v":{"v":0,"d":"0.00"}},{"$f":"L27+L36+L43+L40","v":{"v":0,"d":"0.00"}},{"$f":"M27+M36+M43+M40","v":{"v":0,"d":"0.00"}},{"$f":"N27+N36+N43+N40","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"AJ27+AJ36+AJ43+AJ40","v":{"v":0,"d":"0.00"}},{"$f":"AK27+AK36+AK43+AK40","v":{"v":0,"d":"0.00"}}]
["29. VAT",{"$nulls":8},{"$f":"J44*15%","v":{"v":0,"d":"0.00"}},{"$f":"K44*15%","v":{"v":0,"d":"0.00"}},{"$f":"L44*15%","v":{"v":0,"d":"0.00"}},{"$f":"M44*15%","v":{"v":0,"d":"0.00"}},{"$f":"N44*15%","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"AJ44*15%","v":{"v":0,"d":"0.00"}},{"$f":"AK44*15%","v":{"v":0,"d":"0.00"}}]
["30: TOTAL  PRICE INCLUDING VAT",{"$nulls":5},"(27+36+46)",null,null,{"$f":"J44+J45","v":{"v":0,"d":"0.00"}},{"$f":"K44+K45","v":{"v":0,"d":"0.00"}},{"$f":"L44+L45","v":{"v":0,"d":"0.00"}},{"$f":"M44+M45","v":{"v":0,"d":"0.00"}},{"$f":"N44+N45","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"AJ44+AJ45","v":{"v":0,"d":"0.00"}},{"$f":"AK44+AK45","v":{"v":0,"d":"0.00"}}]
["ENQUIRY NUMBER :",{"$nulls":3},"                                      PRICES INCLUSIVE OF VAT (VALUE ADDED TAX)"]
[]
[{"$f":"A3","v":" PRICE SCHEDULE : C (PS5) :   "},{"$nulls":34},"SUPPLIER:"]
[]
[" PRICE SCHEDULE FOR GOODS MANUFACTURED OUTSIDE THE R.S.A.  PRICE PER UNIT FOR ENGINEERING, MANUFACTURE, SUPPLY AND DELIVERY.  ALL AMOUNTS EXPRESSED IN FOREIGN CURRENCY (UP TO LINE 49)."]
[]
[]
[" REMARKS",{"$nulls":5},"                       ITEM NO",null,null,{"$f":"J7","v":"Item 1"},"Item 2","Item 3","Item 4","Item 5","Item 6","Item 7","Item 8","Item 9","Item 10","Item 11","Item 12","Item 13","Item 14","Item 15","Item 16","Item 17","Item 18","Item 19","Item 20","Item 21","Item 22","Item 23","Item 24","Item 25","Item 26","Item 27","Item 28"]
[{"$nulls":9},{"$f":"J8","v":"0000663307-Specific: 48 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch"},{"$f":"K8","v":"0000663301-Specific: 110 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch"},"0000663304-Specific: 220 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663309-Specific: 48 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663412-Specific: 110 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663416-Specific: 220 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663417-Specific: 48 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663418-Specific: 110 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663277-Specific: 220 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663303-Specific: 48 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663306-Specific: 110 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663289-Specific: 220 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663483-48V DC Power Supply - G3LI","0000663482-110V DC Power Supply - G3LK 100V to 250V DC","0000663480-220V DC Power Supply - G3LK 100V to 230V DC","0000663419-X.21 Communications Module - G3LD","0000663420-FO Driver Module 1310nm - 30km","0000663423-FO Driver Module 1310nm - 60km","0000663421-FO Driver Module 1550nm - 120km","0000663426-E1 2.048Mbps Communications Module - G1LE","0000663424-Ethernet/LAN Communications Module - G3LE","0000663507-CPU and Module Rack - G7BI","0000663427-Channel/Relay Interface (input/output) - G3LRa","0000663509-LED Alarm/Trip Indications Module - Built into Item 22 G7BI","0000663310-HMI Software including instruction manual on CD.","0000663428-Instruction Manual/Handbooks - Hardcopy","0000663486-HMI cable and USB/serial adapter","0000663508-Protection Interface Adaptor (with wiring)"]
[" *Eskom may effect this insurance which includes war",{"$nulls":5},"                  ITEM DESCRIPTION",null,null,{"$f":"J8","v":"0000663307-Specific: 48 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch"},{"$f":"K8","v":"0000663301-Specific: 110 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch"},{"$f":"L8","v":"0000663304-Specific: 220 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch"},{"$f":"M8","v":"0000663309-Specific: 48 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch"},{"$f":"N8","v":"0000663412-Specific: 110 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch"},{"$f":"O8","v":"0000663416-Specific: 220 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch"},"0000663417-Specific: 48 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663418-Specific: 110 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663277-Specific: 220 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663303-Specific: 48 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663306-Specific: 110 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663289-Specific: 220 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","0000663483-48V DC Power Supply - G3LI","0000663482-110V DC Power Supply - G3LK 100V to 250V DC","0000663480-220V DC Power Supply - G3LK 100V to 230V DC","0000663419-X.21 Communications Module - G3LD","0000663420-FO Driver Module 1310nm - 30km","0000663423-FO Driver Module 1310nm - 60km","0000663421-FO Driver Module 1550nm - 120km","0000663426-E1 2.048Mbps Communications Module - G1LE","0000663424-Ethernet/LAN Communications Module - G3LE","0000663507-CPU and Module Rack - G7BI","0000663427-Channel/Relay Interface (input/output) - G3LRa","0000663509-LED Alarm/Trip Indications Module - Built into Item 22 G7BI","0000663310-HMI Software including instruction manual on CD.","0000663428-Instruction Manual/Handbooks - Hardcopy",{"$f":"AJ8","v":"0000663486-HMI cable and USB/serial adapter"},{"$f":"AK8","v":"0000663508-Protection Interface Adaptor (with wiring)"}]
["   risk insurance"]
["**Please specify"]
["PRICE DELIVERED TO PORT R.S.A. (LINE 5)",{"$nulls":6},"(In Foreign Currency)"]
["31: CURRENCY A   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
["32: CURRENCY B   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
["33: CURRENCY C   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
["34: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["35: CURRENCY E   1 ZAR=............",null,null,"(INSURANCE)",{"$nulls":3},"(In Foreign Currency)"]
["36: TOTAL F.O.B. PRICE ",{"$nulls":5},"(5=31+32+33+34+35)"]
["PRICE EXPATRIATE LABOUR (LINE 25)",{"$nulls":6},"(In Foreign Currency)"]
["37: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["38: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["39: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["40: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["41: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
["42.TOTAL PRICE EXPATRIATE LABOUR ",{"$nulls":5},"(24=37+38+39+40+41)"]
["PRICE OVERSEAS ENGINEERING SERVICES (LINE 27)",{"$nulls":6},"(In Foreign Currency)"]
["43: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["44: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["45: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["46: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["47: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
["48: TOTAL PRICE OVERSEAS ENGINEERING SERVICES (LINE 26) ",{"$nulls":6},"(26=43+44+45+46+47)"]
["49: FOREIGN CONTENT OF TOTAL PRICE",{"$nulls":5},"(36+42+48)"]
["LOCAL PREFERENCE FOR ELECTRONICS ONLY"]
["50. FOR PRICE GOODS MANUFACTURED IN R.S.A. (LINE 16)"]
["51. PRICE FOR LOCAL DESIGN / ENGINEERING SERVICES (LINE 27) "]
["52. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 50"]
["53. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 51"]
["54. TOTAL AMOUNT CLAIMED ",null,null,"(52 + 53)"]
[]
[]
["SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................"]

{"sheet":"PS5 Summary","index":2,"n_rows":41,"n_cols":24,"rows_kept":41,"merged":[[6,6,6,11],[6,12,6,14],[6,15,6,21],[6,22,8,22],[6,23,8,23],[7,6,7,11],[7,12,7,14],[7,15,7,21]]}
["SCHEDULE OF PRICES"]
[]
["ESKOM NSD TENDER"]
[]
["SUPPLY OF NSD570"]
[]
["YOUR REF: ",{"$nulls":5},{"$f":"'PS5'!A12","v":"SUPPLIED FROM OUTSIDE R.S.A.:"},{"$nulls":5},{"$f":"'PS5'!A29","v":"SUPPLIED FROM INSIDE R.S.A."},null,null,{"$f":"'PS5'!A37","v":" SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) "},{"$nulls":6},"Total Unit Rate","Total Amount (Excl.VAT)"]
[{"$nulls":6},"In Local Currency",{"$nulls":5},"In Local Currency",null,null,"In Local Currency"]
["ITEM","SAP No.","QTY","DESCRIPTION","Unit of Measurement","Qty","R.o.E",{"$f":"'PS5'!A17","v":"5: TOTAL PRICE DELIVERED PORT R.S.A. ..."},"R.o.E",{"$f":"'PS5'!A23","v":"11: COST OF IMPORTATION ..."},{"$f":"'PS5'!A26","v":"14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ..."},{"$f":"'PS5'!A27","v":"15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE..."},{"$f":"'PS5'!A32","v":"18: TOTAL F.O.R. PRICE ..."},{"$f":"'PS5'!A35","v":"21: COST OF TRANSPORT WORKS TO SITE ...          "},{"$f":"'PS5'!A36","v":"22: PRICE (F.O.R.) DELIVERED TO SITE ...          "},{"$f":"'PS5'!A38","v":"23: LOCAL LABOUR"},"R.o.E",{"$f":"'PS5'!A39","v":"24: EXPATRIATE  LABOUR"},"R.o.E",{"$f":"'PS5'!A41","v":"26: OVERSEAS ENGINEERING SERVICES"},{"$f":"'PS5'!A42","v":"27: LOCAL ENGINEERING SERVICES"},{"$f":"'PS5'!A43","v":"28: TOTAL PRICE FOR ENGINEERING SERVICES..."}]
[]
[1,"0000663307",20,"0000663307-Specific: 48 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":20,"d":"20.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"K11+J11+H11","v":0},{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"SUM(M11:N11)","v":0},{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D11,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"P11+R11+T11+U11","v":0},{"$f":"L11+O11+V11","v":0},{"$f":"W11*F11","v":0}]
[2,"0000663301",104,"0000663301-Specific: 110 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":104,"d":"104.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"K12+J12+H12","v":0},{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"SUM(M12:N12)","v":0},{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D12,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"P12+R12+T12+U12","v":0},{"$f":"L12+O12+V12","v":0},0]
[3,"0000663304",20,"0000663304-Specific: 220 VDC power supply and X.21 communication interface Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":20,"d":"20.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D13,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[4,"0000663309",20,"0000663309-Specific: 48 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":20,"d":"20.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D14,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[5,"0000663412",30,"0000663412-Specific: 110 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":30,"d":"30.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D15,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[6,"0000663416",20,"0000663416-Specific: 220 VDC power supply and Fibre Optic Driver - 1310nm 30km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":20,"d":"20.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D16,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[7,"0000663417",3,"0000663417-Specific: 48 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":3,"d":"3.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D17,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[8,"0000663418",3,"0000663418-Specific: 110 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":3,"d":"3.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D18,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[9,"0000663277",3,"0000663277-Specific: 220 VDC power supply and Fibre Optic Driver - 1310nm 60km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":3,"d":"3.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D19,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[10,"0000663303",3,"0000663303-Specific: 48 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":3,"d":"3.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D20,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[11,"0000663306",4,"0000663306-Specific: 110 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":4,"d":"4.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D21,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[12,"0000663289",4,"0000663289-Specific: 220 VDC power supply and Fibre Optic Driver - 1550nm 120km Generic: includes module rack, CPU module, 4 channels (input/output), Protection Interface Adaptors,  LED (Alarm/Trip) indications, HMI Software, on/off switch","No",{"v":4,"d":"4.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D22,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[13,"0000663483",1,"0000663483-48V DC Power Supply - G3LI","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D23,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[14,"0000663482",1,"0000663482-110V DC Power Supply - G3LK 100V to 250V DC","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D24,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[15,"0000663480",1,"0000663480-220V DC Power Supply - G3LK 100V to 230V DC","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D25,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[16,"0000663419",1,"0000663419-X.21 Communications Module - G3LD","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D26,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[17,"0000663420",1,"0000663420-FO Driver Module 1310nm - 30km","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D27,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[18,"0000663423",1,"0000663423-FO Driver Module 1310nm - 60km","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D28,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[19,"0000663421",1,"0000663421-FO Driver Module 1550nm - 120km","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D29,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[20,"0000663426",1,"0000663426-E1 2.048Mbps Communications Module - G1LE","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D30,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[21,"0000663424",1,"0000663424-Ethernet/LAN Communications Module - G3LE","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D31,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[22,"0000663507",1,"0000663507-CPU and Module Rack - G7BI","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D32,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[23,"0000663427",1,"0000663427-Channel/Relay Interface (input/output) - G3LRa","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D33,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[24,"0000663509",1,"0000663509-LED Alarm/Trip Indications Module - Built into Item 22 G7BI","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D34,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[25,"0000663310",1,"0000663310-HMI Software including instruction manual on CD.","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D35,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[26,"0000663428",1,"0000663428-Instruction Manual/Handbooks - Hardcopy","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D36,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[27,"0000663486",1,"0000663486-HMI cable and USB/serial adapter","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D37,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[28,"0000663508",1,"0000663508-Protection Interface Adaptor (with wiring)","No",{"v":1,"d":"1.00"},null,{"$f":"VLOOKUP(H$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(J$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(K$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(M$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(N$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},0,{"$f":"VLOOKUP(P$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(R$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},null,{"$f":"VLOOKUP(T$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},{"$f":"VLOOKUP(U$9,'PS5'!$A:$AK,INDEX('PS5'!$11:$11,MATCH('PS5 Summary'!$D38,'PS5'!$8:$8,0)),FALSE)","v":0},0,0,0]
[]
[]
[{"$nulls":23},{"$f":"SUM(X11:X40)","v":0}]

{"sheet":"Transport and Offloading Matrix","index":3,"n_rows":34,"n_cols":12,"rows_kept":34,"merged":[[0,0,0,11],[2,0,3,4],[2,5,3,11],[4,0,5,4],[4,5,5,11],[6,0,7,4],[6,5,7,11],[8,0,11,0],[8,1,11,1],[8,2,8,11],[9,2,9,11],[10,2,10,11],[33,0,33,11],[34,0,34,11],[35,0,35,11],[36,0,36,11]]}
["TRANSPORT AND OFF LOADING COSTS"]
[]
[" ENQUIRY NO"]
[]
["COMMODITY",{"$nulls":4},"TPE"]
[]
["SUPPLIER"]
[]
["Item","Round Trip Distance [km]","Prices in South African Currency (Excluding VAT)"]
[null,null,"Transport to site or regional store and off-loading"]
[null,null,"Total Units [No]"]
[null,null,"0-10","11 - 20","21 - 30","31 - 40","41 - 50","51 - 60","61-70","71 - 80","81 - 90","91 - 100"]
[1,"0 - 100"]
[2,"101 - 200"]
[3,"201 - 300"]
[4,"301 - 400"]
[5,"401 - 500"]
[6,"501 - 600"]
[7,"601 - 700"]
[8,"701 - 800"]
[9,"801 - 900"]
[10,"901 - 1000"]
[11,"1001 - 1100"]
[12,"1101 - 1200"]
[13,"1201 - 1300"]
[14,"1301 - 1400"]
[15,"1401 - 1500"]
[16,"1501 - 2000"]
[17,"2001 - 2500"]
[18,"2501 - 3000"]
[19,"3001 - 3500"]
[]
[]
["COMMENTS:"]

{"sheet":"CPA Formula","index":4,"n_rows":148,"n_cols":14,"rows_kept":148,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,4],[8,2,8,3],[8,5,8,7],[9,2,9,4],[9,5,18,7],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[21,1,21,6],[22,1,22,6],[25,1,25,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[32,1,32,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[36,1,36,6],[40,1,40,6],[51,1,51,6],[62,1,62,6],[73,1,73,6],[84,1,84,6],[95,1,95,6],[106,1,106,6],[117,1,117,6],[128,1,128,6],[139,1,139,6]]}
["Enquiry No."]
["Package Name:"]
["Tenderer's Name:"]
["Category of Offer:",null,"Main Offer Only"]
[]
["CONTRACT PRICE ADJUSTMENT (CPA) FOR INFLATION"]
[]
["No.","Formula Code","Summary of the description of the Tenderer's Formulae"]
[1,"Fixed","Firm and Fixed ",null,null,"Prices are 100 % fixed and firm. CPA is not applicable. "]
[2,"A",{"$f":"B41","v":"Tenderer's description of Formula A"},null,null,"Type in the description of each formula in the tables below"]
[3,"B",{"$f":"B52","v":"Tenderer's description of Formula B"}]
[4,"C",{"$f":"B63","v":"Tenderer's description of Formula C"}]
[5,"D",{"$f":"B74","v":"Tenderer's description of Formula D"}]
[6,"E",{"$f":"B85","v":"Tenderer's description of Formula E"}]
[7,"F",{"$f":"B96","v":"Tenderer's description of Formula F"}]
[8,"G",{"$f":"B107","v":"Tenderer's description of Formula G"}]
[9,"H",{"$f":"B118","v":"Tenderer's description of Formula H"}]
[10,"I",{"$f":"B129","v":"Tenderer's description of Formula I"}]
[11,"J",{"$f":"B140","v":"Tenderer's description of Formula J"}]
[]
["SPECIFIC REQUIREMENTS"]
[{"v":1,"d":"1."},"Only Main Offer is to be submitted. Main offer tenderers are to fully comply with the requirements in the General Notes and CPA Formulae Notes below."]
[{"v":2,"d":"2."},"No ALTERNATIVE offers are accepted."]
[]
["GENERAL NOTES :"]
[1,"References to \"indices\" below mean \"cost indices or reference prices\"."]
[2,"Where 5 year historical information must be provided as instructed below, internet address references which are accessible to the general public may be submitted by the Tenderer instead, with the specific electronic route and web page reflecting the applicable data."]
[3,"The worksheet  CPA Formula in PS5 Summary has to be populated by the tenderer (Row 10:10), unless the tenderer’s prices are fixed and firm for the duration of the contract. Each CPA formula must add up to a total of 100%.  All columns are to be populated. No inhouse CPA indices may be used. Tenderers are to provide all requested information.CPA Formulae should represent cost breakdown of the goods/commodities/components/items being sourced.\n"]
[4,"CPA Formulae Codes B8:B19 above is to be populated by the tenderer in PS5 Summary row 10:10, by selecting the respective drop down codes CPA formula as  developed by Tenderer hereunder. Codes and descriptions must be selected by the tenderer and inserted into each row of activity. "]
[5,"Prices will be fixed and firm for the first twelve (12) months after contract signing date and escalated on an annual basis based on the CPA formula agreed on with tenderer."]
[6,"The CPA escalation will be calculated as follows: latest index which is the latest available index at the end of each contractual year vs. the base index which is one month prior to tender closing date. "]
["CPA FORMULA NOTES :"]
[1,"Proportions/weightings in CPA Formulae: The fixed portion of each formula, not subject to CPA, must be at least 15% but Tenderers may submit higher fixed portion percentages.  The other constituent indices and their proportions in each formula must be realistic and relative to the applicable work. The fixed portion and other proportions must add up to 100%.   "]
[2,"Formulae must be linked to independent cost indices or other benchmarks (\"reference prices\") and must be clearly and completely defined. The source must be a recognised and independent statistical publishing organisation.  The Tenderers' in-house indices may not be used."]
[3,"Local Price CPA: Where local indices other than those published by SEIFSA or Statistics SA are specified, the Tenderer must submit 5 years' of month by month historical data for such indices.  The Tenderer must ensure that indices are published and recommended by the source thereof as applicable to the work involved and that they are still in force/use and applicable at the date of submission of the tender. "]
[4,"CPA Base Date: The CPA base date for calculating price movements will be the Base Date, Month before Tender closes. For indices or reference prices published as at certain dates, and where such a date is not the Base Date, the latest date for which it is published before the Base Date will be considered as the Base Date index or reference price.  In instances where the figure or value is not as at the Base Date or considered as the Base Date Index or reference price as explained herein, the date, figure or value as well as the reason for the deviation must be clearly separately stated and must be realistic for purposes of CPA.  "]
[5,"Base Date Index :   The base index or reference price must be inserted in the appropriate column."]
[" "," "]
[]
[]
["Formula A","Tenderer's description of Formula A"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide http link)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["A1"]
["A2"]
["A3"]
["A4"," "]
["A5"]
["A6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B43:B48)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula B","Tenderer's description of Formula B"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["B1"]
["B2"," "]
["B3"]
["B4"," "]
["B5"," "]
["B6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B54:B59)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula C","Tenderer's description of Formula C"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["C1",{"$nulls":4}," "," "," "]
["C2"," "]
["C3"]
["C4"," "]
["C5"," "]
["C6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B65:B70)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula D","Tenderer's description of Formula D"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["D1"," "]
["D2"," "]
["D3"]
["D4"," "]
["D5"," "]
["D6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B76:B81)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula E","Tenderer's description of Formula E"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["E1"," "]
["E2"," "]
["E3"]
["E4"," "]
["E5"," "]
["E6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B87:B92)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula F","Tenderer's description of Formula F"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["F1"]
["F2"]
["F3"]
["F4"]
["F5"]
["F6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B98:B103)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula G","Tenderer's description of Formula G"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["G1"," "]
["G2"," "]
["G3"," "]
["G4"]
["G5"," "]
["G6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B109:B114)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula H","Tenderer's description of Formula H"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["H1"," "]
["H2"," "]
["H3"," "]
["H4"," "]
["H5"," "]
["H6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B120:B125)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula I","Tenderer's description of Formula I"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["I1"," "]
["I2"," "]
["I3"," "]
["I4"]
["I5"," "]
["I6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B131:B136)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula J","Tenderer's description of Formula J"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["J1"," "]
["J2"]
["J3"," "]
["J4"," "]
["J5"," "]
["J6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B142:B147)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]

{"sheet":"Exchnge Rates","index":5,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[0,0,0,1],[0,2,0,4],[1,0,1,1],[1,2,1,4],[2,0,2,1],[2,2,2,4],[7,1,7,6],[8,0,10,0],[8,1,8,6],[8,14,8,19],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,0,15,0],[13,1,13,6],[14,1,14,6],[15,1,15,6],[20,7,20,12]]}
["Enquiry No.",null,{"$f":"Cover!B15","v":0}]
["Package Name:",null,{"$f":"Cover!B17","v":0}]
["Tenderer's Name:",null,{"$f":"Cover!B21","v":0}]
[]
["5.1.4 EXCHANGE RATES FOR MULTIPLE CURRENCIES"]
[]
["NOTES:"]
[1,"The table below needs to be completed if the Employer will be exposed to any currency fluctuation as stipulated in Secondary Clause X3.  For conversion of the foreign portions to Rand, please use the South African Reserve Bank's (SARB) exchange rate at 12:00 on the day of advertisement of the bid.  This is in terms of the Preferential Procurement Policy Framework Act (PPPFA) with which the Employer has to comply.\nNB: Tenderers must submit proof of the SARB rate(s) of exchange used  "]
[2,"The following URL (electronic route) is to be followed to access the relevant SARB rates on their web pages:\n"]
[null,"www.resbank.co.za"]
[null,"-  Select Research\n-  Then select Rates\n-  Click on \"Select historical exchange rates and other interest rates\"\n-  Clicking on the exchange rate in the following page opens the daily rates per currency and SA Rand"]
[3,"The Employer deals only in the currencies listed below unless other currencies are specifically approved for this tender.  Kindly notify the Employer of any currency that the tenderer intends to use, but is not stipulated in the table, to consider sanctioning such currency.  Sufficient time must be allowed for the assessment and to respond to such request.  The onus is on the tenderer to submit a bid with approved currencies"]
[4,"The format in which the exchange rate must be inserted in the table is:  1 (One) Foreign Currency = R Amount  (i.e. the Rand amount for one of each foreign currency applicable).  Exchange rates must be rounded to 4 decimals\n\nNB :  Only the USD/ZAR, GBP/ZAR and EUR/ZAR are published in this way on the SARB web pages above.  The Rand rate with the other currencies must be inverted (1/Foreign Currency Rate) in order to list it in the required format in the table below\n"]
[5,"All information in the table below must conform with all other equivalent information in the offer. "]
[null,"Payment in terms of Payment Method 2  is considered as a \"foreign payment\" although it will be effected in South African Rand. However, amounts for  \"F.O.R. Price-Goods supplied from Imported Items\", are NOT considered as \"foreign payments\""]
[null,"If more than one payment method apply for a currency, the Tenderer must request an additional row be inserted in the table in order to split the values and identify the relevant method.   "]
[" "]
[" "]
["EXCHANGE RATES PUBLISHED BY SARB"]
["NB: Tenderers must submit proof of the SARB rate (s) of exchange used."]
[{"$nulls":4},"Date for which the rates are published :",null,null,"Date to be inserted in the following format: Day, Month and Year.\n\nMust be the SARB rate at 12:00 on day of advertisement of bid"]
["No","Currency Description","Code","Exchange Rate\nCurrency 1,00 = R Amount","Payment Method 1a, 1b or 2","Source"]
[1,"South African Rand","ZAR",{"v":1,"d":"R 1.00"}]
[2,"Australian Dollar","AUD",{"v":0,"d":"R 0.00"}]
[3,"Canadian Dollar","CAN",{"v":0,"d":"R 0.00"}]
[4,"Swiss Franc","CHF",{"v":0,"d":"R 0.00"}]
[5,"Danish Krone","DKK",{"v":0,"d":"R 0.00"}]
[6,"European Currency","EUR",{"v":0,"d":"R 0.00"}]
[7,"British Pound","GBP",{"v":0,"d":"R 0.00"}]
[8,"Hong Kong Dollar","HKD",{"v":0,"d":"R 0.00"}]
[9,"Japanese Yen","JPY",{"v":0,"d":"R 0.00"}]
[10,"Norwegian Krone","NOK",{"v":0,"d":"R 0.00"}]
[11,"New Zealand Dollar","NZD",{"v":0,"d":"R 0.00"}]
[12,"Swedish Krone","SEK",{"v":0,"d":"R 0.00"}]
[13,"Singapore Dollar","SGD",{"v":0,"d":"R 0.00"}]
[14,"United States Dollar","USD",{"v":0,"d":"R 0.00"}]