Quote:
Originally Posted by Joe Ross
Interesting, I just searched Missouri, and they showed up (team 4522, right?). I did notice when I did it for CA that the order was somewhat weird.
|
I copied the data from the search results & pasted into a spreadsheet; I only noticed 4522 (you're correct) was missing when I'd sorted the data by team number (I had both KS & MO in the same spreadsheet). I then went back & looked at the search results & didn't find them; that's when I did the specific search to make sure they are in the system. Maybe FIRST was tired on Sunday too.
Quote:
Originally Posted by Joe Ross
At this point, I'm not sure that it would be much faster to put in lookup tables, as the slow part would be getting the data from the different sources and putting it in the format the lookup tables expect.
|
I have the prgrammer's "it's far better to spend extra time to make something automatic, even if all the times you do that work manually would still be quicker" attitude.
I was thinking of having columns to specify each point type, and putting the number of times the team got that in the appropriate cell. Then have lookups do the math. But maybe manually would be the right way to go for this. It would be interesting to know how FiM & MAR do this; if they have a good way it only makes sense to let the rest of the soon-to-be-districized regions know.