{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Converted Project Data","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"Converted Project Data","index":0,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Midwest States Accelerated Testing Pooled Fund; TPF-5(048); RE-0508-01; C1516 ; C1839"]
["http://www.pooledfund.org/projectdetails.asp?id=413&status=4"]
["Note: Transfers table does not include expenditures (IA=$362,217.07; MO=$392,732.43; NE=$176,826.00; KS=$403,287.95;Total=$1,335,063.45) on project prior to conversion.  See Contracts table below for additonal information."]
["Also does not include $26,582 of MO FY 2005 state funds in project--$21,826.97 spent and $4,755.03 unspent at time of conversion. (See RE-0328-01)"]
[]
["Pledges, Commitment and Transferred Amounts as of 03/31/2010"]
[null,"Pledges",null,"Commitments",{"$nulls":7},"SPR Transfers",{"$nulls":5},"After Conversion Expenditures **"]
[null,"Pledge Totals","#14 FY09","#16 FY09","FY10","FY11","FY12","Commitment Totals","Partner %","Amount Converted","#14 FY09","#16 FY09","FY10","FY11","FY12","Transfer Totals*","Partner %","Partner Share"]
["IA",75000,19501,55499,null,null,null,75000,0.21739130434782608,111266.93,19501,55499,null,null,null,186266.93,0.32253312936662587,76584.30787152053]
["MO",50000,19501,30499,null,null,null,50000,0.14492753623188406,52609.57,19501,30499,null,null,null,102609.57,0.1776750479275299,42188.28806296607]
["NY",60000,0,30000,30000,null,null,60000,0.17391304347826086,0,0,30000,30000,null,null,60000,0.10389384611641772,24669.212469928138]
["KS",100000,19501,80499,60000,null,null,160000,0.463768115942029,68636.05,19501,80499,60000,null,null,228636.05,0.39589797658942644,94004.52159558522]
["Totals",285000,58503,196497,90000,0,0,345000,1,232512.55,58503,196497,90000,null,null,577512.55,1,237446.33]
["* KS completed and planned obligations are shown as transfers"]
["** Total expenditures are unadjusted for fractional amount being charged on each invoice to remaining MODOT state funds"]
["Note: Expenditures (upper limit) remaining  to be made on Experiment Nos. 13 & 14 at time of conversion were $294,206.58",{"$nulls":13},"Date","C1839 Payment","Date","C1516      Payment"]
["Note: Amount needed for experiment no. 16 is $286,000.",{"$nulls":13},"2009-12-24",1048.77,"2009-02-23",8416.5]
["Note: Experiment No. 15 is being funded by PRS and KUTRI.",{"$nulls":13},"2010-02-04",4389.62,"2009-03-20",36414.26]
[{"$nulls":14},"2010-02-16",7059.26,"2009-03-20",126446.07]
[null,"Administrative Contacts",{"$nulls":4},"Contracts Information",{"$nulls":9},"2009-03-20",6472.86]
["IA","Carol Culver (Carol.Culver@DOT.STATE.IA.US)",{"$nulls":4},"Contract No.","KDOT Project No.","Begin Date","Ending Date","Amount",{"$nulls":5},"2009-04-29",18621.24]
["MO","Karmen.Stockman (Karmen.Stockman@modot.gov)",{"$nulls":4},"C1355","RE-0328-01","2002-07-01","2003-06-30",267302,{"$nulls":5},"2009-05-15",11904.79]
["NY","Colin Campbell (ccampbell@dot.state.ny.us)",{"$nulls":4},"C1436","RE-0328-01","2003-09-01","2005-07-01",334930,{"$nulls":5},"2009-06-11",8992.63]
["KS","Rodney Montney (Rodney@ksdot.org)",{"$nulls":4},"C1516","RE-0328-01","2005-04-01","2008-03-31",651849.45,{"$nulls":5},"2010-02-08",1390]
[{"$nulls":6},"Subtotal before conversion",null,null,null,1254081.45,{"$nulls":5},"2010-02-16",1467.74]
[{"$nulls":6},"C1516/N","RE-0508-01","2005-04-01","2008-03-31",232512.55,{"$nulls":5},"2010-03-12",4822.59]
[{"$nulls":6},"C1516 A*","RE-0508-01","2005-04-01","2010-12-31",164503]
[{"$nulls":6},"C1839","RE-0508-01","2009-10-01","2011-03-31",286000]
[{"$nulls":6},"Total",null,null,null,1937097,null,null,null,"Total",12497.65,"Total",224948.68]
[{"$nulls":6},"C1516/N= Funds transferred under new accounting system (tracked under RE-0508-01)",{"$nulls":7},"Combined Total",null,null,237446.33]
[{"$nulls":6},"* Amendment to complete experiment no. 14 "]
[{"$nulls":6},"Note: C1516 amount totals $1,048,865."]
[]
[{"$nulls":7},"FY 2010 Obligations"]
[{"$nulls":7},"Date","Amount"]
[{"$nulls":7},"2009-09-16",30000,"(FY 2009--NY)"]
[{"$nulls":7},"2009-12-22",90000,"(FY 2010--NY & KS)"]
[]
["Q://Research/TPF/TPF-5(048)/TPF-5(048) Funding after conversion.xls"]

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