# VB multi-array sort/group functions

I need a function written in vbscript that can sort a multi-dimensional array, evaluate it and categorized/sorted it in a

new array.

**ARRAY will be created from a getRow in ADO

**so it will be

array (data,key)

i = count

parray(1,i) = item a

parray(2,i) = measurement1,

parray(3,i) = measurement2

The array will have measurements and based on a a tolerance, I need to group them into the new array or sorted:

item_nameA, measurement1, measurement2,measurement3,measuremeant4,measurement5,measurement6

item_nameB, measurement1, measurement2,measurement3,measuremeant4,measurement5,measurement6

item_nameC, measurement1, measurement2,measurement3,measuremeant4,measurement5,measurement6

A 8, 10.75, 7, 10, 8.125, 11

B 8.375, 10.875, 7.375, 10, 8.625, 11.125

C 7.875, 10.875,7, 10, 8.5, 11.125

D 6.875, 14.875,7, 10, 8.5, 11.125

Tolerance could be .5 or .75.. I am measuring in inches so if it is .5 (1/2) off, I need to know this.

if A & B are in within tolerance, it is grouped in the new array

Hence, in the new array

we have:

**Group 1:** A,B

**Group 2:** c

**Group 3:** c

or

GroupArray (0) = A,B

GroupArray (1) = C

GroupArray (2) = D

Note, you will need to convert variants into doubles. cdbl (variant)

So I will need several functions:

1. Check The Tolerance. If the item is not within tolerance, it will be grouped elsewhere

function (variant,tolerance)

if != tolerance return false

end function

2. Sort Array/ Group Array

3. Create a new array that has the grouping.

You can put the first column in the new array and I can use it as a key to reference the old array.

E.G.

newarray(0) = item1,item4, item 5

newarray(1) = item2,item10,item16,item30

Assuming I want exact tolerance, so I should get something like

Group 1: item 24,25

Group 2: item 33,33

Attached is the test data and some info.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

4) Tested against test data provided to developer

## Platform

Windows NT/2000 via ASP or as a Visual Basic Function/Class

( 0 comentários ) United States

ID do Projeto: #2997609

## 6 freelancers estão ofertando em média \$33 para esse trabalho

gopikap

See private message.

\$21.25 USD in 3 dias
(54 Comentários)
5.1
vw654347vw

See private message.

\$42.5 USD in 3 dias
(8 Comentários)
3.8
jspsenthilvw

See private message.

\$38.25 USD in 3 dias
(22 Comentários)
3.9

See private message.

\$21.25 USD in 3 dias
(4 Comentários)
3.4
semaphoreinc

See private message.

\$42.5 USD in 3 dias
(7 Comentários)
2.0
dzaganavw

See private message.

\$42.5 USD in 3 dias
(0 Comentários)
0.0
sanjayinfot

See private message.

\$34 USD in 3 dias
(3 Comentários)
0.0