Where have I been eating the past 4.5 years?

For the past few months, I've been having some issues with my corporate expenses getting paid on time. Yes, I was submitting my receipts in a timely fashion, but there seemed to be some lag getting reimbursed.

After spending way too much time on the phone with American Express and my Expense Department, I finally ordered a reconciliation report.  Basically, I wanted a log of each time I swiped my green corporate Amex card.

2 weeks later, I recieved an excel workbook in my email......I'm happy to report that the issue was resolved, and my Amex bills will now be paid in a timely fashion.  But, with all this wonderful data in hand, I decided to test my pivot table chops, and figure out exactly where I've been eating Monday - Thursday for the past 4.5 years.

While I had a good idea of where I've been eating, I was still a bit shocked by the results.  I can safely say that I am officially not a health conscious person anymore...and in fact.....I'm a bit amazed that I'm not at least 150 lbs heavier than I currently am.  Anyways, here's what I found:

Restaurant - # of Times Charged

• Starbucks - 163
• McDonalds - 69
• Papa Johns - 53
• Burger King - 32
• Subway - 22
• Arby's - 20
• Au Bon Pain (really, I eat here???) - 19
• Caribou Coffee - 19
• Panera Bread - 17
• PF Chang's - 14
• Taco Bell -13
• Chili's - 8
• Applebees - 7
• Wendy's - 7
• Jimmy Johns - 5
• Boston Market - 5

 I also ordered room service a ridiculous amount of times (at least 50..likely more, because some of them are likely rolled into Hotel expenses).  Also, I've had "HMS-HOST" (generic category that covers just about every airport) at least 78 times (again, likely more because I got bored with I was classifying each expense).

And last but not least....1 white castle expense.  literally 1 time going to white castle, and its damage was enough to make me never go back.

edit - I just realized that these numbers are a bit skewed.  they only represent the times that I put the expense on my card.  I know for a fact that I've been to Taco Bell more than 13 times in the last 5 years, but somebody else on my team probably grabbed some of those expenses.