PhaseDragon Posted September 1, 2004 Report Share Posted September 1, 2004 I am currently working on a whole-empire project which parses the PDF file into data fields and places the information into Excel spreadsheets. Also, there is an excellent Ship Builder and Production sheet. I am still working on it but it should be ready soon. I had some problems trying to convert the spreadsheets to work in older versions of Excel...specifically Excel 97. I had to resort to asking for help from Microsoft. That actually proved to be even more helpful than I had hoped and allowed me to rewrite large sections of code to make it run a little faster. The production sheet will read the Shipyard Report, Colony Report, Tooled Production, and Imperial Stockpiles from the PDF and place those values in the production sheet automatically. Also, when building a Nuclear Transwarp Drive, for example, all the other builds associated with this build will also be calculated automatically. It is even tied to the shipyard should you want to start your production from the Ship building level. In addition, there will be an option to optimize your production by adjusting your build amounts based on current stockpiles, mine production, and convoy routes. If your build amounts cannot be produced in one turn then the routine will indicate how many turns it will take to complete the build using the optimized builds (re-adding mine production and convoy route resources for each turn). Finally, there will be an option to save a copy of your work to a separate sheet which will allow you to change your mind about your production and then go back to your first thoughts without having to regenerate everything from scratch. This also allows you bring back production ques from old turns as a starting point if you would like. The research tracker will calculate research points based on the currently accepted square root formula and generate the items that are newly researchable provided that you have that information stored in your copy of the database. The copy shipped with the program will only contain items that are already discovered and are newly researchable by a starting empire. Other items can be either entered manually or read from the PDF file automatically from ANZ, RTD, and INST orders. The research points required to discover an item will also have to be filled in by individual empires. If you have more than one empire you can share one database between them eliminating the need to duplicate tech item entries. Also, scientist bonuses and exploration bonuses will be recorded automatically by reading the PDF. There is currently no accepted formula that I am aware of to calculate the bonus amounts for these events so they are left blank to be manually filled in. You will get a glimpse of their effect when you get a discovery earlier that expected (must be a scientist or exploration bonus). And the best part of all you can batch files together to run all at once (except for the production que as this is pop group specific), even mixing empires when generating exploration data. This will keep all your system scans and pmaps..etc all in one place. Each entry (if read from the PDF) will have an empire ID associated with it. The date of last scan is checked and if earlier than current scan it will be overwritten with the new data and tagged with the new empire ID and date. Future revisions will include the ability to export your build que directly into the Imperial Palace Orders database. Also working on Fleet Movements to export in the same way. I haven't decided on the best way to handle this yet. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.