{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["BOQ -AREA 1 ","BOQ-AREA 2 ","EMFULENI SITES-AREA 3"],"read":"whole","date_system":"1900"}

{"sheet":"BOQ -AREA 1 ","index":0,"n_rows":75,"n_cols":11,"rows_kept":75,"merged":[[1,0,1,3],[22,0,22,3],[42,0,42,3],[62,0,62,2],[63,0,63,2],[64,0,64,2],[65,0,65,2],[66,0,66,2],[68,0,69,3],[72,1,72,3],[74,1,74,3]]}
[]
["EAST REGION "]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE ","TOTAL INCL"]
[]
["PSIRA Grade B Security Supervisor - Dog handler  (Day Shift)",2,{"$nulls":3},15649.15]
["PSIRA Grade B Security Supervisor -  Dog handler  (Night Shift)",2,{"$nulls":3},15831.65]
["PSIRA Grade C Security Officers (Day Shift)",18,{"$nulls":3},14098.19]
["PSIRA Grade C Security Officers (Night Shift)",19,{"$nulls":3},14280.69]
["PSIRA Grade C Pipeline Patrol tactical  dog-hadler (Day Shift)",6,{"$nulls":3},14098.19]
["PSIRA Grade C Pipeline Patrol tactical dog-handler (Night Shift)",6,{"$nulls":3},14280.69]
["Dog Handlers (Day Shift)",7,{"$nulls":3},14098.19]
["Dog Handlers (Night Shift)",7,{"$nulls":3},14280.69]
["Firearms :Handguns",13]
["Firearms : Rifles",3]
["Base Radio",0]
["Hand Radios",21]
["Dogs",11]
["Guard Monitoring points ",55]
["4x4 Double Cab (Bakkie)",3]
["Bullet Proof vests ",16]
["ADHOC Services","Provisional SUM",{"v":2000000,"d":"R2,000,000.00"},{"v":2000000,"d":"R2,000,000.00"}]
[]
["WEST REGION"]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE","TOTAL INCL"]
[{"$nulls":8},{"$f":"SUM(F5*17%)","v":2660.3555},null,{"$f":"SUM(F5+I25)","v":18309.5055}]
["PSIRA Grade B Security Supervisor - Dog handler  (Day Shift)",2,{"$nulls":6},{"$f":"SUM(F6*17%)","v":2691.3805},null,{"$f":"SUM(F6+I26)","v":18523.0305}]
["PSIRA Grade B Security Supervisor -  Dog handler  (Night Shift)",2,{"$nulls":6},{"$f":"SUM(F7*17%)","v":2396.6923},null,{"$f":"SUM(F7+I27)","v":16494.8823}]
["PSIRA Grade C Security Officers (Day Shift)",35,{"$nulls":6},{"$f":"SUM(F8*17%)","v":2427.7173000000003},null,{"$f":"SUM(F8+I28)","v":16708.4073}]
["PSIRA Grade C Security Officers (Night Shift)",39,{"$nulls":6},{"$f":"SUM(F9*17%)","v":2396.6923},null,{"$f":"SUM(F9+I29)","v":16494.8823}]
["PSIRA Grade C Pipeline Patrol tactical Dog Handler (Day Shift)",6,{"$nulls":6},{"$f":"SUM(F10*17%)","v":2427.7173000000003},null,{"$f":"SUM(F10+I30)","v":16708.4073}]
["PSIRA Grade C Pipeline Patrol tactical  Dog Handler (Night Shift)",6,{"$nulls":6},{"$f":"SUM(F11*17%)","v":2396.6923},null,{"$f":"SUM(F11+I31)","v":16494.8823}]
["Dog Handlers (Day Shift)",13,{"$nulls":6},{"$f":"SUM(F12*17%)","v":2427.7173000000003},null,{"$f":"SUM(F12+I32)","v":16708.4073}]
["Dog Handlers (Night Shift)",17]
["Firearms :Handguns",29]
["Firearms :Rifles",3]
["Base Radio",15]
["Hand Radios",44]
["Dogs",19]
["Guard Monitoring points ",110]
["4x4 Double Cab (Bakkie)",3]
["Bullet Proof vests ",29]
["ADHOC Services","Provisional SUM",{"v":2000000,"d":"R2,000,000.00"},{"v":2000000,"d":"R2,000,000.00"}]
["NORTH REGION"]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE ","TOTAL INCL"]
[]
["PSIRA Grade B Security Supervisor - Dog handler  (Day Shift)",1]
["PSIRA Grade B Security Supervisor -  Dog handler  (Night Shift)",1]
["PSIRA Grade C Security Officers (Day Shift)",22]
["PSIRA Grade C Security Officers (Night Shift)",23]
["PSIRA Grade C Pipeline Patrol tactical  Dog Handler (Day Shift)",6]
["PSIRA Grade C Pipeline Patrol tactical Dog Handler  (Night Shift)",6]
["Dog Handlers (Day Shift)",4]
["Dog Handlers (Night Shift)",4]
[" Fireams : Handguns",14]
["Firearms  : Rifles",3]
["Base Radio",0]
["Hand Radios",27]
["Dogs",10]
["Guard Monitoring points ",65]
["4x4 Double Cab (Bakkie)",3]
["Bullet Proof vests ",17]
["ADHOC Services","Provisional SUM",{"v":2000000,"d":"R2,000,000.00"},{"v":2000000,"d":"R2,000,000.00"}]
["TOTAL cost excluding vat (Per Month)",null,null,{"$f":"SUM(D5:D21,D26:D42,D46:D62)","v":{"v":6000000,"d":"R6,000,000.00"}}]
["VAT 15%",null,null,{"$f":"D63*15%","v":{"v":900000,"d":"R900,000.00"}}]
["TOTAL COST PER MONTH ",null,null,{"$f":"D63+D64","v":{"v":6900000,"d":"R6,900,000.00"}}]
["TOTAL COST FOR 12 MONTHS",null,null,{"$f":"D65*12","v":{"v":82800000,"d":"R82,800,000.00"}}]
["TOTAL COST FOR 60  MONTHS",null,null,{"$f":"D66*12","v":{"v":993600000,"d":"R993,600,000.00"}}]
[]
["Transfer the Total Cost for 60 Months to the Form Of Offer"]
[]
[]
[]
["Name of Bidder:"]
["Signed by or on behalf of Bidder:",null,"Official Capacity:"]
["Date:"]

