Azur Lane Quick Stat Comparison sheet (2024)

1

Welcome to my attempt at something of a quick-reference spreadsheet. The goal of this spreadsheet is to provide relevant and focused (Or simplified) data that can be accessed and compared quickly and easily.

The Masterlist tab contains all of the ships in the game, their lvl 125 max stats, and the first node you can find them in and/or their construction types and times. Note that the node listed as their drop location is only the first node they can drop at, not necessarily the only one. If you want to see more detailed information for a ship, like all of its drop locations, their names are linked to their wiki page for easy access.

The Ship Type tabs break down the different types of ships (DD, CL, BB, etc.) and have color grading on their stats so you can see how ships perform stat-wise compared to other ships of their same, or similar, type. They're pretty colorful and might make your eyes bleed at first, but I've found this extremely helpful. Skills are listed on these pages to the right of the stats. Mouse over a skill to get a description of what it does. Numbers in the skill descriptions are at max rank, usually level 10, or max limit break. Finally, there are 3 columns for what gear they use, and one column that shows the efficiency of that gear (100/110/120, for example, would mean their primary weapon would work at 100% efficiency, their secondary at 110%, and so on).

I've kept retrofits seperate from their originals. You'll see a non-retrofit "Cassin" and a "Cassin (R)" for the fully-retrofit version, for example.

At the end are tabs for Weapons, Aircraft, AA Guns, Aux Gear, and ASW Gear. They only show the gold and purple versions of each item (If they have them) in an attempt to keep things simple. I get the DPS numbers and stats from the AL wiki linked below.

I want to stress that this isn't a guide or a rulebook. If you want a guide, look below for a link to AriPanda's Azur Lane Guide. It's a very impressive and comprehensive guide. If you want a deep dive into the game's intricacies I've also linked Doublemint's "Gear and Girls" Google Doc. It's been incredibly helpful to me as I was getting into the game. I'm still not an expert at this game by any means, I just know the numbers. Thanks for the hard work everyone has put into the wiki and other resources that've helped me out.

The formula used for the "Air Sup" (Air supremacy) column in the CV tab was kindly provided by @deceived on Discord.

Finally, If you have any questions or ideas that'll help me improve the spreadsheet without making it too cluttered or confusing, or if you find any mistakes, please let me know. My Discord is Gorreci#9871. I'm in the offical Azur Lane Discord. I'm a lurker though, so you won't see me in any of the channels for the most part.

If you're not familiar with spreadsheets, the tabs are at the bottom.

Changlelog:

05/21/2023: I've uninstalled AL and no longer plan on updating this spreadsheet. Feel free to copy this spread sheet and use it as a base to continue on your own or do whatever you like with it. I hope it helped people while I still updated it, but I have too many things going on IRL these days to continue to play AL or update this spreadsheet.

01/27/2023:

I finished adding all the new Augment modules. I'll do the Atelier Ryza Augment Modules, Auxiliary gear, and ships later. I have no data on the air-burst AA guns, so I'll leave them out until I do.

01/26/2023:

Added ships and stats since last update, and added most gear. Will add Atelier Ryza stuff later along with all the Augment Modules they've added since last update.

08/01/2022:

Worked on the Augment gear tab today. I'm happy with it as it is now, so I probably won't go back to it until they add more to the game. I'll get the new ships added to the other tabs tomorrow or the day after and work on some skill description stuff while I'm at it.

07/30/2022:

Did a pass on the acqusiition columns in the Masterlist tab. A lot of ships had out-of-date methods of acquiring them listed, or were still showing "Limited" when they were available for construction. I'll try to get the ship skill descriptions at least started tomorrow.

07/29/2022:

I've finished the Aux gear update and I've reorganized it a bit. I added a new column for compatible ships, so it's easier to see what ships taht gear can be equipped on. It's in ship designations like DD, AE, BB, etc., but hopefully it isn't too confusing.

Next I'll probably work on finishing the Augment gear tab, adding descriptions to what their effects are.

If I ever get around to it, I plan on going through the ship skill desciptions that I've skipped over these past few months. I need to change a few things on ships that have fate simulation and augment gear skill enhancements as well.

07/28/2022:

I've added the weapons and aircraft that I've missed over the past few months. I've also listed the ships coming in today's update in the Masterlist tab with the stats on the wiki, but I'll keep them there for a few days before moving them to the other tabs just in case.

I've still got aux gear and the new special gear to add. The servers are about to go back up though so I'm done for today, I gotta get those new waifus

07/27/2022:

Added the ships and their stats since I last updated. Haven't bothered with skill descriptions yet. I need to go over how I do skill descriptions anyway. Also considering how to implement the new gear slots that were added. I'll probably just make a new tab for them.

I'll get to the new weapons and gear tomorrow or the day after.

04/11/2022:

Updating now, only have my laptop ATM so it'll be slower updating than usual. So tedious without a second monitor...

I'll get the stats done today but skill descriptions will have to wait, I don't think anyone uses this spreadsheet for skill descriptions anyway. I'll update them when I have a decent setup again.

Also not sure on the DDG's mainfleet stats

Edit: Stats are in, added some new weapons (Not sure if I got all of them), skill descriptions will be done later when the house is done and I can get my desktop out of storage.

03/20/2022:

Currently away from home, will start updating again when I get back in 2 or 3 weeks.

01/03/2022:

Added the following ship's stats and skills;

- Ashes BC Gneisenau META
- Ashes CVL Hiyou META
- KMS BB Ulrich von Hutten
- KMS CA Adalbert
- KMS CVL Elbe
- KMS CL Magdeburg
- KMS SS U-1206

12/21/2021:

Added the new Gear Lab weapons and some of the season 4 research weapons I missed.

11/30/2021:

