Author |
Topic |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.10.26 17:19:00 - [ 211]
Thanks alot i guess i missed one  it should be ok now in this new version |
 Sir EkeEkeFtang
|
Posted - 2008.10.26 17:37:00 - [ 212]
Thanks...your timing is perfect...one nomad in the oven  |
 Braendig |
Posted - 2008.11.08 20:05:00 - [ 213]
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?
|
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.11.10 11:08:00 - [ 214]
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?
Normally i would say that it is you macro security level that are too high, you should set it to medium. But since you do get the question about using and not using macros, then i have no idea what it could be. Maybe the macro's has been removed due to accidental saving when the macro lvl was too high? So make sure the macro lvl is set to Medium, and then redownload the sheet from the web and try again. I hope that helps you |
 Bulli Jo Knights with Honor Circle-Of-Two |
Posted - 2008.11.12 02:09:00 - [ 215]
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.
|
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.11.12 06:08:00 - [ 216]
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.
Sounds very interresting, im always interrested in listening to new idear's so ill contact you when i have some time. new version 10,7,5 is up with the new capital Orca ship and its bonus's for mining ice and ore |
 Eraseri |
Posted - 2008.11.12 15:48:00 - [ 217]
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 |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.11.12 16:08:00 - [ 218]
Edited by: Dedaf on 12/11/2008 16:14:09 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
It seems that after the new Patch, that they have not opened up for API updates. So we all have this problem  i hope they will fix it soon or open it again, what ever they need to do. The reason why the import mineral prices work is because they are not imported from EVE-Online directly, but imported from Eve-central.com |
 Raban Black Aces |
Posted - 2008.11.12 16:14:00 - [ 219]
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? |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.11.12 16:16:00 - [ 220]
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?
Yes it should be in the sheet, if you download it. Just dont click import skills, because that will delete all the preentered skill's So inshort, download it again and scroll down on the Data sheet, before you click skill update. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.11.13 13:03:00 - [ 221]
The APIkey skill information can now be updated again  i have just tested it. Enjoy |
 Braendig |
Posted - 2008.11.14 06:15:00 - [ 222]
nope macro security not the issue, its set at medium.
I have other spreadsheets that I have with macros as well, and they are functioning just fine.
|
 Braendig |
Posted - 2008.11.14 06:19:00 - [ 223]
oh duh... I found the issue.. using mse 2k lol
didnt even dawn on me to check! |
 KevSC7 |
Posted - 2008.11.20 20:04:00 - [ 224]
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 |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.11.21 07:41:00 - [ 225]
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
Yes you are totally right, im amazed that i'v never noted that myself. thanks for the feedback. I have corrected it and will upload the new version soon. Thanks to Bulli Jo, this new version will have an all new T1 Production sheet, where you can select all of todays T1 BPo from a dropdown menu, which means you wont have to go and lookup mineral req. for the BPo in the item-database anymore. Dedaf |
 Bulli Jo Knights with Honor Circle-Of-Two |
Posted - 2008.11.22 01:53:00 - [ 226]
Glad to help in some small way. You've definitely put some love into this and it shows. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.11.24 20:17:00 - [ 227]
New version 10,8
The major change here is the new function in the T1 Production sheet. You are now able to select all ingame T1 BluePrints from a DropDown list.
The complete Blueprint list was provided by Bulli Jo, thanks alot for the help. |
 spyor |
Posted - 2008.11.25 16:52:00 - [ 228]
This may be a silly question, but do we only need to use the limited api key on your indy tool. and if i used the other would it pull my minerals qty automatically or not? Hmm thinking allowed now, possibly not, there will be multiple locations where minerals could be. It was only a thought. Also you have very nicely done the T1 production now, with drop downs. Is Bulli on with T2 now for you? /me wishes had time and patience!!!  Really like your tool, it dont crash likes one of the others I would like to use.  |
 smileynz Gallente Sons Of Alexander
