{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["EAST REGION","NORTH REGION","WEST REGION","CENTRAL REGION","SOUTH REGION"],"read":"whole","date_system":"1900"}

{"sheet":"EAST REGION","index":0,"n_rows":33,"n_cols":6,"rows_kept":33,"merged":[[1,0,1,3],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[24,0,25,3],[28,1,28,3],[30,1,30,3],[32,0,34,3]]}
[]
["EAST REGION "]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE ","TOTAL INCL"]
["PSIRA Grade B Security Supervisor - Dog handler (Day Shift) Armed ",1]
["PSIRA Grade B Security Supervisor -  Dog handler (Day Shift) Armed ",1]
["PSIRA Grade B Security Supervisor -  Dog handler (Night Shift) Armed ",1,{"$nulls":3},15649.15]
["PSIRA Grade C Security Officers (Day Shift) Armed ",10,{"$nulls":3},15831.65]
["PSIRA Grade C Security Officers (Day Shift) Unarmed ",8]
["PSIRA Grade C Security Officers (Night Shift) Armed ",7]
["PSIRA Grade C Security Officers (Night Shift) Unarmed ",9,{"$nulls":3},14098.19]
["PSIRA GRADE C Dog Handlers (Night Shift) ",3,{"$nulls":3},14280.69]
["Firearms: Handguns",11,{"$nulls":3},14098.19]
["Digital Hand Radios",21,{"$nulls":3},14280.69]
["Dogs",3,{"$nulls":3},14098.19]
["Dog Kennels",3,{"$nulls":3},14280.69]
["Guard Monitoring points ",55]
["Bullet Proof vests ",11]
["ADHOC Services","Provisional SUM",{"v":1000000,"d":"R1,000,000.00"}]
["TOTAL cost excluding vat (Per Month)",null,null,{"$f":"SUM(D18:D18)","v":0}]
["VAT 15%",null,null,{"$f":"D19*15%","v":0}]
["TOTAL COST PER MONTH ",null,null,{"$f":"D19+D20","v":0}]
["TOTAL COST FOR 12 MONTHS",null,null,{"$f":"D21*12","v":0}]
["TOTAL COST FOR 60  MONTHS",null,null,{"$f":"D22*12","v":0}]
[]
["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:"]
[]
["NB: Adhoc service will be caped to R1 000 000 per year and R5 000 000 for five (5) years. When populating the BOQ include it as part of Form of Offer"]

{"sheet":"NORTH REGION","index":1,"n_rows":36,"n_cols":4,"rows_kept":36,"merged":[[1,0,1,3],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[27,0,28,3],[31,1,31,3],[33,1,33,3],[35,0,37,3]]}
[]
["NORTH REGION"]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE ","TOTAL INCL"]
["PSIRA Grade B Security Supervisor - Dog handler  (Day Shift) Armed ",1]
["PSIRA Grade B Security Supervisor -  Dog handler  (Night Shift) Armed ",1]
["PSIRA Grade C Security Officers (Day Shift) Armed ",12]
["PSIRA Grade C Security Officers (Day Shift) Unarmed ",10]
["PSIRA Grade C Security Officers (Night Shift) Armed ",11]
["PSIRA Grade C Security Officers (Night Shift) Unarmed ",11]
["PSIRA GRADE C Dog Handlers (Night Shift) ",1]
["PSIRA Grade C Pipeline Patrol tactical  (Day Shift) Armed",2]
["PSIRA Grade C Pipeline Patrol tactical (Night Shift) Armed ",2]
["Firearms :Handguns",15]
["Firearms : Rifles",1]
["Digital Hand Radios",24]
["Dogs",1]
["Dog Kennels",1]
["Guard Monitoring points ",115]
["LDV Double-Cab (Bakkie)",1]
["Bullet Proof vests ",15]
["ADHOC Services","Provisional SUM",{"v":1000000,"d":"R1,000,000.00"}]
["TOTAL cost excluding vat (Per Month)",null,null,{"$f":"SUM(D21:D21)","v":0}]
["VAT 15%",null,null,{"$f":"D22*15%","v":0}]
["TOTAL COST PER MONTH ",null,null,{"$f":"D22+D23","v":0}]
["TOTAL COST FOR 12 MONTHS",null,null,{"$f":"D24*12","v":0}]
["TOTAL COST FOR 60  MONTHS",null,null,{"$f":"D25*12","v":0}]
[]
["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:"]
[]
["NB: Adhoc service will be caped to R1 000 000 per year and R5 000 000 for five (5) years. When populating the BOQ include it as part of Form of Offer"]

