Looking for someone with their Masters Degree in ExcelPrev Topic Next Topic

New Topic New Poll

SkyLine69

Krypton
United States
Member #140,096
March 11, 2013
904 Posts
Offline

Jun 16, 2015, 9:59 pm

Hey folks, I need someone that is a wiz with Excel, I am pretty darn good with formulas and Macros and can not seem to figure out how to make my sheet run itself. I have placed this on multiple forums over the past 3 years only to come up with eventually being ignored. My guess is they have no clue how to do what I am asking. If you can imagine a digital roulette wheel and how the the numbers flash around and then stops on a number. I am trying to place Es and Os, Us and Ds in multiple cells that make up roughly 500 different combinations and gives me numbers or no numbers to wheel. This is putting it in simple terms but trust me its much more complex for someone with basic programming skills. I figure if someone has great skills in excel plus knows the lotto it may be a breeze for them but it will take a Macro , or a different type of program. It do not "think" it can be done with formulas

So.....is there anyone with these skills

Thanks so much for your time

Sky

Stay In The Vortex, you'll be happy you did ..... Random? Seriously? You want me to believe that?
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,228 Posts
Offline

Jun 16, 2015, 10:17 pm

Quote: Originally posted by SkyLine69 on Jun 16, 2015
Hey folks, I need someone that is a wiz with Excel, I am pretty darn good with formulas and Macros and can not seem to figure out how to make my sheet run itself. I have placed this on multiple forums over the past 3 years only to come up with eventually being ignored. My guess is they have no clue how to do what I am asking. If you can imagine a digital roulette wheel and how the the numbers flash around and then stops on a number. I am trying to place Es and Os, Us and Ds in multiple cells that make up roughly 500 different combinations and gives me numbers or no numbers to wheel. This is putting it in simple terms but trust me its much more complex for someone with basic programming skills. I figure if someone has great skills in excel plus knows the lotto it may be a breeze for them but it will take a Macro , or a different type of program. It do not "think" it can be done with formulas

So.....is there anyone with these skills

Thanks so much for your time

Sky

What's the problem with a random number generator?

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
adobea78

United States
Member #116,339
September 8, 2011
5,094 Posts
Offline

Jun 17, 2015, 12:07 am

Quote: Originally posted by SkyLine69 on Jun 16, 2015
Hey folks, I need someone that is a wiz with Excel, I am pretty darn good with formulas and Macros and can not seem to figure out how to make my sheet run itself. I have placed this on multiple forums over the past 3 years only to come up with eventually being ignored. My guess is they have no clue how to do what I am asking. If you can imagine a digital roulette wheel and how the the numbers flash around and then stops on a number. I am trying to place Es and Os, Us and Ds in multiple cells that make up roughly 500 different combinations and gives me numbers or no numbers to wheel. This is putting it in simple terms but trust me its much more complex for someone with basic programming skills. I figure if someone has great skills in excel plus knows the lotto it may be a breeze for them but it will take a Macro , or a different type of program. It do not "think" it can be done with formulas

So.....is there anyone with these skills

Thanks so much for your time

Sky

I don't think is lack of excellent programmers, it could be lack of communication (presentation of concept) on your part. Programming is not writing only codes, it involves analyzing concepts, logic of viability and room for intuition. A wizard of excel is not necessary a programmer, you should be prepared to pay such person for his/her service and to protect your ideal.Try the ' Quora' forum, is mostly academic site, you may get some college professor/ kid to do it out of fun(I do it all the time if I don't understand a concept).Good Luck.
ranman17

New York
United States
Member #83,024
November 27, 2009
2,260 Posts
Offline

Jun 17, 2015, 5:15 am

Quote: Originally posted by SkyLine69 on Jun 16, 2015
Hey folks, I need someone that is a wiz with Excel, I am pretty darn good with formulas and Macros and can not seem to figure out how to make my sheet run itself. I have placed this on multiple forums over the past 3 years only to come up with eventually being ignored. My guess is they have no clue how to do what I am asking. If you can imagine a digital roulette wheel and how the the numbers flash around and then stops on a number. I am trying to place Es and Os, Us and Ds in multiple cells that make up roughly 500 different combinations and gives me numbers or no numbers to wheel. This is putting it in simple terms but trust me its much more complex for someone with basic programming skills. I figure if someone has great skills in excel plus knows the lotto it may be a breeze for them but it will take a Macro , or a different type of program. It do not "think" it can be done with formulas

