Updating Speed Alerts on Traffic Camera POI's
Tue, 05/11/2010 - 3:10pm
 |
16 years
|
Posted within this hallowed forum is a "how to" change the speed alerts for the traffic camera POIs. The really kind, smart and benevolent person who put it here is to be commended.
But where is it? I used it once but can't find it now.
Signed,
POI's for Dummies, Inc.
Speed Alert Format Change
OK it now appears that the format has changed from the XX MPH to R/Speed XX. Also, the intersections have been included (thank you Miss POI).
So the question now is how to auto change the alert speed since the previous formula no longer works?
Continuing to assert a viable existence for POI Dummies.
Speed Alert Format Change
OK .. I found it. Under the Forum - Ticket Cameras - is the topic,
"Speed Camera loading for Dummies" by ramcruzer
Scroll down and find the item, "An Excel formula to automate changing the camera data"
by Felix Krull.
However (see additional commentary) with the change in format, it no longer works.
Speed cameras for dummies
OK .. I found it. Under the Forum - Ticket Cameras - is the topic,
"Speed Camera loading for Dummies" by ramcruzer
Scroll down and find the item, "An Excel formula to automate changing the camera data"
by Felix Krull.
However (see additional commentary) with the change in format, it no longer works.
You didn't scroll to the bottom of the thread did you.
Felix updated it:
=IF(ISERR(FIND("Speed",C1)),C1,(LEFT(C1,FIND("Speed",C1)+5)&"@"&MID(C1,(FIND("Speed",C1))+6,2)+5&RIGHT(C1,LEN(C1)-(FIND("Speed",C1)+9))))
ɐ‾nsǝɹ Just one click away from the end of the Internet
Speed Camera Update
a_user
Mea Culpa. You are absolutely correct. I missed seeing the update. Many thanks.