Aurora 4x

C# Aurora => C# Utilities => Topic started by: GangaSauce on April 27, 2020, 09:21:05 PM

Title: Aurora Dashboard (Graph data over time tool)
Post by: GangaSauce on April 27, 2020, 09:21:05 PM
I've made a simple utility, AuroraDashboard, that periodically opens the AuroraDB. db database in read only mode, then (if time has progressed in the selected Game) reads out all the population's mineral amounts, and a few other variables and stores them in another database called DashboardDB. db. 

It then displays the information in a graph.  (See attached image!)

I'll be adding additional variables and objects to display, any requests? On the todo list is also different color schemes. 

Name: AuroraDashboard. exe
Size: 545280 bytes (532 KiB)
SHA256: 1CD44C2822590C3AE67EC44ABA482D30E9E38E9B65CBB208E71576005DB9911F

Name: AuroraDashboard v1. 7z
Size: 3603469 bytes (3519 KiB)
SHA256: E86B0D9BD987FC03D386416A91323026B9FEDB66D34A8F514E63EBC37E1009BA

This mod/utility has been approved by Steve. 

Please do not include this utility in any mod packs / mod suites.  I have not obfuscated the binary, aside from compiling it in release mode. 

Cheers,
Ganga
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: GangaSauce on April 27, 2020, 09:22:56 PM
Oh, please extract this into a different directory from Aurora, please do not unzip this directly into your Aurora directory. 
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: skoormit on April 28, 2020, 06:58:09 AM
Oh, please extract this into a different directory from Aurora, please do not unzip this directly into your Aurora directory.

You should edit your first post to include this line.

Also: thanks! This is an amazingly useful idea.
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: Graymane on May 07, 2020, 09:15:35 AM
Using 1. 9. 5 Aurora.   Everything opens up ok but nothing graphs when I select it.   Just an empty window.
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: Ehndras on May 07, 2020, 07:51:30 PM
Awaiting update <3 Can't wait to use this
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: GangaSauce on May 09, 2020, 07:12:57 AM
Quote from: Graymane link=topic=11123. msg131529#msg131529 date=1588860935
Using 1.  9.  5 Aurora.    Everything opens up ok but nothing graphs when I select it.    Just an empty window.
Thank you, working on update now. 
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: Mr.Nap on May 09, 2020, 08:06:29 AM
A tool that will quickly become essential!
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: GangaSauce on May 09, 2020, 11:06:30 PM
Quote from: Graymane link=topic=11123. msg131529#msg131529 date=1588860935
Using 1.  9.  5 Aurora.    Everything opens up ok but nothing graphs when I select it.    Just an empty window.

I just tested the original v1 against 1. 9. 5 and it works fine, you need to save the game, let time pass (say, 5 days) then save the game again all while the dashboard is running. 
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: Froggiest1982 on May 10, 2020, 12:30:24 AM
Quote from: Graymane link=topic=11123. msg131529#msg131529 date=1588860935
Using 1.  9.  5 Aurora.    Everything opens up ok but nothing graphs when I select it.    Just an empty window.

I just tested the original v1 against 1. 9. 5 and it works fine, you need to save the game, let time pass (say, 5 days) then save the game again all while the dashboard is running.

You should add a readme file in the installation. For examole when you launch the application it's not really clear you need to select the aurora database.

You could also add the information on the instsllation and how to make it works from your previous posts.

Just a suggestion.

Good work anyway, I love your tool so far.
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: GangaSauce on May 10, 2020, 01:42:49 AM
Quote from: froggiest1982 link=topic=11123. msg132192#msg132192 date=1589088624
Quote from: GangaSauce link=topic=11123. msg132191#msg132191 date=1589083590
Quote from: Graymane link=topic=11123.  msg131529#msg131529 date=1588860935
Using 1.   9.   5 Aurora.     Everything opens up ok but nothing graphs when I select it.     Just an empty window. 

I just tested the original v1 against 1.  9.  5 and it works fine, you need to save the game, let time pass (say, 5 days) then save the game again all while the dashboard is running. 

