Thanks Eiskrap. But I must be missing something from your post. I do not want this to turn into an excel explanation as I consider myself pretty good, as I understand and can do pivot tables, but this statement is not in your template that you provided:
Quote:
|
The last thing is to make sure the formula in columns AF:AG of the batting stats and AY:AZ of the pitching stats reach the bottom of the pasted data.
|
Both of those tabs (Batting Stats and Pitching Stats) in your attachment are completely empty as there are no formulas in those columns.
I will list out my steps that I took, so maybe you can point out what I did wrong.
1. Downloaded attached template
2. Turned on editing and saved as (not a 97-03 excel format because of loss of features) but instead as Microsoft office 2010 excel document.
3. The Batting Stats, Pitching Stats and Master tabs are completely blank.
4. I go to my league and select the Export Data to CSV files.
5. I then open the Players.csv file, create a new tab. I copy and paste into the Masters tab in your spreadsheet.
6. I then open players_career_batting_stats.csv and I again create a new tab. I then filter the League Id to only be of value 100 (MLB League Id). I then do a date between 2012 through 2032 for the years I want of the MLB specific player career batting stats. I finally filter the split id for only value of 1 (as I do not include left/right splits) and I then copy and paste this data into the new tab created. I then copy and paste the data out of the new tab and paste it into the Batting Stats tab of your spreadsheet.
I will stop here so it does not get much longer, but what did I do wrong or what is the next step specifically.
After doing all the above, this is what I see in Batting Charts tab.
