{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Interface","Calculations","Comparison Chart","Percentages","Regional Maps"],"not_rendered":{"charts":4,"images":18,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Comparison Chart","index":3,"reason":"not_a_worksheet"},{"sheet":"Percentages","index":4,"reason":"not_a_worksheet"}],"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":"Introduction","index":0,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null," Carbon Footprint Estimation Toolkit For Poultry On-Farm Emissions"]
[]
[null,"This toolkit is designed to be used by poultry producers to estimate the greenhouse gas emissions from their poultry farms."]
[]
[null,"Instructions for Use"]
[null,"\nTo use this tool, go to the Interface worksheet by clicking on Interface (in green) tab at the bottom left corner of the screen. While on the Interface screen, please enter required data under Farm Information section as well as \nEnergy Consumption section. \nBe sure to click on the cells labeled \"click here\" to select your option from the drop down menu. While selecting your region under Electricity consumption, you may click on the button labeled \"See Map\" to see the Regional and Sub-regional maps. Similarly, while you are done visiting the Maps page, you may click on the button labeled \"Go Back to Main Screen\" to return to the main (Interface) screen.\nAs you enter data, the program starts calculating and updating results. Once all input data are entered, you will see the complete results for the current year.\nA series of recommendations designed to reduce energy consumption for your farm operation are listed. Now, you may see how implementing these recommendations will affect the numbers for the following year. Select as many recommendations as you would like and click on the button labeled \"Show Projections\" for the following year. You may select one recommendation, all recommendations, or any combination in-between. They do not necessarily have to be implemented all at one time. Now you should see the numbers under Projected Year reflecting energy savings.\nNOTE: To protect the worksheet formulae from accidental modification or deletion, portions of the worksheet not used for data entry are protected. Thus, data entry or any modifications are not allowed in those areas."]
[]
[null,"Recommendations"]
[null,"Research have shown that no two poultry farms, has the exact same carbon footprint. As such, recommendations"]
[null,"can only be made based on the specific farm and not based on the size of the footprint."]
[null,"The recommendations are designed to reduce energy use by reducing kilo-watt usage and LPG and diesel use. "]
[null,"These reductions will in turn result in a reduction in the carbon footprint of the farm."]
[]
[null,"Source of emission factors and global warming potential are IPCC 2006 Report and EFDB (emission factor data base). "]
[]
[]
[null,"Definitions "]
[]
[null,"CO2: Carbon dioxide"]
[null,"CH4: Methane"]
[null,"N2O: Nitrous Oxide"]
[null,"LPG use: emissions from stationary sources such heaters and incinerators."]
[null,"Diesel use: emissions from sources such as equipment used in the operation (tractors, generators ect.)"]
[null,"Purchased electricity: emissions from electricity due to usage on farm."]
[null,"CO2e Tonnes: metric tonnes of carbon dioxide equivalent."]
[null,"AAP: Annual average population"]
[null,"NAPA: number of animals produced annually"]
[null,"NEX: Annual average nitrogen excretion"]
[null,"NEMMS: Nitrogen excretion from manure management system"]
[null,"Nvol-MMS: Nitrogen losses due to volatization from manure management"]
[null,"TAM: Typical animal mass"]
[]
[null,"Global Warming Potential"]
[null,"CO2: 1"]
[null,"CH4: 25"]
[null,"N2O: 298"]
[]
[]
[null,"Global Warming Potentials are taken from IPCC 2006."]

