Skip to main content
T
TikkaMasala12-Amethyst
12-Amethyst
June 25, 2014
Solved

Splitting of layers

  • June 25, 2014
  • 11 replies
  • 3302 views

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.

Best answer by Werner_E

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.

11 replies

M
MikeArmstrong1-Visitor
1-Visitor
June 25, 2014

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

Message was edited by: Mike Armstrong

Werner_E
Werner_E25-Diamond I
25-Diamond I
June 25, 2014

Message was edited by: Mike Armstrong

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

M
MikeArmstrong1-Visitor
1-Visitor
June 25, 2014

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.

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
June 25, 2014

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.

M
MikeArmstrong1-Visitor
1-Visitor
June 25, 2014

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.

T
TikkaMasala12-AmethystAuthor
12-Amethyst
June 25, 2014

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.

Terms & ConditionsAccessibility statement