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.
123Next pageLast page
 

Dedaf's industrial tool
Author
Previous Topic Next Topic
Dedaf
United Brothers Of Eve
#1 - 2011-09-09 18:32:41 UTC  |  Edited by: Dedaf
Hi
I have tried to build a industrial tool that covers most of EVE-Online's industry.
You will find tools for mining, building T1, T2, T3, Capitals and Rigs, and latest the Ore Compression Tool
Latest: The Tool is now up to date, with most changes that came with Crius 1.6

Anyway let me know what you think of it or maybe even submit new idea's? Of cause ISK donations are always appreciated. Big smile

enjoy

Download the latest Version of Dedaf's Industrial Tool

HELP improve EVE-central market statistic, by downloading the EVE Central Market Uploader

In this sheet you will find the following Industrial tools:

  • Ore Mining
  • Ice Mining.
  • Ore to mine, calculated from mineral-need.
  • Ice to mine, calculated from fuel-need.
  • Ore Corp Mining calculator.
  • Ice Corp Mining calculator.
  • Planet Interaction
  • Station Production
  • POS Fueling/Reaction.
  • Gas Harvesting
  • Booster Production
  • T1 Ship, items & Rig Production.
  • T2 Ship, Items & Rig Production.
  • T2 Invention tool. Build on an idea of Eloria Thuk.
  • Tech III production.
  • Capital Production
  • Jump Freighter production
  • Ore Compressing
  • Shopping List



OLD forum post

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
themaker1971
Republic University
Minmatar Republic
#2 - 2011-09-09 22:22:06 UTC
Well done on a great program. :)
Type Mismatch
Hedion University
Amarr Empire
#3 - 2011-09-10 12:24:56 UTC
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.
Roland Schlosser
Entropy Engine
#4 - 2011-09-10 17:51:46 UTC
Hands down the best spreadsheet I've ever had the pleasure of working with Big smile
Dedaf
United Brothers Of Eve
#5 - 2011-09-10 18:50:25 UTC  |  Edited by: Dedaf
Type Mismatch wrote:
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.

You will find those items in the Planet interaction tool. The reason for this is, that they do not using standard minerals to build but Planet material. Scroll down to cell D72 and select Tower or array's.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
ICU Andshutup
Kill Injure Slash and Stomp
#6 - 2011-09-12 15:26:25 UTC
Great tool Dedaf!! I have not experimented yet, but do the new API keys work?
Dedaf
United Brothers Of Eve
#7 - 2011-09-18 20:33:27 UTC
ICU Andshutup wrote:
Great tool Dedaf!! I have not experimented yet, but do the new API keys work?

Im working on correcting the sheet so it will run with the new API keys. I have it working already, but i just want to add some more features before releasing it. I will upload it in a few days, or at least before the old key's stop working.

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/
stavrious
Filikh Etairia
#8 - 2011-09-20 08:57:57 UTC
nicely done dedaf. i think i ll be using this a lot
Dusty Meg
Echelon Research
Goonswarm Federation
#9 - 2011-09-30 10:26:34 UTC  |  Edited by: Dusty Meg
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.

Creater of the EVE animated influence map http://www.youtube.com/user/DustMityEVE
Dedaf
United Brothers Of Eve
#10 - 2011-09-30 16:46:41 UTC
Dusty Meg wrote:
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.

H, good to hear you like the tool. The new Key is working great already, i just wanted to add the option of a 2nd character API to the sheet. This is what takes a bit longer than expected. But im almost there now, my goal is to release a new version this weekend.

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/
Raziphan Rebular
Path of Dooppa
#11 - 2011-10-01 02:16:45 UTC
Does this work in open office?
Wa'roun
The Scope
Gallente Federation
#12 - 2011-10-02 07:21:33 UTC  |  Edited by: Wa'roun
Sinq Laison is not in the region list (home to Dodixie).

Raziphan Rebular wrote:
Does this work in open office?



http://www.eveonline.com/ingameboard.asp?a=topic&threadID=557482
Dedaf
United Brothers Of Eve
#13 - 2011-10-02 09:09:34 UTC
Wa'roun wrote:
Sinq Laison is not in the region list (home to Dodixie).

Hi Wa'roun
It is in the list, it it just because i put the 3 most used regions in the top, so people wont have to scroll so much.
Since The Forge is listed in the sheet by default, then Essence and Sinq Laison will be in the list a bow it, so just scroll up in the list and you will find it :)

I will upload a new version with the new API key and other nice things today.

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/
Wa'roun
The Scope
Gallente Federation
#14 - 2011-10-02 09:29:26 UTC
I was scrolling by alphabetical order.

I guess I am weird.
Dedaf
United Brothers Of Eve
#15 - 2011-10-02 20:13:36 UTC
I finally completed the sheet to be released with the new API key system of INCARNA.
You are now able to upload 2 character APi keys and 1 Corp API key.
And also i have build a backup/restore option for the DATA sheet, so in future version of this tool you will be able to restore you API keys and market info, that you have entered in the DATA sheet of the old version.

New Version 14

Enjoy guys

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
ICU Andshutup
Kill Injure Slash and Stomp
#16 - 2011-10-03 19:53:39 UTC  |  Edited by: ICU Andshutup
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)
M Kernel
Cayman Applied Kinetics
#17 - 2011-10-04 19:51:09 UTC
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!
Wa'roun
The Scope
Gallente Federation
#18 - 2011-10-04 20:16:33 UTC
M Kernel wrote:
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!


imported?
M Kernel
Cayman Applied Kinetics
#19 - 2011-10-04 20:22:23 UTC
imported ;-)
Dedaf
United Brothers Of Eve
#20 - 2011-10-06 05:06:24 UTC
M Kernel wrote:
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 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

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