-
BLACKHAND
- Posts: 1945
- Joined: Tue Aug 31, 2004 6:00 pm
- Location: DANBURY , CT
Post
by BLACKHAND » Sat Dec 11, 2010 2:02 pm
Originally posted by Sandman62:
The bulk of the time would indeed be copying all the lineups and pasting them into Excel. Couldn't the Fanball programmers write a SQL query from their database and export the results to comma-delimted format? Then as Wayne said, it's just a matter of using the vloookup function against the stats at the end of the day.
I'd be willing to help out (and I'm not even IN the playoffs). But not if I have to manually copy/paste all the lineups. mike , this is an english speaking country. welcome to america now speak english.
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
THIS IS THE BUSINESS WE HAVE CHOSEN
-
Ted's Cracked Head
- Posts: 2817
- Joined: Sun Aug 28, 2005 6:00 pm
Post
by Ted's Cracked Head » Sat Dec 11, 2010 2:14 pm
quote:
Originally posted by Sandman62:
The bulk of the time would indeed be copying all the lineups and pasting them into Excel. Couldn't the Fanball programmers write a SQL query from their database and export the results to comma-delimted format? Then as Wayne said, it's just a matter of using the vloookup function against the stats at the end of the day.
I'd be willing to help out (and I'm not even IN the playoffs). But not if I have to manually copy/paste all the lineups.
mike , this is an english speaking country. welcome to america now speak english. Figures, I offer to help and then Wayne and Mike jump in with their fancy terms just to make me look bad. That's the final straw. I ain't helping now!
My mama says she loves me but she could be jiving too! BB King
-
pizzatyme
- Posts: 3528
- Joined: Fri Apr 13, 2007 6:00 pm
Post
by pizzatyme » Sat Dec 11, 2010 2:21 pm
What about pivot tables? Scenarios?
2008- Didn't finish last overall in the Classic.
2009- Didn't finish last overall in the Classic or Primetime.
-
Glenneration X
- Posts: 1704
- Joined: Thu Apr 09, 2009 6:00 pm
- Location: Long Island, NY
Post
by Glenneration X » Sat Dec 11, 2010 2:22 pm
Why do I picture Fanball's IT department reading this thread and having the following conversation....
"What's an SQL query?"
"I don't know, I'm still looking up vlookup function."
J/K
Glenn
-
Ted's Cracked Head
- Posts: 2817
- Joined: Sun Aug 28, 2005 6:00 pm
Post
by Ted's Cracked Head » Sat Dec 11, 2010 2:27 pm
Now I have Russ piling on me with his big words? You guys are like sharks that smell blood. Don't you folks have championship rosters to look after?
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
My mama says she loves me but she could be jiving too! BB King
-
pizzatyme
- Posts: 3528
- Joined: Fri Apr 13, 2007 6:00 pm
Post
by pizzatyme » Sat Dec 11, 2010 2:32 pm
Originally posted by Glenneration X:
Why do I picture Fanball's IT department reading this thread and having the following conversation....
"What's an SQL query?"
"I don't know, I'm still looking up vlookup function."
J/K
Glenn
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
2008- Didn't finish last overall in the Classic.
2009- Didn't finish last overall in the Classic or Primetime.
-
pizzatyme
- Posts: 3528
- Joined: Fri Apr 13, 2007 6:00 pm
Post
by pizzatyme » Sat Dec 11, 2010 2:34 pm
Originally posted by Silver and Black:
Now I have Russ piling on me with his big words? You guys are like sharks that smell blood. Don't you folks have championship rosters to look after?
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
What's the holidays without a little piling on?!
Season's Greetings!
2008- Didn't finish last overall in the Classic.
2009- Didn't finish last overall in the Classic or Primetime.
-
Ted's Cracked Head
- Posts: 2817
- Joined: Sun Aug 28, 2005 6:00 pm
Post
by Ted's Cracked Head » Sat Dec 11, 2010 2:35 pm
Seriously now: If I was a gambling man I would wager that Fanball gets all over this early next week and they will make our fantasy dreams come true before week 15.
How sure am I? If they don't, I will retire from HSFF altogether! Now most of you don't want to see the improvement. See, problem solved!
Let's lock this baby down and enjoy some good old fashioned NFL football tomorrow.
Reality - 75% of us will not want to see how our teams are stacking up vs the rest tomorrow and will be looking for a bridge high enough to make the nightmare end. j/k
My mama says she loves me but she could be jiving too! BB King
-
Sandman62
- Posts: 3539
- Joined: Sat Aug 16, 2008 6:00 pm
- Location: RI
Post
by Sandman62 » Sat Dec 11, 2010 3:07 pm
Haha Frank. I WAS speaking English - to us programmers, this IS English. . But really, for the amount of work this should take for someone who has access to the database, it's not rocket science. And I think Fanball should be scrambling to pull this together, not us.
-
Coltsfan
- Posts: 3446
- Joined: Sat May 27, 2006 6:00 pm
- Location: Evansville, IN
Post
by Coltsfan » Sat Dec 11, 2010 4:32 pm
The primetime leaderboard is up under NFFC Primetime Facts
Wayne