Microsoft Excel Tutorial:
Do you need to randomly select someone from your department to win a prize? This awesome free macro from Rob Collie at PowerPivotPro.com will do the trick. Download for free from: Wheel Of Inquisition Files Download | P3 Adaptive
Rob had an idea of how to improve participation on his company Zoom calls. He wanted a way to randomly call on a person. I knew it was going to be a fun day when Rob called and said, "do you think you can rotate the Excel Camera Tool?" He explained what he was trying to do and both of us spent way too much time trying to tweak the workbook to have a spinning Wheel of Inquisition.
We kept adding new features so the wheel would spin faster at first and then slow down. Rob added the ability to mark someone as absent from the call and the ability to add a fudge factor to award someone with a higher probability of being chosen.
Rob took my lame spinning arrow and made it look like a pro app, just like he and his team do with Power BI dashboards at PowerPivotPro.
Table of Contents
(0:00) I get a call from Rob Collie about a spinning carnival wheel in Excel
(0:40) Inserting an arrow shape and making it spin
(1:15) Looking at the VBA Code
(2:23) Rob's version of the spinning wheel
(3:40) How to download
(3:50) Call Rob for help with your Power BI projects
Do you need to randomly select someone from your department to win a prize? This awesome free macro from Rob Collie at PowerPivotPro.com will do the trick. Download for free from: Wheel Of Inquisition Files Download | P3 Adaptive
Rob had an idea of how to improve participation on his company Zoom calls. He wanted a way to randomly call on a person. I knew it was going to be a fun day when Rob called and said, "do you think you can rotate the Excel Camera Tool?" He explained what he was trying to do and both of us spent way too much time trying to tweak the workbook to have a spinning Wheel of Inquisition.
We kept adding new features so the wheel would spin faster at first and then slow down. Rob added the ability to mark someone as absent from the call and the ability to add a fudge factor to award someone with a higher probability of being chosen.
Rob took my lame spinning arrow and made it look like a pro app, just like he and his team do with Power BI dashboards at PowerPivotPro.
Table of Contents
(0:00) I get a call from Rob Collie about a spinning carnival wheel in Excel
(0:40) Inserting an arrow shape and making it spin
(1:15) Looking at the VBA Code
(2:23) Rob's version of the spinning wheel
(3:40) How to download
(3:50) Call Rob for help with your Power BI projects
Transcript of the video:
Learn Excel from MrExcel podcast episode 2371. Spin the Wheel.
So this is fun.
I got a call the other day from Rob Collie.
You know Rob. He is from PowerPivotPro.com.
A former guy on the Excel team.
We used to live near each other in Cleveland and would generally have a great time.
Rob is back in Excel. And he has this crazy idea.
He wants a spinny arrow thing in order to choose a name from a list.
Alright now this was just a day after I spent six hours trying to get 37,000 YouTube subscribers into a spreadsheet in order to give away a pair of socks.
So I was completely down with this idea.
And what I basically came up came up with was this little arrow from Insert Shape.
With the shape you can grab the little rotation handle and spin the shape.
And I said, “I wonder if there is a way that I could do that with VBA?
So we have the arrow and behind the arrow is a pie chart.
The pie chart with these names over here.
So I click spin.
It starts out kind of fast.
It slows down and Eddy is the winner.
Spin again and Andy.
It is kind of cool. It starts out fast.
Let's take a quick look at the code.
You identify that right arrow.
And then I choose several random numbers: i, k, m and n.
There is going to be a loop.
The m loop anywhere from 5 to 20 where we jump the angle at 20 degrees.
That makes it look like it's going fast.
Then the N loop where it jumps by 12 degrees.
Then the k loop where it jumps by 5 degrees.
Then finally the last loop it just jumps by two degrees.
Of course if we ever get to the point where we've gone beyond 360 degrees you have to subtract 360.
It is fairly simple code.
So I sent this off to Rob and what happened next tells me a lot about Rob!
Rob has left the Excel world and moved on to Power BI.
In Power BI he is creating awesome looking dashboards.
In Power BI, it is really important to create something that looks great.
Because, let's face it, it's going to be used by your manager's manager's manager.
It really needs to look great.
So Rob took my lame arrow and came up with this.
So this tells me how important in the Power BI world it is to make things look great.
Rob adds a graphic here.
Instead of the spinny arrow he makes the whole wheel turn.
This is a pie chart. He is changing the angle of first slice.
So we click spin.
And the wheel starts off spinning.
And Molly is the lucky (or unlucky?) winner depending on what Rob is using this for.
There it is Alex. It was really close - almost on the line.
But you can see, thanks to the pointer there. You can tell Alex versus Kellan.
Also back here if there is someone who is out that day, they can just change this to #N/A.
And.
Rob even added a fudge factor.
If he wants to add some weight.
Maybe Brad needs to be called on?
You can jump Brad up by five and then Brad gets a larger share of the wheel like that.
So now when we spin there's a bigger chance that Brad will be called on.
This is just for fun, of course.
If you need to choose a winner in your department or choose who's going to be assigned to go get lunch.
Or whatever.
Rob says that he's making this available for free. You can download this. It is easy to use.
It is easy to add more people back here on the attendees tab.
So check out the URL down in the YouTube description to download this.
Also, if you are trying to get into Power BI and you want dashboards that are going to look great.
Give Rob a call. Rob has been doing this since Power Pivot was first a thing.
He jumped on Power BI as soon as it came by.
His team will create awesome looking dashboards for you.
Rob is a good friend of mine.
I want to thank Rob for calling me and involving me with this crazy fun project.
There you have it. If you like these videos, please Like, Subscribe, and Ring that Bell.
I want to thank Rob for this awesome question.
I want to thank you for stopping by we'll see you next time for another netcast from MrExcel.
So this is fun.
I got a call the other day from Rob Collie.
You know Rob. He is from PowerPivotPro.com.
A former guy on the Excel team.
We used to live near each other in Cleveland and would generally have a great time.
Rob is back in Excel. And he has this crazy idea.
He wants a spinny arrow thing in order to choose a name from a list.
Alright now this was just a day after I spent six hours trying to get 37,000 YouTube subscribers into a spreadsheet in order to give away a pair of socks.
So I was completely down with this idea.
And what I basically came up came up with was this little arrow from Insert Shape.
With the shape you can grab the little rotation handle and spin the shape.
And I said, “I wonder if there is a way that I could do that with VBA?
So we have the arrow and behind the arrow is a pie chart.
The pie chart with these names over here.
So I click spin.
It starts out kind of fast.
It slows down and Eddy is the winner.
Spin again and Andy.
It is kind of cool. It starts out fast.
Let's take a quick look at the code.
You identify that right arrow.
And then I choose several random numbers: i, k, m and n.
There is going to be a loop.
The m loop anywhere from 5 to 20 where we jump the angle at 20 degrees.
That makes it look like it's going fast.
Then the N loop where it jumps by 12 degrees.
Then the k loop where it jumps by 5 degrees.
Then finally the last loop it just jumps by two degrees.
Of course if we ever get to the point where we've gone beyond 360 degrees you have to subtract 360.
It is fairly simple code.
So I sent this off to Rob and what happened next tells me a lot about Rob!
Rob has left the Excel world and moved on to Power BI.
In Power BI he is creating awesome looking dashboards.
In Power BI, it is really important to create something that looks great.
Because, let's face it, it's going to be used by your manager's manager's manager.
It really needs to look great.
So Rob took my lame arrow and came up with this.
So this tells me how important in the Power BI world it is to make things look great.
Rob adds a graphic here.
Instead of the spinny arrow he makes the whole wheel turn.
This is a pie chart. He is changing the angle of first slice.
So we click spin.
And the wheel starts off spinning.
And Molly is the lucky (or unlucky?) winner depending on what Rob is using this for.
There it is Alex. It was really close - almost on the line.
But you can see, thanks to the pointer there. You can tell Alex versus Kellan.
Also back here if there is someone who is out that day, they can just change this to #N/A.
And.
Rob even added a fudge factor.
If he wants to add some weight.
Maybe Brad needs to be called on?
You can jump Brad up by five and then Brad gets a larger share of the wheel like that.
So now when we spin there's a bigger chance that Brad will be called on.
This is just for fun, of course.
If you need to choose a winner in your department or choose who's going to be assigned to go get lunch.
Or whatever.
Rob says that he's making this available for free. You can download this. It is easy to use.
It is easy to add more people back here on the attendees tab.
So check out the URL down in the YouTube description to download this.
Also, if you are trying to get into Power BI and you want dashboards that are going to look great.
Give Rob a call. Rob has been doing this since Power Pivot was first a thing.
He jumped on Power BI as soon as it came by.
His team will create awesome looking dashboards for you.
Rob is a good friend of mine.
I want to thank Rob for calling me and involving me with this crazy fun project.
There you have it. If you like these videos, please Like, Subscribe, and Ring that Bell.
I want to thank Rob for this awesome question.
I want to thank you for stopping by we'll see you next time for another netcast from MrExcel.
