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 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!

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

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.

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

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?

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 :)

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

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.

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

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 ?

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.

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.

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?

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.

I seem to be having an issue with mineral prices, the average prices seem to be a little glitched at the moment. Megacyte is appearing at 1.02isk per unit, buying and selling prices seem correct for the region though.

Hello Dedaf.
I am running Microsoft Excel 2007... and every time I choose "Update Everything" it locks up excel.
Any idea what could be causing this?

Hello Dedaf, your tool is by far the most user friendly, but could you please add more cells for more partecipants in Corp Mining Tab? Cause i can't use it anymore if you don't add more space for more ppl in a Mining Operation.

Dedaf,
sorry to be a pest, but do you have any plans for a Beta Version of the sheet featuring the upcoming changes to ore refine amounts
Main

Hi Dedaf,
one question: I always upgrade your spreadsheet by a Tab called "T2 Ship Invention Costs". It basically calculates the costs for datacores and decryptors, the propability of a succesful invention and the invested costs per bpc/bpc run. I did it to get a clue where invention with/without decryptors has its cutoff to be worthy or not.

However, I got no clue about macros or vba and all that stuff, but I desperately wish to have an "import prices button" (for decryptors and datacores depending on race and shiptype) and some other "wishes" for the ++berskilled

Whishlist

Do you have any idea? Or even better.. Can I send you my dedaf and you just put these tiny little buttons in it?

Hi Dedaf,
For some reason I get the Runtime Error '-2147217376 (80041020)'. After trying to get rid of if by doing what was on the FAQ on your website it still is appearing. I am running it on Microsoft excel 2010.

Hey Dedaf. Love this tool. Keep up the good work. I did find one issue with the pos production section. Might just be me but who knows. I've noticed that the profit calculation only includes the fuel use from the large tower section. It leaves out anything entered in the other two sections of the control tower calculator.

Nice spreadsheet, I am having a bit of trouble getting the skills input, I can get the API to recognize my character but when I update skills nothing shows at the bottom of the sheet.
Am I missing something?

Hi Dedaf! I love the spreadsheet, insanely comprehensive, quite intuitive and easy to upgrade. One thing I noted is that the Magnate frigate for T1 production is not showing the Extra Materials for construction and is calculating the build price significantly below what the other T1 amarr frigates are. Is there a way to modify that in your spreadsheet?

Hey!
I think I may have found a bug with the 'Capital Production' tab.
I've noticed that if I have a ship chosen under 'Slot 5' (even though it might not be queued for production or instock) and I select a ship to build in 'Slot 1', the 'Minerals Needed' show up as #VALUE!

Hi Dedaf,
I think there's a bug with the T2 items production mineral calculations or just specific to that item.
I just happened to test for T2 Gyrostabs and it says 8 units of morphite are need for ME -4.

Jitonomic says 6 units, Zofu says 6 units too, I can't check in game right now so I'm guessing it's probably a bug .
Could you check that out ?
Thanks for this fabulous tool ;)

Not sure if this has been caught by anyone else yet, but your Ferrogel pricing in the data sheet seems to be off showing an average price of 8.99 isk / ea. i would love to have the but.... methinks it isn't the case. The Sell and Buy looks accurate, though.

I am pulling pricing from Eve Central / Jita

Does not work, in the character selection screen is empty. Which key should be entered?

Still does not work, nothing works. The key does not accept, because of this all wrong!

jpg

I think there is a bug in the Ice mining tab.
I can't select the mining character.

Using office 2010

Hello Dedaf,

I just started using your program today and it seems like I'm getting the same problem Save Sex is having. I enter my API info and nothing shows up on the character name box.

I've tried many new API keys and still doesn't work.

Hi,

In version 15,4,9 the drop downs to select t2 rigs don't work for me. They do work on other sheets so probably just some problem with this one...

Hey Dedaf,

I think there is a rounding bug in the Capital_Production sheet:

Steps to reproduce:
- Set all the "To be build" to 0
- under "Construction Parts", set ML to 100 and "Build Additional" to 94.
- the line now displays "Tritanium: 349'733" (which is correct)
- however, on top of the sheet, "Production Need" says 32'874'895 Trit, but 94 * 349'733 = 32'874'902

I think you need to to round the mineral amount per component before multiplying by the number of runs.
I am using version 15,4,9.

Keep up the good work, really love your sheet!

I just checked: This is with Production Efficency Skill at 0.

Also, i just started a Production Batch ingame, it needed 32'874'902 Tritanium. (with Production Efficency Skill at 5 and BP ML at 100)

Thank you Daedaf,
it is very worthwhile to find a person so dedicated and developing his tool in such a long time.

Thanks again.

I donated a bit and will do again.

Hi Dedaf,

I think there's a bug with the T2 items production mineral calculations or just specific to that item.
I just happened to test for T2 Gyrostabs and it says 8 units of morphite are need for ME -4.

Jitonomic says 6 units, Zofu says 6 units too, I can't check in game right now so I'm guessing it's probably a bug .
Could you check that out ?

Thanks for this fabulous tool ;)

Really enjoy your great tool.

But would there be anyway you could add a "backup/restore all" instead of one for each sheet?

Thanks

Firstly.... Great tool! i use it daily, thank you.

Found an error it think with t2 Assault missiles. They are showing the old names (Javelin/Rage) and the material quantities don't match BPs.

Thanks for this great tool!
I have a question, when planning a t2 Ship, it seems, that the tool doesn't count the extra materials of the prophecy for the amarr commandships.

Hello, great work!

Please can you add the option to view isk/hour in mine ore and ice but without refine. Some days is better sell the ore or the ice without refine.

THX

Thanks for this great tool!
I have a question, when planning a t2 Ship, it seems, that the tool doesn't count the extra materials of the prophecy for the amarr commandships.

Hello, Dedaf
I found a small error on a sheet "T2_Items". When calculating the required materials are not added to the amount of mexallon needed for the production of the target object.

And one more thing on the same sheet. Why is the calculation of materials for T2 components is not taken into account their BPO ML?

Maybe I found another error - in all the T2 Gang Links incorrect set quantity of required Hypersynaptic Fibers and Nanotransistors .

Hey dedaf, love the tool, use it almost everyday

I'm heavily involved in T1 production that i can use this sheet for, and im currently setting up a T3 production chain now

the T3 tool is pretty useful in getting an overview of the overview of the production but there is a few more systems involved obviously like gas mining and the like

Its not super relevant and i know you like to keep the sheet simple - but i noticed a section added for gas and jumped out my chair in excitement.... only to find out it was booster production - pah nullsec gas is for noobs

my point is, there's more gas then that - wheres our WH love... I use another sheet i built myself in the meantime - but would be nice to compile

i also use a simple sheet with the reverse engineering formula to work out what i should be researching right now, generally you should have max skills anyway and it only helps me as im in the middle of training... but could be an applet to add to the t3 production sheet?
https://docs.google.com/spreadsheet/ccc?key=0AjIXh1vOiIQddFFpT2NOckZXRnNEVXZsSEhUa3JPUXc#gid=0

Mercoxit's ISK/Hour isn't updating. Just stays at zero. FYI

When I change the material level of Large POS from zero to any number the cost to produce goes down but the materials required does not change. Manual review of the BPO's in game indeed show that the Material efficiency does nothing for these structures. I think this is a bug.

Thanks, Still a great tool.

Is there a trick to making Torpedo Launcher II's, I dont see this in the list of possible T2 items to manufacture?

Lori

Hey Dedaf

Love your tool, been using it for months. Just downloaded your latest version, I was using 15.1.6 before, and now I'm getting an issue where some of the columns aren't wide enough and result in ###### cells.

I know it's an easy enough fix I just obviously can't do anything with the sheet being protected.

Cells that are an issue in particular are the ISK total on materials in stock on T1_Rig_production and Price/30 days on POS production.

On Office on a mac if it makes a difference.

WIth latest version Im getting Run-time error '-2147217376 (80041020)':
XML PARSE ERROR

any idea why

Hey Dedaf,
I'm trying to use your tool, but when I try to update anything, it says:
"Run-time error '438': Object doesn't support this property or method"

I cannot check the server or do anything that requires checking from some other source.
I manually checked the prices too, and they seem to be wrong, so I'm sure it didn't update it.

I'm using version 15.8.5 (currently the latest)
My computer is Mac OS X version 10.7.5, and I'm using microsoft excel that I've bought from a mac store. I believe it's Excel 2011.
What should I do to make it work?
(I'm enabling macros when I use the program too)
Thanks.

That fixed it! Thanks Dedaf.

One other thing.

On the Planet tab, when I choose category and type for Item Slot 4, the additional item needed name shows as "0" and the mineral values under additional items show as #N/A, which then causes a number of other cells to show as #N/A including the minerals needed at the top of the sheet.

How do I remove API? I put in the wrong API into the corporation API slot, and then it went white and now I can't seem to select that cell to delete it.

Hi Dedaf

May have found one other bug on the planet sheet.

I have SBU's on item slot 1 and it appears that it is not adding recursive computing modules into the price and it is not adding them to the amount needed.

Also would it be possible to add a Invested/Market Value/Profit calculation to the Planet sheet, like the one that is on the T1 Rig sheet? Perhaps base it off whether or not build or own is selected under price for P3's/P4's.

Also can you think of an easy way to import data from an old workbook when you do an update?

I'm on a mac so sadly, I enter everything manually.

Shopping list sounds very handy!

Been using the tool for a long time and love it. But in the new version I cannot find how to input my "in stock" numbers, particularly on the T2_Items sheet. All the boxes are grayed out. Where can I enter my materials in stock?

Thanks!

Just want to double check that the newest link for the tool is in the first post. I downloaded it but it doesn't seem to be working correctly. May be user error so I will continue to go through manual. Looks awesome though.

Hi Dedaf

May have found one other bug on the planet sheet.

I have SBU's on item slot 1 and it appears that it is not adding recursive computing modules into the price and it is not adding them to the amount needed.

For those experiencing error 1004 and using Excel 2013 do not use the restore function.

When changing over to a new version, manually copy and paste ur api data. The same goes for ur various production sheets. Something in the restore borks VB scripts in 2013 and does not allow you update beyond the initial first time and comes back with an error 1004: password error

Hey, Awesome Tool.
Is it possible to run a query to list all the T1 BPO's I own and compare with Eve so I can see what BPO's I am missing?

I would assume this would use API to get my assets.

Would it also be possible to automatically enter the ME/PE levels of the BPO's I own in manufacturing sections?

Any Idea how I could just export a list of BPO's from eve to compare with what I own?

Just need to easily see what ones I am missing from my collection.

Regards
Azz

So I like the concept of the shopping list, this something I painfully always add to new version of the spreadsheet, is there a way that you can add additional sheets that can get counted in this function. For example, for T2 Items, i have 7 pages (3 items per page) in my copy of the spreadsheet. When I tested duplicating the default page, it did not get reflected in the shopping list. Is there a more appropriate way of adding pages?

Scorpio

This looks like an excellent tool, however, having some trouble setting up the API and was wondering if I could get some help (note - excel n00b). I go to the API page on the CCP site and generate new API. Following the FAQ on the OP's webpage, it says exclude CharacterInfo, CharacterSheet, Locations & AssetList and I do so. Press generate for API. I then start the tool, go to the data page, input the Apikey, KeyID, from the API I just made, and then manually type in my character name (Mandj, just like it says here). Press update skills, result: Popup window comes up saying Microsoft visual basic, says Run-time error '13': Type mismatch.

So I think I'm doing something wrong but can't tell what it is, could someone help me out please? It seems to pull market data correctly so idk what I'm doing.

Hey Dedaf,

Thanks for this amazing tool. I might be think though but I can't find an option to do the following.

I want to invent and build a t2 ship. I build all of the t2 components for the ship. However, when I enter the ME for the component BPOs and go to my shopping cart it lists both the actual components and the moon materials that are used to produce said components. Any way I can change that so it just lists the moon materials?


Edit: Also, can you choose what materials you manufacture (as in buy or build)?

Cheers!

Hi Dedaf,

Thank you so much for developing this tool! I'm a first time user, and I'm having trouble with the API/character import. I followed the instructions in the PDF and the FAQ, but it still won't recognize my character. I have tried manually entering the character name and updating, and I have also tried just using the API and KeyID, but the drop-down box is blank.

I'm using Excel for Mac 2010 Pro on a Macbook Air. I don't think that has anything to do with it... but the only thing I have tried to do is set up the Data page. I have not modified the backup or restore locations.

Any help you can offer is appreciated, thanks!

Thanks for the reply mate. I look forward to further developments!

Can you choose what materials you manufacture and what materials you buy when constructing t2 items/ships? For example if I build fusion reactors (so need raw mats and usually lower production costs) whilst buying R.A.M (more expensive but takes a while to make)?

First, thank you for making this awesome tool.
I'm having issues trying to use Dodixie and the system to update from. I get "Run-time error '13': Type mismatch" and the same when I try to use the Sinq Laison region. It works for Jita and Oursulaert just fine. Going through the list it gives the error for other systems too.
Any help will be appreciated.

Hey Dedaf I cannot seem to get the API lookup to work. I have run through the FAQ I am using the following:
Win 7 Pro X64
Office 2007 (fully updated )
Macro's enabled ActiveX allowed

I keep getting the following: Run time error '-2147217376(80041020)': XML Parse Error

I have tried the options listed in FAQ 7 but that did not work.

if I leave it blank I get : Run time error 13 type mismatch

I am not sure what else I can do...any thoughts?

Found a slight problem . to avoid confusion this is my forum alt.
Anyhow. been using the tool for ages now. awesome job mate.
How do I get round this?
I'm a ceo in corp. I want the corp assets in our office to be shown for my manufacturing. hangar 2 for example. It only shows our pos hangars.
Other thing If I try to manufacture from personal stocks. I click on character and look down the list of stations. The one where my actual stock is doesn't show, others do.
I'm having to use the old version at the moment as I cannot get any needed minerals and components on my listing.

I set up my API key as shown for corp and personal.

cheers mate

Double post.
That did the trick mate. Works great. No more stocktaking. Can't thank you enough

please please please make this in to Open Office format..... it allows Macros so you can pull eve central data ...not sure why its not in this format yet?

i would convert it myself but my old laptop times out and cant handle it :/

He Dedaf,
Since the last 3 versions im having Visual basic runtime errors 1004 when i hit the Update button in any of the tabs.
Suggestions?
cheers mate keep\up the good work

I'm using office 2013 are there some compability issues with it?

This error 1004, is it the password error?
do not get this error myself, so i cant say what could be to blame, maybe you are using Office 2013?
Also could you try to open one of your old files (if you have them still) just to check if infact it does work in those version.

othere than this i can relly assist with anything. but contact me ingame, then we can try som more specific tests, to see what we can find.

Hi Dedaf!

My second request:

If at all possible, I would like to request that market and / or contract fees be taken into account during the profitability formulation.

Situation behind this request:

I am trying to stay as accurate on my finances as possible, trying to determine if a build is profitable enough or not, and while your tool does an amazing job of keeping the mineral and component prices in line, it ignores taxes / fees completely ( as far as I can tell, PLEASE correct me if im wrong) I would love to have an input section where I can say " My broker fees are 0.50%, my contract fee is 0.85% and my deposit is 10,000,000 ISK) and it would calculate all that into the overall profitability of the ship. this way I can keep a more accurate tracking of my finances with one tool instead of manually writing it down.

First. LOVE the tool.

I may have found a bug. The Bastion module may have inaccurate data for the compression tool? I think that is what it was for a few days after Rubicon but was modified because it was just too good at compression.

Also most of the sheet is self explanatory but there are 3 columns fields that I am not sure I understand. See this image https://dl.dropboxusercontent.com/u/167491/capitalsheet.PNG

The fields I have marked. Are those figures isk values for the mineral volumes above?

Hi Dedaf,

This is an absolutely fantastic tool and thank you for all your efforts and making it accessible. It's making to everyone.

A few requests on wish lists because I'm cheeky.....

First i just want to make it clear that this sheet does not work in openOffice, as i see some of your questions sounds like you are unable to use the keys.

1) Would it be possible to also include the 5% and 10% ore variants as well?
A. Im guessing you are talking about the Mining sheet? use the dropdown menu, there you will find all the ingame ore.

