[more] Smoky Mountain Regional : 18d 12h 05m ... Orlando Regional : 25d 12h 05m ... Peachtree Regional : 32d 12h 05m ...
Go to Post Don't let your FIRST blinders prevent you from thinking. - JaneYoung [more]
Home
Go Back   Chief Delphi > CD-Media > White Papers
Team 51   CD-Events   CD-Media   CD-Swap   CD-Spy   FRC-Spy   Unsung FIRST Heroes   WFA
portal register members calendar search Today's Posts Mark Forums Read FAQ rules
VEXpro
The Chief Delphi Forums are sponsored by Innovation First International, Inc.
ADVERTISEMENT

photos

papers

everything



[revised] Update to Karthik's Scouting Database

petek

By: petek
New: 04-11-2005 04:02 PM
Updated: 04-11-2005 04:02 PM
Total downloads: 140 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: 04-11-2005 04:02 PM
    filetype: xls
    filesize: 740.5kb
    downloads: 138



Recent Downloaders

Discussion

view entire thread

Reply

04-12-2005 08:01 PM

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.



04-12-2005 08:28 PM

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 04:54 PM.

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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright © Delphi and Pontiac Central High School