STATMASTA™realtec - Keep it real (FG-statkeeping tool)

[Absol]

Read the OP. It says use "OpenOffice.Org"

[Jesuperman]

Read the OP. It says use "OpenOffice.Org"

thanx !!

[Zso_Zso]

Does anybody have a version of this spreadsheet with TTW also recorded ?

[Jangoo]

Well, it's been a year ... sorry for having abandoned this guys but there was stuff to be done.
Good news is, apparently not much has changed: Still 12 29 gods, still 3 spins per win ...
... Akebono and Osiris now have 2 Shards which will make them slighty (!) less profitable
than indicated in the Statmasta as of now.

Anyways, I reuploaded the realtec-Edition in the OP and here it is again:

DOWNLOAD STATMASTA™realtec
              (FOR OPEN OFFICE ONLY)



Also, can a mod move this to the tools section please?  

[eaglgenes101]

^12 Gods? That's ages ago!

[Jangoo]

Hahaha hilarious ... "ages ago" ... so am I apparently.

Indeed, it's a few more now. They are all in there, no worries. 

[neuroleptics]

why is this good app hidden from my knowledge till now? Good job!!!

[Luminous]

Hahaha hilarious ... "ages ago" ... so am I apparently.

Indeed, it's a few more now. They are all in there, no worries. 

Not a few more, about 20-30.

[Jangoo]

why is this good app hidden from my knowledge till now? Good job!!!

The "General discussion" section is renowned for burying any- and everything under a pile of Bla.
How many times have I searched for "that useful little thing that guy posted at some point in time in the General section" ... 

[pulli23]

So..... This ain't working  anymore.

I just did some longterm testing and the time was over 8 hours - now it is showing asynch errors everywhere.


EDIT: just who thought it was a clever idea to hide the important cells (Q to T).

[Pella]

So..... This ain't working  anymore.

I just did some longterm testing and the time was over 8 hours - now it is showing asynch errors everywhere.

The spreadsheet works just fine when you follow the author's instructions.  Asynch errors "everywhere" clearly indicate that you did not.  I suspect that you made large entries for total time for wins, losses, and skips for each FG instead of individual entries for each duel.  That's what the "asynch error" columns are designed to detect.  (Actually, I suspect even more strongly that you made only one huge entry for total time spent.)

The good news is that asynch errors have no effect on the spreadsheet's calculations.
The bad news is that asynch errors prevent the spreadsheet from executing many of those calculations.
The other good news is that one tiny change will eliminate the bad news.  Edit Input!N35, delete the formula there, and enter a 0.  Voila!

just who thought it was a clever idea to hide the important cells (Q to T).

The spreadsheet's author thought it was a "clever idea" to hide the important cells because he had no control over who downloaded and used his spreadsheet.  Spreadsheet geeks can unhide those cells and look around.  Such people understand the risks involved in making changes, and usually can repair any damaging changes.  Obviously, the author hid those cells to prevent people from inadvertently changing or deleting the things that make the spreadsheet work.  This is particularly true for spreadsheet non-geeks. 


Having said all that, I think you may find this post interesting.  You probably will want to read it before you spend much more time with STATMASTA.  Just sayin'.