Spreadsheet for line updates (US & Canada)

[rnelsonee]

Hello,

Since Tam's spreadsheet was so useful, if there's any interest, I set one up where you can enter in how many people are in your local line. This may help people decide when (or if!) to leave to head out to their local Tesla store.

The Google Form to fill out is here and you can view the results with this Google Sheet.

 

[Microfrost]

Awesome! May I suggest freezing the top row of Summary, and if possible, having that sheet first?

 

[rnelsonee]

Awesome! May I suggest freezing the top row of Summary, and if possible, having that sheet first?

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.

 

[Microfrost]

I, too, have significantly more experience with Excel than Sheets, but you really did an excellent job on this.

 

[farzyness]

Thanks for putting this together?

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

 

[SMSMD]

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.

 

[Seagrave7]

How are they 11 people in line at California - Canoga Park-Topanga? It's an indoor mall that does not open until 6am?

 

[ELRev]

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.

 

[Tam]

...if there's any interest...

Thanks rnelsonee for the very timely Model ≡ Waiting Line Counter Form!

 

[Tam]

...The Google Form to fill out is here...

One small request please.

On the spreadsheet, please place a link to take back to the Google Form.

Thanks.

 

[ken830]

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.

 

[ucla107]

Surprised that many of the SoCal locations don't have more people...

 

[Tam]

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.

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.

 

[rnelsonee]

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.

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.

 

[ken830]

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.

Thanks for the PDT column!

 

[J3diMast3r]

Surprised that many of the SoCal locations don't have more people...

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.

 

[Mad Hungarian]

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

 

[inottawa]

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

I know of a number of people driving over from Ottawa this morning. That number should jump quickly through out the morning I imagine

 

[MiamiNole]

Heading to the Orlando location now. Definitely will give an update.

 

[minsup23]

There are 75 people at Oakbrook?