Jump to content
Truthiness

Regionals Data Project 2018-2019 Season

Recommended Posts

Not sure how easy it would be to do, but considering the overall event size is probably worth doing.

IE., it's a lot easier to get a list into the 'top 8' at a 12-person regional than it is a 32-person regional...

(Maybe instead of 'top 4' or 'top 8' groupings, have it at 'top 20%' or 'top 50%' or something like that?)

Edited by xanderf

Share this post


Link to post
Share on other sites

Also, squad points and commanders seem obvious. I'm personally curious about "less-loved" squadrons, like basic e-wings, Lancers, or Scurrgs for example.

Same with ships. How many people are still using AFs? Does anyone fly Vic's anymore? How much are I-1s used?

Share this post


Link to post
Share on other sites
6 minutes ago, geek19 said:

Also, squad points and commanders seem obvious. I'm personally curious about "less-loved" squadrons, like basic e-wings, Lancers, or Scurrgs for example.

Squad points and commanders both seem to be there, already.

I'd be keen on a breakdown of 'scatter aces' vs the rest, though.  Even the brace aces seem slightly undercosted for their return on investment (vs the corresponding generic), but 'scatter aces' are crazy cheap compared to what they should be (relative to their corresponding generic) - I bet we'd see that in the numbers if it was tracked.

Share this post


Link to post
Share on other sites
3 hours ago, xanderf said:

Not sure how easy it would be to do, but considering the overall event size is probably worth doing.

IE., it's a lot easier to get a list into the 'top 8' at a 12-person regional than it is a 32-person regional...

(Maybe instead of 'top 4' or 'top 8' groupings, have it at 'top 20%' or 'top 50%' or something like that?)

I might have an idea on how to do it.

Share this post


Link to post
Share on other sites

If you're putting lists together for science... I really should run something ridiculous so we can go back and say "See... 0.002% of players ran Ackbar Nebulons at Regionals - it's a real number!"

3 hours ago, GiledPallaeon said:

@Crabbok You are welcome to send Orlando’s lists back with me if you want. It’s no big deal to me.

 

Ummm, sure.  I wasn't actually planning on collecting anyone's lists in the first place.  Like, I may do some video of like "Hi, wow look at all those ISDs!" but I'm not actually running the regional or anything, I'm just there to play and geek out with fellow geeks!

Edited by Crabbok

Share this post


Link to post
Share on other sites
15 minutes ago, Truthiness said:

I might have an idea on how to do it.

Alright, I've got a solid concept, but it's going to involve some manual input. For my sanity, I'm also going to need it to be one of the earlier columns in the full lists tab. Also for my sanity that means I have to obliterate one of said early columns so that I don't have to re-do every single formula. Any objections to me replacing the MoV column? Tournament Points alone is probably more than enough for our curiosity.

Share this post


Link to post
Share on other sites
16 minutes ago, xanderf said:

Wait, Google sheets doesn't automatically adjust all formulas when you do a column insert?

REALLY?!

Excel has been able to do that since version...geez, I dunno, 97 or so....

One is free and web based. The other is microsoft. 

So on paper a fair competition but in reality not. 

Share this post


Link to post
Share on other sites
8 minutes ago, Ginkapo said:

One is free and web based. The other is microsoft. 

So on paper a fair competition but in reality not. 

Ooof, I'd try copy+paste out into Excel and then back again or something.  That fries my brain, I just can't even imagine trying to work with that limitation...

Share this post


Link to post
Share on other sites
2 hours ago, xanderf said:

Wait, Google sheets doesn't automatically adjust all formulas when you do a column insert?

REALLY?!

Excel has been able to do that since version...geez, I dunno, 97 or so....

The first page is pulling from a second sheet, which means you have to be very specific about what column you call from. Even Excel doesn't update when you do that. Sheets still updates formulas within the same sheet, just like Excel. The formulas I've created are labor intensive when I make them, but they run themselves as the season goes on. It's a massive improvement over the last incarnation of the data project.

Edited by Truthiness

Share this post


Link to post
Share on other sites
11 minutes ago, Truthiness said:

The first page is pulling from a second sheet, which means you have to be very specific about what column you call from. Even Excel doesn't update when you do that. Sheets still updates formulas within the same sheet, just like Excel. The formulas I've created are labor intensive when I make them, but they run themselves as the season goes on. It's a massive improvement over the last incarnation of the data project.

FWIW, Excel actually does still handle that cross-sheets.  Especially if the content in a sheet is defined as a "table", in which case the columns are identified by name rather than position anyway - and you can even move them across documents and it can keep the relationship.

Anyway, that's neither here nor there - this isn't Excel, and it just makes it all the impressive how much of a marvel of work you are doing for the community!  Thanks a million for this - the game unquestionably benefits from it!

(Uhhhmmm…any way to get a track line in for those scatter aces as a squadron type?  😉 )

Share this post


Link to post
Share on other sites
27 minutes ago, xanderf said:

(Uhhhmmm…any way to get a track line in for those scatter aces as a squadron type?  😉 )

Right now I have the ability to pick out the Scatter Aces. I could compare the percentage of lists that include X number of Scatter Aces, just like with ship sizes. If you're looking at normal vs. Scatter numbers, that might be a little harder, but possibly doable.

Edited by Truthiness

Share this post


