{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Grand Total Bid Price ","Stacking Summary","Destacking Summary","Rework Summary ","Data Input Stacking","Data input Destacking","Data input Rework"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"Grand Total Bid Price ","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"merged":[[1,1,1,5],[9,4,9,5],[14,1,14,5],[21,4,21,5],[27,1,27,5]]}
[]
[null,"Drymill Service Summary ",{"$nulls":6},"Increase ",{"v":0,"d":"0.0%"}]
[null,"Elements","Year 1 ","Monthly","Monthly after annual increase","Total for 18 Months"]
[null,"Destacking",{"$f":"'Destacking Summary'!L36","v":0},{"$f":"C4/12","v":0},{"$f":"(D4*$J$2)+D4","v":0},{"$f":"E4*18","v":0}]
[null,"Rework ",{"$f":"'Rework Summary '!Q15","v":0},{"$f":"C5/12","v":0},{"$f":"(D5*$J$2)+D5","v":0},{"$f":"E5*18","v":0}]
[null,"Overtime ",{"$f":"'Rework Summary '!X14","v":0},{"$f":"C6/12","v":0},{"$f":"(D6*$J$2)+D6","v":0},{"$f":"E6*18","v":0}]
[null,"Total Bid price",{"$f":"SUM(C4:C6)","v":0},{"$f":"SUM(D4:D6)","v":0},{"$f":"SUM(E4:E6)","v":0},{"$f":"SUM(F4:F6)","v":0}]
[]
[]
[{"$nulls":4},"Ave cost per head monhtly - OT excl"]
[{"$nulls":4},"Total head count",{"$f":"'Data input Destacking'!C16+'Data input Rework'!C13","v":166}]
[{"$nulls":4},"Monthly",{"$f":"((F4+F5)/F11)/18","v":0}]
[{"$nulls":4},"Daily",{"$f":"F12/'Data input Destacking'!N3","v":0}]
[]
[null,"Stacking Service Summary "]
[null,"Elements","Year 1","Monthly","Monthly after annual increase","Total for 18 Months"]
[null,"Stacking",{"$f":"'Stacking Summary'!R15","v":0},{"$f":"C17/12","v":0},{"$f":"(D17*$J$2)+D17","v":0},{"$f":"E17*18","v":0}]
[null,"Overtime ",{"$f":"'Stacking Summary'!Y14","v":0},{"$f":"C18/12","v":0},{"$f":"(D18*$J$2)+D18","v":0},{"$f":"E18*18","v":0}]
[null,"Total Bid price",{"$f":"SUM(C17:C18)","v":0},{"$f":"SUM(D17:D18)","v":0},{"$f":"SUM(E17:E18)","v":0},{"$f":"SUM(F17:F18)","v":0}]
[]
[]
[{"$nulls":4},"Ave cost per head monhtly - OT excl"]
[{"$nulls":4},"Total head count",{"$f":"'Data Input Stacking'!H14","v":77}]
[{"$nulls":4},"Monthly",{"$f":"(F17/F23)/18","v":0}]
[{"$nulls":4},"Daily",{"$f":"F24/'Data Input Stacking'!P3","v":0}]
[]
[]
[null,"Grand Total - Timbadola Contract Services"]
[null,null,"Year 1","Monthly","Monthly after annual increase","Total for 18 Months"]
[null,"Total Bid price",{"$f":"C7+C19","v":0},{"$f":"D7+D19","v":0},{"$f":"E7+E19","v":0},{"$f":"F7+F19","v":0},"Total bid price (vat Excl.)"]
[]
[]
[]
[{"$nulls":4},"Total Price (Vat Incl.)",{"$f":"(F30*15%)+F30","v":0}]

