paper: When is my next match?

[Joe Johnson]

Thread created automatically to discuss a document in CD-Media.

When is my next match? by Joe Johnson

[Joe Johnson]

CD has been so giving to me during this season (especially with respect to the [DFTF] threads) I thought I would give some back...




I wrote this a few years back when I was helping Ursa Major, 2849. It helps keep track of how much time you have left before your next match, what color your robot is, who your partners and opponents are.

Read the instructions in blue. It is pretty self explanatory.

We run it on a laptop in the pits and you can know at a glance all you need to know about your upcoming matches.

I should have uploaded it a while ago, but it wasn't until I was packing for BU this weekend that I remembered that I even had it.

Hope you find it useful.

The coding is brutal by the way but it works and it took me about 20 minutes to write so... ...don't be a hater. Improve on it if you think it needs it.



Joe J.

[Joe Johnson]

Two things.

When you add matches, use copy and paste of entire rows so that you get the formulas on the left side and also so you get the right format for the time of the match cell (the program should be more tolerant of this but... ...again, it was an internal tool that I published without fully vetting all the use cases).

When you change times, be careful to keep the formatting the same as the others so that the code doesn't get confused. Same disclaimer as above.

Third bonus point, yes, I could have/should have put the ability to stop the program on the form as well as the ability to adjust the schedule time vs actual time via the form. Standard disclaimer.

Joe J.