{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Chezy-trapéz"],"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":"Chezy-trapéz","index":0,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Minta keresztszelvény tervezés és ellenőrzés (Chezy formula alkalmazásával)"]
[]
["A kék és sárga mezők szabadon felvehetők."]
["b értékét általában 10 cm-re kerek értékre vegyék fel, h értéke automatikusan számítódik 1 cm pontosan"]
[]
["Keresztszelvény alakja:",null,null,"trapéz szelvény (b, h, ρ, k, S)"]
[]
["Tervezés mértékadó vízhozamra:"]
["Qmért.=",36.979999999999997,"m3/s","vkh=",2.5,"m/s"]
["k=",55,"m⅓/s"]
["ρ=",1.5]
["S=",1.2,"‰"]
[null,"b (m)","h (m)","A (m2)","P (m)","R (m)","v (m/s)","vkh\nell.","Qszám.\n(m3/s)","Qmért.\nell."]
["1. változat",1.6,{"$f":"h_Trapéz_szelvény($B$9,$B$10,$B$11,$B$12,B14)","v":2.7599999904632568},{"$f":"A_Trapéz_szelvény(B14,C14,$B$11)","v":15.842399597167969},{"$f":"P_Trapéz_szelvény(B14,C14,$B$11)","v":11.551321029663086},{"$f":"D14/E14","v":1.3714794659836442},{"$f":"v_Trapéz_szelvény(B14,C14,$B$11,$B$10,$B$12)","v":2.3518674373626709},{"$f":"IF($E$9>G14,\"OK\",\"NEM\")","v":"OK"},{"$f":"ROUND(G14*D14,2)","v":37.26},{"$f":"IF(I14>=$B$9,\"OK\",\"NEM\")","v":"OK"}]
["2. változat",2.6,{"$f":"h_Trapéz_szelvény($B$9,$B$10,$B$11,$B$12,B15)","v":2.5},{"$f":"A_Trapéz_szelvény(B15,C15,$B$11)","v":15.875},{"$f":"P_Trapéz_szelvény(B15,C15,$B$11)","v":11.61387825012207},{"$f":"D15/E15","v":1.366899123454574},2.3466281890869141,{"$f":"IF($E$9>G15,\"OK\",\"NEM\")","v":"OK"},{"$f":"ROUND(G15*D15,2)","v":37.25},{"$f":"IF(I15>=$B$9,\"OK\",\"NEM\")","v":"OK"}]
["3. változat",2.7,2.4700000286102295,15.820350646972656,11.605711936950684,{"$f":"D16/E16","v":1.3631521041465156},{"$f":"v_Trapéz_szelvény(B16,C16,$B$11,$B$10,$B$12)","v":2.3423378467559814},{"$f":"IF($E$9>G16,\"OK\",\"NEM\")","v":"OK"},{"$f":"ROUND(G16*D16,2)","v":37.06},"OK"]
["4. változat",2.8,2.4500000476837158,15.863750457763672,11.633601188659668,{"$f":"D17/E17","v":1.3636147741790836},{"$f":"v_Trapéz_szelvény(B17,C17,$B$11,$B$10,$B$12)","v":2.3428678512573242},{"$f":"IF($E$9>G17,\"OK\",\"NEM\")","v":"OK"},{"$f":"ROUND(G17*D17,2)","v":37.17},"OK"]
[null,"b/h értéke lehetőség szerint körülbelül 1 legyen (hidraulikailag legyen kedvező a meder alak)"]
[]
["Ellenőrzés kisvízhozamra:"]
["KQ=",0.14000000000000001,"m3/s","vmin=",0.5,"m/s"]
[null,"b (m)","hKQ (m)","A (m2)","P (m)","R (m)","v (m/s)","vmin\nell.","Qszám.\n(m3/s)","KQ\nell."]
["1. változat",{"$f":"B14","v":1.6},{"$f":"h_Trapéz_szelvény($B$21,$B$10,$B$11,$B$12,B23)","v":0.15999999642372131},{"$f":"A_Trapéz_szelvény(B23,C23,$B$11)","v":0.29440000653266907},{"$f":"P_Trapéz_szelvény(B23,C23,$B$11)","v":2.1768882274627686},{"$f":"D23/E23","v":0.13523891710131644},{"$f":"v_Trapéz_szelvény(B23,C23,$B$11,$B$10,$B$12)","v":0.50198155641555786},{"$f":"IF($E$21<=G23,\"OK\",\"NEM\")","v":"OK"},{"$f":"ROUND(G23*D23,2)","v":0.15},{"$f":"IF(I23>=$B$21,\"OK\",\"NEM\")","v":"OK"}]
["2. változat",{"$f":"B15","v":2.6},{"$f":"h_Trapéz_szelvény($B$21,$B$10,$B$11,$B$12,B24)","v":0.11999999731779099},{"$f":"A_Trapéz_szelvény(B24,C24,$B$11)","v":0.33359998464584351},{"$f":"P_Trapéz_szelvény(B24,C24,$B$11)","v":3.0326662063598633},{"$f":"D24/E24","v":0.11000220991886429},{"$f":"v_Trapéz_szelvény(B24,C24,$B$11,$B$10,$B$12)","v":0.43740889430046082},{"$f":"IF($E$21<=G24,\"OK\",\"NEM\")","v":"NEM"},{"$f":"ROUND(G24*D24,2)","v":0.15},{"$f":"IF(I24>=$B$21,\"OK\",\"NEM\")","v":"OK"}]
["3. változat",{"$f":"B16","v":2.7},{"$f":"h_Trapéz_szelvény($B$21,$B$10,$B$11,$B$12,B25)","v":0.11999999731779099},{"$f":"A_Trapéz_szelvény(B25,C25,$B$11)","v":0.34559997916221619},3.1326661109924316,{"$f":"D25/E25","v":0.11032135788410907},0.43825450539588928,"NEM",0.15,"OK"]
["4. változat",{"$f":"B17","v":2.8},{"$f":"h_Trapéz_szelvény($B$21,$B$10,$B$11,$B$12,B26)","v":0.11999999731779099},0.35760000348091125,3.2326662540435791,{"$f":"D26/E26","v":0.11062076174229475},0.43904706835746765,"NEM",0.16,"OK"]