{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Expenses","Time req'd","Std vars","Tipping fees","scratch"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":118,"comments":1,"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":"Summary","index":0,"n_rows":116,"n_cols":16,"rows_kept":116,"cut":false,"hidden":false,"merged":[[23,2,23,12],[0,12,2,15],[26,2,26,13]]}
["Installer Model: summary",null,null,null,null,null,null,null,null,null,null,null,"Spreadsheet by: David William House, author, The Complete Biogas Handbook. Workshops to learn to become an installer, and the book, available at completebiogas.com"]
["sum",null,null,"Green cells","contain assumptions or assertions which you can change. All other numbers are calculated. No touch non-green cells!"]
[]
[]
[null,"income_total_net","Net income or profit",{"$f":"ROUNDDOWN(sum_income_total_gross-sum_exp_total_summary,-1)","v":2630},"/mo",null,{"$f":"sum_income_total_net*12","v":31560},"/yr",null,"As",null,"Favorability"]
[null,null,null,null,null,null,null,null,null,"Used"," l,a,m,c?","Least","Avg.","Most","Custom","Units"]
[null,"income_digester","Digester/Producer income",{"$f":"sum_incom_perProducersTotal_perMo","v":9487.0500000000011},"/mo",{"$f":"IF(sum_income_total_gross>0,sum_income_digester/sum_income_total_gross,)","v":1},null,"sal_hourly_Owner","Owner hourly $",20]
[null,"income_other","Other Income",{"$f":"0","v":0},"/mo",{"$f":"IF(sum_income_total_gross>0,sum_income_other/sum_income_total_gross,)","v":0},null,"sal_hourly_Employee","Employee hourly $",{"$f":"IF(K8=\"l\",L8,IF(K8=\"a\",M8,IF(K8=\"m\",N8,IF(K8=\"c\",O8,\"!\"))))","v":16},"a",18,16,14,22,"$/hr"]
[null,"income_total_gross","Total income",{"$f":"SUM(D7:D8)","v":9487.0500000000011},"/mo",null,null,"producer_numTotal","Number of producers",15,"c",4,10,30,15,"#"]
[null,null,null,null,null,null,null,"foodWaste_tonsPerWeek","Food waste, tons/wk/prod, avg.",1.4,"a",0.75,1.4,2,null,"tons/wk (wet)"]
[null,"exp_fixed_total_summary","Fixed expenses",{"$f":"exp_fixed_perMo_asSummed","v":3490},"/mo",{"$f":"IF(sum_exp_total_summary>0,sum_exp_fixed_total_summary/sum_exp_total_summary,)","v":0.5096750638919314},null,"biogas_cuFtPerTonWetWeight","Biogas/ton FW, wet weight",3000,"a",2500,3000,3500,null,"ft3/ton (wet)"]
[null,"exp_var_total_summary","Variable expenses",{"$f":"exp_variable_perMo_asSummed*sum_producer_numTotal","v":3357.4999999999995},"/mo",{"$f":"IF(sum_exp_total_summary>0,sum_exp_var_total_summary/sum_exp_total_summary,)","v":0.4903249361080686},null,"biogas_pctMethane","%Methane in biogas",0.65,"a",0.6,0.65,0.75,null,"%"]
[null,"exp_total_summary","Total expenses",{"$f":"SUM(D11:D12)","v":6847.5},"/mo",null,null,"cost_energy_natGasPerTherm","Cost natural gas, per therm",0.4,"a",0.3,0.4,0.5,null,"$/therm"]
[null,null,null,null,null,null,null,"cost_tippingFeesPerTon","Tipping fees, per ton",100,"m",0,50,100,null,"$/ton"]
[null,null,null,null,null,null,null,"digester_buildFromKitsOrParts","Build digesters from kits or parts?",{"$f":"IF(K15=\"l\",L15,IF(K15=\"a\",M15,IF(K15=\"m\",N15,IF(K15=\"c\",O15,\"!\"))))","v":"kits"},"a","kits","kits","parts","parts"]
[null,null,null,null,null,null,null,null,null,null,"type in one of the four letters (l,a,m,c) to change"]
[null,null,null,null,null,null,null,null,null,null,"the value in a given row for the col just above"]
[null,null,"Monthly charges, per producer",null,null,null,null,null,"Biogas produced/producer (possibly)"]
[null,"producerCharge_total_perMo","Producer pays, total",{"$f":"SUM(D20:D21)","v":632.47},"/mo",null,null,"biogas_perProdPerMo","Biogas/mo, ft3",{"$f":"ROUNDDOWN(sum_foodWaste_tonsPerWeek*var_time_weeksPerMonth*sum_biogas_cuFtPerTonWetWeight,-1)","v":18260},"ft3/mo."]
[null,"producerCharge_pctTipping_perMo","Charge based on % tipping fee",{"$f":"sum_cost_tippingFeesPerTon*sum_foodWaste_tonsPerWeek*var_time_weeksPerMonth","v":608.75},{"$f":"CONCATENATE(ROUND(var_income_perMo_pctOfTipping,2)*100,\"% of \",DOLLAR(sum_cost_tippingFeesPerTon*sum_foodWaste_tonsPerWeek*var_time_weeksPerMonth,0),\" total tipping fee/mo.\")","v":"75% of $609 total tipping fee/mo."},null,null,"biogas_perProdPerMoMethaneFraction",{"$f":"CONCATENATE(\"ft³ methane, @\",ROUND(sum_biogas_pctMethane*100,0),\"% of biogas\")","v":"ft³ methane, @65% of biogas"},{"$f":"ROUNDDOWN(sum_biogas_perProdPerMo*sum_biogas_pctMethane,-1)","v":11860},"ft3/mo."]
[null,"producerCharge_pctEnergyProduced_perMo","Charge based on % biogas energy",{"$f":"var_income_perMo_pctOfEnergyProduced*sum_biogas_valuePerMoAsNatGas","v":23.72},{"$f":"CONCATENATE(ROUND(var_income_perMo_pctOfEnergyProduced,2)*100,\"% of \",DOLLAR(sum_biogas_valuePerMoAsNatGas,0),\" biogas energy value\")","v":"50% of $47 biogas energy value"},null,null,"biogas_valuePerMoAsNatGas","Value of methane as nat. gas replacement",{"$f":"(sum_biogas_perProdPerMoMethaneFraction/var_methane_cuFtPerTherm)*sum_cost_energy_natGasPerTherm","v":47.44},"$/mo."]
[]
[]
[null,null,"Note that this is not a planning tool, nor is it intended to offer exact estimates of cost, profit or loss. It reflects current assumptions about the business of an installer, and those assumptions may easily be wrong. (You'll have to be the judge on that.) What this spreadsheet is intended to do is to offer some rather modest evidence that there may be a business in providing small-scale biogas digesters to do on-site digestion, a solution which, uniquely, returns the energy embodied in the food waste to the producer as a burnable gas, a value not provided by landfill, composting, off-site AD, etc. The key numbers are offered above, but other variables will have an impact, so look around and make sure that you know what the assumptions are. My hope is that we can show the idea has legs. Anyone interested in trying?"]
[]
[null,null,{"$f":"IF(sum_producer_numTotal=0,\"Number of producers simply cannot be zero. Error!\",\"\")","v":""}]
[null,null,"Note: sentences below are 'active', and their content will change depending on the values that you provide for certain variables. Look around at the different worksheets and try various things, but (generally speaking) DO NOT change things in cells that are not painted green unless you understand what you are doing. Even so, if you screw things up, you can download another copy of this SS, however, so no worries... In fact, we expect to find errors and problems in this model, which is as yet so new, so keep checking back for the most recent version!"]
[null,null,{"$f":"CONCATENATE(\"Presumed per ton tipping fee is \",IF($K$14=\"l\",\"{least favorable}\",IF($K$14=\"a\",\"{average}\",IF($K$14=\"m\",\"{most favorable}\",IF($K$14=\"c\",\"{a custom number}\",\"!\")))),\", at \",DOLLAR(sum_cost_tippingFeesPerTon,0),\". Higher tipping fees = greater profit, since the cost of your service is assumed to include \",ROUND(var_income_perMo_pctOfTipping*100,0),\"% of the tipping fees.\")","v":"Presumed per ton tipping fee is {most favorable}, at $100. Higher tipping fees = greater profit, since the cost of your service is assumed to include 75% of the tipping fees."}]
[null,null,{"$f":"CONCATENATE(\"Presumed food waste per producer is \",IF($K$10=\"l\",\"{least favorable}\",IF($K$10=\"a\",\"{average}\",IF($K$10=\"m\",\"{most favorable}\",IF($K$10=\"c\",\"{a custom number}\",\"!\")))),\", at \",ROUND(sum_foodWaste_tonsPerWeek,2),\"tons/wk. Larger amounts = greater profit, since the cost of your service is assumed to include \",ROUND(var_income_perMo_pctOfEnergyProduced*100,0),\"% of the energy produced as methane.\")","v":"Presumed food waste per producer is {average}, at 1.4tons/wk. Larger amounts = greater profit, since the cost of your service is assumed to include 50% of the energy produced as methane."}]
[null,null,{"$f":"CONCATENATE(\"Presumed nat. gas cost is \",IF($K$13=\"l\",\"{least favorable}\",IF($K$13=\"a\",\"{average}\",IF($K$13=\"m\",\"{most favorable}\",IF($K$13=\"c\",\"{a custom number}\",\"!\")))),\", at \",DOLLAR(sum_cost_energy_natGasPerTherm,2),\"/therm. Higher gas prices = greater profit, since the cost of natural gas fixes the value of the energy produced as methane.\")","v":"Presumed nat. gas cost is {average}, at $0.40/therm. Higher gas prices = greater profit, since the cost of natural gas fixes the value of the energy produced as methane."}]
[null,null,{"$f":"CONCATENATE(\"Number of producers is \",IF($K$9=\"l\",\"{least favorable}\",IF($K$9=\"a\",\"{average}\",IF($K$9=\"m\",\"{most favorable}\",IF($K$9=\"c\",\"{a custom number}\",\"!\")))),\", at \",sum_producer_numTotal,\". More producers generall means more profit, since fixed expenses are amortized over more producers.\")","v":"Number of producers is {a custom number}, at 15. More producers generall means more profit, since fixed expenses are amortized over more producers."}]
[null,null,{"$f":"CONCATENATE(\"Est. manhours per month to provide services for these \",sum_producer_numTotal,\" producers is \",ROUND(tim_moTime_perDigPerProd_Total*sum_producer_numTotal,1),\" hr/mo. (One person working a \",var_workHrsPerWeek_avg,\" hr workweek has \",ROUND(var_workHrsPerWeek_avg*var_time_weeksPerMonth,0), \" working hrs available per avg. mo\")","v":"Est. manhours per month to provide services for these 15 producers is 136.1 hr/mo. (One person working a 40 hr workweek has 174 working hrs available per avg. mo"}]
[null,null,{"$f":"CONCATENATE(\"Note that wks/yr (\",ROUND(var_time_weeksPerYear,2),\") and wks/mo (\",ROUND(var_time_weeksPerMonth,2),\") are CALCULATED, thus are an exact average, versus the standard values of 52 and 4.\")","v":"Note that wks/yr (52.18) and wks/mo (4.35) are CALCULATED, thus are an exact average, versus the standard values of 52 and 4."}]
[null,null,{"$f":"CONCATENATE(\"Travel time can sometimes double or triple time required for servicing. Your producers are an avg. \",var_producer_tripMiles_avg,\" miles away, and avg. drive speed has been set at \",var_speed_urban_avg,\"MPH, giving a round trip time cost of \",ROUND(tim_moTime_roundTripToProd_Avg*60,0),\" min.\")","v":"Travel time can sometimes double or triple time required for servicing. Your producers are an avg. 10 miles away, and avg. drive speed has been set at 30MPH, giving a round trip time cost of 40 min."}]
[null,null,{"$f":"IF(tim_moTime_hrsReqdForAllProducers>=tim_moTime_hrsAvailablePerMoOnePerson,CONCATENATE(\"Given that the time required to service all producers (\",ROUND(tim_moTime_hrsReqdForAllProducers,0),\" hrs/mo) is more than the average working hours you specified for one person (@ \",ROUND(tim_moTime_hrsAvailablePerMoOnePerson,0),\" hrs/mo), you may need an employee...\"),\"\")","v":""}]
[]
[null,null,{"$f":"IF(exp_costFix_rentMortgageLease_perMo>1000,CONCATENATE(\"Major monthly expenses include rent/mortgage of \",DOLLAR(exp_costFix_rentMortgageLease_perMo,0),\". Lower monthlies mean greater take home pay.\"),\"\")","v":"Major monthly expenses include rent/mortgage of $2,500. Lower monthlies mean greater take home pay."}]
[null,null,{"$f":"IF(AND(exp_costFix_truck_perMo<>\"\",exp_costFix_truck_perMo>200),CONCATENATE(\"Major monthly expenses include truck lease/payment of \",DOLLAR(exp_costFix_truck_perMo,0),\". Lower monthlies mean greater take home pay.\"),\"\")","v":"Major monthly expenses include truck lease/payment of $640. Lower monthlies mean greater take home pay."}]
[]
[null,null,{"$f":"CONCATENATE(\"Please note that 'startup' costs for each producer— including digester install (@\",DOLLAR(exp_costVar_digester_installation_perEa,0),\") and training producer employees by installer (@\",DOLLAR(exp_costVar_training_perEa,0),\")— are not included in the calculations above.\")","v":"Please note that 'startup' costs for each producer— including digester install (@$75) and training producer employees by installer (@$120)— are not included in the calculations above."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"costVar_employeesPerProducer"]
[null,"costVar_producersPerEmployee"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"As",null,"Favorability",null,null,null,null,"Cost"]
[null,null,null,"Used","l,a,m?","Least",null,"Avg.","Most",null,"emp","owner"]
[null,"Variables (3 choices by favorability to profit)"]
[null,"cost_salaryOwnerHourly",null,null,null,null,null,null,"add 'custom' field as 4th col"]
[]
[]
[]
[]
[]
[]
[]
[null,"cost_energy_ElectricPerTherm"]
[null,"cost_digesterInstallation_hours"]
[null,"cost_digesterTraining_hours"]
[null,"serviced_timesPerWeek"]
[null,"serviced_hoursPerTime_Avg"]
[null,"producer_tripMiles_avg"]
[null,"cost_IBCs_perEa"]
[null,"cost_IBCs_perEa"]
[null,"paperwork_hrsPerProducerPerMo"]
[null,"costService_perMo_pctOfTipping"]
[null,"costService_perMo_pctOfEnergyProduced"]

{"sheet":"Expenses","index":1,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[32,8,38,11]]}
["Expenses"]
["exp"]
[]
[null,"Monthly variable (per producer) costs",null,{"$f":"SUM(D5:D8)","v":223.83333333333331}]
[null,"employees_hoursPerProducerPerMo",{"$f":"CONCATENATE(var_IBCs_numPerEaDigester,\" IBCs/producer: $\",ROUND(exp_costVar_ibcs_perMo,0),\" per mo\")","v":"2 IBCs/producer: $17 per mo"},{"$f":"(var_IBCs_amortizedPerMoCost*var_IBCs_numPerEaDigester)","v":16.666666666666668}]
[null,"costVar_ibcs_perMo",{"$f":"CONCATENATE(\"Monthy amoritzation, 1 digester\")","v":"Monthy amoritzation, 1 digester"},{"$f":"var_digester_amortCostCalculated","v":62},{"$f":"IF(sum_digester_buildFromKitsOrParts=\"kits\",CONCATENATE(\"Installer purchases and builds kits @\",DOLLAR(var_digester_costKitCompleted,0),\" ea.\"),CONCATENATE(\"Installer manufactures parts and builds digesters @\",DOLLAR(var_digester_costFromPartsCompleted,0),\" ea.\")) & CONCATENATE(\", amortized over \",var_digester_amortYrs_avg,\" mos. @ \",ROUND(var_digester_pctAPR*100,1),\"% interest offers a per ea cost of \",DOLLAR(var_digester_amortCostCalculated,0),\".\")","v":"Installer purchases and builds kits @$1,920 ea., amortized over 36 mos. @ 10% interest offers a per ea cost of $62."}]
[null,null,"Cost servicing (/mo, hrs + travel)",{"$f":"tim_moTime_perDigPerProd_Total*sum_sal_hourly_Employee","v":145.16666666666666},{"$f":"CONCATENATE(\"Calculated cost assumes \",DOLLAR(sum_sal_hourly_Employee,0),\" hourly wage.\")","v":"Calculated cost assumes $16 hourly wage."}]
[]
[]
[null,"Monthly fixed costs",null,{"$f":"ROUNDUP(SUM(D11:D20),-1)","v":3490}]
[null,"costFix_rentMortgageLease_perMo","Land lease/rent, or mortgage",2500,{"$f":"IF(D11<>\"\",\"$/mo\",\"\")","v":"$/mo"},{"$f":"IF(exp_costFix_rentMortgageLease_perMo<1,\"<== Installer has a place to use for her/his business for free.\",\"\")","v":""}]
[null,"costFix_phone_perMo","Phone",120,{"$f":"IF(D12<>\"\",\"$/mo\",\"\")","v":"$/mo"}]
[null,"costFix_web_perMo","Web",25,"$/mo"]
[null,"costFix_internet_perMo","Internet",100,"$/mo"]
[null,"costFix_busCards_perMo","Business cards, brochures",20,"$/mo"]
[null,"costFix_truck_perMo",{"$f":"IF(D30<>\"\",C30,\"\")","v":"Truck lease, payment or depreciation"},{"$f":"IF(D30<>\"\",D30,\"\")","v":640},"$/mo",{"$f":"IF(exp_costFix_truck_perMo=\"\",\"<== Installer is using a truck s/he owns outright.\",\"\")","v":""}]
[null,"costFix_crane_perMo","Crane/winch ",80,"$/mo"]
[null,"costFix_item08_perMo","","","","do not edit"]
[null,"costFix_item09_perMo","","","","any of the"]
[null,"costFix_item10_perMo","","","","cells inside"]
[null,"costFix_item11_perMo","","","","the border"]
[null,"costFix_item12_perMo","","",""]
[null,"costFix_item13_perMo","","","",null,null,null,null,null,null,null,null,null,null," "]
[null,"costFix_item14_perMo","","",""]
[null,"costFix_item15_perMo","","",""]
[null,"costFix_item16_perMo",{"$f":"IF(D38<>\"\",C38,\"\")","v":""},"",""]
[]
[null,"$/mo: loans; rented or leased items",null,{"$f":"SUM(D30:D35)","v":720},{"$f":"CONCATENATE(\"(Note: the \",DOLLAR(D28,0),\" total is not 'summed' toward expenses.\")","v":"(Note: the $720 total is not 'summed' toward expenses."}]
[null,null,"Item","$/mo","APR (%)","$ borrowed","term (mos)"]
[null,"leases_truck","Truck lease, payment or depreciation",{"$f":"IF(AND(E30<>0,F30<>0,G30<>0),ROUNDUP(PMT(E30/var_time_monthsPerYear,G30,-F30,0,1),-1),\"\")","v":640},0.1,30000,60,{"$f":"IF(AND(G30>0,G30<12),\"Really? A term less than a year?\",\"\")","v":""}]
[null,"leases_crane","Crane/winch ",80,0.1,2200,36,{"$f":"IF(AND(G31>0,G31<12),\"Really? A term less than a year?\",\"\")","v":""}]
[null,"leases_opCapital","Loan for operating capital","",null,null,null,""]
[null,"leases_IBC","Loan to purchase IBCs, other tools","",null,null,null,"","Note: fill in an item to the left by putting in each of the three required numbers, and the amortized cost and description will appear in monthly fixed costs list, above."]
[null,"leases_item05","Item #5",""]
[null,"leases_item06","Item #6",""]
[null,"leases_item07","Item #7","",null,null,null,""]
[null,"leases_item08","Item #8","",null,null,null,""]
[null,"leases_item09","Item #9","",null,null,null,""]
[null,"leases_item10","Item #10","",null,null,null,""]
[null,"leases_item11","Item #11","",null,null,null,""]
[null,"leases_item12","Item #12","",null,null,null,""]

{"sheet":"Time req'd","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Time required"]
["tim"]
[]
[]
[null,null,"Time req'd (hrs/month, estimated average)"]
[null,null,"moTime_perDigPerProd_Total","Time required, total/mo/producer",{"$f":"SUM(E7:E13)","v":9.0729166666666661},"hrs/prod/mo"]
[null,null,"moTime_perDigPerProdServiceHrs","Monthly hrs service, per digester",{"$f":"((var_service_hoursOnSiteServiceCall_Avg*var_service_timesPerWeek)+tim_moTime_roundTripToProd_Avg)*var_time_weeksPerMonth","v":5.0729166666666661},"hrs/prod/mo","includes travel time"]
[null,null,"moTime_perProdEmployeeReEducationHrsAvg","Employee re-education, hrs per mo, est avg",1,"hrs/prod/mo"]
[null,null,"moTime_perProdOfficeWorkHrsAvg","Office work req'd, per prod per mo, est avg",{"$f":"var_paperwork_hrsPerProducerPerMo","v":3},"hrs/prod/mo"]
[null,null,"moTime_moCustomActivity01_perProdPerMo","Monthly /producer activity #1, hrs/prod/mo",0,"hrs/prod/mo"]
[null,null,"moTime_moCustomActivity02_perProdPerMo","Monthly /producer activity #2, hrs/prod/mo",0,"hrs/prod/mo"]
[null,null,"moTime_moCustomActivity03_perProdPerMo","Monthly /producer activity #3, hrs/prod/mo",0,"hrs/prod/mo"]
[null,null,"moTime_moCustomActivity04_perProdPerMo","Monthly /producer activity #4, hrs/prod/mo",0,"hrs/prod/mo"]
[]
[]
[null,null,"moTime_roundTripToProd_Avg","Time required, round trip to producer, avg.",{"$f":"(var_producer_tripMiles_avg/var_speed_urban_avg)*2","v":0.66666666666666663},"hrs/prod/ea"]
[null,null,"moTime_hrsReqdForAllProducers","Time required, monthly service, all producers",{"$f":"(tim_moTime_perDigPerProd_Total*sum_producer_numTotal)","v":136.09375},"hrs/mo"]
[null,null,"moTime_hrsAvailablePerMoOnePerson","Time available, one person for one month",{"$f":"var_workHrsPerWeek_avg*var_time_weeksPerMonth","v":173.92857142857142},"hrs/mo"]
[]
[null,null,"moTime_prospectingNewProducers","Prospecting for new producers",10,"hrs/mo",null,"<== not presently used in calculations"]
[null,null,"moTime_moBusinessActivity01_perMo","Monthly business activity #1, hrs/mo",0,"hrs/prod/mo",null,"<==                \""]
[null,null,"moTime_moBusinessActivity02_perMo","Monthly business activity #1, hrs/mo",0,"hrs/prod/mo",null,"<==                \""]
[null,null,"moTime_moBusinessActivity03_perMo","Monthly business activity #1, hrs/mo",0,"hrs/mo",null,"<==                \""]
[null,null,"moTime_moBusinessActivity04_perMo","Monthly business activity #1, hrs/mo",0,"hrs/mo",null,"<==                \""]
[]
[]
[null,null,"Startup costs, per producer (not presently used in calculations!)",null,{"$f":"ROUNDUP(SUM(E28:E29)/tim_moTime_AmortStartUpCosts,0)","v":49},{"$f":"CONCATENATE(\"Total startup per producer cost of \",DOLLAR(E27,0),\" amortized over \",tim_moTime_AmortStartUpCosts,\" months per Std vars\")","v":"Total startup per producer cost of $49 amortized over 4 months per Std vars"}]
[null,null,"prodStartUp_installTime","Cost installation (1 time, $4hrs + travel)",{"$f":"(var_cost_digesterInstallation_hours+tim_moTime_roundTripToProd_Avg)*sum_sal_hourly_Employee","v":74.666666666666671},"done by owner and one emp"]
[null,null,"prodStartUp_trainingTime","Cost training (1 time, $4hrs + travel)",{"$f":"var_cost_digesterTraining_hours*sum_sal_hourly_Owner","v":120},"done by owner"]

{"sheet":"Std vars","index":3,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Standard variables"]
["var"]
[]
[null,null,null,null,null,"As","Favorability"]
[null,null,"Std vars",null,"l,a,m,c?","Used","Least","Avg.","Most","Custom","Units"]
[null,null,"cost_energy_ElectricPerTherm","Cost electricity, per therm equiv","a",{"$f":"IF(E6=\"l\",G6,IF(E6=\"a\",H6,IF(E6=\"m\",I6,\"!\")))","v":50},0,50,150,null,"$/therm"]
[null,null,"cost_digesterInstallation_hours","Digester installation, hrs","a",4,6,4,3,null,"hrs"]
[null,null,"cost_digesterTraining_hours","Digester training, hrs","a",6,8,6,4,null,"hrs"]
[null,null,"service_timesPerWeek","Serviced X times a week","a",0.5,1,0.5,0.33,null,"events/wk"]
[null,null,"service_hoursOnSiteServiceCall_Avg","Avg on-site service time req'd","a",1,2,1,0.5,null,"hrs/ea"]
[null,null,"producer_tripMiles_avg","Avg distance to producers (mi)","a",10,20,10,5,null,"mi"]
[null,null,"IBCs_costPerEa","Average cost of IBCs","a",100,300,100,50,null,"$/IBC"]
[null,null,"IBCs_numPerEaDigester","Number of IBCs per producer","a",2,3,2,1,null,"IBCs/ea digester"]
[null,null,"paperwork_hrsPerProducerPerMo","Paperwork and data hrs, /producer/mo","a",3,6,3,1,null,"hr/mo/ea"]
[null,null,"income_perMo_pctOfTipping","Installer charge, % of tipping","m",0.75,0.25,0.5,0.75]
[null,null,"income_perMo_pctOfEnergyProduced","Installer charge, % of energy produced","a",0.5,0.25,0.5,0.75]
[]
[]
[]
[null,null,"Other vars"]
[null,null,"showVariableNames","Show cell var names?",false,{"$f":"IF(var_showVariableNames,\"Yes, show var names\",\"No, do not show var names\")","v":"No, do not show var names"}]
[null,null,"stripeEveryXthRow",{"$f":"CONCATENATE(\"Row stripes (every \",var_stripeEveryXthRow,\" rows in tipping wks)\")","v":"Row stripes (every 4 rows in tipping wks)"},4]
[]
[null,null,"digester_HRT","HRT",20,"days"]
[null,null,"digester_vol","Vol digester",1.3,"m3"]
[null,null,"digester_dilution_volWater","Dilution, FW/water by vol",1,{"$f":"CONCATENATE(\"1:\",var_digester_dilution_volWater,\" ratio\")","v":"1:1 ratio"}]
[null,null,"methane_cuFtPerTherm","ft3 methane per therm",100,"ft3/therm"]
[]
[null,null,"energy_useNatGas_Q","Producers use natural gas (cook, heat, etc.)?",true,"if FALSE, assume electricity"]
[null,null,"PUtruck_costPerMile","Pick up truck cost, $/mi",0.75,"$/mi"]
[null,null,"speed_urban_avg","Avg driving speed, my area",30,"mph"]
[]
[null,null,"digester_costKit","Cost digester, kit",1800,"$"]
[null,null,"digester_timeToBuildKit","Avg time to build a kit",7,"hrs"]
[null,null,"digester_costKitCompleted","Cost digester, completed kit",{"$f":"ROUNDUP(var_digester_costKit+(var_digester_timeToBuildKit*sum_sal_hourly_Employee),-1)","v":1920},"$"]
[null,null,"digester_costParts","Cost digester, parts",750,"$"]
[null,null,"digester_timeToMakePartsAndBuild","Avg time to produce parts and build dig.",20,"hrs"]
[null,null,"digester_costFromPartsCompleted","Cost digester, completed from parts",{"$f":"ROUNDUP(var_digester_costParts+(var_digester_timeToMakePartsAndBuild*sum_sal_hourly_Employee),-1)","v":1070},"$"]
[null,null,"digester_costCalculated","Cost digester, calculated from vars",{"$f":"IF(sum_digester_buildFromKitsOrParts=\"kits\",var_digester_costKitCompleted,IF(sum_digester_buildFromKitsOrParts=\"parts\",var_digester_costFromPartsCompleted,\"err!\"))","v":1920},{"$f":"CONCATENATE(\"$: Chose \",sum_digester_buildFromKitsOrParts, \" because of var in summary.\")","v":"$: Chose kits because of var in summary."}]
[]
[null,null,"digester_amortYrs_avg",{"$f":"CONCATENATE(\"Digester, amortize over \",var_digester_amortYrs_avg,\" months\")","v":"Digester, amortize over 36 months"},{"$f":"12*3","v":36},"mos"]
[null,null,"digester_pctAPR","Digester, APR for digester amortization",0.1]
[null,null,"digester_amortCostCalculated","Digester, amortized /mo cost, calculated",{"$f":"ROUND(PMT(var_digester_pctAPR/var_time_monthsPerYear,var_digester_amortYrs_avg,-var_digester_costCalculated,1,),0)","v":62},"$"]
[null,null,"IBCs_amortizeOverMos","IBC, months to amortize",12,"mos"]
[null,null,"IBCs_amortizedPerMoCost","IBC, per month amort $",{"$f":"PMT(0,var_IBCs_amortizeOverMos,-var_IBCs_costPerEa,0,1)","v":8.3333333333333339}]
[]
[null,null,"workHrsPerWeek_avg","Avg working hours/week",40,"hrs/wk"]
[null,null,"time_minsPerHr","Mins/Hr ",60,"min/hr"]
[null,null,"time_daysPerYear","Days/year",365.25,"da/yr"]
[null,null,"time_monthsPerYear","Months/year",12,"mo/yr"]
[null,null,"time_daysPerWeek","Days/week",7,"da/wk"]
[null,null,"time_weeksPerYear","Weeks/year",{"$f":"(var_time_daysPerYear/var_time_daysPerWeek)","v":52.178571428571431},"wks/yr","Note that wks/yr and wks/mo are CALCULATED, thus exact, versus the"]
[null,null,"time_weeksPerMonth","Weeks/month",{"$f":"var_time_weeksPerYear/var_time_monthsPerYear","v":4.3482142857142856},"wks/mo","standard values of 52 and 4."]

{"sheet":"Tipping fees","index":4,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,2,7,3],[8,2,8,3],[8,5,8,6],[7,5,7,7]]}
["Tipping fees by state"]
["tfs",null,null,"These lists are not 'active' in the sense that the numbers are not used in calculations in this SS."]
[null,null,null,"The lists are provided for your convenience, but you may well be able to find better numbers online."]
[null,null,null,"So many of the numbers reported in the two lists vary by so much that overall accuracy is in question."]
[]
[null,null,"Data ostensibly from 2016",null,null,"Data ostensibly from 2013"]
[]
[null,null,"The EREF site serves as the primary source for much of the data reported by others (even 2nd and 3rd hand) for tipping fees",null,null,"The Green Power, in my view, is questionable, but it provides high/low and some info on # of sites"]
[null,null,"Table 1.State and Regional Average Tip Fees, from EREF Survey Jan 2016 a,b",null,null,"Landfill Tipping Fees in USA"]
[null,null,"https://erefdn.org/product/analysis-msw-landfill-tipping-fees/",null,null,"http://www.cleanenergyprojects.com/Landfill-Tipping-Fees-in-USA-2013.html"]
[null,null,"State","Average",null,"State","High ","Low","Average"]
[null,null,"Alabama",36.82,null,"Alabama  ",47,26,37.6]
[null,null,"Alaska",56.5,null,"Alaska  (4 Landfills)",85,21,60.88]
[null,null,"Arizona","N.R.",null,"Arizona ",38.25,30,33.049999999999997]
[null,null,"Arkansas",26.25,null,"Arkansas  ",43,33,36.5]
[null,null,"California",63.31,null,"California  ",76.819999999999993,34.369999999999997,52.07]
[null,null,"Colorado",46,null,"Colorado  ",66,28,49.6]
[null,null,"Connecticut","N.R.",null,"Connecticut  (1 Landfill)",57.15,57.15,57.15]
[null,null,"Delaware",75,null,"Delaware (3 Landfills) ",84,84,84]
[null,null,"Florida",51.31,null,"Florida  ",83.92,25.5,43.65]
[null,null,"Georgia",109.5,null,"Georgia ",45,30.55,38.270000000000003]
[null,null,"Hawaii",85,null,"Hawaii  ",90,39,75.17]
[null,null,"Idaho",33,null,"Idaho ",67.7,30,44.41]
[null,null,"Illinois",43.56,null,"Illinois  ",60,28,43.46]
[null,null,"Indiana",18.5,null,"Indiana  ",60.1,32,44.2]
[null,null,"Iowa",35.869999999999997,null,"Iowa  ",40.5,25,34.15]
[null,null,"Kansas",33,null,"Kansas  ",43.5,30.5,37.46]
[null,null,"Kentucky",30.04,null,"Kentucky ",55,33.5,44.69]
[null,null,"Louisiana",72,null,"Louisiana  ",31,19.8,26.96]
[null,null,"Maine",52.67,null,"Maine (4 Landfills)",115,72,91]
[null,null,"Maryland",68.38,null,"Maryland  ",70,52,62.7]
[null,null,"Massachusetts",86,null,"Massachusetts  ",100,60,78.5]
[null,null,"Michigan",41,null,"Michigan ",88,25,46.82]
[null,null,"Minnesota",47.5,null,"Minnesota  ",63.33,26.66,47.04]
[null,null,"Mississippi",32.450000000000003,null,"Mississippi ",47,11,26.48]
[null,null,"Missouri",24.47,null,"Missouri  ",48.11,30,38.380000000000003]
[null,null,"Montana",25.79,null,"Montana  ",31.05,16.5,25.51]
[null,null,"Nebraska",31.49,null,"Nebraska  ",45,21,31.13]
[null,null,"Nevada","N.R.",null,"Nevada  ",31,13.7,24.83]
[null,null,"New Hampshire",72.89,null,"New Hampshire  ",87.55,67,77.849999999999994]
[null,null,"New Jersey",68.03,null,"New Jersey  ",96,44.31,72.39]
[null,null,"New Mexico",25.85,null,"New Mexico  ",62.01,14.98,33.799999999999997]
[null,null,"New York",62.5,null,"New York",102,49.5,86.3]
[null,null,"North Carolina",43.5,null,"North Carolina (4 Landfills)",65.84,27.5,41.59]
[null,null,"North Dakota",58.25,null,"North Dakota  ",43.81,34.65,38.92]
[null,null,"Ohio",14.47,null,"Ohio ",52.8,30,39.659999999999997]
[null,null,"Oklahoma",69,null,"Oklahoma  ",50.29,25.75,38.31]
[null,null,"Oregon",42.25,null,"Oregon  ",83.75,28.5,55.74]
[null,null,"Pennsylvania",47.25,null,"Pennsylvania  ",103,63.25,75.959999999999994]
[null,null,"Rhode Island",32,null,"Rhode Island  (1 Landfill)",75,75,75]
[null,null,"South Carolina",28.88,null,"South Carolina  ",66,29,42.61]
[null,null,"South Dakota",46.75,null,"South Dakota ",59,34,41.9]
[null,null,"Tennessee",42,null,"Tennessee  ",48,30.5,41.15]
[null,null,"Texas",28,null,"Texas  ",41,5,28.95]
[null,null,"Utah",30.18,null,"Utah  ",33,15,24.29]
[null,null,"Vermont",22,null,"Vermont  (2 Landfills)",87.14,77.5,82.32]
[null,null,"Virginia",38.630000000000003,null,"Virginia  ",66,32,46.11]
[null,null,"Washington",64.58,null,"Washington ",142.01,28.8,70.44]
[null,null,"West Virginia",50.82,null,"West Virginia  ",69.25,41.75,49.46]
[null,null,"Wisconsin",64,null,"Wisconsin  ",66,35,50.2]
[null,null,"Wyoming",47,null,"Wyoming ",102,35,60.4]

