{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Cover Sheet","Input Notes","5.1.0 Preambles","5.1.1 Summary","5.1.1.1 Summary of Bills","5.1.1.2 Summary Currency & CPA","5.1.1.3 Summary Cost alloc","5.1.1.4 PS5 Data","5.1.2 Pricing Schedule","5.1.3 Rate of Exchange table","5.1.4.0 NOTES Price adj"," 5.1.4.1 CPA Formula"," 5.1.5 LME Notes","Schedule of cost components","SSCC Rates"],"not_rendered":{"images":1,"defined_names":301,"pivot_tables":4},"read":"whole","date_system":"1900"}

{"sheet":"Cover Sheet","index":0,"n_rows":43,"n_cols":2,"rows_kept":43}
{"$rows_empty":14}
["PRICING INFORMATION"]
[]
["INVITATION TO TENDER"]
[]
["ENQUIRY NUMBER ","MPTUT10610PS"]
["FOR"]
["Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "]
[]
[]
[]
["TENDERER’S NAME: "]
[]
[]
[]
["THE PRICE:  IN RAND (excluding VAT) :"]
[]
["RAND VALUE IN WORDS:"]
[]
[]
[]
[]
["DATE :"]
[]
[]
["AUTHORISED SIGNATORY (per note below) :"]
[]
["NAME :"]
[]
["DESIGNATION :"]

{"sheet":"Input Notes","index":1,"n_rows":13,"n_cols":3,"rows_kept":13}
["Notes for assistance with input"]
["Read these notes BEFORE changes are made to sheets in this workbook."]
[]
[null,"This Spreadsheet contains the following sheets"]
[null,"Cover Sheet","This is the cover sheet for Section 5.1"]
[null,"Input notes","This sheet is provided for help only and will not form part of the contract."]
[null,"Preamble","This is a Preamble to Section 5.1"]
[null,"5.1.1 Summary","This is a manual summary sheet. Data from sheet 5.1.2 and 5.1.3 may be used to assist with compilation"]
[null,"5.1.2. Pricing Schedule","This is the main data entry sheet for the Tenderer to complete. DO NOT input below current data point as stipulated in this sheet. Include additional rows above this are with applicable items if required to preserve integrity of \"Data\" range."]
[null,"5.1.3 Rate of Exchange","This sheet is provided for Rate of Exchange which are carried forward to the Pricing Worksheet"]
[null,"5.1.4.0 NOTES for compilation of Price adjustment formulae","This sheet is provided for the Price adjustment formulae which are carried forward to the Pricing Worksheet"]
[null,"5.1.4.2 CPA Formulae","Details of Price adjustment formulae to be completed in detail by the Tenderer with reference to the NOTES"]
[null,"5.1.5 LME","London Metal Exchange information. Tenderer to populate estimated tonnages."]

{"sheet":"5.1.0 Preambles","index":2,"n_rows":19,"n_cols":2,"rows_kept":19}
[{"$f":"'Cover Sheet'!A2","v":0}]
[{"$f":"'Cover Sheet'!A19:B19","v":"ENQUIRY NUMBER "},{"$f":"'Cover Sheet'!B19","v":"MPTUT10610PS"}]
[{"$f":"'Cover Sheet'!A21","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
[{"$f":"'Cover Sheet'!B25","v":0}]
["5.1.0 PREAMBLES"]
[]
["PRICE SCHEDULES "]
[1,"Price schedule provides the basis of all valuations of the work, payments in multiple currencies, price adjustment (CPA) and general progress monitoring. "]
[2,"The amount due at each application for payment date is based on activities and/or milestones completed as measured in terms of the price schedule. The Tenderer provides all necessary information which is required to determine amounts due at each application for payment relative to the activities and/or milestones completed or to be completed."]
[3,"The price schedule work breakdown structure provided by the Tendereris based on the price schedule provided by the Project Manager.  The activities listed by the Project Manager identify the specific items of work which are estimated to be required to achieve Completion. The price schedule work breakdown structure is compiled to the satisfaction of the Project Manager with any additions and/or amendments deemed necessary. "]
[4,"The Tenderers detailed price schedule summates back to the summary of prices and is in sufficient detail to monitor completion of items related to the accepted programme and or milestones in order that payment of completed work may be assessed."]
[5,"The activities on the pricing schedule are integrated with the required rate of exchange and price adjustment information and the forecast rate of payment schedule (FRP)."]
[6,"Clear unique identification of work in multiple currencies is separately identified in the price schedule and for each currency and uniquely associated price adjustment formula. The combination of currencies and or price adjustment formulae in single rows is not permissible. The tenderer clearly identifies rows added to accommodate these requirements."]
[7,"The total of the prices includes for all direct and indirect costs, overheads, profits, on costs, risks, liabilities, obligations, etc. relative to the contract."]
[8,"The Tenderer allows for all necessary costs to complete the works as required in terms of the specifications, scope of work and conditions of contract whether expressly stated or not in the price schedules. The Tenderer provides the Project Manager with any breakdown of prices as may be required for specific items not detailed in the price schedules prior to or after contract award."]
[9,"All values are total values prior to any retention and excludes VAT. Retention is not calculated in the forecast rate of payment schedule (FRP). "]
[10,"Tenderer to check and take responsibility for all descriptions, formulae, and structure of this file."]
[11,"The Tenderer may add rows as required to cater for specific requirements but is to adhere to the basic requirements identified above and to clearly identify the rows added relative to the Project Manager's items. No rows are to be deleted."]
[12,"Ensure clear Indicatation whether offer is main or alternative tender."]

{"sheet":"5.1.1 Summary","index":3,"n_rows":27,"n_cols":7,"rows_kept":27}
[{"$f":"'Cover Sheet'!A2","v":0}]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "},null,{"$f":"'Cover Sheet'!B19","v":"MPTUT10610PS"}]
["TENDERER NAME:",null,{"$f":"'Cover Sheet'!B25","v":0}]
[{"$f":"'5.1.0 Preambles'!A3","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "},{"$nulls":5},"Manual input"]
[]
["SUMMARY OF PRICES",null,null,"All prices in ZAR"]
["Main / Alt","Bill No","Bill Description","Foreign","Local","Prices (P)"]
["Main",1,{"$f":"'5.1.2 Pricing Schedule'!E23","v":"Preliminary and General"},{"$f":"'5.1.2 Pricing Schedule'!P23","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!Q23","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!R23","v":{"v":0,"d":"R 0.00"}}]
["Main",2,{"$f":"'5.1.2 Pricing Schedule'!E34","v":"Storage, Transportation & Delivery"},{"$f":"'5.1.2 Pricing Schedule'!P34","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!Q34","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!R34","v":{"v":0,"d":"R 0.00"}}]
["Main",3,{"$f":"'5.1.2 Pricing Schedule'!E45","v":"Manufacturing"},{"$f":"'5.1.2 Pricing Schedule'!P45","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!Q45","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!R45","v":{"v":0,"d":"R 0.00"}}]
["Main",4,{"$f":"'5.1.2 Pricing Schedule'!E59","v":"Procurement of Materials"},{"$f":"'5.1.2 Pricing Schedule'!P59","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!Q59","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!R59","v":{"v":0,"d":"R 0.00"}}]
["Main",5,{"$f":"'5.1.2 Pricing Schedule'!E87","v":0},{"$f":"'5.1.2 Pricing Schedule'!P87","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!Q87","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!R87","v":{"v":0,"d":"R 0.00"}}]
["Main",6,{"$f":"'5.1.2 Pricing Schedule'!C144","v":0},{"$f":"'5.1.2 Pricing Schedule'!P144","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!Q144","v":{"v":0,"d":"R 0.00"}},{"$f":"'5.1.2 Pricing Schedule'!R144","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$nulls":3},{"$f":"SUM(D8:D14)","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(E8:E14)","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(D15:E15)","v":{"v":0,"d":"R 0.00"}}]
[]
["Summary of Foreign breakdown"]
["Main / Alt","Works","Description","Foreign 'Currency Value"]
[{"$f":"A8","v":"Main"},1,"Preliminary and General",{"$f":"'5.1.2 Pricing Schedule'!L23","v":{"v":0,"d":"0.00"}}]
["Main",2,"Storage, Transportation & Delivery",{"$f":"'5.1.2 Pricing Schedule'!L34","v":{"v":0,"d":"0.00"}}]
["Main",3,"Manufacturing",{"$f":"'5.1.2 Pricing Schedule'!L45","v":{"v":0,"d":"0.00"}}]
[{"$f":"A11","v":"Main"},4,{"$f":"C11","v":"Procurement of Materials"},{"$f":"'5.1.2 Pricing Schedule'!L59","v":{"v":0,"d":"0.00"}}]
[{"$f":"A12","v":"Main"},5,{"$f":"C12","v":0},{"$f":"'5.1.2 Pricing Schedule'!L87","v":{"v":0,"d":"0.00"}}]
[{"$f":"A13","v":"Main"},6,{"$f":"C13","v":0},{"$f":"'5.1.2 Pricing Schedule'!L144","v":{"v":0,"d":"0.00"}}]
[{"$f":"A14","v":0}]
[{"$nulls":3},{"$f":"SUM(D19:D25)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"IF(D26='5.1.3 Rate of Exchange table'!F34,TRUE,FALSE)","v":true}]

{"sheet":"5.1.1.1 Summary of Bills","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"hidden":true}
[{"$nulls":4},"THIS SHEET IS AUTOMATED - CURSER ON TABLE & REFRESH DATA under Data in Menu CHECK THAT DATA RANGE COVERS ALL APPLICABLE INFORMATION IN ACTIVITIES SHEET"]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "}]
["TENDERER NAME:"]
[{"$f":"'5.1.1 Summary'!A4","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
[]
["Summary of Works & Sections"]
[]
["Sum of PRICES (Costs in ZAR)"]
["Bill No","Bill Description","Total"]
[1,"CABLES",{"v":0,"d":"0.00"}]
[2,"CABLE RACKING & EARTHING",{"v":0,"d":"0.00"}]
[3,"AUXILIARY RACKING",{"v":0,"d":"0.00"}]
[4,"MISCELLANEOUS EQUIPMENT & MATERIALS",{"v":0,"d":"0.00"}]
[5,"LIGHTING & SMALL POWER & SECURITY FENCE",{"v":0,"d":"0.00"}]
[6,"EMPLOYER FURNISHED EQUIPMENT",{"v":0,"d":"0.00"}]
[7,"CONTROL AND INSTRUMENTATION",{"v":0,"d":"0.00"}]
[8,"PRELIMINARY & GENERAL",{"v":0,"d":"0.00"}]
["Grand Total",null,{"v":0,"d":"0.00"}]

{"sheet":"5.1.1.2 Summary Currency & CPA","index":5,"n_rows":31,"n_cols":67,"rows_kept":31,"hidden":true}
["THIS SHEET IS AUTOMATED - CURSER ON TABLE & REFRESH DATA under Data in Menu CHECK THAT DATA RANGE COVERS ALL APPLICABLE INFORMATION IN ACTIVITIES SHEET"]
[]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "}]
["TENDERER NAME:"]
[{"$f":"'5.1.1 Summary'!A4","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
[{"$nulls":4},"Payment Certificate No",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Summary of Currencies & CPA Formulae",{"$nulls":3},"Contractor's statement - application for payment",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":4},"Engineer's Certificate Date",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":4},"Proposed Payment dates",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":4},"Proposed Payment month",null,null,{"$f":"H9","v":{"$error":"#REF!"}},{"$f":"I9","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Check for correct currency input into schedules"]
[{"$nulls":7},"Data"]
["Totals in Foreign Currency","Totals in Rands"," Foreign / Local","Currency Code","RoE Currency 1,00 = R","CPA NOs","FORMULA DESCRIPTION","Sum of Jan-2011","Sum of Feb-2011","Sum of Mar-2011","Sum of Apr-2011","Sum of May-2011","Sum of Jun-2011","Sum of Jul-2011","Sum of Aug-2011","Sum of Sep-2011","Sum of Oct-2011","Sum of Nov-2011","Sum of Dec-2011","Sum of Jan-2012","Sum of Feb-2012","Sum of Mar-2012","Sum of Apr-2012","Sum of May-2012","Sum of Jun-2012","Sum of Jul-2012","Sum of Aug-2012","Sum of Sep-2012","Sum of Oct-2012","Sum of Nov-2012","Sum of Dec-2012","Sum of Jan-2013","Sum of Feb-2013","Sum of Mar-2013","Sum of Apr-2013","Sum of May-2013","Sum of Jun-2013","Sum of Jul-2013","Sum of Aug-2013","Sum of Sep-2013","Sum of Oct-2013","Sum of Nov-2013","Sum of Dec-2013","Sum of Jan-2014","Sum of Feb-2014","Sum of Mar-2014","Sum of Apr-2014","Sum of May-2014","Sum of Jun-2014","Sum of Jul-2014","Sum of Aug-2014","Sum of Sep-2014","Sum of Oct-2014","Sum of Nov-2014","Sum of Dec-2014","Sum of Jan-2015","Sum of Feb-2015","Sum of Mar-2015","Sum of Apr-2015","Sum of May-2015","Sum of Jun-2015","Sum of Jul-2015","Sum of Aug-2015","Sum of Sep-2015","Sum of Oct-2015","Sum of Nov-2015","Sum of Dec-2015"]
[{"$f":"B14*E14","v":0},{"$f":"SUM(G14:CK14)","v":{"v":0,"d":"R 0.00"}},"Foreign","AUD",6.882312456985547,1,"Description of formula 1"]
[0,{"v":0,"d":"R 0.00"},null,"GBP",11.4653,1,"Description of formula 1"]
[0,{"v":0,"d":"R 0.00"},"Foreign Total"]
[0,{"v":0,"d":"R 0.00"},"Local","ZAR",1,1,"Description of formula 1"]
[0,{"v":0,"d":"R 0.00"},"Local Total"]
[0,{"v":0,"d":"R 0.00"},"Grand Total"]
[{"$f":"B20*E20","v":0},{"$f":"SUM(G20:CK20)","v":{"v":0,"d":"R 0.00"}}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]
[0,{"v":0,"d":"R 0.00"}]

{"sheet":"5.1.1.3 Summary Cost alloc","index":6,"n_rows":39,"n_cols":65,"rows_kept":39,"hidden":true}
["THIS SHEET IS AUTOMATED - CURSER ON TABLE & REFRESH DATA under Data in Menu CHECK THAT DATA RANGE COVERS ALL APPLICABLE INFORMATION IN ACTIVITIES SHEET"]
["KUSILE POWER STATION"]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "}]
["TENDERER NAME:"]
[{"$f":"'5.1.1 Summary'!A4","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
[]
["Summary of Cost allocation"]
[]
[null,null,"Payment Certificate No",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Contractor's statement - application for payment",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Engineer's Certificate Date",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Proposed Payment dates",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Proposed Payment month",null,null,{"$f":"F12","v":{"$error":"#REF!"}},{"$f":"G12","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$nulls":5},"Data"]
["Total","Bill No","Bill Description","No","Cost allocation ","Sum of Jan-2011","Sum of Feb-2011","Sum of Mar-2011","Sum of Apr-2011","Sum of May-2011","Sum of Jun-2011","Sum of Jul-2011","Sum of Aug-2011","Sum of Sep-2011","Sum of Oct-2011","Sum of Nov-2011","Sum of Dec-2011","Sum of Jan-2012","Sum of Feb-2012","Sum of Mar-2012","Sum of Apr-2012","Sum of May-2012","Sum of Jun-2012","Sum of Jul-2012","Sum of Aug-2012","Sum of Sep-2012","Sum of Oct-2012","Sum of Nov-2012","Sum of Dec-2012","Sum of Jan-2013","Sum of Feb-2013","Sum of Mar-2013","Sum of Apr-2013","Sum of May-2013","Sum of Jun-2013","Sum of Jul-2013","Sum of Aug-2013","Sum of Sep-2013","Sum of Oct-2013","Sum of Nov-2013","Sum of Dec-2013","Sum of Jan-2014","Sum of Feb-2014","Sum of Mar-2014","Sum of Apr-2014","Sum of May-2014","Sum of Jun-2014","Sum of Jul-2014","Sum of Aug-2014","Sum of Sep-2014","Sum of Oct-2014","Sum of Nov-2014","Sum of Dec-2014","Sum of Jan-2015","Sum of Feb-2015","Sum of Mar-2015","Sum of Apr-2015","Sum of May-2015","Sum of Jun-2015","Sum of Jul-2015","Sum of Aug-2015","Sum of Sep-2015","Sum of Oct-2015","Sum of Nov-2015","Sum of Dec-2015"]
[{"$f":"SUM(F17:BZ17)","v":{"v":0,"d":"R 0.00"}},1,"CABLES",10,"Materials"]
[{"$f":"SUM(F18:BZ18)","v":{"v":0,"d":"R 0.00"}},null,null,20,"Transport"]
[{"v":0,"d":"R 0.00"},null,null,30,"Erection, Installation"]
[{"v":0,"d":"R 0.00"},2,"CABLE RACKING & EARTHING",10,"Materials"]
[{"v":0,"d":"R 0.00"},null,null,20,"Transport"]
[{"v":0,"d":"R 0.00"},null,null,30,"Erection, Installation"]
[{"v":0,"d":"R 0.00"},3,"AUXILIARY RACKING",10,"Materials"]
[{"v":0,"d":"R 0.00"},null,null,20,"Transport"]
[{"v":0,"d":"R 0.00"},null,null,30,"Erection, Installation"]
[{"v":0,"d":"R 0.00"},4,"MISCELLANEOUS EQUIPMENT & MATERIALS",10,"Materials"]
[{"v":0,"d":"R 0.00"},null,null,20,"Transport"]
[{"v":0,"d":"R 0.00"},null,null,30,"Erection, Installation"]
[{"v":0,"d":"R 0.00"},5,"LIGHTING & SMALL POWER & SECURITY FENCE",10,"Materials"]
[{"v":0,"d":"R 0.00"},null,null,20,"Transport"]
[{"v":0,"d":"R 0.00"},null,null,30,"Erection, Installation"]
[{"v":0,"d":"R 0.00"},6,"EMPLOYER FURNISHED EQUIPMENT",10,"Materials"]
[{"v":0,"d":"R 0.00"},null,null,20,"Transport"]
[{"v":0,"d":"R 0.00"},null,null,30,"Erection, Installation"]
[{"v":0,"d":"R 0.00"},7,"CONTROL AND INSTRUMENTATION",10,"Materials"]
[{"v":0,"d":"R 0.00"},null,null,20,"Transport"]
[{"v":0,"d":"R 0.00"},null,null,30,"Erection, Installation"]
[{"v":0,"d":"R 0.00"},8,"PRELIMINARY & GENERAL",40,"General"]
[{"v":0,"d":"R 0.00"},"Grand Total"]

{"sheet":"5.1.1.4 PS5 Data","index":7,"n_rows":56,"n_cols":11,"rows_kept":56,"hidden":true}
[]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "}]
["TENDERER NAME:"]
[{"$f":"'5.1.1 Summary'!A4","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
[]
["Summary of PS5 Cost allocations"]
[null,null,"Manual input"]
["PS5 Ref","PS5 Cost Allocation","Totals"]
[1,"Ex Works Price (Overseas)"]
[2,"Inland Transport Cost "]
[4,"Cost of seafreight"]
[5,"Cost of airfreight"]
[6,"Cost of Marine Insurance*"]
[8,"Wharfage"]
[9,"Landing charges"]
[10,"Customs duties"]
[11,"Surcharge"]
[14,"Cost of Rail transport In R.S.A."]
[15,"Cost of Road transport In R.S.A."]
[18,"F.O.R. Price-Goods manufactured Inside R.S.A."]
[19,"F.O.R. Price-Goods supplied from Imported Items"]
[21,"Cost of Rail transport"]
[22,"Cost of Road transport"]
[25,"Local labour"]
[26,"Expatriate labour"]
[28,"Overseas Engineering Service"]
[29,"Local Engineering Service/Design"]
[null,"Total"]
[]
["Details for PS5 Schedule format"]
["THIS TABLE IS AUTOMATED - CURSER ON TABLE & REFRESH DATA under Data in Menu CHECK THAT DATA RANGE COVERS ALL APPLICABLE INFORMATION IN ACTIVITIES SHEET"]
["Sum of PRICES (Costs in ZAR)","Bill No","Bill Description"]
[null,1,2,3,4,5,6,7,8,"(blank)","Grand Total"]
["PS5 Cost Allocation","CABLES","CABLE RACKING & EARTHING","AUXILIARY RACKING","MISCELLANEOUS EQUIPMENT & MATERIALS","LIGHTING & SMALL POWER & SECURITY FENCE","EMPLOYER FURNISHED EQUIPMENT","CONTROL AND INSTRUMENTATION","PRELIMINARY & GENERAL","(blank)"]
["Allocation?",{"v":20000,"d":"20,000.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":20000,"d":"20,000.00"}]
["(blank)"]
["Ex Works Price (Overseas)"]
["Inland Transport Cost "]
["Cost of seafreight"]
["Cost of airfreight"]
["Cost of Marine Insurance*"]
["Wharfage"]
["Landing charges"]
["Customs duties"]
["Surcharge"]
["Cost of Rail transport In R.S.A."]
["Cost of Road transport In R.S.A."]
["F.O.R. Price-Goods manufactured Inside R.S.A."]
["F.O.R. Price-Goods supplied from Imported Items"]
["Cost of Rail transport"]
["Cost of Road transport"]
["Local labour",{"v":40000000,"d":"40,000,000.00"},{"$nulls":8},{"v":40000000,"d":"40,000,000.00"}]
["Expatriate labour"]
["Overseas Engineering Service"]
["Local Engineering Service/Design"]
["Grand Total",{"v":40020000,"d":"40,020,000.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":40020000,"d":"40,020,000.00"}]

{"sheet":"5.1.2 Pricing Schedule","index":8,"n_rows":193,"n_cols":66,"rows_kept":193,"merged":[[18,18,18,22],[192,2,192,6]]}
[{"$f":"'Cover Sheet'!A2","v":0},{"$nulls":8},"Code","RoE Currency 1,00 =ZAR (Date)",null,null,"CPA No","Description"]
[{"$f":"'Cover Sheet'!A19","v":"ENQUIRY NUMBER "},null,null,{"$f":"'Cover Sheet'!A21","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "},{"$nulls":4},{"v":1,"d":"01"},{"$f":"'5.1.3 Rate of Exchange table'!C18","v":"ZAR"},{"v":1,"d":"1.00"},null,null,1,{"$f":"' 5.1.4.1 CPA Formula'!B9","v":0}]
["TENDERER'S NAME:",null,null,{"$f":"'Cover Sheet'!B25","v":0},null,"No","Cost allocation",null,{"v":2,"d":"02"},{"$f":"'5.1.3 Rate of Exchange table'!C19","v":"AUD"},{"v":20,"d":"20.00"},null,null,2,{"$f":"' 5.1.4.1 CPA Formula'!B18","v":0}]
["5.1.2. Activity Schedule",{"$nulls":4},10,"Project Management",null,{"v":3,"d":"03"},{"$f":"'5.1.3 Rate of Exchange table'!C20","v":"GBP"},{"$nulls":3},3,{"$f":"' 5.1.4.1 CPA Formula'!B27","v":0}]
[{"$nulls":5},20,"Design",null,{"v":4,"d":"04"},{"$f":"'5.1.3 Rate of Exchange table'!C21","v":"CAD"},{"$nulls":3},4,{"$f":"' 5.1.4.1 CPA Formula'!B36","v":0}]
["NOTES:",{"$nulls":4},30,"Procurement and Manufacturing",null,{"v":5,"d":"05"},{"$f":"'5.1.3 Rate of Exchange table'!C22","v":"DKK"},{"$nulls":3},5,{"$f":"' 5.1.4.1 CPA Formula'!B45","v":0}]
[1,"The detail activity cashflow is summarised with unique currency and price adjustment identification",{"$nulls":3},40,"Plant and Material - Local",null,{"v":6,"d":"06"},{"$f":"'5.1.3 Rate of Exchange table'!C23","v":"EUR"},{"$nulls":3},6,{"$f":"' 5.1.4.1 CPA Formula'!B54","v":0}]
[null,"and any freight, insurances and importation costs are separately identified",{"$nulls":3},50,"Plant and Material - Foreign",null,{"v":7,"d":"07"},{"$f":"'5.1.3 Rate of Exchange table'!C24","v":"JPY"},{"$nulls":3},7,{"$f":"' 5.1.4.1 CPA Formula'!B63","v":0}]
[{"$nulls":5},60,"Transport - Local",null,{"v":8,"d":"08"},{"$f":"'5.1.3 Rate of Exchange table'!C25","v":"NZD"},{"$nulls":3},8,{"$f":"' 5.1.4.1 CPA Formula'!B72","v":0}]
[2,"The activity items detailed are the minimum required by the Employer. The tenderer provides",{"$nulls":3},70,"Transport - Freight/Sea",null,{"v":9,"d":"09"},{"$f":"'5.1.3 Rate of Exchange table'!C26","v":"NOK"},{"$nulls":3},9,{"$f":"' 5.1.4.1 CPA Formula'!B81","v":0}]
[null,"detailed activity breakdown in accordance with the programme and cashflow requirements in",{"$nulls":3},80,"De-commissioning, Construction, Erection & Installation",null,10,{"$f":"'5.1.3 Rate of Exchange table'!C27","v":"SGD"},{"$nulls":3},10,{"$f":"' 5.1.4.1 CPA Formula'!B90","v":0}]
[null,"terms of the contract",{"$nulls":3},90,"Commissioning and Testing",null,11,{"$f":"'5.1.3 Rate of Exchange table'!C28","v":"SEK"}]
[3,"Tenderer to check and take responsibility for all descriptions, formulae, etc",{"$nulls":3},100,"Codification and Labelling",null,12,{"$f":"'5.1.3 Rate of Exchange table'!C29","v":"CHF"}]
[4,"The Tenderer can add rows as required to cater for specific requirements but is to adhere to the basic requirements identified above.",{"$nulls":3},110,"Training ",null,13,{"$f":"'5.1.3 Rate of Exchange table'!C30","v":"USD"}]
[{"$nulls":5},120,"Drawings and Manuals",null,14]
[5,"Ensure clear Indicatation whether offer is main or alternative tender",{"$nulls":3},130,"Other"]
[6,"Section No. & Level 1 Activity ID relates to and to be priced in conjuction with schedules issued ",{"$nulls":3},140,"P&G's",{"$nulls":11},{"$f":"SUM(S24:S192)","v":0},{"$f":"SUM(T24:T192)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF24:BF192)","v":0},0,0,0,0,0,0,0,0]
[]
[{"$nulls":18},"Certification Date (Date Contractor submits certificate of work done)"]
[{"$nulls":18},"2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01"]
[{"$nulls":13},"CPA Formula\n(See Sheet 5.1.4.1) need 1 per line","CPA Description\n(See Sheet 5.1.4.1)",{"$nulls":6},"All values in this table to be in ZAR",{"$nulls":3},"Payment Date",{"$nulls":3},"All values in this table to be in ZAR",{"$nulls":7},"Payment Date",{"$nulls":3},"All values in this table to be in ZAR"]
["Seq No","Section Number","Section Description","Level 1   Act ID","Level 1 Activity Description","Level 2 Activity","Level 2 Activity Description\n(See Lookup Sheet)","Local / Foreign","No","Currency Code (one per row)","RoE Currency\n1,00 = ZAR","Total Cost in Foreign Currency ","Payment method 1a, 1b or 2","No","FORMULA DESCRIPTION","Cost of Foreign currency (ZAR)","Cost of Local Currency (ZAR)","Total Cost in Local Currency (ZAR)","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01"]
[1,1,null,null,"Preliminary and General",{"$nulls":6},{"$f":"SUM(L24:L33)","v":0},null,null,{"$f":"IF(N23<>\"\",VLOOKUP(N23,$N$1:$O$11,2,FALSE),\"\")","v":""},{"$f":"SUM(P24:P33)","v":0},0,0,{"$f":"SUM(S24:S33)","v":0},0,0,{"$f":"SUM(V24:V33)","v":0},{"$f":"SUM(W24:W33)","v":0},{"$f":"SUM(X24:X33)","v":0},{"$f":"SUM(Y24:Y33)","v":0},{"$f":"SUM(Z24:Z33)","v":0},{"$f":"SUM(AA24:AA33)","v":0},{"$f":"SUM(AB24:AB33)","v":0},{"$f":"SUM(AC24:AC33)","v":0},{"$f":"SUM(AD24:AD33)","v":0},{"$f":"SUM(AE24:AE33)","v":0},{"$f":"SUM(AF24:AF33)","v":0},{"$f":"SUM(AG24:AG33)","v":0},{"$f":"SUM(AH24:AH33)","v":0},{"$f":"SUM(AI24:AI33)","v":0},{"$f":"SUM(AJ24:AJ33)","v":0},{"$f":"SUM(AK24:AK33)","v":0},{"$f":"SUM(AL24:AL33)","v":0},{"$f":"SUM(AM24:AM33)","v":0},{"$f":"SUM(AN24:AN33)","v":0},{"$f":"SUM(AO24:AO33)","v":0},{"$f":"SUM(AP24:AP33)","v":0},{"$f":"SUM(AQ24:AQ33)","v":0},{"$f":"SUM(AR24:AR33)","v":0},{"$f":"SUM(AS24:AS33)","v":0},{"$f":"SUM(AT24:AT33)","v":0},{"$f":"SUM(AU24:AU33)","v":0},{"$f":"SUM(AV24:AV33)","v":0},{"$f":"SUM(AW24:AW33)","v":0},{"$f":"SUM(AX24:AX33)","v":0},{"$f":"SUM(AY24:AY33)","v":0},{"$f":"SUM(AZ24:AZ33)","v":0},{"$f":"SUM(BA24:BA33)","v":0},{"$f":"SUM(BB24:BB33)","v":0},{"$f":"SUM(BC24:BC33)","v":0},{"$f":"SUM(BD24:BD33)","v":0},{"$f":"SUM(BE24:BE33)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"A23+1","v":2},1,"Preliminary and General",101,"The contractor shall compile manufacturing drawings details for all design performed . These are inclusive of, but not necessarily limited to  material layout quantities, cuting list, bending schedule, welding details and requirements where not specified, welding procedure, assembly sequence, installation quality requirements, burner transportation requirements within Tutuka site.",20,{"$f":"IF(F24=\"\",\"Allocation?\",VLOOKUP(F24,$F$3:$G$18,2,FALSE))","v":"Design"},{"$f":"IF(J24=\"ZAR\", \"Local\", \"Foreign\")","v":"Local"},null,{"$f":"IF(I24=\"\",\"ZAR\",VLOOKUP(I24,$I$2:$K$15,2,FALSE))","v":"ZAR"},{"$f":"IF(H24<>\"\",VLOOKUP(J24,$J$1:$K$17,2,FALSE),\"\")","v":{"v":1,"d":"1.00"}},{"$f":"IF(Q24<>\"\",Q24/K24,\"-\")","v":"-"},null,null,{"$f":"IF(N24=\"\",\"Fixed\",VLOOKUP(N24,$N$2:$O$11,2,FALSE))","v":"Fixed"},null,null,{"$f":"+Q24+P24","v":0}]
[{"$f":"A24+1","v":3},1,"Preliminary and General",102,"Fabrication/ manufacturing  drawings",20,"Design","Local",null,{"$f":"IF(I25=\"\",\"ZAR\",VLOOKUP(I25,$I$2:$K$15,2,FALSE))","v":"ZAR"},{"$f":"IF(J25<>\"\",VLOOKUP(J25,$J$1:$K$17,2,FALSE),\"\")","v":1},{"$f":"IF(Q25<>\"\",Q25/K25,\"-\")","v":"-"},null,null,{"$f":"IF(N25=\"\",\"Fixed\",VLOOKUP(N25,$N$2:$O$11,2,FALSE))","v":"Fixed"},null,null,{"$f":"+Q25+P25","v":0}]
[4,1,"Preliminary and General",103,"Project Management during manufacturing",10,"Project Management","Local",null,"ZAR",{"$f":"IF(J26<>\"\",VLOOKUP(J26,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[5,1,null,104,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[6,1,null,105,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[7,1,null,106,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[8,1,null,107,null,null,"Allocation?","Local",null,"ZAR",{"$f":"IF(J30<>\"\",VLOOKUP(J30,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[9,1,null,108,null,null,"Allocation?","Local",null,{"$f":"IF(I31=\"\",\"ZAR\",VLOOKUP(I31,$I$2:$K$15,2,FALSE))","v":"ZAR"},{"$f":"IF(J31<>\"\",VLOOKUP(J31,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[10,1,null,109,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[11,1,"Other",110,"Minimum Contract Skills Development Goal (CSDG) sum = ME (0,25%) x Subtotal of tender amount",130,"Other","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[12,2,null,null,"Storage, Transportation & Delivery",null,null,"Local",null,"ZAR",{"$f":"IF(J34<>\"\",VLOOKUP(J34,$J$1:$K$17,2,FALSE),\"\")","v":{"v":1,"d":"1.00"}},{"$f":"SUM(L35:L44)","v":0},null,null,"Fixed",{"$f":"SUM(P35:P44)","v":0},0,0,{"$f":"SUM(S35:S44)","v":0},{"$f":"SUM(T35:T44)","v":0},{"$f":"SUM(U35:U44)","v":0},{"$f":"SUM(V35:V44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF35:BF44)","v":0},0,0,0,0,0,0,0,0]
[13,2,"Storage, Transportation & Delivery",201,"Burner packaging (Inc. Burner support)",10,{"$f":"IF(F35=\"\",\"Allocation?\",VLOOKUP(F35,$F$3:$G$18,2,FALSE))","v":"Project Management"},"Local",null,"ZAR",{"$f":"IF(J35<>\"\",VLOOKUP(J35,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[14,2,"Storage, Transportation & Delivery",202,"Storage prior to delivery to site",60,"Transport - Local","Local",null,"ZAR",{"$f":"IF(J36<>\"\",VLOOKUP(J36,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[15,2,"Storage, Transportation & Delivery",203,"Delivery to site",60,"Transport - Local","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[16,2,"Storage, Transportation & Delivery",204,"Factory acceptance test",90,"Commissioning and Testing","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[17,2,"Storage, Transportation & Delivery",205,"Site acceptance test",90,"Commissioning and Testing","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[18,2,null,206,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[19,2,null,207,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[20,2,null,208,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[21,2,null,209,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[22,2,null,210,null,null,{"$f":"IF(F44=\"\",\"Allocation?\",VLOOKUP(F44,$F$3:$G$18,2,FALSE))","v":"Allocation?"},"Local",null,"ZAR",{"$f":"IF(J44<>\"\",VLOOKUP(J44,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[23,3,null,null,"Manufacturing",null,null,"Local",null,"ZAR",null,{"$f":"SUM(L46:L55)","v":0},null,null,"Fixed",{"$f":"SUM(P46:P58)","v":0},0,0,{"$f":"SUM(S46:S58)","v":0},{"$f":"SUM(T46:T55)","v":0},{"$f":"SUM(U46:U58)","v":0},{"$f":"SUM(V46:V58)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF46:BF58)","v":0},0,0,0,0,0,0,0,0]
[24,3,"Manufacturing",301,"Manufacture and deliver of complete Low Nox burner inclusive of all material including wear and protection (steel plate material costs in items 12, 13 & 14)",30,{"$f":"IF(F46=\"\",\"Allocation?\",VLOOKUP(F46,$F$3:$G$18,2,FALSE))","v":"Procurement and Manufacturing"},"Local",null,"ZAR",{"$f":"IF(J46<>\"\",VLOOKUP(J46,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[25,3,"Manufacturing",302,"Manufacture and deliver of spare burner outlet SMV swirl assembly, 2 left swirl and 2 right swirl (Drawing 0.61/96325, Sheet 1, rev 0).",30,"Procurement and Manufacturing","Local",null,"ZAR",{"$f":"IF(J47<>\"\",VLOOKUP(J47,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[26,3,"Manufacturing",303,"Manufacture and delivery of central core air impeller 2 left swirl and 2 right swirl (Drawing 0.61/96318, Sheet 1, Rev 1 only SS314 components)",30,"Procurement and Manufacturing","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[27,3,"Manufacturing",304,"Manufacture and delivery of spare core air  tube 2 left swirl and 2 right swirl (Drawing  0.61/96319, Sheet 1, Rev 0 only SS314 components).",30,"Procurement and Manufacturing","Local",null,"ZAR",{"$f":"IF(J49<>\"\",VLOOKUP(J49,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[28,3,"Manufacturing",305,"Manufacture and delivery of spare flange for core air tube (Drawing  0.61/96318, Sheet 1, Rev 1).",30,"Procurement and Manufacturing","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[29,3,"Manufacturing",306,"Manufacture and delivery of spare secondary air swirler 2 left swirl and 2 right swirl (Drawing 0.61/96314, Sheet 1, Rev 1).",30,"Procurement and Manufacturing","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[30,3,"Manufacturing",307,"Manufacture and delivery of PF inlet (Drawing 0.61/96315, Sheet 1, Rev 0)",30,"Procurement and Manufacturing","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[31,3,"Manufacturing",308,"Manufacture and delivery of spare secondary air flange (Drawing 0.61/96316, Sheet 1, Rev 1)",30,"Procurement and Manufacturing","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[32,3,"Manufacturing",309,"Manufacture of burner stands for installation (Drawing 061/96326, Sheet 1, Rev 1)",30,"Procurement and Manufacturing","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[33,3,null,310,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[34,3,null,311,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[35,3,null,312,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[36,{"$nulls":6},"Local",null,"ZAR",{"$f":"IF(J58<>\"\",VLOOKUP(J58,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[37,4,null,null,"Procurement of Materials",null,null,"Local",null,"ZAR",null,{"$f":"SUM(L60:L86)","v":0},null,null,"Fixed",{"$f":"SUM(P60:P86)","v":0},0,0,{"$f":"SUM(S60:S86)","v":0},{"$f":"SUM(T60:T86)","v":0},{"$f":"SUM(U60:U86)","v":0},{"$f":"SUM(V60:V86)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF60:BF86)","v":0},0,0,0,0,0,0,0,0]
[38,4,"Procurement of Materials",401,"16 M03 Material",40,{"$f":"IF(F60=\"\",\"Allocation?\",VLOOKUP(F60,$F$3:$G$18,2,FALSE))","v":"Plant and Material - Local"},{"$f":"IF(J60=\"ZAR\", \"Local\", \"Foreign\")","v":"Local"},null,"ZAR",{"$f":"IF(J60<>\"\",VLOOKUP(J60,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[39,4,"Procurement of Materials",402,"SS 314 Material",40,"Plant and Material - Local","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[40,4,"Procurement of Materials",403,"S 235 JR",40,"Plant and Material - Local","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[41,4,"Procurement of Materials",404,"VRN 400",40,"Plant and Material - Local","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[42,4,null,405,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[43,4,null,406,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[44,4,null,407,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[45,4,null,408,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[46,4,null,409,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[47,4,null,410,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[48,4,null,411,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[49,4,null,412,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[50,4,null,413,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[51,4,null,414,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[52,4,null,415,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[53,4,null,416,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[54,4,null,417,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[55,4,null,418,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[56,4,null,419,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[57,4,null,420,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[58,4,null,421,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[59,4,null,422,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[60,4,null,423,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[61,4,null,424,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[62,4,null,425,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[63,4,null,426,null,null,"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[64,4,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[65,5,{"$nulls":5},"Local",null,"ZAR",null,{"$f":"SUM(L89:L143)","v":0},null,null,"Fixed",{"$f":"SUM(P89:P143)","v":0},0,0,{"$f":"SUM(S89:S143)","v":0},{"$f":"SUM(T89:T143)","v":0},{"$f":"SUM(U89:U143)","v":0},{"$f":"SUM(V89:V143)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF89:BF143)","v":0},0,0,0,0,0,0,0,0]
[66,5,{"$nulls":4},{"$f":"IF(F88=\"\",\"Allocation?\",VLOOKUP(F88,$F$3:$G$18,2,FALSE))","v":"Allocation?"},"Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[{"$f":"A88+1","v":67},5,{"$nulls":4},"Allocation?","Local",null,{"$f":"IF(I89=\"\",\"ZAR\",VLOOKUP(I89,$I$2:$K$15,2,FALSE))","v":"ZAR"},1,{"$f":"IF(Q89<>\"\",Q89/K89,\"-\")","v":"-"},null,null,{"$f":"IF(N89=\"\",\"Fixed\",VLOOKUP(N89,$N$2:$O$11,2,FALSE))","v":"Fixed"},null,null,{"$f":"+Q89+P89","v":0}]
[68,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[69,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[70,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[71,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[72,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[73,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[74,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[75,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[76,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[77,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[78,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[79,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[80,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[81,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[82,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[83,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[84,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[85,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[86,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[87,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[88,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[89,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[90,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[91,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[92,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[93,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[94,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[95,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[96,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[97,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[98,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[99,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[100,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[101,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[102,5,{"$nulls":4},"Allocation?",{"$f":"IF(J124=\"ZAR\", \"Local\", \"Foreign\")","v":"Local"},null,"ZAR",{"$f":"IF(J124<>\"\",VLOOKUP(J124,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[103,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[104,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[105,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[106,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[107,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[108,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[109,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[110,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[111,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[112,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[113,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[114,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[115,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[116,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[117,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[118,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[119,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[120,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[121,5,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[122,6,{"$nulls":5},"Local",null,"ZAR",null,{"$f":"SUM(L145:L192)","v":0},null,null,"Fixed",{"$f":"SUM(P145:P192)","v":0},0,0,{"$f":"SUM(S145:S192)","v":0},{"$f":"SUM(T145:T192)","v":0},{"$f":"SUM(U145:U192)","v":0},{"$f":"SUM(V145:V192)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF145:BF192)","v":0},0,0,0,0,0,0,0,0]
[123,6,{"$nulls":4},{"$f":"IF(F145=\"\",\"Allocation?\",VLOOKUP(F145,$F$3:$G$18,2,FALSE))","v":"Allocation?"},"Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[124,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[125,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[126,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[127,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[128,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[129,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[130,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[{"$f":"A152+1","v":131},6,{"$nulls":4},"Allocation?","Local",null,{"$f":"IF(I153=\"\",\"ZAR\",VLOOKUP(I153,$I$2:$K$15,2,FALSE))","v":"ZAR"},1,{"$f":"IF(Q153<>\"\",Q153/K153,\"-\")","v":"-"},null,null,{"$f":"IF(N153=\"\",\"Fixed\",VLOOKUP(N153,$N$2:$O$11,2,FALSE))","v":"Fixed"},null,null,{"$f":"+Q153+P153","v":0}]
[132,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[133,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[134,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[135,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[136,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[137,6,{"$nulls":4},{"$f":"IF(F159=\"\",\"Allocation?\",VLOOKUP(F159,$F$3:$G$18,2,FALSE))","v":"Allocation?"},"Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[138,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[139,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[140,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[141,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[142,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[143,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[144,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[145,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[146,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[147,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[148,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[149,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[150,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[151,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[152,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[153,6,{"$nulls":5},"Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[154,6,{"$nulls":5},"Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[155,6,{"$nulls":4},{"$f":"IF(F177=\"\",\"Allocation?\",VLOOKUP(F177,$F$3:$G$18,2,FALSE))","v":"Allocation?"},"Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[156,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[157,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[158,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[159,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[160,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[161,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[162,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[163,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[164,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[165,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[166,6,{"$nulls":4},"Allocation?",{"$f":"IF(J188=\"ZAR\", \"Local\", \"Foreign\")","v":"Local"},null,"ZAR",{"$f":"IF(J188<>\"\",VLOOKUP(J188,$J$1:$K$17,2,FALSE),\"\")","v":1},"-",null,null,"Fixed",null,null,0]
[167,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[168,6,{"$nulls":4},"Allocation?","Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[{"$nulls":7},"Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[{"$nulls":7},"Local",null,"ZAR",1,"-",null,null,"Fixed",null,null,0]
[null,null,"TOTAL",{"$nulls":8},{"$f":"L144+L87+L59+L45+L34+L23","v":0},{"$nulls":6},{"$f":"S144+S87+S59+S45+S34+S23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BD144+BD87+BD59+BD45+BD34+BD23","v":0},0,{"$f":"BF144+BF87+BF59+BF45+BF34+BF23","v":0},0,0,0,0,0,0,0,0]

{"sheet":"5.1.3 Rate of Exchange table","index":9,"n_rows":35,"n_cols":7,"rows_kept":35}
[{"$f":"'Cover Sheet'!A2","v":0}]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "},null,{"$f":"'Cover Sheet'!B19","v":"MPTUT10610PS"}]
["TENDERER NAME:",null,{"$f":"'Cover Sheet'!B25","v":0}]
[{"$f":"'5.1.1 Summary'!A4","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
["Notes: "]
[1,"For conformity please notify Eskom regarding any currencies to be used and not identified on the attached"]
[null,"list prior to enquiry closing in order that the applicable rate is provided by Eskom."]
[2,"All information in this table must conform with all other equivalent information in the offer."]
[3,"Payment for foreign commitments must be in terms of  CPA (IG) Rev 28 where applicable. Refer Tender Returnables "]
[4,"Indicate the currency per row in the Prices but only one currency per row is allowed Exchange rates must"]
[null,"be stipulated in the format of Currency 1,00 = ZAR \"value\" and rounded to four decimals. The exchange"]
[null,"rates in the tables below must be used to convert foreign currency amounts to Rand."]
[5,"The exchange rates to be used are 7 calendar days before tender close."]
[]
["RATE OF EXCHANGE FOR MULTIPLE CURRENCIES"]
["Summary",{"$nulls":4},"All rates of exchange at base of: "]
["No","Currency Description","Code","Exchange Rate Currency 1,00 =","Rand value","Currency value","Payment method 1a, 1b or 2"]
[1,"South African Rand","ZAR",null,{"$f":"SUMIF('5.1.2 Pricing Schedule'!$J$23:$J$192,$C18,'5.1.2 Pricing Schedule'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IFERROR(E18/D18,\"\")","v":""}]
[2,"Austrialian Dollar","AUD",null,null,{"$f":"IFERROR(E19/D19,\"\")","v":""}]
[3,"British Pound","GBP",null,null,""]
[4,"Canadian Dollar","CAD",null,null,""]
[5,"Danish Krone","DKK",null,null,""]
[6,"European Currency","EUR",null,{"$f":"SUMIF('5.1.2 Pricing Schedule'!$J$23:$J$192,$C23,'5.1.2 Pricing Schedule'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IFERROR(E23/D23,\"\")","v":""},"1b"]
[7,"Japanese Yen","JPY",null,null,""]
[8,"New Zealand Dollar","NZD",null,null,""]
[9,"Norwegian Krone","NOK",null,null,""]
[10,"Singapore Dollar","SGD",null,null,""]
[11,"Swedish Krone","SEK",null,null,""]
[12,"Swiss Franc","CHF",null,null,""]
[13,"United States Dollars","USD",null,{"$f":"SUMIF('5.1.2 Pricing Schedule'!$J$23:$J$192,$C30,'5.1.2 Pricing Schedule'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IFERROR(E30/D30,\"\")","v":""},"1b"]
[14]
[15]
[16]
[null,"TOTAL RAND VALUE OF ALL CURRENCIES",null,null,{"$f":"SUM(E18:E33)","v":{"$error":"#REF!"}}]
[null,"Check that value balances with Summary of tendered values",null,null,"Must equal Tender Price"]

{"sheet":"5.1.4.0 NOTES Price adj","index":10,"n_rows":20,"n_cols":2,"rows_kept":20,"merged":[[10,3,10,4],[17,4,18,4]]}
[{"$f":"'Cover Sheet'!A2","v":0}]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "},{"$f":"'Cover Sheet'!B19","v":"MPTUT10610PS"}]
["TENDERER NAME:",{"$f":"'Cover Sheet'!B25","v":0}]
[{"$f":"'5.1.1 Summary'!A4","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
["5.1.4 PRICE ADJUSTMENT FOR INFLATION"]
[]
["GENERAL NOTES :"]
["a.","References to \"indices\" below have the meaning of \"cost indices or reference prices\", unless otherwise stated."]
["b.","Where historical information is applicable as requested below, internet address references which are accessible to the general public may be submitted instead, with the specific electronic route and web page reflecting the applicable data."]
["c.","Each formula is related to one unique currency. Mixing of currencies in a specific formula is not acceptable."]
["CPA FORMULAE REQUIREMENTS :"]
["i.","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 statistical publishing source and must not be in-house indices."]
["ii.","Local Indices: Where local indices other than SEIFSA or StatsSA are specified, the tenderer is to submit 5 years' historical data for such indices.  Note that the Contractor must ensure that indices are published and recommended by the \"Source\" as applicable to the work involved. For example SEIFSA has terminated the publication of Table E and is replaced by Table E-A and or E-EX and the specific sub breakdown of such must be identified. Also SEIFSA recommends utilisation of Table L-2 for road transport rather than Table L-1.  "]
["iii.","Foreign Price Adjustments: In the case of foreign price adjustments, the Contractor is to submit 5 years' historical data for the tendered indices.  Where a formula is linked to indices in a country, payment of the amounts for that formula must be in the currency of the same country.  A formula may not be linked to indices of more than one country."]
["iv.","Commodity Price Linked Payments: The reference price is considered as the base price (index) for purpose of the CPA formula and is included in the applicable tables below and must be in the currency in which the CPA will be payable.  The exchange rate applied to convert the base price in a foreign currency into that of the currency of the formula must also be indicated in the tables below if the price is not in the same currency as the applicable formula, i.e. exposure to the movement in a reference price is in the same currency as that of the CPA formula.  The Contractor is to submit 5 years' historical price data for such commodity, "]
["v.","London Metal Exchange (LME) Prices: For metals traded on the LME, the tonnage will be required before contract award in order for Eskom to hedge the metal price fluctuations.  This applies also for prices linked to local indices or reference prices.  Though these metals are traded in US$, prices are daily quoted in various other currencies.  The LME price in the currency of the formula must apply and thus not the US$ unless the amount payable in terms of the formula is US$.  Refer to the \"LME\" Sheet in this file for more detail regarding this aspect.  By indicating any of these metals in the formulae below, the contractor declares that neither he nor any other body avails or will avail of forward price and/or currency cover for the metal(s).  "]
["vi.","CPA Base Date: The CPA base date for calculating price movements is the Base Date as defined in the Particular Conditions, Clause 1.1.3.1. 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 the price adjustment. "]
["vii.","Period for Movement in Indices: The period for which the movement in indices or reference prices is considered, is the period until the last day of the month prior to the  month in which the work in question was executed or completed (or in which an event or activity for which the adjustment applies, took place).  For indices or reference prices published as at certain dates, and where such a date is not the last day of the month prior to the month in which the work was executed or completed (or an event or activity took place),  then latest date for which the indices or price references are published before the last day of the month prior to the execution or completion of work (or an event or activity took place) is considered as the last day index or reference price of the month prior to execution or completion of work (or event or activity). "]
["viii.","Proportions/weighting/coefficients/base reference in CPA Formulae: The fixed portion of each formula, not subject to inflation, is at least 15% and contractors may submit higher fixed portion percentages.  The indices or other benchmarks and their proportions in the formula must be realistic and relative to the applicable work. The fixed portion and other proportions must add up to 100%."]
["ix.","Base Index or Reference Price :   The base index or reference price must be inserted in the appropriate column"]

{"sheet":" 5.1.4.1 CPA Formula","index":11,"n_rows":96,"n_cols":14,"rows_kept":96}
[{"$f":"'Cover Sheet'!A2","v":0}]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "},null,{"$f":"'Cover Sheet'!B19","v":"MPTUT10610PS"}]
["TENDERER NAME:",null,{"$f":"'Cover Sheet'!B25","v":0}]
[{"$f":"'5.1.1 Summary'!A4","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
["PRICE ADJUSTMENT FOR INFLATION"]
["FORMULAE DETAILS"]
["CPA No \"Description\" automated from Summary CPA formulae (Predefine description heading in Summary CPA formulae)"]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"v":1,"d":"001"},null,"a"]
[{"v":1,"d":"001"},null,"b"]
[{"v":1,"d":"001"},null,"c"]
[{"v":1,"d":"001"},null,"d"]
[{"v":1,"d":"001"},null,"e"]
[{"v":1,"d":"001"},null,"f",{"$f":"1-0.85","v":{"v":0.15000000000000002,"d":"0.150"}},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":1,"d":"001"},null,null,{"$f":"SUM(D9:D14)","v":{"v":0.15000000000000002,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A9+1","v":{"v":2,"d":"002"}},null,"a"]
[{"$f":"A18","v":{"v":2,"d":"002"}},null,"b"]
[{"v":2,"d":"002"},null,"c"]
[{"v":2,"d":"002"},null,"d"]
[{"v":2,"d":"002"},null,"e"]
[{"v":2,"d":"002"},null,"f",{"$f":"D14","v":{"v":0.15000000000000002,"d":"0.150"}},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":2,"d":"002"},null,null,{"$f":"SUM(D18:D23)","v":{"v":0.15000000000000002,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A18+1","v":{"v":3,"d":"003"}},null,"a"]
[{"$f":"A27","v":{"v":3,"d":"003"}},null,"b"]
[{"v":3,"d":"003"},null,"c"]
[{"v":3,"d":"003"},null,"d"]
[{"v":3,"d":"003"},null,"e"]
[{"v":3,"d":"003"},null,"f",{"$f":"D14","v":{"v":0.15000000000000002,"d":"0.150"}},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":3,"d":"003"},null,null,{"$f":"SUM(D27:D32)","v":{"v":0.15000000000000002,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A27+1","v":{"v":4,"d":"004"}},null,"a"]
[{"$f":"A36","v":{"v":4,"d":"004"}},null,"b"]
[{"v":4,"d":"004"},null,"c"]
[{"v":4,"d":"004"},null,"d"]
[{"v":4,"d":"004"},null,"e"]
[{"v":4,"d":"004"},null,"f",{"$f":"D14","v":{"v":0.15000000000000002,"d":"0.150"}},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":4,"d":"004"},null,null,{"$f":"SUM(D36:D41)","v":{"v":0.15000000000000002,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A36+1","v":{"v":5,"d":"005"}},null,"a"]
[{"$f":"A45","v":{"v":5,"d":"005"}},null,"b"]
[{"v":5,"d":"005"},null,"c"]
[{"v":5,"d":"005"},null,"d"]
[{"v":5,"d":"005"},null,"e"]
[{"v":5,"d":"005"},null,"f",{"$f":"D14","v":{"v":0.15000000000000002,"d":"0.150"}},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":5,"d":"005"},null,null,{"$f":"SUM(D45:D50)","v":{"v":0.15000000000000002,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A45+1","v":{"v":6,"d":"006"}},null,"a"]
[{"$f":"A54","v":{"v":6,"d":"006"}},null,"b"]
[{"v":6,"d":"006"},null,"c"]
[{"v":6,"d":"006"},null,"d"]
[{"v":6,"d":"006"},null,"e"]
[{"v":6,"d":"006"},null,"f",{"$f":"D14","v":{"v":0.15000000000000002,"d":"0.150"}},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":6,"d":"006"},null,null,{"$f":"SUM(D54:D59)","v":{"v":0.15000000000000002,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A54+1","v":{"v":7,"d":"007"}},null,"a"]
[{"$f":"A63","v":{"v":7,"d":"007"}},null,"b"]
[{"v":7,"d":"007"},null,"c"]
[{"v":7,"d":"007"},null,"d"]
[{"v":7,"d":"007"},null,"e"]
[{"v":7,"d":"007"},null,"f",{"$f":"D14","v":{"v":0.15000000000000002,"d":"0.150"}},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":7,"d":"007"},null,null,{"$f":"SUM(D63:D68)","v":{"v":0.15000000000000002,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A63+1","v":{"v":8,"d":"008"}},null,"a"]
[{"$f":"A72","v":{"v":8,"d":"008"}},null,"b"]
[{"v":8,"d":"008"},null,"c"]
[{"v":8,"d":"008"},null,"d"]
[{"v":8,"d":"008"},null,"e"]
[{"v":8,"d":"008"},null,"f",{"$f":"D14","v":{"v":0.15000000000000002,"d":"0.150"}},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":8,"d":"008"},null,null,{"$f":"SUM(D72:D77)","v":{"v":0.15000000000000002,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A72+1","v":{"v":9,"d":"009"}},null,"a"]
[{"$f":"A81","v":{"v":9,"d":"009"}},null,"b"]
[{"v":9,"d":"009"},null,"c"]
[{"v":9,"d":"009"},null,"d"]
[{"v":9,"d":"009"},null,"e"]
[{"v":9,"d":"009"},null,"f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":9,"d":"009"},null,null,{"$f":"SUM(D81:D86)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]
[]
["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 (See Note vi)","Base index","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data  (Yes/No)","Internet address"]
[{"$f":"A81+1","v":{"v":10,"d":"010"}},null,"a"]
[{"$f":"A90","v":{"v":10,"d":"010"}},{"$f":"B90","v":0},"b"]
[{"v":10,"d":"010"},0,"c"]
[{"v":10,"d":"010"},0,"d"]
[{"v":10,"d":"010"},0,"e"]
[{"v":10,"d":"010"},0,"f",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[{"v":10,"d":"010"},0,null,{"$f":"SUM(D90:D95)","v":{"v":0.15,"d":"0.150"}},"Total (1.00)"]

{"sheet":" 5.1.5 LME Notes","index":12,"n_rows":27,"n_cols":4,"rows_kept":27}
[{"$f":"'Cover Sheet'!A2","v":0}]
[{"$f":"'Cover Sheet'!$A$19","v":"ENQUIRY NUMBER "},null,null,{"$f":"'Cover Sheet'!B19","v":"MPTUT10610PS"}]
["TENDERER NAME:",null,null,{"$f":"'Cover Sheet'!B25","v":0}]
[{"$f":"'5.1.1 Summary'!A4","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "}]
["Commodities Traded on the London Metal Exchange (LME)"]
[]
["Notes  :"]
[1,"The metals listed are traded in US Dollar.  If the Dollar prices are converted to other currencies,"]
[null,"including South African Rand, the exchange rates must be indicated in the CPA sheet.  "]
[2,"Under normal instances Eskom hedges its exposure to price movements even in instances where"]
[null,"the local portion of contract prices are subject to fluctuations in local indices, e.g. SEIFSA Table F"]
[null,"(for copper, zinc and lead), Table R (for aluminium), etc.  In such instances the exchange rates are"]
[null,"not required.  The tonnage needs to be stipulated as per Note v. in the CPA Sheet of this Excel file"]
[null,"before contract award."]
[3,"The reference to aluminium must be clearly stipulated in the CPA Sheet, ie \"Aluminium\" or "]
[null,"\"Aluminium Alloy\".  Furthermore, Eskom can only accept Aluminium Alloy (instead of Aluminium) if"]
[null,"the material consists of aluminium alloy, otherwise Eskom accepts only the Aluminium LME prices"]
[null,"as adjustment benchmark"]
[]
[null,"The LME metals are :"]
[null,"- Copper"]
[null,"- Aluminium (Primary or First Grade)"]
[null,"- Aluminium Alloy "]
[null,"- Lead"]
[null,"- Zinc"]
[null,"- Nickel"]
[null,"- Tin"]

{"sheet":"Schedule of cost components","index":13,"n_rows":760,"n_cols":20,"rows_kept":760,"hidden":true}
[{"$f":"'Cover Sheet'!A2","v":0},{"$nulls":9},1,{"$f":"' 5.1.4.1 CPA Formula'!B9","v":0},"Foreign",1,"ZAR",{"$f":"'5.1.3 Rate of Exchange table'!D18","v":{"v":0,"d":"R 0.000000"}}]
[{"$f":"'Cover Sheet'!A19","v":"ENQUIRY NUMBER "},{"$nulls":6},"No","Cost allocation","Method",2,"Description of Formula B","Local",2,"AUD",{"$f":"'5.1.3 Rate of Exchange table'!D19","v":{"v":0,"d":"R 0.000000"}}]
["TENDERER NAME:",null,null,0,{"$nulls":3},{"v":0,"d":"00"},"General","1a",3,"Description of Formula C",null,3,"CAD",{"$f":"'5.1.3 Rate of Exchange table'!D20","v":{"v":0,"d":"R 0.000000"}}]
[{"$f":"'Cover Sheet'!A21","v":"Manufacture, Supply and delivery of Seventy Two (72) Low NOx Burners and Burners Spares for Three (3) Units at Tutuka Power Station "},{"$nulls":6},10,"Management","1b",4,"Description of Formula D",null,4,"CHF",{"$f":"'5.1.3 Rate of Exchange table'!D21","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},20,"Design Management",2,5,"Description of Formula E",null,5,"DKK",{"$f":"'5.1.3 Rate of Exchange table'!D22","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},30,"Procurement",null,6,"Description of Formula F",null,6,"EUR",{"$f":"'5.1.3 Rate of Exchange table'!D23","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},40,"Plant and Material - Local",null,7,"Description of Formula G",null,7,"GBP",{"$f":"'5.1.3 Rate of Exchange table'!D24","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},50,"Plant and Material - Foreign",null,8,"Description of Formula H",null,8,"JPY",{"$f":"'5.1.3 Rate of Exchange table'!D25","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},60,"Transport - Local",null,9,"Description of Formula I",null,9,"NZD",{"$f":"'5.1.3 Rate of Exchange table'!D26","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},70,"Transport - Freight/Sea",null,10,"Description of Formula J",null,10,"NOK",{"$f":"'5.1.3 Rate of Exchange table'!D27","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},80,"Construction, Erection & Installation",{"$nulls":4},11,"SEK",{"$f":"'5.1.3 Rate of Exchange table'!D28","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},90,"Commissioning and Testing",{"$nulls":4},12,"SGD",{"$f":"'5.1.3 Rate of Exchange table'!D29","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},100,"Codification and Labelling",{"$nulls":4},13,"USD",{"$f":"'5.1.3 Rate of Exchange table'!D30","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},110,"Training ",{"$nulls":4},14,null,{"$f":"'5.1.3 Rate of Exchange table'!D31","v":{"v":0,"d":"R 0.000000"}}]
[{"$nulls":7},120,"Drawings and Manuals"]
[{"$nulls":7},130,"Other",null,"Price cost allocation - Note Unique currencies and CPA formula per"]
["THIS IS AN ALTERNATIVE RATES SCHEDULE WHICH MAY BE USED AS AND WHEN REQUIRED AND WILL BE",{"$nulls":6},140,"Fixed charges",null,"line must be compiled with only one currency with one associated"]
["USED IN THE EVALUATION OF TENDERS",{"$nulls":6},150,"Time-related",null,"CPA formula and no mix of foreign & local price adjustment"]
["THE TENDERER DOES NOT ADD THE COSTS FROM THIS SCHEDULE TO HIS TENDER",{"$nulls":9},"Default is \"Fixed\" unless otherwise specified",null,"Default is \"ZAR\" R1,000 unless specified"]
[{"$nulls":10},"PRICE ADJUSTMENT",null,"Rate of exchange Data (Insert Rate No)"]
["Ref","Sch No","Schedule description","Section ID","Section Description","Item ID","Item Description","No","Cost allocation ","Payment method 1a, 1b or 2","CPA formula and no mix of foreign & local price adjustment","FORMULA DESCRIPTION"," Foreign / Local","No","Currency Type","RoE Currency 1,00 = R","Unit of measurement","Quantity","Cost per Unit","Total Costs in ZAR"]
[1,10,"Alternative rates","A",{"$nulls":6},1,null,{"$f":"IF($O22=0,\"Check\",IF($O22=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,{"$f":"IF(N22=\"\",\"ZAR\",VLOOKUP(N22,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"$f":"IF(N22=\"\",1,VLOOKUP(N22,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R22*S22","v":{"v":0,"d":"0.00"}}]
[2,10,"Alternative rates","A",{"$nulls":3},{"v":0,"d":"00"},{"$f":"IF(H23=\"\",\"Allocation?\",VLOOKUP(H23,$H$3:$I$14,2,FALSE))","v":"General"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R23*S23","v":{"v":0,"d":"0.00"}}]
[3,10,"Alternative rates","A",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R24*S24","v":{"v":0,"d":"0.00"}}]
[4,10,"Alternative rates","A",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[5,10,"Alternative rates","A",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[6,10,"Alternative rates","A",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[7,10,"Alternative rates","A",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[8,10,"Alternative rates","A",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R29*S29","v":{"v":0,"d":"0.00"}}]
[9,10,"Alternative rates","A",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[10,10,"Alternative rates","A",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[11,10,"Alternative rates","A",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N32=\"\",1,VLOOKUP(N32,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R32*S32","v":{"v":0,"d":"0.00"}}]
[12,10,"Alternative rates","A",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[13,10,"Alternative rates","A",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R34*S34","v":{"v":0,"d":"0.00"}}]
[14,10,"Alternative rates","A",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[15,10,"Alternative rates","A",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[16,10,"Alternative rates","A",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[17,10,"Alternative rates","A",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[18,10,"Alternative rates","A",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[19,10,"Alternative rates","A",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[20,10,"Alternative rates","A",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N41=\"\",1,VLOOKUP(N41,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R41*S41","v":{"v":0,"d":"0.00"}}]
[21,10,"Alternative rates","A",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[22,10,"Alternative rates","A",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[23,10,"Alternative rates","A",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[24,10,"Alternative rates","A",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[25,10,"Alternative rates","A",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[26,10,"Alternative rates","A",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[27,10,"Alternative rates","A",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R48*S48","v":{"v":0,"d":"0.00"}}]
[28,10,"Alternative rates","A",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[29,10,"Alternative rates","A",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[30,10,"Alternative rates","A",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[31,10,"Alternative rates","A",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[32,10,"Alternative rates","A",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[33,10,"Alternative rates","A",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[34,10,"Alternative rates","A",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[35,10,"Alternative rates","A",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[36,10,"Alternative rates","A",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R57*S57","v":{"v":0,"d":"0.00"}}]
[37,10,"Alternative rates","A",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[38,10,"Alternative rates","A",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[39,10,"Alternative rates","A",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[40,10,"Alternative rates","A",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[41,10,"Alternative rates","A",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[42,10,"Alternative rates","A",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[43,10,"Alternative rates","A",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[44,10,"Alternative rates","A",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N65=\"\",1,VLOOKUP(N65,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R65*S65","v":{"v":0,"d":"0.00"}}]
[45,10,"Alternative rates","A",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[46,10,"Alternative rates","A",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[47,10,"Alternative rates","A",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[48,10,"Alternative rates","A",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[49,10,"Alternative rates","A",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[50,10,"Alternative rates","A",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[51,10,"Alternative rates","A",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[52,10,"Alternative rates","A",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N73=\"\",1,VLOOKUP(N73,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R73*S73","v":{"v":0,"d":"0.00"}}]
[53,10,"Alternative rates","A",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[54,10,"Alternative rates","A",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[55,10,"Alternative rates","A",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[56,10,"Alternative rates","A",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[57,10,"Alternative rates","A",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[58,10,"Alternative rates","A",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[59,10,"Alternative rates","A",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[60,10,"Alternative rates","A",{"$nulls":3},30,"Procurement",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"$f":"R81*S81","v":{"v":0,"d":"0.00"}}]
[61,10,"Alternative rates","A",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[62,10,"Alternative rates","A",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[63,10,"Alternative rates","A",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[64,10,"Alternative rates","A",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[65,10,"Alternative rates","A",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},{"$f":"IF($O86=0,\"Check\",IF($O86=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,{"$f":"IF(N86=\"\",\"ZAR\",VLOOKUP(N86,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"$f":"IF(N86=\"\",1,VLOOKUP(N86,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[66,10,"Alternative rates","A",{"$nulls":3},90,{"$f":"IF(H87=\"\",\"Allocation?\",VLOOKUP(H87,$H$3:$I$14,2,FALSE))","v":"Commissioning and Testing"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R87*S87","v":{"v":0,"d":"0.00"}}]
[67,10,"Alternative rates","A",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[68,10,"Alternative rates","A",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N89=\"\",1,VLOOKUP(N89,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R89*S89","v":{"v":0,"d":"0.00"}}]
[69,10,"Alternative rates","A",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[70,10,"Alternative rates","A",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[71,10,"Alternative rates","A",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[72,10,"Alternative rates","A",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[73,10,"Alternative rates","A",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[74,10,"Alternative rates","A",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[75,10,"Alternative rates","A",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[76,10,"Alternative rates","A",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R97*S97","v":{"v":0,"d":"0.00"}}]
[77,10,"Alternative rates","A",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R98*S98","v":{"v":0,"d":"0.00"}}]
[78,10,"Alternative rates","A",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[79,10,"Alternative rates","A",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[80,10,"Alternative rates","A",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[81,10,"Alternative rates","A",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[82,10,"Alternative rates","A",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[83,10,"Alternative rates","A",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[84,10,"Alternative rates","A",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"$f":"R105*S105","v":{"v":0,"d":"0.00"}}]
[85,10,"Alternative rates","A",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[86,10,"Alternative rates","A",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[87,10,"Alternative rates","A",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[88,10,"Alternative rates","A",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[89,10,"Alternative rates","A",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[90,10,"Alternative rates","B",{"$nulls":8},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[91,10,"Alternative rates","B",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[92,10,"Alternative rates","B",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R113*S113","v":{"v":0,"d":"0.00"}}]
[93,10,"Alternative rates","B",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[94,10,"Alternative rates","B",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[95,10,"Alternative rates","B",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[96,10,"Alternative rates","B",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[97,10,"Alternative rates","B",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N118=\"\",1,VLOOKUP(N118,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R118*S118","v":{"v":0,"d":"0.00"}}]
[98,10,"Alternative rates","B",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[99,10,"Alternative rates","B",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[100,10,"Alternative rates","B",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R121*S121","v":{"v":0,"d":"0.00"}}]
[101,10,"Alternative rates","B",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[102,10,"Alternative rates","B",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[103,10,"Alternative rates","B",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[104,10,"Alternative rates","B",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[105,10,"Alternative rates","B",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[106,10,"Alternative rates","B",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[107,10,"Alternative rates","B",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[108,10,"Alternative rates","B",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[109,10,"Alternative rates","B",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R130*S130","v":{"v":0,"d":"0.00"}}]
[110,10,"Alternative rates","B",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[111,10,"Alternative rates","B",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[112,10,"Alternative rates","B",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[113,10,"Alternative rates","B",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[114,10,"Alternative rates","B",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[115,10,"Alternative rates","B",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[116,10,"Alternative rates","B",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[117,10,"Alternative rates","B",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R138*S138","v":{"v":0,"d":"0.00"}}]
[118,10,"Alternative rates","B",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[119,10,"Alternative rates","B",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[120,10,"Alternative rates","B",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[121,10,"Alternative rates","B",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[122,10,"Alternative rates","B",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},{"$f":"IF($O143=0,\"Check\",IF($O143=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,{"$f":"IF(N143=\"\",\"ZAR\",VLOOKUP(N143,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[123,10,"Alternative rates","B",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[124,10,"Alternative rates","B",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[125,10,"Alternative rates","B",{"$nulls":3},10,"Management",{"$nulls":3},"Foreign",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R146*S146","v":{"v":0,"d":"0.00"}}]
[126,10,"Alternative rates","B",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[127,10,"Alternative rates","B",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[128,10,"Alternative rates","B",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[129,10,"Alternative rates","B",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[130,10,"Alternative rates","B",{"$nulls":3},60,{"$f":"IF(H151=\"\",\"Allocation?\",VLOOKUP(H151,$H$3:$I$14,2,FALSE))","v":"Transport - Local"},{"$nulls":3},{"$f":"IF($O151=0,\"Check\",IF($O151=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,{"$f":"IF(N151=\"\",\"ZAR\",VLOOKUP(N151,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"$f":"IF(N151=\"\",1,VLOOKUP(N151,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[131,10,"Alternative rates","B",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,{"$f":"IF(N152=\"\",\"ZAR\",VLOOKUP(N152,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[132,10,"Alternative rates","B",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,{"$f":"IF(N153=\"\",\"ZAR\",VLOOKUP(N153,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[133,10,"Alternative rates","B",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,{"$f":"IF(N154=\"\",\"ZAR\",VLOOKUP(N154,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R154*S154","v":{"v":0,"d":"0.00"}}]
[134,10,"Alternative rates","B",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,{"$f":"IF(N155=\"\",\"ZAR\",VLOOKUP(N155,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[139,10,"Alternative rates","C",{"$nulls":4},"Allocation?",{"$nulls":3},{"$f":"IF($O156=0,\"Check\",IF($O156=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,{"$f":"IF(N156=\"\",\"ZAR\",VLOOKUP(N156,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[140,10,"Alternative rates","C",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[141,10,"Alternative rates","C",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R158*S158","v":{"v":0,"d":"0.00"}}]
[142,10,"Alternative rates","C",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R159*S159","v":{"v":0,"d":"0.00"}}]
[143,10,"Alternative rates","C",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[144,10,"Alternative rates","C",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[145,10,"Alternative rates","C",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"$f":"R162*S162","v":{"v":0,"d":"0.00"}}]
[146,10,"Alternative rates","C",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[147,10,"Alternative rates","C",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[148,10,"Alternative rates","C",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[149,10,"Alternative rates","C",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[150,10,"Alternative rates","C",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R167*S167","v":{"v":0,"d":"0.00"}}]
[151,10,"Alternative rates","C",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R168*S168","v":{"v":0,"d":"0.00"}}]
[152,10,"Alternative rates","C",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[153,10,"Alternative rates","C",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[154,10,"Alternative rates","C",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[155,10,"Alternative rates","C",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[156,10,"Alternative rates","C",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[157,10,"Alternative rates","C",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[158,10,"Alternative rates","C",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[159,10,"Alternative rates","C",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[160,10,"Alternative rates","C",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[161,10,"Alternative rates","C",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N178=\"\",1,VLOOKUP(N178,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R178*S178","v":{"v":0,"d":"0.00"}}]
[162,10,"Alternative rates","C",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[163,10,"Alternative rates","C",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[164,10,"Alternative rates","C",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[165,10,"Alternative rates","C",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[166,10,"Alternative rates","C",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[167,10,"Alternative rates","C",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[168,10,"Alternative rates","C",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[169,10,"Alternative rates","C",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[170,10,"Alternative rates","C",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N187=\"\",1,VLOOKUP(N187,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R187*S187","v":{"v":0,"d":"0.00"}}]
[171,10,"Alternative rates","C",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[172,10,"Alternative rates","C",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[173,10,"Alternative rates","C",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[174,10,"Alternative rates","C",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R191*S191","v":{"v":0,"d":"0.00"}}]
[175,10,"Alternative rates","C",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R192*S192","v":{"v":0,"d":"0.00"}}]
[176,10,"Alternative rates","C",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[177,10,"Alternative rates","C",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[178,10,"Alternative rates","C",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[179,10,"Alternative rates","C",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[180,10,"Alternative rates","C",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[181,10,"Alternative rates","C",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[182,10,"Alternative rates","C",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[183,10,"Alternative rates","C",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[188,10,"Alternative rates","D ",{"$nulls":4},"Allocation?",{"$nulls":3},{"$f":"IF($O201=0,\"Check\",IF($O201=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,{"$f":"IF(N201=\"\",\"ZAR\",VLOOKUP(N201,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"$f":"IF(N201=\"\",1,VLOOKUP(N201,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[189,10,"Alternative rates","D ",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N202=\"\",1,VLOOKUP(N202,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[190,10,"Alternative rates","D ",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N203=\"\",1,VLOOKUP(N203,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[191,10,"Alternative rates","D ",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N204=\"\",1,VLOOKUP(N204,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[192,10,"Alternative rates","D ",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[193,10,"Alternative rates","D ",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[194,10,"Alternative rates","D ",{"$nulls":3},50,{"$f":"IF(H207=\"\",\"Allocation?\",VLOOKUP(H207,$H$3:$I$14,2,FALSE))","v":"Plant and Material - Foreign"},{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[195,10,"Alternative rates","D ",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[196,10,"Alternative rates","D ",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[197,10,"Alternative rates","D ",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[198,10,"Alternative rates","D ",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[199,10,"Alternative rates","D ",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[200,10,"Alternative rates","D ",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[201,10,"Alternative rates","D ",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[202,10,"Alternative rates","D ",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[203,10,"Alternative rates","D ",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[204,10,"Alternative rates","D ",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[205,10,"Alternative rates","D ",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[206,10,"Alternative rates","D ",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[207,10,"Alternative rates","D ",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[208,10,"Alternative rates","D ",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[209,10,"Alternative rates","D ",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[210,10,"Alternative rates","D ",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[211,10,"Alternative rates","D ",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[212,10,"Alternative rates","D ",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[213,10,"Alternative rates","D ",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[214,10,"Alternative rates","D ",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[215,10,"Alternative rates","D ",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[216,10,"Alternative rates","D ",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[217,10,"Alternative rates","D ",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[218,10,"Alternative rates","D ",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[219,10,"Alternative rates","D ",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[220,10,"Alternative rates","D ",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[221,10,"Alternative rates","D ",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[229,10,"Alternative rates","E",{"$nulls":4},"Allocation?",{"$nulls":3},{"$f":"IF($O235=0,\"Check\",IF($O235=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,{"$f":"IF(N235=\"\",\"ZAR\",VLOOKUP(N235,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[230,10,"Alternative rates","E",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[231,10,"Alternative rates","E",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R237*S237","v":{"v":0,"d":"0.00"}}]
[232,10,"Alternative rates","E",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[233,10,"Alternative rates","E",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[234,10,"Alternative rates","E",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[235,10,"Alternative rates","E",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[236,10,"Alternative rates","E",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[237,10,"Alternative rates","E",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[238,10,"Alternative rates","E",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[239,10,"Alternative rates","E",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R245*S245","v":{"v":0,"d":"0.00"}}]
[240,10,"Alternative rates","E",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R246*S246","v":{"v":0,"d":"0.00"}}]
[241,10,"Alternative rates","E",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[242,10,"Alternative rates","E",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[243,10,"Alternative rates","E",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[244,10,"Alternative rates","E",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[245,10,"Alternative rates","E",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[246,10,"Alternative rates","E",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"$f":"R252*S252","v":{"v":0,"d":"0.00"}}]
[247,10,"Alternative rates","E",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[248,10,"Alternative rates","E",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[249,10,"Alternative rates","E",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[250,10,"Alternative rates","E",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[251,10,"Alternative rates","E",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[252,10,"Alternative rates","E",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[253,10,"Alternative rates","E",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[254,10,"Alternative rates","E",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R260*S260","v":{"v":0,"d":"0.00"}}]
[255,10,"Alternative rates","E",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N261=\"\",1,VLOOKUP(N261,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[256,10,"Alternative rates","E",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[257,10,"Alternative rates","E",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[258,10,"Alternative rates","E",{"$nulls":3},60,{"$f":"IF(H264=\"\",\"Allocation?\",VLOOKUP(H264,$H$3:$I$14,2,FALSE))","v":"Transport - Local"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[259,10,"Alternative rates","E",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[260,10,"Alternative rates","E",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[261,10,"Alternative rates","E",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[262,10,"Alternative rates","E",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R268*S268","v":{"v":0,"d":"0.00"}}]
[263,10,"Alternative rates","E",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[264,10,"Alternative rates","E",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[265,10,"Alternative rates","E",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[266,10,"Alternative rates","E",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[267,10,"Alternative rates","E",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[268,10,"Alternative rates","E",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[269,10,"Alternative rates","E",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[270,10,"Alternative rates","E",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R276*S276","v":{"v":0,"d":"0.00"}}]
[271,10,"Alternative rates","E",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[272,10,"Alternative rates","E",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[273,10,"Alternative rates","E",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[274,10,"Alternative rates","E",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[275,10,"Alternative rates","E",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[276,10,"Alternative rates","E",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[277,10,"Alternative rates","E",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[278,10,"Alternative rates","E",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R284*S284","v":{"v":0,"d":"0.00"}}]
[279,10,"Alternative rates","E",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[280,10,"Alternative rates","E",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[281,10,"Alternative rates","E",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[282,10,"Alternative rates","E",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[283,10,"Alternative rates","E",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[284,10,"Alternative rates","E",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[285,10,"Alternative rates","E",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[286,10,"Alternative rates","E",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R292*S292","v":{"v":0,"d":"0.00"}}]
[287,10,"Alternative rates","E",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[288,10,"Alternative rates","E",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[289,10,"Alternative rates","E",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[290,10,"Alternative rates","E",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[291,10,"Alternative rates","E",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[292,10,"Alternative rates","E",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,{"$f":"IF(N298=\"\",\"ZAR\",VLOOKUP(N298,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[293,10,"Alternative rates","E",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[294,10,"Alternative rates","E",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[295,10,"Alternative rates","E",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[302,10,"Alternative rates","F",{"$nulls":8},{"$f":"IF($O302=0,\"Check\",IF($O302=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[303,10,"Alternative rates","F",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[304,10,"Alternative rates","F",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R304*S304","v":{"v":0,"d":"0.00"}}]
[305,10,"Alternative rates","F",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[306,10,"Alternative rates","F",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[307,10,"Alternative rates","F",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[308,10,"Alternative rates","F",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[309,10,"Alternative rates","F",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[310,10,"Alternative rates","F",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[311,10,"Alternative rates","F",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[312,10,"Alternative rates","F",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[313,10,"Alternative rates","F",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[314,10,"Alternative rates","F",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[315,10,"Alternative rates","F",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[316,10,"Alternative rates","F",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[317,10,"Alternative rates","F",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[318,10,"Alternative rates","F",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[319,10,"Alternative rates","F",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[320,10,"Alternative rates","F",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N320=\"\",1,VLOOKUP(N320,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[321,10,"Alternative rates","F",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[322,10,"Alternative rates","F",{"$nulls":3},80,{"$f":"IF(H322=\"\",\"Allocation?\",VLOOKUP(H322,$H$3:$I$14,2,FALSE))","v":"Construction, Erection & Installation"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[323,10,"Alternative rates","F",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[324,10,"Alternative rates","F",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[325,10,"Alternative rates","F",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[326,10,"Alternative rates","F",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[327,10,"Alternative rates","F",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[328,10,"Alternative rates","F",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[329,10,"Alternative rates","F",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[330,10,"Alternative rates","F",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[331,10,"Alternative rates","F",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[332,10,"Alternative rates","F",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[333,10,"Alternative rates","F",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[334,10,"Alternative rates","F",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[335,10,"Alternative rates","F",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[336,10,"Alternative rates","F",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[337,10,"Alternative rates","F",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[338,10,"Alternative rates","F",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[339,10,"Alternative rates","F",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[340,10,"Alternative rates","F",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[341,10,"Alternative rates","F",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[342,10,"Alternative rates","F",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[343,10,"Alternative rates","F",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[344,10,"Alternative rates","F",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[345,10,"Alternative rates","F",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[346,10,"Alternative rates","F",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[347,10,"Alternative rates","F",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[348,10,"Alternative rates","F",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[349,10,"Alternative rates","F",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[350,10,"Alternative rates","F",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[351,10,"Alternative rates","F",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[352,10,"Alternative rates","F",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[353,10,"Alternative rates","F",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[354,10,"Alternative rates","F",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[355,10,"Alternative rates","F",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[356,10,"Alternative rates","F",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,{"$f":"IF(N356=\"\",\"ZAR\",VLOOKUP(N356,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[357,10,"Alternative rates","F",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[358,10,"Alternative rates","F",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[359,10,"Alternative rates","F",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[360,10,"Alternative rates","F",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[361,10,"Alternative rates","F",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[362,10,"Alternative rates","F",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},{"$f":"IF($O362=0,\"Check\",IF($O362=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[363,10,"Alternative rates","F",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[364,10,"Alternative rates","F",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[365,10,"Alternative rates","F",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[366,10,"Alternative rates","F",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[367,10,"Alternative rates","F",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[368,10,"Alternative rates","F",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R368*S368","v":{"v":0,"d":"0.00"}}]
[369,10,"Alternative rates","F",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[370,10,"Alternative rates","F",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[371,10,"Alternative rates","F",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[372,10,"Alternative rates","F",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[373,10,"Alternative rates","F",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[374,10,"Alternative rates","F",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[375,10,"Alternative rates","F",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[376,10,"Alternative rates","F",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[377,10,"Alternative rates","F",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[378,10,"Alternative rates","F",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[379,10,"Alternative rates","F",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[380,10,"Alternative rates","F",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[381,10,"Alternative rates","F",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[382,10,"Alternative rates","F",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[383,10,"Alternative rates","F",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N383=\"\",1,VLOOKUP(N383,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[384,10,"Alternative rates","F",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[385,10,"Alternative rates","F",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[386,10,"Alternative rates","F",{"$nulls":3},60,{"$f":"IF(H386=\"\",\"Allocation?\",VLOOKUP(H386,$H$3:$I$14,2,FALSE))","v":"Transport - Local"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[387,10,"Alternative rates","F",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[388,10,"Alternative rates","F",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N388=\"\",1,VLOOKUP(N388,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R388*S388","v":{"v":0,"d":"0.00"}}]
[389,10,"Alternative rates","F",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[390,10,"Alternative rates","F",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[391,10,"Alternative rates","G",{"$nulls":8},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[392,10,"Alternative rates","G",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[393,10,"Alternative rates","G",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[394,10,"Alternative rates","G",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[395,10,"Alternative rates","G",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[396,10,"Alternative rates","G",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[397,10,"Alternative rates","G",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[398,10,"Alternative rates","G",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[399,10,"Alternative rates","G",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[400,10,"Alternative rates","G",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[401,10,"Alternative rates","G",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[402,10,"Alternative rates","G",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[403,10,"Alternative rates","G",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[404,10,"Alternative rates","G",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[405,10,"Alternative rates","G",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[406,10,"Alternative rates","G",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[407,10,"Alternative rates","G",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[408,10,"Alternative rates","G",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[409,10,"Alternative rates","G",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[410,10,"Alternative rates","G",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[411,10,"Alternative rates","G",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[412,10,"Alternative rates","G",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[413,10,"Alternative rates","G",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[416,10,"Alternative rates","H",{"$nulls":8},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[417,10,"Alternative rates","H",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[418,10,"Alternative rates","H",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[419,10,"Alternative rates","H",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[420,10,"Alternative rates","H",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,{"$f":"IF(N418=\"\",\"ZAR\",VLOOKUP(N418,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[421,10,"Alternative rates","H",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[422,10,"Alternative rates","H",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[423,10,"Alternative rates","H",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[424,10,"Alternative rates","H",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[425,10,"Alternative rates","H",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[426,10,"Alternative rates","H",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[427,10,"Alternative rates","H",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},{"$f":"IF($O425=0,\"Check\",IF($O425=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[428,10,"Alternative rates","H",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[429,10,"Alternative rates","H",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[430,10,"Alternative rates","H",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[431,10,"Alternative rates","H",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[432,10,"Alternative rates","H",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R430*S430","v":{"v":0,"d":"0.00"}}]
[433,10,"Alternative rates","H",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[434,10,"Alternative rates","H",{"$nulls":3},60,"Transport - Local",{"$nulls":3},{"$f":"IF($O432=0,\"Check\",IF($O432=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[435,10,"Alternative rates","H",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[436,10,"Alternative rates","H",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[437,10,"Alternative rates","H",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[438,10,"Alternative rates","H",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[439,10,"Alternative rates","H",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[440,10,"Alternative rates","H",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[441,10,"Alternative rates","H",{"$nulls":3},20,"Design Management",{"$nulls":3},{"$f":"IF($O439=0,\"Check\",IF($O439=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[442,10,"Alternative rates","H",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[443,10,"Alternative rates","H",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[444,10,"Alternative rates","H",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[445,10,"Alternative rates","H",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[446,10,"Alternative rates","H",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[447,10,"Alternative rates","H",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N445=\"\",1,VLOOKUP(N445,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[448,10,"Alternative rates","H",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},{"$f":"IF($O446=0,\"Check\",IF($O446=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[449,10,"Alternative rates","H",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[450,10,"Alternative rates","H",{"$nulls":3},{"v":0,"d":"00"},{"$f":"IF(H448=\"\",\"Allocation?\",VLOOKUP(H448,$H$3:$I$14,2,FALSE))","v":"General"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[451,10,"Alternative rates","H",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[452,10,"Alternative rates","H",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[453,10,"Alternative rates","H",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[454,10,"Alternative rates","H",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[455,10,"Alternative rates","H",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[456,10,"Alternative rates","H",{"$nulls":3},60,"Transport - Local",{"$nulls":3},{"$f":"IF($O454=0,\"Check\",IF($O454=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[457,10,"Alternative rates","H",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[458,10,"Alternative rates","H",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[459,10,"Alternative rates","H",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[460,10,"Alternative rates","H",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[461,10,"Alternative rates","H",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[462,10,"Alternative rates","H",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[463,10,"Alternative rates","H",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[464,10,"Alternative rates","H",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[465,10,"Alternative rates","H",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[466,10,"Alternative rates","H",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[467,10,"Alternative rates","H",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[468,10,"Alternative rates","H",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[469,10,"Alternative rates","H",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[470,10,"Alternative rates","H",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[471,10,"Alternative rates","H",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[472,10,"Alternative rates","H",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[473,10,"Alternative rates","H",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[474,10,"Alternative rates","H",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[475,10,"Alternative rates","H",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[476,10,"Alternative rates","H",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[477,10,"Alternative rates","H",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[478,10,"Alternative rates","H",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[479,10,"Alternative rates","H",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[480,10,"Alternative rates","H",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[481,10,"Alternative rates","H",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[482,10,"Alternative rates","H",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[483,10,"Alternative rates","H",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[484,10,"Alternative rates","H",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,{"$f":"IF(N482=\"\",\"ZAR\",VLOOKUP(N482,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[485,10,"Alternative rates","H",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[486,10,"Alternative rates","H",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[487,10,"Alternative rates","H",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[488,10,"Alternative rates","H",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[489,10,"Alternative rates","H",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[490,10,"Alternative rates","H",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[491,10,"Alternative rates","H",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[492,10,"Alternative rates","H",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[493,10,"Alternative rates","H",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[497,10,"Alternative rates","I",{"$nulls":8},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R492*S492","v":{"v":0,"d":"0.00"}}]
[498,10,"Alternative rates","I",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[499,10,"Alternative rates","I",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[500,10,"Alternative rates","I",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[501,10,"Alternative rates","I",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[502,10,"Alternative rates","I",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[503,10,"Alternative rates","I",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[504,10,"Alternative rates","I",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[505,10,"Alternative rates","I",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[506,10,"Alternative rates","I",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[507,10,"Alternative rates","I",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[508,10,"Alternative rates","I",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[509,10,"Alternative rates","I",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[510,10,"Alternative rates","I",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[511,10,"Alternative rates","I",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N506=\"\",1,VLOOKUP(N506,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[512,10,"Alternative rates","I",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[513,10,"Alternative rates","I",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[514,10,"Alternative rates","I",{"$nulls":3},50,{"$f":"IF(H509=\"\",\"Allocation?\",VLOOKUP(H509,$H$3:$I$14,2,FALSE))","v":"Plant and Material - Foreign"},{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[515,10,"Alternative rates","I",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[516,10,"Alternative rates","I",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[517,10,"Alternative rates","I",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[518,10,"Alternative rates","I",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[519,10,"Alternative rates","I",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},{"$f":"IF($O514=0,\"Check\",IF($O514=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[520,10,"Alternative rates","I",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[521,10,"Alternative rates","I",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[522,10,"Alternative rates","I",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[524,10,"Alternative rates","I",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[525,10,"Alternative rates","I",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[526,10,"Alternative rates","I",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[527,10,"Alternative rates","I",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[528,10,"Alternative rates","I",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[529,10,"Alternative rates","I",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[530,10,"Alternative rates","I",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[531,10,"Alternative rates","I",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[538,10,"Alternative rates","J",{"$nulls":8},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[539,10,"Alternative rates","J",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[540,10,"Alternative rates","J",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[541,10,"Alternative rates","J",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[542,10,"Alternative rates","J",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[543,10,"Alternative rates","J",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[544,10,"Alternative rates","J",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[545,10,"Alternative rates","J",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[546,10,"Alternative rates","J",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[547,10,"Alternative rates","J",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[548,10,"Alternative rates","J",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,{"$f":"IF(N536=\"\",\"ZAR\",VLOOKUP(N536,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[549,10,"Alternative rates","J",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[550,10,"Alternative rates","J",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[551,10,"Alternative rates","J",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[552,10,"Alternative rates","J",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[553,10,"Alternative rates","J",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[554,10,"Alternative rates","J",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[555,10,"Alternative rates","J",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[556,10,"Alternative rates","J",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[557,10,"Alternative rates","J",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[558,10,"Alternative rates","J",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[559,10,"Alternative rates","J",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[560,10,"Alternative rates","J",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R548*S548","v":{"v":0,"d":"0.00"}}]
[561,10,"Alternative rates","J",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[562,10,"Alternative rates","J",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[563,10,"Alternative rates","J",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[564,10,"Alternative rates","J",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[565,10,"Alternative rates","J",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[566,10,"Alternative rates","J",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[567,10,"Alternative rates","J",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[568,10,"Alternative rates","J",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[569,10,"Alternative rates","J",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[570,10,"Alternative rates","J",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[571,10,"Alternative rates","J",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[579,10,"Alternative rates","K",{"$nulls":8},"Local",null,"ZAR",{"$f":"IF(N560=\"\",1,VLOOKUP(N560,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[580,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},{"$f":"IF(H561=\"\",\"Allocation?\",VLOOKUP(H561,$H$3:$I$14,2,FALSE))","v":"General"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[581,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[582,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[583,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},{"$f":"IF($O564=0,\"Check\",IF($O564=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[584,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[585,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[586,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[587,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[588,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[589,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[590,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[591,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[592,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[593,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[594,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[595,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[596,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[597,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[598,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[599,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[600,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[601,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[602,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[603,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[604,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[605,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[606,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[607,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[608,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[609,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[610,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[611,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[612,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,{"$f":"IF(N593=\"\",\"ZAR\",VLOOKUP(N593,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[613,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[614,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[615,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[616,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[617,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[618,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[619,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[620,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[621,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[622,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[623,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[624,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R605*S605","v":{"v":0,"d":"0.00"}}]
[625,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[626,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[627,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[628,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[629,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[630,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[631,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[632,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[633,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[634,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[635,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[636,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[637,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[638,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[639,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N620=\"\",1,VLOOKUP(N620,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[640,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[641,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[642,10,"Alternative rates","K",{"$nulls":3},70,{"$f":"IF(H623=\"\",\"Allocation?\",VLOOKUP(H623,$H$3:$I$14,2,FALSE))","v":"Transport - Freight/Sea"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[643,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[644,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[645,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[646,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[647,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},{"$f":"IF($O628=0,\"Check\",IF($O628=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[648,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[649,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[650,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[651,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[652,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[653,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[654,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[655,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[656,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[657,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[658,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[659,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[660,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[661,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[662,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[663,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[664,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[665,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[666,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N647=\"\",1,VLOOKUP(N647,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"$f":"R647*S647","v":{"v":0,"d":"0.00"}}]
[667,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[668,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[669,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[670,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[671,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[672,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[673,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[674,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[675,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[676,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,{"$f":"IF(N657=\"\",\"ZAR\",VLOOKUP(N657,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[677,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[678,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[679,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[680,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[681,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[682,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[683,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[684,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[685,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[686,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[687,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[688,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R669*S669","v":{"v":0,"d":"0.00"}}]
[689,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[690,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[691,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[692,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[693,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[694,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[695,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[696,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[697,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[698,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[699,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[700,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[701,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[702,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[703,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N684=\"\",1,VLOOKUP(N684,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[704,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[705,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[706,10,"Alternative rates","K",{"$nulls":3},50,{"$f":"IF(H687=\"\",\"Allocation?\",VLOOKUP(H687,$H$3:$I$14,2,FALSE))","v":"Plant and Material - Foreign"},{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[707,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[708,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[709,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[710,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[711,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[712,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},{"$f":"IF($O693=0,\"Check\",IF($O693=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[713,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[714,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[715,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[716,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[717,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[718,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[719,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[720,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[721,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[722,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[723,10,"Alternative rates","K",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[724,10,"Alternative rates","K",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[725,10,"Alternative rates","K",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[726,10,"Alternative rates","K",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[727,10,"Alternative rates","K",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[728,10,"Alternative rates","K",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[729,10,"Alternative rates","K",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[730,10,"Alternative rates","K",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[731,10,"Alternative rates","K",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[732,10,"Alternative rates","K",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[733,10,"Alternative rates","K",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[740,10,"Alternative rates","L",{"$nulls":8},"Local",null,{"$f":"IF(N715=\"\",\"ZAR\",VLOOKUP(N715,$N$1:$P$14,2,FALSE))","v":"ZAR"},{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[741,10,"Alternative rates","L",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[742,10,"Alternative rates","L",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[743,10,"Alternative rates","L",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[744,10,"Alternative rates","L",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[745,10,"Alternative rates","L",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[746,10,"Alternative rates","L",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[747,10,"Alternative rates","L",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[748,10,"Alternative rates","L",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[749,10,"Alternative rates","L",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[750,10,"Alternative rates","L",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[751,10,"Alternative rates","L",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[752,10,"Alternative rates","L",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"$f":"R727*S727","v":{"v":0,"d":"0.00"}}]
[753,10,"Alternative rates","L",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[754,10,"Alternative rates","L",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[755,10,"Alternative rates","L",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[756,10,"Alternative rates","L",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[757,10,"Alternative rates","L",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"ZAR",{"$nulls":4},{"v":0,"d":"0.00"}]
[758,10,"Alternative rates","L",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[759,10,"Alternative rates","L",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[760,10,"Alternative rates","L",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[761,10,"Alternative rates","L",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[762,10,"Alternative rates","L",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[765,10,"Alternative rates","M",{"$nulls":8},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[766,10,"Alternative rates","M",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[767,10,"Alternative rates","M",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[768,10,"Alternative rates","M",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"$f":"IF(N741=\"\",1,VLOOKUP(N741,$N$1:$P$14,3,FALSE))","v":{"v":1,"d":"R 1.0000"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[769,10,"Alternative rates","M",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[770,10,"Alternative rates","M",{"$nulls":3},40,{"$f":"IF(H743=\"\",\"Allocation?\",VLOOKUP(H743,$H$3:$I$14,2,FALSE))","v":"Plant and Material - Local"},{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[771,10,"Alternative rates","M",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[772,10,"Alternative rates","M",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[773,10,"Alternative rates","M",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[774,10,"Alternative rates","M",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[775,10,"Alternative rates","M",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[776,10,"Alternative rates","M",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},{"$f":"IF($O749=0,\"Check\",IF($O749=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[777,10,"Alternative rates","M",{"$nulls":3},{"v":0,"d":"00"},"General",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[778,10,"Alternative rates","M",{"$nulls":3},10,"Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[779,10,"Alternative rates","M",{"$nulls":3},20,"Design Management",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[780,10,"Alternative rates","M",{"$nulls":3},30,"Procurement",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[781,10,"Alternative rates","M",{"$nulls":3},40,"Plant and Material - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[782,10,"Alternative rates","M",{"$nulls":3},50,"Plant and Material - Foreign",{"$nulls":3},"Foreign",null,"EUR",{"$nulls":4},{"v":0,"d":"0.00"}]
[783,10,"Alternative rates","M",{"$nulls":3},60,"Transport - Local",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[784,10,"Alternative rates","M",{"$nulls":3},70,"Transport - Freight/Sea",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[785,10,"Alternative rates","M",{"$nulls":3},80,"Construction, Erection & Installation",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[786,10,"Alternative rates","M",{"$nulls":3},90,"Commissioning and Testing",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]
[787,10,"Alternative rates","M",{"$nulls":3},100,"Codification and Labelling",{"$nulls":3},"Local",null,"ZAR",{"v":1,"d":"R 1.0000"},{"$nulls":3},{"v":0,"d":"0.00"}]

{"sheet":"SSCC Rates","index":14,"n_rows":0,"n_cols":0,"rows_kept":0}