{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions - Acidifying","Acidifying Juice or Must","Instructions - Deacidifying","Deacidifying Juice or Must","List"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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 - Acidifying","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Acidifying Juice or Must","index":1,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,9],[62,2,62,3],[65,1,65,9],[66,1,66,9],[67,1,67,9],[38,2,38,8],[54,2,54,8],[11,4,11,6],[57,7,57,8],[56,6,56,8],[58,2,58,3],[59,2,59,3],[28,5,28,8],[46,5,46,8],[61,7,61,8],[62,7,62,8],[58,7,58,8],[59,7,59,8]]}
[null,"ACIDIFICATION CALCULATOR"]
[null,"Version 1.1"]
[]
[]
[null,"STEP 1. Choose your units"]
[null,null,"What Total Acidity (TA) unit are you using: %  or g/L?",null,null,null,null,null,"g/L"]
[]
[null,null,"What volume unit are you using: L, hL or gal?",null,null,null,null,null,"L"]
[]
[null,"STEP 2. Enter your juice/must information and parameters"]
[]
[null,null,"Vintage",null,"VARIETAL",null,null,null,"Batch ID"]
[]
[null,null,"Measured TA:",null,null,null,null,null,null,{"$f":"I6","v":"g/L"}]
[]
[null,null,"Measured pH:"]
[]
[null,null,"Actual or estimated juice volume:",null,null,null,null,null,null,{"$f":"IF(I8=\"\",\"\",I8)","v":"L"}]
[]
[null,"STEP 3. Enter your target TA",null,null,null,null,null,null,null,{"$f":"I6","v":"g/L"}]
[]
[null,"STEP 4. Select the acid(s) to add and in what proportions for the FIRST ADDITION"]
[]
[null,null,"ACID",null,"%",null,"Est'd Amount needed (g)",null,"Amount to add (g)"]
[null,null,null,null,null,null,{"$f":"IF(OR((I14=\"\"),(I18=\"\"),(I20=\"\"),(C25=\"\"),(E25=\"\"),(E29<>100),AND((E27>0),(C27=\"\"))),\"\",((I20-I14)*(IF(I6=\"%\",10,1))*(IF(C25=\"Malic\",1.119,1))*I18*(IF(I8=\"hL\",100,(IF(I8=\"gal\",3.79,1))))*E25/100))","v":""},null,{"$f":"IF(G25=\"\",\"\",G25/2)","v":""}]
[]
[null,null,null,null,null,null,{"$f":"IF(OR((I14=\"\"),(I18=\"\"),(I20=\"\"),(C27=\"\"),(E27=\"\"),(E29<>100),AND((E25>0),(C25=\"\"))),\"\",((I20-I14)*(IF(I6=\"%\",10,1))*(IF(C27=\"Malic\",1.119,1))*I18*(IF(I8=\"hL\",100,(IF(I8=\"gal\",3.79,1))))*E27/100))","v":""},null,{"$f":"IF(G27=\"\",\"\",G27/2)","v":""}]
[]
[null,null,"TOTAL %",null,{"$f":"IF(AND((E25=\"\"),(E27=\"\")),\"\",E25+E27)","v":""},{"$f":"IF(E29<>100,IF(E29<>\"\",\"TOTAL % MUST BE EQUAL TO 100\",\"\"),IF(OR(AND((E25<>\"\"),(C25=\"\")),AND((E27<>\"\"),(C27=\"\"))),\"SELECT YOUR ACIDS\",\"\"))","v":""}]
[]
[null,"STEP 5. Add the acid(s) and re-measure TA and pH"]
[]
[null,null,"Measured TA:",null,null,null,null,null,null,{"$f":"I6","v":"g/L"}]
[]
[null,null,"Measured pH:"]
[]
[null,null,"Calculated ACTUAL juice volume:",null,null,null,null,null,{"$f":"IF(OR((I18=\"\"),(I20=\"\"),(I14=\"\"),(I33=\"\")),\"\",(I18*((I20+I14)/2)/I33))","v":""},{"$f":"I8","v":"L"}]
[]
[null,null,{"$f":"IF(I33>I20,\"YOU HAVE OVERSHOT YOUR TARGET TA.\",\"\")","v":""}]
[null,"STEP 6. Select the acid(s) to add and in what proportions for the SECOND ADDITION"]
[]
[null,null,"ACID",null,"%",null,null,null,"Amount to add (g)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR((I33=\"\"),(I37=\"\"),(C43=\"\"),(E43=\"\"),(E29>100),(I33>I20),AND((E45>0),(C45=\"\"))),\"\",((I20-I33)*(IF(I6=\"%\",10,1))*(IF(C43=\"Malic\",1.119,1))*I37*(IF(I8=\"hL\",100,(IF(I8=\"gal\",3.79,1))))*E43/100))","v":""}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR((I33=\"\"),(I37=\"\"),(C45=\"\"),(E45=\"\"),(E29>100),(I33>I20),AND((E43>0),(C43=\"\"))),\"\",((I20-I33)*(IF(C45=\"Malic\",1.119,1))*I37*(IF(I8=\"hL\",100,(IF(I8=\"gal\",3.79,1))))*E45/100))","v":""}]
[]
[null,null,"Total",null,{"$f":"IF(AND((E43=\"\"),(E45=\"\")),\"\",E43+E45)","v":""},{"$f":"IF(E47<>100,IF(E47<>\"\",\"TOTAL % MUST BE EQUAL TO 100\",\"\"),IF(OR(AND((E43<>\"\"),(C43=\"\")),AND((E45<>\"\"),(C45=\"\"))),\"SELECT YOUR ACIDS\",\"\"))","v":""}]
[]
[null,"STEP 7. Add the acid(s) and re-measure TA and pH"]
[]
[null,null,"Measured TA:",null,null,null,null,null,null,{"$f":"I6","v":"g/L"}]
[]
[null,null,"Measured pH:"]
[]
[null,null,{"$f":"IF(I51>I20,\"YOU HAVE OVERSHOT YOUR TARGET TA.\",IF(AND((I51=I20),(I51<>\"\")),\"CONGRATULATIONS, YOU HAVE HIT YOUR TARGET TA SPOT ON.\",\"\"))","v":""}]
[]
[null,null,"SUMMARY",null,null,null,"Measured"]
[null,null,null,null,"Initial","Target","After 1st add.","After 2nd add."]
[null,null,{"$f":"CONCATENATE(\"TA (\",I6,\")\")","v":"TA (g/L)"},null,{"$f":"IF(I14=\"\",\"\",I14)","v":""},{"$f":"IF(I20=\"\",\"\",I20)","v":""},{"$f":"IF(I33=\"\",\"\",I33)","v":""},{"$f":"IF(I51=\"\",\"\",I51)","v":""}]
[null,null,"pH",null,{"$f":"IF(I16=\"\",\"\",I16)","v":""},null,{"$f":"IF(I35=\"\",\"\",I35)","v":""},{"$f":"IF(I53=\"\",\"\",I53)","v":""}]
[]
[null,null,null,null,null,null,"Estimated","Actual"]
[null,null,{"$f":"CONCATENATE(\"Juice Volume (\",I8,\")\")","v":"Juice Volume (L)"},null,null,null,{"$f":"IF(I18=\"\",\"\",I18)","v":""},{"$f":"I37","v":""}]
[]
[null,"COMMENTS"]

