Rock Mechanics Assignment.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	W	X	Y	Z	AA
1				Rock Mass				R	2.5	Parameters	A	B	C	D	E	F
2	Properties	A	B	C	D	E	F			P0(MPa)	28	28	28	28	28	28					Consider for the rockmass A, strain		0.025
3	Cohesion (MPa)	0.963	1.197	1.435	2.16	4.029	7.452			Pcr(MPa)	17.36172993	15.84490543	14.39086269	13.38255647	10.37363973	6.11364502					Therefore, the radial deformation		62.5mm
4	Friction Angle (Deg)	20.35	23.26	26.11	26.96	30.36	34.16			Kp	2.066032342	2.304877507	2.571547849	2.658241436	3.043223983	3.560096167					As per LDP, the deformation allowed should be 62.5 mm,but we see that when we reach the face, the deformation is already at 244mm
5	In-situ Stress (MPa)	28	28	28	28	28	28			σcm(MPa)	2.768374503	3.634528435	4.602345324	7.043377385	14.05705105	28.12119077					So face reinforcement has to be adopted for the rockmass A
6	Poisson’s Ratio	0.25	0.25	0.25	0.25	0.25	0.25			Grm(MPa)	460	873.2	1722	3000	4486	11058.8
7	E (MPa)	1150	2183	4305	7500	11215	27647			ue(m)	0.07608695652	0.04008245534	0.02032520325	0.01166666667	0.007802050825	0.003164900351
8										up(m)	1.951463195	0.4604151074	0.1321091424	0.0450135887	0.01421888248	0.003660716544
9										Rp(m)	16.93384121	10.72615398	7.746401017	5.897889369	3.920718653	2.971689904
10										Pi(Mpa)	0	0	0	0	0	0
11
12	Pi	ue	Rpl	upl	u																For rock mass B, strain		0.035
13	0	0.07608695652	16.93384121	1.951463195	2.027550152											Pi	ue	Rpl	upl	u	Therefore, the radial deformation		87.5	mm
14	0.5	0.07472826087	14.35556365	1.392434683	1.467162944											0	0.04008245534	10.72615398	0.4604151074	0.5004975627	At 2m,deformation		497.88	mm
15	1	0.07336956522	12.47513623	1.04306973	1.116439296											0.5	0.03936669721	9.451369458	0.3533566065	0.3927233037	So corresponding Pi=Minimum Yield Strength			6.8	Mpa
16	1.5	0.07201086957	11.04128546	0.8098063082	0.8818171777											1	0.03865093907	8.479008246	0.280905843	0.3195567821	Strain for 498 mm		19.9152
17	2	0.07065217391	9.91077471	0.646148464	0.7168006379											1.5	0.03793518094	7.709985004	0.2292730805	0.2672082614	So face reinforcement has to be adopted for the rockmass B
18	2.5	0.06929347826	8.995888403	0.5268180849	0.5961115632											2	0.03721942281	7.084741782	0.1910012172	0.22822064
19	3	0.06793478261	8.239863363	0.4370906853	0.5050254679											2.5	0.03650366468	6.565201036	0.161743784	0.1982474487
20	3.5	0.06657608696	7.604318931	0.3679065583	0.4344826452											3	0.03578790655	6.125816965	0.1388150334	0.1746029399
21	4	0.0652173913	7.062359199	0.3134374682	0.3786548595											3.5	0.03507214842	5.748774966	0.1204758106	0.155547959
22	4.5	0.06385869565	6.59456794	0.2697927566	0.3336514522											4	0.03435639029	5.421250566	0.1055557885	0.1399121788
23	5	0.0625	6.186572322	0.2342928565	0.2967928565											4.5	0.03364063216	5.133762788	0.0932417003	0.1268823325
24	5.5	0.06114130435	5.827501831	0.20504236	0.2661836644											5	0.03292487403	4.879142353	0.08295277617	0.1158776502
25	6	0.0597826087	5.508980469	0.180669194	0.2404518026											5.5	0.0322091159	4.651861699	0.07426443837	0.1064735543
26	6.5	0.05842391304	5.22444848	0.160159856	0.218583769											6	0.03149335776	4.447586461	0.06685990615	0.09835326391
27	7	0.05706521739	4.968694274	0.1427522543	0.1998174717											6.5	0.03077759963	4.26286717	0.06049856468	0.09127616431
28	7.5	0.05570652174	4.737524222	0.1278642028	0.1835707245											7	0.0300618415	4.094922372	0.05499474011	0.08505658161
29	8	0.05434782609	4.527525113	0.115044612	0.1693924381											7.5	0.02934608337	3.941482914	0.05020312279	0.07954920616
30	8.5	0.05298913043	4.335890255	0.10393949	0.1569286205											8	0.02863032524	3.800678093	0.04600854757	0.07463887281
31	9	0.05163043478	4.160290163	0.09426782379	0.1458982586											8.5	0.02791456711	3.670951058	0.04231869538	0.07023326249
32	9.5	0.05027173913	3.998775031	0.08580418564	0.1360759248											9	0.02719880898	3.550995011	0.03905879361	0.06625760259
33	10	0.04891304348	3.849700217	0.07836600156	0.127279045											9.5	0.02648305085	3.439704461	0.03616770948	0.06265076033
34	10.5	0.04755434783	3.711668642	0.07180410335	0.1193584512											10	0.02576729272	3.336137518	0.03359503072	0.05936232344
35	11	0.04619565217	3.583485782	0.06599562985	0.112191282											10.5	0.02505153459	3.239486414	0.03129885637	0.05635039096
36	11.5	0.04483695652	3.464124152	0.06083863164	0.1056755882											11	0.02433577645	3.149054209	0.02924410587	0.05357988232
37	12	0.04347826087	3.35269502	0.05624792681	0.09972618768											11.5	0.02362001832	3.064236231	0.02740121096	0.05102122928
38	12.5	0.04211956522	3.248425691	0.05215188635	0.09427145157											12	0.02290426019	2.984505134	0.02574509394	0.04864935413
39	13	0.04076086957	3.150641116	0.04848991788	0.08925078744											12.5	0.02218850206	2.909398801	0.02425436221	0.04644286427
40	13.5	0.03940217391	3.058748905	0.04521047926	0.08461265317											13	0.02147274393	2.838510453	0.0229106681	0.04438341203
41	14	0.03804347826	2.972227014	0.04226949815	0.08031297641											13.5	0.0207569858	2.771480524	0.02169819597	0.04245518177
42	14.5	0.03668478261	2.890613578	0.03962910513	0.07631388774											14	0.02004122767	2.707989934	0.0206032483	0.04064447597
43	15	0.03532608696	2.813498461	0.03725661124	0.07258269819											14.5	0.01932546954	2.647754485	0.0196139094	0.03893937894	For rock mass C, strain		0.03
44	15.5	0.0339673913	2.740516189	0.03512367727	0.06909106857											15	0.01860971141	2.590520173	0.01871977038	0.03732948179	Therefore, the radial deformation		75	mm
45	16	0.03260869565	2.671340018	0.03320563487	0.06581433052											15.5	0.01789395328	2.536059239	0.0179117029	0.03580565618	If we mobilize for 2m		Deformation	150	mm
46	16.5	0.03125	2.605676922	0.03148092838	0.06273092838											16	0.01717819514	2.48416683	0.01718167194	0.03435986709
47	17	0.02989130435	2.543263342	0.02993065346	0.05982195781											16.5	0.01646243701	2.434658157	0.01652258011	0.03298501712	So corresponding Pi		2.5	MPa
48	17.5	0.0285326087	2.483861559	0.0285381738	0.0570707825											17	0.01574667888	2.387366074	0.01592813742	0.0316748163	Lets allow deformation of rock mass for 3%		75	mm
49	18	0.02717391304	2.4272566	0.02728880112	0.05446271416											17.5	0.01503092075	2.342138996	0.01539275194	0.0304236727	At 2m,strain	6
50	18.5	0.02581521739	2.373253569	0.02616952669	0.05198474408											18	0.01431516262	2.298839112	0.0149114375	0.02922660012	So face reinforcement has to be adopted for the rockmass C
51	19	0.02445652174	2.321675354	0.02516879527	0.04962531701											18.5	0.01359940449	2.25734084	0.01447973544	0.02807913993
52	19.5	0.02309782609	2.272360634	0.02427631375	0.04737413984											19	0.01288364636	2.217529479	0.01409364806	0.02697729442
53	20	0.02173913043	2.225162158	0.02348288867	0.0452220191											19.5	0.01216788823	2.17930005	0.01374958177	0.02591746999
54	20.5	0.02038043478	2.179945234	0.0227802877	0.04316072249											20	0.0114521301	2.142556271	0.01344429826	0.02489642836
55	21	0.01902173913	2.136586418	0.02216112111	0.04118286024											20.5	0.01073637197	2.107209669	0.01317487261	0.02391124457
56	21.5	0.01766304348	2.09497236	0.02161873994	0.03928178342											21	0.01002061383	2.073178791	0.01293865699	0.02295927082
57	22	0.01630434783	2.054998789	0.02114714837	0.03745149619											21.5	0.009304855703	2.040388517	0.01273324931	0.02203810502
58	22.5	0.01494565217	2.01656962	0.02074092787	0.03568658004											22	0.008589097572	2.008769446	0.01255646593	0.0211455635
59	23	0.01358695652	1.979596164	0.02039517159	0.03398212811											22.5	0.007873339441	1.978257362	0.01240631787	0.02027965732
60	23.5	0.01222826087	1.943996429	0.02010542718	0.03233368805											23	0.00715758131	1.948792747	0.01228099008	0.01943857139
61	24	0.01086956522	1.909694493	0.01986764703	0.03073721225											23.5	0.006441823179	1.920320356	0.01217882318	0.01862064636
62	24.5	0.009510869565	1.876619959	0.01967814476	0.02918901432											24	0.005726065048	1.892788839	0.01209829749	0.01782436254
63	25	0.008152173913	1.844707451	0.01953355702	0.02768573093											24.5	0.005010306917	1.866150397	0.01203801895	0.01704832587
64	25.5	0.006793478261	1.813896181	0.01943081004	0.0262242883											25	0.004294548786	1.840360476	0.01199670663	0.01629125542
65	26	0.005434782609	1.784129546	0.01936709007	0.02480187268											25.5	0.003578790655	1.815377496	0.01197318176	0.01555197242
66	26.5	0.004076086957	1.755354777	0.01933981733	0.02341590429											26	0.002863032524	1.791162603	0.01196635795	0.01482939048
67	27	0.002717391304	1.727522617	0.01934662297	0.02206401427											26.5	0.002147274393	1.767679446	0.01197523249	0.01412250688
68	27.5	0.001358695652	1.700587033	0.01938532862	0.02074402427											27	0.001431516262	1.744893977	0.01199887861	0.01343039488
69	28	0	1.674504957	0.01945392824	0.01945392824											27.5	0.000715758131	1.72277427	0.01203643861	0.01275219674
70																28	0	1.701290353	0.01208711763	0.01208711763
71
72
73	Pi	ue	Rpl	upl	u											Pi	ue	Rpl	upl	u
74	0	0.02032520325	7.746401017	0.1321091424	0.1524343457											0	0.01166666667	5.897889369	0.0450135887	0.05668025537
75	0.5	0.01996225319	7.007112694	0.1064306476	0.1263929008											0.5	0.01145833333	5.515060991	0.03873110008	0.05018943341
76	1	0.01959930314	6.425677473	0.08809445557	0.1076937587											1	0.01125	5.19188727	0.03377733264	0.04502733264	For rockmass D,strain			0.025
77	1.5	0.01923635308	5.954041342	0.07443272875	0.09366908182											1.5	0.01104166667	4.914607398	0.02978521283	0.0408268795	U	62.5
78	2	0.01887340302	5.562244925	0.06391647418	0.0827898772											2	0.01083333333	4.673497488	0.02651013776	0.03734347109	utotal	56.68025537
79	2.5	0.01851045296	5.230549365	0.05561020542	0.07412065838											2.5	0.010625	4.461471257	0.0237831205	0.0344081205	Since total deformation is less than allowable deformation,no need for supports
80	3	0.0181475029	4.945371191	0.04891135954	0.06705886244											3	0.01041666667	4.27322986	0.02148383982	0.03190050649	For rockmass E
81	3.5	0.01778455285	4.697027829	0.0434153448	0.06119989765											3.5	0.01020833333	4.104723506	0.01952440589	0.02973273923	utotal	22.0209333033305mm
82	4	0.01742160279	4.478413602	0.03884101425	0.05626261704											4	0.01	3.952798368	0.01783919265	0.02783919265	For rock mass E, no supports are required
83	4.5	0.01705865273	4.284184841	0.03498728846	0.05204594119											4.5	0.009791666667	3.81495797	0.0163782541	0.02616992077
84	5	0.01669570267	4.1102383	0.03170677709	0.04840247976											5	0.009583333333	3.689197702	0.01510293662	0.02468626996
85	5.5	0.01633275261	3.953366025	0.02888913029	0.0452218829											5.5	0.009375	3.573887427	0.0139828802	0.0233578802	Pi	ue	Rpl	upl	u
86	6	0.01596980256	3.811020364	0.02645019032	0.04241999287											6	0.009166666667	3.467686509	0.01299392284	0.02216058951	0	0.007802050825	3.920718653	0.01421888248	0.0220209333
87	6.5	0.0156068525	3.68114995	0.0243247239	0.0399315764											6.5	0.008958333333	3.369481208	0.01211660694	0.02107494028	0.5	0.007662728489	3.788381005	0.01308596995	0.02074869844
88	7	0.01524390244	3.562082693	0.02246143354	0.03770533598											7	0.00875	3.278337824	0.0113350958	0.0200850958	1	0.007523406152	3.668762214	0.012104162	0.01962756815
89	7.5	0.01488095238	3.452440696	0.02081945878	0.03570041116											7.5	0.008541666667	3.193467106	0.01063637493	0.01917804159	1.5	0.007384083816	3.559942708	0.01124658378	0.01863066759
90	8	0.01451800232	3.351077296	0.01936587488	0.03388387721											8	0.008333333333	3.114196877	0.01000965485	0.01834298818	2	0.00724476148	3.460385842	0.0104923852	0.01773714668
91	8.5	0.01415505226	3.257029772	0.01807387365	0.03222892592											8.5	0.008125	3.039950727	0.009445918701	0.0175709187	2.5	0.007105439144	3.368844918	0.009825141022	0.01693058017
92	9	0.01379210221	3.169483306	0.01692141967	0.03071352188											9	0.007916666667	2.970231239	0.008937575297	0.01685424196	3	0.006966116808	3.284296401	0.009231735262	0.01619785207
93	9.5	0.01342915215	3.087743189	0.01589024369	0.02931939584											9.5	0.007708333333	2.90460667	0.008478190246	0.01618652358	3.5	0.006826794472	3.20589103	0.00870156712	0.01552836159
94	10	0.01306620209	3.011213125	0.01496507887	0.02803128096											10	0.0075	2.842700262	0.008062275392	0.01556227539	4	0.006687472136	3.132917409	0.008225975176	0.01491344731
95	10.5	0.01270325203	2.939378119	0.01413307444	0.02683632647											10.5	0.007291666667	2.784181601	0.007685122401	0.01497678907	4.5	0.006548149799	3.064774494	0.007797812932	0.01434596273
96	11	0.01234030197	2.871790858	0.0133833407	0.02572364267											11	0.007083333333	2.728759576	0.007342670093	0.01442600343	5	0.006408827463	3.000950505	0.007411131209	0.01381995867
97	11.5	0.01197735192	2.808060762	0.01270659249	0.02468394441											11.5	0.006875	2.676176596	0.007031397829	0.01390639783	5.5	0.006269505127	2.941006564	0.007060937279	0.01333044241
98	12	0.01161440186	2.747845119	0.01209486715	0.02370926901											12	0.006666666667	2.62620381	0.006748239197	0.01341490586	6	0.006130182791	2.884563857	0.006743009918	0.01287319271
99	12.5	0.0112514518	2.690841852	0.01154129956	0.02279275136											12.5	0.006458333333	2.578637137	0.006490511629	0.01294884496	6.5	0.005990860455	2.831293459	0.006453755804	0.01244461626
100	13	0.01088850174	2.636783563	0.01103994132	0.02192844306											13	0.00625	2.533293938	0.006255858656	0.01250585866	7	0.005851538119	2.780908185	0.006190096856	0.01204163497