You are not logged in.
Pages: 1
Hi, I need a mathematic algorithm only (not code) to solve the follow scenario:
Quantity of the items, from 1 to 200.
Quantity of the validation (checking), from 1 to 6 for each validation
Goal: to get the 2-sequence numbers - always a pair.
Example: (1-200) Items: 4
(3 checks) Item #1 / Checking: 3
(1 check ) Item #2 / Checking: 1
(4 checks) Item #3 / Checking: 4
(2 checks) Item #4 / Checking: 2
See below the example.
How can I get the 2-sequence numbers? for the checks that does not have numbers, it could be filled out with a zero or negative number. Remember, no coding, only math code, see example below:
For the first value: QtyItems*QtyChecking/2
For the second value: QtyItems*QtyChecking/2 + 1
Thank you.
#.
Item Check #1 Check #2 Check #3 Check #4 Check #5 Check #6
I001 1 and 2 3 and 4 5 and 6 (0 or <0) (0 or <0) (0 or <0)
I002 7 and 8 (0 or <0) (0 or <0) (0 or <0) (0 or <0) (0 or <0)
I003 9 and 10 11 and 12 13 and 14 15 and 16 (0 or <0). (0 or <0)
I004 17 and 18 19 and 20 (0 or <0) (0 or <0) (0 or <0) (0 or <0)
Offline
hi brjohnsmith
Welcome to the forum.
Sorry, I'm a bit thick here. I haven't understood what you are doing at all.
What are the items? Have you got 200 of them? Validation means checking the 'truth' of something. eg. You've made an electrical item and want to check it works. You've solved an equation and want to check the answer works for the given problem. Why would you want 6 checks. Are these different checks and why do some need more checks than others.
Please go back ten steps and assume I'm an idiot. I won't be offended.
Bob
Children are not defined by school ...........The Fonz
You cannot teach a man anything; you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you! …………….Bob
Offline
Pages: 1