{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Student IDs","Clean Data"]
["2024ENG001!",{"$f":"REPLACE(A2, LEN(A2),1,\"\")","v":"2024ENG001"}]
["2024ENG002!",{"$f":"REPLACE(A3, LEN(A3),1,\"\")","v":"2024ENG002"}]
["2024ENG003!","2024ENG003"]
["2024SCI001!","2024SCI001"]
["2024SCI002!","2024SCI002"]
["2024BUS001!","2024BUS001"]
["2024BUS002!","2024BUS002"]
["2024ART001!","2024ART001"]
["2024ART002!","2024ART002"]
["2024ART003!","2024ART003"]
["2024ENG004!","2024ENG004"]
["2024ENG005!","2024ENG005"]
["2024ENG006!","2024ENG006"]
["2024SCI003!","2024SCI003"]
["2024SCI004!","2024SCI004"]
["2024BUS003!","2024BUS003"]
["2024BUS004!","2024BUS004"]
["2024ART004!","2024ART004"]
["2024ART005!","2024ART005"]
["2024ART006!","2024ART006"]

{"sheet":"Sheet2","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Distance","Clean Data"]
["120 miles",{"$f":"VALUE(LEFT(A2, LEN(A2) - 6))","v":120}]
["245 miles",{"$f":"VALUE(LEFT(A3, LEN(A3) - 6))","v":245}]
["365 miles",365]
["478 miles",478]
["580 miles",580]
["655 miles",655]
["736 miles",736]
["820 miles",820]
["945 miles",945]
["1020 miles",1020]
["1100 miles",1100]
["1225 miles",1225]
["1350 miles",1350]
["1485 miles",1485]
["1620 miles",1620]
["1750 miles",1750]
["1890 miles",1890]
["2025 miles",2025]
["2160 miles",2160]
["2300 miles",2300]

{"sheet":"Sheet3","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Email","Username"]
["alice.smith@example.com","alice.smith"]
["bob.johnson@example.com","bob.johnson"]
["carol.white@example.com","carol.white"]
["david.moore@example.com"]
["emily.brown@example.com"]
["frank.clark@example.com"]
["grace.lee@example.com"]
["harry.hall@example.com"]
["iris.wilson@example.com"]
["jake.taylor@example.com"]

{"sheet":"Sheet4","index":3,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Student IDs"]
["2024ENG001!"]
["2024ENG002!"]
["2024ENG003!"]
["2024SCI001!"]
["2024SCI002!"]
["2024BUS001!"]
["2024BUS002!"]
["2024ART001!"]
["2024ART002!"]
["2024ART003!"]
["2024ENG004!"]
["2024ENG005!"]
["2024ENG006!"]
["2024SCI003!"]
["2024SCI004!"]
["2024BUS003!"]
["2024BUS004!"]
["2024ART004!"]
["2024ART005!"]
["2024ART006!"]