viper_22664 said:

First off, who on earth, in their right mind & with real life responsibilities, ENJOYS spending days upon weeks developing a calculator for a GAME???

Obviously, you don't understand the mindset of a programmer.  If I didn't enjoy making things like this, I wouldn't have done it.   I, like many programmers, enjoy problem solving, research, and the satisfaction of making something complicated less so by the process of automation.   Besides, programming something that is complicated puts me in that "zone" and is very peaceful for me.  I could have programmed ANYTHING to achieve that inner peace, but I like Stormfall, I was bored and saw a problem that needed automation to make my own life easier.  That's really all it takes to launch any programmer on a months-long quest.

I am new here and I don't have a clue what you're talking about.

Okay. Ignore that first dumb question, I figured it out. 

Now the next dumb question. "You will have to authorize your copy to use the buttons. These buttons are necessary for the spreadsheet to work (sorry)"

How do I "authorize" my copy?

Again any help would be appreciated.

thanks for your work, please consider also huntress

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.

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)

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

This sounds like exactly what I have been looking for. Shame I don't have Google Drive or Spreadsheets & can't use it.

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 

A really good and nice work mylord

very usefull

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.

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.

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