{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["InputOutput","Densities","Definition of Sorting","Sorter Allocation","Allocation  of Equipment To Mat","Benchmark Sorting Rate","Construction 200T","Construction 600T","MRF Labor Requirements","Equpment Costs","Model Ranges","Lookup Matrix","Sheet1","Sheet2","Cost Curves Single Stream"],"not_rendered":{"charts":2,"images":9,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"InputOutput","index":0,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["INPUTS",null,null,null,null,null,"DESCRIPTION AND ASSUMPTIONS",null,null,null,null,null,null,null,null,"PROCESS FLOW DIAGRAM"]
["Annual Incoming Tonnes",27433,null,null,null,null,{"$f":"VLOOKUP(B4,Sheet1!A21:B26,2,FALSE)","v":"Picture 5"},null,null,null,null,null,null,null,{"$f":"VLOOKUP(B3,Sheet1!A28:B29,2,FALSE())","v":"Picture 8"}]
["Number of Streams","Single"]
["Classification",{"$f":"IF(AND(B2<20000,B3=\"Single\"),\"Single Stream Small\",IF(AND(B2>20000,B2<105000,B3=\"Single\"),\"Single Stream Medium\",IF(AND(B2>105000,B3=\"Single\"),\"Single Stream Large\",IF(AND(B2<10000,B3=\"Dual\"),\"Dual Stream Small\",IF(AND(B2>10000,B2<65000,B3=\"Dual\"),\"Dual Stream Medium\",\"Dual Stream Large\")))))","v":"Single Stream Medium"}]
[]
["Can Be Supported By:"]
["Large Urban",{"$f":"IF($B$2<E7,\"a\",\"\")","v":"a"},null,null,426542.74]
["Urban Regional",{"$f":"IF($B$2<E8,\"a\",\"\")","v":"a"},null,null,229743.23999999996]
["Medium Urban","a",null,null,51230.33511]
["Small Urban","",null,null,25910.569709999996]
["Rural Regional","a",null,null,96390.619550000003]
["Rural Collection - North","",null,null,9942.0137440000017]
["Rural Collection South","a",null,null,38299.415240000009]
["Rural Depot North","",null,null,6048.4668679999986]
["Rural Depot South","",null,null,8816.987948]
[]
["Building amortization period",20]
["Equipment amortization period",10]
["Rolling stock amortizaiton period",8]
["Interest Rate",0.04]
[]
[]
[]
[]
[]
["OUTPUTS"]
["Annual Building Cost ",{"$f":"IF($B$4=\"Single Stream Small\",$B$2*'Lookup Matrix'!B16,IF($B$4=\"Single Stream Medium\",$B$2*'Lookup Matrix'!D16,IF($B$4=\"Single Stream Large\",$B$2*'Lookup Matrix'!F16,IF($B$4=\"Dual Stream Small\",$B$2*'Lookup Matrix'!C16,IF($B$4=\"Dual Stream Medium\",$B$2*'Lookup Matrix'!E16,$B$2*'Lookup Matrix'!G16)))))","v":227162.9419162808}]
["Annual Equipment Cost ",{"$f":"IF($B$4=\"Single Stream Small\",$B$2*'Lookup Matrix'!B17,IF($B$4=\"Single Stream Medium\",$B$2*'Lookup Matrix'!D17,IF($B$4=\"Single Stream Large\",$B$2*'Lookup Matrix'!F17,IF($B$4=\"Dual Stream Small\",$B$2*'Lookup Matrix'!C17,IF($B$4=\"Dual Stream Medium\",$B$2*'Lookup Matrix'!E17,$B$2*'Lookup Matrix'!G17)))))","v":673072.79995709483}]
["Annual Rolling Stock ",{"$f":"IF($B$4=\"Single Stream Small\",$B$2*'Lookup Matrix'!B18,IF($B$4=\"Single Stream Medium\",$B$2*'Lookup Matrix'!D18,IF($B$4=\"Single Stream Large\",$B$2*'Lookup Matrix'!F18,IF($B$4=\"Dual Stream Small\",$B$2*'Lookup Matrix'!C18,IF($B$4=\"Dual Stream Medium\",$B$2*'Lookup Matrix'!E18,$B$2*'Lookup Matrix'!G18)))))","v":27050.315366053474}]
["Annual Labor Cost ",{"$f":"SUM('MRF Labor Requirements'!G25:G30)","v":950400}]
["Annual Building OM Cost",{"$f":"IF($B$4=\"Single Stream Small\",$B$2*'Lookup Matrix'!B20,IF($B$4=\"Single Stream Medium\",$B$2*'Lookup Matrix'!D20,IF($B$4=\"Single Stream Large\",$B$2*'Lookup Matrix'!F20,IF($B$4=\"Dual Stream Small\",$B$2*'Lookup Matrix'!C20,IF($B$4=\"Dual Stream Medium\",$B$2*'Lookup Matrix'!E20,$B$2*'Lookup Matrix'!G20)))))","v":151717.12264827092}]
["Annual Building Insurance Cost",{"$f":"IF($B$4=\"Single Stream Small\",$B$2*'Lookup Matrix'!B21,IF($B$4=\"Single Stream Medium\",$B$2*'Lookup Matrix'!D21,IF($B$4=\"Single Stream Large\",$B$2*'Lookup Matrix'!F21,IF($B$4=\"Dual Stream Small\",$B$2*'Lookup Matrix'!C21,IF($B$4=\"Dual Stream Medium\",$B$2*'Lookup Matrix'!E21,$B$2*'Lookup Matrix'!G21)))))","v":10533.328213792045}]
["Annual Taxes ",{"$f":"IF($B$4=\"Single Stream Small\",$B$2*'Lookup Matrix'!B22,IF($B$4=\"Single Stream Medium\",$B$2*'Lookup Matrix'!D22,IF($B$4=\"Single Stream Large\",$B$2*'Lookup Matrix'!F22,IF($B$4=\"Dual Stream Small\",$B$2*'Lookup Matrix'!C22,IF($B$4=\"Dual Stream Medium\",$B$2*'Lookup Matrix'!E22,$B$2*'Lookup Matrix'!G22)))))","v":124171.08631546613}]
["Annual Residual Disposal Cost ",{"$f":"IF($B$4=\"Single Stream Small\",$B$2*'Lookup Matrix'!B23,IF($B$4=\"Single Stream Medium\",$B$2*'Lookup Matrix'!D23,IF($B$4=\"Single Stream Large\",$B$2*'Lookup Matrix'!F23,IF($B$4=\"Dual Stream Small\",$B$2*'Lookup Matrix'!C23,IF($B$4=\"Dual Stream Medium\",$B$2*'Lookup Matrix'!E23,$B$2*'Lookup Matrix'!G23)))))","v":153625.43199969284}]
["Annual Total Cost",{"$f":"SUM(B27:B34)","v":2317733.026416651}]
["Cost Per Tonne",{"$f":"B35/B2","v":84.487042117765142}]
[]
[]
[]
[]
[]
[]
["COST CURVES"]

{"sheet":"Densities","index":1,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,1,1],[0,0,1,0]]}
["Materials (Managed)","Density of Material (pre sorting)"]
[]
["Newsprint - CNA/OCNA",182]
["Newsprint - Non-CNA/OCNA",182]
["Magazines and Catalogues",182]
["Telephone Books",206]
["Other Printed Paper",206]
[]
["Corrugated Cardboard",95]
["Boxboard",95]
["Gable Top Cartons",55]
["Paper Laminates",55]
["Aseptic Containers",55]
[]
["PET Bottles",28]
["HDPE Bottles",28]
["Plastic Film",29]
["Plastic Laminates",29]
["Polystyrene",29]
["Other Plastics",29]
[]
["Steel Food & Beverage Cans",87]
["Steel Aerosols",87]
["Steel Paint Cans",87]
[]
["Aluminum Food & Beverage Cans",34]
["Other Aluminum Packaging",34]
[]
["Clear Glass",500]
["Coloured Glass",500]

