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 : ... 13 14 15 16 [17] 18 19 20 21 ... : last (28)

Author Topic

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.12.31 15:23:00 - [481]
 

Originally by: caddycarrouf

Thanks Dedaf it was a cool x-mas as always ;)

I'am here again with a nasty bug :p the newest version you posted (11.4.8.1) got again a bug in the rigs component, this time it's for the Small Projection Weapon rigs, 0 smashed trigger unit need to build any of these rigs (should be 4) :)

Thanks again for a fix :)
See you soon Cool


Thanks again, its cause i totally changed the way to build M & S rigs, so i have done some numbers wrong. i didnt bother to go trough them all to check, thanks to you guys for reporting the bugs, that way i can fix them easyer. The correction for this bug will be in next release.

Originally by: millionaire man
Great spreadsheet dedaf!!!
Just one thing tho, your's is the only spreadsheet i use but i cant see if t2 production is worth doing till new t2 construction ratio's are added.
Do we have a ETA on this?
Thx MM

I Do not have an ETA yet sry, i havent had much time this month to work on other than bug fix's

Originally by: Lashesis
Firstly, bloody great spreadsheet man.

Is there a way to manually enter the prices of the rigs and stuff because ide like to find out roughly the exact cost of what im making rather then the average which is usually a bit off

Thanks im glad you like it.
Yes you can use you own price's. On the DATA sheet you can enter them in the blue fields. On each sheet you can then select OWN price, then it will use the price you entered.


Happy New Year everyone

millionaire man
Posted - 2010.01.04 23:29:00 - [482]
 

Me again!

I noticed one thing, not sure if its a bug or just happening with me. When I put the prices in on the own price list on the data page for Liquid Ozone, it doesn't change in the own price list in the ice mining tab. It stays at 255p/u, all the other prices change to what I set them at, in the data page, apart from the LO.

Is this happening with just me or does anyone else have this problem?

Thx MM

master jonbob
Posted - 2010.01.05 02:20:00 - [483]
 

Need some help whenever i set the Bp type to a BPC ie put a number in on the T1 production page i get div/0 error on the build cost i pressume this is cos ive not entered something somewhere,but i dont know where. or is this something with open office?

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.01.05 07:38:00 - [484]
 

Originally by: millionaire man
Me again!

I noticed one thing, not sure if its a bug or just happening with me. When I put the prices in on the own price list on the data page for Liquid Ozone, it doesn't change in the own price list in the ice mining tab. It stays at 255p/u, all the other prices change to what I set them at, in the data page, apart from the LO.

Is this happening with just me or does anyone else have this problem?
Thx MM

Im sorry i dont see the error, i can change the LO price in the DATA sheet and see it change in the Ice mining sheet.

Originally by: master jonbob
Need some help whenever i set the Bp type to a BPC ie put a number in on the T1 production page i get div/0 error on the build cost i pressume this is cos ive not entered something somewhere,but i dont know where. or is this something with open office?

I have tried to set my original BP to coppies, by setting number of runs to 1 or more, but i dont see your error.
Only if i set number of runs to 0 then i get div/0, but you cant have a BPc with 0 runs anyway. Remember the number of runs is the number the BPC had when you bought it.
If you do it like this and still have the error, then it might very well be OpenOffice that misscalculate.

I hope you solve your problems
Dedaf

LilRemmy
Posted - 2010.01.07 05:05:00 - [485]
 

Best Eve tool/spreadsheet I have ever seen. Are you planning on releasing a Dominion version? So used to using your spreadsheet, that I don't even want to bother building T2 without it. Sorry in advance if this question has already been answered.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.01.07 21:24:00 - [486]
 

Edited by: Dedaf on 07/01/2010 21:24:06
Hi
yes i get the question a lot Smile but its ok to ask.
I think I can say with 90% certainty, that I will have a public release, which is up to date with Dominion T2 ship production, within the next 2weeks
So not much more waiting guys, sorry to keep you waiting.

Simp Leton
Posted - 2010.01.08 14:22:00 - [487]
 

I hope I didn't miss it but I tried skimming through most of the 17 pages but did not see my exact problem or possible non-problem.

