Hey Dobber Nation,
Now I know these forums are filled with wisdom of all sorts and I'm hoping I can find some in the form of help with Visual Basic for Applications (VBA) in excel. It's pretty straight forward coding I'm doing, its essentially reading the value in one column which identifies the type and summing the column beside it for all values that fall into the type.
I'm doing an analysis of the last 15 years of NHL drafts and this code would save me a good (and long) days work. If there is anyone out there who knows anything about VBA, please let me know and we can likely hash this out in a couple of solid lines of code.
Reward? Rep of course and recognition on the analytical paper. Its about all I can offer, but hopefully someone is interested in giving a few posts to help me with this!
Standard 8 Team (Year 4) - 23 Man Roster - 6 Keepers - 1 pt for G, A, +/-, GWG, PPP, SHP - 0.25 pt per PIM - 2 pts W, 3 pts SO (Goalie)
C - C. Giroux, J. Pavelski, J. Toews, P. Bergeron
LW - D. Sedin, J. Franzen, D. Perron, R. Clowe
RW - C. Perry, M. St. Louis, M. Erat, B. Wheeler, V. Tarasenko
D - K. Yandle, K. Letang, M. Green, S. Salo, C. Ehrhoff, R. Diaz
G - H. Lundqvist, T. Rask, J. Hiller, C. Ward
2011-2012: 1st Place Regular Season
2010-2011: 1st Place Regular Season
2009-2010: 1st Place Regular Season
Shoot me a PM with the details (and the Excel file) and I'll take a look at it. I know VBA.
SIODL: 12-Team H2H Limited Keeper League
Back-to-Back Defending Champ!
Rosters: 3C, 5W, 5D, 1U, 2G, 9B, 2IR
Keep: 4 F, 2 D, 1 G, 1 U (F or D)
Skater Stats: G (3), A (2), +/- (0.3), PIM (0.4), PPP (0.5), SHP (1), GWG (1), SOG (0.3), Hits (0.1), FW (0.05)
Goalie Stats: W (5.5), Saves (0.25), GA (-2), SHO (2)
Trade Bait: Krejci, Wheeler, Voracek, Streit, Franson, Crawford