Armorsmith Archive

Thread: AS Little Helper

Ziryc
Wed May 18, 2005 12:14 pm
#27


bash_chelik wrote:
Another update:


  • Several issues with resource stats retrieval macro corrected


Version v1.4 is available for download here



Simply awesome



EmekafIneof
EX 12pt Elder Master Armorsmith & R.I.S. certified.
Vendors located in The Firm on Tatooine 60, 3242
______________________________________________

---

bash_chelik
Wed May 18, 2005 5:42 pm
#28

I found another problem with resource stats retrieval macro. In cases where multiple resources contain the same string (i.e. Ovos and Ovosocoot) macro could return "Resource doesn't exist" message, although it's in the base. Version 1.5 corrects this problem.

AS little helper v1.5 is available for download here




Umma Gumma
Goberkain
Thu May 26, 2005 7:03 am
#29






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.
Saarek
Thu May 26, 2005 11:00 am
#30






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!"







------
"The Hawtness is my ally, and a powerful ally it is." RIP SAAREK CARVATHOS :: AUG 4, 2005
------
S A A R E K "SIR WANKSALOT" C A R V A T H O S _Starsider. && _Corbantis.
M A S T E R S C O U N D R E L I AM JACK'S IGNORED PROFESSION
C O A L I T I O N O F T H E L O S T S M U G G L E R S .

Saarek
Thu May 26, 2005 11:02 am
#31


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!







------
"The Hawtness is my ally, and a powerful ally it is." RIP SAAREK CARVATHOS :: AUG 4, 2005
------
S A A R E K "SIR WANKSALOT" C A R V A T H O S _Starsider. && _Corbantis.
M A S T E R S C O U N D R E L I AM JACK'S IGNORED PROFESSION
C O A L I T I O N O F T H E L O S T S M U G G L E R S .

da13ear
Mon Jun 06, 2005 10:17 am
#32

I hafta agree with everyone else Umma (nice Floyd reference!). You saved us a ton of work. thanks for all the effort put into this project.


MisterFoolish - SS
bash_chelik
Fri Jun 10, 2005 5:11 pm
#33

Thanks on all these kind words . I'm really glad you all find AS little helper useful...




Umma Gumma
bash_chelik
Sun Jul 10, 2005 3:53 pm
#34

Nothing new here, just /bump for new smiths




Umma Gumma
Danathal
Sun Jul 10, 2005 10:19 pm
#35


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 inmore thena 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.

Message Edited by Danathal on 07-11-2005 01:28 AM




Danatal!
RoH
Dan 'N' Esh. 5/15/06


bash_chelik
Mon Jul 11, 2005 3:43 am
#36


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).




Umma Gumma
Danathal
Mon Jul 11, 2005 6:16 am
#37

I feel like a retard... It was late, that's my excuse..


Anyhow.... I forgot to scroll the sheets back... I was only using 4.


Sooo sorry for my blonde moment.




Danatal!
RoH
Dan 'N' Esh. 5/15/06


bash_chelik
Wed Aug 03, 2005 8:31 am
#38

Hmm, bump...




Umma Gumma
Aulin
Wed Aug 03, 2005 8:53 am
#39


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

Page 3 of 4