Excel Interface

effectus comes with binaries that read directly from a selection in Excel.

There is absolutely no need to export your data from Excel.

Example

If you have one column with values or one with values and another with frequencies, select them and execute on the command line

$ make_summary_xl
Pareto         True
Ratio          0.917
Causes         1/5
Effects        2/3
Variability    0.04

Command Reference

Consider the video tutorial for a short demo.

No binary takes a file as argument. Configurations may happen through options.

make_summary_xl [OPTIONS]

-h, --help

Display usage summary.

the_rule_xl [OPTIONS]

-h, --help

Display usage summary.

attain_causes_xl [OPTIONS]

-l, --limit

Causes ratio between 0 and 1 to attain.

-d, --delimiter

Column delimiter (default: ‘,’)

-p, --precision

Number of decimals to show (default: 3)

-a, --ascending

Cumulate values from smallest to biggest (default: biggest to smallest).

-h, --help

Display usage summary.

attain_effects_xl [OPTIONS]

-l, --limit

Effects ratio between 0 and 1 to attain.

-d, --delimiter

Column delimiter (default: ‘,’)

-p, --precision

Number of decimals to show (default: 3)

-a, --ascending

Cumulate values from smallest to biggest (default: biggest to smallest).

-h, --help

Display usage summary.

separate_causes_xl [OPTIONS]

-l, --limit

Causes ratio between 0 and 1 to attain (default: 0.2)

-d, --delimiter

Column delimiter (default: ‘,’)

-p, --precision

Number of decimals to show (default: 3)

-a, --ascending

Cumulate values from smallest to biggest (default: biggest to smallest).

-h, --help

Display usage summary.

separate_effects_xl [OPTIONS]

-l, --limit

Effects ratio between 0 and 1 to attain (default: 0.2)

-d, --delimiter

Column delimiter (default: ‘,’)

-p, --precision

Number of decimals to show (default: 3)

-a, --ascending

Cumulate values from smallest to biggest (default: biggest to smallest).

-h, --help

Display usage summary.