2) Would it possible for it to take what you have from your assets list of your API key rather than having to manually enter them?
B. Again I'm guessing you are talking about the Mining sheet? I guess it could be done, but i would need to change the tool completely and i like to keep the tool nice and simple. Another problem is that the API does not update so fast, sometime up to 6 hours. So you woulnt get a very good mining result.

3) I couldn't find Drone Damage Amplifier I in the blue print list for T1 Production? Sometimes the categories make it easy to find blue prints other times you're hunting around trying to find them would be be possible to be able to type them in as well as pick them from the look up lists?
C. The Drone Damage Amplifier seems to be missing or have been renamed. I will make sure you can finde it under Drones - > Drone Upgrades. In the next version.
Its a good idea to allow you to type the name yourself, I will make sure you can do that in the next version. Thanks


4) For the productions sales costs is it possible to take into account sales tax and brokers fees? Or if not put a little statement at the top of pages where they are not taken into account. Especially if you're adding them for Capital etc?
D. This is already an option for Capital and Jump freighters from Version16.2

5) Is it possible to have a blueprint tab for those industrialist who are trying to make money from reaching and copying blue prints to sell. So you can keep track of the cost of the BPO, the costs of copying, and the research costs against the cost of selling the BPC's. If not can you increase the number of blueprints you can keep in the lists for the production tabs? As if you have more than say 20 T1 productions BPO's it is pain to keep track of them separately etc.
E. I do not have this kind of tool yet, but i will think about it, and who knows maybe i will add it sometime in the future. Thanks


