open All Channels
seplocked Science and Industry
blankseplocked Dedaf's industrial tool
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : ... 17 18 19 20 [21] 22 23 24 25 ... : last (28)

Author Topic

Malo Richards
Posted - 2010.05.07 16:06:00 - [601]
 

Hi Dedaf.

Amazing piece of work. I dont know if it has been asked, anychance you could include Drug/Booster manufacturing in the next undate.

Thanks for all your hardwork.

Cheers

MR

Akino Yakasuki
Posted - 2010.05.17 06:01:00 - [602]
 

Edited by: Akino Yakasuki on 17/05/2010 06:18:36
Edited by: Akino Yakasuki on 17/05/2010 06:17:24
I'm having an issue where I'm entering stock minerals into either the Capital ship tab or the T1 Production tab.

When using the Ore tab to calculate required ore to mine and importing from the Tech 1 or Capital sheets, it seems to be doing the subtraction for Mexallon backwards. If, on the Ore sheet, I put in the same number as the 'In Stock' that is imported into the 'Enter needed Materials' field, the calculation works fine.

After some tweaking I found that it is subtracting the 'In Stock' field from the 'Missing' field for Mexallon on the ore tab for the ensuing calculations.

Also some other things seem odd about that sheet.

I'm using the Amarr and 1.0-0.5 filters.
I know for a fact i cant get Noxcium from Kernite and Veldspar but that is what it is telling me to mine when i'm missing a bunch of stuff.

Reference image:
http://img532.imageshack.us/img532/815/68064324.jpg

Kinda a pain in the rear :D

Great work on the tool!

MyoJin Blood
Gallente
Cryptonym Sleepers
Posted - 2010.05.18 13:42:00 - [603]
 

I dont know if this has been posted before this but i do belive that there is a slight error with the ice mining and mining tab.

on the mining tab there is a option that says refine at pos. Yes or no. If you click yes. it takes it to 100 % with very little skills ore refine rate.

i think that's suppose to be on the ICE mining sheet if not on both.

as with ice refining 1 you get 100% refine rate at a pos. Might want to look in to it a bit more..

Mavi Sakal
Posted - 2010.05.19 08:19:00 - [604]
 

Edited by: Mavi Sakal on 19/05/2010 08:21:12
It is really useful excel sheet , thanks for your effort ,

I just want to mention that I noticed a small calculation problem in Ice Mining Sheet. The P6 and P7 cells shows same price that's why Amarr Ice ISK per hour give us wrong calculation.

Thanks.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.05.21 08:27:00 - [605]
 

Originally by: Malo Richards
Hi Dedaf.
Amazing piece of work. I dont know if it has been asked, anychance you could include Drug/Booster manufacturing in the next undate.
Thanks for all your hardwork.
Cheers
MR
I do not have any plans for building such sheet, because i have never build drugs or boosters myself, so i have no knowledge of this kind of manufacturing

Originally by: Akino Yakasuki

I'm having an issue where I'm entering stock minerals into either the Capital ship tab or the T1 Production tab.
When using the Ore tab to calculate required ore to mine and importing from the Tech 1 or Capital sheets, it seems to be doing the subtraction for Mexallon backwards. If, on the Ore sheet, I put in the same number as the 'In Stock' that is imported into the 'Enter needed Materials' field, the calculation works fine.
After some tweaking I found that it is subtracting the 'In Stock' field from the 'Missing' field for Mexallon on the ore tab for the ensuing calculations.
Also some other things seem odd about that sheet.
I'm using the Amarr and 1.0-0.5 filters.
I know for a fact i cant get Noxcium from Kernite and Veldspar but that is what it is telling me to mine when i'm missing a bunch of stuff.
Reference image:
http://img532.imageshack.us/img532/815/68064324.jpg
Kinda a pain in the rear :D

