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

[Giantfrog]

Ya I just noticed that I was tired when I started doing the stats and didnt even think about it thanks for the fast reply and all I am glad that I realized this as soon as you posted thanks for a great stats calculator.

[Giantfrog]

Any idea as to why the fgei and fgeic isn't displaying as a averaged out stat? Here are the screenshots of my main page and second page. My only assumption is certain games have skips and no times recorded but that just doesn't feel right at all everything else displays normally... Not the master of stat masta yet but one day I will triumph and get the stats I am looking for in detail xD.

[Jangoo]

That is weird indeed.

The three normalized stats aren't up yet because you got several gods with only 2 games played and you need three games per god.
But as far as I can see, score/h and FGei(c) should be displayed.

My only assumption is certain games have skips and no times recorded.

In order to make those stats work you have to record a time for each and every game.
Still, you would have "!!!" in the third column of the async-warning if you hadn't done that.
Since all your skip-sums are skip-games x 5, I also assume you actually did enter 5 seconds for each skip ...

So I got no idea why that is. Can you upload a copy of that file with e.g. Rapidshare and post the link?

[Giantfrog]

Here is the link for downloading via rapidshare.

https://rapidshare.com/files/385097493/Fatfat_Limitless_Speed.ods

[Jangoo]

Thanks.

The file works perfectly under my OO 3.3 : FGei(c) and score/h are displayed and as soon as you hit 3 games/god the normalized will be displayed too:

deck	Limitless speed FG OTK [Semi-Unupped]FAT FAT
players	GiantFrog

version	1.29		win-rate	32,08%
$ track ?	enabled		win-rate (n)	n.a.
games	106		Score/h	233
win-loss-(EM)	34-72-(18)		Score/h (n)	n.a.
time (h:m:s)	06:10:43		FGei[c]* (http://elementscommunity.org/forum/index.php/topic,14626.0.html)	3199
min/game	03:30		FGei[cn]* (http://elementscommunity.org/forum/index.php/topic,14626.0.html)	n.a.

      Statmasta™realtec                                                               


So ... yeah ... hmm ... did you activate your macros as described in the quick-guide?

If yes, you could also try "running though" the skip-game and skip-times columns (and all others if these two don't change anything)
by marking the top cell and pressing ENTER 28 times to "actualize" the cells.
That is kinda bs really but I believe OO (and Excel) open a file "as is" at first and only start to check on background routines
when the respective cells are changed.
E.g., if I were to create a file having the macros activated everything would be just fine. Reopening the
file but acidentally hitting "deactivate macros" may display everything as it were before and problems only
occur when I start changing certain cells.

Other than that there is only left to ask what exactly you meant by "certain games have skips and no times recorded",
if you have changed anything in the code or to advise a quick reinstall of open-office (which should be the latest release 3.3!).

[Giantfrog]

I want to say that I just reinstalled OO like about a week ago. So its up to date, I have macros enabled, I guess I can run through and hit enter tons of times. Worse come to worse is that I end up re installing OO again just to make sure everything is working properly. Or ending up having to get excel. I will let you know if anything starts working for some unknown reason.

Edit Apparently a weekago I dled 3.1..... Updating now.

Edit again. It is now updated and running full stats. I appreciate the help, weird that I dlied 3.1 not even 2 weeks ago and it updated on me xD oh well just means I have to stay on top of OO.

[Jangoo]

Dunno where you got that download from dude. OpenOffice has been at 3.3 for ages.

Anyways, glad it's working now.

[druidnia]

I have the STATMASTER but it is already full of data, is there a way to reset everything to zero so I can start entering my own data?

I have never used OO Calc before, so please assume I know nothing

[Djhopper :)]

I have the STATMASTER but it is already full of data, is there a way to reset everything to zero so I can start entering my own data?

I have never used OO Calc before, so please assume I know nothing

Read Below.

Also, always keep a blank copy saved ready!

[Jangoo]

I have the STATMASTER but it is already full of data, is there a way to reset everything to zero so I can start entering my own data?

I have never used OO Calc before, so please assume I know nothing

I think you mean that the sheet is already filled with my sample-data?
It's there to show you how everything should look like when you are
entering your data correctly.

You can just erase it by marking entire columns and hitting DELETE.
If OO asks what exactly you want to delete, choose values, text and formulas.

Enjoy.

[druidnia]

I think you mean that the sheet is already filled with my sample-data?
It's there to show you how everything should look like when you are
entering your data correctly.

You can just erase it by marking entire columns and hitting DELETE.
If OO asks what exactly you want to delete, choose values, text and formulas.

Enjoy.

Yes that is correct, however I tried to do what you said, but i get the message "protected cells cannot be modified" I'm obviously doing something wrong. Sorry to be a pain, but I would love to get this going.

[Jangoo]

No problem. I also noticed that this isn't in the quick-guide yet ...

You can't delete or alter protected cells, correct.
On the Input-sheet, these would be the two warning columns, the column with the gods names, the header-rows etc.
Anything framed in dark-red (bold) IS an input-field and can be deleted.
So all you have to do is mark/delete only those input-cells/columns in three steps.