Sunday, June 06, 2010

Ah…to post again!

It seems like a long time since December of 2009. Only what, six months ago? And here I am, June 2010. Last time, I found something inside that really got me writing about our trip through Financial Peace and many of the lessons that we had learned.

Now, I am sitting outside on my camping lot in Myrtle Beach, SC. This week, I brought my family to Pirateland Campground, a location that played prominently in my childhood. And now, I get to share this with my kids.

I will ask them “hey, go see if that bridge is still there” or “go out on the beach and see if a creek separates this campground from the next” and off they go on some mission. I’ll tell them stories of how the old pool use to have a diving board and was much deeper.

Spending time with your family is important. Making memories even more so.

Sunday, May 09, 2010

24N24 – Completed

My initial Season 1 viewing schedule was wrong, and I noticed it when I finished my first disc a little before 3:00 am. Each disc was nearly three hours long, and with six discs, the total time was closer to eighteen hours than the original sixteen that I had anticipated.

I changed the plan to watch two discs in three viewings with a two hour break after disc two and a four hour break between disc disc four and and five.

I got home from work about 6:30 and went straight to bed. I was afraid that I would not get any shut eye, but amazingly, I did. Cindy woke me at 11:40 when the alarm clock went off.

The six hours was a lot easier than I thought. Maybe it was the anticipation of knowing that I had a whole day ahead of me and this was just the beginning.

At 6:00, I took my first two hour “sync break.” The show was already at 08:00. During the break, I made breakfast for my family and saw them off for their weekend trip.

The next six hours was considerably more difficult and I felt my head nodding from time to time. I ran out to grab some take out lunch and finished up before three.

During my second break, I had the opportunity to go and congratulation a friend of mine for graduating Regent Law school. By that time, I think I had a thousand yard stare. On the way back, I stopped in a very busy Starbucks for a venti Ice Coffee. No sleeping during the breaks.

The final six hours started at six. By this time, I was ahead of the 24 time (which was now at 16:00), and so it was catching up to me, instead of the other way around. This was by design so that I could conclude the show at midnight. I took a quick “sync break” before the last episode so that I stated at 23:19 and ended right on time.

What was it like watching an entire season of 24 in one day? When watching them on broadcast TV, I often lost details of story arcs because the time compression is so tight. A minor character is introduced who suddenly disappears and three weeks later, you are trying to remember what happened to them. In the continuous viewing mode, the story makes a lot more sense. However, it also servers to point out that the show does not really happen in “real-time.”

For example, at 18:59, Jack and Walsh are in an empty field walking down a hill. When 19:00 starts, a shot of the sun establishes that it is going down, and we pick up with Jack and Walsh now walking in darkness. So, between 18:59 and 19:00 we completely skipped dusk – it was as if someone had flipped a switch.

It also seemed that the writers had trouble knowing what to do with Jack’s wife and daughter once they were rescued at noon. They go to a safe house, which is compromised, the mom gets amnesia and thinks that the daughter is dead and both characters wonder around for the next several episodes. Once the Palmer story resolved around the 21:00 mark, it seemed like there was some difficulty knowing how to keep him around for the next several hours.

I think that one 24N24 is enough for me. It is something that I can now scratch off my bucket list.

Wednesday, April 28, 2010

Old Man Hip

I am looking forward to my 42 revolution around the sun. 42 is one of those numbers that, well, make certain geeks snicker: after all, we know it to be the ultimate answer to life, the universe and everything.

Now, if only we knew the question.

The problem is that the body does not quite have the same resiliency as it did, say, 41 years ago. I have some issues with my left hip that adds just a little pain to about anything that involves moving.

I went to my first physical therapy session, an evaluation of what was going on. It always takes me a little while to warm up to someone, but, getting to know someone while they are touching you doesn’t help.

Luckily, I survived with my dignity intact, but with some astute observations made that I was not aware of: my posture is horrible. I always thought I had relatively good posture (didn’t we learn this in marching band?). I suppose sitting in front of a computer 60 – 75% of the day does not help. In my heart of hearts, I know the issue with my hip will heal; I just need to be patient with the process.

What do I want for my birthday? Simple – A homemade sheet cake that has the words “Don’t Panic” written in big, friendly letters.

That, and maybe a Pan-Galactic Gargle Blaster.

Saturday, April 10, 2010

24N24

On May 8th, Cindy, Katie and Megan will be out for the weekend, so I will have the ranch all to myself. What to do?

