Submersible Information Thread

[Darker_Midnight]

North isle of Zozonan, Savage Aim materia VI acquired with CCSyC

[Fireye]

All subs are CUSyC

Stop #1 (Southern Charnel Trench)
Crimson Coral (Sub1)
20 Manasilver Sand HQ (Sub2)
23 Manasilver Sand NQ (Sub3)

Stop#2 (Sea of Ash 1)
24 White Oak Logs HQ (Sub1)
38 Fire Crystals (Sub2)
Teak Log HQ (Sub3)

Stop#3 (North Isle of Zozonan)
Heavens' Eye Materia VII (Sub1)
24 Adamantite Ore NQ (Sub2)
20 Truegold Sand HQ (Sub3)

Stop#4 (Sea of Ash 2)
28 Cassia Logs NQ (Sub1)
23 White Ash Logs HQ (Sub2)
4 Astral Moraine NQ (Sub3)

Sub1 Image
Sub2 Image
Sub3 Image

[Tyark]

CCSyC

Sea of Ash 2: Sandteak Log x24 NQ
SCT: Mythrite Sand x21 NQ

[StouterTaru]

I've updated my Excel Voyage planner for 5.05. Html version to be completed when I have more patience

Submersible route planner (Excel)

• 1st Sheet (Path) - Requires download and enabling macros to be useful. You select up to 5 destinations, and it shows you the shortest range needed.
  
• 2nd Sheet (Builds) - Every possible build, filterable and sortable. Click the filter and sort in the header row to filter out builds that don't have enough range for your route, and sort speed or surveillance from high to low. Will show a voyage time for the route selected on the Path sheet.
  
• 3rd Sheet (Parts) - The various sub parts, there for formulas. You can use the "Include" column to remove parts you don't have from the possible builds on the Builds sheet.

[AuricSeagard]

Thanks for the spreadsheet StouterTaru! I was starting to tinker with one myself but you saved me a lot of time and effort. Can I link the sheet on the Sub Discord?

[StouterTaru]

Thanks for the spreadsheet StouterTaru! I was starting to tinker with one myself but you saved me a lot of time and effort. Can I link the sheet on the Sub Discord?

Feel free to link it, but the link to the file changes occasionally. I keep the link updated on a separate thread here:
http://forum.square-enix.com/ffxiv/t...17#post4693617

If you want to make a better spreadsheet, I can explain the raw data I used.

[AlexanderBlackiris]

Can you share the link to this sub discord?

[AuricSeagard]

Sure. Sub builders Discord is at:

https://discord.gg/wEqTEHA

[AuricSeagard]

I don't think I could make a better sheet, you're using some formulas I'm not familiar with. I linked both the sheet and the update thread over on the Discord, thanks!

[Fate_Testarossa]

Abroader Otter from Sea of Ash 2.
180 Surveillance, 93 Favor on the Submarine.