{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Emergency Planner","Hidden","Documentation"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":111,"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":89,"n_cols":2,"rows_kept":89,"cut":false,"hidden":false,"merged":[[8,1,8,2],[77,1,77,2],[79,1,79,2],[80,1,80,2],[71,1,71,2],[72,1,72,2],[73,1,73,2],[75,1,75,2],[76,1,76,2],[52,1,52,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[40,1,40,2],[41,1,41,2],[39,1,39,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[37,1,37,2],[38,1,38,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[22,1,22,2],[23,1,23,2],[61,1,61,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[2,1,2,2],[10,1,10,2],[12,1,12,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],[21,1,21,2],[17,1,17,2],[78,1,78,2],[1,1,1,2],[74,1,74,2],[82,1,82,2],[88,1,88,2],[86,1,86,2],[67,1,67,2],[69,1,69,2],[70,1,70,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[66,1,66,2],[58,1,58,2],[59,1,59,2],[60,1,60,2]]}
[]
[null,"Instructions for Spartan Emergency Animal Tissue Composting (ATC) Planner"]
[null,"v1.03"]
[]
[null,"1.  Overview"]
[null,"Spartan Emergency Animal Tissue Compost (ATC) Planner is an Excel application that assists in designing a composting system using static piling approaches, including facility type, facility size and material projections. The spreadsheet has been designed for composting animal tissue as whole carcasses."]
[null,"There are two general composting systems or methods which might be used for large single event composting of animal tissue in static piles: piled in bins (i.e. bunker silos or other configurations using walls to support and contain the composting materials) 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 Emergency ATC 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 and currently Manure and Organic Residual Management Consultant, Agri-Business Consultants, Dimondale, Michigan), Suzanne Reamer (Michigan Natural Resource Conservation Service), Dean Ross (Agrosecurity Consulting, Bath, Michigan) and Robert Kriegel (ANR Technology Services, Michigan State University)."]
[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 Spartan ATC Emergency 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 Emergency 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 Emergency Planner assists with planning and sizing of a single event composting system.  First, the program provides an estimate of amount of the expected amount of animal tissue using enterprise size, mortality rates specific to phases of animal production, and average carcass weights. More than one type of animal production enterprise can be entered into the planner. Second, Spartan ATC Emergency Planner assists with the sizing of a composting system to accommodate the estimated volume or pounds of mortality.  System foot print dimensions can be entered using the available space.  Up to four (4) different potential windrow sites can be entered and compared relative to is ability to contain a windrow composting system intended to redue a fixed volume or weight of animal carcasses."]
[null,"The Spartan ATC Emergency Planner delivers answers to several general questions, including:"]
[null," • Estimation of area required to compost a specific weight or number of mortalities (based on species and weights of animals, width and height of windrows or bin foot print, animal tissue density in the pile and equipment working space)."]
[null," • Determine the percentage of a defined space which will be required to compost a specific weight or number of mortalities (based on species and weights of animals, width and height of windrows or bin foot print, animal tissue density in the pile and equipment working space)."]
[null," • Determine the number and length of windrows required to compost a specific weight or number of mortalities  (based on species and weights of animals, width and height of windrows or bin foot print, animal tissue density in the pile and equipment working space)."]
[null," • Determine the amount of bulking agent mixture needed to compost the specific weight or number of mortalities."]
[null,"Input variables."]
[null," • Throughout the spreadsheet the green shaded cells signal locations for entering data into the spreadsheet (though in many cases default information representing best management practices is provided)."]
[null," • Information concering: species, production phase/age group, and average weight within production phase/age group."]
[null," • Data that can be entered when using bins: bin length, bin width, height of compost pile in the bin."]
[null," • Data can be entered when using windrows inlcudes: animal tissue density in the pile, height of the pile/windrow, width of windrow, length and width of up to four (4) potential composting sites, and desired equipment working space width."]
[]
[null,"Output."]
[null," • Number of carcasses & calculated pounds (lbs) of mortality by production phase/age group."]
[null," • Total calculated pounds (lbs) of mortality by species."]
[null," • For the bin composting system:"]
[null,"     ◦ Total weight of mortalities (across species on the farm)"]
[null,"     ◦ Total volume needed for composting"]
[null,"     ◦ Total construction volume of the bin"]
[null,"     ◦ Total floor area of the bin"]
[null,"     ◦ Effective volume of the bin (three sided bin)"]
[null,"     ◦ Bin capacity used, amount of amendment required."]
[null," • For the window composting system:"]
[null,"     ◦ Total weight of mortalities (across the farm)"]
[null,"     ◦ Windrow volume needed for current mortalities"]
[null,"     ◦ Amount of amendment needed for current mortalities"]
[null," • For the window composting system the following is reported for each of up to four (4) possible composting sites:"]
[null,"     ◦ Number of complete windrows available on the pad"]
[null,"     ◦ Exact number of windrows needed"]
[null,"     ◦ Total effective volume of all complete windrows"]
[null,"     ◦ Amount of amendment needed for current mortalities"]
[null,"     ◦ Apron area needed to form and turn windrows"]
[null,"     ◦ Area of pad including working space"]
[null,"     ◦ Maximum windrow length"]
[null,"     ◦ Available area including apron"]
[null,"     ◦ Percent of needed capacity"]
[null,"     ◦ Number of windrows available on the composting site"]
[null,"     ◦ Number of windrows short"]
[]
[null,"The Excel workbook contains the following two worksheets:"]
[null,"Instructions.  This sheet contains instructions for using the System Planner worksheet."]
[null,"Emergency 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 12 rows of the Emergency Planner worksheet enter the following general information about the farm or event:  "]
[null,"Name and address: Enter the enterprise name and address information for this plan."]
[null,"Select producer type: Using the checkboxes 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. If more than one animal production enterprise is selected, the amount of animal tissue will be a sum of all enterprises."]
[null,"Select type of composting system:  Using the drop-down list, select either the bin or windrow system type that will be used; or select both types for comparison.  The worksheet may be switched 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,"https://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.  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 Compost Emergency Planner default is 5 lb/ft3 in order to maximize composting system operations in all conditions.  The impact resulting from the input of other animal tissue density values should be carefully considered before committing to such a change. "]
[]
[null,"b.  Animal Production Information"]
[null,"In the next portion of the Emergency Planner worksheet green shaded cells are provided for you enter production information for estimating animal tissue accumulation.  More than one animal species can be included in the tissue accumulation calculations of a single worksheet.  For specific help with understanding what information is being requested, a comment will appear when the cursor hovers over the name of the item for which a number is being requested."]
[]
[null,"c.  Composting Systems Plan (Bin or Windrows)"]
[null,"The next portion of the Emergency Planner provides green shaded cells for entering:"]
[null,"1. The types of composting system to be used (bin or windrows or both)."]
[null,"2. The dimensions of the composting structure."]
[null,"a. Bin:  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, or the windrow and working space dimensions."]
[null,"b. Windrow: Windrow width, windrow height or equipment working space (apron width).  Each dimension is described in a comment that will appear when the cursor is placed over the name of the measure or the windrow and working space conditions."]
[null,"c. Windrow Composting Sites: When evaluating or using windrow composting, the worksheet will require the input of the overall dimensions of at least one (1) and up to a total of four (4) potential composting sites when comparing sites.  The dimensions are listed as Length and Width.  Where one dimension is greater than the other, the longer dimension should be entered in to Length input cell for that site."]
[]
[null,"d.  Composting Systems Results Reporting"]
[null,"1.  Mortality to Amendment Relationships: The Spartan ATC Emergency Planner worksheet will provide calculated information for: Total weight of animal mortality, compost volume needed for total mortality, and amount of compost amendments needed.  This information is provided regardless of composting system(s) selected."]
[null,"2.  Bin System: The Spartan ATC Emergency Planner worksheet will provide calculated information for: Total volume of bin system, Total area of floor, Effective volume of bin, and Bin capacity used.  If Bin capacity exceeds 100%, the bin is insufficient in size to contain the entire mortality available.  Other mortality disposal methods will be required for any excess."]
[null,"3. Windrow System: The Spartan ATC Emergency Planner worksheet will provide calculated information for each site that has information entered into it: Available area, windrow length, Exact number of windrows needed, Number of windrows rounded up, Number of windrows available at site, Number of windrows short, Working space needed to manage windrows, Total area of pad needed, Projected width of site given available length, and Percent of mortality that could be composted at site."]
[]
[null,"Printing:  Spartan ATC Emergency Planner prints out plans as one page in portrait orientation."]
[]
[null,"Notes and definitions:"]
[]
[null,"Duration of active composting in bin: In well-managed active composting, the decomposition of all soft tissues should take 1 to 2 months.  Bones will not decompose in this time.  Time required to decompoase tissues is dependent on the maturity of the animals.  Mature swine hides will persist 1 to 2 months longer than this; longer than those of mature bovine or equine, and all other soft tissues."]
[]
[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."]

{"sheet":"Emergency Planner","index":1,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[[54,2,54,4],[2,7,2,9],[3,3,3,4],[3,7,3,9],[4,3,4,4],[4,7,4,9],[27,2,27,4],[36,2,36,4],[45,2,45,4],[2,3,2,4],[5,3,5,4]]}
[null,null,null,null,null,null,"Spartan Emergency ATC Planner Worksheet",null,null,null,null,null,null," ------> THESE COLUMNS WILL BE HIDDEN IN FINAL VERSIONS  -------------------------------->"]
[]
[null,null,"Date: ",null,null,null,"Address: ",null,null,null,null,null,null,null,null,"farm mortality",null,"carcass volume"]
[null,null,"Name: ",null,null,null,null,null,null,null,null,null,null,null,"Swine produccer:",{"$f":"IF(UseSwineMortality,swineMortality,0)","v":0},null,{"$f":"IF(UseSwineMortality,swineVolume,0)","v":0}]
[null,null,"Phone: ",null,null,null,null,null,null,null,null,null,null,null,"Bovine producer:",{"$f":"IF(useBovineMortality,bovineMortality,0)","v":0},null,{"$f":"IF(useBovineMortality,bovineVolume,0)","v":0}]
[null,null,"Fax: ",null,null,null,null,null,null,null,null,null,null,null,"Poultry producer:",{"$f":"IF(usePoultryMortality,poultryMortality,0)","v":0},null,{"$f":"IF(usePoultryMortality,poultryVolume,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equine producer;",{"$f":"IF(useEquineMortality,equineMortality,0)","v":0},null,{"$f":"IF(useEquineMortality,equineVolume,0)","v":0}]
[null,"Select specie(s) of mortality:",null,null,null,null,"     Select type of composting system:",null,null,null,null,null,null,null,"Small ruminant producer:",{"$f":"IF(useSmallRuminantMortality,ruminantMortality,0)","v":0},null,{"$f":"IF(useSmallRuminantMortality,ruminantVolume,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total farm mortality: ",{"$f":"SUM(P4:P8)","v":0}," lb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total compost volume: ",{"$f":"EmergencyFarmMortality/TargetTissueDensity","v":0}," ft3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total carcass volume: ",{"$f":"SUM(R4:R8)","v":0}," ft3","ft3 / yard: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total amendment volume: ",{"$f":"EmergencyTissueVolume-emergencyCarcassVolume","v":0}," ft3",null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total amendment volume: ",{"$f":"P13/cubicFtPerYard","v":0},"yd3"]
[null,null,null,"Target animal tissue density: ",5," lb/ft3",{"$f":"IF(E15>15,\"Michigan regulations require animal tissue density <= 15 lb per cubic ft\",\"\")","v":""},null,null,null,null,null,null,null,"  <= input a density > 15 and see what happens"]
[]
[null,"Swine Mortality Information"]
[]
[null,null,null,"Item",null,"Sows & Litters","Breeding Herd","Nursery","Wean-Finish","Grow-Finish",null,null,null,null,"Swine carcass weight = ",1694," lb/yard"]
[null,null,null,null,"Number of carcasses: ",0,0,0,0,0,null,null,null,null,"Animal density = ",{"$f":"SwineCarcassWt/cubicFtPerYard","v":62.74074074074074}," lb/ft3"]
[null,null,null,null,"Average weight of animals (lb): ",500,450,40,125,150,null,null,null,null,"Animal volume = ",{"$f":"swineMortality/swineDensity","v":0}," ft3"]
[null,null,null,null,"Calculated mortality (lb): ",{"$f":"F20*F21","v":0},{"$f":"G20*G21","v":0},{"$f":"H20*H21","v":0},{"$f":"I20*I21","v":0},{"$f":"J20*J21","v":0}]
[null,null,null,null,"Total swine mortality: ",{"$f":"SUM(F22:J22)","v":0}," lb"]
[]
[]
[null,"Bovine Mortality Information"]
[]
[null,null,"Item",null,null,"Cows","Calves","Heifers","Feeder Cattle",null,null,null,null,null,"bovine carcass weight = ",1761," lb/yard"]
[null,null,null,null,"Number of carcasses: ",0,0,0,0,null,null,null,null,null,"Animal density = ",{"$f":"BovineCarcassWt/cubicFtPerYard","v":65.222222222222229}," lb/ft3"]
[null,null,null,null,"Average weight of animals (lb): ",1200,110,600,850,null,null,null,null,null,"Animal volume = ",{"$f":"bovineMortality/bovineDensity","v":0}," ft3"]
[null,null,null,null,"Calculated mortality (lb): ",{"$f":"F29*F30","v":0},{"$f":"G29*G30","v":0},{"$f":"H29*H30","v":0},{"$f":"I29*I30","v":0}]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F31:I31)","v":0}," lbs"]
[]
[]
[null,"Poultry Mortality Information"]
[]
[null,null,"Item",null,null,"Layers","Turkeys","Others"]
[null,null,null,null,"Number of carcasses: ",0,0,0,null,null,null,null,null,null,"Poultry carcass weight = ",{"$f":"5714/7.14","v":800.280112044818}," lb/yard"]
[null,null,null,null,"Average weight of animals during phase (lb): ",6,15,6,null,null,null,null,null,null,"Animal density = ",{"$f":"PoultryCarcassWt/cubicFtPerYard","v":29.640004149808075}," lb/ft3"]
[null,null,null,null,"Calculated mortality (lb): ",{"$f":"F38*F39","v":0},{"$f":"G38*G39","v":0},{"$f":"H38*H39","v":0},null,null,null,null,null,null,"Animal volume = ",{"$f":"poultryMortality/poultryDensity","v":0}," ft3"]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F40:H40)","v":0}," lbs"]
[]
[]
[null,"Equine Mortality Information"]
[]
[null,null,"Item",null,null,"Adults","Foals",null,null,null,null,null,null,null,"Equine carcass weight = ",1700," lb/yard"]
[null,null,null,null,"Number of carcasses: ",0,0,null,null,null,null,null,null,null,"Animal density = ",{"$f":"EquineCarcassWt/cubicFtPerYard","v":62.962962962962962}," lb/ft3"]
[null,null,null,null,"Average weight of animals (lb): ",1500,200,null,null,null,null,null,null,null,"Animal volume = ",{"$f":"equineMortality/equineDensity","v":0}," ft3"]
[null,null,null,null,"Calculated mortality (lb): ",{"$f":"F47*F48","v":0},{"$f":"G47*G48","v":0}]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F49:G49)","v":0}," lb"]
[]
[]
[null,"Small Ruminant Mortality Information"]
[]
[null,null,"Item",null,null,"Adults","Juveniles",null,null,null,null,null,null,null,"Small ruminant carcass weight = ",1400," lb/yard"]
[null,null,null,null,"Number of carcasses: ",0,0,null,null,null,null,null,null,null,"Animal density = ",{"$f":"RuminantCarcassWt/cubicFtPerYard","v":51.851851851851855}," lb/ft3"]
[null,null,null,null,"Average weight of animals (lb): ",120,40,null,null,null,null,null,null,null,"Animal volume = ",{"$f":"ruminantMortality/ruminantDensity","v":0}," ft3"]
[null,null,null,null,"Calculated mortality (lb): ",{"$f":"F56*F57","v":0},{"$f":"G56*G57","v":0}]
[null,null,null,null,"Total farm mortality: ",{"$f":"SUM(F58:I58)","v":0}," lbs"]
[]
[]
[null,"Mortality to Amendment Relationships"]
[]
[null,null,null,null,"Total weight of mortality:",{"$f":"EmergencyFarmMortality","v":0}," lb"]
[null,null,null,null,"Compost volume needed for total mortality: ",{"$f":"EmergencyTissueVolume","v":0}," ft3"]
[null,null,null,null,"Amount of compost amendment(s) needed: ",{"$f":"AmendmentVolume","v":0}," yd3"]
[]
[]
[null,"Composting System Plan Using a Bin"]
[null,null,"Design Parameters",null,null,null,null,null,null,null,null,null,null,null,"Hidden bin calculations"]
[null,null,null,null,"Bin length: ",200," ft",null,null,null,null,null,null,null,null,"Effective volume of bin = ",{"$f":"(eBinWidth*eDepth*eBinLength) - (eBinWidth*TAN(RADIANS(30))*(eDepth^2)/2)","v":79076.239569296595}," ft3"]
[null,null,null,null,"Bin width: ",50," ft",null,null,null,null,null,null,null,null,"Total volume = ",{"$f":"eBinLength*eBinWidth*eDepth","v":80000}," ft3"]
[null,null,null,null,"Material depth: ",8," ft",null,null,null,null,null,null,null,null,"bin capacity used = ",{"$f":"EmergencyTissueVolume*100/eBinEffVolume","v":0},"%"]
[]
[null,null,"Compost Facility Summary"]
[null,null,null,null,"Total volume of bin system:",{"$f":"eBinConstructionVolume","v":80000}," ft3"]
[null,null,null,null,"Total area of floor:",{"$f":"eBinConstructionVolume/eDepth","v":10000}," ft2"]
[null,null,null,null,"Effective volume of bin:",{"$f":"eBinEffVolume","v":79076.239569296595}," ft3"]
[null,null,null,null,"Bin capacity used:",{"$f":"eBineCapacityUsed","v":0},"%"]
[]
[null,"Composting System Plan Using Windrows",null,null,null,null,null,null,null,null,null,null,null,null,"Hidden windrow calculations"]
[null,null,"Design Parameters"]
[null,null,null,null,"Windrow width: ",20," ft",null,null,null,null,null,null,null,null,"length of 1 windrow = ",{"$f":"ROUNDUP(EmergencyTissueVolume/(0.67*widthWindrow*heightMaterial),0)","v":0}," ft"]
[null,null,null,null,"Height of compost material: ",8," ft",null,null,null,null,null,null,null,null,null,null,null,"length = ",{"$f":"Q83+2*workingSpaceWidth","v":40},null,"width = ",{"$f":"ROUNDUP(widthWindrow+2*workingSpaceWidth,0)","v":60},null,"area =",{"$f":"T84*W84","v":2400}]
[null,null,null,null,"Equipment working space (width): ",20," ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"acres =",{"$f":"ROUNDUP(Z84 / 43560,1)","v":0.1}]
[]
[null,null,{"$f":"\"All mortality could be composted using one windrow on a pad \"&T84&\" ft long X \"&W84&\" ft wide, i.e. \"&Z85&\" acres.\"","v":"All mortality could be composted using one windrow on a pad 40 ft long X 60 ft wide, i.e. 0.1 acres."},null,null,null,null,null,null,null,null,null,null,null,null,null,"Site 1",null,"Site 2",null,"Site 3",null,"Site 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effective volume of 1 windrow = ",{"$f":"0.67*windrow1Length*widthWindrow*heightMaterial","v":27872.000000000004}," ft3",{"$f":"0.67*windrow2Length*widthWindrow*heightMaterial","v":38592}," ft3",{"$f":"0.67*windrow3Length*widthWindrow*heightMaterial","v":0}," ft3",{"$f":"0.67*windrow4Length*widthWindrow*heightMaterial","v":0}," ft3"]
[null,null,"Evaluating Potential Sites for Windrows",null,null,"site 1",null,"site 2",null,"site 3",null,"site 4"]
[null,null,null,null,"available length: ",300," ft",400," ft",0," ft",0," ft"]
[null,null,null,null,"available width: ",0," ft",0," ft",0," ft",0," ft",null,null,"Effective volume, all complete windrows = ",{"$f":"effVolume1Windrow*numWindrowsRounded","v":0}," ft3",{"$f":"effVolume2Windrow*NumWindrows2Rounded","v":0}," ft3",{"$f":"effVolume3Windrow*NumWindrows3Rounded","v":0}," ft3",{"$f":"effVolume4Windrow*NumWindrows4Rounded","v":0}," ft3"]
[]
[null,null,null,null,"Available area:",{"$f":"AvailLength*AvailWidth","v":0}," ft2",{"$f":"AvailLength2*AvailWidth2","v":0}," ft2",{"$f":"AvailLength3*AvailWidth3","v":0}," ft2",{"$f":"AvailLength4*AvailWidth4","v":0}," ft2",null,"All caution output if windrow width*0.67 < windrow height"]
[null,null,null,null,"Windrow length:",{"$f":"IF(AvailLength>0,AvailLength-2*workingSpaceWidth,0)","v":260}," ft",{"$f":"IF(AvailLength2>0,AvailLength2-2*workingSpaceWidth,0)","v":360}," ft",{"$f":"IF(AvailLength3>0,AvailLength3-2*workingSpaceWidth,0)","v":0}," ft",{"$f":"IF(AvailLength4>0,AvailLength4-2*workingSpaceWidth,0)","v":0}," ft"]
[null,null,null,null,"Exact number of windrows needed:",{"$f":"IF(effVolume1Windrow>0,EmergencyTissueVolume/effVolume1Windrow,0)","v":0},null,{"$f":"IF(effVolume2Windrow>0,EmergencyTissueVolume/effVolume2Windrow,0)","v":0},null,{"$f":"IF(effVolume3Windrow>0,EmergencyTissueVolume/effVolume3Windrow,0)","v":0},null,{"$f":"IF(effVolume4Windrow>0,EmergencyTissueVolume/effVolume4Windrow,0)","v":0}]
[null,null,null,null,"Number of windrows, rounded up:",{"$f":"ROUNDUP(NumWindRowsNeeded,0)","v":0},null,{"$f":"ROUNDUP(NumWindrows2Needed,0)","v":0},null,{"$f":"ROUNDUP(NumWindrows3Needed,0)","v":0},null,{"$f":"ROUNDUP(NumWindrows4Needed,0)","v":0}]
[null,null,null,null,"Number of windrows available at site:",{"$f":"IF(numWindrowsRounded>0,AvailArea/(Windrow1PadArea/numWindrowsRounded),0)","v":0},null,{"$f":"IF(NumWindrows2Rounded>0,AvailArea2/(Windrow2PadArea/NumWindrows2Rounded),0)","v":0},null,{"$f":"IF(NumWindrows3Rounded>0,AvailArea3/(Windrow3PadArea/NumWindrows3Rounded),0)","v":0},null,{"$f":"IF(NumWindrows4Rounded>0,AvailArea4/(Windrow4PadArea/NumWindrows4Rounded),0)","v":0}]
[null,null,null,null,"Number of windrows short:",{"$f":"IF(NumWindRowsNeeded>AvailWindrows,NumWindRowsNeeded-AvailWindrows,0)","v":0},null,{"$f":"IF(NumWindrows2Needed>AvailWindrows2,NumWindrows2Needed-AvailWindrows2,0)","v":0},null,{"$f":"IF(NumWindrows3Needed>AvailWindrows3,NumWindrows3Needed-AvailWindrows3,0)","v":0},null,{"$f":"IF(NumWindrows4Needed>AvailWindrows4,NumWindrows4Needed-AvailWindrows4,0)","v":0}]
[null,null,null,null,"Working space area needed to manage windrows:",{"$f":"((workingSpaceWidth*(numWindrowsRounded+1))*(windrow1Length+(2*workingSpaceWidth)))+((widthWindrow*workingSpaceWidth)*(numWindrowsRounded*2))","v":6000}," ft2",{"$f":"((workingSpaceWidth*(NumWindrows2Rounded+1))*(windrow2Length+(2*workingSpaceWidth)))+((widthWindrow*workingSpaceWidth)*(NumWindrows2Rounded*2))","v":8000}," ft2",{"$f":"((workingSpaceWidth*(NumWindrows3Rounded+1))*(windrow3Length+(2*workingSpaceWidth)))+((widthWindrow*workingSpaceWidth)*(NumWindrows3Rounded*2))","v":800}," ft2",{"$f":"((workingSpaceWidth*(NumWindrows4Rounded+1))*(windrow4Length+(2*workingSpaceWidth)))+((widthWindrow*workingSpaceWidth)*(NumWindrows4Rounded*2))","v":800}," ft2"]
[null,null,null,null,"Total area of pad needed:",{"$f":"(numWindrowsRounded*windrow1Length*widthWindrow) + Windrow1ApronArea","v":6000}," ft2",{"$f":"(NumWindrows2Rounded*windrow2Length*widthWindrow) + Windrow2ApronArea","v":8000}," ft2",{"$f":"(NumWindrows3Rounded*windrow3Length*widthWindrow) + Windrow3ApronArea","v":800}," ft2",{"$f":"(NumWindrows4Rounded*windrow4Length*widthWindrow) + Windrow4ApronArea","v":800}," ft2"]
[null,null,null,null,"Projected width of site given available length:",{"$f":"ROUNDUP(Windrow1PadArea/(windrow1Length+2*workingSpaceWidth),0)","v":20}," ft",{"$f":"ROUNDUP(Windrow2PadArea/(windrow2Length+2*workingSpaceWidth),0)","v":20}," ft",{"$f":"ROUNDUP(Windrow3PadArea/(windrow3Length+2*workingSpaceWidth),0)","v":20}," ft",{"$f":"ROUNDUP(Windrow4PadArea/(windrow4Length+2*workingSpaceWidth),0)","v":20}," ft"]
[null,null,null,null,"Percent of mortality that could be composted at site:",{"$f":"(AvailArea/Windrow1PadArea)*100","v":0}," %",{"$f":"(AvailArea2/Windrow2PadArea)*100","v":0}," %",{"$f":"(AvailArea3/Windrow3PadArea)*100","v":0}," %",{"$f":"(AvailArea4/Windrow4PadArea)*100","v":0}," %"]

{"sheet":"Hidden","index":2,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Producer type down down menu"]
[null,"None"]
[null,"Swine"]
[null,"Bovine"]
[null,"Poultry"]
[null,"Equine"]
[null,"Processor by-product"]
[]
[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: ",5]
[null,null,"Thirde type of producer: ",6]
[]
[]
[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,"Still need to write documentation.  Rk"]