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..

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.

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

Lord Tom,

nice work :)

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.

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

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

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

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?