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.