设置步骤如下:
1、单击“文件——选项——加载项——(Excel加载项)转到”,出现“加载宏”对话框,如下图所示。选择“规划求解加载项”,单击“确定”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f636afc379310a55eeb07a88bb4543a982261031?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、此时,在“数据”选项卡中出现带有“规划求解”按钮的“分析”组,如下图所示。![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/21a4462309f790523823e34200f3d7ca7bcbd58a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、使用Excel求解线性规划问题时,电子表格是输入和输出的载体,因此设计良好的电子表格,更加易于阅读。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b292df5e0fe99254189cc2c38a85edf8cb171c1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后将其复制到下方相应的单元格中。单击“数据——分析——规划求解”,出现如下图所示的“规划求解参数”对话框,设计相应的参数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/622762d0f703918f31ed99b65d3d269759eec48a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、并且单击“添加”按钮,添加相应的约束,如下图所示。![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4abd78d66f05f790529922d1ed?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9198618367adab43bc1bf3f87d4b31c8701e4bd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、设置好参数后,单击“规划求解参数”对话框中的“求解”按钮,结果如下图所示。![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef3ea30d5af1faaf51f2de66c1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)