{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data Report","Data Report Definitions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Report","index":0,"n_rows":78,"n_cols":3,"rows_kept":78,"cut":false,"hidden":false,"merged":[[20,0,20,2],[24,0,24,2],[39,0,39,2],[9,1,9,2],[5,0,5,2],[12,0,12,2],[18,0,18,2],[68,0,68,2],[69,0,71,2],[82,0,82,2],[33,0,33,2],[48,0,48,2],[52,0,52,2],[49,0,51,2],[59,0,61,2],[34,0,36,2],[77,0,77,2],[78,0,80,2],[58,0,58,2],[4,0,4,2],[7,1,7,2],[8,1,8,2],[6,0,6,2],[0,0,3,2]]}
[]
[]
[]
[]
["Client Demographic Data Report Form"]
[]
["1. Report Information"]
["Agency"]
["Reporting period (mm/dd/yyyy-mm/dd/yyyy)"]
["Date",{"$f":"TODAY()","v":"2023-06-05"}]
[]
["2. Client Demographic Information","#","% of Clients Served"]
["2a. Age and Disability Status"]
["# of clients that ONLY identified as age 65 and older (For grantees that only receive senior mini-grants, this # should include clients age 60 and older)",null,{"$f":"IFERROR(B14/B18,0)","v":0}]
["# of clients that ONLY identified as disabled (Not applicable to grantees that only receive senior mini-grants)",null,{"$f":"IFERROR(B15/B18, 0)","v":0}]
["# of clients that identified as both age 65 and older and disabled (For grantees that only receive senior mini-grants, this # should include clients age 60 and older)",null,{"$f":"IFERROR(B16/B18, 0)","v":0}]
["# of clients served that are incidental service users**",null,{"$f":"IFERROR(B17/B18, 0)","v":0}]
["Total # of clients served during this period",{"$f":"SUM(B14:B17)","v":0},{"$f":"SUM(C14:C17)","v":0}]
["2b. Wheelchair Use"]
["# of clients that used wheelchairs",null,{"$f":"IFERROR(B20/B18, 0)","v":0}]
["2c. Income Status"]
["# of clients that identified as low income",null,{"$f":"IFERROR(B22/B18, 0)","v":0}]
["# of clients that did not identify as low income ",null,{"$f":"IFERROR(B23/B18, 0)","v":0}]
["# of clients that declined to state income status",null,{"$f":"IFERROR(B24/B18, 0)","v":0}]
["2d. Race/Ethnicity "]
["# of clients that identified as American Indian or Alaska Native",null,{"$f":"IFERROR(B26/B18, 0)","v":0}]
["# of clients that identified as Asian or Pacific Islander",null,{"$f":"IFERROR(B27/B18, 0)","v":0}]
["# of clients that identified as Black/African American ",null,{"$f":"IFERROR(B28/B18, 0)","v":0}]
["# of clients that identified as White",null,{"$f":"IFERROR(B29/B18, 0)","v":0}]
["# of clients that identified as some other race ",null,{"$f":"IFERROR(B30/B18, 0)","v":0}]
["# of clients that identified as two or more races ",null,{"$f":"IFERROR(B31/B18, 0)","v":0}]
["# of clients that identified as Hispanic/Latin(o/a)",null,{"$f":"IFERROR(B32/B18, 0)","v":0}]
["# of clients that declined to state their race/ethnicity",null,{"$f":"IFERROR(B33/B18, 0)","v":0}]
["Please describe the method(s) you used to derive this data. If this was through surveys, please indicate your survey response rate."]
[]
[]
[]
[]
["3. Languages of Clients with Limited Engish Proficiency (LEP)","#","% of LEP Clients"]
["If your agency has clients with LEP that speak additional languages, please add each language as a separate row to this section of this report."]
["Language #1",null,{"$f":"IFERROR(B41/B48, 0)","v":0}]
["Language #2",null,{"$f":"IFERROR(B42/B48, 0)","v":0}]
["Language #3",null,{"$f":"IFERROR(B43/B48, 0)","v":0}]
["Language #4",null,{"$f":"IFERROR(B44/B48, 0)","v":0}]
["Language #5",null,{"$f":"IFERROR(B45/B48, 0)","v":0}]
["Language #6",null,{"$f":"IFERROR(B46/B48, 0)","v":0}]
["Language #7",null,{"$f":"IFERROR(B47/B48, 0)","v":0}]
["Total # of clients with LEP",{"$f":"SUM(B41:B47)","v":0},{"$f":"SUM(C41:C47)","v":0}]
["Please describe the method(s) you used to derive this data. If this was through surveys, please indicate your survey response rate."]
[]
[]
[]
[]
["4. Service Quality Information (Operating & Capital Grants Only)","#","% Respondants"]
["# of riders that provided service quality feedback",null,"N/A"]
["# of riders reporting good or excellent service",null,{"$f":"IFERROR(B56/B55, 0)","v":0}]
["# of riders reporting mobility needs as satisfied",null,{"$f":"IFERROR(B57/B55, 0)","v":0}]
["# of riders reporting that the service removed barriers to community resources",null,{"$f":"IFERROR(B58/B55, 0)","v":0}]
["Please describe the method(s) you used to derive this data. If this was through surveys, please indicate your survey response rate."]
[]
[]
[]
[]
["5. Service Quality Information (Mobility Management Grants -  I & R Services)","#","% Respondants"]
["# of individuals that provided information and referral service quality feedback",null,"N/A"]
["# of individuals that reported that information and referral services provided were helpful",null,{"$f":"IFERROR(B66/B65, 0)","v":0}]
["# of individuals that reported that information and referral services provided were accurate",null,{"$f":"IFERROR(B67/B65, 0)","v":0}]
["# of individuals that reported that information and referral services provided were timely",null,{"$f":"IFERROR(B68/B65, 0)","v":0}]
["Please describe the method(s) you used to derive this data. If this was through surveys, please indicate your survey response rate."]
[]
[]
[]
[]
["6. Service Quality Information (Mobility Management Grants - Travel Training)","#","% Respondants"]
["# of individuals that provided travel training service quality feedback",null,"N/A"]
["# of individuals that reported that the travel training allowed them to attain more knowledge about their transportation options",null,{"$f":"IFERROR(B76/B75, 0)","v":0}]
["# of individuals that reported that the travel training allowed them to feel more confident in navigating and using regional public transit or specialized transportation services",null,{"$f":"IFERROR(B77/B75, 0)","v":0}]
["Please describe the method(s) you used to derive this data. If this was through surveys, please indicate your survey response rate."]

{"sheet":"Data Report Definitions","index":1,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Data Report Definitions/Instructions"]
["Term","Definitions/Instructions"]
["American Indian/Alaska Native ","individuals who have origins in any of the original people of North America and who maintain cultural identification through tribal affiliation or community recognition"]
["Asian/Pacific Islander","individuals who have origins in any of the original peoples of the Far East, Southeast Asia, the Indian subcontinent, or the Pacific Islands"]
["Black/African American ","individuals who have origins in any of the black racial groups of Africa"]
["Community resources ","a resource that enables an individual to engage with their community or accomplish activities of daily life e.g. employment centers, libraries, post offices, community centers, religious institutions, grocery stores etc."]
["Disabled ","Consistent with the Americans with Disabilities Act of 1990, an individual with a disability is one who has a physical or mental impairment that substantially limits one or more of their major life activities. "]
["Hispanic/Latin(o/a)","individuals who are of Mexican, Puerto Rican, Cuban, Central or South American or other Spanish culture or origin"]
["Incidental service users","individuals that do not identify as individuals with disabilities, 60 years or 65 years of age and over. For example, attendants who accompany older individuals or passengers with disabilities are incidental service users."]
["Low income ","those with a household annual income of less than 200% of the federal poverty level. See https://aspe.hhs.gov/topics/poverty-economic-mobility/poverty-guidelines"]
["People with limited-English proficiency (LEP)","individuals whose primary language is not English and who have a limited ability to read, speak, write, or understand English. “Limited ability” includes those who speak English less than “very well,” as reported in the American Community Survey (ASC)."]
["Some other race","If a client provides a write-in response that corresponds to a racial category, count that client as belonging to that racial category, rather than “Some other race.” For example, if a client writes in “Puerto Rican” for “Some other race,” count that client as “Hispanic or Latin(o/a).” "]
["Two or more races","If a client checks multiple racial categories, note that client as belonging to “two or more races.” If a client marks a racial category and provides a write-in response of the same racial category for “Some other race”, count that client as belonging to that racial category, rather than “two or more races.” For example, if a client checks “White” and writes in “Italian” for “Some other race,” count that client as “White.” If a client marks one racial category and provides a write-in response of a different racial category, count that client as belonging to “two or more races.” "]
["White","individuals who have origins in any of the original peoples of Europe, the Middle East or North Africa. "]