= ( C2 * 0,5 ^ ( (B3 - B2) / $H$3 ) ) + D2 * J$2 - this does take into consideration multiple dose intakes, but does not account for absorption time. (all examples are for C3 C2 is manually set to 0) In order to write a working formula on column C, I followed many steps: As an example, the person who's going to use this spreadsheet needs to take a new 50mg dose of the drug every 56 hours. It must account for multiple dose intakes (i.e. My spreadsheet currently looks like this: I actually use LibreOffice Calc, but a solution tested in Excel would also help me (as it'll probably be portable, anyway). As painful as it sounds, I've been tasked to implement a spreadsheet to calculate drug absorption and elimination half-life.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |