FORMULA CHALLENGE shortest wins !

[erik.van.geit]

Hi, everyone !!
just a little idea

In this threadwe came up with some formulas to get a random character choosen from
a, b, c ... z, A, B, C, ... Z, 0, 1, 2 ... 9
so 62 possibilities

wouldn't it be nice to make a little sport of it

the one who generates the shortest formula, may launch the next formulachallenge

OBJECTIF
GENERATE randomly 1 LCASE or UCASE or INTEGER
rules:
1. formula in english
2. acurate = all characters must occur about as much as the others when formula is tested (for instance 20000 times, copied down or "evaluate"-macrotest)
3. posts must be generated within 7 days (168 hours) from now
4. no replies with comments about the other formulas
5. jury = moderators ?

what do you think ?

kind regards,
Erik

 

[apolloh]

To:Mr. Tushar Mehta

I am a new bie.My English is so poor to express exactly.I agree with your opinion above.

But, I think this case is just a brainstorming(hehe,learned from Emily) to enhance our thinking ability except for an application.

Maybe the one bellow is faster.(Guess it )

=MID("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ",INT(RAND()*62)+1,1)

 

[apolloh]

59 charaters by cxjsjt a member of http://club.excelhome.net

It seem faster than the 50 charaters one.

=CHAR(INDEX({48;65;97}+RAND()*{10;26;26},(RAND()*31+21)/13))

 

[Emily]

I do concur Tusharm's idea for "easy to maintain"

Array equation is sometimes treated as normal equation (beginner or expert). For example, the formula in this thread:

=CHAR(LARGE({0,33,65}+ROW($32:$57),INT(RAND()*62)+1))

Error #NUM is shown

But brainstorming is acceptable

 

[erik.van.geit]

Hi, folks,

You've been doing a fantastic job here!
Of course, Tushar Mehta, I agree that applications should in first place be easy to understand and edit, but this was just for brainstorm-purposes, to have some fun and ...

... in the mean time learning from each other ...
... see what different approaches !!

Map1
	A	B	C	D
1	POSTER	# CHAR	formula
2	Teacher	68	CHAR(INDEX(RAND()*{10;26;26}+{48;65;97},MATCH(RAND(),{0,10,36}/62)))
3	Erik	75	CHAR(IF(RAND()>52/62,INT(RAND()*10+48),INT(RAND()*26+65)+INT(RAND()*2)*32))
4	Barry	79	CHAR(CHOOSE(MATCH(RAND(),{0,10,36}/62),10*RAND()+48,26*RAND()+65,26*RAND()+97))
5	bosco_yip	61	CHAR(LOOKUP(RAND(),{0,5,18}/31,RAND()*{10;26;26}+{48;65;97}))
6	UCSDKID	64	CHAR(IF(RAND()<10/62,RAND()*10+48,N(RAND()>.5)*32+RAND()*26+65))
7	wintercom	50	CHAR(LARGE({0,33,65}+ROW(32:57),INT(RAND()*62)+1))
sheet1

wintercom,
WELCOME TO THE BOARD !!!
That's a bright entrance !
I agree with Teacher: this formula is working correctly.
Can you post a new challenge ?

kind regards,
Erik

 

[apolloh]

Hi，Erik

Mistaken!
The winner is not wintercom,it should be asdf1001 a member of the excelhome.net

Have a look at the competition thread abount this topic at the competition forum in http:/club.excelhome.net. There are many different ways which had been found out on this topic.

Address:

http://club.excelhome.net/dispbbs.asp?boardid=102&id=112049

 

[PA HS Teacher]

I propose Formula Challenge II

http://www.mrexcel.com/board2/viewtopic.php?t=160246

 

[wintercom]

Hi，Erik

Mistaken!
The winner is not wintercom,it should be asdf1001 a member of the excelhome.net

Have a look at the competition thread abount this topic at the competition forum in http:/club.excelhome.net. There are many different ways which had been found out on this topic.

Address:

http://club.excelhome.net/dispbbs.asp?boardid=102&id=112049

Oh,just take it easy,i never said that i'm the winner, it's above my ability.i have said cleally that it's not done by myself but by others.

 

[erik.van.geit]

Hi, guys,
this post didn't appear in "my posts" yesterday

Oh,just take it easy,i never said that i'm the winner, it's above my ability.i have said cleally that it's not done by myself but by others.

Yes, that's true, wintercom: can you invite the one who provided "your" formula to post a new challenge here? Perhaps (s)he doesn't know (s)he won a challenge

kind regards,
Erik

 

[apolloh]

47 charaters by chrisfang, a member of http://club.excelhome.net

=CHAR(-SMALL(-{31,64,96}-ROW(1:26),RAND()*62+1))

 

[erik.van.geit]

nice variation