ࡱ> HG g2ɀ\pTeresa Carlson Ba==x38X@"1Calibri1Calibri1Calibri1Calibri1 Calibri1Calibri1 Calibri1 Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1@Calibri1 Calibri1 Calibri1Calibri"$"#,##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\);_(* "-"??_);_(@_)$[$-409]dddd\,\ mmmm\ dd\,\ yyyy "$"#,##0.00                                                                       ff  +  )  ,  *     P  P        `            a>        $@   $       $@  D        $  $@ @     l@ @ -   ||NY~}-} yyyy;_(*}-} yyyy;_(*}-} yyyy;_(*}-} yyyy;_(*}-} yyyy;_(*}-} yyyy;_(*}-} yyyy;_(*}-} yyyy;_(*}-} yyyy;_(*}-}  yyyy;_(*}-}  yyyy;_(*}-}  yyyy;_(*}-}  yyyy;_(*}-}  yyyy;_(*}-} yyyy;_(*}-} yyyy;_(*}A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef ;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L ;_(@_) }A} yyyy;_(*23;_(@_) }A} yyyy;_(*23;_(@_) }A} yyyy;_(*23;_(@_) }A} yyyy;_(*23;_(@_) }A}  yyyy;_(*23;_(@_) }A}! yyyy;_(*23 ;_(@_) }A}" yyyy;_(*;_(@_) }A}# yyyy;_(*;_(@_) }A}$ yyyy;_(*;_(@_) }A}% yyyy;_(*;_(@_) }A}& yyyy;_(*;_(@_) }A}' yyyy;_(* ;_(@_) }A}( yyyy;_(*;_(@_) }}) }yyyy;_(*;_(@_)    }}* yyyy;_(*;_(@_) ??? ??? ??? ???}-}+ yyyy;_(*}-}, yyyy;_(*}-}- yyyy;_(*}-}. yyyy;_(*}-}/ yyyy;_(*}A}0 ayyyy;_(*;_(@_) }A}1 yyyy;_(*;_(@_) }A}2 yyyy;_(*?;_(@_) }A}3 yyyy;_(*23;_(@_) }-}4 yyyy;_(*}}5 ??vyyyy;_(*̙;_(@_)    }A}6 }yyyy;_(*;_(@_) }A}7 eyyyy;_(*;_(@_) }}8 yyyy;_(*;_(@_)    }}9 ???yyyy;_(*;_(@_) ??? ??? ??? ???}-}: yyyy;_(*}-}; yyyy;_(*}U}< yyyy;_(*;_(@_)  }-}= yyyy;_(*}-}> yyyy;_(*}-}? yyyy;_(*}-}@ yyyy;_(*}-}A yyyy;_(*}-}B yyyy;_(*}-}C yyyy;_(*}-}D yyyy;_(*}A}E yyyy;_(*;_(@_) }-}F yyyy;_(*}-}G yyyy;_(*}-}H yyyy;_(*}-}I yyyy;_(*}-}J yyyy;_(*}-}K yyyy;_(*}-}L|_(*}-}M |_(* 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 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%3Normal % 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`9Sheet1iSheet2jSheet38$ Enter Subtotal = Tax RateEnter Tip amount.Enter Total charge (including tax but not tip) Tax on food Tip for foodTax on alcoholTip rateTax rate5 - Verify calculations:!1 - Calculate the sales tax rate:6The RED cell is the amount eligible for reimbursement.Enter total tax amount#Enter amounts in yellow cells only.2 - Calculate tip percentage:&Total amount paid - Verify this amountC3 - Calculate the total cost of allowed food including tax and tip:7Enter total allowed food/non alcoholic beverage charges7Total allowed food/non alcoholic beverage charges + Tax^4 - Calculate the total cost of alcoholic beverages or non-traveler meal including tax and tip;Enter total alcoholic beverage charges or non-traveler meal;Total alcoholic beverage charges or non-traveler meal + Tax$Tip for alcohol or non-traveler mealATotal alcoholic beverage or non-traveler meal charges + Tax + Tip%How To Calculate for Meal Adjustments4= Tip rate (automatically adjusted down if over 20%) >Total allowed food/non alcoholic beverage charges + Tax + Tip Unallowed tax (over 20%)((tip automatically adjusted if over 20%)[Use for proper removal of alcohol or non-traveler meals from a receipt including associated*20% if the original percentage was higher.[tax and tip charges. This calculator also will automatically adjust the tip amount down to"3 V4y5{7ccB g2ɀ 1_dh  dMbP?_*+%,&?'?(?)?M HP Photosmart C6200 series#C odXXLetterDINU"0 l xtzOW60 SMTJ HP Photosmart C6200 seriesInputBinFORMSOURCERESDLLUniresDLLHPPreAnalysisFalseMSPreAnalysisFalseHPReportSymmetricMarginsFalseHPPaperSourceMappingTrueHPMinimizeMarginsTrueHPAlignMarginsForMDTrueHPPrintPreviewFalseHPOverSprayOptionAutomaticHPOverSpray100HPBorderLessPhotoFalseHPCustomBorderlessTrueHPOutputOrderReverseTrueJobUITruePaperSizeLETTEROrientationPORTRAITHPDocPropResourceDatahpzhlw71.cabHPNUseDiffFirstPageChoiceTrueHPDryTimeOptionAutomaticHPDryTime0HPInkVolumeOptionAutomaticHPInkVolumeNormalHPPrintInGrayScaleFalsePrintQualityNormalPrintQualityGroupPQGroup_2HPJobAccountingHPJOBACCT_TIMESTAMPHPColorModeCOLOR_MODEHPPDLTypePDL_PCL3HPTilingSelectionTrueHPMediaTypeTreeviewPopupTrueColorModeColor24MediaTypeAUTOMATICResolution600dpiPQDPIInstalledHPMirrorPrintFalseHPPrintOnBothSidesManuallyFalseHPManualDuplexDialogItemsInstructionID_01_FACEUP-NOROTATEHPManualDuplexPageRotateUserRotateHPManualFeedOrientationFACEUPHPSpeedMechFastDraftHPOutputBinOrientationFACEUPHPManualDuplexDialogModelModalHPManualDuplexPageOrderOddPagesFirstHPMapManualFeedToTray1FalseHPConsumerCustomPaperHPCustomHPColorSelectionForHPAEnabledHPSmartDuplexSinglePageJobTrueHPBornOnDateHPBODJobUINetworkTrueHPDriverDataDriverDataHPCustomSizeCommandTRUEHPSendPreloadCommandTRUEESPRITSupportedTrueHPRESDLLNameHPFRSW71HPRedEyeReductionOffHPDigitalImagingHPHomePrintingHPSmartFocusOnHPContrastOnHPDigitalFlashOnHPSharpnessLowHPSmoothingOnHPJpegPngPassthroughTrueHPReverseBandOrderForEvenPagesReverseBandOrderHalftoneHT_PATSIZE_DEFAULTHPMDSideCountTrueHPHagakiPrintingTRUEHPHTDLLNameHPFIGW71HPMHDLLNameHPFIEW71HPHPAFilterTrueHPIntentPERCEPTUALHPAdvancedColorSettingTrueHPICCPrinterFamily5700_6500HPCRDCommandTrueHPSendUnitMeasureCommandTRUEHPPaperSizeTreeviewPopupMetricHPSimplifiedUITrueHPPosterPrintingOptionSUIFalseHPPhotoFixBASICHPRPOFileNamehpfcnw71.rpoHPMaxDpiFalseHPXMLFileUsedhpc6200t.xmlDuplexVERTICALHPPaperSizeDuplexConstraintsLEGALHPAutoDuplexScalingTrueHPUseAutoDuplexUnitTrueHPInputColorSpaceCOLORSMARTxIUPHdLetter o [none] [none]Arial4Pd?TCARLSON<Automatic>R 44General Everyday PrintingdMicrosoft ExcelNone<General Everyday PrintingB B I C E D EXCEL.EXEC:\Program Files\Microsoft Office\Office14\EXCEL.EXETCarlsonHC86RL1IPACDRWDSGATCAPI;F4E8Q;Ki݅&E%9xPPBHAERP"dXX333333?333333?&<3U1GGGG@@,HS@ , , , ,HS@,,,,Hm@,,,,,,,,H > H H HH   H  E   E ! @ D D  ? HE E P@ :DD? DD?B ? HE AD  !D" DD !C DD BD !D/ DD 'L&DDD  K H<  3b-33-39 b@!,",#,%,&,',),+,H,b@-,.,/,0,!E !"A#D  "!#D% D!D" #!%C' D!D# %!&B DD &!'D) D%D& '')D.D!D#D' ) +H -C0D -.ID) .Q/I-;D? DDDD B / /FF#0JF %-/  0M 0FF ~-33339--q>@FB  ggD g2ɀ )j  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3U>@ggD g2ɀ k  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3U>@ggD Oh+'0HP`x nevans2Teresa CarlsonMicrosoft Excel@B?f@"_8_@b7r՜.+,0 PXd lt| UNL Sheet1Sheet2Sheet3  Worksheets  !"#$%&'()*+,-./012345689:;<=>@ABCDEFRoot Entry F\Workbook#lSummaryInformation(7DocumentSummaryInformation8?