Great work on the tool!
I see the problem, but i have not been able to really see where it goes wrong. the idea i have is that the "In Stock" minerals are subtracted 2 times, but im not 100% sure yet.
I will try to find a solution to this in the next release.

Originally by: MyoJin Blood
I dont know if this has been posted before this but i do belive that there is a slight error with the ice mining and mining tab.
on the mining tab there is a option that says refine at pos. Yes or no. If you click yes. it takes it to 100 % with very little skills ore refine rate.
i think that's suppose to be on the ICE mining sheet if not on both.
as with ice refining 1 you get 100% refine rate at a pos. Might want to look in to it a bit more..
I will have to look in to this refining issue on the mining tab, but on the Ice mining it should be ok to get 100% because the module refining rate, does not have effect on ice, it is refined at 100% if you have the skill to refine.

Originally by: Mavi Sakal
Edited by: Mavi Sakal on 19/05/2010 08:21:12
It is really useful excel sheet , thanks for your effort ,
I just want to mention that I noticed a small calculation problem in Ice Mining Sheet. The P6 and P7 cells shows same price that's why Amarr Ice ISK per hour give us wrong calculation.
Thanks.
I do not see this same behavior? are you sure you have the latest version?



Thanks to all of you for your feedback to help making the sheet better.
Dedaf

L'Alchimiste
Caldari
Flight Dynamics
Omega arma
Posted - 2010.05.21 13:16:00 - [606]
 

Edited by: L''Alchimiste on 21/05/2010 13:20:41
Edited by: L''Alchimiste on 21/05/2010 13:18:06
Hi Dedaf, thanks for the great tool, you're the best.

There seems to be an issue with some T2 BPCs, here's an example.

http://img130.imageshack.us/i/errorsu.png/

I have no idea why only these values are off, I'm I doing something wrong?


Mesanis
Gallente
Shadow-Tech Industries
Posted - 2010.05.21 15:27:00 - [607]
 

Edited by: Mesanis on 21/05/2010 17:48:08

hi,

1. awesome spreadsheet!

2. is it possible to add to different accounts to the speadsheet?
cause when i pass my api-key it overwrites the pop-down menu and i haven't found an option to edit it manually.

3. when i try to calculate gas cloud harvester t2, i get the msg "Laser Focus Crystals" -> BluePrint not found
and the materials for ME -4 for the gas cloud harvester are not calculating correct.

4. maybe another bug...before i found your spreadsheet i had build my own for t3 ships.
all calculations the same for a hull+subsystems except scandium metallofullerene...
yours ist showing 74 units and mine 110 and i never had any left after building :)

thx

Reabank Darkfly
Posted - 2010.05.22 21:57:00 - [608]
 

Edited by: Reabank Darkfly on 23/05/2010 07:59:49
I have encountered the Ore Calculator problem as well, but also for the other mins. Worked just fine at first but as I gathered some of the needed mins it started acting up like that. Seems like it adds the difference between Missing and In Stock to the Missing amount. Something like "Need to buy/mine" = "Missing" + "Missing" - "In Stock". Having the sheet protection password could help in figuring it out. :P Could be as simple as a missing bracket.
Anyway, maybe one more screenie of the error helps.
Linkage

Edit: Setting the dropdown menu to "No Import" makes the sheet behave normally again. Good workaround for now. Was using import from Capital sheet before.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.05.26 14:27:00 - [609]
 

Originally by: L'Alchimiste

Hi Dedaf, thanks for the great tool, you're the best.
There seems to be an issue with some T2 BPCs, here's an example.
http://img130.imageshack.us/i/errorsu.png/
I have no idea why only these values are off, I'm I doing something wrong?

I can see the problem, and i also know the reason, its just it makes no sence. first of all, you are not doing anything wrong.
The reason for this problem is that the ME does not seem to have any effect on the T2 components "In game" like the Pulse shield emitter in your case. Why its like this i do not know. if you look at the Trit, and other minerals, then they show the same value as ingame no matter which ME level but the T2 components needed are uneffected by the ME In game.
So i have to look in to this some more, to see it its a general trend that eve dont effect ME level to t2 item BP. Bug in eve?!? (I know it sounds strange that i blame EVE, but where is the logic in eve not applying the ME level to all material neede for a T2 BP.)


