{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Final","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"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":"Final","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[4,6,5,6],[4,7,6,7],[38,0,38,8],[4,9,6,9],[4,10,6,10],[4,11,6,11],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,5,6,5]],"flags":["formulas_cached_only"]}
["Project No.: SPR-2(204)"]
["Project Manager: Terry Halkyard"]
["As of 12-12-12"]
[]
["Final",{"$nulls":5},"Invoiced Amount","Total Expenditures Per State",null,"Actual Expenditure Distribution ","Variance Over/(Under)","Actual Expense % "]
["State","$ Committed on Website","Program Code (e.g., L560)","Originally Obligated","Obligated","Contribution Percentage"]
[null,null,null,"in FMIS","in FMIS",null,1108182.1399999997,null,"UDO"]
["CALIFORNIA",0,"Q560",100000,100000,0.07054673721340388,78178.63421516752,77557.1,22442.899999999994,77557.1,0,0.06998587795323974]
["FLORIDA",0,"Q080",150000,150000,0.10582010582010581,117267.95132275128,116335.64,33664.36,116335.64,0,0.10497880790607222]
["INDIANA",0,"Q550",30000,30000,0.021164021164021163,23453.590264550257,23267.12,6732.880000000001,23267.12,0,0.020995754362184548]
["IOWA",55000,"Q560",25000,25000,0.01763668430335097,19544.65855379188,19389.27,5610.73,19389.27,0,0.017496464976416246]
["KANSAS",0,"Q560",55000,55000,0.03880070546737213,42998.24881834214,42656.41,12343.589999999997,42656.41,0,0.03849223738617554]
["MARYLAND",0,"Q560",15000,15000,0.010582010582010581,11726.795132275129,11633.56,3366.4400000000005,11633.56,0,0.010497877181092274]
["MASSACHUSETTS",0,860,35000,35000,0.024691358024691357,27362.52197530863,27144.98,7855.02,27144.98,0,0.02449505277174022]
["MICHIGAN",0,"Q560",35000,35000,0.024691358024691357,27362.52197530863,27144.98,7855.02,27144.98,0,0.02449505277174022]
["MONTANA",0,"Q560",135000,135000,0.09523809523809523,105541.15619047615,104702.07,30297.929999999993,104702.07,0,0.09448092170119259]
["NEVADA",0,"Q560",87500,87500,0.06172839506172839,68406.30493827158,70999.03,16500.97,70999.03,0,0.06406801502864864]
["NEW HAMPSHIRE",0,"Q560",60000,60000,0.042328042328042326,46907.180529100515,49160.44,10839.559999999998,49160.44,0,0.04436133576381227]
["NEW JERSEY",0,"Q560",5000,163.83,0.003527336860670194,3908.931710758376,163.83,0,163.83,0,0.0001478367085035318]
["NEW YORK",0,"Q560",120000,99244.24,0.08465608465608465,93814.36105820103,99244.24,0,99244.24,0,0.08955589195833821]
["NORTH CAROLINA",0,860,55000,55000,0.03880070546737213,42998.24881834214,42656.41,12343.589999999997,42656.41,0,0.03849223738617554]
["NORTH DAKOTA",0,"Q560",30000,30000,0.021164021164021163,23453.590264550257,23267.12,6732.880000000001,23267.12,0,0.020995754362184548]
["OHIO",0,"Q560",82500,82500,0.0582010582010582,64497.373227513206,65590.03,16909.97,65590.03,0,0.0591870484395282]
["PENNSYLVANIA",0,"Q560",95000,95000,0.06701940035273368,74269.70250440914,75284.65,19715.350000000006,75284.65,0,0.06793526739205526]
["SOUTH CAROLINA",0,"Q560",85000,64769.45,0.059964726631393295,66451.83908289239,64769.45,0,64769.45,0,0.058446574495416445]
["VERMONT",0,"Q560",112500,112500,0.07936507936507936,87950.96349206346,87251.73,25248.270000000004,87251.73,0,0.07873410592955417]
["VIRGINIA",0,"Q560",30000,23262.68,0.021164021164021163,23453.590264550257,23262.68,0,23262.68,0,0.020991747800591702]
["WYOMING",0,"Q560",75000,56701.4,0.05291005291005291,58633.97566137564,56701.4,0,56701.4,0,0.0511661377253382]
["Total",55000,null,1417500,1346641.5999999996,0.9999999999999999,1108182.1399999994,1108182.1399999997,238459.46000000002,1108182.1399999997,0,1.0000000000000004]
[]
["The above spreadsheet should be completed with information with transactions incurred under the Old Pooled Fund procedures (i.e. do not incl transfer information)."]
["If the amount committed on the website does not agree with the amount obligated in FMIS, please explain why"]
[]
[null,"Amount ","Amount",null,"Fund Value ","Fund Value ","Status ","Status "]
["Project #","obligated","Expensed",null,"used - Billing","used - Invoices","per Finance","Per Web site","Lead"]
["SPR-2(204)",{"$nulls":6},"Objectives fulfilled","FHWA"]
[]
["Notes:"]
["AK, GA, WV have different projects with the same study number."]
["NJ, NY, SC & WY closed their study in FMIS before final reclass of expenditures was completed."]

{"sheet":"Sheet3","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}