{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","YAN CALCULATOR","YAN Data","Lists"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":11,"comments":0,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"YAN CALCULATOR","index":1,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[[32,2,32,8],[43,1,43,8],[44,1,44,8],[45,1,45,8],[40,2,40,8],[36,2,36,8],[0,11,2,11],[28,4,28,5],[30,4,30,5],[24,2,24,8],[0,1,0,8],[1,1,1,8],[2,1,2,8],[18,4,18,5],[9,4,9,5]]}
[null,"YAN CALCULATOR",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(C19=\"Lallemand\",VLOOKUP(E19,Lists!D2:E29,2,FALSE),IF(C19=\"Laffort\",VLOOKUP(E19,Lists!F2:G15,2,FALSE),IF(C19=\"Enartis\",VLOOKUP(E19,Lists!H2:I22,2,FALSE),IF(C19=\"Red_Star\",VLOOKUP(E19,Lists!J2:K6,2,FALSE),IF(C19=\"White_Labs\",VLOOKUP(E19,Lists!L2:M13,2,FALSE),IF(C19=\"Wyeast\",VLOOKUP(E19,Lists!N2:O9,2,FALSE),IF(C19=\"Renaissance\",VLOOKUP(E19,Lists!P2:Q10,2,FALSE),IF(C19=\"AB_Biotek\",VLOOKUP(E19,Lists!R2:S2,2,FALSE),\"\"))))))))),\"\")","v":""},"Product","Dose (mg/L)","+YAN\n(mg N/L)","Amount to add (g)"]
[null,"Version 1.0",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E29=\"\",\"Pick a Nutrient\",E29)","v":"Pick a Nutrient"},{"$f":"IF(M2=\"Pick a Nutrient\",0,VLOOKUP(M2,'YAN Data'!$A$1:$C$9,2,FALSE))","v":0},{"$f":"IF(M2=\"Pick a Nutrient\",0,VLOOKUP(M2,'YAN Data'!$A$1:$C$9,3,FALSE))","v":0},{"$f":"ROUND((IF(N2=0,0,((IF(H24>50,((N2*(H24/2)/1000/O2)),0))*(IF(H6=\"L\",H15,(IF(H6=\"hL\",H15*100,H15*3.79))))))),0)","v":0}]
[null,"© Daniel Pambianchi, 2021",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E31=\"\",\"Pick a Nutrient\",E31)","v":"Pick a Nutrient"},{"$f":"IF(M3=\"Pick a Nutrient\",0,VLOOKUP(M3,'YAN Data'!$A$14:$C$25,2,FALSE))","v":0},{"$f":"IF(M3=\"Pick a Nutrient\",0,VLOOKUP(M3,'YAN Data'!$A$14:$C$25,3,FALSE))","v":0},{"$f":"ROUND((IF(N3=0,0,(IF(H24>50,((N3*(H24/2)/1000/O3)),(ROUND((N3*(H24)/1000/O3),2))))*(IF(H6=\"L\",H15,(IF(H6=\"hL\",H15*100,H15*3.79)))))),0)","v":0}]
[]
[null,"What hydrometer unit are you using: SG or Brix?",null,null,null,null,null,"Brix"]
[null,"What volume unit are you using: L, hL or gal?",null,null,null,null,null,"L"]
[]
[null,"Identify the batch:"]
[]
[null,null,"Vintage",null,"GRAPE VARIETY",null,null,"Batch ID"]
[]
[null,"STEP 1. Enter your must/juice parameters"]
[null,null,"Initial, temperature-adjusted Hydrometer reading:",null,null,null,null,null,{"$f":"H5","v":"Brix"},null,{"$f":"IF(H13=\"\",\"\",(IF(AND((H5=\"SG\"),OR(H13<1.08,H13>1.115)),\"ENTER A VALID SG\",IF(AND((H5=\"Brix\"),OR(H13<20,H13>27)),\"ENTER A VALID BRIX\",\"\"))))","v":""}]
[null,null,"Estimated/measured YAN (default = 150 mg N/L):",null,null,null,null,150,"mg N/L"]
[null,null,"Volume of must or juice to treat:",null,null,null,null,null,{"$f":"H6","v":"L"}]
[]
[null,"STEP 2. Which yeast (brand and strain) will you be using for fermentation?"]
[]
[null,null,"BRAND",null,"STRAIN",null,null,null,null,null,{"$f":"IF(C19=\"BRAND\",\"\",(IFERROR((IF((VLOOKUP(E19,INDIRECT(C19),1,FALSE))=E19,\"\")),CONCATENATE(\"Choose a \",C19,\" strain.\"))))","v":""}]
[]
[null,"STEP 3. YAN Calculations"]
[null,null,{"$f":"CONCATENATE(\"Recommended YAN based on your \",H5,\" and yeast strain:\")","v":"Recommended YAN based on your Brix and yeast strain:"},null,null,null,null,{"$f":"IF(C19=\"BRAND\",\"\",(IFERROR((IF(L1<>\"\",IF(H5=\"SG\",(VLOOKUP(CEILING(H13,0.005),'YAN Data'!E1:I9,IF(OR(L1=\"Low\",L1=\"Very Low\"),3,IF(OR(L1=\"Med\",L1=\"Low/Med\"),4,5)),FALSE)),(VLOOKUP(ROUNDUP(H13,0),'YAN Data'!F1:I9,IF(OR(L1=\"Low\",L1=\"Very Low\"),2,IF(OR(L1=\"Med\",L1=\"Low/Med\"),3,4)),FALSE))),\"\")),\"\")))","v":""},"mg N/L"]
[]
[null,null,"Amount of YAN to add (recommended minus measured):",null,null,null,null,{"$f":"IFERROR((IF(L1<>\"\",(IF(OR(H14=0,H14=\"\"),IF(H22<150,0,H22-150),IF(H22<H14,0,H22-H14))),0)),0)","v":0},"mg N/L"]
[null,null,{"$f":"IF(H24=0,\"\",IF(H24<=50,\"\",CONCATENATE(\"NOTE: The 'Amount of YAN to add' will be added in 2 steps according to \",H5,\" drop.\")))","v":""}]
[]
[null,"STEP 4. Choose one or two complex nutrients products you will be using"]
[]
[null,null,"FIRST Addition",null,"Pick a Nutrient"]
[]
[null,null,"SECOND Addition",null,"Pick a Nutrient"]
[]
[null,null,{"$f":"IF(AND((H24<=50),(H24>0)),\"NOTE: Since the amount of YAN to add is 50 mg/L or less, only one complex nutrients product is needed, and is added at the SECOND addition.\",\"\")","v":""}]
[]
[null,"STEP 5. FIRST Addition"]
[]
[null,null,{"$f":"IFERROR((IF(H15>0,(IF(AND((M2=\"Pick a Nutrient\"),(H24=0)),\"\",(IF(H24=0,\"No nutrients addition required.\",IF(M2=\"Pick a Nutrient\",\"\",IF(P2>0,(CONCATENATE(\"Add \",P2,\" g of \",E29,\" 6-12 hours after yeast inoculation.\")),\"A first addition is not needed since the amount of YAN to add is 50 mg/L or less.\")))))),\"\")),\"\")","v":""}]
[]
[null,"STEP 6. SECOND Addition"]
[]
[null,null,{"$f":"IF(E31<>\"\",(IF(H15>0,(IF(AND((M3=\"Pick a Nutrient\"),(H24=0)),\"\",(IF(H24=0,\"No nutrients addition required.\",IF(OR(M3=\"Pick a Nutrient\",E31=\"Pick a Nutrient\"),\"\",(CONCATENATE(\"Add \",P3,\" g of \",E31,\" when \",H5,\" has dropped to approximately \",(IF(H5=\"SG\",ROUND((1+(H13-1)*2/3),3),ROUND((H13*2/3),0))),\".\"))))))),\"\")),\"\")","v":""}]
[]
[null,"Comments"]

