Updated Win Shares Utility for OOTP5 Available

[EvanW]

While Cato's History utility now includes Win Shares, it only does so as a leaderboard.

So, I went back and dug up IatricSB's and Chad Carter's Win Share Utility template for OOTP4, and modified it to be compatible with OOTP5.

In addition, I changed it from using the HTML pages for input to using the CSV files from CommishJoe's Exporter for v5.

It's now available for download.

Enjoy!

--
Evan
4CBA Bora Bora GM and Historian
CDL Oakland GM and Historian

[adventureran]

Wow! Sounds great! Downloading now...

[Hammer755]

Originally posted by EvanW
While Cato's History utility now includes Win Shares, it only does so as a leaderboard.

Evan,

Cato's Utility also provides individual Win Shares on the player pages, not just a leaderboard. However, I would assume that your utility is much better if you want a quick output of the stat.

Have you checked your results vs. the Cato Reference to see if they correspond?

Thanks for your work.

[EvanW]

Hammer,

You're right, it does provide individual win shares on the player pages.

I haven't checked this utility against Cato's, although I did check it against the OOTP4 version of the Win Shares utility and they matched up...except for a slight error in fielding stats for Outfielders Innings played.

I've just fixed that and replaced the file on the server.


edit: I just checked against Cato's utility...the numbers don't match up exactly. Cato has the optionof using park factors, which this utility does not, and the Cato pages I looked at were calculated with park factors. I'll look at adding those in.

Lord knows I don't mean to malign Cato's History. I think it's one of the greatest add ons for OOTP4 and 5. It's just as you said though, it's a matter of the quick calculation as opposed to waiting for the HTML pages to be created. Also, I like to use Win Shares in determining who gets the MVP award in my solo league, so I need to know the answer before I generate the HTML pages. Or I have to do them twice.

--
Evan

[woburn]

Hey, it's great someone is updating that spreadsheet to work with OOTP5

Just a note, it was designed to be used with the QBA. In this historical league, we use average stadiums, hence no park factors were needed.

[bauermj]

Does anyone else get a type mismatch error?

Sub sortMVP()

Dim uMVPcc As Double

uMVPcc = 2

With Worksheets("Overall")

.Activate

For j = 12 To 170 Step 4
  Team = j / 4 - 2
  For i = 3 To 62
    If Worksheets(j).Visible And Val(Worksheets(j).Cells(i, 6)) > 0 Then
      uMVPcc = uMVPcc + 1
      .Cells(uMVPcc, 1) = Worksheets(j).Cells(i, 1)
      .Cells(uMVPcc, 2) = Worksheets(j).Cells(i, 2)
      .Cells(uMVPcc, 3) = "Tm " & Team
      .Cells(uMVPcc, 4) = Worksheets(j).Cells(i, 3)
      .Cells(uMVPcc, 5) = Worksheets(j).Cells(i, 4)
      .Cells(uMVPcc, 6) = Worksheets(j).Cells(i, 5)
      .Cells(uMVPcc, 7) = Worksheets(j).Cells(i, 6)
    End If
  Next i
Next j

.Range("A3:G1000").Sort Key1:=Range("G3"), Order1:=xlDescending, Header:=xlNo

End With

it occurs for me at the IF worksheets(j)... section.

[EvanW]

Grumble......


I thought I squashed all of those.

There's a #REF or #DIV/0 somewhere, probably in one of the team fielding pages.

If you can, save the file, zip it up and send it to me. I'll take a look.

--
Evan

[EvanW]

I've come across some other discrepancies, so I've pulled the file until I can figure out where the problem is.

I'll repost it as soon as I get these nailed down.

--
Evan

[bauermj]

awesome, cant wait to see the finished thing.

[matskralc]

Can we get an update on this?

[EvanW]

In the midst of a rewrite. I hope to have it done by the first part of next week.

--
Evan

[matskralc]

Okay, cool, thanks. Looking forward to it!

[matskralc]

Not to bug ya, but how's progress on this? I'm just really looking forward to having something like this, is all.