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

---

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.

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: 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: 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: 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: 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: 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: 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: 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

---

Originally by: Sidrat Flush

---

Only just started playing with this and it's what I've been looking for - for quite some time now.

Now if you could only pull the inventory using the API that would be really really nice :p

Oh and the backup option isn't working at least on my vista computer using office excel 2007 and I can't see the blueprint icon that the pdf manual displays, in fact my sheet looks nothing like the screenshots used in the pdf.

That being said, it's a very very nice tool to use, but I will test it further later on tonight.

---

Originally by: wibble ipera

---

have just tried to use this and when i try and input my API i get an error

Quote:

---

ActiveWorkbook.XmlMaps("Characters").Import Feed, True

---

is the line that is giving the error

---

Originally by: Vaedon

---

Hey Dedaf, fantastic spreadsheet. Far and away the most useful one I've found yet.

Found one small error though. The probe BPOs that I checked (Multispectral Frequency and Gravametric Quest specifically) produce 1 unit per run, not 100. After a quick look see, every other probe seems to be the same.

This is a fantastic tool and I highly recommend it to every industrialist out there!

---

Originally by: Kordel Trask

---

Hi Dedaf,
Just downloaded your sheet for the first time and have yet to really get into.
(Thanks ahead of time! I know how much work can go into something like this.)

Onward:
I just succesffully imported my character and noticed on the data sheet it is not listing the skill name, just "skills" for all of my characters attributes.
I noted in the documentation it actually listed the skil.
I wanted to check that I hadn't miss something or bring it to your attention if it was a bug.

I also thought it might be useful to clarify if you need the Full or limited API to import all of the data the workbook requires in the documentation or workbook itself.

Thanks Again!

---

Originally by: Lady Flashheart

---

A) Awesome spreadsheet *thumbs up*

B) A small favour if possible. - Some of us are using os's that cannot upload api keys so could you add a few more skills to the data section so that all applicable skills can be uploaded. - For example on the jump freighter production sheet some of the purple skills required show "0" because there is no entry data point unless via the "api" key.

skills like : mechanical engineering, minmitar starship engineering and the like. These would upload via the API key but there is no place to load them manually on the data sheet - unless i'm not seeing it

Many thanks

LF

---

Originally by: BlacX

---

Hello, Thanks for the quick reply and help it is greatly appreciated. It is now working but i have one more bug/trouble. I entered my api information and it entered all the information from it, but the information is not correct. I checked my skills with what was entered and there are several that are different so I need to change them Manually. Is this a bug that you know of or is that supposed to happen?

Thank in Advance
BlacX

---

Originally by: Weshta

---

Hello, I will contact you ingame for your email as I have used api again on another of my players, and i have same problem. I know for the "mining director" skill is wrong and several others.

[Edit] I Have checked the typeid for Mining Director as 22552 and my Xml list it as level 3, buy the excel sheet keeps putting a 5 in the slot. Also warefar link i dont have yet it keeps going to 5 as well. There are a few others but I can't remember them at this time.

[2nd Edit] Ok i checked the sheet under data it lists the mining driector as lvl 3, but on the Mining page/sheet it show as 5. I am still trying to find the other wrong ones..

I will send you my char.xml when i get your email.

Thanks for your Help
Blacx

---

Originally by: Pwett

---

Dedaf, does your skill parser account for unpublished skills? If not, that might be a problem.

It replaces the level field for those skills.
(The skill is mnemonics btw)

 <row typeID="3405" skillpoints="250" level="1" />
 <row typeID="3407" skillpoints="500" unpublished="1" />

---

Originally by: Raaz Satik

---

T1 Production is missing

• ECM - Multispectral Jammer I


• Industrial Core


• Most of the "micro's" (Smartbombs, Shields, Armor etc)

I could be wrong but I also think the following are wrong

• Mobile Small/Medium/Large Warp Disruptor (also needs Electronic Parts and Warp Scrambler I's)


• Warp Disrupt Probes (requires several T2 advanced materials)

---

• Capital Tractor Beam
  Covert Cynosural Field Generator I
  Covert Jump Portal Generator I
  ECM - Multispectral Jammer I
  Industrial Core
  Prototype Cloaking Devices I

Originally by: Mordachai Seghar

---

Hello,
Great sheet, simple and easy to use!

Just one thing, I been looking and I'm not able to fint production of T2 drones any where.
If they are there somewhere, where do I find them?

Regards,
Mordachai

---

Originally by: Erica Vairland

---

Are Prototype Cloaking Devices missing from T1 or am I blind?

Great sheet mate, not only as a tool, but as an example of great Excel skills. :)