{"sheet":"scratch","index":5,"n_rows":80,"n_cols":13,"rows_kept":80,"cut":false,"hidden":true,"merged":[[75,1,76,6]]}
[]
[]
[null,"Weather?"]
[null,"The cost of the digester and its installation, whether it is purchased or leased and the details thereof"]
[null,"The amount of food waste being generated, and its characteristics"]
[null,"The cost of the fuel source being used for heating and cooking, to establish a basis for fuel replacement value"]
[null,"The requirements for servicing by the installer and the producer’s employees, primarily as a function of time"]
[null,"The cost of the producer’s present means of dealing with food waste, such as hauling to a landfill (tipping fees)"]
[null,"The cost of heating the digester, by burning biogas, collecting solar energy, or heating water using electricity"]
[null,"Allow comparison between 2 scenarios, or 3 if possible,",null,null,null,null,null,null,"costVar_digester_installation_perEa"]
[null,"Provide min installers, achieve certain net, show hours est. servicing",null,null,null,null,null,null,"costVar_training_perEa"]
[null,"Add in cost per mile of driving",null,null,null,null,null,null,"costVar_servicing_perMo"]
[null,"Different first year contract?",null,null,null,null,null,null,"costVar_digesterPerProducerAmortization_perMo"]
[null,"Rate of sign-ups, num weeks until breakeven given certain conditions"]
[null,"set up to calculate based on electricity as comparison fuel"]
[null,"# Employees, per producer",null,null,"(tracked to number of trucks, # producers, or ?)"]
[null,"# Producers per employee"]
[null,{"$f":"CONCATENATE(\"with more IBCs, some might be left at composting facility or farm for later emptying, reducing number of monthly trips\")","v":"with more IBCs, some might be left at composting facility or farm for later emptying, reducing number of monthly trips"}]
[null,"Number of trucks",null,"like emp, min would be based on time est."]
[null,{"$f":"sum_biogas_cuFtPerTonWetWeight/var_methane_cuFtPerTherm","v":30},{"$f":"B20*Summary!L13*var_time_weeksPerMonth","v":39.133928571428569}]
[null,{"$f":"(sum_biogas_cuFtPerTonWetWeight*sum_foodWaste_tonsPerWeek*sum_biogas_pctMethane)*var_time_weeksPerMonth","v":11870.625},"ft3/mo",null,{"$f":"B21/100","v":118.70625},"therms/mo"]
[null,{"$f":"(scr_methane_cuFtPerMo/var_methane_cuFtPerTherm)*sum_cost_energy_natGasPerTherm","v":47.482500000000002},"$/mo energy value"]
[]
[null,{"$f":"sum_foodWaste_tonsPerWeek*var_time_weeksPerMonth*sum_cost_tippingFeesPerTon","v":608.75},"$/mo (cost calc'd per ton!)",null,{"$f":"scr_methane_dollarsPerMoAsNatGas/var_time_weeksPerMonth","v":10.92},"/wk energy value"]
[]
[null,null,null,null,null,null,null,"costs_producers_varCostPerMo",{"$f":"CONCATENATE(\"Per mo variable costs, \",sum_producer_numTotal,\" prod/mo\")","v":"Per mo variable costs, 15 prod/mo"},{"$f":"(tmp_costVar_producers_costPerEa+tmp_costVar_ibcs_perMo+exp_costVar_digesterPerProducerAmortization_perMo)*sum_producer_numTotal","v":3930}]
[null,null,"events/yr",null,null,null,null,null,null,null,null,{"$f":"Summary!D29*sum_sal_hourly_Employee","v":0},"/mo paid hours"]
[null,null,{"$f":"CONCATENATE(retHrsMins(scr_service_hoursPerMoPerProducer, FALSE),\"/mo, incl. paperwork, data collection, et al\")","v":"0h/mo, incl. paperwork, data collection, et al"},null,null,null,null,"incom_perProducersTotal_perMo","Income based on assumptions",{"$f":"sum_producerCharge_total_perMo*sum_producer_numTotal","v":9487.0500000000011},null,{"$f":"L27*var_time_monthsPerYear","v":0}]
[null,{"$f":"((var_producer_tripMiles_avg*2)/var_speed_urban_avg)*sum_sal_hourly_Owner","v":13.333333333333332},{"$f":"((var_producer_tripMiles_avg*2)/var_speed_urban_avg)*sum_sal_hourly_Owner","v":13.333333333333332},"$/round trip",null,null,null,"incom_netPerMo","net, based on assumptions",{"$f":"sum_incom_perProducersTotal_perMo-(sum_costs_fixed_perMo+tim_moTime_perDigPerProd_Total)","v":9477.977083333335},"/mo",{"$f":"sum_incom_netPerMo*var_time_monthsPerYear+L28","v":113735.72500000002}]
[null,null,null,null,null,null,null,null,null,{"$f":"(sum_incom_netPerMo*var_time_monthsPerYear)/sum_producer_numTotal","v":7582.381666666668}]
[null,15]
[null,{"$f":"var_time_weeksPerYear*var_workHrsPerWeek_avg*scratch!B31","v":31307.142857142859},null,null,null,null,null,"tmp_costVar_producers_costPerEa",null,100]
[null,260,null,null,null,null,null,"tmp_costVar_ibcs_perMo",null,100]
[null,{"$f":"ROUND(B32*B33,-4)","v":8140000}]
[]
[null,"Operating expenses:",null," ",null,null,null,"moTime_AmortStartUpCosts","Amortize producer startup costs over X mos",4,"mos."]
[]
[null,"Gas expense"]
[null,"Telephone expense"]
[null,"annual repairs"]
[null,"per mile cost vehicle"]
[null,"conversion cost PU"]
[null,"lease/buy commercial vehicle"]
[null,"# producers under contract"]
[null,"amortize digester"]
[null,"gas price per mo"]
[null,"Equipment repair expense"]
[]
[null,"Insurance' expense"]
[null,"Rent expense"]
[null,"Depreciation expense",null,null," "]
[null,"license expense",null,null," "]
[null,"Payroll taxes",null,null," "]
[null,"Office supplies expense",null,null," "]
[null,"Field supplies expense",null,null," "]
[null,"Miscellaneous expenses",null,4700," "]
[null,"Total operating expenses",null,null,{"$f":"SUM(D37:D56)","v":4700}]
[null,"Net operating profit",null," ",{"$f":"Expenses!O23-E57","v":-4700}]
[]
[]
[]
[]
[null,"Cost of travel to producer (mo? Per ea?)",null,null,"r"]
[null,"hours per prod per mo",null,null,"r"]
[null,"var costs per prod per mo",null,null,"r"]
[null,"var costs per prod per ea",null,null,"r"]
[null,"var costs IBCs/prod/mo",null,null,"r"]
[]
[]
[null,"Cost mods to stove, HVAC"]
[]
[null,"hours req'd/producer/mo; emp or owner?"]
[null,"trigger pt for recommend switch from owner to prod is _60%_ of full time"]
[null,"Lots of text in its own worksheet"]
[null,"Directions for use"]
[null,"explain that this is not a month by month, but avg month; indication, not planning, not reporting tool"]
[]
[null,"Because of above, we cannot allocate training to a single month"]
[null,"Nor can we describe the setup costs and allocate to a new producer"]
[null,"Steady state' picture"]