Quote:
Originally Posted by bayesianlogic
So, how was this done, precisely? Can you share the calculation logic or even the code?
|
Pretty easy:
Code:
Copy/paste 2008 results from GTR into excel
Write VBA Macro:
for each match
for each team in the match
if this team scored 2x or 3x in their previous match, remove 1 or 2 balls and print that on the spreadsheet.
do statistic-y stuff.
Attached is my excel worksheet (with macros included). It's fairly ugly because I didn't write it to be pretty.