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

{"sheet":"Western - Western Cape","index":0,"n_rows":37,"n_cols":55,"rows_kept":37,"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],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[36,4,36,6]]}
["REGION: WESTERN",{"$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:WESTERN CAPE",{"$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)"]
[]
["Western Cape","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) "]
["BELLA VISTA",61441,"Western","Outeniqua","Western Cape","Retail",0,0,1,"Closed facilty and requires guarding ",0,0,{"$f":"SUM(K6:L6)","v":0},0,0,{"$f":"O6*M6","v":0},{"$f":"P6*12","v":0},0,0,1,1,0,0,0,0,{"$f":"SUM(R6:Y6)","v":2},0,0,{"$f":"AB6*Z6","v":0},{"$f":"AC6*12","v":0},1,1,{"$f":"SUM(AE6:AF6)","v":2},0,0,{"$f":"AI6*AG6","v":0},{"$f":"AJ6*12","v":0},0,0,{"$f":"SUM(AL6:AM6)","v":0},0,0,{"$f":"AP6*AN6","v":0},{"$f":"AQ6*12","v":0},0,0,{"$f":"SUM(AS6:AT6)","v":0},0,0,{"$f":"AW6*AU6","v":0},{"$f":"AX6*12","v":0},{"$f":"M6+Z6+AG6","v":4},{"$f":"AN6+AU6","v":0},{"$f":"SUM(AZ6:BA6)","v":4},{"$f":"Q6+AD6+AK6+AR6+AY6","v":0}]
["CAPE MAIL HUB",61299,"Western","Peninsula Retail","Western Cape","Mail",1,0,0,"Closed facilty and requires guarding ",0,0,{"$f":"SUM(K7:L7)","v":0},0,0,{"$f":"O7*M7","v":0},{"$f":"P7*12","v":0},8,4,0,0,0,0,0,0,{"$f":"SUM(R7:Y7)","v":12},0,0,{"$f":"AB7*Z7","v":0},{"$f":"AC7*12","v":0},4,4,{"$f":"SUM(AE7:AF7)","v":8},0,0,{"$f":"AI7*AG7","v":0},{"$f":"AJ7*12","v":0},0,0,{"$f":"SUM(AL7:AM7)","v":0},0,0,{"$f":"AP7*AN7","v":0},{"$f":"AQ7*12","v":0},0,0,{"$f":"SUM(AS7:AT7)","v":0},0,0,{"$f":"AW7*AU7","v":0},{"$f":"AX7*12","v":0},20,{"$f":"AN7+AU7","v":0},{"$f":"SUM(AZ7:BA7)","v":20},0]
["CITRUSDAL (RPO)",68392,"Western","Nama-Khoi","Western Cape","Retail",0,0,1,"Closed facilty and requires guarding ",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]
["MACASSAR",73643,"Western","Atlantic/Winelands","Western Cape","Retail",0,0,1,"Closed facilty and requires guarding ",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]
["MITCHELL'S PLAIN DEPOT",61337,"Western","Peninsula Mail","Western Cape","Mail",1,0,0,"Closed facilty and requires guarding ",0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,0]
["VAN RHYNSDORP",88165,"Western","Atlantic/Winelands","Western Cape","Retail",0,0,1,"Closed facilty and requires guarding ",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]
["BELLVILLE",61458,"Western","Peninsula Retail","Western Cape","Retail",1,0,0,"Closed facilty and requires guarding ",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]
["WOLSELEY",89117,"Western","Peninsula Retail","Western Cape","Retail",1,0,0,"Closed facilty and requires guarding ",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]
[{"$nulls":9},"Closed facilty and requires guarding ",0,0,0,0,0,0,{"$f":"P14*12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AC14*12","v":0},0,0,0,0,0,0,{"$f":"AJ14*12","v":0},0,0,0,0,0,0,{"$f":"AQ14*12","v":0},0,0,0,0,0,0,{"$f":"AX14*12","v":0},0,0,0,0]
[{"$nulls":9},"Closed facilty and requires guarding ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"Closed facilty and requires guarding ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"Closed facilty and requires guarding ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"Closed facilty and requires guarding ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"Closed facilty and requires guarding ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[{"$nulls":5},"TOTAL",{"$f":"SUM(G6:G21)","v":4},{"$f":"SUM(H6:H21)","v":0},{"$f":"SUM(I6:I21)","v":4},null,{"$f":"SUM(K6:K21)","v":0},0,0,0,0,0,0,8,5,4,6,0,0,0,0,23,0,0,0,0,{"$f":"SUM(AE6:AE21)","v":10},11,21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,44,0,44,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]