Queue prediction tool: one astro

Read and comment on our tutorials and user guides here.

Moderator: Support Moderators

User avatar
moonfish
Junior Member
Junior Member
Posts: 33
Joined: Thu 17 Sep, 2009 12:42
Reputation: 0
Galaxy: Helion
Contact:

Queue prediction tool: one astro

Postby moonfish » Thu 24 Sep, 2009 20:39

I got tired of constantly having to count and recount my credits (and build times) to see whether or not I had enough to pay for my entire queue. So I set up a spreadsheet to do it for me.

RapidShare download link (old version, check later posts).

It needs to be tested for use with AI and Cybernetics, I've only been playing for a little more than a week so I have neither of those at my disposal for testing purposes.

A few things I'm planning to add at some point, but that don't seem all that important just yet:
  • Two fields need to be added: one for current time, one for current credits.
  • A more accurate way of determining the active jobs' remaining build times.
  • Right now, when a structure that gives +construction is in the queue, this is taken into consideration for all the following structures. Same thing has to be done for +research and +production (this requires the current time field and a more accurate way of determining the active jobs' remaining build times)
  • Multiple simultaneous Astros.

For anyone interested in the mechanics behind this: you have to unprotect the workbook and sheets first (Tools -> Protection). There's no password for these. There are three hidden sheets, and the 'planet data' and 'queue' sheets have hidden columns (respectively column D, and columns G through L).
Last edited by moonfish on Fri 25 Sep, 2009 13:59, edited 1 time in total.

Image
User avatar
Ikari
Retired Moderator
Retired Moderator
Posts: 4010
Joined: Tue 20 Nov, 2007 19:32
Reputation: 2
Guild: NERV
Location: Tokyo 3
Contact:

Re: Queue prediction tool: one astro

Postby Ikari » Fri 25 Sep, 2009 12:50

Moved to Tutorials and Guides :)


Return to “Tutorials & Guides”

Who is online

Users browsing this forum: No registered users and 3 guests