{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["main dataset","count character in a cell","sum of character","count numbers","Count characters except number","Counting special character","VBA"],"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":"main dataset","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Counting Character Number of Password"]
[]
[null,"Full Name","Email Id","Password"]
[null,"Samina Hasan","saminahasan@gmail.com","a3dbv78mn"]
[null,"Afifa Jahan","afifajahan@gmail.com","sd89hbAe3t"]
[null,"Katherine Loya","katherineloya@gmail.com","Cvfg5t982m"]
[null,"Joseph Goebbels","josephgoebbels@gmail.com","3ghTrvd879O23"]
[null,"Daniel Defoe","danieldefoe@gmail.com","A5ths8uJk0982"]
[null,"Sourav Roy","souravroy@gmail.com","A345knmbluy8ff"]

{"sheet":"count character in a cell","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Counting Character Number of Password"]
[]
["Full Name","Email Id","Password","COUNT"]
["Samina Hasan","saminahasan@gmail.com","a3dbv78mn",{"$f":"LEN(C4)","v":9}]
["Afifa Jahan","afifajahan@gmail.com","sd89hbAe3t",{"$f":"LEN(C5)","v":10}]
["Katherine Loya","katherineloya@gmail.com","Cvfg5t982m",10]
["Joseph Goebbels","josephgoebbels@gmail.com","3ghTrvd879O23",13]
["Daniel Defoe","danieldefoe@gmail.com","A5ths8uJk0982",13]
["Sourav Roy","souravroy@gmail.com","A345knmbluy8ff",14]

{"sheet":"sum of character","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Counting Character Number of Password"]
[]
["Full Name","Email Id","Password","COUNT"]
["Samina Hasan","saminahasan@gmail.com","a3dbv78mn"]
["Afifa Jahan","afifajahan@gmail.com","sd89hbAe3t"]
["Katherine Loya","katherineloya@gmail.com","Cvfg5t982m",{"$f":"SUM((LEN(C4:C9)))","v":69}]
["Joseph Goebbels","josephgoebbels@gmail.com","3ghTrvd879O23"]
["Daniel Defoe","danieldefoe@gmail.com","A5ths8uJk0982"]
["Sourav Roy","souravroy@gmail.com","A345knmbluy8ff"]

{"sheet":"count numbers","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Counting Character Number of Password"]
[]
["Full Name","Email Id","Password","COUNT of Numbers"]
["Samina Hasan","saminahasan@gmail.com","a3dbv78mn",{"$f":"SUM(LEN(C4)-LEN(SUBSTITUTE(C4,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":3}]
["Afifa Jahan","afifajahan@gmail.com","sd89hbAe3t",{"$f":"SUM(LEN(C5)-LEN(SUBSTITUTE(C5,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":3}]
["Katherine Loya","katherineloya@gmail.com","Cvfg5t982m",{"$f":"SUM(LEN(C6)-LEN(SUBSTITUTE(C6,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":4}]
["Joseph Goebbels","josephgoebbels@gmail.com","3ghTrvd879O23",{"$f":"SUM(LEN(C7)-LEN(SUBSTITUTE(C7,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":6}]
["Daniel Defoe","danieldefoe@gmail.com","A5ths8uJk0982",{"$f":"SUM(LEN(C8)-LEN(SUBSTITUTE(C8,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":6}]
["Sourav Roy","souravroy@gmail.com","A345knmbluy8ff",{"$f":"SUM(LEN(C9)-LEN(SUBSTITUTE(C9,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":4}]

{"sheet":"Count characters except number","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Counting Character Number of Password"]
[]
["Full Name","Email Id","Password","COUNT Characters except Numbers"]
["Samina Hasan","saminahasan@gmail.com","a3dbv78mn",{"$f":"LEN(C4)-(SUM(LEN(C4)-LEN(SUBSTITUTE(C4,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":6}]
["Afifa Jahan","afifajahan@gmail.com","sd89hbAe3t",{"$f":"LEN(C5)-(SUM(LEN(C5)-LEN(SUBSTITUTE(C5,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":7}]
["Katherine Loya","katherineloya@gmail.com","Cvfg5t982m",{"$f":"LEN(C6)-(SUM(LEN(C6)-LEN(SUBSTITUTE(C6,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":6}]
["Joseph Goebbels","josephgoebbels@gmail.com","3ghTrvd879O23",{"$f":"LEN(C7)-(SUM(LEN(C7)-LEN(SUBSTITUTE(C7,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":7}]
["Daniel Defoe","danieldefoe@gmail.com","A5ths8uJk0982",{"$f":"LEN(C8)-(SUM(LEN(C8)-LEN(SUBSTITUTE(C8,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":7}]
["Sourav Roy","souravroy@gmail.com","A345knmbluy8ff",{"$f":"LEN(C9)-(SUM(LEN(C9)-LEN(SUBSTITUTE(C9,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":10}]

{"sheet":"Counting special character","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Counting Special Character"]
[]
[null,"Full Name","Email Id","Count \"a\" in Email Id"]
[null,"Samina Hasan","saminahasan@gmail.com",{"$f":"LEN(C4)-LEN(SUBSTITUTE(C4,\"a\",\"\"))","v":5}]
[null,"Afifa Jahan","afifajahan@gmail.com",{"$f":"LEN(C5)-LEN(SUBSTITUTE(C5,\"a\",\"\"))","v":5}]
[null,"Katherine Loya","katherineloya@gmail.com",3]
[null,"Joseph Goebbels","josephgoebbels@gmail.com",1]
[null,"Daniel Defoe","danieldefoe@gmail.com",2]
[null,"Sourav Roy","souravroy@gmail.com",2]

{"sheet":"VBA","index":6,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Counting Character Number of Password"]
[]
["Full Name","Email Id","Password","COUNT"]
["Samina Hasan","saminahasan@gmail.com","a3dbv78mn",{"$f":"CharacterNo(C4)","v":"1L1N3L2N2L"}]
["Afifa Jahan","afifajahan@gmail.com","sd89hbAe3t",{"$f":"CharacterNo(C5)","v":"2L2N4L1N1L"}]
["Katherine Loya","katherineloya@gmail.com","Cvfg5t982m",{"$f":"CharacterNo(C6)","v":"4L1N1L3N1L"}]
["Joseph Goebbels","josephgoebbels@gmail.com","3ghTrvd879O23",{"$f":"CharacterNo(C7)","v":"1N6L3N1L2N"}]
["Daniel Defoe","danieldefoe@gmail.com","A5ths8uJk0982",{"$f":"CharacterNo(C8)","v":"1L1N3L1N3L4N"}]
["Sourav Roy","souravroy@gmail.com","A345knmbluy8ff",{"$f":"CharacterNo(C9)","v":"1L3N7L1N2L"}]