I downloaded the spreadsheet and opened it. When I opened it, I got an error that went something like this "Some formatting had to be changed in order to not corrupt the workbook. Please check your formatting carefully". I am using Office 2007, macro's are ok, and am not sure if I am only one that had this problem.

Completely amazing spreadsheet by the way :) Just not sure if any of this formatting that was changed will be a hindrance on it. It seems to work ok but I have not extensively used it yet.

Thanks for any help!

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

Hi everyone

The T2 Production sheet is now up to date with DOMINION i know alot of you have waited for this, so enjoy.Very Happy


IdeaA bit of warning though, since i have not used it for very long myself, then please do yourself the favor of cross checking you T2 BluePrint with the ingame Blueprint, to make sure the material are right, before you go shopping for millions of isk.Idea

Fearr Dorchaa
Posted - 2010.01.09 16:53:00 - [489]
 

Edited by: Fearr Dorchaa on 09/01/2010 16:58:51
epic work sir

best program by a mile

many thanks

edit: i know its cheeky to ask but any news on a t2 module sheet?
edit 2: wow... i knew t2 ship cost to make/sale prices were out of whack but yikes !!

millionaire man
Posted - 2010.01.09 18:28:00 - [490]
 

you've made me very happy, thx man a great spreadsheet Laughing

ISuckForIsk
Posted - 2010.01.10 00:46:00 - [491]
 

Thanks for the update to Dominion!
A question, are you planning to expand this to include T2 modules/Drones/Ammo (any T2 stuff) in the future?

Epae Woewig
Caldari
The Green Machine
Posted - 2010.01.10 11:41:00 - [492]
 

Thanks again for a great tool!
I've checked a few things regarding T2 ship production since the update to 12, and i noticed a few inconsistencies.
I think that the T2 components and ME levels are not entirely correct.
I've researched my bpo's to the 'perfect' ME level as to where they no longer gain any improvements over more research. When applying these ME levels to your spreadsheet, i get a higher material requirement than actual.

I looked into the details.
Example being the Fernite Carbide Composite Armor blueprint.
At ME level 8, it has a 1.11% waste factor, which equals out to:
Fernite Carbide - [You: 46 - Perfect: 40]
Sylramic Fibers - [You: 12 - Perfect: 10]
(Actual ingame)

Your spreadsheet however tells me that with ME 8 i need:
Fernite Carbide - 47
Sylramic Fibers - 35 (?!)

This is tested on a char with Production efficiency 2. Same char that examined the ingame blueprint is used via API in your spreadsheet.

It seems to be the same all over the line for many of the T2 components.
The few T2 ships i checked also had inconsistencies.

I don't know how you've done the import and all that but the numbers are not correct.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.01.10 12:30:00 - [493]
 

hmm yea i see the problem, i thought only ship component amount changed :S
but also the component material need was changed. So that puts me back some days again.
Do not trust the t2 material need in release 12 an 12,1, sry about this.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.01.10 13:21:00 - [494]
 

ok that didnt take too long to change it seems Smile

i just uploaded version 12,2 and it should have the right material amount now.

caddycarrouf
Posted - 2010.01.10 16:46:00 - [495]
 

Hi dedaf,

I've noticed something wrong with the small tractor beam it seems that the material bill changed since dominion

Sheet numbers ME 0

Iso : 2750
Meg : 44
Mexa : 9900
Nox : 385
Pye : 27500
Trit : 110000
Zyd : 22

Bpo numbers ME 0

Iso : 2750
Meg : 44
Mexa : 9900
Nox : 385
Pye : 12100
Trit : 27500
Zyd : 81

So it seems CCP reduced trit & pye requirements and augmented zydrine's, maybe you haven't made a database import for T1 since dominion ?

Thanks in advance for any fix ;)

Epae Woewig
Caldari
The Green Machine
Posted - 2010.01.10 16:52:00 - [496]
 

Edited by: Epae Woewig on 10/01/2010 16:54:19
Edited by: Epae Woewig on 10/01/2010 16:52:27
Originally by: Dedaf
ok that didnt take too long to change it seems Smile

