Originally by: Bushgallam

---

I'd actually like to have all fields editable (like minerals prices and such)...

---

Originally by: Cryos Ylwan

---

I tried editing the skills by hand in the data sheet, and I think I've found a little bug: I entered the values for Refining, and when I'd finished, Refining AND Astrogeology were on level 5 in the calculator sheet. They seem to be linked or something.

---

Originally by: sonofapharmacist

---

Edited by: sonofapharmacist on 23/07/2007 04:08:17
i fit 5 mining laser upgrades in my domi, is there a way to change that?

---

Originally by: Alaris Nightshadow

---

A few glitches i've noticed.
On the POS Production Page

Liquid Ozone listed as missing is off by a factor of 10 (reporting 43,200 required instead of 432,000)

---

Originally by: Dedaf

---

I dont see that error, are you sure you have entered a right Power use in the Left side? or what tower type are you useing?

---

Originally by: Malik Travesh

---

Just a note, since I have an older version of Office, I was entering my data manually, and noticed you don't have Dark Ochre listed in the skills list.

---

Originally by: demonfurbie

---

i dont see small tower listed in the pos fuel calc

---

Originally by: Shinris

---

xml doesn't seem to work is there anotehr way to enter your skills.

---

Originally by: Zent

---

Edited by: Zent on 16/08/2007 23:21:14
when I select the amarr L tower it shows an error there to the right of the cpu is there reason for that error? i still can select everything but wasnt sure why it showing it

---

Originally by: Koyu Ryoko

---

I cannot for the life of me figure out how to import my skills into this excel file....

---

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.

---

Originally by: Pimpja

---

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

---

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."

---

Quote:

---

Dun kill me eris

coming to fanfest by any chance? eris

*GULP*

---

Originally by: Pimpja

---

Please fix spelling:

Available NOT avalerble

---

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.

---

Originally by: zaimine

---

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

---

Originally by: Reviera

---

i dont understand how i can ad a new bpo to the production table...

do i ad it manually and write in the minerals frome a non research bpo and then ad how mutch me i have mine researched?

---

Originally by: Gofer

---

It would be nice to have the ability to import multiple characters and choose them on each sheet. For example, I have a miner character and a production character.

Quote:

---

The thing is that when you download the character XML file, then it only contains that character's skill information. Ofcause i could make 2 files, but that would create some other problems that would be irritating for people with only one character.
I think in your case, make a second copy of the sheet, one fore each character.
But i have thought about it and maybe if i get the auto character skill file update to work, then there might be the possibility to have more than one character in the same sheet.

Originally by: Madcow

---

I added a blue print with the perfect miniral need in the spots what I think need to be done but the amount of minirals needed aint right with 500 researched efficiency blue print get abit close to how my 0 researched blue print is. I build in radima on an npc station.

---

Originally by: avicomo

---

Pls, tell us how to add more rows. it's really a nice spreadsheet you've done, but we need more rows for BPs :)

Also, are you gonna make a sheet for t2 production?
It would be great to have that to in same sheet.

keep the good work up :)

---

Originally by: avicomo

---

Pls, tell us how to add more rows. it's really a nice spreadsheet you've done, but we need more rows for BPs :)
quote]

I just uploaded a new version 7,1 with 10more rows for T1 production :)

About T2 production, I have been thinking about it, but the problem is that it needs so many deferent components, so i cant just make it like the T1. But if i find a good solution, then yes i will make a T2 production sheet aswell.

1. On the Mining page, the Cargo hold number does not adjust the formulae below it unless you set it to 0 it gives a #DIV/0! error, nothing else will make them change, I assume this is a bug.



2. T'el'Alana Luathin's mining sheet (which I used a lot when I first started eve in 2005) has a full set of ore rows including the 5+10% versions, this makes it easy to chuck in your ore and see how much you have and also to see what is best to mine by the values; your sheet is a lot harder as you have to switch the rows to see the best value etc. Unless I am using it in a way other than intended would you consider opening this up to include a row per roid type?



3. You have not included an option for T1 mining crystals, could you add this also?



