аЯрЁБс>ўџ 1ўџџџўџџџ0џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ u'ЭЩ€сАСт\p Erik Thelen BАaР=œЏМ=x‡Ь8X@"Зк1ШџArial1ШџArial1ШџArial1ШџArial1ШџМArial1ШџArial1Ш Arial1Ш$Arial"$"#,##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%рѕџ Р рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР р Р р+ѕџ јР р)ѕџ јР р,ѕџ јР р*ѕџ јР рєџєР рєџєР р ѕџ јР р Р р+Р р HР р Р р  l@ @ * р(Р р(X+ р  l@ @ + р(|@ @ + р(|@ @ * р H* р+X* р H* р H+ р+X+ р H+ р H) р+X) р H) р h) р  L) р(P/ р X/ р X/ р(|+ р(t+ р(|* р(t* р+XР р(XР рX* рP* р(P+ р(p@ @ * р(|@@ * р(|@ * р(| @ * р)X* р(X* р(|* р(t* р(x* р(p* р*Р р Р р (|@ @ + рX* рP* р(|+ р(t+ р)X+ р(X+ р(p@ @ + р(P+ р(Р р (|@ @ * р(|@@ + р(|@ + р(| @ + “€џ“€џ“€џ“€џ“€ џ“€џ“€џ“€џ`…EFFORTŒЎ  ;4 ССTќ YThe percentage of your 9 month Academic Year that you plan to devote to this project is& OThis is ROUGHLY the following number of weeks during the 9 month Academic Year& OThis is ROUGHLY the following number of weeks during the 3 month Summer period& QThe percentage of your 3 month Summer that you plan to devote to this project is& UExample: I'm devoting 25% of my Academic Year to the project and 50% of my summer. HMy ANNUALIZED Academic Year effort is 25 percent times 9 divided by 12 =AMy ANNUALIZED Summer effort is 50 percent times 3 divided by 12 ='My TOTAL ANNUALIZED EFFORT is thereforeNThe amount of salary charged to your grant is based on your contract salary. XStep 4: Calculate the amount of your Academic Year salary corresponding to your effort.QStep 5: Calculate the amount of your Summer Salary corresponding to your effort.+Step 1: Estimate Your Academic Year Effort$Step 2: Estimate Your Summer Effort/Step 3: Calculate Your Total Annualized Effort>EFFORT AND SALARY WORKSHEET FOR FACULTY WITH 9 MONTH CONTRACTS6Step 6: Estimate Your Salary for Future Project Years You have a 9 month contract that runs from August 23, 2004 to May 22, 2005. This is roughly 39 weeks or 194 working days. The start and end dates vary each year: see the Office of the Provost website for the Academic Calendar for the current year's contract dates. You have 3 months of summer, running from May 23, 2005 to August 21, 2005. This is roughly 13 weeks or 65 working days. The start and end dates vary each year: see the Office of the Provost website for the Academic Calendar for the current year's contract dates.jFederal sponsors require effort calculations to be ANNUALIZED. Your ANNUALIZED summer effort (N*3/12) is& fYour total ANNUALIZED effort is the sum of your ANNUALIZED Academic Year and ANNUALIZED Summer effort.цExample: My Academic Year contract salary for Academic Year 2004-2005 is $40,000. I'm devoting 25% of my Academic Year effort to the project and charging 25% of my Academic Year salary to the grant. $40,000 times .25 = $10,000іExample: If my Academic Year contract salary for Academic Year 2004-2005 is $40,000, then one month of summer salary in 2005 is $4,444. In the example, I'm devoting 50% of my summer to the grant: $40,000 divided by 9 months times .5 = $2,222.Your salary for a month of summer effort is 1/9 of your contract salary for the Academic Year immediately preceding the summer.jsNThis is ROUGHLY the following number of days during the 3 month Summer period& NThis is ROUGHLY the following number of days during the 9 month Academic Year& 3This is roughly the following number PERSON MONTHS& †Federal sponsors may require effort calculations to be ANNUALIZED: Multiply your Academic Year effort by 9 and divide by 12 (N*9/12).XORSP typically budgets future year salaries using a 3-4% annual cost of living increase.џ"ф ‘Й’Књ" u'ЭЩ€ 6V&,9н>  dќЉёвMbP?_*+‚€%џСƒ„M‚ LANIER LD035 PCL 5e мЄ џъ odXXLetter (8.5" x 11")LANIER LD035 PCL 5eLPT1:€ Ща€ Y„м''''dd1397ччччччччччччччччDefaultЁ"[XXр?р?U} I } m} } I} } m } $ } } Ж } 6  џ@ џ џ §@ џ џ џ џ€ џ€ џ€ џ€ џ€ џ€ я@ џ џ џ 9@ џ џ џ џ џ џ џ џ џ џ џ џ џ џ§ BОCCCCCCCCCC § ! О"######### § >О?????????? О12222222222 § <О========== НH@$@Р?.@4@а?>@D@р?ш?№? § NО8888888888 # gfffff#@ џ DРТ­$ gfffff3@џМ LўџРТ­$ @8@џ ™™™™™=@џ gfffffC@џ @H@џ ™™™™™M@џ gfffffS@џ @X@џ 0b@џ @h@ џ§ NО 8888888888 # 433333џ? џ DР'  433333@ џ М  LќџР'  €@ џ   ffffff@ џ   433333@ џ   €#@ џ   ffffff'@ џ   433333/@ џ   €3@ џ  @=@ џ  €C@ џ § 9О :::::::::; # ЭЬЬЬЬЬм?" џ DР   ЭЬЬЬЬЬь? џ М  LњџР   ђ? џ   ™™™™™™ѕ? џ   ЭЬЬЬЬЬќ? џ   @ џ   ™™™™™™@ џ   ЭЬЬЬЬЬ @ џ   @ џ  @ џ  "@ џ § NО NNNNNNNNNN '333333Ѓ?­`§DР  j6333333Г?џМ LјџР  j6И?џЬЬЬЬЬЬМ?џ333333У?џШ?џЬЬЬЬЬЬЬ?џ333333г?џи?џ т?џ ш? џ§ $ О%&&&&&&&&& § GОHHHHHHHHHH О/0000000000 § IОJJJJJJJJJJ НH@$@Р?.@4@а?>@D@р?ш?№? § DОKKKKKKKKKK # @ џ DРA@џМ LўџРA@ @џ€#@џ*@џ@0@џ€3@џ:@џ@@@џ `H@џ @P@ џ§ DОKKKKKKKKKK #ЭЬЬЬЬЬф? џ DР ЭЬЬЬЬЬє?џМ LќџР њ?џ333333џ?џЭЬЬЬЬЬ@џ @џ333333@џЭЬЬЬЬЬ@џ@џ €#@џ *@ џ§ OОPPPPPPPPPQ #433333У? џ DР 433333г?ўМ LњџР и?џЬЬЬЬЬЬм?џ433333у?џш?џЬЬЬЬЬЬь?џ433333ѓ?џј? џ @ џ @џ§ DОDDDDDDDDDD '›™™™™™‰? џDР ›™™™™™™?џМ LјџР  ?џ333333Ѓ?џ›™™™™™Љ?џА?џ333333Г?џ›™™™™™Й?џР?џ Ш?џ а? џ§ ' О())))))))) § )О())))))))) зDl,,, ,L,x,x,x,€ ,, ,L,x,x,x,€, џ! џ" џ# џ$ џ% џ& џ' џ( џ) ў@* џ+ џ, џ- џ. џ/ џ0 џ1 џ2 џ3 џ4 џ5 џ О )())))))))) § !)О!())))))))) § "*О"()))))))+" +Ш?# џа?  " )§ #*О#()))))))+# +Р?$ џр? # )§ $*О$()))))))#$ +д? џ %"# Р Р$ )§ &! О&"######### § 'EО'FFFFFFFFFF О(56666666666 § )@О)AAAAAAAAAA О*3 § +$ О+%&&&&&&&&& § ,JО,MMMMMMMMMM О-MMMMMMMMMMM О.7777777777 § /JО/LLLLLLLLLL О0LLLLLLLLLLL О1LLLLLLLLLLL О24 § 3-О3,,,,,,,,,, § 4.О4,,,,,,,,,, 5з0iЄ ,aaY,, , ,, , ,,>ЖАЊ<d444хŠ/1 ,-     ))  ''     я7 ўџр…ŸђљOhЋ‘+'Гй0ШHPp„ œ Ј ДРфВЛСМбаОПЫљ Erik ThelenMicrosoft Excel@€Њ™С•ЅФ@ЃtEеRФ@’dRsХўџеЭеœ.“—+,љЎ0  PXx €ˆ˜   ЩфВЛСМбаОПЫљe: EFFORTEFFORT!Print_Area  Worksheets Named Ranges ўџџџ!"#$%&'ўџџџ)*+,-./ўџџџ§џџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџ РF –В6wХўџџџWorkbookџџџџџџџџџџџџж?SummaryInformation(џџџџ DocumentSummaryInformation8џџџџџџџџџџџџ(