Weaponsmith Archive

Thread: My WS spreadsheet for factory runs

Akkori
Tue Aug 09, 2005 8:27 am
#1

I thought someone might find this useful....



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?
SgtSixpack
Tue Aug 09, 2005 10:34 am
#2

If I click anything I get a message saying "macros not enabled check help or online documentation of host application for help".



138 Assembly 128 Experimentation FS Craft 4404
Weapons Vendor Locations
IGN = Teri' & Terie Pre Cu full Temp jedi cu sbaer 711max.
Zefrin
Tue Aug 09, 2005 1:34 pm
#3

goto the tools menu in excel then to macro then security and change it to allow macros
_Monroe_
Wed Aug 10, 2005 1:24 pm
#4






Akkori wrote:

I thought someone might find this useful....





What format is this in? Nether Open Office or Excel 2003 will read it.



Monroe - Medic (formerly Kiom)
Xana - Jedi
Tarantella - Structures
Cebak - Entertainer
hashiriya
Wed Aug 10, 2005 2:58 pm
#5

I just opened it in Excel 2003 (ver. 11.5612.5606) with no problem what-so-ever.....all I can say is:



WOW.


AMAZING.


FANTASTIC.



No WS should be without this.





HardWire Crafting
Theed -4475, 3282
Sojin Tenaka, Proprietor
14pt Artisan, 12pt Weaponsmith
hashiriya
Wed Aug 10, 2005 3:01 pm
#6

Let me repeat....


GET THIS TOOL NOW.





HardWire Crafting
Theed -4475, 3282
Sojin Tenaka, Proprietor
14pt Artisan, 12pt Weaponsmith
Akkori
Wed Aug 10, 2005 7:07 pm
#7


The Excel sheet is compressed in the ".ace" format. WinAce is free, and beats the crap out of .zip files. DL WinAce ad you'll be good to go.


I am glad some are liking this. I only make standard weapons, in small quantities, in a factory. So this was an attempt to streamline pulling together the resources. The original version would add in the resources and components needed for all needed schematics as well, but I took that out at the last minute, as I think it made things too complicated in a way. The idea though was to be able to drop a bunch of resources into an input hopper, then start form the beginning and be able to make schematics for every single step of the process with only the resources in the Input hopper, and in the end, the Input Hopper would be empty, and the Output would have the desired number of weapons.


It got too hard to remmeber what metal was used in what spot, and then how some components needed UT, while the weapon needed SR (which may mean 2 different resources of the same class..... blah blah.


Anyway, this is easier. It tells you how many components you need, including the ones needed for the final schematic. Maybe someday if I get adventerous I will connect the resource page with the rest of it so it will estimate the quality of the part. But frankly, thinking about that level of math makes my head hurt!





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?
SgtSixpack
Wed Aug 10, 2005 7:31 pm
#8

"Maybe someday if I get adventerous I will connect the resource page with the rest of it so it will estimate the quality of the part."


That is what Ive used my spreadsheet for,is kind of rough but it does the job - no more pressing buttons on the calculator and scribbling down the result, just cut and past the equation multiple times tofind if a resource is worth buying/mining.



138 Assembly 128 Experimentation FS Craft 4404
Weapons Vendor Locations
IGN = Teri' & Terie Pre Cu full Temp jedi cu sbaer 711max.
Thadeus_Tempest
Thu Aug 11, 2005 12:29 am
#9

/bump for my bud!



Dept of Defense Armor
Shibboleth, Dantooine -5800 -1365
FlakJackett - 12pt *R.I.S. Certified* Retired Armorsmith
42 Mandalorian Armor Pieces Crafted DWB Guide 63 Mandalorian Armor Cores Supplied
Thadeus - Elder Jedi ggg Theseus' - Elder Bounty Hunter
Ayesaac - Elder Jedi ggg FlakJackett - Master Armorsmith
Xandr
- Master Spy
ggg Leadfoot WaddleWalker - Commando
Page 1 of 1
Previous Next