- GOOD NEWS, my wife has finally come to US yesterday. I am so happy. It was sad being away from her on our first marriage anniversary. But finally she came, her journey was safe and uneventful.
- Buy walmart shares if you can, now that I have shifted to a hotel bang in front of the giant store. I have been to the store 4 times yesterday alone and picked up stuff till my hands ached.
- The potters have arrived few days back. I have ordered set of first 6 books on Amazon and already in to the series big time. I dont have anything new to say about the books. If you havent read them, may be you should try once, its a different experience.
- Seems like loads of things are happening on market front. They crashed, went up again and seems like they are going to crash again. I made some hurried purchased during the recent crash, my losses arent significant now. The recession seems to here already, few Indian companies have started reducing salaries or worse still revoking the paid salaries. [I am already working in one :P], feels like such an exciting time to be living.
- I am totally crazed up to start my own web business. Exploring few ideas like a craigslist for Indian metros etc. There is nothing much to loose, but so much to gain by doing this. I could learn firsthand the nitti-gritties of running a business, managing servers, users, optimization, databases, services and so much more. If you have some exciting ideas and looking for a crazy soul to partner drop me a mail.
- Work moved to a cruise control mode. Most of the things have become normal now. Hopefully I would move to another project in the coming months.
- Oh yeah, PHD crossed a remarkable milestone(or crossing), my site bandwidth limit for this month is almost over, thats a whopping 2000 megabites served to hungry PHD readers. Well done folks. Please bear with me while I figure out better ways to manage the site by reducing unnecessary images, heavy plugins etc. If you see the site down during the next few days dont panic. Just drop in again on Feb 1st.
[Bored at work? Read the earlier blah :1 , 2, 3, 4, 5, 6, 7, 8, 9, n ]
11 Responses to “MLB Pitching Stats Dashboard in Excel+VBA by our VBA Class Student”
Hey Dan,
Thanks a lot... this is too good 🙂
Awesome stuff Dan! very impressed..
Thanks guys.
Some nice ideas in there, thanks for sharing. I noticed the list with teams has a missing value though ('Arizona Diamondbacks'). Also when manipulating Pivot Tables with VBA you should be really careful not to try to select a value that isn't in the Pivot Table, if you do all hell breaks loose 🙂 That's not the case here but just some advise as I learned the hard way...
Ah.....ya caught me.
dnrTeamName drives both the charts and the drop down list. It refers to:
=OFFSET(PvtTeams!$A$6,0,0,COUNTA(PvtTeams!$A$6:$A$40),1)
If you change A6 to A5, it fixes that little issue.
A better question though, who actually cares about the Arizona Diamondbacks?
🙂
Excellent post. Thanks
Great job, Dan! Thanks a million!
[...] MLB Pitching Statistics Dashboard [...]
Gr8 work Dan
Hi,
I downloaded file, but looks like everything is in xml. Was there suppose to be excel file as well?
Thanks!
I'm late to the party, but seeing this file in action and studying the underlying data in this Excel file has been AWESOME. I have TONS of new ideas to implement in my work files now. THANK YOU Dan and Chandoo!