{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Chezy-összetett"],"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-összetett","index":0,"n_rows":25,"n_cols":20,"rows_kept":25,"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,"összetett trapéz szelvény (b1, b2, h1, h2, ρ1, ρ2, k1, k2, S)"]
[null,null,null,"(az adatok a Részletes feladatkiírás szerint értelmezendők. lsd. 10. oldal)"]
["Tervezés mértékadó vízhozamra:"]
["Qmért.=",34.69,"m3/s","vkh1=",2.5,"m/s","vkh2=",2.5,"m/s"]
["S=",2,"‰","k1=",50,"m⅓/s","k2=",50,"m⅓/s"]
[null,null,null,"ρ1=",0,null,"ρ2=",1.5]
[null,"b1 (m)","h1 (m)","b2 (m)","h2 (m)","A1 (m2)","P1 (m)","R1 (m)","v1 (m/s)","vkh1\nell.","A2 (m2)","P2 (m)","R2 (m)","v2 (m/s)","vkh2\nell.","Q1szám. (m3/s)","Q2szám. (m3/s)","Qszám. (m3/s)","Qmért.\nell."]
["1. változat",0.5,0.5,2,{"$f":"h2_Összetett_szelvény($B$9,$E$10,$H$10,$E$11,$H$11,$B$10,B13,D13,C13)","v":1.8899999856948853},{"$f":"B13*C13+$E$11*C13*C13+E13*(B13+2*$E$11*C13)","v":1.1949999928474426},{"$f":"B13+2*C13*SQRT(1+$E$11*$E$11)","v":1.5},{"$f":"F13/G13","v":0.79666666189829505},{"$f":"$E$10*POWER(H13,2/3)*SQRT($B$10/1000)","v":1.9216285002297271},{"$f":"IF($E$9>I13,\"OK\",\"NEM\")","v":"OK"},{"$f":"2*D13*E13+$H$11*E13*E13","v":12.918149861669541},{"$f":"2*(D13+E13*SQRT(1+$H$11*$H$11))","v":10.814491859049115},{"$f":"K13/L13","v":1.1945221310477174},{"$f":"$H$10*POWER(M13,2/3)*SQRT($B$10/1000)","v":2.5173743479623933},{"$f":"IF($H$9>N13,\"OK\",\"NEM\")","v":"NEM"},{"$f":"ROUND(I13*F13,2)","v":2.2999999999999998},{"$f":"ROUND(N13*K13,2)","v":32.520000000000003},{"$f":"P13+Q13","v":34.82},{"$f":"IF(R13>=$B$9,\"OK\",\"NEM\")","v":"OK"},{"$f":"IF(R13>$B$9*1.03,\"De túlméretezett!!! Csökkentse a b vagy h értékét.\",\"\")","v":""}]
["2. változat",0.8,0.5,1,{"$f":"h2_Összetett_szelvény($B$9,$E$10,$H$10,$E$11,$H$11,$B$10,B14,D14,C14)","v":2.2100000381469727},{"$f":"B14*C14+$E$11*C14*C14+E14*(B14+2*$E$11*C14)","v":2.1680000305175784},{"$f":"B14+2*C14*SQRT(1+$E$11*$E$11)","v":1.8},{"$f":"F14/G14","v":1.2044444613986547},{"$f":"$E$10*POWER(H14,2/3)*SQRT($B$10/1000)","v":2.5312955447997614},{"$f":"IF($E$9>I14,\"OK\",\"NEM\")","v":"NEM"},{"$f":"2*D14*E14+$H$11*E14*E14","v":11.746150329208376},{"$f":"2*(D14+E14*SQRT(1+$H$11*$H$11))","v":9.9682684563162809},{"$f":"K14/L14","v":1.1783541324838178},{"$f":"$H$10*POWER(M14,2/3)*SQRT($B$10/1000)","v":2.4946074881617943},{"$f":"IF($H$9>N14,\"OK\",\"NEM\")","v":"OK"},{"$f":"ROUND(I14*F14,2)","v":5.49},{"$f":"ROUND(N14*K14,2)","v":29.3},{"$f":"P14+Q14","v":34.79},{"$f":"IF(R14>=$B$9,\"OK\",\"NEM\")","v":"OK"},{"$f":"IF(R14>$B$9*1.03,\"De túlméretezett!!! Csökkentse a b vagy h értékét.\",\"\")","v":""}]
["3. változat",0.7,0.5,1.1000000000000001,{"$f":"h2_Összetett_szelvény($B$9,$E$10,$H$10,$E$11,$H$11,$B$10,B15,D15,C15)","v":2.2000000476837158},1.8900000333786009,1.7,1.1117647255168241,2.3997182948777498,"OK",12.100000419616702,10.132212977946859,1.1942110224047606,2.5169372354152166,"NEM",4.54,30.45,34.99,"OK",""]
["4. változat",0.6,0.5,1.2,2.1800000667572021,1.6080000400543213,1.6,1.0050000250339508,2.243515377144035,"OK",12.360600596809395,10.260102021208011,1.2047249209861242,2.531688477574082,"NEM",3.61,31.29,34.9,"OK",""]
[]
[]
["Ellenőrzés kisvízhozamra:"]
["KQ=",0.12,"m3/s","vmin=",0.5,"m/s"]
[null,"b1 (m)","h1KQ (m)","A (m2)","P (m)","R (m)","v (m/s)","vmin\nell.","Qszám.\n(m3/s)","KQ\nell."]
["1. változat",{"$f":"B13","v":0.5},{"$f":"h_Trapéz_szelvény($B$20,$E$10,$E$11,$B$10,B22)","v":0.37999999523162842},{"$f":"B22*C22+$E$11*C22*C22","v":0.18999999761581421},{"$f":"B22+2*C22*SQRT(1+$E$11*$E$11)","v":1.2599999904632568},{"$f":"D22/E22","v":0.15079365004277342},{"$f":"$E$10*POWER(F22,2/3)*SQRT($B$10/1000)","v":0.63349088627796857},{"$f":"IF($E$20<=G22,\"OK\",\"NEM\")","v":"OK"},{"$f":"ROUND(G22*D22,2)","v":0.12},{"$f":"IF(AND(I22>$B$20*0.9,I22<$B$20*1.1),\"OK\",\"NEM\")","v":"OK"},{"$f":"IF(C22>C13,\"   Figyelem! h1KQ nem lehet nagyobb mint h1\",\"\")","v":""}]
["2. változat",{"$f":"B14","v":0.8},{"$f":"h_Trapéz_szelvény($B$20,$E$10,$E$11,$B$10,B23)","v":0.23999999463558197},{"$f":"B23*C23+$E$11*C23*C23","v":0.1919999957084656},{"$f":"B23+2*C23*SQRT(1+$E$11*$E$11)","v":1.279999989271164},{"$f":"D23/E23","v":0.1499999979045242},{"$f":"$E$10*POWER(F23,2/3)*SQRT($B$10/1000)","v":0.63126615307720624},{"$f":"IF($E$20<=G23,\"OK\",\"NEM\")","v":"OK"},{"$f":"ROUND(G23*D23,2)","v":0.12},{"$f":"IF(AND(I23>$B$20*0.9,I23<$B$20*1.1),\"OK\",\"NEM\")","v":"OK"},{"$f":"IF(C23>C14,\"   Figyelem! h1KQ nem lehet nagyobb mint h1\",\"\")","v":""}]
["3. változat",0.7,0.27000001072883606,0.18900000751018523,1.2400000214576721,0.15241935825775857,0.63803585944640007,"OK",0.12,{"$f":"IF(AND(I24>$B$20*0.9,I24<$B$20*1.1),\"OK\",\"NEM\")","v":"OK"},""]
["4. változat",0.6,0.31999999284744263,0.19199999570846557,1.2399999856948853,0.1548387080027831,0.64476981057903915,"OK",0.12,{"$f":"IF(AND(I25>$B$20*0.9,I25<$B$20*1.1),\"OK\",\"NEM\")","v":"OK"},""]