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

Author Topic

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.10.06 07:22:00 - [421]
 

Edited by: Dedaf on 06/10/2009 07:27:51
Originally by: billybobob
I'm just not doing T2 ships...I'm only inventing modules and ammo. I still don't seem to be able to pick a module to produce after invention. Crying or Very sad
When ever I click on "View by slot status" cell: 48 x G-I the drop down doesn't work. I'm using Office 2007 on Vista ultimate.
As it is now, the T2 sheet is only for ships, i am working on a T2 item production sheet, but items use alot more different things than the ships does therefore its not easy to mix those 2 productions together and still keep a simple overview of the sheet.
yes the Sorting option seems to be broke after doing the XML restore, im working on solving that, but its kind of complicated with this macro thingy.

Originally by: Annaxe
I know it's kind of lazy...
Sometimes we work (i.e. grind into oblivion) systems where there are four primary types of ore and we demolish all of them. Is there any way we can have a new page that is a combination of the Mining page (with 12 Empire ore slots) and the T1 production mineral information?

BTW... Thank you for your work. ISKies en-route.
I have added 3 more rows under High sec ore, so that should help you when i upload the next version.
This topic you refere to was the mining time-calculator, and here the issue is different, i can not add other than standard ore, if i do then the calculation will tell you only to mine +10% ore, which is not possible, and therefore the time will be wrong, at least when its set on basic ore, you will know that when you mined the amount of time it says, then you have the needed ore, if you have +5 and +10 ore in between, then its just a bonus.

Originally by: Deckilin Viod
I just started using your tool (great tool btw) But the pos tool doesnt seem to be pulling the info from my corp pos do you have any ideas?
There are 2 reason's why you might not get them.
1st, you need to be Director in the Corp
2nd, you need to use the extended API, the basic is not enough for this type of information.

Originally by: WongKar Wei
Ah, I was unclear. This tool doesn't seem to include brokerage costs and production facility costs and taxes. I got the basic thing you lay out here. But when I total up all the other costs that aren't in the spreadsheet, it changes total profit.
You are right, the tool does not include Broker or factory slot cost, the reason is that its a hell of alot of work implementing for something that doesnt have much impact on the total price. You will never get a 100% correct price anyway the tool is only a guideline.


I hope this answers all you questions.
Thanks for all the feedback
Dedaf

Annaxe
Inter-System Heavy Industries
Posted - 2009.10.06 12:12:00 - [422]
 

Thank you! Very Happy

slytihline
Posted - 2009.10.06 13:23:00 - [423]
 

YOU HAVE A AWESOME PRODUCT HERE.
note im still in process of downloading 11,4,1 my question my be moot.
I do have a question though would it be possible to get some sort of import function for the ore calculator. i change what im needing constantly as it is i build say a capital armor plate i update the qty on hand it changes what i need in minerals which i then need to go change the ore calculator. granted i mine whats there (everything thats there too) but i try to start the day in belts with more of item i need most.

was looking at the sheet agian prior to final submission and noted the in stock minerals being pulled from t1 production. it would be similar to that i think. just with the function of turning off.

thanks for a great product
slytihline

WongKar Wei
Posted - 2009.10.07 02:03:00 - [424]
 

Originally by: Dedaf

Originally by: WongKar Wei
Ah, I was unclear. This tool doesn't seem to include brokerage costs and production facility costs and taxes. I got the basic thing you lay out here. But when I total up all the other costs that aren't in the spreadsheet, it changes total profit.
You are right, the tool does not include Broker or factory slot cost, the reason is that its a hell of alot of work implementing for something that doesnt have much impact on the total price. You will never get a 100% correct price anyway the tool is only a guideline.



Ah well, beggars can't be choosers. Thanks for the excellent tool!

HongHi Choi
AWE Corporation
Intrepid Crossing
Posted - 2009.10.07 11:03:00 - [425]
 

Thank you so much for this excellent tool. Will be giving a donation after my first T2 ship comes to life.

EnTerra
Posted - 2009.10.09 15:08:00 - [426]
 

Hi
I miss the marauder ship in the T2 production tab in Version 11,4,1. Or is that only a problem with Open Office?

Greetings EnTerra

daktrys
Posted - 2009.10.15 16:24:00 - [427]
 

Thanks for the tool - it certainly looks nice :)

I've got Office 2003 non-pro and there should be a way to import the xml some other way. I think you put a password on the VBA modules so we cant see the code - can you give us the password?

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.10.18 17:06:00 - [428]
 

