Skip to main content

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

Popular posts from this blog

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...

What Happens When I Can't Get to Excel?

In life, sometimes it's hard to get to your spreadsheets.  Maybe you're playing a computer game that takes up your entire screen, and you can't reach your netbook that's on your home network and accesses all those spreadsheets you've stored on your shared external hard drive. Or maybe you're researching RAM cards so said computer game will run faster, but you're using the POS computer you hacked into at your bartending job.  Anyway, in such instances, you have to use nature's spreadsheet:  paper.  Here're some sweet examples of my less digital spreadsheets.    Best for you?

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.