Microsoft Excel 9.0 Answer Report
Worksheet: [Voting Problem.xls]Sheet1
Report Created: 12/3/2001 3:56:54 PM
Target Cell (Max)
Cell Name Original Value Final Value
$E$8 Toss up States 243 243
Adjustable Cells
Cell Name Original Value Final Value
$C$10 Arkansas $ 1,000,000 0
$C$11 Delaware $ 1,000,000 0
$C$12 Florida $ 1,000,000 0
$C$13 Illinois $ 1,000,000 0
$C$14 Iowa $ 0 0
$C$15 Maine $ 0 0
$C$16 Missouri $ 0 0
$C$17 Pennsylvania $ 1,000,000 0
$C$18 Tennessee $ 1,000,000 0
$C$19 Michigan $ 0 0
$C$20 Nevada $ 0 0
$C$21 New Mexico $ 0 0
$C$22 Oregon $ 1,000,000 0
$C$23 Washington $ 0 0
$C$24 West Virginia $ 0 0
$C$25 Wisconsin $ 1,000,000 0
Constraints
Cell Name Cell Value Formula Status Slack
$C$26 $ 0 $C$26<=$E$26 Not Binding 5000000
$F$50 Arkansas Constraint 0 $F$50<=1 Not Binding 1
$F$51 Delaware Constraint 0 $F$51<=1 Not Binding 1
$F$52 Florida Constraint 1 $F$52<=1 Binding 0
$F$53 Illinois Constraint 1 $F$53<=1 Binding 0
$F$54 Iowa Constraint 0 $F$54<=1 Not Binding 1
$F$55 Maine Constraint 0 $F$55<=1 Not Binding 1
$F$56 Missouri Constraint 1 $F$56<=1 Binding 0
$F$57 Pennsylvania Constraint 0 $F$57<=1 Not Binding 1
$F$58 Tennessee Constraint 0 $F$58<=1 Not Binding 1
$F$59 Michigan Constraint 1 $F$59<=1 Binding 0
$F$60 Nevada Constraint 0 $F$60<=1 Not Binding 1
$F$61 New Mexico Constraint 0 $F$61<=1 Not Binding 1
$F$62 Oregon Constraint 0 $F$62<=1 Not Binding 1
$F$63 Washington Constraint 1 $F$63<=1 Binding 0
$F$64 West Virginia Constraint 0 $F$64<=1 Not Binding 1
$F$65 Wisconsin Constraint 0 $F$65<=1 Not Binding 1
$K$30 Arkansas sum 1 $K$30<=1 Binding 0
$K$31 Delaware sum 0 $K$31<=1 Not Binding 1
$K$32 Florida sum 1 $K$32<=1 Binding 0
$K$33 Illinois sum 1 $K$33<=1 Binding 0
$K$34 Iowa sum 0 $K$34<=1 Not Binding 1
$K$35 Maine sum 0 $K$35<=1 Not Binding 1
$K$36 Missouri sum 1 $K$36<=1 Binding 0
$K$37 Pennsylvania sum 0 $K$37<=1 Not Binding 1
$K$38 Tennessee sum 1 $K$38<=1 Binding 0
$K$39 Michigan sum 1 $K$39<=1 Binding 0
$K$40 Nevada sum 0 $K$40<=1 Not Binding 1
$K$41 New Mexico sum 0 $K$41<=1 Not Binding 1
$K$42 Oregon sum 0 $K$42<=1 Not Binding 1
$K$43 Washington sum 1 $K$43<=1 Binding 0
$K$44 West Virginia sum 0 $K$44<=1 Not Binding 1
$K$45 Wisconsin sum 0 $K$45<=1 Not Binding 1