Airship Guide

[Arcticharm]

Nyalia are you the one in charge of the spreadsheet?

If so, could you please leave my FCs Airships Voyager and Odysseus in the Public Sheet so i don't have to fill in the stats of my Airships all the time manually? XD
Just note something down like "data in Master Log" after you transfered it so i know if i can Paste a new line or just change the Log details after another trip ^^ Would really help save me some time, filling in 4 sector travels is enough atm xD

Can't you just copy paste from the master log to get the info back? We would have to add yet another column to denote that we've added the info to the master log which would be...annoying.

[Magistrella]

Can't you just copy paste from the master log to get the info back? We would have to add yet another column to denote that we've added the info to the master log which would be...annoying.

I could, if the Masterlog was kept in alphabetical order. At the top it all looks nice and clean but if you scroll down the mix of names becomes a mess. At the moment my Airships are at the bottom - but if more people dedicate it will vanish in the nirvana of neverland - and i do not plan to look for 4 Airships all the time once i unlocked them

[IrealiTY]

There is currently no way to add data to the spreadsheet? Tried to look in the past posts regarding this - not sure if it's closed now or not

[Aeyis]

I could, if the Masterlog was kept in alphabetical order. At the top it all looks nice and clean but if you scroll down the mix of names becomes a mess. At the moment my Airships are at the bottom - but if more people dedicate it will vanish in the nirvana of neverland - and i do not plan to look for 4 Airships all the time once i unlocked them

You can keep the airship list's stats updated and copy paste from there.

Also, please please use rightclick->"paste special"->"paste values only" to paste stuff you copy so I don't have to constantly redo the formatting.

Aha, so that's what it was. I always had to manually redo the formatting for the new cells when using normal copy-pasting.


Update: finally discovered some more sectors. 3 on one trip somehow. Dont ask, I dont know why or how!
Strangely, none of the sectors (14,15,16) showed up in the usual blue in the voyage log itself, only as system message.


Might be interesting to know tho: retrieval is only 58, and that gave me ''disappointing'' extraction yields for all but crystals (''sub-standard'' for those), which suggests that yield is dependant on the item (''lvl''?) and retrieval stats directly.

[Nyalia]

could you please leave my FCs Airships Voyager and Odysseus in the Public Sheet so i don't have to fill in the stats of my Airships all the time manually? XD

I'm not sure I understand. Why can't you select the ship stats in the master log, ctrl-c, go over to the public log, rightclick->paste values only? I don't see how it's more helpful to leave it in the public log, and I really don't want to leave it in the public log if I copy it over because I'm not the only person who copies things over to the master log. If I leave it there, it will almost certainly result in duplicate log entries. Especially since I won't remember what I've copied over and what I haven't, even ignoring that two other people sometimes help me out with that process (thanks, btw, Bonzai and Arctic! It's been really helpful).


EDIT: I really should read all new posts in a thread before commenting instead of replying after the first one <_< The ships are occasionally sorted into alphabetical order by ship (and within a ship, by rank, and if rank is the same, by entry order). I don't do it often because it crashes the sheet for me for a good while. I don't know what happens for other people, but I am mostly unable to access the sheet right afterward, and any changes I do make get reverted weirdly if I do get in during that time. I usually wait until there are a fair number of new log entries before doing it.

There's also ctrl-f.

However, thinking about it, there's an easier solution. I'm going to add a new set of columns to the airship roster for current ship stats. That list is sorted by server, and then by FC, and then by rank (descending), and then by ship name. That keeps an FCs ships all together, and lets you see more easily who else is active with airships on your server so you can arrange material trades if needed. Please use that for this purpose. Also, please please use rightclick->"paste special"->"paste values only" to paste stuff you copy so I don't have to constantly redo the formatting.

There is currently no way to add data to the spreadsheet? Tried to look in the past posts regarding this - not sure if it's closed now or not

Like Arctic said, put it in the public sheet and we'll move it over. This allows us to reformat everything before putting it into the list to keep the dynamic parts of the sheet working (and lets you guys not have to really care about spelling/plurals/capitalization/etc - we'll take care of it). Also, it makes the sheet more troll-resistant. A troll could still delete the roster, which would be annoying, but couldn't delete all of our data or my formulas. It also reduces the impact of people using ctrl-v instead of paste-values-only, because if that was done on the main sheet, I'd have to constantly redo the several dozen conditional formatting entries that colorize the lines based on the color chosen in the roster.

Also, if you see an error on a part of the sheet you cannot edit, or if you want to comment on something you cannot edit (or something you can edit), feel free to use the "Insert Comment" feature of Google Sheets. Rightclick, select "Insert Comment" and put in a comment. It'll send me an email about it, I'll go to the sheet when I have a second, and either fill in/change/correct the data, or reply, and when whatever it is has been resolved, I can click "Resolve" to make it go away.

[Arcticharm]

However, thinking about it, there's an easier solution. I'm going to add a new set of columns to the airship roster for current ship stats. That list is sorted by server, and then by FC, and then by rank (descending), and then by ship name. That keeps an FCs ships all together, and lets you see more easily who else is active with airships on your server so you can arrange material trades if needed. Please use that for this purpose. Also, please please use rightclick->"paste special"->"paste values only" to paste stuff you copy so I don't have to constantly redo the formatting.

See? I knew Nyalia would have some form of solution planned

[hqdm]

s16 - gatherer's grasp IV
s18 - deep green clusters

[IrealiTY]

Did anyone figure out a "BiS" for a lvl 50 Ship?

[Magistrella]

Did anyone figure out a "BiS" for a lvl 50 Ship?

Seein how far away the higher level sectors are it all depends what you want to do really. One Sector to unlock new stuff? Multiple Sectors? High Item gain?

Personally I was playing around with the builder and came out with Tatanora Hull - Enterprise Rigging - Odyssey Forecastle and Bronco Aftcastle

Stats: 126 Survey 62 Retrieval 98 Speed 132 Range 106 Favor

I went that way because even normal retrieval levels are bringing back nice amounts, high survey for multiple items, high range so i can visit 4-5 sectors and medium speed so it doesn't take longer then needed.

How it works out in the end - give me another 6 month and ill have a clear answer for you XD even now we don't know what most of the stats do :/

[IrealiTY]

Seein how far away the higher level sectors are it all depends what you want to do really. One Sector to unlock new stuff? Multiple Sectors? High Item gain?

Personally I was playing around with the builder and came out with Tatanora Hull - Enterprise Rigging - Odyssey Forecastle and Bronco Aftcastle

Stats: 126 Survey 62 Retrieval 98 Speed 132 Range 106 Favor

I went that way because even normal retrieval levels are bringing back nice amounts, high survey for multiple items, high range so i can visit 4-5 sectors and medium speed so it doesn't take longer then needed.

How it works out in the end - give me another 6 month and ill have a clear answer for you XD even now we don't know what most of the stats do :/

Thanks, I was thinking of making 1 ship with high speed, 1 with high retrieval etc one for each need basically, we miss only 4 sectors with our FC so'll just rely on RNG to open them up.