Excel Quickie: Gas-hole

My previous job paid for my gas. But i used my car for things other than work, like driving to my other job, or driving to interviews for new jobs. So the gas that they paid for was kind of a bonus, and i wanted to know exactly how much it added to my total compensation package. So...

gas bonus = total spent on gas - cost of gas used for legitimate business travel

...and...

cost of gas used for legitimate business travel = miles * price of gas / MPG of my Cavalier LS

For my job, i traveled to and from various clients' houses all day. So i threw together this little chart as a quick reference for the exact mileage getting from one place to another.

Comments

Zombie Cafe Optimization

In this game, one has a stupid zombie staff that one gets to serve disgusting meals to idiotic customers. Naturally, it was my favorite. Once a zombie chef finishes preparing a meal, they place the serving dish on a counter. From there, zombie waiters can obtain one serving of a meal to deliver to a seated customer. Since the amount of time it takes for a single customer to be served has a trickle down effect on the entire restaurant (quickly serving customers yields higher tips, rapid turnover increases profit and prevents customers from leaving angrily due to inadequate seating, extended service times increase the overall number of waiters needed to serve a steady flow of customers, etc.), obviously it is crucial to optimize this factor of game play. One element of the serving process that greatly affects service time is the location of the serving dish, since this modulates the amount of time for a stupid zombie waiter to obtain a disgusting dish, bring it t...

Walk It Out

You know how every electronic these days is constantly telling you to walk? Well, I'm not the type to ignore a robot, so I literally get to steppin'. But how much to step? How many steps? How often? The fitbit app demands 5 days of exercise per week. It doesn't start tracking "exercise" until you've been "exercising" for 15 minutes. So that's our daily lower limit. The U.S. Department of Health and Human Services 2008 Physical Activity Guidelines for Americans recommends adults perform moderate-intensity aerobic exercise such as a brisk walk a minimum of 30 minutes, five days per week (or a total of 2 hours, 30 minutes) to reduce the risk of disease later in life. So that gives us a goal of 150 minutes per week. I also feel it's important to take into account how lazy I've been of late. I walked a mere 51 of 150 minutes last week. Ouch. OK, so my goal is 150 minutes a week, but let's throw in a...

Grocery Store Sale Comparisons

I'm collecting more data and refining these graphs! Featured above are the items generally priced above one dollar per unit. This graph showcases those items which typically cost less than one dollar per unit. Above and below are data tables, featuring item descriptions and sale expiration dates. The above tables streamline the data for the graphs. The databases below are used in formulas within the cells of the above tables to reference the appropriate values from the more detailed tables farther above and populate the appropriate cells.

Excel Excess

Search This Blog