XL Toolbox is an Add-In for Microsoft Excel for researchers. 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.
This addin will be appreciated by those who like to have all data in one place, especially since XL Toolbox will augment Excel's scientific capabilities.
Here are some key features of "XL Toolbox":
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.
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.
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, 2007, 2010
What's New in This Release: [ read full changelog ]
Improvements:
· Error bars: The Error Bar function now has two distinct modes of operation. In standard mode, it locates error values based on a certain offset to the right of or below the chart data. In advanced mode (which used to be the only mode available), it looks for empty cells that delineate the chart data block, and picks the appropriate error values from the adjacent block of cells. An explanatory screen was added that is shown the first time the Error Bar function is used.
Bug fixes:
· Open file from cell: Prevented run-time errors if several cells were selected at once (error report ID 53NMZ1). Only the filename in the first selected cell will be opened.
Other changes:
· The help file is now built using Doxygen, making maintenance easier. The help text on the user preferences and the error bar function was updated.
Find us on Google+
