Collection of global functions
I just finished building a relatively large, I think, CRM and Project Management application which required a bunch of global functions. The more generic I've shared at : https://github.com/rmcilmoyle/ninox
3 replies
-
Looks great, thanks for sharing Roger.
-
I have others that focus on providing a complete project management suite that provides; waterfall, Agile, and Hybrid. Those need a little tidy work before I share as they are somewhat specific to how we project manage.
-
Hi Roger, here is set of additional functions that you can add to your project. These are functions used in excel to calculate interest rates and annuities
function vpm(k : number,n : number,t : number) doif n = 0 then0elseif t = 0 thenk / nelselet Pv := t;let APR := number(k);let R := APR / 100 / 12;let numerator := Pv * R;let x := 1 + R;for i in range(1, n) dox := x * (1 + R)end;let denominator := 1 - 1 / x;numerator / denominatorendendend;function fv(Pv : number,R : number,n : number) dolet y := 1 + R;let x := y;for i in range(1, n) dox := x * yend;Pv * xend;function princPer1(k : number,n : number,t : number) doif n = 0 thenkelseif t = 0 thenvpm(k, n, t)else(k * t) / (pow(1 + t, n) - 1)endendend;function amortissementPn(k : number,n : number,t : number,p : number) dolet A := princPer1(k, n, t);if p = 1 or t = 0 thenAelsepow(1 + t, p - 1) * Aendend;function intPer(k : number,n : number,t : number,p : number) dolet m := vpm(k, n, t);let apn := amortissementPn(k, n, t, p);m - apnend
Content aside
- 4 yrs agoLast active
- 3Replies
- 1069Views
