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 : 1 [2] 3 4 5 6 7 8 9 ... : last (28)

Author Topic

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.08.18 19:28:00 - [31]
 

Originally by: Koyu Ryoko
I cannot for the life of me figure out how to import my skills into this excel file....

If it isnt updated after you saved you xml file to the C:\ drive and clicked UPDATE, then its cause your Excel dont support XML update. Then you need to enter them manuel in the DATA sheet

Sense Offender
Gallente
Ethereal Spacesuits Aviation Chillout Club
eXponential maXimum
Posted - 2007.09.19 05:49:00 - [32]
 

Great sheet. One small problem... my current setup has one MLU I and one MLU II. As far as I can tell, you don't give the option to mix and match different models, just multiples of one.

Dretzle Omega
Caldari
Global Economy Experts
Posted - 2007.09.19 15:20:00 - [33]
 

Seems like it would be much more useful if we had the option to manually input our skills. I realize the xml upload is designed to make it easier for players, but for some it just makes it harder.

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

Originally by: Dretzle Omega
Seems like it would be much more useful if we had the option to manually input our skills. I realize the xml upload is designed to make it easier for players, but for some it just makes it harder.


Click on the DATA sheet and enter your skills there. very simple

Snipa Aslan
Caldari
Warrior Nation United
SMASH Alliance
Posted - 2007.09.20 15:51:00 - [35]
 

So very very impressive, this is precisely what I was looking for today with the amount of production I had to do!

Pimpja
Caldari
Posted - 2007.10.03 09:20:00 - [36]
 

Very cool stuff, if only I could chose mining barges apart from exhumers (for mining) as well :(.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.03 14:42:00 - [37]
 

Originally by: Pimpja
Very cool stuff, if only I could chose mining barges apart from exhumers (for mining) as well :(.


Selecting NO to Useing Exhumer that will = mining Barge

PauZotoh Zhaan
Aliastra
Posted - 2007.10.04 23:04:00 - [38]
 

how works production calculator? how to choose bpo? I dont get itNeutral

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.05 15:31:00 - [39]
 

1st You find the item you want to build in Eve-online item database, and enter the mineral needs in the sheet yourself.

When that is done you can set the ME lvl. Then the sheet will calculate the mineral use at that lvl.
Form the mineral use, it will calculate the price of minerals(build price pr item) by using the imported mineral price. If using a BPc then it will also calculate the price of the BPc in to the build price, also taking number of runs in to account.

In the blue field on the left side of the BP, you can set how many runs you want to do. Then in the top right side of the sheet, it will show you how much of each minerals you need for the production and how much of each mineral you are missing so you know what to buy or mine before you can start building.

Cilvius Sanctus
Gallente
The Order of Chivalry
Nex Eternus
Posted - 2007.10.08 01:15:00 - [40]
 

I don't know if there is anything you can do about this, but the update buttons seem to be broken in Office 2007.

Clicking on any of the update buttons (except for the one that takes you to this thread, that one works) throws this error:

"Cannot run the macro 'Ore Mining & Ice Mining & Production Calc & POS running 6,2.xls'!UpdateMarketPrices'. The macro may not be available in this workbook or all macros may be disabled."

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.08 11:27:00 - [41]
 

Originally by: Cilvius Sanctus

"Cannot run the macro 'Ore Mining & Ice Mining & Production Calc & POS running 6,2.xls'!UpdateMarketPrices'. The macro may not be available in this workbook or all macros may be disabled."


This looks more like your macro security level is too high, you should set it to maximum Medium.

so in Excel, go to menu TOOLS -> Options. a new windowe opens, select the Security Tab. In the botten click on Macro Security and set it to medium.

i hope that solves it

ForceM
Gallente
POS Builder Inc.
Silent Requiem
Posted - 2007.10.13 11:41:00 - [42]
 

Production Calculator tab => BluPrint
i might be off by a mile but i think your missing an E :)

Anyways ... nice sheets

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.19 07:21:00 - [43]
 

New version
This version now also have a calculator that can tell you how much of each Ore type you need to mine to get the minerals you need for your production.

Pimpja
Caldari
Posted - 2007.10.19 09:39:00 - [44]
 

Please fix spelling:

Available NOT avalerble

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.19 11:37:00 - [45]
 

Originally by: Pimpja
Please fix spelling:

Available NOT avalerble


Very Happy Done

Pimpja
Caldari
Posted - 2007.10.20 08:02:00 - [46]
 

Errr, you only fixed one box out of all the boxes in the new sheet...

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.20 09:44:00 - [47]
 

hmm, NOW its done

Alaris Nightshadow
Sankkasen Mining Conglomerate
On the Rocks
Posted - 2007.10.20 11:12:00 - [48]
 

Edited by: Alaris Nightshadow on 20/10/2007 11:13:03
I'm a little curious as the the formula you are using to calculate which ore to mine for the minerals. Specifically with Mexallon, the best ore per m3 is Plagioclase for Mexallon, not Kernite.

See this site for Which Ore gives the best yield per m3 for a given mineral.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.20 17:09:00 - [49]
 

Originally by: Alaris Nightshadow
Edited by: Alaris Nightshadow on 20/10/2007 11:13:03
I'm a little curious as the the formula you are using to calculate which ore to mine for the minerals. Specifically with Mexallon, the best ore per m3 is Plagioclase for Mexallon, not Kernite.

See this site for Which Ore gives the best yield per m3 for a given mineral.


Yes you are totaly right, i compleatly forgot to take the mass of the ore in to acount, Thank you very much for you reply.
I will sort i out as soon as i can find the time, and post a new version.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.20 18:21:00 - [50]
 

Mass calculation is fixed in the new version 6,4,1

zaimine
Posted - 2007.10.22 10:27:00 - [51]
 

probs being idiotic where is the update key for the character data

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.22 20:30:00 - [52]
 

Originally by: zaimine
probs being idiotic where is the update key for the character data

Clicking on any one of the buttons will update all data in the file, also you character data as long as you have saved the character XML file to your C:\

Donada De
Posted - 2007.10.29 20:22:00 - [53]
 

It does not work to upload your character data on the latest version. Since I prefer to do that then adding them manualy, I would appriciate if you could make it possible once again. Thanks for a terrific sheet! :)

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.30 15:04:00 - [54]
 

