 |
statistiXL is a powerful new data analysis package that runs as an add-in to Windows versions of Microsoft Excel. statistiXL has been entirely designed and written by scientists in order to meet the demanding needs of anyone requiring access to a robust, versatile statistical analysis package that is quick to learn and easy to use. With its wealth of features, Excel provides an ideal environment for data input, manipulation and calculation and by leveraging this familiar environment, statistiXL greatly extends this feature set to encompass high powered statistical analysis without the need to learn how to use an entirely new application from scratch. Data stored in existing spreadsheets can instantly be subjected to a wide range of statistical tests (many frequently not seen in other analysis packages). Tests provided by statistiXL include (but are not limited to), Analysis of Variance, Cluster Analysis, Contingency Tables, Correlation (Simple, Partial, Multiple and Canonical), Linear and Circular Descriptive Statistics, Classification and Grouping Discriminant Analysis, Factor Analysis, Goodness of Fit Tests such as Binomial, Circular, Normal and Poisson, Simple and Multiple Linear Regression, Nonparametric Tests such as Friedman, Kruskal-Wallis and Mann-Whitney, Principal Component Analysis, Univariate and Multivariate t-Tests. statistiXL also produces a wide range of plots including Box and Whisker Plots, Scatter Plots, Clustering Dendrograms, Normal Probability Plots and many others. Numerous options exist for formatting the standard results that are outputted by statistiXL and because these results are placed into Excel spreadsheets, you can use the tools that you are already familiar with to arrange and format textual and graphical output even further, changing fonts, rearranging cells, altering the scale on the axis of a graph etc etc. You can even subject the results to further analysis using either statistiXL or any of Excels numerous built in functions.
statistical analysis software data analysis statistics software microsoft excel analysis of variance principal component analysis cluster analysis contingency tables t-test correlation discriminant analysis
|
 |
Knowledge Room uses 3-D technology to enable users to navigate, gather, organize, and recall information. Taking advantage of human perception and spatial memory, Knowledge Room helps people organize information in their computer in the same way they organize in the real world: by manipulating objects in 3D space, with a sense of depth, color, texture, and lighting.
Knowledge Room places the user inside of a large room with beamed ceilings, brick walls and an upper loft. Environment views offer close-ups of bookshelves in each area.
The environment view engages one's sense of perception, invoking a different thought process: "Music files are in the cabinet near the stereo"; "Newspapers are in the large green book on the bottom shelf near the couch."
Knowledge Room users organize information into books. A book can contain many things: web pages, notes, documents, email messages, or references to pictures, music, spreadsheets - anything launched from the traditional Windows desktop.
Gathering content into books is easy: drag web pages from the browser and drop them into books; drop email messages and files onto books; "AutoClip" text into books from any Windows program.
Knowledge Room provides an alternative to the decades-old desktop metaphor. The desktop is 2-dimensional and non-intuitive, limiting us to folders and files. Everyone is familiar with the problem of hunting for information through cryptically labeled files scattered across hundreds of confusing directory and subdirectory names. Web browsers only exacerbate the situation, giving us access to a world of information, with only flat folder bookmarks to keep track of it all.
Knowledge Room changes all of that by tapping into our natural ability to think spatially, allowing us to keep information in real books, placed in oak and mahogany bookcases throughout a richly rendered environment.
"Knowledge Room....
...putting information in its place."
info retrieval library keyword search personal information manager information overload research tool using 3-d technology navigate gather
|
 |
JoinLine fixes text files with long fixed length records and unwanted line wraps. Spreadsheets and database programs import individual text records with data on the same line. However, sometimes text lines are wrapped before the end of the record. If these records always wrap to the same number of lines, then JoinLine can restore the wrapped records to single line records. A space pad character can be inserted between merged lines; input lines can be padded to a minimum length; and non-printing characters can be translated to spaces. JoinLine writes the merged line result to a new file or appends to an existing file.
- Automate the tedious job of manually fixing a wrapped line data set
- Can insert a space pad between merged lines
- Can pad short input lines to a minimum length
- Can translate non-printing characters to spaces
- Write the merged line file to a new file or append to an existing file
join lines unwrap text file fixed record database unwrap text files long fixed length records
|
 |
Excel Compare is a tool that allows you to compare and update Excel files, Excel spreadsheets and individual ranges of sheets. Excel Compare offers three different possibilities for using the variations results:
1. MARK DIFFERENCES
Excel Compare marks the differences of the underlying spreadsheets and tables. Differences are marked with the following colors:
- orange for different cell entries
- green for added and columns and rows
- light blue for deleted columns and rows
At one glance Excel Compare clearly displays all differences and you may decide with which version of the spreadsheet you wish to proceed.
2. CREATE A DIFFERENCE REPORT
If desired, you may display the result of the comparison in a reader friendly difference report. On this report you not only see the rows or columns deleted and/or added, but also each individual cell with different values.
3. ANALYZER / UPDATE
The third and certainly most comfortable function of Excel Compare is the "Analyzer" tool: After the comparison process the spreadsheets are displayed vertically or horizontally and a user friendly tool bar is displayed, with which you may easily navigate through the differences. Excel Compare ensures that both tables are displayed on your screen in order for you to directly compare all differences. At this point you may decide with which version you wish to continue. With mouse-clicks you may transfer values from table 1 to table 2 or vice versa. This is the quickest way to eliminate all differences and within a short period of time you will have your Excel spreadsheet perfectly updated.
excel compare update sheet file workbook range xls data cell utility
|
 |
Path Lister lets you view a customizable listing of the contents for any folder on your computer. You can easily save the folder listing as TXT or PDF file. The Path Lister listing can be saved as a file that can be imported into most popular spreadsheets and database applications. Path Lister can also process information contained within a folder's subfolders. A wide range of options are available to allow you customize your listing, including font style and size. Path Lister also allows you to specify what detailed information to list, as well as to apply filters to limit the files that are included in the output list. There are also a lot of settings for the generated PDF files, including PDF Security (passwords, permissions). Page orientation, fonts and colors can also be modified.
path directory folder lister listing as pdf text txt filters name
|
|
|
