Home: Services / Quotation

Quotation Calculator and Customized Functions

Speed Up Your Quotation Process!

Quotation systems and calculators are being used in many different businesses. This quotation calculator example demonstrates how a complex calculator can be generated using Excel.


Quotation Calculator Example

This quotation calculator allows users to compute the final cost of their services. The computation is based on multiple criterions from several data sheets. Figure 1. below shows one of the data sheets that is used for this calculator.

The users will be able to define their criterions through a set of user interfacts - combo boxes (drop down menu), checkboxes, and textbox. The final result with itemized costs breakdown then displays on the output area of the spreadsheet as shown in Figure 2.



Fig 1. Screen shot of a data sheet
Fig 2. Screen shot of the calculator sheet

Ever run out of Excel built-in functions to use?

Through Excel VBA programming, customized functions can be built. This customized function example demonstrates the use of user-defined Excel functions with context-sensitive help.


Customized Function Example

This example shows how user-defined functions can be built using Excel VBA or Macros and each of the customized functions has a context-sensitive help section links to it. This example is taken from one of our XL-Modeling products. This project has 12 user-defined functions on option pricing models and option greeks (sensitivities) based on Black-Scholes theory as shown on Figure 3.

Figures 4. is screen shot taken from the help of these functions. Users can easily navigate to different help section for any particular function.



Fig 3. Screen Shot of the customized functions section
Fig 4. Screen Shot of the functions help section

Quick Contact Box

Data Quality Services

The importance of data management is often overlooked by many companies. They frequently underestimate the important contribution data management makes to the success or failure of their operations. Data quality is vital to business intelligence. Companies typically spend thousands and even millions of dollars setting up business intelligence systems to improve their operations, but the results generated by these efforts are only as good as the data that is fed into them.

Many fall short of their expectations because of poor data quality issues. Contradictory, inconsistent or inaccurate information exposes companies to many business risks that lead to increased costs, customer dissatisfaction, poorer decision making and lost business. Clean, high quality data helps company decision makers to accurately and correctly assess their business activities and avoid potential pitfalls that can significantly impair a company's profitability.

At Excel Business Solutions we offer companies with data cleansing, data integration, data enrichment and data mining services in support of accurate reporting, analysis and business decisions; and consequenentially, minimize risk and cost, enhance business opportunity and increase returns.
More Info