Our Sponsors

Free Online Games
Play Your Favorite Games Free. Arcade, Card, Action Games & More. Over 2800 games to choose from!
www.freegamesfactory.com


Ready To Run Excel Models
37 finance & statistic Excel programs with VBA source code.
www.excel-modeling.com


Super Online Shopping Center
Your prime source for finding all the greatest deals on items and goods online.
www.buy.sc


Buy Domains?
Offer premium domain names for different industries and interests.
www.thedomaincity.com


Excel Consulting Services
Spreadsheet Design, Custom Macro, Data Mining and VBA Programming.
www.excel-business-solutions.com

Excel Models

Queuing Model Excel
The Queuing Model will calculate the optimum number of customer service points (staff) to minimize costs for your business. It considers the average arrival rate of customers, the average customer service rate, the cost to the business of customer waiting time (customer dissatisfaction), and the cost to operate customer service points. Queuing models are used extensively in call centers, toll booth operations and situations where a there is a queue for service including, counter staff, service staff, call response staff or maintenance staff.

Decision Assistant Model Excel
The Decision Assistant Model Excel allows you to value a decision and determine the impact on your business. It calculates the range of possible outcomes for your decision, their likelihood of occurring, the average outcome, and the probability of the outcome being positive (profitable). It applies three decision return estimates (Pessimistic, Middle, and Optimistic) and associated decision costs. Outputs cover a 12 month period and are presented in tabular and graphical form. Outputs include a decision Output Curve, Cash Flow Scenarios, a Risk Profile, and an Action Sheet.

Business Valuation Model Excel
The Business Valuation Model is software designed to provide an economical, efficient and effective business valuation. It combines relative indicators for future performance with basic financial data (Revenue, Variable and Fixed Costs) to value a business. By uniquely applying your intuitive business and market knowledge a 3 year performance forecast with sensitivity analysis, investment return, and a business valuation is calculated. It is compact, easy to use, and requires minimal inputs. Input should be based on your subjective views. These are translated into quantifiable values for model operation. There is no need to provide \"perfect\" answers.

Billing Model Excel
This model was originally designed to test changes in billing structures for a Medical Practice (Public versus Private Billing), however it is equally suited to any professional practice and can be used to test the impact of fee changes. When billing structures are altered they impact on client numbers and in turn revenue and profit. The Billing Model allows you to forecast what this impact will be. It does this using a Client Number Change Percentage.

Financial Excel All Programs Edition
The Financial Excel All Programs Edition provides over 100 business finance spreadsheets, Excel add ins and Excel Learning Modules.

Queuing Model Excel
The Queuing Model will calculate the optimum number of customer service points (staff) to minimize costs for your business. It considers the average arrival rate of customers, the average customer service rate, the cost to the business of customer waiting time (customer dissatisfaction), and the cost to operate customer service points. Queuing models are used extensively in call centers, toll booth operations and situations where a there is a queue for service including, counter staff, service staff, call response staff or maintenance staff.

Production Mix Model Excel
This model calculates the Product or Service Mix that maximizes overall profit considering available resources. It will identify the mix (number) of each Production Item to produce and any remaining resource. Up to six unique Production Items can be handled with ten specific resource inputs. Production Items can be considered as the output of any process including manufactured items and the provision of services. Resources are anything that is needed to produce or provide the Production Item. This may include materials, labor, machine time, floor space, transportation services etc.

Decision Assistant Model Excel
The Decision Assistant Model Excel allows you to value a decision and determine the impact on your business. It calculates the range of possible outcomes for your decision, their likelihood of occurring, the average outcome, and the probability of the outcome being positive (profitable). It applies three decision return estimates (Pessimistic, Middle, and Optimistic) and associated decision costs.

Business Valuation Model Excel
The Business Valuation Model Excel combines relative indicators for future performance with basic financial data (Revenue, Variable and Fixed Costs) to value the business. This valuation method can be used for business purchase, sale, or establishment. The model uniquely applies your intuitive business and market knowledge to provide a 3 year performance forecast with sensitivity analysis, investment return, and a business valuation.

Business Performance Analysis Modules
BusinessPerformanceAnalysis.com provide a suite of easy to use business performance analysis services. These Analysis Modules are delivered via a browser based software interface and consist of business forecasting and business valuation modules. You can access all Analysis Modules directly from our site or download and run the Business Performance Analysis Modules on your computer. All modules are designed to run in your browser, do not alter your system in any way and all data is saved locally on your computer. This provides the highest level of security possible, protecting you, your computer and your data.

Budget Tool Business Excel
The Budget Tool Business Excel provides an effective means to generate a budget for up to five years. Full flexibility allows you to add Revenue, Variable Cost, and Fixed Cost categories and lines to suit any business. Operation is via an easy to use toolbar and function buttons.

