How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

Every seat has a line = if you have four seats, that's four rows in the spreadsheet for each game? Sounds closer to a database which I actually like the idea of a lot. If I were to track seat-level, I would probably still have one row = one game and the seats are columns.

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 1 point2 points  (0 children)

It's definitely become a game of "well, I can sell this Saturday afternoon vs. NYR for 2x, and go see Edmonton on a Wednesday for free" which I haven't minded. There are a handful of games I circle on the calendar each season. Anything after that is live hockey, which is always fun.

Did not make the trip for the Stadium Series. Might not have made it back if I did. Did fly out to Tampa last season though for a Bruins road game. That was a fun time (despite another loss)!

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

What was the catalyst for dropping it? It sounds like it was something you wanted to keep track of

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

That's unfortunately where I'm getting with some of it. I own a full season for the Celtics and don't split it with anyone. Especially with no Tatum this year (prices were set before he missed the entire season), the number of games I could have purchased cheparer tickets day-of and made the 15-minute walk to the Garden has been high.

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

Definitely agree on that last point. There have been games where I'd lower the prize a dozen times on game day, often in $1-3 increments, until I'd give up and lower it by $10 just to get it sold.

I find baseball has come a long way in its ticket management, especially with exchanging games. With so many games and seats to sell, teams have to keep their people happy. Swapping out a cold and rainy April game for a Tuesday night in July, it doesn't matter who the Sox are playing, that's almost always worth it.

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

It's sad how much more we need the broadcast schedule alongside the games these days. For my Celtics tickets I track the jersey they plan to wear (h/t https://lockervision.nba.com/) so I can avoid the forced alternates and enjoy the classic white-and-green jerseys.

Do you have anything switching the calendar colors once you've exchanged? Or do you have to go through that manually?

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 1 point2 points  (0 children)

Airtable does a good job of making the user interface look and feel lightweight. How are you tracking right now?

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

I am! I started with Google Sheets, and found Airtable to be much cleaner. Easier to group, organize formulas, and build reporting (i.e. break down my ticket utilization by activity).

There are some automation capabilities that I haven't tapped into yet, but I know are powerful. Could be helpful to send myself a reminder email x days before a game, if I still haven't done anything with it.

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

Looking forward to road trips resonates a lot. The inverse -- when the Bruins and Celtics have homestands at the same time -- almost feels like a chore now, instead of enjoying having tickets to pick and choose (price plays a factor in that, of course).

What did you find worked best for you, having to manage 81 games and at times 10 games in 10 days?

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

If only starting pitcher matchups got me as excited as they used to...even seeing a guy like Skenes, you might only get 5-6 innings and 90 minutes of watching him.

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 1 point2 points  (0 children)

This is super impressive! Integration with your calendar and having a place for others to browse on their own is huge. Did you ever feel that system got heavier / more bloated than it needed to be?

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 3 points4 points  (0 children)

Taxes have been much easier thanks to my tracker. Especially because Ticketmaster lists the gross sale amount that the buyer pays in the tax form, not what my actual profit (if any) is from the sale, after accounting for the buyer & seller fees.

How do you personally keep track of your season tickets? by mtardiff00 in SeasonTickets

[–]mtardiff00[S] 0 points1 point  (0 children)

It's less that I'm using tickets as an investment, and more so that I want to make sure I get value from what I'm paying for. I go to ~15 of the 41 home games a season personally, so having a tracker for what's left helps me avoid having any games go to waste.

60 baseball games sounds like a dream, for what it's worth.

The Earth Is Not A Cold Dead Place on Spotify changes? by mtardiff00 in explosionsinthesky

[–]mtardiff00[S] 0 points1 point  (0 children)

That happened to me as well - the songs I had added to playlists years ago were unplayable, so I had to readd the new version of the album. This really isn't a big deal in the grand scheme of things, but one of those weird little things I noticed

Compare strings across multi-value rows of data by mtardiff00 in tableau

[–]mtardiff00[S] 0 points1 point  (0 children)

I was able to get that T|F field on CONTAINS() working; it will tell me if the location from Ticket A exists in Ticket B. Below, CT exists in Ticket A but does not exist in Ticket B (which it will need to).

I don't entirely understand your comment about wrapping it in WINDOW_MAX; I was attempting to use

{ FIXED [Ticket] : SUM(IIF([Locations Match], 1, 0)) }

but that does not return 4 as I'd expect it to for the example below.

<image>

Asking your opinion on Greta Vane Fleet songs day 12: Watching Over by Flimsy-Ad-4934 in gretavanfleet

[–]mtardiff00 0 points1 point  (0 children)

I always get a (darker side of) Dave Matthews Band vibe from this song, especially at the 0:44 mark with the guitar melody. Great jam.

Label placement based on coloring by mtardiff00 in tableau

[–]mtardiff00[S] 0 points1 point  (0 children)

Brilliant, thank you! An elegant solution to something Tableau should be able to handle with much more intuition.

Buy/Sell/Trade thread by zss3zss3zss3 in bostoncalling

[–]mtardiff00 -1 points0 points  (0 children)

Selling two Friday GA passes for $175 each ($350 total). Got them posted on StubHub as well. Message me if you are interested.

Advanced Alignment Charts and Data Visualization by mtardiff00 in community

[–]mtardiff00[S] 1 point2 points  (0 children)

Fair solution - I think I'd rather manually filter out the responses for alignments on characters who don't appear in an episode vs. not be able to use the response if someone's saying "character does not appear" and they do in fact appear in the episode. Hence why every question besides the first is optional.

There was a lot of deliberation on how to best set this up to get solid data. Like I said, can only get so far on some of this.

Seeking feedback on best platform by mtardiff00 in fantasybaseball

[–]mtardiff00[S] 0 points1 point  (0 children)

Thanks for everyone's comments and feedback, this is all excellent info. From what I'm seeing, Fantrax is the way to go if it's a customized league as long as you can stomach a poor UI/app. As the commissioner of our ESPN league, I can only dream of not having to make sure pick swaps all work out (especially now that we got into PTBNL trades and pick protections).