So.....is there anyone with these skills

Thanks so much for your time

Sky

Can't you use =randbetween on each cell that is to produce a result and that is activated by hitting the Delete key?

Be kind, because everyone you meet is fighting a great battle.

An Unruly Evil
riscknight

Athens
Greece
Member #133,228
September 24, 2012
209 Posts
Offline

Jun 17, 2015, 6:31 am

Sky, perhaps Serge can help you...

He is awesome with Excel...

I'd rather ask for forgiveness instead of permission

6/49 dis(assembly)
CARBOB

COLUMBUS,GA.
United States
Member #4,924
June 3, 2004
6,719 Posts
Offline

Jun 17, 2015, 6:52 am

Quote: Originally posted by SkyLine69 on Jun 16, 2015
Hey folks, I need someone that is a wiz with Excel, I am pretty darn good with formulas and Macros and can not seem to figure out how to make my sheet run itself. I have placed this on multiple forums over the past 3 years only to come up with eventually being ignored. My guess is they have no clue how to do what I am asking. If you can imagine a digital roulette wheel and how the the numbers flash around and then stops on a number. I am trying to place Es and Os, Us and Ds in multiple cells that make up roughly 500 different combinations and gives me numbers or no numbers to wheel. This is putting it in simple terms but trust me its much more complex for someone with basic programming skills. I figure if someone has great skills in excel plus knows the lotto it may be a breeze for them but it will take a Macro , or a different type of program. It do not "think" it can be done with formulas

So.....is there anyone with these skills

Thanks so much for your time

Sky

If I were you, I would be discussing this, in private, with Jadelottery...
Raven62

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Jun 17, 2015, 8:01 am

Quote: Originally posted by SkyLine69 on Jun 16, 2015
Hey folks, I need someone that is a wiz with Excel, I am pretty darn good with formulas and Macros and can not seem to figure out how to make my sheet run itself. I have placed this on multiple forums over the past 3 years only to come up with eventually being ignored. My guess is they have no clue how to do what I am asking. If you can imagine a digital roulette wheel and how the the numbers flash around and then stops on a number. I am trying to place Es and Os, Us and Ds in multiple cells that make up roughly 500 different combinations and gives me numbers or no numbers to wheel. This is putting it in simple terms but trust me its much more complex for someone with basic programming skills. I figure if someone has great skills in excel plus knows the lotto it may be a breeze for them but it will take a Macro , or a different type of program. It do not "think" it can be done with formulas

So.....is there anyone with these skills

Thanks so much for your time

Sky

Necessity is the mother of invention: A need or problem encourages creative efforts to meet the need or solve the problem. It's your brain child, so you need to keep at it until you complete the spreadsheet.

A mind once stretched by a new idea never returns to its original dimensions!

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

The best way to learn is to never stop being an Experiential Student!
bobby623

San Angelo, Texas
United States
Member #1,097
January 31, 2003
1,648 Posts
Offline

Jun 17, 2015, 9:57 am

Switch to a substitution workout.
RJOh

100

mid-Ohio
United States
Member #9
March 24, 2001
20,272 Posts
Offline

Jun 17, 2015, 10:04 am

Quote: Originally posted by SkyLine69 on Jun 16, 2015
Hey folks, I need someone that is a wiz with Excel, I am pretty darn good with formulas and Macros and can not seem to figure out how to make my sheet run itself. I have placed this on multiple forums over the past 3 years only to come up with eventually being ignored. My guess is they have no clue how to do what I am asking. If you can imagine a digital roulette wheel and how the the numbers flash around and then stops on a number. I am trying to place Es and Os, Us and Ds in multiple cells that make up roughly 500 different combinations and gives me numbers or no numbers to wheel. This is putting it in simple terms but trust me its much more complex for someone with basic programming skills. I figure if someone has great skills in excel plus knows the lotto it may be a breeze for them but it will take a Macro , or a different type of program. It do not "think" it can be done with formulas

So.....is there anyone with these skills

Thanks so much for your time

Sky

You need to stop imagining what might be done and actually do it on paper. Once you understand what you would actually had to do if you were doing it on paper then you will understand what has to be if you was writing steps to be followed in Excel or a program to do it.