I have always wanted to do a 24N24 marathon – watch one season of 24 in a day. I would choose a day, and then begin watching a season and start the marathon at the same time that the show begins.

Using my trusty IMDB, the seasons of 24 start in the following hours:

Day 1 12:00 AM
Day 2 8:00 AM
Day 3 1:00 PM
Day 4 7:00 AM
Day 5 7:00 AM
Day 6 6:00 AM
Day 7 8:00 AM
Day 8 4:00PM

I think Day 8 is safely out, as it is the current season and will not be completed until May 24th. And because of the nature of the Marathon, I think I will rule out Day 3.

What scares me about the ones that are starting after 6:00 AM is going through the night without nodding off and falling asleep. I think that I would have enough momentum to go from 12:00 AM to 6:00 AM, and the 9:00 PM back to 12:00 AM seems doable.

Day 1 it is.

The next thing to consider is the timing. On broadcast TV, the episodes are 1 hour with commercials. On DVD, they are about 40 minutes. 40 * 24 = 960/60 = 16 hours. That takes 8 hours off of the marathon. If I started at midnight, I would finish around 4:00 pm.

But, is that in “the spirit” of a 24N24? There would be something cool about start at 12:00 and finishing the next day at 12:00!

Since the actual viewing time is 16 hours, I’ve broken that down into four blocks. I worked out the start and finish of the season matches up with the show and placed in 8 hours worth of breaks (Food, get out of the house, cat nap, etc.)

So, here is my initial schedule:

image

Again, I am taking anyone who wishes to sponsor me with caffeine products (coffee, five hour energy) and if you want to drop by and watch a block or two (or three or four) feel free!!

Perseverance

This morning, I woke up at 6:30. Cindy and Katie were getting ready to head off to Suffolk with the Ponies and Megan was still fast asleep.

Time to get up.

I went downstairs and made some coffee and remembered what had come from Amazon the day before: my blue ray version of Lord of the Rings. Not the Peter Jackson version, but the Ralph Bakshi animated film.

For me, this film holds a special place. I discovered LOTR in high school, and this film was something that I longed to see, but, it mostly showed at midnight movies. By today’s standards, the animation is not clean, but, put it in the context of 1978, the animation was absolutely fluid thanks to roto-scoping.

Coming in just over two hours, the film ends at roughly the same point as Jackson’s Two Towers. There was never a second film. I wonder if one was ever seriously planned?

The jewel of this disc, however, is the documentary. It is really neat to get into the head of an artist who was trying to do something that we take for granted today – make animation for adults.

One quote that Bakshi made was

Perseverance is something you get if you are doing something you truly love. And perseverance is something you don’t have if you don’t care about what you are doing.

This speaks to me, as I am realizing how much I want to truly understand and create via computer programming. It is almost like I had been in a fog for years where I was focused on the delivery, but not the craft. I had fallen into taking short cuts and bad practices and had done it so often that the end justified the means.

Over a year ago, I stepped away from a management gig because I wanted to program. But, I did not want to write software in the same way that I was previously. I challenged myself to learn and grow. You know what? There are a lot of talented people out there who share much of what they know and who can teach you new ways of doing things.

You have to just invest the time. Find your passion, and persevere! Don’t ask to be taught, go and learn!

As J.P would say: “Develop with Passion!”

Wednesday, March 31, 2010

Tolerance is a cop out.

A friend of mine shared an incident where his son shared certain cornerstones of the Christian faith with a friend at school. When my friend received the phone call, the word “tolerance” came up.

My friend responded with “Tolerance is a cop out.”

Crickets on the other side of the phone.

He went on to explain “Tolerance means that I can tolerate what you say, but still hate your guts.” Jesus’ teachings went way beyond tolerance. He instructed us to “Love our Neighbors in the very same way we love ourselves.”

Strive to move beyond tolerating your neighbor: love ‘em.

Friday, March 19, 2010

An American Hero

I apologize for reposting this obituary, but this hits really close to home.

Navy SEAL Chief (SOC) Adam Brown was killed in action in Komar Province, Afghanistan on March 16, 2010.  In true “Adam Brown Style” he died a true hero, placing himself in the line of fire to protect other members of his unit.  Adam’s Special Ops Assault Team was assaulting an enemy compound, an operation Adam had performed many times.  The U.S. Forces were engaging the enemy in a fire fight, when a portion of the U.S. soldiers were pinned down by very heavy fire from the enemy compound.   In an effort to protect his men, Adam charged the enemy and was firing on the enemy from a better vantage point, drawing fire away from his pinned down comrades.  His selfless action relieved the fire on his men, but it unfortunately resulted in Adam being struck by enemy fire.  One other member of the American Team was wounded, but Adam’s heroic action saved the other men.  The enemy compound was captured and all enemy combatants were killed in the action.

 

