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
CrazyjoeryNL
Aliastra
Gallente Federation
#61 - 2011-12-13 21:31:46 UTC  |  Edited by: CrazyjoeryNL
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. Lol

regards,

crazyjoery
Planek
Destructive Influence
Northern Coalition.
#62 - 2011-12-14 21:38:05 UTC
I may just be missing it but are certain t2 components missing? When entering in, for example, a 1mn micro warp drive II into the t2_items tab. It says blueprint not found for a lot of the components. But there does exist a blueprint
CrazyjoeryNL
Aliastra
Gallente Federation
#63 - 2011-12-14 21:43:03 UTC
you need to make use of the drop down lists
Ezeri Dax
KarmaFleet
Goonswarm Federation
#64 - 2011-12-16 08:31:35 UTC
Hi Again,

I was curious if there was a way to do a price comparison between buying ore and refining it yourself or buying the minerals straight out, as it was just pointed out to me that I could be saving some money buying the ore and refining it myself and gathering the minerals I need to build with that way instead of buying the minerals directly and I am just curious as to what I would need ore wise and how much it would cost to get the minerals to build what I am building.

and once again thank you for your hard work in making all us industrialists lives easier I know your tool has made my manufacturing jobs alot easier to prepare for.
CrazyjoeryNL
Aliastra
Gallente Federation
#65 - 2011-12-16 18:15:50 UTC
you can see what amount of minerals you need from any of the production sheets.
then if you go to the ore tab from the spreadsheet you can see what ores you need to mine and how many in order to get the mineral amounts needed.

then if you go to the ore mining sheet and fill out the amounts of ore you need to mine there. the sheet will use your skills and the settings you apply for the refining using a station.
from that point you know if the value of the minerals will be more or less then the raw ore value you can look up from the market.

hope this is helpfull for you
TehFedz
Bury Your Gods
Mercenaires Sans Frontieres.
#66 - 2011-12-18 21:48:19 UTC
I created an API key, put the info into the data tab and tried updating but I cannot for the life of me get the skills to carry into the spreadsheet. I had no problem before the new API keys were introduced. Can anyone help?
CrazyjoeryNL
Aliastra
Gallente Federation
#67 - 2011-12-20 17:21:06 UTC  |  Edited by: CrazyjoeryNL
to get your character info through the new api system and into the spreadsheet you need to make use of the new api system. the old keys are dead and wont work anymore as they dont contain any info.

to get to the new api creator you need to go to this page login with you account and click on the api keys link.
or just click on the button that is in the sheet not sure if that one points you in the right direction as i just grabbed mine from the link above.

on that page you need to create a new custom API key and select the options you want in it.
then a key will be generated for your account or specific character.

the old api system was a userid with a api key.
the new system is with a keyid and a verification code.

the new key generated will show you both that you can use.

hope this was helpfull enough for you.

- CrazyjoeryNL
Princess Cellestia
Friendship is Podding
#68 - 2012-01-02 06:22:42 UTC
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.
Dedaf
United Brothers Of Eve
#69 - 2012-01-02 19:31:39 UTC
CrazyjoeryNL wrote:
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. Lol

regards,

crazyjoery

Hi Crazyjoery
Im very happy to know you like the sheet.
Building a outpost tool is on my list, it is probably the very next tool to be added. How ever it takes long to build and i need to start building them myself or do a bit a research first, to make sure i know how it works.
So i cant say when i will have this tool, but it is in my list of "need to build"


Princess Cellestia wrote:
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.
That is a lot of Maels!! :) but i have modified the tool now, so you can adjust the columns as you like.
Hope you will like it.


New Version 14.2.5

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Rita Jita
Caldari Provisions
#70 - 2012-01-10 11:38:38 UTC
Having an issue with updating info.

using excel 07

error;

Run-time error '2147217376 (80041020)':

XML Parse Error


Any help would be great

Founder of the "Haulers Channel"

Come Check It Out
Rita Jita
Caldari Provisions
#71 - 2012-01-10 20:22:05 UTC
nvm i found it, i needed to unlock administrator account and use this instead

Founder of the "Haulers Channel"

Come Check It Out
Afrodite Starbuster
Doomheim
#72 - 2012-01-14 01:51:48 UTC  |  Edited by: Afrodite Starbuster
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?
Dedaf
United Brothers Of Eve
#73 - 2012-01-19 05:44:36 UTC
Afrodite Starbuster wrote:
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?

im not 100% sure i understand why you mean, each sheet already show the price of all minerals?

Regarding faction ships, they are in the T1 sheet under, Pirate ships and Navy ships.

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/
Afrodite Starbuster
Doomheim
#74 - 2012-01-19 06:54:33 UTC  |  Edited by: Afrodite Starbuster
Dedaf wrote:

im not 100% sure i understand why you mean, each sheet already show the price of all minerals?



I mean the price for each individual mineral as well as the overall total.

like for example

ship X

Tritanium = 12345 Value = 12345
Pyerite = 12345 value = 12345
etc
etc

Total = 24690


this way I can see what the most expensive part of the build is and see if I can't find a better source for that specific mineral.
Lady Vici
Blinky goes to Hollyhole
Blinky Red Brotherhood
#75 - 2012-01-19 10:14:47 UTC
Hi Dedaf,

I'm using your sheet now for nearly 3 years and have to state its really a great work.

BUT I'm missing one really - for me important - point:

would it be possible to add a API fetch of the actual assets and update the "in stock" values with it so that I not have to work through the whole template over and over again?

I tried this a bit by using jveassets and export them as excel and use vlookup to import the data into your sheet. It actually worked but a direct implementation would be really nice.

Anything planned about that?
Zifrian
The Frog Pond
Ribbit.
#76 - 2012-01-19 14:23:56 UTC
People have requested this feature with my program too but the API isn't that flexible. Assets are only refreshed every 6 hours so the usefulness of this type of feature is limited by that.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Lady Vici
Blinky goes to Hollyhole
Blinky Red Brotherhood
#77 - 2012-01-19 14:28:24 UTC  |  Edited by: Lady Vici
its ok if the update is done once a day imo, just that I get an nearly actual status at the beginning of each day. Still helps a lot as of now I have to enter it manually or do the work around as written above...

jveassets is imo best programm for asset analyses as it is easy to use and it has a nice excel export. But this states that its possible without a big effort and a vlookup is probably the easiest part for Dedaf anyway Blink

btw, didn't know your program yet, will have to test it.
Human Friend
Doomheim
#78 - 2012-01-20 11:09:00 UTC
Found a little bug, dunno if its already been taken care of in the newest version:

Silo`s use broadcast nodes and recursive computing modules as PI components,

sheet shows it needs organic mortar applicators and recursive computing modules.


Anyways, amazing job - been using it since i found this and its been a lifesaver for a new industrialist.
Thanks.
Hellenn
KarmaFleet
Goonswarm Federation
#79 - 2012-02-04 07:37:45 UTC
i dont know if it was mentioned but please review the materials used for Gang asist modules, i dont know if all but some use advanced materials to build t1 modules

Great tool, A++++
solardave
Argentum Holdings
#80 - 2012-02-09 03:10:27 UTC
Can I just say this is an excellent spreadsheet. Can I just back up the request for an asset update option as well to have a list of the assets that the corp has would help in the planning. Not sure how I would fit in to the spreadsheet myself , but the data would be great (e.g. upto date (within reason) records of what is in the silos and hangers with respect to overall planning.

It would be good to get the POS fuel reports cleaned up as well (not high on my list as I also use a POS tracking solution)

(This is being picky, it is a great tool, very well done)

Cheers