{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Gauteng"],"read":"whole","date_system":"1900"}

{"sheet":"Gauteng","index":0,"n_rows":78,"n_cols":55,"rows_kept":78,"merged":[[0,0,0,1],[0,10,0,11],[0,12,2,16],[0,17,0,18],[0,19,0,20],[0,21,0,22],[0,23,0,24],[0,25,2,29],[0,30,1,31],[0,32,2,36],[0,37,0,50],[0,51,2,54],[1,0,1,1],[1,10,1,11],[1,17,1,18],[1,19,1,20],[1,21,1,22],[1,23,1,24],[1,37,1,43],[1,44,1,50],[2,0,2,1],[2,2,2,4],[2,10,2,11],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,23,2,24],[2,30,2,31],[2,37,2,43],[2,44,2,50],[66,4,66,6],[67,4,67,6],[68,4,68,6],[69,4,69,6],[70,4,70,6],[71,4,71,6],[72,4,72,6],[73,4,73,6],[74,4,74,6],[75,4,75,6],[76,4,76,6],[77,4,77,6]]}
["Gauteng",{"$nulls":9},"Mail/Logistics/Support\nUNARMED",null,"Total Requirements & Pricing (Grade B - Unarmed) \n5 x Day Week (Monday to Friday)\nINCL VAT",{"$nulls":4},"Mail - UNARMED",null,"Retail - UNARMED",null,"Logistics - UNARMED",null,"Support - UNARMED",null,"Total Requirements & Pricing (Grade C - Unarmed) \n5 x Day Week (Monday to Friday)\nINCL VAT",{"$nulls":4},"Weekends \n(Saturday & Sunday)\nUNARMED",null,"Total Requirements & Pricing (Grade C - Unarmed) \nWeekends (Saturday and Sunday)\n- INCL VAT",{"$nulls":4},"Armed Guarding",{"$nulls":13},"SUMMARY of REQUIREMENTS & PRICING\n(12 Months)"]
["PROVINCE: Gauteng",{"$nulls":9},"(5 day week)",{"$nulls":6},"(5 Day Week)",null,"(5 Day Week)",null,"(5 Day Week)",null,"(5 Day Week)",{"$nulls":13},"Monday to Friday (Armed) ",{"$nulls":6},"Week Ends (Armed)"]
["BIDDER",null,"Bidder to insert Company Name ",{"$nulls":7},"Grade B",{"$nulls":6},"Grade C",null,"Grade C",null,"Grade C",null,"Grade C",{"$nulls":6},"Grade C",{"$nulls":6},"Grade C (Armed)",{"$nulls":6},"Grade C (Armed)"]
[]
["Gauteng","Cost Centre No","Region","SAPO Area","Province ","Business Unit\n(Mail, Retail, \nLogistics, Support)","Open \nFacility\n(If Yes = 1) ","MVL\nYes / No\n(If Yes = 1)","Closed \nFacility\n(If Yes = 1)","Comments (If Any)","Day","Night","Total Requirements \nper Site per Shift\nGrade B (Unarmed) \n(Total No of Guards)","Unit Pricing \nPER Guard\nGrade B (Unarmed)\n Per 12 Hour Shift \n(Incl Vat)","Monthly Cost \nPER GUARD\nGrade B  (Unarmed \n(Incl Vat)","Total Monthly Cost \nALL GUARDS per SITE \nGrade B (Unarmed) \n(Incl Vat)","12 Month Cost for \nGrade B \nUNARMED (Incl Vat)","Day","Night","Day","Night","Day","Night","Day","Night","Total Requirements \nper Site per Shift\nGrade C (Unarmed) \n(Total No of Guards)","Unit Pricing PER Guard\nGrade C (Unarmed)\n Per 12 Hour Shift \n(Incl Vat)","Monthly Cost \nPER GUARD\nGrade C  (Unarmed \n(Incl Vat)","Total Monthly Cost \nALL GUARDS per SITE \nGrade C (Unarmed) \n(Incl Vat)","12 Month Cost for \nGrade C \nUNARMED (Incl Vat)","Day","Night","Total Requirements \nper Site per Shift\nGrade C (Unarmed)\n(Total No of Guards)","Unit Pricing PER Guard\nGrade C (Unarmed)\n Per 12 Hour Shift \n(Incl Vat)","Monthly Cost \nPER GUARD\nGrade C  (Unarmed \n(Incl Vat)","Total Monthly Cost \nALL GUARDS per SITE \nGrade C (Unarmed) \n(Incl Vat)","12 Month Cost for \nGrade C \nUNARMED (Incl Vat)","Monday to Friday\nDay\nArmed","Monday to Friday\nNight \nArmed","Total Requirements \nper Site per Shift\nGrade C - Armed\n(Total No of Guards)","Monday to Friday\nUnit Pricing - PER Guard\nGrade C (Armed)\n Per 12 Hour Shift - (Incl Vat)","Monday to Friday\nMonthly Cost\nPER GUARD\nGrade C  (Armed) \n(Incl Vat)","Monday to Friday\nTotal Monthly Cost \nALL GUARDS per SITE \nGrade C (Armed) \n(Incl Vat)","Monday to Friday\n12 Month Cost for \nGrade C \nARMED (Incl Vat)","Weekends\nDay\nArmed","Weekends\nNight \nArmed","Total Requirements \nper Site per Shift\nGrade C - Armed\n(Total No of Guards)","Weekends\nUnit Pricing - PER Guard\nGrade C (Armed)\n Per 12 Hour Shift - (Incl Vat)","Weekends\nMonthly Cost \nPER GUARD\nGrade C  (Armed) \n(Incl Vat)","Weekends\nTotal Monthly Cost \nALL GUARDS per SITE \nGrade C (Armed) \n(Incl Vat)","12 Month Cost for \nGrade C\nARMED (Incl Vat)","TOTAL NUMBER OF GUARDS\nGrade B and Grade C \nUNARMED ","TOTAL NUMBER OF GUARDS\nGrade C \nARMED ","TOTAL GUARDING \nUNARMED and ARMED\nGRADE B and C","TOTAL 12 MONTH COST \nGrade B and Grade C \nUNARMED & ARMED (Incl Vat) "]
["JOHANNESBURG COURIER / SPEED SERVICES",14825,"Gauteng","Ekurhuleni","Gauteng","Logistics",1,0,0,null,1,0,{"$f":"SUM(K6:L6)","v":1},0,0,{"$f":"O6*M6","v":0},{"$f":"P6*12","v":0},0,0,0,0,4,3,0,0,{"$f":"SUM(R6:Y6)","v":7},0,0,{"$f":"AB6*Z6","v":0},{"$f":"AC6*12","v":0},3,3,{"$f":"SUM(AE6:AF6)","v":6},0,0,{"$f":"AI6*AG6","v":0},{"$f":"AJ6*12","v":0},2,2,{"$f":"SUM(AL6:AM6)","v":4},0,0,{"$f":"AP6*AN6","v":0},{"$f":"AQ6*12","v":0},2,2,{"$f":"SUM(AS6:AT6)","v":4},0,0,{"$f":"AW6*AU6","v":0},{"$f":"AX6*12","v":0},{"$f":"M6+Z6+AG6","v":14},{"$f":"AN6+AU6","v":8},{"$f":"SUM(AZ6:BA6)","v":22},{"$f":"Q6+AD6+AK6+AR6+AY6","v":0}]
["Tshwane Mail Centre",96098,"Gauteng","Tshwane","Gauteng","Mail",1,0,0,null,1,0,{"$f":"SUM(K7:L7)","v":1},0,0,{"$f":"O7*M7","v":0},{"$f":"P7*12","v":0},6,3,0,0,0,0,0,0,{"$f":"SUM(R7:Y7)","v":9},0,0,{"$f":"AB7*Z7","v":0},{"$f":"AC7*12","v":0},2,2,{"$f":"SUM(AE7:AF7)","v":4},0,0,{"$f":"AI7*AG7","v":0},{"$f":"AJ7*12","v":0},2,2,{"$f":"SUM(AL7:AM7)","v":4},0,0,{"$f":"AP7*AN7","v":0},{"$f":"AQ7*12","v":0},2,2,{"$f":"SUM(AS7:AT7)","v":4},0,0,{"$f":"AW7*AU7","v":0},{"$f":"AX7*12","v":0},14,{"$f":"AN7+AU7","v":8},{"$f":"SUM(AZ7:BA7)","v":22},0]
["WITSPOS Mail Centre",21888,"Gauteng","Johannesburg","Gauteng","MAIL",1,0,0,null,3,0,3,0,0,0,0,5,4,0,0,0,0,0,0,9,0,0,0,0,2,2,4,0,0,0,0,2,2,4,0,0,0,0,2,2,4,0,0,0,0,16,8,24,0]
["Birchleigh Depot",12051,"Gauteng","Ekurhuleni","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Brakpan Depot",13262,"Gauteng","Ekurhuleni","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Daveyton Depot",13342,"Gauteng","Ekurhuleni","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Ekangala Depot/ PO",16400,"Gauteng","Tshwane","Gauteng","Mail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Germiston Depot",18250,"Gauteng","Ekurhuleni","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,2,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["GERMISTON OFFICE OF EXCHANGE",14167,"Gauteng","Ekurhuleni","Gauteng","Mail",1,0,0,null,2,0,2,0,0,0,0,8,2,0,0,0,0,0,0,10,0,0,0,0,2,2,4,0,0,0,0,2,2,4,0,0,0,0,2,2,4,0,0,0,0,16,8,24,0]
["Heidelberg Depot",14142,"Gauteng","Ekurhuleni","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Menlo Park Depot",25970,"Gauteng","Tshwane","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Randburg Depot",31444,"Gauteng","Johannesburg","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Soshanguve Depot",27810,"Gauteng","Tshwane","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Themba Depot",29531,"Gauteng","Johannesburg","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["JIMC",null,"Gauteng","Ekurhuleni","Gauteng","Mail",1,0,0,null,0,0,0,0,0,0,0,3,3,0,0,0,0,0,0,6,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,0,8,0]
["LENASIA",23622,"Gauteng","Johannesburg","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["MAMELODI",25175,"Gauteng","Tshwane","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["Pinegowrie Post Office ",null,"Gauteng","Johannesburg","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,2,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["Pimville",30031,"Gauteng","Johannesburg","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["INDUSTRIA",20388,"Gauteng","Johannesburg","Gauteng","Retail",0,0,1,null,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,2,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["RETHABILE",32075,"Gauteng","Tshwane","Gauteng","Retail",1,0,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,{"$f":"AI26*AG26","v":0},{"$f":"AJ26*12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["ROSETTENVILLE",32821,"Gauteng","Johannesburg","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,{"$f":"AI27*AG27","v":0},{"$f":"AJ27*12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["SEBOKENG",33647,"Gauteng","Vanderbijlpark","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["SUNNYSIDE",35729,"Gauteng","Tshwane","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["ALBERTON",10314,"Gauteng","Ekurhuleni","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,2,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["BENONI",11590,"Gauteng","Ekurhuleni","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["MARAISBURG",25327,"Gauteng","Johannesburg","Gauteng","Retail",0,0,1,null,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,2,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["EDENVALE",16233,"Gauteng","Ekurhuleni","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["KRUGERSDORP",23028,"Gauteng","Johannesburg","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,4,0,1,1,0,0,0,0,6,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,0,8,0]
["LYTTELTON (VERWOERDBURG)",38129,"Gauteng","Tshwane","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["NIGEL",28024,"Gauteng","Ekurhuleni","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["VANDERBIJLPARK",37626,"Gauteng","Vanderbijlpark","Gauteng","Retail",1,1,0,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["7 Church (Data Centre) ",null,"Gauteng","Tshwane","Gauteng","Support",1,0,0,null,1,1,2,0,0,0,0,0,0,0,0,0,0,6,3,9,0,0,0,0,2,2,4,0,0,0,0,2,2,4,0,0,0,0,2,2,4,0,0,0,0,15,8,23,0]
["MOOI Street",null,"Gauteng","Johannesburg","Gauteng","Support",1,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,2,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["Church Square",null,"Gauteng","Tshwane","Gauteng","Support",1,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,2,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["SCM",null,"Gauteng","Tshwane","Gauteng","Support",1,0,0,null,0,0,0,0,0,{"$f":"O41*M41","v":0},{"$f":"P41*12","v":0},0,0,0,0,0,0,2,2,4,0,0,0,0,2,2,{"$f":"SUM(AE41:AF41)","v":4},0,0,{"$f":"AI41*AG41","v":0},{"$f":"AJ41*12","v":0},0,0,{"$f":"SUM(AL41:AM41)","v":0},0,0,{"$f":"AP41*AN41","v":0},{"$f":"AQ41*12","v":0},0,0,{"$f":"SUM(AS41:AT41)","v":0},0,0,{"$f":"AW41*AU41","v":0},{"$f":"AX41*12","v":0},{"$f":"M41+Z41+AG41","v":8},{"$f":"AN41+AU41","v":0},{"$f":"SUM(AZ41:BA41)","v":8},{"$f":"Q41+AD41+AK41+AR41+AY41","v":0}]
["Isando",null,"Gauteng","Ekurhuleni","Gauteng","Retail",1,0,null,null,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0]
["NPC",null,"Gauteng","Tshwane","Gauteng","Support",1,0,0,null,1,0,1,0,0,0,0,0,0,0,0,0,0,3,2,5,0,0,0,0,2,2,4,0,0,0,0,1,1,2,0,0,0,0,0,1,1,0,0,0,0,10,3,13,0]
{"$rows_empty":19}
[{"$nulls":5},"TOTAL",{"$f":"SUM(G6:G62)","v":36},{"$f":"SUM(H6:H62)","v":15},{"$f":"SUM(I6:I62)","v":2},null,{"$f":"SUM(K6:K62)","v":9},1,10,0,0,0,0,27,18,5,22,4,3,13,9,101,0,0,0,0,{"$f":"SUM(AE6:AE62)","v":46},46,92,0,0,0,0,11,11,22,0,0,0,0,10,11,21,0,0,0,0,203,43,246,0]
[]
[]
["Bidders MUST ALSO QUOTE on their ADHOC Daily rate(INCL VAT)"]
[{"$nulls":4},"Day Shift (Incl VAT)"]
["UNARMED - Grade B - 12 hour shift ",{"$nulls":3},0]
["UNARMED - Grade C - 12 hour shift ",{"$nulls":3},0]
["ARMED - Grade C - 12 hour shift ",{"$nulls":3},0]
["PUBLIC HOLIDAY - UNARMED - GRADE B - 12 hour shift ",{"$nulls":3},0]
["PUBLIC HOLIDAY - UNARMED - GRADE C - 12 hour shift ",{"$nulls":3},0]
[{"$nulls":4},"Night Shift (Incl VAT)"]
["UNARMED - Grade B - 12 hour shift ",{"$nulls":3},0]
["UNARMED - Grade C - 12 hour shift ",{"$nulls":3},0]
["ARMED - Grade C - 12 hour shift ",{"$nulls":3},0]
["PUBLIC HOLIDAY - UNARMED - GRADE B - 12 hour shift ",{"$nulls":3},0]
["PUBLIC HOLIDAY - UNARMED - GRADE C - 12 hour shift ",{"$nulls":3},0]