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

You are not logged in.

## #76 2013-05-03 02:11:07

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

Okay, no problem. I will come up with something.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #77 2013-05-03 02:12:48

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,037

### Re: anyone good with doing math on excel?

Okay, thanks.

Here lies the reader who will never open this book. He is forever dead.
Taking a new step, uttering a new word, is what people fear most. ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

## #78 2013-05-03 02:55:02

ElainaVW
Member
Registered: 2013-04-29
Posts: 580

### Re: anyone good with doing math on excel?

I would like to see a new problem too

Offline

## #79 2013-05-03 04:54:46

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

I am posting it now.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #80 2013-05-03 06:00:07

phrontister
Real Member
From: The Land of Tomorrow
Registered: 2009-07-12
Posts: 4,592

### Re: anyone good with doing math on excel?

Hi Bobby and stefy,

bobbym wrote:

Are you attempting to solve this with a simulation?

Yes...as per the question. I hadn't even considered the much sounder and accurate mathematical alternative and the craziness of such a large sim!

Thanks for the fix for my B version, Bobby...took me a while to understand it, but I finally got it.

I tried the codes that both of you posted, but I particularly like this sim one of stefy's as it's brief, fast and I can understand it:

anonimnystefy wrote:

Here is my own code with no strings:

``Count[Table[RandomInteger[], {10000}, {10}], {___, 1, 1, 1, 1, ___}]/10000 // N``

I didn't know that pattern trick, so that was nice to learn.

This slightly amended code reduces processing time by about 40%:

``Count[Table[RandomInteger[1, 10], {10000}], {___, 1, 1, 1, 1, ___}]/10000 // N``

That blindingly-fast code in post #58 erred if I'd used 'a' or 'n' elsewhere in the current M run, but "ClearAll["Global`*"];" at the beginning fixed that. Found it on the net.

Last edited by phrontister (2013-05-03 06:03:11)

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

Offline

## #81 2013-05-03 06:05:25

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

Hi;

The important part is the Tuples command, if you understand that...

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #82 2013-05-03 06:23:15

phrontister
Real Member
From: The Land of Tomorrow
Registered: 2009-07-12
Posts: 4,592

### Re: anyone good with doing math on excel?

Oops! Yes, I was amazed at the speed and short code, but before understanding it properly I started reading all the other posts that followed and clean forgot to get back to it. I did look up Tuples and Cases at the time and think I'm nearly there with it, but I'll have a closer look after I've been to bed...which is where I should have been hours ago!

So many ways to skin a cat!

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

Offline

## #83 2013-05-03 06:28:05

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

M has that feature. It is nice but it is confusing. See you later.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #84 2013-05-03 07:02:59

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,037

### Re: anyone good with doing math on excel?

bobbym wrote:

I am posting it now.

Thanks!

Here lies the reader who will never open this book. He is forever dead.
Taking a new step, uttering a new word, is what people fear most. ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

## #85 2013-05-03 07:07:31

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

I posted it a long time ago.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #86 2013-05-03 07:08:55

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,037

### Re: anyone good with doing math on excel?

I know. But, I haven't had a chance to post when you posted it.

Here lies the reader who will never open this book. He is forever dead.
Taking a new step, uttering a new word, is what people fear most. ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

## #87 2013-05-03 07:11:44

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

That is okay. Good luck with the problem and may the M be with you.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #88 2013-05-03 07:15:44

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,037

### Re: anyone good with doing math on excel?

Well, I'll leave this one until he sees and reads it.

Here lies the reader who will never open this book. He is forever dead.
Taking a new step, uttering a new word, is what people fear most. ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

## #89 2013-05-03 07:21:36

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

He might start working on it himself.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #90 2013-05-03 07:25:25

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,037

### Re: anyone good with doing math on excel?

He probably will. I just do not want him to abandon it because a discussion of it has started.

Here lies the reader who will never open this book. He is forever dead.
Taking a new step, uttering a new word, is what people fear most. ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

## #91 2013-05-03 07:28:24

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

Well, I hope the comments of A and C and especially D do not lead him astray.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #92 2013-05-03 08:02:36

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,037

### Re: anyone good with doing math on excel?

Me too.

Here lies the reader who will never open this book. He is forever dead.
Taking a new step, uttering a new word, is what people fear most. ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

## #93 2013-05-03 08:43:15

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

Okay, I have to go shopping so I will see you later.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #94 2013-05-03 09:17:50

anonimnystefy
Real Member
From: Harlan's World
Registered: 2011-05-23
Posts: 16,037

### Re: anyone good with doing math on excel?

Okay, see you.

Here lies the reader who will never open this book. He is forever dead.
Taking a new step, uttering a new word, is what people fear most. ― Fyodor Dostoyevsky, Crime and Punishment
The knowledge of some things as a function of age is a delta function.

Offline

## #95 2013-05-03 11:19:45

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

Where am I going? Bought some food and I am eating it.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #96 2013-05-04 02:42:30

phrontister
Real Member
From: The Land of Tomorrow
Registered: 2009-07-12
Posts: 4,592

### Re: anyone good with doing math on excel?

Hi Bobby,

bobbym wrote:

...and may the M be with you.

And May the Fourth be with you!

Yes...that Tuples command is interesting, generating all those possibles like that. Length was new to me too, and I didn't know about the use of "//" either. So...thanks for introducing them.

Early to bed for a change. Catch you later.

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

Offline

## #97 2013-05-04 03:50:29

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

The Fourth?

Have a good night.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #98 2013-05-04 10:45:14

phrontister
Real Member
From: The Land of Tomorrow
Registered: 2009-07-12
Posts: 4,592

### Re: anyone good with doing math on excel?

bobbym wrote:

The Fourth?

Either that's today's date, or I've developed a bad spelling lithp.

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

Offline

## #99 2013-05-04 10:47:23

bobbym
bumpkin
From: Bumpkinland
Registered: 2009-04-12
Posts: 109,606

### Re: anyone good with doing math on excel?

I thought it was the fifth over there.

In mathematics, you don't understand things. You just get used to them.
If it ain't broke, fix it until it is.
Always satisfy the Prime Directive of getting the right answer above all else.

Offline

## #100 2013-05-04 11:01:30

phrontister
Real Member
From: The Land of Tomorrow
Registered: 2009-07-12
Posts: 4,592

### Re: anyone good with doing math on excel?

It is now, but not when I wrote that last night. I'd waited with that post until it was the fourth both in Oz and the U.S.

"The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do." - Ted Nelson

Offline