Added stats and skills for:

- USS CA New Orleans
- MNF CA Foch
- SSSS CV Chise Asukagawa
- SSSS BB Akane Shinjo
- SSSS BB Mujina
- SSSS CA Yume Minami
- SSSS CA Namiko
- SSSS CL Rikka Takarada
- SSSS CL Hass

Also updated U-96's stats.

11/04/2021:
Add stats and skills for:

- FFNF DD Le Terrible
- FFNF DD Maillé Brézé

I've also added all the DD max LB bonuses.

10/30/2021:

Will add stats for the two new ships when I get them.

10/19/2021:

I'll be finishing up with the last of the ships in a sec, just wanted to get this to-do list down while I was thinking about it. I've changed the order of the columns in the Masterlist and ship class tabs to match the same order as it's in on the wiki. It made it easier for me to fill in the cells instead of jumping around and such. I could've copy+pasted, but I took my time to fill in each cell just so I could get an idea of the stat changes for each ship type. There were mistakes in the spreadsheet that I never caught that've been fixed due to going over every ship manually. I probably still made a mistake or typo or two doing all this, but I think I fixed more than I broke. Probably. I've tried to be careful and double-check things I type in as often as possible, but I'm not the most consistent typist.

Left to do:
- Work on new DD column (Done)
- Update PR ship skill descriptions (Fate simulation shenanigans)
- Update limited/build times for ships moved to war archive/core data
- Not sure on U-96's lvl 125 stats, her stats are still lvl 120 ATM.

10/17/2021:

Added the skills to Fusou META, and apparently I had missed adding HMS Penelope to the ship type tabs, so I added her in too with her skills.

Finished the CLs, CAs, and CBs today. Might be able to finish the rest of the ships tomorrow.

10/16/2021:

I've finished updating the stats for all the Destroyers, and I got most (if not all) the base game ships. I'll work on the other classes tomorrow or so. Dotted lines updated to show where I left off in each class tab. I'll start working on the limit break bonuses for the Destroyers when I'm done updating the stats for all of the ships.

For those that are interested, all Destroyers got a boost to their Evasion (By about 40, depending on faction and DD type) and their Accuracy. Most CLs got a boost to Evasion as well, but not as much, maybe about 15-20 EVA on average. CAs didn't really get anything. RIP.

I've also added Fusou META, will add her skills tomorrow.

10/15/2021:

I've started working on the lvl 125 stat changes for all the ships. I got up to #150 on the list, there's a dotted line in the ship class tabs that show where I've gotten to. I'll continue tomorrow or the day after.

09/30/2021:

Update's out today, I'll be updating all the ships up to their lvl 125 stats and listing the Destroyer bonuses from last update while I'm at it. It'll be a long and gradual process. I'll list here what I get done, but for the first day or two I'll focus on actually playing the game. After that I'll focus on getting the spreadsheet updated.

09/19/2021:

Add ship stats and skills for the following ships added in the "Upon the Shimmering Blue" update:

- Ashes CV Souryuu META
- IJN CV Katsuragi
- IJN CA Chikuma
- IJN CL Yura
- IJN DD Shimakaze
- IJN DD Umikaze
- IJN DD Yamakaze

09/17/2021:

While I wait for the numbers and stats and the like, I'm experimenting with how I'll update the DD tab to reflect the new buffs they got. It'll be a long-term process, there are a lot of DDs in the game. I'll update the stats as soon as I get them. Still struggling to get Shimakaze...

09/13/2021:

Getting ready for the new event coming with Shimakaze. For Souryuu Meta, I'm not the fastest grinding Opsi, so I'll have to get the numbers from the wiki. It'll be a while probably. Sometimes the numbers fluctuate after they add her too, I don't think it's a simple matter of datamining for the Meta ships.

EDIT: Apparently there are plans to increase the lvl cap to 125 soon. FML that's gunna be a lot of work.

08/21/2021:

Should have all the ships done now. There was a lot added so I won't list them here, but we're all caught up, Ingraham and Nautilus included.

08/20/2021:

All the ships have been added with stats and put in their categories, but only DDs, CLs, and CAs have their skills and such listed. Will finish on the rest of the ships tomorrow.

08/19/2021:

Will be working to update the spreadsheet over the next few days.
Update: Updated weapons, aircraft, and gear, will work on ships starting tomorrow morning. Let me know if I missed any gear, got a bit of a backlog to work through so I might've missed an item or two.

03/22/2021:

It's been a while. I've added all the ships, along with their stats and skills, since I last updated. I'll be adding the few pieces of new gear as well in a bit.

- SN BB Sovetskaya Bellorussiya
- SN CA Tallinn
- SN CL Kirov
- SN CL Murmansk
- SN CL Pamiat Merkuria (R)
- SN DD Stremitelny
- SN DD Gremyashchy
- SN DD Gromky
- ROC CL Ying Swei
- ROC CL Chao Ho
- Ashes CV Ark Royal META

01/22/2021:

Added stats and skill for the 2 new ships from the rerun of Empyreal Tragecomedy:
- RN CA Pola
- RN DD Vincenzo Gioberti

01/20/2021:

Updated Hiryuu META's stats and removed the temporary stats note on her.

01/18/2021:

Finished adding and updating the new torpedoes (Both normal and sub types) and AA guns. I've added all the aircraft, but I'm not sure I want another duplicate tab for aircraft after +10 like I did for weapons. I'll try to figure out a solution later, along with finally catching up on the Aux Gear tab (And maybe the ASW tab).

01/17/2021:

Made a new weapons tab for weapons that go beyond +6 or +10 using the new parts from the Operation Siren update. DD, CL, CA, and BB weapons are done. I'll get to the torpedoes and the other gear soon.