6) Is it possible to fill in mineral amounts and planetary goods etc held form the assets list of the API key?
F. Not sure which tool you are referring to?

7) Would it be possible to have a tab which lists all your assets from the assets list and gives you what the reprocessed minerals would be and what the current avg isk price for selling the assets or reprocessing? As to help with the decision about what to do with loot but if you operate in high sec mega is in limited supply so know what to reprocess for that mineral vs buying could be quite valuable.
G. not sure how useful this would be compared to the time i would have to spend building it :) but thanks for submitting your ideas.

8) Final question I've been using 16.1. I've down loaded the latest version: 16.2.1a how can I import my data from one to the other without having to manually re-enter it?
H. This is what makes me think you are not using Excel. As you have backup and restore keys in all the production tools. However it could be that you haven't selected the right drive to save the backup files, or to restore from? So please check in the Data sheet, that you have typed in the right directory, where your backup files are located.

I noticed the new Hybrid Polymer amounts have not been updated http://puu.sh/6DJtb.png

Hi Dedaf,
3) I couldn't find Drone Damage Amplifier I in the blue print list for T1 Production? Sometimes the categories make it easy to find blue prints other times you're hunting around trying to find them would be be possible to be able to type them in as well as pick them from the look up lists?

Thanks for taking the time to respond.
I've tried with both excel 2010 and excel 2013
Don't worry I'll cut and paste.