{"sheet":"Instructions - Deacidifying","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Deacidifying Juice or Must","index":3,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[60,1,60,9],[61,1,61,9],[53,2,53,3],[53,7,53,8],[55,7,55,8],[56,2,56,3],[56,7,56,8],[59,1,59,9],[48,2,48,8],[50,6,50,8],[51,7,51,8],[52,2,52,3],[52,7,52,8],[0,1,0,9],[1,1,1,9],[2,1,2,9],[11,4,11,6],[35,2,35,8]]}
[null,"DEACIDIFICATION CALCULATOR"]
[null,"Version 1.0"]
[null,"© Daniel Pambianchi, 2021"]
[]
[null,"STEP 1. Choose your units"]
[null,null,"What Total Acidity (TA) unit are you using: %  or g/L?",null,null,null,null,null,"g/L"]
[]
[null,null,"What volume unit are you using: L, hL or gal?",null,null,null,null,null,"L"]
[]
[null,"STEP 2. Enter your juice/must information and parameters"]
[]
[null,null,"Vintage",null,"VARIETAL",null,null,null,"Batch ID"]
[]
[null,null,"Measured TA:",null,null,null,null,null,null,{"$f":"I6","v":"g/L"}]
[]
[null,null,"Measured pH:"]
[]
[null,null,"Actual or estimated juice volume:",null,null,null,null,null,null,{"$f":"IF(I8=\"\",\"\",I8)","v":"L"}]
[]
[null,"STEP 3. Enter your target TA",null,null,null,null,null,null,null,{"$f":"I6","v":"g/L"}]
[]
[null,"STEP 4. Select the carbonate salt of choice"]
[]
[null,null,"Carbonate salt",null,"Formula",null,"Est'd Amount needed (g)",null,"Amount to add (g)"]
[null,null,null,null,{"$f":"IF(C25=\"\",\"\",(IF(C25=\"Potassium carbonate\",\"K2CO3\",IF(C25=\"Potassium bicarbonate\",\"KHCO3\",\"CaCO3\"))))","v":""},null,{"$f":"IF(OR((I14=\"\"),(I18=\"\"),(I20=\"\"),(C25=\"\")),\"\",((I14-I20)*(IF(I6=\"%\",10,1))*(IF(C25=\"Potassium carbonate\",0.46,0.67)*I18*(IF(I8=\"hL\",100,(IF(I8=\"gal\",3.79,1)))))))","v":""},null,{"$f":"IF(G25=\"\",\"\",G25/2)","v":""}]
[]
[]
[null,"STEP 5. Add the carbonate salt and re-measure TA and pH"]
[]
[null,null,"Measured TA:",null,null,null,null,null,null,{"$f":"I6","v":"g/L"}]
[]
[null,null,"Measured pH:"]
[]
[null,null,"Calculated ACTUAL juice volume:",null,null,null,null,null,{"$f":"IF(OR((I18=\"\"),(I20=\"\"),(I14=\"\"),(I30=\"\")),\"\",(I18*((I20+I14)/2)/I30))","v":""},{"$f":"I8","v":"L"}]
[]
[null,null,{"$f":"IF(OR((I30=0),(I30=\"\")),\"\",(IF(I30<I20,\"YOU HAVE OVERSHOT YOUR TARGET TA.\",\"\")))","v":""}]
[null,"STEP 6. Calculation of salt needed for the SECOND ADDITION"]
[]
[null,null,"Carbonate salt",null,"Formula",null,null,null,"Amount to add (g)"]
[null,null,{"$f":"IF(C25=\"\",\"\",C25)","v":""},null,{"$f":"E25","v":""},null,null,null,{"$f":"IF(OR((I30=\"\"),(I34=\"\"),(C40=\"\"),(I30<I20)),\"\",((I30-I20)*(IF(I6=\"%\",10,1))*(IF(C40=\"Potassium carbonate\",0.46,0.67))*I34*(IF(I8=\"hL\",100,(IF(I8=\"gal\",3.79,1))))))","v":""}]
[]
[]
[null,"STEP 7. Perform the SECOND ADDITION and re-measure TA and pH"]
[]
[null,null,"Measured TA:",null,null,null,null,null,null,{"$f":"I6","v":"g/L"}]
[]
[null,null,"Measured pH:"]
[]
[null,null,{"$f":"IF(OR((I45=0),(I45=\"\")),\"\",(IF(I45<I20,\"YOU HAVE OVERSHOT YOUR TARGET TA.\",IF(AND((I45=I20),(I45<>\"\")),\"CONGRATULATIONS, YOU HAVE HIT YOUR TARGET TA SPOT ON.\",\"\"))))","v":""}]
[]
[null,null,"SUMMARY",null,null,null,"Measured"]
[null,null,null,null,"Initial","Target","After 1st add.","After 2nd add."]
[null,null,{"$f":"CONCATENATE(\"TA (\",I6,\")\")","v":"TA (g/L)"},null,{"$f":"IF(I14=\"\",\"\",I14)","v":""},{"$f":"IF(I20=\"\",\"\",I20)","v":""},{"$f":"IF(I30=\"\",\"\",I30)","v":""},{"$f":"IF(I45=\"\",\"\",I45)","v":""}]
[null,null,"pH",null,{"$f":"IF(I16=\"\",\"\",I16)","v":""},null,{"$f":"IF(I32=\"\",\"\",I32)","v":""},{"$f":"IF(I47=\"\",\"\",I47)","v":""}]
[]
[null,null,null,null,null,null,"Estimated","Actual"]
[null,null,{"$f":"CONCATENATE(\"Juice Volume (\",I8,\")\")","v":"Juice Volume (L)"},null,null,null,{"$f":"IF(I18=\"\",\"\",I18)","v":""},{"$f":"I34","v":""}]
[]
[null,"COMMENTS"]

