{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Cover Sheet","01-Instructions","02-LFP","03-Labour_Subs_Travel","04-Transport & Off Loading","05-Accessories","06-Training","07-Other Costs","08-LFP Full Range","Option X3","Option X1","Indices","TOTAL PRICE_LFP","Forecasts"],"not_rendered":{"external_links":11,"defined_names":328,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Cover Sheet","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"merged":[[0,0,0,2],[7,0,7,2],[8,0,8,2]]}
["LITHIUM IRON PHOSPHATE BATTERIES PRICING SCHEDULE COVERSHEET"]
[]
[null,"ENQUIRY:","E1272DXWC"]
[null,"COMMODITY:","LITHIUM IRON PHOSPHATE (LFP) BATTERIES"]
[null,"SUPPLIER:"]
[]
[]
["These LFP Battery Enquiry Activity Schedules consists of the following worksheets:"]
["Click on the hyperlinks of the worksheets to access them."]
[null,"Worksheet","Notes"]
[1,"01-Instructions","The purpose of this worksheet is to ensure that all suppliers are quoting for all items in a standard format, on a common basis for ease of evaluation. "]
[2,"02-LFP","Prices for required cells and associated equipment"]
[4,"03-Labour_Subs_Travel","Costs of labour, subsistence and travelling."]
[5,"04-Transport & Off Loading","Transport to site or regional store and off-loading."]
[6,"05-Accessories","Cost of accessories required."]
[7,"06-Training","Training related costs."]
[8,"07-Other Costs","Any other costs to be priced."]
[9,"08-LFP Full Range","Prices for full range of available LP cells and associated equipment"]
[11,"Option X3","Indicate foreign currency to be used in this tender submission."]
[12,"Option X1","Indicate CPA formulae to be used in this tender submission."]
[13,"TOTAL PRICE_LFP","Total prices for Cells, associated equipment and services"]
[15,"Forecasts Table","Estimated forecasted volumes of cells and battery banks"]

{"sheet":"01-Instructions","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"merged":[[2,1,2,2],[4,1,4,2]]}
[]
[]
[null,"INSTRUCTIONS FOR COMPLETING THIS PRICING SCHEDULE"]
[]
[null,"THE PURPOSE OF THIS WORKSHEET IS TO ENSURE THAT ALL SUPPLIERS ARE QUOTING FOR ALL ITEMS IN A STANDARD FORMAT, ON A COMMON BASIS FOR EASE OF EVALUATION"]
[]
[null,null,"GENERAL NOTES"]
[null,1,"The supplier must complete the following sheets:-"]
[null,null," - All 9 Activity schedules"]
[null,null," - Option X3: Rate of Exchange"]
[null,null," - Option X1: Price adjustment for inflation"]
[]
[null,null,"Note 1: If the Activity Schedule is not completed, the tender will be disqualified"]
[null,null,"Note 2: If the CPA Formulae (Option X1) are not updated, the tendered prices will be taken to be \"Firm and Fixed\""]
[null,2,"Manual input is required in all cells highlighted light blue. Other cells are protected."]
[null,3,"Requests for clarification in case of uncertainty, or possible conflicting information, may be lodged in terms of the process for clarifications as stipulated in the Invitation to Tender"]
[null,4,"All information required in this Pricing Schedule must be provided in a clear and unbiased manner.  The Purchaser reserves the right to interpret information as best as possible without recourse thereafter.  An offer may be considered unacceptable if there is missing information or provided in such a manner that an objective assessment is impeded"]
[null,5,"The price schedules provide the basis of all valuations at delivery/assessment dates, payments in multiple currencies, price adjustment (CPA), etc.  Additional items may be added if the pricing schedules is insufficient in this regard but must include all information required as per the stipulated items.  However, this information must not be in conflict with specified requirements or instructions in the pricing schedules or elsewhere in the tender documentation.  It may not be information which will be to the detriment of the Purchaser or benefit the Tenderer unfairly in the evaluation of the bids.  The Purchaser reserves the right to consider such information or ignore it."]
[null,6,"Tenderers are requested to submit a soft copy of the Entire Pricing Schedule"]
[]
[null,null,"NOTES ON COMPLETING THE VARIOUS WORKSHEETS"]
[]
[null,"A","Cover Sheet: "]
[null,null,"Input Tendering Company into cell C5"]
[null,null,"No other input is required - the pricing information reads from the various Activity Schedules"]
[null,"B","Activity Schedules: \"Act Sch-...\""]
[null,null,"Prices can be filled in South African Rands or Foreign currency; choose the applicable currency from the drop down list."]
[null,null,"Insert the applicable price (in the applicable currency). The price will be converted into Rands based on the exchange rate you input into the tab called \"Option X 3\". NB: The applicable Forex rate is to be sourced from the SA Reserve Bank's website as at 12H00 on the date of the advertisement of the tender."]
[null,"C","Option X 3: Multiple Currency"]
[null,null,"For each currency used in this submission, Tenderers must update a Forex conversion rate, ie currency 1 = how many ZAR"]
[null,null,"The tenderer shall use the exchange rate as at 12H00 on the date of the advertisement of the tender. The source of the exchange rates shall be the South African Reserve Bank (www.resbank.co.za). Please note that the tenderer is required to submit proof of the SARB rate/s used.\n"]
[null,"D","Option X 1: Cost Price Adjustments"]
[null,null,"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%.   "]
[null,null,"Formulae must be linked to independent cost indices or other benchmarks (\"reference prices\") and must be clearly and completely defined. The source must be a recognised and independent statistical publishing organisation.  The Tenderers' in-house indices may not be used."]
[null,null,"The Tenderer must submit 5 years' of month by month historical data for all indices used if the complete website/internet address is not provided or this information is not readily available.  The Tenderer must ensure that indices are published and recommended by the source thereof as applicable to the work involved and that they are still in force/use and applicable at the date of submission of the tender. "]
[null,null,"CPA Base Date: The CPA base date for calculating price movements will be the Month before Tender closes. For indices or reference prices published as at certain dates, and where such a date is not the Base Date, the latest date for which it is published before the Base Date will be considered as the Base Date index or reference price.  In instances where the figure or value is not as at the Base Date or considered as the Base Date Index or reference price as explained herein, the date, figure or value as well as the reason for the deviation must be clearly separately stated and must be realistic for purposes of CPA.  "]
[null,null,"Eskom requires that the first 12 months of the contract may not have CPA attributed to the prices. CPA can then only be applied after the first 12 months. Exchange rate adjustments cannot be part of any CPA formula. Foreign Indices must be applied only for imported items. Local indices must be applied for local cost drivers."]
[null,"E","Estimated Volumes"]
[null,null,"Estimated volumes of battery banks and cells are provided; these volumes are not guaranteed, but merely estimated."]

{"sheet":"02-LFP","index":2,"n_rows":22,"n_cols":104,"rows_kept":22,"merged":[[0,0,0,7],[2,0,2,1],[2,2,2,7],[3,0,3,1],[3,2,3,7],[4,0,4,1],[4,2,4,7],[6,0,6,34],[7,0,7,27],[11,0,14,0],[11,1,14,1],[11,2,14,2],[11,3,14,3],[11,4,14,4],[11,5,11,15],[11,16,11,26],[11,27,11,37],[11,38,11,48],[11,49,11,59],[11,60,11,70],[11,71,11,81],[11,82,11,92],[11,93,11,103],[12,15,14,15],[12,26,14,26],[12,37,14,37],[12,48,14,48],[12,59,14,59],[12,70,14,70],[12,81,14,81],[12,92,14,92],[12,103,14,103],[13,5,14,5],[13,6,13,7],[13,8,13,11],[13,12,13,14],[13,16,14,16],[13,17,13,18],[13,19,13,22],[13,23,13,25],[13,27,14,27],[13,28,13,29],[13,30,13,33],[13,34,13,36],[13,38,14,38],[13,39,13,40],[13,41,13,44],[13,45,13,47],[13,49,14,49],[13,50,13,51],[13,52,13,55],[13,56,13,58],[13,60,14,60],[13,61,13,62],[13,63,13,66],[13,67,13,69],[13,71,14,71],[13,72,13,73],[13,74,13,77],[13,78,13,80],[13,82,14,82],[13,83,13,84],[13,85,13,88],[13,89,13,91],[13,93,14,93],[13,94,13,95],[13,96,13,99],[13,100,13,102]]}
["Offered LFP Cells/Batteries"]
[]
["ENQUIRY NO:",null,{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
["COMMODITY:",null,{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
["SUPPLIER:",null,{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
[]
["The prices for individual cells include a cell/battery label (number), inter-cell/battery connectors, bolts, nuts, washers, spring washers and corrosion protection.."]
["Linking sets will include interrow connectors, terminating cables and associated accessories."]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103]
[{"$nulls":9},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD"]
["Item #","Required Capacity [kWh]","Offered Capacity [kWh]","Model No.","Wet Weight/unit [kg]","Systems / Module/s",{"$nulls":10},"30V Linking Sets (Not Applicable)",{"$nulls":10},"48V Linking Sets (Not Applicable)",{"$nulls":10},"110V Linking Sets (Not Applicable)",{"$nulls":10},"220V Linking Sets (Not Applicable)",{"$nulls":10},"30V Battery Cabinet (Not Applicable)",{"$nulls":10},"48V Battery Cabinet",{"$nulls":10},"110V Battery Cabinet",{"$nulls":10},"220V Battery Cabinet"]
[{"$nulls":5},"(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula"]
[{"$nulls":5},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency"]
[{"$nulls":6},"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&J11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&U11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&AF11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&AQ11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&BB11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&BM11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&BX11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&CI11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&CT11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)"]
[1,"48V, LFP System, E = 3kWh",{"$nulls":3},{"$f":"Forecasts!N4","v":1},null,{"$f":"F16*G16","v":0},null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"F16*I16","v":0},{"$f":"J16*K16","v":0},{"$f":"H16+L16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*M16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(M16:N16)","v":{"v":0,"d":"R 0.00"}},null,0,null,{"$f":"Q16*R16","v":0},null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"Q16*T16","v":0},{"$f":"U16*V16","v":0},{"$f":"S16+W16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*X16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(X16:Y16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"F16","v":1},null,{"$f":"AB16*AC16","v":0},0,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AB16*AE16","v":0},{"$f":"AF16*AG16","v":0},{"$f":"AD16+AH16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*AI16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(AI16:AJ16)","v":{"v":0,"d":"R 0.00"}},null,0,null,{"$f":"AM16*AN16","v":0},0,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AM16*AP16","v":0},{"$f":"AQ16*AR16","v":0},{"$f":"AO16+AS16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*AT16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(AT16:AU16)","v":{"v":0,"d":"R 0.00"}},null,0,null,{"$f":"AX16*AY16","v":0},null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AX16*BA16","v":0},{"$f":"BB16*BC16","v":0},{"$f":"AZ16+BD16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*BE16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(BE16:BF16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"Q16","v":0},null,{"$f":"BI16*BJ16","v":0},null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"BI16*BL16","v":0},{"$f":"BM16*BN16","v":0},{"$f":"BK16+BO16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*BP16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(BP16:BQ16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AB16","v":1},null,{"$f":"BT16*BU16","v":0},null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"BT16*BW16","v":0},{"$f":"BX16*BY16","v":0},{"$f":"BV16+BZ16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CA16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CA16:CB16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AM16","v":0},null,{"$f":"CE16*CF16","v":0},null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"CE16*CH16","v":0},{"$f":"CI16*CJ16","v":0},{"$f":"CG16+CK16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CL16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CL16:CM16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AX16","v":0},null,{"$f":"CP16*CQ16","v":0},null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"CP16*CS16","v":0},{"$f":"CT16*CU16","v":0},{"$f":"CR16+CV16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CW16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CW16:CX16)","v":{"v":0,"d":"R 0.00"}}]
[2,"48V, LFP System, E = 5kWh",{"$nulls":3},{"$f":"Forecasts!N5","v":1},null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,{"$f":"F17","v":1},null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,{"$f":"AB17","v":1},null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[3,"48V, LFP System, E = 10kWh",{"$nulls":3},{"$f":"Forecasts!N6","v":460},null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,460,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,460,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[4,"48V, LFP System, E = 15kWh",{"$nulls":3},{"$f":"Forecasts!N7","v":48},null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,48,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,48,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,0,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[]
["Notes:"]
["The estimated quantities for cells and number of battery banks are imported from the Forecast worksheet."]

{"sheet":"03-Labour_Subs_Travel","index":3,"n_rows":49,"n_cols":10,"rows_kept":49,"merged":[[0,0,0,5],[2,0,2,2],[2,3,2,6],[3,0,3,2],[3,3,3,6],[4,0,4,2],[5,0,5,2],[5,3,5,5],[6,0,6,2],[6,3,6,5],[7,0,7,2],[7,3,7,5],[16,4,16,7],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,3,31,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[36,0,36,7],[36,8,36,9],[37,0,38,0],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,6,38,6],[37,7,38,7],[37,8,38,8],[37,9,38,9]]}
["COSTS FOR LABOUR, SUBSISTENCE AND TRAVELLING"]
[]
[{"$nulls":3},"Prices in South African Currency (Excluding VAT)"]
[{"$nulls":3},"Activities shall be quoted as PER UNIT and as being at the same site at the same time"]
[]
["ENQUIRY NO",null,null,{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
["COMMODITY",null,null,{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
["SUPPLIER",null,null,{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
[]
["Notes:"]
["Decommissioning - the removal of wet charged cells (and associated stand/cabinet where applicable) and disposal in line with Eskom procedures."]
["Installation - the construction, placing of the battery stand/cabinet, packing and linking of cells. "]
["Commissioning - the connection of the battery to the charger and ensuring that the charger settings are correct for the battery. The relevant documentation shall be supplied to Eskom."]
["The tenderer shall indicate the maximum Ah for the Small - Medium Ah range in Column C for Item 1. These values will be copied to the other cells automatically."]
["Minimum discharge duration to be quoted on shall be 5 hours."]
[]
[{"$nulls":4},"Tenderer to indicate the Number of Labour Hours per Battery Bank"]
["Item","Item Description","Capacity Range [kWh]","Bank Voltage [V]","Decommissioning ","Installation","Commissioning without Discharge Test","Commissioning with Discharge Test"]
[]
[1,"Small - Medium kWh",null,12]
[2,"Large kWh",{"$f":"MAX('02-LFP'!C16:C19)","v":0},12]
[3,"Small - Medium kWh",{"$f":"IF(C20=\"\",\"\",C20)","v":""},"24 - 32"]
[4,"Large kWh",{"$f":"IF(C21=\"\",\"\",C21)","v":0},"24 - 32"]
[5,"Small - Medium kWh","",48]
[6,"Large kWh",0,48]
[7,"Small - Medium kWh","",110]
[8,"Large kWh",0,110]
[9,"Small - Medium kWh","",220]
[10,"Large kWh",0,220]
[]
["Item","Item Description","Cost","Comment"]
[]
[11,"Labour Rate",null,"Cost per hour"]
[12,"Subsistence Rate",null,"Cost per Team per Day (8 hrs)"]
[13,"Travelling Rate",null,"Cost per kilometer"]
[]
["Labour Charges",{"$nulls":7},"S&T Costs"]
["Item","Item Description","Capacity Range [Ah]","Bank Voltage [V]","Decommissioning ","Installation","Commissioning without Discharge Test","Commissioning with Discharge Test","S&T without Discharge","S&T with Discharge"]
[]
[1,"Small - Medium Ah",{"$f":"IF(C20=\"\",\"\",C20)","v":""},12,{"$f":"$C$33*E20","v":{"v":0,"d":"R 0.00"}},{"$f":"$C$33*F20","v":{"v":0,"d":"R 0.00"}},{"$f":"$C$33*G20","v":{"v":0,"d":"R 0.00"}},{"v":0,"d":"R 0.00"},{"$f":"ROUNDUP(SUM(E20:G20)/8,0)*$C$34","v":0},{"$f":"ROUNDUP((SUM(E20:F20)+H20)/8,0)*$C$34","v":0}]
[2,"Large Ah",{"$f":"IF(C21=\"\",\"\",C21)","v":0},12,{"$f":"$C$33*E21","v":{"v":0,"d":"R 0.00"}},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"$f":"ROUNDUP(SUM(E21:G21)/8,0)*$C$34","v":0},{"$f":"ROUNDUP((SUM(E21:F21)+H21)/8,0)*$C$34","v":0}]
[3,"Small - Medium Ah",{"$f":"IF(C40=\"\",\"\",C40)","v":""},"24 - 32",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},0,0]
[4,"Large Ah",{"$f":"IF(C41=\"\",\"\",C41)","v":0},"24 - 32",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},0,0]
[5,"Small - Medium Ah","",48,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},0,0]
[6,"Large Ah",0,48,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},0,0]
[7,"Small - Medium Ah","",110,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},0,0]
[8,"Large Ah",0,110,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},0,0]
[9,"Small - Medium Ah","",220,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},0,0]
[10,"Large Ah",0,220,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},0,0]

{"sheet":"04-Transport & Off Loading","index":4,"n_rows":27,"n_cols":13,"rows_kept":27,"merged":[[0,0,0,12],[2,0,2,5],[2,6,2,12],[3,0,3,5],[3,6,3,12],[4,0,4,5],[4,6,4,12],[5,0,8,0],[5,1,8,1],[5,3,5,12],[6,3,6,12],[7,3,7,12],[26,0,26,12]]}
["TRANSPORT AND OFF LOADING COSTS (Applicable to crated orders. Small items shall be couriered at the cheapest cost)"]
["Transport Costs on the same order, going to the same location shall be optimised and NOT treated as individual consignments."]
[" ENQUIRY NO",{"$nulls":5},{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
["COMMODITY",{"$nulls":5},{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
["SUPPLIER",{"$nulls":5},{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
["Item","Distance to site [km]",null,"Prices in South African Currency (Excluding VAT)"]
[{"$nulls":3},"Transport to site or regional store and off-loading"]
[{"$nulls":3},"Total Mass [kg]"]
[{"$nulls":3},"0-1000","1001 - 2000","2001 - 3000","3001 - 4000","4001 - 6000","6001 - 8000","8001 - 10000","10001 - 14000","14001 - 18000","18000 +"]
[{"$nulls":3},1000,2000,3000,4000,6000,8000,10000,14000,18000,22000]
[1,"0 - 100",100]
[2,"101 - 200",200]
[3,"201 - 300",300]
[4,"301 - 400",400]
[5,"401 - 500",500]
[6,"501 - 600",600]
[7,"601 - 700",700]
[8,"701 - 800",800]
[9,"801 - 900",900]
[10,"901 - 1000",1000]
[11,"1001 - 1100",1100]
[12,"1101 - 1200",1200]
[13,"1201 - 1300",1300]
[14,"1301 - 1400",1400]
[15,"1401 - 1500",1500]
[null,null,1,2,3,4,5,6,7,8,9,10,11]
["COMMENTS:"]

{"sheet":"05-Accessories","index":5,"n_rows":27,"n_cols":5,"rows_kept":27,"merged":[[1,0,1,2],[1,3,1,4],[2,0,2,2],[2,3,2,4],[3,0,3,2],[3,3,3,4],[5,0,5,4],[24,1,24,4],[25,1,25,4],[26,1,26,4]]}
[]
["ENQUIRY NO",null,null,{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
["COMMODITY",null,null,{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
["SUPPLIER",null,null,{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
[]
["List of Accessories (All amounts in ZAR excluding VAT.)"]
["Item","SAP Number","Short Description","Price","Comments"]
[1,"TBA","Battery inspection logbook"]
[2,"TBA","Battery cabinet identification label"]
[3,"TBA","Battery cabinet safety sign"]
[4,"TBA","Non-intrusive (laser) thermometer"]
[5,"TBA","Faceshield (rated for working energy level)"]
[6,"TBA","Gloves (rated for working energy level)"]
[7,"TBA","Overall (rated for working energy level)"]
[8,"TBA","Maintenance tools kit"]
[9,"TBA","Safety File"]
[10,"TBA"]
[11,"TBA"]
[12,"TBA"]
[13,"TBA"]
[14,"TBA"]
[15,"TBA"]
[]
[null,"Notes:"]
[null,"1) Shall comply with 240-118705836, Maintenance of Batteries."]
[null,"2) Shall comply with 240-56362221, Standard for safety signs used in DC applications"]
[null,"3) Shall comply with 240-44175132, Eskom Personal Protective Equipment (PPE)"]

{"sheet":"06-Training","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[1,0,1,5],[3,0,3,5],[5,0,5,1],[5,2,5,5],[6,0,6,1],[6,2,6,5],[7,0,7,1],[7,2,7,5],[11,0,11,5],[13,0,13,5]]}
[]
["TRAINING"]
[]
["Prices in South African Currency (Excluding VAT)"]
[]
[" ENQUIRY NO",null,{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
["COMMODITY",null,{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
["SUPPLIER",null,{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
["Item","Options","Cost / Session / Student","Min no. of students","Max no. of students","Duration [days]"]
[1,"At Eskom Premises"]
[2,"At Suppliers Works"]
["NOTE: The supplier shall ensure that all training material and equipment are available."]
[]
["COMMENTS:"]

{"sheet":"07-Other Costs","index":7,"n_rows":7,"n_cols":3,"rows_kept":7,"merged":[[4,1,4,2]]}
[]
[null," ENQUIRY NO",{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
[null,"COMMODITY",{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
[null,"SUPPLIER",{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
[null,"The supplier shall state the terms and conditions related to other costs that were not explicitly stated (requested) as part of the enquiry. These could include costs related to storage on behalf of Eskom where the site is not yet ready; cancellation fees - where an order was placed and needs to be amended / changed for other equipment, etc."]
[]
[null,"Item","Proposal with terms and conditions"]

{"sheet":"08-LFP Full Range","index":8,"n_rows":58,"n_cols":104,"rows_kept":58,"merged":[[0,0,0,7],[2,0,2,1],[2,2,2,7],[3,0,3,1],[3,2,3,7],[4,0,4,1],[4,2,4,7],[6,0,6,34],[7,0,7,27],[11,0,14,0],[11,1,14,1],[11,2,14,2],[11,3,14,3],[11,4,14,4],[11,5,11,15],[11,16,11,26],[11,27,11,37],[11,38,11,48],[11,49,11,59],[11,60,11,70],[11,71,11,81],[11,82,11,92],[11,93,11,103],[12,15,14,15],[12,26,14,26],[12,37,14,37],[12,48,14,48],[12,59,14,59],[12,70,14,70],[12,81,14,81],[12,92,14,92],[12,103,14,103],[13,5,14,5],[13,6,13,7],[13,8,13,11],[13,12,13,14],[13,16,14,16],[13,17,13,18],[13,19,13,22],[13,23,13,25],[13,27,14,27],[13,28,13,29],[13,30,13,33],[13,34,13,36],[13,38,14,38],[13,39,13,40],[13,41,13,44],[13,45,13,47],[13,49,14,49],[13,50,13,51],[13,52,13,55],[13,56,13,58],[13,60,14,60],[13,61,13,62],[13,63,13,66],[13,67,13,69],[13,71,14,71],[13,72,13,73],[13,74,13,77],[13,78,13,80],[13,82,14,82],[13,83,13,84],[13,85,13,88],[13,89,13,91],[13,93,14,93],[13,94,13,95],[13,96,13,99],[13,100,13,102],[15,1,57,1]]}
[{"$f":"'02-LFP'!A1","v":"Offered LFP Cells/Batteries"}]
[]
["ENQUIRY NO:",null,{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
["COMMODITY:",null,{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
["SUPPLIER:",null,{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
[]
["The prices for individual cells include a cell label (number), inter-cell connectors, bolts, nuts, washers, spring washers, corrosion protection and electrolyte."]
["Linking sets will include interrow connectors, terminating cables and associated accessories."]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103]
[{"$nulls":9},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD",{"$nulls":10},"USD"]
["Item #","Required Capacity [kWh]","Offered Capacity [kWh]","Model No.","Wet Weight/unit [kg]","Battery Systems / Module/s",{"$nulls":10},"30V Linking Sets",{"$nulls":10},"48V Linking Sets",{"$nulls":10},"110V Linking Sets",{"$nulls":10},"220V Linking Sets",{"$nulls":10},"30V Battery Cabinet",{"$nulls":10},"48V Battery Cabinet",{"$nulls":10},"110V Battery Cabinet",{"$nulls":10},"220V Battery Cabinet"]
[{"$nulls":5},"(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula","(1)","(2)","(3)=(1)x(2)","(4)","(5)","(6)=(1)x(4)","(7)=(5)x(6)","(8)=(3)+(7)","(9)=0.15x(8)","(10)=(8)+(9)","CPA Formula"]
[{"$nulls":5},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency",{"$nulls":3},"Estimated Qty","Local Currency",null,"Foreign Currency",{"$nulls":3},"Local + Foreign Currency"]
[{"$nulls":6},"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&J11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&U11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&AF11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&AQ11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&BB11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&BM11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&BX11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&CI11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)",null,null,"Rate/unit (ZAR)","Local Portion (ZAR)","Rate/unit (Foreign)","ROE",{"$f":"\"Foreign Portion (\"&CT11&\")\"","v":"Foreign Portion (USD)"},"Foreign Portion (ZAR)","Total Price  excl. VAT (ZAR)","VAT (ZAR)","Total Price  incl. VAT (ZAR)"]
[1,"Not Applicable Not Applicable",{"$nulls":3},1,null,{"$f":"F16*G16","v":0},null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"F16*I16","v":0},{"$f":"J16*K16","v":0},{"$f":"H16+L16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*M16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(M16:N16)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"Q16*R16","v":0},null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"Q16*T16","v":0},{"$f":"U16*V16","v":0},{"$f":"S16+W16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*X16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(X16:Y16)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AB16*AC16","v":0},null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AB16*AE16","v":0},{"$f":"AF16*AG16","v":0},{"$f":"AD16+AH16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*AI16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(AI16:AJ16)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AM16*AN16","v":0},null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AM16*AP16","v":0},{"$f":"AQ16*AR16","v":0},{"$f":"AO16+AS16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*AT16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(AT16:AU16)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AX16*AY16","v":0},null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AX16*BA16","v":0},{"$f":"BB16*BC16","v":0},{"$f":"AZ16+BD16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*BE16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(BE16:BF16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"Q16","v":1},null,{"$f":"BI16*BJ16","v":0},null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"BI16*BL16","v":0},{"$f":"BM16*BN16","v":0},{"$f":"BK16+BO16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*BP16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(BP16:BQ16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AB16","v":1},null,{"$f":"BT16*BU16","v":0},null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"BT16*BW16","v":0},{"$f":"BX16*BY16","v":0},{"$f":"BV16+BZ16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CA16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CA16:CB16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AM16","v":1},null,{"$f":"CE16*CF16","v":0},null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"CE16*CH16","v":0},{"$f":"CI16*CJ16","v":0},{"$f":"CG16+CK16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CL16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CL16:CM16)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AX16","v":1},null,{"$f":"CP16*CQ16","v":0},null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"CP16*CS16","v":0},{"$f":"CT16*CU16","v":0},{"$f":"CR16+CV16","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CW16","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CW16:CX16)","v":{"v":0,"d":"R 0.00"}}]
[2,{"$nulls":4},1,null,{"$f":"F17*G17","v":0},null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"F17*I17","v":0},{"$f":"J17*K17","v":0},{"$f":"H17+L17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*M17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(M17:N17)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"Q17*R17","v":0},null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"Q17*T17","v":0},{"$f":"U17*V17","v":0},{"$f":"S17+W17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*X17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(X17:Y17)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AB17*AC17","v":0},null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AB17*AE17","v":0},{"$f":"AF17*AG17","v":0},{"$f":"AD17+AH17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*AI17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(AI17:AJ17)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AM17*AN17","v":0},null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AM17*AP17","v":0},{"$f":"AQ17*AR17","v":0},{"$f":"AO17+AS17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*AT17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(AT17:AU17)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AX17*AY17","v":0},null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AX17*BA17","v":0},{"$f":"BB17*BC17","v":0},{"$f":"AZ17+BD17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*BE17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(BE17:BF17)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"Q17","v":1},null,{"$f":"BI17*BJ17","v":0},0,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"BI17*BL17","v":0},{"$f":"BM17*BN17","v":0},{"$f":"BK17+BO17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*BP17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(BP17:BQ17)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AB17","v":1},null,{"$f":"BT17*BU17","v":0},null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"BT17*BW17","v":0},{"$f":"BX17*BY17","v":0},{"$f":"BV17+BZ17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CA17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CA17:CB17)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AM17","v":1},null,{"$f":"CE17*CF17","v":0},null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"CE17*CH17","v":0},{"$f":"CI17*CJ17","v":0},{"$f":"CG17+CK17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CL17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CL17:CM17)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AX17","v":1},null,{"$f":"CP17*CQ17","v":0},null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"CP17*CS17","v":0},{"$f":"CT17*CU17","v":0},{"$f":"CR17+CV17","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CW17","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CW17:CX17)","v":{"v":0,"d":"R 0.00"}}]
[3,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[4,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[5,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[6,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[7,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[8,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[9,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[10,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[11,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[12,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[13,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[14,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[15,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[16,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[17,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[18,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[19,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[20,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[21,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[22,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[23,{"$nulls":4},1,null,{"$f":"F38*G38","v":0},null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"F38*I38","v":0},{"$f":"J38*K38","v":0},{"$f":"H38+L38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*M38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(M38:N38)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"Q38*R38","v":0},null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"Q38*T38","v":0},{"$f":"U38*V38","v":0},{"$f":"S38+W38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*X38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(X38:Y38)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AB38*AC38","v":0},null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AB38*AE38","v":0},{"$f":"AF38*AG38","v":0},{"$f":"AD38+AH38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*AI38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(AI38:AJ38)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AM38*AN38","v":0},null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AM38*AP38","v":0},{"$f":"AQ38*AR38","v":0},{"$f":"AO38+AS38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*AT38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(AT38:AU38)","v":{"v":0,"d":"R 0.00"}},null,1,null,{"$f":"AX38*AY38","v":0},null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"AX38*BA38","v":0},{"$f":"BB38*BC38","v":0},{"$f":"AZ38+BD38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*BE38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(BE38:BF38)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"Q38","v":1},null,{"$f":"BI38*BJ38","v":0},null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"BI38*BL38","v":0},{"$f":"BM38*BN38","v":0},{"$f":"BK38+BO38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*BP38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(BP38:BQ38)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AB38","v":1},null,{"$f":"BT38*BU38","v":0},null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"BT38*BW38","v":0},{"$f":"BX38*BY38","v":0},{"$f":"BV38+BZ38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CA38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CA38:CB38)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AM38","v":1},null,{"$f":"CE38*CF38","v":0},null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"CE38*CH38","v":0},{"$f":"CI38*CJ38","v":0},{"$f":"CG38+CK38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CL38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CL38:CM38)","v":{"v":0,"d":"R 0.00"}},null,{"$f":"AX38","v":1},null,{"$f":"CP38*CQ38","v":0},null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},{"$f":"CP38*CS38","v":0},{"$f":"CT38*CU38","v":0},{"$f":"CR38+CV38","v":{"v":0,"d":"R 0.00"}},{"$f":"0.15*CW38","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(CW38:CX38)","v":{"v":0,"d":"R 0.00"}}]
[24,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[25,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[26,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[27,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[28,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[29,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[30,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[31,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[32,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[33,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[34,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[35,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[36,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[37,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[38,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[39,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[40,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[41,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[42,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[43,{"$nulls":4},1,null,0,null,{"$f":"VLOOKUP(J$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(U$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AF$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(AQ$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BB$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BM$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(BX$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CI$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},null,1,null,0,null,{"$f":"VLOOKUP(CT$11,'Option X3'!$D$6:$E$20,2,0)","v":0},0,0,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]

{"sheet":"Option X3","index":9,"n_rows":21,"n_cols":7,"rows_kept":21,"merged":[[1,1,1,3],[1,4,1,6],[2,1,2,3],[2,4,2,6],[3,1,3,3],[3,4,3,6],[4,1,4,6],[20,1,20,6]]}
[]
[null,{"$f":"[10]Summary!C3","v":"ENQUIRY No"},null,null,{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
[null,{"$f":"[10]Summary!C4","v":"COMMODITY"},null,null,{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
[null,{"$f":"[10]Summary!C5","v":"SUPPLIER"},null,null,{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
[null,"MULTIPLE CURRENCIES - SECONDARY OPTION X3"]
[null,"No","Currency Description","Code","Foreign Exchange Currency 1,00 =","Date Published","Source"]
[null,1,"Austrailian Dollar","AUD"]
[null,{"$f":"B7+1","v":2},"Canadian Dollar","CAD"]
[null,3,"Swiss Franc","CHF"]
[null,4,"Danish Krone","DKK"]
[null,5,"European Currency","EUR"]
[null,6,"British Pound","GBP"]
[null,7,"Hong Kong Dollar","HKD"]
[null,8,"Japanese Yen","JPY"]
[null,9,"Norwegian Krone","NOK"]
[null,10,"New Zealand Dollar","NZD"]
[null,11,"Swedish Krone","SEK"]
[null,12,"Singapore Dollar","SGD"]
[null,{"$f":"+B18+1","v":13},"United States Dollars","USD"]
[null,14,"South African Rand","ZAR",{"v":1,"d":"R 1.000000"}]
[null,"Note:  Above is the list for which Foreign Exchange Cover can be obtained. Should   your tender be in  currency not indicated on this list, kindly contact the Eskom Commercial Department who will liaise with Eskom Treasury for sanction to use that currency."]

{"sheet":"Option X1","index":10,"n_rows":108,"n_cols":15,"rows_kept":108,"merged":[[1,1,1,2],[1,3,1,5],[2,1,2,2],[2,3,2,5],[3,1,3,2],[3,3,3,5],[4,1,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[20,2,26,2],[29,2,35,2],[38,2,44,2],[47,2,53,2],[56,2,62,2],[65,2,71,2],[74,2,80,2],[83,2,89,2],[92,2,98,2],[101,2,107,2]]}
[]
[null,"ENQUIRY No",null,{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"}]
[null,"COMMODITY",null,{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"}]
[null,"SUPPLIER",null,{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""}]
[null,"PRICE ADJUSTMENT FOR INFLATION - SECONDARY OPTION X1"]
[null,"No","Description of Formula"]
[null,"Fixed","Firm and Fixed"]
[null,"01",{"$f":"C21","v":"Description of formula 1"}]
[null,"02",{"$f":"C30","v":"Description of formula 2"}]
[null,"03",{"$f":"C39","v":"Description of formula 3"}]
[null,"04",{"$f":"C48","v":"Description of formula 4"}]
[null,"05",{"$f":"C57","v":"Description of formula 5"}]
[null,"06",{"$f":"C66","v":"Description of formula 6"}]
[null,"07",{"$f":"C75","v":"Description of formula 7"}]
[null,"08",{"$f":"C84","v":"Description of formula 8"}]
[null,"09",{"$f":"C93","v":"Description of formula 9"}]
[null,"010",{"$f":"C102","v":"Description of formula 10"}]
[]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"01","Description of formula 1","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"01",null,"b"]
[null,"01",null,"c"]
[null,"01",null,"d"]
[null,"01",null,"e"]
[null,"01",null,"f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"01",null,null,{"$f":"SUM(E21:E26)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"02","Description of formula 2","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"02",{"$f":"C30","v":"Description of formula 2"},"b"]
[null,"02","Description of formula 2","c"]
[null,"02","Description of formula 2","d"]
[null,"02","Description of formula 2","e"]
[null,"02","Description of formula 2","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"02","Description of formula 2",null,{"$f":"SUM(E30:E35)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"03","Description of formula 3","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"03",{"$f":"C39","v":"Description of formula 3"},"b"]
[null,"03","Description of formula 3","c"]
[null,"03","Description of formula 3","d"]
[null,"03","Description of formula 3","e"]
[null,"03","Description of formula 3","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"03","Description of formula 3",null,{"$f":"SUM(E39:E44)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"04","Description of formula 4","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"04",{"$f":"C48","v":"Description of formula 4"},"b"]
[null,"04","Description of formula 4","c"]
[null,"04","Description of formula 4","d"]
[null,"04","Description of formula 4","e"]
[null,"04","Description of formula 4","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"04","Description of formula 4",null,{"$f":"SUM(E48:E53)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"05","Description of formula 5","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"05",{"$f":"C57","v":"Description of formula 5"},"b"]
[null,"05","Description of formula 5","c"]
[null,"05","Description of formula 5","d"]
[null,"05","Description of formula 5","e"]
[null,"05","Description of formula 5","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"05","Description of formula 5",null,{"$f":"SUM(E57:E62)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"06","Description of formula 6","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"06",{"$f":"C66","v":"Description of formula 6"},"b"]
[null,"06","Description of formula 6","c"]
[null,"06","Description of formula 6","d"]
[null,"06","Description of formula 6","e"]
[null,"06","Description of formula 6","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"06","Description of formula 6",null,{"$f":"SUM(E66:E71)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"07","Description of formula 7","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"07",{"$f":"C75","v":"Description of formula 7"},"b"]
[null,"07","Description of formula 7","c"]
[null,"07","Description of formula 7","d"]
[null,"07","Description of formula 7","e"]
[null,"07","Description of formula 7","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"07","Description of formula 7",null,{"$f":"SUM(E75:E80)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"08","Description of formula 8","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"08",{"$f":"C84","v":"Description of formula 8"},"b"]
[null,"08","Description of formula 8","c"]
[null,"08","Description of formula 8","d"]
[null,"08","Description of formula 8","e"]
[null,"08","Description of formula 8","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"08","Description of formula 8",null,{"$f":"SUM(E84:E89)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,"09","Description of formula 9","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,"09",{"$f":"C93","v":"Description of formula 9"},"b"]
[null,"09","Description of formula 9","c"]
[null,"09","Description of formula 9","d"]
[null,"09","Description of formula 9","e"]
[null,"09","Description of formula 9","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,"09","Description of formula 9",null,{"$f":"SUM(E93:E98)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
[null,"CPA No","Description","Index","Proportion / Coefficient / Weight / Base reference price","Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month if not Base Date as defined ","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[null,{"$f":"B93+1","v":{"v":10,"d":"010"}},"Description of formula 10","a",null,null,"Table of indices","Source of indices","1 Month before tender close","Index in the base month","Currency","N/A","Rate",null,"Provide the website address"]
[null,{"$f":"B102","v":{"v":10,"d":"010"}},"Description of formula 10","b"]
[null,{"v":10,"d":"010"},"Description of formula 10","c"]
[null,{"v":10,"d":"010"},"Description of formula 10","d"]
[null,{"v":10,"d":"010"},"Description of formula 10","e"]
[null,{"v":10,"d":"010"},"Description of formula 10","f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":10,"d":"010"},"Description of formula 10",null,{"$f":"SUM(E102:E107)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]

{"sheet":"Indices","index":11,"n_rows":33,"n_cols":5,"rows_kept":33,"merged":[[10,3,19,3],[10,4,12,4],[12,5,13,5],[13,4,19,4],[14,5,15,5],[15,0,18,0],[16,5,17,5],[18,5,19,5],[20,0,20,4],[21,0,21,4]]}
[{"$f":"'[11]C2.2.0 Cover Page'!A12","v":"OFFER CATEGORY : E.g.  \"MAIN\", or \"ALTERNATIVE 3\", etc."}]
[]
[]
["PRESCRIBED INDICES"]
["Note :"]
["It is important that these indices are considered with the requirements in Spares and Tools and Maintenance and repairs,Training and IP"]
["Please go through the Eskom CPA strategy document attached."]
["LOCAL CPA INDICES","Latest"]
[]
["Labour","Commodities","Processed material","Transport","Others"]
["Labour general ","Steel:","Mechanical Engineering Material","\n\nSEIFSA, L2, road freight costs ","Consumer Price Index\n\nStatsSA, P0141\nTable A – Consumer Price Index: \nMain indices\n\nAll items( CPI Headline)\n(*Variable Name: CPS 00000)\n\n\nOR\n\nSEIFSA\nD Consumer Price Index (CPI)\n"]
["SEIFSA, C3, Actual Labour Costs, Hourly- Paid Employees","  StatsSA P0142.1\nTable 2 - PPI for intermediate manufactured goods\n \nBasic iron and steel\n(*Variable Name: PPD35100).\n","SEIFSA, G, Mechanical Engineering Materials"]
[null,"Copper:","Electrical Engineering Material"]
[null,"SEIFSA,  F, Copper Metric Ton",null,null,"Production Price Index  (PPI)\nStatsSA  P0142.1,  Table A – Key figures\n **Final manufactured goods\n(*Variable Name PPC3000) \nor\n**Intermediate manufactured goods\n(*Variable Name  PPD3000)\nOR\n\nSEIFSA,,  Table U                                                 **Final Manufactured Goods\nor\n**Intermediate  Manufactured Goods\n"]
["Labour general","Aluminium:-","SEIFSA, G, Electrical Engineering Material"]
["\n\n\nSEIFSA, C3 (a), Actual Labour Cost (field force) where subsistence allowance is paid","SEIFSA, R, "]
[null,"Zinc:-","Building and Construction Material"]
[null,"SEIFSA, F, Zinc","SEIFSA, G, Building and Construction Material"]
[null,"Lead:-"]
[null,"\nSEIFSA ,F, Lead"]
["*The Variable Numbers are indicate above for ease of finding the appropriate indices in the web pages of StatsSA’s “Inter Active Data” (e.g. index figures in Excel files)   "]
["**The use of Final or Intermediate Manufactured Goods depends on the nature of the cost component in the CPA formula"]
[]
[]
["FOREIGN CPA INDICES"]
[]
["Labour","Commodities","Processed material","Transport","Others"]
["National Statistical Institute,","MEPS,","National Statistical Institute,","National Statistical Institute,","National Statistical Institute,"]
["Country-specific general labour index","Country-specific general steel index","Country-specific mechanical engineering material","Country-specific general transport cost index","Country-specific CPI (Headline)"]
[null,"LME, Copper","National Statistical Institute,"]
[null,"LME, aluminium","Country-specific electrical engineering material",null,"National Statistical Institute,"]
[null,"LME, zinc","National Statistical Institute,",null,"Country-specific PPI"]
[null,"LME, lead","Country-specific building and construction material"]

{"sheet":"TOTAL PRICE_LFP","index":12,"n_rows":18,"n_cols":15,"rows_kept":18,"merged":[[1,1,1,3],[1,10,1,15],[2,1,2,3],[3,1,3,3],[3,10,3,15],[5,0,5,3],[17,1,17,6]]}
[{"$nulls":5},"Cost","Column #",null,null,"Notes:","1) Custom battery banks qty's standardised to closest standard bank size"]
["ENQUIRY NO",{"$f":"'Cover Sheet'!C3","v":"E1272DXWC"},{"$nulls":3},"Equipment",{"$f":"SUM(C10:E13)","v":0},"1+2+3",null,null,"2) Distance for travelling is assumed to 1000km (roundtrip)"]
["COMMODITY",{"$f":"'Cover Sheet'!C4","v":"LITHIUM IRON PHOSPHATE (LFP) BATTERIES"},{"$nulls":3},"Services without Discharge Test",{"$f":"SUM(F10:L13)","v":0},"4+5+7+8+9+10",null,null,"3) Distance for transport is assumed to 500km (one way)",null,null,500,"km"]
["SUPPLIER",{"$f":"IF('Cover Sheet'!C5=\"\",\"\",'Cover Sheet'!C5)","v":""},{"$nulls":3},"Services with Discharge Test",{"$f":"SUM(F10:K13)+SUM(N10:N13)","v":0},"4+5+7+8+9+12"]
[]
["SUMMARY OF PRICES EXCLUDING VAT"]
[{"$nulls":3},"DRST",null,null,0,{"$f":"G7+13","v":13},{"$f":"H7+13","v":26},39,52]
["Column #",null,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Required Capacity [Ah]","Offered Ah","Battery Systems","Linking Sets","Battery Cabinets","Decommissioning","Installation","Commissioning without Discharge","Commissioning with Discharge","Transport","Travelling","Subsistence (Wet Charged) - Commissioning without Discharge Test","Total cost - Commissioning without Discharge Test","Subsistence (Wet Charged) - Commissioning with Discharge Test","Total cost - Commissioning with Discharge Test"]
[{"$f":"'02-LFP'!B16","v":"48V, LFP System, E = 3kWh"},{"$f":"'02-LFP'!C16","v":0},{"$f":"VLOOKUP($A10,LP_Table,12,0)","v":0},{"$f":"SUM(VLOOKUP($A10,LP_Table,23,0),VLOOKUP($A10,LP_Table,34,0),VLOOKUP($A10,LP_Table,45,0),VLOOKUP($A10,LP_Table,56,0))","v":0},{"$f":"SUM(VLOOKUP($A10,LP_Table,67,0),VLOOKUP($A10,LP_Table,78,0),VLOOKUP($A10,LP_Table,89,0),VLOOKUP($A10,LP_Table,100,0))","v":0},{"$f":"IF($B10<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q16*'03-Labour_Subs_Travel'!E42)+('02-LFP'!$AB16*'03-Labour_Subs_Travel'!E$44)+('02-LFP'!$AM16*'03-Labour_Subs_Travel'!E$46)+('02-LFP'!$AX16*'03-Labour_Subs_Travel'!E$48),('02-LFP'!Q16*'03-Labour_Subs_Travel'!E43)+('02-LFP'!$AB16*'03-Labour_Subs_Travel'!E$45)+('02-LFP'!$AM16*'03-Labour_Subs_Travel'!E$47)+('02-LFP'!$AX16*'03-Labour_Subs_Travel'!E$49))","v":0},{"$f":"IF($B10<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q16*'03-Labour_Subs_Travel'!F$42)+('02-LFP'!$AB16*'03-Labour_Subs_Travel'!F$44)+('02-LFP'!$AM16*'03-Labour_Subs_Travel'!F$46)+('02-LFP'!$AX16*'03-Labour_Subs_Travel'!F$48),('02-LFP'!Q16*'03-Labour_Subs_Travel'!F$43)+('02-LFP'!$AB16*'03-Labour_Subs_Travel'!F$45)+('02-LFP'!$AM16*'03-Labour_Subs_Travel'!F$47)+('02-LFP'!$AX16*'03-Labour_Subs_Travel'!F$49))","v":0},{"$f":"IF($B10<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!$Q16*'03-Labour_Subs_Travel'!G$42)+('02-LFP'!$AB16*'03-Labour_Subs_Travel'!G$44)+('02-LFP'!$AM16*'03-Labour_Subs_Travel'!G$46)+('02-LFP'!$AX16*'03-Labour_Subs_Travel'!G$48),('02-LFP'!$Q16*'03-Labour_Subs_Travel'!G$43)+('02-LFP'!$AB16*'03-Labour_Subs_Travel'!G$45)+('02-LFP'!$AM16*'03-Labour_Subs_Travel'!G$47)+('02-LFP'!$AX16*'03-Labour_Subs_Travel'!G$49))","v":0},{"$f":"IF($B10<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!$Q16*'03-Labour_Subs_Travel'!H$42)+('02-LFP'!$AB16*'03-Labour_Subs_Travel'!H$44)+('02-LFP'!$AM16*'03-Labour_Subs_Travel'!H$46)+('02-LFP'!$AX16*'03-Labour_Subs_Travel'!H$48),('02-LFP'!$Q16*'03-Labour_Subs_Travel'!H$43)+('02-LFP'!$AB16*'03-Labour_Subs_Travel'!H$45)+('02-LFP'!$AM16*'03-Labour_Subs_Travel'!H$47)+('02-LFP'!$AX16*'03-Labour_Subs_Travel'!H$49))","v":0},{"$f":"('02-LFP'!Q16*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_30*VLOOKUP($A10,LP_Table,4,0)<1000,1000,Num_30*VLOOKUP($A10,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AB16*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_48*VLOOKUP($A10,LP_Table,4,0)<1000,1000,Num_48*VLOOKUP($A10,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AM16*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_110*VLOOKUP($A10,LP_Table,4,0)<1000,1000,Num_110*VLOOKUP($A10,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AX16*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_220*VLOOKUP($A10,LP_Table,4,0)<1000,1000,Num_220*VLOOKUP($A10,LP_Table,4,0)),WeightRange,1)))","v":0},{"$f":"2*$N$3*'03-Labour_Subs_Travel'!$C$35*('02-LFP'!Q16+'02-LFP'!AB16+'02-LFP'!AM16+'02-LFP'!AX16)","v":0},{"$f":"IF($B10<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q16*'03-Labour_Subs_Travel'!$I$42)+('02-LFP'!AB16*'03-Labour_Subs_Travel'!$I$44)+('02-LFP'!AM16*'03-Labour_Subs_Travel'!$I$46)+('02-LFP'!AX16*'03-Labour_Subs_Travel'!$I$48),('02-LFP'!Q16*'03-Labour_Subs_Travel'!$I$43)+('02-LFP'!AB16*'03-Labour_Subs_Travel'!$I$45)+('02-LFP'!AM16*'03-Labour_Subs_Travel'!$I$47)+('02-LFP'!AX16*'03-Labour_Subs_Travel'!$I$49))","v":0},{"$f":"SUM(C10:L10)","v":0},{"$f":"IF($B10<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q16*'03-Labour_Subs_Travel'!$J$42)+('02-LFP'!AB16*'03-Labour_Subs_Travel'!$J$44)+('02-LFP'!AM16*'03-Labour_Subs_Travel'!$J$46)+('02-LFP'!AX16*'03-Labour_Subs_Travel'!$J$48),('02-LFP'!Q16*'03-Labour_Subs_Travel'!$J$43)+('02-LFP'!AB16*'03-Labour_Subs_Travel'!$J$45)+('02-LFP'!AM16*'03-Labour_Subs_Travel'!$J$47)+('02-LFP'!AX16*'03-Labour_Subs_Travel'!$J$49))","v":0},{"$f":"SUM(C10:K10)+N10","v":0}]
[{"$f":"'02-LFP'!B17","v":"48V, LFP System, E = 5kWh"},{"$f":"'02-LFP'!C17","v":0},0,0,0,{"$f":"IF($B11<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q17*'03-Labour_Subs_Travel'!E43)+('02-LFP'!$AB17*'03-Labour_Subs_Travel'!E$44)+('02-LFP'!$AM17*'03-Labour_Subs_Travel'!E$46)+('02-LFP'!$AX17*'03-Labour_Subs_Travel'!E$48),('02-LFP'!Q17*'03-Labour_Subs_Travel'!E44)+('02-LFP'!$AB17*'03-Labour_Subs_Travel'!E$45)+('02-LFP'!$AM17*'03-Labour_Subs_Travel'!E$47)+('02-LFP'!$AX17*'03-Labour_Subs_Travel'!E$49))","v":0},{"$f":"IF($B11<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q17*'03-Labour_Subs_Travel'!F$42)+('02-LFP'!$AB17*'03-Labour_Subs_Travel'!F$44)+('02-LFP'!$AM17*'03-Labour_Subs_Travel'!F$46)+('02-LFP'!$AX17*'03-Labour_Subs_Travel'!F$48),('02-LFP'!Q17*'03-Labour_Subs_Travel'!F$43)+('02-LFP'!$AB17*'03-Labour_Subs_Travel'!F$45)+('02-LFP'!$AM17*'03-Labour_Subs_Travel'!F$47)+('02-LFP'!$AX17*'03-Labour_Subs_Travel'!F$49))","v":0},{"$f":"IF($B11<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!$Q17*'03-Labour_Subs_Travel'!G$42)+('02-LFP'!$AB17*'03-Labour_Subs_Travel'!G$44)+('02-LFP'!$AM17*'03-Labour_Subs_Travel'!G$46)+('02-LFP'!$AX17*'03-Labour_Subs_Travel'!G$48),('02-LFP'!$Q17*'03-Labour_Subs_Travel'!G$43)+('02-LFP'!$AB17*'03-Labour_Subs_Travel'!G$45)+('02-LFP'!$AM17*'03-Labour_Subs_Travel'!G$47)+('02-LFP'!$AX17*'03-Labour_Subs_Travel'!G$49))","v":0},{"$f":"IF($B11<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!$Q17*'03-Labour_Subs_Travel'!H$42)+('02-LFP'!$AB17*'03-Labour_Subs_Travel'!H$44)+('02-LFP'!$AM17*'03-Labour_Subs_Travel'!H$46)+('02-LFP'!$AX17*'03-Labour_Subs_Travel'!H$48),('02-LFP'!$Q17*'03-Labour_Subs_Travel'!H$43)+('02-LFP'!$AB17*'03-Labour_Subs_Travel'!H$45)+('02-LFP'!$AM17*'03-Labour_Subs_Travel'!H$47)+('02-LFP'!$AX17*'03-Labour_Subs_Travel'!H$49))","v":0},{"$f":"('02-LFP'!Q17*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_30*VLOOKUP($A11,LP_Table,4,0)<1000,1000,Num_48*VLOOKUP($A11,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AB17*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_48*VLOOKUP($A11,LP_Table,4,0)<1000,1000,Num_48*VLOOKUP($A11,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AM17*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_110*VLOOKUP($A11,LP_Table,4,0)<1000,1000,Num_110*VLOOKUP($A11,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AX17*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_220*VLOOKUP($A11,LP_Table,4,0)<1000,1000,Num_220*VLOOKUP($A11,LP_Table,4,0)),WeightRange,1)))","v":0},{"$f":"2*$N$3*'03-Labour_Subs_Travel'!$C$35*('02-LFP'!Q17+'02-LFP'!AB17+'02-LFP'!AM17+'02-LFP'!AX17)","v":0},{"$f":"IF($B11<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q17*'03-Labour_Subs_Travel'!$I$42)+('02-LFP'!AB17*'03-Labour_Subs_Travel'!$I$44)+('02-LFP'!AM17*'03-Labour_Subs_Travel'!$I$46)+('02-LFP'!AX17*'03-Labour_Subs_Travel'!$I$48),('02-LFP'!Q17*'03-Labour_Subs_Travel'!$I$43)+('02-LFP'!AB17*'03-Labour_Subs_Travel'!$I$45)+('02-LFP'!AM17*'03-Labour_Subs_Travel'!$I$47)+('02-LFP'!AX17*'03-Labour_Subs_Travel'!$I$49))","v":0},0,{"$f":"IF($B11<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!AB17*'03-Labour_Subs_Travel'!$J$44)+('02-LFP'!AM17*'03-Labour_Subs_Travel'!$J$46)+('02-LFP'!AX17*'03-Labour_Subs_Travel'!$J$48),('02-LFP'!AB17*'03-Labour_Subs_Travel'!$J$45)+('02-LFP'!AM17*'03-Labour_Subs_Travel'!$J$47)+('02-LFP'!AX17*'03-Labour_Subs_Travel'!$J$49))","v":0},0]
[{"$f":"'02-LFP'!B18","v":"48V, LFP System, E = 10kWh"},{"$f":"'02-LFP'!C18","v":0},0,0,0,{"$f":"IF($B12<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q18*'03-Labour_Subs_Travel'!E44)+('02-LFP'!$AB18*'03-Labour_Subs_Travel'!E$44)+('02-LFP'!$AM18*'03-Labour_Subs_Travel'!E$46)+('02-LFP'!$AX18*'03-Labour_Subs_Travel'!E$48),('02-LFP'!Q18*'03-Labour_Subs_Travel'!E45)+('02-LFP'!$AB18*'03-Labour_Subs_Travel'!E$45)+('02-LFP'!$AM18*'03-Labour_Subs_Travel'!E$47)+('02-LFP'!$AX18*'03-Labour_Subs_Travel'!E$49))","v":0},{"$f":"IF($B12<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q18*'03-Labour_Subs_Travel'!F$42)+('02-LFP'!$AB18*'03-Labour_Subs_Travel'!F$44)+('02-LFP'!$AM18*'03-Labour_Subs_Travel'!F$46)+('02-LFP'!$AX18*'03-Labour_Subs_Travel'!F$48),('02-LFP'!Q18*'03-Labour_Subs_Travel'!F$43)+('02-LFP'!$AB18*'03-Labour_Subs_Travel'!F$45)+('02-LFP'!$AM18*'03-Labour_Subs_Travel'!F$47)+('02-LFP'!$AX18*'03-Labour_Subs_Travel'!F$49))","v":0},{"$f":"IF($B12<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!$Q18*'03-Labour_Subs_Travel'!G$42)+('02-LFP'!$AB18*'03-Labour_Subs_Travel'!G$44)+('02-LFP'!$AM18*'03-Labour_Subs_Travel'!G$46)+('02-LFP'!$AX18*'03-Labour_Subs_Travel'!G$48),('02-LFP'!$Q18*'03-Labour_Subs_Travel'!G$43)+('02-LFP'!$AB18*'03-Labour_Subs_Travel'!G$45)+('02-LFP'!$AM18*'03-Labour_Subs_Travel'!G$47)+('02-LFP'!$AX18*'03-Labour_Subs_Travel'!G$49))","v":0},{"$f":"IF($B12<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!$Q18*'03-Labour_Subs_Travel'!H$42)+('02-LFP'!$AB18*'03-Labour_Subs_Travel'!H$44)+('02-LFP'!$AM18*'03-Labour_Subs_Travel'!H$46)+('02-LFP'!$AX18*'03-Labour_Subs_Travel'!H$48),('02-LFP'!$Q18*'03-Labour_Subs_Travel'!H$43)+('02-LFP'!$AB18*'03-Labour_Subs_Travel'!H$45)+('02-LFP'!$AM18*'03-Labour_Subs_Travel'!H$47)+('02-LFP'!$AX18*'03-Labour_Subs_Travel'!H$49))","v":0},{"$f":"('02-LFP'!Q18*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_30*VLOOKUP($A12,LP_Table,4,0)<1000,1000,Num_48*VLOOKUP($A12,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AB18*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_48*VLOOKUP($A12,LP_Table,4,0)<1000,1000,Num_48*VLOOKUP($A12,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AM18*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_110*VLOOKUP($A12,LP_Table,4,0)<1000,1000,Num_110*VLOOKUP($A12,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AX18*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_220*VLOOKUP($A12,LP_Table,4,0)<1000,1000,Num_220*VLOOKUP($A12,LP_Table,4,0)),WeightRange,1)))","v":0},{"$f":"2*$N$3*'03-Labour_Subs_Travel'!$C$35*('02-LFP'!Q18+'02-LFP'!AB18+'02-LFP'!AM18+'02-LFP'!AX18)","v":0},{"$f":"IF($B12<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q18*'03-Labour_Subs_Travel'!$I$42)+('02-LFP'!AB18*'03-Labour_Subs_Travel'!$I$44)+('02-LFP'!AM18*'03-Labour_Subs_Travel'!$I$46)+('02-LFP'!AX18*'03-Labour_Subs_Travel'!$I$48),('02-LFP'!Q18*'03-Labour_Subs_Travel'!$I$43)+('02-LFP'!AB18*'03-Labour_Subs_Travel'!$I$45)+('02-LFP'!AM18*'03-Labour_Subs_Travel'!$I$47)+('02-LFP'!AX18*'03-Labour_Subs_Travel'!$I$49))","v":0},0,{"$f":"IF($B12<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!AB18*'03-Labour_Subs_Travel'!$J$44)+('02-LFP'!AM18*'03-Labour_Subs_Travel'!$J$46)+('02-LFP'!AX18*'03-Labour_Subs_Travel'!$J$48),('02-LFP'!AB18*'03-Labour_Subs_Travel'!$J$45)+('02-LFP'!AM18*'03-Labour_Subs_Travel'!$J$47)+('02-LFP'!AX18*'03-Labour_Subs_Travel'!$J$49))","v":0},0]
[{"$f":"'02-LFP'!B19","v":"48V, LFP System, E = 15kWh"},{"$f":"'02-LFP'!C19","v":0},0,0,0,{"$f":"IF($B13<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q19*'03-Labour_Subs_Travel'!E45)+('02-LFP'!$AB19*'03-Labour_Subs_Travel'!E$44)+('02-LFP'!$AM19*'03-Labour_Subs_Travel'!E$46)+('02-LFP'!$AX19*'03-Labour_Subs_Travel'!E$48),('02-LFP'!Q19*'03-Labour_Subs_Travel'!E46)+('02-LFP'!$AB19*'03-Labour_Subs_Travel'!E$45)+('02-LFP'!$AM19*'03-Labour_Subs_Travel'!E$47)+('02-LFP'!$AX19*'03-Labour_Subs_Travel'!E$49))","v":0},{"$f":"IF($B13<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q19*'03-Labour_Subs_Travel'!F$42)+('02-LFP'!$AB19*'03-Labour_Subs_Travel'!F$44)+('02-LFP'!$AM19*'03-Labour_Subs_Travel'!F$46)+('02-LFP'!$AX19*'03-Labour_Subs_Travel'!F$48),('02-LFP'!Q19*'03-Labour_Subs_Travel'!F$43)+('02-LFP'!$AB19*'03-Labour_Subs_Travel'!F$45)+('02-LFP'!$AM19*'03-Labour_Subs_Travel'!F$47)+('02-LFP'!$AX19*'03-Labour_Subs_Travel'!F$49))","v":0},{"$f":"IF($B13<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!$Q19*'03-Labour_Subs_Travel'!G$42)+('02-LFP'!$AB19*'03-Labour_Subs_Travel'!G$44)+('02-LFP'!$AM19*'03-Labour_Subs_Travel'!G$46)+('02-LFP'!$AX19*'03-Labour_Subs_Travel'!G$48),('02-LFP'!$Q19*'03-Labour_Subs_Travel'!G$43)+('02-LFP'!$AB19*'03-Labour_Subs_Travel'!G$45)+('02-LFP'!$AM19*'03-Labour_Subs_Travel'!G$47)+('02-LFP'!$AX19*'03-Labour_Subs_Travel'!G$49))","v":0},{"$f":"IF($B13<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!$Q19*'03-Labour_Subs_Travel'!H$42)+('02-LFP'!$AB19*'03-Labour_Subs_Travel'!H$44)+('02-LFP'!$AM19*'03-Labour_Subs_Travel'!H$46)+('02-LFP'!$AX19*'03-Labour_Subs_Travel'!H$48),('02-LFP'!$Q19*'03-Labour_Subs_Travel'!H$43)+('02-LFP'!$AB19*'03-Labour_Subs_Travel'!H$45)+('02-LFP'!$AM19*'03-Labour_Subs_Travel'!H$47)+('02-LFP'!$AX19*'03-Labour_Subs_Travel'!H$49))","v":0},{"$f":"('02-LFP'!Q19*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_30*VLOOKUP($A13,LP_Table,4,0)<1000,1000,Num_48*VLOOKUP($A13,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AB19*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_48*VLOOKUP($A13,LP_Table,4,0)<1000,1000,Num_48*VLOOKUP($A13,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AM19*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_110*VLOOKUP($A13,LP_Table,4,0)<1000,1000,Num_110*VLOOKUP($A13,LP_Table,4,0)),WeightRange,1)))+('02-LFP'!AX19*INDEX(TransportTable,MATCH(IF($N$3<100,100,$N$3),Distance,1),MATCH(IF(Num_220*VLOOKUP($A13,LP_Table,4,0)<1000,1000,Num_220*VLOOKUP($A13,LP_Table,4,0)),WeightRange,1)))","v":0},{"$f":"2*$N$3*'03-Labour_Subs_Travel'!$C$35*('02-LFP'!Q19+'02-LFP'!AB19+'02-LFP'!AM19+'02-LFP'!AX19)","v":0},{"$f":"IF($B13<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!Q19*'03-Labour_Subs_Travel'!$I$42)+('02-LFP'!AB19*'03-Labour_Subs_Travel'!$I$44)+('02-LFP'!AM19*'03-Labour_Subs_Travel'!$I$46)+('02-LFP'!AX19*'03-Labour_Subs_Travel'!$I$48),('02-LFP'!Q19*'03-Labour_Subs_Travel'!$I$43)+('02-LFP'!AB19*'03-Labour_Subs_Travel'!$I$45)+('02-LFP'!AM19*'03-Labour_Subs_Travel'!$I$47)+('02-LFP'!AX19*'03-Labour_Subs_Travel'!$I$49))","v":0},0,{"$f":"IF($B13<='03-Labour_Subs_Travel'!$C$20,('02-LFP'!AB19*'03-Labour_Subs_Travel'!$J$44)+('02-LFP'!AM19*'03-Labour_Subs_Travel'!$J$46)+('02-LFP'!AX19*'03-Labour_Subs_Travel'!$J$48),('02-LFP'!AB19*'03-Labour_Subs_Travel'!$J$45)+('02-LFP'!AM19*'03-Labour_Subs_Travel'!$J$47)+('02-LFP'!AX19*'03-Labour_Subs_Travel'!$J$49))","v":0},0]
[null,null,{"$f":"SUM(C10:C13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Decommissioning Costs = Sum of Y=48,110,220 (No. of YV Banks x Hourly Labour Rate x No. of Hours)"]
[null,"Tripper pack will be installed by Eskom"]

{"sheet":"Forecasts","index":13,"n_rows":12,"n_cols":14,"rows_kept":12,"merged":[[0,0,0,12],[1,4,1,12]]}
["DC : Lithium Ion Batteries"]
[{"$nulls":4},"Qty/OU"]
["Item No","Item Description","E Rating [kWh]","SAP Number","ECOU","FSOU","GOU","KZNOU","LOU","MOU","NCOU","NWOU","WCOU","Total"]
[1,{"$f":"\"48V, Lithium Iron Phosphate Module, E = \"&C4&\"kWh\"","v":"48V, Lithium Iron Phosphate Module, E = 3kWh"},3,null,1,0,0,0,0,0,0,0,0,{"$f":"SUM(E4:M4)","v":1}]
[2,{"$f":"\"48V, Lithium Iron Phosphate Module, E = \"&C5&\"kWh\"","v":"48V, Lithium Iron Phosphate Module, E = 5kWh"},5,null,1,0,0,0,0,0,0,0,0,{"$f":"SUM(E5:M5)","v":1}]
[3,"48V, Lithium Iron Phosphate Module, E = 10kWh",10,null,{"$f":"28-2","v":26},0,0,2,200,200,2,0,30,460]
[4,"48V, Lithium Iron Phosphate Module, E = 15kWh",15,null,10,0,0,2,1,0,1,18,16,48]
[]
[1,{"$f":"\"48V, LFP System, E = \"&C9&\"kWh\"","v":"48V, LFP System, E = 3kWh"},3]
[2,{"$f":"\"48V, LFP System, E = \"&C10&\"kWh\"","v":"48V, LFP System, E = 5kWh"},5]
[3,"48V, LFP System, E = 10kWh",10]
[4,"48V, LFP System, E = 15kWh",15]