Recheck Hybrid Polymer Numbers Carbon-86 Epoxy Resin is off by a factor of 10. Others Unknown

http://puu.sh/6Jm8Q.png Neurotoxin Control is the proper skill not Nanite Control

Thank's for the awesome tool. I've been using it for years now mainly for T3 production. I just got latest version (16.2.6) and I can't figure out where to put my stock of T3 materials. I tried entering in the data sheet but it doesn't transfer the data to the T3 sheet. What am I missing? Thanks.

Hey Dedaf when did you changed quantity or formula on Hemorphite and Hedbergite cuz I have noticed in v.15 one glitch. Price per unit still isnt correct, here is proof http://prntscr.com/2pqupd

I'm not sure this will work with my hanger division in the wormhole POS. Am I wrong?

To be build and hauled:
800mm Repeating Artillery I *16.106
Infrared XL *15.831
Multifrequency XL *2.511

11 hauls out
18hauls back
(total hauls 56)

9,4Bill in excess minerals, after producing the Aron.
-18mill in loss of minerals, when refining the items.

To be build and hauled:
800mm Repeating Artillery I *16.106
Multifrequency XL *271
Nocx *625.108
Zyd. *607.732

11 hauls out
13 hauls back
(total hauls 46)

2,8Bill in excess minerals, after producing the Aron. (6,6Bill less than before)
-8,9mill in loss of minerals, when refining the items. (9,1M less than before)

To be build and hauled:
1400mm Howitzer Artillery I *9.661
Infrared XL *3.548
Nocx *315.114
Zyd. *468.973

13 hauls out
16 hauls back
(total hauls 56)

2,1Bill in excess minerals, after producing the Aron. (7,3Bill less than at first)
-7,5mill in loss of minerals, when refining the items. (10,5M less than at first)

To be build and hauled:
Bastion Module I*2829
Multifrequency XL *89
Inferno Citadel Torpedo *1131
Mex. *3.091.191
Nocx. *1.177.314
Zyd. *134.812

16 hauls out
11 hauls back
(total hauls 52)

230Mill in excess minerals, after producing the Aron. (9,1Bill less than at first)
-5,2mill in loss of minerals, when refining the items. (12,8M less than at first)

That does help a lot. I wasn't getting multiple items but I just didn't have enough of the rows filled out.

I do have a question about fields O9 & O20. What is Base Yield and We Take?

Hey mate
Looking good and getting better.

Got the ol chestnut again.
Since the new update I cannot select any personal stations where my stuff is.
It just gives me the option all stations. No other stations listed at all.

Also a question form a corpie, is there a way to manually add amounts without using the macro?

Hey Dedaf
Yep strange.
Tried a new API key on the old version I had and worked fine. Switched to the new version. Same API key and settings. All I get to locate from is All stations
It seems that it's only me so isn't much of an issue, Can work around it. Ill just stop spreading my materials about and keep them in one place for now.

Keep those improvements coming mate. Its still a pleasure to use. In fact I rely on it now.

Hey Dedaf,

I have encountered a problem the last few times i've used the new version of your industrial tool. After using it to calculate minerals needed, I have consistantly come up short in all fields. I also did a manual profit comparison and the overall profit I am seeing on your spreadsheet is signficiantly less than what I should be expecting based on the math I did with the numbers for build and sell listed on the capital ship production tab. Any advise on how to fix this?

Dedaf,

I have downloaded your latest version (16.4.4), and input a full-detail API key for both my character and corporation in the Data tab. How do I get the production tabs to recognize my corporation's assets to report the materials in stock?

Well Dedaf me ol buddy.
I had a little tinker in my off eve time. Would you believe that I downloaded the sheet again and off it jolly well went, Absolutely perfect. So guess it was a bad download.