I was going to just update the tabs I already have at first, but the gap between weapons would only grow and it'd be difficult for newer players to get a sense of how weapons from varying rarity types stack up against each other when the gap gets so large between +11 and +13.

I may come up with a better method for the Aux Gear and AA tabs, but we'll see.

12/29/2020:

Added the Inverted Orthant ships. Gear from Operation Siren is still trickling in.

12/25/2020:

Merry Christmas! Gear is still being added over time, I'll add another notice here when I'm done, though honestly I'll probably be done with Inverted Orthant's event additions before I'm done with all the new gear.

12/22/2020:

Working on adding Operation Siren stuff now

Edit1: I've updated skill descriptions and stat changes for existing ships, and I've added an entry for Hiryuu META in the masterlist, but it's not representative of her potential, I think, so I'm leaving her there for the moment while I figure this update out. I've started adding most of the new gear, but I need to play the update, so I'll be doing that and I'll update the gear and weapon lists when they're up on the wiki.

12/14/2020:

Been busy. Finally got around to adding the Venus Vacation ships, stats, and skills. Will add the gear and such later.

Edit: I had time so I got the aux gear all caught up.

10/29/2020:

Added stats and skills for the new ships. I've also included USS CVL Princeton on the spreadsheet. I didn't realize that she had already come out in Japan. Unfortunately, I already deleted the 'local' column, so just know for now that she's not in the English version of the game yet.

10/28/2020:

Added entries for the following ships coming in the next update:
- IJN CV Taihou µ
- HMS CV Illustrious µ
- KMS CA Roon µ
- USS CA Baltimore µ
- HMS CL Dido µ
- SN DD Tashkent µ
- MNF Le Malin µ
- USS SS Albacore µ

Dunno why, but it seems like Baltimore µ and Albacore µ are Elite instead of Super Rare for some reason.

Finally removed the 'Local" column. Doesn't seem to be needed anymore.

10/07/2020:

Got around to adding stats and skills to Ariake (R). Nothing new or interesting there.

09/29/2020:

Added entry for Ariake Retrofit, and changed the local column for HMS DD Eskimo. Once the update hits I can finally remove the "local" column, or at least hide it.

09/19/2020:

Updated skill descriptions for the four ships that had ASW-related skills, Chaser, Koln, Cooper, and Odin. Changed and updated most of the ASW gear too, though there may be further changes needed.

09/17/2020:

I've added the new ships' stats and skills;
- IJN CV Shinano
- IJN BB Kii
- IJN CVL Chitose
- IJN CVL Chiyoda
- IJN CA Kumano
- IJN AE Kashino
- Specialized Bulin MKIII

I've made a new tab for the repair and munition ships. I'm not really happy with it, but it'll do for now.

I've also updated Kitakaze's ASW stat.

I'll add the new aux gear when I get info on them or get them myself.

09/09/2020:

Updated local columns for Z2, Hardy, and Hunter. It's late, but nothing's changed other than the fact they were finally released.

08/20/2020:

Added stats and skill for Z26 and U-96 and put them in their appropraite tabs. Don't have U-96's Oxygen stat yet but I'll update it when I know.

08/19/2020:
Added entries for the 2 new ships coming in tomorrow's rerun of Scherzo of Iron and Blood:
- KMS DD Z26 (Elite)
- KMS SS U-96 (Super Rare)

No info on stats or skills yet.

08/12/2020:

Got around to updating skill names and descriptions for the new ships. Have been busy recently, sorry for the delay.

08/06/2020:

Updated local column for the following ships to reflect changes in today's update:
- HMS BB Howe
- HMS BB Valiant
- HMS CV Eagle
- HMS CVL Perseus
- HMS CL Hermione
- HMS DD Icarus

Some skills still have temporary names.

07/29/2020:

Nothing major, tweaked some skill descriptions for the upcoming ships, and modified the color-coding on the ship classes to help tell them apart from each other. For example, BBs, BCs, and BMs now have different colors so they're easier to pick out at a glance.

07/25/2020:

(Part 2) Went ahead and added them to their individual tabs anyway, with temporary skill descriptions. I may have misinterpreted the translations, so don't take these skill descriptions as completely accurate.

07/25/2020:

Finished adding stats to the new HMS ships. Their skills aren't translated yet, and I don't have the confidence to parse Google Translate to get the skills correct, so they're going to stay in the Masterlist for now. I've also added the new new gear pieces, the new fighter and the new Aux torpedo.

07/24/2020:

Added entries for the new ships coming with the next event. Six new Royal Navy ships, I've only seen some stats for three of them so far, and I don't have their skill descriptions yet so they'll stay in the Masterlist for the time being.

07/18/2020:

Updated skill descriptions for research ships that have Fate Simulation to show their improved skills. Also double-checked them to make sure that those that do have Fate Simulation also have 15 Luck to reflect being fully upgraded.

07/16/2020:

Updated skill descriptions for Drake and Odin, and changed the local column for the following ships to reflect changes in today's update, the rerun of Ink-Stained Steel Sakura:
- IJN CA Suzuya
- IJN SSV I-13

07/12/2020:

New weapons have stats and DPS numbers added.

07/11/2020:

Added stats and skills for the 5 new research ships and put them in their respective tabs. I'll be keeping an eye out for the new weapons added. The new AA gun is already listed with its stats.

07/08/2020:

Added entries for the 5 new research ships coming in the next update, I don't have info on stats or skills yet though;
- FFNF BB Champagne
- KMS BC Odin
- HMS CA Drake
- HMS CA Cheshire
- KMS CL Mainz

I'll keep an eye out and add their stats and skills as soon as I see them pop up and/or I get in game after the update and look up their skills there. I'm not a data miner so I rely on the wiki for the stats though. If you see 'em pop up before I do, feel free to poke me on Discord.

