vimsheet.formula.functions.math_funcs

Math and aggregation built-in functions.

vimsheet.formula.functions.math_funcs.fn_sum(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_avg(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_count(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_counta(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_min(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_max(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_prod(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_stddev(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_stdevs(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_var(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_vars(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_median(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_mode(*args)[source]
Parameters:

args (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_percentile(range_val, n)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_sumif(range_val, criteria, sum_range=None)[source]
Parameters:

  • range_val (Any)

  • criteria (Any)

  • sum_range (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_countif(range_val, criteria)[source]
Parameters:

  • range_val (Any)

  • criteria (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_averageif(range_val, criteria, avg_range=None)[source]
Parameters:

  • range_val (Any)

  • criteria (Any)

  • avg_range (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_subtotal(func_num, range_val)[source]
Parameters:

  • func_num (Any)

  • range_val (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_abs(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_ceil(n, sig=1)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_floor(n, sig=1)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_round(n, d)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_roundup(n, d)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_rounddown(n, d)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_sqrt(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_pow(base, exp)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_exp(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_log(n, base=2.718281828459045)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_log10(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_ln(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_sin(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_cos(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_tan(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_asin(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_acos(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_atan(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_atan2(y, x)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_hypot(x, y)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_mod(n, d)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_rand()[source]
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_randbetween(lo, hi)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_sign(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_int(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_trunc(n, m=0)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_fact(n)[source]
Parameters:

n (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_gcd(a, b)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_lcm(a, b)[source]
Parameters:
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_pi()[source]
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_e()[source]
Return type:

Any

vimsheet.formula.functions.math_funcs.fn_dtr(deg)[source]
Parameters:

deg (Any)

Return type:

Any

vimsheet.formula.functions.math_funcs.fn_rtd(rad)[source]
Parameters:

rad (Any)

Return type:

Any