---

Originally by: Lpi Landis

---

Hello,

How do you setup region to get prices from? I have been unable to locate how to choose other regions.

Thanks In Advance
LPI

---

Originally by: Arc Tellos

---

For some reason the link isn't working can you repost the link please?

---

Originally by: MIcky Ward

---

Looks like a really great job. I can get my API entered no problems. On the T1 Production page after I click on Backup the popup appears to ask me to proceed as stated in the user manual, however on proceeding I get an error "Runtime error 75. Path/File access error"

I don't know much about Excel, I'm running 2007, just a pity I can't get it to work. Hopefully I'll figure something out.

---

Originally by: Old WiseMan

---

First off - great tool, been using it for a while. Think i've found a bug in the POS "Total Fuel Needed Calculator".

For Liquid Ozone & Heavy Water the 'Days of Fuel in stock' seems to be giving only about 25% of the actual figure. It seems to be wrong on the imported calculation of 'Days:Hours' as well.

I may be wrong; I often am

---

Originally by: Dnem Arzean

---

Hi, I am trying to use my API-key but I am getting a false message "438". While clicking on the problem-search am I getting: "ActiveWorkbook.XmlMaps("Characters").Import feed, True". What am I doing wrong?

---

Originally by: Relm Wu

---

Really an enormous piece of work. Thank you for sharing this with the community.

Originally by: Dedaf

---

Originally by: MIcky Ward

---

On the T1 Production page after I click on Backup the popup appears to ask me to proceed as stated in the user manual, however on proceeding I get an error "Runtime error 75. Path/File access error"

---

You get that error because the Sheet is not able to write to your C:\
Maybe your C:\ is writ protected or maybe its a DVD/CD-rom drive? or maybe its some other rights that prevent the Sheet from accessing your C:\ drive.

---

I do have the same issue. Most likely Vista is blocking access, preventing a backup and therefore a price update. Is there a way to change the path for the backup file?

---

Originally by: ailis

---

The link on Mediafire is reporting that the file is invalid

---

Originally by: master fog

---

Love this "little" sheet but I do have one question regarding reactions.

With those newly added unrefined reactions, have you ever thought of implementind them into the pos production sheet?

---

Originally by: Welktickler

---

This is an amazing resource. Thank you very much for sharing all your hard work :)
Here comes the inevitable questions lol
In the T1 production section
How you change the number of units per batch?
In the build price does it count the factory cost per item? Does it count the cost of the BPO? If so for how many runs?

---

Originally by: ArtomN

---

I try to add jump Fraitor to prodaction.
All work fine on jump Fraitor Page but then whan i go to pos prodaction i can't see what row matirial i need to produse componets for jump Fraitor is the any way too at them ther from Jump Fraitor Page???

---

Originally by: Antiria Archurian

---

Hi Dedaf, great product. When trying to unprotect the T1 sheet in 10,9,6 I'm prompted for a password. That's new behavior; did I miss the password noted somewhere?
Thanks

---

Originally by: Kalter Kaffee

---

Hi Dedaf,

great tool, thx.

But if I'll try to calculate mining-crystals, it is calculating in 100-batch. For that the build-price is too low.

---

Originally by: slytihline

---

Edited by: slytihline on 13/03/2009 03:18:30
love this sheet use it quite abit.
researching getting into capital production so pulled up tool and started messing around with it (modifing material lvls for everything from carrier to titian to armor plates) after making a stupid high something like 10 yrs researching time bp set for everything for frieghters saw the BPc was sitting at 490mil. making the sell price for this upwards of 1bil to break even... tried to find somewhere to modify that down to proper price couldnt locate? looked thru this a little nothing "popped" out at me.

disregard im a idiot :) messing with things is the devil a large quantitied item had a stupid high bpc price per. moved it down and bam insta fix

awesome sheet once agian.

sly

---

Originally by: Gorbain

---

Whenever I do an update my list of skills disappears

---

Originally by: Gorbain

---

So, it's not that my skills go away, I have the correct API and I get my skills, the numbers are correct but all the skill names become "skill"

