 |
|

04-14-2008, 05:42 PM
|
 |
|
|
Join Date: Jul 2006
Location: Ann Arbor, Michigan
Posts: 3,227
|
|
|
Re: Pick the Winners-Vegas 1
Is anyone an excel wiz?
For some rason my formulas on my spreadsheet have gone wacky. Same thing happened towards the end of last season. Means I have to manually do season stats
formula reads =SUM($A$9:$AZ$9) it shows the area lit up that needs to be tabulated but it wont do it?
|

04-14-2008, 06:05 PM
|
 |
|
|
Join Date: Jul 2006
Location: Norfolk, Va
Posts: 6,019
|
|
|
Re: Pick the Winners-Vegas 1
Like Scott K. said at Topeka in '93 No Freaking Way man...
13 points, oh yeah...
thanks fer doing this PJ, Am I still in 69th?
d'kid
|

04-14-2008, 06:11 PM
|
 |
|
|
Join Date: Jul 2006
Location: Rockwall, TX - via Australia
Posts: 1,106
|
|
|
Re: Pick the Winners-Vegas 1
Quote:
Originally Posted by PJ Sapienza
More importanlt congrats to Tim Soldatos who made it through the carnage to pick up this weeks win
|
AUSSIE AUSSIE AUSSIE!!
|

04-14-2008, 06:28 PM
|
 |
|
|
Join Date: Jul 2006
Location: Connecticut
Posts: 52
|
|
|
Re: Pick the Winners-Vegas 1
How does this work? Low score wins. Right
|

04-14-2008, 08:06 PM
|
 |
|
|
Join Date: Jul 2006
Location: Splendora, TX
Posts: 3,202
|
|
|
Re: Pick the Winners-Vegas 1
Quote:
Originally Posted by PJ Sapienza
Is anyone an excel wiz?
For some rason my formulas on my spreadsheet have gone wacky. Same thing happened towards the end of last season. Means I have to manually do season stats
formula reads =SUM($A$9:$AZ$9) it shows the area lit up that needs to be tabulated but it wont do it?
|
I'm the excel diva at work.  e-mail me the spreadsheet and I'll look at it.
__________________
NAPA Nitro Fan!
If you can't stand behind our troops, feel free to stand in front of them!
|

04-14-2008, 08:13 PM
|
 |
|
|
Join Date: Jul 2006
Location: Oswego, IL
Posts: 1,679
|
|
|
Re: Pick the Winners-Vegas 1
Quote:
Originally Posted by Kelly Holmes
I'm the excel diva at work.  e-mail me the spreadsheet and I'll look at it. 
|
If Kelly can't fix it send it my way. I would check the calculation options to make sure the sheet is not in manual calculation.
|

04-14-2008, 08:34 PM
|
 |
|
|
Join Date: Jul 2006
Location: Splendora, TX
Posts: 3,202
|
|
|
Re: Pick the Winners-Vegas 1
Quote:
Originally Posted by Paul Miller
If Kelly can't fix it send it my way. I would check the calculation options to make sure the sheet is not in manual calculation.
|
Hmmmmm......Paul just threw down the gauntlet! LMAO!
__________________
NAPA Nitro Fan!
If you can't stand behind our troops, feel free to stand in front of them!
|

04-14-2008, 09:18 PM
|
 |
|
|
Join Date: Jul 2006
Location: Tempe, AZ
Posts: 1,167
|
|
|
Re: Pick the Winners-Vegas 1
What a crazy season! Figured I was gonna drop like a rock in standings and wind up P2 -  Thanks again to PJ - you excel experts need to get him back on track!
__________________
"The Counterfeiter"
|

04-14-2008, 10:55 PM
|
 |
|
|
Join Date: Nov 2006
Location: Nitroville, Colorado
Posts: 1,152
|
|
|
Re: Pick the Winners-Vegas 1
Quote:
Originally Posted by Paul Rogers Jr
AUSSIE AUSSIE AUSSIE!!
|
OYE....OYE...OYETimmah just picked up another Point on Pauly!!!!
|

04-14-2008, 11:24 PM
|
|
|
|
Join Date: Jul 2006
Location: Gig Harbor, WA
Posts: 191
|
|
|
Re: Pick the Winners-Vegas 1
Quote:
Originally Posted by John Panuzzo
Question for PJ are the picks that were submitted AFTER Fri night 12pm eligible ? After all by picking AFTER seeing all 4 qualifying runs that person has a distinct advantage ?
If so I'll hold my pick until Sat after 4th qualifying session... I just keep thinking of the BIG $$ to whoever wins...
Looking at the rules the player in 13th place>>> "13 Mark Rohwein 65" <<<
post #79 posted AFTER the deadline..Also the last pick by Mel Smith ? are these picks eligible.. if so I'd like to change mine BEFORE 1st round !
|
I live in WA state and posted 2 hours prior to the midnight deadline. Not even close to Sat. the 12th. That would've been the day of the 4th qualifying round. I'm a tad bit confused here.
I always post late on fridays. You can too if you want to.
Absolutely brutal week for everyone's picks. I can't recall a lower winning score since I've been playing. I picked Cory Mac for Houston and he wins in Vegas!! Go figure.
Last edited by Mark Rohwein; 04-14-2008 at 11:30 PM.
|

04-15-2008, 01:08 AM
|
 |
