The TMC Forum

Sonic Central => Competition Central => Topic started by: Auriman1 on October 22, 2008, 10:43:22 PM

Title: TSC Data Archiving Workbook
Post by: Auriman1 on October 22, 2008, 10:43:22 PM
The Sonic Center Stats Recording Archive
Last Updated: 1-6-2009

Compatible with: Excel 98-2003, OpenOffice, Excel 2007

Features:
-Comprehensive index
-Areas to record all stats carried by TSC
-Separate worksheets for every game
-Color-coded character divisions
-Self-updating totals for all statistics
-Uniform design layout for all games
-Automatically skips over unused cells (Excel only)

Snapshots:

(http://i142.photobucket.com/albums/r120/Auriman1/Miscellaneous/TSC_R_A_Snap1.jpg)

(http://i142.photobucket.com/albums/r120/Auriman1/Miscellaneous/TSC_R_A_Snap2.jpg)

As a side note, the .xls version loads much faster than the .xlsx in OpenOffice.
Title: Re: TSC Data Archiving Workbook
Post by: Luxray on October 23, 2008, 01:12:13 AM
Now that's pretty useful. Not that i'll need it ._.
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on October 24, 2008, 01:44:13 AM
Charts updated. I had screwed up a few things here and there before, but I guess that's what happens for rushing the job <_< Regardless, all should be well in these fresh charts.

If anyone who decides to use these finds anything wrong with them, let me know.
Title: Re: TSC Data Archiving Workbook
Post by: Jawzunx on October 24, 2008, 01:46:46 AM
Nice, but you still forgot about SA2B Bosses :/
And in SADX Red Mountain you put charts for Sonic, Tails, and Knuckles, when it should be Sonic - Knuckles - Gamma  :P
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on October 24, 2008, 02:04:42 AM
Good catch, Jawzun. Fixed.
Title: Re: TSC Data Archiving Workbook
Post by: SadisticMystic on October 24, 2008, 02:28:32 AM
Perhaps it would help to add totals, like (http://soniccenter.org/sm/files/times.ods) these (http://soniccenter.org/sm/files/times.xls)?

Also separate worksheets are pwn.
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on October 24, 2008, 02:49:45 AM
Perhaps it would help to add totals, like (http://soniccenter.org/sm/files/times.ods) these (http://soniccenter.org/sm/files/times.xls)?

Also separate worksheets are pwn.
I hadn't been sure how to handle times in Excel, so that had made totals a difficult concept at the time. Although I feel these charts are lacking without them, my main goal was to make an efficient, uniform archiving system for personal stats of all TSC games. I'll work on reformatting the time columns now that I know there's a method to do so, and will look into implementing totals again.

As for the multiple worksheets, I had considered it, but decided on an index in the end. If people are interested enough, I could make a version that uses multiple worksheets.
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on October 24, 2008, 01:48:20 PM
After a sleepless night's effort, this should be the final version. I gave the whole thing a major cosmetic overhaul, added some color coding to the divisions, gave every last game a totaling system, fixed a few minor errors I came across, and made it easier to navigate. I tried out putting things on separate worksheets, but couldn't decide on a good way to break them up. It would be easy enough to implement, though, if someone has a sorting system in mind.

As a side note, it appears the formulas I used for totaling aren't entirely compatible with older versions of Excel, though, along with a handful of conditions, so no compatibility version :/
Title: Re: TSC Data Archiving Workbook
Post by: EngiNerd on October 24, 2008, 04:55:27 PM
You ain't done yet.  You need a .xls file.
/me would be bricked, but some Linux users will agree
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on October 24, 2008, 05:40:25 PM
You ain't done yet.  You need a .xls file.
/me would be bricked, but some Linux users will agree
I would, but as stated above, there's quite a few compatibility problems in this latest version between the two formats; it breaks several formulas and almost all of the coloring when switching to .xls. That's kind of annoying, but there's not much I can do about it at this point, unfortunately :(
Title: Re: TSC Data Archiving Workbook
Post by: SadisticMystic on October 24, 2008, 05:44:44 PM
So use .ods! The Other ISO-Approved Standard(tm)!
Title: Re: TSC Data Archiving Workbook
Post by: EngiNerd on October 24, 2008, 05:53:49 PM
SM: That's why I was asking for .xls - so OpenOffice could use it.  But, IIRC, even Office 2007 can't open .ods yet, nor can it save them.
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on October 24, 2008, 06:58:46 PM
I just downloaded OpenOffice a few minutes ago to experiment, and it was able to open excel 2007 files (Maybe it was just added recently?). Anyway, it still fried most of the conditional colors, but the formulas seem to be working just fine.
Title: Re: TSC Data Archiving Workbook
Post by: EngiNerd on October 24, 2008, 07:13:27 PM
WHUT./me checks OpenOffice website
FINALLY.
Nice timing, Auriman.  According to the press release, OpenOffice supports MSOffice 2007 files as of ... last Monday.  No really, October 13th.  Nice find, I've been waiting for this ... well, since MSOffice 2007 came out.
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on October 27, 2008, 08:23:45 PM
Title: Re: TSC Data Archiving Workbook
Post by: EngiNerd on October 27, 2008, 08:47:53 PM
Title: Re: TSC Data Archiving Workbook
Post by: Shadow Jacky on October 27, 2008, 08:50:04 PM
ANTI!

I sent you a PM!
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on October 27, 2008, 08:54:38 PM
Title: Re: TSC Data Archiving Workbook
Post by: yse on October 28, 2008, 08:41:49 PM
Looks like my pen-and-paper method of recording stats off-site just became obsolete.

...

Awesome!

(If you remember my trusty notebook, good on you. If you don't remember or weren't around, play TSCA - there's a reference to it in there.)
Title: Re: TSC Data Archiving Workbook
Post by: Aitamen on October 28, 2008, 09:03:16 PM
yeah... I just scribbled in all the stats I've gotten since my unb&

totally beats the lots of pen-and-paper work I was doing...

very much kudos for all the time spent!
Title: Re: TSC Data Archiving Workbook
Post by: Selphos on October 28, 2008, 09:03:55 PM
mike TSCA no longer exists. The link to it on TSC is dead, remember?

And I don't believe RPG kept any copies of it anywhere >_>

But yeah I will be picking this up for the sake of convenience. Even though I'm mostly idle on TSC.
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on November 26, 2008, 07:41:27 PM
Charts Updated (http://www.soniccenter.org/forum/index.php?topic=3795.msg39807#msg39807)

11-26-2008 Changelog:

Workbook level change:
Seconds occasionally displayed incorrectly in time totals under certain conditions, which had to do with how hundredths/thousandths were carried over (ex: 82 instead of 22). Given it didn't affect the rest of the total (it still carried the minutes over from excess seconds properly), it was only a minor cosmetic issue that escaped my attention during the testing period. Fixed.

Worksheet level changes:
Advance2 - Added Boss divisions
Sonic06 - changed time slots and totals to manage thousandths
SSR - Skeleton Dome: Mission 4 score enabled
STT - Sunset Park 2 scores disabled
Sonic3D - Disabled hundredths in times division


For current users of the TSC DAW, here are some quick fix methods:

--To add the Advance2 Boss divisions, copy rows 80-128 from the new workbook, and insert them into the old one accordingly. Make sure the rows line up properly with the new version to ensure consistency with any future updates.

--To fix the seconds display error, substitute column K in every worksheet with the corresponding column K's in this new workbook. Timeframe: It should take less than 15 minutes from start to finish, if you're quick with the copy/paste work. I couldn't find a faster way than that, I apologize :[

--To change the totals for Sonic06 to handle thousandths properly, copy columns K through O from the new workbook to the previous version, then adjust the width of column F to provide space for three digits.

--To disable/enable cells, just re-format the individual cells accordingly; the totals will automatically adjust. For Excel users, remember to lock/unlock cells where appropriate.
Title: Re: TSC Data Archiving Workbook
Post by: KnucklesSonic8 on November 27, 2008, 02:07:33 PM
Thanks for the update, bud. Checking it out now. This means a lot.
Title: Re: TSC Data Archiving Workbook
Post by: Selphos on November 27, 2008, 03:49:06 PM
So far this is coming along great, but I have a request for you. Could you make a version of this for TUSC at some point?
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on November 27, 2008, 04:25:11 PM
So far this is coming along great, but I have a request for you. Could you make a version of this for TUSC at some point?
It'll probably take some time, but I'll look into it.
Title: Re: TSC Data Archiving Workbook
Post by: KnucklesSonic8 on November 27, 2008, 05:05:52 PM
I can't download the attachment. :(
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on December 02, 2008, 10:03:47 PM
The aforementioned TUSC Data Archiving Workbook is complete, and can be found here. (http://unofficial.soniccenter.org/forum/index.php?topic=3903.msg41161#new)
Title: Re: TSC Data Archiving Workbook
Post by: yse on January 06, 2009, 06:42:07 AM
I've finally got around to getting the latest version of this and have begun entering all the site records for the sake of archival. Since there's no site record total on-site (which I've said would be a good addition for years) this is an ideal place to calculate it. (I used to use SM's times.xls for this purpose.)

I've attached what I've done so far so that people can help me out if they feel like it. I've done up to SA2B so far, but I'm going to sleep and will work on it again tomorrow. You can also download it if you're curious on the totals of the games that've been done so far >_>
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on January 06, 2009, 01:24:39 PM
I suppose the least I can do is make a few much-needed updates.

1-6-2009 Changelog:

Added Unleashed charts for Wii/PS2 and 360
Heroes: Added Special divisions
SPA: Added Special divisions
Rush: Added Special divisions
SRA: Added Extra divisions
Minor edits in locking cells

Edit: Heroes scores removed


I've attached the yse's site records archive with these updates. I'll try to implement a master total calculator later, but I'm a little short on time right now.
Title: Re: TSC Data Archiving Workbook
Post by: FuzZerd on January 06, 2009, 06:42:07 PM
why are their three decimal places in su360?
Title: Re: TSC Data Archiving Workbook
Post by: Auriman1 on January 06, 2009, 07:05:07 PM
That's a very good question with a simple answer: I assumed both Unleashed versions would track time the same, and didn't double check. <_<

...Fixed
Title: Re: TSC Data Archiving Workbook
Post by: Selphos on January 06, 2009, 07:07:29 PM
Heroes scores were deleted, btw.
Title: Re: TSC Data Archiving Workbook
Post by: Chackoman15379 on August 29, 2013, 04:07:26 PM
Wheres SG
Title: Re: TSC Data Archiving Workbook
Post by: Groudon on August 29, 2013, 04:18:58 PM
Last Updated: 1-6-2009
Title: Re: TSC Data Archiving Workbook
Post by: Joeey on February 19, 2016, 11:44:20 AM
Well, guess I'm sinning, sorry :/

Wouldn't it be wise to make an update for this? New games have been released, and I wouldn't mind making an update if people would want one.