4. Would you consider adding an ISK per M3 column to aid in the calculation of ore mining value?



5. Again referencing T'el'Alana Luathin's mining sheet, would you consider adding a mining operation calculation sheet, so that we could use your sheet to not only see estimated value before the sale but also to track time in op, contribution per time etc.



6. While I have not yet made use of your Ore calculator (it does look useful) it dosen't include any place to note down what minerals you already have, would you consider adding this so that it can be taken into account. I'll just clarify that a little more, assuming you enter the total required you can then enter "minerals on hand" and choose buy/mine and it will calculate for you, instead of having to work out required-minerals already on hand, allowing you to C&P from say the production sheet.

Originally by: Dedaf

---

4: IÆm not saying I wonÆt add this, but again I like to keep it a simple looking. Can you explain what the info about isk/m3 would be good for? Maybe I just didnÆt think of the use of this info?

---

Originally by: Jonathan Nice

---

Edited by: Jonathan Nice on 21/02/2008 22:48:01
@Dedaf: cool tool :)

but i¦ve a prob. I can¦t update from xml.xml... there¦s shown
a window very short, but i can¦t get an error and he didn¦t import
my xml :(

thx
Lee

---

Originally by: Fitz VonHeise

---

I really like what you have done.

When do you think you will add the newer ships to build like JF and the factional POS's info to your spreadsheet?

---

Originally by: AvatarOfHope

---

Is there a way i could make this work under open office?
Evrything works but i cant enter skill levels... :(

---

Originally by: AvatarOfHope

---

where do i find that data?

---

Originally by: Va Van

---

Edited by: Va Van on 04/03/2008 11:48:08
Little mistake in Rigging Calc.: "Capacitor Control Circuit" requires - Burned Logic Circuit, not Charred Micro Circuit. "Semiconductor Memory Cell" need to correct also.

P.S.: Respect 2 u yob! Every version is better and better!

---

Originally by: Dedaf

---

Selecting T1 and T2 crystals will only change your yield, meaning more ore pr hour, so that is the only thing that change, and when i try to change that, then i see the change.
About the Div/0, it sounds like you havent selecet any laseres in the Mining sheet, since this is where i take the ore yield from, to calculate how long it takes you to min the needed ore. So you need to set up your mining ship in the Ore mining sheet before the Ore calculator is working correctly.
might be the same reason why you dont see any change when you select crystals, if you havent selected the right laseres? othervice you are free to contact me ingame.

---

Originally by: Dedaf

---

The thing about the crystals, i cant see that problem, unless you dont have any Ore skills over 3, because then you cant use T2 crystals and then that is why you dont see it calculate, could that be why?

---

Originally by: Kyrlin DiShai

---

Ahh, I didn't realise it was taking into account I couldn't use them, I was trying to see how much it would increase my yield. That will be the problem then.

---

Originally by: Dedaf

---

You are totally right, the bug was only there when none of the ore skills was at 4.
This was definitely harder do implement than i thought

I think i got it working in this new error correction, Version 7,4,2

But still if you dont have lvl4 in any of the Ore skills, T2 crystals wont be calculating bonus.

Thanks

---

Originally by: Urm

---

Any chance T2 rigs will be included?

---

Originally by: Jendoe

---

Edited by: Jendoe on 28/03/2008 06:08:29
First let me say thanks for working this, it has been a good help recently!!

But, seems in the newest version 7.6.1, you may have locked the rig names in the t1 rig calculator, unless its just me, but I can't select a different rig then what is showing.

Oh yea, and while I am at it.. seems the scorched Telemetry processor is missing as well, and it would be nice if I could get a total value of my rig parts.

Thanks again

---

Originally by: Maria D'thinker

---

I can't download this file. Everytime I tried it just go to another webpage. Anyone has a better link for download?

thanks

---

Originally by: Dar Vega

---

hey great tool. however i have upgrade my whole pc now and downloaded the program again. vista with office 2007. my question is how do i get the excel sheet to import the xml data? i click update in the spreadsheet and it brings me to the webpage here. any ideas? or am i being a total noob? :D

---

Originally by: Kyrlin DiShai

---

1) On the Mining page, the Cargo hold number does not adjust the formulae below it unless you set it to 0 it gives a #DIV/0! error, nothing else will make them change, I assume this is a bug

---

Originally by: jantik

---

Also I noticed that when you select "Modulated Deep Core II" and a "Skiff" that it does not show your mining output (either ore/min or ore/hour)

---

Originally by: Mograthi

---

first I love the sheet keep up the good work. Now i use office 2003 and the api key update is doing nothing. I have put in my api key and userid and character name, when i hit update skill data it looks like it is doing something for a brief second, but no data is updated in the spreadsheet, any ideas?

---

Originally by: jantik

---

Dedaf,

Quick question on the T1 production sheet... I noticed that a Harb is put in when its downloaded and has values in the Gray Boxes (above where you input mineral amounts). If I add another, lets say a raven and give it an ME value those boxes stay 0. Where is it pulling this BP Mineral info from as I dont see it anywhere in the sheet.

---

Originally by: jantik

---

Originally by: jantik

---

Sorry Dedaf let me be more specific. On the Gray rows I20/21 to O20/21 have a "mineral value" encoded in them. Lets say in the type box I put in Raven and that its a BPC and the value. In the Material Level box, G21, I put an ME value of 100, where does the row I20>O20 get that info from? As if I have entered what I have just written above it is 0.

---

Originally by: TehFedz

---

I have a question about the t1 production page...

When I slap in a number of minerals for lets say Isogen in a blueprint information spot the input I give is put in a blue box. A new (higher) number then appears above the blue box in grey. What is this new higher number? What number does the input for the blue box represent?

The blue box im referring to is I22 and the grey is I21

---

I think i can answer both the questions in one. The sheet does no import minerals. it calculate it from the amount you have entered in the Blue fields I23-O23.
So what you need is to Go to Item dadabase. you need to take the minerals from the Item database because that is the base value of minerals for each item.
You can not use the mineral need from the Blueprint ingame, because that is not base minerals, that is the minerals you need with your skill, therefore the calculation is wrong in your case TehFedz.

So in short, you need to go to item database and find your Ship/item, and enter the minerals it shows there in the list.
When that is done, then you can set the ME LvL of your BPo or BPc and then it will show the right amount of minerals in the Gry field I21-O21

after entering minerals from Item database, then you can change ME LvL to see wich lvl will be best to research to.

I hope this helps your both, if not, then you are velcome to contact me ingame for a chat.
-------
Ore & Ice Mining
T1 & Capital & Rig Production
POS Fueling and Reaction
Minerals to Ore calculator

Originally by: sepharim blade

---

i dont know how to enter my skills manually, the down arrow doesnt show skills, how do i enter skills manually?

---

Originally by: Riset

---

Dedaf,

I have been using your files for some time now and am really glad to have them available. Thanks.

Unfortunately I'm having problems getting the "Update Skill Data" to work. I input my ApiKey (manually since it won't let me paste to the cell without unmerging it), UserId, and Character Name and press the key and get a Run-time error '483' "Object doesn't support this property or method" and it asks for me to do one of 2 choices, End or Debug. Any idea why this is coming up or any help on how to input the info to get this function to work? I have an older version of office and d/l'd the version for below 2003 and get it for either version.

