Any maths genius?

[kalos]

Hello!

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?

thanks!

[Deozaan]

Try asking on a website designed for people to ask questions and get them answered, such as Stack Exchange:

https://meta.stackexchange.com/questions/90919/which-stack-exchange-site-is-best-for-microsoft-excel-questions

[Shades]

Move files that are processed correctly out of the folder they were in. Then you can use a simple .vba macro to count the remaining files in the folder with the unprocessed files.

See this link for the vba macro script. Here is another link. Now I know that people love to use Excel as a kind of "dashboard"...but why?


By the way, the provided links were the 1st and 4th search result, provided by duckduckgo. Perhaps DC should spring for a course of google-fu for kalos...

[4wd]

From a purely informational point of view, what happens when there are less than 250 files to be processed?

Does the process stop?
Does it continue, thereby processing less than the stipulated 250 files per day?

[wraith808]

From a purely informational point of view, what happens when there are less than 250 files to be processed?

Does the process stop?
Does it continue, thereby processing less than the stipulated 250 files per day?

The only way to win, is not to play the game 

[4wd]

From a purely informational point of view, what happens when there are less than 250 files to be processed?

Does the process stop?
Does it continue, thereby processing less than the stipulated 250 files per day?

The only way to win, is not to play the game 

I don't do Excel so I'm safe 

I just thought I'd point out an informational shortfall, something that will be of assistance when asking on Stack Exchange/Super User.