*Author

kirchj33

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg319916#msg319916
« Reply #24 on: April 25, 2011, 11:24:57 pm »
@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

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg324426#msg324426
« Reply #25 on: May 01, 2011, 07:04:25 pm »
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.

Offline TimerClock14

  • Legendary Member
  • ******
  • Posts: 2507
  • Country: us
  • Reputation Power: 32
  • TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.
  • hello pls
  • Awards: War III Promo Winner
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg324433#msg324433
« Reply #26 on: May 01, 2011, 07:06:58 pm »
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.
I have music, you have ears. Let them get acquainted with each other: https://www.soundcloud.com/mastinmusic

Scaredgirl

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg324435#msg324435
« Reply #27 on: May 01, 2011, 07:10:01 pm »
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?

Offline TimerClock14

  • Legendary Member
  • ******
  • Posts: 2507
  • Country: us
  • Reputation Power: 32
  • TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.TimerClock14 is a Ghost, obsessed with their Elemental pursuits.
  • hello pls
  • Awards: War III Promo Winner
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg324439#msg324439
« Reply #28 on: May 01, 2011, 07:11:14 pm »
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.
I have music, you have ears. Let them get acquainted with each other: https://www.soundcloud.com/mastinmusic

Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg324786#msg324786
« Reply #29 on: May 02, 2011, 03:39:23 am »

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

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg324937#msg324937
« Reply #30 on: May 02, 2011, 11:36:44 am »
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.

(...)

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg324957#msg324957
« Reply #31 on: May 02, 2011, 01:27:03 pm »
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.

Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg324959#msg324959
« Reply #32 on: May 02, 2011, 01:33:53 pm »
Saving a lot of people, a lot of work +karma cheers jango  :D

Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg325073#msg325073
« Reply #33 on: May 02, 2011, 04:48:43 pm »


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.  :P

(...)

  • Guest
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg325086#msg325086
« Reply #34 on: May 02, 2011, 05:11:48 pm »
This is how it looks for me, no background image



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

Offline JangooTopic starter

  • Sr. Member
  • ****
  • Posts: 877
  • Reputation Power: 0
  • Jangoo hides under a Cloak.
  • New to You
Re: STATMASTA™realtec - Keep it real (now with actual cardspin rates!) http://elementscommunity.org/forum/index.php?topic=21654.msg325124#msg325124
« Reply #35 on: May 02, 2011, 06:20:29 pm »


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.  ;)


 

blarg: