Mass_Energy_Balance.xlsx

	A	B	C	D	E	F	H
1	Mass Balance — Mixer / Junction
2	chemenggcalc.com — multiple inlet streams → one outlet. Basis: mass flow (kg/h).

3	How to use: name up to 3 components, enter each inlet stream's total flow and mass fractions. Outlet is computed; closure checks confirm consistency.
4							Process diagram
5	Component labels (edit names in row 6)
6	Component name	A	B	C
7
8	Inlet streams (yellow = input)
9	Stream	Total flow	w(A)	w(B)	w(C)	Σw check
10	In-1	100.	0.4	0.6	0.	ok
11	In-2	50.	0.1	0.9	0.	ok
12	In-3	0.	0.	0.	0.	–
13
14	Outlet (computed)
15	Stream	Total flow	flow(A)	flow(B)	flow(C)
16	OUT	150.	45.	105.	0.
17	OUT mass fractions		0.3	0.7	0.
18
19	Balance checks
20	Check	In	Out	Diff	% of in	Status
21	Overall mass	150.	150.	0.0000	0.0000	✅ CLOSED
22	Component A	45.	45.	0.0000	0.0000	✅ CLOSED
23	Component B	105.	105.	0.0000	0.0000	✅ CLOSED
24	Component C	0.	0.	0.0000	0.0000	✅ CLOSED
25
26	Notes
27	• Outlet is computed directly, so overall and component balances close by construction; the Σw checks catch fraction-entry errors.
28	• Set unused streams or components to zero. Rename components in row 6.
29	• For streams given as component flows instead of fractions, enter total = sum of flows and fractions = flow/total.
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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