10/3/12

How to Make Huge Decisions

The power of a group is great when you need to get things done. When you need to make a huge decision, not so much.
 
Opinions. Feedback. Advice. Guidance. Counsel.

Consensus!

Yuck.

Granted, it's natural to look for input when we need to make decisions. And if asking for advice doesn't come naturally, the business world trains us to actively solicit opinions, bounce ideas off other people, and run our ideas up proverbial flagpoles in order to harness the amazing brain power of the many to make awesomely incredible decisions.

Sometimes that approach works... but sometimes it's the worst approach to take when you need to make a huge decision.

The main power wielded by group thinking is the power of the middle ground. Groups grind away the edges and the sharp corners. After all that input and feedback and devil's advocacy what remains is safe, secure... and similar.

If you want to be different--if you want to achieve "different"--the only opinion that truly matters is yours. Group decisions give you an out. Other people can be at least partly responsible. Other people can be wrong.

When you make the decision, everything rests on you: Your vision, your passion, your motivation, and your sense of responsibility.

So you'll try harder if only to prove others wrong. You'll fight through every obstacle and roadblock, if only to prove yourself right.

You will do everything possible to make it happen.

So when you need to make a huge decision, this is how to get input and opinions--while still making sure you, and only you, make the final decision:

1. Take a "crazy" idea.
Choose something you believe in late at night but in the cold light of day hesitate to try.
Or choose an idea you've been told will never work.

