{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Chaptalizing Juice or Must","SG-Brix-PA","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":"Chaptalizing Juice or Must","index":1,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,1,0,19],[1,1,1,19],[2,1,2,19],[9,4,9,7],[9,8,9,9],[14,12,15,13],[14,15,15,18],[16,17,16,18],[45,8,45,10],[51,1,53,18],[45,1,45,2],[48,1,48,2],[33,3,33,4],[41,8,41,10],[39,17,39,18],[23,8,23,10],[25,8,25,10],[21,17,21,18],[16,2,16,4]]}
[null,"CALCULATOR FOR CHAPTALIZING JUICE OR MUST"]
[null,"Version 1.0"]
[null,"© Daniel Pambianchi, 2021"]
[]
[null,"STEP 1. Choose your units"]
[null,null,"What hydrometer unit are you using: SG or Brix?","SG"]
[null,null,"What volume unit are you using: L, hL or gal?","gal"]
[]
[null,"STEP 2. Enter your juice information and parameters"]
[null,null,"Wine identifier","Vintage","Varietal",null,null,null,"Batch ID"]
[]
[null,null,"Hydrometer reading (initial) - adjusted for TEMP:",null,{"$f":"D6","v":"SG"}]
[null,null,"Actual or estimated juice volume:",null,{"$f":"IF(D7=\"\",\"\",D7)","v":"gal"}]
[]
[null,"STEP 3. Enter your target SG or BRIX, or desired PA",null,null,{"$f":"D6","v":"SG"},null,null,"SUMMARY",null,null,null,null,"Estimated amount of sugar per volume",null,null,"Estimated TOTAL amount of sugar in the juice or must"]
[null,null,"(Enter a value in one box only.)",null,"PA"]
[null,null,{"$f":"IF(AND(D15<>\"\",D16<>\"\"),CONCATENATE(\"ERROR: Enter either your target \",D6,\" or desired PA.\"),\"\")","v":""},null,null,null,null,null,"SG","Brix","Est. PA",null,"(g/L)","(g/gal)",null,"kg",null,"lb         oz"]
[null,null,null,null,null,null,null,"Measured",{"$f":"IF(D12=\"\",\"\",IF(D6=\"SG\",D12,ROUND(LOOKUP(D12,'SG-Brix-PA'!B3:B303,'SG-Brix-PA'!C3:C303),4)))","v":""},{"$f":"IF(D12=\"\",\"\",IF(D6=\"Brix\",D12,LOOKUP(D12,'SG-Brix-PA'!C3:C303,'SG-Brix-PA'!B3:B303)))","v":""},{"$f":"IF(J18=\"\",\"\",ROUND(LOOKUP(J18,'SG-Brix-PA'!B3:B303,'SG-Brix-PA'!F3:F303),2))","v":""},null,{"$f":"IF(I18=\"\",\"\",ROUND((J18*10),0))","v":""},{"$f":"IF(M18=\"\",\"\",ROUND((M18*3.79),0))","v":""},null,{"$f":"IF(M18=\"\",\"\",IF(D13=\"\",\"\",ROUND((M18*D13*(IF(D7=\"L\",1,(IF(D7=\"hL\",100,3.79))))/1000),2)))","v":""},null,{"$f":"IF(P18=\"\",\"\",(TRUNC(TRUNC(P18*16000/453.6)/16)))","v":""},{"$f":"IF(P18=\"\",\"\",(P18*16000/453.6-R18*16))","v":""}]
[null,null,null,null,null,null,null,"Target",{"$f":"IF(OR(AND(D15=\"\",D16=\"\"),C17<>\"\"),\"\",IF(D15=\"\",ROUND(LOOKUP(D16,'SG-Brix-PA'!F3:F303,'SG-Brix-PA'!C3:C303),4),IF(D6=\"Brix\",ROUND(LOOKUP(D15,'SG-Brix-PA'!B3:B303,'SG-Brix-PA'!C3:C303),4),D15)))","v":""},{"$f":"IF(OR(AND(D15=\"\",D16=\"\"),C17<>\"\"),\"\",IF(D15=\"\",LOOKUP(D16,'SG-Brix-PA'!F3:F303,'SG-Brix-PA'!B3:B303),IF(D6=\"SG\",LOOKUP(D15,'SG-Brix-PA'!C3:C303,'SG-Brix-PA'!B3:B303),D15)))","v":""},{"$f":"IF(OR(AND(D15=\"\",D16=\"\"),C17<>\"\"),\"\",IF(D15=\"\",D16,IF(D6=\"SG\",ROUND(LOOKUP(D15,'SG-Brix-PA'!C3:C303,'SG-Brix-PA'!F3:F303),2),ROUND(LOOKUP(D15,'SG-Brix-PA'!B3:B303,'SG-Brix-PA'!F3:F303),2))))","v":""},null,{"$f":"IF(I19=\"\",\"\",ROUND((J19*10),0))","v":""},{"$f":"IF(M19=\"\",\"\",ROUND((M19*3.79),0))","v":""},null,{"$f":"IF(M19=\"\",\"\",IF(D13=\"\",\"\",ROUND((M19*D13*(IF(D7=\"L\",1,(IF(D7=\"hL\",100,3.79))))/1000),2)))","v":""},null,{"$f":"IF(P19=\"\",\"\",(TRUNC(TRUNC(P19*16000/453.6)/16)))","v":""},{"$f":"IF(P19=\"\",\"\",(P19*16000/453.6-R19*16))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg",null,"lb         oz"]
[]
[null,null,null,null,null,null,null,null,"Estimated amount of sugar to add",null,null,null,{"$f":"IF(OR(M18=\"\",M19=\"\",D13=\"\"),\"\",(M19-M18))","v":""},{"$f":"IF(OR(N18=\"\",N19=\"\",D13=\"\"),\"\",(N19-N18))","v":""},null,{"$f":"IF(OR(P18=\"\",P19=\"\"),\"\",ROUND((M24*D13*(IF(D7=\"L\",1,(IF(D7=\"hL\",100,3.79))))/1000),2))","v":""},null,{"$f":"IF(P24=\"\",\"\",IF((ROUND((((P24*2.205)-TRUNC(P24*2.205))*16),0))=16,TRUNC(P24*2.205)+1,TRUNC(P24*2.205)))","v":""},{"$f":"IF(P24=\"\",\"\",ROUND((((P24*2.205)-R24)*16),0))","v":""}]
[]
[null,null,null,null,null,null,null,null,"50% ADDITION",null,null,null,null,null,null,{"$f":"IF(P24=\"\",\"\",ROUND((P24/2),3))","v":""},null,{"$f":"IF(P26=\"\",\"\",IF((ROUND((((P26*2.205)-TRUNC(P26*2.205))*16),0))=16,TRUNC(P26*2.205)+1,TRUNC(P26*2.205)))","v":""},{"$f":"IF(P26=\"\",\"\",ROUND((((P26*2.205)-R26)*16),0))","v":""}]
[]
[]
[null,"STEP 4. Add HALF the calculated amount in Step 3"]
[null,null,"Dissolve the sugar in approximately (of juice)",{"$f":"IF(I19=\"\",\"\",IF(D13=\"\",\"\",IF(OR(D7=\"L\",D7=\"hL\"),IF((ROUND((P26/0.5),0))=0,1,(ROUND((P26/0.5),0))),IF(ROUND((P26/0.5/3.79),0)=0,1,ROUND((P26/0.5/3.79),0)))))","v":""},{"$f":"IF(OR(D7=\"L\",D7=\"hL\"),\"L\",\"gal\")","v":"gal"}]
[]
[null,"STEP 5. Measure SG/BRIX"]
[null,null,"Hydrometer reading (after 50% chaptalization):",null,{"$f":"IF(D6=\"\",\"\",D6)","v":"SG"},null,null,null,"SG","Brix","Est. PA"]
[null,null,null,{"$f":"IF(D33=\"\",\"\",(IF((AND((D33-1)<1,D6=\"SG\")),(IF(D33>D12,\"\",\"ERROR: Invalid entry\")),(IF((AND((D33>=0),D6=\"Brix\")),(IF(D33>D12,\"\",\"ERROR: Invalid entry\")),IF(D33>1.17,\"ERROR: Invalid entry\",\"\"))))))","v":""},null,null,null,"Measured",{"$f":"IF(D33=\"\",\"\",(IF(D34=\"\",(IF(D6=\"SG\",D33,ROUND(LOOKUP(D33,'SG-Brix-PA'!B3:B303,'SG-Brix-PA'!C3:C303),4))),\"\")))","v":""},{"$f":"IF(D33=\"\",\"\",(IF(D34=\"\",(IF(D6=\"Brix\",D33,LOOKUP(D33,'SG-Brix-PA'!C3:C303,'SG-Brix-PA'!B3:B303))),\"\")))","v":""},{"$f":"IF(J34=\"\",\"\",(IF(D34=\"\",ROUND(LOOKUP(J34,'SG-Brix-PA'!B3:B303,'SG-Brix-PA'!F3:F303),2),\"\")))","v":""}]
[null,null,null,null,null,null,null,"Expected Increase",{"$f":"IF(OR(I34=\"\",I18=\"\"),\"\",IF(I19=\"\",\"\",IF(D13=\"\",\"\",(ROUND(((I19-I18)/2),4)))))","v":""},{"$f":"IF(OR(J34=\"\",J18=\"\"),\"\",IF(J19=\"\",\"\",IF(D13=\"\",\"\",(ROUND(((J19-J18)/2),2)))))","v":""},{"$f":"IF(OR(K34=\"\",K18=\"\"),\"\",IF(K19=\"\",\"\",IF(D13=\"\",\"\",(ROUND(((K19-K18)/2),2)))))","v":""}]
[null,null,null,null,null,null,null,"Actual Increase",{"$f":"IF(OR(I34=\"\",I18=\"\"),\"\",(I34-I18))","v":""},{"$f":"IF(OR(J34=\"\",J18=\"\"),\"\",(J34-J18))","v":""},{"$f":"IF(OR(K34=\"\",K18=\"\"),\"\",(K34-K18))","v":""}]
[]
[null,"STEP 6. Perform the second addition"]
[]
[null,null,"Dissolve the sugar in approximately (of juice)",{"$f":"IF(OR(D33=\"\",D34<>\"\"),\"\",IF(I19=\"\",\"\",IF(D13=\"\",\"\",IF(OR(D7=\"L\",D7=\"hL\"),IF((ROUND((P42/0.5),0))=0,1,(ROUND((P42/0.5),0))),IF(ROUND((P42/0.5/3.79),0)=0,1,ROUND((P42/0.5/3.79),0))))))","v":""},{"$f":"IF(OR(D7=\"L\",D7=\"hL\"),\"L\",\"gal\")","v":"gal"},null,null,null,null,null,null,null,null,null,null,"kg",null,"lb         oz"]
[]
[null,null,null,null,null,null,null,null,"SUGAR TO ADD",null,null,null,null,null,null,{"$f":"IF(OR(P26=\"\",J34=\"\"),\"\",ROUND((P26*(J19-J34)/J36),2))","v":""},null,{"$f":"IF(P42=\"\",\"\",IF((ROUND((((P42*2.205)-TRUNC(P42*2.205))*16),0))=16,TRUNC(P42*2.205)+1,TRUNC(P42*2.205)))","v":""},{"$f":"IF(P42=\"\",\"\",ROUND((((P42*2.205)-R42)*16),0))","v":""}]
[]
[]
[]
[null,"SUMMARY OF TOTAL ADDITION",null,null,null,null,null,null,"TOTAL SUGAR ADDED",null,null,null,null,null,null,{"$f":"IF(OR(P26=\"\",P42=\"\"),\"\",P26+P42)","v":""},null,{"$f":"IF(P46=\"\",\"\",IF((ROUND((((P46*2.205)-TRUNC(P46*2.205))*16),0))=16,TRUNC(P46*2.205)+1,TRUNC(P46*2.205)))","v":""},{"$f":"IF(P46=\"\",\"\",ROUND((((P46*2.205)-R46)*16),0))","v":""}]
[]
[]
[null,"REVISED ESTIMATED TOTAL VOLUME\n(including volume due to sugar addition)",null,{"$f":"IF(OR(D33=\"\",D13=\"\"),\"\",IF(D34=\"\",(ROUND(((D13*P46/P24)+(IF(E13=\"L\",(P46*0.625),(IF(E13=\"hL\",(P46*0.625/100),(P46*0.625/3.79)))))),1)),\"\"))","v":""},{"$f":"E13","v":"gal"}]
[]
[null,"COMMENTS"]

{"sheet":"SG-Brix-PA","index":2,"n_rows":303,"n_cols":6,"rows_kept":303,"cut":false,"hidden":true,"merged":[[0,3,0,4]]}
[null,null,null,"Approximate Sugars"]
[null,"°Brix","SG","(g/L)","(g/gal)","PA             (% alc/vol)"]
[null,0,{"$f":"ROUND((265/(265-B3)),3)","v":1},{"$f":"B3*10","v":0},{"$f":"D3*3.79","v":0},{"$f":"D3/17.5","v":0}]
[null,0.1,{"$f":"ROUND((265/(265-B4)),3)","v":1},{"$f":"B4*10","v":1},{"$f":"D4*3.79","v":3.79},{"$f":"D4/17.5","v":5.7142857142857141E-2}]
[null,0.2,1.0009999999999999,2,7.58,0.11428571428571428]
[null,0.3,1.0009999999999999,3,11.370000000000001,0.17142857142857143]
[null,0.4,1.002,4,15.16,0.22857142857142856]
[null,0.5,1.002,5,18.95,0.2857142857142857]
[null,0.6,1.002,6,22.740000000000002,0.34285714285714286]
[null,0.7,1.0029999999999999,7,26.53,0.4]
[null,0.8,1.0029999999999999,8,30.32,0.45714285714285713]
[null,0.9,1.0029999999999999,9,34.11,0.51428571428571423]
[null,1,1.004,10,37.9,0.5714285714285714]
[null,1.1000000000000001,1.004,11,41.69,0.62857142857142856]
[null,1.2,1.0049999999999999,12,45.480000000000004,0.68571428571428572]
[null,1.3,1.0049999999999999,13,49.27,0.74285714285714288]
[null,1.4,1.0049999999999999,14,53.06,0.8]
[null,1.5,1.006,15,56.85,0.8571428571428571]
[null,1.6,1.006,16,60.64,0.91428571428571426]
[null,1.7,1.006,17,64.430000000000007,0.97142857142857142]
[null,1.8,1.0069999999999999,18,68.22,1.0285714285714285]
[null,1.9,1.0069999999999999,19,72.010000000000005,1.0857142857142856]
[null,2,1.008,20,75.8,1.1428571428571428]
[null,2.1,1.008,21,79.59,1.2]
[null,2.2000000000000002,1.008,22,83.38,1.2571428571428571]
[null,2.2999999999999998,1.0089999999999999,23,87.17,1.3142857142857143]
[null,2.4,1.0089999999999999,24,90.960000000000008,1.3714285714285714]
[null,2.5,1.01,25,94.75,1.4285714285714286]
[null,2.6,1.01,26,98.54,1.4857142857142858]
[null,2.7,1.01,27,102.33,1.5428571428571429]
[null,2.8,1.0109999999999999,28,106.12,1.6]
[null,2.9,1.0109999999999999,29,109.91,1.6571428571428573]
[null,3,1.0109999999999999,30,113.7,1.7142857142857142]
[null,3.1,1.012,31,117.49,1.7714285714285714]
[null,3.2,1.012,32,121.28,1.8285714285714285]
[null,3.3,1.0129999999999999,33,125.07000000000001,1.8857142857142857]
[null,3.4,1.0129999999999999,34,128.86000000000001,1.9428571428571428]
[null,3.5,1.0129999999999999,35,132.65,2]
[null,3.6,1.014,36,136.44,2.0571428571428569]
[null,3.7,1.014,37,140.22999999999999,2.1142857142857143]
[null,3.8,1.0149999999999999,38,144.02000000000001,2.1714285714285713]
[null,3.9,1.0149999999999999,39,147.81,2.2285714285714286]
[null,4,1.0149999999999999,40,151.6,2.2857142857142856]
[null,4.0999999999999996,1.016,41,155.39000000000001,2.342857142857143]
[null,4.2,1.016,42,159.18,2.4]
[null,4.3,1.016,43,162.97,2.4571428571428573]
[null,4.4000000000000004,1.0169999999999999,44,166.76,2.5142857142857142]
[null,4.5,1.0169999999999999,45,170.55,2.5714285714285716]
[null,4.5999999999999996,1.018,46,174.34,2.6285714285714286]
[null,4.7,1.018,47,178.13,2.6857142857142855]
[null,4.8,1.018,48,181.92000000000002,2.7428571428571429]
[null,4.9000000000000004,1.0189999999999999,49,185.71,2.8]
[null,5,1.0189999999999999,50,189.5,2.8571428571428572]
[null,5.0999999999999996,1.02,51,193.29,2.9142857142857141]
[null,5.2,1.02,52,197.08,2.9714285714285715]
[null,5.3,1.02,53,200.87,3.0285714285714285]
[null,5.4,1.0209999999999999,54,204.66,3.0857142857142859]
[null,5.5,1.0209999999999999,55,208.45,3.1428571428571428]
[null,5.6,1.022,56,212.24,3.2]
[null,5.7,1.022,57,216.03,3.2571428571428571]
[null,5.8,1.022,58,219.82,3.3142857142857145]
[null,5.9,1.0229999999999999,59,223.61,3.3714285714285714]
[null,6,1.0229999999999999,60,227.4,3.4285714285714284]
[null,6.1,1.024,61,231.19,3.4857142857142858]
[null,6.2,1.024,62,234.98,3.5428571428571427]
[null,6.3,1.024,63,238.77,3.6]
[null,6.4,1.0249999999999999,64,242.56,3.657142857142857]
[null,6.5,{"$f":"ROUND((265/(265-B68)),3)","v":1.0249999999999999},{"$f":"B68*10","v":65},{"$f":"D68*3.79","v":246.35},{"$f":"D68/17.5","v":3.7142857142857144}]
[null,6.6,1.026,66,250.14000000000001,3.7714285714285714]
[null,6.7,1.026,67,253.93,3.8285714285714287]
[null,6.8,1.026,68,257.72000000000003,3.8857142857142857]
[null,6.9,1.0269999999999999,69,261.51,3.9428571428571431]
[null,7,1.0269999999999999,70,265.3,4]
[null,7.1,1.028,71,269.08999999999997,4.0571428571428569]
[null,7.2,1.028,72,272.88,4.1142857142857139]
[null,7.3,1.028,73,276.67,4.1714285714285717]
[null,7.4,1.0289999999999999,74,280.45999999999998,4.2285714285714286]
[null,7.5,1.0289999999999999,75,284.25,4.2857142857142856]
[null,7.6,1.03,76,288.04000000000002,4.3428571428571425]
[null,7.7,1.03,77,291.83,4.4000000000000004]
[null,7.8,1.03,78,295.62,4.4571428571428573]
[null,7.9,1.0309999999999999,79,299.41000000000003,4.5142857142857142]
[null,8,1.0309999999999999,80,303.2,4.5714285714285712]
[null,8.1,1.032,81,306.99,4.628571428571429]
[null,8.1999999999999993,1.032,82,310.78000000000003,4.6857142857142859]
[null,8.3000000000000007,1.032,83,314.57,4.7428571428571429]
[null,8.4,1.0329999999999999,84,318.36,4.8]
[null,8.5,1.0329999999999999,85,322.14999999999998,4.8571428571428568]
[null,8.6,1.034,86,325.94,4.9142857142857146]
[null,8.6999999999999993,1.034,87,329.73,4.9714285714285715]
[null,8.8000000000000007,1.034,88,333.52,5.0285714285714285]
[null,8.9,1.0349999999999999,89,337.31,5.0857142857142854]
[null,9,1.0349999999999999,90,341.1,5.1428571428571432]
[null,9.1,1.036,91,344.89,5.2]
[null,9.1999999999999993,1.036,92,348.68,5.2571428571428571]
[null,9.3000000000000007,1.036,93,352.47,5.3142857142857141]
[null,9.4,1.0369999999999999,94,356.26,5.371428571428571]
[null,9.5,1.0369999999999999,95,360.05,5.4285714285714288]
[null,9.6,1.038,96,363.84000000000003,5.4857142857142858]
[null,9.6999999999999993,1.038,97,367.63,5.5428571428571427]
[null,9.8000000000000007,1.038,98,371.42,5.6]
[null,9.9,1.0389999999999999,99,375.21,5.6571428571428575]
[null,10,1.0390999999999999,100,379,5.7142857142857144]
[null,10.1,1.0395000000000001,101,382.79,5.7714285714285714]
[null,10.199999999999999,1.0399,102,386.58,5.8285714285714283]
[null,10.3,1.0403,103,390.37,5.8857142857142861]
[null,10.4,1.0407,104,394.16,5.9428571428571431]
[null,10.5,1.0410999999999999,105,397.95,6]
[null,10.6,1.0415000000000001,106,401.74,6.0571428571428569]
[null,10.7,1.0419,107,405.53000000000003,6.1142857142857139]
[null,10.8,1.0423,108,409.32,6.1714285714285717]
[null,10.9,1.0427,109,413.11,6.2285714285714286]
[null,11,1.0430999999999999,110,416.9,6.2857142857142856]
[null,11.1,1.0436000000000001,111,420.69,6.3428571428571425]
[null,11.2,1.044,112,424.48,6.4]
[null,11.3,1.0444,113,428.27,6.4571428571428573]
[null,11.4,1.0448,114,432.06,6.5142857142857142]
[null,11.5,1.0451999999999999,115,435.85,6.5714285714285712]
[null,11.6,1.0456000000000001,116,439.64,6.628571428571429]
[null,11.7,1.046,117,443.43,6.6857142857142859]
[null,11.8,1.0464,118,447.22,6.7428571428571429]
[null,11.9,1.0468,119,451.01,6.8]
[null,12,1.0471999999999999,120,454.8,6.8571428571428568]
[null,12.1,1.0477000000000001,121,458.59000000000003,6.9142857142857146]
[null,12.2,1.0481,122,462.38,6.9714285714285715]
[null,12.3,1.0485,123,466.17,7.0285714285714285]
[null,12.4,1.0488999999999999,124,469.96,7.0857142857142854]
[null,12.5,1.0492999999999999,125,473.75,7.1428571428571432]
[null,12.6,1.0497000000000001,126,477.54,7.2]
[null,12.7,1.0501,127,481.33,7.2571428571428571]
[null,12.8,1.0506,128,485.12,7.3142857142857141]
[null,12.9,1.0509999999999999,{"$f":"B132*10","v":129},{"$f":"D132*3.79","v":488.91},{"$f":"D132/17.5","v":7.371428571428571}]
[null,13,1.0513999999999999,130,492.7,7.4285714285714288]
[null,13.1,1.0518000000000001,131,496.49,7.4857142857142858]
[null,13.2,1.0522,132,500.28000000000003,7.5428571428571427]
[null,13.3,1.0527,133,504.07,7.6]
[null,13.4,1.0530999999999999,134,507.86,7.6571428571428575]
[null,13.5,1.0535000000000001,135,511.65,7.7142857142857144]
[null,13.6,1.0539000000000001,136,515.44000000000005,7.7714285714285714]
[null,13.7,1.0543,137,519.23,7.8285714285714283]
[null,13.8,1.0548,138,523.02,7.8857142857142861]
[null,13.9,1.0551999999999999,139,526.81000000000006,7.9428571428571431]
[null,14,1.0556000000000001,140,530.6,8]
[null,14.1,1.056,141,534.39,8.0571428571428569]
[null,14.2,1.0564,142,538.17999999999995,8.1142857142857139]
[null,14.3,1.0569,143,541.97,8.1714285714285708]
[null,14.4,1.0572999999999999,144,545.76,8.2285714285714278]
[null,14.5,1.0577000000000001,145,549.54999999999995,8.2857142857142865]
[null,14.6,1.0581,146,553.34,8.3428571428571434]
[null,14.7,1.0586,147,557.13,8.4]
[null,14.8,1.0589999999999999,148,560.91999999999996,8.4571428571428573]
[null,14.9,1.0593999999999999,149,564.71,8.5142857142857142]
[null,15,1.0598000000000001,150,568.5,8.5714285714285712]
[null,15.1,1.0603,151,572.29,8.6285714285714281]
[null,15.2,1.0607,152,576.08000000000004,8.6857142857142851]
[null,15.3,1.0610999999999999,153,579.87,8.742857142857142]
[null,15.4,1.0616000000000001,154,583.66,8.8000000000000007]
[null,15.5,1.0620000000000001,155,587.45000000000005,8.8571428571428577]
[null,15.6,1.0624,156,591.24,8.9142857142857146]
[null,15.7,1.0628,157,595.03,8.9714285714285715]
[null,15.8,1.0632999999999999,158,598.82000000000005,9.0285714285714285]
[null,15.9,1.0637000000000001,159,602.61,9.0857142857142854]
[null,16,1.0641,160,606.4,9.1428571428571423]
[null,16.100000000000001,1.0646,161,610.19000000000005,9.1999999999999993]
[null,16.2,1.0649999999999999,162,613.98,9.257142857142858]
[null,16.3,1.0653999999999999,163,617.77,9.3142857142857149]
[null,16.399999999999999,1.0659000000000001,164,621.56000000000006,9.3714285714285719]
[null,16.5,1.0663,165,625.35,9.4285714285714288]
[null,16.600000000000001,1.0667,166,629.14,9.4857142857142858]
[null,16.7,1.0671999999999999,167,632.92999999999995,9.5428571428571427]
[null,16.8,1.0676000000000001,168,636.72,9.6]
[null,16.899999999999999,1.0680000000000001,169,640.51,9.6571428571428566]
[null,17,1.0685,170,644.29999999999995,9.7142857142857135]
[null,17.100000000000001,1.0689,171,648.09,9.7714285714285722]
[null,17.2,1.0692999999999999,172,651.88,9.8285714285714292]
[null,17.3,1.0698000000000001,173,655.67,9.8857142857142861]
[null,17.399999999999999,1.0702,174,659.46,9.9428571428571431]
[null,17.5,1.0707,175,663.25,10]
[null,17.600000000000001,1.0710999999999999,176,667.04,10.057142857142857]
[null,17.7,1.0714999999999999,177,670.83,10.114285714285714]
[null,17.8,1.0720000000000001,178,674.62,10.171428571428571]
[null,17.899999999999999,1.0724,179,678.41,10.228571428571428]
[null,18,1.0729,180,682.2,10.285714285714286]
[null,18.100000000000001,1.0732999999999999,181,685.99,10.342857142857143]
[null,18.2,1.0737000000000001,182,689.78,10.4]
[null,18.3,1.0742,183,693.57,10.457142857142857]
[null,18.399999999999999,1.0746,184,697.36,10.514285714285714]
[null,18.5,1.0750999999999999,185,701.15,10.571428571428571]
[null,18.600000000000001,1.0754999999999999,186,704.94,10.628571428571428]
[null,18.7,1.0760000000000001,187,708.73,10.685714285714285]
[null,18.8,1.0764,188,712.52,10.742857142857142]
[null,18.899999999999999,1.0768,189,716.31000000000006,10.8]
[null,19,1.0772999999999999,190,720.1,10.857142857142858]
[null,19.100000000000001,1.0777000000000001,191,723.89,10.914285714285715]
[null,19.2,1.0782,192,727.68000000000006,10.971428571428572]
[null,19.3,1.0786,{"$f":"B196*10","v":193},{"$f":"D196*3.79","v":731.47},{"$f":"D196/17.5","v":11.028571428571428}]
[null,19.399999999999999,1.0790999999999999,194,735.26,11.085714285714285]
[null,19.5,1.0794999999999999,195,739.05,11.142857142857142]
[null,19.600000000000001,1.08,196,742.84,11.2]
[null,19.7,1.0804,197,746.63,11.257142857142858]
[null,19.8,1.0809,198,750.42,11.314285714285715]
[null,19.899999999999999,1.0812999999999999,199,754.21,11.371428571428572]
[null,20,1.0818000000000001,200,758,11.428571428571429]
[null,20.100000000000001,1.0822000000000001,201,761.79,11.485714285714286]
[null,20.2,1.0827,202,765.58,11.542857142857143]
[null,20.3,1.0831,203,769.37,11.6]
[null,20.399999999999999,1.0835999999999999,204,773.16,11.657142857142857]
[null,20.5,1.0840000000000001,205,776.95,11.714285714285714]
[null,20.6,1.0845,206,780.74,11.771428571428572]
[null,20.7,1.0849,207,784.53,11.828571428571429]
[null,20.8,1.0853999999999999,208,788.32,11.885714285714286]
[null,20.9,1.0858000000000001,209,792.11,11.942857142857143]
[null,21,1.0863,210,795.9,12]
[null,21.1,1.0867,211,799.69,12.057142857142857]
[null,21.2,1.0871999999999999,212,803.48,12.114285714285714]
[null,21.3,1.0875999999999999,213,807.27,12.171428571428571]
[null,21.4,1.0881000000000001,214,811.06000000000006,12.228571428571428]
[null,21.5,1.0885,215,814.85,12.285714285714286]
[null,21.6,1.089,216,818.64,12.342857142857143]
[null,21.7,1.0894999999999999,217,822.43000000000006,12.4]
[null,21.8,1.0899000000000001,218,826.22,12.457142857142857]
[null,21.9,1.0904,219,830.01,12.514285714285714]
[null,22,1.0908,220,833.8,12.571428571428571]
[null,22.1,1.0912999999999999,221,837.59,12.628571428571428]
[null,22.2,1.0916999999999999,222,841.38,12.685714285714285]
[null,22.3,1.0922000000000001,223,845.17,12.742857142857142]
[null,22.4,1.0927,224,848.96,12.8]
[null,22.5,1.0931,225,852.75,12.857142857142858]
[null,22.6,1.0935999999999999,226,856.54,12.914285714285715]
[null,22.7,1.0940000000000001,227,860.33,12.971428571428572]
[null,22.8,1.0945,228,864.12,13.028571428571428]
[null,22.9,1.095,229,867.91,13.085714285714285]
[null,23,1.0953999999999999,230,871.7,13.142857142857142]
[null,23.1,1.0959000000000001,231,875.49,13.2]
[null,23.2,1.0964,232,879.28,13.257142857142858]
[null,23.3,1.0968,233,883.07,13.314285714285715]
[null,23.4,1.0972999999999999,234,886.86,13.371428571428572]
[null,23.5,1.0976999999999999,235,890.65,13.428571428571429]
[null,23.6,1.0982000000000001,236,894.44,13.485714285714286]
[null,23.7,1.0987,237,898.23,13.542857142857143]
[null,23.8,1.0991,238,902.02,13.6]
[null,23.9,1.0995999999999999,239,905.81000000000006,13.657142857142857]
[null,24,1.1001000000000001,240,909.6,13.714285714285714]
[null,24.1,1.1005,241,913.39,13.771428571428572]
[null,24.2,1.101,242,917.18000000000006,13.828571428571429]
[null,24.3,1.1014999999999999,243,920.97,13.885714285714286]
[null,24.4,1.1019000000000001,244,924.76,13.942857142857143]
[null,24.5,1.1024,245,928.55,14]
[null,24.6,1.1029,246,932.34,14.057142857142857]
[null,24.7,1.1032999999999999,247,936.13,14.114285714285714]
[null,24.8,1.1037999999999999,248,939.92,14.171428571428571]
[null,24.9,1.1043000000000001,249,943.71,14.228571428571428]
[null,25,1.1047,250,947.5,14.285714285714286]
[null,25.1,1.1052,251,951.29,14.342857142857143]
[null,25.2,1.1056999999999999,252,955.08,14.4]
[null,25.3,1.1062000000000001,253,958.87,14.457142857142857]
[null,25.4,1.1066,254,962.66,14.514285714285714]
[null,25.5,1.1071,255,966.45,14.571428571428571]
[null,25.6,1.1075999999999999,256,970.24,14.628571428571428]
[null,25.7,1.1080000000000001,{"$f":"B260*10","v":257},{"$f":"D260*3.79","v":974.03},{"$f":"D260/17.5","v":14.685714285714285}]
[null,25.8,1.1085,258,977.82,14.742857142857142]
[null,25.9,1.109,259,981.61,14.8]
[null,26,1.1094999999999999,260,985.4,14.857142857142858]
[null,26.1,1.1099000000000001,261,989.19,14.914285714285715]
[null,26.2,1.1104000000000001,262,992.98,14.971428571428572]
[null,26.3,1.1109,263,996.77,15.028571428571428]
[null,26.4,1.1113999999999999,264,1000.5600000000001,15.085714285714285]
[null,26.5,1.1117999999999999,265,1004.35,15.142857142857142]
[null,26.6,1.1123000000000001,266,1008.14,15.2]
[null,26.7,1.1128,267,1011.9300000000001,15.257142857142858]
[null,26.8,1.1133,268,1015.72,15.314285714285715]
[null,26.9,1.1137999999999999,269,1019.51,15.371428571428572]
[null,27,1.1142000000000001,270,1023.3,15.428571428571429]
[null,27.1,1.1147,271,1027.0899999999999,15.485714285714286]
[null,27.2,1.1152,272,1030.8800000000001,15.542857142857143]
[null,27.3,1.1156999999999999,273,1034.67,15.6]
[null,27.4,1.1161000000000001,274,1038.46,15.657142857142857]
[null,27.5,1.1166,275,1042.25,15.714285714285714]
[null,27.6,1.1171,276,1046.04,15.771428571428572]
[null,27.7,1.1175999999999999,277,1049.83,15.828571428571429]
[null,27.8,1.1181000000000001,278,1053.6200000000001,15.885714285714286]
[null,27.9,1.1185,279,1057.4100000000001,15.942857142857143]
[null,28,1.119,280,1061.2,16]
[null,28.1,1.1194999999999999,281,1064.99,16.057142857142857]
[null,28.2,1.1200000000000001,282,1068.78,16.114285714285714]
[null,28.3,1.1205000000000001,283,1072.57,16.171428571428571]
[null,28.4,1.121,284,1076.3599999999999,16.228571428571428]
[null,28.5,1.1214,285,1080.1500000000001,16.285714285714285]
[null,28.6,1.1218999999999999,286,1083.94,16.342857142857142]
[null,28.7,1.1224000000000001,287,1087.73,16.399999999999999]
[null,28.8,1.1229,288,1091.52,16.457142857142856]
[null,28.9,1.1234,289,1095.31,16.514285714285716]
[null,29,1.1238999999999999,290,1099.0999999999999,16.571428571428573]
[null,29.1,1.1244000000000001,291,1102.8900000000001,16.62857142857143]
[null,29.2,1.1248,292,1106.68,16.685714285714287]
[null,29.3,1.1253,293,1110.47,16.742857142857144]
[null,29.4,1.1257999999999999,294,1114.26,16.8]
[null,29.5,1.1263000000000001,295,1118.05,16.857142857142858]
[null,29.6,1.1268,296,1121.8399999999999,16.914285714285715]
[null,29.7,1.1273,297,1125.6300000000001,16.971428571428572]
[null,29.8,1.1277999999999999,298,1129.42,17.028571428571428]
[null,29.9,1.1283000000000001,299,1133.21,17.085714285714285]
[null,30,1.1287,300,1137,17.142857142857142]

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