I think I had the most unfun ACKS related hours behind me…
I finally could get a MS Excel sheet working that generates the Market demand modifiers for the 4 markets in my starting barony. I thought using that tool would make it easy to get this work done but no, I was still missing step 5: Determine Trade Routes
Running 6 times trough the list of 31 trade goods, modifying the lists of both markets every time…
I think it took at least 150-200 copy&paste to achieve this:
|Berem:|
|-1|Gems,Rare Wood,Spices,Grain
|-2|Hides,Textils,common Wood,Weapons & Armor,Glassware,Animals,Beer,rare Furs,Tools
|-3|preserved Fish
|Moorwacht:|
|+2|Silk,Spirits,fine Porcelain
|+1|pottery,mounts,spices
|-1|textiles,common furs,rare furs,preserved meat,preserved fish
|-2|common wood,gems,precious metals,grain & vegetables, glassware, hides
|-3|cloth
|Dwim:|
|+1|Pottery
|-1|precious metal,preserved fish,rare furs,gems
|-2|common furs,grain&vegetables,glassware,common wood,hides,textils,preserved meat
|Rottenau:|
|+1|silk,fine porcelain,spices,pottery
|-1|coffee&tea,tools,preserved fish,beer,mounts,textiles
|-2|grain&vegetables,glassware,common wood,rare furs,gems,animals
There must be a better way to get such a result!
In the end the values are so dependant on what market goes first I wonder if one couldnt just roll up a whole market group (all markets in reach of each other) taking the average environmental, racial and domain revenue modifiers and afterwards randomly determine a few goods that break from the average…