| A | |
| 1 |
 =file@s("Volkswagen.txt").import@t()
|
| 2 |
=A1.sort(Customer,Date)
|
| 3 |
=A2.select(Model=="Jetta"||Model=="MAGOTAN").derive()
|
| 4 |
=A3.derive(interval(Date[-1],Date):Interval)
|
| 5 |
=A4.select(Model[-1]=="Jetta" && Model=="MAGOTAN" && Customer==Customer[-1])
|
| 6 |
=round(A5.avg(Interval))
|
A6中运算结果如下:
