Jump to content

excell


---
 Share

Recommended Posts

Good morning, is there a way to link CALYPSO reports to an Excel file? I have created a table where I would like to report passed and failed parts, and link it directly to the CALYPSO program. Thank you."

Link to comment
Share on other sites

Are you trying to make your Excel file a template for when Calypso exports to Excel?

Edited
Link to comment
Share on other sites

---

I am looking for a way to export report data from Clypso into an Excel spreadsheet. This will allow me to create a table to monitor the progress of specific parts."

Link to comment
Share on other sites

---

You have to turn on excel reporting for the plan you are running. Resources, define report, default report/ warning limit, then choose the whichever Characteristic template you want to use. The Characteristic.xlt would be if you are using older versions of Excel that use the .xls format. Characteristics .xlsm would be for newer versions of Excel using the .xlsx format. These templates can be changed to suit your needs. There are some guides if you do a bit of google searching, on how to do that. Here is an older guide, but it can at least give you an idea of what you can do.  

Calypso Excel Reporting.pdf

Edited
  • Like! 1
Link to comment
Share on other sites

---

You can move your custom excel file to the designated folder on the C drive, then pull it in as a template in Calypso.

Recourses-> define report 

image.thumb.png.dc52b0f5de447d11368bc4cd270a48e4.png

Or if you use multiple printout you can do it in that window too. Robert's guide looks like it gives you a lot more details.

Link to comment
Share on other sites

  • 3 weeks later...

Need help

I have calypso 2016 ver 6.2.

Want to have excel output in .xlsx

I need newer excel files characteristics.xlsm, FeatChar.xlsm, Feature.xlsm & ReportINI.xlsx

Who can provide?

Link to comment
Share on other sites

Just my opinion, but you're going to have better luck doing this outside of Calypso.  

I use 'Report_End.bat" to call a python script that copies the _chr.txt table files and move them to a folder.  Then use Python scripts to update various excel sheets.  Its not that bad, with AI, everyone's a programmer now.  

Link to comment
Share on other sites

Please sign in to view this quote.

Please sign in to view this username.

 It is surprising even with project automation tools like Codex and Claude Code how many people do not have any interest in jumping into the scripting/automation game. Even in very technical fields, some people just have no interest in learning a little bit that could help them a lot. I was into scripting long before AI hit the stage, but man does it take you from crawl/walk to a full sprint. 

 

Please sign in to view this username.

 Chad is right, manipulating the data outside of the Calypso environment is going to be easier, faster, more customizable. Search the forums for "PowerShell" and you will see some examples of scripting that can more than likely automate the task(s) you are trying to accomplish. 

Edited
Link to comment
Share on other sites

Thanks Chad & DWC.

I am not using any python script  or any other data manipulation platform. We are thinking to introduce down the road once we upgrade to Calypso 2025.

I was in assumption like it's just replacement of excel folder with .xlsx compatibility.

Link to comment
Share on other sites

 Share

×
×
  • Create New...