{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Part num","Part num (UDF)","Vehicle applications"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Part num","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Start","End","Description","Item"]
["2017-01-01","2017-01-04","A",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF((A2<='Vehicle applications'!$C$2:$C$13)*(B2>='Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"))","v":""}]
["2017-02-22","2017-02-25","B",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF((A3<='Vehicle applications'!$C$2:$C$13)*(B3>='Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"))","v":"S, N, F"}]
["2017-02-25","2017-02-27","C",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF((A4<='Vehicle applications'!$C$2:$C$13)*(B4>='Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"))","v":"S, N"}]
["2017-03-02","2017-03-04","D",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF((A5<='Vehicle applications'!$C$2:$C$13)*(B5>='Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"))","v":"E, Q"}]
["2017-03-21","2017-03-25","E",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,IF((A6<='Vehicle applications'!$C$2:$C$13)*(B6>='Vehicle applications'!$C$2:$C$13),'Vehicle applications'!$A$2:$A$13,\"\"))","v":"P, V"}]

{"sheet":"Part num (UDF)","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Start","End","Description","Item"]
["2017-01-01","2017-01-04","A",{"$f":"Lookup_concat(A2,B2,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":""}]
["2017-02-22","2017-02-25","B",{"$f":"Lookup_concat(A3,B3,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"S, N, F"}]
["2017-02-25","2017-02-27","C",{"$f":"Lookup_concat(A4,B4,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"S, N"}]
["2017-03-02","2017-03-04","D",{"$f":"Lookup_concat(A5,B5,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"E, Q"}]
["2017-03-21","2017-03-25","E",{"$f":"Lookup_concat(A6,B6,'Vehicle applications'!$C$2:$C$13,'Vehicle applications'!$A$2:$A$13)","v":"P, V"}]

{"sheet":"Vehicle applications","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Item","Part description","Date"]
["S","A","2017-02-25"]
["P","B","2017-02-28"]
["E","C","2017-03-04"]
["S","A","2017-01-07"]
["O","B","2017-02-10"]
["N","A","2017-02-25"]
["R","B","2017-01-16"]
["P","D","2017-03-21"]
["Q","E","2017-03-04"]
["F","A","2017-02-22"]
["X","B","2017-03-13"]
["V","C","2017-03-25"]