{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","SORBATE CALCULATOR","List","ABV-Sorbic table"],"not_rendered":{"charts":0,"images":2,"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":"SORBATE CALCULATOR","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[27,1,27,5],[28,1,28,5],[29,1,29,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[null,"SORBATE CALCULATOR"]
[null,"Version 1.0"]
[null,"© Daniel Pambianchi, 2021"]
[]
[null,"STEP 1. Enter your wine information and parameters"]
[]
[null,null,"Wine Identifier"]
[]
[null,null,"Vintage","Varietal","Batch ID"]
[]
[null,null,"Actual or estimated % ABV (leave blank if unknown):",null,null,"% alc/vol"]
[]
[null,null,"Wine pH (leave blank if unknown):"]
[]
[null,null,"Actual or estimated volume to treat (choose your unit):",null,null,"L",null,{"$f":"IF(E15<0,\"Enter a value greater than 0\",\"\")","v":""}]
[]
[null,"STEP 2. Calculate the amount of potassium sorbate to add"]
[]
[null,null,"Amount of potassium sorbate in grams (g) to add:",null,{"$f":"IFERROR((IF(E15=\"\",\"\",((LOOKUP((IF(E11=\"\",10,IF(E11<10,10,IF(E11>14,14,ROUND(E11,0))))-IF(OR((E13>3.5),(E13=\"\")),(IF(AND((ROUND(E11,0)>=11),(ROUND(E11,0)<=14)),1,0)),0)),'ABV-Sorbic table'!A2:A6,'ABV-Sorbic table'!B2:B6))*1.34*E15*(IF(F15=\"L\",1,(IF(F15=\"hL\",100,3.79))))/1000))),\"\")","v":""},"g"]
[]
[null,"STEP 3. Add the potassium sorbate to the wine"]
[]
[null,null,"i. Add sulfite (KMS) to the wine according to pH (use the SO2 CALCULATOR)."]
[null,null,"ii. Dissolve the calculated amount of potassium sorbate in a little water and add the sorbate solution to the wine very slowly while stirring continuously."]
[null,null,"iii. If adding sugar to sweeten the wine, wait at least 2 weeks before and after sweetening, or before bottling to make sure there is no sedimentation."]
[]
[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)"]

{"sheet":"ABV-Sorbic table","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["% ABV","Sorbic Acid (mg/L)"]
[10,150]
[11,125]
[12,100]
[13,75]
[14,50]