your four items cost
3.16 1.20 1.50 1.25
(though I can't say what order they were scanned in)
sourced from microsoft excel by "solver"
create range of all decimal numbers (to the second place) from 1.00 to 3.99, store range.
create range of four "empty values"
look for all instances of four cells that produced a product of 7.11
secondary criteria
look for all instances of four cells that sum to 7.11
tertiary criteria for range values, first range of four values must be equal to second range of four values.
everyone that came back was these numbers in different order.
A Riddle of Chess...
-
Skinny Bastard
- shady character
- Posts: 4381
- Joined: Wed Oct 26, 2005 5:14 pm
-
trashtalkr
- Sports Guru
- Posts: 7978
- Joined: Thu Nov 18, 2004 8:20 pm
- Contact:
Wow Raum...that was pretty impressive
"If there were no eternal consciousness in a man, if at the bottom of everything there were only a wild ferment, a power that twisting in dark passions produced everything great or inconsequential; if an unfathomable insatiable emptiness lay hid beneath everything, what would life be but despair?"
Soren Kierkegaard
Soren Kierkegaard
| BBcode: | |
| Hide post links |
-
raum
- Posts: 3944
- Joined: Sun Jul 24, 2005 10:51 am
hey, it's all in your excel application as well, if you install the whole package... and no one taught me how to do it. i just chewed on my keyboard until it started to tasted pretty good.
I highly recommend
"Microsoft Excel Data Analysis and Business Modelling"
by Wayne Winston as a place to start. Excellent reference.
and actually i found a faster way in solver taking a more retail approach, create range of four adjacent columns, to contain the possible prices for four products, that will render a profit of $.711 at a 10% margin.
you have to use accounting format to get the third decimal point, not currency.
then, in the fifth column, sum the four cells per row, and drag this formula down to the bottom of your recordset. open an autofilter on the fifth column, and search for 7.110 and you get the same values for much less criteria programming.
I highly recommend
"Microsoft Excel Data Analysis and Business Modelling"
by Wayne Winston as a place to start. Excellent reference.
and actually i found a faster way in solver taking a more retail approach, create range of four adjacent columns, to contain the possible prices for four products, that will render a profit of $.711 at a 10% margin.
you have to use accounting format to get the third decimal point, not currency.
then, in the fifth column, sum the four cells per row, and drag this formula down to the bottom of your recordset. open an autofilter on the fifth column, and search for 7.110 and you get the same values for much less criteria programming.
| BBcode: | |
| Hide post links |
-
Skinny Bastard
- shady character
- Posts: 4381
- Joined: Wed Oct 26, 2005 5:14 pm
-
AYHJA
- 392
- Posts: 37990
- Joined: Fri Sep 17, 2004 2:25 pm
- Location: Washington, D.C.
- Contact:
LOL!
Wow, I have enjoyed this thread tremendously..
For the record, this is not my question, it was asked to me, and I in turn asked it here, as I had no idea how to solve it...
It was posted that the password to a RAR full of goodies was the first four numbers of the answer to this riddle...So, I decided to drop it here and see what came of it...
Wow, I have enjoyed this thread tremendously..
For the record, this is not my question, it was asked to me, and I in turn asked it here, as I had no idea how to solve it...
It was posted that the password to a RAR full of goodies was the first four numbers of the answer to this riddle...So, I decided to drop it here and see what came of it...
| BBcode: | |
| Hide post links |
-
Fapper
- Rusty Guitar Player
- Posts: 3165
- Joined: Tue Oct 19, 2004 12:12 pm
- Location: ɹns ןǝp ɐɔıɹǝɯɐ
- Contact:
ok did you tried the numbers, let us know
all this talking for some lousy package of porn pixz!
.... goin' down, down, down, down, down ...
all this talking for some lousy package of porn pixz!
.... goin' down, down, down, down, down ...
| BBcode: | |
| Hide post links |