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

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..

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

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

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.

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.

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%

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.

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

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.

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 :)

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?

Posted - 2010.07.13 06:02:00 - [625]

 

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

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...

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

 

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