---

Overview

If=f(Uf) d1
If=f(Uf) d2
Układ 1
Ir=f(Ur) d1
Ir=f(Ur) d2
Układ 2
Us=f(U) d1
Coś jeszcze
Us=f(Is) d2 15, 20V
Us=f(Is) d1 15, 20V
Arkusz1
Układ 3

---

Sheet 1: If=f(Uf) d1

---

Sheet 2: If=f(Uf) d2

---

Sheet 3: Układ 1

	Dioda 1					Dioda 2
	If	Uf	Uwe			If	Uf	Uwe
	mA	V	V			mA	V	V
	0	0.208	0.209	#DIV/0!		0	0.223	0.224	#DIV/0!
	0	0.311	0.312	#DIV/0!		0	0.328	0.329	#DIV/0!
	0	0.403	0.405	#DIV/0!		0	0.397	0.4	#DIV/0!
5	0	0.39	0.599	#DIV/0!		0.05	0.557	0.602	11140
8	0.15	0.67	0.807	4466.66666666667		0.2	0.605	0.796	3025
12	0.35	0.692	1.004	1977.14285714286		0.42	0.628	1.028	1495.2380952381
16	0.55	0.704	1.213	1280		0.6	0.64	0.225	1066.66666666667
20	0.8	0.713	1.422	891.25		0.82	0.648	1.422	790.243902439024
24	1	0.719	1.607	719		1.1	0.654	1.598	594.545454545455
28	1.2	0.724	1.821	603.333333333333		1.38	0.661	1.817	478.985507246377
32	1.4	0.727	1.998	519.285714285714		1.55	0.666	2.036	429.677419354839
36	2.5	0.741	3.026	296.4		1.69	0.669	2.199	395.857988165681
40	3.7	0.75	4.03	202.702702702703		1.9	0.673	2.394	354.21052631579
44	5.8	0.753	6.01	129.827586206897		2.18	0.676	2.623	310.091743119266
48	8.2	0.756	8.033	92.1951219512195		3.7	0.692	4.008	187.027027027027
52	10.4	0.757	9.986	72.7884615384615		8.1	0.715	7.955	88.2716049382716
56	12.5	0.76	12.01	60.8		11.6	0.726	11.11	62.5862068965517
60	14.8	0.762	14.02	51.4864864864865		15	0.733	14.09	48.8666666666667
64	16.8	0.763	16.02	45.4166666666667		18.5	0.737	16.06	39.8378378378378
68	19.2	0.767	18	39.9479166666667		19.6	0.74	18.5	37.7551020408163
72	21.4	0.769	20.13	35.9345794392523		21.4	0.743	20.01	34.7196261682243
	23.4	0.77	22.08	32.9059829059829		23.6	0.746	22.08	31.6101694915254
	25.5	0.773	24.04	30.3137254901961		25.8	0.748	24.1	28.9922480620155
	27.6	0.776	26	28.1159420289855		28	0.751	26.03	26.8214285714286
	29.8	0.777	27.99	26.0738255033557		29.8	0.753	28.01	25.2684563758389
	31.5	0.778	29.47	24.6984126984127		31.2	0.754	29.44	24.1666666666667
							0.105	14.58
								7.20164609053498

---

Sheet 4: Ir=f(Ur) d1

---

Sheet 5: Ir=f(Ur) d2

---

Sheet 6: Układ 2

Dioda 1					Dioda 2
Ir	Ur				Ir	Ur
mA	V				mA	V
0	0.223	896.860986547085			0	0.217	921.658986175115
0.1	2.283	87.6040297853701			0.1	10.787	18.5408361917122
0.2	2.373	84.2815002107037			0.2	10.837	18.4552920549968
0.32	2.472	80.9061488673139			0.3	10.873	18.39418743677
0.41	2.542	78.6782061369001			0.4	10.897	18.3536753234835
0.5	2.61	76.6283524904215			0.5	10.972	18.22821728035
1.23	3.026	66.0938532716457			1.5	10.993	18.1933957973256
2.98	3.34	59.8802395209581			3.72	11.07	18.06684733514
5.33	3.566	56.0852495793606			4.82	11.103	18.0131495992074
7.25	3.71	53.9083557951483			5.94	11.13	17.9694519317161
9.37	3.75	53.3333333333333			8.06	11.174	17.8986933953821
11.5	3.79	52.7704485488127			9.05	11.195	17.8651183564091
13.7	3.848	51.975051975052			10.24	11.212	17.8380306814128
14.72	3.913	51.1116790186558			11.37	11.223	17.8205470907957
17.85	3.96	50.5050505050505			12.02	11.26	17.7619893428064
20.1	4.008	49.9001996007984			13.78	11.265	17.7541056369285
22.17	4.03	49.6277915632754			15.69	11.3	17.6991150442478
24.25	4.09	48.8997555012225			16.84	11.317	17.6725280551383
26.29	4.11	48.661800486618			17.95	11.332	17.6491351923756
27.8	4.16	48.0769230769231			19.35	11.35	17.6211453744493
	6.000	33.3333333333333
	7.000	28.5714285714286
	8.000	25
	9.000	22.2222222222222
	10.000	20				0	16.48
	11.000	18.1818181818182				15	0
	12.000	16.6666666666667
	13.000	15.3846153846154				0	21.978
	14.000	14.2857142857143				20	0
	15.000	13.3333333333333
	16.000	12.5

