OOTP5 Excel History v5.1

kq76 · 04-29-2003, 08:24 AM

A more up to date thread is at: www.400softwarestudios.com Coming Soon!

Introducing OOTP Excel History v5.20!

In the early days of my OOTP experience, I created a small excel workbook to track some of the stats for my solo OOTP league. As time progressed I added more and more to it and after awhile I decided I should try to make it useful and available to others. And so, after much tweaking and optimizing I am finally ready to offer it to the OOTP community.

"So what exactly does it do? Why would I want to use it?", you ask.

Basically, it is an excel workbook that uses CommishJoe's Exporter CSVs to create a statistical history of a league. It is like Cato's html history, but with two main differences: 1) mine does not create html files, but 2) it does allow you to record and analyze numerous stats easily.

It keeps track of the following (helpful for determining awards or evaluating players) for each year:

-full team win / loss records
-top 10 batters
-top batter by position
-avg batter by position
-top 10 starting pitchers
-top 10 relief pitchers
-avg pitchers by position
-top fielder by position
-avg fielder by position
-top 3 rookie batters
-top 3 rookie pitchers
-top 10 postseason batters
-top 10 postseason pitchers

It also tracks over the years:

-full team win / loss records totals, averages, and ranks
-number of award winners (or top nominees) by team and by position
-stat averages above a set minimum criteria

And finally, and perhaps most interestingly, it records every stat by every player for every year so you can find both single season records (AB, AP, and AF sheets) and career records (APT sheet) with a simple sort.

"Great! So where do I get it and how do I use it?", you say.

You can download the 200KB (approx.) zip file at the following sites:

If all else fails, then just email me and I will email it back to you.

When you open the excel file, it will ask if you want to update links, click "No". (If might also ask if you want to "enable macros". You need to for it to work. I promise they are safe, but if you want to make sure, just run it through a virus scanner.) From there, just follow the short "directions" on the "home" sheet and the workbook will do the rest. After that you peruse the sheets for whatever you may be interested in.

If you have any questions, please reply in this thread. If you have any constructive criticism, you can PM me. I will try to implement the best suggestions for improvement into future versions.

Thank you and enjoy,
Kier

P.S. I would like to give a special thank you to all the previous utility makers for enhancing my OOTP experience.

Qrusher14242 · 04-29-2003, 10:50 AM

Awesome! thanks

JWay · 04-29-2003, 12:03 PM

Sorry, this site is temporarily unavailable!
The web site you are trying to access has exceeded its allocated data transfer. Visit our help area for more information.
Access to this site will be restored within an hour. Please try again later.
http://geocities.com/kq76/ootp/

jgross68 · 04-29-2003, 02:23 PM

Got it! Try again JWay.
Thanks Kieran. I created my own spreadsheet for a solo league, but nowhere near the depth of yours. Look forward to using this...

JimServo · 04-29-2003, 03:50 PM

Looks great! I keep having a problem modifying the "Location of the CSVs." Whenever I move it, it tells me "e:\desktop\csvs\league.csv" could not be found.

kq76 · 04-29-2003, 04:17 PM

Quote:

Originally posted by JimServo
Looks great! I keep having a problem modifying the "Location of the CSVs." Whenever I move it, it tells me "e:\desktop\csvs\league.csv" could not be found.

EDIT: Ok, I've uploaded v5.11 which should work fine for all. Until I can figure out how to have all the sheets recognize a new location, just put your CSVs in c:\CSVs (I figure that can work for most everyone). I just tested it on the CBL's league file for 2005 and it works fine. As before, it can be downloaded at http://geocities.com/kq76/ootp/ or by PMing me.

Sorry for not catching this problem earlier.

If you find that your file gets too big too fast (this will happen with leagues with many teams), you may want to use the "add new year without career sheets" button.

sporr · 04-29-2003, 05:37 PM

Thanks for providing your utility to the OOTP community. I'll be checking it out in the next few days.

StorminZ · 04-29-2003, 08:54 PM

Quote:

Originally posted by kq76

...

