QQ登录

只需要一步,快速开始

 注册地址  找回密码
查看: 1451|回复: 1
打印 上一主题 下一主题

由于数据较多,需要用excel导入数据,总是报错无法找到excel表

[复制链接]
字体大小: 正常 放大
ruby2017        

1

主题

9

听众

4

积分

升级  80%

该用户从未签到

自我介绍
奋斗啊
跳转到指定楼层
1#
发表于 2017-3-8 06:15 |只看该作者 |倒序浏览
|招呼Ta 关注Ta
求大神指点!本人刚学lingo软件,想用最小二乘法计算几个矩阵,由于数据较多,需要用excel导入数据,总是报错无法找到excel表。以下为我写的,也不知道还有没有别的错误,求大神指点!十万火急!
SETS:
x1/1..42/:g1,g2,i1,i2,p,h,h1,j1,j2;
y1/1..42/:k1,k2,m1,n1,o1,m2,n2,o2,q;
link(x1,y1):a,b,cc,d,e,f,a_,b_,c_,d_,e_,f_;
endsets
data:
a_=@ole('C:\Users\Administrator\Desktop\lingo.xlsx','a_');
b_=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','b_');
c_=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','c_');
d_=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','d_');
e_=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','e_');
f_=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','f_');
g2=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','cm');
h=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','mi');
i2=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','im');
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','a')=a;
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','b')=b;
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','cc')=cc;
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','d')=d;
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','e')=e;
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','f')=f;
g1=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','cd');
h1=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','mi_');
i1=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','id');
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','g')=m1;
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','h')=n1;
@ole('C:/Users/Administrator/Desktop/lingo.xlsx','i')=o1;
m2=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','g_');
n2=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','h_');
o2=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','i_');
p=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','x_t');
q=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','x');
k1=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','en_t');
k2=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','ep_t');
j1=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','en');
j2=@ole('C:/Users/Administrator/Desktop/lingo.xlsx','ep');
enddata
min=@sum(link(i,j):(a(i,j)-a_(i,j)^2/a_(i,j)+@sum(link(i,j):(b(i,j)-b_(i,j)^2/b_(i,j)+@sum(link(i,j):(cc(i,j)-c_(i,j)^2/c_(i,j)+@sum(link(i,j):(d(i,j)-d_(i,j)^2/d_(i,j)+@sum(link(i,j):(e(i,j)-e_(i,j)^2/e_(i,j)+@sum(link(i,j):(f(i,j)-f_(i,j)^2/f_(i,j)+@sum(y1(j):(m1(j)-m2(j)^2/m2(j))+@sum(y1(j):(n1(j)-n2(j)^2/n2(j))+@sum(y1(j):(o1(j)-o2(j)^2/o2(j));
@for(x1(i):@sum(y1(j):a(i,j)+b(i,j)+cc(i,j))+g1(i)+i1(i)=p(i)-j1(i)-j2(i));
@for(x1(i):@sum(y1(j):d(i,j)+e(i,j)+f(i,j))+g2(i)+i2(i)=h(i));
@for(x1(i):@sum(y1(j):f(i,j))=h1(i));
@for(y1(j):@sum(xi(i):a(i,j)+d(i,j))+m(j)=q(j)-k1(j)-k2(j));
@for(y1(j):@sum(xi(i):b(i,j)+e(i,j))+n(j)=k1(j));
@for(y1(j):@sum(xi(i):cc(i,j)+f(i,j))+o(j)=k2(j));
@if(link(i,j):a_(i,j)#eq#0,a(i,j)#eq#0,a_(i,j));
@if(link(i,j):b_(i,j)#eq#0,b(i,j)#eq#0,b_(i,j));
@if(link(i,j):c_(i,j)#eq#0,cc(i,j)#eq#0,c_(i,j));
@if(link(i,j):d_(i,j)#eq#0,d(i,j)#eq#0,d_(i,j));
@if(link(i,j):e_(i,j)#eq#0,e(i,j)#eq#0,e_(i,j));
@if(link(i,j):f_(i,j)#eq#0,f(i,j)#eq#0,f_(i,j));
@if(y1(j):m2(i,j)#eq#0,m1(i,j)#eq#0,m2(i,j));
@if(y1(j):n2(i,j)#eq#0,n1(i,j)#eq#0,n2(i,j));
@if(y1(j):o2(i,j)#eq#0,o1(i,j)#eq#0,o2(i,j));
end
最后显示error code50 说是for函数非正确使用?







zan
转播转播0 分享淘帖0 分享分享0 收藏收藏0 支持支持0 反对反对0 微信微信
ruby2017        

1

主题

9

听众

4

积分

升级  80%

该用户从未签到

自我介绍
奋斗啊
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册地址

qq
收缩
  • 电话咨询

  • 04714969085
fastpost

关于我们| 联系我们| 诚征英才| 对外合作| 产品服务| QQ

手机版|Archiver| |繁體中文 手机客户端  

蒙公网安备 15010502000194号

Powered by Discuz! X2.5   © 2001-2013 数学建模网-数学中国 ( 蒙ICP备14002410号-3 蒙BBS备-0002号 )     论坛法律顾问:王兆丰

GMT+8, 2024-6-17 18:19 , Processed in 0.707334 second(s), 60 queries .

回顶部