{"sheet":"Definition of Sorting","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,0,1,0],[0,4,1,4],[0,1,1,1],[0,2,0,3]]}
["Materials (Managed)","Sort Stream","Material Residues",null,"Is Material Negatively Sorted?",null,null,null,null,null,1,"Yes"]
[null,null,"Manually","By Machine",null,null,null,null,null,null,2,"No"]
["Newsprint - CNA/OCNA"]
["Newsprint - Non-CNA/OCNA"]
["Magazines and Catalogues"]
["Telephone Books"]
["Other Printed Paper"]
[]
["Corrugated Cardboard"]
["Boxboard"]
["Gable Top Cartons"]
["Paper Laminates"]
["Aseptic Containers"]
[]
["PET Bottles"]
["HDPE Bottles"]
["Plastic Film"]
["Plastic Laminates"]
["Polystyrene"]
["Other Plastics"]
[]
["Steel Food & Beverage Cans"]
["Steel Aerosols"]
["Steel Paint Cans"]
[]
["Aluminum Food & Beverage Cans"]
["Other Aluminum Packaging"]
[]
["Clear Glass"]
["Coloured Glass"]

{"sheet":"Sorter Allocation","index":3,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,25,3,25],[1,1,2,1],[1,2,1,24],[1,0,32,0],[0,2,0,24]]}
[null,null,"SECONDARY SORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sorters Allocated"]
["PRIMARY SORT","Number of Sorters","Sorter"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,"Materials Managed","Newsprint - CNA/OCNA","Newsprint - Non-CNA/OCNA","Magazines and Catalogues","Telephone Books","Other Printed Paper","Corrugated Cardboard","Boxboard","Gable Top Cartons","Paper Laminates","Aseptic Containers","PET Bottles","HDPE Bottles","Plastic Film","Plastic Laminates","Polystyrene","Other Plastics","Steel Food & Beverage Cans","Steel Aerosols","Steel Paint Cans","Aluminum Food & Beverage Cans","Other Aluminum Packaging","Clear Glass","Coloured Glass"]
[null,"Newsprint - CNA/OCNA"]
[null,"Newsprint - Non-CNA/OCNA"]
[null,"Magazines and Catalogues"]
[null,"Telephone Books"]
[null,"Other Printed Paper"]
[]
[null,"Corrugated Cardboard"]
[null,"Boxboard"]
[null,"Gable Top Cartons"]
[null,"Paper Laminates"]
[null,"Aseptic Containers"]
[]
[null,"PET Bottles"]
[null,"HDPE Bottles"]
[null,"Plastic Film"]
[null,"Plastic Laminates"]
[null,"Polystyrene"]
[null,"Other Plastics"]
[]
[null,"Steel Food & Beverage Cans"]
[null,"Steel Aerosols"]
[null,"Steel Paint Cans"]
[]
[null,"Aluminum Food & Beverage Cans"]
[null,"Other Aluminum Packaging"]
[]
[null,"Clear Glass"]
[null,"Coloured Glass"]

