# Buying BA and fighting clans. (in General)

## AdminQBVerifex[Serenity In Chaos]June 1 2005 8:14 AM EDT

I wanted to show you all a very VERY simplistic Excel spreadsheet of what fighting in clans and buying ba and how it all adds up.

The formulas are all right there for you to look at in the sheet itself.

The great part is.. you can change the values to reflect what you your individual character has.

I hope this is useful to you..

The excel sheet

Very nice!

## AdminG BeeeJune 1 2005 8:41 AM EDT

This looks nice Verifex.

You can enter your "exact" rewards by following the formula that Avoid (I think it was avoid) posted a while back. He said...

The first step is to attack a character twice, and record the cash rewards for each battle. If you get the same number twice, or if they are only a dollar or two off, you'll need a third battle.
Then Take the higher of your two values and divide it by the lower.
If you get 2.25,2,1.75 or 1.25, multiply the lower cash value by 13/8 to get your average cash reward.
If you get 1.8,1.6,1.4 or 1.2, multiply the lower cash value by 13/10 to get your average cash reward.
If you get 1.333 or 1.667, multiply the lower cash value by 13/12 to get your average cash reward.
If you get 1.286 or 1.143, multiply the lower cash value by 13/14 to get your average cash reward.
If you get 1.125, multiply the lower cash value by 13/16 to get your average cash reward.
If you get 1.5, there are two possibilities for what your average cash reward can be - low*13/8 or low*13/12. You can look at both and guess which is right, or you can fight another battle and try again, or you can find a nice quiet corner and cry.

## DukeJune 1 2005 9:01 AM EDT

Mininon number is nowhere.
This thread is closed to new posts. However, you are welcome to reference it from a new thread; link this with the html <a href="/bboard/q-and-a-fetch-msg.tcl?msg_id=001N1t">Buying BA and fighting clans.</a>