{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset 1","Removing Blank Rows","Changing to Uppercase","Table of Contents","Dataset 2","PivotTable and Pie Chart","Dataset 3","Solving Equation","Dataset 4","Word Count Function","Dataset 5","Identify Duplicates","Change Cell Color"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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 1","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Idioms"]
[]
[null,"Serial Number","Idioms "]
[null,1,"a blessing in disguise"]
[null,2,"better late than never"]
[null,3,"bite the bullet"]
[null,4,"break a leg"]
[null,5,"call it a day"]
[null,6,"cutting corners"]
[null,7,"get your act together"]
[null,8,"pull someone's leg"]
[null,9,"the best of both worlds"]
[null,10,"let someone off the hook"]

{"sheet":"Removing Blank Rows","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Blank Rows"]
[]
[null,"Serial Number","Idioms "]
[null,1,"a blessing in disguise"]
[null,2,"better late than never"]
[null,3,"bite the bullet"]
[null,4,"break a leg"]
[null,5,"call it a day"]
[null,6,"cutting corners"]
[null,7,"get your act together"]
[null,8,"pull someone's leg"]
[null,9,"the best of both worlds"]
[null,10,"let someone off the hook"]

{"sheet":"Changing to Uppercase","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Changing Text to Uppercase"]
[]
[null,"Serial Number","Idioms "]
[null,1,"A blessing in disguise"]
[null,2,"Better late than never"]
[null,3,"Bite the bullet"]
[null,4,"Break a leg"]
[null,5,"Call it a day"]
[null,6,"Cutting corners"]
[null,7,"Get your act together"]
[null,8,"Pull someone's leg"]
[null,9,"The best of both worlds"]
[null,10,"Let someone off the hook"]

{"sheet":"Table of Contents","index":3,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Making Table of Contents "]
[]
[null,"Table of Contents"]
[null,"Dataset 1"]
[null,"Selecting Blank Rows"]
[null,"Changing to Uppercase"]
[null,"Dataset 2"]
[null,"Pivot Tbl Cht"]
[null,"Dataset 3"]
[null,"Solving Equation"]
[null,"Dataset 4"]
[null,"Word Count Function"]
[null,"Dataset 5"]
[null,"Identify Duplicates"]
[null,"Change Cell Color"]

{"sheet":"Dataset 2","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales Data by Category"]
[]
[null,"Item","Category","Sales"]
[null,"Blender","Kitchen",500]
[null,"Oven","Kitchen",800]
[null,"Juicer","Kitchen",600]
[null,"Stationery","Office",200]
[null,"Paper","Office",100]
[null,"Laser Printer","Office",500]
[null,"PC","Office",900]
[null,"Playstation","Living Room",450]
[null,"TV","Living Room",1100]
[null,"AC","Living Room",1000]

{"sheet":"PivotTable and Pie Chart","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting PivotTable and Pie Chart"]
[]
[null,"Categories","Sum of Sales"]
[null,"Kitchen",1900]
[null,"Living Room",2550]
[null,"Office",1700]
[null,"Grand Total",6150]

{"sheet":"Dataset 3","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Variation of Reynolds Number with Pipe Roughness"]
[]
[null,"Pipe Roughness k (m)","Pipe Diameter D (m)","Reynolds Number Re"]
[null,2.9999999999999997E-4,0.05,30000]
[null,4.0000000000000002E-4,0.05,34000]
[null,5.0000000000000001E-4,0.05,49900]
[null,5.9999999999999995E-4,0.05,56000]
[null,6.9999999999999999E-4,0.05,67400]
[null,8.0000000000000004E-4,0.05,74900]
[null,8.9999999999999998E-4,0.05,80300]
[null,1E-3,0.05,100000]

{"sheet":"Solving Equation","index":7,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,4],[1,1,1,4],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4]]}
[]
[null,"Solving Colebrook Equation"]
[]
[null,"Pipe Roughness k (m)",null,5.0000000000000001E-4]
[null,"Pipe Diameter D (m)",null,0.05]
[null,"Reynolds Number Re",null,49900]
[]
[null,"Friction Factor f","LHS","RHS","RHS - LHS"]
[null,3.9075829535305445E-2,{"$f":"1/SQRT(B9)","v":5.0587812104935503},{"$f":"-2*LOG((D4/(3.7*D5))+(2.51/(D6*SQRT(B9))))","v":5.0582496374553578},{"$f":"D9-C9","v":-5.3157303819251212E-4}]

{"sheet":"Dataset 4","index":8,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Best Sellers"]
[]
[null,"Product ID","Books"]
[null,"B-001","The Black Swan"]
[null,"B-002","A Thousand Splendid Suns"]
[null,"B-003","The Kite Runner"]
[null,"B-004","Thinking, Fast & Slow"]
[null,"B-005","Never Split The Difference"]
[null,"B-006","Why Nations Fail"]
[null,"B-007","Sapiens"]
[null,"B-008","The Psychology of Money"]
[null,"B-009","Prisoner's of Geography"]

{"sheet":"Word Count Function","index":9,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Custom Function"]
[]
[null,"Product ID","Books","Word Count"]
[null,"B-001","The Black Swan",{"$f":"WordCount(C5)","v":3}]
[null,"B-002","A Thousand Splendid Suns",{"$f":"WordCount(C6)","v":4}]
[null,"B-003","The Kite Runner",{"$f":"WordCount(C7)","v":3}]
[null,"B-004","Thinking, Fast & Slow",{"$f":"WordCount(C8)","v":4}]
[null,"B-005","Never Split The Difference",{"$f":"WordCount(C9)","v":4}]
[null,"B-006","Why Nations Fail",{"$f":"WordCount(C10)","v":3}]
[null,"B-007","Sapiens",{"$f":"WordCount(C11)","v":1}]
[null,"B-008","The Psychology of Money",{"$f":"WordCount(C12)","v":4}]
[null,"B-009","Prisoner's of Geography",{"$f":"WordCount(C13)","v":3}]

{"sheet":"Dataset 5","index":10,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Project List"]
[]
[null,"Name","Project Name"]
[null,"Claire","Alpha"]
[null,"Owen","Gamma"]
[null,"Anna","Gamma"]
[null,"Harry","Alpha"]
[null,"Tyler","Beta"]
[null,"Will","Beta"]
[null,"Owen","Alpha"]
[null,"Julie","Gamma"]
[null,"Maisie","Beta"]
[null,"Anna","Alpha"]

{"sheet":"Identify Duplicates","index":11,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Identifying Duplicates"]
[]
[null,"Name","Project Name"]
[null,"Claire","Alpha"]
[null,"Owen","Gamma"]
[null,"Anna","Gamma"]
[null,"Harry","Alpha"]
[null,"Tyler","Beta"]
[null,"Will","Beta"]
[null,"Owen","Alpha"]
[null,"Julie","Gamma"]
[null,"Maisie","Beta"]
[null,"Anna","Alpha"]

{"sheet":"Change Cell Color","index":12,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Changing Cell Color"]
[]
[null,"Name","Project Name"]
[null,"Claire","Alpha"]
[null,"Owen","Gamma"]
[null,"Anna","Gamma"]
[null,"Harry","Alpha"]
[null,"Tyler","Beta"]
[null,"Will","Beta"]
[null,"Owen","Alpha"]
[null,"Julie","Gamma"]
[null,"Maisie","Beta"]
[null,"Anna","Alpha"]