{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Formula 1","Formula 2","WORD","Flash Fill","VBA 1","VBA 2"],"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":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Incorrect Format Sentence List"]
[]
[null,"Sentences"]
[null,"a picTUre is worth A ThouSand wORds."]
[null,"BeTTer laTe than neveR."]
[null,"samanthA tOOk thE bus."]
[null,"beGGars can’T be chOOsers."]
[null,"i did not sEe tHem at the Bus station."]
[null,"Sara has NO monEY at THE moment."]
[null,"mary likes BaNANas."]
[null,"i love my new PETs."]
[null,"HE liKes coFFee and tEa."]
[null,"Our car broke down."]

{"sheet":"Formula 1","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using UPPER, LOWER, RIGHT, LEFT and LEN Functions"]
[]
[null,"Given Case","In Sentence Case"]
[null,"a picTUre is worth A ThouSand wORds.",{"$f":"UPPER(LEFT(B5,1))&LOWER(RIGHT(B5,LEN(B5)-1))","v":"A picture is worth a thousand words."}]
[null,"BeTTer laTe than neveR.",{"$f":"UPPER(LEFT(B6,1))&LOWER(RIGHT(B6,LEN(B6)-1))","v":"Better late than never."}]
[null,"samanthA tOOk thE bus.","Samantha took the bus."]
[null,"beGGars can’T be chOOsers.","Beggars can’t be choosers."]
[null,"i did not sEe tHem at the Bus station.","I did not see them at the bus station."]
[null,"Sara has NO monEY at THE moment.","Sara has no money at the moment."]
[null,"mary likes BaNANas.","Mary likes bananas."]
[null,"i love my new PETs.","I love my new pets."]
[null,"HE liKes coFFee and tEa.","He likes coffee and tea."]
[null,"Our car broke down.","Our car broke down."]

{"sheet":"Formula 2","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using UPPER, LOWER, MID and LEFT Functions"]
[]
[null,"Given Case","In Sentence Case"]
[null,"a picTUre is worth A ThouSand wORds.",{"$f":"UPPER(LEFT(B5,1))&MID(LOWER(B5),2,999)","v":"A picture is worth a thousand words."}]
[null,"BeTTer laTe than neveR.",{"$f":"UPPER(LEFT(B6,1))&MID(LOWER(B6),2,999)","v":"Better late than never."}]
[null,"samanthA tOOk thE bus.","Samantha took the bus."]
[null,"beGGars can’T be chOOsers.","Beggars can’t be choosers."]
[null,"i did not sEe tHem at the Bus station.","I did not see them at the bus station."]
[null,"Sara has NO monEY at THE moment.","Sara has no money at the moment."]
[null,"mary likes BaNANas.","Mary likes bananas."]
[null,"i love my new PETs.","I love my new pets."]
[null,"HE liKes coFFee and tEa.","He likes coffee and tea."]
[null,"Our car broke down.","Our car broke down."]

{"sheet":"WORD","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Word"]
[]
[null,"Given Case","In Sentence Case"]
[null,"a picTUre is worth A ThouSand wORds.","A picture is worth a thousand words."]
[null,"BeTTer laTe than neveR.","Better late than never."]
[null,"samanthA tOOk thE bus.","Samantha took the bus."]
[null,"beGGars can’T be chOOsers.","Beggars can’t be choosers."]
[null,"i did not sEe tHem at the Bus station.","I did not see them at the bus station."]
[null,"Sara has NO monEY at THE moment.","Sara has no money at the moment."]
[null,"mary likes BaNANas.","Mary likes bananas."]
[null,"i love my new PETs.","I love my new pets."]
[null,"HE liKes coFFee and tEa.","He likes coffee and tea."]
[null,"Our car broke down.","Our car broke down."]

{"sheet":"Flash Fill","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Flash Fill"]
[]
[null,"Given Case","In Lower Case","In Sentence Case"]
[null,"a picTUre is worth A ThouSand wORds.",{"$f":"LOWER(B5)","v":"a picture is worth a thousand words."},"A picture is worth a thousand words."]
[null,"BeTTer laTe than neveR.",{"$f":"LOWER(B6)","v":"better late than never."},"Better late than never."]
[null,"samanthA tOOk thE bus.","samantha took the bus.","Samantha took the bus."]
[null,"beGGars can’T be chOOsers.","beggars can’t be choosers.","Beggars can’t be choosers."]
[null,"i did not sEe tHem at the Bus station.","i did not see them at the bus station.","I did not see them at the bus station."]
[null,"Sara has NO monEY at THE moment.","sara has no money at the moment.","Sara has no money at the moment."]
[null,"mary likes BaNANas.","mary likes bananas.","Mary likes bananas."]
[null,"i love my new PETs.","i love my new pets.","I love my new pets."]
[null,"HE liKes coFFee and tEa.","he likes coffee and tea.","He likes coffee and tea."]
[null,"Our car broke down.","our car broke down.","Our car broke down."]

{"sheet":"VBA 1","index":5,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Applying VBA Code"]
[]
[null,"Given Case"]
[null,"A picture is worth a thousand words."]
[null,"Better late than never."]
[null,"Samantha took the bus."]
[null,"Beggars can’t be choosers."]
[null,"I did not see them at the bus station."]
[null,"Sara has no money at the moment."]
[null,"Mary likes bananas."]
[null,"I love my new pets."]
[null,"He likes coffee and tea."]
[null,"Our car broke down."]

{"sheet":"VBA 2","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Given Case","In Sentence Case"]
[null,"a picTUre is worth A ThouSand wORds",{"$f":"SentenceCase(B5)","v":"A picture is worth a thousand words"}]
[null,"BeTTer laTe than neveR",{"$f":"SentenceCase(B6)","v":"Better late than never"}]
[null,"samanthA tOOk thE bus.",{"$f":"SentenceCase(B7)","v":"Samantha took the bus."}]
[null,"beGGars can’T be chOOsers",{"$f":"SentenceCase(B8)","v":"Beggars can’t be choosers"}]
[null,"i did not sEe tHem at the Bus station.",{"$f":"SentenceCase(B9)","v":"I did not see them at the bus station."}]
[null,"Sara has NO monEY at THE moment.",{"$f":"SentenceCase(B10)","v":"Sara has no money at the moment."}]
[null,"mary likes BaNANas.",{"$f":"SentenceCase(B11)","v":"Mary likes bananas."}]
[null,"i love my new PETs.",{"$f":"SentenceCase(B12)","v":"I love my new pets."}]
[null,"HE liKes coFFee and tEa",{"$f":"SentenceCase(B13)","v":"He likes coffee and tea"}]
[null,"Our car broke down.",{"$f":"SentenceCase(B14)","v":"Our car broke down."}]