Saturday, May 23, 2009
Friday, May 22, 2009
Column B contains a value relating to each data string
Column E contains if statement to compare one row against another like this:
What I need to do is in column E have a formula that returns another
STOP *if* column E contains STOP and column B is not equal to D
My brain is so dead - this should be simple and I'm just not getting it.
I realize there is deduping in Excel 2007 but the client wants the
data in this specific format.
Thanks to @mrrichardson for helping me out!
Wednesday, May 20, 2009
Over the past 6 months, I’ve been shifting my priorities to working with small business owners. One of the first things I’ll discuss with them is where they are now versus where they want to be. This helps us establish a path for them to take – what they need to do in order to grow their business to the desired level. Almost without exception, I’ve come to one startling conclusion:
Most small business owners do not have a business model that can help them reach their goals!
First, let me start off by sharing the most common goals most people cited:
· More free time during the regular work week and weekends off
· More time off from work entirely
· Less work-related travel and more personal/family travel
· More time and money to indulge in recreational activities
· Specific income goals – usually in the $150,000 to $250,000 range
· Own a new home, mortgage-free
Basically, the most important goals for the bulk of these people were either related to having more free time or having more money. Sounds reasonable, doesn’t it? It is until I started to look at the plan – or lack of plan – these business owners had in order to reach their goals.
I’ll share with you some details on a client I am working with. Dan is a fairly solid programmer. He has a full-time job and does between 10 and 20 hours of work each week freelance. His rate is $45 per hour. He has around 3 months living expenses set aside and is ready to take the leap to going on his own. He and his wife have 2 young children. His wife is returning to teaching this fall and will be earning just under $30,000 a year. Dan wants to be able to take summers off starting in 2010 to spend with his family. He would need to earn an estimated $110,000 in 2010 to reach his family’s financial goals. Since he’s been freelancing along with his full-time job for the past 3 years now, he wants to be able to have weekends off to spend time with the family. Before we spent some time together, Dan had planned on only increasing his hourly rate to $50.
Let’s say that Dan ended up increasing his rate instead to $75 per hour. That would mean he’d need to work about 1467 billable hours per year. If Dan works 40 weeks per year that would mean almost 37 hours a week of billable time. This doesn’t take into account time between jobs (it’s rare a freelancer is booked solid), other work that isn’t billable, bookkeeping, invoicing, etc – all of which Dan planned to do on his own. Oh and where will all these clients come from? Who will handle the pre-sales, sales and quoting? When we had a look at this, Dan certainly felt discouraged. But then it got worse when I pointed out a few things to him:
What if he gets the flu and is unable to work for a couple of weeks? What if one or both of the children are off school due to illness? These are things that do happen.
His game plan didn’t take into account saving for his children’s college fund. With his children being 9 and 11 years of age, it was something he needed to start planning for soon.
Although his wife’s financial contribution was nominal under their current game plan, one big thing she was bringing to the table was health care benefits for the family. What if her job didn’t go through or if she lost it due to lack of seniority?
Did Dan want to continue coding for the rest of his life – or even the foreseeable future? The problem with any kind of service-based business like this is that you are trading time for money. When you don’t work, you cease to continue earning money.
I think at this point Dan started to feel sick. It became blatantly clear that his business model sucked. His goals are more important to him than how he gets there.
Fortunately all was not lost. We were able to structure a new business model for him that should allow him to easily reach all of his goals in 2010 and over time allow him to continue to see increases in his income. Hopefully he’ll find himself with more free time too.
Dan’s original approach to starting a business is pretty common amongst most service providers and professionals. Trading time for money is a linear model. It’s simply not an entrepreneurial one. With rare exceptions, there are always ceilings to potential earnings.
In the next instalment I’ll be looking at other types of business models.
P.S. Name and personal information was modified to protect the client.
Over the past 20 years, I have had the chance to have a glimpse at the inner workings of literally tens of thousands of businesses – ranging from one-person shows to many of the world’s largest companies. I’ve also built several successful businesses of my own – both online and offline. I don’t have all of the answers to what makes one business succeed while another fails. However, I do believe that the insight I have goes beyond what you could find in any single book, course or even a full business school program.
In June, I’ll be rolling out a coaching program geared to small business owners and start-ups. This will be the first time I’ve done something like this. I’m not doing it for the money. I can make money more easily doing other things. The last thing I want at this stage of my life is to have more work. I am just feeling frustrated with the preponderance of misinformation when it comes to doing business online. I know there are a lot of good, decent people out there that genuinely want to create a business of substance. I feel confident I can provide the keys to unlock the magic kingdom for these people. The focus will be on becoming a true entrepreneur as opposed to being merely a self-employed technician or professional.
Before the program is launched, I’ll be sharing some general thoughts via my blog and eventually through the program’s website. This will give people who may be interested in the program a better idea of what they can expect if they choose to participate. Unlike the actual program, the content won't be provided in any particular order; i.e. you can expect me to jump around a lot. :)