"MES" using Notes, Solver and CAS variables
03-22-2014, 01:33 PM (This post was last modified: 03-22-2014 02:29 PM by CR Haeger.)
Post: #1 CR Haeger Member Posts: 275 Joined: Dec 2013
"MES" using Notes, Solver and CAS variables
Here is my first swing at trying to create a multiple equation solver within the HP Prime. It certainly does not have features of the HP50G MES, but for me its useful enough for daily work. Basically, it is saved notes of CAS commands that can be copied/excecuted as needed. Once setup, I think this may save lots of typing later.

1. I created the following note "FinEqs" in Prime using algebraic format

F_A1:=fv=av*((1+rate)^per-1)/rate;
F_P1:=fv=pv*(rate+1)^per;
P_A1:=pv=av*(((1+rate)^per-1)/(rate*(1+rate)^per));
P_G1:=pv=gv*(((rate+1)^per-1)/(rate^2*(rate+1)^per)-per/(rate*(rate+1)^per));
Solve.E1:='F_A1';
Solve.E2:='F_P1';
Solve.E3:='P_A1';
Solve.E4:='P_G1';

2. Within FinEqs note, select shift/copy, All, Copy to load to clipboard

3. Within CAS (set to approx), shift/paste/1/Enter to paste to command line then Enter. This saves F_A1 etc to CAS variables as equations and loads the equations into E1-E4 in Solve App.

4. Within CAS, you can now solve for terms algebraically using say solve(F_A1,per) (returns {(-ln(av)+ln(fv*rate+av))/ln(rate+1)} for me)

5. Within the Solve App, you can solve equation(s)** numerically after accepting new user variables. Note - you should delete these user variables if not needed afterwards (Vars User Del).

Please comment on or improve this. Thanks to HP Team and experienced users for advice to date.

Best,
Carl

**Check that multiple equations solved simultaneously are correct and meaningful. For example, enabling E1 and E2 in Solve, with fv:2.0, rate:0.1 and per:10 fixed yield av:0.125 (annual or periodic pmt) and pv:0.771. In this case, I solved for two ways (av, pv) to achieve the target fv, given the rate and per(iods). This is not the same as starting with a pv and adding av payment per period.
03-26-2014, 09:17 PM
Post: #2 jebem Senior Member Posts: 1,342 Joined: Feb 2014
RE: "MES" using Notes, Solver and CAS variables
Nice work, hope You don't mind if I put this post's link into the HP Prime Math Tutorials in the index.
Thank You for sharing your work with us here.

Jose Mesquita

03-26-2014, 10:24 PM
Post: #3 CR Haeger Member Posts: 275 Joined: Dec 2013
RE: "MES" using Notes, Solver and CAS variables
(03-26-2014 09:17 PM)jebem Wrote:  Nice work, hope You don't mind if I put this post's link into the HP Prime Math Tutorials in the index.
Thank You for sharing your work with us here.

Thanks Jose and yes, please share as you wish.

I used these financial formulas out of an engineering economic table I used to use. These were used primarily for demonstrating the steps above to create reusable formulas for single/multiple, algebraic/numerical solutions.

Hopefully others can chime in with formulas from other disciplines and other ways to create/use these formulas - perhaps via CAS formulas in a Prime Spreadsheet App?

Best,
Carl
 « Next Oldest | Next Newest »

User(s) browsing this thread: 1 Guest(s)