4n tri to convert 0 number

4n tri   convert 0 number

example  number
8074

807      480      487      407      235      359      239      259      283      203      237      835      035      357      285      205      257      435      835      035      459      859      059      439      839      039      243      283      237      439      839      379      249      289      279      245      205      257      249      209      279      207      459      059      579

then show up
29094987_4n_tri_0_to.xlsm
Microsoft ExcelMicrosoft Office

Last Comment

8/22/2022 - Mon
Learn

Hi Is this duplicate request ?
Martin Liss

I'm concerned about the 487 you show in the expected results. in the previous question where you requested 2-digit pairs I initially split a number like 4807 into 3 pairs, those pairs being 48, 40 and 47, which are all left to right. 78, 84, etcetera were not considered because they were not left to right. Should I have included them?

In any case this is the results I get for 3n when I only consider right to left 3-digit combinations.
29095047.xlsm

Martin

Is an great job
Thanks

Should I have included them?

in the example i show 45  tri numbers

you need that  workbook?

also i would like to ask for an improve?
Martin Liss

I could be wrong about this, or I could be misunderstanding your requirements, but I think there are a lot more than 45 numbers.

To begin with there are 24 permutations of a 4-digit number taken 3 at a time. Using 8074 as an example, the permutations of sets of 3 are:

807, 804, 870, 874, 840, 847, 087, 084, 078, 074, 048, 047, 780, 784, 708, 704, 748, 740, 480, 487, 408, 407, 478, 470

Then after that I believe your requirements are  to...
1. Add 5 to the 1st digit of each of them which gives another 24 numbers
2. Add 5 to the 2st digit of each of them which gives another 24 numbers
3. Add 5 to the 3st digit of each of them which gives another 24 numbers
4. Add 5 to all 3 digits of each of them which gives another 24 numbers
5. Repeat each of the digits in 8074 three times which gives another 4 numbers
6. Add 5 to each of the digits in those four numbers which gives another 4 numbers
Which gives you a total of 24 * 5 + 4 + 4 = 128 numbers!

As I said above, I could be wrong, but if I'm right can you really get any useful information when you look at the 128 results for each number?
Martin Liss

I went ahead and did some work on the tri numbers. In the attached workbook if you click the 'Convert 0 Numbers 3n' button you will see results for only row 20. I did that so we can more easily discuss the results.

The green cells are the permutations of 8809. There are 12 of them. In my previous post I said there should be 24, but because '8'appears twice in the number there are only 12 unique ones.

The yellow cells are the result of adding 5 to the 1st digit of each of them.

The light blue cells are the result of adding 5 to the 2nd digit of each of them.

The pink cells are the result of adding 5 to the 3rd digit of each of them.

The gray cells are the result of adding 5 to all three digits of each of them.

The salmon-colored cells are the result of repeating each digit in 8809 three times.

The dark blue cells are the result of adding 5 to each digit in the salmon-colored cells.

Before I do anything else I need you to tell me if that's what you want, keeping in mind that for a value like 4805 there will be almost twice that many results.
29095047a.xlsm

Martin

Im a greed with you

then  need work with any number with 0

now is working only with number 8809

Best Expert !
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.

Martin

i know the tri is  more dificult  excuse me  because  i get lost with a lot of work around   but  i try to be proper as i can
Martin Liss

Is tri working correctly?

Martin

Tri can be improve with the ORD LAW
Martin Liss

Martin

tri is working

but can be improve to ORD

can be ??
SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.