{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Application Forecasting Tool","Summary","Tutorial"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Application Forecasting Tool","index":0,"n_rows":64,"n_cols":33,"rows_kept":64,"cut":false,"hidden":false,"merged":[[2,25,9,27],[2,3,9,9],[2,19,7,21]]}
[]
[]
[null,null,null,"Step 1: Enter Your Historic Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Step 2: Enter Your Current Year Data",null,null,null,null,null,"Step 3: Review Projected Applications & Households Served",null,null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raw data to be entered by user"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto-calculated data based on raw data entered by user"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected applications for current year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected households served for current year"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application Approval Rate",1]
[]
[null,null,"Program Week","Application Count\nYear 1","Application Count\nYear 2","Application Count\nYear 3","Application Count\nYear 4","Application Count\nYear 5","Average Application Count",null,"% Total Applications (2016)","% Total Applications (2015)","% Total Applications (2014)","% Total Applications (2013)","% Total Applications (2012)","Average Weekly Percent of Applications","Running Total Percent of Applications",null,null,"Application Count\nCurrent Year","Running Total Applications Year-to-Date\nCurrent Year",null,null,"Projected Applications Year to Date",null,"Total Projected Applications for Current Year","% Total Projected Applications of Total Actual Applications","Total Projected Households Served for Current Year"]
[null,null,"1",null,null,null,null,null,{"$f":"IF(COUNTA(D12:H12)>0, AVERAGE(D12:H12), \"\")","v":""},null,{"$f":"IF(D$64=0,\"\",D12/D$64)","v":""},"","","","",{"$f":"AVERAGE(K12:O12)","v":{"$error":"#DIV/0!"}},{"$f":"P12","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"T12","v":0},null,null,0,null,{"$f":"IF(ISBLANK(T12), \"\", U12/'Application Forecasting Tool'!Q12)","v":""},{"$f":"IF(Z12=\"\", \"\", Z12/$T$64)","v":""},{"$f":"IF(Z12=\"\", \"\", Z12*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,"2",null,null,null,null,null,{"$f":"IF(COUNTA(D13:H13)>0, AVERAGE(D13:H13), \"\")","v":""},null,"","","","","",{"$f":"AVERAGE(K13:O13)","v":{"$error":"#DIV/0!"}},{"$f":"Q12+P13","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(ISBLANK(T13), \"\", U12+T13)","v":""},null,null,{"$f":"IF(Z12=\"\",\"\",Z12*'Application Forecasting Tool'!Q13)","v":""},null,{"$f":"IF(ISBLANK(T13), \"\", U13/'Application Forecasting Tool'!Q13)","v":""},{"$f":"IF(Z13=\"\", \"\", Z13/$T$64)","v":""},{"$f":"IF(Z13=\"\", \"\", Z13*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,3,null,null,null,null,null,{"$f":"IF(COUNTA(D14:H14)>0, AVERAGE(D14:H14), \"\")","v":""},null,{"$f":"IF(D$64=0,\"\",D14/D$64)","v":""},{"$f":"IF(E$64=0,\"\",E14/E$64)","v":""},{"$f":"IF(F$64=0,\"\",F14/F$64)","v":""},{"$f":"IF(G$64=0,\"\",G14/G$64)","v":""},{"$f":"IF(H$64=0,\"\",H14/H$64)","v":""},{"$f":"AVERAGE(K14:O14)","v":{"$error":"#DIV/0!"}},{"$f":"Q13+P14","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(ISBLANK(T14), \"\", U13+T14)","v":""},null,null,{"$f":"IF(Z13=\"\",\"\",Z13*'Application Forecasting Tool'!Q14)","v":""},null,{"$f":"IF(ISBLANK(T14), \"\", U14/'Application Forecasting Tool'!Q14)","v":""},{"$f":"IF(Z14=\"\", \"\", Z14/$T$64)","v":""},{"$f":"IF(Z14=\"\", \"\", Z14*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,4,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$f":"Q14+P15","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(ISBLANK(T15), \"\", U14+T15)","v":""},null,null,{"$f":"IF(Z14=\"\",\"\",Z14*'Application Forecasting Tool'!Q15)","v":""},null,{"$f":"IF(ISBLANK(T15), \"\", U15/'Application Forecasting Tool'!Q15)","v":""},{"$f":"IF(Z15=\"\", \"\", Z15/$T$64)","v":""},{"$f":"IF(Z15=\"\", \"\", Z15*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,5,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z15=\"\",\"\",Z15*'Application Forecasting Tool'!Q16)","v":""},null,{"$f":"IF(ISBLANK(T16), \"\", U16/'Application Forecasting Tool'!Q16)","v":""},"",{"$f":"IF(Z16=\"\", \"\", Z16*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,6,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z16=\"\",\"\",Z16*'Application Forecasting Tool'!Q17)","v":""},null,{"$f":"IF(ISBLANK(T17), \"\", U17/'Application Forecasting Tool'!Q17)","v":""},"",{"$f":"IF(Z17=\"\", \"\", Z17*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,7,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z17=\"\",\"\",Z17*'Application Forecasting Tool'!Q18)","v":""},null,{"$f":"IF(ISBLANK(T18), \"\", U18/'Application Forecasting Tool'!Q18)","v":""},"",{"$f":"IF(Z18=\"\", \"\", Z18*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,8,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z18=\"\",\"\",Z18*'Application Forecasting Tool'!Q19)","v":""},null,{"$f":"IF(ISBLANK(T19), \"\", U19/'Application Forecasting Tool'!Q19)","v":""},"",{"$f":"IF(Z19=\"\", \"\", Z19*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,9,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z19=\"\",\"\",Z19*'Application Forecasting Tool'!Q20)","v":""},null,{"$f":"IF(ISBLANK(T20), \"\", U20/'Application Forecasting Tool'!Q20)","v":""},"",{"$f":"IF(Z20=\"\", \"\", Z20*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,10,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z20=\"\",\"\",Z20*'Application Forecasting Tool'!Q21)","v":""},null,{"$f":"IF(ISBLANK(T21), \"\", U21/'Application Forecasting Tool'!Q21)","v":""},"",{"$f":"IF(Z21=\"\", \"\", Z21*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,11,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z21=\"\",\"\",Z21*'Application Forecasting Tool'!Q22)","v":""},null,{"$f":"IF(ISBLANK(T22), \"\", U22/'Application Forecasting Tool'!Q22)","v":""},"",{"$f":"IF(Z22=\"\", \"\", Z22*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,12,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z22=\"\",\"\",Z22*'Application Forecasting Tool'!Q23)","v":""},null,{"$f":"IF(ISBLANK(T23), \"\", U23/'Application Forecasting Tool'!Q23)","v":""},"",{"$f":"IF(Z23=\"\", \"\", Z23*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,13,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z23=\"\",\"\",Z23*'Application Forecasting Tool'!Q24)","v":""},null,{"$f":"IF(ISBLANK(T24), \"\", U24/'Application Forecasting Tool'!Q24)","v":""},"",{"$f":"IF(Z24=\"\", \"\", Z24*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,14,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z24=\"\",\"\",Z24*'Application Forecasting Tool'!Q25)","v":""},null,{"$f":"IF(ISBLANK(T25), \"\", U25/'Application Forecasting Tool'!Q25)","v":""},"",{"$f":"IF(Z25=\"\", \"\", Z25*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,15,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z25=\"\",\"\",Z25*'Application Forecasting Tool'!Q26)","v":""},null,{"$f":"IF(ISBLANK(T26), \"\", U26/'Application Forecasting Tool'!Q26)","v":""},"",{"$f":"IF(Z26=\"\", \"\", Z26*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,16,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z26=\"\",\"\",Z26*'Application Forecasting Tool'!Q27)","v":""},null,{"$f":"IF(ISBLANK(T27), \"\", U27/'Application Forecasting Tool'!Q27)","v":""},"",{"$f":"IF(Z27=\"\", \"\", Z27*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,17,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z27=\"\",\"\",Z27*'Application Forecasting Tool'!Q28)","v":""},null,{"$f":"IF(ISBLANK(T28), \"\", U28/'Application Forecasting Tool'!Q28)","v":""},"",{"$f":"IF(Z28=\"\", \"\", Z28*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,18,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z28=\"\",\"\",Z28*'Application Forecasting Tool'!Q29)","v":""},null,{"$f":"IF(ISBLANK(T29), \"\", U29/'Application Forecasting Tool'!Q29)","v":""},"",{"$f":"IF(Z29=\"\", \"\", Z29*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,19,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z29=\"\",\"\",Z29*'Application Forecasting Tool'!Q30)","v":""},null,{"$f":"IF(ISBLANK(T30), \"\", U30/'Application Forecasting Tool'!Q30)","v":""},"",{"$f":"IF(Z30=\"\", \"\", Z30*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,20,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z30=\"\",\"\",Z30*'Application Forecasting Tool'!Q31)","v":""},null,{"$f":"IF(ISBLANK(T31), \"\", U31/'Application Forecasting Tool'!Q31)","v":""},"",{"$f":"IF(Z31=\"\", \"\", Z31*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,21,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z31=\"\",\"\",Z31*'Application Forecasting Tool'!Q32)","v":""},null,{"$f":"IF(ISBLANK(T32), \"\", U32/'Application Forecasting Tool'!Q32)","v":""},"",{"$f":"IF(Z32=\"\", \"\", Z32*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,22,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z32=\"\",\"\",Z32*'Application Forecasting Tool'!Q33)","v":""},null,{"$f":"IF(ISBLANK(T33), \"\", U33/'Application Forecasting Tool'!Q33)","v":""},"",{"$f":"IF(Z33=\"\", \"\", Z33*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,23,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z33=\"\",\"\",Z33*'Application Forecasting Tool'!Q34)","v":""},null,{"$f":"IF(ISBLANK(T34), \"\", U34/'Application Forecasting Tool'!Q34)","v":""},"",{"$f":"IF(Z34=\"\", \"\", Z34*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,24,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z34=\"\",\"\",Z34*'Application Forecasting Tool'!Q35)","v":""},null,{"$f":"IF(ISBLANK(T35), \"\", U35/'Application Forecasting Tool'!Q35)","v":""},"",{"$f":"IF(Z35=\"\", \"\", Z35*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,25,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z35=\"\",\"\",Z35*'Application Forecasting Tool'!Q36)","v":""},null,{"$f":"IF(ISBLANK(T36), \"\", U36/'Application Forecasting Tool'!Q36)","v":""},"",{"$f":"IF(Z36=\"\", \"\", Z36*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,26,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z36=\"\",\"\",Z36*'Application Forecasting Tool'!Q37)","v":""},null,{"$f":"IF(ISBLANK(T37), \"\", U37/'Application Forecasting Tool'!Q37)","v":""},"",{"$f":"IF(Z37=\"\", \"\", Z37*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,27,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z37=\"\",\"\",Z37*'Application Forecasting Tool'!Q38)","v":""},null,{"$f":"IF(ISBLANK(T38), \"\", U38/'Application Forecasting Tool'!Q38)","v":""},"",{"$f":"IF(Z38=\"\", \"\", Z38*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,28,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z38=\"\",\"\",Z38*'Application Forecasting Tool'!Q39)","v":""},null,{"$f":"IF(ISBLANK(T39), \"\", U39/'Application Forecasting Tool'!Q39)","v":""},"",{"$f":"IF(Z39=\"\", \"\", Z39*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,29,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z39=\"\",\"\",Z39*'Application Forecasting Tool'!Q40)","v":""},null,{"$f":"IF(ISBLANK(T40), \"\", U40/'Application Forecasting Tool'!Q40)","v":""},"",{"$f":"IF(Z40=\"\", \"\", Z40*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,30,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z40=\"\",\"\",Z40*'Application Forecasting Tool'!Q41)","v":""},null,{"$f":"IF(ISBLANK(T41), \"\", U41/'Application Forecasting Tool'!Q41)","v":""},"",{"$f":"IF(Z41=\"\", \"\", Z41*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,31,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z41=\"\",\"\",Z41*'Application Forecasting Tool'!Q42)","v":""},null,{"$f":"IF(ISBLANK(T42), \"\", U42/'Application Forecasting Tool'!Q42)","v":""},"",{"$f":"IF(Z42=\"\", \"\", Z42*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,32,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z42=\"\",\"\",Z42*'Application Forecasting Tool'!Q43)","v":""},null,{"$f":"IF(ISBLANK(T43), \"\", U43/'Application Forecasting Tool'!Q43)","v":""},"",{"$f":"IF(Z43=\"\", \"\", Z43*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,33,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z43=\"\",\"\",Z43*'Application Forecasting Tool'!Q44)","v":""},null,{"$f":"IF(ISBLANK(T44), \"\", U44/'Application Forecasting Tool'!Q44)","v":""},"",{"$f":"IF(Z44=\"\", \"\", Z44*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,34,null,null,null,null,null,"",null,"","","","","",{"$f":"AVERAGE(K45:O45)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z44=\"\",\"\",Z44*'Application Forecasting Tool'!Q45)","v":""},null,{"$f":"IF(ISBLANK(T45), \"\", U45/'Application Forecasting Tool'!Q45)","v":""},"",{"$f":"IF(Z45=\"\", \"\", Z45*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,35,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$f":"Q45+P46","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(ISBLANK(T46), \"\", U45+T46)","v":""},null,null,{"$f":"IF(Z45=\"\",\"\",Z45*'Application Forecasting Tool'!Q46)","v":""},null,{"$f":"IF(ISBLANK(T46), \"\", U46/'Application Forecasting Tool'!Q46)","v":""},"",{"$f":"IF(Z46=\"\", \"\", Z46*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,36,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z46=\"\",\"\",Z46*'Application Forecasting Tool'!Q47)","v":""},null,{"$f":"IF(ISBLANK(T47), \"\", U47/'Application Forecasting Tool'!Q47)","v":""},"",{"$f":"IF(Z47=\"\", \"\", Z47*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,37,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z47=\"\",\"\",Z47*'Application Forecasting Tool'!Q48)","v":""},null,{"$f":"IF(ISBLANK(T48), \"\", U48/'Application Forecasting Tool'!Q48)","v":""},"",{"$f":"IF(Z48=\"\", \"\", Z48*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,38,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z48=\"\",\"\",Z48*'Application Forecasting Tool'!Q49)","v":""},null,{"$f":"IF(ISBLANK(T49), \"\", U49/'Application Forecasting Tool'!Q49)","v":""},"",{"$f":"IF(Z49=\"\", \"\", Z49*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,39,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z49=\"\",\"\",Z49*'Application Forecasting Tool'!Q50)","v":""},null,{"$f":"IF(ISBLANK(T50), \"\", U50/'Application Forecasting Tool'!Q50)","v":""},"",{"$f":"IF(Z50=\"\", \"\", Z50*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,40,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z50=\"\",\"\",Z50*'Application Forecasting Tool'!Q51)","v":""},null,{"$f":"IF(ISBLANK(T51), \"\", U51/'Application Forecasting Tool'!Q51)","v":""},"",{"$f":"IF(Z51=\"\", \"\", Z51*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,41,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z51=\"\",\"\",Z51*'Application Forecasting Tool'!Q52)","v":""},null,{"$f":"IF(ISBLANK(T52), \"\", U52/'Application Forecasting Tool'!Q52)","v":""},"",{"$f":"IF(Z52=\"\", \"\", Z52*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,42,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z52=\"\",\"\",Z52*'Application Forecasting Tool'!Q53)","v":""},null,{"$f":"IF(ISBLANK(T53), \"\", U53/'Application Forecasting Tool'!Q53)","v":""},"",{"$f":"IF(Z53=\"\", \"\", Z53*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,43,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z53=\"\",\"\",Z53*'Application Forecasting Tool'!Q54)","v":""},null,{"$f":"IF(ISBLANK(T54), \"\", U54/'Application Forecasting Tool'!Q54)","v":""},"",{"$f":"IF(Z54=\"\", \"\", Z54*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,44,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z54=\"\",\"\",Z54*'Application Forecasting Tool'!Q55)","v":""},null,{"$f":"IF(ISBLANK(T55), \"\", U55/'Application Forecasting Tool'!Q55)","v":""},"",{"$f":"IF(Z55=\"\", \"\", Z55*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,45,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z55=\"\",\"\",Z55*'Application Forecasting Tool'!Q56)","v":""},null,{"$f":"IF(ISBLANK(T56), \"\", U56/'Application Forecasting Tool'!Q56)","v":""},"",{"$f":"IF(Z56=\"\", \"\", Z56*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,46,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z56=\"\",\"\",Z56*'Application Forecasting Tool'!Q57)","v":""},null,{"$f":"IF(ISBLANK(T57), \"\", U57/'Application Forecasting Tool'!Q57)","v":""},"",{"$f":"IF(Z57=\"\", \"\", Z57*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,47,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z57=\"\",\"\",Z57*'Application Forecasting Tool'!Q58)","v":""},null,{"$f":"IF(ISBLANK(T58), \"\", U58/'Application Forecasting Tool'!Q58)","v":""},"",{"$f":"IF(Z58=\"\", \"\", Z58*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,48,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z58=\"\",\"\",Z58*'Application Forecasting Tool'!Q59)","v":""},null,{"$f":"IF(ISBLANK(T59), \"\", U59/'Application Forecasting Tool'!Q59)","v":""},"",{"$f":"IF(Z59=\"\", \"\", Z59*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,49,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z59=\"\",\"\",Z59*'Application Forecasting Tool'!Q60)","v":""},null,{"$f":"IF(ISBLANK(T60), \"\", U60/'Application Forecasting Tool'!Q60)","v":""},"",{"$f":"IF(Z60=\"\", \"\", Z60*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,50,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z60=\"\",\"\",Z60*'Application Forecasting Tool'!Q61)","v":""},null,{"$f":"IF(ISBLANK(T61), \"\", U61/'Application Forecasting Tool'!Q61)","v":""},"",{"$f":"IF(Z61=\"\", \"\", Z61*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,51,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z61=\"\",\"\",Z61*'Application Forecasting Tool'!Q62)","v":""},null,{"$f":"IF(ISBLANK(T62), \"\", U62/'Application Forecasting Tool'!Q62)","v":""},"",{"$f":"IF(Z62=\"\", \"\", Z62*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,52,null,null,null,null,null,"",null,"","","","","",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"",null,null,{"$f":"IF(Z62=\"\",\"\",Z62*'Application Forecasting Tool'!Q63)","v":""},null,{"$f":"IF(ISBLANK(T63), \"\", U63/'Application Forecasting Tool'!Q63)","v":""},"",{"$f":"IF(Z63=\"\", \"\", Z63*'Application Forecasting Tool'!$U$9)","v":""}]
[null,null,"Total",{"$f":"SUM(D12:D63)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T12:T63)","v":0},{"$f":"LOOKUP(2,1/(ISNUMBER(U12:U$63)),U12:U$63)","v":0},null,null,{"$f":"LOOKUP(2,1/(ISNUMBER(X12:X$63)),X12:X$63)","v":0},null,{"$f":"LOOKUP(2,1/(ISNUMBER(Z12:Z$63)),Z12:Z$63)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(2,1/(ISNUMBER(AB12:AB$63)),AB12:AB$63)","v":{"$error":"#N/A"}}]

{"sheet":"Summary","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,3,4]]}
[]
[]
[]
[null,null,"Application Forecasting Tool - Summary"]
[]
[null,null,"Current Year"]
[null,null,"Total Actual Applications Received to Date for Current Year",null,{"$f":"'Application Forecasting Tool'!T64","v":0}]
[null,null,"Total Projected Applications for Current Year",null,{"$f":"'Application Forecasting Tool'!Z64","v":{"$error":"#N/A"}}]
[null,null,"Total Projected Households Served for Current Year",null,{"$f":"'Application Forecasting Tool'!AB64","v":{"$error":"#N/A"}}]
[]
[null,null,"Historic Values"]
[null,null,"Total Applications Year 1",null,{"$f":"'Application Forecasting Tool'!D64","v":0}]
[null,null,"Total Applications Year 2",null,{"$f":"'Application Forecasting Tool'!E64","v":0}]
[null,null,"Total Applications Year 3",null,{"$f":"'Application Forecasting Tool'!F64","v":0}]
[null,null,"Total Applications Year 4",null,{"$f":"'Application Forecasting Tool'!G64","v":0}]
[null,null,"Total Applications Year 5",null,{"$f":"'Application Forecasting Tool'!H64","v":0}]
[null,null,"Historic Average Total Applications per Year",null,{"$f":"'Application Forecasting Tool'!I64","v":0}]

{"sheet":"Tutorial","index":2,"n_rows":146,"n_cols":3,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Introduction"]
[null,null,"The purpose of the Application Projection Tool is to help LIHEAP grantees predict the number of applications they should anticipate to receive in the next program year."]
[]
[null,null,"To use this tool, you will first need to gather the following information:"]
[null,null,"1.       Historical data on the number of applications you’ve received on a weekly \n         basis for previous years (1 year minimum, 5 years maximum)"]
[null,null,"2.       Current year data on the number of applications received on a weekly basis to \n         date"]
[null,null,"3.       Approval rate for applications (this can be your current approval rate, a \n         historical approval rate, or some other value you anticipate having for the \n         program; the default is 100%)."]
[]
[null,null,"Opening the Application Projection Tool"]
[null,null,"1. When you open the Projection Tool file, you should see three tabs in the lower left hand corner of the Excel file: one named “Application Forecasting Tool”, one named “Summary”, and one named \"Tutorial\". The tab you're on right now is the \"Tutorial\" tab."]
[]
[]
[]
[]
[]
[]
[null,null,"2. Once you've found the three tabs, please navigate to the \"Application Forecasting Tool\" tab. If you’re in the right place, you should see a spreadsheet similar to the one shown in the image below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Entering Data"]
[null,null,"1. The next step is to start inputting your data. On the left side of your screen, you should see the header “Step 1: Enter Your Historic Data” along with six columns underneath it. This is where you will input your historical data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2. Enter one year of data in each column titled “Application Count”. [Note: Make sure that you pay close attention to the “Program Week” column when you’re inputting your data. You want to make sure that the historical data you’re inputting corresponds to the correct week.]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"3. You can include historical data for up to 5 years, but the tool will work with just one year of historical data."]
[]
[null,null,"4. The next step is to input your current year application data under “Step 2: Enter Your Current Year Data”."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"5. First, input the approval rate for applications next to the header “Approval Rate”. As mentioned before, the default is set to 100%."]
[]
[null,null,"6. Next, enter the weekly application counts to-date for the current year under the column titled “Application Count current Year.” [Note: Make sure that you’re paying close attention to the “Program Week” column when you’re inputting your data. As with Step 1, you want to make sure that the current year data you’re inputting corresponds to the correct week.]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Reviewing Analysis Statistics"]
[null,null,"Once you’ve finished inputting your data, you can review the columns under “Step 3: Review Projected Applications & Households Served” for analysis."]
[]
[null,null,"The column titled “Total Projected Applications for Current Year” will give you the number of applications that you can expect to receive for the year based on the historical data you’ve input. The most up to date projection is the last value in that column."]
[]
[null,null,"The column titled “Total Projected Households Served for Current Year” will give you the number of applications that you can expect to approve for the year based on the historical data you’ve input. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Reviewing Summary Statistics"]
[null,null,"After entering your data in the “Application Forecasting Tool” tab, you can navigate to the “Summary” tab to examine the tool’s projections and summary information on historical applications."]
[]
[null,null,"This table summarizes the main results from the application forecasting tool, including total actual applications received, total projected applications, total projected households served, and the historical average of applications received."]