Exploration data costs viewer v1.0

Anchous

Anchous
Hello)

I made a small file in Excel, which forms a summary table for the average price tags for exploration after downloading the database from EDDiscovery. Also, the macro (a small software module inside) displays a table with the maximum values for prices for certain space bodies.
zzzzz.jpg
zzzzz.jpg
What you need to work with the file (the macro in it):
1, Excel :)
2, EDDiscovery (for uploading data)
3, the upload file placed on the desktop called "export.csv" and ANSI
EDDiscovery install, run, open the game, waiting for upload data further, the filters EDDiscovery set only for sale exploration data, otherwise there will be everything from a jump-in and to dock at the station/refueling/repair again wait when upload data in this same program, click on the icon of the Excel. Table is exported in the format *csv, but the encoding is UTF-8. UTF-8 Excel does not understand (my macro too, because there is a self-written sorter by text and it is based on standard encoding) to defeat this, open the upload file in Notepad, save as, do not change the name and extension, set the ANSI encoding.

Link for download file

P.S: The document was created in Excel 2016. if you have an earlier version, the graphic object may not be displayed correctly (the macro launch button). It is also worth noting that the entire database is loaded into RAM and if you do not have a very modern PC, this RAM may not be enough.
P.P.S.: Since my knowledge of English does not allow me to write in it directly without an intermediary, Google translator was used)
 
Last edited:

Anchous

Anchous
v1.02 , what new:
  • changed the layout of tables and their location
  • improved (from my point of view) color coloring and grid
  • now when you click on any line in the list of records, we get a table on the right with the system where this object was found

PS: to trigger any event in the Excel book, you need to: go to the "file" menu/ parameters/ security settings/ macros/ run without notification + trust the VBA object model
 

Anchous

Anchous
Three and a half months away from civilization or traveling between the points of concentration of this civilization :) And three days to develop and implement the handler for data uploads from EDDiscovery. But now others have the opportunity to view their findings from space travel in more detail.

P.S: the existing database includes most types of astronomical bodies, so this file can be used without loading data from the side as a reference.
P. P. S.: There is an idea to the right of the main table to also output data by object type (list), output a list of systems with the maximum payment from cartographers, create separate sheets for uploading data on materials from the surface of planets, hot spots in the rings (if such data is present in the upload).
 

Anchous

Anchous
v1.1
A lot of things have been added, it's easier to see than to list.
------------------------------------------------------------------------------------
Excel in this case is just a development environment. Everything is done (with the right approach to programming) in a fraction of a second, the longest is the time to import data. In any case, we are unlikely to get anything from the developers in terms of visualizing the results of our activities outside the habitable zone. But how to analyze data for weeks and months of travel is up to everyone personally :)
-------------------------------------------------------------------------------------
And remember that everything in this file, from the weight to the content in addition to the table headers, is just for demonstration and debugging purposes. After uploading your data, everything will be different, except for the built-in functionality:)
-------------------------------------------------------------------------------------
Video on Youtube how to use it.
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom