paper: New Scouting Database from Team 2834

[Siri]

A note to passers-by, this is the 2012 thread. (Took me a minute.) 2013 is here: http://www.chiefdelphi.com/forums/sh...d.php?t=115101

[Ed Law]

Originally Posted by faust1706

wow. that is truly an amazing work of excel. Thanks for posting this, cant even begin to imagine how it was made!

Thanks. It is through a combination of Excel formulas and VBA. Very little is done by hand.
This was the original thread from some years ago. I still put the weekly data here to make it easier for people to find it. Each week I create a new thread to let people know new data is available.

[Citrus Dad]

There appears to be an error in the OPR calculation for the 2013 Championships. The sum of the individual OPRs diverges significantly from the total OPR, whereas the differences in the regionals are much smaller. I suggest going back and checking the calculations in that version.

[Ether]

Originally Posted by Citrus Dad

There appears to be an error in the OPR calculation for the 2013 Championships. The sum of the individual OPRs diverges significantly from the total OPR, whereas the differences in the regionals are much smaller. I suggest going back and checking the calculations in that version.

redirect here:

http://www.chiefdelphi.com/forums/sh...30#post1276030

[Ed Law]

The database is ready for 2014. Everything should work for calculating the OPR/CCWM during the competition. I cannot test it since the links are not up yet. It will also calculate the sub-OPR for Assist, Autonomous, Truss & Catch and Teleop. I will check it on Friday to make sure it works. If there are any problems, I will post any correction ASAP.

[marccenter]

Ed,

Thanks for doing this. It didn't seem to work for me as expected. Will you be posting a new version, soon.

The CTRl-SHift-P did provide some data but ended with an error code (not expected). The subsequent Ctrl_Shift-O
did not populate data either (also debug message).

[jwhite]

It's easy to fix - pop into the debugger and do a find for 5000; change all occurrences of 5000 to 6000, and the spreadsheet goes back to working it's wonders.

Cheers,

Jeremy

[Jacob Plicque]

Ed
I am getting a runtime "13" error. After fixing the 5000 with a 6000 for some of the regionals

[Ed Law]

Originally Posted by jwhite

It's easy to fix - pop into the debugger and do a find for 5000; change all occurrences of 5000 to 6000, and the spreadsheet goes back to working it's wonders.

Cheers,

Jeremy

I published a new one to fix the 5000 limit and a few minor errors. It is hard to anticipate everything and with no way to test before publishing. 6 years ago when I wrote this, 5000 seems to be a very big number as the teams were only in 2000 range. I have completely forgotten about it.

[Banderoonies]

On behalf of team 195, I want to thank you for the excellent work you do in putting this data together.

[olapmonkey]

Originally Posted by Jacob Plicque

Ed
I am getting a runtime "13" error. After fixing the 5000 with a 6000 for some of the regionals

I too am getting errors on many of the tabs when I try the ctrl-shift-p combination. Additionally, it is unclear to me on how the WM data and OPR data tabs update. If I try ctrl-shift-P they error as well and currently they are only showing partial information. Any ideas?

Thanks for putting this together Ed. It looks to be quite useful.

[Ed Law]

Originally Posted by olapmonkey

I too am getting errors on many of the tabs when I try the ctrl-shift-p combination. Additionally, it is unclear to me on how the WM data and OPR data tabs update. If I try ctrl-shift-P they error as well and currently they are only showing partial information. Any ideas?

Thanks for putting this together Ed. It looks to be quite useful.

Can you give me one example of which one does not work? All week 2 events work for me. There was one event in Week 1 that did not work because of something I did.

Make sure you do not have other spreadsheets open that have macros, especially older versions of the scouting spreadsheets.

What version of Excel are you using and what kind of computers are you using?

[theawesome1730]

On a Mac running office 2011 what would be Ctrl+Shift+P? I would think Cmd+Shift+P but that opens a new project

[Ed Law]

Originally Posted by theawesome1730

On a Mac running office 2011 what would be Ctrl+Shift+P? I would think Cmd+Shift+P but that opens a new project

Sorry I have no experience with Mac. The shortcut is just for convenience on a PC. You can open up the macro and manually run the macro in Module 2 called "RefreshData". It is on the top of all the macros in Module 2.

[Ether]

Is there anyone out there in the CD community who has managed to figure out a way to convert Ed's xlsm spreadsheet so that it can be opened with Excel 2000 ?