Architect Archive

Thread: New Version: Crafting Assistant 1.2

Akkori
Mon Dec 08, 2003 12:12 am
#27

Also noticed I cannot Copy & Paste into the resource sheet. I have to manually add each and every name and stat for each and every resource I have....Hmmm.



Odano Akkori
First Mayor of Tempest
Jaxian Bay
Elder DE, Rifleman, Swordsman

Jedi will never be a starting profession...Looted items and quest items will never be better then crafted items, this is not a loot based game...CH will return shortly...CH and BE will not be back in game...Rangers are getting their revamp next!...The stealth system will not be changing in the spy expertise...Need any more examples of things the devs said that did not hold true?
ImLucas
Mon Dec 08, 2003 7:52 am
#28


Akkori wrote:
Also noticed I cannot Copy & Paste into the resource sheet. I have to manually add each and every name and stat for each and every resource I have....Hmmm.




Strange... copy and paste seems to be working just fine...

The only time you would run into issues is if you are trying to paste values into the non-green boxes. Maybe the spot you are copying from has more columns than the green area.


As far as your .csv files... It should be a simple matter for you to import those files into a new spreadsheet, then simply adjust the columns to the correct order, copy, then paste.

I never intended or expected anyone who used this spreadsheet to have every resource ever posted on any resource tracking website... It was mainly intended to be used as a quick guide to see what resource is better for which schematic.

However, I'm still toying with some upgrade ideas, and I still need to adjust the harvester formulas.(more data would be helpful in this) But I shall see what I can do in regards to allowing the resizing of columns, and using abbrevs.

Perhaps I can even add in a special conversion page, but it would help to have a short sample of that /csv file, so I can test it.



┌──────────────────────────────────────────────────────────────────┐
This thread has been tainted by Loserwan Ka'Newbie of Tarquinas.
└──────────────────────────────────────────────────────────────────┘

ImLucas
Sat Dec 13, 2003 10:44 am
#29

There's another spreadsheet out there?

Hrm... I'll have to do a search now.



┌──────────────────────────────────────────────────────────────────┐
This thread has been tainted by Loserwan Ka'Newbie of Tarquinas.
└──────────────────────────────────────────────────────────────────┘

ImLucas
Sat Dec 13, 2003 9:06 pm
#30



Mondamin wrote:

How about that password?






Heh, the only way I'm ever gonna give out that password is if I decide to totally give up on updating the spreadsheet, I give up on the game, or I consider the spreadsheet to be "complete and perfect". I think I'm actually closest to the 2nd option, as my opinion of the develpoers is not all that great(but that's another story).

In short: No password for joo! (hehehe)

But I guess when the spreadsheet is all perfect, I could completely get rid of the password protection and it should work in Open Office, but I'd have to really test that. Don't know how compatable it is.



┌──────────────────────────────────────────────────────────────────┐
This thread has been tainted by Loserwan Ka'Newbie of Tarquinas.
└──────────────────────────────────────────────────────────────────┘

saintchuck
Sat Dec 13, 2003 9:10 pm
#31

What version of Excel is required?



Jedi will be rare and difficult - No
Increased Dev communication - No
CU will balance combat - No
Most of the bugs from launch fixed - No
saintchuck will continue to pay - No

- I supported the CURB, the Devs and the attempt to make SWG a better game and have realized it didn't work so I'm quitting in less than 2 days and won't be tricked into coming back again. Trick me once, shame on you...
ImLucas
Sat Dec 13, 2003 9:21 pm
#32



saintchuck wrote:
What version of Excel is required?




Well, I made it using Excel 2002, but I haven't heard of any problems with earlier versions.

But I know for a fact that Open Office can't decode it with the password protection. So if you have an early version of excel, I'd suggest you give it a try, and let us know if it works.



┌──────────────────────────────────────────────────────────────────┐
This thread has been tainted by Loserwan Ka'Newbie of Tarquinas.
└──────────────────────────────────────────────────────────────────┘

Mondamin
Sun Dec 14, 2003 1:13 am
#33

No, his spreadsheet is that Lot Management tool. As far as I have seen, yours is the only one in the crafting genre.


How about that password?




Godrick Blackanvil
Bria
MattDaComputerGuy
Fri Jan 23, 2004 4:18 pm
#34

Corel Quattro 4.0 works too.

Page 3 of 3