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.05.02 10:12:00 - [121]
 

Thank you for the informatil Jantik, i will see if i can use it to create a Ooffice version that can import the XML.


Originally by: jantik
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)


yes you are right, i never noted that.
I have corrected it for the next version, where i hope ill have the Jump freighter production sheet ready too.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.05.06 19:14:00 - [122]
 

New version 8
with Jump freighter production sheet

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.07 02:36:00 - [123]
 

Dedaf,


Another idea that just struck me, how bout an import/export function. Such as for like minerals/ore/ice/components? Due to having to reenter everything with each new sheet.



Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.05.07 13:37:00 - [124]
 

Yes i totally agree, it is a pain especially if you have 20 deferent BP in the Production sheet, that you need to reenter.

I have been trying to make some kind of export/import, but they change format and sizes of cells, which is a big problem, and I have not yet been able to export or import all needed data for one sheet alone.

but again like with the APIkey, if someone have a good knowledge in this field, then im always happy to listen for good advice.

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.08 01:16:00 - [125]
 

Ahh I see what you are saying. I will see if I can find any info for ya.

Mervent
Caldari
Deep Core Mining Inc.
Posted - 2008.05.12 08:16:00 - [126]
 

Thank you for all your effort.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.05.12 19:33:00 - [127]
 

Edited by: Dedaf on 12/05/2008 19:35:50
I have now put up a new version 8,5 which have the ability to export and import BluePrint information from the T1 Production sheet.

But unfortunately it is not possible to export data from versions lower than 8,5 and therefore it is not possible to import your data from the older versions. So Iím afraid you will have to re-enter the data again, but hopefully for the last time.

Export and import is the only difference from version 8 to 8,5

NB: to import data to the T1 Production sheet, you will have to unprotect that sheet. Excel does as fare as i can see not allow import when the sheet is protected.

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.13 00:49:00 - [128]
 

Dedaf,

I get the following error when I try and download the file > This file is currently set to private. This error has been forwarded to MediaFire's development team. Will try later and see if its just not a server error. Also I remember another sheet that I used to use that had a button you could click to import/export the info, without having to unprotect the sheet. I will see if I can find it and post the info here, might help ya keeping your sheet protected Very Happy

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.05.13 04:31:00 - [129]
 

It seems to be working now.

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.17 19:20:00 - [130]
 

Dedaf,

Quick question on the T1 production sheet... I noticed that a Harb is put in when its downloaded and has values in the Gray Boxes (above where you input mineral amounts). If I add another, lets say a raven and give it an ME value those boxes stay 0. Where is it pulling this BP Mineral info from as I dont see it anywhere in the sheet.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.05.18 17:01:00 - [131]
 

im not sure Which field it is.
Is it the ones for each slot, ex:I22-O22 (slot1) or is it production need Q7-Q11?

gray fields Ixx-Oxx should calculate the minerals use, from the ME LvL calculated from the minerals you entered in the blue fields, ex slot1: I23-O23
the sheet does not import mineral need for blueprints, it calculate it from the minerals you enter, so you need to go to the item database of EVE and enter the minerals needed for(in your case) a raven.

If its the production need, then you simply after filling in minerals in the blue field of a slot, just enter how many you want to build in the blue field C22 (slot 1)


Mograthi
Lightfoot Pestisss and Blake Enterprises
Shadow of xXDEATHXx
Posted - 2008.05.21 15:29:00 - [132]
 

first I love the sheet keep up the good work. Now i use office 2003 and the api key update is doing nothing. I have put in my api key and userid and character name, when i hit update skill data it looks like it is doing something for a brief second, but no data is updated in the spreadsheet, any ideas?

Mograthi
Lightfoot Pestisss and Blake Enterprises
Shadow of xXDEATHXx
Posted - 2008.05.21 15:44:00 - [133]
 

Originally by: Mograthi
first I love the sheet keep up the good work. Now i use office 2003 and the api key update is doing nothing. I have put in my api key and userid and character name, when i hit update skill data it looks like it is doing something for a brief second, but no data is updated in the spreadsheet, any ideas?


I found a solution, i had to unmerge the cells for the api key on the data tab and then all worked fine.

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

cool im glad you got it working, i was supose to unmarge that but forgot Confused, cause i seen that bug too. I have done it now, so in versions to come, it should not be a problem anymore.
you could also just paste the APIkey in to the funktion line, incase there are others who dont know how to unmarge cells.

Meenen
Posted - 2008.05.22 07:59:00 - [135]
 

if you have the time, could you make something in microsof works? I would also like a small version of this program thingyugh

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.05.22 08:46:00 - [136]
 

As fare as iw seen the XML is only supported in Office 2003 and up. But you should still be able to use this Tool. You can enter your skills manually if you scroll down in the DATA sheet, then you will see I have entered names and skill id on needed skills, all you need to do is enter you skill lvl there.

But if it is because you can not even open this sheet, then try out this version, i have saved it in office 97 format.

Meenen
Posted - 2008.05.22 09:37:00 - [137]
 

it will not open in the vista microsoft works thing, were can i download the other office?

TehFedz
Semi-Ethical Munitions Inc.
Posted - 2008.05.23 17:37:00 - [138]
 

I have a question about the t1 production page...

When I slap in a number of minerals for lets say Isogen in a blueprint information spot the input I give is put in a blue box. A new (higher) number then appears above the blue box in grey. What is this new higher number? What number does the input for the blue box represent?

