Airship Guide

[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

[Arcticharm]

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

I think that Nyalia has occasionally been going in and sorting so that the ships align themselves but with so many entries so quickly it becomes tough. You can always do a cntl+F to find your ship name and go from there or maybe just keep a small sheet with your ship stats that you can copy paste from? Maybe Nyalia has a better solution for sheets that I'm unaware of

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

Data can be added to the public sheet, only a few of us that have requested access can move the data from public to the master sheet.

[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

[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]

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

Yeah... I really wish I could just lock the formatting, then no one would have to worry about it. But, really, Google's just trying to be helpful!

[Magistrella]

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

What he meant was:

Google removed your document from the public - i.e. too much traffic from public users so only people that are linked to the document can edit at the moment. The rest just get's a readable version where nothing can be changed.

And yes, those stat colums would help a lot ;3 Just gotta look for the color of my Airships and its an easy scrollthrought to get to them ^^
When the document is available... again ><

if you trust me enough to add me to the sheet: forumname at gmail dot com

Gotta love it that theres no PM function in these forums -.-

[Nyalia]

Google removed your document from the public - i.e. too much traffic from public users so only people that are linked to the document can edit at the moment. The rest just get's a readable version where nothing can be changed.

Oh! Sorry, hadn't realized that had happened. If this continues being a problem, I'll create a secondary back-up sheet with the a copy of the public log tab so people can still enter logs while unable to edit the main sheet. If I do that, I'll add a link to the cover page.

EDIT: Also, access is present, though it could be sporadic. Anonymous users are still making edits, the last one being made just eight minutes ago.

[IrealiTY]

What he meant was:

Google removed your document from the public - i.e. too much traffic from public users so only people that are linked to the document can edit at the moment. The rest just get's a readable version where nothing can be changed.

And yes, those stat colums would help a lot ;3 Just gotta look for the color of my Airships and its an easy scrollthrought to get to them ^^
When the document is available... again ><

if you trust me enough to add me to the sheet: forumname at gmail dot com

Gotta love it that theres no PM function in these forums -.-

I'll make a new sheet and send you an invite, will notify you via PM