Science & Industry

Hi Azz
I could be possible to list, but the API cant see the difference of a original or copy blueprint and it does not contain the ME nor PE information either.
So it is not a list, that would be of much use.

So I like the concept of the shopping list, this something I painfully always add to new version of the spreadsheet, is there a way that you can add additional sheets that can get counted in this function. For example, for T2 Items, i have 7 pages (3 items per page) in my copy of the spreadsheet. When I tested duplicating the default page, it did not get reflected in the shopping list. Is there a more appropriate way of adding pages?

Scorpio

Hi Azz
No i cant see any easy way to export that, as you dont get any names from the API. You get just typeID's and then you have to convert it to names. So it will be pretty intense work, and still you need to do a lot of manual work.


I'm afraid it is not so easy as just copy paste. But im happy you think so, as this is how i want my tool to be and look.
Even if the shopping list look simple it is pretty complicated calculations behind it. So to add more sheets to the list, would mean to reconfigure the tool to include that sheet as well. Id suggest you make a file for each of the 7pages T2 item tool, including the shopping list and Data sheet, then you should get some fairly good lists.



Hi Mandj
I dont believe i have seen that specific runtime error before.
To try and help you, I would need some more info, like version of Excel and so on. It would also be good if I could get a copy of the file with the API and runtime error, so i could try it out myself.
You could also try to read FAQ 6, 7 & 8 here, to see if that solves the problem for you?
If not, then please contact me in game, then we can try to see what we can find.

Thanks to all of you for your feedback
Dedaf

Hey Dedaf,

Thanks for this amazing tool. I might be think though but I can't find an option to do the following.

I want to invent and build a t2 ship. I build all of the t2 components for the ship. However, when I enter the ME for the component BPOs and go to my shopping cart it lists both the actual components and the moon materials that are used to produce said components. Any way I can change that so it just lists the moon materials?


Edit: Also, can you choose what materials you manufacture (as in buy or build)?

Cheers!

Hi Dedaf,

Thank you so much for developing this tool! I'm a first time user, and I'm having trouble with the API/character import. I followed the instructions in the PDF and the FAQ, but it still won't recognize my character. I have tried manually entering the character name and updating, and I have also tried just using the API and KeyID, but the drop-down box is blank.

I'm using Excel for Mac 2010 Pro on a Macbook Air. I don't think that has anything to do with it... but the only thing I have tried to do is set up the Data page. I have not modified the backup or restore locations.

Any help you can offer is appreciated, thanks!

Im afraid it is the Mac, i have not had anyone using a mac, saying that it works. There seem to be some difference in the way the Microsoft VBA works on a Mac and PC.
I do not have any Mac products myself so i can not try it out.



No, as it is now, there are no way to select if you buy or produce the components yourself. The sheet expect that when doing T2 ship production, then you also build all the components yourself.

Happy New Year

Awesome tool sir! Very well done.

I just wanted to say thank you.

Hey Dedaf I cannot seem to get the API lookup to work. I have run through the FAQ I am using the following:

Win 7 Pro X64
Office 2007 (fully updated )
Macro's enabled ActiveX allowed

I keep getting the following:

Run time error '-2147217376(80041020)': XML Parse Error

I have tried the options listed in FAQ 7 but that did not work.

if I leave it blank I get :

Run time error 13 type mismatch

I am not sure what else I can do...any thoughts?

HI Jim
That is strange why you get the error on some systems and not others to me it would be more logic if it didnt work at all. I have tried the system and regions you mention on 2 different machines and office versions, but i dont have any problems updating from any systems or regions. You might have some bug in that file, maybe try to download it again?

Hi Emeki
Only thing i can think of is that your version of Office2007 is not a Pro? or you are saving the file in a folder with restrictions. Make sure you save it in you document folder or follow FAQ6 to insure your macro security isn't blocking the macros from running.

Hi Len Ross
At the moment there is a limit of 50 personal & 50corp hangars (Office & POS), so if you have asset allover in space in more than 50 stations, then you should think about cleaning up a bit.

But the problem about the Office and POS hangars is a bit strange to me, unless, you again have more than 50? But it would be strange if the first 50 hangars was all POS hangars. So here i believe there is a bug in the tool.
I have only tested API keys with 2 Office hangars and another key with 2 POS hangars +1 Office hangar, in those two cases the Office hangars showed up just fine.
But for me to really investigate this problem, then i would need a copy of your tool with the API? but im sure a lot of people would advice you against that.
But feel free to contact me in game, then we can try to find a solution to this problem.



Sorry about the problem you guys have with the office and macros, and sorry i dont have much help to offer you. You are all very welcome to contact me ingame, then we can try to see if we can find a solution. It could be some way you are using the tool that i never thought of. So finding the bugs could help out alot of your other fellow eve pilots.

Thanks again everyone for the feedback.

Double post.
That did the trick mate. Works great. No more stocktaking. Can't thank you enough