Spreadsheet Model Builder

Spreadsheet Model Builder

$99.95

Build, Audit and Manage small or big spreadsheets models easier and faster.

Description
Functions
How To Videos
Documentation
Customers
Price

What is Spreadsheet Model Builder? VIEW A DEMO!

Now, to develop and format professionally your Microsoft® Excel® models is easier with Spreadsheet Model Builder !!

Spreadsheet Model Builder has been developed for modeling professionals with years of experience helping people make decisions, from simple problems to multimillion projects with two ideas in mind: working faster and more reliably, i.e. making trustworthy decisions in time.

Spreadsheet Model Builder has the most comprehensive set of tools to develop, analyze, format and maintain models. There is no other tool with such wide range of utilities available in the market. You may need to spend 4 or 5 times as much in multiple products, and even so you wouldn’t have all the tools or the support as with Spreadsheet Model Builder.

Model Builder for Excel, Robust set of Excel tools

Spreadsheet Model Builder integrates 4 powerful Excel Modeling tools:

Moreover, Spreadsheet Model Builder is TOTALLY COMPATIBLE WITH EXCEL 2010 and MICROSOFT® WINDOWS 7 !!!

Highlight Features

Spreadsheet Model Builder has many features:

Multiple IF.
Spreadsheet Goal Seeker
Consolidator
Chart analysis
Link Manager
Audit Panel: Cell’s reference tracker – Panel : Detect and trace references in the cells of your models
Audit Panel: Model Navigator
Audit Panel:Cell watcher
Manage Comments
Who needs this Software?

Any type of user that uses Microsoft Excel for his/her projects. It can be used by:

Financial analysts
Engineers
Biologists
Mathematicians
Economists
Teachers
Students in general
Scientists
Any person who uses Excel in the decision making process and wishes to explore his model’s possibilities.

Model Builder - Panel

