Jump to content
  • GUESTS

    If you want access to members only forums on HSO, you will gain access only when you Sign-in or Sign-Up .

    This box will disappear once you are signed in as a member. ?

Free "envelope" app? Or program?


Recommended Posts

Anyone know of a place I can get an app or program that'll allow me to set up virtual "envelopes" for budget reasons?

Right now I have all of the monthly payments on an excel sheet that I print off and cross off the list as the payments are made, but I'd like to have one that will show the total still outstanding for the month as the payments are crossed off.

Yes, I know I could re-arrange the payments in the excel by their date, and then create another field to show what the total still due is as each one would be paid, but I cannot take that with me on the go.

Anyone come across something like this?

Or, can someone help me with the Excel sheet, making a new column that'll subtract the total paid without having to manually enter each row's total?

Link to comment
Share on other sites

I am not totally clear what you want to do, but does this sound about right.

Column A <amount due> Column B <amount paid> Column C <=column A - Column B> or =A1-B1

That would be row 1 from that point forward you could have have Column A = Column C

Once you get a few forumulas in you could just do an auto fill.

Is that something like you are looking for?

Link to comment
Share on other sites

Not exactly.

I have everything listed row format.

What I would like to do is have column J be a running total, so as the month goes along, as payments are being made, I can have a total of the outstanding bills.

My payments are all listed in column H. Total for the month due is around $xxx.xx. I will put that total in J2, and then have running total in Column J that as I pay a bill, there will be a running total of the remaining payments due, from J5 down to J39.

Link to comment
Share on other sites

I am still not quite clear how you have this setup, but if all your payments are in H and you want that total in J2 this formula in J2 would give you the total of payments made =SUM(H1:H9) or whatever cells you use in column H. I am not clear if H is payments owed or payments made.

Anyway you could put up sample of what you have with dummy data?

Link to comment
Share on other sites

I ended up doing it manually.

For example I put my monthly total due on day 1 at $9,500 for example, J4.

Then J5 said =J4-H3, J6 said =J5-H37 or whichever block in column H would be the one to be paid in daily order.

I know it's confusing, but it worked for me.

I don't really need a record of when they were paid, I just wanted a running total of the amount that the total bills were still due as I went through the month.

I could then compare that with the bank account(s) and receivables and make sure I was still quite solvent.

Link to comment
Share on other sites

Join the conversation

You can post now ↓↓↓ or ask your question and then register. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Your Responses - Share & Have Fun :)

    • A quick pass through the Black Hills on the way home…  
    • Bighorn sheep at Lemoille canyon.   
    • Wild horses in Sparks Nevada   ad
    • Donner lake near Donner pass in California   
    • Redwoods near Big Sur California.  
    • Power output is:  amps x volts = watts   If your charger is pushing 10amp at 12 volt: 12 x 10 = 120 watts.  2 banks = 240 watts.   240 watts / 120v at your outlet = 2 amp.   Efficiency isn't 100% so it's gonna be more than 2 amp on your garage circuit, but maybe like 2.4 amps.     I think.... It's been a while, LOL.  Either way 20amps output on a charger for a 12v battery isn't the same as pulling 20amps off your garage circuit.
    • Wanderer, thank you. I did look at the breakers for my garage/outside outlets and they are 20 amp.  I reached out to the company that makes dual pro chargers with the question and this is the reply I received.:     Thank you for reaching out to us here at PCS. The Sportsman series charger, although rated ay 10 amps per bank, draws only 5 amps from AC when all banks are charging. As the Professional series which provides 15 amps per bank, has a maximum AC draw of 7.5 amps with all banks charging.  
    • That’s an interesting point.  While I understand how Amps work, I can’t say I’m fully versed in the draw of modern on board chargers.   By modern code, outdoor and outbuilding outlets should be 20 Amp.  If your outside or garage outlets are 15 Amp, they’re undersized.  But that is quite possible if the garage was built before that code became enforced.   With heavy use, you may not be able to keep up on daily charging without the 10 Amp per channel charger, however that’s with very aggressive use for consecutive days.  On our June muskie trip we run up to 15 hours a day for up to 7 days on a 24V Ulterra and by mid week we’re starting to see the batteries not reach full charge.  That’s a lot of bank running at nearly 2 mph on windy shores.   We charge at a dock with up to 6 boats per dock plugged in - some with 36 volt systems.  Now I’m not sure if all the outlets are on a dedicated circuit but I’m betting they aren’t.  But they’re all 20A outlets with a lot of draw on them.  At max draw, they’re not keeping up but also not tripping the breakers.   What I’m saying, without a technical review is: you’re probably fine either way.  You probably won’t tax your batteries so much that they can’t recover on a 5 Amp per channel overnight charge and a 10Amp per channel charger probably won’t be too much to plug into your 15A outlet - if it really is a 15A.  If you’re sure, you’re sure, but I would double check if you’re not 100%.
  • Topics

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.