|
|
Join Date: Mar 2007
Location: Central Wisconsin
Posts: 51
|
|
|
Re: Pick the Winners-Vegas 1
Hey, how about that? I make an IRS joke and POOF, I get audited! I thought when I posted there was an hour to go, figured there would be a bunch more making changes, nope, just me. PJ, I'm still kind of a beginner at this, but wouldn't I have 17?
Tony Schumacher 2
Doug Kalitta 3
Robert Hight 2
Ashley Force 4
Jason Line 6
or no?
|

04-15-2008, 09:22 AM
|
 |
|
|
Join Date: Jul 2006
Location: Tracy,CA
Posts: 1,887
|
|
|
Re: Pick the Winners-Vegas 1
PJ, did you forget to score my pics, or did I goose-egg this week??
__________________
Evil Squirrels Are After My Nuts
Avatar courtesy of T-Nebraski
The reason I talk to myself is that I'm the only one whose answers I accept.
|

04-15-2008, 10:21 AM
|
 |
|
|
Join Date: Jul 2006
Location: Ann Arbor, Michigan
Posts: 3,227
|
|
|
Re: Pick the Winners-Vegas 1
Quote:
Originally Posted by Alan Loder
PJ, did you forget to score my pics, or did I goose-egg this week?? 
|
what do you mean you're right there clear as day
|

04-15-2008, 10:26 AM
|
 |
|
|
Join Date: Jul 2006
Location: Tracy,CA
Posts: 1,887
|
|
|
Re: Pick the Winners-Vegas 1
Quote:
Originally Posted by PJ Sapienza
what do you mean you're right there clear as day 
|
Gee, I must have missed it the 5 or so times I scanned thru the list.....
__________________
Evil Squirrels Are After My Nuts
Avatar courtesy of T-Nebraski
The reason I talk to myself is that I'm the only one whose answers I accept.
|

04-15-2008, 10:31 AM
|
 |
|
|
Join Date: Jul 2006
Location: Ann Arbor, Michigan
Posts: 3,227
|
|
|
Re: Pick the Winners-Vegas 1
Ok first off my apologies to Tim, I messed up on the scoring and didn't enter a change. I hope you didn't sell the house and quit your job after finding out you had won
Also a HUGE thank you goes to Kelly for helping me out. With my database error that I couldn't seem to figure out. Kelly you'll be happy to know that my computer and I have decided to go to a therapist. Hopefully it will help me to stop yelling at and threatening it my computer. The computer is really excited to be going, he never gets out of the office.
Ok and now for the season standings
1 Ralph Sajkowski 85
2 Mel Smith 83
3 Greg Green 82
. Ray Ghio Jr 82
5 John Rogers 81
6 Michele Martindale 80
7 Mark Rohwein 79
8 Linda Sapienza 78
9 Jim Tiggelaar 77
10 Dave Major 76
11 Paul Rogers 75
. Matt Smith 75
. Jim Young 75
14 Justin League 74
. tony Rieck 74
. Steve Haller 74
17 Mike Larson 73
. Phillip Abramson 73
. Christopher L Williams 73
. Rick Hildebrand 73
. Georginna Polson 73
22 Mike Minick 72
. Mark Kuehl 72
24 Doug Wright 70
. Mark Glading 70
. Joe Fuchita 70
27 Jeremy Weaver 69
. Chris Schoen 69
. Ross Kloeber 69
. David Williams 69
. Wayne Minick 69
32 Alan Loder 68
. Bob Pellegrini 68
. Barry Feyh 68
. Steve Bullard 68
. Frank Veloz 68
37 Mark Bell 67
. Lance Peltier 67
. Brian Papallo 67
. Tim Charlet 67
41 Amanda Smith 66
. Michael Veskovich 66
. Jared Brouwer 66
. Bruce Federwisch 66
45 Teri Sewell 64
. Sue Nichols 64
47 Cheryl Leister 63
48 PJ 62
. Devallion Pipper 62
. Howard Levine 62
. Dalton Blevins 62
. Paul Miller 62
53 Ken Rau 61
. Erik Bilisoly 61
. Martin Thomas 61
. Don Clark 61
57 John Wulff 60
. Jim Shryne 60
59 Kristen 58
. Mark Jones 57
61 Bobby Miller 56
62 Erica Ortiz 55
. Kurt Leinenjugel 55
64 Jenn Jaramillo 54
65 Karl Stalcup 53
. Bob Webb 53
67 Alan Peck 52
68 Mark Krogen 50
69 John Panuzzo 49
70 Brian Okeefe 45
71 Chris Degidio 43
72 Don Richerson 42
73 Terry Larsen 41
74 David Floyd 32
75 Jessica Murry 29
76 Steven Bunker 27
77 Tim Soldatos 26
78 Jerriod Blanchard 24
. Vincent Carmichael 24
80 Bob Kushon 23
81 Jet Townsend 21
82 Terry Jones 20
83 David Gawboy 19
84 Ton Postuma 14
85 Jesse Robinson 12
86 Rick Rzepka 10
. Todd Bade 10
88 Lynn McCarthy 9
. Chris Anderson 9
90 Chris Cook 8
91 Steven Taranda 7
. Nick Sidoti 7
. Carl Lewis 7
|
 |
|
| Thread Tools |
Search 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
HTML code is Off
|
|
|
|
|