Spreadsheet: 757892d1638499020-help-to-calculate-an-adjustable-average-for-rows-with-numbers-complicated-question-dynamic-average-eba
Sheet: Sheet1

Breath number | [NAME] | Ve | Events (2=apnea, 4=hypopnea) | BaselineSpo2 | [NAME] |  |  |  |  | BaselineVe | NadirSpO2
1 | 99 | 0.0109891765572638 | 2
2 | 99 | 0.149408120044767 | 0
3 | 98 | 0.20308227667215 | 0
4 | 98 | 0.17926389668247 | 0
5 | 95 | 0.188901327616932 | 0
6 | 96 | 0.173660460049241 | 0
7 | 98 | 0.149773491339436 | 2
8 | 99 | 0.146530734629909 | 2
9 | 99 | 0.0785332814366916 | 2
10 | 99 | 0.108479590953777 | 0
11 | 99 | 0.0860988188375358 | 0
12 | 99 | 0.0741324720268547 | 0
13 | 99 | 0.0232406290828906 | 0
14 | 99 | 0.121889150299091 | 0
15 | 99 | 0.159501191982426 | 0
16 | 98 | 0.0751648161247874 | 0
17 | 98 | 0.0806726099107084 | 2
18 | 98 | 0.097736091263588 | 2
19 | 99 | 0.163816115335861 | 2
20 | 98 | 0.0814720810404031 | 0
21 | 98 | 0.0809048617508465 | 0
22 | 98 | 0.0323312289876464 | 0
23 | 98 | 0.0372857991274904 | 0
24 | 98 | 0.0219826739675477 | 0
25 | 98 | 0.15123996411956 | 0
26 | 98 | 0.199927751790961 | 2
27 | 97 | 0.19597872938814 | 2
28 | 96 | 0.181752807059387 | 0
29 | 97 | 0.184461716363549 | 0
30 | 98 | 0.0937016437344139 | 4
31 | 99 | 0.0233647817421717 | 4
32 | 99 | 0.0385895869317287 | 4
33 | 99 | 0.0658901256814661 | 2
34 | 99 | 0.1115051320254 | 0
35 | 99 | 0.201776103129654 | 0
36 | 98 | 0.185546379484093 | 0
37 | 98 | 0.118896017736752 | 0
38 | 98 | 0.10593117852112 | 0
39 | 98 | 0.0423121221237973 | 2
40 | 99 | 0.00850332323999682 | 2
41 | 99 | 0 | 2
42 | 99 | 0.0548104807497618 | 2
43 | 99 | 0.109054607690351 | 0
44 | 98 | 0.263952979486173 | 0
45 | 96 | 0.203878796180989 | 0
46 | 95 | 0.212002963240034 | 0
47 | 96 | 0.143232863310096 | 0
48 | 98 | 0.156504303154903 | 0
49 | 99 | 0.103015727703362 | 0
50 | 99 | 0.0842088128526959 | 0
51 | 99 | 0.0891773265950762 | 0
52 | 99 | 0.0396847586686815 | 2
53 | 99 | 0.0132544728290232 | 2
54 | 99 | 0.00994825376441292 | 2
55 | 99 | 0.00951819924838878 | 2
56 | 99 | 0.159973921131817 | 0
57 | 97 | 0.171527347586614 | 0
58 | 96 | 0.329897878395867 | 0
59 | 93 | 0.221249741269465 | 0
60 | 95 | 0.214304617268371 | 0
61 | 98 | 0.15185501437019 | 0
62 | 99 | 0.112552579651284 | 0
63 | 99 | 0.128899241294772 | 0
64 | 100 | 0.0612862763617956 | 4
65 | 100 | 0.0660334710438418 | 4
66 | 99 | 0.0527643867111733 | 4
67 | 99 | 0.060549721403517 | 4
68 | 99 | 0.136514978475601 | 4
69 | 99 | 0.185661032296589 | 0
70 | 99 | 0.177362619139047 | 0
71 | 98 | 0.173993455385706 | 0
72 | 98 | 0.128964228129819 | 0
73 | 98 | 0.083458722003259 | 0
74 | 99 | 0.0286035304780331 | 0
75 | 99 | 0.0324799887710871 | 0
76 | 99 | 0.152718329144849 | 0
77 | 99 | 0.136660500326794 | 0
78 | 99 | 0.142736153200591 | 0
79 | 98 | 0.111649513585211 | 0
80 | 99 | 0.203518551799327 | 0
81 | 99 | 0.180721896745055 | 0
82 | 99 | 0.154048064248425 | 0
83 | 99 | 0.0838057945713941 | 0
84 | 99 | 0.029126541195009 | 2
85 | 99 | 0.0486097977481081 | 2
86 | 99 | 0.0143109442249667 | 2
87 | 99 | 0.0106206182331717 | 2
88 | 98 | 0.14210921036695 | 0
89 | 98 | 0.278102801416444 | 0
90 | 97 | 0.230617196477504 | 0
91 | 94 | 0.287057167980935 | 0
92 | 94 | 0.290227701606095 | 0
93 | 97 | 0.185680560835806 | 0
94 | 98 | 0.267049605140421 | 0
95 | 99 | 0.186154109046018 | 0
96 | 99 | 0.121531431486702 | 0
97 | 99 | 0.0870444660937032 | 0
98 | 100 | 0.0100644850266878 | 2
99 | 100 | 0 | 2
100 | 100 | 0 | 2
101 | 99 | 0.0252938876870604 | 2