{"sheet":"WEST REGION","index":2,"n_rows":36,"n_cols":11,"rows_kept":36,"merged":[[1,0,1,3],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[27,0,28,3],[31,1,31,3],[33,1,33,3],[35,0,37,3]]}
[]
["WEST REGION"]
["DESCRIPTION ","NO. OF GUARDS /EQUIPMENT","UNIT PRICE","TOTAL INCL"]
["PSIRA Grade B Security Supervisor - Dog handler  (Day Shift) Armed ",2,{"$nulls":6},{"$f":"SUM(#REF!*17%)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!+I4)","v":{"$error":"#REF!"}}]
["PSIRA Grade B Security Supervisor - Dog handler  (Night Shift) Armed ",2,{"$nulls":6},{"$f":"SUM(#REF!*17%)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!+I5)","v":{"$error":"#REF!"}}]
["PSIRA Grade C Security Officers (Day Shift) Armed ",19,{"$nulls":6},{"$f":"SUM(#REF!*17%)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!+I6)","v":{"$error":"#REF!"}}]
["PSIRA Grade C Security Officers (Day Shift) Unarmed ",12,{"$nulls":6},{"$f":"SUM(#REF!*17%)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!+I7)","v":{"$error":"#REF!"}}]
["PSIRA Grade C Security Officers (Night Shift) Armed ",15,{"$nulls":6},{"$f":"SUM(#REF!*17%)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!+I8)","v":{"$error":"#REF!"}}]
["PSIRA Grade C Security Officers (Night Shift) Unarmed ",16,{"$nulls":6},{"$f":"SUM(#REF!*17%)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!+I9)","v":{"$error":"#REF!"}}]
["PSIRA GRADE C Dog Handlers (Night Shift) ",4,{"$nulls":6},{"$f":"SUM(#REF!*17%)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!+I10)","v":{"$error":"#REF!"}}]
["PSIRA Grade C Pipeline Patrol tactical (Day Shift) Armed ",4,{"$nulls":6},{"$f":"SUM(#REF!*17%)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!+I11)","v":{"$error":"#REF!"}}]
["PSIRA Grade C Pipeline Patrol tactical (Night Shift) Armed ",4]
["Firearms: Handguns",25]
["Firearms : Rifles",2]
["Digital Hand Radios",35]
["Dogs",4]
["Dog Kennels",4]
["Guard Monitoring points ",110]
["LDV Double-Cab (Bakkie)",2]
["Bullet Proof vests ",25]
["ADHOC Services","Provisional SUM",{"v":1000000,"d":"R1,000,000.00"}]
["TOTAL cost excluding vat (Per Month)",null,null,{"$f":"SUM(D21:D21)","v":0}]
["VAT 15%",null,null,{"$f":"D22*15%","v":0}]
["TOTAL COST PER MONTH ",null,null,{"$f":"D22+D23","v":0}]
["TOTAL COST FOR 12 MONTHS",null,null,{"$f":"D24*12","v":0}]
["TOTAL COST FOR 60  MONTHS",null,null,{"$f":"D25*12","v":0}]
[]
["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:"]
[]
["NB: Adhoc service will be caped to R1 000 000 per year and R5 000 000 for five (5) years. When populating the BOQ include it as part of Form of Offer"]

