Can Some Patient Soul...

[nevdully's]

Teach me how to compile my teams stats?

If not no worries...Thanks

Nev

[Valen]

Not sure what you mean by compile. Perhaps if you were a little more specific someone would be more likely to be helpful.

[nevdully's]

Put each season of my teams, and individual stats on a Excell speadsheet (or sumptin like this).

[Valen]

Click just to the left of the first column heading, click and hold down your mouse while dragging down to highlight all the team stats. Then paste this in to Excel. Note that sometimes the paste does not go well when using firefox as your browser. It has something to do with how it handles html tables. If I remember right sometimes it will dump all copied contents in to one cell. But if you use IE then the paste will fall with each stat column in a separate excel column.

From there you can manipulate it any way you want with one gotcha. Some of the cell contents will copy as link types and jump out of excel every time you click it (salary and player names for example). To get around this use the paste special feature and paste values only. Then everything will be formatted as simple text and numbers.

I do not capture my entire team (though probably should) but I have copied the team stat line to a spreadsheet which allows me to track over a period of time how my team performs after a trade. Basically I capture stats at time of trade and then periodically capture stats after. The spreadsheet then does the math to determine what numbers have been posted since the trade. This allows me to better judge the impact a trade had on my offense and pitching ERA. For example I trade you Maddux for Mantle. I see how much my offense went up and my era went up, runs per game, etc. From that I determine if it was a good trade or not for future references.

[Valen]

If my understanding of what you are trying to do appears on the right track and you would like a sample spreadsheet of a couple of your past teams to get you jump started send me a pm with your email address. I will throw something together and send it as an attachment.

If you do might want to let me know what you think your excel skills are so I do not get too cute and send something too complicated for you to use. A company I once worked for had a consultant come in after I left and was going to rewrite all their spreadsheets from scratch because he could not follow it all. :lol: I am good at Excel and occasionally get carried away.

[JOSEPHKENDALL]

You can also use Excel to import the data. Go to the Data tab (Excel 2003) and select From Web in the Get External Data pane of the ribbon. I had to select the line that said Simulated Stats, the Pitcher's data, and the Hitter's data to get the Pitcher's and Hitter's data to appear in the worksheet.

[Valen]

The from web option has the advantage of properly formatting your data which is a big plus. It does have disadvantage of importing unnecessary copyright information at bottom of spreadsheet. But this is easily deleted. The B column will then need to be resized as it will be extremely wide for just whether a batter hit left or right.

Was the from web option available prior to office 2007? I will have to play with that when I get some time at home where I have office 2003. An advantage of the from web feature is once you play with it some might be possible to automate it with a macro.

[Valen]

Admittedly, my copy and paste method is left over from before this feature was available. Using the from web option has another advantage in that it does not require as much skill with the mouse. You have to do the highlighting just right to copy it. So I likely will start using this method if my 2003 version supports it.

[JOSEPHKENDALL]

Actually I have the 2007 version. I thought it was 2003 at first. I don't remember if the 2003 version has it or not.

[nevdully's]

Guys I'm on it...well not really. Twice when trying to download the "Free trial version" of Excell it said it failed...I'll get right back on this after my 5 o'clock waivers and dinner...Thanks a bunch to the 2 of you...whether I get through this or not. :)