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?
[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] )
[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]
Hi – You could like the Year category to a new matrix, then set a flag to indicate when the calculations should occur for Loan and Depreciation.
Then you can use this flag in an IF or SWITCH function, and avoid having to use a SKIP.
You can then simply change the flags to adjust the calculation.
Please see attached.
Thanks for your solution of IF and SWITCH functions!
I’m agree avoid having to use a SKIP in this case but I think it’s better if we can use SKIP with CLAUSE or CONDITION
Please help me about [b:ihr8d25n]automatic creating[/b:ihr8d25n] the number of Items of Year Category when I [b:ihr8d25n]change[/b:ihr8d25n] “Total operation years”?
Any update to this question? I know it’s four years old but it’s a worthwhile question. I find myself constantly wishing Quantrix had this capability too. Being able to manually override calculated values would make my models so much more user-friendly (since people are used to doing just that in Excel – e.g. as each month’s Actuals are known, one just manually types in the Actuals in place of the formula that was previously calculating the Budget values).