Also adjusted the acquisition column based on the patch notes.

07/02/2020:

Added Pressure-Resistant Hull Design core data item to the Aux Gear tab.

06/23/2020:

Updated Local column for the following ships to reflect changes in tonight's update:
- USS CV Shangri-La
- USS CVL Independence

06/19/2020:

Added HMS DD Eskimo and her stats and skills. Skybound Oratorio CL guns are updated, Aircraft info still incomplete.

06/12/2020:

Added entries for what I'm assuming is 2 new CL guns (Only blue quality) and a Fighter and Torpedo Bomber (Also blues), but I don't have any stats or info on them yet, other than names. Also added the new 138.6mm gun that uses the old icon the original 138.6mm used to use.

06/11/2020:

Updated skill names for the new ships and added the new CA weapon from the event shop. The rest of the gear will be added tomorrow. Probably.

06/07/2020:

Added Hatsushimo (R)'s stats and skills. I've also added the Iris/Vichya ships coming in the upcoming "Skybound Oratorio" event to their corresponding tabs, but I don't have skill names yet, so they're left blank;
- FFNF BB Richelieu
- FFNF CV Béarn
- FFNF CL Jeanne d'Arc
- MNF CA Algérie
- MNF CL La Galissonnière
- MNF DD Vauquelin

06/04/2020:

Added USS Helena's retrofit stats and skills and moved her to the CL tab. Working on getting the stats for Hatsushimo (R)

05/29/2020:

Added HMS CV Little Illustrious and her stats and skills.

05/20/2020:

Updated the local columns for the following ships to reflect changes in tomorrow's update and the Iris of Light and Dark Rerun:
- FFNF DD L'Opiniâtre
- MNF DD Le Malin

05/19/2020:

