Typical data manipulation or analysis is intrinsically two-dimensional. A table is chosen, and the object of immediate attention is a cell or several cells to be processed.
We Present a three-dimensional view; accessing one or more tables and performing an action simultaneously on every cell in every table present.
-
- With remarkable ease, a table can be decomposed into a stack of smaller tabs in many ways. Actions can then performed on every tab, and results reunited as a single table.
-
- With Excelerate, successive actions – reorganization, cleaning, analysis – can be performed on an entire table or family of tables using simple English phrases from our library. It is fast, powerful, and self documenting.
Example1: (see video)
You have 20-year table of daily stock prices, called stock1. You want the daily average profit or loss for each year.
Three actions will be enough:
-
- t1: group stock1 by year
-
- t2: calculate ((close t1)-(open t1)) average
-
- result: combine t2 vertically
and that’s it
Example 2: (see video)
The manager faced difficulties in cleaning and analyzing clinical trial data from multiple subjects, all presented on a single Excel Workspace tab. This example is more complex, but illustrates the same techniques. Here is an outline of the procedure:
-
- Use the subject id field to break the table into tabs using uniques values in th id column (1 action)
- quickly find the maximum drug concentration, time when achieved, and area under concentration-time curve for each tab all at once using just a few actions.
- combine the results into a table (1 action)
see the video for all the details