[Da...] Posted July 31, 2018 Share Posted July 31, 2018 Hi, I did a quick search on this forum plus http://www.cmmguys.com/forum/ before posting here. How do I trim decimal places, that are being output from calypso to excel from 7 to 3? under C:\Users\Public\Documents\Zeiss\CALYPSO\data\excel_report I can see a few excel templates, each one contains Visual Basic code. But I'm not a programmer and I can't find where decimal places are coded. Link to comment Share on other sites More sharing options...
[An...] Posted July 31, 2018 Share Posted July 31, 2018 Hello Dane, Link to comment Share on other sites More sharing options...
[Da...] Posted July 31, 2018 Author Share Posted July 31, 2018 Please sign in to view this quote. Hi Andreas, I have it set just like you suggested, it has to be something elselang-dec-pl.PNG Link to comment Share on other sites More sharing options...
[An...] Posted July 31, 2018 Share Posted July 31, 2018 are you registered as a Master Link to comment Share on other sites More sharing options...
[An...] Posted July 31, 2018 Share Posted July 31, 2018 _ Link to comment Share on other sites More sharing options...
[An...] Posted July 31, 2018 Share Posted July 31, 2018 who can read has the advantage... 😃 😃 😃 I didn't realize it was the "Excel". The way "Andreas" describes him is the right one Link to comment Share on other sites More sharing options...
[Me...] Posted July 31, 2018 Share Posted July 31, 2018 Try Resources>Measurement plan editor features>number of decimal places. Link to comment Share on other sites More sharing options...
[An...] Posted July 31, 2018 Share Posted July 31, 2018 these are taken over by the system settings, as I have described it at the beginning! Link to comment Share on other sites More sharing options...
[Me...] Posted July 31, 2018 Share Posted July 31, 2018 We tried the same thing and had rounding issues at 3 places. We either had to run the global settings at 3 place or run 3 place thru the editor, per plan, to get the same results as excel at 3 places. We went back to 4 place on everything. Link to comment Share on other sites More sharing options...
[Me...] Posted July 31, 2018 Share Posted July 31, 2018 could this be what your looking for? Sorry for the bad spelling. Link to comment Share on other sites More sharing options...
[An...] Posted August 1, 2018 Share Posted August 1, 2018 Please sign in to view this quote. With this you can delete a decimal number later! "Dane" is looking for the possibility to display transmitted measurement data in 4 digits only, without deleting it afterwards! Link to comment Share on other sites More sharing options...
[Da...] Posted August 1, 2018 Author Share Posted August 1, 2018 Please sign in to view this quote. I tried with Master also and there are still 7 decimal places. Link to comment Share on other sites More sharing options...
[Da...] Posted August 1, 2018 Author Share Posted August 1, 2018 Please sign in to view this quote. That is what I was looking for. Thank you very much! Link to comment Share on other sites More sharing options...
[Me...] Posted August 10, 2018 Share Posted August 10, 2018 I agonized over this issue before coming up with this solution (attached). We use Inspection Xpert so my template works with that software, but you could just make a modified template and use that as a default template the same way you do now. -DaveXcell-Rounding.pdf Link to comment Share on other sites More sharing options...
[Da...] Posted August 10, 2018 Author Share Posted August 10, 2018 Please sign in to view this quote. Nice trick also! Thank you Link to comment Share on other sites More sharing options...
[Da...] Posted August 10, 2018 Share Posted August 10, 2018 I had similar problems before. it seems that Calypso exports all decimal places no matter what the settings . The settings seem to only change the DISPLAY. Excel also imports all the decimal places. Even after rounding in excel , when you click on a cell, the entire 8 decimal places are displayed. There is some way to truncate the number in excel that actually deletes the extra decmal places, but I can't remember what it was. 🙁 But it IS in excel ! Link to comment Share on other sites More sharing options...
[Da...] Posted August 13, 2018 Author Share Posted August 13, 2018 Please sign in to view this quote. Hi Dave, I guess you've missed the post by Andreas Binder on the previous page. See his attachments, he is the best 🙂 And yes, that's in Excel. 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