Spreadsheet: 124019d1318001109-is-there-a-function-i-can-use-to-pull-in-data-to-this-table-extract-cardiac-outputs
Sheet: EchoTest

PT | Corrected vector | Cardiac Output | Helper1 | Helper2
1 | 11 | 0
1 | 10 | 4.42535551111111
1 | 9 | 4.204087735555555
1 | 8 | 0
1 | 7 | 4.204087735555555
1 | 6 | 4.757257174444444
1 | 5 | 3.938566404888888
1 | 4 | 4.867891062222221
1 | 3 | 4.42535551111111
1 | 2 | 6.881427819777777
1 | 1 | 3.982819959999999
1 | 11 | 3.314275181
1 | 10 | 5.405255659999999
1 | 9 | 5.689742799999999
1 | 8 | 5.860435083999999
1 | 7 | 3.850059294666666
1 | 6 | 4.589725858666665
1 | 5 | 0
1 | 4 | 0
1 | 3 | 5.765606037333331
1 | 2 | 0
1 | 1 | 0
10 | 11 | 4.903125700000001
10 | 10 | 4.24620944
10 | 9 | 4.666423080000001
10 | 8 | 4.264066620000001
10 | 7 | 4.618170700000001
10 | 6 | 5.202898360000001
10 | 5 | 4.585875800000001
10 | 4 | 0
10 | 3 | 0
10 | 2 | 4.1660421
10 | 1 | 3.893625120000001
11 | 11 | 1.602675188888889
11 | 10 | 1.544396091111111
11 | 9 | 1.748372933333333
11 | 8 | 1.544396091111111
11 | 7 | 1.631814737777778
11 | 6 | 1.660954286666667
11 | 5 | 1.602675188888889
11 | 4 | 0
11 | 3 | 1.690093835555555
11 | 2 | 1.602675188888889
11 | 1 | 1.566542148266667
12 | 1 | 8.250611875999999
12 | 2 | 9.2939350288
12 | 3 | 8.0586651832
12 | 4 | 7.764553315200001
12 | 5 | 10.29391538
12 | 6 | 9.8233363912
12 | 7 | 0
12 | 8 | 0
12 | 9 | 8.235132304
12 | 10 | 0
12 | 11 | 0
2 | 11 | 0
2 | 10 | 0
2 | 9 | 0
2 | 8 | 0
2 | 7 | 0
2 | 6 | 3.799065694666666
2 | 5 | 3.602562296666666
2 | 4 | 3.711730851111111
2 | 3 | 3.602562296666666
2 | 2 | 3.689897140222221
2 | 1 | 2.816548704666666
21 | 11 | 5.684192850000001
21 | 10 | 6.7470907
21 | 9 | 0
21 | 8 | 0
21 | 7 | 0
21 | 6 | 4.944785650000001
21 | 5 | 5.915257600000001
21 | 4 | 7.070581350000001
21 | 3 | 7.440284950000002
21 | 2 | 0
21 | 1 | 4.68863387
21 | 11 | 4.901873625
21 | 10 | 4.284600650000002
21 | 9 | 4.393531175
21 | 8 | 0
21 | 7 | 5.192355025
21 | 6 | 4.84839864
21 | 5 | 3.87924706
21 | 4 | 4.40871543
21 | 3 | 4.882068075
21 | 2 | 3.99411925
21 | 1 | 4.720322750000001
22 | 11 | 4.46442911288889
22 | 10 | 4.708577580000001
22 | 9 | 5.380857823366669
22 | 8 | 5.40614462888889
22 | 7 | 4.743455932444445
22 | 6 | 4.865530166
22 | 5 | 4.185402293333334
22 | 4 | 0
22 | 3 | 5.768007535500002
22 | 2 | 5.667732272222223
22 | 1 | 4.58693932585
23 | 1 | 3.183959999999999
23 | 2 | 2.280363944444444
23 | 3 | 2.224239279166667
23 | 4 | 3.338072508333333
23 | 5 | 0
23 | 6 | 2.731461795833333
23 | 7 | 3.296467290277778
23 | 8 | 2.68115965
23 | 9 | 3.370501730555555
23 | 10 | 0
23 | 11 | 2.614937704166666
24 | 1 | 3.658752115200001
24 | 2 | 3.586412544
24 | 3 | 3.74433696
24 | 4 | 3.890374592000001
24 | 5 | 0
24 | 6 | 3.718865280000001
24 | 7 | 0
24 | 8 | 0
24 | 9 | 0
24 | 10 | 0
24 | 11 | 3.768789772800001
25 | 1 | 2.866924666666668
25 | 2 | 3.269525000000001
25 | 3 | 3.051556666666667
25 | 4 | 2.92761388888889
25 | 5 | 3.964031944444445
25 | 6 | 3.624257777777779
25 | 7 | 0
25 | 8 | 0
25 | 9 | 3.269525000000001
25 | 10 | 0
25 | 11 | 0
26 | 1 | 4.4745
26 | 2 | 0
26 | 3 | 0
26 | 4 | 0
26 | 5 | 3.819025
26 | 6 | 4.6315
26 | 7 | 3.8779
26 | 8 | 3.925
26 | 9 | 3.21065
26 | 10 | 3.905374999999999
26 | 11 | 4.19975
27 | 11 | 0
27 | 10 | 0
27 | 9 | 0
27 | 8 | 0
27 | 7 | 0
27 | 6 | 4.828653692
27 | 5 | 0
27 | 4 | 4.8409299302
27 | 3 | 4.551301643777779
27 | 2 | 4.137546948888891
27 | 1 | 3.310037559111112
3 | 1 | 3.706491234986666
3 | 2 | 3.20581600768
3 | 3 | 3.230102492586666
3 | 4 | 3.486589568764444
3 | 5 | 3.054959572586667
3 | 6 | 0
3 | 7 | 3.402443125866667
3 | 8 | 3.080296915013333
3 | 9 | 3.157320879164445
3 | 10 | 3.405362174533333
3 | 11 | 3.33367033928
31 | 11 | 0
31 | 10 | 0
31 | 9 | 0
31 | 8 | 0
31 | 7 | 0
31 | 6 | 2.058999081833333
31 | 5 | 2.218898200222222
31 | 4 | 2.319832575666666
31 | 3 | 2.285013325
31 | 2 | 2.357553430555555
31 | 1 | 1.905110429333333
32 | 11 | 5.25559384
32 | 1 | 7.175779199999999
32 | 2 | 5.655909299999999
32 | 3 | 6.76798897
32 | 4 | 5.780488799999999
32 | 5 | 5.657155094999999
32 | 6 | 6.348571319999999
32 | 7 | 6.698639715
32 | 8 | 5.906729359999999
32 | 9 | 5.419208249999999
32 | 10 | 5.997257129999999
33 | 1 | 5.16226048
33 | 2 | 4.900114440000001
33 | 3 | 4.799289040000001
33 | 4 | 4.059549
33 | 5 | 5.230184960000001
33 | 6 | 4.377945
33 | 7 | 5.202590640000001
33 | 8 | 5.482779120000001
33 | 9 | 5.293333500000001
33 | 10 | 0
33 | 11 | 3.840651750000001
34 | 11 | 0
34 | 10 | 0
34 | 9 | 0
34 | 8 | 0
34 | 7 | 0
34 | 6 | 0
34 | 5 | 0
34 | 4 | 6.391835691377778
34 | 3 | 6.624719750400001
34 | 2 | 5.949979775822221
34 | 1 | 6.3486897608
35 | 6 | 3.703380195555555
35 | 5 | 3.885941191111112
35 | 4 | 4.362171733333334
35 | 3 | 4.071360284444445
35 | 2 | 3.456512
35 | 1 | 4.309296924444445
35 | 11 | 3.727674026666667
35 | 10 | 0
35 | 9 | 0
35 | 8 | 0
35 | 7 | 0
36 | 1 | 7.158321626866669
36 | 2 | 0
36 | 3 | 0
36 | 4 | 0
36 | 5 | 0
36 | 6 | 6.220529656000002
36 | 7 | 7.987725581000001
36 | 8 | 5.937778308
36 | 9 | 6.185971157911112
36 | 10 | 7.208981243383335
36 | 11 | 7.801580943566669
37 | 11 | 3.979949999999999
37 | 10 | 0
37 | 9 | 0
37 | 8 | 0
37 | 7 | 0
37 | 6 | 4.121090819444444
37 | 5 | 0
37 | 4 | 4.209902666666666
37 | 3 | 3.775056277777777
37 | 2 | 3.984372166666666
37 | 1 | 4.11924825
38 | 1 | 2.28159936
38 | 2 | 0
38 | 3 | 0
38 | 4 | 0
38 | 5 | 0
38 | 6 | 2.106136857777777
38 | 7 | 0
38 | 8 | 0
38 | 9 | 0
38 | 10 | 0
38 | 11 | 0
39 | 11 | 3.935200638888888
39 | 10 | 3.382513800555556
39 | 9 | 3.946632506666667
39 | 8 | 3.407575972222222
39 | 7 | 4.101402408888889
39 | 6 | 4.61407771
39 | 5 | 3.04703245
39 | 4 | 4.22627358
39 | 3 | 3.216312030555556
39 | 2 | 0
4 | 1 | 3.08450835
4 | 2 | 3.946509
4 | 3 | 3.7734165
4 | 4 | 4.15422
4 | 5 | 3.808035
4 | 6 | 4.3965495
4 | 7 | 4.708116
4 | 8 | 4.361930999999999
4 | 9 | 40.15746
4 | 10 | 3.8426535
41 | 1 | 3.69264
41 | 2 | 3.84336
41 | 3 | 2.91392
41 | 4 | 3.964564
41 | 5 | 0
41 | 6 | 3.871934
42 | 10 | 2.439178166666667
42 | 9 | 3.143270833333334
42 | 8 | 2.530710213333334
42 | 7 | 2.828440826666667
42 | 6 | 3.445024833333334
42 | 5 | 2.52098702888889
42 | 4 | 3.319294
42 | 3 | 3.294147833333334
42 | 2 | 2.828440826666667
42 | 1 | 3.647200013333334
42 | 11 | 2.902873480000001
43 | 1 | 2.2185984
43 | 2 | 2.7973632
43 | 3 | 2.7973632
43 | 4 | 2.733056
43 | 5 | 0
43 | 6 | 2.893466737777778
43 | 7 | 2.6044416
43 | 8 | 3.5690496
43 | 9 | 2.8295168
43 | 10 | 3.108181333333334
43 | 11 | 2.7973632
5 | 11 | 3.8151
5 | 10 | 0
5 | 9 | 4.261607999999999
5 | 8 | 4.144800000000001
5 | 7 | 4.3803
5 | 6 | 4.086081999999999
5 | 5 | 3.965506
5 | 4 | 0
5 | 3 | 3.903648
5 | 2 | 4.171804
5 | 1 | 3.83394
51 | 4 | 4.58360715
51 | 3 | 3.639923325
51 | 2 | 3.99043446
51 | 1 | 3.770421316800001
51 | 11 | 0
51 | 10 | 0
51 | 9 | 3.6215888964
51 | 8 | 0
51 | 7 | 0
51 | 6 | 4.2776738414
51 | 5 | 4.0702431492
52 | 11 | 0
52 | 10 | 1.300190092222222
52 | 9 | 1.222617351666667
52 | 8 | 1.057150341666667
52 | 7 | 1.130691235
52 | 6 | 1.195039516666667
52 | 5 | 1.337605634444445
52 | 4 | 1.26277455
52 | 3 | 1.286965633333334
52 | 2 | 1.201167924444445
52 | 1 | 1.110854546666667
53 | 1 | 4.45332384
53 | 2 | 4.89297879
53 | 3 | 5.054301
53 | 4 | 5.231201535
53 | 5 | 0
53 | 6 | 4.58625888
53 | 7 | 0
53 | 8 | 0
53 | 9 | 0
53 | 10 | 0
53 | 11 | 0
54 | 3 | 0
54 | 4 | 0
54 | 5 | 0
54 | 6 | 3.255552
54 | 7 | 0
54 | 8 | 0
54 | 9 | 0
54 | 10 | 2.950344
54 | 11 | 2.828769480000001
54 | 1 | 3.621801600000001
54 | 2 | 0
55 | 11 | 0
55 | 10 | 4.441498600000001
55 | 9 | 4.857152960000001
55 | 8 | 4.531164440000001
55 | 7 | 4.75988832
55 | 6 | 4.494690200000001
55 | 5 | 4.10943104
55 | 4 | 4.632988360000001
55 | 3 | 3.816117360000001
55 | 2 | 4.3921064
55 | 1 | 4.133747200000001
56 | 9 | 5.868032
56 | 10 | 5.68475648
56 | 11 | 5.555070293333334
56 | 1 | 5.869103786666667
56 | 2 | 5.736202240000001
56 | 3 | 5.476829866666667
56 | 4 | 5.351788088888889
56 | 5 | 5.015961600000001
56 | 6 | 5.19602176
56 | 7 | 5.358933333333335
56 | 8 | 5.001671111111111
57 | 1 | 2.447246222222223
57 | 2 | 2.447246222222223
57 | 3 | 2.67839488
57 | 4 | 2.927763911111112
57 | 5 | 2.875960888888889
57 | 6 | 2.730912426666667
57 | 7 | 3.065309866666666
57 | 8 | 2.656601884444445
57 | 9 | 2.749490062222223
57 | 10 | 2.7973632
57 | 11 | 2.688755484444445
58 | 1 | 2.83525515
58 | 2 | 3.531087
58 | 3 | 3.563282205000001
58 | 4 | 2.46760668
58 | 5 | 2.561769
58 | 6 | 2.8179459
58 | 7 | 2.34298008
58 | 8 | 2.92041666
58 | 9 | 2.552422005
58 | 10 | 2.48491593
58 | 11 | 2.78678925
59 | 11 | 0
59 | 10 | 0
59 | 9 | 0
59 | 8 | 0
59 | 7 | 0
59 | 6 | 0
59 | 5 | 0
59 | 4 | 3.375007020000001
59 | 3 | 3.250766640000001
59 | 2 | 3.462013280000001
59 | 1 | 3.43009832
6 | 1 | 3.22808328
6 | 2 | 2.6654832
6 | 3 | 3.1945104
6 | 4 | 3.128382
6 | 5 | 0
6 | 6 | 0
6 | 7 | 0
6 | 8 | 0
6 | 9 | 0
6 | 10 | 0
6 | 11 | 0
61 | 11 | 0
61 | 10 | 0
61 | 9 | 0
61 | 8 | 0
61 | 7 | 0
61 | 6 | 5.372163199999999
61 | 5 | 0
61 | 4 | 0
61 | 3 | 4.771223022222221
61 | 2 | 4.968847644444445
61 | 1 | 5.222936444444444
62 | 2 | 4.831317039999999
62 | 1 | 4.315476444444443
62 | 11 | 5.138240177777778
62 | 10 | 0
62 | 9 | 0
62 | 8 | 5.202770666666666
62 | 7 | 4.55181936
62 | 6 | 4.712742266666666
62 | 5 | 0
62 | 4 | 4.801068373333333
62 | 3 | 4.577228239999999
65 | 11 | 0
65 | 10 | 0
65 | 9 | 3.987850240000001
65 | 8 | 4.392866280000001
65 | 7 | 4.468094400000001
65 | 6 | 4.386027360000001
65 | 5 | 4.445298000000001
65 | 4 | 4.468094400000001
65 | 3 | 4.468094400000001
65 | 2 | 4.346513600000002
65 | 1 | 3.955935280000001
7 | 1 | 4.342714200000001
7 | 2 | 5.471136000000001
7 | 3 | 5.847276600000001
7 | 4 | 5.402746800000002
7 | 5 | 5.436941400000001
7 | 6 | 4.376908800000001
7 | 7 | 4.376908800000001
7 | 8 | 4.513687200000001
7 | 9 | 5.197579200000001
71 | 1 | 4.655895523499998
71 | 2 | 4.968758529499999
71 | 3 | 4.723819728749999
71 | 4 | 4.909067561249998
71 | 5 | 4.793390581399998
71 | 6 | 5.443816304399998
71 | 7 | 5.737331203449998
71 | 8 | 5.193525899599999
71 | 9 | 4.683065205599998
71 | 10 | 4.771984165199998
71 | 11 | 5.940280495499998
8 | 11 | 0
8 | 10 | 0
8 | 9 | 0
8 | 8 | 0
8 | 7 | 0
8 | 6 | 0
8 | 5 | 0
8 | 4 | 5.013271666666668
8 | 3 | 4.541006944444446
8 | 2 | 6.318517333333336
8 | 1 | 4.374325277777779