Octane Calculator

	A	B	C	D	E	F	G	H	I	J
1	Tank Size (Gallons)	13
2	Target Octane	93
3
4	Blend with 87	87	89	91	93	94	96	98	100	101
5	Price / Gallon	$2.80		$3.19		$4.90	$5.40	$6.10		$6.90
6	% High Octane	N/A			100.00%	85.71%	66.67%	54.55%	46.15%	42.86%
7	Gallons High Octane				13.00	11.14	8.67	7.09	6.00	5.57
8	Gallons Low Octane				0.00	1.86	4.33	5.91	7.00	7.43
9	Cost					$59.79	$58.92	$59.79		$59.23
10
11	Blend with 89	87	89	91	93	94	96	98	100	101
12	Price / Gallon	$2.80		$3.19		$4.90	$5.40	$6.10		$6.90
13	% High Octane	N/A	N/A		100.00%	80.00%	57.14%	44.44%	36.36%	33.33%
14	Gallons High Octane				13.00	10.40	7.43	5.78	4.73	4.33
15	Gallons Low Octane				0.00	2.60	5.57	7.22	8.27	8.67
16	Cost
17
18	Blend with 91	87	89	91	93	94	96	98	100	101
19	Price / Gallon	$2.80		$3.19		$4.90	$5.40	$6.10		$6.90
20	% High Octane	N/A	N/A	N/A	100.00%	66.67%	40.00%	28.57%	22.22%	20.00%
21	Gallons High Octane				13.00	8.67	5.20	3.71	2.89	2.60
22	Gallons Low Octane				0.00	4.33	7.80	9.29	10.11	10.40
23	Cost					$56.28	$52.96	$52.27		$51.11
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100