• Dear forum visitor,

    It looks as though you have not registered for a forum account, or are not signed in. In order to participate in current discussions or create new threads, you will need to register for a forum account by clicking on the link below.

    Click here to register for a forum account!

    If you already have a forum account, you can simply click on the 'Log in' button at the top right of your forum screen.

    Your Elvenar Team

Tournament Catering Data Project

SoggyShorts

Mathematician par Excellence
I just made it for you, you can use or whare it with whomever you wish. If you click on FILE>Create a copy, then it will create a page just for you, and you can make your own link in the top right under "share" that allows people with that link to view,edit, or comment based on your selection.
 

DeletedUser7686

Guest
Domo arigato, Soggy-sama!

EDIT: Going to record this Marble Tournament, then once I have a better handle on it all, get my Fellowship on board collecting data for the upcoming Steel Tournament,
 
Last edited:

Thistleknot

Well-Known Member
Just finished up the tourney for this week and for the first time ever, I catered the whole event. Of course this was all in the name of research. Here's all the data.

Age: 10 - Sorcerers/Dragons
Squad Size: 1689
Tournament: Marble
Below is a chart with the total costs for six tournaments completed through six stars.

Tourney Ring Tot Tier 1 Tot Tier 2 Tot Tier 3 Tot Orcs
1 1 12,800 9,840 14,430 144
2 2 28,630 22,550 24,020 342
3 4 29,190 42,660 45,000 384
4 4 54,070 57,150 30,240 856
5 4 48,710 71,200 75,200 672
6 5 81,180 85,480 43,160 1,288
Total 254,580 288,880 232,050 3,686

Mykan, I attached the raw data PDF. It is hard to read because it did not translate well from Excel. If this doesn't work, let me know and I will see if I can't get it into a better format.

Sadly, the spacing I put in for the chart does not stay once the post is made.:(
 

Attachments

  • Marble Tourney Catering.pdf
    240.3 KB · Views: 97
Last edited:

Ashrem

Oh Wise One
Mykan, I attached the raw data PDF
Maybe you could put the raw data into a google spreadsheet and make it open access for reading?

Converted@Thistleknot post to table
TourneyRingTotTier1Tier2Tier3Orcs.
1112,8009,84014,430144.
2225,63022,55024,020342.
3429,19042,66045,000384.
4454,07057,15030,240856.
5448,71071,20075,200672.
6581,18085,48043,1601,288.
Total-254,580288,880232,0503,686.
 

DeletedUser7686

Guest
Thanks again, Soggy-sama, I did the Marble Tournament, 6 Provinces, 6 Rounds, and will share my insights after I play around with Excel some. But ignoring individual Encounters for a Province Total is a good idea, and there is a tremendous amount of variance.
 

SoggyShorts

Mathematician par Excellence
If I have time this week, I'll record my numbers for all 3 cities as well. I have 2 nearly identical cities in woodelves, one steel one plank, so we should be able to compare and see how big a difference having that first province much closer makes.
 

DeletedUser7686

Guest
I am still chewing on the data, but my very preliminary conclusions are:

1) The total for completing all six rounds of a Province, for coins, supplies, and goods, are about 9.3 x the cost of completing the first Round.
2) There is a LOT of variability.
3) Ring # is important, and I did not capture that.

The 930% estimate seems pretty solid and very useful, at least to a lowbie like me.
 

SoggyShorts

Mathematician par Excellence
The 930% estimate seems pretty solid
What is the % for 5 rounds instead of 6? Most of my FS members(including myself) won't do 6 rounds

I am still chewing on the data
What I'm most curious about is the cost difference between going wide vs deep.
Is 3 provinces 5 times more or less expensive than 15 provinces once?
or
Is 6 provinces 5 times more or less expensive than 15 provinces twice?
 

DeletedUser7686

Guest
What is the % for 5 rounds instead of 6? Most of my FS members(including myself) won't do 6 rounds
I am still chewing on the data, I will report back soon.
What I'm most curious about is the cost difference between going wide vs deep.
Is 3 provinces 5 times more or less expensive than 15 provinces once?
or
Is 6 provinces 5 times more or less expensive than 15 provinces twice?
The increase between Rounds is pretty linear and reliable. The increase between one Province and the next depends mostly on Ring, which I didn't capture, but can still reach some conclusions.

I did 6 Provinces 6 Rounds each time, but I did not capture the 6th Round for Steel because of Real Life(TM).
I don't know what Provinces past the 6th look like, but I SUSPECT the increase is more dramatic for Further Rings than for Further Rounds.
 

SoggyShorts

Mathematician par Excellence
I have 2 accounts that are now at the same squad size, and I plan to try 2 different approaches next tournament:
Both routes are 30 stars, going for max KP.

Option 1 is very simple, 15 provinces, and stop as soon as you get a KP reward from a province. 1008 tournament points, 60 KP

xgggx.jpg

Option 2 is a little more complicated, but basically getting the most KP out of 7 provinces with 5 rounds, stopping if there is no more KP to be had from that province. 1356 tournament points, 44 KP
muwe8k.jpg

A better test would be to replace option 2 with 8 provinces 6 times, as that would give 58 KP, but I won't do round 6.
 
Last edited:

SoggyShorts

Mathematician par Excellence
Update: squad size 897 on both

Option 1 complete, total cost for 60KP:
148K tier 1
161K tier 2
150K tier 3

Option 2 complete, total cost for 44KP:
98K tier 1
100K tier 2
77K tier 3

I'm a little disappointed with the results, was really hoping that the costs would be similar and show that option 1 was better.
To get ~35% more KP costs about 50% more goods, making option 1 more efficient, and it gives far more tournament points.
 

Thistleknot

Well-Known Member
What I'm most curious about is the cost difference between going wide vs deep.
Is 3 provinces 5 times more or less expensive than 15 provinces once?
or
Is 6 provinces 5 times more or less expensive than 15 provinces twice?

Soggy,
I can tell you that going wide is much more expensive than going deep. I did the Steel tournament three different ways. I did 6 tourneys to 6 stars, 8 tourneys to 5 stars, and 11 tourneys to 4 stars. Each covers the points necessary (1620 points) for a single person in a 25-member fellowship to complete all ten chests.

I'm in Age 10 - Sorcerers/Dragons, Squad Size is 1896.

Take a look:
https://docs.google.com/spreadsheets/d/1mX6omKjkllP4G99vBd_bYPQJCLlIFxIsMR8wYS0bF-Y/edit?usp=sharing

Thistleknot
 

SoggyShorts

Mathematician par Excellence
Soggy,
I can tell you that going wide is much more expensive than going deep
Thank you! This is exactly the data I wanted, even though the results aren't what I'd hoped, at least the answer is simple: 8x5 is the cheapest way to do your part without schedule issues.

Looks like a ~33% increase in costs over 6x6 and a ~33% decrease vs 11x4
 
Top