Billing Model Excel
This model was originally designed to test changes in billing structures for a Medical Practice (Public versus Private Billing), however it is equally suited to any professional practice and can be used to test the impact of fee changes. When billing structures are altered they impact on client numbers and in turn revenue and profit. The Billing Model allows you to forecast what this impact will be. It does this using a Client Number Change Percentage. This is the percentage change in client numbers when your billing structure is changed. For each business this is influenced by the level of competition, differentiation of the business, client profiles, and type of service provided. An estimate of this percentage combined with basic data on average billing fees and cost percentages allow revenue, profit and client numbers to be forecast for the range of billing fee combinations.

Recent News

10/8/2008
To provide easy and convenient access to our site, we have transitioned to a new layout. If you prefer to view the classic version, please click the link below.

Classic View





regression.jpg







option.jpg
Excel VBA Basic Tutorial Series  
 
Excel VBA Basic Tutorial Series 1  
 
Creating Your First Macro  
In this sub section, we will show you how to create your first macro (VBA program). We will use the world classic "Hello World!" example.  
 
Recording a Marco  
In this example, we will record a macro that sets the cell background color to light yellow. 
 
See the Recorded Syntax

Before we run the marco, let's look into the syntax. 
 
Run the Recorded Marco  
Run the recorded macro in the worksheet. 
 
Modules and Procedures and Their Scope  
A module is a container for procedures as shown in our prior examples.  A procedure is a unit of code enclosed either between the Sub and End Sub statement or between the Function and End Function statements.

 

Calling Sub Procedures and Function Procedures  
There are two ways to call a sub procedure.  This example shows how a sub procedure can be called by other sub procedures.... 
 
Passing Argument by Value or by Reference

If you pass an argument by reference when calling a procedure, the procedure access to the actual variable in memory.  As a result, the variable's value can be changed by the procedure.

 
Excel VBA Basic Tutorial Series 2  
 
Objects and Collections

Objects are the fundamental building blocks of Visual Basic.  Anobject is a special type of variable that contains both data and codes.  A collection is a group of objects of the same class.  The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

 
Workbook and Worksheet Object

A workbook is the same as an Excel file.  The Workbook collection contains all the workbooks that are currently opened.  Inside of a workbook contains at least one worksheet.

 
Range Object and Cells Property

Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.  We will show you some examples on how Range object can be used.

Methods and Property

Each object contains its own methods and properties.  A Property represents a built-in or user-defined characteristic of the object.  A method is an action that you perform with an object.

 
Assigning Object Variables and Using Named Argument

Sometime a method takes more than one argument.  For example, the Open method for the Workbook object, takes 12 arguments.

 
Excel VBA Basic Tutorial Series 3  
 
Objects and Collections

Objects are the fundamental building blocks of Visual Basic.  An object is a special type of variable that contains both data and codes.  A collection is a group of objects of the same class.  The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

 
Workbook and Worksheet Object

A workbook is the same as an Excel file.  The Workbook collection contains all the workbooks that are currently opened.  Inside of a workbook contains at least one worksheet.

 
Range Object and Cells Property

Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.  We will show you some examples on how Range object can be used.

 

Methods and Property

Each object contains its own methods and properties.  A Property represents a built-in or user-defined characteristic of the object.  A method is an action that you perform with an object.

 
Assigning Object Variables and Using Named Argument

Sometime a method takes more than one argument.  For example, the Open method for the Workbook object, takes 12 arguments.

Excel VBA Simulation Basic Tutorial 101

 

Creating and Managing Array

This is an essential skill for creating a simulation.  Topics in this section cover declare an array, resize an array, manage dynamic array, create multi-dimensional array, and find the array size.

 

Decision Structure - IF and Select Case

Contains tutorial using If...Else, If...ElseIf, and Select Case statements.

 

Loop Structure - For...Next and Loops

Provides examples on all the loop structures: For...Next with Step, Do...While...Loop, So Until...Loop, and etc.

 

Sorting Numbers in an Array

This tutorial shows how to call a sort sub procedure, passes the array to it, and returns a sorted array.

 

Finding Max and Min in Array

Extract the maximum and the minimum values in an array using sorting method.

 

Double Sorting - The Secret of Resampling Without Replacement

This example shows how to derive unique random values by sorting one array based on another array.

 

 

Simulation Basic Tutorial Series

Excel VBA Simulation Basic Tutorial 102

 

Random Number and Randomize

One of the most essential 'Must Know' in simulation.

 

Standard Deviation and Mean

Two of the mostly used statistic estimates in action.

 

Skewness and Kurtosis

Second tier statistic estimates.

 

Percentile and Confidence Interval

Compute the simulated values at a specific percentile.

 

Profitablity

Compute the probability at a specific value (or profit).

 

Creating a Histogram

A tutorial on how to create a histogram by passing array into the histogram sub procedure and returns the frequency distribution from the array.

 

 