---

Originally by: jantik

---

Edited by: jantik on 08/06/2008 16:26:40
An additional note, and I think its something I am doing, if I change the location of where the XML is saved, when I do UPDATE/IMPORT, it gives me a nice error saying that "C:\T1_PRODUCTION_BACKUP" cannot be found, so it never imports. Am I missing something?

---

Originally by: Aquabat

---

Just found this, and I gotta say ... wow!

Only thing that popped into my mind as I was going through, and I apologize if it's been brought up earlier, but any possibility of including ice materials in the ore tab? Or something similar in the POS Production tab, linked to the missing fuel amounts.

---

Originally by: P Stuyvesant

---

How can I import the 'Backup' data from previous releases. I thought this was to prevent users from entering the same data everytime a new version is released...

---

Originally by: P Stuyvesant

---

If I may make a suggestion, I saw that it does not import the actual stocks of minerals. Since the hanger contents can be downloaded by API would it be possible to have the stocks imported so that the T1 and T2 minerals and components in stock match what is in the hangers? Also, by taking 30 day wallet data the stocks could be given an average price per unit if it was bought on the market.

edit: oh and pls save the API data or the last imported skills in that file as well :)

---

Originally by: Kyrlin DiShai

---

5) Again referencing T'el'Alana Luathin's mining sheet, would you consider adding a mining operation calculation sheet, so that we could use your sheet to not only see estimated value before the sale but also to track time in op, contribution per time etc.

