During my time working for Ian down at The Garden Village, I created many pieces of advertising media, as well as creating them several systems for automating task management. Below are some extracts of some of the solutions I created for them.
Whilst I was working, I found the need to automate some of the tasks that I had to perform on a daily basis. I often had to provide an estimate for local delivery costs, so I created a web based tool to retrieve the distance between a pair of addresses via Google's APIs, and calculate a delivery cost which could be given to the customer. The tool had to work very quickly, as it was designed to be used whilst on the phone to a customer. The tool can be accessed HERE.
Whilst creating the tool I mentioned above, I came across a method of using another one of Google's APIs to our advantage. I devised a way to calculate a suggested selling price for our products, based on what other companies were selling it for online. Given the price we bought the products for, it would calculate how much profit we would make it it was sold at the recommended price, and the ratio to set it at in the database I had created. This tool can be accessed HERE.