Readyuse-Perforated Plate.xlsx

	A	B	C	D	E	F	H	I	J
1	Detailed CFD Model					Porous CFD Model
2
3
4
5
6
7
8
9
10
11
12
13									User input
14	t								Calculation output
15									Comparison
16
17
18
19
20
21
22	Abbreviations						Perforated Plate and Fluid Properties
23	d	Darcy coefficient		mu	dynamic viscosity [kg/m-s]		L	0.004	[m]
24	f	Forchheimer coefficient		L	thickness of porous medium [m]		mu	0.0000183	[kg/m-s]
25	dP	Pressure loss [Pa]		rho	density of fluid [kg/m3]		rho	1.1965	[kg/m³]
26	u	velocity [m/s]		S	Pressure gradient [Pa/m]
27
28	Detailed CFD results (No modelling)				Extracted Coefficients			You can use Trendline function (2nd degree polynomial) to predict A and B with a slight error
29	u	dP			Use a curve-fitting software or spreadsheet solver with the following fit method:
30	1	9.88
31	2	33.62
32	4	123.33
33	8	478.56
34	16	1852.84			Extract A and B constants from the user defined curve
35					A	3.85
36					B	7.01
37	Comparison of Results from different Approach				Darcy and Forchheimer coefficients are calculated as follows
38		SimScale (Detailed CFD)	Analytical		d	52595628.42
39	u	dP	dP		f	2929.377351
40	1	9.88	10.86
41	2	33.62	35.74
42	4	123.33	127.56
43	8	478.56	479.44
44	16	1852.84	1856.16
45
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