Dynamic Skip?

4.68K viewsFormulas and Functions


I’m wondering if there is any way to set the range to be skiped over (when using the Skip operation) dynamically? I was hoping I might be able to set the range with Indirect – ie:

Well Name = Exp Well Summary::Well Name Skip Indirect(“ExpWellID[“&Counta(Exp Well Summary::Well Name)&”] .. ExpWellID[LAST]”)

But I get a syntax error when trying to use Indirect with Skip. Is there any other way to do this?

Many thanks


[b:1j0j0op1]I have an example about financial model of power plant:[/b:1j0j0op1]
– Total operation years = 30 (so the Category “Year” have 30 items: ‘1’,’2′, …, ’30’)
– Loan repayment time [LRT] = 10 years
– Depreciation time of Construction [DTC] = 25 years

In the functions of ALL ROWS in matrix “Loan Repayment Calculation” I have to write: [color=”Blue”]… skip ‘1’..’10′[/color]
Same with matrix “Depreciation Calculation”: [color=”Blue”]… skip ‘1’..’25′[/color]

My problem is that when I change [LRT] or [DTC], I have to rewrite all of the functions above. [b:1j0j0op1]It’s very tired![/b:1j0j0op1]
Is there any way to write functions with “dynamic skip”? (maybe like: … skip #year = 1 to #year = [LRT] :D)

[i:1j0j0op1]More advance: any way to create automatically the number of Items of Category “Year” when I change the Total operation years?[/i:1j0j0op1]


You are viewing 1 out of 7 answers, click here to view all answers.