Upstate Forum Index
  The time now is Tue Jan 06, 2009 2:49 pm   

   SHOUT BOX (RC3)  


Upstate Forum Index -> PC Software Help
Anyone want an Excel Challenge?
Goto page Previous  1, 2, 3  Next
  Author    Thread Post new topic Reply to topic
RunnerBiker
Charter UFSC Member
Charter UFSC Member


Age: 61
Joined: 05 Aug 2004
Posts: 4143
Location: West Union, SC

I think we need to keep working on this. The ^3 (Cubed) solution breaks down. Check this example:

NUM.......Hund..........Ten..........One....H^3+T^3+O^3
006...........0..............0..............6..............216
060...........0..............6..............0..............216
345...........3..............4..............5..............216
354...........3..............5..............4..............216
435...........4..............3..............5..............216
453...........4..............5..............3..............216
534...........5..............3..............4..............216
543...........5..............4..............3..............216
600...........6..............0..............0..............216
_________________
RunnerBiker Brown Eye1¿Brown Eye2
"Live in such a way that you would not be ashamed to sell your parrot to the town gossip." - Will Rogers

Post Thu Nov 10, 2005 3:04 pm 
 Send private message  Reply with quote  
Gadget Wizard
UFSC Administrator
UFSC Administrator


Age: 48
Joined: 24 Jul 2004
Posts: 12780
Location: Upstate SC

The sort method doesn't break down. It does work!!

Now, as far as the calc-method, you're right. As I said in the post, I didn't brute force through all the possible iterations...

006, 600 and 060 is the same an we want them to match, same with 345, 453 etc.. but we don't want 345 & 600 to match.

I do believe we are on the right track here to come up with a pure mathematical solution though. We are going to need to perform some functon on each of the digits and then sum/mutliply them or perform some opertion on that as a whole. Perhaps simply raising each digit to a higher power ^4 will do the trick. You might even want to perform some other function such as a log().

To prove any function we come up with, we are going to have to write a brute force algorithm to check all possible combinations. Once that is done, we can plug in any formula we come up with and test it.
_________________

"Linux is more than an OS, it's a state of mind."






Post Thu Nov 10, 2005 3:27 pm 
 Send private message Visit poster's website  Reply with quote  
RunnerBiker
Charter UFSC Member
Charter UFSC Member


Age: 61
Joined: 05 Aug 2004
Posts: 4143
Location: West Union, SC

A fourth power ^4 solution doesn't work either. Consider these numbers:

NUM......Hund........Ten........One.....H^4+T^4+O^4
247..........2............4............7............2673
274..........2............7............4............2673
366..........3............6............6............2673
427..........4............2............7............2673
472..........4............7............2............2673
636..........6............3............6............2673
663..........6............6............3............2673
724..........7............2............4............2673
742..........7............4............2............2673

247 and 366 shouldn't match
_________________
RunnerBiker Brown Eye1¿Brown Eye2
"Live in such a way that you would not be ashamed to sell your parrot to the town gossip." - Will Rogers

Post Thu Nov 10, 2005 4:07 pm 
 Send private message  Reply with quote  
Gadget Wizard
UFSC Administrator
UFSC Administrator


Age: 48
Joined: 24 Jul 2004
Posts: 12780
Location: Upstate SC

Have you already written a proc to brute force all the combinations?

If so, just start plugging in functions until you find one that works. I'll bet there are plenty that do..

Just keep increasing the power or instead of summing the digits, multiply them together. Maybe using sqr roots or logs will do the trick. We just need to stumble on one that works.
_________________

"Linux is more than an OS, it's a state of mind."








Last edited by Gadget Wizard on Thu Nov 10, 2005 4:19 pm; edited 1 time in total

Post Thu Nov 10, 2005 4:15 pm 
 Send private message Visit poster's website  Reply with quote  
RunnerBiker
Charter UFSC Member
Charter UFSC Member


Age: 61
Joined: 05 Aug 2004
Posts: 4143
Location: West Union, SC

good news. the digits raised to the 5th power generates a unique number. Whoo Hoo
_________________
RunnerBiker Brown Eye1¿Brown Eye2
"Live in such a way that you would not be ashamed to sell your parrot to the town gossip." - Will Rogers

Post Thu Nov 10, 2005 4:19 pm 
 Send private message  Reply with quote  
Gadget Wizard
UFSC Administrator
UFSC Administrator


Age: 48
Joined: 24 Jul 2004
Posts: 12780
Location: Upstate SC

Well, there ya go. I kinda felt as the power increased, the numbers would grow large enough to make the sums unique.

Good work RB!! You could have went to Carolina.
_________________

