View Single Post
  #10   Spotlight this post!  
Unread 25-02-2009, 20:56
theCoder's Avatar
theCoder theCoder is offline
Registered User
AKA: Larry Mead
FRC #0956
Team Role: Mentor
 
Join Date: Feb 2007
Rookie Year: 2005
Location: Corvallis OR
Posts: 17
theCoder is on a distinguished road
Re: GUSS Scouting System

Quote:
Originally Posted by JesseK View Post
After playing with it a bit further, I too encountered this. After some investigation, it looks like it's a formatting error.

If you manually enter in each team number on the team list tab, the cells are formatted incorrectly and you will get this error. Hence, you need to copy/paste in a team list from somewhere else.

If you manually enter in the team #'s on the matches tab, then double click the match number, you see that in the 'notes' section you have your team #'s right aligned, whereas the original copy has them left-aligned. You also cannot double-click the team here or on the matches page to automatically go to that team's tab. The workaround for this one is to copy each team # cell from the team list tab over to the matches tab. Then it works perfectly.

Starting with the original, if you manually enter team numbers (e.g. 1130) for a new match, you will get an error that says the team is not found in the team list. This furthers my suspicions that all of the VLOOKUPS look at formatting.

Ok, so some bugs, and some workarounds, but I still like it
I never saw the problem with the teams because I cut & pasted the list. I also ran into another vlookup issue with formatting. Today I was working on a "my team" page and I ran into problems where the team # was not being found in the team list.

Stay tuned....
__________________
I'll pick up my mess, as soon as I'm done here...