Win Shares now available - Page 2

Henry · 12-24-2002, 02:44 PM

Stacy,

I got it to work with my eight team league - just told the macro not to do teams 9-16. Maybe all you'll need (once it works for 32 teams) is to change one macro for smaller leagues.

Henry

IatricSB · 12-24-2002, 02:48 PM

Thanks for the info Henry, I'll give it a try. I'm surprised the 1st sheet worked properly with blank lines.

IatricSB · 12-24-2002, 02:49 PM

BTW, in the latest version (not posted yet), the players whole name will appear if you output the Player HTML pages. Right now it only shows the first initial instead of the first name. I'll try to post an example later today.

mberner · 12-24-2002, 02:58 PM

Whoa - sorry, didn't realize it was such an involved task. If you've tried expanding it to thirty teams, though, and it works when using exactly 30 teams, is there any way you could post that file or e-mail it to me? That assumes of course that you still have a version of that saved. I imagine that would work for anyone running leagues from 1998 on, of which I assume there are quite a few, and it sounds like you've already done the work. Again, I can't stress enough how impressed I am - I've been looking for something like this since I first heard about the concept of Win Shares!

IatricSB · 12-24-2002, 03:02 PM

Quote:

Originally posted by mberner
Whoa - sorry, didn't realize it was such an involved task. If you've tried expanding it to thirty teams, though, and it works when using exactly 30 teams, is there any way you could post that file or e-mail it to me? That assumes of course that you still have a version of that saved. I imagine that would work for anyone running leagues from 1998 on, of which I assume there are quite a few, and it sounds like you've already done the work. Again, I can't stress enough how impressed I am - I've been looking for something like this since I first heard about the concept of Win Shares!

I have a spreadsheet with all the formulas for 30 teams, but that was before I built the macro to import the data so you'd have to input the stats by hand.

Henry · 12-24-2002, 03:56 PM

Actually, all I did was remove the references to teams 9-16 in the macro - not the spreadsheet

IatricSB · 12-24-2002, 04:00 PM

Quote:

Originally posted by Henry
Actually, all I did was remove the references to teams 9-16 in the macro - not the spreadsheet

Yes, I realize that, but my surprise is that the formulas on the 1st sheet would work with eight blank lines for the team totals (for 9 through 16). The first time I tried it, I got a bunch of division by zero errors. Stopping the teams from importing is easy, but my concern was the effect it would have on those team formulas.

Henry · 12-24-2002, 04:08 PM

If you want, I'll upload the spreadsheet to my website so you can take a look at it,

Henry

IatricSB · 12-24-2002, 04:10 PM

Shouldn't be hard to reproduce if all you did was comment out or remove the calls to the subroutines. I figure when things quiet down tonight (I'm currently working), I would give it a try myself.

woburn · 12-24-2002, 05:02 PM

Hi all, Chad here, haven't checked this thread as I'm out of town for the holidays.
My initial idea on the smaller league topic, if you had fewer teams than the max (currently 16), was that you could just delete the total lines for teams 9-16 and it should work. However, I didn't try it with the most recent versions.

Edit - delete after importing...

John C · 12-24-2002, 09:58 PM

Oy...

Why do the fine utilities everyone makes never work for me?

Stacy, I'm getting a run-time error "76". I have no idea why this is.

I'm running Windows XP Home with Office 2000.

Peace
John

IatricSB · 12-24-2002, 10:00 PM

Quote:

Originally posted by John C
Oy...

Why do the fine utilities everyone makes never work for me?

Stacy, I'm getting a run-time error "76". I have no idea why this is.

I'm running Windows XP Home with Office 2000.

Peace
John

Where are your HTML files being exported to? Which files are being exported? How many teams in your league?

Treches · 12-24-2002, 10:53 PM

Quote:

Originally posted by John C
Oy...

Why do the fine utilities everyone makes never work for me?

Stacy, I'm getting a run-time error "76". I have no idea why this is.

I'm running Windows XP Home with Office 2000.

Peace
John

Not much of a problem, really. The excel file looks for the path "LeagueSite". If you have your html files into a folder with a different name, the error 76 will show up. Change your folder name to LeagueSite and it would run properly.

mberner · 12-25-2002, 12:14 AM

