Touring Fans - 2020 North American PJ Tour - Ticket Tracking

bucklyshrank
bucklyshrank Posts: 32
edited January 2020 in The Porch
Hello! Long time member, first time poster... I whipped up a quick Google Form for folks to capture and share their entries.

Entry form: https://forms.gle/pXN3tkgecSCQ2zur8
Spreadsheet of entries: https://docs.google.com/spreadsheets/d/1DMmdBuE5m6lJ3RDUII7YUxsYooa3JDSJ50a8siceWzo/edit?usp=sharing

Couple of points:
- You'll have to submit an entry for each show you have entered for.
- Once you have submitted an entry, it will be emailed to you so you can revise it later.
- Also, after you have submitted an entry, it will provide you with a link to submit another one
- The form asks for your member number. This is a required numerical field, so if you are not comfortable providing your actual number, as it seems the case usually, please enter with the last three digits as "000". For example, if your number is 123456, enter as 123000. Once there are a lot of entries, it will become beneficial to sort by this number.
- The spreadsheet is intended for full transparency of the data, except for email address, for your privacy. The email address is necessary to send the entry to you so that you can later revise it.

Thanks, let me know if this is useful, and if you have any suggestions for improvement!
Post edited by bucklyshrank on
«134567

Comments

  • I submitted mine and my wife's entries. This will be good to look at if enough people add and update their entries.

    Thanks for this!
  • wasnt there a website that did this a few tours back?
  • madkins7 said:
    wasnt there a website that did this a few tours back?
    yeah, actually @KatrinaRocks and I built that one too ;D

  • tschav
    tschav Posts: 2,900
    Nice! thanks for setting this up. Hopefully I'll have positive things to add to the spreadsheet later this weekend.
  • gotthebottle
    gotthebottle San Diego Posts: 3,823
    bump
  • jets521
    jets521 Posts: 804
    Cool i love stuff like this. thanks!
    Wachovia Center, Philadelphia - 10/3/05
    Tweeter Center, Camden - 5/27/06
    Verizon Center, Wash. DC - 5/30/06
    Bonnaroo, Manchester, TN - 6/14/08
    Madison Square Garden, NYC - 6/19/08
    Spectrum, Philadelphia - 10/28/09
    Spectrum, Philadelphia - 10/30/09
    Spectrum, Philadelphia - 10/31/09
    Madison Square Garden, NYC - 5/21/10
    Wells Fargo Center, Philadelphia - 10/21/13
    1st Mariner Arena, Baltimore - 10/27/13
    Wells Fargo Center, Philadelphia - 4/28/16
    Enterprise Center, Saint Louis - 9/18/22
  • Thanks.  I submitted mine.

  • MD190661
    MD190661 Posts: 394
    Is this to have an easy way to see what everyone got from the lottery? 
    10/1/94, 6/22/95, 6/24/95, 9/16/96, 7/22/98, 10/21/01, 6/1/03, 10/25/03, 10/26/03, 9/1/05, 7/15/06, 7/18/06, 8/28/09, 10/07/09, 10/3/12, 11/26/13, 6/18/18, 8/10/18, 5/12/22, 5/13/22, 5/13/24, 5/25/24




  • gotthebottle
    gotthebottle San Diego Posts: 3,823
    MD190661 said:
    Is this to have an easy way to see what everyone got from the lottery? 
    only can see whomever wants to put their info in...it's just for fun
  • Yo... don’t put your full member number into a publicly viewable spreadsheet. Just saying...
  • gotthebottle
    gotthebottle San Diego Posts: 3,823
    Yo... don’t put your full member number into a publicly viewable spreadsheet. Just saying...
    yo...everyone is putting first 3 digits with 000
  • Yo... don’t put your full member number into a publicly viewable spreadsheet. Just saying...
    yo...everyone is putting first 3 digits with 000
    I saw one that was more than just three digits with zeroes
  • tusevun
    tusevun Posts: 252
    Yo... don’t put your full member number into a publicly viewable spreadsheet. Just saying...
    Why?
  • Saw an entry with a 919xxx number. Is that real? I thought the highest member number was somewhere in the 700k range?

    BTW - Thanks for doing this. I miss the touringfans site!
    2003 Spectrum, Camden 2, Holmdel 2004 Reading, PA 2005 Philly 2006 Hartford, Camden 1&2, E. Rutherford 1&2 2008 Camden 1&2, MSG 1&2  2009 Spectrum 1,2,3,4  2010 Hartford, Newark, MSG 1&2 2013 Wrigley, Pittsburgh, Brooklyn 1&2, Philly 1&2,  Baltimore 2014 Leeds, Cincinnati  2015 GCF  2016 Sunrise, Miami, Hampton, Philly 1&2, MSG 1&2, Fenway 1&2  2017 RHoF Induction 2018 Seattle 1&2 Fenway 1&2 2021 Sea Hear Now 2022 Hamilton, Toronto, MSG, Camden 2023 Indy 2024 Indy, MSG 1&2, Philly 1&2, Baltimore

  • dmbolp
    dmbolp ATL Posts: 1,513
    Saw an entry with a 919xxx number. Is that real? I thought the highest member number was somewhere in the 700k range?

    BTW - Thanks for doing this. I miss the touringfans site!
    Was prob their TM presale number
  • Saw an entry with a 919xxx number. Is that real? I thought the highest member number was somewhere in the 700k range?

    BTW - Thanks for doing this. I miss the touringfans site!
    I just joined last week and my number is 879xxx
  • bump
  • gotthebottle
    gotthebottle San Diego Posts: 3,823
    Hope more people put info in the spread sheet..the more data the better
  • Just put mine in. Hope everyone does this, as will be helpful post audit.

    Can we get some labels on the bars for won/loss/don't know, etc on the charts tab? 

    Thanks for doing this!
  • Just put mine in. Hope everyone does this, as will be helpful post audit.

    Can we get some labels on the bars for won/loss/don't know, etc on the charts tab? 

    Thanks for doing this!
    Hey @PushinPaint , there are labels below the bars for the "Win/Loss Data" chart. Did you mean something else?