"Linux is more than an OS, it's a state of mind."






Post Thu Nov 10, 2005 4:22 pm 
 Send private message Visit poster's website  Reply with quote  
Oregonian
UFSC Administrator
UFSC Administrator



Joined: 12 Sep 2004
Posts: 16036
Location: Coquille, OR

Hear! Hear! The final digit of a 5th power relates to the original digit. Maybe that's it! Good work, RB. I would venture to guess that a 9th power would do the same, but not the 7th.
_________________


Women and cats will do as they please, and men and dogs should relax and get used to the idea. - Robert Heinlein

Post Thu Nov 10, 2005 4:24 pm 
 Send private message  Reply with quote  
slider
Charter UFSC Member
Charter UFSC Member


Age: 52
Joined: 29 Jul 2004
Posts: 1920
Location: Wellford

Good work! Someone care to explain what this will do and why for all us non excel folk.

Post Thu Nov 10, 2005 4:28 pm 
 Send private message Send e-mail  Reply with quote  
Gadget Wizard
UFSC Administrator
UFSC Administrator


Age: 48
Joined: 24 Jul 2004
Posts: 12780
Location: Upstate SC

Oregonian wrote:
The final digit of a 5th power relates to the original digit. Maybe that's it!


You might be on to something there O. Good thinking!!

I knew there was enough brain powered geekiness around here to figure it out.
_________________

"Linux is more than an OS, it's a state of mind."






Post Thu Nov 10, 2005 4:29 pm 
 Send private message Visit poster's website  Reply with quote  
RunnerBiker
Charter UFSC Member
Charter UFSC Member


Age: 61
Joined: 05 Aug 2004
Posts: 4143
Location: West Union, SC

GW wrote:
Good work RB!! You could have went to Carolina.

Maybe I could have went to Carolina, but if I had gone to Clemson I would have learned the difference between went and gone.

Sorry GW, that was unkind, but I couldn't help myself.
_________________
RunnerBiker Brown Eye1¿Brown Eye2
"Live in such a way that you would not be ashamed to sell your parrot to the town gossip." - Will Rogers

Post Thu Nov 10, 2005 4:32 pm 
 Send private message  Reply with quote  
slider
Charter UFSC Member
Charter UFSC Member


Age: 52
Joined: 29 Jul 2004
Posts: 1920
Location: Wellford

Roll on the floor

Post Thu Nov 10, 2005 4:33 pm 
 Send private message Send e-mail  Reply with quote  
Gadget Wizard
UFSC Administrator
UFSC Administrator


Age: 48
Joined: 24 Jul 2004
Posts: 12780
Location: Upstate SC

Spoken like a true yankee.
_________________

"Linux is more than an OS, it's a state of mind."






Post Thu Nov 10, 2005 4:34 pm 
 Send private message Visit poster's website  Reply with quote  
Oregonian
UFSC Administrator
UFSC Administrator



Joined: 12 Sep 2004
Posts: 16036
Location: Coquille, OR

There is a place in the world for us Yankees, too. Well maybe.
_________________


Women and cats will do as they please, and men and dogs should relax and get used to the idea. - Robert Heinlein

Post Thu Nov 10, 2005 4:35 pm 
 Send private message  Reply with quote  
Gadget Wizard
UFSC Administrator
UFSC Administrator


Age: 48
Joined: 24 Jul 2004
Posts: 12780
Location: Upstate SC

That's true!! Some of my best friends are Yankees, and well, Clemson graduates. Group Huggin

...and I did kinda step into that one.

If you peeps pointed out all my spelling and grammar mistakes, that would be a big job. Laugh out loud

They just ain't no dad gum telling what this old southern boy might have done gone and posted 'round here. Wink

My pet peave is when people use your for you're. I don't know why, but that drives me crazy!!
_________________

"Linux is more than an OS, it's a state of mind."






Post Thu Nov 10, 2005 8:53 pm 
 Send private message Visit poster's website  Reply with quote  
Oregonian
UFSC Administrator
UFSC Administrator



Joined: 12 Sep 2004
Posts: 16036
Location: Coquille, OR

Well we could just use "yer" and it would serve for both.

_________________


Women and cats will do as they please, and men and dogs should relax and get used to the idea. - Robert Heinlein

Post Fri Nov 11, 2005 1:13 pm 
 Send private message  Reply with quote  
  Display posts from previous:      
Post new topic Reply to topic
Upstate Forum Index Goto page Previous  1, 2, 3  Next Last Thread |  Next Thread >
Jump to:  

Powered by phpBB 2.0.x © 2001 phpBB Group
Custom Mods by Gadget Wizard