Sample Topics
Attached are 2 examples that I created myself. Please note that these were built as examples and do not belong to any of my customers. Any code written for a customer belongs to that customer and is not provided or used for any other customers.
Complex Functions - Retirement Calculator
I decided to create this custom model after being underwhelmed with the available retirement calculators found online. Please download this file, enter your assumptions, and evaluate your retirement.
This application uses primarily excel functions. After running one case a monte carlo VBA macro can be performed. Please contact me if you have questions about how this file actually works.
This file is intended to forecast the estimated amount of retirement savings at a future date based on input retirement savings and spending details.
Your use of this tool is limited to personal and
ColinMarker_RetirementCalculator.xls
Microsoft Excel sheet [101.0 KB]
VBA Work Automation - Address Lookup
This was a sample proof of concept I created for a small local bank.
The bank needed to download the tract code to the government from the FFIEC website. The bank would perform thousands of searches manually to find the tract for each loan. This tool was created to provide an example of how they could automate excel to perform the same function in a fraction of the time freeing their employees to provide value added services.
http://www.ffiec.gov/Geocode/default.aspx
Input: Address
Output: Tract Code Information
Please contact me if you have questions about how this file actually works.
This file takes input addresses, enters those addresses in a website, and downloads the information into Excel for the user.
ColinMarker_Address_lookup.xls
Microsoft Excel sheet [101.0 KB]
Decision Sciences
Should you buy or pass on this deal? I specalize in decision making based on scientific methods. Decision Sciences and probability can help your company evaluate multiple options to make the correct decision.
- Net Present Value
- Expected Monatary Value
- Expected Utility Value
- Basian Probability
- Queueing Theory
- Switching Theory
- Statastics
- More analytical methods... just ask
These are all functions I utilize depending on the particular application.
Please contact me if you have questions about how these methods can help your company.