{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Part 2 - Calculation Worksheet ","Impact template","Sample impact table","Excess MOE Worksheet"],"not_rendered":{"charts":0,"images":0,"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":"Part 2 - Calculation Worksheet ","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["State?",null,null,"Fiscal Year to which credit applies:         "]
[]
["PART 2 – Estimate of Caseload Reduction Credit"]
[]
["Impact of All Changes",null,null,"Caseload Reduction Calculation "]
[null,null,null,"FY 2005 TANF Caseload"]
[null,null,null,"FY 2005 SSP Caseload"]
[null,null,null,"Total FY 2005 Caseload",0]
[null,null,null,"FY      TANF Caseload"]
[null,null,null,"FY      SSP Caseload"]
[null,null,null,"Total FY      Caseload",0]
[null,null,null,"Excess MOE Cases in FY     ",0]
[null,null,null,"Adjusted FY      Caseload",0]
[null,null,null,"Caseload Decline",0,0]
[null,null,null,"Decline – Net Impact",0]
[]
[{"$nulls":4},"Caseload Reduction Credit =",0]
{"$rows_empty":8}
["Net Impact",0]

{"sheet":"Impact template","index":1,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[""]
["Policy Name"]
[]
[null,"Impact on Each Month in FY ?"]
[null,"Oct","Nov","Dec","Jan","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep"]
["Time of Closure"]
["Prior years carryover"]
["Oct"]
["Nov"]
["Dec"]
["Jan"]
["Feb "]
["Mar"]
["Apr"]
["May"]
["Jun"]
["Jul"]
["Aug"]
["Sep",{"$nulls":12},"Grand"]
[{"$nulls":13},"Total"]
["Total",0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":12},"FY ? monthly average",0]

{"sheet":"Sample impact table","index":2,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Columbia"]
["Impact #3, Full Family Sanction"]
[]
[null,"Impact on Each Month in FY 2007 "]
[null,"Oct","Nov","Dec","Jan","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep"]
["Time of Closure"]
["Prior years carryover",-81,-76,-72,-69,-67,-65,-63,-61,-60,-59,-57,-56]
["Oct",-33,-30,-28,-26,-24,-21,-18,-16,-15,-13,-10,-8]
["Nov",null,-42,-39,-36,-34,-32,-29,-27,-25,-23,-21,-20]
["Dec",null,null,-55,-53,-51,-48,-46,-43,-41,-40,-38,-37]
["Jan",null,null,null,-64,-61,-59,-56,-53,-52,-51,-49,-47]
["Feb ",{"$nulls":4},-27,-25,-25,-24,-24,-24,-22,-21]
["Mar",{"$nulls":5},-22,-20,-20,-20,-19,-18,-18]
["Apr",{"$nulls":6},-16,-16,-12,-11,-11,-11]
["May",{"$nulls":7},-26,-23,-21,-21,-19]
["Jun",{"$nulls":8},-24,-20,-18,-17]
["Jul",{"$nulls":9},-31,-26,-26]
["Aug",{"$nulls":10},-29,-23]
["Sep",{"$nulls":11},-26,"Grand"]
[{"$nulls":13},"Total"]
["Total",-114,-148,-194,-248,-264,-272,-273,-286,-296,-312,-320,-329,-3056]
[]
[{"$nulls":12},"FY 2007 monthly average",-254.66666666666666]

{"sheet":"Excess MOE Worksheet","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["",null,null,null,"Fiscal Year to which credit applies:         ",""]
[]
["Excess MOE Calculation Worksheet"]
[]
["Caseload Data",null,null,"Expenditure Data"]
["FY 2005 TANF Caseload",0,null,"Total Expenditures"]
["FY 2005 SSP Caseload",0,null,"FY     Total Federal Expenditures"]
["Total FY 2005 Caseload",0,null,"FY      Total MOE Expenditures"]
["FY        TANF Caseload",0,null,"Total Expenditures (Federal + MOE)",null,0]
["FY        SSP Caseload",0]
["Total FY         Caseload",0,null,"Assistance Expenditures"]
[null,null,null,"FY      Federal Expenditures on Assistance"]
[null,null,null,"FY      MOE Expenditures on Assistance"]
["Adjusted Caseload Data ",null,null,"Total Expenditures on Assistance (Federal + MOE)",null,0]
["Adjusted FY      Caseload",0,null,"Percentage of Expenditures on Assistance",null,0]
[]
[null,null,null,"Expenditures Per Case"]
[null,null,null,"Average Expenditures per Case",null,0]
[null,null,null,"Average Expenditures per Case on Assistance",null,0]
[]
[null,null,null,"MOE and Excess MOE"]
[null,null,null,"Required MOE (80% or 75%)"]
[null,null,null,"Excess MOE Expenditures",null,0]
[null,null,null,"Excess MOE Expenditures on Assistance",null,0]
[]
[null,null,null,"Assistance Cases Funded by Excess MOE",null,0]