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.
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.