Conscious
Gallente
Haru Chai
   |
Posted - 2007.12.17 14:41:00 -
[1]
Hey All,
First off I need to give many thanks to Fubar (aka Aaron Nielsen) for his communications module and many points of advice throughout the process. I've been working at becoming more proficient using VB under Excel. So, I started developing a series of Excel based Eve tools. Well, after 8,000 lines of code it was getting a bit clunky to even load as a single sheet. I decided that I needed to split it up among several smaller stand-alone sheets opened through a launch pad user form.
As I find the time to split these different modules off from the main sheet, I will add them to the launchpad and make them available to anyone in the community that is interested in using them. I would appreciate any feedback about errors or desired features. Obviously, to use this you need to have a copy of Microsoft Excel. If any Open Office users get this working I would like to talk to you.
The first module I'm releasing is the Alliance Tracker. This presents much of the macro level alliance information and presents it in a visual format that is hopefully easy to view. Upcoming features on this may be an alliance history grapher that would maintain a history over time for indiviual alliances and allow the user to take a high level look at it. Please maintain the path structure in the zip file if you wish to use the launchpad, otherwise just have the mdb file at the same location as the excel sheet.
Eve files link to Launch Pad
http://dl.eve-files.com/media/corp/Conscious/LaunchPad.zip
Upcoming modules in order of release would be:
Corporation Management: Allows you to track, annotate, and update multiple corporations and their members through the CCP API.
Wallet Reports: Allows you to summarize and track, based on date, all of a players journal and transaction records downloadable through the CCP API.
Construction: Tracks construction costs, owned BPOs, and construction resources and their location. Also has a build sandbox to allow you to speculate on series of different builds.
Market: Helps track total sales and purchases based on date. Also allows you to enter and track sell and buy orders, profit margins, etc.
From Conscious (aka Dan Canham)
|