Updated HMS CL Swiftsure's Local column and the Acquisition columns for some of the Winter's Crown ships and other ships from the last update. Adding the new upcoming Iris/Vichya ships (After the rerun coming later this week, there's another Iris event coming. The rerun ships have been in the sheet for a long time.) as I get info on them, but they won't be in their class tabs until they're out, probably.

05/09/2020:

Fixed some incorrect oil costs, particularly on ships added in the past few months. Most recently added ships (Starting at around the time of the Northern Parliament event) had one higher oil cost than they should've had.

05/07/2020:

Updated the icon for the Iris DD gun to match the new update, and added the new event ship along with stats and skills,
- MNF DD Tartu

I've also changed all research ships' luck to 5, from 0, since you can get them to 5 luck from Fate Simulation.

04/24/2020:

Finished adding stats and skills to all the new ships and put them in their respective tabs.

04/23/2020:

Added skills and stats for Isuzu (R) and Tosa and copied them to the appropriate tabs. I haven't built the two new DDs and I don't know Little Renown's lvl 120 stats yet, so they'll stay in the Masterlist for now.

04/22/2020:

Added entries for new ships coming in tomorrow's update:
- IJN BB Tosa
- IJN DD Naganami
- IJN DD Hanazuki
- HMS BC Little Renown

- IJN CL Isuzu (Retrofit)

Also changed the Acquisition column for some older ships.

04/16/2020:

Updated acquisition column in Masterlist to reflect changes in today's update.

03/27/2020:

PBY-5A Catalina has stats now, was moved from ASW Gear to Aux Gear, was mistaken in its use, it's a scout plane instead of an ASW bomber. TBM Avenger (VT-18) Torpedo bomber seems to finally dethrone the Barracuda in damage.

03/26/2020:

Added stats and skills for the new ships added today and placed them in the appropriate tabs. Added entries for the new aircraft (Avenger VT-18) and the Catalina, but their stats aren't finished.

03/25/2020:

Added the following ships coming in tomorrow's update, without stats and skills for the moment:
- USS CV Intrepid
- USS CVL Casablanca
- USS CA Bremerton
- USS CL Reno
- USS CL Marblehead
- USS DD Cooper
- USS SS Bluegill

Also added the two retrofits coming in tomorrow's update, and updated their local columns:
- HMS DD Amazon (R)
- IJN DD Hatsuharu (R)

03/13/2020:
Updated the icon for one of the new Northern Parliament AA guns. Forgot to update it when the patch fixed it.

03/11/2020:

Added stats and skills for HMS DD Amazon Retrofit.

02/27/2020:

Added stats and skills for the new ships, put them in their appropriate tabs, and added the new Weapons, AA guns, and Aux gear from the event.

02/26/2020:

Added the following ships to the spreadsheet to reflect changes in tomorrow's update and event, "Northern Overture." No stats on the ships at the moment, will update again when they're finished, I'll update them as I get info for them.
- SN BB Sovetskaya Rossiya
- SN BB Gangut
- SN CL Chapayev
- SN CL Pamiat Merkuria
- SN DD Tashkent
- SN DD Grozny
- SN DD Minsk

02/19/2020:

Changed the local column for the following ships to reflect changes in tomorrow's update:
- IJN DD Shigure Retrofit
- IJN DD Yuugure Retrofit

02/12/2020:

Changed the local column for the following ships to reflect changes in tomorrow's update and the "Passionate Polaris" event;
- IJN CV Akagi (Muse)
- MNF BB Gascogne (Muse)
- KMS CA Admiral Hipper (Muse)
- USS CL Cleveland (Muse)
- HMS Sheffield (Muse)

02/05/2020:
Changed acquisition for Southampton and Kiyonami to the Light Build Pool to reflect changes in tomorrow's update. I don't have the build times yet, but I'll keep an eye out.

01/24/2020:

Added the new AA gun from the event that I thought was another DD gun. Woops.

01/23/2020:

Updated stats and skills for the 5 new ships and placed them in the appropriate tabs.

01/22/2020:

Added the purple single 130mm DD gun to the weapons tab. While I was at it, I made some changes and tweaks, I've added the wiki's "Raw DPS" column as well, and tried to arrange it in a way that shows how important ammo type is to the final damage output. Also did a pass over the DPS numbers to make sure everything was up to date, and added a new column to seperate the distance a weapon will fire at a target, and the distance the shells will travel after being fired. I also got this from the wiki. I'll keep an eye out for the other DD gun from the event and add that when there's info for it.

Don't have the stats for the new ships yet either, but I'm keeping an eye out and will update once they're up on the wiki.

01/20/2020:

Changed local columns for the following ships to reflect changes in tomorrow's update:
- HMS CL Newcastle (And her retrofit)
- HMS CL Curlew (R)
- HMS CL Curacoa (R)
- IJN DD Nagatsuki

Also added entries to the Masterlist for new ships coming in tomorrow's update. No stats or skills yet.
- HMS CL Dido
- HMS CL Gloucester
- USS CL Biloxi
- USS DD Halsey Powell
- IJN DD Uranami

01/14/2020:

Did some cleanup and cosmetic stuff, fixed a few things, nothing major. I've also changed the local columns for the ships coming on the 16th along with Chapter 13:
- USS CV Bunker Hill (Chapter 13 boss-only drop)
- USS DD Dewey (Another Chapter 13 drop)
- HMS Hermes (R)

12/26/2019:
Finished adding stats and skills to the new "Swirling Cherry Blossoms" event ships:
- IJN BB Suruga
- IJN CVL Ryuuhou
- IJN CL Noshiro
- IJN CL Kinu (And her retrofit)
- IJN DD Hibiki
- IJN DD Kasumi

Also changed local columns for:
- IJN CL Yuubari (R)
- IJN DD Kisaragi (R)

I've moved the Air Superiority column in the CV tab further to the right so I can copy entries from the Masterlist without having to adjust columns afterward. The column stands out a little more now too.

12/22/2019:

Changed local column for IJN Asashio and fixed her missing skill in the DD tab. Also removed a lot of "Not in EN yet" tags I put on some of the gear tabs for the gear that's been added with PR2. I've also tried to clarify which season of research projects you need to take to get blueprints for which gear, but I might've missed some. I've gone through and updated the PR2 ships' skill names to match the EN version now.

Also added entries for the ships being posted in the AL official Discord, won't have any information on them until they're out, though.

12/18/2019:

Changed the local column for the following ships to reflect changes in tomorrow's update, bringing in Season 2 Research;
- KMS BB Friedrich Der Große
- MNF BB Gascogne
- USS BB Georgia
- IJN CB Azuma
- USS CL Seattle
- IJN DD Kitakaze

There's also now a new "AirSup" (Air Supremacy) column in the CV tab. It uses a formula kindly provided to me by @deceived on Discord. Saved me a lot of trouble trying to figure out how to add it myself. Thanks again!

12/06/2019:

All skills and, stats, and names are up to date now, and I've added the event gear to the Aux Gear tab as well.

11/29/2019:

Finally got around to adding the event ships to their appropriate tabs with their skills and stats. Some skill names are unkown for me ATM, I will be revisiting them later. I'll also double-check stats later, too. It's hard for me to believe that Aqua's speed stat is 40 while all other SS's are in their 10's. I'm having problems building the new ships, so I can't check the skillnames myself yet. 120 cubes in and only 2 of the new ships built...

11/27/2019:

Added the following ships to the Masterlist to reflect changes in today's update and the "Looking Glass of Fact and Fiction" event. Still in the process of adding stats and skills, will update this changelog again when everything's up to standard.
- DD Shirakami Fubuki
- SS Minato Aqua
- CV Tokino Sora
- CV Ookami Mio
- CVL Murasaki Shion
- CA Nakiri Ayame
- DD Natsuiro Matsuri

11/21/2019:

Changed local column for HMS BB Warspite (R) to reflect changes in tomorrow's update. HMS CL Glasgow's also been added to the spreadsheet a week ago, I just forgot to update the changelog.

11/12/2019:

Added the "Crescendo of Polaris" event ships to the spreadsheet and put them in the appropriate tabs. I held off on adding them because I wasn't sure they'd be coming to AL Global, but they've said we're getting it early next year, so I finally added them:
- IJN CV Akagi (Muse)
- MNF BB Gascoigne (Muse)
- KMS CA Admiral Hipper (Muse)
- USS CL Cleveland (Muse)
- HMS CL Sheffield (Muse)

11/08/2019:
Added Shigure (R) and Yuugure (R) to the spreadsheet. They slipped under my radar somehow, but they're in the spreadsheet now and in their appropriate tabs.

10/30/2019:

I forgot a ship, changed local column for;
- USS CL Memphis

10/29/2019:

Changed local columns for the following ships to reflect changes in the upcoming update and the rerun of the Divergent Chessboard event:
- KMS CL Leipzig (R)
- KMS DD Z1 (R)
- KMS SS U-47
- KMS SS U-557

Also finally remembered to update USS Smalley.

10/22/2019:

Added two new ships coming in tomorrow's update.
- USS DD Smalley (Still in masterlist only, no stats/skills yet)
- KMS SS U-110

10/16/2019:

Changed local columns for the following ships to reflect changes in tomorrow's update and the "Return of the War God" Event;
- IJN BB Mikasa
- IJN BC Hiei
- IJN DD Kuroshio
- IJN DD Oyashio
- IJN DD Hamakaze (And her retrofit)

10/06/2019:

Updated Aux and ASW Gear tabs.

10/04/2019:

Updated the Aircraft and AA tabs the same way I did the Weapons tab yesterday.

10/03/2019:

After receiving feedback a couple of times that some images don't load, I've changed how the images are loaded in the Weapons tab. Instead of downloading the image from the wiki every time you look at the spreadsheet, I've downloaded the images and then uploaded them to the spreadsheet itself, so the images should load much more consistently. I've also linked the individual weapon pages on the wiki to the weapon names, just like in the ship tabs. This should be a good workaround if the images still aren't loading. Some weapons even have previews on how they fire, so if my explanations are confusing, that should help.

I'll be updating the other tabs over the next few days. It's not a difficult process, but it is a little time consuming.

09/29/2019:

Added VC and VH armor from the Crosswave event to the Aux Gear tab.

09/25/2019:

Changed local column for the following ships to reflect tomorrow's update:
- IJN CV Souryuu (R)
- IJN CV Hiryuu (R)
- HMS DD Jersey

Added War Archives as another way to get the following ships in their notes column:
- IJN CV Shoukaku
- IJN CV Zuikaku
- IJN BB Hyuuga
- IJN BB Ise
- IJN DD Yukikaze
- IJN DD Nowaki

Also finally got around to adding Kiyonami's stats and skills, I forgot about her, sorry about that.

09/12/2019:
Finished adding stats and skills for the new ships:
- HMS CV Formidable
- RN BB Littorio
- RN BB Giulio Cesare
- RN BB Conte di Cavour
- RN CA Zara
- RN CA Trento
- RN DD Carabiniere

09/11/2019:

Added new Weapons, Aircraft, and AA guns rolled out with this update to the appropriate tabs. Most stats are done for the new ships, and skills will come later. Will update again when they're done.

09/10/2019:

Changed local column for York (R). Added the ships being added in tomorrow's update to the masterlist. No stats on any of them yet, though.

09/05/2019:

Added USS DD Stanly.

08/29/2019:

Stats and skills added for HMS Black Prince and USS Bache, placed in appropriate tabs.

08/28/2019:

Changed San Diego retrofit's local column to reflect her addition in tomorrow's update, Episode 4 of the Anniversary event chain. Added blank entries to the Masterlist for the following ships:
- HMS CL Black Prince (Dido-class)
- IJN DD Kiyonami (Yuugumo-class)
- USS DD Bache (Fletcher-class)

08/23/2019:

There's a Meowfficer (I'll never get used to typing that) tab on the sheet now. It's been done for a few days, but I just got around to updating the terminology to match the game (Logistics stat instead of Support stat, for example). I'm looking into adding the abilities to the spreadsheet somehow, but I'm not sure how that'll work yet or if it's even worth it to add to the spreadsheet.

