Updates by email
Google Reader (or any RSS)
Follow us on Twitter
Like us on Facebook
Circle us on Google+
Recent Comments
- comcube technologies calicut on Make Versus Buy for Your Next Spreadsheet
- Cap table on Battle of the Capitalization Tables
- Ellsworth Hermandez on Come to a Determination Accordingly
- Tasha on Sales Forecasting Without Tears
- Colin Warwick on Avoid These Five Mistakes When Planning and Tracking Sales Commission
-
Recent Posts
Press Releases
Archives
Categories
- About ModelSheet
- Activity-Based Budgets
- Applications
- Authoring
- Business
- Capitalization Tables
- Case Studies
- Cash Flow Analysis
- Collaborating Authors
- Consulting Services
- Decision Support
- Economics
- Education
- Finance
- Financial Plans
- Marketing & Sales
- Marketing Effectiveness
- Operations Analysis
- Other Applications
- Price Elasticity
- Pricing Tests
- Product Profitability
- Sales Planning
- Spreadsheets
- Templates
Monthly Archives: August 2009
Layout that Makes Data Entry Easier
We changed the layout of input data tables on in the the financial plan templates to facilitiate pasting in larger blocks of data in a block. The new layout excludes subtotals for time periods (such as annual subtotals) and for … Continue reading
Posted in Cash Flow Analysis, Financial Plans, Sales Planning, Templates
Tagged layout, Usability
Leave a comment
Sales Plan Spreadsheet Application
We are offering a family of customizable templates for sales planning and forecasting. The basic idea is to combine managers’ sales targets with historical data: the managers’ targets dominate the sales plan, and the historical data provides information that may not be … Continue reading
Posted in Sales Planning, Templates
Tagged sales forecast, sales forecasting, sales history, sales plan, Sales Planning, sales targets
Leave a comment
Capitalization Table Customizable Spreadsheet
Every business must track investments made, and capitalization tables are usually the best tools for the job. A typical company takes investments in several investment “rounds”, by selling various types of securities that confer different trading rights and payout rights to … Continue reading
Fun with a 216 MB Excel Template
A f ew weeks ago we delivered a 216 MB financial plan template to a customer. This is the largest Excel workbook I have ever used. (This is the size of the xls file; the xlsx file is smaller.) Tools … Continue reading
Posted in Financial Plans, Spreadsheets, Templates
Tagged large spreadsheets, performance, spreadsheet performance
Leave a comment
Measuring Marketing Program Effectiveness
You may have heard the joke that “only half of our marketing spending is effective; we just don’t know which half.” Measuring program effectiveness quantitatively was just a dream of marketers, until increased computer power, data and improved algorithms made … Continue reading
Sales Funnel, Qualified Leads and Order Backlog in Financial Plan Template
Last week we added an optional sale funnel model to the financial plan template. The funnel model has a level of detail that is right for a business unit financial plan. The model tracks two stocks of potential sales. qualified leads … Continue reading
Posted in Financial Plans, Templates
Tagged Financial plan, order backlog, qualified sales leads, sales forecast, sales funnel, sales plan
Leave a comment
Direct Labor Detail in Financial Plan Template
We have upgraded the financial plan template to include more detailed models of direct labor as optional features. The basic direct labor model tracks only direct labor cost per production unit and total direct labor cost, without tracking types of … Continue reading
Product Support Contracts in Financial Plan Template
We recently upgraded the main financial plan template and model to include annual customer support contracts. Customer support contracts are commonly sold by vendors of hardware and software products. The model of support contracts segments support by product. It includes … Continue reading
Decision Support Spreadsheet Application with Uncertainty
ModelSheet Software offers a free sample decision support model that accommodates any number of weighted decision criteria and any number of decisions alternatives. It does the obvious computation: it computes the weighted average of the scores for the various criteria … Continue reading
Usability Features in ModelSheet Customized Templates
To improve usability, each of our customized Excel templates has A user guide that contains general instructions and suggestions An Excel comment on just about every variable table in the workbook that explains meaning and usage, and a glossary of … Continue reading →