{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["dataset","position of substring","checking substring","extracting data","Bold","practice"],"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":"dataset","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"X\" College"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"position of substring","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Position of \"@\" in Email Id"]
[]
[null,"Student Name","Result","Email Id","Position"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"},{"$f":"FindSubstring(D5)","v":8}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"},{"$f":"FindSubstring(D6)","v":8}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com",{"$f":"FindSubstring(D7)","v":7}]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com",{"$f":"FindSubstring(D8)","v":7}]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"},{"$f":"FindSubstring(D9)","v":10}]
[null,"Donald Paul","F (Fail)","donald@gmail.com",{"$f":"FindSubstring(D10)","v":7}]

{"sheet":"checking substring","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Checking Result"]
[]
[null,"Student Name","Result","Pass or fail"]
[null,"Michael James","A (Pass)","Passed"]
[null,"William David","B (Pass)","Passed"]
[null,"Joseph Michael","F (Fail)","Failed"]
[null,"Daniel Defoe","C (Pass)","Passed"]
[null,"Michael Anthony","F (Fail)","Failed"]
[null,"Donald Paul","F (Fail)","Failed"]

{"sheet":"extracting data","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[null,null,null,null,"Michael James","A (Pass)","michael@gmail.com"]
[null,"Checking and Extracting Data",null,null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,null,null,null,"Michael Anthony","F (Fail)","michael23@gmail.com"]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"Bold","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Bolding a substring"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"practice","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]