open All Channels
seplocked Science and Industry
blankseplocked Dedaf's industrial tool
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : ... 20 21 22 23 [24] 25 26 27 28 : last (28)

Author Topic

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.11.12 10:58:00 - [691]
 

Originally by: Jebrea
Edited by: Jebrea on 09/11/2010 01:42:42
Dedaf its a .XLSM file is what the New verison and the older one is a .xls

Ok so if i understand it correctly, the version you have where the dropdown menu works, the sheet is a .xls?
I have tried to save the latest version in .xls format, so try out if that works for you here

Originally by: Khrysees
I have been trying to open ths all morning using winzip and winrar...neither work. both are saying the file is corrupted.

Errors were detected -- see below for details

Testing ...
Testing Dedaf's industrial tool 12,6,9.xlsm CRC check failed
At least one error was detected in C:\Users\Chris\Downloads\Dedafs_industrial_tool_1269.zip.
any insight?
thanks
I have never seen that problem before. It most be a local problem, maybe your AV is to blame.


Originally by: Brigge Tremdut
Is one able to get this to function with Open Office yet? Honestly, I did not read all 23 pages to find out but since this is a rather long thread in time span, I was hoping that might be true now.
to my knowledge Openoffice still doesnt support direct xml import.
But you should still be able to use the sheet, but you will have to manually enter the skills and price infomation.

Dedaf

Mrs Zwieback
Posted - 2010.11.12 16:27:00 - [692]
 

Have been a great fan and user so far, but the newer versions are giving me huge problems.

My Office 2k10 (Professional Plus) tells me on opening the file: Ecel found unreadable contant in [...] Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

After clicking yes:

Excel was able to open the file by repairing or removing the unreadable contant: Removed part: /xl/vbaProject.bin.part (Visual Basic for Applications(VBA))

it also dumps this recovery file:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error075081_01.xml</logFileName>
<summary>Errors were detected in file 'D:\My Documents\My Downloads\Dedaf's industrial tool 12,6,9.xlsm'</summary>
- <removedParts summary="Following is a list of removed parts:">
<removedPart>Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))</removedPart>
</removedParts>
</recoveryLog>


I even tried installing the comp pack you posted, didnt help much either - effectively, the sheet is broken since none of the price/character import functions are working. My Macro and security settings are all the lowest possible.

Please advice =)

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.11.12 17:59:00 - [693]
 

Thats very strange.
I have now tried on 2 other PC than my own, and it works perfect. one was using 2003 another 2007, on my own pc i have 2010.
So i have no idea where that problem could come from.

J'Poll
Caldari
Borealis Mining Concern
Posted - 2010.11.15 21:22:00 - [694]
 

Just downloaded this XML and have a problem with the skills.

In the XML not the names but the ID numbers are showed. So I can't make out which is which.
I'm using Office 2010 Pro


GVR

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.11.16 23:07:00 - [695]
 

Originally by: J'Poll
Just downloaded this XML and have a problem with the skills.

In the XML not the names but the ID numbers are showed. So I can't make out which is which.
I'm using Office 2010 Pro


GVR
Im afraid that is just how it is, the name of the skills are not included in the xml feed.
But it doesnt really matter, cause the sheet know what to look for.
So everything is working as it should.

priscitta
Posted - 2010.11.21 11:55:00 - [696]
 

Hi Dedaf
Thanks for making this huge tool

Unfortuneatly i encounter an error while trying to update everything:
XML Parsing error: -2147217376 (80041020) while executing

Do you have any ideas for a possile fix?

colonel mode
The Demi-Fallen Ones
Posted - 2010.11.24 04:46:00 - [697]
 

Edited by: colonel mode on 24/11/2010 04:47:45
Originally by: priscitta
Unfortuneatly i encounter an error while trying to update everything:
XML Parsing error: -2147217376 (80041020) while executing


I am getting the same error message at the moment, and so is a corpmate. I'm not sure if this is the proper place to post bug reports, but if you need any more information please let me know.

Thanks for all the work you've done on this great tool!

Caldari 5
Amarr
The Element Syndicate
Blazing Angels Alliance
Posted - 2010.11.24 07:01:00 - [698]
 