---

Sheet 7: Us=f(U) d1

---

Sheet 8: Coś jeszcze

Us = f(U),	R = 910 W,	R0 = 2,5 W
Dioda 1			Dioda 2
U	Us		U	Us
V	V		V	V
0.04	0.293		0.08	0.11
0.43	0.5		0.853	1.1
0.79	1.07		1.545	2.08
1.11	1.5		2.225	3.01
1.43	1.94		2.97	4.02
1.83	2.5		3.75	5.08
2.42	3.51		4.47	6.05
2.65	4		5.6	7.74
2.90	5		7.45	10.06
3.08	6.01		8.99	12.18
3.22	7.02		10.46	14.15
3.420	9.02		11.09	15.01
3.492	10.02		11.592	16.02
3.557	11.03		11.658	16.5
3.605	12		11.692	17.02
3.656	13.06		11.702	17.5
3.765	16.02		11.741	18
3.822	18.02		11.759	18.51
3.833	18.5		11.776	19.01
3.859	19.5		11.793	19.53
3.869	20		11.809	20
3.892	21		11.822	20.53
3.930	23		11.846	21.52
3.948	24		11.879	23.02
3.965	25		11.899	24
3.980	26		11.901	25

---

Sheet 9: Us=f(Is) d2 15, 20V

---

Sheet 10: Us=f(Is) d1 15, 20V

---

Sheet 11: Arkusz1

dioda 1 przewodz					dioda 2 przewodz					dioda 1 zapor					dioda 2 zapor
u	uf	if			u	uf	if			u	ur	ir			u	ur	ir
0.209	0.208	0.0			0.224	0.223	0.0			0.224	0.223	0.0			0.224	0.217	0.0
0.312	0.311	0.0			0.329	0.328	0.0			2.393	2.283	0.1			11.56	10.787	0.1
0.405	0.403	0.0			0.4	0.397	0.0			2.565	2.373	0.2			11.7	10.837	0.2
0.599	0.39	0.0			0.602	0.557	0.05			2.773	2.472	0.32			11.83	10.873	0.3
0.807	0.67	0.15			0.796	0.605	0.2			2.923	2.542	0.41			11.95	10.897	0.4
1.004	0.692	0.35			1.028	0.628	0.42			3.082	2.61	0.5			12.05	10.972	0.9
1.213	0.704	0.55			0.225	0.64	0.6			4.064	3.026	1.23			13.02	10.993	1.5
1.422	0.713	0.8			1.422	0.648	0.82			6.021	3.34	2.98			14.08	11.073	3.72
1.607	0.719	1.0			1.598	0.654	1.1			8.334	3.566	5.33			16.09	11.103	4.82
1.821	0.724	1.2			1.817	0.661	1.38			10.107	3.71	7.25			17.12	11.13	5.94
1.998	0.727	1.4			2.036	0.666	1.55			12.11	3.72	9.37			19.06	11.174	8.06
3.026	0.741	2.5			2.199	0.669	1.69			14.07	3.79	11.5			20.15	11.195	9.05
4.03	0.75	3.7			2.394	0.673	1.9			16.12	3.848	13.7			21.05	11.212	10.24
6.01	0.753	5.8			2.623	0.676	2.18			18.01	3.913	14.72			22.09	11.223	11.37
8.033	0.73	8.2			4.008	0.692	3.7			20.0	3.96	17.85			23.05	11.24	12.02
9.986	0.736	10.4			7.955	0.715	8.1			22.12	4.008	20.1			24.12	11.265	13.78
12.01	0.742	12.5			11.11	0.726	11.6			24.14	3.96	22.17			26.07	11.3	15.69
14.02	0.746	14.8			14.09	0.733	15.0			26.02	4.011	24.25			27.14	11.317	16.84
16.02	0.75	16.8			16.06	0.737	18.5			28.03	4.11	26.29			28.17	11.332	17.95
18.00	0.754	19.2			18.5	0.74	19.6			29.47	4.19	27.8			29.47	11.35	19.35
20.13	0.757	21.4			20.01	0.743	21.4
22.08	0.76	23.4			22.08	0.746	23.6
24.04	0.763	25.5			24.1	0.748	25.8
26.00	0.765	27.6			26.03	0.751	28.0
27.99	0.767	29.8			28.01	0.753	29.8										0	16.48
29.47	0.768	31.5			29.44	0.754	31.2										15	0
																	0	21.978
																	20	0

---

Sheet 12: Układ 3

