Complex problem

[Alexsander]

Hi everyone, I have a somewhat complicated problem here.

I have a first sequence of two fixed numbers (0 and 9) and 11 variable numbers with a 12th digit that is generated according to some assumptions.
The premises are, that each unit of the first sequence must be multiplied by a specific weight and the sum of these results I will divide by 11 and what is left of this division I will use in a subtraction of 11.
This result will indicate which digit of that string will be.

An example to make it easier:

Using the sequence 09 (fixed numbers) and 00000000001 with their respective weights (2,7,6,5,4,3,2,7,6,5,4,3,2)

The sum of the individual multiplication of each number by its weight is 65.

Dividing 65 by 11 gives a result of 5 with a remainder of 10.

I use the remainder to subtract from 11: 11-10=1

The reference for the check digit is 1, following the digit table.


The main issue is that I need to find some way to add a unit to the 11 variable numbers and repeat the process to generate the check digit. How can I best do this?

 

[BigBeachBananas]

Hi everyone, I have a somewhat complicated problem here.

I have a first sequence of two fixed numbers (0 and 9) and 11 variable numbers with a 12th digit that is generated according to some assumptions.
The premises are, that each unit of the first sequence must be multiplied by a specific weight and the sum of these results I will divide by 11 and what is left of this division I will use in a subtraction of 11.
This result will indicate which digit of that string will be.

An example to make it easier:

Using the sequence 09 (fixed numbers) and 00000000001 with their respective weights (2,7,6,5,4,3,2,7,6,5,4,3,2)

The sum of the individual multiplication of each number by its weight is 65.

Dividing 65 by 11 gives a result of 5 with a remainder of 10.

I use the remainder to subtract from 11: 11-10=1

The reference for the check digit is 1, following the digit table.


The main issue is that I need to find some way to add a unit to the 11 variable numbers and repeat the process to generate the check digit. How can I best do this?

Try this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1			Fixed	Variable												Sumproduct	Digit	Final Result
2	Values		0	9	0	0	0	0	0	0	0	0	0	0	1	65	1	000000000011
3	Multiplier		2	7	6	5	4	3	2	7	6	5	4	3	2
Sheet1

Cell Formulas
Range	Formula
P2	P2	=SUMPRODUCT(C2:O2,C3:O3)
Q2	Q2	=11-MOD(P2,11)
R2	R2	=CONCAT(E2:O2,Q2)

 

[Alexsander]

Thank you, It worked perfectly