Programming loop

[JB_10220769]

I have inputs which needs to be used for further calculation For ex POP1_2.1 will be used to calculate CO1_2.1 and CO1_2.1 will be used for calculating POP next series and so on. I need some help to formulate programme to carry out this on loop and give the output could someone help? 

[LucMeekes]

You can write a program for this, but it will be as much work as you've already done to put down all the assignment formulae in your sheet.

If you want to put this efficiently in a program, you will need to use indexes instead of literal subscripts to your arrays AF, DF and M.

Since you've hidden their definitions in protected areas, that's something you will need to do.

Success!
Luc

[Raiko · Accepted solution]

Hi,

here is an example how to do it in Mathcad. Hope, it helps.

Raiko