---

Originally by: Avariel

---

I'm not sure if I've missed it here, but does the Capital Ships section have the ability to be backed up as well in the sense of Prints, value of prints, etc, in the same fashion as the T1 Components?

---

Originally by: Keesa Danjad

---

Okay.. these might be stupid questions, so forgive me. I just downloaded the spreadsheet, and I'm totally in love so far. But I have a few "how do I" questions.

1. We buy our ore from our corp members. Can I put in what we purchase it for from the corp, and that way, I can figure out during mining ops more easily what each person earned?

2. In the T1 production... I just don't get it. I can't find the update button everyone is talking about. Am I supposed to be able to download the BPO's I have? Or is it supposed to show what I currently have running in a factory? Like I said, I don't get it.

3. POS production. What is the first blue column on the left before the "Material From" in Raw Materials?

4. In the Mining tab, there's no option for Mining Drone I's.

5. Is there anyway to update the ores/minerals I have in stock so I can't have to manually enter them. Since I mine every day, this can get to be tedious.

I think that's it right now. I would love to have a better idea of what some of this does, but I'm sure I'll get it as I use it more. Thanks so much for this!

---

Originally by: Dedaf

---

Originally by: Keesa Danjad

---

Okay.. these might be stupid questions, so forgive me. I just downloaded the spreadsheet, and I'm totally in love so far. But I have a few "how do I" questions.

1. We buy our ore from our corp members. Can I put in what we purchase it for from the corp, and that way, I can figure out during mining ops more easily what each person earned?

2. In the T1 production... I just don't get it. I can't find the update button everyone is talking about. Am I supposed to be able to download the BPO's I have? Or is it supposed to show what I currently have running in a factory? Like I said, I don't get it.

3. POS production. What is the first blue column on the left before the "Material From" in Raw Materials?

4. In the Mining tab, there's no option for Mining Drone I's.

5. Is there anyway to update the ores/minerals I have in stock so I can't have to manually enter them. Since I mine every day, this can get to be tedious.

I think that's it right now. I would love to have a better idea of what some of this does, but I'm sure I'll get it as I use it more. Thanks so much for this!

---

1) In the sheet called data, you can (in the blue fields) enter your mineral price.
Then if you in each sheet select OWN then it will use those prices.
I think the Corp mining sheet, that i just released today, will help you pay your corp members for the job they did mining.

2) the Backup/restore is only for backing up BP's that you have entered in this or in previous version of this sheet. you have to go to Item data base and find your item, then enter the minerals it says there. you need to use those amounts for the sheet to calculate right, do NOT enter the amout you see in BP's ingame.

3) The one you are asking for is the D colum i think. In Colum E you can select Market, Moon And actual. That refree to the price you bought it at. so to get a more precise build price, then select actual and then enter the brice you bought the moon material at in colum D.

4) Yes there are. Click on the T2 mining drone, then you get a drop down menu, there you select T1 mining drones.

5) I tryed to impliment it, so that the sheet also downloaded your asset, but its all mixed up when downloading that data, and excel dont have a good enough sorting feature, so its a nightmare trying to select what item you want.
so for now that featur does not exsist.

i hope that cleared up some of the

---

Originally by: Keesa Danjad

---