---

Originally by: Mikal Bishop

---

How do you get the list of T2 itmes to show up in the t2 productio sheet. all I see is
T2 vesion name and T1 version name below that?

---

Originally by: Erestas Drake

---

Maybe I'm missing something, but as far as I see it your T3 gas calculations seem wrong, example for the Fulleroferrocene:
One hull (without subsystems) will need 845 Fulleroferrocene, one reaction for this would be 1000 trit, 200 C50, 100 C540 and will output 1000 units of Fulleroferrocene, your sheet seems to calculate 845 reactions needed for one hull, instead of just one to reach the needed 845 Fulleroferrocene.

---

Originally by: ArtomN

---

ther is a prablem with Caesarium Cadmide reaction in Pos_Prodaction
the right row matirials you need is Cadmium Caesium and in you chats it takes
Caesium AND Chromium

---

Originally by: Dariah Stardweller

---

Not to be rude or anything, but when is the last time you updated the T1 blueprints, cause I had one just now where the numbers were way off... Started getting suspicious of the high profit margins it showed me.

---

Originally by: Black Friar

---

Im still with this problem and i made one test.
First i opening your work in the excel 2007 (this is the problem).
If i use vlookup function in the excel 2007 without ending FALSE (Exact match) then default value is True what mean (Approximate match).
Because of that in some case value taken from the wrong row.
'------
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(A8, G2:L10, 3, FALSE)<--- only right metod for excel 2007
=VLOOKUP(A8, G2:L10, 3)<--- working only in the excel 2003
'-----
Maybe you can make some changes in your next version.
ty

---

Originally by: phantom ghost

---

Dedaf,
I keep getting an error message whne i startup V11. the message is: "Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting carefully."

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

Guessing this is the reasion its not getting my skill once i enter the API key or update the prices.
Thanks in advance.
Phantom

---

Originally by: HirschG

---

I have a problem importing my skills.....i enter api and user and nothing happenes when i press update.

---

Originally by: Commander Phoenix

---

Hi again. this still doesn't work with 2 of my characters (they both have spaces in their names). One of my characters does work though (has no spaces in name). With the characters that have spaces in their names, th spreadsheet updates something, but the Mining tab shows no name in the character box, It does however sho the time I tried to update it. Sometimes I get the error quoted and Excel just freezes up and I have to kill it using the task manager.

---

Originally by: Master Kent'sslave

---

Edited by: Master Kent''sslave on 28/04/2009 19:56:25
Edited by: Master Kent''sslave on 28/04/2009 19:51:46
In the t2 page it seams like the own price field updates from somewhere else than the colum in the data sheet. i cant get nano transistors to pick up the price from the data sheet

edit:

Greate work on the sheet btw

second edit:

looking more on it price for nanotransistors are permanently set to :431 isk pr unit in the t2 tab

---

Originally by: Desmont McCallock

---

Edited by: Desmont McCallock on 29/04/2009 07:39:51

Found some faults in the T1 Production.
- Iteron III and Iteron IV must switch Material Bills with each other.
- Magnate is missing from the list.

---

Originally by: Mirena Bauler

---

Originally by: Commander Phoenix

---

I just found out before coming back here that Evemon doesn't work with that character any more either. Although for this character Evemon works fine. Will have to look into it some more later.

Thanks for looking into my problem :)

---

I've got the same problem. On 2 of my accounts one of the characters doesn't work in evemon (says cached) and the same characters also don't work in this spreadsheet.

---

Originally by: BlackChii

---

I would like to see ice added to the corp mining ops for POS fuel

---

Originally by: Jolinar malkchour

---

Hi :)
Nice work, however, i have a question :

When setting all mining skills to 5, and all bonuses to 5 (with orca), i have a cycle time on a T2 fitted Hulk of 149.76sec with your sheet. Why that result ? ingame we reach 138sec cycle time with indus command ship 4 (and even less with a rorqual, obviously).

Also, you request in your sheet to have cybernetics 5 for the mining foreman midlink, however, the miner doesn't have to plug this implant, it is the bonus dealer :)

So maybe i did something wrong :)

---

Originally by: Sir Avalanche

---

phantom ghost - Did you get yours to work? I am getting the same errors below: and I have checked every box I can find to enable everything - No security basically.. :) But get the following:

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