2. Then seek data, not opinions.
Input from other people is useful, but only if you see that input as data points and not opinions.
Opinions carry extra weight, like the weight of credibility (he's really smart, so I'm sure he's right), the weight of guilt (if it turns out he's right, I'll never hear the end of it), or the weight of safety (yeah, there probably is a reason no one has tried this before).

"I think you're crazy to try to open a store in that market," is an opinion. It may be accurate, may not be accurate; it's still just an opinion.

If you value the person's opinion, ask them how he or she arrived at that opinion. Always look for the data behind the conclusion.

Otherwise ignore everything that isn't data--warnings, cautionary tales, and well-intentioned but poorly founded advice--since you already know all those things anyway.

3. Evaluate the data.
Data analysis is easy when opinions and "weight" are stripped away.

Make a pros and cons list. Apply sensitivities. Be objective. Be smart. You know how.

4. Decide how strongly you believe...
Analysis will only take you so far, since critical thinking tends to steer decisions towards conventional wisdom.

An innovative product only looks like a sure thing in hindsight. The emergence of a new industry only seems inevitable after it has emerged.

At some point, someone believed when others didn't.

5. ...then decide if that someone is you.
If you believe when others don't--and a major portion of that belief is based on analysis, not gut feel--then go for it. Start a business. Sell a business. Enter a new market. Take a chance on a new product.

Go for it, knowing you'll go harder and faster and longer because the only person that really matters made the decision.

You.

 http://www.inc.com/jeff-haden/how-to-make-huge-decisions.html

9 Things You Wish Job Candidates Knew

Sure, you'll consider their qualifications. But admit it: This is what you're really looking for during interviews.

Job candidates say a lot during an interview. As the interviewer, so do you.
But there's a lot you wish you could say to job candidates well before the interview ever takes place:

1. I want you to be likable.
Obvious, sure, but also critical. I want to work with people I like and who like me.
So I want you to smile. I want you to make eye contact, sit forward in your chair, and be enthusiastic. The employer-employee relationship truly is a relationship--and that relationship starts with the interview (if not before).

A candidate who makes a great first impression and sparks a real connection instantly becomes a big fish in a very small short-list pond.

You may have solid qualifications, but if I don't think I'll enjoy working with you, I'm probably not going to hire you.

Life is too short.

2. I'm taken aback when you say you want the job right away.
Oh, I do want you to want the job--but not before you really know what the job entails. I may need you to work 60-hour weeks, or travel 80% of the time, or report to someone with less experience than you... so hang in there.

No matter how much research you've done, you can't know you want the job until you know everything possible about the job.

3. I want you to stand out....
A sad truth of interviewing is that later I often don't recall, unless I refer to my notes, a significant amount about some of the candidates. (Unfair? Sure. Reality? Absolutely.)

The more people I interview for a job and the more spread out those interviews, the more likely I am to remember a candidate by impressions rather than by a long list of facts.

So when I meet with staff to discuss potential candidates I might initially refer to someone as, "the guy with the handcuff-ready stainless steel briefcase," or "the woman who does triathlons," or "the guy who grew up in Romania."

In short, I may remember you by "hooks"--whether flattering or unflattering--so use that to your advantage. Your hook could be your clothing, or an outside interest, or an unusual fact about your upbringing or career.
Better yet your hook could be the project you pulled off in half the expected time, or the huge sale you made.

Instead of letting me choose, give me one or two notable ways to remember you.

4. ...But not for being negative.
There's no way I can remember everything you say. But I will remember sound bites, especially negative ones.

Some candidates complain, without prompting, about their current employer, their coworkers, their customers.

So if, for example, you hate being micro-managed, instead say you're eager to earn more responsibility and authority. I get there are reasons you want a new job but I want to hear why you want my job instead of why you're desperate to to escape your old job.

And keep in mind I'm well aware our interview is like a first date. I know I'm getting the best possible version of "you." So if you whine and complain and grumble now... I know you'll be a total downer to be around in a few months.

5. I want you to ask lots of questions about what really matters to you...
I need to know whether I should hire you, but just as importantly I need you to make sure my job is a good fit for you.

So I want you to ask lots of questions: What I expect you to accomplish early on, what attributes make our top performers so outstanding, what you can do to truly drive results, how you'll be evaluated--all the things that matter to you and to me and my business.

You know what makes work meaningful and enjoyable to you. I don't. There's no other way to really know whether you want the job unless you ask questions.

6. ...But only if the majority of those questions relate to work.
I know you want a positive work-life balance. Still, save all those questions about vacation sign-up policies and whether it's okay to take an extra half hour at lunch every day if you also stay a half hour late and whether I've considered setting up an in-house childcare facility because that would be really awesome for you and your family.

First let's find out if you're the right person for the job, and whether the tasks, responsibilities, duties, etc. are right for you.

Then we can talk about the rest.

7. I love when you bring a "project."
I expect you to do a little research about my company. That's not impressive; that's a given.

To really impress me, tell me how you will hit the ground running and contribute right away--the bigger the impact the better. If you bring a specific skill, show how I can leverage that skill immediately.

Remember how I see it: I have to pay you starting day one, so I'd love to see an immediate return starting day one.

8. I want you to ask for the job... and I want to know why.
By the end of the interview you should have a good sense of whether you want the job. If you need more information, say so. Let's figure out how to get you what you need to make a decision.

If you don't need more information, do what great salespeople do and ask for the job. I'll like the fact you asked. I want you to really want the job--but I also want to know why you want the job.

So tell me why: You thrive in an unsupervised role, or you love working with multiple teams, or you like frequent travel. Ask me for the job and prove to me, objectively, that it's a great fit for you.

9. I want you to follow up... especially if it's genuine.
Every interviewer appreciates a brief follow-up note. If nothing else, saying you enjoyed meeting me and are happy to answer any other questions, is nice.

But "nice" may not separate you from the pack.

What I really like is when you follow up based on something we discussed. Maybe we talked about data collection techniques, so you send me information about a set of tools you strongly recommend. Maybe we talked about quality, so you send me a process checklist you developed that I could adapt to use in my company.

Or maybe we both like cycling, so you send me a photo of you on your bike in front of the sign at the top of the Col du Tourmalet (and I'm totally jealous).

The more closely you listened during the interview, the easier it is to think of ways to follow up in a natural and unforced way.

Remember, we're starting a relationship--and even the most professional of relationships are based on genuine interactions.

http://www.inc.com/jeff-haden/9-things-you-wish-you-could-say-to-job-candidates.html

Multiple access points for the same SSID? (Multi-AP Roaming Network Background)


I need to upgrade my existing wireless infrastructure and this time I want 2 access points to cover my house, since I get blind spots no matter what with a single AP, I have physical cabling to my central network available for both access points.
But I would really like these two to interoperate seamlessly as a single SSID. How do I do this and what are the features the new AP's I'm buying need to support? (Product recommendations are welcome.)

Multi-AP Roaming Network Background

There's no magic to making multiple-AP (roaming) 802.11 networks work. Wireless clients just assume that all APs with the same SSID are configured similarly and are all just different points of access to the same underlying wired network. A client will scan all channels looking for APs publishing the SSID it wants, and will pick whichever one suits it needs best (usually that means whichever one shows the highest signal strength).
Once on the network, clients stay with the same AP as long as it's meeting the client's needs (i.e. as long as it's signal strength is above a "good enough" threshold). If the client later thinks it could be better off with another AP on that network, it'll do periodic scans of all channels looking for other APs publishing that SSID. If a scan turns up a candidate AP that's enough better than the AP it's currently on, it'll automatically roam to the other AP, usually without so much as a missed frame.
Assuming both APs are configured similarly and are connected to the same underlying network, roaming is seamless and invisible to the user (except nerds like me who run tools to watch for these things). Roaming events are invisible to applications using the network, although some low-level parts of the network stack might be notified of the event, so that, for example, your DHCP client can double-check that this new AP really is connected to the same network, so it can be sure your DHCP lease is still valid on this network.
Some other users' Answers and Comments on this question erroneously suggested that wireless protocols or features like wireless relay or WDS might be needed for roaming, but this is absolutely incorrect. Those features are just ways to replace a wired Ethernet backhaul with a wireless one.
For the sake of completeness, I should mention that there is a set of technologies, some proprietary, some standardized in IEEE 802.11F, known generally as Inter-Access Point Protocol. IAPP is a method by which generally enterprise-class APs can communicate with each other over the backhaul to optimize client roaming. But that's just an optimization, not a prerequisite for roaming. Roaming works "well enough" on networks both small and large without any IAPP going on.

Configuration Suggestions

Give both APs the same network name (SSID), the same security type (WPA2-PSK recommended), and the same wireless security passphrase. Many clients assume that these kinds of settings will be the same across all APs with the same SSID.
Since you already have the cabling in place, use wired Ethernet as your backhaul. This saves your wireless bandwidth for your portable/mobile devices that actually need it, instead of wasting in on stationary devices like APs that could reasonably be cabled up.
If you have another device on the network, such as a broadband home gateway, providing NAT and DHCP service, then put both APs in bridge mode (turn off NAT and DHCP service). You generally only want one box on your network acting as a NAT gateway or serving DHCP. If you don't already have another device on your network doing NAT and DHCP, and you need those services, then you can have one of your APs do it. Have the more "upstream" AP (the one that's closer, topologically, to your broadband modem) do NAT and DHCP, and make sure that the wired Ethernet connection to the other AP comes from the first AP's LAN port. Also make sure that the "downstream" AP is in bridge mode. I call this out because I've seen people make the mistake of leaving NAT and DHCP enabled on both their APs, and I've seen clients that aren't smart enough to realize that, say, the 192.168.1.x/24 network they're on now is not the same 192.168.1.x/24 network they were on a moment ago in the other room. I've also seen users get confused in this situation where two laptops in the same house had 192.168.1.x addresses, but couldn't ping each other because they really on two separate IP networks behind two separate NATs.
Channel is one key setting you do want to vary from AP to AP in a roaming (multiple AP) 802.11 network. To maximize bandwidth, leave your APs to automatically select the channel to use, or you can manually pick different, non-overlapping, and hopefully unoccupied channels to use. You don't want transmissions to/from one AP to compete for bandwidth with transmissions to/from the other AP.

Additional Considerations

The rest of this answer is just a bunch of general "how to maximize your home 802.11 network bandwidth" tips, not specific to your question of two APs with the same SSID.

Consider taking this opportunity to fully modernize

If you're already buying a new AP and taking the time to reconfigure things, I'd recommend using this opportunity to replace your existing AP as well, by buying two of the latest APs that support simultaneous dual-band 802.11n technology. That way you can support both the 2.4GHz band for older clients that are 2.4GHz only, as well as the less busy 5GHz band for more bandwidth. It's becoming a "best practice" to set your 2.4GHz 802.11n radio to 20MHz (HT20) channels so that it leaves some of the band free for things like Bluetooth to use. This limits your 802.11n transmission rates in 2.4GHz to ~130mbps instead of 300mbps, but allows other non-802.11 2.4GHz devices to still work okay. In 5GHz, where there are many more channels available and they're all generally much less busy, you're encouraged to use 40MHz (HT40) channels to get maximum throughput.
I know that Apple's latest AirPort Extreme and Time Capsule (but not AirPort Express) are simultaneous dual-band 802.11n, and they also support 3-stream (a.k.a. "3x3") 802.11n, for transmission rates up to 450mbps once you get if you have 3-stream clients that can do it (Apple's clients are currently still on 2x2, so 300mbps max Apple's March 2011 "Thunderbolt" renewal of the MacBook Pro line quietly added 3x3 radios).

If you're stuck with older single-band-at-a-time APs

If you don't need to support any older 2.4GHz-only devices, use the 5GHz band since it is generally less busy, and you can use HT40 without starving Bluetooth and other uses.
If you're stuck supporting 2.4GHz-only devices with single-band-at-a-time APs, be careful of your channel selection. In the 2.4GHz band, the channels overlap to a great degree. However, channels 1, 6, and 11 don't overlap at all, so those are good choices to pick manually. You could use a Wi-Fi network scanner like NetStumbler, iStumbler, many "war driving" tools, etc. to see which channels are in use by other APs visible from where you are. If you suspect you have non-802.11 2.4GHz interferers in your area, such as Bluetooth, microwave ovens, and many (but not all) cordless phones, baby monitors, wireless webcams, and wireless room-to-room A/V senders, you could go all-out and get a spectrum analyzer like a Metageek Wi-Spy to find which channels are the least noisy where you are.

http://superuser.com/questions/122441/multiple-access-points-for-the-same-ssid

10/2/12

3 Employees You Need To Fire. Now

You know the saying: Hire slow, fire fast. Here are the people you need to get rid of, right now.

There’s no more challenging job than being the person who has to fire people. Everyone else gets to talk about what a tight-knit, stick-together group the company is (just like a “family” of friends), but you’re the one who has to deliver the bad news over and over again. It’s not easy or always popular to be the boss, but then good leadership isn’t a popularity contest. If you were unpopular in high school, you’re already one step ahead of the game.

But the fact is, your company is only as good as its weakest employee. Here are the folks you need to fire - sooner rather than later.

No effort, no heart Sometimes it’s a breeze. We try to immediately fire any employee who doesn’t try or doesn’t care. These are the cardinal sins in a start-up, so there isn’t much angst in letting these folks go. Then the job gets harder.

All effort, no results The next tier of troublesome employees are those who try hard but just cannot do the job. They are totally sincere, but incapable (or no longer capable) of doing the job that needs to get done. There are good people who are perfectly able to do a job poorly for a very long time before anyone has the time, interest, or guts to ask the hard questions about results rather than effort. These people need to go too, but you need to be fair and firm with them. Do them a real favor and tell them the truth.

Poor fit Then there are the employees who are basically hard-working and dedicated, but who (for better or worse) can’t fit into the corporate culture.  Every business that I’ve been involved with has ultimately been about hard work mixed with a healthy dose of paranoia. We had lots of ways to reflect this ethic and plenty of signs all over the place. “Hard work conquers everything.” “Effort can trump ability.” “Just because you're paranoid doesn't mean that someone's not out to get you.”  And so on. And almost everyone we hired got the message and drank the Kool-Aid. Even the people who just wanted a “job” pretty much worked their butts off.

But every so often, we’d hire someone who was just too healthy and well-adjusted to succeed among our tribe of crazies. We used to say that a relaxed man is not necessarily a better man. In one business, our internal motto was “let our sickness work for you.” It turned out that it was important to let the other people see you sweat even the smallest details. That way, they knew you cared. If you weren’t just a little bit crazy about the work and the business, you were slightly suspect or worse.

I remember one former employee who wrote me a long letter asking for a more complete explanation of why he didn’t succeed with us. Here is part of what I wrote:

Our company is [on] a very fast track, run by a bunch of workaholic perfectionists. We all believe that that’s what it takes to win against pretty fierce odds. And this is simply not the right place for everyone - especially people who want to have a family, outside interests and a normal life. I think it’s very likely that you’re simply too nice and too well-adjusted to work with the crazies around here and that’s shame on us - not you. But it’s the way things are. We wish you all the best.

Ultimately, all of these situations come down to a basic choice. You can make one person miserable when they lose their job, or you can end up with a crappy company where everyone’s miserable because you don’t have the guts to do the right things for the business. Once you start to carry people along who aren’t performing, you take a tremendous double hit. Yes, you pay the price for the poor performer’s activities, but that’s nothing compared to the real harm. As soon as you fail to consistently fire non-performers, you start to lose your best people. That’s what kills the company.

http://www.inc.com/howard-tullman/three-employees-you-need-to-fire-now.html

10/1/12

Sending mail from Excel with CDO

What is CDO doing

The example code is using CDOSYS (CDO for Windows 2000).
It does not depend on MAPI or CDO and hence is dialog free
and does not use your mail program to send email.


Briefly to explain, this code builds the message and drops it
in the pickup directory, and SMTP service running on the machine
picks it up and send it out to the internet.


Why using CDO code instead of Outlook automation or SendMail in VBA.

1: It doesn't matter what Mail program you are using (It only use the SMTP server).
2: It doesn't matter what Office version you are using (97…2007)
3: You can send a range/sheet in the body of the mail (some mail programs can’t do this)
4: You can send any file you like (Word, PDF, PowerPoint, TXT files,….)
5: No Security warnings anymore, really great if you are sending a lot of mail in a loop.


Read this!!!

This code will not work in Win 98 and ME.
You must be connected to the internet when you run a example.

It is possible that you get a Send error when you use one of the examples.
AFAIK : This will happen if you haven't setup an account in Outlook Express or Windows Mail.
In that case the system doesn't know the name of your SMTP server.
If this happens you can use the commented green lines in each example.
Don't forget to fill in the SMTP server name in each code sample where
it says "Fill in your SMTP server here"

When you also get the Authentication Required Error you can add this three lines.
.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "username"
.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password"


Don't remove the TextBody line in the code. If you do you can't open the attachment (bug in CDO).
If you don't want to have text in the body use this then .TextBody = ""

Note: It is always possible that your firewall block the code (Check your firewall settings)


Can you use CDO on your machine?

Let's try a basic example first.

The code below will send four text lines in the body of the mail to the person in this line
.To = "ron@debruin.nl"

Change ron@debruin.nl to your own mail address before you test the code.
If you read the information above you know that if you have a account in Outlook Express or
Windows Mail you can Run the code below after changing the mail address.
But if you not have a account in Outlook Express or Windows Mail you also need the commented
green lines in the code. Remove every ' before every green line and fill in the name of your SMTP server
where it says "Fill in your SMTP server here"

1) Open a new workbook
2) Alt F11 (to open the VBA editor)
3) Insert>Module
4) Paste the code in this module
5) Make your changes
6) Alt q to go back to Excel

