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 : 1 2 3 [4] 5 6 7 8 9 ... : last (28)

Author Topic

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.01 15:47:00 - [91]
 

Thanks Smile
im glad you got it to work.

Va Van
Posted - 2008.03.04 11:17:00 - [92]
 

Edited by: Va Van on 04/03/2008 11:48:08
Little mistake in Rigging Calc.: "Capacitor Control Circuit" requires - Burned Logic Circuit, not Charred Micro Circuit. "Semiconductor Memory Cell" need to correct also. Wink

P.S.: Respect 2 u yob! Every version is better and better!

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.04 13:22:00 - [93]
 

Edited by: Dedaf on 05/03/2008 10:56:42
Originally by: Va Van
Edited by: Va Van on 04/03/2008 11:48:08
Little mistake in Rigging Calc.: "Capacitor Control Circuit" requires - Burned Logic Circuit, not Charred Micro Circuit. "Semiconductor Memory Cell" need to correct also. Wink

P.S.: Respect 2 u yob! Every version is better and better!


Thank you very much for you input, it is now corrected in Version 7,3,1

a CEO
Posted - 2008.03.10 11:19:00 - [94]
 

im using openoffice and cant get the sheet to update can you help

Katana Seiko
Gallente
Posted - 2008.03.10 15:32:00 - [95]
 

Edited by: Katana Seiko on 10/03/2008 15:34:05
Umm... I have no C: Drive (yet)... I managed to set my first hard drive to letter A: and my DVD-ROM drive is letter B:... I know, it's not very common, but without floppy drives I thought it'd be a waste to just skip A and B...

Oh, and same with the OpenOffice... MS Office is just too expensive if you can get a free alternative that has slightly more abilities (and less bugs).

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.10 17:33:00 - [96]
 

i tryed to find out more about OpenOffice today, and from what i can see, then direct import of XML data is not supported, like the type im useing in this Excel.
So im afraid i cant help you there, only way is to manualy enter the data. So you not having a c:\ drive wont matter.

Kyrlin DiShai
Caldari
EVE University
Ivy League
Posted - 2008.03.14 17:28:00 - [97]
 

I found another bug in your sheet, strangely relating to a previous idea of mine :P

The T1/T2 crystal box doesn't actually seem to change any data at all, the ore levels stay the same regardless of which you use. Plus there is always the missing option of no crystals at all, some people have no choice but to do that, could it be added when you are investigating this bug?

Your Ore calculator sheet seems to be giving a lot of #DIV/0! errors too.

Again thanks for the ever helpful sheet.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.14 21:18:00 - [98]
 

Selecting T1 and T2 crystals will only change your yield, meaning more ore pr hour, so that is the only thing that change, and when i try to change that, then i see the change.
About the Div/0, it sounds like you havent selecet any laseres in the Mining sheet, since this is where i take the ore yield from, to calculate how long it takes you to min the needed ore. So you need to set up your mining ship in the Ore mining sheet before the Ore calculator is working correctly.
might be the same reason why you dont see any change when you select crystals, if you havent selected the right laseres? othervice you are free to contact me ingame.

Kyrlin DiShai
Caldari
EVE University
Ivy League
Posted - 2008.03.15 16:47:00 - [99]
 

Originally by: Dedaf
Selecting T1 and T2 crystals will only change your yield, meaning more ore pr hour, so that is the only thing that change, and when i try to change that, then i see the change.
About the Div/0, it sounds like you havent selecet any laseres in the Mining sheet, since this is where i take the ore yield from, to calculate how long it takes you to min the needed ore. So you need to set up your mining ship in the Ore mining sheet before the Ore calculator is working correctly.
might be the same reason why you dont see any change when you select crystals, if you havent selected the right laseres? othervice you are free to contact me ingame.


I have just double checked this as I could well have been wrong; I have my current skills loaded from the XML file and my ship set in the Mining page thus:
5x Mining Drones I, 3x Modulated Strip Miner II, T1 crystals, Using Hulk, No (or 0) to all the other options. This gives 138.0 drone yield, 3437.332 laser yield for a total of 1284/m and 77026/hr. If I change the crystals to T2 it doesn't adjust these figures at all, I even checked by going through the other lasers and choosing some different values, again no change when switching crystal type.
Same with the Ore calc sheet, I checked it with different lasers selected and there is still a #DIV/0! error showing. I've just fiddled with that a bit more and it appears that while you have "Use minerals from stock" selected unless you need more than you have in stock it throws the error.

The reason I was requesting the crystal change is because some people do indeed use charge capable lasers with no crystals and it might help them see how much they are missing out by not using even the T1 crystals.

Hope this helps you locate the bug I'm experiencing.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.15 20:14:00 - [100]
 

new Version 7,4,1

Yes its is true it writs a error in time calculation, if you select "use own minerals" and then select you need to mine less minerals than you already have in your stock, but that is because you dont need to mine anything, becuase you already have what you need.