i just uploaded version 12,2 and it should have the right material amount now.


I'm afraid they're still a bit off. Closer... but still not correct.
Using previous example, the amount of fernite carbide is still incorrect. it's 1 higher in your tool for the example than the actual ingame is (Tool v 12,2: 47.... ingame: 46). I assume it's got to do with the roundings, because if i increase to ME9 in your tool, i get the correct value for the Fernite carbide.

Same goes for ship BPC's.
Using a Hound with -4 ME, ingame (Production efficiency 2) needs 330 fernite carbide composite armor plates.
Your tool says: 345 needed for ME -4.

Same goes for the rest of the materials.

I'm afraid that the data is still incorrect and not the actual values, this counts for both T2 components and T2 ships.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.01.11 11:51:00 - [497]
 

Originally by: Epae Woewig

I'm afraid they're still a bit off. Closer... but still not correct.
Using previous example, the amount of fernite carbide is still incorrect. it's 1 higher in your tool for the example than the actual ingame is (Tool v 12,2: 47.... ingame: 46). I assume it's got to do with the roundings, because if i increase to ME9 in your tool, i get the correct value for the Fernite carbide.

Same goes for ship BPC's.
Using a Hound with -4 ME, ingame (Production efficiency 2) needs 330 fernite carbide composite armor plates.
Your tool says: 345 needed for ME -4.

Same goes for the rest of the materials.

I'm afraid that the data is still incorrect and not the actual values, this counts for both T2 components and T2 ships.

Iím amazed this problem has not been reported before or maybe it has.
But thanks to your very well described bug report I have found the bug.
It turns out I have a miss calculation in material need if your production eff. Skill is lower than lvl5, I havenít seen this bug since I have lvl5.
Problem is that this bug or way of calculating material need, is the same in all of the production sheets, meaning if you have production eff. <5, then you will have a wrong material need. To solve this I will have to go trough a lot of fields to correct the calculations.
I have just started doing it now and will upload a new release as soon as Iím done.
Thanks for helping making the tool better.

Epae Woewig
Caldari
The Green Machine
Posted - 2010.01.11 17:41:00 - [498]
 

Originally by: Dedaf
Originally by: Epae Woewig

I'm afraid they're still a bit off. Closer... but still not correct.
Using previous example, the amount of fernite carbide is still incorrect. it's 1 higher in your tool for the example than the actual ingame is (Tool v 12,2: 47.... ingame: 46). I assume it's got to do with the roundings, because if i increase to ME9 in your tool, i get the correct value for the Fernite carbide.

Same goes for ship BPC's.
Using a Hound with -4 ME, ingame (Production efficiency 2) needs 330 fernite carbide composite armor plates.
Your tool says: 345 needed for ME -4.

Same goes for the rest of the materials.

I'm afraid that the data is still incorrect and not the actual values, this counts for both T2 components and T2 ships.

Iím amazed this problem has not been reported before or maybe it has.
But thanks to your very well described bug report I have found the bug.
It turns out I have a miss calculation in material need if your production eff. Skill is lower than lvl5, I havenít seen this bug since I have lvl5.
Problem is that this bug or way of calculating material need, is the same in all of the production sheets, meaning if you have production eff. <5, then you will have a wrong material need. To solve this I will have to go trough a lot of fields to correct the calculations.
I have just started doing it now and will upload a new release as soon as Iím done.
Thanks for helping making the tool better.


Glad i could help. I use your tool so the least i can do is report bugs in a way that will make the maker of it able to find and recreate the error. Makes easier bugfixing :)
But thanks for your continued development of this tool!

Any news on if we might see a T2 module part one day? :)

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.01.11 20:49:00 - [499]
 

third time's the Charm: Version 12,3

This version have the correct calculation of material and mineral need in all the production sheets, enjoy. Very Happy

About the t2 Item sheet, then I have not been able to get a full t2 item list that contains all needed material.
When I sort through the dump file, then I only get minerals and t2 components, all the special items like robotics and RAM components are missing, or at least I have not been able to find them, in a way that I could link them to the correct t2 items.
Therefore I cannot say when or if I will ever have a t2 item production sheet Crying or Very sad
But if someone can supply me this kind of list (excel), then id be happy to make a tool like the other sheets in this file.

