(Naturally, for Excel formulas, substitute in the value or cell reference for X, Y, T, etc)

Formula | Excel Formula | Example | ||

Initial Cases | X | 112 | Aus # Mar10 | |

Final Cases | Y | 2,431 | Aus # Mar25 | |

Time | T | 15 | days | |

Multiplier over duration | M = Y/X | =Y/X | 21.71 | |

Daily Multiplier | M_{D} = M^{1/T} | =(Y/X)^(1/T) | 1.23 | |

Daily % Increase | =(M_{D} -1) * 100 | =((Y/X)^(1/T)-1) | 22.8% | Format as % |

Time to double | T_{2X} = log_{e}2 / log_{e}M_{D} | =LN(2)/LN((Y/X)^(1/T)) | 3.38 | days |

Time to 10x | T_{10X} = log_{e}10 / log_{e}M_{D} | =(Y/X)^(1/T)/LN(10) | 11.22 | days |

Convert from 'time to double' to 'time to 10x' | ||||

T_{10X }= T_{2X} * log_{e}10 / log_{e}2 | =TDOUBLE * LN(10)/LN(2) | |||

Convert from 'time to 10x' to 'time to double' | ||||

T_{2X} =T_{10X} * log_{e}2 / log_{e}10 | =TTEN * LN(2)/LN(10) | |||

Convert from 'time to double' to 'daily multiplier' | ||||

M_{D} = e^{log2 / T2X} | =EXP( LN(2) / TDOUBLE) | |||

Apply a daily multiplier for N days | ||||

M = M_{D}^{N} | =POWER(MD, NUMDAYS) |

## No comments:

Post a comment