Adam was a 12 year veteran of the United States Navy, with several tours of duty overseas.  He is survived by his wife and two children.

Source

I first met Adam when he and his wife took our Financial Peace class. He was a small group leader and a shining light of Jesus on his team.

My heart aches over this.

Tuesday, March 09, 2010

Embarrassing Moment

I like to take a break at lunch and get away from the office. For several years, I have scooted over to the nearby Barnes and Nobles to enjoy a cup of coffee and a quick read.

What irritates me, however, is people who talk loudly on cell phones. It never fails that when I score a comfy chair, someone in the chair next to me makes a call and talks. Sure, it’s America, and I take the high road and just grin and bear it.

(I am very tempted to get another chair and sit directly in front of them and stare slightly to their left…when they ask what, I’ll just say “I’m thinking”).

Today I brought my laptop into the cafe and pulled out my ear plugs. Believe it or not, my favorite white noise is bird song. So, plugging in, I lost myself in nature’s melody.

But something was wrong, it was really soft, so I turned it up. still a little soft…oh there it is…another volume control on the media player. There we go…cranked up nice and high.

I dig into whatever I was reading and about ten or fifteen minutes pass by when I feel a tap at my shoulder. Looking up, I see my good friend and co-worker Laura pointing at the volume control. I take my earphones out to say “Hi” when I realize that I had plugged my earbuds into the microphone jack.

Who is the obnoxious guy now!?

Monday, February 08, 2010

The Card Game

I watched The Card Game on Netflix Watch Now last night. If you do not subscribe to Netflix, you should! Subscribe to their lowest tier and you get access to thousands of movies (and growing) that is available to stream directly to your computer.

Want to watch it on your TV? Then pick up a Roku Movie Player.

The Documentary

This past week, we had our “Dumping Debt” lesson in FPU, so this documentary really had resonance.  Here are some things you may not know about banking practices:

1. Free Checking – Once upon a time, you paid for checking. Then, they came up with the idea of “Free Checking.” By now, you should realize that nothing is “Free” – they moved the fee. Where did it go? Over draft fees. Before “Free Checking” if you bounced a check, you not only paid the bounced check fee, but you had to go contact the merchant and clear everything up. With Over Draft protection, they will cover you up to three of five hundred dollars. This “loan” is not labeled a loan, but a convenience – therefore it does not fall under the truth in lending terms. The rate on the overdraft convenience is 460%. Very competitive with Pay Day Loans.

2. Over Draft Protection – Was the banks response to Pay Day Loan industry, whom they were failing to compete with.

3. Prioritized Clearance – The bank uses sophisticated software that will clear high charges first in order to drain your account. If you go into overdraft, that same software will start to clear out the lesser charges next. This way, you can pay $50.00 for a $4.00 coffee.

4. 0% Credit Cards – Like Free Checking, 0% Credit Cards and No Annual Fees is another gimmick. However, Credit Cards are far less regulated than banks. They simply moved the annual fee to another fee structure.

4. What is my Interest – The founder of Providian, when presented with a credit card offer, admitted that he could not tell what his actual interest rating would be after the introductory period.

5. Universal Default – If you are late on a bill unrelated to your credit card, your credit card holder can raise your rates. Its called Universal Default.

6. Adjusting Loan Limits – Credit Card Companies can adjust your credit card limits and reset their terms – just because.

7. It hurts the poor – This really got me – those who are able to take advantage of credit cards are doing so at the expense of those living close to the edge. The reason that the product exists is to make money for the company. Those who are poor or living close to the edge are being raped by these companies. I agree, they should not be using them, but, that’s another subject. I might write more about this.

8. Congress’ Legislation did not go far enough – To put it bluntly, I side with Chris Dodd on this one –The Obama Administration did not want to do anything that would hurt the soundness of the banking industry. The banking industry is built on top of fees and until that is regulated that industry will continue to screw the consumer.

9. Housing – The reason that we are in the economic situation has a lot to do with the housing market. Did you know that people were refinancing their homes with sub-prime mortgages to pay off their credit cards just to go and run them up again?

