某Excel中的sheet分为3类,其中sheet A是基础表,部分数据如下:
A | B | C | |
1 | interval1 | interval2 | interval3 |
2 | 1 hour | 1 day | 1 week |
3 | 2 hours | 2 days | 2 weeks |
4 | 3 hours | 3 days | 3 weeks |
5 | 4 hours | 4 days | 4 weeks |
Sheet B1\B2…Bn是关联表,它们的格式都一样,且与A有相同的列interval1、interval2、interval3。其中一个B的部分数据如下:
A | B | C | D | E | F | G | |
1 | interval1 | interval2 | interval3 | Type | value1 | value2 | value3 |
2 | 2 hours | 1 day | 7 week | circle | 37 | 108.1 | 4.1 |
3 | 3 hours | 3 days | 7 weeks | Line | 39 | 117.5 | 4.2 |
4 | 4 hours | 4 days | 7 weeks | Line | 35 |