{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Read Me","Tender Cover Sheet","5.1.0 Preamble","5.1.1 Cables","5.1.1 Boots","5.1.1 Tools","5.1.1 Connectors","5.1.1 Adaptors","5.1.1 Flyleads","5.1.1 Clamps","5.1.1 Protectors","5.1.1 Others","5.1.2 CPA Formulae","5.1.3 Summary","5.1.4 Exchange Rates"],"not_rendered":{"images":1,"external_links":3,"defined_names":33},"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[15,8,15,15],[16,8,16,15],[21,1,21,2],[22,1,22,2]]}
["Enquiry No.",null,"E2438NTCSAMWP"]
["Package Name:",null,"supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
["Tenderer's Name:",null,{"$f":"'[1]Tender Cover Sheet'!C16","v":0}]
["Category of Offer ( Main Offer Only):",null,"Main Offer Only"]
[]
["READ ME"]
[]
[1,"Read these notes BEFORE you commence input  to this workbook. Changes may not be made to this workbook. No columns may be removed, edited, added or changed on this workbook."]
[2,"Only The Main Offer shall be accepted. No alternative offers are accepted. There must be a separate Excel and PDF file for the main offer."]
[3,"Main offer is = The pricing schedule may not be changed or altered. Tenderer(s) to populate all required information on the Tender cover sheet and also populate as stipulated in (5.1.1 Pricing, 5.1.2 CPA Formulae, 5.1.3 Summary (VATPortion) and 5.1.4 Exchange Rates. "]
[4,"NOTE:  ALL CALCULATIONS ARE THE RESPONSIBILITY OF THE TENDERER, AND MUST BE CHECKED THOROUGHLY.  ANY DISCREPANCY FOUND IN THE CALCULATIONS IN THIS WORKBOOK MUST BE BROUGHT TO THE ATTENTION OF ESKOM, THROUGH THE DESIGNATED BUYER!"]
[]
[]
[5,"This workbook contains the following sheets:"]
[null,"Read Me","This sheet provides an overview to the Tenderer of the content and role of the sheets making up the Price Schedule.  It will not form part of the tender or contract.The tender will be awarded to a single supplier for this price list and.This contract is an \"as and when\" required contract. The units quantities herein are estimates only and are non-committal."]
[null,"Tender Cover Sheet","This is the cover sheet for Worksheets 5.1.0 to 5.1.4 and provides the total tendered price which is mandatory be completed.  It is also the source of the package name, tenderer name etc. for the other worksheets.  It will  form part of the tender or contract. Worksheets Tender Cover Sheet, 5.1.1 Pricing, 5.1.2 CPA Formulae, 5.1.3 Summary and 5.1.4 Exchange Rates are compulsory tender returnables as they are loaded onto the Eskom Tender Bulletin and they may not be changed or altered."]
[null,"5.1.0 Preamble","This sheet provides general guidelines for this section."]
[null,"5.1.1 Pricing","This is the main data entry sheet for the Tenderer to complete. The Tenderer takes responsibility for ensuring correct inputs. Tenderers are to populate their pricing information as stipulated in the pricing schedule. The pricing schedule may not be changed or altered. Tenderer(s) to populate all required information on the Tender cover sheet as stipulated in  (5.1.1 Pricing ), (5.1.4 Exchange rates) and  (5.1.2 CPA Formulae). "]
[null,"5.1.2 CPA Formulae","This sheet must be completed by the Tenderer for the proposed contract price adjustment (CPA) formulae, (where applicable ) and will be carried forward to worksheet (5.1.1 Pricing). Details of the CPA Formulae to be determined in accordance with the CPA conditions with reference to the NOTES. If the CPA Formulae are not inputted, in worksheet 5.1.2 CPA formulae, the tendered prices will be deemed \"Fixed and Firm\". If the CPA formulae is inputted in worksheet (5.1.2 CPA Formulae) but is not reflected, using the drop downs, in worksheet (5.1.1 Pricing), the tendered prices will be deemed \"Fixed and Firm\". Rate of exchange (ROE) cannot be accepted by Eskom to form part of any CPA formulae."]
[]
[]
[6,"Conventions used in this workbook"]
[null,"The following conventions have been used in this workbook to facilitate its accurate use:"]
[null,null,"Only Light Green highlighted cells are to be inputted by the Tenderer."]
[null,null,"There will be no inputting in Grey highlighted cells."]

{"sheet":"Tender Cover Sheet","index":1,"n_rows":44,"n_cols":4,"rows_kept":44}
{"$rows_empty":9}
[null,"PRICING INFORMATION"]
[]
[null,"ENQUIRY No.","E2438NTCSAMWP"]
[]
[null,"NAME OF PACKAGE:","supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[]
[null,"TENDERER’S NAME:  "]
[]
[null,"CATEGORY OF OFFER (MAIN OFFER ONLY):",{"$f":"'[1]Read Me'!C4","v":"Main Offer Only"}]
[]
[null,"TENDERED PRICE:  IN ZAR",{"$f":"'[2]5.1.3 Summary'!F15","v":{"v":0,"d":"  0  RAND"}}]
[null,"(excluding VAT)"]
[]
[null,"RAND VALUE IN WORDS","[Price in Words]"]
[]
[]
[]
[]
[null,"TENDERED PRICE:  IN ZAR",{"$f":"'[2]5.1.3 Summary'!F17","v":{"v":0,"d":"  0  RAND"}}]
[null,"(including VAT)"]
[]
[null,"DATE :"]
[]
[]
[]
[null,"FULL NAMES OF SIGNATORY:"]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"]
[]
[]
[]
[null,"SIGNATURE :"]
[{"$nulls":3}," "]

{"sheet":"5.1.0 Preamble","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2]]}
["Enquiry No.",null,"E2438NTCSAMWP"]
["Package Name:",null,"supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
["Tenderer's Name:",null,{"$f":"'[1]Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'[1]Read Me'!C4","v":"Main Offer Only"}]
[]
["5.1.0 PREAMBLE TO PRICE SCHEDULE "]
[]
[1,"The Price Schedule provides the basis of valuation, price adjustment (CPA) formulae and information for general contract progress monitoring. This contract is an \"as and when\" required contract.The tender will be awarded to a single supplier for this price list.The units quantities herein are estimates only and are non-committal.  No alternative offers are accepted."]
[2,"This is the main data entry sheet for the Tenderer to complete. The Tenderer takes responsibility for ensuring correct inputs. Tenderers are to populate their pricing information as stipulated in the pricing schedule. The pricing schedule may not be changed or altered. Tenderer(s) to populate all required information on the Tender cover sheet and also populate  as stipulated in  (5.1.1 Pricing )  (5.1.2 CPA Formulae) and (5.1.4 Exchange rates). CPA Formulae should represent cost breakdown of the goods/commodities/components/items being sourced."]
[3,"The Prices are the amounts stated in the price column of the Price Schedule.  Where an estimated quantity is stated for an item in the Price Schedule, the Price is calculated by multiplying the estimated quantity by the rate."]
[4,"If the Supplier has decided not to identify a particular item in the price schedule at the time of tender the cost to the Supplier of doing the work is assumed to be included in, or spread across, the other Prices and rates in the price schedule in order to fulfil the obligation to Provide the Goods and Services for the tendered total of the Prices.  "]
[5,"The total of the prices must include for all direct and indirect costs, overheads, profit on costs, risks, liabilities, obligations, etc. relative to the contract."]
[6,"The Tenderer must allow for all necessary costs to complete the pricing shedule as required in terms of the specifications, technical scope and conditions of contract whether expressly stated or not in the Price Schedules. The Tenderer must provide any breakdown of prices as may be required for specific items not detailed in the Price Schedule prior to or after contract award."]
[7,"The Prices quoted by the supplier should be exclusive and inclusive of VAT."]
[8," Please note, that the Tenderer is to input the VAT amount as no formulae has been provided for the VAT portion."]
[9,"All worksheets in this Pricing Schedule are to be submitted. Tenderers are not allowed to ommit a worksheet. If specifically worksheets, 5.1.1 or 5.1.2 are ommited, it will be deemed that CPA  are not applicable to this tender. Rate of exchange (ROE) cannot be accepted by Eskom to form part of any CPA formulae."]
[10,"Only Light Green highlighted cells are to be inputted by the Tenderer."]
[11,"There will be no inputting in Grey highlighted cells."]

{"sheet":"5.1.1 Cables","index":3,"n_rows":20,"n_cols":10,"rows_kept":20,"merged":[[1,8,1,9],[4,0,4,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Cables",{"$nulls":7},"Dropdown "]
["1","3.2.1","Cable: RG58 5 mm 50 Ω","CABLE;K31RR0001A,RG58 5MM 50 OHM","m",1000,null,{"$f":"G6*F6","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I6=\"\",\"Fixed\",VLOOKUP(I6,'5.1.2 CPA Formulae'!B9:E19,2,FALSE))","v":"Fixed"}]
["2","3.2.2","Cable: RG223 5.5 mm 50 Ω","CABLE;CNC7L01001A0003,RG223 5.5MM 50 OHM","m",1000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["3","3.2.3","Cable: RG213 10 mm 50 Ω braided","CABLE;CXRG213FA,RG213 10MM 50 OHM FLEXAX","m",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["4","3.2.4","Cable: RG214 10.8 mm 50 Ω","CABLE;CXRG214,RG214 10.8MM 50 OHM","m",1800,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
["5","3.2.5","Cable: RG400 5 mm 50 Ω Teflon","CABLE;CXRG400,RG400 5.5MM 50 OHM TEFLON","m",1000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I10=\"\",\"Fixed\",VLOOKUP(I10,'5.1.2 CPA Formulae'!B13:E23,2,FALSE))","v":"Fixed"}]
["6","3.2.6","Cable: LMR195 5 mm 50 Ω DB PE","CABLE;A31RR0096A,LMR195 5MM 50 OHM DB PE","m",1000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I11=\"\",\"Fixed\",VLOOKUP(I11,'5.1.2 CPA Formulae'!B14:E24,2,FALSE))","v":"Fixed"}]
["7","3.2.7","Cable: LMR195 5 mm 50 Ω ultra","CABLE;CXLMR195UF,LMR195 5MM 50HM ULTRA","m",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I12=\"\",\"Fixed\",VLOOKUP(I12,'5.1.2 CPA Formulae'!B15:E25,2,FALSE))","v":"Fixed"}]
["8","3.2.8","Cable: LMR240 6.1 mm 50 Ω","CABLE;CXLMR240,LMR240 6.1MM 50 OHM","m",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I13=\"\",\"Fixed\",VLOOKUP(I13,'5.1.2 CPA Formulae'!B16:E26,2,FALSE))","v":"Fixed"}]
["9","3.2.9","Cable: LMR240 ultra 6.1 mm 50 Ω","CABLE;CXLMR240UF,LMR240 6.1MM 50 OHM","m",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I14=\"\",\"Fixed\",VLOOKUP(I14,'5.1.2 CPA Formulae'!B17:E27,2,FALSE))","v":"Fixed"}]
["10","3.2.10","Cable: LMR400 10.2 mm 50 Ω","CABLE;CXLMR400,LMR400 10.2MM 50 OHM","m",5000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I15=\"\",\"Fixed\",VLOOKUP(I15,'5.1.2 CPA Formulae'!B18:E28,2,FALSE))","v":"Fixed"}]
["11","3.2.11","Cable: LMR400 10.2 ultra mm 50 Ω","CABLE;CXLMR400ULTRA,LMR400 10.2MM 50 OHM","m",15500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I16=\"\",\"Fixed\",VLOOKUP(I16,'5.1.2 CPA Formulae'!B19:E29,2,FALSE))","v":"Fixed"}]
["12","3.2.12","Cable: 1/2″ (EC4-50) Eupen 5128","CABLE;CXEC4-50,1/2\" (EC4-50) EUPEN 5128","m",15500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I17=\"\",\"Fixed\",VLOOKUP(I17,'5.1.2 CPA Formulae'!B20:E30,2,FALSE))","v":"Fixed"}]
["13","3.2.13","Cable: CXEC5-50, 7/8″ (EC5-50) Eupen 5228A","CABLE;CXEC5-50,7/8\" (EC5-50) EUPEN 5228A","m",7000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I18=\"\",\"Fixed\",VLOOKUP(I18,'5.1.2 CPA Formulae'!B21:E31,2,FALSE))","v":"Fixed"}]
["14","3.2.14","Cable: Coaxial 7/8″ (Aluminium)","CABLE COAX:RADIO FREQUENCY;50 OHM;CU;AL","m",8000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I19=\"\",\"Fixed\",VLOOKUP(I19,'5.1.2 CPA Formulae'!B22:E32,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H6:H19)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Boots","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,8,1,9],[4,0,4,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Boots",{"$nulls":7},"Dropdown "]
["15","3.3.1","Boot: strain relief LMR240 black","BOOT;CNC7B00081B1289,STRAIN REL. LMR240","each",2000,null,{"$f":"G6*F6","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I6=\"\",\"Fixed\",VLOOKUP(I6,'5.1.2 CPA Formulae'!B9:E19,2,FALSE))","v":"Fixed"}]
["16","3.3.2","Boot: strain relief LMR240 red","BOOT;CNC7B00081B1289,STRAIN REL. LMR240","each",600,null,{"$f":"G7*F7","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["17","3.3.3","Boot: strain relief for RG58/LMR 195 black","BOOT;CNAC78Z034,STREIN REL.FOR RG58/LMR","each",600,null,{"$f":"G8*F8","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["18","3.3.4","Boot: strain relief for RG214/LMR 400 black","BOOT;CNAC78Z072,STREIN REL.FOR RG214/LMR","each",600,null,{"$f":"G9*F9","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H6:H9)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Tools","index":5,"n_rows":11,"n_cols":10,"rows_kept":11,"merged":[[1,8,1,9],[4,0,4,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Tools",{"$nulls":7},"Dropdown "]
["19","3.4.1","Tool: cable prep 1/2″","TOOL;CNC7N00091A0015,CABLE PREP 1/2\"","each",150,null,{"$f":"G6*F6","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I6=\"\",\"Fixed\",VLOOKUP(I6,'5.1.2 CPA Formulae'!B9:E19,2,FALSE))","v":"Fixed"}]
["20","3.4.2","Tool: cable prep 7/8″","TOOL;CNC7N00091A0014,CABLE PREP 7/8\"","each",150,null,{"$f":"G7*F7","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["21","3.4.3","Tool: cable stripping 10 mm","TOOL:CNACST400;CABLE STRIPPING;10 MM","each",150,null,{"$f":"G8*F8","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["22","3.4.4","Tool kit: cable crimp metal","TOOL KIT:CNACHT330K;CABLE CRIMP;METAL","each",150,null,{"$f":"G9*F9","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
["23","3.4.5","Tool: Tensioner tool for stainless steel cable ties.","TOOL:STRAPPING;HAND;WD 75 X LG 150 MM","each",100,null,{"$f":"G10*F10","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I10=\"\",\"Fixed\",VLOOKUP(I10,'5.1.2 CPA Formulae'!B13:E23,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H6:H10)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Connectors","index":6,"n_rows":32,"n_cols":10,"rows_kept":32,"merged":[[1,8,1,9],[4,0,4,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Connectors",{"$nulls":7},"Dropdown "]
["24","3.5.1","Connector: BNC STR male crimp RG58/LMR195","CONNECTOR;CNC7J01000A1255,BNC STR MALE","each",2500,null,{"$f":"G6*F6","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I6=\"\",\"Fixed\",VLOOKUP(I6,'5.1.2 CPA Formulae'!B9:E19,2,FALSE))","v":"Fixed"}]
["25","3.5.2","Connector: BNC STR male solder RG223","CONNECTOR;CNC7J01000A0608,BNC STR MALE","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["26","3.5.3","Connector: BNC STR male crimp LMR240","CONNECTOR;CNC7J01000A0049,BNC STR MALE","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["27","3.5.4","Connector: BNC STR male crimp LMR400","CONNECTOR;CNC7J01000A0061,BNC STR MALE","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
["28","3.5.5","Connector: N-male STR crimp RG58/LMR195","CONNECTOR;CNC7J01020C0108,N-MALE STR","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I10=\"\",\"Fixed\",VLOOKUP(I10,'5.1.2 CPA Formulae'!B13:E23,2,FALSE))","v":"Fixed"}]
["29","3.5.6","Connector: N-male STR crimp RG223/RG400","CONNECTOR;CNC7J01020C0113,N-MALE STR CRI","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I11=\"\",\"Fixed\",VLOOKUP(I11,'5.1.2 CPA Formulae'!B14:E24,2,FALSE))","v":"Fixed"}]
["30","3.5.7","Connector: N-male STR crimp RG213","CONNECTOR;CNC7J01020A0107,N-MALE STR CRI","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I12=\"\",\"Fixed\",VLOOKUP(I12,'5.1.2 CPA Formulae'!B15:E25,2,FALSE))","v":"Fixed"}]
["31","3.5.8","Connector: N-male STR solder RG213/RG214","CONNECTOR;CNC7J01020H1070,N-MALE STR SOL","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I13=\"\",\"Fixed\",VLOOKUP(I13,'5.1.2 CPA Formulae'!B16:E26,2,FALSE))","v":"Fixed"}]
["32","3.5.9","Connector: N-male STR crimp RG214","CONNECTOR;CNC7J01020A0110,N-MALE STR CRI","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I14=\"\",\"Fixed\",VLOOKUP(I14,'5.1.2 CPA Formulae'!B17:E27,2,FALSE))","v":"Fixed"}]
["33","3.5.10","Connector: N-male STR crimp LMR240","CONNECTOR;CNC7J01020A0119,N-MALE STR CRI","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I15=\"\",\"Fixed\",VLOOKUP(I15,'5.1.2 CPA Formulae'!B18:E28,2,FALSE))","v":"Fixed"}]
["34","3.5.11","Connector: N-male R/A crimp LMR240","CONNECTOR;CNC7J01020A0097,N-MALE R/A CRI","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I16=\"\",\"Fixed\",VLOOKUP(I16,'5.1.2 CPA Formulae'!B19:E29,2,FALSE))","v":"Fixed"}]
["35","3.5.12","Connector: N-male STR crimp LMR400","CONNECTOR;CNC7J01020A0127,N-MALE STR CRI","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I17=\"\",\"Fixed\",VLOOKUP(I17,'5.1.2 CPA Formulae'!B20:E30,2,FALSE))","v":"Fixed"}]
["36","3.5.13","Connector: N-male R/A crimp LMR400","CONNECTOR;CNC7J01020B0081,N-MALE R/A LMR","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I18=\"\",\"Fixed\",VLOOKUP(I18,'5.1.2 CPA Formulae'!B21:E31,2,FALSE))","v":"Fixed"}]
["37","3.5.14","Connector: N-male STR 7/8″ (EC5-50) IP68","CONNECTOR;J01020A0153,N-MALE STR 7/8","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I19=\"\",\"Fixed\",VLOOKUP(I19,'5.1.2 CPA Formulae'!B22:E32,2,FALSE))","v":"Fixed"}]
["38","3.5.15","Connector: N-female STR crimp RG213","CONNECTOR;CNC7J01021A0061,N-FEMALE STR","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I20=\"\",\"Fixed\",VLOOKUP(I20,'5.1.2 CPA Formulae'!B23:E33,2,FALSE))","v":"Fixed"}]
["39","3.5.16","Connector: N-female STR crimp RG214","CONNECTOR;CNC7J01021A0145,N-FEMALE STR","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I21=\"\",\"Fixed\",VLOOKUP(I21,'5.1.2 CPA Formulae'!B24:E34,2,FALSE))","v":"Fixed"}]
["40","3.5.17","Connector: N-female STR crimp LMR400","CONNECTOR;CNC7J01021A0155,N-FEMALE STR","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I22=\"\",\"Fixed\",VLOOKUP(I22,'5.1.2 CPA Formulae'!B25:E35,2,FALSE))","v":"Fixed"}]
["41","3.5.18","Connector: N-female STR 1/2″ HF (EC450HF)","CONNECTOR;CNC7J01021A0163,N-FEMALE STR","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I23=\"\",\"Fixed\",VLOOKUP(I23,'5.1.2 CPA Formulae'!B26:E36,2,FALSE))","v":"Fixed"}]
["42","3.5.19","Connector: N-female STR 7/8″ (E5-50) IP68","CONNECTOR;CNC7J01021A0201,N-FEMALE STR","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I24=\"\",\"Fixed\",VLOOKUP(I24,'5.1.2 CPA Formulae'!B27:E37,2,FALSE))","v":"Fixed"}]
["43","3.5.20","Connector: SMA-male STR crimp RG58/LMR195","CONNECTOR;CNC7J01150A0011,SMA-MALE STR","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I25=\"\",\"Fixed\",VLOOKUP(I25,'5.1.2 CPA Formulae'!B28:E38,2,FALSE))","v":"Fixed"}]
["44","3.5.21","Connector: SMA-female STR crimp RG58/LMR195","CONNECTOR;CNC7J01151A0491,SMA-FEMALE STR","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I26=\"\",\"Fixed\",VLOOKUP(I26,'5.1.2 CPA Formulae'!B29:E39,2,FALSE))","v":"Fixed"}]
["45","3.5.22","Connector: TNC-male STR crimp RG58/LMR195","CONNECTOR;CNC7J01010A2255,TNC-MALE STR","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I27=\"\",\"Fixed\",VLOOKUP(I27,'5.1.2 CPA Formulae'!B30:E40,2,FALSE))","v":"Fixed"}]
["46","3.5.23","Connector: TNC-male STR solder RG58/LMR195","CONNECTOR;CNC7J01010A2608,TNC-MALE STR","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I28=\"\",\"Fixed\",VLOOKUP(I28,'5.1.2 CPA Formulae'!B31:E41,2,FALSE))","v":"Fixed"}]
["47","3.5.24","Connector: UHF-male STR crimp RG58/LMR195","CONNECTOR;CNC7J01040B0604,UHF-MALE STR","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I29=\"\",\"Fixed\",VLOOKUP(I29,'5.1.2 CPA Formulae'!B32:E42,2,FALSE))","v":"Fixed"}]
["48","3.5.25","Connector: TNC-male STR crimp LMR400","CONNECTOR:TNC MALE LMR400;AL","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I30=\"\",\"Fixed\",VLOOKUP(I30,'5.1.2 CPA Formulae'!B33:E43,2,FALSE))","v":"Fixed"}]
["49","3.5.26","Connector: bulkhead N type","CONNECTOR: Bulkhead N type","each",200,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I31=\"\",\"Fixed\",VLOOKUP(I31,'5.1.2 CPA Formulae'!B34:E44,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H6:H31)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Adaptors","index":7,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[1,8,1,9],[4,0,4,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Adaptors",{"$nulls":7},"Dropdown "]
["50","3.6.1","Adaptor: BNC-female to SMA-female","ADAPTOR;CNC7J01008A0019, BNC-FEMALE SMA-","each",600,null,{"$f":"G6*F6","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I6=\"\",\"Fixed\",VLOOKUP(I6,'5.1.2 CPA Formulae'!B9:E19,2,FALSE))","v":"Fixed"}]
["51","3.6.2","Adaptor: BNC-male to UHF-female","ADAPTOR;CNC7J01008A0803,BNC-MALE UHF-FEM","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["52","3.6.3","Adaptor: BNC-male to N-female","ADAPTOR;CNC7J01008A0824,BNC-MALE N-FEMAL","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["53","3.6.4","Adaptor: BNC-female to N-male","ADAPTOR;CNC7J01008A0825,BNC-FEMALE N-MAL","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
["54","3.6.5","Adaptor: N-female to N-female","ADAPTOR;CNC7J01024A0004,N-FEMALE N-FEMAL","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I10=\"\",\"Fixed\",VLOOKUP(I10,'5.1.2 CPA Formulae'!B13:E23,2,FALSE))","v":"Fixed"}]
["55","3.6.6","Adaptor: R/A N-male to N-female","ADAPTOR;CNC7J01024J1096,R/A N-MALE TO N-","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I11=\"\",\"Fixed\",VLOOKUP(I11,'5.1.2 CPA Formulae'!B14:E24,2,FALSE))","v":"Fixed"}]
["56","3.6.7","Adaptor: R/A TNC-male to TNC-female","ADAPTOR;CNC7J01014A0001,R/A TNC-MALE TNC","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I12=\"\",\"Fixed\",VLOOKUP(I12,'5.1.2 CPA Formulae'!B15:E25,2,FALSE))","v":"Fixed"}]
["57","3.6.8","Adaptor: TNC-male to BNC-female","ADAPTOR;CNC7J01019B0000,TNC-MALE BNC-FEM","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I13=\"\",\"Fixed\",VLOOKUP(I13,'5.1.2 CPA Formulae'!B16:E26,2,FALSE))","v":"Fixed"}]
["58","3.6.9","Adaptor: TNC-male to N-female","CONNECTOR:TNC MALE FEMALE ADAPTOR;AL","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I14=\"\",\"Fixed\",VLOOKUP(I14,'5.1.2 CPA Formulae'!B17:E27,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H6:H14)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Flyleads","index":8,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[1,8,1,9],[4,0,4,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Flyleads",{"$nulls":7},"Dropdown "]
["59","3.7.1","Flylead: BNC male to N male RG58 1m","FLYLEAD;C20AA0001A,RG58 1M BNC M TO N-MA","each",600,null,{"$f":"G6*F6","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I6=\"\",\"Fixed\",VLOOKUP(I6,'5.1.2 CPA Formulae'!B9:E19,2,FALSE))","v":"Fixed"}]
["60","3.7.2","Flylead: BNC male - N male LMR195 1m","FLYLEAD;C20AA0004A,LMR195 1M BNC M - N M","each",600,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["61","3.7.3","Flylead: N female bulkhead – N male LMR 195 1m","CORD COMM:FLYLEAD;CO-AX;LG 1 M;3 MM","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["62","3.7.4","Flylead: N female bulkhead – SMA male LMR 195 1m","Flylead LMR195 cable 1 m: N female bulkhead – SMA male","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
["63","3.7.5","Flylead: N male – TNC male LMR DB 195 1m","Flylead LMR195DB ultra cable 1 m: N male – TNC male","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I10=\"\",\"Fixed\",VLOOKUP(I10,'5.1.2 CPA Formulae'!B13:E23,2,FALSE))","v":"Fixed"}]
["64","3.7.6","Flylead: N male – N male LMR DB 195 5m","Flylead LMR195DB ultra cable 5 m: N male – N male","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I11=\"\",\"Fixed\",VLOOKUP(I11,'5.1.2 CPA Formulae'!B14:E24,2,FALSE))","v":"Fixed"}]
["65","3.7.7.1","Flylead: N female– N male LMR400 5m","Flylead LMR400 ultra cable 5 m: N female - N male","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I12=\"\",\"Fixed\",VLOOKUP(I12,'5.1.2 CPA Formulae'!B15:E25,2,FALSE))","v":"Fixed"}]
["66","3.7.7.2","Flylead: N female– N male LMR400 2.5m","Flylead LMR400 ultra cable 2.5 m: N female - N male","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I13=\"\",\"Fixed\",VLOOKUP(I13,'5.1.2 CPA Formulae'!B16:E26,2,FALSE))","v":"Fixed"}]
["67","3.7.8","Flylead: N male – N male LMR400 5m","Flylead LMR400 ultra cable 5 m: N male - N male","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I14=\"\",\"Fixed\",VLOOKUP(I14,'5.1.2 CPA Formulae'!B17:E27,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H6:H14)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Clamps","index":9,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[1,8,1,9],[4,0,4,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Clamps",{"$nulls":7},"Dropdown "]
["68","3.8.1","Clamp: Cumfy dual cable and clip","CLAMP;L10AA0116A,CUMFY TK120-2 & CLIP","each",1500,null,{"$f":"G6*F6","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I6=\"\",\"Fixed\",VLOOKUP(I6,'5.1.2 CPA Formulae'!B9:E19,2,FALSE))","v":"Fixed"}]
["69","3.8.2","Clamp: Cumfy single cable and clip","CLAMP;L10AA0129A,CUMFY TK120/13/1 & CLIP","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["70","3.8.3","Clamp: Cumfy dual RG58 and clip","CLAMP;L10AA0114A,CUMFY DUAL RG8 & CLIP","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["71","3.8.4","Clamp: Cumfy G-clamp dual assy","CLAMP;L10CC0001A,CUMFY G DUAL ASSY.1/4\"","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
["72","3.8.5","Clamp: Cumfy 3 way + clip","CLAMP;L10AA0057A,CUMFY 7/8\" 3 WAY+CLIP","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I10=\"\",\"Fixed\",VLOOKUP(I10,'5.1.2 CPA Formulae'!B13:E23,2,FALSE))","v":"Fixed"}]
["73","3.8.6","Clamp: Cumfy G-clamp single assy - 10mm","CLAMP;L10AA0001A,G 10MM 1 WAY ASSY. POLY","each",9000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I11=\"\",\"Fixed\",VLOOKUP(I11,'5.1.2 CPA Formulae'!B14:E24,2,FALSE))","v":"Fixed"}]
["74","3.8.7","Clamp: Cumfy G-clamp dual assy - 10mm","CLAMP;L10AA0002A,G 10MM 2 WAY ASSY. POLY","each",9000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I12=\"\",\"Fixed\",VLOOKUP(I12,'5.1.2 CPA Formulae'!B15:E25,2,FALSE))","v":"Fixed"}]
["75","3.8.8","Clamp: Cumfy G-clamp triple assy - 10mm","CLAMP;L10AA0003A,10MM 3 WAY ASSY. POLY","each",9000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I13=\"\",\"Fixed\",VLOOKUP(I13,'5.1.2 CPA Formulae'!B16:E26,2,FALSE))","v":"Fixed"}]
["76","3.8.9","Clamp: Cumfy G-clamp quad assy - 10mm","CLAMP;L10AA0004A,G 10MM 4 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I14=\"\",\"Fixed\",VLOOKUP(I14,'5.1.2 CPA Formulae'!B17:E27,2,FALSE))","v":"Fixed"}]
["77","3.8.10","Clamp: Cumfy G-clamp single assy - 16mm","CLAMP;L10AA0065A,G 1/2\" 1 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I15=\"\",\"Fixed\",VLOOKUP(I15,'5.1.2 CPA Formulae'!B18:E28,2,FALSE))","v":"Fixed"}]
["78","3.8.11","Clamp: Cumfy G-clamp dual assy - 16mm","CLAMP;L10AA0069A,G 1/2\" 2 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I16=\"\",\"Fixed\",VLOOKUP(I16,'5.1.2 CPA Formulae'!B19:E29,2,FALSE))","v":"Fixed"}]
["79","3.8.12","Clamp: Cumfy G-clamp triple assy - 16mm","CLAMP;L10AA0068A,G 1/2\" 3 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I17=\"\",\"Fixed\",VLOOKUP(I17,'5.1.2 CPA Formulae'!B20:E30,2,FALSE))","v":"Fixed"}]
["80","3.8.13","Clamp: Cumfy G-clamp quad assy - 16mm","CLAMP;L10AA0020A,G 1/2\" 4 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I18=\"\",\"Fixed\",VLOOKUP(I18,'5.1.2 CPA Formulae'!B21:E31,2,FALSE))","v":"Fixed"}]
["81","3.8.14","Clamp: Cumfy G-clamp single assy - 7/8″","CLAMP;L10AA0063A,G 7/8\" 1 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I19=\"\",\"Fixed\",VLOOKUP(I19,'5.1.2 CPA Formulae'!B22:E32,2,FALSE))","v":"Fixed"}]
["82","3.8.15","Clamp: Cumfy G-clamp dual assy - 7/8″","CLAMP;L10AA0064A,G 7/8\" 2 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I20=\"\",\"Fixed\",VLOOKUP(I20,'5.1.2 CPA Formulae'!B23:E33,2,FALSE))","v":"Fixed"}]
["83","3.8.16","Clamp: Cumfy G-clamp triple assy - 7/8″","CLAMP;L10AA0061A,G 7/8\" 3 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I21=\"\",\"Fixed\",VLOOKUP(I21,'5.1.2 CPA Formulae'!B24:E34,2,FALSE))","v":"Fixed"}]
["84","3.8.17","Clamp: Cumfy G-clamp quad assy - 7/8″","CLAMP;L10AA0218A,G 7/8\" 4 WAY ASSY. POLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I22=\"\",\"Fixed\",VLOOKUP(I22,'5.1.2 CPA Formulae'!B25:E35,2,FALSE))","v":"Fixed"}]
["85","3.8.18","Clamp: Polyprop - 1/2\"","CLAMP;L16AA0089A,G 1/2\" POLYPROP ONLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I23=\"\",\"Fixed\",VLOOKUP(I23,'5.1.2 CPA Formulae'!B26:E36,2,FALSE))","v":"Fixed"}]
["86","3.8.19","Clamp: Polyprop - 7/8″","CLAMP;L16AA0082A,G 7/8\" POLYPROP ONLY","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I24=\"\",\"Fixed\",VLOOKUP(I24,'5.1.2 CPA Formulae'!B27:E37,2,FALSE))","v":"Fixed"}]
["87","3.8.20","Clamp: Polyprop - 10mm","CLAMP;L16AA0007A,G 10MM ASSY. WSC 100","each",2000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I25=\"\",\"Fixed\",VLOOKUP(I25,'5.1.2 CPA Formulae'!B28:E38,2,FALSE))","v":"Fixed"}]
["88","3.8.21","Clamp: grounding kit 10 mm coax cable","CLAMP;L10AA0140A,GROUNDING 10MM CABLE","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I26=\"\",\"Fixed\",VLOOKUP(I26,'5.1.2 CPA Formulae'!B29:E39,2,FALSE))","v":"Fixed"}]
["89","3.8.22","Clamp: grounding kit 1/2″ coax cable","CLAMP;L10AA0200A,GROUNDING 1/2\" CABLE","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I27=\"\",\"Fixed\",VLOOKUP(I27,'5.1.2 CPA Formulae'!B30:E40,2,FALSE))","v":"Fixed"}]
["90","3.8.23","Clamp: grounding 1/2″","CLAMP;CNC7L00040A0013,GROUNDING 1/2\"","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I28=\"\",\"Fixed\",VLOOKUP(I28,'5.1.2 CPA Formulae'!B31:E41,2,FALSE))","v":"Fixed"}]
["91","3.8.24","Clamp: grounding 7/8″","CLAMP;CNC7L00040A0014,GROUNDING 7/8\"","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I29=\"\",\"Fixed\",VLOOKUP(I29,'5.1.2 CPA Formulae'!B32:E42,2,FALSE))","v":"Fixed"}]
["92","3.8.25","Clamp: BAND-IT strap 12 mm 30 m","CLAMP;L16AA0824A,BAND-IT STRAP 12MM 30M","each",250,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I30=\"\",\"Fixed\",VLOOKUP(I30,'5.1.2 CPA Formulae'!B33:E43,2,FALSE))","v":"Fixed"}]
["93","3.8.26","Clamp: BAND-IT buckle 12 mm","CLAMP;L16AA0813A,BAND-IT BUCKLE 12MM S/S","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I31=\"\",\"Fixed\",VLOOKUP(I31,'5.1.2 CPA Formulae'!B34:E44,2,FALSE))","v":"Fixed"}]
["94","3.8.27","Clamp: Stainless steel cable ties 7.9 mm","Clamp: Stainless steel cable ties 259 x 7.9 mm","each",450,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I32=\"\",\"Fixed\",VLOOKUP(I32,'5.1.2 CPA Formulae'!B35:E45,2,FALSE))","v":"Fixed"}]
["95","3.8.28","Clamp: 7/8″ 1 way tandem with G-clamp","CLAMP;L10AA0119A,7/8\" 1 WAY","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I33=\"\",\"Fixed\",VLOOKUP(I33,'5.1.2 CPA Formulae'!B36:E46,2,FALSE))","v":"Fixed"}]
["96","3.8.29","Clamp: 7/8″ 2 way tandem with G-clamp","CLAMP;L10AA0120A,7/8\" 2 WAY","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I34=\"\",\"Fixed\",VLOOKUP(I34,'5.1.2 CPA Formulae'!B37:E47,2,FALSE))","v":"Fixed"}]
["97","3.8.30","Clamp: 7/8″ 3 way tandem with G-clamp","CLAMP;L10AA0112A,7/8\" 3 WAY","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I35=\"\",\"Fixed\",VLOOKUP(I35,'5.1.2 CPA Formulae'!B38:E48,2,FALSE))","v":"Fixed"}]
["98","3.8.31","Clamp: cable two-way 32 mm","CLAMP:L10CA0020A;CABLE 2 WAY 32MM","each",1500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I36=\"\",\"Fixed\",VLOOKUP(I36,'5.1.2 CPA Formulae'!B39:E49,2,FALSE))","v":"Fixed"}]
["99","3.8.32","Clamp: cable one-way 32 mm","CLAMP:L10CA0019A;CABLE 1 WAY;32 MM","each",6000,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I37=\"\",\"Fixed\",VLOOKUP(I37,'5.1.2 CPA Formulae'!B40:E50,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H6:H37)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Protectors","index":10,"n_rows":18,"n_cols":10,"rows_kept":18,"merged":[[2,8,2,9],[5,0,5,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Protectors",{"$nulls":7},"Dropdown "]
["100","3.9.1","Protector: surge filter 1.7 GHz to 2.3 GHz bulkhead N‑female\\N‑female","PROTECTOR;CNLPSXL,WEBB POLY 1.2-2.8GH","each",200,null,{"$f":"G7*F7","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["101","3.9.2","Protector: surge suppressor DC-2 GHz N-female bulkhead mount 90 V","PROTECTOR;J01028A0044,DC-2GHZ N-FEMAL","each",750,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["102","3.9.3","Protector: 125 MHz to 1 000 MHz N-female","PROTECTOR;CNLPPOLYC2,125-1000MHZ N-FEMAL","each",500,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
["103","3.9.4","Protector: data line surge bulkhead RJ45","PROTECTOR;TR1101-1028,SURGE B/HEAD RJ45","each",150,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I10=\"\",\"Fixed\",VLOOKUP(I10,'5.1.2 CPA Formulae'!B13:E23,2,FALSE))","v":"Fixed"}]
["104","3.9.5","Protector: surge AC3 phase kit","PROTECTOR;TR1101-901,SURGE AC3 PHASE KIT","each",20,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I11=\"\",\"Fixed\",VLOOKUP(I11,'5.1.2 CPA Formulae'!B14:E24,2,FALSE))","v":"Fixed"}]
["105","3.9.6","Protector: surge AC single phase","PROTECTOR;TR1101-901-W,SURGE AC 1PHASE","each",50,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I12=\"\",\"Fixed\",VLOOKUP(I12,'5.1.2 CPA Formulae'!B15:E25,2,FALSE))","v":"Fixed"}]
["106","3.9.7","Protector: solar panel 120 V","PROTECTOR,TR1102-014-43,SOLAR PANEL 120V","each",80,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I13=\"\",\"Fixed\",VLOOKUP(I13,'5.1.2 CPA Formulae'!B16:E26,2,FALSE))","v":"Fixed"}]
["107","3.9.8","Protector: component AC surge protector","PROTECTOR;TR1101-826,SURGE AC SUPERHY","each",45,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I14=\"\",\"Fixed\",VLOOKUP(I14,'5.1.2 CPA Formulae'!B17:E27,2,FALSE))","v":"Fixed"}]
["108","3.9.9","Protector: outdoor 60 V PoE surge protector","PROTECTOR;TR1101-993,ALPU WEATHERPROOF","each",180,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I15=\"\",\"Fixed\",VLOOKUP(I15,'5.1.2 CPA Formulae'!B18:E28,2,FALSE))","v":"Fixed"}]
["109","3.9.10","Protector: 48 VDC DIN rail SADS","PROTECTOR;TR1101-626,48VDC DIN RAIL SADS","each",180,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I16=\"\",\"Fixed\",VLOOKUP(I16,'5.1.2 CPA Formulae'!B19:E29,2,FALSE))","v":"Fixed"}]
["110","3.9.11","Protector: AC common mode","PROTECTOR;TR1102-014-8,AC COMMON MODE","each",180,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I17=\"\",\"Fixed\",VLOOKUP(I17,'5.1.2 CPA Formulae'!B20:E30,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H7:H17)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Others","index":11,"n_rows":18,"n_cols":10,"rows_kept":18,"merged":[[1,8,1,9],[4,0,4,2]]}
["Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
[{"$nulls":8},"CPA"]
["Item No.","Spec Clause","Description 1","Description 2","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Description\n(See Sheet 5.1.2)"]
[]
["Other",{"$nulls":7},"Dropdown "]
["111","3.10.1","Tape: self-vulcanizing Scotch 23","TAPE;L26AA0001A,SELF VULCANIZING SCOTCH","each",600,null,{"$f":"G6*F6","v":{"v":0,"d":"R0.00"}},null,{"$f":"IF(I6=\"\",\"Fixed\",VLOOKUP(I6,'5.1.2 CPA Formulae'!B9:E19,2,FALSE))","v":"Fixed"}]
["112","3.10.2","Tape: insulation black 3M 14mm","TAPE;L26AA0002A,INSULATION BLACK 3M","each",1400,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I7=\"\",\"Fixed\",VLOOKUP(I7,'5.1.2 CPA Formulae'!B10:E20,2,FALSE))","v":"Fixed"}]
["113","3.10.3","Tape: insulation black 3M 48mm","TAPE;L25AL0010 : Tape PVC 48mmx10m","each",1400,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I8=\"\",\"Fixed\",VLOOKUP(I8,'5.1.2 CPA Formulae'!B11:E21,2,FALSE))","v":"Fixed"}]
["114","3.10.4","Tape: Butyl 48mm","TAPE;L25AL0000 : Tape Butyl 48mmx5m","each",1400,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I9=\"\",\"Fixed\",VLOOKUP(I9,'5.1.2 CPA Formulae'!B12:E22,2,FALSE))","v":"Fixed"}]
["115","3.10.5","Saddle: 5 mm BH500","SADDLE;CNACBH500,5MM BOX OF 100 BH500","each",1300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I10=\"\",\"Fixed\",VLOOKUP(I10,'5.1.2 CPA Formulae'!B13:E23,2,FALSE))","v":"Fixed"}]
["116","3.10.6","Crimper: crimp for L910","CRIMPER;CNCHT336J,CRIMP FOR L910","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I11=\"\",\"Fixed\",VLOOKUP(I11,'5.1.2 CPA Formulae'!B14:E24,2,FALSE))","v":"Fixed"}]
["117","3.10.7","Bundle: 9 × coax LMR 400","BUNDLE:CXLMRBC400-9;CO-AX","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I12=\"\",\"Fixed\",VLOOKUP(I12,'5.1.2 CPA Formulae'!B15:E25,2,FALSE))","v":"Fixed"}]
["118","3.10.8","Seal: boot weather - LMR400-9","SEAL:EC-BC400-9B;BOOT WEATHER","each",400,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I13=\"\",\"Fixed\",VLOOKUP(I13,'5.1.2 CPA Formulae'!B16:E26,2,FALSE))","v":"Fixed"}]
["119","3.10.9","Kit: grounding kit - LMR400-9","KIT:GK-BC400-9;GROUNDING","each",200,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I14=\"\",\"Fixed\",VLOOKUP(I14,'5.1.2 CPA Formulae'!B17:E27,2,FALSE))","v":"Fixed"}]
["120","3.10.10","Bundle: 4 × LMR400","BUNDLE:LMR-BC400-4;C0-AX 50V DC","each",200,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I15=\"\",\"Fixed\",VLOOKUP(I15,'5.1.2 CPA Formulae'!B18:E28,2,FALSE))","v":"Fixed"}]
["121","3.10.11","Shroud: LMR400-4, cold shrink","SHROUD:BC4004CS;COLD SHRINK","each",250,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I16=\"\",\"Fixed\",VLOOKUP(I16,'5.1.2 CPA Formulae'!B19:E29,2,FALSE))","v":"Fixed"}]
["122","3.10.12","Kit: grounding kit LMR400-4","KIT:GK-BC400-4;GROUNDING","each",300,null,{"v":0,"d":"R0.00"},null,{"$f":"IF(I17=\"\",\"Fixed\",VLOOKUP(I17,'5.1.2 CPA Formulae'!B20:E30,2,FALSE))","v":"Fixed"}]
[{"$nulls":7},{"$f":"SUM(H6:H17)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.2 CPA Formulae","index":12,"n_rows":148,"n_cols":67,"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.",null,"E2438NTCSAMWP"]
["Package Name:",null,"NTCSA System Operator - Telecommunications"]
["Tenderer's Name:",null,"Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
["Category of Offer:",null,{"$f":"'[1]Read Me'!C4","v":"Main Offer Only"}]
[]
["5.1.2 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 5.1.2. has to be populated by the tenderer (columns B - J), 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 Column N 5.1.1 Pricing is to be populated by the tenderer by selecting the respective drop down codes CPA formula as  developed by Tenderer in 5.1.2 CPA formulae worksheet   (e.g. Formula A-J ) then  the tenderer must populate their respective CPA formula in  5.1.2 CPA Formulae Worksheet. Codes and descriptions must be selected by the tenderer and inserted into each row of activity. "]
[5,"Prices will be fixed 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.  ",{"$nulls":10}," "]
[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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","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":"5.1.3 Summary","index":13,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[19,3,19,5],[21,3,21,5]]}
["Enquiry No.",null,"E2438NTCSAMWP"]
["Package Name:",null,"NTCSA System Operator - Telecommunications"]
["Tenderer's Name:",null,"Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
["Category of Offer:",null,{"$f":"'[3]Read Me'!C4","v":"Main Offer Only"}]
[]
["5.1.3 Summary ",{"$nulls":3},"Manual input required"]
[]
[null,null,"All prices in ZAR"]
["Table No.","Section Description","Total Tendered Value "]
[1,"Cables",{"$f":"'5.1.1 Cables'!H20","v":0}]
[2,"Boots",{"$f":"'5.1.1 Boots'!H10","v":0}]
[3,"Tools",{"$f":"'5.1.1 Tools'!H11","v":0}]
[4,"Connectors",{"$f":"'5.1.1 Connectors'!H32","v":0}]
[5,"Adaptors",{"$f":"'5.1.1 Adaptors'!H15","v":0}]
[6,"Flyleads",{"$f":"'5.1.1 Flyleads'!H15","v":0}]
[7,"Clamps",{"$f":"'5.1.1 Clamps'!H38","v":0}]
[8,"Protectors",{"$f":"'5.1.1 Protectors'!H18","v":0}]
[9,"Other",{"$f":"'5.1.1 Others'!H18","v":0}]
[]
[null,"TOTAL PRICE EXCLUDING VAT",{"$f":"SUM(C10:C19)","v":0},"Must agree with Price (Excl. VAT) on Tender Cover Page"]
[null,"SOUTH AFRICAN VAT - ON IMPORTED GOODS",{"$f":"C20*15%","v":0}," "]
[null,"TOTAL PRICES INCLUDING VAT",{"$f":"C20+C21","v":0},"Must agree with Price (Incl. VAT) on Tender Cover Page"]

{"sheet":"5.1.4 Exchange Rates","index":14,"n_rows":37,"n_cols":8,"rows_kept":37,"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],[3,0,3,1],[3,2,3,4],[8,1,8,6],[9,0,11,0],[9,1,9,6],[9,14,9,19],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,1,13,6],[14,0,16,0],[14,1,14,6],[15,1,15,6],[16,1,16,6],[21,7,21,12]]}
["Enquiry No.",null,"E2438NTCSAMWP"]
["Package Name:",null,"Supply and delivery of RF cables and connectors on an as and when required basis for a period of five (5) years"]
["Tenderer's Name:",null,{"$f":"'[1]Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'[1]Read Me'!C4","v":"Main Offer Only"}]
[]
["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"}]