Posted - 2009.03.20 06:06:00 - [302]

 

Originally by: Gorbain

---

So, it's not that my skills go away, I have the correct API and I get my skills, the numbers are correct but all the skill names become "skill"

---

well then you have no problem, it normal because skill names are not provided by the API.



New version 10.9.7
no big changes, just some minor correction to the t1 BP

Posted - 2009.03.24 21:05:00 - [304]

 

Thanks Dedaf,
This is one the best EvE tool I have ever seen, keep up the good work mate.

Thanks once again.

Posted - 2009.04.02 17:07:00 - [306]

 

Thanks a lot guys for the nice words, it’s always nice doing an extra effort when people appreciated the work you do.

my next project is building a T3 production sheet, i have the basic done now, but will fine-tune it a bit more before releasing it.

Thanks
Dedaf

Posted - 2009.04.05 05:04:00 - [308]

 

I dont know why you would supply you e-mail anywhere, just follow the like and click download.

Posted - 2009.04.08 14:18:00 - [310]

 

Edited by: Natascha Schwarz on 08/04/2009 14:18:26
Jump Freighter Tab:

if you dont have the needed Skill for the Parts at Level IV you get the message:

"You Need VI:" in front of the skill. Think they havent patched anything in yet beyond Level V :-)

(and for the non romans here: VI = 6)

Posted - 2009.04.09 15:47:00 - [312]

 

Great spreadsheet, I know this had to take awhile to get together and it is one of my most used tools over the last few weeks I have had it!

I only really use the T1 and Rig production tabs right now but that is all I really need. I too was wondering if you can make the columns larger as it seems a 3 digit number cannot be displayed in the T1 and rig sheets where it shows how much I can build/want to build/can build.

Posted - 2009.04.11 15:33:00 - [314]

 

In the T2 sheet,

I have to build 563 Scalar Capacitor Unit (for one Basilisk ME-4). My Scalar Capacitor Unit BPO is ME0. In the block of Missing Components, it shows missing 563 SCU correctly. In the block of Missing Materials it shows missing 9281 Fullerides, when it should be 9571.

Posted - 2009.04.16 19:39:00 - [316]

 

How do you get the list of T2 itmes to show up in the t2 productio sheet. all I see is
T2 vesion name and T1 version name below that?

Posted - 2009.04.19 08:09:00 - [318]

 

Need to fix T1 production sheet (Zydrine price)
If you change price with cell(I6) dropdown then price come from Pyerite row.

Posted - 2009.04.21 08:52:00 - [320]

 

Maybe I'm missing something, but as far as I see it your T3 gas calculations seem wrong, example for the Fulleroferrocene:
One hull (without subsystems) will need 845 Fulleroferrocene, one reaction for this would be 1000 trit, 200 C50, 100 C540 and will output 1000 units of Fulleroferrocene, your sheet seems to calculate 845 reactions needed for one hull, instead of just one to reach the needed 845 Fulleroferrocene.

Posted - 2009.04.21 16:26:00 - [322]

 

Not to be rude or anything, but when is the last time you updated the T1 blueprints, cause I had one just now where the numbers were way off... Started getting suspicious of the high profit margins it showed me.

Posted - 2009.04.23 06:43:00 - [324]

 

Dedaf,

I keep getting an error message whne i startup V11. the message is:

"Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting carefully."

Then i get:

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

if it helps the recovery log is:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error054480_03.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\Mark\Downloads\Dedaf's_industrial_tool_11 orig.xls'</summary>
- <additionalInfo>
<info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info>
</additionalInfo>
</recoveryLog>

Guessing this is the reasion its not getting my skill once i enter the API key or update the prices.

Thanks in advance.

Phantom

Posted - 2009.04.25 12:04:00 - [326]

 

Originally by: Erestas Drake

---

