Jump to content
Sign in to follow this  
You need to play a total of 20 battles to post in this section.
Helstrem

Made a random ship picker using Google Sheets

6 comments in this topic

Recommended Posts

3,634
[ARS]
Beta Testers
6,698 posts
6,719 battles

I decided that a lot of my ships were going to waste and that I'd like to set something up so that once or so per day I take out a random ship that isn't related to any particular task I am doing.

I compiled lists of my ships in three categories, All Ships, Premium Ships and Tech Tree ships.  I then used this formula to generate a random selection: =INDEX(A2:A, RANDBETWEEN(1, COUNTA(A2:A)))

The sheet looks like this:
Random.thumb.png.8d07b9129d447daff92fe9338bb50421.png

I just select an empty cell and press Delete and it randomly selects a ship from the appropriate list and displays it in the green cell.  The red cells don't do anything, they are just highlighted empty cells to hit delete in.  The formula is tweaked to select the correct column of course, the one I listed is the the A column of All Ships.

  • Cool 2

Share this post


Link to post
Share on other sites
3,634
[ARS]
Beta Testers
6,698 posts
6,719 battles

Finished editing the lists last night and used it for the first time.  Looking at premiums only for the time being.  HMAS Vampire was selected, played it in a loss where there were 10 bots per side.  Got a dev strike on a human player in a cruiser.

Share this post


Link to post
Share on other sites
3,714
[WOLF1]
[WOLF1]
Beta Testers
12,984 posts
18,336 battles
17 hours ago, Nutaz said:

There is one in Aslain's modpack

Man that would be nice to get in the main modpack.

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×