{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Area 1&2","Summary ","JHB-TSHWN","EAST RAND","WEST RAND","VAAL"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Area 1&2","index":0,"n_rows":166,"n_cols":7,"rows_kept":166}
["Item","Description","UNIT","QTY","Rate ","No. of guards","Total"]
[1,"AREA: JOHANNESBURG CLN "]
[1.1,"Minerva"]
["1.1.1","Grade B NKP Security Officer Dayshift including  Armed","month",36,null,1]
["1.1.2","Grade B NKP Security Officer Night shift including  Armed","month",36,null,1]
["1.1.3","Grade C NKP Security Officer Dayshift Armed","month",36,null,2]
["1.1.4","Grade C NKP Security Officer Nightshift Armed","month",36,null,3]
[null,"Subtotal"]
[1.2,"Croydon substation "]
["1.2.1","Grade C  Security Officer Dayshift","month",36,null,2]
["1.2.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[1.3,"Sisimuka Substation "]
["1.3.1","Grade C  Security Officer Dayshift","month",36,null,2]
["1.3.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[1.4,"Jupiter substaion "]
["1.4.1","Grade C  Security Officer Dayshift","month",36,null,2]
["1.4.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[1.5,"Eiger substation"]
["1.5.1","Grade C  Security Officer Dayshift","month",36,null,2]
["1.5.2","Grade C  Security Officer Night shift","month",36,null,4]
[null,"Subtotal"]
[1.6,"Lulamisa"]
["1.6.1","Grade C  Security Officer Dayshift","month",36,null,2]
["1.6.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal",null," "]
[1.7,"Lepini substation"]
["1.7.1","Grade C  Security Officer Dayshift","month",36,null,2]
["1.7.2","Grade C  Security Officer Night shift","month",36,null,3]
["1.7.2","Subtotal"]
[1.8,"Others"]
["1.8.1","4x4 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,1]
["1.8.2","4x2 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,1]
["1.8.3","Armed reaction team of 2 personnel (provide rate per person)","month",36,null,8]
["1.8.4","Armed Supervisor grade B. Dayshift including 4x2 vehicle (all - inclusive costs)  ","month",36,null,1]
["1.8.5","Armed Supervisor grade B. Nightshift including 4x2 vehicle (all - inclusive costs)  ","month",36,null,1]
["1.8.6","SHE officer ","month",36,null,1]
[null,"Subtotal"]
[null,"Total "]
[]
[2,"AREA: TSHWANE"]
[2.1,"Pelly substation"]
["2.1.1","Grade C  Security Officer Dayshift","month",36,null,2]
["2.1.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[2.2,"Kwagga substation"]
["2.2.1","Grade C  Security Officer Dayshift","month",36,null,2]
["2.2.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[2.3,"Njala substation"]
["2.3.1","Grade C  Security Officer Dayshift","month",36,null,2]
["2.3.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[2.4,"Thuso substation"]
["2.4.1","Grade C  Security Officer Dayshift","month",36,null,2]
["2.4.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[2.5,"Others"]
[null,"4x4 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,1]
[null,"4x2 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,1]
[null,"Armed reaction team of 2 personnel (provide rate per person)","month",36,null,8]
[null,"Subtotal"]
[null,"Total"]
[3,"AREA: EASTRAND"]
[3.1,"Esselen substation"]
["3.1.1","Grade C  Security Officer Dayshift","month",36,null,2]
["3.1.2","Grade C  Security Officer Night shift","month",36,null,4]
[null,"Subtotal"]
[3.2,"Benburg substation"]
["3.2.1","Grade C  Security Officer Dayshift","month",36,null,2]
["3.2.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[3.3,"Nevis substation"]
["3.3.1","Grade C  Security Officer Dayshift","month",36,null,2]
["3.3.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[3.4,"Pieterboth substation"]
["3.4.1","Grade C  Security Officer Dayshift","month",36,null,2]
["3.4.2","Grade C  Security Officer Night shift","month",36,null,4]
[null,"Subtotal"]
[3.5,"Brenner substation"]
["3.5.1","Grade C  Security Officer Dayshift","month",36,null,2]
["3.5.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[3.6,"Others"]
[null,"4x4 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,1]
[null,"4x2 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,2]
[null," Armed reaction team of 2 personnel (provide rate per person)","month",36,null,12]
[null,"Subtotal"]
[null,"Total"]
[4,"AREA: VAAL"]
[4.1,"Rigi substation"]
["4.1.1","Grade C  Security Officer Dayshift","month",36,null,2]
["4.1.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[4.2,"Verdun substation"]
["4.2.1","Grade C  Security Officer Dayshift","month",36,null,2]
["4.2.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[4.3,"Glockner substation"]
[null,"Grade C  Security Officer Dayshift","month",36,null,2]
[null,"Grade C  Security Officer Night shift","month",36,null,2]
["4.3.1","Grade C  Security Officer Dayshift for depo","month",36,null,1]
["4.3.2","Grade C  Security Officer Night shift for depo ","month",36,null,2]
[null,"Subtotal"]
[4.4,"Kookfontein substation"]
["4.4.1","Grade C  Security Officer Dayshift","month",36,null,2]
["4.4.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[4.5,"Snowdon substation"]
["4.5.1","Grade C  Security Officer Dayshift","month",36,null,2]
["4.5.2","Grade C  Security Officer Night shift","month",36,null,4]
[null,"Subtotal"]
[4.6,"Others"]
[null,"4x4 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,1]
[null,"4x2 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,2]
[null," Armed reaction team of 2 personnel (provide rate per person)","month",36,null,12]
[null,"Armed Supervisor grade B. Dayshift including 4x2 vehicle (all - inclusive costs)  ","month",36,null,1]
[null,"Armed Supervisor grade B. Nightshift including 4x2 vehicle (all - inclusive costs)  ","month",36,null,1]
[null,"SHE officer ","month",36,null,1]
[null,"Subtotal"]
[null,"Total"]
[null,"AREA: WESTRAND/JHB"]
[5.1,"Etna"]
["5.1.1","Grade C  Security Officer Dayshift","month",36,null,2]
["5.1.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[5.2,"Bernina- Hera"]
["5.2.1","Grade C  Security Officer Dayshift","month",36,null,2]
["5.2.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[5.3,"Taunus"]
["5.3.1","Grade C  Security Officer Dayshift","month",36,null,2]
["5.3.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[5.4,"Westgate"]
["5.4.1","Grade C  Security Officer Dayshift","month",36,null,2]
["5.4.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[5.5,"Princess"]
["5.5.1","Grade C  Security Officer Dayshift","month",36,null,2]
["5.5.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[5.6,"Craighall"]
["5.6.1","Grade C  Security Officer Dayshift","month",36,null,2]
["5.6.2","Grade C  Security Officer Night shift","month",36,null,2]
[null,"Subtotal"]
[5.8,"Others"]
[null,"4x4 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,1]
[null,"4x2 Vehicle for postings and patrols during day shifts, night shift and weekend  including holidays(km)","km",{"$f":"3000*36","v":108000},null,2]
[null," Armed reaction team of 2 personnel (provide rate per person)","month",36,null,12]
[null,"Subtotal"]
[null,"Total"]
[null,"ADDITIONAL OTHER CLN"]
[null,"Polygraph test for eskom staff and other contractors ","no",{"$f":"18*3","v":54},null,1]
[null,"Total"]
[]
[null,"Total"]
[null,"VAT"]
[null,"GRAND TOTAL"]
[]
[]
[]
[{"$nulls":3}," "]

{"sheet":"Summary ","index":1,"n_rows":22,"n_cols":4,"rows_kept":22}
[]
[]
[]
[]
[null,"ITEM ","DESCRIPTION ","Total "]
[null,null,"Provision of security guards services for the duration of 36 months as per the specification."]
[]
[null,1,"AREA: JOHANNESBURG CLN "]
[]
[null,2,"AREA: TSHWANE"]
[]
[null,3,"AREA: EASTRAND "]
[]
[null,4,"AREA: VAAL "]
[]
[null,5,"AREA: WESTRAND/JHB"]
[]
[null,6,"ADDITIONAL OTHER CLN"]
[]
[null,null,"TOTAL "]
[null,null,"VAT AT 15%"]
[null,null,"GRAND TOTAL"]

{"sheet":"JHB-TSHWN","index":2,"n_rows":28,"n_cols":9,"rows_kept":28,"hidden":true}
["ITEM","PAYREF","DESCRIPTION","UNIT","A-QTY","RATE",null,"AMOUNT","WORDING"]
[]
[null,null,"JOHANNESBURG CLN – (TSHWANE AREAS)","H1"]
[null,null,"Pelly substation","H3"]
[null,null,"2x Grade C  Security Officer Dayshift","Month ",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F5*E5","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month ",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F6*E6","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H5+H6","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Kwagga substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month ",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F9*E9","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"2x Grade C  Security Officer Night shift","Month ",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F10*E10","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H9+H10","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Njala substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month ",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"E13*F13","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"2x Grade C  Security Officer Night shift","Month ",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"E14*F14","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H13+H14","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Thuso substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month ",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F17*E17","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month ",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F18*E18","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H17+H18","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Others"]
[null,null,"4x2 Vehicle for patrols (during day shifts, night shift and weekend including holidays) /km  (2vehicle x cln for each shift)","KM",8000,{"v":6,"d":"R6.00"},null,{"$f":"E21*F21","v":{"v":48000,"d":"R48,000.00"}}]
[null,null,"4x4 vehicle ( 1vehicle x cln for each shift)","KM",4000,{"v":6,"d":"R6.00"},null,{"$f":"E22*F22","v":{"v":24000,"d":"R24,000.00"}}]
[null,null,"12 x  Armed reaction team of 2 personnel Day + Nightshift (provide rate Grade C armed  per officer)","Month",36,{"$f":"19917.96*12","v":{"v":239015.52,"d":"R239,015.52"}},null,{"$f":"E23*F23","v":{"v":8604558.719999999,"d":"R8,604,558.72"}}]
[null,null,"Supervisor grade B. Dayshift (all-inclusive costs) 4 x 2 vehicle ","Month",36,{"v":22089.32,"d":"R22,089.32"},null,{"v":795215.52,"d":"R795,215.52"}]
[null,null,"Supervisor grade B. Nightshift (all-inclusive costs)4 x 2 vehicle  ","Month",36,{"v":22089.32,"d":"R22,089.32"},null,{"v":795215.52,"d":"R795,215.52"}]
[null,null,"SHE officer","Month",36,{"v":8000,"d":"R8,000.00"},null,{"$f":"E26*F26","v":{"v":288000,"d":"R288,000.00"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"SUM(H21:H26)","v":{"v":10554989.759999998,"d":"R10,554,989.76"}}]
[null,null,"TOTAL FOR JOHANNESBURG CLN – (TSHWANE AREAS)",{"$nulls":4},{"$f":"H27+H19+H15+H11+H7","v":{"v":24895920.959999993,"d":"R24,895,920.96"}}]

{"sheet":"EAST RAND","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"hidden":true}
["ITEM","PAYREF","DESCRIPTION","UNIT","A-QTY","RATE",null,"AMOUNT","WORDING"]
[]
[null,null,"AREA: EASTRAND"]
[null,null,"Esselen substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F5*E5","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F6*E6","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H5+H6","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Benburg substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F10*E10","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"F11*E11","v":{"v":0,"d":"R0.00"}}]
[null,null,"Nevis substation",{"$nulls":4},{"$f":"H10+H11","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F13*E13","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F14*E14","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H14+H13","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Pieterboth substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F17*E17","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F18*E18","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H17+H18","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Brenner substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F21*E21","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F22*E22","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H21+H22","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Others"]
[null,null,"4x2 Vehicle for patrols during day shifts, night shift and weekend  including holidays(km)","Month",8000,{"v":6,"d":"R6.00"},null,{"$f":"F25*E25","v":{"v":48000,"d":"R48,000.00"}}]
[null,null,"4x2 Vehicle for patrols during day shifts, night shift and weekend  including holidays(km)","Month",4000,{"v":6,"d":"R6.00"},null,{"$f":"F26*E26","v":{"v":24000,"d":"R24,000.00"}}]
[null,null," Armed reaction team of 2 personnel (provide rate per person)"]
[null,null,"Supervisor grade B. Dayshift (all-inclusive costs) 4 x 2 vehicle","Month",36,{"v":22089.32,"d":"R22,089.32"},null,{"$f":"F28*E28","v":{"v":795215.52,"d":"R795,215.52"}}]
[null,null,"Supervisor grade B. Nightshift (all-inclusive costs) 4 x 2 vehicle ","Month",36,{"v":22089.32,"d":"R22,089.32"},null,{"$f":"F29*E29","v":{"v":795215.52,"d":"R795,215.52"}}]
[null,null,"SHE officer","Month",36,{"v":8000,"d":"R8,000.00"},null,{"$f":"F30*E30","v":{"v":288000,"d":"R288,000.00"}}]
[null,null,"Subtotal ",{"$nulls":4},{"$f":"SUM(H25:H30)","v":{"v":1950431.04,"d":"R1,950,431.04"}}]
[null,null,"TOTAL FOR EASTRAND AREA ",{"$nulls":4},{"$f":"H31+H23+H19+H15+H12+H7","v":{"v":22027734.719999995,"d":"R22,027,734.72"}}]

{"sheet":"WEST RAND","index":4,"n_rows":35,"n_cols":9,"rows_kept":35,"hidden":true}
["ITEM","PAYREF","DESCRIPTION","UNIT","A-QTY","RATE",null,"AMOUNT","WORDING"]
[null,null,"AREA: WESTRAND/JHB"]
[null,null,"Etna"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F4*E4","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F5*E5","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H4+H5","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Bernina - Hera"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F8*E8","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"3x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*3","v":{"v":59753.88,"d":"R59,753.88"}},null,{"$f":"F9*E9","v":{"v":2151139.6799999997,"d":"R2,151,139.68"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"SUM(H8:H9)","v":{"v":3585232.8,"d":"R3,585,232.80"}}]
[null,null,"Taunus"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F12*E12","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F13*E13","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H12+H13","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Westgate"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F16*E16","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"2x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F17*E17","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H16+H17","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Princess"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F20*E20","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"2x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F21*E21","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H20+H21","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Craighall"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F24*E24","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"2x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F25*E25","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H24+H25","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Others"]
[null,null,"4x2 Vehicle for patrols during day shifts, night shift and weekend  including holidays(km)","KM",8000,{"v":6,"d":"R6.00"},null,{"$f":"F28*E28","v":{"v":48000,"d":"R48,000.00"}}]
[null,null,"4x4 Vehicle for patrols during day shifts, night shift and weekend  including holidays(km)","KM",4000,{"v":6,"d":"R6.00"},null,{"$f":"E29*F29","v":{"v":24000,"d":"R24,000.00"}}]
[null,null,"12x  Armed reaction team of 2 personnel (provide rate per person)","Month",36,{"$f":"19917.96*12","v":{"v":239015.52,"d":"R239,015.52"}},null,{"$f":"F30*E30","v":8604558.719999999}]
[null,null,"Supervisor grade B. Dayshift  (all-inclusive costs) 4 x 2 vehicle","Month",36,{"v":22089.32,"d":"R22,089.32"},null,{"$f":"E31*F31","v":{"v":795215.52,"d":"R795,215.52"}}]
[null,null,"Supervisor grade B. Nightshift (all-inclusive costs) 4 x 2 vehicle  ","Month",36,{"v":22089.32,"d":"R22,089.32"},null,{"$f":"E32*F32","v":{"v":795215.52,"d":"R795,215.52"}}]
[null,null,"SHE officer","Month",36,{"v":8000,"d":"R8,000.00"},null,{"v":288000,"d":"R288,000.00"}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H6+H10+H14+H18+H22+H26+H33","v":{"v":21082350.24,"d":"R21,082,350.24"}}]
[null,null,"TOTAL  AREA: WESTRAND/JHB",{"$nulls":4},{"$f":"H34+H26+H22+H18+H14+H10+H6","v":{"v":41876700.47999999,"d":"R41,876,700.48"}}]

{"sheet":"VAAL","index":5,"n_rows":33,"n_cols":9,"rows_kept":33,"hidden":true}
["ITEM","PAYREF","DESCRIPTION","UNIT","A-QTY","RATE",null,"AMOUNT","WORDING"]
[null,null,"AREA: VAAL"]
[null,null,"Rigi substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F4*E4","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F5*E5","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H4+H5","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Verdun substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F8*E8","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"2x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F9*E9","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H8+H9","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Glockner substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"v":1434093.1199999999,"d":"R1,434,093.12"}]
[null,null,"4x  C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"v":2868186.2399999998,"d":"R2,868,186.24"}]
[null,null,"Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96","v":{"v":19917.96,"d":"R19,917.96"}},null,{"$f":"F14*E14","v":{"v":717046.5599999999,"d":"R717,046.56"}}]
[null,null,"2x Grade C  Security Officer Nightshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"v":1434093.1199999999,"d":"R1,434,093.12"}]
[null,null,"Subtotal",null,null,{"v":8000,"d":"R8,000.00"},null,{"$f":"H12+H13+H14+H15","v":{"v":6453419.039999999,"d":"R6,453,419.04"}}]
[null,null,"Kookfontein substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F18*E18","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"2x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F19*E19","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H18+H19","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Snowdon substation"]
[null,null,"2x Grade C  Security Officer Dayshift","Month",36,{"$f":"19917.96*2","v":{"v":39835.92,"d":"R39,835.92"}},null,{"$f":"F22*E22","v":{"v":1434093.1199999999,"d":"R1,434,093.12"}}]
[null,null,"4x Grade C  Security Officer Night shift","Month",36,{"$f":"19917.96*4","v":{"v":79671.84,"d":"R79,671.84"}},null,{"$f":"F23*E23","v":{"v":2868186.2399999998,"d":"R2,868,186.24"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"H22+H23","v":{"v":4302279.359999999,"d":"R4,302,279.36"}}]
[null,null,"Others"]
[null,null,"4x2 Vehicle for patrols during day shifts, night shift and weekend  including holidays(km)","Month",36,{"v":6,"d":"R6.00"},null,{"$f":"F26*E26","v":{"v":216,"d":"R216.00"}}]
[null,null,"4x4 Vehicle for patrols during day shifts, night shift and weekend  including holidays(km)","Month",36,{"v":6,"d":"R6.00"},null,{"$f":"F27*E27","v":{"v":216,"d":"R216.00"}}]
[null,null,"12x  Armed reaction team of 2 personnel (provide rate per person)","Month",36,{"$f":"19917.96*12","v":{"v":239015.52,"d":"R239,015.52"}},null,{"v":8604558.719999999,"d":"R8,604,558.72"}]
[null,null,"Supervisor grade B. Dayshift (all-inclusive costs) 4 x 2 vehicle","Month",36,{"v":22089.32,"d":"R22,089.32"},null,{"v":795215.52,"d":"R795,215.52"}]
[null,null,"Supervisor grade B. Nightshift (all-inclusive costs) 4 x 2 vehicle","Month",36,{"v":22089.32,"d":"R22,089.32"},null,{"v":795215.52,"d":"R795,215.52"}]
[null,null,"SHE officer","Month",36,{"v":8000,"d":"R8,000.00"},null,{"$f":"E31*F31","v":{"v":288000,"d":"R288,000.00"}}]
[null,null,"Subtotal",{"$nulls":4},{"$f":"SUM(H26:H31)","v":{"v":10483421.759999998,"d":"R10,483,421.76"}}]
[null,null,"TOTAL FOR VAAL AREA ",{"$nulls":4},{"$f":"H32+H24+H20+H16+H10+H6","v":{"v":31277771.999999993,"d":"R31,277,772.00"}}]