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 : ... 18 19 20 21 [22] 23 24 25 26 ... : last (28)

Author Topic

licht dark
Amarr
Anuran Origin
Posted - 2010.08.05 10:06:00 - [631]
 

Edited by: licht dark on 05/08/2010 10:23:48
there a fault in ice mining sheet.
the sheet say that i get out off 10.158 ice
488.599 heavy water
244.299 ozon
9.771 stront
2.931.598 helium iso

after refeining i got

507.900 heavy water
253.950 ozon
10.158 stront
3.047.400 helium iso.

so the amount are not right.

(edit: never mind dont have the ice processing skill :P)

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.08.08 06:59:00 - [632]
 

Im glad you found the problem to the ice processing issue licht dark.

Thanks guys for the feedback, im happy to see people enjoy the sheet as much as myself Smile

juya
Posted - 2010.08.09 23:00:00 - [633]
 

Been using this for a bit now and awesome sheet.....but I dont know if I got a corruption or something...but back in the other sheet I could set something on capital build sheet then switch over to the ore tab and click on each ore tabCool and it would input it automatically in it.....did you set a different way for it to work? YARRRR!!

zindeen
Posted - 2010.08.11 05:20:00 - [634]
 

Edited by: zindeen on 11/08/2010 06:57:20
... never mind my office trial ran out may have to look into buying a copy of it so i can use this one program.. lol sighs

ID102034234
Posted - 2010.08.12 21:30:00 - [635]
 

Hey Dedaf,

nice work it seems to be! But unfortunately I cannot run it as Office 2007 always seems to delete the vbaProjects.bin.

I've setup a trusted folder and the sheet is in that location... do you know a workaround?

Thanks in advance,

Holyfire
Posted - 2010.08.12 22:11:00 - [636]
 

I quite appreciate the sheet, it has made my life significantly easier.

The one issue I have had, is that you can set "own" price on the data tab, and use it on the T1 construction tab to know what it is actually costing you personally based on own prices.

For t2 and other prices however, I can see no way to use "own" prices instead of the chosen region prices. This is slightly annoying, since it means I have to do all the math myself on what I would actually make based on what I am actually paying for T2 components.

Thanks!

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

Originally by: juya
Been using this for a bit now and awesome sheet.....but I dont know if I got a corruption or something...but back in the other sheet I could set something on capital build sheet then switch over to the ore tab and click on each ore tabCool and it would input it automatically in it.....did you set a different way for it to work? YARRRR!!

Nothing has been changed resently that should effect this, but maybe you used a old version.
What you need to do now is to select where to import missing minerals from. You do that in the dropdown menu (cell U16)

Originally by: ID102034234
Hey Dedaf,
nice work it seems to be! But unfortunately I cannot run it as Office 2007 always seems to delete the vbaProjects.bin.
I've setup a trusted folder and the sheet is in that location... do you know a workaround?
Thanks in advance,
My only idea is to try and lower the security settings of you office.
Try to go to the tab "files", then "settings". from that menu you go to "securitycenter". now click on "settings for securitycenter" here you should find "settings for macros, try to change those and see if it helps.
Sorry if the menu names are not 100% correct, its because i dont have a english version of office.

Originally by: Holyfire
I quite appreciate the sheet, it has made my life significantly easier.
The one issue I have had, is that you can set "own" price on the data tab, and use it on the T1 construction tab to know what it is actually costing you personally based on own prices.
For t2 and other prices however, I can see no way to use "own" prices instead of the chosen region prices. This is slightly annoying, since it means I have to do all the math myself on what I would actually make based on what I am actually paying for T2 components.
Thanks!

Im not really sure i understand this problem´. Feel free to contact me ingame and lets see if we can solve this issue.

thanks to everyone for your feedback

kiler 555
Posted - 2010.08.13 19:35:00 - [638]
 

nice tool but only i think ther is a error in the pi stuff it seems the soferenty mods materials divrent nubers for bilding than eve it self


but for the rest wery nice tool

AuroraMantis
Gallente
black-body
Posted - 2010.08.19 02:20:00 - [639]
 

Can you suggest any resources or books for being able to do advanced excel like this?

licht dark
Amarr
Anuran Origin
Posted - 2010.08.22 16:24:00 - [640]
 

found a error in the t2 item's.

when you select large armor repairer.
then it wont give the amount of t2 part's you need to build them.
its all stay on 0

Fractalon
Posted - 2010.08.22 23:40:00 - [641]
 

Hey is it possible to add an in stock box for the T1 item that goes into producing a T2 item? Thanks.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.08.25 15:01:00 - [642]
 

