Go to Post Changing the world starts with changing yourself. - Jeremy_Mc [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

 
Reply
Thread Tools Rate Thread Display Modes
  #1   Spotlight this post!  
Unread 12-04-2005, 19:56
petek's Avatar
petek petek is offline
What would Dave do?
AKA: Peter Kieselbach
FRC #3654 (Tech Tigers)
Team Role: Mentor
 
Join Date: May 2002
Rookie Year: 2002
Location: Middletown, CT
Posts: 923
petek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond reputepetek has a reputation beyond repute
Send a message via AIM to petek
White Paper Discuss: [revised] Update to Karthik's Scouting Database

Thread created automatically to discuss a document in the White Papers.

[revised] Update to Karthik\'s Scouting Database by petek
__________________
Pete Kieselbach
#4

Reply With Quote
  #2   Spotlight this post!  
Unread 12-04-2005, 20:01
Bill_Hancoc's Avatar
Bill_Hancoc Bill_Hancoc is offline
Volkswagen Enthusiast
AKA: Bill Hancock
FRC #0573 (MechWarriors)
Team Role: Mechanical
 
Join Date: Mar 2005
Rookie Year: 2005
Location: Ortonville MI.
Posts: 589
Bill_Hancoc has much to be proud ofBill_Hancoc has much to be proud ofBill_Hancoc has much to be proud ofBill_Hancoc has much to be proud ofBill_Hancoc has much to be proud ofBill_Hancoc has much to be proud ofBill_Hancoc has much to be proud ofBill_Hancoc has much to be proud ofBill_Hancoc has much to be proud of
Send a message via AIM to Bill_Hancoc
Exclamation 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.
__________________

MechWarriors 573

Reply With Quote
  #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
Reply


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 00:48.

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