XL Toolbox 2.14

XL Toolbox 2.14 is a powerful and easy to use tool which is designed to meet all the needs of
There are several commercial software packages for scientific data analysis and presentation. While their statistical and scientific charting functions are unmatched, they are themselves no match for Excel's flexibility when it comes to organizing your data. Thus, researchers may end up having their data in several files: Most is stored in Excel®, and for specific analysis and presentation tasks, some of it is copied over to one of the professional scientific packages. I prefer to have my data in one place and developed the XL Toolbox to augment Excel's scientific capabilities.
There are two editions of the Toolbox, one for Excel® 2007 and another one for Excel® 2003 and earlier. The installer automatically determines which files to install, and can activate (turn on) the add-in in Excel® for you.
Installing the Toolbox

• When you run the installer file, the add-in and a few supporting files will be copied to the add-in folder of your user profile. Typically, on an English machine, this is: c:documents and settingsusernameapplication dataMicrosoftaddins.
• Starting with version 2.11, the installer can automatically activate the XL Toolbox in Excel for you.
• You need to install the add-in for each user on the computer. If you log into different computers on a network with the same username, you will have to install the add-in on each computer.

Installing for all users on the computer

• If you have a multi-user environment and want to install the Toolbox for all users at once, you need to manually copy the file(s) from your profile folder to the XLStart folder, e.g.:
• C:Program FilesMicrosoft OfficeOffice12XLSTART
• Besides the actual addin file, you may want to copy the help file (xltbhelp.chm) along with it.
• When an addin is installed in the XLStart folder, it is not necessary to activate it from within Excel.
• Hint: A handy shortcut to your personal profile folder is: Start--Run--%appdata%--ENTER.

Uninstalling the Toolbox

• Uninstalling the toolbox is easy. Simply go to Control Panel, choose "Add or remove programs", locate "Daniel's XL Toolbox" in the list, and click on "Remove". The Uninstaller will unregister the Addin in Excel for you.
• The uninstall procedure will also permanently delete your personal XL Toolbox preferences.

Major Features:

1. Data analysis
   
   • The Improved ANOVA is a lot more flexible than the ANOVA function of the Analysis Toolpak, and it also offers posthoc testing.
   • The Pearson product-moment correlation gives you a very quick overview of the linearity of your data and also calculates statistical significance for you.
   • Use the Group Allocator to allocate ("randomize") subjects to treatment groups before you start the experiment.
   • Formula Builder helps analyzing your data.
   • Multi Histogram is a very flexible tool to generate histogram analyses.
2. Chart functions
   
   • Spread Scatter spreads out the data points in your chart, making it easier to visualize individual subjects.
   • Annotate charts easily by simply marking the data cells with color, or insert text comments.
   • Smart error bars: Add custom error bars to your Excel® graphs with one mouse click.
   • Move chart ranges left and right to quickly browse your data.
   • Save charts as PNG, GIF, or JPG files to your hard drive.
   • Copy chart properties from one chart to all other charts in the current workbook.
   • Add and edit watermarks on your charts to mark the date or authorship.
   • Point charts to the correct worksheet after copying and pasting them in Excel.
3. Other features
   
   • Automatic backups keep the recent saved versions of your Excel workbooks.
   • Special Paste functions speed up your data entry.
   • Use the Home Sheet button or the Sheet List function to navigate with ease through multiple worksheets.
   • Undo: Starting with XL Toolbox version 2.10, the most recent change to your workbook can be undone. Excel has some important technical limitations to Undo that are worth knowing about. 

Requirements:

• Microsoft® Excel® 2000, 2002, 2003, or 2007.
• Microsoft® Windows 2000, XP (Vista not tested).
• Harddrive space: negligible (around 3 MB).WareSeeker Editor