Anyone really good with Excel? - Fantasy Football Cafe 2014 Fantasy Football Cafe


Return to General Talk

Anyone really good with Excel?

Moderator: Football Moderators

Anyone really good with Excel?

Postby joelamosobadiah » Fri Jan 12, 2007 1:28 pm

Hey, is anybody here really good with Excel? I am going to need some help with a project (football project) I am doing and was just curious. It won't take more than a few minutes. I just need somebody to check it out for bugs, etc. It would be nice if somebody here knows some Visual Basic (I don't, but am learning this year in college) so that they could tweak anything that was wrong. Anyways, thanks whoever. ;-D
Image
joelamosobadiah
Mod in Retirement
Mod in Retirement

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterGolden Eagle EyePick 3 Weekly WinnerMatchup Meltdown SurvivorCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 16386
Joined: 4 Sep 2006
Home Cafe: Football
Location: Gun control is hitting what you aim at.

Re: Anyone really good with Excel?

Postby The_Captain » Fri Jan 12, 2007 2:58 pm

joelamosobadiah wrote:Hey, is anybody here really good with Excel? I am going to need some help with a project (football project) I am doing and was just curious. It won't take more than a few minutes. I just need somebody to check it out for bugs, etc. It would be nice if somebody here knows some Visual Basic (I don't, but am learning this year in college) so that they could tweak anything that was wrong. Anyways, thanks whoever. ;-D


What exactly are you needing done?

I know VBA and designed a football spreadsheet last year having to write a ton of code for it. I'm also a software tester and fairly good at breaking stuff so if need something tested let me know, I'll be happy to help.
Image
Image

"This is your captain calling--with an urgent warning" - The The
The_Captain
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe RankerMock(ing) DrafterEagle EyePick 3 Weekly WinnerSweet 16 SurvivorCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 13949
Joined: 8 Oct 2003
Home Cafe: Football
Location: Lurking somewhere between here and there...

Postby knapplc » Fri Jan 12, 2007 3:00 pm

It sounds like I'm not nearly in the league of The Captain, but I'm not without some knowledge of Excel. I'd be willing to help, too.
Image
How 'bout them Huskers!
knapplc
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe WriterCafe RankerGolden Eagle EyeCafe MusketeerCafe Blackjack Weekly Winner
Posts: 18961
Joined: 27 Dec 2004
Home Cafe: Football
Location: It's an L, not an I

Postby joelamosobadiah » Fri Jan 12, 2007 3:05 pm

OK, I am making a football stats spreadsheet. No big deal, but I am making it so the average Joe can input his league scoring settings, etc. and get custom rankings. I just need one or two guys to proof it when it is done. I didn't know if there was even anybody here that did it at all. It looks like I have my two guys. ;-D

I will drop you a PM when I have it finished. I thought I was done earlier, but found some more bugs so it will be a little bit longer or maybe this weekend. ;-D

Thanks guys. ;-D
Image
joelamosobadiah
Mod in Retirement
Mod in Retirement

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterGolden Eagle EyePick 3 Weekly WinnerMatchup Meltdown SurvivorCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 16386
Joined: 4 Sep 2006
Home Cafe: Football
Location: Gun control is hitting what you aim at.

Postby The_Captain » Fri Jan 12, 2007 3:08 pm

joelamosobadiah wrote:OK, I am making a football stats spreadsheet. No big deal, but I am making it so the average Joe can input his league scoring settings, etc. and get custom rankings. I just need one or two guys to proof it when it is done. I didn't know if there was even anybody here that did it at all. It looks like I have my two guys. ;-D

I will drop you a PM when I have it finished. I thought I was done earlier, but found some more bugs so it will be a little bit longer or maybe this weekend. ;-D

Thanks guys. ;-D


:-b - your spreadsheet sounds exactly like what I did! I can email you a copy of mine if you like so you can compare it.
Image
Image

"This is your captain calling--with an urgent warning" - The The
The_Captain
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe RankerMock(ing) DrafterEagle EyePick 3 Weekly WinnerSweet 16 SurvivorCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 13949
Joined: 8 Oct 2003
Home Cafe: Football
Location: Lurking somewhere between here and there...

