ࡱ> bd  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`aefghijklmnopqrstuvwxyz{|}~Root Entry F>JY jc,WorkbookZH_VBA_PROJECT_CUR" `ىcjcjCtls  T8\p Ann Kenney Ba= ThisWorkbook=Z$8@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1Arial1Arial1$Arial1 Arial1 Arial1Arial1Arial1& Courier New1& Courier New1Arial1hArial1Arial1@Arial1@Arial1Calibri1 Calibri1 Calibri14 Calibri1  Calibri1Calibri1 Calibri1,8 Calibri18 Calibri18 Calibri1> Calibri14 Calibri1< Calibri1?Calibri1h8Cambria1Calibri1 Calibri"$"#,##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\);_(* "-"??_);_(@_) 000000 mm/dd/yy mm/dd/yyyy"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + ) , *   !  " P # P $  $  %   & ` '      (   ) * a> +      @  @       @@   @  @        @    @      @           0 0       @ @     @   (0@  @ @  @ @   @ @  (0`@ @@   @  @   @  @   @   @@  @  @  @  @  @@ 7   @ 7  @ 7   @ 7  @      @         @   @   (    (  @   @ (@    @@  @   @@  @    @@  @  (@@/  (@/  ( @/   8@@  0@  0` @  0@  0  0`  0`@  0`  0``   @@    x@    x @   8@  8@  8` @    8` 8  0` 0` 0`` 1)@@) 1)@ 1) @ 1)@ 1) 1) 1) 1) @ 1) 1) @  @     @@ @  @  @    (@@  (@  ( @ "@ "     1@ 1 1 @       @@ @  @ @@) @)  @   @ @ )  )     @@ ) @ )  @   @  @ @ @ @ a@@ ) a@ )  a@  a @ (@ ( (  @@ 0@ 0 @  (@  (  (   @  0  !@@  !@  @   @  1@@ 1!@ 1! @ @     @@ (@ ( @ (@ ( (    a@ @   @@  0@  0 @ !@ ! !   8 @  0  0 !@ !  @@  @  @   @    8@ 8 @  @@   @  @      ( (         "@@/ "@ "  @  *@/ * * *@ * @ * *  @@ 7  @ 7   @ 7  @@  @ -@ - @   @  @ (@ ( @  @ - -  @ - -    ||<}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_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}A}1 a00_)[$ -}A}2 00_)[$ -}A}3 00_)?[$ -}A}4 00_)23[$ -}-}5 00_)}}7 ??v00_)̙[$ -##0.  }A}8 }00_)[$ -}A}9 e00_)[$ -}x}:00_)[$##  }}; ???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 %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`bBenefits Usage Instructions CDatecalcdaysSffd@ 98 m-.9b-2a'g*n-2a'g*PNG  IHDR0sRGB pHYs+DIDATx^ˑEܘLg#?1h~nh;+eC!Fd^| w:z]HdL է/@4Smq"}հp @f@v<_|" L!0Pm"1L@x@a~u~-=Y & #Mm dG"  4V.2K7A T"\M@V$P6 dNJBL ZxJd ;j8@B,@v,2@($P+ dGa}1 0.V|\ؓ HMErr @6^Fd1Ø % @Pxq@5jqr+8 lAFm<R @@'P6Ν~~tXBޖ@x[R$@@gFcO>(@fT3\ TÉ^o~İu 2qWa- @Yej%  ra0@FFO=i  ?(筋:n KLm(Z9$ܟ}䞃n9 ٷއ@R1O >ˈҽ?80@ptC#B@ Fً: i&݂/AB Ф6?*u @`Ն|әuP  @IMj#C(^Ѱ=k@}5 ì  @_@ ڠ @x@G^__4Dcb@Ԇ0 & /֞!@s6pf@[mQ`۹d@(PknkFO) @`8q~ ׂCb@Y @(S> #_?x{ߺ9 @`ej#PaB $Ъ6Ii/@UmE췌\aN?%z*$۱/^b<@ `@mܝ>G˽>˃`H/3Wg9tOg5R,z._pTYCԆ{fJzǛ"}@a".mY]ڃFwy(`G;ַc#\)FDp3vW 3qU V"%Y\8 17p} lS4H^{N*'JY|`s=. ӽen.᤽vO*JwzRT"^rɒFV>=B7҃ wqn:c0Kʋ\.FE>/<ðCjx=rwy]jϸ$r6ƕ޳[z׌j 7{Qs((GR Xj1j1#oDʃ|BrploR.mP z 246w))^YmY.t3B`yCr +@|u2 ڍq]?#H$iHtkcܥHiyآ+Rt ȝ!AdE")h\-xˑ=~~byp0~+]]q܊$sY4Fߜ@q\k[*#좶nhMtnTE|\o# ֏pDֽZ{lE?}aKUi-$|\xVp=ǝ@1$G0~HrSuR.MTcqp%^%䞏MGz.]w:)v}w&/ύK B!BQ^>6dK'E/>k%Ն#:#ً4.AQ'؝ y7(2EXk]َ(FWP!2Z '6?VAOjݷbO*{(INM_XlQnl~XVߐ8J^ \f^}5qg3Z.lu"A-R WE+3d_Qj/ݯ G%Π4EfKs)oem/?:O~3_2n*ܨQ^|WmJWnlrW備UD/O?|g:vrC>=BY=9PL 7XuƟs/TbE˧t PAt6U1@FE'1 $P*5'CFnjIF<;j{Ep@IzRt^hm@ 0@Xl@m 6B( ;U6a?.1 ϓ7*H:hm Zdpѱp@oK A٢76NhS6tyqgYTr6pa @KjCS" :@Fh=¸6? @ MD.jC  @`jCTe%1{p @PXjHX\v Ȍ9R`[@`2dL wL%RonVLjZm<*fMi"+W962Ι#(#[qY!_(3nļY3R}k'IܫK+Mrl?W&8܁Kg O.x.k_9bEPtsN"{0VNВVqzP`mAK(fO!:ě]=Gn+R.J$')?\1Zbl CNwOwj zHmI#svܬ'}^s- QƆג}?;eQ%ZlR㇢PxoM}f&/o<^۶L))bד;;KҠnt%Ȯ9ݜrL21 Mgx:xI`:mA8igDFVOq^hf ܆/жv1S$7$;GR[o9yrw2QQc(mKƂē-d"cN".KsіcdzQZVF*)R*C\C3P1C~&eAفȘ"N@z-܍4% T_e.(lqus]owA.}\v 2'w5]ߓ'mo$ $'VLJ%oq'r-@RjtQlnWHeAڸf,;]jv߂Xt[Ǖ.@%)%s" ,pXx:#,' 4"l}sjJ 9}BA=snbkيı@@X7E#2 d |ϿC`*>@WL [*XcWIΦLU'كprX ,tev:Egɐ\} J pon3T\ OڸB/Ugc]l8 V*znB]r[C1*ʽƞwZXиJ:mB+#BfAۂ@ '[ABDF@d5  jÖ:h!@xu#eIENDB`"w[.r㓇)ɰ%@=w[.r㓇)ɰ% bd |xkeM&ifIsOh !BQt`Z&i"ЦM(H qP /t Dwfބsye&2MǺQD?̛k3;e?tOr]63fw^X|^f;&g{Kx\YYKMuHFA-IE>6&K4STaFǭ, M,'Tz$a2y< Ð:^lՆύg&L4ةv`89aeƃ-i}׿y!;z~r':_L̒l։?|&JKR]A/ jAp‘}q&ڈ7 ȅ~Y( kc]=YC y1_׆@7"B^L8 Q}X6? l:|JzD. 8<ғ˜^U=%7 r c#!=A]lOvQ^S;7z%o@2u ~8&$t }o/ G)kz4wCq ­]9|5}%.Ǒ^MǔR2њ/}'<_\q_( =/m/ lcyݻrd-s_-7ͪ|>_oׅl,q7™c~]~?B'ma _?+5MۓGޞ %%<\z E/a??n72_z}B]ͻ`OK*+>&={eOgOؔ:M~sPxi+A;kjg*Q+ O SqSЗwW`"5}{WR1pc@=[5}{WR1pL S )xVkAliij VAJAVCzh`{C)" (z7/-xP{-{gL, B֑S@#MI`'a4HwpQ2 @_>9r%IՆ~#x*A2Щyaq,l?HUQHswwD4J  ٰ9eVųZ<=Ǯx:InR_4 E14%Z=Gnn0 =QʗVŵ%TW+ރ~O55Ldf$EZ~F7T\9!҄Ye\9ieF} /YOm.^/"<3V'gBdUNzp9ߜ$liDNr^刄8Wi'ȭs>^=#++W5e߮ܪ^cVoXC&r+z6&d zm6b 2K|]'wܽg{LDUx0XڒC79J氊u-b X:ɛSꋃFrЖoDW{&}7Gy$͟'S~?˱Cs2w=z˾0ق,3)[T*|^g"'a؇g#ˬ<z;,`ؠl~!m"@t2{_;HdO Y4fh9|l/9+mHfR"CH<.Mf@=^CH<<.ML PI| Y,xVOSQJ)Q-D̫A q2qA :5|/, !81889`\\0q?hDz}65 r>ܛ*sQgR xŻd8G:30&ɮݻS#z%3{$0bDJ:a.0ƸvǑ(y"G^hGrf,^m:"8K fXzYa]rReZY^F[: "I~i8M%(Pwܦ]cN9\3sוHI5V؀8ŒW]^J+ oU'/; iriO:"ߍdf$ER_KKskkvK#9} j9sBE4M3'cygOdlb$;1edr'O{҃|%1`|;Cj+N{TӐ+O+j-߂[U+~FVg- nUY U _XCB&:D jm63x5$Qgwڻokx^=ޫ K8{Q!ˆ#?%tPHtD3@S 8lё#..Gs4 wK@spRRx*E2Ы>";,).$Tòϳ"݆'dy0||'[y[sgD^Tn2XڔKƯ6 Xdž*b+'٠lʚ}{?JUs8h4H2T^~S>f M7Zꙏ{xG0/B˧f9q1;[fFk̍Hg<56GJ5Yy/}=id}yW&a"U+TN[;՘z.(|?羌x79|6&X"J<|(ySl;s@=kJ<|(ySl;a }9xTOAfn9a]"k"  ;/*:w(l(P+K066gbABBq}o~swy;{o̜<$=9 {YΡU@Im1ZI&} b㽂t<Ntx\ [ݲ~"F_&$P>$i׵#%$d늰Q)d^(J\]^ ʵ:Z5~DNop KU$ʫ(vf4߾;<1WK_CiXUV +XD(諿ěn+ iǴ-suce7?vM'ѷ\8ZBwygEգJ ʵTN?w%$s/ }<ӋUKxN~tNŪ/a\*xq$o)6cBC| Lv"%-̪,Ym}o@=g%-̪,Ym}X Ql 5xV=LSQ{Z)y51H&"R ց((B^؞ L &.8;6 *Ѥs=}zi=!"')J $G8jsIW9o޹I&g)R5pUxRN7&gLȟLoӬ &Gދq{!ƴ=^&'sHrMzu!heiD21+}G^]9WoT`mQ *Quf17Gk]u 3!h2?By|[9SSfhG^T2XKƯ90YVdڰ<~z]k4UzHx,Mk6ivv+6H`?P}-ѻ/e_vg 3ȭ^ՅN?RU(r<ˬ5ÿæp Fѵ"ܕeϻAXc&gHA:eߨA!&2i2x!S@h'h"]ڱhעc;M_01 WR"pDA}#PL@=DDA}#P Ql xUOSQ}@!lKF8"bp$Z ! o}N:0trp2q2qgF AI0ys=}M ιy^'i0 0S( :O )H%ܽ}oL֛cc9r/T]`))!LUjn:I?WaDJBM ,+rB3NȚLm.>/!yY5b[hϷ'{\9Wfǽ:rl=Uf>Szabܫ!oΑ;+*ۿܩ^V^DKljOzԁ^(#ogC>dy0||'[9[gD^=Tn2XڔKƯ6*( UQ*O*Aʘ}J4$]ie=>M4rGi~ H/K,f91+/rfF}M-X2[hؼgWAu_?2!a 7ړh[ ѱ/ ä=]",)RB괵c^]yyR?K};Ĺ {px=c넍_WX"~t70:a$l@=d~t70:a$X Ql 2xVKTQQ'-fF+aBڴ(HJK1iZLHKGyVAAA$ljvm ZF JP0s= .p;sϽoa?.4PICG-0aWI6Dxkd@?ƃg,hx$jAT1+Lu>L1΢Da dO~p&,+W(:ڪZ*GXr XJvúeެeRZz^XIB 4ItCI&;^î14E%R Cxj7y.%ZiF:I'Z_YǖVhqqB&o7*$p'lz |33gvX>\ܱ29«OwKӍAbBt$:b UI8Q.C+O3jO9oVX39yH<~g^YY}|jY>UZcuyfͨU[RMѬjyD-!O1aVg } r6G>,Q4ÒB6^M7;w_vߌ?FvWz~яw$K%1lroT 򩖏o@z$g 3]$ @{A{\3>53_'Y9<+)G#kfVD1zN~6>̴ܾ.< 3ɶGcu!MMM&4(cuD-($.Rh)yt.#H1 )(wg̵2O{99#" @ U Dxw=G^/\xeC'&"_8'Z'R0k ?q#"#Lɸ 9CHEwR6,3nOqd"?%Xmq1znmmAV*o*u] L2&lk;? ƙ*@T9+:MQ%1ʹQ[R-@-"OlbEDZ+<(č6'KʡyVыCkճkiXZg5q A>֤:sޏBr2@,Zk5 !S_XCP'0O9qLTIu! rTw^:yphMc&=uڔ,|ʱ8ɚث>9v0.mCʲҁ,jg(M%ϵȺAkڈչŽ갨ķ>yܫ>ѹ'2:9Y9S/հC+8-;?ِ=װ׾o'ʻ*ȵ>gO?<|o~S&tЎ6?o|m`4'_5xI1Ӈ%9n>vw(Ծ-ѰS<C`,bxj>E`Na4@^lww&O[e l95Me/Qe7os-x.S" 3  @@   UP'Total of Personal Sick Leave Days Used:Date:%Total of Family Sick Leave Days Used:"Total of Vacation Leave Days Used:Employee Name: Note :JanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberOctoberNovemberDecemberReporting Period: Employee ID:General Information Department:uFOR COPY/TRANSFER USE ONLY (NOTE: WHEN PASTING THIS INTO THE SUMMARY SHEET, USE "PASTE SPECIAL" AND SELECT VALUES.)Employee Signature:%Supervisor Signature (If Applicable):9Benefit Usage (If benefits were not used, enter a zero.)CommentsConversion InformationHow many of the above leave days (vacation, personal sick and/or family sick) were used for an approved leave under the Family and Medical Leave Act?x y Benefits Usage Guidelines<Complete the reporting period indicating the month and year.CFill in your name. If using a printed form, please print your name.Fill in your Employee ID.ZThe date is entered automatically. If using printed form you may need to correct the date.RSpecify the department for which you are reporting. (Only one department per form) Benefit UsagegEnter the total number of vacation days used during the period specified in the Reporting Period field.lEnter the total number of personal sick days used during the period specified in the Reporting Period field.jEnter the total number of family sick days used during the period specified in the Reporting Period field. For Example:Enter the number of above listed vacation, personal sick and family sick days to be applied to an APPROVED Family and Medical Leave Act (FMLA) program.oSign the Benefit Usage Statement and submit it to your supervisor or other designated departmental coordinator.Use of sick leave and vacation shall be arranged with due regard for the operational needs of the university and shall require supervisory approval. The use and reporting of all leave time benefits shall be in strict compliance with departmental and University policies. Reporting Period Employee Name Employee IDDate DepartmentTotal Vacation Days Used&Total of Personal Sick Leave Days Used$Total of Family Sick Leave Days UsedFMLA SignatureVPF P Conversion from Hours to Days FORMULA: Hours Used / 7.5 = Days b2 hours taken / 7.5 = .27 days 4 hours taken / 7.5 = .53 days 6 hours taken / 7.5 = .80 days_2 hours used / 7.5 = .27 days 4 hours used / 7.5 = .53 days 6 hours used / 7.5 = .80 daysHours to Days Calculator!FORMULA: Hours Used / 7.5 = Days^Sick leave and vacation days may be recorded in whole days or fractions of days. Fractions of days may be recorded by dividing the number of hours used by 7.5. Note that "days" are based on the standard 7.5 hour work day. Note: In those instances where a contract specifies a standard 8 hour work day use (Hours Used / 8.0) to calculate days used.AComments: (Include date(s) and amount of leave documented above)YBoard of Trustee Regulations and the State Officials and Employees Ethics Act (SOEEA) require that all leave time taken (vacation, sick leave, FMLA, or any other leave authorized pursuant to Board of Trustees Regulations and university policies) be recorded to the nearest quarter hour (see example and formula below), with vacation time entered into the "Total of Vacation Leave Days Used" section and sick leave entered into the "Total of Personal Sick Leave Days Used" or "Total of Family Sick Leave Days Used" sections. In addition, time taken "for any political candidate or partisan purpose other than educational" must be documented as either vacation or unpaid leave time. The date(s) and total amount of time taken for all leave time documented during the reporting period must be recorded in the "Comments" section of the Benefits Usage Form. In the Comments section, note date(s) and amount of all leave including vacation, sick leave, jury duty, bereavement, funeral leave, military leave or any unpaid leave time declared.0Salaried Employee Benefits Usage FormNInstructions and Guidelines for the Salaried Employee Benefits Usage StatementAs part of the required institutional compliance with the State Finance Act and the State Officials and Employees Act, a number of important responsibilities are delegated to supervisors, departments and colleges throughout the university. These responsibilities include verification and authorization of the time worked records that are incorporated into the Hourly Time Sheet and Salaried Employee Benefits Usage Form. When a department authorizes a time sheet or benefit usage form, that department is attesting to the accuracy of the information contained therein. Accordingly, supervisors are directly responsible for monitoring the hours of work and other provisions recorded in these documentation formats.(Benefit usage and leave time reported in accordance with the SOEEA compliance program must be reported to the nearest quarter hour (see example and formula above.) Employees should contact their supervisors for the appropriate and customary precision by which benefit usage should be reported. Please be reminded that all leave accruals are based and prorated on the appointment percentage or FTE value. The total unused Sick leave and Vacation accruals will appear on your pay check or payment advice. Remember though that sick leave and vacation accounts are only reconciled on a monthly basis and the delay in reporting actual monthly usage may cause some discrepancies in your pay check/advice amounts. Contact HRS if there are any questions. In accordance with state law and university policy, I certify that the benefit usage reflected above are true and accurate based on hours worked this month.All salaried employees are required to submit an Employee Benefits Usage Statement each and every month. Statements are to be submitted to the supervisor or other designated department coordinator on the 1st of each month. {Specific eligibility criteria and provisions for sick leave and vacation accrual, as well as specific provisions regarding extended illness leave for civil service employees, nonaccumulative sick leave for Faculty/SPS, FMLA guidelines and Sick Leave banks, can be found in the 鶹Ʒ Board of Trustees Regulations or at the http://www.niu.edu/board/regs/botregtoc.shtml web address. Doe, Jane00987654 SL00000: Human Resource Services.03/02 - 4 hrs vacation ; 03/12 - 7.5 hrs sick   How To Complete Benefit Usage Form 1. Reporting Period: Using the drop down box , select the month and year 2. Employee Name: Name should be in the following format: Last Name, First name, MI. 3. Employee ID: Enter your 8 digit employee ID number 4. Date: Use today s date 5. Department: Department code should be two letters with 5 zeros followed by the name of your deparment <7 6. Benefit Usage: Enter number of days used for Vacation, personal sick, and/or family sick. Formula: Hours Used/7.5 = Number of Days 7. Employee Signature: Must be original signature, payroll will not except electronic signatures 8. Comment Section: Please note day and hours you used your benefits Benefit Usage Forms are due to your supervisors on the 1st day of every month unless otherwise requested by your supervisor. ( )*>u jy<M%9k R 4xW tۈZn0 іPcc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭Vū'y'pNoDw=U=^VW/끐Ak^7/Ͽó*|F"'t3q%'sn3f1 c;OV5#ţxwؑu5lj< 5}ͫb2]3*:#:/3EP:TIB?%F(uzD%!&ѹHIh~Y vls 9HHj.^*ԑU NJUX*0!nCV~Cu[%.R(zZG漊<䧣'YvJӸXBbtU8G8~{!.,E/t"LLTꄦ?Tm9ܔwX]ܻT K!^bs7rC Mlm#Ty M-a '0M')7bY :[l O1Πo=Md!s 2.ahkik<6;zb+ꈇvFIH0{ڂQK*^Nt{f|#)Remb/`iMlC`.l5k`FBmw- ">zo7N*beC w|*p[/P,&'Kw8xl1R7-)P†[dڛB17 |8vPة؆K5'+f.jդh cR]ג(":2mg_Rʗi9[ ס T‰紵'8IW=38;Y-2MA*e0o@ZٍrﮊIkRg Z@#) sBYL8TpFm rڜ4LZNR# B,{ 1?_,I2UWfV99#lk`W!M5ˀ]?=ϠB79|s*Yww>6A))bWU;L/ު"újY*KA?OZ[64nv `epT^xuO" l wltsh &Mʚ6oՊ;ݒ%ckɮw4vٜ\NcvlmǶ<{9Ea(*621榬zчpmdzKff ;h~ؘ$7E"ʣ] a 0CES]L RIϠ]"-E6Lzx_UnurVmeT;k<zeK_ILp8NCs.;Rt OH+ E?”] eu1RЁkz;{{N5n {vpco4 I:6,n`lR x w-, {k1rʎ)Z~ˬMԵi_15 [ʋɍ2nqKVG Ip!DF3p  p#8 k>[üxXfPvMmu*7l5_&[ٚ')jpb55]gPK! ѐ'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 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!ڞq:#theme/theme/theme1.xmlPK-! ѐ'D theme/theme/_rels/themeManager.xml.relsPK]? ~-z4nA_)k:~yw T8 - Q  dMbP?_*+%96&L&8http://www.hr.niu.edu/resources&R&8Rsvd. 2/20/2014&?'?(?)?M HP LaserJet P4014/P4015 PCL6d!C odX,LetterDINU" P=N:SMTJHP LaserJet P4014/P4015 PCL6InputBinPrinterSelectRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERMediaTypeAutoCollateONOutputBinAutoHPImageShiftOffHPAutoDuplexScalingTrueColorMode24bppTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPBackSidePrintingFalseJPEGEnableBestSmoothingTruePrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpap6.xmlHPStaplingOpposedFalseHPPCL6PassThroughTrueHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNStaplingNoneHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1TrueHPPrintOnBothSidesManuallyFalseHPStraightPaperPathFalseHPSendPJLUsageCmdCURIHPCoversOther_PagesFront_Cover_from_Feeder_InputBinNoneBack_Cover_from_Feeder_InputBinNoneJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPConsumerCustomPaperTruePSAlignmentFileHPZLSwn7HPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHub_ColorprintingaccessusageTRUEHPSmartHub_OrdersuppliesTRUEHPSmartHub_ShowmehowTRUEPSServices_PrintcolorusagejoblogTRUEHPSmartHubInet_SID_263_BID_514_HID_265PIUPHdLetter o [none]  !"#$%&'()*+,-./123456789:;<=>?ABCDEFGHIJKLMNOQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~0ҋB `$AEH, {Marchac.5Arialac.0ҋB `$AAEH, {20185Arialac.7WF#xME [none]4Pd?A141218044dMicrosoft ExcelEXCEL.EXE<"C:\Program Files\Microsoft Office\Office15\EXCEL.EXE"BX,??&OU} @} @} @} @} 9@} ::U@} ;;q@} <=@} > @-FFF\F@F@FF F@FF@ F F@ FK@  F@ FFFFFF F@0FY@F@F@F@ FF F@FFFFF@ 8IEEEEEEEEEEEEEEEEEEEEEEEE CB7 :O;EvKAAAAAAAAAAAAAAAABAAABACA7:EvMMMMMMMMMMMMMMMMMMMMMMM7:Ev7:E  t       EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEJ7:EvFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFH7:E t7:E D  !, -.7:E  KD                                 L!,~ -@.7:E t 7 :E Mt 7 :E Mt  7 :E t PQ7 :E ^ ,~ -J@ .7 :Ev7:E ^,~ -?.7:Ev7:E t7:Ev7:E Ht7:E ^, -.7:Ev7:E ^, -.7:Ev7:E t7:Ev7:E @t7:E Nt7:Ev7:Ev7:Ev7:Ev7:EDl F@!FJ@ "F,@#F@$F@%F@&F@'F,@ (F@)Fi@ *F@+F,F t 7 :Ev!DAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAARAAAASARAAAAAAALAAAAAAAG7!:E"D "h9 ":6"[[[\ "=>"cAG7":Ev#Dc[[[\cAG7#:Ev$Dc[[[\cAG7$:E %Dc %<p%[[[\cAG7%:Ev&Dc[[[\cAG7&:Ev'Dg[[[\cAG7':Ev(DAAAAAAAAAAAAAAAAAAAAAAAALAAAAAAXYYYUVWWZZZOOOOOOOOAAAAG7(:Ev)TMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMN7):E *t*7*:E +_6+d +_7 +_8n+aaaaaaaaaaaaaaaaaaaaEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEJ7+:E,e(\? $ -~ ,f,e?, $-3,e, $-n,`````bbbbbbb````````MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMN7,:E 2l(   l A$??,NIU HRS Logo LongPicture 2NIU HRS Logo Long.bmp/]&l`~~ ( < CC@?"$ -3&],(@9 $,<-Convert Hours Used to Standard 7.5 Hour Days<  ,%0 x 3 s >A ?@cmbomonth ]]n3 1 D Forms.ComboBox.1T ; ~v 4 s <A ?@cmboyearU]w]n4 1 D Forms.ComboBox.1TT ; >@Zd :,:E :' 7 7-7-7,,:E,, 7 5 77-7 -7 ,-7-7,,,777,-7 ,-7-7 ,-7**7"'4 7"$%'77g Non-Numeric Data%This field must contain numeric data.,-7 -7xl Invalid Date=This field must contain a valid date greater than 01/01/2000.77-7-7jl Invalid Date7This field must contain a date greater than 01/01/2000.00-7h,Emplid must be 8 characters&Emplid must be 8 characters in length. , Sheet1ggD T8 *,$l:hA  dMbP?_*+%&RRevised: 12/20/2004&?'?(?)?M HP LaserJet P4014/P4015 PCL6d!C odXXLetterDINU" P=N:SMTJHP LaserJet P4014/P4015 PCL6InputBinPrinterSelectRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERMediaTypeAutoCollateONOutputBinAutoHPImageShiftOffHPAutoDuplexScalingTrueColorMode24bppTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineRETChoiceTrueHPBackSidePrintingFalseJPEGEnableBestSmoothingTruePrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpap6.xmlHPStaplingOpposedFalseHPPCL6PassThroughTrueHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNStaplingNoneHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1TrueHPPrintOnBothSidesManuallyFalseHPStraightPaperPathFalseHPSendPJLUsageCmdCURIHPCoversOther_PagesFront_Cover_from_Feeder_InputBinNoneBack_Cover_from_Feeder_InputBinNoneJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPConsumerCustomPaperTruePSAlignmentFileHPZLSwn7HPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHub_ColorprintingaccessusageTRUEHPSmartHub_OrdersuppliesTRUEHPSmartHub_ShowmehowTRUEPSServices_PrintcolorusagejoblogTRUEHPSmartHubInet_SID_263_BID_514_HID_265PIUPHdLetter o [none] [none]4Pd?A141218044dMicrosoft ExcelEXCEL.EXE<"C:\Program Files\Microsoft Office\Office15\EXCEL.EXE"OXX?RQ?&QOU} } } :} ;;} <>*>>e@>>]>]>T]>d]>]>^>^ >@ >^ >^ >^ >^>^>^>^>^>^>^>@>^>^>^>^>^>^>^>^>^ >^>^D DB = )************************************************************+=jkkkk ,Iv--------------------------------------------------...../=jkkkk 7Jv:::::::::::::::::::::::::::::::::::::::::::::::::::::::;=jkkkk 7Av88888888888888888888888888888888888888888888888888888889=jkkkk 7Ev:::::::::::::::::::::::::::::::::::::::::::::::::::::::;=jkkkk 4Gv55555555555555555555555555555555555555555555555555555556= noooopqq r  qqq  0+h 1111111111111111111111111111111111112222222222223=sooootoooooo= u vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvwwwwwx= yzzzz n,v zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzoooooooooo{= yzzzz|}}}} }l }}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}~~~~~~~~~~= yzzzz i-v zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzoooooqqqqq= yzzzz}}}} } l }}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}~~~~~~~~~~=loo n.vooooooooooooooooooooooooooooooooooooooooooqqqqq=loo|  ~!l ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=loooo n/vooooooooooooooooooooooooooooooooooooooooooooooooqqqqq=loooo|~~~~  ~"l ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=loooo n0vooooooooooooooooooooooooooooooooooooooooooooooooqqqqq=loooot~~~~  ~#l ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~= u$vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvwwwwwx=loooo n1vzzzzqqqqqqqqqq=loooo|}}}}  %l ~~~~~=loooo i2vzzzzqqqqqqqqqq=loooo}}}}  &l ~~~~~=loooo n3vqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq=loooo|  'l ~~~~~=loooonoooo  ?h =loooonoooo=loooonoooo=$loooonooooloo (ooooooo >R                       !ooooooooooooo{=4loooonooooloooooooooo ";R#######################$ooooooooooooo{=Dl >^!>^ ">K^#>t^$>^%>^&>^'>^(>^)>^ loooonooooloooooooooo%#######################$ooooooooooooo{=!loooonooooloooooooooo&'''''''''''''''''''''''(ooooooooooooo{="loooonooootoo~~~~~~~~~~~~~~~~~=#loooommmmq #  # qq #Fb#=$loooo $4v$qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq=%loooo|~~~~ % )l% ~~~~~=&loooo &nv&ooooqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq='loooot~~~~ ' Bl' ~~~~~=(loooo (n5v(ooooqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq=)t~~~t~~~~ ) *l) ~~~~~=2* ,(   , A$??,NIU HRS Logo LongPicture 3NIU HRS Logo Long.bmp"]&,`><d= 7 7== ====== =##=%% 7'' 7)) 7""//!/ 77 Sheet2ggD T8  EsG  dMbP?_*+%&?'?(?)?"??=&U}       ~ x@ ~ |@  ~ @  ~ @  ~ @  ~ @  ~ @ ~ @ ~ @ ~ @ ~ @ ~ @@PH00(  >@7 Sheet3ggD VBA9cjpcjModule1 NThisWorkbook Sheet1 /(SLSS<N0{00020819-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 ;oKWDcx#cmbomonth, 51, 0, MSForms, ComboBox"cmboyear, 52, 1, MSForms, ComboBoxME(SLSSsN0{00020820-0000-0000-C000-000000000046} F@ H J L(% %*Sh0 %*U`h8h*\R8003*#63 "  "  " ( "0 8Hop@o`oPo@86Attribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Controlcmbomh, 51, 0, MSForms, Co Boxyear2, PX\ Sub+mandButton1_Click()End dayscmdHour >._Change result = MsgBoSheet30Sheet2@_VBA_PROJECTP/dir^7W@#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}4; WUxME  $@h+!Macro recorded 1/31/01 by a20sob1d 14`&x`(ge`*H`,`.`0`2+"   (( P X x   (@ h <0 "p  4    08 &h nB ` p x b    0 calcdays Macro" Macro recorded 1/31/01 by a20sob1 Keyboard Shortcut: Ctrl+d]p]]]]]]t* infte = InputBox("What is the FTE ? " & Chr(13) &'* "(Note: Enter as a Decimal, for example .8 = 80%) ")8c!* If Len(Trim(infte)) > 0 Then* fte = Val(infte)** If ((fte <> 1#) And (fte <> 0.93) And (fte <> 0.8) And (fte <> 0.75) And (fte <> 0.67)'* And (fte <> 0.53) And (fte <> 0.5)) Thenf <&* msginfo = "The FTE must match the Benefit Bands. They are: " &'* Chr(13) & Chr(13) &'* "1.0, .93, .80, .75, .67, .53, and .50" & Chr(13) & Chr(13)'* & "If your FTE does not match one of these bands, use the next highest FTE."RM* MsgBox (msginfo)fD * Elsee&Enter the Number of Hours To Convert $4'(0d ($6 >< ($8 ($:'* *@'.;** days = hours / (7.5 * fte)_* msginfo = " For an Employee With a " & Format(fte, "#.00") & " FTE: "'* & Chr(13) & Chr(13) & Chr(13)'* & " " & Format(hours, "###0.00") & " Hours = " & Format(days, "##0.00") & " Days"ig* result = MsgBox(msginfo, vbInformation, "Convert Hours to the FTE Based Standard Day")& The number of days used is: $< $< $<  *###0.00$ Hours =  .##0.00$ Days'0 0 @+Convert Hours to the FTE Based Standard Day$>'2> ?dSOnly numberic values must be entered in order to calculate the number of days used.A@>kdVA valid number of hours must be entered in order to calculate the number of days used.A@>k* End If * End IfoAttribute VB_Name = "Module1" Sub calcdays() T.nDescr@iption|acro recorded 1/31/01 by a20sobProcDataTInvoke_FuncTd\n14' ' Mjs$'Keyboard Shortcut: Ctrl+dDim inBfAs Sng  hours    ingle    hmsg6o *5r esult Integer N*L= InputBox("What is the FTE ? " & ChrP(13)_ "(Note: E+r as a Decimal, for example .8\80%) |'*If Len(Trim(H)) > 0 0ThenH>= 8Val @((<> 1#) And 0.9K,K875M67) 8@* 55. -@ b@BSmust matchXBenefit Bands. >rT\M!?ceF "1.0, B8A$75@6753, @ .50xV & "^y5does no6one of!se ba, u@aJnext highe !L.o#AMsgP (DŽ'fEElsayin#eWP NumberHlTo ConvertCP Pb Q'' Is` ericQ$V g^CWC x= / (7.5ǩ * `__J cHQbF@san E`soyee With@w@@Th, "#.00"~"<|& "efGUK@ & b$##0';,"D%"D M ģ= OO, vbIn" %HCtoxBasSt]{! "2@ 0nT+"=*F0*Noioogon]ASeD"Only Cic va luJbXbe e#Qkpin qr AulazJ./PgIf=O % ("AQidD J O O e'?#dL E sv!p{`ub 8(%H xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 +Wf#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%H xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 a  *\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.8#0#C:\Program Files\Microsoft Office\Office15\EXCEL.EXE#Microsoft Excel 15.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\system32\FM20.DLL#Microsoft Forms 2.0 Object Library *\G{66A74825-0AEE-489A-AADD-AE5A189292D4}#2.0#0#C:\Users\A10AMK~1.NIU\AppData\Local\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M (*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.7#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLL#Microsoft Office 15.0 Object Library :WModule1015cd058ee Module1U ThisWorkbook025cd058eeCThisWorkbookF= Sheet1075cd058eeE Sheet1D0 Sheet3045cd058eeO Sheet3@H= Sheet2055cd058eeQ Sheet2f`1x`0Ht+kZHP4+X.S$Fc~`72:82*H33A$b3^{xMv=>_OAU{aNRK*'*Excel+VBAWin16~Win32Win64xMacVBA6#VBA7# VBAProjectstdole`MSFormsCOfficeuModule1b _EvaluatecalcdaysinfteinhourshoursGPftedays=;msginforesulturInputBox Trim@ IsNumeric$*ValChrK~MsgBoxR vbInformationn ThisWorkbook|Sheet1CommandButton1_Click dayscmd_ClickHourscmd_Clickcmboyear_ChangeaSheet3Sheet2 cmbomonth7cmboyear CE!OQ   ZZ0* pHd VBAProject4@j = r : J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\syst em32\e2.tlb#OLE Automation`MSForms>SFFrms3ED452EE1-E08F-@101A-8-02608C4D0BB4EFM20.DLL#Microsoft E: ^ Ob Library/;D1u00}#0#k0 A66A74825-0AEE-489A-AADD-AE5A1@89292D6Users\A10AMK~1.NIU\AppData\Local\Temp\Exc@el8.0\DW.8exd>$.E .`M AÍ OfficčOf@ic A42DF8D04C-5BFAAkB-BDE80AA42k@gram Files\CommonGkShared\OFFICE4155Os& 15.0Lt%BՈWCodule1GDou1 2HB1` B,QBU!B+BThisWorkbookGU T oi@^W_kbokwM2o=oF"eaSheet! Se:t 2 m D 3G, 3  3 3UU@ 2 2 2 2 1)f)b+Module1Module1ThisWorkbookThisWorkbookSPROJECTwmPROJECT SummaryInformation( DocumentSummaryInformation8,heet1Sheet1Sheet3Sheet3Sheet2Sheet2ID="{A8DB8F98-F787-11D4-B01B-00D0B7AC5927}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet3/&H00000000 Document=Sheet2/&H00000000 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="8A8867FFF503F503F404F404" DPB="1416F989091913191369E2B926083D10DEE642" GC="9E9C730377070008000800" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] Module1=44, 44, 492, 382, Z ThisWorkbook=0, 0, 0, 0, C Sheet1=88, 88, 923, 890, C Sheet3=154, 203, 1253, 841, C Sheet2=132, 174, 1231, 812, C Oh+'0 PXl  sectionIIMarius Morosanu Ann KenneyMicrosoft Excel@