Today, in Episode 716 we take a look at the entries for the MapPoint contest, and also a chance to enter the MrExcel NCAA basketball game.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today is Monday, March 17th, St. Patrick's Day.
big day in the U.S.
Because yesterday, last night was selection Sunday for the NCAA basketball pool.
If you're in the U.S.
You have an office pool, please stop by my website MrExcel.com/NCAA.html Grab one of our Excel entry forms, and you can play along, it's free to play.
You can win some great books.
Also, the 15th, Saturday was the deadline for the contest, where we had everyone send in their zip code. Zip code or postal code now, I know that on any given day a podcast is watched by about 10,000 people.
We had 190, actually enter the contest, which I guess is a pretty good ratio.
You'll see here the map, basically I had to import this three different ways one for all the people in the U.S.
And those are the blue dots, then the red dots for Canada and because this is the North American version of map point.
Map point did a great job with those with either the zip code or postal code in the case of Canada.
For the rest of the world since I don't have the European version of that point.
It was basically mapping to a city and country.
Some places it could find, some places it couldn't find, you know.
Maybe it was a misspelling or you live in a suburb that map point just doesn't seem to know.
So, in many cases these dots are close.
You'll see we have a large contingent down here in Australia.
Mostly in Victoria and Australia.
Let's zoom in on Europe and take a look there.
Good representation from throughout Europe of course several in England and will pan over here to the U.S. and Canada, fairly good representation from across the USA, both coasts and several different states.
So, it was interesting to see that.
Now, I said what we do here is for everyone who sent in their entry.
We would draw a name and win a copy of Map Point for yourself.
So, we had 190 entries, what I'm going to do is. I'm just going to switch over to Excel and we're going to use the RAND between function.
Now, RAND between is one of the functions in the analysis tool pack.
So, you want to make sure under tools, add-ins that analysis tool pack is chosen.
Now, it's very simple.
What we do is the RAND between function and specify two numbers in this case 11 and 190 and it chooses number 93.
Now, let me go over to my outlook computer over here.
We'll check...
Okay! The winners from zip code 02184, let's see who that is.
Okay! Well, hey! It says Tim from Braintree, Massachusetts.
Tim didn't give me his last name.
So I'll shoot Tim on now.
We able to get him that copy of Map Point.
I want to thank everyone for sending in the information again.
It's just cool to see how wide area of people are actually listening to the podcast from, that's always cool to see that you're out there.
We'll be back tomorrow with more Excel tips, want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
Today is Monday, March 17th, St. Patrick's Day.
big day in the U.S.
Because yesterday, last night was selection Sunday for the NCAA basketball pool.
If you're in the U.S.
You have an office pool, please stop by my website MrExcel.com/NCAA.html Grab one of our Excel entry forms, and you can play along, it's free to play.
You can win some great books.
Also, the 15th, Saturday was the deadline for the contest, where we had everyone send in their zip code. Zip code or postal code now, I know that on any given day a podcast is watched by about 10,000 people.
We had 190, actually enter the contest, which I guess is a pretty good ratio.
You'll see here the map, basically I had to import this three different ways one for all the people in the U.S.
And those are the blue dots, then the red dots for Canada and because this is the North American version of map point.
Map point did a great job with those with either the zip code or postal code in the case of Canada.
For the rest of the world since I don't have the European version of that point.
It was basically mapping to a city and country.
Some places it could find, some places it couldn't find, you know.
Maybe it was a misspelling or you live in a suburb that map point just doesn't seem to know.
So, in many cases these dots are close.
You'll see we have a large contingent down here in Australia.
Mostly in Victoria and Australia.
Let's zoom in on Europe and take a look there.
Good representation from throughout Europe of course several in England and will pan over here to the U.S. and Canada, fairly good representation from across the USA, both coasts and several different states.
So, it was interesting to see that.
Now, I said what we do here is for everyone who sent in their entry.
We would draw a name and win a copy of Map Point for yourself.
So, we had 190 entries, what I'm going to do is. I'm just going to switch over to Excel and we're going to use the RAND between function.
Now, RAND between is one of the functions in the analysis tool pack.
So, you want to make sure under tools, add-ins that analysis tool pack is chosen.
Now, it's very simple.
What we do is the RAND between function and specify two numbers in this case 11 and 190 and it chooses number 93.
Now, let me go over to my outlook computer over here.
We'll check...
Okay! The winners from zip code 02184, let's see who that is.
Okay! Well, hey! It says Tim from Braintree, Massachusetts.
Tim didn't give me his last name.
So I'll shoot Tim on now.
We able to get him that copy of Map Point.
I want to thank everyone for sending in the information again.
It's just cool to see how wide area of people are actually listening to the podcast from, that's always cool to see that you're out there.
We'll be back tomorrow with more Excel tips, want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
