| :fire Minimal testing :fire You only put in the number of games won, lost, skipped and EMed. This "historical" method of taking stats for FG-decks is very time-saving but only produces the win-rate and EM-rate as somewhat significant stats. In all honesty, that approach is outdated as of now and compares to e.g. evaluating a cars performance by looking at its horsepower only. |
| :time Timed testing :time In addition to the number of games won, lost, skipped and EMed, you also put in the time you played each game, which is displayed after each match in the details screen. This method of taking stats for FG-decks produces a variety of stats that express your decks true efficiency, most significant of which are the FGei-stats. It also yields a few interesting side-stats such as min/game played. Unless you really want to have an accurate account of your decks score-performance, I suggest using this method for your regular, everyday FG-deck-testing as a perfect compromise between effort and results. |
| :life Scientific testing: Timed and electrum-based :life In addition to the data used in Minimal- and Timed testing, you also put in the number of "raw" (before card-spins) electrum won after each non-EM game.. This is undoubtedly THE method for getting 100% accurate and conclusive stats. The accuracy of your electrum-related stats will be improved by up to 3%. Most importantly though, this method will fully validate all score-related stats since the exact score gained can be calculated from your raw electrum-gain per game. Testers that participate in a study, really want to produce 100%-pro stats and/or want to gain conclusive stats about a decks score-performance should use this design. |
| :fire I (wins, losses, skips) :fire unlock: games played, win-rate and normalized win-rate, approximation to the stats score/total and score/game Use these three columns to enter your basic data about winning, losing and skipping games against each False God. Directly increase the number in the respective cell by one whenever you won, lost or skipped a game. (Click cell -> enter new number) In order to take ANY stats, noting down this data is absolutely required! |
| :fire Ib (EMs/wins) :fire unlock: EM% +accuracy: FGei-stats, $-earned-, $/game-, all score-related stats Whenever you win a match with an Elemental Mastery, meaning with 100% of your HPs, you should increase the number in the respective cell by one. Note, that the input in this column is EMs out of all the wins you had, meaning that you should add 1 in the win-column AND 1 the EM-column. (For decks that have more than 100HPs max. health, refer to the FAQs at the end of this post) |
| :time II (times: win, loss, skip) :time unlock: time-total, time/game, FGei(e), FGei(c), FGei(cn), score/h and score/h (n). The two score-related stats will remain an approximation unless you also record electrum won. See below -> III. These three columns are used to enter your pure time needed for each of the games you played and noted down in the "games" columns. After each game, Elements will show you a game-time in seconds in the upper right corner of the "win-" or "details"-screen. Enter this number into the respective cell by using the following formula: =[time1]+[time2]+ etc. (without "[" brackets of course) It is imperative that you don't forget to enter a "=" when you put your first time into a cell. Without it, Excel cannot properly calculate the time-related stats! Also, if you record skipped matches, always enter a time of at least 1 (sec) in the respective cell! (Realistically you should enter the time actually needed to quit the god. The actual issue here is however that Excel needs a value > 0 here to calculate all of your stats.) Hint: Click cell -> F2 will take you directly to the end of the cells formula, so all you will have to do is enter a "+" and your next time once you get going. |
| :life III ($ won (noEM) :life unlock: HPs left/win 100% accuracy: all electrum related stats, all score related stats This is a recent addition to the STATMASTA-series. If you are interested in testing your deck to the max (see above: Scientific test-design), you should enter the "raw" electrum won after each regular win in this column: After each game you win, Elements will show you electrum won right above the slotmachine in the middle of the "win-screen". - It is important that you use the electrum-amount displayed BEFORE you spin the slotmachine! - Make sure you only enter regular wins here, no EMs and certainly no losses - win-electrum ranges: 35-59 electrum*, no more, no less ... be exact about this - If the electrum-amount is 120 or higher, you got an EM-win DO NOT enter this into the $-won(noEM) column!* (You already entered your EM, and the electrum that goes with it, by upping the count in the "EMs/wins"-column.) - If the electrum-amount is -30, you got a loss. DO NOT enter this either. (Your loss, and the electrum that goes with it, is already entered by upping the count in the normal "losses"-column.) To enter the electrum-amount into the respective gods cell, use the following formula: =[electrum]+[electrum]+ etc. (without "[" brackets of course) It is imperative that you don't forget to enter a "=" when you put your first electrum amount into a cell. Without it, Excel cannot properly calculate the respective stats! Hint: Click cell -> F2 will take you directly to the end of the cells formula, so all you will have to do is enter a "+" and your next electrum-amount once you get going. *For decks that have more than 100HPs max. health, refer to the FAQs at the end of this post |
| :time !!! -> the async warning :time As long as there is an active async-warning, a large number of stats cannot be displayed on sheet2+3: All time-related stats - time-total, time/game, all FGeis, score/h, score/h (n) - will be set to "n.a." See on top under "deciding on your test design" and below under the detailed stat-sheet descriptions for more information. This field is not an input field. It will show you when something went wrong with the data-entry in field "games" and/or "times" by displaying "!!!" in the respective cell. In the example, something is wrong with the wins or times (for wins) against the FG Incarnate. A !!! async-warning will show whenever: - You did not activate macros when opening the file - You forgot to enter a time (or game), which means that the number of games and the number of times noted are not the same (asynchronous). - You made a formula mistake entering a time. Most likely you forgot to start the cell with a "=" but you could also have accidently entered an invalid value like a second "+" or any other value that is not a number, a "+" or a "=" . See above "II: Time" for how the formula should look like. |
| :life $?! -> $won(noEM) async warning :life As long as there is a "disabled", all score-related stats - score-total, score/game, score/h, score/h (n) - are just an approximation. All electrum-related stats will be slightly less accurate and the HPs left/win stat will be set to "n.a." See on top under "deciding on your testing-design" and below under the detailed stat-sheet descriptions for more information. This field is not an input field. It works similar to the games<>time-async-warning: It will show you when something went "wrong" with the data-entry under "wins" and/or "$ won(noEM)" by displaying "disabled" in the respective cell and consecutively for the entire column in the top row. In the example, the $-tracking is disabled (=invalid) for the FG Seism. A "disabled" will show whenever: - You did not activate macros when opening the file - You did not enter an electrum-amount for a regular win (not EMs!), which means that the number of wins and the number of electrum- amounts noted are not the same (asynchronous). - You made a formula mistake while entering an electrum-amount. Most likely you forgot to start the cell with a "=" but you could also have accidently entered an invalid value like a second "+" or any other value that is not a number, a "+" or a "=" . See above "III: $ won(noEM)" for how the formula should look like. |
| :underworld Cards won :underworld unlock: $ earned, $ per game, card-win% and FGei(e)] Whenever you win a card (or two, or three) from a FalseGod you can enter the number of cards won in this column. Recording this is not critical for any of the "hard" stats, so significant data for comparing decks will still be intact if you don't record your card-wins. It can be interesting to see how much electrum you actually made though, or how good a cardwin-rate certain FGs have ... Directly increase the number in the respective cell by clicking and typing the new number. |
| :underworld Background :underworld Here, you should enter your deck-name, your player-name and the version of Elements you have been using while taking your stats. These will show up on your forum-code-statsheet later. The Deck-code field is just for your convenience so you will always know which exact deck you played while taking the stats. In this version, an automated deck-posting is not included. The deck-code should be entered as follows: Right-click the cell -> paste contents (just below the regular "paste") -> unicode-text OR text The cell will then resize the code but it can be copied and pasted again by simply right-clicking on it. |
| deck | Shak'ar (juked) |
| players | Jangoo |
| version | 1.27 | win-rate | 32% | ||
| $ track ? | enabled | win-rate (n) | 33,56% | ||
| games | 150 | Score/h | 108 | ||
| win-loss-(EM) | 48-102-(0) | Score/h (n) | 148 | ||
| time (h:m:s) | 05:54:42 | FGei[c]* (http://elementsforum.co.cc/index.php/topic,14626.0.html) | 4386 | ||
| min/game | 02:22 | FGei[cn]* (http://elementsforum.co.cc/index.php/topic,14626.0.html) | 4548 |
| score/h | FGei(c) | Statmasta™realtec | wins | losses | skips | EM/Wins |
| 136 136 -268 -1346 439 549 -135 378 -527 146 405 -311 -519 -519 -1082 621 621 621 1023 124 821 139 -220 -80 406 319 -342 13 13 | 5331 3482 2531 -1346 5012 7859 4076 5144 1939 4326 7499 2018 2068 2526 -1082 6405 7844 6281 7254 3110 8252 4454 3168 3807 7124 4196 1504 2935 3402 | Akebono Chaos Lord Dark Matter Decay Destiny Divine Glory Dream Catcher Elidnis Eternal Phoenix Ferox Fire Queen Gemini Graviton Hecate Hermes Incarnate Jezebel Lionheart Miracle Morte Neptune Obliterator Octane Osiris Paradox Rainbow Scorpio Seism Serket | 2 2 1 2 3 1 2 1 1 2 1 1 1 3 3 3 3 1 3 1 1 1 2 2 1 2 2 | 4 4 4 4 2 2 3 3 7 2 3 5 6 6 6 2 2 2 1 2 2 2 4 3 3 3 5 5 5 | | |
link unavailable bruhShould work now ... somehow the forum didn't permit to upload it directly to server even though the file doesn't breach the 5MBs. I went with a hosting-site ... ???
Yeah. Blank images followed by "Waiting for abload.de"Hmmm ... that sucks, funny description though. ;D
I'll check back. Looking forward to it.
Edit: A Wild Image Appears! (just took a few minutes)
Edit: 10 minutes in... still downloading... still eager.
Edit: One hour in, still waiting for download to start. Starting to have fantasies about google docs.
Edit: Some hours later. Stopping the download and restarting it results in, "Download-Ticket abgelaufen." I can only imagine that is some kind of hex that is being hurled against me by a council of foreign witches. For now, they have won. I will steel my resolve and return to crush these heretics and receive my rightful reward. This excel file will be mine. Oh yes. It will be mine.
got it downloaded without problems (file upload).Thanks hrmmm ... that tool-thread of yours is pretty awesome.
and im pretty impressed ... awsome work!
+karma &
gonna link (http://elementscommunity.org/forum/index.php/topic,16745.0.html) this one ^^
(...)dont tell me ... this place is getting huge^^
Thanks hrmmm ... that tool-thread of yours is pretty awesome.
Funny how you end up completely missing certain things just because you never look
at certain sections. ;)
i tested your tool a bit... and im totally gonna use it.Ok will do when updating the Statmasta to 1.27.
only a little improvment i like to have:
a place where you can put in a deckcode.
(made me one below the decksize/version cell)
im used to place my deckcode in the sheet, to be sure to use the same deck again and for obvious practical reasons.
Can you also upload it on localhostr.com?May I ask why? Are the others not working or ... ?
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.
After searching for an hour for a nice excel spread sheet i finally found a good one (yours). So i hope you will update it soon ;)Will do soon.
Sorry to hear that.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
:( I'll just have to do it the old fashioned way...After searching for an hour for a nice excel spread sheet i finally found a good one (yours). So i hope you will update it soon ;)Will do soon.
I am a little confused as to what timeframe we can expect for any changes
concerning the new gods ... Are there any conclusive news about Jezebel
staying in the Pandemonium or being taken out yet?Sorry to hear that.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
I guess I could come up with a version that bypasses the macro sometime.
The thing is: It is needed to ensure proper data-input and even while I was
thinking "Aww hell, I made the darn table so I certainly won't screw up my
data-input" it actually happened all the time that I forgot to enter something.
Sorry for replying so late, my new provider considers weeks of waiting for a new:( I'll just have to do it the old fashioned way...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
GG said make it rain.Lol, I used to watch Inspector Gadget when I was a kid. When I recently came across
Go, go gadget rainmaker.
+Karma. Leik...srsly.
| deck | 1.27 CCYB - unupped |
| player | kirchj33 |
| version | 1.27 |
| games | 25 |
| win-loss-(EM) | 5-20-(4) |
| time (h:m:s) | 01:25:07 |
| min/game | 03:24 |
| win-rate | 020% |
| normalized | n.a. |
| FGei[c]* (http://elementscommunity.org/forum/index.php/topic,14626.0.html) | 1372 |
| FGei[cn]* (http://elementscommunity.org/forum/index.php/topic,14626.0.html) | n.a. |
| wins | losses | skips | EM/Wins | |
| Akebono Chaos Lord Dark Matter Decay Destiny Divine Glory Dream Catcher Elidnis Eternal Phoenix Ferox Fire Queen Gemini Graviton Hecate Hermes Incarnate Jezebel Lionheart Miracle Morte Neptune Obliterator Octane Osiris Paradox Rainbow Scorpio Seism Serket | 1 2 1 1 | 3 1 2 2 1 2 1 2 1 1 1 1 | 1 1 | 2 1 1 |
This thing is a breeze to use! +karma since I haven't done that yet.
Oh wow, as Kirch said, it's a breeze to use.Thanks guys ... glad you like it. :)
I love it.
A couple of thoughts...1. Damn, the "bug" is back. I thought I had dealt with this but apparently not.
1. The enter deck code cell on the first page seems to be protected? I couldn't enter mine (fairly unimportant)
2. (We've already discussed this) It would be great to get uber accurate win results for HP/dependant non-EM wins. Also an electrum tracker would be great!
To show the simplicity... this post took me less than 60 seconds to show great stats!
@kirch: What happened to the display of your win-rate?First, I have no idea why it posted that way... I just added the forum code and voila!
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.
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:
Yea but can't you make it so that everyone takes their own personal copy of it?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'd have to look it up, but right now I don't think you can.Yea but can't you make it so that everyone takes their own personal copy of it?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.
Also, from what I hear, google-docs does not support Macroes.Google Docs has Macros.
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?
I use it on open office, you only need to turn macros on and i think it's the same as on excel.Also, from what I hear, google-docs does not support Macroes.Google Docs has Macros.
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?
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.
Google Docs has Macros.Hmyeah, there have already been some complaints about not having Excel.
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 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
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
[Btw, I think the reputation is broken or delayed or is the message system isn'tRep should be working. I know this because I gave you rep because of this project yesterday. Just look in your profile and you'll see.
working or ... none of the Rep recently given to me has reached it's destination.]
P.s. You should change the title of this topic to match the current version of the tool.Huh? I changed the title of the OP already and my last reply (the one above yours) was titled "STATMASTA4000 ..." correctly.
Great, got your rep indeed. Guess the others didn't actually press the rep-button after posting "+Karma" then ...Yea, you probably changed the title before I commented on it. Yesterday I noticed the title was outdated, and I guess I didn't re-check it today before posting.P.s. You should change the title of this topic to match the current version of the tool.Huh? I changed the title of the OP already and my last reply (the one above yours) was titled "STATMASTA4000 ..." correctly.
Is your reply called "STATMASTA3000 ..." because you replied to an older post perhaps?
@SG (mostly)Not sure if this is what you are asking, but you can attach files by clicking the "Attachments and other options" under the text box.
In regards to the Open Office/Googledocs discussion. Is there a way these forum postings can have the excel sheet attached directly as opposed to using a file hosting site? Just curious because Jangoo and I are in the midst of organizing a full-blown study utilizing the STATMASTA and this seems like the most logical solution to merging data.
Ok, I tested and this file would be too big. I guess we're better off using a file hosting site then and providing links. Thanks.@SG (mostly)Not sure if this is what you are asking, but you can attach files by clicking the "Attachments and other options" under the text box.
In regards to the Open Office/Googledocs discussion. Is there a way these forum postings can have the excel sheet attached directly as opposed to using a file hosting site? Just curious because Jangoo and I are in the midst of organizing a full-blown study utilizing the STATMASTA and this seems like the most logical solution to merging data.
Ok, I tested and this file would be too big. I guess we're better off using a file hosting site then and providing links. Thanks.Hmyeah, thought so.
While I haven't actually looked at the spreadsheet due to not having excel at home, as far as I can tell from reading the documentation on v3000, your macros just count the number of items added together in the time cells (hence having people input them in =1+2+3+4 format rather than just a total) and compare that to the total win/loss and spit out an error if they aren't the same thing.Yes, that is what the Macro is doing in both the async-warning- as well as the $-tracking column.
If you wanted to make this completely compatible with everything via not using macros, you could just stick like 20 cells in for each FG in some aesthetically pleasing way and just use count to do the error checking. The only real drawback to this method (assuming I guessed right about your macro use) is that the main FG page would get a bit more cluttered.I mainly chose the input-in-a-single cell because it's so much easier and nicer to use and
I was actually coming to this thread to try to gauge how many people want to use this but don't have excel to figure out if I should work on putting together an equivalent project on oo.o or google docs, but it looks like you're already on top of it.Well, there have been some complaints about Excel + Windows in this thread.
Is there some freeware programm to open .xls files?Yes. It is called open office (to name just the most prominent freeware).
A 100% working OO-version of the STATMASTA is already in beta-testing and will soon hit this thread.Cool! ^-^
Cool! ^-^Indeed ;D
Confirmed, it works with all images, macros etc.Cool! ^-^Indeed ;D
The new STATMASTA™4000 for open-office is done and ready to go:
⇒ DOWNLOAD STATMASTA™4000 FOR OPEN OFFICE (http://www.file-upload.net/download-3499074/Statmasta4000_OO.ods.html) ⇐
Enjoy
Thanks! :3
Hey Wadjet.
Clearing the Input fields:
The dark-red framed cell-fields on sheet1 are your input-fields.
Just mark the input-fields via left-click and drag -> press "delete" (or: right-click -> "delete contents")
OO will ask you which parts you want to delete: Everything except the formatting.
All the other fields are calcing stats for you, are protected and thus read only.
Have fun :D
Just wanted to say thanks. Awesome work!Welcome ... thank you too for actually using the tool. ;)
Thanks! :3Yeah well ... I am guessing you marked ALL of the visible cells on sheet 1 at once?
EDIT: Instead of asking me what to delete, it simply says, "Protected cells cannot be modified".
I'll just manually delete them one at a time, won't take too long.
| FG | DarkWeaver | Merged studies | Sample size |
| Akebono Chaos Lord Dark Matter Decay Destiny Divine Glory Dream Catcher Elidnis Eternal Phoenix Ferox Fire Queen Gemini Graviton Hecate Hermes Incarnate Jezebel Lionheart Miracle Morte Neptune Obliterator Octane Osiris Paradox Rainbow Scorpio Seism Serket | 58,63% 38,68% 41,26% 61,41% 44,74% 68,00% 37,58% 37,33% 56,25% 44,43% 50,92% 49,76% 46,88% 54,71% 39,26% 48,34% 59,72% 47,36% 37,75% 37,84% 47,07% 48,15% 59,71% 57,22% 48,19% 36,10% 36,54% 41,99% 48,29% | 56,86% 40,71% 38,40% 59,74% 43,54% 80,80% 34,02% 35,07% 43,42% 50,28% 51,94% 44,39% 45,88% 56,29% 30,99% 45,51% 54,13% 39,29% 37,37% 34,45% 41,14% 44,83% 54,74% 54,75% 52,16% 31,78% 37,21% 41,46% 42,92% | 204 140 125 154 294 125 97 211 76 177 206 223 85 167 71 334 109 252 281 209 333 203 137 179 324 107 129 164 219 |
it's really sad to learn that MS-excel will not be supported... ::)+1
Not that I play elements anymore, but if i did i would still use the old stamasta (4000) because excel is :D and openoffice is -_-it's really sad to learn that MS-excel will not be supported... ::)+1
We want excel :P
Did you know Winston Churchill was born in a ladies' room during a dance.
Did you know A pregnant goldfish is called a twit.Random piece of spam?
I don't know if this is happening to anyone else but if I get any ems, and say so in realtec it decides that the tracking enabled should be changed to disabled. If I take out the em its goes back to enabled? am I missing something here or am I just entering something wrong??The EM-column is EMs out of wins, meaning if you win a game with an EM you should
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.
| 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. |
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?Read Below.
I have never used OO Calc before, so please assume I know nothing
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 think you mean that the sheet is already filled with my sample-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?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.
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.
Function SUMMANDS(cell As Range) As Integer
SUMMANDS = Len(cell.Formula) - Len(Replace(cell.Formula, "+", "")) + 1
End Function
I figured out what ANZAHLSUMMANDEN is. This is a user-defined function counting the number of summands in the argument cell. I don't know VBA well but I found that this works as a replacement:Code: [Select]Function SUMMANDS(cell As Range) As Integer
SUMMANDS = Len(cell.Formula) - Len(Replace(cell.Formula, "+", "")) + 1
End Function
=Len(F4)-Len(Substitute(F4,"+",""))+1Well,i want a stat masta that i can download. Can you upload stat masta to a site,so we can download it?
Well,i want a stat masta that i can download. Can you upload stat masta to a site,so we can download it?
Thank you soo much,and for info,i use it because you doWell,i want a stat masta that i can download. Can you upload stat masta to a site,so we can download it?
http://www.2shared.com/file/wwq9luCc/Statmasta_realtec_OO.html (http://Statmasta RealTec)
Sorry for this post but any one know the link to download STATMASTA?
i read all the topic and i trying to download from all this link's but nothing or error or blank sites.. any help??
thanx
p.s. sorry for my bad english
Sorry for this post but any one know the link to download STATMASTA?
i read all the topic and i trying to download from all this link's but nothing or error or blank sites.. any help??
thanx
p.s. sorry for my bad english
HERE (http://www.2shared.com/file/wwq9luCc/Statmasta_realtec_OO.html)
Read the OP. It says use "OpenOffice.Org"thanx !!
Hahaha hilarious ... "ages ago" ... so am I apparently.
Indeed, it's a few more now. They are all in there, no worries. ;D
why is this good app hidden from my knowledge till now? Good job!!!
So..... This ain't working anymore.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.)
I just did some longterm testing and the time was over 8 hours - now it is showing asynch errors everywhere.
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. :)