Thesi

I did some research on research

11 posts in this topic

research tree*

Before I begin I just wanted to say a quick hi to everyone in DI-II and thanks to @AlwaysSlayinfor getting me super stuck into SHK.

Being a Pokemon player and how I generally am when playing games I decided I would try to figure out the most optimal research to maximise growth and efficiency. So I made some spread sheets (link below, best looked at in excel) and some graphs to figure out whats best to research and whats not. I also made some recommendations as to what each specialist should invest.

Short disclaimer; I've only been playing for a short while so I might be completely wrong on some points that come later in the recommendations section. Also this is based off EU4, I don't know if it is different/the same in other worlds, soz.

Methodology:

In my examples I'll be focusing on the farming sheet, but the same points works for all sheets. Also I converted everything to numbers instead of percent for easier maths, effect is the same either way.

First and most obvious step is to just list out all the skills and how much benefit they give at each level (D31-K42). Also I listed out what was unlocked at each level (D45-K56) and the total number of research into each skill(L31-42)/tree(L30) possible.

Note that I have a 0th skill point and values in there, this is because even at level 0 you still have a base production rate, despite the fact you need level 1 to get the building to allow you to produce. On other sheets this is different (you have a base art's multiplier of 1 at level 0 but you don't have a base faith gain etc). 

The first real bit of analysis comes when we just average the values of each skill (M31-42), this is multiplied by 100 to help with calculations later. This shows a basic efficiency value for this section.

Next is to find the relative gain at each rank (O31-V42). This simply is just how much extra production you get over the last rank. As we can see the relative gain for things like Ale/Bread is less then things like Apple/Wheat. Again we do the same average * 100. 

The next two graphs are how much you get per level of investment. These values are based off the previous two sections so that the final section is the relative gain per invested point. Since these graphs are a measure of efficiency they are already multiplied by 100 so the final column doesn't have to be. Again looking at the difference between Wheat and Bread it is clear that Wheat is more efficient.

Now we have the four sections we can look at the over all efficiency (A31-42). Here, any value over 100 means it is that much "worth'' it. So Wheat is 22% worth it and Bread is 21% not worth it. This of course only makes sense in farming where two different skills can affect the same thing. In just about every other tree this number is meaningless as no two skills can help produce the same thing (with the exception of weapon making).

Then I added graphs for those who don't like looking at numbers. For all the graphs in education I chopped them off at 10 because it looked nicer and Theology doesn't exactly do anything interesting.

Recommendations

So with the numbers out of the way next was to make some recommendations. This is largely speculative and depends heavily on play style/parish/premium token/card usage, but I tried to make this work as best I could. The first section(A1-E52) is what I'd recommend if you wanted to be a 'generalist', not great at one thing but good at everything.

This obviously isn't how most people will play as they will take a liking to certain aspects of the game. So I made a specialist section(A54-S106). I based this around the idea that the first 100 (ish) points (so about when you get to page) should be spent the same for everyone, then the next 50+50 is spent specialising. You can spend 50 on supply then 50 on fighting or just both sets of 50 on supply. Either way these points should be the best way to maximise your role.

Ideally your specialisation should allow you to still be fully self sufficient and still allow you to grow in rank in some way that is better then generalisation.

Other points:

In the last sheet I just did some quick calculations to see if Philosophy is worth it, spoiler; it is. Basically in cell B3 enter the current amount of gold you need to buy your next point, the yellow cell (L7) is how much you need to max out Philo if you buy every point. This is based off the assumption that the increase in price is liner and that you will wait until the first point is finished researching before buying the next one (otherwise the cell to look at is L5 if you just buy them without waiting). The over all efficiency is ~10%, so definitely get this if you have surplus gold to spend.

I also did the same thing for maths with basically the same result, just with cost replaced with time. This trends up then back down to ~5%, so again get this if you have surplus time(ie time that you are not researching other things). 

The best way to make use of these would be to buy your way to max Philo then buy your way to max maths. This will cost the amount in cell V7. If you do this in between your other research and gold spending then you can pretty easily save a lot of gold and time in the long run. Just don't spend gold that would be better used on things like captains as they allow Vill's which will get more honour and more free research so you won't need to buy these in the first place. I would also say that buying architecture points is pretty worth it too, but it's best saved until right before you get to rank 15 so you can build up your 3rd vill really quick.

 

Again I would like to point out that this is very dependant on your play style/parish/card use so take this as a pointer to the direction you should take rather then the definitive way to spent points.

Also if you guys think I got something wrong (which TBH, I probably did) then let me know and I can update it.

Thanks, Thesi.

Link

https://drive.google.com/file/d/0B9P6o2yu4o6Ud1RldHBrYTZvc3M/view?usp=sharing

If you copy the file into your own google drive then you can turn it into a google sheet. I don't think it will keep the formula though...

0

Share this post


Link to post
Share on other sites
Events Attended

Nice post

0

Share this post


Link to post
Share on other sites
Events Attended

Wow that`s allot to take in man, I`ll definitely use this in the future.

0

Share this post


Link to post
Share on other sites

Fair bit of work you`ve put in there. 

Well done. 

I`ll look into putting it to use.

0

Share this post


Link to post
Share on other sites
Events Attended
48
2

Tried to open this and it won't

0

Share this post


Link to post
Share on other sites

Try downloading it.

0

Share this post


Link to post
Share on other sites
Events Attended
48
2

Thanks, I'll give that a try.:)

0

Share this post


Link to post
Share on other sites

ill try it too

0

Share this post


Link to post
Share on other sites
Events Attended

i'm cornfused, can anyone make it short a sweet for someone like me.

0

Share this post


Link to post
Share on other sites
Events Attended
2
2

On 2017-6-24 at 7:16 AM, Macon3 said:

i'm cornfused, can anyone make it short a sweet for someone like me.

Basically, the numbers in coloumns A is how 'effective' each research is. The graphs and other stuff is just for understanding why it is the case. Recommendations are just what I think you should research, in order, to effectively fulfill what ever role you want. Lastly, buy each point of philosophy, math and (probably) architecture if you have surplus gold, they are all 'worth it' to just buy.

0

Share this post


Link to post
Share on other sites
Events Attended