Home› The Porch

Touring Fans - 2020 North American PJ Tour - Ticket Tracking

bucklyshrankbucklyshrank 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
«1345

Comments

  • NewfieintheUSANewfieintheUSA Posts: 2,416
    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!
  • madkins7madkins7 Posts: 29
    wasnt there a website that did this a few tours back?
  • bucklyshrankbucklyshrank Posts: 32
    madkins7 said:
    wasnt there a website that did this a few tours back?
    yeah, actually @KatrinaRocks and I built that one too ;D

  • tschavtschav Posts: 2,836
    Nice! thanks for setting this up. Hopefully I'll have positive things to add to the spreadsheet later this weekend.
  • gotthebottlegotthebottle Posts: 2,642
    bump
  • jets521jets521 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
  • ledbetterman4pearljamledbetterman4pearljam Posts: 122
    Thanks.  I submitted mine.

  • MD190661MD190661 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




  • gotthebottlegotthebottle Posts: 2,642
    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
  • halshakarchihalshakarchi Posts: 176
    Yo... don’t put your full member number into a publicly viewable spreadsheet. Just saying...
  • gotthebottlegotthebottle Posts: 2,642
    halshakarchi said:
    Yo... don’t put your full member number into a publicly viewable spreadsheet. Just saying...
    yo...everyone is putting first 3 digits with 000
  • halshakarchihalshakarchi Posts: 176
    gotthebottle said:
    halshakarchi said:
    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
  • tusevuntusevun Posts: 231
    halshakarchi said:
    Yo... don’t put your full member number into a publicly viewable spreadsheet. Just saying...
    Why?
  • washed in blackwashed in black Posts: 879
    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

  • dmbolpdmbolp Posts: 1,287
    washed in black said:
    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
  • lawilczewski2lawilczewski2 Posts: 60
    washed in black said:
    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
  • bucklyshrankbucklyshrank Posts: 32
    bump
  • gotthebottlegotthebottle Posts: 2,642
    Hope more people put info in the spread sheet..the more data the better
  • PushinPaintPushinPaint Posts: 433
    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!
  • bucklyshrankbucklyshrank Posts: 32
    PushinPaint said:
    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?
  • amethgr8amethgr8 Posts: 766
    tusevun said:
    halshakarchi said:
    Yo... don’t put your full member number into a publicly viewable spreadsheet. Just saying...
    Why?
    I've always wondered why
    Amy The Great #74594
    New Orleans LA 7/4/95 reschedule 9/17/95
    Chicago IL 1998, 10/9/00, 06/18/03, 05/16/06, 05/17/06
    08/23/09, 08/24/09, Lolla 08/05/07
    Champaign IL 4/23/03
    Grand Rapids MI VFC 10/03/04
    Grand Rapids MI 19May06
    Noblesville IN 05/07/10 Cleveland OH 05/09/10
    PJ 20 2011
    Baltimore MD, Charlottesville VA, Seattle WA 2013
    St. Louis MO, Milwaukee WI 2014
    Tampa FL, Chicago IL, Lexington KY 2016
    Missoula MT 2018
  • PushinPaintPushinPaint Posts: 433
    bucklyshrank said:
    PushinPaint said:
    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?
    Ah, i must have missed those! I looked on top of bar. Thanks!
  • PushinPaintPushinPaint Posts: 433
    PushinPaint said:
    bucklyshrank said:
    PushinPaint said:
    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?
    Ah, i must have missed those! I looked on top of bar. Thanks!
    Sorry, i was looking for counts for each bar on top
  • bucklyshrankbucklyshrank Posts: 32
    PushinPaint said:
    PushinPaint said:
    bucklyshrank said:
    PushinPaint said:
    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?
    Ah, i must have missed those! I looked on top of bar. Thanks!
    Sorry, i was looking for counts for each bar on top
    Good call, added data labels. Had to dig a bit :D
  • PushinPaintPushinPaint Posts: 433
    Bump, the more data we get the more understanding we'll have for oddities (i.e. priority 1 BA didn't receive but priority 5 for someone else did). Please add! 
  • gotthebottlegotthebottle Posts: 2,642
    Bump
  • bucklyshrankbucklyshrank Posts: 32
    bump, rebranded this to something better than "Form and Spreadsheet", cause that sounded way too exciting ;)
  • gotthebottlegotthebottle Posts: 2,642
    bump...come on people!! Input your data!!
  • tschavtschav Posts: 2,836
    Updated, hoping more updates to be made. Has this been passed around the FB groups as well?
  • gotthebottlegotthebottle Posts: 2,642
    tschav said:
    Updated, hoping more updates to be made. Has this been passed around the FB groups as well?
    FB? lol...
Sign In or Register to comment.