{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Blending Multiple Wines","Blending to desired % ABV,TA,pH","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Blending Multiple Wines","index":1,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[0,1,0,9],[1,1,1,9],[2,1,2,9],[22,3,22,4],[21,3,21,4],[6,5,6,9]]}
[null,"BLENDING MULTIPLE WINES"]
[null,"Version 2.0"]
[null,"© Daniel Pambianchi, 2024"]
[]
[null,"What volume unit are you using: L, hL or gal?",null,null,null,null,"L"]
[]
[null,"STEP 1. Name the blend:"]
[]
[null,"STEP 2. Identify the component wines and parameters"]
[]
[null,null,"Vintage","Varietal","Batch ID","% of blend",{"$f":"CONCATENATE(\"Volume (\",G5,\")\")","v":"Volume (L)"},"% ABV","TA","pH"]
[null,null,null,null,null,{"$f":"IF($G$23<>\"\",IF(G12<>\"\",G12/$G$23,\"\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF((AND(ISBLANK(G12),ISBLANK(H12),ISBLANK(I12),ISBLANK(J12))),\"\",(IF(OR(ISBLANK(G12),ISBLANK(H12),ISBLANK(I12),ISBLANK(J12)),(CONCATENATE(\"Enter value in \",(IF(ISBLANK(G12),\"Volume\",(IF(ISBLANK(H12),\"% ABV\",(IF(ISBLANK(I12),\"TA\",(IF(ISBLANK(J12),\"pH\")))))))),\" field\")),\"\")))","v":""}]
[null,null,null,null,null,{"$f":"IF($G$23<>\"\",IF(G13<>\"\",G13/$G$23,\"\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF((AND(ISBLANK(G13),ISBLANK(H13),ISBLANK(I13),ISBLANK(J13))),\"\",(IF(OR(ISBLANK(G13),ISBLANK(H13),ISBLANK(I13),ISBLANK(J13)),(CONCATENATE(\"Enter value in \",(IF(ISBLANK(G13),\"Volume\",(IF(ISBLANK(H13),\"% ABV\",(IF(ISBLANK(I13),\"TA\",(IF(ISBLANK(J13),\"pH\")))))))),\" field\")),\"\")))","v":""}]
[null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,null,""]
[]
[null,"STEP 3. Results for FINAL BLEND"]
[]
[null,null,null,"FINAL BLEND",null,null,{"$f":"CONCATENATE(\"Volume (\",G5,\")\")","v":"Volume (L)"},"% ABV","TA","Est'd\npH"]
[null,null,null,{"$f":"IF(F7<>\"\",IF($G$23<>\"\",F7,\"\"),\"\")","v":""},null,{"$f":"IF(G23=\"\",\"\",SUM(F12:F18))","v":""},{"$f":"IF(SUM(G12:G18)=0,\"\",IF(AND(L12=\"\",L13=\"\",L14=\"\",L15=\"\",L16=\"\",L17=\"\",L18=\"\"),SUM(G12:G18),\"\"))","v":""},{"$f":"IF(G23=\"\",\"\",(SUMPRODUCT(G12:G18,H12:H18)/$G$23))","v":""},{"$f":"IF(G23=\"\",\"\",(SUMPRODUCT(G12:G18,I12:I18))/G23)","v":""},{"$f":"IF(G23=\"\",\"\",-LOG(((10^-J12)*G12+(10^-J13)*G13+(10^-J14)*G14+(10^-J15)*G15+(10^-J16)*G16+(10^-J17)*G17+(10^-J18)*G18)/G23))","v":""}]
[]
[null,"Comments"]

{"sheet":"Blending to desired % ABV,TA,pH","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[28,1,28,9],[29,1,29,9],[30,1,30,9],[0,1,0,9],[1,1,1,9],[2,1,2,9],[27,1,27,9],[21,2,21,9]]}
[null,"BLENDING FOR A DESIRED % ABV, TA OR PH"]
[null,"Version 2.0"]
[null,"© Daniel Pambianchi, 2024"]
[]
[null,"What volume unit are you using: L, hL or gal?",null,null,null,"L"]
[]
[null,"STEP 1. Identify the parameters of the wine to be \"corrected\""]
[]
[null,null,"Vintage","Varietal ","Batch ID",{"$f":"CONCATENATE(\"Volume (\",F5,\")\")","v":"Volume (L)"},"% ABV","TA","pH"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((AND(ISBLANK(F10),ISBLANK(G10),ISBLANK(H10),ISBLANK(I10))),\"\",(IF(OR(ISBLANK(F10),ISBLANK(G10),ISBLANK(H10),ISBLANK(I10)),(CONCATENATE(\"Enter value in \",(IF(ISBLANK(F10),\"Volume\",(IF(ISBLANK(G10),\"% ABV\",(IF(ISBLANK(H10),\"TA\",(IF(ISBLANK(I10),\"pH\",\"\")))))))),\" field\")),\"\")))","v":""}]
[]
[null,"STEP 2. Set your target % ABV, TA, or pH; enter one field ONLY"]
[]
[null,null,null,null,null,null,"% ABV","TA","pH"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(G15),ISBLANK(H15),ISBLANK(I15)),\"\",IF(OR(AND(G15<>0,H15<>0),AND(G15<>0,I15<>0),AND(H15<>0,I15<>0)),\"Enter value in ONE field only\",(IF(AND(ISBLANK(H15),ISBLANK(I15)),(IF(G20<>\"\",IF(OR(AND(G15>G10,G15<G20),AND(G15<G10,G15>G20)),\"\",\"Value out of range\"),\"\")),(IF(AND(ISBLANK(G15),ISBLANK(H15)),(IF(I20<>\"\",IF(OR(AND(I15>I10,I15<I20),AND(I15<I10,I15>I20)),\"\",\"Value out of range\"),\"\")),(IF(AND(ISBLANK(G15),ISBLANK(I15)),(IF(H20<>\"\",IF(OR(AND(H15>H10,H15<H20),AND(H15<H10,H15>H20)),\"\",\"Value out of range\"),\"\")),\"\"))))))))","v":""}]
[]
[null,"STEP 3. Identify the blending wine and enter its % ABV, TA, and pH"]
[]
[null,null,"Vintage","Varietal ","Batch ID",{"$f":"CONCATENATE(\"Volume (\",F5,\")\")","v":"Volume (L)"},"% ABV","TA","pH"]
[null,null,null,null,null,{"$f":"IF(OR(AND(ISBLANK(G20),ISBLANK(H20),ISBLANK(I20)),L15=\"Value out of range\",L15=\"Enter value in ONE field only\",AND(ISBLANK(G15),ISBLANK(H15),ISBLANK(I15)),L20=\"Enter value in % ABV field\",L20=\"Enter value in TA field\",L20=\"Enter value in pH field\",F10=\"\",L10=\"Enter value in Volume field\",L10=\"Enter value in % ABV field\",L10=\"Enter value in TA field\",L10=\"Enter value in pH field\"),\"\",(F10*(IF(AND(ISBLANK(G15),ISBLANK(I15)),ROUND((H10-H15)/(H15-H20),3),(IF(AND(ISBLANK(H15),ISBLANK(I15)),ROUND((G10-G15)/(G15-G20),3),ROUND(((POWER(10,-I10))*F10-(POWER(10,-I15)*F10))/(POWER(10,-I15)-POWER(10,-I20))/F10,3)))))))","v":""},null,null,null,null,null,{"$f":"IF((AND(ISBLANK(G20),ISBLANK(H20),ISBLANK(I20))),\"\",(IF(OR(ISBLANK(G20),ISBLANK(H20),ISBLANK(I20)),(CONCATENATE(\"Enter value in \",(IF(ISBLANK(G20),\"% ABV\",(IF(ISBLANK(H20),\"TA\",(IF(ISBLANK(I20),\"pH\",\"\")))))),\" field\")),\"\")))","v":""}]
[]
[null,null,{"$f":"IF(F20<>\"\",CONCATENATE(\"Add \",F20,\" \",F5,\" of \",IF(D20<>\"\",CONCATENATE(C20,\" \",D20),\" blending wine\"),\" to your \",IF(D10<>\"\",CONCATENATE(C10,\" \",D10),\"'to be corrected'\"),\" batch.\"),\"\")","v":""}]
[]
[null,"STEP 4. Results for the FINAL BLEND"]
[null,null,null,null,null,{"$f":"CONCATENATE(\"Volume (\",F5,\")\")","v":"Volume (L)"},"% ABV","TA","Est'd\npH"]
[null,null,null,{"$f":"IF(F26=\"\",\"\",\"BLENDED WINE\")","v":""},null,{"$f":"IF($F$20=\"\",\"\",(F10+F20))","v":""},{"$f":"IF($F$20=\"\",\"\",(($F$20*G20+$F$10*G10)/($F$20+$F$10)))","v":""},{"$f":"IF($F$20=\"\",\"\", IF($H$20=\"\",\"\",(($F$20*H20+$F$10*H10)/($F$20+$F$10))))","v":""},{"$f":"IF($F$20=\"\",\"\", IF($H$20=\"\",\"\",-LOG(((10^-I20)*$F$20+(10^-I10)*$F$10)/($F$20+$F$10))))","v":""}]
[]
[null,"COMMENTS"]

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