TMC is an independent, primarily volunteer organization that relies on ad revenue to cover its operating costs. Please consider whitelisting TMC on your ad blocker or making a Paypal contribution here: paypal.me/SupportTMC

Spreadsheet for line updates (US & Canada)

Discussion in 'Model 3' started by rnelsonee, Mar 30, 2016.

  1. rnelsonee

    rnelsonee Member

    Joined:
    Feb 20, 2016
    Messages:
    95
    Location:
    Maryland
    • Like x 12
    • Helpful x 3
    • Informative x 2
    • Love x 1
  2. Microfrost

    Microfrost Member

    Joined:
    Feb 18, 2016
    Messages:
    37
    Location:
    Chandler, AZ
    Awesome! May I suggest freezing the top row of Summary, and if possible, having that sheet first?
     
    • Like x 1
  3. rnelsonee

    rnelsonee Member

    Joined:
    Feb 20, 2016
    Messages:
    95
    Location:
    Maryland
    Oh yeah, thank you very much for the suggestion! I'm used to Excel so I am very open to suggestions and tricks (thankfully, most Excel functions carry over). I moved the tab over (I didn't know if it would show the last tab I was on, or the first - looks like the first) and froze the top row.
     
  4. Microfrost

    Microfrost Member

    Joined:
    Feb 18, 2016
    Messages:
    37
    Location:
    Chandler, AZ
    I, too, have significantly more experience with Excel than Sheets, but you really did an excellent job on this.
     
    • Like x 1
  5. farzyness

    farzyness Food lover. Entrepreneur. Did I say food lover?

    Joined:
    Aug 8, 2013
    Messages:
    407
    Location:
    Lehigh Valley PA
    Thanks for putting this together?

    Can you perhaps put a total on the People in line (last update) and the max?
     
  6. SMSMD

    SMSMD Member

    Joined:
    Dec 2, 2015
    Messages:
    854
    Location:
    Edmonton, Alberta, Canada
    Great Idea..Nice to see Canada leading..will be short lived for sure...Goes to show we need more Super Chargers and more Service centers.
     
  7. Seagrave7

    Seagrave7 Member

    Joined:
    Mar 5, 2016
    Messages:
    17
    Location:
    Los Angeles, CA
    How are they 11 people in line at California - Canoga Park-Topanga? It's an indoor mall that does not open until 6am?
     
  8. ELRev

    ELRev Member

    Joined:
    Mar 7, 2016
    Messages:
    145
    Location:
    Los Angeles, CA
    There are 15 of us in Burbank, CA. I'm 5th. Channel 4 (NBC) news just swung by for a couple shots and an interview with the first guy in line. Should be on LA news in 8 minutes or so.
     
  9. Tam

    Tam Active Member

    Joined:
    Nov 25, 2012
    Messages:
    1,048
    Location:
    Visalia, CA
    Thanks rnelsonee for the very timely Model ≡ Waiting Line Counter Form!
     
  10. Tam

    Tam Active Member

    Joined:
    Nov 25, 2012
    Messages:
    1,048
    Location:
    Visalia, CA
  11. ken830

    ken830 Model S (Res#P12,447)

    Joined:
    Jun 19, 2012
    Messages:
    858
    Location:
    San Carlos, CA
    I said the same thing on reddIt, but shouldn't the date and times be local time? Or PDT (Tesla's time zone). Heck, even GMT would be better. EDT and no indication of time zone is super confusing.
     
  12. ucla107

    ucla107 Member

    Joined:
    Mar 10, 2016
    Messages:
    17
    Location:
    Los Angeles, CA
    Surprised that many of the SoCal locations don't have more people...
     
  13. Tam

    Tam Active Member

    Joined:
    Nov 25, 2012
    Messages:
    1,048
    Location:
    Visalia, CA
    I would prefer local time zone.

    For example, Munich, Germany is bright day light, almost 10AM right now and it's been open for reservation for an hour, so it makes sense if the time would indicate that it's not night time as we are right now in the US.
     
  14. rnelsonee

    rnelsonee Member

    Joined:
    Feb 20, 2016
    Messages:
    95
    Location:
    Maryland
    Sorry! My first draft asked for local time (and date), and then I realized Google provides a timestamp already, so I used that. I didn't know how timezones were handled, and assumed Google showed each user local time based on their browser/location. I guessed wrong, so I just updated the headings at least. It might be too late to add the time back in as it would mix EDT and local.
     
  15. ken830

    ken830 Model S (Res#P12,447)

    Joined:
    Jun 19, 2012
    Messages:
    858
    Location:
    San Carlos, CA
    Thanks for the PDT column!
     
  16. b0r3dguy

    b0r3dguy Member

    Joined:
    Mar 29, 2016
    Messages:
    14
    Location:
    Anaheim, CA
    I'm surprised, too! Maybe many people are just not updating the Google Sheets....I will be at the Santa Monica store in the morning after I get off work at 6:30am PDT. :)
     
    • Like x 1
  17. Mad Hungarian

    Mad Hungarian Member

    Joined:
    Sep 25, 2015
    Messages:
    272
    Location:
    Montreal, QC, Canada
    rnelsonee, thanks so much for this new doc!
    I just updated for Montreal, we're at 85 now and climbing fast.
    Considering it's raining, windy and 7C/43F I think we're doing pretty damn good
     
  18. inottawa

    inottawa Member

    Joined:
    Oct 2, 2012
    Messages:
    240
    Location:
    Ottawa, ON, Canada
    I know of a number of people driving over from Ottawa this morning. That number should jump quickly through out the morning I imagine
     
  19. MiamiNole

    MiamiNole Member

    Joined:
    Aug 19, 2015
    Messages:
    298
    Location:
    Orlando, FL
    Heading to the Orlando location now. Definitely will give an update.
     
    • Like x 1
  20. minsup23

    minsup23 Member

    Joined:
    Feb 22, 2016
    Messages:
    5
    Location:
    Chicago, IL
    There are 75 people at Oakbrook?
     

Share This Page