| Author |
Topic |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.07.16 08:58:00 - [ 1] - Quote
Edited by: Dedaf on 29/10/2009 20:39:25Hi I have build a sheet to calculate the ore/ice amount mined and its ISK value, using todays prices, directly imported from EVE-Online's web page. 2nd this sheet contains at nice calculator for reaction and fuel need for POS's and 3rd, there are both T1, T2 & T3 and Jump freighter and capital Production sheets in the file. Latest: The T2 production sheet has been changed to t2 Ship production, and you can now select all t2 ships from a drop down menu. 2nd i have now added a backup and restore funktion to the T3 production sheet. Download: Version 11,4,3a HowTo manual 1,6In this sheet you will find the following calculators: Ore Mining
Ice Mining
Ore to mine, calculated from mineral-need
Ice to mine, calculated from fuel-need, from version 10,4
Ore Corp Mining calculator. from version 10,6,3
Ice Corp Mining calculator. from version 11,3,2
POS Fueling/Reaction
Rig Production
T1 BPo/c Production
T2 BPo/c Production, from version 7,6
Tech III production, from version 11
Capital Production
Jump Freighter production, from version 8To upload your oven skills to this sheet, do like this. 1st. log in to this forum 2nd. click this link APIKEY site3th. Enter the ApiKey and UserID in to the sheet, then click update. Thats it The XML price and skill update is supported only in Office 2003-2008 Pro.Open office do not support direct XML updateAnyway let me know what you think of it or maybe even new idea's, ofcause isk donations is always appreciated  enjoy NB: Dont Update prices every 5min, then you will be blocked by the firewall. Ones a day should be enough. |
PauZotoh Zhaan
Aliastra
|
Posted - 2007.07.16 23:50:00 - [ 2] - Quote
Edited by: PauZotoh Zhaan on 16/07/2007 23:57:56
Edited by: PauZotoh Zhaan on 16/07/2007 23:54:08
Very nice, gr8 work:)
|
Gojyu
Ever Flow
Axiom Empire |
Posted - 2007.07.17 10:29:00 - [ 3] - Quote
Edited by: Gojyu on 17/07/2007 10:30:37
Sorry, maybe I'm missing something, but how do you change your skill levels? seems the purple cells have been locked, I understand the putting the xml in the c:, but is it possible to manually enter values for the skills? |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.07.17 11:00:00 - [ 4] - Quote
If you have saved the xml.xml file on your c:\ drive then it should just be a matter of clikking update in the sheet. But i hear for others running Office 2k that is doesnt work, im running office 2003, it seems that XML are not supported in office 2k.
Maybe other in here know how to solw this?, maybe there is a update for office 2k that can fix that.
|
Ghostmistress |
Posted - 2007.07.17 21:43:00 - [ 5] - Quote
xms is possible in 2003 version, but its hard to apply |
Bushgallam |
Posted - 2007.07.18 10:31:00 - [ 6] - Quote
nice work!
request: I fit up to 4 mining upgrades in my Rokh, but the drop down box only allows 0,1 or 2.
I'd actually like to have all fields editable (like minerals prices and such)... |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.07.18 11:40:00 - [ 7] - Quote
 Originally by: Bushgallam
