Cross 2 niveles.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	W	X	Y	Z	AA	AC	AD	AF	AG
1	DATOS						ESQUEMA DEL PÓRTICO						ESTADO 0						ESTADO 1					ESTADO 2
2	f'c	280	kgf/cm2				w2						w2										Δ2			Δ2
3	E	2526713	tonf/m2		F2 →	↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓					F2 →	↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓			R2						R21
4	H1	4.00	m		F2 →	C	V2	F			F2 →															R22
5	H2	3.00	m
6	L	6.00	m
7	F1	10.00	tonf			C2		C4	H2
8	F2	20.00	tonf
9	w1	9.00	tonf/m				w1						w1					Δ1			Δ1
10	w2	6.00	tonf/m		F1 →	↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓					F1 →	↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓			R1											R12
11	IC1	0.0031	m4	inercia C1	F1 →	B	V1	E			F1 →										R11
12	IC2	0.0031	m4	inercia C2
13	IC3	0.0031	m4	inercia C3
14	IC4	0.0031	m4	inercia C4		C1		C3	H1
15	IV1	0.0031	m4	inercia V1
16	IV2	0.0031	m4	inercia V2
17						A		D
18
19							L
20
21	RIGIDECES RELATIVAS Y FACTORES DE DISTRIBUCIÓN PARA CADA ELEMENTO
22	kC1	7.81E-04
23	kC2	1.04E-03
24	kC3	7.81E-04
25	kC4	1.04E-03
26	kV1	5.21E-04
27	kV2	5.21E-04
28
29		nodo	A	B			C		F		E			D
30		tramo	AB	BA	BC	BE	CB	CF	FC	FE	EF	ED	EB	DE
31		FD	0.000	0.333	0.444	0.222	0.667	0.333	0.333	0.667	0.444	0.333	0.222	0.000
32
33	CROSS PARA EL ESTADO 0
34		nodo	A	B			C		F		E			D
35		tramo	AB	BA	BC	BE	CB	CF	FC	FE	EF	ED	EB	DE
36		FD	0.000	0.333	0.444	0.222	0.667	0.333	0.333	0.667	0.444	0.333	0.222	0.000
37		ME	0.000	0.000	0.000	-27.000	0.000	-18.000	18.000	0.000	0.000	0.000	27.000	0.000
38	iter. 1	MD	0.000	9.000	12.000	6.000	12.000	6.000	-6.000	-12.000	-12.000	-9.000	-6.000	0.000
39	iter. 1	MT	4.500	0.000	6.000	-3.000	6.000	-3.000	3.000	-6.000	-6.000	0.000	3.000	-4.500
40	iter. 2	MD	0.000	-1.000	-1.333	-0.667	-2.000	-1.000	1.000	2.000	1.333	1.000	0.667	0.000
41	iter. 2	MT	-0.500	0.000	-1.000	0.333	-0.667	0.500	-0.500	0.667	1.000	0.000	-0.333	0.500
42	iter. 3	MD	0.000	0.222	0.296	0.148	0.111	0.056	-0.056	-0.111	-0.296	-0.222	-0.148	0.000
43	iter. 3	MT	0.111	0.000	0.056	-0.074	0.148	-0.028	0.028	-0.148	-0.056	0.000	0.074	-0.111
44	iter. 4	MD	0.000	0.006	0.008	0.004	-0.080	-0.040	0.040	0.080	-0.008	-0.006	-0.004	0.000
45	iter. 4	MT	0.003	0.000	-0.040	-0.002	0.004	0.020	-0.020	-0.004	0.040	0.000	0.002	-0.003
46	iter. 5	MD	0.000	0.014	0.019	0.009	-0.016	-0.008	0.008	0.016	-0.019	-0.014	-0.009	0.000
47	iter. 5	MT	0.007	0.000	-0.008	-0.005	0.009	0.004	-0.004	-0.009	0.008	0.000	0.005	-0.007
48	iter. 6	MD	0.000	0.004	0.006	0.003	-0.009	-0.004	0.004	0.009	-0.006	-0.004	-0.003	0.000
49	iter. 6	MT	0.002	0.000	-0.004	-0.001	0.003	0.002	-0.002	-0.003	0.004	0.000	0.001	-0.002
50	iter. 7	MD	0.000	0.002	0.003	0.001	-0.003	-0.002	0.002	0.003	-0.003	-0.002	-0.001	0.000
51	iter. 7	MT	0.001	0.000	-0.002	-0.001	0.001	0.001	-0.001	-0.001	0.002	0.000	0.001	-0.001
52	iter. 8	MD	0.000	0.001	0.001	0.001	-0.001	-0.001	0.001	0.001	-0.001	-0.001	-0.001	0.000
53	iter. 8	MT	0.000	0.000	-0.001	0.000	0.001	0.000	0.000	-0.001	0.001	0.000	0.000	0.000
54	iter. 9	MD	0.000	0.000	0.000	0.000	-0.001	0.000	0.000	0.001	0.000	0.000	0.000	0.000
55	iter. 9	MT	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
56	iter. 10	MD	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
57	iter. 10	MT	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
58		Mfinal	4.125	8.250	16.000	-24.250	15.500	-15.500	15.500	-15.500	-16.000	-8.250	24.250	-4.125
59
60	CROSS PARA EL ESTADO 1
61		nodo	A	B			C		F		E			D						R21					R21
62		tramo	AB	BA	BC	BE	CB	CF	FC	FE	EF	ED	EB	DE			C		F			C		F
63		FD	0.000	0.333	0.444	0.222	0.667	0.333	0.333	0.667	0.444	0.333	0.222	0.000									VCB			VFE	C	VCB	F	VFE
64		ME	-29.610	-29.610	-52.640	0.000	-52.640	0.000	0.000	-52.640	-52.640	-29.610	0.000	-29.610									-9.874			-9.874		-9.874		-9.874
65	iter. 1	MD	0.000	27.417	36.555	18.278	35.093	17.547	17.547	35.093	36.555	27.417	18.278	0.000
66	iter. 1	MT	13.708	0.000	17.547	9.139	18.278	8.773	8.773	18.278	17.547	0.000	9.139	13.708									-9.874			-9.874
67	iter. 2	MD	0.000	-8.895	-11.860	-5.930	-18.034	-9.017	-9.017	-18.034	-11.860	-8.895	-5.930	0.000			Δ1			Δ1			VBC			VEF	B	VBC	E	VEF
68	iter. 2	MT	-4.448	0.000	-9.017	-2.965	-5.930	-4.509	-4.509	-5.930	-9.017	0.000	-2.965	-4.448		M												-9.874		-9.874
69	iter. 3	MD	0.000	3.994	5.325	2.663	6.959	3.480	3.480	6.959	5.325	3.994	2.663	0.000			B		E	R11		B		E	R11
70	iter. 3	MT	1.997	0.000	3.480	1.331	2.663	1.740	1.740	2.663	3.480	0.000	1.331	1.997									VBA			VED	B	VBA	E	VED
71	iter. 4	MD	0.000	-1.604	-2.138	-1.069	-2.935	-1.467	-1.467	-2.935	-2.138	-1.604	-1.069	0.000									-6.786			-6.786		-6.786		-6.786
72	iter. 4	MT	-0.802	0.000	-1.467	-0.535	-1.069	-0.734	-0.734	-1.069	-1.467	0.000	-0.535	-0.802
73	iter. 5	MD	0.000	0.667	0.890	0.445	1.202	0.601	0.601	1.202	0.890	0.667	0.445	0.000
74	iter. 5	MT	0.334	0.000	0.601	0.222	0.445	0.300	0.300	0.445	0.601	0.000	0.222	0.334								R11	-6.174	tonf			A	VAB	D	VDE
75	iter. 6	MD	0.000	-0.274	-0.366	-0.183	-0.497	-0.248	-0.248	-0.497	-0.366	-0.274	-0.183	0.000			A		D			R21	-19.747	tonf				-6.786		-6.786
76	iter. 6	MT	-0.137	0.000	-0.248	-0.091	-0.183	-0.124	-0.124	-0.183	-0.248	0.000	-0.091	-0.137
77	iter. 7	MD	0.000	0.113	0.151	0.076	0.205	0.102	0.102	0.205	0.151	0.113	0.076	0.000
78	iter. 7	MT	0.057	0.000	0.102	0.038	0.076	0.051	0.051	0.076	0.102	0.000	0.038	0.057			Δ1	0.010	m
79	iter. 8	MD	0.000	-0.047	-0.062	-0.031	-0.084	-0.042	-0.042	-0.084	-0.062	-0.047	-0.031	0.000			MBA	-29.610	tonf-m
80	iter. 8	MT	-0.023	0.000	-0.042	-0.016	-0.031	-0.021	-0.021	-0.031	-0.042	0.000	-0.016	-0.023			MBC	-52.640	tonf-m
81	iter. 9	MD	0.000	0.019	0.026	0.013	0.035	0.017	0.017	0.035	0.026	0.019	0.013	0.000			MED	-29.610	tonf-m
82	iter. 9	MT	0.010	0.000	0.017	0.006	0.013	0.009	0.009	0.013	0.017	0.000	0.006	0.010			MEF	-52.640	tonf-m
83	iter. 10	MD	0.000	-0.008	-0.011	-0.005	-0.014	-0.007	-0.007	-0.014	-0.011	-0.008	-0.005	0.000
84	iter. 10	MT	-0.004	0.000	-0.007	-0.003	-0.005	-0.004	-0.004	-0.005	-0.007	0.000	-0.003	-0.004
85		Mfinal	-18.919	-8.227	-13.165	21.383	-16.456	16.447	16.447	-16.456	-13.165	-8.227	21.383	-18.919
86
87	CROSS PARA EL ESTADO 2																Δ2			Δ2
88		nodo	A	B			C		F		E			D		M
89		tramo	AB	BA	BC	BE	CB	CF	FC	FE	EF	ED	EB	DE			C		F	R22		C		F	R22
90		FD	0.000	0.333	0.444	0.222	0.667	0.333	0.333	0.667	0.444	0.333	0.222	0.000									VCB			VFE	C	VCB	F	VFE
91		ME	0.000	0.000	-52.640	0.000	-52.640	0.000	0.000	-52.640	-52.640	0.000	0.000	0.000									-14.359			-14.359		-14.359		-14.359
92	iter. 1	MD	0.000	17.547	23.395	11.698	35.093	17.547	17.547	35.093	23.395	17.547	11.698	0.000
93	iter. 1	MT	8.773	0.000	17.547	5.849	11.698	8.773	8.773	11.698	17.547	0.000	5.849	8.773									-14.359			-14.359
94	iter. 2	MD	0.000	-7.798	-10.398	-5.199	-13.647	-6.824	-6.824	-13.647	-10.398	-7.798	-5.199	0.000									VBC			VEF	B	VBC	E	VEF
95	iter. 2	MT	-3.899	0.000	-6.824	-2.599	-5.199	-3.412	-3.412	-5.199	-6.824	0.000	-2.599	-3.899						R12					R12			-14.359		-14.359
96	iter. 3	MD	0.000	3.141	4.188	2.094	5.741	2.870	2.870	5.741	4.188	3.141	2.094	0.000			B		E			B		E
97	iter. 3	MT	1.571	0.000	2.870	1.047	2.094	1.435	1.435	2.094	2.870	0.000	1.047	1.571									VBA			VED	B	VBA	E	VED
98	iter. 4	MD	0.000	-1.306	-1.741	-0.871	-2.353	-1.176	-1.176	-2.353	-1.741	-1.306	-0.871	0.000									4.486			4.486		4.486		4.486
99	iter. 4	MT	-0.653	0.000	-1.176	-0.435	-0.871	-0.588	-0.588	-0.871	-1.176	0.000	-0.435	-0.653
100	iter. 5	MD	0.000	0.537	0.716	0.358	0.972	0.486	0.486	0.972	0.716	0.537	0.358	0.000