ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FWorkbooks_VBA_PROJECT_CUR" @,xPVBA |` ZO\pRaegan Kelliher Ba= ThisWorkbook=BT8Q@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1Arial1 Arial1, Arial1,Arial1 Arial1 Arial1 Arial1Arial1Arial1Arial1Arial1Arial1.Times New Roman1. Times New Roman1.Times New Roman1. Times New Roman1. Times New Roman1.Times New Roman1.Times New Roman1.,>Times New Roman1.>Times New Roman1.>Times New Roman1.>Times New Roman1. Times New Roman1.Times New Roman1.?Times New Roman1h>Cambria1.Times New Roman1. Times New Roman1 Arial1 Arial1Arial"$"#,##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\);_(* "-"??_);_(@_)4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)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/yym/dmmmm\ d\,\ yyyy "$"#,##0.00$[$-409]dddd\,\ mmmm\ dd\,\ yyyy[$-409]h:mm:ss\ AM/PM                                                                      ff + ) , * ! "  # P $ P % % &   ' ` (      )   * + a8 , "     @ #8@  (@  ,@  "8@  w@   (       ! $ # "      % % # ! # !  $     ! " " "  @ " !  # $@ $ $    !@    %$ ! %!   (  ) (  @   " $ $ !@@    @@  @ &@  &p  &  " "@  "@  @ #@ $@ $ @  @ " !   # " "  "     "  !@@   !    )  )  !@  !@ &@@  &@  & @  "@ " "@  "@  &@  &  "@   @ !@   @  % ! @ &  $ @ &@ & ! + " @  "  " " " " " -%  -%   -%$ -%$  % -  -  -  -$ -$    @ "      -"  " .   @  @  p@ "   # "@ "@ "@ "@ # /"X  ( "x@@ "x@  h@@ "xw@ @    &x@  &x "x@  h@ "xw@  "x@  "x   h@  "xw@   (@  (  (w@  @  @  p@ 1&<@ 1&<  p@  ,p@  "8   @   @ "8   ,@   ,w@ "8@ "8 "@ "8w@  @  @  @  @  @  @ $@  @ "@ "0 "@ "0 ||3>}<} yyyy00\)ef);_(@_)(}<} yyyy00\)ef);_(@_)(}<} yyyy00\)ef);_(@_)(}<} yyyy00\)ef);_(@_)(}<} yyyy00\)ef);_(@_)(}<} yyyy00\)ef );_(@_)(}<} yyyy00\)L);_(@_)(}<} yyyy00\)L);_(@_)(}<} yyyy00\)L);_(@_)(}<} yyyy00\)L);_(@_)(}<} yyyy00\)L);_(@_)(}<} yyyy00\)L );_(@_)(}<} yyyy00\)23);_(@_)(}<} yyyy00\)23);_(@_)(}<} yyyy00\)23);_(@_)(}<} yyyy00\)23);_(@_)(}<}  yyyy00\)23);_(@_)(}<}! yyyy00\)23 );_(@_)(}<}" yyyy00\));_(@_)(}<}# yyyy00\));_(@_)(}<}$ yyyy00\));_(@_)(}<}% yyyy00\));_(@_)(}<}& yyyy00\));_(@_)(}<}' yyyy00\) );_(@_)(}<}( yyyy00\));_(@_)(}}) }yyyy00\));_(@_)(   }}* yyyy00\));_(@_)(??? ??? ??? ???}(}/ yyyy00\)}<}0 ayyyy00\));_(@_)(}<}1 yyyy00\));_(@_)(}<}2 yyyy00\)?);_(@_)(}<}3 yyyy00\)23);_(@_)(}(}4 yyyy00\)}}5 ??vyyyy00\)̙);_(@_)(   }<}6 }yyyy00\));_(@_)(}<}7 eyyyy00\));_(@_)(}x}8yyyy00\));_(@_)(  }}9 ???yyyy00\));_(@_)(??? ??? ??? ???}-}; yyyy00\)}P}< yyyy00\));_(@_)( }(}= yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} yyyy00\)}(} pyyyy00\) 20% - Accent1H 20% - Accent1 ef  20% - Accent2H" 20% - Accent2 ef  20% - Accent3H& 20% - Accent3 ef  20% - Accent4H* 20% - Accent4 ef  20% - Accent5H. 20% - Accent5 ef  20% - Accent6H2 20% - Accent6  ef  40% - Accent1H 40% - Accent1 L  40% - Accent2H# 40% - Accent2 L渷  40% - Accent3H' 40% - Accent3 L  40% - Accent4H+ 40% - Accent4 L  40% - Accent5H/ 40% - Accent5 L  40% - Accent6H3 40% - Accent6  Lմ  60% - Accent1H 60% - Accent1 23  60% - Accent2H$ 60% - Accent2 23ږ  60% - Accent3H( 60% - Accent3 23כ  60% - Accent4H, 60% - Accent4 23  60% - Accent5H0 60% - Accent5 23 ! 60% - Accent6H4 60% - Accent6  23  "Accent1<Accent1 O  #Accent2<!Accent2 PM  $Accent3<%Accent3 Y  %Accent4<)Accent4 d  &Accent5<-Accent5 K  'Accent6<1Accent6  F (Bad4Bad  ) Calculation| Calculation  } * Check Cellz Check Cell  ????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextB5Explanatory Text  0Good6Good  a1 Heading 1B Heading 1 I}O2 Heading 2B Heading 2 I}?3 Heading 3B Heading 3 I}234 Heading 44 Heading 4 I} 5InputpInput ̙ ??v 6 Linked CellF Linked Cell } 7Neutral<Neutral  e"Normal 8Noteb Note   9OutputrOutput  ???????????? ???:$Percent ;Title1Title I}% <TotalHTotal OO= Warning Text: Warning Text XTableStyleMedium9PivotStyleLight168 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`]detailxpayrollmWeb Expense SummarypWeb Revenue Summary  ;  ;H  ;5 <Year 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 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 Temporary Classified Union 4 = ExecutiveEX APT (Exempt) 5 = Faculty, UNAC Extended TemporaryA9/AR Executive Faculty, UNAC Student Taxable Students non-taxableOrg # & Org titleHrsDaysHourlyBenefitBegStopPerHoli-Per-Days ofGrossAnnualNameWageObjPCNTypeDayContractRemdaysonalOtherEarningsSalaryLabor_6Subtotal: Permanent Positions and Committed Pool Labor= Leave/BenefitRate-Pool Labor Projections:Adjunct FacultyClassified 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}~/WGPEa1\D/rfd~~@date({?})~ Faculty, UNAC Faculty-Temp representedNX/XXF9 8 = Faculty temp representedFT/FW 10 = Student Taxable 9 = Temporary 11 = Students non-taxable Temporaryb2c3d4e5f6g7h8i9j10k11l12m13n14o15 Level 5 OrgFundLevel 3 ProgramOrgAccount Type TitleExpendedEncumCurrentYTDOrg Title$ 7 = Faculty non-represented 12 moFR& 12 = Faculty non-represented <12 moFN Faculty non-rep 12 mo Faculty non-rep <12 mo 6 = Faculty, UAFT Faculty, UAFT Faculty, UAFTSN/GNECLSfor the pay period ending0Department Name (input to cell K1 on detail tab)A9CT/NT/XTST/GTFY24 Management Report DetailUE E[FfFFx$GG]HrH)HI;IvI:JJ^KKKSLnL% M=MtM+MiN O ccj 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 }\  dMbP?_*+% &CPage &P&R&D&'((\?)?MHP LaserJet 2430 PCL 5C odXXLetterDINU"0lP|&0SMTJ HP LaserJet 2430 PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]4Pd?KRTHORNGREN44dPrint driver host for 32bit appsplwow64.exeC:\Windows\splwow64.exe"D(\?&U} }  } } } } } m ;;?          @Z                                                           D F0~ A@@ ZE# %(  DDD ~  B@   #C %bl(CD DD ~ A@ ZE  -   LLL ~  B@   C -blC LLL ~ A@@       ~ B@   C  C ~ Ap@        ~ B@   C  C  ~ A@@ !       ~ B@ "  C  C  ~ A@ #       ~ B$@ $  C  C  ~ A@ %       ~ B%@ &  C  C  ~ Ap@ '     ~  BV@  ( CC  ~ BX@ &    ~  Bt@  ) CC ~ B@@ *     +   ,# % # %   -           -        " D D42DF@@@@G@@@@@@@@E,|*/.6PB8` F9 9 @  @ 4   ( ><dd7 Sheet1ggD@ ZO  AVl  dMbP?_*+%w;8&C&"Arial,Bold"&12&K000000Department Name FY19 Payroll  &CPage &P&R&D&'(?)?M HPD17E3B (HP OfficeJet Pro 8716C odLegal GIS4DINU" *J&;  SMTJ {0E194E46-3C98-4d0a-B3E1-422AFEF305BA}InputBin1RESDLLUniresDLLLocaleEnglish_United_StatesStringsCluster0IDS_PS_PAPER_SIZEStringsCluster1IDS_ABOUT_HP_COPYRIGHT1HPInkDriverTypeHPStandardInkDriverDeviceLanguagePCLHPDataCollectionXMLhpygidDataMap.xmlHPImagingDllhpfime52HPApplicationTrackingAppTrackingHPMechOffset192HPFeedTypeHPCFeedHPSpeedMech2V4DriverV4HPBookletGutter5927HPRlt1UserResolutionNormalResolution1200dpiHPPrintOnBothSidesManuallyOFFColorModeColorOutputPaperSizeLEGALBorderlessPrintNOOrientationLANDSCAPE_CC270MediaType0.1004.0000_0_600x600DuplexNONEJobFlipPageUpfalseDocumentNUp1NUpBordersOffPresentationDirectionRightBottomCollateONJobPageOrderReverseDocumentPageRangesAllPagesGUIStringsIDS_USE_PAPER_SIZE_GeneralEverydayMediaType_PhotoPrintingBorderlessMediaType_PhotoWhiteBordersMediaType_DuplexMediaType_FastEcoMediaType_FactoryDefaultsMediaTypeDocumentBindingNONEHPMaxDpi0_disabledOutputQualityPrevNormalBorderlessPrevNOInputBinPrev1MediaTypePrev0.1004.0000_0_600x600TouchByUserOffSnapp_HP_3_5X5_IN_L_MMMTS_5.1069.0000_0_600x600_IB_1_PQ_Normal_BD_BorderlessOverspray_ENDSnapp_JapanHagakiPostcardMTS_2.1077.0000_1_600x600_IB_1_PQ_Normal_BD_None_ENDSnapp_HP_4X6_IN_10X15_CMMTS_5.1069.0000_0_600x600_IB_1_PQ_Normal_BD_BorderlessOverspray_ENDSnapp_HP_2L_MMMTS_5.1069.0000_0_600x600_IB_1_PQ_Normal_BD_BorderlessOverspray_ENDSnapp_HP_3X5_INMTS_5.1069.0000_0_600x600_IB_1_PQ_Normal_BD_BorderlessOverspray_ENDSnapp_HP_5X7_IN_13X18_CMMTS_5.1069.0000_0_600x600_IB_1_PQ_Normal_BD_BorderlessOverspray_ENDSnapp_HP_8X10_INMTS_5.1069.0000_0_600x600_IB_1_PQ_Normal_BD_BorderlessOverspray_ENDSnapp_HP_INDEX_CARD_3X5_INMTS_2.1077.0000_1_600x600_IB_1_PQ_Normal_BD_None_ENDSnapp_HP_INDEX_CARD_4X6_INMTS_2.1077.0000_1_600x600_IB_1_PQ_Normal_BD_None_ENDSnapp_HP_INDEX_CARD_5X8_INMTS_2.1077.0000_1_600x600_IB_1_PQ_Normal_BD_None_ENDSnapp_HP_INDEX_CARD_LETTERMTS_2.1077.0000_1_600x600_IB_1_PQ_Normal_BD_None_ENDSnapp_HP_INDEX_CARD_A4MTS_2.1077.0000_1_600x600_IB_1_PQ_Normal_BD_None_ENDSnapp_HP_OFUKU_HAGAKI_200X148_MMMTS_2.1077.0000_1_600x600_IB_1_PQ_Normal_BD_None_END*V4DM ᪉>< MB*x&Dd~~~B~h~~$~:d$(~,~~ ,T~~4~8v4~4~R~< ~ <  < @< j@ D H L L:PTXX\D`rttx|. 0h     <0 8 @J  d bArrayZoomPosterNUpBorderWidthNUpBorderLengthNUpBorderDashLengthFrontCoverMediaSizeFrontCoverMediaSizeWidthFrontCoverMediaSizeHeightFrontCoverMediaTypeFrontCoverInputBinBackCoverMediaSizeBackCoverMediaSizeWidthBackCoverMediaSizeHeightBackCoverMediaTypeBackCoverInputBinInterleavesMediaSizeInterleavesMediaSizeWidthInterleavesMediaSizeHeightInterleavesMediaTypeInterleavesInputBinInsertEmptyPagesMediaSizeInsertEmptyPagesMediaSizeWidthInsertEmptyPagesMediaSizeHeightInsertEmptyPagesMediaTypeInsertEmptyPagesInputBinInsertEmptyPagesExceptionUsageInsertEmptyPagesListInsertPrintPagesMediaSizeInsertPrintPagesMediaSizeWidthInsertPrintPagesMediaSizeHeightInsertPrintPagesMediaTypeInsertPrintPagesInputBinInsertPrintPagesExceptionUsageInsertPrintPagesListTargetMediaSizeTargetMediaSizeWidthTargetMediaSizeHeightBindingGutterSignaturePagesPageWatermarkNameHPageWatermarkPlacementOffsetWidthPageWatermarkPlacementOffsetHeightPageWatermarkTransparencyPageWatermarkTextTextHPageWatermarkTextFontSizePageWatermarkTextAnglePageWatermarkTextColorPageWatermarkTextFontHPageWatermarkTextOutlinePageWatermarkTextBoldPageWatermarkTextItalicPageWatermarkTextRightToLeftPageWatermarkImageFileHPageWatermarkImageScaleWidthPageWatermarkImageScaleHeightJobNameUserNamePINPasswordShortcutNameDuplexModedns0000:UsePageMediaSizepsk:Plainpsk:AutoSelectns0000:UsePageMediaSizepsk:Plainpsk:AutoSelectns0000:UsePageMediaSizepsk:Plainpsk:AutoSel<vectns0000:UsePageMediaSizepsk:AutoSelectpsk:AutoSelectns0000:SpecifiedPagesns0000:UsePageMediaSizepsk:AutoSelectpsk:AutoSelectns0000:SpecifiedPages20061HFFFF00000061!0041ddManual"K??&U} J} J} c} J} mJ} IJ} I J} J}  J} mJ} mJ} mJ} IJ} mJ} J} J} I J} I _} I J}  J} &$ J} '( J} ).IJ} // J} 01mJ} 28IJ} 9UJ} V JV((((((((;@( ( ( ( ( (((VVVVVVVVVVVVVVVV KOKKKKKKKKKK L-:KKKKKKKKKKKKKKHIIIIIIIIIII'VKKOKKKKKKKKKKLKKKKKKKKKKKKKKHIIIIIIIIIII'V`KOKKKKKKKKKKKKKKggggggGgggNHIIIIIIIIIII'*`KOKKKKKKKKKKKKKK 00KHIIIIIIIIIII'0KKO~~MMKKKKKKK 1 2 3  4 KHIIIIIIIIIII' |5 4@ AJO .  /KKKKKKKKK  8 9 : ; ; ; ;  KHIIIIIIIIIII'o} 4@y AJROijjiKKKKKKKKKKQRRRRRIIIIII' o>~ 2@O 6  7KKKKKKKKK 7~  A?;pΈް?㥛 ?m?~jt? KQRRRRRISIIII' B+ @ D%]yBfO <  =KKKKKKKKK =~ ? DbX9ȶ?~jt?x&?V-?~ G@ KQRRRRRISIIII' KKO ?  @ KKKKKKLKK @~ @ G   Ac]? V}b? ;Nё\? S?  |?5^? KQRRRRRISIIII' KKO C   KKKKMMMMM ~ @ I ~  Mb?~  Mb?  #~j? KQRRRRRISIIII' KKO E  F KKPKKKKKK F~ @ K  Bi? B>٬? Gx $(? |?5^?  Mb? KHISSIIISIIII' KKO H   KKKKKKKKK ~ @ L ~  {Pk? z):˿?~ .@  ʡE? KHIIIIIIIIIII' KKO    KKKKKKKNK J~ @    ~  KHIIIIIIIIIII' KKO   KKKKKNKNK ~ @ Bi?B>٬?Gx $(?|?5^?Mb? KHIIIIIIIIIII' KKO   KKKKKNNNK ~  @ EԸ? KHIIIIIIIIIII' KKO   KKKKKNNNK ~ "@ I +? KHIIIIIIIIIII' KKO   KKKKKNNNN ~ $@ MI +? KHISSIIISIIII' KKO     KKKKNNNNN ~ &@ N~  MHISSIIISIIII' KKO  z{   KKKKNNNNN ~ (@ z~ {Pk?z):˿?~ .@ Mb? MHISSIIISIIII'VKKOKKKKKKKKKNNNNNNggjMHISSIIISIIII')IIIIIII/ 1TT2 O P   Q   .HISSIIISIIII' R : S T U V   V  Q  W X Y P Z [ 2 3    HISSIIISIIII' \ ] ^ _ `   a   b  c  2  d [ e f ; c g ; ; ; ; h  iHISSIIISIIII'"HTTTTTTTTTTTTTTUVijejjjjjjjjjjjjjjjjjjjjjjjjkUVSSIIISIIII'n@B_7ULA'  L4LA'  L LBB @  _7 ULA'  L4LA'  L LBB * 7 LA' LA' B%LLLLBLLA'LLA'  7 LD LD  LLA' LA' B%LDLDBLLA'DBB~     7 LD LD :L%]iBfL%]iBf=D%]kBfL%]iBf"BL%mxBf,-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#5 % ~ 7L oLLA NL L+LLL?L""BS-=D DD DDDB%7L%BfL%7L%BfL%7L%BfL+,DDDD#/ %D9%7L% BfL!9 DDUVSSIIIIIIII'n@  @  C  )  ~     * 7L L B$L333333ÿLL L B$LLL L B$L333333ÿLiL L B$?L L B$LQL""""B7 -~ G7=L LLLLLB/#7LLLD7 -D 7 LLUVSSIIIIIIII'n@  @      ~   '  7~ * 4+HISSIIIIIIII'n@  @      ~   4  .~ ' . * HIIIIIIIIIII'n@  @      ~   5  - ~ *579,HISSIIIIIIII'n@  @      ~   #  ~ -6 ' $UISSIIIIIIII'n@  @     2  ~   #  5~  93HISSIIIIIIII'D0lpZZp-*G   Z?^^^^ (!("(#($(%(&('((()(*(+(,(-(.(/(03132333435363738393:3;3<3=3>3?3  n@  @      7  ~        ~           9     & HISSIIIIIIII'!!n@! ! @! !   ! ! ~ ! ! 1  !!!6~ !!!!% !!!"!!!!!'!!!6!HIIIIIIIIIII'""n@" " @" " !  " " ~ " "   """""~ """"" """"""*","""'"HIIIIIIIIIII'##n@# # @# # "  # &  ~ # # /  ###!~ ############+#1###+#HISSIIIIIIII'$$n@# $ @$  $ $ $ 3  ~ $ $   $$%$1~ $$$$$$$$$$$$0$"$$$$HISSIIIIIIII'%%n@% % @% % $  % !  ~ % % (  %%%%%~ %%%%&%%%%%%%%%&%%%%HIIIIIIIIIII'&&n@& & @& & %  & 3  ~ & & 0  &&&&7~ &&&&/&&&&&5&$&&&&&.&HISSIIIIIIII'''n@' ' @' ' &  ' ' ~ ' ' ' ''/ '!~ ''''7 ''''''''('''4'HISSIIIIIIII'((n@' ( @(  ( ( ( ( ~ ( (   ((+ (~ ((((* (((((((-("(((2(HISSIIIIIIII'))n@) ) @) ) (  )   ~ ) ) (  ))))3~ )))))))))))))4)))9)HISSIIIIIIII'**n@* * @* * 7  * .  ~ * * * ** ***4 -~ ****(*******#**4 LLLD***4 -D*****4 LL*HISSIIIIIIII'++n@+ + @+ + *  +   ~ + +   ++++*~ ++++++++++2+)*++*+++0*+HISSIIIIIIII',,n@, , @, , +  ,   ~ , , 5  ,,,,)*~ ,,,,,,,,,,,,$*,.*,,,4*,HISSIIIIIIII'--n@, - @-  - - - - ~ - - +  --&-(*~ ----0 -6-6----*-*---6*-HISSIIIIIIII'..n@. . @. . -  . &  ~ . .   ....7*~ ........#...*..*...,*.HISSIIIIIIII'//n@/ / @/ / .  / 1  ~ / / )  /////*~ ///////////%*/3*///2*/HISSIIIIIIII'00n@/ 0 @0  0 0 0 6  ~ 0 0 ! 00000*~ 0000000#0002*00*000&*0HISSIIIIIIII'11n@1 1 @1 1 0  1 $  ~ 1 1 $  11!1*~ 111111111151*11*111*1HISSIIIIIIII'22n@1 2 @2  2 2 2 -  ~ 2 2 4  2222*~ 22222222222*20*2221*2HISSIIIIIIII'33n@3 3 @3 3 2  3 ,  ~ 3 3 - 3333*~ 333333333333%*3/*333)*3HISSIIIIIIII'44n@4 4 @4 4 3  4 2  ~ 4 4 %  44442*~ 44444444444.*44*4441*4HISSIIIIIIII'55n@5 5 @5 5 )  5  ~ 5 5 5 55 51~ 5555(5555555)5$555$5HIIIIIIIIIII' 51TT266n@6 6 @6 6 5  6 6 ~ 6 6 6 66, 60~ 6666(666'6!6+66666#6HIIIIIIIIIII'77n@6 7 @7  7 7 7 7 ~ 7 7   77"7 ~ 7777! 7777777-777777HIIIIIIIIIII',8dleggggmn 8j 8j 8j 8j 8j 8j 8j 8j 8j8HIIIIIIIIIII' 9ok9geggggmnk9 @UD9A'  D94D9A'  D9 D9BB9 9999 -99999999999399E99E99E99HIIIIIIIIIII',:dgeggggggggggg :jl :jl :jl :jl :jl :jl :jl :jl :kl:HIIIIIIIIIII'4;dgeggggggggggggggg ;fm&;gggpHIIIIIIIIIII'4<dgeggggggggggggggg <en&<gggpHIIIIIIIIIII'4=dgeggggggggggggggg =jo&=gggpHIIIIIIIIIII' >op,>gegggggggggggg >fq >gg>qEԸ?>D>g~ >!>> D>D>>4 >>C LL>HIIIIIIIIIII'.?dgegggggggggggg ? ?gg?qʡE??D ?g~ ?!?? D?D??>>?HIIIIIIIIIII'DBl^^^^^^^^^^^^^^^^^^^^l^^ppp@(A(B(C(D(E(F(G(H(I(J(K(L(M(N(O(P(Q(R(S(T(U(V(W(X(Y(wZ(w[(w\(w](w^(w_(w.@dgegggggggggggg @ @gg@q@D @g~ @!@@ D@D@@?>@HIIIIIIIIIII'.Adgegggggggggggg Afr AggAq~jt?ADAg~ A!AA DADAA@>AHIIIIIIIIIII'.Bdgegggggggggggg Bfs BggBqI +?BDBg~ B!BB DBDBBA>BHIIIIIIIIIII'.Cdgegggggggggggg Cft Cgg ChuCgCCE >CHIIIIIIIIIII'8Ddgeggggggggggggggggg Drj Dj DjDHIIIIIIIIIII' EovEgegggggkEn@9 UDEA'  DE4DEA'  DE DEBBkE @EUDEA'  DE4DEA'  DE DEBB E : E : E s: E : Es: Es: Es: E: Ef: Es: Et: Et: Etw Et:Eu#Ev9 %9D#E %9D#E %9DEHIIIIIIIIIII'8Fwxyxxxxxxxxxxxxxxxxx Fzl Fzl F{lFHIIIIIIIIIII'VGggegggggggggggggggggjjjHIIIIIIIIIII'VHggegggggggggggggggggjjjHIIIIIIIIIII'VIHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VJHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VKHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VLHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VMHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VNHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VOHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VPHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VQHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VRHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VSHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VTHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VUHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VVHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'VWHHaHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIII'XH XWx Xay XHH XW3 XWz XHHH X X{ X HH X X|XHHHHH XX}.XHHHHHHHHHIIIIIIIIIII' YY~ YY Yb YII YY YYYIIIIII Y Z:YIIIIIIIIII[IIIIIIIIIIIIIII' Z\o Z\o Zbo ZII Z\o Z\oZIIIIII Z Z:ZIIIIIIIIII[IIIIIIIIIIIIIII'V[IIbIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'V\IIbIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII']I`@`@ ]"]`@ AA~ ](@H]IIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'^I,@@@ ^"^@] AA~ ^I&@H^IIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'_I.@@@@ _"_ @^ AA~ _I$@ _III _ Z _ II _ Z_IIIII _Z._IIII[IIIIIIIIIIIIIII'DliZZZZZZZZZZZZZZZZZZZ`(wa(wb(wc(wd(we(wf(wg(wh(wi(wj(wk(wl(wm(wn(wo(wp(wq(wr(ws(wt(wu(wv(ww(wx(wy(wz(w{(w|(w}(w~(w(w`I0@`@ @ `"`@_  AA~ `I"@H`IIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'aI1@ @ @ a"a@`  AA~ aI @HaIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'bI2@ @ @ b"b@a  AA~ bI@HbIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'cI3@ @@@ c"c@b  AA~ cI@HcIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'dI4@`@@ d"d@c  AA~ dI@ dIII d Z d III dZ8dIIII]]]]]^]]]]]]]]IIIIIII'eI5@ @@ e"e@d AA~ eI@eIIIIIII eZ8eIIIIIIIII[IIIIIIIIIIIIIII'fI6@@@ f"f@e AA~ fI@fIIIIIII fZ8fIIIIIIIII[IIIIIIIIIIIIIII'gI7@@@@ g"g`@f AA~ gI@gIIIIIII gZ8gIIIIIIIII[IIIIIIIIIIIIIII'hI8@`@@ h"h&@g AA~ hI?hIIIIIII hZ8hIIIIIIIII[IIIIIIIIIIIIIII'iI9@ @@ iII"i0@h AA~ iIiIIIIIII iZ8iIIIIIIIII[IIIIIIIIIIIIIII'jY:@@@jIIIIIIIIIII jZ8jIIIIIIIII[IIIIIIIIIIIIIII' kYk@@@PkIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' lYl`@@PlIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' mYm @ @ mIImII?HmIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' nYn @"@ nIInI?I? nIII n Z n III nZ8nIIIIIIIII[IIIIIIIIIIIIIII' oYo"@@$@ oIIoI@I?HoIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' pYp`$@&@ pIIpI@IHpIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' qYq &@'@ qIIqI@I?HqIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' rYr'@)@ rIIrI@I?HrIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' sYs)@@+@ sIIsI@I?HsIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' tYt`+@-@ tIItI@I?HtIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' uYu -@.@ uIIuI @IHuIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' vYv.@0@ vIIvI"@IHvIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' wYw0@@2@ wIIwI&@IHwIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' xYx`2@4@ xIIxI(@I?HxIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII' yYy 4@@4@.yIIIIIIIIIIIIIIII]]]]#y]" %Ix"AA#y^y %Ix#AA#y]y %Ix$AA#y]y %Ix%AAy]yyyy y]yyy]yyy]yyy]yyy ]yyy!IIIIIII'VzIIbIIIIIIIIIIIIIIII]]]]I[IIIIIIIIIIIIIII'V{IIbIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'V|IIbIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'V}IIbIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'V~IIbIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'VIIbIIIIIIIIIIIIIIIIIIIII[IIIIIIIIIIIIIII'DDlxxZZZZZ`) I* I* I+  I> IE IE IE ><d**   7 Sheet3ggD@< ZO o>p  dMbP?_*+%&A Page &P&?'?(?)?"P??&U} m } $} $   >>>>> > > >          >>***7 Sheet4ggD@ ZO qs  dMbP?_*+%&A Page &P&?'?(?)?"P??&U} m } $} $   >>>>> > >         :>>:7 Sheet5ggD@ ThisWorkbookSheet1 modTransferData  Sheet3  !"#$%&'()*+,-./123456789:;<=>?-V#ѷ(<N0{00020819-0000-0000-C000-000000000046}@ 0ic%@xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2-c_h#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 0wa%@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 0c_ߌ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` (_=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      ")#$%'(*5+4-./0123&]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ž -c_VD#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 0ic%@xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Sheet4 0Sheet5@_VBA_PROJECT,dirP-c_#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 0%@xAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2-c_aA#xME(SLSS<N0{00020820-0000-0000-C000-000000000046}@ 0%@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 _=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"c_|ThisWorkbookG T~ isWrkbo 2 HBj13@B,Q!V"B+BSheet1GS@#et14H2NhmodTransferDa`taG=d@TransUeD@t2 O)6'~"ߌV!"3"3"3"3"VD04 4 4 4 > 5 5 5 5 aA b+scrrun.dll#Microsoft Scripting ThisWorkbookThisWorkbookSheet1Sheet1Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5modTransferDatamodTransferData_ThisWorPROJECTwm]PROJECT `sSummaryInformation(jDocumentSummaryInformation8o|ID="{77030D3D-D146-46A1-B142-54687DD29DD3}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Module=modTransferData Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="7E7CC64A3AB6BCBABCBABCBABCBA" DPB="FCFE44C8BC47BD47BD47" GC="7A78C24E414F414FBE" [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=0, 0, 0, 0, C COLzi Oh+'0HPx  Budget Dev. & Maint Offc - UA 1Raegan KelliherMicrosoft Macintosh Excel@yP@T8@MARYH 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 Runtime_=Sc_ThisWorkbook016724f63b'ThisWorkbookV3 Sheet1026724f63b+ Sheet1h3modTransferData036724f63b,modTransferDataߌ06 Sheet3046724f63b Sheet3VDH3 Sheet4056724f63b Sheet4`3 Sheet5066724f63b Sheet5aAx3`x0H3=y5OR0ЙГ@0۸F|Wz>ݰ?^"iB2] dτrBwB ';@Cr= 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