Originally by: Mesanis
hi,
1. awesome spreadsheet!

2. is it possible to add to different accounts to the speadsheet?
cause when i pass my api-key it overwrites the pop-down menu and i haven't found an option to edit it manually.

3. when i try to calculate gas cloud harvester t2, i get the msg "Laser Focus Crystals" -> BluePrint not found
and the materials for ME -4 for the gas cloud harvester are not calculating correct.

4. maybe another bug...before i found your spreadsheet i had build my own for t3 ships.
all calculations the same for a hull+subsystems except scandium metallofullerene...
yours ist showing 74 units and mine 110 and i never had any left after building :)
thx
1. thank you very much

2. what you need to do is to acctivate that specific cell and then paste you api key, for some reason the Copy/Paste function also apply the format from the web page, but you awoid that by activating the cell before pasting.

3. You get that because to calculate the correct material amount then the tool also need to know the ME of the Component blueprint. So you need to add them in the drop down menu from cell row E114 and down.

4. Correct, i have corrected it in this new release 12,5,3.

Originally by: Reabank Darkfly

I have encountered the Ore Calculator problem as well, but also for the other mins. Worked just fine at first but as I gathered some of the needed mins it started acting up like that. Seems like it adds the difference between Missing and In Stock to the Missing amount. Something like "Need to buy/mine" = "Missing" + "Missing" - "In Stock". Having the sheet protection password could help in figuring it out. :P Could be as simple as a missing bracket.
Anyway, maybe one more screenie of the error helps.
Linkage

Edit: Setting the dropdown menu to "No Import" makes the sheet behave normally again. Good workaround for now. Was using import from Capital sheet before.
Thank you for helping in this matter aswell, i have now located the bug and corrected it in the new release 12,5,3. It should be working as intended in this release.

Thanks to everyone for helping making this tool better. The new Release 12.5.3 is ready to download now.

Thee Macgyver
Posted - 2010.05.27 18:01:00 - [610]
 

I'm having a little trouble opening the latest version( I had version 11,4,3a)Excel 2003 Professional fails to convert the xlsm file to xls i've downloaded the Compatibility pack and installed. But still no luck.

Tammy Tentoes
My Lil Corpy
Posted - 2010.05.28 20:20:00 - [611]
 

I am having an issue with T2 mining crystal BPO calculations. It doesn't seen to want to include the T1 crystal that is needed in the calculations.

Silver Bacardi
Posted - 2010.05.29 00:16:00 - [612]
 

12,5,3 is a nice update but I think you forgot to change the bonus on the Rorqual for gang members. It is now 10% per lvl and not 5%

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.05.29 10:52:00 - [613]
 

Originally by: Thee Macgyver
I'm having a little trouble opening the latest version( I had version 11,4,3a)Excel 2003 Professional fails to convert the xlsm file to xls i've downloaded the Compatibility pack and installed. But still no luck.


I have tried to convert the sheet on 2 different pc with office 2003, but i do not see a problem with converting the file.
I do however see another problem, and that is that office 2003 do not support some of the formulas because they are too long mostly related to T2-Items and JF sheet. i might look in to fixing this at some point, but it do not have very high attention for the time beeing, sry.

Originally by: Tammy Tentoes
1. I am having an issue with T2 mining crystal BPO calculations. It doesn't seen to want to include the T1 crystal that is needed in the calculations.
2. 12,5,3 is a nice update but I think you forgot to change the bonus on the Rorqual for gang members. It is now 10% per lvl and not 5%

