Page 1 of 1
Master Spreadsheet Question
Posted: Tue Dec 17, 2013 3:38 am
by 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?
RE: Master Spreadsheet Question
Posted: Tue Dec 17, 2013 9:47 am
by CowboyRonin
I've referred your question to the developers.
RE: Master Spreadsheet Question
Posted: Fri Dec 20, 2013 3:28 pm
by 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,