Grader case 4 - setting up solver
Give this one a try later!
set objective: select cell max? min?
variable cells: cells that will be changed to hit objective within constraints
constraints: add > cell # (only variable cells), select inequalities, enter
constraint (if want to be only whole #s, use int instead of ineq)
, Grader case 2 - advanced filter
Give this one a try later!
-shift table down
-copy and paste headings in new space
-enter filter requirements under headings
- data > advanced filter
Grader case 4 - custom format
Give this one a try later!
right click cell> format cell> custom > type > "words to show instead of
number"
use semi colon if want to show nothing
Grader case 4 - scenario summary report
Give this one a try later!
data>what if>scenario manager> summary > scenario summary
Grader case 3 - PERCENTILE.EXC
Give this one a try later!
Give this one a try later!
set objective: select cell max? min?
variable cells: cells that will be changed to hit objective within constraints
constraints: add > cell # (only variable cells), select inequalities, enter
constraint (if want to be only whole #s, use int instead of ineq)
, Grader case 2 - advanced filter
Give this one a try later!
-shift table down
-copy and paste headings in new space
-enter filter requirements under headings
- data > advanced filter
Grader case 4 - custom format
Give this one a try later!
right click cell> format cell> custom > type > "words to show instead of
number"
use semi colon if want to show nothing
Grader case 4 - scenario summary report
Give this one a try later!
data>what if>scenario manager> summary > scenario summary
Grader case 3 - PERCENTILE.EXC
Give this one a try later!
