{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["RFI Cover Sheet","5.1.0 Preamble","5.1.1 Price Table 1-17","5.1.2 CPA Formulae","5.1.3 Summary","5.1.4 PS5","5.1.4 Exchange Rates"],"not_rendered":{"images":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"RFI Cover Sheet","index":0,"n_rows":44,"n_cols":4,"rows_kept":44}
{"$rows_empty":9}
[null,"PRICING INFORMATION"]
[]
[null,"RFI No.","E2396NTCSAMWP"]
[]
[null,"NAME OF PACKAGE:","Supply, Delivery, Design, Installation, Commissioning, Support and Training on Environmental Racks with Built-in Air Conditioning, Noise Reduction Solutions, Heat Management Systems and Security Access Control for Substation Environments, on an as and when required basis"]
[]
[null,"SUPPLIER’S NAME:  "]
[]
[null,"CATEGORY OF OFFER (MAIN OFFER ONLY):","RFI"]
[]
[null," PRICE:  IN ZAR",{"$f":"'5.1.3 Summary'!F28","v":{"v":0,"d":"  0  RAND"}}]
[null,"(excluding VAT)"]
[]
[null,"RAND VALUE IN WORDS","[Price in Words]"]
[]
[]
[]
[]
[null," PRICE:  IN ZAR",{"$f":"'5.1.3 Summary'!F30","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":1,"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]]}
["RFI No.",null,{"$f":"'RFI Cover Sheet'!C12","v":"E2396NTCSAMWP"}]
["Package Name:",null,{"$f":"'RFI Cover Sheet'!C14","v":"Supply, Delivery, Design, Installation, Commissioning, Support and Training on Environmental Racks with Built-in Air Conditioning, Noise Reduction Solutions, Heat Management Systems and Security Access Control for Substation Environments, on an as and when required basis"}]
["Supplier's Name:",null,{"$f":"'RFI Cover Sheet'!C16","v":0}]
["Category of Offer:",null,"RFI"]
[]
["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.The units herein are estimates only and are non-committal.  No alternative offers are accepted."]
[2,"This is the main data entry sheet to be completed. The Supplier  takes responsibility for ensuring correct inputs. Supplier(s) to populate their pricing information as stipulated in the pricing schedule. The pricing schedule may not be changed or altered. Supplier(s) to populate all required information on the RFI 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 RFI 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 Supplier 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 Supplier must provide any breakdown of prices as may be required for specific items not detailed in the Price Schedule."]
[7,"The Prices should be exclusive and inclusive of VAT."]
[8," Please note, that the Supplier 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. Supplier(s) 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. Rate of exchange (ROE) cannot be accepted by NTCSA to form part of any CPA formulae."]
[10,"Only Light Green highlighted cells are to be inputted by the Supplier."]
[11,"There will be no inputting in Grey highlighted cells."]

{"sheet":"5.1.1 Price Table 1-17","index":2,"n_rows":303,"n_cols":27,"rows_kept":303,"merged":[[8,1,8,3],[9,1,9,3],[11,5,11,6],[11,7,11,11],[11,12,11,14],[11,15,11,26],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,14,13,14],[12,15,13,15],[12,16,13,25],[12,26,13,26],[301,7,301,9]]}
["Enquiry No.",{"$f":"'RFI Cover Sheet'!C12","v":"E2396NTCSAMWP"}]
["Package Name:",{"$f":"'RFI Cover Sheet'!C14","v":"Supply, Delivery, Design, Installation, Commissioning, Support and Training on Environmental Racks with Built-in Air Conditioning, Noise Reduction Solutions, Heat Management Systems and Security Access Control for Substation Environments, on an as and when required basis"}]
["Supplier's Name:"]
["Category of Offer:","RFI"]
[]
["5.1.1. Pricing"]
[]
["NOTES:"]
[1,"NB - Column F & Column N in 5.1.1 Pricing is a  drop down cell for supplier to select the Currency and CPA formula chosen that they would have populated in 5.1.2 CPA Formulae and 5.1.4 Exchange Rates. It is the Supplier's responsibility to ensure that Column H correctly reflects the intention of the Supplier."]
[2,"CPA Formulae Codes Column I 5.1.1 Pricing is to be populated by the supplier by selecting the respective drop down codes CPA formula as  developed by Supplier 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 supplier and inserted into each row of activity. "]
[]
[{"$nulls":5},"Local Currency",null,"Foreign Currency",{"$nulls":4},"Local + Foreign",null,null,"CPA"]
["Line No.","Activity description","Notes","Unit of measure"," Quantities","Tendered Rates (ZAR)","Total Tendered Value (ZAR)","Currency Code (See Sheet 5.1.4 Rate of Exchange)","RoE Currency 1,00 = ZAR","Unit Price in Foreign Currency","Total Foreign Price in Foreign Currency","Total Foreign Price in Local Currency (ZAR)","Tendered Price Excld. Vat (ZAR)","Vat ","Tendered Price Including Vat (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)","CPA Formula No.\n(See Sheet 5.1.2)",{"$nulls":9},"CPA Description\n(See Sheet 5.1.2)"]
[]
[null,"List of required items and services"]
[]
["Table 1","CONFIGURATION 1: STANDARD CABINET (BASIC)"]
["1.1","47U Standard 19\" Cabinet (600x600mm)","Drawing 0.53-1833 Standard equipment cabinet, 240-60725641","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P18=\"\",\"Fixed\",VLOOKUP(P18,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.2","Fixed and sliding rack shelves",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P19=\"\",\"Fixed\",VLOOKUP(P19,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.3","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P20=\"\",\"Fixed\",VLOOKUP(P20,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.4","Cable entry gland plate / brush strip",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P21=\"\",\"Fixed\",VLOOKUP(P21,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.5","Lockable front & rear doors (or lock set)",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P22=\"\",\"Fixed\",VLOOKUP(P22,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.6","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P23=\"\",\"Fixed\",VLOOKUP(P23,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.7","Basic PDU (Power Distribution Unit)","PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P24=\"\",\"Fixed\",VLOOKUP(P24,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.8","Blanking panels & mounting hardware",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P25=\"\",\"Fixed\",VLOOKUP(P25,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.9","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P26=\"\",\"Fixed\",VLOOKUP(P26,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.10","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P27=\"\",\"Fixed\",VLOOKUP(P27,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.11","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P28=\"\",\"Fixed\",VLOOKUP(P28,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.12","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P29=\"\",\"Fixed\",VLOOKUP(P29,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.13","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P30=\"\",\"Fixed\",VLOOKUP(P30,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["1.14","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P31=\"\",\"Fixed\",VLOOKUP(P31,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G18:G31)","v":0},{"$nulls":3},{"$f":"SUM(K18:K31)","v":0},{"$f":"SUM(L18:L31)","v":0},0,{"$f":"SUM(N18:N31)","v":0},{"$f":"SUM(O18:O31)","v":0}]
[{"$nulls":26},{"$f":"IF(P33=\"\",\"Fixed\",VLOOKUP(P33,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["Table 2","CONFIGURATION 2: STANDARD CABINET (PERFORATED)"]
["2.1","47U Standard Cabinet with 60% Perforation",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P35=\"\",\"Fixed\",VLOOKUP(P35,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.2","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P36=\"\",\"Fixed\",VLOOKUP(P36,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.3","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P37=\"\",\"Fixed\",VLOOKUP(P37,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.4","Basic PDU (Power Distribution Unit)"," PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P38=\"\",\"Fixed\",VLOOKUP(P38,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.5","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P39=\"\",\"Fixed\",VLOOKUP(P39,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.6","Perforated front/rear doors (60%+ perforation) ","Digital display PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P40=\"\",\"Fixed\",VLOOKUP(P40,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.7","Door gasket/seal kit for dust control","Dust protection","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P41=\"\",\"Fixed\",VLOOKUP(P41,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.8","EMI Gaskets for Perforation","EMI protection","Each",null,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P42=\"\",\"Fixed\",VLOOKUP(P42,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.9","Replaceable dust filters for airflow paths","Enhanced airflow ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P43=\"\",\"Fixed\",VLOOKUP(P43,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.10","Improved Ventilation Design","Enhanced airflow panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P44=\"\",\"Fixed\",VLOOKUP(P44,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.11","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P45=\"\",\"Fixed\",VLOOKUP(P45,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.12","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P46=\"\",\"Fixed\",VLOOKUP(P46,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.13","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P47=\"\",\"Fixed\",VLOOKUP(P47,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.14","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P48=\"\",\"Fixed\",VLOOKUP(P48,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["2.15","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P49=\"\",\"Fixed\",VLOOKUP(P49,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G35:G49)","v":0},{"$nulls":3},{"$f":"SUM(K35:K49)","v":0},{"$f":"SUM(L35:L49)","v":0},0,0,0]
[]
["Table 3","CONFIGURATION 3: Swing Frame (47U × 600 × 600)"]
["3.1","47U Swing Frame Cabinet (600x600mm)",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P53=\"\",\"Fixed\",VLOOKUP(P53,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.2","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P54=\"\",\"Fixed\",VLOOKUP(P54,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.3","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P55=\"\",\"Fixed\",VLOOKUP(P55,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.4","Basic PDU (Power Distribution Unit)"," PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P56=\"\",\"Fixed\",VLOOKUP(P56,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.5","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P57=\"\",\"Fixed\",VLOOKUP(P57,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.6","Perforated front/rear doors (60%+ perforation) - lockable","Perforated doors","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P58=\"\",\"Fixed\",VLOOKUP(P58,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.7","Swing-open rear frame (with cable support tray)",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P59=\"\",\"Fixed\",VLOOKUP(P59,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.8","19\" mounting rails, cage nuts, and hardware",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P60=\"\",\"Fixed\",VLOOKUP(P60,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.9","Standard Ventilation Panels","Enhanced airflow ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P61=\"\",\"Fixed\",VLOOKUP(P61,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.10","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P62=\"\",\"Fixed\",VLOOKUP(P62,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.11","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P63=\"\",\"Fixed\",VLOOKUP(P63,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.12","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P64=\"\",\"Fixed\",VLOOKUP(P64,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.13","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P65=\"\",\"Fixed\",VLOOKUP(P65,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["3.14","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P66=\"\",\"Fixed\",VLOOKUP(P66,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G53:G66)","v":0},{"$nulls":3},{"$f":"SUM(K53:K66)","v":0},{"$f":"SUM(L53:L66)","v":0},0,0,0]
[]
["Table 4","CONFIGURATION 4: Fixed Frame (47U × 600 × 600)"]
["4.1","47U fixed-frame cabinet (600W × 600D)","CPS Africa - Fixed frame for OTN/MPLS","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P70=\"\",\"Fixed\",VLOOKUP(P70,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.2","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P71=\"\",\"Fixed\",VLOOKUP(P71,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.3","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P72=\"\",\"Fixed\",VLOOKUP(P72,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.4","Basic PDU (Power Distribution Unit)"," PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P73=\"\",\"Fixed\",VLOOKUP(P73,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.5","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P74=\"\",\"Fixed\",VLOOKUP(P74,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.6","Perforated front/rear doors (60%+ perforation) ","Digital display PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P75=\"\",\"Fixed\",VLOOKUP(P75,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.7","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P76=\"\",\"Fixed\",VLOOKUP(P76,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.8","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P77=\"\",\"Fixed\",VLOOKUP(P77,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.9","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P78=\"\",\"Fixed\",VLOOKUP(P78,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.10","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P79=\"\",\"Fixed\",VLOOKUP(P79,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["4.11","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P80=\"\",\"Fixed\",VLOOKUP(P80,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G70:G80)","v":0},{"$nulls":3},{"$f":"SUM(K70:K80)","v":0},{"$f":"SUM(L70:L80)","v":0},0,0,0]
[]
["Table 5","CONFIGURATION 5: Swing Frame (47U × 600 × 1200)"]
["5.1","47U swing-frame cabinet (600W × 1200D)","Maximum depth fixed frame ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P84=\"\",\"Fixed\",VLOOKUP(P84,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.2","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P85=\"\",\"Fixed\",VLOOKUP(P85,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.3","PDU (Power Distribution Unit)"," PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P86=\"\",\"Fixed\",VLOOKUP(P86,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.4","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P87=\"\",\"Fixed\",VLOOKUP(P87,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.5","Perforated front/rear doors (60%+ perforation) ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P88=\"\",\"Fixed\",VLOOKUP(P88,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.6","Swing-back rear section for access",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P89=\"\",\"Fixed\",VLOOKUP(P89,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.7","Maximum vertical & horizontal cable management","1200mm depth rails","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P90=\"\",\"Fixed\",VLOOKUP(P90,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.8","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P91=\"\",\"Fixed\",VLOOKUP(P91,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.9","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P92=\"\",\"Fixed\",VLOOKUP(P92,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.10","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P93=\"\",\"Fixed\",VLOOKUP(P93,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.11","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P94=\"\",\"Fixed\",VLOOKUP(P94,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["5.12","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P95=\"\",\"Fixed\",VLOOKUP(P95,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G84:G95)","v":0},{"$nulls":3},{"$f":"SUM(K84:K95)","v":0},{"$f":"SUM(L84:L95)","v":0},0,0,0]
[]
["Table 6","CONFIGURATION 6: Fixed Frame Server Cabinet (47U × 600 × 800)",{"$nulls":24},{"$f":"IF(P98=\"\",\"Fixed\",VLOOKUP(P98,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.1","47U cabinet (600W × 800D)","Standard server depth","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P99=\"\",\"Fixed\",VLOOKUP(P99,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.2","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P100=\"\",\"Fixed\",VLOOKUP(P100,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.3","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P101=\"\",\"Fixed\",VLOOKUP(P101,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.4","Basic PDU (Power Distribution Unit)","Standard 8-outlet PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P102=\"\",\"Fixed\",VLOOKUP(P102,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.5","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P103=\"\",\"Fixed\",VLOOKUP(P103,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.6","Perforated front/rear doors (60%+ perforation) ","Digital display PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P104=\"\",\"Fixed\",VLOOKUP(P104,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.7","Server Cable Management Kit","Server-specific management","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P105=\"\",\"Fixed\",VLOOKUP(P105,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.8","Server Ventilation Panels","Enhanced server cooling","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P106=\"\",\"Fixed\",VLOOKUP(P106,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.9","Universal Server Mounting Rails","Universal server rails","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P107=\"\",\"Fixed\",VLOOKUP(P107,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.10","Temperature Monitoring","Server temp monitoring","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P108=\"\",\"Fixed\",VLOOKUP(P108,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.11","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P109=\"\",\"Fixed\",VLOOKUP(P109,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.12","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P110=\"\",\"Fixed\",VLOOKUP(P110,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.13","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P111=\"\",\"Fixed\",VLOOKUP(P111,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.14","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P112=\"\",\"Fixed\",VLOOKUP(P112,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["6.15","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P113=\"\",\"Fixed\",VLOOKUP(P113,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G99:G113)","v":0},{"$nulls":3},{"$f":"SUM(K99:K113)","v":0},{"$f":"SUM(L99:L113)","v":0},0,0,0]
[]
["Table 7","CONFIGURATION 7: Swing Frame Server Cabinet (47U × 600 × 800)"]
["7.1","47U Swing Frame Server Cabinet (600W × 800D)","Microteach","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P117=\"\",\"Fixed\",VLOOKUP(P117,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.2","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P118=\"\",\"Fixed\",VLOOKUP(P118,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.3","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P119=\"\",\"Fixed\",VLOOKUP(P119,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.4","Basic PDU (Power Distribution Unit)"," PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P120=\"\",\"Fixed\",VLOOKUP(P120,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.5","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P121=\"\",\"Fixed\",VLOOKUP(P121,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.6","Swing Frame Server System ","Server swing frame","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P122=\"\",\"Fixed\",VLOOKUP(P122,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.7","Server Cable Management Kit",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P123=\"\",\"Fixed\",VLOOKUP(P123,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.8","Server Ventilation Design","Server airflow ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P124=\"\",\"Fixed\",VLOOKUP(P124,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.9","Universal Mounting Rails (Adjustable)","Adjustable mounting","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P125=\"\",\"Fixed\",VLOOKUP(P125,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.10","Temperature Monitoring","Temp monitoring","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P126=\"\",\"Fixed\",VLOOKUP(P126,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.11","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P127=\"\",\"Fixed\",VLOOKUP(P127,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.12","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P128=\"\",\"Fixed\",VLOOKUP(P128,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.13","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P129=\"\",\"Fixed\",VLOOKUP(P129,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.14","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P130=\"\",\"Fixed\",VLOOKUP(P130,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["7.15","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P131=\"\",\"Fixed\",VLOOKUP(P131,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G117:G131)","v":0},{"$nulls":3},{"$f":"SUM(K117:K131)","v":0},{"$f":"SUM(L117:L131)","v":0},0,0,0]
[]
["Table 8","CONFIGURATION 8: STANDARD CABINET + SECURITY"]
["8.1","47U Standard 19\" Cabinet (600x600mm)",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P135=\"\",\"Fixed\",VLOOKUP(P135,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.2","Fixed and sliding rack shelves",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P136=\"\",\"Fixed\",VLOOKUP(P136,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.3","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P137=\"\",\"Fixed\",VLOOKUP(P137,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.4","Cable entry gland plate / brush strip",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P138=\"\",\"Fixed\",VLOOKUP(P138,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.5","Lockable front & rear doors (or lock set)",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P139=\"\",\"Fixed\",VLOOKUP(P139,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.6","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P140=\"\",\"Fixed\",VLOOKUP(P140,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.7","Basic PDU (Power Distribution Unit)"," PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P141=\"\",\"Fixed\",VLOOKUP(P141,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.8","Blanking panels & mounting hardware",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P142=\"\",\"Fixed\",VLOOKUP(P142,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.9","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P143=\"\",\"Fixed\",VLOOKUP(P143,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.10","Tamper Detection Sensors","Security breach detection","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P144=\"\",\"Fixed\",VLOOKUP(P144,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.11","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P145=\"\",\"Fixed\",VLOOKUP(P145,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.12","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P146=\"\",\"Fixed\",VLOOKUP(P146,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.13","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P147=\"\",\"Fixed\",VLOOKUP(P147,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.14","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P148=\"\",\"Fixed\",VLOOKUP(P148,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["8.15","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P149=\"\",\"Fixed\",VLOOKUP(P149,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G135:G149)","v":0},{"$nulls":3},{"$f":"SUM(K135:K149)","v":0},{"$f":"SUM(L135:L149)","v":0},0,0,0]
[]
["Table 9","CONFIGURATION 9: Security + PTZ CAMERA"]
["9.1","47U Standard 19\" Cabinet (600x600mm)",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P153=\"\",\"Fixed\",VLOOKUP(P153,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.2","Fixed and sliding rack shelves",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P154=\"\",\"Fixed\",VLOOKUP(P154,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.3","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P155=\"\",\"Fixed\",VLOOKUP(P155,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.4","Cable entry gland plate / brush strip",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P156=\"\",\"Fixed\",VLOOKUP(P156,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.5","Lockable front & rear doors (or lock set)",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P157=\"\",\"Fixed\",VLOOKUP(P157,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.6","Earthing/grounding kit","Earthing ","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P158=\"\",\"Fixed\",VLOOKUP(P158,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.7","Basic PDU (Power Distribution Unit)"," PDU","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P159=\"\",\"Fixed\",VLOOKUP(P159,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.8","Blanking panels & mounting hardware",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P160=\"\",\"Fixed\",VLOOKUP(P160,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.9","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P161=\"\",\"Fixed\",VLOOKUP(P161,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.10","Tamper Detection Sensors","Security breach detection","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P162=\"\",\"Fixed\",VLOOKUP(P162,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.11","PTZ Camera with Night Vision","Pan-tilt-zoom camera","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P163=\"\",\"Fixed\",VLOOKUP(P163,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.12","Camera Mounting Bracket","Secure camera mount","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P164=\"\",\"Fixed\",VLOOKUP(P164,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.13","Network Video Recorder (Local Storage)","Recording system","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P165=\"\",\"Fixed\",VLOOKUP(P165,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.14","Motion Detection Software","AI motion detection","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P166=\"\",\"Fixed\",VLOOKUP(P166,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.15","Remote Viewing Capability","Remote access software","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P167=\"\",\"Fixed\",VLOOKUP(P167,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.16","30-Day Video Storage","Storage capacity","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P168=\"\",\"Fixed\",VLOOKUP(P168,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.17","Delivery","Price per km","Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P169=\"\",\"Fixed\",VLOOKUP(P169,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.18","Design",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P170=\"\",\"Fixed\",VLOOKUP(P170,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.19","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P171=\"\",\"Fixed\",VLOOKUP(P171,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.20","Support  ",null,"Each",1,null,0,"ZAR",{"v":1,"d":"1.0000"},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P172=\"\",\"Fixed\",VLOOKUP(P172,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["9.21","Training","Cover installation, configuration and maintenance","Each",1,null,{"$f":"F173*E173","v":0},"ZAR",{"$f":"IF(H173<>\"\",VLOOKUP(H173,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E173*J173","v":0},{"$f":"E173*I173*J173","v":0},{"$f":"L173+G173","v":0},{"$f":"M173*15%","v":0},{"$f":"M173+N173","v":0},{"$nulls":11},{"$f":"IF(P173=\"\",\"Fixed\",VLOOKUP(P173,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G153:G173)","v":0},{"$nulls":3},{"$f":"SUM(K153:K173)","v":0},{"$f":"SUM(L153:L173)","v":0},0,0,0]
[]
["Table 10","CONFIGURATION 10: OTN/MPLS + RODENT-RESISTANT (47U x 600 x 600mm)"]
["10.1","47U Rodent-Resistant Cabinet (600x600mm)","OTN/MPLS pest protection","Each",1,null,{"$f":"F177*E177","v":0},"ZAR",{"$f":"IF(H177<>\"\",VLOOKUP(H177,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E177*J177","v":0},{"$f":"E177*I177*J177","v":0},{"$f":"L177+G177","v":0},{"$f":"M177*15%","v":0},{"$f":"M177+N177","v":0},{"$nulls":11},{"$f":"IF(P177=\"\",\"Fixed\",VLOOKUP(P177,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.2","Sealed Entry Point System","Complete sealing against rodents","Each",1,null,{"$f":"F178*E178","v":0},"ZAR",{"$f":"IF(H178<>\"\",VLOOKUP(H178,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E178*J178","v":0},{"$f":"E178*I178*J178","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P178=\"\",\"Fixed\",VLOOKUP(P178,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.3","Reinforced Cable Entry Brush Seals","Brush seal cable entries","Each",1,null,0,"ZAR",{"$f":"IF(H179<>\"\",VLOOKUP(H179,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P179=\"\",\"Fixed\",VLOOKUP(P179,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.4","Rodent-Proof Door Gaskets","Specialized door sealing","Each",1,null,0,"ZAR",{"$f":"IF(H180<>\"\",VLOOKUP(H180,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P180=\"\",\"Fixed\",VLOOKUP(P180,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.5","Mesh Ventilation Panels (Rodent-Proof)","Fine mesh prevents entry","Each",1,null,0,"ZAR",{"$f":"IF(H181<>\"\",VLOOKUP(H181,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P181=\"\",\"Fixed\",VLOOKUP(P181,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.6","Bottom Plate Sealing System","Floor entry protection","Each",1,null,{"$f":"F182*E182","v":0},"ZAR",{"$f":"IF(H182<>\"\",VLOOKUP(H182,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E182*J182","v":0},{"$f":"E182*I182*J182","v":0},{"$f":"L182+G182","v":0},{"$f":"M182*15%","v":0},{"$f":"M182+N182","v":0},{"$nulls":11},{"$f":"IF(P182=\"\",\"Fixed\",VLOOKUP(P182,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.7","Anti-Gnaw Material Coating","Prevents rodent damage","Each",1,null,{"$f":"F183*E183","v":0},"ZAR",{"$f":"IF(H183<>\"\",VLOOKUP(H183,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E183*J183","v":0},{"$f":"E183*I183*J183","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P183=\"\",\"Fixed\",VLOOKUP(P183,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.8","Inspection Access Ports (Sealed)","Maintenance access with seals","Each",1,null,0,"ZAR",{"$f":"IF(H184<>\"\",VLOOKUP(H184,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P184=\"\",\"Fixed\",VLOOKUP(P184,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.9","Basic PDU with Monitoring","Power distribution","Each",1,null,0,"ZAR",{"$f":"IF(H185<>\"\",VLOOKUP(H185,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P185=\"\",\"Fixed\",VLOOKUP(P185,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.10","OTN/MPLS Equipment Rails","Mounting system","Each",1,null,0,"ZAR",{"$f":"IF(H186<>\"\",VLOOKUP(H186,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P186=\"\",\"Fixed\",VLOOKUP(P186,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.11","Delivery","Price per km","Each",1,null,{"$f":"F187*E187","v":0},"ZAR",{"$f":"IF(H187<>\"\",VLOOKUP(H187,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E187*J187","v":0},{"$f":"E187*I187*J187","v":0},{"$f":"L187+G187","v":0},{"$f":"M187*15%","v":0},{"$f":"M187+N187","v":0},{"$nulls":11},{"$f":"IF(P187=\"\",\"Fixed\",VLOOKUP(P187,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.12","Design",null,"Each",1,null,{"$f":"F188*E188","v":0},"ZAR",{"$f":"IF(H188<>\"\",VLOOKUP(H188,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E188*J188","v":0},{"$f":"E188*I188*J188","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P188=\"\",\"Fixed\",VLOOKUP(P188,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.13","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"$f":"IF(H189<>\"\",VLOOKUP(H189,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P189=\"\",\"Fixed\",VLOOKUP(P189,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.14","Support  ",null,"Each",1,null,0,"ZAR",{"$f":"IF(H190<>\"\",VLOOKUP(H190,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P190=\"\",\"Fixed\",VLOOKUP(P190,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["10.15","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"$f":"IF(H191<>\"\",VLOOKUP(H191,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P191=\"\",\"Fixed\",VLOOKUP(P191,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G177:G191)","v":0},{"$nulls":3},{"$f":"SUM(K177:K191)","v":0},{"$f":"SUM(L177:L191)","v":0},0,0,0]
[]
["Table 11","CONFIGURATION 11: OTN/MPLS + ACTIVE VENTILATION"]
["11.1","47U Active Ventilation Cabinet (600x600mm)","OTN/MPLS with fans","Each",1,null,{"$f":"F195*E195","v":0},"ZAR",{"$f":"IF(H195<>\"\",VLOOKUP(H195,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E195*J195","v":0},{"$f":"E195*I195*J195","v":0},{"$f":"L195+G195","v":0},{"$f":"M195*15%","v":0},{"$f":"M195+N195","v":0},{"$nulls":11},{"$f":"IF(P195=\"\",\"Fixed\",VLOOKUP(P195,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.2","Intelligent Fan System (Top Mounted)","Heat extraction fans","Each",1,null,{"$f":"F196*E196","v":0},"ZAR",{"$f":"IF(H196<>\"\",VLOOKUP(H196,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E196*J196","v":0},{"$f":"E196*I196*J196","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P196=\"\",\"Fixed\",VLOOKUP(P196,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.3","Variable Speed Fan Controller","Temperature-based control","Each",1,null,0,"ZAR",{"$f":"IF(H197<>\"\",VLOOKUP(H197,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P197=\"\",\"Fixed\",VLOOKUP(P197,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.4","Redundant Fan Configuration","Backup fan system","Each",1,null,0,"ZAR",{"$f":"IF(H198<>\"\",VLOOKUP(H198,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P198=\"\",\"Fixed\",VLOOKUP(P198,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.5","Air Flow Sensors","Monitors air movement","Each",1,null,0,"ZAR",{"$f":"IF(H199<>\"\",VLOOKUP(H199,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P199=\"\",\"Fixed\",VLOOKUP(P199,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.6","Hot Air Extraction Ducting","Directs heat away from cabinet","Each",1,null,{"$f":"F200*E200","v":0},"ZAR",{"$f":"IF(H200<>\"\",VLOOKUP(H200,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E200*J200","v":0},{"$f":"E200*I200*J200","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P200=\"\",\"Fixed\",VLOOKUP(P200,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.7","Intake Air Filtration","Clean air intake","Each",1,null,{"$f":"F201*E201","v":0},"ZAR",{"$f":"IF(H201<>\"\",VLOOKUP(H201,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E201*J201","v":0},{"$f":"E201*I201*J201","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P201=\"\",\"Fixed\",VLOOKUP(P201,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.8","Fan Failure Alarm System","Alerts on fan failure ","Each",1,null,0,"ZAR",{"$f":"IF(H202<>\"\",VLOOKUP(H202,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P202=\"\",\"Fixed\",VLOOKUP(P202,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.9","Temperature Monitoring (Multi-Point)","Thermal management","Each",1,null,0,"ZAR",{"$f":"IF(H203<>\"\",VLOOKUP(H203,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P203=\"\",\"Fixed\",VLOOKUP(P203,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.10","Basic PDU with Monitoring","Power distribution","Each",1,null,0,"ZAR",{"$f":"IF(H204<>\"\",VLOOKUP(H204,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P204=\"\",\"Fixed\",VLOOKUP(P204,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["11.11","OTN/MPLS Equipment Rails","Mounting system","Each",1,null,{"$f":"F205*E205","v":0},"ZAR",{"$f":"IF(H205<>\"\",VLOOKUP(H205,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E205*J205","v":0},{"$f":"E205*I205*J205","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P205=\"\",\"Fixed\",VLOOKUP(P205,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G195:G205)","v":0},{"$nulls":3},{"$f":"SUM(K195:K205)","v":0},{"$f":"SUM(L195:L205)","v":0},0,0,0]
[]
["Table 12","CONFIGURATION 12: SOUND-DAMPED"]
["12.1","47U Standard 19\" Cabinet (600x600mm)",null,"Each",1,null,{"$f":"F209*E209","v":0},"ZAR",{"$f":"IF(H209<>\"\",VLOOKUP(H209,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E209*J209","v":0},{"$f":"E209*I209*J209","v":0},{"$f":"L209+G209","v":0},{"$f":"M209*15%","v":0},{"$f":"M209+N209","v":0},{"$nulls":11},{"$f":"IF(P209=\"\",\"Fixed\",VLOOKUP(P209,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.2","Fixed and sliding rack shelves",null,"Each",1,null,{"$f":"F210*E210","v":0},"ZAR",{"$f":"IF(H210<>\"\",VLOOKUP(H210,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E210*J210","v":0},{"$f":"E210*I210*J210","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P210=\"\",\"Fixed\",VLOOKUP(P210,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.3","Vertical and horizontal cable management","Horizontal and vertical managers","Each",1,null,0,"ZAR",{"$f":"IF(H211<>\"\",VLOOKUP(H211,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P211=\"\",\"Fixed\",VLOOKUP(P211,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.4","Cable entry gland plate / brush strip",null,"Each",1,null,0,"ZAR",{"$f":"IF(H212<>\"\",VLOOKUP(H212,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P212=\"\",\"Fixed\",VLOOKUP(P212,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.5","Lockable front & rear doors (or lock set)",null,"Each",1,null,0,"ZAR",{"$f":"IF(H213<>\"\",VLOOKUP(H213,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P213=\"\",\"Fixed\",VLOOKUP(P213,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.6","Earthing/grounding kit","Earthing ","Each",1,null,{"$f":"F214*E214","v":0},"ZAR",{"$f":"IF(H214<>\"\",VLOOKUP(H214,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E214*J214","v":0},{"$f":"E214*I214*J214","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P214=\"\",\"Fixed\",VLOOKUP(P214,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.7","Basic PDU (Power Distribution Unit)","Standard 8-outlet PDU","Each",1,null,{"$f":"F215*E215","v":0},"ZAR",{"$f":"IF(H215<>\"\",VLOOKUP(H215,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E215*J215","v":0},{"$f":"E215*I215*J215","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P215=\"\",\"Fixed\",VLOOKUP(P215,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.8","Blanking panels & mounting hardware",null,"Each",1,null,0,"ZAR",{"$f":"IF(H216<>\"\",VLOOKUP(H216,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P216=\"\",\"Fixed\",VLOOKUP(P216,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.9","Labelling kit and rack ID plates","Top and bottom vented panels","Each",1,null,0,"ZAR",{"$f":"IF(H217<>\"\",VLOOKUP(H217,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P217=\"\",\"Fixed\",VLOOKUP(P217,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.10","Soundproof door assembly with seals",null,"Each",1,null,0,"ZAR",{"$f":"IF(H218<>\"\",VLOOKUP(H218,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P218=\"\",\"Fixed\",VLOOKUP(P218,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.11","Specialized Acoustic Foam Lining","Sound absorption material","Each",1,null,{"$f":"F219*E219","v":0},"ZAR",{"$f":"IF(H219<>\"\",VLOOKUP(H219,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E219*J219","v":0},{"$f":"E219*I219*J219","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P219=\"\",\"Fixed\",VLOOKUP(P219,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.12","Vibration isolators / anti-resonance mounting feet",null,"Each",1,null,{"$f":"F220*E220","v":0},"ZAR",{"$f":"IF(H220<>\"\",VLOOKUP(H220,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E220*J220","v":0},{"$f":"E220*I220*J220","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P220=\"\",\"Fixed\",VLOOKUP(P220,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.13","Sound-Dampened Ventilation System","Acoustic ventilation","Each",1,null,0,"ZAR",{"$f":"IF(H221<>\"\",VLOOKUP(H221,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P221=\"\",\"Fixed\",VLOOKUP(P221,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.14","Delivery","Price per km","Each",1,null,0,"ZAR",{"$f":"IF(H222<>\"\",VLOOKUP(H222,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P222=\"\",\"Fixed\",VLOOKUP(P222,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.15","Design",null,"Each",1,null,0,"ZAR",{"$f":"IF(H223<>\"\",VLOOKUP(H223,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P223=\"\",\"Fixed\",VLOOKUP(P223,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.16","Installation& Commissioning",null,"Each",1,null,{"$f":"F224*E224","v":0},"ZAR",{"$f":"IF(H224<>\"\",VLOOKUP(H224,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E224*J224","v":0},{"$f":"E224*I224*J224","v":0},{"$f":"L224+G224","v":0},{"$f":"M224*15%","v":0},{"$f":"M224+N224","v":0},{"$nulls":11},{"$f":"IF(P224=\"\",\"Fixed\",VLOOKUP(P224,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.17","Support  ",null,"Each",1,null,0,"ZAR",{"$f":"IF(H225<>\"\",VLOOKUP(H225,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P225=\"\",\"Fixed\",VLOOKUP(P225,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["12.18","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"$f":"IF(H226<>\"\",VLOOKUP(H226,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P226=\"\",\"Fixed\",VLOOKUP(P226,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G209:G226)","v":0},{"$nulls":3},{"$f":"SUM(K209:K226)","v":0},{"$f":"SUM(L209:L226)","v":0},0,0,0]
[]
["Table 13","CONFIGURATION 13: ENVIRO RACK (INTEGRATED COOLING - 6KW)"]
["13.1","47U Environmental Cabinet Base",null,"Each",1,null,{"$f":"F230*E230","v":0},"ZAR",{"$f":"IF(H230<>\"\",VLOOKUP(H230,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E230*J230","v":0},{"$f":"E230*I230*J230","v":0},{"$f":"L230+G230","v":0},{"$f":"M230*15%","v":0},{"$f":"M230+N230","v":0},{"$nulls":11},{"$f":"IF(P230=\"\",\"Fixed\",VLOOKUP(P230,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.2","6kW Integrated Cooling System","Cooling unit with compressor","Each",1,null,{"$f":"F231*E231","v":0},"ZAR",{"$f":"IF(H231<>\"\",VLOOKUP(H231,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E231*J231","v":0},{"$f":"E231*I231*J231","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P231=\"\",\"Fixed\",VLOOKUP(P231,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.3","Temperature and Humidity Monitoring","Environmental sensors","Each",1,null,0,"ZAR",{"$f":"IF(H232<>\"\",VLOOKUP(H232,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P232=\"\",\"Fixed\",VLOOKUP(P232,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.4","Condensate Management System","Water removal system","Each",1,null,0,"ZAR",{"$f":"IF(H233<>\"\",VLOOKUP(H233,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P233=\"\",\"Fixed\",VLOOKUP(P233,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.5","Air Filtration (Dust Protection)","HEPA filtration","Each",1,null,0,"ZAR",{"$f":"IF(H234<>\"\",VLOOKUP(H234,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P234=\"\",\"Fixed\",VLOOKUP(P234,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.6","Leak Detection System","Water leak sensors","Each",1,null,{"$f":"F235*E235","v":0},"ZAR",{"$f":"IF(H235<>\"\",VLOOKUP(H235,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E235*J235","v":0},{"$f":"E235*I235*J235","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P235=\"\",\"Fixed\",VLOOKUP(P235,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.7","Thermal Management","Smart temperature control","Each",1,null,{"$f":"F236*E236","v":0},"ZAR",{"$f":"IF(H236<>\"\",VLOOKUP(H236,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E236*J236","v":0},{"$f":"E236*I236*J236","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P236=\"\",\"Fixed\",VLOOKUP(P236,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.8","OTN/MPLS Equipment Rails",null,"Each",1,null,0,"ZAR",{"$f":"IF(H237<>\"\",VLOOKUP(H237,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P237=\"\",\"Fixed\",VLOOKUP(P237,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.9","Delivery","Price per km","Each",1,null,0,"ZAR",{"$f":"IF(H238<>\"\",VLOOKUP(H238,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P238=\"\",\"Fixed\",VLOOKUP(P238,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.10","Design",null,"Each",1,null,0,"ZAR",{"$f":"IF(H239<>\"\",VLOOKUP(H239,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P239=\"\",\"Fixed\",VLOOKUP(P239,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.11","Installation& Commissioning",null,"Each",1,null,{"$f":"F240*E240","v":0},"ZAR",{"$f":"IF(H240<>\"\",VLOOKUP(H240,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E240*J240","v":0},{"$f":"E240*I240*J240","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P240=\"\",\"Fixed\",VLOOKUP(P240,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.12","Support  ",null,"Each",1,null,{"$f":"F241*E241","v":0},"ZAR",{"$f":"IF(H241<>\"\",VLOOKUP(H241,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E241*J241","v":0},{"$f":"E241*I241*J241","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P241=\"\",\"Fixed\",VLOOKUP(P241,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["13.13","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"$f":"IF(H242<>\"\",VLOOKUP(H242,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P242=\"\",\"Fixed\",VLOOKUP(P242,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G230:G242)","v":0},{"$nulls":3},{"$f":"SUM(K230:K242)","v":0},{"$f":"SUM(L230:L242)","v":0},0,0,0]
[]
["Table 14","CONFIGURATION 14: ENVIRO RACK (INTEGRATED COOLING - 12KW)"]
["14.1","47U Environmental Cabinet (600x800mm)",null,"Each",1,null,{"$f":"F246*E246","v":0},"ZAR",{"$f":"IF(H246<>\"\",VLOOKUP(H246,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E246*J246","v":0},{"$f":"E246*I246*J246","v":0},{"$f":"L246+G246","v":0},{"$f":"M246*15%","v":0},{"$f":"M246+N246","v":0},{"$nulls":11},{"$f":"IF(P246=\"\",\"Fixed\",VLOOKUP(P246,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.2","12kW Integrated Cooling System","Cooling unit with compressor","Each",1,null,{"$f":"F247*E247","v":0},"ZAR",{"$f":"IF(H247<>\"\",VLOOKUP(H247,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E247*J247","v":0},{"$f":"E247*I247*J247","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P247=\"\",\"Fixed\",VLOOKUP(P247,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.3","Temperature and Humidity Monitoring","Environmental sensors","Each",1,null,0,"ZAR",{"$f":"IF(H248<>\"\",VLOOKUP(H248,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P248=\"\",\"Fixed\",VLOOKUP(P248,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.4","Condensate Management System","Water removal system","Each",1,null,0,"ZAR",{"$f":"IF(H249<>\"\",VLOOKUP(H249,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P249=\"\",\"Fixed\",VLOOKUP(P249,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.5","Air Filtration (Dust Protection)","HEPA filtration","Each",1,null,0,"ZAR",{"$f":"IF(H250<>\"\",VLOOKUP(H250,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P250=\"\",\"Fixed\",VLOOKUP(P250,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.6","Leak Detection System","Water leak sensors","Each",1,null,{"$f":"F251*E251","v":0},"ZAR",{"$f":"IF(H251<>\"\",VLOOKUP(H251,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E251*J251","v":0},{"$f":"E251*I251*J251","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P251=\"\",\"Fixed\",VLOOKUP(P251,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.7","High-Density PDU",null,"Each",1,null,{"$f":"F252*E252","v":0},"ZAR",{"$f":"IF(H252<>\"\",VLOOKUP(H252,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E252*J252","v":0},{"$f":"E252*I252*J252","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P252=\"\",\"Fixed\",VLOOKUP(P252,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.8","Thermal Management","Smart temperature control","Each",1,null,0,"ZAR",{"$f":"IF(H253<>\"\",VLOOKUP(H253,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P253=\"\",\"Fixed\",VLOOKUP(P253,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.9","Delivery","Price per km","Each",1,null,0,"ZAR",{"$f":"IF(H254<>\"\",VLOOKUP(H254,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P254=\"\",\"Fixed\",VLOOKUP(P254,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.10","Design",null,"Each",1,null,0,"ZAR",{"$f":"IF(H255<>\"\",VLOOKUP(H255,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P255=\"\",\"Fixed\",VLOOKUP(P255,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.11","Installation& Commissioning",null,"Each",1,null,{"$f":"F256*E256","v":0},"ZAR",{"$f":"IF(H256<>\"\",VLOOKUP(H256,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E256*J256","v":0},{"$f":"E256*I256*J256","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P256=\"\",\"Fixed\",VLOOKUP(P256,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.12","Support  ",null,"Each",1,null,{"$f":"F257*E257","v":0},"ZAR",{"$f":"IF(H257<>\"\",VLOOKUP(H257,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E257*J257","v":0},{"$f":"E257*I257*J257","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P257=\"\",\"Fixed\",VLOOKUP(P257,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["14.13","Training","Cover installation, configuration and maintenance","Each",1,null,0,"ZAR",{"$f":"IF(H258<>\"\",VLOOKUP(H258,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P258=\"\",\"Fixed\",VLOOKUP(P258,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G246:G258)","v":0},{"$nulls":3},{"$f":"SUM(K246:K258)","v":0},{"$f":"SUM(L246:L258)","v":0},0,0,0]
[]
["Table 15","CONFIGURATION 15: ENVIRO RACK (INTEGRATED COOLING - 20KW)"]
["15.1","47U Environmental Cabinet Base",null,"Each",1,null,{"$f":"F262*E262","v":0},"ZAR",{"$f":"IF(H262<>\"\",VLOOKUP(H262,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E262*J262","v":0},{"$f":"E262*I262*J262","v":0},{"$f":"L262+G262","v":0},{"$f":"M262*15%","v":0},{"$f":"M262+N262","v":0},{"$nulls":11},{"$f":"IF(P262=\"\",\"Fixed\",VLOOKUP(P262,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.2","6kW Integrated Cooling System","Cooling unit with compressor","Each",1,null,{"$f":"F263*E263","v":0},"ZAR",{"$f":"IF(H263<>\"\",VLOOKUP(H263,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E263*J263","v":0},{"$f":"E263*I263*J263","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P263=\"\",\"Fixed\",VLOOKUP(P263,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.3","Temperature and Humidity Monitoring","Environmental sensors","Each",1,null,0,"ZAR",{"$f":"IF(H264<>\"\",VLOOKUP(H264,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P264=\"\",\"Fixed\",VLOOKUP(P264,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.4","Condensate Management System","Water removal system","Each",1,null,0,"ZAR",{"$f":"IF(H265<>\"\",VLOOKUP(H265,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P265=\"\",\"Fixed\",VLOOKUP(P265,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.5","Air Filtration (Dust Protection)","HEPA filtration","Each",1,null,0,"ZAR",{"$f":"IF(H266<>\"\",VLOOKUP(H266,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P266=\"\",\"Fixed\",VLOOKUP(P266,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.6","Leak Detection System","Water leak sensors","Each",1,null,{"$f":"F267*E267","v":0},"ZAR",{"$f":"IF(H267<>\"\",VLOOKUP(H267,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E267*J267","v":0},{"$f":"E267*I267*J267","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P267=\"\",\"Fixed\",VLOOKUP(P267,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.7","Thermal Management","Smart temperature control","Each",1,null,{"$f":"F268*E268","v":0},"ZAR",{"$f":"IF(H268<>\"\",VLOOKUP(H268,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E268*J268","v":0},{"$f":"E268*I268*J268","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P268=\"\",\"Fixed\",VLOOKUP(P268,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.8","Delivery","Price per km","Each",1,null,0,"ZAR",{"$f":"IF(H269<>\"\",VLOOKUP(H269,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P269=\"\",\"Fixed\",VLOOKUP(P269,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.9","Design",null,"Each",1,null,0,"ZAR",{"$f":"IF(H270<>\"\",VLOOKUP(H270,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P270=\"\",\"Fixed\",VLOOKUP(P270,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.10","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"$f":"IF(H271<>\"\",VLOOKUP(H271,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P271=\"\",\"Fixed\",VLOOKUP(P271,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.11","Support  ",null,"Each",1,null,{"$f":"F272*E272","v":0},"ZAR",{"$f":"IF(H272<>\"\",VLOOKUP(H272,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E272*J272","v":0},{"$f":"E272*I272*J272","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P272=\"\",\"Fixed\",VLOOKUP(P272,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["15.12","Training","Cover installation, configuration and maintenance","Each",1,null,{"$f":"F273*E273","v":0},"ZAR",{"$f":"IF(H273<>\"\",VLOOKUP(H273,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E273*J273","v":0},{"$f":"E273*I273*J273","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P273=\"\",\"Fixed\",VLOOKUP(P273,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G262:G273)","v":0},{"$nulls":3},{"$f":"SUM(K262:K273)","v":0},{"$f":"SUM(L262:L273)","v":0},0,0,0]
[]
["Table 16","CONFIGURATION 16: PREMIUM SECURITY CABINET"]
["16.1","47U Environmental Cabinet","Base cabinet unit","Each",1,null,{"$f":"F277*E277","v":0},"ZAR",{"$f":"IF(H277<>\"\",VLOOKUP(H277,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E277*J277","v":0},{"$f":"E277*I277*J277","v":0},{"$f":"L277+G277","v":0},{"$f":"M277*15%","v":0},{"$f":"M277+N277","v":0},{"$nulls":11},{"$f":"IF(P277=\"\",\"Fixed\",VLOOKUP(P277,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.2","20kW Integrated Cooling System","Pan-tilt-zoom camera","Each",1,null,{"$f":"F278*E278","v":0},"ZAR",{"$f":"IF(H278<>\"\",VLOOKUP(H278,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E278*J278","v":0},{"$f":"E278*I278*J278","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P278=\"\",\"Fixed\",VLOOKUP(P278,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.3","Integrated Biometric Security","Secure camera mount","Each",1,null,0,"ZAR",{"$f":"IF(H279<>\"\",VLOOKUP(H279,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P279=\"\",\"Fixed\",VLOOKUP(P279,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.4","PTZ Camera","Recording system","Each",1,null,0,"ZAR",{"$f":"IF(H280<>\"\",VLOOKUP(H280,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P280=\"\",\"Fixed\",VLOOKUP(P280,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.5","Sound Dampening (≤65dB)","AI motion detection","Each",1,null,0,"ZAR",{"$f":"IF(H281<>\"\",VLOOKUP(H281,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P281=\"\",\"Fixed\",VLOOKUP(P281,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.6","Dual Power Distribution (48V DC + 230V AC)","Remote access software","Each",1,null,{"$f":"F282*E282","v":0},"ZAR",{"$f":"IF(H282<>\"\",VLOOKUP(H282,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E282*J282","v":0},{"$f":"E282*I282*J282","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P282=\"\",\"Fixed\",VLOOKUP(P282,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.7","30-Day Video Storage","Storage capacity","Each",1,null,{"$f":"F283*E283","v":0},"ZAR",{"$f":"IF(H283<>\"\",VLOOKUP(H283,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E283*J283","v":0},{"$f":"E283*I283*J283","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P283=\"\",\"Fixed\",VLOOKUP(P283,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.8","Delivery","Price per km","Each",1,null,0,"ZAR",{"$f":"IF(H284<>\"\",VLOOKUP(H284,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P284=\"\",\"Fixed\",VLOOKUP(P284,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.9","Design",null,"Each",1,null,0,"ZAR",{"$f":"IF(H285<>\"\",VLOOKUP(H285,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P285=\"\",\"Fixed\",VLOOKUP(P285,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.10","Installation& Commissioning",null,"Each",1,null,0,"ZAR",{"$f":"IF(H286<>\"\",VLOOKUP(H286,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P286=\"\",\"Fixed\",VLOOKUP(P286,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.11","Support  ",null,"Each",1,null,{"$f":"F287*E287","v":0},"ZAR",{"$f":"IF(H287<>\"\",VLOOKUP(H287,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E287*J287","v":0},{"$f":"E287*I287*J287","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P287=\"\",\"Fixed\",VLOOKUP(P287,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["16.12","Training","Cover installation, configuration and maintenance","Each",1,null,{"$f":"F288*E288","v":0},"ZAR",{"$f":"IF(H288<>\"\",VLOOKUP(H288,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E288*J288","v":0},{"$f":"E288*I288*J288","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P288=\"\",\"Fixed\",VLOOKUP(P288,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G277:G288)","v":0},{"$nulls":3},{"$f":"SUM(K277:K288)","v":0},{"$f":"SUM(L277:L288)","v":0},0,0,0]
[]
["Table 17","PDU DC Circuit breakers"]
["17.1","5A",null,"Each",1,null,{"$f":"F292*E292","v":0},"ZAR",{"$f":"IF(H292<>\"\",VLOOKUP(H292,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E292*J292","v":0},{"$f":"E292*I292*J292","v":0},{"$f":"L292+G292","v":0},{"$f":"M292*15%","v":0},{"$f":"M292+N292","v":0},{"$nulls":11},{"$f":"IF(P292=\"\",\"Fixed\",VLOOKUP(P292,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["17.2","10A",null,"Each",1,null,{"$f":"F293*E293","v":0},"ZAR",{"$f":"IF(H293<>\"\",VLOOKUP(H293,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E293*J293","v":0},{"$f":"E293*I293*J293","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P293=\"\",\"Fixed\",VLOOKUP(P293,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["17.3","15A",null,"Each",1,null,0,"ZAR",{"$f":"IF(H294<>\"\",VLOOKUP(H294,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P294=\"\",\"Fixed\",VLOOKUP(P294,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["17.4","20A",null,"Each",1,null,0,"ZAR",{"$f":"IF(H295<>\"\",VLOOKUP(H295,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P295=\"\",\"Fixed\",VLOOKUP(P295,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["17.5","25A",null,"Each",1,null,0,"ZAR",{"$f":"IF(H296<>\"\",VLOOKUP(H296,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,0,0,0,0,0,{"$nulls":11},{"$f":"IF(P296=\"\",\"Fixed\",VLOOKUP(P296,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["17.6","30A",null,"Each",1,null,{"$f":"F297*E297","v":0},"ZAR",{"$f":"IF(H297<>\"\",VLOOKUP(H297,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E297*J297","v":0},{"$f":"E297*I297*J297","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P297=\"\",\"Fixed\",VLOOKUP(P297,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
["17.7","50A",null,"Each",1,null,{"$f":"F298*E298","v":0},"ZAR",{"$f":"IF(H298<>\"\",VLOOKUP(H298,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":{"v":1,"d":"1.0000"}},null,{"$f":"E298*J298","v":0},{"$f":"E298*I298*J298","v":0},0,0,0,{"$nulls":11},{"$f":"IF(P298=\"\",\"Fixed\",VLOOKUP(P298,'5.1.2 CPA Formulae'!$B$9:$E$20,2,FALSE))","v":"Fixed"}]
[]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G291:G299)","v":0},{"$nulls":3},{"$f":"SUM(K291:K299)","v":0},{"$f":"SUM(L291:L299)","v":0},{"$f":"SUM(M291:M299)","v":0},{"$f":"SUM(N291:N299)","v":0},{"$f":"SUM(O291:O299)","v":0}]
[]
[null,"Total Value",{"$nulls":4},{"$f":"G32+G50+G67+G81+G96+G114+G132+G150+G174+G192+G206+G227+G243+G259+G274+G289+G300","v":0},{"$nulls":3},{"$f":"K32+K50+K67+K81+K96+K114+K132+K150+K174+K192+K206+K227+K243+K259+K274+K289+K300","v":0},{"$f":"L32+L50+L67+L81+L96+L114+L132+L150+L174+L192+L206+L227+L243+L259+L274+L289+L300","v":0},{"$f":"M32+M50+M67+M81+M96+M114+M132+M150+M174+M192+M206+M227+M243+M259+M274+M289+M300","v":0},{"$f":"N32+N50+N67+N81+N96+N114+N132+N150+N174+N192+N206+N227+N243+N259+N274+N289+N300","v":0},{"$f":"O32+O50+O67+O81+O96+O114+O132+O150+O174+O192+O206+O227+O243+O259+O274+O289+O300","v":0}]
[{"$nulls":12},"Must agree with Price (Excl. VAT) on RFI Cover Page",null,"Must agree with Price (Incl. VAT) on RFI Cover Page"]

{"sheet":"5.1.2 CPA Formulae","index":3,"n_rows":149,"n_cols":67,"rows_kept":149,"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,19,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],[19,2,19,4],[22,1,22,6],[23,1,23,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[31,1,31,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[36,1,36,6],[37,1,37,6],[41,1,41,6],[52,1,52,6],[63,1,63,6],[74,1,74,6],[85,1,85,6],[96,1,96,6],[107,1,107,6],[118,1,118,6],[129,1,129,6],[140,1,140,6]]}
["Enquiry No.",null,{"$f":"'RFI Cover Sheet'!C12","v":"E2396NTCSAMWP"}]
["Package Name:",null,{"$f":"'RFI Cover Sheet'!C14","v":"Supply, Delivery, Design, Installation, Commissioning, Support and Training on Environmental Racks with Built-in Air Conditioning, Noise Reduction Solutions, Heat Management Systems and Security Access Control for Substation Environments, on an as and when required basis"}]
["Supplier's Name:",null,{"$f":"'RFI Cover Sheet'!C16","v":0}]
["Category of Offer:",null,"RFI"]
[]
["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,"A1","Tenderer's description of Multiple Formula ",null,null,"Type in the description of each formula in the tables below"]
[3,"A",{"$f":"B42","v":"Tenderer's description of Formula A"}]
[4,"B",{"$f":"B53","v":"Tenderer's description of Formula B"}]
[5,"C",{"$f":"B64","v":"Tenderer's description of Formula C"}]
[6,"D",{"$f":"B75","v":"Tenderer's description of Formula D"}]
[7,"E",{"$f":"B86","v":"Tenderer's description of Formula E"}]
[8,"F",{"$f":"B97","v":"Tenderer's description of Formula F"}]
[9,"G",{"$f":"B108","v":"Tenderer's description of Formula G"}]
[10,"H",{"$f":"B119","v":"Tenderer's description of Formula H"}]
[11,"I",{"$f":"B130","v":"Tenderer's description of Formula I"}]
[12,"J",{"$f":"B141","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 CPA will be applicable and will be applied on the contract 16 months from base date 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(B44:B49)","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(B55:B60)","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(B66:B71)","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(B77:B82)","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(B88:B93)","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(B99:B104)","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(B110:B115)","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(B121:B126)","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(B132:B137)","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(B143:B148)","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":4,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[7,3,7,5],[27,6,27,8],[29,6,29,8]]}
["Enquiry No.",null,{"$f":"'RFI Cover Sheet'!C12","v":"E2396NTCSAMWP"}]
["Package Name:",null,{"$f":"'RFI Cover Sheet'!C14","v":"Supply, Delivery, Design, Installation, Commissioning, Support and Training on Environmental Racks with Built-in Air Conditioning, Noise Reduction Solutions, Heat Management Systems and Security Access Control for Substation Environments, on an as and when required basis"}]
["Supplier's Name:",null,{"$f":"'RFI Cover Sheet'!C16","v":0}]
["Category of Offer:",null,"RFI"]
[]
["5.1.3 Summary ",{"$nulls":6},"Manual input required"]
[]
[{"$nulls":3},"All prices in ZAR"]
["Table No.","Section Description","Total Foreign Currency","Total Foreign Currency (ZAR)","Local","Total  Value "]
[1,{"$f":"'5.1.1 Price Table 1-17'!A17","v":"Table 1"},{"$f":"'5.1.1 Price Table 1-17'!K32","v":0},{"$f":"'5.1.1 Price Table 1-17'!L32","v":0},{"$f":"'5.1.1 Price Table 1-17'!G32","v":0},{"$f":"'5.1.1 Price Table 1-17'!M32","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A34","v":"Table 2"},{"$f":"'5.1.1 Price Table 1-17'!K50","v":0},{"$f":"'5.1.1 Price Table 1-17'!L50","v":0},{"$f":"'5.1.1 Price Table 1-17'!G50","v":0},{"$f":"'5.1.1 Price Table 1-17'!M50","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A52","v":"Table 3"},{"$f":"'5.1.1 Price Table 1-17'!K67","v":0},{"$f":"'5.1.1 Price Table 1-17'!L67","v":0},{"$f":"'5.1.1 Price Table 1-17'!G67","v":0},{"$f":"'5.1.1 Price Table 1-17'!M67","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A69","v":"Table 4"},{"$f":"'5.1.1 Price Table 1-17'!K81","v":0},{"$f":"'5.1.1 Price Table 1-17'!L81","v":0},{"$f":"'5.1.1 Price Table 1-17'!G81","v":0},{"$f":"'5.1.1 Price Table 1-17'!M81","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A83","v":"Table 5"},{"$f":"'5.1.1 Price Table 1-17'!K96","v":0},{"$f":"'5.1.1 Price Table 1-17'!L96","v":0},{"$f":"'5.1.1 Price Table 1-17'!G96","v":0},{"$f":"'5.1.1 Price Table 1-17'!M96","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A98","v":"Table 6"},{"$f":"'5.1.1 Price Table 1-17'!K114","v":0},{"$f":"'5.1.1 Price Table 1-17'!L114","v":0},{"$f":"'5.1.1 Price Table 1-17'!G114","v":0},{"$f":"'5.1.1 Price Table 1-17'!M114","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A116","v":"Table 7"},{"$f":"'5.1.1 Price Table 1-17'!K132","v":0},{"$f":"'5.1.1 Price Table 1-17'!L132","v":0},{"$f":"'5.1.1 Price Table 1-17'!G132","v":0},{"$f":"'5.1.1 Price Table 1-17'!M132","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A134","v":"Table 8"},{"$f":"'5.1.1 Price Table 1-17'!K150","v":0},{"$f":"'5.1.1 Price Table 1-17'!L150","v":0},{"$f":"'5.1.1 Price Table 1-17'!G150","v":0},{"$f":"'5.1.1 Price Table 1-17'!M150","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A152","v":"Table 9"},{"$f":"'5.1.1 Price Table 1-17'!K174","v":0},{"$f":"'5.1.1 Price Table 1-17'!L174","v":0},{"$f":"'5.1.1 Price Table 1-17'!G174","v":0},{"$f":"'5.1.1 Price Table 1-17'!M174","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A176","v":"Table 10"},{"$f":"'5.1.1 Price Table 1-17'!K192","v":0},{"$f":"'5.1.1 Price Table 1-17'!L192","v":0},{"$f":"'5.1.1 Price Table 1-17'!G192","v":0},{"$f":"'5.1.1 Price Table 1-17'!M192","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A194","v":"Table 11"},{"$f":"'5.1.1 Price Table 1-17'!K206","v":0},{"$f":"'5.1.1 Price Table 1-17'!L206","v":0},{"$f":"'5.1.1 Price Table 1-17'!G206","v":0},{"$f":"'5.1.1 Price Table 1-17'!M206","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A208","v":"Table 12"},{"$f":"'5.1.1 Price Table 1-17'!K227","v":0},{"$f":"'5.1.1 Price Table 1-17'!L227","v":0},{"$f":"'5.1.1 Price Table 1-17'!G227","v":0},{"$f":"'5.1.1 Price Table 1-17'!M227","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A229","v":"Table 13"},{"$f":"'5.1.1 Price Table 1-17'!K243","v":0},{"$f":"'5.1.1 Price Table 1-17'!L243","v":0},{"$f":"'5.1.1 Price Table 1-17'!G243","v":0},{"$f":"'5.1.1 Price Table 1-17'!M243","v":0}]
[2,{"$f":"'5.1.1 Price Table 1-17'!A245","v":"Table 14"},{"$f":"'5.1.1 Price Table 1-17'!K259","v":0},{"$f":"'5.1.1 Price Table 1-17'!L259","v":0},{"$f":"'5.1.1 Price Table 1-17'!G259","v":0},{"$f":"'5.1.1 Price Table 1-17'!M259","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A261","v":"Table 15"},{"$f":"'5.1.1 Price Table 1-17'!K274","v":0},{"$f":"'5.1.1 Price Table 1-17'!L274","v":0},{"$f":"'5.1.1 Price Table 1-17'!G274","v":0},{"$f":"'5.1.1 Price Table 1-17'!M274","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A276","v":"Table 16"},{"$f":"'5.1.1 Price Table 1-17'!K289","v":0},{"$f":"'5.1.1 Price Table 1-17'!L289","v":0},{"$f":"'5.1.1 Price Table 1-17'!G289","v":0},{"$f":"'5.1.1 Price Table 1-17'!M289","v":0}]
[null,{"$f":"'5.1.1 Price Table 1-17'!A291","v":"Table 17"},{"$f":"'5.1.1 Price Table 1-17'!K300","v":0},{"$f":"'5.1.1 Price Table 1-17'!L300","v":0},{"$f":"'5.1.1 Price Table 1-17'!G300","v":0},{"$f":"'5.1.1 Price Table 1-17'!M300","v":0}]
[]
[null,"TOTAL PRICE EXCLUDING VAT",{"$f":"SUM(C10:C23)","v":0},{"$f":"SUM(D10:D23)","v":0},{"$f":"SUM(E10:E23)","v":0},{"$f":"SUM(F10:F23)","v":0},"Must agree with Price (Excl. VAT) on RFI Cover Page"]
[null,"SOUTH AFRICAN VAT - ON IMPORTED GOODS",{"$f":"C28*15%","v":0},{"$f":"D28*15%","v":0},{"$f":"E28*15%","v":0},{"$f":"F28*15%","v":0}," "]
[null,"TOTAL PRICES INCLUDING VAT",{"$f":"C28+C29","v":0},{"$f":"D28+D29","v":0},{"$f":"E28+E29","v":0},{"$f":"F28+F29","v":0},"Must agree with Price (Incl. VAT) on RFI Cover Page"]

{"sheet":"5.1.4 PS5","index":5,"n_rows":83,"n_cols":19,"rows_kept":83,"hidden":true,"merged":[[8,1,8,7],[11,1,11,7],[12,1,12,7],[54,1,54,7]]}
["Enquiry No.",null,{"$f":"'RFI Cover Sheet'!C12","v":"E2396NTCSAMWP"}]
["Package Name:",null,{"$f":"'RFI Cover Sheet'!C14","v":"Supply, Delivery, Design, Installation, Commissioning, Support and Training on Environmental Racks with Built-in Air Conditioning, Noise Reduction Solutions, Heat Management Systems and Security Access Control for Substation Environments, on an as and when required basis"}]
["Tenderer's Name:",null,{"$f":"'RFI Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'RFI Cover Sheet'!C18","v":"RFI"}]
[]
["5.1.4. PS 5 "]
[]
["NOTES:"]
[1,"The exchange rates inputted below must be the same as per Worksheet 5.1.6   Exchange Rates."]
[]
[{"$nulls":10},1,2,3,4,5,6,7,8]
["No.","Description",{"$nulls":6}," ",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null," *Eskom may effect this insurance which includes war",{"$nulls":6}," "]
[null,"   risk insurance"]
[null,"**Please specify"]
[null,"SUPPLIED FROM OUTSIDE R.S.A.:",{"$nulls":7},"(In ZAR)"]
[1,"1: F.O.B. PRICE",{"$nulls":7},"(In ZAR)",{"v":1000,"d":"1,000.00"}]
[2,"2: COST OF SEA  FREIGHT",{"$nulls":7},"(In ZAR)"]
[3,"3: COST OF AIR  FREIGHT",{"$nulls":7},"(In ZAR)"]
[4,"4: COST OF MARINE INSURANCES *",{"$nulls":7},"(In ZAR)"]
[5,"5: TOTAL PRICE DELIVERED PORT R.S.A. ...",{"$nulls":5},"(1+2+3+4)",null,"(In ZAR)",{"$f":"SUM(K17:K20)","v":{"v":1000,"d":"1,000.00"}},{"$f":"SUM(L17:L20)","v":0},0,0,0,0,0,0]
[6,"6: WHARFAGE",{"$nulls":7},"(In ZAR)"]
[7,"7: LANDING CHARGES",{"$nulls":7},"(In ZAR)"]
[8,"8: CUSTOMS DUTIES",{"$nulls":7},"(In ZAR)"]
[9,"9: IMPORT SURCHARGE",{"$nulls":7},"(In ZAR)"]
[10,"10: OTHER**",{"$nulls":7},"(In ZAR)"]
[11,"11: COST OF IMPORTATION ...",{"$nulls":5},"(6+7+8+9+10)",null,"(In ZAR)",{"$f":"SUM(K22:K26)","v":0},0,0,0,0,0,0,0]
[12,"12: COST OF RAIL TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[13,"13: COST OF ROAD TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[14,"14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ...",{"$nulls":5},"(12+13)",null,"(In ZAR)",{"$f":"SUM(K28:K29)","v":0},0,0,0,0,0,{"$f":"SUM(Q28:Q29)","v":0},{"$f":"SUM(R28:R29)","v":0}]
[15,"15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE...",{"$nulls":5},"(5+11+14)",null,"(In ZAR)",{"$f":"K21+K27+K30","v":{"v":1000,"d":"1,000.00"}},0,0,0,0,0,{"$f":"Q21+Q27+Q30","v":0},{"$f":"R21+R27+R30","v":0}]
[]
[" ","SUPPLIED FROM INSIDE R.S.A."]
[16,"16: F.O.R. PRICE-GOODS MANUFACTURED INSIDE R.S.A."]
[17,"17: F.O.R. PRICE-GOODS SUPPLIED FROM IMPORTED ITEMS"]
[18,"18: TOTAL F.O.R. PRICE ...",{"$nulls":5},"(16+17)",null,null,{"$f":"SUM(K34:K35)","v":0},0,0,0,0,0,{"$f":"SUM(Q34:Q35)","v":0},{"$f":"SUM(R34:R35)","v":0}]
[19,"19: COST OF RAIL TRANSPORT"]
[20,"20: COST OF ROAD TRANSPORT"]
[21,"21: COST OF TRANSPORT WORKS TO SITE ...          ",{"$nulls":5},"(19+20)",null,null,{"$f":"SUM(K37:K38)","v":0},0,0,0,0,0,{"$f":"SUM(Q37:Q38)","v":0},{"$f":"SUM(R37:R38)","v":0}]
[22,"22: PRICE (F.O.R.) DELIVERED TO SITE ...          ",{"$nulls":5},"(18+21)",null,null,{"$f":"K36+K39","v":0},0,0,0,0,0,{"$f":"Q36+Q39","v":0},{"$f":"R36+R39","v":0}]
[" "," SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) "]
[23,"23: LOCAL LABOUR"]
[24,"24: EXPATRIATE  LABOUR"]
[25,"25: TOTAL PRICE FOR SITE WORK ...          ",{"$nulls":5},"(23+24)",null,null,{"$f":"SUM(K42:K43)","v":0},{"$f":"SUM(L42:L43)","v":0},0,0,0,0,0,0]
[26,"26: OVERSEAS ENGINEERING SERVICES"]
[27,"27: LOCAL ENGINEERING SERVICES"]
[28,"28: TOTAL PRICE FOR ENGINEERING SERVICES...",{"$nulls":5},"(26+27)",null,null,{"$f":"SUM(K45:K46)","v":0},0,0,0,0,0,0,0]
[29,"29: TOTAL PRICE DELIVERED TO SITE (EXCL VAT)",{"$nulls":5},"(15+22+25+28)",null,null," ",{"$f":"L31+L40+L44+L47","v":0},0,0,0,0,0,0]
[30,"30. VAT",{"$nulls":8}," "," "]
[31,"31: TOTAL  PRICE DELIVERED TO SITE (INCLD) VAT",{"$nulls":5},"(29+30)",null,null,{"$f":"SUM(K48:K49)","v":0},0,0,0,0,0,0,0,"Must agree with Price (Including VAT) on Tender Cover Page"]
[null," ",null," ",null,"                "]
[]
[null," "]
[]
[" "," ",{"$nulls":8},1,2,3,4,5,6,7,8]
[null," *Eskom may effect this insurance which includes war",{"$nulls":5}," "," ",null,"DISTRIBUTION CLASS SURGE ARRESTERS FOR 11KV SYSTEMS (INLAND)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 11KV SYSTEMS (COASTAL)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 22KV SYSTEMS (INLAND)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 22KV SYSTEMS (COASTAL)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 33KV SYSTEMS (COASTAL)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 33KV SYSTEMS (COASTAL)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 19KV SWER SYSTEMS (INLAND)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 19KV SWER SYSTEMS (COASTAL)"]
[null,"   risk insurance"]
[null,"**Please specify"]
[null,"PRICE DELIVERED TO PORT R.S.A. (LINE 5)",{"$nulls":6},"(In Foreign Currency)"]
[32,"32: CURRENCY A   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[33,"33: CURRENCY B   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[34,"34: CURRENCY C   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[35,"35: CURRENCY D   1 ZAR=............",null,null,"(FREIGHT)",{"$nulls":3},"(In Foreign Currency)"]
[36,"36: CURRENCY E   1 ZAR=............",null,null,"(INSURANCE)",{"$nulls":3},"(In Foreign Currency)"]
[37,"37: TOTAL F.O.B. PRICE ",{"$nulls":5},"(5=32+33+34+35+36)",null,null,{"$f":"SUM(K60:K64)","v":0},{"$f":"SUM(L60:L64)","v":0},0,0,0,0,0,0]
[null,"PRICE EXPATRIATE LABOUR (LINE 25)",{"$nulls":6},"(In Foreign Currency)"]
[38,"38: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[39,"39: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[40,"40: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[41,"41: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[42,"42: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[43,"43.TOTAL PRICE EXPATRIATE LABOUR ",{"$nulls":5},"(24=38+39+40+41+42)",null,null,{"$f":"SUM(K67:K71)","v":0},0,0,0,0,0,0,0]
[null,"PRICE OVERSEAS ENGINEERING SERVICES (LINE 27)",{"$nulls":6},"(In Foreign Currency)"]
[44,"44: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[45,"45: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[46,"46: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[47,"47: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[48,"48: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[49,"49: TOTAL PRICE OVERSEAS ENGINEERING SERVICES (LINE 26) ",{"$nulls":6},"(26=44+45+46+47+48)",null,{"$f":"SUM(K74:K78)","v":0},0,0,0,0,0,0,0]
[50,"50: FOREIGN CONTENT OF TOTAL PRICE",{"$nulls":5},"(37+43+49)",null,null,{"$f":"K65+K72+K79","v":0},0,0,0,0,0,{"$f":"Q65+Q72+Q79","v":0},0]
[]
[]
[null,"SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................"]

{"sheet":"5.1.4 Exchange Rates","index":6,"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,{"$f":"'RFI Cover Sheet'!C12","v":"E2396NTCSAMWP"}]
["Package Name:",null,{"$f":"'RFI Cover Sheet'!C14","v":"Supply, Delivery, Design, Installation, Commissioning, Support and Training on Environmental Racks with Built-in Air Conditioning, Noise Reduction Solutions, Heat Management Systems and Security Access Control for Substation Environments, on an as and when required basis"}]
["Supplier's Name:",null,{"$f":"'RFI Cover Sheet'!C16","v":0}]
["Category of Offer:",null,"RFI"]
[]
["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"}]