Yes, on rows are piping length and on column the progress
for example for row 13(12)
Lenght: 12.61
on 25.08.2022 was done 50% so 6.305 ml
on 26.08.2022 was done 90% from total so 0.9from total lenght: 11.631ml but without the 6.8 ml that was done before so the result is 5.044
so in the future for 100% it remains to be done 1.261 ml
this is an extract from a larger data base that is export like this and I would like to calculate how many meters was done per month
|