P.S. I would like to give a special thank you to all the previous utility makers for enhancing my OOTP experience.

You can add yourself to that list ... and I, too, thank all of you guys (and gals if any have been involved in utilities development) ... I can't get enough of this game!

StorminZ

Dargone · 04-29-2003, 08:55 PM

Great work

pallison14 · 04-30-2003, 12:26 AM

More great stuff -- thanks again. As great as the game is, it's the community that makes it better.

-p

kq76 · 05-02-2003, 10:32 AM

bumping it for v5.20 that fixes some problems and adds some things.

Update History:

5.20
-Redid the VB code for it to also work with Excel 97
-Added sheet links on the home sheet
-Changed sheet names to be more intuitive
-Added Glossary
-Fixed problem with RL stat
-Fixed TRST Averages and Ranks for expansion teams

5.12
-Fixed a problem with the year data caused by 5.11

5.11
-Took away ability to change the path of the CSVs. Until, I find a better workaround, put the exported CSVs into c:\CSVs.

sporr · 05-02-2003, 11:45 AM

This is a great utility that just keeps getting better. Thanks for providing it.

Tresclub · 05-02-2003, 09:37 PM

Both of Kieran's great utilities are available at my downloads site.

Tresclub's Downloads

kq76 · 05-03-2003, 03:05 AM

Thanks for the kind words everyone. It's funny, when you hear of a problem you feel real bad, embarrassed even, so you try to fix it right away. It's nice to get the positive feedback to balance that out.

kq76 · 05-05-2003, 09:12 PM

I received an email today from someone saying that they could not change the year and that the macro buttons were unresponsive. I am not yet sure that this is the problem for this person, but sometimes for me the workbook will freeze and I might have to restart the workbook and maybe stop a program or two, or even restart the computer for it to work. I think it has to do with how good your computer is and how many programs you have running at the time.

locust9 · 06-02-2003, 10:17 AM

kq-

tried to use your util to compare with cato's - seems good so far - I do get an error (seems to be my lot in life) at the beginning of the import which says "copying cells outside destination range, all data outside range will be lost, continue y/n?" to which i reply yes. Any idea what's causing this?

Also, and I'm sure other people ask for this, but it sure would be nice if the program would just search pathed folders for the csvs (ie, 2001, 2002, 2003, etc), instead of having to manually shift them around.

best,
loc

kq76 · 06-02-2003, 12:14 PM

Quote:

Originally posted by locust9
tried to use your util to compare with cato's - seems good so far - I do get an error (seems to be my lot in life) at the beginning of the import which says "copying cells outside destination range, all data outside range will be lost, continue y/n?" to which i reply yes. Any idea what's causing this?

Sounds like you have more players for a certain advanced filter than I allowed for (you must have a really big league then). Could you email me (kq76@hotmail.com) a zip of your CSV files and I'll take a look.

Quote:

Originally posted by locust9
Also, and I'm sure other people ask for this, but it sure would be nice if the program would just search pathed folders for the csvs (ie, 2001, 2002, 2003, etc), instead of having to manually shift them around.

Yeah, that was the idea originally, but I had some problems with figuring a way to do that. Ideally what I would like is to tell the excel file, "ok, here's all my CSV folders in such and such folder, process every year on your own without me pressing more than one button". Problem is though, I'm not a programmer, just a novice, so problems like that are not the easiest for me to solve. Anyways, I'll take another look at it tonight and see if I can come up with some ideas.

EDIT: If anyone has some suggestion on how to do this, they are most welcome.

locust9 · 06-02-2003, 01:22 PM

ahh, ok. I'll send it right now, although i think hotmail is going to bounce the csvs, as they are fairly large. Let me know if you got them on here.

tx much,
loc

locust9 · 06-02-2003, 01:45 PM

argh, that isn't going to work. the rar is 7.97 megs- hotmail bounced it.

/loc

kq76 · 06-02-2003, 02:03 PM

One year's worth of CSVs is a rar of almost 8 Megs? No way.. I'm guessing you're talking about a rar of your league files. Either way, upload it to the net, email me where and I'll go get it.

