Any Mathematics fat-heads out there?

Any Mathematics fat-heads out there?

PostBy: OldAA130 On: 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
OldAA130
 
Stove/Furnace Make: Axeman Anderson
Stove/Furnace Model: 130

Re: Any Mathematics fat-heads out there?

PostBy: Dennis On: 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
Attachments
IMG.jpg
(299.39 KiB) Viewed 73 times
View: New PagePopup • Select:BBCode
[nepathumb]41326[/nepathumb]
Last edited by Dennis on Wed Mar 27, 2013 11:06 am, edited 2 times in total.
Dennis
 
Hand Fed Coal Boiler: AHS/WOC55-multi-fuel/wood,oil,coal
Coal Size/Type: Anthracite/stove size

Re: Any Mathematics fat-heads out there?

PostBy: michaelanthony On: Tue Mar 26, 2013 7:49 pm

blocklayer.com is an excellent site for this and countless other formulas!
michaelanthony
 
Hand Fed Coal Stove: Vigilant 2310, gold marc box, vogelzang pot belly coat rack
Coal Size/Type: Pea, and a little nut
Other Heating: Very cold FHA oil furnace


Re: Any Mathematics fat-heads out there?

PostBy: coalnewbie On: 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.
coalnewbie
 
Hot Air Coal Stoker Stove: LL AnthraKing 180K, Pocono110K,KStokr 90K, DVC
Hand Fed Coal Stove: Hitzer 50-93,
Baseburners & Antiques: Invader 2 Wings Best, Glenwood #8 + Herald 116x
Coal Size/Type: Rice, Chestnut
Other Heating: Heating Oil CH, Toyotomi OM 22

Re: Any Mathematics fat-heads out there?

PostBy: NoSmoke On: 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!
NoSmoke
 
Hand Fed Coal Boiler: New Yoker WC90
Hand Fed Coal Stove: Vogelzang Pot Bellied Stove
Coal Size/Type: Stove/Nut/Pea Anthracite
Other Heating: Munchkin LP Boiler (Back-up)

Re: Any Mathematics fat-heads out there?

PostBy: KLook On: 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
KLook
 
Stoker Coal Boiler: Harman VF 3000
Coal Size/Type: rice, bagged, Blaschak
Stove/Furnace Make: Harman (Back In Maine)
Stove/Furnace Model: VF 3000

Re: Any Mathematics fat-heads out there?

PostBy: lsayre On: Tue Mar 26, 2013 9:56 pm

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

Select for "Vertical Oval" and have at it. For geeks (like me), the formulas are presented on the website as well.
lsayre
 
Stoker Coal Boiler: AHS S130 Coal Gun
Coal Size/Type: Stockton Anthracite Pea
Other Heating: Resistance Boiler (13 KW)

Re: Any Mathematics fat-heads out there?

PostBy: Lightning On: 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 :lol:
Lightning
 
Hand Fed Coal Furnace: Clayton 1537G
Coal Size/Type: Nut/Stove Size Mix

Re: Any Mathematics fat-heads out there?

PostBy: franco b On: Tue Mar 26, 2013 11:30 pm

With tank charts so common why bother to calculate. Just Google it.
franco b
 
Hand Fed Coal Stove: V ermont Castings 2310, Franco Belge 262
Baseburners & Antiques: Glenwood Modern Oak 114
Coal Size/Type: nut and pea

Re: Any Mathematics fat-heads out there?

PostBy: SMITTY On: Wed Mar 27, 2013 10:44 am

SMITTY
 
Stoker Coal Boiler: Patriot Coal - custom built by Jim Dorsey
Hand Fed Coal Stove: Harman Mark III (not currently in use)
Coal Size/Type: Rice / Blaschak anthracite
Other Heating: Oil fired Burnham boiler

Re: Any Mathematics fat-heads out there?

PostBy: michaelanthony On: 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 :lol: :lol: :lol: 8-)
michaelanthony
 
Hand Fed Coal Stove: Vigilant 2310, gold marc box, vogelzang pot belly coat rack
Coal Size/Type: Pea, and a little nut
Other Heating: Very cold FHA oil furnace

Re: Any Mathematics fat-heads out there?

PostBy: SMITTY On: Wed Mar 27, 2013 3:12 pm

I know, right? :lol: "Low" is a relative term these days ... :shock:
SMITTY
 
Stoker Coal Boiler: Patriot Coal - custom built by Jim Dorsey
Hand Fed Coal Stove: Harman Mark III (not currently in use)
Coal Size/Type: Rice / Blaschak anthracite
Other Heating: Oil fired Burnham boiler

Re: Any Mathematics fat-heads out there?

PostBy: rberq On: 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. :|
rberq
 
Hand Fed Coal Stove: DS Machine 1300
Coal Size/Type: Nut -- Kimmel/Blaschak/Reading
Other Heating: Oil hot water radiators, propane

Re: Any Mathematics fat-heads out there?

PostBy: titleist1 On: 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..... :?
titleist1
 
Hot Air Coal Stoker Stove: Harman Mag Stoker (old style) one in basement, one in workshop
Hand Fed Coal Stove: Harman Mark III on standby for long power outages
Coal Size/Type: Rice/Anthracite; Nut/Anthracite

Re: Any Mathematics fat-heads out there?

PostBy: dll On: 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 :)
Attachments
275VertTank.xls
(22.5 KiB) Downloaded 4 times
Select:BBcode: [nepafile=41361]275VertTank.xls[/nepafile]
dll
 
Hand Fed Coal Stove: Harman MKII, Salvo Citation wood/coal
Coal Size/Type: Nut/anthracite