Here's how it's done, open the Google Doc's ACRA spreadsheet:
- Rename the first sheet to 'Sheet1'
- Add new sheet
- In Cell A1 set text: "Short Stack"
- In Cell A2 set text: "=LEFT(Sheet1!P2,FIND("(", Sheet1!P2, 1))"
- Copy cell A2 to match the rows in Sheet1 (e.g. to cells A3, A4, A5, ...)
- Select column A in Sheet2, and create a pivot table ("Data" -> "Pivot table report...")
- In the pivot table sheet:
- "Rows" -> "Add field" : "Short Stack"
- "Values" -> "Add field" : "Short Stack", summarize by: "COUNTA"