Convert raw decimal lat/long data points to lat/long DD

[tsa8786]

Hello,
Am seeking expert assistance in creating a spreadsheet that will convert recorded raw decimal values to latitude and longitude degrees decimal (Lat XX.xxxxxxxx, Long XXX.xxxxxxxx) format.
The recorder records data this way:
4 words per frame
4 sub frames per frame
12 bits per word

Parameters:
Latitude
Lat1, word 26, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat2, word 58, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat3, word 90, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat4, word 122, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.

Longitude
Lon1, word 10, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon2, word 42, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon3, word 74, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon4, word 106, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.

With the above information, the lat coefficient is 0.125 and the lon is 0.25

Thanks for the help anyone can provide.

Respectfully,

Tim

 

[shg]

Is this data in a spreadsheet, a text file, a binary file, ...?

Does it follow some published format?

 

[tsa8786]

Both spreadsheet and text file. Think can export just the lat and long from the main binary file, in binary format. It is recorded 4 times per sec, late to lat4. Does this help? The recorder is a 128 wpf system. Would a type file of your choice be helpful if able yo send?

 

[tsa8786]

Is there a way in here to upload a file to you?

 

[shg]

You can put the files on box.net and post a link.