Operations Management (33:623:386)
Professor Eckstein
Instructions for Standard Printouts
Throughout the term, I will ask for "standard printouts" of your Excel
models. The standard printouts for a model consist of two things. The first
is a printout of the model as a set of values, the way it usually
appears on the screen. To get this printout, you perform the following
steps:
-
Choose Page Setup... from the File menu.
-
Click on the Sheet tab.
-
If there is no "X" in the box next to "Row and Column Headings", click
there so that one appears.
-
Click OK
-
Click on the printer icon in the toolbar, or choose
Print... from
the file menu to print the spreadsheet.
If possible, you should try to make each spreadsheet printout fit on a
single page. Under the Page tab of Page Setup..., select
"landscape" orientation, and "fit to" 1 x 1 page before you print. You
can use the Print Preview button to see how things will look when
printed.
The second printout should be as a set of formulas. It should
show the formulas in your spreadsheet; for optimization models (which will
be most of our spreadsheets), it should also clearly indicate the target
cell, the changing cells, and all constraints. Also indicate whether you
are minimizing or maximizing the target cell.
To get this printout, follow these steps:
-
Type control-tilde (hold down "ctrl" and type the key marked ` ~)
-
Adjust the column widths so that you can see all the formulas.
-
Print out the spreadsheet, using the same procedure as above.
To indicate the target cell, minization or maximization, changing cells,
and constraints, you may make handwritten notations on this second printout.
Alternately, you may make notations using text and graphics on the spreadsheet
itself. Excel will let you draw arrows right on your spreadsheet.
Points will be deducted if you fail to follow these guidelines.
Common errors are forgetting the row and column headings, or not clearly
indicating the changing cells, target cell, or constraints.
To go back to the values view, type control-tilde again.