Pages: 1 2 3 4 5 6 7 8 [9] 10 11 12 13 14 15 16 17 18 19 20 .. 28 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Spartus Raile
Gallente Distinguished Gentleman's Boating Club Burning Horizons
|
Posted - 2008.12.06 19:29:00 -
[241]
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 --- Warning:,Veldspar can seriously damage your health and mental wellbeing. Do not place Veldspar over your head. Do not ingest. If Veldspar makes contact with your eyes, rinse immediately |
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.10 07:18:00 -
[242]
Edited by: Dedaf on 10/12/2008 07:23:47
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.
Yes you are right, at this time the Profit pr hour is only for Small towers. I guess i could make an option to select if you want to calculate the Moon mining profit for M and L towers aswell.
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
Good to hear you got it working, i havent been able to test 2008 myself yet, so im glad to hear its working in that version aswell.
Thanks to everyone for the nice words. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Sidrat Flush
Caldari Life is Experience Rally Against Evil
|
Posted - 2008.12.13 16:21:00 -
[243]
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.
-------------------------- Life is about memories the more the better.
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.14 11:41:00 -
[244]
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.
I have tried to import the inventory, but its a total mess, and i havent been able to make real search and lookup in all that imported data. so i have no plans about doing it in a near future.
About the T1 production, you are right, then How To Do manual which tells about T1 production sheet is out of date :) i resently rebuild the T1 Production sheet, you no longer have to inter the minerals your self, you just select the T1 blueprint from the drop down menu.
I do not use Vista myself, so i can not explain why you cant get the backup to work, but iw seen others use Vista where it works, so it should be possible.
New version 10.8.3 the main diference here is to the POS production sheet. You can now calculate tower incom for all types of towers, not only for the small like before. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
ZiggyMeister
|
Posted - 2008.12.15 17:31:00 -
[245]
Hello Dedaf.
Thanks for this precious help :D
I'm posting here cause I think I found some inaccuracies in a few BPO's mineral need that I own: EMP M + Phased Plasma M + all Cruise Missiles (except Cataclysm BPO), they lack some need of Isogen and Mexallon on some of these BPO's...
Where do you got the info on the material need for the BPO?
Thanks.
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.15 17:52:00 -
[246]
Edited by: Dedaf on 15/12/2008 17:58:04 Hi ZiggyMeister
Thanks for the input. I have just checked, and i dont see anything wrong with the BP that you mention, other than the EMP M, cruise missiles seems ok to me?
what exact mineral is it that are missing?
the BPo information was imported from EVE-online database, but some of it is outdated, so ill be happy to correct the ones that are wrong, but wont check them all. I will ofcause correct the ones that you guys find.
thanks ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
ZiggyMeister
|
Posted - 2008.12.16 10:55:00 -
[247]
Thanks for your reply and time.
It seems I overlooked the other BPO, besides Phased Plasma M. Thanks and sorry for the mistake.
If I find anymore issues I'll let you know.
|
wibble ipera
Caldari
|
Posted - 2008.12.17 12:12:00 -
[248]
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 ---History is written by the Victors,but i dont know anyone called victor--- |
Vaedon
Roid Ripper Industries
|
Posted - 2008.12.19 15:39:00 -
[249]
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!
Vaedon Jack-of-all-trades...Master-of-none |
Kordel Trask
|
Posted - 2008.12.20 04:48:00 -
[250]
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!
|
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.20 07:33:00 -
[251]
Edited by: Dedaf on 20/12/2008 07:34:18
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
I havent seen that error before, Maybe you could tell which applicatioin you are using and version? ex excel 2003 or openoffice?
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!
First of all thank you very much for the nice words, its always nice to hear that people like someting that you put alot of time in to build Also thanks for the bug reporting, i have corrected them in the version im working on now, which i will upload soon.
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!
About the skill name, then it doesn't matter that it only show skill, all that the sheet needs is the skill ID, so if you can import the skill then the sheet will handle the rest. So its not a bug.
The API can be both limited or full key. for now you wont get any more features using the full instead of the limited, because all it does is import characters and skills. But im working on a new version where the POS production sheet can import your Tower's and its fuel, so you can keep track of when your tower runs out of fuel, from out of game, when i release that version then you will need the Full API if you want to use that feature.
thanks again to everyone for there comment's Dedaf ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.22 11:55:00 -
[252]
New version 10,9
This version include a POS tracker, to monitor your towers fuel. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Lady Flashheart
|
Posted - 2008.12.24 19:50:00 -
[253]
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
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.25 12:48:00 -
[254]
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
yes i have forgoten about them.
please add the lines below, in to your sheet: Skill name & Skill-ID Electromagnetic Physics11448 Electronic Engineering11453 Graviton Physics11446 High Energy Physics11433 Hydromagnetic Physics11443 Laser Physics11447 Molecular Engineering11529 Nuclear Physics11451 Plasma Physics11441
I will make sure to have them in the next version.
------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Lady Flashheart
|
Posted - 2008.12.27 08:41:00 -
[255]
^^
Legend !!
tyvm
LF
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.27 09:55:00 -
[256]
ah sry about that. You can either download the version 10,9,a that i just put up, where i have added them to the list of pre entered skill's in the data sheet. Or you can simply add them your self and safe you the hassel of redownloading the sheet again. the ID's are as followed
Mechanical Engineering11452 Gallentean Starship Engineering11450 Amarrian Starship Engineering11444 Minmatar Starship Engineering11445 Caldari Starship Engineering11454
There are no other change in this version than this, compared to 10,9 so no need for otheres who uses the auto API, to download the 10,9,a if you have the 10,9 already.
Marry x-mas ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
BlacX
|
Posted - 2008.12.30 05:41:00 -
[257]
Hello, I am very new to excel and to eve. How do i enable excel Macro for just this file and not for every file? Every time i try to run the sheet i get told macro is not enabled, and i only want to enable for this sheet but see no options in excel for it.
Please Help Thanks in Advance BlacX
|
BlacX
Republic University
|
Posted - 2008.12.30 06:12:00 -
[258]
Originally by: Dedaf 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.
Ok forget that problem i simply moved the file to the trusted folder.
But i have a new problem when i went to update mineral price it starts to update then at about 85% i get an error that says "c:\t1_production_backup.xml" , "Data Source not found" where do i get that file from or is it a excel programming issue?
Thanks BlacX
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.30 07:25:00 -
[259]
The file it is asking for is a backup file. Its is used to store all your BPo/c information that you entered in the T1 Production sheet. Since it is the first time you use this sheet that file has not been generated yet. Go to the T1_Production sheet and click backup even though you havent entered any BP's yet, this will generate a backup file on your C:/ harddrive.
About the macros, you just have to set security level to Medium, then a pupop will ask if you want to enable micros or not when you open the excel file.
I hope that helps you ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
BlacX
Republic University
|
Posted - 2008.12.30 19:46:00 -
[260]
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: Dedaf The file it is asking for is a backup file. Its is used to store all your BPo/c information that you entered in the T1 Production sheet. Since it is the first time you use this sheet that file has not been generated yet. Go to the T1_Production sheet and click backup even though you havent entered any BP's yet, this will generate a backup file on your C:/ harddrive.
About the macros, you just have to set security level to Medium, then a pupop will ask if you want to enable micros or not when you open the excel file.
I hope that helps you
|
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.31 08:58:00 -
[261]
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
I have never seen that before. If your skills are not correct then its a trubbel with your API, the sheet does not modify the imported data. All it use it for is to lookup the skill ID's and then use that corrosponding lvl somwhere in the sheet. If you are thinking about the names compared to what is pre entered then skill names are changed to "skill" but its not a problem since the sheet looks for the skill ID.
I would like to see your sheet, just import the skill's remove your API key and other info you find privat then send it on a mail to me. Mail me ingame for my mail if needed.
happy new year to everyone. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Pwett
Minmatar QUANT Corp. QUANT Hegemony
|
Posted - 2008.12.31 17:48:00 -
[262]
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" />
_______________ Pwett Founder <Q> QUANT Hegemony
|
Weshta
|
Posted - 2008.12.31 18:26:00 -
[263]
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.
I will send you my char.xml when i get your email.
Thanks for your Help Blacx
Originally by: Dedaf
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
I have never seen that before. If your skills are not correct then its a trubbel with your API, the sheet does not modify the imported data. All it use it for is to lookup the skill ID's and then use that corrosponding lvl somwhere in the sheet. If you are thinking about the names compared to what is pre entered then skill names are changed to "skill" but its not a problem since the sheet looks for the skill ID.
I would like to see your sheet, just import the skill's remove your API key and other info you find privat then send it on a mail to me. Mail me ingame for my mail if needed.
happy new year to everyone.
|
Raaz Satik
|
Posted - 2009.01.01 03:53:00 -
[264]
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)
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2009.01.01 11:18:00 -
[265]
Edited by: Dedaf on 01/01/2009 11:23:06
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
This is not a bug. It is because Mining forman, Mining Director and warefar link are Gang skills, it is therefor not always you who give the bonus,and therefore they are not updated via the API key, you need to set them manually to give the most precise mining yield. othervice it would not show right. Basically all purple fields are API updated skills, all blue fields are unlocked fields for you to change manaully. I hope that helps you
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" />
I dont know what a unpublished skill is? so the sheet wont know to use a different skill ID if thats what you are asking. But if your question is related to the abow one then this is not the problem.
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)
I will make sure to look in to this, but i dont think i will add the micros, since all micro BPo has been removed from game, and only the ones players have exsist. If those are t2 items or for some reason needs other t1 moduels then i will remove them i think, but ill look in to that and correct what i can in the next version. thanks for the bug reporting.
thanks all of you Dedaf ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Erica Vairland
|
Posted - 2009.01.03 14:43:00 -
[266]
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. :) |
Raaz Satik
|
Posted - 2009.01.03 23:16:00 -
[267]
Originally by: Raaz Satik T1 Production is missing- ECM - Multispectral Jammer I
- Industrial Core
- Most of the "micro's" (Smartbombs, Shields, Armor etc)
Also- Capital Tractor Beam
- Covert Cynosural Field Generator I
- Covert Jump Portal Generator I
|
Mordachai Seghar
|
Posted - 2009.01.05 15:54:00 -
[268]
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
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2009.01.06 14:16:00 -
[269]
New version 10,9,2
With the following items added to the T1 production sheet:
- 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
Thanks a lot. There are no pree entered T2 items in this sheet. I do however have a T2 Production sheet included, but you need to enter the material manually.
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. :)
Thank you very much, and yes you are right, it was missing. Though it is not a basic T1 item, and therefore needs other material than just minerals, my sheet does not add those in the calculation.
Enjoy Dedaf
------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Lpi Landis
|
Posted - 2009.01.08 05:27:00 -
[270]
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 |
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 [9] 10 11 12 13 14 15 16 17 18 19 20 .. 28 :: one page |
First page | Previous page | Next page | Last page |