Results -9 to 0 of 1492

Thread: Airship Guide

Threaded View

  1. #11
    Player
    mcspamm's Avatar
    Join Date
    Apr 2015
    Posts
    99
    Character
    Sophi Wynne
    World
    Malboro
    Main Class
    Marauder Lv 70
    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:
    Code:
    =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:
    Code:
    =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.
    Code:
    =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:
    Code:
    =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)
    (1)
    Last edited by mcspamm; 08-04-2015 at 05:57 AM. Reason: Formatting

Tags for this Thread