But What about the Free Market?

I believe in the free market and capitalism and generally think that regulation is a bad thing. Most of the times, the Market will adjust and drive out the things that are harmful.

Not so in this case. In this case, the banks have done a good job at marketing their product. What other product do you approach with bended knee? Oh please, please give me credit.

The component of Capitalism that is missing from this formula is Moral Restraint (again, I need to write on this too).

This American Way of using Debt is unsustainable by the consumer. At least, that’s what I found to be true for me.

That’s why I quit. I am out. It’s not a win-win game, and don’t tell me about your Free Points and Air Miles that you get.

It’s a game of they win, you loose. I am not going to play their game. I quit. I am out.

The borrower is slave to the lender. – Proverbs 22:7.

Creating a Budget, Part 3

This is a series for creating a budget using Google Docs. Part One and Part Two describe creating a basic budget form.

In Part Two, we completed our Google Document Budget Spreadsheet. Now, you should test out the formulas that we entered and make sure that everything is working.

Go ahead, take some time to fill in the numbers. Don’t worry, if this is your first budget, it will not be accurate for about the first three months. After that, budgeting becomes second nature.

Allocating Your Income

Congratulations! You have just completed your first Zero Based Budget! You have spent EVERY penny on paper, on purpose before the month has begun. You want to do this every month. Cindy and I recommend that you start about mid-month so that you can forecast all of the monthly variables (such as Valentine’s Days, birthdays and kids needing clothing).

Next, we want to allocate your income over the next month. Life would be simple if we could get one paycheck at the start of the month and we could execute on the budget, but most of us get paid on a varying cycle.

In my household, we have only one regular income, which occurs bi-weekly. The biggest category on my budget is the mortgage. If I pay for my mortgage out of one paycheck, it will leave very little left over for other necessities, so, I am going to take half out of each paycheck.

With your Spreadsheet open, we are going to add to our column headers:

image

I have added a Pay Date, an Income and an Allocated Column. The Income Column and the Allocated Column are going to save the same purposes as cells B2 and C2.

Next, just like in the budget side, we are going to merge cells. However, instead of two columns, we are going to merge three:

image

Finally, we are going to add a formula to the allocated cell at F2: E2 -SUM(D3:D26).

Note: When you merge cells, you address the values in formulas using the left most cell. That is why we use SUM(D3:D26) instead of SUM(F3:F26).

Complete the new columns by adding formatting to the headers. If you have any other income that occurs on other dates, add another set of columns.

image

I copied and pasted the columns from D – F, but I had to re-enter the formula because the cell references where not correct. Make sure you enter some values to test that the Allocated values are working correctly.

Making Sure it all Adds Up

The last thing that I want to add to this are columns that will help me to determine that I have allocated everything correctly.

The formula for the first row is as follows: =B3-SUM(D3:G3). To translate what this is doing: subtract the value of cell B3 from the Sum of Cells D3 and G3 (technically, this says to sum all cells between D3 and G3). I am going to place this formula into cell J3 and then will copy this all the way down to my last category:

image

I’ve also created a header.

Now the completed spreadsheet looks like this:

image

Just a note – I do not use Google Docs for my spreadsheet – I use Excel. I have found that entering formulas into Google and copying cells is not as forgiving as Excel, but, as a free alternative, Google Docs is pretty good.

I hope that this series helps you get a very simple way of creating a zero based budget and allocation plan.

Saturday, January 30, 2010

Picasa 3.6.0: Coolest Thing I Have Seen Today

If you are like me, you have tons of electronic photos that you have been snapping for the last 10 – 15 years. Do you use a photo organizer?

If you don’t, give Picasa (from Google) a try.

I opened up Picasa looking for a “photo stitching” tool to help me with my Panoramic photos. There wasn’t one, but, I was prompted to update the software.

Following the software, I noticed my hard-drive spinning, and Picasa was stating that it was “scanning.” However, the “scanning” was under a new tab labeled “people.”

Picasa was scanning our photos looking for faces. Once you tag a few faces, it starts to build an album.

And it really works…notice how it is accurately picking out my daughter even at different ages in her life:

image

Now, that is cool!

Friday, January 29, 2010

Christmas 2010 Challenge

Today is January 29th, 2010. By now, you should be getting your credit card statements from last month’s Christmas extravaganza. Time to pay the piper, right.

Here is my Christmas 2010 Challenge: Ditch the Credit Cards and pay Christmas 2010 in cash!