Originally by: colonel mode
Edited by: colonel mode on 24/11/2010 04:47:45
Originally by: priscitta
Unfortuneatly i encounter an error while trying to update everything:
XML Parsing error: -2147217376 (80041020) while executing


I am getting the same error message at the moment, and so is a corpmate. I'm not sure if this is the proper place to post bug reports, but if you need any more information please let me know.

Thanks for all the work you've done on this great tool!


I Too am getting the Error
Quote:
Run-time error'-2147217376 (80041020)': XML Parse Error

Running Excel 2007 Professional Plus

Wanara
Posted - 2010.11.24 13:49:00 - [699]
 

Originally by: Caldari 5
Originally by: colonel mode
Edited by: colonel mode on 24/11/2010 04:47:45
Originally by: priscitta
Unfortuneatly i encounter an error while trying to update everything:
XML Parsing error: -2147217376 (80041020) while executing


I am getting the same error message at the moment, and so is a corpmate. I'm not sure if this is the proper place to post bug reports, but if you need any more information please let me know.

Thanks for all the work you've done on this great tool!


I Too am getting the Error
Quote:
Run-time error'-2147217376 (80041020)': XML Parse Error

Running Excel 2007 Professional Plus


I am getting the same error. Running Excel 2010 on Windows 7 64 Bit.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.11.24 22:34:00 - [700]
 

i have no idea where that error could come from.
I have tried to download the files to see if i get the same bug, but no it works fine. Im using excel 2010 ultimate on Win7 64bit.
I tried to Google the error, that doesnt help much.

I will try on a different pc tomorrow, to see if i can get this error you are having.

Caldari 5
Amarr
The Element Syndicate
Blazing Angels Alliance
Posted - 2010.11.25 04:42:00 - [701]
 

Additional information, that may or may not assist in diagnosis

I have tried on 2 different PCs
1st PC is WinXP
2nd PC is Win7x64
Both Running Excel Professional Plus 2007

The File that I downloaded was the one from Eve-Files(Dedafs_industrial_tool_1269.zip)

The only things that I had put into the Spreadsheet, were my Full API, hit Update Skill Data, Select my Character, Select Region Essence, Select C:\ for backup, as there is no D:\ in my Systems(well there is but they are Optical Drives), and then hit Update Everything, Progress bar/window thing comes up, and then get the error.

Cindril
Caldari
Posted - 2010.11.26 12:47:00 - [702]
 

Hi there,

I'm using Excel 2011 on Mac OS, which does support xlsm with the embedded macros and VBA-code.

But when I click on "Update everything" I get a run-time error '438' - Object doesn't support this property or method.

Any ideas? I'm willing to debug this on OSX, so drop me a line if we could work together on this.

zulgol
Gallente
x13
Raiden.
Posted - 2010.12.02 14:07:00 - [703]
 

Will there be a update to add Noctis ?

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.12.03 11:55:00 - [704]
 

Im sorry to say that i can not help you with the error's you are seeing.
I have downloaded the file to multiple PC with different Windows versions like XP, Vista and Win7. also with all of the excel Pro versions going back to 2003, but i do not see the problem you are seeing. it therefore most be some user/right permissions in your systems that prevent you from using the sheet.

Originally by: zulgol
Will there be a update to add Noctis ?

Yep its added in this new version 12.7a enjoy

Gamingloser1
Posted - 2010.12.10 01:49:00 - [705]
 

I am getting the Run Time error'-2147217376 (80041020)': XML Parse Error.

WIN 7 64bit
Office Pro 2010 - Freshly installed today. All macros are enabled and tried both "trust access to the VBA project object model"
Microsoft .NET Framework 4 Client profile and extended (not sure if this matters).

Still love the SS. Cheers.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.12.10 16:24:00 - [706]
 

Edited by: Dedaf on 10/12/2010 16:30:59
Ok i have found the reason to the problem. Run Time error'-2147217376 (80041020)': XML Parse Error.
It seems that eve-central does not accept or have an error happening if you ask for multiple market stats at a time.
i have tried with the market strings directly in a web browser, and if i keep clicking update in the browser for that one string, then it fails to update after clicking update between 10 and 16 times.

Since i have 16 market strings to update in the tool, the chance are very high that you will get the error that you'll are seeing.