{"sheet":"List","index":4,"n_rows":85,"n_cols":1,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
["VARIETAL"]
["BLEND"]
["OTHER"]
["Aglianico"]
["Albariño (Alvarinho)"]
["Alicante Bouschet"]
["Aligoté"]
["Auxerrois"]
["Baco Noir"]
["Barbera"]
["Cabernet Franc"]
["Cabernet Sauvignon"]
["Cabernet Severnyi"]
["Carignan"]
["Carménère"]
["Catawba"]
["Cayuga White"]
["Chambourcin"]
["Chancellor"]
["Chardonel"]
["Chardonnay"]
["Chenin Blanc"]
["Cinsault"]
["Colombard"]
["Concord"]
["Corot Noir"]
["De Chaunac"]
["Delaware"]
["Fredonia"]
["Frontenac"]
["Gamay"]
["Gewürztraminer"]
["Grenache"]
["Grenache Gris"]
["Grüner Veltliner"]
["Isabella"]
["La Crescent"]
["La Crosse"]
["Landot Noir"]
["Léon Millot"]
["Malbec"]
["Malvasia"]
["Maréchal Foch"]
["Marquette"]
["Merlot"]
["Mission"]
["Montepulciano d'Abruzzo"]
["Mourvèdre (Monastrell)"]
["Müller-Thurgau"]
["Muscadine"]
["Muscat (Moscato Bianco)"]
["Mustang"]
["Nebbiolo"]
["Nero d'Avola"]
["Niagara"]
["Noiret"]
["Norton (Cynthiana)"]
["Palomino"]
["Petit Verdot"]
["Petite Sirah (Durif)"]
["Pinot Blanc (Pinot Bianco)"]
["Pinot Gris (Pinot Grigio)"]
["Pinot Meunier"]
["Pinot Noir"]
["Pinotage"]
["Regent"]
["Riesling"]
["Ruby Cabernet"]
["Sangiovese"]
["Saperavi"]
["Sauvignon Blanc"]
["Scuppernong"]
["Sémillon"]
["Seyval Blanc"]
["St. Croix"]
["Swenson White"]
["Syrah (Shiraz)"]
["Tempranillo"]
["Thompson Seedless"]
["Touriga Nacional"]
["Traminette"]
["Trebbiano (Ugni Blanc)"]
["Vidal Blanc"]
["Viognier"]
["Zinfandel (Primitivo)"]