Ok, I found the problem. The change in V is exactly as it is on the spreadsheet. However, V is not the change in tech level. It is the change in knowledge. The model had to convert this back to tech level change. The final equation is:
newLevel = growth (GV)/LN(multiplier (MV))*LN(k+V)+ startLevel (Ts)
If you add that line in it should work fine. All the architecture seems to be in place; it looks good otherwise. It may seem like a bug for tech level to be negative, but it is supposed to work that way. Tech will usually start at a level of at least ten, and we wanted it to potentially drop below the starting value. I have tested such things and the model does not break at negative tech levels. (If k were ever to become negative, the model would die, but that won't happen as long as upkeep (c) is below 1.)
One more thing: The helper calculation, to my untrained eye, looks as if it only can reference one helper tech. Is this the case?
newLevel = growth (GV)/LN(multiplier (MV))*LN(k+V)+ startLevel (Ts)
If you add that line in it should work fine. All the architecture seems to be in place; it looks good otherwise. It may seem like a bug for tech level to be negative, but it is supposed to work that way. Tech will usually start at a level of at least ten, and we wanted it to potentially drop below the starting value. I have tested such things and the model does not break at negative tech levels. (If k were ever to become negative, the model would die, but that won't happen as long as upkeep (c) is below 1.)
One more thing: The helper calculation, to my untrained eye, looks as if it only can reference one helper tech. Is this the case?
Comment