氮气置换计算3.0for excel 2003
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
N2 REPLACEMENT CALCULATOR 3.0 THEORETICAL CALCULATION (For O2 Free)
THEORETICAL DATA
ITEM VALUE UNIT Barg Barg Barg % times times % Ton
N2 CONSUMPTION CALCULATION
ITEM N2 temperature N2 density Volume Total estimate consumption of N2 VALUE UNIT 0 º C 1.249032 kg/m 3 3053 47.393 m
3
The initial pressure of vessel 0.4 Initial O2 and other Non-N2 1.50 gases in vessel Target pressure for 0.40 pressuring step Target pressure for 99.8000 depressuring step Target N2 concentration in 11.2985 vessel Replace times theoretically 12 Actual Pressure-depressure 99.8668 steps HC simulation consumption 50.3355
Unit 3 m m3 m3 m3 m3 m3 m3 m3 m3 m3 m m3 m3 m3 m3 m 3 m
3 3
Line 18 Line 19 Line 20 Line 21 Line 22 Line 23 Line 24 Line 25 Line 26 Line 27 Line 28 Line 29 Line 30 Line 31 Line 32 Line 33 Line 34 Line 35 Line 36 Line 37 Line 38 Line 39 Line 40 Line 41 Line 42 Line 43 Line 44 Line 45 Line 46 Line 47 Line 48 Line 49 Line 50 Line 51 Line 52 Line 53 Line 54 Line 55 Line 56 Line 57 Line 58 Line 59 Line 60 Line 61 Line 62 Line 63 Line 64 Line 65 Line 66 Line 67 Line 68 Line 69 Line 70
m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3
Line 71 Line 72 Line 73 Line 74wenku.baidu.comLine 75 Line 76 Line 77 Line 78 Line 79 Line 80 Line 81 Line 82 Line 83 Line 84 Line 85 Line 86 Line 87 Line 88 Line 89 Line 90 Line 91 Line 92 Line 93 Line 94 Line 95 Line 96 Line 97 Line 98 Line 99 Line 100
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
m m3 m
3
3
m3 m 3 m m 3 m m 3 m m3 3 m 3 m m m3 3 m 3 m 3 m m 3 m 3 m m3 m m3 m m3 m3 m
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
Volume 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
m
3
TOTAL VOLUME OF
3053
Volume 3053 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm
ACTUAL CALCULATION
Time of pressurize No.1 No.2 No.3 No.4 No.5 No.6 No.7 No.8 No.9 No.10 Targe pressure Release pressure Value Unit Value Unit Barg Barg 3.01 0.58 Barg Barg 2.80 0.30 Barg Barg 2.91 0.61 Barg Barg 3.07 0.38 Barg Barg 2.97 0.40 Barg Barg 3.07 0.59 Barg Barg 2.24 0.40 Barg Barg 0.00 0.00 Barg Barg 0.00 0.00 Barg Barg 0.00 0.00 Total N2 consumption N2 content Value Unit % 44.8379 % 81.1288 % 92.2295 % 97.3653 % 99.0709 % 99.6370 % 99.8432 % 99.8432 % 99.8432 % 99.8432 N2 consumption Value Unit Ton 9.2663 Ton 9.5332 Ton 8.7706 Ton 10.2578 Ton 9.8002 Ton 9.4570 Ton 7.0165 Ton 0.0000 Ton 0.0000 Ton 0.0000 64.1015 Ton
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
m m3 m
3
3
Vessel 71 Vessel 72 Vessel 73 Vessel 74 Vessel 75 Vessel 76 Vessel 77 Vessel 78 Vessel 79 Vessel 80 Vessel 81 Vessel 82 Vessel 83 Vessel 84 Vessel 85 Vessel 86 Vessel 87 Vessel 88 Vessel 89 Vessel 90 Vessel 91 Vessel 92 Vessel 93 Vessel 94 Vessel 95 Vessel 96 Vessel 97 Vessel 98 Vessel 99 Vessel 100
Ton
TIME CONSUMPTION
N2 flowrate Ø=25mm hose Numbers of N2 hose used Time consumption for each pressurizing Total time consumption for each pressurizing 0.900 3 1.55 18.64 h h t/h
3 3 3 3 3 3 3 3
m3 m 3 m m 3 m m 3 m m3 3 m 3 m m m3 3 m 3 m 3 m m 3 m 3 m m3 m m3 m3 m3 m3 m
3 3 3 3 3 3 3
m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3
VOLUME CALCULATION
TOTAL VOLUME OF THE LINE
No Line 1 Line 2 Line 3 Line 4 Line 5 Line 6 Line 7 Line 8 Line 9 Line 10 Line 11 Line 12 Line 13 Line 14 Line 15 Line 16 Line 17 Diamete 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Unit mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm Length 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Unit m m m m m m m m m m m m m m m m m
m m3 m
3
3
Vessel 18 Vessel 19 Vessel 20 Vessel 21 Vessel 22 Vessel 23 Vessel 24 Vessel 25 Vessel 26 Vessel 27 Vessel 28 Vessel 29 Vessel 30 Vessel 31 Vessel 32 Vessel 33 Vessel 34 Vessel 35 Vessel 36 Vessel 37 Vessel 38 Vessel 39 Vessel 40 Vessel 41 Vessel 42 Vessel 43 Vessel 44 Vessel 45 Vessel 46 Vessel 47 Vessel 48 Vessel 49 Vessel 50 Vessel 51 Vessel 52 Vessel 53 Vessel 54 Vessel 55 Vessel 56 Vessel 57 Vessel 58 Vessel 59 Vessel 60 Vessel 61 Vessel 62 Vessel 63 Vessel 64 Vessel 65 Vessel 66 Vessel 67 Vessel 68 Vessel 69 Vessel 70
m
3
Unit 3 m m3 m3 m3 m3 m3 m3 m3 m3 m3 m m3 m3 m3 m3 m 3 m
3 3
No Vessel 1 Vessel 2 Vessel 3 Vessel 4 Vessel 5 Vessel 6 Vessel 7 Vessel 8 Vessel 9 Vessel 10 Vessel 11 Vessel 12 Vessel 13 Vessel 14 Vessel 15 Vessel 16 Vessel 17
THEORETICAL DATA
ITEM VALUE UNIT Barg Barg Barg % times times % Ton
N2 CONSUMPTION CALCULATION
ITEM N2 temperature N2 density Volume Total estimate consumption of N2 VALUE UNIT 0 º C 1.249032 kg/m 3 3053 47.393 m
3
The initial pressure of vessel 0.4 Initial O2 and other Non-N2 1.50 gases in vessel Target pressure for 0.40 pressuring step Target pressure for 99.8000 depressuring step Target N2 concentration in 11.2985 vessel Replace times theoretically 12 Actual Pressure-depressure 99.8668 steps HC simulation consumption 50.3355
Unit 3 m m3 m3 m3 m3 m3 m3 m3 m3 m3 m m3 m3 m3 m3 m 3 m
3 3
Line 18 Line 19 Line 20 Line 21 Line 22 Line 23 Line 24 Line 25 Line 26 Line 27 Line 28 Line 29 Line 30 Line 31 Line 32 Line 33 Line 34 Line 35 Line 36 Line 37 Line 38 Line 39 Line 40 Line 41 Line 42 Line 43 Line 44 Line 45 Line 46 Line 47 Line 48 Line 49 Line 50 Line 51 Line 52 Line 53 Line 54 Line 55 Line 56 Line 57 Line 58 Line 59 Line 60 Line 61 Line 62 Line 63 Line 64 Line 65 Line 66 Line 67 Line 68 Line 69 Line 70
m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3
Line 71 Line 72 Line 73 Line 74wenku.baidu.comLine 75 Line 76 Line 77 Line 78 Line 79 Line 80 Line 81 Line 82 Line 83 Line 84 Line 85 Line 86 Line 87 Line 88 Line 89 Line 90 Line 91 Line 92 Line 93 Line 94 Line 95 Line 96 Line 97 Line 98 Line 99 Line 100
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
m m3 m
3
3
m3 m 3 m m 3 m m 3 m m3 3 m 3 m m m3 3 m 3 m 3 m m 3 m 3 m m3 m m3 m m3 m3 m
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
Volume 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
m
3
TOTAL VOLUME OF
3053
Volume 3053 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm
ACTUAL CALCULATION
Time of pressurize No.1 No.2 No.3 No.4 No.5 No.6 No.7 No.8 No.9 No.10 Targe pressure Release pressure Value Unit Value Unit Barg Barg 3.01 0.58 Barg Barg 2.80 0.30 Barg Barg 2.91 0.61 Barg Barg 3.07 0.38 Barg Barg 2.97 0.40 Barg Barg 3.07 0.59 Barg Barg 2.24 0.40 Barg Barg 0.00 0.00 Barg Barg 0.00 0.00 Barg Barg 0.00 0.00 Total N2 consumption N2 content Value Unit % 44.8379 % 81.1288 % 92.2295 % 97.3653 % 99.0709 % 99.6370 % 99.8432 % 99.8432 % 99.8432 % 99.8432 N2 consumption Value Unit Ton 9.2663 Ton 9.5332 Ton 8.7706 Ton 10.2578 Ton 9.8002 Ton 9.4570 Ton 7.0165 Ton 0.0000 Ton 0.0000 Ton 0.0000 64.1015 Ton
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
m m3 m
3
3
Vessel 71 Vessel 72 Vessel 73 Vessel 74 Vessel 75 Vessel 76 Vessel 77 Vessel 78 Vessel 79 Vessel 80 Vessel 81 Vessel 82 Vessel 83 Vessel 84 Vessel 85 Vessel 86 Vessel 87 Vessel 88 Vessel 89 Vessel 90 Vessel 91 Vessel 92 Vessel 93 Vessel 94 Vessel 95 Vessel 96 Vessel 97 Vessel 98 Vessel 99 Vessel 100
Ton
TIME CONSUMPTION
N2 flowrate Ø=25mm hose Numbers of N2 hose used Time consumption for each pressurizing Total time consumption for each pressurizing 0.900 3 1.55 18.64 h h t/h
3 3 3 3 3 3 3 3
m3 m 3 m m 3 m m 3 m m3 3 m 3 m m m3 3 m 3 m 3 m m 3 m 3 m m3 m m3 m3 m3 m3 m
3 3 3 3 3 3 3
m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m3
VOLUME CALCULATION
TOTAL VOLUME OF THE LINE
No Line 1 Line 2 Line 3 Line 4 Line 5 Line 6 Line 7 Line 8 Line 9 Line 10 Line 11 Line 12 Line 13 Line 14 Line 15 Line 16 Line 17 Diamete 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Unit mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm mm Length 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Unit m m m m m m m m m m m m m m m m m
m m3 m
3
3
Vessel 18 Vessel 19 Vessel 20 Vessel 21 Vessel 22 Vessel 23 Vessel 24 Vessel 25 Vessel 26 Vessel 27 Vessel 28 Vessel 29 Vessel 30 Vessel 31 Vessel 32 Vessel 33 Vessel 34 Vessel 35 Vessel 36 Vessel 37 Vessel 38 Vessel 39 Vessel 40 Vessel 41 Vessel 42 Vessel 43 Vessel 44 Vessel 45 Vessel 46 Vessel 47 Vessel 48 Vessel 49 Vessel 50 Vessel 51 Vessel 52 Vessel 53 Vessel 54 Vessel 55 Vessel 56 Vessel 57 Vessel 58 Vessel 59 Vessel 60 Vessel 61 Vessel 62 Vessel 63 Vessel 64 Vessel 65 Vessel 66 Vessel 67 Vessel 68 Vessel 69 Vessel 70
m
3
Unit 3 m m3 m3 m3 m3 m3 m3 m3 m3 m3 m m3 m3 m3 m3 m 3 m
3 3
No Vessel 1 Vessel 2 Vessel 3 Vessel 4 Vessel 5 Vessel 6 Vessel 7 Vessel 8 Vessel 9 Vessel 10 Vessel 11 Vessel 12 Vessel 13 Vessel 14 Vessel 15 Vessel 16 Vessel 17