Recent S3 map runners?

[Navigata07]

There is so much data here. If I feel like taking on a task, I may pull all this data and plot it in excel...bonus stack (expected percentage) vs actual percent. Think we have enough sample points to do so.

 

[Navigata07]

I have decided to take on the task. There is a lot of data here, so I will be slowly adding each data point over the next few weeks into one big spreadsheet and plotting the result. I'm making the spreadsheet and will begin adding data at some point this week. No promises that I will see it through, but I will do my best.

 

[Navigata07]

Page 1 Data entered (done for bookkeeping purposes)

 

[Navigata07]

Page 2 complete

 

[Navigata07]

3 Pages entered, with a total of 54 points so far (the first 31 points before the current bonus structure was put in place, and most likely wont be included in the plot)

 

[Navigata07]

Page 4 complete

 

[Navigata07]

Page 6 complete

 

[Madge59230]

Page 6 complete

You going to post after every page? Trying catch up no. 1 poster of the month!!

 

[Navigata07]

You going to post after every page? Trying catch up no. 1 poster of the month!!

Its easier for me to keep track after each page...in case I lose my place. Only about 9 more to go anyway, so wont come close to the #1 poster 😅

 

[Robbie Laker]

Geneva, 21 flights, 6 drops. 28.5%

Specifying the drop enhancers used (if any) would make this information more useful.

 

[Robbie Laker]

Maranello - SC+SG+GD+D+Gold sub, 105 flights, 18 drops, 17.1%.

 

[Navigata07]

All data has been entered at this point, except for the Geneva flight from @uschu who still needs to inform us of the bonuses. The only bonus that isn't included is the bowl of riches. I am not convinced that it applies to map runs, since it only affects quest items (collectible and non collectible quest items). The other bonuses only state "item from flights", so I did not count that bonus in the database. I will post a plot (or a few) soon. Thank you all for placing so much information over the past 2 years; it has been very beneficial

 

[Barkmi4 (Mike)]

All data has been entered at this point, except for the Geneva flight from @uschu who still needs to inform us of the bonuses. The only bonus that isn't included is the bowl of riches. I am not convinced that it applies to map runs, since it only affects quest items (collectible and non collectible quest items). The other bonuses only state "item from flights", so I did not count that bonus in the database. I will post a plot (or a few) soon. Thank you all for placing so much information over the past 2 years; it has been very beneficial

Just a point to note, the bonuses changed last year. Before the change, only GD affected S3 maps? Have you accounted for that? Anything before that date is probably null for these purposes 😬

 

[Navigata07]

Just a point to note, the bonuses changed last year. Before the change, only GD affected S3 maps? Have you accounted for that? Anything before that date is probably null for these purposes 😬

Yes the first 31 data points wont be included as it is pre 7.11 when the current bonus structure was implemented...thanks for reminding me. I could include them, but I would need to shift the GD runs to the SG column, since GD was +150%

 

[Navigata07]

Ok here are the two plots I've generated so far. Here is what I can gather from looking at these plots:

Expected vs. Actual Drop Rates
1) The default drop rate without any bonuses is 3%. The fact that the "true data" seems to group together around the "perfect trend" tells me that the default drop rate seems to be an accurate number to use
2)There is a large spread in actual drop rate vs the expected drop rate
3) Potion of Luck in my spreadsheet is applied for all flights instead of just a fraction. Most of those flights are next to the major expected drop rates of 12 and 15% (slightly to the right). There isn't much of a shift upward when looking at the two columns of data, which tells me that the Potion of Luck really doesn't do anything, and this is with the addition to all flights. The reality is that it applies to even less of the flights, becoming even more insignificant.

Number of Flights vs. Drop Rates
1) The lower the number of flights, the higher the actual drop rate variability
2) For the few high number of flights, the variability between the expected vs actual drop rates seems tight, which indicates that the more flights you fly, the closer to the expected drop rate you will be. Number of flights is the parameter of importance, not number of stars or how many planes are used at once.

Let me know if you have any questions or make any additional observations.

 

[deepgreensea]

This is brilliant analysis. Are the individual bonus descriptions borne out by the results?

Great work @Navigata07

 

[Navigata07]

This is brilliant analysis. Are the individual bonus descriptions borne out by the results?

Great work @Navigata07

It's more of a collection of the bonuses more than the individual ones. With each flight, there was a combination of bonus items to lead to a combined bonus for each run. My database has each bonus item checked off based on use, so I know whats expected for each bonus combination

 

[uschu]

Specifying the drop enhancers used (if any) would make this information more useful.

Yeah, you are right.
Luckily I only had to apply the usual suspects, Dice and Spyglass.

 

[Robbie Laker]

Le Mans - SC+SG+GD+D+Gold sub, 115 flights, 14 drops, 12.2%.

2xS3 747s secured; now for the Falcons ...

 

[MikeH]

Alicante - SG, SC, GD, Dice * 145 flights/20 drops