User:Spedracr/sheet View history

(Created page with "f")
 
(2022 updates)
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
f
=====Waze Catastrophic Event Closure Tracking=====
 
Below is the google form and google sheet currently being used to track closures in weather related events.  The form is for use by anyone and feeds the closure sheet.  The sheet is used by those that can do the closures. 
 
*[https://docs.google.com/forms/d/e/1FAIpQLSduBiLMhbg6nRpsEVCTcVbV4eWmHDXdIKGtuaOvzy6NZLbSgw/viewform Waze USA Event Closures Entry Form]
 
Below is the google form for instant access to the sheet currently being used to track closures for events.
 
*[https://docs.google.com/forms/d/e/1FAIpQLSd6tH-8zgmHs2hxqa42jngimxPmuNID6y90c2abRMMx1YRMiQ/viewform Link for the Authorization Form to sheet below]
 
Below is the google sheet currently being used to track closures for events.
 
*[https://docs.google.com/spreadsheets/d/1WCbVPLEHwqESbYRsXbKfuKRB2Dinvo5kxCgyWnSg70k/edit#gid=712145152 Waze USA Event Tracking Sheet]
 
Below is a Form Filler Script created by crazycaveman. It saves a lot of time for the people adding them to the sheet. You will need tapermonkey to install.
 
*[https://greasyfork.org/en/scripts/23367-wme-form-filler Form Filler Script]  V 1.4.4.4 Last updated 5/01/2019
 
=====Google sheet tips, short cuts, etc=====
 
*To change the view and only see a certain condition Click on ('''Data''') then ('''Filter views)''' then choose the one you want from the choices on the far right.  Using the <code>'''Filter'''</code> option instead of the <code>'''Filter Views'''</code> will affect everyone's view.
'''DATA FILTER VIEW FOR SPECIFIC STATE (This will not affect the view of others)'''
 
*You will need to do the following steps
 
#Data->Filter Views -> Closure By State (View)
#click the gear icon in Data Filter View
#click Duplicate.  This should make a copy of the Data View
#Change the name of from "Closure By State) to the state(s) you want to see (ie NC Closures) as name<>.  This will be in the upper left hand corner above the column letters.
#Go to cell I3 and click the filter icon.
#Select the state you want to filter.  Deselect others as necessary.
#This will now create the data filter view for that particular state.
 
'''COLUMN C'''
 
*This is the Permalink to the closure with the layers stripped out.  ('''''Please do not edit anything in this column''''')
 
'''UPDATING TIME CHECKED''' -
 
*Updating the time checked in Column H "LAST CHECKED TIME" is as simple as changing the name (Has to be a name change) in Column G "LAST CHECKED BY" or typing something in Column E (ie I usually just type the number 1).  It should automatically update to the current time.
 
'''SORTING'''
 
*Do so sparingly and with a warning to other editors. (Can only be done by sheet admins)
 
{{font color|red|'''ROW DELETION'''}}
 
*If for some reason an editor deletes out a row.  Please click on the words ROW DELETION to re-execute the DUP SCRIPT.  It is located at the top of Column P
 
'''COLUMN F "Type" *Highlighted requires action by someone with EA for the closure.*'''
{| class="wikitable"
|-
!Type!!Usage
|-
|zOPEN||Open in Waze
|-
|CLOSED||Closed in Waze
|- style="background: green; color: black"
|'''NEEDS OPENED'''||'''Needs to be validated and open or extended as needed'''
|- style="background: blue; color: white"
|'''REPORTED'''||'''Needs to be closed in Waze by editor with access to location'''
|-
|UNLISTED||No longer found on source location. Needs closure removed and marked as open
|-
|DUPLICATE||Segment ID(s) found in other closure Permalink(s)
|- style="background: green; color: black"
|'''EXTEND/SHORTEN'''||'''Closure still in effect just needs date/time adjusted to match new information.'''
|- style="background: green; color: black"
|'''NEEDS OPEN NOT LISTED'''||'''Closure in WME but not listed on closure sheet.'''
|-
|FUTURE/PLANNED/ENTERED||Closed in future in WME, used for Contraflow.
|}
 
*If a line has expired and is reopened in real life please change to zOPEN in column F
 
'''COLUMNS A-D'''
 
*Are not editable as they are derived data.  If the closure date/time needs extended please edit the date/time in Column E
 
=====Change Log for Road Closures Sheet (Post-Harvey)=====
 
*Sort order changed, now---- State, Current waze Status, County/Parish/Municipality, then Closure Ending Date/time, moved zOPEN to bottom of sheet below everything else listed above.
*Changed OPEN to zOPEN so opens now show up at the bottom of each state since we need to see them less.
*Added NEEDS OPEN NOT LISTED to form and sheet to support closures in WME not on sheet that need to be opened.
*Flipped LAST CHECKED BY and LAST CHECKED TIME for better flow.  Now one tab over from status is id instead of date/time then ID.
*Changed TIME NEEDS UPDATED to EXTEND/SHORTEN
*Move old "TIME NEEDS UPDATED" now EXTEND/SHORTEN to be beside NEEDS OPENED for counts
*Updated Form with "NEEDS OPEN NOT LISTED" as a drop down choice for status
*The script that checks for duplicates has not been updated thanks to dbsooner and justins83.  We now check to see if the new row entered is a duplicate of others.  We also can do a check every row against every other row on the sheet check as needed.
*A lot of behind the scenes script updates by dbsooner to make Expired, Expiring, Duplcate check work better and faster.
*A real time Stats tab that keeps up with some data.  More will be coming out later.
*If you receive a warning message about cells being protected please do NOT make the change.  Ask in the Waze VEOC spreadsheet-issues channel.  Someone will review and make changes as needed.

Latest revision as of 00:28, 15 March 2022

Waze Catastrophic Event Closure Tracking

Below is the google form and google sheet currently being used to track closures in weather related events. The form is for use by anyone and feeds the closure sheet. The sheet is used by those that can do the closures.

Below is the google form for instant access to the sheet currently being used to track closures for events.

Below is the google sheet currently being used to track closures for events.

Below is a Form Filler Script created by crazycaveman. It saves a lot of time for the people adding them to the sheet. You will need tapermonkey to install.

Google sheet tips, short cuts, etc
  • To change the view and only see a certain condition Click on (Data) then (Filter views) then choose the one you want from the choices on the far right. Using the Filter option instead of the Filter Views will affect everyone's view.

DATA FILTER VIEW FOR SPECIFIC STATE (This will not affect the view of others)

  • You will need to do the following steps
  1. Data->Filter Views -> Closure By State (View)
  2. click the gear icon in Data Filter View
  3. click Duplicate. This should make a copy of the Data View
  4. Change the name of from "Closure By State) to the state(s) you want to see (ie NC Closures) as name<>. This will be in the upper left hand corner above the column letters.
  5. Go to cell I3 and click the filter icon.
  6. Select the state you want to filter. Deselect others as necessary.
  7. This will now create the data filter view for that particular state.

COLUMN C

  • This is the Permalink to the closure with the layers stripped out. (Please do not edit anything in this column)

UPDATING TIME CHECKED -

  • Updating the time checked in Column H "LAST CHECKED TIME" is as simple as changing the name (Has to be a name change) in Column G "LAST CHECKED BY" or typing something in Column E (ie I usually just type the number 1). It should automatically update to the current time.

SORTING

  • Do so sparingly and with a warning to other editors. (Can only be done by sheet admins)

ROW DELETION

  • If for some reason an editor deletes out a row. Please click on the words ROW DELETION to re-execute the DUP SCRIPT. It is located at the top of Column P

COLUMN F "Type" *Highlighted requires action by someone with EA for the closure.*

Type Usage
zOPEN Open in Waze
CLOSED Closed in Waze
NEEDS OPENED Needs to be validated and open or extended as needed
REPORTED Needs to be closed in Waze by editor with access to location
UNLISTED No longer found on source location. Needs closure removed and marked as open
DUPLICATE Segment ID(s) found in other closure Permalink(s)
EXTEND/SHORTEN Closure still in effect just needs date/time adjusted to match new information.
NEEDS OPEN NOT LISTED Closure in WME but not listed on closure sheet.
FUTURE/PLANNED/ENTERED Closed in future in WME, used for Contraflow.
  • If a line has expired and is reopened in real life please change to zOPEN in column F

COLUMNS A-D

  • Are not editable as they are derived data. If the closure date/time needs extended please edit the date/time in Column E
Change Log for Road Closures Sheet (Post-Harvey)
  • Sort order changed, now---- State, Current waze Status, County/Parish/Municipality, then Closure Ending Date/time, moved zOPEN to bottom of sheet below everything else listed above.
  • Changed OPEN to zOPEN so opens now show up at the bottom of each state since we need to see them less.
  • Added NEEDS OPEN NOT LISTED to form and sheet to support closures in WME not on sheet that need to be opened.
  • Flipped LAST CHECKED BY and LAST CHECKED TIME for better flow.  Now one tab over from status is id instead of date/time then ID.
  • Changed TIME NEEDS UPDATED to EXTEND/SHORTEN
  • Move old "TIME NEEDS UPDATED" now EXTEND/SHORTEN to be beside NEEDS OPENED for counts
  • Updated Form with "NEEDS OPEN NOT LISTED" as a drop down choice for status
  • The script that checks for duplicates has not been updated thanks to dbsooner and justins83. We now check to see if the new row entered is a duplicate of others. We also can do a check every row against every other row on the sheet check as needed.
  • A lot of behind the scenes script updates by dbsooner to make Expired, Expiring, Duplcate check work better and faster.
  • A real time Stats tab that keeps up with some data. More will be coming out later.
  • If you receive a warning message about cells being protected please do NOT make the change. Ask in the Waze VEOC spreadsheet-issues channel. Someone will review and make changes as needed.