{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5"],"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":"Sheet1","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name:Subject","Position of last \":\" character"]
["Charlotte White:History",{"$f":"LEN(_xlfn.TEXTBEFORE(A2,\":\",-1))+1","v":16}]
["Chloe Allen:Math",{"$f":"LEN(_xlfn.TEXTBEFORE(A3,\":\",-1))+1","v":12}]
["Oliver Wilson:History",14]
["Ruby Scott:English",11]
["Amelia Taylor:Science",14]
["Emily Johnson:Science",14]
["Jack Anderson:English",14]
["Michael Brown:History",14]
["Liam Thompson:Math",14]

{"sheet":"Sheet2","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name:Subject","Position of last \":\" character"]
["Charlotte White:History",{"$f":"MATCH(2,1/(MID(A2,_xlfn.SEQUENCE(LEN(A2)),1)=\":\"))","v":16}]
["Chloe Allen:Math",{"$f":"MATCH(2,1/(MID(A3,_xlfn.SEQUENCE(LEN(A3)),1)=\":\"))","v":12}]
["Oliver Wilson:History",{"$f":"MATCH(2,1/(MID(A4,_xlfn.SEQUENCE(LEN(A4)),1)=\":\"))","v":14}]
["Ruby Scott:English",{"$f":"MATCH(2,1/(MID(A5,_xlfn.SEQUENCE(LEN(A5)),1)=\":\"))","v":11}]
["Amelia Taylor:Science",{"$f":"MATCH(2,1/(MID(A6,_xlfn.SEQUENCE(LEN(A6)),1)=\":\"))","v":14}]
["Emily Johnson:Science",{"$f":"MATCH(2,1/(MID(A7,_xlfn.SEQUENCE(LEN(A7)),1)=\":\"))","v":14}]
["Jack Anderson:English",{"$f":"MATCH(2,1/(MID(A8,_xlfn.SEQUENCE(LEN(A8)),1)=\":\"))","v":14}]
["Michael Brown:History",{"$f":"MATCH(2,1/(MID(A9,_xlfn.SEQUENCE(LEN(A9)),1)=\":\"))","v":14}]
["Liam Thompson:Math",{"$f":"MATCH(2,1/(MID(A10,_xlfn.SEQUENCE(LEN(A10)),1)=\":\"))","v":14}]

{"sheet":"Sheet3","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name:Subject","Position of last \":\" character"]
["Charlotte White:History",{"$f":"FIND(\"@\",SUBSTITUTE(A2,\":\",\"@\",(LEN(A2)-LEN(SUBSTITUTE(A2,\":\",\"\")))))","v":16}]
["Chloe Allen:Math",{"$f":"FIND(\"@\",SUBSTITUTE(A3,\":\",\"@\",(LEN(A3)-LEN(SUBSTITUTE(A3,\":\",\"\")))))","v":12}]
["Oliver Wilson:History",14]
["Ruby Scott:English",11]
["Amelia Taylor:Science",14]
["Emily Johnson:Science",14]
["Jack Anderson:English",14]
["Michael Brown:History",14]
["Liam Thompson:Math",14]

{"sheet":"Sheet4","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name:Subject","Position of last \":\" character"]
["Charlotte White:History",{"$f":"MAX(IF(MID(A2, ROW(INDIRECT(\"1:\" & LEN(A2))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A2))), 0))","v":16}]
["Chloe Allen:Math",{"$f":"MAX(IF(MID(A3, ROW(INDIRECT(\"1:\" & LEN(A3))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A3))), 0))","v":12}]
["Oliver Wilson:History",{"$f":"MAX(IF(MID(A4, ROW(INDIRECT(\"1:\" & LEN(A4))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A4))), 0))","v":14}]
["Ruby Scott:English",{"$f":"MAX(IF(MID(A5, ROW(INDIRECT(\"1:\" & LEN(A5))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A5))), 0))","v":11}]
["Amelia Taylor:Science",{"$f":"MAX(IF(MID(A6, ROW(INDIRECT(\"1:\" & LEN(A6))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A6))), 0))","v":14}]
["Emily Johnson:Science",{"$f":"MAX(IF(MID(A7, ROW(INDIRECT(\"1:\" & LEN(A7))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A7))), 0))","v":14}]
["Jack Anderson:English",{"$f":"MAX(IF(MID(A8, ROW(INDIRECT(\"1:\" & LEN(A8))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A8))), 0))","v":14}]
["Michael Brown:History",{"$f":"MAX(IF(MID(A9, ROW(INDIRECT(\"1:\" & LEN(A9))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A9))), 0))","v":14}]
["Liam Thompson:Math",{"$f":"MAX(IF(MID(A10, ROW(INDIRECT(\"1:\" & LEN(A10))), 1) = \":\", ROW(INDIRECT(\"1:\" & LEN(A10))), 0))","v":14}]

{"sheet":"Sheet5","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name:Subject","Position of last \":\" character"]
["Charlotte White:History",{"$f":"GetLastCharacterPosition(A2, \":\")","v":16}]
["Chloe Allen:Math",{"$f":"GetLastCharacterPosition(A3, \":\")","v":12}]
["Oliver Wilson:History",{"$f":"GetLastCharacterPosition(A4, \":\")","v":14}]
["Ruby Scott:English",{"$f":"GetLastCharacterPosition(A5, \":\")","v":11}]
["Amelia Taylor:Science",{"$f":"GetLastCharacterPosition(A6, \":\")","v":14}]
["Emily Johnson:Science",{"$f":"GetLastCharacterPosition(A7, \":\")","v":14}]
["Jack Anderson:English",{"$f":"GetLastCharacterPosition(A8, \":\")","v":14}]
["Michael Brown:History",{"$f":"GetLastCharacterPosition(A9, \":\")","v":14}]
["Liam Thompson:Math",{"$f":"GetLastCharacterPosition(A10, \":\")","v":14}]