ࡱ> h  !"#$%&'()*+-./012345679:;<=>?ABCDEFGIJKLMNOPQRSTUVWXYZ[\]^_`abcdefgijklmnopqrstuvwxyz{|}~Root Entry F PzWorkbook"H_VBA_PROJECT_CUR"-P PMBD00017A04  F-PPOle >Data 1Table CompObj j  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIKLMNOPQRSUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxz{|}~.F!Sheet1!Object 1  FMicrosoft Word Document MSWordDocWord.Document.89q #xME H@H Normal CJOJQJ_HaJmH sH tH DAD Default Paragraph FontViV  Table Normal :V 44 la (k@(No List  z;<3?4|(_\0000 0 0 0 03 03 0 0 00 0 0 0 000  ::' Suzanne HuardI93\U~aqRsVs2]6h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h   ^ `hH.h  ^ `OJQJo(hHh xLx^x`LhH.h HH^H`hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h X LX ^X `LhH.aqRsI93Vs"@*                  "@*         x[q,\1\}]) ^gc zc{'@yp@UnknownGz Times New Roman5Symbol3& z ArialA& Trebuchet MS;Wingdings?5 z Courier New"h+&T&3 3 $243QH)?gc9How to use the inflation processing in the budgeting tool Suzanne Huard Suzanne Huard   OlePres0006&WordDocument ,"SummaryInformation( 8DocumentSummaryInformation8@;H% n  7."SystemLr0Px -@"Trebuchet MS- b2 Y:=How to use the inflation processing in the budgeting tool.A6J(67(7(777$5'678'527((727(6777827'72(56% 2 Y = 3 2 = 4-A2 A$=There is ONE inflation piece on the :77'7(C@67$5'57862757(67@"Trebuchet MS- 2 AE=S32 Ax=etup9(;:-22 AN= tab, the rest are on the (48%(67'7((5&767(77-2 A =Sponsorp3:9;+9+-2 A = tab.o(48% 2 A = 3 2 = 4@Wingdings- 2 )=O@"Arial- 2 )= G-2 ),=Setupo39(;:-2 )5= Tab:58 2 )= 4='@1Courier New- 2 =o<- 2 = Z-2 X=Non@67 2 =-%72 *=faculty salary inflation rate$526(1(55'17$5(67'4(6- @ !X-2  =. The pe%:7786,2  =rcentage entered here '167(52777'7'6876'7='G2 X(=will be copied into each period of the bJ77258787(6741787&686%(77822 M =udget and used to inflate 7817'5787(78(67%5'7='2 X=non767 2 =-%)2 !=faculty salaries. $517(1(55&7(% 2 G= 4='- 2 =O- 2 = G-2 ,=Sponsorp3:9;+9+-2 = Tab:58 2 a= 3='- 2 n=o<- 2 n= Z-%2 nX=Faculty inflation 4527(17$5'57- @ !{X-O2 n9-=. Enter the desired inflation amount in the %66'7'(6787(&787%5'575S667(7(67='-2 X=greeno2'777 2 V=-$a2 z9=highlighted entry cell in the faculty row. Click on the 72617(6876(&1277'77$526(1'5J%<2267(77='-12 VX=Process Faculty Inflation;+939++:53;(5;%5(9;-I2 V)= button in order to activate this rate. 87'(6776&87'(652'14(7'7('5'7%='2 X=(C%</2 =opies the rate into the 677((67'5'77(6'772 =formulap%6'R75)2 += cells for faculty).26(%6'$427(1%% 2 S = 3='- 2 >=o<- 2 >= Z-2 >X =Row inflation:6J7%4(67- @ !TKX-2 >=. %V2 > 2= Different inflation modes are available for some =%%6&77(7%5'67R687(5&7514587%6'(6S7='2 X =of the non6%(77766 2 '=-%X2 L3=salary support rows. Rows where you can choose an (55'1(7876'('6J(%:6J(J77'71672572756(757='n2 'XB=inflation mode have the Mode/Entry columns highlighted in green. 7%5'67R6877517(67G687457('1167R7(72727'7872'677%='2 X =Here is hoA7'7(76&2 =w to operate them:J(6587&5'7(77R% 2 = 3='-2 =1.4%- 2 = =-2  =Mode columnG687167S7- @ !O- 2 i=:%I2 )= Choose one of the inflation modes from ;766(66776%'777$5'57S687(%'6S='2 =the drop(778&68 2 =-$J2 *=down list (the modes are described below).86J7((%(67S687(5&787(1'777876J$% 2 ^ = 3='-2 =2.4%- 2 = =-2  =Entry column67('1167R7- @ !P - 2 j=:%O2 -= Enter the inflation value that you wish to 57(6''777%5(671467(65'167J(7(6='2 k =use.7(7% 2 k = 3='-2 =3.4%- 2 = =-2  =Click on the <2267(67-+2 P=Process Row Inflation ;*939++=9N;%5(9;-"2 9 = button. This 77('67%:7(=')2 S =modified the formulaS68$78(77$6'S65;2 S  = for each period based upon the $6'742777'6875(787867(77='2 =choice.p27517% 2 b= 3='\2 < X6=The following describes how each mode affects its row::77%66J7287(2&76(76J7527S5875%%62(((('6J% 2 <  = 3- 2 =O- 2 = G-V2 F2=PCT: Inflates a period from the period before it 8<:%7%5'7(587&67%'6S(7787&6877%6&7(='P2 $ F.=by the inflation rate percentage in the Entry 81(777%5'67&5(777'177'5277(6766('1='@2 F#=column. Has no impact on Period 1.267S7%A5(76R841(6786'584% 2 = 4='- 2 =O- 2 = G-72 F=AMT+: Inflates a period fromh;G:4%7%5'7(587&58%'6S,2 k = the period before it (6787&5887$6'7(='R2 F/=by adding the amount in the Entry column. Has 8158872(675S577(7(6757('1257R7%A5(=',2 F=no impact on Period 1.76S751(6777'684$ 2 D = 4='- 2 i=O- 2 i= G-U2 iF1=AMT: Enters the amount in the Entry column into ;G:%67'7'((775S667(7(7767''1267S67(6=';2 F =all periods, including Period 1.587&68(%71777287'684% 2  = 3='- 2 Q=O- 2 Q= G-F2 QF'=DEF: same action as PCT. Derives the =64%(5S752'675(8<:%=7'17((67='.2 F=percentage from the non87'176(527%&6S(67667 2  =-%(2  =salary faculty infl (55'1%427(17$2  =ation 4'67='(2 9F=from the Setup tab. %'6S(6707(68(48% 2 9= 3=' 2 = 4 2 != 4-NANI5@ bjbj22 "XX>>>>>>>t  t tv x x x x x x $kR > >> fff>>v fv f$fVr @>>6  I u v 0 x".6 Rf>>>>>6 @f ttdPttHow to use the inflation processing in the budgeting tool. There is ONE inflation piece on the Setup tab, the rest are on the Sponsor tab. Setup Tab Non-faculty salary inflation rate. The percentage entered here will be copied into each period of the budget and used to inflate non-faculty salaries. Sponsor Tab Faculty inflation. Enter the desired inflation amount in the green-highlighted entry cell in the faculty row. Click on the Process Faculty Inflation button in order to activate this rate. (Copies the rate into the formula cells for faculty). Row inflation. Different inflation modes are available for some of the non-salary support rows. Rows where you can choose an inflation mode have the Mode/Entry columns highlighted in green. Here is how to operate them: Mode column: Choose one of the inflation modes from the drop-down list (the modes are described below). Entry column: Enter the inflation value that you wish to use. Click on the Process Row Inflation button. This modified the formula for each period based upon the choice. The following describes how each mode affects its row: PCT: Inflates a period from the period before it by the inflation rate percentage in the Entry column. Has no impact on Period 1. AMT+: Inflates a period from the period before it by adding the amount in the Entry column. Has no impact on Period 1. AMT: Enters the amount in the Entry column into all periods, including Period 1. DEF: same action as PCT. Derives the percentage from the non-salary faculty inflation from the Setup tab. :;`ae3 : ? P   4 A D    | ( ^ _ ƿƿ˻˻hx[ h{h{ h{>*h{h{h{5h{h}]>*h zch}]h}]>*h}]h}]5 h}]5hq,\h}]%;<3 ? 4  | ( _ \ !=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=gd{p^pgd{ & Fgdx[^gdx[ & Fgd{ & Fgd{ & Fgd}] & Fgd}] 1h/ =!"#$%Oh+'0 , DP l x :How to use the inflation processing in the budgeting toolnow Suzanne Huard iuzauza Normal.dotrSuzanne Huard i3zaMicrosoft Word 10.0@ @]u@šu3՜.+,0  hp|  o A :How to use the inflation processing in the budgeting tool Title  ـ`\p Suzanne Huard Ba=   ThisWorkbook= 8u!8@"1Helv1Geneva1Geneva1Geneva1Geneva1Helv1( Trebuchet MS1 Helv1=Helv1( Trebuchet MS1Helv1( Trebuchet MS1( Trebuchet MS1( Trebuchet MS1( Trebuchet MS1( Trebuchet MS1( Trebuchet MS1* Lucida Grande1(H Trebuchet MS1( Trebuchet MS1( Trebuchet MS1QTahoma1QTahoma1QTahoma1QTahoma1( Trebuchet MS1( Trebuchet MS"$"#,##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.0%###0_);\(###0\)###0\);\(###0\) #### 0.000%$[$-409]dddd\,\ mmmm\ dd\,\ yyyy m/d/yy;@#,##0.0_);\(#,##0.0\)#,##0.0_);[Red]\(#,##0.0\)%               % ( &      %   %  % H %a   %`#  %a#x %`! %` %`  q  q H, q( q  q   %! q(X,  %   L,  L,   q"8 q ( %`# q" %a"8 & & ,  %a"  l ,  l ,  %` * `"* %a H  %!*  % @*  % @ * !*  %a %a %a"  %a"  a   a"  a#  a  %a  %a  %a" %#  %a#     %a" %a! %a!  %a(  %a" %a   %a* %a!  %a!  %a  %a  %a %a"  %a!  %a"  %a  %a!  %a!  %a %a" %a(  %a(  %a# %a(  %a(  %a# %a"  a#  %a  q   a#  q q H & L q H y  & * %` *  %` *  ` *  a   %(X  %(X %(X %( %(X %  % H 1 * %!* !* % * !* * %  L p * %a %a"  !  %#  %! %a  %+  % % %a  %" %#  %a#    %a"  %!@   %"@  %a @   %"@   % %  % @ %a   %"  %a   % @   % @@   %a @   % *  %"  %)@   %  @  %    %    %  @  %  %  %" % %  %"  %  %# %` *  %"*  %` * & %`( `( %`( %`* %`*  %`(  %`( %`( %(    $Normal_budget structure v.1.xls Normal_Budget Structure.xls8dq:Fc-2NWgFSWc-2NWgFSW̙̙3f3fff3f3f33333f33333\` YSetupmSponsor SubAwards Cost SharingԶ Pgm IncomeHelp on Inflation Blocks @Rates Data Lookup Version Notes ,) AppointmentList;( AYFacultyBlock; $ BudItemCol;, CostShareCopyRange;) ) CShrBlockEndRow; ) CShrBlockPrdCol;( CShrBlockRange; + CShrBlockStartRow; , CShrBlockTotPrdCol; ( CYFacultyBlock; %Data_Validation<- DefaultInflationRow;& EquipmentRow;%FacInflationPct: ( FBRateTypeList; ! FFRtRow;& IDCBasisList;% IDCRateList;" IDCRtRow;# InBaseCol; $ InBaseList; + InflationEntryCol;* InflationModeCol;+ InflationModeList;+ LockStructureList; !+Module2.ProcessInflationMode NumBudPrds:  NumCoPIAY: NumCoPICY:NumFacAY:NumFacCY:( OtherExemptRow;%%( PartSupportRow;##! PDRtRow;! PFRtRow;PIAppt:PIName:  PrdCol;# PrdHdrRow;' PrdStartDtRow;&ProcessFacultyInflation#ProcessInflationModeProcessSubsIDC' RatesEndDtCol;) RatesFBStartRow;$ RatesFFCOL;* RatesIDCStartRow;$ RatesPDCOL;$ RatesPFCOL;) RatesStartDtCol;( RatesUINSOFCol;( RatesUINSONCol;( RatesUOTHOFCol;( RatesUOTHONCol;( RatesURESOFCol;( RatesURESONCol;-SetupDefaultInflationRt: # SetupFlatRate:# SetupIDCBasis:# SetupLockCell:*SetupMaintenanceCell:)SetupNegotiatedRate:" SetupStartDt: * SponCstShrTotRow;*** SponPgmIncTotRow;++% StartFacRow; $ SubIDCList;&() SubsApplyIDCRow;& SubsDCTotRow; 0 SubsDirectCostStartRow;* SubsExemptIDCRow; ' SubsIDCCapCol;) SubsIDCCapRange; & SubsIDCRtRow;) SubsIDCStartRow;' SubsIDCTotRow;' SubsInBaseRow;* SubsNotInBaseRow;- SubsNotInBaseTotRow;$ SubsPrdCol;0 SubsRemainingInBaseRow;!!3 SubsRemainingInBaseTotRow;,,' SubsTotPrdCol;$ SubTotGrad;$ SubTotSubs;!!# TotDirect;&&# TotFacRow;   TotIDC;((# TotPrdCol; $ TotProjRow;,,  TotSal;" TotSalFB;$ TotSponsor;))# TravelRow;$ TuitionRow; VersionNo:1 WorkbookMaintenanceList;#$$ ZeroPrdCol;"fffP0@`, =hF /.$"ID a@=ID a]6Stfx< p]u>I)L$G$@?8a`Z҉dI-{,G 0@δpzJҒ!dL;& LvPݳ'=?~νg9{~{CBݢbŜB\X/DzuBbkH Q?O^-GM:*J [p%;*Pz뺣=}tW[oT^MyؕBCsE5կUt ɹtm/OLMMqz&붉bH b ~'tѿo+W ❹"LRO06 凯_#{~`x=p3{ αh^<;.IOC!zk 7 eJJǣƏ]P3|$BIAYCv]=!PJ-bX)o")[lHJ7//I9$wȊ֏a~|>m});ޟZN?4 QI{لߡM:.ADžo'3Hq1<1gtLe By`O CDfy(?{1 ~"^kx}ii޹h%6>HpK/se}/<(UzDH^lj[8,q7\7CEo- }8 a}n-f_{lrG7e (TM<-Ϻ=-g8j۬?iU6rLVR]SwL~F?Jct  ~D~b7;t+zx5(psa?H-)Av yVQ/° 8RTORwR7D:> w{So^G40rĘj] :〔~ C,Ŀ&: 챫Z9U-zЉ}kǼ= 0|e▓KHO'T蹹G}Mr UDX89tc(exv34!j rJ1pYG%G1V>K98"v#ce~ N?Q9#|+ 6ń38 и1˫!t|eV'Y5<#4n>p3x08;H<=Is*\ZL=@_S!4au#o_/T(<]eațjޠL.NK }_\Yj[PRx.aa؎+}ځ~َIzlR9A.4,F9#gLwO)6`? )ޣ l{nDիN`L c`7a,#4VToH~9re7\@q~r^1{;x,r^9+<(6L%9vň,T }rP|k!Mo+t,;=Y ]ҶCێ19HE? Q8mCW2ӡFN´W^WvadaW+v >Vmln° .U_:@XlSQKھX|_E_hKKa-ۏ0??Ƹ b{jܚEk?9k2ZIwBvTSaӧOɵy߭ J}=\~#1iË6utߚ=؝L'Y3nsERͱbr,],L!茋/)Hv뿜Quqԅo gCy7  wqIE *HBd弸˚1)͘cl5c3Ȑ2_;gIǜ}cld|Mrm$灁Arzܻ&-L[]m2f8`+~|Ƽ] 8k ^!|}B:QX^rѯѽRCG0rLbMIc.o|҈:nh6di3ӵYT}S駧20h 3PMxߌxMx{Qg5 eEgn֌/XݥOmqM {X9"o5즎Tz"  }\jrlkE0L}b۪ld(ao.?˘mx<ҋ|_Kϟq|GOrֹzU{moףjcv! .(7mF9 1a)5aSY܂o{d&SiM_ڻQbc=-&frF^Y#p`0pvv=Z_R8Qͱl$EjWDY#~Ss{]st,{HP+?Z YR+fkH2,}9~Q7ŽVN/~p~&a|p.Ad=LJW̢wș)d1aqV%uM?ĸ[}M9s)֦FIBÎ~DgsRٜ9U͹Pi+ hsjls 9ImrkwUUUޏW}vav@H81N1q~ṕz̀A{R5#y`:|oG5Zs)0c Ɯcl;iu`Kqqvꨈu:.nJ9t۹`ݶ݆4n;mfN-q!ܮJ&N9oPy[lggNa;/`9os^}+WѽeO>Vt}֦ aHW]ɥ5*.^W1r|oc~  !^SmW_u0C=_/:z]I\jkgHC-!W(L4 iHΉ{z=Z=W7Ѱ'9cn,e;>t8غ^5Os*;*GR#?|p1S>aW_z۱!aGP_y5^my.w_InWnr3yCERWӜZ>Uw[{ X."o1Xϛu6fRFØCj3b23Fz.Zŏ^?ff{]kOzK_1BةOE kA_5O\bfqt~!y^T csS#r;l טCUHzRNV!U{ytR{'\|}$hY{_/O:_7jRJ2Z tsP?w:r%Xh3soQqm!KOoGk7[/}5Vih+Mu[Iÿd~ {k;N??r<{:PG?[w:aDE aR{o+ ܼ „-w?hh@f>95MezjE;L큜 [jw'g:F,6B:/;d`}ʧ @ ;KG+z'zϕmc2<^2ѿXt:}:./܎+RrЃ˧=ٺ||]uٺ^|qECNk/tr#>^h+u?$}s\>m:1]K<ؙ ^ ӎnyŰw/hc{w{ZMVc.&= .}}U_ >-郡z[Z_>@`$cg`W-c9k`L#}0.ѢwK(^5$k*?uz6 nsxI#WbZ}h^ӿv߯½e;㡿 kkh?x#Go']o8Bث[{K8ߩq~p  쿦gk6U?ۏ0l<`_'Ϙ{y92-$} Lv5-}*z|xKh?º><6׽8`~afn߆Nucroc{e勻<_]X1J|z']f9ssx<|CrvUy_*wStfL xMlUEg}GEbn?D R`R@K#!hD Ҹk &Zε$nÊ3tKZHr=nW̻ܙ3;~~Jmngi-> X~=~rc'G ?V.;SZzU}McI{1|Wp˓[84잼v͕_|jf]WDss/Mwn[ӄt;܁eas߸j硵BkS䲄9:ʝr.E ^A Q$JQpX35h-Ya 9VE#fvveoyc=p;k]A ne:{!ۻ۟F]*b p4o l*}" 5U㙥SAU&W:؆G~PX>ڱcU-vWŲH82Gsqպ5}(Mq1\8^ݶng? W[o?2;3y9\u}*IuF !k-ڏ^=1=t hƱJ+}י{\ 5ȑ1y(v`*OVCg^]ۂ_o-g\DGngM wοR5݈hiNi}$YثJM^)g~e( =fG/dM~"k%)^Z>C nem\YgFrngx5{Ԋc9MaLA)Mإ۰u]ki- vB2(֥S(Mk<Ee ٮ ºgDد]g\+F߇vuؖ*QS'n|biΣҮ}gV3V d-bRדb0Uew K%(cxX.NQ$_WGT/bE=\(^T ^e\BJUX{EOglgJe=e\c=L0 nb"]gc0*3J o23xq kـV_ZgóGΜQ.PĽ|-hb{-]5j5ZaR5uUwv]cmTu(?7ވc'exbsݔ b' ˴DV`,sA{9+O(ORxKUҽ<vhx؈[*_Ά:7u6Y'H2QT̛3[=#'܍Uğ 0=|f?!)(bQŞ*Tl?gc{2zZn|GMc5++I} ReOW\};bYTuf c !)F|v;q(|ھv3cs,Q+X'soRuOm7zh{ݔ'֔9f˵UJU/ݭz pY'sW{E-{i_=_[SXe-"~5=SxC}B덉 M(nҲvRqqυ1̸_c[{emJsEv8(N=c"DvCXcGےY׺_[\.r=)wkpzsQXFpu"ְ#n깖ܑzszM 5+jsbWf稸\娥zqͶ5"P#7ͺR5Ǭ\<BXe6ئᕡX|+z$ܥ8zp}qORcV{U(2g%y[ϔNΕp5׬lkUR{Yl7YlN"OP ~ T <Wl XPP? ]4T@Wl  H6Q q8<rPI Info: Name: no particular formatting. Appointment: AY for academic year; CY for calendar year appointment. <8)  #+M7$q~~ W <PXl XPP?  ]4W@PXl  16\H)?zn8 H<IDC Info: If no IDC, ignore this section. Negotiated Rate: Choose from drop down list. If using a flat rate, choose Other & .or Flat Rate: If using a flat rate, enter 10 for 10 percent, etc. IDC Base: Choose from dropdown list. <H.*\9G~P2mic~~ X <Xl XPP?  ]4X@Xl  Ӏ/؈=L\+ {<|Will be used to inflate staff and non-AAUP faculty salary. (You will enter the AAUP faculty inflator on the sponsor tab). <G{s~~ [ <Yl XPP?]4[@Yl  "NrV /H<0#Co-PI (AY): Enter number of PI's with academic year appointments. #Co-PI (CY): Enter number of PI's with calendar year appointments. #Other Faculty (AY): Enter number of other senior faculty with academic yr appts. #Other Faculty (CY): Enter number of other sernior faculty with calendar yr appts.<HMDFP"t5s+/Dry~~ ] <|Yl XPP? ]4]@|Yl  FK7Frnl t<u# Budget Periods: Enter number of periods in budget. This will determine the number of columns in the spreadsheet.<jtm~~ _ <Yl XPP? ]4_@Yl  N[r~Jʾ!%! (<Lock Structure: Defaults to N (no). When you have completed the above data, change this value to Y (yes). This will allow you to visit the entry tabs. Once the budget structure is locked, you will be unable to add periods, co-pi's, etc. <(Yw&T Suzanne HuardW Suzanne Huard X Suzanne Huard ] Suzanne Huard[ Suzanne Huard_ Suzanne Huard>@7)lrdѕ + rd#4 rdd + rd#d+ rd#d, rd , rd  + rd#  SetupSheetgg@   ـ 3 |8  dMbP?_*+%, &LConsolidated Sponsor BudgetVS&L&"Trebuchet MS,Regular"&9Last saved on: &D &T&R&"Trebuchet MS,Regular"&9&P of &N&?'p= ף?M KONICA MINOLTA C351 PCL  odXXKONICA MINOLTA C351 PCL  odXXKDRVR|kddddddd4321  shuardo R|kshuardX 132.177.208.254RH15ENU6US2OSRe1234"d??cU} $@} @} @} @} $ A} A} $@} $@}  @} @} B} $B} !}  @3@FVF,@@@@* , , ,_ ,_ ,_,_,_,_,_,_,,@ @,,,,,,,,,?P C` PropBud v1.5 ??CCCCDD EvECCCDD sCCCD rEECCCDD  KGIJ KKLLHMM  K GIJ K KLLHMM  K"GIJ K"KLLHMM  K#GIJ K#KLLHMM N(OHII KKLHHMM P P Qf  Q= R  Sg  SY  Tp~ > U> V Q0 Q WVXX  Y GuH ZA [[\\~ H' H @%  HMM ]n ] ^B @AA@@' _ @%  `` aab ^C c~ c& 8 D D@' _ @%  `h `i aab ^~ c 8   LL@' _@%  `h `Z dde Za \\ f~ c#\ % ' \@% \gg aab ^D c~ c8  ' _@%  `h  `\ aab ^E c~ c8  ' _@%  `h  `[ aab ^F c~ c8  ' _@%  `h  `[ aab ^ c~ c8  ' _@%  `h  `Z aab ^ __ c~ c8  ' _@%  Bh  Bi GGH ZGIIHH/H %|DD ' H@% HMM ]j] ^H ___ h~ h_ x%  FF% BYD%  PF% BYD@@%  PD% BYD@@' i@%  Bh GGH ZIIIHH%H DD' H @% HMM ?k? @Jh&Ahr' @ @%  Bl ?k? @Kh@&Ahr' @ @%  Bl sks @Lh%Ahr' @ @%  Bh jG HMHIIkkH' H @% HMM sks @bh@%Ahr' @ @%  Bh sks @ch@%Ahr' @ @%  Bh sks @dh%Ahr' @ @%  Bh skt @eh@%Ahr' @ @%  Bh lk? @4hh@' @ @%  BhDl@<HPPPPHll{u{{{o{{{{ ,!,",#,$,%,&g@';(+@)@*F@+,,F@2, lk ? @5 h h@' @!@%  Bl !jGH !H3 !II!kF,k#!H! % @'! H" @%!!! HMM "sk"t "@"h %Ahr'" @# @%"" " Bh #sk#s #@#h0 &Ahr'# @$ @%## # Bh $sk$s $@6$hr'$ @% @%$$ $ Yh %sk%s %@7%hr'% @&@%%% % Bl &HHH &HN &IIH,&H&% %"%B,&H& % %"%B'& H'@%&&& HMM ' '0''% % Y% %BY0'' % % Y% %BY'' (@%'' ' (@O(h!(@( DD'!(@( DD''( @)@%(( )HHH )H )IIH%)H)D(D&B$%)H) D(D&B$') H* @%))) HMM *@ *hh'* @+ @%** +@ '+ @,@%++ ,HHH ,HP ,IIH+,H,D+D*D)+,H, D+D*D)', H4V@%,,, HMM 2XXXX L{{uuG9  X, V E(  x ' 6lCC@h],'@l dV$l9* $<Process Row Infl ation<nxx : 6XlCC@Gr],:@Xll Vl9) $,<-Process Fac Inflation (1st Year inflated)<,)}0xx @ 6lCC@h],@@ld Vl9 $<Process Row Inflation<r >@   5C #9"% + #9 , + #9   SponsorSheetgg@   ـ .Z~  dMbP?_*+%,+(&L&"Trebuchet MS,Regular"SubAward BudgetVS&L&"Trebuchet MS,Regular"&9Last saved on: &D &T&R&"Trebuchet MS,Regular"&9&P of &N"d??cU} } m } } } m .  , X , , , , , , , , , , , ,  ,,,,,,,,,,,,,,,,,l C` PropBud v1.5 K!LGHI    f =  ;T~ <'@%/  ;U~ <'@%  ;V~ <'@%  ;W~ <'@%  ;X~ <'@%  ;~ <' @%  ;~ <'  @%   ;~ <'  @%   ;~ <'  @%   ;~ ='  @%   N#   % ' @%  V ]DTotal  L Sub #1~  $  Sub #2~  ,  Sub #3~  Ĵ Sub #4~  Դ Sub #5~   Sub #6~   Sub #7~   Sub #8~   Sub #9~  $ Sub #10~   ^# %  _~  $  `~ " $  D l2@LUUUUUUUUUUnQ~~ggggggghd OO , !, ", #, $, %, &, ', (, ), *, +, ,, -,  !! != !"4"D Sub #1~ ""# $" "#D###+ L Sub #2~ ##$##+ , #$T$# Sub #3~ $$%# $%d%# Sub #4~ %%&# %&t&# Sub #5~ &&'# &''# Sub #6~ ''(# '((# Sub #7~ (()# ())# Sub #8~ ))*# )**# Sub #9~ **+# *+ĵ+# Sub #10~ ++,# + ,#,, %"+, $,t , 4kggggggghh , 0( $ x   6HlCC@%x], @Hl l9+ $ <Calculate F&A<K >@7+ #C9 SubAwardsSheetgg@   ـ E  dMbP?_*+%/,&L&"Trebuchet MS,Regular"Cost-Sharing BudgetVS&L&"Trebuchet MS,Regular"&9Last saved on: &T &T&R&"Trebuchet MS,Regular"&9&P of &N"d??cU} m @@@@*Ե C` PropBud v1.5 <2  pBPH@ 0(   >@7CostSharingSheet   ـ /3  dMbP?_*+%1.&L&"Trebuchet MS,Regular"Program Income BudgetVS&L&"Trebuchet MS,Regular"&9Last saved on: &D &T&R&"Trebuchet MS,Regular"&9&P of &N"d??cU} m /@@@@@@ @* C` PropBud v1.5x2(g@)F@*+@+@,F@.F@xd  pBPHP$0(  $>@7 PgmIncSheet   ـ [  dMbP?_*+%"dXX??cU}  `((  (v ( <A ?AA@? )]H`  lhDocumentz>@  7 Sheet1ggD   ـ   dMbP?_*+%,"d??cU} $$} 3} $} $} $ $} $} $$} $$}  1} $} $} $$} $$} $} $} $} $ $} $} $$}  $} $} $} $$} $$} $} $} $} $ $} $} $$} ! $} ""$} ##$} $$$$} %%$$} &&$} ''$} (($} ))$ $} **$} ++$$} ,- $} ..$} //$} 00$$} 11$$} 22$} 33$} 44$} 55$ $} 66$} 77$$} 89 $} ::$} ;;$} <<$$} ==$$} >>$} ??$} @@$} AA$ $} BB$} CC$$} DE $} FF$} GG$} HH$$} II$$} JJ$} KK$} LL$} MM$ $} NN$} OO$$} PQ $} RR$} SS$} TT$$} UU$$} VV$} WW$} XX$} YY$ $} ZZ$} [[$$} \] $} ^^$} __$} ``$$} aa$$} bb$} cc$} dd$} ee$ $} ff$} gg$$} hi $} jj$} kk$} ll$$} mm$$} nn$} oo$} pp$} qq$ $} rr$} ss$$} tu $} vv$} ww$} xx$$} yy$$} zz$} {{$} ||$} }}$ $} ~~$} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$} $} $} $} $ $} $} $$} $} $} $} $$} $$ , , , ; ; , , ; , , , F@,!  C` PropBud v1.5! 4 . // f  =   2q  2Y p> Crq9 0?%D D&r  DD   $   5h  5[ p> C :~ 9 0@%D D&r  DD  $  5h  5Z3 $$  11 3 $$  11 p> Cq9 0 %D D&r  DD $  5h  5[~ X $Q~ r @ $  $R~ r @  $  onm mS mmmm# H % 0. HX $  mmm p2 l&&?? m  PHp 0(   >@ 53 #  3 #  3 # BlocksSheetgg@   ـ /Z  dMbP?_*+%,"d??U}  &}  '}  /,,,,,,,,, , , , , ,,,,,,,,,,,,,,,,,-( vC` PropBud v1.5 ++,,,,,, 6 6 7 7 7 7 7 76& @&@'G@':@@M@':@'?@':@&@&@@'F@':@'#~j?~ ':@'S?~ ':@&`@&+@'F@':@'#~j?~ ':@'S?~ ':@&,@&Y@'F@':@'#~j?~ ':@'S?~ ':@&Y@&@@'F@':@'#~j?~ ':@'S?~ ':@&`@&@'F@':@'#~j?~ ':@'S?~ ':@ &@&@'F@':@ '#~j?~ ':@ 'S?~ ':@ &@&@@'F@':@ '#~j?~ ':@ 'S?~ ':@ &`@&=@'F@':@ '#~j?~ ':@ 'S?~ ':@ &>@&k@'F@':@ '#~j?~ ':@ 'S?~ ':@ &k@& @'F@':@ '#~j?~ ':@ 'S?~ ':@&@@&@'F@':@'#~j?~ ':@'S?~ ':@&@&@'F@':@'#~j?~ ':@'S?~ ':@&@& "@'F@':@'#~j?~ ':@'S?~ ':@&@"@&O@'F@':@'#~j?~ ':@'S?~ ':@&O@&}@'F@':@'#~j?~ ':@'S?~ ':@&}@& @'F@':@'#~j?~ ':@'S?~ ':@&@@&@'F@':@'#~j?~ ':@'S?~ ':@&@&`@'F@':@'#~j?~ ':@'S?~ ':@&@& 4@'F@':@'#~j?~ ':@'S?~ ':@ ++,,, 6 6 7[ 7Z 7\& @&@'F@'ʡE?'Mb?&@&@@'-?'K?'Mb?&`@&+@'On?'sh|??'E?&,@&Y@'D@'sh|??'S㥛?&Y@&@@'&1?'/$?'?5^I ?@j D2&p:bbbbbbbbbbbbbbbbbbb F@LL@ ,!,",#,$,%,&,',(,),*,+,,,-,., &`@&@ 'x&1? 'ʡE?~ '<@!&@&@!'x&1?!'ʡE?~ !'<@"&@&@@"'x&1?"'ʡE?~ "'<@#&`@&=@#'x&1?#'ʡE?~ #'<@$&>@&k@$'x&1?$'ʡE?~ $'<@%&k@& @%'x&1?%'ʡE?~ %'<@&&@@&@&'x&1?&'ʡE?~ &'<@'&@&@''x&1?''ʡE?~ ''<@(&@& "@('x&1?('ʡE?~ ('<@)&@"@&O@)'x&1?)'ʡE?~ )'<@*&O@&}@*'x&1?*'ʡE?~ *'<@+&}@& @+'x&1?+'ʡE?~ +'<@,&@@&@,'x&1?,'ʡE?~ ,'<@-&@&`@-'x&1?-'ʡE?~ -'<@.&@& 4@.'x&1?.'ʡE?~ .'<@"dHHHHHHHHHHHHHH > @7 RatesSheetggD   ـ )  dMbP?_*+%,"d??cU} &$} $'#}  $),@,XXX,@, , @ , , ,,@,,,,,,,@,,,,@,,@!̸ 0vC` PropBud v1.5 "m %n #o %p #t %u #w %x #y %k #z "{ $h #| $l #~ " $[ # $Z # $\ # $i # "% $ $ $ $ $ $ $} "' $ $ $ $* "- $. $/ "Dl2 ,!,"@#,$,%@&,',(, $h !$l ") #$ $$ %) &$ '$ ($2 >@ 5 LookupSheet   ـ   dMbP?_*+%"Det??U} m D} m D} -D TvZ PropBud v1.5~ `]@ d  >@7 VBAݟP0PThisWorkbookSetupSheet Module23(SLSS<N0{00020819-0000-0000-C000-000000000046}x  h@%@@p}E " D "Px  ,>Open to SETUP tab if workbook is unlocked; else take no actionsoftMsgBox ("In Workbook_Open")rkA@ Setup % B@"ocikP ( $(&&again in case closed funny oWorkboook_OpenAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 PA Sub _@Open()' to SETUP e if w is unlocked; eke no action!MsgBox (("In 1"1InitializeVarsIf Not IsL+P The# PBP.Sheets("SetupP").A7v1 End IfApplica!.CalcuJ$a@YxlAuDc 'again %ccl[fuXnnyAF'okF ls _#xME (SLSS<N0{00020820-0000-0000-C000-000000000046} ,@ .`0sh%@ @}E) "  "   8 X 8`h   , H (P x , <08@H P`op@]2can't get the upper case function to be recognized 1check to see if user has now locked the structure SetupLockCell 2$ %4!6Y SetupLockCell 2$ %4!6y 8'A@: SetupLockCell 2$ %4!<B@>A@@ SetupLockCell 2$ %4(BF 2$ B@DA@Hk`dX'N SetupLockCell 2$ %4(6kkSetupMaintenanceCell 2$ %4!6Allowed'Jd'JkoAttribute VB_Name = "SetupSheet"D Bas0{00020820-C$ 0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplate`DerivBustomizD24 P" Sub Works_Activ ()EndDea  Dim strApp@t As Sng 'can't get the upper cfun"on to be recognizedIf Not IsLocBkvThen 'check see if ushas npow l A#uctur@Y @ s(t).R`ange(CCell").Valuq"Y" O8r _ny" .!OK 9;= CnBuildBud@RW6Eh'idation.DeletDHUnprotectEntry@A %oQ3Psinterfonly:=BWIfEtI= dg%,CN LMananceMAllowedIFIsIn('/dG aSub rU~|      \Rffff*0]4a1288d7A 2 8 2X    ( ( 0 @ P ` p       D0 H NX 8P h  &: :*P /  2  2 "   h0 1$2p9jh<xME (0Pj046 </R+P@Setup%SponsorPBlocks%Blocks Cost Sharing% Pgm IncomeRates% SubAwards%%^+, @b0 @d+2 @ʘh,B ʘlBʘn@,Bʘrh,BʘvBʘx,Bʐ2,(Hʐ~pHHʐ,XHʐ-xHʐHʘ0-aBJX-8 !@ʘB#L ` :` `bb`Sed`----`----  St%`X`` gbl`ean P` @`HH``` $ % temC%  in % 8w to% ``kk  to % Se% r% %` Co` Pg` Su`Ra h`//` (` er s % % (T% Hulty%` et: P `..` >On` hed, otFa%  uara% 0 on f%` )  ` i" lty )$ $# %`e ce  `0 i(ce. h enti%  % * 1 re% , app%`.ad  ` "" @ w").% ` umn)% * In% , $ %`22$`4PI  `  6 ` 11 p CY %  %4% * 6% , Bloc% < la%`>ad`@t lo`BY `Dc`F`HAY 8 ` 00  %  one% < ETUP% *@02% ,`!%`>`@CY `B `D`F6 `H :h`11 P Num% pNumF% *% , % <0%`>`@`B`D'in`Fr ea`Had (`HH  % Facu% *% , % R@ for% <`ls; %`Tom r`V`>%4`@Star`B4`DTotF`F!`H To `))`Za = `\w & `^ & "`` iTh`b=Sum fP``j`l! h``j `normu`p col P` r0%`tts(S v` isCo% ("To% xHere% ztRow% ~`,, h% ----% r% uctu%`%ad ``(77ith f `comp% s th% asis% 4in% d to%``rtDt`A`` `77i  wit% to a%  spo% 8et% Xock %`il a`1co`he o`ubs` 8`;;i Popy % pd% % % Pr%` ``TotP` |`x00i  % Row% !% % 0 the%`KBe`stru` to `mula `&& 7% otRo% X` ` `]]``` `Su`74`Col`(``.Off` ` the`cost  co% 0ds% Pto t% pno h% has % $%  why% `<< 0ockP% P% p!% 7% % CShr%`  `(( H % h %  pM%  X%  %` ! ` -- @!% `!O% ! % ! % !P%`8 H "!`!  @`""`" +P ##`"#i"i"Ti#4i+#$``#$ I # I +@$%`#%i$PWi $(i %&`$&i$ i$Yi$i ` +x%'`X%' i +J@&(`%()%% %i&4i r8&%+N&)`&) i ]` ]+L0'*`&*i X^` ^+'+`p'+ i'@_i+(,`', i+X(-`P(-""i`\`+@).`(. i)i )ib+8)/` /,,``  +0*0`)0 i*ixc+1`p*1 i*i ʀN* @0@T(+p@VP+@Xx+ @Z+$@\(@`. @f04 @ʘjXBʘpBʘtBʘz Bʐ|H8Hʐ`HʐH6 @ꀌ8: "@*x%  h*!P # 8(X0',% -(,X-0- @&(@)h,' "p0*P8`"x++&,`#@@$+P (+,P++X0)h+@,`HP p22$*0*8`@-}E*\R1*#2ad*\R1*#1c8$*      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~B& 0 2H  2" b F@  2"( 80 h . D H 0H x ( 2 " . .P 0  "  ` L` H  X ` h 6x   6  " &0  X h    8     6 (&@ hx  >   . ( &@$h   : (  .0 `$x   @ (  T0 ".,B  lhP ( 8 H(BX   ,N d0 @ n  H 2h" 6 , \ Bp : *8@HPX ` 2" F . N8 8  "  ( 68:p8D8j  (  RHHF@X "p R  z  *  6 & D0 ,x D J HP  &RH  ` p x    2  2! "8! R@! "! ! (! "  "("0"8"@"H"P"X"  `" p"" &"D"<#H#  `#x## #N# j$ p$ ((%  P%`% h%% % &%R%B0&x&  &&& &N& 8'  H' &h'L'D'(( @(`(x( (N( (  (D)FX)) ))) *N* `* p*  x** &**L*J +p+ "+++ +J+(B8, , h, ,--  - (- >@-"- -- ----- V- .8(.N`... . .  @. L8/ 6/ 2/&/* 0(P0(x0 00  V0 J 1 Tp1 1>1< 2T`2V2 33 3 >@3"3 33 3333 X3 \4 p4,444 45 5 5  @05 Jp5 25&5 6  V@6 J6 T6 @7 X74h7R7T7 P8p8x8 28 8 28" 9  09 89H9 `9 p9H999H9(:  0: 2H:" : @: 2: ;; ;; ; (; <8;Fx;; ;; ;< < 0<8< 2X<"< Z< @< 8= @=H= P=X=`=h= &p= == H=L>P> 4h> > > > >>  > 2?"8?@?H?P?X? 2x?"? @? ?@ @@V@ $p@ 8@4@0A08AhA A6A@AB:(B XhB DBC (C  &8C2`C 6C"C4C0D@DPDJpD&D  D D E 2 E"XE D`E EEVE FF $ F 8HF4F0F0FG 8G6HG@GG:G  XH DpHH H  &H2I 6HI"I4IIIJJ J&pJ  J J J 2J"K DK XK`K hKpKVxK $K 8K40L0hL0LL L6L@0MpM:M  XM D NhN N  &N2N 6N"0O4XOOOO JO& P  HP XP `P 2P"P 8P JP dHQ DQ ^Q `XR R &R SS SS SV(S 6SPS$T 80T4hT0T0TU  U60U@hUU:U  0V  X0V DVV VW . WPW &XW 2W (W :W  X 0X @X J`X X X  X  "XY>YPYXY pY xY 2Y"Y 0Y \Z BhZ 4Z :Z 8([ (`[6[6[D[:@\ *\ 4\\](]H]`]  x] ] ] ]] ] ] ] ]]]  ^ 2 ^"X^ P`^ *^ ^^ ^_ _@_X_ `_ 2_"_ P_ *` @`H`P` X`h`````` a 0 a"Pa :Xa >a aa a ab bb  b$0b Xb hbxb b 2b b 2b 2 c"Xc `chcpcxc cc@c2c d 8dHd Xdhdd d 2d"d d eee e (e 0e8eHeB`eFee f f (f 0f @fXf hf xff f ff f fg g  g8g @gXg  `gpgggg 2g" g Rg PhXh`hhh phxhhhhh 8h Ph <(i  hixi0i iii (i j(j0j8j 6@j *xj.jj Dj ,8k hk<xk  kk k k (l (l 8lHlPl Xl hl 2l" l @l Nm PmXm`mhm pmxmmmmm 8m mm0n