Modeling ToolPack -- Frequently Asked Questions and Answers
Topic Overview: What is Modeling ToolPack - Technical Requirements
Installation / Activation: How do I get Modeling ToolPack - How do I activate Modeling ToolPack
Getting Started: Best way to get Started - Help
Modeling ToolPack Tools: AutoColor
Temporarily Disabling Modeling ToolPack: How to Temporarily Disable Modeling ToolPack
Uninstallation: How to Uninstall Modeling ToolPack
Index of Resources: List of Resources
What is Modeling ToolPack?
The Modeling ToolPack gives financiers the power to generate the components of a spreadsheet analysis in a single step. Automatically insert growth drivers, price/volume buildups, lookup tables, and other spreadsheet staples in seconds -- or use DealMaven's formula bar to view complex formulas in terms of the finance concepts they employ. An array of flexible features makes Modeling ToolPack essential to both the creation and the understanding of financial documents in Excel.
Modeling ToolPack runs within Microsoft Excel and appears on Excel’s main menu toolbar. Each Modeling ToolPack tool is available from the ‘Modeling ToolPackàTools’ menu.
Click here for more detailed information on Modeling ToolPack’s features.
What are the Technical Requirements for Modeling ToolPack?
Machine
· IBM-compatible PC, 266 MHz or higher with a Pentium II or higher CPU
· 64 MB RAM recommended minimum. More RAM generally improves performance
· 40 MB available hard disk space (includes 14 MB of optional help files and 10 MB of temporary installation files
· Internet connectivity
Software
· PC: Windows NT 4.0 SP 3+ or Windows 98, 2000, or XP; Macintosh: Virtual Windows
· Microsoft Excel 97 or higher
· Internet Explorer 5 or higher
Installation / Activation
How do I get Modeling ToolPack?
Click here to download a copy of Modeling ToolPack.
Then simply follow the installation prompts and presto! – Modeling ToolPack‘s welcome message should automatically appear the next time you open Microsoft Excel along with a “Modeling ToolPack” menu on Excel’s main menu bar. (If you don’t see Modeling ToolPack, contact our support team for assistance.)
If you encounter any problems during installation or simply want more information about the installation process, please visit our DealMaven Product Installation forum.
New users automatically receive a 60-day free trial of the Modeling ToolPack. The product will warn you when your free trial is about to expire.
Once the trial period is up, you’ll receive an expiration message each time you open Excel or attempt to use any of Modeling ToolPack’s features. To use Modeling ToolPack after the trial period, you’ll need to activate your copy of the product as detailed below.
How do I activate Modeling ToolPack?
If you’ve purchased Modeling ToolPack for Excel, please follow the DealMaven Product Activation instructions to activate the product. If you’re receiving expiration messages and wish to continue using Modeling ToolPack, click here to purchase it.
If you have difficulty activating your copy of Modeling ToolPack or want to know more about the activation process, please visit our DealMaven Product Activation forum. If you can’t find the answers you’re looking for there, you can also contact our support team for assistance.
Getting Started
What’s the best way to get started using Modeling ToolPack?
We realize it may be daunting the first time you try and use Modeling ToolPack, therefore, we’ve developed three primary resources to aid you:
- ‘Modeling ToolPack àTools’ menu: Lists all of the product’s tools by category
- Examples workbook: Select the ‘Examples Workbook’ option from the ‘Modeling ToolPack’ menu in Excel to see every tool in action and try them yourself. Like the ‘Tools’ menu, the Examples workbook categorizes tools by tab and offers a helpful ‘Getting Started’ section. Running through the entire workbook can take as little as 15 minutes and is a great way to see everything Modeling ToolPack has to offer.
- Reference guide: This printable PDF contains an overview of the product and instructions on how to get started with the product’s top time-saving tools. We recommend that you print it on one double-sided page for easy desktop reference.
Where can I find in-depth help documentation and other technical support for Modeling ToolPack?
You can access Modeling ToolPack’s full help documentation at the bottom of the ‘Modeling ToolPack’ menu in Excel. Context-sensitive help for Modeling ToolPack is also available from forms within the application by clicking the question mark in the form’s upper-right corner and then selecting the area of interest on the form.
Additional assistance is available through this forum or by contacting our support team.
Modeling ToolPack Tools
When I type in Excel, the font color of cells automatically changes sometimes. What is happening?
Color-coding cells based on their content is a very important Excel technique that helps you quickly identify where the inputs, values, and formula links are in your spreadsheet. This technique can be very time-consuming and error-prone when done manually.
AutoColor is a Modeling ToolPack feature that automatically color-codes cells based on their content as you work in Excel.
To enable or disable this feature, simply select the “AutoColor On Entry” item under the main Modeling ToolPack menu in Excel (you can tell if the feature is currently enabled by whether or not this menu item is checked). You can also fine-tune your AutoColor settings and preferences by selecting the ‘Modeling ToolPackàOptions…’ menu option.
Files with a circular reference or numerous data tables take even longer to calculate when Modeling ToolPack is installed. How can I remedy this?
Modeling ToolPack’s AutoColor feature automatically color-codes inputs and formulas as you work in Excel. Normally, the time lag from AutoColor is imperceptible. However, with data tables and/or circular references, you may find the delay magnified. To avoid this delay, you may wish to set calculation to “Manual” (‘ToolsàOptions’ menu option in Excel) while working in a spreadsheet with data tables (or see above to learn how to turn off AutoColor).
Temporarily Disabling Modeling ToolPack
How do I temporarily disable Modeling ToolPack?
To temporarily disable Modeling ToolPack, open Windows Explorer and browse to the ‘C:\Documents and Settings\USERNAME\Application Data\DealMaven’ folder, where USERNAME is your Windows username. (If you don’t see the “Application Data” folder then you need to enable hidden folders. Simply go to ToolsàFolder OptionsàView and select ‘Show Hidden Files and Folders, then click ’OK’ to exit. Also, if the ‘DealMaven’ folder does not exist, go ahead and create it). In this folder, right-click and select ‘NewàText Document’ to create a new file named ‘ModelingToolPack_OFF.txt’. The next time you open Microsoft Excel, Modeling ToolPack will not load.
To re-enable Modeling ToolPack, simply rename or delete the aforementioned file.
Uninstallation
How do I uninstall Modeling ToolPack?
To PERMANENTLY uninstall Modeling ToolPack:
- Close Excel.
- In Windows, select ‘StartàControl PanelàAdd or Remove Programs’.
- Select DealMaven Modeling ToolPack for Excel from the list and remove the program.
Please contact our support team if you require assistance.
Index of Resources
Modeling ToolPack Product Page: Learn about Modeling ToolPack, view demonstrations of the product’s key features and concepts, read testimonials, and purchase the product from this web page.
Modeling ToolPack Reference Guide: This printable PDF contains an overview of the product and instructions on how to get started the product’s top time-saving tools. Prints on one double-sided page for easy desktop reference.
Product Installation Instructions: This forum post has detailed instructions on how to install all DealMaven products.
Product Activation Instructions: If you’ve purchased a subscription or a permanent license for Modeling ToolPack, go to this forum to get instructions on how to activate your copy of the product and use it beyond the 60-day trial period.