Get a sneak peek at whats next for Permanent Hazards on our April 7th Office Hours!

Post Reply

Annual MTE Schedule Spreadsheet

Post by Kkervinjones
As part of my MTE (Major Traffic Event) Marshal role, I have started to put together a list of annual events which may need MTEs and closures adding to the map.

Obviously this list could run into the hundreds of events per month, and I would like help in populating the lists where possible.

I'm hoping this list will become the focal point for managing annual events going forward. If you would like access to the list, select the link below and request access with confirmation of your Waze username:
Google Sheet

The Google Sheet is organised into Tabs for each month. Please add any MTE you think may be worth adding on. Please enter the event in the correct month. If you are unsure that the event warrants adding on, please do so anyway and it can be reviewed later as and when it need to be added.

If you add an MTE and closures to the map that's on the list, please update the status of the event as needed.

If you have any suggestion on how this could be improved upon, let me know.
Kkervinjones
Waze Global Champs
Waze Global Champs
Posts: 4056
Answers: 11
Answers: 11
Has thanked: 1113 times
Been thanked: 1650 times

POSTER_ID:16843688

1

Send a message
Keith
UK Country Admin and Global Champ
Area Manager for North West England and the Isle of Man
Google Pixel 5 (Personal)/iPhone 8 (Work) - Carplay/AA - 2021 Toyota Corolla

https://s.waze.tools/gc.pnghttps://s.waze.tools/c6s.pnghttps://s.waze.tools/s0500.pnghttps://s.waze.tools/betc.pnghttps://s.waze.tools/beta.pnghttps://s.waze.tools/tem.png
https://i.imgur.com/nW244c6.png

Post by iangpowell
Is there a way of accessing this without having a Google email address/account, as it's asking me to request access and then required a Google account for this.
iangpowell
Waze Mentor
Waze Mentor
Posts: 1911
Answers: 5
Has thanked: 639 times
Been thanked: 447 times
Send a message

AM for the Thames Valley, Tees Valley / Tyneside, Greater London & Norfolk, UK
Waze UK Mentor

UK Wazeo | Quick Start Editing Guide | Editing Best Practice | Request a Mentor Here | L1 Mentoring Presentation | Join the UK Discord Channel

Post by Kkervinjones
You have to have a Google Account (it is a Google service at the end of the day). You can sign up to Google using a non-google email address - use the 'Use my current email address instead' option when signing up.
Kkervinjones
Waze Global Champs
Waze Global Champs
Posts: 4056
Answers: 11
Has thanked: 1113 times
Been thanked: 1650 times
Send a message
Keith
UK Country Admin and Global Champ
Area Manager for North West England and the Isle of Man
Google Pixel 5 (Personal)/iPhone 8 (Work) - Carplay/AA - 2021 Toyota Corolla

https://s.waze.tools/gc.pnghttps://s.waze.tools/c6s.pnghttps://s.waze.tools/s0500.pnghttps://s.waze.tools/betc.pnghttps://s.waze.tools/beta.pnghttps://s.waze.tools/tem.png
https://i.imgur.com/nW244c6.png

Post by titchy_
Hi Keith

Any chance of a pivot table sorted by city so we can quickly get a view of events by the areas that we manage without having to go in each tab?

Edit; actually I'm not sure how easy this is to do. In Excel it's a PowerPivot but I don't know if that's possible in Google Sheets :|
titchy_
Waze Mentor
Waze Mentor
Posts: 1090
Has thanked: 581 times
Been thanked: 225 times
Send a message


UK Country Manager
Yorkshire • Cumbria • Channel Islands

https://i.imgur.com/nW244c6.png