[求助]lingo运行结果以矩阵保存在excel
本帖最后由 HNzhangjie 于 2012-8-19 13:36 编辑求高手指教，怎样把lingo求出的结果保存在excel，要矩阵形式
代码model:
sets:
v/1..50/:n;
w/1..4/:t;
links(v,w):p,s,x,z;
endsets
data:
p=@file('数据ls.txt');
n=@file('数据ls.txt');
t=@file('数据ls.txt');
s=@file('数据ls.txt');
enddata
min=@sum(links(i,j):p(i,j)*x(i,j))+@sum(w(J):t(J)*@sum(v(I):z(I,J)));
!目标函数;
@for(v(I):@for(w(J):x(I,J)<=s(I,J)));
!库存约束;
@for(v(I):@sum(w(J):x(I,J))=n(I));
!购买量;
@for(v(I):@for(w(J):z(I,J)=@if(x(I,J)#gt#0,1,0)));
!取运费01 有为1 无为0;
@for(links:@gin(x));
!限制x为整数;
end
数据ls.txt为
9.35 9.79 9.68 9.35
19.2 19.44 19.44 21.6
10.53 10.4 11.7 11.18
30.26 27.88 30.26 27.88
29.24 30.6 28.56 27.88
24.36 23.78 24.07 25.23
21.32 22.36 22.88 20.8
23.24 20.44 22.12 23.52
10.08 9.6 9.24 9.6
7.5 7 8.4 7.8
15.12 12.6 15.12 12.78
12.32 11.36 12.16 12
17.71 16.1 17.94 18.17
10.53 11.05 10.53 10.66
20.79 21.6 21.33 18.9
15.75 17.43 15.75 17.85
14.91 17.01 17.22 16.38
13.28 12.16 11.52 13.28
25.56 26.64 25.2 25.56
22.72 23.04 23.04 24
23.68 22.4 24 23.04
24.09 24.42 23.76 23.1
19.6 20.72 20.16 19.6
38.88 36.96 36.96 40.32
25.84 26.52 26.18 25.84
28.7 29.05 28 28.35
22.62 21.75 23.49 24.65
25.6 24.32 24.32 25.92
27.39 27.06 26.73 25.08
35.7 32.76 33.18 31.5
48.38 48.38 45.43 48.97
26.95 27.3 28.35 29.4
9.96 9.72 8.88 9.48
79.17 68.73 69.6 71.34
54.51 64.86 48.3 61.41
32 28.8 32 34.4
45.9 48.06 48.6 50.22
13.14 13.86 12.6 14.76
107.88 99.76 109.04 82.36
55.44 57.6 54.72 62.64
24.96 25.6 24.64 29.76
39.27 44.37 40.29 36.21
65.52 72.24 71.4 63.84
80.1 82.77 75.65 68.53
12.8 11.2 11.2 12
38.95 34.85 36.08 36.9
49.8 46.8 52.2 55.8
55.5 64.38 54.76 57.72
52.51 54.87 48.97 47.79
57.6 48 46.72 49.28~
2 1 1 5 2 2 1 4 2 3 2 1 5 1 1 1 4 4 1 2 2 8 1 5 3 1 5 3 3 4 1 1 2 5 5 1 2 1 5 1 1 1 3 8 3 10 1 5 5 1~
5 10 10 15~
8 10 5 8
0 2 9 4
1 3 4 8
2 2 3 0
2 9 1 7
9 5 6 4
7 2 7 9
4 2 8 9
1 7 7 6
3 4 7 4
1 7 10 3
6 5 2 5
3 3 3 8
10 0 10 10
9 4 0 10
4 2 10 0
5 2 1 1
7 3 4 1
8 6 2 10
5 10 2 3
2 8 10 2
2 3 7 0
10 1 10 7
0 6 7 4
0 7 2 8
8 9 8 9
5 3 9 7
2 0 6 9
4 1 6 4
0 7 1 9
8 0 6 2
0 4 2 1
10 0 8 3
4 3 8 7
8 8 0 8
9 10 10 9
7 5 5 10
1 2 2 8
7 9 5 3
8 4 9 8
4 4 4 3
8 5 3 3
10 1 5 0
1 2 3 2
7 5 6 5
5 6 5 6
2 10 3 10
9 4 5 4
4 3 2 7
8 3 0 10~
结果输的出(太长了，没有粘进来)，但是我想输出一个x的矩阵50*4的，如果有高手知道的话，望指教→_→，谢谢~ {:soso_e111:} 没有输入这个符号，输入的是@for(v(I):@for(w(J):x(I,J)<=s(I,J)));
!库存约束;
@for(v(I):@sum(w(J):x(I,J))=n(I));
!购买量;
@for(v(I):@for(w(J):z(I,J)=@if(x(I,J)#gt#0,1,0)));
!取运费01 有为1 无为0;
@for(links:@gin(x));
!限制x为整数;
不知道怎么就显示表情了
页:
[1]