Armorsmith Archive

Thread: Armorsmith Resource Tally Tool v0.1

MaknarSerak
Tue May 18, 2004 4:10 pm
#1

Hey All,


I'm new to the Armorsmith profession and created this spreadsheet tool to help me figure out how many resources I need for each suit of armor or a certain quanitity of armor. It also takes into accountwhat layers I wanted to put in and such andincludes PSGs. This tool has proved very helpful for me in resource management and I'd thought I'd just put it out there for use by anyone else that might find it useful.


Please take it easy on me as I'm no programmer, definitely not an elite excel user and very new to this profession, but I thought I'd just put this out there for anyone else in the community that could find it useful.


If you do find this useful and locate any miscalculations, see something missing or think of a feature that would be nice to have, please let me know.






PLEASE NOTE: The RIS Armor information is incomplete as I could only find the exact schematics of the boots and chest plate. If anyone has the other seven schematics, I would really appreciate it if you could either post them here or PM me with them so I can complete this spreadsheet. Thanks



+ Rainuan +
Owner of RainQuake Armor - Darkstone, Lok - 1485, 3789
Master Armorsmith | Master Tailor | Master Artisan

+ Maknar Serak +
Master Fencer | Master Rifleman | Expert Gunfighter
hopnasty
Tue May 18, 2004 4:35 pm
#2

Before you go any further, have you seen/tried our tool?


http://forums.station.sony.com/swg/board/message?board.id=armorsmith&message.id=40930




Shion
Master Armorsmith
MaknarSerak
Tue May 18, 2004 5:06 pm
#3

Yeah, I saw that one and it's very nice but I was confused by it. No offense as I know it's just me. Plus, I didn't see anything but Ubese and Composite as well as the ability to specify the exact number of suits you wanted. I just needed something straightforward. Don't worry about me going any further either, as I already have everything anArmorsmithcan buildin the spreadsheet with the exception of some RIS stuff.


Thanks for the link though and I hope you don't take offense to it not working for me.


Here is a link to the Excel file rather than the downloadable zip file if anyone wants to just take a peak - Excel version of AS Resource Tally Tool



+ Rainuan +
Owner of RainQuake Armor - Darkstone, Lok - 1485, 3789
Master Armorsmith | Master Tailor | Master Artisan

+ Maknar Serak +
Master Fencer | Master Rifleman | Expert Gunfighter
MaknarSerak
Wed May 19, 2004 8:32 am
#4

^



+ Rainuan +
Owner of RainQuake Armor - Darkstone, Lok - 1485, 3789
Master Armorsmith | Master Tailor | Master Artisan

+ Maknar Serak +
Master Fencer | Master Rifleman | Expert Gunfighter
Davy
Wed May 19, 2004 11:24 am
#5

OK I got the file, it looks pretty nice. But I can't tell what you've plugged in to each of the underlying sheets.


How do I unhide those columns?





Lei'lu, Elder Light Jedi

(gnn[[[[[[[[[[]nnnWX9ggggggggggggggggggggggggggggg)

Cassiopia Zorrak - DZ Crafts & Armor
Riverlands, Corellia

MaknarSerak
Wed May 19, 2004 11:41 am
#6

Woops, sorry about that. The download links above have been updated to allow viewing of the tabs that feed the calculator.



Thanks





+ Rainuan +
Owner of RainQuake Armor - Darkstone, Lok - 1485, 3789
Master Armorsmith | Master Tailor | Master Artisan

+ Maknar Serak +
Master Fencer | Master Rifleman | Expert Gunfighter
Kiom
Wed May 19, 2004 11:48 am
#7






Davy wrote:

OK I got the file, it looks pretty nice. But I can't tell what you've plugged in to each of the underlying sheets.


How do I unhide those columns?








Nice sheet.



You don't plug anything into the other sheet. Just put in the number of suits you want to make in the yellow box and it gives you the total resources.


I think the other sheets are just reference numbers used in the calculations.




Monroe Glesn - Distant cousin of Kiom
Master Tailor
MaknarSerak
Thu May 20, 2004 12:00 am
#8

Thanks and you're correct, Kiom. Everything but the "Calculator" sheet are just reference sheets from which the Calculator pulls it's information.



+ Rainuan +
Owner of RainQuake Armor - Darkstone, Lok - 1485, 3789
Master Armorsmith | Master Tailor | Master Artisan

+ Maknar Serak +
Master Fencer | Master Rifleman | Expert Gunfighter
MaknarSerak
Thu May 20, 2004 10:07 pm
#9

^



+ Rainuan +
Owner of RainQuake Armor - Darkstone, Lok - 1485, 3789
Master Armorsmith | Master Tailor | Master Artisan

+ Maknar Serak +
Master Fencer | Master Rifleman | Expert Gunfighter
SaintGadreel
Thu May 20, 2004 10:32 pm
#10

You gonna update this baby with the Wook Armor info? I'm actually diggin on this new toy.



Thyran Gadreel_________________Ariman'zen Gadreel
Lazy Master Armorsmith - FoE____Useless Smuggler - FoE
Official FoE Meatsheild __________Semi-Official FoE Meatsheild
Bastion Minister of Commerce ____Bastion Minister of Drug Abuse
Vendor Located In Bastion City, Naboo. Armor Hall by the TIE Fighter
MaknarSerak
Thu May 20, 2004 11:38 pm
#11

Just made Master Armorsmith tonight so that will be next on the list.



+ Rainuan +
Owner of RainQuake Armor - Darkstone, Lok - 1485, 3789
Master Armorsmith | Master Tailor | Master Artisan

+ Maknar Serak +
Master Fencer | Master Rifleman | Expert Gunfighter
WolfGuy
Mon Oct 18, 2004 11:38 pm
#12

File Not Found!




"zOMGz w3-3r g0nn@ pwn teh n00bz!! board the roflcopter troops!"- Fly
Taggart
WolfGuy <I> Gaun Hung-Lo <RIFT>
DARK JEDI KNOOB COMMANDO
v Offcial noob-schoolbus driveR v
Vendor at [ 1840, -5160 ] Athens, Rori
Jedi are total noobs
Page 1 of 1
Previous Next