Thursday, October 7, 2010

Spreadsheets Direct | Expert Excel Custom | Business Spreadsheet & VBA Freelance Consultancy Service

Spreadsheets Direct

Spreadsheets Direct is an Excel spreadsheet consultancy business based in the UK trading since July 2007. Spreadsheets Direct can provide quality professional Excel files, improvements to your existing files and data analysis at competitive prices.
Improve your business spreadsheets with the use of VBA and high level Excel techniques. Spreadsheets Direct can save you hours by automating your daily processes. Files can be updated with a simple click of a button saving you time and money.

INVESTMENT-CALC PRO for IRR & NPV Solutions

INVESTMENT-CALC PRO for IRR & NPV Solutions
This complete collection of Investment Return workbooks now comes with free document and spreadsheet connectivity as well. Spreadsheet connectivity will help you share spreadsheets more effectively.
Includes a 30 page Guide fully explaining all the calculations and equations required for time based value of investing. Includes Quick IRR - NPV spreadsheets and Future Values.
Investment Appraisal simulations. This spreadsheet will run 3,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.
The library of investment analysis spreadsheets incorporate present value beyond the cash flow forecasting horizon. With our quick and easy to use spreadsheets terminal values are automatically added to project net worth and included in the real return on capital values.
Quick calculation of your firms cost of capital using beta risk look up values from the database included within the workbook. Your firms or your project cost of capital is the real discount rate to apply to all net present value spreadsheets.
Synergy Value schedule calculates the economic and net present value of the financial benefits of an acquisition or merger.
Insurance buy out schedules value any bond to its terminal value.
This workbook includes lots of Present values calculators, and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, and present value of periodic investments.
Quick NPV and IRR spreadsheets provide present values and IRR of any project for up to 40 years
Plus rate of return of investment portfolios with any buy/sell patterns.
New Excel Finance Spreadsheets for Investment Cash Flow Forecasting – NPV & IRR

Investment-Calc Solutions for IRR & NPV

Investment-Calc Solutions for IRR & NPV
This complete collection of Investment Cash Flow workbooks for NPV & IRR Solutions includes:
30 page Guide fully explaining all the calculations and equations required for time based value of investing. Includes Quick IRR –NPV spreadsheets and Future Values.
Investment Appraisal simulations. This spreadsheet will run 3,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.
The library of investment analysis spreadsheets incorporate present value beyond the cash flow forecasting horizon. With our quick and easy to use spreadsheets terminal values are automatically added to project net worth and included in the real return on capital values.
Quick calculation of your firms cost of capital using beta risk look up values from the database included within the workbook. Your firms or your project cost of capital is the real discount rate to apply to all net present value spreadsheets.
Project cash flows rate of return targeting using Excel Goal Seek. Adjust any individual income/cost/sale/recovery forecast and drive your project to the desired rate of return.
Synergy Value schedule calculates the economic and net present value an acquisition or merger.
Insurance buy out schedules value any bond to its terminal value.
This workbook includes lots of Present values calculators, and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, and present value of periodic investments.
Quick NPV and IRR spreadsheets provide present values and IRR of any project for up to 40 years.
FILE CONVERSION. Convert Excel, Word files to pdf documents without any requirement for Acrobat using our web software add https:// web inks for safe secure document transmissions. Converts PowerPoint 2003-2007 to Flash presentations.
Zip file download or select CD edition shipping. Investment-Calc will run in Excel 2003-2007 and Excel 2008.

Inventory Manager PRO For Excel

Inventory Manager provides manufacturing and operations decision support for inventory management and scheduling with Excel. Maximum 10,000 inventory items capacity.

Determine the best inventory re-order schedules (includes safety stocks), optimize the lowest cost re-order quantities, establish ordering frequencies and lot sizes, receive alerts when you need to re-order, includes seasonality, trends and forecasting, quality control inventory analysis. Improve efficiencies and enhance customer service with INVENTORY MANAGER PRO.
  • You can establish which inventory items should be re-ordered on a daily basis with INVENTORY MANAGER.
  • You can establish least cost ordering quantities with INVENTORY MANAGER taking account of storage costs, administration of purchasing costs and the cost of finance.
  • You can create Excel lists of inventories in categories and storage locations.
  • You can export inventory lists from QuickBooks (and Quattro Pro and barcode readers which interface with Microsoft Excel) to create your own inventory management control system which will include supplier delivery lead time, re-order quantities, safety levels.
  • When you want to evaluate buying inventory in larger quantities to gain volume discounts, use INVENTORY MANAGER to determine the inventory level s for each product item that will deliver profit gains after storage costs are taken into account.
  • Analyze quality control data of incoming stock with INVENTORY MANAGER Statistic spreadsheets.
  • Generate re-order schedules for all stock items.