Link to post
Share on other sites
1 minute ago, Truthiness said:

Right now I have the ability to pick out the Scatter Aces. I could compare the percentage of lists that include X number of Scatter Aces, just like with ship sizes. If you're looking at normal vs. Scatter numbers, that might be a little harder, but possibly doable.

Hmmm.  Yeah, wonder what the most conclusive analysis would be.

Certainly the overall impression is that scatter aces are worth more than their cost lets on, compared to their generic counterparts.  But would the best way to look at that in a tournament format be just overall comparisons?  IE., lists with with max squads and 50% scatter aces place so high, where max squads and 10% scatter aces do something else?

That is - the question is probably best phrased as percent of squads taken as scatter aces?  Or...actually...maybe even better...

Percent of squad limit (134 pts) that is scatter aces?  THAT might be illuminating...  (after all, someone could bring just two squads and both are scatter aces - if that list does well or poorly, does it really tell us much?  Or...maybe it does, actually...hrm…  No, wait, maybe it works this way, too.  Say 36 pts in scatter aces is 27% of max squads...comparing a list with the same cost in squads but no scatter aces at 0% then, if they trend in sharply different directions...)

Share this post


Link to post
Share on other sites
4 hours ago, xanderf said:

Hmmm.  Yeah, wonder what the most conclusive analysis would be.

Certainly the overall impression is that scatter aces are worth more than their cost lets on, compared to their generic counterparts.  But would the best way to look at that in a tournament format be just overall comparisons?  IE., lists with with max squads and 50% scatter aces place so high, where max squads and 10% scatter aces do something else?

That is - the question is probably best phrased as percent of squads taken as scatter aces?  Or...actually...maybe even better...

Percent of squad limit (134 pts) that is scatter aces?  THAT might be illuminating...  (after all, someone could bring just two squads and both are scatter aces - if that list does well or poorly, does it really tell us much?  Or...maybe it does, actually...hrm…  No, wait, maybe it works this way, too.  Say 36 pts in scatter aces is 27% of max squads...comparing a list with the same cost in squads but no scatter aces at 0% then, if they trend in sharply different directions...)

I assume this is primarily Imp focused? I can see Shara/Tycho, but that's a basic Rebel dump of squadrons that doesn't need much more support is all.

Share this post


Link to post
Share on other sites

How hard would it be to add in a thing for each ship? Not just X large or whatever, but how many CR90s, how many Assault Frigates, how many Nebulons Yavari? While knowing the number of ships is interesting and number of larges/mediums, i think you'll get more traction out of THIS data personally.

Share this post


Link to post
Share on other sites
19 minutes ago, geek19 said:

I assume this is primarily Imp focused? I can see Shara/Tycho, but that's a basic Rebel dump of squadrons that doesn't need much more support is all.

At the moment, yeah, obviously - although don't knock Blount.

Still, that 'don't need much support is all' speaks to the point of the issue.  I mean, as that example - does anyone seriously think the Shara + Tycho is worth only 3 standard A-Wings?  Good grief, they'll easily take double the number of attacks to kill as the entire other group - and that's just the defensive value of the tokens, nevermind the pilot's ability.

Certainly, the same is true (and worse) for the Imperials - you sneeze at a TIE Fighter and it explodes, while it takes 3 powerful attacks to take out Howl (enough that you get at least a couple accuracies in there).  Yet she's only double the cost, nevermind her pilot ability.

The issue is less pronounced with the brace aces, as they don't take an average of as many attacks to kill, but scatter aces are quite the durability value for their price.  At least, this certainly seems anecdotally true of games, and a casual review of historical games, but I think we could pretty easily put hard numbers to it to quantify more clearly.

Share this post


Link to post
Share on other sites
5 hours ago, geek19 said:

How hard would it be to add in a thing for each ship? Not just X large or whatever, but how many CR90s, how many Assault Frigates, how many Nebulons Yavari? While knowing the number of ships is interesting and number of larges/mediums, i think you'll get more traction out of THIS data personally.

It's easy to compare how many fleets included one or more of a ship. The formula for the ship sizes is done by checking against a list of ships, so making a formula that just counts one specific ship type is easy. How would this be compared? Are you looking for the raw number of each ship taken, or the percentage of fleets that take at least one of a ship type?

Edited by Truthiness

Share this post


Link to post
Share on other sites
10 hours ago, xanderf said:

Hmmm.  Yeah, wonder what the most conclusive analysis would be.

Certainly the overall impression is that scatter aces are worth more than their cost lets on, compared to their generic counterparts.  But would the best way to look at that in a tournament format be just overall comparisons?  IE., lists with with max squads and 50% scatter aces place so high, where max squads and 10% scatter aces do something else?

That is - the question is probably best phrased as percent of squads taken as scatter aces?  Or...actually...maybe even better...

Percent of squad limit (134 pts) that is scatter aces?  THAT might be illuminating...  (after all, someone could bring just two squads and both are scatter aces - if that list does well or poorly, does it really tell us much?  Or...maybe it does, actually...hrm…  No, wait, maybe it works this way, too.  Say 36 pts in scatter aces is 27% of max squads...comparing a list with the same cost in squads but no scatter aces at 0% then, if they trend in sharply different directions...)

Ooof. That might be possible, but I'm not sure I'm skilled enough to pull it off.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×