1. I see the problem and i have corrected it, i will upload a new release within the next day or 2.
2. Thank you for bringing that to my attention, i didnt know the bonus was changed from 5 to 10%

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.05.31 17:26:00 - [614]
 

New version 12,5,6
To fix the T2 mining crystal and Rorqual bonus, Enjoy.

Sapegu
Gallente
the muppets
RED.OverLord
Posted - 2010.06.02 11:34:00 - [615]
 

Hi there Dedaf,
Your sheet is just great, but it seams that in your last update capital ships dont seam to work.
I only get final price equal to BPO price.
Thanx again for your good work.
You can convo me in game, if you need help.

Domin Mitauchi
NOMAD.
Warped Aggression
Posted - 2010.06.14 12:32:00 - [616]
 

Awesome tool you have created!!! I was wondering if there any plans to create a sheet for the PI recently released? Specifically with inputs for creating the different POSes and their various modules. I have started one of my own, but really don't have the time (or excel skills for that matter) to make a good one that would reflect P0 - P4 material requirements from PI, the regular mineral need and then sync live pricing info from eve central as you have with the other sheets. Such a sheet would allow players to determine build costs using any level of PI materials. I.E. would it save more isk to purchase P1 - P4 materials then continue the refinement process in order to generate the most cost effective build. Again you have done such great work with the other tools I would love to see your version of something like this.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.06.14 16:00:00 - [617]
 

Originally by: Sapegu
Hi there Dedaf,
Your sheet is just great, but it seams that in your last update capital ships dont seam to work.
I only get final price equal to BPO price.
Thanx again for your good work.
You can convo me in game, if you need help.

Hi Sapegu
I do not see the problem you are mentioning, and im not able to contact you ingame either, seems like im blocked to do so.

Originally by: Domin Mitauchi
Awesome tool you have created!!! I was wondering if there any plans to create a sheet for the PI recently released? Specifically with inputs for creating the different POSes and their various modules. I have started one of my own, but really don't have the time (or excel skills for that matter) to make a good one that would reflect P0 - P4 material requirements from PI, the regular mineral need and then sync live pricing info from eve central as you have with the other sheets. Such a sheet would allow players to determine build costs using any level of PI materials. I.E. would it save more isk to purchase P1 - P4 materials then continue the refinement process in order to generate the most cost effective build. Again you have done such great work with the other tools I would love to see your version of something like this.

Thanks for the nice words. Yes infact i have build it already, but its pretty complex so i want to make sure it is working correct first, before i release it, just so you or anyone else dont lose alot of isk because of some silly bug.
But i am working on a PI sheet, and its almost ready to be released, so stay tuned Smile

keiber
Posted - 2010.06.15 18:20:00 - [618]
 

OK I am having an issue, every single page is working correctly except the t1 production page, it doesnt show the build cost for any thing, every other page works fine just the t1 one wont show build costs, please help me.

Montka Huot
Posted - 2010.06.30 19:38:00 - [619]
 

Sorry if I'm a dolt, but have 2003 pro, even got the compatibility pack just in case, but every time I try to update prices or even add a character I get a XML parse error.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.07.03 09:11:00 - [620]
 

Originally by: keiber
OK I am having an issue, every single page is working correctly except the t1 production page, it doesnt show the build cost for any thing, every other page works fine just the t1 one wont show build costs, please help me.

Im sorry, i have tried to look in to this, but i do not see this error, i think best option is to download it again, maybe something is curropt in your file.

Originally by: Montka Huot
Sorry if I'm a dolt, but have 2003 pro, even got the compatibility pack just in case, but every time I try to update prices or even add a character I get a XML parse error.

It seems that not all office version are able to use the compability pack, i have tried on 3 different pc's using 2003 and i never seen a problem with opening the file.


I have just uploaded a new version 12.6
This version contains the first version the the Planet interaction tool.



Larannda Firestorm
Posted - 2010.07.07 21:54:00 - [621]
 