Go Green! Choose Paper over Plastic!

This year, Christmas comes in December. That gives you about 11 months to figure out how much you want to spend next year and then save for that amount.

And…the best part of all, no piper to pay in January 2011!!

Thursday, January 28, 2010

Oh No!!!!

image

The last time I used a credit card was in November of 2006. Seems that now, I have more emergency savings, more investments, more college savings and NO DEBT.

But my credit is a C. Dag Nab It! I was going for an F!!!

Read Blogs? Get a Reader!

I went through several years of keeping all of my favorite blogs booked marked in one of “My Favorites” folder. I would simply wake up in the morning, grab some coffee and some cheerios and see what was going on in my little slice of the super highway.

Then, I noticed something called a blog reader. A blog reader, or aggregator, is a tool that is specifically designed for capturing data coming from a blog, or RSS feed. With it, not only can you keep up with your favorite sites, but, you can check out what is getting released this week at Netflix.

My current favorite is “Google Reader.” I like it because it is a web based reader. That way, when I am on vacation, I can still keep up. And, because it is from Google, you have excellent searching capabilities if you ever want to catch up again.

But be warned, my simple list of sites has grown! I can’t possibly read them all.

(HT to Marjie B. for the inspiration to write this)

A Sucker Born Every Minute

image

I think I will jump right on this!! Seriously, do you think they need my social, or, anything else?

Wednesday, January 27, 2010

Get A Check Up!

It is that time of year again to get a check up: on your credit report.

There are three credit reporting agencies – Equifax, Experian and TransUnion. Under the Fair Credit Reporting Act, each of these reporting agencies must give you an annual report. But, you have to ask for them

Don’t Get Fooled

There is a lot of money being made by companies that will sell you a credit report. Watch out, if they start asking you for a credit card number, you are NOT at the free site.

Go to AnnualCreditReport’s web site. From there, you can get started. Once you have requested the report, some might want to sell you a FICO score as an add on. Just say no.

What to do with the Information

Your credit report is your credit reputation. You want to make sure that it is accurate. For example, this year, a Walmart credit card has mysteriously appeared on my report. It wasn’t there last year.

I used an online dispute form. According to the FTC, they have 30 days to prove that this is mine.  I know it’s not mine, and I even called the GEMB, who had absolutely no record of me in their system.

Make sure it is right.

How often?

You can order 1 report from each of the agencies once a year. There is nothing stopping you from ordering all of them at once, however, I recommend doing this once every four months.

That way, you are checking your credit report all year round.

Enjoy the free benefit courtesy of the FTC.

Saturday, January 23, 2010

Handy Man Saturday

I came home from grocery shopping with Cindy this morning and was greeted by my oldest daughter. She informed me that her lock was broken on the door to her room.

As parents, we instantly switch to the “what did you do to screw it up” mode. It turned out everything was fine, but the latch was not aligning with the strike plate. The door would close, but you could effortless push it open.

Here is my time patented trick for fixing an interior door that can be pushed open.

  1. 1. Get about three or four magazines and a screw driver.
  2. 2. Loosen the screws on the butterfly hinge that is mounted to the door jamb.
  3. 3. Put the magazines under the door to push it up a little.
  4. 4. With the magazines still under the door, tighten the screws.

Nine times out of ten, this will fix the problem (and, gave me a chance to show the kids some of my mad handy man skillz).

Wednesday, January 20, 2010

Why I Quit Reading the Bible

It seems that, along with loosing some weight, being a better husband, a better father, I always make a New Year’s resolution (or change, or commitment) to read through the Bible during the calendar year.

For those who have taken this on, and have succeeded, I salute you. I usually start to trickle off somewhere during Leviticus (if I make it past Esau’s lineage).

Why do I quit?

There are some parts of the Bible that, honestly, don’t seem to make a difference in my day to day life. Just saying.

But, that’s not the real reason I quit. The real reason is that I have set myself up to fail in this task. I have taken this on as a resolution, a task to be accomplished somewhere between the time I wake up and go back to bed.

What is the Right Reason?

I have a lot of ideas about God, who He is, what He likes, what He dislikes. The problem is, most of my ideas are formed around what others have said about Him.

Something that I am learning is how much God loves me. Not in the Grand Daddy kind of way, but in the Daddy kind of way. He loves me enough that he disciplines me, He places new challenges in front of me. Sometimes, He leaves me alone, so I can learn the experience of making mistakes on my own.