Even a good programmer has to have a working concept of what he wants before writing a program to do it.

* you don't need to buy every combination, just the winning ones *
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,228 Posts
Offline

Jun 17, 2015, 11:17 am

Larry, there are Excel forums with VBA code to make the cells flash/blink. All seem to note two drawbacks.

1) Flashing/Blinking is an eye irritant.

2) Excel is useless with flashing/blinking text. No editing while cells/ text is blinking.

They way they accomplish the flashing/blinking is by turning a cell on and off.

In your case, you would want to set a flash rate and a color for the roulette effect. Also you'd want to consider if the blinking would be sequential or random, which would determine your flash/blink rate.

You'll need to randomize a timer for each cell to (hopefully) stop a cell from blinking at a given time, but one that don't allow all the cells to stop at once.

You'll need an interrupt handler to kill all the flashing and pass the program back to the sheet once you have the data you want so you can proceed with the next step. Along the same lines, you'll need a routine to notify every other cell when one stops.

That's the simplified, watered down version. There are (likely) other steps that without actually doing it, aren't apparent.

It doesn't seem the Excel community lacks the code or the skill to do what you want, it seems they find it an irritating way to disable their ability to use Excel.

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
SkyLine69

Krypton
United States
Member #140,096
March 11, 2013
904 Posts
Offline

Jun 17, 2015, 1:45 pm

Quote: Originally posted by garyo1954 on Jun 16, 2015
What's the problem with a random number generator?

Hi G, this is beyond a random generator. You have seen some of my books?

Stay In The Vortex, you'll be happy you did ..... Random? Seriously? You want me to believe that?
SkyLine69

Krypton
United States
Member #140,096
March 11, 2013
904 Posts
Offline

Jun 17, 2015, 1:46 pm

Quote: Originally posted by adobea78 on Jun 17, 2015
I don't think is lack of excellent programmers, it could be lack of communication (presentation of concept) on your part. Programming is not writing only codes, it involves analyzing concepts, logic of viability and room for intuition. A wizard of excel is not necessary a programmer, you should be prepared to pay such person for his/her service and to protect your ideal.Try the ' Quora' forum, is mostly academic site, you may get some college professor/ kid to do it out of fun(I do it all the time if I don't understand a concept).Good Luck.

Thanks Ill take a look at it. Ive explained it pretty well I think

Stay In The Vortex, you'll be happy you did ..... Random? Seriously? You want me to believe that?
SkyLine69

Krypton
United States
Member #140,096
March 11, 2013
904 Posts
Offline

Jun 17, 2015, 1:48 pm

Quote: Originally posted by riscknight on Jun 17, 2015
Sky, perhaps Serge can help you...

He is awesome with Excel...

Thanks, Serge and I are talking and he does mostly things on his web site and to make a long story short. I have 5 books approx 2 GIGS each , with 3000 rows of formulas across 36 rows all linked together giving me patterns. I then take these patterns and feed them into hat I call my game sheet for hopefully the next winning numbers.

Stay In The Vortex, you'll be happy you did ..... Random? Seriously? You want me to believe that?
SkyLine69

Krypton
United States
Member #140,096
March 11, 2013
904 Posts
Offline

Jun 17, 2015, 1:50 pm

Quote: Originally posted by ranman17 on Jun 17, 2015
Can't you use =randbetween on each cell that is to produce a result and that is activated by hitting the Delete key?

I will send you a PM with some info and a pic for your evaluation, I have not tried what you mentioned and do not think it will work. It has to physically place letters in specific cells to get an output of number(s)

Stay In The Vortex, you'll be happy you did ..... Random? Seriously? You want me to believe that?
SkyLine69

Krypton
United States
Member #140,096
March 11, 2013
904 Posts
Offline

Jun 17, 2015, 1:51 pm

Quote: Originally posted by CARBOB on Jun 17, 2015
If I were you, I would be discussing this, in private, with Jadelottery...

Thanks CB, you've seen my work, I will do as suggested and you will not be forgotten my friend

Stay In The Vortex, you'll be happy you did ..... Random? Seriously? You want me to believe that?

New Topic New Poll

Subscribe to this topic

Looking for someone with their Masters Degree in ExcelPrev TopicNext Topic

Looking for someone with their Masters Degree in ExcelPrev Topic Next Topic