Indulge yourself in the no-nonsense ramblings of Sharon Hayes-Tucci, Internet Entrepreneur.
Saturday, May 23, 2009
Twitter Tips
Friday, May 22, 2009
Excel problem
Column B contains a value relating to each data string
Column E contains if statement to compare one row against another like this:
=IF(A3614=A3613,"STOP","")
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.
Answer: =IF(E8="STOP",IF(B8<>"D","STOP",""),"")
Thanks to @mrrichardson for helping me out!
Wednesday, May 20, 2009
How to Get What You Want as an Entrepreneur
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. :)
Friday, May 15, 2009
FollowFriday Rockstars May 15, 2009
Each week I try and share with everyone some people on Twitter I think are worth following & getting to know better. I am doing it this way because I think that a simple 140 character recommendation isn't enough. Like many others that use Twitter, I believe in quality over quantity. I hope that some quality contacts come from this. That you personally can find one or more people from this list that you can also become friends with, network with & maybe get to know a little bit better.
HalSparks - For my first time, I'm actually including a real life celebrity - and with good reason. I've known of Hal Sparks since his stint on E!'s Talk Soup. Since then, he's been a host for a number of different entertainment shows, played one of the main characters on "Queer as Folk," been in a rock band (and is a surprisingly great singer), done stand-up comedy and is now pretty active on Twitter. I've been following Hal for a while now. I think he's setting a great example of how a "personality" can use Twitter effectively and can communicate with their fan base. He actually does interact with people, DM's with those he follows back and "gets" it.
TPR2 - Terry is a genuine sweetie. Although a serious business man (more on that in a bit), like me, he believes that the best reward we can get is by bringing a bit of sunshine to other people's days. He's taken it a step further by starting MyHugClub. Terry's a feel good person that you can't help but like. He hails from New Zealand and has homes in 3 cities. Terry owns 2 Real Estate Agencies, 2 Mortgage Broking Firms, 2 insurance agencies and 2 Financial Planning Practices. He also builds homes for people as well. Lately he's been making the transition to web geek. Terry's a doting dad to two boys who he loves to bits: Alex who is 6 months old and Bailey (featured in his avatar) is 4 years old. If you want to network with a sharp man that is compassionate, look no further.
Of course, you're more than welcome to follow me too :) I tweet a lot. I try to interact with followers to the extent I can. I spin tunes at Blip.fm. I share links I think are interesting. I'm a news junkie, voracious consumer of information - much of it useless but that which amuses me in some way.
For information on what #followfriday is, you can read here.
For information on why I do this weekly list, you can read here
Thursday, May 07, 2009
How to Share Music With Blip.fm
- Use the same user name that you use on Twitter. This will help you to avoid confusing people like me :)
- When I joined, it made suggestions of recommended DJ's to listen to (Blip's equivalent of "following"). I ended up removing them within a few days since I found their tastes to be very different from my own. I prefer adding DJ's as I come across them.
- To link to your Twitter account, you can go to "services". Although all songs you blip will be broadcast on blip.fm, you do have the ability to turn broadcasting to your Twitter stream on and off.
- You can add a profile pic/avatar like you can on Twitter. The size requirements are a bit larger than what they are on Twitter. A friend added a border to my Twitter avatar so that I could use the same one on Blip.
- Go through all of the tabs under "settings" so that you can decide whether to receive email notices, add your location, add your URL, etc.
- If you opt to receive email notices (like I do), I suggest setting up an email filter in your email program so that the emails will go to a folder. I have my blip emails go to a Gmail account with the following filter: from:(noreply@blip.fm) Skip Inbox, Apply label "* Blip".
- Your blip home page is located at http://blip.fm/username - for example mine is http://blip.fm/sharonhayes
- You can see in your stream either all blips (all DJ's) or just your favorites.
- To add someone as a favorite DJ, just click on the "listen to" button where their avatar is.
- There is a bookmark & share icon in each blip box to use across many different social networks.
- You can delete your own blips & remove blips from your playlist by clicked on the X (delete blip). I suggest doing this when you are aware that a song is no longer available.
- Song availability & quality varies. Please make sure to test a bit of a song (using preview or play button) before blipping. You'll also find that many songs end prematurely. Some songs are also incorrectly labelled. There are a lot of covers that are labelled as if they are the original song.
- There's a neat software tool called Blipster that makes blipping loads easier. It allows you to queue up a number of blips at one time. You can see length of songs and the file type so you'll have less chance of errors.
- You can embed blips into web pages.
- Blips can also be broadcast to FriendFeed & other services. You can set this up by going to Settings -->> Services.
Friday, May 01, 2009
FollowFriday Rockstars May 1, 2009
Each week I try and share with everyone some people on Twitter I think are worth following & getting to know better. I am doing it this way because I think that a simple 140 character recommendation isn't enough. Like many others that use Twitter, I believe in quality over quantity. I hope that some quality contacts come from this. That you personally can find one or more people from this list that you can also become friends with, network with & maybe get to know a little bit better.
JoshuaDenney - Of everyone I'm including today, I'm struggling the most on what to say about Josh. If you already follow him and/or know him at all, you'd understand why I say this. Josh has a great sense of humor, enjoys a wide variety of music and has a brilliant mind. He makes music, has worked as a talent agent and now does kick ass web design and strategy. He's a fellow #nightowl and currently lives in Nova Scotia. To me, Josh is simply Superman. :) Follow him & you'll see why I recommend him.
BradGal - Ingrid is not only simply stunning but a wonderfully sweet woman. She tweets a lot (much retweets of interesting things she comes across) but also a good deal of conversation too. Professionally, Ingrid is an electrical engineer. She lives in WV. She loves cats & dogs, computers, entertainment, high tech, iPhone and poker. Ingrid's also a huge Brad Garrett fan :)
RoseHwang - Rose is like a rainbow in Twitterville to me. I love people who are genuinely about giving and making others smile. This is Rose to a tee. Rose is in Taiwan but wherever you are in the world, she will succeed at making you smile with something she says. She's just really good people and any words cannot do justice to the joy she brings to others. Rose works in International trading, Graphic Design, Fashion Design, Events and she is also working on Social Enterprise.
Reddsmitty - Kim is someone I'm just getting to know myself. Most of our exchanges have come about so far because of music. She's a very friendly woman with a mahvelous sense of humor.Kim is a sales & marketing diva with 10+ years experience helping businesses grow through better understanding of their customers, their brand, and their locations. Kim has experience helping businesses market more effectively across every channel (including social media!). Mom to three boys 4 and under this road warrior keeps a very busy schedule and still manages to blip, blog, and tweet. I'm not sure how she manages to do it all and keep those of us that follow her smiling :)
There are many other people I wanted to include on this list. But there's always next #FollowFriday for that :)
Of course, you're more than welcome to follow me too :) I tweet a lot. I try to interact with followers to the extent I can. I spin tunes at Blip.fm. I share links I think are interesting. I'm a news junkie, voracious consumer of information - much of it useless but that which amuses me in some way.
For information on what #followfriday is, you can read here.
For information on why I do this weekly list, you can read here
Friday, April 17, 2009
FollowFriday Rockstars
Last week, I introduced you to a dozen amazing women. This week I want to share with you an assortment of men from around the globe & with different interests and tweeting styles. Each of these men is truly unique. Hopefully after you read what I have to say about each of them, you'll find yourself wanting to follow some or all of them yourself.
Minervity - For the ladies reading this, the first thing you'll notice is Richard's avatar is simply hot. ;) For many of you, that many not be enough reason to follow him. Richard is simply one extremely cool guy & one of the nicest people you can come across on Twitter. He's one of a handful of people I check their tweets daily. Richard tweets on a variety of subjects. One of my favorite recent ones was a nice article on how to work through exhaustion - something many of us could use help with from time to time. Richard has a varied creative background. He started out a songwriter/producer when he was 12 & signed to Sony Music (he still writes & produces music for artists such as American Idol, Swedish, German Idol & Lutricia McNeal). To date, Richard has sold about 10 million albums. Over the past decade, Richard has been working as a graphic/logo/icon designer. He also programs & works with 3D, flash and database development.
IAmKhayyam - Khayyam is one interesting dude. The tweeting side of him is just one aspect of this really super guy I am proud to call my friend. This guy is truly a renaissance man. His wisdom spans across pretty much everything and he's quite phenomenal at all of them. There's something about him that just makes you want to connect with him. He has an amazing energy that you want to be a part of and witness. You know - the old soul in a young body feel? That's him. A connoisseur of all things fine, it trickles nicely over to his design work. He's a print and identity designer that will get you noticed. But to call him just a designer is limiting. The side projects that he's working on will be definitely something to watch out for. He's an idea man. A thinker. Someone who will challenge you in ways you never thought of.
BuySellDomains - John is an incredible sweetie. Someone I had come across before Twitter but has gradually becoming a friend. He really makes an effort to support his friends - which is an admirable quality in anyone. John does web site design and is gradually making his mark in the domain industry. He's interested in health issues & natural stuff. He also is an animal lover and proudly owned by one little kitty.
Arodomus - Arod may seem like a strange choice to include if you look at his stream. (If you are easily offended you may want to avoid his stream.) He's one of the early people I connected with on Twitter. He's a normal guy with a heart of gold that shares his day to day life in his tweets as opposed to someone that interacts. He's just someone I find myself wanting to cheer on as he gets himself back in shape & celebrates life every day. If you follow him, you can't help but start to find yourself cheering him on.
AndySowards - Andy is a doting dad to 3 beautiful kids, a loving husband to his wife, a great friend that you can rely on and a simply mahvelous tweeter. He’s a freelance web designer and the selfless provider of the Web Development Nerdy Daily Links; a huge collection of links, tips, resources, tutorials and inspiration that he collects and shares with web designers the world over, every day. Andy produces extremely high quality custom Web 2.0 sites, Web Applications, e-Commerce Solutions & Wordpress blogs. He's done work for my businesses & clients - top notch job. One client was so thrilled, he even wrote a birthday song when Andy finished up a job on his birthday :)
BrianCray - Brian is a super dooper all around nice guy. Someone I'm just starting to get to know. Brian is a web ninja with a mix of marketing and web development knowledge that will karate chop straight through 5 thick cardboard boxes. He uses his knowledge to help businesses with everything web 2.0. He is the guy behind Nearbytweets.com and pxtoem.com. Brian is working on a book that is due out later this year - something I can't wait to read & tweet about myself!
TonyBlakeLive - Tony's tweets can be a little out there at times. He has a wicked sense of humor. Tony was a friend well before Twitter. We reconnected after I found him on Twitter. What can I say about Tony? He is one of the original Internet gurus while avoiding the guru type mentality. He combines his expertise with mentalism with some kick-ass marketing expertise to be top notch. Beneath the tough outer shell, Tony is a real sweet, stand-up guy who is loyal to his friends and always willing to go the extra distance.
There are many other people I wanted to include on this list. But there's always next #FollowFriday for that :)
Of course, you're more than welcome to follow me too :) I tweet a lot. I try to interact with followers to the extent I can. I spin tunes at Blip.fm. I share links I think are interesting. I'm a news junkie, voracious consumer of information - much of it useless but that which amuses me in some way.
For information on what #followfriday is, you can read here.
For information on why I do this weekly list, you can read here
Thursday, April 16, 2009
10 Things I Love About Twitter
Friday, April 10, 2009
FollowFriday Rockstars
Why I'm Changing How I Do #FollowFriday
Tuesday, March 31, 2009
Useful Links to Twitter Statistics
Today we have a guest post by Kirsty Wilson of http://www.interimbusiness.com.au/
You can also follow me on Twitter here.
Twitter is all about building connections with like-minded people and the focus is more about the individual rather than the business. However, it seems to be a fairly organic process that just naturally directs visitors to your website that are curious about the business behind the avatar and the personality.
In my short time tweeting I have discovered and utilise a number of links to review various statistics about my tweeting time; the ‘Followers’ I have attracted and the individuals I am ‘Following’. Here are some of my favourites and the information they provide:
http://tweetstats.com/ Displays your tweeting in a number of graph forms – a tweeting timeline can be viewed (since you commenced); your tweet density (days/time); Aggregate daily and hourly tweets; the top 10 Tweeters you reply to and the various interfaces you may use to Tweet.
http://twittercounter.com/ Displays much the same data as Tweetstats but also makes available the number of new Followers added in a day and the average growth per day. It will also make a prediction of how many Followers you will have the following day.
http://twitter.grader.com/ Displays where you are ranked out of all Twitter users world wide. (When writing this the total was 1,823,407). A ‘Tweet Cloud’ is also present. A ‘Tweet Cloud’ for those that do not know, is a list of dominant feature words you have used in your posts. It will also present you with a grade out of 100 and lists a number of ‘Suggested Folks to Follow’.
http://twitterholic.com/ Displays your ranking by Followers and then your ranking for your location. You can see where other local Tweeters fall within the rank.
http://mytweetcloud.com/ Displays all dominant #hashtags used during your posts. By adding a hashtag to any word or phrase, will allow real time tracking. For example some that I use frequently include #followfriday #travel #business #virtualassistant and you can search for other Tweeters that are tweeting the same topics. It’s a great way to find new Followers and make connections. Note: this site appears to be currently down.
http://twitter-friends.com/ Displays your relevant network and some stats about your tweeting behaviour compared to other Twitter users. It provides a list of the top 10 people you reply to and the top 10 people that reply to you. It clearly defines who is part of the ‘gang’!
http://www.twitalyzer.com/ Displays your activity in percentages over 5 categories, being - influence, signal, generosity, velocity, clout (How this is measured and the definition of each can be seen in detail visiting the above mentioned site)
http://twitterratio.com/ Displays the Twitter Ratio and is the ratio of your followers to friends (or people who you follow). It is measured with the TFF Ratio (Twitter Follower-Friend Ratio). The higher the ratio, the more Twitter heat you pack.
http://happytweets.com/ Displays a happiness score and a short description as to your happiness or maybe, unhappiness! Generally, a Tweeter with a score of 700 plus are the happiest Tweeters and the least happy, will display a score of 100 or below. My score for some time has hovered around 560 ‘Ridiculously Happy’!
Lastly, I wanted to share the fact that I analyse my own Website statistics and during the 3 months I have been involved with Twitter, the traffic to my website has almost doubled. The pages that were once viewed the most (Home & About Us) has had a huge shift to the ‘Services’ page being viewed significantly more than it ever has during the past 3.5 years and there has been a large increase in the number of visitors ‘saving to favourites’. “Social Media is truly awesome!”
About Kirsty
Kirsty Wilson, established Interim Business Solutions in 2005 when a need was recognised that small businesses and professionals were wishing to access virtual, temporary or ongoing administration support that allowed them to develop a close working relationship with the one service provider, without having to go down the path of employing some one. With more than 18 years experience across all areas of Business Administration, Kirsty believes she is extremely well equipped to deliver high level support offering a range of services. You can follow/thank Kirsty for this great list on Twitter here.
Friday, March 20, 2009
FollowFriday On Twitter
The aim of FollowFriday is to share with the Twitter community which tweeps you enjoy following. Of course, it can help you find new people to follow too. One of the biggest benefits for those that participate is that they can pick up a good number of new followers.
When I was newer to Twitter myself, I used it primarily as a way to find interesting people. I find that most people recommended by others are conversational in nature. Now that I have a sizable follower base myself, I participate to help my followers out.
The game was started by @micah as a way to suggest just a person or two. Most of those who participate tend to recommend more than just one or two.
How does this work?
Hashtags are used on Twitter to enable others to search on specific topics. You simply add "#" before the word/term without a space.
#followfriday is specifically what should be used in tweets relating to FollowFriday.
Note: If you are using TweetDeck, one of the recent updates will automatically include hashtags used in a tweet if you hit reply on a tweet where a hashtag such as #followfriday is used. For web access and for other Twitter apps, you would need to enter it manually.
How to find others
There are 2 ways you can find others recommended with #followfriday:
1. In the Twitter search box type #followfriday - this will display all results across Twitter. You can also click on this link:
http://search.twitter.com/search?q=%23followfriday
2. You can look at the tweets of those you already follow. I think this is a preferable route to go since you probably already have things in common with those you follow, so it's likelier that the recommendations will have at least something in common with you too.
How to recommend others
There are 2 common ways that Twitter users recommend others.
1. They will send a tweet recommending a single person. For example:
#followfriday @sharonhayes because she is really cool
Go ahead, copy and paste that into your tweet box ;)
2. They will send a tweet recommending a bunch of people at one time. For example:
#followfriday @sharonhayes @designmeme @andysowards @Minervity @styletime @iamkhayyam @unmarketing
Again, feel free to go ahead and copy & paste that into your tweet box ;)
Notes: Try and remember to use the proper hashtag - #followfriday - since that will help with the search aspect. Also remember to put the @ in front of the person's user name. Finally, remember NOT to start the tweet with @username but instead with #followfriday since only that person + people following that person will see it - defeating the purpose of making a recommendation.
How to find out who has suggested you
Since FollowFriday recommendations are rarely done as @replies, it's a good idea to take a peek to see if anyone has suggested you. If you are using TweetDeck, they should show up in your @replies column. If you use Tweetie, you can go to your profile page and there is a link to search from there. If you are using the web, you can put @yourname in the search box.
Remember to be courteous
In my opinion, it's a matter of courtesy to say thank you to those who have recommended you. After all if they are taking the time to suggest you to their own followers, it should get at least a nod.
How you handle this is at your discretion. I used to DM (direct message) people. Then I would tweet a list of those who have suggested me and include the #followfriday hashtag. Something like this:
Thanks for the #followfriday @designmeme @andysowards @Minervity @styletime @iamkhayyam
Resources
There are some sites that have sprung up that look at #followfriday recommendations.
http://nearbytweets.com/search/followfriday - is a nice tool that will show you people suggested by others that are geographically near you.
http://www.topfollowfriday.com - provides daily ongoing counts for all users suggested by someone for the first time. It does not count duplicate, it does not count #followfriday lists that start with @user, it does not count tweets containing RT.
http://www.boxuk.com/followfriday/ - updated every 15 minutes on Friday. Counts duplicates from what I can see but does not include suggestions that contain RT (retweet).
http://www.tweeplerank.com/ - a ranking service that shows #followfriday #mrtweet recommends and #tweepletuesday. Like Topfollowfriday.com, it does not count recommendations including RT and if it starts with @username, it seems that the first person is not counted. Duplicates do not count.
http://www.followfridays.com - provides live #followfriday feed
Note: these sites only track where #followfriday tag is specifically included.
Hope this helps you! Please feel to follow me too :)
P.S. The tweets provided above were for simply for the purpose of providing an example. :)
Wednesday, March 04, 2009
Twitter Gaming & How It's Costing Everyone
I am getting sick and tired of the gaming for numbers I am seeing on Twitter. Before it was people that would follow as many as Twitter limits allow...
Twitter allows you to follow up to 2000 people. At that point, you can only follow 10% more than are following you.
... that was one thing. It didn't put a lot of "stress" on the system and wasn't a huge manipulation tactic.
The more recent trend is one that I personally find disturbing - and I'm not the only one. I'll explain what the trend is and then share why I think it is costing everyone.
Some people have figured out an "easy" way to game the system. Basically it is to bulk unfollow existing followers and then bulk follow new ones. Presumably the people doing this believe that a couple of things will happen: a. new people they follow will be "impressed" and a good percentage will follow back and b. that the people they unfollow won't notice they have been unfollowed.
Why is this a bad thing? Let me count the ways...
1. I have no idea how many people are doing this across Twitter. However, between myself and a few others I've communicated with who have noticed the same shenanigans, we've found at least 30 reasonably high profile people (high profile meaning a considerable follower base). But let's say that there are 500 people doing this and are unfollowing/refollowing in batch an average of 5,000 followers at a time. Yes, Twitter can handle a lot but how much of a drain is this putting on system resources? Keep in mind, it's not just the resources needed for the follows/unfollows but the follow emails that go out, people going to look at follower pages, and so on.
2. It's misleading to Twitter users. You look at one of these profiles and say to yourself - oh they follow back every one that follows them. For the most part, people engaging in this behavior try to keep the numbers balanced. There are also some that have been gaming Twitter who - after reaching a certain magical threshold number of followers - have made a big stink about how hard it was to keep up with all the people they were following so they were no longer going to follow everyone. The other aspect of this is that it gives false "social proof" of these Twitter users when looking at their follower count alone.
3. At least a few of these people are using their Twitter high follower counts to add credibility to whatever it is that they do. I don't know how you feel, but to me this is tantamount to faking testimonials.
4. Twitter is a fantastic networking tool and a great way to meet people you may not have otherwise. It's a superb way to stay in touch with others. But one thing that is crucial to Twitter's continued growth is the authenticity of it's users. Gaming the system in this way diminishes authenticity.
5. People are getting hurt by the unfollowing. I've had a few people tell me they were upset that so and so unfollowed them - especially since they had had communication etc. I've had it happen to me as well. It's hard not to take it personally in some cases.
6. Then let's not forget the time being wasted with this. Let's say the numbers above hold up. That would be 2,500,000 bulk follows a day. How long does it take to check out a new follower? 30 seconds? That works out to 20,833 hours a day being lost to gaming. Let's lowball the productivity of each person impacted to $20 per hour. Over $400,000 a day. Still think it's not an issue?What isn't surprising to me is that these people have been smart enough to find out some way to game the system yet they don't realize that literally everything they do on Twitter is tracked somewhere or is trackable. You can get an instant snapshot through various sites like FriendorFollow.com to see who is gaming. You can backup someone's following/follower list and compare it on a day to day basis. There are sites like Twitterholic.com that show trends of how many followers/following any individual has had.
Here are some takeaways you can derive from this:
1. Don't hold much credence in a Twitter user's follower count. You may be shocked to learn who some of the people engaging in this behavior are.
2. Follower count really doesn't matter. Some of the sharpest people I know on Twitter have fewer than 1,000 followers.
3. If you are gaming the system now or are considering doing it & you are in business for the long haul, consider the potential damage to your reputation that can be done if/when you get called out on it. People are getting called out now. Your actions are being recorded. Is it really worth sacrificing your reputation in the long haul?
If I sound bitter in any way about this, I'm not and have no reason to be. I have close to 12,000 followers at the time of writing this. All but 30-40 were gained in just over 2 months time by using Twitter in an ethical and responsible manner. I tweet on a variety of subjects, I engage in conversations, I retweet, I try and help others when I see I can and I share worthwhile/ entertaining links I come across. I make an attempt to answer DM's. I have a very busy life yet I can handle this without resorting to tactics. I've made several dozen incredible contacts - both of a business and personal nature. The time I've spent on Twitter has been more than worthwhile when I consider just the new business I've gained. I know that I'm building a solid network with what I'm doing.
Follow me on Twitter