{"sheet":"BOQ-AREA 2 ","index":1,"n_rows":55,"n_cols":12,"rows_kept":55,"merged":[[1,0,1,3],[21,0,21,3],[43,0,43,2],[44,0,44,2],[45,0,45,2],[46,0,46,2],[47,0,47,2],[49,0,50,3],[52,1,52,3],[54,1,54,3]]}
[]
["CENTRAL REGION"]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE ","TOTAL INCL"]
[{"$nulls":7},15649.15,null,{"$f":"SUM(H4*17%)","v":2660.3555},null,{"$f":"SUM(H4+J4)","v":18309.5055}]
["PSIRA Grade B Security Supervisor - Dog handler  (Day Shift)",1,{"$nulls":5},15831.65,null,{"$f":"SUM(H5*17%)","v":2691.3805},null,{"$f":"SUM(H5+J5)","v":18523.0305}]
["PSIRA Grade B Security Supervisor -  Dog handler  (Night Shift)",1,{"$nulls":5},14098.19,null,2396.6923,null,16494.8823]
["PSIRA Grade C Security Officers (Day Shift)",39,{"$nulls":5},14280.69,null,2427.7173000000003,null,16708.4073]
["PSIRA Grade C Security Officers (Night Shift)",42,{"$nulls":5},14098.19,null,2396.6923,null,16494.8823]
["PSIRA Grade C Pipeline Patrol tactical  Dog Handler  (Day Shift)",8,{"$nulls":5},14280.69,null,2427.7173000000003,null,16708.4073]
["PSIRA Grade C Pipeline Patrol tactical  Dog Handler (Night Shift)",8,{"$nulls":5},14098.19,null,2396.6923,null,16494.8823]
["Dog Handlers (Day Shift)",15,{"$nulls":5},14280.69,null,2427.7173000000003,null,16708.4073]
["Dog Handlers (Night Shift)",21]
["Firearms : Riles",4]
["Firearms : Handguns",33]
["Base Radio",0]
["Hand Radios",42]
["Dogs",21]
["Guard Monitoring points ",115]
["4x4 Double Cab (Bakkie)",4]
["Bullet Proof vests ",32]
["ADHOC Services","Provisional SUM",{"v":2000000,"d":"R2,000,000.00"},{"v":2000000,"d":"R2,000,000.00"}]
["SOUTH REGION"]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE ","TOTAL INCL"]
[]
["PSIRA Grade B Security Supervisor - Dog handler  (Day Shift)",2]
["PSIRA Grade B Security Supervisor -  Dog handler  (Night Shift)",2]
["PSIRA Grade C Security Officers (Day Shift)",56]
["PSIRA Grade C Security Officers (Night Shift)",55]
["PSIRA Grade C Pipeline Patrol tactical  (Day Shift)",6]
["PSIRA Grade C Pipeline Patrol tactical  (Night Shift)",6]
["Dog Handlers (Day Shift)",14]
["Dog Handlers (Night Shift)",14]
["Firearms :  Rifles",3]
["Firearms : Hand-guns ",41]
["Base Radio",0]
["Hand Radios",62]
["Cellular phones",0]
["Dogs",19]
["Guard Monitoring points ",75]
["4x4 Double Cab (Bakkie)",3]
["Bullet Proof vests ",44]
["ADHOC Services","Provisional SUM",{"v":2000000,"d":"R2,000,000.00"},{"v":2000000,"d":"R2,000,000.00"}]
[]
["TOTAL cost excluding vat (Per Month)",null,null,{"$f":"SUM(D5:D21,D25:D42)","v":{"v":4000000,"d":"R4,000,000.00"}}]
["VAT 15%",null,null,{"$f":"D44*15%","v":{"v":600000,"d":"R600,000.00"}}]
["TOTAL COST PER MONTH ",null,null,{"$f":"D44+D45","v":{"v":4600000,"d":"R4,600,000.00"}}]
["TOTAL COST FOR 12 MONTHS",null,null,{"$f":"D46*12","v":{"v":55200000,"d":"R55,200,000.00"}}]
["TOTAL COST FOR 60 MONTHS",null,null,{"$f":"D47*12","v":{"v":662400000,"d":"R662,400,000.00"}}]
[]
["Transfer the Total Cost for 60 Months to the Form Of Offer"]
[]
[]
["Name of Bidder:"]
["Signed by or on behalf of Bidder:",null,"Official Capacity:"]
["Date:"]

