{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Cover Sheet","Frances Baard District","Other Districts","Total Pricing"],"not_rendered":{"images":1,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"Cover Sheet","index":0,"n_rows":39,"n_cols":8,"rows_kept":39,"merged":[[1,7,1,11],[2,6,2,12],[13,0,13,12],[15,4,15,11],[17,4,17,11],[19,4,19,11],[21,4,21,11],[24,0,24,12],[26,0,26,12],[27,0,27,12],[28,0,28,12],[29,0,29,12],[30,0,30,12],[31,0,31,12],[32,0,32,12],[33,0,33,12],[34,0,34,12],[35,0,35,12],[36,0,36,12],[37,0,37,12],[38,0,38,12],[39,0,39,12],[40,0,40,12],[41,0,41,12],[42,0,42,12],[43,0,43,12],[44,0,44,12],[45,0,45,12]]}
[]
[{"$nulls":7},"ANNEXURE G"]
[{"$nulls":6},"(Form of Offer and Acceptance)."]
{"$rows_empty":10}
["PRICING SCHEDULE"]
[]
["DEPARTMENT:",{"$nulls":3},"DEPARTMENT OF SPORT, ARTS AND CULTURE"]
[]
["RFB NO:",{"$nulls":3}," BID NCDSAC-004-2025/26"]
[]
["RFB NAME:",{"$nulls":3},"APPOINTMENT OF A SERVICE PROVIDER TO RENDER PHYSICAL SECURITY SERVICES TO THE DEPARTMENT FOR THE PERIOD OF THREE (3) YEARS"]
[]
["BIDDER NAME"]
[]
[]
["PRICE INSTRUCTIONS"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet for BID NCDSAC-004-2025/26 contains the financial response templates for the bid. The bid pricing submission/schedule instructions in this document must be read in conjunction with instructions or notes embedded in the various tabs of spreadsheet (Pricing Schedule).  "]
[]
["1.1 The financial response template consists of the following sheets:"]
["1.1.1 Frances Baard District;"]
["1.1.2 Other Districts;"]
["1.1.3 Total Pricing."]
[]
["2.  INSTRUCTIONS FOR COMPLETION OF EXCEL SPREADSHEETS"]
["2.1 Complete Bidders Name - Highlighted in green"]
["2.2 Frances Baard District - Column C, Category: Base price (highlighted in green) per security guard per month will be used as input cells.  The bidder will insert his/her price per month (all inclusive)"]
["2.3 Other Districts - Column C, Category: Base price  (highlighted in green) per security guard per month will be used as input cells.  The bidder will insert his/her price per month (all inclusive)"]
["2.4 Total Pricing - Column E9, Include the price (highlighted in green) for public liability insurance for a period of three (3) years.  The sheet with automatically calculate all the pricing (E3, E4, E5, E6 and E12)"]

{"sheet":"Frances Baard District","index":1,"n_rows":64,"n_cols":6,"rows_kept":64,"merged":[[0,0,0,5],[1,0,1,2],[1,3,1,5],[9,0,9,5],[10,0,10,2],[10,3,10,5],[17,0,17,2],[17,3,17,5],[24,0,24,2],[24,3,24,5],[29,0,29,2],[29,3,29,5],[36,0,36,2],[36,3,36,5],[42,0,42,2],[42,3,42,5],[47,0,47,2],[47,3,47,5],[52,0,52,2],[52,3,52,5],[57,0,57,2],[57,3,57,5]]}
["1. FRANCES BAARD DISTRICT - GRADE C/D/E"]
["1.1 MERVIN J ERLANK SPORT PRECINCT (HEAD OFFICE)",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","SHIFTS PER MONTH","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[4,1,null,{"v":0,"d":"R0.00"},{"$f":"(D4*5%)+D4","v":0},{"$f":"(E4*5%)+E4","v":0}]
[4,1,null,{"$f":"A5*B5*C5*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D5*5%)+D5","v":0},{"$f":"(E5*5%)+E5","v":0}]
[4,1,null,{"v":0,"d":"R0.00"},0,0]
[1,1,null,{"v":0,"d":"R0.00"},0,0]
[{"$f":"SUM(A4:A7)","v":13},null,null,{"$f":"SUM(D4:D7)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E4:E7)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F4:F7)","v":{"v":0,"d":"R0.00"}}]
[]
["1.2 MINISTRY"]
["OFFICE OF THE MEC",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","SHIFTS PER MONTH","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[2,1,null,{"v":0,"d":"R0.00"},{"$f":"(D13*5%)+D13","v":0},0]
[2,1,null,{"$f":"A14*B14*C14*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D14*5%)+D14","v":0},0]
[2,1,null,{"v":0,"d":"R0.00"},{"$f":"(D15*5%)+D15","v":0},0]
[{"$f":"SUM(A13:A15)","v":6},null,null,{"$f":"SUM(D13:D15)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E13:E15)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F13:F15)","v":{"v":0,"d":"R0.00"}}]
[]
["1.3 MAYIBUYE CENTRE",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","SHIFTS PER MONTH","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[3,1,null,{"v":0,"d":"R0.00"},{"$f":"(D20*5%)+D20","v":0},0]
[3,1,null,{"$f":"A21*B21*C21*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D21*5%)+D21","v":0},0]
[3,1,null,{"v":0,"d":"R0.00"},{"$f":"(D22*5%)+D22","v":0},0]
[{"$f":"SUM(A20:A22)","v":9},null,null,{"$f":"SUM(D20:D22)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E20:E22)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F20:F22)","v":{"v":0,"d":"R0.00"}}]
[]
["1.4 ARCHIVES REPOSITORY",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAILY (MONDAY - FRIDAY)","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D27*5%)+D27","v":0},0]
[{"$f":"SUM(A27:A27)","v":1},null,null,{"$f":"SUM(D27:D27)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E27:E27)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F27:F27)","v":{"v":0,"d":"R0.00"}}]
[]
["1.5 NC THEATRE",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","SHIFTS PER MONTH","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[2,1,null,{"v":0,"d":"R0.00"},{"$f":"(D32*5%)+D32","v":0},0]
[2,1,null,{"$f":"A33*B33*C33*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D33*5%)+D33","v":0},0]
[2,1,null,{"v":0,"d":"R0.00"},{"$f":"(D34*5%)+D34","v":0},0]
[{"$f":"SUM(A32:A34)","v":6},null,null,{"$f":"SUM(D32:D34)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E32:E34)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F32:F34)","v":{"v":0,"d":"R0.00"}}]
[]
["1.6 AR ABASS STADIUM",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","SHIFTS PER MONTH","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[2,1,null,{"v":0,"d":"R0.00"},{"$f":"(D39*5%)+D39","v":0},0]
[2,1,null,{"$f":"A40*B40*C40*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D40*5%)+D40","v":0},0]
[{"$f":"SUM(A39:A40)","v":4},null,null,{"$f":"SUM(D39:D40)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E39:E40)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F39:F40)","v":{"v":0,"d":"R0.00"}}]
[]
["1.7 BARKLEY WEST LIBRARY",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAILY (MONDAY - FRIDAY)","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D45*5%)+D45","v":0},0]
[{"$f":"SUM(A45:A45)","v":1},null,null,{"$f":"SUM(D45:D45)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E45:E45)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F45:F45)","v":{"v":0,"d":"R0.00"}}]
[]
["1.8 RITCHIE LIBRARY",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAILY (MONDAY - FRIDAY)","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D50*5%)+D50","v":0},0]
[{"$f":"SUM(A50:A50)","v":1},null,null,{"$f":"SUM(D50:D50)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E50:E50)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F50:F50)","v":{"v":0,"d":"R0.00"}}]
[]
["1.9 ROBERT SOBUKWE PRECINCT ",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAILY (MONDAY - FRIDAY)","BASEPRICE PER SECURITY GUARDS","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D55*5%)+D55","v":0},0]
[{"$f":"SUM(A55:A55)","v":1},null,null,{"$f":"SUM(D55:D55)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E55:E55)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F55:F55)","v":{"v":0,"d":"R0.00"}}]
[]
["1.10 GREENPOINT LIBRARY",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAILY (MONDAY - FRIDAY)","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D60*5%)+D60","v":0},{"$f":"(E60*5%)+E60","v":0}]
[{"$f":"SUM(A60:A60)","v":1},null,null,{"$f":"SUM(D60:D60)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E60:E60)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F60:F60)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[{"$f":"A8+A16+A23+A28+A35+A41+A46+A51+A56+A61","v":43},"Total Security Officers"]

{"sheet":"Other Districts","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[0,0,0,5],[1,0,1,2],[1,3,1,5],[6,0,6,5],[7,0,7,2],[7,3,7,5],[12,0,12,2],[12,3,12,5],[19,0,19,2],[19,3,19,5],[26,0,26,2],[26,3,26,5]]}
["2. PIXLEY KA SEME DISTRICT - GRADE C/D/E"]
["2.1 PIXLEY KA SEME DISTRICT OFFICE",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAILY (MONDAY - FRIDAY)","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D4*5%)+D4","v":0},{"$f":"(E4*5%)+E4","v":0}]
[{"$f":"SUM(A4:A4)","v":1},null,null,{"$f":"SUM(D4:D4)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E4:E4)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F4:F4)","v":{"v":0,"d":"R0.00"}}]
[]
["3. ZFM DISTRICT - GRADE C/D/E"]
["3.1 SANDILE PRESENT (ZFM DISTRICT OFFICE UPINGTON )",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAILY (MONDAY - FRIDAY)","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D10*5%)+D10","v":0},{"$f":"(E10*5%)+E10","v":0}]
[{"$f":"SUM(A10:A10)","v":1},null,null,{"$f":"SUM(D10:D10)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E10:E10)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F10:F10)","v":{"v":0,"d":"R0.00"}}]
[]
["3.2 STERNHAM LIBRARY GROBLERSHOOP - GRADE C/D/E",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAY & NIGHT","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D15*5%)+D15","v":0},{"$f":"(E15*5%)+E15","v":0}]
[1,1,null,{"$f":"A16*B16*C16*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D16*5%)+D16","v":0},{"$f":"(E16*5%)+E16","v":0}]
[1,1,null,{"$f":"A17*B17*C17*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D17*5%)+D17","v":0},{"$f":"(E17*5%)+E17","v":0}]
[{"$f":"SUM(A15:A17)","v":3},null,null,{"$f":"SUM(D15:D17)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E15:E17)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F15:F17)","v":{"v":0,"d":"R0.00"}}]
[]
["4. NAMAKWA DISTRICT OFFICE (BESGSIG) - GRADE C/D/E",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAY SHIFT ONLY","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D22*5%)+D22","v":0},{"$f":"(E22*5%)+E22","v":0}]
[1,1,null,{"$f":"A23*B23*C23*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D23*5%)+D23","v":0},{"$f":"(E23*5%)+E23","v":0}]
[1,1,null,{"v":0,"d":"R0.00"},0,0]
[{"$f":"SUM(A22:A24)","v":3},null,null,{"$f":"SUM(D22:D24)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E22:E24)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F22:F24)","v":{"v":0,"d":"R0.00"}}]
[]
["5.1 JTG DISTRICT OFFICE (MS KITCHEN) - GRADE C/D/E",null,null,"TOTAL"]
["NO. OF SECURITY GUARDS","DAY & NIGHT","BASEPRICE PER SECURITY GUARDS P/M","YEAR 1","YEAR 2","YEAR 3"]
[1,1,null,{"v":0,"d":"R0.00"},{"$f":"(D29*5%)+D29","v":0},{"$f":"(E29*5%)+E29","v":0}]
[1,1,null,{"$f":"A30*B30*C30*12","v":{"v":0,"d":"R0.00"}},{"$f":"(D30*5%)+D30","v":0},{"$f":"(E30*5%)+E30","v":0}]
[1,1,null,{"v":0,"d":"R0.00"},0,0]
[{"$f":"SUM(A28:A31)","v":3},null,null,{"$f":"SUM(D29:D31)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E29:E31)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F29:F31)","v":{"v":0,"d":"R0.00"}}]
[]
[{"$f":"'Frances Baard District'!A64","v":43},"Total Security Officers - Frances Baard District"]
[{"$f":"A5+A11+A18+A25+A32","v":11},"Total Security Officers - Other Districts"]
[{"$f":"SUM(A34:A35)","v":54},"Overall Total"]

{"sheet":"Total Pricing","index":3,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[0,0,0,4],[11,0,11,2],[11,3,11,4],[18,3,18,4]]}
["PHYSICAL SECURITY SERVICES - PRICING STRUCTURE FOR THE THREE (3) YEARS"]
[]
["YEAR 1 TOTAL",{"$nulls":3},{"$f":"'Frances Baard District'!D8+'Frances Baard District'!D16+'Frances Baard District'!D23+'Frances Baard District'!D28+'Frances Baard District'!D35+'Frances Baard District'!D41+'Frances Baard District'!D46+'Frances Baard District'!D51+'Frances Baard District'!D56+'Frances Baard District'!D61+'Other Districts'!D5+'Other Districts'!D11+'Other Districts'!D18+'Other Districts'!D25+'Other Districts'!D32","v":{"v":0,"d":"R0.00"}}]
["YEAR 2 TOTAL",{"$nulls":3},{"$f":"'Frances Baard District'!E8+'Frances Baard District'!E16+'Frances Baard District'!E23+'Frances Baard District'!E28+'Frances Baard District'!E35+'Frances Baard District'!E41+'Frances Baard District'!E46+'Frances Baard District'!E51+'Frances Baard District'!E56+'Frances Baard District'!E61+'Other Districts'!E5+'Other Districts'!E11+'Other Districts'!E18+'Other Districts'!E25+'Other Districts'!E32","v":{"v":0,"d":"R0.00"}}]
["YEAR 3 TOTAL",{"$nulls":3},{"$f":"'Frances Baard District'!F8+'Frances Baard District'!F16+'Frances Baard District'!F23+'Frances Baard District'!F28+'Frances Baard District'!F35+'Frances Baard District'!F41+'Frances Baard District'!F46+'Frances Baard District'!F51+'Frances Baard District'!F56+'Frances Baard District'!F61+'Other Districts'!F5+'Other Districts'!F11+'Other Districts'!F18+'Other Districts'!F25+'Other Districts'!F32","v":{"v":0,"d":"R0.00"}}]
["TOTAL COSTS FOR THREE (3) YEARS",{"$nulls":3},{"$f":"SUM(E3:E5)","v":{"v":0,"d":"R0.00"}}]
[]
[]
["PUBLIC LIABILITY INSURANCE FOR THREE (3) YEARS",{"$nulls":3},{"v":0,"d":"R0.00"}]
[]
[]
["PRICE THAT WILL BE USED FOR EVALUATION PURPOSES",null,null,{"$f":"E6+E9","v":0}]
[]
[]
[]
["I, the undersigned (Full name and surname) "]
[]
[]
["…………………………………………………………………………………………………………………………………..."]
[]
["Certify that the information as provided in the table above is true and correct "]
["(to be recalculated by the Bidder), and understood the above document in full."]
[]
[]
[]
[]
[]
["………………………………………..",null,null,"………………………….."]
["Signature",null,null,"Date"]