The thing about the crystals, i cant see that problem, unless you dont have any Ore skills over 3, because then you cant use T2 crystals and then that is why you dont see it calculate, could that be why?

Kyrlin DiShai
Caldari
EVE University
Ivy League
Posted - 2008.03.16 04:32:00 - [101]
 

Originally by: Dedaf

The thing about the crystals, i cant see that problem, unless you dont have any Ore skills over 3, because then you cant use T2 crystals and then that is why you dont see it calculate, could that be why?


Ahh, I didn't realise it was taking into account I couldn't use them, I was trying to see how much it would increase my yield. That will be the problem then.

Kyrlin DiShai
Caldari
EVE University
Ivy League
Posted - 2008.03.16 04:48:00 - [102]
 

Originally by: Kyrlin DiShai

Ahh, I didn't realise it was taking into account I couldn't use them, I was trying to see how much it would increase my yield. That will be the problem then.

I've just downloaded your new sheet and put in the same ship setup, same skills:
138 for drones (same) 2115.28 for lasers (1322.052 less) 843/m (441 less) 50585/hr (26441 less) I now show no change when swapping from No crystals to T1, with T2 it tells me I need level 4 skills. I have L3 Veld, Plag, Scord and Pyrox; L2 for Omber, Kernite, Jaspet, Hemorphite and Hedbergite.

Being unable to see how your formula works I can't myself work out why it's not giving the crystal bonus, I have to assume you are checking all the ore types for level 3/4.

Hope this helps you work it out, still loving your sheet, thanks again for doing it Smile

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.16 07:55:00 - [103]
 

You are totally right, the bug was only there when none of the ore skills was at 4.
This was definitely harder do implement than i thought Surprised

I think i got it working in this new error correction, Version 7,4,2

But still if you dont have lvl4 in any of the Ore skills, T2 crystals wont be calculating bonus.

Thanks

Kyrlin DiShai
Caldari
EVE University
Ivy League
Posted - 2008.03.17 05:05:00 - [104]
 

Originally by: Dedaf
You are totally right, the bug was only there when none of the ore skills was at 4.
This was definitely harder do implement than i thought Surprised

I think i got it working in this new error correction, Version 7,4,2

But still if you dont have lvl4 in any of the Ore skills, T2 crystals wont be calculating bonus.

Thanks

I'm getting lower values this time and again changing the type of crystal shows no change to mining yield per min or hour.
Put in my full skills to your sheet to see if you get the same bug:
Mining 5, Astrogeology 5, Barge 5, Exhumers 3, Drones 3, Drone interfacing 3, ore skills in post above.

5x mining drones I, 3x msm II, T1 crystals, nothing else.

This now gives me: 138 for drones, 1940.63 for lasers, 785 ore/m and 47092 ore/hr.

I should probably go and work out what my yield should be and post a comparison for you.

Thanks for taking the time to fix this.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.17 09:14:00 - [105]
 

3rd time’s the charm,
Version 7,4,3

Urm
Posted - 2008.03.19 13:52:00 - [106]
 

Any chance T2 rigs will be included?

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.25 16:40:00 - [107]
 

new version 7,6

Now inclouding T2 production sheetVery Happy

Jendoe
Posted - 2008.03.28 06:05:00 - [108]
 

Edited by: Jendoe on 28/03/2008 06:08:29
First let me say thanks for working this, it has been a good help recently!!

But, seems in the newest version 7.6.1, you may have locked the rig names in the t1 rig calculator, unless its just me, but I can't select a different rig then what is showing.

Oh yea, and while I am at it.. seems the scorched Telemetry processor is missing as well, and it would be nice if I could get a total value of my rig parts.

Thanks again

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.03.29 11:31:00 - [109]
 

Edited by: Dedaf on 29/03/2008 11:33:05
new version 7,7

Originally by: Urm
Any chance T2 rigs will be included?


At some point it might, but it would also need some kind of invention to give a precise build price, so i first have to find a good solution to this.


Originally by: Jendoe
Edited by: Jendoe on 28/03/2008 06:08:29
First let me say thanks for working this, it has been a good help recently!!

But, seems in the newest version 7.6.1, you may have locked the rig names in the t1 rig calculator, unless its just me, but I can't select a different rig then what is showing.

Oh yea, and while I am at it.. seems the scorched Telemetry processor is missing as well, and it would be nice if I could get a total value of my rig parts.

Thanks again


Yes you are right about both Embarassed
The scorched Telemetry processor is now inclouded and the launcher rig's has been corrected.




Maria D'thinker
School of Applied Knowledge
Posted - 2008.04.15 17:44:00 - [110]
 

I can't download this file. Everytime I tried it just go to another webpage. Anyone has a better link for download?

thanks

Dar Vega
Non Nobis
Posted - 2008.04.16 19:41:00 - [111]
 

