View Single Post
 
Old 11-27-2022, 07:57 AM
rammy25 rammy25 is offline Windows 10 Office 2021
Novice
 
Join Date: Nov 2022
Posts: 5
rammy25 is on a distinguished road
Default

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
Reply With Quote