Decision Optimization

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

//In *.mod file:range t=2016..2031; //{string} cost=...;float Lifetimecost_est[ti in t][c in cost]=ti;tuple Lifetimecost_tup{  int t;  string cost;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,Lifetimecost_est[i][j]> | i in t, j in cost};execute { 	writeln(Lifetimecost_tup,Lifetimecost_exp); };//In *.dat filecost={purchase,maintanence,fuel,detour,range,wait,idio};SheetConnection Outputs("C:\\Users\\jzhong17\\OneDrive - azureford\\Documents\\CPLEX\\OPL project\\Outputs.xlsx");Lifetimecost_exp to SheetWrite(Outputs,"Test!F2:ZZ500");​

This simplified model will only generate a 14×24 data, but I leave a F2:zz500 space in excel still generate the error of "Description Resource Path Location Type
Exception from IBM ILOG Concert: excel: range width does not fit the arity of the tuple. Test Unknown OPL Problem Marker".

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

//In *.mod file:range t=2016..2031; //{string} cost=...;float Lifetimecost_est[ti in t][c in cost]=ti;tuple Lifetimecost_tup{  int t;  string cost;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,Lifetimecost_est[i][j]> | i in t, j in cost};execute { 	writeln(Lifetimecost_tup,Lifetimecost_exp); };//In *.dat filecost={purchase,maintanence,fuel,detour,range,wait,idio};SheetConnection Outputs("C:\\Users\\jzhong17\\OneDrive - azureford\\Documents\\CPLEX\\OPL project\\Outputs.xlsx");Lifetimecost_exp to SheetWrite(Outputs,"Test!F2:ZZ500");​

This simplified model will only generate a 14×24 data, but I leave a F2:zz500 space in excel still generate the error of "Description Resource Path Location Type
Exception from IBM ILOG Concert: excel: range width does not fit the arity of the tuple. Test Unknown OPL Problem Marker".

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

//In *.mod file:range t=2016..2031; //{string} cost=...;float Lifetimecost_est[ti in t][c in cost]=ti;tuple Lifetimecost_tup{  int t;  string cost;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,Lifetimecost_est[i][j]> | i in t, j in cost};execute { 	writeln(Lifetimecost_tup,Lifetimecost_exp); };//In *.dat filecost={purchase,maintanence,fuel,detour,range,wait,idio};SheetConnection Outputs("C:\\Users\\jzhong17\\OneDrive - azureford\\Documents\\CPLEX\\OPL project\\Outputs.xlsx");Lifetimecost_exp to SheetWrite(Outputs,"Test!F2:ZZ500");​

This simplified model will only generate a 14×24 data, but I leave a F2:zz500 space in excel still generate the error of "Description Resource Path Location Type
Exception from IBM ILOG Concert: excel: range width does not fit the arity of the tuple. Test Unknown OPL Problem Marker".

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

//In *.mod file:range t=2016..2031; //{string} cost=...;float Lifetimecost_est[ti in t][c in cost]=ti;tuple Lifetimecost_tup{  int t;  string cost;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,Lifetimecost_est[i][j]> | i in t, j in cost};execute { 	writeln(Lifetimecost_tup,Lifetimecost_exp); };//In *.dat filecost={purchase,maintanence,fuel,detour,range,wait,idio};SheetConnection Outputs("C:\\Users\\jzhong17\\OneDrive - azureford\\Documents\\CPLEX\\OPL project\\Outputs.xlsx");Lifetimecost_exp to SheetWrite(Outputs,"Test!F2:ZZ500");​

This simplified model will only generate a 14×24 data, but I leave a F2:zz500 space in excel still generate the error of "Description Resource Path Location Type
Exception from IBM ILOG Concert: excel: range width does not fit the arity of the tuple. Test Unknown OPL Problem Marker".

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

//In *.mod file:range t=2016..2031; //{string} cost=...;float Lifetimecost_est[ti in t][c in cost]=ti;tuple Lifetimecost_tup{  int t;  string cost;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,Lifetimecost_est[i][j]> | i in t, j in cost};execute { 	writeln(Lifetimecost_tup,Lifetimecost_exp); };//In *.dat filecost={purchase,maintanence,fuel,detour,range,wait,idio};SheetConnection Outputs("C:\\Users\\jzhong17\\OneDrive - azureford\\Documents\\CPLEX\\OPL project\\Outputs.xlsx");Lifetimecost_exp to SheetWrite(Outputs,"Test!F2:ZZ500");​

This simplified model will only generate a 14×24 data, but I leave a F2:zz500 space in excel still generate the error of "Description Resource Path Location Type
Exception from IBM ILOG Concert: excel: range width does not fit the arity of the tuple. Test Unknown OPL Problem Marker".

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

//*.mod range t=2016..2031; //{string} cost=...;float Lifetimecost_est[ti in t][c in cost]=ti;float data[ti in t]=ti;execute{      for (var ti in t) {       Lifetimecost_est[ti][c in cost]=Lifetimecost_est[ti][c]*Math.pow((1-0.005),(ti-2016));}writeln(Lifetimecost_est);};//*.datcost={purchase,maintanence,fuel,detour,range,wait,idio};​

Hi Renaud, here is the example. I have this multi-dimensional parameter Lifetimecost_est, I would like to let it degrades by 5% annually. In this simplified example, the values are the same across set c. But the idea is let the value change by 5% for all cost categories.
The above statement will yield error message. I need help in correcting this code. I have been searching online for a while about the solution of this. 

Thanks a lot!

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}

//*.mod range t=2016..2031; //{string} cost=...;float Lifetimecost_est[ti in t][c in cost]=ti;float data[ti in t]=ti;execute{      for (var ti in t) {       Lifetimecost_est[ti][c in cost]=Lifetimecost_est[ti][c]*Math.pow((1-0.005),(ti-2016));}writeln(Lifetimecost_est);};//*.datcost={purchase,maintanence,fuel,detour,range,wait,idio};​

Hi Renaud, here is the example. I have this multi-dimensional parameter Lifetimecost_est, I would like to let it degrades by 5% annually. In this simplified example, the values are the same across set c. But the idea is let the value change by 5% for all cost categories.
The above statement will yield error message. I need help in correcting this code. I have been searching online for a while about the solution of this. 

Thanks a lot!

tuple Lifetimecost_tup{  int t;  string cost;  string vehicle;  string vmtgrp;  string segment;  float value;}{Lifetimecost_tup} Lifetimecost_exp= {<i,j,k,z,l,Lifetimecost_est[i][j][k][z][l]> | i in t, j in cost, k in vehicle, z in vmtgrp,l in segment};​Lifetimecost_exp to SheetWrite(Outputs,"Lifetimecost!F2:AC50000");

2. I have a parameter needs to multiply a yearly 0.5% growth rate starting 2016. It is also a multi-dimensional data MileB_seg[ti][s][vmt], ti is the year set.
What I did is putting it in the script 

float MileB_seg[t][segment][vmtgrp];execute{for (var ti in t) {   MileB_seg[ti][s][vmt]=MileB_seg[ti][s][vmt]*Math.pow((1-0.005),(ti-2016));}}