{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Manual Calculations","Urban Calculation","Rural Calculation","Stellenbosch"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Manual Calculations","index":0,"n_rows":65,"n_cols":8,"rows_kept":65,"hidden":true,"merged":[[23,3,23,6],[26,2,26,5],[27,1,30,2],[31,1,31,4],[45,3,45,6],[48,2,48,5],[49,1,52,2],[53,1,53,4],[56,3,56,6],[59,2,59,5],[60,1,63,2],[64,1,64,4]]}
[]
[{"$nulls":7},"CHIEF DIRECTORATE: SECURITY RISK MANAGEMENT"]
[{"$nulls":7},"Provincial Security Provisioning"]
[]
[]
[]
[null,"Current Amount","Guards Day","Per Guard"]
["Grade A Day",0,0,{"$f":"IF(B8=0,0,(B8/C8))","v":0},{"$nulls":3},{"$f":"A8","v":"Grade A Day"}]
["Grade B Day",{"v":16253.3,"d":"R 16,253.30"},1,{"$f":"IF(B9=0,0,(B9/C9))","v":{"v":16253.3,"d":"R 16,253.30"}},{"$nulls":3},{"$f":"A9","v":"Grade B Day"}]
["Grade C Day",{"v":507693.6,"d":"R 507,693.60"},36,{"$f":"IF(B10=0,0,(B10/C10))","v":{"v":14102.599999999999,"d":"R 14,102.60"}},{"$nulls":3},{"$f":"A10","v":"Grade C Day"}]
["Grade D Day",0,0,{"$f":"IF(B11=0,0,(B11/C11))","v":0},{"$nulls":3},{"$f":"A11","v":"Grade D Day"}]
["Grade E Day",0,0,{"$nulls":4},{"$f":"A12","v":"Grade E Day"}]
[null,{"$f":"SUM(B8:B12)","v":{"v":523946.89999999997,"d":"R 523,946.90"}},{"$f":"SUM(C8:C12)","v":37},{"$f":"SUM(D8:D12)","v":{"v":30355.899999999998,"d":"R 30,355.90"}},{"$nulls":3},{"$f":"A16","v":"Grade A Night"}]
[{"$nulls":7},{"$f":"A17","v":"Grade B Night"}]
[null,"Current Amount","Guards Night","Per Guard",null,"Monthly Cost",null,{"$f":"A18","v":"Grade C Night"}]
["Grade A Night",0,0,{"$f":"IF(B16=0,0,(B16/C16))","v":0},null,{"$f":"SUM(B8,B16)","v":0},null,{"$f":"A19","v":"Grade D Night"}]
["Grade B Night",0,0,{"$f":"IF(B17=0,0,(B17/C17))","v":0},null,{"$f":"SUM(B9,B17)","v":{"v":16253.3,"d":"R 16,253.30"}},null,{"$f":"A20","v":"Grade E Night"}]
["Grade C Night",{"v":244109.8,"d":"R 244,109.80"},17,{"$f":"IF(B18=0,0,(B18/C18))","v":{"v":14359.4,"d":"R 14,359.40"}},null,{"$f":"SUM(B10,B18)","v":{"v":751803.3999999999,"d":"R 751,803.40"}}]
["Grade D Night",0,0,{"$f":"IF(B19=0,0,(B19/C19))","v":0},null,{"$f":"SUM(B11,B19)","v":0}]
["Grade E Night",0,0,null,null,{"$f":"SUM(B12,B20)","v":0}]
[null,{"$f":"SUM(B16:B20)","v":{"v":244109.8,"d":"R 244,109.80"}},{"$f":"SUM(C16:C20)","v":17},{"$f":"SUM(D16:D20)","v":{"v":14359.4,"d":"R 14,359.40"}},null,{"$f":"SUM(F16:F20)","v":{"v":768056.7,"d":"R 768,056.70"}}]
[]
[]
["Heideveld High School",null,null,"Hourly PSIRA rate as of 1 September 2017"]
["Description","PSIRA Grade","Total hours","Rate per hour","Rate per day","Rate per week","Cost per week"]
["Private Security Officer","Grade C Day",4,{"v":34.75,"d":"R 34.75"},{"v":394.82,"d":"R 394.82"},{"$f":"E26*5","v":{"v":1974.1,"d":"R 1,974.10"}},{"$f":"F26*C26","v":{"v":7896.4,"d":"R 7,896.40"}}]
["Transport Included in costing",null,"Cost Breakdown"]
[null,"8 Hours per Day Monday to Friday",null,"2017-09-04","2017-09-29",{"$f":"G26*4","v":{"v":31585.6,"d":"R 31,585.60"}}]
[{"$nulls":3},"2017-10-09","2017-10-27",{"$f":"G26*3","v":{"v":23689.199999999997,"d":"R 23,689.20"}}]
[{"$nulls":3},"2017-10-30","2017-11-24",{"$f":"G26*4","v":{"v":31585.6,"d":"R 31,585.60"}}]
[{"$nulls":3},"2017-11-27","2017-11-30",{"$f":"E26*4*C26","v":{"v":6317.12,"d":"R 6,317.12"}}]
[null,"Total Cost of Outsourced Deployment",{"$nulls":3},{"$f":"SUM(F28:F31)","v":{"v":93177.51999999999,"d":"R 93,177.52"}},null,{"v":394.82,"d":"R 394.82"}]
[]
[]
[]
[]
[null,"Grade B Day","Grade C Day","Grade C Night","Grade D Day","Grade D Day"]
["Cost per month",{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,$A$8:$D$20,4,FALSE))","v":{"v":16253.3,"d":"R 16,253.30"}},{"$f":"IF(C37=\"\",\"\",VLOOKUP(C37,$A$8:$D$20,4,FALSE))","v":{"v":14102.599999999999,"d":"R 14,102.60"}},{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,$A$8:$D$20,4,FALSE))","v":{"v":14359.4,"d":"R 14,359.40"}},{"$f":"IF(E37=\"\",\"\",VLOOKUP(E37,$A$8:$D$20,4,FALSE))","v":0},{"$f":"IF(F37=\"\",\"\",VLOOKUP(F37,$A$8:$D$20,4,FALSE))","v":0}]
["Guards",1,8,4,8,8]
["Cost for guards",{"$f":"IF(B38=\"\",\"\",B38*B39)","v":{"v":16253.3,"d":"R 16,253.30"}},{"$f":"IF(C38=\"\",\"\",C38*C39)","v":{"v":112820.79999999999,"d":"R 112,820.80"}},{"$f":"IF(D38=\"\",\"\",D38*D39)","v":{"v":57437.6,"d":"R 57,437.60"}},{"$f":"IF(E38=\"\",\"\",E38*E39)","v":0},{"$f":"IF(F38=\"\",\"\",F38*F39)","v":0}]
["Period",3,3,3,3,3]
["Cost for period",{"$f":"IF(B40=\"\",\"\",B40*B41)","v":{"v":48759.899999999994,"d":"R 48,759.90"}},{"$f":"IF(C40=\"\",\"\",C40*C41)","v":{"v":338462.39999999997,"d":"R 338,462.40"}},{"$f":"IF(D40=\"\",\"\",D40*D41)","v":{"v":172312.8,"d":"R 172,312.80"}},{"$f":"IF(E40=\"\",\"\",E40*E41)","v":0},{"$f":"IF(F40=\"\",\"\",F40*F41)","v":0}]
[]
[]
[]
["Heideveld High School",null,null,"Hourly PSIRA rate as of 1 September 2017"]
["Description","PSIRA Grade","Total hours","Rate per hour","Rate per day 8 hrs","Rate per day 4 hours"]
["Private Security Officer","Grade C Day",4,{"v":34.75,"d":"R 34.75"},{"v":417.05,"d":"R 417.05"},{"$f":"E48/2","v":{"v":208.525,"d":"R 208.53"}}]
["Transport Included in costing",null,"Cost Breakdown"]
[null,"8 Hours per Day Monday to Friday",null,"September",21,{"$f":"$F$48*E50","v":{"v":4379.025000000001,"d":"R 4,379.03"}},{"$f":"F50*$C$48","v":{"v":17516.100000000002,"d":"R 17,516.10"}}]
[{"$nulls":3},"October",17,{"$f":"$F$48*E51","v":{"v":3544.925,"d":"R 3,544.93"}},{"$f":"F51*$C$48","v":{"v":14179.7,"d":"R 14,179.70"}}]
[{"$nulls":3},"November",22,{"$f":"$F$48*E52","v":{"v":4587.55,"d":"R 4,587.55"}},{"$f":"F52*$C$48","v":{"v":18350.2,"d":"R 18,350.20"}}]
[{"$nulls":3},"Total Days",{"$f":"SUM(E50:E52)","v":60}]
[null,"Total Cost of Outsourced Deployment",{"$nulls":3},{"$f":"SUM(F50:F52)","v":{"v":12511.5,"d":"R 12,511.50"}},{"$f":"SUM(G50:G52)","v":{"v":50046,"d":"R 50,046.00"}}]
[]
[]
["Heideveld High School",null,null,"Hourly PSIRA rate as of 1 September 2017"]
["Description","PSIRA Grade","Total hours","Rate per hour","Rate per day 12 hrs","Rate per day 4 hours"]
["Private Security Officer","Grade C Day",4,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(E59/12)*4","v":{"$error":"#REF!"}}]
["Transport Included in costing",null,"Cost Breakdown"]
[null,"8 Hours per Day Monday to Friday",null,"September",21,{"$f":"$F$59*E61","v":{"$error":"#REF!"}},{"$f":"F61*$C$59","v":{"$error":"#REF!"}}]
[{"$nulls":3},"October",17,{"$f":"$F$59*E62","v":{"$error":"#REF!"}},{"$f":"F62*$C$59","v":{"$error":"#REF!"}}]
[{"$nulls":3},"November",22,{"$f":"$F$59*E63","v":{"$error":"#REF!"}},{"$f":"F63*$C$59","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Total Days",{"$f":"SUM(E61:E63)","v":60}]
[null,"Total Cost of Outsourced Deployment",{"$nulls":3},{"$f":"SUM(F61:F63)","v":{"$error":"#REF!"}},{"$f":"SUM(G61:G63)","v":{"$error":"#REF!"}}]

{"sheet":"Urban Calculation","index":1,"n_rows":94,"n_cols":9,"rows_kept":94,"hidden":true,"merged":[[1,1,2,2],[1,3,2,3],[1,4,1,6],[4,2,4,3],[6,1,6,3],[12,1,13,2],[12,3,13,3],[12,4,12,6],[15,2,15,3],[17,1,17,3],[23,1,24,2],[23,3,24,3],[23,4,23,6],[26,2,26,3],[28,1,28,3],[34,1,35,2],[34,3,35,3],[34,4,34,6],[37,2,37,3],[39,1,39,3],[45,1,46,2],[45,3,46,3],[45,4,45,6],[48,2,48,3],[50,1,50,3],[56,1,57,2],[56,3,57,3],[56,4,56,6],[59,2,59,3],[61,1,61,3],[67,1,68,2],[67,3,68,3],[67,4,67,6],[70,2,70,3],[72,1,72,3],[78,1,79,2],[78,3,79,3],[78,4,78,6],[81,2,81,3],[83,1,83,3],[89,1,91,3],[89,4,89,6]]}
[]
[null,"Day Shift Calculation",null,"Monday to Sunday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Day Shift","excluding nightshift",null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E4*14%","v":{"$error":"#REF!"}},{"$f":"F4*14%","v":{"$error":"#REF!"}},{"$f":"G4*14%","v":{"$error":"#REF!"}}]
[null,{"$f":"B17","v":"Total Direct Cost"},{"$f":"C4","v":"excluding nightshift"},"Per guard",{"$f":"E4+E5","v":{"$error":"#REF!"}},{"$f":"F4+F5","v":{"$error":"#REF!"}},{"$f":"G4+G5","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B6","v":"Total Direct Cost"},{"$f":"C6","v":"excluding nightshift"},{"$f":"D19","v":"per month"},{"$f":"E6*E7","v":{"$error":"#REF!"}},{"$f":"F6*F7","v":{"$error":"#REF!"}},{"$f":"G6*G7","v":{"$error":"#REF!"}}]
[null,{"$f":"B20","v":"Overheads"},{"$f":"C20","v":"(please complete your percentage above in E3)"},null,{"$f":"E8*#REF!","v":{"$error":"#REF!"}},{"$f":"F8*#REF!","v":{"$error":"#REF!"}},{"$f":"G8*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B2","v":"Day Shift Calculation"},{"$f":"D2","v":"Monday to Sunday"},{"$f":"SUM(E8:E9)","v":{"$error":"#REF!"}},{"$f":"SUM(F8:F9)","v":{"$error":"#REF!"}},{"$f":"SUM(G8:G9)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E6,E6+(E6*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F6,F6+(F6*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G6,G6+(G6*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Night Shift Calculation",null,"Monday to Sunday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Night Shift",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E15*14%","v":{"$error":"#REF!"}},{"$f":"F15*14%","v":{"$error":"#REF!"}},{"$f":"G15*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E15+E16","v":{"$error":"#REF!"}},{"$f":"F15+F16","v":{"$error":"#REF!"}},{"$f":"G15+G16","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B17","v":"Total Direct Cost"},null,"per month",{"$f":"E17*E18","v":{"$error":"#REF!"}},{"$f":"F17*F18","v":{"$error":"#REF!"}},{"$f":"G17*G18","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E19*#REF!","v":{"$error":"#REF!"}},{"$f":"F19*#REF!","v":{"$error":"#REF!"}},{"$f":"G19*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B13","v":"Night Shift Calculation"},{"$f":"D13","v":"Monday to Sunday"},{"$f":"SUM(E19:E20)","v":{"$error":"#REF!"}},{"$f":"SUM(F19:F20)","v":{"$error":"#REF!"}},{"$f":"SUM(G19:G20)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E17,E17+(E17*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F17,F17+(F17*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G17,G17+(G17*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Day Shift Calculation",null,"Monday to Friday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Day Shift","excluding Night allowance, Sunday allowance and public holidays",null,{"$f":"#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E26*14%","v":{"$error":"#REF!"}},{"$f":"F26*14%","v":{"$error":"#REF!"}},{"$f":"G26*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E26+E27","v":{"$error":"#REF!"}},{"$f":"F26+F27","v":{"$error":"#REF!"}},{"$f":"G26+G27","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B19","v":"Total Direct Cost"},null,"per month",{"$f":"E28*E29","v":{"$error":"#REF!"}},{"$f":"F28*F29","v":{"$error":"#REF!"}},{"$f":"G28*G29","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E30*#REF!","v":{"$error":"#REF!"}},{"$f":"F30*#REF!","v":{"$error":"#REF!"}},{"$f":"G30*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B24","v":"Day Shift Calculation"},{"$f":"D24","v":"Monday to Friday"},{"$f":"SUM(E30:E31)","v":{"$error":"#REF!"}},{"$f":"SUM(F30:F31)","v":{"$error":"#REF!"}},{"$f":"SUM(G30:G31)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E28,E28+(E28*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F28,F28+(F28*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G28,G28+(G28*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Night Shift Calculation",null,"Monday to Friday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Night Shift","excluding Sunday allowance and public holidays",null,{"$f":"#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E37*14%","v":{"$error":"#REF!"}},{"$f":"F37*14%","v":{"$error":"#REF!"}},{"$f":"G37*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E37+E38","v":{"$error":"#REF!"}},{"$f":"F37+F38","v":{"$error":"#REF!"}},{"$f":"G37+G38","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B39","v":"Total Direct Cost"},null,"per month",{"$f":"E39*E40","v":{"$error":"#REF!"}},{"$f":"F39*F40","v":{"$error":"#REF!"}},{"$f":"G39*G40","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E41*#REF!","v":{"$error":"#REF!"}},{"$f":"F41*#REF!","v":{"$error":"#REF!"}},{"$f":"G41*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B35","v":"Night Shift Calculation"},{"$f":"D35","v":"Monday to Friday"},{"$f":"SUM(E41:E42)","v":{"$error":"#REF!"}},{"$f":"SUM(F41:F42)","v":{"$error":"#REF!"}},{"$f":"SUM(G41:G42)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E39,E39+(E39*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F39,F39+(F39*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G39,G39+(G39*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Day Shift Calculation (10 hour shift)",null,"Monday to Sunday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Day Shift","excluding nightshift",null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E48*14%","v":{"$error":"#REF!"}},{"$f":"F48*14%","v":{"$error":"#REF!"}},{"$f":"G48*14%","v":{"$error":"#REF!"}}]
[null,{"$f":"B61","v":"Total Direct Cost"},{"$f":"C48","v":"excluding nightshift"},"Per guard",{"$f":"E48+E49","v":{"$error":"#REF!"}},{"$f":"F48+F49","v":{"$error":"#REF!"}},{"$f":"G48+G49","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B50","v":"Total Direct Cost"},{"$f":"C50","v":"excluding nightshift"},{"$f":"D63","v":"per month"},{"$f":"E50*E51","v":{"$error":"#REF!"}},{"$f":"F50*F51","v":{"$error":"#REF!"}},{"$f":"G50*G51","v":{"$error":"#REF!"}}]
[null,{"$f":"B64","v":"Overheads"},{"$f":"C64","v":"(please complete your percentage above in E3)"},null,{"$f":"E52*#REF!","v":{"$error":"#REF!"}},{"$f":"F52*#REF!","v":{"$error":"#REF!"}},{"$f":"G52*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B46","v":"Day Shift Calculation (10 hour shift)"},{"$f":"D46","v":"Monday to Sunday"},{"$f":"SUM(E52:E53)","v":{"$error":"#REF!"}},{"$f":"SUM(F52:F53)","v":{"$error":"#REF!"}},{"$f":"SUM(G52:G53)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E50,E50+(E50*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F50,F50+(F50*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G50,G50+(G50*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Night Shift Calculation (10 hour shift)",null,"Monday to Sunday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Night Shift",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E59*14%","v":{"$error":"#REF!"}},{"$f":"F59*14%","v":{"$error":"#REF!"}},{"$f":"G59*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E59+E60","v":{"$error":"#REF!"}},{"$f":"F59+F60","v":{"$error":"#REF!"}},{"$f":"G59+G60","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B61","v":"Total Direct Cost"},null,"per month",{"$f":"E61*E62","v":{"$error":"#REF!"}},{"$f":"F61*F62","v":{"$error":"#REF!"}},{"$f":"G61*G62","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E63*#REF!","v":{"$error":"#REF!"}},{"$f":"F63*#REF!","v":{"$error":"#REF!"}},{"$f":"G63*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B57","v":"Night Shift Calculation (10 hour shift)"},{"$f":"D57","v":"Monday to Sunday"},{"$f":"SUM(E63:E64)","v":{"$error":"#REF!"}},{"$f":"SUM(F63:F64)","v":{"$error":"#REF!"}},{"$f":"SUM(G63:G64)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E61,E61+(E61*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F61,F61+(F61*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G61,G61+(G61*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Night Shift Calculation",null,"Weekends and Public Holidays Only","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Night Shift","excluding ordinary time",null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E70*14%","v":{"$error":"#REF!"}},{"$f":"F70*14%","v":{"$error":"#REF!"}},{"$f":"G70*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E70+E71","v":{"$error":"#REF!"}},{"$f":"F70+F71","v":{"$error":"#REF!"}},{"$f":"G70+G71","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B72","v":"Total Direct Cost"},null,"per month",{"$f":"E72*E73","v":{"$error":"#REF!"}},{"$f":"F72*F73","v":{"$error":"#REF!"}},{"$f":"G72*G73","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E74*#REF!","v":{"$error":"#REF!"}},{"$f":"F74*#REF!","v":{"$error":"#REF!"}},{"$f":"G74*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B68","v":"Night Shift Calculation"},{"$f":"D68","v":"Weekends and Public Holidays Only"},{"$f":"SUM(E74:E75)","v":{"$error":"#REF!"}},{"$f":"SUM(F74:F75)","v":{"$error":"#REF!"}},{"$f":"SUM(G74:G75)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E72,E72+(E72*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F72,F72+(F72*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G72,G72+(G72*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Day Shift Calculation",null,{"$f":"D68","v":"Weekends and Public Holidays Only"},"Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Day Shift","excluding ordinary time and nightshift",null,{"$f":"SUM(#REF!)-#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E81*14%","v":{"$error":"#REF!"}},{"$f":"F81*14%","v":{"$error":"#REF!"}},{"$f":"G81*14%","v":{"$error":"#REF!"}}]
[null,{"$f":"B72","v":"Total Direct Cost"},{"$f":"C81","v":"excluding ordinary time and nightshift"},"Per guard",{"$f":"E81+E82","v":{"$error":"#REF!"}},{"$f":"F81+F82","v":{"$error":"#REF!"}},{"$f":"G81+G82","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B83","v":"Total Direct Cost"},{"$f":"C83","v":"excluding ordinary time and nightshift"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E83*E84","v":{"$error":"#REF!"}},{"$f":"F83*F84","v":{"$error":"#REF!"}},{"$f":"G83*G84","v":{"$error":"#REF!"}}]
[null,{"$f":"B75","v":"Overheads"},{"$f":"C75","v":"(please complete your percentage above in E3)"},null,{"$f":"E85*#REF!","v":{"$error":"#REF!"}},{"$f":"F85*#REF!","v":{"$error":"#REF!"}},{"$f":"G85*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B79","v":"Day Shift Calculation"},{"$f":"D79","v":"Weekends and Public Holidays Only"},{"$f":"SUM(E85:E86)","v":{"$error":"#REF!"}},{"$f":"SUM(F85:F86)","v":{"$error":"#REF!"}},{"$f":"SUM(G85:G86)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E83,E83+(E83*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F83,F83+(F83*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G83,G83+(G83*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Total cost per guard per month",null,null,"Total Cost per month per Grade"]
[{"$nulls":4},{"$f":"SUM(E30,E41,E74,E85,E8,E19,E52,E63)","v":{"$error":"#REF!"}},{"$f":"SUM(F30,F41,F74,F85,F8,F19,F52,F63)","v":{"$error":"#REF!"}},{"$f":"SUM(G30,G41,G74,G85,G8,G19,G52,G63)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E91:H91)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"E32+E43+E76+E87+E10+E21+E54+E65","v":{"$error":"#REF!"}},{"$f":"F32+F43+F76+F87+F10+F21+F54+F65","v":{"$error":"#REF!"}},{"$f":"G32+G43+G76+G87+G10+G21+G54+G65","v":{"$error":"#REF!"}},null,{"$f":"SUM(E92:H92)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"E29+E40+E73+E84+E7+E18+E62+E51","v":{"$error":"#REF!"}},{"$f":"F29+F40+F73+F84+F7+F18+F62+F51","v":{"$error":"#REF!"}},{"$f":"G29+G40+G73+G84+G7+G18+G62+G51","v":{"$error":"#REF!"}},null,{"$f":"I91+('Urban Calculation'!I91*#REF!)","v":{"$error":"#REF!"}}]
[null,"Back to Legend"]

{"sheet":"Rural Calculation","index":2,"n_rows":94,"n_cols":9,"rows_kept":94,"hidden":true,"merged":[[1,1,2,2],[1,3,2,3],[1,4,1,6],[4,2,4,3],[6,1,6,3],[12,1,13,2],[12,3,13,3],[12,4,12,6],[15,2,15,3],[17,1,17,3],[23,1,24,2],[23,3,24,3],[23,4,23,6],[26,2,26,3],[28,1,28,3],[34,1,35,2],[34,3,35,3],[34,4,34,6],[37,2,37,3],[39,1,39,3],[45,1,46,2],[45,3,46,3],[45,4,45,6],[48,2,48,3],[50,1,50,3],[56,1,57,2],[56,3,57,3],[56,4,56,6],[59,2,59,3],[61,1,61,3],[67,1,68,2],[67,3,68,3],[67,4,67,6],[70,2,70,3],[72,1,72,3],[78,1,79,2],[78,3,79,3],[78,4,78,6],[81,2,81,3],[83,1,83,3],[89,1,91,3],[89,4,89,6]]}
[]
[null,"Day Shift Calculation",null,"Monday to Sunday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Day Shift","excluding nightshift",null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E4*14%","v":{"$error":"#REF!"}},{"$f":"F4*14%","v":{"$error":"#REF!"}},{"$f":"G4*14%","v":{"$error":"#REF!"}}]
[null,{"$f":"B17","v":"Total Direct Cost"},{"$f":"C4","v":"excluding nightshift"},"Per guard",{"$f":"E4+E5","v":{"$error":"#REF!"}},{"$f":"F4+F5","v":{"$error":"#REF!"}},{"$f":"G4+G5","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B6","v":"Total Direct Cost"},{"$f":"C6","v":"excluding nightshift"},{"$f":"D19","v":"per month"},{"$f":"E6*E7","v":{"$error":"#REF!"}},{"$f":"F6*F7","v":{"$error":"#REF!"}},{"$f":"G6*G7","v":{"$error":"#REF!"}}]
[null,{"$f":"B20","v":"Overheads"},{"$f":"C20","v":"(please complete your percentage above in E3)"},null,{"$f":"E8*#REF!","v":{"$error":"#REF!"}},{"$f":"F8*#REF!","v":{"$error":"#REF!"}},{"$f":"G8*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B2","v":"Day Shift Calculation"},{"$f":"D2","v":"Monday to Sunday"},{"$f":"SUM(E8:E9)","v":{"$error":"#REF!"}},{"$f":"SUM(F8:F9)","v":{"$error":"#REF!"}},{"$f":"SUM(G8:G9)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E6,E6+(E6*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F6,F6+(F6*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G6,G6+(G6*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Night Shift Calculation",null,"Monday to Sunday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Night Shift",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E15*14%","v":{"$error":"#REF!"}},{"$f":"F15*14%","v":{"$error":"#REF!"}},{"$f":"G15*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E15+E16","v":{"$error":"#REF!"}},{"$f":"F15+F16","v":{"$error":"#REF!"}},{"$f":"G15+G16","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B17","v":"Total Direct Cost"},null,"per month",{"$f":"E17*E18","v":{"$error":"#REF!"}},{"$f":"F17*F18","v":{"$error":"#REF!"}},{"$f":"G17*G18","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E19*#REF!","v":{"$error":"#REF!"}},{"$f":"F19*#REF!","v":{"$error":"#REF!"}},{"$f":"G19*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B13","v":"Night Shift Calculation"},{"$f":"D13","v":"Monday to Sunday"},{"$f":"SUM(E19:E20)","v":{"$error":"#REF!"}},{"$f":"SUM(F19:F20)","v":{"$error":"#REF!"}},{"$f":"SUM(G19:G20)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E17,E17+(E17*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F17,F17+(F17*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G17,G17+(G17*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Day Shift Calculation",null,"Monday to Friday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Day Shift","excluding Night allowance, Sunday allowance and public holidays",null,{"$f":"#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E26*14%","v":{"$error":"#REF!"}},{"$f":"F26*14%","v":{"$error":"#REF!"}},{"$f":"G26*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E26+E27","v":{"$error":"#REF!"}},{"$f":"F26+F27","v":{"$error":"#REF!"}},{"$f":"G26+G27","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B19","v":"Total Direct Cost"},null,"per month",{"$f":"E28*E29","v":{"$error":"#REF!"}},{"$f":"F28*F29","v":{"$error":"#REF!"}},{"$f":"G28*G29","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E30*#REF!","v":{"$error":"#REF!"}},{"$f":"F30*#REF!","v":{"$error":"#REF!"}},{"$f":"G30*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B24","v":"Day Shift Calculation"},{"$f":"D24","v":"Monday to Friday"},{"$f":"SUM(E30:E31)","v":{"$error":"#REF!"}},{"$f":"SUM(F30:F31)","v":{"$error":"#REF!"}},{"$f":"SUM(G30:G31)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E28,E28+(E28*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F28,F28+(F28*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G28,G28+(G28*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Night Shift Calculation",null,"Monday to Friday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Night Shift","excluding Sunday allowance and public holidays",null,{"$f":"#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E37*14%","v":{"$error":"#REF!"}},{"$f":"F37*14%","v":{"$error":"#REF!"}},{"$f":"G37*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E37+E38","v":{"$error":"#REF!"}},{"$f":"F37+F38","v":{"$error":"#REF!"}},{"$f":"G37+G38","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B39","v":"Total Direct Cost"},null,"per month",{"$f":"E39*E40","v":{"$error":"#REF!"}},{"$f":"F39*F40","v":{"$error":"#REF!"}},{"$f":"G39*G40","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E41*#REF!","v":{"$error":"#REF!"}},{"$f":"F41*#REF!","v":{"$error":"#REF!"}},{"$f":"G41*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B35","v":"Night Shift Calculation"},{"$f":"D35","v":"Monday to Friday"},{"$f":"SUM(E41:E42)","v":{"$error":"#REF!"}},{"$f":"SUM(F41:F42)","v":{"$error":"#REF!"}},{"$f":"SUM(G41:G42)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E39,E39+(E39*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F39,F39+(F39*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G39,G39+(G39*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Day Shift Calculation (10 hour shift)",null,"Monday to Sunday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Day Shift","excluding nightshift",null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E48*14%","v":{"$error":"#REF!"}},{"$f":"F48*14%","v":{"$error":"#REF!"}},{"$f":"G48*14%","v":{"$error":"#REF!"}}]
[null,{"$f":"B61","v":"Total Direct Cost"},{"$f":"C48","v":"excluding nightshift"},"Per guard",{"$f":"E48+E49","v":{"$error":"#REF!"}},{"$f":"F48+F49","v":{"$error":"#REF!"}},{"$f":"G48+G49","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B50","v":"Total Direct Cost"},{"$f":"C50","v":"excluding nightshift"},{"$f":"D63","v":"per month"},{"$f":"E50*E51","v":{"$error":"#REF!"}},{"$f":"F50*F51","v":{"$error":"#REF!"}},{"$f":"G50*G51","v":{"$error":"#REF!"}}]
[null,{"$f":"B64","v":"Overheads"},{"$f":"C64","v":"(please complete your percentage above in E3)"},null,{"$f":"E52*#REF!","v":{"$error":"#REF!"}},{"$f":"F52*#REF!","v":{"$error":"#REF!"}},{"$f":"G52*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B46","v":"Day Shift Calculation (10 hour shift)"},{"$f":"D46","v":"Monday to Sunday"},{"$f":"SUM(E52:E53)","v":{"$error":"#REF!"}},{"$f":"SUM(F52:F53)","v":{"$error":"#REF!"}},{"$f":"SUM(G52:G53)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E50,E50+(E50*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F50,F50+(F50*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G50,G50+(G50*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Night Shift Calculation (10 hour shift)",null,"Monday to Sunday","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Night Shift",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E59*14%","v":{"$error":"#REF!"}},{"$f":"F59*14%","v":{"$error":"#REF!"}},{"$f":"G59*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E59+E60","v":{"$error":"#REF!"}},{"$f":"F59+F60","v":{"$error":"#REF!"}},{"$f":"G59+G60","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B61","v":"Total Direct Cost"},null,"per month",{"$f":"E61*E62","v":{"$error":"#REF!"}},{"$f":"F61*F62","v":{"$error":"#REF!"}},{"$f":"G61*G62","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E63*#REF!","v":{"$error":"#REF!"}},{"$f":"F63*#REF!","v":{"$error":"#REF!"}},{"$f":"G63*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B57","v":"Night Shift Calculation (10 hour shift)"},{"$f":"D57","v":"Monday to Sunday"},{"$f":"SUM(E63:E64)","v":{"$error":"#REF!"}},{"$f":"SUM(F63:F64)","v":{"$error":"#REF!"}},{"$f":"SUM(G63:G64)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E61,E61+(E61*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F61,F61+(F61*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G61,G61+(G61*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Night Shift Calculation",null,"Weekends and Public Holidays Only","Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Night Shift","excluding ordinary time",null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E70*14%","v":{"$error":"#REF!"}},{"$f":"F70*14%","v":{"$error":"#REF!"}},{"$f":"G70*14%","v":{"$error":"#REF!"}}]
[null,"Total Direct Cost",null,"Per guard",{"$f":"E70+E71","v":{"$error":"#REF!"}},{"$f":"F70+F71","v":{"$error":"#REF!"}},{"$f":"G70+G71","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B72","v":"Total Direct Cost"},null,"per month",{"$f":"E72*E73","v":{"$error":"#REF!"}},{"$f":"F72*F73","v":{"$error":"#REF!"}},{"$f":"G72*G73","v":{"$error":"#REF!"}}]
[null,"Overheads","(please complete your percentage above in E3)",null,{"$f":"E74*#REF!","v":{"$error":"#REF!"}},{"$f":"F74*#REF!","v":{"$error":"#REF!"}},{"$f":"G74*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B68","v":"Night Shift Calculation"},{"$f":"D68","v":"Weekends and Public Holidays Only"},{"$f":"SUM(E74:E75)","v":{"$error":"#REF!"}},{"$f":"SUM(F74:F75)","v":{"$error":"#REF!"}},{"$f":"SUM(G74:G75)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E72,E72+(E72*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F72,F72+(F72*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G72,G72+(G72*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Day Shift Calculation",null,{"$f":"D68","v":"Weekends and Public Holidays Only"},"Grade"]
[{"$nulls":4},"A","B","C"]
[null,"Day Shift","excluding ordinary time and nightshift",null,{"$f":"SUM(#REF!)-#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)-#REF!","v":{"$error":"#REF!"}}]
[null,"14% tax","inclusive",null,{"$f":"E81*14%","v":{"$error":"#REF!"}},{"$f":"F81*14%","v":{"$error":"#REF!"}},{"$f":"G81*14%","v":{"$error":"#REF!"}}]
[null,{"$f":"B72","v":"Total Direct Cost"},{"$f":"C81","v":"excluding ordinary time and nightshift"},"Per guard",{"$f":"E81+E82","v":{"$error":"#REF!"}},{"$f":"F81+F82","v":{"$error":"#REF!"}},{"$f":"G81+G82","v":{"$error":"#REF!"}}]
[null,"Guards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B83","v":"Total Direct Cost"},{"$f":"C83","v":"excluding ordinary time and nightshift"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E83*E84","v":{"$error":"#REF!"}},{"$f":"F83*F84","v":{"$error":"#REF!"}},{"$f":"G83*G84","v":{"$error":"#REF!"}}]
[null,{"$f":"B75","v":"Overheads"},{"$f":"C75","v":"(please complete your percentage above in E3)"},null,{"$f":"E85*#REF!","v":{"$error":"#REF!"}},{"$f":"F85*#REF!","v":{"$error":"#REF!"}},{"$f":"G85*#REF!","v":{"$error":"#REF!"}}]
[null,"Total Cost per month",{"$f":"B79","v":"Day Shift Calculation"},{"$f":"D79","v":"Weekends and Public Holidays Only"},{"$f":"SUM(E85:E86)","v":{"$error":"#REF!"}},{"$f":"SUM(F85:F86)","v":{"$error":"#REF!"}},{"$f":"SUM(G85:G86)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"IF(E83,E83+(E83*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(F83,F83+(F83*#REF!),0)","v":{"$error":"#REF!"}},{"$f":"IF(G83,G83+(G83*#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"Total cost per guard per month",null,null,"Total Cost per month per Grade"]
[{"$nulls":4},{"$f":"SUM(E30,E41,E74,E85,E8,E19,E52,E63)","v":{"$error":"#REF!"}},{"$f":"SUM(F30,F41,F74,F85,F8,F19,F52,F63)","v":{"$error":"#REF!"}},{"$f":"SUM(G30,G41,G74,G85,G8,G19,G52,G63)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E91:H91)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"E32+E43+E76+E87+E10+E21+E54+E65","v":{"$error":"#REF!"}},{"$f":"F32+F43+F76+F87+F10+F21+F54+F65","v":{"$error":"#REF!"}},{"$f":"G32+G43+G76+G87+G10+G21+G54+G65","v":{"$error":"#REF!"}},null,{"$f":"SUM(E92:H92)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"$f":"E29+E40+E73+E84+E7+E18+E62+E51","v":{"$error":"#REF!"}},{"$f":"F29+F40+F73+F84+F7+F18+F62+F51","v":{"$error":"#REF!"}},{"$f":"G29+G40+G73+G84+G7+G18+G62+G51","v":{"$error":"#REF!"}},null,{"$f":"I91+('Urban Calculation'!I91*#REF!)","v":{"$error":"#REF!"}}]
[null,"Back to Legend"]

{"sheet":"Stellenbosch","index":3,"n_rows":127,"n_cols":7,"rows_kept":127,"merged":[[0,0,0,6],[1,0,1,2],[2,0,2,2],[17,0,17,2],[20,0,20,2],[32,0,32,2],[35,0,35,2],[37,0,37,6],[38,0,38,2],[39,0,39,2],[54,0,54,2],[57,0,57,2],[69,0,69,2],[72,0,72,2],[73,0,73,6],[74,0,74,2],[75,0,75,2],[90,0,90,2],[93,0,93,2],[105,0,105,2],[108,0,108,2],[110,1,110,2],[110,3,110,4],[111,1,111,2],[111,3,111,4],[112,1,112,2],[112,3,112,4],[113,1,113,2],[113,3,113,4],[114,1,114,2],[114,3,114,4],[115,1,115,2],[115,3,115,4],[116,0,118,4],[124,0,128,0],[126,1,128,1],[126,2,128,2],[126,3,128,3],[126,4,128,4],[126,5,128,5]]}
["YEAR 1"]
["Stellenbosch Sub District ",null,null,"Estimated Amount of staff","Rate per hour              VAT Inclusive in South African Rand","Monthly Rate per staff                VAT Inclusive in South African Rand","Total Bid Price Montly rate x number of staff x 12 months)"]
["Rendering of cleaning Services: Cleaners",null,null,{"$f":"SUM(D4:D20)","v":27}]
["Don & Pat Bilton Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",1,null,null,{"$f":"D4*F4*12","v":0}]
["Groendal Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,{"$f":"D5*F5*12","v":0}]
["Dirkie Uys Satellite Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Idas Valley Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Klapmuts Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Kylemore Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Aan-het Pad Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Kayamandi Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Pniel Satelite Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Cloetesville Community Day Centre","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Stellenbosch Hospital","Day Shift","Monday to Sunday (12 hours) ",4,null,null,0]
["Stellenbosch Hospital","Night Shift","Monday to Sunday (12 hours)",2,null,null,0]
["Stellenbosch Hospital,EMS","Day Shift","Monday to Friday (8 hours) ex PHD",7,null,null,{"$f":"D16*F16*12","v":0}]
["Stellenbosch Hospital,EMS","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Rendering of cleaning Services: Supervisor/Team leader and Manager"]
["Stellenbosch Hospital- Manager","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},{"$f":"D19*F19*12","v":0}]
["Stellenbosch Hospital- Supervisor","Day Shift","Monday to Friday (8 hours) ex PHD",1,null,null,0]
["Equipment, PPE and Consumables",{"$nulls":4},"Monthly Rate  VAT Inclusive in South African Rand","Total Bid Price Montly rate x number of staff x 12 months)"]
["Don & Pat Bilton Clinic","Per month",{"$nulls":4},{"$f":"F22*12","v":0}]
["Groendal Clinic","Per month",{"$nulls":4},{"$f":"F23*12","v":0}]
["Dirkie Uys  Satellite Clinic","Per month",{"$nulls":4},0]
["Idas Valley Clinic","Per month",{"$nulls":4},0]
["Klapmuts Clinic","Per month",{"$nulls":4},0]
["Kylemore Clinic","Per month",{"$nulls":4},0]
["Aan-het Pad Clinic","Per month",{"$nulls":4},0]
["Kayamandi Clinic","Per month",{"$nulls":4},0]
["Pniel Satelite Clinic","Per month",{"$nulls":4},0]
["Cloetesville Community Day Centre","Per month",{"$nulls":4},0]
["Stellenbosch Hospital","Per month",{"$nulls":4},0]
["Admin and Profit"]
["Stellenbosch Sub District ","Per month"]
[]
["TOTAL LUMPSUM ",{"$nulls":4},{"$f":"SUM(F4:F34)","v":0},{"$f":"SUM(G22:G34)","v":0}]
[]
["YEAR 2"]
["Stellenbosch Sub District ",null,null,"Estimated Amount of staff","Rate per hour              VAT Inclusive in South African Rand","Monthly Rate per staff                VAT Inclusive in South African Rand","Total Bid Price Montly rate x number of staff x 12 months)"]
["Rendering of cleaning Services: Cleaners",null,null,{"$f":"SUM(D41:D57)","v":27}]
["Don & Pat Bilton Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",1,null,null,{"$f":"D41*F41*12","v":0}]
["Groendal Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,{"$f":"D42*F42*12","v":0}]
["Dirkie Uys Satellite Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Idas Valley Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Klapmuts Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Kylemore Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Aan-het Pad Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Kayamandi Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Pniel Satelite Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Cloetesville Community Day Centre","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Stellenbosch Hospital","Day Shift","Monday to Sunday (12 hours) ",4,null,null,0]
["Stellenbosch Hospital","Night Shift","Monday to Sunday (12 hours)",2,null,null,0]
["Stellenbosch Hospital,EMS","Day Shift","Monday to Friday (8 hours) ex PHD",7,null,null,{"$f":"D53*F53*12","v":0}]
["Stellenbosch Hospital,EMS","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Rendering of cleaning Services: Supervisor/Team leader and Manager"]
["Stellenbosch Hospital- Manager","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},{"$f":"D56*F56*12","v":0}]
["Stellenbosch Hospital- Supervisor","Day Shift","Monday to Friday (8 hours) ex PHD",1,null,null,0]
["Equipment, PPE and Consumables",{"$nulls":4},"Monthly Rate  VAT Inclusive in South African Rand","Total Bid Price Montly rate x number of staff x 12 months)"]
["Don & Pat Bilton Clinic","Per month",{"$nulls":4},{"$f":"F59*12","v":0}]
["Groendal Clinic","Per month",{"$nulls":4},{"$f":"F60*12","v":0}]
["Dirkie Uys  SatelliteClinic","Per month",{"$nulls":4},0]
["Idas Valley Clinic","Per month",{"$nulls":4},0]
["Klapmuts Clinic","Per month",{"$nulls":4},0]
["Kylemore Clinic","Per month",{"$nulls":4},0]
["Aan-het Pad Clinic","Per month",{"$nulls":4},0]
["Kayamandi Clinic","Per month",{"$nulls":4},0]
["Pniel Satelite Clinic","Per month",{"$nulls":4},0]
["Cloetesville Community Day Centre","Per month",{"$nulls":4},0]
["Stellenbosch Hospital","Per month",{"$nulls":4},0]
["Admin and Profit"]
["Stellenbosch Sub District","Per month"]
[]
["TOTAL LUMPSUM ",{"$nulls":4},{"$f":"SUM(F41:F71)","v":0}]
["YEAR 3"]
["Stellenbosch Sub District ",null,null,"Estimated Amount of staff","Rate per hour              VAT Inclusive in South African Rand","Monthly Rate per staff                VAT Inclusive in South African Rand","Total Bid Price Montly rate x number of staff x 12 months)"]
["Rendering of cleaning Services: Cleaners",null,null,{"$f":"SUM(D77:D93)","v":27}]
["Don & Pat Bilton Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",1,null,null,{"$f":"D77*F77*12","v":0}]
["Groendal Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,{"$f":"D78*F78*12","v":0}]
["Dirkie Uys Satellite Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Idas Valley Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Klapmuts Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Kylemore Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Aan-het Pad Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Kayamandi Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Pniel Satelite Clinic","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Cloetesville Community Day Centre","Day Shift","Monday to Friday (8 hours) ex PHD",2,null,null,0]
["Stellenbosch Hospital","Day Shift","Monday to Sunday (12 hours) ",4,null,null,0]
["Stellenbosch Hospital","Night Shift","Monday to Sunday (12 hours)",2,null,null,0]
["Stellenbosch Hospital","Day Shift","Monday to Friday (8 hours) ex PHD",7,null,null,{"$f":"D89*F89*12","v":0}]
["Stellenbosch Hospital,EMS","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},0]
["Rendering of cleaning Services: Supervisor/Team leader and Manager"]
["Stellenbosch Hospital- Manager","Day Shift","Monday to Friday (8 hours) ex PHD",{"$nulls":3},{"$f":"D92*F92*12","v":0}]
["Stellenbosch Hospital- Supervisor","Day Shift","Monday to Friday (8 hours) ex PHD",1,null,null,0]
["Equipment, PPE and Consumables",{"$nulls":4},"Monthly Rate  VAT Inclusive in South African Rand","Total Bid Price Montly rate x number of staff x 6 months)"]
["Don & Pat Bilton Clinic","Per month",{"$nulls":4},{"$f":"F95*6","v":0}]
["Groendal Clinic","Per month",{"$nulls":4},{"$f":"F96*6","v":0}]
["Dirkie Uys Satellite Clinic","Per month",{"$nulls":4},0]
["Idas Valley Clinic","Per month",{"$nulls":4},0]
["Klapmuts Clinic","Per month",{"$nulls":4},0]
["Kylemore Clinic","Per month",{"$nulls":4},0]
["Aan-het Pad Clinic","Per month",{"$nulls":4},0]
["Kayamandi Clinic","Per month",{"$nulls":4},0]
["Pniel Satelite Clinic","Per month",{"$nulls":4},0]
["Cloetesville Community Day Centre","Per month",{"$nulls":4},0]
["Stellenbosch Hospital","Per month",{"$nulls":4},0]
["Admin and Profit"]
["Stellenbosch Sub District ","Per month",{"$nulls":4},{"$f":"F107*6","v":0}]
[]
["TOTAL LUMPSUM ",{"$nulls":4},{"$f":"SUM(F77:F107)","v":0},{"$f":"SUM(G95:G107)","v":0}]
[]
["1ST YEAR","2ND YEAR",null,"3RD YEAR"]
["(INCLUSIVE OF VAT)","(INCLUSIVE OF VAT)",null,"(INCLUSIVE OF VAT)"]
[]
["Total cost per month ","Total cost per month ",null,"Total cost per month "]
[]
["Total cost per year","Total cost per year",null,"Total cost per year"]
["Total all-inclusive cost for three (30) Monthss: R (included VAT)"]
[]
[]
[]
[]
[]
["ADHOC SERVICES"]
[]
["Cleaning and/or moving of items between areas; and/or deep cleaning; and/or relief duties.  Please indicate the hourly rate per person( only labour)","07H00-16h00","Monday - Friday ( exl public holidays)",null,"CLEANER","R….......(per hour)"]
[null,"07H00-16h00","Saturday - Sunday( excl public holidays)",null,"CLEANER","R….......(per hour)"]
[null,"07H00-16h00","Public holiday",null,"CLEANER","R….......(per hour)"]