Worked examples and full guidelines provided in a separate demo tutorial version download.

Seeking help to raise business finance? The CD edition provides the following extra document files:
  • Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital.
  • Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes.
  • Share subscription agreements are supplied.
  • Help provided for non US companies how to structure an offering to secure finance.
  • Popular with start ups, franchises, entrepreneurs and small businesses.
  • List of capital sources supplied.

Cash Forecasting plus Leases Organiser - Cash Forecasting, Credit Controls, Scheduling

Cash Forecasting plus Leases OrganizerExcel Cash forecasting and management spreadsheets provides:
1. Cash Forecasting – 150 days spreadsheet, auto updating forecasts daily.
2. Cash Solvency Predictive Ratios
3. Cash Management spreadsheets
Cash forecasting spreadsheet provides a quick and easy way to transfer payable, receivable and fixed obligations into Excel, set aging days and Excel places each item into the exact day of settlement to forecast rolling cumulative cash flows.
Invaluable as cash forecasting spreadsheets.
Cash Solvency Prediction Spreadsheet. Need to know if your suppliers, customers, applicants for credit are financially strong or weak, use this workbook to analyze their strengths with built in Altman and Ohlsen formulae.
Cash Management. Manage payable, receivable accounts, invoice and settlement dates to calculate your forward working capital requirements.
Extra: Lease Organizer for Excel will manage all your leases for you.

Business Solvency & Financial Ratios 2008

You can run quick and easy checks on the solvency of companies you rely on to deliver services to you and to buy from you using this Business Solvency & Financial Ratios 2008 workbook.

Business Solvency:

The Business Solvency & Financial Ratios 2008 workbook employs all the multivariate analysis equations published by Edward Altman. Altman is the Max L. Heine Professor of Finance at the Stern School of Business, New York University.

In the workbook supplied you can simply enter two comparative sets of financial data for any company (including your own). The Altman Z scores are readily computed using the multivariate formulas provided by Professor Altman.

Bonus Addition:

Financial Ratios with Excel

Windex 2008 calculates all major financial ratios in Excel.

Calculates these financial ratios from balance sheet, income statement and cash flow templates provided:
  • Rate of Return on Assets (ROA)
  • Rate of Return on Common Equity (ROE)
  • Return on Capital (ROIC)
  • Common Earnings Leverage
  • Cash Flow from Operations/Total Cash Flow Ratio
  • Cash Flow from Investments/Total Cash Flow Ratio
  • Cash Flow from Financing/Total Cash Flow Ratio
  • Operating Cash Flow/Current Liabilities Ratio
  • Operating Cash Flow/Total Liabilities
  • Operating Cash Flow/Capital Expenditures
  • Working Capital/Current Liabilities Ratio
  • Working Capital/Long Term Liabilities Ratio
  • Working Capital/Total Debt Ratio
  • Working Capital/Current Assets Ratio
  • Working Capital/Total Assets Ratio
  • Income Tax Expense/Revenues Ratio
  • Total Assets Turnover Ratio
  • Fixed Assets Turnover
  • Current Ratio
  • Acid Test (See note for Quick Ratio)
  • Accounts Payables Turnover
  • Days Accounts Payables outstanding
  • Accounts Receivable Turnover Ratio
  • Days Receivables Outstanding Ratio
  • Inventory Turnover
  • Days Inventory Outstanding
  • Total Debt to Equity Ratio
  • Total Debt Coverage ratio
  • Long Term Debt Ratio
  • Long Term Debt to Total Assets
  • Long Term Debt to Shareholder Equity
  • Total Liabilities/Total Assets
  • Interest Coverage Ratio

Instant Balance Sheets Excel Templates


Instant Balance Sheets provides 12 month revenue and expense forecasts spreadsheet, linked to working capital forecasts, fixed asset purchases with monthly depreciation. Creates monthly balance sheets and cash flow forecasts from your plans.

Ideal for when you want to turn your monthly profit and loss forecasts or last 12 months data into monthly and year end balance sheets and cash flows.

Start by entering monthly inputs of Unit Volumes/Prices/Cost of Sales and Company Expenses (100 rows). There are quick and easy working capital and fixed capital forecast spreadsheets provided.