08/21/2019:

Changed local columns for the following ships to reflect changes in tomorrow's update, Episode 3 of the Anniversary event chain:
- HMS CA Exeter (R)
- HMS CL Achilles (R)

Meowfficers are coming tomorrow as well, I'll work on including them in the spreadsheet. It may take me a few days, Meowfficers aren't as simple as just items or weapons and include a lot of unique stats and effects. As usual, I'll try my best to make them easy to read, understand, and compare. It's a pretty complex system, so hopefully it won't be too sloppy.

08/14/2019:

Changed local columns for the following ships to reflect changes in tomorrow's update, Episode 2 of the Anniversary event chain:
- USS CV Essex
- IJN CV Taihou
- FFNF DD Le Temeraire
- USS SS Albacore
- IJN CL Yuubari

08/09/2019:

Reworked Aux Gear page. You can now sort by stats to make it easier to find what you're looking for. It's not as simple or clean as it was before, but I feel this is in an improvement overall. ASW gear was moved to the ASW Gear tab.

08/06/2019:

Changed HMS DD Jupiter's local column from "No" to "Yes" to reflect tomorrow's update.

08/04/2019:

I went through the ships I have in-game (I'm currently at 79.7% completion, so I'm missing quite a few) and changed a lot of the skill names on the spreadsheet to match the game. The skill names on the Wiki differ a lot sometimes, so I attempted to cut down on the differences. I left a few the same as the wiki for personal tastes and/or to fit them in the skill columns, but they're the same for the most part.

Also fixed some incorrect skill descriptions, mostly between "Burn Order", "Arsonist", and some of the other HE effect skills. When I originally made this spreadsheet I didn't realize there was a difference between the first two, so they ended up being copy+pasted to everyone that had an HE shelling skill.

07/31/2019:

Stats and skills have been added for new event ships released today. Changed Sims (R) local column to reflect her addition in today's update.

07/29/2019:

Added the NY City Coast Recon Report item to the Aux Gear tab.

07/27/2019:

Added entries to the Masterlist for the new ships announced for the next update. No stats or info on any of them yet, they're listed for future convenience.
- USS BB Alabama
- USS CVL Bataan
- USS CA Baltimore
- USS CL Birmingham
- USS CL San Juan
- USS DD Aylwin
- USS SS Cavalla

I've removed unreleased ships from the ship type tabs, but kept them in the masterlist. Didn't like getting ships with a bunch of question marks when I sorted by a stat. They'll stay in the masterlist tab until they're added to the game.

07/25/2019:

Updated the Aircraft tab to match new numbers on the wiki, added a few planes that have been added since I made the tab, and added two new columns for plane evasion and crash damage.

07/24/2019:

Changed local column for HMS CVL Centaur.

07/17/2019:

Added HMS CA London Retrofit

07/12/2019:

Added stats for the following ships and put them in their corresponding tabs;
- IJN SS I-25
- IJN SS I-56
- IJN SS I-168
- KMS SS U-101
- KMS SS U-522

07/10/2019:

Changed local column to reflect changes in tomorrow's update.
- IJN DD Kagerou (R)

- No information on them yet, but I've added entries for the 5 new subs.

