Excel Solver ( ). , (, - ). , , . . , . , .
( Excel Solver) MS Excel, , ,
Excel . Excel 2007, Microsoft Office, Excel, . Excel . .
1. , .
2. , , :
Excel 2007 / / ;
Set Target Cell ( ) Solver ( ) .
3. Equal To (), , ( ), Min ( ) Value of (). .
4. By Changing Cells ( ), .
5. Subject to the Constraints (). Add () Add Constraint ( ) .
6. Options (), ( ), ( , , )
7. Solver (), .
8. Solver Results ( ), Keep Solve Solution ( ) Restore Original Values ( ).
9. .
- , . , 32 767 ( ); 100, , .
|
|
- ().
- . , .
- , . , .
- . , , .
- . , , .
- , .
- , .
- .
- , , .
- ,
, .
- .
- .
- , . .
- , . , , , .
- , , .
- , , , . , .