Edited by: Dedaf on 30/10/2007 15:07:12
It seems that the XML file from the character page has been changed, so i will have to find another way to import the data, if infact this is a permanent change to the XML file or just a bug. But if it isínt a bug then i will see what i can do to make it work with my sheet again.

ill do my best to have a new working version very soon.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.30 17:32:00 - [55]
 

New version 6,5 that works with the new Character XML-file

Donada De
Posted - 2007.10.30 19:46:00 - [56]
 

Thanks for the quick response and help!Smile

Tai Shogun
Gallente
Posted - 2007.10.31 18:11:00 - [57]
 

Edited by: Tai Shogun on 31/10/2007 18:11:22
Hi

I downloaded this sheet, and it looks great. Just one thing, the import of xml data. Is there another way to do this.
I renamed the file to xml.xml and saved it in C: but i get this error msg. Have been nice to have a button just to update
character and find it manualy by browsing to it. because it dont work now. Maby i done something wrong.

Please visit your user settings to re-enable images.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.10.31 21:06:00 - [58]
 

it would seem you are doing the right thing, but there could be one thing you are doing wrong, If you renamed the file after you have downloaded it, then it could be that you are not renaming it to "xml.xml", but infact "xml.xml.xml" that is because *.xml is a known file by windows, so it haids the file type.

Try this, Download the file again and before you save it to your disk drive, make sure it got the right name.

Dertionaire
Posted - 2007.11.03 21:14:00 - [59]
 

Would it be possible to get the sheet to download the xml direct? via the API key?

/Sedontane

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2007.11.06 07:28:00 - [60]
 

I think it would be possible, problem is I donít know how to do it myself, but I might know someone who does. For sure it is an issue that im thinking about implementing.


Pages: first : previous : 1 [2] 3 4 5 6 7 8 9 ... : 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