07/06/2019:

Changed USS Nicholas (R) to "Yes" in the local column a few days ago, but forgot to update the changelog.

06/28/2019:

Added two ships added to Iris even rerun, not in the EN version.
- MNF DD Le Malin
- FFNF DD L'Opiniatre

06/27/2019:

Added Emile Bertin (R)'s stats and skills.

06/26/2019:

Changed local columns to reflect changes in tomorrow's update for the Iris Event:
- USS BB Massachusetts
- MNF BB Jean Bart
- MNF BC Dunkerque
- FFNF CL Emile Bertin
- FFNF DD Le Triomphant
- MNF DD Le Mars (And her retrofit)
- FFNF DD Forbin (And her retrofit)
- FFNF SS Surcouf

- Added an entry for FFNF Emile Bertin's retro in the masterlist, but I don't have stats for her yet.

06/22/2019:

Added two new retrofits, not available in EN yet:
- HMS CL Curacoa (R)
- HMS CL Curlew (R)

06/19/2019:

Changed local columns to reflect changes in tomorrow's update:
- HMS CV Glorious
- HMS DD Acasta and her retro
- HMS DD Ardent and her retro

06/16/2019:
Added this month's monthly login ship:
- HMS CL Southampton

06/14/2019:

A day late, but changed local columns to reflect changes in yesterday's update:
- IJN CVL Hiyou
- IJN CVL Junyou
- IJN CA Choukai

- HMS CL Swiftsure isn't in EN yet, but I've added her to the spreadsheet.

06/09/2019:

Experimenting with a few things;

- I've changed the ID sorting so that retrofit ships are listed beside their non-reto version when sorted by ID. I'm not sure this is better than it was previously, but I'm going to leave it for a while to get a feel for it.

- Added a crude section on the far right of the CA and CL tabs that show how many main gun/torpedo/AA gun mounts each ship has. I'm not really happy with it and it will most likely change once I figure out a better way to implement that information. - Still looking at the viability of using the headers I made in the sandbox tab, which might also help the issue above.

06/08/2019:
Added two more ships recently added in the CN version that we don't have yet.
- KMS DD Z1 (R)
- KMS CL Leipzig (R)
- Fixed Elegant Kizuna's skill cells.

06/05/2019:

Koln (R) stats added, and added her to the appropriate tabs.

06/03/2019:

Changed the local column for Achilles (R). I mistakenly had her retrofit listed as available in the EN version, but it's not in for us yet. Apparently I just assumed it was when I saw Ajax's retro in-game.

05/30/2019:

Added 3 new ships coming in today's update:
- USS CL Li'l Sandy
- USS CL Clevelad (That's not a typo)
- USS CL Lena

05/24/2019:

Missing a few numbers, but the Bismarck event ships are now in their correct tabs and updated.

05/23/2019:

Updated local column to reflect changes in today's update:
- KMS BB Bismarck
- KMS SS U-73
- KMS SS U-556
- KMS DD Z36
- HMS BB King George V
- HMS DD Echo
- KMS CL Koln retrofit

05/21/2019:

Added a few more entries for some of the new ships coming, but I don't have anything on them yet other than names, so they're sitting in the Masterlist for now. Again, I'll keep an eye out for updates.

05/18/2019:

A small update, added:
- HMS CVL Hermes Retrofit
- Entry for KMS SS U-556, no stats for her yet. Will update again when I have them.

05/11/2019:

Just some general improvements and additions:
- Created new ASW Gear tab
- Made some slight changes to to Aux Gear tab

05/08/2019:

Updated local columns to reflect changes in tomorrow's update.
- HMS CA Sussex
- HMS BM Abercrombie

05/05/2019:

Updated local columns to reflect changes in today's update. Research project ships;
- HMS CL Neptune
- HMS BB Monarch
- IJN CA Ibuki
- IJN BB Izumo
- KMS CA Roon
- FFNF CA Saint Louis

- Removed "Not in EN yet" tags from Research season 1 gear

- Changed the top row stat names to the abbreviated versions used in the game. This has helped cut down a lot of wasted space in the spreadsheet, and gave me the opportunity to standardize cell sizes, so the spreadsheet looks a lot better IMO. I've added notes to the headers so that those that aren't familiar can easily find out what they mean.

04/27/2019:

(Part 2) I'll update here when I update a tab to lvl 120:
- DD tab updated
- CL tab updated
- CA tab updated
- CA/CL tab updated
- BB/BC/BM/BBV tab updated
- CV/CVL/BBV/AR tab updated
- SS tab updated

Everything's updated to lvl 120 and copied over to the other tabs. I've probably made a few mistakes or typos, even after going over them all at least twice. If you find any mistakes or something looks funny, let me know.

04/27/2019:

The wiki pages for the ships are back to normal, so I finished updating stats in the Masterlist. Before I copy them over, I'm going to go over them again to make sure I didn't miss anything, considering I did it over the course of two days with a pause in the middle.

Also added Kisaragi's retrofit.

04/26/2019:

End of the day, I've converted most stats to lvl 120. Unfortunately, there seems to be an issue on a lot of the ship wiki pages ATM which makes getting stats from them really difficult. Most of the normal ship are updated, but some of the retrofits still have their lvl 100 numbers simply because I can't read their lvl 120 numbers and their wiki pages are going through a rebellious phase. For now, the Masterlist will be lvl 120 stats while the individual class tabs still have their lvl 100 stats. The information has to be complete before I will copy them over for reasons mentioned earlier in the changelog

04/26/2019:

The pages have been created for the new ships, only the lvl 120 stats for now. I'll be changing the stats to lvl 120 numbers over the next few days, since it seems easier on the folks creating the wiki to get those numbers. It'll make it easier and faster. I'll do it on the Masterlist first and then copy them to the class tabs when I'm done, so the color grading doesn't get skewed.

04/25/2019:

I've added entries for the Kizuna Ai Collab ships and the Operation Manjuu ships. I don't have any information on them at all however, so they're sitting mostly blank in the masterlist until I get more info. I'll add information as I get it or see it uploaded on the wiki.

04/24/2019:

Just a few small changes. nothing major has happened in the past couple of days.
-Changed "Belchan" to "Little Bel."
-Updated the weapons to match the wiki.
-Changed Azuma to "CB" instead of "CA." This won't change how she's placed in the spreadsheet, she'll still be listed and organized as a Heavy Cruiser, I just included the Large Cruiser designation to be thorough and possibly future-proof, should more ships be released that are also classified as Large Cruisers.
-Updated the landing page a bit too, included some much-deserved links which I should've added earlier.

No lvl 100 stats on the new round of research ships yet, which is understandable.

04/18/2019:

Added some of the new weapons and AA guns included in the second season of research. Some of the numbers are missing, and I don't play the JP version, so I'm completely reliant on the wiki for these numbers (as always, for new stuff). I'll update when I see the missing numbers added in the future.

The wiki now has stats for the lvl 120 versions of the new PR ships, but not the lvl 100 stats. I can't add these because of how drastically it would skew the color grading (FdG's lvl 120 numbers are disgusting), unless I change all stats in the spreadsheet to lvl 120. I'll hold off a while and hope someone can provide their lvl 100 stats. If not, I'll find time to update all ships in the spreadsheet to lvl 120.

