|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
jantik
Caldari Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.01 03:58:00 -
[1]
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 Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.01 04:23:00 -
[2]
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) ***** |
jantik
Caldari Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.01 04:58:00 -
[3]
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. ***** |
jantik
Caldari Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.07 02:36:00 -
[4]
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.
***** |
jantik
Caldari Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.08 01:16:00 -
[5]
Ahh I see what you are saying. I will see if I can find any info for ya. ***** |
jantik
Caldari Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.13 00:49:00 -
[6]
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 ***** |
jantik
Caldari Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.17 19:20:00 -
[7]
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. ***** |
jantik
Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.23 22:45:00 -
[8]
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. ***** |
jantik
Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.05.24 18:20:00 -
[9]
Ok that makes sence ***** |
jantik
Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.06.08 16:20:00 -
[10]
Rock On! |
|
jantik
Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.06.08 16:26:00 -
[11]
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? ***** |
jantik
Vengeance of the Fallen CORPVS DELICTI
|
Posted - 2008.06.08 23:33:00 -
[12]
The XML system is looking for that file on your C:\ even though you saved it somewhere eles. Its a fixed setting and cannot be changed, because othervice you would have to specify which fields need to be updated eachtime. sorry
Ahh ok thanks! ***** |
jantik
Caldari Chicago Mobsters
|
Posted - 2009.06.12 03:35:00 -
[13]
The XML price and skill update is supported only in Office 2003-2008 Pro. Open office do not support direct XML update
|
jantik
Caldari Battlestars Wildly Inappropriate.
|
Posted - 2011.01.16 18:03:00 -
[14]
Dedaf,
Not sure if this has been repoted yet but when I save/close the sheet, a pop up asking for the VB Project password comes up before final closure.
This is with MS Office 2010.
|
|
|
|