The only way to avoid this error "at the moment" is to not use the "update all" button, but just use the update button in the specific sheet you are using.
For example, if i am using the T1 production sheet, then i click update in that sheet, that will only ask for 3-4 market stats, this will make the bug less likely to happen.But even doing it that way, i still manage to get the bug. Just click update again and the prices should be updated.

I hope this will be solved soon.

PS: i only update my prices like ones a day at max, that could be why i didn't see the bug till now. Could be that there is a max to how often you can update from eve-central, to reduce load on the server.



Sewer Urchin
Posted - 2010.12.11 20:16:00 - [707]
 

Just downloaded this the other day. Great tool. Thank you for making it Very Happy

DSM20T
Obsidian Ridge INC
Posted - 2010.12.11 20:59:00 - [708]
 

Edited by: DSM20T on 11/12/2010 21:01:38
Is there any way to get the minerals and what not in stock from the api???

Edit: Also, unless I'm missing it somewhere, I don't see the value minerals needed, just the worth of the minerals I own. (t1 production tab).

Great tool. Thanks

Jieka Olipia
Posted - 2010.12.13 06:15:00 - [709]
 

Hello. I have no problem entering information manually as I am using open office. BUT i cant figure the rig calculator out.... When i select what rig i want to build it just says Err:502. It doesnt allow me to select a rig. ANYONE?

Gamingloser1
Posted - 2010.12.14 03:25:00 - [710]
 

On the planet sheet I noticed the following:
When selecting a temperate planet, "aqueous liquid" is not highlighted green. Furthermore, the spreadsheet does not indicate that water can be made on a temperate planet. I'm sure these two problems are related (or same).

Also, I have a question on the same page. There are two "rows" for calulating POS fuel. What are the differences between the two (if any)? I noticed when I put the same size and race towers with the same amount of days the price pr day costs are different. When I change the raw material cost drop down box the cost per day changes but they never match.


Gamingloser1
Posted - 2010.12.14 05:07:00 - [711]
 

Also on the planet sheet:

The materials need to build a complex reactor array is wrong. I believe it is pointing the materials needed for a simple reactor array.

Thanks for the great work!

Gelysta
Posted - 2010.12.17 14:44:00 - [712]
 

using verson 12.6.9

I was looking at the t2_items

Ammunition
Laser_Crystal

checked most of them they are all showing units will be built as 120 in 10 runs, but Laser_Crystals only make 4 per run. I also tryed to run the numbers on cost per run vs out put and it dose not seem to add up most likely due to the output variance.
Thanks

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2010.12.28 12:00:00 - [713]
 

Originally by: DSM20T
Edited by: DSM20T on 11/12/2010 21:01:38
Is there any way to get the minerals and what not in stock from the api???
Edit: Also, unless I'm missing it somewhere, I don't see the value minerals needed, just the worth of the minerals I own. (t1 production tab).
Great tool. Thanks
It is possible to pull the items in your hangar, but its of no real use, the work needed to pull this kinda information and make it easy to use is just huge! so i wont do that.
Im not sur ei understand what you are missing in the T1 production sheet. do you want the total price of all minerals needed?

Originally by: Jieka Olipia
Hello. I have no problem entering information manually as I am using open office. BUT i cant figure the rig calculator out.... When i select what rig i want to build it just says Err:502. It doesnt allow me to select a rig. ANYONE?
I think this problem comes from it beeing a .xlsm file, i have uploaded a .xls file that you can try to download instead to see if that helps you. let me know if it works.

Originally by: Gamingloser1
On the planet sheet I noticed the following:
When selecting a temperate planet, "aqueous liquid" is not highlighted green. Furthermore, the spreadsheet does not indicate that water can be made on a temperate planet. I'm sure these two problems are related (or same).

Also, I have a question on the same page. There are two "rows" for calulating POS fuel. What are the differences between the two (if any)? I noticed when I put the same size and race towers with the same amount of days the price pr day costs are different. When I change the raw material cost drop down box the cost per day changes but they never match.

first of thanks alot for the good error description. I have now corrected the bugs you have found.
The reason why the 2 POS fule slots calculated a different price was that the 2nd one was not using the correct material prices.

