[TRU Research] Spreadsheet update

[Katie Wilson]

The other badges aren’t really continuums, they’re just yes or no. So maybe they each need their own column.

> On Sep 9, 2019, at 1:25 PM, Jim Walseth <jim.walseth at gmail.com> wrote:
> 
> Regarding "how we’re supposed indicate these badges on the spreadsheet" for my prototyping with the leaves* I was using "rating" column. That works if the badge is also a "continuum", meaning they are in some order and the employer is identified by one badge. We could use negative ratings then, for the tortoise etc.
> Jim
> * we can still dispense with leaves
> 
> On Mon, Sep 9, 2019 at 1:08 PM Katie Wilson <katie at transitriders.org <mailto:katie at transitriders.org>> wrote:
> Hey All,
> 
> Quick update on the spreadsheet <https://docs.google.com/spreadsheets/d/1HmOcG7hJLD1G0unCMPcsDnXr4RIA_PMKEE5ne-hhQR8/edit?usp=sharing>. I added a “cost per month” column and filled it in for all the employers with the “publish” box checked.
> 
> The “description” column should be the only text that shows up in the pop-up; I also updated and kind of standardized the descriptions for the aforementioned ready-to-go entries.
> 
> I think if we’re going to use the leaf system it should be zero to three leaves:
> 
> Zero: No subsidy (may do pre-tax)
> One: Some subsidy, cost to employee is 50/month or more
> Two: Some subsidy, cost to employee is 10-50 per month
> Three: Cost to employee is less than 10 per month
> 
> Dollars above are pre-tax, so in fact if they are able to purchase with pre-tax dollars the actual cost to the employee may be lower.
> 
> If we know an employer doesn’t do the pre-tax thing, they get a tortoise.
> If they subsidize parking more than transit, they get a car.
> If they give way better transit benefits to some employees than others, they get unbalances scales.
> If they go above and beyond, they get a gold ribbon.
> 
> I don’t remember how we’re supposed indicate these badges on the spreadsheet. If someone can tell me I can add those in later today.
> 
> - Katie
> 
> Katie Wilson
> General Secretary
> Transit Riders Union
> https://transitriders.org <https://transitriders.org/>
> 206-781-7204
> 
> The Transit Riders Union is a democratic organization of working and poor people, including students, seniors, and people with disabilities, taking control over our own lives, and building up the power we need to change society for the good of humanity and of the planet. We will fight to preserve, expand, and improve the public transportation system in Seattle and beyond, so that every human being has access to safe, affordable, and reliable public transit.
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.transitriders.org/pipermail/research/attachments/20190909/ca6d866c/attachment.html>