!NSS

ver 2b
<download>

Make sure you have version 2b!!

THIS IS A PRETTY GOOD UPGRADE.  More importantly, I have included a really good <README> file.  The readme is also included in RTF in the ZIP file.  I hope it helps.   This version allows you to use multiple files not just the default file; so, start creating some new uses for NSS and post them on the bulletin board!. 

If you are interested in the <SOURCE CODE> you can download it here.  The source code includes the math library as well as techniques for debugging using the emulator.

VERSION 1a

<Sample>

Here is another example.  It is a currency conversion spreadsheet.  Left Side is US$ to KRW and 4 other currencies.  Right side is KWR to US$ and the same 4 currencies.

<download>

This version is still not user configurable, but it soon will be since there is lots of extra room now in the main addin.

Please test it and let me know what you think.  
 

If I get enough feedback I'll "hurry-up" and add the user text file customization and release the math library. 

More importantly it includes atof and ftoa which by themselves take up almost 1K in an addin!!! 

There is room in the library for a lot more functions.  Any reccomendations?

The following calculations are hard coded samples of what you will be able to do:

1)Summation and average
$ -------------------------------------------
$SimpleSum&Avg;
G#SUM;
H#NUM;
I#AVG;
G=A+B+C+D+E+F;
I=G/H;

2)Sample Functions
$ -------------------------------------------
$Functions;
G#A^B;
H#A^(1/B);
I#Sqrt(C);
J#LOG(D);
K#LOG10(E);
L#EXP(F);
G=A^B;
H=A^(1/B);
I=C^0.5;
J=LOG(D);
K=LOG10(E);
L=EXP(E);

3) FINANCIAL FUNCTIONS
$ -------------------------------------------
$Present Value of Future Sum
A#FVAMT
B#RATE
C#NUMPER
D#PVAMT
D=A*(1/((1+B)^C))
$ -------------------------------------------
$FUTURE VALUE of Present Sum
A#PVAMT
B#RATE
C#NUMPER
D#FVAMT
D=A*(1+B)^C)
$ -------------------------------------------

4) Mortgage Calculation
$ -------------------------------------------
$Loan Amort;
A#PRINC;
B#RATE%;
C#MONTHS;
D#PAYMNT;
E=B/100;
D=A*(E/12)/(1-1/(EXP(C*LOG(1+E/12))));

5)Sample Trig Functions
$ -------------------------------------------
$TRIG FUNCS;
A#ANGLE;
B#Sin(A);
C#COS(A);
D#TAN(A);
G#RADIAN;
B=SIN(A);
C=COS(A);
D=TAN(A);
G=RAD(A);
 

6) CUSTOM: Concrete required for fence poles
$ -------------------------------------------
$Concrete Calc;
A#DIAM;
B#Depth;
C##Holes;
D#H/YD;
E#Yards;
F#Vol:1H;
F=(A/2)^2*3.1416*B;
D=46656/F;
E=C/D;

7) Back out the BEFORE TAX total for a given AFTER TAX total that has 2 TAXES applied to only 35% of before tax total.
$ -------------------------------------------
$Temp Tax Calc;
A#InvTOTL;
B#Tax%1;
C#Tax%2;
D#TFac1;
E#TFac2;
G#MtlB4Tx;
H#TAmt1;
I#TAmt2;
J#Check;
D=B/100*.35;
E=C/100*.35;
F=1/(D+E+1);
G=(A*F);
H=G*D;
I=G*E;
J=G+H+I;
 

8) Book and Discount Calculation
$ -------------------------------------------
$Book&Disc Price;
A#QTY;
B#BOOK$;
C#Dscnt%;
D#Net$;
E#Ext$;
F#Net%;
F=(100-C)/100;
D=B*F;
E=A*D;"
 

9) LABOR calculation Labor is 2 times the discounted extended price.
$ -------------------------------------------
$LABOR;
A##UNITS;
B#UNIT$;
C#Dscnt%;
D#Labor$;"
F=(100-C)/100;
E=A*B;
D=E*2*F;

/* ------------------------------------------------------------------- */
 

<README>

<25 OCT 01>

$ -------------------------------------------
$Present Value of Future Sum
A=FVAMT
B=RATE
C=NUMPER
D=PVAMT
D=A*(1/((1+B)^C))
$ -------------------------------------------
$FUTURE VALUE of Present Sum
A=PVAMT
B=RATE
C=NUMPER
D=FVAMT
D=A*(1+B)^C)
$ -------------------------------------------

DOWNLOAD ALL HERE!!!!!! (no source yet)

Due to the lack of interest, this is no longer being worked on.  Since release on 22 SEP, I have only had 1 comment regarding the program.