{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["Summary","Total Captured Yield","Harvested Yield","Purified Yield","Processed Yield","EXAMPLE"],"not_rendered":{"charts":1,"images":3,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Summary","index":0,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,9],[3,0,3,9],[1,0,1,9],[2,0,2,9],[17,0,17,2],[5,2,5,6],[6,2,6,6],[18,0,18,9],[20,1,20,2],[12,3,12,4],[41,1,41,2],[9,5,9,6],[13,3,13,4],[14,3,14,4],[21,1,21,2],[22,1,22,2],[23,1,23,2]],"flags":["formulas_cached_only"]}
["Yield Workbook"]
["FINAL FUEL YIELD SUMMARY"]
["Purpose: This workbook tracks conversion of biomass and the consituent elemental carbon from agricultural crop in the field to the final fuel product thus elucidating the overall annual energy and carbon yield of fuel per unit area of agricultural land."]
["Instructions: Fill in information in yellow fields ONLY on this page, all other cells are locked.  Click on the tabs at the bottom of the workbook to link to each of the other four spreadsheets.  The data in grey boxes at the top of each spreadsheet link to values on this 'Summary' spreadsheet- follow the instructions in the upper left-hand corner of each spreadsheet in this workbook to provide the data in each spreadsheet's grey box. Numbers that applicants supply in the grey boxes must be justified by showing all calculations, references, and experimental data along with relevant assumptions in the 'Calculations' area below each grey box.  After completing this workbook, applicants should upload this workbook in Microsoft Excel format along with their full application per the full application instructions."]
[]
[null,"Applicant:","<<applicant name>>"]
[null,"Organism:","<<organism designation>>"]
[]
[]
[null,null,"FINAL FUEL",null,"Designation:","<<final fuel designation>>"]
[]
[null,null,"Value","Units"]
[null,"Final fuel carbon yield:",1.5276689302325586,"tonne C·ha-1yr-1"]
[null,"Final fuel energy yield:",79.16902325581397,"GJ·ha-1yr-1"]
[null,"Fuel energy content:",51.82341650671785,"GJ/tonne C"]
[]
[]
["SUMMARY BREAKDOWN"]
[]
[null,null,null,"Total Biomass","Carbon","Units","% C","% Carbon Yield (overall)"]
[1,"Total Captured Yield",null,17.651660532532524,7.7,"tonne·ha-1yr-1",0.4362195831836147,0.154]
[2,"Harvested Yield",null,8.720930232558139,3.9,"tonne·ha-1yr-1",0.44720000000000004,0.078]
[3,"Purified Yield",null,6.688953488372093,2.6755813953488374,"tonne·ha-1yr-1",0.4000000000000001,0.05351162790697675]
[4,"Processed Yield",null,2.9321860465116285,1.5276689302325586,"tonne·ha-1yr-1",0.521,0.030553378604651172]
{"$rows_empty":17}
[null,"Max photosynthetic Carbon fixation:",null,50,"tonne·ha-1yr-1"]

{"sheet":"Total Captured Yield","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,6,12,7],[12,8,15,12],[19,5,20,12],[2,0,28,2],[33,0,33,2],[32,0,32,2],[29,0,29,2],[30,0,30,2],[31,0,31,2]],"flags":["formulas_cached_only"]}
["TOTAL CAPTURED YIELD BREAKDOWN"]
[]
["INSTRUCTIONS: Report the expected annual per hectare biomass and biomass carbon (i.e. carbon contained in all above and below ground biomass) yields for the entire organism. Provide references, calculations, and experimental data (if available) in the 'Calculations' section to justify your reported numbers in the grey box.  Note: sample calculations for corn have been provided.  You may modify and customize these entries/calculations or create your own as is appropriate for your organism after deleting the overlaid text box.  Please use the cell formatting as indicated below in the legend.",null,null,"TOTAL CAPTURED YIELD"]
[]
[{"$nulls":5},"Value","Units"]
[{"$nulls":5},17.651660532532524,"tonne captured biomass·ha-1yr-1"]
[{"$nulls":5},7.7,"tonne captured carbon·ha-1yr-1"]
[]
[]
[null,null,null,"CALCULATIONS"]
[{"$nulls":8},"Sources"]
[]
[{"$nulls":4},"Carbon content:",7.7,"tonne C·ha-1yr-1",null,"determined by eddy covariance data; Hollinger et al., “Carbon budget of mature no-till ecosystem in the North Central Region of the United States”, Ag & Forest Res. 2005, 130, 59-69."]
[]
[]
[]
[]
[null,null,null,"Plant Composition"]
[]
[{"$nulls":4},"Table Source: ","Latshaw, W.L.; Miller, E.C. “Elemental composition of the corn plant”, J. Agric. Res. 1924, 27, 845-861."]
[]
[]
[{"$nulls":4},"Plant Component","Dry Weight (kg)","% of Total Mass","% Carbon by wt","Carbon content (kg)"]
[{"$nulls":4},"Leaves",0.2346,0.28099173553719003,0.4127,0.09681942]
[{"$nulls":4},"Stems",0.2006,0.24026829560426397,0.4451,0.08928706]
[{"$nulls":4},"Grain",0.261,0.31261228889687387,0.4472,0.1167192]
[{"$nulls":4},"Roots",0.0605,0.07246376811594202,0.4231,0.025597549999999997]
[{"$nulls":4},"Cob",0.0782,0.09366391184573003,0.4575,0.0357765]
[]
["LEGEND",null,null,null,"TOTAL",0.8349000000000001,1,0.4362195831836147,0.36419972999999994]
["Applicant input"]
["Calculated value"]
["Calculated value from another tab"]
["Reference Value"]

{"sheet":"Harvested Yield","index":2,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,2],[37,0,37,2],[38,0,38,2],[7,6,7,9],[6,6,6,8],[35,0,35,2],[36,0,36,2],[25,6,26,11],[2,0,34,2],[35,4,35,5],[20,4,20,5],[2,3,2,11],[10,3,10,11],[13,3,13,11],[23,3,23,11],[5,6,5,8]],"flags":["formulas_cached_only"]}
["HARVESTED YIELD BREAKDOWN"]
[]
["INSTRUCTIONS: Report the expected annual per hectare harvested material produced and the carbon content of this material.  The harvested material represents the biomass removed from the field for purification/processing minus any biomass discarded before purification/processing. Provide references, calculations, and experimental data (if available) used to produce your reported numbers in the grey box.  Note: sample calculations for corn grain have been provided to the right.  You may modify and customize these entries/calculations or create your own as is appropriate for your organism after deleting the overlaid text box.  Please use the cell formatting as indicated below in the legend.",null,null,"HARVESTED YIELD"]
[]
[{"$nulls":5},"Value","Units"]
[{"$nulls":5},17.651660532532524,"tonne captured biomass·ha-1yr-1"]
[{"$nulls":5},8.720930232558139,"tonne harvested material·ha-1yr-1"]
[{"$nulls":5},3.9,"tonne harvested material carbon·ha-1yr-1"]
[]
[]
[null,null,null,"CALCULATIONS"]
[]
[]
[null,null,null,"Proportion of Total Plant Material that is harvested"]
[]
[{"$nulls":5},"Plant Component","% Wt of Dry Plant","% Carbon by Weight"]
[{"$nulls":5},"Grain",0.31261228889687387,0.4472]
[{"$nulls":5},"(extractives)",0,0]
[{"$nulls":5},"TOTAL",0.31261228889687387]
[{"$nulls":9},"Sources"]
[{"$nulls":4},"Grain carbon content:",null,3.9,"tonne C·ha-1yr-1",null,"Hollinger et al, see spreadsheet (1)"]
[]
[]
[null,null,null,"Harvested Material Composition"]
[]
[{"$nulls":5},"Table Source:","Bunge Milling “Typical Composition of Yellow Dent Corn,” downloaded on 1/5/10 from http://www.bungenorthamerica.com/news/pubs/03_Bunge_Milling_Process_Diagram.pdf"]
[]
[]
[{"$nulls":5},"Component","Weight %"]
[{"$nulls":5},"Endosperm",0.829]
[{"$nulls":5},"Germ",0.11]
[{"$nulls":5},"Bran",0.053]
[{"$nulls":5},"Tip",0.008]
[{"$nulls":5},"(extractives)",0]
[]
["LEGEND",null,null,null,"Fermentable Sugars:",null,0.767]
["Applicant input"]
["Calculation"]
["Calculated value from another tab"]
["Reference Value"]

{"sheet":"Purified Yield","index":3,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,33,2],[32,0,32,2],[2,0,28,2],[7,6,7,9],[29,0,29,2],[30,0,30,2],[31,0,31,2],[5,6,5,9],[6,6,6,9]],"flags":["formulas_cached_only"]}
["PURIFIED YIELD BREAKDOWN"]
[]
["INSTRUCTIONS: Report the expected annual per hectare purified material produced and the carbon content of this material.  The purified material represents the output of any preliminary refinement or processesing steps on the harvested material resulting in an intermediate product that is fed into the processing step to produce the final fuel.  This worksheet will vary greatly between different crops and final fuels. This step may involve processes such as separations (e.g. waste products from the harvested material) or chemical conversions (e.g. hydrolysis).  Provide references, calculations, and experimental data (if available) in the 'Calculations' section to justify your reported numbers in the grey box. Note: sample calculations for corn starch have been provided to the right.  You may modify and customize these entries/calculations or create your own as is appropriate for your processed material after deleting the overlaid text box.  Please use the cell formatting as indicated below in the legend.",null,null,"PURIFIED YIELD"]
[]
[{"$nulls":5},"Value","Units"]
[{"$nulls":5},8.720930232558139,"tonne harvested material·ha-1yr-1"]
[{"$nulls":5},6.688953488372093,"tonne purified material·ha-1yr-1"]
[{"$nulls":5},2.6755813953488374,"tonne purified material carbon·ha-1yr-1"]
[]
[]
[null,null,null,"CALCULATIONS"]
[]
[]
[{"$nulls":5},0.767,"(fermentable sugars in corn grain)"]
[]
[{"$nulls":4},"Assuming all fermentable sugars are glucose (C6H12O6) after starch hydrolysis:"]
[{"$nulls":5},"Carbon","Hydrogen","Oxygen"]
[{"$nulls":4},"#",6,12,6]
[{"$nulls":4},"Atomic Wt",12,1,16]
[{"$nulls":4},"g per element",72,12,96,180,"g/mol"]
[{"$nulls":4},"% element in sugar by wt",0.4,0.06666666666666667,0.5333333333333333]
{"$rows_empty":8}
["LEGEND"]
["Applicant input"]
["Calculation"]
["Calculated value from another tab"]
["Reference Value"]