I'd actually like to have all fields editable (like minerals prices and such)...
I dont think i will make all fields editable, since most cell's have some kinda formula, but you are able to edit the auto updated fields if you got to the DATA sheet and change the prices/skills from there. I will make sure you can select 4 mining Upgrades in the next version  |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.07.19 07:09:00 - [ 8] - Quote
Edited by: Dedaf on 19/07/2007 19:23:03
New version
|
Cryos Ylwan
Pilots Of Honour
Axiom Empire |
Posted - 2007.07.19 22:42:00 - [ 9] - Quote
This looks really great, but as has been said before, unfortunately the XML thing seems to be not working properly on some Office versions.
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. |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.07.20 05:01:00 - [ 10] - Quote
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.
Bugger, you are right they used the same skill ID, it has been fixed now. thanks |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.07.22 19:33:00 - [ 11] - Quote
New version |
sonofapharmacist
Hard Corp
Brotherhood Of Steel |
Posted - 2007.07.22 22:38:00 - [ 12] - Quote
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? |
Nashime
Gallente
Aliastra
|
Posted - 2007.07.23 03:40:00 - [ 13] - Quote
I'd love to be able to use this, but it's not working with Open office.
|
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.07.24 15:55:00 - [ 14] - Quote
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?
New version |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.07.31 15:29:00 - [ 15] - Quote
new version |
Alaris Nightshadow
Dark Star Corp
Severed Hand. |
Posted - 2007.07.31 20:52:00 - [ 16] - Quote
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)
Also on the left side The missing Isotopes does not update when you change the in stock value |
Actanna Levh
Minmatar
Utopian Research I.E.L. |
Posted - 2007.08.01 04:35:00 - [ 17] - Quote
A very interesting document.
I am more interested in markets than mining and found how your ‘data’ page takes automatic updates from eve-central particularly clever. I tend to manually look up eve-central for data for 18 T1 type salvage components, datacore prices and minerals every couple of weeks, how foolish I am.
Anything you could do to extend those updates on that page I think would be great.
(R.A.M though I don’t think is needed as they can be manufactured by yourself)
|
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.08.01 06:58:00 - [ 18] - Quote
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)
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? But you are right about the left side Missing Isotope update, i will correct that in a later version. But the Right side is showing the correct value. |
Alaris Nightshadow
Dark Star Corp
Severed Hand. |
Posted - 2007.08.01 13:46:00 - [ 19] - Quote
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?
You were right,I had missed a Zero in the power grid update. ^_^ |
demonfurbie
Minmatar
Covert-Nexus
|
Posted - 2007.08.06 00:38:00 - [ 20] - Quote
i dont see small tower listed in the pos fuel calc |
Malik Travesh
The xDEATHx Squadron
Legion of xXDEATHXx |
Posted - 2007.08.06 01:19:00 - [ 21] - Quote
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. |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.08.06 06:37:00 - [ 22] - Quote
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.
i think its cause i dont have the skill myself but if you enter the skill id 12183 then it should work. if there are other skills missing then you can find the ID in EVE online's Item database, just hover the picture of the skill you want. Originally by: demonfurbie
i dont see small tower listed in the pos fuel calc
I might add the small towers in later, i build the sheet for calculation reactions so the small is not an option there. But an idea could be to make a LAB/Moon mining calculation useing small towers. i will do some thinking about that  |
Mr Bondy
The Hoodie Mafia
Cosa Nostra. |
Posted - 2007.08.07 11:07:00 - [ 23] - Quote
This is one of the nicest eve tools ive seen, i just entered my skills into the 'data' table and it only took 3 mins The fact that it deals with the ganglinks makes it even better. Thanks alot |
Biggizmo
Gallente
New Earth Inc. |
Posted - 2007.08.08 10:13:00 - [ 24] - Quote
Edited by: Biggizmo on 08/08/2007 11:04:07
indeed a verry nice sheet.
lots of work in here. verry verry nice job.
wired 5m for this one :)
thanks |
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.08.13 09:39:00 - [ 25] - Quote
New version 6,0,1 Now with a Production calculator sheet, for calculating price and mineral use when building T1 ships and items. let me know what you think |
Shinris
Gallente |
Posted - 2007.08.15 22:30:00 - [ 26] - Quote
xml doesn't seem to work is there anotehr way to enter your skills.
|
Dedaf
Gallente
United Brothers Of Eve
Zenith Affinity |
Posted - 2007.08.16 04:49:00 - [ 27] - Quote
Originally by: Shinris
xml doesn't seem to work is there anotehr way to enter your skills.
Its because you use an old version of Excel, but yes in the DATA sheet, before you make the first XML update (which in you case dont work) there are all the related skills just change them manualy, then it works. |
Zent |
Posted - 2007.08.16 23:21:00 - [ 28] - Quote
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 |
Tramp Oline |
Posted - 2007.08.17 03:38:00 - [ 29] - Quote
Modify the cpu value to the left of the error message. The spreadsheet comes with values already in there and when you changed the tower type the value entered for the cpu is higher than what the tower supports. 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
|
Koyu Ryoko
Perkone
|
Posted - 2007.08.17 22:56:00 - [ 30] - Quote
I cannot for the life of me figure out how to import my skills into this excel file.... |
All Channels
Screenshots & Art
