OK, updated Spreadsheet to Version 4.2.   Changes are:

• Modified BG Payout to be clearer. It just shows Bank Credits and what level of BG will currently give a payout. Much simpler to understand.
  
• Added instructions for an interesting new experimental BG method
  
• Added Huntress to Def BG units

Same URL as the 4.0/4.1 spreadsheet, i just updated it in place.

thanks very much, how about adding tournament points?

how do transfer my bank from 4 to 4.2 ?

I actually did make a stab at adding in rewards from BG tournaments to the ratio calculator, just forgot to mention it in the changes list, I think.  Take a look at the bottom of the bank tab.   Unfortunately, I don't think it's complete yet as I didn't add space for the daily rewards which has a lot more types of things you can get.   It's a work in progress :)

As for copying from 4.0->4.2, that is something I hadn't really thought about until last night.   It's tricky because you don't want to just cut-n-paste areas because the formulas might have changed. 

For the bank page, you can safely cut and paste the following columns "Last Large Payout", "Overflow Killed (Credits)", "Overflow Number Rewarded (Debits)" from "Archer" through "Food".   Be careful though because Reavers and Huntress were added, so you'll have to make sure the old values are in the proper rows on the new spreadsheet.

In order for the bank to be correct, you'll ALSO need to copy the "Previously Accumulated Totals" columns on the Defensive and Offensive BG tabs.  You'll need to grab the rows for "Own Units Killed" and "Rewards" ("Initial Enemy Units" and "Enemy Killed Rows" are optional - they're just fun data to know).  Again, be careful to make sure the values get copied to the correct new rows because of the addition of Reaver and Huntress.

For all other pages, you should just be able to safely copy and paste any cells that have a white background.

I'm not sure if there's a way to automate this - there might be.  I'll give it some thought and see if I can't figure out a way.  For now, those instructions will have to do.

I actually did make a stab at adding in rewards from BG tournaments to the ratio calculator, just forgot to mention it in the changes list, I think.  Take a look at the bottom of the bank tab.   Unfortunately, I don't think it's complete yet as I didn't add space for the daily rewards which has a lot more types of things you can get.   It's a work in progress :)

As for copying from 4.0->4.2, that is something I hadn't really thought about until last night.   It's tricky because you don't want to just cut-n-paste areas because the formulas might have changed. 

For the bank page, you can safely cut and paste the following columns "Last Large Payout", "Overflow Killed (Credits)", "Overflow Number Rewarded (Debits)" from "Archer" through "Food".   Be careful though because Reavers and Huntress were added, so you'll have to make sure the old values are in the proper rows on the new spreadsheet.

In order for the bank to be correct, you'll ALSO need to copy the "Previously Accumulated Totals" columns on the Defensive and Offensive BG tabs.  You'll need to grab the rows for "Own Units Killed" and "Rewards" ("Initial Enemy Units" and "Enemy Killed Rows" are optional - they're just fun data to know).  Again, be careful to make sure the values get copied to the correct new rows because of the addition of Reaver and Huntress.

Edit: to more easily determine which places you need to copy, I've modified the 4.2 version to have the cells that you need to copy have a light orange background.

For all other pages, you should just be able to safely copy and paste any cells that have a white background.

I'm not sure if there's a way to automate this - there might be.  I'll give it some thought and see if I can't figure out a way.  For now, those instructions will have to do.

1DonutBoy:  I do, actually.  On the defensive BGs, you just choose the troop types and it tells you the amount needed and in the Offensive BGs, it tells you how many of the "optimal" troop types you need in the "Number and Cost to Yellow" and "Number and Cost to Kill" rows (35-56)

Thank you.  Yoour time and effort are greatly appreciated.

Respectfully,

proposal for a addition bank resources split gold-iron-food or in % (for study :D)

Jumy: Hmmm, wouldn't be too hard to add, actually.  I will consider this for next version.

wauu and and always thanks :)

bgs has changed a lot.... not according plarium

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.

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?

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 

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.