{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Corridors","Current","7% Increase","Envisaged Open Tender","WP-1-GW","WP-2-GE","WP-3 GN","WP-4-WC","WP-5-KZN","WP-6-EC","WP-7-MLPS","WP-8-Ad-hoc"],"read":"whole","date_system":"1900"}

{"sheet":"Corridors","index":0,"n_rows":44,"n_cols":12,"rows_kept":44,"hidden":true}
[]
[]
[null,"#","Region ","Province","Security Complements ","Armed ","Unarmed","Unit Cost Armed ","Unit Cost Unarmed ","Monthly Cost ",null,"Cost Over 36 Months "]
[null,1,"Gautneg North 1 - Mabopane-De Wildt - Winternest","Gauteng ",{"$f":"G4+F4","v":136},38,98,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F4*H4+G4*I4","v":{"v":3763142,"d":"R3,763,142.00"}},{"$f":"J4*12","v":{"v":45157704,"d":"R45,157,704.00"}},{"$f":"J4*36","v":{"v":135473112,"d":"R135,473,112.00"}}]
[null,{"$f":"B4+1","v":2},"Gauteng North 2 - Wolmerton- Belle Ombre- Schutte- Queenswood","Gauteng ",{"$f":"G5+F5","v":232},116,116,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F5*H5+G5*I5","v":{"v":6475004,"d":"R6,475,004.00"}},{"$f":"J5*12","v":{"v":77700048,"d":"R77,700,048.00"}},{"$f":"J5*36","v":{"v":233100144,"d":"R233,100,144.00"}}]
[null,{"$f":"B5+1","v":3},"Gauteng North 3 - Koedoes-Pienaars-Mears","Gauteng ",256,124,132,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":7140492,"d":"R7,140,492.00"},{"v":85685904,"d":"R85,685,904.00"},{"v":257057712,"d":"R257,057,712.00"}]
[null,4,"Gauteng North 4 - Sauls-Pretoria-Pinedene","Gauteng ",232,26,206,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":6377354,"d":"R6,377,354.00"},{"v":76528248,"d":"R76,528,248.00"},{"v":229584744,"d":"R229,584,744.00"}]
[null,"Totals ",null,null,{"$f":"F8+G8","v":856},{"$f":"SUM(F3:F7)","v":304},{"$f":"SUM(G4:G7)","v":552},null,null,{"$f":"J4+J5+J6+J7","v":{"v":23755992,"d":"R23,755,992.00"}},{"$f":"K4+K5+K6+K7","v":{"v":285071904,"d":"R285,071,904.00"}},{"$f":"L4+L5+L6+L7","v":{"v":855215712,"d":"R855,215,712.00"}}]
[null,"#","Region ","Province","Security Complements ","Armed ","Unarmed","Unit Cost Armed ","Unit Cost Unarmed ","Monthly Cost ",null,"Cost Over 36 Months "]
[null,{"$f":"B7+1","v":5},"Gauteng East 1 - Leralla-Olifantsfontein - Oakmoor - Tembisa - Limindlela - Kempton Park - Isando - Rhodesfield - Daveyton - Benoni - Brakpan - Springs - Dunswart - Doornfontein - Nigel  - Kaalfontein - Ravensklip - Elandsfontein - Germiston","Gauteng ",{"$f":"F10+G10","v":190},90,100,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"H10*F10+G10*I10","v":{"v":5297380,"d":"R5,297,380.00"}},{"$f":"J10*12","v":{"v":63568560,"d":"R63,568,560.00"}},{"$f":"J10*32","v":{"v":169516160,"d":"R169,516,160.00"}}]
[null,{"$f":"B10+1","v":6},"Gauteng East 2 - Ravensklip-Germiston-George Koch","Gauteng ",{"$f":"F11+G11","v":200},100,100,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"H11*F11+G11*I11","v":{"v":5581900,"d":"R5,581,900.00"}},{"$f":"J11*12","v":{"v":66982800,"d":"R66,982,800.00"}},{"$f":"J11*32","v":{"v":178620800,"d":"R178,620,800.00"}}]
[null,7,"Gauteng East 3 - Delmore - Daveyton - Nigel ","Gauteng ",301,136,165,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":8385027,"d":"R8,385,027.00"},{"v":100620324,"d":"R100,620,324.00"},{"v":268320864,"d":"R268,320,864.00"}]
[null,8,"Gauteng East 4 - Kwesine- Wadeville- Elsburg- Vereeniging ","Gauteng ",300,135,165,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":8356575,"d":"R8,356,575.00"},{"v":100278900,"d":"R100,278,900.00"},{"v":267410400,"d":"R267,410,400.00"}]
[null,"Totals ",null,null,{"$f":"F14+G14","v":991},{"$f":"SUM(F10:F13)","v":461},530,null,null,{"$f":"J10+J11+J12+J13","v":{"v":27620882,"d":"R27,620,882.00"}},{"$f":"K10+K11+K12+K13","v":{"v":331450584,"d":"R331,450,584.00"}},{"$f":"L10+L11+L12+L13","v":{"v":883868224,"d":"R883,868,224.00"}}]
[null,"#","Region ","Province","Security Complements ","Armed ","Unarmed","Unit Cost Armed ","Unit Cost Unarmed ","Monthly Cost ",null,"Cost Over 36 Months "]
[null,{"$f":"B13+1","v":9},"Gautneg West  1 - Mlamlankunzi - Midway -Vereeniging ","Gauteng ",{"$f":"F16+G16","v":174},84,90,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F16*H16+G16*I16","v":{"v":4852998,"d":"R4,852,998.00"}},{"$f":"J16*12","v":{"v":58235976,"d":"R58,235,976.00"}},{"$f":"J16*36","v":{"v":174707928,"d":"R174,707,928.00"}}]
[null,10,"Gauteng West 2 -Langlaagte-New Canada- Naledi","Gauteng ",{"$f":"F17+G17","v":300},120,180,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F17*H17+G17*I17","v":{"v":8340300,"d":"R8,340,300.00"}},{"$f":"J17*12","v":{"v":100083600,"d":"R100,083,600.00"}},{"$f":"J17*36","v":{"v":300250800,"d":"R300,250,800.00"}}]
[null,11,"Gauteng West 3 - Industria- Roodepport- Randfontein - Oberlholser ","Gauteng ",204,76,128,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":5665328,"d":"R5,665,328.00"},{"v":67983936,"d":"R67,983,936.00"},{"v":203951808,"d":"R203,951,808.00"}]
[null,12,"Gauteng West 4 - Langlaate- Parkstation -Geoege Goch, Jikeleza, Westgate & Faraday ","Gauteng ",300,88,212,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":8305580,"d":"R8,305,580.00"},{"v":99666960,"d":"R99,666,960.00"},{"v":299000880,"d":"R299,000,880.00"}]
[null,"Totals ",null,null,{"$f":"F20+G20","v":978},{"$f":"F16+F17+F18+F19","v":368},610,null,null,{"$f":"J19+J18+J17+J16","v":{"v":27164206,"d":"R27,164,206.00"}},{"$f":"K16+K17+K18+K19","v":{"v":325970472,"d":"R325,970,472.00"}},{"$f":"L16+L17+L18+L19","v":{"v":977911416,"d":"R977,911,416.00"}}]
[null,"#","Region ","Province","Security Complements ","Armed ","Unarmed","Unit Cost Armed ","Unit Cost Unarmed ","Monthly Cost ",null,"Cost Over 36 Months "]
[null,null,"North ","Western Cape",{"$f":"F22+G22","v":200},40,160,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"H22*F22+I22*G22","v":{"v":5516800,"d":"R5,516,800.00"}},{"$f":"J22*12","v":{"v":66201600,"d":"R66,201,600.00"}},{"$f":"J22*36","v":{"v":198604800,"d":"R198,604,800.00"}}]
[null,null,"Central ","Western Cape",{"$f":"F23+G23","v":292},82,210,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"H23*F23+I23*G23","v":{"v":8080134,"d":"R8,080,134.00"}},{"$f":"J23*12","v":{"v":96961608,"d":"R96,961,608.00"}},{"$f":"J23*36","v":{"v":290884824,"d":"R290,884,824.00"}}]
[null,null,"Ikapa","Western Cape",226,56,170,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":6245702,"d":"R6,245,702.00"},{"v":74948424,"d":"R74,948,424.00"},{"v":224845272,"d":"R224,845,272.00"}]
[null,null,"South ","Western Cape",200,40,160,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":5516800,"d":"R5,516,800.00"},{"v":66201600,"d":"R66,201,600.00"},{"v":198604800,"d":"R198,604,800.00"}]
[null,"Totals ",null,null,{"$f":"F26+G26","v":918},{"$f":"F22+F23+F24+F25","v":218},{"$f":"G22+G23+G24+G25","v":700},null,null,{"$f":"J22+J23+J24+J25","v":{"v":25359436,"d":"R25,359,436.00"}},{"$f":"K22+K23+K24+K25","v":{"v":304313232,"d":"R304,313,232.00"}},{"$f":"L22+L23+L24+L25","v":{"v":912939696,"d":"R912,939,696.00"}}]
[null,"#","Region ","Province","Security Complements ","Armed ","Unarmed","Unit Cost Armed ","Unit Cost Unarmed ","Monthly Cost ",null,"Cost Over 36 Months "]
[null,{"$f":"B19+1","v":13},"Newline Main Line /Crossmoor/Umlazi line  / KwaMashu ","KwaZulu Natal ",{"$f":"F28+G28","v":465},306,159,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F28*H28+G28*I28","v":{"v":13057665,"d":"R13,057,665.00"}},{"$f":"J28*12","v":{"v":156691980,"d":"R156,691,980.00"}},{"$f":"J28*36","v":{"v":470075940,"d":"R470,075,940.00"}}]
[null,14,"Central Line / North Coast / South ","KwaZulu Natal ",{"$f":"F29+G29","v":464},305,159,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F29*H29+G29*I29","v":{"v":13029213,"d":"R13,029,213.00"}},{"$f":"J29*12","v":{"v":156350556,"d":"R156,350,556.00"}},{"$f":"J29*36","v":{"v":469051668,"d":"R469,051,668.00"}}]
[null,"Totals ",null,null,{"$f":"F30+G30","v":929},{"$f":"F28+F29","v":611},318,null,null,{"$f":"J29+J28","v":{"v":26086878,"d":"R26,086,878.00"}},{"$f":"K28+K29","v":{"v":313042536,"d":"R313,042,536.00"}},{"$f":"L28+L29","v":{"v":939127608,"d":"R939,127,608.00"}}]
[null,"#","Region ","Province","Security Complements ","Armed ","Unarmed","Unit Cost Armed ","Unit Cost Unarmed ","Monthly Cost ",null,"Cost Over 36 Months "]
[null,{"$f":"B29+1","v":15},"Port Elizabeth ","Eastern Cape ",{"$f":"SUM(F32:G32)","v":30},4,26,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F32*H32+G32*I32","v":{"v":825350,"d":"R825,350.00"}},{"$f":"J32*12","v":{"v":9904200,"d":"R9,904,200.00"}},{"$f":"J32*36","v":{"v":29712600,"d":"R29,712,600.00"}}]
[null,16,"East London ","Eastern Cape ",{"$f":"SUM(F33:G33)","v":58},8,50,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F33*H33+G33*I33","v":{"v":1595966,"d":"R1,595,966.00"}},{"$f":"J33*12","v":{"v":19151592,"d":"R19,151,592.00"}},{"$f":"J33*36","v":{"v":57454776,"d":"R57,454,776.00"}}]
[null,"Totals ",null,null,{"$f":"F34+G34","v":88},{"$f":"F32+F33","v":12},76,null,null,{"$f":"J32+J33","v":{"v":2421316,"d":"R2,421,316.00"}},{"$f":"K32+K33","v":{"v":29055792,"d":"R29,055,792.00"}},{"$f":"L32+L33","v":{"v":87167376,"d":"R87,167,376.00"}}]
[null,"#","Region ","Province","Security Complements ","Armed ","Unarmed","Unit Cost Armed ","Unit Cost Unarmed ","Monthly Cost ",null,"Cost Over 36 Months "]
[null,{"$f":"B33+1","v":17},"De-Aar, Kimberly, Warington, Klerksdorp, Christiana and Bloemhof","Northern Cape",{"$f":"F36+G36","v":24},0,24,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F36*H36+G36*I36","v":{"v":656808,"d":"R656,808.00"}},{"$f":"J36*12","v":{"v":7881696,"d":"R7,881,696.00"}},{"$f":"J36*36","v":{"v":23645088,"d":"R23,645,088.00"}}]
[null,18,"Bloemfontein, Springfontein, Theunesin, Heineman, Kroonstad, Brandford, Sasolburg, Noupoort and Coalsburg","Free State ",{"$f":"F37+G37","v":152},8,144,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"$f":"F37*H37+G37*I37","v":{"v":4168464,"d":"R4,168,464.00"}},{"$f":"J37*12","v":{"v":50021568,"d":"R50,021,568.00"}},{"$f":"J37*36","v":{"v":150064704,"d":"R150,064,704.00"}}]
[null,19,"Burgersdorp, Rosemead, Cradock, Cookhouse and Ellisdale","Eastern Cape ",20,0,20,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":547340,"d":"R547,340.00"},{"v":6568080,"d":"R6,568,080.00"},{"v":19704240,"d":"R19,704,240.00"}]
[null,20,"Naboomspruit, Mokopane, Polokwane, Soekmekaar, Makhado, Mopane and Musina","Limpopo",24,0,24,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":656808,"d":"R656,808.00"},{"v":7881696,"d":"R7,881,696.00"},{"v":23645088,"d":"R23,645,088.00"}]
[null,21,"Komatipoort, Malelane, Kaapmeiden, Nelspruit, Middelburg and Standerton","Mpumalanga ",24,0,24,{"v":28452,"d":"R28,452.00"},{"v":27367,"d":"R27,367.00"},{"v":656808,"d":"R656,808.00"},{"v":7881696,"d":"R7,881,696.00"},{"v":23645088,"d":"R23,645,088.00"}]
[null,"Totals ",null,null,{"$f":"F41+G41","v":244},{"$f":"SUM(F36:F40)","v":8},236,{"v":142260,"d":"R142,260.00"},{"v":136835,"d":"R136,835.00"},{"v":6686228,"d":"R6,686,228.00"},{"$f":"K36+K37+K38+K39+K40","v":{"v":80234736,"d":"R80,234,736.00"}},{"$f":"J41*36","v":{"v":240704208,"d":"R240,704,208.00"}}]
[null,"National Totals ",null,null,{"$f":"E8+E14+E20+E26+E30+E34+E41","v":5004},{"$f":"F8+F14+F20+F26+F30+F34+F41","v":1982},3022,null,null,{"$f":"J41+J34+J30+J26+J20+J14+J8","v":{"v":139094938,"d":"R139,094,938.00"}},null,{"$f":"L41+L34+L30+L26+L20+L14+L8","v":{"v":4896934240,"d":"R4,896,934,240.00"}}]
[]
[{"$nulls":11},{"$f":"L42/3","v":{"v":1632311413.3333333,"d":"R1,632,311,413.33"}}]

{"sheet":"Current","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"hidden":true}
["SECURITY REQUIREMENTS FOR PHASES 1-2&3 BASED ON CURRENT RATES "]
["#","Region / Business Unit","Security Complement ","GRADE C",null,"GRADE C",null,"Monthly Cost ","Cost for Six Months Extension Incl. Vat "]
[{"$nulls":3},"Armed","Unarmed ","Armed","Unarmed "]
[1,"Gauteng North ",{"$f":"D4+E4","v":856},304,552,{"v":20400,"d":"R20,400.00"},{"v":19700,"d":"R19,700.00"},{"$f":"((D4*F4)+(E4*G4))","v":{"v":17076000,"d":"R17,076,000.00"}},{"$f":"H4*6","v":{"v":102456000,"d":"R102,456,000.00"}}]
[{"$f":"A4+1","v":2},"Gauteng East ",{"$f":"D5+E5","v":991},461,530,{"$f":"F4","v":{"v":20400,"d":"R20,400.00"}},{"$f":"G4","v":{"v":19700,"d":"R19,700.00"}},{"$f":"((D5*F5)+(E5*G5))","v":{"v":19845400,"d":"R19,845,400.00"}},{"$f":"H5*6","v":{"v":119072400,"d":"R119,072,400.00"}}]
[{"$f":"A5+1","v":3},"Gauteng West ",978,368,610,{"$f":"F5","v":{"v":20400,"d":"R20,400.00"}},{"v":19700,"d":"R19,700.00"},{"v":19524200,"d":"R19,524,200.00"},{"v":117145200,"d":"R117,145,200.00"}]
[4,"Western Cape",918,218,700,{"v":20400,"d":"R20,400.00"},{"v":19700,"d":"R19,700.00"},{"v":18237200,"d":"R18,237,200.00"},{"v":109423200,"d":"R109,423,200.00"}]
[5,"KwaZulu Natal ",929,611,318,{"v":20400,"d":"R20,400.00"},{"v":19700,"d":"R19,700.00"},{"v":18729000,"d":"R18,729,000.00"},{"v":112374000,"d":"R112,374,000.00"}]
[6,"Eastern Cape ",88,12,76,{"v":20400,"d":"R20,400.00"},{"v":19700,"d":"R19,700.00"},{"v":1742000,"d":"R1,742,000.00"},{"v":10452000,"d":"R10,452,000.00"}]
[7,"MLPS Nationally",244,8,236,{"v":20400,"d":"R20,400.00"},{"v":19700,"d":"R19,700.00"},{"v":4812400,"d":"R4,812,400.00"},{"v":28874400,"d":"R28,874,400.00"}]
["Total ",null,{"$f":"C4+C5+C6+C7+C8+C9+C10","v":5004},{"$f":"SUM(D4:D10)","v":1982},{"$f":"SUM(E4:E10)","v":3022},null,null,{"$f":"H4+H5+H6+H7+H8+H9+H10","v":{"v":99966200,"d":"R99,966,200.00"}},{"$f":"I4+I5+I6+I7+I8+I9+I10","v":{"v":599797200,"d":"R599,797,200.00"}}]
[]
[{"$nulls":8},{"$f":"I11*2","v":{"v":1199594400,"d":"R1,199,594,400.00"}}]
[{"$nulls":8},{"$f":"I11*7%+I11","v":{"v":641783004,"d":"R641,783,004.00"}}]
[]
[{"$nulls":8},"R 578,067,600.00"]
[{"$nulls":5},{"$f":"F4*7%+F4","v":{"v":21828,"d":"R21,828.00"}},{"$f":"G4*7%+G4","v":{"v":21079,"d":"R21,079.00"}}]

{"sheet":"7% Increase","index":2,"n_rows":19,"n_cols":9,"rows_kept":19,"hidden":true}
["SECURITY REQUIREMENTS FOR PHASES 1-2&3 BASED ON CURRENT RATES "]
["#","Region / Business Unit","Security Complement ","GRADE C",null,"GRADE C",null,"Monthly Cost ","Cost for Six Months Extension Incl. Vat "]
[{"$nulls":3},"Armed","Unarmed ","Armed","Unarmed "]
[1,"Gauteng North ",{"$f":"D4+E4","v":856},304,552,{"v":21828,"d":"R21,828.00"},{"v":21079,"d":"R21,079.00"},{"$f":"((D4*F4)+(E4*G4))","v":{"v":18271320,"d":"R18,271,320.00"}},{"$f":"H4*6","v":{"v":109627920,"d":"R109,627,920.00"}}]
[{"$f":"A4+1","v":2},"Gauteng East ",{"$f":"D5+E5","v":991},461,530,{"v":21828,"d":"R21,828.00"},{"v":21079,"d":"R21,079.00"},{"$f":"((D5*F5)+(E5*G5))","v":{"v":21234578,"d":"R21,234,578.00"}},{"$f":"H5*6","v":{"v":127407468,"d":"R127,407,468.00"}}]
[{"$f":"A5+1","v":3},"Gauteng West ",978,368,610,{"v":21828,"d":"R21,828.00"},{"v":21079,"d":"R21,079.00"},{"v":20890894,"d":"R20,890,894.00"},{"v":125345364,"d":"R125,345,364.00"}]
[4,"Western Cape",918,218,700,{"v":21828,"d":"R21,828.00"},{"v":21079,"d":"R21,079.00"},{"v":19513804,"d":"R19,513,804.00"},{"v":117082824,"d":"R117,082,824.00"}]
[5,"KwaZulu Natal ",929,611,318,{"v":21828,"d":"R21,828.00"},{"v":21079,"d":"R21,079.00"},{"v":20040030,"d":"R20,040,030.00"},{"v":120240180,"d":"R120,240,180.00"}]
[6,"Eastern Cape ",88,12,76,{"v":21828,"d":"R21,828.00"},{"v":21079,"d":"R21,079.00"},{"v":1863940,"d":"R1,863,940.00"},{"v":11183640,"d":"R11,183,640.00"}]
[7,"MLPS Nationally",244,8,236,{"v":21828,"d":"R21,828.00"},{"v":21079,"d":"R21,079.00"},{"v":5149268,"d":"R5,149,268.00"},{"v":30895608,"d":"R30,895,608.00"}]
["Total ",null,{"$f":"C4+C5+C6+C7+C8+C9+C10","v":5004},{"$f":"D4+D5+D6+D7+D8+D9+D10","v":1982},3022,null,null,{"$f":"H4+H5+H6+H7+H8+H9+H10","v":{"v":106963834,"d":"R106,963,834.00"}},{"$f":"I4+I5+I6+I7+I8+I9+I10","v":{"v":641783004,"d":"R641,783,004.00"}}]
[]
[null,null,{"$f":"C11/2","v":2502},{"$nulls":5},{"$f":"I11*2","v":{"v":1283566008,"d":"R1,283,566,008.00"}}]
[null,null,{"$f":"C11+C13","v":7506},{"$nulls":5},{"$f":"I11*7%+I11","v":{"v":686707814.28,"d":"R686,707,814.28"}}]
[]
[{"$nulls":4},{"$f":"D8/2","v":305.5},{"$f":"E8/2","v":159},null,null,"R 578,067,600.00"]
[]
[{"$nulls":8},{"$f":"I11-48395604","v":{"v":593387400,"d":"R593,387,400.00"}}]
[{"$nulls":8},{"$f":"I11-I18","v":{"v":48395604,"d":"R48,395,604.00"}}]

{"sheet":"Envisaged Open Tender","index":3,"n_rows":33,"n_cols":16,"rows_kept":33,"hidden":true}
[]
[null,"#","Region / Business Unit","Security Complement ","GRADE C",null,"GRADE C",null,"Monthly Cost ","Annual Cost"]
[{"$nulls":4},"Armed","Unarmed ","Armed","Unarmed "]
[null,1,"Gauteng North ",{"$f":"E4+F4","v":856},304,552,{"v":22406.499375,"d":"R22,406.50"},{"v":21486.499375,"d":"R21,486.50"},{"$f":"((G4*E4)+(F4*H4))","v":{"v":18672123.465,"d":"R18,672,123.47"}},{"$f":"I4*12","v":{"v":224065481.57999998,"d":"R224,065,481.58"}},{"$f":"O4-D4","v":-232},"Gauteng North ",188,436,{"$f":"M4+N4","v":624}]
[null,{"$f":"B4+1","v":2},"Gauteng East ",{"$f":"E5+F5","v":991},461,530,{"v":22406.499375,"d":"R22,406.50"},{"v":21486.499375,"d":"R21,486.50"},{"$f":"((G5*E5)+(F5*H5))","v":{"v":21717240.880625,"d":"R21,717,240.88"}},{"$f":"I5*12","v":{"v":260606890.5675,"d":"R260,606,890.57"}},{"$f":"O5-D5","v":0},"Gauteng East",461,530,{"$f":"M5+N5","v":991}]
[null,{"$f":"B5+1","v":3},"Gauteng West ",978,368,610,{"v":22406.499375,"d":"R22,406.50"},{"v":21486.499375,"d":"R21,486.50"},{"v":21352356.38875,"d":"R21,352,356.39"},{"v":256228276.66500002,"d":"R256,228,276.67"},0,"Gauteng West",368,610,978]
[null,4,"Western Cape",918,218,700,{"v":22406.499375,"d":"R22,406.50"},{"v":21486.499375,"d":"R21,486.50"},{"v":19925166.42625,"d":"R19,925,166.43"},{"v":239101997.115,"d":"R239,101,997.12"},0,"Western Cape ",218,700,918]
[null,5,"KwaZulu Natal ",929,611,318,{"v":22406.499375,"d":"R22,406.50"},{"v":21486.499375,"d":"R21,486.50"},{"v":20523077.919375,"d":"R20,523,077.92"},{"v":246276935.03249997,"d":"R246,276,935.03"},0,"KwaZulu Natal",611,318,929]
[null,6,"Eastern Cape ",88,12,76,{"v":22406.499375,"d":"R22,406.50"},{"v":21486.499375,"d":"R21,486.50"},{"v":1901851.9449999998,"d":"R1,901,851.95"},{"v":22822223.339999996,"d":"R22,822,223.34"},0,"Eastern Cape ",12,76,88]
[null,7,"MLPS Nationally",244,8,236,{"v":22406.499375,"d":"R22,406.50"},{"v":21486.499375,"d":"R21,486.50"},{"v":5250065.8475,"d":"R5,250,065.85"},{"v":63000790.17,"d":"R63,000,790.17"},-156,"MLPS ",0,88,88]
[null,"Total ",null,{"$f":"D4+D5+D6+D7+D8+D9+D10","v":5004},{"$f":"SUM(E4:E10)","v":1982},{"$f":"SUM(F4:F10)","v":3022},null,null,{"$f":"I4+I5+I6+I7+I8+I9+I10","v":{"v":109341882.87249999,"d":"R109,341,882.87"}},{"$f":"J4+J5+J6+J7+J8+J9+J10","v":{"v":1312102594.47,"d":"R1,312,102,594.47"}},null,null,{"$f":"M4+M5+M6+M7+M8+M9+M10","v":1858},{"$f":"N4+N5+N6+N7+N8+N9+N10","v":2758},4616]
[]
[{"$nulls":6},{"$f":"G4*E4","v":{"v":6811575.81,"d":"R6,811,575.81"}},{"$f":"H4*F4","v":{"v":11860547.655,"d":"R11,860,547.66"}},{"$f":"G13+H13","v":{"v":18672123.465,"d":"R18,672,123.47"}},{"$f":"J11-1200000000","v":{"v":112102594.47000003,"d":"R112,102,594.47"}},null,4856]
[{"$nulls":9},{"$f":"J13/2","v":{"v":56051297.235000014,"d":"R56,051,297.24"}}]
[{"$nulls":5},439,780,null,null,{"$f":"J14+'7% Increase'!I19","v":{"v":104446901.23500001,"d":"R104,446,901.24"}}]
[{"$nulls":5},1339,1524]
[{"$nulls":3},2,{"$f":"F17+G17","v":4082},{"$f":"F15+F16","v":1778},{"$f":"G15+G16","v":2304}]
[]
[null,null,20400,19700,{"$nulls":7},{"v":14947.13,"d":"R14,947.13"},{"$nulls":3},{"v":14947.13,"d":"R14,947.13"}]
[null,null,{"$f":"C19*19%+C19","v":{"v":24276,"d":"R24,276.00"}},{"$f":"D19*19%+D19","v":{"v":23443,"d":"R23,443.00"}},null,"Rates Applicable from March 2023 to February 2024 at Grade C direct cost of R 14,947.13 excluding shares, overheads and Vat"]
[{"$nulls":5},"Percentage for Shares and Overheads ","Armed","Unarmed ",{"$nulls":3},20400,19700]
[{"$nulls":5},{"v":0.4,"d":"40%"},{"$f":"H22+800","v":{"v":21725,"d":"R21,725.00"}},{"v":20925,"d":"R20,925.00"},"Excl. Vat",null,null,{"$f":"L21*7%+L21","v":21828},{"$f":"M21*7%+M21","v":21079}]
[{"$nulls":6},{"$f":"G22*15%+G22","v":{"v":24983.75,"d":"R24,983.75"}},{"$f":"H22*15%+H22","v":{"v":24063.75,"d":"R24,063.75"}},"Vat Inclusive",null,null,{"$f":"L21*13%+L21","v":23052},{"$f":"M21*13%+M21","v":22261}]
[{"$nulls":5},{"v":0.3,"d":"30%"},{"$f":"H24+800","v":{"v":20231.269,"d":"R20,231.27"}},{"$f":"L19*30%+L19","v":{"v":19431.269,"d":"R19,431.27"}},"Excl. Vat"]
[{"$nulls":6},{"$f":"G24*15%+G24","v":{"v":23265.95935,"d":"R23,265.96"}},{"$f":"H24*15%+H24","v":{"v":22345.95935,"d":"R22,345.96"}},"Vat Inclusive"]
[{"$nulls":5},{"v":0.25,"d":"25%"},{"$f":"H26+800","v":{"v":19483.9125,"d":"R19,483.91"}},{"$f":"P19*25%+P19","v":{"v":18683.9125,"d":"R18,683.91"}},"Excl. Vat"]
[{"$nulls":6},{"$f":"G26*15%+G26","v":{"v":22406.499375,"d":"R22,406.50"}},{"$f":"H26*15%+H26","v":{"v":21486.499375,"d":"R21,486.50"}},"Vat Inclusive"]
[]
[]
[]
[{"$nulls":5},"Own ",4856,{"v":0.51,"d":"51.00%"}]
[{"$nulls":5},"Private Security",{"$f":"D11","v":5004},{"v":0.49,"d":"49.00%"}]
[{"$nulls":6},{"$f":"G31+G32","v":9860},{"$f":"H31+H32","v":{"v":1,"d":"100.00%"}}]

{"sheet":"WP-1-GW","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"merged":[[0,2,0,8],[1,1,1,13],[2,5,2,6],[2,7,2,8],[2,9,3,9],[8,1,8,3]]}
[null,null,"REQUEST FOR PROPOSAL – PRIVATE SECURITY SERVICES\nTENDER NUMBER: HO/SEC/002/05/2023"]
[null,"GAUTENG WEST - WORK PACKAGE 1"]
[null,"#","Region ","Province","Total Security Complements ","Grade - C ",null,"Grade C Units Cost Incl. Vat  ",null,"Monthly Value Inlc. Vat ","Year 1 Incl. VAT ","Year 2 Including Escalation and VAT","Year 3 Including Escalation and VAT ","Total Cost Over 36 Months Incl. Vat"]
[{"$nulls":5},"Armed ","Unarmed","Armed ","Unarmed"]
[null,1,"Gautneg West  1 - Mlamlankunzi - Midway -Vereeniging ","Gauteng ",{"$f":"F5+G5","v":174},84,90]
[null,{"$f":"B5+1","v":2},"Gauteng West 2 -Langlaagte-New Canada- Naledi","Gauteng ",{"$f":"F6+G6","v":300},120,180]
[null,3,"Gauteng West 3 - Industria- Roodepport- Randfontein - Oberlholser ","Gauteng ",204,76,128]
[null,4,"Gauteng West 4 - Langlaate- Parkstation -Geoege Goch, Jikeleza, Westgate & Faraday ","Gauteng ",300,88,212]
[null,"Total ",null,null,{"$f":"E5+E6+E7+E8","v":978},{"$f":"SUM(F5:F8)","v":368},{"$f":"SUM(G5:G8)","v":610}]

{"sheet":"WP-2-GE","index":5,"n_rows":9,"n_cols":14,"rows_kept":9,"merged":[[1,1,1,13],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,5,2,6],[2,7,2,8]]}
[]
[null,"GAUTENG EAST - WORK PACKAGE 2"]
[null,"#","Region ","Province","Total Security Complements ","Grade C Complements",null,"Grade C Units Cost Incl. Vat  ",null,"Monthly Value Incl. Vat","Year 1 Incl. VAT ","Year 2 Including Escalation and VAT","Year 3 Including Escalation and VAT ","Total Cost Over 36 Months Incl. Vat"]
[{"$nulls":5},"Armed ","Unarmed","Armed ","Unarmed"]
[null,1,"Gauteng East 1 - Leralla-Olifantsfontein - Oakmoor - Tembisa - Limindlela - Kempton Park - Isando - Rhodesfield - Daveyton - Benoni - Brakpan - Springs - Dunswart - Doornfontein - Nigel  - Kaalfontein - Ravensklip - Elandsfontein - Germiston","Gauteng ",{"$f":"F5+G5","v":190},90,100]
[null,{"$f":"B5+1","v":2},"Gauteng East 2 - Ravensklip-Germiston-George Koch","Gauteng ",{"$f":"F6+G6","v":200},100,100]
[null,3,"Gauteng East 3 - Delmore - Daveyton - Nigel ","Gauteng ",301,136,165]
[null,4,"Gauteng East 4 - Kwesine- Wadeville- Elsburg- Vereeniging ","Gauteng ",300,135,165]
[null,"Totals ",null,null,{"$f":"E5+E6+E7+E8","v":991},{"$f":"F5+F6+F7+F8","v":461},{"$f":"G5+G6+G7+G8","v":530}]

{"sheet":"WP-3 GN","index":6,"n_rows":8,"n_cols":14,"rows_kept":8,"merged":[[0,1,0,13],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,5,1,6],[1,7,1,8]]}
[null,"GAUTENG NORTH - WORK PACKAGE 3"]
[null,"#","Region ","Province","Total Security Complements ","Grade C Complements",null,"Grade C Units Cost Incl. Vat  ",null,"Monthly Value Incl. Vat","Year 1 Incl. VAT ","Year 2 Including Escalation and VAT","Year 3 Including Escalation and VAT ","Total Cost Over 36 Months Incl. Vat"]
[{"$nulls":5},"Armed ","Unarmed","Armed ","Unarmed"]
[null,1,"Gautneg North 1 - Mabopane-De Wildt - Winternest","Gauteng ",{"$f":"G4+F4","v":136},38,98]
[null,{"$f":"B4+1","v":2},"Gauteng North 2 - Wolmerton- Belle Ombre- Schutte- Queenswood","Gauteng ",{"$f":"G5+F5","v":232},116,116]
[null,{"$f":"B5+1","v":3},"Gauteng North 3 - Koedoes-Pienaars-Mears","Gauteng ",256,124,132]
[null,4,"Gauteng North 4 - Sauls-Pretoria-Pinedene","Gauteng ",232,26,206]
[null,"Totals ",null,null,{"$f":"E4+E5+E6+E7","v":856},{"$f":"F4+F5+F6+F7","v":304},552]

{"sheet":"WP-4-WC","index":7,"n_rows":9,"n_cols":14,"rows_kept":9,"merged":[[1,1,1,13],[2,5,2,6],[2,7,2,8],[2,9,3,9],[8,1,8,3]]}
[]
[null,"WESTERN CAPE - WORK PACKAGE 4"]
[null,"#","Region ","Province","Total Security Complements ","Grade C Complements",null,"Grade C Units Cost Incl. Vat  ",null,"Monthly Value Inlc. Vat ","Year 1 Incl. VAT ","Year 2 Including Escalation and VAT","Year 3 Including Escalation and VAT ","Total Cost Over 36 Months Incl. Vat"]
[{"$nulls":5},"Armed ","Unarmed","Armed ","Unarmed"]
[null,1,"North ","Western Cape",{"$f":"F5+G5","v":200},40,160]
[null,2,"Central ","Western Cape",{"$f":"F6+G6","v":292},82,210]
[null,3,"Ikapa","Western Cape",226,56,170]
[null,4,"South ","Western Cape",200,40,160]
[null,"Totals ",null,null,{"$f":"E5+E6+E7+E8","v":918},{"$f":"F5+F6+F7+F8","v":218},700]

{"sheet":"WP-5-KZN","index":8,"n_rows":7,"n_cols":14,"rows_kept":7,"merged":[[1,1,1,13],[2,5,2,6],[2,7,2,8],[2,9,3,9],[6,1,6,3]]}
[]
[null,"KWAZULU NATAL - WORK PACKAGE 5"]
[null,"#","Region ","Province","Total Security Complements ","Grade C Complements",null,"Grade C Units Cost Incl. Vat  ",null,"Monthly Value Inlc. Vat ","Year 1 Incl. VAT ","Year 2 Including Escalation and VAT","Year 3 Including Escalation and VAT ","Total Cost Over 36 Months Incl. Vat"]
[{"$nulls":5},"Armed ","Unarmed","Armed ","Unarmed"]
[null,1,"Newline Main Line /Crossmoor/Umlazi line  / KwaMashu ","KwaZulu Natal ",{"$f":"F5+G5","v":465},306,159]
[null,{"$f":"B5+1","v":2},"Central Line / North Coast / South ","KwaZulu Natal ",{"$f":"F6+G6","v":464},305,159]
[null,"Total ",null,null,{"$f":"E5+E6","v":929},{"$f":"F5+F6","v":611},318]

{"sheet":"WP-6-EC","index":9,"n_rows":7,"n_cols":14,"rows_kept":7,"merged":[[1,1,1,13],[2,5,2,6],[2,7,2,8],[2,9,3,9],[6,1,6,3]]}
[]
[null,"EASTERN CAPE - WORKPACKAGE 6"]
[null,"#","Region ","Province","Total Security Complements ","Grade C Complements",null,"Grade C Units Cost Incl. Vat  ",null,"Monthly Value Inlc. Vat ","Year 1 Incl. VAT ","Year 2 Including Escalation and VAT","Year 3 Including Escalation and VAT ","Total Cost Over 36 Months Incl. Vat"]
[{"$nulls":5},"Armed ","Unarmed","Armed ","Unarmed"]
[null,1,"Port Elizabeth ","Eastern Cape ",{"$f":"SUM(F5:G5)","v":40},4,36]
[null,{"$f":"B5+1","v":2},"East London ","Eastern Cape ",{"$f":"SUM(F6:G6)","v":68},8,60]
[null,"Total ",null,null,{"$f":"E5+E6","v":108},{"$f":"F5+F6","v":12},96]

{"sheet":"WP-7-MLPS","index":10,"n_rows":9,"n_cols":14,"rows_kept":9,"merged":[[1,1,1,13],[2,5,2,6],[2,7,2,8],[2,9,3,9],[8,1,8,3]]}
[]
[null,"MAINLINE PASSENGER SERVICES (MLPS) - WORK PACKAGE 7"]
[null,"#","Region ","Province","Security Complements ","Grade C Complements",null,"Grade C Units Cost Incl. Vat  ",null,"Monthly Value Inlc. Vat ","Year 1 Incl. VAT ","Year 2 Including Escalation and VAT","Year 3 Including Escalation and VAT ","Total Cost Over 36 Months Incl. Vat"]
[{"$nulls":5},"Armed ","Unarmed","Armed ","Unarmed"]
[null,1,"De-Aar, Kimberly, Warington, Klerksdorp, Christiana and Bloemhof","Northern Cape",{"$f":"F5+G5","v":24},0,24]
[null,{"$f":"B5+1","v":2},"Bloemfontein, Springfontein, Theunesin, Heineman, Kroonstad, Brandford, Sasolburg, Noupoort and Coalsburg","Free State ",{"$f":"F6+G6","v":152},8,144]
[null,3,"Naboomspruit, Mokopane, Polokwane, Soekmekaar, Makhado, Mopane and Musina","Limpopo",24,0,24]
[null,4,"Komatipoort, Malelane, Kaapmeiden, Nelspruit, Middelburg and Standerton","Mpumalanga ",24,0,24]
[null,"Total ",null,null,{"$f":"E5+E6+E7+E8","v":224},{"$f":"F5+F6+F7+F8","v":8},216]

{"sheet":"WP-8-Ad-hoc","index":11,"n_rows":16,"n_cols":11,"rows_kept":16,"merged":[[15,0,15,4]]}
[]
[null,"National Ad-Hoc Intervention Unit","*Must have offices in KZN, WC and GP"]
["AD-HOC SERVICES AS-AND-WHEN REQUIRED - Estimate for all 8 work packages"]
["#","Description of Service ","Unit of Measure ","Unit Cost Incl. Vat","Estimate  Year 1 ","Year 1 Incl. VAT "," Unit Cost Year 2 Including Escalation and VAT","Estimate Year 2 to Year 3","Year 2 Including VAT","Year 3 Including Escalation and VAT ","Total Cost Over 36 Months Incl. Vat"]
[1,"B6 SUV Armoured vehicles as-and-when required wet rate. ","R/Km",null,{"$f":"40000*5","v":200000},null,null,{"$f":"E5*2","v":400000}]
[null,"B6 Armoured Personnel Carrier (must seat 10 persons)","Per 12 Hour Shift",null,{"$f":"60*9","v":540},null,null,{"$f":"E6*2","v":1080}]
[{"$f":"A5+1","v":2},"Grade B Armed Tactical Security officers of Ten Man Team Including Driver for personnel carrier . Shotguns compulsory. ","Per 12 Hour Shift for Team of 10",null,540,null,null,1080]
[{"$f":"A6+1","v":1},"Grade B Armed 2-Man Tactical Security officers/drivers for armoured SUV","Per 12 Hour Shift for Team of 2",null,{"$f":"5*30*2*3*7","v":6300},null,null,12600]
[null,"Gade C Armed Security Officers @ rate per guard per shift","Rate Per Guard Per 12 Hour Shift",null,24000,null,null,48000]
[{"$f":"A7+1","v":3},"K9 Officer with Narcotic dogs. ","Per 12 Hour Shift",null,{"$f":"450*5","v":2250},null,null,4500]
[null,"K9 Officer with Explosive dogs. ","Per 12 Hour Shift",null,{"$f":"450*5","v":2250},null,null,4500]
[{"$f":"A10+1","v":4},"Provision of Motor Vehicles LDV single Cab with Grade B driver wet rate. Estimated 250 km per shift","Per 12 Hour Shift",null,{"$f":"14*2*30*9","v":7560},null,null,15120]
[{"$f":"A12+1","v":5},"Provision of Motor Vehicles LDV Double Cab with Grade B driver wet rate. Estimated 250 km per shift","Per 12 Hour Shift",null,{"$f":"14*2*30*9","v":7560},null,null,15120]
[6,"Provision of Scrambler Motorcycles with Grade C rider wet rate. Estimated 100 km per shift","Per 12 Hour Shift",null,{"$f":"14*2*30*9*0.5","v":3780},null,null,7560]
[7,"Provision of quadbikes with Grade C rider wet rate.Estimated 50 km per shift","Per 12 Hour Shift",null,{"$f":"14*2*30*9*0.5","v":3780},null,null,7560]
["Total "]