Double check?
Jun. 18th, 2005 04:58 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
thebratqueenOkay, I've been staring at this for over an hour now and my eyes are starting to cross. Normally I adore math (as you know) but I have two different spreadsheets that aren't adding up so obviously somewhere I've done something wrong.
So - anybody want to double check my homework? ;)
Here's what I'm trying to do: I want to double check my calculations on what, if any, extra money I have in my account. I originally calculated this back in January since I was moving into a whole new way of keeping track of things and it was a nice clean break all 'round. Sparing you the details, I basically at the time figured out what extra I had in my account and then came up with a spreadsheet that was broken down by weeks and grouped by months that would help me monitor income and expenses. Now that it's six months later, I want to double check myself just to make sure the figures are accurate.
Now the kicker is that as sexy as my original spreadsheet was I made a mistake on it that I didn't discover for at least a month, namely that I was counting a weekly expense twice. I'm pretty sure I made all the necessary corrections but it's possible that I did not. In addition to that, halfway through I decided I didn't like the layout of the spreadsheet in terms of ease of information, so I adjusted that as well. I mention this because these are two key places where user error could've crept in, hence part of my paranoia and desire to double check.
Luckily for me my bank kicks ass so I'm able to go online and find out exactly how much money they think I have in my account right now. This number also jives with what I have in MS Money, so I can rest easy knowing that I haven't forgotten to enter in an income or an expense.
Now we come to the math part.
As I say, I want to double check how much extra money, if any, is in the account. "Extra" is defined as "money that is not used towards monthly expenses." I've got my budget down now so that nearly everything is either a flat monthly fee (eg cable, car payment) or estimated pretty close to what the monthly cost will be, depending on my actions (eg electric, food). This means my monthly expenses have been fairly constant and, since I haven't gotten a raise since I started this, so has my income.
So, given that my monthly income and outgo are at a constant, if I want to double check my figures, would I be right in thinking that one way to do that would be:
Current Bank Total - Uncleared Expenses + Uncleared Deposits = Subtotal
Subtotal + One Month's Deposits - One Month's Expenses = Extra money (if any)
At which point ideally that final number jives with the total that's on my other spreadsheet. Yes? No? Other?
So - anybody want to double check my homework? ;)
Here's what I'm trying to do: I want to double check my calculations on what, if any, extra money I have in my account. I originally calculated this back in January since I was moving into a whole new way of keeping track of things and it was a nice clean break all 'round. Sparing you the details, I basically at the time figured out what extra I had in my account and then came up with a spreadsheet that was broken down by weeks and grouped by months that would help me monitor income and expenses. Now that it's six months later, I want to double check myself just to make sure the figures are accurate.
Now the kicker is that as sexy as my original spreadsheet was I made a mistake on it that I didn't discover for at least a month, namely that I was counting a weekly expense twice. I'm pretty sure I made all the necessary corrections but it's possible that I did not. In addition to that, halfway through I decided I didn't like the layout of the spreadsheet in terms of ease of information, so I adjusted that as well. I mention this because these are two key places where user error could've crept in, hence part of my paranoia and desire to double check.
Luckily for me my bank kicks ass so I'm able to go online and find out exactly how much money they think I have in my account right now. This number also jives with what I have in MS Money, so I can rest easy knowing that I haven't forgotten to enter in an income or an expense.
Now we come to the math part.
As I say, I want to double check how much extra money, if any, is in the account. "Extra" is defined as "money that is not used towards monthly expenses." I've got my budget down now so that nearly everything is either a flat monthly fee (eg cable, car payment) or estimated pretty close to what the monthly cost will be, depending on my actions (eg electric, food). This means my monthly expenses have been fairly constant and, since I haven't gotten a raise since I started this, so has my income.
So, given that my monthly income and outgo are at a constant, if I want to double check my figures, would I be right in thinking that one way to do that would be:
Current Bank Total - Uncleared Expenses + Uncleared Deposits = Subtotal
Subtotal + One Month's Deposits - One Month's Expenses = Extra money (if any)
At which point ideally that final number jives with the total that's on my other spreadsheet. Yes? No? Other?
