Assumption: You know which stats are kept at a quiz-bowl tournament and have basic comfort level with MS Excel. Where to find it: <a href=http://www.umich.edu/~uac/mac/maize/Stats994.xls target=new>http://www.umich.edu/~uac/mac/maize/Stats994.xls</a> - the URL is case sensitve, sorry I munged it in previous post. What you need to use it: Spreadsheet program compatible with MS Excel 4.0 (the Windows95 one) -- any more recent MS Excel program should work. How to enter the data: Before you do anything, save under a different filename. Then, use the macros (under the Tools/Macros menu) to add lines for players, teams, & games. (MAKE SURE YOU USE THE MACROS to add the lines before doing data entry. Otherwise, the columns that do the calculating won't have formulas in them. That's the first mistake I made in "end user" mode tonight.) Where to enter the data: On the Team Stats sheet, for each team row, enter some convenient abbreviation in the Team column and the fuller name in the Full Name column. (You'll use that abbreviation on the Individual page and Game Score page.) On the Individual Stats sheet, for each player row, enter the player name and team (use the convenient abbreviation). Then, for each round (to get more than 10 rounds simply unhide the hidden columns :-)), if that player had a game that round, enter individual score in the column for that round as follows: Say she had 2 power tossups, 3 regular, and a neg. You'd enter the number "2003.01" -- power in the thousands place, regular in the units place, neg in the hundedth's place. (People have asked if in some future version, just a String like "2-3-1" could do the trick. I tried to make that work tonight but didn't find any painless way to do that. Maybe soon.) --to be continued--
This archive was generated by hypermail 2.4.0: Sat 12 Feb 2022 12:30:43 AM EST EST