Spreadsheet Categorizing Data

cd_logo

Spreadsheet Categorizing Data

$29.95

If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then Categorizing Data for Excel is the solution.

What is Spreadsheet Categorizing Data? VIEW A DEMO!
This product is an add-in for Microsoft® Excel® that, allows you:
  • Extracting unique values from a column in a database and building another table with that data.
  • Stratifying time by: years, months, weeks and inclusive days lapsed.
  • Making stratification based in a correspondence one-to-one.
  • Knowing if a particular table is well designed, using “stratification table sufficiency” tool.
  • Separating a column in its different parts o categories.
  • And more…
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, 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
 
Extract Unique Cases
 
Test the Stratification Table
 
Extract Row
 
Moreover, Spreadsheet Categorizing Data is TOTALLY COMPATIBLE WITH EXCEL 2010 and MICROSOFT® WINDOWS® 7 !!!
What is a Heatmap? A Heatmap is a graphical representation of data where the values taken by a variable, in a two-dimensional (or more) map, are represented as colors, size, background, etc.
With Heatmaps you can analyze your data with up to 5 dimensions, using:1. Font Size.
2. Font Color.
3. Font Type.
4. Background Color.
5. Inserting Images.

Who needs this Software?
Any type of user that uses Microsoft Excel for his/her projects. It can be used by:
  • 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.
 
Categorize Databases
Extract unique casesExtract unique cases
This tool extracts unique values from a column in a database.
Time stratificationTime stratification
This useful tool stratifies a database, by adding one more column to the database being observed.
Test the "stratification table sufficiency"Test the "stratification table sufficiency"
To stratify a database we need a stratification table.
Consolidate ranges Consolidate ranges
With this tool you can consolidate ranges of different sheets in the open workbooks as closed workbooks as well.
Stratification 1 to 1Stratification 1 to 1
Stratification 1 to 1 was created to deal with the frequent need of stratifying a database.
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.
Extract rowExtract record
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.
Split field - By groupsSplit field - By groups
Use Split field by groups to split a database in multiple data groups
Split field - By dateSplit field - 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.
 
 Tools
Toggle settingsToggle settings
This powerful tool has been crated to do away with such loss of time.
Freeze | divide panesFreeze | divide panes
We sometimes work with models whose information does not fit in the screen.
Sheets managerSheets manager
A comprehensive tool that will make any worksheet management task easier to you.
Export sheets as...Export sheets as...
Use the "Export sheets as..." tool, and simplify this task.
Workbooks managerWorkbooks manager
Managing your open workbooks is made easy with the Workbook manager tool.
My Favorites My Favorites
Do you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all.
My favorites - (Permission on Windows Vista)
My favorites Demo
Sheets Manager Demo
Conditional Text
Split Field by Date
Time stratification 1
Time stratification 2
Categorizing Data Bar
Extract Unique Cases
Test Stratification
Stratification 1 to 1
Categorize Database
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 is 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
$29.95
2 to 5
$25.95
6 to 9
$22.50
10+
$14.95
 
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!