1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Welcome to Smashboards, the world's largest Super Smash Brothers community! Over 225,000 Smash Bros. fans from around the world have come to discuss these great games in over 19 million posts!

    You are currently viewing our boards as a visitor. Click here to sign up right now and start on your path in the Smash community!

  3. Use the Smashboards Store to get awesome Smash stuff and support the site, like a Nintendo Controller or the Wii U - Gamecube adaptor ! Check out the inventory in our store and support Smashboards with your purchase today!

SkillKeeper - TrueSkill™ Rankings Bookkeeper

Discussion in 'Tournament Discussion' started by Zankoku, Nov 5, 2014.

  1. Zankoku

    Zankoku
    Expand Collapse
    Never Knows Best

    • Administrator
    • Premium
    • Back Roomer
    Joined:
    Nov 8, 2006
    Messages:
    22,987
    Location:
    Las Vegas, NV
    NNID:
    SSBM_PLAYER

    [​IMG]
    v1.1.0.2 (03/28/2017)

    Download: http://www.mediafire.com/file/nucj90fqliymfaz/SkillKeeper.zip
    Source: https://github.com/SugoiFactory/SkillKeeper

    SkillKeeper is pretty much the successor to my older rankings program, GlickoMan, now using Microsoft TrueSkill.

    I'll say more when I feel like it, but for now you can download and enjoy!

    Changelog:
    v1.1.0.2 (03/28/2017)
    - Fixed various importing and saving bus. (_ThreeFold)
    - Adjusted compatibility issues of saved files with older versions of SkillKeeper.

    v1.1.0.1 (03/13/2017)
    - Various interface fixes (_ThreeFold)

    v1.1.0.0 (03/03/2017)
    - Implemented support for importing Smash.GG events. (_ThreeFold)

    v1.0.2.1 (03/01/2017)
    - Fixed various issues introduced with Poyo-SSB's modification of form layouts.

    v1.0.2.0 (02/09/2017)
    - Correction of decay calculation to account for discrepancies in behaviors for same time intervals such as one week compared to 7 days. (PGLF-EAP)
    - Added support for window resizing, maximizing, amd minimizing. (Poyo-SSB)

    v1.0.1.6 (11/20/2015)
    - Created check for existing player name when attempting to rename a player in the Modify Player tab.
    - Alterations in the history tab are now quicker - scores are not recalculated until the user switches to a new tab.

    v1.0.1.5 (11/4/2015) (emb)
    - Added Challonge import without subdomain or owner's api key. v1.0.1.4 (2/11/2015)
    - Fixed issue with unfinished tournament import in Challonge (now uses create date if completion date does not exist).
    - Adjusted player import selection detection.

    v1.0.1.4 (2/11/2015)
    - Fixed issue with unfinished tournament import in Challonge (now uses create date if completion date does not exist).
    - Adjusted player import selection detection.

    v1.0.1.3 (2/3/2015)
    - Added draw detection capability to account for Challonge imports.
    - Added ability to import unfinished tournaments from Challonge (experimental).

    v1.0.1.2 (1/9/2015)
    - Fixed issue where recent matches wouldn't be counted if they had a timestamp of later than midnight on the current date.
    - Added further interval customization to score decay setting.

    v1.0.1.1 (1/8/2015)
    - Fixed issue where program would prompt to save even if no changes were made.
    - Fixed bug that caused player merge to crash under certain conditions.
    - Fixed issue where tournaments with the same name could not properly be accessed individually. (Fizzi)
    - Added improved error message when attempting to load Challonge tournaments. (Fizzi)

    v1.0.1.0 (1/5/2015)
    - Challonge import tool now stores most recent API Key and Subdomain for the next time the form is opened. (Fizzi)
    - Fixed a few scenarios where the tool would crash. (Fizzi)
    - Improved network efficiency of the tool. (Fizzi)
    - Added Save/Save As functionality.
    - Now prompts to save changes before new/load/close, if changes have not yet been saved.
    - Added minimum matches to rank in settings tab.

    v1.0.0.2 (11/11/2014)
    - Fixed an issue where having a different default date format set natively would interfere with date parsing.

    v1.0.0.1 (11/10/2014)
    - Player dropdown list for import dialogs is now sorted alphabetically.
    - Added progress bar for loading world files.
    - Made optimizations to load function.
    - Prevented crashing on TIO file import if the event date is an invalid value.

    v1.0.0 RC1 (11/5/2014)
    - First general public release!
    - Added leaderboard time setting.
    - Fixed issue where importing matches from a GLK file without a description would make it impossible to save.
    - Made application icon a cute bird.
    - Now defaults to BCN format files.

    v0.0.4.1 (11/4/2014)
    - Fixed an issue with TioPro files having erroneous pools match results.
    - Fixed window title name.
    - Implemented Delete Match and Delete Tournament buttons in history tab.
    - Implemented score decay.
    - Now deletes the old player after combining into a newer one.
    - Fixed match order numbers for GlickoMan import.

    v0.0.4 (11/3/2014)
    - Implemented Challonge importing.
    - Implemented GlickoMan importing.
    - Linking an imported player to an existing one now adds that name to the existing player's list of alt names.
    - Added ability to set players visible or hidden from leaderboard in the Modify tab.
    - Added settings tab.
    - Implemented last match date for player leaderboard.

    v0.0.3 (10/30/2014)
    - Implemented history view editing.
    - Implemented player combine function (found in Modify Player tab).
    - Added match description to file save values.
    - Fixed a strange bug in the TIO importer.
    - Made window bigger.

    v0.0.2 (10/29/2014)
    - Implemented tio file importing.
    - Allowed for full history view.
    - Implemented exporting leaderboard to CSV.

    v0.0.1 (10/28/2014)
    - First public release!

    Screenshots:
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
    [​IMG]
     
    #1 Zankoku, Nov 5, 2014
    Last edited: Mar 28, 2017
  2. Raziek

    Raziek
    Expand Collapse
    Charging Limit All Day

    • Moderator
    • Premium
    • Wii U Backroomer
    Joined:
    Oct 14, 2008
    Messages:
    9,645
    Location:
    Halifax, Nova Scotia
    3DS FC:
    3866-8131-5247
    NNID:
    Raziek

    Proud Beta Tester co-signing this program.

    I got to break it quite a few times. :3c
     
    BearUNLV likes this.
  3. Dspyder08

    Dspyder08
    Expand Collapse
    Smash Rookie

    Joined:
    Oct 24, 2014
    Messages:
    8
    Could it be possible to make this an app?
     
  4. Zankoku

    Zankoku
    Expand Collapse
    Never Knows Best

    • Administrator
    • Premium
    • Back Roomer
    Joined:
    Nov 8, 2006
    Messages:
    22,987
    Location:
    Las Vegas, NV
    NNID:
    SSBM_PLAYER

    I have absolutely no prior experience in coding for smartphones.
     
  5. Russ The Love Muss

    Russ The Love Muss
    Expand Collapse
    I just want to love you

    Joined:
    Jun 17, 2014
    Messages:
    249
    Location:
    Brisbane
    NNID:
    RussellTLM
    What differences are there between this and Glicko? (In terms of score calculations)

    I've also found a bug when importing Tio Files. Since it's reading in dates as MM/DD/YY it's not able to parse the files when it's actually DD/MM/YY in Tio and the day is greater than 12

    It would be nice if the players were sorted alphabetically as well when selecting a player when importing the Tio file as well
     
    #5 Russ The Love Muss, Nov 8, 2014
    Last edited: Nov 8, 2014
  6. Zankoku

    Zankoku
    Expand Collapse
    Never Knows Best

    • Administrator
    • Premium
    • Back Roomer
    Joined:
    Nov 8, 2006
    Messages:
    22,987
    Location:
    Las Vegas, NV
    NNID:
    SSBM_PLAYER

    Wait, it actually does dates in DD/MM/YY? >_> Is this Tio or TioPro?
    I'll look into alphabetical sort, should be an easy fix.


    Glicko and TrueSkill are subtly different, but I can't tell you exactly what difference that is, since I'm not that high-level in statistical mathematics. Sorry. I think both systems are fairly well documented on the Internet if you just Google for them, though.
     
    #6 Zankoku, Nov 8, 2014
    Last edited: Nov 8, 2014
  7. Russ The Love Muss

    Russ The Love Muss
    Expand Collapse
    I just want to love you

    Joined:
    Jun 17, 2014
    Messages:
    249
    Location:
    Brisbane
    NNID:
    RussellTLM
    I'm using TioPro files so that may be why, but it's definitely got to do with the dates as I just changed the dates in TioPro and it worked.

    Also yea, I got it the wrong way around >_<
     
    #7 Russ The Love Muss, Nov 8, 2014
    Last edited: Nov 8, 2014
  8. FGCU Viper

    FGCU Viper
    Expand Collapse
    Smash Lord

    Joined:
    Mar 31, 2010
    Messages:
    1,739
    Location:
    FGCU, Florida
    This looks good. i will be taking advantage of this. Thanks for your contribution.
     
  9. Zankoku

    Zankoku
    Expand Collapse
    Never Knows Best

    • Administrator
    • Premium
    • Back Roomer
    Joined:
    Nov 8, 2006
    Messages:
    22,987
    Location:
    Las Vegas, NV
    NNID:
    SSBM_PLAYER

    I'm unable to reproduce this bug in either tio OR TioPro. : \
    If there's nothing else, I'll release a quick version end of today for alphabetical sort.
     
    #9 Zankoku, Nov 10, 2014
    Last edited: Nov 10, 2014
  10. Russ The Love Muss

    Russ The Love Muss
    Expand Collapse
    I just want to love you

    Joined:
    Jun 17, 2014
    Messages:
    249
    Location:
    Brisbane
    NNID:
    RussellTLM
    Could it have anything to do with my computer locale? I have no idea if that has any effect on Tio or SkillKeeper. I'm in Australia. Also here is the error:
    Code:
    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.
    
    ************** Exception Text **************
    System.FormatException: String was not recognized as a valid DateTime.
       at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
       at System.DateTime.Parse(String s)
       at SkillKeeper.SKTioImporter.importFile(String fileName, List`1 playerList)
       at SkillKeeper.SkillKeeper.fileImportTioButton_Click(Object sender, EventArgs e)
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    
    
    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34014 built by: FX45W81RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
    ----------------------------------------
    SkillKeeper
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.0.0
        CodeBase: file:///H:/SkillKeeper/SkillKeeper.exe
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    System
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34239 built by: FX452RTMGDR
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Core
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
    ----------------------------------------
    Moserware.Skills
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.0.0
        CodeBase: file:///H:/SkillKeeper/Moserware.Skills.DLL
    ----------------------------------------
    System.Xml.Linq
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34230 built by: FX452RTMGDR
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Configuration
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.33440 built by: FX45W81RTMREL
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    
    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.
    
    For example:
    
    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>
    
    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.
    
     
  11. Zankoku

    Zankoku
    Expand Collapse
    Never Knows Best

    • Administrator
    • Premium
    • Back Roomer
    Joined:
    Nov 8, 2006
    Messages:
    22,987
    Location:
    Las Vegas, NV
    NNID:
    SSBM_PLAYER

    It might be locale. All my tio files have stuff like this:
    <StartDate>02/16/2014 00:00:00</StartDate>
    and I'm simply running a Parse on the value there, rather than manually going through logic to get the date. So it's a little weird that some files would not be following the format.

    In the meantime, if you could send me the tio files in question, I can write in an extra check to make an exception for that date format, haha.
     
    #11 Zankoku, Nov 10, 2014
    Last edited: Nov 10, 2014
    BearUNLV likes this.
  12. Russ The Love Muss

    Russ The Love Muss
    Expand Collapse
    I just want to love you

    Joined:
    Jun 17, 2014
    Messages:
    249
    Location:
    Brisbane
    NNID:
    RussellTLM
    That contains one of the TioPro files that produced that error
     

    Attached Files:

  13. Zankoku

    Zankoku
    Expand Collapse
    Never Knows Best

    • Administrator
    • Premium
    • Back Roomer
    Joined:
    Nov 8, 2006
    Messages:
    22,987
    Location:
    Las Vegas, NV
    NNID:
    SSBM_PLAYER

    Apparently the issue is that it attempts to use your Short Date format (set in Region/Language control panel) to determine what format to parse in. I imported the tio file just fine, then tried setting Short Date to dd-MMM-yy format and ran into the issue. Gonna have to look into how to force to parse on a specific format...
     
    Russ The Love Muss likes this.
  14. Cuban Legend

    Cuban Legend
    Expand Collapse
    Smash Apprentice

    Joined:
    Jan 31, 2013
    Messages:
    174
    Location:
    West Palm Beach, Florida
    Love this tool! was able to make a nice leader-board from a dozen tourneys from a few months back to determine more accurate seeding for the next tourney!

    One issue I did have was with importing TioPro files with the "day" of the month being above 12, and i also couldn't figure out which format to type in the subdomains for importing Challonge brackets, if you could help me with that then I'd be Golden!

    Any suggested decay length for my local circuit that consists of quarterly and bi-annual tourneys?
     
    #14 Cuban Legend, Nov 26, 2014
    Last edited: Nov 27, 2014
  15. Zankoku

    Zankoku
    Expand Collapse
    Never Knows Best

    • Administrator
    • Premium
    • Back Roomer
    Joined:
    Nov 8, 2006
    Messages:
    22,987
    Location:
    Las Vegas, NV
    NNID:
    SSBM_PLAYER

    If it's as uncommon as quarterly/bi-annual, I would recommend a yearly or no decay.
    I *thought* I fixed the date issue, so I'll have to take another look.
    Subdomain is just the name of your subdomain, so for example if I run a bunch of tournaments on http://sugoifactory.challonge.com/ then my subdomain is sugoifactory. If I don't use subdomains then I leave the field blank.
     
  16. Cuban Legend

    Cuban Legend
    Expand Collapse
    Smash Apprentice

    Joined:
    Jan 31, 2013
    Messages:
    174
    Location:
    West Palm Beach, Florida
    Thanks for the reply much appreciated.
     
  17. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    I got an error trying to inport my challonge informatioin

     
  18. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    Please help
     
  19. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    using a score multiplier with a decimal will crash skillkeeper
     
  20. Fizzi

    Fizzi
    Expand Collapse
    Smash Ace

    Joined:
    Feb 14, 2008
    Messages:
    791
    Location:
    Montreal, QC/Jacksonville, FL
    RedEyesWhiteSwaggin likes this.
  21. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    I'm getting the same error message. I'm using windows 8.1 and it comes with .NET Framework 4.5 bundled... I even tried putting compatibility mode to windows 7 but no bueno
     
    #21 Citricide, Jan 2, 2015
    Last edited: Jan 2, 2015
  22. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    errr apparently if I leave subdomain blank it works
     
    RedEyesWhiteSwaggin likes this.
  23. RedEyesWhiteSwaggin

    RedEyesWhiteSwaggin
    Expand Collapse
    Smash Apprentice

    Joined:
    Jan 19, 2014
    Messages:
    94
    This has made it possible for me to import challonge brackets but it doesn't seem to list all of the tournaments on my account. I double checked that the tournaments were complete. A few of the brackets are named the same thing even though they are different urls and dates if that has any affect on it.

    EDIT: I am almost positive that is the problem. All the tournaments named "PM" are coming up with the same results/date. Is there a way to change the name of the tournament on challonge?
     
    #23 RedEyesWhiteSwaggin, Jan 2, 2015
    Last edited: Jan 2, 2015
    Citricide likes this.
  24. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    Could you make it so we can omit certain columns like team before we export to CSV? Could you add in a feature to export leaderboard into HTML?
     
  25. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    Could you add in a feature to pop up a dialog window asking to save before closing?
     
  26. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    • Warning Received
    Is there anyway I can take player information and put it on a website? I want to display individual players and their match history, tally, alts, characters and all that other information on my website.

    Right now I have the leaderboard exported as CSV into a table on my website. I want to be able to click player names and have it show their MU, Sigma, Score, WL ratio, Individual Match Tally, Match History, character names and other names as well. Is there any way you guys could import a way to do this?

    I was looking into the Bacon File and it seems to be a simple XML file that I could parse but it doesn't contain any information like score, MU, talley and such. Is there anyway you can include information on the file so we can parse it?
     
    #26 Citricide, Jan 2, 2015
    Last edited: Jan 2, 2015
  27. Fizzi

    Fizzi
    Expand Collapse
    Smash Ace

    Joined:
    Feb 14, 2008
    Messages:
    791
    Location:
    Montreal, QC/Jacksonville, FL
    I can try to reproduce the error on my end if you give me your subdomain name. You might need to add me as an admin to the subbomain too I'm not sure (My challonge username is Fizzi). If I can't reproduce it we'll have to try something different.

    Yeah certainly if the tournament isn't complete it won't show up. I can see what I can do about adding support for same-name tournaments. Perhaps I'll put a date in parentheses or something.
     
    #27 Fizzi, Jan 2, 2015
    Last edited: Jan 2, 2015
  28. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    Subdomain is Lemonlust
     
  29. Fizzi

    Fizzi
    Expand Collapse
    Smash Ace

    Joined:
    Feb 14, 2008
    Messages:
    791
    Location:
    Montreal, QC/Jacksonville, FL
    As far as the other features requested, this isn't my application so I'll let Tony answer :p.
     
  30. Fizzi

    Fizzi
    Expand Collapse
    Smash Ace

    Joined:
    Feb 14, 2008
    Messages:
    791
    Location:
    Montreal, QC/Jacksonville, FL
    http://lemonlust.challonge.com/ does not exist... are you sure that's the correct subdomain name?

    I did change it so that it gives you a better error message if you input an organization that doesn't exist.
     
    #30 Fizzi, Jan 2, 2015
    Last edited: Jan 2, 2015
  31. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    Nevermind I figured out what was going on. I was using my own user name instead of my organization url
     
  32. lazymp

    lazymp
    Expand Collapse
    Smash Apprentice

    Joined:
    Apr 14, 2013
    Messages:
    114
    Location:
    Raleigh, NC
    NNID:
    mpittman17
    Really like the tool, thanks for making it. I'm using the csv export & a jQuery plugin to generate the NC Wii U Leaderboard.

    A feature that would be awesome would be a checkbox column to the far left on the Leaderboard tab so that certain players can be excluded from the export. Sometimes I don't want players that haven't attended enough events to show up on the leaderboard, so I want to exclude them from the csv export.
     
    Citricide likes this.
  33. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    this would be a nice addition. Are you willing to share said jQuery plugin
     
  34. lazymp

    lazymp
    Expand Collapse
    Smash Apprentice

    Joined:
    Apr 14, 2013
    Messages:
    114
    Location:
    Raleigh, NC
    NNID:
    mpittman17
    Definitely, I Googled "csv to html table javascript" to find this: https://code.google.com/p/jquerycsvtotable/.
    Very easy to use, once I had the csv file I was easily able to get it formatted nice on the webpage within ~30 mins.

    Next I'm going to attempt to modify the JS/CSS so that it will display characters used, custom-colored rows/sections based on score ranges, and up/down arrows to show how players are trending.
     
  35. Fizzi

    Fizzi
    Expand Collapse
    Smash Ace

    Joined:
    Feb 14, 2008
    Messages:
    791
    Location:
    Montreal, QC/Jacksonville, FL
    Temporarily it should be rather easy to open your csv in excel and delete the rows you don't want before importing.
     
  36. lazymp

    lazymp
    Expand Collapse
    Smash Apprentice

    Joined:
    Apr 14, 2013
    Messages:
    114
    Location:
    Raleigh, NC
    NNID:
    mpittman17
    That's actually exactly what I did ;), it would just be cool to have that feature in the program to make things faster/easier
     
  37. Zankoku

    Zankoku
    Expand Collapse
    Never Knows Best

    • Administrator
    • Premium
    • Back Roomer
    Joined:
    Nov 8, 2006
    Messages:
    22,987
    Location:
    Las Vegas, NV
    NNID:
    SSBM_PLAYER

    Technically, you can already hide players from the leaderboard in the View/Modify Player tab, though I implemented that mainly to allow one to exclude out-of-state players and such. I'm not sure if there's much time savings to always uncheck boxes compared to just deleting rows. Are you excluding people who haven't played enough matches? If that's the case, I can include a universal "minimum matches played to be ranked" criterion in the Settings tab.
     
  38. Sharkz

    Sharkz
    Expand Collapse
    Smash Ace

    Joined:
    Nov 11, 2007
    Messages:
    517
    Location:
    NC State, NC
    NNID:
    Sharkz1
    I've been using Glickoman for PM PR's that I help with. I like a few things about SkillKeeper a little more so I wanted to switch over. I just have two problems. One is that when PM 3.5 hit we wanted to start with a fresh slate. But we wanted to raise the player skill level in Glickoman for the players that were already PR'd, so an upset in the early season would give the points deserved. Transferring from Glicko to SkillKeeper does not keep the changed player skills that were put in Glicko. I'm not sure why that is and I'm not sure if there's a way to change that. So let me ask this. In SkillKeeper, for players that are already known to be top-10 worthy, should their Sigma, MU, or score be changed? Which one and how much?

    Also, when transferring from Glicko to SkillKeeper, it treats it as one big tournament. I can't figure out a way to change specific match dates meaning monthly decay doesn't work unless I manually enter in every match again like I've done with Glicko (which I'll probably end up doing). Is there any way that can be changed?
     
  39. lazymp

    lazymp
    Expand Collapse
    Smash Apprentice

    Joined:
    Apr 14, 2013
    Messages:
    114
    Location:
    Raleigh, NC
    NNID:
    mpittman17
    Ahhh I originally missed that checkbox over on that tab completely :p

    But also that minimum number of matches required would be a great setting to have.
     
  40. Citricide

    Citricide
    Expand Collapse
    JuneauSmashBros Tournament Organizer

    Joined:
    Jan 11, 2014
    Messages:
    176
    Location:
    Juneau, Alaska
    Can we get an option to omit certain columns from the CSV
     
    lazymp likes this.

Share This Page

Users Viewing Thread (Users: 0, Guests: 1)

We know you don't like ads
Why not buy Premium?