Tuesday, December 08, 2009
Thursday, November 05, 2009
Wednesday, October 21, 2009
Thursday, October 15, 2009
- Lists allow each user a way to group some or all of the people they follow by assigning them to a list.
- It also helps with discovery: When you go to a user's profile, you can see which lists they have created and follow relevant people. You can also see which lists someone belongs to and follow the others on that same list.
- Carefully consider how you want to structure your lists before you start to set them up.
- You can only create 20 lists.
- Each list cannot have more than 500 people.
- If you want to edit a list's name, go to: Lists You Follow, Click on List Name and on the right hand side towards the bottom is an "edit list" link. That will allow you to change the name of a list OR change it from public to private & vice versa.
- If you want to delete a list, go to: Lists You Follow, Click on List Name and on the right hand side towards the bottom is an "delete list" link.
Friday, September 11, 2009
- Don't include a personal url when sending someone an @ reply. It's perceived as spamming. By this I mean tacking on your domain name to a tweet that has nothing to do with your business.
- Don't tweet everyone new that follows you or that you follow. It's really annoying for your existing followers and you'll likely lose people.
- If you want to greet new followers, take a minute to look at their bio and tweets to use "something" to start a conversation with. Too much effort? Then why follow people unless you intend on building some kind of relationship or network with them?
- Create goodwill - if you share something someone else has tweeted, make sure to give attribution to it by using either RT or via. :) See my last tips post for more on retweeting.
- If you will be away from Twitter from an extended period - whether it is 12 hours, a day or a week, try and make sure your last tweet or two is representative of you. I've noticed huge fluctuations in how many new followers I get based on the tweets I leave up when I am not around.
Wednesday, September 09, 2009
Monday, September 07, 2009
Wednesday, August 12, 2009
- I make an effort to respond to every tweet,
- I tweet a lot,
- I haven't automated anything on Twitter (even followbacks I manually do now),
- and if you've had exchanges with me, you'll see I rarely am able to tweet in real time
- Although I'm typically "light" on Twitter, I do take business seriously. There are often full days where I am on overload with work which prevents me from spending any time on Twitter. Since I work on the Internet, I also like taking downtime entirely away from the computer. Both of these things mean it is easy for me to get behind in responding to tweets. I've been as much as 2 weeks behind in responses at some points!
- When I get far behind, I often have to resort to using search rather than Tweetdeck for responses. This means missing tweets from those tweeps who don't appear in search entirely.
- For productivity purposes, it makes more sense for me - on those days I am able to tweet - to spend 1 or 2 solid chunks of time responding to tweets. The issue here is that I don't want to flood the stream of followers with responses. Also, Twitter has implemented a time-out period where if you tweet too much in a given time, you are unable to tweet for an hour (and sometimes more).
- I've not been able to look as much at the streams of my friends because of time limitations.
- I love live interactions/exchanges with people but with getting behind all the time in responses, it's rare that I'm able to engage in "real-time" like I used to.
Friday, June 12, 2009
Friday, May 29, 2009
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.