DylanBradbury Posted May 18, 2009 Author Share Posted May 18, 2009 Hey folks! I updated my pitching calculator tonight... The newest version has the following updates/features: - Improved the velocity formulas - Fastball velocity will always be the highest - Added a sort function to sort pitches based on their default sort order in MVP (see above posts in this topic for details) - The window is always on-top - Updated the readme! Enjoy! Link to comment Share on other sites More sharing options...
DylanBradbury Posted August 31, 2009 Author Share Posted August 31, 2009 My pitching calculator now has the widely sought after Import/Export feature! Enjoy! Link to comment Share on other sites More sharing options...
jerm Posted August 31, 2009 Share Posted August 31, 2009 In the inputPitcher Generator, the only organization I can find is Toronto, and the rosters are out of date. How do I get other teams and updated rosters. I haven't even heard of most of these pitchers. Thanks in advance. Link to comment Share on other sites More sharing options...
DylanBradbury Posted August 31, 2009 Author Share Posted August 31, 2009 In the inputPitcher Generator, the only organization I can find is Toronto, and the rosters are out of date. How do I get other teams and updated rosters. I haven't even heard of most of these pitchers. Thanks in advance. You put in your own pitcher stats. I just chose the 2003 Toronto Blue Jays, the first team I saw play. It's explained in the readme and inside the generator, but basically you go to Baseball-Reference.com, find the team you want ratings for. Next: After that, highlight the pitcher's you want to ratings for... And then paste the stats, into the inputPitcher Generator on the corresponding page (MLB, AAA, AA, A) ... (Right click on "A2" > Paste Special... > Text > OK. (Do this as many times and for as many levels and organizations as you like/that can fit) If you know what a pitcher throws, write them under the P2, P3, P4, P5 headings. And change the pitchers' organizations to the pitchers' organizations. (As long as there's an alpha-character under that heading.) Go to the "User Interface" sheet, and click the "Create inputPitching.csv!" button. It'll create your inputPitching.csv! Go to the Pitching Rating Calculator and click "Import/Export" and your ratings will be created in outputPitching.csv, in the same folder as inputPitching.csv and the calculator. Hope that helps! Link to comment Share on other sites More sharing options...
andy82 Posted August 31, 2009 Share Posted August 31, 2009 Right, tried putting in the 1998 Anaheim Angels, put in the pitch types and everything, but I keep getting a "Compile Error in hidden module: module 4". Link to comment Share on other sites More sharing options...
DylanBradbury Posted August 31, 2009 Author Share Posted August 31, 2009 Right, tried putting in the 1998 Anaheim Angels, put in the pitch types and everything, but I keep getting a "Compile Error in hidden module: module 4". Andy, what version of Excel are you using? Link to comment Share on other sites More sharing options...
andy82 Posted August 31, 2009 Share Posted August 31, 2009 Andy, what version of Excel are you using? 2000 lol. Link to comment Share on other sites More sharing options...
DylanBradbury Posted August 31, 2009 Author Share Posted August 31, 2009 2000 lol. It seems you need 2003, or later. Sorry mate. Link to comment Share on other sites More sharing options...
andy82 Posted August 31, 2009 Share Posted August 31, 2009 It seems you need 2003, or later. Sorry mate. Bugger. Do you know of any freeware Excel-like programs that would be able to run the file? Link to comment Share on other sites More sharing options...
andy82 Posted August 31, 2009 Share Posted August 31, 2009 Downloaded OpenOffice and no result. Looks like this ain't gonna go for me :| Link to comment Share on other sites More sharing options...
DylanBradbury Posted August 31, 2009 Author Share Posted August 31, 2009 I just updated the program Andy. Try deleting your old version, and re-download. Also, make sure to enable macros. Link to comment Share on other sites More sharing options...
andy82 Posted August 31, 2009 Share Posted August 31, 2009 I just updated the program Andy. Try deleting your old version, and re-download. Also, make sure to enable macros. Had no progress with the old Excel. Tried using the new one you uploaded with OpenOffice, it responded, but with this error: A scripting framework error occured while running Basic script vnd.sun.star.script:Standard.Macro8?language=Basic&location=document. Message: The following basic script could not be found: Library: Standard Module: 'Macro8' Does not make a lot of sense to me. Link to comment Share on other sites More sharing options...
DylanBradbury Posted August 31, 2009 Author Share Posted August 31, 2009 Andy, you're enabling macros? Link to comment Share on other sites More sharing options...
andy82 Posted August 31, 2009 Share Posted August 31, 2009 Andy, you're enabling macros? Yep. I manually searched through all the macro's available and that one wasn't there. Not quite sure why it's needed because it's not related to the processes that you've inputted but obviously the program is being a bit female. Link to comment Share on other sites More sharing options...
DylanBradbury Posted August 31, 2009 Author Share Posted August 31, 2009 Macro8 is the whole point of the program, it compiles the statistics table in the order needed for the Pitching Calculator. I've checked the program on two different machines and Macro8 works (and shows up) both times. It's a similar macro to the one in the Fielding Input Generator, which I think worked for you. So I'm completely lost as to why it's not working. If you never figure out a solution, make a spreadsheet in Excel, with the following columns in the following order: Name,Org,Level,GP,GS,CG,IP,HR,BB,SO,ERA,P2,P3,P4,P5 and Save as type CSV (Comma delimited). (Use NA for no pitch.) Link to comment Share on other sites More sharing options...
andy82 Posted August 31, 2009 Share Posted August 31, 2009 Macro8 is the whole point of the program, it compiles the statistics table in the order needed for the Pitching Calculator. I've checked the program on two different machines and Macro8 works (and shows up) both times. It's a similar macro to the one in the Fielding Input Generator, which I think worked for you. So I'm completely lost as to why it's not working. If you never figure out a solution, make a spreadsheet in Excel, with the following columns in the following order: Name,Org,Level,GP,GS,CG,IP,HR,BB,SO,ERA,P2,P3,P4,P5 and Save as type CSV (Comma delimited). (Use NA for no pitch.) Yeah I guess that's what I need to do. Just seems so odd. Done it manually anyway, and it's bloody fantastic as usual :) Link to comment Share on other sites More sharing options...
DylanBradbury Posted August 31, 2009 Author Share Posted August 31, 2009 That sucks, man. Sorry it doesn't work for you, but I've done all I could man. Link to comment Share on other sites More sharing options...
andy82 Posted August 31, 2009 Share Posted August 31, 2009 That sucks, man. Sorry it doesn't work for you, but I've done all I could man. That's cool man, it's my fault for being a pikey lol. Link to comment Share on other sites More sharing options...
jerm Posted September 1, 2009 Share Posted September 1, 2009 Thanks for the help Dylan. The only problem I had is about half of the row heights changed when I pasted it but I assume that isn't a big deal. The only question I have is, can you still put in how many seasons that the data is from? For instance, if I want to put in data from this season, it would be a decimal. Link to comment Share on other sites More sharing options...
DylanBradbury Posted September 1, 2009 Author Share Posted September 1, 2009 Thanks for the help Dylan. The only problem I had is about half of the row heights changed when I pasted it but I assume that isn't a big deal. The only question I have is, can you still put in how many seasons that the data is from? For instance, if I want to put in data from this season, it would be a decimal. No problem jerm. Row heights shouldn't be changing (it didn't change for me), but I don't think it should matter too much. Just click the generate button and find out. As for the number of seasons the data is from... That is not needed, and as far as I can remember never needed for the pitching calculator. Hope that makes sense. Link to comment Share on other sites More sharing options...
jerm Posted September 1, 2009 Share Posted September 1, 2009 Ya, that's right I forgot that the pitching calculator didn't have a "Number of Seasons" field, it's in the Batting calculator. Thanks. Link to comment Share on other sites More sharing options...
DylanBradbury Posted September 1, 2009 Author Share Posted September 1, 2009 No problem, enjoy the new version of the calculator. Link to comment Share on other sites More sharing options...
DylanBradbury Posted October 27, 2009 Author Share Posted October 27, 2009 Version 9.0 was uploaded last night. It fixed a bug that dealt with the velocity for forkballs and knucklecurves. Enjoy! Link to comment Share on other sites More sharing options...
sebvanderm Posted December 23, 2009 Share Posted December 23, 2009 Hi, I have a question, I downloaded ur file but i have a MAC and it doesent let me open the file...any idea how i can make it work on a Macintosh??? Thanks in advance Sebastian Link to comment Share on other sites More sharing options...
DylanBradbury Posted December 23, 2009 Author Share Posted December 23, 2009 Hi, I have a question, I downloaded ur file but i have a MAC and it doesent let me open the file...any idea how i can make it work on a Macintosh??? Thanks in advance Sebastian It will never work on a Mac. You'll just have to buy a PC to use my calculators. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.