EXCEL ASSIGNMENT

profileGJbratt
Exp19_Excel_Ch05_CapAssessment_Travel.xlsx

Subtotals

Expense Employee Category
$ 93.28 Davidson Misc
$ 113.64 Miller Misc
$ 114.90 Hart Misc
$ 123.41 Abbott Misc
$ 124.64 Overton Misc
$ 400.00 Miller Airfare
$ 285.32 Abbott Meals
$ 304.12 Miller Meals
$ 324.08 Davidson Meals
$ 327.95 Hart Airfare
$ 340.76 Hart Meals
$ 374.82 Overton Meals
$ 423.99 Davidson Airfare
$ 450.00 Davidson Registration
$ 595.00 Abbott Registration
$ 595.00 Miller Registration
$ 658.00 Overton Airfare
$ 750.20 Abbott Airfare
$ 775.00 Overton Registration
$ 840.25 Miller Hotel
$ 864.84 Hart Hotel
$ 995.00 Hart Registration
$ 1,051.14 Abbott Hotel
$ 1,204.78 Davidson Hotel
$ 1,283.50 Overton Hotel

Expenses

Employee Category Expense
Davidson Misc $ 93.28
Miller Misc $ 113.64
Hart Misc $ 114.90
Abbott Misc $ 123.41
Overton Misc $ 124.64
Miller Airfare $ 400.00
Abbott Meals $ 285.32
Miller Meals $ 304.12
Davidson Meals $ 324.08
Hart Airfare $ 327.95
Hart Meals $ 340.76
Overton Meals $ 374.82
Davidson Airfare $ 423.99
Davidson Registration $ 450.00
Abbott Registration $ 595.00
Miller Registration $ 595.00
Overton Airfare $ 658.00
Abbott Airfare $ 750.20
Overton Registration $ 775.00
Miller Hotel $ 840.25
Hart Hotel $ 864.84
Hart Registration $ 995.00
Abbott Hotel $ 1,051.14
Davidson Hotel $ 1,204.78
Overton Hotel $ 1,283.50