Battlegrounds Spreadsheet

72 Replies
D.a.M. Freya
8 May, 2016, 1:43 PM UTC
This thread needs to be updated for the new bg system plarium coded for. It seems to change on a weekly basis. The bgs are more like a garbage can for troops you are angry at. :(
Freya
UTC +5:00
tom
18 July, 2016, 8:34 AM UTC

just found this. thanks for your hard work. but unless I am misunderstanding or doing something wrong, it seems like v4.2 may no longer be relevant.

I tried to PM, but (at least on my computer) that interface is totally unusable -- it loses about 9 of every 10 keystrokes, and there is no way to include images.


On offensive BG's in particular, it seems as if there is now an element of randomness that is not accounted for by your static BG Level based estimate of enemy forces. Perhaps you need to go to a system like the Def BG where you sacrifice a pikeman to learn the actual enemy strength. On low-level BG's where the recommended initial 10-20 infantry units would be total overkill, it's estimates of enemy strength seem way off. For example, it gives me 210 for this BG:



Other than that, the only bugs I see are cosmetic. A number of the cells seem to have lost their formatting -- they right justify instead of centering like you seem to have intended. And there are a number of grammatical & word usage errors (which I can totally excuse on the grounds that you are probably not a native English speaker.)

As for feature requests for the next version, some things I'd like to see are:

  • Friendlier instructions on how to get started for novice players, such as me. Perhaps start with a simple explanation of how BGs work, maybe something like: "Stormfall Battlegrounds are different from battles in most other games. You don't want to win every battle on the first try. Think of it like a casino slot machine--the more units that you pay in, the greater your chances of eventually hitting a very large reward payout." Then include the forum link up front instead of at the end of the instructions.
  • In Def BG instructions 8 & 9, instead of the vague text about guesstimating or using Payout BG Level, it would be nice to have a discussion of how first time users can figure out or reset their actual bank status after many battles before they learned about how the system works. Also "Remaining Payout Balance" does not appear on the sheet. I'm guessing that it was changed to "Bank Credits" at some point. It would also help to give a bit more guidance on what you mean by a "MUCH larger payout", for example, is it 2x, 10x, 100x, ...?
  • I would like to see N/A (Not Applicable) added to the drop-down menus in the Def BG sheet as many users might not have access to Cavalry, Occult and Bestiary units until they discover the requisite Lost Arts, and have each category default to either N/A or the cheapest unit in that category rather than Golem.
  • I realize that this idea would add a lot of complexity to the sheet, but it would make user's lives a lot easier in updating and save time. I would like to see a lot more granularity in the bonuses applied on the Data sheet. Have a table for each type of effect, drop-downs to select what levels each effect has been upgraded to, and what is enabled. For example: Lost Arts and the Obelisk are "Always On" but need to be kept up to date wrt levels, The Hero, Temple of War, and the Sanctuary of Shards are Always On, but depend on what is installed. Paragon bonuses depend on your Paragon level and are either activated or not. Dragon bonuses depend on Dragon Arts levels and which are selected, etc. All of hes things could be selected & calculated, and remove the need to individually edit every cell in the data sheet every time something changes.


UTC -5:00
Lord Mark
4 August, 2016, 4:58 PM UTC

I have a question :

If i Boost my off and hit BG my Bank it will fill up?


In other words if i hit with Boosted truppes...i will go up in BG faster but i will need to fill up the bank in the same way?


Wich metode is better?

Boost or no Boost in BG ?
UTC +0:00
exxxe
4 August, 2016, 6:21 PM UTC

Lord Mark said:


I have a question :

If i Boost my off and hit BG my Bank it will fill up?


In other words if i hit with Boosted truppes...i will go up in BG faster but i will need to fill up the bank in the same way?


Wich metode is better?

Boost or no Boost in BG ?

lord Mark 


if your interest is to finish BG's faster and to go up in lvl then boost your units off and def stats 


however the bank only depends on your units resource value which means if you want to fill your bank faster then choose expensive units 
I'am me and that is what i care about :)
UTC +3:00
tom
5 August, 2016, 11:39 PM UTC

I gave up on trying to track the bank. With all of the changes, it's just too much stress & accounting for too little reward.


For offensive BGs I now use a dirt-simple spreadsheet with a row for each type of Balur unit, a column to enter number of each, and formula columns for Inf, Cav, Occ & Bst that multiply by the defensive strength of each type. It sums the columns, I pick the lowest & attack with that class of units.

I can now blow through a day's worth of offensive BGs in about 20 minutes and most of that is waiting for the results. Send a Pikeman to every one, when the reports come back, read & dispose of them one at a time by entering the surviving enemy numbers, pick the type of unit they are weakest against and send just enough to kill them. There is an element of randomness a higher number doesn't guarantee a win, but 10% or more higher seems to. Then read the next BG report & repeat.


For defensive BG I use just the top bit of Devnullicus's sheet to help calculate what to send. I ought to make my own that is designed more to my taste, but i'm really pretty clueless with spreadsheets.
UTC -5:00
jssamp2003
10 August, 2016, 7:17 AM UTC

On the Attack calculator sheet I noted the note,

"NOTE:  This page is a Work in Progress and does not fully work yet - estimated losses are not being calculated yet "

If you like I could help you finish it. Excel and Matlab formulas are kinda my thing.

                                 

Here is an exemplar of my work, an attack calculator for the game Oil Empires:

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

I will have some time free this week and into next before I have to get back to telemetry and avionics.

EDIT: This works best in Excel, Google docs doesn't have all of the functions and formatting used in my formulas..

If you don't make mistakes you are doing engineering wrong. If you don't fix the mistakes you are doing engineering way wrong. If you don't admit you make mistakes you aren't doing engineering.
UTC +7:00
jssamp2003
10 August, 2016, 7:39 AM UTC

tom said:



As for feature requests for the next version, some things I'd like to see are:

  • Friendlier instructions on how to get started for novice players, such as me. Perhaps start with a simple explanation of how BGs work, maybe something like: "Stormfall Battlegrounds are different from battles in most other games. You don't want to win every battle on the first try. Think of it like a casino slot machine--the more units that you pay in, the greater your chances of eventually hitting a very large reward payout." Then include the forum link up front instead of at the end of the instructions.
  • In Def BG instructions 8 & 9, instead of the vague text about guesstimating or using Payout BG Level, it would be nice to have a discussion of how first time users can figure out or reset their actual bank status after many battles before they learned about how the system works. Also "Remaining Payout Balance" does not appear on the sheet. I'm guessing that it was changed to "Bank Credits" at some point. It would also help to give a bit more guidance on what you mean by a "MUCH larger payout", for example, is it 2x, 10x, 100x, ...?
  • I would like to see N/A (Not Applicable) added to the drop-down menus in the Def BG sheet as many users might not have access to Cavalry, Occult and Bestiary units until they discover the requisite Lost Arts, and have each category default to either N/A or the cheapest unit in that category rather than Golem.
  • I realize that this idea would add a lot of complexity to the sheet, but it would make user's lives a lot easier in updating and save time. I would like to see a lot more granularity in the bonuses applied on the Data sheet. Have a table for each type of effect, drop-downs to select what levels each effect has been upgraded to, and what is enabled. For example: Lost Arts and the Obelisk are "Always On" but need to be kept up to date wrt levels, The Hero, Temple of War, and the Sanctuary of Shards are Always On, but depend on what is installed. Paragon bonuses depend on your Paragon level and are either activated or not. Dragon bonuses depend on Dragon Arts levels and which are selected, etc. All of hes things could be selected & calculated, and remove the need to individually edit every cell in the data sheet every time something changes.

+1. As a new comer just yesterday I am still unclear on the jargon; BG, payout levels, etc.

Another nice feature would be if the enemy troops would populate the chart automatically; perhaps through the spy report?

In my last post I volunteered my assistance with it if needed.


If you don't make mistakes you are doing engineering wrong. If you don't fix the mistakes you are doing engineering way wrong. If you don't admit you make mistakes you aren't doing engineering.
UTC +7:00
tom
13 August, 2016, 7:07 AM UTC

i think my modified version of Devnulicus's spreadsheet is available here: https://docs.google.com/spreadsheets/d/1GKjiZydlPCnLowHhQ7X_pt2wGGgNLRbq4tH31-S6IZQ/edit?usp=sharing


there is definitely room for improvement. what I am currently looking for is simplicity and ease of data entry. if I wanted to track every unit scored or lost and every BG, I could easily write a db app to track everything, but updating it would just suck all the fun out of playing.


what i am looking for is simplicity and ease of data entry. i currently don't care about tracking losses or trying to predict when the next payout is coming as that has not worked since before I started playing and  am not sure it is even possible in the face of almost daily rules changes. my current model is: send out a minimum cost unit (archer or pikeman) to a bunch of BGs; get the reports; read them one at a time and send appropriate troops to kill each.

my offensive bg calculator is the last page. it is not linked to any of the others. you just enter 4 numbers and pick the lowest score youhave the units for. obvious improvements would be to highlight the best number & a clear button. i don't know how to do either.


i'd like to see the current data entry table turn into a calculated table, fed by entering your current levels of the various unit lost arts, and other things that affect unit values.

there is no good way to do what you suggest as far as automatically populating the sheets as the game does not provide an API for that, and Plarium might consider it "cheating"

PM me an email addr if you want to discuss this offsite.

tom

UTC -5:00
Nemanja
13 August, 2016, 10:29 AM UTC

Lord Tom,

nice work :)

