{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Proposed Pricing schedule","Sheet2"],"read":"whole","date_system":"1900"}

{"sheet":"Proposed Pricing schedule","index":0,"n_rows":69,"n_cols":18,"rows_kept":69,"merged":[[1,0,1,12],[3,0,3,4],[7,0,7,7],[10,0,10,16],[14,0,16,1],[22,0,25,0],[22,2,25,2],[22,5,25,5],[22,8,25,8],[22,11,25,11],[22,14,25,14],[28,0,30,15],[31,0,31,16],[35,0,38,0],[35,2,38,2],[35,5,38,5],[35,8,38,8],[35,11,38,11],[35,14,38,14],[42,0,44,15],[49,0,52,0],[49,2,52,2],[49,5,52,5],[49,8,52,8],[49,11,52,11],[49,14,52,14],[55,0,57,15],[60,0,60,16],[61,0,61,7],[62,1,62,7],[63,1,63,7],[64,1,64,7],[65,1,65,7],[66,0,68,6]]}
["RFB071/25/26 - PRICING SCHEDULE - ANNEXURE B"]
["Bidders must provide the NHLS with costing information for a 5 years’ contract duration.  The bid price quoted must be inclusive as per the scope of work."]
["Terms and Conditions of pricing are as follows:"]
["a) Bidder must complete the pricing as per tables below."]
["b) Prices must be provided in South African Rand (R)."]
["c) Line Prices are all VAT EXCLUSIVE and TOTAL PRICE is VAT INCLUSIVE."]
["d) Bidder to ensure that the Prices listed below are included on the Total Declared Price."]
["e) Bidders who fail to price according to the costing template provided will be disqualified."]
[]
["PRICING SCHEDULE SECTION A:  Outright Purchase of Building Management System/Environmental Monitoring System (EMS) "]
[]
["Item Description","Unit of Measure","Quantity","Cost VAT excl."," "]
["Outright Purchase of Building Management System/Environmental Moninoring System (EMS)","Each",1,0]
["Programming","Each",1,0]
[" ",null,"Subtotal (VAT Excl.)",{"$f":"D13+D14","v":{"v":0,"d":"R0.00"}}]
[null,null,"VAT (15%)",{"$f":"D14*0.15","v":{"v":0,"d":"R0.00"}}]
[null,null,"Subtotal (VAT Incl.)",{"$f":"D15+D16","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["SECTION B: "]
["Pricing Schedule B1. Service and Maintenance"]
["Item Description",null,"Number of Services and Maintenance per Year","Unit Rate","Total Cost ","Estimated Quantity Year 2","Unit Rate","Total Cost ","Estimated Quantity Year 3","Unit Rate","Total Cost ","Estimated Quantity Year 4","Unit Rate","Total Cost ","Estimated Quantity Year 5","Unit Rate","Total Cost ","Total Annual Cost "]
[{"$nulls":3},"in","Year 1 ",null,"in","Year 2",null,"in","Year 3",null,"in","Year 4",null,"Year 5","Year 5","Year 1 - 5"]
[null,"Unit of measure",null,"Year 1","(VAT Excl.)",null,"Year 2","(VAT Excl.)",null,"Year 3","(VAT Excl.)",null,"Year 4","(VAT Excl.)",null,"in","(VAT Excl.)","(VAT Excl.)"]
[{"$nulls":3},"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)"]
["Preventative Maintenance","Per Maintenance",null,null,{"$f":"D27*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"G27*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"J27*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"M27*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"P27*12","v":{"v":0,"d":"R0.00"}},{"$f":"E27+H27+K27+N27+Q27","v":{"v":0,"d":"R0.00"}}]
["Service","Per service",null,null,{"$f":"D28*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"G28*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"J28*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"M28*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"P28*12","v":{"v":0,"d":"R0.00"}},{"$f":"E28+H28+K28+N28+Q28","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"Subtotal (VAT Excl.)",{"$f":"R27+R28","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT (15%)",{"$f":"R29*15","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"Subtotal (VAT Incl.)",{"$f":"R29+R30","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["Pricing Schedule B2: Calibrators (List of all calibrators)"]
["Item Description",null,"Estimated Quantity Year 1","Unit Rate","Total Cost ","Estimated Quantity Year 2","Unit Rate","Total Cost ","Estimated Quantity Year 3","Unit Rate","Total Cost ","Estimated Quantity Year 4","Unit Rate","Total Cost ","Estimated Quantity Year 5","Unit Rate","Total Cost ","Total Annual Cost "]
[{"$nulls":3},"in","Year 1 ",null,"in","Year 2",null,"in","Year 3",null,"in","Year 4",null,"Year 5","Year 5","Year 1 - 5"]
[null,"Unit of measure",null,"Year 1","(VAT Excl.)",null,"Year 2","(VAT Excl.)",null,"Year 3","(VAT Excl.)",null,"Year 4","(VAT Excl.)",null,"in","(VAT Excl.)","(VAT Excl.)"]
[{"$nulls":3},"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)"]
[null,"Each",null,null,{"$f":"C40*D40","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F40*G40","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I40*J40","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L40*M40","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O40*P40","v":{"v":0,"d":"R0.00"}},{"$f":"E40+H40+K40+N40+Q40","v":{"v":0,"d":"R0.00"}}]
[null,"Each",null,null,{"$f":"C41*D41","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"F41*G41","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"I41*J41","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"L41*M41","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"O41*P41","v":{"v":0,"d":"R0.00"}},{"$f":"E41+H41+K41+N41+Q41","v":{"v":0,"d":"R0.00"}}]
[null,"Each",null,null,{"$f":"C42*D42","v":{"v":0,"d":"R0.00"}},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":16},"Subtotal (VAT Excl.)",{"$f":"R40+R41+R42","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT (15%)",{"$f":"R43*0.15","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"Subtotal (VAT Incl.)",{"$f":"R43+R44","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["SECTION C: TRAINING AND APPLICATION SUPPORT "]
["Item Description",null,"Estimated Officials Year 1","Unit Rate","Total Cost ","Estimated OfficialsYear 2","Unit Rate","Total Cost ","Estimated OfficialsYear 3","Unit Rate","Total Cost ","Estimated Officials Year 4","Unit Rate","Total Cost ","Estimated Officials Year 5","Unit Rate","Total Cost ","Total Annual Cost "]
[{"$nulls":3},"in","Year 1 ",null,"in","Year 2",null,"in","Year 3",null,"in","Year 4",null,"Year 5","Year 5","Year 1 - 5"]
[null,"Unit of measure",null,"Year 1","(VAT Excl.)",null,"Year 2","(VAT Excl.)",null,"Year 3","(VAT Excl.)",null,"Year 4","(VAT Excl.)",null,"in","(VAT Excl.)","(VAT Excl.)"]
[{"$nulls":3},"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)",null,null,"(VAT Excl.)"]
["System operation,  Data review and reporting","Per delegate",6,null,{"$f":"D54*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"G54*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"J54*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"M54*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"P54*12","v":{"v":0,"d":"R0.00"}},{"$f":"E53+H54+K54+N54+Q54","v":{"v":0,"d":"R0.00"}}]
["Administration and configuration","Per delegate",6,null,{"$f":"D55*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"G55*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"J55*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"M55*12","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"P55*12","v":{"v":0,"d":"R0.00"}},{"$f":"E54+H55+K55+N55+Q55","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"Subtotal (VAT Excl.)",{"$f":"R54+R55","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"VAT (15%)",{"$f":"R55*0.15","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"Subtotal (VAT Incl.)",{"$f":"R56+R57","v":{"v":0,"d":"R0.00"}}]
[]
[]
[{"$nulls":17}," "]
["Summary of the pricing scehdule",{"$nulls":7},"Bid Amounts"]
["Pricing Schedule A","Outright Purchase of Building Management System/Environmental Moninoring System (EMS), Installation and Programming",{"$nulls":6},{"$f":"D15","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B1","Service and Maintenance",{"$nulls":6},{"$f":"R29","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule B2","Calibration",{"$nulls":6},{"$f":"R43","v":{"v":0,"d":"R0.00"}}]
["Pricing Schedule C","Training",{"$nulls":6},{"$f":"R56","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":7},"Subtotal (VAT Excl.)",{"$f":"I63+I64+I65+I66","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":7},"VAT (15%)",{"$f":"I67*0.15","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":7},"Subtotal (VAT Incl.)",{"$f":"I67+I68","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Sheet2","index":1,"n_rows":28,"n_cols":20,"rows_kept":28,"hidden":true}
[]
[]
[]
[]
[974513,81209,{"$f":"+B5*12","v":974508}]
[{"$nulls":4},17.69,{"$nulls":6},90.94,938,{"$f":"+M6*L6","v":85301.72}]
[{"$nulls":4},10.88,{"$nulls":7},12]
[{"$nulls":4},62.37,{"$nulls":7},{"$f":"+M6*M7","v":11256}]
[{"$nulls":4},{"$f":"SUM(E6:E8)","v":90.94},938,{"$f":"+F9*E9","v":85301.72},12,{"$f":"+G9*H9","v":1023620.64},{"$nulls":3},5]
[{"$nulls":6},{"$f":"+B5","v":81209},{"$nulls":5},{"$f":"+M8*M9","v":56280}]
[{"$nulls":6},{"$f":"+G10-G9","v":-4092.720000000001},12,{"$f":"+G11*H11","v":-49112.640000000014},{"$nulls":3},{"$f":"+M10*E9","v":5118103.2},5122360,{"$f":"+N11-M11","v":4256.799999999814},{"$f":"+O11/N11","v":8.3102320024360128E-4}]
[{"$nulls":17},{"$f":"4092*2.5%","v":102.30000000000001}]
[{"$nulls":13},938,{"$nulls":3},4092]
[null,null,974513,998876,{"$f":"+D14-C14","v":24363},{"$f":"+E14/C14","v":{"v":0.025000179576875833,"d":"0.03"}},{"$nulls":7},60,{"$nulls":3},{"$f":"+R13+R12","v":4194.3}]
[{"$nulls":13},{"$f":"+N14*N13","v":56280},56330]
[null,null,1023848,{"$f":"+D14","v":998876},{"$f":"+D16-C16","v":-24972},{"$f":"+E16/C16","v":{"v":-0.02439033919097366,"d":"(0.02)"}},{"$nulls":7},{"$f":"+N15-O15","v":-50}]
[{"$nulls":10},{"v":0.025,"d":"2.50%"}]
[null,null,974513,null,{"$f":"+C18","v":974513},null,81209,null,null,{"$f":"+G18","v":81209},{"$f":"+J18*$K$17","v":2030.2250000000001},{"$f":"+K18+J18","v":83239.225}]
[null,{"$f":"+C18/C19-1","v":{"v":-0.024390414826264695,"d":"-2%"}},998876,{"$f":"+C19/C18","v":1.0250001795768757},null,{"$f":"+G18/G19-1","v":{"v":-0.024399327246516056,"d":"-2%"}},83240,{"$f":"+G19/G18","v":{"v":1.025009543277223,"d":"102.5%"}},null,{"$f":"+G19","v":83240},{"$f":"+J19*$K$17","v":2081},{"$f":"+K19+J19","v":85321},{"$nulls":3},938,12,{"$f":"+Q19*P19","v":11256},5,{"$f":"+R19*S19","v":56280}]
[null,{"$f":"+C19/C20-1","v":{"v":-0.024390339190973664,"d":"-2%"}},1023848,{"$f":"+C20/C19","v":1.0250001001125264},null,{"$f":"+G19/G20-1","v":{"v":-0.024390243902439046,"d":"-2%"}},85321,{"$f":"+G20/G19","v":{"v":1.025,"d":"102.5%"}},null,{"$f":"+G20","v":85321},{"$f":"+J20*$K$17","v":2133.025},{"$f":"+K20+J20","v":87454.025}]
[null,{"$f":"+C20/C21-1","v":{"v":-0.024390057973555535,"d":"-2%"}},1049444,{"$f":"+C21/C20","v":1.024999804658504},null,{"$f":"+G20/G21-1","v":{"v":-0.024389965010176762,"d":"-2%"}},87454,{"$f":"+G21/G20","v":{"v":1.0249997069889007,"d":"102.5%"}},null,{"$f":"+G21","v":87454},{"$f":"+J21*$K$17","v":2186.35},{"$f":"+K21+J21","v":89640.35}]
[null,{"$f":"+C21/C22-1","v":{"v":-0.024390153205414267,"d":"-2%"}},1075680,{"$f":"+C22/C21","v":1.0249999047114473},null,{"$f":"+G21/G22-1","v":{"v":-0.024386434627398534,"d":"-2%"}},89640,{"$f":"+G22/G21","v":{"v":1.0249959978960368,"d":"102.5%"}},null,{"$f":"+G22","v":89640},{"$f":"+J22*$K$17","v":2241},{"$f":"+K22+J22","v":91881}]
[]
[null,null,{"$f":"+J18","v":81209},{"$f":"+C24/$E$9","v":892.9953815702661}]
[null,null,{"$f":"+J19","v":83240},{"$f":"+C25/$E$9","v":915.3287882120079},{"$f":"+D25/D24","v":1.025009543277223}]
[null,null,{"$f":"+J20","v":85321},{"$f":"+C26/$E$9","v":938.2120079173081},{"$f":"+D26/D25","v":1.0250000000000001}]
[null,null,{"$f":"+J21","v":87454},{"$f":"+C27/$E$9","v":961.6670332087091},{"$f":"+D27/D26","v":1.0249997069889007}]
[null,null,{"$f":"+J22","v":89640},{"$f":"+C28/$E$9","v":985.7048603474818},{"$f":"+D28/D27","v":1.0249959978960368}]