{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["main","UDF","Matrix","Lambda","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":42,"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":"main","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,9,1]]}
[]
[null,"Calculate Levenshtein Distance in Excel"]
[]
[null,"Company","Name (Actual)","Name (Automated)"]
[null,"Company LMNOP","Ross Geller","Ros Gella"]
[null,null,"Chandler Bing","Chenadler Bong"]
[null,null,"Joey Tribiaani","Joey Tribbiani"]
[null,null,"Rachel Green","Reachel Gree"]
[null,null,"Phoebe Buffay","Phoebe Buffaye"]
[null,null,"Monica Geller","Monica Geller"]

{"sheet":"UDF","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,9,1],[4,6,9,6],[1,6,1,9]]}
[]
[null,"Applying User Defined Function",null,null,null,null,"Practice"]
[]
[null,"Company","Name (Actual)","Name (Automated)","Distance",null,"Company","Name (Actual)","Name (Automated)","Distance"]
[null,"Company LMNOP","Ross Geller","Ros Gella",{"$f":"Levenshtein_Distance(C5,D5)","v":3},null,"Company LMNOP","Ross Geller","Ros Gella"]
[null,null,"Chandler Bing","Chenadler Bong",{"$f":"Levenshtein_Distance(C6,D6)","v":3},null,null,"Chandler Bing","Chenadler Bong"]
[null,null,"Joey Tribiaani","Joey Tribbiani",{"$f":"Levenshtein_Distance(C7,D7)","v":2},null,null,"Joey Tribiaani","Joey Tribbiani"]
[null,null,"Rachel Green","Reachel Gree",{"$f":"Levenshtein_Distance(C8,D8)","v":2},null,null,"Rachel Green","Reachel Gree"]
[null,null,"Phoebe Buffay","Phoebe Buffaye",{"$f":"Levenshtein_Distance(C9,D9)","v":1},null,null,"Phoebe Buffay","Phoebe Buffaye"]
[null,null,"Monica Geller","Monica Geller",{"$f":"Levenshtein_Distance(C10,D10)","v":0},null,null,"Monica Geller","Monica Geller"]

{"sheet":"Matrix","index":2,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,17],[18,1,18,17]]}
[]
[null,"Creating Matrix to Find Levenshtein Distance"]
[]
[null,null,null,{"$f":"MID($R$11,D5,1)","v":"E"},"x","c","e","l","d","e","m","y","","",""]
[null,null,0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,{"$f":"MID($R$12,C6,1)","v":"M"},1,{"$f":"IF(OR(D$5>LEN($R$11),$C6>LEN($R$12)),\"\",IF(D$4=$B6,OFFSET(D6,-1,-1,1,1), MIN(OFFSET(D6,-1,0,1,1)+1,OFFSET(D6,0,-1,1,1)+1,OFFSET(D6,-1,-1,1,1)+1) ))","v":1},2,3,4,5,6,7,7,8,"","",""]
[null,"i",2,2,2,3,4,5,6,7,8,8,"","",""]
[null,"c",3,3,3,2,3,4,5,6,7,8,"","",""]
[null,"r",4,4,4,3,3,4,5,6,7,8,"","",""]
[null,"o",5,5,5,4,4,4,5,6,7,8,"","",""]
[null,"s",6,6,6,5,5,5,5,6,7,8,"","","",null,"Text01","Exceldemy"]
[null,"o",7,7,7,6,6,6,6,6,7,8,"","","",null,"Text02","Microsoft"]
[null,"f",8,8,8,7,7,7,7,7,7,8,"","","",null,"Distance",{"$f":"OFFSET($C$5,LEN($R$12),LEN($R$11),1,1)","v":8}]
[null,"t",9,9,9,8,8,8,8,8,8,8,"","",""]
[null,"",10,"","","","","","","","","","","",""]
[null,"",11,"","","","","","","","","","","",""]
[null,"",12,"","","","","","","","","","","",""]
[]
[null,"Practice"]
[]
[]
[null,null,0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,"Text01"]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,"Text02"]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distance"]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]

{"sheet":"Lambda","index":3,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,9,1],[1,6,1,9],[4,6,9,6]]}
[]
[null,"Incorporating LAMBDA Function",null,null,null,null,"Practice"]
[]
[null,"Company","Name (Actual)","Name (Automated)","Distance",null,"Company","Name (Actual)","Name (Automated)","Distance"]
[null,"Company LMNOP","Ross Geller","Ros Gella",{"$f":"LEVDISTANCE(C5,D5)","v":3},null,"Company LMNOP","Ross Geller","Ros Gella"]
[null,null,"Chandler Bing","Chenadler Bong",{"$f":"LEVDISTANCE(C6,D6)","v":3},null,null,"Chandler Bing","Chenadler Bong"]
[null,null,"Joey Tribiaani","Joey Tribbiani",{"$f":"LEVDISTANCE(C7,D7)","v":2},null,null,"Joey Tribiaani","Joey Tribbiani"]
[null,null,"Rachel Green","Reachel Gree",{"$f":"LEVDISTANCE(C8,D8)","v":2},null,null,"Rachel Green","Reachel Gree"]
[null,null,"Phoebe Buffay","Phoebe Buffaye",{"$f":"LEVDISTANCE(C9,D9)","v":1},null,null,"Phoebe Buffay","Phoebe Buffaye"]
[null,null,"Monica Geller","Monica Geller",{"$f":"LEVDISTANCE(C10,D10)","v":0},null,null,"Monica Geller","Monica Geller"]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,1,9,1],[1,1,1,5],[4,7,9,7],[1,7,1,11]]}
[]
[null,"Applying VBA",null,null,null,null,null,"Practice"]
[]
[null,"Company","Name (Actual)","Name (Automated)","Similarity","LEV Distance",null,"Company","Name (Actual)","Name (Automated)","Similarity","LEV Distance"]
[null,"Company LMNOP","Ross Geller","Ros Gella",0.72727272727272729,0.72727272727272729,null,"Company LMNOP","Ross Geller","Ros Gella"]
[null,null,"Chandler Bing","Chenadler Bong",0.92307692307692313,0.7857142857142857,null,null,"Chandler Bing","Chenadler Bong"]
[null,null,"Joey Tribiaani","Joey Tribbiani",0.9285714285714286,0.8571428571428571,null,null,"Joey Tribiaani","Joey Tribbiani"]
[null,null,"Rachel Green","Reachel Gree",0.91666666666666663,0.83333333333333337,null,null,"Rachel Green","Reachel Gree"]
[null,null,"Phoebe Buffay","Phoebe Buffaye",1,0.9285714285714286,null,null,"Phoebe Buffay","Phoebe Buffaye"]
[null,null,"Monica Geller","Monica Geller",1,1,null,null,"Monica Geller","Monica Geller"]