Pretty basic division question

[DavJans]

I got 2 fields, workers(field u) and quantity(field q), Field a is the answer

workers will be input like this 24,58,34
and quantity is just a number 2 for example

here is my code for dividing quantity based on workers

Code: Select all

on mouseUp
   put fld "u" into tempu
   replace "," with cr in tempu
   put number of lines of tempu into tempu2
   put fld "q" into tempq
   put tempq / tempu2 into tempq2
   put tempu2 & tempq2 into fld "a"
end mouseUp

my question is, is there a better way to do this, it seems kind of ugly

[dunbarx]

Hi.

Well, in one sense I have no idea what you are up to. But your script seems sound, as far as it goes.

So without knowing, as I say, why not just:

put fld "q" / number of items of fld "u" into fld "a"

Now I am not trying to be cute or coy. What I am really getting at is, how are you managing your data?

Craig Newman

[DavJans]

I can elaborate a little more, as for what I'm up to, this specific question has to do with welder's, sometimes we have very big welds that take up to 4 or 5 hours to complete, so one worker starts at night and one finishes in the morning, so in this case 2 welders worked on one weld, we keep track of this because these welds (CJP's) need to pass NDT testing and if they fail we keep track of that as well and we keep track of who in return has to re-weld it. As far as managing my data, it is all stored in a mysql database. My main goal i guess is to get a variable, using this example, that would have one worker number per line and one variable with .5 in it. then use a repeat for each line and send it to my mysql server.

I all ready have it working for one worker at a time, but my Quality control guys want me to dd this as an option. its easy enough to do, I just thought maybe I was making it more complicated than it had to be.

[dunbarx]

Fair enough. I really asked because I thought it odd that you had a string of integers separated by commas, that you turned into a return delimited list. I really does not matter how you arrange your data, only that you can manage it easily. So your method is verbose, but that is not intrinsically bad. Whatever works.

When you have a moment, consider creating an array with welders and their hours linked. This would be a fooling-around exercise.

Craig