LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
rci rci is offline
external usenet poster
 
Posts: 40
Default A math/algorithm puzzle!

Hi all...

Using VB in a appplication that needs to solve a bit of a math/algorithm
problem, and thought the good people here would have interesting ideas on
how to solve it...

Without going into too much detail, basically the code must find/suggest the
best pairs of numbers from a single list, and be able to exclude "outliers".

Pairing would be the best pairings possible by closest value.

Example:

data:
25
22
31
24
25
22
28
18
23

I would want to be able to adjust the sensitivity of the code to start to
trim outliers from the data, like "18" would seem to be the biggest
troublemaker in creating similar pairs... resulting in a list like this:


31 28
25 25
24 23
22 22
excluded: 18


The largest delta is three in this case... but you can see how the
logic/sorting might become complex, especially when the list of data becomes
much larger.

Thoughts?

Thx,

SMS
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Algorithm Challenge Lowkey Excel Worksheet Functions 4 July 20th 05 06:40 PM
Can you help!!!!! New Puzzle Krefty Excel Discussion (Misc queries) 0 June 13th 05 08:13 PM
algorithm creation Gixxer_J_97[_2_] Excel Programming 11 February 11th 05 04:24 PM
help with algorithm dreamer[_3_] Excel Programming 6 January 9th 04 02:14 PM
Need help with algorithm RADO[_3_] Excel Programming 1 November 4th 03 12:37 PM


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"