由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Statistics版 - optimization using Solver in Excel
相关主题
求教 SAS 用于简单PROTFOLIO 分析考SAS adv看Prep Guide好还是online tutor好?
solve an optimization model with integral as constraints请问版上了解credit risk的牛人,
SAS 如何实现excel solver的功能SAS batch mode的问题
nonlinear constraint in SAS一个实际应用的SAS问题
Re: help, how to make a data normal?[合集] a small question on SAS data import
关于SAS Advance 9 的考试体会Is there a way to convert data in pdf file into Excel or SAS table?
求教: R function紧急求助,如何快速掌握SAS
请推荐能够optimizing with constrains 的软件[合集] 问一个SAS 从excel import数据的问题
相关话题的讨论汇总
话题: solver话题: excel话题: sas话题: share
进入Statistics版参与讨论
1 (共1页)
p**********l
发帖数: 1160
1
Has anybody used the Solver function in Excel?
If you do, can you share the experience?
I have googled and it seems that Solver is a very powerful tool and we want
to use it for optimization projects.
If you want to share something about optimization and the methods you have
known, especially in SAS, I would appreciate that too.
s*****9
发帖数: 108
2
I have used excel solver for some simple optimization problems. Constraints
are linear, it's good to use that for illustration of how optimization
solver works. When the number of variables goes large, I use SAS/OR,
commands like "solve with nlpc " etc.
p**********l
发帖数: 1160
3
thank you so much.

Constraints

【在 s*****9 的大作中提到】
: I have used excel solver for some simple optimization problems. Constraints
: are linear, it's good to use that for illustration of how optimization
: solver works. When the number of variables goes large, I use SAS/OR,
: commands like "solve with nlpc " etc.

1 (共1页)
进入Statistics版参与讨论
相关主题
[合集] 问一个SAS 从excel import数据的问题Re: help, how to make a data normal?
[合集] how to combine ATE files using R关于SAS Advance 9 的考试体会
Import excel file to sas (the first 8 or more observations求教: R function
How to search all data files in a folder?请推荐能够optimizing with constrains 的软件
求教 SAS 用于简单PROTFOLIO 分析考SAS adv看Prep Guide好还是online tutor好?
solve an optimization model with integral as constraints请问版上了解credit risk的牛人,
SAS 如何实现excel solver的功能SAS batch mode的问题
nonlinear constraint in SAS一个实际应用的SAS问题
相关话题的讨论汇总
话题: solver话题: excel话题: sas话题: share