Insert Symbols This option makes it possible to insert some of the most commonly used Excel symbols, some of which can be accessed by using key combinations.	Quick Styles Panel By means of this function you will be able to realize about the use of the styles for your workbooks with the possibility of modifying or saving the styles.
Iterative tools
Format currency Change the format of your numbers using the Format Currency tool . Click many times to see other types of number formats.	Format number Change the format of your numbers using the Format Number tool . Click many times to see other types of number formats.
Format percentage Change the format of your numbers using the Format percentage tool . Click many times to see other types of number formats.	Format date Change the date formats easily using the Format Date tool . Click many times to see other types of date formats.
Pick up formatting options Using the Apply Formatting Options tool to use and save your own format settings.	Apply formatting options Select a cell and press this button many times to see the different format settings you selected.
Format cell's width In order to gain access to this tool, go to panel Quick styles and press the button And a dialogue settings box will be displayed	Unhide/hide rows Use Unhide/hide Rows to unhide/hide rows with a simple click.
Format cell's height In order to gain access to this tool, go to panel Quick styles and press the button And a dialogue settings box will be displayed.	Unhide/hide columns Use Unhide/hide Columns to unhide/hide columns with a simple click.
Add note In order to gain access to this tool, go to panel Quick styles and press the button ...	Draw a circle Select the cell or cell range to be highlighted and click the oval icon. Access this button from the General Tools toolbar.
Superscript - Explanatory With this function you will be able to place a super numeric index at the beginning of a text.	Superscript - Explanatory 2 With this function you will be able to place a super numeric index at the end of a text.
Quick edit
Insert rows Inserts the number of rows selected.	Insert columns Inserts the number of columns selected.
Delete rows Deletes the number of rows selected.	Delete columns Deletes the number of columns selected.
Fill downward This tool copies all values / formulas, from one row, going down... Until it finds the first empty cell in the cell below to the left.	Fill rightward This tool copies all values / formulas, from one column, towards the right... Until it finds the first empty cell in the cell above.
Fill the highlighted range This tool quickly fills a selected range with the data found in the first row / column / cell, respectively.	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.
Paste formatting This option copies all the formats of a given range / cell, to another range, as indicated.	Paste formulas This function copies formulas from one range to another.
Paste values... This function copies values from one range to another.	Autoformat This tool will find and format the following kinds of cells.
Quick edit2
Add any Mathematycal Operation Many times we wish to change or add a formula to a value or to a cell, or part of another formula...	Cell's math with selected cells You may want to do some math only with selected cells in the active worksheet.
Advanced Transposer This tool transposes the data selected in the indicated range. Have a look at the example ...	Change reference style You can change a formula's reference style.
Exact formula copier Excel, when copying formulas, does it with relative references, so the formulas change.	Change Sign This useful tool allows you to change the sign of a range or cell containing formulas or values.
Quick references changer With this tool you will be able to modify in your formula the references towards a determined cell by references towards other specific cell.	Swap Ranges This tool allows you to interchange data contained in two ranges, in a simple manner...
Copy Range as Link This useful tool allows you to paste a cell range to get linked to the original range. When Excel pastes ...	Custom cells alignment Customize cell alignment to right or to the left with this tool
Formulas [ Fx ]
Cut as values This useful tool makes it possible to cut a range of cells containing values and formulas; to then paste it to another area, but only as values.	Flip Cells This interesting tool permits the interchanging of values of a selected range. In other words, the value of the first cell is positioned ...
Swap % to Number Whenever we apply the percentage format to a range, using the tool available in Excel, we notice that the ...	Change to Text \| Number It is often the case that we wish to convert numeric values into text, to then perform certain calculations using the same values which have been converted to text.
Formulas to Values This useful tool converts all formulas of a selected range into values, in the simplest possible way: a single click.	Select by Format This tool selects cells of a given range, but only taking into account those with a given format. Consider the following example ...
Add / remove text Remove text from the left or the right. Also you could add text from the beginning ot the end.	Add / text as number format Use the Add Text as Number Format to have numbers with letters combinations.
Quick Matematics Can you imagine how useful it would be to have a dialogue box that would allow you to perform on the spot calculations?	Formula's Error This useful tool detects whenever one enters data that will cause an error in the formula.
Superscript / Underscript Get exponents written with this tool, either at the beginning or at the end of a stream of characters.
Wizards [ W ] - Analytical tables
$Cell's Math by Format$ Cell'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. The following database will be ...	Cells Math by Logical Criteria This useful tool performs mathematical calculations (adding, counting, finding highest, etc.), using cells that meet a given criteria (greater than, less than, equal to, etc.)....
Cells math by logical criteria - models After having entered the data required by the dialogue box, we can save this model for future needs.	Cell's math by format - models After having entered the data required by the dialogue box, we can save this model for future needs.
Categorize database Use this practical tool to categorize records in a database, based on a category table.	Multiple 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...
Conditional Text Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified...
Wizards [ W ] - Consolidation tools
Math between sheets This useful tool allows you to make in a simple way, many arithmetic operations at the same time between spreadsheets.	Consolidator This useful tool makes easy the process of to consolidate information proceeding from ...
Detailed Consolidation This type of consolidation is appropriated if you want to see the detail along with the totals Let's illustrate this ...	Spreadsheet Goal Seeker The cell or range that you want to change is called: Define the cell/range to change . This item must always contains a formula or a function...
Breakeven Let's build a breakeven (no earnings nor losses) of a specific business. e.g. We want to calculate how many units of each product we need to sell in order to ...	Models Panel Execute all models we may have previously saved with any of the following tools: Spreadsheet goal seeker Consolidator ...
Waited Average This practical tool allows you to find the weighted average of a set of values. Let us see the following	Conditional Sum & Count This useful tool allows you to sum and count data regarding to conditions specified in a criteria table...
SumIF In order to understand the SUMIF option functionality, Think about the following situation....	CountIF In this case, we have a table with the names and the score of each one of them, also a criteria table.
Concatenate Cells Do you wish to join text of many cells to a single cell? Simply do this...	Indirect reference This is a very useful tool. You can use to get/refer the value in a cell in terms of its location relative to another one.
Intersect Wizard intersect is the tool that searches for a table's intersections. There are two cases with regard to intersections ...	Multiple IF Have you ever tried to build a formula containing several embedded IFs? Complicated, right?
Quick Fill Quick fill is the tool that allows you to fill ranges with consecutive values, in a simple manner. Let us see an illustrative example ...
Audit - Analysis
Chart analysis This tool allows us to make graphical comparisons In a twinkle, about data series, using charts.	Formula's translation This tool enables us to view formulas in a different, friendlier manner.
Name Manager This tool allows you to perform a series of operations with the named ranges. Many times workbooks have erroneous names ...	Decompose Formula Many times we would like to determine the origin of each of the cells forming part of a formula....
Error's Tracker This tool is meant to make up for the errors of Excel's Trace Error tool. Excel has a tool called Trace Error, which, to ...	Circular Reference Tracker This tool was designed to track circular references. In other words, Many times, in our models there are circular references which we do not know where they came from.
Link Manager This useful tool allows you to perform a variety of operations with the external and internal links with a ...	Compare ranges With this tool you will be able to make comparison of formulas and values of the datas of a range.
Easy search This is a useful tool that has been designed to make searching in a data range both simple and efficient.	Easy search - By text The selected range is automatically detected as the search range. If that is not the range to be searched, you may choose another ...
Easy search - By format 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 criteria Click on the Easy Search button in the toolbar. The selected range is automatically detected as the search range ...
Miscelaneaus
Trace Multiple Precedents This tool shows all origin links which may exist between formulas of a selected range. To use this tool, do as follows ...	Trace Multiple Dependents This tool shows any and all dependence links which may exist between formulas of a selected range...
Erase Auditing Arrows This tool bar option erases all origin and/or dependence link arrows from the active sheet...	Cell's Reference Tracker This versatile tool allows you to navigate between the cells which originate and/or depend on a ...
Model Navigator - Panel Workbooks are often very extensive –and sometimes you will be interested only in checking the value of certain cells.	Cell's reference tracker - Panel This versatile tool allows you to navigate between the cells which originate and/or depend on a cell under observation.
Cell's watcher - Panel Do you need to select important cells in your model? Use this powerful tool to select and manage them.	Cells watcher Do you need to select important cells in your model? Use this powerful tool to select and manage them.
In block formula's analyzer This utility as it´s name indicates, allows us to analize in a specific range, a group of formulas and all the.....
Document
Eliminate comments of the selected range Unlike Excel, which only eliminates comments from the active cell, this tool allows you to .....	Show/hide all comments Displays any comments hidden in the selected range.
Change comments color This tool allows us to change the comments background color.	Manage Comment With this function you can manage workbook’s comments.
New comment Adds a new comment to the active cell.
Document - Tools settings
Camera and Camera settings There are two option buttons in the Camera Tools frame: Excel's image and Dynamic.	Format currency Use this tool to apply format of currency to a range of cells.
Format number Change the format of your numbers using the Format Number tool . Click many times to see other types of number formats.	Format percentage Change the format of your numbers using the Format percentage tool . Click many times to see other types of number formats.
Format date Change the date formats easily using the Format Date tool . Click many times to see other types of date formats.	Guides This tool is specially convenient if you want to navigate throughout databases with records or fields stretching beyond the screen.
Set alarm Use Set alarm to receive a reminder if you have a meeting or need to do something special.	Change color palette This tool will allow you to change Excel's color palette, making it possible for you to have fresh colors with a more professional and personalized tone.
Copy Color from another book You can copy the customized colors from another open book.	Arithmetical calculator This useful arithmetical calculator, in addition to performing the most common calculations, makes it possible for us to copy data from a cell in the active sheet.
Show Rebuild arrays This small but very useful tool bar makes it possible to create arrays in the simplest possible manner.
Charts - labels - Images
View active book charts Allows visualizing the graphics in the active book.	Add label Add labels to your charts with this tool, either to them all or to selected ones.
Move label Use this tool to move the labels already posted in a chart.	Add images Add images to series points in your charts with this tool.
Resize charts Resize your charts with this tool –e.g. make them all the same size	Export to This tool allows you to export as an image any part or section of the spreadsheet that you previously selected.
Copy & paste chart format The following example shows how to use Copy & Paste chart format tool.	Save chart format To save a model select a graphic, place a name and description and finally click on the "Save chart's formats" button.
Tools
Resize charts Resize your charts with this tool –e.g. make them all the same size	Sheets Manager Your workbooks have so many sheets you find it hard to manage them? Use Sheet Manager - A comprehensive tool that ...
Easy Print This tool makes printing and previewing Areas, Charts, Views easier ...	Toggle Settings We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook ...
Freeze \| 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 ...	Arrange Windows Do you wish to browse several workbooks at the same time? Or better yet: do you want to check different parts of a workbook at the same time?
Document
Add to Recents File's List If you are using MS Excel, you add the document to the recent MS Excel list ...	Erase History of Files Select the options you want to clear and press the OK button. Clean History is available using the Fast Close ...
Fast Close Use the Fast close Button to save/close open workbooks with a single click. Save your work if you have a meeting immediately!!!	Fast close Settings Workbook to Show: Select a workbook to show when the Fast Close Button is chosen.
Show Recalc all open books bar This extremely useful option allows - in a single click - to recalculate all workbooks opened.	Workbooks Manager Managing your open workbooks is made easy with the Workbook manager tool. With this tool you can: ...
Model navigator You can add and/or remove the cells you wish to and from the Model Navigator dialog as follows...	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.
Version manager With this tool you will be able to check the progress of your projects.	To Do List This useful tool allows you to manage any pending tasks related to a given workbook that may be key to your projects, in an ordered manner ...
Password list Use Password list to view/add/delete/edit your password for MS Excel and MS Word files.	Password list settings Use Protection Configuration to add different types of passwords protection to your file.

Consolidator Model Builder	Multisheets consolidator Builder

My favorites - Permission on Windows Vista	Advantages

Add any math action	Formula error

Cells References Tracker	Auditor Spreadsheet Map

Chart Analysis	Auditor Trouble test

Categorize Database	Circular references

Error Tracker	Link Manager

Name manager	Toolbars (set 1)

Toolbars (set 2)

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

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	$99.95
2 to 5	$84.95
6 to 9	$74.95
10+	$49.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!

* First Name:
* Last Name:
* Company:
* Number of licenses:
* Country:
* Telephone:
* E-mail:
Write us a message:

Spreadsheet Model Builder

Spreadsheet Model Builder

Excel

OFFICE ADD-INS

OTHER TOOLS