---

Overview

Wykres
obliczenia

---

Sheet 1: Wykres

---

Sheet 2: obliczenia

N	18
B	13
G	2
k	3E-05	m/s
rzędna spągu	90	m npm
dx	100
e	190	mm/rok	6,0207366846655E-09	m/s
Studnia 1
X	750	m
Y	440	m
Q	10	m3/h	0,002777777777778	m3/s
Studnia 2
X	1250	m
Y	550	m
Q	20	m3/h	0,005555555555556	m3/s
równanie prostej			y=ax+b
x1	0		y1	35		b=y-ax	35
x2	2000		y2	29		a=(y-b)/x	-0,003
u			0	100	200	300	400	500	600	700	800	900	1000	1100	1200	1300	1400	1500	1600	1700	1800	1900	2000
		1200	1225	1204,09	1183,36	1162,81	1142,44	1122,25	1102,24	1082,41	1062,76	1043,29	1024	1004,89	985,96	967,21	948,64	930,25	912,04	894,01	876,16	858,49	841
		1100	1202,84075579087	1194,97202251629	1180,88475370148	1163,74808466092	1144,81103846528	1124,73971095811	1104,11288971876	1083,59348993714	1063,7137297875	1044,23357487506	1024,91644629723	1005,86780781802	987,452600995492	969,925035489716	953,003658497374	936,1988713959	919,083447779633	901,347359811438	882,728024323509	862,865293282384	841
		1000	1192,40515367445	1188,05875611637	1177,44508317227	1162,47272202047	1144,30253378567	1123,77109119194	1101,86453352335	1080,12351578586	1060,25402988135	1041,00029895909	1021,55057803938	1002,19835952291	984,04373621779	968,020058009553	953,236902647437	938,44455485015	922,733735454751	905,554142686166	886,525619743768	865,229324349585	841
		900	1186,64852221776	1183,39894064603	1174,35027639432	1160,38136200658	1142,14145900852	1120,16376204421	1095,43681294038	1070,76818534517	1052,1647505365	1033,94918858413	1014,07338292183	993,317491560028	974,490101886756	960,860733226827	949,465514776225	937,594885446068	923,838972046611	907,596031278263	888,577163159371	866,512559915743	841
		800	1183,37722944807	1180,52438339923	1172,16189529594	1158,54716614656	1139,7043537412	1115,29186057954	1084,93694639234	1051,33383766148	1039,67377387892	1024,54449746265	1003,46244904736	978,494297452162	955,724622085936	947,453433778331	942,155713328125	934,616675654843	923,417411550919	908,400022764462	889,660617243264	867,229927697572	841
		700	1181,79780431963	1179,14564375044	1171,21193078722	1157,92722908606	1138,82310477375	1112,34855568398	1073,67144993153	1005,94262057305	1026,63818539861	1017,07875388374	992,723793896347	957,458802658881	918,446830770051	927,058842015991	933,073404646659	931,284867837815	922,800151281315	908,912206528959	890,421530895207	867,732709174838	841
		600	1181,50887587312	1179,03463203923	1171,59913056002	1159,11289018026	1141,29845612732	1117,59398299465	1087,4438526203	1053,29837002932	1039,84376880227	1020,39471432093	988,881345538963	936,15646406052	829,531231862953	905,247874412481	927,780370948259	930,635415312	923,572294751123	910,013296718409	891,366766177325	868,265553650129	841
		500	1182,15461063795	1179,87105351689	1173,02324477692	1161,61292049118	1145,65002210418	1125,27124309054	1101,19778306925	1075,94941366523	1055,02998100379	1031,76116460228	1002,23658542162	964,740651724838	924,630304122689	932,607228366275	938,150964965455	935,890303254361	926,826491236324	912,188094959787	892,752858989111	868,948914791907	841
		400	1183,35363518844	1181,25790215704	1174,99605008314	1164,65170044694	1150,40364425124	1132,62935973766	1112,11279844447	1090,25769610213	1068,55175248895	1045,36955320633	1019,54935536394	991,925428838085	967,628280080244	958,385945508033	952,312132836479	943,934517047222	931,641447523581	915,145908438858	894,493835570981	869,763422071946	841
		300	1184,7303013453	1182,79704538322	1177,03752849523	1167,58036250573	1154,66967025974	1138,71592870794	1120,35253041242	1100,40299535341	1079,5359551871	1057,60211591371	1034,6520295333	1011,76960372687	991,557617395727	976,98231629269	964,763279368764	951,880360118021	936,645048915479	918,24643124464	896,299328327566	870,597113468453	841
		200	1185,95965496988	1184,14862507888	1178,76283155238	1169,94872636459	1157,9649211176	1143,19832996549	1126,1645746874	1107,45197525557	1087,57313253587	1066,83710127168	1045,67321867223	1024,92951468393	1005,83644502666	989,208598441793	973,864483771421	958,164770684177	940,798132319228	920,881614840214	897,846108569745	871,311879017858	841
		100	1186,79724392001	1185,06114395361	1179,90262181436	1171,47296582621	1160,02913342412	1145,93407089259	1129,64163865968	1111,65337398914	1092,45367397269	1072,48611350846	1052,26040474356	1032,42496685351	1013,63622512875	996,137324219959	979,307462134507	962,102282071593	943,487270380599	922,6219627708	898,877787636897	871,790469576789	841
		0	1187,09320834648	1185,38226054474	1180,29972146881	1171,99755724533	1160,73075140366	1146,8533570646	1130,80071061315	1113,05238361219	1094,08825140087	1074,37944958946	1054,4434954836	1034,85989840137	1016,13233995841	998,383186718347	981,111934018612	963,435800630644	944,412879904333	923,227353769047	899,238785173811	871,958387195958	841
		q	0,00016695278689	0,000137029569501	3,71481304284447E-05	-1,4068433095935E-05	-3,55471427601184E-05	-3,73249744819449E-05	-2,80814220886215E-05	-1,77474991738754E-05	-1,43027386824986E-05	-1,41504243587842E-05	-1,37436201241803E-05	-1,46635510469634E-05	-2,23805479065977E-05	-4,06969924355249E-05	-6,537977845167E-05	-8,90908657542189E-05	-0,000105448520372	-0,000109835495955	-9,83364172676904E-05	-3,27729958025055E-05
			0	100	200	300	400	500	600	700	800	900	1000	1100	1200	1300	1400	1500	1600	1700	1800	1900	2000
