fixed

minor thing: added the ability to edit the tourney details (name, date, etc). I got tired of editing things on the back end for folks :-)

If the tourney is unlocked, a 'Edit tourney details' link shows up. Clicking the link gets you to:

Note I had to edit the countries.js, so you might need to dump your javascript cache (Control+Shift+R on chrome) or the country/state might not populate.

Excellent!

Other outstanding things:

• Can we add a "comment" field for each tournament? That could be useful.
• Can we also add a "links" field where people can add links to their related battle reports, photos, etc?
• Did we ever fix the problem with player names in quotes breaking the auto-upload?
• I need to look into getting an SQL plugin for MATLAB. OK, that one is on me.

There's an ODBC connector for Matlab which you could use to connect to MySQL.

Its like $100 bucks or something last I checked.

Yeah, the other option is if there is an open-source SQL database reader, and I learn some other scripting language. MATLAB is just convenient for me as I still have my student license version and use it liberally for other things, including MathWing.

Scilab or Octave? Not sure about database connectivity with those. Otherwise, if you're on Windows, I'd go with Visual Studio Express and C#, there are so many useful extensions available for it.

I can't believe I just wrote this, there were times when I was a .Net hater and worked exclusively with Linux...

besides matlab or mathematica, numpy/scipy/pandas is what all the quant nerds I hang with use for this sort of thing

I am noodling around ways of taking advantage of all the match-up results we have now, so I implemented a basic matchup summary as part of search, showing up as summary stats beneath the main search bar:

not sure where I'm going, but things that spring two mind are pre-canned matchup reports using the common archtypes; for example, how does 4 ship rebels do against brobots? or allowing the user to have a double search bar where they specify what two search results they want to match-up; ie, show me every result where a list containing a Han took on a list containing a Chiraneau.

continuing to muck around here, added some more summary stats, notably, how many points the list destroyed versus how much it lost. for example, in the above example:

Summary stats
Winning percentage: 45.24%
Wins: 19
Losses: 23
Draws: 0
Total: 42
Opponent's ship points destroyed: 2,465
Points destroyed efficiency: 58.69%
Ship points lost: 2,838
Points lost efficiency: 32.43%

The wedge + dtf lists destroyed 2,465 points (out of ~4,200, so 58.69% destruction efficiency) and lost 2,838 (out of ~4,200, or 1-(2,833/4,200) = 32.43% defensive efficiency).

Compare this to a two ship fatty list, search string "p=Soontir and p=Chiraneau":

Summary stats
Winning percentage: 59.31%
Wins: 274
Losses: 188
Draws: 0
Total: 462
Opponent's ship points destroyed: 29,938
Points destroyed efficiency: 64.80%
Ship points lost: 21,271
Points lost efficiency: 53.96%

20% for efficient defensively as you would expect.

Is this useful at all? What other ways could we use this match results?

So the points destroyed efficiency is the percentage of points faced that were destroyed, and points lost efficiency the percentage of points of the list remaining, right? With MoV being 100% correlated to these numbers? Very useful I would say.

amazing stuff, sozin. maybe a tiny fraction of it will make it to our rebel-leagues system one day, but we haven't tied squads to our game reports yet. not sure we want to dig that deep yet.

Toby, yes, that is right.

Mu0n, thanks :-) now I have to figure out how to make it look purty.

Juggler -- re, social features, I've sniffed around this and think there is a good way to do it (Flask, the web framework I'm using, has a social module that enables Facebook/google/twitter etc sign-on, and there are a few good javascript libraries out there that provide rich text editors that let you embedded pictures, hyperlinks, etc etc). It is a decent chunk of work to do. Right now I'm going to keep riffing on making use of the match results. I'm thinking some sort of list ranker that, for every unique list, gives you the stats I've been kicking out above, and has a link to show all of the associated match results. (Bonus feature: vlog upload so you can browse games that came via Vassal, maybe with some sort of Ladyluck integration.)

Squad ranking would be very nice to have. I would include the functionality to rank not only unique lists, but also archetypes. The latter is of course somewhat more complicated. You could start of by grouping together lists that use the same ships, regardless of pilots and upgrades.

Ok! Rolling out 0.1 of t he list ranker . Good to see the results reflect what I hoped :-) Netdeckers rejoice!

seeing some bugs in the efficiency scores, looking at now ...

sozin, bugs? unpossible

I represent that remark!

Searching seems to be a bit wonky too. I put in "soontir" and get a lot of Soontir lists... and some Rebel lists.

It would be nice to be able to limit to regionals, limit to more than N lists, search for all lists with a given ship type, etc.

Thanks for all the work!

yep, all on the todo list, ty. soontir bug is weird, will try to reproduce

re: efficiency score bugs, turns out there are some match results in standard 100 point dog fights where a player scored more than 100 points! (see for example Hoontir Lin's 176-24 victory over Steve Dodd in the top 4 of the ATF Regional

commence data cleaning and constraint setting.

some data cleaning and debugging later, things are mostly ok. non 100 point dogfight matches were throwing things off (now being filtered out), as well as match results versus lists where I only knew one of the list point totals (ie one list has been entered, and the other has not). if you sort by points survived efficiency, you'll see what I mean. so, some minor cleanup still left to do.

along the way I implemented a " show list results " feature where you can see all the results of particular list.

I also added some basic erg stuff like showing the number of points in a list.

here's an example of what appears to be the most efficient list being played right now:

Soontir Fel + Push the Limit + Royal Guard TIE + Stealth Device + Autothrusters
Rear Admiral Chiraneau + Veteran Instincts + Engine Upgrade + Ysanne Isard + Gunner + Rebel Captive
(98)

It has a record of 17-3, has taken out 74.18% of opponent points, and kept a whopping 81.48% of its points!

(I found it by sorting most efficient to least efficient, and then scanning down for the list with the most number of games.)

chasing down a double counting bug in the list win/lost/draw scoring.

fixed. also updated the tableau data set with most recent tournament results.

pilot skill 2 and 8 remain the top pilot skills:

the blue b-wing remains the most popular ship at 11%. YT-1300 and Decimator are right at #2 with ~8.5%. Chiraneau and Han are the second and most third popular ships, at 5.4% and 4.6% respectively.

It would be nice to be able to limit to regionals, limit to more than N lists, search for all lists with a given ship type, etc.

Quick question -- did you mean for search? "type=regional and ship=xwing" will get you every regional list flying an x-wing, for example.