{"sheet":"Allocation  of Equipment To Mat","index":4,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,14,3,14],[1,0,2,0],[1,1,1,13],[0,1,0,13]]}
["Materials managed","PIECE OF EQUIPMENT",null,null,null,null,null,null,null,null,null,null,null,null,"Total Sorters Allocated"]
["Name of Sorting Station","Equipment"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13]
["                                                                                                                                                                             ","Conveyor Belt","Magnet","Eddy Current","Optical Sorter","Trommel","Vibrating Screen","Air Knife","Ballistic Seperator","Vertical Baler","2 Ram Baler","1 Ram Baler","Plastic Granulator","Glass Crusher"]
["Newsprint - CNA/OCNA"]
["Newsprint - Non-CNA/OCNA"]
["Magazines and Catalogues"]
["Telephone Books"]
["Other Printed Paper"]
[]
["Corrugated Cardboard"]
["Boxboard"]
["Gable Top Cartons"]
["Paper Laminates"]
["Aseptic Containers"]
[]
["PET Bottles"]
["HDPE Bottles"]
["Plastic Film"]
["Plastic Laminates"]
["Polystyrene"]
["Other Plastics"]
[]
["Steel Food & Beverage Cans"]
["Steel Aerosols"]
["Steel Paint Cans"]
[]
["Aluminum Food & Beverage Cans"]
["Other Aluminum Packaging"]
[]
["Clear Glass"]
["Coloured Glass"]

{"sheet":"Benchmark Sorting Rate","index":5,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Benchmark (Standard sorting Rate) kg per hour)"]
["Materials Managed","Sorters","Machines"]
["Newsprint - CNA/OCNA",440,925]
["Newsprint - Non-CNA/OCNA",495,925]
["Magazines and Catalogues",220,880]
["Telephone Books",220,550]
["Other Printed Paper",260,710]
[]
["Corrugated Cardboard",400,400]
["Boxboard",300,300]
["Gable Top Cartons",50,270]
["Paper Laminates",50,270]
["Aseptic Containers",50,270]
[]
["PET Bottles",100,400]
["HDPE Bottles",140,420]
["Plastic Film",25,50]
["Plastic Laminates",0,0]
["Polystyrene",40,60]
["Other Plastics",60,120]
[]
["Steel Food & Beverage Cans","Magnet",750]
["Steel Aerosols","Magnet",750]
["Steel Paint Cans","Magnet",750]
[]
["Aluminum Food & Beverage Cans",250,600]
["Other Aluminum Packaging",250,600]
[]
["Clear Glass",380,490]
["Coloured Glass",200,525]

