The quotation calculator example demonstrates how a complex calculator can be generated using Excel programming through our Excel consulting services.
The customized function examples demonstrate the use of user-defined Excel functions with context-sensitive help by our Excel consultants. The Black-Scholes option pricing model is used for this example.
Quotation Calculator Example Details
Quotation Calculator and Customized Functions
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 - 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.
Figure 1. Screen shot of a data sheet
Figure 2. Screen shot of the calculator sheet
Customize Function Example Details
The 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.
Figure 3. Screen Shot of the customized functions section
Figure 4. Screen Shot of the functions help section
Copyright © Excel Business Solutions. All Rights Reserved.
37 advanced Excel VBA prorgrams in finance & statistics with VBA source codes.
