Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2010, 06:12 PM
Guinea Guinea is offline Income/Budget Calendar? Windows 7 Income/Budget Calendar? Office 2007
Novice
Income/Budget Calendar?
 
Join Date: Mar 2010
Posts: 3
Guinea is on a distinguished road
Default Income/Budget Calendar?

I am not even sure if Excel is capable of performing the functions that I am looking for, but I figured I would try. If not, I would like to at least be pointed in the right direction. Basically I want a document that can take my input, like some of the Excel budget templates out on the internet today....

The difference is, I want it to be somewhat of a calendar that allows me to plan out my finances as of future income dates. For example, if I have 500 dollars now. I get paid 400 dollars every Wednesday. I want to be able to type in an income or an expense on the days of a calendar and have all of the calendar days display what my total amount will be, so I know if I will end up going negative.... Here is an example:

March 1 - 500 starting budget
March 3 - First wednesday, 400 deposit, net = 900
March 5 - Car payment, 200, net = 700
March 10 - Next wednesday, 400 deposit, net = 1100


March 13 - Insurance, 100, net = 1000

Obviously I want this in a clean calendar form, not just text. I know this is asking a lot, but if anyone has seen anything like this or could point me in the right direction, I would really appreciate it... Something like this would really help my finances and be able to plan my expenses much more clearly.
Reply With Quote
  #2  
Old 03-10-2010, 05:24 AM
BjornS BjornS is offline Income/Budget Calendar? Windows Vista Income/Budget Calendar? Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
please look at the attachment. Does this do what you want?

Kind regards
Bjorn
Attached Files
File Type: xls Budget.xls (17.5 KB, 81 views)
Reply With Quote
  #3  
Old 03-10-2010, 05:26 PM
Guinea Guinea is offline Income/Budget Calendar? Windows 7 Income/Budget Calendar? Office 2007
Novice
Income/Budget Calendar?
 
Join Date: Mar 2010
Posts: 3
Guinea is on a distinguished road
Default Actually...

Actually, that is almost perfect. It is simple and provides me with just the information that I am looking for. I really appreciate you submitting that for me...

The only thing I was hoping for was to have that same information and method of displaying data, but in a calendar form. I don't know if that is possible, but it would make things a lot cleaner for me to actually visualize it in a calendar, so I could see Wednesdays and other days...visualize a 7 day period etc etc. Is that possible?
Reply With Quote
  #4  
Old 03-11-2010, 01:55 PM
BjornS BjornS is offline Income/Budget Calendar? Windows Vista Income/Budget Calendar? Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi again,
here is a proposal for solution. See the sheet "Calendar". You still update on the sheet "budget".

Kind regards
Bjorn
Attached Files
File Type: xls Budget2.xls (44.0 KB, 99 views)
Reply With Quote
  #5  
Old 03-11-2010, 09:11 PM
Guinea Guinea is offline Income/Budget Calendar? Windows 7 Income/Budget Calendar? Office 2007
Novice
Income/Budget Calendar?
 
Join Date: Mar 2010
Posts: 3
Guinea is on a distinguished road
Default

Again...very awesome that you are doing this for me. I actually took your first concept and put some of my own information to work. I found a calendar template that I really liked and put some of the same fundamentals into it... Here is what I was kind of talking about. Not sure if I could make it anymore systematic or clean, or if I could make the functionality any better...but this is kind of what I meant.
Attached Files
File Type: zip 2010-calendar.zip (82.7 KB, 106 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
calendar Bar Coloring fltpro Project 0 12-02-2009 06:40 AM
Calendar disappeared David Bruner Outlook 1 10-29-2009 01:28 AM
online calendar acidd22 Outlook 1 05-21-2009 07:59 PM
Income/Budget Calendar? Calendar does not allow any changes benz240 Outlook 1 01-20-2006 10:06 AM
Calendar WON'T OPEN calripkenjr Outlook 0 01-19-2006 09:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft