当前时间： 2026-05-06 23:34:47
分类：办公文件
评论(0)
一堆数字中凑出目标值(Excel规划求解)最近接受了一份工作，真是绝了，无前任、五交接、无文档……真是焦头烂额。也不知道结果怎么出来的，就一个结果，逼得没办法，竟然用起了规划求解（Excel版的），我的所学终于有所用了😓，看效果，需要自取。这个求解方法叫0-1线性规划，就是一堆数分别乘以0或者1。乘以0，就是舍弃了这个数，乘以1就是保留了这个数，让后用Excel线性规划的方法反复测试哪些数乘以1、哪些数乘以0，可以得到目标单元格的值。数值和可变单元格的相乘后求和用了公式SUMPRODUCT，这个函数的意义就是：两组个数一致的单元格，一一对应相乘，并相加所有的乘积的和。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-07 10:53:53 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/581266.html
- 运行时间 : 0.094829s [ 吞吐率：10.55req/s ] 内存消耗：4,672.08kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=44be408aefb3ff4c1651348109b00cf3
- CONNECT:[ UseTime:0.000564s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000767s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000333s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000293s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000557s ]
- SELECT * FROM `set` [ RunTime:0.000193s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000554s ]
- SELECT * FROM `article` WHERE `id` = 581266 LIMIT 1 [ RunTime:0.000375s ]
- UPDATE `article` SET `lasttime` = 1778122433 WHERE `id` = 581266 [ RunTime:0.004670s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000305s ]
- SELECT * FROM `article` WHERE `id` < 581266 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
- SELECT * FROM `article` WHERE `id` > 581266 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000390s ]
- SELECT * FROM `article` WHERE `id` < 581266 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000952s ]
- SELECT * FROM `article` WHERE `id` < 581266 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000606s ]
- SELECT * FROM `article` WHERE `id` < 581266 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000713s ]
0.096469s
夜雨聆风