Originally by: Gelysta
using verson 12.6.9
I was looking at the t2_items
Ammunition
Laser_Crystal
checked most of them they are all showing units will be built as 120 in 10 runs, but Laser_Crystals only make 4 per run. I also tried to run the numbers on cost per run vs out put and it dose not seem to add up most likely due to the output variance.
Thanks
I do not see the problem you describe. I have checked all crystals with the ingame BPc's and they all show an output of 4 crystals as my sheet does.

Thanks to everyone for helping making the sheet better.
I have just now uploaded the latest version 12,7,1

Happy New Year

Dr Conners
Posted - 2010.12.29 23:07:00 - [714]
 

TLDR The thread, so I apologize if this has been mentioned before.

Data tab: Robotics listed twice, under Fuel and Industrial group, for the purpose of price updating, is it possible to link these, so they don't have be updated twice for the same item. I have not checked for duplicates of other items, this was just the first one that I noticed.

T2 Items Tab. Heavy Missile Prints. Without any Quantity being asked to be built, it adds 80 Rocket Fuel to the Productions needed above.

For ME -4 Prints, it does not calculate quantity of Rocket Fuel needed (for any amount to be produced, it says 80, at any ME level). I've checked this across all 8 Heavy Missile types and get same result for each.

Jane Evano
Posted - 2010.12.30 23:44:00 - [715]
 

I have an error with T2 heavy missile ammo....

ex. bpc for scourge fury heavy missiles -4ME
the excel spredsheet says
9 Graviton pulse generator - the bpc says 14
18 phenolic composites - the bpc 18

Im new with T2 production - so maybe i have overseen something in the spreedsheet - it works wonders with my T1 production.

so question is have i done something wrong - og is it an error?
the same "error" is with some of the other T2 missiles

Admiral Jessica
Amarr
GHF Corperation
Posted - 2011.01.02 14:37:00 - [716]
 

This is a great sheet just got it today and it has made me over 100m isk from things I didn't even consider.

suggestions......

a clear button I dont know if its left over info from you but it shows me as having items i don't have in the data part


Also in blue prints from t1 / T2 what have you, an auto spawn new line when the rest are full.... some of us have over 300 BPO and the list only holds so many if they added a new row when the others were full it would be very mice :)

the ability to add more then 1 api key dont know back end if this would be alot of work for you but to be able to add all 3 of my chars into 1 sheet for easy management would be wicked

Lenyxia
Posted - 2011.01.10 21:06:00 - [717]
 

Hope isnt just by me ... Refined Comodities - Rocket Fuel on "Planet" page uses price from Specialized Comodities - Robotics. Tested on MS Office 2007.

Pure Hope
Posted - 2011.01.11 12:35:00 - [718]
 

Edited by: Pure Hope on 11/01/2011 12:36:12
Great spreadsheet being using for years for different things. My corp is starting to use the calculator for Corp Ice Mining Ops; however, strontium does not generate a price despite the avg, own, buy, sell price chosen. It could be due to the fact that on the Ice corp mining sheet is is known as Strontium but on the data sheet is is known by is full name Strontium clathrates

Ave Volta
Perkone
Posted - 2011.01.12 06:11:00 - [719]
 

Just wanted to say great spreadsheet. Thanks! Very Happy

Gamingloser1
Posted - 2011.01.15 01:41:00 - [720]
 

Hello again Dedaf!

I noticed another oddity on the planet worksheet in regards to how it "pulls" prices from the Data worksheet. When you select the own pricing on Planet worksheet, the guidance system price (specialized commodities) is pulling prices from the hazmat detection systems from the Data sheet. Also Planetary Vehicles price on the Planet Sheet is pointing to the smart fab units pricing on the Data sheet.

A quick easy way to get a visual idea of what the results are set the prices of specialized commodities as 1-18 isk on the Data worksheet (H82-H99), set the guidance system (H70) price as something insane like 9999999 isk, and then change the price of hazmat detection system (H88) to something high (say 7777). Now go to the planet worksheet and use the own pricing. The guidance system will say cost 7777 isk and planetary vehicles will both cost 14 isk.

Secondly, Robotics are listed twice on the Data sheet. Once in Industrial goods (L74) and in Fuel (L22). I'm not sure how that can screw things up....is L74 even used to calculate anything (POS fuel cost/hr)?

Let me know if you have any questions.

Cheers!



Pages: first : previous : ... 20 21 22 23 [24] 25 26 27 28 : last (28)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only