It's that time of the year again folks! Today, I'm introducing our annual community effort to collect as many lists as possible from Prime (formerly Regional) Championships and give us a pulse on the larger health of Armada's meta. My apologies for not making this post before last week's first round of Primes, but I was holding out on today's stream to debut the sheet so i could avoid making changes during the season as much as possible.

I'm in the middle of an accelerated Grad school program this year, so I'm going to need a lot help doing data input. Luckily, I have @CyborgNinja @geek19 @Snipafist @shmitty @duck_bird @GiledPallaeon and @Jamienasmyth. Any and all additional help would be much appreciated. As usual, if you are able to get a hold of lists, feel free to send them via PM, email, or post them here. I've heard that FFG is asking lists to be sent in this year, so if you are unable to secure the original copies, please ask to take photos!

The data sheet can be found here: https://drive.google.com/open?id=1zLdqo9y47lqIKubfrEUKV8gX5t9Ee-XuemM4xbiB_8A

If you find errors, please don't assume someone else has already told me! Two errors made it through all of last season without me noticing! Post it here and I'll be sure to put them in.

For reference, the data for last year can be found here: https://drive.google.com/open?id=1Tn7Q68JzqhxAwjjMd7ObFxoCrd-uArWf7p7bMYiFRWw

Finally, below is the running list of Primes and their status:

Carrolton, GA- Done! Thanks @jamie nasmyth!

Spokane, WA- Done! Thanks @duck_bird!

Upland, CA- Top 3 only

Brea, CA- Done!

Barcelona, Spain- Done!

Berlin, Germany (unofficial)- Done!

Warsaw, Poland (Grand)- Done! Thanks @CyborgNinja!

Niles, IL- Done! Thanks @geek19!

Toronto, ON- Done! Thanks @jamie nasmyth!

St. Albert, AB- Done!

St. Petersburg, FL- Done!

Roseville, MN- Done! Thanks @jamie nasmyth!

Madrid, Spain- Done!

Danvers, MA- Done!

Ashburn, VA- Missing #9, #17, #20, #21, #24 and #26. Thanks @GiledPallaeon!

Mountain View, CA- No data

Raleigh, NC- Only Top 4 plus #7

London, UK- Spotty, but thanks for the efforts @Grumbleduke!

Stirling, UK- Done! Thanks @Akhrin!

Valencia, Spain- Done!

St-Romuald, QC- Done! Thanks @CptAwesomer!

Calgary, AB- Missing bottom 3. Thanks @jamie nasmyth!

Krakow, Poland- No data

Richmond, BC- Done!

Elizabethtown, KY- Done! Thanks @CyborgNinja!

Houston, TX- Done!

Denmark- Done!

Bremerton, WA- No Data

Midlothian, VA- Missing #14-15 and #25-27. Thanks @CyborgNinja!

Gautier, MS- No Data

Neumünster, Germany- Done!

Las Vegas, NV (Grand)- Sporadic data. Thanks @geek19!

Sevilla, Spain- No Data

Marietta, GA- Done! Thanks @jamie nasmyth

Clive, IA- Done!

Stockholm, Sweden- Done!

Winnipeg, MB- Done!

Broomfield, CO- No data

Portland, OR- Done!

Singapore, Singapore- No data

StockTon-on-Tees, UK- Done! Thanks @Akhrin!

Vienna, Austria- Done! Thanks @RapidReload!

Torre del Mar, Spain- No data

Frankfurt am Main, Germany- Done!

Warsaw, Poland- Done!

Grayslake, IL- Data in hand, awaiting input

Redmon, WA- Done! Thanks @Ardaedhel!

Limerick, Ireland- No data

Victoria, AUS- Done!

Siegen, Germany- Done!

Zaragoza, Spain- No data

Louisville, KY- Done! Thanks @CyborgNinja!

Salamanca, Spain- 15MAR20

*Last edit 24FEB20*

You and the other folks mentioned in your post are absolutely stellar for the Armada community. Thanks for all that y'all do!

Thanks for doing it again.