I hope this could help other players.
Nemanja
UTC +1:00
tom
14 August, 2016, 12:02 AM UTC

I can't take credit for it. 99% was someone elses work. I only changed some defaults and added a simple sheet that I use.


I don't get the whole spreadsheet thing. In real life I'm an embedded systems & device driver guy. no need for pretty user interfaces.
UTC -5:00
John
14 August, 2016, 7:28 AM UTC

tom said:


i think my modified version of Devnulicus's spreadsheet is available here: https://docs.google.com/spreadsheets/d/1GKjiZydlPCnLowHhQ7X_pt2wGGgNLRbq4tH31-S6IZQ/edit?usp=sharing

Hi Tom, 

This is not for Stormfall though but for some other game you must play

UTC +8:00
tom
14 August, 2016, 10:01 PM UTC

sorry. that was my corrected Non-Weapon Proficiencies for 1st edition AD&D. don't know how that happened. I hope this will be the correct link::

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

UTC -5:00
Alyona Kolomiitseva
Community Manager
15 August, 2016, 9:29 AM UTC
tom said:

sorry. that was my corrected Non-Weapon Proficiencies for 1st edition AD&D. don't know how that happened. I hope this will be the correct link::

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

We can't open it without asking for permissions. Could you please share it for vieving?
Plarium Community Manager. Please note that I will be unable to respond to your private messages, review your tickets, or check your account information. All technical issues should be directed to our Support Team at plrm.me/Support_Plarium
UTC +2:00
1722968 users registered; 43020 topics; 272461 post; our newest member:daveyddick57