{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Spares","Summary Costs","A-Overheads","B-Preventative Maint","C-Call Outs","D-Airport Spares","IBs","Summary"],"read":"whole","date_system":"1900"}

{"sheet":"Spares","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"hidden":true,"merged":[[0,0,0,4],[23,0,23,4],[24,0,24,2],[24,3,24,4]]}
["5 Year List of Spares"]
["Spare Part","Qty/year","No. of Years","Amount/spare","Amount for 5 years"]
["160 KV Generator",15,5,{"v":100000,"d":"R100,000.00"},{"$f":"B3*C3*D3","v":{"v":7500000,"d":"R7,500,000.00"}}]
["300 KV Generator",2,3,{"v":1200000,"d":"R1,200,000.00"},{"$f":"B4*C4*D4","v":{"v":7200000,"d":"R7,200,000.00"}}]
["HiTrax",15,5,{"v":80000,"d":"R80,000.00"},{"v":6000000,"d":"R6,000,000.00"}]
[" 6046 XRC ",15,5,{"v":40000,"d":"R40,000.00"},{"v":3000000,"d":"R3,000,000.00"}]
["150150 XRC",2,2,{"v":150000,"d":"R150,000.00"},{"v":600000,"d":"R600,000.00"}]
["Keyboard",15,5,{"v":1200,"d":"R1,200.00"},{"v":90000,"d":"R90,000.00"}]
["Monitor",20,5,{"v":3000,"d":"R3,000.00"},{"v":300000,"d":"R300,000.00"}]
["4 Pin AMD Power Supply",15,5,{"v":7000,"d":"R7,000.00"},{"v":525000,"d":"R525,000.00"}]
["3 Pin AMD Power Supply",15,5,{"v":7000,"d":"R7,000.00"},{"v":525000,"d":"R525,000.00"}]
["Drum Motor",10,5,{"v":12000,"d":"R12,000.00"},{"v":600000,"d":"R600,000.00"}]
["Indicator Lamp",1000,5,{"v":40,"d":"R40.00"},{"v":200000,"d":"R200,000.00"}]
["6046 Conveyor Belt",8,5,{"v":6000,"d":"R6,000.00"},{"v":240000,"d":"R240,000.00"}]
["100100 Conveyor Belt",2,2,{"v":8000,"d":"R8,000.00"},{"v":32000,"d":"R32,000.00"}]
["150150 Conveyor Belt",2,2,{"v":12000,"d":"R12,000.00"},{"v":48000,"d":"R48,000.00"}]
["PI Board",15,5,{"v":32000,"d":"R32,000.00"},{"v":2400000,"d":"R2,400,000.00"}]
["Light Barrier",15,5,{"v":4000,"d":"R4,000.00"},{"v":300000,"d":"R300,000.00"}]
["6046 Lead Curtain",72,5,{"v":250,"d":"R250.00"},{"v":90000,"d":"R90,000.00"}]
["100100 Lead Curtain",30,5,{"v":500,"d":"R500.00"},{"v":75000,"d":"R75,000.00"}]
["150150 Lead Curtain",30,5,{"v":700,"d":"R700.00"},{"v":105000,"d":"R105,000.00"}]
["150150 Tension Roller",2,5,{"v":2500,"d":"R2,500.00"},{"v":25000,"d":"R25,000.00"}]
["Emergency Stop",15,5,{"v":900,"d":"R900.00"},{"v":67500,"d":"R67,500.00"}]
[]
["TOTAL",null,null,{"$f":"SUM(E3:E23)","v":{"v":29922500,"d":"R29,922,500.00"}}]

{"sheet":"Summary Costs","index":1,"n_rows":21,"n_cols":8,"rows_kept":21,"merged":[[5,0,5,7],[6,0,7,0],[6,1,7,1],[7,3,7,6],[20,1,20,6]]}
[]
[]
[]
[]
[]
["Summary"]
["Item No.","Description","Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[{"$nulls":3},"Escalation Percentage at 6%"]
[1,"Sub Total A - Overheads",{"$f":"'A-Overheads'!F12","v":{"v":120000,"d":"R120,000.00"}},{"$f":"C9*1.06","v":{"v":127200,"d":"R127,200.00"}},{"$f":"D9*1.06","v":{"v":134832,"d":"R134,832.00"}},{"$f":"E9*1.06","v":{"v":142921.92,"d":"R142,921.92"}},{"v":151497.23520000002,"d":"R151,497.24"},{"$f":"SUM(C9:G9)","v":{"v":676451.1552,"d":"R676,451.16"}}]
[]
[2,"Sub Total B - Preventative Maintenance",{"$f":"'B-Preventative Maint'!G19","v":0},{"$f":"C11*1.06","v":0},{"$f":"D11*1.06","v":0},{"$f":"E11*1.06","v":0},{"$f":"F11*1.06","v":0},{"$f":"SUM(C11:G11)","v":0}]
[]
[3,"Sub Total C - Callouts",{"$f":"'C-Call Outs'!E6","v":0},{"$f":"C13*1.06","v":0},{"$f":"D13*1.06","v":0},{"$f":"E13*1.06","v":0},{"$f":"F13*1.06","v":0},0]
[]
[4,"Sub Total D - Spares",{"$f":"'D-Airport Spares'!I23","v":0},{"$f":"C15*1.06","v":0},{"$f":"D15*1.06","v":0},{"$f":"E15*1.06","v":0},{"$f":"F15*1.06","v":0},0]
[]
[5,"Provisional Sums (Permits)",{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"$f":"SUM(C17:G17)","v":{"v":250000,"d":"R250,000.00"}}]
[]
[null,"Total Year 1 (Y1)",{"$f":"C9+C11+C13+C15","v":{"v":120000,"d":"R120,000"}},{"$f":"C19*1.06","v":{"v":127200,"d":"R127,200.00"}},{"$f":"D19*1.06","v":{"v":134832,"d":"R134,832.00"}},{"$f":"E19*1.06","v":{"v":142921.92,"d":"R142,921.92"}},{"$f":"F19*1.06","v":{"v":151497.23520000002,"d":"R151,497.24"}},{"v":676451.1552,"d":"R676,451.16"}]
[]
[null,"Total E - Total Maintenance Cost for Five (5) Years to be Carried to the Form of Offer"]

{"sheet":"A-Overheads","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"merged":[[0,1,0,5],[1,1,2,1],[1,4,2,4],[11,1,11,4]]}
[null,"PART A: Contract Overheads"]
[null,"Description"," (a)"," (b)","Unit of measure ","(c) = (a) x (b)"]
[null,null,"No. of units","Price Per Unit",null,"Price per year"]
[null,"Contract Management and Administration (Including all required reporting such as monthly reports, analysis reports, audit reports, spares inventory management reports, etc.)",1,null,"Each",{"$f":"C4*D4","v":0}]
[null,"Office Leasing (overheads, office utilities) - on the airport. Provisional sum. Claimed on proven cost.",12,{"v":7500,"d":"R7,500"},"Each",{"$f":"C5*D5","v":{"v":90000,"d":"R90,000"}}]
[null,"On-demand Remote Support/Hotline services for maintenance, fault troubleshooting and resolution.",1,null,"Each",0]
[null,"Access and Permits Requirements. Provisional sum. Claimed on proven cost.",1,{"v":30000,"d":"R30,000"},"Each",{"v":30000,"d":"R30,000"}]
[null,"Other 1 (Specify)",null,null,"Each",0]
[null,"Other 2 (Specify)",null,null,"Each",0]
[null,"Other 3 (Specify)",null,null,"Each",{"$f":"C10*D10","v":0}]
[]
[null,"Sub Total A - Overheads",{"$nulls":3},{"$f":"SUM(F1:F10)","v":{"v":120000,"d":"R120,000"}}]

{"sheet":"B-Preventative Maint","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"merged":[[0,0,0,6],[1,4,1,6],[13,0,13,1],[15,0,15,1],[16,0,16,3],[18,0,18,5]]}
["PART B : Preventative Maintenance"]
[]
["Machine/Component/System\nName & Type ","Machine / Component\nModel","(a) = Rate","(b) = Number of Services Annually","(c) = QTY ","(d) = a x b","(e) = c x d"]
["1.       Battery Maintenance ",null,0,null,null,{"$f":"$C4*$D4","v":0},{"$f":"E4*F4","v":0}]
["2.       Fire Safety Management",null,0,null,null,{"$f":"$C5*$D5","v":0},{"$f":"E5*F5","v":0}]
["3.       Thermal Management",null,0,null,null,0,0]
["4.       Dynamic / Distributed Monitoring & Control (DMC) or SCADA or Monitoring plant and control platform",null,0,null,null,0,0]
["5.       Software Upgrades",null,0,null,null,0,0]
["6.       Ingress and dust control",null,0,null,null,0,0]
["7.       Sensor cleaning ",null,0,null,null,0,0]
["8.       Configuration and calibration checks",null,0,null,null,0,0]
["9.       Solar plant Inverters",null,0,null,null,0,0]
["10.   Solar plant Software   and controls",null,0,null,null,0,0]
["Other 1 (Specify)",null,0,null,null,0,0]
[null,"Other 2 (Specify)",0,null,null,0,0]
["Other 3 (Specify)",null,0,null,null,0,0]
["Total Equipment",{"$nulls":5},{"$f":"SUM(G4:G16)","v":0}]
[]
["Sub Total B - Preventative Maintenance",{"$nulls":5},{"$f":"G17","v":0}]

{"sheet":"C-Call Outs","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[1,2,2,2],[5,0,5,3],[6,0,7,3],[8,0,8,5],[9,0,10,0],[9,3,10,3],[15,0,15,4]]}
[]
["(a)",null,"Unit of Measure","(b)","(c) = (a) x (b)"]
["Number of Callouts",null,null,"Unit Price","Price per Year  Excluding VAT"]
[null,null,"Each",null,{"$f":"D4*A4","v":0}]
[]
[{"$nulls":4},{"$f":"SUM(E4:E4)","v":0}]
[" Battery Energy Storage Facility Callouts (Includes travelling, travelling time & first hour on site)"]
[]
[" Battery Energy Storage Facility Callouts (Includes travelling, travelling time & first hour on site)"]
["Service Description",null,"(a)","Unit of Measure","(b)","(c) = (a) x (b)"]
[null,"Specify Professional (i.e Engineer, Technician or Electrician)","Number of Callouts",null,"Unit Price","Price per Year Excluding VAT"]
["Call out Fee",null,null,"Each"," R "," R "]
["Call out Fee",null,null,"Each"," R "," R "]
["Call out Fee",null,null,"Each"," R "," R "]
[]
["Sub Total C – Callouts ",{"$nulls":4}," R "]

{"sheet":"D-Airport Spares","index":5,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[0,0,0,8],[1,0,2,0],[1,1,2,1],[22,0,22,7]]}
[]
["Spare Part Description","Spare Part Number","(a)","(b)","(c) ","(d) = (a) x (c)","(e)","(f) = (d) x (e)","(g) = (d) + (f)"]
[null,null,"Reccomended No. of units","Unit of Measure","Price / Unit","Total Excl VAT","Mark-up %","Markup Value Excl VAT ","Total Excl VAT"]
["Fuse ",null,null,"Each",null,{"$f":"E4*C4","v":0},null,{"$f":"F4*G4","v":0},{"$f":"F4+H4","v":0}]
[" Temperature sensor",null,null,"Each",null,{"$f":"E5*C5","v":0},null,{"$f":"F5*G5","v":0},{"$f":"F5+H5","v":0}]
[" Humidity sensor",null,null,"Each",null,{"$f":"E6*C6","v":0},null,0,0]
[" Water Immersion sensor",null,null,"Each",null,0,null,0,0]
[" Smoke detector",null,null,"Each",null,0,null,0,0]
[" Combustible gas detector",null,null,"Each",null,0,null,0,0]
[" Cooling liquid",null,null,"Each",null,0,null,0,0]
["Hybrid Inverter",null,null,"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,{"$f":"E13*C13","v":0},null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
[{"$nulls":3},"Each",null,0,null,0,0]
["Sub Total D - Spares ",{"$nulls":7},{"$f":"SUM(I4:I22)","v":0}]

{"sheet":"IBs","index":6,"n_rows":14,"n_cols":11,"rows_kept":14,"hidden":true}
[]
["Model","ORTIA","CTIA","KSIA","PLZ","GRJ","ELS","BRF","KIM","UPN"," Totals "]
["HS6046si",59,36,21,4,3,4,4,2,1,{"$f":"SUM(B3:J3)","v":134}]
["HS 100100V",2,0,1,0,0,0,0,0,1,4]
["HS 7555 Si",2,0,0,0,0,0,0,1,2,5]
["HS 150150",2,2,1,0,0,0,0,0,0,5]
["HS10080EDts",{"$nulls":3},0,{"$nulls":5},0]
["CEIA-HIPE-PNZ",56,24,22,5,4,4,4,0,3,122]
["IONSCAN 400B",5,2,2,1,1,1,1,2,1,16]
["Matrix Server",1,0,1,0,0,0,0,0,0,2]
["Other AMD",0,1,0,0,0,0,0,0,0,1]
["Other X-ray",0,0,0,2,0,2,0,0,0,4]
["TIP Server",1,2,1,0,0,1,0,0,0,5]
["Total Equipment",{"$f":"SUM(B3:B13)","v":128},67,49,{"$f":"SUM(E3:E13)","v":12},8,12,9,5,8,298]

{"sheet":"Summary","index":7,"n_rows":8,"n_cols":14,"rows_kept":8,"hidden":true}
[{"$nulls":5},"Restrict Bid (incl vat)","Restrict Bid (excl vat)","BOQ","Diff"]
[{"$nulls":4},"PLZ",{"v":496413.68,"d":"496,413.68"},{"$f":"F2/1.15","v":{"v":431664.0695652174,"d":"431,664.07"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"H2-G2","v":{"$error":"#REF!"}},{"$f":"I2/G2","v":{"$error":"#REF!"}},null,{"$f":"I2/5/12","v":{"$error":"#REF!"}}]
[{"$nulls":4},"GRJ",{"v":1730089.56,"d":"1,730,089.56"},{"$f":"F3/1.15","v":{"v":1504425.7043478263,"d":"1,504,425.70"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"H3-G3","v":{"$error":"#REF!"}},{"$f":"I3/G3","v":{"$error":"#REF!"}},null,{"$f":"I3/5/12","v":{"$error":"#REF!"}},null,{"$f":"76000*5","v":380000}]
[{"$nulls":4},"ELS",{"v":3629261.92,"d":"3,629,261.92"},{"v":3155879.930434783,"d":"3,155,879.93"},{"$f":"'Summary Costs'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"I4/5/12","v":{"$error":"#REF!"}}]
[{"$nulls":4},"BFN",{"v":630446.84,"d":"630,446.84"},{"v":548214.6434782608,"d":"548,214.64"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[{"$nulls":4},"KIM",{"v":703751.6,"d":"703,751.60"},{"v":611957.9130434783,"d":"611,957.91"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[{"$nulls":4},"UPN",{"v":2152208.27,"d":"2,152,208.27"},{"v":1871485.4521739131,"d":"1,871,485.45"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[{"$nulls":4},"RAs",{"$f":"SUM(F2:F7)","v":{"v":9342171.87,"d":"9,342,171.87"}},{"$f":"SUM(G2:G7)","v":{"v":8123627.713043479,"d":"8,123,627.71"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]