ࡱ> gf T8\p Ramos, Amanda Ba==K=8X@"1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1 Calibri1 Calibri1h Calibri1Calibri1Calibri1Calibri1QTahoma1QTahoma1 Tahoma1Calibri1Calibri1Calibri1.Times New Roman1Arial1Arial1 Arial1 Arial1*h6 Calibri Light1,6Calibri16Calibri16Calibri1Calibri1Calibri1<Calibri1>Calibri1?Calibri14Calibri14Calibri1 Calibri1 Calibri1Calibri1 Calibri"$"#,##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\);_(* "-"??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)                                         (  (  (  (  (  (  (  (  (  (  (  (    #   % ff + ) , * , '    P  P    !   $ `        "      a &  @ # " ,  , H   ,      @+  D    "  1 @ @   @ @  (@ @   @ @  1*@ @  1*@ @  "@ @  , @ @   `@ @   d@ @   @ @  "@ @  1+@ @  1(@ @  , h@ @    h@ @      (""(( <  $      , h@ @  1*@ @  1*@ @  ||gV'}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-} #0\);_("}-} #0\);_("}-}- #0\);_("}-}< #0\);_("}-}A #0\);_("}-}B #0\);_("}-}C #0\);_("}-}D #0\);_("}-}E #0\);_("}-}F #0\);_("}-}G #0\);_("}-}H #0\);_("}A}I #0\);_("L ;_(@_) }-}J #0\);_("}-}K #0\);_("}-}L #0\);_("}-}M #0\);_("}-}N #0\);_("}-}O #0\);_("}-}P #0\);_("}-}Q #0\);_("}-}R #0\);_("}A}S #0\);_(";_(@_) }A}T #0\);_(";_(@_) }A}U #0\);_(";_(@_) }A}V #0\);_(";_(@_) }-}W #0\);_("}A}X #0\);_(";_(@_) }-}Y #0\);_("}-}Z #0\);_("}A}[ #0\);_(";_(@_) }}\ #0\);_("vV@?LL&&ÿ?}-}] #0\);_("}}}^ #0\);_("V@  }(}_ #0\);_("}-}` #0\);_("}(}a #0\);_("}(}b #0\);_("}-}d #0\);_("}-}e #0\);_("}-}f #0\);_("}-}+ #0\);_("}-}, #0\);_("}-}. #0\);_("}-}> #0\);_("}A}2 #0\);_("V@}A}3 #0\);_("?V@}A}4 #0\);_("23V@}-}5 #0\);_("}A}1 a#0\);_("V@}A}( #0\);_("V@}A}8 e#0\);_("V@}}6 ??v#0\);_("̙V@  &ÿ}}; ???#0\);_("V@?????? ??? ???&ÿ}}) }#0\);_("V@  &ÿ}A}7 }#0\);_("V@}}* #0\);_("V@?????? ??? ???&ÿ}-}@ #0\);_("}}: #0\);_("V@  &ÿ}-}0 #0\);_("}U}? #0\);_("V@}A}" #0\);_("V@}A} #0\);_("efV@}A} #0\);_("LV@}A} #0\);_("23V@}A}# #0\);_("V@}A} #0\);_("efV@}A} #0\);_("LV@}A} #0\);_("23V@}A}$ #0\);_("V@}A} #0\);_("efV@}A} #0\);_("LV@}A} #0\);_("23V@}A}% #0\);_("V@}A} #0\);_("efV@}A} #0\);_("LV@}A} #0\);_("23V@}A}& #0\);_("V@}A} #0\);_("efV@}A} #0\);_("LV@}A}  #0\);_("23V@}A}' #0\);_(" V@}A} #0\);_("ef V@}A} #0\);_("L V@}A}! #0\);_("23 V@ 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 23f % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23Ў % "Accent1AAccent1 [ % #Accent2A!Accent2 }1 % $Accent3A%Accent3  % %Accent4A)Accent4  % &Accent5A-Accent5 Dr % 'Accent6A1Accent6  pG %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/ Currency 20Explanatory TextG5Explanatory Text % 1Good;Good  a%2 Heading 1G Heading 1 DTj%[3 Heading 2G Heading 2 DTj%?4 Heading 3G Heading 3 DTj%235 Heading 49 Heading 4 DTj% 6InputuInput ̙ ??v% 7 Linked CellK Linked Cell }% 8NeutralANeutral  e%3Normal % 9Normal 2 :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent= Percent 2 >Title1Title DTj% ?TotalMTotal %[[@ Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`SP Unobl Calc Multi Index _xlfn.DAYS~v0 S AA@A@   /.RNIH Estimated Unobligated Balance Calculator - Fill in items highlighted in yellow1. Enter Sponsor Award #:2. Enter Today's Date:3. Enter Banner Grant:#-5. Enter Current Year's Award amount per NOA: 7. Total:(Unobligated balance should be less than:*4. Enter Dates:Budget Period Start:Budget Period end: Project Period Start:Project Period End:Days left in budget period&Days elapsed since budget period startA: Foreign SubcontractsB: PDC payroll changes13: Projected ExpendituresC: Major Purchases"14: Estimated Unobligated Balance:%15: Percentage of Total Years budget:>25% DOES require justificationParent and child totals Total8* NOTE: If Multiple Index #('s), complete "Multi Index" Carryover from ePrint FZRB090ParentChild 1Child 2Child 3Child 4Child 5Index #*Enter Total in cell #F16 on Unobl Calc tab*Enter Total in cell #F22 on Unobl Calc tab8 worksheet to calculate totals and insert result below<6. Enter Carryover from ePrint FZRB090 ("Available Balance" &(Backup documentation required on A-D)D. Allowable OH on commitments #<25% Does NOT require justification7 as of the end date of the previous budget period): 5658. Enter Total Available Balance from ePrint FZRBD90:+Total Available Balance from ePrint FZRBD90:10: Estimated Expenditures for Remainder of budget period:>11: OPTIONAL: Anticipated Commitments not reflected in Banner:*9. Actual expenditures for current period:2= >l?J@@\/BccA PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭Vitheme/theme/theme1.xmlY[F~/?;I|ͶMBq[if%yKևRh/1 m#zf$38{a)ii3ߜst:8M|:81M_(#bt7v?:!1AM7bS, #~p &,dZ'FX)bH:1Ʉ3.ݥXp90@ƆŽCѦ ?Cpԟ[ܽ^D;[l52QE͙LI=V_jFҔo7]?j[V^_+PWo=Vx^R|Z]f($>@Y6LݳׯU2+TC^]r ŶZ#  ;b14* Ji7C10\*?O4k !ᣄDק^>g?gs+Wݻϝ?݋ө\ǿ鋷>U(|o_XtÇ$ܹO{,Zb'Bx{ f$26# LXfF1f5\Zxj<{Hpo>y%64R 41Ǝ0!!F\(aM8mD!CVF{$,l!Fl8mFmc CL0Ds"!}$B")16; WK-P{"2 G61eGE3v@P~Ds w<"E3X^g%i{d&Dm9(!hjeW¢aaQ`ɁV=0#xBeT/yL`UեvL$r3IȨC4Yuиhd(|PZ+X\6` 4֕I >͚0ApEt /F"Io(,ᢋx\N8q(\~+ Q\dC#I7'<zڵ> Ue~ydsH 8tCPb~,8&^h ̅lUk)]tYy WRQgy lP-$Y#<yH9lgiꙆȮiW1ceX嚼jb4çҽ.֭.ghd5xSfgfX. jiKkq{u:Tr_">|&#.SU*C`C4P{T6y,[yB:S(^zBoU -߯{~mWBcaTӏ.}xE٧5%Zk6bQ+EE\}~)W~qΓoTШۮ]ZF+תvW/N%I(ԼJZzmc`|d*^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 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!u>itheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]  T8 .t|  dMbP?_*+%,&ffffff?'ffffff?(?)?M \\print\RPPRT23"C odXXLetterDINU"@ U@ SMTJ0 IUPH%xMKADt):D!L}3:DNXv[" }] :U*/ыI.Ύ~ ,=rw !{ +ghȦiҜ[Iw/.}WY5i3rOc%4v^/+|>_M- ˉD]ٔ)7\ia1z#aơ^I wr ""zO=p DD-e?~2.gFVb'A!'eVw臙Ԉi]ohL6!Lbvi?̵}ȞQ<+uFeIKZpbLJ6 )haߖ&ouGpl=:@6r/|]뇋'u5Tt4bvKy n<B"MXX333333?333333?&<3U} I} 5} $} $ } } } } I }  } I} } .   , , , , , , ,   , ,A , , , , , , , , , , , , , , , , , , K KK U AAA V JAA U AAA I AAA I#  B VA B  V J BW Y ) X#D DB Z# v@ mD + G"DD D 0(((>4&7 E 0Q G"&"""  ,! ," ; # ; $ ,% & ,' ;( ,) ,* ,+ ,, ;- , F# G  %  ]! ] "%"G#DD " ] #"#^% D"D$] $B'e%\B%OD#  NO JUSTIFICATION REQUIRED JUSTIFICATION REQUIREDB %B %AA&A &AA'bbacA'A(]]]])aaaa*]]]]+]]]],bbac-]]]] ? A4  ] (   x  6ncɅX?C!@]4@ DEξ)D% C<DCyr, Joan: Not on equipment, participant costs or Subs over $25,000<7 !C  Cyr, Joan >@Z, *  ggD T8 Ш  dMbP?_*+%,&ffffff?'ffffff?(?)?M \\print\RPPRT23"C odXXLetterDINU"@ U@ SMTJ0 HP Universal Printing PCL 6 (v6.6.0)InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueFastRes1bppResolution600dpiPrintQualityGroupPQGroup_2DryTime0Saturation0BlackInkSpreaddefaultHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNoCmdHPColorSmart_ColorOptions_HalftoneNoCmdHPColorSmart_Text_NeutralGraysNoCmdHPColorSmart_Text_HalftoneNoCmdHPColorSmart_Text_RGBColorNoCmdHPColorSmart_Graphics_NeutralGraysNoCmdHPColorSmart_Graphics_HalftoneNoCmdHPColorSmart_Graphics_RGBColorNoCmdHPColorSmart_Photo_NeutralGraysNoCmdHPColorSmart_Photo_HalftoneNoCmdHPColorSmart_Photo_RGBColorNoCmdOrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALHPPrintOnBothSidesManuallyFalsePaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE215HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionHPOutputBinOrientationFACEDOWNPunchingNoneStaplingNoneHPStaplingOpposedFalseEconomodeFalseTextAsBlackFalseAlternateLetterHeadFalseHPSmartHubInet_SID_263_BID_514_HID_265PCFoldingNoneEdgeToEdge_PCFALSEOutputBinAutoSHOutputBinAutoSHPunchingNoneSHFoldingNoneHPDocPropResourceDatahpchl215.cabHPLpiSelectionNoneJPEGEnableAutoHPEasyColorOnHPMHDLLNameHPFIE215HP_DIBStitch_TintTestDisabledHPMediaTypeTreeviewPopupTrueHPColorModeCOLOR_MODEColorMode24bppTTAsBitmapsSettingTTModeOutlineHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPBornOnDateHPBODHPColorPlaneHPCPHPInkPdlGrayScaleNoCmdSHRightEdgeStaplPunchRightStaplPunchHPJobByJobOverrideJBJOHPJobAccWoPinTrueHPXMLFileUsedhpcu2156.xmlHPUDMDataMapFilehpcu2156dm.xmlHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPDuplicateJobNameOverrideSWFWHPEnableRAWSpoolingTrueRGBColorNoCmdOutputProfileSHDefaultSHFrontCoverInsertionNoneSHBackCoverInsertionNoneJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPBestGlossDefaultPSAlignmentFileHPCLS215HPManualDuplexFirstHalfRotateTRUEPaperSizeDefaultForLocaleEuropeanIUPH%xMKADt):D!L}3:DNXv[" }] :U*/ыI.Ύ~ ,=rw !{ +ghȦiҜ[Iw/.}WY5i3rOc%4v^/+|>_M- ˉD]ٔ)7\ia1z#aơ^I wr ""zO=p DD-e?~2.gFVb'A!'eVw臙Ԉi]ohL6!Lbvi?̵}ȞQ<+uFeIKZpbLJ6 )haߖ&ouGpl=:@6r/|]뇋'u5Tt4bvKy n<B"NXX333333?333333?&<3U} } I   , , w   efffffffQ R R R R R RR M SSSSSS N O*TTTTTT#P% % ! O**TTTTTT#P % "P&h2q  "  (  x  6PхX?@P]4@ w8T,Au38 O <PCyr, Joan: "Available Balance" as of the end date of the previous budget period<  9O  Cyr, Joan>@, *    b(b( Lf&3?ggD Oh+'0HPd|  Cyr, JoanRamos, AmandaMicrosoft Excel@4@#3@nu ՜.+,0 PXd lt|   Unobl Calc Multi Index  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUWXYZ[\]_`abcdeRoot Entry FWorkbookKSummaryInformation(VDocumentSummaryInformation8^