Posts Tagged Lotus

Circumstance has forced my hand,

To be a cut price person in a low budget land

- from Low Budget, by The Kinks, circa 1979

They say the more things change, the more they stay the same.  I remember when that song came out; we were embroiled in controversy with a Middle Eastern country, faced with odd-and-even days of gasoline rationing and a stagnated economy.  People were embracing Hamburger Helper, and the government was exerting its influence in the private sector.

Times are hard but we’ll all survive,

I just got to learn to economize

I started my adult life in the mid-1980s, and with the freedom came responsibility.  I needed a way to track my expenses, and with my accounting background, I set up my first budget.  It was a primitive affair, in an old journal with lots of columns.  Eventually, I graduated to a computer-based spreadsheet.

Low budget sure keeps me on my toes,

I count every penny and I watch where it goes

I’ve used a weekly budget in an Excel spreadsheet since 1996, the year that I learned Excel.  Prior to that, it was in Lotus 1-2-3.  It’s just a simple tabulation, which lists my expenses by week.  I created it initially to avoid overdraft fees on my checking account.  Back when I started working, I had to watch my weekly cash flow.  Some things haven’t changed much.  I still watch it weekly, but just to stay on top of it.

Each year has it’s own tab, making it easy to compare expenses year-to-year.  To add a year, I just copy the current year’s worksheet.  I can do a pro-forma projection of next year’s expenses by factoring them off of this year’s actual expenses.

You can download a copy of the Excel file by clicking this link: Weekly Budget.xls

The file contains two tabs; a sample with some of the expenses filled in, and a blank tab for 2009.

I hope you find it helpful.  Here are some budget-related links:

Kevin at No Debt Plan talks about free cash flow and your debt,

PaidTwice asks what’s in your emergency fund?

2million is managing his big ticket item spending

Jaimie at Bargaineering wonders if you need an adult allowance.

Follow me on Twitter: CorpBarbarian

• Excel How-to: A Macro to Hide Blank Rows on a Spreadsheet Today, a coworker asked me how to hide a row on his Excel spreadsheet.  This was a fairly large spreadsheet, with about 150 rows and 30 columns.  After showing him, he started to hide every other row, which would be an incredible waste of time for someone in his salary......
• My Thanksgiving Ritual Photo by theogeo People develop different rituals to celebrate Thanksgiving.  Laurel and Hardy fans may tune in to March of the Wooden Soldiers, or watch the Macy's Parade.  A local radio station plays Alice's Restaurant in its entirety every year (I never tire from hearing the massacree again).  Some......
• Barbaric Book Review: Die Broke by Stephen M. Pollan, Part 2 This is Part 2 of my review of Die Broke.  You can read Part 1 by following this link: Barbaric Book Review: Die Broke by Stephen M. Pollan Step 2: Pay Cash The authors feel that there are three things that will keep you trapped: an unwillingness to change, and......

• Love and Marriage - Impress Yourselves, Not Your Friends. I met my wife 4 years ago this month through some mutual friends. She says it was fate, but I believe it was some sort of a freak accident. Whatever anyone believes, we met while standing next to a creepy clown blowing up balloons for some 5 year olds. But......
• Good Investment Management For Average People You can pay a penny on the dollar for good investment management or pay lots more for asset management like some rich folks do. Does the latter guarantee good investment returns? No way. Whether they call themselves investment management companies or asset management firms, you lay your money down and......
• Best of the Rest: Google Spreadsheet Edition I love automatic processes and saving time on mundane activities. Excel helps me do that lal the time with its fancy functions and awesome macros. This week while I automated the standings for the Alexa Challenge in Google Spreadsheets, I learned two amazing functions that are currently competing for my......