Tools for Spreadsheet Tables

logo_tet

Tools for Spreadsheet Tables

$44.95

Excel Data Management Essential tools for data analysis and tables management for novice and advanced Excel’s users.

What is Tools for Spreadsheet Tables? VIEW A DEMO!
It is a data management tool that will strengthen your Microsoft® Excel® to manage huge tables and data bases.
Tools for Spreadsheet Tables is an addin that combines the functionalities of Microsoft Excel in order to create more robust functionalities which let you extracting multiple conditional data, splitting tables, smart consolidation, merging tables, categorizing database, Extracting unique records, stratifying data and more…
Tools for Spreadsheet Tables is a priceless, time saving Excel tool for accountants, auditors, specialists in fraud detection, financial and data analysts, and professionals whose activity involves the use of data bases or large tables in Excel spreadsheets.
Now you can insert Heatmaps and Traffic Lights.
A Heatmap is a graphical representation of data where the values taken by a variable, in a two-dimensional (or more) map, these are represented as colors, size, background, etc.
Traffic Lights is a sort of Heatmap but more specific to get a visual and fast alarm about the status in a cell.
Heatmaps
 
Traffic Lights
 
 
Conditional Text
 
Test the Stratification Table
 
Extract Unique Records
 
Multiple Conditional Data Extractor
 
List Unique Cases
 
Extract Row
 
Moreover, Tools for Spreadsheet Tables is TOTALLY COMPATIBLE WITH EXCEL 2010 and MICROSOFT® WINDOWS 7 !!!
Who needs this Software?
  • DataBase Administrators
  • Accountants
  • Consultants
  • Any person who uses Excel as a software for databases
Insert Heat Maps and Traffic Lights
Insert HeatmapsInsert Heatmaps
A heatmap is a graphical representation of data where the values taken by a variable, in a two-dimensional (or more) map, etc.
Heatmaps MultidimensionalHeatmaps Multidimensional
Create Heatmaps combining Image, Font, color, backcolor Cell, Text & font type....
Rules TableRules Table
With this function you can insert an example that you can re-use or edit according to you convenience to make the categorization from your data.
RefreshRefresh
This option refresh all saved models in your active workbook as modified at the data base.
Manage ModelsManage Models
Through this functionality you will be able to manage in a simple way the refreshing of data.
Options - Delete ImagesOptions - Delete Images
From this page you can insert images from the dialog box, simply, choose one cell and select the image you wish.
Options - Delete IconsOptions - Delete Icons
With this function you can delete inserted icons inside the selected range.
 
Import/Export
From ExcelFrom MSSQL
This tool allows you to recuperate data from a database to an Excel sheet, in an easy and friendly way.
From MYSQLFrom MYSQL
This tool allows you to recuperate data from a database to an Excel sheet, in an easy and friendly way.
From Csv/TextFrom Csv/Text
Never was importing a document that easy. This tool makes the importing files a child's play.
From ExcelFrom Excel
Use this practical tool to save a range in or the worksheet or an entire sheet in other file type, i.e. in CSV or TXT format.
Select cells
Easy select Easy select
Some times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish.
Select current regionSelect current region
Suppose you have a database with 60000 records and 250 fields, and want to copy this database in other sheet.
Select visible cellsSelect visible cells
This tool selects all visible cells of a selected range or the entire active sheet. If no range is selected, the entire worksheet becomes the work area.
 
Manager Data
Change to text - numberChange to text - number
Some times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish.
Concatenate cellsConcatenate cells
Do you wish to join text of many cells to a single cell? Simply do this: 1. Select the cells of a row that you desire to concatenate....
Multiple conditional data extractorMultiple conditional data extractor
This tool allow to perform filters in a data base. Excel only allows to apply filters that involve a single condition per field.
Extract unique recordsExtract unique records
Use this versatile tool to group records in a database, meeting the rigorousness you will usually need for a given operation.
Multi sheet / database consolidatorMulti sheet / database consolidator
Do you wish to consolidate data come from many sheets contained in more than one workbook and the records are disordered? Then, this tool will make it for you.
AutofilterAutofilter
Use this advantageous tool to filter a database based on specific criteria.
Complex formula's consolidationComplex formula's consolidation
This useful tool allows you to make in a simple way, many arithmetic operations at the same time between spreadsheets.
Test the "stratification table sufficiency"Test the "stratification table sufficiency"
To stratify a database we need a stratification table. It means if the stratification table does not consider all possible cases a given field may take?
Time stratificationTime stratification
This useful tool stratifies a database, by adding one more column to the database being observed.
Stratification 1 to 1Stratification 1 to 1
Stratification 1 to 1 was created to deal with the frequent need of stratifying a database, but stating a 1-to-1 correspondence....
List unique casesList unique cases
Some times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish.
SortSort
Sorts an Excel database according to criteria defined for specific field(s)
Extract rowExtract row
Some times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish.
Merge tablesMerge tables
Use this valuable tool to merge two databases based on a common field.
FormForm
Analyze a database, record by record, with this valuable tool.
 
   Split Tables
