Discussion about math, puzzles, games and fun.   Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫  π  -¹ ² ³ °

You are not logged in.

#26 2013-04-27 06:00:17

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

Unfortunately it will not let me post links to the screen cap of it.

Offline

#27 2013-04-27 06:07:44

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

There's a time delay before new members can post images.  Bit of a nuisance, but it's needed to make abuse etc less frequent.

If you have somewhere you can post an image you can tell me the address here.

Do it like this

htt etc

ww etc

link name

I'll re-build it and post it properly, which may help some other soul who is trying to follow this thread.

Bob

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

#28 2013-04-27 06:08:49

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

/albums/cc214/Hayabusakota/ScreenShot2013-04-27at15702PM.png

Offline

#29 2013-04-27 06:10:00

JoshH
Member
Registered: 2013-04-25
Posts: 31

Offline

#30 2013-04-27 06:33:57

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

hi

Just been looking at the formulas.  Let's see if I've got it.

B2 contains the zero/one number from ten rolls.  eg. 1010111101

B3 initially contains zero.

FIND(1111,B2) looks to see if 1111 occurs and if it does B3 is incremented by 1

If it doesn't then IFERROR traps the value error and puts B3 back in B3, so B3 is not incremented.

So what happens if you put 1010111101 in B2 ?

Does B3 get incremented ?

Bob

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

#31 2013-04-27 06:40:48

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

the B3 cell seams to remain at zero and never changes.

Offline

#32 2013-04-27 06:42:21

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

in b3 my cell reads =IFERROR(IF(FIND(1111,B2)>0,B3+1,B3),B3)

Offline

#33 2013-04-27 06:43:17

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

try this:

=IFERROR(IF(FIND(1111,B2)>0,"yes","no"),"no")

That works for me.

Bob

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

#34 2013-04-27 06:46:03

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

With your b3 stuff in the formula I get  circular reference error.  Not surprising as the formula is sitting in the space you want to store a number.

thinking....................

Bob

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

#35 2013-04-27 06:48:02

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

ok the yes and no one worked.

Offline

#36 2013-04-27 06:49:10

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

now would there be a way to run number tally's in the same bracket and after 10k games have it reset ?

Offline

#37 2013-04-27 06:51:05

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

in the same bracket

?? not following you ??

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

#38 2013-04-27 06:56:59

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

the cell underneath the random coin flips I was trying to get number of wins in there and I can't figure out how to have that work. The yes/no worked but I am still kinda lost on how to get the number of wins to come out.

Offline

#39 2013-04-27 06:59:17

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

something else I did was on a separate sheet I did the same problem but took a different approach I made ten separate sells across a =RANDBETWEEN(0,1). I was thinking maybe there would be a way to have all those cell's join in a formula to figure out the average. I'll post a link of what I did in the separate cell. I am terrible at explaining what I was thinking lol! sorry

Offline

#40 2013-04-27 07:01:14

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

albums/cc214/Hayabusakota/ScreenShot2013-04-27at30008PM.png

Offline

#41 2013-04-27 07:02:15

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

How about this:

columns A to J hold the ten coin flips.

column K builds the ten digit o/1 value

column L has the IFERROR...... formula returning YES or NO

Copy 20 times down the page.

At the bottom of the L column use COUNTIF to count the YES values.

If this works, extend to 10000 rows.

Bob

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

#42 2013-04-27 07:02:29

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

i218 .photobucket. com

Offline

#43 2013-04-27 07:11:15

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

just wondering how do I build the ten digit 0/1 value into one cell?

Offline

#44 2013-04-27 07:17:41

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

This is messy but it will do it I think

k = 1000000000*A + 100000000*B + 10000000*C + 1000000*D  + 100000*E + 10000*F + 1000*G + 100*H + 10*I + J

Or you could build a string version as you can 'add' letters without all those powers of ten.

Bob

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

#45 2013-04-27 07:40:31

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

Better idea.  Don't use numbers at all.

IF(RANDBETWEEN(0,1)=1,"H","T") to get an H or T.

Then use CONCATENATE to build a ten letter word.

FIND HHHH instead.

I'm going to see if I can get my head around how you avoid 10000 rows of formulas.

It's 20.40 BST so I'm going to log off for now and come back to this tomorrow evening.

Bob

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

#46 2013-04-27 07:43:15

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

No luck with that formula up there I was trying to build a string but I don't know how to have the string represent the number in each cell while grouped in the cell I am adding the totals in.

Offline

#47 2013-04-27 07:45:28

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

alright sounds good to me going to see if I know anyone locally that can help me figure this one out.

Offline

#48 2013-04-27 15:23:41

JoshH
Member
Registered: 2013-04-25
Posts: 31

Re: Greetings!

Hey Bob here you go a screen cap of the current problem almost solved I think.

albums/cc214/Hayabusakota/ScreenShot2013-04-27at30008PM-1.png

this is part one.

Offline

#49 2013-04-27 15:25:03

JoshH
Member
Registered: 2013-04-25
Posts: 31

Offline

#50 2013-04-27 18:58:21

bob bundy
Administrator
Registered: 2010-06-20
Posts: 8,566

Re: Greetings!

hi Josh,

It's 8 am here in the UK.  I'm out all morning at a dance show rehearsal so I'll have to leave this until this afternoon.  That last image looks like you are just about there.

Bob

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob Bundy

Offline

Board footer

Powered by FluxBB