All monthly balance sheets “balance” by transferring changes occurring between successive monthly periods into the monthly cash flow spreadsheet. The cash flow schedule tracks changes for all twelve monthly balance sheets and calculates the balancing cash position at the end of each month.

If you want to transform 12 month financials (historical or forecast) into neat income schedules and balance sheets to display to management, investors, lenders, banks, use Instant Balance Sheets for really quick results.

Provides a forward looking planning suite which accepts monthly unit volume forecasts, different product prices and cost of sales for the 12 month period and a monthly company expenses forecast. You can predict sales days outstanding, inventory levels and percentage of sales supporting receivables.

Provides a demo version which shows you how everything fits together.

Budgeting Spreadsheets for Excel

A collection of Budgeting Spreadsheets for Excel (workbooks) provides 50 business finance spreadsheets plus 9 Excel Add-ins and full Excel Training Course to help you create, control and value your budgets quickly and easily. The following is a partial summary:

Master Budgets 4.6 helps you combine up to 10 department budgets quickly easily

Everything is so easy with Excel. Excel links combine separate budgets into the Master Budget. You can track your budgets with actual performance. Master Budgets reports monthly variances and year to date totals.

If you need to calculate your cash burn each day for 150 days ahead use the cash forecasting spreadsheet.

If you need to look further ahead use the Cash Flow accounting spreadsheets which make it really quick and simple to prepare a detailed monthly budget plan and forecast how your balance sheets and cash flows will look for 5 years x 12 monthly periods ahead.

You can value your company based on your budget forecasts using the valuation spreadsheet.

The CD edition provides the following extra document files:

Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital. Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes. Share subscription agreements are supplied. Help provided for non US companies how to structure an offering to secure finance. Popular with start ups, franchises, entrepreneurs and small businesses. List of capital sources supplied.

Bank & Loan Refund Software

If you think you have been overcharged for a loan, mortgage, bank account through incorrect repayment amounts or wrong interest rate, unauthorised loan insurance charges, or incorrect penalty charges this dual software package is for you.

With the Bank & Loan Account Refund package you are acquiring 2 programs that will help you challenge lenders calculations, debits from your accounts and possible asset seizures.

The two programs are CheckMyBank 2008 (Excel workbook) and Loan Amortization Manager (web software).

With CheckMy Bank you can quickly verfiy all the calculations which lead to your monthly interest charges. Compare the real ending balance totals with your actual balances and challenge your account deductions if this is justified.

Loan Amortization Manager will store up to 100 current loan account repayment statements for you. You can change any rate or payment within any loan account during its repayment period and check that the current loan balance is correct.

Five Keys To Business Success (Excel Add-Ins)


Excel add-ins provide ready made solution for forecasting, investment economics, portfolio optimization, business resource optimization and material planning.
  • Forecasting.xla. Calculates moving averages, exponential smoothing moving averaging, linear regression and seasonal trend analysis.
  • Investment Economics.xla. Calculates net present values and internal rate of return after tax for any capital investment projects. Selects projects that in aggregate meet users objectives.
  • Portfolio Optimization.xla. Optimises any investment portfolio to meet users objectives. Both business investments and securities investments are catered for.
  • Process.xla. Creates computer models to mirror business flows. Calculates the optimized scheduling of materials and resources which maximise profits. Use Process Flow to work with your line managers on each business step for scheduling the the highest optimization of scarce resources.
  • MRP.xla. Creates dynamic materials requirement planning (MRP) spreadsheets which optimizes the least cost solution for users' manufacturing requirements. Including material purchasing, defines minimum inventory levels, least cost production scheduling.
  • Free Giveaway. Business Statistics for Excel. Instant calculation of Averages, Moving Averages, Mean, Median, Mode, Range, Frequency, Seasonality Trends, Correlation, Variance, Regression formula, Significance (T-Test), Sigma and Six Sigma values, Least Squares, Best Fit Forecasting. Supression of unwanted zeros in data range, set upper and lower boundaries for calculations.

Asset & Lease Accounting With Excel

Fixed Asset Accounting workbook provides all you need to keep track of a maximum 3,000 asset depreciation records, book values and disposals with Excel 97-2003. It will save you hours of work calculating MACRS depreciation for tax purposes and deferred tax balance values for any month end date. It also includes capital lease accounting.

You can select straight line depreciation or the declining/double declining deprecation methods.

You can wind the month end back and forwards to calculate accounting depreciation, MACRS depreciation and deferred tax balances at any month end. The default calculation period is the current month end.

