paper: Database scoring (Excel) - Waterloo
 

Thread created automatically to discuss a document in CD-Media.

Database scoring (Excel) - Waterloo by kramarczyk

Re: paper: Database scoring (Excel) - Waterloo
 

Hey guyz,

I had some issues with this scouting sheet. First of all, It does not let me change the Blue Panalties whereas in red i can do that.Second issue is that the place where it says to enter 3 teams in each alliance(on the scoreboard), It starts from Game # 3 Rather Than Game # 1. And Third one is If you have time, Can you plz Set the scouting sheet on the GTR settings as i am not familiar with VB. Also Since They Updated the team list of Waterloo Regional You might have to get the updated version of the same scouting sheet.

Thank you very much in advance.

Team 1219
Scouting Captain.

Re: paper: Database scoring (Excel) - Waterloo
 

Good catch with the penalties thing... I didn't write that portion of the sheet and it was locked when I got it, so I don't know how it works. As for the match number... naughty me, I missed cleaning that up before I uploaded it. Just cursor into the cell and change it manually (the sheet protection prevents clicking directly in the cell. You'll need to do that for each match anyway. You can type in whatever teams you want; there is no macro involved.

Have fun,
Mark

Re: paper: Database scoring (Excel) - Waterloo
 

Hey,

Thak you man..but i dont know..there is some problem in the coding. since i cannot change the game # no matter ho many times i click on it it stays the same every match.The second thing is, For example Red team has won the game by 10-2, all 6 teams (red and blue alliance) gets 2 RPs and only 3 get 2 QP. Whereas in my opinion only 3 teams should be getting 2 RP and 2 QP. The other thing is you should consider adding more teams from waterloo 3 teams have been recently added to the regional.

thankyou very much fo the help.

Bilal shahid
Team 1219

Re: paper: Database scoring (Excel) - Waterloo
 

Hi,

The scouting sheet which you posted sometimes doesn't work. for example,if i want to test it i just say max for red and blue. But the problem is when i say get data it produces an error.

I just wanted to let you know.
Thanks,

Bilal

Re: paper: Database scoring (Excel) - Waterloo
 

Sorry for the delay... it's build season. Some background before I try to answer some of your questions...

This was created to help setsanto figure out how to move the match results to a common sheet so that he could tally them up for match rankings.

As I said before... The easiest way may be to click in one of the team cells and cursor up.

I believe this is scoring correctly base upon sections 9a.3.4 & 9a.3.5.

OK this one is completely my deal... Are you using Excel 2000? I think the root cause is that I recorded the macro on excel 2003, but it captured more than 2000. It throws an error when I use it on 200 at home. Sorry for the inconvienience. Remind me after ship and I'll get it fixed before the regional for you. Robot is behind. gtg

Re: paper: Database scoring (Excel) - Waterloo
 

Hey dude

I have Office 2003 at home and it works fine. But as soon as i work on my school computers with ms office 2000 it gives the code error sometimes. Would you kindly get it up and running for the ms excel 2000.

On behalf of me and team 1219 would like to appriciate the help you giving to us.

Thank you very much.

Bilal Shahid
Team 1219.

Re: paper: Database scoring (Excel) - Waterloo
 

well, I must say, I'm glad to see my scoresheet being used by others. Sorry about locking the fields, although I don't remember exactly what I used for a password, I have an unlocked version saved that I'd be glad to share w/you. Just send me an e-mail and I'll send it to you.