Page 1 of 3

SPY's Tools

Posted: Fri Nov 13, 2009 10:28 am
by SPY
Hi all,

--------------------------------------------------------------------------------------------------------------
Fleet menu Simulator:

If you need a Rapid Fire at a glance or keep track of your Research Techs and there effects on your fleet, even may be you want to see the fleet info in one single view, rather than going through multiple pages, I bet you would like what I did.

I tried to make a simple Excel file which provides the above mentioned info in four worksheets. I extracted the info from the forum and the Zorg pages. So none of the info is mine other than the orientation and plotting. I tried to put on the latest calculation available for the data.

I would extend the tool to have more info in future.

Any discrepancies (Calculations or info), please notify ASAP.

This is a latest version of the tool. This one in addition to the previous options will provide the range of different ships and will tell whether a fleet operation accedes cargo cap.




--------------------------------------------------------------------------------------------------------------
Colony Cost and Worth Audit:

Find out how much is your planet rebuild would cost you or how much is an existing planet is worth in points. The following tool should get you all the info needed to measure that.


=============================================================

ps: lets add some keywords for search hits. Research, Armour, Shield, Weapon, fire power, deuterium consumption, fleet cost, rapid fire, distance, duration, attack point, speed, range, capacity calculation.

-Regards

Re: A Help Tool for newbies from a newbie

Posted: Fri Nov 13, 2009 8:48 pm
by Thatguyeric
I just downloaded this, it is a great program for newbies and experienced players alike. It even tells you how long attacks will take to reach its destination!

Re: A Help Tool for newbies from a newbie

Posted: Sat Nov 14, 2009 1:14 am
by Surrias
Looks pretty dandy to me.

Stickied ~Surrias

Re: A Help Tool for newbies from a newbie

Posted: Sat Nov 21, 2009 10:32 am
by prestonwatson
Hi yxz,
Thank for providing such a good information. I am sure for this you would have require a lot of time, patience and hard work. I appreciate it. Apart from this you also have two links. Your information will be helpful to many of the forum members including me. Let me tell you that I am a newbie. Thanks.

Re: A Help Tool for newbies from a newbie

Posted: Sat Nov 21, 2009 11:18 am
by IKICKAYOUWASSNOW
This must have taken a lot of work. The community as a whole must be thankful towards you. I could only wish someone took this time to do this when I was starting out...

Re: A Help Tool for newbies from a newbie

Posted: Sat Nov 21, 2009 11:45 am
by SPY
Thanks guyz, I really appreciate the returns of my hard work here. It was an one long night, but before that lots of forum research was the building block for this tool. I hope you do not stop here. Keep exploring cause there are a lot of useful info provided by other users that helped me.

Re: A Help Tool for newbies from a newbie

Posted: Sun Nov 22, 2009 2:26 pm
by makks
hey man, it is infact a great adn very well done for doing it, but i have been trying to change the researches and its asking for a password to unpotect the cells, what is it?

Re: A Help Tool for newbies from a newbie

Posted: Sun Nov 22, 2009 10:50 pm
by SPY
I actually blocked some of the fields to make it less complicated and secure the calculations that I added to the cells.
You can only change the fields in Research Levels (Research Level->Blue cells) and Upgrades (Fleet Statistics->Gray cells) and Number of Fleets (Fleet Cost->Light Blue) cells.

Re: A Help Tool for newbies from a newbie

Posted: Sun Jan 10, 2010 12:31 pm
by makks
Hey, recently got a mac, how do u open this file in a mac? it opens the xsls as a folder in the finder

Re: A Help Tool for newbies from a newbie

Posted: Sun Jan 10, 2010 4:52 pm
by SPY
Hey Makks,

I have uploaded a xls file for the benefit. That should be enough. For using xlsx files in Mac u have to have Mac office 10 I think. Also there are a number of converters available online, check them out.

-yXz