paper: New Scouting Database from Team 2834

[nuclearnerd]

Originally Posted by Gregor

No issues for me.

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

[Gregor]

Originally Posted by nuclearnerd

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

Huh.

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

[eddie12390]

Originally Posted by Gregor

Huh.

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

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)

[Ether]

Originally Posted by nuclearnerd

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

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

[Dragonking]

Will you be posting a 2015 version?

[Ed Law]

Originally Posted by Dragonking

Will you be posting a 2015 version?

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.

[Ether]

Originally Posted by Ed Law

A lot of data is missing so far...

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

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

[Ether]

Originally Posted by Ed Law

Yes I am working on it.

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

[nuclearnerd]

Originally Posted by Ether

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

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

[Ether]

Originally Posted by nuclearnerd

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

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.

[allen.mays]

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!

[Ed Law]

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

[RomeroFRC5012]

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

[evanperryg]

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.

[Steve2062]

Originally Posted by evanperryg

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.

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.