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
Dedaf
United Brothers Of Eve
#121 - 2012-08-07 15:57:11 UTC  |  Edited by: Dedaf
I have just uploaded the latest version of my sheet.
The sheet has been modified, to be in-line with the changes done to mining ships in Inferno 1,2

New version 14.5.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/
Blodhgarm Dethahal
8 Sins of Man
Stray Dogs.
#122 - 2012-08-08 02:23:07 UTC
Absolutely Excellent Tool for every kind of industrial pilot out there. It has been an excellent tool to help me manage my T3 Production.

Have you thought of adding taxes to the Planet Production Tab? I realize it might not be possible... but I think it would be a neat feature to haveSmile

Very well done Spreadsheet
Vile Industrial
Future Corps
Sleeper Social Club
#123 - 2012-08-08 17:55:32 UTC
With the new update, they also change the BP`s for frigates and mining barges/exhumers :)
I made quite a considerable loss on that ;) Anyhows, a heads up is provided now:D
Dedaf
United Brothers Of Eve
#124 - 2012-08-13 15:43:45 UTC
Hi Blodhgarm Dethahal
I was thinking about it, but the tax is calculated from a estimated value of the material, so i think it is too incorrect for any real use.
But maybe i could add the option to enter the % and then calculate it from your own material prices. But i still think its gonna be too inaccurate to be of any real help.
Thanks for the idea.

Hi Vile Industrial
Yes i had corrected the material need for building the Barge and Exhumers. But i wasn't aware of the change that was done to some of the T1 frigates. Thanks for the heads up.

I have corrected the mineral need for the T1 frigates in the latest version.

New Version 14.5.9

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
#125 - 2012-08-19 10:44:45 UTC
Just uploaded a new version, with a booster production sheet.

Version 14,6,2

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
FightTh3p0w3r
Worthless Carebears
The Initiative.
#126 - 2012-08-21 00:11:45 UTC
Love your tool, great work.
Xaneth Salvor
State War Academy
Caldari State
#127 - 2012-08-27 02:31:50 UTC
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.
Capatec Anahuac
Sebiestor Tribe
Minmatar Republic
#128 - 2012-08-28 15:08:03 UTC  |  Edited by: Capatec Anahuac
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?
Dedaf
United Brothers Of Eve
#129 - 2012-08-30 13:11:11 UTC
Xaneth Salvor wrote:
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.

Very nicely spotted, i have corrected in the new version.



Capatec Anahuac wrote:
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?

Correct, the tool does not import items from the API, only your characters and skill.


New version 14,6,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/
Zuleikha
The Dispossessed
#130 - 2012-09-01 17:49:46 UTC
Very impressed by this tool :)

Question - I just purchased a set of blueprints for shield resistance enhancers.
They dont seem to appear in your spreadsheet.

EM Ward Field I
EM Ward Aplifier I

Explosive Deflection Field I
Explosive Deflection Amplifier I

Kinetic Deflection Field I
Kinetic Deflection Amplifier I

Thermic Dissipation Field I
Thermic Dissipation Amplifier I

If they are there, where are they?
Dedaf
United Brothers Of Eve
#131 - 2012-09-04 04:45:35 UTC
Hi Zuleikha
They are there, but just with the old name, look in Ship_equipment -> Shield, there you will find them look for Field and Amplifier.
They all have the same mineral amount so it dont matter which on you select.
I will make sure to correct the names in the next version.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Taveira PT
Delta force 1
#132 - 2012-09-07 15:15:33 UTC
Hi

Im sorry if this question was previusly 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?
Dedaf
United Brothers Of Eve
#133 - 2012-09-07 15:31:05 UTC
Taveira PT wrote:
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 think its a bug from when the fuel blocks came in. I don't have a tower to test on, so i cant test or correct it at the moment.
Last time someone mentioned this, i asked if there were anyone willing to lend me a API key, then i could try to correct it.
Other vice i will have to wait till i need a tower again.

Thanks for reporting it though.

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/
Taveira PT
Delta force 1
#134 - 2012-09-07 15:57:03 UTC
Hmm

Acording to the info on this link, the expected result still have all the old mats.

http://wiki.eveonline.com/en/wiki/EVE_API_Corporation_POS_List

Maybe it never got uptadet.
Ill test it and if i come up whit something ill talk to you.
loard doktor
tradersbear
#135 - 2012-09-11 19:17:05 UTC
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?
Aurora Quinn
Science and Trade Institute
Caldari State
#136 - 2012-09-11 20:24:46 UTC
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
SunTsu Rae
Perkone
Caldari State
#137 - 2012-09-12 02:20:37 UTC  |  Edited by: SunTsu Rae
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


Opening this website may put your security at risk


The website you wanted to see might transmit malicious software to your computer, or has done that before to someone else. It may also show signs of involvement in online scams or fraud.


Address:

http://199.91.154.130/lgwok0l91tqg/t144xt61lakmsav/dedaf%5c%27s+indust...



Rating:

Dangerous


What you can do:



Try visiting another site to find the information you want.



Notify Trend Micro to review this page if you consider it safe.


If you still want to see this blocked page:
1. Open the Trend Micro Internet Security Pro console.

2. Click Internet & Email Controls

3. Click the Settings... button under Protection Against Web Threats.

4. Click the Approved websites link in the next window that opens.

5. Copy and paste the address of the blocked website into the list.

Note: If you still want to visit this site despite the risk, click here to open it.

SunTsu Rae Ensuring Rights, Recognition, and Remembrance. (Gulf War 1991) http://www.vfw.org
Dedaf
United Brothers Of Eve
#138 - 2012-09-12 13:10:53 UTC
loard doktor wrote:
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?

Aurora Quinn wrote:
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

I think the problem you are doth seeing is because you are not using Microsoft Office 2007pro or 2010pro
Open office does not support XML import and MS office pre 2007 can not handle the calculations done in this tool.
So in short, you need Microsoft Office 2007pro or 2010pro.

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
#139 - 2012-09-12 13:24:40 UTC
SunTsu Rae wrote:
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


Hi SunTsu
I dont know the security tool you are using, which is blocking your access to the download.
However i'm sure that you will be able to find scammers all over, no matter which host you are using to upload/download files from. In my case i find mediafire reliable.

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/
Aurora Quinn
Science and Trade Institute
Caldari State
#140 - 2012-09-12 16:43:08 UTC
Dedaf wrote:
loard doktor wrote:
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?

Aurora Quinn wrote:
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

I think the problem you are doth seeing is because you are not using Microsoft Office 2007pro or 2010pro
Open office does not support XML import and MS office pre 2007 can not handle the calculations done in this tool.
So in short, you need Microsoft Office 2007pro or 2010pro.



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?