Re: paper: New Scouting Database from Team 2834
 

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

Scouting Database from Team 2834
 

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.

Re: paper: New Scouting Database from Team 2834
 

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.

Re: paper: New Scouting Database from Team 2834
 

redirect here:

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

Scouting Database from Team 2834 (2014)
 

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.

Re: paper: New Scouting Database from Team 2834
 

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).

Re: paper: New Scouting Database from Team 2834
 

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

Re: paper: New Scouting Database from Team 2834
 

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

Re: paper: New Scouting Database from Team 2834
 

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.

Re: paper: New Scouting Database from Team 2834
 

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

Re: paper: New Scouting Database from Team 2834
 

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.

Re: paper: New Scouting Database from Team 2834
 

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?

Re: paper: New Scouting Database from Team 2834
 

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

Re: paper: New Scouting Database from Team 2834
 

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.

Re: paper: New Scouting Database from Team 2834
 

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 ?