Get more from Microsoft Excel
...with Custom Formulas, Functions and Add-ins

The problem:-  A PBMS client in the insurance industry used to spend hours preparing block quotations for new proposals received from their agents.

The solution:-  A little organisation and Microsoft Excel.  PBMS prepared a Custom function that does all the table look-ups and calculations.  The agents E-mail their lists of potential new business as Excel spreadsheets, our client copies a formula down the list - and it's done!  In seconds.

Because the Custom function is designed as an Excel add-in, it is available to all users and it's there on the menu like any native Excel formula or function.  Simple, practical and inexpensive.

A simplified example is shown below.  It is a Web interactive Excel spreadsheet so...

...try it yourself:
(If the example fails to load, see below)

◄Enter your date of birth...
◄...and your policy renewal date...

To calculate other premiums as at...

...Today copy the yellow range

...at Renewal Date copy the  blue range

 Copy to any rows in the range  C12..E15

To interact with a spreadsheet on the Web, you need Microsoft Internet Explorer 4.01 or later and Microsoft Office XP Web Components - go to http://www.microsoft.com/downloads and Search for Web Components

  ...or click here for an alternative static presentation of this example.

About Custom Functions...