Spreadsheet: 782820d1654285790-using-aggregate-indexed-to-return-multiple-returns-but-multiple-criteria-sample-ws
Sheet: RS_RESERVATION

[NAME] | INV_UNIT | [NAME] | [NAME] | RES_DEPART_DT | RES_DT | RESORT | ORIGIN_CD | SOURCE_CD | RES_RATE | RES_CHECKIN_DT | RES_CHECKOUT_DT | RES_ACT_DEPART_DT
16211631 | 603 | C | 2022-06-01 00:00:00 | 2022-06-03 00:00:00 | 2022-05-30 00:00:00 | 8 | 1 | 12 | 134.19
16018120 |  | C | 2022-06-02 00:00:00 | 2022-06-04 00:00:00 | 2022-03-14 00:00:00 | 8 | 667 | 23 | 145.76
16065002 |  | X | 2022-06-02 00:00:00 | 2022-06-06 00:00:00 | 2022-03-31 00:00:00 | 8 | 309 | 23 | 124.75
16065004 |  | X | 2022-06-02 00:00:00 | 2022-06-06 00:00:00 | 2022-03-31 00:00:00 | 8 | 309 | 23 | 124.75
16064982 |  | X | 2022-06-02 00:00:00 | 2022-06-05 00:00:00 | 2022-03-31 00:00:00 | 8 | 309 | 23 | 127.11
16117593 |  | C | 2022-06-02 00:00:00 | 2022-06-05 00:00:00 | 2022-04-19 00:00:00 | 8 | 229 | 23 | 149.43
16184007 |  | X | 2022-06-02 00:00:00 | 2022-06-04 00:00:00 | 2022-05-17 00:00:00 | 8 | 168 | 30 | 196.97
16178517 |  | C | 2022-06-02 00:00:00 | 2022-06-04 00:00:00 | 2022-05-15 00:00:00 | 8 | 667 | 23 | 178.37
15615710 |  | C | 2022-06-03 00:00:00 | 2022-06-10 00:00:00 | 2021-10-16 00:00:00 | 8 | 17 | 2
15616024 |  | X | 2022-06-03 00:00:00 | 2022-06-06 00:00:00 | 2021-10-17 00:00:00 | 8 | 168 | 30 | 164.1
15614868 |  | X | 2022-06-03 00:00:00 | 2022-06-10 00:00:00 | 2021-10-16 00:00:00 | 8 | 17 | 2
15580309 |  | C | 2022-06-03 00:00:00 | 2022-06-10 00:00:00 | 2021-10-05 00:00:00 | 8 | 17 | 2
16065850 |  | C | 2022-06-03 00:00:00 | 2022-06-05 00:00:00 | 2022-03-31 00:00:00 | 8 | 667 | 23 | 154.03
16092298 |  | C | 2022-06-03 00:00:00 | 2022-06-05 00:00:00 | 2022-04-09 00:00:00 | 8 | 632 | 4 | 189
16148565 |  | C | 2022-06-03 00:00:00 | 2022-06-05 00:00:00 | 2022-05-02 00:00:00 | 8 | 904 | 4 | 170.1
16138215 |  | X | 2022-06-03 00:00:00 | 2022-06-06 00:00:00 | 2022-04-27 00:00:00 | 8 | 904 | 4 | 164.01
16133019 |  | C | 2022-06-03 00:00:00 | 2022-06-05 00:00:00 | 2022-04-25 00:00:00 | 8 | 309 | 23 | 131.83
16120760 |  | C | 2022-06-03 00:00:00 | 2022-06-10 00:00:00 | 2022-04-20 00:00:00 | 8 | 4 | 8
16120768 |  | C | 2022-06-03 00:00:00 | 2022-06-10 00:00:00 | 2022-04-20 00:00:00 | 8 | 4 | 8
16090877 |  | C | 2022-06-03 00:00:00 | 2022-06-10 00:00:00 | 2022-04-08 00:00:00 | 8 | 17 | 2
16162647 |  | C | 2022-06-03 00:00:00 | 2022-06-05 00:00:00 | 2022-05-08 00:00:00 | 8 | 398 | 30 | 189
15916368 |  | X | 2022-06-04 00:00:00 | 2022-06-07 00:00:00 | 2022-02-10 00:00:00 | 8 | 168 | 30 | 250.67
16093074 |  | C | 2022-06-04 00:00:00 | 2022-06-11 00:00:00 | 2022-04-09 00:00:00 | 8 | 17 | 2
16103233 |  | C | 2022-06-04 00:00:00 | 2022-06-06 00:00:00 | 2022-04-13 00:00:00 | 8 | 667 | 23 | 145.76
16113039 |  | C | 2022-06-04 00:00:00 | 2022-06-06 00:00:00 | 2022-04-17 00:00:00 | 8 | 667 | 23 | 145.76
16105410 |  | C | 2022-06-04 00:00:00 | 2022-06-11 00:00:00 | 2022-04-13 00:00:00 | 8 | 17 | 2
16142535 |  | C | 2022-06-04 00:00:00 | 2022-06-08 00:00:00 | 2022-04-29 00:00:00 | 8 | 942 | 4 | 156.4
16186441 |  | X | 2022-06-04 00:00:00 | 2022-06-07 00:00:00 | 2022-05-18 00:00:00 | 8 | 168 | 30 | 181.92
16189996 |  | X | 2022-06-04 00:00:00 | 2022-06-07 00:00:00 | 2022-05-20 00:00:00 | 8 | 168 | 30 | 181.92
16204575 |  | C | 2022-06-04 00:00:00 | 2022-06-07 00:00:00 | 2022-05-26 00:00:00 | 8 | 17 | 2
16192361 |  | C | 2022-06-04 00:00:00 | 2022-06-05 00:00:00 | 2022-05-21 00:00:00 | 8 | 7 | 12 | 99
15769491 |  | X | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2021-12-20 00:00:00 | 8 | 941 | 4 | 177.81
15850495 |  | C | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2022-01-17 00:00:00 | 8 | 1 | 1
15724119 |  | C | 2022-06-05 00:00:00 | 2022-06-09 00:00:00 | 2021-11-30 00:00:00 | 8 | 17 | 2
15799054 |  | E | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2021-12-30 00:00:00 | 8 | 1 | 1 | 0
16156824 |  | C | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2022-05-05 00:00:00 | 8 | 1 | 1
16175287 |  | C | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2022-05-13 00:00:00 | 8 | 4 | 8
16163169 |  | C | 2022-06-05 00:00:00 | 2022-06-07 00:00:00 | 2022-05-08 00:00:00 | 8 | 758 | 4 | 148.46
16197948 |  | X | 2022-06-05 00:00:00 | 2022-06-10 00:00:00 | 2022-05-24 00:00:00 | 8 | 168 | 30 | 168.7
16192213 |  | X | 2022-06-05 00:00:00 | 2022-06-09 00:00:00 | 2022-05-21 00:00:00 | 8 | 17 | 2
16192216 |  | C | 2022-06-05 00:00:00 | 2022-06-09 00:00:00 | 2022-05-21 00:00:00 | 8 | 17 | 2
16192211 |  | X | 2022-06-05 00:00:00 | 2022-06-09 00:00:00 | 2022-05-21 00:00:00 | 8 | 17 | 2
16192215 |  | C | 2022-06-05 00:00:00 | 2022-06-09 00:00:00 | 2022-05-21 00:00:00 | 8 | 17 | 2
16198183 |  | C | 2022-06-05 00:00:00 | 2022-06-09 00:00:00 | 2022-05-24 00:00:00 | 8 | 168 | 30 | 168.7
16192212 |  | X | 2022-06-05 00:00:00 | 2022-06-09 00:00:00 | 2022-05-21 00:00:00 | 8 | 17 | 2
16141891 |  | C | 2022-06-06 00:00:00 | 2022-06-10 00:00:00 | 2022-04-28 00:00:00 | 8 | 667 | 23 | 137.49
15966615 |  | X | 2022-06-06 00:00:00 | 2022-06-10 00:00:00 | 2022-02-26 00:00:00 | 8 | 168 | 30 | 241
16168194 |  | C | 2022-06-06 00:00:00 | 2022-06-10 00:00:00 | 2022-05-10 00:00:00 | 8 | 168 | 30 | 216.9
16178709 |  | C | 2022-06-06 00:00:00 | 2022-06-10 00:00:00 | 2022-05-15 00:00:00 | 8 | 168 | 30 | 168.7
16206502 |  | X | 2022-06-06 00:00:00 | 2022-06-09 00:00:00 | 2022-05-27 00:00:00 | 8 | 632 | 4 | 192.28
16206521 |  | X | 2022-06-06 00:00:00 | 2022-06-09 00:00:00 | 2022-05-27 00:00:00 | 8 | 632 | 4 | 192.28
16206534 |  | C | 2022-06-06 00:00:00 | 2022-06-09 00:00:00 | 2022-05-27 00:00:00 | 8 | 632 | 4 | 192.28
16048578 |  | C | 2022-06-07 00:00:00 | 2022-06-10 00:00:00 | 2022-03-24 00:00:00 | 8 | 667 | 23 | 137.49
16133856 |  | X | 2022-06-07 00:00:00 | 2022-06-09 00:00:00 | 2022-04-25 00:00:00 | 8 | 940 | 4 | 151.83
16202901 |  | C | 2022-06-07 00:00:00 | 2022-06-09 00:00:00 | 2022-05-26 00:00:00 | 8 | 941 | 4 | 160.26
16181993 |  | C | 2022-06-07 00:00:00 | 2022-06-12 00:00:00 | 2022-05-16 00:00:00 | 8 | 703 | 4 | 146
16199573 |  | C | 2022-06-07 00:00:00 | 2022-06-12 00:00:00 | 2022-05-24 00:00:00 | 8 | 876 | 4 | 188
16137619 |  | C | 2022-06-08 00:00:00 | 2022-06-13 00:00:00 | 2022-04-27 00:00:00 | 8 | 229 | 23 | 171.17
15664577 |  | C | 2022-06-09 00:00:00 | 2022-06-12 00:00:00 | 2021-11-04 00:00:00 | 8 | 950 | 4 | 164.97
16122209 |  | X | 2022-06-09 00:00:00 | 2022-06-13 00:00:00 | 2022-04-20 00:00:00 | 8 | 17 | 2
16136360 |  | C | 2022-06-09 00:00:00 | 2022-06-15 00:00:00 | 2022-04-26 00:00:00 | 8 | 632 | 4 | 157.92
16094653 |  | X | 2022-06-09 00:00:00 | 2022-06-12 00:00:00 | 2022-04-10 00:00:00 | 8 | 800 | 4 | 164.8
16094654 |  | X | 2022-06-09 00:00:00 | 2022-06-12 00:00:00 | 2022-04-10 00:00:00 | 8 | 800 | 4 | 164.8
15978207 |  | X | 2022-06-09 00:00:00 | 2022-06-13 00:00:00 | 2022-03-02 00:00:00 | 8 | 4 | 8
16205446 | 103 | C | 2022-06-09 00:00:00 | 2022-06-11 00:00:00 | 2022-05-27 00:00:00 | 8 | 7 | 12 | 219.79
16187402 |  | X | 2022-06-09 00:00:00 | 2022-06-11 00:00:00 | 2022-05-19 00:00:00 | 8 | 168 | 30 | 218.75
15568345 |  | C | 2022-06-10 00:00:00 | 2022-06-17 00:00:00 | 2021-10-01 00:00:00 | 8 | 17 | 2
15521626 |  | C | 2022-06-10 00:00:00 | 2022-06-17 00:00:00 | 2021-09-08 00:00:00 | 8 | 17 | 2
15688168 |  | X | 2022-06-10 00:00:00 | 2022-06-12 00:00:00 | 2021-11-14 00:00:00 | 8 | 168 | 30 | 269
15648742 |  | C | 2022-06-10 00:00:00 | 2022-06-17 00:00:00 | 2021-10-28 00:00:00 | 8 | 4 | 8
15521610 |  | C | 2022-06-10 00:00:00 | 2022-06-17 00:00:00 | 2021-09-08 00:00:00 | 8 | 17 | 2
15521620 |  | C | 2022-06-10 00:00:00 | 2022-06-17 00:00:00 | 2021-09-08 00:00:00 | 8 | 17 | 2
15897527 |  | C | 2022-06-10 00:00:00 | 2022-06-15 00:00:00 | 2022-02-04 00:00:00 | 8 | 110 | 4 | 177.81
16075875 |  | X | 2022-06-10 00:00:00 | 2022-06-12 00:00:00 | 2022-04-04 00:00:00 | 8 | 942 | 4 | 241.92
16150417 |  | C | 2022-06-10 00:00:00 | 2022-06-17 00:00:00 | 2022-05-02 00:00:00 | 8 | 309 | 23 | 137.62
16084343 |  | B | 2022-06-10 00:00:00 | 2022-06-17 00:00:00 | 2022-04-06 00:00:00 | 8 | 1 | 1 | 0
16104976 |  | X | 2022-06-10 00:00:00 | 2022-06-12 00:00:00 | 2022-04-13 00:00:00 | 8 | 942 | 4 | 241.92
16182612 |  | C | 2022-06-10 00:00:00 | 2022-06-12 00:00:00 | 2022-05-17 00:00:00 | 8 | 788 | 4 | 255.36
16058256 |  | C | 2022-06-11 00:00:00 | 2022-06-18 00:00:00 | 2022-03-28 00:00:00 | 8 | 702 | 4 | 145.29
16042104 |  | C | 2022-06-11 00:00:00 | 2022-06-18 00:00:00 | 2022-03-22 00:00:00 | 8 | 702 | 4 | 145.29
16023406 |  | X | 2022-06-11 00:00:00 | 2022-06-18 00:00:00 | 2022-03-16 00:00:00 | 8 | 17 | 2
16127872 |  | C | 2022-06-11 00:00:00 | 2022-06-15 00:00:00 | 2022-04-22 00:00:00 | 8 | 17 | 2
16045712 |  | X | 2022-06-11 00:00:00 | 2022-06-14 00:00:00 | 2022-03-24 00:00:00 | 8 | 876 | 4 | 182
16175290 |  | C | 2022-06-11 00:00:00 | 2022-06-14 00:00:00 | 2022-05-13 00:00:00 | 8 | 788 | 4 | 217.49
15626078 |  | X | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2021-10-21 00:00:00 | 8 | 4 | 8
15773577 |  | X | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2021-12-20 00:00:00 | 8 | 110 | 4 | 170
15784039 |  | G | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2021-12-26 00:00:00 | 8 | 1 | 1
15784035 |  | C | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2021-12-26 00:00:00 | 8 | 4 | 1
15895503 |  | X | 2022-06-12 00:00:00 | 2022-06-18 00:00:00 | 2022-02-03 00:00:00 | 8 | 4 | 4 | 180.67
15784024 |  | X | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2021-12-26 00:00:00 | 8 | 1 | 1
16136025 |  | C | 2022-06-12 00:00:00 | 2022-06-15 00:00:00 | 2022-04-26 00:00:00 | 8 | 398 | 30 | 168.71
16091960 |  | G | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2022-04-08 00:00:00 | 8 | 17 | 2
16070378 |  | C | 2022-06-12 00:00:00 | 2022-06-16 00:00:00 | 2022-04-02 00:00:00 | 8 | 942 | 4 | 151.83
16091956 |  | C | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2022-04-08 00:00:00 | 8 | 22 | 2
16153723 |  | C | 2022-06-12 00:00:00 | 2022-06-17 00:00:00 | 2022-05-03 00:00:00 | 8 | 309 | 23 | 117.67
16117556 |  | C | 2022-06-12 00:00:00 | 2022-06-15 00:00:00 | 2022-04-19 00:00:00 | 8 | 876 | 4 | 152
16138807 |  | C | 2022-06-13 00:00:00 | 2022-06-16 00:00:00 | 2022-04-27 00:00:00 | 8 | 17 | 2
16142874 |  | C | 2022-06-13 00:00:00 | 2022-06-17 00:00:00 | 2022-04-29 00:00:00 | 8 | 942 | 4 | 151.83
16122256 |  | C | 2022-06-13 00:00:00 | 2022-06-16 00:00:00 | 2022-04-20 00:00:00 | 8 | 905 | 4 | 151.83
16095199 |  | C | 2022-06-15 00:00:00 | 2022-06-19 00:00:00 | 2022-04-11 00:00:00 | 8 | 632 | 4 | 204
16095204 |  | C | 2022-06-15 00:00:00 | 2022-06-19 00:00:00 | 2022-04-11 00:00:00 | 8 | 632 | 4 | 204
16095206 |  | C | 2022-06-15 00:00:00 | 2022-06-19 00:00:00 | 2022-04-11 00:00:00 | 8 | 632 | 4 | 204
16095214 |  | C | 2022-06-15 00:00:00 | 2022-06-19 00:00:00 | 2022-04-11 00:00:00 | 8 | 632 | 4 | 183.5
16095202 |  | C | 2022-06-15 00:00:00 | 2022-06-19 00:00:00 | 2022-04-11 00:00:00 | 8 | 632 | 4 | 204
15705691 |  | C | 2022-06-16 00:00:00 | 2022-06-23 00:00:00 | 2021-11-22 00:00:00 | 8 | 4 | 8
16053204 |  | X | 2022-06-16 00:00:00 | 2022-06-20 00:00:00 | 2022-03-26 00:00:00 | 8 | 398 | 30 | 214.21
16053874 |  | C | 2022-06-16 00:00:00 | 2022-06-20 00:00:00 | 2022-03-27 00:00:00 | 8 | 110 | 4 | 192.78
16136765 |  | X | 2022-06-16 00:00:00 | 2022-06-18 00:00:00 | 2022-04-26 00:00:00 | 8 | 168 | 30 | 291.5
16031937 |  | C | 2022-06-16 00:00:00 | 2022-06-20 00:00:00 | 2022-03-19 00:00:00 | 8 | 876 | 4 | 192.5
16139518 |  | C | 2022-06-16 00:00:00 | 2022-06-20 00:00:00 | 2022-04-27 00:00:00 | 8 | 942 | 4 | 192.78
16210128 |  | C | 2022-06-16 00:00:00 | 2022-06-19 00:00:00 | 2022-05-30 00:00:00 | 8 | 168 | 30 | 224.1
15517386 |  | X | 2022-06-17 00:00:00 | 2022-06-24 00:00:00 | 2021-09-05 00:00:00 | 8 | 17 | 2
15517393 |  | X | 2022-06-17 00:00:00 | 2022-06-24 00:00:00 | 2021-09-05 00:00:00 | 8 | 17 | 2
15517384 |  | X | 2022-06-17 00:00:00 | 2022-06-24 00:00:00 | 2021-09-05 00:00:00 | 8 | 17 | 2
15517388 |  | X | 2022-06-17 00:00:00 | 2022-06-24 00:00:00 | 2021-09-05 00:00:00 | 8 | 17 | 2
15811013 |  | X | 2022-06-17 00:00:00 | 2022-06-19 00:00:00 | 2022-01-02 00:00:00 | 8 | 168 | 30 | 239
15847672 |  | C | 2022-06-17 00:00:00 | 2022-06-23 00:00:00 | 2022-01-15 00:00:00 | 8 | 728 | 5 | 197.1
15955595 |  | C | 2022-06-17 00:00:00 | 2022-06-24 00:00:00 | 2022-02-23 00:00:00 | 8 | 4 | 8