The spreadsheet presented in the last post on sorting also includes links to many other Numpy functions.  The spreadsheet and associated Python file can be downloaded from:

xlNumpy.zip

The Numpy functions require xlwings and Numpy to be installed, which are included in the (free) Anaconda Python default installation.

All the Numpy functions in this spreadsheet return an array.  The whole array may be displayed either by entering as an array function, or using xlwings dynamic array formulas.  The spreadsheet also includes two VBA macros to display the entire array function (press Ctrl-Shift-S), or to re-size the display to the selected range (press Ctrl-Shift-R).  The next post on this topic will give more details.

The Numpy functions included are shown in the screenshots below.  See the Numpy Documentation for more details.:

Polynomial functions:

• xl_PolyRoots
• xl_PolyFromRoots
• xl_PolyVal

xl_PolyFit fits a polynomial to scattered data

• xl_PolyCompanion
• xl_PolyDer
• xl_PolyInt
• xl_PolyAdd
• xl_PolySub
• xl_PolyMul
• xl_PolyDiv
• xl_PolyPow

Maths functions operating on arrays:

• xl_add
• xl_subtract
• xl_multiply
• xl_divide
• xl_logaddexp
• xl_logaddexp2
• xl_true_divide
• xl_floor_divide
• xl_negative
• xl_positive
• xl_power
• xl_remainder

• xl_mod
• xl_fmod
• xl_divmod
• xl_absolute
• xl_fabs
• xl_rint
• xl_sign
• xl_heaviside
• xl_conj
• xl_exp
• xl_exp2
• xl_log
• xl_log2
• xl_log10
• xl_expm1
• xl_log1p

• xl_sqrt
• xl_square
• xl_cbrt
• xl_reciprocal

Trigonometric Functions:

• xl_sin
• xl_cos
• xl_tan
• xl_arcsin
• xl_arccos
• xl_arctan
• xl_arctan2
• xl_hypot

• xl_sinh
• xl_cosh
• xl_tanh
• xl_arcsinh
• xl_arccosh
• xl_arctanh
• xl_deg2rad
• xl_rad2deg

Floating Point Functions:

• xl_isfinite
• xl_isinf
• xl_isnan
• xl_fabs
• xl_signbit
• xl_copysign
• xl_nextafter
• xl_spacing

• xl_modf
• xl_ldexp
• xl_frexp
• xl_fmod
• xl_floor
• xl_ceil
• xl_trunc

Numerical Ranges:

• xl_arange
• xl_linspace

• xl_logspace
• xl_geomspace

• xl_meshgrid