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

{"sheet":"Central Free State","index":0,"n_rows":84,"n_cols":55,"rows_kept":84,"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],[72,4,72,6],[73,4,73,6],[74,4,74,6],[75,4,75,6],[76,4,76,6],[77,4,77,6],[78,4,78,6],[79,4,79,6],[80,4,80,6],[81,4,81,6],[82,4,82,6],[83,4,83,6]]}
["REGION: CENTRAL",{"$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: FREE STATE",{"$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)"]
[]
["Free State ","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) "]
["BAIN'S VLEI",50499,"Central","Bloemfontein","Free State","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}]
["BOSHOF",90605,"Central","Bloemfontein","Free State","Retail",0,0,1,"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},0,0,0,1,0,0,0,0,{"$f":"SUM(R7:Y7)","v":1},0,0,{"$f":"AB7*Z7","v":0},{"$f":"AC7*12","v":0},1,1,{"$f":"SUM(AE7:AF7)","v":2},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},3,{"$f":"AN7+AU7","v":0},{"$f":"SUM(AZ7:BA7)","v":3},0]
["BRANDFORT",51338,"Central","Welkom","Free State","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]
["DEALESVILLE",51965,"Central","Bloemfontein","Free State","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]
["DENEYSVILLE",52032,"Central","Welkom","Free State","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]
["EDENBURG",52313,"Central","Bloemfontein","Free State","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]
["EDENVILLE",52388,"Central","Bloemfontein","Free State","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]
["HOBHOUSE",53853,"Central","Bloemfontein","Free State","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]
["JACOBSDAL",92343,"Central","Bloemfontein","Free State","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]
["JAGERSFONTEIN",53991,"Central","Bloemfontein","Free State","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]
["MELODING",51320,"Central","Welkom","Free State","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]
["MEMEL",55399,"Central","Welkom","Free State","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]
["ORANJEVILLE",55951,"Central","Welkom","Free State","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]
["STEYNSRUS",57350,"Central","Welkom","Free State","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]
["TROMPSBURG",57841,"Central","Bloemfontein","Free State","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]
["TSHESENG",54398,"Central","Welkom","Free State","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]
["TSHIAME",70086,"Central","Welkom","Free State","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]
["TWEELING",57988,"Central","Welkom","Free State","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]
["VENTERSBURG",58192,"Central","Welkom","Free State","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]
["VILLIERS",58617,"Central","Welkom","Free State","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]
["WARDEN",58891,"Central","Welkom","Free State","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,{"$f":"AI26*AG26","v":0},{"$f":"AJ26*12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["ZAMDELA",59876,"Central","Welkom","Free State","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,{"$f":"AI27*AG27","v":0},{"$f":"AJ27*12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,4,0]
["OLD POSTBANK BUILDING",null,"Central","Bloemfontein","Free State","Support",0,0,1,"Dilapidated building. Cannot install alarm",0,0,0,0,0,0,0,0,0,0,0,0,0,2,2,4,0,0,0,0,2,2,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,0,8,0]
["BLOEMCON",51353,"Central","Bloemfontein","Free State","Logistics",1,0,0,"Alarm will not secure the perimeter fencing (devils fork), or outside of the building (piping and wiring), which was the main target of criminals in the past.  Located in an Industrial are.",0,0,0,0,0,0,0,0,0,0,0,2,2,0,0,4,0,0,0,0,2,2,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,0,8,0]
["BETHLEHEM",50633,"Central","Welkom","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",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]
["BLOEMFONTEIN",50842,"Central","Bloemfontein","Free State","Retail",1,1,0,"Regional buillding, Transport and Logistics, Mail Centre as well as the Bloemfontin Post Office, which is anMVL Office.",0,0,0,0,0,0,0,0,0,4,2,0,0,0,0,6,0,0,0,0,2,2,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,0,10,0]
["FICHARDT PARK",55365,"Central","Bloemfontein","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",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]
["FRANKFORT, OFS",53082,"Central","Welkom","Free State","Retail",1,0,0,"Guards to be removed once alarm is linked ",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]
["HARRISMITH",53572,"Central","Welkom","Free State","Retail",1,0,0,"Guards to be removed once alarm is linked ",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]
["HENNENMAN",53717,"Central","Welkom","Free State","Retail",1,0,0,"Guards to be removed once alarm is linked ",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]
["KAGISANONG",54148,"Central","Bloemfontein","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",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]
["KOFFIEFONTEIN",54349,"Central","Bloemfontein","Free State","Retail",1,0,0,"Guards to be removed once alarm is linked ",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]
["KROONSTAD",54695,"Central","Welkom","Free State","Retail",1,0,0,"Guards to be removed once alarm is linked ",0,0,0,0,0,0,0,0,0,1,2,0,0,0,0,3,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,5,0,5,0]
["LANGENHOVENPARK",53564,"Central","Bloemfontein","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",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]
["LUCKHOF",55115,"Central","Bloemfontein","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",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]
["Marquard",55252,"Central","Bloemfontein","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",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]
["MOKODUMELA",57866,"Central","Welkom","Free State","Retail",1,0,0,"Guards to be removed once alarm is linked ",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]
["SASOLBURG",56865,"Central","Welkom","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",0,0,0,0,0,0,0,0,0,1,2,0,0,0,0,3,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,5,0,5,0]
["TWEESPRUIT",58054,"Central","Bloemfontein","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",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]
["VIRGINIA",58682,"Central","Welkom","Free State","Retail",1,0,0,"Guards to be removed once alarm is linked ",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]
["VREDE",58754,"Central","Welkom","Free State","Retail",1,0,0,"Guards to be removed once alarm is linked ",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]
["WELKOM",59102,"Central","Welkom","Free State","Retail",1,1,0,"Guards to be removed once alarm is linked ",0,0,0,0,0,0,0,0,0,1,2,0,0,0,0,3,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,5,0,5,0]
{"$rows_empty":21}
[{"$nulls":5},"TOTAL",{"$f":"SUM(G6:G68)","v":19},10,23,null,0,0,0,0,0,0,0,0,0,14,44,2,2,2,2,66,0,0,0,0,{"$f":"SUM(AE6:AE68)","v":44},45,89,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,155,0,155,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]