{"sheet":"Stacking Summary","index":1,"n_rows":18,"n_cols":25,"rows_kept":18,"merged":[[0,21,0,24]]}
[{"$nulls":21},"Overtime rates and Projection"]
["Position","Shift 1","Shift 2","Shift 3","Shift 4","Grades","Total","Base Rate","Daily Leave Cost","Medicals Survey and First aid boxes","PPE and Safety ","Consumables ","Transport","Training","Night Shift Allowance (12% of base rate)","Total Cost","Management Fee","Grand Total","Daily Rates",null,null,"Normal","Sun / Public","OT Projection (Ave hours monthly)","Total"]
["Stackers",25,25,null,null,"A1",{"$f":"SUM(B3:E3)","v":50},{"$f":"'Data Input Stacking'!I4","v":0},{"$f":"'Data Input Stacking'!$J$18","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},{"$f":"(H3*12%)/2","v":0},{"$f":"SUM(H3:O3)*G3","v":0},null,{"$f":"(Q3*P3)+P3","v":0},{"$f":"R3/G3","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"(H3/9)*1.5","v":0},{"$f":"(H3/9)*2","v":0},32,{"$f":"X3*V3*G3","v":{"v":0,"d":"R0.00"}}]
["Sticker Handler",1,1,null,null,"A1",{"$f":"SUM(B4:E4)","v":2},{"$f":"'Data Input Stacking'!I5","v":0},{"$f":"'Data Input Stacking'!$J$18","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},{"$f":"(H4*12%)/2","v":0},{"$f":"SUM(H4:O4)*G4","v":0},null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Cleaner",1,1,null,null,"A1",2,{"$f":"'Data Input Stacking'!I6","v":0},{"$f":"'Data Input Stacking'!$J$18","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},0,0,null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Waste Recovery",2,2,null,null,"A1",4,{"$f":"'Data Input Stacking'!I7","v":0},{"$f":"'Data Input Stacking'!$J$18","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},0,0,null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Board Separator",4,4,null,null,"A3",8,{"$f":"'Data Input Stacking'!I8","v":0},{"$f":"'Data Input Stacking'!J19","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},0,0,null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Stack Chockers",1,1,null,null,"A1",2,{"$f":"'Data Input Stacking'!I9","v":0},{"$f":"'Data Input Stacking'!$J$18","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},0,0,null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Chipper & Screen",1,{"$nulls":3},"A1",1,{"$f":"'Data Input Stacking'!I10","v":0},{"$f":"'Data Input Stacking'!$J$18","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},0,0,null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Boiler Feeder",1,1,1,1,"A1",4,{"$f":"'Data Input Stacking'!I11","v":0},{"$f":"'Data Input Stacking'!$J$18","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},0,0,null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Lubricators",1,1,null,null,"A1",2,{"$f":"'Data Input Stacking'!I12","v":0},{"$f":"'Data Input Stacking'!$J$18","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},0,0,null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Supervisor",1,1,null,null,"B1",2,{"$f":"'Data Input Stacking'!I13","v":0},{"$f":"'Data Input Stacking'!J20","v":0},{"$f":"'Data Input Stacking'!$F$66+'Data Input Stacking'!$E$90","v":0},{"$f":"'Data Input Stacking'!$F$35+'Data Input Stacking'!$F$42","v":0},{"$f":"'Data Input Stacking'!$F$60","v":0},{"$f":"'Data Input Stacking'!$L$74","v":0},{"$f":"'Data Input Stacking'!$E$83","v":0},0,0,null,0,{"v":0,"d":"R0.00"},null,null,0,0,32,{"v":0,"d":"R0.00"}]
["Total",{"$f":"SUM(B3:B12)","v":38},{"$f":"SUM(C3:C12)","v":37},{"$f":"SUM(D3:D12)","v":1},{"$f":"SUM(E3:E12)","v":1},null,{"$f":"SUM(G3:G12)","v":77},{"$nulls":9},"Total Daily",{"$f":"SUM(R3:R12)","v":0},{"$nulls":5},"Ave OT monthly",{"$f":"SUM(Y3:Y12)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"Total Monthly",{"$f":"R13*'[1]Data input & costing'!P3","v":0},{"$nulls":5},"Ave Yearly OT",{"$f":"Y13*12","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":16},"Total Yearly",{"$f":"R13*'[1]Data input & costing'!P2","v":0}]
[]
[]
[{"$nulls":16},"ave cost per head",{"$f":"R13/G13","v":0}]

{"sheet":"Destacking Summary","index":2,"n_rows":38,"n_cols":17,"rows_kept":38,"merged":[[0,3,0,16],[1,2,1,4],[1,6,1,12],[15,6,15,8],[17,2,17,12]]}
[{"$nulls":3},"Destacking Costing"]
[null,null,"No#",{"$nulls":3},"Daily cost per worker "]
[null,"Resources","Shift 1","Shift 2","Total","Grades","Base Rate","Daily Leave Cost","Medicals Survey and First aid boxes","PPE and Safety ","Consumables ","Transport","Training","Night Shift Allowance (12% of base rate)","Total Cost","Management Fee (%)","Grand Total"]
[1,"Destackers",4,4,{"$f":"SUM(C4:D4)","v":8},"A3",{"$f":"'Data input Destacking'!E5","v":0},{"$f":"'Data input Destacking'!J5","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},{"$f":"(G4*12%)/2","v":0},{"$f":"SUM(G4:N4)*E4","v":0},null,{"$f":"(P4*O4)+O4","v":0}]
[2,"Trimsaw operators",4,4,{"$f":"SUM(C5:D5)","v":8},"B1",{"$f":"'Data input Destacking'!E6","v":0},{"$f":"'Data input Destacking'!J6","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},{"$f":"(G5*12%)/2","v":0},{"$f":"SUM(G5:N5)*E5","v":0},null,{"$f":"(P5*O5)+O5","v":0}]
[3,"X-cut operator",1,1,2,"B1",{"$f":"'Data input Destacking'!E7","v":0},{"$f":"'Data input Destacking'!J7","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[4,"General workers",2,2,4,"A1",{"$f":"'Data input Destacking'!E8","v":0},{"$f":"'Data input Destacking'!J8","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[5,"Ticket Writers",1,1,2,"A3",{"$f":"'Data input Destacking'!E9","v":0},{"$f":"'Data input Destacking'!J9","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[6,"Strapper",1,1,2,"A1",{"$f":"'Data input Destacking'!E10","v":0},{"$f":"'Data input Destacking'!J10","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[7,"Grader",2,2,4,"B1",{"$f":"'Data input Destacking'!E11","v":0},{"$f":"'Data input Destacking'!J11","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[8,"Stackers",9,9,18,"A1",{"$f":"'Data input Destacking'!E12","v":0},{"$f":"'Data input Destacking'!J12","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[9,"Sorters",4,4,8,"A1",{"$f":"'Data input Destacking'!E13","v":0},{"$f":"'Data input Destacking'!J13","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[10,"Supervisor ",1,1,2,"B4",{"$f":"'Data input Destacking'!E14","v":0},{"$f":"'Data input Destacking'!J14","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[11,"Foreman",1,null,1,"C1",{"$f":"'Data input Destacking'!E15","v":0},{"$f":"'Data input Destacking'!J15","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0]
[{"$nulls":4},{"$f":"SUM(E4:E14)","v":59},{"$nulls":9},{"$f":"SUM(O4:O14)","v":0},"Daily Cost",{"$f":"SUM(Q4:Q14)","v":0}]
[{"$nulls":6},"Note: Only put inputs of the yellow Columns "]
[]
[null,null,"Destacking Model - Tariffs"]
[null,null,"Dimension","Mix",null,"Potential number of stack daily\n= (Given)","Profitable stacks target \n= (Given 12 stacks)","Productivity\n= (Potential no of stacks / Profitable target stacks)","Deficit\n= (100% -productivity)","Base rate\n= (Total Destacking operational cost / Profitable stacks target)","Adjustor\n= (Deficit X Base Rate)","Rate per stack\n= (Base rate + adjustor)","Ave per stack"]
[null,null,"25/228",{"v":0.01,"d":"1%"},null,12,12,{"$f":"F20/G20","v":{"v":1,"d":"100%"}},{"$f":"100%-H20","v":{"v":0,"d":"0.00%"}},{"$f":"$Q$15/G$20","v":0},{"$f":"I20*J20","v":0},{"$f":"J20+K20","v":0},{"$f":"L20*D20","v":0}]
[null,null,"38/50",{"v":0.005,"d":"1%"},null,4,12,{"$f":"F21/G21","v":{"v":0.3333333333333333,"d":"33%"}},{"$f":"100%-H21","v":{"v":0.6666666666666667,"d":"66.67%"}},{"$f":"$Q$15/G$20","v":0},{"$f":"I21*J21","v":0},{"$f":"J21+K21","v":0},0]
[null,null,"38/76",{"v":0.07,"d":"7%"},null,6,12,{"v":0.5,"d":"50%"},{"v":0.5,"d":"50.00%"},0,0,0,0]
[null,null,"38/114",{"v":0.23,"d":"23%"},null,10,12,{"v":0.8333333333333334,"d":"83%"},{"v":0.16666666666666663,"d":"16.67%"},0,0,0,0]
[null,null,"38/152",{"v":0.26,"d":"26%"},null,12,12,{"v":1,"d":"100%"},{"v":0,"d":"0.00%"},0,0,0,0]
[null,null,"38/200",{"v":0.08,"d":"8%"},null,12,12,{"v":1,"d":"100%"},{"v":0,"d":"0.00%"},0,0,0,0]
[null,null,"38/228",{"v":0.1,"d":"10%"},null,13,12,{"v":1.0833333333333333,"d":"108%"},{"v":-0.08333333333333326,"d":"-8.33%"},0,0,0,0]
[null,null,"50/152",{"v":0.09,"d":"9%"},null,13,12,{"v":1.0833333333333333,"d":"108%"},{"v":-0.08333333333333326,"d":"-8.33%"},0,0,0,0]
[null,null,"50/228",{"v":0.08,"d":"8%"},null,13,12,{"v":1.0833333333333333,"d":"108%"},{"v":-0.08333333333333326,"d":"-8.33%"},0,0,0,0]
[null,null,"76/152",{"v":0.045,"d":"5%"},null,13,12,{"v":1.0833333333333333,"d":"108%"},{"v":-0.08333333333333326,"d":"-8.33%"},0,0,0,0]
[null,null,"76/228",{"v":0.03,"d":"3%"},null,13,12,{"v":1.0833333333333333,"d":"108%"},{"v":-0.08333333333333326,"d":"-8.33%"},0,0,0,0]
[{"$nulls":3},{"$f":"SUM(D20:D30)","v":{"v":0.9999999999999999,"d":"100%"}},{"$nulls":7},"Ave daily rate",{"$f":"SUM(M20:M30)","v":0}]
[{"$nulls":10},"Ideal Production",12]
[{"$nulls":10},"Daily cost",{"$f":"Q15","v":0}]
[{"$nulls":10},"Stacks income daily",{"$f":"M31*L32","v":0}]
[{"$nulls":10},"Monthly Cost",{"$f":"L34*'Data input Destacking'!N3","v":0}]
[{"$nulls":10},"Yearly  Cost",{"$f":"L33*'Data input Destacking'!N2","v":0}]
[]
[{"$nulls":10},"Ave cost per person",{"$f":"L33/E15","v":0}]

{"sheet":"Rework Summary ","index":3,"n_rows":17,"n_cols":24,"rows_kept":17,"merged":[[0,3,0,16],[2,1,2,17],[2,20,2,23],[13,6,13,8]]}
[{"$nulls":3},"Destacking Costing"]
[]
[null,"Drymill Rework Tariffs",{"$nulls":18},"Overtime rates"]
[null,"Resources","Shift 1","Shift 2","Total","Grades","Base Rate","Daily Leave Cost","Medicals Survey and First aid boxes","PPE and Safety ","Consumables ","Transport","Training","Night Shift Allowance (12% of base rate)","Total Cost","Management Fee (%)","Grand Total","Daily Rate",null,null,"Normal","Sunday","Overtime projection monthly (hours)","Total Cost"]
[1,"General Workers",25,28,{"$f":"SUM(C5:D5)","v":53},"A1",{"$f":"'Data input Rework'!E5","v":0},{"$f":"'Data input Rework'!J5","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},{"$f":"(G5*12%)/2","v":0},{"$f":"SUM(G5:N5)*E5","v":0},null,{"$f":"(P5*O5)+O5","v":0},{"$f":"Q5/E5","v":0},null,{"$f":"R5-S5","v":0},{"$f":"(G5/9)*1.5","v":0},{"$f":"(G5/9)*2","v":0},30,{"$f":"U5*W5*E5","v":0}]
[2,"General Workers",6,null,{"$f":"SUM(C6:D6)","v":6},"A1",{"$f":"'Data input Rework'!E6","v":0},{"$f":"'Data input Rework'!J6","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,{"$f":"SUM(G6:N6)*E6","v":0},null,{"$f":"(P6*O6)+O6","v":0},{"$f":"Q6/E6","v":0},null,null,{"$f":"(G6/9)*1.5","v":0},0,30,0]
[3,"General Workers",9,null,9,"A1",{"$f":"'Data input Rework'!E7","v":0},{"$f":"'Data input Rework'!J7","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0,0,null,null,0,0,30,0]
[4,"Operator",3,null,3,"B1",{"$f":"'Data input Rework'!E8","v":0},{"$f":"'Data input Rework'!J8","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0,0,null,null,0,0,30,0]
[5,"General Workers",6,null,6,"A1",{"$f":"'Data input Rework'!E9","v":0},{"$f":"'Data input Rework'!J9","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0,0,null,null,0,0,30,0]
[6,"Operator",2,1,3,"B1",{"$f":"'Data input Rework'!E10","v":0},{"$f":"'Data input Rework'!J10","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0,0,null,null,0,0,30,0]
[7,"General Workers",19,4,23,"A1",{"$f":"'Data input Rework'!E11","v":0},{"$f":"'Data input Rework'!J11","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},{"$f":"(G11*12%)/2","v":0},0,null,0,0,null,null,0,0,30,0]
[8,"Loaders",2,2,4,"A1",{"$f":"'Data input Rework'!E12","v":0},{"$f":"'Data input Rework'!J12","v":0},{"$f":"'Data input Destacking'!$F$55+'Data input Destacking'!$E$78","v":0},{"$f":"'Data input Destacking'!$F$28+'Data input Destacking'!$F$39","v":0},{"$f":"'Data input Destacking'!$F$49","v":0},{"$f":"'Data input Destacking'!$L$63","v":0},{"$f":"'Data input Destacking'!$E$71","v":0},0,0,null,0,0,null,null,0,0,30,0]
[null,null,{"$f":"SUM(C5:C12)","v":72},35,{"$f":"SUM(E5:E12)","v":107},{"$nulls":10},"Daily Cost",{"$f":"SUM(Q5:Q12)","v":0},{"$nulls":5},"Monthly cost",{"$f":"SUM(X5:X12)","v":0}]
[{"$nulls":15},"Monhtly cost",{"$f":"Q15/'Data input Rework'!N3","v":0},{"$nulls":5},"Yearly cost",{"$f":"X13*12","v":0}]
[{"$nulls":15},"Yearly Cost",{"$f":"Q13*'Data input Rework'!N2","v":0},{"$nulls":5},"18 Months ",{"$f":"X13*18","v":0}]
[]
[{"$nulls":15},"Ave cost person",{"$f":"Q13/E13","v":0}]

{"sheet":"Data Input Stacking","index":4,"n_rows":90,"n_cols":16,"rows_kept":90,"merged":[[1,11,1,12],[2,0,13,0],[15,5,15,6],[16,0,23,0],[26,0,31,0],[36,0,50,0],[53,0,59,0],[62,0,65,0],[68,0,74,0],[77,0,82,0],[85,0,89,0]]}
[]
[{"$nulls":11},"Overtime Rates",null,null,"Prod Days",236]
["People","Position","Shift 1","Shift 2","Shift 3","Shift 4","Grades","Total","Base Daily Rate","Total",null,"Normal","Sun / public ",null,"Ave Days monhtly ",{"$f":"P2/12","v":{"v":19.666666666666668,"d":"19.7"}}]
[null,"Stackers",25,25,null,null,"A1",{"$f":"SUM(C4:F4)","v":50},null,{"$f":"I4*H4","v":{"v":0,"d":"R0.00"}},null,{"$f":"(I4/9)*1.5","v":{"v":0,"d":"R0.00"}},{"$f":"(I4/9)*2","v":{"v":0,"d":"R0.00"}}]
[null,"Sticker Handler",1,1,null,null,"A1",{"$f":"SUM(C5:F5)","v":2},null,{"$f":"I5*H5","v":{"v":0,"d":"R0.00"}},null,{"$f":"(I5/9)*1.5","v":{"v":0,"d":"R0.00"}},{"$f":"(I5/9)*2","v":{"v":0,"d":"R0.00"}}]
[null,"Cleaner",1,1,null,null,"A1",2,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Waste Recovery",2,2,null,null,"A1",4,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Board Separator",4,4,null,null,"A3",8,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Stack Chockers",1,1,null,null,"A1",2,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Chipper & Screen",1,{"$nulls":3},"A1",1,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Boiler Feeder",1,1,1,1,"A1",4,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Lubricators",1,1,null,null,"A1",2,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Supervisor",1,1,null,null,"B1",2,null,{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Total",{"$f":"SUM(C4:C13)","v":38},{"$f":"SUM(D4:D13)","v":37},{"$f":"SUM(E4:E13)","v":1},{"$f":"SUM(F4:F13)","v":1},"Grand Total",{"$f":"SUM(H4:H13)","v":77},null,{"$f":"SUM(J4:J13)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":8},"Ave Daily Cost per head",{"$f":"J14/H14","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":5},"Type of Leave (Yearly)"]
["Leave ","Poistions","Grade","# No","Base Rate","Annual (days)\n1.2 Accum monthly","Sick Leave (days)\n30  in 3 year cycle","Holidays Portionsing","Total Days Yearly","Daily Leave cost","Total Cost Yearly"]
[null,"General Labour ","A1",{"$f":"SUM(H4,H5,H6,H7,H9,H10,H11,H12)","v":67},{"$f":"I4","v":{"v":0,"d":"R0.00"}},{"$f":"1.2*12","v":14.399999999999999},{"$f":"30/3","v":10},10,{"$f":"SUM(F18:G18)+H18","v":34.4},{"$f":"(E18*I18)/$P$2","v":{"v":0,"d":"0.00"}},{"$f":"I18*D18*E18","v":{"v":0,"d":"R0.00"}}]
[null,"Other","A3",{"$f":"SUM(H8)","v":8},{"$f":"I8","v":{"v":0,"d":"R0.00"}},{"$f":"1.2*12","v":14.399999999999999},{"$f":"30/3","v":10},10,{"$f":"SUM(F19:G19)+H19","v":34.4},{"$f":"(E19*I19)/$P$2","v":{"v":0,"d":"0.00"}},{"$f":"I19*D19*E19","v":{"v":0,"d":"R0.00"}}]
[null,"Supervisor","B1",{"$f":"SUM(H13)","v":2},{"$f":"I13","v":{"v":0,"d":"R0.00"}},{"$f":"1.2*12","v":14.399999999999999},{"$f":"30/3","v":10},10,{"$f":"SUM(F20:G20)+H20","v":34.4},{"v":0,"d":"0.00"},{"$f":"I20*D20*E20","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},{"$f":"SUM(D18:D20)","v":77}]
[{"$nulls":8},"Yearly Total",{"$f":"SUM(K18:K20)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":8},"Total Daily Cost",{"$f":"J22/P2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":8},"Daily Cost Per head",{"$f":"J23/H14","v":{"v":0,"d":"R0.00"}}]
[]
[]
["PPE","PPE (Essential)","QTY","Unit Price ","#No ","Total"]
[null,"Safety Boots",2,null,{"$f":"$H$14","v":77},{"$f":"D28*C28*E28","v":{"v":0,"d":"R0.00"}},{"$f":"F28/E28","v":{"v":0,"d":"R0.00"}}]
[null,"Overhauls",3,null,{"$f":"$H$14","v":77},{"$f":"D29*C29*E29","v":{"v":0,"d":"R0.00"}},{"$f":"F29/E29","v":{"v":0,"d":"R0.00"}}]
[null,"Helmet",1,null,77,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"T-shirts",2,null,77,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Winter Jacket (N/A)",1,null,77,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F28:F32)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G28:G31)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F33/P3","v":{"v":0,"d":"R0.00"}},{"$f":"G33*199","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"(F33/H14)/P2","v":{"v":0,"d":"R0.00"}}]
[]
["Consumable PPE","Specialised PPE (Sticker handers and cleaners only)","QTY","Unit Price ","#No ","Total"]
[null,"Rain coat ",1,null,4,{"$f":"D38*C38*E38","v":{"v":0,"d":"R0.00"}}]
[null,"Water Boots",1,null,4,{"$f":"D39*C39*E39","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F38:F39)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F40/P2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F41/H14","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Consumable PPE","QTY","Unit Price ","#No ","Total"]
[null,"Ear plugs (1 in 3 months)",4,null,{"$f":"$H$14","v":77},{"$f":"E46*D46*C46","v":{"v":0,"d":"R0.00"}}]
[null,"Gloves (1 pair monthly)",12,null,{"$f":"$H$14","v":77},{"$f":"E47*D47*C47","v":{"v":0,"d":"R0.00"}}]
[null,"Apron ( 1 in 3 months)",4,null,77,{"v":0,"d":"R0.00"}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F46:F48)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F49/P2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F50/H14","v":{"v":0,"d":"0.00"}}]
[]
[]
["General Consumables","Consumables","QTY","Unit Price ","#No ","Total"]
[null,"Soap (1 bar every month)",6,null,{"$f":"$H$14","v":77},{"$f":"C55*D55*E55","v":{"v":0,"d":"R0.00"}}]
[null,"Polish (2 every month)",8,null,{"$f":"$H$14","v":77},{"$f":"C56*D56*E56","v":{"v":0,"d":"R0.00"}}]
[null,"Toliet Paper ( 4 in 1 month)",{"$f":"4*12","v":48},null,77,{"v":0,"d":"R0.00"}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F55:F57)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F58/P2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F59/H14","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Medicals","Medicals","#No","Unit Price ","Frequency Yearly","Total"]
[null,null,{"$f":"H14","v":77},null,1,{"$f":"C64*D64*E64","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F64/P2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F65/H14","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Transport","Transport ","Destination","Split","# No","Distance (incl. return)","People per shift","Transport mode","Km Rates","Trips weekly","Cost weekly","Cost yearly"]
[null,null,"VHUVHA",{"v":0.85,"d":"85%"},{"$f":"D70*H14","v":{"v":65.45,"d":"65"}},{"v":20,"d":"20.00"},{"$f":"E70/2","v":{"v":32.725,"d":"33"}},"Truck ",null,2,{"$f":"F70*I70*J70","v":{"v":0,"d":"R0.00"}},{"$f":"K70*($P$2/5)","v":{"v":0,"d":"R0.00"}}]
[null,null,"THSAKUMA",{"v":0.15,"d":"15%"},{"$f":"D71*H14","v":{"v":11.549999999999999,"d":"12"}},{"v":30,"d":"30.00"},{"$f":"E71/2","v":{"v":5.7749999999999995,"d":"6"}},"Bakkie",null,2,{"$f":"F71*I71*J71","v":{"v":0,"d":"R0.00"}},{"$f":"K71*($P$2/5)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},{"$f":"SUM(E70:E71)","v":77},{"$nulls":5},"Yearly Total",{"$f":"SUM(L70:L71)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":7},"Note: Overtime to be invoice on Km Rates",null,null,"Total Daily Cost",{"$f":"L72/P2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":10},"Daily Cost Per head",{"$f":"L73/H14","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["Training","Training","QTY","Unit Price ","Total"]
[null,"First Aid",3,null,{"$f":"C79*D79","v":0}]
[null,"SHE Rep",null,null,{"$f":"C80*D80","v":0},"to be provided by KLF"]
[{"$nulls":3},"Yearly Total",{"$f":"SUM(E79:E80)","v":0}]
[{"$nulls":3},"Total Daily Cost",{"$f":"E81/P2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Daily Cost Per head",{"$f":"E82/H14","v":{"v":0,"d":"0.00"}}]
[]
[]
["First Aid","First Aid Box ","QTY","Unit Price ","Total"]
[null,"Box",1,null,{"$f":"D87*C87","v":0}]
[{"$nulls":3},"Yearly Total",{"$f":"SUM(E87)","v":0}]
[{"$nulls":3},"Total Daily Cost",{"$f":"E88/P2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Daily Cost Per head",{"$f":"E89/H14","v":{"v":0,"d":"0.00"}}]

{"sheet":"Data input Destacking","index":5,"n_rows":78,"n_cols":14,"rows_kept":78,"merged":[[2,5,2,6],[3,0,16,0],[20,0,27,0],[21,8,21,10],[32,0,38,0],[42,0,48,0],[51,0,54,0],[57,0,62,0],[65,0,70,0],[73,0,77,0]]}
[]
[{"$nulls":12},"Ave Yearly Prod Days",236]
[{"$nulls":5},"Type of Leaves (Yearly)",{"$nulls":6},"Ave Monthly Prod Days",{"$f":"N2/12","v":{"v":19.666666666666668,"d":"19.67"}}]
["Leave Costing","Poistions","# No","Grades ","Daily Base Rate","Annual (days)\n1 Accum monthly","Sick Leave (days)\n30  in 3 year cycle","Provision for Public Holidays","Total Days Yearly","Daily leave cost","Total Cost Yearly"]
[null,"Destackers",8,"A3",null,{"$f":"1.2*12","v":14.399999999999999},{"$f":"30/3","v":10},10,{"$f":"SUM(F5:H5)","v":34.4},{"$f":"(I5*E5)/235","v":{"v":0,"d":"0.000"}},{"$f":"I5*C5*E5","v":{"v":0,"d":"R0.00"}}]
[null,"Trimsaw operators",8,"B1",null,{"$f":"1.2*12","v":14.399999999999999},{"$f":"30/3","v":10},10,{"$f":"SUM(F6:H6)","v":34.4},{"$f":"(I6*E6)/235","v":{"v":0,"d":"0.000"}},{"$f":"I6*C6*E6","v":{"v":0,"d":"R0.00"}}]
[null,"X-cut operator",2,"B1",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"General workers",4,"A1",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"Ticket Writers",2,"A3",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"Strapper",2,"A1",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"Grader",4,"B1",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"Stackers",18,"A1",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"Sorters",8,"A1",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"Supervisor ",2,"B4",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"Foreman",1,"C1",null,14.399999999999999,10,10,34.4,{"v":0,"d":"0.000"},{"v":0,"d":"R0.00"}]
[null,"Total People",{"$f":"SUM(C5:C15)","v":59},{"$nulls":6},"Yearly Total",{"$f":"SUM(K5:K15)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":9},"Total Daily Cost",{"$f":"SUM(J5:J15)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["Core PPE Costing","PPE (Essential)","QTY per annum","Unit Price ","#No ","Total"]
[null,"Safety Boots",2,null,{"$f":"$C$16","v":59},{"$f":"D22*C22*E22","v":{"v":0,"d":"R0.00"}},null,null,"Note: Only put inputs of the yellow Columns "]
[null,"Overhauls",3,null,{"$f":"$C$16","v":59},{"$f":"D23*C23*E23","v":{"v":0,"d":"R0.00"}}]
[null,"Helmet",1,null,59,{"v":0,"d":"R0.00"}]
[null,"T-shirts",2,null,59,{"v":0,"d":"R0.00"}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F22:F25)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F26/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F27/C16","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
[]
["Consumable PPE","Consumable PPE","QTY","Unit Price ","#No ","Total"]
[null,"Ear plugs (1 in 3 months)",4,null,{"$f":"$C$16","v":59},{"$f":"E34*D34*C34","v":{"v":0,"d":"R0.00"}}]
[null,"Gloves (1 pair monthly)",12,null,{"$f":"$C$16","v":59},{"$f":"E35*D35*C35","v":{"v":0,"d":"R0.00"}}]
[null,"Apron ( 1 in 3 months)",4,null,59,{"$f":"E36*D36*C36","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F34:F36)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F37/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F38/C16","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["General Consumables","Consumables","QTY","Unit Price ","#No ","Total"]
[null,"Soap (1 bar every month)",6,null,{"$f":"$C$16","v":59},{"$f":"C44*D44*E44","v":{"v":0,"d":"R0.00"}}]
[null,"Polish (2 every month)",8,null,{"$f":"$C$16","v":59},{"$f":"C45*D45*E45","v":{"v":0,"d":"R0.00"}}]
[null,"Toliet Paper ( 4 in 1 month)",{"$f":"4*12","v":48},null,59,{"v":0,"d":"R0.00"}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F44:F46)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F47/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F48/E46","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Medicals","Medicals","#No of workers","Cost per person","Frequency Yearly","Total"]
[null,null,{"$f":"C16","v":59},null,1,{"$f":"C53*D53*E53","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F53/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F54/C53","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Transport ","Destination","Split","# No","Distance (incl. return)","People per shift","Transport mode",null,"Km Rates","Trips weekly","Cost weekly","Cost yearly"]
[null,"VHUVHA",{"v":0.85,"d":"85%"},{"$f":"C59*$C$16","v":{"v":50.15,"d":"50"}},{"v":25,"d":"25.00"},{"$f":"D59/2","v":{"v":25.075,"d":"25"}},"Truck ",null,null,2,{"$f":"E59*I59*J59","v":{"v":0,"d":"R0.00"}},{"$f":"K59*47","v":{"v":0,"d":"R0.00"}}]
[null,"THSAKUMA",{"v":0.15,"d":"15%"},{"$f":"C60*$C$16","v":{"v":8.85,"d":"9"}},{"v":30,"d":"30.00"},{"$f":"D60/2","v":{"v":4.425,"d":"4"}},"Bakkie",null,null,2,{"$f":"E60*I60*J60","v":{"v":0,"d":"R0.00"}},{"$f":"K60*47","v":{"v":0,"d":"R0.00"}}]
[null,null,{"$f":"SUM(C59:C60)","v":{"v":1,"d":"100%"}},{"$f":"SUM(D59:D60)","v":59},{"$nulls":6},"Yearly Total",{"$f":"SUM(L59:L60)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":6},"Note: Overtime to be invoice on Km Rates",{"$nulls":3},"Total Daily Cost",{"$f":"L61/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":10},"Daily Cost Per head",{"$f":"L62/D61","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Training ","Training type","QTY","Price ","Total"]
[null,"First Aid",2,null,{"$f":"C67*D67","v":0}]
[null,"SHE Rep",2,0,{"$f":"C68*D68","v":0},"To be provided by KLF"]
[{"$nulls":3},"Yearly Total",{"$f":"SUM(E67:E68)","v":0}]
[{"$nulls":3},"Total Daily Cost",{"$f":"E69/N2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Daily Cost Per head",{"$f":"E70/C16","v":{"v":0,"d":"0.00"}}]
[]
[]
["First Aid","First Aid Box ","QTY","Price ","Total"]
[null,"Box",2,null,{"$f":"D75*C75","v":0}]
[{"$nulls":3},"Yearly Total",{"$f":"SUM(E75)","v":0}]
[{"$nulls":3},"Total Daily Cost",{"$f":"E76/N2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Daily Cost Per head",{"$f":"E77/C16","v":{"v":0,"d":"0.00"}}]

{"sheet":"Data input Rework","index":6,"n_rows":75,"n_cols":14,"rows_kept":75,"merged":[[2,5,2,6],[3,0,13,0],[17,0,24,0],[18,8,18,10],[29,0,35,0],[39,0,45,0],[48,0,51,0],[54,0,59,0],[62,0,67,0],[70,0,74,0]]}
[]
[{"$nulls":12},"Ave Yearly Prod Days",236]
[{"$nulls":5},"Type of Leave (Yearly)",{"$nulls":6},"Ave Monthly Prod Days",{"$f":"N2/12","v":{"v":19.666666666666668,"d":"19.67"}}]
["Leave Costing","Poistions","# No","Grades ","Daily Base Rate","Annual (days)\n1 Accum monthly","Sick Leave (days)\n30  in 3 year cycle","Provision for Public Holidays","Total Days Yearly","Daily leave cost","Total Cost Yearly"]
[null,"General Workers",53,"A1",null,{"$f":"1.2*12","v":14.399999999999999},{"$f":"30/3","v":10},{"v":10,"d":"10.00"},{"$f":"SUM(F5:H5)","v":34.4},{"$f":"(I5*E5)/$N$2","v":{"v":0,"d":"R0.00"}},{"$f":"I5*C5*E5","v":{"v":0,"d":"R0.00"}}]
[null,"General Workers",6,"A1",null,{"$f":"1.2*12","v":14.399999999999999},{"$f":"30/3","v":10},{"v":10,"d":"10.00"},{"$f":"SUM(F6:H6)","v":34.4},{"$f":"(I6*E6)/$N$2","v":{"v":0,"d":"R0.00"}},{"$f":"I6*C6*E6","v":{"v":0,"d":"R0.00"}}]
[null,"General Workers",9,"A1",null,14.399999999999999,10,{"v":10,"d":"10.00"},34.4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Operator",3,"B1",null,14.399999999999999,10,{"v":10,"d":"10.00"},34.4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"General Workers",6,"A1",null,14.399999999999999,10,{"v":10,"d":"10.00"},34.4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Operator",3,"B1",null,14.399999999999999,10,{"v":10,"d":"10.00"},34.4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"General Workers",23,"A1",null,14.399999999999999,10,{"v":10,"d":"10.00"},34.4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Loaders",4,"A1",null,14.399999999999999,10,{"v":10,"d":"10.00"},34.4,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Total People",{"$f":"SUM(C5:C12)","v":107},{"$nulls":6},"Yearly Total",{"$f":"SUM(K5:K12)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":9},"Total Daily Cost",{"$f":"SUM(J5:J12)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
["Core PPE ","PPE (Essential)","QTY per annum","Unit Price ","#No ","Total"]
[null,"Safety Boots",2,null,{"$f":"$C$13","v":107},{"$f":"D19*C19*E19","v":{"v":0,"d":"R0.00"}},null,null,"Note: Only put inputs of the yellow Columns "]
[null,"Overhauls",3,null,{"$f":"$C$13","v":107},{"$f":"D20*C20*E20","v":{"v":0,"d":"R0.00"}}]
[null,"Helmet",1,null,107,{"v":0,"d":"R0.00"}]
[null,"T-shirts",2,null,107,{"v":0,"d":"R0.00"}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F19:F22)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F23/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F24/C13","v":{"v":0,"d":"R0.00"}}]
[]
[]
[]
[]
["Consumable PPE","Consumable PPE","QTY","Unit Price ","#No ","Total"]
[null,"Ear plugs (1 in 3 months)",4,null,{"$f":"$C$13","v":107},{"$f":"E31*D31*C31","v":{"v":0,"d":"R0.00"}}]
[null,"Gloves (1 pair monthly)",12,null,{"$f":"$C$13","v":107},{"$f":"E32*D32*C32","v":{"v":0,"d":"R0.00"}}]
[null,"Apron ( 1 in 3 months)",4,null,107,{"v":0,"d":"R0.00"}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F31:F33)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F34/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F35/C13","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["General Consumables","Consumables","QTY","Price ","#No ","Total"]
[null,"Soap (1 bar every month)",6,null,{"$f":"$C$13","v":107},{"$f":"C41*D41*E41","v":{"v":0,"d":"R0.00"}}]
[null,"Polish (2 every month)",8,null,{"$f":"$C$13","v":107},{"$f":"C42*D42*E42","v":{"v":0,"d":"R0.00"}}]
[null,"Toliet Paper ( 4 in 1 month)",{"$f":"4*12","v":48},null,107,{"v":0,"d":"R0.00"}]
[{"$nulls":4},"Yearly Total",{"$f":"SUM(F41:F43)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F44/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F45/E43","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Medicals","Medicals","#No of workers","Cost per person","Frequency Yearly","Total"]
[null,null,{"$f":"C13","v":107},null,1,{"$f":"C50*D50*E50","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Daily Cost",{"$f":"F50/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Daily Cost Per head",{"$f":"F51/C50","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Transport ","Destination","Split","# No","Distance (incl. return)","People per shift","Transport mode",null,"Km Rates","Trips weekly","Cost weekly","Cost yearly"]
[null,"VHUVHA",{"v":0.85,"d":"85%"},{"$f":"C56*$C$13","v":{"v":90.95,"d":"91"}},{"v":25,"d":"25.00"},{"$f":"D56/2","v":{"v":45.475,"d":"45"}},"Truck ",null,null,2,{"$f":"E56*I56*J56","v":{"v":0,"d":"R0.00"}},{"$f":"K56*47","v":{"v":0,"d":"R0.00"}}]
[null,"THSAKUMA",{"v":0.15,"d":"15%"},{"$f":"C57*$C$13","v":{"v":16.05,"d":"16"}},{"v":30,"d":"30.00"},{"$f":"D57/2","v":{"v":8.025,"d":"8"}},"Bakkie",null,null,2,{"$f":"E57*I57*J57","v":{"v":0,"d":"R0.00"}},{"$f":"K57*47","v":{"v":0,"d":"R0.00"}}]
[null,null,{"$f":"SUM(C56:C57)","v":{"v":1,"d":"100%"}},{"$f":"SUM(D56:D57)","v":107},{"$nulls":6},"Yearly Total",{"$f":"SUM(L56:L57)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":6},"Note: Overtime to be invoice on Km Rates",{"$nulls":3},"Total Daily Cost",{"$f":"L58/N2","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":10},"Daily Cost Per head",{"$f":"L59/D58","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Training ","Training type","QTY","Price ","Total"]
[null,"First Aid",2,null,{"$f":"C64*D64","v":0}]
[null,"SHE Rep",2,null,{"$f":"C65*D65","v":0},"To be provided by KLF"]
[{"$nulls":3},"Yearly Total",{"$f":"SUM(E64:E65)","v":0}]
[{"$nulls":3},"Total Daily Cost",{"$f":"E66/N2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Daily Cost Per head",{"$f":"E67/C13","v":{"v":0,"d":"0.00"}}]
[]
[]
["First Aid","First Aid Box ","QTY","Price ","Total"]
[null,"Box",2,null,{"$f":"D72*C72","v":0}]
[{"$nulls":3},"Yearly Total",{"$f":"SUM(E72)","v":0}]
[{"$nulls":3},"Total Daily Cost",{"$f":"E73/N2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Daily Cost Per head",{"$f":"E74/C13","v":{"v":0,"d":"0.00"}}]