hey great tool. however i have upgrade my whole pc now and downloaded the program again. vista with office 2007. my question is how do i get the excel sheet to import the xml data? i click update in the spreadsheet and it brings me to the webpage here. any ideas? or am i being a total noob? :D

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.04.16 20:04:00 - [112]
 

Edited by: Dedaf on 16/04/2008 20:22:03
Originally by: Maria D'thinker
I can't download this file. Everytime I tried it just go to another webpage. Anyone has a better link for download?

thanks


The File is not hosted on EVE-online's webpage, it is hosted by www.mediafire.com that is why you are forwarded to a deferent page, from there you download de file.


Originally by: Dar Vega
hey great tool. however i have upgrade my whole pc now and downloaded the program again. vista with office 2007. my question is how do i get the excel sheet to import the xml data? i click update in the spreadsheet and it brings me to the webpage here. any ideas? or am i being a total noob? :D


i think it is because you are cliking on the UPDATE beside the version note, its a link i put to make it easer for useres to check for updates of my sheet Smile
you need to click the botton below the minerals, it will update both prices and skills for you, IF you placed the skill file on your C:\ drive.

hopes it helps

Originally by: Kyrlin DiShai

1) On the Mining page, the Cargo hold number does not adjust the formulae below it unless you set it to 0 it gives a #DIV/0! error, nothing else will make them change, I assume this is a bug

This funktion should be working again Laughing


I just now uploaded a new version 7,8

Jendoe
Posted - 2008.04.25 18:02:00 - [113]
 

Here is a little macro that I made to update the character info from the api site, I think you might be interested in this for your sheet.

Public Sub RefreshChar()
apikey = Range("Preferences!$D$3")
charID = Str(Range("Preferences!$D$5"))
UserId = Str(Range("Preferences!$D$4"))

Feed = "http://api.eve-online.com/char/CharacterSheet.xml.aspx?apiKey=" + apikey + "&characterID=" + charID + "&userID=" + UserId

'True for Overwrite, False for Append
ActiveWorkbook.XmlMaps("eveapi_Map").Import Feed, True
End Sub

You need to have a place to enter the apikey, userid, and charid in the sheet, in this one I used a page called Preferences, and you need to map out the xml import, in this case its called eveapi_Map.

If you have any questions feel free to contact me in game, as I don't come to the forums everyday. This could probably be writen better, as it is in VBA.

Jendoe

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.04.28 17:08:00 - [114]
 

Thank you very much Jendoe
This was the info i have been looking/hoping for, for a long time Very Happy

The new version 7,9,2 have the ApiKey update funktion.
I have updated my first post to explain how to do it, but its very simple. Enjoy

Thanks again

xXHeadHunterXx
The Knights Templar
R.A.G.E
Posted - 2008.04.29 12:23:00 - [115]
 

Awsome sheet.

However I loaded up the API information as it asked for and pressed "update skill data"

I got an error message from a VBA it said
"BASIC syntex error.
unexpected symbol /."

the VBA code was

Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Sub Knap317_Klik()
http://myeve.eve-online.com/character/xml.asp
End Sub

It highlighted the part in the URL after the "http:" part

I am using Open Office 2.4

Anyone have any idea if I should download somthing, or change some settings to make this work?

Thanks in advance

Daniel.

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

many people seem to have the problem with Openoffice, i tryed one time to see if i could find some information on this, and as fare as i can see then Direct import of XML data is not supported in OpenOfficeCrying or Very sad

so Openoffice users only option is to manualy enter the skill in the Sheet called Data, i have marked some lines in the DATA sheet where you can inter the lvl of your skills.

But if someone knows how to get around this problem in OpenOffice, then it sure would be nice to know.

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.01 03:58:00 - [117]
 

Dedaf,

Since I use your sheet, which I love btw, and I don't know a lot about excel or XML programming yet, I did a bit of searching and found this > http://www.xml.com/pub/a/2006/01/11/from-microsoft-to-openoffice.html?page=2 <. Basically it tells you how to convert MS OFFICE to OPENOFFICE files and gives them to ability to add/use API inputs from different sources.

Hope this helps for all the OpenOffice users out there, and doesn't create too much extra work/coding for you.

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.01 04:23:00 - [118]
 

Also I noticed that when you select "Modulated Deep Core II" and a "Skiff" that it does not show your mining output (either ore/min or ore/hour)

Outo
Phoenix Propulsion Labs
Firmus Ixion
Posted - 2008.05.01 04:54:00 - [119]
 

Edited by: Outo on 01/05/2008 04:54:33
how do you get excel to call up information based on a drop down list?

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.01 04:58:00 - [120]
 

This is the easyist way to do it with office 2003. Linkage. Office 2007 is easier imho. Office 07 List


Basically you are creating Validations. Hope it helps.


Pages: first : previous : 1 2 3 [4] 5 6 7 8 9 ... : 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