Cant wait to see what you come up with next.

All the best mate

He Dedaf when will the update out for 1.3?
Keep up the good work.

Cheers

There might be an error in the Obelisk BPO. My ML2 BPO is showing the need for 14 Capital Armor Plates while the spreadsheet is showing the need for 16, The other items are all fine. 16,4,6 version.

First I want to say great job our Industrial efforts are coming in bounds due to your tool.

I have a similar problem as was mentioned here before with the API locations feed.
In previous versions I have had the api keys that I have set for dedaf tool select the stations from a drop down menu.
In version 1646 I have all stations and nothing else.
Now if I add an alt toon to the sheet, it gives me a list of stations that I have never visited let alone have things stored. If I swap my alt to slot 2 it lists all the strange stations, If I swap my alt to slot 1 it does the same.
My main never shows anything other than all stations.
I've put my main in slot 1 and 2 alone, put it in slot 1 and 2 at the same time, changed slots with alts, used various keys. Nothing.

I have tried a new api key with everything selected. same effect my main doesn't show the list.
I tried an api key with only the settings on the instructions, same again.
I dug into my downloads and found version 1601 inputted the key and all was fine with both new and old keys. Alts and main show lists with no strange systems showing up.

At the moment I have to use 1601 I know this will soon be way outdated, I'd hate to loose the tool.

Hej there!

Amazing job! This tool is of great use to me!

Do you mind looking into T2 small tractor beams? I'm getting odd numbers there - like 100k trit for the needed T1 tractor beam.

Cu, Jalina

Hej there!

Amazing job! This tool is of great use to me!

Do you mind looking into T2 small tractor beams? I'm getting odd numbers there - like 100k trit for the needed T1 tractor beam.

Cu, Jalina

Any chance Meta 2 capital guns can make it

I realize they are kinda hybrid using a T1 item and PI, but it might be able to be added to "Planets"

The T1 PRODUCTION chart is not showing ITENS IN STOCK anymore, and it dont let you change the In Stock minerals.

Despite this, thank you very much for keeping updating this amazing tool

amazing tool, thanks for hard work!
btw skiff CAN fit 3 MLU's now! ;)

Hello Dedaf,

Let me begin with telling you that iam a huge fan of this sheet!

I think however that there is an issue with mineral calculatons in "T2_Items".

If I specified that i want to manufactor for example ECCM - Magnetometric II it recordnices that i have R.A.M.- Electronics in the station specified but it will still want to add the materials for manufactoring of R.A.M.- Electronics components.

I tried to download an additional fresh version to do the same again but the result was the same, this goes for some other components that i tride which are using R.A.M.- Electronics.

Are there older versions of this document that might be able to be tested on?

Hope this helps.


Best regards
Meteon

Hi dedaf,

thank you for this sheet. i have been using it for a long time now and been very happy. I have one request though, can you add the outpost material modifier to t1 and t2 production aswell please. right now its only on the cap sheet. And maybe change the dropdown menu for it from 'basic, improved, advanced' to '1,2,3,4,5%'.

still not working for me

oh an me again there might be an issue with the calculated amount for the t2 bpcs.
i tried waspII and salvagerII and both have less pi material then they should have compared to what the ingametool tells me.
so for 1waspII with no bonus i need 6 guidance and 6 robotics
and for the salvager its 9 miniature and 12 transmitter

Just want to say thanks for adding the outpost bonuses. Many blueprints changed aswell with Crius 1.6 so most numbers are currently incorrect but the SDE is released now.

Hi
When opening the sheet, I'm receiving this error message :
"Excell found unreadable content in Dedaf's 16,6,9.xlsm. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."
If I click Yes, the sheet open normally, but when I input my APIKey, the character Name remains blank.
I've try downloading it several times, but the problem persist.
Any suggestions on how to correct that?
Thanks

How do I remove the "in stock" from showing up in the t1 Production Sheet, I think it is messing up my shopping list.

