{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["North Mpumalanga"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"North Mpumalanga","index":0,"n_rows":52,"n_cols":55,"rows_kept":52,"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,43],[0,44,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,2,2,3],[2,4,2,7],[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],[37,0,37,5],[39,2,39,8],[40,2,40,5],[40,6,40,8],[41,2,41,5],[41,6,41,8],[42,2,42,5],[42,6,42,8],[43,2,43,5],[43,6,43,8],[44,2,44,5],[44,6,44,8],[45,2,45,5],[45,6,45,8],[46,2,46,5],[46,6,46,8],[47,2,47,5],[47,6,47,8],[48,2,48,5],[48,6,48,8],[49,2,49,5],[49,6,49,8],[50,2,50,5],[50,6,50,8],[51,2,51,5],[51,6,51,8]]}
["REGION: NORTH",{"$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":6},"Armed Guarding",{"$nulls":6},"SUMMARY of REQUIREMENTS & PRICING\n(12 Months)"]
["PROVINCE: MPUMALANGA",{"$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)"]
[null,null,"BIDDER:",{"$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)"]
[]
["Mpumalanga","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) "]
["GA NALA",22822,"Mpumalanga","Mpumalanga West","Mpumalanga","Retail",1,0,0,"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,0,1,0,0,0,0,{"$f":"SUM(R6:Y6)","v":1},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":3},{"$f":"AN6+AU6","v":0},{"$f":"SUM(AZ6:BA6)","v":3},{"$f":"Q6+AD6+AK6+AR6+AY6","v":0}]
["EMALAHLENI CENTRAL",36571,"Mpumalanga","Mpumalanga West","Mpumalanga","Retail",1,1,0,"Closed facilty and requires guarding ",0,0,0,0,0,{"$f":"O7*M7","v":0},{"$f":"P7*12","v":0},0,0,0,1,0,0,0,0,1,0,0,{"$f":"AB7*Z7","v":0},{"$f":"AC7*12","v":0},1,1,2,0,0,{"$f":"AI7*AG7","v":0},{"$f":"AJ7*12","v":0},0,0,0,0,0,{"$f":"AP7*AN7","v":0},{"$f":"AQ7*12","v":0},0,0,0,0,0,0,{"$f":"AX7*12","v":0},3,{"$f":"AN7+AU7","v":0},3,0]
["WITRIVIER",39669,"Mpumalanga","Mpumalanga East","Mpumalanga","Retail",1,1,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,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]
["STANDERTON",35174,"Mpumalanga","Mpumalanga West","Mpumalanga","Retail",1,1,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]
["MIDDELBURG",26273,"Mpumalanga","Mpumalanga West","Mpumalanga","Retail",1,1,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]
["LYDENBURG",24576,"Mpumalanga","Mpumalanga East","Mpumalanga","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,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]
["NELSPRUIT MAIL CENTRE",24808,"Mpumalanga","Mpumalanga East","Mpumalanga","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]
[{"$nulls":9},"Closed facilty and requires guarding ",0,0,{"$f":"SUM(K13:L13)","v":0},0,0,{"$f":"O13*M13","v":0},{"$f":"P13*12","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R13:Y13)","v":0},0,0,0,0,0,0,{"$f":"SUM(AE13:AF13)","v":0},0,0,{"$f":"AI13*AG13","v":0},{"$f":"AJ13*12","v":0},0,0,{"$f":"SUM(AL13:AM13)","v":0},0,0,{"$f":"AP13*AN13","v":0},0,0,0,{"$f":"SUM(AS13:AT13)","v":0},0,0,{"$f":"AW13*AU13","v":0},{"$f":"AX13*12","v":0},0,{"$f":"AN13+AU13","v":0},{"$f":"SUM(AZ13:BA13)","v":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":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":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[{"$nulls":16},0,{"$nulls":11},0,0,{"$nulls":13},0]
[]
["TOTAL",{"$nulls":5},{"$f":"SUM(G6:G37)","v":7},{"$f":"SUM(H6:H37)","v":4},{"$f":"SUM(I6:I37)","v":0},null,{"$f":"SUM(K6:K37)","v":0},0,0,0,0,0,0,0,0,0,7,0,0,0,0,7,0,0,0,0,5,7,12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19,0,19,0]
[]
[null,null,"Bidders MUST ALSO QUOTE on their ADHOC Daily rate(INCL VAT)"]
[{"$nulls":6},"Day Shift (Incl VAT)"]
[null,null,"UNARMED - Grade B - 12 hour shift ",{"$nulls":3},0]
[null,null,"UNARMED - Grade C - 12 hour shift ",{"$nulls":3},0]
[null,null,"ARMED - Grade C - 12 hour shift ",{"$nulls":3},0]
[null,null,"PUBLIC HOLIDAY - UNARMED - GRADE B - 12 hour shift ",{"$nulls":3},0]
[null,null,"PUBLIC HOLIDAY - UNARMED - GRADE C - 12 hour shift ",{"$nulls":3},0]
[{"$nulls":6},"Night Shift (Incl VAT)"]
[null,null,"UNARMED - Grade B - 12 hour shift ",{"$nulls":3},0]
[null,null,"UNARMED - Grade C - 12 hour shift ",{"$nulls":3},0]
[null,null,"ARMED - Grade C - 12 hour shift ",{"$nulls":3},0]
[null,null,"PUBLIC HOLIDAY - UNARMED - GRADE B - 12 hour shift ",{"$nulls":3},0]
[null,null,"PUBLIC HOLIDAY - UNARMED - GRADE C - 12 hour shift ",{"$nulls":3},0]