Dioda 1 przy U=15V				Dioda 1 przy U=20V				Dioda 2 przy U=15V				Dioda 2 przy U=20V
R0	Us	Is			Us	Is		R0	Us	Is		R0	Us	Is
W	V	mA		W	V	mA		kW	V	mA		kW	V	mA
0	0.0254	16.6		0	0.031	21.18		0.00	0.065	16.69		0.0	0.00	22.14
100	1.512	14.9	1655.55453934096	100	2.020	19.05	2211.39212598425	0.20	2.796	13.65		0.2	3.68	18.17
200	2.663	13.2	1299.57251328777	200	3.207	15.02	1505.482689747	0.40	4.686	11.55		0.4	6.20	15.40
300	3.187	10.5	655.37321937322	300	3.538	11.2	443.894642857143	0.60	6.071	10.02		0.6	8.06	13.36
400	3.391	8.4	255.121140142518	400	3.657	8.7	153.195402298851	0.80	7.1	8.93		0.8	9.48	11.79
500	3.492	6.9	122.715728715729	500	3.720	7.08	77.4152542372883	1.00	7.967	7.90		1.0	10.60	10.64
600	3.552	5.9	70.7142857142858	600	3.756	5.96	42.7651006711405	1.20	8.65	7.14		1.4	11.67	9.30
700	3.591	5.1	44.9647058823531	700	3.781	5.14	28.9883268482494	1.40	9.056	6.64		1.8	11.81	6.50
800	3.618	4.5	30.6681514476611	800	3.797	4.52	18.1946902654867	1.60	9.672	6.00		2.0	11.81	5.85
900	3.639	4.0	23.5137157107231	900	3.810	4.03	14.5806451612902	2.00	10.41	5.16		2.4	11.80	4.89
1000	3.653	3.6	15.4655647382923	1000	3.820	3.62	11.1325966850826	2.40	10.974	4.54		2.8	11.82	4.20
1100	3.666	3.3	14.2567975830815	1200	3.835	3.04	17.8618421052633	2.80	11.407	4.04		3.2	11.83	3.67
1200	3.674	3.0	8.71052631578948	1400	3.845	2.61	11.6475095785443	3.20	11.567	3.58		3.6	11.85	3.27
1400	3.692	2.6	20.8854961832064	1600	3.852	2.29	7.97816593886426	3.60	11.628	3.20		4.0	11.85	2.94
1600	3.703	2.3	12.5851528384276	1800	3.858	2.04	6.73529411764731	4.00	11.657	2.89		5.0	11.86	2.35
2000	3.719	1.8	19.9130434782609	2000	3.863	1.83	5.57377049180316	4.50	11.68	2.57		6.0	11.87	1.96
2400	3.729	1.5	11.9480519480522	2500	3.871	1.47	9.9591836734694	5.00	11.69	2.32		7.0	11.98	1.68
3000	3.739	1.2	12.8333333333331	3000	3.876	1.22	6.0245901639343	6.00	11.71	1.93		8.0	11.88	1.47
3500	3.744	1.0	5.88235294117687	3500	3.879	1.05	3.48571428571442	7.00	11.73	1.65		10.0	11.89	1.17
4000	3.748	0.9	4.58426966292135	4000	3.882	0.92	3.42391304347839	8.00	11.73	1.45		12.0	11.89	0.97
4500	3.751	0.8	3.37974683544267	5000	3.886	0.79	4.65822784810127	10.00	11.74	1.16		14.0	11.89	0.83
5000	3.754	0.7	3.33802816901421	6000	3.888	0.61	2.59016393442594	12.00	11.75	0.96		16.0	11.90	0.73
7000	3.76	0.5	8.35294117647029	7000	3.890	0.52	2.34615384615411	14.00	11.76	0.82		20.0	11.90	0.58
9000	3.763	0.4	3.92307692307707	8000	3.891	0.45	1.15555555555543	18.00	11.76	0.64		25.0	11.90	0.46
12000	3.766	0.3	4.03448275862084	9000	3.892	0.4	1.12499999999988	30.00	11.77	0.38		30.0	11.90	0.38
16000	3.769	0.2	4.1428571428573	10000	3.893	0.36	1.11111111111099	50.00	11.78	0.22		40.0	11.91	0.28
20000	3.77	0.2	1.23529411764692	12000	3.894	0.3	1.2000000000004	80.00	11.78	0.14		60.0	11.91	0.19
30000	3.771	0.1	1.54545454545438	16000	3.896	0.22	2.72727272727243	150.00	11.78	0.07		80.0	11.91	0.14
40000	3.772	0.1	1.37499999999985	20000	3.897	0.17	1.29411764705868	350.00	11.78	0.02		100.0	11.91	0.11
60000	3.773	0.1	1.60000000000053	25000	3.897	0.14	0	670.00	11.78	0.00		50.0	11.91	0.07
100000	3.774	0.0	2.49999999999972	30000	3.898	0.11	1.2727272727277					250.0	11.91	0.04
150000	3.774	0.0	0	40000	3.898	0.08	0					350.0	11.91	0.02
250000	3.774	0.0	#DIV/0!	60000	3.898	0.05	0					550.0	11.91	0.01
				100000	3.899	0.03	1.66666666666648					670.0	11.91	0.00
				200000	3.899	0.01	0
				260000	3.899	0	#DIV/0!
0.00	15			20
16.50	0			0