Đang chuẩn bị liên kết để tải về tài liệu:
beginning excel what if data analysis tool phần 6

Giới hạn báo cáo danh sách mục tiêu của mô hình tế bào và các tế bào có thể điều chỉnh với giá trị tương ứng của họ, giới hạn trên và dưới, và các giá trị mục tiêu. Sử dụng loại hình này của báo cáo cho các vấn đề mà không có hạn chế số nguyên. | 74 CHAPTER 4 SOLVER The Limits report lists the model s target cell and the adjustable cells with their respective values lower and upper limits and target values. Use this type of report for problems that do not contain integer constraints. To create a report click one or more report types in the Reports box in the Solver Results dialog box see Figure 4-9 shown earlier in the chapter and then click OK. The corresponding reports are created on new worksheets in the current workbook one report per new worksheet. Interpreting the Answer Report The Answer report shown in Figure 4-11 lists the following The target cell s and adjustable cells address their names if ones were assigned their original values before Solver was run and their final values after Solver was run The constraints cell addresses their names if ones were assigned the cells values the constraints formulas the constraints statuses Binding meaning a slack value of 0 or Not Binding meaning a nonzero slack value and the constraints slack values A B I c __LD_L Microsoft Excel 11.0 Answer Report Worksheet Solver Exercises.xIsJBug Counts Report Created 6 30 2005 8 30 21 PM F I G I E c Target Cell Value Of _2 2 4 2 6 7 Cell Name Original Value Final Value 8 G 7 Averages Totals 28 25 9 10 11 Adjustable Cells 12 Cell Name Original Value Final Value 13 B 2 Week 1 Monday 2 2 14 c 2 Week 1 Tuesdav 6.5 5.75 34 35 Constraints 36 Cell Name Cell Value Formula Status Slack 37 B 2 Week 1 Monday 2 B 2 2 Binding 0 38 c 2 Week 1 Tuesday 5.75 c 2 2 Not Binding 3.75 39 D 2 Week 1 Wednesday 5.75 D 2 2 Not Binding 3.75 40 E 2 Week 1 Thursday 5.75 E 2 2 Not Binding 3.75 41 F 2 Week 1 Friday 5.75 F 2 2 Not Binding 3.75 Figure 4-11. The Solver Answer report panes split for readability A slack value is the absolute difference in values between the left side and the right side of the constraint. The left side of the constraint is the constraint cell s value and the right side of the constraint is a .