Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. Half Life Steady State Days to Reach
  2. in Days Concentration (to 4 places)
  3. =========== ============= =============
  4. 1 2.000 17
  5. 2 3.4142 33
  6. 3 4.8473 49
  7. 4 6.2852 68
  8. 5 7.7250 85
  9. 6 9.1658 107
  10. etc.
  11.  
  12. A1: Half-Life in Days [entered number]
  13. B1: =0.5^(1/A1) [Amount retained after 1 day]
  14.  
  15. A2: 1 [Dosage amount]
  16. B2: =A2 [Amount after dose]
  17. C2: =B2*B$1 [Amount after 1 day just before next dose]
  18.  
  19. A3: 1 [Dosage amount]
  20. B3: =A3+C2 [Dosage + Previous day retained amount]
  21. C3: =B3*B$1 [Amount after 1 day just before next dose]
  22.  
  23. Rows 4 onwards are copies of row 3 (cell references adjusted, of course)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement