Spreadsheet: 872287d1718672597-calculate-2-separate-ratios-from-two-variables-when-defined-irregular-conditions-are-met-ratio-selector-done-manually
Sheet: tab 1

Date | 2017-05-30 00:00:00 | 2017-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-09-17 00:00:00 | 2019-09-18 00:00:00 | 2019-09-19 00:00:00 | 2019-09-20 00:00:00 | 2019-09-23 00:00:00 | 2019-09-24 00:00:00 | 2019-09-25 00:00:00 | 2019-09-26 00:00:00 | 2019-09-27 00:00:00 | 2019-09-30 00:00:00 | 2019-10-01 00:00:00 | 2019-10-02 00:00:00 | 2019-10-03 00:00:00 | 2019-10-04 00:00:00 | 2019-10-07 00:00:00 | 2019-10-08 00:00:00 | 2019-10-09 00:00:00 | 2019-10-10 00:00:00
Data | 2.847311827956989 | 2.84865831842576 | 2.842291371994342 | 2.851851851851852 | 2.856359649122807 | 2.854545454545454 | 2.838420107719928 | 2.857813063875857 | 2.857696371961958 | 2.875611460517121 | 2.917857142857143 | 2.911095305832148 | 2.917195207892882 | 2.937142857142857 | 2.938181818181818 | 2.941091954022988 | 2.935332369942197 | 2.937680115273775 | 2.92829111666072 | 2.917460317460317 | 2.895244658855961 | 2.883356545961003 | 2.877486910994764 | 2.867872994195972 | 2.869296740994854 | 2.863401172818214 | 2.869671558350803 | 2.881350034794711 | 2.874870017331022 | 2.890531502991904 | 2.888733379986005 | 2.88011088011088 | 2.884869565217391 | 2.876325088339223 | 2.84971098265896 | 2.795371900826446 | 2.788774493523746 | 2.795918367346939 | 2.808397200933022 | 2.800858652575958 | 2.806930693069307 | 2.820202020202021 | 2.82585217684779 | 2.840725806451613 | 2.841767881241565 | 2.838742393509128 | 2.737199050525602 | 2.735570469798657 | 2.716402829235433 | 2.711802072885323 | 2.717063359034529 | 2.751196172248804 | 2.762827047230717 | 2.72559543777256 | 2.624589086127548 | 2.620223978919631 | 2.635454848383872 | 2.612795734755081 | 2.630769230769231 | 2.61571906354515 | 2.602348993288591 | 2.621247892074199 | 2.600203458799593 | 2.600618131868132 | 2.593599449415004 | 2.578231292517007 | 2.550861777627577 | 2.530952380952381 | 2.541396933560477 | 2.523972602739726 | 2.539649845520083 | 2.538648180242634 | 2.518995929443691 | 2.539130434782609 | 2.548268974700399 | 2.54223252732693 | 2.552878179384204 | 2.541086812458582 | 2.524156187954997 | 2.54045954045954 | 2.556115591397849 | 2.559118236472946 | 2.527 | 2.515070328198258 | 2.51090238175109 | 2.525042016806723 | 2.54222972972973 | 2.553177257525084 | 2.516237027117509 | 2.578659370725035 | 2.589205912684771 | 2.588195386702849 | 2.582828282828283 | 2.564662411823984 | 2.553511705685619 | 2.543608521970706
selector A | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
selector B |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
selected by A
selected by B
ratio A/B
ratio B/A