5G Throughput Calculation.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	FR	Constant Value (Mbps Conversion)	Bandwidth	Numerology	SubCarrier spacing	Carrier component	PRB	No of Tx	No of Rx	Modulated Symbol	scaling factor	Coding efficiency	Overhead-DL	Overhead-UL	DL Throughput (Mbps)	UL Throughput(Mbps)	TDD Frame Structure	DL Slots (%)	UL Slots (%)	TDD_DL throughput (Mbps)	TDD_UL throughput(Mbps)
2	FR1	0.000001	5	0	15	1	25	8	8	8	1	0.92578125	0.14	0.08	214.011	228.942	33	14	0.8571428571	2996.154	196.236
3	FR1	0.000001	10	0	15	1	52	8	8	8	1	0.92578125	0.14	0.08	445.14288	476.19936	33	14	0.8571428571	6232.00032	408.17088
4	FR1	0.000001	15	0	15	1	79	8	8	8	1	0.92578125	0.14	0.08	676.27476	723.45672	33	14	0.8571428571	9467.84664	620.10576
5	FR1	0.000001	20	0	15	1	106	8	8	8	1	0.92578125	0.14	0.08	907.40664	970.71408	33	14	0.8571428571	12703.69296	832.04064
6	FR1	0.000001	25	0	15	1	133	8	8	8	1	0.92578125	0.14	0.08	1138.53852	1217.97144	33	14	0.8571428571	15939.53928	1043.97552
7	FR1	0.000001	30	0	15	1	160	8	8	8	1	0.92578125	0.14	0.08	1369.6704	1465.2288	33	14	0.8571428571	19175.3856	1255.9104
8	FR1	0.000001	40	0	15	1	216	8	8	8	1	0.92578125	0.14	0.08	1849.05504	1978.05888	33	14	0.8571428571	25886.77056	1695.47904
9	FR1	0.000001	50	0	15	1	270	8	8	8	1	0.92578125	0.14	0.08	2311.3188	2472.5736	33	14	0.8571428571	32358.4632	2119.3488
10	FR1	0.000001	5	1	30	1	11	8	8	8	1	0.92578125	0.14	0.08	188.32968	201.46896	33	14	0.8571428571	2636.61552	172.68768
11	FR1	0.000001	10	1	30	1	24	8	8	8	1	0.92578125	0.14	0.08	410.90112	439.56864	33	14	0.8571428571	5752.61568	376.77312
12	FR1	0.000001	15	1	30	1	38	8	8	8	1	0.92578125	0.14	0.08	650.59344	695.98368	33	14	0.8571428571	9108.30816	596.55744
13	FR1	0.000001	20	1	30	1	51	8	8	8	1	0.92578125	0.14	0.08	873.16488	934.08336	33	14	0.8571428571	12224.30832	800.64288
14	FR1	0.000001	25	1	30	1	65	8	8	8	1	0.92578125	0.14	0.08	1112.8572	1190.4984	33	14	0.8571428571	15580.0008	1020.4272
15	FR1	0.000001	30	1	30	1	78	8	8	8	1	0.92578125	0.14	0.08	1335.42864	1428.59808	33	14	0.8571428571	18696.00096	1224.51264
16	FR1	0.000001	40	1	30	1	106	8	8	8	1	0.92578125	0.14	0.08	1814.81328	1941.42816	33	14	0.8571428571	25407.38592	1664.08128
17	FR1	0.000001	50	1	30	1	133	8	8	8	1	0.92578125	0.14	0.08	2277.07704	2435.94288	10	14	0.07142857143	31879.07856	173.99592
18	FR1	0.000001	60	1	30	1	162	8	8	8	1	0.92578125	0.14	0.08	2773.58256	2967.08832	33	14	0.8571428571	38830.15584	2543.21856
19	FR1	0.000001	70	1	30	1	189	8	8	8	1	0.92578125	0.14	0.08	3235.84632	3461.60304	33	14	0.8571428571	45301.84848	2967.08832
20	FR1	0.000001	80	1	30	1	217	8	8	8	1	0.92578125	0.14	0.08	3715.23096	3974.43312	33	14	0.8571428571	52013.23344	3406.65696
21	FR1	0.000001	90	1	30	1	245	8	8	8	1	0.92578125	0.14	0.08	4194.6156	4487.2632	33	14	0.8571428571	58724.6184	3846.2256
22	FR1	0.000001	100	1	30	1	273	8	8	8	1	0.92578125	0.14	0.08	4674.00024	5000.09328	33	14	0.8571428571	65436.00336	4285.79424
23	FR1	0.000001	10	2	60	1	11	8	8	8	1	0.92578125	0.14	0.08	376.65936	402.93792	33	14	0.8571428571	5273.23104	345.37536
24	FR1	0.000001	15	2	60	1	18	8	8	8	1	0.92578125	0.14	0.08	616.35168	659.35296	33	14	0.8571428571	8628.92352	565.15968
25	FR1	0.000001	20	2	60	1	24	8	8	8	1	0.92578125	0.14	0.08	821.80224	879.13728	33	14	0.8571428571	11505.23136	753.54624
26	FR1	0.000001	25	2	60	1	31	8	8	8	1	0.92578125	0.14	0.08	1061.49456	1135.55232	33	14	0.8571428571	14860.92384	973.33056
27	FR1	0.000001	30	2	60	1	38	8	8	8	1	0.92578125	0.14	0.08	1301.18688	1391.96736	33	14	0.8571428571	18216.61632	1193.11488
28	FR1	0.000001	40	2	60	1	51	8	8	8	1	0.92578125	0.14	0.08	1746.32976	1868.16672	33	14	0.8571428571	24448.61664	1601.28576
29	FR1	0.000001	50	2	60	1	65	8	8	8	1	0.92578125	0.14	0.08	2225.7144	2380.9968	33	14	0.8571428571	31160.0016	2040.8544
30	FR1	0.000001	60	2	60	1	79	8	8	8	1	0.92578125	0.14	0.08	2705.09904	2893.82688	33	14	0.8571428571	37871.38656	2480.42304
31	FR1	0.000001	70	2	60	1	93	8	8	8	1	0.92578125	0.14	0.08	3184.48368	3406.65696	33	14	0.8571428571	44582.77152	2919.99168
32	FR1	0.000001	80	2	60	1	107	8	8	8	1	0.92578125	0.14	0.08	3663.86832	3919.48704	33	14	0.8571428571	51294.15648	3359.56032
33	FR1	0.000001	90	2	60	1	121	8	8	8	1	0.92578125	0.14	0.08	4143.25296	4432.31712	33	14	0.8571428571	58005.54144	3799.12896
34	FR1	0.000001	100	2	60	1	135	8	8	8	1	0.92578125	0.14	0.08	4622.6376	4945.1472	33	14	0.8571428571	64716.9264	4238.6976
35	FR2	0.000001	50	2	60	1	66	8	8	8	1	0.92578125	0.18	0.1	2154.84192	2365.0704	33	14	0.8571428571	30167.78688	2027.2032
36	FR2	0.000001	100	2	60	1	132	8	8	8	1	0.92578125	0.18	0.1	4309.68384	4730.1408	33	14	0.8571428571	60335.57376	4054.4064
37	FR2	0.000001	200	2	60	1	264	8	8	8	1	0.92578125	0.18	0.1	8619.36768	9460.2816	33	14	0.8571428571	120671.1475	8108.8128
38	FR2	0.000001	50	3	120	1	32	8	8	8	1	0.92578125	0.18	0.1	2089.54368	2293.4016	33	14	0.8571428571	29253.61152	1965.7728
39	FR2	0.000001	100	3	120	1	66	8	8	8	1	0.92578125	0.18	0.1	4309.68384	4730.1408	33	14	0.8571428571	60335.57376	4054.4064
40	FR2	0.000001	200	3	120	1	132	8	8	8	1	0.92578125	0.18	0.1	8619.36768	9460.2816	33	14	0.8571428571	120671.1475	8108.8128
41	FR2	0.000001	400	3	120	1	264	8	8	8	1	0.92578125	0.18	0.1	17238.73536	18920.5632	33	14	0.8571428571	241342.295	16217.6256
42
43
44		can be changed as per requireent
45		Fixed
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100