I would like help with a spreadsheet that would show Cnc machine work
load per machine .

Number of Hours and Minutes that are required to complete scheduled work .
Lets say 2 machines involved,, laser1 and laser2 .

So 2 directory's ,, laser1 and laser1 .
Each directory could have 5 to 15 programs each ready to run .
Files are text files .. just G-code .

Example p1234, p2234, p3344 .

Inside top few lines of each program would have the info required to fill
the excel chart..
example of program

%
P1234
( Machine : laser1 )
( Program name : P1234 )
( Post date : 02/25/06 )
( Required run time : 2:12:20 )
( Sheets required : 1 )

Line 6 of program would be multiplied by line 7 for total run time if
program is required to repeat.

The sheet would show , machine , program name , post date , run time ,
sheets required

A total of requireed run time per program per machine as well as total run
time required for
all programs in each machine directory..


Thanks
Rod