The MACRS depreciation rates are variable. They are set for US tax depreciation rules but you can enter any MACRS rates into the database which will apply to your calculations.

In the first workbook each asset is defined by location, accounting depreciation life, MACRS class and salvage percentage.

Individual assets can have their own unique depreciation life.

Everything is so easy with Excel. Excel links location, asset class, depreciation lives together and you can filter and sort records just anyway you want.

Disposal accounting included.

The Lease accounting section reports repayment status, interest and remaining balances for all capital leases at any month end. Lease terms can include pre-payments and final balloon payments.

The Zip download is a 6.67 MB file. After downloading unzip the three Excel Asset Accounting workbooks including the tutorial edition. The MACRS accounting is provided in a separate workbook (No: 2). CD shipping is also an option.

Financial Statement Forecasting PRO

When you need a quick snap way to create your financial statement forecasts for your senior managers, bank manager or investors, use Financial Statement Forecasting PRO.

Financial Statement Forecasting PRO enables you to set up a 12 month forecast of your financial statements starting at any month of your choice. As well as calculating monthly balance sheets, income statements and cash flows (source and application of funds) the workbook outputs all key operating, financial and shareholder ratios and financing covenant ratios.

Plus the FinExcelSoft 10 year financial statement forecasting workbook.

Quick and simple to use. No accounting knowledge is required.

Financial Ratios with Excel


Windex 2008 calculates all major financial ratios in Excel from balance sheet, income statement and cash flow templates provided:
  • Rate of Return on Assets (ROA)
  • Rate of Return on Common Equity (ROE)
  • Return on Capital (ROIC)
  • Common Earnings Leverage
  • Cash Flow from Operations/Total Cash Flow Ratio
  • Cash Flow from Investments/Total Cash Flow Ratio
  • Cash Flow from Financing/Total Cash Flow Ratio
  • Operating Cash Flow/Current Liabilities Ratio
  • Operating Cash Flow/Total Liabilities
  • Operating Cash Flow/Capital Expenditures
  • Working Capital/Current Liabilities Ratio
  • Working Capital/Long Term Liabilities Ratio
  • Working Capital/Total Debt Ratio
  • Working Capital/Current Assets Ratio
  • Working Capital/Total Assets Ratio
  • Income Tax Expense/Revenues Ratio
  • Total Assets Turnover Ratio
  • Fixed Assets Turnover
  • Current Ratio
  • Acid Test (See note for Quick Ratio)
  • Accounts Payables Turnover
  • Days Accounts Payables outstanding
  • Accounts Receivable Turnover Ratio
  • Days Receivables Outstanding Ratio
  • Inventory Turnover
  • Days Inventory Outstanding
  • Total Debt to Equity Ratio
  • Total Debt Coverage ratio
  • Long Term Debt Ratio
  • Long Term Debt to Total Assets
  • Long Term Debt to Shareholder Equity
  • Total Liabilities/Total Assets
  • Interest Coverage Ratio
  • Altman's Z (Solvency) Ratio.

Excel Add-ins & Training Bible Complete Collection


Nine Excel add-ins plus the Complete Excel Training Bible modules 101-701.

Plus Free Workbook Bonus - Learn how to develop your own Excel Currency Converter with this extra free workbook.

Convert any of your financial records or lists into any one of 81 cross currency exchange rates updated via the Excel import function – In today’s environment of volatile exchange rates, instant recalculation into your home currency from different currencies is an essential tool.

Free workbook with the Combined Collection.

FASTPLAN Version 9.6

FastPlan version 9.6 provides a complete five year financial plan incorporating monthly fixed asset schedules with depreciation spreadsheets, 60 x monthly sales forecasts for multi products, forecast expenses, share capital inputs, three loan notes providing monthly interest charges and declining loan balances, plus working capital forecasts to generate five annual and monthly balance sheets, income statements and cash flow forecasts with supporting financial ratios and five years financial summary overview. With FastPlan you can quickly and easily change any variable input and drive the financial statements and cash flows to your target goals. No accounting knowledge is required.

Plus three separate and additional workbooks.
  • Twelve months income statements, balance sheets and cash flows forecasting spreadsheet to develop high - low forecast scenarios to analyse your sales, profits, accounts receivable, accounts payable and total cash flows for each year for all possible outcomes.
  • Sales and Profits Risk Forecasting using Monte Carlo formulas.
  • Forecasting Risk analysis (probability of reaching goals) using Monte Carlo formulas.
FastPlan and the three additional bonus workbooks all run in Excel 2003-2007.

