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.
 

Dedaf's industrial tool
Author
Previous Topic Next Topic
Painstouch Hawk
Native Freshfood
Minmatar Republic
#301 - 2013-09-11 12:00:50 UTC  |  Edited by: Painstouch Hawk
Sadly, I cannot get over the following error, which happens when I open the Excel in Office 2010 Pro Plus.

"Excel found unreadable content in 'Filenamehere'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

If Yes -> Following error shows:

Excel was unable to open file by repairing or removing the unreadable content.
Removed Part: /xl/vbaProject.bin.part. (Visual Basic for Applications (VBA))

Click to view the log.

Log is;


error065760_01.xml
Errors were detected in file 'C:\Users\Name\Desktop\Dedaf's industrial tool 15,6,4.xlsm'
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))



If I click No -> Nothing happens, Excel stays blank.

Now, when I try to update anything, Macro refuses to work, says its not available in this workbook or all macros may be disabled.

Already made sure the VBA plugin is installed via Office Suite, I have Trusted Sources set to allow all, so is ActiveX plugin allowed.

I'm opening latest File version, which is 15.6.4 via WinRar v4.20 (64bit) on a Win 7 64bit OS.


Thanks for your help.
Banjo Blanco
Viziam
Amarr Empire
#302 - 2013-09-11 12:49:55 UTC
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
Dedaf
United Brothers Of Eve
#303 - 2013-09-11 17:00:33 UTC
Hi Painstouch Hawk
I do not know what could be the reason for the problem you have. Have you tried the solutions described in FAQ 7 & 8 here?
It is most likely some problem with your Office installation, all i can advice you to do, is to google the error you get, to see if others have the same issue.

Banjo Blanco wrote:
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

To do so, i would have to import price information for all Ore types. I like to keep the tool simple looking, so i will not importing this much data just to do that calculation. The "1 Unite Price" already listed in the ore mining sheet, shows you the price that the ore have calculated on the minerals you get when refining it.
So if you can sell the ore for more than the "1 Unite price", then you will make even more money than refining.

Thanks for the feedback though.

B'atou wrote:
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.

I have corrected the mineral need for the prophecy in the T2 Sheet now, so you should get a more correct build price now.


New version 14.6.5

Thanks

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Mmrsshan
Trash Shapito
#304 - 2013-09-14 05:46:06 UTC
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?
Dedaf
United Brothers Of Eve
#305 - 2013-09-14 06:19:56 UTC
Mmrsshan wrote:
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?

Im not really sure i understand which items you are referring to. could you give me a few examples of some items that you think is being calculated wrong?

Thanks

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Mmrsshan
Trash Shapito
#306 - 2013-09-14 07:05:29 UTC  |  Edited by: Mmrsshan
A simple example. Take Inferno Fury Cruise Missile BPC (ML -4). For the production of need:

  • Tritanium - 30120;
  • Mexallon - 450;
  • Nocxium - 105;
  • Megacyte - 53;
  • Morphite -15;
  • R.A.M. Ammuntion Tech;
  • Rocket fuel 120 + 6 extra (134 in your document, this is another error);
  • Phenolic Composites - 59 (apparently they are included in the batch build price, but do not appear in the table located on top);
  • Plasma Pulse Generator - 14. <- That's what I wanted them to talk.



For the production of Plasma Pulse Generator is required:

  • Crystalline Carbonide - 22;
  • Nanotransistors - 2;
  • Phenolic Composites - 7;

But at ML15, these values ​​are changed to 20, 2 and 6, respectively.
Dedaf
United Brothers Of Eve
#307 - 2013-09-14 08:03:00 UTC  |  Edited by: Dedaf
Hi Mmrsshan
Very well spotted!
I have corrected the errors to the Mexallon, Phenolic Composites & Rocket fuel in the T2 Item Production tool, and uploaded a new version 15,6,7

Regarding the T2 Components, then they go to 20, 2 & 6 already at ML4 so it is correct that ML15 is showing what it is.
Thank you for helping making the tool better.


Also in the new version 15,6,7 is an all new Gas Harvesting tool.

