{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Reservation","CHECK IN","Data","SCERCH"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Reservation","index":0,"n_rows":336,"n_cols":12,"rows_kept":336,"cut":false,"hidden":false,"merged":[[3,9,3,10],[3,7,3,8]]}
[null,null,"Reservation"]
[null,"From","2020-05-30"]
[null,"To","2020-06-25"]
[null,null,null,null,null,null,null,null,null,null,null,"Reservation"]
[null,null,null,null,null,null,null,null,null,null,null,"CHECK IN"]
["Room","Start","Days","End","Status","Full Name"]
["Room 13","2020-05-10",{"$f":"IF(OR(B7=\"\",D7=\"\"),\"\",D7-B7)","v":20},"2020-05-30","CHECK IN","Delsie Edwards",{"$f":"IF($E7=$L$5,MAX($G$6:G6)+1,\"\")","v":1}]
["Room 21","2020-05-11",20,"2020-05-31","CHECK IN","Mary Mace",{"$f":"IF($E8=$L$5,MAX($G$6:G7)+1,\"\")","v":2}]
["Room 5","2020-05-12",20,"2020-06-01","Reservation","Kent Todmanson",{"$f":"IF($E9=$L$5,MAX($G$6:G8)+1,\"\")","v":""}]
["Room 7","2020-05-13",20,"2020-06-02","Reservation","Ted Brent",{"$f":"IF($E10=$L$5,MAX($G$6:G9)+1,\"\")","v":""}]
["Room 16","2020-06-14",9,"2020-06-23","Reservation","Ted Brent",{"$f":"IF($E11=$L$5,MAX($G$6:G10)+1,\"\")","v":""}]
[null,null,"",null,null,null,{"$f":"IF($E12=$L$5,MAX($G$6:G11)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E13=$L$5,MAX($G$6:G12)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E14=$L$5,MAX($G$6:G13)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E15=$L$5,MAX($G$6:G14)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E16=$L$5,MAX($G$6:G15)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E17=$L$5,MAX($G$6:G16)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E18=$L$5,MAX($G$6:G17)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E19=$L$5,MAX($G$6:G18)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E20=$L$5,MAX($G$6:G19)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E21=$L$5,MAX($G$6:G20)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E22=$L$5,MAX($G$6:G21)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E23=$L$5,MAX($G$6:G22)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E24=$L$5,MAX($G$6:G23)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E25=$L$5,MAX($G$6:G24)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E26=$L$5,MAX($G$6:G25)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E27=$L$5,MAX($G$6:G26)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E28=$L$5,MAX($G$6:G27)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E29=$L$5,MAX($G$6:G28)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E30=$L$5,MAX($G$6:G29)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E31=$L$5,MAX($G$6:G30)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E32=$L$5,MAX($G$6:G31)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E33=$L$5,MAX($G$6:G32)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E34=$L$5,MAX($G$6:G33)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E35=$L$5,MAX($G$6:G34)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E36=$L$5,MAX($G$6:G35)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E37=$L$5,MAX($G$6:G36)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E38=$L$5,MAX($G$6:G37)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E39=$L$5,MAX($G$6:G38)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E40=$L$5,MAX($G$6:G39)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E41=$L$5,MAX($G$6:G40)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E42=$L$5,MAX($G$6:G41)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E43=$L$5,MAX($G$6:G42)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E44=$L$5,MAX($G$6:G43)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E45=$L$5,MAX($G$6:G44)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E46=$L$5,MAX($G$6:G45)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E47=$L$5,MAX($G$6:G46)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E48=$L$5,MAX($G$6:G47)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E49=$L$5,MAX($G$6:G48)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E50=$L$5,MAX($G$6:G49)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E51=$L$5,MAX($G$6:G50)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E52=$L$5,MAX($G$6:G51)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E53=$L$5,MAX($G$6:G52)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E54=$L$5,MAX($G$6:G53)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E55=$L$5,MAX($G$6:G54)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E56=$L$5,MAX($G$6:G55)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E57=$L$5,MAX($G$6:G56)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E58=$L$5,MAX($G$6:G57)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E59=$L$5,MAX($G$6:G58)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E60=$L$5,MAX($G$6:G59)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E61=$L$5,MAX($G$6:G60)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E62=$L$5,MAX($G$6:G61)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E63=$L$5,MAX($G$6:G62)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E64=$L$5,MAX($G$6:G63)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E65=$L$5,MAX($G$6:G64)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E66=$L$5,MAX($G$6:G65)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E67=$L$5,MAX($G$6:G66)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E68=$L$5,MAX($G$6:G67)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E69=$L$5,MAX($G$6:G68)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E70=$L$5,MAX($G$6:G69)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E71=$L$5,MAX($G$6:G70)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E72=$L$5,MAX($G$6:G71)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E73=$L$5,MAX($G$6:G72)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E74=$L$5,MAX($G$6:G73)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E75=$L$5,MAX($G$6:G74)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E76=$L$5,MAX($G$6:G75)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E77=$L$5,MAX($G$6:G76)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E78=$L$5,MAX($G$6:G77)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E79=$L$5,MAX($G$6:G78)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E80=$L$5,MAX($G$6:G79)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E81=$L$5,MAX($G$6:G80)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E82=$L$5,MAX($G$6:G81)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E83=$L$5,MAX($G$6:G82)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E84=$L$5,MAX($G$6:G83)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E85=$L$5,MAX($G$6:G84)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E86=$L$5,MAX($G$6:G85)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E87=$L$5,MAX($G$6:G86)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E88=$L$5,MAX($G$6:G87)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E89=$L$5,MAX($G$6:G88)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E90=$L$5,MAX($G$6:G89)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E91=$L$5,MAX($G$6:G90)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E92=$L$5,MAX($G$6:G91)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E93=$L$5,MAX($G$6:G92)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E94=$L$5,MAX($G$6:G93)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E95=$L$5,MAX($G$6:G94)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E96=$L$5,MAX($G$6:G95)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E97=$L$5,MAX($G$6:G96)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E98=$L$5,MAX($G$6:G97)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E99=$L$5,MAX($G$6:G98)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E100=$L$5,MAX($G$6:G99)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E101=$L$5,MAX($G$6:G100)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E102=$L$5,MAX($G$6:G101)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E103=$L$5,MAX($G$6:G102)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E104=$L$5,MAX($G$6:G103)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E105=$L$5,MAX($G$6:G104)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E106=$L$5,MAX($G$6:G105)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E107=$L$5,MAX($G$6:G106)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E108=$L$5,MAX($G$6:G107)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E109=$L$5,MAX($G$6:G108)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E110=$L$5,MAX($G$6:G109)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E111=$L$5,MAX($G$6:G110)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E112=$L$5,MAX($G$6:G111)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E113=$L$5,MAX($G$6:G112)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E114=$L$5,MAX($G$6:G113)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E115=$L$5,MAX($G$6:G114)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E116=$L$5,MAX($G$6:G115)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E117=$L$5,MAX($G$6:G116)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E118=$L$5,MAX($G$6:G117)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E119=$L$5,MAX($G$6:G118)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E120=$L$5,MAX($G$6:G119)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E121=$L$5,MAX($G$6:G120)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E122=$L$5,MAX($G$6:G121)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E123=$L$5,MAX($G$6:G122)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E124=$L$5,MAX($G$6:G123)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E125=$L$5,MAX($G$6:G124)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E126=$L$5,MAX($G$6:G125)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E127=$L$5,MAX($G$6:G126)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E128=$L$5,MAX($G$6:G127)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E129=$L$5,MAX($G$6:G128)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E130=$L$5,MAX($G$6:G129)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E131=$L$5,MAX($G$6:G130)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E132=$L$5,MAX($G$6:G131)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E133=$L$5,MAX($G$6:G132)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E134=$L$5,MAX($G$6:G133)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E135=$L$5,MAX($G$6:G134)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E136=$L$5,MAX($G$6:G135)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E137=$L$5,MAX($G$6:G136)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E138=$L$5,MAX($G$6:G137)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E139=$L$5,MAX($G$6:G138)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E140=$L$5,MAX($G$6:G139)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E141=$L$5,MAX($G$6:G140)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E142=$L$5,MAX($G$6:G141)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E143=$L$5,MAX($G$6:G142)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E144=$L$5,MAX($G$6:G143)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E145=$L$5,MAX($G$6:G144)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E146=$L$5,MAX($G$6:G145)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E147=$L$5,MAX($G$6:G146)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E148=$L$5,MAX($G$6:G147)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E149=$L$5,MAX($G$6:G148)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E150=$L$5,MAX($G$6:G149)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E151=$L$5,MAX($G$6:G150)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E152=$L$5,MAX($G$6:G151)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E153=$L$5,MAX($G$6:G152)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E154=$L$5,MAX($G$6:G153)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E155=$L$5,MAX($G$6:G154)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E156=$L$5,MAX($G$6:G155)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E157=$L$5,MAX($G$6:G156)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E158=$L$5,MAX($G$6:G157)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E159=$L$5,MAX($G$6:G158)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E160=$L$5,MAX($G$6:G159)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E161=$L$5,MAX($G$6:G160)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E162=$L$5,MAX($G$6:G161)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E163=$L$5,MAX($G$6:G162)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E164=$L$5,MAX($G$6:G163)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E165=$L$5,MAX($G$6:G164)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E166=$L$5,MAX($G$6:G165)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E167=$L$5,MAX($G$6:G166)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E168=$L$5,MAX($G$6:G167)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E169=$L$5,MAX($G$6:G168)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E170=$L$5,MAX($G$6:G169)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E171=$L$5,MAX($G$6:G170)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E172=$L$5,MAX($G$6:G171)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E173=$L$5,MAX($G$6:G172)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E174=$L$5,MAX($G$6:G173)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E175=$L$5,MAX($G$6:G174)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E176=$L$5,MAX($G$6:G175)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E177=$L$5,MAX($G$6:G176)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E178=$L$5,MAX($G$6:G177)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E179=$L$5,MAX($G$6:G178)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E180=$L$5,MAX($G$6:G179)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E181=$L$5,MAX($G$6:G180)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E182=$L$5,MAX($G$6:G181)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E183=$L$5,MAX($G$6:G182)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E184=$L$5,MAX($G$6:G183)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E185=$L$5,MAX($G$6:G184)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E186=$L$5,MAX($G$6:G185)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E187=$L$5,MAX($G$6:G186)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E188=$L$5,MAX($G$6:G187)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E189=$L$5,MAX($G$6:G188)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E190=$L$5,MAX($G$6:G189)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E191=$L$5,MAX($G$6:G190)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E192=$L$5,MAX($G$6:G191)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E193=$L$5,MAX($G$6:G192)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E194=$L$5,MAX($G$6:G193)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E195=$L$5,MAX($G$6:G194)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E196=$L$5,MAX($G$6:G195)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E197=$L$5,MAX($G$6:G196)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E198=$L$5,MAX($G$6:G197)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E199=$L$5,MAX($G$6:G198)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E200=$L$5,MAX($G$6:G199)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E201=$L$5,MAX($G$6:G200)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E202=$L$5,MAX($G$6:G201)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E203=$L$5,MAX($G$6:G202)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E204=$L$5,MAX($G$6:G203)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E205=$L$5,MAX($G$6:G204)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E206=$L$5,MAX($G$6:G205)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E207=$L$5,MAX($G$6:G206)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E208=$L$5,MAX($G$6:G207)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E209=$L$5,MAX($G$6:G208)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E210=$L$5,MAX($G$6:G209)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E211=$L$5,MAX($G$6:G210)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E212=$L$5,MAX($G$6:G211)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E213=$L$5,MAX($G$6:G212)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E214=$L$5,MAX($G$6:G213)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E215=$L$5,MAX($G$6:G214)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E216=$L$5,MAX($G$6:G215)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E217=$L$5,MAX($G$6:G216)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E218=$L$5,MAX($G$6:G217)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E219=$L$5,MAX($G$6:G218)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E220=$L$5,MAX($G$6:G219)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E221=$L$5,MAX($G$6:G220)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E222=$L$5,MAX($G$6:G221)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E223=$L$5,MAX($G$6:G222)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E224=$L$5,MAX($G$6:G223)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E225=$L$5,MAX($G$6:G224)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E226=$L$5,MAX($G$6:G225)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E227=$L$5,MAX($G$6:G226)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E228=$L$5,MAX($G$6:G227)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E229=$L$5,MAX($G$6:G228)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E230=$L$5,MAX($G$6:G229)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E231=$L$5,MAX($G$6:G230)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E232=$L$5,MAX($G$6:G231)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E233=$L$5,MAX($G$6:G232)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E234=$L$5,MAX($G$6:G233)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E235=$L$5,MAX($G$6:G234)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E236=$L$5,MAX($G$6:G235)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E237=$L$5,MAX($G$6:G236)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E238=$L$5,MAX($G$6:G237)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E239=$L$5,MAX($G$6:G238)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E240=$L$5,MAX($G$6:G239)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E241=$L$5,MAX($G$6:G240)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E242=$L$5,MAX($G$6:G241)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E243=$L$5,MAX($G$6:G242)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E244=$L$5,MAX($G$6:G243)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E245=$L$5,MAX($G$6:G244)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E246=$L$5,MAX($G$6:G245)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E247=$L$5,MAX($G$6:G246)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E248=$L$5,MAX($G$6:G247)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E249=$L$5,MAX($G$6:G248)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E250=$L$5,MAX($G$6:G249)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E251=$L$5,MAX($G$6:G250)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E252=$L$5,MAX($G$6:G251)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E253=$L$5,MAX($G$6:G252)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E254=$L$5,MAX($G$6:G253)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E255=$L$5,MAX($G$6:G254)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E256=$L$5,MAX($G$6:G255)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E257=$L$5,MAX($G$6:G256)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E258=$L$5,MAX($G$6:G257)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E259=$L$5,MAX($G$6:G258)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E260=$L$5,MAX($G$6:G259)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E261=$L$5,MAX($G$6:G260)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E262=$L$5,MAX($G$6:G261)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E263=$L$5,MAX($G$6:G262)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E264=$L$5,MAX($G$6:G263)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E265=$L$5,MAX($G$6:G264)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E266=$L$5,MAX($G$6:G265)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E267=$L$5,MAX($G$6:G266)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E268=$L$5,MAX($G$6:G267)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E269=$L$5,MAX($G$6:G268)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E270=$L$5,MAX($G$6:G269)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E271=$L$5,MAX($G$6:G270)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E272=$L$5,MAX($G$6:G271)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E273=$L$5,MAX($G$6:G272)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E274=$L$5,MAX($G$6:G273)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E275=$L$5,MAX($G$6:G274)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E276=$L$5,MAX($G$6:G275)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E277=$L$5,MAX($G$6:G276)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E278=$L$5,MAX($G$6:G277)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E279=$L$5,MAX($G$6:G278)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E280=$L$5,MAX($G$6:G279)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E281=$L$5,MAX($G$6:G280)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E282=$L$5,MAX($G$6:G281)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E283=$L$5,MAX($G$6:G282)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E284=$L$5,MAX($G$6:G283)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E285=$L$5,MAX($G$6:G284)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E286=$L$5,MAX($G$6:G285)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E287=$L$5,MAX($G$6:G286)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E288=$L$5,MAX($G$6:G287)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E289=$L$5,MAX($G$6:G288)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E290=$L$5,MAX($G$6:G289)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E291=$L$5,MAX($G$6:G290)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E292=$L$5,MAX($G$6:G291)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E293=$L$5,MAX($G$6:G292)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E294=$L$5,MAX($G$6:G293)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E295=$L$5,MAX($G$6:G294)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E296=$L$5,MAX($G$6:G295)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E297=$L$5,MAX($G$6:G296)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E298=$L$5,MAX($G$6:G297)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E299=$L$5,MAX($G$6:G298)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E300=$L$5,MAX($G$6:G299)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E301=$L$5,MAX($G$6:G300)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E302=$L$5,MAX($G$6:G301)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E303=$L$5,MAX($G$6:G302)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E304=$L$5,MAX($G$6:G303)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E305=$L$5,MAX($G$6:G304)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E306=$L$5,MAX($G$6:G305)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E307=$L$5,MAX($G$6:G306)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E308=$L$5,MAX($G$6:G307)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E309=$L$5,MAX($G$6:G308)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E310=$L$5,MAX($G$6:G309)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E311=$L$5,MAX($G$6:G310)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E312=$L$5,MAX($G$6:G311)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E313=$L$5,MAX($G$6:G312)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E314=$L$5,MAX($G$6:G313)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E315=$L$5,MAX($G$6:G314)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E316=$L$5,MAX($G$6:G315)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E317=$L$5,MAX($G$6:G316)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E318=$L$5,MAX($G$6:G317)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E319=$L$5,MAX($G$6:G318)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E320=$L$5,MAX($G$6:G319)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E321=$L$5,MAX($G$6:G320)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E322=$L$5,MAX($G$6:G321)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E323=$L$5,MAX($G$6:G322)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E324=$L$5,MAX($G$6:G323)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E325=$L$5,MAX($G$6:G324)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E326=$L$5,MAX($G$6:G325)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E327=$L$5,MAX($G$6:G326)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E328=$L$5,MAX($G$6:G327)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E329=$L$5,MAX($G$6:G328)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E330=$L$5,MAX($G$6:G329)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E331=$L$5,MAX($G$6:G330)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E332=$L$5,MAX($G$6:G331)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E333=$L$5,MAX($G$6:G332)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E334=$L$5,MAX($G$6:G333)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E335=$L$5,MAX($G$6:G334)+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF($E336=$L$5,MAX($G$6:G335)+1,\"\")","v":""}]

