Mortgage Mentor Excel Application: Client has created a massive Excel workbook for use by mortgage brokers. The client needs occasional expertise in VBA/Excel coding. Services provided: coding that “registers” a new user via an Access database on a web server, coding that verifies the identity of a user every time the application is opened, and coding that allows end-user to send mortgage alerts to any number of clients and to store a record of emails sent.

Ipsen Main Screen

This is the opening screen of an Excel application. Users navigate to only those areas that are unlocked and input up to 21,000 inputs for a given forecast. The colored bands indicate areas where users can “autofill” by entering a number on the left side, and all cells to the right will automatically populate. This feature can also be optionally turned off.

IHLH DB Screen

Screen showing list of available “Legacy Trees” on the right and the trees owned by the current customer on the left. The box at left shows details on the certificate that accompanies every legacy tree, including who it is dedicated to and an inscription. List boxes to the right show the various contact types the customer falls under and allows the end-user to filter all contacts by various contact types. Also, note the custom ribbon items.

Office Holders Screen

Microsoft Access Legislation Database: This screen shows various office holders in multi-level jurisdictions, lengths of terms and other contact information.