EXCELL setup sheet combine operations and tools

[nubrandao]

hi, im using template setup sheet excell 2007

but i want to personalize, i deleted "tools pag" and inputed $tool_row

i want to be able to inputed some operations and some tool info in the same colum

it seems that those variables in the same row wont work,.

what im doing wrong?

[rohit_maneYV8C9 · Accepted solution]

Hello @nubrandao 

Here's a simple way to customize it: you can insert a column at the end of the template Excel file. Then, add your desired header name. Below that, use this code to retrieve specific tool data:

All the tool data is already included in the variable, so you can format the code like this: "$operation." followed by the key name.

$operation.tool.number   // To get the tool number
$operation.tool.diameter // To get the tool diameter

I hope this explanation is clear and helpful for you.

[nubrandao]

Wow, if that works, is a life saver.

Im responsable in the company to implement Fusion 360 in all computers, and the setup sheet plays a important role because we need to deliver information to the CNC operator, and they were strugle a little bit with the current setup sheet. I Will try 

Thanks a lot 

[nubrandao]

hi, it work perfectly, by the way, is possible to include the post processor in the setup sheet?

in this case is a more complicated situation i think, because, in order to post , im using a specific post to get excell setup sheet and the real post im using in the machine.

for example, i currently post in selca, fidia, and heideian 

or, input in excell template the post processor like an option, and before print, choose the post and then print

[rohit_maneYV8C9]

Hello @nubrandao ,

To integrate the Excel setup sheet into your main post processor (such as selca, fidia, and heideian ), follow these steps:

• Implement the onTerminate Function: Add the following function to your main post processor script in the global scope:

keywords = "MODEL_IMAGE";
function onTerminate() {
  var outputPath = getOutputPath(); 
  var programFilename = FileSystem.getFilename(outputPath); 
  var postPath = findFile("setup-sheet-excel-2007.cps"); 
  var intermediatePath = getIntermediatePath(); 
  var a = "--property unit " + ((unit == IN) ? "0" : "1"); // use 0 for inch and 1 for mm 
  if (programName) { 
  a += " --property programName \"'" + programName + "'\""; 
  }
  if (programComment) { 
  a += " --property programComment \"'" + programComment + "'\""; 
  }
  a += " --property programFilename \"'" + programFilename + "'\"";
  a += " --noeditor \"" + postPath + "\" \"" + intermediatePath + "\" \"" + FileSystem.replaceExtension(outputPath, "xlsx") + "\"";
  if (FileSystem.isFile(postPath)){ 
    execute(getPostProcessorPath(), a, false, "");
  }
  }

This function executes after the post-processing is complete.

Make sure:

• The setup-sheet-excel-2007.cps is located in the same folder as your main post processor script.

[nubrandao]

cant understand sorry, those command should be in the fidia post  processor or setup sheet post processor?

[rohit_maneYV8C9]

Yes, You just need to integrate those codes into your main post-processor (like Selca, Fidia, or Heidenhain) so that the setup sheet Excel post executes after the main post-processor runs.

[nubrandao]

Hi mate, can you help me?

I want to add the $notes in one column, but not works when I use $operation.notes

If I use in a different align excel

It works.

It important to $notes be in the same line the $operations_row

What should I add in the post processor?

[rohit_maneYV8C9 · Accepted solution]

hello @nubrandao ,
It seems you want to include operation notes from Fusion operation in the setup sheet Excel file. If that's correct, here’s how you can do it:
Note: You can use those commands which are available in post-processor file so Ensure that the notes command you want to add is available in the post-processor file. If not, you will need to modify the post-processor file.

Edit the Post-Processor File:

• Locate the onSectionEnd function in your post-processor file.

• Add the following code snippet to handle the operation notes:

  // custom code start
  var notes = cachedParameters["notes"];
  operationParameters["notes"] = notes;
  // custom code end

Refer- before image

Refer- after image

Update the Setup Sheet Excel:

• After modifying the post-processor file, you should be able to add rows to the setup sheet Excel with the notes included. Refer to the image provided for guidance on how to format these rows.

I hope it works for you.