Airship Guide

[Nyalia]

is there already something existing like a route calculator?

i think about using tatanora for and aftcastle, but I only end up with 84 range and I would like to know whats possible with that setup c.c

There are also two in the Quick Reference spreadsheet:

- The "auto" one only works for up to three destinations, but will automatically calculate the shortest path. It does have a few bugs.** For sectors not currently in your trip, the distance shown is the distance it would cost to add in the shown sector to the most optimal point in the route. For sectors that are already selected, the distance shown is the distance that would be saved if you removed the sector from your route. Neither take the survey cost of 13 range into account. Sectors that cannot be added without causing you to exceed your range are highlighted in red, and that does take the survey cost of 13 into account.

- The "manual" one lets you specify the order you want to visit the sectors. You put numbers 1-5 to the left of the sector to specify the order you'll be visiting them. The distance numbers for ones not in your route are the cost of adding them to the end, not to the optimal point. The distance numbers for the ones that are in your route are still the amount of range you'll save by removing that point (excluding the survey cost).

The auto one is also in the master airship log spreadsheet. I haven't moved the manual one there yet.

The travel times used by all the above calculators show only estimated times. I do have the data to show exact travel times now (thanks, Faux!) but I haven't implemented it yet.


** I'm having a hard time writing shortest path algorithms with Google Sheets formulas - if someone can write one that works for up to 5 points without variables, subroutines, or recursion (or even proper array manipulation...), please let me know!




EDIT: In other news, my standalone Ship Builder Tool now includes an inventory where you can list all the parts you've built. It'll automatically tell you which ones are in ships (the ones currently set up in the builder tab) and which ones are unused. The last feature I want to implement is a pair of tabs where on one, you can put your desired "final four" ship designs, and on the other, it tells you what parts you'll eventually need to make to create those (and maybe what mats they'll take...)

[Magistrella]

Someone wrecked the Ship Builder in the spreadsheet (at least the dropdown selectors) - in all 4 of them... looks like they deleted 3 of the 4 rows

I copy pasted some dropdowns over but that doesnt work for all of it and since i have no clue of programming stuff like that :/ *sigh*


Edit: Found the culprit - it was deleted on the changelog entry: 18th September 6:14pm (UTC+2) x.x

[Airget]

Someone wrecked the Ship Builder in the spreadsheet (at least the dropdown selectors) - in all 4 of them... looks like they deleted 3 of the 4 rows

I copy pasted some dropdowns over but that doesnt work for all of it and since i have no clue of programming stuff like that :/ *sigh*


Edit: Found the culprit - it was deleted on the changelog entry: 18th September 6:14pm (UTC+2) x.x

Honestly I copied that once I saw it, so I do apologize if it's in bad taste to do that but since was using it for personal use I figured no harm, I wasn't going to take any credit for the awesome work.

With that in mind I made more copies of the one I copied:

View Only:
https://docs.google.com/spreadsheets...it?usp=sharing

With that one if you "Make a copy" for yourself you should be able to edit the new one, however if you can't.

https://docs.google.com/spreadsheets...it?usp=sharing

That's one you can edit, lemme know if it works, it should. I just personally made a backup for myself cause it was so well made I didn't want to see it get destroyed lol.

[Arcticharm]

Someone wrecked the Ship Builder in the spreadsheet (at least the dropdown selectors) - in all 4 of them... looks like they deleted 3 of the 4 rows

I fixed the spreadsheet now I think! Please check it out and let me know if it's working for you.

In other news, please don't copy + paste anything, there's some very specific formulas written to call over the correct data from the other sheets and they can be cell specific. To create the dropdowns a data validation tool has to be created to properly call out the information that is being sorted and used. Thank goodness Nyalia is a spreadsheet wizard (amazing foresight with formula design); otherwise I'm not sure my minor fix would have corrected the whole thing.

[Nyalia]

Arctic fixed most of it, I fixed the formatting and the one broken formula he missed. If you notice something broken, use the Insert Comment feature to let me know. That'll send me an email about it.

[Nyalia]

I haven't done the calculations yet, but it always seemed to me that the later sectors have a better chance at rarer items than the earlier ones, and that you got more items from later sectors than earlier ones. Far Eastern Coins are found in a really early sector, and a rather late-game sector, so it's not surprising they're pretty rare. They also don't drop from the endgame sectors (17-22), only iron giant cores and toy box schemas drop in those.

[ServerCollaps]

I've 3 lvl 50 airships now which made 100+ flights together and I got 2 rare items during all these flights... 1 time the toy box crap and 1 time the mog stuff

I would call the "rare" suff rare :s

[Nyalia]

I've 3 lvl 50 airships now which made 100+ flights together and I got 2 rare items during all these flights... 1 time the toy box crap and 1 time the mog stuff

I would call the "rare" suff rare :s

Whereas I'm running a 50, 42, 18, and 8 and have gotten 3x Iron Giant Cores, 5x Shrub Seedlings, 20x Toy Box Schema, 10x Fine Alumen, and 4x Dusk Leather if that counts. The only item we haven't gotten is the Far Eastern Coins. Sure, the rare items aren't common, but they're not as rare as rare minions, I don't think.

[Nyalia]

Okay, according to our data, the super rare items have an observed drop rate of 1% in 1* sectors, 2.5% in 2* sectors, 3.5% in 3* and 4* sectors, and 4.5% in 5* sectors. Overall, the drop rate is ~2.3%. This is ignoring other factors, such as ship stats. The total sample size for the data is 3,000 item retrievals, but the data clusters at the start, so the data for the later areas is less good.

Observed drop rates:

	Schmtc / Spcl	FC Craft Mat	Unique Craf Mat	Gen Craft Mat	Materia		Crystal		Total
	-------------	------------	---------------	-------------	-------		-------		-----
 All	783 (26.6%)	741 (25.2%)	67 (2.3%)	212 (7.2%)	481 (16.3%)	659 (22.4%)	2943
-----	-------------	------------	---------------	-------------	-------		-------		-----
01-16	753 (26.9%)	693 (24.7%)	61 (2.2%)	200 (7.1%)	437 (15.6%)	659 (23.5%)	2803
17-22	30 (21.4%)	48 (34.3%)	6 (4.3%)	12 (8.6%)	44 (31.4%)	0 (0.0%)	140
-----	-------------	------------	---------------	-------------	-------		-------		-----
01-05	291 (24.8%)	312 (26.6%)	13 (1.1%)	75 (6.4%)	174 (14.8%)	308 (26.3%)	1173
06-08	201 (28.4%)	166 (23.5%)	18 (2.5%)	43 (6.1%)	112 (15.8%)	167 (23.6%)	707
09-11	156 (28.5%)	126 (23.0%)	19 (3.5%)	43 (7.8%)	82 (15.0%)	122 (22.3%)	548
12-14	73 (26.3%)	67 (24.1%)	10 (3.6%)	23 (8.3%)	52 (18.7%)	53 (19.1%)	278
15-16	32 (33.0%)	22 (22.7%)	1 (1.0%)	16 (16.5%)	17 (17.5%)	9 (9.3%)	97
17-22	30 (21.4%)	48 (34.3%)	6 (4.3%)	12 (8.6%)	44 (31.4%)	0 (0.0%)	140

[jnseagul]

I suppose I may just getting lucky with my explorations, but ever since I added the Tatanora aft or forecastle to my 2 lvl 50 airships, I've seemingly been bringing back a lot of the rarer items. It'll be interesting to see how favor, retrieval and/or surveillance correlate with the rare item return, both in rate and in number.