Two more quick things: one - just making sure you know DH'S cause problems - if they haven't played a single defensive inning their stats/win shares get messed up, and their name is blank in the BWS list. And two, tried expanding myself to 30 teams and had no luck whatsoever - I don't know what I'm doing at all. Just keep up the great work and keep this thread updated with new developments, but that's definitely my top request (even moreso than the DH thing!)

IatricSB · 12-25-2002, 12:41 AM

That's what I get for never playing a league with DH's. Didn't even think to test it but it should be a quick fix.

darkhorse · 12-25-2002, 02:20 AM

Stacy,

When I save the file as a web page (HTML), it works beautifully and I am able to view it in all its glory. When I email this file to others in my league, they get a "Page Not Found" error when trying to view. Any idea where I am messing up?

IatricSB · 12-25-2002, 02:24 AM

Quote:

Originally posted by darkhorse
Stacy,

When I save the file as a web page (HTML), it works beautifully and I am able to view it in all its glory. When I email this file to others in my league, they get a "Page Not Found" error when trying to view. Any idea where I am messing up?

When you save it as a web page, it creates a subdirectory with a name very similar to the name of the HTML page. Inside the subdirectory is a whole bunch of HTML files. I believe one for every sheet in the XLS file. You need to send it to them also. If your file was named BoysOfSummer.htm, you should be able to find a subdirectory named BoysOfSummer_files.

Hope this helps.

darkhorse · 12-25-2002, 04:05 AM

Quote:

Originally posted by IatricSB
When you save it as a web page, it creates a subdirectory with a name very similar to the name of the HTML page. Inside the subdirectory is a whole bunch of HTML files. I believe one for every sheet in the XLS file. You need to send it to them also. If your file was named BoysOfSummer.htm, you should be able to find a subdirectory named BoysOfSummer_files.

Hope this helps.

That did the trick. Thank you.

Recte44 · 12-25-2002, 09:39 AM

Stacy,

You like it? My avatar was inspired by your new project.

John C · 12-25-2002, 04:59 PM

Stacy,

I got them to work. I'm very happy with them. However, I came across another stumbling block.

The files add up. I know that really can't change. The 2003 season, currently 1/4 of the way through, is 5.6MB. I don't think it'll get any bigger than this, because the only thing that changes is the numbers. However, for the historical portion of this project, it could really add up.

That said, I'd like to pick your brain. What idea did you have for guys like me, who want to use this for a huge amount of seasons? I'm curious.

And, how much size do you think it would take up?

Peace
John

12-24-2002, 02:48 PM	#22
IatricSB Hall Of Famer Join Date: Dec 2001 Location: California Posts: 3,493	Thanks for the info Henry, I'll give it a try. I'm surprised the 1st sheet worked properly with blank lines. __________________ Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body; but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming, "Wow! What a Ride!" Chicago(N) - Boys of Summer Oakland - 20th Century League Bakersfield - Wild Things Brooklyn - QBA Dodge City - NBSL California - ABC Dodger's Senioriest fan on the OOTP Boards

12-24-2002, 02:49 PM	#23
IatricSB Hall Of Famer Join Date: Dec 2001 Location: California Posts: 3,493	BTW, in the latest version (not posted yet), the players whole name will appear if you output the Player HTML pages. Right now it only shows the first initial instead of the first name. I'll try to post an example later today. __________________ Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body; but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming, "Wow! What a Ride!" Chicago(N) - Boys of Summer Oakland - 20th Century League Bakersfield - Wild Things Brooklyn - QBA Dodge City - NBSL California - ABC Dodger's Senioriest fan on the OOTP Boards

12-24-2002, 02:58 PM	#24
mberner Bat Boy Join Date: Dec 2002 Posts: 13	A post for thirty team leagues Whoa - sorry, didn't realize it was such an involved task. If you've tried expanding it to thirty teams, though, and it works when using exactly 30 teams, is there any way you could post that file or e-mail it to me? That assumes of course that you still have a version of that saved. I imagine that would work for anyone running leagues from 1998 on, of which I assume there are quite a few, and it sounds like you've already done the work. Again, I can't stress enough how impressed I am - I've been looking for something like this since I first heard about the concept of Win Shares!

