{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["List1","List2","List3","List2(an)","List3(an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"List1","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["List1"]
["rad 1"]
["rad 2"]
["rad 3"]
["rad 4"]
["rad 5"]
["rad 6"]
["rad 8"]
["rad 9"]
["rad 11"]
["rad 12"]
["rad 14"]
["rad 16"]
["rad 17"]
["rad 19"]

{"sheet":"List2","index":1,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["If item in List 2 is not in List 1, then put in List 3","List2"]
[null,"rad 1"]
[null,"rad 2"]
[null,"rad 3"]
[null,"rad 4"]
[null,"rad 5"]
[null,"rad 6"]
[null,"rad 7"]
[null,"rad 8"]
[null,"rad 9"]
[null,"rad 10"]
[null,"rad 11"]
[null,"rad 12"]
[null,"rad 13"]
[null,"rad 14"]
[null,"rad 15"]
[null,"rad 16"]
[null,"rad 17"]
[null,"rad 18"]
[null,"rad 19"]
[null,"rad 20"]
[null,"rad 21"]
[null,"rad 22"]
[null,"rad 23"]
[null,"rad 24"]
[null,"rad 25"]
[null,"rad 26"]

{"sheet":"List3","index":2,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["No","List3"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]

{"sheet":"List2(an)","index":3,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["If item in List 2 is not in List 1, then put in List 3","List2"]
[{"$f":"SUM(ISNA(MATCH(B2,List1!$A$2:$A$15,0)),A1)","v":0},"rad 1"]
[{"$f":"SUM(ISNA(MATCH(B3,List1!$A$2:$A$15,0)),A2)","v":0},"rad 2"]
[{"$f":"SUM(ISNA(MATCH(B4,List1!$A$2:$A$15,0)),A3)","v":0},"rad 3"]
[{"$f":"SUM(ISNA(MATCH(B5,List1!$A$2:$A$15,0)),A4)","v":0},"rad 4"]
[{"$f":"SUM(ISNA(MATCH(B6,List1!$A$2:$A$15,0)),A5)","v":0},"rad 5"]
[{"$f":"SUM(ISNA(MATCH(B7,List1!$A$2:$A$15,0)),A6)","v":0},"rad 6"]
[{"$f":"SUM(ISNA(MATCH(B8,List1!$A$2:$A$15,0)),A7)","v":1},"rad 7"]
[{"$f":"SUM(ISNA(MATCH(B9,List1!$A$2:$A$15,0)),A8)","v":1},"rad 8"]
[{"$f":"SUM(ISNA(MATCH(B10,List1!$A$2:$A$15,0)),A9)","v":1},"rad 9"]
[{"$f":"SUM(ISNA(MATCH(B11,List1!$A$2:$A$15,0)),A10)","v":2},"rad 10"]
[{"$f":"SUM(ISNA(MATCH(B12,List1!$A$2:$A$15,0)),A11)","v":2},"rad 11"]
[{"$f":"SUM(ISNA(MATCH(B13,List1!$A$2:$A$15,0)),A12)","v":2},"rad 12"]
[{"$f":"SUM(ISNA(MATCH(B14,List1!$A$2:$A$15,0)),A13)","v":3},"rad 13"]
[{"$f":"SUM(ISNA(MATCH(B15,List1!$A$2:$A$15,0)),A14)","v":3},"rad 14"]
[{"$f":"SUM(ISNA(MATCH(B16,List1!$A$2:$A$15,0)),A15)","v":4},"rad 15"]
[{"$f":"SUM(ISNA(MATCH(B17,List1!$A$2:$A$15,0)),A16)","v":4},"rad 16"]
[{"$f":"SUM(ISNA(MATCH(B18,List1!$A$2:$A$15,0)),A17)","v":4},"rad 17"]
[{"$f":"SUM(ISNA(MATCH(B19,List1!$A$2:$A$15,0)),A18)","v":5},"rad 18"]
[{"$f":"SUM(ISNA(MATCH(B20,List1!$A$2:$A$15,0)),A19)","v":5},"rad 19"]
[{"$f":"SUM(ISNA(MATCH(B21,List1!$A$2:$A$15,0)),A20)","v":6},"rad 20"]
[{"$f":"SUM(ISNA(MATCH(B22,List1!$A$2:$A$15,0)),A21)","v":7},"rad 21"]
[{"$f":"SUM(ISNA(MATCH(B23,List1!$A$2:$A$15,0)),A22)","v":8},"rad 22"]
[{"$f":"SUM(ISNA(MATCH(B24,List1!$A$2:$A$15,0)),A23)","v":9},"rad 23"]
[{"$f":"SUM(ISNA(MATCH(B25,List1!$A$2:$A$15,0)),A24)","v":10},"rad 24"]
[{"$f":"SUM(ISNA(MATCH(B26,List1!$A$2:$A$15,0)),A25)","v":11},"rad 25"]
[{"$f":"SUM(ISNA(MATCH(B27,List1!$A$2:$A$15,0)),A26)","v":12},"rad 26"]

{"sheet":"List3(an)","index":4,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["No","List3"]
[1,{"$f":"IFERROR(VLOOKUP(A2,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 7"}]
[2,{"$f":"IFERROR(VLOOKUP(A3,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 10"}]
[3,{"$f":"IFERROR(VLOOKUP(A4,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 13"}]
[4,{"$f":"IFERROR(VLOOKUP(A5,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 15"}]
[5,{"$f":"IFERROR(VLOOKUP(A6,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 18"}]
[6,{"$f":"IFERROR(VLOOKUP(A7,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 20"}]
[7,{"$f":"IFERROR(VLOOKUP(A8,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 21"}]
[8,{"$f":"IFERROR(VLOOKUP(A9,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 22"}]
[9,{"$f":"IFERROR(VLOOKUP(A10,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 23"}]
[10,{"$f":"IFERROR(VLOOKUP(A11,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 24"}]
[11,{"$f":"IFERROR(VLOOKUP(A12,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 25"}]
[12,{"$f":"IFERROR(VLOOKUP(A13,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":"rad 26"}]
[13,{"$f":"IFERROR(VLOOKUP(A14,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[14,{"$f":"IFERROR(VLOOKUP(A15,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[15,{"$f":"IFERROR(VLOOKUP(A16,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[16,{"$f":"IFERROR(VLOOKUP(A17,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[17,{"$f":"IFERROR(VLOOKUP(A18,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[18,{"$f":"IFERROR(VLOOKUP(A19,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[19,{"$f":"IFERROR(VLOOKUP(A20,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[20,{"$f":"IFERROR(VLOOKUP(A21,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[21,{"$f":"IFERROR(VLOOKUP(A22,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[22,{"$f":"IFERROR(VLOOKUP(A23,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[23,{"$f":"IFERROR(VLOOKUP(A24,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[24,{"$f":"IFERROR(VLOOKUP(A25,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[25,{"$f":"IFERROR(VLOOKUP(A26,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[26,{"$f":"IFERROR(VLOOKUP(A27,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[27,{"$f":"IFERROR(VLOOKUP(A28,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[28,{"$f":"IFERROR(VLOOKUP(A29,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[29,{"$f":"IFERROR(VLOOKUP(A30,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[30,{"$f":"IFERROR(VLOOKUP(A31,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[31,{"$f":"IFERROR(VLOOKUP(A32,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[32,{"$f":"IFERROR(VLOOKUP(A33,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[33,{"$f":"IFERROR(VLOOKUP(A34,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[34,{"$f":"IFERROR(VLOOKUP(A35,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[35,{"$f":"IFERROR(VLOOKUP(A36,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[36,{"$f":"IFERROR(VLOOKUP(A37,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[37,{"$f":"IFERROR(VLOOKUP(A38,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]
[38,{"$f":"IFERROR(VLOOKUP(A39,'List2(an)'!$A$2:$B$27,2,0),\"\")","v":""}]