Log File:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error034480_05.xml</logFileName>
<summary>Errors were detected in file 'C:\Documents and Settings\dmcgirt\Desktop\EVE\Dedaf's industrial tool 11,3,2.xls'</summary>
- <additionalInfo>
<info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info>
</additionalInfo>
</recoveryLog>

Running - Office 2007 SP2


thanks for a great tool

---

Originally by: strike18

---

i dont undertsand location of back up. do i have to download xml of my char and put on hard drive?

---

Originally by: Meoneta

---

I love this! I cannot find, however, to save my dear life, where on the T1 production to get the Warp Disrupt Probe Launchers or Warp Disrupt Field Generators....please2help!

---

Originally by: Lovebot

---

Erebus Titan Part numbers seem to be completly wrong, is it possible to change those myself to the correct figures ?

---

Originally by: Saxxon Baru

---

Awesome! Can you make your sheet cleaner?
I saw ther alot name as test, your name, etc..

I want get clean and try working it to myself.

Thank you, well done!

---

Originally by: Austin John

---

Edited by: Austin John on 15/07/2009 22:11:38
Strip Miner I's required minerals are all wrong. I just spent a small fortune buying minerals thinking I would make millions, when in fact I now just have a lot of over-priced ore.

If this items mineral requirement is so far off, how can I, or anyone for that matter, have any trust in this spreadsheet?

Please, double check your BP's after updates.

---

Originally by: MARS VICTOR

---

This is really a very nice spreadsheet, quite nifty.

I just have one feature request, but it is probably a big one

It would be truly great if the spreadsheet had an option to, via the API key, import the Corporation inventory / stocks for prints and resources.

Ideally as two seperate functions:
- import corporation blueprints and insert those as owned with me and pe variables into the sheet
- import corporation mineral and/or other resource stocks so those can also be inserted right away

---

Originally by: Konstructus Primus

---

A really great tool, thx for that. But i got a problem, wich i don¦t know if i did something wrong or the program just is not made this way...

If i go to the T2 Prod Sheet, i cannot go in the search List for any T2 Product ? Where do i enter the product to calculate the production for ? Do i have to do something in preperation or what ?
Thx for help...

---

Originally by: Succorbenoth

---

Is there any plans to add a alchemy spreadsheet to this amazing download?

---

Originally by: beldonuin

---

I have v11.3.5 which is brilliant thank you
one small problem, when it updates it looks for backup files and fails
also it defaults to c:\ even though i have changed backup location
T3 production:
one other small problem is when i set the items to 0, there is still 290mil on the build price
T3 production sheet
there is an error that comes up in cells d18-26, it cannot default to a space it must default to a number, change "" to 0 please
T3 production - subsystems
sorry am a bit confused, the items and numbers shown are they purely for a hull build??
it would be nice to see a different box for each subsystem build items then
thanks

---

Originally by: Black Intent

---

great tool, update the help manual- way out of date, some of the things its refers to are not even existing anymore.

---

Originally by: Aewen

---

Hi, i m new to EVE and just found your sheet, it s an awsome tools !
Thaks for your work

i have a few request to improve it, it would be great to add the volume of productions, ideal for hauling :)
in the data i would like to add ore prices, so i could compare in the mining sheet sellinf veldspar vs tritanium for exemple :)

---

Originally by: Sidrat Flush

---

download my spreadsheet there you will find all the T2 blueprints available, of course it's formatted differently, alternatively I could make the Access database available that includes the queries I use to obtain the data.

---

Originally by: licht dark

---

is there going to be a update for the new rigs to?

---

Originally by: REFINERALTINNIT

---

It says the macros in this sheet arent safe and you need to change your security level or have the macro signed?
What do I do?

---

Originally by: Troya McArthur

---

Thanks for all your effort - would you like isk or RL money for donation?

Cu, Troya

---

Originally by: Cmlp

---

hi
Excellent work !!
But i have an error 438 (VBA) when i want to update my skills or price .
What do i do ?

---

Originally by: Kadar Ladesh

---

could you add the 5% and 10% variants to the Ores section so people know how much of the variants to mine? or is it as easy as i think it is and -10% to the amount....

---

Originally by: Petter Dol

---

Edited by: Petter Dol on 17/09/2009 14:19:37
sorry to mislead you with that, i ment the Ore tab which takes values from production and tells you the time, money, and amount of which ores to mine.
(its kadar ladesh here)