{"sheet":"YAN Data","index":2,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Pick a Nutrient","Dose","mg N/L",null,"SG","Brix","YAN Low","YAN Med","YAN High"]
["Fermaid O (Lallemand)",100,20,null,1.08,20,150,180,250]
["Stimula (Lallemand)",100,20,null,1.085,21,160,190,260]
["Nutristart (Laffort)",100,15,null,1.0900000000000001,22,165,200,275]
["Nutristart Org (Laffort)",100,10,null,1.095,23,175,210,290]
["Nutristart Arom (Laffort)",100,14,null,1.1000000000000001,24,180,220,300]
["Thiazote (Laffort)",100,21,null,1.105,25,190,230,315]
["Nutriferm Special (Enartis)",100,16,null,1.1100000000000001,26,195,240,325]
["Superfood (BSG)",120,11,null,1.115,27,200,250,350]
[]
[]
[]
[]
["Pick a Nutrient","Dose","mg N/L"]
["Fermaid O (Lallemand)",100,20]
["Fermaid K (Lallemand)",100,10]
["Stimula (Lallemand)",100,20]
["DAP (Lallemand)",100,20]
["Nutristart (Laffort)",100,15]
["Nutristart Org (Laffort)",100,10]
["Nutristart Arom (Laffort)",100,14]
["Thiazote (Laffort)",100,21]
["Mauriferm Gold (AB Biotek)",100,10]
["Superfood (BSG)",120,11]
["Nutrivin (Anchor)",100,15]
[]
[]
["Nutriferm Arom Plus (Enartis)","no data"]
["Fermax"]
["DAP"]

{"sheet":"Lists","index":3,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["GRAPE VARIETY","BRAND",null,"Lallemand",null,"Laffort",null,"Enartis",null,"Red_Star",null,"White_Labs",null,"Wyeast",null,"Renaissance",null,"AB_Biotek"]
["Other","Lallemand",null,"71B-1122","Low","F15","Med","Aroma White","Med/High","Premier Rouge","High","WLP707","Med",4021,"Med","Allegro","Med","Maurivin B","Low","when adding varieties, be sure to update cell references in Yeast Selector sheet, column G"]
["Aglianico","Laffort",null,"Alchemy I","Med","F83","Med","D20","Med","Premier Classique","Low","WLP715","Med",4028,"Med","Andante","Med"]
["Albariño (Alvarinho)","Enartis",null,"BDX","Med","FX10","Low","ES123","High","Côte des Blancs","High","WLP718","Med",4242,"Med","Avante","Med"]
["Alicante Bouschet","Red_Star",null,"BM45","High","RB2","Low","ES181","Low","Premier Blanc","Very Low","WLP720","Med",4244,"Med","Bella","High"]
["Auxerrois","White_Labs",null,"BM4X4","High","RX60","High","ES401","Med/High","Premier Cuvée","Very Low","WLP727","Med",4267,"Med","Bravo","Med"]
["Baco Noir","Wyeast",null,"BRG","High","CX9","Low","ES454","Med",null,null,"WLP730","Med",4767,"Med","Brio","Med"]
["Barbera","Renaissance",null,"BRL97","Med","DELTA","High","ES488","High",null,null,"WLP735","Med",4783,"Med","Maestoso","High"]
["Cabernet Franc","AB_Biotek",null,"CLOS","Med","VL1","High","EZ Ferm 44","Low",null,null,"WLP740","High",4946,"Med","TR-313","Med"]
["Cabernet Sauvignon",null,null,"Cross Evolution","Low","VL2","Med","MB15","Low/Med",null,null,"WLP749","Med",null,null,"Vivace","High"]
["Carménère","STRAIN",null,"CSM","Med","VL3","High","Q Citrus","Med",null,null,"WLP750","Med"]
["Catawba",null,null,"CY3079","High","X5","High","Q5","Med",null,null,"WLP760","Med"]
["Cayuga White",null,null,"DV10","Low","X16","Med","Q7","Med",null,null,"WLP770","High"]
["Chambourcin",null,null,"EC-1118","Low","BO213","Low","Q9","Med/High"]
["Chardonnay",null,null,"ICV-D21","Med","ROSÉ","Med","Red Fruit","High"]
["Chenin Blanc",null,null,"ICV-D254","Med",null,null,"Top Essence","Med"]
["Concord",null,null,"ICV-D47","Low",null,null,"Vintage Red","Med"]
["Frontenac",null,null,"ICV-D80","High",null,null,"Vintage White","Med/High"]
["Gamay",null,null,"ICV-GRE","Med",null,null,"VQ Assmanshausen","Med"]
["Gewürztraminer",null,null,"K1V-1116","Med",null,null,"VQ10","Low"]
["Grenache",null,null,"Lalvin C","Low",null,null,"VQ51","Med"]
["La Crescent",null,null,"QA23","Low",null,null,"WS","Low"]
["Léon Millot",null,null,"R2","High"]
["Malbec",null,null,"RC 212","Med"]
["Maréchal Foch",null,null,"RP15","Med"]
["Marquette",null,null,"SVG","Med"]
["Merlot",null,null,"SYRAH","Med"]
["Mourvèdre (Monastrell)",null,null,"Uvaferm 43 RESTART","Low"]
["Muscat (Moscato Bianco)",null,null,"VIN 13","Low"]
["Nebbiolo"]
["Niagara"]
["Noiret"]
["Norton (Cynthiana)"]
["Petit Verdot"]
["Petite Sirah (Durif)"]
["Pinot Gris (Pinot Grigio)"]
["Pinot Noir"]
["Pinotage"]
["Riesling"]
["Sangiovese"]
["Sauvignon Blanc"]
["Scuppernong"]
["Seyval Blanc"]
["St. Croix"]
["Syrah (Shiraz)"]
["Tempranillo"]
["Touriga Nacional"]
["Traminette"]
["Vidal Blanc"]
["Viognier"]
["Zinfandel (Primitivo)"]