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  |
 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 tab  and it would input it automatically in it.....did you set a different way for it to work?  |
 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 tab and it would input it automatically in it.....did you set a different way for it to work? 
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:01Very 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  |
 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  |
 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? |