Science & Industry

I don't know about most but I hate using web based calculators as I like to be able to modify the material prices and tweek things the way I want them. (Edit: and based on 100 downloads in it's first day it sounds like others do as well. I honestly expected maybe 5 people to use this :) )

I used to use a spreadsheet called the Capital Ship Cost Calculator from a guy named Aaron Nielson but it didn't have some of the newer ships and now that Crucible changed the quantites it was totally off.

So instead of whining about it, I thought I would learn Excel, clean up the sheet and re-do it for crucible from scratch

I have tested it in Excel 2010 and 2007. Anything outside of that and you are on your own. Here is a link to the file:

Capital Build Spreadsheet 1.0 - Dec 29

After spending 3 hrs testing every component against the levels in my in game hanger I am comfortable calling this a 1.0 release! That said please report any defects to this thread.

Planned updates: I need to finish adding fighter bombers to list

I hope you enjoy and yes I am a noob Exel user so don't fault the design. It works and unlike the original spreadsheet it uses the official formula from the Eve equation Wiki so it seems to be more accurate then the original as well.

FOR GOOGLE DOCS: For those who want to use this but don't have Excel, you can easily import it into Google docs with a couple of simple steps. (I have not found a way to save data validation look-ups between formats)

New Link by Invictra Atreides Link to google doc

1) import the .xls into Google docs
2) select the capital ship selection cell (A8)
3) click "Data" at top of page, Cell range should be "Main!A8"
4) click radio button beside "Create Items from List" and enter "Control!A10:A31" in the box to the right of it
5) click save
6) select item to build cell (A45)
7) click "Data" at top of page, Cell range should be "Main!A45"
8) click radio button beside "Create Items from List" and enter "Control!A40:A58" in the box to the right of it
9) click save

Then it should work

Check your formulas on the tab Control, cells C67&C68, not sure those have an impact on main but they are wrong
Watch about absolute reference $ in formulas and maybe can this make your life better.

protip -- ME 6 to ME 7 makes no difference on a Moros.
Cap parts are probably ideal around 20 ... but since it only took like 6 weeks to run them to 100 back when I did freighters (years ago), I just ran them to 100 -- took 3-4 months for the freighter anyway. My calcs show ME 0 is ~4.9m for Cap Const Parts, ME 10 is 4.5, me 20 is 4.48m, and ME 100 is 4.46m.

@Velicitia Thanks for the protip, just started researching them yesterday.
@Zifrian I use your product for invention, guess I need to check for other things also.

The Control tab is just lookup data for the tables. Basically it allows me to just modify the base requirements for a ship should CCP decide to tweek it again instead of having to hard code everything into formulas.

Regarding perfect skills: Yes I hardwired the spreadsheet for perfect skills since anyone without them should not even be looking at building capitals :)


Basically, unless you want to dive into the guts of the spreadsheet to figure out how it is working ( I just use a simple MATCH statement to find the reference point for the OFFSET that loads a set of cells with control data) then just pretend it doesn't exist and don't play with the values or you will bork all the results.

Tab 2 is mostly control data as well but I personally find it usefull on occasion to break out the min requirements for a couple of components if I am just missing a few.

So to use the sheet just update your component ME values on tab2 . update you min prices, select your ship or mod, plug in it's ME value and go shopping :)


Just be gentle, this was more of a personal project to get me to use functions of Excell I normally don't and I don't profess to be a spreadsheet god. But I have checked it's accuracy against my prints in game and it is bang on every time.

Yeah awesome app and I use it, but when it comes to doing production, I just like using a good old spreadsheet with static data.

Now if your app would allow me to select a ship, then punch out a static quote sheet with mins and components I could mark ( I shift cells to green as I deliver component batches) then that would be awesome :)

I will re-check the titan materials and make the necessary corrections. I did some cutting and pasting from my old spreadsheet and got tied up with the formulas, guess I overlooked reworking the titan base requirements.

Expect a release later today.


Edit - Looks like somehow an old control set got into the spreadsheet. I am updating now and rechecking every single ship against my ingame bpo's to ensure accuracy. I am blocking access to the dload until I post updated version in about an hour.

Thanks for catching this, I was paying so much attention to the formulas that I screwed up on the control sheet :(

Big kudos for this, seems to be the most up to date mineral calculator out there for capitals (a lot have failed to update with the changes to drone bay requirements of titans etc)

Nice ! I'll have to figure out how you did that :)

In the mean time I'll link a connection to it in the top posting .


Thanks