averagetsbplayer Posted September 28, 2012 Author Share Posted September 28, 2012 (edited) 1. This is something I can add. 2. I generally don't export things that are just calculations, but it's something I can consider adding. 3. Correct, these represent the plays - http://tecmobowltools.com/Plays 4. It's an interesting idea. Can you post an example spreadsheet of how you would like the output to appear? - The challenge with that "draft" situation is that it isn't easy to handle this situations where players switch position slots or teams over different ROMs. - For the more straightforward situation (where guys don't change slots or teams), I'm envisioning an entry field similar to this one provided. Edited January 5, 2017 by averagetsbplayer Update URL Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted September 28, 2012 Author Share Posted September 28, 2012 Can you also upload the ROM and save state you used when it wasn't pulling the names? Quote Link to comment Share on other sites More sharing options...
macknbyner Posted September 28, 2012 Share Posted September 28, 2012 1. Cool. 2. I think I get it. You can total up the players' offensive stats to get the team offensive numbers. But this can't be done with defensive. 3. That's what I thought. But what purpose do they play in extracting stats? Was there a reason you had to extract them? Or was it just part of the team's info? 4. I'm not good with spreadsheets. I don't know much about them. But I think the way you have the season extraction set up would be fine. Basically, the program could search for the player's name (This would have to be the case, because players may not be on the same team as they were.) If the names are a match, then the stats from one are added to the other, all this is sent to a career sheet, which adds the values puts out the total of all season stats together. I like the way you had the thumbnail there. It looks, by viewing the layout, that it can do exactly what I was thinking. I'm not concerned with the draft thing. Or the changing teams with players. I don't mind doing stuff like that myself. As long as there is an efficient way to get the seasons stat results. The General Manager is an awesome little tool for moving things around. Here's the state and rom. http://www.mediafire.com/?8sgz3s500tw522b Here's something I've been trying to piece together: Basically, what I want it to do is take CSV values output from the TSB Stat Extractor (I can't remember who made it) and compare the values to specific values on the right. For instance, the QBS pass attempts. If the number is greater than the number in the previous record file, the value on the right is overwritten with the new record. I want it to be able to out put, name of player, abbreviated team name, and amount of record for each category. I haven't finished the process yet, but I'll keep working on it. These are the kind of things I see with your extractors as a base. Anyway, thanks! Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted October 9, 2012 Author Share Posted October 9, 2012 On the single game stat extraction, there are now columns for first name and last name. Quote Link to comment Share on other sites More sharing options...
macknbyner Posted October 9, 2012 Share Posted October 9, 2012 Yes! That's awesome, AverageTSBplayer!!! Thanks. It keeps getting better. Quote Link to comment Share on other sites More sharing options...
macknbyner Posted October 14, 2012 Share Posted October 14, 2012 (edited) Hey averagetsbplayer. I just tried the extractor for single game. I extracted the same game twice.In the first extraction, I didn't uncheck the box beside 'use original 28 team rom'.The extraction did leave a place for the names, but their slots were all empty.So, I tried it a second time, unchecked the box and chose my rom.This time, there were names present, however, they were not the correct names. In fact, no matter which game state I use, I get the same players names in each slot.Maybe I just misunderstood. You DID say there were new columns. You didn't say anything about them being working columns as of yet. Is there plans on making the names appear. Or are they left for us to fill in? Just wondering.I totally revamped the game records program I was creating to use these files in order to get the players names from the files. And I'm close to finishing up on it. But the names thing is important to the final product.**A note on the program I'm creating using your extracted stats**I've got it set up to take the CSV form of your spreadsheets (you can upload 16 games altogether, that way you can find game records by the week). When you've uploaded the save state extractions you want, you then hit the 'find records' button and the stats will be output into an INI file Edited October 14, 2012 by macknbyner Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted October 15, 2012 Author Share Posted October 15, 2012 (edited) I found a bug. It should be fixed now. So, you should be able to see the correct first and last names. Note: Extracting save states and pulling out the first/last names for Nestopia 1.36 is not supported, though. Edited October 15, 2012 by averagetsbplayer Quote Link to comment Share on other sites More sharing options...
macknbyner Posted October 16, 2012 Share Posted October 16, 2012 Yep. It works. Nice! Quote Link to comment Share on other sites More sharing options...
TecmoTurd Posted October 16, 2012 Share Posted October 16, 2012 Just a quick bump to say I heart this project. You could then write a PHP library that hits your API and lets developers use it for their leagues...this should have been done years ago. Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted October 16, 2012 Author Share Posted October 16, 2012 Turd, that's probably next on my list. I'm not familiar with PHP's recommended techniques for hitting other websites, though. Are there specific functions/classes that are part of the PHP library that you would use for making that sort of API? Quote Link to comment Share on other sites More sharing options...
TecmoTurd Posted October 16, 2012 Share Posted October 16, 2012 Well, I think you'd basically just have a class that did a cURL request, got the results, and parsed them into objects or arrays. That way the user basically just fills in their API key and secret in a config file and lets the library do all the heavy lifting...it could even handle encoding the file into base64 by passing it a filename...Maybe I'll take a stab at writing something raw for you if I get a chance... Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted October 17, 2012 Author Share Posted October 17, 2012 (edited) I added an api_key parameter as a requirement to use the API. You can generate your API key on the MyProfile page of tecmobowltools.com (http://www.tecmobowltools.com/MyProfile). Edited January 5, 2017 by averagetsbplayer Update URL Quote Link to comment Share on other sites More sharing options...
tecmo_geek Posted January 16, 2013 Share Posted January 16, 2013 (edited) I'd love to be able to use the stat extractor on save files from Nestopia 1.3.7 on a Mac. Right now I'm getting back a .csv with data in it, but the numbers are incorrect. Edited January 16, 2013 by mositatupu91 Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted December 3, 2013 Author Share Posted December 3, 2013 (edited) On 9/18/2012 at 8:25 AM, TecmoTurd said: Might I request that you also return the data in json format as well? Turd, I finally got around to making my http://www.tecmobowltools.com/API/ParseSaveState page support a JSON response. The format matches the XML Schema - just turned into JSON.  I haven't yet documented my error responses, but I'll eventually get to it. Edited January 5, 2017 by averagetsbplayer Update URL Knobbe 1 Quote Link to comment Share on other sites More sharing options...
manYo Posted October 30, 2016 Share Posted October 30, 2016 (edited) Attached is an Excel document which you can paste the exported stats file from the Madison tool into the first tab, and the second tab populates some box score and stat stuff. Some stats like the score and first downs are not in the csv file from the extractor, so you gotta input those manually. Also, you'd need the tackle stat hack on your rom to get the tackles, which would then effect the stat for TACK INB %, which is basically just the percentage of plays where a tackle was recorded. Hopefully it works for anyone that would like this. My use is for a live tournament where there are recorded stats, print these out for each game and put them in a binder.  EDIT: fixed  Tecmo Box Score.xlsx Edited October 30, 2016 by manYo Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted November 15, 2016 Author Share Posted November 15, 2016 Manyo - let me know if you have ideas for how to change the extract. I can probably tweak it for you. Quote Link to comment Share on other sites More sharing options...
manYo Posted November 16, 2016 Share Posted November 16, 2016 On 11/15/2016 at 9:16 AM, averagetsbplayer said: Manyo - let me know if you have ideas for how to change the extract. I can probably tweak it for you. Â it's all good the way it is, thanks..... however, if you are able to add in QUARTER SCORES, FINAL SCORE and FIRST DOWNS, that would be much appreciated. Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted November 18, 2016 Author Share Posted November 18, 2016 @manyo360Â Check it out and see how it works. It's somewhat odd in the output, but there's now data for first downs, quarter-by-quarter scoring, and final scores. Overtime is obviously not handled super well. Let me know what you think. manYo 1 Quote Link to comment Share on other sites More sharing options...
bruddog Posted November 18, 2016 Share Posted November 18, 2016 As far as overtime...there is a hack that prevents the qtr scores from being overwritten in overtime.Pretty simple to then figure out the overtime scoring based on the final score. Â Â Quote Link to comment Share on other sites More sharing options...
averagetsbplayer Posted November 18, 2016 Author Share Posted November 18, 2016 @bruddog - Thanks for showing that to me! I updated the parser so that it handles that hack. @manyo360 - FYI manYo 1 Quote Link to comment Share on other sites More sharing options...
manYo Posted November 20, 2016 Share Posted November 20, 2016 cool, thanks guys, works great! Â attached here is the box score excel doc updated with these latest changes: Â Tecmo Box Score.xlsx Quote Link to comment Share on other sites More sharing options...
macknbyner Posted September 23, 2017 Share Posted September 23, 2017 I have been building a little program that can utilize the Stat Extractor and export player stats in career form.  Basically, it takes the CSV files, matches player names and compiles their stats in a text document for viewing. I can only program in Ruby. So I'm wondering, what are the chances that the stat extractor site goes down? Cause in that case, the program I'm making would be pointless. Secondly, can it be created as a standalone EXE, so that the program could still exist even if the site were to go down? Quote Link to comment Share on other sites More sharing options...
bruddog Posted September 23, 2017 Share Posted September 23, 2017 I bumped a thread with a standalone windows stat extractor for you @macknbyner Quote Link to comment Share on other sites More sharing options...
macknbyner Posted September 23, 2017 Share Posted September 23, 2017 Thank you!  Hope it stores the info in the same places. Will check it out. Quote Link to comment Share on other sites More sharing options...
macknbyner Posted September 29, 2017 Share Posted September 29, 2017 It appears that this one only dumps game stats from the blue screen. I need a full season stat extractor. Guess I'll just use the one online until such time as it expires. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.