1. I was talking ores and not minerals really. We pay our corp members for the ore. I'm the only one that refines for the corp, and I don't refine but every few days. So, is there a way to put in values for the ore prices, not the minerals? Also, I really would love to see the new sheet you have for corp mining? Is it available yet? I'm almost drooling!

2. Does this mean it will save the information for the BPO's or do I have to re-enter them each time I use them for production? And does that take into account any research you might have done?

Thanks for all your hard work. I'm sure I'll enjoy this even more. Unfortunately, my boyfriend isn't happy with my obsession on this sheet right now.

---

Originally by: NetBlaise 1

---

WOW, I have to say that this is a Mining Directors best friends. The new CORP mining calculator is the best. I've done a couple of test rins with it to see how proficent it is and I have to say it works well. The CORP mining calculator can also be used to figure out your own mining amount per hour/day/week. A great tool. I have alot of questions about. Also is their like a How to Guide for using the calculator's etc?

CORP Mining Calculator

1. Break 1-5, What is that for and what does it do?

2. All the way to the right where the minaral totals are what are those totals telling me? Is it saying if I mine Veld. for 3hrs I will get this amount Tril./isk?

---

Originally by: NetBlaise 1

---

is their like a How to Guide for using the calculator's etc?

---

Originally by: shimmster

---

I just LOVE this sheet, youve put so much work into it what more can we ask! Well ok i do have one thing to ask, could you make it so we can pick the region prices are updated from, i live in derelik and just want to work off the prices in and around my region. Would be awesome if you could put that in!

Awesome work btw, just what ive been needing, this + eve-meep and everything i need is taken care of :P

---

Originally by: Elana Vaho

---

Edited by: Elana Vaho on 03/08/2008 19:35:26
First of all - very nice work mate :)

There is however a minor bug in the T2 production sheet. The amount of R.A.M. Starship Tech is not effected by the ME-level of the blueprint. It's like the T1 version of the item/ship, it's the exact amount listed that is needed. Like if it shows 15 on the T2 blueprint, I only need 15.

Another thing, how can I add multiple T2 blueprints, like on the T1 production sheet? I haven't checked everything yet, but as I see it I can only add 1 T2 blueprint or am I wrong?

Again, really nice work!

Edit:
Also, your sheet works very good with T2 production of ships, there are some T2 modules that also needs trade goods. Like sensor booster II needs some amount of miniture electronics.

---

Originally by: Zareph

---