You should add a readme file in the installation.  For examole when you launch the application it's not really clear you need to select the aurora database.

You could also add the information on the instsllation and how to make it works from your previous posts.

Just a suggestion.

Good work anyway, I love your tool so far.

That is a good idea, I will include a readme in the next release.

Thank you! Any ideas on additional things to graph?
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: JyeGuru on May 17, 2020, 02:18:22 AM
Quote from: GangaSauce link=topic=11123. msg132195#msg132195 date=1589092969
Any ideas on additional things to graph?

The entire set of terraforming data would be really interesting to map, although there's a lot of values to track.
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: Graymane on May 18, 2020, 03:42:35 PM
There are so many graphs and pie charts I'd love to see it isn't even funny!
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: GangaSauce on May 20, 2020, 10:46:08 AM
Quote from: Graymane link=topic=11123. msg133800#msg133800 date=1589834555
There are so many graphs and pie charts I'd love to see it isn't even funny!
Please please list your ideas
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: GangaSauce on May 20, 2020, 10:46:33 AM
Quote from: JyeGuru link=topic=11123. msg133479#msg133479 date=1589699902
Quote from: GangaSauce link=topic=11123.  msg132195#msg132195 date=1589092969
Any ideas on additional things to graph?

The entire set of terraforming data would be really interesting to map, although there's a lot of values to track.
I'll add that
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: JyeGuru on May 21, 2020, 06:31:38 AM
Quote from: GangaSauce link=topic=11123. msg134128#msg134128 date=1589989593
Quote from: JyeGuru link=topic=11123.  msg133479#msg133479 date=1589699902
Quote from: GangaSauce link=topic=11123.   msg132195#msg132195 date=1589092969
Any ideas on additional things to graph?

The entire set of terraforming data would be really interesting to map, although there's a lot of values to track. 
I'll add that

Even if it's not fully integrated with the graphing (not sure how you'd filter so many things with tick boxes in the current UI!) but if you are able to pull the data into the database I can report on it in Excel which is good enough.  :)

Also, is this open source? I'd be happy to potentially contribute to things if it's in a language I can work with.  👍
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: Graymane on May 21, 2020, 02:37:33 PM
Quote from: Graymane link=topic=11123. msg133800#msg133800 date=1589834555
There are so many graphs and pie charts I'd love to see it isn't even funny!
Please please list your ideas

Maybe some of these are already visible in game, but with the state of the user interface as it is, who knows?  I'm still fairly new.  Here are a couple.

* How many and in what proportions minerals are distributed through my building activities.  How much of that is recoverable via scrapping?  X% of total duranium in facilities, Y% in mil ships, Z% stockpiled, etc.  Where is it all by system?
* How much sorium is being used per time period on average by mil ships, commercial ships, and possibly civ ships.
* Total minerals available in systems (bodies, asteroids, comets).  Sort of a sum of the mining tab across all colonies as well as potential colonies.
* Some way to look at my total mining rate (with/without civilian) versus total resources to guestimate how long I have, which ones will give out first, etc.
* Some way to measure how many resources I'm using in weapons and ships in an engagement.  Not sure that is even possible?
* More detailed empire mining tab.  How much is coming from surface mines, versus asteroid/comet mining versus civilian by mining?  As well as by system.
Title: Re: Aurora Dashboard (Graph data over time tool)
Post by: JyeGuru on May 23, 2020, 09:43:27 AM
Would it be possible to allow a "divisor" for certain numbers that should be, but currently aren't, directly comparable?

In the current version, this applies to fuel and MSP.    Both individual graphs show a nice increase over time, but together the scale of the graph makes MSP meaningless (examples attached).   Having the ability to graph some things in higher numbers (MSP in "each" and Fuel in "x100,000" for example) would make some of these composite graphs a lot more useful.  Edit: This also applies to a Sorium vs Fuel graph, which is useful to ensure your production is staying where it should be.

Further to this, is it possible to have the Always On Top flag an option somewhere, since I usually put these on a side monitor that isn't where I have Aurora, and wouldn't mind them being behind my other random stuff at times.