Originally by: kiler 555
nice tool but only i think ther is a error in the pi stuff it seems the soferenty mods materials divrent nubers for bilding than eve it self
but for the rest wery nice tool
Im not sure of the problem you describe here, contact me ingame and lets have a talk about it.
Originally by: AuroraMantis
Can you suggest any resources or books for being able to do advanced excel like this?
No i cant give you that sry, all iw learned is from YouTube and self-study.

Originally by: licht dark
found a error in the t2 item's.
when you select large armor repairer.
then it wont give the amount of t2 part's you need to build them.
its all stay on 0
i see the problem, it seems there are 4 other items doing the same thing. I will fix it in the next release.
Originally by: Fractalon
Hey is it possible to add an in stock box for the T1 item that goes into producing a T2 item? Thanks.
That is not a bad idea, i will see what i can do. Maybe have it in the next release.

Thanks to all of you for the feedback.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.08.26 13:43:00 - [643]
 

New version that should correct the abow mentioned problems and some new features.

Version 12,6,6

Volrathfalln
Posted - 2010.08.30 07:20:00 - [644]
 

Hey Dedaf

Im trying to use ur spreadsheet for mineing ore, well everytime i goto select the ore that i can mine to caculate how much i need to mine it puts a 0 in the Available spot for the ore, then its gives me a bunch of errors in the need to buy row and extra minerals row.
im useing open office and read that the uploads wouldnt work with it am i doing something wrong


Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.08.30 08:20:00 - [645]
 

Originally by: Volrathfalln
Hey Dedaf

Im trying to use ur spreadsheet for mineing ore, well everytime i goto select the ore that i can mine to caculate how much i need to mine it puts a 0 in the Available spot for the ore, then its gives me a bunch of errors in the need to buy row and extra minerals row.
im useing open office and read that the uploads wouldnt work with it am i doing something wrong


Hi Volrathfalln
I have tried to see if i could get the same error, but it is working fine in the Office2010 version.
But it seems after the sheet was converted to xlsm (office 2007) then there have been some problems for OpenOffice users.
So im afraid that the problem is because OpenOffice isnt compatible with office2007 or newer file format.

I have tried to save the file in a old Office format, maybe that will help you.
you can download it here

dragtec13
Posted - 2010.08.31 14:17:00 - [646]
 

Hi, I have been playing around with this tool some and have a quick question or I might be just plan doing it wrong. Under t1 production is there anyway to calc. The cost of the factory run into the production cost per batch seems like it only shows the cost of the minerals?

Firestorm Andrew
Posted - 2010.09.04 01:09:00 - [647]
 

this is awsome looking spread shett going to take a while to figure it all out.

Problem I am having I put in my api limited key user and charractor name but I am getting a runtime error 438 object does not support this property or method I am using office xp.

Any ideas on what might be wrong would be appreciated thanks

Firestorm Andrew

seanzyyy
Minmatar
Atlas Solutions
Posted - 2010.09.04 22:58:00 - [648]
 

Edited by: seanzyyy on 04/09/2010 23:00:36
Very nice work. I was turned on some other industrial calculator that can't do 1/4 of what yours does, I love yours. One request tho, or perhaps you could tell me a simple way of doing it myself. In the T2 Items production section there are only 3 Item lines, I make many more items at once and more lines in there would be lovely. I suppose just duplicating the tab works, but it would be nice to have everything combined on one sheet instead of many.

Aedun Sole
Posted - 2010.09.05 12:41:00 - [649]
 

Edited by: Aedun Sole on 05/09/2010 12:48:10
Hey Dedaf, the link to the download seems to be not working for me from eve files, and there is no link to mediafire file of this. I tried firefox and explorer but still a no go.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.09.06 09:30:00 - [650]
 

Originally by: dragtec13
Hi, I have been playing around with this tool some and have a quick question or I might be just plan doing it wrong. Under t1 production is there anyway to calc. The cost of the factory run into the production cost per batch seems like it only shows the cost of the minerals?

No, the factory slot cost is not calculated. To do this, the sheet will have to know Skill, BP production time and factory cost. This is a major job to implement, but you wont have an exact build price anyway. And often the price of factory slots is so low that it doesn’t have any effect on the build price really. So i decided not to have that calculated.

Originally by: Firestorm Andrew
this is awsome looking spread shett going to take a while to figure it all out.
Problem I am having I put in my api limited key user and charractor name but I am getting a runtime error 438 object does not support this property or method I am using office xp.
Any ideas on what might be wrong would be appreciated thanks
Firestorm Andrew

