Skip to main content

Easy tip/share calculator

At work we’ll sometimes go out to eat for birthdays, splitting the check at the end. At the end of the meal we have to go through two steps; figuring out the tip, then everyone’s share (joys of going dutch). Sometimes everyone fends for themselves, but the birthday boy/girl gets their meal for free, with the rest of us splitting the bill.

a b c d
1 Bill Tip % Amount Total
2 format as $ format as % =a2*b2 =a2+c2
3
4 # of people $ per
5 1 =d2/a5

Its easy enough. Things are laid out the way they are so its easy enough to adjust. You put in your bill into a2, the percentage you want to tip into b2, and the rest gets figured out for you. If you’re splitting something, change the 1 in a5 to however many people you’re splitting by.

For instance, if me and two friends of mine went to eat, with the meal costing $24 and is wanting to tip 30%?

a b c d
1 Bill Tip % Amount Total
2 $24.00 30 $7.20 $31.20
3
4 # of people $ per
5 3 $10.40

Easy enough! Again, its one of those things I’ve seen apps for but if you’ve got a spreadsheet on your smartphone? No need to buy or download one (important if you don’t have a data plan currently!). And, before you say that nobody has a smartphone without a data plan, keep in mind I was without one for almost two years, plus there are people who have had to turn off the data service to save money! A smart phone can be very useful, even without the data plan!

Plus, there is the iPod Touch to consider, too! There are a few spreadsheet apps available in the app store, after all :)

The more I mess with spreadsheets, the more I find how useful they are. The fact you can carry one around with you in your pocket, as opposed to needing a laptop or desktop, means you’re not chained to your desk. And, ultimately, that is what a smartphone is all about.

Comments

Popular posts from this blog

[STO] PVP as War, PVP as Sport.

In the middle of last year, I read a little on a thread about "Combat as Sport versus Combat as War." It was referencing a very long opinion post for Dungeons & Dragons 5th Edition (currently in development). Intriguing as it was, though, is was concerning a tabletop role-playing game. Could it offer anything worth noting about Star Trek Online's PVP? I think so.

The difficulty of cooperative games.

Sunday afternoons I normally find my self at Paul and Mandy's house. They're a wonderful couple with a wonderful family - gracious and hospitable. The time is often spent playing games of various types - word, card, personality, trivia, etc. We've played Moods, Wizard, Pit, Title Recall, Shout it Out and more, enjoying ourselves the whole time. Its not uncommon for the house to have eight or more people there, visiting, and enjoying each other's company. Much to their credit, as well as the folks who come, its often laid back and everyone is a good sport about winning, losing, and generally just playing. But one thing I was wondering, however, is "are there many cooperative games?" As is, the games we play are typically competitive in nature. The rules set up a system for that competition that everyone has to abide by and goes from there. There is really only one winner, be it an individual or a particular team. Now, that is good, and enjoyable, but "in t...

[STO] Master Keys without spending a dime.

Cryptic/PWE just unveiled the latest lockbox for Star Trek Online: the Temporal Lock Box . Its time-travel themed, with all sorts of neat ships, consoles, etc., both to be won on random chance and via Lobi. You should really take a look - they're very cool looking . Now, given that Master Keys cost $1.25 each (well, less if you buy 10-packs), you might be hesitant to go after them. You might also be leery of the whole lockbox scheme. And, that's understandable. Goodness knows Pavlovian responses aren't limited to just dogs! So, how to play without paying...?