Wednesday, October 6, 2010

Excel Skills Pack - COMPLETE MICROSOFT EXCEL CORE KNOWLEDGE PACK


Core fundamentals 1. Keyboard functions, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function.

Core fundamentals 2. Improved working with Formulas, Worksheet Formulas, Extracting Data for Decision Making, Data Validation, Importing external data. Core fundamentals of Advanced Filters, AutoFilters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining.

Core fundamentals 3. Learn Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files, Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the Web, Macros 1, Macros 2.

Plus Core Knowledge chapters 4, 5, 6 and 7 VBA and Macro developments.

Special Bonus: Excel Add-Ins improve your spreadsheets presentations and reduce your spreadsheet working hours.
  • Duplication Manager
  • Formula Manager
  • Number Manager
  • Text Manager
  • Excel Plus
  • Named Range Manager
  • Formula Reference Changer
  • Sheet Index Creator
  • File Size Reducer Download or CD shipping.

Excel Costing 2010

Excel Costing 2010 provides new and free document and connectivity software for Excel spreadsheets : Spreadsheet connectivity will help you share financial more effectively.

The standard costing workbooks include:
  • Standard costs, activity based costs, overhead cost recovery ratios, cost drivers, absorption costs and cost allocation ratios in Excel.
  • Complete range of product costing formula with eight ready to use costing templates iin the first workbook with Excel costing formula provide unit costs for pricing and profit recovery calculations.
  • Excel database supplies accurate costs into costing formula.
  • Benchmark costing ratios.
  • A – Z spreadsheets for Marginal costing - Standard costing – Activity based costing – Cost drivers – Absorption Costing values and Most economic quantity.
  • Formula and equations each step of the way.
  • Incorporate risk analysis of reaching your gross profit margin goals when customer spending patterns change and these changes impact your unit costs. Runs Monte Carlo simulations of the most probable outcomes and returns the probability of achieving whatever target is set.

FastPlan 2010 Five Year Company Forecasting

FastPlan version 9.6 provides a complete five year financial plan incorporating monthly fixed asset schedules with depreciation spreadsheets, 60 x monthly sales forecasts for multi products, forecast expenses, share capital inputs, three loan notes providing monthly interest charges and declining loan balances, plus working capital forecasts to generate five annual and monthly balance sheets, income statements and cash flow forecasts plus all core ratios and five years financial summary overview.

With FastPlan you can quickly and easily change any variable input and drive the financial statements and cash flows to your target goals.

No accounting knowledge is required.

Plus three separate and additional workbooks.
  1. Twelve months income statements, balance sheets and cash flows forecasting spreadsheet to develop high - low forecast scenarios to analyse your sales, profits, accounts receivable, accounts payable and total cash flows for each year for all possible outcomes.
  2. Sales and Profits Risk Forecasting using Monte Carlo formulas.
  3. Forecasting Risk analysis (probability of reaching goals) using Monte Carlo formulas.
FastPlan and the three additional bonus workbooks all run in Excel 2003-2007.

Excel Add-Ins File Collection

With this powerful Excel Add-Ins File Collection for Microsoft Excel you enhance your Excel with extra capabilities that are well beyond standard Microsoft Excel features:
  • Add page indexes to link all spreadsheets together.
  • Add Reminder notes. Like those little yellow pads, bring reminders messages into your Excel at preset times and dates.
  • Add formulas list with links to each formula cell.
  • Manage cell ranges with more options than provided by Microsoft.
  • Convert imported numbers to true Excel formats.
  • Hide zeros, Hide text, hide numbers, hide negatives, hide positives with one click.
  • Create one year Excel 365 days calendars.
  • Manage List duplicates, number formats and equations much more efficiently and make Excel work faster for you.
  • Convert vertical number sequences into horizontal rows with one click.
  • Copy data to a different part of your spreadsheets keeping the orginal cell references. the same
  • File size reduction to save disk space.

Excel Scheduler

Project Management, Gantt Charting, and Employee Scheduling - For all versions of Microsoft Excel. To run Excel Scheduler, simply run Excel and read in template(s) of choice.

Project Management:
  • CPMDAILY.XLS
  • CPMHOUR.XLS
  • CPMWEEK.XLS
Gantt Charting
  • GANTDAY.XLS
  • GANTHOUR.XLS
  • GANTWEEK.XLS
Employee Scheduling
  • DAYSOFF.XLS

Operations Manager

