Are POS modules such as silos and towers inculded in the manufacturing sheets? I could not find them but i may just be blind. Superb tool anyways, thanks for sharing it.

Great tool Dedaf!! I have not experimented yet, but do the new API keys work?

Just wondering how the updates going with having the new keys put in? Other then that great spreadsheet been using it for ages now and barely had any problems with it.

Ow and the evelopedia article needs updating to this new thread.

Sinq Laison is not in the region list (home to Dodixie).

Hey!
Great Work with the new version! I really love this Sheet!

However, there's a small mistake:
On the T2 Items Sheet, Minerals in Stock, it says "Importet from T1 Production Sheet", but it is not!
On the same Sheet, the field "Industrial Character" should be a Dropdown I think.

Also, on the T3 Production Sheet it would be nice if the "Minerals In Stock" would be importet as well!

Keep up the great work!

Hey!
Great Work with the new version! I really love this Sheet!

However, there's a small mistake:
On the T2 Items Sheet, Minerals in Stock, it says "Importet from T1 Production Sheet", but it is not!
On the same Sheet, the field "Industrial Character" should be a Drop-down I think.

Also, on the T3 Production Sheet it would be nice if the "Minerals In Stock" would be importet as well!

Keep up the great work!

So i have Microsoft 2010 pro plus, and i am still unable to update my skills or input them.

Any ideas? is it anything to do with the new api system?

Did you use the NEW API-Keys? The ones you have to create manually first...

Hi M Kernel
Thank you for the idea's with the linking of minerals in stock to the t1 sheet. It a thing i have been thinking about doing. But it limits the user to having only one stock of minerals, so i cant decide if i want to do it. The note in the t2 item sheet saying that is importing from t1 is a leftover from when i build it i guess, cause its not meant to do it. So i removed the note.
you write about a problem with the drop-down menu for selecting characters in the t2 item sheet? i don't see the problem, i have the drop-down in my sheet.
Anyway, im glad you like the sheet and you are always welcome to submit idea's and bugs.
Dedaf

Hi
It seems that is some problem in T1 rig sheet, because when i change BP from original to a BPC with a number of runs and added BPC price is not taken in consideration and addes at final production cost of the rig.

Please check that.

Dedaf this is a great tool thanks you for your hard work on it.

Have you any plans to make this into a app for iPhones or androids?

A problem I've found is there are things missing, most notably you have the Capital Ship Maintenance Array, but not the Assembly array. Also the meta cap mods, and a few others. Will these be added at some point?

Dedaf

as always you are the best. i truly love your program.

Now to business. under the capital production tab there is a question i am hoping you can shine a light on.

Using Titan -> Erebus me 0 as example: you will notice that it requires 550 units of jump bridge arrays as one of its required components. You see it up top with everything else that is needed to create one but towards the bottom it does not show up in red like the others. is this a glitch? line 146 to be exact does not show the 550 units in red.

Let me know would ya

Thanks

Don Tiberon

not sure you spotted this. on the t2 item sheet. when you select ogre IIs it automaticly adds 2 partical accelerator units to the build list even though you have it set to 0 runs. did this on the 3rd t2 item build.

As the nice guy in this Thread explained to me, Starbase Structure BP's are not effected by ME.
This means, the Material Calculation on the "Planet" Sheet is obsolete (and quite missleading )

I also noticed that apparently some T2 parts were renamed. For Example the "Emp Pulse Generator" (Needed to build T2 Missiles) is now called EMP Generator.

Keep up the great work! <3

Another thing I noticed is the 'How To 1.7' link in your first post links to nothing. I've not played with the sheets too much yet but I noticed that almost right away. Any chance it could be re-uploaded?

Hey, wanted to let you know that your numbers for Nanoelectrical Microprocessor are incorrect. You have it needing Fernite Carbine when in fact it needs Tungsten Carbide.

Thanks for a great tool.

Cheers,
Sen

I don't see this problem. Could you specify in which of the productions sheets you have this problem? To me they are all using Tungsten Carbide.

T2 Ships. For example, when I choose Rapier and scroll down to the fifth component line, it shows Nanomechanical Microprocessor as requiring 16 Fernite Carbide.

Nanomechanical Microprocesso uses Fernite Carbide
Nanoelectrical Microprocessor uses Tungsten Carbide

To me they are correct or at least my sheets has same stats as the ingame. You sure you check the right prints?

With v14 I am getting an XML Parse Error when I try to add my characters into the data sheet. Runtime Error '-2147217376 (80041020)'

Tis odd as I am doing it the same way that previous sheets took it

