Regional Income

**YAKOBU** · 05-17-2004, 12:35

Hi Everyone

Tricky Lady and myself have produced a regional income and province speciality file that you may find useful. It is based on VI: Early at 1087 startup.

:Region Incomes

Columns A-N show the summary with Columns P-Z showing working.

Note:
Farming is the figure in the MTW directory * 52/100 which is proved back to the starting position in 1087 taking into account kings acumen. This doesn't work as well on rebel provinces.
Trade Goods are valued as per the figures in the MTW directory. Note some provinces gain further trade goods as game progresses and these are shown.

Please let me know your thoughts on any mistakes or potential improvements.

**Eastside Character** · 05-17-2004, 13:30

Nice initiative, thank you YAKOBU and Tricky Lady

It will certainly come handy from time to time.

Regards,
EC

**YAKOBU** · 05-17-2004, 13:42

Cheers EC

Need to check the trade goods again tonight as Anjou shows 2 and Northumbia 1, I know in my games it's the other way round on the map Not in till 10pm so bear with me

**Ludens** · 05-17-2004, 18:19

Thanks YAKOBU and Tricky Lady. No doubt this will come in handy.

**YAKOBU** · 05-17-2004, 23:01

High everyone

Slight amendment needed, Northumbria should have wool (30) and fish (20). I will update the file and reload tomorrow.

**Powermonger** · 05-17-2004, 23:46

Thought I'd de-lurk and say good job on the file.

I've actually been working on my own with the same sort of information but it's not quite finished yet and I'm including the provincial titles as well for reference. Your's will certainly help fill in my blanks though. :)

Question about the trade goods though, how/where did you derive their values from? I've been basing my tradable good values on their 'normal' tax rate with only a trading post (no governor). Commodoties like wood, butter and saltfish I get a base rate of 10 florins and any subsequent trade upgrades seems to increase their values by 20%. Maybe I'm missing something?

**YAKOBU** · 05-17-2004, 23:57

Hi Opeth

The information is in the MTW directory campmap/startpos in the Early text file, about 1/6th of the way down. There is also other information in there that may help you. My figure ignores tax or upgrades as trade is difficult to value but the base gives you an idea how profitable a regions trading could be.

I'm thinking of maybe adding region specialities (i.e. valour bonuses).

**Powermonger** · 05-18-2004, 00:14

Thanks, I'll have another look in the file tonight but somehow I can never find it.

I can find the section on what provinces have what goods but nothing else. Adding valour bonuses would be helpful I think too, never crossed my mind adding that.

**Gregoshi** · 05-18-2004, 04:52

Hello Opeth.

It is about time you de-lurked. Now that you have, you gonna stay that way?

**Powermonger** · 05-18-2004, 05:21

Thanks for the welcome.

I hope to stay in my delurked state and add to the discussions. There is always something new to learn about MTW, that's why I love it so much and is one of my all time favourite games. It's like Powermonger on steroids

**YAKOBU** · 05-18-2004, 09:42

Hi everyone

I have now corrected Northumbria trade and you can check the file on the link at the beginning.

Can people let me know what they think of the file? I am thinking of adding region specialities (i.e. valour bonuses) but don't want the sheet to get too clogged up.

Sorry Opeth didn't officially welcome you.............

WELCOME to the org I'm new myself and only have a high post count due to the 1 word story and the word association game

**cutepuppy** · 05-18-2004, 10:46

Good initiative, indeed

I think the valour bonuses would be a nice addition. Maybe you can also add the 'new tradegoods' (the ones that appear over time in certain provinces).

Just an idea, though.

**RedKnight** · 05-18-2004, 16:52

Good deal, Yakobu... a nice summary

I'm working on an applet that will let you checkmark which ports you own and which are available for trade, and it will calculate your trade income. As we all know, the trade system is fairly straightforward... but a pain to simulate Thus there's no good statement of combined farm+trade income (of course, the trade income would change tons, depending on conditions anyway... but my simulator would allow for that). Still, we all know the best regions, shrug.

One small suggestion: Next time you revise your .xls, put the cursor in B4 and then /Window /Freeze panes. This will make the region and column headings always visible, regardless of scrolling.

In case it helps / you don't already have it down, trade goods that change over time are (kudos to garion, cutepuppy, Schro, katank and others in my trade goods thread):

1295 - Marco Polo; Tripoli and Syria add spices and silk
1367 - Ibn Battutah; Khazar adds spices and silk, Crimea adds silk
1434 - Gil Eanes; Portugal adds cotton and spices

