Skip to main content

Easy debit card balance tracker.

I had started looking for a checkbook program (not seriously) for my phone to use for my debit card. My Palm Centro is an older, now discontinued, entry-level smart phone, so a lot of folks have moved on, developer-wise.
In a "why didn't I think of this before?" moment, I fired up my Centro's spreadsheet (provided by DataViz’s Docs to Go) and whipped up a quick and dirty way to keep track of my expenditures!

  a b c
1 =sum(b:d)    
2      
3      

Its basically a one-cell formula, usable for any spreadsheet. Cell a1 gets the equation to show the current balance, with columns b, c and d getting the number entries (deposits are positive, purchases are negatives). A1’s result is bolded to help it stand apart from everything else.

  a b c
1 37.77 50.53  
2   -4.67  
3   -8.09  

So, while there is room to improve it? My current balance is there, all quick and convenient like! Its no substitute for good tracking of your money, but for me its better than trying to keep a checkbook registrar with me.

Also, when I was thinking about it, it’s a good example of something that’s useful in a real-life way so I won’t have to buy an app for it. While you can say they’re cheap, I won’t have to try a bunch, deal with poor ones, etc. What’s also nice is this one little formula is portable, so it’ll make the jump when I upgrade from my Centro to a Windows Phone 7 smartphone in March. Something that an app can’t do.

Next lunch-break project? And spreadsheet that calculates tip at a restaurant, plus figuring out shares for splitting a check.

Labels:

Comments

Post a Comment

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.
10 comments
Read more

[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...?
Post a Comment
Read more

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...
5 comments
Read more