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,"##.##"),"""")
Will return:
78° 21' 33.38"
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,"##.##"),"""")
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:
If cell “E19” is 78.359272 in degrees decimal then: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,"##.##"),"""")
Will return:
78° 21' 33.38"
Im not sure what CSV, I will look into it, but this is my scenario: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?
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.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.
Code: Select all
=CONCATENATE(MIN(D2:D128),"-",MAX(D2:D128))
I just read the OP post and figured he got it to work within cmm managerveedubnut115 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.