You will have 30 minutes from when your challenge is announced to submit your answers for Round I, using the form at the right. Please note that this 1-page form will not be accessible until the contest is officially open. Be prepared to submit the following in the 30 minutes that you are allotted and keep a close eye on the countdown:
  • You will need to accept the Terms & Conditions as outlined in the Contest Rules, in addition to submitting your full name, email address and answers for the Quickfire Challenge. A preview of the form appears at the right.
  • The 200 highest scoring individuals will be selected to proceed to Round II. Scores will be based upon number of correct answers and speed of entry.
Welcome to Round I of the Google Apps challenge. Starting from now, you will have unitl 4:30 P.M. PDT to complete the following questions. All of these questions have a single right answer.

Accept the Terms & Conditions to the Contest Rules and submit your answers at one of mirrored forms below.

We've included a list of ~150 URLs in the following Spreadsheet  Each of these URLs will return a text/plain document containing a stock symbol.  Each of these URLs will return a text/plain document containing a stock symbol.  Look up yesterday's (close of US stock market on March 28th) closing price for each of these stocks, round it to 2 decimal points, and find the median value. $10.59 or EPIC

Round II
Automation on Apps Scripts

Choose a task that you do regularly and automate it with Apps Script.  Some examples are here:
  • Bonus points if you integrate with a third-party (non-Google) API to solve this challenge.