Anyone really good with Excel?

[joelamosobadiah]

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.

[The_Captain]

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.

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.

[knapplc]

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.

[joelamosobadiah]

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.

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.

Thanks guys.

[The_Captain]

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.

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.

Thanks guys.

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

[joelamosobadiah]

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.

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.

Thanks guys.

- 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.

Anyways, go ahead and e-mail it too me. Is it current with the stats?

[BGbootha]

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.

[joelamosobadiah]

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.

[BGbootha]

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.

[joelamosobadiah]

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.