{"sheet":"CENTRAL REGION","index":3,"n_rows":36,"n_cols":12,"rows_kept":36,"merged":[[1,0,1,3],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[28,0,29,3],[31,1,31,3],[33,1,33,3],[35,0,37,3]]}
[]
["CENTRAL REGION"]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE ","TOTAL INCL"]
["PSIRA Grade B Security Supervisor - Dog handler (Day Shift) Armed ",1,{"$nulls":5},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 (Night Shift) Armed ",1,{"$nulls":5},15831.65,null,{"$f":"SUM(H5*17%)","v":2691.3805},null,{"$f":"SUM(H5+J5)","v":18523.0305}]
["PSIRA Grade C Security Officers (Day Shift) Armed ",20,{"$nulls":5},14098.19]
["PSIRA Grade C Security Officers (Day Shift) Unarmed ",17,{"$nulls":5},14280.69]
["PSIRA Grade C Security Officers (Night Shift) Armed ",9,{"$nulls":5},14098.19]
["PSIRA Grade C Security Officers (Night Shift) Unarmed ",20,{"$nulls":5},14280.69]
["PSIRA GRADE C Dog Handlers (Night Shift) Armed ",11,{"$nulls":5},14098.19]
["PSIRA Grade C Pipeline Patrol tactical  (Day Shift) Armed",2,{"$nulls":5},14280.69,null,2427.7173000000003,null,16708.4073]
["PSIRA Grade C Pipeline Patrol tactical (Night Shift) Armed ",2]
["Firearms :Handguns",23]
["Firearms : Rifles",1]
["Digital Hand Radios",35]
["Dogs",11]
["Dog Kennels",11]
["Guard Monitoring points ",115]
["LDV Double-Cab (Bakkie)",1]
["Bullet Proof vests ",23]
["ADHOC Services","Provisional SUM",{"v":1000000,"d":"R1,000,000.00"}]
[]
["TOTAL cost excluding vat (Per Month)",null,null,{"$f":"SUM(D21:D21)","v":0}]
["VAT 15%",null,null,{"$f":"D23*15%","v":0}]
["TOTAL COST PER MONTH ",null,null,{"$f":"D23+D24","v":0}]
["TOTAL COST FOR 12 MONTHS",null,null,{"$f":"D25*12","v":0}]
["TOTAL COST FOR 60 MONTHS",null,null,{"$f":"D26*12","v":0}]
[]
["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:"]
[]
["NB: Adhoc service will be caped to R1 000 000 per year and R5 000 000 for five (5) years. When populating the BOQ include it as part of Form of Offer"]

{"sheet":"SOUTH REGION","index":4,"n_rows":32,"n_cols":4,"rows_kept":32,"merged":[[1,0,1,3],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[24,0,25,3],[27,1,27,3],[29,1,29,3],[31,0,33,3]]}
[]
["SOUTH REGION"]
["DESCRIPTION ","NO.OF GUARDS /EQUIPMENT","UNIT PRICE ","TOTAL INCL"]
["PSIRA Grade B Security Supervisor - Dog handler  (Day Shift) Armed ",1]
["PSIRA Grade B Security Supervisor -  Dog handler  (Night Shift) Armed ",1]
["PSIRA Grade C Security Officers (Day Shift) Armed ",27]
["PSIRA Grade C Security Officers (Day Shift) Unarmed ",27]
["PSIRA Grade C Security Officers (Night Shift) Armed ",18]
["PSIRA Grade C Security Officers (Night Shift) Unarmed ",26]
["PSIRA GRADE C Dog Handlers (Night Shift) Armed",9]
["Firearms :Handguns",28]
["Digital Hand Radios",50]
["Dogs",9]
["Dog Kennels",9]
["Guard Monitoring points ",120]
["Bullet Proof vests ",28]
["ADHOC Services","Provisional SUM",{"v":1000000,"d":"R1,000,000.00"}]
[]
["TOTAL cost excluding vat (Per Month)",null,null,{"$f":"SUM(D17:D17)","v":0}]
["VAT 15%",null,null,{"$f":"D19*15%","v":0}]
["TOTAL COST PER MONTH ",null,null,{"$f":"D19+D20","v":0}]
["TOTAL COST FOR 12 MONTHS",null,null,{"$f":"D21*12","v":0}]
["TOTAL COST FOR 60 MONTHS",null,null,{"$f":"D22*12","v":0}]
[]
["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:"]
[]
["NB: Adhoc service will be caped to R1 000 000 per year and R5 000 000 for five (5) years. When populating the BOQ include it as part of Form of Offer"]