StopWatch ( AverageRate ; recordcount )

Timer to estimate how long a process will take in seconds

Average rating: 4.6 (25 votes) Log in to vote

Roger Biel
2Geckos Consulting, LLC
www.2geckos.com

Sample input:

StopWatch( .005 ; 4000 )

Sample output:

230

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// StopWatch( AverageRate ; recordcount )
/*first run returns estimated time
then returns Minutes elapsed since first run and $string variables
IndexTime: is a stored value containing average time per record
recordcount: is the number of files to proccess, if empty then FoundCount is used
Julian: is the number of seconds since Jan 1, 1970

AverageRate = D110:Domain_Files::_gIndexTime;
recordcount = valuecount(D100:Domains::Local_FileList);
*/

Let([
First = If(IsEmpty($swStart);1;0);
$swStart = If(First;Julian("");$swStart);
$swRecods = If(First;0;$swRecods + 1);
recordcount = Case(IsEmpty(recordcount)and First;Get(FoundCount);
		IsEmpty(recordcount)and not First;$swRecods;
		recordcount);

Elapsed = Julian("")- $swStart;
Rate = Elapsed/ recordcount;
$AverageRate = Case(Rate = 0;AverageRate;
	AverageRate<0;Rate;
	AverageRate>5*Rate;Rate;// exclude out of range
	Round((AverageRate+Rate)/2;4));// average using current

Rate = Case(First;AverageRate;Rate);


// 1st: Estimated Sec then Elapsed Sec
$swSec = If(First;Rate*recordcount;Elapsed);

// formatted time
swMin = Round($swSec / 60;0);
	SecRem = Round($swSec-(swMin*60);0);
FmtTime = If(swMin>0;swMin & " min";"")&
	If(SecRem<10;"";" " & SecRem & " sec");

ElapsedMin = Round(Elapsed/60;0);
ElapsedSec = Abs(Elapsed-ElapsedMin*60);
ElapsedFmt = If(Elapsed<60;Elapsed & " sec";ElapsedMin & " min " & ElapsedSec & " sec");

$Estimated = If(First;"Estimate" & FmtTime & " to process " & recordcount & " files¶";$Estimated);
$swDescription = If(First;$Estimated;
	$swRecods & " files in " & ElapsedFmt & ", " & Round(Rate;3)& " sec per file¶")

];
$swSec
)

first run returns estimated time
then returns Minutes elapsed since first run and $string variables
IndexTime: is a stored value containing average time per record
recordcount: is the number of files to proccess, if empty then FoundCount is used
Julian: is the number of seconds since Jan 1, 1970

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

StopWatch ( AverageRate ; recordcount )

Comments

Support this website.

Support this website.