{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ValidationExample"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"ValidationExample","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["tblMachines",null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.SORT(_xlfn.UNIQUE(tblMachines[Brand])))","v":"Brand 1"},"Brand 2","Brand 3","Brand 4","Brand 5"]
[null,null,null,"Brand","Type",null,{"$f":"_xlfn._xlws.FILTER(tblMachines[Type],tblMachines[Brand]=G1)","v":"Brand 1 Prod 1"},{"$f":"_xlfn._xlws.FILTER(tblMachines[Type],tblMachines[Brand]=H1)","v":"Brand 2 Prod 2"},{"$f":"_xlfn._xlws.FILTER(tblMachines[Type],tblMachines[Brand]=I1)","v":"Brand 3 Prod 1"},{"$f":"_xlfn._xlws.FILTER(tblMachines[Type],tblMachines[Brand]=J1)","v":"Brand 4 Prod 2"},{"$f":"_xlfn._xlws.FILTER(tblMachines[Type],tblMachines[Brand]=K1)","v":"Brand 5 Prod 1"}]
["Brand","Type",null,"Brand 2","Brand 2 Prod 5",null,"Brand 1 Prod 2","Brand 2 Prod 3",null,"Brand 4 Prod 5","Brand 5 Prod 3"]
["Brand 1","Brand 1 Prod 1",null,null,"Validation formula: =INDEX($G$2:$XFD$2,MATCH(D3,$G$1#,0))#",null,"Brand 1 Prod 3","Brand 2 Prod 5",null,null,"Brand 5 Prod 5"]
["Brand 1","Brand 1 Prod 2",null,null,null,null,"Brand 1 Prod 4"]
["Brand 1","Brand 1 Prod 3",null,null,null,null,"Brand 1 Prod 5"]
["Brand 1","Brand 1 Prod 4"]
["Brand 1","Brand 1 Prod 5"]
["Brand 2","Brand 2 Prod 2"]
["Brand 2","Brand 2 Prod 3",null,null,"This workbook is © JKP Application Development Services, all rights reserved"]
["Brand 2","Brand 2 Prod 5",null,null,"https://jkp-ads.com"]
["Brand 3","Brand 3 Prod 1"]
["Brand 4","Brand 4 Prod 2"]
["Brand 4","Brand 4 Prod 5"]
["Brand 5","Brand 5 Prod 1"]
["Brand 5","Brand 5 Prod 3"]
["Brand 5","Brand 5 Prod 5"]