|
无名阿亮: 回帖置顶 2021-09-30 21:38:37
问题:
在部分数据下,该代码会出现错误69;
但是其他数据使用改代码正常
代码是:
model:
sets:
m/1..6/:;
o/1..5/:h;
ajz(m,o):p,x,y,s;
endsets
data:
p=@ole('D:\ipython\cost.xlsx','price11');
h=8.8 6.1 2.0 4.2 5.0;
enddata
max=@sum(m(i):@sum(o(j):1500*y(i,j)-50*s(i,j)-p(i,j)*x(i,j)));
@for(m(i):y(i,1)+y(i,2)<=200);
@for(m(i):y(i,3)+y(i,4)+y(i,5)<=250);
@for(m(i):@sum(o(j):y(i,j)*h(j))/@sum(o(j):y(i,j))<=6);
@for(m(i):@sum(o(j):y(i,j)*h(j))/@sum(o(j):y(i,j))>=3);
@for(o(j):s(1,j)=500);
@for(o(j):@for(m(i):s(i,j)+x(i,j)<=1000));
@for(o(j):s(2,j)=s(1,j)+x(1,j)-y(1,j));
@for(o(j):s(3,j)=s(2,j)+x(2,j)-y(2,j));
@for(o(j):s(4,j)=s(3,j)+x(3,j)-y(3,j));
@for(o(j):s(5,j)=s(4,j)+x(4,j)-y(4,j));
@for(o(j):s(6,j)=s(5,j)+x(5,j)-y(5,j));
@for(o(j):s(6,j)+x(6,j)-y(6,j)=500);
@for(m(i):@for(o(j):s(i,j)>=0));
k=@sum(m(i):@sum(o(j):1500*y(i,j)-50*s(i,j)-p(i,j)*x(i,j)));
k>0;
data:
@ole('D:\ipython\cost.xlsx','result11','cost11','used11')=k,x,y;
错误:
--------------------------------------------------------------------------------
[Error Code: 69]
Undefined arithmetic operation.
The error occurred in row index: 25
--------------------------------------------------------------------------------
报错数据:
1100 1200 1300 1100 1150
1443 1443 1342 1098 1403
1342 1708 1872 1440 1368
1596 1463 1992 1992 2075
1440 1728 2820 2068 1974
1395 1550 2940 1680 2835 |
|