Download the K-Factor Calculator here: K Factor Calculator.xlsx or input values in the calculator below.
|
|
K-Factor Calculator | |||
|
|
Use the tank reading screen to enter yellow highlighted fields | Tank Size | Start % | Total Gals |
| 1&2 | Total tank capacity x starting % | 100 | ||
| 3 | Plus Number of Gallons Delivered |
|
|
|
|
|
Total Gallons with this Delivery |
|
|
400 |
|
| ||||
|
|
|
Last Date | New Date | # Days |
| 4&5 | # of Days between Deliveries | 60 | ||
| 6 | Daily Use |
|
|
|
|
|
Total Daily Use Gallons Used |
|
|
60 |
|
| ||||
|
|
|
|
|
Gallons |
| 7 | Previous Gallons left in tank after last delivery |
|
|
|
|
|
Minus Gallons left in tank this delivery |
|
|
100 |
|
|
Minus Daily Use Gallons Used |
|
|
60 |
|
|
Calculated Gallons |
|
|
239 |
|
| ||||
|
|
|
Old DD | New DD | # of DD's |
| 8&9 | Old Read\New Read | 2195 | ||
|
|
Divide by Calculated Gallons |
|
|
239 |
|
|
New Calculated K-Factor |
|
|
9.18 |
|
| ||||
|
|
Newly Calculated K-Factor |
|
|
9.18 |
| 10 | Previous K-Factor |
|
|
|
| 11 | Previous K-Factor |
|
|
|
|
|
Total Last 3 K-Factor |
|
|
29.74 |
|
|
Divide by 3 - Averaged K-Factor |
|
|
9.91 |
|
| ||||
|
|
|
Previous | % | Value |
| 12 | Percent to Change X Previous K-Factor |
|
1.95 | |
|
|
Previous K-Factor + Percent to Change Value | 9.74 | 1.95 | 11.69 |
|
|
Is Calculated K-Factor less than Percent to Change? |
|
|
TRUE |
|
|
If True, the Averaged K-Factor becomes the Current K-Factor | |||
|
|
If False, the previous k-factor and % to change becomes the Current K-Factor | |||