04-29-2003, 08:24 AM	#1
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	OOTP5 Excel History v5.20 A more up to date thread is at: www.400softwarestudios.com Coming Soon! Introducing OOTP Excel History v5.20! In the early days of my OOTP experience, I created a small excel workbook to track some of the stats for my solo OOTP league. As time progressed I added more and more to it and after awhile I decided I should try to make it useful and available to others. And so, after much tweaking and optimizing I am finally ready to offer it to the OOTP community. "So what exactly does it do? Why would I want to use it?", you ask. Basically, it is an excel workbook that uses CommishJoe's Exporter CSVs to create a statistical history of a league. It is like Cato's html history, but with two main differences: 1) mine does not create html files, but 2) it does allow you to record and analyze numerous stats easily. It keeps track of the following (helpful for determining awards or evaluating players) for each year: -full team win / loss records -top 10 batters -top batter by position -avg batter by position -top 10 starting pitchers -top 10 relief pitchers -avg pitchers by position -top fielder by position -avg fielder by position -top 3 rookie batters -top 3 rookie pitchers -top 10 postseason batters -top 10 postseason pitchers It also tracks over the years: -full team win / loss records totals, averages, and ranks -number of award winners (or top nominees) by team and by position -stat averages above a set minimum criteria And finally, and perhaps most interestingly, it records every stat by every player for every year so you can find both single season records (AB, AP, and AF sheets) and career records (APT sheet) with a simple sort. "Great! So where do I get it and how do I use it?", you say. You can download the 200KB (approx.) zip file at the following sites: If all else fails, then just email me and I will email it back to you. When you open the excel file, it will ask if you want to update links, click "No". (If might also ask if you want to "enable macros". You need to for it to work. I promise they are safe, but if you want to make sure, just run it through a virus scanner.) From there, just follow the short "directions" on the "home" sheet and the workbook will do the rest. After that you peruse the sheets for whatever you may be interested in. If you have any questions, please reply in this thread. If you have any constructive criticism, you can PM me. I will try to implement the best suggestions for improvement into future versions. Thank you and enjoy, Kier P.S. I would like to give a special thank you to all the previous utility makers for enhancing my OOTP experience. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080) Last edited by kq76; 08-10-2025 at 11:37 PM.

04-29-2003, 02:23 PM	#4
jgross68 All Star Reserve Join Date: Feb 2002 Location: ....is everything! OTA: .882, Member #866 Posts: 690	Got it! Try again JWay. Thanks Kieran. I created my own spreadsheet for a solo league, but nowhere near the depth of yours. Look forward to using this... __________________ Javier Gustavo Ruprecht Oss LXVIII Bizarro-Gastric ReFlux Emeritus Judo Purist and Supporter of Monkey Rodeo Leagues: OTBL \| ABC \| OCHO \| Off The Wall (Coming Soon!) Blogs: The Legacy of Tony Womack \| How We Got Enron! ...the musical (Now even less frequently updated!) Topical quote for any occasion: "Never wear your best trousers when you go out to fight for freedom and truth." ~Henrik Ibsen, "An Enemy of the People"

04-29-2003, 03:50 PM	#5
JimServo Major Leagues Join Date: Dec 2001 Location: Near Philadelphia, PA Posts: 418	Looks great! I keep having a problem modifying the "Location of the CSVs." Whenever I move it, it tells me "e:\desktop\csvs\league.csv" could not be found. __________________ "When I was a small boy in Kansas, a friend of mine and I went fishing and as we sat there in the warmth of the summer afternoon on a river bank, we talked about what we wanted to do when we grew up. I told him that I wanted to be a real major league baseball player, a genuine professional like Honus Wagner. My friend said that he'd like to be President of the United States. Neither of us got our wish." -Dwight D. Eisenhower

04-29-2003, 08:55 PM	#9
Dargone Hall Of Famer Join Date: Feb 2002 Location: Interwebs Posts: 2,862	Great work __________________ I was never one to patiently pick up broken fragments and glue them together again and tell myself that the mended whole was as good as new. What is broken is broken -- and I'd rather remember it as it was at its best than mend it and see the broken places as long as I lived.-Margaret Mitchell

