Author |
Topic |
 Gorbain |
Posted - 2009.03.19 16:23:00 - [ 301]
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"
|
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
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 |
 Knossos Gallente GrueTech
|
Posted - 2009.03.23 16:43:00 - [ 303]
Very nice project Dedaf :)
I just started looking at it and it is all very nice and straight forward.
I was wondering if there is a way to unlock the columns so that I can change the widths of them? The T1 production screen hangs off the edge and it is a little irritating to scroll all the time.
Thanks again for the wonderful app, I look forward to using it :) |
 Digdepa Fore |
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.  |
 Mikal Bishop Gallente Iron Anvil Industries Violent Entity |
Posted - 2009.03.27 22:16:00 - [ 305]
I love this sheet. My corp mates have started calling me Mr. Spread sheet because I constantly say Let me check my spread sheet. Well done. I would request a link between the required minerals on the T1 production sheet and the needed materials on the ore calculator. Or let me copy from porduction sheet to the ore calcualtor sheet. At any rate I still love the sheet and will continue to use it. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
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 |
 Aus Dog |
Posted - 2009.04.04 20:25:00 - [ 307]
I just get sick of supplying my email address to every Spam Mill in the Real Universe. If you are proud of your work figure out how to let us get to it without inviting a huge Spam Invasion. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
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. |
 Jake Dykes Deutsche Minen und Werke Guardian Federation |
Posted - 2009.04.08 14:06:00 - [ 309]
It seems I found a rounding bug present in the T2 sheet in the latest version (.7). Not sure if its already lurking there since the dawn of time, anyway. You can reproduce it by trying to built two Mackinaws with ME -4 and Production Efficiency V. You will notice odd numbers of needed components when there should be actually only even numbers when trying to produce something x2.
For instance the numbers for 1 item should be like:
90 90 113 150 188 188 188 12
Now if you double the "to be built" Macks to two, you end up with these numbers:
180 180 225 300 375 375 375 24
|
 Natascha Schwarz |
Posted - 2009.04.08 14:18:00 - [ 310]
Edited by: Natascha Schwarz on 08/04/2009 14:18:26Jump 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)  |
 Jake Dykes Deutsche Minen und Werke Guardian Federation |
Posted - 2009.04.08 14:28:00 - [ 311]
As you have protected most of the sheets with a password I have to ask you to give some of the Columns a bit more space, or else the numbers of some columns only gets displayed in ######## or you have to shrink to sheet to something like 70% of the original size so the numbers can be seen.
S on Jump Freighter C on T1 Production
I stumbled over so far. Would be nice if you gave them a little more space in the next version.
Thank you.
|
 DaemonExodus Sleeper Industries |
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.
|
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2009.04.09 17:28:00 - [ 313]
Thanks a lot guys for your feedback I will try to correct the things you ask for, like the length of the columns.
About the t2 production. Its a rounding issue, before it was better to build multiple items at one time because the rounding was done on the whole lot, that is why you see a difference in building 1 and 2, because if a number ends on 1,5 it will be rounded to 2 but if you build 2 items at one time its 1,5*2 therefore the result becomes 3 and not 4. In your case 113 does not become 226 but 225. Isnt it like this anymore? Have you checked what you actually use for building 2 in game?
I will try to upload a new version as soon as possible.
Thanks
|
 wakalaka Information And Entropy |
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. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2009.04.16 13:26:00 - [ 315]
new Version 11,0
Now with my very first T3 production sheet, its still a bit basic, but it gives a good idea of the build price of the new cruisers. Since i havent build any T3 cruiser yet, then im not sure if its 100% correct. |
 Mikal Bishop Gallente Iron Anvil Industries Violent Entity |
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?
|
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2009.04.17 08:38:00 - [ 317]
Originally by: Mikal Bishop 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?
Unfortunately i do not have a complete list of Tech2 blueprints. Therefore you will have to enter the type of material needed and the amount of material manually. When doing so, it is important NOT to use the amount that the in game BluePrint shows, but find the item in the database to get the base material amount. Other vice then ME calculation will be wrong. EVE-onlines item database was changed recently, and since then its not really useful for this type of information, So I suggest you use www.battleclinic.com, here is the link to the blueprint database. |
 Black Friar |
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. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2009.04.19 08:39:00 - [ 319]
I Think its something with your sheet, try to download it again. I dont see anything wrong with the prices. |
 Erestas Drake |
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. |
 ArtomN |
Posted - 2009.04.21 11:38:00 - [ 321]
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 |
 Dariah Stardweller Gallente NO U111 Enterprises |
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.  |
 Black Friar |
Posted - 2009.04.21 19:23:00 - [ 323]
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 |
 phantom ghost |
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 |
 HirschG Rule of Five Split Infinity. |
Posted - 2009.04.24 14:00:00 - [ 325]
I have a problem importing my skills.....i enter api and user and nothing happenes when i press update. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
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. |
 Commander Phoenix Deep Core Mining Inc. |
Posted - 2009.04.25 14:51:00 - [ 327]
Originally by: Commander Phoenix Hi.
Great sheet. I want to explore it, but am having a problem importing my API data.
When I enter my details, API and username, everything is fine. When I select my character and click update it seems to crash my Excel 2007. I can still change data and select worksheet tabs but all other Excel functions are frozen. I can't save, change Excel tabs (view, etc) click the office button. I can't even resize Excel.
Anybody else have problems like that? I run Vista 32bit with Office 2007
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. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
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 herehere 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 hereWhen 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> |
 Commander Phoenix Deep Core Mining Inc. |
Posted - 2009.04.25 21:00:00 - [ 329]
I just found out before coming back here that Evemon doesn't work with that character any more either. Although for this character Evemon works fine. Will have to look into it some more later.
Thanks for looking into my problem :) |
 Drexciyian The Water Margin Tech |
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 |