Hi. I love the tool. Apparently I didn't pay enough for Office though as my 2003 version of Excel isn't fancy enough for the import :(

I was wondering is there somewhere you put in what the costs of slot installation/hourly charge is for building things? Wanted that factored into the cost of my items that I'm making and didn't see anywhere obvious for it or it mentioned in the documentation.

Thanks for this, looks pretty handy just getting my head around it.

---

Originally by: Dedaf

---

I think XML is a standard part of Office but i could be wrong. I think it could be 1 of 2 things. 1 you didnt install all features during installations or 2 your Macro security is too high.

---

Originally by: Avis Alt

---

In the Eve database the newest t2 ships doesn't exist. how can I get the base material quantity ?

---

Originally by: Avariel

---

Can someone verify if they're also seeing this problem.

Jump Freighter Construction, Toggling the Produced at Pos on various components like Crystalline Carbonide/Sylramic Fibers, is not changing the profit percentage (meaning it's not taking into account the lower cost of producing the Moon material as opposed to purchasing) like the pervious versions did.

---

Originally by: Dedaf

---

Edited by: Dedaf on 23/09/2008 15:45:47
Ok i have confirmed the bug.
ill upload a new version asap, sorry for the trubble

---

Originally by: Dedaf

---

Edited by: Dedaf on 28/09/2008 13:43:19

The XML price and skill update is supported only in Office 2003-2007 Pro.
Open office do not support direct XML update

---

Originally by: Paris vonTroja

---

What about a timecalculator for caps and its components?

---

Originally by: Zen Fong

---

I get this kinda error everytime I open the sheet:

"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

And I cannot import my character because the Update button doesn't work. I'm using MS Office 2007.

---

Originally by: Xevios I

---

Hmm...nice spredsheet indeed. But when I press the "backup button", the one for T1-production to create a XML file, it shows me an error 75. Anyone knows how to fix this? Using Office 2003.

---

Originally by: Sir EkeEkeFtang

---

Am i missing something or are the Material requirements for the Capital versions of the T2 components not available on the Jump Freighter page??

I cant find the build material lvls in either the Eve DB or Battle Clinics DB

---

Originally by: Sir EkeEkeFtang

---

On the Jump Freighter page the only components i can choose from are the standard T2 components. e.g. Deflection Shield Emitter. The Jump Freighter uses Capital Deflection Shield Emitters which have a higher material requirement.
How do i get to use the Capital versions of the T2 components in the sheet?

---

Originally by: Braendig

---

when I open the file, it asks if I want to run macros.. and no matter what I pick just closes.. every other workbook I open seems to work fine, anyone have any suggestions?

---

Originally by: Bulli Jo

---

Very nice spreadsheet. You've got functions I've been trying to figure out how to implement in mine (mainly a shopping list)

One thing I do in mine is I have a sheet with all of the perfect values for mineral requirements (contact me in game and I'll send you that sheet if you want) and then on my sheets that calculate mineral amounts like your T1 prod page I have it perform a lookup on that item. You could have it implemented in yours with 10 min of work and it would save the trouble of having to look up the minerals constantly.

---

Originally by: Eraseri

---

Hi, does anyone have any idea why i cant update my skill data? Im using excel 2007 and i have disabled all settings that prevent macros from working. I can however update mineral prices. I have checked my usedid/api/char many times but still something is bugged and the update thing doesnt work

---

Originally by: Raban

---

in the mean time is there a way to input our skills so the numbers for everything update? You dont ave the name and type IDs for the skills listed down there by default anymore so i dont know what it is?

---

Originally by: KevSC7

---

Hey,

First off, thanks for the awesome tool!

I noticed a small problem with the Rorqual production, for the Armor plates, it shows 5 needed when the Rorqual BPC is at ME 2, when it should be 6. It will only show that it needs 6 Capital Armor Plates when the Rorqual BPC is at ME 0.

Thanks,
Kevan

---

Originally by: Mikal Bishop

---

I love this spread sheet. Everyone in my corp calls me Mr. spread sheet becauase I always say let me open my spread sheet.

A correction though. The batch amount for cap booster 800 and 400 is 10 not 100 I don't know about the other sizes.

---

Originally by: Evo Mannerheim

---

Edited by: Evo Mannerheim on 02/12/2008 14:40:27
I've been getting an error when trying to update the prices over the past day. It shows the attached error message and then Excel locks up. Are others having this problem or is it just on my end?

---

Originally by: Viculus

---

But there does seem to be a bit of a problem :(
It appears that you have taken the item data from the eve-o website 'Item Database'.
Unfortunately this seems to be somewhat out of date.
e.g. 'Armor EM Hardener I'
The mineral requirements you give match the 'Item Database', but are not the ingame values.

I know that ccp have made data-dumps available (http://www.eveonline.com/community/toolkit.asp) but have never tried using this info.
My limited experience with databases will probably make this sloe going for me, but I am sure that there are many people in this community who already have an handle on how to use this data.

Regards

---

Originally by: Dedaf

---

I have just uploaded a new version 10,8,1

---

Originally by: Legionos McGuiros

---

Hi first id liek to say what a brilliant spreadsheet, its exactly what i need to get into industry and manufacturing :) Top man!

One thing ive found though, its probably sumin if done but i thought id check anyway, for the POS Production the Incme Per hour box only works for Small towers, wont work for Medium or Large.

---

Originally by: Spartus Raile

---

Edited by: Spartus Raile on 06/12/2008 19:29:55
Im using office 2008 and the macros to update dont seem to work, even after enabling all macros...

EDIT: Closed the document and re-opened it and works fine, good job man

---