Power by faction
search
Azur lane fleet power calculator
Total ship power
0
No ships yet
Total fleet power
0
inbox
toggle process
Generate to XLSX
Writes your list to a spreadsheet with the fleet power math as live formulas, so you can change a ship's power in Excel and watch the total recalculate. Nothing is imported back into this app, so the tables here and in the sheet stay independent.
What the sheet contains
| Cell | Contents |
|---|---|
| A4 down | One row per ship: number, prefix, name, total power, faction |
| F column | =IF($I$5>0, D4/$I$5, 0) |
| I4 | =COUNT(D4:D…) |
| I5 | =SUM(D4:D…) |
| I6 / I7 | Coefficient 0.9996 and exponent 0.667, as editable inputs |
| I8 | =IF(I5>0, ROUNDDOWN(I6*I5^I7, 0), 0) |
The coefficient and exponent sit in their own cells rather than being baked into the formula, so you can test a different value without rewriting anything.
About this project
A calculator for the Fleet Power number on your Azur Lane commander profile, the one the leaderboard ranks. You enter the Total Power shown on each ship's own status screen and it applies the published formula to the whole roster.
Everything runs in your browser. Your ship list is stored locally with IndexedDB and never leaves the device. The only network requests are for the ship database, the spreadsheet library and the fonts.
Fleet Power = floor(0.9996 x (sum of Total Power) ^ 0.667)
Total Power = (HP x 0.2 + Firepower + AA + Torpedo + Aviation
+ Reload + Anti-Sub + Evasion x 2 + Accuracy x 2)
x Affection Bonus + Speed + Equipment Bonus
Source code
Open source, and a single self-contained HTML file with no build step. Issues and pull requests are welcome.
Sources and attribution
This project only implements the math. The research behind it belongs to other people.
- Azur Lane WIKI (BWIKI, by 碧蓝海事局) is the authority for the fleet power mechanic: the exponent, the rule that every limit break stage counts separately, the list of retrofits that count as their own entry, and the fact that collab ships are excluded while Bulin, META, mu-equipped, child and Type II ships are not. 舰队实力
- Enrico's write-up on note.com documented the coefficient and the per-ship Total Power breakdown in a form that was straightforward to verify in game. Day 626, organizing fleet power
- SheetJS writes the XLSX file, and Roboto with Material Symbols Rounded come from Google Fonts.
Azur Lane is developed by Manjuu and Yongshi and published by Yostar. This project is unofficial and not affiliated with any of them.
Faction audit
The ship database identifies factions by a numeric ID, and this app keeps only the IDs on its countable list, so collab ships are dropped before they can reach the picker. Because those IDs are not documented anywhere, the table below prints every ID actually found in the data with real ship names beside it. If a row's sample ships do not match its faction name, the label is wrong and can be fixed in NATIONS near the top of the script.
Prefixes are read from each record's own name rather than derived from the ID, so they stay correct even where a label here is not. Rows marked drop are excluded from fleet power: collab ships, and any faction ID not yet on the list.