{"sheet":"Interface","index":1,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[35,1,35,10],[1,1,1,4],[8,1,8,3],[2,10,16,10],[2,1,2,3],[16,1,16,3],[19,10,34,10],[0,1,0,10],[17,1,17,10],[18,1,18,10],[20,6,20,9],[20,1,21,1],[15,2,15,3],[20,2,20,5],[3,2,3,3],[9,2,9,3],[19,6,19,9],[19,2,19,5],[2,4,16,9],[1,6,1,9]]}
[null,"Poultry GHG Estimation Tool"]
[]
[null,"Farm Information"]
[null,"Select type of birds →","(click here)"]
[null,"# of Houses"]
[null,"# of Birds per House"]
[null,{"$f":"IF(C4=\"Broilers\",\"# of Flocks per Year\",\"\")","v":""}]
[null,{"$f":"IF(C4=\"Broilers\",\"# of Days to raise Flock\",\"\")","v":""}]
[]
[null,null,"Year"]
[null,"Energy Consumption","Current","Projected"]
[null,"LPG (gal)"]
[null,"Diesel (gal)"]
[null,"Natural Gas (ccf)"]
[null,"Electricity (kWh)"]
[null,"Select your region →","(click here)"]
[]
[null,"Greenhouse Gas Inventory"]
[null,"GHG Emissions (metric tonnes)"]
[null,null,"Year",null,null,null,"Year"]
[null,"Emissions Categories","Current Year",null,null,null,"Projected Year"]
[null,null,"CO2","CH4","N2O","CO2e","CO2","CH4","N2O","CO2e"]
[null,"On-farm sources: Mechanical"]
[null,"Deisel Use",{"$f":"Calculations!C100","v":0},{"$f":"Calculations!D100","v":0},{"$f":"Calculations!E100","v":0},{"$f":"Calculations!F100","v":0},{"$f":"Calculations!G100","v":0},{"$f":"Calculations!H100","v":0},{"$f":"Calculations!I100","v":0},{"$f":"Calculations!J100","v":0}]
[null,"LPG Use",{"$f":"Calculations!C101","v":0},{"$f":"Calculations!D101","v":0},{"$f":"Calculations!E101","v":0},{"$f":"Calculations!F101","v":0},{"$f":"Calculations!G101","v":0},{"$f":"Calculations!H101","v":0},{"$f":"Calculations!I101","v":0},{"$f":"Calculations!J101","v":0}]
[null,"Total",{"$f":"C24+C25","v":0},0,0,0,0,0,0,0]
[null,"On-farm sources: Non-mechanical"]
[null,"Enteric fermentation",{"$f":"Calculations!C104","v":"-"},{"$f":"Calculations!D104","v":"-"},{"$f":"Calculations!E104","v":"-"},{"$f":"Calculations!F104","v":"-"},{"$f":"Calculations!G104","v":"-"},{"$f":"Calculations!H104","v":"-"},{"$f":"Calculations!I104","v":"-"},{"$f":"Calculations!J104","v":"-"}]
[null,"Manure management",{"$f":"Calculations!C105","v":"-"},{"$f":"Calculations!D105","v":0},{"$f":"Calculations!E105","v":0},{"$f":"Calculations!F105","v":0},{"$f":"Calculations!G105","v":"-"},{"$f":"Calculations!H105","v":0},{"$f":"Calculations!I105","v":0},{"$f":"Calculations!J105","v":0}]
[null,"Total",{"$f":"SUM(C28:C29)","v":0},{"$f":"SUM(D28:D29)","v":0},0,0,0,0,0,0]
[null,"On-farm sources Total",{"$f":"C26+C30","v":0},{"$f":"D26+D30","v":0},{"$f":"E26+E30","v":0},{"$f":"F26+F30","v":0},{"$f":"G26","v":0},{"$f":"H26+H30","v":0},{"$f":"I26+I30","v":0},{"$f":"J26+J30","v":0}]
[]
[null,"Off-farm sources: Electricity used",{"$f":"Calculations!C109","v":0},{"$f":"Calculations!D109","v":0},{"$f":"Calculations!E109","v":0},{"$f":"Calculations!F109","v":0},{"$f":"Calculations!G109","v":0},{"$f":"Calculations!H109","v":0},{"$f":"Calculations!I109","v":0},{"$f":"Calculations!J109","v":0}]
[]
[null,"Farm Total",{"$f":"C31+C33","v":0},{"$f":"D31+D33","v":0},0,0,0,0,0,0]

