{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Spares","Summary Costs","A-Overheads","B-Preventative Maint","C-Call Outs","D-Cluster Spares","IBs","Summary"],"not_rendered":{"comments":2},"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":19,"n_cols":9,"rows_kept":19,"merged":[[5,1,5,8],[6,1,7,1],[7,4,7,7],[18,1,18,7]]}
[]
[]
[]
[]
[]
[null,"Summary"]
[null,"Description",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[{"$nulls":4},"Escalation at 6%"]
[null,"Sub Total A - Overheads",null,{"$f":"'A-Overheads'!F11","v":{"v":9369,"d":"R9,369.00"}},{"$f":"D9*1.06","v":{"v":9931.140000000001,"d":"R9,931.14"}},{"$f":"E9*1.06","v":{"v":10527.008400000002,"d":"R10,527.01"}},{"$f":"F9*1.06","v":{"v":11158.628904000003,"d":"R11,158.63"}},{"v":11828.146638240003,"d":"R11,828.15"},{"$f":"SUM(D9:H9)","v":{"v":52813.923942240006,"d":"R52,813.92"}}]
[]
[null,"Sub Total B - Preventative Maintenance",null,{"$f":"'B-Preventative Maint'!X73","v":0},{"$f":"D11*1.06","v":0},{"$f":"E11*1.06","v":0},{"$f":"F11*1.06","v":0},{"$f":"G11*1.06","v":0},{"$f":"SUM(D11:H11)","v":0}]
[]
[null,"Sub Total C - Callouts",null,{"$f":"'C-Call Outs'!F14","v":0},{"$f":"D13*1.06","v":0},{"$f":"E13*1.06","v":0},{"$f":"F13*1.06","v":0},{"$f":"G13*1.06","v":0},0]
[]
[null,"Sub Total D - Spares",null,{"$f":"'D-Cluster Spares'!K73","v":{"v":220,"d":"R220.00"}},{"$f":"D15*1.06","v":{"v":233.20000000000002,"d":"R233.20"}},{"$f":"E15*1.06","v":{"v":247.19200000000004,"d":"R247.19"}},{"$f":"F15*1.06","v":{"v":262.0235200000001,"d":"R262.02"}},{"$f":"G15*1.06","v":{"v":277.7449312000001,"d":"R277.74"}},{"v":1240.1604512000004,"d":"R1,240.16"}]
[]
[null,"Total Year 1 (Y1)",null,{"$f":"D9+D11+D13+D15","v":{"v":9589,"d":"R9,589"}},{"$f":"D17*1.06","v":{"v":10164.34,"d":"R10,164.34"}},{"$f":"E17*1.06","v":{"v":10774.200400000002,"d":"R10,774.20"}},{"$f":"F17*1.06","v":{"v":11420.652424000002,"d":"R11,420.65"}},{"$f":"G17*1.06","v":{"v":12105.891569440002,"d":"R12,105.89"}},{"v":54054.08439344,"d":"R54,054.08"}]
[]
[null,"Total E - Total Maintenance Cost for Five (5) Years to be Carried to the Form of Offer",{"$nulls":6},{"$f":"SUM(I9:I18)","v":{"v":108108.16878688,"d":"R108,108.17"}}]

{"sheet":"A-Overheads","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,0,5],[1,1,2,1],[1,4,2,4],[10,1,10,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 required reporting such as monthly reports, spares inventory management reports, office leasing / overheads, office utilities, etc.)",12,null,"Each",{"$f":"C4*D4","v":0}]
[null,"Safety File",9,null,"Each",{"$f":"C5*D5","v":0}]
[null,"Permits (Provisional Sum - Re-measurable)",19,{"v":451,"d":"R451"},"Each",{"$f":"C6*D6","v":{"v":8569,"d":"R8,569"}}]
[null,"Parking (Provisional Sum - Re-measurable) ",4,{"v":200,"d":"R200"},"Each",{"$f":"C7*D7","v":{"v":800,"d":"R800"}}]
[null,"Other 1 (Specify)",null,null,"Each",{"$f":"C8*D8","v":0}]
[null,"Other 2 (Specify)",null,null,"Each",0]
[]
[null,"Sub Total A - Overheads",{"$nulls":3},{"$f":"SUM(F1:F7)","v":{"v":9369,"d":"R9,369"}}]

{"sheet":"B-Preventative Maint","index":3,"n_rows":73,"n_cols":24,"rows_kept":73,"merged":[[0,0,0,23],[1,5,1,23],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,22],[14,0,14,1],[15,0,15,1],[16,0,16,3],[19,5,19,23],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[20,15,20,16],[20,17,20,18],[20,19,20,20],[20,21,20,22],[32,0,32,1],[33,0,33,1],[34,0,34,3],[37,5,37,23],[38,0,39,0],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[38,15,38,16],[38,17,38,18],[38,19,38,20],[38,21,38,22],[50,0,50,1],[51,0,51,1],[52,0,52,3],[55,5,55,23],[56,0,57,0],[56,1,57,1],[56,2,57,2],[56,3,57,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[56,15,56,16],[56,17,56,18],[56,19,56,20],[56,21,56,22],[68,0,68,1],[69,0,69,1],[70,0,70,3],[72,0,72,22]]}
["PART B : Preventative Maintenance"]
[{"$nulls":5},"PART B1 : Monthly Services (Includes travelling and travelling time)"]
["Machine \nName & Type (Only CTX and XCT)","Machine \nModel","Rate","Number of Services",null,"ORTIA",null,"CTIA",null,"KSIA",null,"CDSIA",null,"GRJ",null,"KPA",null,"BFIA",null,"KIM",null,"UPN",null," Total"]
[{"$nulls":5},"QTY","(a) = Amount","QTY","(b) = Amount","QTY","(c) = Amount","QTY","(d) = Amount","QTY","(e) = Amount","QTY","(f) = Amount","QTY","(g) = Amount","QTY","(h) = Amount","QTY","(i) = Amount","(j) = (a) + (b) + (c) + (d) + (e) + (f) + (g) + (h) + (i)"]
[null,null,0,{"$nulls":3},{"$f":"$C5*$F5*$D5","v":0},null,{"$f":"$C5*$H5*$D5","v":0},null,{"$f":"$C5*$J5*$D5","v":0},null,{"$f":"$C5*$L5*$D5","v":0},null,{"$f":"$C5*$N5*$D5","v":0},null,{"$f":"$C5*$P5*$D5","v":0},null,{"$f":"$C5*$R5*$D5","v":0},null,{"$f":"$C5*$T5*$D5","v":0},null,{"$f":"$C5*$V5*$D5","v":0},{"$f":"G5+I5+K5+M5+O5+Q5+S5+U5+W5","v":0}]
[null,null,0,{"$nulls":3},{"$f":"$C6*$F6*$D6","v":0},null,{"$f":"$C6*$H6*$D6","v":0},null,{"$f":"$C6*$J6*$D6","v":0},null,{"$f":"$C6*$L6*$D6","v":0},null,{"$f":"$C6*$N6*$D6","v":0},null,{"$f":"$C6*$P6*$D6","v":0},null,{"$f":"$C6*R6","v":0},null,{"$f":"$C6*$T6*$D6","v":0},null,{"$f":"$C6*$V6*$D6","v":0},{"$f":"G6+I6+K6+M6+O6+Q6+S6+U6+W6","v":0}]
[null,null,0,{"$nulls":3},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,{"$nulls":3},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,{"$nulls":3},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,{"$nulls":3},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,{"$nulls":3},0,null,{"$f":"$C11*$H11*$D11","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,{"$nulls":3},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,{"$nulls":3},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,{"$nulls":3},0,null,0,null,0,null,{"$f":"$C14*$L14*$D14","v":0},null,{"$f":"$C14*$N14*$D14","v":0},null,0,null,0,null,{"$f":"$C14*$T14*$D14","v":0},null,{"$f":"$C14*$V14*$D14","v":0},0]
["Other 1 (Specify)",null,0,{"$nulls":3},0,null,0,null,0,null,{"$f":"$C15*$L15*$D15","v":0},null,{"$f":"$C15*$N15*$D15","v":0},null,0,null,0,null,{"$f":"$C15*$T15*$D15","v":0},null,{"$f":"$C15*$V15*$D15","v":0},0]
["Other 2 (Specify)",null,0,{"$nulls":3},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
["Total Equipment",{"$nulls":4},{"$f":"SUM(F5:F14)","v":0},{"$f":"SUM(G5:G16)","v":0},{"$f":"SUM(H5:H14)","v":0},{"$f":"SUM(I5:I16)","v":0},{"$f":"SUM(J5:J14)","v":0},{"$f":"SUM(K5:K16)","v":0},{"$f":"SUM(L5:L14)","v":0},{"$f":"SUM(M5:M16)","v":0},{"$f":"SUM(N5:N14)","v":0},{"$f":"SUM(O5:O16)","v":0},{"$f":"SUM(P5:P14)","v":0},{"$f":"SUM(Q5:Q16)","v":0},{"$f":"SUM(R5:R14)","v":0},{"$f":"SUM(S5:S16)","v":0},{"$f":"SUM(T5:T14)","v":0},{"$f":"SUM(U5:U16)","v":0},{"$f":"SUM(V5:V14)","v":0},{"$f":"SUM(W5:W16)","v":0},{"$f":"SUM(X5:X16)","v":0}]
[]
[]
[{"$nulls":5},"PART B2 : Quarterley Services (Includes travelling and travelling time)"]
["Machine \nName & Type (Only CTX and XCT)","Machine \nModel","Rate","Number of Services",null,"ORTIA",null,"CTIA",null,"KSIA",null,"CDSIA",null,"GRJ",null,"KPA",null,"BFIA",null,"KIM",null,"UPN",null," Total"]
[{"$nulls":5},"QTY","(a) = Amount","QTY","(b) = Amount","QTY","(c) = Amount","QTY","(d) = Amount","QTY","(e) = Amount","QTY","(f) = Amount","QTY","(g) = Amount","QTY","(h) = Amount","QTY","(i) = Amount","(j) = (a) + (b) + (c) + (d) + (e) + (f) + (g) + (h) + (i)"]
[null,null,0,4,null,null,{"$f":"$C23*$F23*$D23","v":0},null,{"$f":"$C23*$H23*$D23","v":0},null,{"$f":"$C23*$J23*$D23","v":0},null,{"$f":"$C23*$L23*$D23","v":0},null,{"$f":"$C23*$N23*$D23","v":0},null,{"$f":"$C23*$P23*$D23","v":0},null,{"$f":"$C23*$R23*$D23","v":0},null,{"$f":"$C23*$T23*$D23","v":0},null,{"$f":"$C23*$V23*$D23","v":0},{"$f":"G23+I23+K23+M23+O23+Q23+S23+U23+W23","v":0}]
[null,null,0,4,null,null,{"$f":"$C24*$F24*$D24","v":0},null,{"$f":"$C24*$H24*$D24","v":0},null,{"$f":"$C24*$J24*$D24","v":0},null,{"$f":"$C24*$L24*$D24","v":0},null,{"$f":"$C24*$N24*$D24","v":0},null,{"$f":"$C24*$P24*$D24","v":0},null,{"$f":"$C24*$R24*$D24","v":0},null,{"$f":"$C24*$T24*$D24","v":0},null,{"$f":"$C24*$V24*$D24","v":0},{"$f":"G24+I24+K24+M24+O24+Q24+S24+U24+W24","v":0}]
[null,null,0,4,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,4,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,4,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,4,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,4,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,4,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$C30*$T30*$D30","v":0},null,0,0]
[null,null,0,4,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,4,null,null,0,null,0,null,{"$f":"$C32*$J32*$D32","v":0},null,0,null,0,null,{"$f":"$C32*P32","v":0},null,0,null,0,null,0,0]
["Other 1 (Specify)",null,0,4,null,null,0,null,0,null,{"$f":"$C33*$J33*$D33","v":0},null,0,null,0,null,{"$f":"$C33*$P33*$D33","v":0},null,{"$f":"$C33*R33","v":0},null,0,null,0,0]
["Other 2 (Specify)",null,0,4,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
["Total Equipment",{"$nulls":4},{"$f":"SUM(F23:F32)","v":0},{"$f":"SUM(G23:G34)","v":0},{"$f":"SUM(H23:H32)","v":0},{"$f":"SUM(I23:I34)","v":0},{"$f":"SUM(J23:J32)","v":0},{"$f":"SUM(K23:K34)","v":0},{"$f":"SUM(L23:L32)","v":0},{"$f":"SUM(M23:M34)","v":0},{"$f":"SUM(N23:N32)","v":0},{"$f":"SUM(O23:O34)","v":0},{"$f":"SUM(P23:P32)","v":0},{"$f":"SUM(Q23:Q34)","v":0},{"$f":"SUM(R23:R32)","v":0},{"$f":"SUM(S23:S34)","v":0},{"$f":"SUM(T23:T32)","v":0},{"$f":"SUM(U23:U34)","v":0},{"$f":"SUM(V23:V32)","v":0},{"$f":"SUM(W23:W34)","v":0},{"$f":"SUM(X23:X34)","v":0}]
[]
[]
[{"$nulls":5},"PART B3 : Six Monthly Services (Includes travelling and travelling time)"]
["Machine \nName & Type (Only CTX and XCT)","Machine \nModel","Rate","Number of Services",null,"ORTIA",null,"CTIA",null,"KSIA",null,"CDSIA",null,"GRJ",null,"KPA",null,"BFIA",null,"KIM",null,"UPN",null," Total"]
[{"$nulls":5},"QTY","(a) = Amount","QTY","(b) = Amount","QTY","(c) = Amount","QTY","(d) = Amount","QTY","(e) = Amount","QTY","(f) = Amount","QTY","(g) = Amount","QTY","(h) = Amount","QTY","(i) = Amount","(j) = (a) + (b) + (c) + (d) + (e) + (f) + (g) + (h) + (i)"]
[null,null,0,2,null,null,{"$f":"$C41*$F41*$D41","v":0},null,{"$f":"$C41*$H41*$D41","v":0},null,{"$f":"$C41*$J41*$D41","v":0},null,{"$f":"$C41*$L41*$D41","v":0},null,{"$f":"$C41*$N41*$D41","v":0},null,{"$f":"$C41*$P41*$D41","v":0},null,{"$f":"$C41*$R41*$D41","v":0},null,{"$f":"$C41*$T41*$D41","v":0},null,{"$f":"$C41*$V41*$D41","v":0},{"$f":"G41+I41+K41+M41+O41+Q41+S41+U41+W41","v":0}]
[null,null,0,2,null,null,{"$f":"$C42*$F42*$D42","v":0},null,{"$f":"$C42*$H42*$D42","v":0},null,{"$f":"$C42*$J42*$D42","v":0},null,{"$f":"$C42*$L42*$D42","v":0},null,{"$f":"$C42*$N42*$D42","v":0},null,{"$f":"$C42*$P42*$D42","v":0},null,{"$f":"$C42*$R42*$D42","v":0},null,{"$f":"$C42*$T42*$D42","v":0},null,{"$f":"$C42*$V42*$D42","v":0},{"$f":"G42+I42+K42+M42+O42+Q42+S42+U42+W42","v":0}]
[null,null,0,2,null,null,{"$f":"$C43*$F43*$D43","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"G43+I43+K43+M43+O43+Q43+S43+U43+W43","v":0}]
[null,null,0,2,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,2,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,2,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,2,null,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$C47*$R47*$D47","v":0},null,0,null,{"$f":"$C47*$V47*$D47","v":0},0]
[null,null,0,2,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,2,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$C49*$T49*$D49","v":0},null,0,0]
[null,null,0,2,null,null,0,null,{"$f":"$C50*$H50*$D50","v":0},null,0,null,0,null,0,null,{"$f":"$C50*$P50*$D50","v":0},null,0,null,{"$f":"$C50*$T50*$D50","v":0},null,0,0]
["Other 1 (Specify)",null,0,2,null,null,0,null,{"$f":"$C51*$H51*$D51","v":0},null,0,null,0,null,0,null,{"$f":"$C51*$P51*$D51","v":0},null,{"$f":"$C51*R51","v":0},null,{"$f":"$C51*$T51*$D51","v":0},null,0,0]
["Other 2 (Specify)",null,0,2,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
["Total Equipment",{"$nulls":4},{"$f":"SUM(F41:F50)","v":0},{"$f":"SUM(G41:G52)","v":0},{"$f":"SUM(H41:H50)","v":0},{"$f":"SUM(I41:I52)","v":0},{"$f":"SUM(J41:J50)","v":0},{"$f":"SUM(K41:K52)","v":0},{"$f":"SUM(L41:L50)","v":0},{"$f":"SUM(M41:M52)","v":0},{"$f":"SUM(N41:N50)","v":0},{"$f":"SUM(O41:O52)","v":0},{"$f":"SUM(P41:P50)","v":0},{"$f":"SUM(Q41:Q52)","v":0},{"$f":"SUM(R41:R50)","v":0},{"$f":"SUM(S41:S52)","v":0},{"$f":"SUM(T41:T50)","v":0},{"$f":"SUM(U41:U52)","v":0},{"$f":"SUM(V41:V50)","v":0},{"$f":"SUM(W41:W52)","v":0},{"$f":"SUM(X41:X52)","v":0}]
[]
[]
[{"$nulls":5},"PART B4 : Yearly Services (Includes travelling and travelling time)"]
["Machine \nName & Type (Only CTX and XCT)","Machine \nModel","Rate","Number of Services",null,"ORTIA",null,"CTIA",null,"KSIA",null,"CDSIA",null,"GRJ",null,"KPA",null,"BFIA",null,"KIM",null,"UPN",null," Total"]
[{"$nulls":5},"QTY","(a) = Amount","QTY","(b) = Amount","QTY","(c) = Amount","QTY","(d) = Amount","QTY","(e) = Amount","QTY","(f) = Amount","QTY","(g) = Amount","QTY","(h) = Amount","QTY","(i) = Amount","(j) = (a) + (b) + (c) + (d) + (e) + (f) + (g) + (h) + (i)"]
[null,null,0,1,null,null,{"$f":"$C59*$F59*$D59","v":0},null,{"$f":"$C59*$H59*$D59","v":0},null,{"$f":"$C59*$J59*$D59","v":0},null,{"$f":"$C59*L59","v":0},null,{"$f":"$C59*$N59*$D59","v":0},null,{"$f":"$C59*$P59*$D59","v":0},null,{"$f":"$C59*$R59*$D59","v":0},null,{"$f":"$C59*$T59*$D59","v":0},null,{"$f":"$C59*$V59*$D59","v":0},{"$f":"G59+I59+K59+M59+O59+Q59+S59+U59+W59","v":0}]
[null,null,0,1,null,null,{"$f":"$C60*$F60*$D60","v":0},null,{"$f":"$C60*$H60*$D60","v":0},null,{"$f":"$C60*$J60*$D60","v":0},null,{"$f":"$C60*L60","v":0},null,{"$f":"$C60*$N60*$D60","v":0},null,{"$f":"$C60*$P60*$D60","v":0},null,{"$f":"$C60*$R60*$D60","v":0},null,{"$f":"$C60*$T60*$D60","v":0},null,{"$f":"$C60*$V60*$D60","v":0},{"$f":"G60+I60+K60+M60+O60+Q60+S60+U60+W60","v":0}]
[null,null,0,1,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$C61*$T61*$D61","v":0},null,0,0]
[null,null,0,1,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,1,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,1,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,1,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"$C65*$P65*$D65","v":0},null,{"$f":"$C65*$R65*$D65","v":0},null,0,null,{"$f":"$C65*$V65*$D65","v":0},0]
[null,null,0,1,null,null,0,null,{"$f":"$C66*$H66*$D66","v":0},null,0,null,0,null,0,null,0,null,{"$f":"$C66*$R66*$D66","v":0},null,0,null,0,0]
[null,null,0,1,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,0,1,null,null,0,null,0,null,0,null,{"$f":"$C68*L68","v":0},null,0,null,0,null,0,null,{"$f":"$C68*$T68*$D68","v":0},null,0,0]
["Other 1 (Specify)",null,0,1,null,null,0,null,0,null,0,null,{"$f":"$C69*$L69*$D69","v":0},null,0,null,0,null,{"$f":"$C69*R69","v":0},null,{"$f":"$C69*$T69*$D69","v":0},null,0,0]
["Other 2 (Specify)",null,0,1,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
["Total Equipment",{"$nulls":4},{"$f":"SUM(F59:F68)","v":0},{"$f":"SUM(G59:G70)","v":0},{"$f":"SUM(H59:H68)","v":0},{"$f":"SUM(I59:I70)","v":0},{"$f":"SUM(J59:J68)","v":0},{"$f":"SUM(K59:K70)","v":0},{"$f":"SUM(L59:L68)","v":0},{"$f":"SUM(M59:M70)","v":0},{"$f":"SUM(N59:N68)","v":0},{"$f":"SUM(O59:O70)","v":0},{"$f":"SUM(P59:P68)","v":0},{"$f":"SUM(Q59:Q70)","v":0},{"$f":"SUM(R59:R68)","v":0},{"$f":"SUM(S59:S70)","v":0},{"$f":"SUM(T59:T68)","v":0},{"$f":"SUM(U59:U70)","v":0},{"$f":"SUM(V59:V68)","v":0},{"$f":"SUM(W59:W70)","v":0},{"$f":"SUM(X59:X70)","v":0}]
[]
["Sub Total B - Preventative Maintenance",{"$nulls":22},{"$f":"X17+X35+X53+X71","v":0}]

{"sheet":"C-Call Outs","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,0,0,5],[1,0,2,0],[1,1,2,1],[1,3,2,3],[13,0,13,4]]}
["PART C : Security Equipment Callouts (Includes travelling, travelling time & first hour on site)"]
["Airport","Service Description","(a)","Unit of Measure","(b)","(c) = (a) x (b)"]
[null,null,"Number of Callouts",null,"Unit Price","Price per Year  Excluding VAT"]
["ORTIA","Call out Fee",48,"Each",null,{"$f":"E4*C4","v":0}]
["CTIA","Call out Fee",36,"Each",null,{"$f":"E5*C5","v":0}]
["KSIA","Call out Fee",24,"Each",null,0]
["CDSIA","Call out Fee",12,"Each",null,0]
["GRJ","Call out Fee",12,"Each",null,0]
["KPA","Call out Fee",12,"Each",null,0]
["BFIA","Call out Fee",12,"Each",null,0]
["KIM","Call out Fee",12,"Each",null,0]
["UPIA","Call out Fee",12,"Each",null,0]
[]
["Sub Total C - Callouts",{"$nulls":4},{"$f":"SUM(F4:F12)","v":0}]

{"sheet":"D-Cluster Spares","index":5,"n_rows":73,"n_cols":11,"rows_kept":73,"merged":[[0,1,0,10],[1,1,2,1],[1,2,2,2],[1,3,2,3],[3,1,22,1],[22,2,22,9],[25,1,26,1],[25,2,26,2],[25,3,26,3],[27,1,46,1],[46,2,46,9],[49,1,50,1],[49,2,50,2],[49,3,50,3],[51,1,70,1],[70,2,70,9],[72,1,72,9]]}
[null,"PART D : Spare Parts"]
[null,"Cluster 1  ","Spare Part Description","Spare Part Number","(a)","(b)","(c) ","(d) = (a) x (c)","(e)","(f) = (d) x (e)","(g) = (d) + (f)"]
[{"$nulls":4},"Reccomended No. of units","Unit of Measure","Price / Unit","Total Excl VAT","Mark-up Percentage","Markup Value Excl VAT ","Total Excl VAT"]
[null,"Cluster 1 - OR Tambo International (Including BFIA)","Example 1","Example 1",2,"Each",{"v":100,"d":"R100.00"},{"$f":"G4*E4","v":{"v":200,"d":"R200.00"}},{"v":0.1,"d":"10.00%"},{"$f":"H4*I4","v":{"v":20,"d":"R20.00"}},{"$f":"H4+J4","v":{"v":220,"d":"R220.00"}}]
[{"$nulls":5},"Each",null,{"$f":"G5*E5","v":0},null,{"$f":"H5*I5","v":0},{"$f":"H5+J5","v":0}]
[{"$nulls":5},"Each",null,{"$f":"G6*E6","v":0},null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,{"$f":"G13*E13","v":0},null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[null,null,"Total Cluster 1 Spares per Annum",{"$nulls":7},{"$f":"SUM(K4:K22)","v":{"v":220,"d":"R220.00"}}]
[]
[]
[null,"Cluster 2  ","Spare Part Description","Spare Part Number","(a)","(b)","(c) ","(d) = (a) x (c)","(e)","(f) = (d) x (e)","  (g) = (d) + (f)"]
[{"$nulls":4},"Reccomended No. of units","Unit of Measure","Price / Unit","Total Excl VAT","Mark-up Percentage","Markup Value Excl VAT ","Total Excl VAT"]
[null,"Cluster 2 - Cape Town International Airport (Including GRJ / KIM / UPIA)",{"$nulls":3},"Each",null,{"$f":"G28*E28","v":0},null,{"$f":"H28*I28","v":0},{"$f":"H28+J28","v":0}]
[{"$nulls":5},"Each",null,{"$f":"G29*E29","v":0},null,{"$f":"H29*I29","v":0},{"$f":"H29+J29","v":0}]
[{"$nulls":5},"Each",null,{"$f":"G30*E30","v":0},null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[null,null,"Total Cluster 2 Spares per Annum",{"$nulls":7},{"$f":"SUM(K28:K46)","v":0}]
[]
[]
[null,"Cluster 3  ","Spare Part Description","Spare Part Number","(a)","(b)","(c) ","(d) = (a) x (c)","(e)","(f) = (d) x (e)","  (g) = (d) + (f)"]
[{"$nulls":4},"Reccomended No. of units","Unit of Measure","Price / Unit","Total Excl VAT","Mark-up Percentage","Markup Value Excl VAT ","Total Excl VAT"]
[null,"Cluster 3 - King Shaka International Airport (Including CDSIA / KPA)",{"$nulls":3},"Each",null,{"$f":"G52*E52","v":0},null,{"$f":"H52*I52","v":0},{"$f":"H52+J52","v":0}]
[{"$nulls":5},"Each",null,{"$f":"G53*E53","v":0},null,{"$f":"H53*I53","v":0},{"$f":"H53+J53","v":0}]
[{"$nulls":5},"Each",null,{"$f":"G54*E54","v":0},null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,{"$f":"H60+J60","v":0}]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[{"$nulls":5},"Each",null,0,null,0,0]
[null,null,"Total Cluster 3 Spares per Annum",{"$nulls":7},{"$f":"SUM(K52:K70)","v":0}]
[]
[null,"Sub Total D - Spares",{"$nulls":8},{"$f":"K23+K47+K71","v":{"v":220,"d":"R220"}}]

{"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!"}]