{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["NDRD Project Tracking","Examples"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"NDRD Project Tracking","index":0,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,3,29,22],[43,3,43,22],[44,3,44,22],[42,3,42,22],[2,6,2,11],[2,12,2,13]],"flags":["formulas_cached_only"]}
["Example Cost Estimate Table for NDRD Interim Program Guidance ",null,null,null,"V1: 8/11/2015"]
[]
["Region","Project Subaccount  and Number","Project Name","Total Project Cost","Dates","Milestones: Scoping, FIR, FOR, AD","Cost Categories: Estimates for all PWQ Costs",{"$nulls":5},"Non-CDOT Resources**",null,"Estimated Total to be Reimbursed","Payment Item","Date Work Perfomred","Total Actual Cost (Invoice Amount)","Invoice Date","Payments from PWQ Pool","Payment Date","Total Actual Costs","Status Notes"]
[{"$nulls":6},"ROW","Design, incl Enviro Clearances and Survey","Utilities","Construction  include CE *","Misc","Total","Funding from outside CDOT","In-kind from outside CDOT"]
{"$rows_empty":26}
["* Include CDOT CE and indirect costs here. Currently, those equal 22.1% of the construction cost. Note % used in the \"Status Notes.\""]
["** Describe Source of funds and type of in-kind resources that are being provided in the \"Status Notes\""]

{"sheet":"Examples","index":1,"n_rows":28,"n_cols":23,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,6,2,11],[2,12,2,13]],"flags":["formulas_cached_only"]}
["Example Cost Estimate Table for NDRD Interim Program Guidance "]
[]
["Region","Project Subaccount  and Number","Project Name","Total Project Cost","Dates","Milestones: Scoping, FIR, FOR, AD","Cost Categories: Estimates for all PWQ Costs",{"$nulls":5},"Non-CDOT Resources**",null,"Estimated Total to be Reimbursed","Payment Item","Date Work Perfomred","Invoice Amount","Invoice Date","Payments from PWQ Pool","Payment Date","Total Actual Costs","Status Notes"]
[{"$nulls":6},"ROW","Design, incl Enviro Clearances and Survey","Utilities","Construction  include CE *","Misc","Total","Funding from outside CDOT","In-kind from outside CDOT"]
[]
[]
[]
[1,19000,"I-25-related EA"]
[null,"NHPP 0250-403","non-RAMP",null,"2013-01-20","Scoping",200000,50000,25000,950000,null,1225000]
[{"$nulls":4},"2014-03-15","FIR",{"$nulls":5},0]
[{"$nulls":4},"2014-05-28",{"$nulls":10},"Draft Drainage Report","2014-05-02",10000,"2015-05-07",10000,"2014-06-07",10000]
[{"$nulls":4},"2014-05-29",{"$nulls":10},"Draft PWQ Plans","2014-05-10",15000,"2014-05-14",15000,"2014-06-14",15000]
[null,null,"FY 14",null,"2014-06-15","FOR",{"$nulls":5},0]
[{"$nulls":4},"2014-08-22",{"$nulls":10},"Final Drainage Report","2014-08-27",9000,"2014-09-05",9000,"2014-10-05",9000]
[{"$nulls":4},"2014-08-25",{"$nulls":10},"Final PWQ Plans","2014-08-27",13000,"2014-09-05",13000,"2015-10-05",13000]
[null,null,"FY15",null,"2014-10-15","AD",225000,75000,28000,925000,350,1253350,50000,30000,1173350,{"$nulls":7},"In-kind is cost of 0.15 acres of permanent easement from Local Agency"]
[{"$nulls":4},"2015-11-01",{"$nulls":6},0,null,null,null,"PWQ Clearing and Grubbing","2015-11-08",20000,"2015-11-13",20000,"2015-12-01",25000,"$5,000 Local Agency contribution"]
[{"$nulls":4},"2015-12-02",{"$nulls":6},0,null,null,null,"PWQ Orifice Plate",null,3000,null,3000]
[{"$nulls":11},0]
[]
[]
[4,23000,"bridge over a river",null,"2013-01-20","Scoping",500000,50000,25000,950000,null,1525000]
[null,null,"CDOT RAMP Project; CDOT paying 75%",null,"2013-03-25","FIR",{"$nulls":5},0]
[null,null,"FY14",null,"2014-06-02","FOR",{"$nulls":5},0]
[null,null,"FY15",null,"2014-12-11","AD",300000,75000,30000,925000,350,1330350,332587.5,null,997762.5,{"$nulls":7},"Cost x 0.75 for CDOT=$ 997,763 to be reimbursed."]
[]
[{"$nulls":22},"Update final costs for reimbursement of 75%"]
["Project Totals",{"$nulls":10},2583700,null,null,2171112.5]