{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Method#1","Method#2","Method#3","Method#4","Method#5","Method#6"],"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":"Method#1","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name ","Initial ID","Final ID"]
["Anug Koko","152122$",{"$f":"LEFT(B2, LEN(B2)-1)","v":"152122"}]
["Mongkya Chak","152683e",{"$f":"LEFT(B3, LEN(B3)-1)","v":"152683"}]
["Amelie Griffith","122378r","122378"]
["Franklin Sierra","182930#","182930"]
["Oliver Yew","172993$","172993"]
["Smile Bugg","162839&","162839"]
["Peg Legge","134485*","134485"]
["Allie Gomes","123745_","123745"]
["Micheal Scofield","142836z","142836"]

{"sheet":"Method#2","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name ","Initial ID","Final ID"]
["Anug Koko","152122$",{"$f":"REPLACE(B2,LEN(B2),1,\"\")","v":"152122"}]
["Mongkya Chak","152683e",{"$f":"REPLACE(B3,LEN(B3),1,\"\")","v":"152683"}]
["Amelie Griffith","122378r","122378"]
["Franklin Sierra","182930#","182930"]
["Oliver Yew","172993$","172993"]
["Smile Bugg","162839&","162839"]
["Peg Legge","134485*","134485"]
["Allie Gomes","123745_","123745"]
["Micheal Scofield","142836z","142836"]

{"sheet":"Method#3","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name ","Initial ID"," Final ID"]
["Anug Koko","152122$",{"$f":"ClearLastDigit(B2)","v":"152122"}]
["Mongkya Chak","152683e",{"$f":"ClearLastDigit(B3)","v":"152683"}]
["Amelie Griffith","122378r",{"$f":"ClearLastDigit(B4)","v":"122378"}]
["Franklin Sierra","182930#",{"$f":"ClearLastDigit(B5)","v":"182930"}]
["Oliver Yew","172993$",{"$f":"ClearLastDigit(B6)","v":"172993"}]
["Smile Bugg","162839&",{"$f":"ClearLastDigit(B7)","v":"162839"}]
["Peg Legge","134485*",{"$f":"ClearLastDigit(B8)","v":"134485"}]
["Allie Gomes","123745_",{"$f":"ClearLastDigit(B9)","v":"123745"}]
["Micheal Scofield","142836z",{"$f":"ClearLastDigit(B10)","v":"142836"}]

{"sheet":"Method#4","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name ","Initial ID"," Final ID"]
["Anug Koko","152122$",15212]
["Mongkya Chak","152683e",15268]
["Amelie Griffith","122378r",12237]
["Franklin Sierra","182930#",18293]
["Oliver Yew","172993$",17299]
["Smile Bugg","162839&",16283]
["Peg Legge","134485*",13448]
["Allie Gomes","123745_",12374]
["Micheal Scofield","142836z",14283]

{"sheet":"Method#5","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name ","Initial ID"," Final ID"]
["Anug Koko","152122$",152122]
["Mongkya Chak","152683e",152683]
["Amelie Griffith","122378r",122378]
["Franklin Sierra","182930#",182930]
["Oliver Yew","172993$",172993]
["Smile Bugg","162839&",162839]
["Peg Legge","134485*",134485]
["Allie Gomes","123745_",123745]
["Micheal Scofield","142836z",142836]

{"sheet":"Method#6","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name ","Initial ID"," Final ID"]
["Anug Koko","152122$",{"$f":"ClearLastDigit(B2)","v":"152122"}]
["Mongkya Chak","152683e",{"$f":"ClearLastDigit(B3)","v":"152683"}]
["Amelie Griffith","122378r",{"$f":"ClearLastDigit(B4)","v":"122378"}]
["Franklin Sierra","182930#",{"$f":"ClearLastDigit(B5)","v":"182930"}]
["Oliver Yew","172993$",{"$f":"ClearLastDigit(B6)","v":"172993"}]
["Smile Bugg","162839&",{"$f":"ClearLastDigit(B7)","v":"162839"}]
["Peg Legge","134485*",{"$f":"ClearLastDigit(B8)","v":"134485"}]
["Allie Gomes","123745_",{"$f":"ClearLastDigit(B9)","v":"123745"}]
["Micheal Scofield","142836z",{"$f":"ClearLastDigit(B10)","v":"142836"}]