{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["問題","実習","解答","解答（論理式IF シート計算）"],"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":"問題","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,1,1,9],[2,1,4,9]]}
[]
[null,"問題1.1 円管内の摩擦係数 [VBAのマクロ作成、If文：条件別の計算]"]
[null,"　水平で平滑な直径D=0.1 mの円管内を、密度が=998 kg m-3、粘度が=1.00 × 10-3 Pa sの流体が平均流速u=2 m s-1で流れている。この時、円管内の摩擦係数f [−]を求めなさい。"]

{"sheet":"実習","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["D 円管の直径",0.1,"m"]
["r 流体密度",998,"kg m-3"]
["u 流速",2,"m s-1"]
["m 流体粘度",1E-3,"Pa s"]
["Reレイノルズ数",null,"−"]
["f 摩擦係数",null,"−"]

{"sheet":"解答","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["D 円管の直径",0.1,"m"]
["r 流体密度",998,"kg m-3"]
["u 流速",2,"m s-1"]
["m 流体粘度",1E-3,"Pa s"]
["Reレイノルズ数",199600,"−"]
["f 摩擦係数",3.8605609339874601E-3,"−"]

{"sheet":"解答（論理式IF シート計算）","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["D 円管の直径",0.1,"m"]
["r 流体密度",998,"kg m-3"]
["u 流速",2,"m s-1"]
["m 流体粘度",1E-3,"Pa s"]
[]
[]
["Reレイノルズ数",{"$f":"B2*B1*B3/B4","v":199600.00000000003},"－"]
["f 摩擦係数(Re<2100)",{"$f":"16/B7","v":8.016032064128256E-5},"－"]
["f 摩擦係数 (3000<Re<100000)",{"$f":"0.0791*B7^-0.25","v":3.7422806089067446E-3},"－"]
["f 摩擦係数 (100000<Re<100000000)",{"$f":"0.0008+0.0552*B7^-0.237","v":3.8605609339874549E-3},"－"]
[]
["解答　f",{"$f":"IF(B7<2100,B8,IF(B7<3000,\"遷移域\",IF(B7<100000,B9,B10)))","v":3.8605609339874549E-3},"－"]