{"sheet":"Calculations","index":2,"n_rows":131,"n_cols":21,"rows_kept":131,"cut":false,"hidden":true,"merged":[[0,2,0,8],[107,1,107,9],[94,1,96,1],[94,2,94,9],[95,2,95,5],[95,6,95,9],[97,1,97,9],[98,1,98,9],[4,4,4,5],[15,4,15,5],[102,1,102,9],[3,4,3,5],[79,6,79,7],[4,17,4,20],[120,5,120,6],[121,5,121,6],[122,5,122,6],[1,2,1,3],[2,2,2,3],[115,2,116,5],[60,1,60,4],[119,5,119,6],[78,1,78,5],[68,1,68,4],[118,5,118,7],[91,1,91,9],[28,4,28,6]]}
[null,null,"Poultry GHG Estimation Tool"]
[null,"Name of Farm"]
[null,"Company"]
[null,null,null,null,"Mechanical Sources"]
[null,null,null,null,"Fuel Use",null,null,null,null,null,null,null,null,null,null,null,null,"Emission Factors"]
[null,"Source","Gal LPG","t LPG","CO2","CH4"," N2O","CO2e Tonnes",null,null,null,null,null,null,null,null,null,"Sub-Regions","CO2","CH4","N20"]
["Current Year","LPG",{"$f":"Interface!C12","v":0},{"$f":"C7/415.503","v":0},{"$f":"D7*63.1","v":0},{"$f":"D7*0.005","v":0},{"$f":"D7*0.0001","v":0},{"$f":"E7+F7+G7","v":0},null,null,null,null,null,null,null,null,null,"(click here)"]
["Projected Year",null,{"$f":"Interface!D12","v":0},{"$f":"C8/415.503","v":0},{"$f":"D8*63.1","v":0},{"$f":"D8*0.005","v":0},{"$f":"D8*0.0001","v":0},{"$f":"E8+F8+G8","v":0},null,null,null,null,null,null,null,null,null,"ASCC-Alaska Grid",0.55898777799999999,1.16121E-5,2.9517099999999999E-6]
[null,null,"Gal Diesel","t diesel",null,null,null,null,null,null,null,null,null,null,null,null,null,"ASCC-Miscellaneous",0.226278545,9.4129900000000005E-6,1.8493E-6]
["Current Year","Diesel",{"$f":"Interface!C13","v":0},{"$f":"C10/285.75","v":0},{"$f":"D10*(75*0.044)","v":0},{"$f":"D10*(0.45*0.044)","v":0},{"$f":"D10*(0.08*0.044)","v":0},{"$f":"E10+F10+G10","v":0},null,null,null,null,null,null,null,null,null,"ASCC-Sub-region unknown",0.49432224299999999,1.00847E-5,2.7374299999999998E-6]
["Projected Year",null,{"$f":"Interface!D13","v":0},{"$f":"C11/285.75","v":0},{"$f":"D11*(75*0.044)","v":0},{"$f":"D11*(0.45*0.044)","v":0},{"$f":"D11*(0.08*0.044)","v":0},{"$f":"E11+F11+G11","v":0},null,null,null,null,null,null,null,null,null,"ERCT-All",0.60071491899999996,8.4576800000000006E-6,6.8559099999999997E-6]
[null,null,"CCF NG","t NG",null,null,null,null,null,null,null,null,null,null,null,null,null,"FRCC-All",0.59809397200000003,2.08307E-5,7.6844000000000005E-6]
["Current Year","Natural Gas",{"$f":"Interface!C14","v":0},null,{"$f":"D13*45.22","v":0},{"$f":"D13*0.1","v":0},{"$f":"D13*0.1","v":0},{"$f":"E13+F13+G13","v":0},null,null,null,null,null,null,null,null,null,"HICC Miscellaneous",0.78517469699999998,7.5024540000000003E-5,1.35889E-5]
["Projected Year",null,{"$f":"Interface!D14","v":0},null,{"$f":"D14*45.22","v":0},{"$f":"D14*0.1","v":0},{"$f":"D14*0.1","v":0},{"$f":"E14+F14+G14","v":0},null,null,null,null,null,null,null,null,null,"HICC Oahu",0.78517469699999998,7.50245E-5,1.35889E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HICC Sub-region Unknown",0.78517469699999998,7.50245E-5,1.35889E-5]
[null,null,null,null,"Electricity Use",null,null,null,null,null,null,null,null,null,null,null,null,"MRO East",0.83221472100000005,1.2515599999999999E-5,8.2064799999999994E-5]
[null,null,"                      Consumption Data",null,null,null,null,"                       Emissions",null,null,null,null,null,null,null,null,null,"MRO Sub-region Unknown",0.78517469699999998,7.50245E-5,1.35889E-5]
[null,"Region","Amount","Units","CO2","CH4","N2O","CO2","CH4","N2O","Tonnes CO2e",null,null,null,null,null,null,"MRO West",0.826374901,1.27005E-5,1.37723E-5]
["Current Year",{"$f":"Interface!C16","v":"(click here)"},{"$f":"Interface!C15","v":0},"kwh",{"$f":"VLOOKUP(Calculations!B19,Calculations!$R$7:$U$40,2)","v":0},{"$f":"VLOOKUP(Calculations!B19,Calculations!$R$7:$U$40,3)","v":0},{"$f":"VLOOKUP(Calculations!B19,Calculations!$R$7:$U$40,4)","v":0},{"$f":"C19*N18/1000","v":0},{"$f":"C19*(O18*25)/1000","v":0},{"$f":"C19*(P18*298)/1000","v":0},{"$f":"H19+I19+J19","v":0},null,null,0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5,null,"NPCC Long Island",0.69708247800000001,5.2351200000000001E-5,8.8064799999999997E-6]
["Projected Year",{"$f":"Interface!C16","v":"(click here)"},{"$f":"Interface!D15","v":0},"kwh",{"$f":"VLOOKUP(Calculations!B20,Calculations!$R$7:$U$40,2)","v":0},{"$f":"VLOOKUP(Calculations!B20,Calculations!$R$7:$U$40,3)","v":0},{"$f":"VLOOKUP(Calculations!B20,Calculations!$R$7:$U$40,4)","v":0},{"$f":"C20*N19/1000","v":0},{"$f":"C20*(O19*25)/1000","v":0},{"$f":"C20*(P19*298)/1000","v":0},0,null,null,0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5,null,"NPCC New England",0.420789205,3.9233000000000002E-5,7.71447E-6]
[null,null,null,null,null,null,null,{"$f":"C21*N20/1000","v":0},{"$f":"C21*(O20*25)/1000","v":0},{"$f":"C21*(P20*298)/1000","v":0},0,null,null,0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5,null,"NPCC NYC/Westchester",0.36988271499999997,1.63403E-5,2.47503E-6]
[null,null,null,null,null,null,null,{"$f":"C19*N21/1000","v":0},{"$f":"C19*(O21*25)/1000","v":0},{"$f":"C19*(P21*298)/1000","v":0},0,null,null,0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5,null,"NPCC Subregion Unknown",0.82721150600000004,1.2673999999999999E-5,1.3905499999999999E-5]
[null,null,null,null,null,null,null,{"$f":"C20*N22/1000","v":0},{"$f":"C20*(O22*25)/1000","v":0},{"$f":"C20*(P22*298)/1000","v":0},0,null,null,0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5,null,"NPCC Upstate NY",0.32694865499999998,1.12582E-5,5.0771000000000001E-6]
[null,null,null,null,null,null,null,{"$f":"C24*N23/1000","v":0},{"$f":"C24*(O23*25)/1000","v":0},{"$f":"C24*(P23*298)/1000","v":0},0,null,null,0.8894690096010951,1.0803209476290001E-5,1.4553556550686999E-5,null,"RFC East",0.51667554699999996,1.37312E-5,8.4888000000000008E-6]
[null,null,null,null,null,null,null,{"$f":"C25*N24/1000","v":0},{"$f":"C25*(O24*25)/1000","v":0},{"$f":"C25*(P24*298)/1000","v":0},0,null,null,0.75211792874079397,1.1330057014045E-5,1.0253500883087001E-5,null,"RFC Michigan",0.70909206199999997,1.53916E-5,1.23242E-5]
[null,null,null,null,null,null,null,{"$f":"C26*N25/1000","v":0},{"$f":"C26*(O25*25)/1000","v":0},{"$f":"C26*(P25*298)/1000","v":0},0,null,null,0.32845535232363698,1.3715045695505E-5,3.6631212616459995E-6,null,"RFC Sub-region Unknown",0.39722916400000002,2.7469100000000001E-5,6.1460400000000004E-6]
[null,null,null,null,null,null,null,{"$f":"C27*N26/1000","v":0},{"$f":"C27*(O26*25)/1000","v":0},{"$f":"C27*(P26*298)/1000","v":0},0,null,null,null,null,null,null,"SERC Midwest",0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SERC Mississippi Valley",0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5]
[null,null,null,null,"Non-Mechanical Sources",null,null,null,null,null,null,null,null,null,null,null,null,"SERC South",0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5]
[null,null,null,null,null,"Manure Management",null,null,null,null,null,null,null,null,null,null,null,"SERC Sub-region Unknown",0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5]
[null,null,null,null,"Bird Information",null,null,null,null,null,null,null,null,null,null,null,null,"SERC Tennessee Valley",0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5]
[null,"Broilers APP","AAP=Avg#birds per flock*#flock per year*#days to raise flock/365",null,"Birds/flock(farm)","flocks/year","days to raise flock","days/year","# houses","birds/house",null,null,null,null,null,null,null,"SERC Virginia/Carolina",0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5]
["Current Year",null,null,null,{"$f":"I33*J33","v":0},{"$f":"IF(Interface!C4=\"Broilers\",Interface!C7,0)","v":0},{"$f":"IF(Interface!C4=\"Broilers\",Interface!C8,0)","v":0},365,{"$f":"IF(Interface!C4=\"Broilers\",Interface!C5,0)","v":0},{"$f":"IF(Interface!C4=\"Broilers\",Interface!C6,0)","v":0},null,null,null,null,null,null,null,"SPP North",0.8894690096010951,1.0803209476290001E-5,1.4553556550686999E-5]
["Projected Year",null,null,null,{"$f":"E33","v":0},{"$f":"F33","v":0},0,365,{"$f":"I33","v":0},{"$f":"J33","v":0},null,null,null,null,null,null,null,"SPP South",0.75211792874079397,1.1330057014045E-5,1.0253500883087001E-5]
[null,"Breeders APP","AAP=days alive*NAPA/365",null,null,"Farm capacity (birds)","days alive","days/year","# houses","birds/house",null,null,null,null,null,null,null,"SPP Sub-region Unknown",0.62090191148092799,1.0577139039082001E-5,1.0224788486066001E-5]
["Current Year",null,null,null,{"$f":"(G36*F36)/365","v":0},{"$f":"I36*J36","v":0},455,335,{"$f":"IF(Interface!C4=\"Breeders\",Interface!C5,0)","v":0},{"$f":"IF(Interface!C4=\"Breeders\",Interface!C6,0)","v":0},null,null,null,null,null,null,null,"WECC California",0.32845535232363698,1.3715045695505E-5,3.6631212616459995E-6]
["Projected Year",null,null,null,{"$f":"(G37*F37)/365","v":0},{"$f":"I37*J37","v":0},455,335,{"$f":"I36","v":0},{"$f":"J36","v":0},null,null,null,null,null,null,null,"WECC Northwest",0.40924931599999997,8.6771800000000008E-6,6.7584399999999998E-6]
[null,"Pullets APP","AAP=days alive*NAPA/365",null,null,"Farm capacity (birds)","days alive","days/year","# houses","birds/house",null,null,null,null,null,null,null,"WECC Rockies",0.85415108299999998,1.0380100000000001E-5,1.30411E-5]
["Current Year",null,null,null,{"$f":"(G39*F39)/365","v":0},{"$f":"I39*J39","v":0},147,335,{"$f":"IF(Interface!C4=\"Pullets\",Interface!C5,0)","v":0},{"$f":"IF(Interface!C4=\"Pullets\",Interface!C6,0)","v":0},null,null,null,null,null,null,null,"WECC Southwest",0.59468241300000002,7.9171799999999996E-6,8.1356300000000006E-5]
["Projected Year",null,null,null,{"$f":"(G40*F40)/365","v":0},{"$f":"I40*J40","v":0},147,335,{"$f":"I39","v":0},{"$f":"J39","v":0},null,null,null,null,null,null,null,"WECC Sub-region Unknown",0.79440902199999996,1.11679E-5,1.1577500000000001E-5]
[null,"Direct N2O Emissions"]
[]
[null,"Livestock Category","AAP","Nitrogen excretion rate","TAM","NEX","MS","NEMMS","EF","kg N2O ","Tonnes CO2e"]
["Current Year","Broilers",{"$f":"(G33*E33*F33)/365","v":0},1.1000000000000001,0.9,{"$f":"D44*E44*0.001*365","v":0.36135000000000006},1,{"$f":"C44*F44*G44","v":0},1E-3,{"$f":"H44*I44*44/28","v":0},{"$f":"J44*0.001*298","v":0}]
["Projected Year","Broilers",{"$f":"(G34*E34*F34)/365","v":0},1.1000000000000001,0.9,{"$f":"D45*E45*0.001*365","v":0.36135000000000006},1,{"$f":"C45*F45*G45","v":0},1E-3,0,0]
["Current Year","Breeders",{"$f":"(F36*G36)/H36","v":0},0.83,0.9,{"$f":"D46*E46*0.001*365","v":0.27265500000000004},1,{"$f":"C46*F46*G46","v":0},1E-3,0,0]
["Projected Year","Breeders",{"$f":"(F37*G37)/H37","v":0},0.83,0.9,0.27265500000000004,1,0,1E-3,0,0]
["Current Year","Pullets",{"$f":"(F39*G39)/H39","v":0},0.62,0.9,0.20367000000000002,1,0,1E-3,0,0]
["Projected Year","Pullets",{"$f":"(F40*G40)/H40","v":0},0.62,0.9,0.20367000000000002,1,0,1E-3,0,0]
[]
[null,"Indirect N2O Emissions"]
[]
[null,"Livestock","NEMMS","FRAC","Nvol-mms","EF","kg N2O",null,null,null,"Tonnes CO2e"]
["Current Year","Broilers",{"$f":"H44","v":0},{"$f":"40%","v":0.4},{"$f":"C54*D54","v":0},0.01,{"$f":"E54*F54*44/28","v":0},null,null,null,{"$f":"G54*0.001*298","v":0}]
["Projected Year","Broilers",0,{"$f":"40%","v":0.4},0,0.01,{"$f":"E55*F55*44/28","v":0},null,null,null,0]
["Current Year","Breeders",0,{"$f":"40/100","v":0.4},0,0.01,{"$f":"E56*F56*44/28","v":0},null,null,null,0]
["Projected Year","Breeders",0,0.4,0,0.01,0,null,null,null,0]
["Current Year","Pullets",0,0.4,0,0.01,{"$f":"E58*F58*44/28","v":0},null,null,null,0]
["Projected Year","Pullets",0,0.4,0,0.01,{"$f":"E59*F59*44/28","v":0},null,null,null,0]
[]
[null,"Total N2O Emissions form manure Management"]
["Current Year","Broiler",{"$f":"K44+K54","v":0}]
["Projected Year","Broiler",0]
["Current Year","Breeder",0]
["Projected Year","Breeder",0]
["Current Year","Pullet",0]
["Projected Year","Pullet",0]
[]
[null,"Total CH4 Emissions From Manure Management"]
[]
[null,"Livestock","AAP","EF","Gg CH4manure","Tonnes CH4",null,"Tonnes CO2e"]
["Current Year","Broiler",{"$f":"C44","v":0},0.02,{"$f":"C72*D72*0.000001","v":0},{"$f":"E72*1000","v":0},null,{"$f":"F72*25","v":0}]
["Projected Year","Broiler",0,0.02,{"$f":"C73*D73*0.000001","v":0},{"$f":"E73*1000","v":0},null,0]
["Current Year","Breeder",0,0.03,{"$f":"C74*D74*0.000001","v":0},{"$f":"E74*1000","v":0},null,0]
["Projected Year","Breeder",0,0.03,0,0,null,0]
["Current Year","Pullets",0,0.02,0,0,null,0]
["Projected Year","Pullets",0,0.02,0,0,null,0]
[]
[null,"Total Emissions from Manure Management"]
[null,null,null,null,null,null,"GHG Input"]
[null,"Livestock","N2O","CH4","Tonnes CO2e",null,"N2O","CH4"]
["Current Year","Broiler",{"$f":"C62","v":0},{"$f":"H72","v":0},{"$f":"C82+D82","v":0},null,{"$f":"C82+C84+C86","v":0},{"$f":"D82+D84+D86","v":0}]
["Projected Year","Broiler",0,0,{"$f":"C83+D83","v":0},null,{"$f":"C83+C85+C87","v":0},{"$f":"D83+D85+D87","v":0}]
["Current Year","Breeder",0,0,{"$f":"C84+D84","v":0}]
["Projected Year","Breeder",0,0,0]
["Current Year","Pullets",0,0,0]
["Projected Year","Pullets",0,0,0]
[]
[]
[]
[]
[null,"GREENHOUSE GAS INVENTORY "]
[]
[]
[null,"Emissions Categories","GHG Emissions (metric tonnes)"]
[null,null,"Current Year",null,null,null,"Projected Year"]
[null,null,"CO2","CH4","N2O","CO2e","CO2","CH4","N2O","CO2e"]
[null,"Scope 1"]
[null,"Mechanical"]
[null,"Deisel Use",{"$f":"E10","v":0},{"$f":"F10","v":0},{"$f":"G10","v":0},{"$f":"H10","v":0},{"$f":"E11","v":0},{"$f":"F11","v":0},{"$f":"G11","v":0},{"$f":"H11","v":0}]
[null,"LPG Use",{"$f":"E7","v":0},{"$f":"F7","v":0},{"$f":"G7","v":0},{"$f":"H7","v":0},{"$f":"E8","v":0},{"$f":"F8","v":0},{"$f":"G8","v":0},{"$f":"H8","v":0}]
[null,"Total",{"$f":"C100+C101","v":0},0,0,0,0,0,0,0]
[null,"Non-mechanical"]
[null,"Enteric fermentation","-","-","-","-","-","-","-","-"]
[null,"Manure management","-",{"$f":"H82","v":0},{"$f":"G82","v":0},{"$f":"D105+E105","v":0},"-",{"$f":"H83","v":0},{"$f":"G83","v":0},{"$f":"H105+I105","v":0}]
[null,"Total",0,{"$f":"D105","v":0},{"$f":"E105","v":0},{"$f":"F105","v":0},0,{"$f":"H105","v":0},{"$f":"I105","v":0},{"$f":"H106+I106","v":0}]
[null,"Total Scope 1",{"$f":"C102+C106","v":0},{"$f":"D102+D106","v":0},{"$f":"E102+E106","v":0},{"$f":"F102+F106","v":0},{"$f":"G102","v":0},{"$f":"H102+H106","v":0},{"$f":"I102+I106","v":0},{"$f":"J102+J106","v":0}]
[null,"Scope 2"]
[null,"Purchased Electricity",{"$f":"H22","v":0},{"$f":"I22","v":0},{"$f":"J22","v":0},{"$f":"K22","v":0},{"$f":"H23","v":0},{"$f":"I23","v":0},{"$f":"J23","v":0},{"$f":"K23","v":0}]
[null,"Total   Scope 2",{"$f":"C109","v":0},0,0,0,0,0,0,0]
[null,"Total Scopes",{"$f":"C107+C110","v":0},0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null," CHARTS"]
[]
[]
[null,null,"Current Emissions","Projected Emissions"]
[null,"Diesel Use",{"$f":"F100","v":0},{"$f":"J100","v":0}]
[null,"LPG Use",{"$f":"F101","v":0},{"$f":"J101","v":0}]
[null,"Manure Management",{"$f":"F105","v":0},{"$f":"J106","v":0}]
[null,"Purchased Electricity",{"$f":"F109","v":0},{"$f":"J110","v":0}]
[null,null,{"$f":"SUM(C120:C123)","v":0},{"$f":"SUM(D120:D123)","v":0}]
[]
[]
[null,null,"Current Emissions","Projected Emissions"]
[null,"Diesel Use",{"$f":"(C120/C124)*100","v":{"$error":"#DIV/0!"}},{"$f":"(D120/D124)*100","v":{"$error":"#DIV/0!"}}]
[null,"LPG Use",{"$f":"(C121/C124)*100","v":{"$error":"#DIV/0!"}},{"$f":"(D121/D124)*100","v":{"$error":"#DIV/0!"}}]
[null,"Manure Management",{"$f":"(C122/C124)*100","v":{"$error":"#DIV/0!"}},{"$f":"(D122/D124)*100","v":{"$error":"#DIV/0!"}}]
[null,"Purchased Electricity",{"$f":"(C123/C124)*100","v":{"$error":"#DIV/0!"}},{"$f":"(D123/D124)*100","v":{"$error":"#DIV/0!"}}]

{"sheet":"Regional Maps","index":5,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,4,33,7],[1,4,1,6]]}
[]
[null,null,null,null,"Regional Map"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Sub-Regional Map"]