Battlegrounds Spreadsheet

72 Replies
devnullicus
20 December, 2015, 2:14 AM UTC

For those who have been wishing for a convenient, easy-to-use spreadsheet to help with Stormfall Battlegrounds, the wait is over!  :)  I'm making my battlegrounds spreadsheet publicly available for everyone to use.


The spreadsheet will tell you how to use battlegrounds, how to track your bank balance to get good payouts, and what are the best and most efficient troop types to use.  It will allow you to keep track of all troops bonuses from lost arts, relics, paragon, etc.


I will try to answer questions, but I can't guarantee I'll have much time as I do have a job and a life outside this game, so PLEASE read the instructions in the spreadsheet first!


I hope you find it helpful!.

You can find it at:

https://docs.google.com/spreadsheets/d/1ox2mD3Cu2FbVqNdzdDwmQ9qbaSDbHvGhhhgrW12-BU0/edit#gid=1434820704 


Please note that this is a google spreadsheet and is not something you can download.  You'll need to make a copy in your own google drive.


Edit:  I've updated this spreadsheet to version 4.2 with a lot of new changes and error fixes.  The new spreadsheet is at

https://docs.google.com/spreadsheets/d/1WebO4sDFZLlXbz7x6332oheMSNXK2H2LQLw4uJwJf0M/edit#gid=1434820704


If you ever want to know how the gods feel about money, simply look at who they choose to give it to [Caine Black Knife]
UTC -8:00
Mehnslayer
20 December, 2015, 2:26 AM UTC

Pinning this post, a lot of time and effort has been put into this and should be acknowledged, hopefully JUGLAR DEL VIENTO can give some more insight than me on this post.

E 'n la sua volontade è nostra pace
UTC +10:00
djmoody
20 December, 2015, 2:45 AM UTC

Clearly took a lot of time and effort. Nice work.

Everyone has a right to an opinion. No one has a right to their opinion being respected by other if it can't be backed up with rational and logic explanation
UTC +0:00
devnullicus
20 December, 2015, 3:16 AM UTC
Thank you.    Now, if only Plarium would put battle results in a text-friendly format and allow us to cut-n-paste them :)   Would make life much easier!  Ah well, can't have everything.
If you ever want to know how the gods feel about money, simply look at who they choose to give it to [Caine Black Knife]
UTC -8:00
Skramble
21 December, 2015, 2:57 AM UTC

WOW nice work !!!

Thank you for opening this up to public use.

UTC -7:00
Juglar del Viento
Moderator
21 December, 2015, 5:58 PM UTC

A really good and nice work mylord

very usefull

Thanks for sharing.
Resistance Is Futile
UTC +1:00
Lord Oberon
Administrator
22 December, 2015, 12:42 PM UTC

What a tremendous amount of work you've accomplished with this calculator, my Lord!


Very useful and deserves it's place among the best player written tutorials. Thank you very much for sharing it Lord Devnullicus 


Oberon, Heir of Veyon, Scion of the Firstborn, Lord Regent of Stormfall
UTC +2:00
viper_22664
22 December, 2015, 11:59 PM UTC
This sounds like exactly what I have been looking for. Shame I don't have Google Drive or Spreadsheets & can't use it.
Cry Havoc and let slip the dogs of war
UTC +5:00
Mehnslayer
23 December, 2015, 12:07 AM UTC
viper_22664 said:

This sounds like exactly what I have been looking for. Shame I don't have Google Drive or Spreadsheets & can't use it.
Maybe you will win some free sapphires from it ;)
E 'n la sua volontade è nostra pace
UTC +10:00
viper_22664
23 December, 2015, 12:23 AM UTC
Yup.....I have spent a lot of time working on a BG Spreadsheet (in Excel) but, it doesn't go into the detail (lvl's, boost's, etc) that it sounds like this one does. I am bummed......I don't even have a Google email addy.
Cry Havoc and let slip the dogs of war
UTC +5:00
Lord Oberon
Administrator
23 December, 2015, 9:26 AM UTC
viper_22664 said:

This sounds like exactly what I have been looking for. Shame I don't have Google Drive or Spreadsheets & can't use it.
Maybe it's time to set up a Google account, my Lord?
Oberon, Heir of Veyon, Scion of the Firstborn, Lord Regent of Stormfall
UTC +2:00
Mehnslayer
23 December, 2015, 9:28 AM UTC

Lord Oberon said:


viper_22664 said:


This sounds like exactly what I have been looking for. Shame I don't have Google Drive or Spreadsheets & can't use it.
Maybe it's time to set up a Google account, my Lord?

Sellout!


E 'n la sua volontade è nostra pace
UTC +10:00
viper_22664
24 December, 2015, 2:39 AM UTC

Ahhhh......I see the lords of this land have a witty sense of humor. Is this spreadsheet really so good I should betray my people??


Oh.....and where would one go to submit suggestions for the game?? At the top of my list is.....Have a calculator built into the BG's that automatically reports the amount the player has banked!! Just a thought.