H		1200	35	34,7	34,4	34,1	33,8	33,5	33,2	32,9	32,6	32,3	32	31,7	31,4	31,1	30,8	30,5	30,2	29,9	29,6	29,3	29	-0,0001305
		1100	34,6819946916389	34,5683673683946	34,3640037495848	34,1137521340136	33,8350563538068	33,5371392780915	33,2281941988842	32,9179812554953	32,6146244771805	32,3146031211133	32,0143162709627	31,7154190862744	31,4237585434253	31,1436194988591	30,8707573359867	30,5973670663981	30,3163890953331	30,0224475986126	29,7107392086348	29,3745688186633	29	-0,000325874872237
		1000	34,5312199853184	34,4682282126072	34,3139196707731	34,0950542164178	33,8275410543785	33,5226951659908	33,1943449027593	32,8652326294195	32,5615421913851	32,2645362427401	31,9617048675345	31,6575166354361	31,3694714048195	31,1130207149604	30,8745348571835	30,6340424177115	30,3765326437161	30,0924266666244	29,774580093492	29,4147807122471	29	-0,000360859219655
		900	34,4477651266052	34,4005659931058	34,2687944987027	34,0643708588105	33,7955834245915	33,4688476354386	33,0973837778815	32,7225944164757	32,4370891193477	32,155080291987	31,8445188835039	31,5169397556303	31,2168240198576	30,9977536803367	30,8133982997044	30,6201712184316	30,3947194763599	30,1263345144786	29,8090114421691	29,4365853983736	29	-0,000379829296585
		800	34,4002504271128	34,3587599223143	34,2368499616414	34,0374377141781	33,7595076051355	33,3959856955824	32,9383810529956	32,4242785218342	32,2439726751981	32,0085066421826	31,6774754209889	31,2808934887123	30,9147961676272	30,7807315341649	30,6945551088157	30,5715010369927	30,3877839197089	30,1396752265923	29,8271791700667	29,4487678468484	29	-0,000390428026758
		700	34,3772861686263	34,3386901868787	34,2229737279978	34,0283298015941	33,7464532176901	33,351889836769	32,7669261593383	31,7165985025672	32,0411951306222	31,8916721713325	31,5075196404977	30,942831199793	30,3058877245008	30,4476409926285	30,5462502550912	30,5169603309015	30,3776258335196	30,1481708653935	29,8399318178713	29,4573031551573	29	-0,000397853744987
		600	34,3730835956438	34,3370737256282	34,228630275838	34,0457470204467	33,783109035838	33,4304349806377	32,9764135803198	32,4545585400468	32,2466086403249	31,9436177400263	31,4464838342693	30,5966740686062	28,8015838429582	30,0873374430587	30,4594873717247	30,506317629501	30,3903322579916	30,1664266481532	29,8557660457293	29,4663461197707	29	-0,000405721124201
		500	34,3824753419231	34,3492511347321	34,2494269262556	34,0824429947617	33,8474522247123	33,5450628720613	33,1843002498056	32,8016678488341	32,4812250539261	32,1210392827237	31,6581203709509	31,0602744953234	30,4077342813089	30,5386186388035	30,6292501534963	30,5923242538772	30,4438251741847	30,2024518037822	29,8789701795278	29,4779394597368	29	-0,000415807329971
		400	34,3999074880797	34,3694326714456	34,2782153864979	34,1269937212016	33,9176008032885	33,6545592711843	33,3483552584603	33,0190505027344	32,6887098627179	32,3321752006624	31,9303829504744	31,4948476554195	31,1067240332415	30,9578091199625	30,8595549682182	30,7235173287048	30,5228020916098	30,2513786204672	29,9080898014397	29,4917517633651	29	-0,000427824034128
		300	34,4199114081559	34,3918165467197	34,3079805365345	34,1698750730191	33,9804306956186	33,744865219881	33,4716675774067	33,1723227307557	32,8562924747619	32,520795130404	32,1660073607729	31,8083260126475	31,4890078820487	31,2567163389357	31,0606387469537	30,8525584047421	30,6046573075975	30,3025812637247	29,9382586054628	29,5058826925827	29	-0,000440117942547
		200	34,4377649531714	34,41146066471	34,3331156691667	34,2045132455439	34,0288836301986	33,8112160379583	33,5583756264721	33,2784010321344	32,9783737096884	32,6624723692447	32,336870885604	32,0145203725423	31,7149246416677	31,4516867344471	31,2068018831059	30,9542367162264	30,672432774712	30,3460312864831	29,9640803057552	29,517992462528	29	-0,000450653442399
		100	34,4499237142843	34,4247170497247	34,349710651101	34,2267872553971	34,0592004225602	33,8516479789771	33,6101419018081	33,3414662843304	33,0522869703852	32,7488337732576	32,4385635431589	32,1313704477962	31,8376542026693	31,5616432433414	31,2938885748401	31,0177736478876	30,7162378943223	30,3746928012581	29,9812906266041	29,5260981095842	29	-0,000457705355338
		0	34,4542190209919	34,4293807749245	34,355490412288	34,234449860416	34,0694988428603	33,8652234167236	33,6273803709588	33,3624397131293	33,0770048734898	32,7777279503851	32,472195729325	32,169238387027	31,8768307703011	31,5972021976368	31,32270636485	31,0392622436591	30,7313013050917	30,3846565517704	29,9873104024654	29,5289415183809	29	-0,000230089560496
bilans		e SDx^2	0,014449768043197
		Qs1	-0,002777777777778
		Qs2	-0,005555555555556
		Qrz	-0,000412440932939
		Qj	-0,004813263949301
		bilans	0,000890729827623
		błąd	6,36%