using aliases for subscripts
Posted: Tue Apr 17, 2007 5:49 pm
Hi
I have a model that uses subscripts representing different customer segmentation.
Depending on the agency, the segmentation may vary.
For instance in one agency, it is better to choose a class of customer that rent
More or less than 100 kilometer per day, in another it may be more or less than 200 kilometer a day. I would call both subscripts c1s100 and c1s200 if they represent renting one day during the week for instance.
Using the same model, if I want to switch from one agency to another I am obliged to modify the subscripts and some of the equations.
On top of that if I want to compare the results of different agencies I cannot do it because
if the model has the subscripts from one agency, the results coming from other agencies will not show. The segmentation may change too with the time.
One of the solution is to have a list of subscripts say (s1-s15) the same for all agencies, knowing that the subscript s3 for example will not have the same meaning for different agencies. It is then not necessary to modify the equations, if the sets of subscripts are correctly mapped.
But with this solution, on the results, one looses the meaning of the subscripts, one has only
s1,s2 etc… which is not practical.
Is there a way to keep at the same time the same model for different sets of subscripts, while
making it possible to see what is really behind the word s10 for instance.
The ideal would be to use aliases, the aliases being loaded from an excel spreadsheet and being different with each run.
Regards and thanks in advance.
JJ
I have a model that uses subscripts representing different customer segmentation.
Depending on the agency, the segmentation may vary.
For instance in one agency, it is better to choose a class of customer that rent
More or less than 100 kilometer per day, in another it may be more or less than 200 kilometer a day. I would call both subscripts c1s100 and c1s200 if they represent renting one day during the week for instance.
Using the same model, if I want to switch from one agency to another I am obliged to modify the subscripts and some of the equations.
On top of that if I want to compare the results of different agencies I cannot do it because
if the model has the subscripts from one agency, the results coming from other agencies will not show. The segmentation may change too with the time.
One of the solution is to have a list of subscripts say (s1-s15) the same for all agencies, knowing that the subscript s3 for example will not have the same meaning for different agencies. It is then not necessary to modify the equations, if the sets of subscripts are correctly mapped.
But with this solution, on the results, one looses the meaning of the subscripts, one has only
s1,s2 etc… which is not practical.
Is there a way to keep at the same time the same model for different sets of subscripts, while
making it possible to see what is really behind the word s10 for instance.
The ideal would be to use aliases, the aliases being loaded from an excel spreadsheet and being different with each run.
Regards and thanks in advance.
JJ