Operations Manager contains 35 templates for manufacturing and operations decision support. All templates have a simple, consistent interface and include an actual application. Runs with Excel, Lotus & Quattro Pro.

Benefits include:
  • adjust for seasonality and predict trends,
  • optimize economic order quantity,
  • determine best inventory (includes reorder points & safety stocks) and workforce levels,
  • improve production throughput and enhance customer service.

Resource Manager for Excel/FULL

Resource Manager for Excel/FULL contains the functionality of high-end systems, without the complexity and expense. An add-on for existing systems, or stand-alone, Resource Manager adapts to your specific needs.

Key features include:
  • Easily integrates with all systems
  • General purpose resource management tool for projects that contain any combination of people, materials, and equipment
  • Dynamic finite capacity analysis
  • A great stand alone scheduler
  • Priority Scheduling
  • Costing & estimating
  • True Windows GUI
  • Inventory Management & MRP
  • Excel Integration
  • Planning
  • Rough-cut capacity planning
  • Bills-Of-Material/Resources containing material, workcenters, & labor requirements.

Spreadsheet QC

Spreadsheet QC is a collection of templates for use with Excel, Lotus & Quattro Pro. It is ideally suited for small operations which are just beginning to implement quality improvement programs, as well as for large operations, to complement existing Total Quality Management systems, for flexible, ad-hoc reporting and individual training. By automating the main techniques in a familiar spreadsheet format, Spreadsheet QC makes statistical process and quality control more accessible.

Spreadsheet Scheduler by User Solutions, Inc.


Low cost and easy-to-use spreadsheet templates for Project Management, Scheduling Customer Jobs and Employees, Generating Calendars and Gantt Charts.

The Spreadsheet Scheduler is a toolkit containing 14 ready-to-use, practical models for a variety of common scheduling problems. The models are spreadsheet templates that work with all popular spreadsheets. The 14 spreadsheet-based programs provide an easy-to-use set of tools to help any organization manage projects more efficiently, improve customer deliveries, and minimize work-in-process times.

Excel ActiveX

Excel ActiveX acts as an ActiveX document container for hosting Excel document in a custom form or Web page. Support Excel automation client and offer abundant sample codes.

Excel ActiveX can be easily integrated into applications written in languages that support ActiveX control such as Visual C++, Visual Basic, Delphi, C++ Builder and .Net languages.

ZRandom for Excel

ZRandom implements high quality random number generation for Microsoft Excel using the Merssenne Twister algorithm :
  • Use higher quality pseudo-random numbers than the Excel RAND() and VBA Rnd() functions.
  • Generate random numbers from 16 discrete and continuous distributions.
ZRandom implements the following discrete distributions: Uniform, Bernoulli, Geometric, Hypergeometric, Negative Binomial and Poisson.

ZRandom implements the following continuous distributions: Beta, Burr, Exponential, Gamma, Lognormal, Normal, Pareto, Triangular, Uniform and Weibull.
  • Create large batches of random numbers using the interactive user interface.
  • Excel functions for use in spreadsheet formulas.
  • Random Sort and Random Sample
  • Interactive distribution wizard
  • A VBA interface to generate random numbers in your code.

Excel Workbook Splitter

Excel Workbook Splitter is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. This excel tool changes the complicated, duplicate and boring excel works into easy ones. Especially it's used for financial affairs, legal affairs and so on. Excel Workbook Splitter supports Microsoft Excel only and Windows 2000/XP operating system.

With Excel itself, the operation requires opening each workbook, selecting entire sheet, creating a new workbook, pasting the sheet, saving... But with Excel Workbook Splitter, you just load any number of workbooks (or even some folders) into the program and see the list of all worksheets from all workbooks at once.

Budget Forecaster & Expense Tracker Combo Package

Budget Forecaster for Excel® is a household budgeting and finance management software was designed for Microsoft Excel® lovers who prefer using Excel-based household budgeting software to a stand-alone application to manage their family finances.

These users tend to enjoy the convenience of managing their household finances with the help of this VBA Excel tool without having to learn a new household finance management software application
  • Track where your money goes See where your money goes by tracking your daily expenses by type.
  • Get a clear picture of where your money is going by week or by month.
  • Track your income, investments and expenses for the selected time period, and analyze your income allocation and expenses distribution with efficient Budget Forecaster software tools - all in one place.
  • View colorful detailed charts & graphs.
  • View colorful, detailed charts and graphs and see visually by category where your money goes. If you prefer to see where your expenses go in a colorful easy to read pie chart, you will enjoy this feature.