---

Overview

Studnie
depresja w s1
Depresja w pkt
Wykres przestrzenny
Wykres płaski

---

Sheet 1: Studnie

	w komórki w tej kolumnie wpisz i-ty numery studni	w komórki w tej kolumnie wpisz współ- rzędną X i-tej studni	w komórki w tej kolumnie wpisz współ- rzędną Y i-tej studni	w komórki w tej kolumnie wpisz wydajność i-tej studni (jeśli studnie mają różne wydatki, usuń formułę)	Wyznaczanie depresji dla grupy współpracujących studni
	Dane dodatkowe
	podaj wartość współczynnika odsączalności
	podaj wartość wodoprzewodności
	podaj czas pompowania
	Dane
	współcz. odsączalności m :			0.01
	wodoprzewodność T [m2/doba] :			200
	czas pompowania t [doba] :			10
		współrzędne studni		Q [m3/doba]
		x [m]	y [m]
	1	0	0	250
	2	0	10	250
	3	0	20	250
	4	0	30	250
	5	0	40	250
	6	0	50	250
	7	10	50	250
	8	20	50	250
	9	30	50	250	promień r	1.0	[m]
	10	40	0	250
	11	30	0	250
	12	20	0	250
	13	10	0	250
	14	40	50	250
	15	50	40	250
	16	50	30	250
	17	50	20	250
	18	50	10	250
	19	50	0	250
	20	50	50	250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
				250
	koniec zakresu
	Dane

---

Sheet 2: depresja w s1

Obliczenie depresji w wybranym punkcie
współrzędne punktu
x :		25	[m]
y :		15	[m]
Wartość depresji :		25.0765313573209
podaj współrzędne punktu

---

Sheet 3: Depresja w pkt

podaj skok siatki wykresu
podaj współrzędne punktu początkowego wykresu (możliwe wartości ujemne)
			dy	10	[m]
			dx	10	[m]	TABELA DANYCH OK
			x / y	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40																																																													koniec
				0	10	20	30	40	50	60	70	80	90	100	110	120	130	140	150	160	170	180	190	200	210	220	230	240	250	260	270	280	290	300	310	320	330	340	350	360	370	380	390
