Armorsmith Archive

Thread: Virtual Armorsmith

AegolinAdaron
Fri May 07, 2004 11:03 pm
#1

Been working on an Excel spreadsheet where you can enter your resources, stats, and distribution of experimentation points and it will give you an estimate of the stats of your layers, segments and armor. Nice if you want to try some things out without wasting resources.

Only thing is that I have no way of uploading it anywhere. Anyone interested in checking it out or even making it available to others? Let me know.


Emily
KryssPteska
Sat May 08, 2004 7:45 am
#2

ohhhh. if you upload this, send me a forum message
i will love you forever :*



Oigan Eivyme of House Corrino
Decoration Consultant | Oi! Industries CEO
[GuildChat] Oigan: brb, gotta go grab a cigarette
But all you savage cats, know that I was strapped wit gats when you were cuddlin a Cabbage Patch -Dr. Dre


oiyan
Sat May 08, 2004 3:53 pm
#3

me too



____________________________________________________________________________________
Oi-yun Cifo and Sizzlor-
12pt Master Architect/RIS cert Armoursmith/Artisan (Kauri Server)
Specializing in HQ heavy harvesters and HQ Armour
BER 13 heaves / CU armour - full suits or indv. pieces (in production phase)
Mangoville, Naboo at mango market [-5956, 2680],
12 point Architect, Armoursmith and Artisan


kardlan
Sat May 08, 2004 5:23 pm
#4

You may want to contact nathan118 or hopnasty in the thread Armorsmith Resource Dictionary v1.0 for they have set up an Excel spreadsheet for resources needed for making armor, layers, segments, and components, and it will tell u whatyou need for factory runs. It also has most of the resource caps.It sounds like it would work well with there spreadsheet.



DON'T FORGET TO HAVE FUN
AegolinAdaron
Sat May 08, 2004 6:50 pm
#5

Ok, here it is: http://web.tampabay.rr.com/hluinge/va10.zip

You will need Excel to use the spreadsheet. Only the blue text and numbers can be changed by the user. This is a prototype, any suggestions for improvement are welcome.


Emily
Preloaded
Sat May 08, 2004 9:32 pm
#6



Heh I've been working on this too. I'll post a link toi my ubese crafter shortly.


Web application is semi working for ubese armor @ swgarmory.com


REALLY REALLY beat right now.


I'm really humbled by your spreadsheet.


Shouldn't have posted this so soon. Sorry about thread hijack


Working components

Layers (All)- Max Resistance

Segments (Advanced Ubese)- Kinetic Resistance / Base Resistance

Armor (Ubese all components) - Kinetic Resistance / Base Resistance


(btw if you want me to kill this post i'll be more than happy to give your thread back )

Message Edited by Preloaded on 05-08-2004 09:36 PM

Message Edited by Preloaded on 05-08-2004 09:47 PM



Spyndel Vellack
$ $ $ $ $ $ $ No Credits $ $ $ $ $ $ $ $
Radiant's Poorest Armorsmith
$ $ $ $ $ $ $ No Problem $ $ $ $ $ $ $ $
...omg!?! you are teh lose!...
AegolinAdaron
Sat May 08, 2004 10:20 pm
#7

Ok, I had some more armor types that I didnt post yet. Here is an updated version: http://web.tampabay.rr.com/hluinge/va11.zip


I am aware that the spreadsheet still needs elaborate testing and improvements. By the way, I am very interested in your web application, Spyndel. Will be interesting to see if the results are similar. Oh and no I dont mind you posting about swgarmory at all. The more tools we have, the better for all of us.


Emily


oiyan
Sun May 09, 2004 11:11 am
#8

this is great. i suggest a method of working in different types of layers into one combine. that is the big problem we have right now. hard to determine what do use when we are making kinetic/energy/electric or kinetic/electric/energy/acid composite. consider that for the future and we will all be immensly happy


your sheet is still great though, dont get me wrong





____________________________________________________________________________________
Oi-yun Cifo and Sizzlor-
12pt Master Architect/RIS cert Armoursmith/Artisan (Kauri Server)
Specializing in HQ heavy harvesters and HQ Armour
BER 13 heaves / CU armour - full suits or indv. pieces (in production phase)
Mangoville, Naboo at mango market [-5956, 2680],
12 point Architect, Armoursmith and Artisan


hopnasty
Mon May 10, 2004 10:59 am
#9

Great work Emily!


I wanted to integrate expected experimentation outcomes into the Armor Dictionary also, however, I had no idea how to calculate the formulas. It was also requested by many people as a function they wanted to be added. I'm glad someone is working on it!


Also, would you be opposed to adding your work to the Armor Dictionary? Since you're running it off Excel, it would be a welcome addition to make the spreadsheet as a "one-stop" armorsmith resource tool. If not, I understand... Let me know and keep up the outstanding work!







Shion
Master Armorsmith
AegolinAdaron
Mon May 10, 2004 8:13 pm
#10

I have no objections whatsoever if you want to add VA to the dictionary. I am currently working on improving the predictions and extending it to all armor types.


Emily
Herms
Tue May 11, 2004 1:51 am
#11

Now this is what I've been looking for, for a long long time. Theres nothing worse than burning up some precious materials to test an idea only to find that the idea was... well... a silly one.

Thanks for taking the time to do this it's gonna get used an awful lot by me at least.


Are there plans to make versions that would calculate weights on full suits and/or is there any way that segment enhancers (eg NS Shards/Layers etc) could be worked into the equation? I think this would be perfect as it is when working with rare looted parts that this spreadsheet would really come into it's own.

Kudos emily you're a star!



HermS:- Ex-Armoursmith & Pikeyman

Waypoint:- Dantooine (Doomsville) -5059 4486
MaligY
Thu May 13, 2004 5:37 pm
#12

Great job but there seems to be some problems.


The forumlas are wrong perhaps. I'm not getting the same outcomes that this spreadsheet does.


Also here is a suggestion, Iuse 3 different types of kinetic layers.. maybe one layer with 3 pts in base, 2 other layers with 2 in base and 1 in kinetic resist etc. Would be nice to work on 3 different ata time. Thanks





______________________________
JA
Armory
The Finest Composite Armor in the Galaxy - Located on Dantooine, Valley of Darkness Mall
New Vendor located near Theed, Naboo at: -4491 3411
Jimmy


AegolinAdaron
Thu May 13, 2004 8:08 pm
#13






MaligY wrote:

Great job but there seems to be some problems.


The forumlas are wrong perhaps. I'm not getting the same outcomes that this spreadsheet does.


Also here is a suggestion, Iuse 3 different types of kinetic layers.. maybe one layer with 3 pts in base, 2 other layers with 2 in base and 1 in kinetic resist etc. Would be nice to work on 3 different ata time. Thanks









In version 1.2 I have changed some of the formulas that calculate the intial percentages. A non-linear model seems to be better in describing the relation between average resource stats and experimental quality/resistance. The relation between HAM costs and experimental durability seems to be a complex one and the results are only crude approximations. A lot more testing will be needed to improve the predictions. I will be working on that.


Version 1.2 can be found at http://web.tampabay.rr.com/hluinge/va12.zip


I agree that having different types of layers would be nice. I am trying to come up with a way to implement this.


Emily

Page 1 of 2
Previous Next