Other econ events: Banking Houses (1280) and Public Clocks (1286) sound like income is impacted; Children’s Crusade (1211) farm income in France and HRE (-10%?); The Plague (1346) all income reduced (%?).

**Tricky Lady** · 05-22-2004, 11:27

*shameless bump*

(it was on page 2)

**YAKOBU** · 05-23-2004, 14:06

Hi everyone

Just letting you know Tricky Lady and myself have updated this file and relinked it at the start of this thread.

Valour bonuses and new trade goods over time are now shown - hope that makes cutepuppy and RedKnight happy.

Also done the freeze pane RedKnight but was happy myself just to print it out for ease of use.

Thanks RedKnight for the information for other trade goods

, although I didn't feel the need to show the other economic events.

Finally 2 questions for the moderators:

Is this worthy of sticking on the guides section and highlighting so it stays on the 1st page?? I can update it with other suitable information if needed.

I now have 3 files on the org with a link to the last revision. How do I delete the 1st two??

Hope you all find it useful

**gaijinalways** · 05-23-2004, 16:59

Thanks guys, good info. Another reason that this forum is useful for playing this time sucking games ( still love those battles though).

**RedKnight** · 05-23-2004, 19:59

Thanks for that update, Tricky Lady and Yakobu Excellent work, as always, you two Right, the other economic events are too much hassle to include.

Here's a slightly different look at the picture - a model of income from provinces, all things held equal (acumen 5 governor and king, 80% farm, master merchant for ports, trading post for inland; MS Excel 2000 file). It lets you see what are the best income provinces in general, all things equal. Of course they never are in a real game (nor would you want them to be), but anyway, it can be useful to know, in theory. You can use it to see what will be best in the future (when everything's built), to assign your best governor.

For the model, I assumed ports could trade with half the other ports in the game (i.e., 20), but also blocking due to other ports selling the same good, is included.

Anybody want to see anything else with this? The code's all set up, so I can make variations. (I dump it out of Access into Excel.)

**Ludens** · 05-26-2004, 17:55

YAKOBU, what happened to the link? It doesn't work anymore.

**Obadiah** · 05-26-2004, 19:53

I'd love to see it, but I'm getting a file not found error. Can you double check that the link is currently working?

thanks

**Tricky Lady** · 05-26-2004, 20:02

As I contributed a bit to YAKOBU's document, I have a copy too.

I'll put it online until YAKOBU returns.

You can temporarily consult the file over here.

As said, I'll remove this link within a few days, when YAKOBU's file is back online.

Cheers,
TL

Edit: I checked the link. It works fine. Just give me a sign if anyone of you can't see it.

Edit2: LINK REMOVED.

**YAKOBU** · 05-26-2004, 22:11

Cheers Tricky Lady

I think the file gets moved after a few days to a more permanent residence but I can't locate it.

I've mailed Barocca to see if he can locate it for me.

Will let you know when all is OK.

Thanks for stepping in

**Tricky Lady** · 05-26-2004, 22:19

Hey YAKOBU, does my link work when accessed from your computer too? Or are you redirected to the hijackers too?

**YAKOBU** · 05-26-2004, 22:24

It opens fine Tricky

**YAKOBU** · 05-26-2004, 22:25

p.s. Congratulations on the 500 and I like your pic, didn't know you were so pretty

**RedKnight** · 05-26-2004, 22:30

erm... the hijackers? (maybe you should train more spies?)

(it opens fine for me

)

roger that, on the cuteness factor. wtg on collaborating, Yakobu

**Don Corleone** · 05-26-2004, 22:36

Aha Yet one more sign you've been playing MTW waaaaay too much

When avatars start generating arousal, it's time for a dose of 'real life'.

Just kiddin.

**Gregoshi** · 05-27-2004, 06:21

Wow Tricky, it seems like you joined us only yesterday. Congrats on the 500.

**shakaka36** · 05-27-2004, 08:15

cheers this is very usefull.

**Tricky Lady** · 05-27-2004, 17:17

Originally Posted by [b

Quote[/b] (Gregoshi @ May 27 2004,07:21)]Wow Tricky, it seems like you joined us only yesterday. Congrats on the 500.

But I only joined the org yesterday.... *checks own member profile* oh, no it was somewhere in March. Good god, time flies Anyway, it's good being around here...

Originally Posted by [b

Quote[/b] ]When avatars start generating arousal, it's time for a dose of 'real life'.

My thoughts exactly, don Corleone.

BTW, thanks for all the good words, guys.