ࡱ> bdf  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry Fpe#3Workbook_VBA_PROJECT_CUR" 3pe#3VBAr3P 3 ZO\pRaegan Kelliher Ba= ThisWorkbook=p.8^@"1Arial1Calibri1Calibri1Calibri1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1 Arial1 Arial1 Arial1Arial1 Arial1 Arial1 Arial1, Arial1,Arial1Arial1Arial1 Arial1Arial1Arial1Arial1Tahoma1Tahoma1Tahoma1Tahoma1Arial1Calibri1 Calibri1Calibri1 Calibri1 Calibri1Calibri1Calibri1,>Calibri1>Calibri1>Calibri1>Calibri1 Calibri1Calibri1?Calibri1h>Cambria1Calibri1 Calibri1 Arial1 Arial1 Arial"$"#,##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\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_) dd\-mmm\-yy_)hh:mm\ AM/PM_) 0.000_) 0.0000_)0_);;; 0.00_) 0_);\(0\)94_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"???_);_(@_);6_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"???_);_(@_) mm/dd/yy "$"#,##0.00                &  &  &  &  &  &  &  &  &  &  &  &  '  '  '  '  '  '  '  '  '  '  '  '  (  )   * ff %+ ) ) + + + %, %* , + ,  " / " / $ / - P . P / / 0   1 ` 2  ! & & &  # %    3  % 4 5 a8 6 "    # "x@ @   `@ @   &x@ @  "x@ @   `@ @   "x@ @   `@ @   @ @   "8@ @   "xw@ @   "xw@ @   "xw@ @    (  "x@ @   &x  "x@ @    " !     !  @ @   @ @  !@ @   # &@ @  &p@ @  &@ @  &@ @  &@ @  &@ @  &@ @  $@ @  $ $@ @  $ "@ @  " "@ @  !@ @  "@ @  !@ @   &@ @  &@ @  "@ @  &@ @  &@ @  "@ @  !@ @   @ @   @ @  !@ @     @ @   !@ @    %  !@ @  "@ @   @ @  #@ @  $@ @  $@ @   @ @  " " !   # " "@ @  "@ @  "@ @   @ @  "@ @  " $@ @  % %  @ @  +          !  @ @   ! # %$ %$ %$@ @  ! ! %!   ( ) (  )  ) @ @  " # ! # " !  $   "    (@ @  " " " " "  @ @  $@ @  $@ @  7"@ @  7  7  7  7%  7% @ @  7$ 7$@ @    % 7%$ 7%$@ @   @ @   "       7  7$ 7$@ @  7! 7 @ @  7" 7  7! 7# 7%$ 7! 7! 7%! 7 ( 8) ( 8)  8) @ @  9   $@ @   $ "   "    @ @  "@ @   ,@ @  "<@ @  "<p@ @   @ @   @ @ /  @ @   @ @   p@ @   p@ @   p@ @    @ @    @ @   "<@ @    ,@ @  "@ @  "p@ @    ,wa@ @  +  " "\, + h, + H,  a@ @    a@ @    ,a@ @   "<a@ @      ,  "<    #8@ @   (@ @  1&<@ @   ( 1&< "  "8@ @    (   (@ @  "<@ @   (w@ @  "@ @  "p@ @   "8  "8  "@ @   "@ @   "<@ @   @ @   @ @   (p@ @   (p@ @   p@ @  "<p@ @  "  (@ @  #8@ @   (@ @   !8@ @   (a@ @    ,wa@ @    ,w@ @    ,  ,a@ @   ,a@ @   (q@ @    ,q@ @   ,q@ @    ,q@ @   (qp@ @    w@ @   w@ @   w@ @    w@ @   " }0.0000\)_)(@_) }A}? e0.0000\)_)(@_) }-}A 0.0000\)}-}B 0.0000\)}-}C 0.0000\)}x}F0.0000\)_)(  }}G ???0.0000\)_)(??? ???  ??? ???}-}I 0.0000\)}U}J 0.0000\)_)( }-}K 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(} 0.0000\)}(}ef0.0000\)}(}ef0.0000\)}(}ef0.0000\)}(}v0.0000\) 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]- Comma [0] 2 .Comma 2 /Comma 3 0Comma 41&Currency2. Currency [0]3 Currency 24Explanatory TextG5Explanatory Text % 5Good;Good  a%6 headerStyle8 headerStyle 7 headerStyle 2< headerStyle 2 8 headerStyle 3< headerStyle 3 9 Heading 1G Heading 1 I}%O: Heading 2G Heading 2 I}%?; Heading 3G Heading 3 I}%23< Heading 49 Heading 4 I}% =InputuInput ̙ ??v% > Linked CellK Linked Cell }% ?NeutralANeutral  e%"Normal @Normal 2 ANormal 37Normal 3 %B Normal 3 2; Normal 3 2 %C Normal 3 3; Normal 3 3 % DNormal 4 ENormal 5 FNoteb Note   GOutputwOutput  ???%????????? ???H$Percent ITitle1Title I}% JTotalMTotal %OOK Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight168 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`0pdetail payroll Web Expense SummaryJWeb Revenue Summary  ;.  ;x  ;5 for the period endingYear to ProjectedTotalNet Expenditures:AdjustedBudgetDate ExpenditureExp toYTD andBalanceRevenue:Revenue Revenue to Under/(Over) Org/Object DescriptionRevisionActivity Reservat'ns AdjustmentsYear End Projections at Year End Pers SvcsTuitionBenefitsLab FeesTravelGen Fund Contr Svcs UA ReceiptsCommdty Aux ReceiptsResaleInterest Income EquipmentOverheadFin AidIntra Agency Rcpt CIP ReceiptsMiscOther 93/94/95/98TOTALPAYROLL PROJECTION SUMMARY Form P-3 Benefit Type ECLS CodesLeave and Benefit Rates AnnualSickHolidayStaff Current as of: 0 = ClassifiedNRCodeCategory Leave 1 = Classified UnionCR Data thru LD# 2 = APT (Exempt)XR Classified LD Date is 3 = Extended TemporaryNX/XX Classified Union 4 = ExecutiveEX APT (Exempt) 5 = Faculty, UNACF9 Extended Temporary Executive Faculty, UNAC 8 = Faculty temp representedFT/FW 9 = TemporaryCT/NT/XT 10 = Student Taxable Faculty-Temp represented 11 = Students non-taxable Temporary Student Taxable Students non-taxableOrg # & Org titleHrsDaysHourlyBenefitBegStopPerHoli-Per-Days ofGrossAnnualNameWageObjPCNTypeDayContractRemdaysonalOtherEarningsSalaryLabor_6Subtotal: Permanent Positions and Committed Pool Labor= Leave/BenefitRate-Pool Labor Projections:Adjunct Faculty Faculty, UNACClassified Overtime Temporary Non-Students Temporary Students NoneTOTAL PAYROLL PROJECTIONS StartEndHolidays\P/wchL1~/WCHQ1~ \P M128..M130LD# Remaining/ppos{esc}\015\143~qagpq /wcda1..bj1~\A \A M132..M133\I/WGPD/WIR~!{UP}{END}{LEFT}/C{END}{RIGHT 25}~{DOWN}~{DOWN} /RE{RIGHT 7}~a1/WGPEb2c3d4e5\D/rfd~~@date({?})~f6g7h8i9j10k11l12m13n14o15OrgFundCurrentYTD Level 5 OrgLevel 3 ProgramAccount Type TitleExpendedEncum$ 7 = Faculty non-represented 12 moFR& 12 = Faculty non-represented <12 moFN Faculty non-rep 12 mo Faculty non-rep <12 mo Faculty, UAFT 6 = Faculty, UAFT Faculty, UAFTT720CAF UNAC Faculty DevReport Balance Difference From LastReportOrg # and TitleOrg #Title Department 1 Department 2 Department 3 Department 4 Department 5Major Budget Unit SummaryDepartment SummarySN/GNA9ST/GTF24 Management Report DetailDepartment NameW XlnXX'1YYZdZZ(V[[$|\\5!]sX]]T^^%_w___?E``9 ja a# cc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VѠԯٴ++2a,/$nECA6٥D-ʵ? dXiJF8,nx (MKoP(\HbWϿ})zg'8yV#x'˯?oOz3?^?O?~B,z_=yǿ~xPiL$M>7Ck9I#L nꎊ)f><|HL|3.ŅzI2O.&e>Ƈ8qBۙ5toG1sD1IB? }J^wi(#SKID ݠ1eBp{8yC]$f94^c>Y[XE>#{Sq c8 >;-&~ ..R(zy s^Fvԇ$*cߓqrB3' }'g7t4Kf"߇ފAV_] 2H7Hk;hIf;ZX_Fڲe}NM;SIvưõ[H5Dt(?]oQ|fNL{d׀O&kNa4%d8?L_H-Ak1h fx-jWBxlB -6j>},khxd׺rXg([x?eޓϲكkS1'|^=aѱnRvPK! ѐ'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-!0ktheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]  q=cf{=/$ ZO 82F*N7sȡx  dMbP?_*+%&.U &CPage &P&R&D&ffffff?'ffffff?(?)?M Kyocera BWKalfa 4003i KX'dXX"dPcKZ0 o **$ ** $o **$ ** $ EE00100004!*4!* dd@ ? ?XX0J,X< XXXX 0000Arial?  A A A A"""""""""""""""" /dPcKPZ0dPcK'ZdPcK NZDConfidential 1dPcKZdPcKdZdPcKcZ<z"D333333?333333?&43U} }  } I }  }  }  } I } $ }  } $ } } } } m }  } I } $ }  } I } $ } } $ }  2hhM      v      Nm @ZmO]OO O OO O O  O PO]OO OO O O OP X [ [ Q^ R R R R R R R  R  S  Q  ^  R R R R R R R S \ R ] T _ T T T T T T T  T U  T  _  T T T T T T TU Z ^ Y6*2333334**%*25555555igej *~ +j@ ,0%6667%%%%'-------=hfj~ $@@ ' VZ:  -( DDD %~  %@  ' /////#  %D( D DD%HHj~ $@ '   Z:  p  =   LLL %~ %@ ' /////     -L r  LLL %HHj~ $@@ '         %~ %@ ' /////       %HHj~ $p@ '         %~ %@ '! /////       %HHj~ $@@ '"      $  %~ %@ '# /////       %HHj~ $@ '$        %~ %$@ '% /////     %HHj~ $@ '&      %~  %%@  '' /////  %HHj~ $p@ '(      %~  %V@  ') /////  %HHj~ %X@ ''      %~  %t@  '* /////  %HHj~ %@@ '+           %  &, (00 (D DD%HHj% 1-  -D# %=   %%  1     -  # %   %"IW D D~ I!j~ DD6%'666667%%%%'-------%HHj *~ +j@ ,0%6667%%%%'-------%HHj~ $@@ ' /Z`# I %(  DDD %~  %@  ' /////# %D(D DDJJj~ $@ ' Z`   -D   LLL %~  %@  ' ///// -L LLLJJj~ $@@ '      %~  %@  ' /////JJj~ $p@ '       %~  %@  '! /////JJj~ $@@ '"      %~  %@  '# /////JJj~ $@ '$      %~  %$@  '% /////JJj~ $@ '&      %~  %%@  '' /////JJj~ $p@ '(      %~  %V@  ') /////JJj~ %X@ ''      %~  %t@  '* /////JJj~ %@@ '+          %  &, (00JJj% 1-,  -L ,,/    %%  1 ,    - ,     "K D D~ KjD!l,9@H:^Vt:^C !"#$%&'()*+,-./0123456789:;<=>?6 %'666667%%%%'-------%HHj !*~ !+j@ !,0!%6667%%%%'-------%HHj~ "$@@ "'"" #Z#" } %""(" , D"D"D"" %~ " %@ " '" /////#"" %""D"("#D" D"D""%HHj~ #$@ #'## #Z# # ##+ -D"# p# #+ LLL# %~ # %@ # '# /////#$##+ -L###+ LLL#%HHj~ $$@@ $'$ $ $ #$ &# $ %~ $ %@ $ '$ /////$$#$%#$%HHj~ %$p@ %' % % #% '# % %~ % %@ % '!% /////%%#%&#%%HHj~ &$@@ &'"& & 1#& % # & %~ & %@ & '#& /////&&#&'#&%HHj~ '$@ ''$' ' ' #' (# ' %~ ' %$@ ' '%' /////''#'(#'%HHj~ ($@ ('&( ( ( #( )# ( %~ ( %%@ ( ''( /////((#()#(%HHj~ )$p@ )'()) ) #) *# ) %~ ) %V@ ) ')) /////))#)*#)%HHj~ *%X@ *''** * #* +# * %~ * %t@ * '** /////**#*+#*%HHj~ +%@@ +'++      ++ #+ "# + % + &,+ (00++#+,#+%HHj,% ,1-,9,,,  -L,,,9,,9,,,,,",," ,, ,, , %% , 1, 9 , ,,  -,,, ,9, ,,, ,,, ,, ,, ,%",I, D, D,~ ,K!,j D,D,6-%'666666%%%%'-------%HHj .*~ .+j@ .,0.%6666%%%%'-------%HHj~ /$@@ /'// 0Z#/ p %//(/ 9 D/D/D// %~ / %@ / '/ /////#/0 %//D/(/9D/ D/D//%HHj~ 0$@ 0'00 0Z0 0 008 -D/0 <0 08 LLL0 %~ 0 %@ 0 '0 /////00008 -L01008 LLL0%HHj~ 1$@@ 1'1 1 1 01 s0 1 %~ 1 %@ 1 '1 /////1101201%HHj~ 2$p@ 2' 22 2 02 30 2 %~ 2 %@ 2 '!2 /////2202302%HHj~ 3$@@ 3'"33 3 03 40 3 %~ 3 %@ 3 '#3 /////3303403%HHj~ 4$@ 4'$44 4 04 50 4 %~ 4 %$@ 4 '%4 /////4404504%HHj~ 5$@ 5'&55 5 05 60 5 %~ 5 %%@ 5 ''5 /////560505%HHj~ 6$p@ 6'(66 6 06 70 6 %~ 6 %V@ 6 ')6 /////6606706%HHj~ 7%X@ 7''77 7 07 80 7 %~ 7 %t@ 7 '*7 /////7707807%HHj~ 8%@@ 8'+8      88 08 /0 8 % 8 &,8 (008808908%HHj9% 91-9F999  -L9%99F99F99999/99 99 99 9 %% 9 19 F 9 99  -999 9F9 999 999 9 9 999 9%"9I9 D9 D9~ 9K!9j9 D9D96:%'666666%%%%'-------%HHj ;*~ ;+j@ ;,0;%6666%%%%'-------%HHj~ <$@@ <'<< ,Z#< V %<<(< JD<D<D<< %~ < %@ < '< /////#<< %<<D<(<=D< D<D<<%HHj~ =$@ ='==  Z= F==E -D<= F = =E LLL= %~ = %@ = '= /////=?==E -L=F==E LLL=%HHj~ >$@@ >'> > > => ?= > %~ > %@ > '> /////#>> %>>L>K=>%HHj~ ?$p@ ?' ? ? ? =? @= ? %~ ? %@ ? '!? /////??=?@=?%HHjD~#l:^C:^C:^C@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_~ @$@@ @'"@ @ =@ A= @ %~ @ %@ @ '#@ /////@@=@A=@%HHj~ A$@ A'$AA A =A B= A %~ A %$@ A '%A /////AA=AB=A%HHj~ B$@ B'&BB B =B C= B %~ B %%@ B ''B /////BB=BC=B%HHj~ C$p@ C'(CC C =C D= C %~ C %V@ C ')C /////CC=CD=C%HHj~ D%X@ D''DD D =D E= D %~ D %t@ D '*D /////DD=DE=D%HHj~ E%@@ E'+E      EE =E <= E % E &,E (00EE=EF=E%HHjF% F1-FSFFF  -F2FFSFFSFFFFF FFJ FF FF F %% F 1F S F FF  -FFF FSF FFF FF F F F F F%"FIF DF DF~ FK!FjF DFDF6G89::::::88889;;;;;;;8LLj H*~ H+j@ H,0H%#########<<<<<<<#??j~ I$@@ I'II }Z#I } %II(I  DIDIDII %~ I %@ I 'I /////#IJ %IIDI(ISDI DIDII#HHj~ J$@ J'JJ  ZJ SJJR -DIJ S J JR LLLJ %~ J %@ J 'J /////JJJJR -LJLJJR LLLJ#HHj~ K$@@ K'K K K JK LJ K %~ K %@ K 'K /////#KK %KKLKXJK#HHj~ L$p@ L' L L L JL MJ L %~ L %@ L '!L /////LLJLMJL#HHj~ M$@@ M'"M M M JM NJ M %~ M %@ M '#M /////MMJMNJM#HHj~ N$@ N'$NN OJN & J N %~ N %$@ N '%N /////NNJNOJN#HHj~ O$@ O'&OO O JO PJ O %~ O %%@ O ''O /////OOJOPJO#HHj~ P$p@ P'(PP P JP QJ P %~ P %V@ P ')P /////PPJPQJP#HHj~ Q%X@ Q''QQ Q JQ RJ Q %~ Q %t@ Q '*Q /////QQJQRJQ#HHj~ R%@@ R'+R      RR JR IJ R % R &,R (00RRJRSJR#HHjS% S1-S`SSS  -S>SS`SS`SSSSSV SS SS SS S %% S 1S ` S SS  -SSS S`S SSS SFS SS SSS S#"SIS DS DS~ SK!SjS DSDS6T#############<<<<<<<#??j U*~ U+j@ U,0U%#########<<<<<<<#??j~ V$@@ V'VV <Z #V < %VV(V WDVDVDVV %~ V %@ V 'V /////#VV %VVDV(VWDV DVDVV#HHj~ W$@ W'WW JZ W `WW_ -DVW `W W_ LLLW %~ W %@ W 'W /////WWWW_ -LWYWW_ LLLW#HHj~ X$@@ X'X X X WX YW X %~ X %@ X 'X /////#XX %XXLXqWX#HHj~ Y$p@ Y' Y Y Y WY ZW Y %~ Y %@ Y '!Y /////YYWYZWY#HHj~ Z$@@ Z'"Z Z Z WZ [W Z %~ Z %@ Z '#Z /////ZZWZ[WZ#HHj~ [$@ ['$[[ [ W[ \W [ %~ [ %$@ [ '%[ /////[[W[\W[#HHj~ \$@ \'&\\ \ W\ ]W \ %~ \ %%@ \ ''\ /////\\W\]W\#HHj~ ]$p@ ]'(]] ] W] ^W ] %~ ] %V@ ] ')] /////]]W]^W]#HHj~ ^%X@ ^''^^ ^ W^ _W ^ %~ ^ %t@ ^ '*^ /////^^W^_W^#HHj~ _%@@ _'+_      __ W_ VW _ % _ &,_ (00__W_`W_#HHjD#l:^C:^C`abcdefghijklmnopqrstuvwxyz{|}~`% `1-`z```  -`K``z``z`````= ``q`` ~` ` %% ` 1` z ` ``  -``` `z` ``` `S` `g ` `` `#"`I D` D`~ `K!`j~ D`D`6a#############<<<<<<<#??jb*Y@+j@ b,0b%#########<<<<<<<#??j~ c$@@ c'c#c c %cc(c dDcDcDcc %~ c %@ c 'c #cc %ccDc(cmDc DcDcc#HHj~ d$@ d'dd d ddl -Dcd ed dl LLLd %~ d %@ d 'd ddddl -Ldeddl LLLd#HHj~ e$@@ e'ee e de fd e %~ e %@ e 'e eedefde#HHj~ f$p@ f' ff f df gd f %~ f %@ f '!f ffdfgdf#HHj~ g$@@ g'"gg hdg m d g %~ g %@ g '#g ggdghdg#HHj~ h$@ h'$hh h dh id h %~ h %$@ h '%h hhdhidh#HHj~ i$@ i'&ii i di jd i %~ i %%@ i ''i iidijdi#HHj~ j$p@ j'(jj j dj kd j %~ j %V@ j ')j jjdjkdj#HHj~ k%X@ k''kk k dk ld k %~ k %t@ k '*k kkdkldk#HHj~ l%@@ l'+l      ll dl cd l % l &,l (lldlmdl#HHjm% m1-mXmmm  -Lmmmmmmmmmmmmmmmm mm mm m %% m 1m mm mm  -mm m mmm mmm mmm mum mdm m#"mIm Dm Dm~ mImj6n#############<<<<<<<#??j o*~ o+j@ o,0o%#########<<<<<<<#??j~ p$@@ p'pp Z-#p  %pp(p ,DpDpDpp %~ p %@ p 'p /////#pp %ppDp(psDp DpDpp#HHj~ q$@ q'qq qZ-q zqqy -Dpq zq qy LLLq %~ q %@ q 'q /////#qq %qqLqrqqy LLLq#HHj~ r$@@ r'r r r qr uq r %~ r %@ r 'r /////#ry %rrLr qr#HHj~ s$p@ s' s s s qs tq s %~ s %@ s '!s /////ssssy -stqs#HHj~ t$@@ t'"t t t qt q t %~ t %@ t '#t /////ttstqt#HHj~ u$@ u'$uu u qu vq u %~ u %$@ u '%u /////uvsuzqu#HHj~ v$@ v'&vv v qv wq v %~ v %%@ v ''v /////vvsvwqv#HHj~ w$p@ w'(ww w qw xq w %~ w %V@ w ')w /////wxswN qw#HHj~ x%X@ x''xx x qx yq x %~ x %t@ x '*x /////xzsxwqx#HHj~ y%@@ y'+y      yy qy pq y % y &,y (00yysyqy#HHjz% z1-zzzz  -zczzzzzzzzz` zzzz `z z %% z 1z  z zz  -zzz zz zRzz z`z zz z z z#"zI Dz Dz~ zK!zj DzDz6{#############<<<<<<<#??j |*~ |+j@ |,0|%#########<<<<<<<#??j~ }$@@ }'}} IZR#} " %}}(} 9D}D}D}} %~ } %@ } '} /////}}}} -D}(}~D} D}D}}#HHj~ ~$@ ~'~~ ZR~ ~~ -D}~  ~ ~ LLL~ %~ ~ %@ ~ '~ /////~~}~~~ LLL~#HHj~ $@@ '   ~ ~  %~  %@  ' /////# %L~#HHjD$l:X$p:^C|:^Vt~ $p@ '    ~ ~  %~ %@ '! /////}~#HHj~ $@@ '"   ~ ~  %~ %@ '# /////}~#HHj~ $@ '$  ~ ~  %~ %$@ '% /////}~#HHj~ $@ '& ~ ~  %~ %%@ '' /////}~#HHj~ $p@ '( ~  ~  %~ %V@ ') /////}~#HHj~ %X@ ''  ~ }~  %~ %t@ '* /////}~#HHj~ %@@ '+       ~  ~  % &, (00}~#HHj% 1-  -rQ`  %% 1     -    S}T #"I D D~ K!j DD6#############<<<<<<<#??j *~ +j@ ,0%#########<<<<<<<#??j~ $@@ '#  %(  DDD %~ %@ ' /////# %D(D DD#HHj~ $@ '#  %D   LLL %~ %@ ' ///// -L LLL#HHj~ $@@ '    -L   %~ %@ ' /////# %#HHj~ $p@ '       %~ %@ '! /////#HHj~ $@@ '"      %~ %@ '# /////#HHj~ $@ '$     %~ %$@ '% /////#HHj~ $@ '&    %~ %%@ '' /////#HHj~ $p@ '(     %~ %V@ ') /////#HHj~ %X@ ''     %~ %t@ '* /////#HHj~ %@@ '+          % &, (00#HHj% 1-  -# %   %% 1     -   z   #"I D D~ K!j, DD6#############<<<<<<<#??j *~ +j@ ,0%#########<<<<<<<#??j~ $@@ '#  %( DDD %~ %@ ' /////# %D(D DD#HHj~ $@ '   -D   LLL %~ %@ ' ///// -L= LLL#HHj~ $@@ '     %~ %@ ' /////#HHj~ $p@ '      %~ %@ '! /////#HHj~ $@@ '"    %~ %@ '# /////#HHj~ $@ '$     %~ %$@ '% /////#HHj~ $@ '&     %~ %%@ '' /////#HHj~ $p@ '(     %~ %V@ ') /////#HHj~ %X@ ''     %~ %t@ '* /////#HHjD#l:^$]:^$p~ %@@ '+          % &, (00#HHj% 1-  -L   %% 1     -       #"I D D~ Kj6#############<<<<<<<#??j *~ +j@ ,0%#########<<<<<<<#??j~ $@@ '#  %(  DDD %~ %@ ' /////# %D(D DD#HHj~ $@ '  -D    LLL %~ %@ ' ///// -L LLL#HHj~ $@@ '     %~ %@ ' /////# %L#HHj~ $p@ '      %~ %@ '! /////#HHj~ $@@ '"     %~ %@ '# /////#HHj~ $@ '$     %~ %$@ '% /////#HHj~ $@ '&     %~ %%@ '' /////#HHj~ $p@ '(     %~ %V@ ') /////#HHj~ %X@ ''     %~ %t@ '* /////#HHj~ %@@ '+          % &, (00#HHj% 1-  -   %% 1     -      #"I D D~ K!j% DD6#############<<<<<<<#??j *~ +j@ ,0%#########<<<<<<<#??j~ $@@ '#  %( DDD %~ %@ ' /////# %D(D DD#HHj~ $@ '  -D   LLL %~ %@ ' ///// -L LLL#HHj~ $@@ '     %~ %@ ' /////>#HHj~ $p@ '      %~ %@ '! /////#HHj~ $@@ '"     %~ %@ '# /////#HHj~ $@ '$     %~ %$@ '% /////#HHj~ $@ '&     %~ %%@ '' /////#HHj~ $p@ '(     %~ %V@ ') /////#HHj~ %X@ ''     %~ %t@ '* /////#HHj~ %@@ '+          % &, (00#HHj% 1-  -L  %% 1     -    #  #"I D D~ K!j DD6#############<<<<<<<#??j *~ +j@ ,0%#########<<<<<<<#??j~ $@@ '#  %(  DDD %~ %@ ' /////# %D(D DD#HHj~ $@ '   -D   LLL %~ %@ ' ///// -L LLL#HHjDA$l:^$p:^$p:^$ ~ $@@ '     %~ %@ ' /////#HHj~ $p@ '      %~ %@ '! /////F#HHj~ $@@ '"     %~ %@ '# /////#HHj~ $@ '$     %~ %$@ '% /////#HHj~ $@ '&     %~ %%@ '' /////#HHj~ $p@ '(     %~ %V@ ') /////#HHj~ %X@ ''     %~ %t@ '* /////#HHj~ %@@ '+          % &, (00#HHj% 1-  -L/  %% 1     -      #"I D D~ Ij6#############<<<<<<<#??j @4+,%%%%%%%'%'-------%b'j~ >@@ '#] XSL=LJLWLdLqL~LLLLLLLL###### #  '~ %@ ' #  ] MSL=LJLWLdLqL~LLLLLLLL# # # # # # %W ML=LJLWLdLqL~LLLLLLL caj~ >@ '$$$$$$$ $  '~ %@ ' $  $ $ $ $ $ $  caj~ >@@ '%%%%%%   '~ %@ '    %  % %    caj~ >p@ ' &&&&&&& &  '~ %@ '! &   & & & & &  caj~ >@@ '"''''''' '  '~ %@ '# '  ' ' ' ' ' u  caj~ >@ '$((((((( (  '~ %$@ '% (  ( ( ( ( ( (  caj~ >@ '&))))))) )  '~ %%@ '' )  )  )  ) )  caj~ >p@ '(******* *  '~ %V@ ') *  * * * * * *  caj~ ?X@ ''+++++++ +  '~ %t@ '* +  + + + + + +  caj~ ?@@ '+,,,,,,, ,  ' &, ( ,  , , , , , ,  daj? 1-G-G-G-G G-G-G- G-  '% 1 G-  G- G  G- G G- G- GiG-SDDD,D9DFDSD`DzDDDDDD~ G!j= DD6?'%%%%%%%%'%'-------%==j# Z3Z3Z3  Z Z<<<###j# ! DD!' DD! DD !  D D !- DD<<<###j6#############<<<<<<<###j )))))))j )))))))j @4+,%#########<<<<<<<###j~ $@@ '#  %W( DDD %~ %@ ' # %D(D DD#..j~ $@ '   -D   LLL %~ %@ '  -L LLL#..j~ $@@ '  %   %~ %@ ' #..jDI.l:F_BBBBBBBB>::""F$p  ~ $p@ '      %~ %@ '! #..j~ $@@ '"     %~ %@ '# #..j~ $@ '$     %~ %$@ '% #..j~ $@ '&     %~ %%@ '' #..j~ $p@ '(     %~ %V@ ') #..j~ %X@ ''     %~ %t@ '* #..j~ %@@ '+     % &, (#..j% 1-  -L   %% 1     -    z  A"B D D~ B!j DD )))))))j )))))))j @4+%%#########<<<<<<<###j~ $@@ '#  %( DDD %~ %@ ' # %D(D DDCDDj~ $@ '   -D   LLL %~ %@ '  -L LLLCDDj~ $@@ '     %~ %@ ' CDDj~ $p@ '      %~ %@ '! -CDDj~ $@@ '"     %~ %@ '# CDDj~ $@ '$     %~ %$@ '% CDDj~ $@ '&     %~ %%@ '' CDDj~ $p@ '(    %~ %V@ ') CDDj~ %X@ ''     %~ %t@ '* CDDj~ %@@ '+     % &, (CDDj% 1-  -L   %% 1     -      F"B D D~ B!j- DD )))))))j )))))))j @4+%%#########<<<<<<<###j~ $@@ '#  %(  DDD %~ %@ ' # %D(D DD#..j~ $@ '   -D   LLL %~ %@ '  -L LLL#..j~ $@@ '     %~ %@ ' #..j~ $p@ '           !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrstuvwxyz{|}~ %~ %@ '! #..j~ $@@ '"     %~ %@ '# #..j~ $@ '$     %~ %$@ '% #..j~ $@ '&     %~ %%@ '' #..jDh!l""F$p""F$p        ~ $p@ '(     %~  %V@  ') #..j~ %X@ ''     %~  %t@  '* #..j~ %@@ '+     %  &, (#..j% 1-  -L   %%  1     -      A"B D D~ B!j DD )))))))j )))))))j @4+%%#########<<<<<<<###j~ $@@ 'NM   -( DDD %~  %@  ' # %D(D DD#..j~ $@ 'NM      LLL %~  %@  '  -L LLL#..j~ $@@ ' OV          %~  %@  '    ( D  D D  #..j~ $p@ '  O"          %~  %@  '!       #..j~ $@@ '" O"          %~  %@  '#       #..j~ $@ '$ NM          %~  %$@  '%       #..j~ $@ '& NM         %~  %%@  ''      #..j~ $p@ '(NM     %~  %V@  ') #..j~ %X@ ''NM     %~  %t@  '* #..j~ %@@ '+PM     %  &, (#..j% 1-  -D     %%  1     -       A"B D D~ B!j DD6%1  ''1!!!!!!!'EEj6%1  ''1!!!!!!!'EEj @4+%%#########<<<<<<<###j~ $@@ '#  % ( DDD %~  %@  ' # %D(5D DDCDDj~ $@ '  -D    LLL %~  %@  '  -L LLLCDDj~ $@@ '     %~  %@  ' CDDj~ $p@ '      %~  %@  '! CDDj~ $@@ '"     %~  %@  '# CDDj~ $@ '$     %~  %$@  '% CDDj~ $@ '&     %~  %%@  '' CDDj~ $p@ '(     %~  %V@  ') CDDj~ %X@ ''     %~  %t@  '* CDDj~ %@@ '+     %  &, (CDDj% 1-  -L)    %%  1    -      F"B D D~ B!j DDD5#l""F7U::F$p !"#$%&'()*+,- ./01  ))))))) j! )))))))!j "@4"+#%#########<<<<<<<###j~ #$@@ #'9##DDDDDD##-## #LLLLLL#########W##  ## %~ # %@ # '# # -#$ #LLLLLL# # ## ## ## ## ## ##..j~ $$@ $'9$#DDDDDD$$-$$ #LLLLLL$$$$$$$$$z $$ z$$ %~ $ %@ $ '$  # $# $# $# $# $# $# $#..j~ %$@@ %'%%-%- #LLLLLL%%-%% #LLLLLL%%%%%%%%%%% %% %~ % %@ % '% % -%- ?#LLLLLL%% %% %%% %% %% %I% %#..j~ &$p@ &' &%&&-&& #LLLLLL&&&&&&& &&% && && %~ & %@ & '!&  % &%% &% &% &% & % &% &#..j~ '$@@ ''"'%''-'' #LLLLLL'''''''''@ '' '' %~ ' %@ ' '#'  % '% '% '% '% '% 'I% '#..j~ ($@ ('$(%((-(( #LLLLLL(((((((((((  (( %~ ( %$@ ( '%(  % (% (% (% (% (% (% (#..j~ )$@ )'&)%))-)) #LLLLLL))))))))))) )) %~ ) %%@ ) '')  % )% )&% )% ))% )`% )% )#..j~ *$p@ *'(*%**-** #LLLLLL********* ** ** %~ * %V@ * ')*  % *% *% *% *% *`% *% *#..j~ +%X@ +''+%++-++ #LLLLLL+++++++++++ ++ %~ + %t@ + '*+  % +% +% +% +% +% +% +#..j~ ,%@@ ,'+,%,,-,, #LLLLLL,,,,,,,,, ,,  ,, % , &,, (,  % ,% ,% ,% ,% ,% ,% ,#..j-% -1--0%-x---- #LLLLLL-0--0----q -- -- z- - %% - 1- 0 % - % -0% -m% -% -% -,% -A9--#DDDDDD~ -!-k D-D-.W[V.E/# /2/<<<###E0# 0!0 D/D-0!0 D/D-!0 D/D-0 !0  D/ D- 0!0 D/D-0<<<###E1\(TT""FtVVVVVVRNh! < E.  '  #  &   K  Y C  A f" f#  , / k/ f0  < K< <  *&=  $I  YI  I  MS 9S V V  V  NW L` -` w`  ` Dm Cp wz z 00%} s} R~        9  q  = f _    O  ?&    k X @ A      0O ,  <]   X`   # 5$ m% X&  && g(  h( @) ) )  + P,  f- '- - - 0 B0   >@d !!! Sheet1ggD ZO H4gRR Jt'  dMbP?_*+%w8 <b /T# &C&K000000FY19 Payroll Worksheet Page &P&'(?)?M Kyocera BWKalfa 4003i KX'dXX"dPcKZ0 o **$**$o **$**$ EE00100004!*4!* dd@ ? ?XX0J,X< XXXX 0000Arial?  A A A A"""""""""""""""" /dPcKPZ0dPcK'ZdPcK NZDConfidential 1dPcKZdPcKdZdPcKcZ<z"8XX&U} f} f} } f} mf} If} I f} f}  f} mf} mf} mf} If} mf} f} f} I f} I } I f}  f} &$ f} '( f} ).If} // f} 01mf} 28If} 9Uf} V f((((((((( ( ( ( ( (((VVVVVVVVVVVVVVVV abaaaaaaaaaa c.:aaaaaaaaaaaaaadeeeeeeeeeee'Vaabaaaaaaaaaacaaaaaaaaaaaaaadeeeeeeeeeee'<gabaaaaaaaaaaaaaakkkkkk\kkk l/deeeeeeeeeee'*gabaaaaaaaaaaaaaaa q20rrrrrrrsadeeeeeeeeeee'0aabhiihjwwaaaaaaaaxxy x3 x4 x5 xx z6 adeeeeeeeeeee' {7|4@3AJb m0 no m1paaaaaaaaaa : ; < = = = =  adeeeeeeeeeee'4@b AJRbtuutvaaaaaaaaaa~}}}}aeeeeee' @~ 2@b }8 ~~ 9aaaaaaaaaa~  }C~n?n;pΈް?n㥛 ?nm?op~jt? aeeeee' D+ @m D%Bfb }> ~~ ?aaaaaaaaaa~ ? }G~nbX9ȶ?n~jt?qx&?nV-?n~ pG@ aeeeee' aab }A ~~ B aaaaaacaaa~ @ }J ~ n Ac]? nV}b? n;Nё\? nS? n p|?5^? aeeeee' aab }E ~~ F aaaawwwwwa~ @ }M ~~ n nMb?~ n nMb? n p#~j? aeeeee' aab }H ~~ I aaaaaaaaa~ @ }N ~ nBi? nB>٬? nGx $(? n|?5^? n pMb? adeeeeeeee' aab }K ~~ L aaaaaaaaaa~ @ }O ~~ n n{Pk? nz):˿?~ n.@ n pʡE? adeeeeeeeeeee' aab } ~~  aaaaaaalaa~ @ } ~ nnnn n~ p adeeeeeeeeeee' aab } ~~ aaaaalalaa~ @ }~nBi?nB>٬?nGx $(?n|?5^?npMb? adeeeeeeeeeee' aab }P ~~ Qaaaaalllaa~  @ }U~nnnnnpEԸ? adeeeeeeeeeee' aab }R ~~ Saaaaalllaa~ "@ }W~nnnnnpI +? adeeeeeeeeeee' aab }T ~~ aaaaalllll~ $@ }X~nnnnnpI +? adeeeeeeee' aab }V ~~ wxaaaallllll~ &@ }Y~nnnnn~ p wdeeeeeeee' aab   yzaaaallllll~ (@ ~ rr{Pk?rz):˿?~ s.@tuMb? wdeeeeeeee'Vaabaaaaaaaaallllllkkuwdeeeeeeee')eeeeeee/ 12 i ii [ ii  \  i .ideeeeeeee' ] < ^ _ ` a   a  \  b c d [ e f 4 5    deeeeeeee' g h i j k   l   m  n  4  o f p q = n r = = = = s  tdeeeeeeee'"HUVuuuuuuuuuuuuuuuuuuueeeeeee'@@ _,ULA'  L4LA'  L ,"B @ _, ULA'  L4LA'  L ,"B  , LA' LA' B%LLLLBLLA'LLA'  , LD LD  ,LA' LA' B%LDLDBLLA'D"B~     , LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bf,D D B$D 333333ÿD D D B$D D D D B$D 333333ÿD iD D B$?D D B$D QD """"B# % ~ ,L oLLA NL L+LLL?L""BS=D DD DDDB%,L%BfL%,L%BfL%,L%BfL+DDDD#\ %%,L% BfL! DDeeeeeeee'@ @       ~      ,L L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""BX, -~ G,=L LLLLLB,LLLL[, -, LLeeeeeeee'@  @  `     ~     '~ X;deeeeeeeee'@  @  3     ~    D ~ +!deeeeeeeeeee'@  @     ?  ~   P  iD~ Egdeeeeeeeee'@  @  ,    ~     7 ~ meeeeeeeee'@  @     J  ~     ~ c:deeeeeeeee'D70lpZpp!;Z?^^^^ 3!3"3#3$3%3&3'3(3)3*3+3,3-3.3/30V1V2V3V4V5V6V7V8V9V:V;V<V=V>V?V  @  @      c  ~         ~   . . . . .  . . deeeeeeeee'!!@ ! @!  ! ! !   ~ ! ! g  !!!!~ !!!!!!!!!!!!k!N!!!!deeeeeeeeeee'""@" " @" " !  " f  ~ " " 4  """~ """"""""""""%"q"""A"deeeeeeeee'##@" # @#  # # # $  ~ # #   ####~ ############L####B#deeeeeeeee'$$@# $ @$  $ $ $   ~ $ $ *  $$$$~ $$$$?$$$$$$$$D$$$$deeeeeeeee'%%@$ % @%  % % %   ~ % %   %%%%e~ %%%%%%%%%%%%%%%%a%deeeeeeeee'&&@& & @& & %  & k  ~ & &   &&&&&~ &&&&&&&&&&&H&&&&&deeeeeeeee'''@& ' @'  ' ' '   ~ ' ' ' '' '~ ''''''''''<''''G'deeeeeeeee'((@' ( @(  ( ( (   ~ ( ( H  (((((~ ((((f (((((((?(((((deeeeeeeee'))@( ) @)  ) ) ) ) ~ ) )   ))))~ )))) ))))))P)))J)I)deeeeeeeee'**@* * @* * )  * q  ~ * *   *****~ ****@********#***<*deeeeeeeeeee' *12++@* + @+  + + + G  ~ + +   ++++~ ++++++++++g++++++deeeeeeeeeee',,@+ , @, , @  , , ~ , , , ,,a ,~ ,,,,,,;, ,,m,,,,,,deeeeeeeeeee',-kkkk -u -u -u -u -u -u -u -u -u-deeeeeeeeeee' .v.kkkkkk. @, UD.A'  D.4D.A'  D. $."B. k.Y... - ..... .. .....:..:..:..deeeeeeeeeee',/kkkkkkkkkkkk /uw /uw /uw /uw /uw /uw /uw /uw /w/deeeeeeeeeee'40kkkkkkkkkkkkkkkk 0x&0kkkdeeeeeeeeeee'41kkkkkkkkkkkkkkkk 1y&1kkkdeeeeeeeeeee'42kkkkkkkkkkkkkkkk 2uz&2kkkdeeeeeeeeeee' 3{,3kkkkkkkkkkkkk 3| 3kk3EԸ?3D3k~ 3!33 D3D33Y338 LL3deeeeeeeeeee'.4kkkkkkkkkkkkk 4} 4kk4ʡE?4D 4k~ 4!44 D4D44Z34deeeeeeeeeee'.5kkkkkkkkkkkkk 5 5kk56D 5k~ 5!55 D5D55[35deeeeeeeeeee'.6kkkkkkkkkkkkk 6~ 6kk6~jt?6D6k~ 6!66 D6D66736deeeeeeeeeee'.7kkkkkkkkkkkkk 7 7kk7I +?]D7k~ 7!77 D7D77 37deeeeeeeeeee'.8kkkkkkkkkkkkk 8 8kk 88k88: 38deeeeeeeeeee'89kkkkkkkkkkkkkkkkkk 9u 9u 9u9deeeeeeeeeee' ::kkkkkkk:@. UD:A'  D:4D:A'  D: $:"Bk: @:UD:A'  D:4D:A'  D: $:"B : < : < : < : < :< :< :< :< :< :< :< :< : :<:#: %.9 #:. %.9#: %.9:deeeeeeeeeee'V;kkkkkkdeeeeeeeeeee' <<i <<ii <[ <ii < \<  <<i <.<ideeeeeeee'= =]= =< =^ =_ =` =a = = a = \= = b= =c= =d= =[ =e =f =4 =5 = = = ==deeeeeeee' >g >h >i >j >k > > >l > > m > n > 4 > o >f >p >q >=> >n >r >= >= >= >= >s > >t>deeeeeeee'">HUF?uuuuuuuuuuuuuuuuuuueeeeeee'Dk3l^^^^^^^^^^l^^pppiZ@(A(B(C(D(E(F(G(H(I(J(K(L(M(N(O(P3Q3R3S3T3U3V3W3X3Y3Z3[3\3]3^3_3@WYXXZZX@@@ @_@RULA'  L4LA'  L ,"B@ @@@ _@R ULA'  L4LA'  L ,"B@ f @ @R LA' LA' B%LLLLBLLA'LLA'@ @@ @R LD LD  ,LA' LA' B%LDLDBLLA'D"B~ @ @ @@ @R LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bf@@B @ @RL L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B#@ %@@ @~ @@@@@RL oLLA NL L+LLL?L""B@@@G@R=L LLLLLB@H @%@RL%BfL@C@%@RL%BfL@,@%@RL%BfL+@D@D@D@D#@ %@@@@6@%@RL% BfL!@C D@D@@eeeeeeee'AA@ @A @A @ A A@ A A@ ~ A A A@ AAA@A AAR -~ AA @A]@AA@A<@A@ATAARLLLLAAAR -AA@ACAAR LLAeeeeeeee'BB@A @B @B @ B B@ B  @ ~ B B @ @ BBB@B\A~ BBB@BB@BB@B@BB@BBABABB@B@ABdeeeeeeeee'CC@B @C @C @ C C@ C C@ ~ C C Z @ CC,@CIA~ CC @CT@CC@CT@CT@C`ACiACT@CjACdeeeeeeeeeee'DD@D @D @D@ D C @ D D@ ~ D D B @ DDD@D A~ DDD@DD@DD@DD@DD@D#AD,ADD@DADdeeeeeeeee'EE@D @E @E @ E E@ E E@ ~ E E  @ EEE@E5A~ EEE@EE@E_ @EE@EJ@EEAEAEE@E;AEeeeeeeeee'FF@E @F @F @ F F@ F ) @ ~ F F  @ FFg@FgA~ FFF@FF@FF@F@FF@FFAFAFD@FAFdeeeeeeeee'GG@F @G @G @ G G@ G  @ ~ G G ' @ GGG@GGA~ GGG@G@GG@G@GG@GGAG)AGG@GHAGdeeeeeeeee'HH@H @H @H@ H G @ H L @ ~ H H  @ HHH@HA~ HHH@HH@H@HH@HH@HHAHAHH@HAHdeeeeeeeee'II@I @I @I@ I H @ I I@ ~ I I  @ II@@IA~ III@I @II@II@II@IAIAII@IJAIdeeeeeeeee'JJ@J @J @J@ J I @ J J@ ~ J J  @ JJJ@JA~ JJJ@JJ@Jq@Je @JJ@JAJAJJ@JFAJdeeeeeeeee'KK@J @K @K @ K K@ K  @ ~ K K + @ KKK@KKA~ KKK@K=@KK@KK@KK@KKAK$AKK@K(AKdeeeeeeeee'LL@K @L @L @ L L@ L  @ ~ L L  @ LLL@LLA~ LLL@Lm@LL@LL@LL@LALALL@LeALdeeeeeeeee'MM@L @M @M@ M B@ M  @ ~ M M  @ MMM@M@A~ MMM@MM@MM@MM@MM@MAMAMM@MAMdeeeeeeeee'NN@N @N @N@ N M @ N 8 @ ~ N N : @ NNN@N^A~ NNN@NN@NN@NN@NN@NTAN:ANN@NANdeeeeeeeee'OO@O @O @O@ O N @ O O@ ~ O O  @ OOO@OiA~ OOO@O @Oq@OO@OO@OAOAOO@OAOdeeeeeeeee'PP@O @P @P @ P P@ P P@ ~ P P P@ PPP@P A~ PPP@PP@PP@PP@Pi @PAPZAP>@PAAPdeeeeeeeeeee' P12QQ@Q @Q @Q@ Q P @ Q  @ ~ Q Q  @ QQQ@QA~ QQQ@QQ@QQ@Qj@QQ@QAQ AQQ@QAQdeeeeeeeeeee'RR@R @R @R@ R Q @ R R@ ~ R R k @ RR= @R A~ RRR@R@RR@R@RR@RRARARR@RARdeeeeeeeeeee',S Su Su Su Su Su Su Su Su SuSdeeeeeeeeeee' TvTkkkkkkT @R UDTA'  DT4DTA'  DT $T"BT TTTT - TfTTTTCTTlTT!TT`TT`TT`TTdeeeeeeeeeee',Ukkkkkkk Uw Uw Uw Uw Uw Uw Uw Uw UwUdeeeeeeeeeee'4Vkkkkkkkkkkkkkkkk Vx&Vkkkdeeeeeeeeeee'4Wkkkkkkkkkkkkkkkk Wy&Wkkkdeeeeeeeeeee'4Xkkkkkkkkkkkkkkkk Xuz&Xkkkdeeeeeeeeeee' Y{,Ykkkkkkkkkkkkk Y| YkkYEԸ?4D3Yk~ Y!YY DYDYYxYY^ LLYdeeeeeeeeeee'.Zkkkkkkkkkkkkk Z} ZkkZʡE?5D4Zk~ Z!ZZ DZDZZyYZdeeeeeeeeeee'.[kkkkkkkkkkkkk [ [kk[D5[k~ [![[ D[D[[zY[deeeeeeeeeee'.\kkkkkkkkkkkkk \~ \kk\~jt?{D6\k~ \!\\ D\D\\Y\deeeeeeeeeee'.]kkkkkkkkkkkkk ] ]kk]I +? D7]k~ ]!]] D]D]]\Y]deeeeeeeeeee'.^kkkkkkkkkkkkk ^ ^kk ^^k^^` Y^deeeeeeeeeee'8_kkkkkkkkkkkkkkkkkk _u _u _u_deeeeeeeeeee'D@l^^^^^^^^^^^^^^l^^ppp`VaVbVcVdVeVfVgVhViVjVkVlVmVnVoVp(q(r(s(t(u(v(w(x(y(z({(|(}(~(( ``kkkkkkk`@T UD`A'  D`4D`A'  D` $`"Bk` @`UD`A'  D`4D`A'  D` $`"B ` < ` < ` < ` < `< `< `< `< `< `< `< `< ` `<`#` %T_ #`C %T_#` %T_`deeeeeeeeeee'Vakkkkkkdeeeeeeeeeee' bbi bbii b[ bii b \b  bbi b.bideeeeeeee'c c]c c< c^ c_ c` ca c c a c \c c bc ccc cdc c[ ce cf c4 c5 c c c ccdeeeeeeee' dg dh di dj dk d d dl d d m d n d 4 d o df dp dq d=d dn dr d= d= d= d= ds d dtddeeeeeeee'"dHUVeuuuuuuuuuuuuuuuuuuueeeeeee'ff@ f_fq ULA'  L4LA'  L ,"Bf @f f _fq ULA'  L4LA'  L ,"Bf ff fq LA' LA' B%LLLLBLLA'LLA'f I f fq LD LD  ,LA' LA' B%LDLDBLLA'D"B~ f f  f fq LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bfffff fq L L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B#ff %ff ~ ffffq L oLLA NL L+LLL?L""BfsfGfq =L LLLLLBfsf%fq L%BfLfsf%fq L%BfLfsf%fq L%BfL+fsDfDfDfL#f %ffffsf%fq L% BfL!fs DfDffeeeeeeee'gg@ufg @gf g  f g  f ~ g g _ f gggfgggq -~ gggfgGfgfggfggfg5ggq LLLgggq -ggfgMggq LLgeeeeeeee'hh@^fh @h f h hf h  f ~ h h hf hh3 fhgg~ hhhfhhfhhfhhfhhfh8gh ghhfhighdeeeeeeeee'ii@h fi @i f i if i  f ~ i i j f iiifi!g~ iiifiifiifiifiifi3gi&giifigideeeeeeeee'jj@i fj @j f j jf j  f ~ j j  f jjQfjM g~ jjjfjjfjjfjjfjyfjYgjigjjfjgjdeeeeeeeee'kk@j fk @kf k Ff k  f ~ k k  f kkkfkkg~ kkkfk fkkfkkfkkfk&gk?gkkfkgkdeeeeeeeee'll@k fl @l f l lf l lf ~ l l [ f lllflg~ lllfl fllfllfllflglBgllflgldeeeeeeeee'mm@m fm @mf m l f m mf ~ m m  f mm>fmg~ mmmfmmfmfm9 fmmfmmgmgmmfmgmdeeeeeeeee'nn@n fn @nf n m f n  f ~ n n i f nnnfnhg~ nnnfnnfnnfnnfnnfngnqgnnfngndeeeeeeeee'oo@n fo @o f o of o of ~ o o h f ooofog~ ooofo foofoofoofogogoofogodeeeeeeeeeee' o12pp@o fp @p f p pf p pf ~ p p : f pppfpg~ pppfppfppfp= fppfpgpgppfpzgpdeeeeeeeeeee'qq@p fq @q f q qf q  f ~ q q P f qqqfqg~ qqqfqqfq^fqZfq+fqgqgqqfq=gqdeeeeeeeeeee',rkkkk ru ru ru ru ru ru ru ru rurdeeeeeeeeeee' svskkkkkks @q UDsA'  Ds4DsA'  Ds $s"Bs ssss - sfssfssfssfssFssssssssdeeeeeeeeeee',tkkkkkkk tw tw tw tw tw tw tw tw twtdeeeeeeeeeee'4ukkkkkkk ux&udeeeeeeeeeee'4vkkkkkkk vy&vdeeeeeeeeeee'4wkkkkkkk wz&wdeeeeeeeeeee' x{,xkkkkkkk x| xxEԸ?DYx~ x!xx DxDxxxx} LLxdeeeeeeeeeee'.ykkkkkkk y} yyʡE?gDZy~ y!yy DyDyyxydeeeeeeeeeee'.zkkkkkkk z zzgD[z~ z!zz DzDzzxzdeeeeeeeeeee'.{kkkkkkk {~ {{~jt?7D\{~ {!{{ D{D{{x{deeeeeeeeeee'.|kkkkkkk | ||I +?]D]|~ |!|| D|D||x|deeeeeeeeeee'.}kkkkkkk } } }}}} x}deeeeeeeeeee'8~kkkkkkk ~u ~u ~u~deeeeeeeeeee' kkkkkkk@s UDA'  D4DA'  D $"Bk @UDA'  D4DA'  D $"B  <  <  <  < < < < < < < < <  <#f %s~ #f %s~#  %s~deeeeeeeeeee'D9liZZ^^^^^^^l^^pppVVVVVVVVVVVVVVVV3333333333333333Vkkkkkkdeeeeeeeeeee' i ii [ ii \  i .ideeeeeeee' ] < ^ _ ` a  a \ b c d [ e f 4 5    deeeeeeee' g h i j k   l  m n 4 o f p q = n r = = = = s  tdeeeeeeee'"HUVuuuuuuuuuuuuuuuuuuueeeeeee'@g _ULA'  L4LA'  L ,"B @  _ ULA'  L4LA'  L ,"B   LA' LA' B%LLLLBLLA'LLA'   LD LD  ,LA' LA' B%LDLDBLLA'D"B~  C   LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bf L L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B# % ~ L oLLA NL L+LLL?L""BYG=L LLLLLB%L%BfL%L%BfL%L%BfL+DDDL# %%L% BfL! DDeeeeeeee'@  @      ~  B   -~ h bLLL -% LLeeeeeeee'@  @       ~  "  O~ Ldeeeeeeeee'@} @  P    ~    Z~ Ldeeeeeeeeeee'@  @      ~    ~  lE9deeeeeeeee'@  @       ~  J  d~ ggKeeeeeeeee'@  @      ~  ^  @~ K Fdeeeeeeeee'@  @  5    ~    P~  OIAdeeeeeeeee'@  @     D  ~  d  ~ DZdeeeeeeeee'@  @  Y    ~    37~ B deeeeeeeee'@  @      ~    ~ C pdeeeeeeeee'@  @     R  ~    ~ $[sdeeeeeeeee'@  @     i  ~  F  ~ Ro7deeeeeeeee'@  @     6  ~  f   ~ m=deeeeeeeeeee' 12@  @      ~   ~  5!deeeeeeeeeee'@  @      ~    ~  b,\\deeeeeeeeeee', u u u u u u u u udeeeeeeeeeee' vkkkkkk @ UDA'  D4DA'  D $"B  - jj`deeeeeeeeeee',kkkkkkk w w w w w w w w wdeeeeeeeeeee'4kkkkkkk x&deeeeeeeeeee'4kkkkkkk y&deeeeeeeeeee'4kkkkkkk z&deeeeeeeeeee' {,kkkkkkk | EԸ?Dx~ ! DD LLdeeeeeeeeeee'.kkkkkkk } ʡE?Dy~ ! DDdeeeeeeeeeee'.kkkkkkk  Dz~ ! DDdeeeeeeeeeee'.kkkkkkk ~ ~jt?(D{~ ! DDdeeeeeeeeeee'.kkkkkkk  I +?%D|~ ! DDdeeeeeeeeeee'D=lZZ^^^^^^^^^^^l^^pppVVVVVVVVVVVVVVVV3333333333333333.kkkkkkk    deeeeeeeeeee'8kkkkkkk u u udeeeeeeeeeee' kkkkkkk@ UDA'  D4DA'  D $"Bk @UDA'  D4DA'  D $"B < < < < < < < < < < < <  <# % #f %#k %deeeeeeeeeee'Vkkkkkkdeeeeeeeeeee' i ii [ ii \  i .ideeeeeeee' ] < ^ _ ` a  a \ b c d [ e f 4 5    deeeeeeee' g h i j k   l  m n 4 o f p q = n r = = = = s  tdeeeeeeee'"HUVuuuuuuuuuuuuuuuuuuueeeeeee'@ _ULA'  L4LA'  L ,"B @ _ ULA'  L4LA'  L ,"B    LA' LA' B%LLLLBLLA'LLA'   LD LD  ,LA' LA' B%LDLDBLLA'D"B~     LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bf L L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B#F % ~ L oLLA NL L+LLL?L""BG=L LLLLLB%L%BfL& %L%BfL%L%BfL+DDDL# %%L% BfL! DDeeeeeeee'@  @       ~  )   -~ Ji LLLq - LLeeeeeeee'@  @    A  ~    ~ ^F9deeeeeeeee'@  @      ~     ~ Adeeeeeeeeeee'@  @      ~    o~ I$pdeeeeeeeee'@  @     Y  ~  "  ~ deeeeeeeee'@  @       ~  K  ~ ,)&deeeeeeeee'@  @      ~  D  6 ~ nfdeeeeeeeee'@  @     E  ~    _~ fAdeeeeeeeee'@  @  `     ~    ~ H_deeeeeeeee'@  @       ~  g  ~ Rdeeeeeeeee'@  @       ~    ~ Z6^Tdeeeeeeeeeee' 12@  @       ~    ~ @Ydeeeeeeeeeee'@  @     \  ~    ~ <jdeeeeeeeeeee',kkkk u u u u u u u u udeeeeeeeeeee' vkkkkkk @ UDA'  D4DA'  D $"B  - 53BM[deeeeeeeeeee',kkkkkkk w w w w w w w w wdeeeeeeeeeee'4kkkkkkk x&deeeeeeeeeee'4kkkkkkk y&deeeeeeeeeee'4kkkkkkk z&deeeeeeeeeee' {,kkkkkkk | EԸ?D~ ! DD LLdeeeeeeeeeee'.kkkkkkk } ʡE?7D~ ! DDdeeeeeeeeeee'.kkkkkkk  D~ ! DDdeeeeeeeeeee'.kkkkkkk ~ ~jt?D~ ! DDYdeeeeeeeeeee'D;liZZ^^^^^^^^^l^^pppVVVVVVVVVVVVVVVV3333333333333333.kkkkkkk  I +?+D~ ! DDdeeeeeeeeeee'.kkkkkkk    deeeeeeeeeee'8kkkkkkk u u udeeeeeeeeeee' kkkkkkk@ UDA'  D4DA'  D $"Bk @UDA'  D4DA'  D $"B < < < < < < < < < < < <  <# % #& %# %deeeeeeeeeee'Vkkkkkkdeeeeeeeeeee' i ii [ ii \  i .ideeeeeeee' ] < ^ _ ` a  a \ b c d [ e f 4 5    deeeeeeee' g h i j k   l  m n 4 o f p q = n r = = = = s  tdeeeeeeee'"HUVuuuuuuuuuuuuuuuuuuueeeeeee'@ _ULA'  L4LA'  L ,"B @  _ ULA'  L4LA'  L ,"B   LA' LA' B%LLLLBLLA'LLA' *   LD LD  ,LA' LA' B%LDLDBLLA'D"B~     LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bf L L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B# % ~ L oLLA NL L+LLL?L""B'G=L LLLLLB%L%BfL%L%BfL%L%BfL+DDDL# %%L% BfL! DDeeeeeeee'@  @      ~  ]     -~ LLL - LLeeeeeeee'@  @     q  ~  | ~ 4RcTdeeeeeeeee'@  @      ~    ~ *deeeeeeeeeee'@  @      ~  b  ~   xdeeeeeeeee'@  @       ~  h  ~ Cgkdeeeeeeeee'@  @      ~    o~ b ]#deeeeeeeee'@  @       ~   f Y~ c^deeeeeeeee'@  @       ~    ~ $Gdeeeeeeeee'@  @      ~  ;  ~ ( Ondeeeeeeeee'@  @      ~    ~  deeeeeeeee'@  @     ~    ~   ;deeeeeeeee'@  @  6   ~    @~  Cdeeeeeeeee'@  @      ~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdeghijklmnopqrstuvwxyz{|}~    d~ ; \deeeeeeeeeee' 12@  @      ~  \  ~  A7 "deeeeeeeeeee'@  @      ~  i  +b~ 4 "7deeeeeeeeeee',kkkk u u u u u u u u udeeeeeeeeeee' vkkkkkk @ UDA'  D4DA'  D $"B [ - C )deeeeeeeeeee',kkkkkkk w w w w w w w w wdeeeeeeeeeee'4kkkkkkk x&deeeeeeeeeee'4kkkkkkk y&deeeeeeeeeee'4kkkkkkk z&deeeeeeeeeee' {,kkkkkkk | EԸ?D~ ! DD LLdeeeeeeeeeee'D=liZZ^^^^^^^^^^^l^^pppVVVVVVVVVVVVVVVV3333333333333333.kkkkkkk } ʡE?D~ ! DDdeeeeeeeeeee'.kkkkkkk  *D~ ! DDdeeeeeeeeeee'.kkkkkkk ~ ~jt?D~ ! DDdeeeeeeeeeee'.kkkkkkk  I +?D~ ! DDTdeeeeeeeeeee'.kkkkkkk    deeeeeeeeeee'8kkkkkkk u u udeeeeeeeeeee' kkkkkkk@ UDA'  D4DA'  D $"Bk @UDA'  D4DA'  D $"B < < < < < < < < < < < <  <# % #' %# %deeeeeeeeeee'Vkkkkkkdeeeeeeeeeee' Ziii [ ii \  i .ideeeeeeee' ] < ^ _ ` a  a \ b c d [ e f 4 5    deeeeeeee' g h i j k   l  m n 4 o f p q = n r = = = = s  tdeeeeeeee'"HUVuuuuuuuuuuuuuuuuuuueeeeeee'@_ULA'  L4LA'  L ,"B @  _ ULA'  L4LA'  L ,"B   LA' LA' B%LLLLBLLA'LLA' %   LD LD  ,LA' LA' B%LDLDBLLA'D"B~     LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bf L L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B# % ~ qL oLLA NL L+LLL?L""BG=L LLLLLB%L%BfL%L%BfL%L%BfL+DDDL# %%L% BfL! DDeeeeeeee'@  @      ~     -~  k LLLG -" LLeeeeeeee'@  @       ~    n~ )deeeeeeeee'@  @     N  ~  n  A~ @Qdeeeeeeeeeee'@  @      ~    k~ lNdeeeeeeeee'@  @     C  ~  g  =~ iQdeeeeeeeee'@  @  =   ~    ~ Q )Qdeeeeeeeee'@  @     &  ~  ,  R~ Xadeeeeeeeee'@  @       ~    ~ qodeeeeeeeee'@  @       ~  !  ~ @hdeeeeeeeee'@  @      ~  G  ~ :p [deeeeeeeee'@  @      ~  D   `~ @9deeeeeeeee'@  @       ~    ~ Pdeeeeeeeee'@  @      ~    M~ gCdeeeeeeeeeee' 12@  @     ?  ~  Z  ~ MDedeeeeeeeeeee'@  @      ~  F  ~ I  Odeeeeeeeeeee',kkkk u u u u u u u u udeeeeeeeeeee' vkkkkkk @ UDA'  D4DA'  D $"B h -   deeeeeeeeeee',kkkkkkk w w w w w w w w wdeeeeeeeeeee'4kkkkkkk x&deeeeeeeeeee'D>liZZ^^^^^^^^^^^l^^VVVVVVVVV V V V V VVV33333333333333334kkkkkkk y&deeeeeeeeeee'4kkkkkkk z&deeeeeeeeeee' {,kkkkkkk | EԸ?*D~ ! DD LLdeeeeeeeeeee'.kkkkkkk } ʡE? D~ ! DD&deeeeeeeeeee'.kkkkkkk  D~ ! DD(deeeeeeeeeee'.kkkkkkk ~ ~jt?D~ ! DDdeeeeeeeeeee'.kkkkkkk  I +?D~ ! DDdeeeeeeeeeee'.kkkkkkk     deeeeeeeeeee'8kkkkkkk u u udeeeeeeeeeee'  kkkkkkk @ UD A'  D 4D A'  D  $ "Bk  @ UD A'  D 4D A'  D  $ "B  <  <  <  < < < < < < < < <  < #  % # N %# O % deeeeeeeeeee'V kkkkkkdeeeeeeeeeee' Z iii [ ii  \    i . ideeeeeeee'  ]  < ^ _ ` a   a  \   b  c  d  [ e f 4 5     deeeeeeee' g h i j k   l   m  n  4  o f p q =  n r = = = = s  t deeeeeeee'" HUVuuuuuuuuuuuuuuuuuuueeeeeee'@_ULA'  L4LA'  L ,"B @  _ ULA'  L4LA'  L ,"B   LA' LA' B%LLLLBLLA'LLA'   LD LD  ,LA' LA' B%LDLDBLLA'D"B~      LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bf L L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B# % ~  L oLLA NL L+LLL?L""BNG=L LLLLLB%L%BfL!%L%BfL!%L%BfL+!DDDL# %!%L% BfL!! DDeeeeeeee'@  @  ]    ~      -~ 6*QLLL` -F LLeeeeeeee'@  @      ~     j~  D*deeeeeeeee'@  @      ~     ~ f Fgdeeeeeeeeeee'@  @     ~   A  ~  Bdeeeeeeeee'@  @      ~   L  >~ 7 deeeeeeeee'@  @      ~     ~ j '_deeeeeeeee'@  @     o  ~     ~ |kdeeeeeeeee'@  @     !  ~     ~ CcfFdeeeeeeeee'@  @      ~   ^  ~  deeeeeeeee'@  @     5  ~     h~ '5deeeeeeeee'@  @     (  ~   l  ~ 5$deeeeeeeee'@  @    %  ~   A  ;~ ?Hbdeeeeeeeee'@  @     d  ~      ~ 4deeeeeeeee'@  @     ,  ~   N  8~ 'Rdeeeeeeeeeee' 12@  @      ~    o ~ p deeeeeeeeeee'@  @     ]  ~   #  ~ Ipdeeeeeeeeeee'D>lppiZZ^^^^^^^^^^^^l^ (!("(#($(%(&('((()(*(+(,(-(.(/(0V1V2V3V4V5V6V7V8V9V:V;V<V=V>V?V, kkkk u u u u u u u u u deeeeeeeeeee' !v!kkkkkk! @ UD!A'  D!4D!A'  D! $!"B! !n!!! - !!!!!!!!!!!!!-!!!!!!!deeeeeeeeeee',"kkkkkkk "w "w "w "w "w "w "w "w "w"deeeeeeeeeee'4#kkkkkkk #x&#deeeeeeeeeee'4$kkkkkkk $y&$deeeeeeeeeee'4%kkkkkkk %z&%deeeeeeeeeee' &{,&kkkkkkk &| &&EԸ?D&~ &!&K D&D&&-&&+ LL&deeeeeeeeeee'.'kkkkkkk '} ''ʡE?D'~ '!'' D'D''L&'deeeeeeeeeee'.(kkkkkkk ( ((LD(~ (!(( D(D((K&(deeeeeeeeeee'.)kkkkkkk )~ ))~jt?D)~ )!)) D)D))N&)deeeeeeeeeee'.*kkkkkkk * **I +?D*~ *!** D*D**O&*deeeeeeeeeee'.+kkkkkkk + + ++++- &+deeeeeeeeeee'8,kkkkkkk ,u ,u ,u,deeeeeeeeeee' --kkkkkkk-@! UD-A'  D-4D-A'  D- $-"Bk- @-UD-A'  D-4D-A'  D- $-"B - < - < - < - < -< -< -< -< -< -< -< -< - -<-#-C %!, #-w %!,#-K %!,-deeeeeeeeeee'V.kkkkkkdeeeeeeeeeee' /Z/iii /[ /ii / \/  //i /./ideeeeeeee'0 0]0 0< 0^ 0_ 0` 0a 0 0 a 0 \0 0 b0 0c0 0d0 0[ 0e 0f 04 05 0 0 0 00deeeeeeee' 1g 1h 1i 1j 1k 1 1 1l 1 1 m 1 n 1 4 1 o 1f 1p 1q 1=1 1n 1r 1= 1= 1= 1= 1s 1 1t1deeeeeeee'"1HUV2uuuuuuuuuuuuuuuuuuueeeeeee'33@+3_3DULA'  L4LA'  L ,"B3 @33 _3D ULA'  L4LA'  L ,"B3 a 3 3D LA' LA' B%LLLLBLLA'LLA'3 33 3D LD LD  ,LA' LA' B%LDLDBLLA'D"B~ 3 3 < 3 3D LD LD :L%BfL%Bf=D%BfL%Bf"BL%Bf3333 3DL L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B#3 %33 ~ 33333DL oLLA NL L+LLL?L""B3O 3G3D=L LLLLLB333%3DL%BfL3d3%3DL%BfL33%3DL%BfL+33D3D3D3L#3 %333333%3DL% BfL!3F D3D33eeeeeeee'44@4 34 @43 4 3 3 4 43 ~ 4 4  3 44434444D -~ 44434 34434434434444DLLL444D -4434<44D LL4eeeeeeee'55@4 35 @5 3 5 53 5  3 ~ 5 5  3 555354~ 55h35^35535Z3553545545535+45deeeeeeeee'66@6 36 @63 6 5 3 6  3 ~ 6 6 R 3 6663664~ 6663663636636D36646946636E46deeeeeeeeeee'77@6 37 @73 7 D3 7 Q 3 ~ 7 7  3 777374~ 77737F37F37F37737F47A4773747deeeeeeeee'88@8 38 @83 8 7 3 8  3 ~ 8 8 @ 3 8883884~ 8883838838838838484883848eeeeeeeee'99@8 39 @9 3 9 93 9 93 ~ 9 9  3 99939b4~ 9993939939939939a494993949deeeeeeeee'::@: 3: @:3 : 9 3 :  3 ~ : : M 3 :::3:F4~ :::3::3::3:b3::3::4:84::3:4:deeeeeeeee';;@; 3; @;3 ; : 3 ; ;3 ~ ; ;  3 ;;;3;4~ ;;;3; 3;m3;A3;;3;;4;d4;;3;A4;deeeeeeeee'<<@; 3< @< 3 < <3 < <3 ~ < < ' 3 <<<3<l4~ << 3<3<<3<@3<3<4<<4<<3<4<deeeeeeeee'==@< 3= @=3 = g 3 = =3 ~ = =  3 ==33=4~ ===3=> 3==3= 3=33=4==4==3=4=deeeeeeeee'>>@> 3> @>3 > = 3 > >3 ~ > > Y 3 >>>3>4~ >>>3>>3>>3>` 3>>3>B4>>4>3>)4>deeeeeeeee'??@> 3? @? 3 ? ?3 ?  3 ~ ? ?  3 ???3??4~ ???3?3?X3??3??3??4?4??3?N4?deeeeeeeee'D9lpppiZZ^^^^^^^^^^@3A3B3C3D3E3F3G3H3I3J3K3L3M3N3O3PVQVRVSVTVUVVVWVXVYVZV[V\V]V^V_V@@@? 3@ @@3 @ = 3 @  3 ~ @ @  3 @@@3@i4~ @@@3@3@@3@@3@@3@4@4@@3@h4@deeeeeeeee'AA@@ 3A @A 3 A A3 A A3 ~ A A l 3 AAA3A4~ AA 3AJ3AA3AA3AA3A4Ah4AA3Ae4Adeeeeeeeee'BB@A 3B @B 3 B B3 B @ 3 ~ B B  3 BBB3BB4~ BBB3Bf3BB3BB3B3Bk4BB4BB3B(4Bdeeeeeeeeeee' B12CC@C 3C @C3 C B 3 C C3 ~ C C  3 CCC3C 4~ CCC3C 3C3C3CC3Ch4CC4CC3C4Cdeeeeeeeeeee'DkD@D 3D @D3 D C 3 D  3 ~ D D D3 DD3 3DC4~ DDD3DD3DD3DK3D3DD4DC4DD3D4Ddeeeeeeeeeee',Ekkkk Eu Eu Eu Eu Eu Eu Eu Eu EuEdeeeeeeeeeee' FvFkkkkkkF @D UDFA'  DF4DFA'  DF $F"BF F*FFF - F7FF7FF7FF#FF`FFRFFFFFFdeeeeeeeeeee',Gkkkkkkk Gw Gw Gw Gw Gw Gw Gw Gw GwGdeeeeeeeeeee'4Hkkkkkkk Hx&Hdeeeeeeeeeee'4Ikkkkkkk Iy&Ideeeeeeeeeee'4Jkkkkkkk Jz&Jdeeeeeeeeeee' K{,Kkkkkkkk K| KKEԸ? D&K~ K!Kp DKDKKsKKP LLKdeeeeeeeeeee'.Lkkkkkkk L} LLʡE? D'L~ L!LL DLDLLqKLdeeeeeeeeeee'.Mkkkkkkk M MM(D(M~ M!MM DMDMMrKMdeeeeeeeeeee'.Nkkkkkkk N~ NN~jt?D)N~ N!NN DNDNNsKNdeeeeeeeeeee'.Okkkkkkk O OOI +?)D*O~ O!OO DODOOtKOdeeeeeeeeeee'.Pkkkkkkk P P PPPPR KPdeeeeeeeeeee'8Qkkkkkkk Qu Qu QuQdeeeeeeeeeee' RRkkkkkkkR@F UDRA'  DR4DRA'  DR $R"BkR @RUDRA'  DR4DRA'  DR $R"B R < R < R < R < R< R< R< R< R< R< R< R< R R<R#R% %FQ #RR %FQ#R %FQRdeeeeeeeeeee'VSkkkkkkdeeeeeeeeeee' TZTiii T[ Tii T \T  TTi T.Tideeeeeeee'U U]U U< U^ U_ U` Ua U U a U \U U bU UcU UdU U[ Ue Uf U4 U5 U U U UUdeeeeeeee' Vg Vh Vi Vj Vk V V Vl V V m V n V 4 V o Vf Vp Vq V=V Vn Vr V= V= V= V= Vs V VtVdeeeeeeee'"VHUVWuuuuuuuuuuuuuuuuuuueeeeeee'XX@X X_XiULA'  L4LA'  L ,"BX @XX _Xi ULA'  L4LA'  L ,"BX PX Xi LA' LA' B%LLLLBLLA'LLA'X  X Xi LD LD  ,LA' LA' B%LDLDBLLA'D"B~ X X XX Xi LD LD :L%BfL%Bf=D%BfL%Bf"BL%BfXX> X XiL L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B#X %XX ~ XXXXXiL oLLA NL L+LLL?L""BXXXGXi=L LLLLLBXXX%XiL%BfLX'X%XiL%BfLXXX%XiL%BfL+XDXDXDXL#Xa %XXXXXX%XiL% BfL!X DXDXXeeeeeeee'YY@X XY @YX Y X Y A X ~ Y Y  X YYYXY>YYi -~ YYYXYXYYXYkXYYXYkYYiLLLYYYi -YkXYkYYi LLYeeeeeeee'ZZ@Y XZ @Z X Z ZX Z  X ~ Z Z O X ZZZXZEY~ ZZZXZZXZXZZXZZXZ5YZYZZXZYZdeeeeeeeee'[[@[ X[ @[X [ Z X [ 8 X ~ [ [ e X [[[X[Y~ [[[X[[X[X[[X[[X[fY[Y[[X[Y[deeeeeeeeeee'\\@\ X\ @\X \ [ X \  X ~ \ \ 9 X \\\X\_Y~ \\\X\\X\X\\X\\X\Y\Y\\X\Y\deeeeeeeee']]@] X] @]X ] \ X ] ]X ~ ] ]  X ]]]X] Y~ ]]]X]]X]]X]]X]]X]Y] Y]]X]Y]eeeeeeeee'^^@] X^ @^ X ^ ^X ^  X ~ ^ ^  X ^^^X^{Y~ ^^^X^X^<X^^X^^X^XY^iY^^X^Y^deeeeeeeee'__@_ X_ @_X _ ^ X _  X ~ _ _ g X ___X_CY~ ___X_X__X__X__X_Y_LY__X_Y_deeeeeeeee'D9l^^l^^pppiZZ^^^^^`3a3b3c3d3e3f3g3h3i3j3k3l3m3n3o3p(q(r(s(t(u(v(w(x(y(z({(|(}(~((``@_ X` @`X `  X ` m X ~ ` `  X ```X`OY~ ```X``X``X`!X``X`Y`Y``X`sY`deeeeeeeee'aa@` Xa @aX a  X a @ X ~ a a a X aaaXaY~ aaaXaaXaaXaaXaaXaYaYaaXaYadeeeeeeeee'bb@a Xb @bX b  X b $ X ~ b b M X bbbXbY~ bbbXb:XbbXbbXbXbYbfYbbXbYbdeeeeeeeee'cc@b Xc @c X c cX c  X ~ c c [ X cccXcY~ cccXccXccXccXccXcKYc"YccXcYcdeeeeeeeee'dd@c Xd @d X d dX d dX ~ d d c X dddXd+ Y~ dddXddXddXd=XddXdYd YddXdYddeeeeeeeee'ee@d Xe @e X e eX e C X ~ e e  X eeeXeeY~ eeeXe XeeXeeXeeXe(Ye8YeeXekYedeeeeeeeee'ff@e Xf @fX f _X f X X ~ f f < X fffXffY~ fffXfXffXfpXffXfBYfYffXfYfdeeeeeeeee'gg@f Xg @g X g gX g  X ~ g g h X gggXggY~ gggXggXgXg\XgXg"YgYggXgYgdeeeeeeeeeee' g12hh@h Xh @hX h g X h hX ~ h h X X hhhXhY~ hhhXhE XhhXhXhhXhhYhkYhhXhYhdeeeeeeeeeee'iki@i Xi @iX i h X i # X ~ i i n X iiiXiY~ iiiXiBXiiXiXiiXiiYi@YiiXi[Yideeeeeeeeeee',jkkkk ju ju ju ju ju ju ju ju jujdeeeeeeeeeee' kvkkkkkkkk @i UDkA'  Dk4DkA'  Dk $k"Bk kAkkk - kkk&kkYkkkkkkwkkYkkkkdeeeeeeeeeee',lkkkkkkk lw lw lw lw lw lw lw lw lwldeeeeeeeeeee'4mkkkkkkk mx&mdeeeeeeeeeee'4nkkkkkkk ny&ndeeeeeeeeeee'4okkkkkkk oz&odeeeeeeeeeee' p{,pkkkkkkk p| ppEԸ?pDKp~ p!ps DpDpp-ppu LLpdeeeeeeeeeee'.qkkkkkkk q} qqʡE?qDLq~ q!qq DqDqqMpqdeeeeeeeeeee'.rkkkkkkk r rrrDMr~ r!rr DrDrrpprdeeeeeeeeeee'.skkkkkkk s~ ss~jt?'DNs~ s!s& DsDssMpsdeeeeeeeeeee'.tkkkkkkk t ttI +?tDOt~ t!tt DtDttptdeeeeeeeeeee'.ukkkkkkk u u uuuuw pudeeeeeeeeeee'8vkkkkkkk vu vu vuvdeeeeeeeeeee' wwkkkkkkkw@k UDwA'  Dw4DwA'  Dw $w"Bkw @wUDwA'  Dw4DwA'  Dw $w"B w < w < w < w < w< w< w< w< w< w< w< w< w w<w#wk %kv #w %kv#ww %kvwdeeeeeeeeeee'Vxddddddddddeeeeeeeeeee'Vyddddddddddddddddddddddddddddeeeeeeeeeee'Vzddddddddddddddddddddddddddddeeeeeeeeeee'V{ddddddddddddddddddddddddddddeeeeeeeeeee'V|ddddddddddddddddddddddddddddeeeeeeeeeee'V}ddddddddddddddddddddddddddddeeeeeeeeeee'V~ddddddddddddddddddddddddddddeeeeeeeeeee'Vddddddddddddddddddddddddddddeeeeeeeeeee'Dk*l^^^^^^^l^^pppiZZZZZZZ((((w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(w(wVddddddddddddddddddddddddddddeeeeeeeeeee'Vddddddddddddddddddddddddddddeeeeeeeeeee'd   dd 5  ddd   dd  ddddd .dddddddddeeeeeeeeeee'    ee  eeeeee  :eeeeeeeeeeeeeeeeeeeeeeeee' z z z ee z zeeeeee  :eeeeeeeeeeeeeeeeeeeeeeeee'Veeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'Veeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'``@`@ "`@ AA~ (@Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'`,@@@ "@ AA~ `&@Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'`.@@@@ " @ AA~ `$@ eee   ee  eeeee .eeeeeeeeeeeeeeeeeee'`0@`@ @ "@  AA~ `"@Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'`1@ @ @ "@  AA~ ` @Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'`2@ @ @ "@  AA~ `@Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'`3@ @@@ "@  AA~ `@Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'`4@`@@ "@  AA~ `@ eee   eee 8eeeeeeeeeee'`5@ @@ "@ AA~ `@eeeeeee 8eeeeeeeeeeeeeeeeeeeeeeee'`6@@@ "@ AA~ `@eeeeeee 8eeeeeeeeeeeeeeeeeeeeeeee'`7@@@@ "`@ AA~ `@eeeeeee 8eeeeeeeeeeeeeeeeeeeeeeee'`8@`@@ "&@ AA~ `?eeeeeee 8eeeeeeeeeeeeeeeeeeeeeeee'`9@ @@ ``"0@ AA~ `eeeeeee 8eeeeeeeeeeeeeeeeeeeeeeee'l:@@@````eeeeeee 8eeeeeeeeeeeeeeeeeeeeeeee' l@@@P````eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l`@@P````eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l @ @ ````?Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l @"@ ```?`? eee   eee 8eeeeeeeeeeeeeeeeeeeeeeee' l"@@$@ ```@`?Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l`$@&@ ```@`Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l &@'@ ```@`?Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l'@)@ ```@`?Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l)@@+@ ```@`?Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l`+@-@ ```@`?Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l -@.@ ``` @`Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'DlZZZZxx(w(w(w(w(w(w(w(w(w(w l.@0@ ```"@`Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l0@@2@ ```&@`Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l`2@4@ ```(@`?Heeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' l 4@@4@.````eeeeeeeeeeee#1Zd?= %s"#1Zd? %s##R %s$# %s%8  !eeeeeee'Veeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'Veeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'Veeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'Veeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'Veeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'Veeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'xZZZZZh e e, e" e,  e: e : e@  F BI M T B` 333` -i  Lm $" ?# L   -  } %    / 0 ,      I < =     00,  5  p I J < x         V  W  /     -     ?  <! W( Xp- q- - '6 7  8 ; 0; ,? <B  C XC  K JL VN }R ~R R [ ` #a  d f  f pk Ik Wp =q s `w   >@dd   Sheet3ggD ZO 4   dMbP?_*+%&A Page &P&?'?(?)?"P??&U} m } $} $4                                      LLLLL L L L          UUUU UUUU UUUU UUUU UUUU UUUU UUUU  UUUU  UUUU  UUUU  UUUU  UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU UUUU DXl>~  ! " # $ % & ' ( ) * + , - . / 0 1 3  UUUU !UUUU "UUUU #UUUU $UUUU %UUUU &UUUU 'UUUU (UUUU )UUUU *UUUU +UUUU ,UUUU -UUUU .UUUU /UUUU 0UUUU 1UUUU 3UUUU *h>@UR Sheet4ggD ZO o  dMbP?_*+%&A Page &P&?'?(?)?"P??&U} m } $} $                 LLLLL L L         ______```______```______```______```______```______```______``` ______``` ______``` ______``` ______``` ______```______``` UUU$f,:p>@  Sheet5ggD ThisWorkbookSheet1 modTransferData  Sheet3  !"#$%&'()*+,-./123456789:;<=>?-#ѷ(<N0{00020819-0000-0000-C000-000000000046}@ 0ic%@xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2-#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 0%@xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 R LX H P &@ 2h R  8 8 Xx  ""  8@   (8P    8 P h  8 . (  0P` hx P h  .  & @ H P dX "      ( 8 0$$xME(<8<<<`Hʐ28L6hxx%%% >`77`@`B`D \`^ d@`^ bxih`j`D`l`n`p rhH`L t v x@  z` | ~ @  `   @ ` ` f0 i`j`D`l`n`p r`L  8 xX   8   x X       ` ` + ) %+ ` +`x jjil in ip )t  )v` h  @ )x  )z  )|8 @   )  ` )  ) )X` 8)~ ) iB (%``L+ ]] ilinip)X` 8) ) )08 )x X) ) )PX 0) xiB %``L+Hh&&)%ilip`@`L``` ()%i@ %  %+`)%`j`Lʐ.Lʐ0Lʐ40L:< (H@80h0 `x` (g=S R :X  FH  X h p x  d "    8 H X h x      V , " @ H P X ` h p            ( 8 @ H  X  h  V h  `px   "  ` 0X  " < PBp  L : Xhpx   P  ( @ X"h:  08 @H 6P   N *$H p x  ,J $J@ ,J .J@ 0J 0J@ &J $J0 J (J ,hJ L@ HP 2X  8 H PX Vh@  .(0 2P:( V0  V ,8 Vh "     0 @ P ` p         !h!2! !!! ! !" "" @" `P" 0"" " #" # H#<h# #B# $$ L $ :p$ $$$$$ $% %% P % p% % % %"%%:&@& H& P&p&&& && 6&& &'' ' N ' *p'$' ' ' ' $'0( 2H(0( (0( .)00) 2`)0) f)00* <`*0* 4*0+ (8+0`+ +L++ ++ 2, 8, @,`,8h, ,@, F,@-H- P-h-h-2- . .0.`.x.... 2./H/P/X/`/x////:/0 V0`0x00 00000 B0 D1B H1"P1x1 D1B11 1 x222222 L2 @3B @3H3P3X3  `3p33d33444 (4d84444 >4455 05(@5 h5(p5 55 555 5(5  6((6 P6X6 `6p66 6(6 6(6 77 7(7@7 X7(h7 7(7 77 777 8( 8 H8(P8 x88 888 8(8 9(9 0989 @9P9h9 9(9 9(9 99 9: : 8:(H: p:(x: :: ::.: ;@; X;@`; ;; ;;; L; @ <B `<h<p<x<  <<<d<= =(=0= H=dX==== >=> >8> P>(`> >(> >> >>> ?(? @?(H? p?x? ??? ?(? ?(@ (@0@ 8@H@`@ x@(@ @(@ @@ @AA 0A(@A hA(pA AA AAA A(A  B((B PBXB `BpB.B B@B C@C PCXC `CpCxC LC PC 8 D VXD TD $E 20EB hEpExEEEE  E EEE E F Fj0F F FF FF FG G  G@G PGXG `G G G GG GGG ZG" 8H@HHH  PH"`H HH HH "H HI 0I8IPIXI X`I IB III I I IJ (J &8J4`JJ FJJJ J KKK K0KK'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''3 Web revenue/expense transfer program, version 1.24 Kenrick Mock, 9/16/03? 9/16/03 Added support for "Other revenue sources - Private"L 1/8/02 changed while loop in ProcessExpense/Revenue to <= instead of <E to get the last row's data in case of a short grand totalA 1/8/02 Added extra case in ProcessRevenue and ProcessExpenseI in case there is a "total" and a change in fund, to recognize the new fund and org+ Send any questions to afkjm@uaa.alaska.eduK'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''1 Names of the worksheets to transfer data from/to]$Web Revenue Summary]$Web Expense Summary]$detail]$1041108]@0]@h]@ Clear the detail worksheet]]0]H 2$F.< First clear the revenue'BPlease enter the LAST row number where you would like data to be cleared. Data will be cleared from row 5 down to this row number.Enter end of range to clear$H'@ @|k @X 'D B D B <%J'@ @1000 @1900 @2000 @3000 @4000 @4500 @5000 @6000 @7000 @8000 B <,J B <,J B <,J B <,J B <,J LP e'N*There was an error, end of data not found! RA@PT(k  B 'BClearing Revenue Row BX !V(XA@ Now clear the expenses B 'D'B B D B <%J'@ @9100 @9150 @9210 @9600 @9700 @9801 @9802 @9900 @9960 @$Other B <,J B <,J B <,J B <,JkH B 'BClearing Expense Row BX !V(XA@ !V(XDone clearing the data! ZA@PT.<o^ The main routine to transfer data from the expense form to the summary spreadsheets in memory`]If WarningMsg = False Then Exit SubEnd If .$F.6 0$F.: 2$F.< :$`'^ ^A@b.6.:.<ox^ The main routine to transfer data from the revenue form to the summary spreadsheets in memory](If WarningMsg = False Then Exit SubEnd If .$F.6 0$F.: 2$F.< 6$`'^ ^A@f.6.:.<oHO Loop through all the funds/orgs in the Expense worksheet and process each one.& Assumed that FUND starts in column C!@]]]]]]0]p]]]]H]]]]H]]]]H]` :$'D !'j h'lF'nF'p L L+tF L+vF L+xF L+zF L+| L+F L+F L+F L+F L+~F L+ L'' j D Get a line L j L :%J L+r LY First check for a case that we read in a complete chunk of info. If we did, process it!* This section checks for the fund changing$r$  Fund is a number l$r'l4 Initial case$r l e'4/ Found a new number different from current fund$r l e$r'l4. New fund, we already finished processing datak@d8 E Fund is not a number and its not blank, process chunk if we have one$r$Total:$r$Fund 'd'l0 Resetkh$re'k@k8IThis section checks for the org changing, if we finished a chunk of info. $r$  Org is a number n$r'n4 Initial case$r ne'4. Found a new number different from current orgk d  Org is not a number$r'k k k 0 If account title is blank, we completed a chunk$r'kP H  G No completed chunk, add current line's info to collection of the chunk$r$rTotal:$r'p4 Get the programk Process data'$r$Capital Expenditures$rX+tF$rX+tF$rX+t$r$ Commoditiese$rX+vF$rX+vF$rX+v$r$Contractual Servicese$rX+xF$rX+xF$rX+x$r$Miscellaneous Expensese$rX+zF$rX+zF$rX+z$r$Non-Mandatory Transferse$rX+|F$rX+|F$rX+|$r$Personal Services Costse$rX+F$rX+F$rX+$r$Staff Benefitse$rX+F$rX+F$rX+$r$ Student Aide$rX+F$rX+F$rX+$r$Travele$rX+F$rX+F$rX+$r$Items for Resalee$rX+F$rX+F$rX+$r$Mandatory Transferse$rX+~F$rX+~F$rX+~d2Error on Expense - Don't understand account type: $r RA@Pkd , Complete a chunk, process it and start anew' n l '[ Processing l  p  n PROCESS DATA HERE l n p t v x z |     ~  j$J Some kind of error, quit now. Error message should already be displayed.|PkH Reset variables L L+tF L+vF L+xF L+zF L+| L+F L+F L+F L+F L+F L+~ L( Set the new fund or org if there is one$r$ $r l$r'lk$r$Total:e, Erase current fund if we hit a "total" line'lkh$r$ $r n$r'nk d'n0+ Reset org if we finished a chunk each timekO If this line has data in it, we have to process it before incrementing lCurRow$rXkPkHk@ j 'j(o P Loop through all the funds/orgs in the Revenue worksheet and process each one.& Assumed that FUND starts in column C!O This is about equivalent to the ProcesExpense routine, but just puts data into different places.x]]] ]8]P]h]]]]@]]] ]@ ] ] ] ] 6$'D !'j 'lF'nF'p L L+F L+F L+F L+F L+F L+ L+F L+F L+ L'' j D Get a line L j L 6%J L+r LY First check for a case that we read in a complete chunk of info. If we did, process it!* This section checks for the fund changing$r$  Fund is a number l$r'l4 Initial case$r l e'4/ Found a new number different from current fund$r l e$r'l4. New fund, we already finished processing datakd E Fund is not a number and its not blank, process chunk if we have one$r$Total:$r$Fund 'd0'l0 Resetk$re'kkIThis section checks for the org changing, if we finished a chunk of info. $r$  Org is a number n$r'n4 Initial case$r ne'4. Found a new number different from current orgkd Org is not a number$r'khk`kX0 If account title is blank, we completed a chunk$r'k  G No completed chunk, add current line's info to collection of the chunk$r$rTotal:$r'p4 Get the programk0 Process data'$r$ Student Fees$rX+F$rX+$r$Government Appropriationse$rX+F$rX+$r$Aux Ente$rX+F$rX+$r$Indirect Cost Recoverye$rX+F$rX+$r$Inter/Intra Campus Revenuee$rX+F$rX+$r$Other Revenue Sources$r$Other Revenue Sources - Privatee$rX+F$rX+$r$#Sales & Services of Education Dept.e$rX+F$rX+$r$Donations & Endowment Incomee$rX+F$rX+$r$Interest Incomee$rX+F$rX+dh2Error on Revenue - Don't understand account type: $r RA@Pkd , Complete a chunk, process it and start anew' n l '[ Processing l  p  n PROCESS DATA HERE l n p          j$ @ Some kind of error, exit... we already printed an error message|k Reset variables L L+F L+F L+F L+F L+F L+ L+F L+F L+ L( Set the new fund or org if there is one$r$ $r l$r'lkX$r$Total:e, Erase current fund if we hit a "total" line'l$r$r$r$re'lk$r$ $r n$r'nkX$re'n0+ Reset org if we finished a chunk each timekO If this line has data in it, we have to process it before incrementing lCurRow$rkxkpkh j 'jPoH< Returns the last row for the Expense or Revenue worksheets.> Dependent on column G being filled all the way to the bottom!0 G1 %%!'i= Display a message about how to set things up before we begin ] rMake sure you enter a '*' at the end of the code, and position the cursor in the row you want processing to begin. Spreadsheet Converter$P' 'dh 'kX iP E Add the extracted expense information to the management spreadsheet.9 Return true if successful, false if some error occurred. ]]0]H.  nA@ !+Couldn't find on the management worksheet: l  n Near Row: B RA@P'z k  l p$'  +Couldn't find on the management worksheet; l  n Near Row: B RA@P'zP kH 8 Start adding the stuff we know into the row we selected. L L$ L L$   L <,Jd L$   L <,Jk` kX  L L L$ L L$   L <,Jd L$   L <,Jk k  L L L$ L L$   L <,Jd L$   L <,Jkk L L L$x L L$x   L <,Jdh L$x   L <,Jk8k0 L L L$v L L$v   L <,Jd L$v   L <,Jkkx L L L$ L L$   L <,Jd L$   L <,Jkk L L L$t L L$t   L <,Jd@ L$t   L <,Jkk L L L$ L L$   L <,Jd L$   L <,JkXkP L L L$z L$| L$~  L L$z L$| L$~   L <,Jd L$z L$| L$~   L <,JkXkP L'i0E Add the extracted revenue information to the management spreadsheet.9 Return true if successful, false if some error occurred.`]]].  nA@ !+Couldn't find on the management worksheet: l  n Near Row: B RA@P'zk  l p$'  +Couldn't find on the management worksheet; l  n Near Row: B RA@P'z0k(8 Start adding the stuff we know into the row we selected. L L$ L L$  L <,Jdp L$   L <,Jk@k8 L L L$ L L$  L <,Jd L$   L <,Jkk L L L$ L L$  L <,Jd L$   L <,Jk?k? L L L$ L L$  L <,JdH? L$   L <,Jk?k? L L L$ L L$  L <,Jd> L$   L <,Jk`>kX> L L L$ L L$  L <,Jd= L$   L <,Jk=k= L L L$ L$ L$  L L$ L$ L$  L <,Jd< L$ L$ L$   L <,Jk<k< L'i<F Returns the "best" match on the management worksheet for a given Org.J The best match is if the org, the fund, and the program string all match.2 The second best is if the org and the fund match.P The last best is just the org matching (anything passed in the dictRows object)N If the curFund is different from the general fund, we require that it must be a match or we'll discard it., Returns -1 if there was some kind of error.]]]]]0'' L ! ' L % <%J'@ l 4 @ l$ ' Y Bad and generate error if the fund is not general and not listed on the management sheetkX9 @ p$  'k 9d9 @ l$  'k8 @ p$  'k8k8 See if this is the best   ' L %'kH8 L 'i(8S Returns the rows for the occurence of a particular string in the dictionary objectH]] B@ @A:A <%%.  ! ! B@ ._07 A:A <%%. ! ! ! ! B@k6 ! !k6o6R Looks "up" for the fund in the event that we are restarting on a row with no fund listed.(]]'` !'j j %J$ j 'L L L %J$$ L %J'`: Found a fund, return itz`5 L %J$e: Some non-fund thing, just exit'`z5k5 L 'L4k4i44ֶAttribute VB_Name = "modTransferData" 'H Web revenue/expense tr program, version 1.245Kenrick Mock, 9/ 16/03  Added support for "Othern sources - Pr`ivateo 1/8/02 chang!while loop( inosE V/R^ to <= stead of <H)Cget A last row0's d+caÀ|a shX|nd*tal#Klex JFaPrSEe is a H"to" a>&fund,7recognize4new  BorgSe@!any ques tosAafkjm@uaa.a@Aka.edu@ F Op CompareL T@K' AsAgA-worksh8eetB&dfrom/to PublicnlREVENUEA[SummaryJ EXPENSF T SUMMARYdetailGENERALFUND 104110 ( wsE$As WE7 d 9ClearW ' c$Sub Dd () A_Dim s S0trin@DlRowLoLd.S hws=s(' c' Fir6c"(= 5s*InputBox("P@@rent`ELASTv numb`we you !uld likey }be Abed. a will  L 5 downacth q$ .",x "EAigoc "DIf*" Thenca+ExitMb#REqIfcle+= CLng(s$ W#.< C $/.Cells(A(, 1(!"1000") Or 92345 678$!s3)lkAeS4_%%5_E6_E7MElsBe1l > $0LCbFinidTru`]EqMsg`0 "Twa bn err0or, (rRno u0b!*vbCr0itic1kGoTo (Func$)8b+ 1xcel.ActiveWin2x.Ca^`/GE O+" + CF#))DoEtsW SaHBX32 -5 fD?O4 QO4E121_4 "9`4Y4915Z/92@`X69`0G`08012\:9Left(s, 3,Ҕ4O2ow0B_2#7vG2uJ2hQ` bO(O(aI(vO(' O(SE..$9Donf0ajQ98InPma 7:39mtNogw19SuG c㒰 maТrpoutim qջ1leзmqp spr@memoryzuJ`CdE nd Sub ' Loop through allXe funds/orgs inDExpense worksheet aprocess each one. ' Assumedlat FUND startcolumn C! Pr ivate PGd(sInitialFValQ String) Dim lCurRow!LongLasts2R'1 Org PgramLine(7) ] OdCapital(3@DoubleCd@CommodesntractualServiCMisc NonMqatoryResalePersonA;StaffS@tudentTPraveQbQpletedChunkfBooleanZbDidSometh@N l= Get8(wsDģŢ= ActiveCe8ll.= : = ""CEAFor l = 1 To 3AFl)@0: ʎOC*B 976D4MFG Next lc8= False 8JWhilef<= 9 ''!:p a lw-7!s"}B&@.a=s($@,5+ 2Ba' First check f@;a ca thwe readomBX`AXoffo. If did, it c This se)QonC sb thc`ang^ @(c1)) > 0 Thefg " a numberk$]""PA h%% ' ;$ E@@  <^>bi@(CTrue)L+ 7o Fnewd differ from cur "]5( ' N a,FalaKy fhini |d#Odata 0If7 no3%c i~AblankW*cXi+h[!;0Tri&mh(pPTor:" Or _&_ ueO  ; %/Us' NetE! 1.4s o o ='OCGC6C, v$JJ xdZ?aMH3Ha' g OH(1tcxa4H H!SgFerFF/% i=`af accXt titp~ bFpqcdsdZG & 4 4`p1>::?\/(Zo  , adddщ'fo tlld}6|,f2)qqpAE-$%U*1w60'1]1'u fZ"P _n4Ap= Pures` ౔B1CDbldf5))= 6/7)Ȟq@ pP  _ ?R    ElseIf Trim(sLine(4)) = "Contractual Services" Then MdXV(1CDbl5)): R2 )6)3 )7)) Miscellaneous Expensh` Y QNon-Mand atoryansferV/ Z7/P@*on Cost/ .-7,Staff Benefi) )S('udent AidStV'C'?5TraveltS?5Items for Resalevtsu}d|MsgBo@x "Err*on - Don@'t undt accouWtype: " & , vbCriticalo ReturEnpd Ifg+'mplete a chunk, pros it star!DewKbCo#dfCFa`sCurOrg <> "" A@!F@HbDidSomething3k= a>Debug.Pri(|"Pc B)`"& +`gram -"-! ' PROCESS DATA HEREOAddr(, p4,}@apitalommodes5P!r`Ig\rSrI@f,#7, lRo>wq2'  kiof Be,, qu`"n ow. -message should already be displayeLd._ExSub},@'Jet variaPblesF7l)1 To 3IdC3(lq0bIJSxofTJ#Next /D the new f:J;if `re is oLne/P/Va1 > 0$2SMPpAE2f=4Q1"ӡ кTo 8:n Erase pcurrq`we h`+a "t1" l@ ""/O 3SVjWy Q3? Ses UO8_Et ;o&finishe`Ch ea@ch tim/' {c' o** has a i2nm,  t2onbe-ncremcQ&4)$l$ GopG^u@a! T?`V{ + 1Wend AT ' Looproug*hpYleR>s/ ~nRevenue work AaU0@@\' Assumthat FUN D ҂column C! '= about ePcvaoB+Ts t`4, bjust p$utftodi~fݡ8@e0v6aP $ (s$InualAs( StgT.Dimp png0Last r̵ Dim sCurFund As StringD OrghP@rogram 0e]Aa a numberk$U""Pg Z*1)j' D]$ E@@  <>(CTrmL+ &oAewd d iffer from cur "])(E6c' N =, FalaKy finishedGA0data `(Ifg!.+GAnotU A aits AblankTciWhave onDye`:TrimPTotal:" Or L @T*aA!a([_' Reset 0! .4sn o +{E<'OCGCo5C, v$LJwltdZw?aMH3Ha' g OH(_qc3HH?hH!ThSGFerFFA2s5i<Z#(8 (O =f accX`t titp~ bFtesd!tq) & 4 `w@1::?\/(2 Zo  Q, Xadddщ'}nfo tlld}6|2Qf0SCA?-$%U*1w60ǧ;]q' T fZua_4Aa Fees_` vA0= CDbU5<))@$Q6)ht>O0ernmQAppriat  ՟b03td1q!St CoRecoveryocdĿ /e.//Pra CampuswO F   " Op2r SourC1m(sLine(4)) = "Other Revenue Sources - Private" Then dn(1CDbl5)): 6"2 66)) ElseIf Tri Sal& Serviof Education Dept.;KDonAs & Endowment IncomeH7IInteres?BCb"MsgBox "Er0ror i- 8't understand accouMtyp0e: "R, vbCriticalRetur㌢@a If K' Complete a chunk, pro@`s it $%r)AewbEdCs @Fa sCurOrg <> "" A8AF<bDidSthing = Debug.Q"P2wR"B&@Vgram@Z"[ ! ' PROCESS DATA 0HERE Add<(E, ! D, dStuFdd GovAuxIndirectB@X"tccS, lRowb#(Ac!. ki@2@eS, exit... w BlrehadyBih@Sn  messa,geE E S\ub/MR%'set variaVbOF`glL1 To 2A )(l 0*+,)`-# ?a'2Ne(xt y't new fe!hifre is p0PVa%1> 08A@tV|G= 3$=A Total:a<' Erase cur^r!̢#" Vha "ta" l""O v` KoR`L3&4! 1?r3SV Xo y Q3? uo uAo/0finisheHk each tim0a p'P`4 41" has d@ata inPo,Ohave toCOpbefoq7ncreAe$W/$vp /GoM aQwc% = 0S+ 1Wend bZ 1sF la`roGGHExpen`7Am workets.P!9 column G befill1llwayqbottom!T 4 zcGetLP m(ws As W)pLong ws.Range(@"G1"). (xlDown).3%cDisp l am about h airps up R (begin Warn @(r BooleaDim v Vnnt Sv ("Make su&you 0`a '*'l asa P{code,posburs0-wap$ ."OKCancel, "Sp@nverq"@- x Tru$9@#!/JH(Ѫq CR#rractp$e(inma" mans' S*3 t csuc!7fufBPdoc"fd7N 1sFaSt>rP-idCapi0o"DouGЏ`еmodesntaualC%Misc,NonMмatorZyPǠllSptaff>Ҫ\TrRs Res0l9!L=/3a!3dict@R@Dcary3%l~BPX#SSc&= N0T@ary FindAll dictRows, sCurOrg xIfd.Count = 0 Then>Msg Box ">ld n't f on the ma@nagemerworksheet : " &gFutnd "xNPear :)l, vbCri ticalzAddExpensesFalse Exit actioEnIf"lBesyX( PProgpram)< ;@r' Start addingostuff we know intorselectebdDSetUNothFor l1 To 3Personal(l) <>S DJ@wsSumm.@Cells(f+ 1, 2 + q= dH E A3Next YGdffFyF2I# " "` "t "#XFTraveF MF F3" "" " ""ContractualServic~eaj!Ua<4$?&:& '&?  ikm/Commod&=K/n5& %% %8 L_& [Resale?Ia2q^7%x+ 6vAOIO#xZlCapitlCxl7#Ph#_ 5d E@dStud0?#O F 8_Y_ ~@(@(dMisc+ dNonMandatory$\) T10 ojooo__ )Trup± ' PQted revenuefor4ma 4spPread.qR0etur` i f sucxsf`ul, f1Bo@me errPoccurredPrivatef5! R3( d Asr- i&8)QDouble, dGov"(AuxIndirnter<O0=Sbs|DteLIn"k! Long BooleaDimGǀDpfTQs*#S}ew ]__ws_9______1%]Revenue = False  Exit FunctionXEnd If,lBestRowind(dic*s, sCu r|dProgram)xIf ~< 0 Theb|MsgBox "Couldn't f` on the management worksheet; " &p ""OrgNear :)l, vbCrit0icalJ=Add5' Start addingUstuff we kninto r sel ected>Se t Noth# For l 1 To 2 VAdStud(l) <> wsSummary.Cells(f+ 2,@ 13 + = HG EA=4 Next mGGov?FF3 FC2q2[ C3-= N҇E+޲Row End Function ' Returns the rows for0occurence of a particular str@ing inNdiary object Private Sub FindAl l(dcts As D1, BSP) Dim r&RangeFirst [.RemovemSetI= wsSummP.)("A:AH").L(s:If NoIshpTheI2Add r.e>,57R= r Do KNext(rMQr.?ress <> r5 W[A AIf)Loop Whil @|ks "up"fueventat we areston wi@th no A ' liste 0Val()A AayHws' FoA6a/]" i|mExit(Else!aX""%' SHome`>n-Etq, ju e K E3 9Qi^0 0end ]Až -?#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 0%@xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Sheet4 0Sheet5@_VBA_PROJECTdirP-f#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 0'0%@xAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2-e#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 01-%@xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2qdctRowsrirFirst< RemoveAllFindnAddrFindNextuAddressSheet3Sheet4Sheet5Workbookk "$' + -  l#1.9#0#C:\Program Files\Microsoft Office\Root\0* pHd VBAProject4@j = r g=S J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\Syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE16\MSO.0DLL#M 1@6.0 Ob LibraryK Scripting>_ripAingt je420B28UE718-11CF-893D20C9054@228}#1Ucrrun.dllH* Runti,me"|ThisW     orkbookG T~ isWrkbo 2 HBj13@B,Q!E"B+BSheet1GS@#et14H2NmodTransferDa`taG=d@TransUeD@t2 O)6'~"$$V!"3"3"3"3"?04 4 4 4 >f 5 5 5 5 e b+scrrun.dll#Microsoft Scripting ThisWorkbookThisWorkbookSheet1Sheet1Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5modTransferDatamodTransferDataThisWorPROJECTwm]PROJECT `ySummaryInformation(jDocumentSummaryInformation8o|ID="{314A79A0-D49D-4384-8930-1BB8BC6431EB}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Module=modTransferData Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="7D7FB4354CB650B650B650B650" DPB="FAF833BCB1BDB1BDB1" GC="7775BE4346BDC2BEC2BE3D" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C Sheet4=0, 0, 0, 0, C Sheet5=0, 0, 0, 0, C modTransferData=25, 25, 1360, 678, ޳ j_ Oh+'0HPx  Budget Dev. & Maint Offc - UA 1Raegan KelliherMicrosoft Excel@o@T8@2NSExSUMMARYH GENERALFUND wsRevenue Worksh ՜.+,0LHa   *\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.9#0#C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE#Microsoft Excel 16.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\System32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.8#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE16\MSO.DLL#Microsoft Office 16.0 Object Library*\G{420B2830-E718-11CF-893D-00A0C9054228}#1.0#0#C:\Windows\System32\scrrun.dll#Microsoft Scripting Runtimeg=SThisWorkbook016724f6fb'ThisWorkbookE3 Sheet1026724f6fb+ Sheet13modTransferData036724f6fb,modTransferData$$06 Sheet3046724f6fb Sheet3?H3 Sheet4056724f6fb Sheet4f`3 Sheet5066724f6fb Sheet5ex30H`xn-I;JU{b*G%3]OO!QVI"= dNonMandatory{ dMandatory dResale dPersonalXxdStaff{dStudent`dTravelbCompletedChunk bDidSomething GetLastRow ActiveCellRowValTrim@ProcessExpLine AddExpenses  sInitialFundzgdGovxZdAuxB; dIndirectcdInterÙdOthergdSalesAdDonate* dInterestProcessRevLine AddRevenue ws_Range xlDown0D WarningMsgvm vbOKCancelx?dictRowso DictionarylBestRow_ZFindAllB;Count0v FindBestRow+lSumlBestValmKeysP X`hp x  detailpayrollWeb Expense SummaryWeb Revenue Summarydetail!Print_Areapayroll!Print_Areadetail!Print_Titles  Worksheets Named Ranges FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89qCompObjuk