EPT1v1 Stats Spreadsheet - Page 3
| Forum Index > SC2 General |
|
Mastermind
Canada7096 Posts
| ||
|
WarpMePlz
United Kingdom76 Posts
| ||
|
Ksquared
United States1748 Posts
| ||
|
RaVi_932
Hong Kong14 Posts
| ||
|
coMbs
United States50 Posts
 | ||
|
WarpMePlz
United Kingdom76 Posts
On August 15 2011 14:49 coMbs wrote: Quite a bit of work going through my match history to fill this all out but well worth it. Thanks dude Heh, yeah i bet. It's much easier once you get used to filling it in after each game. very satisfying when you add a win | ||
|
Schoenhole
United States88 Posts
| ||
|
dejeseAI
Mexico32 Posts
| ||
|
Dagobert
Netherlands1858 Posts
| ||
|
acidbean
Germany287 Posts
| ||
|
OneofOne
United States18 Posts
![[image loading]](http://i.imgur.com/NK0AN.png) | ||
|
WarpMePlz
United Kingdom76 Posts
On August 23 2011 21:38 OneofOne wrote: one thing i would add is win % over a set number of games. i have made something like this, not as complex but the same none the less. the reason for the win % over a set number of games is because it is beleaved that promotions work off a moving average. the number of games is not specified so i did over 20 games and over 40 game. I have updated the spreadsheet just now, I believe that I've solved your problem by adding a section where you can vary the number of days to display stats for. Showing a graph to display the winrate change over a low number of days/games wouldn't show anything noteworthy | ||
|
teide
Spain178 Posts
| ||
|
Paralytic
United States4 Posts
I've been using this since late July and although I've run into a few problems with it, I've never hit a road block until now. I have no experience other then this in using a spreadsheet program. I've got this all set up in Libre office Calc and it works great, to one exception. I cant figure out for the life of me how to add more rows to the spreadsheet and actually have them calculate. I managed to play over 1,000 games during season 3 and have been struggling for the last few hours to get my latest games to calculate. I know not everyone uses Libre Office, But I'm sure that anyone in my position would run into this problem regardless of the Calc Program. All I want to do is add more rows, and extend the background area past 1,000.... Any Ideas of what I should be doing, or at least looking for? Thanks again. | ||
|
Hashmeister
Germany238 Posts
 But thanks for this anyway | ||
|
Acurus
Norway32 Posts
http://www.teamliquid.net/forum/viewmessage.php?topic_id=266019 | ||
|
ElBlanco
Australia140 Posts
It's so disappointing that we have to do this rather than it being an in game feature. I love stats and it would be fantastic if blizzard would incorporate some more into the game. | ||
|
WarpMePlz
United Kingdom76 Posts
On October 11 2011 16:59 Paralytic wrote: Hey I just wanted to say thanks for making this. It has helped me greatly. I've been using this since late July and although I've run into a few problems with it, I've never hit a road block until now. I have no experience other then this in using a spreadsheet program. I've got this all set up in Libre office Calc and it works great, to one exception. I cant figure out for the life of me how to add more rows to the spreadsheet and actually have them calculate. I managed to play over 1,000 games during season 3 and have been struggling for the last few hours to get my latest games to calculate. I know not everyone uses Libre Office, But I'm sure that anyone in my position would run into this problem regardless of the Calc Program. All I want to do is add more rows, and extend the background area past 1,000.... Any Ideas of what I should be doing, or at least looking for? Thanks again. Wow! 1000 games, congrats! To add more rows I would suggest adding rows before the 1000th row, this should extend the calculation region further. So for example, add 10 rows on the 9000th row, copy these 10 rows and paste insert them. Copy the 20 rows, insert, copy the 40 rows etc. l don't really have time to add the rows myself since im struggling to find time to do anything lol. I plan to keep uploading new spreadsheet with the new map pools though, maybe I will add more rows then. Thanks for your great feedback and i'm glad this was so useful to you | ||
|
Paralytic
United States4 Posts
On October 19 2011 05:34 WarpMePlz wrote: Wow! 1000 games, congrats! To add more rows I would suggest adding rows before the 1000th row, this should extend the calculation region further. So for example, add 10 rows on the 9000th row, copy these 10 rows and paste insert them. Copy the 20 rows, insert, copy the 40 rows etc. l don't really have time to add the rows myself since im struggling to find time to do anything lol. I plan to keep uploading new spreadsheet with the new map pools though, maybe I will add more rows then. Thanks for your great feedback and i'm glad this was so useful to you Thanks for the help, For some reason it just didn't want to add past 1,000 games. I did as you said and it still wouldn't add any wins/losses past 1,000. I ended up just started a new document for my most recent games. But thanks for the response, I'm still using it. I look forward to the update for season 4 as the map pool has changed once again. I'll keep checking back! Thanks again! | ||
|
NeutraLiTe
United States49 Posts
| ||
| ||