Update:
Looks like it has something to do with the macro. Permissions are on, but its blocked/broke somehow. 12.8.1 works fine so will wait till next version is out (I hates troubleshooting Excel)

Awesome work, thanks for adding all the new stuff!! wrt the new fuel block sheet, it looks like faction and non-faction towers calculate as consuming the same amount of fuel.

I'm having the same issue as ICU Andshutup, however, i do not have any of the previous versions.

I'm running win 7 pro, with office 2007 pro.

Any assistance would be appreciated

Hi Dream Five
I dont believe there are any difference in the fuel use anymore, when it comes to standard and faction towers.

This is a text copy pasted from the dev. block

Towers will use 1 block/hour for small, 2 blocks/hour for medium and 4 blocks/hour for large. The CPU and Power load will no longer have any impact on your fuel needs - all towers now need the same amount of fuel, regardless of configuration.

The one downside of this big-blocks approach is that it's impossible to give faction towers a fuel consumption bonus any more (you can't consume 2/3 of a block). We talked to some large-scale starbase operators about this, and they told us that the main bonus of faction towers for them is actually that they last longer between fuel cycles. To try and compensate for the increased running costs, we've taken the above bay size increases and added +25% bay size on top of that for the "tier 1" faction towers, and +50% bay size for the "tier 2" ones. We're hoping people will find that a satisfactory tradeoff, but we're listening for further feedback on this change.


You can read the full block http://www.eveonline.com/devblog.asp?a=blog&nbid=3029

Hi Arganas Paendrag

Another player Commander IceQ had a similar error, this is how he solved it.

Go to Control Panel -> Programs and Features -> Select "Microsoft Office" (DO NOT DOUBLE CLICK) -> right click and select "Change"
Select "Add or Remove features" -> Scroll down to "Office Shared Features" -> set "Visual Basic for Applications" to "Not Available -> Click Continue.
Once Office is finished removing "Visual Basic for Applications", follow the same instructions, this time install "Visual Basic for Applications" again.
Macro's should be enabled and the xlsm file should load without any errors. :)

Good luck, let me know if it works.

if it would be possible i would love to see the implentation of a sheet for outpost construction.
if it is possible please give it a try as that would be one of the last things missing in the sheet. then it would be mostly complete covering most sections of the industrial side of EvE.

i started using this sheet from the very beginning i started playing eve the industrial way. and it is the one tool that helps me the most in doing the math in production work.
keep up the great work even if you cant implent the function described above.

regards,

crazyjoery

Dedaf can you PLEASE PLEASE PLEASE either make the columns wider, or un protect the sheet. Once you hit a bil of anything the numbers turn to #############. I do large quantities of stuff, ie 500 maels, that means 5 bil trit, but its a pain when the numbers break.

Hi there,

I would like to request something added to this already amazing tool. would it be possible in any given manufacturing tab ( capital building, etc,) to see the cost of the individual mineral types, IE : 12345 Megacyte costs : 12345 ISK ( with the price values indicated, buy / sell / average/own) so I can see what the most expensive part of my build is so I can see about finding a better source? this would go a long way to helping me. and I would love it if you included it in your spreadsheet.

Thanks much!

Edit:

could you also add in faction ships for manufacturing ? i don't see them in the T1 production, or are they listed under another tab?

With v14 I am getting an XML Parse Error when I try to add my characters into the data sheet. Runtime Error '-2147217376 (80041020)'

Tis odd as I am doing it the same way that previous sheets took it

Update:
Looks like it has something to do with the macro. Permissions are on, but its blocked/broke somehow. 12.8.1 works fine so will wait till next version is out (I hates troubleshooting Excel)

Hi everyone,

I recently updated to the latest version ( 14,3,4) and everytime I hit the "update everything" to get the new price averages for materials I get an error which reads as follows:

Run-Time Error "-2147217376 (80041020)':

XML Parse Error

I have no idea what this means or what I can do to fix it but if anyone has any ideas or suggestions I would be happy to hear them.

Top notch calculator, the effort is much appreciated!

One question though - I've probably missed something but when I've set my POS details in the POS_Production sheet it calculates how many fuel blocks I'm missing as per normal as well as how much stront I'll need.

When I go to the Ice tab though to see how much of each type I need to mine, it only shows the stront and not the isotopes needed for the fuel blocks.

Is this functionality in there and I'm just missing it, or have I somehow broken things? I've looked through the manual but the page is missing for the POS_Production sheet.

hey guys i wondered if anyone can help me, I've been at this for hours an nothing.
When I put my ID in, then my API, I hit update Skill data, an it gives me "Run time error "-2147217376(80041020)':

XML Parse Error

damned if I can figure it out, afraid I'm a better fisherman than I am a geek :)

