{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Overview","Commitments","Expenditures","Obligations and Tracking"],"not_rendered":{"charts":0,"images":21,"macros":0,"external_links":1,"defined_names":4,"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":"Overview","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,1,14,4],[15,1,15,4],[16,1,16,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4]],"flags":["formulas_cached_only"]}
["Total Commitments",225000]
["Total Amont Obligated from Total Committed",162500]
["Total Spent of Obligated",61210.5]
["Total Obligated \"Untouched\"",101289.5]
["Available commitments that could eventually add to Obligations ($62.5k) + $25k Tentatively from Indiana in new system",87500]
[]
["State","Summary of Needed Action / Information for each State"]
["Alabama","$17348.69 of H560 funds remain to be transferred into new pooled fund accounting system"]
["California","No funds were spent because committed funds wer not obligated. These entire funds can be transferred over to the new pooled fund accounting system"]
["Illinois","$9,697.38 of \"0860\" funds remain to be transferred into new pooled fund accounting system"]
["Indiana","Please be prepared to commit and obligate 25k into the new pooled fund accounting system"]
["Kansas","We need to determine which accounting code was obligated in which year. It appears funds were succesfully obligated in '06 and '07 but there is not enough information to determine how H550 and H560 were distributed. Nevertheless, what remains to be transfered is a full obligation of $12,500.00 and $4,848.89 remainign from the other obligation"]
["Louisiana","$4,848.69 remains from H550 funds to be transferred into the new pooled fund accounting system"]
["Minnesota","$17,348.69 of H560 funds remain to be transferred into new pooled fund accounting system"]
["New York","$17348.69 of H560 funds remain to be transferred into new pooled fund accounting system"]
["Ohio","$17348.69 of H560 funds remain to be transferred into new pooled fund accounting system"]
["Texas","While no funds were obligated and charged against. There are two commitmentts of 12.5k that can be transferred over into the new pooled fund accounting system."]

