Archive for February, 2012

How Regimented Should Your Life Be?

Personal finance

Some people claim life should be as spontaneous as possible—that to rip the spontaneity out of life is to also rip out the very essence of life.  Other people promote the regimented life.  They argue that humans function best when they are able to stick to a set schedule.

I have experience with both such lifestyles.  I have had an unstructured life (namely college) and I have been a creature of habit.  For me, the regimented life is where I most excel.

When I stick (or try to stick) to a schedule, I tend to get more done.  Sure I might miss out on some things, but I am more focused and better able to accomplish my goals.  Back in college, I went with the flow, and that tended to lead me nowhere but to dodging assignments.

That said, can you just box out every hour of your day?  At one point does a schedule become too rigid?  Of course life will interfere, as it always does.  So some might say: what’s the point?


For most of us, there are several schedules in our lives that will rarely change.  We will sleep each night and work each weekday.  We will eat three square meals a day, and maybe a snack at night.  We will have commutes, perhaps church on Sunday, and there will also be children’s schedules or spouse’s schedules to consider.

So, for the average person, how much time is there left either way?  Whether we structure those hours or not?

For me, I know that if I wake up early I can accomplish something before work.  Perhaps I’ll write a freelance blog post or read a book about my industry.  After work but before dinner is when I try to hit the Gym 2-4 times per week.  It’s from the time I finish dinner to the time I go to bed (along with the weekends) that are my true free time.  I think this is in line with the average person in a developed country.

So the questions becomes, how do you spend those hours.  For me, if I don’t plan something better, I’ll end up watching television or wasting time on the internet.  This is true even though I don’t have cable and have to watch any television through the internet.

If I sit down and write a list of goals or standards, however, then I might accomplish something more—even if it’s just reading for pleasure.  For me, I need to have a structure in place or I’ll skip the gym, not eat proper meals, and end up dawdling my nights away watching Downton Abby or Mad Men with my Wife.


I met a man once who worked as a cop (the night shift) and had his own solo law practice that he was developing during the day.  He said he would sleep on a cot at his office sometimes.  He did this for 10 years and then retired as a cop.  Now he earns a sick pension and has a busy law practice.  I’m not sure how he did it—particularly with a family, but he did.  And now he and his family are reaping the rewards.   When I asked him about it he said that he had goals—that he accomplished what he did because that’s how he wanted to use his free time.

What are your goals?  Is it to create a side business?  Learn more about a subject that interests you by reading or taking courses?   Furthering your education?  Look at the Financial Blogger, he has started/raised a family, worked successfully as a financial planner, started an always expanding side-business, written books, and furthered his education.  I’m sure he’s done all this because he’s very goal-oriented and is an expert in managing time.  What’s holding us back?

Now, there are moments in life that you have to cease.  I’m not arguing with that.  Sometimes it’s good for your soul to relax, kill time, or engage in the adult equivalent of “unstructured play.”  But for me at least, I need regimentation to be successful and meet my goals.

How about you?  I’d be interested to hear differing opinions on this subject.

Simple Introduction To Using Variables In An Excel Macro

Excel macros

I love getting questions as they often give me ideas for new excel tutorials, etc. Recently, I received a question for a seemingly simple problem. Using a variable in such a case should make it easy to understand and will also give more flexibility. Why? Let’s first take a look at the question:

“You are doing wonderful job at posting easy excel tutorials. Continue the great work! Can you please post a macro tutorial that copy data from one tab and paste into another tab? For instance, the macro copies column A & B from sheet1 and paste into sheet 2, then copies column A & C from sheet1 and paste it into sheet3, and so forth?

Can you please help with this? I have attached my excel spreadsheet, which includes the data and simply macro – that is not working.”

Here is the screenshot of the file:

Many would have the reflex to simply record a macro that does this exact task. That would work fine. However, what if the next time there are more rows? Or you would like to change a few things? Using an excel macro with a variable is a great way to get it done.

Step #1-Define the problem: I want the macro to go column by column starting at column B until there is an empty column. For each column, I want the macro to create a sheet, copy both the first column and that column to the new sheet. Let’s first take a look at my code:

Name of the macro:

Add the variable “I” that will be the column number. And also select the sheet named “Detail” where the data needs to be.

Then, I add a loop that will make it possible for the macro to go from column to column:

Then, for each column I want to add a sheet, and rename it to the correct name:

Finally, I want to paste the information on each tab so I add a few more lines

You can also see the result after running the macro and of course download the spreadsheet here.