{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet1 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Sheet1","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Last name","First name","Organization","Card number","Entrance Time",{"$f":"SUMPRODUCT(--(LEN(TRIM(D2:D30))>0))-1","v":4}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G1))),\"\")","v":"Jackson"},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H1))),\"\")","v":"Michael"},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I1))),\"\")","v":"USA"},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J1))),\"\")","v":1},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D2,'Sheet1 3'!$F$1:$F$400))","v":43545.244846180554},"кто находится на объекте и время последнего входа",null,{"$f":"NOW()","v":"2019-03-25T11:32:04.920"},null,null,null,{"$f":"'Sheet1 3'!E8","v":6}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G2))),\"\")","v":"Presley"},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H2))),\"\")","v":"Elvis"},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I2))),\"\")","v":"USA"},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J2))),\"\")","v":4},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D3,'Sheet1 3'!$F$1:$F$400))","v":43546.246736226851},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E9","v":9}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G3))),\"\")","v":"Ali"},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H3))),\"\")","v":"Muhammad"},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I3))),\"\")","v":"USA"},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J3))),\"\")","v":6},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D4,'Sheet1 3'!$F$1:$F$400))","v":43549.342554282404},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E10","v":8}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G4))),\"\")","v":"Columbus"},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H4))),\"\")","v":"Christopher"},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I4))),\"\")","v":"Italia"},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J4))),\"\")","v":9},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D5,'Sheet1 3'!$F$1:$F$400))","v":43545.244746412034},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E11","v":6}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G5))),\"\")","v":"Gandhi"},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H5))),\"\")","v":"Mahatma"},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I5))),\"\")","v":"India"},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J5))),\"\")","v":7},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D6,'Sheet1 3'!$F$1:$F$400))","v":43545.244765393516},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E12","v":7}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G6))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H6))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I6))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J6))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D7,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E15","v":6}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G7))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H7))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I7))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J7))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D8,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E16","v":3}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G8))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H8))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I8))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J8))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D9,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E21","v":8}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G9))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H9))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I9))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J9))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D10,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E24","v":2}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G10))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H10))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I10))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J10))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D11,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E28","v":10}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G11))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H11))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I11))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J11))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D12,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E30","v":4}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G12))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H12))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I12))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J12))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D13,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E31","v":3}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G13))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H13))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I13))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J13))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D14,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E32","v":6}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G14))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H14))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I14))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J14))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D15,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E36","v":5}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G15))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H15))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I15))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J15))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D16,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E39","v":0}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G16))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H16))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I16))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J16))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D17,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E40","v":0}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G17))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H17))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I17))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J17))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D18,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E41","v":0}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G18))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H18))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I18))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J18))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D19,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E42","v":0}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G19))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H19))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I19))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J19))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D20,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E43","v":0}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G20))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H20))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I20))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J20))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D21,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E44","v":0}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G21))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H21))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I21))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J21))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D22,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E45","v":0}]
[{"$f":"IFERROR(INDEX('Sheet1 3'!A$1:A$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(G22))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!B$1:B$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(H22))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!C$1:C$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(I22))),\"\")","v":""},{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J22))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D23,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E46","v":0}]
[null,{"$f":"IFERROR(IF(L24=\"\",\"\",INDEX(Sheet2!B:B,MATCH(Sheet1!L24,Sheet2!E:E,0))),\"\")","v":""},null,{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J23))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D24,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E47","v":0}]
[null,{"$f":"IFERROR(IF(L25=\"\",\"\",INDEX(Sheet2!B:B,MATCH(Sheet1!L25,Sheet2!E:E,0))),\"\")","v":""},null,{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J24))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D25,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E48","v":0}]
[null,{"$f":"IFERROR(IF(L26=\"\",\"\",INDEX(Sheet2!B:B,MATCH(Sheet1!L26,Sheet2!E:E,0))),\"\")","v":""},null,{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J25))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D26,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E49","v":0}]
[null,{"$f":"IFERROR(IF(L27=\"\",\"\",INDEX(Sheet2!B:B,MATCH(Sheet1!L27,Sheet2!E:E,0))),\"\")","v":""},null,{"$f":"IFERROR(INDEX('Sheet1 3'!E$1:E$300,_xlfn.AGGREGATE(15,6,ROW($A$1:$A$100)/ISNUMBER('Sheet1 3'!$H$1:$H$200),ROW(J26))),\"\")","v":""},{"$f":"MAX(IF('Sheet1 3'!$E$1:$E$400=Sheet1!D27,'Sheet1 3'!$F$1:$F$400))","v":"00:00:00"},null,null,null,null,null,null,{"$f":"'Sheet1 3'!E50","v":0}]

