{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Welcome","Vineyard","Nitrogen Calculator","Vineyard Results","Vineyard Benchmark","Winery","Winery Results","Winery Benchmark","Lists","Scope 3 advice page","Factors","Images"],"not_rendered":{"charts":2,"images":34,"macros":1,"external_links":0,"defined_names":28,"comments":4,"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":"Welcome","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,1,10,14],[20,1,22,14],[23,1,23,6],[14,1,14,14]]}
[]
[]
[]
[null,"Welcome to the Australian Grape and Wine Carbon Calculator. This tool is designed to help grapegrowers and winemakers estimate their direct (Scope 1 & 2) greenhouse gas emissions. This free Excel version is maintained by the AWRI. A more interactive version, which includes customisable benchmarking reports, is integrated into Sustainable Winegrowing Australia. \n\nSustainable Winegrowing Australia is the Australian wine industry’s sustainability program - set up to support growers and winemakers in demonstrating and improving the sustainability of their businesses. The program covers the fundamental components of sustainability (environmental, social and economic) and can be applied to both the vineyard and winery. It provides benchmarking tools and resources to enable planning, evaluation, control and communication.\n\nA sample of the benchmarking features offered by Sustainable Winegrowing Australia is provided in this spreadsheet. To take advantage of these benchmarking features, consider becoming a member of the program. For more information or to join up, visit the Sustainable Winegrowing Australia website:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"www.sustainablewinegrowingaustralia.com.au"]
[]
[null,"**Note that this tool requires macros to be enabled. A security alert may have popped up when you opened this file. If so, you can enable the content from there. Otherwise, go to Excel Options > Trust Centre > Trust Centre Settings > Macro Settings > Select \"Disable all macros with notification\", then reopen the file. "]
[]
[]
[]
[]
[]
[null,"The tool is based on the methodologies of the Australian National Greenhouse Gas Accounts (2022) and the latest global warming potentials from IPCC AR6 (2021). This calculator does not attempt to estimate offsite Scope 3 emissions (packaging, distribution, oak, etc). These are best calculated through accepted Life Cycle Analysis methodologies. "]
[]
[]
[null,"More information can be found on the Scope 3 advice page"]

{"sheet":"Vineyard","index":1,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Question","Input","Unit","Help"]
[]
[null,"Vineyard"]
[null,"Vineyard area",null,"ha"]
[null,"Tonnes grapes harvested",null,"t"]
[null,"Vine area unharvested",null,"ha"]
[null,"Biodiversity area",null,"ha"]
[]
[null,"Electricity"]
[null,"Purchased electricity",null,"kWh"]
[null,"Generated electricity",null,"kWh"]
[]
[null,"State (determines electricity grid)"]
[]
[null,"Fuel use"]
[null,"Off-road petrol",null,"L"]
[null,"Off-road diesel",null,"L"]
[null,"Off-road LPG",null,"L"]
[null,"Off-road biodiesel",null,"L"]
[]
[null,"Vineyard floor management"]
[null," How much of your vineyard area is covered by each option listed below?"]
[null,"Permanent cover crop native",null,"ha"]
[null,"Permanent cover crop non-native",null,"ha"]
[null,"Permanent cover crop volunteer sward",null,"ha"]
[null,"Annual cover crop",null,"ha"]
[null,"Bare soil",null,"ha"]
[null,"Area covered",{"$f":"SUM(C25:C28)/C6","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(AND(SUM(C25:C29)<>C6,COUNTBLANK(C25:C29)<5),\"Warning - Area does not match vineyard area recorded above\",\"\")","v":""}]
[null,"Irrigation types"]
[null,"How many ha are irrigated under each irrigation type?"]
[null,"Irrigation type - Dripper",null,"ha"]
[null,"Irrigation type - Undervine sprinkler",null,"ha"]
[null,"Irrigation type - Overhead sprinkler",null,"ha"]
[null,"Irrigation type - Flood",null,"ha"]
[null,"Irrigation type - Non-irrigated",null,"ha"]
[null,"Area irrigated ",{"$f":"SUM(C34:C37)/C6","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(AND(SUM(C34:C38)<>C6,COUNTBLANK(C34:C38)<5),\"Warning - Area does not match vineyard area recorded above\",\"\")","v":""}]
[]
[null,"Water source"]
[null,"How much water is taken from each source listed below?"]
[null,"River water",null,"ML",null,null,null,null,null,null,false]
[null,"Groundwater",null,"ML",null,null,null,null,null,null,false]
[null,"Dams or tanks",null,"ML"]
[null,"Recycled water from winery",null,"ML"]
[null,"Recycled water from other source",null,"ML"]
[null,"Mains water",null,"ML"]
[null,"Other water",null,"ML"]
[null,"Total water used",{"$f":"SUM(C44:C50)","v":0},"ML"]
[]
[]
[null,"Fertilisers"]
[]
[null,"I know how much N I apply"]
[]
[null,"Synthetic nitrogen (including urea)",null,"kg N"]
[null,"Organic nitrogen",null,"kg N"]
[null,"Urea",null,"kg Urea"]
[]
[null,"Why do I have to report urea twice?"]
[]
[null,"-- OR -- "]
[]
[null,"I know how much fertiliser I apply. Help me calculate N:"]
[]
[]
[null,"Synthetic nitrogen (including urea)",{"$f":"'Nitrogen Calculator'!C48","v":0},"kg N"]
[null,"Organic nitrogen",{"$f":"'Nitrogen Calculator'!C49","v":0},"kg N"]
[null,"Urea",{"$f":"'Nitrogen Calculator'!C50","v":0},"kg Urea"]

{"sheet":"Nitrogen Calculator","index":2,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Synthetic fertilisers"]
[null,"Please enter the mass of each synthetic fertliser applied to the vineyard. "]
[null,"If liquid fertilisers were used, please use the density to convert volume to mass. "]
[null,"There is space at the bottom for extra fertilisers if what you need isn't listed."]
[]
[null,"Fertiliser","Applied (kg)","Nitrogen %","Urea %"]
[null,"Anhydrous ammonia",null,0.82]
[null,"Ammonium polyphosphate",null,0.1]
[null,"Ammonium sulfate",null,0.21]
[null,"Ammonium nitrate",null,0.33]
[null,"Calcium nitrate",null,0.15]
[null,"Potassium nitrate",null,0.13]
[null,"Monoammonium phosphate",null,0.11]
[null,"Diammonium phosphate",null,0.18]
[null,"Urea",null,0.46,1]
[null,"Urea ammonium nitrate",null,0.32,0.35]
[]
[]
[]
[]
[]
[null,"Organic fertilisers"]
[null,"Please enter the wet mass of each organic fertiliser type applied to the vineyard"]
[null,"There is space at the bottom for extra fertilisers if what you need isn't listed."]
[null,"If you don't know the nitrogen content, try Google searching \"[name] nitrogen content\""]
[]
[null,"Fertiliser","Applied (kg)","Nitrogen %",null,"*Please note the organic fertiliser Nitrogen (%) figures stated are estimates. "]
[null,"Blood and bone",null,9.0999999999999998E-2]
[null,"Vegetable wastes",null,1.4999999999999999E-2]
[null,"Broiler litter",null,1.7010000000000001E-2]
[null,"Grass clippings",null,1.7000000000000001E-2]
[null,"Cattle (dairy) manure",null,1.3500000000000002E-2]
[null,"Horse manure",null,8.0000000000000002E-3]
[null,"Non-legume hay",null,1.1700000000000002E-2]
[null,"Tree prunings",null,8.0000000000000002E-3]
[null,"Straw",null,6.1599999999999997E-3]
[null,"Softwood sawdust",null,8.0000000000000015E-4]
[null,"Hardwood sawdust",null,4.8000000000000001E-4]
[null,"Newspaper",null,3.7600000000000003E-4]
[]
[]
[]
[]
[]
[null,"Total synthetic nitrogen",{"$f":"SUMPRODUCT(C10:C22,D10:D22)","v":0},"kg"]
[null,"Total organic nitrogen",{"$f":"SUMPRODUCT(C31:C45,D31:D45)","v":0},"kg"]
[null,"Total urea",{"$f":"SUMPRODUCT(C10:C22,E10:E22)","v":0},"kg"]
[]
[null,"(Total nitrogen)",{"$f":"C48+C49","v":0},"kg"]
[null,"(Average nitrogen per ha)",{"$f":"C52/Vineyard!C6","v":{"$error":"#DIV/0!"}},"kg/ha"]

{"sheet":"Vineyard Results","index":3,"n_rows":82,"n_cols":7,"rows_kept":82,"cut":false,"hidden":false,"merged":[[8,2,8,4],[80,0,80,10],[81,0,81,10],[3,2,3,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[56,6,56,7]]}
[]
[]
[]
[]
[]
[null,"Grapes harvested",{"$f":"Vineyard!C7","v":0},null,null,"t"]
[null,"Vineyard area",{"$f":"Vineyard!C6","v":0},null,null,"ha"]
[null,"Yield",{"$f":"C6/C7","v":{"$error":"#DIV/0!"}},null,null,"t/ha"]
[]
[]
[null,"Site inputs"]
[]
[null,null,"Total use","Use per t","Use per ha","Unit"]
[]
[null,"Water",{"$f":"Vineyard!C51:C51","v":0},{"$f":"C15/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C15/$C$7","v":{"$error":"#DIV/0!"}},"ML"]
[null,"Nitrogen",{"$f":"IF(COUNTA(Vineyard!C58:C60)>0,Vineyard!C58+Vineyard!C59,Vineyard!C69+Vineyard!C70)","v":0},{"$f":"C16/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C16/$C$7","v":{"$error":"#DIV/0!"}},"kg N"]
[]
[null,"Electricity"]
[null,"Purchased electricity",{"$f":"Vineyard!C12","v":0},{"$f":"C19/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C19/$C$7","v":{"$error":"#DIV/0!"}},"kWh"]
[null,"Generated electricity",{"$f":"Vineyard!C13","v":0},{"$error":"#DIV/0!"},{"$f":"C20/$C$7","v":{"$error":"#DIV/0!"}},"kWh"]
[]
[null,"Fuels"]
[null,"Petrol",{"$f":"Vineyard!C18","v":0},{"$f":"C23/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C23/$C$7","v":{"$error":"#DIV/0!"}},"L"]
[null,"Diesel",{"$f":"Vineyard!C19","v":0},{"$f":"C24/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C24/$C$7","v":{"$error":"#DIV/0!"}},"L"]
[null,"LPG",{"$f":"Vineyard!C20","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"L"]
[null,"Biodiesel",{"$f":"Vineyard!C21","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"L"]
[]
[null,"Greenhouse gas emissions"]
[]
[null,null,"Total Emission","Emission per t","Emission per ha","Unit"]
[]
[null,"Scope 1"]
[null,"Fuel use "]
[null,"Petrol",{"$f":"Vineyard!C18*VLOOKUP(B34,Fuels,2,0)","v":0},{"$f":"C34/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C34/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,"Diesel",{"$f":"Vineyard!C19*VLOOKUP(B35,Fuels,2,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"LPG",{"$f":"Vineyard!C20*VLOOKUP(B36,Fuels,2,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Biodiesel",{"$f":"Vineyard!C21*VLOOKUP(B37,Fuels,2,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Total",{"$f":"SUM(C34:C37)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[]
[]
[null,"Fertiliser emissions"]
[null,"Nitrous oxide",{"$f":"IF(COUNTA(Vineyard!C58:C60)>0,Vineyard!C58*(Vineyard!C39*Factors!C40+(1-Vineyard!C39)*Factors!C42)+Vineyard!C59*(Vineyard!C39*Factors!C41+(1-Vineyard!C39)*Factors!C43),Vineyard!C69*(Vineyard!C39*Factors!C40+(1-Vineyard!C39)*Factors!C42)+Vineyard!C70*(Vineyard!C39*Factors!C41+(1-Vineyard!C39)*Factors!C43))","v":{"$error":"#DIV/0!"}},{"$f":"C42/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C42/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,"Urea hydrolysis",{"$f":"IF(COUNTA(Vineyard!C58:C60)>0,Vineyard!C60,Vineyard!C71)*Factors!C44","v":0},{"$f":"C43/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C43/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,"Total",{"$f":"SUM(C42:C43)","v":{"$error":"#DIV/0!"}},{"$f":"C44/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C44/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[]
[]
[null,"Scope 2"]
[null,"Electricity"]
[null,"Purchased electricity",{"$f":"Vineyard!C12*VLOOKUP(Vineyard!C15,Electricity,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"C49/$C$6","v":{"$error":"#N/A"}},{"$f":"C49/$C$7","v":{"$error":"#N/A"}},"kg CO2e"]
[null,"Generated electrcity",0,{"$f":"C50/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C50/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,"Total",{"$f":"SUM(C49:C50)","v":{"$error":"#N/A"}},{"$f":"SUM(D49:D50)","v":{"$error":"#N/A"}},{"$error":"#N/A"},"kg CO2e"]
[]
[]
[null,null,"Total Emission","Emission per t","Emission per ha","Unit"]
[]
[null,"Summary"]
[null,"Vineyard fuel use",{"$f":"C38","v":0},{"$f":"C57/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C57/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e","Note on contractors"]
[null,"Fertiliser",{"$f":"C44","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Electricity",{"$f":"C51","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"kg CO2e"]
[null,"Scope 1 total",{"$f":"C58+C57","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Scope 2 total",{"$f":"C59","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"kg CO2e"]
[null,"Site total",{"$f":"SUM(C57:C59)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NOTE: This calculator does not include the estimation of Scope 3 (offsite) carbon emissions. Scope 3 emissions are best calculated at a business level through accepted Life Cycle Analysis Methodologies. Some general advice on wine industry Scope 3 emissions can be found here"]
["DISCLAIMER: The results presented  by this calculator are based on assumptions and are for guidance purposes only. The results should not be used for public communication, and public comparison with other producers based on these results is expressly prohibited. For more detailed assessment of the user's environmental performance, including results which can be publicly communicated, it is recommended that the user pursue a Life Cycle Assessment with a reputable LCA practitioner. "]

{"sheet":"Vineyard Benchmark","index":4,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,1,5,9],[7,1,8,9],[9,1,9,6]]}
[]
[]
[]
[null,"This page offers an example of the benchmarking feature available to members of the Sustainable Winegrowing Australia program. This feature allows users to compare their results with other members of the program and filter results to compare with users in the same state, region or size category."]
[]
[]
[]
[null,"NOTE: These are not your benchmarking results! These are sample screenshots from the Sustainable Winegrowing Australia database. To sign up for the program and benchmark your results against other Australian wine-grape growers, go to:"]
[]
[null,"www.sustainablewinegrowingaustralia.com.au"]
[]
[null,null,"Select an assessment type to begin"]
[null,null,null,null,null,null,null,null,null,null,3,{"$f":"1+K13","v":4},{"$f":"VLOOKUP(L14,Images!$C$12:$E$31,3,1)","v":"B3"}]
[null,null,null,null,"Filters",null,null,null,null,null,4,{"$f":"_xlfn.NUMBERVALUE(CONCATENATE(K13,K14,K15,K16))","v":3411}]
[null,null,"Assessment type:",null,null,null,null,null,null,null,1]
[null,null,"Basis:",null,null,null,null,null,null,null,1]
[null,null,"Compare against:"]
[null,null,"Vineyard size:"]

{"sheet":"Winery","index":5,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[[28,2,28,4]]}
[]
[]
[null,"Question","Input","Unit","Help"]
[]
[null,"Winery"]
[null,"Tonnes crushed",null,"t"]
[null,"Biodiversity area",null,"ha"]
[null,"Finished Wine",null,"kL"]
[]
[null,"Electricity"]
[null,"Purchased electricity",null,"kWh"]
[null,"Generated electricity",null,"kWh"]
[]
[null,"State (determines electricity grid)"]
[]
[null,"Fuel use"]
[null,"Natural gas",null,"GJ"]
[null,"Off-road petrol",null,"L"]
[null,"Off-road diesel",null,"L"]
[null,"Off-road LPG",null,"L"]
[null,"Off-road biodiesel",null,"L"]
[]
[null,"Water & wastewater volumes"]
[null,"Water used",null,"kL"]
[null,"Wastewater generated",null,"kL"]
[null,"Wastewater recycled",null,"kL"]
[null,"Do you have wastewater treatment on site?",null,null,null,null,1]
[]
[null,"Treatment type"]
[null,"Average inlet COD",null,"mg/L"]
[null,"Average outlet COD",null,"mg/L"]
[null,"% Flared or combusted",null,"%"]
[]
[null,"Solid waste"]
[null,"Waste to landfill",null,"t"]
[null,"Waste to recycling",null,"t"]
[null,"Total organic waste",null,"t"]
[null,"On site composting",null,"t"]
[]
[null,"Winemaking CO2"]
[null,"Purchased CO2",null,"t"]
[]
[]
[null,"Synthetic Refrigerant emissions (excluding ammonia, hydrocarbons, CO2)"]
[null,"Refrigerant","Charge size"]
[null,null,null,"kg"]
[null,null,null,"kg"]
[null,null,null,"kg"]
[null,null,null,"kg"]
[null,null,null,"kg"]

{"sheet":"Winery Results","index":6,"n_rows":104,"n_cols":6,"rows_kept":104,"cut":false,"hidden":false,"merged":[[102,0,102,6],[103,0,103,6],[3,2,3,4],[5,2,5,4],[6,2,6,4],[7,2,7,4]]}
[]
[]
[]
[]
[]
[null,"Grapes crushed",{"$f":"Winery!C6","v":0},null,null,"t"]
[null,"Finished wine",{"$f":"Winery!C8","v":0},null,null,"kL"]
[]
[]
[null,"Site Inputs"]
[]
[null,null,"Total use","Use per t","Use per kL","Unit"]
[null,"Water",{"$f":"Winery!C24","v":0},{"$f":"C13/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C13/$C$7","v":{"$error":"#DIV/0!"}},"kL"]
[null,"Winemaking CO2",{"$f":"Winery!C41*1000","v":0},{"$f":"C14/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C14/$C$7","v":{"$error":"#DIV/0!"}},"kg"]
[null,"Purchased electricity",{"$f":"Winery!C11","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kWh"]
[null,"Generated electricity",{"$f":"Winery!C12","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kWh"]
[]
[null,"Fuels"]
[null,"Natural gas",{"$f":"Winery!C17","v":0},{"$f":"C19/$C$6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"GJ"]
[null,"Petrol",{"$f":"Winery!C18","v":0},{"$f":"C20/$C$6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"L"]
[null,"Diesel",{"$f":"Winery!C19","v":0},{"$f":"C21/$C$6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"L"]
[null,"LPG",{"$f":"Winery!C20","v":0},{"$f":"C22/$C$6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"L"]
[null,"Biodiesel",{"$f":"Winery!C21","v":0},{"$f":"C23/$C$6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"L"]
[]
[null,"Waste"]
[null,"Wastewater",{"$f":"Winery!C25","v":0},{"$f":"C26/$C$6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"kL"]
[null,"Wastewater recycled",{"$f":"Winery!C26","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"%"]
[null,"Waste to landfill",{"$f":"Winery!C35","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"t"]
[null,"Waste to recycling",{"$f":"Winery!C36","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"t"]
[null,"Organic waste",{"$f":"Winery!C37","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"t"]
[null,"Composting on site",{"$f":"Winery!C38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"m3"]
[]
[]
[null,"Greenhouse Gas Emissions"]
[]
[null,null,"Total Emission","Emission \nper t","Emission per kL","Unit"]
[]
[null,"Scope 1"]
[null,"Fuel use "]
[null,"Natural gas",{"$f":"Winery!C17*VLOOKUP(B40,Fuels,2,0)","v":0},{"$f":"C40/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C40/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,"Petrol",{"$f":"Winery!C18*VLOOKUP(B41,Fuels,2,0)","v":0},{"$f":"C41/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C41/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,"Diesel",{"$f":"Winery!C19*VLOOKUP(B42,Fuels,2,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"LPG",{"$f":"Winery!C20*VLOOKUP(B43,Fuels,2,0)","v":0},{"$error":"#DIV/0!"},{"$f":"C43/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,"Biodiesel",{"$f":"Winery!C21*VLOOKUP(B44,Fuels,2,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Total",{"$f":"SUM(C40:C44)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[]
[]
[null,"Winemaking CO2"]
[null,"Total",{"$f":"Winery!C41*Factors!C47","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[]
[]
[null,"Refrigerant emissions"]
[null,{"$f":"IF(ISBLANK(Winery!B46),\"-\",Winery!B46)","v":"-"},{"$f":"IFERROR(Winery!C46*VLOOKUP(Winery!B46,RefrigGWPs,2,0)*Factors!$C$50,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,{"$f":"IF(ISBLANK(Winery!B47),\"-\",Winery!B47)","v":"-"},{"$f":"IFERROR(Winery!C47*VLOOKUP(Winery!B47,RefrigGWPs,2,0)*Factors!$C$50,0)","v":0},{"$f":"C54/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C54/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,{"$f":"IF(ISBLANK(Winery!B48),\"-\",Winery!B48)","v":"-"},{"$f":"IFERROR(Winery!C48*VLOOKUP(Winery!B48,RefrigGWPs,2,0)*Factors!$C$50,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,{"$f":"IF(ISBLANK(Winery!B49),\"-\",Winery!B49)","v":"-"},{"$f":"IFERROR(Winery!C49*VLOOKUP(Winery!B49,RefrigGWPs,2,0)*Factors!$C$50,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,{"$f":"IF(ISBLANK(Winery!B50),\"-\",Winery!B50)","v":"-"},{"$f":"IFERROR(Winery!C50*VLOOKUP(Winery!B50,RefrigGWPs,2,0)*Factors!$C$50,0)","v":0},{"$f":"C57/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C57/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[null,"Total",{"$f":"SUM(C53:C57)","v":0},{"$f":"C58/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"C58/$C$7","v":{"$error":"#DIV/0!"}},"kg CO2e"]
[]
[]
[null,"Waste"]
[null,"On site composting",{"$f":"Winery!C38*Factors!C48","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Wastewater",{"$f":"IF(Winery!G27=2,0,((Winery!C25*((Winery!C30*(1-Factors!C34))-Winery!C31)*VLOOKUP(Winery!C29,Fwan,2,0))/1000)*(Winery!C32*Factors!C36*Factors!C37+(1-Winery!C32)*Factors!C35))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"kg CO2e"]
[null,"Total",{"$f":"SUM(C62:C63)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"kg CO2e"]
[]
[null,"Scope 2"]
[null,"Electricity"]
[null,"Purchased electricity",{"$f":"Winery!C11*VLOOKUP(Winery!C14,Electricity,2,0)","v":{"$error":"#N/A"}},{"$f":"C68/$C$6","v":{"$error":"#N/A"}},{"$f":"C68/$C$7","v":{"$error":"#N/A"}},"kg CO2e"]
[null,"Generated electricity",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Total",{"$f":"SUM(C68:C69)","v":{"$error":"#N/A"}},{"$f":"SUM(D68:D69)","v":{"$error":"#N/A"}},{"$error":"#N/A"},"kg CO2e"]
[]
[]
[null,null,"Total Emission","Emission \nper t","Emission per kL","Unit"]
[]
[null,"Summary"]
[null,"Fuel use",{"$f":"C45","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Winemaking CO2",{"$f":"C49","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Refrigerant emissions",{"$f":"C58","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"kg CO2e"]
[null,"Waste",{"$f":"C64","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"kg CO2e"]
[null,"Electricity",{"$f":"C70","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"kg CO2e"]
[null,"Scope 1 total",{"$f":"C79+C78+C77+C76","v":{"$error":"#N/A"}},{"$f":"C81/$C$6","v":{"$error":"#N/A"}},{"$f":"C81/$C$7","v":{"$error":"#N/A"}},"kg CO2e"]
[null,"Scope 2 total",{"$f":"C80","v":{"$error":"#N/A"}},{"$f":"C82/$C$6","v":{"$error":"#N/A"}},{"$f":"C82/$C$7","v":{"$error":"#N/A"}},"kg CO2e"]
[null,"Site total",{"$f":"SUM(C76:C80)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"kg CO2e"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NOTE: This calculator does not include the estimation of Scope 3 (offsite) carbon emissions. Scope 3 emissions are best calculated at a business level through accepted Life Cycle Analysis Methodologies. Some general advice on wine industry Scope 3 emissions can be found here"]
["DISCLAIMER: The results presented  by this calculator are based on assumptions and are for guidance purposes only. The results should not be used for public communication, and public comparison with other producers based on these results is expressly prohibited. For more detailed assessment of the user's environmental performance, including results which can be publicly communicated, it is recommended that the user pursue a Life Cycle Assessment with a reputable LCA practitioner. "]

{"sheet":"Winery Benchmark","index":7,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,1,5,9],[7,1,8,9],[9,1,9,6]]}
[]
[]
[]
[null,"This page offers an example of the benchmarking feature available to members of the Sustainable Winegrowing Australia program. This feature allows users to compare their results with other members of the program and filter results to compare with users in the same state, region or size category."]
[]
[]
[]
[null,"NOTE: These are not your benchmarking results! These are sample screenshots from the Sustainable Winegrowing Australia database. To sign up for the program and benchmark your results against other Australian wineries, go to:"]
[]
[null,"www.sustainablewinegrowingaustralia.com.au"]
[]
[null,null,"Select an assessment type to begin:"]
[null,null,null,null,null,null,null,null,null,null,1,{"$f":"1+K13","v":2},{"$f":"VLOOKUP(L14,Images!C52:E71,3,1)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Filters",null,null,null,null,null,1,{"$f":"_xlfn.NUMBERVALUE(CONCATENATE(K13,K14,K15,K16))","v":1111}]
[null,null,"Assessment type:",null,null,null,null,null,null,null,1]
[null,null,"Basis:",null,null,null,null,null,null,null,1]
[null,null,"Compare against:"]
[null,null,"Vineyard size:"]

{"sheet":"Lists","index":8,"n_rows":79,"n_cols":20,"rows_kept":79,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Refrigerants",null,"Wastewater types",null,null,null,"States",null,"Years",null,"Assessment type",null,null,"Basis",null,null,"Region",null,"Size"]
[]
[null,"R-11",null,"Managed aerobic treatment",null,null,null,"NSW",null,"2013/2014",null,"Compare with other years",null,null,"Per tonne of grapes harvested",null,null,"Australia",null,"All sizes"]
[null,"R-12",null,"Unmanaged aerobic treatment",null,null,null,"ACT",null,"2014/2015",null,"Compare with other sites",null,null,"Per hectare of vineyard area",null,null,"State",null,"My size (25-50 ha)"]
[null,"R-13",null,"Anaerobic digester/reactor",null,null,null,"VIC",null,"2015/2016",null,null,null,null,null,null,null,"GI Zone"]
[null,"R-22",null,"Shallow anaerobic lagoon (<2 metres)",null,null,null,"QLD",null,"2016/2017",null,null,null,null,null,null,null,"GI Region",null,"All sizes"]
[null,"R-23",null,"Deep anaerobic lagoon (>2 metres)",null,null,null,"SA",null,null,null,null,null,null,"Per tonne of grapes crushed",null,null,null,null,"My size (500-2000 t)"]
[null,"R-32",null,null,null,null,null,"WA",null,null,null,null,null,null,"Per kL of finished wine"]
[null,"R-113",null,null,null,null,null,"TAS"]
[null,"R-114",null,null,null,null,null,"NT"]
[null,"R-115",null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"R-116",null,null,null,null,null,null,null,null,null,null,null,null,"Per tonne of grapes harvested"]
[null,"R-123",null,null,null,null,null,null,null,null,null,null,null,null,"Per hectare of vineyard area"]
[null,"R-124"]
[null,"R-125"]
[null,"R-134a",null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"R-141b",null,null,null,null,null,null,null,null,null,null,null,null,"Per tonne of grapes crushed"]
[null,"R-142b",null,null,null,null,null,null,null,null,null,null,null,null,"Per kL of finished wine"]
[null,"R-143a"]
[null,"R-152a"]
[null,"R-218"]
[null,"R-227ea"]
[null,"R-236fa"]
[null,"R-245ca"]
[null,"R-245fa"]
[null,"R-C318"]
[null,"R-401A"]
[null,"R-401B"]
[null,"R-401C"]
[null,"R-402A"]
[null,"R-402B"]
[null,"R-403A"]
[null,"R-403B"]
[null,"R-404A"]
[null,"R-405A"]
[null,"R-406A"]
[null,"R-407A"]
[null,"R-407B"]
[null,"R-407C"]
[null,"R-407D"]
[null,"R-407E"]
[null,"R-408A"]
[null,"R-409A"]
[null,"R-409B"]
[null,"R-410A"]
[null,"R-411A"]
[null,"R-411B "]
[null,"R-412A"]
[null,"R-413A"]
[null,"R-414A"]
[null,"R-414B"]
[null,"R-415A"]
[null,"R-415B"]
[null,"R-416A"]
[null,"R-417A"]
[null,"R-418A"]
[null,"R-419A"]
[null,"R-420A"]
[null,"R-421A"]
[null,"R-421B"]
[null,"R-422A"]
[null,"R-422B"]
[null,"R-422C"]
[null,"R-422D"]
[null,"R-423A"]
[null,"R-424A"]
[null,"R-425A"]
[null,"R-426A"]
[null,"R-427A"]
[null,"R-428A"]
[null,"R-500"]
[null,"R-502"]
[null,"R-503"]
[null,"R-507A"]
[null,"R-508A"]
[null,"R-508B"]
[null,"R-509A"]

{"sheet":"Scope 3 advice page","index":9,"n_rows":73,"n_cols":4,"rows_kept":73,"cut":false,"hidden":false,"merged":[[24,1,24,11],[72,1,72,11],[27,1,27,11],[56,1,56,11],[66,1,66,11],[68,1,68,11],[70,1,70,11]]}
[]
[]
[]
[null,"In carbon accounting, greenhouse gas emissions for a business/facility are typically categorised into three different 'Scopes':"]
[]
[null,"Scope 1: Direct emissions of greenhouse gases from a business/facility. "]
[null,"Scope 2: Emissions of greenhouse gases during the generation of electricity that is purchased by a business/facility. "]
[null,"Scope 3: Emissions of greenhouse gases from other businesses as a consequence of the activities at the business/facility.   "]
[]
[null,"These scopes help to promote consistency and prevent double counting between organisations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 1: Emission Scopes (Ranganathan, Janet & Bhatia, Pankaj. (2004). The Greenhouse Gas Protocol: a Corporate Accounting and Reporting Standard, Revised Edition)"]
[]
[]
[null,"The Carbon Calculator provides a streamlined method for estimating the Scope 1 and 2 emissions for grapegrowing and winemaking in Australia (see Figure 2); however, Scope 3 emissions are also required to get the whole story. Many materials are used in grape and wine production, like fertiliser, diesel, bentonite and glass, all of which create emissions during their production. These materials make up part of the wine's life cycle and rightfully deserve to be counted against the product. Furthermore there are transport and waste disposal emissions along the supply chain which also belong to the product."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 2: Simplified supply chain"]
[]
[null,"It is important to keep the limited scope of this calculator in mind when thinking about making comparisons. This tool provides benchmarks for the purpose of assessing improvement opportunities in the areas where producers have direct control. It would be inappropriate, however, to make comparative claims about products based on these results alone, without looking at the rest of the life cycle."]
[]
[null,"For example, using the Carbon Calculator: "]
[null,"Winery A","Grapegrowing","0.3 kg CO2e/L"]
[null,null,"Winemaking","0.4 kg CO2e/L"]
[null,null,"Total","0.7 kg CO2e/L"]
[null,"Winery B","Grapegrowing","0.4 kg CO2e/L"]
[null,null,"Winemaking","0.5 kg CO2e/L"]
[null,null,"Total","0.9 kg CO2e/L"]
[]
[null,"From this, Winery A may conclude that their production is more environmentally friendly than Winery B. However, Winery B uses lightweight glass, while Winery A does not. Glass production is relatively high in carbon emissions and when this is taken into account, 1 L of wine sold by Winery B is actually less carbon intensive than Winery A. If winery A were to go ahead and make a claim without investigating the full life cycle, it may be misleading the public. "]
[]
[null,"In a recent carbon footprint study, glass production was found to make up approximately 45% of the total life cycle emissions of a bottle of wine. Grapegrowing, including associated Scope 3 emissions, made up roughly 10% and winemaking made up approximately 20% of the total. The remaining contributions came from other packaging material, distribution and disposal. In this particular study, Scope 1 and 2 emissions made up only 7% and 14% of the total emissions respectively, with the remaining 79% coming from Scope 3 sources."]
[]
[null,"The full range of environmental impacts from a product’s production, use and disposal can be analysed in a process called Life Cycle Assessment (LCA). This is the recommended method for analysing environmental product performance in a robust and defensible manner. A full LCA is recommended to make any public claims or comparisons about products and processes. These assessments look at all aspects of the supply chain, from the extraction of raw materials and manufacturing of additives, to the use and disposal of packaging material. LCAs are governed by International Standards (ISO 14000 series) and are recognised by markets around the world."]
[]
[null,"LCA can be in important tool for branding and communicating a company’s commitment to environmental sustainability. This can provide a point of distinction for the product, particularly among environmentally conscious consumer groups."]

{"sheet":"Factors","index":10,"n_rows":146,"n_cols":8,"rows_kept":146,"cut":false,"hidden":false,"merged":[[3,1,5,6],[9,7,9,13],[10,7,10,13]]}
[null,"Editable Parameters"]
[]
[null,"General Comments"]
[null,"All factors have been calculated using IPCC AR6 (2021) GWPs: Methane = 28, Nitrous Oxide = 273"]
[]
[]
[]
[null,null,2022,"Comment"]
[null,"Electricity emission factors (kg CO2e/kWh)",null,null,null,null,"References:"]
[null,"NSW",0.73,"NGA Factors (2022). **Developer note. These boxes should expand down to wrap around if the text is too big for the box.",null,null,"NGA Factors - 2022","Department of the Environment. 2022. Australian national greenhouse accounts – National inventory report 2022, Volume 1. "]
[null,"ACT",0]
[null,"VIC",0.85]
[null,"QLD",0.73]
[null,"SA",0.25]
[null,"WA",0.51,"Western Australia - South West Interconnected System (SWIS)"]
[null,"TAS",0.17]
[null,"NT",0.54]
[]
[null,"Fuel emission factors (kg CO2e/L)"]
[null,"Petrol",2.31,"NGA Factors (2022) - EDxEF"]
[null,"Diesel",2.698]
[null,"LPG",1.5469999999999999]
[null,"Biodiesel",0.01]
[null,"Natural Gas",51.57,"kg CO2e/GJ"]
[]
[null,"Wastewater types (%)"]
[null,"managed aerobic treatment",0,"NGA Factors (2022)"]
[null,"unmanaged aerobic treatment",0.3]
[null,"anaerobic digester/reactor",0.8]
[null,"shallow anaerobic lagoon (<2 metres)",0.2]
[null,"deep anaerobic lagoon (>2 metres)",0.8]
[]
[null,"Wastewater factors"]
[null,"F Sludge %",0.15,"NGA Factors"]
[null,"Emission Factor (kg CO2e/kg COD)",{"$f":"6.3/25*34","v":8.5679999999999996},"NGA Factors, adjusted for CH4 34"]
[null,"Methane Production (kg CH4/kg COD)",0.65,"NGER Tech Guide"]
[null,"Flare emission factor (kg CO2e/m3 CH4)",{"$f":"0.00581193271889401/25*34","v":7.9042284976958543E-3},"NGA Factors, Natural gas, no CO2"]
[]
[null,"Fertilizer emissions"]
[null,"Synthetic Irrigated",3.98,"kg CO2e/kg N - 0.0085 EF"]
[null,"Organic Irrigated",3.98,"kg CO2e/kg N - 0.0085 EF"]
[null,"Synthetic Dryland",0.94,"kg CO2e/kg N - 0.002 EF"]
[null,"Organic Dryland",0.94,"kg CO2e/kg N - 0.002 EF"]
[null,"Extra Urea emissions",{"$f":"0.2*44/12","v":0.73333333333333339},"kg CO2e/kg Urea - 20%"]
[]
[null,"Miscelaneous"]
[null,"Purchased CO2 EF",1000,"kg/t"]
[null,"Composting EF",55.84,"kg/t CH4 and N2O combined. NGA factors (2015)"]
[null,"Compost bulk density",0.9,"t/m3 (Patti 2004, 'Characterization of grape marc')"]
[null,"Annual Refrigerant Release",0.09,"Fraction of charge. (Commercial AC) NGA factors"]
[]
[]
[null,"Refrigerant GWPs (kg CO2e/kg)"]
[null,"R-11",4750,"From 2009 ASHRAE Handbook - Fundamentals (29.4)"]
[null,"R-12",10900]
[null,"R-13",14400]
[null,"R-22",1810]
[null,"R-23",14800]
[null,"R-32",675]
[null,"R-113",6130]
[null,"R-114",10000]
[null,"R-115",7370]
[null,"R-116",12200]
[null,"R-123",77]
[null,"R-124",609]
[null,"R-125",3500]
[null,"R-134a",1430]
[null,"R-141b",725]
[null,"R-142b",2310]
[null,"R-143a",4470]
[null,"R-152a",124]
[null,"R-218",8830]
[null,"R-227ea",3220]
[null,"R-236fa",9810]
[null,"R-245ca",693]
[null,"R-245fa",1030]
[null,"R-C318",10300]
[null,"R-401A",1200]
[null,"R-401B",1300]
[null,"R-401C",930]
[null,"R-402A",2800]
[null,"R-402B",2400]
[null,"R-403A",3100]
[null,"R-403B",4500]
[null,"R-404A",3900]
[null,"R-405A",5300]
[null,"R-406A",1900]
[null,"R-407A",2100]
[null,"R-407B",2800]
[null,"R-407C",1800]
[null,"R-407D",1600]
[null,"R-407E",1600]
[null,"R-408A",3200]
[null,"R-409A",1600]
[null,"R-409B",1600]
[null,"R-410A",2100]
[null,"R-411A",1600]
[null,"R-411B ",1700]
[null,"R-412A",2300]
[null,"R-413A",2100]
[null,"R-414A",1500]
[null,"R-414B",1400]
[null,"R-415A",1500]
[null,"R-415B",550]
[null,"R-416A",1100]
[null,"R-417A",2300]
[null,"R-418A",1700]
[null,"R-419A",3000]
[null,"R-420A",1500]
[null,"R-421A",2600]
[null,"R-421B",3200]
[null,"R-422A",3100]
[null,"R-422B",2500]
[null,"R-422C",3100]
[null,"R-422D",2700]
[null,"R-423A",2300]
[null,"R-424A",2400]
[null,"R-425A",1500]
[null,"R-426A",1500]
[null,"R-427A",2100," "]
[null,"R-428A",3600]
[null,"R-500",8100]
[null,"R-502",4700]
[null,"R-503",15000]
[null,"R-507A",4000]
[null,"R-508A",13000]
[null,"R-508B",13000]
[null,"R-509A",5700]
[]
[null,"Vineyard sizes (ha)"]
[null,"Micro",10,"Micro upper limit"]
[null,"Small",25,"Small upper limit"]
[null,"Medium",50,"Medium upper limit"]
[null,"Large",100,"Large upper limit and Very Large lower limit"]
[]
[null,"Winery crush sizes (t)"]
[null,"Very Small",500,"Very Small upper limit"]
[null,"Small",2000,"Small upper limit"]
[null,"Medium",10000,"Medium upper limit"]
[null,"Large",20000,"Large upper limit and Very Large lower limit"]
[]
[null,"Contractors"]
[null,"Harvesting",20,"L/ha (NSW DPI 2012)"]
[null,"Spraying",5,"L/ha"]
[null,"Slashing",5,"L/ha"]
[null,"Pruning",7,"L/ha"]

{"sheet":"Images","index":11,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[44,1,47,1],[44,3,47,3],[44,5,47,5],[44,7,47,7],[38,1,40,1],[38,3,40,3],[38,5,40,5],[38,7,40,7],[41,7,43,7],[41,5,43,5],[41,3,43,3],[41,1,43,1],[4,7,5,7],[7,1,9,1],[7,3,9,3],[7,5,9,5],[2,1,3,1],[2,3,3,3],[2,5,3,5],[2,7,3,7],[4,1,5,1],[4,3,5,3],[4,5,5,5],[7,7,9,7]]}
[null,"Vineyard"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Lookup Table"]
[null,null,2200,"VinI","B8"]
[null,null,2300,"VinJ","D8"]
[null,null,2400,"VinK","F8"]
[null,null,3211,"Blank","H8"]
[null,null,3222,"VinA","B3"]
[null,null,3223,"VinH","H5"]
[null,null,3232,"VinC","F3"]
[null,null,3233,"VinF","F5"]
[null,null,3242,"VinE","B5"]
[null,null,3243,"VinD","D5"]
[null,null,3252,"VinG","F5"]
[null,null,3253,"VinB","B5"]
[null,null,3322,"VinB","D3"]
[null,null,3323,"VinG","H3"]
[null,null,3332,"VinD","H3"]
[null,null,3333,"VinE","F3"]
[null,null,3342,"VinF","D5"]
[null,null,3343,"VinC","D3"]
[null,null,3352,"VinH","H5"]
[null,null,3353,"VinA","B3"]
[]
[]
[]
[null,null,3222,{"$f":"VLOOKUP(C35,Images!$C$12:$E$31,3,1)","v":"B3"}]
[]
[]
["Winery"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Lookup Table"]
[null,null,2200,"VinI","B45"]
[null,null,2300,"VinJ","D45"]
[null,null,2400,"VinK","F45"]
[null,null,"3211","Blank","H45"]
[null,null,3222,"VinA","B39"]
[null,null,3223,"VinH","H42"]
[null,null,3232,"VinC","F39"]
[null,null,3233,"VinF","F42"]
[null,null,3242,"VinE","B42"]
[null,null,3243,"VinD","D42"]
[null,null,3252,"VinG","F42"]
[null,null,3253,"VinB","B42"]
[null,null,3322,"VinB","D39"]
[null,null,3323,"VinG","H39"]
[null,null,3332,"VinD","H39"]
[null,null,3333,"VinE","F39"]
[null,null,3342,"VinF","D42"]
[null,null,3343,"VinC","D39"]
[null,null,3352,"VinH","H42"]
[null,null,3353,"VinA","B39"]