Hi Melodee619
Its a common error in excel 2007/2010. You need to remove the macro feature and reinstall it.
Please read my FAQ nbr7 here to see how to fix it.

In the T2 Items sheet, it is not connecting Robotics correctly to the Data sheet field. Own price is 0.0 and the Buy and Avg prices are off too.

Hello everyone.
Have I understood it correct that minerals, blueprints and inventory items will not load automatically? I enter these manually?
Everything named something like "in stock" will not load from API?

Hi

Im sorry if this question was previously made.
Even whit this last version (16,6,5), in the POS Sheet, the Tool can get the towers but not the fuel that they still have.

Is this a bug from the API or from the tool?

I tried to load it but it said all the files had names too long or were not in the format work uses. Any suggestions on what to do to make it work?

I love the concept of your chart, but I keep getting an error, so I cant use it. if I try to check server, for example, I get an error with "Sheets("Data").Unprotect Password" highlighted. Any help would be appriciated

Clicked on the download of the application . . .
frame flipped to a porno site - then I got this . . . .
Might want to change your host there . . . .

Website blocked by Trend Micro Internet Security Pro

I think the problem you are doth seeing is because you are not using Microsoft Office 2007pro or 2010pro
Open office does not support XML import and MS office pre 2007 can not handle the calculations done in this tool.
So in short, you need Microsoft Office 2007pro or 2010pro.

You are correct. I was using LibreOffice. As soon as I switched to Excell, it worked like a charm. A little complicated, but I'm figuring it out. Your PDF could use a little work... And for the corp mining charts, does that take into consideration the changes CCP made with the mining barges?

Nice tool, but I found two missing items, the Target Spectrum Breaker, and the Reactive Armor Hardener. Part of E-war and Armor and Hull respectively. If they are in the tool, please tell me where, because I could not find them in T1 Items and T2 items. They're both inferno prototypes.

Nice tool, but I must comment...

Ever since you upgraded to where it requires 2010 or 2007 with compatibillity install I cannot hardly use it. I run on linux and have never even wanted to purchase 2007 and 2010 for my systems so the only time I can even look at these is when I'm at the campus library or so on. Why did you change from where 2003/openoffice/libreoffice could read it? Seems to be more of a detriment even for those on windows who cannot afford microsoft's overpriced crap software suite.

hi Dedaf,

amazing file, however i am not sure how to work with t2 rig production. I try changing runs for bpc, but values dont seem to change. Only get error if i change to 0, but 1 or 5, material consumption stays the same. Can you take a look into it?

Also i feel its a bit too automatic/restricted. Would it be possible to have a field to enter our "bought" price for materials and then calculate profit based on sold price? That would be amazing.

Hey mate, with the latest version I get an error when pulling all data, also when I use second char I can not select that char in drop down box;s etc.

Hi Kronarn

I checked it this morning and it seem the error comes from a change CCP has done to the SOV system feed. It seems that im no longer able to pull the system info, the way i have been doing till now.
A workaround for now untill i upload a new version, will be not to use the "update everything", but use the update bottons in each of the productions tools. Except for the update button in the POS production tool, as it is asking for system SOV, so you will get the same error her.

As soon as i have the time i will upload en corrected file.

Thanks you for reporting this.

great tool, almost life by it now days, ;)
Cheers, Dedaf

Nice tool thx.

The T1 rig "Processor Overclocking Unit" both Small and Large does not come up with any Materials needed, so it shows a "0" build price. The Medium one works.

It look nice, Just started using it. I hope it gets updated.
A Quick Question tho,
In the Planet section, In a Fuel Block section what does Material Level mean?

I tried to update from version 14,6,5 to 14,6,7, made a backup of the tabs data, T1 production, t2 ships and t2 items. The data import goes without issues but when I import the other tabs I get no data.
And yes, I do have full access to the backup location :)

o/ loved earlier versions did not realize till today you were still playing and updateing :) downloaded and tried to use i keep getting a Runtime error 13 type mismatch

<3 been using this for over a year...amazing work :) "cough" ccp should post your tool on the eve news or make a blog about it....just saying

Hi Cat Harkness
As fare as i know there are no Small or Large size rigs of this kind? that is why they dont give you any value.

Is there a way to use it with Google Docs ?

What's the chances of getting the source code?

thanks for the update keep up the good job...one question tho is it possible when you update the api info for your character and it shows the skill sheet to show what the skills are instead of type id ?

Hi Aphelion
The character skill tree API itself, doesn't contain the name, so directly it is not possible. But after thinking a little bit about your question, then i came up with the idea of adding a test character, that does not have API imported skills.
So in the DATA sheet, you can now change skills manually on this 3rd character and select that character in the tool you want to play with the skills. i think it works pretty well, so i hope you like it.

