从excel导出的MPS文件有效但我无法理解 [英] MPS file exported from excel is valid but I can't understand it

问题描述

您好，

我曾经使用Excel示例"AirlineAllocationMIP.xlsx"检查导出到MPS功能。

我无法理解生成的MPS文件。 （见下文，奇怪的"（"这里和那里的字符）

另外，用SCIP解决这个MPS产生了不可行性。

我无法决定问题在哪一方。

I used to Excel sample "AirlineAllocationMIP.xlsx" to check the export to MPS functionality.
I could not make sense of the MPS file that was generated. (see below, the strange "(" characters here and there)
In addition, solving this MPS with SCIP produced an infeasibility.
I can't decide on which side the problem is.

是否有一些关于用于翻译为MPS格式的规则的文档？

此功能是否存在已知问题，除此之外生成的文件的奇怪内容？

Is there some documentation about the rules used for the translation to the MPS format?
Are there known problems with this functionality, beside the strange content of the generated file?

下面，我粘贴生成的完整MPS。

Below, I paste the full MPS that was generated.

谢谢

NAME          MODEL
ROWS
 G  c1      
 G  c1#1    
 G  c1#2    
 G  c1#3    
 G  c1#4    
 E  c2      
 E  c2#1    
 E  c2#2    
 E  c2#3    
 N  g       
COLUMNS
    INTMARK   'MARKER'                 'INTORG'
    Bumped(0  c1         1             g          26.0000000260
    Allocati  c1         16            c2         1
    Allocati  g          72           
    Allocat0  c2#1       1            
    Allocat1  c2#2       1            
    Allocat2  c1         9             c2#3       1
    Allocat2  g          68           
    Allocat3  c1         1             g          52
    Bumped(1  c1#1       1             g          26.0000000260
    Allocat4  c1#1       15            c2         1
    Allocat4  g          84           
    Allocat5  c1#1       10            c2#1       1
    Allocat5  g          60           
    Allocat6  c1#1       5             c2#2       1
    Allocat6  g          40           
    Allocat7  c1#1       11            c2#3       1
    Allocat7  g          64           
    Allocat8  c1#1       1             g          52
    Bumped(2  c1#2       1             g          14
    Allocat9  c1#2       28            c2         1
    Allocat9  g          72           
    Alloca10  c1#2       14            c2#1       1
    Alloca10  g          64           
    Alloca11  c2#2       1            
    Alloca12  c1#2       22            c2#3       1
    Alloca12  g          68           
    Alloca13  c1#2       1             g          28
    Bumped(3  c1#3       1             g          14
    Alloca14  c1#3       23            c2         1
    Alloca14  g          64           
    Alloca15  c1#3       15            c2#1       1
    Alloca15  g          56           
    Alloca16  c1#3       7             c2#2       1
    Alloca16  g          36           
    Alloca17  c1#3       17            c2#3       1
    Alloca17  g          60           
    Alloca18  c1#3       1             g          28
    Bumped(4  c1#4       1             g          2.00000000200
    Alloca19  c1#4       81            c2         1
    Alloca19  g          40           
    Alloca20  c1#4       57            c2#1       1
    Alloca20  g          36           
    Alloca21  c1#4       29            c2#2       1
    Alloca21  g          24           
    Alloca22  c1#4       55            c2#3       1
    Alloca22  g          40           
    Alloca23  c1#4       1             g          4
    INTMARK   'MARKER'                 'INTEND'
RHS
    RHS       c1         250           c1#1       120
    RHS       c1#2       180           c1#3       90
    RHS       c1#4       600           c2         10
    RHS       c2#1       19            c2#2       25
    RHS       c2#3       15           
BOUNDS
ENDATA

 

推荐答案

1. 我的猜测是'）'字符与不正确地转换名称有关原始模型中的决定。我认为他们是"_"人物吧？这很容易通过查找/替换来解决....
   
2. Erwin在这个帖子中指出了MPS导入/导出具有二进制或整数变量的模型的一些问题：http：//social.msdn .microsoft.com /论坛/ EN / solverfoundation /线程/ 7669081f-18AC-445B-850E-434bff80da38。我没有仔细检查你的b $ b b，但我推测不可行性的根本原因是相关的。

Nate

这篇关于从excel导出的MPS文件有效但我无法理解的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！