Pages: 1 2 3 4 5 6 7 8 9 10 [11] 12 13 14 15 16 17 18 19 20 .. 28 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
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 Arcane Alliance
|
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 ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Knossos
Gallente Occam's Razor Combine
|
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 :) - These words are my own, and are not affiliated with any corporation, alliance or any other organisation |
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
|
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 Arcane Alliance
|
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 ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
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. "Owning a dog teaches a child Honesty, Loyalty, and to always circle three times before lying down".....Mark Twain |
Dedaf
Gallente United Brothers Of Eve
|
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. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
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
--- While waiting for the world to be perfect is an option, it might be wise to adapt to the way things are.
|
Natascha Schwarz
|
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)
|
|
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.
--- While waiting for the world to be perfect is an option, it might be wise to adapt to the way things are.
|
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 Exxxotic
|
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
------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
wakalaka
|
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 Exxxotic
|
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. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Mikal Bishop
|
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 Exxxotic
|
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. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
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 Exxxotic
|
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. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
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
|
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
Mindstar Technology Executive Outcomes
|
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. -------------
Matari ships ARE the real deal |
Dedaf
Gallente United Brothers Of Eve Exxxotic
|
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.
------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Commander Phoenix
Orchestrated Violence
|
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.
---------------------------- -It's a big rock. Can't wait to tell my friends. They don't have a rock this big. |
Dedaf
Gallente United Brothers Of Eve Exxxotic
|
Posted - 2009.04.25 19:38:00 -
[328]
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 test, and yes i see your problem though my excel dont crash, it just dont import the skills. I will see if i can find some way to get around this problem. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Commander Phoenix
Orchestrated Violence
|
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 :) ---------------------------- -It's a big rock. Can't wait to tell my friends. They don't have a rock this big. |
Drexciyian
The Water Margin
|
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
|
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 9 10 [11] 12 13 14 15 16 17 18 19 20 .. 28 :: one page |
First page | Previous page | Next page | Last page |