I might very well be because you use a too old version of Office. Im not sure if the Office XP version supported direct xml import.
Originally by: seanzyyy
Edited by: seanzyyy on 04/09/2010 23:00:36
Very nice work. I was turned on some other industrial calculator that can't do 1/4 of what yours does, I love yours. One request tho, or perhaps you could tell me a simple way of doing it myself. In the T2 Items production section there are only 3 Item lines, I make many more items at once and more lines in there would be lovely. I suppose just duplicating the tab works, but it would be nice to have everything combined on one sheet instead of many.

i guess i could add one more slot maybe, but the thing is, some of the formula’s (length)are already at the limit of what office support, so its a major job adding more. i therfor think your best option is to duplicate the t2 item porduction sheet.
Originally by: Aedun Sole
Edited by: Aedun Sole on 05/09/2010 12:48:10
Hey Dedaf, the link to the download seems to be not working for me from eve files, and there is no link to mediafire file of this. I tried firefox and explorer but still a no go.

I have fixed the mediafire link it should be working now. The evefile link seems to work fine for me though.


Thanks to all of you for the feed back.
Dedaf

Iriana
Posted - 2010.09.06 18:51:00 - [651]
 

getting "Run-time error '9': Subscript out of range"

Windows 7 64bit.. Office 2007

Anytime I try to (check server) or (Update skill data) am i doing something wrong?

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.09.07 09:01:00 - [652]
 

That error can mean alot of things if you try to google it. I do not know why you have that problem.
Try to google it to see if any of the info, can help you.
all i can say is make sure the macro security is not set too high or put the sheet in to a trusted folder, like i describe in the FAQ nb.3

Iriana
Posted - 2010.09.07 22:15:00 - [653]
 

I downloaded the converter tool from Microsoft and inside excel clicked the convert option that shows up under file.. after it converted things started to work.

Moldarion
Posted - 2010.09.08 09:20:00 - [654]
 

Hey Dedaf.
First of all I got to say that your tool is amazing :)
But I think there is an error in T2 Production. I don't think that the price of the Construction Blocks is added to the total production costs.
I set up several prices for the Blocks but the Production Costs of my Vagabond didn't change at all.


Emma Royd
Caldari
Maddled Gommerils
Posted - 2010.09.09 12:13:00 - [655]
 

Edited by: Emma Royd on 09/09/2010 12:14:01
Very comprehensive sheet :)

I'd love to see a cut-down version, I like to see one with just the ore sheet (the one where you can enter your mineral requirements and it shows which ore to mine), any chance of telling me the secrets of how you got this worked out? I'd love to integrate it into my own humble spreadsheet Rolling Eyes


Deckington Forgecaster
Posted - 2010.09.10 13:26:00 - [656]
 

Amazing spreadsheet!!

Thanks for sharing

10 thumbs up

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.09.10 13:59:00 - [657]
 

Im glad you got it working Iriana.

Originally by: Moldarion
Hey Dedaf.
First of all I got to say that your tool is amazing :)
But I think there is an error in T2 Production. I don't think that the price of the Construction Blocks is added to the total production costs.
I set up several prices for the Blocks but the Production Costs of my Vagabond didn't change at all.

Thanks im glad you like the sheet. You are right there was a link error to the pice date. but its corrected in this newly uploaded version.


Emma Royd: Its not easy to explain here, and its been some time since i build it. So contact me ingame and lets have a talk about it.

Deckington Forgecaster: Thanks alot, i hope you will enjoy this new version too.


Thanks to all of you for your feedback
New version 12,6,7 uploaded

Torn Rufen
Posted - 2010.09.10 14:00:00 - [658]
 

hmm, not sure why, but I get a "run-time error 13 incompatible type" while trying to update my skill data in Office 2007!

my office is in french, but my windows 7 64bit is in english, and my regional settings date and time are set to dd.MM.yyy and HH:mm.

th for any help :)

Emma Royd
Caldari
Maddled Gommerils
Posted - 2010.09.12 09:16:00 - [659]
 

Cheers Dedaf, when I feel the urge to throw myself into excel, I'll get a huge pot of coffee brewing, and send you an evemail Wink

hankey
Minmatar
The xDEATHx Squadron
Legion of xXDEATHXx
Posted - 2010.09.14 10:20:00 - [660]
 

Dedaf,
Nice compilation of tools!

Can you add there POS Modules Production?


Pages: first : previous : ... 18 19 20 21 [22] 23 24 25 26 ... : 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