EPT1v1 Stats Spreadsheet - Page 6
| Forum Index > SC2 General |
|
Dibond
United States19 Posts
| ||
|
marine63
43 Posts
Microsoft Excel 2010 Click the File tab, and then click Options. Click Advanced, and then click to clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box in the General area. Click OK. Microsoft Office Excel 2007 Click the Microsoft Office Button, and then click Excel Options. Click Advanced, and then click to clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box in the General area. Click OK. Microsoft Office Excel 2003 or earlier versions of Excel Click Options, on the Tools menu. Click the General tab. Click to clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box, and then click OK. source: http://support.microsoft.com/kb/211494 This also disables you from allowing you to open more than one Excel window. Tough choice. | ||
|
Alejandrisha
United States6565 Posts
| ||
|
ssregitoss
Turkey241 Posts
| ||
|
MingusDew
United States77 Posts
| ||
|
BioTech
Australia264 Posts
| ||
|
Ghost.573
United States126 Posts
edit: Figured that out, but is there any special place that I save it for it to update automatically? Or will I just need to update it manually each day? | ||
|
sansalvador
Austria308 Posts
 | ||
|
WarpMePlz
United Kingdom76 Posts
On February 15 2012 10:07 BioTech wrote: So I just open the XLS and it automatically pulls the info out of my locally stored replays?? How does this work? For those wondering, the spreadsheet doesn't grab data from your replays. You must enter them manually (after each game for example). I honestly don't know how to implement auto-updating stats, manually up-dating during que times takes no longer than 10-20 seconds. I guess that will have to do until someone who knows how to do this contacts me | ||
|
Bloodspray
United States4 Posts
| ||
|
KicKDoG
Sweden765 Posts
| ||
|
bondja
United States39 Posts
| ||
|
WarpMePlz
United Kingdom76 Posts
On February 18 2012 02:27 bondja wrote: Very great excel sheet that helps you track what maps you are bad at vs what race, and everything anyone could possibly want! I've shown this on my stream and have had the majority of my viewers go to this topic and download it. Keep up the good work! Thanks bro, means alot! I'm glad it is getting some good use :D | ||
|
bondja
United States39 Posts
| ||
|
WarpMePlz
United Kingdom76 Posts
On February 18 2012 06:00 bondja wrote: Actually, SgValor is a member of the Mizzou Gaming Team and their whole Starcraft II team is now using this spreadsheet! As well as all the members part of Sovereign Gaming. It's pretty epic! Hehe, amazing! ^.^ Good stuff! | ||
|
AdroiT
United States77 Posts
| ||
|
Cephiro
Finland1934 Posts
Good job on the sheet! Request: A column and some kind of statistics being shown for SQ-calculation? | ||
|
WarpMePlz
United Kingdom76 Posts
On February 18 2012 16:44 AdroiT wrote: I think you need to work with SC2Gears to get their numbers put into your spreadsheet =) People believe that SC2Gears can do this already which is quite sad really because to my best knowledge it can't. You wouldn't believe the number of SC2Gears eliteists out there who shoot down every stat sheet without even looking at it. For this reason I won't be approaching SC2Gears but I'd still happily work with them if they asked. They could integrate it and keep it updated and i'd definitely use it if I start playing again for HOTS. | ||
|
Macpo
453 Posts
| ||
|
WarpMePlz
United Kingdom76 Posts
On February 18 2012 21:43 Macpo wrote: hmm season 5 works for me, but not season 6, as excel won't open with it... any piece of advice? I saw that the format changed from XLSX to XLSM so maybe there is something with this, but I am lost... The difference is that season 6 uses macro's so need to be in a macro enabled spreadsheet, hence the XLSM. As to why it won't open for you idk, try looking through your options in excel to enable macros or google it or something | ||
| ||