{"sheet":"Sheet2","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Last name","First name","Agency code","Organization","Card number"]
["Jackson","Michael",12345,"USA",1]
["Lincoln","Abraham",11111,"USA",2]
["Gates","Bill",22222,"USA",3]
["Presley","Elvis",33333,"USA",4]
["Jobs","Steve",44444,"USA",5]
["Ali","Muhammad",5555,"USA",6]
["Gandhi","Mahatma",6666,"India",7]
["Thatcher","Margaret",7777,"Britain",8]
["Columbus","Christopher",8888,"Italia",9]
["Darwin","Charles",9999,"UK",10]

{"sheet":"Sheet1 3","index":2,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Last name","First name","Organization",null,"Card number","Time"]
[{"$f":"IFERROR(IF(E2=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E2,Sheet2!E:E,0))),\"\")","v":"Jackson"},{"$f":"IFERROR(IF(E2=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E2,Sheet2!E:E,0))),\"\")","v":"Michael"},{"$f":"IFERROR(IF(E2=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E2,Sheet2!E:E,0))),\"\")","v":"USA"},null,1,{"$f":"IF(E2<>\"\",IF(F2=\"\",NOW(),F2),\"\")","v":43545.244288310183},null,{"$f":"IF(COUNTIF(E$2:E2,E2)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E2)),COUNTIF(E$2:E$40,E2),\"\"))","v":5}]
[{"$f":"IFERROR(IF(E3=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E3,Sheet2!E:E,0))),\"\")","v":"Jackson"},{"$f":"IFERROR(IF(E3=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E3,Sheet2!E:E,0))),\"\")","v":"Michael"},{"$f":"IFERROR(IF(E3=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E3,Sheet2!E:E,0))),\"\")","v":"USA"},null,1,{"$f":"IF(E3<>\"\",IF(F3=\"\",NOW(),F3),\"\")","v":43545.244288310183},null,{"$f":"IF(COUNTIF(E$2:E3,E3)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E3)),COUNTIF(E$2:E$40,E3),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E4=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E4,Sheet2!E:E,0))),\"\")","v":"Jackson"},{"$f":"IFERROR(IF(E4=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E4,Sheet2!E:E,0))),\"\")","v":"Michael"},{"$f":"IFERROR(IF(E4=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E4,Sheet2!E:E,0))),\"\")","v":"USA"},null,1,43545.244288310183,null,{"$f":"IF(COUNTIF(E$2:E4,E4)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E4)),COUNTIF(E$2:E$40,E4),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E5=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E5,Sheet2!E:E,0))),\"\")","v":"Jobs"},{"$f":"IFERROR(IF(E5=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E5,Sheet2!E:E,0))),\"\")","v":"Steve"},{"$f":"IFERROR(IF(E5=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E5,Sheet2!E:E,0))),\"\")","v":"USA"},null,5,43545.244482523151,null,{"$f":"IF(COUNTIF(E$2:E5,E5)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E5)),COUNTIF(E$2:E$40,E5),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E6=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E6,Sheet2!E:E,0))),\"\")","v":"Presley"},{"$f":"IFERROR(IF(E6=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E6,Sheet2!E:E,0))),\"\")","v":"Elvis"},{"$f":"IFERROR(IF(E6=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E6,Sheet2!E:E,0))),\"\")","v":"USA"},null,4,43545.244492824073,null,{"$f":"IF(COUNTIF(E$2:E6,E6)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E6)),COUNTIF(E$2:E$40,E6),\"\"))","v":5}]
[{"$f":"IFERROR(IF(E7=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E7,Sheet2!E:E,0))),\"\")","v":"Ali"},{"$f":"IFERROR(IF(E7=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E7,Sheet2!E:E,0))),\"\")","v":"Muhammad"},{"$f":"IFERROR(IF(E7=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E7,Sheet2!E:E,0))),\"\")","v":"USA"},null,6,43545.244508217591,null,{"$f":"IF(COUNTIF(E$2:E7,E7)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E7)),COUNTIF(E$2:E$40,E7),\"\"))","v":5}]
[{"$f":"IFERROR(IF(E8=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E8,Sheet2!E:E,0))),\"\")","v":"Ali"},{"$f":"IFERROR(IF(E8=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E8,Sheet2!E:E,0))),\"\")","v":"Muhammad"},{"$f":"IFERROR(IF(E8=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E8,Sheet2!E:E,0))),\"\")","v":"USA"},null,6,43545.24451261574,null,{"$f":"IF(COUNTIF(E$2:E8,E8)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E8)),COUNTIF(E$2:E$40,E8),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E9=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E9,Sheet2!E:E,0))),\"\")","v":"Columbus"},{"$f":"IFERROR(IF(E9=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E9,Sheet2!E:E,0))),\"\")","v":"Christopher"},{"$f":"IFERROR(IF(E9=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E9,Sheet2!E:E,0))),\"\")","v":"Italia"},null,9,43545.244746412034,null,{"$f":"IF(COUNTIF(E$2:E9,E9)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E9)),COUNTIF(E$2:E$40,E9),\"\"))","v":1}]
[{"$f":"IFERROR(IF(E10=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E10,Sheet2!E:E,0))),\"\")","v":"Thatcher"},{"$f":"IFERROR(IF(E10=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E10,Sheet2!E:E,0))),\"\")","v":"Margaret"},{"$f":"IFERROR(IF(E10=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E10,Sheet2!E:E,0))),\"\")","v":"Britain"},null,8,43545.244751851853,null,{"$f":"IF(COUNTIF(E$2:E10,E10)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E10)),COUNTIF(E$2:E$40,E10),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E11=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E11,Sheet2!E:E,0))),\"\")","v":"Ali"},{"$f":"IFERROR(IF(E11=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E11,Sheet2!E:E,0))),\"\")","v":"Muhammad"},{"$f":"IFERROR(IF(E11=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E11,Sheet2!E:E,0))),\"\")","v":"USA"},null,6,43545.244758680557,null,{"$f":"IF(COUNTIF(E$2:E11,E11)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E11)),COUNTIF(E$2:E$40,E11),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E12=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E12,Sheet2!E:E,0))),\"\")","v":"Gandhi"},{"$f":"IFERROR(IF(E12=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E12,Sheet2!E:E,0))),\"\")","v":"Mahatma"},{"$f":"IFERROR(IF(E12=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E12,Sheet2!E:E,0))),\"\")","v":"India"},null,7,43545.244765393516,null,{"$f":"IF(COUNTIF(E$2:E12,E12)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E12)),COUNTIF(E$2:E$40,E12),\"\"))","v":1}]
[{"$f":"IFERROR(IF(E13=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E13,Sheet2!E:E,0))),\"\")","v":"Jobs"},{"$f":"IFERROR(IF(E13=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E13,Sheet2!E:E,0))),\"\")","v":"Steve"},{"$f":"IFERROR(IF(E13=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E13,Sheet2!E:E,0))),\"\")","v":"USA"},null,5,43545.24477222222,null,{"$f":"IF(COUNTIF(E$2:E13,E13)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E13)),COUNTIF(E$2:E$40,E13),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E14=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E14,Sheet2!E:E,0))),\"\")","v":"Presley"},{"$f":"IFERROR(IF(E14=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E14,Sheet2!E:E,0))),\"\")","v":"Elvis"},{"$f":"IFERROR(IF(E14=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E14,Sheet2!E:E,0))),\"\")","v":"USA"},null,4,43545.244778356478,null,{"$f":"IF(COUNTIF(E$2:E14,E14)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E14)),COUNTIF(E$2:E$40,E14),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E15=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E15,Sheet2!E:E,0))),\"\")","v":"Ali"},{"$f":"IFERROR(IF(E15=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E15,Sheet2!E:E,0))),\"\")","v":"Muhammad"},{"$f":"IFERROR(IF(E15=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E15,Sheet2!E:E,0))),\"\")","v":"USA"},null,6,43545.244785069444,null,{"$f":"IF(COUNTIF(E$2:E15,E15)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E15)),COUNTIF(E$2:E$40,E15),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E16=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E16,Sheet2!E:E,0))),\"\")","v":"Gates"},{"$f":"IFERROR(IF(E16=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E16,Sheet2!E:E,0))),\"\")","v":"Bill"},{"$f":"IFERROR(IF(E16=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E16,Sheet2!E:E,0))),\"\")","v":"USA"},null,3,43545.244792939811,null,{"$f":"IF(COUNTIF(E$2:E16,E16)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E16)),COUNTIF(E$2:E$40,E16),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E17=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E17,Sheet2!E:E,0))),\"\")","v":"Jobs"},{"$f":"IFERROR(IF(E17=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E17,Sheet2!E:E,0))),\"\")","v":"Steve"},{"$f":"IFERROR(IF(E17=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E17,Sheet2!E:E,0))),\"\")","v":"USA"},null,5,43545.24480104167,null,{"$f":"IF(COUNTIF(E$2:E17,E17)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E17)),COUNTIF(E$2:E$40,E17),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E18=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E18,Sheet2!E:E,0))),\"\")","v":"Jackson"},{"$f":"IFERROR(IF(E18=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E18,Sheet2!E:E,0))),\"\")","v":"Michael"},{"$f":"IFERROR(IF(E18=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E18,Sheet2!E:E,0))),\"\")","v":"USA"},null,1,43545.24480763889,null,{"$f":"IF(COUNTIF(E$2:E18,E18)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E18)),COUNTIF(E$2:E$40,E18),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E19=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E19,Sheet2!E:E,0))),\"\")","v":"Lincoln"},{"$f":"IFERROR(IF(E19=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E19,Sheet2!E:E,0))),\"\")","v":"Abraham"},{"$f":"IFERROR(IF(E19=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E19,Sheet2!E:E,0))),\"\")","v":"USA"},null,2,43545.244813310186,null,{"$f":"IF(COUNTIF(E$2:E19,E19)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E19)),COUNTIF(E$2:E$40,E19),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E20=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E20,Sheet2!E:E,0))),\"\")","v":"Jobs"},{"$f":"IFERROR(IF(E20=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E20,Sheet2!E:E,0))),\"\")","v":"Steve"},{"$f":"IFERROR(IF(E20=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E20,Sheet2!E:E,0))),\"\")","v":"USA"},null,5,43545.244818865744,null,{"$f":"IF(COUNTIF(E$2:E20,E20)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E20)),COUNTIF(E$2:E$40,E20),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E21=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E21,Sheet2!E:E,0))),\"\")","v":"Thatcher"},{"$f":"IFERROR(IF(E21=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E21,Sheet2!E:E,0))),\"\")","v":"Margaret"},{"$f":"IFERROR(IF(E21=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E21,Sheet2!E:E,0))),\"\")","v":"Britain"},null,8,43545.244824189816,null,{"$f":"IF(COUNTIF(E$2:E21,E21)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E21)),COUNTIF(E$2:E$40,E21),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E22=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E22,Sheet2!E:E,0))),\"\")","v":"Darwin"},{"$f":"IFERROR(IF(E22=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E22,Sheet2!E:E,0))),\"\")","v":"Charles"},{"$f":"IFERROR(IF(E22=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E22,Sheet2!E:E,0))),\"\")","v":"UK"},null,10,43545.244879282407,null,{"$f":"IF(COUNTIF(E$2:E22,E22)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E22)),COUNTIF(E$2:E$40,E22),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E23=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E23,Sheet2!E:E,0))),\"\")","v":"Jackson"},{"$f":"IFERROR(IF(E23=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E23,Sheet2!E:E,0))),\"\")","v":"Michael"},{"$f":"IFERROR(IF(E23=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E23,Sheet2!E:E,0))),\"\")","v":"USA"},null,1,43545.244846180554,null,{"$f":"IF(COUNTIF(E$2:E23,E23)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E23)),COUNTIF(E$2:E$40,E23),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E24=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E24,Sheet2!E:E,0))),\"\")","v":"Lincoln"},{"$f":"IFERROR(IF(E24=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E24,Sheet2!E:E,0))),\"\")","v":"Abraham"},{"$f":"IFERROR(IF(E24=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E24,Sheet2!E:E,0))),\"\")","v":"USA"},null,2,43545.244849537034,null,{"$f":"IF(COUNTIF(E$2:E24,E24)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E24)),COUNTIF(E$2:E$40,E24),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E25=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E25,Sheet2!E:E,0))),\"\")","v":"Darwin"},{"$f":"IFERROR(IF(E25=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E25,Sheet2!E:E,0))),\"\")","v":"Charles"},{"$f":"IFERROR(IF(E25=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E25,Sheet2!E:E,0))),\"\")","v":"UK"},null,10,43545.24489710648,null,{"$f":"IF(COUNTIF(E$2:E25,E25)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E25)),COUNTIF(E$2:E$40,E25),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E26=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E26,Sheet2!E:E,0))),\"\")","v":"Presley"},{"$f":"IFERROR(IF(E26=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E26,Sheet2!E:E,0))),\"\")","v":"Elvis"},{"$f":"IFERROR(IF(E26=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E26,Sheet2!E:E,0))),\"\")","v":"USA"},null,4,43545.244858564816,null,{"$f":"IF(COUNTIF(E$2:E26,E26)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E26)),COUNTIF(E$2:E$40,E26),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E27=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E27,Sheet2!E:E,0))),\"\")","v":"Darwin"},{"$f":"IFERROR(IF(E27=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E27,Sheet2!E:E,0))),\"\")","v":"Charles"},{"$f":"IFERROR(IF(E27=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E27,Sheet2!E:E,0))),\"\")","v":"UK"},null,10,43545.244907986111,null,{"$f":"IF(COUNTIF(E$2:E27,E27)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E27)),COUNTIF(E$2:E$40,E27),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E28=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E28,Sheet2!E:E,0))),\"\")","v":"Darwin"},{"$f":"IFERROR(IF(E28=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E28,Sheet2!E:E,0))),\"\")","v":"Charles"},{"$f":"IFERROR(IF(E28=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E28,Sheet2!E:E,0))),\"\")","v":"UK"},null,10,{"$f":"IF(E28<>\"\",IF(F28=\"\",NOW(),F28),\"\")","v":43546.24564212963},null,{"$f":"IF(COUNTIF(E$2:E28,E28)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E28)),COUNTIF(E$2:E$40,E28),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E29=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E29,Sheet2!E:E,0))),\"\")","v":"Presley"},{"$f":"IFERROR(IF(E29=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E29,Sheet2!E:E,0))),\"\")","v":"Elvis"},{"$f":"IFERROR(IF(E29=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E29,Sheet2!E:E,0))),\"\")","v":"USA"},null,4,43546.24662233796,null,{"$f":"IF(COUNTIF(E$2:E29,E29)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E29)),COUNTIF(E$2:E$40,E29),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E30=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E30,Sheet2!E:E,0))),\"\")","v":"Presley"},{"$f":"IFERROR(IF(E30=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E30,Sheet2!E:E,0))),\"\")","v":"Elvis"},{"$f":"IFERROR(IF(E30=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E30,Sheet2!E:E,0))),\"\")","v":"USA"},null,4,43546.246736226851,null,{"$f":"IF(COUNTIF(E$2:E30,E30)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E30)),COUNTIF(E$2:E$40,E30),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E31=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E31,Sheet2!E:E,0))),\"\")","v":"Gates"},{"$f":"IFERROR(IF(E31=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E31,Sheet2!E:E,0))),\"\")","v":"Bill"},{"$f":"IFERROR(IF(E31=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E31,Sheet2!E:E,0))),\"\")","v":"USA"},null,3,43549.342310763888,null,{"$f":"IF(COUNTIF(E$2:E31,E31)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E31)),COUNTIF(E$2:E$40,E31),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E32=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E32,Sheet2!E:E,0))),\"\")","v":"Ali"},{"$f":"IFERROR(IF(E32=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E32,Sheet2!E:E,0))),\"\")","v":"Muhammad"},{"$f":"IFERROR(IF(E32=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E32,Sheet2!E:E,0))),\"\")","v":"USA"},null,6,43549.342554282404,null,{"$f":"IF(COUNTIF(E$2:E32,E32)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E32)),COUNTIF(E$2:E$40,E32),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E33=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E33,Sheet2!E:E,0))),\"\")","v":"Jobs"},{"$f":"IFERROR(IF(E33=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E33,Sheet2!E:E,0))),\"\")","v":"Steve"},{"$f":"IFERROR(IF(E33=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E33,Sheet2!E:E,0))),\"\")","v":"USA"},null,5,43549.343178009258,null,{"$f":"IF(COUNTIF(E$2:E33,E33)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E33)),COUNTIF(E$2:E$40,E33),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E34=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E34,Sheet2!E:E,0))),\"\")","v":"Jobs"},{"$f":"IFERROR(IF(E34=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E34,Sheet2!E:E,0))),\"\")","v":"Steve"},{"$f":"IFERROR(IF(E34=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E34,Sheet2!E:E,0))),\"\")","v":"USA"},null,5,43549.343243750001,null,{"$f":"IF(COUNTIF(E$2:E34,E34)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E34)),COUNTIF(E$2:E$40,E34),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E35=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E35,Sheet2!E:E,0))),\"\")","v":"Jobs"},{"$f":"IFERROR(IF(E35=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E35,Sheet2!E:E,0))),\"\")","v":"Steve"},{"$f":"IFERROR(IF(E35=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E35,Sheet2!E:E,0))),\"\")","v":"USA"},null,5,43549.343243750001,null,{"$f":"IF(COUNTIF(E$2:E35,E35)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E35)),COUNTIF(E$2:E$40,E35),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E36=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E36,Sheet2!E:E,0))),\"\")","v":"Jobs"},{"$f":"IFERROR(IF(E36=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E36,Sheet2!E:E,0))),\"\")","v":"Steve"},{"$f":"IFERROR(IF(E36=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E36,Sheet2!E:E,0))),\"\")","v":"USA"},null,5,43549.343243750001,null,{"$f":"IF(COUNTIF(E$2:E36,E36)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E36)),COUNTIF(E$2:E$40,E36),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E37=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E37,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E37=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E37,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E37=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E37,Sheet2!E:E,0))),\"\")","v":""},null,null,"",null,{"$f":"IF(COUNTIF(E$2:E37,E37)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E37)),COUNTIF(E$2:E$40,E37),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E38=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E38,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E38=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E38,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E38=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E38,Sheet2!E:E,0))),\"\")","v":""},null,null,"",null,{"$f":"IF(COUNTIF(E$2:E38,E38)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E38)),COUNTIF(E$2:E$40,E38),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E39=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E39,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E39=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E39,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E39=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E39,Sheet2!E:E,0))),\"\")","v":""},null,null,"",null,{"$f":"IF(COUNTIF(E$2:E39,E39)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E39)),COUNTIF(E$2:E$40,E39),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E40=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E40,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E40=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E40,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E40=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E40,Sheet2!E:E,0))),\"\")","v":""},null,null,"",null,{"$f":"IF(COUNTIF(E$2:E40,E40)>1,\"\",IF(ISODD(COUNTIF(E$2:E$40,E40)),COUNTIF(E$2:E$40,E40),\"\"))","v":""}]
[{"$f":"IFERROR(IF(E41=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E41,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E41=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E41,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E41=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E41,Sheet2!E:E,0))),\"\")","v":""},null,null,""]
[{"$f":"IFERROR(IF(E42=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E42,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E42=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E42,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E42=\"\",\"\",INDEX(Sheet2!D:D,MATCH('Sheet1 3'!E42,Sheet2!E:E,0))),\"\")","v":""},null,null,""]
[{"$f":"IFERROR(IF(E43=\"\",\"\",INDEX(Sheet2!A:A,MATCH('Sheet1 3'!E43,Sheet2!E:E,0))),\"\")","v":""},{"$f":"IFERROR(IF(E43=\"\",\"\",INDEX(Sheet2!B:B,MATCH('Sheet1 3'!E43,Sheet2!E:E,0))),\"\")","v":""}]