Code Samples

Here is a proof of concept I developed to demonstrate the power of Google Spreadsheets. It is a shopping list that accepts as input any groceries you've purchased (food, purchase date, quantity, price paid) as well as a master list of all foods including the common unit used for that item and how long the food of that unit would typically last. The output is an ordered grocery list, the topmost items being the ones that most likely need to be bought now, and the bottommost items being those that we already have a supply of that will last the longest. It's not practical because there is no easy way (other than a custom program based on OCR technology that would parse our grocery receipts or a grocery store that provides downloadable CSVs of shopping history) to input every grocery item we buy. This may become practical when grocery receipts inevitably go digital, so you can spit out an automated grocery list and no longer forget to buy anything.

Here is one of the Google Spreadsheets I use to manage hospitality for new people in our community. We use Google forms to help track how many times each new person has been invited out in order to paint a prioritized picture for prospective hosts regarding who can most use an invitation.

Here is a IT development project changelog I wrote using Google Spreadsheets.

Attached below is the code I wrote under in a timed setting (2 hours) in 2007 for one of my Google Software Engineer interviews.

Attached below is the code I wrote under in a timed setting (30 minutes) in 2010 for another interview (C#, SQL).

The vast majority of my Java, ColdFusion, .NET, Oracle and PL/SQL code is owned by the companies I've worked for. I therefore cannot post those files. I will sift through my personal files that I feel comfortable posting, and will post those incrementally.