Originally by: slytihline
YOU HAVE A AWESOME PRODUCT HERE.
note im still in process of downloading 11,4,1 my question my be moot.
I do have a question though would it be possible to get some sort of import function for the ore calculator. i change what im needing constantly as it is i build say a capital armor plate i update the qty on hand it changes what i need in minerals which i then need to go change the ore calculator. granted i mine whats there (everything thats there too) but i try to start the day in belts with more of item i need most.

was looking at the sheet agian prior to final submission and noted the in stock minerals being pulled from t1 production. it would be similar to that i think. just with the function of turning off.

thanks for a great product
slytihline
I will try to work on this, but i ran in to some problems dooing so.
So i thought id uploade a new version to fix the problem with Missing ships in the T2 production. ill try to add this funktion later.

Originally by: EnTerra
Hi
I miss the marauder ship in the T2 production tab in Version 11,4,1. Or is that only a problem with Open Office?

Greetings EnTerra

Yea you are right, then Marauder's and interdictors was missing, but they are now added to the new version.

Originally by: daktrys
Thanks for the tool - it certainly looks nice :)

I've got Office 2003 non-pro and there should be a way to import the xml some other way. I think you put a password on the VBA modules so we cant see the code - can you give us the password?

Only Office Pro have the XML import funktion, so your only option is to enter the skills manually.

just uploaded a new version 11,4,2. enjoy

Lico Crotikus
Gallente
ePeen Construction
Posted - 2009.10.19 13:34:00 - [429]
 

You really have made a lot of work here. And i love it.
Just have one question, and the question has been asked here before.
And you answered that you where working on getting the T2 Mods implemented, and there is a lot of work here.
But just wandering if you are thinking about the upcomming expansion and working on The Dominion T2 Ship production. As, everything you have done in the T2 Ship production sheet, will be changed in the next patch.
Im looking foreward to this new T2 Ship production spreadsheet.

Nice work here tbh.

Allucination
Gallente
Tellurian Works
Dark Taboo
Posted - 2009.10.19 17:36:00 - [430]
 

Hi can you do a correction to the T2 Build sheet on the sacrilege Hac as the R.A.M.- Starship Tech shows as isogen and errors the calculation.

Great work by the way Very Happy


Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.10.19 17:54:00 - [431]
 

Edited by: Dedaf on 20/10/2009 04:39:55
Originally by: Lico Crotikus
You really have made a lot of work here. And i love it.
Just have one question, and the question has been asked here before.
And you answered that you where working on getting the T2 Mods implemented, and there is a lot of work here.
But just wandering if you are thinking about the upcomming expansion and working on The Dominion T2 Ship production. As, everything you have done in the T2 Ship production sheet, will be changed in the next patch.
Im looking foreward to this new T2 Ship production spreadsheet.

Nice work here tbh.

Thanks,
No i havent started looking in to whats gonna change, ill wait till the patch is here, to see what happens, but maybe i should wait with the module sheet till after the patch.



Originally by: Allucination
Hi can you do a correction to the T2 Build sheet on the sacrilege Hac as the R.A.M.- Starship Tech shows as isogen and errors the calculation.

Great work by the way Very Happy


you are right, amazing i didnt see that before, the bug was not only on that ship but also on 10-12 other ships.

i will upload a new version within a few min's

Allucination
Gallente
Tellurian Works
Dark Taboo
Posted - 2009.10.22 16:38:00 - [432]
 

Hi again the sheet configures alot better now thank you but the quatities still dont calculate quite right on them the R.A.M.- Starship Tech should read 12 units for 1 ship built on a -3 bpc not 17 not sure about the others ie -4 -6 and -1 but i think they are 12 units aswell.

Hope you find this right to and i hope i havent just made to much work for you.

Thanks again.

Kira Metari
Posted - 2009.10.23 18:40:00 - [433]
 

Download link is buggy .

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.10.26 19:04:00 - [434]
 

Originally by: Allucination
Hi again the sheet configures alot better now thank you but the quatities still dont calculate quite right on them the R.A.M.- Starship Tech should read 12 units for 1 ship built on a -3 bpc not 17 not sure about the others ie -4 -6 and -1 but i think they are 12 units aswell.

Hope you find this right to and i hope i havent just made to much work for you.

Thanks again.


i didnt notis that RAM material wasnt effected by ME level, that is corrected now, so you should get the right numbers.


Originally by: slytihline
YOU HAVE A AWESOME PRODUCT HERE.
note im still in process of downloading 11,4,1 my question my be moot.
I do have a question though would it be possible to get some sort of import function for the ore calculator. i change what im needing constantly as it is i build say a capital armor plate i update the qty on hand it changes what i need in minerals which i then need to go change the ore calculator. granted i mine whats there (everything thats there too) but i try to start the day in belts with more of item i need most.

