The Ski & Snowboard Season-Pass Value & Days Log is a ski season pass tracker and ski day log in one spreadsheet, for skiers and snowboarders. Log each day once — one row per rider per day — and it tells you the day each pass paid for itself, what a day on the mountain really cost, and which pass to buy next season, priced at the days you actually rode. It holds up to 6 riders, 6 passes, 20 resorts and 400 rider-days a season.
Plenty of ski households have the same autumn conversation. The pass sale is ending, somebody asks whether last year’s pass was worth it, and nobody can say, because the answer is spread across a pass receipt, a ride-tracking app, a stack of gas and lodging charges, and memory. This file puts those pieces in one place.
Not sure yet? Try the free ski pass break-even checker — one rider, one pass, one season log that finds the day your pass paid for itself — then come back here for every rider, the all-in cost of each day and next winter’s pass priced at the days you rode.
When did my season pass pay for itself?
A pass day is worth what that day would have cost at the ticket window — at the resort you actually rode, at the adult or youth rate, with the resort’s peak-day surcharge on the days you mark as peak days. The Pass Value tab adds those up day by day for every rider and shows:
- the walk-up value of the days your pass covered, against the price you paid
- the break-even date — the day the running total crossed the price of the pass
- the pass days still needed, for a rider who isn’t there yet
- a progress bar and a plain verdict: Paid off, or Paying off
Days at a resort a rider’s pass does not cover are ticket days. They cost money, but they don’t count toward that pass — and because a resort can sit on several passes, the Resorts tab carries a Yes/No grid of which of your passes covers which mountain.
What does a ski day really cost?
The lift is only part of it. The True Cost tab totals 8 cost categories — pass, lift tickets, driving, lodging and parking, rentals, lessons, food and gear upkeep — per rider and for the household, and turns them into an all-in cost per day you can set against the walk-up window rate.
Shared costs are typed once. Mark “Drove here?” Yes on one row per car and the drive is split across everyone who rode that resort that day; lodging and parking are entered once and shared the same way.
Which pass should we buy next season?
The Next Season tab is where the log pays off. Enter up to five pass options with their adult and youth prices and which resorts each covers, and it prices every rider on every pass at this season’s actual days and resort mix — or at an expected-days percentage if you plan to ride more or less.
Then it ranks five household plans: this season’s setup, pinned as the baseline; a best mix it finds automatically, cheapest pass per rider; and three of your own. Riders don’t have to match — “adults on one pass, kids on another” is a plan like any other. Prices are per rider; family and bundle discounts aren’t modeled, so check those against the real offer.
What else is in it?
- Trip Planner — cost a trip before you book it, including tickets for anyone whose pass doesn’t cover that resort, and see whether it raises or lowers your season’s cost per day.
- Household — every rider side by side: days, runs, vertical, powder days, black-diamond days, verdict and break-even date, plus days on snow month by month.
- Gear — name the skis or board on each Day Log row, and it counts days on snow per item and flags wax and edge tunes due from your service log.
- History — pass cost per day and all-in cost per day, season over season.
- Dashboard — the whole season on one screen.
Own it, don’t rent it
Ride-tracking apps count your runs and vertical; resort apps sell you the next pass. Neither keeps the money. This is a spreadsheet you buy once. It opens in Excel, Google Sheets or LibreOffice, it keeps a season-over-season History of up to 8 seasons, and nothing about where your family skis leaves your own computer or your own Drive. You type the days yourself — it doesn’t connect to any resort or app, so there is nothing upstream that can switch it off.
What’s in the download
A 12-tab workbook, a ready-made Google Sheets copy, a 15-page Start Here guide, a 7-page worked example of the season-pass math, and 7 printable pages — a day log for the car, a trip cost worksheet, a gear service log and a pass break-even tally. It arrives pre-loaded with a fictional household — 4 fictional riders, 8 fictional resorts, 56 logged rider-days — so every tab makes sense the moment you open it.
