[Fe...] Posted February 26 Share Posted February 26 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 More sharing options...
[Jo...] Posted February 27 Share Posted February 27 (edited) Are you trying to make your Excel file a template for when Calypso exports to Excel? Edited February 27 Link to comment Share on other sites More sharing options...
[Fe...] Posted March 2 Author Share Posted March 2 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 More sharing options...
[Fe...] Posted March 2 Author Share Posted March 2 Please sign in to view this username. Link to comment Share on other sites More sharing options...
[Ro...] Posted March 2 Share Posted March 2 (edited) 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 March 2 1 Link to comment Share on other sites More sharing options...
[Lu...] Posted March 2 Share Posted March 2 Hello, this Knowledge Base article may be helpful to you. LINK Link to comment Share on other sites More sharing options...
[Jo...] Posted March 4 Share Posted March 4 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 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 More sharing options...
[Ra...] Posted 8 hours ago Share Posted 8 hours ago 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 More sharing options...
[Ch...] Posted 7 hours ago Share Posted 7 hours ago 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 More sharing options...
[DW...] Posted 3 hours ago Share Posted 3 hours ago (edited) 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 3 hours ago Link to comment Share on other sites More sharing options...
[Ra...] Posted 1 hour ago Share Posted 1 hour ago 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 More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in