Customer: Christian Investment Consultants Project: Financial Analysis Excel Macro Type: Windows Application

Jim Krebec of CIC developed a Microsoft Excel workbook containing complex formulas, to support the analysis of financial returns. Though effective, applying the formulas to new data would be manually intensive and would increase the likelihood of errors. By adding a Macro to the workbook, it would be possible to automate the application of the formulas with the click of a button.

ASI worked with Jim to define and refine the spreadsheet requirements. The macro was programmed, tested, and further refined until it satisfied all requirements.

The new macros allow Christian Investment Consultants to apply complex financial analysis rules easily and with consistent accuracy. Tools: Microsoft Excel

Jim "We are very pleased with the service and the results and look forward to working with Ablesoft Solutions again."