Go to Post Sleep is for the weak - TEntwistle [more]
Home
Go Back   Chief Delphi > CD-Media > White Papers
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

photos

papers

everything



[revised] Update to Karthik's Scouting Database

petek

By: petek
New: 11-04-2005 16:02
Updated: 11-04-2005 16:02
Total downloads: 278 times



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

  • xls [revised] Update to Karthik's Scouting Database

    11132497242005_championship_scouting_database_050411v2.xls

    downloaddownload file

    uploaded: 11-04-2005 16:02
    filetype: xls
    filesize: 740.5kb
    downloads: 276



Recent Downloaders

  • Guest

Discussion

view entire thread

Reply

12-04-2005 20:01

Bill_Hancoc


Unread 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


Unread 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.
I should let Karthik answer, but here is my take on how to make Excel sing.

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

Reply

Tags

loading ...



All times are GMT -5. The time now is 14:58.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi