Author |
Topic |
 Fractalon |
Posted - 2010.09.14 22:10:00 - [ 661]
On the T2 items sheet it looks like the materials required for producing the prototype cloaking device are wrong. There are only 7 minerals listed when actually 8 are required and it doesnt list the T2 component, PI component or R.A.M required to create it. It is only the T1 item so it may have just been missed or changed. Thanks. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2010.09.17 12:39:00 - [ 662]
Originally by: hankey Dedaf, Nice compilation of tools!
Can you add there POS Modules Production?
You will find all the POS modules in the Planet Interaction sheet. Just scroll down a bit. Originally by: Fractalon On the T2 items sheet it looks like the materials required for producing the prototype cloaking device are wrong. There are only 7 minerals listed when actually 8 are required and it doesnt list the T2 component, PI component or R.A.M required to create it. It is only the T1 item so it may have just been missed or changed. Thanks.
I see the problem. But its a matter of 5 items, who need a special T1-item. I do not want to change the entire sheet to fit those 5 items. I have however added a warning text, which will show when one of those 5 items has been selected. This will let the user know not to trust the build price when building one of those 5 items. The effected items are cloaking devices and t2 bubbles. |
 Tron X16 |
Posted - 2010.09.17 18:41:00 - [ 663]
This is a nice spreadsheet but I was looking for something to help tell me what modules are cost effective to reprocess.
I didnt see it on here is there a way this program can do it or someone point me to a simular reprocessing tool. |
 Fashby Caldari |
Posted - 2010.09.22 07:12:00 - [ 664]
Edited by: Fashby on 22/09/2010 07:12:45 I have Microsoft Office 2010, is there no way to have the spreadsheet automatically update prices on the Data tab?
Even when I switch regions and update everything, the prices stay the same. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2010.09.22 08:41:00 - [ 665]
Originally by: Fashby Edited by: Fashby on 22/09/2010 07:12:45 I have Microsoft Office 2010, is there no way to have the spreadsheet automatically update prices on the Data tab?
Even when I switch regions and update everything, the prices stay the same.
Yes ofcause. Im using Office2010 myself and it works fine. You could have multiple problems. 1.You macro security is too high. 2.You do not have Office2010Pro/ultimate. In the eaarlyer versions of Office, only the Pro versions supported direct xml import, im not sur eif that goes for 2010 too. |
 Sakari Yuuki |
Posted - 2010.09.22 14:47:00 - [ 666]
Originally by: Dedaf
Originally by: Fashby Edited by: Fashby on 22/09/2010 07:12:45 I have Microsoft Office 2010, is there no way to have the spreadsheet automatically update prices on the Data tab?
Even when I switch regions and update everything, the prices stay the same.
Yes ofcause. Im using Office2010 myself and it works fine. You could have multiple problems. 1.You macro security is too high. 2.You do not have Office2010Pro/ultimate. In the eaarlyer versions of Office, only the Pro versions supported direct xml import, im not sur eif that goes for 2010 too.
I have Microsoft Office 2010 Student. I have all macros enabled currently. Will I never be able to have prices adjust with this setup? On the Mining tab, it only takes prices from the data that gets automatically uploaded, and for most everything else but t1 production, effectively making the most of spreadsheet nice to look at, but not actually applicable in my manufacturing and mining ventures. |
 Szabo Valtery |
Posted - 2010.09.22 20:26:00 - [ 667]
Hey Dedaf,
great work..
thx |
 Caius LiviusCerso Caldari Deep Core Mining Inc.
|
Posted - 2010.10.03 10:09:00 - [ 668]
errors in POS module BPO databaase. Moon arrays show wrong P4 construction part numbers.(like only 1 Broadcast node as opposed to 4 ) etc.
otherwise, great work.
|
 Quinnea Caldari Australian Mining and industry Corp Intergalactic Exports Group |
Posted - 2010.10.05 13:50:00 - [ 669]
Great tool!
One feature request... it would have a small footprint and be of value to a lot of folks..
Somewhere in the T1 production tab, set up a a "realistic" perfect ME.. one that would drop it below 1% waste, but not have people going nuts researching ME higher than they need to. This would provide a quick reference to see that you are researched when planning a job.
For example, this particuar BP (Fusion L Projectile) drops to 2.5% @ ME3, .91% @ ME10, and 0.5% waste at ME 19.
Or, on a tangent.. (Albeit an ADD/OCD-caffeine driven complexity level) have a "Research Library" page that lists blueprints with a toggled "Owned" status... and the ability to calculate out the ideal research figures for them.
I would love to get inside your spreadsheet and see how you are accomplishing some of your calculations... It works wonderfully!!
|
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2010.10.08 10:05:00 - [ 670]
Edited by: Dedaf on 08/10/2010 10:06:06 Originally by: Caius LiviusCerso errors in POS module BPO databaase. Moon arrays show wrong P4 construction part numbers.(like only 1 Broadcast node as opposed to 4 ) etc.
otherwise, great work.
I have looked in to this problem, and noted a general error in the tower and station modules. It has now been fixed in this new version i just uploaded. let me know if you still have problems. Originally by: Quinnea Great tool! One feature request... it would have a small footprint and be of value to a lot of folks..
Somewhere in the T1 production tab, set up a a "realistic" perfect ME.. one that would drop it below 1% waste, but not have people going nuts researching ME higher than they need to. This would provide a quick reference to see that you are researched when planning a job.
For example, this particuar BP (Fusion L Projectile) drops to 2.5% @ ME3, .91% @ ME10, and 0.5% waste at ME 19.
Or, on a tangent.. (Albeit an ADD/OCD-caffeine driven complexity level) have a "Research Library" page that lists blueprints with a toggled "Owned" status... and the ability to calculate out the ideal research figures for them.
I would love to get inside your spreadsheet and see how you are accomplishing some of your calculations... It works wonderfully!!
That is not a bad idea. I will see if i can find some way to calculate this and try to implement it in a future release. Thanks again to everyone for your feedback. I have now uploaded a new version with new features and bug fix. Version 12.6.8 |
 Templar Nato Unlawful Combatants |
Posted - 2010.10.13 19:11:00 - [ 671]
Edited by: Templar Nato on 13/10/2010 20:08:55 First and foremost, thank you for the work on this sheet.
I have a question regarding the mineral requirements listed for " R.A.M Starship Tech" at the bottom of the Jump Freighter tab. I had been running version 12,6,6 and noticed that the Isogen requirements were listed 7,407 units. As this doesn't correlate with the 81 units of Isogen listed in game for the construction of the RAM I looked for a way to manually edit the number with no success. I have downloaded the current version (12,6,8) in the hope that this would correct the problem, however the current version shows the same value.
Is there a way to edit these values, or does that require the download of a new update?
Upon further examination it seems that all of the required materials to build the components for a jump freighter as off. For example:
In game says: Crystalline Carbonide Armor Plate Blueprint - 44 Crystalline Carbonide + 11 Sylramic fibers Spreadsheet says: Crystalline Carbonide Armor Plate - 2,200 Crystalline Carbonide + 1,650 Sylramic fibers
Since this was a fresh download I'm assuming I haven't messed the sheet up with my own data. Any help would be greatly appreciated. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2010.10.13 21:41:00 - [ 672]
Hi Templar Nato I agree the minerals needed for the RAM in the JB sheet is off, i have corrected it but i dont have time to upload a new version today, i will do it tomorrow. However i do not agree in the other component Originally by: Templar Nato Upon further examination it seems that all of the required materials to build the components for a jump freighter as off. For example:
In game says: Crystalline Carbonide Armor Plate Blueprint - 44 Crystalline Carbonide + 11 Sylramic fibers Spreadsheet says: Crystalline Carbonide Armor Plate - 2,200 Crystalline Carbonide + 1,650 Sylramic fibers
You are comparing a none capital component BP to a capital BP. since it is a JF you are building, that means you need the capital components. i have checked the material need to be sure and they are correct. Ok my sheet doesnt say capital Crystalline Carbonide Armor Plate, but the material are inline with the capital component blueprint. I hope that clarifies it a bit. I will upload a new version tomorrow with the RAM correction. Dedaf |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2010.10.14 07:17:00 - [ 673]
New version 12,6,8,2 uploaded |
 Templar Nato Unlawful Combatants |
Posted - 2010.10.14 17:41:00 - [ 674]
Thanks for your help. |
 Mr Holdem |