12-24-2002, 04:10 PM	#29
IatricSB Hall Of Famer Join Date: Dec 2001 Location: California Posts: 3,493	Shouldn't be hard to reproduce if all you did was comment out or remove the calls to the subroutines. I figure when things quiet down tonight (I'm currently working), I would give it a try myself. __________________ Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body; but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming, "Wow! What a Ride!" Chicago(N) - Boys of Summer Oakland - 20th Century League Bakersfield - Wild Things Brooklyn - QBA Dodge City - NBSL California - ABC Dodger's Senioriest fan on the OOTP Boards

12-24-2002, 09:58 PM	#31
John C Hall Of Famer Join Date: Mar 2002 Location: Albion, RI Posts: 2,286 Infractions: 1/0 (0)	Oy... Why do the fine utilities everyone makes never work for me? Stacy, I'm getting a run-time error "76". I have no idea why this is. I'm running Windows XP Home with Office 2000. Peace John __________________ Facebook \| My Videos

12-24-2002, 02:44 PM	#21
Henry Hall of Fame Join Date: Dec 2001 Posts: 6,498	Stacy, I got it to work with my eight team league - just told the macro not to do teams 9-16. Maybe all you'll need (once it works for 32 teams) is to change one macro for smaller leagues. Henry

12-24-2002, 03:56 PM	#26
Henry Hall of Fame Join Date: Dec 2001 Posts: 6,498	Actually, all I did was remove the references to teams 9-16 in the macro - not the spreadsheet

12-24-2002, 04:08 PM	#28
Henry Hall of Fame Join Date: Dec 2001 Posts: 6,498	If you want, I'll upload the spreadsheet to my website so you can take a look at it, Henry

12-24-2002, 05:02 PM	#30
woburn Registered User Join Date: Jan 2002 Posts: 191	Hi all, Chad here, haven't checked this thread as I'm out of town for the holidays. My initial idea on the smaller league topic, if you had fewer teams than the max (currently 16), was that you could just delete the total lines for teams 9-16 and it should work. However, I didn't try it with the most recent versions. Edit - delete after importing...

12-25-2002, 12:14 AM	#34
mberner Bat Boy Join Date: Dec 2002 Posts: 13	Two more quick things: one - just making sure you know DH'S cause problems - if they haven't played a single defensive inning their stats/win shares get messed up, and their name is blank in the BWS list. And two, tried expanding myself to 30 teams and had no luck whatsoever - I don't know what I'm doing at all. Just keep up the great work and keep this thread updated with new developments, but that's definitely my top request (even moreso than the DH thing!)

12-25-2002, 12:41 AM	#35
IatricSB Hall Of Famer Join Date: Dec 2001 Location: California Posts: 3,493	That's what I get for never playing a league with DH's. Didn't even think to test it but it should be a quick fix. __________________ Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body; but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming, "Wow! What a Ride!" Chicago(N) - Boys of Summer Oakland - 20th Century League Bakersfield - Wild Things Brooklyn - QBA Dodge City - NBSL California - ABC Dodger's Senioriest fan on the OOTP Boards

12-25-2002, 02:20 AM	#36
darkhorse Hall Of Famer Join Date: May 2002 Location: fort worth, tx Posts: 10,850	Stacy, When I save the file as a web page (HTML), it works beautifully and I am able to view it in all its glory. When I email this file to others in my league, they get a "Page Not Found" error when trying to view. Any idea where I am messing up? __________________ "The Human Torch was denied a bank loan."

12-25-2002, 09:39 AM	#39
Recte44 Global Moderator Join Date: Dec 2001 Location: Oconomowoc, WI Posts: 2,818	Stacy, You like it? My avatar was inspired by your new project. __________________ Matt Rectenwald Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)

12-25-2002, 04:59 PM	#40
John C Hall Of Famer Join Date: Mar 2002 Location: Albion, RI Posts: 2,286 Infractions: 1/0 (0)	Stacy, I got them to work. I'm very happy with them. However, I came across another stumbling block. The files add up. I know that really can't change. The 2003 season, currently 1/4 of the way through, is 5.6MB. I don't think it'll get any bigger than this, because the only thing that changes is the numbers. However, for the historical portion of this project, it could really add up. That said, I'd like to pick your brain. What idea did you have for guys like me, who want to use this for a huge amount of seasons? I'm curious. And, how much size do you think it would take up? Peace John __________________ Facebook \| My Videos