{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Goal Seek","Worksheet Iteration","VBA Code"],"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":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":"Goal Seek","index":1,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,11,5,12],[5,13,5,14],[1,11,1,14],[3,11,3,12],[3,13,3,14],[4,11,4,12],[4,13,4,14],[1,1,1,4],[3,1,3,2],[4,1,4,2],[5,1,5,2],[3,3,3,4],[4,3,4,4],[5,3,5,4]]}
[]
[null,"Using Goal Seek Tool",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Pipe Roughness k (m)",null,5.0000000000000001E-4,null,null,null,null,null,null,null,"Pipe Roughness k (m)"]
[null,"Pipe Diameter D (m)",null,0.05,null,null,null,null,null,null,null,"Pipe Diameter D (m)"]
[null,"Reynolds Number Re",null,49900,null,null,null,null,null,null,null,"Reynolds Number Re"]
[]
[null,"Friction Factor f","LHS","RHS","RHS - LHS",null,null,null,null,null,null,"Friction Factor f","LHS","RHS","RHS - LHS"]
[null,3.9083929732372027E-2,{"$f":"1/SQRT(B9)","v":5.0582569637204715},{"$f":"-2*LOG((D4/(3.7*D5))+(2.51/(D6*SQRT(B9))))","v":5.0582573829650874},{"$f":"D9-C9","v":4.1924461591236195E-7}]

{"sheet":"Worksheet Iteration","index":2,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[1,11,1,14],[3,11,3,12],[3,13,3,14],[4,11,4,12],[4,13,4,14],[5,11,5,12],[5,13,5,14],[7,11,7,12],[7,13,7,14],[8,11,8,12],[8,13,8,14],[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,"Using Worksheet Iteration",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Pipe Roughness k (m)",null,5.0000000000000001E-4,null,null,null,null,null,null,null,"Pipe Roughness k (m)"]
[null,"Pipe Diameter D (m)",null,0.05,null,null,null,null,null,null,null,"Pipe Diameter D (m)"]
[null,"Reynolds Number Re",null,49900,null,null,null,null,null,null,null,"Reynolds Number Re"]
[]
[null,"Friction Factor f",null,{"$f":"1/(-2*LOG(D4/(D5*3.7) + 2.51/(D6*SQRT(D8+1E-300))))^2","v":3.9083923347897211E-2},null,null,null,null,null,null,null,"Friction Factor f"]
[null,"Answer",null,{"$f":"D8","v":3.9083923347897211E-2},null,null,null,null,null,null,null,"Answer"]

{"sheet":"VBA Code","index":3,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,4],[1,11,1,14],[3,11,3,12],[3,13,3,14],[4,11,4,12],[4,13,4,14],[5,11,5,12],[5,13,5,14],[1,1,1,4],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Pipe Roughness k (m)",null,5.0000000000000001E-4,null,null,null,null,null,null,null,"Pipe Roughness k (m)"]
[null,"Pipe Diameter D (m)",null,0.05,null,null,null,null,null,null,null,"Pipe Diameter D (m)"]
[null,"Reynolds Number Re",null,49900,null,null,null,null,null,null,null,"Reynolds Number Re"]
[]
[null,"Friction Factor f","LHS","RHS","RHS - LHS",null,null,null,null,null,null,"Friction Factor f","LHS","RHS","RHS - LHS"]
[null,3.9083887547477228E-2,{"$f":"1/SQRT(B9)","v":5.0582596935151987},{"$f":"-2*LOG((D4/(3.7*D5))+(2.51/(D6*SQRT(B9))))","v":5.0582573426334223},{"$f":"D9-C9","v":-2.3508817763584489E-6}]