Sign in to follow this  
Followers 0
wutangah

Evaluating values in arrays.

2 posts in this topic

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?

Share this post


Link to post
Share on other sites



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?

;)


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0