|
Posted - 2008.11.29 21:05:00 - [ 229]
Great Spreadsheet. Well done bro  . Nice and easy to use |
 gallminin Gallente White Star Line 2010 DEM0N HUNTERS |
Posted - 2008.12.01 02:48:00 - [ 230]
dont mean to be a pain but, you spelled zydrine wrong...eveywhere you spelled it with no r.. :] i just realized there was a r in it a couple weeks ago and iv been playing for 2 years |
 Mikal Bishop Gallente Iron Anvil Industries Violent Entity |
Posted - 2008.12.01 19:09:00 - [ 231]
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. |
 Mister Xerox |
Posted - 2008.12.01 19:25:00 - [ 232]
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.
*LOL* Dontcha know it! I used to have 1 spreadsheet that I built for my production managment. Then I went on vacation... no access to my comp, no access to the game, so only able to surf the forums... ... picked up no less than 7 (seven!!!) new spreadsheets and apps to incorporate once I get home. Some of them with some spiffy interfaces that I have not a clue how to set up. |
 Luke Lor'aul New Eden Association
|
Posted - 2008.12.02 06:34:00 - [ 233]
What do you use to update your prices? EVE-Central API? Market Exports? |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.12.02 09:19:00 - [ 234]
Thanks for all the nice words, and also for the bug reporting.
i will correct the errors and upload a new version soon.
Here are some answers for the questions a bow.
About the API key, all you need is the limited version, the only thing that the sheet imports are the character names and the skills. So using the advance API key won’t give you any other information than the names and skills.
Some time ago i tried to see if it was possible to get the sheet to import you items in stations, but it brings in too much unneeded data and i didn’t find a really good way to sort it. so I dropped that idea again.
About the price information, it is all import from EVE-Central.com
|
 Evo Mannerheim m3 Corp
|
Posted - 2008.12.02 14:38:00 - [ 235]
Edited by: Evo Mannerheim on 02/12/2008 14:40:27I'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? Please visit your user settings to re-enable images. |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.12.02 14:45:00 - [ 236]
Edited by: Dedaf on 02/12/2008 19:08:13 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?
Its the HTTP://Eve-central.com webpage that are down. Edit: Webpage is up and running again, so you can update price information again. |
 Viculus Organic Combined Industries |
Posted - 2008.12.03 19:06:00 - [ 237]
Just started to look at this app, and think I have found a problem.
Fist though. THANKS!
Very nicely done, and I for one appreciate a tool like this that makes use of a standard spreadsheet package. I have also had a lok at EvE-MEEP and find it to be a bit arkward to use. The way you have used sub-categories ('Type') makes finding some things much easier, although I personally would prefer yhe 'Type' to be sorted alphabetically. I have quite a few bp's and am reluctant to spend the time entering data manually into EvE-MEEP when that inforamtion is not easily accessable/retrievable by me. I hope to use your app for a similar function.
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 |
 Dedaf Gallente United Brothers Of Eve S E D I T I O N |
Posted - 2008.12.04 19:31:00 - [ 238]
I have just uploaded a new version 10,8,1 It contains the corrections mentioned abow and a few more minor errors. 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
Yes the Items has been imported from the Item database. Tbh i thought the Items that was on that database was updated but i guess thats not the case. I will however not go trough all the item and check if they are correct. But ofcause i will try to correct the ones people find. So the Armor hardners has now been corrected. Thanks for you comment's Dedaf |
 Seth Ruin Minmatar Ominous Corp Circle-Of-Two |
Posted - 2008.12.05 19:34:00 - [ 239]
Originally by: Dedaf I have just uploaded a new version 10,8,1
I just want to say thanks for making this spreadsheet! I use it all the time.  |
 Legionos McGuiros Caldari Legio Prima Victrix Imperius Legio Victrix |
Posted - 2008.12.06 18:52:00 - [ 240]
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. |