Addins: Fiscally Conservative Pack

[Abev]

I have reformatted and/or recoded my original addins. Get It Here
Overwrite the original addin in your 'PureSim Baseball 2007\mods\AddIns\VB6' directory

This is a replacement of my original addins. The original pack (AbevAddins.dll) had:

Best Young Player Value (Under 26)
Best Player Value (Any Age)
Best Young Pitcher Value (Under 26)
Best Pitcher Value
Front Office Accounting Report

I combined the "Best Value" addins (the first 4 in the above list) all into one addin. I stumbled onto a way to combine them all programicallyl; I never knew how to do it before. It was too much going back and forth so now you can have all data in one spot.

The only caveat so far is the load time is pretty long, relatively speaking. It takes about 70 seconds to load the addin on my avg comp. Once its loaded, sorting by column or changing from players to pitchers or vice versa is almost instant.

Best Player Value
Upon launching the addin, you are presented with two ugly dialog boxes (Shaun a custom filter dialog for the addins would be amazing [:D]).

The first dialog is the max age to consider for the data set. Its defaulted to 35, but for example, if you just wanted to take a look at young players you may enter that age here.

The second dialog is 'include major leaguers only?'. Yes means major leaguers only, No means get all players - majors, minors, free agents.

IMPORTANT Whatever selections you make here will define whats available to the addin. If you choose max age of 25 and major leaguers only, thats all you can get for that incarnation of the addin. If you want to change that criteria, you need to go back out to the main addin menu and restart the addin.

The columns are pretty self explanitory. Position, Age(team) Salary (x years/x $).

Then theres "ARat" which is the ability rating. I have been working on this and refining over the past couple days to somehow project what kind of future ability this player has. The formula takes into account the players ratings, age, potential, and historical stats. 10 is the highest ability and 1 is the lowest. This is partially why there can be a long load time.

The next col is $Rat. This takes that players salary and compare it to other pitchers or players in the assn and ranks them on a scale of 1-10. 10 is a great value (low salary) and 1 is a bad value (high). Free Agents automatically get a "0" for this field.

The remaining cols are Ratings and stats.

Front Office Accounting Report

This addin comes from the Front Office. These folks are not necessarily the most athletic; there are strictly number crunchers. What this addin does is it takes each of the players on your team, compares that players ratings with other players of similar age and ratings, and determines whether they are "overpaid", "underpaid", or "average". I added "Slightly Overpaid", "Slightly Underpaid", "Grossly Overpaid", and "Grossly Underpaid".

The order goes from "Grossly Underpaid" < "Underpaid" < "Slightly Underpaid" < "Average" < "Slightly Overpaid" < "Overpaid" < "Grossly Overpaid".

In my world, if you are in the the grossly overpaid column, pack your bags kid.

I like to use this as a 2nd opinion to control my payroll and keep it down so I can sign that big FA should he come along.

I havnt added any ratings or stats to this one. Not sure how necessary it is, but it can be done.

Best Player By Pos

This addin is nothing more than a way to get players with the best stats from a certain position.

You get asked 3 quesitons for this one.

"Which year" defaults to the current year. A side note though. If you run this addin before games are played for that current year there are no stats, so use the last year.