{"sheet":"Commitments","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[0,7,0,8],[0,9,1,9],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[0,1,0,2],[0,3,0,4],[0,5,0,6]],"flags":["formulas_cached_only"]}
[null,2005,null,2006,null,2007,null,2008,null,"Total"]
[null,"Amount","Program Code","Amount","Program Code","Amount","Program Code","Amount","Program Code"]
["Alabama",0,"n/a",12500,"H560",12500,"H560",0,"n/a",25000]
["California",0,"n/a",0,"n/a",12500,"Unknown / Unobligated",12500,"Unknown / Unobligated",25000]
["Illinois",0,"n/a",25000,"\"0860\"",0,"n/a",0,"n/a",25000]
["Indiana",0,"n/a",0,"n/a",0,"n/a",0,"n/a",0]
["Kansas",0,"n/a",12500,"Either L550 or L560",12500,"Either L550 or L560",0,"n/a",25000]
["Louisiana",0,"n/a",12500,"One of the two LA commitments is with H550, the other is unknown/unobligated",12500,"One of the two LA commitments is with H550, the other is unknown/unobligated",0,"n/a",25000]
["Minnesota",0,"n/a",12500,"H560",12500,"H560",0,"n/a",25000]
["New York",0,"n/a",12500,"H560",12500,"H560",0,"n/a",25000]
["Ohio",0,"n/a",12500,"H560",12500,"H560",0,"n/a",25000]
["Texas",0,"n/a",12500,"Unknown / Unobligated",12500,"Unknown / Unobligated",0,"n/a",25000]
[]
["Subtotal Commitments",0,null,112500,null,100000,null,12500,null,225000]
[]
["Subtotal Obligations",0,null,100000,null,62500,null,0,null,162500]

{"sheet":"Expenditures","index":2,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,0,40,0],[1,4,1,8],[2,4,2,8],[3,4,3,8],[11,5,40,5],[11,9,40,9]],"flags":["formulas_cached_only"]}
[]
["PR#","Contract (Coop Agmnt)","Task ID#","Date","Accounting Code",{"$nulls":4},"Description","Amount",null,null,"Ependitures","Balance"]
["41-11-00000"," DTFH61-05-H-00002","AU-4 E1 or AU4 - E2 ","2006-07-01","15X0100010.0000.0951000100.9500000000.25305.61006600 TPF-5(127)",{"$nulls":4},"Meetings",30368,null,null,0,30368]
["41-11-00000"," DTFH61-05-H-00002","AU-4 E1 or AU4 - E2 ","2006-07-01","15X0100010.0000.0951000100.9500000000.25305.61006600 TPF-5(127)",{"$nulls":4},"Staff Engineer",30842.5,null,"1st meeting",17688,12680]
[{"$nulls":12},"Addition to Coop.",-4500,17180]
[{"$nulls":9},"Total",61210.5,null,"2nd meeting",17180,0]
[]
[]
[]
[]
["This is from Markview where I can see the inovices for the funds spent on this contract.","Supplier Name","Supplier Site","Invoice Number","Invoice Date","Invoice Amount","Invoice Currency","Payment Number","Payment Date","Payment Amount","Payment Currency","Payment Status","Current Queue"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",1,"2006-02-07","Information Deleted for Privacy - Not all of these are for the CAPT Pooled Fund","USD",507521,"2008-05-13","Information Deleted for Privacy - Not all of these are for the CAPT Pooled Fund","USD","NEGOTIABLE","Archive"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",2,"2008-04-10",null,"USD",507671,"2008-05-14",null,"USD","NEGOTIABLE","Completed"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",1,"2008-03-11",null,"USD",507672,"2008-05-14",null,"USD","NEGOTIABLE","Completed"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",1,"2008-03-10",null,"USD",507271,"2008-05-09",null,"USD","NEGOTIABLE","Archive"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",2,"2008-04-10",null,"USD",507673,"2008-05-14",null,"USD","NEGOTIABLE","Completed"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",3,"2008-04-14",null,"USD",507674,"2008-05-14",null,"USD","NEGOTIABLE","Completed"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",5,"2006-09-11",null,"USD",507522,"2008-05-13",null,"USD","NEGOTIABLE","Archive"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",12,"2007-10-12",null,"USD",507523,"2008-05-13",null,"USD","NEGOTIABLE","Archive"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",13,"2007-11-08",null,"USD",507524,"2008-05-13",null,"USD","NEGOTIABLE","Archive"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",14,"2008-02-08",null,"USD",507272,"2008-05-09",null,"USD","NEGOTIABLE","Archive"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",15,"2008-04-14",null,"USD",507675,"2008-05-14",null,"USD","NEGOTIABLE","Completed"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",2,"2008-03-10",null,"USD",507676,"2008-05-14",null,"USD","NEGOTIABLE","Completed"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121",1,"2006-02-07",null,"USD",495914,"2008-01-16",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121",10,"2007-08-07",null,"USD",482401,"2007-09-05",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","FHWA AUBBURN",11,"2007-09-18",null,"USD",489407,"2007-11-05",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121",5,"2007-05-23",null,"USD",481706,"2007-08-27",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121",7,"2007-05-08",null,"USD",481707,"2007-08-27",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121",8,"2007-06-11",null,"USD",481708,"2007-08-27",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121",9,"2007-07-19",null,"USD",481709,"2007-08-27",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","-AU4CI2","30-APR-2006",null,"USD","432525","12-JUN-2006",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","0-4","06-DEC-2006",null,"USD","456884","19-JAN-2007",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","0000003","04-MAY-2006",null,"USD","440214","16-AUG-2006",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","000003","12-JUN-2006",null,"USD","440215","16-AUG-2006",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","000004","07-JUL-2006",null,"USD","439331","09-AUG-2006",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","00002","26-JUN-2006",null,"USD","440216","16-AUG-2006",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","00003","10-JUL-2006",null,"USD","439332","09-AUG-2006",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","00004","10-JUL-2006",null,"USD","439333","09-AUG-2006",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","00005ADJ2","06-MAR-2008",null,"USD","1019669","06-MAR-2008",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","00006ADJ2","06-MAR-2008",null,"USD","1019669","06-MAR-2008",null,"USD","NEGOTIABLE"]
[null,"AUBURN UNIVERSITY (001)","AUBURN 82121","2-AU4C2","30-APR-2006",null,"USD","432529","12-JUN-2006",null,"USD","NEGOTIABLE"]

{"sheet":"Obligations and Tracking","index":3,"n_rows":176,"n_cols":6,"rows_kept":176,"cut":false,"hidden":false,"merged":[[88,3,89,5]],"flags":["formulas_cached_only"]}
["State:","Entire Project"]
["Program Code:","n/a"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,100000,100000,null,100000]
[2006,null,100000,-30842.5,69157.5,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,100000,-30368,38789.5,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,62500,162500,null,101289.5,"Meetings Held Fall 2006 and Spring 2007"]
[2007,null,162500,0,101289.5]
[2008,0,162500,null,101289.5,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,162500,0,101289.5]
[]
[]
[]
["State:","Alabama"]
["Program Code:","H560"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,12500,12500,null,12500]
[2006,null,12500,-3855.3125,8644.6875,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,12500,-3796,4848.6875,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,12500,25000,null,17348.6875,"Meetings Held Fall 2006 and Spring 2007"]
[2007,null,25000,0,17348.6875]
[2008,0,25000,null,17348.6875,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,25000,0,17348.6875]
[]
[]
[]
["State:","California"]
["Program Code:","unknown"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,0,0,null,0]
[2006,null,0,0,0]
[2006,null,0,0,0]
[2007,0,0,null,0,"Funds committed but not obligated"]
[2007,null,0,0,0]
[2008,0,0,null,0,"Funds committed but not obligated"]
[2008,null,0,0,0]
[]
[]
[]
["State:","Illinois"]
["Program Code:","\"0860\""]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,null,0]
[2006,25000,25000,null,25000]
[2006,null,25000,-7710.625,17289.375,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,25000,-7592,9697.375,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,0,25000,null,9697.375,"Meetings Held Fall 2006 and Spring 2007"]
[2007,null,25000,0,9697.375]
[2008,0,25000,null,9697.375,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,25000,0,9697.375]
[]
[]
[]
["State:","Indiana"]
["Program Code:","n/a"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,0,0,null,0]
[2006,null,0,0,0]
[2006,null,0,0,0]
[2007,0,0,null,0]
[2007,null,0,0,0]
[2008,0,0,null,0]
[2008,null,0,0,0,"It sound like Indiana will be the first State to contribute to the new accounting system. Thanks!"]
[]
[]
[]
["State:","Kansas-(A)"]
["Program Code:","H550"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,null,0]
[2006,12500,12500,null,12500]
[2006,null,12500,-3855.3125,8644.6875,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,12500,-3796,4848.6875,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,null,12500,null,4848.6875,"Meetings Held Fall 2006 and Spring 2007"]
[2007,null,12500,0,4848.6875]
[2008,null,12500,null,4848.6875,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,12500,0,4848.6875]
[]
[null,null,null,"General Comment for Kansas:  It it not known which figure was obligated in 2006. Thus it was assumed H550 was oblligated in 2006 and H560 was obligated in 2007. This needs verification"]
["State:","Kansas-(B)"]
["Program Code:","H560"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,0,0,null,0]
[2006,null,0,0,0,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,0,0,0,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,12500,12500,null,12500,"Meetings Held Fall 2006 and Spring 2007"]
[2007,null,12500,0,12500]
[2008,0,12500,null,12500,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,12500,0,12500]
[]
[]
[]
["State:","Louisiana"]
["Program Code:","H550"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,12500,12500,null,12500]
[2006,null,12500,-3855.3125,8644.6875,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,12500,-3796,4848.6875,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,null,12500,null,4848.6875,"It was assumed that the H550 was obligated in 2006. But there remains an unkown commitment in 2007 that could have been obligated in 2007"]
[2007,null,12500,null,4848.6875]
[2008,null,12500,null,4848.6875,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,12500,null,4848.6875]
[]
[]
[]
["State:","Minnesota"]
["Program Code:","H560"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,12500,12500,null,12500]
[2006,null,12500,-3855.3125,8644.6875,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,12500,-3796,4848.6875,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,12500,25000,null,17348.6875,"Meetings Held Fall 2006 and Spring 2007"]
[2007,null,25000,0,17348.6875]
[2008,null,25000,null,17348.6875,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,25000,0,17348.6875]
[]
[]
[]
["State:","New York"]
["Program Code:","H560"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,12500,12500,null,12500]
[2006,null,12500,-3855.3125,8644.6875,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,12500,-3796,4848.6875,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,12500,25000,null,17348.6875,"Meetings Held Fall 2006 and Spring 2007"]
[2007,null,25000,0,17348.6875]
[2008,null,25000,null,17348.6875,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,25000,0,17348.6875]
[]
[]
[]
["State:","Ohio"]
["Program Code:","H560"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,0,0,null,0]
[2005,null,0,0,0]
[2006,12500,12500,null,12500]
[2006,null,12500,-3855.3125,8644.6875,"Funds put on Cooperative Agreement for Support Staff  - August 2006"]
[2006,null,12500,-3796,4848.6875,"Funds put on Cooperative Agreement for Meeting(s) - July 2006"]
[2007,12500,25000,null,17348.6875,"Meetings Held Fall 2006 and Spring 2007"]
[2007,null,25000,0,17348.6875]
[2008,null,25000,null,17348.6875,"Notification of Pooled Fund Accounting System Reorganization, all funds not sitting on a contract are not to be spent utill transferred into new system"]
[2008,null,25000,0,17348.6875]
[]
[]
[]
["State:","Texas"]
["Program Code:","H560"]
["Year","Contribution by Obligation","Cumulative Contributions by Obligation","Expenditure","Balance","Comment"]
[2005,null,0,null,0]
[2005,null,0,0,0]
[2006,0,0,null,0,"Funds committed but not obligated"]
[2006,null,0,0,0]
[2006,null,0,0,0]
[2007,0,0,null,0,"Funds committed but not obligated"]
[2007,null,0,0,0]
[2008,null,0,null,0]
[2008,null,0,0,0]