When you use Alt F8 you can select the macro and press Run.
Now wait a moment and see if you receive the mail in your inbox.
Sub CDO_Mail_Small_Text()
    Dim iMsg As Object
    Dim iConf As Object
    Dim strbody As String
    '    Dim Flds As Variant

    Set iMsg = CreateObject("CDO.Message")
    Set iConf = CreateObject("CDO.Configuration")

    '    iConf.Load -1    ' CDO Source Defaults
    '    Set Flds = iConf.Fields
    '    With Flds
    '        .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
    '        .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") _
    '                       = "Fill in your SMTP server here"
    '        .Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
    '        .Update
    '    End With

    strbody = "Hi there" & vbNewLine & vbNewLine & _
              "This is line 1" & vbNewLine & _
              "This is line 2" & vbNewLine & _
              "This is line 3" & vbNewLine & _
              "This is line 4"

    With iMsg
        Set .Configuration = iConf
        .To = "ron@debruin.nl"
        .CC = ""
        .BCC = ""
        .From = """Ron"" "
        .Subject = "New figures"
        .TextBody = strbody
        .Send
    End With

End Sub

Note: If you get this error : The transport failed to connect to the server
then try to change the SMTP port from 25 to 465



Use the GMail SMTP server from Google.
http://gmail.google.com

You can find the code in the workbook with examples that you can download below.
There is more information about the code in the workbook.
Note: You must have a Gmail account to try this example.




Download workbook with more examples

You can download a example workbook with eighth examples.
Download Example workbook with all the code

Attachment examples:
Module file1 = Workbook
Module file2 = One worksheet or more
Module file3 = Every sheet with a mail address in cell A1

Body examples:
Module body1 = Selection/Range or whole worksheet
Module body2 = Personalized Mail
Module body3 = Every sheet with a mail address in cell A1
Module body4 = Small text and text from a txt file

Note: the body examples in the workbook are using the function RangetoHTML in
the "bodyfunction" module of the workbook.

Gmail example:
Module gmail = Use the smtp.gmail.com server from Gmail to send mail



Tips and links


CDO sheet template

Check out this sheet template if you want to send every sheet to a different person.
Or want to send one or more sheets to one or more recipient.
http://www.rondebruin.nl/mail/templates.htm



Set importance/priority and request read receipt

For importance/priority and read receipt you can add this in the With iMsg part of the macro before .Send

' Set importance or Priority to high
.Fields("urn:schemas:httpmail:importance") = 2
.Fields("urn:schemas:mailheader:X-Priority") = 1

' Request read receipt
.Fields("urn:schemas:mailheader:return-receipt-to") = "ron@debruin.nl"
.Fields("urn:schemas:mailheader:disposition-notification-to") = "ron@debruin.nl"

' Update fields
.Fields.Update


Changing the To line

If you want to mail to all E-mail addresses in a range then use this code
instead of .To = "ron@debruin.nl"

The example below will use the cells from sheets("Sheet1") in ThisWorkbook (workbook with the code)
It is possible that you must use ActiveWorkbook or something else in your code to use it.
    Dim cell As Range
    Dim strto As String
    On Error Resume Next
    For Each cell In ThisWorkbook.Sheets("Sheet1") _
        .Range("A1:A10").Cells.SpecialCells(xlCellTypeConstants)
        If cell.Value Like "?*@?*.?*" Then
            strto = strto & cell.Value & ";"
        End If
    Next cell
    On Error GoTo 0
    If Len(strto) > 0 Then strto = Left(strto, Len(strto) - 1)

Change the To line to .To = strto


Or to more people
.To = "Jon@something.com;ron@something.com"

Or you can use a address in a cell like this
.To = Sheets("Sheet1").Range("C1").Value



Change the Body line


Plain text :

Note: see also the example in the workbook to send all text from a txt file (Module body4)

If you want to add more text to the body then you can use the code below.
Instead of .TextBody = "This is the body text" use .TextBody = strbody then.

Dim strbody As String
strbody = "Hi there" & vbNewLine & vbNewLine & _
    "This is line 1" & vbNewLine & _
    "This is line 2" & vbNewLine & _
    "This is line 3" & vbNewLine & _
    "This is line 4"


Or use this if you want to use cell values

Dim cell As Range
Dim strbody As String
For Each cell In Sheets("Sheet1").Range("C1:C20")
    strbody = strbody & cell.Value & vbNewLine
Next


Or this one

Dim strbody As String
With Sheets("Sheet1")
    strbody = "Hi there" & vbNewLine & vbNewLine & _
        .Range("A1") & vbNewLine & _
        .Range("A2") & vbNewLine & _
        .Range("A3") & vbNewLine & _
        .Range("A4")
End With




Links

.TextBody = "file://Yourcomputer/YourFolder/Week2.xls"

'If there are spaces use %20
.TextBody = "file://Yourcomputer/YourFolder/Week%202.xls"

'Example for a file on a website
.TextBody = "http://www.rondebruin.nl/files/EasyFilter.zip"



HTML text :

If you want to create emails that are formatted you can use HTMLBody (Office 2000 and up) instead of TextBody. You can find a lot of WebPages on the internet with more HTML tags examples.

.HTMLBody = "

Dear Ron de Bruin

" & _
"Please visit this website to download an update.
" & _
"Ron's Excel Page"



Tip: Or send a complete webpage, instead of HTMLBody or TextBody use

.CreateMHTMLBody "http://www.rondebruin.nl/copy1.htm"

Or file on your computer
.CreateMHTMLBody "file://C:/test.htm"



Copy the cells as values

If you want to paste as values the sheet must be unprotected!!!!!
Or Unprotect and Protect the sheet in the Sub also.

See this page for example code that you can use
http://www.rondebruin.nl/values.htm



Test if you are online

You can use code like this in your subroutine to avoid errors if you run the code
when you are not online (example below is for a dial up connection)

For checking other connections check out this great website.
http://vbnet.mvps.org/

Public Declare Function InternetGetConnectedState _
                         Lib "wininet.dll" (lpdwFlags As Long, _
                                            ByVal dwReserved As Long) As Boolean

Function IsConnected() As Boolean
    Dim Stat As Long
    IsConnected = (InternetGetConnectedState(Stat, 0&) <> 0)
End Function

Sub Test()
' Randy Birch
    If IsConnected = True Then
        MsgBox "Copy your mail code here"
    Else
        MsgBox "You can't use this subroutine because you are not online"
    End If
End Sub


Links to more information about CDO for windows 2000


MSDN
Search for "CDO for Windows 2000" on MSDN

Paul R. Sadowski
http://www.paulsadowski.com/WSH/cdo.htm

www.aspfaq.com
http://www.aspfaq.com/show.asp?id=2026

http://www.rondebruin.nl/cdo.htm

9/29/12

7 Ways to Earn Respect as a Leader


Are you feeling disrespected by your employees? It may be that you're failing in one of these seven areas.

Do you wonder why some people naturally gain respect, while others have to command or, worse, demand it?

Earning respect is in direct correlation to treating others with the same. Showing respect sounds like a basic skill, and yet somehow complaints about being disrespected run rampant around coffee rooms and bathrooms in companies around the country.

Are parents and teachers shirking their responsibility for turning everyone into good little citizens that can play well with others? Perhaps, but more likely, cultural norms have changed. Families allow for greater familiarity, and schools are more focused on test scores and class sizes than they are on teaching little Johnny and Susie to stand out as leaders.

But whether you are the executive in charge or a contributing team member, your ability to earn respect will impact your emotional happiness and ultimate career trajectory. Some people in authority believe they are entitled to respect simply due to their position or experience, but this sort of respect diminishes over time and can ultimately hurt the company culture.

Here are seven tips to help you be the leader who earns respect rather than just demands it.

1. Be consistent.
If you find you lack credibility, it's probably because you are saying one thing and doing another. People do pay attention to what you say until you give them reason not to by doing the opposite. You don't have to be predictable, just don't be a hypocrite.

2. Be punctual.
Nothing makes me lose respect for someone more then being made to wait. Time is the most valuable commodity for successful people. Missing appointments or being late demonstrates a total disregard for the lives and needs of others. Get control of your calendar.

3. Be responsive.
The challenge with contact management today is there are too many ways to communicate. Between Twitter, Facebook, Messenger, text, phone, Skype, and Facetime, people are in a quandary to know what is the best way to reach you. And even with all the channels, some people still don't respond in a timely manner, leaving colleagues hanging or chasing them. Limit your channels and respond within 24 hours if you want to appear communication worthy.

4.  Be right much of the time, but be comfortable being wrong.
The simple way to be right is to do your homework and state facts that are well thought out. Still, you may have to make a best guess now and then even when information is too scarce to know for sure. Take it as a qualified risk, manage expectations, and if you're wrong, smile and be happy you learned something that day.

5. Forgive others and yourself for mistakes.
If you're not erring, you're not trying. Healthy leaders encourage experimentation and create environments of safe failure. Encourage people to take mitigated risks, and set an example for how to shake off a failure and bounce back.

6. Show respect to others when they are wrong and right.
Disparaging people who make errors will reflect worse on you than those who err. On the flip side, any jealous tendencies toward those who succeed will surely be noticed by those around. Live as if in a glass body. Assume all can see inside your heart.

7. Help those who are holding you back, but not too much.
Good leaders help those around them succeed by overcoming weakness. But respect is lost quickly for the boss who placates habitual troublemakers at the expense of the group's success. Know when to support weak players, and cut them loose when they clearly hamper the result.
Too many people today assume leadership positions without consideration for their impact on others. The leadership vacuum in business today allows them to stay as long they manage acceptable results. Ultimately, your personal leadership legacy will not be remembered for your M.B.A., your sales numbers, or the toys you acquired. Most likely, it will be the positive, personal impact you created, one follower at a time.

http://www.inc.com/kevin-daum/7-ways-to-earn-respect-as-a-leader.html

9/21/12

Don't Just Buy Local, Buy Personal

Buying local is great, but to really support local entrepreneurs, go one step farther and buy personal.

A small business near me closed down. I feel terrible because it's partly my fault.

Every entrepreneur has big dreams. Many have small budgets, though, so they do the best they can.

They hope for great word of mouth since they have no marketing budget. They hope quality and service will turn an otherwise terrible location into a destination. They have passion and desire in abundance, and hope hard work and persistence will overcome any roadblocks.

In short, they hope.

And every day, people like me crush their hopes.

Granted in this case I'm only a little to blame. I knew the little clothing store was doomed the day it opened. It seemed obvious, just from driving by, that the owner loves clothing and fashion and hoped to build a business out of that passion, but it seemed just as obvious the business would eventually fail.

We've all seen entrepreneurs open new ventures that we can tell will soon go under. I'm sure you drive by a few every day. (If you're like me you sometimes make a little mental bet on how long they'll stay open. Six months is usually a safe estimate.)

I never stopped in this particular store. While I could say was more convenient to shop elsewhere, the truth is I didn't stop in because I never saw any cars in the parking lot. I was uncomfortable with how I would feel, and how the owner would feel, if I looked around and didn't buy anything.

I would feel guilty. I'm sure you've walked out of a store empty-handed and felt like you somehow let an eager, enthusiastic, bright-eyed owner down.

The owner would feel disappointed. Every business is an extension of its owner, and when a business is struggling perspective is in short supply.

You know you won't make every sale, of course, but remembering that it's business, not personal, is almost impossible.  The customer who doesn't make a purchase in some small way rejects your business... and therefore, by extension, rejects you.

Each potential customer carries the power of validation or rejection.

That's a power I didn't want. But I should have, because I could have made a difference, however small.
Each of us can make that difference. Instead of buying local, go a step further and buy personal.

Put aside price/value calculations and rational market theory and survival of the fittest and take a chance on a new or struggling entrepreneur. Buy a few items from a local mom and pop. Hire the small restaurant down the road to cater a non-critical event. Call a new vendor and ask for a quote.

Sure, you already have established vendor relationships in place, but why not give other small businesses the opportunity to win you over? In the process you may find a great new vendor... or you might not.

But what's the worst that can happen?

You might spend a little more. The meal might not be great. The quote might miss the mark. That's okay. No matter what happens, be gracious. Be complimentary. Say something nice. Say thank you.

Pick a small business and give it a chance. Will you, alone, keep it afloat?

Of course you won't. I couldn't have saved that clothing store. But I could still have made a meaningful, even if momentary, difference.

At the heart of every business is a person with a dream, and few things are sadder than realizing your life will fall short of your dreams.

So stop in. Take a look around. Provide a moment of hope.

A little extra hope may be all that entrepreneur needs to keep going.

http://www.inc.com/jeff-haden/dont-just-buy-local-buy-personal.html

9/11/12

How to Manage Managers

When you work for yourself, as most entrepreneurs do, the notion of "managing" those you have hired to do just that may seem quaint in light of all the work you need to catch up on. But as the company you started begins to grow, and you hire more and more people to fuel that growth, it is a good idea to take a step back from the day-to-day grind and consider what it might mean to both you and your company if you devoted some of your time to thinking about how best to manage your managers. After all, the more people you empower to make decisions, and that free you up to think more strategically, the faster, at least in theory, your company can grow.
"Don't fall into the trap of believing that management is an indefinable art," says Ed Muzio, CEO of Group Harmonics, a workplace consulting firm in Albuquerque, New Mexico. "It's not. The key to managing anyone is to set clear performance expectations in advance, and hold the person accountable. That may be more difficult to do for managers than direct workers, but it's no less important."
How does one best managing a manager anyway? Here are some strategies to consider:
Managing Managers: Set the Vision
The first key to managing your managers is to make sure your managers know what they're managing toward.
One way to do this would be sharing clear short-term (one year) and long-term (three- to five-year) business plans, says Jenni Luke, national executive director of the Step Up Women's Network, a national membership organization for women: "This provides measurable goals to achieve in the short term and gives long term vision for the business so that when managers must make decisions independently, they have the proper strategic context in which to make them."
Another approach to aligning your vision with your managers, says Jill Morin, CEO of Kahler Slater, an interdisciplinary design and consulting enterprise in Milwaukee, is to ascertain answers to questions such as:
  • Do they embrace your organization's vision?
  • Are they on board with your core beliefs, your values, and your mission?
  • Do they have a clear image of what the future holds when the business achieves its vision for success?
"The bottom line," Morin says, "is without these essential starting points, it won't matter who or how you manage."
 
Managing Managers: Document the Details and Communicate
As a boss, one of your goals should be to make sure that your managers have all the tools necessary to do their jobs well. As part of that, you should make developing an employee handbook, which contains policies on issues like vacation and over-time as well as structured feedback regarding performance a priority. "Having the handbook will help you set expectations with the team before problems arise, and they will arise," Luke says.
Managers need to understand not only the "what" but also the "why" behind any strategic plan," says Morin. That way, they can offer their own ideas on enhancing and executing the plan, and do so without needing your involvement every step of the way.
"Yes, Jack Welch said it first, but you cannot over-communicate the vision, goals, and strategies for the business, especially if your managers are smart, committed, and passionate about achieving success," she says. "And why would you have hired them in the first place if they weren't?"
Bi-weekly individual meetings and bi-weekly team meetings serve the purpose of checking progress against goals but also enable the sharing of best practices and experiences that others on your management team can benefit from, says Luke. Then, supplement these regular meetings with quarterly meetings focused on the bigger picture such as budget, product or program development or long-range planning so that the managers know they will be expected to contribute to this top-level thinking and planning. "Giving your managers the freedom to do the work and engaging them in planning should engender a sense of ownership in the success of the business unit which is exactly what you need," she says.


Managing Managers: Measure Tasks
A key part of knowing how well a manager is doing is to establish straight-forward quantitative measures based on the performance of their team, says Luke, who suggests looking at objective goals set in your business plan such as:
  • Is your manager achieving revenue targets?
  • Are they operating on budget?
  • Have they developed new customers?
Dr. Alice Waagen, founder and president of Workforce Learning, a leadership development company in Washington, D.C., says that you can even establish clear performance guidelines about what makes up a good manager along the lines of something like:
1. A good manager creates short- and long-term goals for all staff.
2. A good manager sets realistic standards and targets to measure progress to plan.
3. A good manager provides specific, objective feedback on an ongoing basis, informing, enlightening and helping staff members improve their performance.
"For managers to succeed, they need time to learn to manage" she says. "And then, once they do, they need to be held accountable for their results."
"When you add all that up, it means that you need to clearly communicate to your manager what you expect them to accomplish through his or her staff," Muzio says. "For example, you might say, 'Your job is to make sure the five people who work for you make 400 widgets each week,' or, if the goals change, 'your job is to make sure each of the five people who works for you has a clear performance target, hits the target, and together those targets roll up to the output goal you and I set together each month. You can vary the structure, but keep the simple focus: Your job is to make sure your people produce what is necessary."


Managing Managers: Manage Behavior

Employees usually don't quit businesses, they quit bosses. That means that while tracking how a team performs quantitatively is critical in evaluating a manager, "it should also be an equal priority to assess qualitative measures of skills such as leadership, strategic thinking, and business development instincts, which can be a far more challenging task," says Luke.
That's why you want your manager to maintain positive, functional relationships, Muzio says. "Don't dismiss expectations about relationships as soft or emotional; they are extremely practical," he says, pointing out that it costs at least two- to three-times an employee's annual salary to find a replacement. "Good interpersonal relationships lead to output consistency and group longevity. A manager who leaves unhappy, dysfunctional relationships in his wake is a manager that will cost you money in employee complaints and turnover."
So how can we actually measure and evaluate to these standards? Waagen suggests tips such as:
1. Look for telltale signs of bad management, such as missed deadlines or unusually high absenteeism or turnover. Chances are, if you do not see these key signs, the manager is doing a pretty good job.
2. Walk around and talk with the manager's direct reports. Are employees engaged and involved? Are they excited by their work? Do they appear to have a clear idea of the specific tasks or projects they need to accomplish and why?
3. Interview employees. Ask them when was the last time they talked with their manager? Probe whether or not they are happy on the job. Their responses can provide terrific feedback.


Managing Managers: Be a Coach, Not a Referee

Even the best managers mess up sometimes, and "people problems" – which are usually brought to your attention when a subordinate comes to you to complain about his or her manager - are often the cause, says Morin of Kahler Slater. She suggests that you resist the temptation to get directly involved or, worse, to fix the problems yourself.

"Instead, use these challenges as opportunities to coach your managers on how to deal with conflict – personally, professionally, and productively – rather than ignore or dismiss it," she says. "Then you can circle back to assess progress."
One of the mistakes any CEO can make is forgetting to look in the mirror. Said another way, keep a close watch on your own behavior as a way to inspire your managers to emulate you, says Marilyn Suttle, a Detroit-based personal and professional development coach. To do that, she suggests asking yourself questions like:
  • Do you shy away from conflict?
  • Do you demand and force rather than encourage and inspire?
  • Do you ask questions and solicit input from others in the company?
"The point," says Suttle, "is to become a role model and mentor your managers into becoming the best versions of themselves."

http://www.inc.com/guides/2010/08/how-to-manage-managers.html

9/6/12

5 Power Questions for Your Sales Team

Smart questions bring in good answers. If you want to know what's really going on at your company, make sure you're asking the right ones.

Your interactions with your sales team have an obvious impact on business--and the questions you ask can enhance or degrade your company's performance.

By asking the right questions, and then carefully listening to the answers, an astute leader can influence and gain insight into an employee's business competence and morale, as well as a team's overall effectiveness. As a bonus, you'll enrich morale by showing your sales team you understand their key concerns.

Here are five smart questions that can give you a deeper understanding of employees, the business, and the competitive marketplace.

1. What is the biggest obstacle to adding new customers?
Reps are cautious to court new accounts if they believe the company will not be able to service them effectively. So the answers to this question can reveal operational issues, such as a lengthy procedure for setting up new accounts or order processing problems within your company.

On the other hand, if you get the answer, "Only my lack of time," that's good news: It says that all systems are in good order and that morale is likely high.

2. What is working and what isn't?
Such open-ended questions will quickly identify chronic complainers as well as uncover significant problems. When asking this question, be prepared for fix-it requests that may or may not be valid, such as, "We need more samples," "Delivery is too slow," or "We are not competitive." You may need to do some digging to find out whether the problems really need solving.

Most importantly, answers to this question communicate morale. If the responses suggest that little or nothing is working, then you have a morale issue. That's a sales killer, and a leader should uncover and fix causative issues.

3. What are your most (and least) significant opportunities
The answers to this question indicate where a sales team is focusing its attention. The answers may signal that a sales team is operating contrary to company plans--perhaps spending time on a product or service that is not in the company's best interest, for instance. You may also uncover an opportunity that management has not previously identified.

4. If you had a magic wand and could fix one problem, what would it be?
This question forces a targeted answer to avoid a rambling discussion. A wise leader will ask why an employee picked a particular answer, and follow up by soliciting suggestions to correct it.

While the specific answer may give you additional insight into business challenges, it's the suggestions that indicate the depth of a salesperson's business understanding. An unfeasible answer implies a shallow understanding; practical answers convey a solid business understanding.

5. Who is your toughest competitor--and what are they doing right?
One of a leader's most important duties is to stay current with competitors. Your sales force faces the competition each day; team members should have the best on-the-ground reconnaissance.

Once you know the competitive landscape, you can proceed with "risk vs. opportunity" analyses. What you do not want is to find out after the fact that you could have avoided a sales failure by countering competitive activity.

By asking power questions of the sales team, leaders keep in touch with team morale while staying informed about the competition and showing that they care about the team's success. When issues need correction, take action quickly, and give credit to an idea's originator--both clear signals that a good leader is in charge.

http://www.inc.com/john-treace/sales-management-power-questions-sales-team.html

8/23/12

Build Trust: 6 Foolproof Steps to Train Employees

Want to trust your employees to do the job right? Train them like you would teach them to drive.

Building trust in an employee is very much like teaching someone to drive. You don't just hand him the keys on the first day and let him take the car for a spin while hoping for the best. You have to show him how the car works, what the rules of the road are, and how to handle emergency situations successfully. Only when he can drive you to a destination without incident can he be trusted to take the car out alone.

So how do you create that trust with an employee?

1. Start everyone as a passenger. 
When a new employee joins our team, he spends a significant amount of time learning our products. He is taught our computer system and our order fulfillment process. Finally, he role-plays the correct way to help customers get what they need. Throughout this training period, he does not talk to live customers or touch actual orders; instead he is kept in a classroom-like environment, much like a student taking driver's ed. Only when he is able to pass a product exam, successfully enter a test order, and impress me with how he handles difficult sales obstacles is he able to move on the next level.

2. Put the employee behind the wheel--in the parking lot.
Just because an employee has been successful on the written road test does not mean he is ready to drive. In phase two of our trust-building process, a new team member is given real responsibilities, but performs them in an off-road setting, still quarantined from customer contact. Whereas before, he was only allowed to enter test orders, he will now enter actual orders that come in via our website. Because the orders are real, he must enter them correctly, anticipate problems, and make sure they are handled in a timely manner. Essentially, he is given the chance to sit in the driver's seat, but can only drive around the parking lot, because another team member will be double-checking all of his orders for potential errors. When his orders are error-free, I trust him to take the next step.

3. Let the employee take a drive around the block.

Driving is difficult at first because it requires the use of many skills at once. At this level, the employee must put together all the product knowledge he has acquired, use our computer system accurately, and do both with a live customer on the line. In order to make it a little less frightening (for both the employee and me), a new employee practices by shadowing a senior rep on calls. The senior rep takes the order, while the new employee listens in, silently getting his cues from the customer, and using them to enter the order on his own computer. At the end of each call, he prints and compares his order to the order taken by the senior rep. Once he is successfully typing in the same thing as the senior rep, and several orders are done correctly, he can be trusted enough to go further.

4. Time to try the open road.
You will never know if someone can actually drive until you let him do it. As a business owner, I find this is the hardest stage because there are real consequences. The employee is now in control of the order-taking situation, but a senior rep will be shadowing him to make sure the order is done right. Even if the new staffer makes a mistake, the customer will not suffer, and the mistake can be used to teach how to make a better choice the next time. This allows me to let the employee drive, but with the safety of my foot close to the brakes, just in case. Once the mistakes diminish, and the employee feels comfortable in most situations, he can be trusted to take the car out alone.

5. Licensed and ready to roll. 
At this point, the employee trusts that he knows enough about our product, procedure, and mission to be able to drive without a problem from point A to point B. I also trust that he will be able to do that.

6. Send him on his way.
Once the new rep is out on the road, I fully expect he may have some minor fender benders along the way. Being okay with that is the final speed bump in the two-way street called trust.

http://www.inc.com/vanessa-merit-nornberg/build-trust-employee-training-guide.html

8/6/12

10 Tricks for a Fabulous Workday

Want to have the best workday ever?  Day after day?  It's not as difficult as you think.
These 10 tweaks to your everyday behavior will virtually guarantee you a day that's not just enjoyable but allows you to get more done than you ever thought possible.

1. Start with 15 minutes of positive input.
It's easier to achieve and maintain a positive attitude if you have a "library" of positive thoughts in your head, so you can draw upon them if the day doesn't go exactly as you'd prefer. Start each day by reading (or listening to) an inspirational book to ensure that you have just such a resource at hand.

2. Tie your work to your life's goals.
Always remember that there's a deeper reason why you go to work and why you chose your current role. Maybe it's to support your family, to change the world in some way, to help your customers, to make a difference: Whatever the deeper motivation, remind yourself that this workday--today--is the opportunity to accomplish part of that deeper and more important goal.

3. Use your commute wisely.
Most people waste their commute time listening to the news or (worse, especially if they're driving) making calls, texting, or answering emails. In fact, your commute time is the perfect time to get yourself pumped up for the day, and there's no better way to do this than to listen to music that truly inspires you and gets you in the right mood. Don't depend on a DJ: Make your own mixes!

4. Stick a smile on your face.
It's likely, if you followed the first three steps, that you'll already be smiling. If not, stick a smile on your face anyway.

It doesn't matter if it feels fake: Research has shown that even the most forced of smiles genuinely reduces stress and makes you happier. Does this mean you should be grinning like the Joker in the Batman comics? Well, yes, if that's the best you can do. But something a bit more relaxed might be less alarming to co-workers.

5. Express a positive mood.
When most people are asked social greetings--questions such as "How are you?" or "What's up?"--they typically say something neutral ("I'm OK") or negative, like "Hangin' in there." That kind of talk programs your brain for failure.

Instead, if anyone inquires, say something positive and enthusiastic, like: "Fantastic!" or "I'm having a wonderful day!" It's true that there are some people whom this annoys--but these are people you should be avoiding anyway. (See No. 7, below.)

6. Do what's important first.
Everybody complains about having too much to do, but few people do anything about it. As I explained in "The Surprising Secret of Time Management," 20% of your activities are going to produce 80% of your results.  So do that 20% first, before you get to the 80% of your activities that is mostly wasted time. You'll get more done, and you'll get better results.

7. Avoid negative people.
If you've been following Steps 1 through 6, you'll probably find that the most negative people in your orbit will be avoiding you, while the positive people will want to hang out with you and help you. Though it's true you can't avoid all the Debbie Downers, you can certainly find something else to do when they start grousing about stuff they won't or can't change.

8. Don't work long hours.
Long hours are simply a bad idea. For one thing, as I have pointed out before: Long hours, after a short burst of productivity, actually make you less productive. But frankly, if you've followed Steps 1 through 7, you'll be getting so much done that you won't need to work those long hours.

9. Wind down and relax.
Once you're done with the workday, fill the remainder of your hours with nonwork-related activities that bring you joy and help you relax. The analogy of "recharge your batteries" is valid. Failing to take time to relax and stop thinking about work guarantees that you'll begin the next day with a "hangover" of resentment that will leach the joy out of what can, and should be, a positive work experience. overconcentration.

10. End your day with 15 minutes of gratitude.
As I pointed out in "The True Secret of Success," exercising your "gratitude muscle" is the best way to make certain that you experience more success. Before you go to sleep, get out a tablet (paper or electric), and record everything that happened during the day about which you are (or could be) grateful.
You'll sleep better and be ready for tomorrow--which will probably be even more fabulous than today.

But What About ...
Now, I know some of this can sound like a stretch. It may take a leap of faith to give this approach a try. But before you push back too much, let me answer some of the questions I sometimes hear. 

  • What if something really horrible happens during the day? You'll be much better prepared to deal with challenges than if you were already halfway to miserable--which is how most people go through their workday. 
  • What if I simply have to deal with a negative person? Tune out the negativity. Learn to shrug it off. If the negativity becomes too much of a burden, start using the extra energy you're producing to reorganize your team or (if the person is outside your company) find a different partner. 
  • What if I'm too depressed to do any of this? If that's the case, you may need professional help. None of these tricks require more time and effort than making yourself miserable, however. 
  • Do these tricks really work? Yes.
http://www.inc.com/geoffrey-james/have-a-fabulous-workday-10-tricks.html

8/5/12

Motivate Your Core Performers to Become Star Performers

No sales force consists entirely of stars; sales staffs are usually made up mainly of solid performers, with smaller groups of laggards and rainmakers. Though most compensation plans approach these three groups as if they were the same, research shows that each is motivated by something different.

As the largest cadre, core performers typically represent the greatest opportunity, but they're often ignored by incentive plans. At the same time, they're the group most likely to move the needle — if they're given the proper incentives.

Why does this valuable group tend to be off the radar screen? One reason is that sales managers don't identify with them. At many companies the managers are former rainmakers, so they pay the current rainmakers an undue amount of attention. As a consequence, core performers are often passed over for promotion and neglected at annual sales meetings. But this is not in the best interest of the company. Core performers usually represent the largest part of the sales force, and companies cannot make their numbers if they're not in the game. Here are some proven strategies for keeping them there.

Multi-tier targets. A project that Mike recently worked on with a national financial services company shows that such targets help motivate core performers. At the company a major proportion of the salespeople fell into this category. In bearish months they almost always found a way to hit their targets, but in bullish months they seldom exceeded their numbers substantially. In an effort to nudge them upward, the company experimented with tiered targets.

The first-tier target was set at a point that a majority of the company's sales agents had historically attained, the second-tier target at a point reached by a smaller percentage of the sales force, and the third-tier target at a point hit only by the company's elite. All the firm's agents were divided into two groups: The first was given targets at tiers one and three, and the second group got targets at all three tiers. The hypothesis was that tiers would act as stepping stones to guide core performers up the curve.

The tiered structure indeed had a profound impact. Core performers striving to achieve triple-tier targets significantly outsold core performers given only two tiers. By contrast, multi-tier targets did not motivate stars and laggards as much: No significant differences in performance were found for those segments.

These results suggest that core performers exert more effort if given additional tiers. Stars are presumably unaffected by the extra stepping stone because they view the top tier as attainable regardless of the number of targets. And the inattentiveness that laggards show suggests that they typically aim for and are satisfied with achieving the first-tier target.

Prizes. A research project that we're both currently working on investigates how prize structures in sales contests can engage core performers. The problem with contests is that stars usually win them. Knowing this, core performers don't bump up their own efforts. You can handicap contestants on the basis of their prior performance, which alleviates the problem to a certain degree. But that creates its own problem: What's fair about core performers' and laggards' taking home the top prizes, if stars are left with lesser prizes or no prize at all?

Ideally, sales executives would design contests so that both stars and core performers would go home satisfied. This isn't easy to do, but if you keep in mind that people are hardwired to adapt to their position in a social hierarchy, it is possible. The key is to offer gifts (not cash) for the lower-level prizes that can be seen as equal, or even superior, to the top-level prizes on some dimension. Suppose a prestigious golf vacation is awarded as a top prize and a local family getaway is awarded as a lower prize. The family getaway has a lower market value than the golf vacation, but core performers can adapt to their central position on the performance curve by shifting their preferences. They can rationalize their prize by saying, "I've golfed plenty lately — what's important to me is spending time with my family." We consistently find that core performers work harder and perform better in contests of this kind than they do in contests with cash prizes.
Furthermore, their increased effort does not come at the cost of decreased effort from stars or laggards.
However, this approach won't work if the gifts offered at lower performance tiers are simply lower-grade versions of those at the top tier. Core performers will never perceive 18 holes at a run-of-the-mill golf course as more desirable than 18 holes at a prestigious course. The lower-level prize must have some quality that the higher-level one does not. In this example, it was the local getaway's family appeal that allowed core performers to remain engaged in the contest.

You will be able to coax better performance from your team by treating your sales force like a portfolio of investments that require different levels and kinds of attention. Sales compensation plans that take into account the different needs of different salespeople — and that are based on real evidence rather than assumptions — will ensure that your sales department gets a significantly higher return on its investments.

http://blogs.hbr.org/cs/2012/08/incentivize_your_core_performe.html

Nine Things Successful People Do Differently

Why have you been so successful in reaching some of your goals, but not others? If you aren't sure, you are far from alone in your confusion. It turns out that even brilliant, highly accomplished people are pretty lousy when it comes to understanding why they succeed or fail. The intuitive answer — that you are born predisposed to certain talents and lacking in others — is really just one small piece of the puzzle. In fact, decades of research on achievement suggests that successful people reach their goals not simply because of who they are, but more often because of what they do.

1. Get specific. When you set yourself a goal, try to be as specific as possible. "Lose 5 pounds" is a better goal than "lose some weight," because it gives you a clear idea of what success looks like. Knowing exactly what you want to achieve keeps you motivated until you get there. Also, think about the specific actions that need to be taken to reach your goal. Just promising you'll "eat less" or "sleep more" is too vague — be clear and precise. "I'll be in bed by 10pm on weeknights" leaves no room for doubt about what you need to do, and whether or not you've actually done it.

2. Seize the moment to act on your goals.
Given how busy most of us are, and how many goals we are juggling at once, it's not surprising that we routinely miss opportunities to act on a goal because we simply fail to notice them. Did you really have no time to work out today? No chance at any point to return that phone call? Achieving your goal means grabbing hold of these opportunities before they slip through your fingers.
To seize the moment, decide when and where you will take each action you want to take, in advance. Again, be as specific as possible (e.g., "If it's Monday, Wednesday, or Friday, I'll work out for 30 minutes before work.") Studies show that this kind of planning will help your brain to detect and seize the opportunity when it arises, increasing your chances of success by roughly 300%.

3. Know exactly how far you have left to go. Achieving any goal also requires honest and regular monitoring of your progress — if not by others, then by you yourself. If you don't know how well you are doing, you can't adjust your behavior or your strategies accordingly. Check your progress frequently — weekly, or even daily, depending on the goal.

4. Be a realistic optimist.
When you are setting a goal, by all means engage in lots of positive thinking about how likely you are to achieve it. Believing in your ability to succeed is enormously helpful for creating and sustaining your motivation. But whatever you do, don't underestimate how difficult it will be to reach your goal. Most goals worth achieving require time, planning, effort, and persistence. Studies show that thinking things will come to you easily and effortlessly leaves you ill-prepared for the journey ahead, and significantly increases the odds of failure.

5. Focus on getting better, rather than being good.
Believing you have the ability to reach your goals is important, but so is believing you can get the ability. Many of us believe that our intelligence, our personality, and our physical aptitudes are fixed — that no matter what we do, we won't improve. As a result, we focus on goals that are all about proving ourselves, rather than developing and acquiring new skills.

Fortunately, decades of research suggest that the belief in fixed ability is completely wrong — abilities of all kinds are profoundly malleable. Embracing the fact that you can change will allow you to make better choices, and reach your fullest potential. People whose goals are about getting better, rather than being good, take difficulty in stride, and appreciate the journey as much as the destination.

6. Have grit.
Grit is a willingness to commit to long-term goals, and to persist in the face of difficulty. Studies show that gritty people obtain more education in their lifetime, and earn higher college GPAs. Grit predicts which cadets will stick out their first grueling year at West Point. In fact, grit even predicts which round contestants will make it to at the Scripps National Spelling Bee.

The good news is, if you aren't particularly gritty now, there is something you can do about it. People who lack grit more often than not believe that they just don't have the innate abilities successful people have. If that describes your own thinking .... well, there's no way to put this nicely: you are wrong. As I mentioned earlier, effort, planning, persistence, and good strategies are what it really takes to succeed. Embracing this knowledge will not only help you see yourself and your goals more accurately, but also do wonders for your grit.

7. Build your willpower muscle. Your self-control "muscle" is just like the other muscles in your body — when it doesn't get much exercise, it becomes weaker over time. But when you give it regular workouts by putting it to good use, it will grow stronger and stronger, and better able to help you successfully reach your goals.

To build willpower, take on a challenge that requires you to do something you'd honestly rather not do. Give up high-fat snacks, do 100 sit-ups a day, stand up straight when you catch yourself slouching, try to learn a new skill. When you find yourself wanting to give in, give up, or just not bother — don't. Start with just one activity, and make a plan for how you will deal with troubles when they occur ("If I have a craving for a snack, I will eat one piece of fresh or three pieces of dried fruit.") It will be hard in the beginning, but it will get easier, and that's the whole point. As your strength grows, you can take on more challenges and step-up your self-control workout.

8. Don't tempt fate. No matter how strong your willpower muscle becomes, it's important to always respect the fact that it is limited, and if you overtax it you will temporarily run out of steam. Don't try to take on two challenging tasks at once, if you can help it (like quitting smoking and dieting at the same time). And don't put yourself in harm's way — many people are overly-confident in their ability to resist temptation, and as a result they put themselves in situations where temptations abound. Successful people know not to make reaching a goal harder than it already is.

9. Focus on what you will do, not what you won't do. Do you want to successfully lose weight, quit smoking, or put a lid on your bad temper? Then plan how you will replace bad habits with good ones, rather than focusing only on the bad habits themselves. Research on thought suppression (e.g., "Don't think about white bears!") has shown that trying to avoid a thought makes it even more active in your mind. The same holds true when it comes to behavior — by trying not to engage in a bad habit, our habits get strengthened rather than broken.

If you want to change your ways, ask yourself, What will I do instead? For example, if you are trying to gain control of your temper and stop flying off the handle, you might make a plan like "If I am starting to feel angry, then I will take three deep breaths to calm down." By using deep breathing as a replacement for giving in to your anger, your bad habit will get worn away over time until it disappears completely.

It is my hope that, after reading about the nine things successful people do differently, you have gained some insight into all the things you have been doing right all along. Even more important, I hope are able to identify the mistakes that have derailed you, and use that knowledge to your advantage from now on. Remember, you don't need to become a different person to become a more successful one. It's never what you are, but what you do.

http://blogs.hbr.org/cs/2011/02/nine_things_successful_people.html

8/1/12

10 Habits of Remarkably Charismatic People

Charisma isn't something you have. It's something you earn. Here's how.

Some people instantly make us feel important. Some people instantly make us feel special. Some people light up a room just by walking in.
We can't always define it, but some people have it: They're naturally charismatic.
Unfortunately, natural charisma quickly loses its impact. Familiarity breeds, well, familiarity.
But some people are remarkably charismatic: They build and maintain great relationships, consistently influence (in a good way) the people around them, consistently make people feel better about themselves--they're the kind of people everyone wants to be around...and wants to be.
Fortunately we can, because being remarkably charismatic isn't about our level of success or our presentation skills or how we dress or the image we project--it's about what we do.
Here are the 10 habits of remarkably charismatic people:

1. They listen way more than they talk.
Ask questions. Maintain eye contact. Smile. Frown. Nod. Respond--not so much verbally, but nonverbally.
That's all it takes to show the other person they're important.
Then when you do speak, don't offer advice unless you're asked. Listening shows you care a lot more than offering advice, because when you offer advice in most cases you make the conversation about you, not them.
Don't believe me? Who is "Here's what I would do..." about: you or the other person?
Only speak when you have something important to say--and always define important as what matters to the other person, not to you.

2. They don't practice selective hearing.
Some people--I guarantee you know people like this--are incapable of hearing anything said by the people they feel are somehow beneath them.
Sure, you speak to them, but that particular falling tree doesn't make a sound in the forest, because there's no one actually listening.
Remarkably charismatic people listen closely to everyone, and they make all of us, regardless of our position or social status or "level," feel like we have something in common with them.
Because we do: We're all people.

3. They put their stuff away.
Don't check your phone. Don't glance at your monitor. Don't focus on anything else, even for a moment.
You can never connect with others if you're busy connecting with your stuff, too.
Give the gift of your full attention. That's a gift few people give. That gift alone will make others want to be around you and remember you.

4. They give before they receive--and often they never receive.
Never think about what you can get. Focus on what you can provide. Giving is the only way to establish a real connection and relationship.
Focus, even in part and even for a moment, on what you can get out of the other person, and you show that the only person who really matters is you.

5. They don't act self-important…
The only people who are impressed by your stuffy, pretentious, self-important self are other stuffy, pretentious, self-important people.
The rest of us aren't impressed. We're irritated, put off, and uncomfortable.
And we hate when you walk in the room.

6. …Because they realize other people are more important.
You already know what you know. You know your opinions. You know your perspectives and points of view.
That stuff isn't important, because it's already yours. You can't learn anything from yourself.
But you don't know what other people know, and everyone, no matter who they are, knows things you don't know.
That makes them a lot more important than you--because they're people you can learn from.

7. They shine the spotlight on others.
No one receives enough praise. No one. Tell people what they did well.
Wait, you say you don't know what they did well?
Shame on you--it's your job to know. It's your job to find out ahead of time.
Not only will people appreciate your praise, they'll appreciate the fact you care enough to pay attention to what they're doing.
Then they'll feel a little more accomplished and a lot more important.

8. They choose their words.
The words you use impact the attitude of others.
For example, you don't have to go to a meeting; you get to go meet with other people. You don't have to create a presentation for a new client; you get to share cool stuff with other people. You don't have to go to the gym; you get to work out and improve your health and fitness.

You don't have to interview job candidates; you get to select a great person to join your team.
We all want to associate with happy, enthusiastic, fulfilled people. The words you choose can help other people feel better about themselves--and make you feel better about yourself, too.

9. They don't discuss the failings of others...
Granted, we all like hearing a little gossip. We all like hearing a little dirt.
The problem is, we don't necessarily like--and we definitely don't respect--the people who dish that dirt.
Don't laugh at other people. When you do, the people around you wonder if you sometimes laugh at them.

10. ...But they readily admit their failings.
Incredibly successful people are often assumed to have charisma simply because they're successful. Their success seems to create a halo effect, almost like a glow.
Keyword is seem.
You don't have to be incredibly successful to be remarkably charismatic. Scratch the shiny surface, and many successful people have all the charisma of a rock.
But you do have to be incredibly genuine to be remarkably charismatic.
Be humble. Share your screwups. Admit your mistakes. Be the cautionary tale. And laugh at yourself.
While you should never laugh at other people, you should always laugh at yourself.
People won't laugh at you. People will laugh laugh with you.
They'll like you better for it--and they'll want to be around you a lot more.

http://www.inc.com/jeff-haden/10-habits-of-remarkably-charismatic-people.html

9 Beliefs of Remarkably Successful People


I'm fortunate enough to know a number of remarkably successful people. Regardless of industry or profession, they all share the same perspectives and beliefs.

The most successful people in business approach their work differently than most. See how they think--and why it works.

And they act on those beliefs:
1. Time doesn't fill me. I fill time.
Deadlines and time frames establish parameters, but typically not in a good way. The average person who is given two weeks to complete a task will instinctively adjust his effort so it actually takes two weeks.
Forget deadlines, at least as a way to manage your activity. Tasks should only take as long as they need to take. Do everything as quickly and effectively as you can. Then use your "free" time to get other things done just as quickly and effectively.
Average people allow time to impose its will on them; remarkable people impose their will on their time.

2. The people around me are the people I chose.
Some of your employees drive you nuts. Some of your customers are obnoxious. Some of your friends are selfish, all-about-me jerks.
You chose them. If the people around you make you unhappy it's not their fault. It's your fault. They're in your professional or personal life because you drew them to you--and you let them remain.
Think about the type of people you want to work with. Think about the types of customers you would enjoy serving. Think about the friends you want to have.
Then change what you do so you can start attracting those people. Hardworking people want to work with hardworking people. Kind people like to associate with kind people. Remarkable employees want to work for remarkable bosses.
Successful people are naturally drawn to successful people.

3. I have never paid my dues.
Dues aren't paid, past tense. Dues get paid, each and every day. The only real measure of your value is the tangible contribution you make on a daily basis.
No matter what you've done or accomplished in the past, you're never too good to roll up your sleeves, get dirty, and do the grunt work.  No job is ever too menial, no task ever too unskilled or boring.
Remarkably successful people never feel entitled--except to the fruits of their labor.

4. Experience is irrelevant. Accomplishments are everything.
You have "10 years in the Web design business." Whoopee. I don't care how long you've been doing what you do. Years of service indicate nothing; you could be the worst 10-year programmer in the world.
I care about what you've done: how many sites you've created, how many back-end systems you've installed, how many customer-specific applications you've developed (and what kind)... all that matters is what you've done.
Successful people don't need to describe themselves using hyperbolic adjectives like passionate, innovative, driven, etc. They can just describe, hopefully in a humble way, what they've done.

5. Failure is something I accomplish; it doesn't just happen to me.
Ask people why they have been successful. Their answers will be filled with personal pronouns: I, me, and the sometimes too occasional we.
Ask them why they failed. Most will revert to childhood and instinctively distance themselves, like the kid who says, "My toy got broken..." instead of, "I broke my toy."
They'll say the economy tanked. They'll say the market wasn't ready. They'll say their suppliers couldn't keep up.
They'll say it was someone or something else.
And by distancing themselves, they don't learn from their failures.
Occasionally something completely outside your control will cause you to fail. Most of the time, though, it's you. And that's okay. Every successful person has failed. Numerous times. Most of them have failed a lot more often than you. That's why they're successful now.
Embrace every failure: Own it, learn from it, and take full responsibility for making sure that next time, things will turn out differently.

6. Volunteers always win.
Whenever you raise your hand you wind up being asked to do more.
That's great. Doing more is an opportunity: to learn, to impress, to gain skills, to build new relationships--to do something more than you would otherwise been able to do.
Success is based on action. The more you volunteer, the more you get to act. Successful people step forward to create opportunities.
Remarkably successful people sprint forward.

7. As long as I'm paid well, it's all good.
Specialization is good. Focus is good. Finding a niche is good.
Generating revenue is great.
Anything a customer will pay you a reasonable price to do--as long as it isn't unethical, immoral, or illegal--is something you should do. Your customers want you to deliver outside your normal territory? If they'll pay you for it, fine. They want you to add services you don't normally include? If they'll pay you for it, fine. The customer wants you to perform some relatively manual labor and you're a high-tech shop? Shut up, roll 'em up, do the work, and get paid.
Only do what you want to do and you might build an okay business. Be willing to do what customers want you to do and you can build a successful business.
Be willing to do even more and you can build a remarkable business.
And speaking of customers...

8. People who pay me always have the right to tell me what to do.
Get over your cocky, pretentious, I-must-be-free-to-express-my-individuality self. Be that way on your own time.
The people who pay you, whether customers or employers, earn the right to dictate what you do and how you do it--sometimes down to the last detail.
Instead of complaining, work to align what you like to do with what the people who pay you want you to do.
Then you turn issues like control and micro-management into non-issues.

9. The extra mile is a vast, unpopulated wasteland.
Everyone says they go the extra mile. Almost no one actually does. Most people who go there think, "Wait... no one else is here... why am I doing this?" and leave, never to return.
That's why the extra mile is such a lonely place.
That's also why the extra mile is a place filled with opportunities.
Be early. Stay late. Make the extra phone call. Send the extra email. Do the extra research. Help a customer unload or unpack a shipment. Don't wait to be asked; offer. Don't just tell employees what to do--show them what to do and work beside them.
Every time you do something, think of one extra thing you can do--especially if other people aren't doing that one thing. Sure, it's hard.
But that's what will make you different.
And over time, that's what will make you incredibly successful.

http://www.inc.com/jeff-haden/9-beliefs-of-remarkably-successful-people.html