<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">This is awesome, thank you Stephen. I put some thoughts in-line<font color="#ff2600" class=""> in red </font>below, and attached a hard-to-interpret spreadsheet with info about Business Choice participants.<div class=""><br class=""></div><div class="">I will try to schedule some time this week to start completing rows for the businesses I’m sure about based on the info we have. If anyone wants to get together for a spreadsheet workparty this week let me know, I have time Tuesday and Friday evenings.<div class=""><br class=""></div><div class="">Katie<br class=""><div class=""><br class=""></div><div class=""><div><blockquote type="cite" class=""><div class="">On Aug 25, 2019, at 3:37 PM, Stephen DeSanto <<a href="mailto:rachidian@gmail.com" class="">rachidian@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">Hi everyone. Made a few updates to the <a href="https://docs.google.com/spreadsheets/d/1HmOcG7hJLD1G0unCMPcsDnXr4RIA_PMKEE5ne-hhQR8/edit?usp=sharing" class="">master list of employers</a> for the upcoming website:</div><div class=""><ul class=""><li class="">Added companies and transit benefits raw descriptions from TRU survey data<br class=""></li><li class="">Added "Likely CTR Targets": <a href="https://seattletransitpasses-research.pbworks.com/w/page/133438365/Likely%20Target%20Assessment" class="">https://seattletransitpasses-research.pbworks.com/w/page/133438365/Likely%20Target%20Assessment</a></li><li class="">Added "Potential CTR Targets": <a href="https://seattletransitpasses-research.pbworks.com/w/page/133437828/Potential%20CTR%20Targets" class="">https://seattletransitpasses-research.pbworks.com/w/page/133437828/Potential%20CTR%20Targets</a></li><li class="">"Likely" / high-profile targets (hotels, banks) are highlighted in ORANGE</li><li class="">Added "Potential Poster Children": <a href="https://seattletransitpasses-research.pbworks.com/w/page/133439169/Potential%20Poster%20Children" class="">https://seattletransitpasses-research.pbworks.com/w/page/133439169/Potential%20Poster%20Children</a></li><li class="">Poster children are highlighted in GREEN</li></ul><div class="">Highlight colors are just to make it easier to find rows that a) someone said should be included in the list, and b) probably needs benefits data incorporated</div><div class=""><br class=""></div><div class="">Things to be done:</div><div class=""><ul class=""><li class="">Normalize locations data <font color="#ff2600" class="">For this and the “leaf scores†and the <span style="caret-color: rgb(255, 38, 0);" class="">“polluter</span>†columns, I’d be inclined to do this after we’ve got enough info to check the “publish†box. I could be wrong, but I feel like it will be less work that way.</font></li><li class="">Assign "leaf scores" to all companies that don't have one<br class=""></li><li class="">Assign "polluter" etc badges to companies we want to name&shame </li><li class="">Add all of the hotels? <a href="https://seattletransitpasses-research.pbworks.com/w/page/133666440/Hotels" class="">https://seattletransitpasses-research.pbworks.com/w/page/133666440/Hotels</a> <font color="#ff2600" class="">Yeah let’s go ahead and add them...</font></li><li class="">Add Choice participants? <font color="#ff2600" class="">Good question. I did get info back from Metro on what products the choice participants are buying, I can’t remember whether I shared that with you all. Anyway, it’s attached. It’s actually a little hard to interpret (I got a tutorial from a Metro staffer) so I can try to explain by phone or in person if someone wants to dig throughthat. Maybe it makes sense to look through that info and add businesses selectively as we feel like we have a grasp on their programs.</font></li><li class="">Add column for Commute Seattle participants? <a href="https://seattletransitpasses-research.pbworks.com/w/page/133438167/Commute Seattle List of Passport Participants" class="">https://seattletransitpasses-research.pbworks.com/w/page/133438167/Commute%20Seattle%20List%20of%20Passport%20Participants</a><font color="#ff2600" class=""> I don’t think we need to do this, because this info is most likely duplicative with what we learned from Metro about passport participants. The Commute Seattle list doesn’t tell us how much of a subsidy they provide, so it’s not going to add much.</font></li></ul></div></div></div></div></blockquote><blockquote type="cite" class=""><div class=""><div dir="ltr" class=""><div class=""><div class=""><ul class=""><li class="">Citations, descriptions of benefits, etc. for companies that need it</li></ul><div class="">There's still a lot we're not 100% sure about for employer benefits, but we can do the best we have with what we've got, and make changes as we get new information.<br class=""></div><div class=""><br class=""></div><div class="">My thinking was, we can use the "master employer list" to get as much information about the companies we're interested in. When we're satisfied that a row is finished and ready for publication, check the checkbox in the "__publish" column. Then, when we export this data to the website, we can only get the rows where "__publish" is checked. This hopefully will ensure that someone manually reviewed and verified all the data for an employer before it gets published, and that unfinished rows won't be accidentally exported.</div><div class=""><br class=""></div><div class="">Is this helpful? Am I just spinning my wheels in the mud?<br class=""></div></div></div></div></div></blockquote><div></div></div></div></div></div></body></html>