{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Closeout Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Closeout Report","index":0,"n_rows":163,"n_cols":10,"rows_kept":163,"cut":false,"hidden":false,"merged":[[89,2,89,9],[17,1,17,9],[75,1,75,9],[87,5,87,6],[88,5,88,6],[85,5,85,6],[86,5,86,6],[77,1,77,9],[80,5,80,6],[80,7,80,9],[67,1,67,9],[51,7,51,9],[59,5,59,6],[60,5,60,6],[57,5,57,6],[52,7,52,9],[56,7,56,9],[81,5,81,6],[81,7,81,9],[79,5,79,6],[79,7,79,9],[63,1,66,9],[40,1,43,9],[58,7,58,9],[57,7,57,9],[56,5,56,6],[59,7,59,9],[60,7,60,9],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[58,5,58,6],[53,7,53,9],[54,7,54,9],[55,7,55,9],[25,5,25,6],[26,5,26,6],[47,1,47,2],[46,7,46,8],[49,1,49,9],[27,7,27,9],[28,7,28,9],[29,7,29,9],[36,5,36,6],[36,7,36,9],[55,5,55,6],[9,3,9,4],[9,6,9,9],[10,3,10,4],[10,6,10,9],[12,1,14,9],[30,5,30,6],[31,5,31,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[33,7,33,9],[31,7,31,9],[45,1,45,9],[30,7,30,9],[24,7,24,9],[3,7,3,8],[130,1,130,3],[96,1,96,9],[100,1,100,9],[97,7,97,8],[98,1,98,2],[121,1,121,9],[102,1,102,6],[111,1,111,3],[111,5,111,6],[116,1,116,3],[119,1,119,6],[5,1,5,2],[5,7,5,8],[7,1,7,9],[8,3,8,9],[50,7,50,9],[37,5,37,6],[24,5,24,6],[37,7,37,9],[20,1,21,9],[32,5,32,6],[32,7,32,9],[27,5,27,6],[28,5,28,6],[23,5,23,6],[23,7,23,9],[29,5,29,6],[34,7,34,9],[35,7,35,9],[25,7,25,9],[26,7,26,9]]}
["The column titles for this worksheet are in row 1. They span cells B1. The data spans cells B2 through J163. There is information in every cell for column A through J.  If you are not using a screen reader, you can press Alt + R, T for the Review Ribbon, Edit Comment to move to and open a Comment once you are on a cell with a Comment. When you are finished reading the Comment, press Escape to close the comment and return to the worksheet. If you are using the JAWS screen reader, press Ctrl + Shift + Apostrophe to get a list of Comments and their cell coordinates in the worksheet. Press Enter on the Comment you want to go to or Escape once you’ve read the Comment for a cell. You are returned to the workbook. Note that there is no keyboard command with JAWS to reread Comments or read Comments once you are on them in a cell. You must use the ability to list Comments in order to read them if you are using the JAWS screen reader. ","PROPOSITION 1B FINAL DELIVERY REPORT"]
[null,null,"Program ","CMIA     ","SR99     ","STIP"]
[null,null,null,"SHOPP     ","TCIF     ","SLPP     "]
[null,null,null,"Final Delivery Rpt","       Supplemental Final Delivery Report",null,null,"Date"]
[null,"EA",null,"PPNO","District","County","Route","PM Bk",null,"PM Ahd"]
[]
[null,"Project Title"]
[]
[null,"Project Sponsor"]
[null,"Contact Name:",null,null,null,"Agency:"]
[null,null,"E-mail:",null,null,"Phone:"]
[null,"Current Approved Scope of Work:"]
[]
[]
[]
[null,"Does the completed project match the approved scope of work?",null,null,null,null,null,null,"Yes","No"]
[null,"If no, please describe changes to scope of work:"]
[]
[null,"If this project is a segment to the overall bond programmed project identify  # of total."]
[]
[]
[]
[null,"FINANCIAL INFORMATION (all numbers in thousands)"]
[null,"by Phase",null,"Original Baseline","Current Approved","Actual Expended",null,"Net Difference"]
[null,null,"Environmental",null,null,null,null,{"$f":"E25-F25","v":0}]
[null,null,"Design",null,null,null,null,{"$f":"E26-F26","v":0}]
[null,null,"ROW Support",null,null,null,null,0]
[null,null,"CON Support",null,null,null,null,0]
[null,null,"ROW Capital",null,null,null,null,0]
[null,null,"CON Capital",null,null,null,null,{"$f":"E30-F30","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D25:D30)","v":0},{"$f":"SUM(E25:E30)","v":0},{"$f":"SUM(F25:G30)","v":0},null,{"$f":"SUM(H25:J30)","v":0}]
[]
[null,"by Fund Type",null,"Original Baseline","Current Approved","Actual Expended",null,"Net Difference"]
[null,null,"Select…",null,null,null,null,{"$f":"E34-F34","v":0}]
[null,null,"Select…",null,null,null,null,{"$f":"E35-F35","v":0}]
[null,null,"Select…",null,null,null,null,0]
[null,null,"Select…",null,null,null,null,{"$f":"E37-F37","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D34:D37)","v":0},{"$f":"SUM(E34:E37)","v":0},{"$f":"SUM(F34:G37)","v":0},null,{"$f":"SUM(H34:J37)","v":0}]
[]
[null,"If actual expenditures are greater than approved, please explain/ If savings were they captured:"]
[]
[]
[]
[]
[]
[null,"PROPOSITION 1B FINAL DELIVERY REPORT- ON SYSTEM PROJECTS, Pg 2"]
[null,"EA",null,"PPNO","District","County","Route","Date",null,{"$f":"J4","v":"00:00:00"}]
[null,{"$f":"B6","v":0},null,{"$f":"D6","v":0},{"$f":"E6","v":0},{"$f":"F6","v":0},{"$f":"G6","v":0}]
[]
[null,"SCHEDULE"]
[null,null,null,"Original Baseline","Current Approved","Actual Schedule",null,"Net Difference (months)"]
[null,null,"Begin ENV",null,null,null,null,{"$f":"ROUND((F52-E52)/30.41666,0)","v":0}]
[null,null,"End ENV (PAED)",null,null,null,null,{"$f":"ROUND((F53-E53)/30.41666,0)","v":0}]
[null,null,"Begin Design",null,null,null,null,{"$f":"ROUND((F54-E54)/30.41666,0)","v":0}]
[null,null,"End Design (RTL)",null,null,null,null,0]
[null,null,"Begin ROW",null,null,null,null,0]
[null,null,"End ROW",null,null,null,null,0]
[null,null,"Begin CON (Award)",null,null,null,null,0]
[null,null,"End CON",null,null,null,null,0]
[null,null,"Begin Closeout",null,null,null,null,0]
[null,null,"End Closeout",null,null,null,null,{"$f":"ROUND((F61-E61)/30.41666,0)","v":0}]
[]
[null,"If actual schedule is later than approved, please provide corrective action:"]
[]
[]
[]
[]
[null,"AMENDMENTS"]
[null,"List approved amendments:"]
[null,null,"Amendment #","CTC Meeting ","Summary of changes (Scope, Cost, Schedule)"]
[]
[]
[]
[]
[]
[null,"PROPOSITION 1B FINAL DELIVERY REPORT- ON SYSTEM PROJECTS, Pg 3"]
[]
[null,"PERFORMANCE OUTCOME"]
[null,"Corridor System Management Plan (CSMP)"]
[null,null,null,"Original Baseline","Current Approved","Actual Schedule",null,"Net Difference (months)"]
[null,null,"Plan Adoption",null,null,null,null,{"$f":"ROUND((F81-E81)/30.41666,0)","v":0}]
[null,null,"Plan Implementation",null,null,null,null,{"$f":"ROUND((F82-E82)/30.41666,0)","v":0}]
[]
[]
[null,"Benefits"]
[null,null,"Daily Travel Time Savings (hours)"]
[null,null,"Lane Miles Added (HOV)"]
[null,null,"Lane Miles Added (Mixed)"]
[null,null,"Peak Period Time Savings (minutes)"]
[null,null,"Provide narrative on actual benefits and/or outputs and assumptions. If unable to provide calculated values or if this is a segment of a project indicate when data will be provided.  ( Back-up Calculations should be maintained in project file.)"]
[]
[]
[]
[]
[]
[]
[null,"PROPOSITION 1B FINAL DELIVERY REPORT- ON SYSTEM PROJECTS, Pg 4"]
[null,"EA",null,"PPNO","District","County","Route","Date",null,{"$f":"J4","v":"00:00:00"}]
[null,{"$f":"B6","v":0},null,{"$f":"D6","v":0},{"$f":"E6","v":0},{"$f":"F6","v":0},{"$f":"G6","v":0}]
[]
[null,"Certification Signature Page"]
[]
[null,"Project Manager"]
[]
[null,"I hereby certify to the best of my knowledge the information in this report is  true and accurate."]
[null,"The work was performed in accordance with the CTC approved scope, cost, schedules, and benefit"]
[null,"information in the baseline agreement or amendment."]
[]
[]
[]
[]
[null," (Print name) Project Manager"]
[]
[]
[]
[]
[null," (Signature) Project Manager",null,null,null,null,"        Date"]
[]
[]
[null,"Caltrans"]
[]
[null,"The Program Coordinator from the California Department of Transportation has reviewed the "]
[null," information contained  in this report and has verified the information presented is complete."]
[]
[]
[]
[]
[]
[]
[]
[null,"(Signature) Program Coordinator",null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Select…"]
[null,null,"CMIA"]
[null,null,"Route 99"]
[null,null,"TCIF"]
[null,null,"STIP Augmentation"]
[null,null,"IRI"]
[null,null,"LBSRA"]
[null,null,"HRCSA"]
[null,null,"TLSP"]
[null,null,"SLPP"]
[null,null,"STIP (non bond)"]
[null,null,"SHOPP"]
[null,null,"Local"]
[null,null,"Federal"]