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

[Sevs]

Sorry for the necro as I know you dont really come on the forums anymore. but a great addition would be a check box(or just a box next to each god for an "x") for skips. So you could check this box to automatically change all games against that god counted as skips. So it would be easier or quicker to see which gods to skip to increase your FGei

[Luminous]

I searched up stat masta and looked it's thread. I want to download it,link openes the site but when i click on download button,it cant download.
So,i am not sure link is working. And i really want to have it so i am asking,
Can anybody upload statmasta anywhere else,or give me a useful link,please ?

[Jenkar]

Could anybody reupload this? Apparently link is broken.

[Dragoon]

https://docs.google.com/spreadsheet/ccc?key=0AvzXeWJKVKrsdGFRMklSczh1NVkzMnExTFl2RlZ0c2c

A few things.

1. This is StatMasta3000, not the newest version Jangoo made.

2. I must've downloaded the excel version and uploaded it to google docs just to see if it would work. At least one set of functions doesn't work— ANZAHLSUMMANDEN (it looks like some other language actually, German?). If we could figure out what this function was supposed to do, it is possible that we can get the spreadsheet functional.

3. It needs to be updated with new FGs.

[CuCN]

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

[Luminous]

Well,i want a stat masta that i can download. Can you upload stat masta to a site,so we can download it?

[Dragoon]

Edit:  <------ Posts: I'm leet.

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

Actually, I think the function we want is Substitute, not Replace. I get a wrong number of arguments error with the Replace function.

So this is what I have in the cell:

Code: [Select]

=Len(F4)-Len(Substitute(F4,"+",""))+1
However, both Len(F4) and Len(Substitute(F4,"+","")) are coming up with the same number which it shouldn't for the spreadsheet to work. Any suggestions?

Edit: I feel silly. Having looked at it more, I now see that the function isn't looking at the formula in the target cell; it's looking at the result. So the Len function is only telling us how many digits there are in the result . . . which is not what we need.

Well,i want a stat masta that i can download. Can you upload stat masta to a site,so we can download it?

You can download it right now from that link I gave in my earlier post (File > Download as > Microsoft Excel). But, 1) you'll need to paste over my formula changes with the original (just copy and paste from a cell that has the original formula in it [i.e. M9]) and 2) it still may not work depending on how much is lost in the conversion process from Google Docs to MS Excel.

[Sevs]

Well,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

[Luminous]

Well,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

Thank you soo much,and for info,i use it because you do

[Jesuperman]

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

[Sevs]

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

[Jesuperman]

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

i try also this link
but when i open it say that some parts is non readable ...


p.s i use microsoft excel starter
if the problem is the program can you indicate  an other , please?
thanx for the help!!!