{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Kalkulator","Kotwienie","Beton i stal","Robol","Arkusz1"],"not_rendered":{"charts":0,"images":25,"macros":1,"external_links":0,"defined_names":727,"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":"Kalkulator","index":0,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,8,1,10],[7,1,7,2],[39,2,39,6]]}
[null,null,null,null,null,null,null,null,null,null,null,"Instrukcja , uwagi i ostrzeżenia:"]
[null,"Projekt","Przykład 1.2a",null,null,null,null,null,"Projektant"]
[null,"Klient","Konstruktor żelbetu",null,null,null,null,null,"Opracował","Data","Strona"]
[null,"Lokalizacja","http://chodor-projekt.net/encyclopedia/belki-zelbetowe/",null,null,null,null,null,"LCH",{"$f":"TODAY()","v":"2019-01-01"},25]
[null,"Uwagi","Zginanie jedoosoiwe bez ściskania",null,null,null,null,null,"Sprawdził","Rewizja","Zlecenie"]
[null,"Notatka","Wpisz notatkę",null,null,null,null,null,"MK","-","ChP-1"]
[]
[null,"Nośność",null,"ΛR",{"$f":"IF(M_Ry=0,0,(M_y/M_Ry))^α_y+IF(M_Rz=0,0,(M_z/M_Rz))^α_z","v":1.0002397939017742},"wzór (87)*)"]
[null,"współrzędne nośności",null,"MRy",{"$f":"M_Ry","v":172.85854957394264},"kNm"]
[null,"(+siła osiowa Nx niżej)",null,"MRz",{"$f":"M_Rz","v":0},"kNm"]
[null,"strefa ściskana betonu",null,"xY",{"$f":"Robol!x_Ry","v":112.66731517278032},"mm"]
[null,null,null,"xZ",{"$f":"Robol!x_Rz","v":0},"mm"]
[null,"  Wynik sprawdzenia:"]
[null,"  Zginanie Y",{"$f":"IF(OR(R_y>0.01,R_y<-0.01),\"BŁĄD\", \"OK\")","v":"OK"},{"$f":"IF(R_y>0.01,\" Brak równowagi !!! :  naciśnij [sprawdż]  i dalej zwiększ stal, beton lub przekrój \", \"Zbilansowano  przekrój\")","v":"Zbilansowano  przekrój"}]
[null,"  Zginanie Z",{"$f":"IF(OR(R_z>0.01,R_z<-0.01),\"BŁĄD\", \"OK\")","v":"OK"},{"$f":"IF(R_z>0.01,\"Brak równowagi !!! :  naciśnij [sprawdż]-  jeśli dalej,to  zwiększ stal, beton lub przekrój \", \" Zbilansowano  przekrój\")","v":" Zbilansowano  przekrój"}]
[null,null,null,"  Po zbilansowaniu przekroju w kierunku Y i Z - patrz instrukcja obok",null,null,null,null,null,null,null," Wprowadzaj dane tylko do  niebieskich komórek"]
[null,null,null,null,null,null,null,null,null,null,null," Czerwone komunikaty  niżej wskazują na błędy danych."]
[null,"SIŁY PRZEKROJOWE",null,null,null,null,null,null,null,null,null," Pomarańczowe komunikaty są uwagami"]
[null,"względem osi głównych (y-y), (z-z) ",null,null,null,null,null,null,null,null,null,"Wymóg  minimalnego stopnia zbrojenia:"]
[null,"My - dodatni rozciąga włókna dolne ",null,null,"My",172.9,"kNm",null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Belka\",A_suy < A_sminBy),\"Belka: zbrojenie górne mniejsze od minimalnego Amin= \"& ROUND(A_sminBy,1)&\" mm2\",\"-\")","v":"-"}]
[null,"Mz - (dodatni rozciąga włókna prawe",null,null,"Mz",0,"kNm",null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Belka\",A_sly < A_sminBy),\"Belka: zbrojenie dolne mniejsze od minimalnego Amin= \"& ROUND(A_sminBy,1)&\" mm2\",\"-\")","v":"-"}]
[null," Nx- siła osiowa (dodatnia ściskająca). ",null,null,"Nx",0,"kN",null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Belka\",A_suz< A_sminBz),\"Belka: zbrojenie lewe mniejsze od minimalnego Amin= \"& ROUND(A_sminBz,1)&\" mm2\",\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Belka\",A_slz < A_sminBz),\"Belka: zbrojenie prawe mniejsze od minimalnego Amin= \"& ROUND(A_sminBz,1)&\" mm2\",\"-\")","v":"-"}]
[null,"BETON  I STAL",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Płyta\",A_suy< A_sminPy),\"Płyta: zbrojenie górne  mniejsze od minimalnego Amin= \"& ROUND(A_sminPy,1)&\" mm2\",\"-\")","v":"-"}]
[null,null,"Element",null,null,"  ",null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Płyta\",A_sly< A_sminPy),\"Płyta: zbrojenie dolne mniejsze od minimalnego Amin= \"& ROUND(A_sminPy,1)&\" mm2\",\"-\")","v":"-"}]
[null,"Wsp. γc",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Słup\",A_suy  < A_sminS),\"Słup: Zbrojenie górne mniejsze od minimalnego Amin= \"& ROUND(A_sminS,1)&\" mm2\",\"-\")","v":"-"}]
[null,1.5,"Beton",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Słup\",A_sly  < A_sminS),\"Słup: Zbrojenie dolne mniejsze od minimalnego Amin= \"& ROUND(A_sminS,1)&\" mm2\",\"-\")","v":"-"}]
[null,null,"Stal",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Słup\",A_suz  < A_sminS),\"Słup: Zbrojenie lewe mniejsze od minimalnego Amin= \"& ROUND(A_sminS,1)&\" mm2\",\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Ściana\",A_sly < A_sminŚ),\"Ściana: zbrojenie strony <góra > mniejsze od minimalnego Amin= \"& ROUND(A_sminŚ,1)&\" mm2\",\"-\")","v":"-"}]
[null,"PRZEKRÓJ",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Ściana\",A_slz < A_sminŚ),\"Ściana: zbrojenie strony <dół> mniejsze od minimalnego Amin= \"& ROUND(A_sminP,1)&\" mm2\",\"-\")","v":"-"}]
[null,"h",450,"mm","górne cuy",34,"mm",null,null,null,null,"Wymóg  maksymalnego stopnia zbrojenia:"]
[null,"b",300,"mm","dolne cly",31,"mm",null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Belka\",A_sly > A_smaxB),\"Belka: zbrojenie dolne większe  od maksymalnego poza zakładami Amax= \"& ROUND(A_smaxB,1)&\" mm2\",\"-\")","v":"-"}]
[null,null,null,null,"lewe cuz",31,"mm",null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Płyta\",A_sly > A_smaxP),\"Płyta: zbrojenie dolne większe  od maksymalnego poza zakładami Amax= \"& ROUND(A_smaxP,1)&\" mm2\",\"-\")","v":"-"}]
[null,null,null,null,"prawe clz",31,"mm",null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Słup\",(A_sly+A_suy) > A_smaxS),\"Słup: zbrojenie łączne większe  od maksymalnego Amax= \"& ROUND(A_smaxS,1)&\" mm2\",\"-\")","v":"-"}]
[null,null,null," ",null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"Ściana\",A_sly > A_smaxŚ),\"Ściana: zbrojenie dolne większe  od maksymalnego poza zakładami Amax= \"& ROUND(A_smaxŚ,1)&\" mm2\",\"-\")","v":"-"}]
[null,"ZBROJENIE",null,null,null," ",null,null,null,null,null," Wymogi konstrukcyjne (beton, stal, otulenie):"]
[null,null,"Pręt Ø","Liczba","Pole","% zbrojenia","co (odstęp)",null,null,null,null,{"$f":"IF(OR(f_ck>99,f_ck<20),\"Beton niekonstrukcyjny fck<25\",\"-\")","v":"-"}]
[null,"górne  Øuy",12,2,{"$f":"PI()/4*Fi_uy^2*n_uy","v":226.1946710584651},{"$f":"A_suy/h/b","v":1.6755160819145565E-3},{"$f":"IF(n_uy>0,(b-c_uz-c_lz-n_uy*Fi_uy)/(n_uy-1),\" \")","v":214},null,null,null,null,{"$f":"IF(c_uz >65,\"Sprawdż otulenie górne z warunku klasy ekspozycji\",\"-\")","v":"-"}]
[null,"dolne Øly",18,5,{"$f":"PI()/4*Fi_ly^2*n_ly","v":1272.3450247038661},{"$f":"E39/C$31/C$32","v":9.4247779607693778E-3},{"$f":"IF(n_ly>0,(b-c_uz-c_lz-n_ly*Fi_ly)/(n_ly-1),\" \")","v":37},null,null,null,null,{"$f":"IF(c_uy >65,\"Sprawdż otulenie górne z warunku klasy ekspozycji\",\"-\")","v":"-"}]
[null,null," wypełnienie pomiędzy prętami narożnymi",null,null,null,null,null,null,null,null,{"$f":"IF(c_ly >65,\"Sprawdż otulenie górne z warunku klasy ekspozycji\",\"-\")","v":"-"}]
[null,"lewe Øuz",18,0,{"$f":"PI()/4*(Fi_uz^2*n_uz+IF(n_uy>0,Fi_uy^2,0)+   IF(n_ly>0,Fi_ly^2,0))","v":367.5663404700058},{"$f":"E41/C$31/C$32","v":2.7227136331111541E-3},{"$f":"IF(n_uz>0,(h-c_uy-c_ly-IF(n_uy>0,Fi_uy,0)-IF(n_uz>0,Fi_ly,0)-Fi_uz*n_uz)/(n_uz+1),\" \")","v":" "},null,null,null,null,{"$f":"IF(OR(s_ly<Fi_ly,s_ly<20),\"Za mały prześwit między oprętami  >ly<.\",\"-\")","v":"-"}]
[null,"prawe Ølz",18,0,{"$f":"PI()/4*(Fi_lz^2*n_lz+IF(n_uy>0,Fi_uy^2,0)+   IF(n_ly>0,Fi_ly^2,0))","v":367.5663404700058},{"$f":"E42/C$31/C$32","v":2.7227136331111541E-3},{"$f":"IF(n_lz>0,(h-c_uy-c_ly-IF(n_uy>0,Fi_uy,0)-IF(n_ly>0,Fi_ly,0)-Fi_lz*n_lz)/(n_lz+1),\" \")","v":" "},null,null,null,null,{"$f":"IF(OR(s_ly<Fi_uy,s_ly<20),\"Za mały prześwit między oprętami  >uy<.\",\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(s_lz<Fi_lz,s_lz<20),\"Za mały prześwit między oprętami  >lz<.\",\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(s_uz<Fi_uz,s_uz<20),\"Za mały prześwit między oprętami  >uz<.\",\"-\")","v":"-"}]
[null,"  *) Powołania na wzory w arkuszu  i teoria do kalkulatora wg artykułu   www. http://chodor-projekt.net/encyclopedia/belki-zelbetowe",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(s_uy < 50,\"Maksymalna średnica kruszywa \"&  ROUND(s_uy-5,1) & \" mm\",\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(s_ly < 50,\"Maksymalna średnica kruszywa \"&  ROUND(s_ly-5,1) & \" mm\",\"-\")","v":"Maksymalna średnica kruszywa 32 mm"}]
[]
[null,"     Arkusz  CHP Ż - w.1.3.xls | © 2018 Leszek Chodor, Chodor-Projekt , sp. z o.o."]

{"sheet":"Kotwienie","index":1,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,7,0,9],[6,1,6,2]]}
["Projekt","Wpisz nazwę projektu",null,null,null,null,null,"Wpisz Projektanta",null,null,"Dla Projektanta:"]
["Klient","Wpisz klienta",null,null,null,0,null,"Opracował","Data","Strona"," Wprowadzaj dane tylko do  niebieskich komórek"]
["Lokalizacja","Wpisz lokalizację inwestycji",null,null,null,null,null,"LCH",{"$f":"TODAY()","v":"2019-01-01"},25]
["Uwagi","Wpisz uwagi",null,null,null,null,null,"Sprawdził","Rewizja","Zlecenie"]
["Notatka","Wpisz notatkę",null,null,null,null,null,"MK","-","ChP-1"]
[]
[null,"Wyniki"]
[null,null,"Długość zakotwienia","lbd",{"$f":"L_brqd*α1*α2*α3*α4*α5/Fi_zaklad","v":23.08779153326957},"Ф"]
[null,null,"minimalna","lbd,min",{"$f":"MAX(0.3*L_brqd,10*Fi_zaklad,100)/Fi_zaklad","v":11.306201921089754},"Ф"]
[null,null,"Długość zakładu","l0",{"$f":"α6*l_bd","v":32.651067911592541},"Ф"]
[null,null,"minimalna","lo,min",{"$f":"MAX(0.3*L_brqd*α6,15*Fi_zaklad, 200)/Fi_zaklad","v":15.989384095733872},"Ф"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"słup\",A_suy  < A_sminS),\"Słup: Zbrojenie górne mniejsze od minimalnego Amin= \"& ROUND(A_sminS,1)&\" mm2\",\"-\")","v":"-"}]
[null,"Dane z Kalkulatora",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Smb_Elem=\"słup\",A_sly  < A_sminS),\"Słup: Zbrojenie dolne mniejsze od minimalnego Amin= \"& ROUND(A_sminS,1)&\" mm2\",\"-\")","v":"-"}]
[null,null,null,"beton",{"$f":"SmbBeton","v":"C25/30"},null,null,null,null,null,"Strefa dobrej przyczepności wystąpi gdy: "]
[null,null,null,"stal",{"$f":"SmbStal","v":"18G2A"},null,null,null,null,null,"* pręty są nachylone pod kątem 45-90o"]
[null,null,null,"element",{"$f":"Smb_Elem","v":"Belka "},null,null,null,null,null,"* w elemencie  h < 250 mm"]
[null,null,"naprężenia z Kalkulatora ","σsly",{"$f":"Robol!G102","v":309.56521739130437},"MPa",null,null,null,null,"* w pasie 250 mm od  powierzchni dolne elemnt o grubości h> 250 mmj "]
[null,null,"jeśli znasz wpisz lub przepisz  σsly","σsd",435,"MPa",null,null,null,null," * w pasie 300 mm od wierzchu  elementu  o grubosci h> 600 mm"]
[null,null,"Średnica pręta "]
[null,null,"dolne zbrojenie z kalkulatora","фly",{"$f":"Fi_ly","v":18},null,null,null,null,null," Rodzaje zakotwień"]
[null,null,"jeśli znasz wpisz lub przepisz  σsly","ф",16]
[]
[null,"Dane dodatkowe"]
[null,null,"sposób wytężenia"]
[null,null,"kształt prętów",null,"    "]
[null,null,"rodzaj zakotwienia",null,null,null,null,null,null,null,"Sposób przyspojenia "]
[null,null,"warunki przyczepności "]
[null,null,"przyspojono pręty ?"]
[null,null,"jeśli przypojono, to sposób"]
[null,null,"otulenie dolne ","c",25,"mm"]
[null,null,"otulenie boczne     ","c1",25,"mm"]
[null,null,"rozstaw prętów ","a",60,"mm"]
[null,null," nacisk poprzeczny ","p",0,"MPa"]
[]
[null,null,"udział prętów uciąglanych","As",50," % zbrojenia w uciąglanego pasie 1,3 l0 "]
[null,null,"zbrojenie  ⊥ wzdłuż lb","ΣAst",2.5099999999999998,"cm2"]
[null,null,null,null,"Podpowiedż:","ΣAst =[ 25%  ф co 200 mm]= ",null,{"$f":"PI()*(Fi_zaklad/10)^2/4*1000/200*0.25","v":2.5132741228718349},"cm2]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Arkusz  CHP Ż02 Belka, v.1.0.xls | © 2018 Leszek Chodor, Chodor-Projekt , sp. z o.o."]

