Tuesday, October 16, 2012

Alvin Roth Wins Nobel Prize

I was fortunate to have worked my way through college as an Undergraduate Research Assistant with the Economics department at the University of Illinois working on multi-player bargaining experiments funded by some NSF grants where one of the researchers was Al Roth. He was already well known in game theory at the time these experiments were conducted.

The Sveriges Riksbank Prize in Economic Sciences in Memory of Alfred Nobel 2012 was awarded jointly to Alvin E. Roth and Lloyd S. Shapley "for the theory of stable allocations and the practice of market design"

http://www.nobelprize.org/nobel_prizes/economics/laureates/2012/

Three of his earlier papers where we (Ron Harstad, Michael Barr, myself) contributed by building multi-player experiments on PLATO:


Expectations and Reputations in Bargaining: An Experimental Study (1983)
https://web.stanford.edu/~alroth/papers/1983_AER_Expectations_and_Reputations.pdf

The Role of Information in Bargaining: An Experimental Study (1982)
https://web.stanford.edu/~alroth/papers/1982_E_Role_of_Information.pdf

Sociological versus strategic factors in bargaining (1980)

A footnote in history!

Tuesday, October 02, 2012

Google Apps Script Web App with Spreadsheet

Google Apps Script is a fascinating technology for putting together web applications using the Google Apps environment as the infrastructure. Here is a quick example of a public web application that sets 10 cells in a Google Apps spreadsheet to a value.


Note: Logger class does not work in an event handler.

I used the GUI Builder to create the simple interface:


Just make sure you set the parameter to be passed in the event handler. See the following stackoverflow item for more detail:



Like magic you have a web application. To see it in action go to the following public URL:


And you can see the spreadsheet that is modified by this script at the following public URL:


For some fun, open the app in one tab and open the spreadsheet in a separate window. You can modify the value in the application tab and watch the cells change in the spreadsheet. This is a view-only spreadsheet, but it is being modified by the web application.

Next up is writing a script to pull info from Google Analytics since I need to do some combining of statistics from there regularly for work.