|
|
|
 Sleep is for the weak - TEntwistle [more] |
 |
|
|||||||
|
||||||||
[revised] Update to Karthik's Scouting Database
I fixed a couple of formatting errors (which gave two teams 21-0-0, instead of 2-10-0 records) and added division regional wins statistics. Any errors are almost certainly mine! Please let me or Karthik know if you find any more.
Enjoy!
I fixed a couple of formatting errors (which gave two teams 21-0-0, instead of 2-10-0 records) and added division regional wins statistics. Any errors are almost certainly mine! Please let me or Karthik know if you find any more.
Enjoy!
Attached Files
-
[revised] Update to Karthik's Scouting Database
11132497242005_championship_scouting_database_050411v2.xls
download file
uploaded: 11-04-2005 16:02
filetype: xls
filesize: 740.5kb
downloads: 276
Discussion
view entire thread
12-04-2005 20:01
Bill_Hancoc
Re: White Paper Discuss: [revised] Update to Karthik's Scouting Database
This is really great, could you please explain to me how you do things like this?
I would like to make a few team related updates for scouting purposes.
12-04-2005 20:28
Joe Johnson
Re: White Paper Discuss: [revised] Update to Karthik's Scouting Database
Quote:
|
Originally Posted by Bill_Hancoc
This is really great, could you please explain to me how you do things like this?
I would like to make a few team related updates for scouting purposes. |
One of the most under utilized functions... ...function pairs actually are MATCH and OFFSET.
Basically, you use MATCH to find what row a something is in then use the OFFSET function to return the contents of a cell that is near that cell (perhap in the same row only in another column).
IF is another very powerful function that lets you pick the right value or dislay errors etc.
OFFSET, MATCH and IF are pretty clunky to use due to their syntax, but once you get the zen of Excel syntax, you can make very powerful spreedsheets.
Joe J.
view entire thread
Tags
loading ...
All times are GMT -5. The time now is 14:58.
The Chief Delphi Forums are sponsored by Innovation First International, Inc.