{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Rate calculation","Qoutation","Contract Value"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Rate calculation","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"merged":[[5,2,5,4],[19,2,19,4]]}
[]
[]
[]
[]
[]
["MSUNDUZI",null,"UNIT RATE"]
["Cost element","% contribution to rate","Year 1","Year 2"]
["Baic Wage & statutory costs",54.1]
["Lost time recovery",{"v":5,"d":"5.0"}]
["Operational components"]
["Transport",8.1]
["Medicals",1.8]
["Tools",{"v":8,"d":"8.0"}]
["PPE",{"v":5,"d":"5.0"}]
["Training",{"v":3,"d":"3.0"}]
["Admin and overhead",{"v":5,"d":"5.0"}]
["Mark-up",{"v":10,"d":"10.0"}]
[]
["Cost per Manday (Rands)",{"$f":"SUM(B8:B17)","v":{"v":100,"d":"100.0"}},{"$f":"SUM(C8:C18)","v":0},{"$f":"SUM(D8:D18)","v":0}]

{"sheet":"Qoutation","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[0,0,0,4],[2,1,2,3],[4,1,4,2],[5,3,15,3],[5,4,15,4],[6,1,6,2],[16,3,16,4],[17,3,17,4],[17,5,17,6],[18,5,18,7]]}
["SILVICULTURE PRICING SCHEDULE"]
[]
["Bidders Name"]
[]
["Plantation Name",{"$f":"'Rate calculation'!A6","v":"MSUNDUZI"},null,"Rate Yr1","Rate Yr2","Total Yr1","Total Yr2","TOTAL"]
[null,"Year 1","year 2",{"$f":"'Rate calculation'!C19","v":{"v":0,"d":"R0.00"}},{"$f":"'Rate calculation'!D19","v":{"v":0,"d":"R0.00"}}]
["Activities","Man-days"]
["Establishment",5250,4325,null,null,{"$f":"B8*$D$6","v":{"v":0,"d":"R0.00"}},{"$f":"C8*$E$6","v":{"v":0,"d":"R0.00"}},{"$f":"F8+G8","v":{"v":0,"d":"R0.00"}}]
["Weeding",2220,2320,null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"F9+G9","v":{"v":0,"d":"R0.00"}}]
["Tending",3501,3470,null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Conservation and Protection",2025,2025,null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Pruning",3050,3200,null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Pruning",null,500,null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Supply of labour (PTM, EHM)",500,500,null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
["Road clearing and maintenance, Village maintenance, etc.",1500,1500,null,null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":5},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Totals",null,{"$f":"SUM(F8:F16)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G8:G16)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Grand Total",null,{"$f":"SUM(F17:G17)","v":{"v":0,"d":"R0.00"}}]
[]
["Other Ad hoc work","Year 1","year 2","Rate Yr1","Rate Yr2","Total Yr1","Total Yr2","TOTAL"]
["Chainsaw wet rate",400,400,null,null,{"$f":"B21*D21","v":{"v":0,"d":"R0.00"}},{"$f":"C21*E21","v":{"v":0,"d":"R0.00"}},{"$f":"F21+G21","v":{"v":0,"d":"R0.00"}}]
["Driver operator",200,200,null,null,{"$f":"B22*D22","v":{"v":0,"d":"R0.00"}},{"$f":"C22*E22","v":{"v":0,"d":"R0.00"}},{"$f":"F22+G22","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":5},{"$f":"SUM(F21:F22)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G21:G22)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]

{"sheet":"Contract Value","index":2,"n_rows":30,"n_cols":4,"rows_kept":30,"merged":[[5,2,5,6],[7,2,7,6],[11,3,11,7],[12,3,12,7],[14,3,14,7],[15,3,15,7],[17,3,17,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7]]}
[]
[]
[]
[]
[]
["BIDDER'S NAME"]
[]
["PLANTATION",null,{"$f":"Qoutation!$B$5","v":"MSUNDUZI"}]
[]
[]
[]
[null,"CORE SILVICULTURE",null,{"$f":"Qoutation!F18","v":{"v":0,"d":"R0.00"}}]
[null,"AD HOC ACTIVITIES",null,{"$f":"SUM(Qoutation!F23:H23)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"TOTAL",{"$f":"D12+D13","v":{"v":0,"d":"R0.00"}}]
[null,null,"VAT @15%",{"$f":"D15*0.15","v":{"v":0,"d":"R0.00"}}]
[]
[null,"GRAND TOTAL",null,{"$f":"D15+D16","v":{"v":0,"d":"R0.00"}}]
[]
[null,"TOTAL IN WORDS"]
{"$rows_empty":8}
["1.     Failure to fully complete the document (Annexure A) will be a disqualification"]
["2.     Bidders to provide SAFCOL with market related rates as bidders who quotes within a certain market range will be appointed"]