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 : ... 8 9 10 11 [12] 13 14 15 16 ... : last (28)

Author Topic

Micky Ward
Posted - 2009.04.26 18:30:00 - [331]
 

Great job Dedaf, enjoying playing with this. I'm looking for script BPO's for the likes of sensor boosters or damps etc.. but I can't see them anywhere in the drop down lists. I also can't seem to add them manually from the database because when I try to unprotect the sheet it asks for a password.

I'm sure I'm missing how it's done but can't seem to figure how to do it.

Thanks for your time.


Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.04.26 19:44:00 - [332]
 

Thanks for your feedback. You were not able to find the scripts because they were not in there at all.
But i have added them now under Ammunition, so you should be able to find them there in the new version i just uploaded.


New version 11,2

Micky Ward
Posted - 2009.04.26 22:06:00 - [333]
 

Hey thanks, that was quick. Much appreciated.

Master Kent'sslave
Lonetrek Trade and Industries
Posted - 2009.04.28 19:51:00 - [334]
 

Edited by: Master Kent''sslave on 28/04/2009 19:56:25
Edited by: Master Kent''sslave on 28/04/2009 19:51:46
In the t2 page it seams like the own price field updates from somewhere else than the colum in the data sheet. i cant get nano transistors to pick up the price from the data sheet


edit:

Greate work on the sheet btw Very Happy

second edit:

looking more on it price for nanotransistors are permanently set to :431 isk pr unit in the t2 tab Cool

Desmont McCallock
Posted - 2009.04.29 07:14:00 - [335]
 

Edited by: Desmont McCallock on 29/04/2009 07:39:51

Found some faults in the T1 Production.
- Iteron III and Iteron IV must switch Material Bills with each other.
- Magnate is missing from the list.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.04.29 13:16:00 - [336]
 

Originally by: Master Kent'sslave
Edited by: Master Kent''sslave on 28/04/2009 19:56:25
Edited by: Master Kent''sslave on 28/04/2009 19:51:46
In the t2 page it seams like the own price field updates from somewhere else than the colum in the data sheet. i cant get nano transistors to pick up the price from the data sheet

edit:

Greate work on the sheet btw Very Happy

second edit:

looking more on it price for nanotransistors are permanently set to :431 isk pr unit in the t2 tab Cool

I think your problem is that the option "build at POS" is set to YES (colum M7 to M13), which means it will take the build price from the POS production sheet.


Originally by: Desmont McCallock
Edited by: Desmont McCallock on 29/04/2009 07:39:51

Found some faults in the T1 Production.
- Iteron III and Iteron IV must switch Material Bills with each other.
- Magnate is missing from the list.

nicely spotted :) it will be added and corrected in the next release

Mirena Bauler
The Exploited.
Posted - 2009.05.06 14:06:00 - [337]
 

Originally by: Commander Phoenix
I just found out before coming back here that Evemon doesn't work with that character any more either. Although for this character Evemon works fine. Will have to look into it some more later.

Thanks for looking into my problem :)


I've got the same problem. On 2 of my accounts one of the characters doesn't work in evemon (says cached) and the same characters also don't work in this spreadsheet.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.05.06 16:34:00 - [338]
 

Originally by: Mirena Bauler
Originally by: Commander Phoenix
I just found out before coming back here that Evemon doesn't work with that character any more either. Although for this character Evemon works fine. Will have to look into it some more later.

Thanks for looking into my problem :)


I've got the same problem. On 2 of my accounts one of the characters doesn't work in evemon (says cached) and the same characters also don't work in this spreadsheet.

The thing is that the problem is neiter Evemon or my excel sheet. The problem is the API server.
For some unknown reason the server returns an error when it lookup and character with a space in the name.

BlackChii
Posted - 2009.05.11 17:44:00 - [339]
 

I would like to see ice added to the corp mining ops for POS fuel

Nym Qyamara
Gallente
The Executives
IT Alliance
Posted - 2009.05.12 08:40:00 - [340]
 

Very very nice tool. I've been using other spreadsheets but recently downloaded and older version and updated this today. Here's hoping it's better than my other ones - as it's more compact, more features in one spreadsheet.

Looks a great tool - good work.

Jolinar malkchour
Les chevaliers de l'ordre
Tau Ceti Federation
Posted - 2009.05.12 12:09:00 - [341]
 

Hi :)
Nice work, however, i have a question :

When setting all mining skills to 5, and all bonuses to 5 (with orca), i have a cycle time on a T2 fitted Hulk of 149.76sec with your sheet. Why that result ? ingame we reach 138sec cycle time with indus command ship 4 (and even less with a rorqual, obviously).