Split table - By groupsSplit table - By groups
Use Split field by groups to split a database in multiple data groups, according to repeated values in the selected field.
Split table - By dateSplit table - By date
Split field by date is the ideal tool to split a database according to date-type criteria such as year, month, day, week or weekday.
   Delete
Delete rows emptyDelete rows empty
This tool is especially useful when there are empty cells in a database and we need to delete them all.
Delete rows hiddenDelete rows hidden
Delete hidden records in a database with this practical tool. It is especially hepful when we have grouped our database and hidden repeated records.
Delete rows visibleDelete rows visible
Apply this tool to delete visible columns in a selection. It does not delete columns hidden columns in that selection.
Delete columns emptyDelete columns empty
Use this advantageous tool to delete empy columns in a selection.
Delete columns hiddenDelete columns hidden
Use this convenient tool to delete hidden cells in a selection.
Delete columns visibleDelete columns visible
Apply this tool to delete visible columns in a selection. It does not delete columns hidden columns in that selection.
Data Analysis
Specific cellsSpecific cells
This tool selects cells of a given range, but only taking into account those with a given format.
Easy searchEasy search
This is a useful tool that has been designed to make searching in a data range both simple and efficient.
Easy search - By textEasy search - By text
Steps: 1. Include the active cell in the range to be searched. 2. Click on the Easy Search button in the toolbar.
Easy search - By formatEasy search - By format
Steps: 1. Include the active cell in the range to be searched. 2. Click on the Easy Search button in the toolbar.
Easy search - By logic criteriaEasy search - By logic criteria
Steps: 1. Include the active cell in the range to be searched. 2. Click on the Easy Search button in the toolbar.
Cell's math By formatCell's math By format
Use this gainful tool to search all cells in a specific range with a particular background color and to do some math with the results.
Multiple conditional analysis & formattingMultiple conditional analysis & formatting
Multiple conditional analysis & formatting is the tool suitable to format cells in a database based on a criterion previously specified in the decision table.
Consolidate ranges Consolidate ranges
Some times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish.
Conditional text Conditional text
Some times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish.
SumifSumif
In order to understand the SUMIF option functionality, Think about the following situation...
CountifCountif
In this case, we have a table with the names and the score of each one of them, also a criteria table.
DuplicatesDuplicates
This tool looks for values (or dates) duplicates in a specific column of a selected data base.
BreachesBreaches
If you wish to look for missing records in a data base through a field that contains a sequence (either numeric or date values) this tool will do it for you.
 
