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

[kirchj33]

@kirch:  What happened to the display of your win-rate?
It is set to format to "00,00%" so I am kind of puzzled how you got "020%"   .



Damn, the "bug" is back. I thought I had dealt with this but apparently not.
For some reason, my Excel seems to reset the cell-formatting for this particular field,
hence joining 3 cells to make a large one keeps failing. Whyever the error-message claims
it has something to do with sheet-protection.
In the next update, this field will simply be 1 cell to avoid complications.

First, I have no idea why it posted that way... I just added the forum code and voila!

Secondly, I found that if you enter the deck code above, directly into the data entry spot (long bar representing the cell up top) it allows you to enter the deck code.

[Scaredgirl]

Cool project but would be even better as a Google Docs Spreadsheet. This way people could use it with their browser and not by downloading a file and then opening it in Excel.

[TimerClock14]

Cool project but would be even better as a Google Docs Spreadsheet. This way people could use it with their browser and not by downloading a file and then opening it in Excel.

Problem:
Google docs is one of two things at any given time:
Collaborative
Private

If you have more than one person using this, then they will need to wait in line. Otherwise the collaborative editing feature on Google Docs will interfere.

Making it a downloadable excel spreadsheet was the only way to make it useful.

[Scaredgirl]

Cool project but would be even better as a Google Docs Spreadsheet. This way people could use it with their browser and not by downloading a file and then opening it in Excel.

Problem:
Google docs is one of two things at any given time:
Collaborative
Private

If you have more than one person using this, then they will need to wait in line. Otherwise the collaborative editing feature on Google Docs will interfere.

Making it a downloadable excel spreadsheet was the only way to make it useful.

Yea but can't you make it so that everyone takes their own personal copy of it?

[TimerClock14]

Cool project but would be even better as a Google Docs Spreadsheet. This way people could use it with their browser and not by downloading a file and then opening it in Excel.

Problem:
Google docs is one of two things at any given time:
Collaborative
Private

If you have more than one person using this, then they will need to wait in line. Otherwise the collaborative editing feature on Google Docs will interfere.

Making it a downloadable excel spreadsheet was the only way to make it useful.

Yea but can't you make it so that everyone takes their own personal copy of it?

I'd have to look it up, but right now I don't think you can.

[Jangoo]

Also, from what I hear, google-docs does not support Macroes.
The Statmasta needs a certain Macro to guarantee unadulterated, perfectly pro stats.
But is downloading and simply doing it on ones hard-drive really all that bad?


Other than that:

The Statmasta3000 has been taken off the market.
For a, yet to be revealed, specific purpose I have reworked the codes and very soon

the new and of course waaaay better  Statmasta™4000 will be available.


The Most prominent new features will be:

- score-related stats including a normalized score/h stat
   (get a grip on those pesky speed-decks that forced you to quit the CL  )

- HP-tracking system for highly accurate score- and electrum calculation
   (deck-scientists get ready, all the others: relax, it's fully optional of course)

- reworked normalized stats now also normalizing the time played
   (it doesn't normalize girlfriends yet but we are working on it ... )


Screenshots of the Statmasta4000 can be viewed in the OP.

[Scaredgirl]

Also, from what I hear, google-docs does not support Macroes.
The Statmasta needs a certain Macro to guarantee unadulterated, perfectly pro stats.
But is downloading and simply doing it on ones hard-drive really all that bad?

Google Docs has Macros.

It's not that bad, but  a tool that you could use with a regular browser without any downloads or additional software, would probably get much more users. If converting to Google Docs would be easy to do, you should definitely look into that, because currently you are leaving out two groups of users, which are:

A) Players who don't like to download stuff
B) Players who don't have Excel

I don't know the actual statistics, so I have no idea how many potential users are left out. But I do know that group B has more then a couple of members.

[(...)]

Also, from what I hear, google-docs does not support Macroes.
The Statmasta needs a certain Macro to guarantee unadulterated, perfectly pro stats.
But is downloading and simply doing it on ones hard-drive really all that bad?

Google Docs has Macros.

It's not that bad, but  a tool that you could use with a regular browser without any downloads or additional software, would probably get much more users. If converting to Google Docs would be easy to do, you should definitely look into that, because currently you are leaving out two groups of users, which are:

A) Players who don't like to download stuff
B) Players who don't have Excel

I don't know the actual statistics, so I have no idea how many potential users are left out. But I do know that group B has more then a couple of members.

I use it on open office, you only need to turn macros on and i think it's the same as on excel.

[spiritkirinblade]

Saving a lot of people, a lot of work +karma cheers jango 

[Jangoo]

Google Docs has Macros.

It's not that bad, but  a tool that you could use with a regular browser without any downloads or additional software, would probably get much more users. If converting to Google Docs would be easy to do, you should definitely look into that, because currently you are leaving out two groups of users, which are:

A) Players who don't like to download stuff
B) Players who don't have Excel

Hmyeah, there have already been some complaints about not having Excel.
While I really couldn't care less about groupA, groupB bothers me too.

Now I only looked into google-docs for a short moment when I started coding
the Statmasta and it all looked so ... slim, stripped down to nothing and uncomfortable.
I am assuming that's just the layout?
Could I include the shiny background graphics in google docs?

[Btw, I think the reputation is broken or delayed or is the message system isn't
working or ...  none of the Rep recently given to me has reached it's destination.]

I use it on open office, you only need to turn macros on and i think it's the same as on excel.

Hmmmm ... interesting. So you are actually using the original Statmasta-file by simply opening it
in open-office? And the Macro works? (something visible about it: it should yield "!!!"s in the async-columns
when there is the said asynchronisation)
Are the background-graphics properly displayed as well? Are the forum-code fields working?
Is the sheet-protection in place? (shouldn't be able to mess with anything other than input-fields)

I am a bit curious now whether it works or not under open office and under which circumstances
because statements about the (in)compatibility couldn't be more varied:

Does this work with openoffice...?

Nope, and it doesn't work with Google Docs either.  Macro support for everything that Excel does is where Open Office/ Libre Office are lacking.

Looks like a cool tool, but unusable by me because I don't have windows. 

[(...)]

This is how it looks for me, no background image



It seems that forum code is not working, not sure why, never used it

[Jangoo]

Oha ... thanks for sharing.

Since you used the original data I can see that all the stats are calculated correctly.
Formatting and layout is only off by a tiny bit, nothing ugly at least.
Just the FGei(cn) and forum-codes don't seem to be working ...

Good enough: Will download open-office some time soon and check it out in detail.