Also, you request in your sheet to have cybernetics 5 for the mining foreman midlink, however, the miner doesn't have to plug this implant, it is the bonus dealer :)

So maybe i did something wrong :)

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.05.22 14:28:00 - [342]
 

Originally by: BlackChii
I would like to see ice added to the corp mining ops for POS fuel

That is a good idea, and you will find just that in this new version i just uploaded.


Originally by: Jolinar malkchour
Hi :)
Nice work, however, i have a question :

When setting all mining skills to 5, and all bonuses to 5 (with orca), i have a cycle time on a T2 fitted Hulk of 149.76sec with your sheet. Why that result ? ingame we reach 138sec cycle time with indus command ship 4 (and even less with a rorqual, obviously).

Also, you request in your sheet to have cybernetics 5 for the mining foreman midlink, however, the miner doesn't have to plug this implant, it is the bonus dealer :)

So maybe i did something wrong :)


You kind of answer your own question, the reason you see different number, is because the sheet thought you needed to have lvl 5 cybernetics. But as you mention, that isnt really true, because it doesn't have to be you who have the mining forman implant, but another gang member.
So i corrected that in this new version, you should now see the right numbers even if you dont have cybernetics lvl5

so enjoy the new version 11,3,2

Sir Avalanche
Viziam
Posted - 2009.05.22 19:58:00 - [343]
 

phantom ghost - Did you get yours to work? I am getting the same errors below: and I have checked every box I can find to enable everything - No security basically.. :) But get the following:

Error Box - "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

Log File:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error034480_05.xml</logFileName>
<summary>Errors were detected in file 'C:\Documents and Settings\dmcgirt\Desktop\EVE\Dedaf's industrial tool 11,3,2.xls'</summary>
- <additionalInfo>
<info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info>
</additionalInfo>
</recoveryLog>

Running - Office 2007 SP2


thanks for a great tool


Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.05.22 21:54:00 - [344]
 

Originally by: Sir Avalanche
phantom ghost - Did you get yours to work? I am getting the same errors below: and I have checked every box I can find to enable everything - No security basically.. :) But get the following:

Error Box - "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

Log File:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error034480_05.xml</logFileName>
<summary>Errors were detected in file 'C:\Documents and Settings\dmcgirt\Desktop\EVE\Dedaf's industrial tool 11,3,2.xls'</summary>
- <additionalInfo>
<info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info>
</additionalInfo>
</recoveryLog>

Running - Office 2007 SP2


thanks for a great tool



I only have a danish version of excel 2007 but i will try to direct you to the right location to set the active X security.

First click on Excel- button.
Then click on the Excel-properties.
Go to the line securitycenter and click the button Settings for securitycenter.
Go to the ActiveX-settings and select 3rd option from the top. Sound something like this, Ask, before all object with minimal rights is activated.

You might have to close Excel and reopen it to make it work, also if you saved the sheet before making the ActiveX change, then you might have to redownload a new copy

i hope this works for you.

Sir Avalanche
Viziam
Posted - 2009.05.22 22:40:00 - [345]
 

Thank you for the quick response, I made those changes on my US version, but still get the same error. Maybe someone with the US version might be able to help..



Cpt Polonel
Posted - 2009.05.24 16:46:00 - [346]
 

I'm having trouble getting this to working with Office 2007 Pro. I have active X set to prompt and macros enabled. But whenever I go to update skills or check server i get a VBA error that has says:
Run-time error '9'
Subscript out of range

any help?

Desmont McCallock
Posted - 2009.06.02 11:21:00 - [347]
 

Edited by: Desmont McCallock on 02/06/2009 11:38:33

I want to report typing errors on:

Sheet "Capital Production" the word "Engine" is typed as "Engien".
Sheet "Jump Freighter" cell J18 the word should be "Production Efficiency".
Sheet "Jump Freighter" cell G6,P5, "Rig Production" cell P5, "T2 Production" cell G6,P5, "T1 Production" cell S6 should be "Productions Need".
Sheet "T1 Production" cell J6 should be "Price".
Sheet "Mining" cell W17 should be "Warfare Link", cell W15 should be "Mining Foreman".

That's all I've seen so far (could have missed some!).

Mean Gus
Caldari
Eye of God
Posted - 2009.06.05 05:18:00 - [348]
 

Awesome work! You are a stallion.

