Ideas for Apache OpenOffice Calc
From Apache OpenOffice Wiki
Contents
- 1 Calc Add-ins
- 1.1 Function to return roots of quadratic equation
- 1.2 Numerical integration - Simpson's rules
- 1.3 Function to return astrological sign
- 1.4 Function to return calling code
- 1.5 Function to return chemical compound formula
- 1.6 Resistor color code calculator
- 1.7 Newton Raphson solver
- 1.8 Secant solver
- 1.9 Function to return RAL color
- 1.10 Thunderbird contacts
Calc Add-ins
Function to return roots of quadratic equation
Formerly bug 122171
Quadratic equation ax^2+bx+c=0
Proposed added function:
- quadratic(a,b,c,1) will return (-b+sqrt(b^2-4ac))/(2a)
- quadratic(a,b,c,2) will return (-b-sqrt(b^2-4ac))/(2a)
- error if complex root
Numerical integration - Simpson's rules
Formerly bug 122202
Given: equally spaced x values, x0 till xn and respective function values in two columns
- Three points n=2: Simpson's 1/3 ruleFunction
Simp13 = (x2-x0)*(f(x0)+4f(x1)+f(x2))/6
- Four points n=3: Simpson's 3/8 ruleFunction
Simp38 = (x3-x0)*(f(x0)+3f(x1)+3f(x2)+f(x3))/8
- Five points n=4: Simpson's 1/3 rule on first and last three points
- Six points n=5: Simpson's 1/3 rule on first three points and Simpson's 3/8 rule on last last four points
- etc.
Function to return astrological sign
Proposed added function:
- astrosign(19/07/2013)=Cancer
Function to return calling code
Proposed added function:
- callcode(Colombia)=57
Function to return chemical compound formula
Proposed added function:
- chemform(water)=H2O
Resistor color code calculator
Proposed added function:
- rescol(brown,red,orange)=12000 (ohm)
Newton Raphson solver
Proposed added function: given f(x)=0, d/dx(f(x))
- newraph(x,f(x),d/dx(f(x)),eps)=x-f(x)/(d/dx(f(x))
eps=convergence criteria
Secant solver
Proposed added function: given f(x)=0 (unlike Newton Raphson, function derivative not given)
- secant(x_i-1,x_i,f(x),eps)=x_i-(f(x_i)*(x_i-1-x_i))/(f(x_i-1)-f(x_i))
eps=convergence criteria
Function to return RAL color
Proposed added function:
- ral(2004) will color selection in "pure orange"
see link: https://www.ral-farben.de/uebersicht-ral-classic-farben.html?&L=1
Thunderbird contacts
Extension to make a list of contacts in Thunderbird.