39		1	0	24.2840	25.1061	25.3952	25.3952	25.1061	24.2840	22.0279	20.4784	19.1762	18.0425	17.0389	16.1404	15.3287	14.5900	13.9133	13.2898	12.7124	12.1754	11.6740	11.2042	10.7626	10.3464	9.9531	9.5807	9.2274	8.8915	8.5716	8.2666	7.9753	7.6968	7.4302	7.1747	6.9296	6.6944	6.4683	6.2510	6.0419	5.8405	5.6465	5.4595
39		2	10	25.1061	24.9785	25.0818	25.0818	24.9785	25.1061	22.7743	21.0396	19.5972	18.3646	17.2908	16.3416	15.4925	14.7255	14.0269	13.3864	12.7954	12.2474	11.7369	11.2596	10.8118	10.3903	9.9925	9.6162	9.2595	8.9207	8.5983	8.2910	7.9977	7.7174	7.4492	7.1923	6.9459	6.7095	6.4824	6.2641	6.0541	5.8520	5.6573	5.4696
		3	20	25.3952	25.0818	25.0706	25.0706	25.0818	25.3952	23.1066	21.3202	19.8153	18.5325	17.4218	16.4456	15.5767	14.7949	14.0850	13.4355	12.8375	12.2839	11.7688	11.2877	10.8366	10.4125	10.0124	9.6341	9.2757	8.9354	8.6117	8.3032	8.0089	7.7277	7.4587	7.2011	6.9541	6.7171	6.4895	6.2707	6.0603	5.8577	5.6627	5.4747
		4	30	25.3951772743758	25.0818	25.0706	25.0706	25.0818	25.3952	23.1066	21.3202	19.8153	18.5325	17.4218	16.4456	15.5767	14.7949	14.0850	13.4355	12.8375	12.2839	11.7688	11.2877	10.8366	10.4125	10.0124	9.6341	9.2757	8.9354	8.6117	8.3032	8.0089	7.7277	7.4587	7.2011	6.9541	6.7171	6.4895	6.2707	6.0603	5.8577	5.6627	5.4747
		5	40	25.1061	24.9785	25.0818	25.0818	24.9785	25.1061	22.7743	21.0396	19.5972	18.3646	17.2908	16.3416	15.4925	14.7255	14.0269	13.3864	12.7954	12.2474	11.7369	11.2596	10.8118	10.3903	9.9925	9.6162	9.2595	8.9207	8.5983	8.2910	7.9977	7.7174	7.4492	7.1923	6.9459	6.7095	6.4824	6.2641	6.0541	5.8520	5.6573	5.4696
		6	50	24.2840	25.1061	25.3952	25.3952	25.1061	24.2840	22.0279	20.4784	19.1762	18.0425	17.0389	16.1404	15.3287	14.5900	13.9133	13.2898	12.7124	12.1754	11.6740	11.2042	10.7626	10.3464	9.9531	9.5807	9.2274	8.8915	8.5716	8.2666	7.9753	7.6968	7.4302	7.1747	6.9296	6.6944	6.4683	6.2510	6.0419	5.8405	5.6465	5.4595
		7	60	22.0279	22.7743	23.1066	23.1066	22.7743	22.0279	20.8828	19.6919	18.5935	17.5942	16.6849	15.8549	15.0945	14.3949	13.7486	13.1492	12.5912	12.0699	11.5815	11.1224	10.6899	10.2815	9.8948	9.5281	9.1797	8.8481	8.5320	8.2303	7.9420	7.6661	7.4018	7.1485	6.9053	6.6718	6.4473	6.2314	6.0235	5.8234	5.6305	5.4445
		8	70	20.4784	21.0396	21.3202	21.3202	21.0396	20.4784	19.6919	18.8042	17.9124	17.0578	16.2535	15.5021	14.8016	14.1487	13.5392	12.9693	12.4352	11.9336	11.4615	11.0162	10.5953	10.1967	9.8185	9.4591	9.1170	8.7910	8.4799	8.1825	7.8980	7.6256	7.3644	7.1138	6.8732	6.6419	6.4195	6.2054	5.9993	5.8007	5.6092	5.4245
		9	80	19.1762	19.5972	19.8153	19.8153	19.5972	19.1762	18.5935	17.9124	17.1922	16.4714	15.7707	15.1001	14.4632	13.8609	13.2922	12.7555	12.2488	11.7699	11.3168	10.8875	10.4802	10.0933	9.7253	9.3747	9.0403	8.7210	8.4158	8.1237	7.8439	7.5757	7.3183	7.0710	6.8335	6.6050	6.3851	6.1733	5.9693	5.7726	5.5829	5.3998
		10	90	18.0425	18.3646	18.5325	18.5325	18.3646	18.0425	17.5942	17.0578	16.4714	15.8650	15.2590	14.6657	14.0919	13.5413	13.0151	12.5137	12.0364	11.5823	11.1501	10.7387	10.3468	9.9731	9.6165	9.2759	8.9503	8.6388	8.3404	8.0544	7.7801	7.5167	7.2637	7.0204	6.7864	6.5612	6.3442	6.1352	5.9336	5.7392	5.5515	5.3704
		11	100	17.0389	17.2908	17.4218	17.4218	17.2908	17.0389	16.6849	16.2535	15.7707	15.2590	14.7357	14.2131	13.6991	13.1989	12.7152	12.2497	11.8028	11.3746	10.9647	10.5724	10.1970	9.8377	9.4937	9.1641	8.8482	8.5453	8.2545	7.9754	7.7071	7.4493	7.2012	6.9624	6.7324	6.5109	6.2973	6.0913	5.8925	5.7007	5.5154	5.3365
		12	110	16.1404	16.3416	16.4456	16.4456	16.3416	16.1404	15.8549	15.5021	15.1001	14.6657	14.2131	13.7533	13.2943	12.8416	12.3990	11.9688	11.5524	11.1506	10.7635	10.3911	10.0330	9.6889	9.3582	9.0405	8.7350	8.4414	8.1590	7.8872	7.6257	7.3738	7.1312	6.8973	6.6718	6.4543	6.2445	6.0419	5.8463	5.6573	5.4747	5.2982
		13	120	15.3287	15.4925	15.5767	15.5767	15.4925	15.3287	15.0945	14.8016	14.4632	14.0919	13.6991	13.2943	12.8847	12.4759	12.0721	11.6759	11.2894	10.9137	10.5495	10.1972	9.8569	9.5285	9.2117	8.9063	8.6119	8.3281	8.0545	7.7907	7.5363	7.2909	7.0541	6.8256	6.6050	6.3919	6.1861	5.9873	5.7951	5.6092	5.4295	5.2557
		14	130	14.5900	14.7255	14.7949	14.7949	14.7255	14.5900	14.3949	14.1487	13.8609	13.5413	13.1989	12.8416	12.4759	12.1071	11.7392	11.3752	11.0173	10.6671	10.3255	9.9933	9.6709	9.3584	9.0558	8.7631	8.4801	8.2065	7.9421	7.6866	7.4398	7.2012	6.9707	6.7478	6.5324	6.3240	6.1226	5.9277	5.7392	5.5567	5.3802	5.2093
		15	140	13.9133	14.0269	14.0850	14.0850	14.0269	13.9133	13.7486	13.5392	13.2922	13.0151	12.7152	12.3990	12.0721	11.7392	11.4043	11.0703	10.7394	10.4136	10.0940	9.7815	9.4767	9.1801	8.8918	8.6120	8.3406	8.0775	7.8226	7.5758	7.3367	7.1053	6.8813	6.6644	6.4544	6.2510	6.0542	5.8635	5.6789	5.5001	5.3269	5.1590
		16	150	13.2898	13.3864	13.4355	13.4355	13.3864	13.2898	13.1492	12.9693	12.7555	12.5137	12.2497	11.9688	11.6759	11.3752	11.0703	10.7639	10.4585	10.1557	9.8572	9.5638	9.2763	8.9954	8.7213	8.4543	8.1946	7.9422	7.6970	7.4589	7.2279	7.0038	6.7865	6.5758	6.3714	6.1733	5.9813	5.7951	5.6145	5.4395	5.2698	5.1053
		17	160	12.7124	12.7954	12.8375	12.8375	12.7954	12.7124	12.5912	12.4352	12.2488	12.0364	11.8028	11.5524	11.2894	11.0173	10.7394	10.4585	10.1766	9.8956	9.6170	9.3419	9.0712	8.8056	8.5455	8.2913	8.0432	7.8014	7.5659	7.3368	7.1140	6.8974	6.6869	6.4825	6.2840	6.0913	5.9042	5.7226	5.5464	5.3753	5.2093	5.0481
		18	170	12.1754	12.2474	12.2839	12.2839	12.2474	12.1754	12.0699	11.9336	11.7699	11.5823	11.3746	11.1506	10.9137	10.6671	10.4136	10.1557	9.8956	9.6349	9.3752	9.1175	8.8629	8.6121	8.3656	8.1239	7.8874	7.6561	7.4304	7.2101	6.9955	6.7865	6.5831	6.3851	6.1926	6.0054	5.8234	5.6466	5.4747	5.3077	5.1455	4.9879
		19	180	11.6740	11.7369	11.7688	11.7688	11.7369	11.6740	11.5815	11.4615	11.3168	11.1501	10.9647	10.7635	10.5495	10.3255	10.0940	9.8572	9.6170	9.3752	9.1331	8.8920	8.6527	8.4161	8.1828	7.9533	7.7280	7.5072	7.2910	7.0797	6.8733	6.6719	6.4755	6.2840	6.0976	5.9160	5.7392	5.5672	5.3998	5.2371	5.0788	4.9248
		20	190	11.2042	11.2596	11.2877	11.2877	11.2596	11.2042	11.1224	11.0162	10.8875	10.7387	10.5724	10.3911	10.1972	9.9933	9.7815	9.5638	9.3419	9.1175	8.8920	8.6663	8.4416	8.2186	7.9980	7.7803	7.5660	7.3553	7.1486	6.9461	6.7479	6.5540	6.3647	6.1798	5.9994	5.8234	5.6519	5.4848	5.3221	5.1636	5.0093	4.8591
		21	200	10.7626	10.8118	10.8366	10.8366	10.8118	10.7626	10.6899	10.5953	10.4802	10.3468	10.1970	10.0330	9.8569	9.6709	9.4767	9.2763	9.0712	8.8629	8.6527	8.4416	8.2306	8.0206	7.8121	7.6058	7.4020	7.2013	7.0039	6.8100	6.6198	6.4335	6.2511	6.0727	5.8984	5.7282	5.5620	5.3999	5.2417	5.0876	4.9373	4.7909
		22	210	10.3464	10.3903	10.4125	10.4125	10.3903	10.3464	10.2815	10.1967	10.0933	9.9731	9.8377	9.6889	9.5285	9.3584	9.1801	8.9954	8.8056	8.6121	8.4161	8.2186	8.0206	7.8228	7.6258	7.4304	7.2369	7.0458	6.8574	6.6719	6.4896	6.3107	6.1352	5.9634	5.7951	5.6305	5.4697	5.3125	5.1591	5.0093	4.8632	4.7206
		23	220	9.9531	9.9925	10.0124	10.0124	9.9925	9.9531	9.8948	9.8185	9.7253	9.6165	9.4937	9.3582	9.2117	9.0558	8.8918	8.7213	8.5455	8.3656	8.1828	7.9980	7.8121	7.6258	7.4399	7.2549	7.0712	6.8894	6.7097	6.5324	6.3579	6.1862	6.0176	5.8521	5.6898	5.5309	5.3753	5.2232	5.0744	4.9290	4.7870	4.6484
		24	230	9.5807	9.6162	9.6341	9.6341	9.6162	9.5807	9.5281	9.4591	9.3747	9.2759	9.1641	9.0405	8.9063	8.7631	8.6120	8.4543	8.2913	8.1239	7.9533	7.7803	7.6058	7.4304	7.2549	7.0797	6.9055	6.7326	6.5613	6.3920	6.2250	6.0604	5.8984	5.7392	5.5829	5.4296	5.2793	5.1320	4.9879	4.8469	4.7091	4.5744
		25	240	9.2274	9.2595	9.2757	9.2757	9.2595	9.2274	9.1797	9.1170	9.0403	8.9503	8.8482	8.7350	8.6119	8.4801	8.3406	8.1946	8.0432	7.8874	7.7280	7.5660	7.4020	7.2369	7.0712	6.9055	6.7402	6.5758	6.4127	6.2511	6.0914	5.9337	5.7782	5.6252	5.4747	5.3269	5.1818	5.0395	4.9000	4.7634	4.6297	4.4989
		26	250	8.8915	8.9207	8.9354	8.9354	8.9207	8.8915	8.8481	8.7910	8.7210	8.6388	8.5453	8.4414	8.3281	8.2065	8.0775	7.9422	7.8014	7.6561	7.5072	7.3553	7.2013	7.0458	6.8894	6.7326	6.5758	6.4196	6.2643	6.1101	5.9574	5.8064	5.6574	5.5104	5.3656	5.2232	5.0832	4.9457	4.8108	4.6786	4.5490	4.4220
		27	260	8.5716	8.5983	8.6117	8.6117	8.5983	8.5716	8.5320	8.4799	8.4158	8.3404	8.2545	8.1590	8.0545	7.9421	7.8226	7.6970	7.5659	7.4304	7.2910	7.1486	7.0039	6.8574	6.7097	6.5613	6.4127	6.2643	6.1164	5.9693	5.8235	5.6790	5.5361	5.3949	5.2558	5.1186	4.9837	4.8510	4.7206	4.5927	4.4672	4.3441
		28	270	8.2666	8.2910	8.3032	8.3032	8.2910	8.2666	8.2303	8.1825	8.1237	8.0544	7.9754	7.8872	7.7907	7.6866	7.5758	7.4589	7.3368	7.2101	7.0797	6.9461	6.8100	6.6719	6.5324	6.3920	6.2511	6.1101	5.9693	5.8292	5.6898	5.5516	5.4147	5.2793	5.1455	5.0136	4.8836	4.7556	4.6297	4.5060	4.3845	4.2652
		29	280	7.9753	7.9977	8.0089	8.0089	7.9977	7.9753	7.9420	7.8980	7.8439	7.7801	7.7071	7.6257	7.5363	7.4398	7.3367	7.2279	7.1140	6.9955	6.8733	6.7479	6.6198	6.4896	6.3579	6.2250	6.0914	5.9574	5.8235	5.6898	5.5568	5.4246	5.2935	5.1636	5.0352	4.9083	4.7831	4.6597	4.5381	4.4186	4.3011	4.1856
		30	290	7.6968	7.7174	7.7277	7.7277	7.7174	7.6968	7.6661	7.6256	7.5757	7.5167	7.4493	7.3738	7.2909	7.2012	7.1053	7.0038	6.8974	6.7865	6.6719	6.5540	6.4335	6.3107	6.1862	6.0604	5.9337	5.8064	5.6790	5.5516	5.4246	5.2982	5.1727	5.0482	4.9248	4.8029	4.6824	4.5635	4.4462	4.3308	4.2172	4.1055
		31	300	7.4302	7.4492	7.4587	7.4587	7.4492	7.4302	7.4018	7.3644	7.3183	7.2637	7.2012	7.1312	7.0541	6.9707	6.8813	6.7865	6.6869	6.5831	6.4755	6.3647	6.2511	6.1352	6.0176	5.8984	5.7782	5.6574	5.5361	5.4147	5.2935	5.1727	5.0525	4.9332	4.8148	4.6976	4.5817	4.4672	4.3541	4.2427	4.1329	4.0249
		32	310	7.1747	7.1923	7.2011	7.2011	7.1923	7.1747	7.1485	7.1138	7.0710	7.0204	6.9624	6.8973	6.8256	6.7478	6.6644	6.5758	6.4825	6.3851	6.2840	6.1798	6.0727	5.9634	5.8521	5.7392	5.6252	5.5104	5.3949	5.2793	5.1636	5.0482	4.9332	4.8188	4.7053	4.5927	4.4812	4.3709	4.2620	4.1545	4.0485	3.9441
		33	320	6.9296	6.9459	6.9541	6.9541	6.9459	6.9296	6.9053	6.8732	6.8335	6.7864	6.7324	6.6718	6.6050	6.5324	6.4544	6.3714	6.2840	6.1926	6.0976	5.9994	5.8984	5.7951	5.6898	5.5829	5.4747	5.3656	5.2558	5.1455	5.0352	4.9248	4.8148	4.7053	4.5964	4.4883	4.3811	4.2750	4.1700	4.0663	3.9640	3.8631
		34	330	6.6944	6.7095	6.7171	6.7171	6.7095	6.6944	6.6718	6.6419	6.6050	6.5612	6.5109	6.4543	6.3919	6.3240	6.2510	6.1733	6.0913	6.0054	5.9160	5.8234	5.7282	5.6305	5.5309	5.4296	5.3269	5.2232	5.1186	5.0136	4.9083	4.8029	4.6976	4.5927	4.4883	4.3845	4.2815	4.1794	4.0783	3.9784	3.8796	3.7822
		35	340	6.4683	6.4824	6.4895	6.4895	6.4824	6.4683	6.4473	6.4195	6.3851	6.3442	6.2973	6.2445	6.1861	6.1226	6.0542	5.9813	5.9042	5.8234	5.7392	5.6519	5.5620	5.4697	5.3753	5.2793	5.1818	5.0832	4.9837	4.8836	4.7831	4.6824	4.5817	4.4812	4.3811	4.2815	4.1825	4.0843	3.9870	3.8907	3.7955	3.7014
		36	350	6.2510	6.2641	6.2707	6.2707	6.2641	6.2510	6.2314	6.2054	6.1733	6.1352	6.0913	6.0419	5.9873	5.9277	5.8635	5.7951	5.7226	5.6466	5.5672	5.4848	5.3999	5.3125	5.2232	5.1320	5.0395	4.9457	4.8510	4.7556	4.6597	4.5635	4.4672	4.3709	4.2750	4.1794	4.0843	3.9899	3.8963	3.8035	3.7117	3.6209
		37	360	6.0419	6.0541	6.0603	6.0603	6.0541	6.0419	6.0235	5.9993	5.9693	5.9336	5.8925	5.8463	5.7951	5.7392	5.6789	5.6145	5.5464	5.4747	5.3998	5.3221	5.2417	5.1591	5.0744	4.9879	4.9000	4.8108	4.7206	4.6297	4.5381	4.4462	4.3541	4.2620	4.1700	4.0783	3.9870	3.8963	3.8062	3.7168	3.6283	3.5407
		38	370	5.8405	5.8520	5.8577	5.8577	5.8520	5.8405	5.8234	5.8007	5.7726	5.7392	5.7007	5.6573	5.6092	5.5567	5.5001	5.4395	5.3753	5.3077	5.2371	5.1636	5.0876	5.0093	4.9290	4.8469	4.7634	4.6786	4.5927	4.5060	4.4186	4.3308	4.2427	4.1545	4.0663	3.9784	3.8907	3.8035	3.7168	3.6308	3.5455	3.4610
		39	380	5.6465	5.6573	5.6627	5.6627	5.6573	5.6465	5.6305	5.6092	5.5829	5.5515	5.5154	5.4747	5.4295	5.3802	5.3269	5.2698	5.2093	5.1455	5.0788	5.0093	4.9373	4.8632	4.7870	4.7091	4.6297	4.5490	4.4672	4.3845	4.3011	4.2172	4.1329	4.0485	3.9640	3.8796	3.7955	3.7117	3.6283	3.5455	3.4633	3.3819
		40	390	5.4595	5.4696	5.4747	5.4747	5.4696	5.4595	5.4445	5.4245	5.3998	5.3704	5.3365	5.2982	5.2557	5.2093	5.1590	5.1053	5.0481	4.9879	4.9248	4.8591	4.7909	4.7206	4.6484	4.5744	4.4989	4.4220	4.3441	4.2652	4.1856	4.1055	4.0249	3.9441	3.8631	3.7822	3.7014	3.6209	3.5407	3.4610	3.3819	3.3034
		koniec

---

Sheet 4: Wykres przestrzenny

---

Sheet 5: Wykres płaski