But i have a question about the calcualtion. For the first fleet i end at 389 points (instead of the 377 points). Did i made an error, or is there a problem in the data sheet?
250+23+4+3+5+7+7+5+6+4+2+8+10 + 23+2+2 + 23+1+4 = 389.

I've SEEN the Spokane lists, but I dont know placements. If anyone has those, can you let me or @shmitty know?

Just now, geek19 said:

I've SEEN the Spokane lists, but I dont know placements. If anyone has those, can you let me or @shmitty know?

I posted them in the same spot as the list

3 hours ago, Tokra said:

But i have a question about the calculation

The 3rd fleet is also off. And a couple of the others look suspicious based on the bids (although I haven't checked). The Ackbar corvettes list has a 56-point bid, which feels like it is missing a ship, but again, I haven't checked.

11/16/2019 - Gameology (Upland, CA)

I only remember top 3 for this one:

1. I believe @BrobaFett is the handle, he can dump his list

2. https://armada.ryankingston.com/fleet/68925/

3. https://armada.ryankingston.com/fleet/69686/

9 hours ago, Tokra said:

Thanks for doing it again.

But i have a question about the calcualtion. For the first fleet i end at 389 points (instead of the 377 points). Did i made an error, or is there a problem in the data sheet?
250+23+4+3+5+7+7+5+6+4+2+8+10 + 23+2+2 + 23+1+4 = 389.

I'll take a look

Found the problem. Because of how the points are added, each column has to be called out in the UNIQUE formula. When I add columns, it doesn't automatically update that specific formula. I added three columns to accommodate the SSD, but didn't update the formula. I'll get it fixed when I have a moment to sit down at a computer.

Fixed! I found a similar issue in the 15th and 16th squadron columns which I likewise fixed (one cheeky bastard brought max Z-95s last year, forcing me to change it for this year). Again, thank you all for finding and pointing out errors like that!

@jamie nasmyth is list #5 from Quest missing some squads?

@Truthiness list #5 is not missing squads just written confusingly. It’s the AF, 2 plain Jane TRC90s and then 2 more, one of those Jaina’s Light and one of those holding Hondo.

Sum total: 1 AF, 4x CR90s (2 with unique things), & 2 transports. And it makes one very dangerous Ackbar swirl of doom, from personal experience.

Is it really 344 points? Or are there things missing?

There is an error in the Carrollton data. According to the spreadsheet, there were no Demolishers but there were at least 2, one of which was in my fleet!

1 minute ago, stephen_harris70 said:

There is an error in the Carrollton data. According to the spreadsheet, there were no Demolishers but there were at least 2, one of which was in my fleet!

Which one? Would you mind posting the corrected version?

Under Imperial Upgrades, it list Demolishers at 0% but there were at least 2. I will contact Jamie.

Disregard. It's a formula error, not an input error. I'm seeing a lot of fishy things actually. Give me some time to dive into it.

ALL of the upgrade formulas are off by exactly one column. I guess an inserted column took strangely at some point. My apologies. If it's bold, I haven't had a chance to fix the issue yet.

Issues I DID have time to fix:

-Demolisher and Avenger formulas are now correct

-RHQ formula was not properly counting H9 Turbolaser. Apparently I accidentally added an extra parenthesis.

I will happily collect lists and report them as TO for the Massachusetts Prime in December.

All the upgrade formula errors have been fixed. Hopefully that ends our usual hickup period of my silly between seasons mistakes.

Duck got the Sponake data in!

thanks for your work!

On 11/20/2019 at 12:58 PM, GalacticFist said:

11/16/2019 - Gameology (Upland, CA)

I only remember top 3 for this one:

1. I believe @BrobaFett is the handle, he can dump his list

2. https://armada.ryankingston.com/fleet/68925/

3. https://armada.ryankingston.com/fleet/69686/

How many total players? Even without the lists, the total number is important for calculating percentiles.

Top 3 from Uplands are in. The only estimate I got for total attendance was "around 20, but an odd number because there was a bye." I'm gonna go with 19 total for the time being until someone can confirm otherwise.

Who's grabbing data this weekend?