{"sheet":"Construction 200T","index":6,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Item","$/unit","$/unit","# of Units","Cost"]
["Site work",4.5,{"$f":"B2*$F$2","v":7.3583999999999996},45000,{"$f":"C2*D2","v":331128},1.6352]
[]
["Fencing",12,{"$f":"B4*$F$2","v":19.622399999999999},3000,{"$f":"C4*D4","v":58867.199999999997}]
[]
["Landscaping",null,null,null,{"$f":"25000*F2","v":40880}]
[]
["Formwork"]
["-Expansion Joints",2.5,{"$f":"B9*$F$2","v":4.0880000000000001},1500,{"$f":"C9*D9","v":6132}]
["-Braces",8.6999999999999993,{"$f":"B10*$F$2","v":14.226239999999999},50,{"$f":"C10*D10","v":711.3119999999999}]
["-Barchairs",0.28499999999999998,{"$f":"B11*$F$2","v":0.46603199999999995},43000,{"$f":"C11*D11","v":20039.375999999997}]
["-r/f for footings",1200,{"$f":"B12*$F$2","v":1962.24},2,{"$f":"C12*D12","v":3924.48}]
[]
["Concrete"]
["-slab",50,{"$f":"B15*$F$2","v":81.760000000000005},1593,{"$f":"C15*D15","v":130243.68000000001}]
["-Footings",190,{"$f":"B16*$F$2","v":310.68799999999999},50,{"$f":"C16*D16","v":15534.4}]
["-Floor Hardner",0.8,{"$f":"B17*$F$2","v":1.30816},43000,56250.879999999997]
["-Loading Docts",100,{"$f":"B18*$F$2","v":163.52000000000001},75,12264]
["-Curing",0.15,{"$f":"B19*$F$2","v":0.24528},1718,421.39103999999998]
[]
["Roof and Siding Including Framework",11,{"$f":"B21*$F$2","v":17.987200000000001},43000,773449.60000000009]
[]
["Metal Fabrications"]
["-Stairs",200,{"$f":"B24*$F$2","v":327.04000000000002},40,{"$f":"C24*D24","v":13081.6}]
["-Railing",25,{"$f":"B25*$F$2","v":40.880000000000003},300,12264]
["-Steel Deck",5,{"$f":"B26*$F$2","v":8.1760000000000002},800,6540.8]
["-Doors",5000,{"$f":"B27*$F$2","v":8176},6,49056]
[]
["Electrical",5,{"$f":"B29*$F$2","v":8.1760000000000002},43000,351568]
[]
["Offices and Sorting Room",25,{"$f":"B31*$F$2","v":40.880000000000003},4000,163520]
[]
["Pavement",10,{"$f":"B33*$F$2","v":16.352},13333,218021.21600000001]
[]
["Storage area netting",2,{"$f":"B35*$F$2","v":3.2704},167,546.15679999999998]
[]
["Scale house",20000,{"$f":"B37*$F$2","v":32704},1,32704]
[]
["Painting",0.5,{"$f":"B39*$F$2","v":0.81759999999999999},64000,52326.400000000001]
[]
["Fire Protection",null,null,null,{"$f":"8000*F2","v":13081.6}]
[]
["Security Gates",2500,{"$f":"B43*$F$2","v":4088},2,{"$f":"C43*D43","v":8176}]
[]
[null,null,null,"Total Cost:",{"$f":"SUM(E2:E44)","v":2370732.0918399999}]
[null,null,null,"Total Cost ($/sq ft)",{"$f":"(E45/D2)*10.7639","v":567.0738480745905}]
[null,null,null,"$/TPD",{"$f":"E45/(200*'MRF Labor Requirements'!B20)","v":53.880274814545452}]

{"sheet":"Construction 600T","index":7,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Item","$/unit","$/unit","# of Units","Cost"]
["Site work",4.5,{"$f":"B2*$F$2","v":7.3583999999999996},72000,{"$f":"C2*D2","v":529804.79999999993},1.6352]
[]
["Fencing",12,{"$f":"B4*$F$2","v":19.622399999999999},5000,{"$f":"C4*D4","v":98112}]
[]
["Landscaping",null,null,null,{"$f":"25000*F2","v":40880}]
[]
["Formwork"]
["-Expansion Joints",2.5,{"$f":"B9*$F$2","v":4.0880000000000001},200,{"$f":"C9*D9","v":817.6}]
["-Braces",8.6999999999999993,{"$f":"B10*$F$2","v":14.226239999999999},70,{"$f":"C10*D10","v":995.83679999999993}]
["-Barchairs",0.28499999999999998,{"$f":"B11*$F$2","v":0.46603199999999995},72000,{"$f":"C11*D11","v":33554.303999999996}]
["-r/f for footings",1200,{"$f":"B12*$F$2","v":1962.24},3,{"$f":"C12*D12","v":5886.72}]
[]
["Concrete"]
["-slab",50,{"$f":"B15*$F$2","v":81.760000000000005},2667,{"$f":"C15*D15","v":218053.92}]
["-Footings",190,{"$f":"B16*$F$2","v":310.68799999999999},70,{"$f":"C16*D16","v":21748.16}]
["-Floor Hardner",0.8,{"$f":"B17*$F$2","v":1.30816},72000,94187.520000000004]
["-Loading Docts",100,{"$f":"B18*$F$2","v":163.52000000000001},120,19622.400000000001]
["-Curing",0.15,{"$f":"B19*$F$2","v":0.24528},2857,700.76495999999997]
[]
["Roof and Siding Including Framework",11,{"$f":"B21*$F$2","v":17.987200000000001},75000,1349040]
[]
["Metal Fabrications"]
["-Stairs",200,{"$f":"B24*$F$2","v":327.04000000000002},25,{"$f":"C24*D24","v":8176.0000000000009}]
["-Railing",25,{"$f":"B25*$F$2","v":40.880000000000003},650,26572]
["-Steel Deck",5,{"$f":"B26*$F$2","v":8.1760000000000002},450,3679.2000000000003]
["-Doors",5000,{"$f":"B27*$F$2","v":8176},10,81760]
[]
["Electrical",5,{"$f":"B29*$F$2","v":8.1760000000000002},72000,588672]
[]
["Offices and Sorting Room",25,{"$f":"B31*$F$2","v":40.880000000000003},10000,408800]
[]
["Pavement",10,{"$f":"B33*$F$2","v":16.352},38889,635912.92799999996]
[]
["Storage area netting",2,{"$f":"B35*$F$2","v":3.2704},1000,3270.4]
[]
["Scale house",15000,{"$f":"B37*$F$2","v":24528},1,24528]
[]
["Painting",0.5,{"$f":"B39*$F$2","v":0.81759999999999999},100000,81760]
[]
["Fire Protection",null,null,null,{"$f":"8000*F2","v":13081.6}]
[]
["Security Gates",2500,{"$f":"B43*$F$2","v":4088},2,{"$f":"C43*D43","v":8176}]
[]
[null,null,null,"Total Cost:",{"$f":"SUM(E2:E44)","v":4297792.1537599992}]
[null,null,null,"Total Cost ($/sq m)",{"$f":"(E45/D2)*10.7639","v":642.51395783135069}]
[null,null,null,"$/TPD",{"$f":"E45/(600*'MRF Labor Requirements'!B20)","v":32.559031467878782}]

{"sheet":"MRF Labor Requirements","index":8,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Employee Categories","Capacity (TPD)"]
[null,10,100,500]
["Manager",1,1,1]
["Foreman/Operator",1,1.5,3.5]
["Sorters",1.5,19,70]
["Maintenance",1,1.5,4]
["other (rolling stock operators, clean up staff etc)",0,4.5,11]
["Administrative (scale monitors, book keepers)",0,1.5,2.5]
["Total Number of Employees",{"$f":"SUM(B3:B8)","v":4.5},{"$f":"SUM(C3:C8)","v":29},92]
[]
["Employee Categories","Labor Costs"]
["Manager",25]
["Foreman/Operator",40]
["Sorters",12]
["Maintenance",15]
["other (rolling stock operators, clean up staff etc)",12]
["Administrative (scale monitors, book keepers)",15]
[]
["Working Assumptions","Days/Hours"]
["Number of working days per year",220]
["Length of working day",12]
["Number of shifts per day",2]
[]
["Employee Categories","Marginal Worker Per Tonne","Labor Required","# of Hours Worked","Total Hours Per Day","Total Labor Costs Per Day","Labor Costs Per Year"]
["Marginal Manager Per Tonne",1,1,7.5,{"$f":"D25*C25","v":7.5},{"$f":"E25*B12","v":187.5},{"$f":"F25*$B$20","v":41250}]
["Marginal Foreman/Operator Per Tonne",{"$f":"0.00555555555555556","v":5.5555555555555601E-3},{"$f":"ROUNDUP(B26*(InputOutput!$B$2/'MRF Labor Requirements'!$B$20)+Sheet1!B3,0)","v":2},7.5,{"$f":"D26*C26","v":15},{"$f":"E26*B13","v":600},{"$f":"F26*$B$20","v":132000}]
["Marginal Sorter Per Tonne",{"$f":"0.194444444444444","v":0.194444444444444},{"$f":"ROUNDUP(B27*(InputOutput!$B$2/'MRF Labor Requirements'!$B$20)+Sheet1!B4,0)","v":26},7.5,195,2340,514800]
["Marginal Maintenance Per Tonne",{"$f":"0.00555555555555556","v":5.5555555555555601E-3},{"$f":"ROUNDUP(B28*(InputOutput!$B$2/'MRF Labor Requirements'!$B$20)+Sheet1!B5,0)","v":2},7.5,15,225,49500]
["Marginal other (rolling stock operators, clean up staff etc)",0.05,{"$f":"ROUNDUP(B29*(InputOutput!$B$2/'MRF Labor Requirements'!$B$20)+Sheet1!B6,0)","v":7},7.5,52.5,630,138600]
["Marginal Administrative (scale monitors, book keepers)",1.6666666666666666E-2,{"$f":"ROUNDUP(B30*(InputOutput!$B$2/'MRF Labor Requirements'!$B$20)+Sheet1!B7,0)","v":3},7.5,22.5,337.5,74250]
[]
[null,"Manager","Foreman/Operator","Sorters","Maintenance","other (rolling stock operators, clean up staff etc)","Administrative (scale monitors, book keepers)"]
[10,1,1,1.5,1,0,0]
[100,1,1.5,19,1.5,4.5,1.5]
[500,1,3.5,55,4,11,2.5]
["WA TPD",1,{"$f":"ROUNDUP(SUMPRODUCT(C33:C35,$A$33:$A$35)/SUM($A$33:$A$35),0)","v":4},{"$f":"ROUNDUP(SUMPRODUCT(D33:D35,$A$33:$A$35)/SUM($A$33:$A$35),0)","v":49},{"$f":"ROUNDUP(SUMPRODUCT(E33:E35,$A$33:$A$35)/SUM($A$33:$A$35),0)","v":4},{"$f":"ROUNDUP(SUMPRODUCT(F33:F35,$A$33:$A$35)/SUM($A$33:$A$35),0)","v":10},{"$f":"ROUNDUP(SUMPRODUCT(G33:G35,$A$33:$A$35)/SUM($A$33:$A$35),0)","v":3}]

{"sheet":"Equpment Costs","index":9,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Material","50/TPD","1/TPD","Fixed Cost"]
["Conveyor Belt (Paper Fibers)",{"$f":"D2/50","v":5670},{"$f":"B2/50","v":113.4},283500]
["Conveyor Belt (Containers)",{"$f":"D3/50","v":8910.0000000000018},{"$f":"B3/50","v":178.20000000000005},445500.00000000006]
["Feed Line",4050,81,202500]
["Magnet",810,16.2,40500]
["Eddy Current",5184.0000000000009,103.68000000000002,259200.00000000003]
["Dual Eject Optical Sorter",16200,324,810000]
["Trommel",1490.4,29.808000000000003,74520]
["Vibrating Screen",0,0,0]
["Air Knife",0,0,0]
["Ballistic Seperator",4860.0000000000009,97.200000000000017,243000.00000000003]
["Vertical Baler",2430.0000000000005,48.600000000000009,121500.00000000001]
["2 Ram Baler",3240,64.8,162000]
["1 Ram Baler",7290,145.80000000000001,364500]
["Plastic Granulator",0,0,0]
["Glass Crusher",4860.0000000000009,97.200000000000017,243000.00000000003]
["Cost of Bins",972,19.440000000000001,48600]
["Rolling Stock",2106,42.12,105300]
["Installation",6520,130.4,326000]
["Average Equipment  $/TPD",null,{"$f":"AVERAGE(C2:C19)","v":82.88044444444445}]

{"sheet":"Model Ranges","index":10,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Single"]
["Dual"]
[]
[1]
[2]

{"sheet":"Lookup Matrix","index":11,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"Single Stream Small","Dual Stream Small","Single Stream Medium","Dual Stream Medium","Single Stream Large","Dual Stream Large"]
["Single vs Dual Stream",1,2,1,2,1,2]
[null,22324,10492,52088,22324,104177,65482]
["Tonnes TPD",{"$f":"B3/'MRF Labor Requirements'!$B$20","v":101.47272727272727},{"$f":"C3/'MRF Labor Requirements'!$B$20","v":47.690909090909088},{"$f":"D3/'MRF Labor Requirements'!$B$20","v":236.76363636363635},{"$f":"E3/'MRF Labor Requirements'!$B$20","v":101.47272727272727},{"$f":"F3/'MRF Labor Requirements'!$B$20","v":473.53181818181821},{"$f":"G3/'MRF Labor Requirements'!$B$20","v":297.64545454545453}]
["Tonnes Threshold ",20000,10000,50000,20000,105000,65000]
["Building Cost TPD",345057.80099982454,189781.7905499035,431322.2512497807,345057.80099982454,905776.72762453952,534839.59154972807,null,null,null,null,null,{"$f":"PMT(InputOutput!M20/12,InputOutput!M17,-5168000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M17,-2842400,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M17,-6460000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M17,-5168000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M17,-13566000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M17,-8010400,0)","v":{"$error":"#NUM!"}}]
["Equipment Cost TPD",531971.38899574068,313735.49886414484,1277986.9501755242,429514.54202122486,2271293.323873986,808923.62921731209,null,null,null,null,null,{"$f":"PMT(InputOutput!M20/12,InputOutput!M18,-4050000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M18,-2400000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M18,-9300000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M18,-3250000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M18,-17600000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M18,-6750000,0)","v":{"$error":"#NUM!"}}]
["Rolling Stock TPD",27819.810004434908,27686.835944803846,51361.383253271364,43632.728472193266,90840.808440084031,50017.334300150789,null,null,null,null,null,{"$f":"PMT(InputOutput!M20/12,InputOutput!M19,-170000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M19,-170000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M19,-300000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M19,-265000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M19,-565000,0)","v":{"$error":"#NUM!"}},{"$f":"PMT(InputOutput!M20/12,InputOutput!M19,-335000,0)","v":{"$error":"#NUM!"}}]
["Labor Cost TPD"]
["Annual Building OM Cost",79653,79653,123462,79653,209089,99566,null,null,null,null,null,267539.29863666062,147146.61425016334,334424.12329582579,267539.29863666062,702290.65892123419,414685.91288682399]
["Building Insurance Cost TPD",10000,8000,20000,10000,30000,30000,null,null,null,null,null,412462.06257125887,244421.96300519045,947135.10664511286,330988.07490286202,1792427.72870473,687436.77095209807]
["Taxes TPD",152108,83660,235768,152108,399284,190135,null,null,null,null,null,21569.987507094367,21569.987507094367,38064.683836048884,33623.804055176515,71688.487891225392,42505.563616921252]
["Residual Disposal Cost TPD",125012,117511,291694,125012,583389,366701,null,null,null,null,null,{"$f":"SUM(M10:M12)","v":701571.34871501382},{"$f":"SUM(N10:N12)","v":413138.56476244819},1319623.9137769877,632151.1775946992,2566406.87551719,1144628.2474558433]
[null,null,null,null,null,null,null,null,null,null,null,null,904849,530297,1780593,820326,3252049,1346912]
["Tonnes Threshold ",20000,10000,50000,20000,105000,65000,null,null,null,null,null,{"$f":"M14/M13","v":1.2897462270335101},{"$f":"N14/N13","v":1.2835814548199274},1.3493185303861617,1.2976737670904859,1.2671603365092441,1.1767244107366486]
["Building Cost TPD",{"$f":"B6/B$3","v":15.456808860411419},18.088237757329725,{"$f":"D6/D$3","v":8.2806452781788646},15.456808860411419,8.6945940814626983,{"$f":"G6/G$3","v":8.1677345155879184}]
["Equipment Cost TPD",23.829573060192647,29.90235406635006,{"$f":"D7/D$3","v":24.535151093832059},19.240035030515358,21.802253125680199,{"$f":"G7/G$3","v":12.353373892326321},null,null,null,null,null,{"$f":"M10*$M$15","v":345057.80099982454},{"$f":"N10*$M$15","v":189781.7905499035},431322.2512497807,345057.80099982454,905776.72762453952,534839.59154972807]
["Rolling Stock TPD",1.2461839278102003,2.6388520725127571,0.98605020836414081,1.9545210747264499,0.87198526008700605,{"$f":"G8/G$3","v":0.76383333282659038},null,null,null,null,null,{"$f":"M11*M15","v":531971.38899574068},{"$f":"N11*N15","v":313735.49886414484},1277986.9501755242,429514.54202122486,2271293.323873986,808923.62921731209]
["Labor Cost TPD",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M12*M15","v":27819.810004434908},{"$f":"N12*N15","v":27686.835944803846},51361.383253271364,43632.728472193266,90840.808440084031,50017.334300150789]
["Annual Building OM Cost",{"$f":"B10/$B$3","v":3.568043361404766},{"$f":"C10/$B$3","v":3.568043361404766},5.5304604909514428,3.568043361404766,9.3661082243325566,4.4600430030460494]
["Building Insurance Cost TPD",{"$f":"B11/B$3","v":0.4479483963447411},0.76248570339306143,0.38396559668253727,0.4479483963447411,0.28797143323382318,0.45814116856540726]
["Taxes TPD",6.8136534671205879,7.9736942432329396,4.5263400399324221,6.8136534671205879,3.8327461915777956,2.9036223695061238]
["Residual Disposal Cost TPD",5.5998924923848774,11.200057186427754,5.6000230379358014,5.5998924923848774,5.5999788820948959,5.600027488470114]
["Total TPD",{"$f":"SUM(B16:B23)","v":56.962103565669238},{"$f":"SUM(C16:C23)","v":74.133724390651068},49.84263574587726,53.080902682908203,50.45563719846897,34.706775770328527]
[]
[]
[null,"Single Stream Small","Dual Stream Small","Single Stream Medium","Dual Stream Medium","Single Stream Large","Dual Stream Large"]
["Single vs Dual Stream",1,2,1,2,1,2]
[null,22324,10492,52088,22324,104177,65482]
["Tonnes TPD",{"$f":"B29/'MRF Labor Requirements'!$B$20","v":101.47272727272727},{"$f":"C29/'MRF Labor Requirements'!$B$20","v":47.690909090909088},{"$f":"D29/'MRF Labor Requirements'!$B$20","v":236.76363636363635},{"$f":"E29/'MRF Labor Requirements'!$B$20","v":101.47272727272727},{"$f":"F29/'MRF Labor Requirements'!$B$20","v":473.53181818181821},{"$f":"G29/'MRF Labor Requirements'!$B$20","v":297.64545454545453}]
["Tonnes Threshold ",20000,10000,50000,20000,105000,65000]
["Building Cost TPD",5168000,2842400,6460000,5168000,13566000,8010400]
["Equipment Cost TPD",4050000,2400000,9300000,3250000,17600000,6750000]
["Rolling Stock TPD",170000,170000,300000,265000,565000,335000]
["Labor Cost TPD"]
["Building Insurance Cost TPD",10000,8000,20000,10000,30000,30000]
["Taxes TPD",152108,83660,235768,152108,399284,190135]
["Residual Disposal Cost TPD",125012,117511,291694,125012,583389,366701]

{"sheet":"Sheet1","index":12,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,10,100,500]
["Manager",1,1,1]
["Foreman/Operator",1,1.5,3.5]
["Sorters",1.5,19,70]
["Maintenance",1,1.5,4]
["other (rolling stock operators, clean up staff etc)",0,4.5,11]
["Administrative (scale monitors, book keepers)",0,1.5,2.5]
["Total Number of Employees",{"$f":"SUM(B2:B7)","v":4.5},{"$f":"SUM(C2:C7)","v":29},92]
[]
[]
["Marginal Manager Per Tonne",0]
["Marginal Foreman/Operator Per Tonne",{"$f":"(C3-B3)/90","v":5.5555555555555558E-3}]
["Marginal Sorter Per Tonne",{"$f":"(C4-B4)/90","v":0.19444444444444445}]
["Marginal Maintenance Per Tonne",{"$f":"(C5-B5)/90","v":5.5555555555555558E-3}]
["Marginal other (rolling stock operators, clean up staff etc)",0.05]
["Marginal Administrative (scale monitors, book keepers)",1.6666666666666666E-2]
[]
[]
[]
[]
["Dual Stream Small","Picture 1"]
["Dual Stream Medium","Picture 2"]
["Dual Stream Large","Picture 3"]
["Single Stream Small","Picture 4"]
["Single Stream Medium","Picture 5"]
["Single Stream Large","Picture 6"]
[]
["Single","Picture 8"]
["Dual","Picture 7"]

{"sheet":"Sheet2","index":13,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Trommel: A trommel is used to remove grit and broken glass from recyclables before they enter the sorting room"]
[]
["Balers: Recycling balers are used to compact recyclables such as aluminum, cardboard, paper, and plastic into blocks which can easily be stacked and transported. The blocks of recyclables that come "]
["into blocks which can easily be stacked and transported. The blocks of recyclables that come out of balers vary in size and weight depending on how big of a baler you have. There are many "]
["different kinds of balers, but balers used specifically for recyclables are usually called “vertical” balers. "]
[]
["Eddy Current:  Electric currents induced within conductors by a changing magnetic field in the conductor. Allows for separation of aluminum products in a recycling facility"]
[]
["Ferrous Magnet: Magnet used to separate out ferrous metals (i.e. steel) in a material recovery facility"]

{"sheet":"Cost Curves Single Stream","index":14,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[5000,138.14210356566926,null,null,5000,155.31372439065109]
[15000,100.19210356566924,null,null,15000,96.310902682908221]
[25000,84.492635745877266,null,null,25000,87.730902682908194]
[35000,81.522635745877281,null,null,35000,84.760902682908196]
[45000,82.33,null,null,45000,85.567569349574882]
[55000,80.832635745877269,null,null,55000,84.070902682908184]
[65000,79.111097284338811,null,null,65000,63.975237308790064]
[75000,78.706635745877264,null,null,75000,63.570775770328531]
[85000,79.232047510583158,null,null,85000,64.096187535034417]
[95000,78.691583114298325,null,null,95000,63.555723138749578]
[105000,78.294874551847414,null,null,105000,62.882490056042819]
[115000,78.462593720208105,null,null,115000,62.713732292067661]
[125000,78.730037198468963,null,null,125000,62.981175770328527]
[135000,78.432303865135651,null,null,135000,62.683442436995193]
[145000,77.92,null,null,145000,62.256086115156116]
[155000,78.275637198468971,null,null,155000,62.171291899360774]
[165000,78.071922912754687,null,null,165000,62.526775770328513]
[175000,77.997258820090593,null,null,175000,62.323061484614236]
[185000,77.600252583084369,null,null,185000,62.248397391950149]
[195000,78.09313719846898,null,null,195000,61.851391154943926]
[205000,77.901978661883618,null,null,205000,62.153117233743153]
[]
[{"$f":"MIN(B1:B21)","v":77.600252583084369},null,null,null,null,{"$f":"MIN(F1:F21)","v":61.851391154943926}]