Hey Enseric, could you add this data to the spreadsheet or include pics of the whole entry so we can add it? :) Please and Thank you!
Printable View
I've added an "items reported elsewhere" column to the sector list. Nothing references it though, it's just there for reference. I'll make it publicly editable.
For those who are using the sheet to record voyages - please don't forget to include the rating for your final sector! A few people have been forgetting to do so. I can use their exp totals to deduce what their rating had to have been, but it's still nice not to have to.
EDIT: I have now made the spreadsheet, at least for now, highlight sectors that do not have a rating entered. It's the most commonly missed piece of information. I will not be copying over logs that lack ratings to the master log until they're added - the ratings are important for determining what actually influences your rating. Since rating has a huge impact on experience, that information would be very good to figure out, and it's hard to mine out that data with incomplete logs.
This was a triumph.
I'm making a note here:
HUGE SUCCESS.
It's hard to overstate my satisfaction.
Airship Guide Forums.
We do what we must because we can.
For the good of all of us
Except the ones who are dead.
But there's no sense crying over every mistake.
You just keep on trying till you run out of cake.
And the science gets done and you make a neat ship.
For the people who are still alive.
I'm not even angry.
I'm being so sincere right now.
Even though you broke my heart and killed me.
And tore me to pieces.
And threw every piece into a fire.
As they burned it hurt because
I was so happy for you!
Now these points of data make a beautiful line.
And we're out of beta, we're releasing on time.
So I'm GLaD I got burned.
Think of all the things we learned
For the people who are still alive.
Go ahead and leave me.
I think I prefer to stay inside.
Maybe you'll find someone else to help you.
Maybe Bluegartr...
THAT WAS A JOKE. Haha. FATCAT.
Anyway, this cake is great.
It's so delicious and moist.
Look at me still talking when there's science to do.
When I look out there it makes me GLaD I'm not you.
I've experiments to run there is research to be done
On the people who are still alive
And believe me I am still alive.
I'm doing science and I'm still alive.
I feel FANTASTIC and I'm still alive.
While you're dying I'll be still alive.
And when you're dead I will be still alive.
Still alive
Still alive
These are edited lyrics of Still Alive by Jonathan Coulton :D
Waiting for airships to return is hard guys...
On the spreadsheet, if there are any errors in the Master Voyage Log (such as your ship's name being missing), please right-click on the incorrect cell, click "insert comment," and leave a comment for me. I (or Arcticharm) will correct the error, then clear the comment. Also do this if there is an error on any other page, such as the unlock conditions on the sector list tab.
Thank you to everyone who is donating data! The database is coming along nicely. :)
I can confirm Gold Ore from Sector 8!
http://i25.photobucket.com/albums/c7...ight%20log.png
Went there with:
Enterprise - Hull and Fore
Invincible - Rigging and Aft
Heading into Sector 9 at rank 25 with Enterprise Hull, Fore, and Rigging, and unlocked sector 10 which requires rank 27 to visit. I'll let you know what we find!
Bad news...
Ship returned from 6->5->2 with A rating and bonus in every sector(6 =150%, 5= 50%,2 = 100%) but neighter 11 or 7 was found. :/
Sector 5 where i expected a discovery, got bonus but rating was abysmal with replacement of parts recommended message...
So the "You need bonus to find new sectors" theorie seems to be busted... or there are other requirements, like minimum ship level/grade of parts, too. :(
I started a new try with full invincible build to see if there is a different result.
Hello,
I added some comments to the sheet "Ship Parts" as I couldn't edit it directly.
I only added the comments to the hull section, but the numbers are the same for the 3 other sections as well.
And incase anyone wants to know it, the repair costs/amounts of repair kits needed per ship part, are linear from Bronco 1 to Tatanora 6.
We discovered sector 11 today, but it did not show it in the voyage log about unlocking a sector. Anyone else had this bug?
Edit: Craftman's command materia III drop from sector 3.
Sorry to hear that! We personally had the same result last night, we had sent out to only sector 5 to try to discover 7 but were unsuccessful. We got a substandard rating which I think I’ve seen other people get AND still discover areas. Upon closer review the line about violent turbulence says “Airship surveillance levels unaffected, but EXPLORATORY CAPABILITIES may be significantly hindered.” so maybe that has something to do with it. We sent it back out on the route to 5 -> 6 so I'll know some more this evening. We haven't been able to complete our invincible forecastle yet but I'm thinking that we might need to lean hard on it and get it done just to advance :-/ Banzai, we may have found one of the walls :p Will keep updating with findings.
Looking at the spreadsheet, it appears that all entries that have found new sectors (so far) have mostly had satisfactory end results(except possibly line 5) from the Sector of interest AND have seen violent and high winds, with high winds being the 2nd entry before discovery of the new sector, so perhaps slight hindrance still allows for discovery of new sectors while significant hindrance does not?
Thanks for the numbers, I’ve edited it now! The airship builder portion of the sheet is now complete!
Strange bug, have you gone back and checked the log again? Can you take a screenshot of the log AND the airship map?
The spreadsheet is designed to automatically compile the items list vs the sectors based off the master log, so if you have the entry and it’s put over into the master log, it’ll show up on the items.
Thank you! :)
That's awesome XD I know I forgot to enter mine once but I caught it.
Can't fully describe how awesome that was XD
I was starting to get curious about the theory too, the first few data points seemed to suggest there was some promise. Since then I've also found some disconfirming data as well. It was a good theory! We've been able to conclude that proximity is important. Beyond that, my best guess is that Forecastle improves the odds of finding a new sector, as we've been speculating about for some time now. We've had at least one person say they got as high as sector 6 on just the bronco forecastle but there might still be some RNG too it.
This is a message you got in your flight log? :O I hadn't seen that yet, can you do a screenshot?
At the very least it is consistent with reports! Seems worthwhile to keep recommending the forecastle upgrade then for unlocking sectors, although keep us updated! \o/
As for the wind conditions, you raise another really interesting theory, lets keep an eye on the data!
That trip of mine to sector 05, unlocking 06, is really working against the turbulence theory. I had violent turbulence, but still found 06 on my first attempt.
What I think will really help crack the unlock conditions is to include a new column in the spreadsheet where people can list what sectors they have already discovered. Just don't list 01 and 02 - we start with those unlocked, so those aren't interesting. (Err, you do start with 02 unlocked, right? <_< I didn't send our ship out the first time, so I just realized I'm not actually sure about that!) Please either fill this new column out completely or leave it blank - don't put in some sectors but not others, it'll skew the data. With this extra information, we should be able to tell if RNG is involved, or if it's just a function of surveillance, rating, and/or wind.
I'm thinking that you found it on the 2nd attempt in that sector. You had violent wind for the first try but then only had high wind for the 2nd item and you ended the sector with a satisfactory rating. It's only a theory of course so if we find some good data against it, I'm all for scratching it off the list. (I'm assuming we're both talking about line 37 of the master log). Let me know if I'm wrong on that assumption.
I'll add the sectors we have unlocked to the sheet :)
Having some way to know which reports had the potential to unlock a sector is important, but I'm wondering if listing all previously unlocked sectors will get a tad unwieldy (especially as we unlock more sectors). I've been trying to indicate in my own reports which trips actually had a potential to unlock a sector.
It might also be inferred using the name of the ship, if they've kept a steady log and reported their sectors previously unlocked. I suppose we could just include the steady reporters in the sector unlock analysis. But you are the spreadsheet wizard, this is your call!
Well I've been able to reproduce the bug that someone reported where the name of the sector discovered is one thing before finalizing the report and another thing after finalizing :D
Before:
http://i.imgur.com/xHRNLQE.png
After:
http://i.imgur.com/M8u3Bux.png
It is worth noting that it IS possible to unlock sector 05 from this sector (02), it just didn't happen on this trip! I'm starting to think the Mammet isn't qualified to be writing these reports :D
Now to see if the SE staffers are reading our guide/forums XD
Of note, you discovered a new sector with a substandard rating. What was the wind JUST before it?
This might be a good time to mention best practice to screen capture logs on the front of the guide...
Complete last trip: Album
Picture with messageReplacement of parts recommended
Exploration of sea of clouds - sector 5 finished. Performance of the airship was rated as insufficient/ unsatisfactory. The the replacement of airship parts is recommended.
But it seems its just a normal rating in german, i got this sometimes at the beginning.
This are the german rating texts i got so far:
worst -> best
Unersuchung von Zielort <Destination> mit äußerst wenig zufriedenstellender Leistung abgeschlossen (0%)
Unersuchung von Zielort <Destination> abgeschlossen. Die Leistung des Luftschiffs wurde als nicht ausreichend bewertet. Der Austausch von Bauteilen empfiehlt sich(50%)
Untersuchung von Zielort <Destination> abgeschlossen. Die Leistung des Luftschiffs wurde als zufriedenstellend bewertet. (100%)
Untersuchung von Zielort <Destination> abgeschlossen. Die Leistung des Luftschiffs wurde als gut bewertet. (150%)
Just to take pictures of the log to refer back to or provide for additional analysis. You already mention the glitch on the front page so we should be ok there. I didn't think to take screen shots till after people started posting them here and in hindsight I wish I had. It would be great to get before and after pics of the log like you did proving that the glitch is real.
It looks like the Rubber Ducky disproved my wind theory :O
ship looks like it got turbulent wind twice in a row and STILL managed to discover SC08. It might just be left to RNGesus
It seems sector ratings are not as straightforward as I first proposed. I had pretty much been thinking of them as an "average" of your retrieval ratings. However, here is one case where there was a satisfactory rating (+100%) from two Normal retrieval results.
There is something else in these screenshots that is significant, I had seen it a couple times before this as well. For the deep red crystals instead of the standard "High-quality deep red crystals discovered" it says "Several high-quality deep red crystals discovered." And instead of the usual 2-3 crystals I retrieved 11 of them and they were HQ. This seems to be an upgraded version of "High-quality" retrieval. Whenever I have seen this, the items were actually HQ.
It may also account for the higher sector performance rating.
Edit: Well I have found another case where I got the "Several High-quality" message but an abysmal rating....
I think RNGesus plays a role but Forecastle gives him extra reason to bless you =) She had been to sector 7 twice before:
- Rank 17 with 76 Surveillance (Invincible forecastle)
- Rank 20 with 62 Surveillance (Bronco forecastle, had downgraded to make room for another enterprise part)
- Rank 22 (found it) with 76 Surveillance (Invincible forecastle re-attached)
I haven't read the last couple of pages of posts, but I just had an expedition come back with some interesting results. I've entered it on the spreadsheet; some highlights that you can see on the spreadsheet:
Two new sectors unlocked. In sector 07, rating was Abysmal, and weather was Turbulence; despite this, sector 10 was unlocked. In sector 08, conditions were more favorable and sector 09 was unlocked.
We collected two items from every sector, which is quite extraordinary for this airship. What changed? We replaced the Bronco hull and aftcastle with Invincible hull and Enterprise Aftcastle, reducing Surveillance and Favor.
A very interesting point that's not reflected in the spreadsheet concerns the repair condition of the parts. Hull and Rigging began the journey at 11% and 20% respectively, while the Fore- and Aftcastles started at 100%. The latter two ended at 76%, while the former ended at 0%.
The conclusions this experience seems to suggest (obviously, more data points are required to have any real confidence):
- Performance and weather in a sector do not determine discovery of new sectors.
- Simple airship part grade (minimum? average?) is the primary factor in obtaining a second item in a sector.
- Repair condition does not affect your chances of obtaining a second item.
- There's no point in repairing your parts before they hit 0%.
If I recall correctly, you already had an enterprise forecastle, is that right? So it still doesn't quite go against the popular notion that the forecastle is important.
If simply the overall grade of your parts is a factor (in either the sector unlock or the 2nd item question)... well that would be fairly convoluted, I would hope SE wouldn't make it so weird to have a "hidden" stat like this. XD Still, lets keep it on the list of hypotheses to test when we have enough data! I think it still is reasonable to think that RNG plays some role in addition to whatever else, so that might also explain your results.
Once we have a sector with enough data points, and enough people who have various levels of forecastle, we can test the "surveillance improves the odds of finding a 2nd item" hypothesis! \o/
Doing this is totally fine. You can even do just "3-9,11" if you want. In any case, I'll expand it on the master sheet for consistency so it's easier to compare, but don't mind doing that at all.
On the master sheet, I've started using "____" to space out gaps where unfound sectors are in the sequence. I feel this makes it easier to notice who is missing what when looking through where they've been.
So far, looking at the data we have, there does appear to be RNG involved with unlocking things, unfortunately. It's a bit hard to tell if higher surveillance helps, or a higher rating, or a certain wind value (though wind really doesn't seem to matter given how many unlocks were double turbulence), or a better overall rating. Comparing a trip where I found sector 06 and one where I didn't (which I totally forgot about when I made that comment about finding it first try!), very little was different. The only notable difference was I had more range.
It's clear though that there's a specific sector that you have to go to in order to unlock a given sector. 07 always unlocks from 05. 08 always unlocks from 07. And so on.
Also, I've added an Airship Roster to the spreadsheet, just because. Feel free to list your airship there! If you choose a log color from the Log Color dropdown menu, all of your log entries in the Master List will be highlighted in that color. This will hopefully make it easier to see which logs go together when we're comparing them. If any supported color combos hurt your eyes, let me know and I'll edit them.
I'm glad we've at least been able to narrow it down to that! It is really tempting to think after an adjustment is made and a sector is unlocked that the adjustment was the necessary factor (post hoc, ergo proctor hoc). It will probably be a little while before we have enough data to say more confidently one way or the other.
The Champagne Supernova! will try to get as far as it can without upgrading parts. \o/ The SS Flying Squirrel also went really far without upgrading Forecastle so that will be some interesting data too.
Entered, that is a nifty feature!
Unlocking sector 10
It looks like, from glancing over the log, all the people who have unlocked sector 10 have an enterprise forecastle at least. We just sent out the Ducky to sector 07 with an enterprise forecastle newly attached, so I'll let you know what she finds! Before that she had visited sector 07 quite a few times without an unlock.
If this trend for sector 10 continues, perhaps that is where I will start recommending the Enterprise forecastle.
Update: The Ducky is back and has unlocked sector 10! Seems like more support for the Forecastle theory ;)
I'm starting to wonder if perhaps the ''Airship condition found insufficient for further exploration'' is related to rank (or rank + other factors)
It would appear otherwise. First enterprise part the Elite had was the forecastle, but still missing both sector 9 and sector 10.
For anyone with those 2 sectors unlocked:
How much range is there between SC07-SC10 and SC08-SC09?
In other words, the range between the new sectors and the ones you discovered them from. With/without including survey time in the new sector.
A little late, but last night we did manage to find SC07 after our third or 4th trip to SC05. We were running invincible hull and propellers with bronco aft and forecastle (survey @70). I took screenshots of the log after finalizing it the first time and when I went back to look I don't see the messages about finding sector 7 at all in the Voyage log (there is something in my chat log) but I kind of remember it being there when I first looked at it like I've seen in some other screenshots.
http://imgur.com/a/4PB6N
Damn! Every time it looks like we may have figured this question out we get some disconfirming report! :P
I'm not entirely convinced rank isn't a factor as well. It is the one confounding factor in every observation reported! We have had people be fairly high rank and not find sectors. But it could just as easily be Rank + RNG as Forecastle + RNG. It could also be Rank + Forecastle + RNG. And if it is... we have virtually no hope of know that for sure. Each factor you add increases the sample size necessary to give you adequate statistical power to reject the null. Can anyone do a bayesian analaysis? :P Anyway, it will still be fun trying to figure it out!
When I have an airship back in the workshop I'll try to get you some numbers for range, if someone hasn't already.
Thanks for the report! It looks like you were Rank 21, so it might be that your rank stat finally pulled it's weight. Or it may just be RNG, given enough attempts even a lower probability will succeed.
Speculating more, it isn't at all unusual for SE to use base level as a factor in stats formulas. In crafting, the most important "stat" that people never talk about is your level relative to the recipe level. Even someone with high stats will have some difficulty attempting recipes 2-3 levels above their own. And even someone with low stats should have a much simpler time when doing recipes 2-3 levels below. With crafting the contribution of class level relative to recipe level is nonlinear as well, so that would also complicate a statistical analysis.
Trip 5->6->3
Found 11 after transfer from 6 to 3 (bonus), didn't found 7 (no bonus)...
Need to lookup in the collected data so far if we have a discovery without any bonus yet... i don't want to throw the bonus thesis out of the window after that result but its linked to the forecastle/surveillance.
Our Airship returned from a 10>7>8>9 trip with a double S (SS) rating, made about 1,000,000 exp during this.
+200% EXP bonus on most stops. Also brought 7 Mogcrowns together with Raw Celestine and a shitload of different tier III materias.
Currently rank 36 with full Enterprise parts.
200% bonus says "... performance rated as outstanding"
It's possible that if you want to test this someone willing to hold off possibly discovering higher level sectors could in fact send their 2nd ship (rank 1) with bronco parts to try to find sectors. Here you could potentially see if rank is a factor though it may not be fully independent of the stats.
My current hypothesis is that in order to discover a new sector you need to have enough range left over to ''reach'' it from the sector you discover it from. This would explain why I failed to discover it so far since I had been using pretty much the max the Elite's range to visit 4x sectors.
Send it out for only sector's 7 and 8 now, will be back tomorrow.
Very unlucky, we've finally unlocked the sector 8, while our airship was rank 26 and equipped with invincible parts for many visits around the sector 7 (and 6 and 5).
Tired of waiting, we've sent our airship to the sector 7 alone, and that's when we've finally been blessed by the new discovery.
Also, the voyage log shows that we've unlocked the sector 10, while the chat log says "sector 8 has been discovered" (and it indeed has been as we've sent the airship there).
http://i.imgur.com/KVTsM7K.png
http://i.imgur.com/w2fsMhm.png
http://i.imgur.com/NnSCkvG.png
That sounds like a really lucky trip!
It would be nice to do something like this, but unfortunately we can't send a rank 1 airship to some of these unlocking sectors because there is a minimum rank requirement.
That is an interesting angle, keep us updated!
Congrats! I think the solo visit made sense simply on the basis of time, as you mentioned. But it also fits with what Aeyis was thinking too. I posted a bug report about the flight logs, hopefully it catches some attention ;)
I have my own sector unlocking anecdote to add to the pile, another one which downplays the role of surveillance. My experimental airship the Champagne Supernova! has just found sector 5 on the third visit to sector 2. It is using all bronco parts and was only rank 5 when it left the workshop. I'll keep trying to get as far as I can without upgrading anything to see how important that really is!