I hope this version will solve most of the major problems.

thanks everyone for giving your feedback
Dedaf

Distant Sentry
Posted - 2010.01.12 00:22:00 - [500]
 

Dedaf, this sheet is awsome. If I ever learn to make money in this game, I'll have to send you some serious isk.

I've found one minor error. The kronos and golem have there base t1 ships swaped in the t2 build menu. Golem shows a megathron, and kronos shows a raven as the required t1 ship.

Again, thanks. Very Happy

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.01.12 06:10:00 - [501]
 

Originally by: Distant Sentry
Dedaf, this sheet is awsome. If I ever learn to make money in this game, I'll have to send you some serious isk.
I've found one minor error. The kronos and golem have there base t1 ships swaped in the t2 build menu. Golem shows a megathron, and kronos shows a raven as the required t1 ship.
Again, thanks. Very Happy

thanks alot, i hope you do make some isk Very Happy
here is a quick fix version 12,3a

caddycarrouf
Posted - 2010.01.13 01:32:00 - [502]
 

Hi Dedaf,

Another lil' bug :)

In the Legion Subsystems (T3 sheet)

Dissolution Sequencer is here in double & Interdiction Nullifier is missing

Thanks for the fix, Cu around :)


Joe SMASH
You Got A Purty Mouth
Posted - 2010.01.14 21:14:00 - [503]
 

Friendly bump, and great spreadsheet. I use it for my cap production and to pay out my mining fleet.

WillieWortel
Posted - 2010.01.15 08:45:00 - [504]
 

Hi Dedaf,

I downloaded 12.3a and tried to use 6 x Modulated Deep Core II, but only 0 or 1 is selectable (i'm using a BC).

The sheet is amazing by the way, very impressive.

Regards,

Darthyeren

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.01.15 09:42:00 - [505]
 

Originally by: caddycarrouf
Hi Dedaf,

Another lil' bug :)
In the Legion Subsystems (T3 sheet)
Dissolution Sequencer is here in double & Interdiction Nullifier is missing

Thanks for the fix, Cu around :)


I will make sure to have that corrected in the next release.

Originally by: Joe SMASH
Friendly bump, and great spreadsheet. I use it for my cap production and to pay out my mining fleet.

Thanks for the bump Very Happy


Originally by: WillieWortel
Hi Dedaf,
I downloaded 12.3a and tried to use 6 x Modulated Deep Core II, but only 0 or 1 is selectable (i'm using a BC).

The sheet is amazing by the way, very impressive.

Regards,
Darthyeren

Its because there are too types of Modulated Deep Core lasers Modulated Deep Core Miner II and Modulated Deep Core Strip Miner II
What you need is the first Modulated Deep Core Miner II, you select that in field "F7"
The one you are trying to use is for the Skiff, and it can only fit 1.

Dedaf

DarthYeren
Posted - 2010.01.15 11:39:00 - [506]
 

Your support is as great as the sheet itself.

Thanks alot

Azumo
Posted - 2010.01.16 07:13:00 - [507]
 

Edited by: Azumo on 16/01/2010 07:17:06
Thanks a lot!

Rotti
Posted - 2010.01.16 09:44:00 - [508]
 

Thank you the best spreadsheet out there by far excellent work

ZenithDK
Minmatar
Danish Space Pioneers
Posted - 2010.01.17 15:54:00 - [509]
 

Bugs found:
Crystalline Carbonide Armor Plates requires 40 crystalline and 10 ferrogel, not 30 ferrogel as the sheet says.

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

Thanks guys, for all the nice words.


Originally by: ZenithDK
Bugs found:
Crystalline Carbonide Armor Plates requires 40 crystalline and 10 ferrogel, not 30 ferrogel as the sheet says.



Crystalline Carbonide Armor Plates requires 40 crystalline and 10 Sylramic Fibers, which the t2 Ship production shows. so i think you might not have the latest version.
current version is 12.3a


Pages: first : previous : ... 13 14 15 16 [17] 18 19 20 21 ... : 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