Spreadsheet: 186311d1349981262-determining-if-a-value-is-within-a-range-when-there-are-gaps-overlaps-sample-data-for-analysis
Sheet: Gaze Data

 | FixationBegin | Duration | FixationEnds | Gaze Location
 | 19308 | 0.868 | 19360.08 | 0
 | 19361 | 0.167 | 19371.02 | 0
 | 19375 | 0.133 | 19382.98 | 1
 | 19423 | 0.167 | 19433.02 | 4
 | 19434 | 0.651 | 19473.06 | 4
 | 19477 | 0.217 | 19490.02 | 0
 | 19507 | 0.1 | 19513 | 4
 | 19522 | 0.467 | 19550.02 | 0
 | 19551 | 0.184 | 19562.04 | 0
 | 19577 | 0.15 | 19586 | 4
 | 19590 | 0.1 | 19596 | 4
 | 19647 | 0.217 | 19660.02 | 0
 | 19661 | 0.234 | 19675.04 | 4
 | 19677 | 0.167 | 19687.02 | 4
 | 19691 | 0.167 | 19701.02 | 0
 | 19702 | 0.25 | 19717 | 4
 | 19729 | 0.117 | 19736.02 | 4
 | 19737 | 0.2 | 19749 | 4
 | 19750 | 0.1 | 19756 | 4
 | 19759 | 0.133 | 19766.98 | 4
 | 19788 | 0.184 | 19799.04 | 0
 | 19834 | 0.184 | 19845.04 | 0
 | 19863 | 0.15 | 19872 | 0
 | 19877 | 0.434 | 19903.04 | 4
 | 19921 | 0.267 | 19937.02 | 2
 | 19946 | 0.1 | 19952 | 4
 | 19969 | 0.3 | 19987 | 4
 | 19988 | 0.15 | 19997 | 4
 | 20001 | 0.133 | 20008.98 | 4
 | 20013 | 0.15 | 20022 | 4
 | 20025 | 0.167 | 20035.02 | 4
 | 20036 | 0.267 | 20052.02 | 4
 | 20053 | 0.2 | 20065 | 4
 | 20067 | 0.217 | 20080.02 | 4
 | 20082 | 0.117 | 20089.02 | 4
 | 20092 | 0.234 | 20106.04 | 4
 | 20123 | 0.367 | 20145.02 | 4
 | 20146 | 0.584 | 20181.04 | 4
 | 20183 | 1.151 | 20252.06 | 4
 | 20254 | 0.133 | 20261.98 | 0
 | 20263 | 0.45 | 20290 | 4
 | 20325 | 0.133 | 20332.98 | 4
 | 20359 | 0.334 | 20379.04 | 4
 | 20380 | 0.2 | 20392 | 4
 | 20399 | 0.117 | 20406.02 | 1
 | 20432 | 0.384 | 20455.04 | 4
 | 20456 | 0.167 | 20466.02 | 0
 | 20467 | 0.184 | 20478.04 | 4
 | 20479 | 0.284 | 20496.04 | 4
 | 20514 | 0.117 | 20521.02 | 4
 | 20525 | 0.4 | 20549 | 4
 | 20553 | 0.184 | 20564.04 | 0
 | 20565 | 0.234 | 20579.04 | 4
 | 20629 | 0.2 | 20641 | 4
 | 20642 | 0.25 | 20657 | 4
 | 20659 | 0.484 | 20688.04 | 4
 | 20689 | 0.217 | 20702.02 | 4
 | 20703 | 0.4 | 20727 | 4
 | 20733 | 0.634 | 20771.04 | 4
 | 20772 | 0.2 | 20784 | 4
 | 20785 | 0.734 | 20829.04 | 4
 | 20831 | 0.25 | 20846 | 4
 | 20865 | 0.2 | 20877 | 4
 | 20878 | 0.117 | 20885.02 | 4
 | 20888 | 0.284 | 20905.04 | 4
 | 20907 | 0.35 | 20928 | 4
 | 20944 | 0.217 | 20957.02 | 4
 | 20958 | 0.634 | 20996.04 | 4
 | 20999 | 0.133 | 21006.98 | 4
 | 21009 | 0.15 | 21018 | 4
 | 21019 | 0.184 | 21030.04 | 4
 | 21033 | 0.15 | 21042 | 4
 | 21047 | 0.1 | 21053 | 4
 | 21055 | 0.117 | 21062.02 | 0
 | 21065 | 0.167 | 21075.02 | 4
 | 21086 | 0.15 | 21095 | 4
 | 21096 | 0.2 | 21108 | 4
 | 21109 | 0.133 | 21116.98 | 4
 | 21123 | 0.2 | 21135 | 4
 | 21136 | 0.501 | 21166.06 | 4
 | 21167 | 0.651 | 21206.06 | 4
 | 21228 | 0.367 | 21250.02 | 4
 | 21277 | 0.167 | 21287.02 | 4
 | 21288 | 0.15 | 21297 | 4
 | 21303 | 0.234 | 21317.04 | 0
 | 21341 | 0.133 | 21348.98 | 4
 | 21352 | 0.984 | 21411.04 | 4
 | 21412 | 0.133 | 21419.98 | 4
 | 21421 | 0.184 | 21432.04 | 4
 | 21433 | 0.35 | 21454 | 4
 | 21455 | 0.2 | 21467 | 4
 | 21474 | 0.117 | 21481.02 | 4
 | 21486 | 0.117 | 21493.02 | 4
 | 21494 | 0.267 | 21510.02 | 4
 | 21511 | 0.434 | 21537.04 | 4
 | 21538 | 0.2 | 21550 | 4
 | 21564 | 0.35 | 21585 | 4
 | 21587 | 0.384 | 21610.04 | 2
 | 21613 | 0.334 | 21633.04 | 1
 | 21684 | 0.117 | 21691.02 | 4
 | 21692 | 0.434 | 21718.04 | 4
 | 21722 | 0.267 | 21738.02 | 1
 | 21752 | 0.117 | 21759.02 | 4
 | 21762 | 1.418 | 21847.08 | 4
 | 21848 | 0.284 | 21865.04 | 4
 | 21867 | 0.217 | 21880.02 | 4
 | 21912 | 0.45 | 21939 | 4
 | 21940 | 0.1 | 21946 | 4
 | 21949 | 0.3 | 21967 | 2
 | 21968 | 0.217 | 21981.02 | 2
 | 21984 | 0.184 | 21995.04 | 4
 | 21996 | 0.4 | 22020 | 4
 | 22021 | 0.25 | 22036 | 4
 | 22037 | 0.367 | 22059.02 | 4
 | 22060 | 0.384 | 22083.04 | 4
 | 22095 | 0.217 | 22108.02 | 4
 | 22109 | 0.701 | 22151.06 | 4
 | 22152 | 0.384 | 22175.04 | 4
 | 22177 | 0.217 | 22190.02 | 4
 | 22200 | 0.3 | 22218 | 4
 | 22225 | 0.1 | 22231 | 4
 | 22235 | 0.234 | 22249.04 | 4
 | 22250 | 0.701 | 22292.06 | 4
 | 22293 | 0.184 | 22304.04 | 4
 | 22342 | 0.217 | 22355.02 | 4
 | 22356 | 0.384 | 22379.04 | 4
 | 22380 | 0.234 | 22394.04 | 4
 | 22396 | 0.25 | 22411 | 4
 | 22458 | 0.367 | 22480.02 | 4
 | 22481 | 0.2 | 22493 | 4
 | 22494 | 0.3 | 22512 | 4
 | 22517 | 0.15 | 22526 | 4
 | 22527 | 0.184 | 22538.04 | 4
 | 22547 | 0.267 | 22563.02 | 4
 | 22636 | 0.217 | 22649.02 | 4
 | 22660 | 0.117 | 22667.02 | 4
 | 22668 | 0.184 | 22679.04 | 4
 | 22680 | 0.184 | 22691.04 | 4
 | 22700 | 0.284 | 22717.04 | 4
 | 22718 | 0.217 | 22731.02 | 4
 | 22732 | 0.133 | 22739.98 | 4
 | 22744 | 0.1 | 22750 | 0
 | 22757 | 0.267 | 22773.02 | 4
 | 22823 | 0.1 | 22829 | 2
 | 22836 | 0.167 | 22846.02 | 4
 | 22847 | 0.534 | 22879.04 | 4
 | 22880 | 0.4 | 22904 | 4
 | 22912 | 0.1 | 22918 | 1
 | 22938 | 0.117 | 22945.02 | 4
 | 22947 | 0.584 | 22982.04 | 4
 | 23016 | 0.184 | 23027.04 | 4
 | 23028 | 0.2 | 23040 | 4
 | 23041 | 0.367 | 23063.02 | 4
 | 23064 | 0.601 | 23100.06 | 4
 | 23101 | 0.2 | 23113 | 4
 | 23119 | 0.384 | 23142.04 | 4
 | 23145 | 0.317 | 23164.02 | 4
 | 23166 | 0.35 | 23187 | 4
 | 23188 | 0.117 | 23195.02 | 4
 | 23204 | 0.1 | 23210 | 4
 | 23217 | 0.117 | 23224.02 | 4
 | 23245 | 0.15 | 23254 | 4
 | 23256 | 0.184 | 23267.04 | 4
 | 23272 | 0.617 | 23309.02 | 4
 | 23338 | 0.117 | 23345.02 | 2
 | 23366 | 0.1 | 23372 | 4
 | 23398 | 0.15 | 23407 | 0
 | 23422 | 0.167 | 23432.02 | 4
 | 23436 | 0.634 | 23474.04 | 4
 | 23475 | 0.133 | 23482.98 | 4
 | 23484 | 0.167 | 23494.02 | 4
 | 23498 | 0.284 | 23515.04 | 4
 | 23519 | 0.133 | 23526.98 | 4
 | 23546 | 0.133 | 23553.98 | 4
 | 23555 | 0.2 | 23567 | 2
 | 23555 | 0.2 | 23567 | 4
 | 23568 | 0.133 | 23575.98 | 4
 | 23578 | 0.35 | 23599 | 4
 | 23600 | 0.918 | 23655.08 | 4
 | 23656 | 0.1 | 23662 | 4
 | 23688 | 0.384 | 23711.04 | 4
 | 23712 | 0.634 | 23750.04 | 4
 | 23790 | 0.217 | 23803.02 | 0
 | 23808 | 0.184 | 23819.04 | 4
 | 23820 | 0.367 | 23842.02 | 4
 | 23885 | 0.1 | 23891 | 0
 | 23892 | 0.117 | 23899.02 | 0
 | 23903 | 0.2 | 23915 | 4
 | 23916 | 0.234 | 23930.04 | 4
 | 23931 | 0.184 | 23942.04 | 4
 | 23943 | 0.634 | 23981.04 | 4
 | 23991 | 0.551 | 24024.06 | 4
 | 24032 | 0.1 | 24038 | 4
 | 24042 | 0.684 | 24083.04 | 4
 | 24122 | 0.884 | 24175.04 | 4
 | 24176 | 0.167 | 24186.02 | 4
 | 24187 | 0.417 | 24212.02 | 4
 | 24215 | 0.35 | 24236 | 4
 | 24237 | 0.184 | 24248.04 | 4
 | 24318 | 0.651 | 24357.06 | 4
 | 24358 | 0.634 | 24396.04 | 4
 | 24397 | 0.184 | 24408.04 | 4
 | 24410 | 0.45 | 24437 | 4
 | 24439 | 0.25 | 24454 | 4
 | 24455 | 0.117 | 24462.02 | 4
 | 24490 | 0.284 | 24507.04 | 4
 | 24508 | 0.15 | 24517 | 4
 | 24518 | 0.133 | 24525.98 | 4
 | 24560 | 0.317 | 24579.02 | 4
 | 24580 | 0.384 | 24603.04 | 4
 | 24605 | 0.117 | 24612.02 | 4
 | 24625 | 0.117 | 24632.02 | 4
 | 24636 | 0.133 | 24643.98 | 4
 | 24648 | 0.133 | 24655.98 | 4
 | 24687 | 0.467 | 24715.02 | 4
 | 24716 | 0.133 | 24723.98 | 4
 | 24726 | 0.25 | 24741 | 4
 | 24747 | 0.434 | 24773.04 | 4
 | 24775 | 0.3 | 24793 | 4
 | 24797 | 0.234 | 24811.04 | 4
 | 24812 | 0.2 | 24824 | 4
 | 24825 | 0.35 | 24846 | 4
 | 24849 | 0.167 | 24859.02 | 4
 | 24861 | 0.117 | 24868.02 | 4
 | 24908 | 0.1 | 24914 | 4
 | 24915 | 0.1 | 24921 | 4
 | 24922 | 0.2 | 24934 | 4
 | 24935 | 0.267 | 24951.02 | 4
 | 24953 | 0.434 | 24979.04 | 4
 | 24981 | 0.334 | 25001.04 | 4
 | 25004 | 0.267 | 25020.02 | 4
 | 25034 | 0.117 | 25041.02 | 4
 | 25042 | 0.467 | 25070.02 | 4
 | 25071 | 0.2 | 25083 | 4
 | 25084 | 0.167 | 25094.02 | 4
 | 25095 | 0.217 | 25108.02 | 4
 | 25109 | 0.167 | 25119.02 | 4
 | 25120 | 0.417 | 25145.02 | 4
 | 25172 | 0.567 | 25206.02 | 4
 | 25213 | 0.15 | 25222 | 3
 | 25286 | 0.651 | 25325.06 | 4
 | 25327 | 0.4 | 25351 | 4
 | 25352 | 0.667 | 25392.02 | 4
 | 25416 | 0.217 | 25429.02 | 4
 | 25452 | 0.15 | 25461 | 0
 | 25470 | 0.601 | 25506.06 | 4
 | 25510 | 0.25 | 25525 | 0
 | 25532 | 0.1 | 25538 | 4
 | 25539 | 0.334 | 25559.04 | 4
 | 25560 | 0.367 | 25582.02 | 4
 | 25583 | 0.901 | 25637.06 | 4
 | 25638 | 0.25 | 25653 | 4
 | 25667 | 0.133 | 25674.98 | 4
 | 25676 | 0.484 | 25705.04 | 4
 | 25711 | 0.484 | 25740.04 | 4
 | 25747 | 0.234 | 25761.04 | 4
 | 25796 | 0.15 | 25805 | 4
 | 25813 | 0.267 | 25829.02 | 4
 | 25830 | 0.25 | 25845 | 4
 | 25846 | 0.184 | 25857.04 | 4
 | 25863 | 0.35 | 25884 | 4
 | 25885 | 0.167 | 25895.02 | 4
 | 25897 | 0.217 | 25910.02 | 4
 | 25911 | 0.267 | 25927.02 | 4
 | 25940 | 0.2 | 25952 | 4
 | 25953 | 0.15 | 25962 | 4
 | 25963 | 0.133 | 25970.98 | 4
 | 26003 | 0.2 | 26015 | 4
 | 26016 | 0.184 | 26027.04 | 4
 | 26028 | 0.284 | 26045.04 | 4
 | 26046 | 0.2 | 26058 | 4
 | 26059 | 0.601 | 26095.06 | 4
 | 26144 | 0.2 | 26156 | 4
 | 26157 | 0.567 | 26191.02 | 4
 | 26192 | 0.167 | 26202.02 | 4
 | 26204 | 0.15 | 26213 | 4
 | 26215 | 0.15 | 26224 | 4
 | 26225 | 0.284 | 26242.04 | 4
 | 26243 | 0.501 | 26273.06 | 4
 | 26274 | 0.45 | 26301 | 4
 | 26302 | 0.1 | 26308 | 4
 | 26309 | 0.117 | 26316.02 | 4
 | 26338 | 0.317 | 26357.02 | 4