Master Spreadsheet Question

[stilicho410]

I was just looking over the modding documentation and the Master Spreadsheet.

I have a question on the tab "Mission Components-I". I can see how the L1 through L4 parameters are derived, but how are they used? Are they some sort of inputs for reliablity?

[CowboyRonin]

I've referred your question to the developers.

[Nacho84]

Hello stilicho,

The L1 through L4 parameters indicate the reliability improvements provided by each SET employee assigned to a mission component (L4 is for the leftmost employee, L3 is for the second employee from the left, and so on). The reliability improvement is computed as follows:

1) We compute the amount of reliability points remaining in order to reach the MaxRDReliability:

DistanceToMaxRD = MaxRDReliability - CurrReliability

2) We compute and add up the contribution of each assigned employee. The leftmost slot is a random number between L3 and L4, the second slot is a random number between L2 and L3, the third slot is a random number between L1 and L2 and the last slot is a random number between 0 and L1. The contribution also takes into account the relevant skill level of that employee.

3) The result from point 3) is divided by 100 in order to get a normalized value between 0 and 1. The normalized value gets multiplied by the result from 2), which yields the improvement in % points.

Notice that the algorithm actually produces a dichotomy paradox, so we have a bit of code in order to adjust the result of 3) when we get close enugh to MaxRDReliability:

Code: Select all

 // Avoid a dichotomy paradox.
 if ((normalizedDistanceToMaxRDRel < 0.0075f) && (reliabilityRawImprovement > 0))
 {
 	reliabilityRawImprovement = currMissionComponent.MaxRDReliability - currMissionComponent.CurrReliability;
 }
 

Hope this helps clarify what's going on behind the scenes!

Cheers,