### Sometimes, it would just be better to switch to VBA :)

This file contains vehicle
routing paths (a solution to the two truck problem a few posts back), as a
Trendline’s Microsoft Excel Solver optimization result. The problem (in the two
left red columns) is that the two paths have become mixed. One path would have
to take us: Tallinn-Märjamaa-Riidaku-Tallinn and the other:
Tallinn-Pärnu-Valgerand-Tallinn, as determined by the ones and zeros in the
solution. But the six ones determining the paths reside in the same column and
have to be separated.

The set of Excel
relationships is visualized by the formula auditing tool. The final result is
in the right side of the spreadsheet, where the two red columns have three ones
each.

## No comments:

Post a Comment