Just uploaded the new version 14,7,8

Enjoy

when i try to open it, it says excel found unreadable content?

yes excel 2007
also, there is no fleet stabber or fleet firetail in the t1 production tab, no fleet anything, we have pirate and navy, but no fleet.

Help Text

This message can appear for the following reasons:
Microsoft Office Excel is attempting to close with an invalid value in a cell.
An OLE operation has not completed (such as an ActiveX control or an embedded program or Object).
Excel is in print preview mode.
A Microsoft Visual Basic macro is running in step mode (a form of testing and debugging that takes place within the VBA editor).
Excel is trying to load a file.
A dialog box is open (usually behind the application, where you can't see it).
To avoid this message, allow Excel to complete pending tasks, close any open dialog boxes, close the Visual Basic Editor, and close any other programs that use objects embedded in the workbook before you close Excel.
If those steps don't work, press CTRL+ALT+DELETE and click Task Manager. In Windows Task Manager, click the Applications tab, select the open workbook, and then click End Task.

i know someone who had the same issue when they had the cracked version of excel was fine when they paid for the program

Hi Jass

I don't know much about MAC i prefer PC and windows, so i cant really help you much here. The VBA I use in Excel is specific for excel use, so that is most likely why it doesn't work on Mac. I believe it could be possible to make a VAB that would run under Mac, but since i don't have any Appel products then i have no way of testing it.
The problem with "The Name C Is Invalid" might relate to the PC drive C:\ maybe the drives are named differently on a Mac? its just a thought.



New version 14.8 has been uploaded

Is it possible to get a backup/restore for some of the other sheets? The Ore Mining sheet (for one) has a lot of info that has to be reentered with each update.

Thanks for this great tool, and keep up the good work.

Hi cat Harkness
I have created a backup/restore function for the mining sheet. You wont be able to restore anything from before version 14,8 since there were no backup function in those sheets. But with the next versions you will be able to backup and restore.

New version 14,8,3

on the section for making Custom Office Gantrys can you include the additional items required to convert it into a full customs office.

Could we also (might already be possible) get an export function of just the corp mining (ore and ice) pages. For my corp to get full transparancy to how we split up the takings, without them having access to the rest of my stuff.

Cheers for a well done spreadsheet though!

Could we also (might already be possible) get an export function of just the corp mining (ore and ice) pages. For my corp to get full transparancy to how we split up the takings, without them having access to the rest of my stuff.

Cheers for a well done spreadsheet though!

Hmmm, when i try to open it in MS word it says file is corrupt, am i doing something wrong? Do you have any install info/help for a spreadsheet noob?

I would have at least looked at it if it wasn't so RL commercial. I'd rather do my own.

I kind of figured that I would run in to some errors, but all in all I make do with what I can. Thank you again.

Hello DeDaf and thanks for for amazing tool.

Unfortunately I can't use it to its full extent because the API / Prices wont automatically update.

I am running Win7 64-bit with Office 2007 SP3 whenver I try to use the API Feature or Update Everything or even the "Check Server" button I get hit with the Run-time error '-2147217376 (80041020)': XML Parse Error.

Now Eve-search and Googled this thing to death and tried the solution in your FAQ page with no success. Tried disabling my firewall and AV to see if that made a difference, no luck. Any ideas as to what else I could try would be grand.

Do you know if the sheet will work with Office 365 from Microsoft? This is their cloud based collaboration system, and you get use of Office 2013 on multiple devices. This may be a great option for me as I often travel and take a laptop. Means I wouldn't have to continually transfer files between the PC and laptop. (Mac users are able to use a version of Office 2010, so it may help Jass as well.)

Regards
Kesker

anyone else getting incorrect command line when trying to download?

doesnt show up as a zip file or anything when i try to open from the download i just get

Incorrect command line

Hi Dedaf,

Firstly, Thank you for making such a incredible tool. it has allowed me to maximize my manufacturing and be much more efficient.

I would like to request a future addition to the sheet if at all possible. Instead of having 5 ship slots for capital manufacturing, could you increase that to 11 + to bring up with the other ship and item manufacturing tabs ? Thank you in advance if you are able and willing to do this!

Hey Dedaf,

First off and most importantly, amazing spreadsheet. This thing has everything! Thank you for sharing the work that you've put into it.

My question is with the corp mining tab. Is there any way to determine or change the payouts that certain ships will get at the end of the op? As it seems to me now (or I've overlooked it) that the payouts are at a fixed payout percentage based on the ship that is being flown. I'd like to personalize this if possible.