Originally by: Montka Huot
Sorry if I'm a dolt, but have 2003 pro, even got the compatibility pack just in case, but every time I try to update prices or even add a character I get a XML parse error.


I was getting the XML parse error as well.

I then realised I didnt have my proxy set in my Internet settings. Once I set the proxy, boom, no more parse errors :)

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.07.11 16:47:00 - [622]
 

thanks alot for that information, im sure that will help alot of people who have problems with importing price information.

Red Teufel
Blackened Skies
Posted - 2010.07.12 16:32:00 - [623]
 

when I'm using the t2 items not ships, does it only calculate that i am reacting my own moon goo or just to build my own components?

keiber
Posted - 2010.07.12 23:39:00 - [624]
 

Originally by: Dedaf
Originally by: keiber
OK I am having an issue, every single page is working correctly except the t1 production page, it doesnt show the build cost for any thing, every other page works fine just the t1 one wont show build costs, please help me.

Im sorry, i have tried to look in to this, but i do not see this error, i think best option is to download it again, maybe something is curropt in your file.

Originally by: Montka Huot
Sorry if I'm a dolt, but have 2003 pro, even got the compatibility pack just in case, but every time I try to update prices or even add a character I get a XML parse error.

It seems that not all office version are able to use the compability pack, i have tried on 3 different pc's using 2003 and i never seen a problem with opening the file.


I have just uploaded a new version 12.6
This version contains the first version the the Planet interaction tool.





Ok well I have downloaded it 4 times and still getting the same error every time, every thing else in it works totally fine, except the t1 doesnt show build cost

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.07.13 06:02:00 - [625]
 

That is very strange. Contact me ingame and let us see what we can find.

Knug LiDi
N00bFleeT
Posted - 2010.07.20 20:35:00 - [626]
 

Dedaf: For 12.6b

I believe I have found a bug with PI calculation sheet:

Under Refined Commodities, if synthetic oil is requested, it only shows needing Electrolytes instead of two P1 commodities

Also,

If superconductors are needed, it calculates requirements for Oxygen, Plasmoids and Water, instead of just two P1 commodities.

I hadn't noticed this before, because most of my calc's required both synthetic oil and superconductors, so the total quantities worked out. when I changed to different P4, the quantities didn't match paper calculation.

Thanks, Knug




Tau Bargoth
Posted - 2010.07.20 21:35:00 - [627]
 

I really wish there was a way you could make this work for Open Office. I understand it may be a great undertaking, but Open Office is very widely used...

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.07.24 12:41:00 - [628]
 

Originally by: Knug LiDi
Dedaf: For 12.6b
I believe I have found a bug with PI calculation sheet:
Under Refined Commodities, if synthetic oil is requested, it only shows needing Electrolytes instead of two P1 commodities

Also,

If superconductors are needed, it calculates requirements for Oxygen, Plasmoids and Water, instead of just two P1 commodities.
I hadn't noticed this before, because most of my calc's required both synthetic oil and superconductors, so the total quantities worked out. when I changed to different P4, the quantities didn't match paper calculation.

Thanks, Knug


Very well spottet Knug, i have corrected it in this new version that i just uploaded, it also contains a restore option, so you dont have to reenter allyou PI material.

Originally by: Tau Bargoth
I really wish there was a way you could make this work for Open Office. I understand it may be a great undertaking, but Open Office is very widely used...

I would love to be able to make it work for OpenOffice, but OO simply does not support direct XML import, so i cant do anything about it sry.

New version is up: Version 12,6,2

Steila
Posted - 2010.08.02 14:56:00 - [629]
 

Edited by: Steila on 02/08/2010 15:00:33
Hi Dedaf , nice job !

Asmirrious
Posted - 2010.08.02 16:32:00 - [630]
 

Amazing bit of work! Thanks for taking the time to put this togehter.


Pages: first : previous : ... 17 18 19 20 [21] 22 23 24 25 ... : last (28)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only