These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Capital And Sub Cap SpreadSheet
Author
Previous Topic Next Topic
Mike Ant
Worthless Carebears
The Initiative.
#1 - 2012-01-05 06:18:59 UTC
Hey guys,

I am the industrialist for my corporation. I have built several ships and equipment including capital ships. I have recently created what I think is a really good spreadsheet for determining costs and materials required for a project.

Explanation About Spreadsheet

It has several sheets

Capitals - This sheet is used for entering in the individual parts that you need for a certain capital. So for instance if a freighter requires 67 cap cargo bays, you modify the yellow part for cap cargo bay and the numbers will pull up.

RefSheet - This is the reference sheet that lists how much of what materials you have and is used right now by the capitals sheet

Capital Equipment - As the name suggests, this is the capital equipment page including but not limited to Drone Control Units, Local and Remote reps and such.

Battleships, Battlecruiser, Cruisers, SubCap Drones - Self explanatory.

This Spreadsheet does not take into account any material levels as I couldn't find the formula for determining the different requirements for each level. It is in a primitive form and I am slowly working on it so it will improve and I will post updates to the link at the bottom of the post. If any of you improve upon this document and can make it better, please feel free to post a link to a google docs or contact me in game and I can tell you how to send it to me and I will update the link. Also. It doesn't have everything under every category because right now, this is what I have built and needed in the spreadsheet. Soon to come is Rigs, More of the tech 1 drones, more of the capital equipment and the rest of the tech 1 sub-cap ships.

Any HELPFUL comments are much appreciated.

Link to the Spreadsheet

That is the link
RubyPorto
RubysRhymes
#2 - 2012-01-05 09:14:56 UTC
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=348689

Here's a link explaining exactly how ME and PE work and the formulae to determine what the mineral costs are at each level.

Good luck with your project.

"It's easy to speak for the silent majority. They rarely object to what you put into their mouths." -Abrazzar "the risk of having your day ruined by other people is the cornerstone with which EVE was built" -CCP Solomon
Invictra Atreides
Toward the Terra
#3 - 2012-01-05 09:35:51 UTC
Hehe a nice project ^_^

My eyes hurt after 5 min. I think the contrast of the colors is to strong.

Blog | Tutorials | Youtube "I don’t know everything, I just know what I know."
Mike Ant
Worthless Carebears
The Initiative.
#4 - 2012-01-05 13:17:29 UTC
Thanks ruby ill modify the spreadsheet and update it.

Ill also change the colors invictra to make it easier to look at.