Postby joelamosobadiah » Fri Jan 12, 2007 3:16 pm

The_Captain wrote:
joelamosobadiah wrote:OK, I am making a football stats spreadsheet. No big deal, but I am making it so the average Joe can input his league scoring settings, etc. and get custom rankings. I just need one or two guys to proof it when it is done. I didn't know if there was even anybody here that did it at all. It looks like I have my two guys. ;-D

I will drop you a PM when I have it finished. I thought I was done earlier, but found some more bugs so it will be a little bit longer or maybe this weekend. ;-D

Thanks guys. ;-D


:-b - your spreadsheet sounds exactly like what I did! I can email you a copy of mine if you like so you can compare it.

Allright, you can go ahead and e-mail it to me. I figured it had been done before, but figured I would do one. I am taking VBA and JavaScripting in College this semester at college, so I wanted to mess around with Excel too. ;-D

Anyways, go ahead and e-mail it too me. Is it current with the stats?
Image
joelamosobadiah
Mod in Retirement
Mod in Retirement

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterGolden Eagle EyePick 3 Weekly WinnerMatchup Meltdown SurvivorCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 16386
Joined: 4 Sep 2006
Home Cafe: Football
Location: Gun control is hitting what you aim at.

Postby BGbootha » Fri Jan 12, 2007 3:20 pm

I have thought about trying this, but how do you account for rookies, or players like a Donovan McNabb, who missed a bunch of time this year due to injury. just curious and thinking outloud.

Anyway, good luck with this it sounds like a good tool.
Image
BGbootha
General Manager
General Manager

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeCafe Blackjack Weekly Winner
Posts: 3830
Joined: 18 Feb 2003
Home Cafe: Football
Location: Teaching is the Greatest Job in the World!!! (during the Summer)

Postby joelamosobadiah » Fri Jan 12, 2007 3:27 pm

BGbootha wrote:I have thought about trying this, but how do you account for rookies, or players like a Donovan McNabb, who missed a bunch of time this year due to injury. just curious and thinking outloud.

Anyway, good luck with this it sounds like a good tool.


The purpose of the tool is so that after the league sites close down, you can see approximately where guys fell in the final standings in total points for your league. If it is done right, it will have final points and points/game, so that will cover injuries. ;-D
Image
joelamosobadiah
Mod in Retirement
Mod in Retirement

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterGolden Eagle EyePick 3 Weekly WinnerMatchup Meltdown SurvivorCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 16386
Joined: 4 Sep 2006
Home Cafe: Football
Location: Gun control is hitting what you aim at.

Postby BGbootha » Fri Jan 12, 2007 3:29 pm

ohhh so this is a tool to look at the previous season in relation to your leagues scoring? I thought it was a projection tool for next season.
Image
BGbootha
General Manager
General Manager

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeCafe Blackjack Weekly Winner
Posts: 3830
Joined: 18 Feb 2003
Home Cafe: Football
Location: Teaching is the Greatest Job in the World!!! (during the Summer)

Postby joelamosobadiah » Fri Jan 12, 2007 3:31 pm

BGbootha wrote:ohhh so this is a tool to look at the previous season in relation to your leagues scoring? I thought it was a projection tool for next season.

Correct. A projection tool would be impossible. I guess you could compare what next year's opponents will be and project based on that, but it wouldn't work very well. :-t
Image
joelamosobadiah
Mod in Retirement
Mod in Retirement

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterGolden Eagle EyePick 3 Weekly WinnerMatchup Meltdown SurvivorCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 16386
Joined: 4 Sep 2006
Home Cafe: Football
Location: Gun control is hitting what you aim at.

Next

Return to General Talk

Who is online

Users browsing this forum: Google [Bot] and 3 guests

Forums Articles & Tips Start & Sit Sleepers Rankings Leagues


Get Ready...
The 2014 NFL season kicks off in 10:07 hours
(and 37 days)
2014 NFL Schedule


  • Fantasy Football
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact