Closed Thread
Results 1 to 5 of 5

I'm trying to build a "Hand to Mouth" type of budget. Feel like offering some advice?

  1. #1
    Registered User
    Join Date
    04-19-2011
    Location
    las vegas, nv
    MS-Off Ver
    Excel 2010
    Posts
    2

    I'm trying to build a "Hand to Mouth" type of budget. Feel like offering some advice?

    Ok so some quick background. I live hand to mouth. I hate it, but it is what it is.

    Most budget programs, spreadsheets, apps, websites fail to account for those of us that don't think about our bills on a monthly basis. I dont give a fat rats a** when TMobile is due, because they're not getting paid until I get paid.
    Of course I try to pay everyone with the check BEFORE their due date, but you get the idea.
    I dont have a $600 grocery budget for the month, I have a $300 budget every pay day. I dont pay my van payment when its due, I pay with the check that is not rent. Make sense?
    I thought it would be awesome to have a spreadsheet that automatically figure my due dates and list them with the check that matches their due date.
    I wanted it to be as automatic as possible, mostly so I could learn Excel more. Arrays, named ranges, dynamic named ranges etc etc.
    Well I was doing pretty good but then I got lost. I tweaked it so it works for me, but not for everyone. (people with 1st and 15th checks. People with weekly pay dates, etc) There's many bugs, and I'm just curious if anyone wants to give it a once over and offer some suggestions.
    Some of the bugs I notice:
    1) when I delete a row above the expenses section, one row of the expenses section errors out with a DIV/O. I figured out why the error is happening, but not why...the error IS HAPPENING.
    2) If a bill is due weekly, but I get paid bi week, the sheet won't automatically add the 2 amounts together for my check. ie)I put $100 into babysitting every week, I need it to tell me to pay $200 each check. I know I could do a formula that would divide the due date frequency (in this case, 7 days) by my pay date freq (14 days) and if it divides evenly (14/7 = 2), multiply the bill times that. $100*2=$200, but then it gets all funky on the next due date and I just can't figure it out.
    3) I had to list (in cells, instead of an array) the due dates of each bill on the sheet and then hide the columns (for appearance reasons) because when I try to enter the formulas as an array the due dates become incorrect. Don't know why. Probably because it would be a nested array at that point.
    There's tons more, but whatever.
    Also, my ultimate goal would be to have a budget app that will perform some calculations and decide if I can't afford to pay a bill with one check, but i have left over money on the check before, to move it to that check. I know that's some pretty extensive logic and not something that excel could do easily, but it's something to consider.

    tl;dr I made a hand to mouth budget and if anyone is feeling like offering some advice, please do so. I'm not looking for you to fix my errors, but maybe check out my named formulas and such and just offer some advice on how to do things better.

    note: I hid some rows and columns in the template and forgot to unhide them before uploading. The reason is because a) if i delete the rows, the sheet erros out and if i delete the columns, the sheet wont work, because I suck and couldn't figure out how to get the formulas into an array that works.

    non members link, if it is allowed:
    https://rapidshare.com/files/4598693...uthBudget.xlsx
    Attached Files Attached Files

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: I'm trying to build a "Hand to Mouth" type of budget. Feel like offering some adv

    Welcome to the forum.
    Please notice that this is a moderated forum and we do enforce the rules. The rules can easily be found by clicking the Forum Rules link above. The rule concerning posting the same question to multiple forums requires you to post a link to the other forum so we can track progress there and not duplicate effort and waste time.

    Because you're new to this forum, I'll post the link for you THIS time...but, you will be expected to follow the rules in the future.

    http://www.mrexcel.com/forum/showthread.php?t=547107
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    04-19-2011
    Location
    las vegas, nv
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: I'm trying to build a "Hand to Mouth" type of budget. Feel like offering some adv

    thanks. I had posted here first and then posted to the other after signing up and all that. Sorry about that.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: I'm trying to build a "Hand to Mouth" type of budget. Feel like offering some adv

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    IT WOULD SAVE US ALL TIME IF YOU ACTUALLY READ THE FORUM RULES
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: I'm trying to build a "Hand to Mouth" type of budget. Feel like offering some adv

    Your thread is being closed for non compliance with our rules. Please PM me when you have read the forum rules RULES and made the changes to your post accordingly, i will then unlock your post so you may continue with the thread!

    Post Closed

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1