not to turn this into a griping session about automated trade routes, but my biggest issue with is that although I have my import colonies set to a max 200 (keep 200) for import/export, it will dump the entire wagon load of the good into the city causing overages. Of course, the wagon's left by then, so I can't re-load it to stop the spillage.
You're right. Again, Automated trading is an inefficient algorithm but a necessary evil provided you have a 10+ cities empire and you don't wanna spend 1 minute per city per turn. If you want to work around this problem, do the following:
If a city has a standard warehouse, do not set it to import anything automatically.
If a city has a bigger warehouse (200 normal, 600 marathon), set it to import/export at 100 (on normal, 300 on marathon).
If a city has the biggest warehouse possible (300 normal, 900 marathon):
- If you use Dale PatchMod which counts Warehouse trading as Trading (and thereby affects Europe prices), set it at import/export at 200/600 resp.
- If you use Civ4 Col w/out Dale PatchMod, just set it at import.