Re: paper: New Scouting Database from Team 2834
 

Isn't this available with a little math from the twitter data? I don't think it's collated all in one place in Ed's spreadsheet.

Re: paper: New Scouting Database from Team 2834
 

Yes, I could do this easily with just the Twitter data.

But the Twitter data is frustratingly incomplete, and contains errors and redundancies.

Ed starts with the official Match Results and Team Standings data, then integrates the Twitter data with loving care and attention to detail. Bless you Ed. I don't have the stamina or patience to do that.

Re: paper: New Scouting Database from Team 2834
 

For events that have complete twitter data, I paste them starting in cell A401. The unpenalized scores are in column O and P starting from row 154.

paper: Scouting Database from Team 2834
 

There is a new presentation to explain how to calculate OPR, sub-OPR and CCWM in more details. It is what I presented today at the Michigan State Championship seminars.

Re: paper: Scouting Database from Team 2834
 

Is there video of this and/or presentation notes available?

Re: paper: Scouting Database from Team 2834
 

No, there is no video, only the powerpoint slides that was used in the presentation. It can be found in the same white paper where I put all the scouting data.
http://www.chiefdelphi.com/media/papers/2174?

Re: paper: New Scouting Database from Team 2834
 

Hey Ed, I don't know if you can do anything about it, but the latest versions of your scouting database crashes Excel for Mac 2011. The weird thing is the 2013 databases, and the earlier versions of the 2014 database (V6 maybe? Can't check) open fine. But V7.0, V7.1 and 2014 CMP V1 hang on opening.

Maybe you have an idea about what changed? I have a windows PC with excel viewer that lets me see the data at least, but unless I can get it open on OS X again, I can't edit (or filter or search) anything :(

Re: paper: New Scouting Database from Team 2834
 

Hi,

I did not do anything different in the spreadsheet except the files get bigger and bigger with more weeks of data. I think started from v6.0 or v7.0, I started zipping the file first before I upload. Did you unzip the file? I don't have a Mac so I don't know if you can unzip. I uploaded a Championship v1 without zipping for you. Try to download that one and see if it works. Let me know if you are able to unzip. If not, I will not zip it in the future when I upload.

Re: paper: New Scouting Database from Team 2834
 

The file unzips fine it seems. Unfortunately the unzipped file crashes as well - file starts to open, asks to enable macros, throws up a progress bar, and then stalls. I wish I had more to give you. Is there anyone else on CD using office for Mac?

Re: paper: New Scouting Database from Team 2834
 

No issues for me.

Re: paper: New Scouting Database from Team 2834
 

Huh, weird. I have no problem loading the 1114 database.

Can you do me a favor Ed / Gregor if you have time? Export a version in excel 97 "xls" format (instead of xlsm)?

Re: paper: New Scouting Database from Team 2834
 

Huh.

Trying to do that crashes Excel for me, but not with any other spreadsheet.

Re: paper: New Scouting Database from Team 2834
 

I just tried to do it and had the exact same issue. About 75% of the way through saving the file it crashed inexplicably.

(Excel 2013)

Re: paper: New Scouting Database from Team 2834
 

Welcome to the club.

http://www.chiefdelphi.com/forums/sh...91&postcount=3

http://www.chiefdelphi.com/forums/sh...08&postcount=7

http://www.chiefdelphi.com/forums/sh...13&postcount=8

http://www.chiefdelphi.com/forums/sh...15&postcount=9

http://www.chiefdelphi.com/forums/sh...&postcount=195

Re: paper: New Scouting Database from Team 2834
 

Will you be posting a 2015 version?

Re: paper: New Scouting Database from Team 2834
 

Yes I am working on it. A lot of data is missing so far plus we need to wait for some events to finish on Sunday.

Re: paper: New Scouting Database from Team 2834
 

Let's hope it's not missing permanently...

http://www.chiefdelphi.com/forums/sh...14#post1451114

Re: paper: New Scouting Database from Team 2834
 

Ed, what version of Excel will you be using for the database this year?

Re: paper: New Scouting Database from Team 2834
 

Is there much programmed in VB? If it's mostly formulas, maybe you could consider moving the spreadsheet to Google Sheets?

Re: paper: New Scouting Database from Team 2834
 

I think VBA is used to import and parse the data from the web, and to do the linear algebra heavy lifting. Probably other stuff too. Once you've gone to the trouble of learning VBA, it's a whole lot easier to use than formulas in many cases.

I was able to get the latest version imported into Excel2000, but haven't run it through the wringer yet to see if everything works.

Re: paper: New Scouting Database from Team 2834
 

I can update data and OPR for each region using the keys you specify in the instructions. However, do I have to enter the complete world WM and OPR data manually? Using the refresh commands (Ctrl+Shift+ P or O) only calls an error and asks to debug. If I try to refresh OPR on the Worldrank sheet, the calculations run on and on, adding tens of thousands of rows to the sheet. Thanks for the help and all of the time you have put in to this!

Re: paper: New Scouting Database from Team 2834
 

I update the world ranking and each week's results. Individual users do not need to worry about that.

Re: paper: New Scouting Database from Team 2834
 

Hey Ed i like hwat you're doing and was wondering when a new thread with updated rankings will be out? if there is any thing i can do to help?
Thank you

Re: paper: New Scouting Database from Team 2834
 

The database is incorrect for Midwest regional elims.
-Currently says 2338, 1756, and 171 were semifinalists. We were finalists.
-Currently says 4143, 2062, and 2830 were semifinalists. They won.

TBA shows this as well, but the FRC event page is up to date.

Re: paper: New Scouting Database from Team 2834
 

The FRC events page doesn't show the score of the final match (Finals 3) for me, but does say that the Red alliance won 2-1. The final score of Finals Match 3 was 172-166 for those that didn't watch.

Re: paper: New Scouting Database from Team 2834
 

Thank you for bringing it to my attention. My program determines which alliance is winner and which alliance is finalist. When there is a tie after the first two matches in the finals and the third match has no scores, my program would think that they are all semifinalist. Probably why TBA says the same thing. I have manually put in the score 172-166. It will be reflected next week when I publish after Week 7 events.

Re: paper: New Scouting Database from Team 2834
 

Any updates planned for 2016?

Re: paper: New Scouting Database from Team 2834
 

Ed retired and moved to the San Fran Bay area. The last I heard, he had passed the baton for update of his widely used and loved spreadsheet.

Re: paper: New Scouting Database from Team 2834
 

Do you know where the baton got passed?

Re: paper: New Scouting Database from Team 2834
 

This is all I know:
http://www.chiefdelphi.com/forums/sh...37&postcount=6

Reach out to Team 2834 Leadership and ask.

Re: paper: New Scouting Database from Team 2834
 

Baton passed to me by Ed. I have updated Scouting Database file based on this year's game and will start publishing it this week?

Thanks,
Timur Aydin
Team 2834 Mentor

Re: paper: New Scouting Database from Team 2834
 

2016 scouting database is posted to

http://www.chiefdelphi.com/media/papers/3242

Re: paper: New Scouting Database from Team 2834
 

Awesome, thank you very much for continuing with this.