The blue box im referring to is I22 and the grey is I21

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.23 22:45:00 - [139]
 

Originally by: jantik
Dedaf,

Quick question on the T1 production sheet... I noticed that a Harb is put in when its downloaded and has values in the Gray Boxes (above where you input mineral amounts). If I add another, lets say a raven and give it an ME value those boxes stay 0. Where is it pulling this BP Mineral info from as I dont see it anywhere in the sheet.



Sorry Dedaf let me be more specific. On the Gray rows I20/21 to O20/21 have a "mineral value" encoded in them. Lets say in the type box I put in Raven and that its a BPC and the value. In the Material Level box, G21, I put an ME value of 100, where does the row I20>O20 get that info from? As if I have entered what I have just written above it is 0.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.05.24 08:45:00 - [140]
 

Originally by: jantik
Originally by: jantik
Sorry Dedaf let me be more specific. On the Gray rows I20/21 to O20/21 have a "mineral value" encoded in them. Lets say in the type box I put in Raven and that its a BPC and the value. In the Material Level box, G21, I put an ME value of 100, where does the row I20>O20 get that info from? As if I have entered what I have just written above it is 0.

Originally by: TehFedz
I have a question about the t1 production page...

When I slap in a number of minerals for lets say Isogen in a blueprint information spot the input I give is put in a blue box. A new (higher) number then appears above the blue box in grey. What is this new higher number? What number does the input for the blue box represent?

The blue box im referring to is I22 and the grey is I21


I think i can answer both the questions in one. The sheet does no import minerals. it calculate it from the amount you have entered in the Blue fields I23-O23.
So what you need is to Go to Item dadabase. you need to take the minerals from the Item database because that is the base value of minerals for each item.
You can not use the mineral need from the Blueprint ingame, because that is not base minerals, that is the minerals you need with your skill, therefore the calculation is wrong in your case TehFedz.

So in short, you need to go to item database and find your Ship/item, and enter the minerals it shows there in the list.
When that is done, then you can set the ME LvL of your BPo or BPc and then it will show the right amount of minerals in the Gry field I21-O21

after entering minerals from Item database, then you can change ME LvL to see wich lvl will be best to research to.

I hope this helps your both, if not, then you are velcome to contact me ingame for a chat.

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.05.24 18:20:00 - [141]
 

Ok that makes sence

sepharim blade
Posted - 2008.05.25 21:56:00 - [142]
 

i dont know how to enter my skills manually, the down arrow doesnt show skills, how do i enter skills manually?

Riset
Caldari
Galactic Miners Guild
Posted - 2008.05.26 01:50:00 - [143]
 

Dedaf,

I have been using your files for some time now and am really glad to have them available. Thanks.

Unfortunately I'm having problems getting the "Update Skill Data" to work. I input my ApiKey (manually since it won't let me paste to the cell without unmerging it), UserId, and Character Name and press the key and get a Run-time error '483' "Object doesn't support this property or method" and it asks for me to do one of 2 choices, End or Debug. Any idea why this is coming up or any help on how to input the info to get this function to work? I have an older version of office and d/l'd the version for below 2003 and get it for either version.

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.05.26 09:48:00 - [144]
 

Originally by: sepharim blade
i dont know how to enter my skills manually, the down arrow doesnt show skills, how do i enter skills manually?


To enter the skills manually you scroll down on the DATA sheet, (below alle the market information) there you will find some preentered skills, where all you need to do is enter the lvl.

Originally by: Riset
Dedaf,

I have been using your files for some time now and am really glad to have them available. Thanks.

Unfortunately I'm having problems getting the "Update Skill Data" to work. I input my ApiKey (manually since it won't let me paste to the cell without unmerging it), UserId, and Character Name and press the key and get a Run-time error '483' "Object doesn't support this property or method" and it asks for me to do one of 2 choices, End or Debug. Any idea why this is coming up or any help on how to input the info to get this function to work? I have an older version of office and d/l'd the version for below 2003 and get it for either version.


If you have a version of Office older than 2003, then XML is not supported, so that might be why you get that error, so only choice is to manually enter the skill.

sepharim blade
Posted - 2008.05.26 16:16:00 - [145]
 

Edited by: sepharim blade on 26/05/2008 19:43:23
got it. also how do i change the prices of minerals? i was wanting it to reflect the prices in the area im at, not the average prices

Astronemo
Posted - 2008.05.31 13:18:00 - [146]
 

Just a suggestion could the ore calculator take into account individual ore processing skill levels as the refine rate and times are completely shot for me

Regi Rain
Posted - 2008.06.01 16:02:00 - [147]
 

Thanks this is the best sheet I have seen so far. \o/

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2008.06.08 07:26:00 - [148]
 

Thanks alot Very Happy

new version has just been uploaded as a mark, that it is now 1year since i published the sheet for the first time. 6000 has downloaded till now.

New Version 9

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.06.08 16:20:00 - [149]
 

Rock On!

jantik
Caldari
Battlestars
S E D I T I O N
Posted - 2008.06.08 16:26:00 - [150]
 

Edited by: jantik on 08/06/2008 16:26:40
An additional note, and I think its something I am doing, if I change the location of where the XML is saved, when I do UPDATE/IMPORT, it gives me a nice error saying that "C:\T1_PRODUCTION_BACKUP" cannot be found, so it never imports. Am I missing something?


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