Extra Robots Speeds Increase Not Right?

So this may have already been discussed, and I’m not sure that it is an actual bug, but it appears that the time being reduced when adding the Extra Robots upgrade isn’t 10%, 7.5%, and 5%. It seems to be off by a few percentage points more and more with each calculation.

Looking at the game files, the time is shown in milliseconds so I’m wondering if the base speed is in another format and has to then be converted to millisecond time, which in turn is used to calculate the speed increase/time reduction causing the times to appear off.

Below is an example of what I’m talking about. The in game percentages for each Extra Robot Upgrade are in parentheses while the actual percentages I calculated are in brackets next the times in seconds.

Ex.
Chassis Assemble
Base Time: 25.75
Extra Robots 1: 23.41 [9.09%] (10%)
Extra Robots 2: 21.91 [14.91%] (10%+7.5%)
Extra Robots 3: 21.02 [18.37%] (10%+7.5%+5%)

What am I missing because this is driving me a little crazy.

Hey TwistedNexus,

please find the explanation in this post:
http://positech.co.uk/forums/phpBB3/viewtopic.php?f=53&t=18002&p=83489#p83483

The upgrades provide more speed, not less time …

Kind regards

Here is the excel formula that I have used for the different robot combinations.

S= Standard Time
(S-(S-((1/S)/((1+%)/S)*S)))

$G19 = standard time for that station.
R3 robot
($G19-($G19-((1/$G19)/((1+5%)/$G19)*$G19)))

R2 robot
($G19-($G19-((1/$G19)/((1+7.5%)/$G19)*$G19)))

R1 robot
($G19-($G19-((1/$G19)/((1+10%)/$G19)*$G19)))

R2 & R3 robots
($G19-($G19-((1/$G19)/((1+12.5%)/$G19)*$G19)))

R1 & R3 robots
($G19-($G19-((1/$G19)/((1+15%)/$G19)*$G19)))

R1 & R2 robots
($G19-($G19-((1/$G19)/((1+17.5%)/$G19)*$G19)))

R1, R2, & R3
($G19-($G19-((1/$G19)/((1+22.5%)/$G19)*$G19)))

Hope this helps you out.

I knew I was missing something and figured it out this morning while at work. Was too tired and got fixated on the 10% speed increase trying to make it math out to a linear reduction in time in the opposite direction.

Thank you for linking to the other.

So I was working on creating a formula as well to help me figure out the new time for each upgrade by production slot and I did eventually get this figured out and wrote the below expressions since different slots have different Speed increases based on upgrade. Also, these expressions assume you have bought/installed the previous upgrade.

Upgrade 1: “=1/((1+(1D$4))/$B5)"
Upgrade 2: "=1/((1+(1
(D$4+E$4)))/$B5)”
Upgrade 3: “=1/((1+(1*(D$4+E$4+F$4)))/$B5)”

$B5 = Base Speed
D$4 = Upgrade 1 Percentage Speed Increase
E$4 = Upgrade 2 Percentage Speed Increase
F$4 = Upgrade 3 Percentage Speed Increase

You can see them in action at: goo.gl/Ugg7Xi

I under stand what you are doing. The formulas that I have listed above are the ones that I used in my excel sheet. It will show the times for each combination of robots. You may not want to use Robot 1 because it will be to fast but Robot 2 is to slow so if you add Robot 2 & 3 it will give you the time you are looking for or at least get you close.

Here is my doc sheet if you want to have a look.

https://docs.google.com/spreadsheets/d/1K6KYUA8NU5PwqWGtwrPITe4hLDCSykQAx9lFA-g_2nM/edit#gid=0

Can’t access the sheet

Try this link. Just so that you know this spreadsheet does not have the formulas in it because I copied it from my excel file.

https://docs.google.com/spreadsheets/d/1K6KYUA8NU5PwqWGtwrPITe4hLDCSykQAx9lFA-g_2nM/edit?usp=sharing