paper: Aluminum Falcons (FRC2168) 2011 Scouting System Ver 1.1

[jkudo]

Hi guys,
Thanks for all the positive feedback so far - I hope the scouting system works well for all of you.

Originally Posted by RookieWookiez

Wow, awesome looking scouting sheet! We're having a bit of difficulties here with the scout input data. Everytime we try to add in an entry, we get "Run-time error '1004'" and doesn't add in the data for us. It says its an application or object-defined error. We're not sure if it's our computer that we're using or if there is some sort of error with the coding.

I know you said you figured out the error but can you go into more detail why that error was happening or how? I'd like to know if its something I can fix for future users.

Originally Posted by Carter12s

It is not super important, but has anyone found a workaround for this, or do I just need to get some more computers with excel 2003?

I believe the excel object structure and thus the coding for VBA for excel has changed between excel 2003 and excel 2007. I coded everything in excel 2003 so I know it will work for that. I can't guarantee results for any other version of excel and I probably won't get around to figuring out what has changed between the two versions to upload a 2007+ compatible scouting file.

Regarding the password for the code and the sheets, I'm pretty reluctant to reveal it because of how sloppy/non-intuitive the code is in terms of readability. Maybe if I get around to commenting at some point...?

[Bill_B]

Originally Posted by jkudo

Regarding the password for the code and the sheets, I'm pretty reluctant to reveal it because of how sloppy/non-intuitive the code is in terms of readability. Maybe if I get around to commenting at some point...?

The chef never likes to admit wiping his hands on his apron. We can forgive quite a bit when the result is solid and stable. Did you code with glasses on?

Thanks anyway. I might even be able to get my team members more interested in scouting because of this system. Stranger things have happened.

[CurseofDragon33]

Team 48 will be on Galileo and at the very least usethe scouting sheets and if we can get organized and situated in the arena in time for matches to start on Thursday we may use the database too. This will be a great help not only to me but to our students as well. Thanks!

[speedbuggy76]

We'll be using it in Newton. We went to all digital entry at North Carolina. We have a laptop for each scouter, and then we combine all the data sets into one master file at lunch/end of the day.

[avanboekel]

Originally Posted by CurseofDragon33

Team 48 will be on Galileo and at the very least usethe scouting sheets and if we can get organized and situated in the arena in time for matches to start on Thursday we may use the database too. This will be a great help not only to me but to our students as well. Thanks!

I highly suggest using the database as well. Its simple to input data, and was a major help with alliance selection. 2338 used AFSS at Midwest, so PM me if you have questions that I can help with.

[CurseofDragon33]

Originally Posted by avanboekel

I highly suggest using the database as well. Its simple to input data, and was a major help with alliance selection. 2338 used AFSS at Midwest, so PM me if you have questions that I can help with.

Ok. Thanks.

[Drivencrazy]

Hey guys,

First of all, just wanted to say thanks for your hard work. We've been using your system all year and it has been great.

We are planning on using it in the Newton division but the team list is missing team 1732 so we are unable to enter match data for them. Any way to fix that?

Thanks again and good luck.

[jwfoss]

Updated version with the latest team list (4/25/2011) with 88 Teams per field.

Glad to see people plan to use the system, I will do my best to stop by.

Anyone in Curie planning on using it? It looks like we have the other divisions supported. Is there any chance you guys would allow me to have a copy of the data to check out? Thanks.