{"sheet":"Beton i stal","index":2,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,3,39,10],[24,0,27,0],[24,2,27,2],[28,0,34,0],[28,2,30,2],[31,2,34,2],[35,0,38,0],[20,0,20,10],[20,12,20,21],[21,0,23,0],[21,1,21,2],[21,3,22,3],[21,4,21,5],[22,1,23,1],[22,2,23,2],[18,0,18,21],[0,0,0,21],[2,0,11,0],[2,10,2,13],[2,15,2,16],[12,0,17,0]]}
["Tabela betonów"]
["Beton","Symbol","fck","fcd","η","λ","fcm","fctm","Ecm","n","εc1","εcu1","εc2","εcu2","ξu","εc3","εcu3","k1 ,k3","k2=k4","ξuS1)","ϕ0 2)","ρmin,b1)"]
["zwykły  BZ","(-)","MPa","MPa","(-)","(-)","MPa","MPa","GPa","(-)","‰",null,null,null,null,"‰",null,"(-)","(-)","(-)","(-)","%"]
[null,"C12/15",12,{"$f":"C4/1.4","v":8.5714285714285712},1,0.8,{"$f":"C4+8","v":20},{"$f":"0.3*C4^(2/3)","v":1.5724448365253381},{"$f":"22*(0.1*G4)^0.3","v":27.085177093588158},2,{"$f":"0.7*G4^0.31","v":1.7718107758850909},3.5,2,3.5,{"$f":"(T4+0.208)/2","v":0.41242911877394633},1.75,3.5,0.44,{"$f":"1.25*(0.6+1.4/3.5)","v":1.25},{"$f":"1/(1+500/1.15/(200*N4))","v":0.61685823754789271},3.3,0.13]
[null,"C16/20",{"$f":"VALUE(MID(B5,2,2))","v":16},{"$f":"C5/1.4","v":11.428571428571429},1,0.8,24,1.9048812623618392,{"$f":"22*(0.1*G5)^0.3","v":28.607904894961404},2,1.8748370396696974,3.5,2,3.5,{"$f":"(T5+0.208)/2","v":0.41242911877394633},1.75,3.5,0.44,{"$f":"1.25*(0.6+1.4/3.5)","v":1.25},{"$f":"1/(1+500/1.15/(200*N5))","v":0.61685823754789271},3,0.13]
[null,"C20/25",{"$f":"VALUE(MID(B6,2,2))","v":20},14.285714285714286,1,0.8,28,2.2104188991842313,{"$f":"22*(0.1*G6)^0.3","v":29.961951054640309},2,1.9666045051940388,3.5,2,3.5,0.41242911877394633,1.75,3.5,0.44,1.25,0.61685823754789271,2.7777777777777777,0.13]
[null,"C25/30",25,17.857142857142858,1,0.8,33,2.5649639200150443,{"$f":"22*(0.1*G7)^0.3","v":31.475806210019346},2,2.0693662482105193,3.5,2,3.5,0.41242911877394633,1.75,3.5,0.44,1.25,0.61685823754789271,2.5555555555555554,{"$f":"0.26*H7/500*100","v":0.13337812384078232}]
[null,"C30/37",30,21.428571428571431,1,0.8,38,2.896468153816889,{"$f":"22*(0.1*G8)^0.3","v":32.836568031330792},2,2.1618768697354804,3.5,2,3.5,0.41242911877394633,1.75,3.5,0.44,1.25,0.61685823754789271,2.2777777777777781,0.15061634399847823]
[null,"C35/45",35,25,1,0.8,43,3.2099624416952368,34.077146199189329,2,2.2463284691964671,3.5,2,3.5,0.41242911877394633,1.75,3.5,0.44,1.25,0.61685823754789271,2.0222222222222221,0.16691804696815232]
[null,"C40/50",40,28.571428571428573,1,0.8,48,3.5088212858554391,35.220462288934414,2,2.3242499142093389,3.5,2,3.5,0.41242911877394633,1.75,3.5,0.44,1.25,0.61685823754789271,1.822222222222222,0.18245870686448284]
[null,"C45/55",45,32.142857142857146,1,0.8,53,3.7954469938578708,36.283188218914134,2,2.3967545449312704,3.5,2,3.5,0.41242911877394633,1.75,3.5,0.44,1.25,0.61685823754789271,1.6555555555555557,0.19736324368060928]
[null,"C50/60",50,35.714285714285715,1,0.8,58,4.0716264248923588,37.277869091614662,2,2.4646810048680772,3.5,2,3.5,0.41242911877394633,1.75,3.5,0.44,1.25,0.61685823754789271,1.5,0.21172457409440265]
["wysokiej wytrzymałości  BWW","C55/67",55,39.285714285714285,0.98,0.75,63,{"$f":"2.12*LN(1+0.1*(C13+8))","v":4.214293618087213},38.214206461639002,{"$f":"1.4+23.4*(0.01*(90-C13))^4","v":1.7511462500000001},2.5286784670814431,{"$f":"2.8+27*(0.01*(98-G13))^4","v":3.2051687499999999},{"$f":"2+0.085*(C13-50)^0.53","v":2.1994679057750481},{"$f":"2.6+35*(0.01*(90-C13))^4","v":3.1252187500000002},{"$f":"(T13+0.16)/2","v":0.37488026263531171},{"$f":"1.75+0.01375*(C13-50)","v":1.8187500000000001},{"$f":"2.6+35*(0.01*(90-C13))^4","v":3.1252187500000002},0.54,{"$f":"1.25*(0.6+1.4/N13)","v":1.3099608027438079},0.58976052527062339,null,0.21914326814053506]
[null,"C60/75",60,42.857142857142861,0.95,0.78,68,4.3547423154345584,39.099873708049074,1.58954,2.5892608390866876,3.0186999999999999,2.2880175327183223,2.8835000000000002,0.36507657721553816,1.8875,2.8835000000000002,0.54,1.3569013351829373,0.57015315443107628,null,0.22644660040259701]
[null,"C70/85",70,50,0.9,0.75,78,4.6104736495464218,40.742817784548983,1.4374399999999998,2.7017637279883995,2.8431999999999999,2.4158769243143414,2.6560000000000001,0.35495319026357486,2.0249999999999999,2.6560000000000001,0.54,1.4088855421686746,0.54990638052714969,null,0.23974462977641395]
[null,"C80/95",80,57.142857142857146,0.9,0.75,88,4.8386506576342363,42.244238168935823,1.4023399999999999,2.8047080976469241,2.8026999999999997,2.5155765911087431,2.6034999999999999,0.35248010338504104,2.1625000000000001,2.6034999999999999,0.54,1.4221720760514691,0.54496020677008206,null,0.2516098341969803]
[null,"C90/105",{"$f":"VALUE(MID(B17,2,2))","v":90},64.285714285714292,0.9,0.75,98,5.0446378043559692,43.630531500658059,1.4,2.8998672916610371,2.8,2.6004968327615767,2.6,0.35231329690346086,2.2999999999999998,2.6,0.54,1.4230769230769229,0.54462659380692169,null,0.26232116582651044]
[null,"C100/115",{"$f":"VALUE(MID(B18,2,3))","v":100},71.428571428571431,0.9,0.75,108,5.2323710067198332,44.921040526673679,1.4023399999999999,2.9885422791692191,2.8026999999999997,2.6758853420920015,2.6034999999999999,0.35248010338504104,2.4375,2.6034999999999999,0.54,1.4221720760514691,0.54496020677008206,null,0.27208329234943129]
[" 1)  σcu2=Ecm · εcu2  ,  dla stali B500 (fyd=500/1.15)   |  2) Współczynnik pełzania dla wilgotności RH=50% ,  t0=28 dni, h0=250 mm"]
[]
["Tabela stali",null,null,null,null,null,null,null,null,null,null,null,"Współczynnik interakcji My-Mz"]
["Stal","Oznaczenie stali",null,"Zakres średnic","Granica plast.",null,"Wytrz.","k","εyd","εuk","Epl"]
[null,"gatunek","w projekcie",null,"fyk","fyd","fuk","(ft/fy)k","fyd/Es ",null,"2)"]
[null,null,null,"mm","MPa","MPa","MPa","(-)","‰","%","GPa"]
["A","BSt 500KR","B500-A","6-12",500,{"$f":"E25/1.15","v":434.78260869565219},550,{"$f":"G25/E25","v":1.1000000000000001},{"$f":"F25/E_s","v":2.1739130434782608},2.5,{"$f":"(H25-1)/(J25*10/E25-1/E_s)","v":2.2222222222222241}]
[null,"RB500",null,"4-16",500,434.78260869565219,550,1.1000000000000001,2.1739130434782608,2.5,2.2222222222222241]
[null,"RB 500W",null,"6-40",500,434.78260869565219,550,1.1000000000000001,2.1739130434782608,2.5,2.2222222222222241]
[null,"BSt 500S",null,"6-14",500,434.78260869565219,550,1.1000000000000001,2.1739130434782608,2.5,2.2222222222222241]
["B","RB400","B400-B","6-40",400,347.82608695652175,550,1.375,1.7391304347826086,5,3.125]
[null,"RB400W",null,"6-40",400,347.82608695652175,440,1.1000000000000001,1.7391304347826086,5,0.83333333333333415]
[null,"34GS",null,"6-32",410,356.52173913043481,440,1.0731707317073171,1.7826086956521741,5,0.62565172054223206]
[null,"RB500","B500-B","6-40",500,434.78260869565219,550,1.1000000000000001,2.1739130434782608,5,1.0526315789473693]
[null,"RB 500Wz",null,"8-32",500,434.78260869565219,550,1.1000000000000001,2.1739130434782608,5,1.0526315789473693]
[null,"BST 500S",null,"8-32",500,434.78260869565219,550,1.1000000000000001,2.1739130434782608,5,1.0526315789473693]
[null,"BSt 500WR",null,"8-32",500,434.78260869565219,550,1.1000000000000001,2.1739130434782608,5,1.0526315789473693]
["C","18G2A","B355-C","10-32",356,309.56521739130437,480,1.348314606741573,{"$f":"F36/E_s","v":1.5478260869565219},7.5,{"$f":"(H36-1)/(J36*10/E36-1/E_s)","v":1.6935263589183283}]
[null,"35G2Y","B400-C","6-20",410,356.52173913043481,550,1.3414634146341464,1.7826086956521741,7.5,1.9191226867717621]
[null,"20G2VYb","B490-C","6-28",490,426.08695652173918,590,1.2040816326530612,2.1304347826086958,7.5,1.3783597518952446]
[null,"B500SP","B500-C","8-40",500,434.78260869565219,575,1.1499999999999999,2.1739130434782608,7.5,1.0344827586206891]
["1) Es=",200,"GPa","                2) Epl=(k-1)/(εuk/fyk-1/Es)"]