Enjoy

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Mmrsshan
Trash Shapito
#308 - 2013-09-14 08:44:32 UTC
Thanks for the quick response.
Regarding the ML T2 components , it is my mistake. I didn't scroll down the sheet.
Mmrsshan
Trash Shapito
#309 - 2013-09-14 09:27:58 UTC
Maybe I found another error - in all the T2 Gang Links incorrect set quantity of required Hypersynaptic Fibers and Nanotransistors .
Dedaf
United Brothers Of Eve
#310 - 2013-09-14 20:49:43 UTC
Mmrsshan wrote:
Maybe I found another error - in all the T2 Gang Links incorrect set quantity of required Hypersynaptic Fibers and Nanotransistors .

thanks again
I will have it corrected in the next release.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Cedub
Sebiestor Tribe
Minmatar Republic
#311 - 2013-09-17 03:10:18 UTC  |  Edited by: Cedub
Liking it so far, experiencing quite a few issues though.

On the Ore sheet: Michi's Excavation Augmentor - requires Cybernetics 5 (The other Implant drop downs notify you if you do not have high enough Cybernetics skill)

On the Planetary Interaction sheet: I've selected 2 different types of fuel to be produced, the ML and the amount of days, the "Needed" field populates, however the "Missing" field does not populate for Non-CS Crystals and Ionic Solutions - also in the same row for Chiral Structures & Electrolytes. There may be others, these are just the two I happen to need that are missing.

The other issues seem to have been fixed with the latest update.

Can we look at importing Character Assets via API? I know there's other software that does this, and it would take a lot of hassle out of manually entering numbers.
Dedaf
United Brothers Of Eve
#312 - 2013-09-17 10:18:31 UTC
Hi Cedub
I have corrected the texture colure for the missing material Non-CS Crystals and Ionic Solutions. They were calculated, but was just showing in a wrong colure (same as cell background) now red.
I also fixed the notification message for the michi implant, it will now tell you that you need lvl5 cybernetic. It was only a notification error, the bonus of the michi implant was not added if you had lower than lvl5 cybernetic, so it didnt effect the numbers in the mining sheet.
All the corrections will be in the next version.

Thanks for the feedback.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Dedaf
United Brothers Of Eve
#313 - 2013-09-21 08:16:17 UTC
New version 15.6.8

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
kookalt
AlpacaWaffe
The Last Alpaca
#314 - 2013-09-21 18:59:48 UTC
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
Creaming Soda
Tactically Challenged
The Initiative.
#315 - 2013-09-29 12:54:19 UTC
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

Creaming Soda Ariel Rin
Merksniper
Imperial Shipment
Amarr Empire
#316 - 2013-09-29 18:34:51 UTC
Mercoxit's ISK/Hour isn't updating. Just stays at zero. FYI
Dedaf
United Brothers Of Eve
#317 - 2013-09-30 08:45:11 UTC  |  Edited by: Dedaf
Creaming Soda wrote:
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

Hi Creaming Soda
Thanks for the ideas you submitted, I will for sure add the gas that I missed, so the wormholes can have some love :-)

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Dedaf
United Brothers Of Eve
#318 - 2013-09-30 08:47:32 UTC
Merksniper wrote:
Mercoxit's ISK/Hour isn't updating. Just stays at zero. FYI

It's because you need to select the right ship for mining it. It does not make sense to show isk/hour if the selected ship can not mine it.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Alenn G'kar
Deep Core Mining Inc.
Caldari State
#319 - 2013-10-03 20:19:21 UTC  |  Edited by: Alenn G'kar
Hey, i have little problem with the last version, there is screen http://prntscr.com/1v2hmb (runtime error 1004, but I've set all macros on) Can you help me? thx
Dedaf
United Brothers Of Eve
#320 - 2013-10-04 19:28:23 UTC
I don't understand the language of the error message, so I can't help you here.
But I see u haven't entered any API info, so I'm wondering what you are doing when you get that error, is it as soon as u open the file? Also it would be nice to know which office version u use.
So contact me in game an lets see what we can find out.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/