Log in

View Full Version : paper: OVERDRIVE Excel Scoring Spreadsheet


cbudrecki
05-01-2008, 18:45
Thread created automatically to discuss a document in CD-Media.

OVERDRIVE Excel Scoring Spreadsheet (http://www.chiefdelphi.com/media/papers/2062?) by tb222

cbudrecki
05-01-2008, 18:47
My annual scoring spreadsheet is done! And only about 7 hours after the game was announced!!! Please, if you find any bugs, POST THEM HERE!!! I also created a ReadMe file. This will require that you TURN MACROS ON in Excel. Please enjoy! :D

cbudrecki
05-01-2008, 19:23
OK, played and found some small things that weren't necessarily "broken," but just seemed like they should work better.

RESET HYBRID now clears the Hybrid and Penalty fields. (v1.0 just makes the "Working Hybrid" box equal 0)

The FINAL score box now shows "ERROR!" instead of just ##### when an error occurs in TELE mode.

So, v1.1 is born, download the new version, enjoy, strategize!:]

cbudrecki
05-01-2008, 19:31
v.1.11 - just minor ERROR display adjustments, nothing major

cbudrecki
06-01-2008, 00:18
v1.2 is out. I feel this is a fairly important upgrade, not quite CRITICAL, but it'll save you a ton of headaches!:ahh: Not much has actually changed, but I made it so that the only ROBOT counters active during TELE-OPERATIONS are the ones for the respective FINISH LINES. i.e. BLUE ROBOTS are only counted when crossing the BLUE FINISH LINE (top row of counters). I did this so you don't have to click all four counters to make the score register. I also updated the ReadMe file to include this.

cbudrecki
06-01-2008, 02:17
v2.0 posted. Added QP & RP scoring. This always seems to be an afterthought with me...

cbudrecki
08-01-2008, 00:41
Almost 300 downloads (once you subtract the Read Me downloads), and no comments yet:ahh: ?! I take it everything is working as expected?

kSniper
08-01-2008, 00:50
Well let me start off by thanking you emmensly for this, I was looking to do something simiar but you beat me to it and you did an amazing job!!!

Team303