Posted - 2010.10.14 20:00:00 - [ 675]
OK, so I go out and buy Office 2010 pro (Academic version if it matters)
I download this program (Spreadsheet)
I get nothing on screen as far as click boxes (update, restore - They just aren't physically on the screen), the hyperlinks are blue, but not clickable.
I have tried to disable every setting I can find in the trusted menu and am running the spreadsheet from a trusted folder and nada, zero, zilch.
I am windows stupid and only use this machine to play EvE, so please bear with me.
HELP, please :) |
 Mr Holdem |
Posted - 2010.10.14 20:11:00 - [ 676]
Nevermind, I downloaded it onto my Mac, copied it to windows using a USB drive and all is well....
I H8 windows, but thanks for this wonderful looking spreadsheet. |
 Caffiene Overdose |
Posted - 2010.10.20 09:30:00 - [ 677]
Edited by: Caffiene Overdose on 20/10/2010 18:57:36 Edited by: Caffiene Overdose on 20/10/2010 18:57:02 The prices given for most of the T3 materials seem to be off by quite a bit, and the melted nanoribbon price appears to be fixed. |
 Yawina |
Posted - 2010.10.21 22:12:00 - [ 678]
HI, at the Planet Window, the Mineral Requierment from the Construction Parts or much higher as InGame with the same ME Lvl.
Thx
|
 gammatude |
Posted - 2010.10.22 00:10:00 - [ 679]
Originally by: Mr Holdem OK, so I go out and buy Office 2010 pro (Academic version if it matters)
I download this program (Spreadsheet)
I get nothing on screen as far as click boxes (update, restore - They just aren't physically on the screen), the hyperlinks are blue, but not clickable.
I have tried to disable every setting I can find in the trusted menu and am running the spreadsheet from a trusted folder and nada, zero, zilch.
I am windows stupid and only use this machine to play EvE, so please bear with me.
HELP, please :)
I also have 2010 Office Home and Student and get this same error. No grey buttons to press for updating. I have enabled macro's yet that does not seem to work. Other update features seem to be fine like prices and my stats via API. Any workarounds? |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2010.10.22 12:56:00 - [ 680]
Originally by: Caffiene Overdose The prices given for most of the T3 materials seem to be off by quite a bit, and the melted nanoribbon price appears to be fixed.
It would be nice with an exapmle, so i could try to look in to the problem. The melted nanoribbon price works ok for me, for all price types like Buy, Sell & Avg. Originally by: Yawina HI, at the Planet Window, the Mineral Requierment from the Construction Parts or much higher as InGame with the same ME Lvl.
Thx
You are right, the mineral use are of for that module, i have fixed it now and it will be corrected in the next version. Originally by: gammatude I also have 2010 Office Home and Student and get this same error. No grey buttons to press for updating. I have enabled macro's yet that does not seem to work. Other update features seem to be fine like prices and my stats via API. Any workarounds?
Im not sure i understand which buttons it is that are not working if you can update your skills and price information? Can you make a screen dump, that will make it easier for me to see the problem. The problem you quoted was fixed by downloading then sheet again. Thanks to all of you for the feedback |
 Tilly Moon |
Posted - 2010.10.30 17:15:00 - [ 681]
Hi, I found problems with Void M ammo material calculation in T2_Items sheet. 1. For invented bpc with -4 ME, Crystalline Carbonide and Fullerides should be 240 not 160. 2. I see also that Megacyte and Zydrine in "Productions Need" is always calculated for only 1 run. |
 Jebrea |
