Any Mathematics Fat-Heads Out There?

OldAA130 · Post by **OldAA130** » Tue. Mar. 26, 2013 6:34 pm

Anyone ever plot a line for fuel level in a standard 275 gallon vertical fuel tank. I'd like to obtain the equation to the line for gallons in the tank... then plug it into a program that will allow the office guy to dip the tank and simply enter the number and out spits the gallons. I tried excel thinking this would be a polynomial equation... but it didn't seem to work.

height gallons
1 2
2 5
3 9
4 14
5 19
6 25
7 31
8 38
9 44
10 51
11 58
12 65
13 72
14 79
15 86
16 94
17 101
18 108
19 115
20 122
21 129
22 136
23 143
24 151
25 158
26 165
27 172
28 179
29 186
30 193
31 200
32 207
33 214
34 221
35 228
36 235
37 242
38 248
39 254
40 259
41 264
42 268
43 272
44 275

Thanks everyone.
Tom Hart

Dennis · Post by **Dennis** » Tue. Mar. 26, 2013 6:55 pm

my oil man gave me this back when I was buying oil
EDIT:the little circles on the 275 gallon tanks mean horizonal and vertical tank mounts
if you print out the chart, stick it on the tank for quick reference

michaelanthony · Post by **michaelanthony** » Tue. Mar. 26, 2013 7:49 pm

blocklayer.com is an excellent site for this and countless other formulas!

coalnewbie · Post by **coalnewbie** » Tue. Mar. 26, 2013 7:51 pm

OK, here is a quiz on what you learned. Last Sept I dipped the tank and had 25" of oil and now it's 25" left, how much coal did I use this winter.

NoSmoke · Post by **NoSmoke** » Tue. Mar. 26, 2013 8:01 pm

I keep track of my on-farm Off-Road Diesel Fuel which is held in a 275 gallon oil drum, and what I do is just calculate each day how many gallons have been consumed by the equipment on this farm. By deducting how much fuel is used, I automatically know how much fuel is in the tank...and what I am really after...what the value of that off-road fuel is. This is for taxes, and for my net income statements, and just so I know how much is in the tank and how much I consume over a week/month/year. At the same time, the excel spreadsheet predicts when the fuel will be used up and on what date it will run out, which is handy for reordering, especially since rural delivery such as me, only happens on Mondays.

In a way it is a much better system then what you propose because you must go out and manually "dip" the tank, where as with my system, I already know the gallons in the tank without having to even approach the tank, and other projected factors are calculated automatically every day since I do a daily farm input log. It also kicks out a neat little line graph of how much fuel is being consumed based over a calendar year!

KLook · Post by **KLook** » Tue. Mar. 26, 2013 9:39 pm

That's great NoSmoke unless the meth-head over the hill is helping himself to your tank.

Kevin

lsayre · Post by **lsayre** » Tue. Mar. 26, 2013 9:56 pm

Try this: http://www.calculatorsoup.com/calculators/constru ... n/tank.php

Select for "Vertical Oval" and have at it. For geeks (like me), the formulas are presented on the website as well.

Post by **Lightning** » Tue. Mar. 26, 2013 11:05 pm

coalnewbie wrote:OK, here is a quiz on what you learned. Last Sept I dipped the tank and had 25" of oil and now it's 25" left, how much coal did I use this winter.

Geez, that's easy - You used enough to keep warm with

Post by **franco b** » Tue. Mar. 26, 2013 11:30 pm

With tank charts so common why bother to calculate. Just Google it.

SMITTY · Post by **SMITTY** » Wed. Mar. 27, 2013 10:44 am

Here ya go:

http://univoil.com/chart.php

michaelanthony · Post by **michaelanthony** » Wed. Mar. 27, 2013 10:59 am

SMITTY wrote:Here ya go:

http://univoil.com/chart.php

Hey SMITTY, love the saying atop the chart, "today's low price is 3.46/gallon

SMITTY · Post by **SMITTY** » Wed. Mar. 27, 2013 3:12 pm

I know, right?

"Low" is a relative term these days ...

rberq · Post by **rberq** » Wed. Mar. 27, 2013 6:31 pm

NoSmoke wrote:... what I do is just calculate each day how many gallons have been consumed by the equipment on this farm. By deducting how much fuel is used, I automatically know how much fuel is in the tank...and what I am really after...what the value of that off-road fuel is. This is for taxes ...

For taxes, it's traditional to just lie.

titleist1 · Post by **titleist1** » Wed. Mar. 27, 2013 7:11 pm

rberq wrote:
NoSmoke wrote:... what I do is just calculate each day how many gallons have been consumed by the equipment on this farm. By deducting how much fuel is used, I automatically know how much fuel is in the tank...and what I am really after...what the value of that off-road fuel is. This is for taxes ...
For taxes, it's traditional to just lie.

But don't you have to be a cabinet level appointee or former Governor or sitting Senator or re-elected Representative to get away with it.....

dll · Post by **dll** » Thu. Mar. 28, 2013 1:06 pm

You will find that the attached spreadsheet, with a 10th order polynomial equation, will calculate your gallons very close to your data.

The spreadsheet has three tabs, the first has the derived equation function, the second has the equation fit information and the third has the original data.

I would not use this polynomial equation for any other tank, it is derived as a custom equation for the data on the subject tank only.

dll - mathematics fat-head

Any Mathematics Fat-Heads Out There?

Attachments

Attachments