ࡱ> .-  !"#$%&'()*+,EP012D456789C;<=>?@AB3FSGHIJKLMNOQRTZUVWXY[\Root Entry F͹>/0Workbook3U_VBA_PROJECT_CUR"H:5 :5VBA:5\:5 `\pllharrisood Ba= ThisWorkbook=X,X/!8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1h>Cambria1,>Calibri1>Calibri1>Calibri1Calibri1Calibri1Calibri1>Calibri1?Calibri1 Calibri1 Calibri1 Calibri1 Calibri1Calibri1Calibri1 Calibri1Calibri1Calibri"$"#,##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.00 \+###0 \+###0.00 #,##0.##### \+#,##0 \+#,##0.00 0,000 0,000.00 \+0,000 \+0,000.00"$"#,##0;\("$"#,##0\) "$"#,##0.00;\("$"#,##0.00\) \+"$"#,##0 \+"$"#,##0.00 ##0% ##0.00% \+##0% \+##0.00 mm/dd mm/dd/yy mmm\-yyyy dd\-mmm\-yyyy yyyy\-mm\-ddmm/dd/yy\ hh:mm\ AM/PMmm/dd/yy\ hh:mm:ss hh:mm\ AM/PMm/d/yyyy\ h:mm:ss\ AM/PM                                                                      ff + ) , *     P  P       `            a8     ! (  @  (@   (@  + (@ )@  (@  ||K/}A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef ;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L ;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A}  00\);_(*23;_(@_) }A}! 00\);_(*23 ;_(@_) }A}" 00\);_(*;_(@_) }A}# 00\);_(*;_(@_) }A}$ 00\);_(*;_(@_) }A}% 00\);_(*;_(@_) }A}& 00\);_(*;_(@_) }A}' 00\);_(* ;_(@_) }A}( 00\);_(*;_(@_) }}) }00\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}/ 00\);_(*}A}0 a00\);_(*;_(@_) }A}1 00\);_(*;_(@_) }A}2 00\);_(*?;_(@_) }A}3 00\);_(*23;_(@_) }-}4 00\);_(*}}5 ??v00\);_(*̙;_(@_)    }A}6 }00\);_(*;_(@_) }A}7 e00\);_(*;_(@_) }x}800\);_(*;_(  }}9 ???00\);_(*;_(??? ???  ??? ???}-}; 00\);_(*}U}< 00\);_(*;_( }-}= 00\);_(* 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L湸 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ٗ % 60% - Accent3M( 60% - Accent3 23֚ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight168 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`[> Rpt BudgetSSheet1 CreateASCII  ;ZR 3  @@  w ProgramClass Project/GrantUMICH RPT_BUDGETAccount (Required) Fund (Required) Deptid (Required) Fiscal Year (Required) Accounting Period (Required) Business Unit (Required - UMICH) Ledger (Required - RPT_BUDGET) NPosted Total Amt (Rev amts are net negative (-) and exp amts net positive (+)) e/ /ccN PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!ÄA theme/theme/theme1.xmlYOoE#F{oc'NjGuرhF[xw;23NjHH q Jĥ|@_73xM6{o~(fIyWk"޽aJCR$'Mnlu"^T$}*OIB.bQn̖kC 0>ACMȉ<&J &M5BNe tY>?#!mfKx=[Ԃu}ˆ ~umoLz^W/}ةLo;9iwk/_tV[,ac߬56YvYp1ϡAz 9ۮ7ެe ."Zk1~EȰ RӔ/x$( :7vʗsSj{"bF^x^xz?>~,ɸ7Gg_zy5^|?}V I򋧿>O~I|SQ>19D{<Ÿ8ߊaG@tOE*\ʻ/ yToN:"1Q(v; y4<$jbRa|PŻǴI Y3wJG݈8b2(<& QHT^w/B(`Z!94[Mc˴j`jG7;Q]o YC5*CocU 9 IQ/ RV+`%*;æWѼ9/#~7qZ$*cߓrUngN>%OOi Dh[BvoLJƌB6>p&>w O]>_x.eywQ,5,^<ؾt&9 ԔEЇIIqhJ#f6kAS&2D)p3ӕ5teO`jvzEOG)9cshger-# ~fu-ԙՍh&9܊- 6 AлY3hX"M$#Fz6#b.w*lyhĭɾ̮]nR3+=,)'Kak.zi X 8Ka6!_ 5[ M܆< kW Ds/Z/j@&8?&5- C⫲K3Zw1K|D!`~J0A?Uֶy&,Xg1K#[y$[BTV)bBRvVt=낕@[\׶Dž8d4~_@`rx \kp*O69mY&ԧ HE]HKN!Vj%2BƣJԊ=" u\ӵC&Y0>g4&oN)j rihr"VTU,koy#ŬjQJpRk3܎Ws;ɢ!JT~u "֠ۀW_ Nq֙4)ڬuZˋw֒TvќXHegvtm,{2Da*20V=CoOQ2'@C8D.IrG[Ȥiࠆ)d͛|?&f9>b|w##(ɇ"C *_p=ce΂aenv*Wm瓗{varAˇ$IDpKs6* ʢG0egAnlCYt֏$Ysă)2|FS` uz'Xr*󠍒F`Bi m/Ҷj9Xrmox86tFo˜ b`>ASDbƟPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!ÄA theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] {mU7hgY H  G6I  dMbP?_*+%&A Page &P&(\?'Q?(q= ףp?)q= ףp?M\\bf-it-polaris01\MA-PR-ASB104$S odXXLetterPRIV0''''H\KhCSMTJDell Color Laser 5110cn PSResolution600dpiInputSlot*UseFormTrayTableDuplexDuplexNoTumblePageSizeLetterPageRegionLeadingEdgeDLColorModeBlackDLOutputModeHighSpeedDLBrightnessNormalDLRGBImageTypesRGBDLEngineScreenAutoDLRGBCorrectionNoneDLRGBInputProfileSRGBDLRGBBCorrectionDarkDLColorTemperatureTemperatureD65DLGrayBalanceTrueDLMSILeadingEdgeShortEdgeCollateFalseMediaTypeDefaultDLSlipSheetTrayOFFDLSlipSheetPrintFalseDLSubPaperSelectionSMHDLCustomPageSizeCorrectionTrueSmoothingTrueDLTonerSaverFalseDLColorAjstFalseDLSaveBlankSheetFalseDLHalftoneModeTrueDLMonochromePriorityFalseHDFBF01401#c~M>Ʃ V 1.008PrintProcCaps_EMF"dXXRQ?Q?&U} $>} >}  A} I@} @} @} @}  @} >} >} ?  E F B H I D D C C D D D J F F GB B * ( @A@A "  S Р`pGff=i=i?( Rounded Rectangle 1#"@PK!Zf[Content_Types].xmlMO &2WR=cJ`F0iK`#̼vLw 9uSq:w`G ^i ½KI)c/ $oVjTMRc|}042ҥCƔM̏P~*ka/8^DkHbL8e i"K\XN\6rco4y@_;oPK!1_a _rels/.relsj0 ѽqCNo^K [ILcX&m߾0XFo;>0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!c,Gdrs/shapexml.xmlUKo0 t驵4u6]Z4+vV,ɒ'1Qt;. E||I]^jI6J&g1%BeWH)%Lj%R^?~q3c*+!B*RZ4(Y)jft#Zsmjx4E ۢZF8G1q[ B7lBHyCUntL2r98cϓ|ǽͩU;9dq<!C.mH2Sz,mܬy!<^Nɧzd~Qm͓i3y2)PXt>ₓg!Ʌ$Q}'kGd9`kv^`脚UyNv)N.b}J=C.16Id4Iƃ1%ڇH`.D!w1}tN9JqP9|l`!⸘VˊUR 4ddJWECudm_(:6M1&kRK( 6U%L?20>ſ[S"0Wwhut2[¼s_8}p!QW-8%R`|'*.R"ϑZX3Ma%ߒ\g )ExZi8M7`iIrY2Wfu dSk`۾tOna㈇av @A 7 Sheet1ggD  T  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?9&<3U>@ Sheet2ggD ThisWorkbook Sheet1 Module1:!__SRP_2 P !"#$%')*+,-./012345679:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsuvwxyz{|}~/އ܇#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}H(%H0(87xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2/އڇ#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}H(%H0(87xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2X  0$8 `$h   `  ` px ,+ L+  0 8xx^^8g$^ X9^ xg^9E^^6A^Mo^^8le^X^xrd^^s.^^^^8^X^ x^^^^^^8pHX]]]]]]]00000000000.00;-0000000000.000&Please enter output file path and name#Where do you want to save the file?C:\temp\BUDLOAD.DAT$`'Zb`$'\ Z \ 'T 'X T d%f T d%f b T d%f>$ T d,f T d%f>$ T d,f T d%f>$ T d,f T d%f>$ T d,f  T d%f9 T d%f9" X9  X96 T d%f9( X9& T d%f9, X9* T d%f000000$90 X9. T d%f00000$94 X92 T d%f00000$98 X9: X9> T d%f0000$9@ X9B X9F T d%f0000$9H X9J T d%f000$9L X9N T d%f ^$9P \55 5"5$5&5(5*5,5.5052545:585>5<5B5@5>5D5J5H5N5L565P T 'Tqph \VASCII file created successfullyA@hg b?Error - File could not be created. Make sure file path exists.A@h \Vgo RPT_BUDGET9$$C10/20/08 - blking - Hard code value; was Application.Cells(nRow, 3)XFINAL9DC10/20/08 - blking - Hard code value; was Application.Cells(nRow, 4)` T d%f>$ T d,f T d%f000000000000000$9<fAttribute VB_Name = "Module1" Option Explicit Type LedBud Business_unit As Sng * 5@Fill1 0F10Oger 0 _Group T3 9Accoun 6343Fund_code _5Ded 46ProPgram52Appropria_nbT7;@ject_iV1 8 @{get_yea4S9 Scenario'vAa10 Fiscal1|ing_pe9 3G+1WPost@ed_tot@a:mˎ1; End A Sub CreateASCII() DimḊ:AnRowpInteCJournaldӇAOGsenOut8fil%Const FMT_CURRENCY0.00;-`= InputBox("Please eAr out path a(n", "Where do y ou wa@wto save th eb?C:\temp\BUDLOAD.DAT" `-!-O rror GoToitl= Freea$A4pen }F$I Wri)L r=:n(9C Let := 2'm l6 &Do Whb1pBz.Cells(, 1) <> "" A$ `  ormat6(w0>)2)'B$9 2)? , 6? `? , 7? `? , 8? `) ,WiYz.+= -C.72L.H1/`erCLRPT_cGET"L'10/20/08 - blkHard BvalueZ;7s (32TW`,3Ww044x.on 55a)KU.5 yol6f}Z6]{7! 7 o}?<86\ 89:9=+FINAL* ***YS" 2Ʌ "Q L$010t5N1Y R އ؇xRRrME0H6 LLLL<4<8<<< (809  H( X P (("x p9   ($ Mo  h(&4le H((6rd ((*B!s. (,D" (.8N'0 (0XP(P (2x\.p (4^/ h(6h4 H(8j5 ((:t: (<v; (>8J0 (@XKP (BxOp (DP  h(FZ H(H[ ((J_ (L` (N8c0 (PdP  R`JEE! @%`T`V`X`Z`\@^0HX%pP0P00000000000.00;-0000000000.00dht d @T D @4 $ @ @ @ p @  @ on`p `X @ @ @ @ @t t @d ``h\ @X @T @P ot@L @H @D @@ @< @8 @4 @0 @, @( @$ @  @ @ @ @ @  @ @ @ @ @ 0XXXH7$*\Rffff*054a805580(*\Rffff*054a805580\0*\R0*#14*\R0*#11*\R1*#337*\R1*#10d*\R1*#fc*\R1*#220*\R0*#f*\R1*#10d*\R1*#fc*\R0*#f!f    0 @ P ` p            0 @ P ` p      "   * tH     60 0P000NN \ @ ( @H `&h & & 0@ $ (|3QBPriu#l, J; 3FpSIwE(3pD4wq45p96wp5d7p18p -D9pH)Te%$11e2N]S}M + t`doopCloG &CMsg ,("3cd succfully!`xJ:E- e]uld not b. M8akeWexists. Pd rU~|  Q y1 Y   I q q 9q0 X  krU $` n__SRP_3 &oSheet2(_VBA_PROJECT8dirt3'އ#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@07xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2a  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.6#0#C:\Program Files\Microsoft Office\Office12\EXCEL.EXE#Microsoft Excel 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{BC2A1988-7A92-4DC4-9EE1-96F9C4674FA1}#2.0#0#C:\DOCUME~1\blking\LOCALS~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M &*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.4#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 8.0 Object Library  7އThisWorkbook024a805568ThisWorkbook܇5 Sheet1034a805568 Sheet1ڇ5Module1054a805580Module1؇0 Sheet2024a841a41s Sheet2P-p0P $MNO.e'_ @UTB6!hIS0 oC5\ 09:, Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`MSFormsCOfficeu ThisWorkbook| _Evaluate Sheet1 Module1b(!LedBud Business_unitFill1XYLedgerO  Ledger_Group.Fill3ZYAccount Fill4[Y Fund_codeGFill5\YDeptidFill6]Y Program_codeFill2YYAppropriation_nbr9wFill7^Y Project_idFill8_Y Budget_year(Fill9`YScenarioFill10  Fiscal_yeart*Fill11 Accounting_periodFill12 Posted_total_amt) (CreateASCIIknRowM JournaldatexFiller sFileNamenOutfile4~ FMT_CURRENCYInputBox ExitProg֖ Application*CellsMsgBoxRWorkbookk Worksheet_Defaultj _B_var_Format Sheet2x s  H@/0* pHd VBAProject4@j = r 7 J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.tlb#OLE Automation`MSForms>SFFrms3ED452EE1-E08F-@101A-8-02608C4D0BB4EFM20.DLL#Microsoft E: ^ Ob Library/;D1u00}#0#k0 ABC2A1988-7A92-4DC4-9A:96F9C4674FA16DOCUME~1\blking\LOCALSTemp \VBE\T.exd;@!.E .``M OfficOfQ@ic 12DF8D04C-5BFAg@B-BDE5IAjA421gram Files\CommonhShared\OFFICE125Op& 8..0p@%"އ»ThisWorkbookG T@iWkbok 2 HB1`5B,Q!܇"B+qSheet1G Se,t1w u2 ڃ bnoduleucnouA2'r ؇!2222 -**bK*rU~~~~~~~~~~~~~Y AĀ4D*7    a Q 1 )  __SRP_0_ __SRP_1 NPROJECTwmkPROJECT VBAProject ThisWorkbookSheet1Module1F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA A i0F4C:\Program Files\Microsoft Office\Office12\EXCEL.EXEExcel 9a@0FC:\WINDOWS\system32\stdole2.tlbstdoleF IqP.E .`M C:\WINDOWS\system32\FM20.DLLMSForms aa`qNW)? 0C:\DOCUME~1\blking\LOCALS~1\Temp\VBE\MSForms.exd AaipL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLLOffice 1Y FWhere do you want to save the file?  D r4 \ o \ re 4 bj6 ngB !D "N 'P (\ 8.^ /h 4j 5t :v ; J K O P Z [ _ ` c d CreateASCII  :00000000000.00;-0000000000.00 LPlease enter output file path and name &C:\temp\BUDLOAD.DATF F  > FINAL RPT_BUDGET 000000 00000 0000000 0000 000 HHHHHHHHHHHHHHHHHHHHHHHHH >ASCII file created successfully! ~Error - File could not be created. Make sure file path exists.VBE6.DLL T    S Sheet2ArU tThisWorkbookThisWorkbookSheet1Sheet1Module1Module1Sheet2Sheet2ID="{F1DC79AC-4A7A-11D3-8B15-00C04FCDCE4C}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module1 Document=Sheet2/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="D1D3C6EECAEECAEECAEECA" DPB="F8FAEF10F010F010" GC="1F1D0813081D2E1E2E1ED1" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=44, 44, 661, 523, Module1=44, 44, 650, 484, Sheet2=0, 0, 0, 0, C SummaryInformation(DocumentSummaryInformation8(CompObjrOh+'0@H\ p |  Brandy Wood Brandy Wood@Gܬ@ V@:5՜.+,0HP X`hp x   Rpt BudgetSheet1'Rpt Budget'!Print_Titles  Worksheets Named Ranges F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89q