Built around the jobs ski families actually do
Price every pass option for your family
Type each option's real prices by age band: Epic, Ikon, Indy, a single-mountain pass, a day pack or plain tickets. Add day caps, extra-day discounts and blackout dates. The sheet prices the season for your family, ranks the options and names the cheapest one for each skier.
Pass prices, capsCheapest optionSee what a blacked-out pass really costs
List each pass's blackout dates. Planned trips that fall inside them are priced as ticket days, so a cheaper limited pass shows its true cost. Use a pass on one of its blackout days in the log and the sheet flags who.
Blackout rangesTicket days addedLog a family ski day in one row
Date, mountain and a code for each person: P for pass, T for ticket, F for free. Snow, vertical, a rating and lodge spending are there if you want them.
Mountain, P / T / FDays per skierKnow whose pass has paid off, and when
Each pass day is valued at the ticket that skier would have bought at that mountain. Everyone gets pass value, net savings, days still to go and the date the pass paid for itself.
Your ski daysBreak-even dateFind out what a ski day really costs
Lift cost per day and all-in cost per day for each person, with lodging, gas, food, gear and tunes counted. Day trips get a gas estimate from your round-trip miles and MPG.
Trips, gas, gearAll-in $ per dayKeep up with growing kids and full gear bags
Log gear bought new, at a swap, leased or handed down, and what it sold for. A growth log tracks height and foot size, the Tune Log shows who is due for wax, and the packing list shows who still needs to pack what.
Gear, sizes, packingCost per day used14 tabs in one file
- Start Here
- Dashboard
- Pass Compare
- Ski Days
- Skiers
- Mountains
- Trips
- Blackout Dates
- Gear & Swap
- Sizes
- Tune Log
- Packing List
- Season Report
- Settings
- Start Here
- Setup steps, the color key and a map of every tab.
- Dashboard
- Passes paid off, cost per ski day, season spend, goals, gear care and your next trip.
- Pass Compare
- Any pass, pack or tickets at your prices, caps and blackouts, ranked for your family.
- Ski Days
- One row per ski day with a P, T or F code for each skier.
- Skiers
- Up to 6 people: pass value, break-even date, cost per day, sizes and gear care.
- Mountains
- Ticket prices by age band, round-trip miles, days skied and a bucket list.
- Trips
- Lodging, gas, food and lessons for each trip, with cost per skier-day.
- Blackout Dates
- Blackout ranges for each pass, checked against your planned trips.
- Gear & Swap
- Gear bought new, at a swap, leased, handed down or sold, with net cost per day.
- Sizes
- A growth log for the kids with ski length and boot size guides.
- Tune Log
- Waxes, edge tunes and boot work, with ski days since each one.
- Packing List
- A packing grid with a column for each skier and one for the family bag.
- Season Report
- Days per skier, vertical and the pass and ticket mix, month by month.
- Settings
- Season dates, ticket prices, gas, tune intervals, goals and every dropdown.
Try the free Ski Pass Break-Even Calculator
How many days each skier needs for a season pass to beat lift tickets, and what the family saves.
Pair it with
“Well thought out worksheets nicely presented”
“Excellent! Very easy to use.”
Before you buy
Does it come with this season's pass prices?
No, on purpose. Pass and ticket prices change every season, and sometimes every few weeks. You type the prices you are actually offered, so the comparison fits your family and your year, and it keeps working next season.
We ski at a small local hill, not on Epic or Ikon. Will it work?
Yes. A single-mountain pass, a punch card, a multi-day pack or plain day tickets all work the same way. Add each one as an option on Pass Compare with your own prices.
How are blackout dates counted?
Enter each pass's blackout ranges on the Blackout Dates tab. Planned trip days inside a range are priced as ticket days on Pass Compare, and a pass day logged on a blackout date is flagged on Ski Days with the skier's name.
Does it work for one skier, or for snowboarders?
Yes to both. One person works fine and the extra skier columns stay out of the way. Snowboarders log their days the same way.
Is there a free way to check one pass first?
Yes. The free Ski Pass Break-Even Calculator on this site works out the break-even day for each person and the family total. The spreadsheet does the same math day by day through the season, across every pass option, with trips, gear and tunes counted.
What do I get?
An Excel file (.xlsx), a filled-in sample to look at, and a quick-start PDF guide with a link that makes your own copy in Google Sheets.
How does delivery work?
You get your download links right after checkout, and Stripe emails your receipt. There is nothing to ship and nothing to wait for.
How do I set it up in Google Sheets?
Open the quick-start PDF and click the Google Sheets link. Google makes a copy in your own Drive that only you can edit. You need a free Google account.
Will it work on a Mac?
Yes. It works in Excel on Mac and Windows, and in Google Sheets in any browser.
I'm not a spreadsheet person. Is that a problem?
No. You only type in the yellow cells. Everything in gray works itself out, and the Start Here tab shows you where to begin.
Can I get a refund?
Templates are digital downloads, so sales are final. If a file won't open, is broken or doesn't match its description, email hello@cleanpixelstudios.com within 30 days and we'll fix it, or refund you if we can't.
What if I get stuck?
Email hello@cleanpixelstudios.com and we'll help you get it working.
More in Home, hobbies & travel
See all Home, hobbies & travel templates
Made by Clean Pixel StudiosWe start every template by reading what people in that line of work say they struggle with, then build the spreadsheet around those problems. This one was made for ski families and nobody else.
How we build templatesSki Season Tracker$14.99 · Excel + Google Sheets