Page 4 of 143 FirstFirst ... 2 3 4 5 6 14 54 104 ... LastLast
Results 31 to 40 of 1495

Thread: Airship Guide

Hybrid View

  1. #1
    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

  2. #2
    Player
    Nyalia's Avatar
    Join Date
    Jun 2014
    Location
    Gridania
    Posts
    1,683
    Character
    Neri Feralheart
    World
    Faerie
    Main Class
    Paladin Lv 90
    Quote Originally Posted by mcspamm View Post
    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...
    (0)
    Last edited by Nyalia; 08-05-2015 at 02:38 AM.

  3. #3
    Player
    Eldeniel's Avatar
    Join Date
    Aug 2013
    Posts
    97
    Character
    Meldan Loredon
    World
    Ragnarok
    Main Class
    Marauder Lv 70
    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 :/
    (0)

  4. #4
    Player
    MysticSpirit's Avatar
    Join Date
    Jul 2015
    Posts
    44
    Character
    Mystic Spirit
    World
    Phoenix
    Main Class
    White Mage Lv 80
    It is possible to obtain the same item twice from the same sector on the same voyage. We found 11 Red Clay and then 7 Red Clay in sector 7. We discorvered both sector 8 and sector 13, after 3 weeks of searching for sector 8 (airship at rank 34 and full enterprise). Unlocked tier 5 airship parts (Odyssey) aswell. That is what I call a comeback
    (0)
    Last edited by MysticSpirit; 08-04-2015 at 08:57 PM.

  5. #5
    Player
    Oldwolf's Avatar
    Join Date
    Aug 2013
    Posts
    34
    Character
    Old Wolf
    World
    Tonberry
    Main Class
    Archer Lv 60

    Sector 19

    2 pieces of Dusk Leather from a trip to this spot.

    Awesome and helpful guide! Thanks for doing this.

    Wolfy
    (0)

  6. #6
    Player
    MysticSpirit's Avatar
    Join Date
    Jul 2015
    Posts
    44
    Character
    Mystic Spirit
    World
    Phoenix
    Main Class
    White Mage Lv 80
    So today we obtained S rating from sector 17 and got 15 Toy Box Schema (optimal retrieval) and 7 HQ Red Cluster (several high level retrieval). I might think the retrieval level in logs (normal, sub-normal, high, optimal) have something to do with Rating and exp bonus. I have seen it clearly from our last 20 or so airship voyage.
    (0)
    Last edited by MysticSpirit; 09-13-2015 at 05:20 PM.

  7. #7
    Player
    Bellandy's Avatar
    Join Date
    Sep 2013
    Posts
    154
    Character
    Bellandy Illyan
    World
    Phoenix
    Main Class
    Astrologian Lv 60
    Has anyone tried to calculate how "rare" the rare items are for each sector? It looks like on Phoenix, a total of 4 Far eastern coins were found since HW launch... the drop rate seems abysmal. Are we just unlucky?
    (0)

    http://eq.guildwork.com/

  8. #8
    Player
    jnseagul's Avatar
    Join Date
    Aug 2013
    Posts
    16
    Character
    Katya Threadbare
    World
    Diabolos
    Main Class
    Conjurer Lv 60
    Quote Originally Posted by Bellandy View Post
    Has anyone tried to calculate how "rare" the rare items are for each sector? It looks like on Phoenix, a total of 4 Far eastern coins were found since HW launch... the drop rate seems abysmal. Are we just unlucky?
    In my last 2 voyages I've gotten a total of 14 Far Eastern Coins (7 each time) from Sector 16, so I think you're just getting unlucky. My airship build, FYI, was Invincible Hull, Enterprise Rigging, Invincible-II Forecastle, Tatanora Aftcastle.
    (0)

  9. #9
    Player
    Avotas's Avatar
    Join Date
    Jul 2015
    Posts
    6
    Character
    Avotas Felious
    World
    Famfrit
    Main Class
    Botanist Lv 60

    Conditions!

    Sea of Clouds - Sector 17, 18, 19 - Requires Surveillance Level 90

    We lost our omni crafter, so we been a bit behind on airship parts. I just ran into this today.
    (0)

  10. #10
    Player
    LillithCale's Avatar
    Join Date
    Jul 2014
    Posts
    319
    Character
    Lillith Cale
    World
    Balmung
    Main Class
    Archer Lv 80
    I have two quick questions and this was the best place I could think we ask.

    --If we already have 22 and 21 unlocked, do we have to visit them to unlock hard, or will it already be unlocked?

    --Can we do exploratory voyages and exploratory missions at the same time? I haven't had time to poke around on anything in game to find out if this is possible or not.


    Also: Received 4 wind silk from Sector 17. No idea what they are used for yet. http://imgur.com/2s6AXds
    (0)
    Last edited by LillithCale; 11-10-2015 at 09:53 PM. Reason: image

Page 4 of 143 FirstFirst ... 2 3 4 5 6 14 54 104 ... LastLast

Tags for this Thread