Import and tidy initial data

[eroten]

@dpena523 is working on cleaning up Excel workbooks

[dpena523]

service_eval_base.xlsx
service_eval_by_tma.xlsx
this is the base data

[dpena523]

service_eval_base.xlsx

This an updated service_eval_base file, this one includes a new entry, "Regional Total", which isn't included in the original file and is needed for one of the calculations

[dpena523]

service_eval_clean.xlsx

Clean data for the slider tool; can be used for Expanded Access Metric, Improved Transit Service Metric, and Increased by Service Type Metric

[dpena523]

service_eval_clean Metadata

• Scenario "X" Expand: population that has new access to service per each scenario

• Scenario "X" Improve: population that has improved service in each scenario

• Scenario "X" High Freq/Local/Basic/CE: population that has access to each level of transit service

• pop_total: overall population

• X_pct: percent of improvement

• emp_total: overall employment

• poc_total: BIPOC affected

• pov_total: Low Income population affected

• aff_hu: affordable housing units affected

• senior_total: senior population affected

• lo_emp_total: low income jobs affected

• hi_emp_total: high income jobs affected

• pop_tma_X: population affected in transit market area X

• emp_tma_X: jobs affected in transit market area X

[dpena523]

scenario_def.xlsx

Scenario definitions

[dpena523]

scenario_rdrshp.xlsx
Ridership increases for each scenario

[dpena523]

job_access.xlsx
figures for job access measures

[dpena523]

DRAFT Intermediate Scenario Evaluation Memo_20201230.docx

This is the Draft Scenario Evaluation Memo prepared by the consultant, provides some useful context for the analysis.

[dpena523]

Service Allocation Slider Mock Up.pptx

Mock up of slider tool

[dpena523]

Service Allocation Web Tool Text.docx
Proposed text for the slider tool.
Please disregard inserted chart, we are still coming up with a visualization idea, I will have something by end of day

[dpena523]

Slider tool webtext: new text for slider tool; this is good for now, there is a main change in that we want to reconsider what the scenarios are called, so scenario names are still TBD in this version
Service Allocation Web Tool Text 3-2-21.docx