{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Table A FY18-19 Prog Info","Table B FY20-21 Prog Desc","Table C FY20-21 Costs & Funding","Table D Vehicle Fleet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":41,"comments":3,"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":"Table A FY18-19 Prog Info","index":0,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[13,0,13,1],[13,4,13,13],[13,2,13,3],[4,0,4,5],[5,0,5,5],[6,0,6,5],[7,0,7,5],[8,0,8,5],[9,0,9,5],[10,0,10,5],[3,0,3,6]]}
["Alameda CTC FY 2020-21 Annual Paratransit Program Plan Application (July 1, 2020 - June 30, 2021)"]
[" Attachment Table A: Summary of Past Program Service, Performance, Revenue, and Costs (FY 2018-19)"]
[]
["Total FY 2018-19 Program Revenue\n (Measure B, Measure BB and all other funds available for FY 2018-19)"]
["Estimated Measure B Paratransit DLD reserve balance at the start of FY 2018-19"]
["FY 2018-19 Measure B DLD Paratransit revenue (Staff will confirm using Alameda CTC reports)"]
["Estimated Measure BB Paratransit DLD reserve balance at the start of FY 2018-19"]
["FY 2018-19 Measure BB DLD Paratransit revenue (Staff will confirm using Alameda CTC reports)"]
["Total FY 2018-19 Measure B and BB Paratransit DLD Revenue (Automatically calculated)",null,null,null,null,null,{"$f":"SUM(G5:G8)","v":0}]
["Total FY 2018-19 Other Revenue (All other revenue sources, non-DLD, including fares, discretionary grant, non-Meas B and BB) "]
["Total FY 2018-19 Program Revenue (Measure B, Measure BB and all other sources available for FY 2018-19)  (Automatically calculated)",null,null,null,null,null,{"$f":"G9+G10","v":0}]
[]
[]
["Service/Program Type and Name",null,"Performance FY 2018-19",null,"Total FY 2018-19 Program Costs Expended by Fund Source\n (Measure B, Measure BB and all other funds expended during FY 2017-18)",null,null,null,null,null,null,null,null,null,"Notes"]
["Column A","Column B","Column C","Column D","Column E","Column F","Column G","Column H","Column I","Column J","Column K","Column L","Column M","Column N","Column O"]
["Eligible Service/Program\nType    \n\nDrop-down Menu               ","Service/Program/Project Name","Quantity Provided \nFY 2018-19 \nProvide total number of one-way trips or units ","On-Time Performance \nFY 2018-19 \nPercent of passenger trips arrived within designated window (indicate if data is unavailable or non-applicable)"," Amount of RESERVE Measure B Paratransit\nDLD funds EXPENDED","Amount of FY 2018-19 Measure B Paratransit\nDLD funds EXPENDED"," Amount of RESERVE Measure BB Paratransit\nDLD funds EXPENDED","Amount of FY 2018-19 Measure BB Paratransit\nDLD funds EXPENDED","Amount of OTHER \nMeasure B/BB funds EXPENDED","What was the source of these OTHER Measure B/BB funds?\n(e.g. MB Gap Grant, MB LSR, etc.)","Fare Revenue expended on service ","Amount of all non-Alameda CTC funds EXPENDED\n (not including fares)\n","What was the source of these non-Alameda CTC funds?\n(e.g. City general fund, federal, state, etc.)","Total Funds expended\n(all sources)\n\nAutomatically calculated","Miscellaneous Notes\n(If necessary, provide any notes/clarification about trip/program)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E17+F17+G17+H17+I17+K17+L17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E18+F18+G18+H18+I18+K18+L18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E30+F30+G30+H30+I30+K30+L30","v":0}]
[null,null,null,null,{"$f":"SUM(E17:E30)","v":0},0,0,0,0,null,{"$f":"SUM(K17:K30)","v":0},{"$f":"SUM(L17:L30)","v":0},null,{"$f":"SUM(N17:N30)","v":0}]
[]
[]
[]
[]
["Management/Overhead"]
["Customer Service and Outreach"]
["ADA-mandated Paratransit"]
["Same-Day Transp. - Taxi"]
["Same-Day Transp. - TNC"]
["Specialized Accessible Van"]
["Accessible Shuttle"]
["Group Trips"]
["Door-through-Door/Volunteer Driver"]
["Mobility Mgmt/Travel Training"]
["Scholarship/Subsidized Fare"]
["Meal Delivery (existing program)"]
["Capital Purchase"]