Cry Havoc and let slip the dogs of war
UTC +5:00
Mehnslayer
24 December, 2015, 3:00 AM UTC

viper_22664 said:


Ahhhh......I see the lords of this land have a witty sense of humor. Is this spreadsheet really so good I should betray my people??


Oh.....and where would one go to submit suggestions for the game?? At the top of my list is.....Have a calculator built into the BG's that automatically reports the amount the player has banked!! Just a thought.

http://forum.plarium.com/en/stormfall-age-of-war/game-discussion/topics/suggestions-thread-/6/ Suggestions thread my Lord

E 'n la sua volontade è nostra pace
UTC +10:00
viper_22664
24 December, 2015, 3:39 AM UTC
I'm forever in your debit Lord Mehnslayer. Many thanks. ****bows humbly****
Cry Havoc and let slip the dogs of war
UTC +5:00
djmoody
24 December, 2015, 4:14 AM UTC

viper_22664 said:


Ahhhh......I see the lords of this land have a witty sense of humor. Is this spreadsheet really so good I should betray my people??


Oh.....and where would one go to submit suggestions for the game?? At the top of my list is.....Have a calculator built into the BG's that automatically reports the amount the player has banked!! Just a thought.

Anything easy is of no challenge and therefore no interest to me.

I am know I am not the only person that thinks like this.

Dumbing down the game to this extent would lose them a lot of customers, especially in this kind of strategy game where by it's nature you are going to have attracted a lot of rational/logical type people who don't mind working stuff out for themselves as a part of the challenge/fun of playing.

Instant gratification is not a good thing (even if it is something a lot of us crave).

Everyone has a right to an opinion. No one has a right to their opinion being respected by other if it can't be backed up with rational and logic explanation
UTC +0:00
devnullicus
24 December, 2015, 5:50 AM UTC
Well, the good news is that if you really don't feel like getting a Google account, you can wait a while and I'll have the C# version of this done :)  I'm a good chunk of the way done already and the UI is much cleaner and easier to use.  The spreadsheet was just my way of learning how to do the BGs - an easy UI was always my end goal :)
If you ever want to know how the gods feel about money, simply look at who they choose to give it to [Caine Black Knife]
UTC -8:00
viper_22664
26 December, 2015, 4:21 AM UTC

Lord DJMOODY...I respectfully disagree. I don't feel it is dumbing down the game. Rather simply eliminating a laborius mondane task which probably repels more players than it attracts. After all doesen't your financial institutions provide you with statements of your accounts?? You can even access them 24 - 7 online.....just as it should be in this game. And, just as it is now, players who don't understand the mechanics of BG's, won't know what to make of the bank statement. I don't mind working things out for myself if the endevor is worth it but sorry, this is boring & rediculous.


Lord DEVNULLICUS......that sounds fantastic!!! I have constructeed my own sheet but gawd......filling it out makes clearing out a list of BG's a day long event. It is exactly the point I was trying to make with Lord DJMOODY. This would simply eliminate a long ardjous & unecessary task.

Cry Havoc and let slip the dogs of war
UTC +5:00
djmoody
26 December, 2015, 12:42 PM UTC

Bad analogy - you are supposed to know how your bank account works and exactly what is in it.

You are supposed to LEARN how BG's work. Game mechanics are supposed to be hidden providing you the challenge of working them out.

You need to learn what troops add to banks, do eldrict units counts, what about imperial, is there a tax etc etc etc. To be honest knowing there is a bank based on resource value of troops at all is giving the game mechanic away somewhat (although this is now such common knowledge you could argue there is no longer a point in hiding it).

Everyone has a right to an opinion. No one has a right to their opinion being respected by other if it can't be backed up with rational and logic explanation
UTC +0:00
viper_22664
26 December, 2015, 7:36 PM UTC

On the contrary my lord, this is a great analogy. Again, the existence of a bg bank statement will not make it easier for players to LEARN BG's, only easier to monitor your progresss. Players wanting to learn more about the game come to this forum, which is exactly what the forum is for. Those players who either are not worried about or, simply don't have the time for learning more, won't come to the forum. You remind me of a skilled employee, who is ready for retirement & resents the new guys comming in because you feel they haven't walked the "road of hard knocks" as you have. Most people don't have the time to spend hours, days, or weeks learning the game; as maybe you have. But, that doesn't make the sharing of information, & these forum posts a crime. Am I also to assume, that now, because you seemingly already know everything about the game that you are now bored with it???


Tell you what. Let's take a survey.


Those who agree with Lord DJMOODY's point of view, click the like button under his post.

Those who agree with my point of view, please click the like button under my post.


Thanks everyone & I hope you ALL had a great christmas & have a happy new year.


Cry Havoc and let slip the dogs of war
UTC +5:00
1724607 users registered; 43496 topics; 271461 post; our newest member:vova.kondakov.48