{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Conducting TA-pH Bench Trials","List"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":"Conducting TA-pH Bench Trials","index":1,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[9,4,9,8],[0,1,0,11],[1,1,1,11],[2,1,2,11],[69,1,69,11],[66,1,66,11],[28,2,28,11],[29,2,29,11],[33,2,33,11],[34,2,34,11],[51,2,51,11],[31,2,31,11],[58,2,58,11],[67,1,67,11],[68,1,68,11]]}
[null,"CONDUCTING TA-PH TRIALS"]
[null,"Version 1.0"]
[null,"© Daniel Pambianchi, 2021"]
[]
[null,"What volume unit are you using: L, hL, or gal?",null,null,null,null,null,null,"L"]
[null,"What TA unit are you using: % or g/L?",null,null,null,null,null,null,"g/L"]
[]
[null,"Identify the wine, e.g. vintage, varietal, etc."]
[]
[null,null,"Vintage",null,"VARIETAL",null,null,null,null,null,"Batch ID"]
[]
[null,"STEP 1. Enter the measured and desired TA and pH, and volume of batch to treat"]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"TA (\",I6,\")\")","v":"TA (g/L)"},null,"pH",null,{"$f":"CONCATENATE(\"Volume (\",I5,\")\")","v":"Volume (L)"}]
[null,null,"Measured",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G15)=FALSE,(IF(OR((G15<2.8),(G15>4.2)),\"ERROR: pH IS OUT OF RANGE. Enter a value in the range 2.80-4.20\",\"\")),\"\")","v":""}]
[null,null,"Desired"]
[]
[null,"STEP 2. Choose the acid you will be using to acidify",null,null,null,null,null,null,null,null,"TARTARIC"]
[]
[null,{"$f":"CONCATENATE(\"STEP 3. Prepare 100 mL of 10% \",K18,\" acid solution\")","v":"STEP 3. Prepare 100 mL of 10% TARTARIC acid solution"}]
[null,null,"Refer to the INSTRUCTIONS tab on how to prepare a 10% solution"]
[]
[null,"STEP 4. Choose your bench trials parameters"]
[null,null,"What volume increments, in mL, will you be using?",null,null,null,null,null,null,null,0.1,"mL"]
[null,null,"What sample size, in mL, will you be using: 50 or 100 mL?",null,null,null,null,null,null,null,100,"mL"]
[]
[null,"STEP 5. Conduct the bench trials"]
[null,"i.",{"$f":"CONCATENATE(\"Pour \",K25,\" mL of juice/must or wine in a \",(IF(K25=50,100,200)),\"-mL beaker.\")","v":"Pour 100 mL of juice/must or wine in a 200-mL beaker."}]
[null,"ii.","Place the beaker on a magnetic stirrer with stir bar, insert the pH electrode into the sample, and measure and confirm the pH. Record the measured pH in the table above on the first line (Dose ID 0)."]
[null,"iii.",{"$f":"CONCATENATE(\"Using a good 1-mL syringe add \",K24,\" mL of 10% acid solution. Wait for the magnetic stirrer to homogenize the sample, then take a pH reading once stable. Record the measured pH in the table below on the next line.\")","v":"Using a good 1-mL syringe add 0.1 mL of 10% acid solution. Wait for the magnetic stirrer to homogenize the sample, then take a pH reading once stable. Record the measured pH in the table below on the next line."}]
[]
[null,null,"NOTE: Do NOT taste samples as that would change the sample size and acid additions. You can however taste the Decision sample at the conclusion of the trial to make sure you are not acidifying excessively."]
[]
[null,"iv.","Repeat iii. until the measured pH is close (either slightly under or above is okay) to your desired pH."]
[null,"v.","When you have reached your desired pH, mark your Decision with an X from the dropdown menu against the line with the desired pH. You can only mark one line."]
[null,"vi.","Proceed to STEP 6."]
[]
[null,null,"Dose ID",null,"mL",null,{"$f":"CONCATENATE(\"Acid added (\",I6,\")\")","v":"Acid added (g/L)"},null,"Measured \npH",null,"Decision"]
[null,null,0,null,{"$f":"C39*$K$24","v":0},null,{"$f":"(E39*0.1*1000/$K$25)*(IF($I$6=\"g/L\",1,0.1))*(IF($K$18=\"TARTARIC\",1,(IF($K$18=\"MALIC\",1.119,(IF($K$18=\"LACTIC\",0.883,1.172))))))","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(I39)=FALSE,(IF(OR((I39<2.8),(I39>4.2)),1,0)),0)","v":0},{"$f":"IF(AND(ISBLANK(I39)=FALSE,I39<>\"\"),(IF(OR((I39<2.8),(I39>4.2)),\"ERROR: pH IS OUT OF RANGE. Enter a value in the range 2.80-4.20\",\"\")),\"\")","v":""}]
[null,null,1,null,0.1,null,0.10000000000000002,null,null,null,null,null,0,{"$f":"IF(ISBLANK(I40)=FALSE,(IF(OR((I40<2.8),(I40>4.2)),\"ERROR: pH IS OUT OF RANGE. Enter a value in the range 2.80-4.20\",\"\")),\"\")","v":""}]
[null,null,2,null,0.2,null,0.20000000000000004,null,null,null,null,null,0,""]
[null,null,3,null,0.30000000000000004,null,0.30000000000000004,null,null,null,null,null,0,""]
[null,null,4,null,0.4,null,0.40000000000000008,null,null,null,null,null,0,""]
[null,null,5,null,0.5,null,0.5,null,null,null,null,null,0,""]
[null,null,6,null,0.60000000000000009,null,0.60000000000000009,null,null,null,null,null,0,""]
[null,null,7,null,0.70000000000000007,null,0.7,null,null,null,null,null,0,""]
[null,null,8,null,0.8,null,0.80000000000000016,null,null,null,null,null,0,""]
[null,null,9,null,0.9,null,0.90000000000000013,null,null,null,null,null,0,""]
[null,null,10,null,1,null,1,null,null,null,null,null,0,""]
[]
[]
[null,null,"NOTE: The amount of \"Acid added\" is expressed in Tartaric Acid Equivalent, the standard for acidity measurements in winemaking."]
[]
[null,"STEP 6. Treat your batch of juice/must or wine based on your decision in Step 5."]
[]
[null,null,"Volume of juice/must or wine to treat:",null,null,null,null,null,null,null,{"$f":"IF(I15=\"\",\"\",I15)","v":""},{"$f":"I5","v":"L"}]
[null,null,{"$f":"CONCATENATE(\"Grams (g) of \",K18,\" acid to add to treat batch:\")","v":"Grams (g) of TARTARIC acid to add to treat batch:"},null,null,null,null,null,null,null,{"$f":"IF(SUM(M39:M49)=0,IF((IF(I5=\"L\",I15,IF(I5=\"hL\",I15*100,I15*3.79))*(IF(I6=\"%\",10,1))*(IF(ISBLANK(K39)=FALSE,G39,IF(ISBLANK(K40)=FALSE,G40,IF(ISBLANK(K41)=FALSE,G41,IF(ISBLANK(K42)=FALSE,G42,IF(ISBLANK(K43)=FALSE,G43,IF(ISBLANK(K44)=FALSE,G44,IF(ISBLANK(K45)=FALSE,G45,IF(ISBLANK(K46)=FALSE,G46,IF(ISBLANK(K47)=FALSE,G47,IF(ISBLANK(K48)=FALSE,G48,IF(ISBLANK(K49)=FALSE,G49,0)))))))))))))=0,\"\",(IF(I5=\"L\",I15,IF(I5=\"hL\",I15*100,I15*3.79))*(IF(I6=\"%\",10,1))*(IF(ISBLANK(K39)=FALSE,G39,IF(ISBLANK(K40)=FALSE,G40,IF(ISBLANK(K41)=FALSE,G41,IF(ISBLANK(K42)=FALSE,G42,IF(ISBLANK(K43)=FALSE,G43,IF(ISBLANK(K44)=FALSE,G44,IF(ISBLANK(K45)=FALSE,G45,IF(ISBLANK(K46)=FALSE,G46,IF(ISBLANK(K47)=FALSE,G47,IF(ISBLANK(K48)=FALSE,G48,IF(ISBLANK(K49)=FALSE,G49,0)))))))))))))),\"\")","v":""},"g"]
[]
[null,null,"ADVICE: To avoid errors due to, for example, estimating must volume, add half the calculated amount of acid to your juice/must, measure TA and pH, and add/adjust the second half of the calculated amount."]
[]
[null,"STEP 7. Re-measure TA and pH in your batch to confirm your adjustment"]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"TA (\",I6,\")\")","v":"TA (g/L)"},null,"pH"]
[null,null,"Expected",null,{"$f":"IF(K57=\"\",\"\",(IF(E15>0,(E15+(IF(K39=\"X\",G39,(IF(K40=\"X\",G40,(IF(K41=\"X\",G41,(IF(K42=\"X\",G42,(IF(K43=\"X\",G43,(IF(K44=\"X\",G44,(IF(K45=\"X\",G45,(IF(K46=\"X\",G46,(IF(K47=\"X\",G47,(IF(K48=\"X\",G48,(IF(K49=\"X\",G49,0))))))))))))))))))))))),\"\")))","v":""},null,{"$f":"IF(K57=\"\",\"\",(IF((IF(ISBLANK(K39)=FALSE,I39,IF(ISBLANK(K40)=FALSE,I40,IF(ISBLANK(K41)=FALSE,I41,IF(ISBLANK(K42)=FALSE,I42,IF(ISBLANK(K43)=FALSE,I43,IF(ISBLANK(K44)=FALSE,I44,IF(ISBLANK(K45)=FALSE,I45,IF(ISBLANK(K46)=FALSE,I46,IF(ISBLANK(K47)=FALSE,I47,IF(ISBLANK(K48)=FALSE,I48,IF(ISBLANK(K49)=FALSE,I49,0))))))))))))=0,\"\",(IF(ISBLANK(K39)=FALSE,I39,IF(ISBLANK(K40)=FALSE,I40,IF(ISBLANK(K41)=FALSE,I41,IF(ISBLANK(K42)=FALSE,I42,IF(ISBLANK(K43)=FALSE,I43,IF(ISBLANK(K44)=FALSE,I44,IF(ISBLANK(K45)=FALSE,I45,IF(ISBLANK(K46)=FALSE,I46,IF(ISBLANK(K47)=FALSE,I47,IF(ISBLANK(K48)=FALSE,I48,IF(ISBLANK(K49)=FALSE,I49,0)))))))))))))))","v":""}]
[null,null,"Measured"]
[]
[null,"Comments"]

{"sheet":"List","index":2,"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)"]