Spreadsheet: 485914d1477167205-traveling-sales-person-problem-traveling-sales-man
Sheet: Answer Report 1

Microsoft Excel 14.0 Answer Report
Worksheet: [[NAME] with Evolutionary
Report Created: 10/22/2016 3:13:46 PM
Result: Solver stopped at user's request.
Solver Engine
 | Engine: Evolutionary
 | Solution Time: 28.393 Seconds.
 | Iterations: 0 Subproblems: 22884
Solver Options
 | [NAME] 20 sec,  [NAME], Precision 0.000001, Use Automatic Scaling
 | Convergence 0.0001, Population Size 100, Random Seed 0, Mutation Rate 0.075, Time w/o Improve 30 sec, [NAME]
 | Max Subproblems Unlimited, [NAME], [NAME] 1%, Assume NonNegative
Objective Cell (Min)
 | Cell | Name | Original Value | Final Value
 | $V$20 | Distance | 14000 | 97
Variable Cells
 | Cell | Name | Original Value | Final Value | [NAME]
 | $T$5 | Cust 1 Route To Travel | 0 | 9 | AllDiff
 | $[NAME] | Cust 2 Route To Travel | 0 | 13 | AllDiff
 | $T$7 | Cust 3 Route To Travel | 0 | 12 | AllDiff
 | $[NAME] | Cust 4 Route To Travel | 0 | 8 | AllDiff
 | $T$9 | Cust 5 Route To Travel | 0 | 10 | AllDiff
 | $T$10 | Cust 6 Route To Travel | 0 | 11 | AllDiff
 | $T$11 | Cust 7 Route To Travel | 0 | 7 | AllDiff
 | $T$12 | Cust 8 Route To Travel | 0 | 6 | AllDiff
 | $T$13 | Cust 9 Route To Travel | 0 | 5 | AllDiff
 | $T$14 | Cust 10 Route To Travel | 0 | 4 | AllDiff
 | $T$15 | Cust 11 Route To Travel | 0 | 3 | AllDiff
 | $T$16 | Cust 12 Route To Travel | 0 | 1 | AllDiff
 | $T$17 | Cust 13 Route To Travel | 0 | 2 | AllDiff
Constraints
 | Cell | Name | Cell Value | [NAME] | Status | Slack
 | $T$5 | Cust 1 Route To Travel | 9 | $[NAME] | Not Binding | 4
 | $[NAME] | Cust 2 Route To Travel | 13 | $T$6<=13 | Binding | 0
 | $T$7 | Cust 3 Route To Travel | 12 | $T$7<=13 | Not Binding | 1
 | $[NAME] | Cust 4 Route To Travel | 8 | $T$8<=13 | Not Binding | 5
 | $T$9 | Cust 5 Route To Travel | 10 | $[NAME] | Not Binding | 3
 | $T$10 | Cust 6 Route To Travel | 11 | $T$10<=13 | Not Binding | 2
 | $T$11 | Cust 7 Route To Travel | 7 | $T$11<=13 | Not Binding | 6
 | $T$12 | Cust 8 Route To Travel | 6 | $[NAME] | Not Binding | 7
 | $T$13 | Cust 9 Route To Travel | 5 | $T$13<=13 | Not Binding | 8
 | $T$14 | Cust 10 Route To Travel | 4 | $T$14<=13 | Not Binding | 9
 | $T$15 | Cust 11 Route To Travel | 3 | $T$15<=13 | Not Binding | 10
 | $T$16 | Cust 12 Route To Travel | 1 | $T$16<=13 | Not Binding | 12
 | $T$17 | Cust 13 Route To Travel | 2 | $T$17<=13 | Not Binding | 11
 | $T$5 | Cust 1 Route To Travel | 9 | $[NAME] | Not Binding | 8
 | $[NAME] | Cust 2 Route To Travel | 13 | $T$6>=1 | Not Binding | 12
 | $T$7 | Cust 3 Route To Travel | 12 | $T$7>=1 | Not Binding | 11
 | $[NAME] | Cust 4 Route To Travel | 8 | $T$8>=1 | Not Binding | 7
 | $T$9 | Cust 5 Route To Travel | 10 | $T$9>=1 | Not Binding | 9
 | $T$10 | Cust 6 Route To Travel | 11 | $T$10>=1 | Not Binding | 10
 | $T$11 | Cust 7 Route To Travel | 7 | $[NAME] | Not Binding | 6
 | $T$12 | Cust 8 Route To Travel | 6 | $[NAME] | Not Binding | 5
 | $T$13 | Cust 9 Route To Travel | 5 | $T$13>=1 | Not Binding | 4
 | $T$14 | Cust 10 Route To Travel | 4 | $[NAME] | Not Binding | 3
 | $T$15 | Cust 11 Route To Travel | 3 | $T$15>=1 | Not Binding | 2
 | $T$16 | Cust 12 Route To Travel | 1 | $T$16>=1 | Binding | 0
 | $T$17 | Cust 13 Route To Travel | 2 | $T$17>=1 | Not Binding | 1
 | $T$5:$T$17=AllDiff