Hello all, I've currently got a progress bar that I use for my data entry scripts and I wanted to figure out a way to also display an "estimated" completion time that is updated based on the time it takes to process a record.
Any ideas how I could do something of this nature? My process is that I count the total records in the datasource, and then do an update of the progress bar after each D.Next_: As far as estimating time, what I do now is sit there and watch a record be processed, start to finish, counting in my head "one-one thousand, two-one thousand, three-one thousand", etc until the record finishes. I know it's not totally accurate, but it gives me an idea how many seconds each record takes. I take that total, multiply by the total records, divide by 60 twice to get hours in decimals and then subtract whole hours, multiply by 60 to get minutes. I can then add the hours and minutes to the script start time and get an estimated time of completion. For the purpose of the status bar, I would just be interested in some time of "estimated completion in xx:xx minutes" type of update on each record processed. I'm stuck on what formula to use though. Thoughts? Thank you, Mitch Lawrence Lead Applications Analyst Technical Support - NPR/Automation CHRISTUS Information Management *: [email protected] <mailto:[email protected]> Send a "thank you <http://intranet.christushealth.org/spiritBuck/Default.asp> " to someone!
<<image001.png>>
<<image002.png>>
