Thit k phn mm tnh ton trn excel

1. Nhp thng s u vo theo bng. ( nh km trong file excel)

Vi mi ln trc khi nhp s liu ch c th cho n hin ln thng bo
Nhp cng thit k fc khng ? Sau khi enter v n li t ng
nhp thng bo cho n ht y ?
Trong 3 ct Th tch tuyt i ca , Hm lng nc ban u,
Lng ph gia s dng v T l N/B, nu gi tr nhp vo khng trong
phm v gi tr khuyn co => Bo Li/ Yu cu nhp li?
2. Sau khi nhp xong cc gi tr u vo, my t in cc thng s vo 1 ci
bng nh th ny :
Bng 12. Thnh phn hn hp vt liu kh cha iu chnh
ST
T
1
2
3
4
5
6
7

Khi lng ring,

g/cm3

Vt liu

d
c
x
b
n
pg

dm
Ct
Xi mng
Bt
Nc
Ph gia
Khng
kh

Th
tch,
m3
V
Vc
Vx
Vb
Vn
Vpg
Vkk

Thnh phn/1m3 b
tng

n
v

1
C1
X
B
N2
PG2

kg
kg
kg
kg
lt
lt

KK

lt

3. Cc cng thc tnh cho bng 12

3.1. Ct khi lng ring v th tch , th tch khng kh my t chuyn
gi tr t bng nhp s u vo.
3.2. 1 = V d
3.3. N2 = N1 N1 12%
3.4.

X=

N2
N /CKD

3.5.

B=

N2
N /B

3.6.
3.7.

B = B X
KK = Vkk 1000

3.8.

PG 2=PG 1

3.9.

C 1= c (

X
100

X 1 B N 2
+
+
+
+Vkk )
x d b n

X
x 1000

3.10.

Vx=

3.11.

Vb=

3.12.

Vn=

3.13.

Vpg=

B
b 1000

N2
n 1000
PG
1000

3.14. Vc = 1 V Vn Vpg Vx Vb - Vkk

4. Bng 13. Thnh phn hn hp sau khi xt ti m ct liu.
STT

Vt liu

1
2
3
4
5
6
7

dm
Ct
Xi mng
Bt
Nc
Ph gia
Khng kh

Khi lng ring, g/m3

d
c
x
b
n
pg

Thnh phn/1m3 b tng

2
C2
X
B
N3
PG2
KK

C2 = C1 x (1 + AC/100)
D2 = D1 x (1 + AD/100)
N3 = N2 D1 x (AD/100-0.006) C1 x (AC/100-0.01)

n v
kg
kg
kg
kg
lt
lt
lt