{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ANNEXURE F - WATERBERG"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"ANNEXURE F - WATERBERG","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[7,0,9,8],[10,0,11,0],[10,1,10,6],[10,7,10,8],[16,0,16,7],[17,0,17,7],[18,0,18,7],[19,0,19,7],[21,0,21,8],[22,0,22,4],[22,5,22,8],[24,0,24,1],[24,4,24,7],[28,0,28,1],[28,4,28,7]]}
{"$rows_empty":7}
["ANNEXURE F: PRICING SCHEDULE FOR WATERBERG DISTRICT"]
[]
[]
[null,"Monthly Cost per Guard (please capture monthly rates only)",{"$nulls":5},"Cost per Year (please note that calculations will be performed automatically)"]
[null,"Salary per Guard","Overheads per Guard","Profit per Guard","Total Cost per Guard","Number of Guards","Total Cost for Guards","Total Cost per Guard","Total Cost for Guards"]
["Armed Guards (Day Shift)",{"$nulls":3},{"$f":"B13+C13+D13","v":{"v":0,"d":"R0.00"}},18,{"$f":"E13*F13","v":{"v":0,"d":"R0.00"}},{"$f":"E13*12","v":{"v":0,"d":"R0.00"}},{"$f":"G13*12","v":{"v":0,"d":"R0.00"}}]
["Unarmed Guards (Day Shift)",{"$nulls":3},{"$f":"B14+C14+D14","v":{"v":0,"d":"R0.00"}},11,{"$f":"E14*F14","v":{"v":0,"d":"R0.00"}},{"$f":"E14*12","v":{"v":0,"d":"R0.00"}},{"$f":"G14*12","v":{"v":0,"d":"R0.00"}}]
["Armed Guards (Night Shift)",{"$nulls":3},{"$f":"B15+C15+D15","v":{"v":0,"d":"R0.00"}},17,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Unarmed Guards (Night Shift)",{"$nulls":3},{"$f":"B16+C16+D16","v":{"v":0,"d":"R0.00"}},9,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Total Cost per Month (excl vat)",{"$nulls":7},{"$f":"SUM(G13:G16)","v":{"v":0,"d":"R0.00"}}]
["VAT",{"$nulls":7},{"$f":"I17*0.015","v":{"v":0,"d":"R0.00"}}]
["Total Cost per Month (incl vat)",{"$nulls":7},{"$f":"SUM(I17:I18)","v":{"v":0,"d":"R0.00"}}]
["Total Bidding Price for Year 1 (incl vat)",{"$nulls":7},{"$f":"I19*12","v":{"v":0,"d":"R0.00"}}]
[]
["NB:  The automatic calculations are as follows:"]
["1. Total Cost per Guard per Month = Salary per Guard + Overhead per Guard + Profit per Guard\n2. Total Cost of Guards per Month = Total Cost per Guard per Month × Number of Guards\n \n\n",{"$nulls":4},"3. Total Cost per Guard per Year = Total Cost per Guard per Month × 12 Months \n4. Total Cost of Guards per Year =  Total Cost per Guard per Year × Number of Guards"]
[]
["Signature",{"$nulls":3},"Date"]
[]
[]
[]
["Name of Bidder",{"$nulls":3},"Position"]