{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["TPF-5(121)"],"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":"TPF-5(121)","index":0,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Project No.TPF-5(121)"]
["Project Manager: Cynthia Gerst"]
[]
[]
[]
[{"$nulls":7},"Invoiced amt","Total",null,"Actual ","Varience","Actual "]
[null,"$ Committed","Program Code","Obligated","Transferred","Total ","Contribution ","Amount","Expenditures",null,"Expenditure","Over/","Expense"]
["State","on Website","(e.g., L560)a","in FMIS","to Ohio","Obligation","Percentage",1584934.82,"per State","UDO","Distribution","(Under)","%"]
["NEW YORK",null,"H560",200000,null,200000,0.12617269635468153,200000,200000,0,200000,0,0.1261881545387463]
["NEW YORK",null,"L56E",null,100000,100000,0.06308634817734077,100000,100000,0,0,-100000,0]
["NEW YORK",null,"L56E",null,100000,100000,0.06308634817734077,100000,100000,0,0,-100000,0]
["NEW YORK",null,"L560",null,150000,150000,0.09462952226601115,150000,150000,0,0,-150000,0]
["NEW YORK",null,"L560",null,100000,100000,0.06308634817734077,100000,100000,0,0,-100000,0]
["NEW YORK",null,"L560",null,100000,100000,0.06308634817734077,100000,100000,0,0,-100000,0]
["NEW YORK",null,"L560",null,50000,50000,0.031543174088670384,50000,50000,0,0,-50000,0]
["OHIO",null,"L56E",null,-200000,-200000,-0.12617269635468153,-200000,-200000,0,0,200000,0]
["OHIO",null,"H560",402527.95,null,402527.95,0.2539401840481122,402527.95,402527.95,0,402527.95,0,0.2539712958038237]
["OHIO",null,"L560",982601.05,-400000,582601.05,0.3675417268878432,582406.87,582406.87,194.18000000005122,982406.87,400000,0.6198405496574302]
[null,{"$error":"#REF!"},null,1585129,0,1585129,1,1584934.8199999998,1584934.8199999998,194.18000000005122,1584934.8199999998,0,1.0000000000000002]
[]
["The Delphi expenses to be recorded should be those indicated in the Invoiced Amount column."]
["The funds to be released back to the states should be those in the UDO column. "]
[]
["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","Fund Value ",null,null,"Fund Value ","Status ","Status "]
["Project #","obligated","Expensed","used - Billing",null,null,"used - Invoices","per Finance","Per Web site","Lead"]
[{"$nulls":9},"OH"]