Your Accounts
Step 1 of 2
Five columns is all it takes: account, ZIP, tank size, gallons that account bought in the last 12 months, and the date of its last delivery.
That last-delivery date is what tells me how full the tank is today — without it there's no
way to know what's in the tank right now, so a row with no date gets skipped rather than
guessed. (A current fill % works in its place if you run tank monitors.)
One report out of your delivery system — no pivot tables, no pairing up deliveries. Paste
straight from Excel or as a comma list. Dates in any normal format (6/15/2026 is fine).
More columns, if you have them
With a header row the columns can be in any order. Recognized headers:
account, zip, tank size, annual gallons, last delivery, fill %, generator
— plus previous delivery and gallons if you'd rather
calibrate from two deliveries than a year of usage. A live fill % makes it
sharper. Mark generator or backup-power accounts with a y and they get
flagged earlier.
No header row? Use this order: account, zip, tank size, annual gallons, last delivery, fill %, generator y/n. Example:
No header row? Use this order: account, zip, tank size, annual gallons, last delivery, fill %, generator y/n. Example:
Coastal Motel, 04103, 1000, 1180, 6/5/2026, , y
Your account list never leaves this page. It's processed right here in your
browser — nothing is uploaded, nothing is stored, and I never see it. If you ask me for the
report at the end, only the totals come to me, never your customers.
Leave blank and I'll use $165.
The extra cost a runout produces. Blank uses $110.
On auto-delivery you absorb the whole cost — you can't bill a customer for a miss that was yours.
Cold snaps don't wait for Monday. Blank uses 35%.
EIA puts whole-home heat at roughly 450–710 by region.
Industry survey average is $1.42. Use your own.
Advanced — tune the cost assumptions to your real numbers
Default 1.3 — set from your own history if you know it.
Default 3× — generator runouts cost more.
Flag standard accounts within this many days of reserve.
Flag backup accounts earlier — default 21.
Nobody publishes this number. 12% is my assumption — change it to whatever your experience says.
How many years of margin walk out with them. Default 6.
Default 20%. Set 30 if that's your rule.
Water heater, range, dryer — burns year-round regardless of weather. Default 0.8. Set 0 for a heat-only book.
Leave blank for automatic: each account's own delivery history decides. A drop that matches what the tank had room for keeps a tight 5-point band; one that ran clearly short gets the full 40-point band and a CHECK FILL flag. A number here overrides that for every account — 0 if every drop on your book fills to the stop.
Used by the cold-snap check only when a row has no connected load (BTU/hr) column — a real nameplate figure always wins. Default 3: the furnace pulls about three times the day's average burn while it's actually firing. No published source for this one; set it to what your book shows.
Leave blank for today. Set a past date and it predicts from there, so you can check the flags against what actually happened. Uses historical weather only — no forecast existed then.
The leak-and-light is a separate service call — the exception, not the rule. Default 40%. Set it to how often it actually happens on your book.
Can't get this out of your delivery system? Don't fight with it. Email your
export — or even a screenshot of a few accounts — to
info@greenelightservices.com
and I'll run it myself and send the list back. Free, no strings. — Jacob, propane service tech
Your Ranked Report
Step 2 of 2
Paste your accounts above (or load sample data to see how it works), then run the report.