ࡱ> TV  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSWRoot Entry FOjTjUWorkbookSummaryInformation(DocumentSummaryInformation8, \plcm Ba==< 08X@"1Arial1Arial1Arial1Arial1Arial1xArial1Arial1Arial1Arial1Arial1 Arial1Arial1h>JCambria1,>JCalibri1>JCalibri1>JCalibri1JCalibri1JCalibri1<JCalibri1>JCalibri1?JCalibri15JCalibri15JCalibri1 JCalibri1 JCalibri1JCalibri1JCalibri1 JCalibri1JCalibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) m\/d\/yyyy                                                                      ff + ) , *     P  P        `            a2  X!x!|!x)x)x"x#xxx !x X*x )x !|!xx!x)x!| !X !Xx"x X )x||X)}A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef ;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L ;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A}  00\);_(*23;_(@_) }A}! 00\);_(*23 ;_(@_) }A}" 00\);_(*;_(@_) }A}# 00\);_(*;_(@_) }A}$ 00\);_(*;_(@_) }A}% 00\);_(*;_(@_) }A}& 00\);_(*;_(@_) }A}' 00\);_(* ;_(@_) }A}( 00\);_(*;_(@_) }}) }00\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}/ 00\);_(*}A}0 a00\);_(*;_(@_) }A}1 00\);_(*;_(@_) }A}2 00\);_(*?;_(@_) }A}3 00\);_(*23;_(@_) }-}4 00\);_(*}}5 ??v00\);_(*̙;_(@_)    }A}6 }00\);_(*;_(@_) }A}7 e00\);_(*;_(@_) }x}800\);_(*;_(  }}9 ???00\);_(*;_(??? ???  ??? ???}-}; 00\);_(*}U}< 00\);_(*;_( }-}= 00\);_(* 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L湸 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ٗ % 60% - Accent3M( 60% - Accent3 23֚ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight168f3fff̙̙3f3ff3f3f33333f33333\``N Data check]Entry Exit Data checkqServices Data checkHPRP Exit DataPt Start dateEnd dateGrant Start Date-DATA QUALITY ISSUES IDENTIFIED IN THIS REPORTABClients with no Housing Status recorded (at time of program entry)BSClients without Program Entry (during specified date range by a specified provider)COClients without a Service Transaction (while enrolled with specified provider) DIClients without an HPRP Service Activity (for one or more valid services)E4Clients with an Non-HPRP Program Entry Type recordedFQClients which have one or more HPRP Type Program Entry before start date of GrantGOClients which have one or more HPRP Service Activity before start date of GrantHnClients which have one or more Services with both a Financial and a Non-financial HPRP Activity Type indicatedIFor exited clients: Must have HPRP Entry type, service transaction for HPRP provider, HPRP service activity (No errors on E, C and D)Note Clients with data entry problems in columns A through E will not show up on the quarterly report. Each of these columns highlight these problems for you to correct. Blanks indicate data entry is correct. Problematic data along with additional data are shown on the other sections of this data check report. All data should be fixed by the time of the quarterly report due date. You will know the clients listed below will be on the quarterly report if all columns are blank. Column "I" applies only to exited clients. Client Uid First Name Last NameC & DTesty Testerson%Service Start date Before Grant StartokTestMissing Housing StatusHas Entry,no serviceNo HPRP ServicesHprp MinnesotaBrett'Will not be included in report outcomesMauerBarakObamaMichelleSashaMaliaPercival PreventionNon-HPRP Entry TypeRebecca RehousingRonnie Test HPRP 1Couple Anonymous ZZ000325054#Entry Exits by Client and HouseholdCritical Errors - NoteMissing Housing Status ("A") or Housing Status = "Don't know" or "refused" will cause the client to be excluded from the HPRP Quarterly Counting Report.UEntry Type ("E") must be "HPRP" to be included in the HPRP Quarterly Counting Report.Client Unique ID: Used to count clients in the HPRP Quarterly Counting Report. The field is based on client name,date of birth, and other demographic information. It can be used to unduplicate clients served by other programs receiving HPRP and included in the Grantee report. Please make sure that you have completely and correctly entered demographic information for a client. 5Correct data entry on a number of variables is needed for clients to show up on the HPRP Quarterly Counting Report. The "Data Check" tab highlights these issues more completely. Also below, columns "A" and "E" highlight key fields that need to be entered. Many fields are required for ALL HOUSEHOLD MEMBERS!Wilder Research Center-HPRP(2139)ID2Client Unique IdHead E -Entry Type Entry Date Exit DateA -Housing Statusttsm01011961t230t236HPRP*Housed and at-risk of losing housing (HUD)tts 00000000t230t230 Missinghmnf06121967h161m523Literally Homeless (HUD)bmnm08251964b630m523mmnf06161991m600m523boam05121950b620o1503Housed and at imminent risk of losing housing (HUD)moa 09252002m400o150moaf06181960m240o150soaf08182000s200o150rrhf12311977r120r252rrhm05052005r500r252tcuf07121980t230c140azz000325054zzzzzzzzppem08251960p621p615Basic Entry/Exit&Services - by individual and householdHPRP Services and Service Start and End dates are needed for all household members to be counted on the HPRP Quarterly Counting Report. Please make sure all clients have a HPRP Service or they will not be counted on the HPRP Quarterly Counting Report. The Service start date can't be before the Grant Start date. Please see Data Check tab for clients not included on the quarerly report because of missing or problematic data entry. Service UidService Start DateService End Date&Service HPRP Financial Assistance Type@Service HPRP Housing Relocation & Stabilization Service ProvidedCase managementRental assistanceDouble Service ActivitySecurity depositsUtility paymentsCount:Exited ClientsFor exited clients only: Must have HPRP Entry type, service transaction for HPRP provider, HPRP service activity (No errors on B, C and D) to be reported. Entry TypeHousing Status at ExitReason Leaving DestinationCompleted programJTransitional housing for homeless persons (including homeless youth) (HUD)Stably housed (HUD)8Rental by client, other (non-VASH) housing subsidy (HUD)ColumnzI. G/ 0C3Z44455]9s %: : ;q =>?cc PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!ÄA theme/theme/theme1.xmlYOoE#F{oc'NjGuرhF[xw;23NjHH q　Jĥ|@_73xM6{o~(fIyWk"޽aJCR$'Mnlu"^T$}*OIB.bQn̖kC 0>ACMȉ<&J &M5BNe tY>?#!mfKx=[Ԃu}ˆ ~umoLz^W/}ةLo;9iwk/_tV[,ac߬56YvYp1ϡAz 9ۮ7ެe ."Zk1~EȰ RӔ/x$( :7vʗsSj{"bF^x^xz?>~,ɸ7Gg_zy5^|?}V I򋧿>O~I|SQ>19D{<Ÿ8ߊaG@tOE*\ʻ/ yToN:"1Q(v; y4<$jbRa|PŻǴI Y3wJG݈8b2(<& QHT^w/B(`Z!94[Mc˴j`jG7;Q]o YC5*CocU 9 IQ/ RV+`%*;æWѼ9/#~7qZ$*cߓrUngN>%OOi Dh[BvoLJƌB6>p&>w O]>_x.eywQ,5,^<ؾt&9 ԔEЇIIqhJ#f6kAS&2D)p3ӕ5teO`jvzEOG)9cshger-# ~fu-ԙՍh&9܊- 6 AлY3hX"M$#Fz6#b.w*lyhĭɾ̮]nR3+=,)'Kak.zi X 8Ka6!_ 5[ M܆< kW Ds/Z/j@&8?&5- C⫲K3Zw1K|D!`~J0A?Uֶy&,Xg1K#[y$[BTV)bBRvVt=낕@[\׶Dž8d4~_@`rx \kp*O69mY&ԧ HE]HKN!Vj%2BƣJԊ=" u\ӵC&Y0>g4&oN)j rihr"VTU,koy#ŬjQJpRk3܎Ws;ɢ!JT~u "֠ۀW_ Nq֙4)ڬuZˋw֒TvќXHegvtm,{2Da*20V=CoOQ2'@C8D.IrG[Ȥiࠆ)d͛|?&f9>b|w##(ɇ"C *_p=ce΂aenv*Wm瓗{varAˇ$IDpKs6* ʢG0egAnlCYt֏$Ysă)2|FS` uz'Xr*󠍒F`Bi m/Ҷj9Xrmox86tFo˜ b`>ASDbƟPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!ÄA theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]   #zO[\  dMbP?_*+%&?'?(`_____?)`_____?"dXXQPPPPP?QPPPPP?&TPU} }  } } $} I} } }  $ } } m } #  > h> h> > h> h> h> h> h>  h>  h>  h>  h>  h> K> h> > > > > > h> > > h> h> h> h> > h> > h> ? OO OO@^rQsQ~ Q^rQ ?s OOOOOOOOOO A MMMMMMMMMM A MMMMMMMMMM A M MMMMMMMMM A M MMMMMMMMM A M  MMMMMMMMM A M MMMMMMMMM A M MMMMMMMMM A M MMMMMMMMM A M MMMMMMMMM OOOOOOOOOOO PPPPPPPPPPP ? C OO ? D D D  D  D  D  D~ E A MMBBBBB  B B  B~ E A MM B! B" B#BBBBB ~ EV A$ M%MBBBBBBB  B~ Ef A& M% MB B" B#BBBB  B'~ En A( M% MB B" B#BBBB  B'~ EN A) M*MBBBBBBB  B~ ER A+ M*MBBBBBBB  B~ EZ A, M*MBBBBBBB  B~ Eb A- M*MBBBBBBB  B~ E A. M/ MB B" B# B0 BBBB ~ E A1 M2MBBBBBBBB ~ E A3 M2M B!BBBBBBB ~ E A4 M5MBBBBBBBB D l>88888888888,,frRttRRRRtFZ  h>! h>" 7>~ E A6 M7 MBBBBBBBB ~ !F:!GNNGGGGGGGG (F.>@GB              !!ggD  -^l q  dMbP?_*+%&?'?(`_____?)`_____?"dXXQPPPPP?QPPPPP?&TPU} }  } } m } m} I } }  } } $-  > h> J> h> h> h> > > >  h>  ,>  h>  h>  h> h> h> h> h> h> h> h> h> h> h> h> h> h> h> h> h> h> h> S8 SSS O9OOOOOOOOO M:MMMMMMMMM M;MMMMMMMMM P<PPPPPPPPP P=PPPPPPPPP R> RRRRR ?? ?@ ? ?A ? ? ?B ?C ?D ?E~ Er! AF~ E A A A AG @a `@ @a `@ AH E AI~ E AJ A A AG @a `@ @ HK~ Fr!GFGGGGGFF IIIIIIIIII ?? ?@ ? ?A ? ? ?B ?C  ?D  ?E~ E AL~ EV A A$ A% AG@l@ @ls@  AME AN~ Ef AJ A& A% AG@l@ @ls@  AME AO~ En AJ A( A% AG@l@ @ls@  AM~ FGFGGGGGFF IIIIIIIIII ?? ?@ ? ?A ? ? ?B ?C  ?D  ?E~ E AP~ EN A A) A* AG@Ӗ@ @[՗@  AQE AR~ Eb AJ A- A* AG@Ӗ@ @[՗@  AQE AS~ ER AJ A+ A* AG@Ӗ@ @[՗@  AQE AT~ EZ AJ A, A* AG@Ӗ@ @[՗@  AQ~ FGFGGGGGFF IIIIIIIIII ?? ?@ ? ?A ? ? ?B ?C  ?D  ?E~ EB AU~ E A A1 A2 AG@POO@ @  AME AV~ E AJ A3 A2 AG@POO@ @  HKD l*****"***  h>! h>" h># h>$ h>% h>& h>' h>( h>) h>* h>+ h>, >~ FB GFGGGGGFF !IIIIIIIIII "?? "?@ "? "?A "? "? "?B "?C " ?D " ?E~ #E #AW~ #E #A #A4 #A5 #AG#@ ` 3@# @ # AQ$E $AX~ $E $AJ $A6 $A7 $AG$@ ` 3@$ @ $ AQ~ %F%GFGGGGGFF &IIIIIIIIII '?? '?@ '? '?A '? '? '?B '?C ' ?D ' ?E~ (E (AY~ (E (A (A. (A/ (HZ(@[@( @ ( AH~ )F)GFGGGGGFF *IIIIIIIIII +FF:+FGGGGGFF ***0>@GB:      ggD  2r  dMbP?_*+%&?'?(`_____?)`_____?"dXXQPPPPP?QPPPPP?&TPU} $}  } m} m } I} } $ }  }  } } } $} } I2  > h> ;> h> > > W> h> ,>  S>  h>  >  h>  > > h> h> S> h> h> h> h> h> h> h> h> h> h> S> h> h> h> S[ SS OOOOOOOOOOOO P\PPPPPPPPPPP P]PPPPPPPPPPP R>RRRRR C? ?@ ? ?A ? ? C^ C_ C` Ca Cb J~ E AF~ E A A A~ Ev)P @'}.@ @A Ac K E AF~ E A A A~ EVQ LO{@ @ Ad Ac Ke E AF~ E A A A~ EVQ L{@ @ Ad AK  E AF~ E A A A~ E"R @B@ @ Ad Ac KeE AF~ E A A A~ ER@T@ @  Ad  Ac  Ke~ FGGGGGGGFGGG IIIIIIIIIIII C? ?@ ? ?A ? ? C^ C_  C`  Ca  Cb  J~ E AP~ EN A A) A*~ E>R@Ֆ@ @u@  Ad  AK E AP~ EN A A) A*~ E>R@Ֆ@~  @p@ A  Ac KE AR~ Eb AJ A- A*~ E>R@Ֆ@ @u@  Ad  AK E AR~ Eb AJ A- A*~ E>R@Ֆ@~  @p@ A  Ac KE AS~ ER AJ A+ A*~ E>R@Ֆ@ @u@  Ad  AK E AS~ ER AJ A+ A*~ E>R@Ֆ@~  @p@ A  Ac KE AT~ EZ AJ A, A*~ E>R@Ֆ@ @u@  Ad  AK E AT~ EZ AJ A, A*~ E>R@Ֆ@~  @p@ A  Ac K~ FGGGGGGGFGGG IIIIIIIIIIII C? ?@ ? ?A ? ? C^ C_  C`  Ca  Cb  J~ EB AU~ E A A1 A2~ ES@llo@ @llo@  Af  AK E AU~ E A A1 A2~ E S@llO@  @A  Ac KE AU~ E A A1 A2~ ES@llϖ@ @ll/@  Ad  AK Dl..."."."  h>! h>" h># h>$ h>% S>& h>' h>( h>) h>* S>+ h>, h>- h>. h>/ h>0 h>1 > E AV~ E AJ A3 A2~ ES @llo@ @llo@ Af AK !E !AV~ !E !AJ !A3 !A2~ !ES!@llO@ ! @A ! Ac! K"E "AV~ "E "AJ "A3 "A2~ "ES"@llϖ@" @ll/@ " Ad " AK ~ #F#GGGGGGGFGGG $IIIIIIIIIIII %C? %?@ %? %?A %? %? %C^ %C_ % C` % Ca % Cb % J~ &E &AW~ &E &A &A4 &A5~ &EjS&@.؂-3@ & @A & Ac& K'E 'AX~ 'E 'AJ 'A6 'A7~ 'EfS'@.؂-3@ ' @A ' Ac' K~ (F(GGGGGGGFGGG )IIIIIIIIIIII *C? *?@ *? *?A *? *? *C^ *C_ * C` * Ca * Cb * J~ +E_g +AL~ +EV +A +A$ +A%~ +EN+@(}'@+ @(}'t@ + Ad + AK ,E ,AL~ ,EV ,A ,A$ ,A%~ ,EN,@(}'@ , @A , Ac, K-E -AL~ -EV -A -A$ -A%~ -EN-@(}'@- @(}'@ - Ag - AK ~ .F.GGGGGGGFGGG /IIIIIIIIIIII 0FF*F*0GGGGG 0 Fh0 FF 0 G(T."."."^>@FB*   ggD  "Оl  dMbP?_*+%&?'?(`_____?)`_____?"dXXQPPPPP?QPPPPP?&TPU} } I } $ } m} }  }  }  }  } $ } I } m} } } ">h>h>>>>h>h>> > > > h> h>>S>S>S>S>h>h>h>9>h>h>h>h>h>h>h>h>h> OiOOOOOOOOOOO MjMMMMMMMMMMM ?? ? O@O ? ? ?k ?D  Cl  Cm  On O  JEr!E MFM A A AG@a `@  BH  KK  WK W  BFr!FTTGGGGGGNNG IIVVIIIIIIVVI ?? ? O@O ? ? ?k ?D  Cl  Cm  On O  J EEV ML M A$ A% AG @ls@ BM Bo Pp P B E~ Ef MN M A& A% AG @ls@ BM Bo Pp P B' E~ En MO M A( A% AG @ls@ BM Bo Pp P B' FFT TGGGGGGNNG IIVVIIIIIIVVI ?? ? O@O ? ? ?k ?D  Cl  Cm  On O  JEEN MPM A) A* AG@[՗@  Bq  Bo  Pr P  BE~ ER MSM A+ A* AG@[՗@  Bq  Bo  Pr P  BE~ EZ MTM A, A* AG@[՗@  Bq  Bo  Pr P  BE~ Eb MRM A- A* AG@[՗@  Bq  Bo  Pr P  BFFTTGGGGGGNNG IIVVIIIIIIVVI FF"T"TGGGGGGNNG ? UU UU U U UD U  U U~ EMMMMMMQa `@ Q  M M~ EVMMMMMMQls@ Q  M M~ ENMMMMMMQ[՗@ Q  M M~ ERMMMMMMQ[՗@ Q  M M~ EZMMMMMMQ[՗@ Q  M M~ EbMMMMMMQ[՗@ Q  M M~ Ef MM M# MMMQls@ Q  M' M~ En MM M# MMMQls@ Q  M' MDl..:$:$:$:XXXXXXn  h>! 7>~ F" NNNNNNNNNN T,>@NJX                                          ggD  Oh+'0d08 D P\lcm@RHi@TTj՜.+,0HP X`hp x   Data checkEntry Exit Data checkServices Data checkHPRP Exit Data  WorksheetsCompObjr F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89q