PKPD Tools for Excel for Windows

It is hard to believe that it is getting close to 20 years since we first released our PKPD Tools for Excel at at Prof. Steven Shafer's International Pharmacokinetic Modeling Workshop in Palo Alto (December 1994).

Since then, there have been several complete rewrites of the Tools, with incremental improvements in stability. Our 'oldest' users will recall that with the first versions it was necessary to copy a DLL fi le (the library of functions) to the windows system directory and a XLA file (for the function registrations) to the Excel Add-Ins directory. Although this approach worked, it caused many headaches, particularly with the links created between the spreadsheets and the XLA file. These links were often problematic when they were unexpectedly encountered by users who prepared a spreadsheet on one computer and tried to open it on another computer with a diff erent directory structure.

In order to improve the user experience (speci cally to avoid the 'link head- aches') we have completely rewritten the Tools and compiled them as an XLL, which is a special type of DLL written for Excel (for Windows). This means that this version (and all future versions) of our Tools does not require a separate XLA file for function registration. The good news is that there is now no issue with 'link headaches,' i.e., spreadsheets created on one computer can be used on any computer on which our Tools are installed without worrying about editing links to the Add-In.

excel/start.txt · Last modified: 2011/04/20 19:25 by cminto
CC Attribution-Noncommercial-Share Alike 3.0 Unported
Driven by DokuWiki Recent changes RSS feed Valid XHTML 1.0