[Solved] Create layout for locksmith master key system

[drlock]

The information not in the grid is user entered data. Within the grid is formula created data using =if function

Progression sequence shows the order each column to be advanced. Progression column 1, the numbers advance each row.PC 2 is advanced every 4, PC 3 advanced ecery 16. The example I have is all cut and paste. What I am trying to do is to automaticly fill in spread sheet according to the progression sequence in whatever order the numbers are. I am looking for any suggestions or formulas that will help me accomplish this

[MrProgrammer]

Hi, and welcome to the forum.

Progression column 1, the numbers advance each row.PC 2 is advanced every 4, PC 3 advanced ecery 16.

I can't find anything like that in your attachment. In particular, I do not see the number 16 anywhere. I ignored this statement.

What I am trying to do is to automaticly fill in spread sheet according to the progression sequence in whatever order the numbers are. I am looking for any suggestions or formulas that will help me accomplish this.

I will guess that you might want the MOD function, though I am not sure I understand what you want to do. See my attachment. I entered the formula in B8, then copied it to the other cells in B8:G11. The values in your grid stay in the range 0 through 9 because your IF function subtracts 10 if the value would exceed 9. That is what =MOD(value;10) does.

202106190012.ods

(13.13 KiB) Downloaded 102 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[Lupp]

I obviously didn't understand anything but the term "wrap-around" - if not I am wrong insofar.

Meta:
Why is a (only) text document attached to a question posted to the Calc branch?
Why is a text document not containing a chart named "chart"?
Why doesn't anything (next to) contained in that document look as if related to the question?

Concerning what I guessed "wrap-around" should mean, and rgarding the mention of the IF() function, I attach an example.

Editing:
Sorry. The attachment didn't survive the save draft/load draft cycle though it was still "textually present".
Now attached anew:

wrapAround.ods

(13.25 KiB) Downloaded 104 times

[drlock]

In the user provided info is the progression sequence right now it is set up 1,2,3,4,5 but it can be any setting i.e. 51324. In the area below the pinning matrix the column with progression 1 each row increases by 1 and repeats each block. Under pro = 2 then the number advances after 4 rows.... that is what I'm trying to get the program to do. I am trying to understand why they work, not just what the different formulas do,

[drlock]

Layout.ods

(10.35 KiB) Downloaded 102 times

Reposting with color to show sequence

[Villeroy]

Under pro = 2 then the number advances after 4 rows.... that is what I'm trying to get the program to do.

Every row counts. You have an empty row after each block, so it should advance after 5 rows.

First cell: =INT((ROW(A1)-1)/5)+1
copy down.
The result is
1
1
1
1
1
2
2
2
2
2
3
3
3
3
3
4
4
4
4
4

[drlock]

I have added notes to the sheet to hopefully explain that it is not random numbers that I'm looking for but a quicker way of showing the spreadsheet numbers without cut and paste.

[MrProgrammer]

I did not understand the goal initially. Your layout makes the task very difficult.

202106191200.ods

(21.57 KiB) Downloaded 121 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[drlock]

Thanks to all who looked at and attempted and solved the problem. I am a locksmith by trade and this is to make master key systems. I do it in my head most of the time and as my wife says " I expect other people to know what I'M talking about". Sorry for the confusion.