{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Sweetening 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":"Sweetening Bench Trials","index":1,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[24,2,24,11],[26,2,26,11],[0,1,0,11],[1,1,1,11],[2,1,2,11],[11,4,11,7],[27,2,27,11],[54,1,54,11],[51,1,51,11],[28,2,28,11],[29,2,29,11],[52,1,52,11],[53,1,53,11],[49,2,49,11],[42,2,42,11]]}
[null,"SWEETENING BENCH TRIALS"]
[null,"Version 1.0"]
[null,"© Daniel Pambianchi, 2022"]
[]
[null,"STEP 1. Choose your units"]
[null,null,"What volume unit are you using: L, hL, or gal?",null,null,null,null,null,null,null,"L"]
[]
[null,null,"What sugar concentration unit are you using: % or g/L?",null,null,null,null,null,null,null,"g/L"]
[]
[null,"STEP 2. Identify the wine, i.e. vintage, varietal and batch ID, and volume to be treated"]
[]
[null,null,"Vintage",null,"VARIETAL",null,null,null,null,null,"BatchID"]
[]
[null,null,"Volume of wine to be sweetened:",null,null,null,null,null,null,null,null,{"$f":"K6","v":"L"}]
[]
[null,"STEP 3. Prepare 100 mL of 10% sugar 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 sugar concentration increments would you like to start with?",null,null,null,null,null,null,null,1,{"$f":"K8","v":"g/L"}]
[]
[null,null,"What wine sample size would you like to use? Choose 50 or 100 mL.",null,null,null,null,null,null,null,50,"mL"]
[]
[null,"STEP 5. Conduct the bench trials"]
[null,"i.","Prepare a CONTROL tasting glass and up to six (6) wine tasting glasses and label each as 0, 1, 2, 3, 4, 5 and 6. Glass 0 is the Control, i.e. with no sugar addition."]
[null,"ii.","Pour some wine in glass 0, i.e. the CONTROL."]
[null,"iii.",{"$f":"CONCATENATE(\"Pour exactly \", K22, \" mL of wine in a 100-mL graduated cylinder and transfer to a wine tasting glass, and repeat for the number of samples planned.\")","v":"Pour exactly 50 mL of wine in a 100-mL graduated cylinder and transfer to a wine tasting glass, and repeat for the number of samples planned."}]
[null,"iv.","Using a good pipette or syringe, add the amount of 10% sugar solution to each glass as per COLUMN C in the table below. Swirl each glass to mix the sugar solution thoroughly."]
[null,"v.","Taste the CONTROL wine and each sweetened sample, and compare. See which has the best balance and which best matches your desired taste profile."]
[null,"vi.","Mark your preferred sample in the Decision column with an X from the dropdown menu. You can only mark one line."]
[null,"vii.","Proceed to STEP 6."]
[]
[null,null,"A",null,"B",null,"C",null,"D",null,"E"]
[null,null,"Sample",null,{"$f":"CONCATENATE(\"Incremental rate of addition (\",K8,\")\")","v":"Incremental rate of addition (g/L)"},null,"mL of 10% sugar solution to add",null,{"$f":"CONCATENATE(\"Equivalent rate of addition (\",K8,\")\")","v":"Equivalent rate of addition (g/L)"},null,"Decision"]
[null,null,0,null,{"$f":"C35*$K$20","v":0},null,{"$f":"IF($K$8=\"%\",10,1)*E35/(IF($K$22=50,2,1))","v":0},null,{"$f":"(G35*0.1*1000)/($K$22+G35+(G35*0.1*0.625))","v":0},null,null,null,null,{"$f":"IF(ISBLANK(K35)=FALSE,1,0)","v":0},{"$f":"IF(ISBLANK(#REF!)=FALSE,(IF(OR((#REF!<2.8),(#REF!>4.2)),1,0)),0)","v":{"$error":"#REF!"}}]
[null,null,1,null,{"$f":"C36*$K$20","v":1},null,{"$f":"IF($K$8=\"%\",10,1)*E36/(IF($K$22=50,2,1))","v":0.5},null,{"$f":"(G36*0.1*1000)/($K$22+G36+(G36*0.1*0.625))","v":0.9894867037724181},null,null,null,null,{"$f":"IF(ISBLANK(K36)=FALSE,1,0)","v":0},{"$f":"IF(ISBLANK(#REF!)=FALSE,(IF(OR((#REF!<2.8),(#REF!>4.2)),1,0)),0)","v":{"$error":"#REF!"}}]
[null,null,2,null,2,null,1,null,1.9583843329253365,null,null,null,null,{"$f":"IF(ISBLANK(K37)=FALSE,1,0)","v":0},{"$f":"IF(ISBLANK(#REF!)=FALSE,(IF(OR((#REF!<2.8),(#REF!>4.2)),1,0)),0)","v":{"$error":"#REF!"}}]
[null,null,3,null,3,null,1.5,null,2.9073288915808608,null,null,null,null,{"$f":"IF(ISBLANK(K38)=FALSE,1,0)","v":0},{"$f":"IF(ISBLANK(#REF!)=FALSE,(IF(OR((#REF!<2.8),(#REF!>4.2)),1,0)),0)","v":{"$error":"#REF!"}}]
[null,null,4,null,4,null,2,null,3.8369304556354917,null,null,null,null,{"$f":"IF(ISBLANK(K39)=FALSE,1,0)","v":0},{"$f":"IF(ISBLANK(#REF!)=FALSE,(IF(OR((#REF!<2.8),(#REF!>4.2)),1,0)),0)","v":{"$error":"#REF!"}}]
[null,null,5,null,5,null,2.5,null,4.7477744807121658,null,null,null,null,{"$f":"IF(ISBLANK(K40)=FALSE,1,0)","v":0},{"$f":"IF(ISBLANK(#REF!)=FALSE,(IF(OR((#REF!<2.8),(#REF!>4.2)),1,0)),0)","v":{"$error":"#REF!"}}]
[null,null,6,null,6,null,3,null,5.6404230317273809,null,null,null,null,{"$f":"IF(ISBLANK(K41)=FALSE,1,0)","v":0}]
[]
[null,null,{"$f":"IF(SUM(N35:N41)>1,\"ERROR: YOU CAN CHOOSE ONLY DECISION LINE.\",\"\")","v":""}]
[]
[null,"STEP 6. Treat your batch of wine based on your decision in Step 5."]
[]
[null,null,"Volume of wine to be sweetened (from STEP 2):",null,null,null,null,null,null,null,{"$f":"IF(K14=\"\",\"\",K14)","v":""},{"$f":"K6","v":"L"}]
[null,null,"Amount of sugar to add to the batch (DISSOLVE DIRECTLY IN WINE):",null,null,null,null,null,null,null,{"$f":"IF(OR((SUM(N35:N41)>1),(SUM(N35:N41)=0),$K$14=\"\"),\"\",(IF(K6=\"L\",K14,IF(K6=\"hL\",K14*100,K14*3.79))*(IF(ISBLANK(K35)=FALSE,I35,IF(ISBLANK(K36)=FALSE,I36,IF(ISBLANK(K37)=FALSE,I37,IF(ISBLANK(K38)=FALSE,I38,IF(ISBLANK(K39)=FALSE,I39,IF(ISBLANK(K40)=FALSE,I40,IF(ISBLANK(K41)=FALSE,I41,0))))))))))","v":""},"g"]
[]
[null,null,{"$f":"IF(OR((K48=\"\"),(K48=0)),\"\",\"REMINDER: WHEN SWEETENING, EITHER ADD SORBATE OR STERILE FILTER YOUR WINE TO AVOID REFERMENTATION IN BOTTLES.\")","v":""}]
[]
[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)"]