{"sheet":"Table B FY20-21 Prog Desc","index":1,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[3,4,3,5],[24,3,24,5],[3,6,3,9],[3,0,3,1],[24,0,24,1]]}
["Alameda CTC FY 2020-21 Annual Paratransit Program Plan Application (July 1, 2020 - June 30, 2021)"]
["Attachment Table B: Description of Planned Program"]
["Note: Definitions for each drop-down menu are in the Implementation Guidelines"]
["Service/Program Type and Name",null,"Contractor","Need(s) Met","Cost to Consumer",null,"For Trip Provision Services"]
["Column A","Column B","Column C","Column D","Column E","Column F","Column G","Column H","Column I","Column J"]
["Eligible Service/Program\nType    \n\nDrop-down Menu               ","Service/Program/Project Name","If service is contracted, provide name of contractor/service provider","Need(s) this Service Meets\n(E.g. medical, grocery, recreation, regional trips, etc.)","Fare/Cost to Consumer","Fare Medium\n(E.g. cash, voucher, reimbursement, annual fee, etc.)","Vehicle Accessibility    \n\nDrop-down Menu               ","Is this a same day or pre-scheduled service? \n\nDrop-down Menu               ","Is this a fixed route or origin-to-destination service \n(e.g. door-to-door)?\n\nDrop-down Menu               ","Service Area"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note: Definitions for each drop-down menu are in the Implementation Guidelines"]
["Service/Program Type and Name",null,"Limits","Schedule",null,null,"Eligibility  ","Status","Deliverables","Notes"]
["Column A (repeated)","Column B (repeated)","Column K","Column L","Column M","Column N","Column O","Column P","Column Q","Column R"]
["Service/Program\nType    \n\nWill automatically populate from rows above               ","Service/Program/Project Name\n\nWill automatically populate from rows above","Limits on number of trips/\nuse of service?\n(e.g. trip limits per month/quarter/year or a maximum expenditure per consumer)","If pre-scheduled, what days/hours are reservations accepted for trip, training, etc?","If pre-scheduled, how far in advance can/must a consumer schedule a trip, training, etc?","Days/Hours of Operation","Eligibility Requirements","Project Status\n\nDrop-down Menu   ","Quantity Planned \nProvide total number of units  (one-way passenger trips, consumers trained, meals delivered, etc.)  ","Miscellaneous Notes\n(If necessary, provide any notes/clarification about trip/program)"]
[{"$f":"A7","v":0},0]
[{"$f":"A8","v":0},0]
[{"$f":"A9","v":0},0]
[{"$f":"A10","v":0},0]
[{"$f":"A11","v":0},0]
[{"$f":"A12","v":0},0]
[0,0]
[0,0]
[{"$f":"A15","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[]
[]
[]
[]
[]
["Management/Overhead",null,null,null,null,null,"Accessible","Pre-scheduled","Fixed Route"]
["Customer Service and Outreach",null,null,null,null,null,"Not Accessible","Same Day","Fixed Route w/Deviations"]
["ADA-mandated Paratransit",null,null,null,null,null,null,null,"Curb-to-Curb"]
["Same-Day Transp. - Taxi",null,null,null,null,null,null,null,"Door-to-Door"]
["Same-Day Transp. - TNC",null,null,null,null,null,null,"To be initiated in FY 18/19","Door-through-Door "]
["Specialized Accessible Van",null,null,null,null,null,null,"Continuing/Ongoing"]
["Accessible Shuttle",null,null,null,null,null,null,"To be closed out in FY 18/19"]
["Group Trips"]
["Door-through-Door/Volunteer Driver"]
["Mobility Mgmt/Travel Training"]
["Scholarship/Subsidized Fare"]
["Meal Delivery (existing program)"]
["Capital Purchase"]

{"sheet":"Table C FY20-21 Costs & Funding","index":2,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,11],[32,0,32,2],[33,0,33,2],[11,15,11,16],[11,2,11,10],[31,0,31,2],[2,0,2,11],[3,0,3,10],[4,0,4,10],[11,0,11,1],[11,12,11,13],[6,0,6,10],[7,0,7,10],[8,0,8,10],[9,0,9,10],[5,0,5,10]]}
["Alameda CTC FY 2020-21 Annual Paratransit Program Plan Application (July 1, 2020 - June 30, 2021)\nAttachment Table C: Program Revenue, Cost and Fund Sources"]
[]
["Total FY 2020-21 Program Revenue\n (Measure B, Measure BB and all other funds available for FY 2020-21)"]
["Estimated Measure B Paratransit DLD ending balance at the end of THIS fiscal year, FY 2019-20 (June 30, 2020) "]
["Projected FY 2020-21 Measure B DLD Paratransit revenue (Use projections distributed by the Alameda CTC)"]
["Estimated Measure BB Paratransit DLD ending balance at the end of THIS fiscal year, FY 2019-20 (June 30, 2020) "]
["Projected FY 2020-21 Measure BB DLD Paratransit revenue (Use projections distributed by the Alameda CTC)"]
["Total FY 2020-21 Measure B and BB Paratransit DLD Revenue (Automatically calculated)",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L4:L7)","v":0}]
["Total FY 2020-21 Other Revenue (All other revenue sources, non-DLD, including fares, discretionary grant, non-Meas B and BB) "]
["Total FY 2019-20 Program Revenue  (Measure B, Measure BB and all other sources available for FY 2019-20)  (Automatically calculated)",null,null,null,null,null,null,null,null,null,null,{"$f":"L8+L9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WE CAN HIDE THESE 2 COLUMNS"]
["Service/Program Name",null,"Total FY 2020-21 Program Costs by Fund Source\n (Measure B, Measure BB and all other funds planned to be expended during FY 2020-21)",null,null,null,null,null,null,null,null,"Total Cost  ","Cost per Trip",null,"Measure B Cost per Trip","Portion of Program Funded by Measure B"]
["Column A","Column B","Column C","Column D","Column E","Column F","Column G","Column H","Column I","Column J","Column K","Column L","Column L","Column M","Column N","Column O","Column L"]
["Service/Program/Project Name\n\nAutomatically populated from prior sheet (column B)","Quantity Planned for FY 2020-21\n\nAutomatically populated from prior sheet (column Q) "," Amount of RESERVE Measure B Paratransit\nDLD funds to be EXPENDED","Amount of FY 2020-21 Measure B Paratransit\nDLD funds to be EXPENDED","Amount of RESERVE Measure BB Paratransit\nDLD funds to be EXPENDED","Amount of FY 2020-21 Measure BB Paratransit\nDLD funds to be EXPENDED","Amount of OTHER \nMeasure B/BB funds to be EXPENDED","What is the source of these OTHER Measure B/BB funds?\n(e.g. MB Gap Grant, LSR, MB LSR, etc.)","Fare Revenue to be expended on service ","Amount of all Non-Alameda CTC funds to be EXPENDED\n (not including fares)\n","What is the source of these non-Alameda CTC funds?\n(e.g. city funds, federal, state, etc.)","Total Cost\n(all sources)\n\nAutomatically calculated","Cost per Trip or other unit of service \n(e.g. per training, meal, etc.)\n\nWill automatically calculate","Net Cost per Trip or other unit of service \n(net of fare revenue)\n\nWill automatically calculate","Measure B Cost per Trip or other unit of service\n\nWill automatically calculate","Percentage of total cost funded through Measure B\n\nWill automatically calculate","Number of planned trips funded by Measure B\n\nWill automatically calculate"]
[{"$f":"'Table B FY20-21 Prog Desc'!B7","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I28","v":0},null,null,null,null,null,null,null,null,null,{"$f":"C15+D15+E15+F15+G15+I15+J15","v":0},{"$f":"L15/B15","v":{"$error":"#DIV/0!"}},{"$f":"(L15-I15)/B15","v":{"$error":"#DIV/0!"}},{"$f":"(D15+G15)/B15","v":{"$error":"#DIV/0!"}},{"$f":"(D15+G15)/L15","v":{"$error":"#DIV/0!"}},{"$f":"P15*B15","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Table B FY20-21 Prog Desc'!B8","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I29","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B9","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I30","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B10","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I31","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B11","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I32","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B12","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I33","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B13","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I34","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B14","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I35","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B15","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I36","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B16","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I37","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B17","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I38","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B18","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I39","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B19","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I40","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'Table B FY20-21 Prog Desc'!B20","v":0},{"$f":"'Table B FY20-21 Prog Desc'!I41","v":0},null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Totals",{"$f":"SUM(B15:B28)","v":0},0,0,0,0,0,null,{"$f":"SUM(I15:I28)","v":0},{"$f":"SUM(J15:J28)","v":0},null,{"$f":"SUM(L15:L28)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Budget check (total revenue less total cost):",{"$f":"L10-L29","v":0}]
["PARATRANSIT DLD RESERVE BALANCES ",null,null,"Measure B","Measure BB","Total MB/BB"]
["Estimated Reserve Balance, June 30, 2021:",null,null,{"$f":"((L4+L5)-(C29+D29))","v":0},{"$f":"((L6+L7)-(E29+F29))","v":0},{"$f":"SUM(D33:E33)","v":0}]
["Reserve balance as percent of FY 2020-21 Revenue*",null,null,{"$f":"D33/L5","v":{"$error":"#DIV/0!"}},{"$f":"E33/L7","v":{"$error":"#DIV/0!"}},{"$f":"F33/(L5+L7)","v":{"$error":"#DIV/0!"}}]
[]
["*Alameda CTC's Timely Use of Funds policy looks at entire jurisdiction's fund balance."]

{"sheet":"Table D Vehicle Fleet","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,0,3,9],[5,5,5,6],[0,0,0,9],[1,0,1,9]]}
["Alameda CTC FY 2020-21 Annual Paratransit Program Plan Application (July 1, 2020 - June 30, 2021)"]
["Attachment Table D: Vehicle Fleet"]
["Instructions:  Please complete table below.  If necessary, please contact your contractors to obtain the information."]
["Vehicle Fleet"]
["Column A","Column B","Column C","Column D","Column E","Column F","Column G","Column H","Column I","Column J"]
[null,null,null,null,null,"Vehicle Capacity"]
["Make","Type of Vehicle(s) (specify bus, large van, minivan, sedan)","Year of Vehicle","Fuel Type","Lift/Ramp Equipment (specify lift, ramp, or none)","Ambulatory","Wheelchair","Number of Vehicles","Owner (specify if contractor)","City that vehicle(s) are garaged"]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]
["     ","     ",null,"     ","     ","     ","     ","     ","     ","     "]