[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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/ Share on other sites More sharing options...
[An...] Posted July 31, 2018 Share Posted July 31, 2018 Hello Dane, Link to comment https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116278 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116280 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116282 Share on other sites More sharing options...
[An...] Posted July 31, 2018 Share Posted July 31, 2018 _ Link to comment https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116284 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116286 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116288 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116290 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116292 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116294 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116296 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116298 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116300 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116302 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116304 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116306 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 https://qualityforum.zeiss.com/topic/20490-calypso-excel-decimal-places/#findComment-116308 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