For Valentine's Day, I will spoiler with a spring bouquet.
Home
Go Back   Chief Delphi > Technical > Programming
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
  #5   Spotlight this post!  
Unread 02-02-2007, 16:20
Setsanto's Avatar
Setsanto Setsanto is offline
Registered User
FRC #1334 (OTHS RobOTics)
Team Role: Animator
 
Join Date: Jan 2007
Rookie Year: 2007
Location: Oakville, ON (Canada)
Posts: 122
Setsanto is a jewel in the roughSetsanto is a jewel in the roughSetsanto is a jewel in the rough
Send a message via MSN to Setsanto
Re: Help with VB code

Well, it works, which is better than what I did, also, Ranking Points are divided by 3 for their final score, and finally, your IF satements in the totals columns seem kind of pointless, could you please specify what they are for?

~Nick/1334

EDIT: The statement in the last column should actually be
=IF(ISERROR(SUMIF($C$2:$GT$2,"RP",C3:GT3)/(COUNT(C3:GT3)/2)),0,SUMIF($C$2:$GT$2,"RP",C3:GT3)/(COUNT(C3:GT3)/4))/3
__________________
2008 : GTA Regional 7th Seed, Quarters
2008 : Waterloo Regional 4th Seed, Quarters
2007 : GTA Regional 2nd Seed, Quarters
2007 : Waterloo Regional Quarters

Last edited by Setsanto : 02-02-2007 at 16:27.
 


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
Help with code b-rant Programming 1 05-04-2006 13:52
Need help with code CaseyKasem_1251 Programming 3 18-02-2006 09:39
Need help with code. hawk_11 Programming 6 06-02-2005 13:56
Need help with my code jaywion Programming 9 20-03-2004 11:32
hey need some help with writing a code please help me here magical hands Programming 9 01-01-2004 21:46


All times are GMT -5. The time now is 03:50.

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