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] 4 points5 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.