---

Overview

Arkusz1
Arkusz2

---

Sheet 1: Arkusz1

	Tabela do rozwiązania ramy od wpływów mechanicznych.
W pola koloru				należy wprowadzić wartości od siebie.
Pozostałe pola zostaną automatycznie uzupełnione.
W polu		powinna wyjść wartość "0" lub do niej zbliżona.
W polu		mamy sumy delt.
Założenie Io			Io=	0.0054
Moment	Pręt	długość	pręt	m	M1	M2	Mp	d11	d12	d22	d1p	d2p	Mw	Ms	MsMwm
0.0072		4	p	0.5	0	0	0	0	0	0	0	0	0	0	0
0.0072	1	4	s	2	0.665	0	45.65	0.88445	0	0	60.7145	0	52.2930099422725	0.665	69.5497032232224
0.0072		4	k	0.5	1.333	0	51.12	0.8884445	0	0	34.07148	0	64.4359883504499	1.333	42.9465862355749
0.011433		3	p	0.236158488585673	1.333	-0.6	96.12	0.419627420624508	-0.188879559170821	0.085017055890842	30.2585053791656	-13.6197323537129	87.0021561037518	0.733	15.0604362061519
0.011433	2a	3	s	0.944633954342692	0.3315	-0.45	160.29	0.103807950669116	-0.140915770139071	0.191288375754395	50.1941973235371	-68.1369194437156	146.776141297478	-0.1185	-16.4299926207043
0.011433		3	k	0.236158488585673	-0.669	-0.3	224.46	0.105695329309892	0.047397008659145	0.021254263972711	-35.462441878772	-15.9024403043821	206.560115979839	-0.969	-47.2687161233317
0.011433		3	p	0.236158488585673	-0.669	-0.3	224.46	0.105695329309892	0.047397008659145	0.021254263972711	-35.462441878772	-15.9024403043821	206.560115979839	-0.969	-47.2687161233317
0.011433	2b	3	s	0.944633954342692	-1.6675	-0.15	138.625	2.62660784570979	0.236276567829966	0.021254263972711	-218.35892810286	-19.6424822881134	116.359069639469	-1.8175	-199.773653280254
0.011433		3	k	0.236158488585673	-2.666	0	52.79	1.67850968249803	0	0	-33.2365064287589	0	26.1580232991002	-2.666	-16.4690530317137
0.0072		3	p	0.375	0	0.6	-45.56	0	0	0.135	0	-10.251	-23.1261677533019	0.6	-5.20338774449292
0.0072	3	3	s	1.5	0	0.3	-11.25	0	0	0.135	0	-5.0625	-0.033083876650942	0.3	-0.014887744492924
0.0072		3	k	0.375	0	0	0	0	0	0	0	0	0	0	0
0.0054		6.32455	p	1.05409166666667	0	0	0	0	0	0	0	0	0	0	0
0.0054	4	6.32455	s	4.21636666666667	3	-0.5	-30	37.9473	-6.32455	1.05409166666667	-379.473	63.2455	-18.7263943005932	2.5	-197.393361789695
0.0054		6.32455	k	1.05409166666667	6	-1	-60	37.9473	-6.32455	1.05409166666667	-379.473	63.2455	-37.4527886011865	5	-197.393361789695
0.0054		6.32455	p	1.05409166666667	6	0	0	37.9473	0	0	0	0	59.9369318099771	6	379.07412207879
0.0054	5	6.32455	s	4.21636666666667	3	0	0	37.9473	0	0	0	0	29.9684659049885	3	379.07412207879
0.0054		6.32455	k	1.05409166666667	0	0	0	0	0	0	0	0	0	0	0
0.0072		5	p	0.625	0	-1	0	0	0	0.625	0	0	-37.3897204111635	-1	23.3685752569772
0.0072	6	5	s	2.5	0	-0.5	0	0	0	0.625	0	0	-18.6948602055818	-0.5	23.3685752569772
0.0072		5	k	0.625	0	0	0	0	0	0	0	0	0	0	0
0.011433		3	p	0.236158488585673	-2.666	0	52.79	1.67850968249803	0	0	-33.2365064287589	0	26.1580232991002	-2.666	-16.4690530317137
0.011433	7	3	s	0.944633954342692	-0.6665	0	-48.045	0.419627420624508	0	0	30.249061401207	0	-54.702994175225	-0.6665	34.4409247504683
0.011433		3	k	0.236158488585673	1.333	0	-148.88	0.419627420624508	0	0	-46.8673146155865	0	-135.56401164955	1.333	-42.6754512663252
0.0072		4	p	0.5	1.333	0	-148.88	0.8884445	0	0	-99.22852	0	-135.56401164955	1.333	-90.3534137644251
0.0072	8	4	s	2	0.665	0	-74.44	0.88445	0	0	-99.0052	0	-67.7969900577275	0.665	-90.1699967767776
0.0072		4	k	0.5	0	0	0	0	0	0	0	0	0	0	0
							suma	162.892697081868	-12.6478247441616	3.9682515568967	-1154.3161152296	-22.026514694306			2.55795384873636E-13
				Ujemny wyznacznik macierzy W				W=	-0.002055786952925
				Obliczanie x1 i x2				x1=	9.98948863499618
								x2=	37.3897204111635
					Tabela do obliczenia wartości przemieszczeń dla ramy.
	Moment	Pręt	długość	pręt	m	Mw	M|	M_	Edl|	Edl_	Mn	Edl|	Edl_
	0.0072		4	p	0.5	0	0	0	0	0	0	0	0
	0.0072	1	4	s	2	52.29301	2	-1.5555	209.17204	-162.68355411	0.06334	0.25336	-0.19705074
	0.0072		4	k	0.5	64.43599	4	-3.111	128.87198	-100.230182445	0.12668	0.25336	-0.19705074
	0.0114		3	p	0.236842105263158	87.00216	4	-0.111	82.4230989473684	-2.28724099578947	-0.05512	-0.052218947368421	0.001449075789474
	0.0114	2a	3	s	0.947368421052632	146.7761	4	-1.2755	556.204168421053	-177.359604205263	-0.10466	-0.396606315789474	0.126467838947368
	0.0114		3	k	0.236842105263158	206.5601	4	-2.444	195.688515789474	-119.565683147368	-0.15421	-0.146093684210526	0.089263241052632
	0.0114		3	p	0.236842105263158	206.5301	4	-2.444	195.660094736842	-119.548317884211	-0.15421	-0.146093684210526	0.089263241052632
	0.0114	2b	3	s	0.947368421052632	116.3591	4	-3.6105	440.939747368421	-398.003239468421	-0.20375	-0.772105263157895	0.696921513157895
	0.0114		3	k	0.236842105263158	26.15802	4	-4.777	24.7812821052632	-29.5950461542105	-0.2533	-0.239968421052632	0.286582286842105
	0.0072		3	p	0.375	-23.1262	0	-3	0	26.016975	0.1818	0	-0.204525
	0.0072	3	3	s	1.5	-0.03308	0	-1.5	0	0.07443	0.0909	0	-0.204525
	0.0072		3	k	0.375	0	0	0	0	0	0	0	0
	0.0054		6.32455	p	1.05409166666667	0	0	0	0	0	0	0	0
	0.0054	4	6.32455	s	4.21636666666667	-18.7264	0	0	0	0	0.1335	0	0
	0.0054		6.32455	k	1.05409166666667	-37.4528	0	0	0	0	0.267	0	0
	0.0054		6.32455	p	1.05409166666667	59.93693	0	0	0	0	0.57	0	0
	0.0054	5	6.32455	s	4.21636666666667	29.96847	0	0	0	0	0.285	0	0
	0.0054		6.32455	k	1.05409166666667	0	0	0	0	0	0	0	0
	0.072		5	p	0.0625	-37.3897	0	0	0	0	0.267	0	0
	0.072	6	5	s	0.25	-18.6949	0	0	0	0	0.1335	0	0
	0.072		5	k	0.0625	0	0	0	0	0	0	0	0
	0.0144		3	p	0.1875	26.15802	4	-4.777	19.618515	-23.42941153875	-0.2533	-0.189975	0.22687764375
	0.0144	7	3	s	0.75	-54.703	4	-5.944	-164.109	243.865974	-0.06331	-0.18993	0.28223598
	0.0144		3	k	0.1875	-135.564	4	-7.111	-101.673	180.74917575	0.12668	0.09501	-0.1689040275
	0.0072		3	p	0.375	-135.564	4	-7.111	-203.346	361.4983515	0.12668	0.19002	-0.337808055
	0.0072	8	3	s	0.375	-67.797	2	-3.5555	-50.84775	90.3945875625	0.06334	0.047505	-0.08445201375
	0.0072		3	k	0.375	0	0	0	0	0	0	0	0
								SUMA	1333.38369236842	-230.102786136513		-1.29373631578947	0.404745244342105
		WPŁYWY MECHANICZNE						WPŁYWY NIEMECHANICZNE
	L =1333,384:E = 0,0411538 m.							L = - 1,294:E = -3,99*10-5 m.
	L _ = - 230,1:E = 0,0071 m.							L _ = 0,4047:E = 1,249*10-5 m.
			0,007 m.
				0,0411538 m.
	0,041761767 m.							-3,99*10-5 m.	4,1809 * 10-5 m
									1,249*10-5 m.