Viewer
GuidesGuides
This tool is specially convenient if you want to navigate throughout databases with records or fields stretching beyond the screen.
Freeze | divide panesFreeze | divide panes
We sometimes work with models whose information does not fit in the screen. And we may get lost as we navigate throughout the spreadsheet as the headings of our model would no longer be visible.
Sheets managerSheets manager
Use Sheet Manager –a comprehensive tool that will make any worksheet management task easier to you.
Arrange WindowsArrange Windows
We have created a useful tool that will allow you to sort and display all open workbooks on the screen; furthermore, you can view different areas of a workbook.
Workbooks managerWorkbooks manager
Managing your open workbooks is made easy with the Workbook manager tool.
Toggle settingsToggle settings
We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook, we will have to do it one at a time.
Vista Security Using Excel and Heatmaps in order to categorize reports
Conditional text Extract unique record
List unique cases Multiple conditional data extrator
Multisheet database Consolidator Stratitication 1 to 1
Test stratification table Time stratification 2
Time stratification 1 SQL to Excel
Consolidate Ranges Merge Tables
Split field by date Cell's math by format
Easy search Demo Specific Cells Demo
Complex Formulas Consolidation Conditional Sum Count
Import from CVS Multiple conditional analysis formatting
Categorizing Data (2003) My Favorites
Sheets Manager
How to open this help file: 
Before pressing the button OPEN , the checklist must be uncheked, in this way we are telling Windows that this file if secure so that the window will not be displayed again for this action.
These are some of the Clients
Microsoft
Oracle
Hp - Hewlett-Packard
Roche
Intel
IBM
Siemens
AT & T
Alcatel-Lucent
A.P. Moller Maersk
US Bank
Career Management Center, Stanford University
BDO Seidman LLP
Cisco
FBI - Federal Bureau of Investigation
Acciona Infraestructuras, S.A.
US Patent & Trademark Office / OCIO / WDD
U.S. Geological Survey
Triumph
Accenture
Berkeley - University of California
Atkins
Rhein-Zeitung
EATON
EIM
University of Bridgeport
Kodak
URALSIB CAPITAL
Postbank Ireland
Avon
The Hartford
University College Dublin
Honeywell
BP
INTERNATIONAL OLYMPIC COMMITTEE
Vonage
The digital Bookstore
BD Biosciences
Baltic Property Trust AM
JumpSport
Medtronic
ZACPOSEN
Harman International
Amtico International
Banque Saudi Fransi
Habib Bank Limited
WSECU - Washington State Employees Credit Union
Macy's West
Euromonitor International
BC Ferry Services Inc
Deloitte
University of Manitoba
NovaScotia Dept of Education
Danfoss
Santos
SHAW
Ernst and Young
Cowabunga Inc
Temple University
Rohmihaas
State Goverment of Victoria, Australia - Department of Human services
Bullhorn Software
Otenet
CEMA - Canadian Egg Marketing Agency
DataMark
Iron Mountain
Marsh
Vanderbilt University
Verizon
Leica Geosystems
Towers Perrin
CDN
Mondrian Investment Partners Ltd
Baxter Healthcare Corporation
Sanofi-Aventis Canada Inc
University at Buffalo
Bureau Van Dijk
LLoyd Germánico de México, S de R.L. de C.V.
Nucor - LMP
Kenworth Mexixana, S.A. DE CV
Georgia Pacific
Texas Tech University Health Sciences Center - CELL BIOLOGY & BIOCHEMISTRY DEPARTMENT
Singapore Press Holdings
Time Warner Cable
Education Development Centre (DECS) Australia
PC Richard and son
Valspar
Prudential zack shore properties
Bigmouth - UK's NO.1 LIVE MUSIC INFORMATION STATION
Quintiles Transnational
Swedish University of Agricultural Sciences
Compu Com
Loyola Collegue in Maryland
Elite Technical
The Samuel Roberts Noble Foundation
Wayne Resa
Citco
Lyondell
Maritime Institute of Technology
Oger Systems
Calvert Online
Corning Inc
Kizoom
Lad Consulting
Chipkins Catering Supplies - Durban
First Pioneer Farm Credit
Ace Canada
Secur Invest
Red de Energia del Peru
The Walden Group
Global Apparel Network
BSH Group
Metropolitan ARC
Boa Construction Company
MTI
Cermak Peterka  Petersen
Flatiron Capital Corp
Acuren
Richardson Patel
ICES - Institute for clinical evaluative Sciences
SDCERA
Pacesetter energy, Inc
The Oberg group
Mercy Corps
Genetrix
ASM TECHNOLOGIES LTD
Century Wealth Management
Pindar
RCLCO
Blue Rhino
Rio tinto
Pioneer Natural resources
Scotsburn Dairy Group
HMC
Access Business Group
Printing Industries Association
MSB Associates, Inc.
Los Angeles Unified School District
Saic
Ukrainian Trade Guide
IBEX
Mondo Minerals
Cross Systems
Champlain college
Calix
Aluwest
Linear Transfer Systems
S.P. Shaughnessey & Company
KICK Automatisering BV
Williams
American Laser Mark
CSIR
Flytoget
Aerosat
St. George Bank
Parker HSD
If you would like to evaluate the software please contact us, and we will be delighted to arrange a free trial for you. Below is the pricing for your indication:
 
Quantity
Price per license (USD)
1
$44.95
2 to 5
$38.95
6 to 9
$33.95
10+
$22.50
 
For quantities above 10 licenses please contact us at sales@unitedaddins.com, and we will be happy to provide you the needed quote.
Thank You!