[TRU Research] Spreadsheet update

[Jim Walseth]

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> 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
> 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/d02d2a9a/attachment.html>