04/17/2019: Added entries for the 6 newly announced PR ships (Azuma, Georgia, etc.), as their pages have been created on the wiki. They don't have the stats up yet, so they're just on the Masterlist with links to their pages. When the stats are updated on the wiki, I'll update them here and then add them into their respective tabs, naturally.

04/12/2019:

I've added purple versions of every gold weapon/aircraft/AA gun that had one to the weapon tabs. I don't have very many gold weapons myself yet, so being able to compare the more accessible versions of the best weapons is pretty important. This is mostly a personal convenience thing, but it didn't really clutter up the tabs much, so it I figured I might as well do it.

04/10/2019:

Local columns updated to reflect changes coming in tomorrow's update, Ink-stained Steel Sakura event starts and includes:
IJN DD Fumizuki
IJN DD Kawakaze
IJN DD Asashio
IJN DD Ooshio
IJN DD Harutsuki
IJN DD Yoizuki
IJN BC Kongou
IJN BC Haruna
IJN BB Nagato (Yay!)
IJN BB Mutsu
IJN BB Ise's retrofit
IJN BB Hyuuga's retrofit

04/08/2019: Small polish pass, fixing some typos, cell sizes, and some other things.

04/04/2019:

Added Yuubari's retrofit. Not in EN yet.

04/03/2019: Local columns updated to reflect changes coming in tomorrow's update:
KMS CL Karlsruhe retrofit
KMS SS U-81
IJN SS I-19
IJN SS I-26
IJN SS I-58
USS SS Dace

03/30/2019: Added two more ships added to the wiki, not in the EN version yet:
IJN CA Suzuya
IJN SSV I-13

03/28/2019:

Local columns updated to reflect changes in today's update:
USS CV Saratoga's retrofit
IJN DD Shiranui's retrofit
USS CL Montpelier
USS CL Denver
IJN DD Hatsushimo

Cleaned up a bit by getting rid of most unnecessary cells. No longer is 75% of a tab just blank cells. Hopefully makes the spreadsheet a little easier to use.

03/25/2019:
Added two more ships added to the wiki, not in the EN version yet:
USS CV Bunker Hill
USS DD Dewey

03/21/2019: Local columns updated to reflect changes in today's update. Visitors Dyed in Red event starts today, included ships are;
IJN CL Mogami (And her retrofit)
IJN CL Mikuma
IJN DD Yukikaze
IJN DD Akatsuki
IJN DD Nowaki
IJN CV Shoukaku
IJN CV Zuikaku
IJN BB Ise
IJN BB Hyuuga
HMS DD Foxhound's retrofit

03/18/2019: Attempted to clean up and clarify this landing page a bit. Success has been elusive.

03/16/2019: Finished Aux Gear tab. Just like weapons and aircraft, only shows the best version of each item type to keep things simple. Added submarine torpedoes to Weapons tab

03/15/2019: Removed Alternate CV tab, combined it with the normal tab. Currently working on the gear tab.

03/14/2019: Changed Local columns, ships added by update;
IJN CL Agano
IJN CL Sendai
USS CL Columbia
USS CA Quincy
USS CA Vincennes
USS CA Astoria
IJN BC Kirishima

Retrofits added;
Sendai, Mutsuki, and Matsukaze

Also added upcoming ships and retrofits listed on the wiki but not yet in-game:
USS CV Shangri-La
USS CVL Independence
HMS DD Hardy
HMS DD Hunter
KMS DD Z2
USS DD Sims (R)

Added an Aircraft tab.

Azur Lane Quick Stat Comparison sheet (2024)
Top Articles
Latest Posts
Article information

Author: Otha Schamberger

Last Updated:

Views: 6020

Rating: 4.4 / 5 (75 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Otha Schamberger

Birthday: 1999-08-15

Address: Suite 490 606 Hammes Ferry, Carterhaven, IL 62290

Phone: +8557035444877

Job: Forward IT Agent

Hobby: Fishing, Flying, Jewelry making, Digital arts, Sand art, Parkour, tabletop games

Introduction: My name is Otha Schamberger, I am a vast, good, healthy, cheerful, energetic, gorgeous, magnificent person who loves writing and wants to share my knowledge and understanding with you.