was looking at the sheet agian prior to final submission and noted the in stock minerals being pulled from t1 production. it would be similar to that i think. just with the function of turning off.

thanks for a great product
slytihline



you are now able to import missing minerals from T1 and Capital production sheet to the Ore to mine sheet.



New version 11.4.3 uploaded.

naotsu
Posted - 2009.10.29 18:52:00 - [435]
 

Edited by: naotsu on 29/10/2009 18:58:59
Edited by: naotsu on 29/10/2009 18:57:08
First off Dedaf, I would like to thank you for creating such a powerful calculator. I have not come across one that is this awesome.
It really has changed the way I play eve.

Anyways I am well aware that not everything is perfect and I do understand you're doing it for free. So just as a heads up, if you will, there are some errors in the rig prod. calculator.

In the workbook, I have used my api and updated it.
I go to the rig calc and plug in my numbers.
So for example, I want to build 100 units of small gravity capacitor upgrades. Using my api already, it says I need 4 charred micro circuits, 3 Damaged art. neural networks, and 4 fried interface circuits for a me 0 bpo
So I go ahead and conjure up 400, 300, 400 units of the respective salvage parts and fly 12 jumps to where the bpo sits in the corp hangar. I begin the manufacturing process and it says I only need 300 charred micro, 200 damaged art neural, and 400 fried interface circuits. Now for me this is a good thing because it doesn't require me to conjure up any more parts. But on some other rigs I have looked into, I would get to home station begin manufacturing and I am missing 100 units of something.

Is there something I am doing wrong? I checked market for the base unused amounts and it shows the same as the bpo I have in station. Is there a conflict somewhere in my skills that reduces the rig requirements on the workbook when in fact it's not supposed to?

Or is there a way we can enter our own values for the requirements?

Either way, I am just curious about this.

Oh and do you take isk donations?

Thanks for creating such a great product.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.10.29 20:47:00 - [436]
 

Thanks, im glad you like the tool.
you have done a very good error description, i looked in to this problem and i have modified the formula.
So i think the calculation should be correct now.
yes isk donations are always appreciated Smile

I uploaded a new version 11.4.3a with this rig material correction.

Enjoy


naotsu
Posted - 2009.10.29 21:11:00 - [437]
 

Originally by: Dedaf
Thanks, im glad you like the tool.
you have done a very good error description, i looked in to this problem and i have modified the formula.
So i think the calculation should be correct now.
yes isk donations are always appreciated Smile

I uploaded a new version 11.4.3a with this rig material correction.

Enjoy




Thanks for the swift update.

Isk donated :)

naotsu
Posted - 2009.10.30 00:33:00 - [438]
 

Small salvage tackle material requirements are incorrect as well.
Says it requires 3 Armor plates, 2 Contaminated Nanite Compound, and 4 Fried Interface Circuit. In-game an ME0 bpo says it's 4, 3, 4 respectively.

All the other rigs I work on seem to be correct.

Thanks :)

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.10.31 11:28:00 - [439]
 

Originally by: naotsu
Small salvage tackle material requirements are incorrect as well.
Says it requires 3 Armor plates, 2 Contaminated Nanite Compound, and 4 Fried Interface Circuit. In-game an ME0 bpo says it's 4, 3, 4 respectively.

All the other rigs I work on seem to be correct.

Thanks :)


Seems I canít do it the easy way.
Easy way is M rig use 5 times less material than L and small use 25 less than L.
90+% of the times that is correct, but in some cases like the salvager its not.
So only way to fix this is to totally reconfigure the way i import the M and S rig material, instead of calculating them as i do now.
So im sorry to say i cant fix this bug within a short amount of time.
But will try to find a solution to this.

Sorry for the trouble

naotsu
Posted - 2009.10.31 20:12:00 - [440]
 

Originally by: Dedaf
Originally by: naotsu
Small salvage tackle material requirements are incorrect as well.
Says it requires 3 Armor plates, 2 Contaminated Nanite Compound, and 4 Fried Interface Circuit. In-game an ME0 bpo says it's 4, 3, 4 respectively.

All the other rigs I work on seem to be correct.

Thanks :)


Seems I canít do it the easy way.
Easy way is M rig use 5 times less material than L and small use 25 less than L.
90+% of the times that is correct, but in some cases like the salvager its not.
So only way to fix this is to totally reconfigure the way i import the M and S rig material, instead of calculating them as i do now.
So im sorry to say i cant fix this bug within a short amount of time.
But will try to find a solution to this.