Been reading through this thread and it seems that excel 03 works. That is what I have but I don't have the pro version. Does that mean the skills won't update?

Here is what I'm doing:
entering the API information in the corresponding fields.
Clicking "update everything" button
Nothing happens
Click "Update Skill Data" button and get the message that this function is only in the pro version.

I've read something in here about importing the xml file from my character sheet, but alas I'm afraid I don't know how to do that, or I've read it wrong.

Finally, do the mineral prices update automatically from eve-central apart from the api information?

Any help is appreciated!!!

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.06.05 07:02:00 - [349]
 

Yes unfortunately you will need pro version of excel 2003-2008 to use the price & Skill information import.
Both skills and prices are imported via XML and that function is disabled in none PRO versions it seems.
For those that use OpenOffice, it donít support XML import at all.
So in case of none Pro Office versions or openOffice, your only option is to enter the skills manually in the button of the DATA sheet in this spreadsheet.



Desmont McCallock, thank you for the text corrections, they are included in the next release.

Drexciyian
The Water Margin Tech
Posted - 2009.06.08 00:37:00 - [350]
 

Ladar sensor clusters seem to be missing

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.06.10 07:16:00 - [351]
 

New Version 11,3,3

Just some minor corrections.

strike18
Posted - 2009.06.10 17:41:00 - [352]
 

i dont undertsand location of back up. do i have to download xml of my char and put on hard drive?Question

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2009.06.11 07:10:00 - [353]
 

Originally by: strike18
i dont undertsand location of back up. do i have to download xml of my char and put on hard drive?Question

The reason for the "Location of backup file:" is that you can select the location where the backup files from the Productions sheets are stored.
If you go to T1 production sheet and click the BACKUP button, then it will create an XML backup file on that specific location, default is C:\ but you can change that to what ever you like.
If you want to restore a backup file, then you need to have the XML file located at the drive and folder that you specified.

Dedaf

Mordou
Mordou Manufacturing and Trade
Posted - 2009.06.11 16:42:00 - [354]
 

Uhh.. whenever I try to update prices (I am using open office) it says

"A scripting framework error occured while running the Basic script vnd.sun.star.script:standard.tech2?language=basic&location=document

Message: The following Basic script could not be found
library: "standard"
module: tech2
method:"
location:document"

Otherwise looks like it will come in handy Laughing

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2009.06.12 03:35:00 - [355]
 

The XML price and skill update is supported only in Office 2003-2008 Pro.
Open office do not support direct XML update

Elocineax
Gallente
Posted - 2009.06.13 21:40:00 - [356]
 

Thank you for developing this wonderful asset.

Eloc

Meoneta
Posted - 2009.06.15 12:06:00 - [357]
 

I love this! I cannot find, however, to save my dear life, where on the T1 production to get the Warp Disrupt Probe Launchers or Warp Disrupt Field Generators....please2help!

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

Originally by: Meoneta
I love this! I cannot find, however, to save my dear life, where on the T1 production to get the Warp Disrupt Probe Launchers or Warp Disrupt Field Generators....please2help!

i think when you say "Warp Disrupt Probe Launchers" then you mean: Interdiction Sphere Launcher I ?
You will find it under the category: Ship Equipment/Electronic Warfare

The "Warp Disrupt Field Generators" is a nother story, i didnt have that in the sheet at all, so thats why you couldnt find it.

I have added it to the sheet now and will upload a new version soon. At the same time of adding the "Warp Disrupt Field Generators" i also corrected the probe launchers such as Core & Expanded launchers, and removed all the old probes and added the 2 new Core & Combat probes.

All this will be in the next version.

Thanks for your feedback everyone

Sen Quenten
House of Quenten
Posted - 2009.07.04 23:57:00 - [359]
 

I'm getting an error about the update character macro when I try to put in my api info. I understand that you need the Pro version, but I'm using Office 2008 for Mac, and I don't think there is a "Pro" version. There is the Home and Student, the regular Office 2008 for Mac, and the Special Media Edition. I have the plain "Office 2008 for Mac". Has anyone else gotten the sheet to work with that version?

The specific error I'm getting is that the RefreshChar macro cannot be found.

Thanks, Sen

P.S.- I use this on my Windows computer just fine and find it incredibly useful. Good work!

Lovebot
N00BS R US
Talocan United
Posted - 2009.07.05 11:30:00 - [360]
 

Erebus Titan Part numbers seem to be completly wrong, is it possible to change those myself to the correct figures ?


Pages: first : previous : ... 8 9 10 11 [12] 13 14 15 16 ... : 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