新公式计算岩层真厚度的Excel算法

CALCULATE THE TRUE THICKNESS WITH EXCEL ALGORITHM

使用软件1,将岩层序号、导线的方位和倾角、岩层的倾向、倾角和两层面切割导线处的读数分别输入A、F、G、H、I、J、K列,先后分别沿M、N列从第2行单元格开始拖动鼠标,岩层真厚度数据和累积厚度即刻计算出来,进一步可计岩组或岩性段的真厚度;将导线的序号、方位、倾角、长度分别输入W、X、Y、Z列,先后分别沿AB、AC、AD、AE、AF、AG、AH列,从第2行单元格开始拖动鼠标,导线的水平投影长度、纵座标增量及其累积值、横座标增量及其累积值、高程增量及其累积值即刻计算出来。使用软件2,在输入原始数据的同时,结果便计算出来。

With software 1, serial number of the terrain, and dip angle of the traverse, dip and dip angle of the terrain, count ofjoint of bedding planes and traverse are input to line A, F, G, H, I, J, K, then drag mouse from cell in row 2 along line M, N. The true thickness and cumulative thickness can be figure out immediately, and the true thickness of fabric and lithomember can be figure out. Serial number, azimuth, dip angle and length of traverse are input to line W, X, Y, Z, then drag mouse from cell in row 2 along line AB, AC, AD, AE, AF, AG, AH. The horizontal projection length of the traverse, increment of Y-coordinate and its accumulation, increment of X-coordinate and its accumulation, and increment of height and its accumulation can be figure out immediately. With software 2, the results can be figure out at the same time of inputting base data,