Which Position? Use 2 thru 9 (dont use 1 I dont think it will work) Where 2 is Catcher, 3 is 1b, etc (everyone know this dont they? I was thinking of adjusting this addin so once you load it you could have all the positions available by clicking it within the loaded addin. Maybe thats todays project.

"How Many At bats" Its sorted by stats, so If you are further along in the season use a larger number like 100 or so, just so you dont get clouded by a player with a few Ab's.

I am in desparate need of a good catcher so I have been using this one to find me one with more than 5 hrs a season. No luck so far - no one wants to trade with me.

[redsoxfan999]

Abev,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wow , great work, these are even better! keep 'em coming.

[pbot]

Thanks for sharing these addins.

[PadresFan104]

updated on my site

[Abev]

Padre I am giving you a real workout here. Thanks for putting em on your site. I cant leave well enough alone.

UPDATE

Recoded the Best Player By Pos addin. Now it loads with ALL position players, has sortable ratings and basic stats. So you dont have to reload the addin if you want ot check different positions.

As always, bugs may lurk; feel free to add comments/suggestions/ bug reports.

Download and overwrite Abevaddins.dll from HERE (same location as before, just restating just in case) and overwrite to your 'PureSim Baseball 2007\mods\AddIns\VB6' directory.

[Abev]

Funny thing about my "Best Value Player" addin. Believe me, I question the output sometimes too. Some of the players ranked with a 9 or 10 ability really dont look that good. Their stats are avg and sometimes their ratings dont jump at you.

So what the heck I say. What IF my code is correct and I got PS beat. Not so fast my friend. Whenever I try and trade for those "average" high ranking players, the current team of said player wants my BEST player, OR I dont have enough to give him. And this is usually for a minor leaguer with less than stellar stats.

[akcranker]

Hey Abev.. will any of these add-in's tell me who the best defensive fielder is at each position or would you have to create a new add-in for that?

I think it would be cool to see where my players rank in fielding ability and maybe be able to look for a younger fielder of similar ability to trade my aging fielder to.

thanks for all your work on these man

[PadresFan104]

LOL... updated

[Deltadog]

I have tried your updated version of these add-ins and, with exception of one minor issue, all seem to work well and are very good.

Using the Front Office Accounting Report, all worked well up to and through the presentation of the report. However, when I tried to go to another team from the first, I get an error message that reads, "Add-in error: Table 'TeamScratch' already exist." Click ok and the Puresim Baseball 2007, please wait message appears and just sits there apparently hanging. Click back to Add-Ins List and it says loading, please wait and then all resumes. At that point a new team can be selected and the report is again presented. If you try and go to another the error appears again.

Question, your add-ins appear to access databases that must be in the association files. How do you access these databased or know that they even exist?

Thanks for the good work.

[Abev]

ORIGINAL: Deltadog

Using the Front Office Accounting Report, all worked well up to and through the presentation of the report. However, when I tried to go to another team from the first, I get an error message that reads, "Add-in error: Table 'TeamScratch' already exist." Click ok and the Puresim Baseball 2007, please wait message appears and just sits there apparently hanging. Click back to Add-Ins List and it says loading, please wait and then all resumes. At that point a new team can be selected and the report is again presented. If you try and go to another the error appears again.

Question, your add-ins appear to access databases that must be in the association files. How do you access these databased or know that they even exist?

Thanks for the good work.

Yes Delta I was partially aware of that. I remember seeing that error once, making a mental note of it, then forgeting the mental note.

You cannot access more than one team with that addin without going back out and starting all over again. I wonder if I can fix it without redoing the whole thing? I will look into it. It can see how that would be pretty annoying. [:@]

All addins as far as I know dump into an access db. Thats how shaun has it set up. Basically in the addin code you specify which tables you want exported as your "work db" then you can perform calcs on the data. You cannot change anything thats in the game db itself. Its basicallyl just a dump into a temp table, a partial copy of whats in the main game db.

[SittingDuck]

Did you give up on my Ammy Draft preview Add-In suggestion?

[Abev]

ORIGINAL: SittingDuck

Did you give up on my Ammy Draft preview Add-In suggestion?

I never give up. I quit instead. [:'(]

Honestly I havnt looked at it sittingduck. I need to see when those names become available for use of the addin in realtion to the ammy draft. I will look at it. I got something else under my sleeve right now. [:D]

[akcranker]

ORIGINAL: akcranker

Hey Abev.. will any of these add-in's tell me who the best defensive fielder is at each position or would you have to create a new add-in for that?

I think it would be cool to see where my players rank in fielding ability and maybe be able to look for a younger fielder of similar ability to trade my aging fielder to.

thanks for all your work on these man

Hey Abev I didn't know if you seen this but I was curious what you thought about trying to make an add-in like this?

[Abev]

ORIGINAL: akcranker

ORIGINAL: akcranker

Hey Abev.. will any of these add-in's tell me who the best defensive fielder is at each position or would you have to create a new add-in for that?

I think it would be cool to see where my players rank in fielding ability and maybe be able to look for a younger fielder of similar ability to trade my aging fielder to.

thanks for all your work on these man

Hey Abev I didn't know if you seen this but I was curious what you thought about trying to make an add-in like this?

AK do you want strictly defense? Or some offense thrown in? Give me a more specific idea what you are looking for.

[akcranker]

For the Defensive Ability Add-in I'd mainly want to know who the best player was at each position.&nbsp; So maybe if you could select either "all assn" or "specific team" and then select which position it will generate a report that shows you the top players at the specific position.&nbsp; I don't know if you can come up with some formula like you did with the best value players add-in but if you were able to take in account Range, Hands & Arm and create a number like you did with the best value players that would be cool.

For the fields to show maybe it can look something like this:

2B Jorge Cantu (Tampa Bay)&nbsp;&nbsp;&nbsp;&nbsp; Age 19&nbsp;&nbsp; Range 65 Hands 70 Arm 95&nbsp; Combined Ability 100 Contact 70 Power 95

I don't know how many fields you can fit in there but something like that would be nice.&nbsp; If anything you can shorten it by taking out the defensive ratings and we can just click on the player to goto thier players card and look at their defensive ratings.&nbsp; Use your own discretion on how you think it should look.&nbsp; Yes offense would be something I would want in the add-in but only as a secondary item.

I'd like to see if anybody else is interested in an add-in like this and if they have any ideas on what to include in it.

[Abev]

"Best Player" does take into account Range, Arm, and Hands. But does not take into account Fielding %, while it does take into account BA, Hits, Hr, RBI.

I gotta think about this one a little more.

AK - Do you want to know the best Player at each pos with offense AND defense? I am still trying to gt my arms around what to do. Could you tell me a specific need that you have had? You want the bst all around player at each position?

Once I figure it out, I need to figure if I need to create a whole new addin or just add to this one. Not trying to be difficult, I just have a strange process.

[akcranker]

No I understand that I'm kinda confusing in what I'm asking for.

I'm mainly look for the best defensive player at each position.&nbsp; Offense is kinda important because I don't want a crappy hitter or a player that is young and good at defense but still needs to develop his offensive skills in the minors.&nbsp; I'm mainly looking to find a decent hitter with great defensive skills to shore up the holes in my defense.&nbsp; If I can find a great defensive player with great offensive skills then I've scored big.

So maybe you can find the best Defensive player at each position and then have a couple fields that show thier contact and power and I can just scroll through the players and find the one that best fits my needs.

I hope all of that helped some and didn't confuse you anymore.&nbsp; I'm kinda confused on how exactly I should explain what I want.

[SittingDuck]

How do you really define 'best defensive player'?&nbsp; To me, this is by far the hardest area to define by means of statistics.&nbsp; You can set a formula, but how effective is it really?&nbsp; Fielding will likely always be a very hard area to quantify.&nbsp; So it comes down to 'what do you value'?

[akcranker]

Abev I just got an error with the Financial Accounting Add-in.&nbsp; I'm using v1.28 Beta DEBUG BUILD and when I clicked on the add-in and went to the screen with the drop down box and so I picked my team and it gave me an error "Overflow"

[pbot]

I have the same error using build 1.29