Skip to main content
TikkaMasala12-Amethyst
12-Amethyst
Jun 25, 2014 6:27 AM UTC
Solved

Splitting of layers

Hi all

I'm trying to make a small computation program that would split a thicker layers

into thinner ones and would put the split layers into one column.

In the attached computation sheet I have demonstrated what I would like to find first for a one layer system, then for a 2 layer system, but

the problem is that I haven't been able to make it work for n -layered system.

Thanks for your advices.

Werner_E
Werner_EAnswer
25-Diamond I
Jun 25, 2014 7:26 AM UTC

See if the attached file helps.

IMHO functions, like I provide, are more useful than static calculations, but you sure can easily turn my function into a simple one-time calculation if you insist.

@Mike: Did you post the wrong file? I can't see any solution or any function in the sheet you posted.

View in thread

11 replies

MikeArmstrong1-Visitor
1-Visitor
Jun 25, 2014 6:40 AM UTC

If we work look at the first fucntion is this what you were looking for?

Message was edited by: Mike Armstrong

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Jun 25, 2014 7:33 AM UTC

Message was edited by: Mike Armstrong

I still don't see the solution of yours!?

Translate
MikeArmstrong1-Visitor
1-Visitor
Jun 25, 2014 7:41 AM UTC

I must have had a moment this morning.

I have only developed one function (h.tot_j_layers_1) because I was not sure what Matti wanted.

Translate
Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
Jun 25, 2014 7:26 AM UTC

See if the attached file helps.

IMHO functions, like I provide, are more useful than static calculations, but you sure can easily turn my function into a simple one-time calculation if you insist.

@Mike: Did you post the wrong file? I can't see any solution or any function in the sheet you posted.

Translate
MikeArmstrong1-Visitor
1-Visitor
Jun 25, 2014 7:29 AM UTC

Werner Exinger wrote:

@Mike: Did you post the wrong file? I can't see any solution or any function in the sheet you posted.

Yes my mistake. I have edited my original post.

Translate
TikkaMasala12-AmethystAuthor
12-Amethyst
Jun 25, 2014 8:04 AM UTC

Hi Werner, your answer was correct, but I must admit I don't yet fully understand your efficient programming.

For Mike, I updated my original posting with the programming you had added to your file and

made a simple program for an additional layer.

Werner or Mike, could you advice how this new 4 layers system could be turned into n-layers system.

If it is not easy, I'm happy what Werner provided and try to understand that code.

Translate
Terms & ConditionsAccessibility statement