{"sheet":"CHECK IN","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Room","Start","Days","End","Status","Full Name"]
[{"$f":"IF(ROW($A1)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A1),Reservation!$G:$G,0)),\"\")","v":"Room 13"},{"$f":"IF(ROW($A1)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A1),Reservation!$G:$G,0)),\"\")","v":"2020-05-10"},{"$f":"IF(ROW($A1)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A1),Reservation!$G:$G,0)),\"\")","v":20},{"$f":"IF(ROW($A1)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A1),Reservation!$G:$G,0)),\"\")","v":"2020-05-30"},{"$f":"IF(ROW($A1)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A1),Reservation!$G:$G,0)),\"\")","v":"CHECK IN"},{"$f":"IF(ROW($A1)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A1),Reservation!$G:$G,0)),\"\")","v":"Delsie Edwards"}]
[{"$f":"IF(ROW($A2)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A2),Reservation!$G:$G,0)),\"\")","v":"Room 21"},{"$f":"IF(ROW($A2)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A2),Reservation!$G:$G,0)),\"\")","v":"2020-05-11"},{"$f":"IF(ROW($A2)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A2),Reservation!$G:$G,0)),\"\")","v":20},{"$f":"IF(ROW($A2)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A2),Reservation!$G:$G,0)),\"\")","v":"2020-05-31"},{"$f":"IF(ROW($A2)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A2),Reservation!$G:$G,0)),\"\")","v":"CHECK IN"},{"$f":"IF(ROW($A2)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A2),Reservation!$G:$G,0)),\"\")","v":"Mary Mace"}]
[{"$f":"IF(ROW($A3)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A3),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A3)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A3),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A3)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A3),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A3)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A3),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A3)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A3),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A3)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A3),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A4)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A4),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A4)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A4),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A4)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A4),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A4)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A4),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A4)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A4),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A4)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A4),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A5)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A5),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A5)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A5),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A5)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A5),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A5)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A5),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A5)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A5),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A5)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A5),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A6)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A6),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A6)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A6),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A6)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A6),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A6)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A6),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A6)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A6),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A6)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A6),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A7)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A7),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A7)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A7),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A7)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A7),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A7)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A7),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A7)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A7),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A7)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A7),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A8)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A8),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A8)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A8),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A8)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A8),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A8)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A8),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A8)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A8),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A8)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A8),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A9)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A9),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A9)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A9),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A9)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A9),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A9)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A9),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A9)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A9),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A9)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A9),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A10)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A10),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A10)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A10),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A10)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A10),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A10)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A10),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A10)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A10),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A10)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A10),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A11)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A11),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A11)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A11),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A11)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A11),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A11)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A11),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A11)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A11),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A11)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A11),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A12)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A12),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A12)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A12),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A12)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A12),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A12)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A12),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A12)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A12),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A12)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A12),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A13)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A13),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A13)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A13),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A13)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A13),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A13)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A13),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A13)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A13),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A13)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A13),Reservation!$G:$G,0)),\"\")","v":""}]
[{"$f":"IF(ROW($A14)<=MAX(Reservation!$G:$G),INDEX(Reservation!$A:$A,MATCH(ROW($A14),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A14)<=MAX(Reservation!$G:$G),INDEX(Reservation!$B:$B,MATCH(ROW($A14),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A14)<=MAX(Reservation!$G:$G),INDEX(Reservation!$C:$C,MATCH(ROW($A14),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A14)<=MAX(Reservation!$G:$G),INDEX(Reservation!$D:$D,MATCH(ROW($A14),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A14)<=MAX(Reservation!$G:$G),INDEX(Reservation!$E:$E,MATCH(ROW($A14),Reservation!$G:$G,0)),\"\")","v":""},{"$f":"IF(ROW($A14)<=MAX(Reservation!$G:$G),INDEX(Reservation!$F:$F,MATCH(ROW($A14),Reservation!$G:$G,0)),\"\")","v":""}]

