Jangoo has been a big help with tracking False God stats with STATMASTA™realtec (
http://elementscommunity.org/forum/index.php/topic,21654.0.html). I first want to say a big thank you to Jangoo for all the work he has done to make False God stats interesting and useful for the community.
I like to be able to drag my stats around with me via web-based services and share the entire set with others quickly so was craving a Google Spreadsheet version of Jangoo's STATMASTA™realtec. This is the first time I'm sharing this, so I'm only going to give a basic rundown of how to use it and hope you can give some feedback to make this as usable as possible. I can't say this is perfect until the community thinks it is.
Here is what I've put together and have been using for a little while:
False God Stats (Google Docs) (
http://goo.gl/tjuMk)
The sheet is public but not editable, so the first thing you'll want to do is:
File > Make a copy...
This puts a copy of the sheet in your Google Docs.
Boxes with an orange triangle in the corner have comments. Hover your mouse over them to read the comments.
* The green boxes are ones where you should directly input data or directly modify settings.
* The blue boxes are automatically populated with data and should not be touched.
* The yellow boxes have an average formula which you should edit with new data. The formula will look like:
= IF(C2 > 0, (0) / C2,)
Click once in a yellow box and look at the forumla input box which appears at the top of the spreadsheet, just under the toolbar. You will edit the formula in this box. You should change the (0) part of the formula to be a sum of time or turns.
For example, if you have fought Akebono once with a Time to Win of 78 the new formula will be:
= IF(C2 > 0, (78) / C2,)
If you have fought Akebono a scond time with a Time to Win of 94 the new formula will be:
= IF(C2 > 0, (78 + 94) / C2,)
And so on...
At the bottom of the spreadsheet you'll see some settings for CWR, E/W, and E/C. These numbers may be edited. Read the comments provided in the sheet for an explanation. Jangoo has posted the best numbers to use in a thread linked to in the box labeled
Link. Simply click on the box next to the
Link label and copy, then paste into your favorite browser to view the thread. For reference, here is the link:
http://elementscommunity.org/forum/index.php/topic,14626.msg198172#msg198172The Min Fights box is another useful setting you can modify. Read the comments provided on the sheet. This setting is the minimum number of fights you would like to have had with a false god before the sheet gives you skip recommendations. These recommendations appear as colored boxes to the left of each of the false god names. Red means skip, yellow means difficult, and green means easy. By starting with a Min Fights setting of 0, you will start seeing recommendations as soon as you fight a false god and input stats. However, these will not be reliable until probably 10 fights with a given false god.
Finally, I'm working on a
Forum Post feature to let you post your stats as a simple table in the forums. STATMASTA™realtec has this feature, and it is doable with Google Spreadsheet. I just haven't decided what is best to put in that table, so your feedback would be appreciated. To use the
Forum Post feature, look at the bottom of the spreadsheet and find the
Forum Post label. Click once on the box to the right of this label to select the forum code, copy, and then paste into the forums.
Thank you for taking a look.