Sorry for the trouble


Oh it's no problem dude, just making you aware of the bug.

All it takes is some simple math to figure out what materials I need so it's no biggie.

Thanks o7

billybobob
Gallente
Posted - 2009.11.03 13:36:00 - [441]
 

Hi Dedaf,

The spreadsheet is great! :) But, per some your comments, T2 manufacturing is borked. :) Any idea when you will try and fix that?

Just curious.

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

Edited by: Dedaf on 03/11/2009 21:27:26
The next patch is within a month,and as i understand then there will be alot of changes to the t2 production's.
So i wont start on a t2 item sheet untill after the next patch. after the patch ill try to get a full t2 item list and then work from that.

Acmon
Caldari
ROMANIA Renegades
Legiunea ROmana
Posted - 2009.11.12 09:52:00 - [443]
 

Edited by: Acmon on 13/11/2009 13:22:17
Edited by: Acmon on 13/11/2009 13:08:03
Edited by: Acmon on 12/11/2009 10:04:40
Hello there.
Congrats for the awsome tool, i must be honest i use it from vers 10 Very Happy.
I`m waiting for dominion vers. too.
Thanks for your time, your tool ..and keep the awsome work.

Later edit:
I wanted to be shure that i`m not wrong. So in Excel 2010 are some "visual" problems with graphical icons (materials, skills..etc).
Link:
http://img690.imageshack.us/img690/8489/mining.jpg

In mining, ore, ice mine calculator, T2 production, jump frieghter sheets.

Acmon

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.11.15 20:05:00 - [444]
 

Yea iw seen that too in excel 2007, it has somthing to do with the zoom.
If you zoom in or out it will show the icons correct.

Agisha
Gallente
6thsense Corp
Posted - 2009.11.23 06:00:00 - [445]
 

This is a great product. Thanks a lot.

However, I have a doubt. In the T1 production profit calculation, do you include the manufacture cost: Install cost and Hour cost? If yes, where can we change the value?

Thanks

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

Originally by: Agisha
This is a great product. Thanks a lot.
However, I have a doubt. In the T1 production profit calculation, do you include the manufacture cost: Install cost and Hour cost? If yes, where can we change the value?
Thanks


No installation cost is not included, you will have to subtract that yourself from the sell price you set.
But still often the amount is so little it wont matter much in the end, since the import price are also only a approximate.

GFRoSTY
Minmatar
Posted - 2009.11.25 08:20:00 - [447]
 

I have started to use your spreadsheet more and more and I was wondering if you could increase the T1 Production sheet to more than the 20 item rows listed in Production.

As I am just making T1 stuff at present, I have more than 20 items in production so is there a way that I can increase this myself?
I might need something like 100-150 rows or even more of items as this helps me keep an eye on what I have in stock and what I can make with current mined or bought materials.

Thank you for an excellent Industrial Tool, when I have some spare ISKies they are yours.

Austin John
Gallente
Rapier Industry and Technology
Second Sun Rising
Posted - 2009.11.27 09:08:00 - [448]
 

Edited by: Austin John on 27/11/2009 09:10:49
Every single t1 item I look at has the wrong mineral requirements, EVERY SINGLE ONE.

Why is this? I've redownloaded, tried it on a different computer, used characters with 0 in every skill, etc etc etc; And I can't find anything.

I've also found that there's a crazy amount of grammatical and spelling errors in your spreadsheet...

Don't get me wrong, I LOVE it, but I can't trust it for anything and is therefore useless...

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.11.28 08:07:00 - [449]
 

Im sorry you feel like that, good luck finding a spreadsheet that works for you.

Epae Woewig
Caldari
The Green Machine
Posted - 2009.12.01 13:32:00 - [450]
 

Just started using this excel file and must say nice work indeed.
I did however find something i think is a bit of an oversight.

In the ORE tab, if you import from Tech 1.
In T1 Production i have as an example entered 1x Apocalypse and the mineral requirements are show at the top of the spreadsheet including a Total xx.xxx.xxx isk for this production.

When then tabbing over to the Ore tab, to see how much ore i'd need to mine, it shows all correct, EXCEPT in the Morphite listing.
It takes the total ISK from the T1 Production tab, and enters it as Missing Morphite for this production in the Ore tab.
Obviously this totally messes with the numbers.

Below is two links to show the issue with pictures:
http://img21.imageshack.us/img21/74/89332470.jpg
http://img24.imageshack.us/img24/8194/29703813.jpg

Something that could be updated/fixed?


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