ࡱ> +*  !"#$%&'()-./012;456789:,<=>?@ACDEFGZIJKLMNOPQRSTUVWXY[Root EntryF:^~מB@Book N_VBA_PROJECT0ٿמ0ٿמdir` $ Worksheet&Tools&WindowChart&Tools&WindowVisual Basic Module&Tools&Window\p Tracey Nally BYear1 AdEquipment AdIndirectInsertPINewBudgetYears+ Year1ACAD01:'Year1by: * Year1CAL01:* Year1cncmt<* Year1cndol:0 * Year1cpcmt<* Year1cpdol:1 * Year1csdol:? * Year1dccmt<"""* Year1docmt<%%%* Year1dodol:% , Year1equip01:!0Year1equipcmnt01<!!!/Year1equipdol01:!* Year1fbcmt<* Year1fbdol: * Year1focmt<&&&* Year1fodol:& * Year1gscmt<* Year1gscnt:* Year1gsdol: /Year1idircmnt01<%%%.Year1idirdol01:8/Year1idirname01:8/Year1idirrate01:8* Year1macmt<* Year1madol:. * Year1odcmt< * Year1oddol:3 + Year1odtcmt<!!!* Year1opaca:* Year1opcal:* Year1opcmt<* Year1opcnt:* Year1opdol: * Year1opsum: + Year1orgdte:C+ Year1orgnme:C* Year1otcmt<* Year1otcnt:* Year1otdol: + Year1othcmt<+ Year1othdol:+* Year1pdaca:* Year1pdcal:* Year1pdcmt<* Year1pdcnt:* Year1pddol: * Year1pdsum: , Year1PIDOL01: .Year1PIFNAME01:.Year1PILNAME01:.Year1PIMNAME01:.Year1PITITLE01:* Year1pucmt<* Year1pudol:/ * Year1rsdol:= * Year1sccmt<* Year1sccnt:* Year1scdol: + Year1sigdte:A+ Year1signme:A* Year1stcmt<* Year1stdol:(+ Year1subcmt<+ Year1subdol:2 * Year1sucmt<* Year1sudol:*+ Year1SUMR01: * Year1tpcnt:,* Year1trcmt<* Year1trdol:)* Year1tscmt<+ Year1tsfcmt<* Year1ugcmt<* Year1ugcnt:* Year1ugdol: ==*(G8?(List each separately with title, A.7. show number in brackets)77779> Person-months #$  < Requested By ,k=*~ ?@ First Name 0M0 Last Name 0TitleA BCAL BACAD  $SUMR >Proposer $@C*D?D/y FirstNamePI yXy LastNamePI yTitlejzzz  M~  {  @tr"DEEEEEFsssMN@t  L(!? %B&0)TOTAL SENIOR PERSONNEL (1-6)000Asss !  % pL  @t 5.-B.OTHER PERSONNEL (SHOW NUMBERS IN BRACKETS) 00000AGGGWW@H  D1. (~ "0)POST DOCTORAL ASSOCIATES000Azzz  M~  {  @T  D2. (~ <04)OTHER PROFESSIONALS (TECHNICIAN, PROGRAMMER, ETC.)0000|}}  M~  {  @T  D3. (~ E)GRADUATE STUDENTS00_0llmM ~  {  @T  D4. (~  E)UNDERGRADUATE STUDENTS00_0llmM ~  {  @T  D5. (~ 6E.)SECRETARIAL - CLERICAL (IF CHARGED DIRECTLY)000000AM ~  ~  @T  D6. (~ E)OTHER000000AM ~  {  @T D&ETOTAL SALARIES AND WAGES (A+B)E000000AM .  % U@D @  @T 7./C.FRINGE BENEFITS (IF CHARGED AS DIRECT COSTS)00000X0AM ~  {  IT .9E1TOTAL SALARIES, WAGES AND FRINGE BENEFITS (A+B+C)0000000AM ! 4 % U  IT BXUj32wJ((4kv @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@ =@ >@ ?@ [ (SD.PERMANENT EQUIPMENT (LIST ITEM AND DOLLAR AMOUNT FOR EACH ITEM EXCEEDING $5,000) 9IIIJ  !(n!equipment item 1~ !!oO9IIIJ ! "(a" 9IIvJ "#(# 9II@J #$.$ETOTAL EQUIPMENT$0000000AZ !$ , %!$|g $ @i $%. E.TRAVEL %00?%071.DOMESTIC (INCL. CANADA, MEXICO AND U.S. POSSESSIONS)%00000AM ~ % % IT % &.00&0 2.FOREIGN&00000AM ~ & { & IT &$'(F.PARTICIPANT SUPPORT COSTS '777777779IIIJ '(((71.STIPENDS (7K~ ((7779IIIJ ()()7 2.TRAVEL )77~ ))779IIIJ )*(*73.SUBSISTENCE *77~ **7779IIGJ *+(+74.OTHER +77~ ++7779II@Ju ,L(~ ,&,E)TOTAL NUMBER OF PARTICIPANTS,00v000AM !, 5 %(+U, @T*u-.G.OTHER DIRECT COSTS$-00000000AGG@H*u..!.01.MATERIALS AND SUPPLIES.0000000AM ~ . {. @T*u/.8/002.PUBLICATION COSTS/DOCUMENTATION/DISSEMINATION/0000000AM ~ / {/ @T*u0.003.CONSULTANT SERVICES00000000AM ~ 0 {0 @T7u1.104.COMPUTERS SERVICES10000000AM ~ 1 {1 @T`u2.20 5.SUBAWARDS20000000AM ~ 2 { 2 @T 2u3.306.OTHER3000_000AM ~ 3 { 3 @T 4.0 40TOTAL OTHER DIRECT COSTS4000000AM !4 $ %.3  4 IT +5.#H.TOTAL DIRECT COSTS (A THROUGH G)500000000AM 05 < D@ %$@&@ D,@ D4@  5 IT 26(* I.INDIRECT COSTS (SPECIFY RATE AND BASE) 6777777779YYUJ 7(7"77Name of indirect cost item 77777Amount77 77Rate779YY@J 8(8FirstIndirectCostItem8\~ 88]~ 8 8; D8D88 9YY@J 9(9\^][9 9YY@J :(:\^][: 9YY@J ;.TOTAL INDIRECT COSTS;00000000AZ ";  %8: ; @V 0<.(J.TOTAL DIRECT AND INDIRECT COSTS (H+I)<00000000AM < > D5@ D;@  < gT X=.PK.RESIDUAL FUNDS (IF FOR FURTHER SUPPORT OF CURRENT PROJECTS SEE GPG II.D.7.j.)=00000000AM ~ = = 4T 4>Q,L.AMOUNT OF THIS REQUEST (J) OR (J MINUS K)>222222223d > g< D<@ D=@  > #h ,?Q$M.COST SHARING: PROPOSED LEVEL ?2222f#?2AGREED LEVEL IF DIFFERENT $?224d ~ ? ? #e Dl^0,hZjejZIkhgdVZ00r@@A@ B@C@ D@@( PI/PD NAME@E @-DATE@PFOR NSF USE ONLY@#### @ O Initials-ORG@ C A.0Av PIFullName A003~ A`@'A#INDIRECT COST RATE VERIFICATIONA####2C B(ORG. REP. NAMEBR B-DATEBO Date CheckedB,B ODate Rate of Sheet B O, B = CQ2CInstRepFullName C22b~ C`@C23223 C 6DRRRRSDFD `>*SIGNATURES REQUIRED ONLY FOR REVISED BUDGET (GPG III.B)Pe]Kbi l$l|9x4eCreate New Budget Year(s)ys]Year]Zp $@}94eCreate New PI Row b]Z $}903eCreate New Equipment Rowb]Zi 4$x~93eCreate New Indirect Cost Rowb= " $&APage &PMHP LaserJet III@g,,@MSUDNHP LaserJet IIId "d,,??= \ l(*&4\|,($"( , 8"D@hFF Tpx|(&8`.p* * &Lt*&<T dp  SUMR ' = !R 4C10' t  !`B@L 4'@ @$JB@ @$J(tJ ! PIDOL '= !R 4C12' t  !`B@k !' !t'b = "Year1" 'debugging only:Row = InputBox("Enter the Row# to insert above", "", "21")' T `!j T$`!t equipdol | T$`!t | T$`!t$ T$`!$#REF! T$`!t$' T' gg T $`!' $|'    '* * '4  '  0 'gC 4'@ @$JB@ T!`B@j= !R 4C3'what is this for? @$JB@Equipment Item @$J(t ! equip ' t  !`B@F 4'@ @$JB@ @$J(t! ! equipdol 'fi= !R 4C6'Fo t  !`B@P 4'@ @$JB@ @$J(t !  equipcmnt '= !R 4C16' t  !`B@k !' !t'b = "Year1" 'debugging only):Row = InputBox("Enter the Row# to insert above", "", "21")' T `!j I T$`!t idirname | T$`!t |j T$`!t$ T$`!$#REF! T$`!t$' T' gg T $`!' $|'    '*, * '4j  '  0 'gC 4'@ @$JB@ T!`B@j= !R 4C3' @$JB@New Indirect Item goes here @$J(tJ ! idirname ' r t  !`B@riF 4'@ @$JB@ @$J(tn ! idirdol 'th= !R 4C6' t  !`B@sH 4'@ @$JB@ @$J(t ! idirrate ' = !R 4C8'' t  !`B@ I 4 '@ @$JB@ TB@ I 4'@ @$JB@ B@ng (P 4'@ @$JB@Comments go here @$J(t ! idircmnt ' = !R 4C16' t  !`B@$kD'Enter number of years to add$ '$  '  T *!j! T$*!tYear  ' * .If Mid(Sheets(counter).Name, 5, 2) > test Then   'gg TJ '4 '@Year1$*B@@ 4$*JYear1$*B@ Year1 (2)$*B@Year @  Year1 (2)$*(t @ year1by$J(t#need to change labels at this point'Year @ A@ kpCreate New Budget Year(s)Year1$`%j(tkY2' T `!j T$`!t05|0And 'InStr(Names(counter).Name, "PI")) Then T$`!t +  'g TA T  T$$`B@ka] m*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#C:\WINDOWS\system32\VBAEN32.OLB#Visual Basic For Applicationsoma>*\G{00020813-0000-0000-C000-000000000046}#1.0#409#xl5en32.olb#\*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\STDOLE2.TLB#OLE AutomationQ #4 24de4fac5 14de4fac5*D*4*4`@j@  TT** 4 JJ`` jJtjtt@T+ `b (2,:BοJ0vPVx\zd@arf@5X%NʪYh :S-R6d$3( 4Z:DrNKV\frvcz@ƿ*4h:Ջ 1 MD p$X.T4@]LTr