{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","System Planner","Hidden","Documentation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":79,"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":"Instructions","index":0,"n_rows":63,"n_cols":3,"rows_kept":63,"cut":false,"hidden":false,"merged":[[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[2,1,2,2],[10,1,10,2],[14,1,14,2],[15,1,15,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[11,1,11,2],[12,1,12,2],[8,1,8,2],[27,1,27,2],[29,1,29,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[1,1,1,2],[39,1,39,2],[50,1,50,2],[48,1,48,2],[47,1,47,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[30,1,30,2],[31,1,31,2],[33,1,33,2],[34,1,34,2],[25,1,25,2],[26,1,26,2],[49,1,49,2]]}
[]
[null,"Instructions for Spartan Animal Tissue Compost System Planner"]
[null,"v1.02"]
[]
[null,"1.  Overview"]
[null,"Spartan Animal Tissue Compost (ATC) System Planner is an Excel application that assists in designing a composting system for routine or normal production, using a static piling approach, including facilities and material flow in batches. The spreadsheet has been designed for composting animal tissue routinely accumulated as whole carcasses (on-farm, live animal businesses) or as animal tissue co-products (animal processing operations)."]
[null,"There are four general composting systems or methods which may be used to compost animal tissues in static batches: piled in bins, open piles adjacent to one another, piles that overlap slightly, and windrows.  Static means that animal tissue and compost materials are mixed and left to stand motionless or idle for a planned period of time."]
[null,"Spartan ATC System Planner was developed by Dr. Dale Rozeboom (Department of Animal Science, Michigan State University), Dr. Howard Person (formerly Department of Agricultural Engineering Michigan State University), Suzanne Reamer (Michigan Natural Resource Conservation Service) and Robert Kriegel M.S. (ANR Technology Services, Michigan State University), and Dean Ross (Agrosecurity Consulting; revisions made in version 1.01, 1.02)."]
[null,"For inquiries about this application contact rozeboom@msu.edu."]
[]
[null,"2.  System Requirements"]
[null,"Excel 2003.  Due to changes in how Excel handles macros, there are separate versions of this application for Excel 2003 and for Excel 2007-2010.  You must have Microsoft Excel 2003 or later to run this version of Spartan ATC System Planner.  The spreadsheet contains macros, so MS Excel's security must be set to moderate or low to allow the macros to function.  To change the security setting select Tools > Macro > Security from Excel's main menu and set security to moderate or low.  Since macros are only loaded when a file is first opened, you need to close and reopen a file after changing Excel's macro security settings.  Depending on your security setting, Excel may ask you whether to enable or disable macros when you open the file.  Macros must be enabled for the application to work correctly. \n"]
[null,"Excel 2007 and later. Due to changes in how Excel handles macros, there are separate versions of this application for Excel 2003 and for Excel 2007-2010.  You must have Microsoft Excel 2007 or later to run this version of Spartan ATC System Planner. The spreadsheet contains macros, so MS Excel's security must be set to moderate or low to allow the macros to function.  To change the security setting select the Developer tab on Excel's main menu, then select 'Macro Security' from the toolbar and Tools > Macro > Security from Excel's main menu and set security to enable macros.  Depending on your security setting, Excel may ask you whether to enable or disable macros when you open the file.  Macros must be enabled for the application to work operate correctly.  "]
[]
[null,"3.  Planning a Compost System"]
[null,"Spartan ATC System Planner assists producers of animal tissues with sizing of a composting system. First, the program provides an estimate of amount of animal tissue over time (i.e. rate of accumulation) using enterprise size, mortality rates specific to phases of animal production, and weights (carcasses or by-products). You may enter more than one type of animal production enterprise. Second, Spartan ATC System Planner assists with the selection of a composting system which is sized to accommodate the composting of that amount of mortality in a desired time. You will enter system dimensions using your best reasoning, or by \"trial and error\" so that \"volume needed per desired time\" is equal to or slightly greater than the \"effective volume\" of the bin, pile, or windrow."]
[null,"Throughout the spreadsheet enter appropriate information into cells which are shaded green."]
[null,"The Excel workbook contains the following two worksheets:"]
[null,"Instructions.  This sheet contains instructions for using the System Planner worksheet."]
[null,"System Planner.  Use this sheet to determine the material flow and size of a static piling compost system or operation.  You will determine animal tissue accumulation rate (amount per time) and then plan how to accomplish the composting of that amount of tissue (flow as batches) through a compost system of a size which you select for your situation."]
[]
[null,"a.  Introductory Steps"]
[null,"In the first 11 rows of the System Planner worksheet enter the following general information about your farm or business:  "]
[null,"Name and address: Enter the enterprise name and address information for this plan."]
[null,"Select producer type: Using the drop-down list, select one or more different animal production enterprises. A table for that specie will appear below to be used to estimate the amount of animal tissue accumulated over time. If more than one animal production enterprise is selected, the amount of animal tissue accumulated over time will be a sum of all enterprises."]
[null,"Select type of composting system:  Using the drop-down list, select one system you plan to use. This is not a final decision. You may switch from one system to another at any time. Alternatively, all systems may be evaluated at one time. The advantages and disadvantages of each system are described in the Michigan Animal Tissue Compost Operational Standard available at the following URL:"]
[null,"http://www.msu.edu/~rozeboom/"]
[null,"Target animal tissue density:  Also known as \"volume factor\" or \"volume coefficient\" or the \"bulking agent to mortality ratio\". This is the most important factor in determining composting volume. This density has been determined through experimentation and animal tissue composting has been successfully accomplished using densities varying from 0.05 to 15 lb/ft3.  However, when animal tissue density is greater than 10 lb/ft3, intensive management of aeration and moisture is necessary. The Spartan ATC System Planner default is 10 lb/ft3."]
[]
[null,"b.  Animal Production Information"]
[null,"In the next portion of the System Planner worksheet you enter production information in order to estimate the routine or normal rate of animal tissue accumulation."]
[null,"For each animal production enterprise selected, enter measures in the green shaded cells. For specific help with understanding what information is being requested, a comment will appear when the cursor is placed over the name of the item for which a number is being requested."]
[]
[null,"c.  Composting Systems Information"]
[null,"In the lowest portion of the System Planner you enter dimensions of compost material in specific shapes and the months or fraction of months you plan on leaving a batch of compost in your system."]
[null,"A batch is the animal tissue and amendment accumulated together in a planned period of time. Batches provide for appropriately timed temperature monitoring, aerating, and final utilization. Initial additions, or loading of new dead animals and bulking agent is limited to a planned time period which is based on animal tissue accumulations over time (determined in the preceding portion of this worksheet ) and an appropriately sized composting system (determined in the following portion of this worksheet)."]
[null,"Desired time: Enter an estimate of the number of months that will be required to start and complete the creation of a new batch. The batch may be kept in one bin or in the form of a windrow or pile. Desired time is the period over which animal tissue will be added.  Most often a period of 1 month is taken to create a batch, but a range from 0.25 to 2 months may be considered depending on daily mortality rate."]
[null,"Length, width, and height: Each dimension is described in a comment that will appear when the cursor is placed over the name of the measure. Enter dimensions so that batch \"volume needed per desired time\" is equal to or slightly greater than the \"effective volume\" of that batch in that selected system. Enter dimensions by \"trial and error.\""]
[null,"Duration of active composting in bin: Number of months after a batch has been created. Time required to decompose tissues is dependent on the maturity of the animals. The number of months of well-managed active composting in static batches for the decomposition of all soft tissues is shown in the table below for carcasses of various sizes. Mature swine hides will persist longer than those of mature bovine or equine, and all other soft tissues."]
[null,"Table 1. Months of active composting suggested for the decomposition of soft animal tissues."]
[null,"Carcass size, lb","Suggested number of months for well-managed active composting in static batches for the decomposition of all soft tissues"]
[null,"1 to 25",1]
[null,"25 to 125",1]
[null,"125 to 250",2]
[null,"250 to 500",2]
[null,"500 to 1000",2]
[]
[null,"Actively or forced aerated batches (bins, piles, windrows or contained vessels) require up to 50% less time. It has been reported that composting hog farm mortality using the traditional static batch system was a 180-day process, but with the grinding of carcasses and the use of a rotating drum system composting time reduced the time needed to compost all soft tissue by 30 to 50%. "]
[null,"Equipment working space or apron width: This is the area around batches needed for formation and mixing using a bucket loader. It is sometimes called an apron. Enter the linear distance from the edge of the compost material (where is meets the inside border of the apron) to outside border of apron. This space depends on size of tractor and loader."]
[null,"The Spartan ATC System Planner has been developed to plan continuous flow composting systems across a range of herd and facility size and management strategies.  The Planner is programmed to report a minimum default of 3 piles or bins required under each planning scenario entered by the user.  Underlying management assumptions suggest that there will be at least one bin or pile built and operational, one bin or pile under construction and one bin or pile ready to accept compost or act as a mixing location.  In situations where annual material flow into the system is very small or highly intermittent, the Spartan ATC System Planner may overestimate the required number of bins, piles or space required.  In situations when planning is for the composting of individual animal mortalities or other materials, the Spartan Emergency ATC Planner may provide a better model.  It is designed to plan for single composting events, rather than for continuous flow operations."]
[null,"Printing:  Spartan ATC System Planner prints out plans as one page in portrait orientation."]
[]
[null,"Changes since version 1.0"]
[null,"v1.00 Oct. 9, 2008:  Version 1.0 released."]
[]
[null,"v1.01 Dec. 17, 2013:  Several changes made as follows:"]
[null," - Production information section for 'Processor by-product' changed to 'Animal Tissue'"]
[null," - Version 1.01 beta tested and distributed at MSUE Livestock Inservice."]
[]
[null,"v1.02 Mar. 3, 2014:  Several changes made as follows:"]
[null," - Animal production sections modified to remove 'Number of animals per year' row."]
[null," - Animal production section added for small ruminants."]
[null," - For overlapping piles composting system, recommendation added when volume requires less than 3 pile minimum worksheet is designed for."]

{"sheet":"System Planner","index":1,"n_rows":135,"n_cols":27,"rows_kept":135,"cut":false,"hidden":false,"merged":[[2,7,2,9],[3,7,3,9],[4,7,4,9],[3,3,3,4],[4,3,4,4],[2,3,2,4],[132,21,133,26],[131,21,131,26],[133,7,134,11],[60,2,60,4],[27,2,27,4],[71,3,71,4],[49,2,49,4],[38,2,38,4]]}
[null,null,null,null,null,null,"System Planner Worksheet"]
[]
[null,null,"Name: ",null,null,null,"Address: ",null,null,null,null,null,null," ------> THESE COLUMNS WILL BE HIDDEN IN FINAL VERSIONS  -------------------------------->",null,null,null,null,null,null,null,null,null,null,null,null,"HIDE TO HERE ---------->"]
[null,null,"Phone: ",null,null,null,null,null,null,null,null,null,null,null,"Producer1, Total farm mortality =",{"$f":"IF(ProducerType=1, 0, IF(ProducerType=2, $F$23,IF(ProducerType=3,$F$34,IF(ProducerType=4,$F$45,IF(ProducerType=5,$F$56,IF(ProducerType=6,$F$67,$F$74))))))","v":0}]
[null,null,"Fax: ",null,null,null,null,null,null,null,null,null,null,null,"Producer2, Total farm mortality =",{"$f":"IF(Producer2Type=1, 0, IF(Producer2Type=2, $F$23,IF(Producer2Type=3,$F$34,IF(Producer2Type=4,$F$45,IF(Producer2Type=5,$F$56,IF(Producer2Type=6,$F$67,$F$74))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Producer3, Total farm mortality =",{"$f":"IF(Producer3Type=1, 0, IF(Producer3Type=2, $F$23,IF(Producer3Type=3,$F$34,IF(Producer3Type=4,$F$45,IF(Producer3Type=5,$F$56,IF(Producer3Type=6,$F$67,$F$74))))))","v":0}]
[null,null,"Select first type of producer:",null,null,null,"     Select type of composting system:",null,null,null,null,null,null,null,"Total farm mortality =",{"$f":"SUM(P4:P6)","v":0}," lb/day"]
[null,null,"Select second type of producer:",null,null,null,null,null,null,null,null,null,null,null,"Days per month =",{"$f":"365.25/12","v":30.4375},null,null,"Tissue"]
[null,null,"Select third type of producer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Density",null,"Recommendation text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x<=10","Animal tissue density is ok."]
[null,null,null,"Target animal tissue density: ",10," lb/ft3",{"$f":"IF(TargetTissueDensity>15,T12,IF(TargetTissueDensity<=10,T10,T11))","v":"Animal tissue density is ok."},null,null,null,null,null,null,"  <= input a density > 15 and see what happens",null,null,null,null,"10<x<=15","Intensive aeration and moisture management may be necessary."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x>15","Animal tissue density exceeds state of Michigan regulations."]
[null,"Swine Animal Production Information"]
[]
[null,null,null,"Item",null,"Piglets Preweaning","Breeding Herd","Nursery","Wean-Finish","Grow-Finish"]
[null,null,null,null,"Stalls: ",0]
[null,null,null,null,"Total piglets farrowed per litter: ",11]
[null,null,null,null,"Capacity: ",null,0,0,0,0]
[null,null,null,null,"Days per complete turn: ",21,365,70,168,135]
[null,null,null,null,"Percent mortality: ",0.15,0.02,0.05,0.02,0.03]
[null,null,null,null,"Average weight of animals during phase (lb): ",4.5,450,40,125,150]
[null,null,null,null,"Calculated daily mortality (lb/day): ",{"$f":"IF(F19>0, (F16*F17*F20*F21)/F19, 0)","v":0},{"$f":"IF(G19>0, G18*G20*G21/G19, 0)","v":0},0,0,{"$f":"IF(J19>0, J18*J20*J21/J19, 0)","v":0}]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F22:J22)","v":0}," lb/day"]
[]
[]
[null,"Bovine Animal Production Information"]
[]
[null,null,"Item",null,null,"Cows","Calves","Heifers","Feeder Cattle"]
[null,null,null,null,"Capacity: ",0,0,0,0]
[null,null,null,null,"Days in this production phase: ",365,365,168,168]
[null,null,null,null,"Percent mortality: ",0.04,0.05,0.02,0.02]
[null,null,null,null,"Average weight of animals during phase (lb): ",1200,110,600,600]
[null,null,null,null,"Calculated daily mortality (lb/day): ",{"$f":"IF(F30>0,F29/F30,0)*F31*F32","v":0},{"$f":"IF(G30>0,G29/G30,0)*G31*G32","v":0},0,0]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F33:I33)","v":0}," lb/day"]
[]
[]
[null,"Small Ruminant Production Information"]
[]
[null,null,"Item",null,null,"Adults","Young Stock"]
[null,null,null,null,"Capacity: ",0,0]
[null,null,null,null,"Days in this production phase: ",365,365]
[null,null,null,null,"Percent mortality: ",0.04,0.05]
[null,null,null,null,"Average weight of animals during phase (lb): ",150,25]
[null,null,null,null,"Calculated daily mortality (lb/day): ",{"$f":"(F40*F42*F43)/365","v":0},{"$f":"(G40*G42*G40)/365","v":0}]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F44:G44)","v":0}," lb/day"]
[]
[]
[null,"Poultry Animal Production Information"]
[]
[null,null,"Item",null,null,"Layers","Turkeys","Others"]
[null,null,null,null,"Capacity: ",0,0,0]
[null,null,null,null,"Days in this production phase: ",365,122,168]
[null,null,null,null,"Percent mortality: ",0.05,0.1,0.02]
[null,null,null,null,"Average weight of animals during phase (lb): ",6,15,600]
[null,null,null,null,"Calculated daily mortality (lb/day): ",{"$f":"IF(F52>0,F51/F52,0)*F53*F54","v":0},{"$f":"IF(G52>0,G51/G52,0)*G53*G54","v":0},0]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F55:H55)","v":0}," lb/day"]
[]
[]
[null,"Equine Animal Production Information"]
[]
[null,null,"Item",null,null,"Adults","Foals"]
[null,null,null,null,"Capacity: ",0,0]
[null,null,null,null,"Days in this production phase: ",365,365]
[null,null,null,null,"Percent mortality: ",0.02,0.25]
[null,null,null,null,"Average weight of animals during phase (lb): ",1500,200]
[null,null,null,null,"Calculated daily mortality (lb/day): ",{"$f":"IF(F63>0,F62/F63,0)*F64*F65","v":0},{"$f":"IF(G63>0,G62/G63,0)*G64*G65","v":0}]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F66:G66)","v":0}," lb/day"]
[]
[]
[null,"Animal Tissue Production Information"]
[]
[null,null,null,"Item",null,"Tissue"]
[null,null,null,null,"Animal tissue accumulation: ",0," lb/wk"]
[null,null,null,null,"Total plant mortaility: ",{"$f":"animalTissuePerWk/7","v":0}," lb/day"]
[]
[]
[null,"Composting System Plan Using Bins"]
[null,null,"Design Parameters",null,null,null,null,null,null,null,null,null,null,null,"Hidden bin calculations"]
[null,null,null,null,"Desired time to fill bin and create a batch: ",2," months",{"$f":"\"Total farm mortality = \"&TEXT(ROUND(Q79,0),\"#,###\")&\" lb per \"&F79&\" month\"&IF(F79=1,\"\",\"s\")","v":"Total farm mortality =  lb per 2 months"},null,null,null,null,null,null,null,"Total farm mortality per time =",{"$f":"binBatchDuration*MortalityPerDay*DaysPerMonth","v":0}]
[null,null,null,null,"Bin length: ",6," ft",{"$f":"\"Volume needed to fill bin in desired time = \"&TEXT(ROUND(Q80,0),\"#,###\")&\" cubic ft\"","v":"Volume needed to fill bin in desired time =  cubic ft"},null,null,null,null,null,null,null,"Bin volume needed to fill bin in desired time = ",{"$f":"binsTotalMortality/TargetTissueDensity","v":0}," ft3"," actual"]
[null,null,null,null,"Bin width: ",6," ft",{"$f":"\"Effective volume of bin = \"&TEXT(ROUND(Q81,0),\"#,###\")&\" cubic ft\"","v":"Effective volume of bin = 137 cubic ft"},null,null,null,null,null,null,null,"Bin effective volume = ",{"$f":"(BinWidth*BinHeight*BinLength) - (BinWidth*TAN(RADIANS(30))*(BinHeight^2)/2)","v":136.69872981077808}," ft3","planned"]
[null,null,null,null,"Bin height: ",5," ft",{"$f":"\"Construction volume of bin = \"&TEXT(ROUND(Q82,0),\"#,###\")&\" sq ft\"","v":"Construction volume of bin = 180 sq ft"},null,null," ",null,null,null,null,"Construction volume = ",{"$f":"BinLength*BinWidth*BinHeight","v":180}]
[null,null,null,null,"Duration of active composting in bin:",5," months",{"$f":"IF(Q83<3,\"NOTE: A minimum of three composting bins are needed to\",\"\")","v":"NOTE: A minimum of three composting bins are needed to"},null,null,null,null,null,null,null,"calc'd # composting bins = ",{"$f":"binsTotalVolumeNeeded/binsConstructionVolume+(BinCompoostingDuration/binBatchDuration)","v":2.5}]
[null,null,null,null,"Number of bulking agent storage bins: ",1,null,{"$f":"IF(Q83<3,\"allow for moving compost and managing distinct batches.\", \"\")","v":"allow for moving compost and managing distinct batches."},null,null,null,null,null,null,null,"Number of composting bins w/ 3 min rule",{"$f":"IF(calcedNumBinsNeeded>=3, calcedNumBinsNeeded, 3)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," % bin system is over capacity",{"$f":"(binEfffectiveVolume-binsTotalVolumeNeeded)/binsTotalVolumeNeeded","v":{"$error":"#DIV/0!"}}]
[null,null,"Compost Facility Summary",null,null,null,null,"Recommendations"]
[null,null,null,null,"Number of bins needed for active composting",{"$f":"ROUND(calcedNumBinsMin3+0.49,0)","v":3},null,{"$f":"IF(Q80<=0,\"\", IF(Q81<Q80,O88,IF(AND(Q85>=0,Q85<=0.1),O89,O90)))","v":""},null,null,null,null,null,"%Over capacity",null,"recommendation text"]
[null,null,null,null,"Total number of bins needed",{"$f":"numBinsNeeded+BinNumStorageBins","v":4},null,null,null,null,null,null,null,"x< 0",{"$f":"\"Bin system volume is \"&ROUND(Q85*-100,0)&\"% too small to meet anticpated mortaility rate\"","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Total construction volume of bin system",{"$f":"binsConstructionVolume*ROUND(binsTotalBinsNeeded,0)","v":720}," ft3",null,null,null,null,null,null,"0<=x<=10%","Bin system volume is appropriately size for anticipated mortality rate"]
[null,null,null,null,"Total area of floor",{"$f":"binsTotalVolume/BinHeight","v":144}," ft2",null,null,null,null,null,null,"x>10%",{"$f":"\"Bin system volume is \"&ROUND(Q85*100,0)&\"% larger than needed to meet anticpated mortaility rate\"","v":{"$error":"#DIV/0!"}}]
[]
[null,"Composting System Plan Using Windrows"]
[null,null,"Design Parameters",null,null,null,null,null,null,null,null,null,null,null,null,"Total farm mortality per time = ",{"$f":"windrowFormationTime*MortalityPerDay*DaysPerMonth","v":0}]
[null,null,null,null,"Desired time to form a windrow and batch: ",2," months",{"$f":"\"Total farm mortality = \"&TEXT(ROUND(Q93,0),\"#,###\")&\" lb per \"&F94&\" months\"","v":"Total farm mortality =  lb per 2 months"},null,null,null,null,null,null,null,"Volume needed to fill windrows = ",{"$f":"totalMortality/TargetTissueDensity","v":0}," ft3"]
[null,null,null,null,"Windrow length: ",18," ft",{"$f":"\"Volume needed to fill windrow in desired time = \"&TEXT(ROUND(Q94,0),\"#,###\")&\" cubic ft\"","v":"Volume needed to fill windrow in desired time =  cubic ft"},null,null,null,null,null,null,null,"Effective volume of windrows = ",{"$f":"0.67*windrowWidth*compostHeight*windrowLength","v":1302.48}," ft3"]
[null,null,null,null,"Windrow width: ",18," ft",{"$f":"\"Effective volume of windrow = \"&TEXT(ROUND(Q95,0),\"#,###\")&\" cubic ft\"","v":"Effective volume of windrow = 1,302 cubic ft"},null,null,null,null,null,null,null,"calc'd # of windrows needed",{"$f":"((windrowsVolumeNeeded/windrowEffectiveVolume)+compostingDuration)/windrowFormationTime","v":2}]
[null,null,null,null,"Height of compost material: ",6," ft",null,null,null,null,null,null,null,null,"Number of windrows w/ 3 min rule",{"$f":"IF(calcedNumWindrows>=3, calcedNumWindrows, 3)","v":3}]
[null,null,null,null,"Duration of active composting in windrow/batch: ",4," months",null,null,null,null,null,null,null,null,"% windrows is over capacity",{"$f":"(windrowEffectiveVolume-windrowsVolumeNeeded)/windrowsVolumeNeeded","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Equipment working space or apron width: ",10," ft"]
[]
[null,null,"Compost Facility Summary",null,null,null,null,"Recommendations"]
[null,null,null,null,"Exact number of windrows needed",{"$f":"ROUND(calcedNumWindrowsMin3+0.49,0)","v":3},null,{"$f":"IF(Q94<=0,\"\", IF(Q95<Q94,O103,IF(AND(Q98>=0,Q98<=0.1),O104,O105)))","v":""},null,null,null,null,null,"%Over capacity",null,"recommendation text"]
[null,null,null,null,"Apron area needed to form and turn windrows",{"$f":"((windrowApronWidth*(numWindrowsNeeded+1))*(windrowLength+(2*windrowApronWidth)))+((windrowWidth*windrowApronWidth)*(numWindrowsNeeded*2))","v":2600}," ft2",null,null,null,null,null,null,"x< 0",{"$f":"\"Total windrow volume is \"&ROUND(Q98*-100,0)&\"% too small to meet anticpated mortaility rate\"","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Total efffective volume of system",{"$f":"windrowEffectiveVolume*numWindrowsNeeded","v":3907.44}," ft3",null,null,null,null,null,null,"0<=x<=10%","Total windrow volume is appropriately size for anticipated mortality rate"]
[null,null,null,null,"Size of pad including working space",{"$f":"(numWindrowsNeeded*windrowLength*windrowWidth) + windrowsApronArea","v":3572}," ft2",null,null,null,null,null,null,"x>10%",{"$f":"\"Total windrow volume is \"&ROUND(Q98*100,0)&\"% larger than needed to meet anticpated mortaility rate\"","v":{"$error":"#DIV/0!"}}]
[]
[null,"Composting System Plan Using Piles"]
[null,null,"Design Parameters",null,null,null,null,null,null,null,null,null,null,null,null,"Total farm mortality per time =",{"$f":"PilesFillTime*MortalityPerDay*DaysPerMonth","v":0}]
[null,null,null,null,"Desired time to form pile and establish a batch: ",1," months",{"$f":"\"Total farm mortality = \"&TEXT(ROUND(Q108,0),\"#,###\")&\" lb per \"&F109&\" month\"&IF(F109=1,\"\",\"s\")","v":"Total farm mortality =  lb per 1 month"},null,null,null,null,null,null,null,"Volume needed to construct piles =",{"$f":"pileTotalMortalityPerMonth/TargetTissueDensity","v":0}," ft3"]
[null,null,null,null,"Length of pile: ",12," ft",{"$f":"\"Volume needed to construct a pile in desired time = \"&TEXT(ROUND(Q109,0),\"#,###\")&\" cubic ft\"","v":"Volume needed to construct a pile in desired time =  cubic ft"},null,null,null,null,null,null,null,"Effective volume of piles =",{"$f":"pileWidth*pileHeight * (0.67*pileLength - TAN(RADIANS(30))*pileHeight)","v":492.65248989355132}," ft3"]
[null,null,null,null,"Width at base of pile: ",18," ft",{"$f":"\"Effective volume of a pile = \"&TEXT(ROUND(Q110,0),\"#,###\")&\" cubic ft\"","v":"Effective volume of a pile = 493 cubic ft"},null,null,null,null,null,null,null,"calc'd # of piles needed",{"$f":"(((pileTotalMortalityPerMonth/TargetTissueDensity)/pileEffectiveVolume)+pileCompostingDuration)/PilesFillTime","v":2}]
[null,null,null,null,"Height of compost material: ",8," ft",null,null,null,null,null,null,null,null,"Number of piles w/ 3 min rule",{"$f":"IF(calcedNumPiles>=3, calcedNumPiles, 3)","v":3}]
[null,null,null,null,"Duration of active composting for pile or batch: ",2," months",null,null,null,null,null,null,null,null,"% piles is over capacity",{"$f":"(pileEffectiveVolume-pileConstructionVolume)/pileConstructionVolume","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Equipment working space or apron width: ",10," ft"]
[]
[null,null,"Compost Facility Summary",null,null,null,null,"Recommendations"]
[null,null,null,null,"Total number of piles needed",{"$f":"ROUND(calcedNumPilesMin3+0.49,0)","v":3},null,{"$f":"IF(Q109<=0,\"\", IF(Q110<Q109,O118,IF(AND(Q113>=0,Q113<=0.1),O119,O120)))","v":""},null,null,null,null,null,"%Over capacity",null,"recommendation text"]
[null,null,null,null,"Apron area needed to form and turn piles",{"$f":"(2*(pileApronWidth) *((numPilesNeeded*pileLength)+(pileApronWidth*2))) + (2*(pileApronWidth*pileWidth))","v":1480}," ft2",null,null,null,null,null,null,"x< 0",{"$f":"\"Volume of piles is \"&ROUND(Q113*-100,0)&\"% too small to meet anticpated mortaility rate\"","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Total effective volume of piles",{"$f":"pileEffectiveVolume*numPilesNeeded","v":1477.957469680654}," ft3",null,null,null,null,null,null,"0<=x<=10%","Volume of piles is appropriately size for anticipated mortality rate"]
[null,null,null,null,"Size of pad, including working space",{"$f":"(numPilesNeeded*(pileLength*pileWidth))+pilesApronArea","v":2128}," ft2",null,null,null,null,null,null,"x>10%",{"$f":"\"Volume of piles is \"&ROUND(Q113*100,0)&\"% larger than needed to meet anticpated mortaility rate\"","v":{"$error":"#DIV/0!"}}]
[]
[null,"Composting System Plan Using Overlapping Piles"]
[null,null,"Design Parameters",null,null,null,null,null,null,null,null,null,null,null,null,"Total farm mortality per time =",{"$f":"overlapPilesFormTime*MortalityPerDay*DaysPerMonth","v":0}]
[null,null,null,null,"Desired time to form pile and batch: ",1," months",{"$f":"\"Total farm mortality = \"&ROUND(Q123,0)&\" lb per \"&F124&\" month\"&IF(F109=1,\"\",\"s\")","v":"Total farm mortality = 0 lb per 1 month"},null,null,null,null,null,null,null,"Volume needed to construct overlapping piles",{"$f":"overlapPilesTotalMortality/TargetTissueDensity","v":0}," ft3"]
[null,null,null,null,"Length of individual pile: ",20," ft",{"$f":"\"Volume needed to construct pile in desired time = \"&ROUND(Q124,0)&\" cubic ft\"","v":"Volume needed to construct pile in desired time = 0 cubic ft"},null,null,null,null,null,null,null,"Effective volume of overlapping piles =",{"$f":"overlapPilesWidth * overlapPilesHeight * ( 0.67*overlapPilesLength - TAN(RADIANS(30) ) * 0.5*overlapPilesHeight)","v":1774.4958277186397}," ft3"]
[null,null,null,null,"Width at base of individual pile: ",20," ft",{"$f":"\"Effective volume of pile = \"&ROUND(Q125,0)&\" cubic ft\"","v":"Effective volume of pile = 1774 cubic ft"},null,null,null,null,null,null,null,"calc'd # of overlapping piles needed",{"$f":"(overlapPilesTotalMortality/TargetTissueDensity/overlapPilesEffectiveVolume + overlapPilesCompostTime)/overlapPilesFormTime","v":2}]
[null,null,null,null,"Height of compost material: ",8," ft",null,null,null,null,null,null,null,null,"Number of piles w/ 3 min rule",{"$f":"IF(calcedNumOverlapPiles>=3, calcedNumOverlapPiles, 3)","v":3}]
[null,null,null,null,"Duration of active composting for pile or batch:  ",2," months",null,null,null,null,null,null,null,null,"% piles is over capacity",{"$f":"(overlapPilesEffectiveVolume-overlapPilesVolumeNeeded)/overlapPilesVolumeNeeded","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Equipment working space or apron width: ",10," ft"]
[]
[null,null,"Compost Facility Summary",null,null,null,null,"Recommendations"]
[null,null,null,null,"Total number of piles needed",{"$f":"ROUND(calcedNumOverlapPilesMin3+0.49,0)","v":3},null,{"$f":"IF(Q124<=0,\"\", IF(Q125<Q124,O133,IF(AND(Q128>=0,Q128<=0.1),O134,O135)))","v":""},null,null,null,null,null,"%Over capacity",null,"recommendation text",null,null,null,null,null,"Recommendation text for use case where <3 overlapping bins are needed"]
[null,null,null,null,"Apron area needed to form and turn piles",{"$f":"2*overlapPilesWidth*numOverlapPilesNeeded*overlapPilesApronWidth","v":1200}," ft2",null,null,null,null,null,null,"x< 0",{"$f":"\"System volume is \"&ROUND(Q128*-100,0)&\"% is too small to meet anticpated mortaility rate\"","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"\"System uses a 3 pile minimum.  Your volume only needs \"&ROUND(calcedNumOverlapPiles,1)&\" overlapping pile(s).\"","v":"System uses a 3 pile minimum.  Your volume only needs 2 overlapping pile(s)."}]
[null,null,null,null,"Total effective volume of piles",{"$f":"overlapPilesEffectiveVolume*numOverlapPilesNeeded","v":5323.4874831559191}," ft3",{"$f":"IF(calcedNumOverlapPiles<3,V133,\"\")","v":"System uses a 3 pile minimum.  Your volume only needs 2 overlapping pile(s)."},null,null,null,null,null,"0<=x<=10%","System volume is appropriately size for anticipated mortality rate"]
[null,null,null,null,"Area of pad or floor, including working space",{"$f":"numOverlapPilesNeeded*overlapPilesLength*overlapPilesWidth + overlapPilesApronArea","v":2400}," ft2",null,null,null,null,null,null,"x>10%",{"$f":"\"System volume is \"&ROUND(Q128*100,0)&\"% larger than needed to meet anticpated mortaility rate\"","v":{"$error":"#DIV/0!"}}]

{"sheet":"Hidden","index":2,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Producer type down down menu"]
[null,"None"]
[null,"Swine"]
[null,"Bovine"]
[null,"Small Ruminant"]
[null,"Poultry"]
[null,"Equine"]
[null,"Animal Tissue"]
[]
[null,"Facility type drop down menu"]
[null,"Display all types of facilities"]
[null,"Bins"]
[null,"Windrows"]
[null,"Piles"]
[null,"Overlapping piles"]
[]
[]
[null,"System Planner Sheet"]
[null,null,"Type of composting facility: ",1]
[null,null,"Type of producer: ",2]
[null,null,"Second type of producer: ",3]
[null,null,"Thirde type of producer: ",4]
[]
[]
[null,"Emergency Planner Sheet"]
[null,null,"Type of composting facility: ",1]
[]
[null,null,"Description","Value"]
[null,null,"swine motality checkbox",true]
[null,null,"bovine mortality checkbox",true]
[null,null,"poultry mortality checkbox",true]
[null,null,"equine mortality checkbox",true]
[null,null,"small ruminant mortality checkbox",true]

{"sheet":"Documentation","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Coming soon.  Rk"]