Spreadsheet: 724500d1616182365-vlookup-match-formula-required-to-display-and-order-experimental-results-tester
Sheet: Raw_Data

 | Q_set [ul/min] | Q_ref[ul/min] | Q_ref_SD[ul/min] | Q_read[ul/min] | Q_read_SD[ul/min] | measurement_correct? |  |  |  | No of Sensor |  |  | No of Runs |  |  |  |  |  |  |  | Serial Nos | Date Stamp | Unique SN | Unique TS | Sorted | Complted Runs ALL |  |  | Q_set [ul/min] | Q_ref[ul/min] | Error (%) | Q_ref[ul/min] | Error (%) | Difference (%) | EXPT. Status
2 | 0.15 | 0.15798086326458 | 0.00456281768297266 | 0.115980921052631 | 0.00390967982952513 | FAILED | Run 1 |  | S:\SyncedFolder\Fluidic Analytics Main Drive\R&D\Flow_Sensors_Calibration\LG16-0150D\LG16-0150D_SN204800758_20210319_111642.csv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reading 1
3 | 0.2 | 0.205003111664295 | 0.00402368932975668 | 0.1602125 | 0.00507071276806234 | PASSED |  |  | LG16-0150D_SN204800758_20210319_111642.csv
4 | 0.3 | 0.319554957918444 | 0.00685463170432572 | 0.264953947368421 | 0.00864785528339288 | FAILED |  |  | 204800758 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flow Sensor ID
5 | 0.5 | 0.53925883119962 | 0.00735295024893167 | 0.46756447368421 | 0.021426270344842 | FAILED |  |  | 20210319-111642
6 | 0.8 | 0.850181423111941 | 0.00491907277518324 | 0.769071808510638 | 0.00394559308072139 | FAILED |  |  | 204800758_20210319-111642
7 | 1.3 | 1.36575850285125 | 0.00674446171168053 | 1.27087234042553 | 0.00626642944681392 | FAILED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Stamp:
8 | 0.15 | 0.150886191250774 | 0.00411556153453173 | 0.11235582010582 | 0.00380085803434608 | PASSED
9 | 0.2 | 0.20438463016588 | 0.0035311327582539 | 0.161045634920634 | 0.0030038180702211 | PASSED
10 | 0.3 | 0.314275026514609 | 0.00619947498792669 | 0.265193783068783 | 0.00524531810999399 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of Fails:
11 | 0.5 | 0.520981507823613 | 0.00674892324077017 | 0.464224999999999 | 0.00495658008814673 | PASSED
12 | 0.8 | 0.830640813686026 | 0.00695998836544523 | 0.764577127659574 | 0.00547851701194715 | PASSED
13 | 1.3 | 1.367057847321 | 0.00906408069267388 | 1.26435263157894 | 0.0525240066026656 | FAILED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File
14 | 0.15 | 0.150117193085943 | 0.00754084503770233 | 0.110716269841269 | 0.007210129951037 | PASSED
15 | 0.2 | 0.208266654812707 | 0.00379448290091265 | 0.162341447368421 | 0.00355064583660545 | PASSED
16 | 0.3 | 0.319512779148195 | 0.0054511529579153 | 0.265046296296296 | 0.00507641142589261 | FAILED
17 | 0.5 | 0.529463847158328 | 0.00657960390356906 | 0.463998670212765 | 0.00384431112832471 | FAILED
18 | 0.8 | 0.842977640469416 | 0.00593270466091261 | 0.763807894736842 | 0.0306660754204206 | FAILED
19 | 1.3 | 1.38584452050735 | 0.0080069704130619 | 1.26843552631578 | 0.00632644376229581 | FAILED
1 | 0.15 | 0.15798086326458 | 0.00456281768297266 | 0.133696710526315 | 0.00459007862613141 | FAILED | Run 2 |  | S:\SyncedFolder\Fluidic Analytics Main Drive\R&D\Flow_Sensors_Calibration\LG16-0150D\LG16-0150D_SN210700318_20210319_111642.csv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reading 2
2 | 0.2 | 0.205003111664295 | 0.00402368932975668 | 0.186872368421052 | 0.00419403625736569 | PASSED |  |  | LG16-0150D_SN210700318_20210319_111642.csv
3 | 0.3 | 0.319554957918444 | 0.00685463170432572 | 0.302604605263157 | 0.00465623783426967 | FAILED |  |  | 210700318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flow Sensor ID
4 | 0.5 | 0.53925883119962 | 0.00735295024893167 | 0.494534210526315 | 0.0204617121212749 | FAILED |  |  | 20210319-111642
5 | 0.8 | 0.850181423111941 | 0.00491907277518324 | 0.788605053191489 | 0.00448999422220338 | FAILED |  |  | 210700318_20210319-111642
6 | 1.3 | 1.36575850285125 | 0.00674446171168053 | 1.2830119680851 | 0.00606965806631485 | FAILED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Stamp:
7 | 0.15 | 0.150886191250774 | 0.00411556153453173 | 0.129267195767195 | 0.00445579297438966 | PASSED
8 | 0.2 | 0.20438463016588 | 0.0035311327582539 | 0.18803373015873 | 0.0033964208674299 | PASSED
9 | 0.3 | 0.314275026514609 | 0.00619947498792669 | 0.302905423280423 | 0.00518403662449793 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of Fails:
10 | 0.5 | 0.520981507823613 | 0.00674892324077017 | 0.491475 | 0.00505372071696748 | PASSED
11 | 0.8 | 0.830640813686026 | 0.00695998836544523 | 0.784063829787234 | 0.00567742134529457 | PASSED
12 | 1.3 | 1.367057847321 | 0.00906408069267388 | 1.28018684210526 | 0.00867511407897989 | FAILED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File
13 | 0.15 | 0.150117193085943 | 0.00754084503770233 | 0.127945105820105 | 0.00844090529324868 | PASSED
14 | 0.2 | 0.208266654812707 | 0.00379448290091265 | 0.189478947368421 | 0.0042769010374321 | PASSED
15 | 0.3 | 0.319512779148195 | 0.0054511529579153 | 0.302898809523809 | 0.00544652698102334 | FAILED
16 | 0.5 | 0.529463847158328 | 0.00657960390356906 | 0.490791223404255 | 0.00385028924246337 | FAILED
17 | 0.8 | 0.842977640469416 | 0.00593270466091261 | 0.783475 | 0.0302144023006078 | FAILED
18 | 1.3 | 1.38584452050735 | 0.0080069704130619 | 1.27950263157894 | 0.0062451571382929 | FAILED
2 | 0.15 | 0.152222432136083 | 0.00414195764278091 | 0.113573026315789 | 0.00286435735229245 | PASSED | Run 3 |  | S:\SyncedFolder\Fluidic Analytics Main Drive\R&D\Flow_Sensors_Calibration\LG16-0150D\LG16-0150D_SN204800758_20210319_102038.csv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reading 3
3 | 0.2 | 0.206225198412698 | 0.00462530475229659 | 0.163080687830687 | 0.00368457159998774 | PASSED |  |  | [NAME]
4 | 0.3 | 0.31174801446183 | 0.00616284669560361 | 0.264177631578947 | 0.00467654421442519 | PASSED |  |  | 204800758 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flow Sensor ID
5 | 0.5 | 0.522541615751389 | 0.00802380575869604 | 0.467764627659574 | 0.00599615850318815 | PASSED |  |  | 20210319-102038
6 | 0.8 | 0.825272641062114 | 0.00513421909100876 | 0.763311842105263 | 0.0315620477305083 | PASSED |  |  | 204800758_20210319-102038
7 | 1.3 | 1.35302032418056 | 0.00817122199015603 | 1.2630704787234 | 0.0523712500855292 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Stamp:
8 | 0.15 | 0.149885376447876 | 0.00694548951675862 | 0.110536375661375 | 0.00620882042122507 | PASSED
9 | 0.2 | 0.201853477655286 | 0.00506444889559276 | 0.15810197368421 | 0.00378795336041502 | PASSED
10 | 0.3 | 0.311271651115401 | 0.00666788279146033 | 0.262734126984127 | 0.00507424065745277 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of Fails:
11 | 0.5 | 0.517901330606922 | 0.00756719636383686 | 0.464657894736841 | 0.00459200459048273 | PASSED
12 | 0.8 | 0.822644120184014 | 0.00651616469540038 | 0.760485372340425 | 0.031535053974283 | PASSED
13 | 1.3 | 1.3541097613571 | 0.00812278857569925 | 1.26822340425531 | 0.00544834221668291 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File
14 | 0.15 | 0.148164905977406 | 0.0040899824955703 | 0.109431216931216 | 0.00317746873371782 | PASSED
15 | 0.2 | 0.206106962617379 | 0.00584296812818035 | 0.162475529100529 | 0.00529679120402051 | PASSED
16 | 0.3 | 0.313593541458124 | 0.00539240263840487 | 0.264931216931216 | 0.00432375739750483 | PASSED
17 | 0.5 | 0.519217147666283 | 0.00702580931292913 | 0.464470744680851 | 0.00476604623889817 | PASSED
18 | 0.8 | 0.826722957997891 | 0.00549298653419364 | 0.765098404255319 | 0.00364668948505516 | PASSED
19 | 1.3 | 1.35450746799431 | 0.0549413243061305 | 1.26568289473684 | 0.0524241942915335 | PASSED
1 | 0.15 | 0.152222432136083 | 0.00414195764278091 | 0.130611842105263 | 0.00330636279746828 | PASSED | Run 4 |  | S:\SyncedFolder\Fluidic Analytics Main Drive\R&D\Flow_Sensors_Calibration\LG16-0150D\LG16-0150D_SN210700318_20210319_102038.csv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reading 1
2 | 0.2 | 0.206225198412698 | 0.00462530475229659 | 0.189943121693121 | 0.00436801177943979 | PASSED |  |  | LG16-0150D_SN210700318_20210319_102038.csv
3 | 0.3 | 0.31174801446183 | 0.00616284669560361 | 0.301330263157894 | 0.00499956730235775 | PASSED |  |  | 210700318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flow Sensor ID
4 | 0.5 | 0.522541615751389 | 0.00802380575869604 | 0.495114361702127 | 0.00582188756822151 | PASSED |  |  | 20210319-102038
5 | 0.8 | 0.825272641062114 | 0.00513421909100876 | 0.783446052631578 | 0.0306086998122972 | PASSED |  |  | 210700318_20210319-102038
6 | 1.3 | 1.35302032418056 | 0.00817122199015603 | 1.28061037234042 | 0.007569189287683 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Stamp:
7 | 0.15 | 0.149885376447876 | 0.00694548951675862 | 0.128035714285714 | 0.00739618178110907 | PASSED
8 | 0.2 | 0.201853477655286 | 0.00506444889559276 | 0.184905263157894 | 0.00549186856186051 | PASSED
9 | 0.3 | 0.311271651115401 | 0.00666788279146033 | 0.300658068783068 | 0.00554976857391072 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of Fails:
10 | 0.5 | 0.517901330606922 | 0.00756719636383686 | 0.491971052631578 | 0.00475575143931215 | PASSED
11 | 0.8 | 0.822644120184014 | 0.00651616469540038 | 0.78401329787234 | 0.00608677914869118 | PASSED
12 | 1.3 | 1.3541097613571 | 0.00812278857569925 | 1.27976462765957 | 0.00596300355685049 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File
13 | 0.15 | 0.148164905977406 | 0.0040899824955703 | 0.126943783068783 | 0.00802424627603335 | PASSED
14 | 0.2 | 0.206106962617379 | 0.00584296812818035 | 0.18966865079365 | 0.00634328621078021 | PASSED
15 | 0.3 | 0.313593541458124 | 0.00539240263840487 | 0.302654761904761 | 0.00455844768410845 | PASSED
16 | 0.5 | 0.519217147666283 | 0.00702580931292913 | 0.491573138297872 | 0.00501825998975282 | PASSED
17 | 0.8 | 0.826722957997891 | 0.00549298653419364 | 0.784844414893617 | 0.00461587978172587 | PASSED
18 | 1.3 | 1.35450746799431 | 0.0549413243061305 | 1.282075 | 0.00659581588842822 | PASSED
2 | 0.15 | 0.1502118895211 | 0.00290558952886956 | 0.112358552631578 | 0.00278497644397786 | PASSED | Run 5 |  | S:\SyncedFolder\Fluidic Analytics Main Drive\R&D\Flow_Sensors_Calibration\LG16-0150D\LG16-0150D_SN204800758_20210319_091925.csv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reading 2
3 | 0.2 | 0.203918203918203 | 0.00392331513750575 | 0.162220899470899 | 0.00312645918876115 | PASSED |  |  | LG16-0150D_SN204800758_20210319_091925.csv
4 | 0.3 | 0.313685395922238 | 0.0059608250675352 | 0.265480263157894 | 0.00414268159251255 | PASSED |  |  | 204800758 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flow Sensor ID
5 | 0.5 | 0.537382571716453 | 0.00979378135550399 | 0.468515789473684 | 0.00437193061422898 | FAILED |  |  | 20210319-091925
6 | 0.8 | 0.824503985893788 | 0.00418320935074471 | 0.769527631578947 | 0.00267885354190783 | PASSED |  |  | 204800758_20210319-091925
7 | 1.3 | 1.34499368051562 | 0.00790777516502978 | 1.26855319148936 | 0.00621675268113677 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Stamp:
8 | 0.15 | 0.150119280464675 | 0.00380018047623822 | 0.112298684210526 | 0.030975275463803 | PASSED
9 | 0.2 | 0.205806958274063 | 0.00732940345504823 | 0.160972368421052 | 0.00595207043885154 | PASSED
10 | 0.3 | 0.310814534772868 | 0.00602683719309774 | 0.260088624338624 | 0.00240637511261149 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of Fails:
11 | 0.5 | 0.528614011285221 | 0.0107763689921415 | 0.464809840425531 | 0.00373890512495329 | FAILED
12 | 0.8 | 0.835707829540066 | 0.0340925410774496 | 0.763293421052631 | 0.00361543898802729 | PASSED
13 | 1.3 | 1.37752081851588 | 0.00774872724469442 | 1.26795131578947 | 0.00609033543823983 | FAILED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File
14 | 0.15 | 0.155753409659659 | 0.00428496611365235 | 0.110281746031746 | 0.00268482068204405 | PASSED
15 | 0.2 | 0.207320974248057 | 0.00467245484561299 | 0.16017791005291 | 0.00347225105526698 | PASSED
16 | 0.3 | 0.315826987701987 | 0.00461819006802186 | 0.264725529100529 | 0.00267215990321514 | FAILED
17 | 0.5 | 0.520092460881934 | 0.00911667955804093 | 0.464488157894736 | 0.00387345858516316 | PASSED
18 | 0.8 | 0.830292051920341 | 0.00455123061740423 | 0.766652631578947 | 0.00374983062327454 | PASSED
19 | 1.3 | 1.36186872544086 | 0.00756063515282234 | 1.27096010638297 | 0.00469765343954014 | PASSED
1 | 0.15 | 0.1502118895211 | 0.00290558952886956 | 0.128504605263157 | 0.00311362668598127 | PASSED | Run 6 |  | S:\SyncedFolder\Fluidic Analytics Main Drive\R&D\Flow_Sensors_Calibration\LG16-0150D\LG16-0150D_SN210700318_20210319_091925.csv |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reading 3
2 | 0.2 | 0.203918203918203 | 0.00392331513750575 | 0.188407407407407 | 0.00578348178814238 | PASSED |  |  | [NAME]
3 | 0.3 | 0.313685395922238 | 0.0059608250675352 | 0.302957236842105 | 0.00420089869721277 | PASSED |  |  | 210700318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flow Sensor ID
4 | 0.5 | 0.537382571716453 | 0.00979378135550399 | 0.495776315789473 | 0.00438891763243768 | FAILED |  |  | 20210319-091925
5 | 0.8 | 0.824503985893788 | 0.00418320935074471 | 0.786297368421052 | 0.0310111948887277 | PASSED |  |  | 210700318_20210319-091925
6 | 1.3 | 1.34499368051562 | 0.00790777516502978 | 1.27982180851063 | 0.00603366143813474 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Stamp:
7 | 0.15 | 0.150119280464675 | 0.00380018047623822 | 0.127344736842105 | 0.00328228348120884 | PASSED
8 | 0.2 | 0.205806958274063 | 0.00732940345504823 | 0.188484868421052 | 0.00706708112056215 | PASSED
9 | 0.3 | 0.310814534772868 | 0.00602683719309774 | 0.298263888888888 | 0.00246340683342203 | PASSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of Fails:
10 | 0.5 | 0.528614011285221 | 0.0107763689921415 | 0.492458776595744 | 0.00438496899157574 | FAILED
11 | 0.8 | 0.835707829540066 | 0.0340925410774496 | 0.783635526315789 | 0.00416556709082086 | PASSED
12 | 1.3 | 1.37752081851588 | 0.00774872724469442 | 1.27984868421052 | 0.00639140293636388 | FAILED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File
13 | 0.15 | 0.155753409659659 | 0.00428496611365235 | 0.12756746031746 | 0.0032561693743458 | PASSED
14 | 0.2 | 0.207320974248057 | 0.00467245484561299 | 0.187447751322751 | 0.00419322190483044 | PASSED
15 | 0.3 | 0.315826987701987 | 0.00461819006802186 | 0.302679894179894 | 0.00304092419102336 | FAILED
16 | 0.5 | 0.520092460881934 | 0.00911667955804093 | 0.492203947368421 | 0.00440219709982539 | PASSED
17 | 0.8 | 0.830292051920341 | 0.00455123061740423 | 0.786909210526315 | 0.0035018252319622 | PASSED
18 | 1.3 | 1.36186872544086 | 0.00756063515282234 | 1.28247340425531 | 0.00483816982041398 | PASSED