"Ghost numbers"

Question

Below is a chart of interface control numbers.

7	0	0	4	3	9	5
1	4	8	8	1	7	1
1	4	8	8	5	3	7
7	6	8	0	5	3	7
6	13	13	9	10	4	8
10	4	2	6	8	12	8
6	2		8	4	4	6
1	4	8	0	1	3	1

Looking at this, there are 7 columns.  What I need is a way to find Ghost numbers.  A ghost number is a number that works in the interface system but was not designed to, it shows up when the columns, which require certain criteria are calculated.  Column 5 is a good example.  The interface control numbers results would be, in this case, 4,1 (the bottom two rows).  The criteria used as the interface are 1,5,5 (bottom 3 rows of top section).  For this example, 1,5,&5 are designed to work in the system.  However, when we look at the compiling of the control numbers column we see a number 4, in this case (4+1=5).  This 4 is called a ghost and will access the system but because of the criteria cannot be changed for calculations (it is mechanical) knowing there is a 4 ghost becomes the best solution to preventing uncontrolled interface access--we can do this by simply not giving out any #4 for use in the 5th column for access.  MY QUESTION, how do I set-up a formula to find these ghost numbers in a spreadsheet.  The ghost numbers are only found in the bottom two rows (this example shows that the last three columns have ghost, 4, 4, & 6) of the interface control numbers, here they would be

6, 2, -, 8, 4, 4, 6

1, 4, 8, 0, 1, 3, 1,

Thanks

Answer 1

If I marked, answered, it was a mistake.  Yes I would still like help.  The last message above was the shortest and best explanation I came up with for origination of the ghost number and what it is.  Thanks

Answer 2

You marked this question as answered. Did you mean to do that? The comment you chose does not provide any solution. Do you still need help?

Answer 3

I made this example, it has two computations for examples but in this case I only used the top set when I derived the numbers.

There are two separate computations below (for examples).

Here is the formula for setting up the control numbers

-) Always use bottom three rows of criteria numbers to establish control numbers

-) Bottom three rows, each row independently is an interface number that works the system-

i.e. in first group 1488793, 7082793, 1488171

1. All columns are processed downward independently
2. Lowest number from criteria group becomes bottom line of control group
3. Lowest number subtracted from next highest becomes 2^nd^ row from bottom
4. Lowest number subtracted from total of previous two rows (it is rare to have a third number pop in so this step is usually not needed)

(there are two more steps but they act as a ‘system control’ and don’t affect “each” production run but the “total”, therefore they will not be mentioned)

The three number listed above are supposed to be the only product numbers that can cross through the ‘side-step’ in the production run, but, when I look at the control numbers I can see that 6082793, 1486172, 1082171, and 6482671 plus a few others I didn’t list will also cross the ‘side-step’ in production.  Those other numbers that can cross the side-step are the ghost numbers, they weren’t allocated in the production run to cross over but because of the glitch in the mechanical control design they will cross over.  Currently the only way to alleviate the incorrect product side-step is to send a list of ghost numbers to production and tell them not to issue the product numbers.

GHOST NUMBER CRITERIA

1. The control number (bottom two rows) is equal to or between lowest and highest number of the bottom three rows of Criteria group

Criteria

7              0              0              4              3              9              5

1              4             8              8              1             7              1

1              4             8              8              7             9              3

7              0              8             2              7              9             3

Control

6              13           13           9              10           4              8

10           6              2              6              6              10           12

6              4                             6              6              2             2

1              0              8             2              1              7             1

_______________________________________

Criteria

7              0              0              4              3              9              5

1              4              8              8              1              7              1

1              4              8              8              3              3              5

9              6              8              2              3              3              5

Control

6              13           13           9              10           4              8

8              4              2              6              10           12           10

8              2                              6              2              4              4

1              4              8              2              1              3              1

This is the shortest explanation I could come up with that explains who what and where.  Thanks

Answer 4

Thanks for the work everyone.  The points are clear I haven't expounded the problem clearly and have been thinking of how to convey it without a three page explanation.  I am sure the solutions provided would be well worth the effort because as I said above, find ghost numbers in 400+ pages of computations is a solid waste of time.  I am preparing an exert of computations and explanations to hopefully rectify the vast state of confusion I have made here, but non-the-less, I am so grateful of the effort to solve or the help offered.

MrInstrument

Answer 5

You stated

"MY QUESTION, how do I set-up a formula to find these ghost numbers in a spreadsheet.  The ghost numbers are only found in the bottom two rows (this example shows that the last three columns have ghost, 4, 4, & 6) of the interface control numbers, here they would be ..."

So, can we safely infer from that statement that what you really want to do is just find where on each spreadsheet the last 2 rows are at?  From that point, it is just a matter of identifying the entries in those 2 rows?

Or are you asking how to actually calculate the numbers that would appear in those last two rows?  If that is the question, then we need to know what math is involved in getting them into the rows as you have them shown now.