04-30-2003, 12:26 AM	#10
pallison14 Major Leagues Join Date: Mar 2002 Posts: 452	More great stuff -- thanks again. As great as the game is, it's the community that makes it better. -p __________________ Commissioner, NGBL - Putting the FUNK in defunct. New York (AL), UBL

04-29-2003, 10:50 AM	#2
Qrusher14242 All Star Starter Join Date: Feb 2002 Location: CA Posts: 1,253	Awesome! thanks

04-29-2003, 12:03 PM	#3
JWay Hall Of Famer Join Date: Dec 2001 Location: Sioux Falls, SD Posts: 5,031	Sorry, this site is temporarily unavailable! The web site you are trying to access has exceeded its allocated data transfer. Visit our help area for more information. Access to this site will be restored within an hour. Please try again later. http://geocities.com/kq76/ootp/

04-29-2003, 05:37 PM	#7
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	Thanks for providing your utility to the OOTP community. I'll be checking it out in the next few days.

05-02-2003, 10:32 AM	#11
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	bumping it for v5.20 that fixes some problems and adds some things. Update History: 5.20 -Redid the VB code for it to also work with Excel 97 -Added sheet links on the home sheet -Changed sheet names to be more intuitive -Added Glossary -Fixed problem with RL stat -Fixed TRST Averages and Ranks for expansion teams 5.12 -Fixed a problem with the year data caused by 5.11 5.11 -Took away ability to change the path of the CSVs. Until, I find a better workaround, put the exported CSVs into c:\CSVs. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080)

05-02-2003, 11:45 AM	#12
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	This is a great utility that just keeps getting better. Thanks for providing it.

05-02-2003, 09:37 PM	#13
Tresclub All Star Starter Join Date: Dec 2001 Location: La Mesa, CA USA Posts: 1,908	Both of Kieran's great utilities are available at my downloads site. Tresclub's Downloads

05-03-2003, 03:05 AM	#14
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	Thanks for the kind words everyone. It's funny, when you hear of a problem you feel real bad, embarrassed even, so you try to fix it right away. It's nice to get the positive feedback to balance that out. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080)

05-05-2003, 09:12 PM	#15
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	I received an email today from someone saying that they could not change the year and that the macro buttons were unresponsive. I am not yet sure that this is the problem for this person, but sometimes for me the workbook will freeze and I might have to restart the workbook and maybe stop a program or two, or even restart the computer for it to work. I think it has to do with how good your computer is and how many programs you have running at the time. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080)

06-02-2003, 10:17 AM	#16
locust9 Minors (Rookie Ball) Join Date: Mar 2002 Posts: 36	kq- tried to use your util to compare with cato's - seems good so far - I do get an error (seems to be my lot in life) at the beginning of the import which says "copying cells outside destination range, all data outside range will be lost, continue y/n?" to which i reply yes. Any idea what's causing this? Also, and I'm sure other people ask for this, but it sure would be nice if the program would just search pathed folders for the csvs (ie, 2001, 2002, 2003, etc), instead of having to manually shift them around. best, loc Last edited by locust9; 06-02-2003 at 11:13 AM.

06-02-2003, 01:22 PM	#18
locust9 Minors (Rookie Ball) Join Date: Mar 2002 Posts: 36	ahh, ok. I'll send it right now, although i think hotmail is going to bounce the csvs, as they are fairly large. Let me know if you got them on here. tx much, loc

06-02-2003, 01:45 PM	#19
locust9 Minors (Rookie Ball) Join Date: Mar 2002 Posts: 36	argh, that isn't going to work. the rar is 7.97 megs- hotmail bounced it. /loc

06-02-2003, 02:03 PM	#20
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	One year's worth of CSVs is a rar of almost 8 Megs? No way.. I'm guessing you're talking about a rar of your league files. Either way, upload it to the net, email me where and I'll go get it. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080)