{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["COST BREAKDOW"],"read":"whole","date_system":"1900"}

{"sheet":"COST BREAKDOW","index":0,"n_rows":128,"n_cols":5,"rows_kept":128,"merged":[[1,0,1,4],[5,0,5,4],[13,0,13,4],[19,0,19,4],[26,0,26,4],[31,0,31,4],[40,0,40,3],[42,0,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[70,0,70,3],[72,1,72,3],[73,1,73,3],[98,0,98,3],[100,1,100,3],[101,1,101,3],[125,0,125,3],[126,0,126,3],[127,0,127,3]]}
[]
["COST BREAKDOW PLANNED MAINTENANCE "]
[]
[null,"TOTAL AMOUNT YEAR 1","TOTAL AMOUNT YEAR 2","TOTAL AMOUNT YEAR 3","OVERALL TOTAL"]
[]
["Sprinkler Services"]
["Routine 1-weekly",null,0,0,{"$f":"+B7+C7+D7","v":0}]
["Routine 2-monthly",0,0,0,{"$f":"+B8+C8+D8","v":0}]
["Routine 3-Quarterly",0,0,0,{"$f":"+B9+C9+D9","v":0}]
["Routine 4-yearly",0,0,0,{"$f":"+B10+C10+D10","v":0}]
[null,{"$f":"+SUM(B7:B10)","v":0},{"$f":"+SUM(C7:C10)","v":0},0,0]
[]
[]
["Fire Extinguishers"]
["Quarterly",null,0,0,{"$f":"+B15+C15+D15","v":0}]
["Annually",0,0,0,{"$f":"+B16+C16+D16","v":0}]
[null,{"$f":"+B15+B16","v":0},{"$f":"+C15+C16","v":0},{"$f":"+D15+D16","v":0},{"$f":"+SUM(B17:D17)","v":0}]
[]
[]
["Gas Suppression "]
["Monthly",0,null,0,{"$f":"+B21+C21+D21","v":0}]
["Quarterly",0,0,0,{"$f":"+B22+C22+D22","v":0}]
["Annually",0,0,0,{"$f":"+B23+C23+D23","v":0}]
[null,{"$f":"+B21+B22+B23","v":0},{"$f":"+C21+C22+C23","v":0},{"$f":"+D21+D22+D23","v":0},{"$f":"+SUM(B24:D24)","v":0}]
[]
[{"$nulls":4},{"$f":"+B26+C26+D26","v":0}]
["Fire Detection"]
["Monthly ",0,0,null,{"$f":"+B28+C28+D28","v":0}]
["Quarterly",0,0,null,{"$f":"+B29+C29+D29","v":0}]
[null,{"$f":"+B28+B29","v":0},{"$f":"+C28+C29","v":0},null,{"$f":"+SUM(B30:D30)","v":0}]
[]
["Evacuation system"]
["Monthly",0,0,null,{"$f":"+B33+C33+D33","v":0}]
["Quarterly",0,0,0,{"$f":"+B34+C34+D34","v":0}]
[null,{"$f":"+SUM(B6:B34)","v":0},{"$f":"+SUM(C6:C34)","v":0}]
[null,{"$f":"+B33+B34+B35","v":0},{"$f":"+C33+C34+C35","v":0},0,{"$f":"+E33+E34+E35","v":0}]
[]
["Total",{"$f":"B36+B30+B24+B17+B11","v":0},{"$f":"C36+C30+C24+C17+C11","v":0},0,{"$f":"+E36+E30+E24+E17+E11","v":0}]
[]
[]
["UNPLANNED MAINTENANCE COSTS"]
[]
["YEAR ONE COST "]
[]
["NUMBER OF INCIDENT /HOURS"]
["MATERIALS"]
[null,"Cost price ","Estimated Hours /incidents","Total"]
[]
[]
["LABOUR"]
["Qualified Technician normal office hours",null,{"$f":"24*12","v":288},{"$f":"+B51*C51","v":0}]
["Assistant normal office hours",null,{"$f":"24*12","v":288},{"$f":"+B52*C52","v":0}]
[]
["Additional Assistant normal hours",null,{"$f":"24*12","v":288},{"$f":"+B54*C54","v":0}]
["Call out fee if applicable office hours",null,288,{"$f":"+B55*C55","v":0}]
[]
[]
["After hours unplanned Maintenance including public Holidays and Weekends"]
["Qualified technician after office hours",null,{"$f":"24*12","v":288},{"$f":"+B59*C59","v":0}]
["Assistant after office hours",null,288,0]
["Callout fee after hours",null,288,0]
[]
["Material Costs"]
["Material costs below R10, 000, Mark up % fill only colum c %",{"v":9000,"d":"R9,000.00"},null,{"$f":"B64*C64","v":0}]
["Material costs between R10, 000 and R40, 000 Mark up % fill only colum c %",{"v":39000,"d":"R39,000.00"},null,{"$f":"B65*C65","v":0}]
["Material costs above R40, 000 Mark up % fill only colum c %",{"v":41000,"d":"R41,000.00"},null,0]
[]
["Total price ",null,null,{"$f":"+SUM(D54:D67)","v":0}]
[]
[]
["YEAR  TWO COST "]
[]
["NUMBER OF INCIDENT /HOURS"]
["MATERIALS"]
[null,"Cost price ","Estimated Hours /incidents","Total"]
[]
[]
["LABOUR"]
["Qualified Technician normal office hours",null,{"$f":"24*12","v":288},{"$f":"+B79*C79","v":0}]
["Assistant normal office hours",null,288,{"$f":"+B80*C80","v":0}]
[]
["Additional Assistant normal hours",null,{"$f":"24*12","v":288},{"$f":"+B82*C82","v":0}]
["Call out fee if applicable office hours",null,288,{"$f":"+B83*C83","v":0}]
[]
[]
["After hours unplanned Maintenance including public Holidays and Weekends"]
["Qualified technician after office hours",null,{"$f":"24*12","v":288},{"$f":"+B87*C87","v":0}]
["Assistant after office hours",null,288,0]
["Callout fee after hours",null,288,0]
[]
["Material Costs"]
["Material costs below R10, 000, Mark up % fill only colum c %",{"v":9000,"d":"R9,000.00"},null,{"$f":"+C92*B92","v":0}]
["Material costs between R10, 000 and R40, 000 Mark up % fill only colum c %",{"v":39000,"d":"R39,000.00"},null,{"$f":"+C93*B93","v":0}]
["Material costs above R40, 000 Mark up % fill only colum c %",{"v":41000,"d":"R41,000.00"},null,0]
[]
["Total price ",null,null,{"$f":"+SUM(D82:D95)","v":0}]
[]
[]
["YEAR THREE COST "]
[]
["NUMBER OF INCIDENT /HOURS"]
["MATERIALS"]
[null,"Cost price ","Estimated Hours /incidents","Total"]
[]
[]
["LABOUR",null,null,{"$f":"+B106*C106","v":0}]
["Qualified Technician normal office hours",null,{"$f":"24*12","v":288},{"$f":"+B107*C107","v":0}]
["Assistant normal office hours",null,288,{"$f":"+B108*C108","v":0}]
[{"$nulls":3},{"$f":"+B109*C109","v":0}]
["Additional Assistant normal hours",null,{"$f":"24*12","v":288},{"$f":"+B110*C110","v":0}]
["Call out fee if applicable office hours",null,288,{"$f":"+B111*C111","v":0}]
[]
[]
["After hours unplanned Maintenance including public Holidays and Weekends"]
["Qualified technician after office hours",null,{"$f":"24*12","v":288},{"$f":"+B115*C115","v":0}]
["Assistant after office hours",null,288,0]
["Callout fee after hours",null,288,0]
[]
["Material Costs"]
["Material costs below R10, 000, Mark up % fill only colum c %",{"v":9000,"d":"R9,000.00"},null,{"$f":"B120*C120","v":0}]
["Material costs between R10, 000 and R40, 000 Mark up % fill only colum c %",{"v":39000,"d":"R39,000.00"},null,{"$f":"B121*C121","v":0}]
["Material costs above R40, 000 Mark up % fill only colum c %",{"v":41000,"d":"R41,000.00"},null,0]
[]
["Total price ",null,null,{"$f":"+SUM(D107:D122)","v":0}]
[]
["Sub-Total",{"$nulls":3},{"$f":"+D124+D96+D68+E38","v":0}]
["VAT 15%",{"$nulls":3},{"$f":"E126*15/100","v":0}]
["GRAND TOTAL",{"$nulls":3},{"$f":"E126+E127","v":0}]