Required % of cutter consumption from total tool list time

[malinsAM3TM]

Hi 

We are in die and mould business

We required various cutting tools to finish mould

Is there any option to get cutter consumption used in a particular power mill project

What is the total time used the particular tool used in a project as per feed given in a project 

This is to analyze the cutter consumption trend 

This would help to maintain cutting tool inventory 

Regards

Nivrutti Mali

Godrej Tooling

[ondrej.mikulec]

INT LIST $toolsNumbers = extract(folder('Tool'), 'Number.Value')

INT dummy = remove_duplicates($toolsNumbers)

FOREACH $toolNumber IN toolsNumbers {

	REAL $cuttingTimeSum = 0

	FOREACH $tp IN folder("Toolpath") {
	
		IF $tp.Tool.Number.Value == $toolNumber {
		
			$cuttingTimeSum = $cuttingTimeSum + $tp.Statistics.TotalTime
		}
	}
	
	PRINT ${"Tool Number: " + $toolNumber + " Total Time: " + $time_to_string($cuttingTimeSum)}

}

[danmic7JH66]

I was playing around with this code a little and i went about it a bit differently.

Your code definitely got me on the right path but I couldn't get any values to actually output. All tools had 0.0 output simulation time for some reason. I changed it up a bit and went this route and it gave me (not the OP) the results I was hoping to get. Maybe it'll be useful for someone else. I know it could be made more efficient, I just typed it out real quick and tested.

string list tool_ = {}

foreach t in folder ('tool') {
    int add1 = add_last($tool_, $t.name )
}

foreach tl in $tool_ {
real tp_time = '0'
string msg = "" 

    foreach tp in folder('toolpath') {
        if $tp.tool.name == $tl {
            $tp_time = $tp_time + round($tp.Statistics.TotalTime, 3)
        }
    }
$msg = "Tool " + $tl + " total simulation time : " + $tp_time    
print $msg

}

[malinsAM3TM]

Hello Sir

I run this macro

but I am not getting time as per tool diameter

It is showing only for 1st tool and that to in seconds

It would be helpful we get output in excel  

I have attached ppt and project for your reference

regards

Nivrutti Mali