Hi all,
Firstly, many thanks to both Eventure and seeebek for your time and efforts on data analysis and OCR. This is some really cool stuff you guys have created together. I haven't been following all this from the beginning and I've only been playing the game for a few weeks, so apologies if I'm saying anything that's already been said. I did read Yokai's guide a couple weeks ago, though I can't help but feel that some of this information is dated (which is a great testament to your ongoing efforts and progress), and with the hundreds of forum pages to scour through on these posts, it's pretty hard to catch up to the latest. So I figure I'll just ask:
1) The process for adding stations to TCE is awfully manual compared to commodity scanning. Virtually all of the station info (except the presence of a Black Market or Rare Commodity) can be found in the local NAV map. When selecting the current station, "Arrival Point" can be read from the center of the screen, and is a perfect analogue for your "Distance to Star" field. The station type can be determined by performing image recognition on the station's icon in the center of the screen, once it's selected. It doesn't let you distinguish between the various types of Coriolis, Orbis or Outposts, but I also haven't found a real reason to distinguish these. All you need to worry about is if it's an Outpost or not since those are the only ones that don't have large landing pads. The rest of the fields can be populated by interpreting text on the left-hand side of the screen under the "Info" window. You could even capture more info from this screen to create more robust algorithms for managing illegal cargo along trade routes. And regarding the "Black Market" check box, you could leave that manual or even use an interface such as AutoHotKey (AHK) to send keystrokes to reach the "Contacts" page and then scan the buttons for the presence of a "Black Market" option. In fact, after teaching it your keybindings, AHK could allow you to automate virtually this entire process once you're landed at the station of interest. I know this because I've already written an AHK script that uses image recognition (instead of time delays) and some fancy logic to robustly enter the Galaxy map and setup a route to a system that it reads from a list stored in a text file. I used it to auto-select the next hop of a 71-system-long rare route I tested a couple weeks ago. Each time I would launch from a station after selling or buying, I'd just hit a key and it would automatically setup my next destination. It works 100% of the time now, regardless of how long my system takes to open the galaxy map, scroll to the new system or setup the route to the selected system. It even detects missed keystrokes and re-sends. I know those concepts could be combined with your tool to automate a lot of this data entry by sending keystrokes to the game. You could then even expand and go for the gold by collecting every bit of info about a station, including a list of outfitting components sold as well as ships sold.
2) In line with the above suggestions, it would be awesome to see the commodity price scanning become more automated. I looked at EliteOCR natively and I like that it shows a black/white of each image scanned immediately above the text entry box so you can quickly compare and make any changes. I know it sounds like a small deal since the prices should already be on your screen when using your GUI, but it really makes a big time difference to have the image right there immediately above the text box you're comparing it to. I could see it useful to make commodity price scanning a staged process where the same button that kicks off the process can be used to auto-initiate a scan on the next page (i.e. clicking the same button would scroll down a page and kickoff another OCR). Then in the end, you could just click a button, scan through the text and make any changes as needed, and then go back to the same button until the whole process is complete. It really wastes a lot of time to have to manually click over to the window and keep track of the last commodity and then line up a new list of commodities without cutting off any of the letters, which seems to wreak havoc on EliteOCR's routine. Overall, even a simple idea like allowing keystrokes to navigate the categories of the commodity pricing page would speed things up immensely. All you need are 3 keys to speed up the process: Scan (preferably auto-scrolling the commodities after each subsequent press), Highlight Next Field, View Next Category. Even better yet, you could skip the View Next Category button and the (Next) Scan button by kicking off an auto-scroll and new Scan once the last commodity was confirmed from the most recent OCR. That would be fantastic =)
3) On that note, it would be great to have more bindable keystrokes in general to open/hide the various features in TCE. The less mouse use, the better and the faster. Hotkeys = speed and accuracy. Right now, it's very easy to accidentally hit SAVE instead of HIDE on one of your windows.
4) You no longer need to advise people to change their whole system's UAC setting. All you have to do is create a simple batch file with the path of the TCE.xlsm file (and you can do the same for the TCE Setup.xlsm file) and store it alongside the TCE.xlsm file. Then create a shortcut to the .bat file and navigate to Properties > Shortcut (tab) > Advanced... (button) > Run as administrator (checkbox). Then just use the shortcut to run TCE and it'll leave a small command prompt on your screen which you can minimize while it's running. This way, people can maintain their pre-existing UAC settings while trusting your program to do what it needs to do.
5) Do you need to start TCE prior to ED every single time? I had a lot of difficulty getting it work at first and I realized that in the beginning, I needed to start TCE and let it load entirely before starting ED, but after seeing some crashes and having to restart TCE mid-game, I'm unsure if I need to keep up this habit.
6) What exactly is affected when I "Reset All Prices and Scan" in the commodity window? I'm unsure if this wipes all of my commodity data from the database or if it's just for this current station. If it's the latter, I'm unsure why this matters since the OCR writes over top of old data anyway. Can you explain when I might want to use it?
7) While I'm at it, how exactly are we supposed to use the Rare Commodity field in the Edit Station window? I made a mistake early on of adding Rares to my standard list of Commodities, but I quickly realized that I shouldn't have done that =)