{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Collection Program","XStation Tribal Hauling","XStation Contract Hauling","Outside Landfill","Tribal Landfill","Key"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":72,"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":"Collection Program","index":0,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":false,"merged":[[56,3,56,4],[52,0,52,1],[54,0,54,1],[56,0,56,1],[58,0,58,1],[0,0,0,4],[58,3,58,4],[4,0,4,4],[1,0,1,4],[52,3,52,4],[50,0,50,4],[5,1,5,3],[43,1,43,3],[3,0,3,4],[13,0,13,4],[41,0,41,4],[54,3,54,4]]}
["Tribal-Run Collection Program"]
[{"$f":"Key!A$143","v":"This worksheet is for tribes that want to determine how much it would cost to self-haul waste to a landfill or transfer station (Pages 6-9).  Only enter values in the gray colored areas.   * are required fields."}]
[]
[{"$f":"Key!A$7","v":"Step 1: Determine what the tribe currently pays for waste collection"}]
[{"$f":"Key!A$17","v":"These calculations only include costs that the tribal government currently pays for rather than what residents, businesses, or other generators may be paying for."}]
[{"$f":"Key!B$2","v":"How does the tribe pay for the waste collection?  "},"by Household/Business Units"]
[{"$f":"Key!$A$14","v":"Item"},null,null,{"$f":"Key!A$15","v":"Total cost per year"},{"$f":"Key!A$16","v":"% of total annual costs"}]
[{"$f":"Key!$A18","v":"* Number of tribal HOUSEHOLDs or residential units within the service area"},"A1"]
[{"$f":"Key!A$20","v":"* Number of offices, BUSINESSes, and government facilities (such as schools and hospitals) within the service area"},"A2"]
[{"$f":"IF(B$6=Key!$C$3, Key!A22, IF(B$6=Key!$C$4, Key!A24,Key!A19))","v":"* Current monthly waste hauling/disposal cost to the tribal government per HOUSEHOLD"},"A3",null,{"$f":"IF(B$6=Key!$C$2,IF(OR(C8=\"\",C10=\"\"),\"\",C8*C10*12),\"\")","v":""},{"$f":"IF(OR(D10=\"\",D$12=0),\"\",D10/D$12)","v":""}]
[{"$f":"IF(B$6=Key!$C$3, Key!A23, IF(B$6=Key!$C$4,Key!A25,Key!A21))","v":"* Current monthly waste hauling/disposal cost to the tribal government per BUSINESS"},"A4",null,{"$f":"IF(B$6=Key!$C$2,IF(OR(C9=\"\",C11=\"\"),\"\",12*C9*C11),IF(OR(C10=\"\",C11=\"\"),\"\",12*C10*C11))","v":""},{"$f":"IF(OR(D11=\"\",D$12=0),\"\",D11/D$12)","v":""}]
[{"$f":"Key!A$26","v":"Total yearly cost of current system to the tribe"},"A",{"$f":"IF(D12=\"\",\"\", IF(B$6=Key!$C$2,12*(C8*C10+C9*C11),12*C10*C11))","v":""},{"$f":"IF(COUNTIF(D8:D11,\"\")=ROW(A12)-ROW(A7)-1,\"\",SUM(D8:D11))","v":""},{"$f":"IF(OR(D12=\"\",D12=0),\"\",SUM(E8:E11))","v":""}]
[]
[{"$f":"Key!A$8","v":"Step 2: Determine what a tribally-owned collection system would cost"}]
[]
[{"$f":"Key!A30","v":"* Number of curbside bins needed"},"B1",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A31","v":"* Cost per curbside bin"},"B2",null,{"$f":"IF(OR(C16=\"\",C17=\"\"),\"\", C16*C17)","v":""},{"$f":"IF(OR(D17=\"\",D$25=0),\"\",D17/D$25)","v":""},null,1]
[{"$f":"Key!A32","v":"* Number of community dumpsters or roll-off bins needed"},"B3",null,null,null,null,{"$f":"2","v":2}]
[{"$f":"Key!A33","v":"* Cost per community dumpster or roll-off bin"},"B4",null,{"$f":"IF(OR(C18=\"\",C19=\"\"),\"\", C18*C19)","v":""},{"$f":"IF(OR(D19=\"\",D$25=0),\"\",D19/D$25)","v":""},null,2]
[{"$f":"Key!A34","v":"Number of additional collection vehicles needed"},"B5",null,null,null,null,{"$f":"3","v":3}]
[{"$f":"Key!A35","v":"Cost per collection vehicle"},"B6",null,{"$f":"IF(OR(C20=\"\",C21=\"\"),\"\", C20*C21)","v":""},{"$f":"IF(OR(D21=\"\",D$25=0),\"\",D21/D$25)","v":""},null,3]
[{"$f":"Key!A36","v":"* Other equipment or overhead costs (include costs of planning)"},"B7",null,{"$f":"IF(C22=\"\",\"\",C22)","v":""},{"$f":"IF(OR(D22=\"\",D$25=0),\"\",D22/D$25)","v":""}]
[{"$f":"Key!A150","v":"Cost to plan, design, and construct the reuse center"},"B8",null,{"$f":"IF(C23=\"\",\"\",C23)","v":""},{"$f":"IF(OR(D23=\"\",D$25=0),\"\",D23/D$25)","v":""}]
[{"$f":"Key!A$39","v":"GRANT received"},"B9",null,{"$f":"IF(C24=\"\",\"\",-C24)","v":""},{"$f":"IF(OR(D24=\"\",D$25=0),\"\",D24/D$25)","v":""}]
[{"$f":"Key!A41","v":"Total Initial Cost"},"B",{"$f":"IF(D25=\"\",\"\",C16*C17+C18*C19+C20*C21+C22+C23-C24)","v":""},{"$f":"IF(COUNTIF(D16:D24,\"\")=ROW(A25)-ROW(A15)-1,\"\",SUM(D16:D24))","v":""},{"$f":"IF(OR(D25=\"\",D25=0),\"\",SUM(E16:E24))","v":""}]
[]
[{"$f":"Key!A22","v":"* Number of tons disposed per month"},"C1",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A43","v":"* Landfill tipping fee per ton"},"C2",null,{"$f":"IF(OR(C27=\"\",C28=\"\"),\"\", 12*C27*C28)","v":""},{"$f":"IF(OR(D28=\"\",D$40=0),\"\",D28/D$40)","v":""},null,1]
[{"$f":"Key!A44","v":"* Miles the collection vehicle will travel per week"},"C3",null,null,null,null,{"$f":"2","v":2}]
[{"$f":"Key!A45","v":"* Gas mileage of collection vehicle (mile/gallon)"},"C4",null,null,null,null,2]
[{"$f":"Key!A46","v":"* Gas price per gallon (=> Total cost of gas per year)"},"C5",null,{"$f":"IF(OR(C29=\"\",C30=\"\",C31=\"\",C30=0),\"\",C29/C30*C31*52)","v":""},{"$f":"IF(OR(D31=\"\",D$40=0),\"\",D31/D$40)","v":""},null,2]
[{"$f":"Key!A51","v":"* Administrative staff hours needed per week"},"C6",null,null,null,null,{"$f":"3","v":3}]
[{"$f":"Key!A52","v":"* Cost per hour administrative staff time (salary + benefits)"},"C7",null,{"$f":"IF(OR(C32=\"\",C33=\"\"),\"\", 52*C32*C33)","v":""},{"$f":"IF(OR(D33=\"\",D$40=0),\"\",D33/D$40)","v":""},null,3]
[{"$f":"Key!A53","v":"* Solid waste technician/hauler hours needed per week"},"C8",null,null,null,null,{"$f":"4","v":4}]
[{"$f":"Key!A54","v":"* Cost per hour solid waste technician/hauler (salary + benefits)"},"C9",null,{"$f":"IF(OR(C34=\"\",C35=\"\"),\"\", 52*C34*C35)","v":""},{"$f":"IF(OR(D35=\"\",D$40=0),\"\",D35/D$40)","v":""},null,4]
[{"$f":"Key!A55","v":"Cost per year of Staff Training"},"C10",null,{"$f":"IF(C36=\"\",\"\",C36)","v":""},""]
[{"$f":"Key!A48","v":"* Cost per year of collection vehicle maintenance, repairs and insurance"},"C11",null,{"$f":"IF(C37=\"\",\"\",C37)","v":""},""]
[{"$f":"Key!A49","v":"Contingency cost per year (replacement costs for equipment, contamination cleanup, etc.)"},"C12",null,"",""]
[{"$f":"Key!A57","v":"Other costs per year (include any annual capital costs related to depreciation of vehicles and equipment, and any state taxes for road use)"},"C13",null,"",""]
[{"$f":"Key!A$70","v":"Total operating cost per year"},"C",{"$f":"IF(D40=\"\",\"\",IF(C30=0,12*C27*C28+52*(C32*C33+C34*C35)+SUM(C36:C39),12*C27*C28+52*(C29/C30*C31+C32*C33+C34*C35)+SUM(C36:C39)))","v":""},{"$f":"IF(COUNTIF(D27:D39,\"\")=ROW(A40)-ROW(A26)-1,\"\",SUM(D27:D39))","v":""},{"$f":"IF(OR(D40=\"\",D40=0),\"\",SUM(E27:E39))","v":""}]
[]
[{"$f":"Key!A$9","v":"Step 3: Include User Fees"}]
[]
[{"$f":"Key!B$5","v":"How does the tribe charge the user?  "},"by Monthly Fee"]
[{"$f":"IF(B44=Key!$C$5,Key!A$73,Key!A$75)","v":"* Monthly fee charged to HOUSEHOLDs for use (if any)"},"D1",null,{"$f":"IF(B44=Key!$C$5,IF(OR(C45=\"\",C8=\"\"),\"\",12*C45*C$8),\"\")","v":""},{"$f":"IF(OR(D45=\"\",D$49=0),\"\",D45/D$49)","v":""}]
[{"$f":"IF(B44=Key!$C$5,Key!A$74,Key!A$76)","v":"* Monthly fee charged to tribal BUSINESSes for use (if any)"},"D2",null,{"$f":"IF(B44=Key!$C$5,IF(OR(C46=\"\",C9=\"\"),\"\",12*C46*C$9),IF(OR(C45=\"\",C46=\"\"),\"\",12*C45*C46))","v":""},{"$f":"IF(OR(D46=\"\",D$49=0),\"\",D46/D$49)","v":""}]
[{"$f":"Key!A$78","v":"* Yearly revenue from selling recyclable materials"},"D3",null,{"$f":"IF(C47=\"\",\"\",C47)","v":""},""]
[{"$f":"Key!A151","v":"Yearly revenue from selling reuse materials"},"D4",null,{"$f":"IF(C48=\"\",\"\",C48)","v":""},{"$f":"IF(OR(D48=\"\",D$49=0),\"\",D48/D$49)","v":""}]
[{"$f":"Key!A$79","v":"Total yearly revenue from collection program"},"D",{"$f":"IF(D49=\"\",\"\",IF(B44=Key!$C$5,12*(C45*C$8+C46*C$9)+C47+C48,12*C45*C46+C47+C48))","v":""},{"$f":"IF(COUNTIF(D45:D48,\"\")=ROW(A49)-ROW(A44)-1,\"\",SUM(D45:D48))","v":""},{"$f":"IF(OR(D49=\"\",D49=0),\"\",SUM(E45:E47))","v":""}]
[]
[{"$f":"Key!A$10","v":"Step 4: Determine if/when the new collection system will “break even” with what the tribe pays currently"},null,null,null,null,null,{"$f":"5","v":5}]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$83","v":"Payback period (in years) with no fee charged and no recycling revenue"},null,null,{"$f":"Key!A$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$84","v":"Payback period (in years) with no fee charged but with RECYCLING REVENUE"},null,null,{"$f":"Key!A$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$85","v":"Payback period (in years) with FEE CHARGED but without recycling revenue"},null,null,{"$f":"Key!A$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$86","v":"Payback period (in years) with FEE CHARGED and RECYCLING REVENUE"},null,null,{"$f":"Key!A$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,{"$f":"IF(OR(C$21=\"\",C$12=\"\",C$49=\"\",D$53=\"\",D$54=\"\"),\"\",IF((D$53+D$54+C$12-C$49)<=0,-1,C$21/(D$53+D$54+C$12-C$49)))","v":""}]
[]
[null,null,{"$f":"IF(OR(C$21=\"\",C$12=\"\",C$49=\"\",C$56=\"\"),\"\",IF((C$56+C$12-C$49)<=0,-1,C$21/(C$56+C$12-C$49)))","v":""}]

{"sheet":"XStation Tribal Hauling","index":1,"n_rows":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":false,"merged":[[66,0,66,1],[73,3,73,4],[68,0,68,4],[70,3,70,4],[1,0,1,4],[60,3,60,4],[66,3,66,4],[64,3,64,4],[62,3,62,4],[60,0,60,1],[62,0,62,1],[64,0,64,1],[0,0,0,4],[3,0,3,4],[13,0,13,4],[58,0,58,4],[49,0,49,4],[5,1,5,3],[51,1,51,3],[4,0,4,4]]}
["Tribal-Owned XStation with Tribal Hauling Option"]
[{"$f":"Key!A$144","v":"This worksheet is for tribes that want to determine how much it would cost to self-haul waste to a landfill from their own transfer station (Pages 16-20).  Only enter values in the gray colored areas.   * are required fields."}]
[]
[{"$f":"Key!A$7","v":"Step 1: Determine what the tribe currently pays for waste collection"}]
[{"$f":"Key!A$17","v":"These calculations only include costs that the tribal government currently pays for rather than what residents, businesses, or other generators may be paying for."}]
[{"$f":"Key!B$2","v":"How does the tribe pay for the waste collection?  "},"by Waste Weight"]
[{"$f":"Key!$A$14","v":"Item"},null,null,{"$f":"Key!A$15","v":"Total cost per year"},{"$f":"Key!A$16","v":"% of total annual costs"}]
[{"$f":"Key!$A18","v":"* Number of tribal HOUSEHOLDs or residential units within the service area"},"A1"]
[{"$f":"Key!A$20","v":"* Number of offices, BUSINESSes, and government facilities (such as schools and hospitals) within the service area"},"A2"]
[{"$f":"IF(B$6=Key!$C$3, Key!A22, IF(B$6=Key!$C$4, Key!A24,Key!A19))","v":"* Number of tons disposed per month"},"A3",null,{"$f":"IF(B$6=Key!$C$2,IF(OR(C8=\"\",C10=\"\"),\"\",C8*C10*12),\"\")","v":""},{"$f":"IF(OR(D10=\"\",D$12=0),\"\",D10/D$12)","v":""}]
[{"$f":"IF(B$6=Key!$C$3, Key!A23, IF(B$6=Key!$C$4,Key!A25,Key!A21))","v":"* Hauling/disposal cost per ton to the tribal government"},"A4",null,{"$f":"IF(B$6=Key!$C$2,IF(OR(C9=\"\",C11=\"\"),\"\",12*C9*C11),IF(OR(C10=\"\",C11=\"\"),\"\",12*C10*C11))","v":""},{"$f":"IF(OR(D11=\"\",D$12=0),\"\",D11/D$12)","v":""}]
[{"$f":"Key!A$26","v":"Total yearly cost of current system to the tribe"},"A",{"$f":"IF(D12=\"\",\"\", IF(B$6=Key!$C$2,12*(C8*C10+C9*C11),12*C10*C11))","v":""},{"$f":"IF(COUNTIF(D8:D11,\"\")=ROW(A12)-ROW(A7)-1,\"\",SUM(D8:D11))","v":""},{"$f":"IF(OR(D12=\"\",D12=0),\"\",SUM(E8:E11))","v":""}]
[]
[{"$f":"Key!A$11","v":"Step 2: Determine what a tribally-owned transfer station would cost"}]
[]
[{"$f":"Key!A28","v":"Option1: Tribal Hauling"},null,null,{"$f":"Key!A$15","v":"Total cost per year"},{"$f":"Key!A$16","v":"% of total annual costs"}]
[{"$f":"Key!A37","v":"* Cost to plan, design, and construct the transfer station"},"B1",null,{"$f":"IF(C17=\"\",\"\",C17)","v":""},{"$f":"IF(OR(D17=\"\",D$24=0),\"\",D17/D$24)","v":""}]
[{"$f":"Key!A38","v":"* Cost of other equipment needed to run the transfer station"},"B2",null,{"$f":"IF(C18=\"\",\"\",C18)","v":""},{"$f":"IF(OR(D18=\"\",D$24=0),\"\",D18/D$24)","v":""}]
[{"$f":"Key!A34","v":"Number of additional collection vehicles needed"},"B3",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A35","v":"Cost per collection vehicle"},"B4",null,{"$f":"IF(OR(C19=\"\",C20=\"\"),\"\", C19*C20)","v":""},{"$f":"IF(OR(D20=\"\",D$24=0),\"\",D20/D$24)","v":""},null,1]
[{"$f":"Key!A$150","v":"Cost to plan, design, and construct the reuse center"},"B5",null,{"$f":"IF(C21=\"\",\"\",C21)","v":""},{"$f":"IF(OR(D21=\"\",D$24=0),\"\",D21/D$24)","v":""}]
[{"$f":"Key!A$39","v":"GRANT received"},"B6",null,{"$f":"IF(C22=\"\",\"\",-C22)","v":""},""]
[{"$f":"Key!A40","v":"* Life span of transfer station (years)"},"B7",20]
[{"$f":"Key!A41","v":"Total Initial Cost"},"B",{"$f":"IF(D24=\"\",\"\",C17+C18+C19*C20+C21-C22)","v":""},{"$f":"IF(COUNTIF(D17:D23,\"\")=ROW(A24)-ROW(A16)-1,\"\",SUM(D17:D23))","v":""},{"$f":"IF(OR(D24=\"\",D24=0),\"\",SUM(E17:E23))","v":""}]
[]
[{"$f":"Key!A22","v":"* Number of tons disposed per month"},"C1",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A43","v":"* Landfill tipping fee per ton"},"C2",null,{"$f":"IF(OR(C26=\"\",C27=\"\"),\"\",12*C27*C26)","v":""},{"$f":"IF(OR(D27=\"\",D$48=0),\"\",D27/D$48)","v":""},null,1]
[{"$f":"Key!A44","v":"* Miles the collection vehicle will travel per week"},"C3",null,null,null,null,{"$f":"2","v":2}]
[{"$f":"Key!A45","v":"* Gas mileage of collection vehicle (mile/gallon)"},"C4",null,null,null,null,2]
[{"$f":"Key!A46","v":"* Gas price per gallon (=> Total cost of gas per year)"},"C5",null,{"$f":"IF(OR(C28=\"\",C29=\"\",C30=\"\",C29=0),\"\",C28/C29*C30*52)","v":""},{"$f":"IF(OR(D30=\"\",D$48=0),\"\",D30/D$48)","v":""},null,2]
[{"$f":"Key!A51","v":"* Administrative staff hours needed per week"},"C6",null,null,null,null,{"$f":"3","v":3}]
[{"$f":"Key!A52","v":"* Cost per hour administrative staff time (salary + benefits)"},"C7",null,{"$f":"IF(OR(C31=\"\",C32=\"\"),\"\",C32*C31*52)","v":""},{"$f":"IF(OR(D32=\"\",D$48=0),\"\",D32/D$48)","v":""},null,3]
[{"$f":"Key!A53","v":"* Solid waste technician/hauler hours needed per week"},"C8",null,null,null,null,{"$f":"4","v":4}]
[{"$f":"Key!A54","v":"* Cost per hour solid waste technician/hauler (salary + benefits)"},"C9",null,{"$f":"IF(OR(C33=\"\",C34=\"\"),\"\",C34*C33*52)","v":""},{"$f":"IF(OR(D34=\"\",D$48=0),\"\",D34/D$48)","v":""},null,4]
[{"$f":"Key!A55","v":"Cost per year of Staff Training"},"C10",null,{"$f":"IF(C35=\"\",\"\",C35)","v":""},""]
[{"$f":"Key!A61","v":"Cost per year of Rent/Property Tax"},"C11",null,{"$f":"IF(C36=\"\",\"\",C36)","v":""},""]
[{"$f":"Key!A62","v":"Cost per year of Property Insurance"},"C12",null,"",""]
[{"$f":"Key!A63","v":"Cost per year of Gas/Heating"},"C13",null,"",""]
[{"$f":"Key!A64","v":"Cost per year of Electricity"},"C14",null,"",""]
[{"$f":"Key!A65","v":"Cost per year of Water"},"C15",null,"",""]
[{"$f":"Key!A66","v":"Cost per year of Telephone/Internet"},"C16",null,"",""]
[{"$f":"Key!A67","v":"Cost per year of Office Supplies"},"C17",null,"",""]
[{"$f":"Key!A68","v":"Cost per year of Janitorial Supplies"},"C18",null,"",""]
[{"$f":"Key!A69","v":"* Cost per year of Equipment Repair & Maintenance"},"C19",null,"",""]
[{"$f":"Key!A48","v":"* Cost per year of collection vehicle maintenance, repairs and insurance"},"C20",null,"",""]
[{"$f":"Key!A50","v":"Contingency cost per year (replacement costs for equipment, contamination cleanup, closure and post-closure monitoring, expansion of facilities, etc.)"},"C21",null,"",""]
[{"$f":"Key!A57","v":"Other costs per year (include any annual capital costs related to depreciation of vehicles and equipment, and any state taxes for road use)"},"C22",null,"",""]
[{"$f":"Key!A$70","v":"Total operating cost per year"},"C",{"$f":"IF(D48=\"\",\"\",IF(C29=0,12*C27*C26+52*(C31*C32+C33*C34)+SUM(C35:C47),12*C27*C26+52*(C28/C29*C30+C31*C32+C33*C34)+SUM(C35:C47)))","v":""},{"$f":"IF(COUNTIF(D26:D47,\"\")=ROW(A48)-ROW(A25)-1,\"\",SUM(D26:D47))","v":""},{"$f":"IF(OR(D48=\"\",D48=0),\"\",SUM(E26:E47))","v":""}]
[]
[{"$f":"Key!A$9","v":"Step 3: Include User Fees"}]
[]
[{"$f":"Key!B$5","v":"How does the tribe charge the user?  "},"by per Bag Fee"]
[{"$f":"IF(B52=Key!$C$5,Key!A$73,Key!A$75)","v":"* Number of bags collected per month"},"D1",null,{"$f":"IF(B52=Key!$C$5,IF(OR(C53=\"\",C8=\"\"),\"\", 12*C53*C$8),\"\")","v":""},{"$f":"IF(OR(D53=\"\",D$57=0),\"\",D53/D$57)","v":""}]
[{"$f":"IF(B52=Key!$C$5,Key!A$74,Key!A$76)","v":"* Fee charged per bag"},"D2",null,{"$f":"IF(B52=Key!$C$5,IF(OR(C54=\"\",C9=\"\"),\"\",12*C54*C$9),IF(OR(C53=\"\",C54=\"\"),\"\",12*C53*C54))","v":""},{"$f":"IF(OR(D54=\"\",D$57=0),\"\",D54/D$57)","v":""}]
[{"$f":"Key!A$78","v":"* Yearly revenue from selling recyclable materials"},"D3",null,{"$f":"IF(C55=\"\",\"\",C55)","v":""},""]
[{"$f":"Key!A$151","v":"Yearly revenue from selling reuse materials"},"D4",null,{"$f":"IF(C56=\"\",\"\",C56)","v":""},{"$f":"IF(OR(D56=\"\",D$57=0),\"\",D56/D$57)","v":""}]
[{"$f":"Key!A$80","v":"Total yearly revenue from transfer station program"},"D",{"$f":"IF(D57=\"\",\"\",IF(B52=Key!$C$5,12*(C53*C$8+C54*C$9)+C55+C56,12*C53*C54+C55+C56))","v":""},{"$f":"IF(COUNTIF(D53:D56,\"\")=ROW(A57)-ROW(A52)-1,\"\",SUM(D53:D56))","v":""},{"$f":"IF(OR(D57=\"\",D57=0),\"\",SUM(E53:E55))","v":""}]
[]
[{"$f":"Key!A$12","v":"Step 4: Determine if/when the new transfer station will “break even” with what the tribe pays currently"},null,null,null,null,null,{"$f":"5","v":5}]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$83","v":"Payback period (in years) with no fee charged and no recycling revenue"},null,null,{"$f":"Key!A$88","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$84","v":"Payback period (in years) with no fee charged but with RECYCLING REVENUE"},null,null,{"$f":"Key!A$88","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$85","v":"Payback period (in years) with FEE CHARGED but without recycling revenue"},null,null,{"$f":"Key!A$88","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$86","v":"Payback period (in years) with FEE CHARGED and RECYCLING REVENUE"},null,null,{"$f":"Key!A$88","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$13","v":"Step 5: Determine if building a transfer station will be cost effective based on the distances traveled"},null,null,null,null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$94","v":"Cost per ton to build, own, and operate transfer station whose lifespan is 20 years"},"E1",null,{"$f":"Key!A$99","v":"This number is calculated using data above, do not enter data here"},null,null,5]
[{"$f":"Key!A$95","v":"* Average payload (tons) of collection truck hauling directly to the landfill"},"E2",null,null,null,null,5]
[{"$f":"Key!A$96","v":"* Average payload (tons) of transfer truck hauling from transfer station to landfill"},"E3",null,null,null,null,5]
[{"$f":"Key!A$97","v":"Average trucking cost per mile driven (direct or transfer hauling, including the costs of hauler salary, gas and vehicle maintenance)"},"E4",null,{"$f":"Key!A$99","v":"This number is calculated using data above, do not enter data here"},null,null,5]
[{"$f":"Key!A$98","v":"“Break-even” hauling distance in miles (from Waste Source to Landfill)"},"E",null,null,null,null,5]

{"sheet":"XStation Contract Hauling","index":2,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,0,4],[51,0,51,4],[13,0,13,4],[42,0,42,4],[3,0,3,4],[4,0,4,4],[55,3,55,4],[57,3,57,4],[1,0,1,4],[59,3,59,4],[53,3,53,4],[44,1,44,3],[5,1,5,3],[53,0,53,1],[55,0,55,1],[57,0,57,1],[59,0,59,1]]}
["Tribal-Owned XStation with Contract Hauling Option"]
[{"$f":"Key!A$145","v":"This worksheet is for tribes that want to determine how much it would cost to contract waste-hauling to a landfill from their own transfer station (Pages 16-20).  Only enter values in the gray colored areas.   * are required fields."}]
[]
[{"$f":"Key!A$7","v":"Step 1: Determine what the tribe currently pays for waste collection"}]
[{"$f":"Key!A$17","v":"These calculations only include costs that the tribal government currently pays for rather than what residents, businesses, or other generators may be paying for."}]
[{"$f":"Key!B$2","v":"How does the tribe pay for the waste collection?  "},"by Waste Weight"]
[{"$f":"Key!$A$14","v":"Item"},null,null,{"$f":"Key!A$15","v":"Total cost per year"},{"$f":"Key!A$16","v":"% of total annual costs"}]
[{"$f":"Key!$A18","v":"* Number of tribal HOUSEHOLDs or residential units within the service area"},"A1"]
[{"$f":"Key!A$20","v":"* Number of offices, BUSINESSes, and government facilities (such as schools and hospitals) within the service area"},"A2"]
[{"$f":"IF(B$6=Key!$C$3, Key!A22, IF(B$6=Key!$C$4, Key!A24,Key!A19))","v":"* Number of tons disposed per month"},"A3",null,{"$f":"IF(B$6=Key!$C$2,IF(OR(C8=\"\",C10=\"\"),\"\",C8*C10*12),\"\")","v":""},{"$f":"IF(OR(D10=\"\",D$12=0),\"\",D10/D$12)","v":""}]
[{"$f":"IF(B$6=Key!$C$3, Key!A23, IF(B$6=Key!$C$4,Key!A25,Key!A21))","v":"* Hauling/disposal cost per ton to the tribal government"},"A4",null,{"$f":"IF(B$6=Key!$C$2,IF(OR(C9=\"\",C11=\"\"),\"\",12*C9*C11),IF(OR(C10=\"\",C11=\"\"),\"\",12*C10*C11))","v":""},{"$f":"IF(OR(D11=\"\",D$12=0),\"\",D11/D$12)","v":""}]
[{"$f":"Key!A$26","v":"Total yearly cost of current system to the tribe"},"A",{"$f":"IF(D12=\"\",\"\", IF(B$6=Key!$C$2,12*(C8*C10+C9*C11),12*C10*C11))","v":""},{"$f":"IF(COUNTIF(D8:D11,\"\")=ROW(A12)-ROW(A7)-1,\"\",SUM(D8:D11))","v":""},{"$f":"IF(OR(D12=\"\",D12=0),\"\",SUM(E8:E11))","v":""}]
[]
[{"$f":"Key!A$11","v":"Step 2: Determine what a tribally-owned transfer station would cost"}]
[]
[{"$f":"Key!A29","v":"Option 2: Contract Hauling"},null,null,{"$f":"Key!A$15","v":"Total cost per year"},{"$f":"Key!A$16","v":"% of total annual costs"}]
[{"$f":"Key!A37","v":"* Cost to plan, design, and construct the transfer station"},"B1",null,{"$f":"IF(C17=\"\",\"\",C17)","v":""},{"$f":"IF(OR(D17=\"\",D$22=0),\"\",D17/D$22)","v":""}]
[{"$f":"Key!A38","v":"* Cost of other equipment needed to run the transfer station"},"B2",null,{"$f":"IF(C18=\"\",\"\",C18)","v":""},{"$f":"IF(OR(D18=\"\",D$22=0),\"\",D18/D$22)","v":""}]
[{"$f":"Key!A$150","v":"Cost to plan, design, and construct the reuse center"},"B3",null,{"$f":"IF(C19=\"\",\"\",C19)","v":""},{"$f":"IF(OR(D19=\"\",D$22=0),\"\",D19/D$22)","v":""}]
[{"$f":"Key!A$39","v":"GRANT received"},"B4",null,{"$f":"IF(C20=\"\",\"\",-C20)","v":""},""]
[{"$f":"Key!A40","v":"* Life span of transfer station (years)"},"B5",20]
[{"$f":"Key!A41","v":"Total Initial Cost"},"B",{"$f":"IF(D22=\"\",\"\",C17+C18+C19-C20)","v":""},{"$f":"IF(COUNTIF(D17:D21,\"\")=ROW(A22)-ROW(A16)-1,\"\",SUM(D17:D21))","v":""},{"$f":"IF(OR(D22=\"\",D22=0),\"\",SUM(E17:E21))","v":""}]
[]
[{"$f":"Key!A58","v":"* Cost per month of contract hauling and disposal"},"C1",null,{"$f":"IF(C24=\"\",\"\",C24*12)","v":""},{"$f":"IF(OR(D24=\"\",D$41=0),\"\",D24/D$41)","v":""}]
[{"$f":"Key!A51","v":"* Administrative staff hours needed per week"},"C2",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A52","v":"* Cost per hour administrative staff time (salary + benefits)"},"C3",null,{"$f":"IF(OR(C25=\"\",C26=\"\"),\"\",C26*C25*52)","v":""},{"$f":"IF(OR(D26=\"\",D$41=0),\"\",D26/D$41)","v":""},null,1]
[{"$f":"Key!A59","v":"* Solid waste technician hours needed per week"},"C4",null,null,null,null,{"$f":"2","v":2}]
[{"$f":"Key!A60","v":"* Cost per hour solid waste technician (salary + benefits)"},"C5",null,{"$f":"IF(OR(C27=\"\",C28=\"\"),\"\",C28*C27*52)","v":""},{"$f":"IF(OR(D28=\"\",D$41=0),\"\",D28/D$41)","v":""},null,2]
[{"$f":"Key!A55","v":"Cost per year of Staff Training"},"C6",null,{"$f":"IF(C29=\"\",\"\",C29)","v":""},""]
[{"$f":"Key!A61","v":"Cost per year of Rent/Property Tax"},"C7",null,"",""]
[{"$f":"Key!A62","v":"Cost per year of Property Insurance"},"C8",null,"",""]
[{"$f":"Key!A63","v":"Cost per year of Gas/Heating"},"C9",null,"",""]
[{"$f":"Key!A64","v":"Cost per year of Electricity"},"C10",null,"",""]
[{"$f":"Key!A65","v":"Cost per year of Water"},"C11",null,"",""]
[{"$f":"Key!A66","v":"Cost per year of Telephone/Internet"},"C12",null,"",""]
[{"$f":"Key!A67","v":"Cost per year of Office Supplies"},"C13",null,"",""]
[{"$f":"Key!A68","v":"Cost per year of Janitorial Supplies"},"C14",null,"",""]
[{"$f":"Key!A69","v":"* Cost per year of Equipment Repair & Maintenance"},"C15",null,"",""]
[{"$f":"Key!A50","v":"Contingency cost per year (replacement costs for equipment, contamination cleanup, closure and post-closure monitoring, expansion of facilities, etc.)"},"C16",null,"",""]
[{"$f":"Key!A57","v":"Other costs per year (include any annual capital costs related to depreciation of vehicles and equipment, and any state taxes for road use)"},"C17",null,"",""]
[{"$f":"Key!A$70","v":"Total operating cost per year"},"C",{"$f":"IF(D41=\"\",\"\",12*C24+52*(C25*C26+C27*C28)+SUM(C29:C40))","v":""},{"$f":"IF(COUNTIF(D24:D40,\"\")=ROW(A41)-ROW(A23)-1,\"\",SUM(D24:D40))","v":""},{"$f":"IF(OR(D41=\"\",D41=0),\"\",SUM(E24:E40))","v":""}]
[]
[{"$f":"Key!A$9","v":"Step 3: Include User Fees"}]
[]
[{"$f":"Key!B$5","v":"How does the tribe charge the user?  "},"by Monthly Fee"]
[{"$f":"IF(B45=Key!$C$5,Key!A$73,Key!A$75)","v":"* Monthly fee charged to HOUSEHOLDs for use (if any)"},"D1",null,{"$f":"IF(B45=Key!$C$5,IF(OR(C46=\"\",C8=\"\"),\"\", 12*C46*C$8),\"\")","v":""},{"$f":"IF(OR(D46=\"\",D$50=0),\"\",D46/D$50)","v":""}]
[{"$f":"IF(B45=Key!$C$5,Key!A$74,Key!A$76)","v":"* Monthly fee charged to tribal BUSINESSes for use (if any)"},"D2",null,{"$f":"IF(B45=Key!$C$5,IF(OR(C47=\"\",C9=\"\"),\"\",12*C47*C$9),IF(OR(C46=\"\",C47=\"\"),\"\",12*C46*C47))","v":""},{"$f":"IF(OR(D47=\"\",D$50=0),\"\",D47/D$50)","v":""}]
[{"$f":"Key!A$78","v":"* Yearly revenue from selling recyclable materials"},"D3",null,{"$f":"IF(C48=\"\",\"\",C48)","v":""},""]
[{"$f":"Key!A$151","v":"Yearly revenue from selling reuse materials"},"D4",null,{"$f":"IF(C49=\"\",\"\",C49)","v":""},{"$f":"IF(OR(D49=\"\",D$50=0),\"\",D49/D$50)","v":""}]
[{"$f":"Key!A$80","v":"Total yearly revenue from transfer station program"},"D",{"$f":"IF(D50=\"\",\"\",IF(B45=Key!$C$5,12*(C46*C$8+C47*C$9)+C48+C49,12*C46*C47+C48+C49))","v":""},{"$f":"IF(COUNTIF(D46:D49,\"\")=ROW(A50)-ROW(A45)-1,\"\",SUM(D46:D49))","v":""},{"$f":"IF(OR(D50=\"\",D50=0),\"\",SUM(E46:E48))","v":""}]
[]
[{"$f":"Key!A$12","v":"Step 4: Determine if/when the new transfer station will “break even” with what the tribe pays currently"},null,null,null,null,null,{"$f":"5","v":5}]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$83","v":"Payback period (in years) with no fee charged and no recycling revenue"},null,null,{"$f":"Key!A$89","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$84","v":"Payback period (in years) with no fee charged but with RECYCLING REVENUE"},null,null,{"$f":"Key!A$89","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$85","v":"Payback period (in years) with FEE CHARGED but without recycling revenue"},null,null,{"$f":"Key!A$89","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$86","v":"Payback period (in years) with FEE CHARGED and RECYCLING REVENUE"},null,null,{"$f":"Key!A$89","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]

{"sheet":"Outside Landfill","index":3,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[9,0,9,4],[50,3,50,4],[34,0,34,4],[42,0,42,4],[44,3,44,4],[46,3,46,4],[48,3,48,4],[3,0,3,4],[44,0,44,1],[46,0,46,1],[48,0,48,1],[50,0,50,1]]}
["Haul C&D debris to outside landfill"]
[{"$f":"Key!A$146","v":"This worksheet is for tribes that want to determine how much it would cost to haul C&D debris to outside landfill.  Only enter values in the gray colored areas.   * are required fields."}]
[]
[{"$f":"Key!A$103","v":"Step 1: Determine what tribe is willing to subside"}]
[]
[{"$f":"Key!$A$14","v":"Item"},null,null,{"$f":"Key!A$15","v":"Total cost per year"},{"$f":"Key!A$16","v":"% of total annual costs"}]
[{"$f":"Key!A110","v":"* Amount of subsidy per year"},"A1",null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(OR(D7=\"\",D$8=0),\"\",D7/D$8)","v":""}]
[{"$f":"Key!A$111","v":"Total yearly subsidy by the tribe"},"A",{"$f":"IF(D7=\"\",\"\", C7)","v":""},{"$f":"IF(COUNTIF(D7:D7,\"\")=ROW(A8)-ROW(A6)-1,\"\",SUM(D7:D7))","v":""},{"$f":"IF(OR(D8=\"\",D8=0),\"\",SUM(E7:E7))","v":""}]
[]
[{"$f":"Key!A$104","v":"Step 2: Determine the cost to haul C&D debris to outside landfill"}]
[]
[{"$f":"Key!A113","v":"* Number of hauling vehicles needed"},"B1",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A114","v":"* Cost per hauling vehicle"},"B2",null,{"$f":"IF(OR(C12=\"\",C13=\"\"),\"\",C12*C13)","v":""},{"$f":"IF(OR(D13=\"\",D$17=0),\"\",D13/D$17)","v":""},null,1]
[{"$f":"Key!A36","v":"* Other equipment or overhead costs (include costs of planning)"},"B3",null,{"$f":"IF(C14=\"\",\"\",C14)","v":""},{"$f":"IF(OR(D14=\"\",D$17=0),\"\",D14/D$17)","v":""}]
[{"$f":"Key!A$150","v":"Cost to plan, design, and construct the reuse center"},"B4",null,{"$f":"IF(C15=\"\",\"\",C15)","v":""},{"$f":"IF(OR(D15=\"\",D$17=0),\"\",D15/D$17)","v":""}]
[{"$f":"Key!A$39","v":"GRANT received"},"B5",null,{"$f":"IF(C16=\"\",\"\",-C16)","v":""},""]
[{"$f":"Key!A41","v":"Total Initial Cost"},"B",{"$f":"IF(D17=\"\",\"\",C12*C13+C14+C15-C16)","v":""},{"$f":"IF(COUNTIF(D12:D16,\"\")=ROW(A17)-ROW(A11)-1,\"\",SUM(D12:D16))","v":""},{"$f":"IF(OR(D17=\"\",D17=0),\"\",SUM(E12:E16))","v":""}]
[]
[{"$f":"Key!A116","v":"* Number of tons disposed per load"},"C1",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A117","v":"* Number of loads per year"},"C2",null,null,null,null,1]
[{"$f":"Key!A118","v":"* Landfill tipping fee per ton"},"C3",null,{"$f":"IF(OR(C19=\"\",C20=\"\",C21=\"\"),\"\",C21*C20*C19)","v":""},{"$f":"IF(OR(D21=\"\",D$33=0),\"\",D21/D$33)","v":""},null,1]
[{"$f":"Key!A119","v":"* Roundtrip miles to C&D landfill"},"C4",null,null,null,null,{"$f":"2","v":2}]
[{"$f":"Key!A120","v":"* Number of trips to C&D landfill per year"},"C5",null,null,null,null,2]
[{"$f":"Key!A121","v":"* Gas mileage of hauling vehicle (mile/gallon)"},"C6",null,null,null,null,2]
[{"$f":"Key!A122","v":"* Gas price per gallon (=> Total cost of gas per year)"},"C7",null,{"$f":"IF(OR(C22=\"\",C23=\"\",C24=\"\",C25=\"\",C24=0),\"\",C22*C23/C24*C25)","v":""},{"$f":"IF(OR(D25=\"\",D$33=0),\"\",D25/D$33)","v":""},null,2]
[{"$f":"Key!A51","v":"* Administrative staff hours needed per week"},"C8",null,null,null,null,{"$f":"3","v":3}]
[{"$f":"Key!A52","v":"* Cost per hour administrative staff time (salary + benefits)"},"C9",null,{"$f":"IF(OR(C26=\"\",C27=\"\"),\"\",C27*C26*52)","v":""},{"$f":"IF(OR(D27=\"\",D$43=0),\"\",D27/D$43)","v":""},null,3]
[{"$f":"Key!A59","v":"* Solid waste technician hours needed per week"},"C10",null,null,null,null,{"$f":"4","v":4}]
[{"$f":"Key!A60","v":"* Cost per hour solid waste technician (salary + benefits)"},"C11",null,{"$f":"IF(OR(C28=\"\",C29=\"\"),\"\",C29*C28*52)","v":""},{"$f":"IF(OR(D29=\"\",D$43=0),\"\",D29/D$43)","v":""},null,4]
[{"$f":"Key!A55","v":"Cost per year of Staff Training"},"C12",null,{"$f":"IF(C30=\"\",\"\",C30)","v":""},""]
[{"$f":"Key!A125","v":"* Cost per year of hauling vehicle repair and maintenance"},"C13",null,"",""]
[{"$f":"Key!A126","v":"Contingency cost per year (emergency repairs for vehicle, etc.)"},"C14",null,"",""]
[{"$f":"Key!A$70","v":"Total operating cost per year"},"C",{"$f":"IF(D33=\"\",\"\",IF(C24=0,C19*C20*C21+SUM(C30:C32)+(C26*C27+C28*C29)*52,C19*C20*C21+C22*C23/C24*C25+SUM(C30:C32)+(C26*C27+C28*C29)*52))","v":""},{"$f":"IF(COUNTIF(D19:D32,\"\")=ROW(A33)-ROW(A18)-1,\"\",SUM(D19:D32))","v":""},{"$f":"IF(OR(D33=\"\",D33=0),\"\",SUM(E19:E32))","v":""}]
[]
[{"$f":"Key!A$105","v":"Step 3: Include User Fees"}]
[]
[{"$f":"Key!A136","v":"* Number of tons of C&D debris received per year"},"D1"]
[{"$f":"Key!A137","v":"* Fee charged per ton"},"D2",null,{"$f":"IF(OR(C37=\"\",C38=\"\"),\"\",C37*C38)","v":""},{"$f":"IF(OR(D38=\"\",D$41=0),\"\",D38/D$41)","v":""}]
[{"$f":"Key!A138","v":"* Yearly revenue from selling recyclable C&D materials"},"D3",null,{"$f":"IF(C39=\"\",\"\",C39)","v":""},{"$f":"IF(OR(D39=\"\",D$41=0),\"\",D39/D$41)","v":""}]
[{"$f":"Key!A$151","v":"Yearly revenue from selling reuse materials"},"D4",null,{"$f":"IF(C40=\"\",\"\",C40)","v":""},{"$f":"IF(OR(D40=\"\",D$41=0),\"\",D40/D$41)","v":""}]
[{"$f":"Key!A$81","v":"Total yearly revenue from C&D landfill program"},"D",{"$f":"IF(D41=\"\",\"\",C37*C38+C39+C40)","v":""},{"$f":"IF(COUNTIF(D37:D40,\"\")=ROW(A41)-ROW(A36)-1,\"\",SUM(D37:D40))","v":""},{"$f":"IF(OR(D41=\"\",D41=0),\"\",SUM(E37:E39))","v":""}]
[]
[{"$f":"Key!A$107","v":"Step 4: Determine if/when the C&D debris hauling program will “break even”"},null,null,null,null,null,{"$f":"5","v":5}]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$83","v":"Payback period (in years) with no fee charged and no recycling revenue"},null,null,{"$f":"Key!A$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$84","v":"Payback period (in years) with no fee charged but with RECYCLING REVENUE"},null,null,{"$f":"Key!A$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$85","v":"Payback period (in years) with FEE CHARGED but without recycling revenue"},null,null,{"$f":"Key!A$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$86","v":"Payback period (in years) with FEE CHARGED and RECYCLING REVENUE"},null,null,{"$f":"Key!A$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},null,null,5]

{"sheet":"Tribal Landfill","index":4,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[40,3,40,4],[42,3,42,4],[44,3,44,4],[0,0,0,4],[1,0,1,4],[9,0,9,4],[28,0,28,4],[36,0,36,4],[38,3,38,4],[3,0,3,4],[38,0,38,1],[40,0,40,1],[42,0,42,1],[44,0,44,1]]}
["Operate tribally-owned C&D landfill"]
[{"$f":"Key!A$147","v":"This worksheet is for tribes that want to determine how much it would cost to operate a tribally-owned C&D landfill.  Only enter values in the gray colored areas.   * are required fields."}]
[]
[{"$f":"Key!A$103","v":"Step 1: Determine what tribe is willing to subside"}]
[]
[{"$f":"Key!$A$14","v":"Item"},null,null,{"$f":"Key!A$15","v":"Total cost per year"},{"$f":"Key!A$16","v":"% of total annual costs"}]
[{"$f":"Key!A110","v":"* Amount of subsidy per year"},"A1",null,{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(OR(D7=\"\",D$8=0),\"\",D7/D$8)","v":""}]
[{"$f":"Key!A$111","v":"Total yearly subsidy by the tribe"},"A",{"$f":"IF(D7=\"\",\"\", C7)","v":""},{"$f":"IF(COUNTIF(D7:D7,\"\")=ROW(A8)-ROW(A6)-1,\"\",SUM(D7:D7))","v":""},{"$f":"IF(OR(D8=\"\",D8=0),\"\",SUM(E7:E7))","v":""}]
[]
[{"$f":"Key!A$106","v":"Step 2: Determine the cost to operate a tribally-owned C&D landfill"}]
[]
[{"$f":"Key!A129","v":"* Cost to plan, design, and construct the C&D landfill"},"B1",null,{"$f":"IF(C12=\"\",\"\",C12)","v":""},{"$f":"IF(OR(D12=\"\",D$17=0),\"\",D12/D$17)","v":""}]
[{"$f":"Key!A130","v":"* Cost of equipment needed to run the C&D landfill"},"B2",null,"",{"$f":"IF(OR(D13=\"\",D$17=0),\"\",D13/D$17)","v":""}]
[{"$f":"Key!A$150","v":"Cost to plan, design, and construct the reuse center"},"B3",null,{"$f":"IF(C14=\"\",\"\",C14)","v":""},{"$f":"IF(OR(D14=\"\",D$17=0),\"\",D14/D$17)","v":""}]
[{"$f":"Key!A$39","v":"GRANT received"},"B4",null,{"$f":"IF(C15=\"\",\"\",-C15)","v":""},""]
[{"$f":"Key!A131","v":"* Life span of C&D landfill (years)"},"B5",20]
[{"$f":"Key!A41","v":"Total Initial Cost"},"B",{"$f":"IF(D17=\"\",\"\",C12+C13+C14-C15)","v":""},{"$f":"IF(COUNTIF(D12:D16,\"\")=ROW(A17)-ROW(A11)-1,\"\",SUM(D12:D16))","v":""},{"$f":"IF(OR(D17=\"\",D17=0),\"\",SUM(E12:E16))","v":""}]
[]
[{"$f":"Key!A51","v":"* Administrative staff hours needed per week"},"C1",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A52","v":"* Cost per hour administrative staff time (salary + benefits)"},"C2",null,{"$f":"IF(OR(C19=\"\",C20=\"\"),\"\",C20*C19*52)","v":""},{"$f":"IF(OR(D20=\"\",D$42=0),\"\",D20/D$42)","v":""},null,1]
[{"$f":"Key!A59","v":"* Solid waste technician hours needed per week"},"C3",null,null,null,null,{"$f":"2","v":2}]
[{"$f":"Key!A60","v":"* Cost per hour solid waste technician (salary + benefits)"},"C4",null,{"$f":"IF(OR(C21=\"\",C22=\"\"),\"\",C22*C21*52)","v":""},{"$f":"IF(OR(D22=\"\",D$42=0),\"\",D22/D$42)","v":""},null,2]
[{"$f":"Key!A55","v":"Cost per year of Staff Training"},"C5",null,{"$f":"IF(C23=\"\",\"\",C23)","v":""},{"$f":"IF(OR(D23=\"\",D$27=0),\"\",D23/D$27)","v":""}]
[{"$f":"Key!A132","v":"* Cost per year of equipment repair and maintenance"},"C6",null,"",""]
[{"$f":"Key!A133","v":"Cost per year for utilities (if applicable)"},"C7",null,"",""]
[{"$f":"Key!A50","v":"Contingency cost per year (replacement costs for equipment, contamination cleanup, closure and post-closure monitoring, expansion of facilities, etc.)"},"C8",null,"",""]
[{"$f":"Key!A$70","v":"Total operating cost per year"},"C",{"$f":"IF(D27=\"\",\"\",(C19*C20+C21*C22)*52+SUM(C23:C26))","v":""},{"$f":"IF(COUNTIF(D19:D26,\"\")=ROW(A27)-ROW(A18)-1,\"\",SUM(D19:D26))","v":""},{"$f":"IF(OR(D27=\"\",D27=0),\"\",SUM(E19:E26))","v":""}]
[]
[{"$f":"Key!A$105","v":"Step 3: Include User Fees"}]
[]
[{"$f":"Key!A136","v":"* Number of tons of C&D debris received per year"},"D1",null,null,null,null,{"$f":"1","v":1}]
[{"$f":"Key!A137","v":"* Fee charged per ton"},"D2",null,{"$f":"IF(OR(C31=\"\",C32=\"\"),\"\",C31*C32)","v":""},{"$f":"IF(OR(D32=\"\",D$35=0),\"\",D32/D$35)","v":""},null,1]
[{"$f":"Key!A138","v":"* Yearly revenue from selling recyclable C&D materials"},"D3",null,{"$f":"IF(C33=\"\",\"\",C33)","v":""},{"$f":"IF(OR(D33=\"\",D$35=0),\"\",D33/D$35)","v":""}]
[{"$f":"Key!A$151","v":"Yearly revenue from selling reuse materials"},"D4",null,{"$f":"IF(C34=\"\",\"\",C34)","v":""},{"$f":"IF(OR(D34=\"\",D$35=0),\"\",D34/D$35)","v":""}]
[{"$f":"Key!A$81","v":"Total yearly revenue from C&D landfill program"},"D",{"$f":"IF(D35=\"\",\"\",C31*C32+C33+C34)","v":""},{"$f":"IF(COUNTIF(D31:D34,\"\")=ROW(A35)-ROW(A30)-1,\"\",SUM(D31:D34))","v":""},{"$f":"IF(OR(D35=\"\",D35=0),\"\",SUM(E31:E33))","v":""}]
[]
[{"$f":"Key!A$108","v":"Step 4: Determine if/when the new C&D landfill program will “break even”"},null,null,null,null,null,{"$f":"5","v":5}]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$83","v":"Payback period (in years) with no fee charged and no recycling revenue"},null,null,{"$f":"Key!A$90","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$84","v":"Payback period (in years) with no fee charged but with RECYCLING REVENUE"},null,null,{"$f":"Key!A$90","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$85","v":"Payback period (in years) with FEE CHARGED but without recycling revenue"},null,null,{"$f":"Key!A$90","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]
[null,null,null,null,null,null,5]
[{"$f":"Key!A$86","v":"Payback period (in years) with FEE CHARGED and RECYCLING REVENUE"},null,null,{"$f":"Key!A$90","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"},null,null,5]

{"sheet":"Key","index":5,"n_rows":151,"n_cols":8,"rows_kept":151,"cut":false,"hidden":true,"merged":[[0,3,0,4],[0,5,0,6],[0,7,0,8],[16,2,16,3]]}
[null,"transfer station's lifespan ",20,50,null,50,null,46]
["collection system","How does the tribe pay for the waste collection?  ","by Household/Business Units"]
["transfer station",null,"by Waste Weight"]
["Step 2: Determine what a tribally-owned ",null,"by Waste Volume"]
["Step 4: Determine if/when the new ","How does the tribe charge the user?  ","by Monthly Fee"]
[null,null,"by per Bag Fee"]
["Step 1: Determine what the tribe currently pays for waste collection"]
[{"$f":"A4&A2&B8","v":"Step 2: Determine what a tribally-owned collection system would cost"}," would cost"]
["Step 3: Include User Fees"," will “break even” with what the tribe pays currently"]
[{"$f":"A5&A2&B9","v":"Step 4: Determine if/when the new collection system will “break even” with what the tribe pays currently"}]
[{"$f":"A4&A3&B8","v":"Step 2: Determine what a tribally-owned transfer station would cost"}]
[{"$f":"A5&A3&B9","v":"Step 4: Determine if/when the new transfer station will “break even” with what the tribe pays currently"},null,"Max Number Allowed",999999999]
["Step 5: Determine if building a transfer station will be cost effective based on the distances traveled",null,"Min Number Allowed",0]
["Item"]
["Total cost per year"]
["% of total annual costs"]
["These calculations only include costs that the tribal government currently pays for rather than what residents, businesses, or other generators may be paying for.",null,"Conversion of loose waste"]
["* Number of tribal HOUSEHOLDs or residential units within the service area",null,"pound/cubic yard",350]
["* Current monthly waste hauling/disposal cost to the tribal government per HOUSEHOLD",null,"pound/ton",2000]
["* Number of offices, BUSINESSes, and government facilities (such as schools and hospitals) within the service area",null,"ton/cubic yard",{"$f":"D18/D19","v":0.17499999999999999}]
["* Current monthly waste hauling/disposal cost to the tribal government per BUSINESS"]
["* Number of tons disposed per month","Approximate number of tons per day disposed"]
["* Hauling/disposal cost per ton to the tribal government"]
["* Number of cubic yards disposed per month"]
["* Hauling/disposal cost per cubic yard to the tribal government"]
["Total yearly cost of current system to the tribe"]
[]
["Option1: Tribal Hauling"]
["Option 2: Contract Hauling"]
["* Number of curbside bins needed"]
["* Cost per curbside bin"]
["* Number of community dumpsters or roll-off bins needed"]
["* Cost per community dumpster or roll-off bin"]
["Number of additional collection vehicles needed"]
["Cost per collection vehicle"]
["* Other equipment or overhead costs (include costs of planning)","Other equipment or overhead costs (include costs of planning as well as hiring and training staff)"]
["* Cost to plan, design, and construct the transfer station"]
["* Cost of other equipment needed to run the transfer station"]
["GRANT received"]
["* Life span of transfer station (years)"]
["Total Initial Cost"]
[]
["* Landfill tipping fee per ton"]
["* Miles the collection vehicle will travel per week"]
["* Gas mileage of collection vehicle (mile/gallon)"]
["* Gas price per gallon (=> Total cost of gas per year)"]
["Cost of gas per mile"]
["* Cost per year of collection vehicle maintenance, repairs and insurance"]
["Contingency cost per year (replacement costs for equipment, contamination cleanup, etc.)"]
["Contingency cost per year (replacement costs for equipment, contamination cleanup, closure and post-closure monitoring, expansion of facilities, etc.)"]
["* Administrative staff hours needed per week"]
["* Cost per hour administrative staff time (salary + benefits)"]
["* Solid waste technician/hauler hours needed per week"]
["* Cost per hour solid waste technician/hauler (salary + benefits)"]
["Cost per year of Staff Training"]
[]
["Other costs per year (include any annual capital costs related to depreciation of vehicles and equipment, and any state taxes for road use)"]
["* Cost per month of contract hauling and disposal"]
["* Solid waste technician hours needed per week"]
["* Cost per hour solid waste technician (salary + benefits)"]
["Cost per year of Rent/Property Tax"]
["Cost per year of Property Insurance"]
["Cost per year of Gas/Heating"]
["Cost per year of Electricity"]
["Cost per year of Water"]
["Cost per year of Telephone/Internet"]
["Cost per year of Office Supplies"]
["Cost per year of Janitorial Supplies"]
["* Cost per year of Equipment Repair & Maintenance"]
["Total operating cost per year"]
[]
[]
["* Monthly fee charged to HOUSEHOLDs for use (if any)"]
["* Monthly fee charged to tribal BUSINESSes for use (if any)"]
["* Number of bags collected per month"]
["* Fee charged per bag"]
["Yearly revenue, if any, from selling recyclable materials"]
["* Yearly revenue from selling recyclable materials"]
["Total yearly revenue from collection program"]
["Total yearly revenue from transfer station program"]
["Total yearly revenue from C&D landfill program"]
[]
["Payback period (in years) with no fee charged and no recycling revenue"]
["Payback period (in years) with no fee charged but with RECYCLING REVENUE"]
["Payback period (in years) with FEE CHARGED but without recycling revenue"]
["Payback period (in years) with FEE CHARGED and RECYCLING REVENUE"]
[{"$f":"$B$87 & $C$87","v":"(if this number is -1, then the operation will not pay for itself or stay sustainable)"},"(if this number is -1",", then the operation will not pay for itself or stay sustainable)"]
[{"$f":"$B$87 & $B$88 & 'XStation Tribal Hauling'!C23 & $C$88","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"}," or > ",{"$f":"\" years\" & C87","v":" years, then the operation will not pay for itself or stay sustainable)"}]
[{"$f":"$B$87 & $B$88 & 'XStation Contract Hauling'!C21 & $C$88","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"}]
[{"$f":"$B$87 & $B$88 & 'Tribal Landfill'!C16 & $C$88","v":"(if this number is -1 or > 20 years, then the operation will not pay for itself or stay sustainable)"}]
[]
[]
[]
[{"$f":"\"Cost per ton to build, own, and operate transfer station whose lifespan is \" & 'XStation Tribal Hauling'!C23 & \" years\"","v":"Cost per ton to build, own, and operate transfer station whose lifespan is 20 years"}]
["* Average payload (tons) of collection truck hauling directly to the landfill"]
["* Average payload (tons) of transfer truck hauling from transfer station to landfill"]
["Average trucking cost per mile driven (direct or transfer hauling, including the costs of hauler salary, gas and vehicle maintenance)"]
["“Break-even” hauling distance in miles (from Waste Source to Landfill)"]
["This number is calculated using data above, do not enter data here"]
[]
[]
["landfill program"]
["Step 1: Determine what tribe is willing to subside"]
["Step 2: Determine the cost to haul C&D debris to outside landfill"]
["Step 3: Include User Fees"]
["Step 2: Determine the cost to operate a tribally-owned C&D landfill"]
["Step 4: Determine if/when the C&D debris hauling program will “break even”"]
["Step 4: Determine if/when the new C&D landfill program will “break even”"]
[]
["* Amount of subsidy per year"]
["Total yearly subsidy by the tribe"]
[]
["* Number of hauling vehicles needed"]
["* Cost per hauling vehicle"]
[]
["* Number of tons disposed per load"]
["* Number of loads per year"]
["* Landfill tipping fee per ton"]
["* Roundtrip miles to C&D landfill"]
["* Number of trips to C&D landfill per year"]
["* Gas mileage of hauling vehicle (mile/gallon)"]
["* Gas price per gallon (=> Total cost of gas per year)"]
["* Cost per year of worker(s) (salary + benefits)"]
["* Cost per year of staff training"]
["* Cost per year of hauling vehicle repair and maintenance"]
["Contingency cost per year (emergency repairs for vehicle, etc.)"]
[]
[]
["* Cost to plan, design, and construct the C&D landfill"]
["* Cost of equipment needed to run the C&D landfill"]
["* Life span of C&D landfill (years)"]
["* Cost per year of equipment repair and maintenance"]
["Cost per year for utilities (if applicable)"]
[]
[]
["* Number of tons of C&D debris received per year"]
["* Fee charged per ton"]
["* Yearly revenue from selling recyclable C&D materials"]
["* Grants received per year (e.g. GAP, other)"]
[]
[]
[]
["This worksheet is for tribes that want to determine how much it would cost to self-haul waste to a landfill or transfer station (Pages 6-9).  Only enter values in the gray colored areas.   * are required fields."]
["This worksheet is for tribes that want to determine how much it would cost to self-haul waste to a landfill from their own transfer station (Pages 16-20).  Only enter values in the gray colored areas.   * are required fields."]
["This worksheet is for tribes that want to determine how much it would cost to contract waste-hauling to a landfill from their own transfer station (Pages 16-20).  Only enter values in the gray colored areas.   * are required fields."]
["This worksheet is for tribes that want to determine how much it would cost to haul C&D debris to outside landfill.  Only enter values in the gray colored areas.   * are required fields."]
["This worksheet is for tribes that want to determine how much it would cost to operate a tribally-owned C&D landfill.  Only enter values in the gray colored areas.   * are required fields."]
[]
[]
["Cost to plan, design, and construct the reuse center"]
["Yearly revenue from selling reuse materials"]