---

Originally by: BlackChii

---

For group mining ops can you put in a way to divide the ore mined with different percentages for miners hualers other and combat since each different ship is needed for mining ops in low and null space

---

Originally by: Myrchana

---

its a nice tool, but my english is not os good an i have som problems with the manual.
Also i dont found the calculation for t2 Productbuildiung(T2 Mining crystals or t2 rigs)
And the sync for the api to get the Skill- and Posdata dont work atm. is ist a problem by CCP?
thx for you help

---

Originally by: WongKar Wei

---

Edited by: WongKar Wei on 21/09/2009 20:06:07

What I'd like to do is plug in 'I wanna build 5000 runs of Antimatter Charge M, what do I need and how much profit am I going to make?'

---

Originally by: Valendi

---

Thanks for hard work :)

I have strange error -> T2 production sheet count wrong quantity of component if you want build more then 1 unit.
Ie 113 (needed for 1) x 4 (production) = 452, but excel show 450 only



Spec: Vista ultimate + MS office 2007 (also when i open file there is some error in formating that is removed)

---

Originally by: Valendi

---

As i see T2 cost of BPC is ignored in build price (no change whatever price you add), also BPC run number do not effect anything. Just minor problem as it is easy count it memory :)

---

Originally by: Noonxo

---

I don't know if it has been highlighted yet but there's a major error in the Rig Production sheet.
Mats needed for when changing Material Level of the BPO aren't truncated as they should be ; this result in incorrect needs when multiple runs are selected.

eg.: Medium Core Defence Purger I, ML2, Prod. Efficiency II : 24 Burned Logic Circuit, 24 Tripped Power Circuit, 9 Ward Console (10 on Dedaf's but I need only 9 on my BPO's Show Info in EVE for 1 run, another bug but I don't know where it comes from); 20runs
Materials needed : 475 BLC, 475 TPC, 190WC
As each run is independant of the others, it uses 24/24/9 * 20 = 480/480/180 respectively and not 475/475/190 like said.
Anyway, just wanted to help if it can improve this awesome tool :)
Thanks again for it

---

Originally by: billybobob

---

I think I'm being stupid...I can't really see where I'm supposed to enter the material needed manually. It seems the cells are locked. Could you please go into some more details?

Other than that...this is a great spreadsheet!

---

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

---

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.

---

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?

---

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.

---

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

---

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

---

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?

---

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.

---

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

---

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.

---

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

---

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 :)

---

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

---

Originally by: Brosef Mojitos

---

Thanks for all of your hard work Dedaf and very much appreciated :)

---

Originally by: Canal

---

Edited by: Canal on 13/12/2009 19:25:48
POS Production tab Import Corp Tower dosen't import the corp pos that helps keep track of the fuel besides going out there to check it out
T1 Production tab Productions Need dosen't addup the minerals needed to build the ships setup

Ore tab i sent a amount i needed to get to build something and it's not telling me what is missing

---

Originally by: Mandy Moo

---

I get some errors on the Jump Freighter page. Firstly selecting to build a Nomad gives BPO/C not found over the component parts ( Deflection Shield Emitter, Electrolytic Capacitor Unit etc. ) which leads to an inaccurate build cost. Also on that page the graphics for the T2 components are out of place being aligned right and displaced down 1 row.

---

Originally by: Fatal Reality

---

Hi Dedaf,
I know your working very hard on getting the latest version done but do you have any rough idea on ETA? before the new year? or later? as many of us have been waiting since 1st dec for it :)
Kinest Regards,
Fatal

---

Originally by: Viperb0y

---

Hi,
i relly want to use your tool and downloaded the MS Office 2007 trial. After I opened your file in Excel I get the following:
"This workbook has lost its VBA project [...]"
After this nothing works :(

---

Originally by: caddycarrouf

---

Edited by: caddycarrouf on 25/12/2009 09:46:05
Hi, Dedaf !

First thanks you for this awesome sheet, i couln't go without it these days for all my production awesomeness :)
I've noticed a small problem in the last release, it seem that the data for the small energy grid rigs are not here (i get 0 material needed) for any rigs under this category, i'd hoped it would reflect that ingame (kiddin' :p) but no luck

Thanks in advance for any fix and merry X-mas m8 !

---