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
Dusty Meg
Echelon Research
Goonswarm Federation
#41 - 2011-12-01 22:08:16 UTC
Above question. and any chance of having the fuel blocks put in aswell

Creater of the EVE animated influence map http://www.youtube.com/user/DustMityEVE
Dedaf
United Brothers Of Eve
#42 - 2011-12-02 22:53:14 UTC
Yep, i am as we speak correcting and adding things.
I have the capitals corrected and the Fuel blocks in the sheet now. Will upload a new version sometimes this weekend.
However the new T2 items will take a bit longer to add, but i am working on it.
I expect to be done with them sometimes this coming week.

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
#43 - 2011-12-03 10:31:06 UTC
uploaded new version, with correction to capitals and added fuel block calculation to the PI sheet.
Still working on adding the new T2 items.


New version 14.2

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/
Sen Quenten
House of Quenten
#44 - 2011-12-04 00:33:36 UTC
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
Dedaf
United Brothers Of Eve
#45 - 2011-12-04 13:02:44 UTC
Sen Quenten wrote:
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.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Sen Quenten
House of Quenten
#46 - 2011-12-04 16:47:37 UTC
Dedaf wrote:

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.
Dedaf
United Brothers Of Eve
#47 - 2011-12-04 17:43:11 UTC
Sen Quenten wrote:

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.

You write Nanomechanical Microprocesso and Nanoelectrical Microprocessor those are two different items that use different material.

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?

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Sen Quenten
House of Quenten
#48 - 2011-12-04 18:57:27 UTC
Dedaf wrote:


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?


Ummm, wow. Sorry about that. I guess I pulled up the wrong one in game. You are correct. I was looking at the wrong one.

Cheers.
Dedaf
United Brothers Of Eve
#49 - 2011-12-06 17:26:54 UTC
I'm finally done adding the new t2 items.

new version 14.2.3

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Dream Five
Renegade Pleasure Androids
#50 - 2011-12-08 00:46:15 UTC
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.
Dream Five
Renegade Pleasure Androids
#51 - 2011-12-08 00:46:36 UTC
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.
Arganas Paendrag
Paendrag Enterprises
#52 - 2011-12-08 05:28:08 UTC
ICU Andshutup wrote:
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)


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
Dedaf
United Brothers Of Eve
#53 - 2011-12-08 06:02:10 UTC  |  Edited by: Dedaf
Dream Five wrote:
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.

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

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
#54 - 2011-12-08 06:06:57 UTC
Arganas Paendrag wrote:


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

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Dusty Meg
Echelon Research
Goonswarm Federation
#55 - 2011-12-08 09:05:05 UTC
Dedaf wrote:
Dream Five wrote:
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.

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


Dedaf that got updated so your calculations may be wrong.

Try this dev blog
http://www.eveonline.com/devblog.asp?a=blog&nbid=3143

Each production run of fuel blocks will now take five minutes rather than ten minutes
Each production run of fuel blocks will now produce FORTY fuel blocks rather than FOUR
Fuel blocks are now 5m3 rather tha 50m3
Fuel blocks can now be produced in Component Assembly Arrays as well as Ammunition Assembly Arrays
Control towers will now use 40/20/10 blocks an hour for large/medium/small towers, up from 4/2/1 (matched by production increases)
Faction towers will no longer have a fuel bay capacity bonus; their bays will be 140k/70k/35k in line with standard towers
Faction towers will have a 10% fuel use reduction for "tier 1" towers and a 20% fuel use reduction for "tier 2" towers (compared to their standard tower equivalents), taking them to 36/18/9 and 32/16/8 respectively for large/medium/small towers

Creater of the EVE animated influence map http://www.youtube.com/user/DustMityEVE
Dedaf
United Brothers Of Eve
#56 - 2011-12-08 21:35:08 UTC
Thank you very much for pointing this out. I will make sure its corrected in the next release, tomorrow.

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
#57 - 2011-12-09 19:02:02 UTC
The fuel block calculation has been corrected.

New version 14.2.4

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Arganas Paendrag
Paendrag Enterprises
#58 - 2011-12-10 04:36:31 UTC
Dedaf wrote:

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.


Dedaf
From what im seeing of this speadsheet, it looks awesome, however i'm still receiving the same Runtime error whenever i try to update anything, i followed your instructions, and still no luck. I'll be grateful for any assistance you can provide.

the error i'm recieving is: Runtime Error '-2147217376 (80041020)'
I get the error anytime i try to use any of the update buttons

Thanks for your time and effort.
Ezeri Dax
KarmaFleet
Goonswarm Federation
#59 - 2011-12-11 18:13:11 UTC
Hi there,

I recently found your tool and am finding it extremely helpful so I wanted to thank you for all the hard work you put into making it.

I also had a question as to how to set the mineral prices manually if you are not buying them off the market or for setting to a specific region or system, as right now the difference between the average in all regions and in some of the places where I get my minerals is very different so I would like to get a more a accurate view of my costs and profit margins.

if this is not a current feature then I would like to request it be made into one soon.

thank you again for sharing your talents with the rest of the community.

Ezeri Dax
Dedaf
United Brothers Of Eve
#60 - 2011-12-11 20:43:34 UTC
Hi Ezeri Dax
Im happy to hear you like the sheet.

For sure its a feature already, go to the DATA sheet and enter your own prices in the blue fields.
Then go to the production or mining sheet you are working with and select price option as: Own
Then the sheet will calculate using your values.

Enjoy
Dedaf

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