{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","SO2 Calculator","List"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"SO2 Calculator","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[41,1,41,6],[33,4,33,5],[0,1,0,6],[1,1,1,6],[2,1,2,6],[5,5,6,5],[5,3,5,4],[10,4,10,5],[36,1,36,6],[37,1,37,6],[38,1,38,6]]}
[null,"SO2 CALCULATOR"]
[null,"Version 6.1"]
[null,"© Daniel Pambianchi, 2022"]
[]
[null,"STEP 1. Choose your preferred method of potassium metabisulfite (KMS) addition"]
[null,null,null,"KMS solution",null,{"$f":"IF($D$6=\"KMS solution\",CONCATENATE(\"To prepare a \",$D$8,\"% KMS solution: Dissolve \",$D$8,\" g KMS in about 75 mL of cool water, then add water to bring to exactly 100 mL.\"),IF($D$6=\"KMS Campden tablets\",\"It is assumed that you can split Campden tablets into half (0.50) or quarter (0.25) portions for more accurate dosage.\",\"\"))","v":"To prepare a 10% KMS solution: Dissolve 10 g KMS in about 75 mL of cool water, then add water to bring to exactly 100 mL."}]
[]
[null,null,{"$f":"IF($D$6=\"KMS solution\",\"Enter desired % KMS solution\",\"\")","v":"Enter desired % KMS solution"},10,{"$f":"IF(D6=\"KMS solution\",\"%\",\"\")","v":"%"},{"$f":"IF(D6=\"KMS solution\",\"default: 10%\",\"\")","v":"default: 10%"}]
[]
[null,"STEP 2. Enter your wine information and parameters"]
[null,null,"Wine identifier","Vintage","VARIETAL",null,"Batch ID"]
[]
[null,null,"Type of wine","RED"]
[null,null,"Estimated/measured % ABV",null,"% alc/vol","default: 12.0"]
[null,null,"pH"]
[null,null,"Cellar temperature",null,"°C","default: 15°C/59°F"]
[null,null,"Current (measured) Free SO2",null,"mg/L","default: 0"]
[null,null,"Dissolved Oxygen (DO)",null,"µg/L","default: 0"]
["HIDE",null,"mg SO2 : mg O2",2.5,null,null,null,"HIDE"]
[null,null,"Volume to be treated",null,"L"]
[]
[null,"STEP 3. Enter your desired Molecular SO2 and Binding Factor"]
[null,null,"Molecular SO2",{"$f":"IF(D13=\"RED\",0.5,0.8)","v":0.5},"mg/L","default: 0.5 if RED, 0.8 if WHITE/ROSÉ"]
[null,null,"Binding adjustment factor",0,"%","default: 0"]
[]
[null,{"$f":"CONCATENATE(\"STEP 4. Calculated RECOMMENDED Free SO2\",\" at \",$D$23,\" Molecular SO2\")","v":"STEP 4. Calculated RECOMMENDED Free SO2 at 0.5 Molecular SO2"}]
[null,null,null,{"$f":"(IF($D$15<>\"\",IF((ROUND(($D$19*(IF($E$18=\"mg/L\",$D$18,$D$18/1000))+(1+$D$24/100)*($D$23*(1+POWER(10,($D$15-(1.92+((IF($D$14=\"\",12,$D$14))-10)*0.02+((IF($E$16=\"°C\",(IF($D$16=\"\",15,$D$16)),IF($D$16=\"\",15,(($D$16-32)*5/9))))-20)*0.031)))))),1))<10,10,(ROUND(($D$19*(IF($E$18=\"mg/L\",$D$18,$D$18/1000))+(1+$D$24/100)*($D$23*(1+POWER(10,($D$15-(1.92+((IF($D$14=\"\",12,$D$14))-10)*0.02+((IF($E$16=\"°C\",(IF($D$16=\"\",15,$D$16)),IF($D$16=\"\",15,(($D$16-32)*5/9))))-20)*0.031)))))),1))),\"\"))","v":""},"mg/L"]
[]
[null,"STEP 5. Enter your DESIRED Free SO2"]
[null,null,"Desired Free SO2",{"$f":"D27","v":""},"mg/L","default: RECOMMENDED Free SO2 in Step 4"]
[]
[null,"STEP 6. Calculated amount of KMS to add according to your preferred method"]
[]
[null,null,null,{"$f":"IF(AND(($D$20<>\"\"),($D$30<>$D$17)),(IF(AND(($D$27=\"\"),($D$30=\"\")),\"\",(IF((($D$30-$D$17)*$D$20/0.576/1000)>0,(IF($D$6=\"KMS solution\",(($D$30-$D$17)*$D$20*10*(10/$D$8)*(IF($E$20=\"gal\",3.79,(IF($E$20=\"hL\",100,1))))/0.576/1000),(IF($D$6=\"KMS powder\",(($D$30-$D$17)*$D$20*(IF($E$20=\"gal\",3.79,(IF($E$20=\"hL\",100,1))))/0.576/1000),(CEILING((($D$30-$D$17)*$D$20*(IF($E$20=\"gal\",3.79,(IF($E$20=\"hL\",100,1))))/0.576/1000/0.44),0.25)))))),IF($D$30>0,0,\"\"))))),\"\")","v":""},{"$f":"IF($D$34=\"\",\"\",(IF((($D$30-$D$17)*$D$20/0.576/1000)<>0,(IF($D$6=\"KMS solution\",CONCATENATE(\"mL \",$D$8,\"% KMS solution\"),(IF($D$6=\"KMS powder\",\"g KMS powder\",CONCATENATE(\"KMS Campden tablets\",(IF($D$30<>\"\",(IF($D$6=\"KMS Campden tablets\",IF((($D$30-$D$17)*$D$20/0.576/1000)<>0,(IF((ROUND((($D$34*0.44*0.576*1000/($D$20*(IF($E$20=\"gal\",3.79,(IF($E$20=\"hL\",100,1))))))+$D$17),1)<>$D$30),\" (see Note 1)\",\"\")),\"\"),\"\")),\"\"))))))),\"\")))","v":""}]
[]
[null,"Comments"]
[]
[]
[]
[]
[]
[null,{"$f":"IF($E$34=\"KMS Campden tablets (see Note 1)\",\"NOTE:\",\"\")","v":""}]
[null,{"$f":"IF($E$34=\"KMS Campden tablets (see Note 1)\",\"1. This will provide a Free SO2 level of approx.:\",\"\")","v":""},null,null,{"$f":"IF($B$43<>\"\",CONCATENATE(((ROUND(($D$34*0.44*0.576*1000/($D$20*(IF($E$20=\"gal\",3.79,(IF($E$20=\"hL\",100,1)))))),1))+$D$17),\" mg/L\"),\"\")","v":""}]
[null,{"$f":"IF($B$43<>\"\",\"     This is because it is difficult to accurately split tablets smaller than quarter portions.\",\"\")","v":""}]
[null,{"$f":"IF($B$43<>\"\",\"     You should consider using one of the other two methods for more accurate results.\",\"\")","v":""}]

{"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)"]