Spreadsheet: 881196d1729156947-need-help-creating-cocktail-costs-based-on-amount-and-bottles-used-alcohol-costs
Sheet: Liquor_List

Scotch | Vendor | SIZE | BTL COST | 1.5oz P | 1oz P | .5oz P
 | [NAME] | 1L | 29.97 | 9 | 6 | 3
[NAME] | Southern | 1L | 22.67 | 7 | 4.5 | 2.5
[NAME], Dekuyper | Southern | 1L | 11.17 | 3.5 | 2.5 | 1.5
Apple Pucker, Dekuyper | Southern | 1L | 8.96 | 3 | 2 | 1
Aviation | Southern | 1L | 28.5 | 8.5 | 6 | 3
[NAME] | Southern | 1L | 19 | 6 | 4 | 2
Bailey's | Southern | 1L | 28.83 | 9 | 6 | 3
Barton Gin | Southern | 1L | 6.58 | 6 | 3 | 1.5
[NAME] | Southern | 1L | 6.92 | 6.5 | 3 | 1.5
Barton Vodka | Southern | 1L | 6.33 | 6 | 3 | 1.5
Blue Curaco, Dekuyper | Southern | 1L | 9.67 | 3 | 2 | 1
Bombay Sapphire | Southern | 1L | 30.33 | 9 | 6 | 3
Buffalo Trace | Harbor | 1L | 27.56 | 8.5 | 5.5 | 3
Butterscotch, Dekuyper | Southern | 1L | 8.96 | 3 | 2 | 1
Captain | Southern | 1L | 19.5 | 6 | 4 | 2
[NAME] | Southern | 1L | 44.33 | 13.5 | 9 | 4.5
[NAME] | Southern | 1L | 46.64 | 14 | 9.5 | 5
Cazadores | Southern | 1L | 34.04 | 10 | 7 | 3.5
Crown Royal | Southern | 1L | 30.58 | 9.5 | 6.5 | 3.5
[NAME] Mary | Vitco | 0 | 12.5 | 2 | 0 | 0
[NAME], Cinzano | Southern | 1L | 7.99 | 2.5 | 2 | 1
E&J | [NAME] | 1L | 10.5 | 3.5 | 2.5 | 1.5
[NAME] | Harbor | 1L | 18.05 | 5.5 | 4 | 2
[NAME] | Southern | 1L | 37.75 | 11.5 | 7.5 | 4
[NAME] | Southern | 1L | 33 | 10 | 6.5 | 3.5
Hendricks | [NAME] | 1L | 42.8 | 13 | 8.5 | 4.5
Hennessy | Southern | 1L | 46 | 14 | 9.5 | 5
[NAME] | Southern | 1L | 22.75 | 7 | 4.5 | 2.5
Island Punch Pucker, Dekuyper | Southern | 1L | 8.96 | 3 | 2 | 1
[NAME] | [NAME] | 1L | 29.36 | 9 | 6 | 3
[NAME] | [NAME] | 1L | 29.36 | 9 | 6 | 3
Jager | Southern | 1L | 26.59 | 8 | 5.5 | 3
Jameson | Southern | 1L | 28.08 | 8.5 | 6 | 3
[NAME] | Southern | 1L | 20.25 | 6 | 4 | 2
[NAME] | Southern | 1L | 38.92 | 11.5 | 8 | 4
Kahlua | Southern | 1L | 24.25 | 7.5 | 5 | 2.5
Ketel One | Southern | 1L | 27.25 | 8.5 | 5.5 | 3
[NAME] | Southern | 1L | 22.67 | 7 | 4.5 | 2.5
[NAME] | Southern | 1L | 32 | 9.5 | 6.5 | 3.5
Malibu | Southern | 1L | 17.75 | 5.5 | 3.5 | 2
Midori | Southern | 1L | 21.33 | 6.5 | 4.5 | 2.5
MOM Mango | [NAME] | 0 | 4 | 1.5 | 0 | 0
[NAME] | [NAME] | 0 | 4 | 1.5 | 0 | 0
MOM Strawberry | [NAME] | 0 | 4 | 1.5 | 0 | 0
[NAME] | Southern | 1L | 8.7 | 8 | 4 | 2
Mr [NAME] | Southern | 1L | 8.42 | 7.5 | 4 | 2
Mr [NAME] | Southern | 1L | 8 | 7.5 | 3.5 | 2
Myers's Dark | Harbor | 1L | 26.63 | 8 | 5.5 | 3
Patron Blanco | Southern | 750ML | 39.7 | 16 | 10.5 | 5.5
Peachtree, Dekuyper | Southern | 1L | 8.96 | 3 | 2 | 1
Pomegranate, Dekuyper | Southern | 1L | 8.94 | 3 | 2 | 1
Razzmataz, Dekuyper | Southern | 1L | 9.67 | 3 | 2 | 1
Rumhaven | [NAME] | 1L | 21.8 | 6.5 | 4.5 | 2.5
Seagrams 7 | Southern | 1L | 15.19 | 4.5 | 3 | 1.5
Seagrams VO | Harbor | 1L | 21.58 | 6.5 | 4.5 | 2.5
Southern Comfort | Harbor | 1L | 23.47 | 7 | 5 | 2.5
Sweet and [NAME] | BB | 0 | 1 | 0.5 | 0 | 0
[NAME], Cinzano | Southern | 1L | 7.99 | 2.5 | 2 | 1
Tangueray | Southern | 1L | 26.5 | 8 | 5.5 | 3
Tito's | [NAME] | 1L | 24.69 | 7.5 | 5 | 2.5
Triple Sec, Barton | Southern | 1L | 5.17 | 2 | 1.5 | 1
Watermelon, Dekuyper | Southern | 1L | 8.96 | 3 | 2 | 1
Woodford | [NAME] | 1L | 37.08 | 11 | 7.5 | 4
0 | 0 | 0 | 25.33 | 8 | 5 | 2.5