{"sheet":"EMFULENI SITES-AREA 3","index":2,"n_rows":34,"n_cols":4,"rows_kept":34,"merged":[[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[26,0,27,3],[31,1,31,3],[33,1,33,3]]}
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE","TOTAL INCL"]
[]
["PSIRA Grade B Security Supervisors -Day shift",4]
["PSIRA Grade B Security Supervisors - Night shift",4]
["PSIRA Grade C Tactical Response Officers - Day Shift",6]
["PSIRA Grade C Tactical Response Officers - Night Shift",6]
["PSIRA Grade C Security Officers - Day Shift",81]
["PSIRA Grade C Security Officers - Night Shift",85]
["PSIRA Grade C Armed Security Officers - Day Shift",9]
["PSIRA Grade C Armed Security Officers - Night Shift",9]
["PSIRA Grade C Dog Handlers - Day Shift ",12]
["PSIRA Grade C Dog Handlers - Night Shift",12]
["Firearms : Handguns",6]
["Firearms :Rifles",9]
["Hand Radios",52]
["Dogs",24]
["Patrol vehicles",6]
["Bullet Proof Vests",21]
["ADHOC Services","Provisional SUM",{"v":2000000,"d":"R2,000,000.00"},{"v":2000000,"d":"R2,000,000.00"}]
[]
["TOTAL cost excluding vat (Per Month)",null,null,{"$f":"SUM(D3:D19)","v":{"v":2000000,"d":"R2,000,000.00"}}]
["VAT 15%",null,null,{"$f":"D21*15%","v":{"v":300000,"d":"R300,000.00"}}]
["TOTAL COST PER MONTH ",null,null,{"$f":"D21+D22","v":{"v":2300000,"d":"R2,300,000.00"}}]
["TOTAL COST FOR 12 MONTHS",null,null,{"$f":"D23*12","v":{"v":27600000,"d":"R27,600,000.00"}}]
["TOTAL COST FOR 60 MONTHS",null,null,{"$f":"D24*12","v":{"v":331200000,"d":"R331,200,000.00"}}]
[]
["Transfer the Total Cost for 60 Months to the Form Of Offer"]
[]
[]
[]
[]
["Name of Bidder:"]
["Signed by or on behalf of Bidder:",null,"Official Capacity:"]
["Date:"]