标题:Excel2007 “规划求解”
作者:jinwyp
时间:9/24 16:07
答案。如图3：
http://blog.officeba.com.cn/upload/200806070919340210.gif
图3
可以看出，D4单元格（黄色），是目标单元格，是包含公式的。
C4单元格（灰色），是可变单元格，是一个数值，没有公式。求解过程：
规划求解就是给C4单元格一个值0.12，看D4单元格等于3360，把它和结果3660比较，计算机发现它不是答案，返回给C4赋予一个新值0.121，结果D4单元格为3363，不对，计算机又给C4赋予另一值，这样不断尝试，直到得到符合计算机要求的答案出现，才停止尝试。其实这个过程对人来说是很漫长和枯燥的，但是对计算机是非常快速 ..
下页 上页
回复本帖|发新话题
回复列表 (4)
#1 [yanshen 9/24 16:55] 回复本帖
割腕者的天堂
===================
#2 [jinwyp 9/24 22:11] 回复本帖
ls什么意思
===================
#3 [yanshen 9/24 22:44] 回复本帖
下这个电影 记录一下
===================
#4 [yanshen 10/14 18:32] 回复本帖
ear Mr. Bentley ,
I am writing to express my strong interest in the position of Director of Human Resources at your company, as described in an advertisement on jobsearch.com. I am interested in your company, which has a reputation for company loyalty and the professional development of its staff. I believe that my background in personnel administration, my excellent communication skills, and my knowledge of your industry make me a strong candidate for the position.
As the assistant manager in the Human Resources department of my present company, I have had many responsibilities. I have researched legal matters, wrote reports for company policy, hired and trained new employees. Last year I organized an important project to analyze and make recommendations on the health care policy of our international employees. Since I have previously worked in both product development and sales and marketing. I have a wider range of experience than many others in my field. I believe that I apply this to my day-to-work in ways that make me a more effective leader of a diverse staff...
===================
<<下一主题
>>上一主题
返回板块