Posted - 2010.10.31 19:14:00 - [ 682]
Edited by: Jebrea on 31/10/2010 19:31:29 Edited by: Jebrea on 31/10/2010 19:20:41 He Dedaf i was useing a older verison of your industrial spreadsheet. I just downloaded this new on and for some reason all the drop down menus read 0 instead of what they should read. I am using open office, so i know i cant updates my skills using the updater. Not sure whats going on or what. i was using 12,6,2. more trying to make Ammo any help would be nice. when i used the older vers, when i went to build ammo or input it it said e502 |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2010.11.02 16:05:00 - [ 683]
Originally by: Tilly Moon Hi, I found problems with Void M ammo material calculation in T2_Items sheet. 1. For invented bpc with -4 ME, Crystalline Carbonide and Fullerides should be 240 not 160. 2. I see also that Megacyte and Zydrine in "Productions Need" is always calculated for only 1 run.
I will look in to the problem with Crystalline and Fullerides, but i fear that this is a downside to a correction i did not long ago. For some reason, not all moon material needed for t2 items are effected by ME level "In game". I "to this day" do not understand the logic in it. So i thought it was general for all t2 items (other than ships) and corrected my sheet, so ME does not effect the moon material components. i guess in your case this correction is incorrect. So in short, i have no idea how to correct this. since it seems to be random (from CCP) which t2 item does not add ME lvl to moon material need and which ones does. Originally by: Jebrea Edited by: Jebrea on 31/10/2010 19:31:29 Edited by: Jebrea on 31/10/2010 19:20:41 He Dedaf i was useing a older verison of your industrial spreadsheet. I just downloaded this new on and for some reason all the drop down menus read 0 instead of what they should read. I am using open office, so i know i cant updates my skills using the updater. Not sure whats going on or what. i was using 12,6,2. more trying to make Ammo any help would be nice. when i used the older vers, when i went to build ammo or input it it said e502
I dont know what could be the reason for this bug. could you tell me if the version you used before was a .xls or .xlsm file? Thanks Dedaf |
 Tilly Moon |
Posted - 2010.11.03 00:05:00 - [ 684]
Originally by: Dedaf
So in short, i have no idea how to correct this. since it seems to be random (from CCP) which t2 item does not add ME lvl to moon material need and which ones does.
Please look at blueprints database in EVEMon: EVEMon\Resources\eve-blueprints-en-US.xml.gz file. There is wasted="1" or wasted="0" attribute for each blueprint material. I suppose that this attribute is used for proper calculation in EVEMon blueprint browser. I hope these help. Best regards, Tilly Moon |
 Fregateur2 |
Posted - 2010.11.06 23:10:00 - [ 685]
Thank you very much for this tool, I used every day.
I spotted a few errors:
-T2 rigs: Telemetry Processor missing on T2 missile rigs
-Planet: Ballistic Deflection Array is the only Hardener who use Nano Factory , not Organic Mortar. |
 TImeless Wanderer |
Posted - 2010.11.07 16:08:00 - [ 686]
Have been using these sheets for years, but have noticed the following errors on the T3 sheet.
'FulleroFerrocene' and 'PPD Fullerene Fibers' are only showing 1 gas being required instead of 2.
'Lanthanum Metallofullerene' and 'Methanofullerene' are showing 3 gas instead of 2.
|
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2010.11.08 11:12:00 - [ 687]
Thanks Tilly Moon for the info, i will look in to this problem and see if i can find some logic to this problem. Originally by: Fregateur2 Thank you very much for this tool, I used every day.
I spotted a few errors:
-T2 rigs: Telemetry Processor missing on T2 missile rigs
-Planet: Ballistic Deflection Array is the only Hardener who use Nano Factory , not Organic Mortar.
Thank you for the well described bug report, i have corrected the error's in this newly updated version. Originally by: TImeless Wanderer Have been using these sheets for years, but have noticed the following errors on the T3 sheet.
'FulleroFerrocene' and 'PPD Fullerene Fibers' are only showing 1 gas being required instead of 2.
'Lanthanum Metallofullerene' and 'Methanofullerene' are showing 3 gas instead of 2.
very well spotted, i have now corrected the bugs you reported. Thanks again to all of you for the feedback and helping making the sheet better. you can now download the newest version 12.6.9 |
 Jebrea |
Posted - 2010.11.09 01:41:00 - [ 688]
Edited by: Jebrea on 09/11/2010 01:42:42 Dedaf its a .XLSM file is what the New verison and the older one is a .xls |
 Khrysees |
Posted - 2010.11.09 15:03:00 - [ 689]
I have been trying to open ths all morning using winzip and winrar...neither work. both are saying the file is corrupted.
Errors were detected -- see below for details Testing ... Testing Dedaf's industrial tool 12,6,9.xlsm CRC check failed At least one error was detected in C:\Users\Chris\Downloads\Dedafs_industrial_tool_1269.zip.
any insight?
thanks,
|
 Brigge Tremdut |
Posted - 2010.11.10 23:48:00 - [ 690]
Is one able to get this to function with Open Office yet? Honestly, I did not read all 23 pages to find out but since this is a rather long thread in time span, I was hoping that might be true now. |