Excel VBA Statistics and Math

 

Finding Median

Compute the median from an array

 

Generate Random Number From Uniform Distribution

Generate uniform random number within a range.

 

Sum Number in an Array

Sum up number in a array using loop.

 

Compute Factorial

Compute binomial coefficient.

 

Binomial Coefficient

Compute the probability at a specific value (or profit).

 

Cumulative Standard Normal Distribution

Compute the probabilty from a standard normal distribution. 

Excel VBA Basic Tutorial Series

Excel VBA Basic Tutorial Series 1

Creating Your First Macro
In this sub section, we will show you how to create your first macro (VBA program). We will use the world classic "Hello World!" example.

Recording a Marco
In this example, we will record a macro that sets the cell background color to light yellow.

See the Recorded Syntax
Before we run the marco, let's look into the syntax.

Run the Recorded Marco
Run the recorded macro in the worksheet.

Modules and Procedures and Their Scope
A module is a container for procedures as shown in our prior examples.  A procedure is a unit of code enclosed either between the Sub and End Sub statement or between the Function and End Function statements.
 
Calling Sub Procedures and Function Procedures
There are two ways to call a sub procedure.  This example shows how a sub procedure can be called by other sub procedures....

Passing Argument by Value or by Reference
If you pass an argument by reference when calling a procedure, the procedure access to the actual variable in memory.  As a result, the variable's value can be changed by the procedure.

Excel VBA Basic Tutorial Series 2 

Objects and Collections
Objects are the fundamental building blocks of Visual Basic.  Anobject is a special type of variable that contains both data and codes.  A collection is a group of objects of the same class.  The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

Workbook and Worksheet Object
A workbook is the same as an Excel file.  The Workbook collection contains all the workbooks that are currently opened.  Inside of a workbook contains at least one worksheet.

Range Object and Cells Property
Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.  We will show you some examples on how Range object can be used.
Methods and Property
Each object contains its own methods and properties.  A Property represents a built-in or user-defined characteristic of the object.  A method is an action that you perform with an object.

Assigning Object Variables and Using Named Argument
Sometime a method takes more than one argument.  For example, the Open method for the Workbook object, takes 12 arguments.

Excel VBA Basic Tutorial Series 3

Objects and Collections
Objects are the fundamental building blocks of Visual Basic.  An object is a special type of variable that contains both data and codes.  A collection is a group of objects of the same class.  The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

Workbook and Worksheet Object
A workbook is the same as an Excel file.  The Workbook collection contains all the workbooks that are currently opened.  Inside of a workbook contains at least one worksheet.

Range Object and Cells Property
Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.  We will show you some examples on how Range object can be used.
 
Methods and Property
Each object contains its own methods and properties.  A Property represents a built-in or user-defined characteristic of the object.  A method is an action that you perform with an object.

Assigning Object Variables and Using Named Argument
Sometime a method takes more than one argument.  For example, the Open method for the Workbook object, takes 12 arguments.
Excel VBA Simulation Basic Tutorial 101
 
Creating and Managing Array
This is an essential skill for creating a simulation.  Topics in this section cover declare an array, resize an array, manage dynamic array, create multi-dimensional array, and find the array size.
 
Decision Structure - IF and Select Case
Contains tutorial using If...Else, If...ElseIf, and Select Case statements.
 
Loop Structure - For...Next and Loops
Provides examples on all the loop structures: For...Next with Step, Do...While...Loop, So Until...Loop, and etc.
 
Sorting Numbers in an Array
This tutorial shows how to call a sort sub procedure, passes the array to it, and returns a sorted array.
 
Finding Max and Min in Array
Extract the maximum and the minimum values in an array using sorting method.
 
Double Sorting - The Secret of Resampling Without Replacement
This example shows how to derive unique random values by sorting one array based on another array.
Simulation Basic Tutorial Series
Excel VBA Simulation Basic Tutorial 102
 
Random Number and Randomize
One of the most essential 'Must Know' in simulation.
 
Standard Deviation and Mean
Two of the mostly used statistic estimates in action.
 
Skewness and Kurtosis
Second tier statistic estimates.
 
Percentile and Confidence Interval
Compute the simulated values at a specific percentile.
 
Profitablity
Compute the probability at a specific value (or profit).
 
Creating a Histogram
A tutorial on how to create a histogram by passing array into the histogram sub procedure and returns the frequency distribution from the array.
Excel VBA Statistics and Math
 
Finding Median
Compute the median from an array
 
Generate Random Number From Uniform Distribution
Generate uniform random number within a range.
 
Sum Number in an Array
Sum up number in a array using loop.
 
Compute Factorial
Compute binomial coefficient.
 
Binomial Coefficient
Compute the probability at a specific value (or profit).
 
Cumulative Standard Normal Distribution
Excel and VBA Examples