Airship Guide

[mcspamm]

In case someone hasn't mentioned this yet, experience needed from rank 35 -> 36 is 295,384.



EDIT:
In the Airship Logs spreadsheet, under the Ship Builder tab, the formulas for the Forecastle are wrong (currently show the stats for the same tier as whichever Aftcastle is selected).

The Forecastle column formula should be:

=iferror(index(filter('Ship Parts'!$D$2:$I,'Ship Parts'!$A$2:$A=E$3,'Ship Parts'!$B$2:$B=E$2),1,row($B6)-row($B$5)),0)

instead of:

=iferror(index(filter('Ship Parts'!$D$2:$I,'Ship Parts'!$A$2:$A=F$3,'Ship Parts'!$B$2:$B=E$2),1,row($B6)-row($B$5)),0)

Also, the Build Points formula in G3 needs updating as well.

=concatenate(sum(iferror(index(filter('Ship Parts'!D2:D,'Ship Parts'!A2:A=C3,'Ship Parts'!B2:B=C2),1,1),0),iferror(index(filter('Ship Parts'!D2:D,'Ship Parts'!A2:A=D3,'Ship Parts'!B2:B=D2),1,1),0),iferror(index(filter('Ship Parts'!D2:D,'Ship Parts'!A2:A=F3,'Ship Parts'!B2:B=E2),1,1),0),iferror(index(filter('Ship Parts'!D2:D,'Ship Parts'!A2:A=F3,'Ship Parts'!B2:B=F2),1,1),0))," / ",11+B3)

Should be:

=concatenate(sum(iferror(index(filter('Ship Parts'!D2:D,'Ship Parts'!A2:A=C3,'Ship Parts'!B2:B=C2),1,1),0),iferror(index(filter('Ship Parts'!D2:D,'Ship Parts'!A2:A=D3,'Ship Parts'!B2:B=D2),1,1),0),iferror(index(filter('Ship Parts'!D2:D,'Ship Parts'!A2:A=E3,'Ship Parts'!B2:B=E2),1,1),0),iferror(index(filter('Ship Parts'!D2:D,'Ship Parts'!A2:A=F3,'Ship Parts'!B2:B=F2),1,1),0))," / ",11+B3)

[Nyalia]

In the Airship Logs spreadsheet, under the Ship Builder tab, the formulas for the Forecastle are wrong (currently show the stats for the same tier as whichever Aftcastle is selected).

Oops! Thanks, fixed.


EDIT: Actually, looking at it, all references to E3 were replaced by F3, and the formatting for E3 is incorrect and it has F3's formatting instead. I think someone used cut/paste in a way that messed up the formulas... Please don't use ctrl-v/ctrl-x in the spreadsheet. Instead, rightclick and choose "paste special -> paste values only" if you want to copy/paste... Otherwise stuff like this happens because Google is helpful.

EDIT2: Yeah, that's definitely what happened. The conditional formatting was also messed up, as was the "rank too low" formula that's hidden from view and which was definitely working before...

[Eldeniel]

So now, our aircraft is rank 30, so we sent him to sector 11, 5 and 4 but still no sign of sector 7 for us :/