I have 1000 files. Each day, 250 files are processed. Out of the processed files, 20% get completed. Out of the processed files, 80% files need reprocessing and they restart from the beginning, but after second processing, they get completed.
How can I model this in excel to show the decline of files to be processed per day? In a function, that I can drag to generate the sequence?