{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Tender Cover Sheet"," (PS5) "," (PS5)  Training","5.1.1 Pricing Schedule","Summary","Transp & Offload OPT A","Transp & Offload OPT B","5.1.2 CPA Formula","5.1.3  Exchange Rates"],"not_rendered":{"images":1,"external_links":49,"defined_names":1460},"read":"whole","date_system":"1900"}

{"sheet":"Tender Cover Sheet","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"merged":[[7,2,10,4]]}
[]
[]
[null,null,"Enquiry No.","E1291NTCSAMWP"]
[null,null,"Package Name:","SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"]
[null,null,"Tenderer's Name:"]
{"$rows_empty":7}
[null,null,"PRICING INFORMATION"]
[]
[null,null,"RAND VALUE IN WORDS","[Price in Words]"," "]
[]
[]
[null,null,"TENDERED PRICE:  IN ZAR"]
[null,null,"(excluding VAT)"]
[]
[null,null,"TENDERED PRICE:  IN ZAR"]
[null,null,"(including VAT)"]
[]
[]
[]
[null,null,"DATE :"," "]
[]
[]
[null,null,"FULL NAMES OF SIGNATORY:"," "]
[]
[]
[null,null,"DESIGNATION OF SIGNATORY:"," "]
[]
[]
[null,null,"SIGNATURE :"]
[{"$nulls":4}," "]

{"sheet":" (PS5) ","index":1,"n_rows":97,"n_cols":18,"rows_kept":97,"merged":[[9,7,9,9],[10,10,12,10],[10,11,12,11],[10,12,12,12],[10,13,12,13],[10,14,12,14],[10,15,12,15],[10,16,12,16],[10,17,12,17],[11,7,11,9],[62,7,62,9],[63,10,65,10],[63,11,65,11],[63,12,65,12],[63,13,65,13],[63,14,65,14],[63,15,65,15],[63,16,65,16],[63,17,65,17],[64,7,64,9]]}
[]
[]
[null,"ENQUIRY NUMBER : ",null,"E1291NTCSAMWP"]
[{"$nulls":16},"SUPPLIER NAME"]
[null,"PACKAGE NAME:",null,{"$f":"'Tender Cover Sheet'!D4","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[]
[null,"PRICE SCHEDULE FOR GOODS MANUFACTURED IN AND OUTSIDE THE R.S.A.  PRICE PER UNIT FOR SUPPLY, DELIVERY AND ERECTION / INSTALLATION.  ALL AMOUNTS EXPRESSED IN RANDS"]
[null,""]
[null," REMARKS",{"$nulls":5},"                       ITEM NO",null,null,1,2,3,4,5,6,7,8]
[{"$nulls":7},"SAP NO"]
[null," *Eskom may effect this insurance which includes war",{"$nulls":8},{"$f":"'5.1.1 Pricing Schedule'!C12","v":"Digital transducer only. No analogue outputs."},{"$f":"'5.1.1 Pricing Schedule'!C13","v":"Digital transducer with a minimum of four galvanic isolated analogue outputs."},{"$f":"'5.1.1 Pricing Schedule'!C14","v":"Digital transducer with a minimum of six galvanic isolated analogue outputs."},{"$f":"'5.1.1 Pricing Schedule'!C15","v":"Digital display"},{"$f":"'5.1.1 Pricing Schedule'!C16","v":"2 x Independent digital transducers (item 1) fitted inside a 19” rack with 2 x independent digital displays."},{"$f":"'5.1.1 Pricing Schedule'!C17","v":"2 x Independent digital transducers (item 2) fitted inside a 19” rack with 2 x independent digital displays."},{"$f":"'5.1.1 Pricing Schedule'!C18","v":"2 x Independent digital transducers (item 3) fitted inside a 19” rack with 2 x independent digital displays."},{"$f":"'5.1.1 Pricing Schedule'!C19","v":"Transducer: configuration cable"}]
[null,"   risk insurance",{"$nulls":5}," ITEM DESCRIPTION"]
[null,"**Please specify"]
[null,"SUPPLIED FROM OUTSIDE R.S.A.:",{"$nulls":7},"(In ZAR)"]
[null,"1: F.O.B. PRICE",{"$nulls":7},"(In ZAR)"]
[null,"2: COST OF SEA  FREIGHT",{"$nulls":7},"(In ZAR)"]
[null,"3: COST OF AIR  FREIGHT",{"$nulls":7},"(In ZAR)"]
[null,"4: COST OF MARINE INSURANCES *",{"$nulls":7},"(In ZAR)"]
[null,"5: TOTAL PRICE DELIVERED PORT R.S.A. ...",{"$nulls":5},"(1+2+3+4)",null,"(In ZAR)",{"$f":"SUM(K15:K18)","v":0},{"$f":"SUM(L15:L18)","v":0},0,0,{"$f":"SUM(O15:O18)","v":0},0,0,{"$f":"SUM(R15:R18)","v":0}]
[null,"6: WHARFAGE",{"$nulls":7},"(In ZAR)"]
[null,"7: LANDING CHARGES",{"$nulls":7},"(In ZAR)"]
[null,"8: CUSTOMS DUTIES",{"$nulls":7},"(In ZAR)"]
[null,"9: IMPORT SURCHARGE",{"$nulls":7},"(In ZAR)"]
[null,"10: OTHER**",{"$nulls":7},"(In ZAR)"]
[null,"11: COST OF IMPORTATION ...",{"$nulls":5},"(6+7+8+9+10)",null,"(In ZAR)",{"$f":"SUM(K20:K24)","v":0},{"$f":"SUM(L20:L24)","v":0},{"$f":"SUM(M20:M24)","v":0},{"$f":"SUM(N20:N24)","v":0},{"$f":"SUM(O20:O24)","v":0},0,0,{"$f":"SUM(R20:R24)","v":0}]
[null,"12: COST OF RAIL TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[null,"13: COST OF ROAD TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[null,"14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ...",{"$nulls":5},"(12+13)",null,"(In ZAR)",{"$f":"SUM(K26:K27)","v":0},{"$f":"SUM(L26:L27)","v":0},0,0,{"$f":"SUM(O26:O27)","v":0},0,0,{"$f":"SUM(R26:R27)","v":0}]
[null,"15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE...",{"$nulls":5},"(5+11+14)",null,"(In ZAR)",{"$f":"K19+K25+K28","v":0},{"$f":"L19+L25+L28","v":0},0,0,{"$f":"O19+O25+O28","v":0},0,0,{"$f":"R19+R25+R28","v":0}]
[]
[null,"SUPPLIED FROM INSIDE R.S.A."]
[null,"16: F.O.R. PRICE-GOODS MANUFACTURED INSIDE R.S.A."]
[null,"17: F.O.R. PRICE-GOODS SUPPLIED FROM IMPORTED ITEMS"]
[null,"18: TOTAL F.O.R. PRICE ...",{"$nulls":5},"(16+17)",null,null,{"$f":"SUM(K32:K33)","v":0},{"$f":"SUM(L32:L33)","v":0},0,0,{"$f":"SUM(O32:O33)","v":0},0,0,{"$f":"SUM(R32:R33)","v":0}]
[null,"19: COST OF RAIL TRANSPORT"]
[null,"20: COST OF ROAD TRANSPORT"]
[null,"21: COST OF TRANSPORT WORKS TO SITE ...          ",{"$nulls":5},"(19+20)",null,null,{"$f":"SUM(K35:K36)","v":0},{"$f":"SUM(L35:L36)","v":0},{"$f":"SUM(M35:M36)","v":0},0,{"$f":"SUM(O35:O36)","v":0},0,0,{"$f":"SUM(R35:R36)","v":0}]
[null,"22: PRICE (F.O.R.) DELIVERED TO SITE ...          ",{"$nulls":5},"(18+21)",null,null,{"$f":"K34+K37","v":0},0,0,0,{"$f":"O34+O37","v":0},0,0,{"$f":"R34+R37","v":0}]
[null,"SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) "]
[null,"23: LOCAL LABOUR"]
[null,"24: EXPATRIATE  LABOUR"]
[null,"25: TOTAL PRICE FOR SITE WORK ...          ",{"$nulls":5},"(23+24)",null,null,{"$f":"SUM(K40:K41)","v":0},{"$f":"SUM(L40:L41)","v":0},0,0,{"$f":"SUM(O40:O41)","v":0},0,0,{"$f":"SUM(R40:R41)","v":0}]
[null,"26: OVERSEAS ENGINEERING SERVICES",{"$nulls":8},0,0,0,0,0,0,0,0]
[null,"27: LOCAL ENGINEERING SERVICES"]
[null,"28: TOTAL PRICE FOR ENGINEERING SERVICES...",{"$nulls":5},"(26+27)",null,null,{"$f":"SUM(K43:K44)","v":0},{"$f":"SUM(L43:L44)","v":0},0,0,{"$f":"SUM(O43:O44)","v":0},0,0,{"$f":"SUM(R43:R44)","v":0}]
[null,"29: TOTAL PRICE EXCLUDING VAT",{"$nulls":8},{"$f":"K36+K42+K45+K29","v":0},{"$f":"L36+L42+L45+L29","v":0},{"$f":"M36+M42+M45+M29","v":0},0,{"$f":"O36+O42+O45+O29","v":0},0,0,{"$f":"R36+R42+R45+R29","v":0}]
[null,"29. VAT AT 15%",{"$nulls":8},{"$f":"K46*0.15","v":0},{"$f":"L46*0.15","v":0},{"$f":"M46*0.15","v":0},{"$f":"N46*0.15","v":0},0,0,0,{"$f":"R46*0.15","v":0}]
[null,"30: TOTAL  PRICE INCLUDING VAT",{"$nulls":5},"(27+36+46)",null,null,{"$f":"SUM(K46:K47)","v":0},{"$f":"SUM(L46:L47)","v":0},0,0,{"$f":"SUM(O46:O47)","v":0},0,0,{"$f":"SUM(R46:R47)","v":0}]
[]
[null,"SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................"]
[]
[]
[]
[]
[null,{"$f":"B3","v":"ENQUIRY NUMBER : "},null,{"$f":"D3","v":"E1291NTCSAMWP"},null,"                                      PRICES INCLUSIVE OF VAT (VALUE ADDED TAX)"]
[]
[null,{"$f":"B5","v":"PACKAGE NAME:"}]
[]
[null,"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)."]
[]
[]
[null," REMARKS",{"$nulls":5},"                       ITEM NO",null,null,{"$f":"K9","v":1},2,3,4,{"$f":"O9","v":5},6,7,{"$f":"R9","v":8}]
[{"$nulls":7},"SAP NO",null,null,0,0,0,0,{"$f":"O10","v":0},0,0,{"$f":"R10","v":0}]
[null," *Eskom may effect this insurance which includes war",{"$nulls":8},"Digital transducer only. No analogue outputs.","Digital transducer with a minimum of four galvanic isolated analogue outputs.","Digital transducer with a minimum of six galvanic isolated analogue outputs.","Digital display",{"$f":"O11","v":"2 x Independent digital transducers (item 1) fitted inside a 19” rack with 2 x independent digital displays."},"2 x Independent digital transducers (item 2) fitted inside a 19” rack with 2 x independent digital displays.","2 x Independent digital transducers (item 3) fitted inside a 19” rack with 2 x independent digital displays.",{"$f":"R11","v":"Transducer: configuration cable"}]
[null,"   risk insurance",{"$nulls":5}," ITEM DESCRIPTION"]
[null,"**Please specify"]
[null,"PRICE DELIVERED TO PORT R.S.A. (LINE 5)",{"$nulls":6},"(In Foreign Currency)"]
[null,"31: CURRENCY A   1 ZAR=",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"32: CURRENCY B   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"33: CURRENCY C   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"34: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"35: CURRENCY E   1 ZAR=............",null,null,"(INSURANCE)",{"$nulls":3},"(In Foreign Currency)"]
[null,"36: TOTAL F.O.B. PRICE ",{"$nulls":5},"(5=31+32+33+34+35)"]
[null,"PRICE EXPATRIATE LABOUR (LINE 25)",{"$nulls":6},"(In Foreign Currency)"]
[null,"37: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"38: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"39: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"40: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"41: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[null,"42.TOTAL PRICE EXPATRIATE LABOUR ",{"$nulls":5},"(24=37+38+39+40+41)"]
[null,"PRICE OVERSEAS ENGINEERING SERVICES (LINE 27)",{"$nulls":6},"(In Foreign Currency)"]
[null,"43: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"44: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"45: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"46: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"47: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[null,"48: TOTAL PRICE OVERSEAS ENGINEERING SERVICES (LINE 26) ",{"$nulls":6},"(26=43+44+45+46+47)"]
[null,"49: FOREIGN CONTENT OF TOTAL PRICE",{"$nulls":5},"(36+42+48)"]
[null,"LOCAL PREFERENCE FOR ELECTRONICS ONLY"]
[null,"50. FOR PRICE GOODS MANUFACTURED IN R.S.A. (LINE 16)"]
[null,"51. PRICE FOR LOCAL DESIGN / ENGINEERING SERVICES (LINE 27) "]
[null,"52. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 50"]
[null,"53. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 51"]
[null,"54. TOTAL AMOUNT CLAIMED ",null,null,"(52 + 53)"]
[]
[]
[null,"SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................"]

{"sheet":" (PS5)  Training","index":2,"n_rows":97,"n_cols":11,"rows_kept":97,"merged":[[9,7,9,9],[10,10,12,10],[11,7,11,9],[62,7,62,9],[63,10,65,10],[64,7,64,9]]}
[]
[]
[null,"ENQUIRY NUMBER : ",null,{"$f":"'Tender Cover Sheet'!D3","v":"E1291NTCSAMWP"}]
[{"$nulls":9},"SUPPLIER NAME"]
[null,"PACKAGE NAME:",null,{"$f":"'Tender Cover Sheet'!D4","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[]
[null,"PRICE SCHEDULE FOR GOODS MANUFACTURED IN AND OUTSIDE THE R.S.A.  PRICE PER UNIT FOR SUPPLY, DELIVERY AND ERECTION / INSTALLATION.  ALL AMOUNTS EXPRESSED IN RANDS"]
[null,""]
[null," REMARKS",{"$nulls":5},"                       ITEM NO",null,null,9]
[{"$nulls":7},"SAP NO"]
[null," *Eskom may effect this insurance which includes war",{"$nulls":8},{"$f":"'5.1.1 Pricing Schedule'!C20","v":"Training per session (min 10 candidates)"}]
[null,"   risk insurance",{"$nulls":5}," ITEM DESCRIPTION"]
[null,"**Please specify"]
[null,"SUPPLIED FROM OUTSIDE R.S.A.:",{"$nulls":7},"(In ZAR)"]
[null,"1: F.O.B. PRICE",{"$nulls":7},"(In ZAR)"]
[null,"2: COST OF SEA  FREIGHT",{"$nulls":7},"(In ZAR)"]
[null,"3: COST OF AIR  FREIGHT",{"$nulls":7},"(In ZAR)"]
[null,"4: COST OF MARINE INSURANCES *",{"$nulls":7},"(In ZAR)"]
[null,"5: TOTAL PRICE DELIVERED PORT R.S.A. ...",{"$nulls":5},"(1+2+3+4)",null,"(In ZAR)",{"$f":"SUM(K15:K18)","v":0}]
[null,"6: WHARFAGE",{"$nulls":7},"(In ZAR)"]
[null,"7: LANDING CHARGES",{"$nulls":7},"(In ZAR)"]
[null,"8: CUSTOMS DUTIES",{"$nulls":7},"(In ZAR)"]
[null,"9: IMPORT SURCHARGE",{"$nulls":7},"(In ZAR)"]
[null,"10: OTHER**",{"$nulls":7},"(In ZAR)"]
[null,"11: COST OF IMPORTATION ...",{"$nulls":5},"(6+7+8+9+10)",null,"(In ZAR)",{"$f":"SUM(K20:K24)","v":0}]
[null,"12: COST OF RAIL TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[null,"13: COST OF ROAD TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[null,"14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ...",{"$nulls":5},"(12+13)",null,"(In ZAR)",{"$f":"SUM(K26:K27)","v":0}]
[null,"15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE...",{"$nulls":5},"(5+11+14)",null,"(In ZAR)",{"$f":"K19+K25+K28","v":0}]
[]
[null,"SUPPLIED FROM INSIDE R.S.A."]
[null,"16: F.O.R. PRICE-GOODS MANUFACTURED INSIDE R.S.A."]
[null,"17: F.O.R. PRICE-GOODS SUPPLIED FROM IMPORTED ITEMS"]
[null,"18: TOTAL F.O.R. PRICE ...",{"$nulls":5},"(16+17)",null,null,{"$f":"SUM(K32:K33)","v":0}]
[null,"19: COST OF RAIL TRANSPORT"]
[null,"20: COST OF ROAD TRANSPORT"]
[null,"21: COST OF TRANSPORT WORKS TO SITE ...          ",{"$nulls":5},"(19+20)",null,null,{"$f":"SUM(K35:K36)","v":0}]
[null,"22: PRICE (F.O.R.) DELIVERED TO SITE ...          ",{"$nulls":5},"(18+21)",null,null,{"$f":"K34+K37","v":0}]
[null,"SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) "]
[null,"23: LOCAL LABOUR"]
[null,"24: EXPATRIATE  LABOUR"]
[null,"25: TOTAL PRICE FOR SITE WORK ...          ",{"$nulls":5},"(23+24)",null,null,{"$f":"SUM(K40:K41)","v":0}]
[null,"26: OVERSEAS ENGINEERING SERVICES",{"$nulls":8},0]
[null,"27: LOCAL ENGINEERING SERVICES"]
[null,"28: TOTAL PRICE FOR ENGINEERING SERVICES...",{"$nulls":5},"(26+27)",null,null,{"$f":"SUM(K43:K44)","v":0}]
[null,"29: TOTAL PRICE EXCLUDING VAT",{"$nulls":8},{"$f":"K36+K42+K45+K29","v":0}]
[null,"29. VAT AT 15%",{"$nulls":8},{"$f":"K46*0.15","v":0}]
[null,"30: TOTAL  PRICE INCLUDING VAT",{"$nulls":5},"(27+36+46)",null,null,{"$f":"SUM(K46:K47)","v":0}]
[]
[null,"SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................"]
[]
[]
[]
[]
[null,{"$f":"B3","v":"ENQUIRY NUMBER : "},null,{"$f":"D3","v":"E1291NTCSAMWP"},null,"                                      PRICES INCLUSIVE OF VAT (VALUE ADDED TAX)"]
[]
[null,{"$f":"B5","v":"PACKAGE NAME:"}]
[]
[null,"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)."]
[]
[]
[null," REMARKS",{"$nulls":5},"                       ITEM NO",null,null,{"$f":"K9","v":9}]
[{"$nulls":7},"SAP NO",null,null,0]
[null," *Eskom may effect this insurance which includes war",{"$nulls":8},"Training per session (min 10 candidates)"]
[null,"   risk insurance",{"$nulls":5}," ITEM DESCRIPTION"]
[null,"**Please specify"]
[null,"PRICE DELIVERED TO PORT R.S.A. (LINE 5)",{"$nulls":6},"(In Foreign Currency)"]
[null,"31: CURRENCY A   1 ZAR=",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"32: CURRENCY B   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"33: CURRENCY C   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"34: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"35: CURRENCY E   1 ZAR=............",null,null,"(INSURANCE)",{"$nulls":3},"(In Foreign Currency)"]
[null,"36: TOTAL F.O.B. PRICE ",{"$nulls":5},"(5=31+32+33+34+35)"]
[null,"PRICE EXPATRIATE LABOUR (LINE 25)",{"$nulls":6},"(In Foreign Currency)"]
[null,"37: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"38: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"39: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"40: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"41: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[null,"42.TOTAL PRICE EXPATRIATE LABOUR ",{"$nulls":5},"(24=37+38+39+40+41)"]
[null,"PRICE OVERSEAS ENGINEERING SERVICES (LINE 27)",{"$nulls":6},"(In Foreign Currency)"]
[null,"43: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"44: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"45: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"46: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"47: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[null,"48: TOTAL PRICE OVERSEAS ENGINEERING SERVICES (LINE 26) ",{"$nulls":6},"(26=43+44+45+46+47)"]
[null,"49: FOREIGN CONTENT OF TOTAL PRICE",{"$nulls":5},"(36+42+48)"]
[null,"LOCAL PREFERENCE FOR ELECTRONICS ONLY"]
[null,"50. FOR PRICE GOODS MANUFACTURED IN R.S.A. (LINE 16)"]
[null,"51. PRICE FOR LOCAL DESIGN / ENGINEERING SERVICES (LINE 27) "]
[null,"52. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 50"]
[null,"53. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 51"]
[null,"54. TOTAL AMOUNT CLAIMED ",null,null,"(52 + 53)"]
[]
[]
[null,"SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................"]

{"sheet":"5.1.1 Pricing Schedule","index":3,"n_rows":23,"n_cols":13,"rows_kept":23}
[]
[]
[null,"ENQUIRY NUMBER : ","E1291NTCSAMWP"]
[]
[null,"PACKAGE NAME:",{"$f":"'Tender Cover Sheet'!$D$4","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[]
[null,"PRICING SCHEDULE "]
[]
[]
[null,"Column1","Column2","Column24","Column25","Column22","Column225","Column224","Column223","Column23","Column232"]
[null,"Item No.","Description","Central"," Eastern","Northern","North East","Southern","Western","Quantity","Rate","Amount","CPA Formula              (Use the dropdown menu to select the applicable CPA formula)"]
[null,1,"Digital transducer only. No analogue outputs.",0,0,0,15,0,0,{"$f":"SUM(Table4243137[[#This Row],[Column24]:[Column223]])","v":15},null,{"$f":"K12*J12","v":{"v":0,"d":"R0.00"}}]
[null,2,"Digital transducer with a minimum of four galvanic isolated analogue outputs.",0,0,0,25,12,0,{"$f":"SUM(Table4243137[[#This Row],[Column24]:[Column223]])","v":37},null,{"v":0,"d":"R0.00"}]
[null,3,"Digital transducer with a minimum of six galvanic isolated analogue outputs.",20,0,45,25,24,0,{"$f":"SUM(Table4243137[[#This Row],[Column24]:[Column223]])","v":114},null,{"v":0,"d":"R0.00"}]
[null,4,"Digital display",20,0,45,25,8,0,{"$f":"SUM(Table4243137[[#This Row],[Column24]:[Column223]])","v":98},null,{"v":0,"d":"R0.00"}]
[null,5,"2 x Independent digital transducers (item 1) fitted inside a 19” rack with 2 x independent digital displays.",0,0,0,10,0,0,{"$f":"SUM(Table4243137[[#This Row],[Column24]:[Column223]])","v":10},null,{"v":0,"d":"R0.00"}]
[null,6,"2 x Independent digital transducers (item 2) fitted inside a 19” rack with 2 x independent digital displays.",0,0,0,10,2,0,12,null,{"v":0,"d":"R0.00"}]
[null,7,"2 x Independent digital transducers (item 3) fitted inside a 19” rack with 2 x independent digital displays.",5,80,24,10,12,16,{"$f":"SUM(Table4243137[[#This Row],[Column24]:[Column223]])","v":147},null,{"v":0,"d":"R0.00"}]
[null,8,"Transducer: configuration cable",{"$nulls":6},52,null,{"v":0,"d":"R0.00"}]
[null,9,"Training per session (min 10 candidates)",{"$nulls":6},10,null,{"v":0,"d":"R0.00"}]
[null,null,"TOTAL EXCL VAT",{"$nulls":8},{"$f":"SUM(L12:L20)","v":{"v":0,"d":"R0.00"}}]
[null,null,"ADD 15% VAT",{"$nulls":8},{"$f":"L21*0.15","v":{"v":0,"d":"R0.00"}}]
[null,null,"TOTAL INCLUDING VAT ",{"$nulls":8},{"$f":"SUM(L21:L22)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Summary","index":4,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[1,3,1,5],[2,3,2,5],[3,3,3,5],[6,1,6,3],[6,4,6,6],[7,1,8,1],[7,2,8,2],[11,1,11,5],[12,1,12,5],[13,1,13,5]]}
[]
[null,null,"Enquiry No.","E1291NTCSAMWP"]
[null,null,"Package Name:",{"$f":"'Tender Cover Sheet'!D4","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[null,null,"Tenderer's Name:",{"$f":"'Tender Cover Sheet'!D5","v":0}]
[]
[]
[null,"SUMMARY",null,null,"All prices in ZAR"]
[null,"Item No.","DESCRIPTION","Total Foreign Currency","Total Foreign Currency","Total Local Currency","Total Tendered Value "]
[{"$nulls":3},"FC","ZAR","ZAR","ZAR"]
[null,1,"DIGITAL TRANSDUCERS",{"$nulls":3},{"$f":"E10+F10","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":6},{"$f":"E11+F11","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL EXCL VAT",{"$nulls":4},{"$f":"SUM(G10:G11)","v":{"v":0,"d":"R0.00"}}]
[null,"ADD VAT AT 15%",{"$nulls":3},"ADDED VAT",{"$f":"G12*0.15","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL INCL VAT",{"$nulls":4},{"$f":"SUM(G12:G13)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Transp & Offload OPT A","index":5,"n_rows":72,"n_cols":12,"rows_kept":72,"merged":[[5,1,6,4],[5,5,6,11],[7,1,8,4],[7,5,8,11],[9,1,10,4],[9,5,10,11],[11,1,13,1],[11,2,11,11],[12,2,12,11],[13,2,13,11],[37,1,38,4],[37,5,38,11],[39,1,40,4],[39,5,40,11],[41,1,42,4],[41,5,42,11],[43,1,45,1],[43,2,43,11],[44,2,44,11],[45,2,45,11],[69,1,69,5],[70,1,70,5],[71,1,71,5]]}
[null,"OPTION A"]
[]
[null,{"$f":"\"TRANSPORT OF DIGITAL TRANSDUCERS\"","v":"TRANSPORT OF DIGITAL TRANSDUCERS"}]
[]
[]
[null," ENQUIRY NO",{"$nulls":3},"E1291NTCSAMWP"]
[]
[null,"COMMODITY",{"$nulls":3},{"$f":"'Tender Cover Sheet'!D4","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[]
[null,"SUPPLIER",{"$nulls":3},{"$f":"'Tender Cover Sheet'!D5","v":0}]
[]
[null,"DISTANCE WITHIN A GIVEN RADIUS","PER UNIT PRICE IN SOUTH AFRICAN CURRENCY EXCLUDING VAT"]
[null,null,"TRANSPORT TO SITE OR GRID STORE"]
[null,null,"NUMBER OF UNITS TO BE TRANSPORTED DURING ONE SITE VISIT"]
[null,null,1,2,3,4,5,6,"7 to 9","10 to 12","13 to 18","19 or more"]
[null,"0 - 100"]
[null,"101 - 200"]
[null,"201 - 300"]
[null,"301 - 400"]
[null,"401 - 500"]
[null,"501 - 600"]
[null,"601 - 700"]
[null,"701 - 800"]
[null,"801 - 900"]
[null,"901 - 1000"]
[null,"1001 - 1100"]
[null,"1101 - 1200"]
[null,"1201 - 1300"]
[null,"1301 - 1400"]
[null,"1401 - 1500"]
[]
[null,"ADDITIONAL NOTES:"]
[]
[]
[null,{"$f":"\"OFF LOADING OF DIGITAL TRANSDUCERS\"","v":"OFF LOADING OF DIGITAL TRANSDUCERS"}]
[]
[]
[null," ENQUIRY NO",{"$nulls":3},{"$f":"F6","v":"E1291NTCSAMWP"}]
[]
[null,"COMMODITY",{"$nulls":3},{"$f":"F8","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[]
[null,"SUPPLIER",{"$nulls":3},{"$f":"F10","v":0}]
[]
[null,"DISTANCE WITHIN A GIVEN RADIUS","PER UNIT PRICE IN SOUTH AFRICAN CURRENCY EXCLUDING VAT"]
[]
[null,null,"NUMBER OF UNITS TO BE OFF LOADED DURING ONE SITE VISIT"]
[null,null,1,2,3,4,5,6,"7 to 9","10 to 12","13 to 18","19 or more"]
[null,"0 - 100"]
[null,"101 - 200"]
[null,"201 - 300"]
[null,"301 - 400"]
[null,"401 - 500"]
[null,"501 - 600"]
[null,"601 - 700"]
[null,"701 - 800"]
[null,"801 - 900"]
[null,"901 - 1000"]
[null,"1001 - 1100"]
[null,"1101 - 1200"]
[null,"1201 - 1300"]
[null,"1301 - 1400"]
[null,"1401 - 1500"]
[]
[null,"ADDITIONAL NOTES:"]
[]
[]
[]
[]
[]
[null,"Monthly manufacturing capacity"]
[null,"Monthly installation capacity"]
[null,"Lead time"]

{"sheet":"Transp & Offload OPT B","index":6,"n_rows":51,"n_cols":13,"rows_kept":51,"merged":[[5,1,6,4],[5,5,6,12],[7,1,8,4],[7,5,8,12],[9,1,10,4],[9,5,10,12],[11,2,11,12],[26,1,27,4],[26,5,27,11],[28,1,29,4],[28,5,29,11],[30,1,31,4],[30,5,31,11],[32,1,34,1],[32,2,32,11],[33,2,33,11],[34,2,34,11],[48,1,48,5],[49,1,49,5],[50,1,50,5]]}
[null,"OPTION B"]
[]
[null,{"$f":"'Transp & Offload OPT A'!B3","v":"TRANSPORT OF DIGITAL TRANSDUCERS"}]
[]
[]
[null," ENQUIRY NO",{"$nulls":3},"E1291NTCSAMWP"]
[]
[null,"COMMODITY",{"$nulls":3},"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"]
[]
[null,"SUPPLIER",{"$nulls":3},{"$f":"'Tender Cover Sheet'!D5","v":0}]
[]
[null,null,"PER UNIT PRICE IN SOUTH AFRICAN CURRENCY EXCLUDING VAT"]
[null,null,"LDV","Personnel Transport for Staff","10 m³ Tipper Truck","6 m³ Tipper Truck","Transport Truck 2-4 ton","Transport Truck 5-8 ton","Transport Truck 5-8 ton with crane","Transport Truck 9-14 ton","Transport Truck 9-14 ton with crane","Lowbed","TLB for standing time claim only"]
[]
[null,"R/km"]
[]
[]
[]
[null,"ADDITIONAL NOTES:"]
[]
[]
[]
[]
[null,{"$f":"'Transp & Offload OPT A'!B35","v":"OFF LOADING OF DIGITAL TRANSDUCERS"}]
[]
[]
[null," ENQUIRY NO",{"$nulls":3},{"$f":"F6","v":"E1291NTCSAMWP"}]
[]
[null,"COMMODITY",{"$nulls":3},{"$f":"F8","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[]
[null,"SUPPLIER",{"$nulls":3},{"$f":"F10","v":0}]
[]
[null,"CAPACITY OF COMMODITY","PER UNIT PRICE IN SOUTH AFRICAN CURRENCY EXCLUDING VAT"]
[]
[null,null,"NUMBER OF UNITS TO BE OFF LOADED DURING ONE SITE VISIT"]
[null,null,1,2,3,4,5,6,"7 to 9","10 to 12","13 to 18","19 or more"]
{"$rows_empty":7}
[null,"ADDITIONAL NOTES:"]
[]
[]
[]
[]
[null,"Monthly manufacturing capacity"]
[null,"Monthly installation capacity"]
[null,"Lead time"]

{"sheet":"5.1.2 CPA Formula","index":7,"n_rows":148,"n_cols":15,"rows_kept":148,"merged":[[1,1,1,2],[1,3,1,5],[2,1,2,2],[2,3,2,5],[3,1,3,2],[3,3,3,5],[5,1,5,5],[8,3,8,4],[8,6,8,8],[9,3,9,5],[9,6,18,8],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[21,2,21,7],[22,2,22,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,2,28,7],[29,2,29,7],[30,2,30,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[35,2,35,7],[36,2,36,7],[40,2,40,7],[51,2,51,7],[62,2,62,7],[73,2,73,7],[84,2,84,7],[95,2,95,7],[106,2,106,7],[117,2,117,7],[128,2,128,7],[139,2,139,7]]}
[]
[null,"Enquiry No.",null,"E1291NTCSAMWP"]
[null,"Package Name:",null,{"$f":"'Tender Cover Sheet'!D4","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[null,"Tenderer's Name:",null,{"$f":"'Tender Cover Sheet'!D5","v":0}]
[]
[null,"CONTRACT PRICE ADJUSTMENT (CPA) FOR INFLATION"]
[]
[null,"No.","Formula Code","Summary of the description of the Tenderer's Formulae"]
[null,1,"Fixed","Firm and Fixed and Firm for the full duration of Contract",null,null,"Prices are 100 % fixed and firm. CPA is not applicable. "]
[null,2,"A",{"$f":"C41","v":"Tenderer's description of Formula A"},null,null,"Type in the description of each formula in the tables below"]
[null,3,"B",{"$f":"C52","v":"Tenderer's description of Formula B"}]
[null,4,"C",{"$f":"C63","v":"Tenderer's description of Formula C"}]
[null,5,"D",{"$f":"C74","v":"Tenderer's description of Formula D"}]
[null,6,"E",{"$f":"C85","v":"Tenderer's description of Formula E"}]
[null,7,"F",{"$f":"C96","v":"Tenderer's description of Formula F"}]
[null,8,"G",{"$f":"C107","v":"Tenderer's description of Formula G"}]
[null,9,"H",{"$f":"C118","v":"Tenderer's description of Formula H"}]
[null,10,"I",{"$f":"C129","v":"Tenderer's description of Formula I"}]
[null,11,"J",{"$f":"C140","v":"Tenderer's description of Formula J"}]
[]
[null,"SPECIFIC REQUIREMENTS"]
[null,{"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."]
[null,{"v":2,"d":"2."},"No ALTERNATIVE offers are accepted."]
[]
[null,"GENERAL NOTES :"]
[null,1,"References to \"indices\" below mean \"cost indices or reference prices\"."]
[null,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."]
[null,3,"The worksheet  CPA Formula in PS5 Summary has to be populated by the tenderer (Row 9:9), 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"]
[null,4,"CPA Formulae Codes B8:B19 above is to be populated by the tenderer in the \"PS5 Summary\" tab, row 9:9, by selecting the respecting the correct formula code from the dropdown list as developed by Tenderer hereunder. Codes and descriptions must be selected by the tenderer and inserted into each row of activity. "]
[null,5,"CPA will kick in after sixteen (16) months from the contract base date (contract base date is one month prior to enquiry closing), for commodities with prices that are less volatile. The sixteen months comprises of one (1) month prior to enquiry closing, three (3) months normal tender validity period as prescribed by the CIDB Act, and the twelve (12) months being the first twelve (12) months of the contract period."]
[null,6,"The CPA escalation will be calculated as follows: The base date for CPA calculation purposes will be one month prior to enquiry closing or as agreed to between the parties (if there is a need to move the base date during contract negotiations). The latest / ruling index used for CPA calculation purposes will be aligned to the delivery dates of the equipment on the assessment for payment on a particular payment certificate month."]
[null,"CPA FORMULA NOTES :"]
[null,1,"Proportions/weightings in CPA Formulae: The fixed portion of each formula, not subject to CPA, must be at least 15%.  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%.   "]
[null,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."]
[null,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. "]
[null,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.  "]
[null,5,"Base Date Index :   The base index or reference price must be inserted in the appropriate column."]
[null," "," "]
[]
[]
[null,"Formula A","Tenderer's description of Formula A"]
[null,"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"]
[null,"A1"]
[null,"A2"]
[null,"A3"]
[null,"A4"," "]
[null,"A5"]
[null,"A6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C43:C48)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula B","Tenderer's description of Formula B"]
[null,"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"]
[null,"B1"]
[null,"B2"," "]
[null,"B3"]
[null,"B4"," "]
[null,"B5"," "]
[null,"B6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C54:C59)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula C","Tenderer's description of Formula C"]
[null,"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"]
[null,"C1",{"$nulls":4}," "," "," "]
[null,"C2"," "]
[null,"C3"]
[null,"C4"," "]
[null,"C5"," "]
[null,"C6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C65:C70)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula D","Tenderer's description of Formula D"]
[null,"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"]
[null,"D1"," "]
[null,"D2"," "]
[null,"D3"]
[null,"D4"," "]
[null,"D5"," "]
[null,"D6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C76:C81)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula E","Tenderer's description of Formula E"]
[null,"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"]
[null,"E1"," "]
[null,"E2"," "]
[null,"E3"]
[null,"E4"," "]
[null,"E5"," "]
[null,"E6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C87:C92)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula F","Tenderer's description of Formula F"]
[null,"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"]
[null,"F1"]
[null,"F2"]
[null,"F3"]
[null,"F4"]
[null,"F5"]
[null,"F6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C98:C103)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula G","Tenderer's description of Formula G"]
[null,"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"]
[null,"G1"," "]
[null,"G2"," "]
[null,"G3"," "]
[null,"G4"]
[null,"G5"," "]
[null,"G6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C109:C114)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula H","Tenderer's description of Formula H"]
[null,"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"]
[null,"H1"," "]
[null,"H2"," "]
[null,"H3"," "]
[null,"H4"," "]
[null,"H5"," "]
[null,"H6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C120:C125)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula I","Tenderer's description of Formula I"]
[null,"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"]
[null,"I1"," "]
[null,"I2"," "]
[null,"I3"," "]
[null,"I4"]
[null,"I5"," "]
[null,"I6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C131:C136)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula J","Tenderer's description of Formula J"]
[null,"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"]
[null,"J1"," "]
[null,"J2"]
[null,"J3"," "]
[null,"J4"," "]
[null,"J5"," "]
[null,"J6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C142:C147)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]

{"sheet":"5.1.3  Exchange Rates","index":8,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[1,3,1,6],[2,3,2,6],[3,3,3,6],[9,1,11,1],[9,2,9,9],[9,15,9,20],[10,2,10,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,1,16,1],[14,2,14,9],[15,2,15,9],[16,2,16,9],[20,1,20,9]]}
[]
[null,null,"Enquiry No.","E1291NTCSAMWP"]
[null,null,"Package Name:",{"$f":"'Tender Cover Sheet'!D4","v":"SUPPLY AND DELIVERY OF DIGITAL TRANSUCERS ON AN AS AND WHEN REQUIRED BASIS FOR A PERIOD OF FIVE YEARS"}]
[null,null,"Tenderer's Name:",{"$f":"'Tender Cover Sheet'!D5","v":0}]
[]
[]
[null,"5.1.2 EXCHANGE RATES FOR MULTIPLE CURRENCIES"]
[null," "]
[null,"NOTES:"]
[null,1,"The following URL (electronic route) is to be followed to access the relevant SARB rates on their web pages:\n"]
[null,null,"www.resbank.co.za"]
[null,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"]
[null,2,"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"]
[null,{"$f":"B13+1","v":3},"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"]
[null,4,"All information in the table below must conform with all other equivalent information in the offer. "]
[null,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,null,"If more than one payment method apply for a currency, the Tenderer must an additional row be inserted in the table in order to split the values and identify the relevant method.   "]
[null," "]
[null,"EXCHANGE RATES PUBLISHED BY SARB"]
[null,"NB: Tenderers must submit proof of the SARB rate (s) of exchange used."]
[null,"MULTIPLE CURRENCIES"]
[null,"No","Currency Description","Code","Exchange Rate\nCurrency 1,00 = R Amount","Amount in Foreign Currency","Amount in Rand","Payment Method 1a, 1b, 2 or Fixed Rand","Date Published","Source"]
[null,1,"Australian Dollar","AUD",{"v":0,"d":"0.0000"}]
[null,{"$f":"B23+1","v":2},"Canadian Dollar","CAN",{"v":0,"d":"0.0000"}]
[null,{"$f":"B24+1","v":3},"Swiss Franc","CHF",{"v":0,"d":"0.0000"}]
[null,{"$f":"B25+1","v":4},"Danish Krone","DKK",{"v":0,"d":"0.0000"}]
[null,5,"European Currency","EUR",{"v":0,"d":"0.0000"}]
[null,6,"British Pound","GBP",{"v":0,"d":"0.0000"}]
[null,7,"Hong Kong Dollar","HKD",{"v":0,"d":"0.0000"}]
[null,8,"Japanese Yen","JPY",{"v":0,"d":"0.0000"}]
[null,9,"Norwegian Krone","NOK",{"v":0,"d":"0.0000"}]
[null,10,"New Zealand Dollar","NZD",{"v":0,"d":"0.0000"}]
[null,11,"Swedish Krone","SEK",{"v":0,"d":"0.0000"}]
[null,12,"Singapore Dollar","SGD",{"v":0,"d":"0.0000"}]
[null,13,"United States Dollar","USD",{"v":0,"d":"0.0000"}]
[null,14,"South African Rand","ZAR",{"v":0,"d":"0.0000"}]
[null,15,"Example Purposes European Currency  (EURO for this example)","EURO",{"v":14.22,"d":"14.2200"},{"$f":"SUM(F24:F36)","v":0}," "]
[null,null,"TOTAL RAND  -  MUST AGREE WITH TOTAL PRICE EXCLUDING VAT",{"$nulls":3},{"$f":"SUM(G23:G37)","v":{"v":0,"d":"R 0.00"}}," "]