{"sheet":"Data","index":2,"n_rows":32,"n_cols":77,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Count"]
[null,{"$f":"MAX(B9:B500)","v":29},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copied range for restoration if overbook",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Criteria",null,null,null,"Count",null,"Days overbooked"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Room","Start","End",null,{"$f":"COUNTA(BM9:BM31)","v":0},null,{"$f":"IF(BN10>BN9,BN10-BN9,BO10-BN9+1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Criteria for limiting data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"=\" &#REF!","v":{"$error":"#REF!"}},{"$f":"\">=\" &#REF!","v":{"$error":"#REF!"}},{"$f":"\"<=\" &#REF!","v":{"$error":"#REF!"}}]
[null,"ID","Room","Start","Days","End","Status","Cost per day","Deposit","Addition  Cost","Cost","Full Name","Address","Email","Phone ","Licience /Passport","Expenses 1","Descript1","Expenses 2","Descript2","Expenses 3","Descript3","Expenses 4","Descript4","Expenses 5","Descript5",null,null,null,null,null,null,"Start","End","ID","Room","Start","Days","End","Status","Cost per day","Deposit","Addition  Cost","Cost","Full Name","Address","Email","Phone ","Licience /Passport","Expenses 1","Descript1","Expenses 2","Descript2","Expenses 3","Descript3","Expenses 4","Descript4","Expenses 5","Descript5",null,{"$f":"\"=\" &#REF!","v":{"$error":"#REF!"}},{"$f":"\"<=\" &#REF!","v":{"$error":"#REF!"}},{"$f":"\">=\" &#REF!","v":{"$error":"#REF!"}},null,"Room","Start","End","Full Name","check in",null,null,"check Out"]
[null,1,"Room 15","2020-03-31",{"$f":"IF(OR(D9=\"\",F9=\"\"),\"\",F9-D9)","v":10},"2020-04-10","arrival",200,50,null,400,"Meagan Rouch","67 Pook St","meag@mmm.com","2345 2134","rt 565788",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AS9,AK9)","v":"Henry Purcible43832"},{"$f":"\">=\" &#REF! - 14","v":{"$error":"#REF!"}},{"$f":"\"<=\" &#REF! + 14","v":{"$error":"#REF!"}},3,"Room 1","2020-01-02",5,"2020-01-07","Unconfirmed",80,null,0,548,"Henry Purcible","56 Grease St","1234fred@dod.com.ad","2345 6789","1234 5678 45",23,"Drinks",null,null,null,null,null,null,45,"Towels",null,null,null,null,null,null,null,null,null,{"$f":"MONTH(AK9)","v":"1900-01-01"},{"$f":"DAY(AK9)","v":2},{"$f":"YEAR(AK9)","v":2020},{"$f":"MONTH(AM9)","v":1},{"$f":"DAY(AM9)","v":7},{"$f":"YEAR(AM9)","v":2020},"IND","B.B","01-00001"]
[null,2,"Room 25","2020-03-31",{"$f":"IF(OR(D10=\"\",F10=\"\"),\"\",F10-D10)","v":10},"2020-04-10","arrival",80,null,0,320,"Jenny Trerrfer","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AS10,AK10)","v":"Kent Todmanson43833"},null,null,4,"Room 15","2020-01-03",11,"2020-01-14","Paid",150,null,0,1650,"Kent Todmanson","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MONTH(AK10)","v":1},{"$f":"DAY(AK10)","v":3},{"$f":"YEAR(AK10)","v":2020},{"$f":"MONTH(AM10)","v":1},{"$f":"DAY(AM10)","v":14},{"$f":"YEAR(AM11)","v":1900},"IND","B.B","01-00002"]
[null,3,"Room 1","2020-03-31",{"$f":"IF(OR(D11=\"\",F11=\"\"),\"\",F11-D11)","v":10},"2020-04-10","arrival",80,null,0,548,"Henry Purcible","56 Grease St","1234fred@dod.com.ad","2345 6789","1234 5678 45",23,"Drinks",null,null,null,null,null,null,45,"Towels",null,null,null,null,null,{"$f":"CONCATENATE(AS11,AK11)","v":""}]
[null,4,"Room 15","2020-03-31",10,"2020-04-10","arrival",150,null,0,1650,"Kent Todmanson","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,5,"Room 5","2020-03-31",10,"2020-04-10","arrival",150,200,0,1300,"Trex Lawson","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,6,"Room 21","2020-03-31",10,"2020-04-10","arrival",80,null,0,480,"Neal Heart","56 Grease St","1234fred@dod.com.ad","2345 6789","1234 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,7,"Room 3","2020-03-31",10,"2020-04-10","arrival",120,null,0,600,"Delsie Drival","32 Trash Crt","1234fred@dod.com.ad","2346 6789","1235 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,8,"Room 8","2020-03-31",10,"2020-04-10","arrival",300,null,0,1200,"Trevor Westward","3/5 My Village","1234fred@dod.com.ad","2352 6789","1241 5678 45",22,"foods",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,9,"Room 27","2020-03-31",10,"2020-04-10","arrival",150,null,0,300,"Ted Brent","99 Holdering Ct","1234fred@dod.com.ad","2354 6789","1243 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,10,"Room 14","2020-03-31",10,"2020-04-10","arrival",230,null,0,2432,"Ben Y","67 Pretzel Rd","1234fred@dod.com.ad","2351 6789","1240 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,11,"Room 13","2020-03-31",10,"2020-04-10","arrival",200,null,0,711,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,12,"Room 7","2020-03-31",10,"2020-04-10","arrival",180,null,0,1080,"Merry Easton","45 Brentwood St","1234fred@dod.com.ad","2356 6789","1245 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,13,"Room 1","2020-03-31",10,"2020-04-10","arrival",150,null,0,2250,"Denny Bernt","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,14,"Room 23","2020-03-31",10,"2020-04-10","arrival",80,null,0,320,"Jenny Trerrfer","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,18,"Room 11","2020-02-03",9,"2020-02-12","departure",165,null,0,495,"Kentty Beckword","Nally Plaza","1234fred@dod.com.ad","2350 6789","1239 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,21,"Room 5","2020-02-04",9,"2020-02-13","departure",200,null,0,400,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,22,"Room 13","2020-02-05",9,"2020-02-14","departure",200,null,0,400,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,23,"Room 14","2020-02-06",9,"2020-02-15","departure",230,null,0,1150,"Ben Y","67 Pretzel Rd","1234fred@dod.com.ad","2351 6789","1240 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,24,"Room 13","2020-02-07",9,"2020-02-16","departure",200,null,0,545,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,25,"Room 13","2020-05-10",20,"2020-05-30","Reservation",200,null,0,640,"Delsie Edwards","Shop 3 Wynnun Rd","1234fred@dod.com.ad","2349 6789","1238 5678 45",67,"Towels",8,"Damage",67,"Drinks",8,"Towels",90,"Tokens",null,null,null,null,null,""]
[null,26,"Room 21","2020-05-11",20,"2020-05-31","Reservation",200,200,null,800,"Mary Mace","56 Tre st","Mer@adsfaf.com","341 1414","re234141341",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,27,"Room 5","2020-05-12",20,"2020-06-01","Reservation",150,null,0,1950,"Kent Todmanson","45 Thenden St","567red@optusnet","2347 6789","1236 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,28,"Room 7","2020-05-13",20,"2020-06-02","Reservation",230,null,0,920,"Ted Brent","Shop6 Brentdale Shopping Centre","1234fred@dod.com.ad","2355 6789","1244 5678 45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,29,"Room 16","2020-06-14",9,"2020-06-23","Reservation",230,null,0,920,"Ted Brent","Shop6 Brentdale Shopping Centre","1234fred@dod.com.ad","2355 6789","1244 5678 45"]

{"sheet":"SCERCH","index":3,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ROOM NO","Room 15"]
[null,"Date","2020-03-01"]
[null,"Date","2020-06-30"]
[]
[]
["Room","Start","Days","End","Status","Full Name"]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A8))),\"\")","v":"Room 15"},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B8))),\"\")","v":"2020-03-31"},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C8))),\"\")","v":10},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D8))),\"\")","v":"2020-04-10"},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E8))),\"\")","v":"arrival"},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F8))),\"\")","v":"Meagan Rouch"}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A9))),\"\")","v":"Room 15"},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B9))),\"\")","v":"2020-03-31"},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C9))),\"\")","v":10},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D9))),\"\")","v":"2020-04-10"},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E9))),\"\")","v":"arrival"},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F9))),\"\")","v":"Kent Todmanson"}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E10))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F10))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E11))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F11))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E12))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F12))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E13))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F13))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E14))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F14))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E15))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F15))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E16))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F16))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E17))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F17))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A18))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B18))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C18))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D18))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E18))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F18))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A19))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B19))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C19))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D19))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E19))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F19))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A20))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B20))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C20))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D20))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E20))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F20))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A21))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B21))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C21))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D21))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E21))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F21))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A22))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B22))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C22))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D22))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E22))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F22))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A23))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B23))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C23))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D23))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E23))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F23))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A24))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B24))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C24))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D24))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E24))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F24))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A25))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B25))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C25))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D25))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E25))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F25))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A26))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B26))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C26))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D26))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E26))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F26))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A27))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B27))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C27))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D27))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E27))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F27))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A28))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B28))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C28))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D28))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E28))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F28))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A29))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B29))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C29))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D29))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E29))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F29))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A30))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B30))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C30))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D30))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E30))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F30))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A31))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B31))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C31))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D31))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E31))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F31))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A32))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B32))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C32))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D32))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E32))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F32))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A33))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B33))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C33))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D33))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E33))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F33))),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Data!$C:$C,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(A$9:A$5000)-ROW(A$9)+1))),ROWS($A$8:A34))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$D:$D,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(B$9:B$5000)-ROW(B$9)+1))),ROWS($A$8:B34))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$E:$E,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(C$9:C$5000)-ROW(C$9)+1))),ROWS($A$8:C34))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$F:$F,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(D$9:D$5000)-ROW(D$9)+1))),ROWS($A$8:D34))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$G:$G,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(E$9:E$5000)-ROW(E$9)+1))),ROWS($A$8:E34))),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$L:$L,SMALL(IF(Data!$D:$D>=$C$3,IF(Data!$D:$D<=$C$4,IF(Data!$C:$C=$C$2,ROW(F$9:F$5000)-ROW(F$9)+1))),ROWS($A$8:F34))),\"\")","v":""}]