Evaluating values in arrays.

[wutangah]

Need help please!

Here is the concept of what I'm trying to do...

5 arrays taken from Excel

GL# - SO# - VEND# - PART# - QTY#

1 - 1234 - 2313 - ABC12 - 5

1 - 1234 - 2313 - ABC24 - 1

0 - 1424 - 1212 - ASD99 - 4

=======================

Definitions of variables:

$soNumber = SO#

$vendNumber = VEND#

$prev_SO = Previous SO# to evaluate against

$prev_VEND = Previous VEND# to evaluate against

$part = PART#

$qty = QTY#

$gl = GL#

Anything in "[ ]" is a function.

Loop [data entry of PART# and QTY#] until one of these conditions occurs, in this order of precedence:

1) If $soNumber is not equal to $prev_SO then [save, exit and create new order].

2) If $vendNumber is not equal to $prev_VEND then [save, exit and create new order].

========================

And here are some questions:

1) How do I evaluate, for example, $soNumber vs. $prev_SO?

2) Is this concept optimized or is there an easier way?

[PsaltyDS]

Need help please!

Here is the concept of what I'm trying to do...

5 arrays taken from Excel

GL# - SO# - VEND# - PART# - QTY#

1 - 1234 - 2313 - ABC12 - 5

1 - 1234 - 2313 - ABC24 - 1

0 - 1424 - 1212 - ASD99 - 4

=======================

Definitions of variables:

$soNumber = SO#

$vendNumber = VEND#

$prev_SO = Previous SO# to evaluate against

$prev_VEND = Previous VEND# to evaluate against

$part = PART#

$qty = QTY#

$gl = GL#

Anything in "[ ]" is a function.

Loop [data entry of PART# and QTY#] until one of these conditions occurs, in this order of precedence:

1) If $soNumber is not equal to $prev_SO then [save, exit and create new order].

2) If $vendNumber is not equal to $prev_VEND then [save, exit and create new order].

========================

And here are some questions:

1) How do I evaluate, for example, $soNumber vs. $prev_SO?

2) Is this concept optimized or is there an easier way?

Do you already have the data from excel in a 2D array (perhaps by way of ExcelCOM_UDF), with row [0][x] = headings, rows [1][x] thru [n][x] = data?

A 1) If Not $soNumber = $prev_SO Then _NewOrder($soNumber)

A 2) What does it mean to "optimize" generalized pseudo code?