{"sheet":"Robol","index":3,"n_rows":134,"n_cols":15,"rows_kept":134,"cut":false,"hidden":false,"merged":[[88,1,88,8],[50,3,50,4],[49,3,49,4],[53,1,53,8],[62,1,62,8],[46,5,46,6],[50,5,50,6],[51,5,51,6],[46,8,46,9],[37,12,37,13],[44,12,44,13],[0,11,0,14],[0,1,0,8],[30,1,30,8],[31,1,31,2],[31,3,31,4],[31,7,31,8],[1,12,1,13],[17,12,17,13],[27,12,27,13]]}
[null,"OBLICZENIA kalkulatora zbrojenia podłużnego",null,null,null,null,null,null,null,null,null,"Zakotwienie i zakłady"]
[null,"rozdział Nx","nNy",{"$f":"n_Ny","v":1},null,null,null,null,null,null,null,null,"Opcje wyboru"]
[null,null,"nNz",{"$f":"n_Nz","v":0},null,"xRy",112.66731517278032,"xRy/h",{"$f":"x_Ry/h","v":0.25037181149506738},null,null,null,"wytężenie","rozciąganie"]
[null,null,"Ny",{"$f":"N_x*n_Ny","v":0},null,"xRz",0,"xRz/b",{"$f":"x_Rz/b","v":0},null,null,null,"rozciąganie","ściskanie"]
[null,null,"Nz",{"$f":"N_x*n_Nz","v":0},null,null,null,null,null,null,null,null,"kształt pręta","proste"]
[null,null,"ny=Ny/NRy",{"$f":"N_y/N_Ry","v":0},null,null,null,null,null,null,null,null,"inne","inne"]
[null,null,"nz=Nz/NRz",{"$f":"IF(N_Rz=0,0,N_z/N_Rz)","v":0},null,null,null,null,null,null,null,null,"zakotwienie pręta","bez haka"]
[null,"Wsp interkacji","αy",{"$f":"IF(M_z=0,1,G133)","v":1},null,null,null,null,null,null,null,null,null,"zagięte lub hak"]
[null,null,"αz",{"$f":"IF(M_y=0,1,G134)","v":0.98150000000000004},"   Zintegowane równania równowagi przekroju w kierunkach y-y i z-z:",null,null,null,null,null,null,null,"zagięte lub hak","pętla"]
[null,"Ry",{"$f":"(M_y-M_cy)*1000- ((N_y+2*F_sly-F_cy)*d_0y +(F_sly*a_ly+F_suy*a_uy))","v":-7.3484261520206928E-7},null,null,null,null,null,null,null,null,null,"warunki przyczepności","dobre"]
[null,"Rz",{"$f":"(M_z-M_cz)*1000- ((N_z+2*F_slz-F_cz)*d_0z +(F_slz*a_lz+F_suz*a_uz))","v":0},null,null,null,null,null,null,null,null,null,"dobre","inne"]
[null,null,null,null,null,null,null,null,null,null,null,null,"przyspojenie","nie"]
[null,null,0,null,null,null,null,null,null,null,null,null,"nie","tak"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sposób przyspawania","w narożu belki"]
[null,null,null,null,null,null,null,null,null,null,null,null,"pręty rozdzielcze","poprzeczne pod"]
[null,null,null,null,null,null,null,null,null,null,null,null,"w narożu belki","poprzeczne nad"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Współczynniki ogólne"]
[null,null,null,null,null,null,null,null,null,null,null,null,"współczynnik K ",{"$f":"IF(Sposób_przyspawania=w_narozu,0.1,IF(Sposób_przyspawania=poprzeczne_pod,0.05,0))","v":0.1},"(-)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"współczynnik η1 ",{"$f":"IF(Warunki_przyczepności=\"dobre\",1,0.7)","v":1},"(-)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"współczynnik η1 ",{"$f":"IF(Fi_zaklad<= 32,1,0.01*(132-Fi_zaklad))","v":1},"(-)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Przyczepność fbd",{"$f":"2.25*N20*N21*f_ctk05/1.4","v":2.885584410016925},"MPa"]
[null,null,null,null,null,null,null,null,null,null,null,null,"otulenie efektywne cd",{"$f":"IF(Zakotwienie_preta=bez_haka,MIN(0.5*a_kotwa,c_1kotwa, c_kotwa),IF(Zakotwienie_preta=hak,MIN(0.5*a_kotwa,c_1kotwa),c_kotwa))","v":25},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,"pole poj. pręta As",{"$f":"Fi_zaklad^2 *PI()/4/100","v":2.0106192982974678},"cm2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"efektywny pas zakładu 1,3 l0",{"$f":"1.3*l_0","v":42.446388285070306},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,"min zbrojenie  ⊥",{"$f":"IF(Smb_Elem=\"belka\", 0.25*A_skotwa,0)","v":0},"cm2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"wsp  zbrojenia λ ",{"$f":"(Kotwienie!E36-N26)/A_skotwa","v":1.2483715848770538},"(-)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Obliczenia pomocnicze"]
[null,null,null,null,null,null,null,null,null,null,null,null,"α1",{"$f":"IF(Ksztalt_preta=N5,1,  IF(c_d>3*Fi_zaklad,0.7,1))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"α2",{"$f":"IF(Ksztalt_preta=N5, 1-0.15*(c_d-Fi_zaklad)/Fi_zaklad, 1-0.15*(c_d-3*Fi_zaklad)/Fi_zaklad)","v":1.215625}]
[null,"BUFOR danych pomocniczych",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N30<0.7,0.7,IF(N30>1,1,N30))","v":1}]
["Element","Beton",null,"Stal",null,null,null,"Wysokości użyteczne","Wysokości użyteczne",null,null,null,"α3",{"$f":"1-N19*N27","v":0.87516284151229462}]
["Belka ","Symbol","C25/30","Symbol","18G2A",null,"xx","a_xx","dxx",null,null,null,null,{"$f":"IF(N32<0.7,0.7,IF(N32>1,1,N32))","v":0.87516284151229462}]
["Belka ","fck",{"$f":"VLOOKUP(SmbBeton,tBeton,2,0)","v":25},"fyk",{"$f":"VLOOKUP(SmbStal,tStal,4,0)","v":356},"MPa","0y",null,{"$f":"h/2","v":225},"mm",null,null,"α4",0.7]
["Płyta ","fcd",{"$f":"VLOOKUP(SmbBeton,tBeton,3,0)","v":17.857142857142858},"fyd",{"$f":"VLOOKUP(SmbStal,tStal,5,0)","v":309.56521739130437},"MPa","uy",{"$f":"c_uy+Fi_uy/2","v":40},{"$f":"a_uy","v":40},"mm",null,null,"α5",{"$f":"1-0.004*p_kotwa","v":1}]
["Słup","γc",{"$f":"Kalkulator!B27","v":1.5},"(ft/fy)k",{"$f":"VLOOKUP(SmbStal,tStal,7,0)","v":1.348314606741573},"(-)","ly",{"$f":"c_ly+Fi_ly/2","v":40},{"$f":"h-a_ly","v":410},"mm",null,null,"α6",{"$f":"(procent_kotwa/25)^0.5","v":1.4142135623730951}]
["Ściana","fcd(1,5)",{"$f":"IF(C36=1.4,f_cd,f_cd*1.4/1.5)","v":16.666666666666668},"εuk",{"$f":"VLOOKUP(SmbStal,tStal,8,0)","v":1.5478260869565219},"%","luy",null,{"$f":"h-a_ly-a_uy","v":370},"mm",null,null,null,{"$f":"IF(N36<1,1,IF(N36>1.5,1.5,N36))","v":1.4142135623730951}]
[null,"η",{"$f":"VLOOKUP(SmbBeton,tBeton,4,0)","v":1},"Epl",{"$f":"VLOOKUP(SmbStal,tStal,9,0)","v":7.5},"GPa","0z",null,{"$f":"b/2","v":150},"mm",null,null,"Współczynniki zakotwienia i zakładu"]
[null,"λ",{"$f":"VLOOKUP(SmbBeton,tBeton,5,0)","v":0.8},"εsy",{"$f":"f_yd/E_s","v":1.5478260869565219},"‰","uz",{"$f":"c_uz+Fi_uz/2","v":40},{"$f":"a_uz","v":40},"mm",null,null,"Kształt prętów α1",{"$f":"IF(wytezenie=$N$3,N29,1)","v":1}]
[null,"fctm",{"$f":"VLOOKUP(SmbBeton,tBeton,7,0)","v":2.5649639200150443},null,null,null,"lz",{"$f":"c_lz+Fi_lz/2","v":40},{"$f":"b-a_lz","v":260},"mm",null,null,"Otulenie betonem α2",{"$f":"IF(wytezenie=$N$3,N31,1)","v":1}]
[null,"Ecm",{"$f":"VLOOKUP(SmbBeton,tBeton,8,0)","v":31.475806210019346},"(-)",null,null,"luz",null,{"$f":"b-a_lz-a_uz","v":220},"mm",null,null,"Brak przyspojenia α3",{"$f":"IF(wytezenie=$N$3,N32,1)","v":0.87516284151229462}]
[null,"n",{"$f":"VLOOKUP(C33,tBeton,9,0)","v":2},"‰",null,null,null,null,null,null,null,null,"Jeśli przyspojone α4",{"$f":"N34","v":0.7}]
[null,"εcu2",{"$f":"VLOOKUP(SmbBeton,tBeton,13,0)","v":3.5},"(-)",null,null,null,null,null,null,null,null,"Nacisk poprzeczny α5",{"$f":"IF(wytezenie=$N$3,N35,1)","v":1}]
[null,"ξu",{"$f":"VLOOKUP(SmbBeton,tBeton,14,0)","v":0.41242911877394633},"(-)",null,null,null,null,null,null,null,null,"Udział uciąglanych α6",{"$f":"IF(wytezenie=$N$3,N36,1)","v":1.4142135623730951}]
[null,"k1(k3)",{"$f":"VLOOKUP(SmbBeton,tBeton,17,0)","v":0.44},"(-)",null,null,null,null,null,null,null,null,"Długości kotwienia i zakłasu"]
[null,"k2(k4)",{"$f":"VLOOKUP(SmbBeton,tBeton,18,0)","v":1.25},"(-)",null,null,null,null,null,null,null,null,"Pods. zakotw.  lbrqd",{"$f":"Fi_zaklad/4*Kotwienie!E18/N22","v":602.99743579145354},"mm"]
[null,"Φ0 ",{"$f":"VLOOKUP(SmbBeton,tBeton,19,0)","v":0.61685823754789271},"MPa",null,"Min zbrojenie",null,null,"Max zbrojenie"]
[null,"fctk,0,5",{"$f":"0.7*f_ctm","v":1.7954747440105308},null,"kierunek","y","z",null,"AsmaxP=0,04 *b*h",{"$f":"0.04*b*h","v":5400},"mm²"]
[null,null,"płyta","AsminP=max{0,26fctm/fyk;0,0013}*b*dl",null,null,{"$f":"MAX(0.26*f_ctm/f_yk,0.0013)*b*d_lz","v":146.11648398287952},null,"AsmaxB=0,04 *b*h",null,"mm²"]
[null,null,"belka","AsminB=AsminP",null,{"$f":"MAX(0.26*f_ctm/f_yk,0.0013)*h*d_ly","v":345.62168326719575},{"$f":"MAX(0.26*f_ctm/f_yk,0.0013)*b*d_lz","v":146.11648398287952},"mm²","AsmaS=0,04 *b*h",null,"mm²"]
[null,null,"słup","AsminS=max ( NEdmax*0,10/fyd; 0.002*b*h)",null,{"$f":"MAX(N_x*0.1/f_yd, 0.002*b*h)","v":270},null,"mm²","AsmaxŚ=0,004 *b*h",{"$f":"0.004*b*h","v":540},"mm²"]
[null,null,"ściana","AsminŚ=0.002*b*h/2",null,{"$f":"0.002*b*h/2","v":135},null,"mm²"]
[]
[null,"KALKULATOR zbrojenia podłużnego"]
[null,null,"Obciązenie względne",null,null,"my",{"$f":"M_y/(b/100)/(d_ly^2/10000)/f_cd","v":0.19199682728534603},"(-)"]
[null,null,null,null,null,"mz",{"$f":"M_z/(h/100)/(d_lz^2/10000)/f_cd","v":0},"(-)"]
[null,null,null,null,null,"nx",{"$f":"N_x/(b/100)/(d_ly/100)/f_cd","v":0},"(-)"]
[null,null,null,"Pole przekroju 1 pręta",null,"A1uy",{"$f":"PI()*(Fi_uy/10)^2/4","v":1.1309733552923256},"cm2"]
[null,null,null,null,"górne  ","A1ly",{"$f":"PI()*(Fi_ly/10)^2/4","v":2.5446900494077327},"cm2"]
[null,null,null,null,"dolne ","A1uz",{"$f":"PI()*(Fi_uz/10)^2/4","v":2.5446900494077327},"cm2",null,null," "]
[null,null,null,null,"lewe ","A1lz",{"$f":"PI()*(Fi_lz/10)^2/4","v":2.5446900494077327},"cm2"]
[null,null,null,null,"prawe "]
[null,"Obliczenia wstępne (klasyczne)"]
[null,null,null,"ZGINANIE Y "]
[null,null,null,"wsp redystrybucji",null,"δ",0.9,"(-)","(36), (40)"]
[null,null,null,"graniczna wysokość ściskana",null,"ξu",{"$f":"(δ-k_13)/k_24","v":0.36799999999999999},"(-)"]
[null,null,null,"efektywna, graniczna wysokość",null,"ξefff,u",{"$f":"G66*λ","v":0.2944},"(-)","(43)"]
[null,null,null,"graniczna nośność przekroju",null,"mu",{"$f":"η*(G67-(λ*G66)^2/2)","v":0.25106432000000001},"(-)"," (44)"]
[null,null,null,"nadwyżka nad my",null,"Δmy",{"$f":"my-mu","v":-5.9067492714653974E-2},"(-)"]
[null,null,null,"warunek zbrojenia podwójnego  ",null,"Asu> 0 ?",{"$f":"IF(G69>0,\"TAK\",\"NIE\")","v":"NIE"},"(-)","(45)"]
[null,null,null,"wyróżnik y",null,"Wy",{"$f":"1- 2*my/η","v":0.61600634542930788},"(-)"]
[null,null,null,"efektywna wysokość strefy ściskanej",null,"ξ1,effy",{"$f":"IF(G71>0, 1 - SQRT(G71),0)","v":0.21513928278368533},"(-)"]
[null,null,null,"wysokość strefy ściskanej klasycznie",null,"x1Ky",{"$f":"G72*d_ly/λ","v":110.25888242663872},"mm"]
[null,null,null,"efektywne ramie sił ",null,"ζ1effy",{"$f":"IF(G71>0,(1+SQRT(G71)/η)/2,1)","v":0.89243035860815734},"(-)"]
[null,null,null,"siła beton",null,"Fc1y",{"$f":"b*d_ly*f_cd/1000000","v":2.1964285714285712},"kN"]
[null,null,null,"Zbrojenie rozciągane pojedyńczo  Asll",null,"Asl_1y",{"$f":"my*G75/G74/f_yd*10000","v":15.264572406577187},"cm2","(49)"]
[null,null,null,"Zbrojenie ściskaneAsu",null,"Asu2y",{"$f":"IF(G69>0,G69*G75/f_yd*10000,0)","v":0},"cm2","(51)"]
[null,null,null,"Zbrojenie rozciągane podwójnie  Asl+Asu",null,"Asl2y",{"$f":"G76+G77","v":15.264572406577187},"cm2","(52)"]
[null,null,null,"ZGINANIE Z "]
[null,null,null,"nadwyżka nad  mz",null,"Δmz",{"$f":"mz-mu","v":-0.25106432000000001},"(-)"]
[null,null,null,"warunek zbrojenia podwójnego  ",null,"Asu> 0 ?",{"$f":"IF(G80>0,\"TAK\",\"NIE\")","v":"NIE"},"(-)"]
[null,null,null,"wyróżnik",null,"Wz",{"$f":"1- 2*mz/η","v":1},"(-)"]
[null,null,null,"efektywna wysokość strefy ściskanej",null,"ξ1effz",{"$f":"IF(G82>0, 1 - SQRT(G82),0)","v":0},"(-)"]
[null,null,null,"wysokość strefy ściskanej klasycznie",null,"x1Kz",{"$f":"G83*d_lz/λ","v":0},"mm"]
[null,null,null,"efektywne ramie sił ",null,"ζ1effz",{"$f":"IF(G82>0,(1+SQRT(1-2*mz)/η)/2,1)","v":1},"(-)"]
[null,null,null,"Zbrojenie Asll",null,"Asl1z",{"$f":"mz*G75/G85/f_yd*10000","v":0},"cm2"]
[null,null,null,"Zbrojenie Asu",null,"Asu2z",{"$f":"IF(G80>0,G80*b/10*d_ly/10*f_cd/((1-a_uy /d_ly)*f_yd),0)","v":0},"cm2"]
[null,null,null,"Zbrojenie Asl+Asu",null,"Asl2z",{"$f":"G86+G87","v":0},"cm2"]
[null,"Nośności przekroju"]
[null,null,null,"ZGINANIE Y"]
[null,null,null,"Siła w betonie",null,"F0cy",{"$f":"17/21*x_Ry*b*f_cd/1000","v":488.60825457583309},"kN"]
[null,null,null,null,null,"FNy",{"$f":"IF(_x_y>1,(7/192*(1/_x_y-1)^2)*b*h*f_cd/1000,0)","v":0}]
[null,null,null,null,null,"Fcy",{"$f":"F0_cy-F_Ny*(21+20*_x_y)","v":488.60825457583309},"kN"]
[null,null,null,"Moment w betonie",null,"M0cy",{"$f":"F0_cy*(d_0y-693/1666*x_Ry)/1000","v":87.037832736632069},"kNm"]
[null,null,null,null,null,"Mcy",{"$f":"M0_cy+F_Ny*h*(7+8*_x_y+9*_x_y^2)/1000","v":87.037832736632069}]
[null,null,null,null,null,"εsly",{"$f":"IF(x_Ry<>0, 3.5*(d_ly/x_Ry),0)","v":12.736613078951637},"‰"]
[null,null,null,"Odkształcenia w stali",null,"znak εsly",{"$f":"SIGN(ε_sly)","v":1}]
[null,null,null,null,null,"|εly|",{"$f":"ABS(ε_sly)","v":12.736613078951637},"‰"]
[null,null,null,null,null,"εsuy",{"$f":"IF(x_Ry<>0, 3.5*(1-d_uy/x_Ry),0)","v":2.2574036020534991},"‰"]
[null,null,null,null,null,"znak εsuy",{"$f":"SIGN(ε_suy)","v":1}]
[null,null,null,null,null,"|εsuy|",{"$f":"ABS(ε_suy)","v":2.2574036020534991},"‰"]
[null,null,null,"Naprężenia  w stali",null,"σsly",{"$f":"IF(G98>ε_sy, G97*f_yd, ε_sly*E_s)","v":309.56521739130437},"MPa"]
[null,null,null,null,null,"σsu",{"$f":"IF(G101>ε_sy, G100*f_yd, ε_suy*E_s)","v":309.56521739130437},"MPa"]
[null,null,null,"Siła stal dolna",null,"Fsly",{"$f":"n_ly*A_1ly*G102/10","v":393.87376416919693},"kN"]
[null,null,null,"Siła stal górna",null,"Fsuy",{"$f":"n_uy*A_1uy*G103/10","v":70.022002518968335},"kN"]
[null,null,null,null,null,"NRy",{"$f":"F_cy+G105-G104","v":164.7564929256045},"kN"]
[null,null,null,null,null,"MRy",{"$f":"M_cy+(G105*(d_0y-a_uy)+G104*(d_0y-a_ly))/1000","v":172.85854957394264},"kNm"]
[null,null,null,"ZGINANIE Z"]
[null,null,null,"Siła w betonie",null,"F0cz",{"$f":"17/21*x_Rz*h*f_cd/1000","v":0},"kN"]
[null,null,null,null,null,"FNz",{"$f":"IF(_x_z>1,(7/192*(1/_x_z-1)^2)*b*h*f_cd/1000,0)","v":0}]
[null,null,null,null,null,"Fcz",{"$f":"F0_cz-F_Nz*(21+20*_x_z)","v":0}]
[null,null,null,"Moment w betonie",null,"M0cz",{"$f":"F_cz*(d_0z-693/1666*x_Rz)/1000","v":0},"kNm"]
[null,null,null,null,null,"Mcz",{"$f":"M0_cz+F_Nz*b*(7+8*_x_z+9*_x_z^2)/1000","v":0}]
[null,null,null,null,null,"εslz",{"$f":"IF(x_Rz<>0,3.5*(d_lz/x_Rz),0)","v":0},"‰"]
[null,null,null,"Odkształcenia w stali",null,"znak εslZ",{"$f":"SIGN(G114)","v":0}]
[null,null,null,null,null,"|εslz|",{"$f":"ABS(G114)","v":0},"‰"]
[null,null,null,null,null,"εsuz",{"$f":"IF(x_Rz<>0, 3.5*(1-d_uz/x_Rz),0)","v":0},"‰"]
[null,null,null,null,null,"znak εsuz",{"$f":"SIGN(G117)","v":0}]
[null,null,null,null,null,"|εsuz|",{"$f":"ABS(G117)","v":0},"‰"]
[null,null,null,null,null,"σslz",{"$f":"IF(G116>ε_sy,f_yd,G114*E_s)","v":0},"MPa"]
[null,null,null,null,null,"σsuz",{"$f":"IF(G119>ε_sy,f_yd*G118,G117*E_s)","v":0},"MPa"]
[null,null,null,null,null,"Fslz",{"$f":"n_lz*A_1lz*G120/10","v":0},"kN"]
[null,null,null,null,null,"Fsuz",{"$f":"n_uz*A_1uz*G121/10","v":0},"kN"]
[null,null,null,null,null,"NRz",{"$f":"F_cz+G123-G122","v":0},"kN"]
[null,null,null,null,null,"MRz",{"$f":"G112+(G123*(d_0z-a_uz)+G122*(d_0z-a_lz))/1000","v":0},"kNm"]
[]
[null,null,null,"ŚCISKANIE X",null,"Ac",{"$f":"b*h/100","v":1350},"cm2"]
[null,null,null,"Pole betonu",null,"ΣAs",{"$f":"(A_suy+A_sly+A_suz+A_slz)/100","v":22.336723767023429},"cm2"]
[null,null,null,"Suma pola zbrojenia",null,"NRdx",{"$f":"G127*f_cd+G128*f_yd/10","v":24798.610132017671},"kN"]
[null,null,null,"Max nośność przekroju",null,"nx",{"$f":"N_x/N_Rdx","v":0}]
[null,null,null,null,null,"nNy",{"$f":"IF(M_z=0,1, 1/2+(1/(nx+1)-3/4)^0.5)","v":1}]
[null,null,null,null,null,"nNz",{"$f":"IF(M_y=0,1,1-n_Ny)","v":0}]
[null,null,null,null,null,"αy",{"$f":"0.9259*n_Ny^2+0.09526*n_Ny+0.9815","v":2.0026599999999997}]
[null,null,null,"Wsp interkacji",null,"αz",{"$f":"0.9259*n_Nz^2+0.09526*n_Nz+0.9815","v":0.98150000000000004}]

{"sheet":"Arkusz1","index":4,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,2,12,2],[13,2,14,2],[1,4,1,7],[1,3,2,3],[3,2,4,2],[5,2,6,2],[7,2,8,2],[9,2,10,2],[1,2,2,2]]}
[]
[null,null,"Schemat","Moment [kNm]","Punkt: A,B-stopy, C,D-głowice"]
[null,null,null,null,"A","B","C","D"]
[null,null,"V","MI",-140.38999999999999,140.38999999999999,-282.88,282.88]
[null,null,null,"MII",-157.79,157.79,-283.17,283.17]
[null,null,"V+H(-)","MI",-172.14,108.64,-282.88,282.88]
[null,null,null,"MII",-367.76,-52.2,-283.58,282.7]
[null,null,"V+H(-)+q(++)","MI",-201.56,79.23,-282.88,282.88]
[null,null,null,"MII",-517.98,-202.43,-283.86,-282.38]
[null,null,"V+H(-)+q(--)","MI",-164.82,101.32,-282.88,282.88]
[null,null,null,"MII",-360.07,-60.33,-283.61,282.69]
[null,null,"V+H(-)+q(+-)","MI",-142.72999999999999,138.06,-282.88,282.88]
[null,null,null,"MII",-217.54,98.04,-283.29000000000002,283.02999999999997]
[null,null,"V+H(-)+q(-+)","MI",-179.47,115.97,-282.88,282.88]
[null,null,null,"MII",-375.44,-44.07,-283.55,282.72000000000003]