---

Sheet 2: Arkusz2

	Tabela do rozwiązania ramy od wpływów mechanicznych.
W pola koloru				należy wprowadzić wartości od siebie.
Pozostałe pola zostaną automatycznie uzupełnione.
W polu		powinna wyjść wartość "0" lub do niej zbliżona.
W polu		mamy sumy delt.
Założenie Io			Io=	0.0054
Moment	Pręt	długość	pręt	m	M1	M2	Mp	d11	d12	d22	d1p	d2p	Mw	Ms	MsMwm
0.0072		4	p	0.5	0	0	0	0	0	0	0	0	0	0	0
0.0072	1	4	s	2	0	0.6666	45.56	0	0	0.88871112	0	60.740592	46.2551891677263	0.6666	61.6674181984127
0.0072		4	k	0.5	0	1.3333	51.12	0	0	0.888844445	0	34.079148	52.5104826242567	1.3333	35.0061132414607
0.011433		3	p	0.236158488585673	1	1.333	51.12	0.236158488585673	0.314799265284702	0.419627420624508	12.0724219364996	16.092538441354	43.3494177920587	2.333	23.8836978583012
0.011433	2a	3	s	0.944633954342692	0.75	0.6666	75.42	0.531356599317764	0.472269745473629	0.419753349776961	53.4332196273944	47.4914456048281	69.244625193387	1.4166	92.660973439052
0.011433		3	k	0.236158488585673	0.5	-0.666	201.96	0.059039622146418	-0.078640776699029	0.104749514563107	23.8472841773813	-31.7645825242719	196.685060582205	-0.166	-7.71050854132287
0.011433		3	p	0.236158488585673	0.5	-0.6666	201.96	0.059039622146418	-0.078711624245605	0.10493833744424	23.8472841773813	-31.7931992652847	196.684434849381	-0.1666	-7.73835323046868
0.011433	2b	3	s	0.944633954342692	0.25	-1.6666	74.58	0.059039622146418	-0.393581737076883	2.62377329204933	17.6127000787195	-117.413303804776	70.5517348004337	-1.4166	-94.4101062886013
0.011433		3	k	0.236158488585673	0	-2.6666	52.8	0	0	1.67926528575177	0	-33.2502839149829	50.0190347514866	-2.6666	-31.4989982318244
0.0072		3	p	0.375	1	0	0	0.375	0	0	0	0	-9.16075196578583	1	-3.43528198716969
0.0072	3	3	s	1.5	0.5	0	0	0.375	0	0	0	0	-4.58037598289292	0.5	-3.43528198716969
0.0072		3	k	0.375	0	0	0	0	0	0	0	0	0	0	0
0.0054		6.32455	p	1.05409166666667	0	0	0	0	0	0	0	0	0	0	0
0.0054	4	6.32455	s	4.21636666666667	-0.8333	13	-67.5	2.92779816949967	-45.6754784633333	712.565966666667	237.161138175	-3699.86175	-46.3088008617948	12.1667	-2375.60760114102
0.0054		6.32455	k	1.05409166666667	-1.666	26	-135	2.92569044996667	-45.6590346333333	712.565966666667	237.07575675	-3699.86175	-92.623098174769	24.334	-2375.80716304452
0.0054		6.32455	p	1.05409166666667	0	6	0	0	0	37.9473	0	0	6.25732824236118	6	39.5747853352254
0.0054	5	6.32455	s	4.21636666666667	0	3	0	0	0	37.9473	0	0	3.12866412118059	3	39.5747853352254
0.0054		6.32455	k	1.05409166666667	0	0	0	0	0	0	0	0	0	0	0
0.0072		5	p	0.625	-1.666	20	-75	1.7347225	-20.825	250	-210.29085	2524.5	238.07957358287	18.334	2728.09431379271
0.0072	6	5	s	2.5	-0.8333	10	-37.5	1.735972225	-20.8325	250	-155.368785	1864.5	92.6425350170246	9.1667	2123.0658143514
0.0072		5	k	0.625	0	0	0	0	0	0	0	0	52.8	0	0
0.011433		3	p	0.236158488585673	0	-2.666	52.8	0	0	1.67850968249803	0	-33.2428024140645	50.0196604843108	-2.666	-31.4923047405026
0.011433	7	3	s	0.944633954342692	0	-0.6666	-48.04	0	0	0.419753349776961	0	30.2504514300708	-48.7351891677263	-0.6666	30.6882071784684
0.011433		3	k	0.236158488585673	0	1.3333	-148.88	0	0	0.419816321437943	0	-46.8778623983207	-147.489517375743	1.3333	-46.440040977531
0.0072		4	p	0.5	0	1.3333	-148.88	0	0	0.888844445	0	-99.250852	-147.489517375743	1.3333	-98.3238867585393
0.0072	8	4	s	2	0	0.6666	-74.44	0	0	0.88871112	0	-99.243408	-73.7448108322737	0.6666	-98.3165818015872
0.0072		4	k	0.5	0	0	0	0	0	0	0	0	0	0	0
							sumy:	11.018817298809	-132.75587822393	2012.45183101726	239.390169922376	-3314.90561884545			7.03437308402499E-13
				Ujemny wyznacznik macierzy W				W=	-0.000219745647481
				Obliczanie x1 i x2				x1=	-9.16075196578583
								x2=	1.04288804039353