{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["Instruction","Summary","Act Sch-010","PS5 Schedule","Option X3","Option X1","Data"],"not_rendered":{"external_links":1,"defined_names":122},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instruction","index":0,"n_rows":50,"n_cols":3,"rows_kept":50,"flags":["formulas_cached_only"]}
[]
[null,"INSTRUCTIONS FOR COMPLETING THE ACTIVITY SCHEDULE:"]
[]
[1,"The Supplier must complete the following Sheets:"]
[null,"Summary"]
[null,"Act Sch - ###  (Where ### is the item number listed in the Summary Sheet)"]
[null,"PS5 Schedule"]
[null,"Option X3 Data"]
[null,"Option X1 Data"]
[]
[null,"NOTE:  If the above sheets are not complete, the tender will be disqualified"]
[]
[2,"Drop-down items are provided in cells highlighted in light blue"]
[]
[3,"The cells highlighted in light yellow are cells the Supplier can edit"]
[]
[4,"The Supplier can select the following items for the cost allocation in column D of the Activity Schedule"]
[]
[null,"Item No","Cost allocation"]
[null,10,"General"]
[null,20,"Design"]
[null,30,"Procurement"]
[null,40,"Engineering and Manufacture"]
[null,50,"Transport / Freight"]
[null,60,"Local Transport"]
[null,70,"Construction, Erection, Installation"]
[null,80,"Commissioning & Testing"]
[null,90,"Inspection (Local/Foreign)"]
[null,100,"Training"]
[null,110,"Spares"]
[null,120,"Local Storage"]
[]
[5,"The Supplier shall verify the values in the PS5 Schedule"]
[]
[6,"The sheet 'Option X3' defines the different currencies and ruling Rates of Exchange (RoE) to be used as part of the contract."]
[]
[7,"The sheet 'Option X1' defines the formulas that shall be used for the calculation of price adjustments."]
{"$rows_empty":12}
[null,"Name of supplier & factory of origin"]

{"sheet":"Summary","index":1,"n_rows":41,"n_cols":15,"rows_kept":41,"merged":[[4,3,4,6],[6,1,6,14],[7,10,7,11],[7,12,7,13],[8,1,19,1],[8,10,8,11],[8,12,8,13],[9,10,9,11],[9,12,9,13],[10,10,10,11],[10,12,10,13],[11,10,11,11],[11,12,11,13],[12,10,12,11],[12,12,12,13],[13,10,13,11],[13,12,13,13],[14,10,14,11],[14,12,14,13],[15,10,15,11],[15,12,15,13],[16,10,16,11],[16,12,16,13],[17,10,17,11],[17,12,17,13],[18,10,18,11],[18,12,18,13],[19,10,19,11],[19,12,19,13],[20,1,20,9],[20,10,20,11],[20,12,20,13],[26,1,26,5],[26,13,27,14],[27,1,27,5],[28,1,39,1],[40,1,40,6]],"flags":["formulas_cached_only"]}
[null,"ENQUIRY No: ","MWP1472TX"]
[]
[null,"SUMMARY OF PRICES"]
[]
[null,"SUPPLIER NAME:",null,"NAME OF O.E.M. & FACTORY"]
[]
[null,"Summary of PRICES"]
[null,"Grouping","Item No","MVA RATING","HV","LV","TERTIARY","IMPEDANCE","DUTY","Completion Date","Foreign",null,"Local",null,"Prices (P)"]
[null,null,{"v":10,"d":"010"}]
[null,null,{"v":20,"d":"020"}]
[null,null,{"v":30,"d":"030"}]
[null,null,{"v":40,"d":"040"}]
[null,null,{"v":50,"d":"050"}]
[null,null,{"v":60,"d":"060"}]
[null,null,{"v":70,"d":"070"}]
[null,null,{"v":80,"d":"080"}]
[null,null,{"v":90,"d":"090"}]
[null,null,100]
[null,null,110]
[null,null,120]
[null,"GRAND TOTALS: ",{"$nulls":8},0,null,0,null,0]
[]
[]
[]
[null,"Summary of Foreign breakdown"]
[null,"Grouping","Item No","MVA RATING","HV","LV","TERTIARY",null,null,"Foreign 1","Foreign 2","Foreign 3","Foreign 4","Option X5 Data","Total Foreign"]
[null,"Currency (eg Euro)"]
[null,"RoE Currency 1,00 = R ",{"$nulls":7},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"MV Metal-clad Switchgear",{"v":10,"d":"010"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":6},"ITEM NUMBER (REF SUMMARY)",0]
[null,null,{"v":20,"d":"020"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,{"v":30,"d":"030"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,{"v":40,"d":"040"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,{"v":50,"d":"050"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,{"v":60,"d":"060"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,{"v":70,"d":"070"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,{"v":80,"d":"080"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,{"v":90,"d":"090"},{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,100,{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,110,{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,null,120,{"v":0,"d":"0kV"},{"v":0,"d":"0A"},{"v":0,"d":"0kA"},0,{"$nulls":7},0]
[null,"GRAND TOTALS: ",{"$nulls":7},0,0,0,0,null,0]

{"sheet":"Act Sch-010","index":2,"n_rows":73,"n_cols":70,"rows_kept":73,"merged":[[3,3,4,3],[3,4,4,4],[3,5,4,10],[3,11,5,21],[5,3,5,10],[7,3,7,4],[7,5,7,10],[7,12,7,13],[7,15,7,16],[7,18,7,20],[8,3,12,3],[8,4,14,4],[8,7,8,9],[8,12,14,13],[8,18,8,19],[9,5,10,5],[9,6,10,6],[9,7,10,9],[9,10,10,10],[9,18,10,19],[9,20,10,20],[11,5,12,5],[11,6,12,6],[11,18,12,19],[11,20,12,20],[13,3,14,3],[13,5,14,5],[13,6,14,6],[16,3,16,10],[16,12,16,14],[16,16,16,20],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,12,18,12],[17,13,18,13],[17,14,18,14],[17,15,18,15],[17,16,67,20],[66,3,67,7],[66,9,67,9],[66,10,67,10],[68,3,69,7],[68,9,69,9],[68,10,69,10],[71,3,71,20],[72,3,72,5],[72,6,72,10],[72,12,72,15],[72,16,72,20],[73,3,73,5],[73,6,73,10],[73,12,73,15],[73,16,73,20],[74,3,74,5],[74,6,74,10],[74,12,74,15],[74,16,74,20],[75,3,75,5],[75,6,75,10],[75,12,75,15],[75,16,75,20],[76,3,76,5],[76,6,76,10],[76,12,76,15],[76,16,76,20],[77,3,77,5],[77,6,77,10],[77,12,77,15],[77,16,77,20],[78,3,78,5],[78,6,78,10],[78,12,78,15],[78,16,78,20],[79,3,79,5],[79,6,79,10],[79,12,79,15],[79,16,79,20]],"flags":["formulas_cached_only"]}
[]
[]
[]
[{"$nulls":3},"ENQUIRY No: ","MWP1472TX","ACTIVITY SCHEDULE",{"$nulls":5},"OTHER INFORMATION (MANDATORY)"]
[]
[{"$nulls":3},0]
[]
[{"$nulls":3},"SUPPLIER NAME:",null,"NAME OF O.E.M. & FACTORY",null,0,{"$nulls":4},"LOCAL TRANSPORT",null,null,"MATERIAL WEIGHTS",null,null,"LEAD TIME INFORMATION:"]
[{"$nulls":3},"ITEM NUMBER (REF SUMMARY)","TRANSFORMER DETAILS","MVA RATING",{"v":0,"d":"0 MVA"},"IMPEDANCE",null,null,0,null,"Based on actuals +2.5% Admin Fee ",null,null,"Material","Kg",null,"Lead Time From Date of Order to Ex Works / F.A.S: (Months)",null,0]
[{"$nulls":5},"HV",{"v":0,"d":"0 kV"},"DUTY",null,null,0,{"$nulls":4},"Copper - Local","Kg",null,"Delivery Period: (Weeks)",null,0]
[{"$nulls":6},{"$error":"#N/A"},{"$nulls":3},{"$error":"#N/A"},{"$nulls":4},"Copper - Foreign","Kg"]
[{"$nulls":5},"LV",{"v":0,"d":"0.0"},{"$nulls":8},"Core Steel","Kg",null,"Installation & Commissioning Lead Time: (Months)",null,0]
[{"$nulls":6},"MVA RATING",{"$nulls":8},"Mild Steel","Kg"]
[{"$nulls":3},{"v":10,"d":"010"},null,"TERTIARY",{"v":0,"d":"0 kV"},{"$nulls":8},"Oil","Ltr"]
[{"$nulls":6},{"$error":"#N/A"}]
[]
[{"$nulls":3},"TRANSFORMER ACTIVITY DETAILS & PS5 ALLOCATION",{"$nulls":8},"Option X3 Data",null,null,"Option X1 Data","One Payment at Installation, Commissioning & Hand Over "]
[{"$nulls":3},"Item No","Cost allocation","PS5 Allocation","Activity","Name of Tier 2 Supplier & Factory of Origin",null,"PRICE (In Rands)","PRICE (In Rands)",null,"Foreign / Local","Currency Type","RoE Currency 1,00 = R","CPA FORMULA",{"$nulls":36},8,9,10,11,13,14,15,18,19,21,22,25,26,28,29,null,"Foreign","Local"]
[{"$nulls":8},"Foreign Amount","FIRST UNIT","SUBSEQUENT UNITS",{"$nulls":41},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[{"$nulls":3},"",{"$nulls":19},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},101,null,null,"Head office overheads & Profit",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},102,null,null,"Factory Overheads",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},103,null,null,"Project management",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},104,null,null,"Electrical design  (First Unit)",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},105,null,null,"Electrical design (Subsequent Units)",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},106,null,null,"Mechanical design (First Unit)",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},107,null,null,"Mechanical design (Subsequent Units)",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},108,null,null,"Radiators / Coolers",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},109,null,null,"Copper ",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},110,null,null,"Core steel",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},111,null,null,"Tap changer ",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},112,null,null,"HV Bushings",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},113,null,null,"MV Bushings",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},114,null,null,"LV Bushings",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},115,null,null,"Neutral Bushing",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},116,null,null,"Insulation material",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},117,null,null,"Mild steel",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},118,null,null,"Oil",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},119,null,null,"Temperature monitor / Fibre optics",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},120,null,null,"Other Transformer Components (List)",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},121,null,null,"Factory Labour",null,null,0,null,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},122,null,null,"Factory Type Testing First Unit ","Specify - Below",null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},123,null,null,"Factory Routine Testing (Subsequent Units)","Specify - Below",null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},124,null,null,"Foreign transport (If Applicable)",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},125,null,null,"Shipping Sea Freight",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},126,null,null,"Testing during / after Transportation","Specify - Below",null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},127,null,null,"Landing Charges",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},128,null,null,"Liner Release Fee",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},129,null,null,"Import Customs Clearing",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},130,null,null,"Customs Duties",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},131,null,null,"SHE File",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},132,null,null,"Installation",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},133,null,null,"Site commissioning",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},134,null,null,"Site testing","Specify - Below",null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},135]
[{"$nulls":6},"Additional Items",{"$nulls":7},"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},1,null,null,"Sergi Fire & Explosion Prevention",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},2,null,null,"Sergi Installation  &  commissioning",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},3,null,null,"Sprinkler System ",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},4,null,null,"Sprinkler Installation  &  commissioning",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},5,null,null,"On- Line DGA",null,null,0,0,null,"",null,""]
[{"$nulls":3},6,null,null,"Dismantle and removal existing transformer","Generation Units Only",null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},7,null,null,"On-Line Drying System","Transmission Units Only",null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},8,null,null,"Integrated On-Line Condition  Monitoring ",null,null,0,0,null,"",null,""]
[{"$nulls":3},9,null,null,"Storage at Contractors works per month","Distribution Units Only",null,0,0,null,"",null,""]
[{"$nulls":3},10,null,null,"Site Supervisor",null,null,0,0,null,"",null,"",{"$nulls":8},"","","","","","","","","","","","","","","","","","","","",null,"","",null,"","","","","","","","","","","","","","","","","","","","",null,"",""]
[{"$nulls":3},"Final NETT Price Excluding Local Transport (First Unit)",{"$nulls":5},0,{"$nulls":34},0,0,{"$nulls":22},0,0]
[]
[{"$nulls":3},"Final NETT Price Excluding Local Transport (Subsequent Units)",{"$nulls":6},0]
[]
[]
[{"$nulls":3},"DETAILS OF TESTING"]
[{"$nulls":3},"FACTORY TYPE TESTS",null,null,"FACTORY ROUTINE TESTS",{"$nulls":5},"TESTING DURING / AFTER TRANSPORTATION",{"$nulls":3},"SITE TESTING"]

