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.
Quote:
Originally Posted by bilal1219
i cannot change the game # no matter ho many times i click on it it stays the same every match.
|
As I said before...
Quote:
|
Just cursor into the cell and change it manually (the sheet protection prevents clicking directly in the cell...
|
The easiest way may be to click in one of the team cells and cursor up.
Quote:
|
Originally Posted by bilal1229
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.
|
I believe this is scoring correctly base upon sections 9a.3.4 & 9a.3.5.
Quote:
Originally Posted by bilal1219
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.
|
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