Player1	Player 2	Player3	Player 4	Player 5	Player6	Player 7
Guard? 1=yes 0=no	1	0	1	0	1	0	1
Forward 1=yes 0=no	0	0	1	1	1	1	1
Center 1=yes 0=no	0	1	0	1	0	1	0
Ball-handling	3	2	2	1	1	3	3
Shooting	3	1	3	3	3	1	2
Rebounding	1	3	2	3	1	2	2
Defense	3	2	2	1	2	3	1

43. Coach Night is trying to choose the starting lineup for the basketball team. The team consists of seven play- ers who have been rated on a scale of 1 (poor) to 3 (excellent) according to their ball handling, shooting, rebounding, and defensive abilities. The positions that each player is allowed to play and the players' abilities are listed in the file P06_43.xlsx. The five-player start- ing lineup must satisfy the following restrictions: At least four members must be able to play guard (G), at least two members must be able to play for- ward (F), and at least one member must be able to play center (C). The average ballhandling, shooting, and rebound- ing level of the starting lineup must each be at least 1.8. Either player 2 or player 3 (or both) must start. Given these constraints, Coach Night wants to maximize the total defensive ability of the starting team. Use Solver to determine his starting team. 43. Coach Night is trying to choose the starting lineup for the basketball team. The team consists of seven play- ers who have been rated on a scale of 1 (poor) to 3 (excellent) according to their ball handling, shooting, rebounding, and defensive abilities. The positions that each player is allowed to play and the players' abilities are listed in the file P06_43.xlsx. The five-player start- ing lineup must satisfy the following restrictions: At least four members must be able to play guard (G), at least two members must be able to play for- ward (F), and at least one member must be able to play center (C). The average ballhandling, shooting, and rebound- ing level of the starting lineup must each be at least 1.8. Either player 2 or player 3 (or both) must start. Given these constraints, Coach Night wants to maximize the total defensive ability of the starting team. Use Solver to determine his starting team