Sheet3
Sheet2
Sheet1
pic
序号
方格网边长
a
设计标高
场地标高
h2
h3
h4
施工高程
HN1
HN2
HN3
HN4
Hn1
Hn2
Hn3
Hn4
h1
面积
挖方
填方
m2
m3
备注
x1
x2
x3
x4
填充为挖
一填三挖
二填二挖
三填一挖
全填或全挖
一填三挖零点1
一填三挖零点2
一填三挖零点3
一填三挖零点4
二填二挖零点5
二填二挖零点6
二填二挖零点7
二填二挖零点8
三填一挖零点9
三填一挖零点10
三填一挖零点11
三填一挖零点12
施工高程绝对值
h1
h2
h3
h4
全挖或全填零点0
填方
挖方
公式列(判断挖填情况）
公式列（返回挖方值）
公式列（返回填方值）
方格网土方计算表
By:Xman
面积：
华丽的
分隔缝
400m2
.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
-.00
-.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
0.00
0.00
.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
0.00
00.00
.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
00.00
.00
.00
.00
.00
|
|
