ذدà،±ل>‏ے	‏ےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےے‎ےےے‏ےےے~‏ےےے
 !"#$%&'()*+,-./012345678‏ےےے:;<E>?@ABCD9FGHIJKLMNOPQRSTUVWXYZ[\]^_`ab‏ےےےdefghijklmnopqrstu‏ےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےے‏ےےےےےےےRoot EntryےےےےےےےےہF>ًـ;ً¼ے}^pw½€Book
ےےےےےےےے=zS_VBA_PROJECT€uùU	½™EùU	½dirےےےےےےےےر		
 !"#$%&'‏ےےے)*+‏ےےے-‏ےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےجaج]k*\G{000204F3-0000-0000-C000-000000000046}#1.0#9#C:\WINDOWS\SYSTEM\VBAEN32.OLB#Visual Basic For Applications00Y*\G{00020813-0000-0000-C000-000000000046}#1.0#409#\\DISDEVEL\RICHDEV\delthis\xl5en32.olb#\*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\STDOLE2.TLB#OLE AutomationجQ ےےےےےے	نع#•4ےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےے	234719a30
2349523d4*D*ےےےےےےےےےےےے4ےےےےےےےےےےےےےے*ےےےےôےےےےےے€ےےٹےےےےےےےے4 ےے`ےےےےےےےے@ےےےےےےےےتےےےےےےےےےےےےےےےےےےjےےےے@ô´ےےےےےےھ
ےےےےےےےےےے”ےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےے ےےTےے´ےےہàTےےےےےےےےےےےےےے*ےے*ےے ےےêےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےے
ےےےےےےےےےےےےےے4ےےےےےےےےےےےےےے€ےے ےےےےےےےے ےےےےےےےےتےےےےےےJےےےےےےشےےےےàےےےےےےےےےےےےJھےےےےےےےے ےےےے€ےےےےےے`شےےےےےےےےےےےےےےےےہہےےےےےےےےےےےے`
ےےےےےےےےےےjےےےےےےJےےےےےےےےےےےےےےےےےےtjےےےےےےےےےےٹےےtےےےےtےےےےےے@ےےےےےےےےےےTےےےےےےےےےےت÷â”ےےâے€+ےےےےàےNتےےےے
ہے“`ےےےےàےbےےےے âےظےےےے(آےôŒےےےے2&¯,ےےےے:آےûےےےےBہےFخ؟ےےےےJآے0vےےےےPآےًٍےےےےVآے¸xےےےے\آےëzےےےےd&@a´ےےrآےtBf@ےےےےŒہے°ْےےےےœہے5ےےےے¬&Xےےےے¶ہے%Nےےےے؛آے½تھےےئآےےےYےےےےخہےh¦ےےےےزہےےےےےعآےGˆ¬ےےےےàآے:Sےےےےêہے-àےےےےْہےNR6ےےےےہےd¨ےےےےہے‰دےےےے$آے3‚ےےےے(ہےعےےےے4آےZ®ےے”:آے÷ےےےےDآےضrےےےےNآےنKےےےےVآےrصêےے\ہے¢ےےfآے÷rےےےےvآےµcےےےےzآے½ےےےےˆ&@ےےےے”&Fئ؟ےےےے آے‌ےےےے¦آے¥*ےےےے¬آےâ¨ےےےے¸آےثےےےےؤ&4«ےےےےشہےص‹ےےےےعہےدےےےےوآےطےےےےًہےک1ےےےےہے
ےےےےآےMےےےےہے  pےےٹ$ہے،Xےےےے.ہےTعےےےے4&*¼ّےےےے@آےه]ےےےےLآےي«ےےےےTآے‘<ےےےےZ& tےےےےfآےZïےےےےrہےےےےے€àے9ظےےےےŒآےV ےےےےڑہےاîےےےے¤ہےےے®VBAExcelMUpldT.xls0stdoleےModule1_EvaluatecleanuplabelscounterNamesCountNameDeleteےModifyLabelsSheetInWhichToReplaceYearLabelToReplaceclabelbeginningےInsertPIaےےActiveSheetSelect
bےےbiggestRightRefersToےLabelOnLastRowےLocation StartOfCellFormulasRowFormula RowselectrangeRangeSelectionEntireRowInsertValuerangenameActiveWorkbookAddRefersToR1C1AdEquipmentAdIndirectےCopy(PasteApplicationCutCopyModeNewBudgetYearsےtestYearsToAdd)InputBoxNumberOfYearsToAdd YearCounterSheetsTotalYears LastYearAfterbuttonnameWorksheetsXButtonsTextےdeleteextradeletenamesdeletecounterMUPLDT1.XLS_B_var_RightےAuto_OpenDatabaseےے<+ےےےےےےےےےےےے ےےےے ےےےے
ےےےےےےےےےےےےےےےےےےےے
234719a30ےےےےےےےےےےےے	´_SummaryInformation(ےےےےےےےےcP$DocumentSummaryInformation8ےےےےےےےےےےےے(شCompObjےےےےےےےےےےےے,f¶ےےےےےےےے2.N£;ےےےےےے»NN0ك(ےے``‏ےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےے(ےے@‏ےEےےع#•4ك”(

 


ڈ
‹t@‏ےےےےےےےےےڈ
é,پےےJdےDNة‚ےے”ےےx

 


ڈ
‹جٹ‏ےhX
ےےےےےےڈ
, é”ےےJdے¬ےے

 


ڈ
‹ّ´$‏ےہےےےےLےےےے`ڈ


 


ڈ
‹$ھ6‏ےىےےےےّےےےے:ڈ


 


ڈ
‹P´H‏ےےےےےn
ےےےےMڈ


 


ڈ
‹|êZ‏ےDےےےے®ےےےےڈ


 


ڈ
‹¨Tl‏ےpےےےےکےےےےڈ


 


ڈ
‹ےے€~‏ےœےےےے¼ےےےےڈ
3ب پےےٹdےàپےےJےے|ےےؤ$ےے4ےےےےےےLےے$TTے$ےےےےےےےےےےdےےےےےےےے|ےےےےےے´ےے| Tےےےôlے ہHT4ے$طگ´œےےےےےےذ¨xôےے„ےےےےےےؤہ\ےےےہ\ے@èà<ےèê,ے ےےہ\ےTHھ¤‏ےےTے$ہxœ„ےےےےےے0گ`HےےlےےےےےےHà<ےxê,ے ےے”TےX-œ$Tے02$€8\DےےےےےےجP 0ےے,ےےےےےےl$
\‏ےےL‏0ط <‏ ےے*,‏ؤ4‏ط@‏@ےےà<ے$ê,ے$€ـ‎t t t tt  t @t tt  t @¨نےےDےڈ
ےےTے$ےے¬phےےےےذےےےےـےےےےےےےےےےH´
\‏ےےL‏0´ <‏ےے*,‏$4‏ ´@‏ےےT4ےنےے$ے@ےے€ـ‎t t  t D¨¬ےےےےےےےےےےےےےےےےےےےےےےےےےےےےےے„¬ےےےى‎ےےےےےDےے
\‏ےےL‏60t <‏Aےے*,‏ہ4‏ t@‏ےےج‏’¬ےےô‏Dےے€ـ‎Œ‏t ى‎t  t @t xےے¬‏‏ےےن‏@(ےےش‏ےےےے |‏ ےےTl‏$ےےےےےےےےےےےےےےےےےے<¨ےےےےےےےےےے(4,‏(@‏DJےےےے¨ےےےےےےےےےےےےےےےےےےMEےےےےےےےے‏تJ44TNˆ طXّP \|ˆک¨¼ےے"جذ6ـ<ً6ٹ®$4°بجشےےےے"ط,ـr|ˆ6ک<¬ؤ6ج$à"ü
*
.`8hlpxےےےے"|ےے&€&Œ"ک@¼ےےü6FٹF´`L¨
ؤجذشےے0ـےےً(ےےےےےے(8HXےے\,l.|ےےŒ,œF¬ےےبےے&Pط,@*J,DXےےx,ˆ8ک*J¬&PطDےے ,0@@*J\&PˆD°ےےذ,à8ً*J	&P0	DX	ےےx	,ˆ	2ک	&F¬	&Pش	Dü	ےے
,,
2<
&HP
&Px
D 
ےےہ
,ذ
2à
&Hô
(PDDےےd,t2„(Hک(PہDèےے"ےے&&"(@LےےŒ6”FŒ¨F´ًL8
T\`dےے0lےے€(گ¨ےےےےےے¸بطèےےى,ü.ےے>Pےے,\ Fl(HŒD´ےےش,ن2ô*L&P4D\ےے|,Œ8œ,L°(PـDےےےے$ےے"(ےے&,&8"D@hےے¨6°FŒؤF´LT
px|€ےے0ˆےےœ(¬ؤےےےےےےشنôےے,.(ےے&P8ےےےے,`.Rp*L Dجےےى,ü2*J &PLDtےے”,¤2´*Lب&PôDےے$<,T
"dp,€
"گ
&œےےےےےےےے¨,¸"Hب*Lى(PD@ےے`ےےےے"dےےhےے2xpےے¤´ےے6¼$\ذô48
DLPT
\
dےے6l$^„:¨,bؤ Jً*0<X`ےے"d<ph¤ےے"¨¬¸6ہXFشF,DTXےے `6tŒگےےےےےےےے”×Sub modyrprefix()× total = Names.Count×For counter = 1 To totalےے×. If Left(Names(counter).Name, 4) = "Year" Then×H  myvalue = InputBox("replace - " & Names(counter).Name, "hello", "yes")× If (myvalue = "yes") Then×R  Names(counter).Name = Left(Names(counter).Name, 5) & Mid(Names(counter).Name, 7)×End If×If (myvalue = "end") Then×  End× End If× End If× Next counter×End SubژYإ£èéL T£ `!jٹ T$`!t T+J T؟ T£ `!jٹ@‌)£ T$J­Year1£~££ T$J­Year10£~££ T$J­Year11£~£” T$J$`B@€gےے T؟@kےےژt×% read all names into array of strings×k then go thru each string in the array and change the name of the original keyed by the string in the arrayYإ£¸éô­Year1'  T£ `!jٹ  T$`!t T+J T؟  T£ `!jٹ£ T$J ”£~”£ T$J  £~”£ T$J  }£'ھ ” T$J ھ£ƒ T$J$`(tgےےgےے T؟kےےژج ت!ش'ہ ت!t'à×b = "Year1" 'debugging only×:Row = InputBox("Enter the Row# to insert above", "", "21")£'ê T£ `!jٹ‌ T$`!t à­PIFNAME| T$`!t à|” ê T$`!t£$ô	 T$`!£$ô­#REF!” T$`!t£$ô'ê T'
gےےgےے T؟ 
$`!'  ­$|'    £¢ƒ'*@ *£'4 ê£'ê@ ê£	”­0 ê'êgےے­C 4'@ @$JB@ش T!`B@j­A 4'@ @$JB@ش ê£$ô @$J(t­C 4'@­= à­!R 4­C3' @$JB@ش­	FirstName @$J(t à­! à­PIFNAME ê'€ €بt ب  ٹ!`B@”­D 4'@ @$JB@ش­X @$J(t à­! à­PIMNAME ê'€­= à­!R 4­C4' €بt ب  ٹ!`B@”G­E 4'@ @$JB@ش­LastName @$J(t@ à­! à­PILNAME ê'€­= à­!R 4­C5' €بt ب  ٹ!`B@”@­F 4'@ @$JB@ش­ @$J(t( à­! à­PITITLE ê'€'­= à­!R 4­C6'' €بt ب  ٹ!`B@””­H 4'@ @$JB@ش£ @$J(t( à­! à­CAL ê'€'­= à­!R 4­C8'' €بt ب  ٹ!`B@””­I 4'@ @$JB@ش£ @$J(t( à­! à­ACAD ê'€'­= à­!R 4­C9'' €بt ب  ٹ!`B@””­J 4'@ @$JB@ش£ @$J(t( à­! à­SUMR ê'€'­= à­!R 4­C10' €بt ب  ٹ!`B@””­L 4'@ @$JB@ش£ @$J(t( à­! à­PIDOL ê'€­= à­!R 4­C12' €بt ب  ٹ!`B@””kژّ ت!ش'ہ ت!t'à×b = "Year1" 'debugging onlynl×:Row = InputBox("Enter the Row# to insert above", "", "21")£'ê T£ `!jٹj‌ T$`!t à­equipdol| T$`!t à|” ê T$`!t£$ô	 T$`!£$ô­#REF!” T$`!t£$ô'ê T'
g
gےے T؟T 
$`!'' ­$|'    £¢ƒ'*' *£'4' ê£'ê' ê£	”­0 ê'êgê­C 4'@ @$JB@ش T!`B@jj­= à­!R 4­C3'×what is this for?or @$JB@ش­Equipment Item @$J(t à­! à­equip ê'€ €بt ب  ٹ!`B@””­F 4'@ @$JB@ش£ @$J(t( à­! à­equipdol ê'€'­= à­!R 4­C6'' €بt ب  ٹ!`B@””­P 4'@ @$JB@ش­ @$J(to  à­! à­	equipcmnt ê'€­= à­!R 4­C16' €بt ب  ٹ!`B@”k ژ$ ت!ش'ہ ت!t'à×b = "Year1" 'debugging onlyr1×:Row = InputBox("Enter the Row# to insert above", "", "21")£'ê T£ `!jٹê‌ T$`!t à­idirname| T$`!t à|” ê T$`!t£$ô	 T$`!£$ô­#REF!”ô T$`!t£$ô'ê T'
g$g T؟T 
$`!'  ­$|'    £¢ƒ'* *£'4' ê£'ê' ê£	”­0 ê'êg”­C 4'@ @$JB@ش T!`B@jB@­= à­!R 4­C3' @$JB@ش­New Indirect Item goes here @$J(t h à­! à­idirname ê'€id €بt ب  ٹ!`B@”­F 4'@ @$JB@ش£ @$J(t à­! à­idirdol ê'€id­= à­!R 4­C6' €بt ب  ٹ!`B@”­H 4'@ @$JB@ش£ @$J(t à­! à­idirrate ê'€id­= à­!R 4­C8' €بt ب  ٹ!`B@”­I 4£'@ @$JB@ش TB@ہJ­I 4'@ @$JB@ش تB@تJ® ش(àت­P 4'@ @$JB@ش­Comments go here @$J(to  à­! à­idircmnt ê'€id­= à­!R 4­C16' €بt ب  ٹ!`B@”k ژP£'ô­Enter number of years to add­£$
'dd £ ٹ'£'  T£ *!jٹ  T$*!t££ƒ­Year”  £' ar×.If Mid(Sheets(counter).Name, 5, 2) > test Then   ô
”  'ôg gô T؟   '4 ô'@­Year1$*B@ش 4$*بJ­Year1$*B@ہ­	Year1 (2)$*B@شar­Year @£­	Year1 (2)$*(t @£­year1by$J(t×#need to change labels at this pointab­Year @£A@ٹ ؟kژ|­Create New Budget Year(s)£­Year1$`%j(tk1ژ¨Yإ£2éè£'” T£ `!jٹ”‌‎ے T$`!t­05|”×0And      'InStr(Names(counter).Name, "PI")) Then T$`!t ”+ٹ ”£'”+g T؟ T£ ”£ٹ T$ٹ$`B@€T¾ٹk$And      'InStr(Names(counter).Name, "PI")) Then T$`!t ”+ٹ ”£'”gےے T؟ T£ ”£ٹ T$ٹ$`B@€@¾ےےkےےےےےےNˆےے`ڈ


 


ڈ
‹$ھ6‏ےىےےےےےے:ڈ


 


ڈ
‹P´H‏ےےےےےn
TےےMڈ


 


ڈ
‹|êZ‏ےDےےےے®<ےےڈ


 


ڈ
‹¨Tl‏ےpےےےےکنےےڈ


 


ڈ
‹ےے€~‏ےœےےےے¼èےےڈ
3ب پےےٹdےàےےےےےےےےےے|ّtج$P¨@ےےےےےےےےےےےےےےےےےےےےےے4ےےےےےےLےےےےTTےèےےےےےےےےےےdےےےےےےےے|ےےےےےے´ےےےے Tےےےôlے ےےT4ےےےطگ´œےےےےےےذ¨xôےے„ےےےےےےےےہ\ےےےہ\ے@ےےà<ے¬ê,ے ےےہ\ےXھ¤‏ےےTےےےہxœ„ےےےےےے0گ`Hےےlےےےےےےےےà<ے¸ê,ے ےے”TےX-ےےTے02ےے€8\DےےےےےےجP 0ےے,ےےےےےےےے
\‏ےےL‏ےے <‏ ےے*,‏ؤ4‏ےے@‏@ےےà<ےـê,ےےے€ـ‎t t t tt  t @t tt  t @´ےےDےڈ
ےےTےےے¬phےےےےذےےےےـےےےےےےےےےےےے
\‏ےےL‏ےے <‏ےے*,‏$4‏
 ےے@‏ےےT4ےےے$ے@ےے€ـ‎t t 
 t Dےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےےtےےےى‎ےےےےےDےے
\‏ےےL‏6ےے <‏Aےے*,‏ہ4‏ ےے@‏ےےج‏’¸ےےô‏Dےے€ـ‎Œ‏t ى‎t  t @t ےے¬‏‏ےےےےن‏E(ےےش‏ےے |‏ ےےTl‏èےےےےےےےےےےےےےےےےےے<¨ےےےےےےےےےےےے4,‏ےےےے@‏@Jےےےے¨ےےےےےےےےےےےےےےےےôMEےےpےےگےے€¶tDےے àvD$ٍّD06²	E 0HـEE0ےےZ IE@ےےl¦‎APD~€E`‏تUےےےےےےےےےےےےےےےےےےےےےے44TNˆ طXّP \|ˆک¨¼ےے"جذ6ـ<ً6ٹ®$4°بجشےےےے"ط,ـr|ˆ6ک<¬ؤ6ج$à"ü
*
.`8hlpxےےےے"|ےے&€&Œ"ک@¼ےےü6FٹF´`L¨
ؤجذشےے0ـےےً(ےےےےےے(8HXےے\,l.|ےےŒ,œF¬ےےبےے&Pط,@*J,DXےےx,ˆ8ک*J¬&PطDےے ,0@@*J\&PˆD°ےےذ,à:ً*J	&P4	D\	ےے|	,Œ	2œ	&F°	&Pط	D
ےے 
,0
2@
&HT
&P|
D¤
ےےؤ
,ش
2ن
&Hّ
(P DHےےh,x2ˆ(Hœ(PؤDىےے"ےے&& ",@Pےےگ6کFŒ¬F´ôL<
X`dhےے0pےے„(”¬ےےےےےے¼جـىےےً,.ےے>P ےے,` Fp(HگD¸ےےط,è2ّ*L&P8D`ےے€,گ"H ,Lؤ(PًDےےےے8ےے"<ےے&@&L"X@|ےے¼6ؤFŒطF´ Lh
„Œگ”ےے0œےے°(ہطےےےےےےèّےے,,.<ےے&PLےےےے,t.R„*L´Dàےے,2 *J4&P`Dˆےے¨,¸2ب*Lـ&PD0ےے$P,h
"x„,”
"¤
&°ےےےےےےےے¼,ج"Hـ*L(P,DTےےtےےےے"xےے|ےے2x„ےے¸بےے6ذ$\ن4L
X`dh
p
xےے6€$^ک:¼,bط J*$0Pltےے"x<p|¸ےے"¼ہج6شXFèF@Xhlےے t6ˆ ¤ےےےےےےےے¨×Sub modyrprefix()× total = Names.Count×For counter = 1 To totalےے×. If Left(Names(counter).Name, 4) = "Year" Then×H  myvalue = InputBox("replace - " & Names(counter).Name, "hello", "yes")× If (myvalue = "yes") Then×R  Names(counter).Name = Left(Names(counter).Name, 5) & Mid(Names(counter).Name, 7)×End If×If (myvalue = "end") Then×  End× End If× End If× Next counter×End SubژYإ£èéL T£ `!jٹ T$`!t T+J T؟ T£ `!jٹ@‌)£ T$J­Year1£~££ T$J­Year10£~££ T$J­Year11£~£” T$J$`B@€gےے T؟@kےےژt×% read all names into array of strings×k then go thru each string in the array and change the name of the original keyed by the string in the arrayYإ£èé´­Year1'  T£ `!jٹ  T$`!t T+J T؟  T£ `!jٹ£ T$J ”£~”£ T$J  £~”£ T$J  }£'ھ ” T$J ھ£ƒ T$J$`(tgےےgےے T؟kےےژج ت!ش'ہ ت!t'à×b = "Year1" 'debugging only×:Row = InputBox("Enter the Row# to insert above", "", "21")£'ê T£ `!jٹ‌ T$`!t à­PIFNAME| T$`!t à|” ê T$`!t£$ô	 T$`!£$ô­#REF!” T$`!t£$ô'ê T'
gےےgےے T؟ 
$`!'  ­$|'    £¢ƒ'*@ *£'4 ê£'ê@ ê£	”­0 ê'êgےے­C 4'@ @$JB@ش T!`B@j­A 4'@ @$JB@ش ê£$ô @$J(t­C 4'@­= à­!R 4­C3' @$JB@ش­	FirstName @$J(t à­! à­PIFNAME ê'€ €بt ب  ٹ!`B@”­D 4'@ @$JB@ش­X @$J(t à­! à­PIMNAME ê'€­= à­!R 4­C4' €بt ب  ٹ!`B@”G­E 4'@ @$JB@ش­LastName @$J(t@ à­! à­PILNAME ê'€­= à­!R 4­C5' €بt ب  ٹ!`B@”@­F 4'@ @$JB@ش­Dr. @$J(t à­! à­PITITLE ê'€­= à­!R 4­C6' €بt ب  ٹ!`B@”­H 4'@ @$JB@ش£ @$J(t à­! à­CAL ê'€­= à­!R 4­C8' €بt ب  ٹ!`B@”­I 4'@ @$JB@ش£ @$J(t@ à­! à­ACAD ê'€­= à­!R 4­C9' €بt ب  ٹ!`B@”@­J 4'@ @$JB@ش£ @$J(t à­! à­SUMR ê'€­= à­!R 4­C10' €بt ب  ٹ!`B@”­L 4'@ @$JB@ش£ @$J(t à­! à­PIDOL ê'€­= à­!R 4­C12' €بt ب  ٹ!`B@”kےےژّ ت!ش'ہ ت!t'à×b = "Year1" 'debugging only×:Row = InputBox("Enter the Row# to insert above", "", "21")£'ê T£ `!jٹH‌ T$`!t à­equipdol| T$`!t à|” ê T$`!t£$ô	 T$`!£$ô­#REF!” T$`!t£$ô'ê T'
gےےgےے T؟ 
$`!' ­$|'    £¢ƒ'* *£'4H ê£'ê ê£	”­0 ê'êgےے­C 4'@ @$JB@ش T!`B@j­= à­!R 4­C3'×what is this for? @$JB@ش­Equipment Item @$J(t à­! à­equip ê'€ €بt ب  ٹ!`B@”­F 4'@ @$JB@ش£ @$J(t à­! à­equipdol ê'€­= à­!R 4­C6' €بt ب  ٹ!`B@”­O 4'@ @$JB@ش­Comments go here @$J(t à­! à­	equipcmnt ê'€­= à­!R 4­C15' €بt ب  ٹ!`B@”kےےژ$ ت!ش'ہ ت!t'à×b = "Year1" 'debugging only×:Row = InputBox("Enter the Row# to insert above", "", "21")£'ê T£ `!jٹ‌ T$`!t à­idirname| T$`!t à|” ê T$`!t£$ô	 T$`!£$ô­#REF!” T$`!t£$ô'ê T'
gےےgےے T؟  
$`!' ­$|'    £¢ƒ'* *£'4 ê£'ê ê£	”­0 ê'êgےے­C 4'@ @$JB@ش T!`B@j­= à­!R 4­C3' @$JB@ش­New Indirect Item goes here @$J(t à­! à­idirname ê'€ €بt ب  ٹ!`B@” ­F 4'@ @$JB@ش£ @$J(t à­! à­idirdol ê'€­= à­!R 4­C6' €بt ب  ٹ!`B@”­H 4'@ @$JB@ش£ @$J(tG à­! à­idirrate ê'€­= à­!R 4­C8' €بt ب  ٹ!`B@”G­I 4£'@ @$JB@ش TB@ہ­I 4'@ @$JB@ش تB@تG® ش(à­O 4'@ @$JB@ش­Comments go here @$J(t à­! à­idircmnt ê'€­= à­!R 4­C15' €بt ب  ٹ!`B@”kےےژP£'ô­Enter number of years to add­£$
' £ ٹ£'  T£ *!jٹ T$*!t££ƒ­Year”  £'  ×.If Mid(Sheets(counter).Name, 5, 2) > test Then   ô
”  'ôgےےgےے T؟@  '4 ô'@­Year1$*B@ش 4$*بJ­Year1$*B@ہ­	Year1 (2)$*B@شG­Year @£­	Year1 (2)$*(t @£­year1by$J(t×#need to change labels at this point­Year @£A@ٹ ؟kےےژ|­Create New Budget Year(s)£­Year1$`%j(tkےےژ¨Yإ£2éè£'” T£ `!jٹ@‌‎ے T$`!t­05|”×0And      'InStr(Names(counter).Name, "PI")) Then T$`!t ”+ٹ ”£'”gےے T؟ T£ ”£ٹ T$ٹ$`B@€@¾ےےkےےع1بےگGeneva1بے¼Geneva1بےگGeneva1بے¼Geneva1بےگGeneva1´ےگHelv1بے¼Helv1´ے¼Helv1 ے¼Helv1 ے¼Helv1 ےگHelv1بےگHelv1´ےگHelv1´	گHelv1بےگArial1´ےگTms Rmn1´ےگscdol1´ےگArial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)¤0.¥\(0\)#¦ "$"#,##0.0_);[Red]\("$"#,##0.0\)§0.0;¨8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)7©4_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)ھ"$"#,##0«
"$"#,##0.0¬#,##0.0_);[Red]\(#,##0.0\)­"$"#,##0.00àُے ہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ àُے ôہ à ہ à(ُے ّہ à&ُے ّہ à)ُے ّہ à+ُے ّہ àُے ّہ àُے ّہ à*ُے ّہ à,ُے ّہ àُے ہ à	ُے ّہ à ˆہ à&¸ہ €€€@à&¸ہ €€€à&¸ہ €€‚€ à ¨ہ €@à ¨ہ €à&¸ہ €@à&°ہ €à&¸ہ B€ à&¸ہ @€€à&¸ہ @€‚€ à¸ہ @€@à¸ہ @€à¸ہ @€€ à&¸ہ @€à&¸ہ @€@ à&°ہ @€@ à¸ہ @€€ àکہ à ¨ہ @à&¸ہ @à&¸ہ à	=تلءآےےےے	Worksheetآےےےے&Tools&WindowآےےےےChartآےےےے&Tools&WindowآےےےےVisual Basic Moduleآےےےے&Tools&Window؟¤ہâ\6Edward Lipson                                        Bن=êےےس_VBA_PROJECTœYear1ŒAdEquipmentŒ
AdIndirectŒInsertPIŒNewBudgetYears+Year1ACAD01:ےےثSˆ€'Year1by:ےے/Tˆ€*
Year1CAL01:ےے“Tˆ€*
Year1cncmt:ےے÷Tˆ€0*
Year1cndol:ےے[Uˆ€0*
Year1cpcmt:ےے؟Uˆ€1*
Year1cpdol:ےے#Vˆ€1*
Year1csdol:ےے‡Vˆ€?*
Year1dccmt:ےےëVˆ€5*
Year1docmt:ےےWˆ€%*
Year1dodol:ےےƒWˆ€%,Year1equip01:ےےëWˆ€!0Year1equipcmnt01:ےے'Xˆ€!/Year1equipdol01:ےے“Xˆ€!*
Year1fbcmt:ےے÷Xˆ€*
Year1fbdol:ےے[Yˆ€*
Year1focmt:ےےڈYˆ€&*
Year1fodol:ےےأYˆ€&*
Year1gscmt:ےے÷Yˆ€*
Year1gscnt:ےے[Zˆ€*
Year1gsdol:ےےڈZˆ€/Year1idircmnt01:ےےثZˆ€8.Year1idirdol01:ےے3[ˆ€8/Year1idirname01:ےےں[ˆ€8/Year1idirrate01:ےےغ[ˆ€8*
Year1macmt:ےے\ˆ€.*
Year1madol:ےےC\ˆ€.*
Year1odcmt:ےےw\ˆ€3*
Year1oddol:ےےغ\ˆ€3+Year1odtcmt:ےےC]ˆ€4*
Year1opaca:ےے§]ˆ€*
Year1opcal:ےےغ]ˆ€*
Year1opcmt:ےے^ˆ€*
Year1opcnt:ےےs^ˆ€*
Year1opdol:ےے§^ˆ€*
Year1opsum:ےےغ^ˆ€	+Year1orgdte:ےےC_ˆ€C+Year1orgnme:ےے«_ˆ€C*
Year1otcmt:ےےك_ˆ€*
Year1otcnt:ےےC`ˆ€*
Year1otdol:ےے§`ˆ€+Year1othcmt:ےےك`ˆ€++Year1othdol:ےےGaˆ€+*
Year1pdaca:ےے«aˆ€*
Year1pdcal:ےےbˆ€*
Year1pdcmt:ےےCbˆ€*
Year1pdcnt:ےے§bˆ€*
Year1pddol:ےےغbˆ€*
Year1pdsum:ےےcˆ€	,Year1PIDOL01:ےےGcˆ€.Year1PIFNAME01:ےےcˆ€.Year1PILNAME01:ےےçcˆ€.Year1PIMNAME01:ےےdˆ€.Year1PITITLE01:ےےWdˆ€*
Year1pucmt:ےے‹dˆ€/*
Year1pudol:ےے؟dˆ€/*
Year1rsdol:ےےَdˆ€=*
Year1sccmt:ےے'eˆ€*
Year1sccnt:ےے‹eˆ€*
Year1scdol:ےے؟eˆ€+Year1sigdte:ےے'fˆ€A+Year1signme:ےے_fˆ€A*
Year1stcmt:ےےëfˆ€(*
Year1stdol:ےےgˆ€(+Year1subcmt:ےےWgˆ€2+Year1subdol:ےے؟gˆ€2*
Year1sucmt:ےےَgˆ€**
Year1sudol:ےےWhˆ€*+Year1SUMR01:ےےڈhˆ€	*
Year1tpcnt:ےےأhˆ€,*
Year1trcmt:ےے÷hˆ€)*
Year1trdol:ےے+iˆ€)*
Year1tscmt:ےے_iˆ€+Year1tsfcmt:ےے—iˆ€*
Year1ugcmt:ےےثiˆ€*
Year1ugcnt:ےے/jˆ€*
Year1ugdol:ےے€=ٌےٌے­%U8‎@چ"!¸ہ @ à&¸ہ @ à ¨ہ € à ¨ہ @€@à ¨ہ @€à ¨ہ @€à  ہ €€@à ¨ہ €€à ¨ہ €€@ à&¸ہ €€à&¸ہ €€@ à ¨ہ €€€ à ¨ہ à ¨ہ à ¨ہ @ à&¸ہ à&°ہ @ à&کہ à&¸ہ € à&¸ہ @€à#¸ہ @€à"¸ہ @€à ¨ہ @€@ à"¸ہ @€@ à&¸ہ @€€ à¤!¼ہ @€@à!¸ہ @€à!¸ہ @€@ à èہ Q€à èہ Q€€ à èہ à èہ € à#¸ہ à¤#¼ہ @€@à&¼ہ @€à&¼ہ @€@ à&کہ à&¸ہ @€à ¨ہ €€@à	 ˆہ à
 ˆہ à"¸ہ @€€ à"¸ہ @€€à"¸ہ @€پ€ à ىہ Q€à#¸ہ @€à ىہ à&¼ہ @€€à	 Œہ à"کہ à#کہ à"ہ à ¨ہ @€à#کہ à Œہ à#کہ à!کہ à&¼ہ €€à&¸ہ €€€ à&¼ہ €€à"¼ہ €€à"¼ہ €€€ à èہ @€پ€ à!¸ہ @€@ à ¼ہ @€à ¨ہ @€à ¨ہ @€@ à!œہ à@&œہ à"کہ àکہ à@"œہ à"¼ہ @€@ à­"¼ہ @€€ à!کہ à	گ!کہ à èہ @€à ¨ہ à  ہ à!ّ A€à"ü A€@ à&ü A€@ à"ü A€I€@ à"ü A€A€ à&ü A€@ à!ط à!P à ب à&ü A€@ à#ّ A€à èہ à	 ج à"\ à"ü پ€à"ü A€@ à&ü
 A€@ à&ü
 A€A€ à&ü
 A€à&ü
 A€€à	"üہ @€à#ّ
 A€à¤ ¤ہ @€@à&ّ
 A€€à ب
 à èہ €€à ىہ @€ˆ@ à ىہ €€€ à@ ى A€àھ ج à&¸ہ à¸ہ à­"¼ہ à"¸ہ à"¼ہ à­&¼ہ à#ّہ à!¸ہ @ “€ے“€ے“Comma [0]_Budget“Comma_Budget“€ے“€ے“Currency [0]_Budget“Currency_Budget“€ے“Normal_Budget“€ے’â8ےےےےےےےےےےےے€€€€€€€€€ہہہ€€€€€ے€ `ےےہ àà`€ے€€€ہہہے€ےےےےےے€€€€€ےجےiےےجےجےے™¦تًجœجج™ےممم3fے3جج3™3™™3™f3™ffff™–––33ج3ff333f3™3f33™BBB…ج"Year1…=RModule1
	=تFô$غ9âK–Odü©ٌزMbP?_*+‚€%زŒپء87&L&"Palatino,Italic"NSF 96-115&R&"Palatino,Italic"Smith&C&"Palatino,Regular"F-&Pƒ„&333333س?'333333س?(à?)à?MضHP LaserJet IIIlar"F-&P6-115&R&”@gxH@‚ک$ل°jT0°bT0k0ب’•‚@MSUDNHP LaserJet III d
،"W‚xH333333س?à?U}¶‚}$‚}$‚}¶‚}m‚}I‚}غ‚}	‚}

غ‚}$	‚}’‚}¶	‚}m‚}¶
u‚}¶
‚
Fزbز÷ڈزbزb÷ڈز÷؟ ‚ز ‚ز ‚لb÷¯÷؟ ¢	û؟÷¯
ے÷؟÷؟€, ے@÷ڈbل)ےbےے@زPےP@bے@ےb@ے@D@ےb@bے@bے¾@ے@ے@†ے@ے@ے@ے@ے@†[SInstructions to NSF Submitters:  The functions below work on this spreadsheet only.	Notes:‘
‰If you delete a row created with the buttons, prior to using the buttons again you must remove the labels that were created with the row.E=These functions may not work properly if you add any columns.`
XDo not enter anything in the red cells unless you intend to override the formula values.LDThese functions will add the necessary labels required for each row.[
SYou should be entering the values you want Fastlane to receive in the yellow cells.Q
IFastLane will ignore all data in cells that are not either yellow or red.آ
؛If you want to create additional years based on the data in a first year, then do not press the "create new budget years" button until you have filled out the data that you want to copy.f
^The "create new budget years" button will copy all data from budget year1 to subsequent years.[
SComments fields are limited to 255 characters - please do not enter more than that./
'PLEASE DO NOT ENTER CENTS IN ANY FIELD!hYEAR~
–ً?	FOR NSF USE ONLY¾		*‌
ORGANIZATION¾

 PROPOSAL NO.¾

	!"

#DURATION (MONTHS)¾
1$/%#&Your Organization goes here¾&&&&&'(()
(Proposed:+Granted¾‍vv/-'PRINCIPAL INVESTIGATOR/PROJECT DIRECTOR.	AWARD NO.¾	/0/AFunds¾
2<¾345555556789AGranted by NSF¾
;<¾$-}<<<<<<~<</A2<¾$-}<<<<<<~<</A2<Q-IA. SENIOR PERSONNEL: PI/PD, Co-PI´S, Faculty and Other Senior Associates ¾<<<=<>?
NSF Funded¾/@A
¤Funds¾CB/-G=?(List each separately with title, A.7. show number in brackets)¾<<<<>CPerson-months¾
()	
ARequested By¾1pB/~
•DE
First Name	5M5	Last Name5TitleFGCALGACAD	)SUMR
CProposer¾)EH/Iً?ےDہ4FirstNamePI	X
LastNamePITitleo½€€€	
R~
پ¾Eyںw¾$IJJJJJKxxxRSEyں	Q(!”ً?ے%ہہB&5) TOTAL SENIOR PERSONNEL (1-6)¾555Fxxx
!ڈے%ہہpL¾
Ey¢COMMENTS¾
TR53-B. OTHER PERSONNEL (SHOW NUMBERS IN BRACKETS)¾"55555FLLL\\EMٹI 1. (~
‰"5) POST DOCTORAL ASSOCIATES¾555F½€€€	
R~
پ¾
EYP	Post Doc:…I 2. (~
‰<54) OTHER PROFESSIONALS (TECHNICIAN, PROGRAMMER, ETC.)¾5555½‚ƒƒ	
R~
پ¾
EYPOther Professionals:¾
…I 3. (~
‰J) GRADUATE STUDENTS¾55d5qqrR
~
پ¾
EYPGrad Students:¾
…wI 4. (~
‰ J) UNDERGRADUATE STUDENTS¾55d5qqrR
~
پ¾
EYP
Undergrad:…I 5. (~
‰6J.) SECRETARIAL - CLERICAL (IF CHARGED DIRECTLY)¾555555FR
~
„¾
EYPSecretarial:…I 6. (~
‰J) OTHER¾555555FR
~
پ¾
EYPOther Persons:…I&JTOTAL SALARIES AND WAGES (A+B)¾J555555FR
.ڈے%ہہشU@Dہ@¾
EYPTotal Salaries:¾
…R73/C. FRINGE BENEFITS (IF CHARGED AS DIRECT COSTS)¾55555]“5FR
~
پ¾
NYPFringe Benefits:¾
…R39J1TOTAL SALARIES, WAGES AND FRINGE BENEFITS (A+B+C)¾5555555FR
!ڈ4ے%ہہشU¾
NY PTotal Salary and Fringe:¾
…R×Dمl­¯Uئj_32ƒژwJ((²؛ہد(ث_¸لœ™±Œ¹ں ےb@!ے@÷ڈ"ےb@#ےb@÷ڈ$ے÷؟@ ‚%ے@ ‚&ے@ ‚'ےb@÷ڈ(ے÷؟@ ‚)ےû؟@÷ڈ*ے÷؟@+ے÷؟@,,ے@÷ڈ-ےb@ل	.ے@b/ے@0ے@@1ےP@2ےP@b3ے@4ےb@5ے@D@6ےb@b7ے@b8ے¾@9ے@:ے@†;ے@<ے@ =ے@ >ے@ ?ے@† [ -SD. PERMANENT EQUIPMENT (LIST ITEM AND DOLLAR AMOUNT FOR EACH ITEM EXCEEDING $5,000)¾ 	>NNNO£z¾
!-s!†equipment item 1~
!œ¾!tT>NNNO!£Equipment comments:!…¾
"-f¾"	>NN|Oٹz#-¾#	>NNEOٹz$3$JTOTAL EQUIPMENT¾$5555555F_
!$گ,ے%!ہ$ہ|g¾$Enٹz%3	E. TRAVEL¾
%55?%571. DOMESTIC (INCL. CANADA, MEXICO AND U.S. POSSESSIONS)¾%55555FR
~
%ˆ¾
%NY%PDomestic Travel:%…¾&355&5
2. FOREIGN¾&55555FR
~
&پ¾
&NY&PForeign Travel:&…$'-F. PARTICIPANT SUPPORT COSTS¾$'<<<<<<<<>NNNO£z(-(<1. STIPENDS   ¾(<P~
(›¾(<<<>NNNO(£	Stipends:(…)-)<	2. TRAVEL¾)<<~
)›¾)ٹ<<>NNNO)£Travel:)…*-*<3. SUBSISTENCE¾*<<~
*›¾*<<<>NNLO*£Subsistence:*…+-+<4. OTHER¾+<<~
+›¾+<<<>NNEO+£Other:+…	,Q(~
,‰&,J) TOTAL NUMBER OF PARTICIPANTS¾,55|555FR
!,ڈ5ے%(ہ+ہشU¾,EY£z-3G. OTHER DIRECT COSTS¾$-55555555FLLEM£z.3!.51. MATERIALS AND SUPPLIES¾.5555555FR
~
.پ¾
.EY.P
Materials:.…/38/502. PUBLICATION COSTS/DOCUMENTATION/DISSEMINATION¾/5555555FR
~
/پ¾
/EY/PPublications:/…03053. CONSULTANT SERVICES¾05555555FR
~
0پ¾
0EY0PConsultant:0…13154. COMPUTERS SERVICES¾15555555FR
~
1پ¾
1EY1P	Computer:1…23255. SUBAWARDS¾25555555FR
~
2پ¾
2EY2P
Subawards:2…33356. OTHER¾3555d555FR
~
3پ¾
3EY3POther:3…¾
435 45TOTAL OTHER DIRECT COSTS¾4555555FR
!4ڈ$ے%.ہ3ہ¾
4NY4POther Total:4…+53#H. TOTAL DIRECT COSTS (A THROUGH G)¾555555555FR
05‘<ےD@%$@&@D,@D4@¾
5NY5PDirect Total:¾
5…R26-* I. INDIRECT COSTS (SPECIFY RATE AND BASE)¾$6<<<<<<<<>^^ZO£z¾
7-<"7<Name of indirect cost item¾
7<<7<Amount7<7<Rate¾7<>^^EO£z8-8‡FirstIndirectCostItem8a~
8Œ8b~
8‹ 8—ے
D8€D8€¾8	>^^EO8£Indirect Cost Items:8…9-¾9acb`¾9	>^^EOٹz:-¾:acb`¾:	>^^EOٹz;3TOTAL INDIRECT COSTS¾;55555555F_
";’8‏%8ہ:ہ‘¾;E[ {__0<3(J. TOTAL DIRECT AND INDIRECT COSTS (H+I)¾<55555555FR
<‘>ے	D5@D;@¾<lY zRX=3PK. RESIDUAL FUNDS (IF FOR FURTHER SUPPORT OF CURRENT PROJECTS SEE GPG II.D.7.j.)¾=55555555FR
~
=ژ¾=9Y z4>V,L. AMOUNT OF THIS REQUEST (J) OR (J MINUS K)¾>777777778i
>l77‎	D<@D=@¾>(m،z,?V$M. COST SHARING: PROPOSED LEVEL     ¾?7777k#?7AGREED LEVEL IF DIFFERENT $¾?779i
~
?چ¾?(j/z×D؟lwy&"xہP{t~r–I‡،…‚zr،¶^ˆ½44z‰ڑ‹@ےb@Aے@÷¯Bےb@Cےb@÷¯Dے÷؟@ ‚Eز ‚%@-PI/PD TYPED NAME & SIGNATURE*@J@2DATE@UFOR NSF USE ONLY¾@((((@TInitials-ORG¾@H/z¾
A35A|
PIFullName¾A558~
A™`ٌà@'A(INDIRECT COST RATE VERIFICATION¾A((((7H/z*B-"INST. REP. TYPED NAME & SIGNATURE*BWB2DATEBTDate CheckedB1B	TDate Rate of Sheet¾
B
T1¾BB/z¾
CV7CکInstRepFullName¾C77g~
Cڑ`ٌà@¾C78778¾C;<zضADW6NSF Form 1030 (10/97) Supersedes All Previous Editions
¾DWWWXDFDe>   *SIGNATURES REQUIRED ONLY FOR REVISED BUDGET (GPG III.B)   ¾
DezEz×ld™‡¦k¹]گI_d CCے(¾ـ¾$کOˆ9ےےہànˆeCreate New Budget Year(s)y‍s]Year]ˆ[r’ CCے(¾¾$œrˆ9ےے?ہànˆeCreate New PI Row pb]ژر[غ’ CCے(¾`ا†$نrˆ9ےے_ہànˆeCreate New Equipment Row¢b]’ر[غd CCے(†گا†$,sˆ9ےےànˆeCreate New Indirect Cost Row­b>
¶0!!!«" 
	=ت&APage &Pƒ„MضHP LaserJet III333f3™3f”@g,,=
àئb<`يڑàئb×±0@MSUDNHP LaserJet III d
،"d,,à?à?>
d
‏ےà…ںٍùOh«‘+'³ظ0 $HPd|گ¨´¼نNSF BudgetRich Schneider	rschneidMicrosoft Excel@©ْy3ً¼GZ#ےےےےصل	،	ےےےت4÷€€€€€€€€€ہہہہـہ¦تً""")))UUUMMMBBB999ے|€ےPPض“جىےïضئççض­©گ3f™ج333f3™3ج3ے3f3fff™fجfےf™3™f™™™ج™ے™ج3جfج™جججےجfے™ےجے333f3™3ج3ے333333f33™33ج33ے33f33f3ff3™f3جf3ےf3™33™3f™3™™3ج™3ے™3ج33ج3fج3™ج3جج3ےج33ے3fے3™ے3جے3ےے3f3fff™fجfےf3f33ff3f™3fج3fے3fff3fffff™ffجff™f3™ff™f™™fج™fے™fجf3جf™جfججfےجfےf3ےf™ےfجےfےججے™™™3™™™ج™™33™f™ج3™ے™f™3f™f3™™f™جf™ے3™3™™f™™™™™ج™™ے™™ج™3ج™fجf™ج™جج™ےج™ے™3ے™fج™™ے™جے™ےے™ج3™fج™ججج3™33جf3ج™3جج3جے3جfج3fجff™™fججfجےf™™ج3™جf™ج™™جج™جے™ججج3ججfجج™جججججےججےج3ےجfے™™ےججےجےےج3جfے™ے3ج33ےf3ے™3ےج3ےے3ےfے3fےffج™fےجfےےfج™ے3™ےf™ے™™ےج™ےے™ےجے3جےfجے™جےججےےجے3ےےfےج™ےےجےےےfffےfےےfffےےfےfےے¥!___www†††–––ثثث²²²×××فففمممêêêٌٌٌّّّےûً  ¤€€€ےےےےےےےےےےےے45'ےےےےے	'ےےےےے	ت4ü-	ْ"-ت	ْ"-	!ًت--	!ً----	!ً--;;-	!ً;-II-	!ًI-WW-	!ًW-ee-	!ًe-ss-	!ًs-‚‚-	!ً‚-””-	!ً”-¦¦-	!ً¦-··-	!ً·-ةة-	!ًة-4-	!ً4----	!ً--CC-	!ًC-´´-	!ً´-اا-	!ًا-33-	!ً3üےےے-'ےے-	ت4üہہہ-	ہہہہہہً	ْہہہ"-4-	!ً---4-	!ً--;;4-	!ً;-II4-	!ًI-WW4-	!ًW-ee4-	!ًe-ss4-	!ًs-‚‚4-	!ً‚-””4-	!ً”-¦¦4-	!ً¦-··4-	!ً·-ةة4-	!ًة--ت--	!ً¸--CتC-	!ً¸C-´ت´-	!ً¸´-اتا-	!ً¸ا-3ت3-	!ً¸3-	ےےے	!ً6¥	!ًE¥ً	ْ"-ةة`-	!ًEة-'ےے-ےےے	ت4ûَے¼"Geneva-ہہہ2
 ü€€€-	€€€ےےےً	ْ€€€"--	!ً--	!ً--	!ً--	!ً--	ہہہ2

12

!-22
,
/;32
:
=I42
H
KW52
V
Ye62
d
gs72
r
u‚82
ƒ
„”92
•–¦102
§¨·112
¹¹ة122
 -A	2
4/CB	2
xE´C	2
؛¶اD	2
ْة3Eû¼"Systemn-'ےے-ہہہ	ت4ûَےگ"Geneva-	ûôےگ"Helv-
-	ےےےےےے	!ً,	!ً.	!ًB	!ًD	!ً³	!ًµ	!ًئ	!ًب	„2
SInstructions to NSF Submitters:  The functions below work on this spreadsheet only.	ےےے	!ً ,	!ً .	!ً B	!ً D	!ً ³	!ً µ	!ً ئ	!ً ب	c2
 =These functions may not work properly if you add any columns.	ےےے	!ً.,	!ً..	!ً.B	!ً.D	!ً.³	!ً.µ	!ً.ئ	!ً.ب	m2
.DThese functions will add the necessary labels required for each row.ûôے¼"Helv-2
—rFOR NSF USE ONLY						-
	ےےے	!ً§,	!ً§.	!ً§B	!ً§D	2
©ORGANIZATIONûَے¼"Helv-	ےےے	!ً¸B	!ً¸D	!ً¸³	!ً¸µ	!ً¸ئ	!ً¸ب	02
¸0Your Organization goes here
										-
-ت4	ْ"--	ےےے	!ً¨iE	!ً!iE-		!ً!iى	!ً¨‰E--	ہہہےےے	!ً¦jF	!ًjF-	€€€	!ًjë	!ً¦ˆF--ˆëkG-		ہہہ2
َےGkëˆ-2
qJCreate New Budget Year(s)					-
---'ےے-
--ہہہ	ت4-	ےےےےےے	!ً©@F	!ً @F-		!ً @î	!ً©_F--	ہہہےےے	!ً§AG	!ًAG-	€€€	!ًAي	!ً§^G-^يBH-		ہہہ2
َےHBي^!2
GcCreate New PI Row						-
---'ےے-
--ہہہ	ت4-	ےےےےےے	!ً·@	!ً @-		!ً @ة	!ً·_--	ہہہےےے	!ًµA	!ًA-	€€€	!ًAب	!ًµ^-^4B-		ہہہ2
َےBب^+2
GCreate New Equipment Row						-
---'ےے-
--ہہہ	ت4-	ےےےےےے	!ً·j	!ً j-		!ً jة	!ً·‰--	ہہہےےے	!ًµk	!ًk-	€€€	!ًkب	!ًµˆ-ˆ4l-		ہہہ2
َےlبˆ12
qCreate New Indirect Cost Row						-
---'ےے-
--ہہہ	ت4--ً-'ےے-
ہہہ	ت4-ےےےً	ْ"-4-	!ً4-ت-	!ًت--÷€€€€€€€€€ہہہہـہ¦تًےûً  ¤€€€ےےےےےےےےےےےے4'ےے‘ ‏ےصحصœ.“—+,ù®0¤08@HfنYear1Module1WorksheetsModules‏ےصحصœ.“—+,ù®0¤08@HfنYear1Module1WorksheetsModules‏ے
ےےےےہFMicrosoft Excel WorksheetBiff5Excel.Sheet.5ô9²q