Export to excel - DDE - Angle Format

User avatar
US_Helpdesk
Moderator
Moderator
Posts: 1087
Joined: Wed Feb 23, 2011 7:26 pm

Re: Export to excel

Post by US_Helpdesk » Tue Jun 21, 2016 2:51 pm

You will need to output the data from CMM-Manager in Decimal.Degree. Once in Excel you can use a Formula to convert Decimal to Degree:Minutes:Seconds using a formula like this:

Code: Select all

=CONCATENATE(TEXT(INT(E19),"##° "),TEXT(INT((E19-INT(E19))*60),"##'"),TEXT(MOD((E19-INT(E19))*60,INT((E19-INT(E19))*60))*60,"##.##"),"""")
If cell “E19” is 78.359272 in degrees decimal then:

Will return:
78° 21' 33.38"
I've migrated to a new user account, see my other posts here

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: Export to excel

Post by ameade022008 » Tue Jun 21, 2016 4:34 pm

nfrost wrote:You will need to output the data from CMM-Manager in Decimal.Degree. Once in Excel you can use a Formula to convert Decimal to Degree:Minutes:Seconds using a formula like this:

Code: Select all

=CONCATENATE(TEXT(INT(E19),"##° "),TEXT(INT((E19-INT(E19))*60),"##'"),TEXT(MOD((E19-INT(E19))*60,INT((E19-INT(E19))*60))*60,"##.##"),"""")
If cell “E19” is 78.359272 in degrees decimal then:

Will return:
78° 21' 33.38"

Nathan any help with my comment regrading multiple runs into one cell and increasing ranges? I know its a bit off topic, but any help is appreciated
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

medupriest
SUDO
SUDO
Posts: 423
Joined: Fri Mar 13, 2015 11:59 am

Re: Export to excel - DDE - Angle Format

Post by medupriest » Wed Jun 22, 2016 9:13 am

After all the the dde steps, add a "Convert Excel to CSV" step. This will allow you to reproduce the spreadsheet each run and save it with a sequence number.

Is this what you are looking for?

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: Export to excel - DDE - Angle Format

Post by ameade022008 » Wed Jun 22, 2016 10:52 am

medupriest wrote:After all the the dde steps, add a "Convert Excel to CSV" step. This will allow you to reproduce the spreadsheet each run and save it with a sequence number.

Is this what you are looking for?
Im not sure what CSV, I will look into it, but this is my scenario:

I have a Production part we constantly do, I run my program inspecting the features, then I print a report and manually enter the values into my AS9012 spread sheet (see previous attached photo). Then I load a new part and repeat these steps over and over. If I inspect 50 parts, I dont have 50 results, I just have a high and low result.

Recently I've leared of the DDE feature, so at the end of my programs ive re-written them to output those values directly into my result column saving me so much time, however, the issue is there are only 3 option for DDE: "Overwrite" which overwrites my previous result. "Column" which just adds the new result into the next available column since there is already a result from the previous part inspected. and "Row which I wont use since it will interfere with other results.

What Id like to see is being able to output a result into the same column as the last run but not be overwritten.

example:
Part 1: result "2.000"
Column will read "2.000"

Part 2: result "2.001"
Column now reads 2.000-2.001

Part 3: "1.999"
column now reads 1.999-2.001

Part 4: "2.000"
Column will maintain 1.999-2.001 since its within the range.
Last edited by ameade022008 on Wed Jun 22, 2016 10:55 am, edited 1 time in total.
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: Export to excel - DDE - Angle Format

Post by ameade022008 » Wed Jun 22, 2016 10:54 am

Side note, we do have InspectionXpert. they do have a software call CMMxpert. Maybe this software will allow me to do what i need to do? Ill have to inquire about it and research it some more. But if I can get Cmm manager to do it, no point in buying that added software.
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

User avatar
US_Helpdesk
Moderator
Moderator
Posts: 1087
Joined: Wed Feb 23, 2011 7:26 pm

Re: Export to excel - DDE - Angle Format

Post by US_Helpdesk » Wed Jun 22, 2016 11:20 am

ameade022008 wrote: example:
Part 1: result "2.000"
Column will read "2.000"

Part 2: result "2.001"
Column now reads 2.000-2.001

Part 3: "1.999"
column now reads 1.999-2.001

Part 4: "2.000"
Column will maintain 1.999-2.001 since its within the range.
Just another example where you would use a Formula in Excel... I think you need to do some searching / learning about capabilities of Excel. This is pretty standard stuff.

For example: If your data range written from CMM-Manager (DDE) in Excel is Column D, you could create a cell in cell E2 with a Formula like this:

Code: Select all

=CONCATENATE(MIN(D2:D128),"-",MAX(D2:D128))
This would display MinValue - MaxValue - i.e. "1.999 - 2.001"
excel example.jpg
You do not have the required permissions to view the files attached to this post.
I've migrated to a new user account, see my other posts here

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: Export to excel - DDE - Angle Format

Post by ameade022008 » Wed Jun 22, 2016 11:47 am

yes I knew excel could do this, sorry I was just wondering if cmm manger could do this without having to output ALL the results and clutter up my excel spread sheet. I guess I could just create a new form on the spreadsheet where all the data will get outputted to and than once i collect the min max to output it back to form I need it on.
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: Export to excel - DDE - Angle Format

Post by ameade022008 » Wed Jun 22, 2016 11:53 am

veedubnut115 wrote:So I am able to get my results to export to an excel file. I can get them to sequentially increase as to not overwrite themselves.
I just read the OP post and figured he got it to work within cmm manager
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

User avatar
US_Helpdesk
Moderator
Moderator
Posts: 1087
Joined: Wed Feb 23, 2011 7:26 pm

Re: Export to excel - DDE - Angle Format

Post by US_Helpdesk » Wed Jun 22, 2016 12:46 pm

This could also be done in CMM-Manager if you add a loop within the program and then use VB Script to calculate Min / Max / Range / etc. The Excel solution is usally more along the lines of the average users comfort zone, most users will not be willing to use VB.
I've migrated to a new user account, see my other posts here

Post Reply