I have some minerals in some random stations, but it still seems to count them. I know there's got to be a cell I can clear somewhere, but I can't figure it out.

There's dropdowns on the t1 Production Sheet to adjust station, but there's only "all" or blank, and selecting blank and updating doesn't help.

I feel like I'm probably blind.

So, I have to bother you again :) The calculations done with T2 components are incorrect.

I tested it with a few components but I will just give one below; I used the 'Build Additional' function on the components in the T2 Ships sheet. The version is 16,6,8.

ME 10 with a 3% Outpost. I want to build 20,000 Crystalline Carbonide Armor Plates.

Your sheet shows: 760k CC and 200k Sylramic Fibers
What It shows ingame: Crystalline Carbonide768,240, Sylramic Fibers192,060

The base values are correct I checked so my guess is the material modifier isnt applied correctly. I guess you first calculate the base materials with the material modifier and then multiply with the buildruns. (Basevalue x Modifier) x Runs.

The game uses this formula: CEILING ((Basevalue x Modifier x Runs) ,1), the big difference is the number rounding only happens at the end.


And can you tell me a good way to export the Bp requirements from the datadump? :)

Very nice tool, for some reason excel is much more comforting to work with than other tools.

Couple questions:

1) I suspect it's an API thing on CCP (I'm not very good with the API limitations) but can/will the tool be able to pull inv from containers? So I can keep my stuff sorted but still see it all in your tool.

2) Maybe I'm doing it wrong - but the production tabs seem to pull my mineral quantities from my imv, but they don't pull any other items (T2, PI products etc) am I doing it wrong, or are these to be manually entered only on the Data tab?

3) Since all T2 invention produce BPC with the same ME/TE regardless of parent BPO, will you adjust that section to auto populate the standard level before decryptor? So dont have to manually change each one every time.


Thanks for the fun! I think this will help my T2 production a lot.


P.s. The T2 ship production tab, the pull down menu for ship selection is missing Prospect

why on earth does that sheet not pull the eve-central price for the finished product ?

it does pretty much everything else, but i still need to enter the price manually. that makes zero sense.

Great tool thanks, been using it off and on for like 2 years now.
Couple things:
- The latest version doesn't even load at all in open office, it just hangs up. Works find in MS Excel (this is a known issue w/ open office, but it used to at least load, just not do the xml/api updates.)
- Mobile Warp Disruptor aren't available under the T1 mods.

Maybe I'm not seeing it, but do you involve/show the 'time to build' anywhere? With the increased build time for many mods, it would be a very nice thing to have to sort out when you need to build base/middle components.

Hi,

Is it possible to see the assets from station containers? I use the corp hanger and have all my minerals and salvage ect separated in station containers.

Also can it pull the BP info from the assets list or does this need to be put in manually?

Thanks

Yyou can show assets in containers in jEveassets, how so?

Same issue for me with this version aswell.

"File is corrupt and cannot be opened"

Hey Dedaf,

Couple of issues I have noticed.

Fermonic Condensates is not calculating correctly (Same issue as I posted above I believe).

Picture

As you can see I need more Fusion reactors but no Fermonic Condensates are displaying.

Also - When selected Black Ops in T2 Ship production, Build Price and Profit list at #DIV/0!

Cheers


Edit - the Capital Jump Drive Build Price seems to be giving the error as its Build price is #DIV/0

Edit - Nevermind - I had the Number of runs cell deleted

Error in 16.7.9 when updating everything

Run-time error '-2147217376 (80041020)":
XML Parse Error

Error in 16.7.9 when updating everything

Run-time error '-2147217376 (80041020)":
XML Parse Error

Hi,

Quick question.

How do i get the production tabs to use the custom assets i have input on the data tab and not pull API assets?

Thanks

Hi,

Quick question.

How do i get the production tabs to use the custom assets i have input on the data tab and not pull API assets?

Thanks