The Bible tells me what God has said about Himself.

I want to discover more about Him. I want to allow Him to shape who I am, by surrendering my pre-conceived notions of what our relationship should look like.

Tools for the Journey

I have discovered Brian Hardin’s Daily Audio Bible. It is a 30 minute podcast that started five years ago. The format is idyllic: soothing music and nature sounds combined with Brian’s mellow voice create an image of sitting outside with a cup of coffee and a good friend reading the Bible. Every week, Brian changes versions of the Bible, and it is an excellent way for you to determine which one you like best.

Currently, Brian is reading out of Genesis, Matthew, Psalms and Proverbs. It takes about 20 minutes, and the remainder is spent with brief comments on a passage, promotion of the web site, and callers with prayer requests.

I listen to this in the evening, prior to going to bed. In the morning, I am reading out of Genesis (I just made it past the lineage of the Edomites). After having heard the passages read the night before, the text becomes much more real and alive.

Additionally, I have joined a smaller group of men who have committed to get together on a weekly basis for a para-biblical study (Elderidge’s Fathered by God). We are committed to praying for one another and building each other up in the Lord.

Instead of just reading the Bible alone, and quitting, I am moving along side others to walk with me. Maybe the real, real reason I have quit in the past because I have tried to do this alone.

I hope that with companions along the journey, I can spend this year in the Bible (even if I don’t get all the way through it!).

Sunday, January 17, 2010

Ringers - Where There's A Whip, There's a Way!



I tried to watch Ringers: Lord of the Fans last night and it was...horrible. Except for two clips of bands that had done covers of some of the music from The Hobbit and The Return of the King.

I especially liked No More Sundays version of "Where there's a whip, there's a way."

Thursday, January 14, 2010

Creating a Budget, Part 2

I started a series on creating a zero-based budget using Google Docs. Part one can be found here.

Today we are going to complete the header and the categories of the budget. Before we are complete, you will see how to add a formula and how to format the spreadsheet cells.

Categories

The following categories are taken from Dave Ramsey’s Quickie Budget. I have removed the categorizations and the “cash” asterisk indicator.

Giving Car Payment
Saving Car Payment
First Mortgage Gas & Oil
Second Mortgage Repairs & Tires
Repairs/Mn. Fee Car Insurance
Electricity Clothing
Water Disability Ins
Gas Health Insurance
Phone Life Insurance
Trash Child Care
Cable Entertainment
Food Other Misc
These are a very limited amount of categories, but should suffice for helping to build your first budget.
 

Back To Google Docs

Open your web browser and navigate to the Google Documents web site. After signing in, select your spreadsheet that you started during part one.

When we left off, we simply froze the top two rows, which will become our headers. Let’s fill those in now:

image

In cell A2, enter the text “Categories” by typing directly into the cell.

Cell B1 and C1 will contain the values “Income” and “Allocated”.

Income is the total amount your family brings in during the period that the budget covers. This your “Net,” or after tax. We will use a formula to calculate how much of your income has been allocated.

Next, add values for the categories into the cells starting at A3:

image

You can directly key in the values, or, you can try to copy and paste the values from the table above into the spreadsheet.

Next, I will “merge” the cells starting at B3 and C3 to form one cell that spans both columns.

Select cell B3 and move your mouse over to cell C3 while still holding the mouse button down. With both cells selected, release the mouse button (both cells should remain in the selected state) and then select the Merge Button on the toolbar (third button from the right). Both cells should now be merged together.

image 

Repeat this for each of the categories. Save your work.

Formulas

One of the reasons that I like using a spreadsheet is that I can enter calculations and formulas that will do everyday simple math. I have come to realize that if I am going to make a mistake with the budget, it will be because of simple math.

I can have a spreadsheet automatically add a Range of Cells by using the following formula: =SUM(B3:B26). This formula will give us the total amount that has been entered into the categories. We can subtract our Income by modifying it to =B2 - Sum(B3:B26) which will give us the amount allocated.

image

To test the formula, I am going to enter 2000 for the income value and then add numbers to the categories. Allocated value should be calculated as I enter numbers.

image

Save your work.

Formatting

Another thing that I like to do is format my spreadsheets. This is completely up to you, but the things I like to do is

image Format the Numbers as Currency
image Color the Headers
image Add Lines
image Bold the Headers

image

Don’t forget to save your work. Now, you are ready to “play” with the numbers and start your first quickie budget.