Armorsmith Archive
Thread: AS Little Helper
bash_chelik wrote:
Another update:
- Several issues with resource stats retrieval macro corrected
Version v1.4 is available for download here
Simply awesome
AS little helper v1.5 is available for download here
bash_chelik wrote:
I dropped AS today, so there'll be no major updates to AS little helper in future. If any bug surface I'll try to correct it, though...
MayI say thankyou for all the work you put into this spreadsheet, it has been very valuable to me and has helped me a great deal.
bash_chelik wrote:
I dropped AS today, so there'll be no major updates to AS little helper in future. If any bug surface I'll try to correct it, though...
In the words of Luke Skymocker...
"It can't be! NooOoOooOoooOOoOOOoOO!"
but really - stupidity aside - great job on it mate, and I hope whichever profession you chose will benefit from your arrival as much as we have.
Cheers!
Message Edited by Danathal on 07-11-2005 01:28 AM
Danathal wrote:
FIrst off, hats off to am AMAZING tool. It's a solid part of my startup menu items now.I am having a bit of trouble with layers calculating in.I am trying to make Quad-layered (Energy) layers in recon armor. for some reason, as soon as I plug in more then a single "2" to the layers section of the recon segments, Kinetic and energy go to "NA."Anyone know a work-around?The Forumula text is:=IF($B$8<>0,CHOOSE($B$8,'Layer 1'!K11,'Layer 1'!K27,'Layer 1'!K43,'Layer 1'!K59,'Layer 1'!K75,'Layer 1'!K91,'Layer 1'!K108,'Layer 1'!K125,'Layer 1'!K142,0),0)
PS. The layers are showing -92.6 Kinetic, and +92.6 energy.
I just tried quad-layered thing and everything works fine.
Layer 1 slot corresponds to Layer 1 sheet, Layer 2 slot to Layer 2 sheet etc. So make sure you have entered all resource names on each layer sheet (Layer 1-4).
I must say I am a new smith and this tool is great, spent a few hours putting in my resources (automaic resource macro's don't work for me) playing with with what happens if I add this, what happens if i put a layer here a layer there, I have learnt a lot and its saved me using up resources.
I also use it to work out what resources I should be mining / buying also as a way of keeping track of what resources I have in my house. I have added a new line in the resource table to include price if the resource was purchased so I can keep track of costs.
Aulin
Master Armorsmith - Eclipse