Go to Post oh, the prom! I thought you were missing a PROM (Programable Read Only Memory) ...you had me worried for a minute, I dont know if IFI has any spare PROMs. - KenWittlief [more]
Home
Go Back   Chief Delphi > ChiefDelphi.com Website > Extra Discussion
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Spotlight this post!  
Unread 12-04-2005, 20:28
Joe Johnson's Avatar Unsung FIRST Hero
Joe Johnson Joe Johnson is offline
Engineer at Medrobotics
AKA: Dr. Joe
FRC #0088 (TJ2)
Team Role: Engineer
 
Join Date: May 2001
Rookie Year: 1996
Location: Raynham, MA
Posts: 2,648
Joe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond reputeJoe Johnson has a reputation beyond repute
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.
__________________
Joseph M. Johnson, Ph.D., P.E.
Mentor
Team #88, TJ2
Reply With Quote
 


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
White Paper Discuss: Karthik's 2005 Championship Scouting Database Karthik Extra Discussion 33 11-04-2005 15:05
White Paper Discuss: Joystick Sensitivity Demystified - Version 2 marccenter Extra Discussion 0 28-02-2005 16:54
White Paper Discuss: Continuous Improvement Process for FIRST Teams Chris Fultz Team Organization 2 05-01-2005 20:52
White Paper Discuss: Comparison Paper for Teacher Involvement CD47-Bot Extra Discussion 1 13-11-2004 00:09
White Paper Discuss: Karthik's Championship Event Data CD47-Bot Extra Discussion 20 13-04-2004 08:17


All times are GMT -5. The time now is 17:33.

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