{"sheet":"Processed Yield","index":4,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[[35,7,35,11],[12,7,12,15],[20,7,20,15],[23,3,23,5],[18,7,18,15],[14,7,14,15],[16,7,16,15],[17,7,17,15],[13,7,13,15],[46,0,46,2],[42,0,42,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[29,6,29,11],[30,6,30,11],[31,6,31,11],[2,0,41,2],[10,3,10,5]],"flags":["formulas_cached_only"]}
["PROCESSED YIELD BREAKDOWN"]
[]
["INSTRUCTIONS: Provide properties of the final fuel product (which may be a mixture) produced from the processing step that uses the purified material as its input.  Show any relevant calculations and data for the processing step and include a detailed list of the constituent molecules that comprise the final fuel.  Compounds that are present in trace amounts (<1% by weight) can be neglected for the purposes of this analysis.  For all energy contents, use the lower heating value (LHV).  Provide references, calculations, and experimental data (if available) in the 'Calculations' section to justify your reported numbers in the grey box. Note: sample calculations for corn grain ethanol have been provided.  You may modify and customize these entries/calculations or create your own as is appropriate for your final fuel after deleting the overlaid text box.  Please use the cell formatting as indicated below in the legend.",null,null,"OVERALL PROCESSED FUEL ENERGY YIELD"]
[]
[{"$nulls":5},"Value","Units"]
[{"$nulls":4},"Final fuel yield:",3711.6279069767443,"L·ha-1yr-1"]
[{"$nulls":4},"Final fuel yield:",2.9321860465116285,"tonne·ha-1yr-1"]
[{"$nulls":4},"Final fuel energy yield:",79.16902325581397,"GJ·ha-1yr-1"]
[{"$nulls":4},"Final fuel carbon yield:",1.5276689302325586,"tonne C·ha-1yr-1"]
[]
[null,null,null,"Bulk Properties of Final Fuel Mixture"]
[]
[{"$nulls":5},"Value","Units","Source"]
[{"$nulls":4},"Density:",0.79,"kg/L","Sigma-Aldrich MSDS"]
[{"$nulls":4},"Energy Content, LHV*:",27,"MJ/kg","ANL GREET Model (2008)"]
[{"$nulls":4},"Energy Density, LHV*:",21.330000000000002,"MJ/L"]
[{"$nulls":4},"Freezing Point (°C):",-144,"°C","Sigma-Aldrich MSDS"]
[{"$nulls":4},"Flash Point (°C):",14,"°C","Sigma-Aldrich MSDS"]
[{"$nulls":4},"Carbon content (wt% of final product):",0.521," -","single component product, carbon content = ethanol carbon content)"]
[]
[{"$nulls":4},"Energy Yield (GJ/tonne C):",51.82341650671785]
[]
[null,null,null,"* Lower Heating Value"]
[null,null,null,"CALCULATIONS"]
[]
[null,null,null,"Processing Step"]
[]
[{"$nulls":5},"Value","Units",{"$nulls":5},"Source"]
[]
[{"$nulls":5},8.720930232558139,"tonne harvested material·ha-1yr-1"]
[{"$nulls":5},425.6,"L EtOH/tonne corn grain",{"$nulls":5},"Bothast et al (2005) Appl Microbiol Biotechnol, 67, 19-25"]
[{"$nulls":5},3711.6279069767443,"L EtOH·ha-1yr-1"]
[]
[]
[null,null,null,"Chemical Composition of Final Fuel (Mixture)"]
[{"$nulls":7},"Chemical Formula"]
[{"$nulls":4},"Compound","Weight %","Molecular Weight (g/mol)","C","H","O","N","S","%C","Density (kg/L)","Energy Content, LHV (MJ/kg)"]
[{"$nulls":4},"ethanol",1,46.068,2,6,1,0,0,0.5214031431796475,0.789,27]
[{"$nulls":4},"(compound 2)"]
[{"$nulls":4},"(compound 3)"]
[]
[]
["LEGEND"]
["Applicant input"]
["Calculation"]
["Calculated value from another tab"]
["Reference Value"]

{"sheet":"EXAMPLE","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}