Please help me with the following constraints on my sheet that i have attached
After stopping off for an early breakfast at a highway resta ura nt near Musina, Biff headed his truck back onto the N l highway on h is way to deliver his goods in Zim ba bwe. When he stopped at the border post, he noticed that his truck is in a convoy of five trucks and he starts talking to the other four drivers. I t turns out each of the five was driving a load of a different type of cargo from a different location to Harare. Can you determine each trucker's place in the convoy, as well as his/her cargo and origin?CLU ES:1. Hank's truck was immediately in front of the truck from Mokopane and immediately behind the truck carrying soda.2. The truck carrying lumber, which was not being driven by Rhoda, was not from Johannesburg.3. The five drivers are Ali; the person from Cape Town, the last driver in the line; Jerriand the one who had a load of pa per products.4. The truck from Richards Bay was somewhere in front of Jerri's truck and somewhere behind the truck from Johannesbu rg.5. Rhoda's truck was somewhere behind the truck carrying prod uce, which was somewhere behind the truck from Durban .OPTIONS:Truck driver names: Biff; Hank; Rhoda; Ali; JerriTruck origin: Mokopane; Johannesbu rg; Cape Town; Richa rds Bay; Durban Cargo:Soda; Lumber; Paper; Prod uce; OvensOrder: First; Second; Third; Fourt h; Fifth
After stopping off for an early breakfast at a highway resta ura nt near Musina, Biff headed his truck back onto the N l highway on h is way to deliver his goods in Zim ba bwe. When he stopped at the border post, he noticed that his truck is in a convoy of five trucks and he starts talking to the other four drivers. I t turns out each of the five was driving a load of a different type of cargo from a different location to Harare. Can you determine each trucker's place in the convoy, as well as his/her cargo and origin?CLU ES:1. Hank's truck was immediately in front of the truck from Mokopane and immediately behind the truck carrying soda.2. The truck carrying lumber, which was not being driven by Rhoda, was not from Johannesburg.3. The five drivers are Ali; the person from Cape Town, the last driver in the line; Jerriand the one who had a load of pa per products.4. The truck from Richards Bay was somewhere in front of Jerri's truck and somewhere behind the truck from Johannesbu rg.5. Rhoda's truck was somewhere behind the truck carrying prod uce, which was somewhere behind the truck from Durban .OPTIONS:Truck driver names: Biff; Hank; Rhoda; Ali; JerriTruck origin: Mokopane; Johannesbu rg; Cape Town; Richa rds Bay; Durban Cargo:Soda; Lumber; Paper; Prod uce; OvensOrder: First; Second; Third; Fourt h; Fifth
Copy of ga2 final.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | |||||||||||||||
2 | Driver | hint | Driver | ||||||||||||
3 | biff | ? | Place | biff | hank | rhoda | ali | jerri | |||||||
4 | hank | not from mokopane; not carrying soda | Mokopane | 0 | 0 | 1 | 0 | 0 | 1 | = | 1 | ||||
5 | rhoda | not carrying lumber; not from dbn | Johannesburg | 1 | 0 | 0 | 0 | 0 | 1 | = | 1 | ||||
6 | ali | not from cpt; | Cape Town | 0 | 1 | 0 | 0 | 0 | 1 | = | 1 | ||||
7 | jerri | not from rcb or jozi | Richards Bay | 0 | 0 | 0 | 1 | 0 | 1 | = | 1 | ||||
8 | Durban | 0 | 0 | 0 | 0 | 1 | 1 | = | 1 | ||||||
9 | Cargo | hint | 1 | 1 | 1 | 1 | 1 | ||||||||
10 | Lumber | not from jozi | = | = | = | = | = | ||||||||
11 | soda | not from mokopane | 1 | 1 | 1 | 1 | 1 | ||||||||
12 | paper | not ali,jerri, not from cpt | |||||||||||||
13 | produce | not from durban; not rhoda | plcae | ||||||||||||
14 | ovens | Cargo | Mokopane | Johannesburg | Cape Town | Richards Bay | Durban | ||||||||
15 | Lumber | 0 | 0 | 0 | 0 | 1 | 1 | = | 1 | ||||||
16 | soda | 0 | 1 | 0 | 0 | 0 | 1 | = | 1 | ||||||
17 | Order | hint | paper | 0 | 0 | 0 | 1 | 0 | 1 | = | 1 | ||||
18 | 1 | not hank, not richardsbay | produce | 0 | 0 | 1 | 0 | 0 | 1 | = | 1 | ||||
19 | 2 | ovens | 1 | 0 | 0 | 0 | 0 | 1 | = | 1 | |||||
20 | 3 | 1 | 1 | 1 | 1 | 1 | |||||||||
21 | 4 | = | = | = | = | = | |||||||||
22 | 5 | not ali or jerri;not hank, not durban | 1 | 1 | 1 | 1 | 1 | ||||||||
23 | |||||||||||||||
24 | |||||||||||||||
25 | h1 | 0 | = | 0 | |||||||||||
26 | h2 | 0 | = | 0 | |||||||||||
27 | |||||||||||||||
28 | Order | ||||||||||||||
29 | Place | 1 | 2 | 3 | 4 | 5 | |||||||||
30 | Mokopane | 0 | 0 | 0 | 0 | 1 | 1 | = | 1 | ||||||
31 | Johannesburg | 0 | 0 | 1 | 0 | 0 | 1 | = | 1 | ||||||
32 | Cape Town | 1 | 0 | 0 | 0 | 0 | 1 | = | 1 | ||||||
33 | Richards Bay | 0 | 1 | 0 | 0 | 0 | 1 | = | 1 | ||||||
34 | Durban | 0 | 0 | 0 | 1 | 0 | 1 | = | 1 | ||||||
35 | 1 | 1 | 1 | 1 | 1 | ||||||||||
36 | = | = | = | = | = | ||||||||||
37 | 1 | 1 | 1 | 1 | 1 | ||||||||||
38 | |||||||||||||||
39 | H2 | 0 | = | 0 | |||||||||||
40 | h3 | 0 | = | 0 | |||||||||||
41 | |||||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J30:J34,J15:J19,J4:J8 | J4 | =SUM(E4:I4) |
E35:I35,E20:I20,E9:I9 | E9 | =SUM(E4:E8) |
E25 | E25 | =F4+G8+H6+I7+I5 |
E26 | E26 | =F15+E16+I18+G17 |
E39 | E39 | =E30+E33+I33+I34+I31+I32 |
E40 | E40 | =I34+E33 |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
solver_lhs1 | =Sheet1!$E$15:$I$19 | E20, J15 |
solver_lhs5 | =Sheet1!$E$30:$I$34 | E35, J30, E39 |
solver_lhs8 | =Sheet1!$E$4:$I$8 | E9, J4 |
solver_rhs13 | =Sheet1!$F$16 | F20, J16 |