XlsxShop
二维线性插值计算
-
插值计算
- 插值计算
| 名称 | 单位 | 公式/来源 | 值 | |
| 1 | 示意图 | |||
| 2 |  |
|||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | 输入 | |||
| 10 | X1 | / | 1 | |
| 11 | X | / | 2 | |
| 12 | X2 | / | 3 | |
| 13 | Y1 | / | 6 | |
| 14 | Y | / | 7 | |
| 15 | Y2 | / | 8 | |
| 16 | X1Y1 | / | 10 | |
| 17 | X1Y2 | / | 17 | |
| 18 | X2Y1 | / | 13 | |
| 19 | X2Y2 | / | 19 | |
| 20 | 过程 | |||
| 21 | XY1 | / | 11.5 | |
| 22 | X1Y | / | 13.5 | |
| 23 | XY2 | / | 18 | |
| 24 | X2Y | / | 16 | |
| 25 | 结果 | |||
| 26 | XY | / | 14.75 | |
