{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["2","HELP"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"2","index":0,"n_rows":128,"n_cols":9,"rows_kept":128,"merged":[[102,6,102,8],[103,6,103,8],[104,6,104,8],[105,6,105,8],[106,0,106,8],[108,2,108,7],[111,2,111,8],[113,2,113,8],[114,2,114,8],[115,2,115,8],[117,0,117,2],[118,0,118,8],[120,0,120,1],[122,5,122,8],[123,5,123,8],[124,5,124,8],[125,5,125,8],[126,5,126,8],[127,5,127,8]]}
["INGREDIENT","Grams","PERCENT","IFRA %","1000","New Grams","PRICE","1/2 gr.","NOTES"]
[null,null,{"$f":"B2/$B$102","v":{"$error":"#DIV/0!"}},{"$f":"C2*$B$112","v":{"$error":"#DIV/0!"}},{"$f":"C2*1000","v":{"$error":"#DIV/0!"}},{"$f":"C2*$F$104","v":{"$error":"#DIV/0!"}},null,{"$f":"0.5*B2","v":{"v":0,"d":"0.00gr"}}]
[null,null,{"$error":"#DIV/0!"},{"$f":"C3*$B$112","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"0.5*B36","v":{"v":0,"d":"0.00gr"}}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"0.5*B48","v":{"v":0,"d":"0.00gr"}}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"0.5*B52","v":{"v":0,"d":"0.00gr"}}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"0.5*B55","v":{"v":0,"d":"0.00gr"}}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"0.5*B56","v":{"v":0,"d":"0.00gr"}}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$f":"B66/$B$102","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"C66*$F$104","v":{"$error":"#DIV/0!"}},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$f":"C67*$B$112","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$f":"B73/$B$102","v":{"$error":"#DIV/0!"}},{"$f":"C73*$B$112","v":{"$error":"#DIV/0!"}},{"$f":"C73*1000","v":{"$error":"#DIV/0!"}},{"$f":"C73*$F$104","v":{"$error":"#DIV/0!"}},null,{"$f":"0.5*B73","v":{"v":0,"d":"0.00gr"}}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"v":0,"d":"0.00gr"}]
[null,null,{"$f":"B101/$B$102","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"C101*$F$104","v":{"$error":"#DIV/0!"}},null,{"v":0,"d":"0.00gr"}]
["Your test batch weight in grams is Column B--->",{"$f":"SUM(B2:B101)","v":{"v":0,"d":"0.00gr"}},{"$nulls":4},{"$f":"SUM(G2:G101)","v":{"v":0,"d":"$0.00"}},"<------Your cost of ingredients"]
[{"$nulls":5},{"v":0,"d":"0.0"},"<--enter mls of fragrance oil you need to make."]
[{"$nulls":5},{"$f":"F103*B109","v":{"v":0,"d":"0.0gr"}},"<--the gram equivalent of your desired volume."]
[{"$nulls":5},{"$f":"B113-F103","v":{"v":0,"d":"0.0"}},"<--ml of ethanol you must add (any proof)."]
["Enter the SG2 of the ethanol you're using here->",{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"F105*B106","v":{"v":0,"d":"0.0gr"}},"<--grams of ethanol you must add (Put SG2 in B)"]
["CALCULATE THE GRAMS AND MILLILITERS OF FRAGRANCE OIL AND JUICE1 TO BATCH UP TO FILL A CHOSEN NUMBER OF BOTTLES"]
[]
["Enter the  SG2 of your fragrance oil-------------->",0.985,"<-----Or you can usually guestimate it as around .985"]
["Enter number of bottles you want to fill--------->",0]
["Enter ml capacity of one bottle------------------->",0]
["Enter desired % strength volume of your juice->",{"v":0,"d":"0.0%"},"1Juice = finished product, i.e. fragrance oil + ethanol + water."]
["This is the amount of juice you need (ml)------->",{"$f":"B110*B111","v":{"v":0,"d":"0.0"}}]
["This is the amount of oil you must make (ml)-->",{"$f":"((B110*B111)*B112)","v":{"v":0,"d":"0.0"}},"<-----Put this number [or any number] in Column E on TOTALS LINE"]
["Cost of your fragrance oil per GRAM------------->",{"$f":"G3/F104","v":{"$error":"#DIV/0!"}},"<-----After you input a price for every ingredient, see read-out here."]
["Cost of your fragrance oil per BOTTLE----------->",{"$f":"G102/B110","v":{"$error":"#DIV/0!"}},"<-----After you input a price for every ingredient, see read-out here."]
[]
["1Juice means finished product, ie fragrance oil + ethanol + water."]
["2To calculate the SG of any fluid, measure 100 ml into a graduated cylinder. Determine its weight in grams. This is its Specific Gravity or SG"]
[]
["SG OF ETHANOL & H2O at 25° C  ",null,"By Vol.",null,"By Wt."]
[]
["200 proof:","SG .79 ",{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},"Percent ethanol. (Remainder = H2O)"]
["190 proof:","SG .81",{"v":0.9679,"d":"96.79%"},null,{"v":0.9242,"d":"92.42%"},"Percent ethanol. (Remainder = H2O)"]
["180 proof:","SG .83",{"v":0.9325,"d":"93.25%"},null,{"v":0.8699,"d":"86.99%"},"Percent ethanol. (Remainder = H2O)"]
["170 proof:","SG .84",{"v":0.8946,"d":"89.46%"},null,{"v":0.7944,"d":"79.44%"},"Percent ethanol. (Remainder = H2O)"]
["160 proof:","SG .86",{"v":0.8546,"d":"85.46%"},null,{"v":0.7353,"d":"73.53%"},"Percent ethanol. (Remainder = H2O)"]
["150 proof:","SG .87",{"v":0.8127,"d":"81.27%"},null,{"v":0.6787,"d":"67.87%"},"Percent ethanol. (Remainder = H2O)"]

{"sheet":"HELP","index":1,"n_rows":72,"n_cols":1,"rows_kept":72}
["FRAGRANCE FORMULA WORKBOOK HELP SHEET"]
["Make sure your View Menu is set to \"Page View\""]
["Header access: DOUBLE click in either left, middle or right sections. "]
["Otherwise, you cannot type in those regions. Changing the header on a SHEET won't "]
["change the header on another SHEET."]
["But each SHEET is made of PAGES. They each copy the same header on all pages."]
["DOUBLE click outside of one of the three a header areas when finished there."]
["You can type in any cell just by making it \"active\" with a SINGLE click."]
["You can do the same with cells that are already typed in, but Excel will overtype"]
["the ENTIRE previous contents. If you just want to fix a typo or change something"]
["in a cell, you must DOUBLE click it first, then type. MAKE SURE you hit 'return' ('enter')"]
["as soon as you're done typing there or you'll create a rat's nest you'll regret."]
["You want to be very careful to ALWAYS hit 'return' ('enter') to 'close' a cell "]
["before moving to any other cell. Having two cells 'open' (sticking out in 3-D) at the same"]
["time is a bitch on wheels if you don't know exactly what you're doing. Trust me."]
["You can set your cursor to move either to the next cell to the right or to the next cell "]
["down when you hit return or enter. Change this in Excel Menu 'Preferences.'"]
["If you need to add a row or rows, do this: "]
["Click once in the row BELOW where you want a new row to appear."]
["Go to Menu \"Insert\". Select \"Rows.\" A new row will be created, "]
["but first you must format it for each column's function."]
["Click in the cell above each new cell, move the cursor to that"]
["cell's bottom right corner. It will change from a fat cross to a "]
["hairline one. Drag straight down and your new rows will become"]
["formatted. Repeat with each column. Note that if a function or text was in the cell above,"]
["something will be copied into your new row. Just SINGLE click and overtype it."]
["Remember that even if a cell appears blank, it may still contain formatting information"]
["or a formula, so repeat this process for each cell in each column."]
["At any time while you're tweaking amounts in your formula or adding new items, you can "]
["have Excel maintain your ingredients neatly in ascending or descending order based on"]
["percentage or weight, which of course will be in exactly the same order."]
["To do this, look at the red column title \"PERCENT\". Or you could use the \"Grams\" column."]
["See the tiny arrows pointing up and down? Click and release quickly on these arrows."]
["A menu should drop down which includes \"Sort Ascending\" and \"Sort Descending.\""]
["Chose one or the other as you like. I prefer \"Descending\" instead of perfumers'"]
["traditonal method of using \"Acending Order,\" which I don’t find very intuitive."]
["Your project's ingredients will rearrange themselves instantly into neat ranking order."]
[]
["USING THE \"1/2 Gr\" COLUMN TO SPLIT A TRIAL INTO TWO VARIATIONS"]
[]
["A new column automatically displays 1/2 of the gram weight of each ingredient"]
["you entered in the cells of column B."]
[]
["What's this for?"]
[]
["Say you really like your original experiment and want to keep it, but you want to see what "]
["adding some so-and-so and making some adjustments would do. You'll want to be able"]
["to compare this second altered version with your original one. An easy way to accomplish"]
["this is to decant exactly 1/2 the volume OR weight of your original experiment into a"]
["second bottle. (A graduated cylinder comes in very handy for this). "]
["Regardless of how much alcohol and/or other neutral solvent you had added, "]
["each bottle will now contain exactly half the weight of each aroma ingredient of your"]
["original experiment."]
["Highlight all of the cells of the \"1/2 Gr\" column that now show weights more than zero."]
["Next, use Excel's Menu Edit item \"Copy.\" We're going to paste all these weights into the "]
["\"Grams\" column (Column B). So, mouse over just Cell B2. SINGLE click it.  "]
["BUT DON'T PASTE YET! Go to the Edit Menu and find an item called \"Paste Special...\""]
["You'll be presented with choices of exactly what part of the data you just copied you "]
["want to be pasted in. Select the radio button \"Values\" and below that, under \"Operation,\""]
["select \"None\". Click \"OK\" and that window shuts."]
["Column B now displays exactly half the amount of each ingredient that it did before. "]
["It will round off to two decimal places, but you can prove it's half by requesting a third "]
["decimal place. Next, you clone this sheet into an exact duplicate by alt-(option)-dragging "]
["a new tab toward the right at the worksheet's bottom . "]
["Make sure to rename the new tab (by DOUBLE clicking it first) AND rename the duplicate "]
["sheet's header to read Version 2 or however you prefer to notate it as new and different."]
["Any addiitonal ingredients you put in and any dosage increases you make from now on to "]
["either version should be done with only half the amount you would have used before you "]
["divided your experiment in two. Personally, I often add an unweighed amout of alcohol "]
["before I divide. I don't bother weighing this because at this point I'm not concerned "]
["about the percent strength of my experiment. "]
["That detail comes only after I've created something fantastic."]