Maybe I'm missing something, but as far as I see it your T3 gas calculations seem wrong, example for the Fulleroferrocene:
One hull (without subsystems) will need 845 Fulleroferrocene, one reaction for this would be 1000 trit, 200 C50, 100 C540 and will output 1000 units of Fulleroferrocene, your sheet seems to calculate 845 reactions needed for one hull, instead of just one to reach the needed 845 Fulleroferrocene.

---

I checked it a bit, and yes you are right, i didnt include the reaction in the calculation.
I have corrected it and will upload a new version soon.

Originally by: ArtomN

---

ther is a prablem with Caesarium Cadmide reaction in Pos_Prodaction
the right row matirials you need is Cadmium Caesium and in you chats it takes
Caesium AND Chromium

---

You are right, the correction will be in the next version.

Originally by: Dariah Stardweller

---

Not to be rude or anything, but when is the last time you updated the T1 blueprints, cause I had one just now where the numbers were way off... Started getting suspicious of the high profit margins it showed me.

---

I have done it only ones when i build it, i wont waist me time checking trough thousands of BP to see if they are correct. So if you see that there is a problem with some of the BP, then let me know which ones and ill try to correct.

Originally by: Black Friar

---

Im still with this problem and i made one test.
First i opening your work in the excel 2007 (this is the problem).
If i use vlookup function in the excel 2007 without ending FALSE (Exact match) then default value is True what mean (Approximate match).
Because of that in some case value taken from the wrong row.
'------
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(A8, G2:L10, 3, FALSE)<--- only right metod for excel 2007
=VLOOKUP(A8, G2:L10, 3)<--- working only in the excel 2003
'-----
Maybe you can make some changes in your next version.
ty

---

I dont see this error in any of my office version, but i have added the False function to the formula, so you shouldt see the problem in the next version.

Originally by: phantom ghost

---

Dedaf,
I keep getting an error message whne i startup V11. the message is: "Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting carefully."

Then i get: "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

Guessing this is the reasion its not getting my skill once i enter the API key or update the prices.
Thanks in advance.
Phantom

---

If you are using Office, then i think its cause your macro security is too high, it should be set to no more than medium.

Originally by: HirschG

---

I have a problem importing my skills.....i enter api and user and nothing happenes when i press update.

---

I believe your problem is the same as Phantom's, your macro security is too high, so the macros are removed from the sheet. But could also be that you are not using Microsoft Office 2003-2008 but OpenOffice, which dont support this kind of macros.



Thanks for all your feedback, ill make sure the corrections are in the next version.

Posted - 2009.04.25 19:38:00 - [328]

 

Edited by: Dedaf on 25/04/2009 20:08:55

Originally by: Commander Phoenix

---

Hi again. this still doesn't work with 2 of my characters (they both have spaces in their names). One of my characters does work though (has no spaces in name). With the characters that have spaces in their names, th spreadsheet updates something, but the Mining tab shows no name in the character box, It does however sho the time I tried to update it. Sometimes I get the error quoted and Excel just freezes up and I have to kill it using the task manager.

---

Hmm i just done some tests, and yes i see your problem, though my excel dont crash, it just dont import the skills.


edit:
ok i found the problem, unfortunatly i cant fix it, because it seems to be a problem with the API it self.

You can check it out yourself this way

first get your character ID's
http://api.eve-online.com/account/Characters.xml.aspx?apiKey=Paste your API here&userID=Paste your user id here

here you check your skills, if you use the number of the character with the name which contain a space, then you will see it fails
http://api.eve-online.com/char/CharacterSheet.xml.aspx?apiKey=Paste your API here&characterID=Paste your Character id here&userID=Paste your user id here

When your character have a space in the name, then you will get this error from the API server.

<?xml version="1.0" encoding="UTF-8" ?>
- <eveapi version="2">
<currentTime>2009-04-25 19:53:13</currentTime>
<error>A general error has occured, please try again later.</error>
<cachedUntil>2009-04-25 20:53:13</cachedUntil>
</eveapi>

Posted - 2009.04.25 22:08:00 - [330]

 

Any chance of a mirror? not been able to download, been trying for a few days now