{"sheet":"PS5 Schedule","index":3,"n_rows":91,"n_cols":12,"rows_kept":91,"merged":[[3,4,3,6],[4,7,4,11],[5,4,5,6],[5,7,5,11],[6,4,6,11],[7,4,7,11],[8,4,8,11],[9,4,9,6],[9,7,9,10],[10,4,10,9],[10,10,10,11],[11,4,12,9],[13,4,13,9],[31,4,31,9],[39,4,39,9],[51,4,51,11],[52,4,52,11],[53,4,53,9],[54,4,54,9],[61,4,61,9],[68,4,68,9],[90,5,90,7],[90,9,90,10]],"flags":["formulas_cached_only"]}
[]
[]
[]
[{"$nulls":4},"ENQUIRY No: ",null,null,"MWP1472TX"]
[{"$nulls":7},0]
[{"$nulls":4},"SUPPLIER NAME:",null,null,"NAME OF O.E.M. & FACTORY"]
[{"$nulls":4},"1.1 : PS5  Price Schedule - Page 1"]
[{"$nulls":4},"PRICE SCHEDULE FOR GOODS MANUFACTURED INSIDE AND OUTSIDE THE R.S.A."]
[{"$nulls":4},"SUPPLY, DELIVERY & ERECTION / INSTALLATION (PS5)"]
[{"$nulls":4},"REMARKS:",null,null,"   *  ESKOM may effect this insurance,\n      which Includes war risk Insurance \n   ** Please specify"]
[{"$nulls":4},"ITEM SUPPLIED FROM OUTSIDE RSA",{"$nulls":5},"UNIT REFERENCE"]
[{"$nulls":4},"ITEM NUMBER ACCORDING TO THE ITEM LIST",{"$nulls":5},{"v":10,"d":"010"},{"v":10,"d":"010"}]
[{"$nulls":10},"FIRST UNIT","SUBSEQUENT UNITS"]
[{"$nulls":4},"PS5 ALLOCATION (FROM ACTIVITY SCHEDULE)",{"$nulls":5},"AMOUNT","AMOUNT"]
[{"$nulls":5},"1.","Ex Works Price (Overseas)",{"$nulls":3},"R","R"]
[{"$nulls":5},"2.","Inland Transport Cost ",{"$nulls":3},"R","R"]
[{"$nulls":4},"3.    FOB Price",{"$nulls":4},"(= 1+2)",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":5},"4.","Cost of seafreight",{"$nulls":3},"R","R"]
[{"$nulls":5},"5.","Cost of airfreight",{"$nulls":3},"R","R"]
[{"$nulls":5},"6.","Cost of Marine Insurance*",{"$nulls":3},"R","R"]
[{"$nulls":4},"7.    Total price delivered port R.S.A.",{"$nulls":4},"(= 3+4+5+6)",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":5},"8.","Wharfage",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":5},"9.","Landing charges",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":5},"10.","Customs duties",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":5},"11.","Surcharge",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":4},"12.  Cost of Importation",{"$nulls":4},"(= 8+9+10+11)",0,{"$error":"#VALUE!"}]
[{"$nulls":4},"13.  Other ** ",{"$nulls":4},"(= 13)",0,0]
[{"$nulls":5},"14.","Cost of Rail transport In R.S.A.",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":5},"15.","Cost of Road transport In R.S.A.",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":4},"16.  Cost of transport works to site",{"$nulls":4},"(=14+15)",0,{"$error":"#VALUE!"}]
[{"$nulls":4},"17.  Price (FOB) delivered to works/site",{"$nulls":4},"(= 7+12+13+16)",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ITEM SUPPLIED FROM INSIDE RSA"]
[{"$nulls":5},"18.","F.O.R. Price-Goods manufactured Inside R.S.A.",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":5},"19.","F.O.R. Price-Goods supplied from Imported Items",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":4},"20.  Total F.O.R. price",{"$nulls":4},"(=18+19)",0,{"$error":"#VALUE!"}]
[{"$nulls":5},"21.","Cost of Rail transport",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":5},"22.","Cost of Road transport",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":4},"23.  Cost of transport works to site",{"$nulls":4},"(=21+22)",0,{"$error":"#VALUE!"}]
[{"$nulls":4},"24.  Price (F.O.R.) delivered to site",{"$nulls":4},"(=20+23)",0,{"$error":"#VALUE!"}]
[{"$nulls":4},"SITE WORK (ERECTION/INSTALLATION)"]
[{"$nulls":5},"25.","Local labour",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":5},"26.","Expatriate labour",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":4},"27.  Total price for site work",{"$nulls":4},"(= 25+26)",0,{"$error":"#VALUE!"}]
[{"$nulls":5},"28.","Overseas Engineering Service",{"$nulls":3},"R",{"$error":"#VALUE!"}]
[{"$nulls":5},"29.","Local Engineering Service/Design"]
[{"$nulls":4},"30.  Total price for Engineering Service",{"$nulls":4},"(= 28+29)",0,{"$error":"#VALUE!"}]
[{"$nulls":4},"30.1.  TOTAL PRICE DELIVERED TO SITE Excl. VAT",{"$nulls":4},"(=17+24+27+30)",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":5},"31.","VAT 15%",{"$nulls":3},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"32.  Total price delivered to site including VAT",{"$nulls":4},"(= 30.1+31)",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[{"$nulls":4},"1.2 :  PS5  Price Schedule - Page 2"]
[{"$nulls":4},"NOTE: Complete this ONLY if supplied from OUTSIDE RSA"]
[{"$nulls":4},"ITEM NUMBER ACCORDING TO THE ITEM LIST",{"$nulls":5},{"v":10,"d":"010"},{"v":10,"d":"010"}]
[{"$nulls":4},"CIF Price (Line 7)"]
[{"$nulls":4},"33.    Currency           A:  1  ZAR  =",null,null,"",null,"(FOB)"]
[{"$nulls":4},"34.    Currency           B:  1  ZAR  =",null,null,"",null,"(FOB)",0,0]
[{"$nulls":4},"35.    Currency           C:  1  ZAR  =",null,null,"",null,"(FOB)",0,0]
[{"$nulls":4},"36.     Currency          D:  1  ZAR  =",null,null,"",null,"(Freight)",0,0]
[{"$nulls":4},"37.     Currency          E:  1  ZAR  =",null,null,"",null,"(Ins)",0,0]
[{"$nulls":4},"38.    Total CIF price",{"$nulls":4},"(7 = 33+34+35+36+37)",0,0]
[{"$nulls":4},"Price Expatriate Labour (Line 26)"]
[{"$nulls":4},"39.    Currency           A:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"40.    Currency           B:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"41.     Currency          C:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"42.     Currency          D:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"43.     Currency          E:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"44. Total Price Expatriate Labour",{"$nulls":4},"(26 = 39+40+41+42+43)",0,0]
[{"$nulls":4},"Price Overseas Engineering Services (Line 28)"]
[{"$nulls":4},"45.    Currency           A:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"46.     Currency          B:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"47.     Currency          C:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"48.     Currency          D:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"49.     Currency          E:  1  ZAR  =",null,null,"",null,null,0,0]
[{"$nulls":4},"50.  Total Price O/seas Engineering Services",{"$nulls":4},"(28 = 45+46+47+48+49)",0,0]
[{"$nulls":4},"51.    Foreign content of total price",{"$nulls":4},"(38+44+50)",0,0]
{"$rows_empty":14}
[{"$nulls":5},"SIGNATURE:__________________________",{"$nulls":3},"CAPACITY:___________________________"]

{"sheet":"Option X3","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"merged":[[5,4,5,6],[6,1,6,6],[26,1,26,6]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"ENQUIRY: MWP1472TX"]
[null,0]
[null,"SUPPLIER NAME:",null,null,"NAME OF O.E.M. & FACTORY"]
[null,"MULTIPLE CURRENCIES - SECONDARY OPTION X3"]
[null,"No","Currency Description","Code","Exchange Rate Currency 1,00 =","The exchange rate/s: should be exchange rate/s as at tender advertisement/issue date and the source should be the South African Reserve Bank(SARB)","Source"]
[null,1,"UAE Dirham","AED",{"v":0,"d":"R 0.0000"}]
[null,2,"Austrialian Dollar","AUD",{"v":0,"d":"R 0.0000"}]
[null,3,"Canadian Dollar","CAD",{"v":0,"d":"R 0.0000"}]
[null,4,"Swiss Franc","CHF",{"v":0,"d":"R 0.0000"}]
[null,5,"Danish Krone","DKK",{"v":0,"d":"R 0.0000"}]
[null,6,"European Currency","EUR",{"v":0,"d":"R 0.0000"}]
[null,7,"British Pound","GBP",{"v":0,"d":"R 0.0000"}]
[null,8,"Hong Kong Dollar","HKD",{"v":0,"d":"R 0.0000"}]
[null,9,"Indian Rupee","INR",{"v":0,"d":"R 0.0000"}]
[null,10,"Japanese Yen","JPY",{"v":0,"d":"R 0.0000"}]
[null,11,"Malaysian Ringgit","MYR",{"v":0,"d":"R 0.0000"}]
[null,12,"Norwegian Krone","NOK",{"v":0,"d":"R 0.0000"}]
[null,13,"New Zealand Dollar","NZD",{"v":0,"d":"R 0.0000"}]
[null,14,"Saudi Arabian Riyal","SAR",{"v":0,"d":"R 0.0000"}]
[null,15,"Swedish Krone","SEK",{"v":0,"d":"R 0.0000"}]
[null,16,"Singapore Dollar","SGD",{"v":0,"d":"R 0.0000"}]
[null,17,"United States Dollars","USD",{"v":0,"d":"R 0.0000"}]
[null,18,"South African Rand","ZAR",{"v":1,"d":"R 1.0000"}]
[null,"Note:  Should a currency not be available, contact the Eskom Commercial Department"]

{"sheet":"Option X1","index":5,"n_rows":181,"n_cols":8,"rows_kept":181,"merged":[[3,1,3,2],[4,1,4,5],[5,1,5,2],[5,3,5,5],[6,1,6,5],[24,1,24,2],[25,2,25,5],[26,1,26,5],[36,1,36,2],[37,2,37,5],[38,1,38,5],[48,1,48,2],[49,2,49,5],[50,1,50,5],[61,1,61,2],[62,2,62,5],[63,1,63,5],[73,1,73,2],[74,2,74,5],[75,1,75,5],[85,1,85,2],[86,2,86,5],[87,1,87,5],[97,1,97,2],[98,2,98,5],[99,1,99,5],[110,1,110,2],[111,2,111,5],[112,1,112,5],[122,1,122,2],[123,2,123,5],[124,1,124,5],[134,1,134,2],[135,2,135,5],[136,1,136,5],[146,1,146,2],[147,2,147,5],[148,1,148,5],[158,1,158,2],[159,2,159,5],[160,1,160,5],[170,1,170,2],[171,2,171,5],[172,1,172,5]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"ENQUIRY No: ",null,"MWP1472TX"]
[null,0]
[null,"SUPPLIER NAME:",null,"NAME OF O.E.M. & FACTORY"]
[null,"PRICE ADJUSTMENT FOR INFLATION - SECONDARY OPTION X1"]
[null,"No","Description of Formula"]
[null,"A","????",{"$nulls":4},"A - ????"]
[null,"B","????",{"$nulls":4},"B - ????"]
[null,"C","????",{"$nulls":4},"C - ????"]
[null,"D","????",{"$nulls":4},"D - ????"]
[null,"E","????",{"$nulls":4},"E - ????"]
[null,"F","????",{"$nulls":4},"F - ????"]
[null,"G","????",{"$nulls":4},"G - ????"]
[null,"H","????",{"$nulls":4},"H - ????"]
[null,"I","????",{"$nulls":4},"I - ????"]
[null,"J","????",{"$nulls":4},"J - ????"]
[null,"K","????"]
[null,"L","????"]
[null,"M","????"]
[]
[{"$nulls":3},"BASE DATE FOR INDICES = August 2022"]
[]
[null,"FORMULA No:"]
[null,"A","????"]
[null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (15% minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"B","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"C","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[]
[null,"FORMULA No:"]
[null,"D","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"E","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"F","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"G","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[]
[null,"FORMULA No:"]
[null,"H","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"I","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"J","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"K","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"L","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]
[]
[null,"FORMULA No:"]
[null,"M","????"]
[null,null,"The proportions used to calculate the Price Adjustment Factor are:"]
[null,"Index","Proportion","Description","Base Date","Source (indices prepared by)"]
[null,1,{"v":0.85,"d":"85%"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6,{"v":0.15,"d":"15%"},"Non-adjustable (0.15 minimum)"]
[null,null,{"v":1,"d":"100%"},"Total"]

{"sheet":"Data","index":6,"n_rows":20,"n_cols":6,"rows_kept":20,"flags":["formulas_cached_only"]}
["INX","Description","COST ALLOCATION","ITEM",null,"CPA Data"]
[{"$error":"#VALUE!"},"1.   Ex Works Price (Overseas)","General",10,null,"A-????"]
[{"$error":"#VALUE!"},"2.   Inland Transport Cost ","Design",20,null,"B-????"]
[{"$error":"#VALUE!"},"4.   Cost of seafreight","Procurement",30,null,"C-????"]
[{"$error":"#VALUE!"},"5.   Cost of airfreight","Engineering and manufacture",40,null,"D-????"]
[{"$error":"#VALUE!"},"6.   Cost of Marine Insurance*","Transport / Freight",50,null,"E-????"]
[{"$error":"#VALUE!"},"8.   Wharfage","Construction, Erection, Installation",60,null,"F-????"]
[{"$error":"#VALUE!"},"9.   Landing charges","Commissioning & Testing",70,null,"G-????"]
[{"$error":"#VALUE!"},"10. Customs duties","Inspection (Local/Foreign)",80,null,"H-????"]
[{"$error":"#VALUE!"},"11. Surcharge","Training",90,null,"I-????"]
[{"$error":"#VALUE!"},"14. Cost of Rail transport In R.S.A.","Spares",100,null,"J-????"]
[{"$error":"#VALUE!"},"15. Cost of Road transport In R.S.A.","Local Transport",110,null,"K-????"]
[{"$error":"#VALUE!"},"18. F.O.R. Price-Goods manufactured Inside R.S.A.","Local Storage",120,null,"L-????"]
[{"$error":"#VALUE!"},"19. F.O.R. Price-Goods supplied from Imported Items",{"$nulls":3},"M-????"]
[{"$error":"#VALUE!"},"21. Cost of Rail transport"]
[{"$error":"#VALUE!"},"22. Cost of Road transport"]
[{"$error":"#VALUE!"},"25. Local labour"]
[{"$error":"#VALUE!"},"26. Expatriate labour"]
[{"$error":"#VALUE!"},"28. Overseas Engineering Service"]
[{"$error":"#VALUE!"},"29. Local Engineering Service/Design"]