I've got a project to retrieve some historical data for a small local water district. The data was stored in an old PowerBase data base from the early 80's. No one has the data base software and I haven't been able to find it on line to this point. So I'm trying to extract the data from the backup tables. Plain text like name and address info. is in ASCII, but the numbers and dates are stored via some algorithm.

Anyone have any suggestions as to how to extract these numbers & dates?

See example in hex below. Field descriptions are at the bottom. This read - Last read = gal uses. The dates should be toward the end of each month listed. The readings should be a 7 to 9 digit number. The gallons used should be a 5 digit number. You can see how the dates change month to month as well. The first 11 bytes are two key fields.

4E 00 00 00 00 00 00 00 00 24 87 00 00 00 00 20 A0 3C 94 00 00 00 00 C0 07 4B 94 00 00 00 00 00 7A 66 90 00 80 00 00 00 00 B0 C3 31 94 00 00 00 00 A0 C3 31 94 APR 93
4F 00 00 00 00 00 00 00 00 24 87 00 00 00 00 C0 07 4B 94 00 00 00 00 80 E8 4D 94 00 00 00 00 00 30 38 8E 00 80 00 00 00 00 B0 C5 31 94 00 00 00 00 70 C5 31 94 MAY 93
4F 00 00 00 00 00 00 00 00 24 87 00 00 00 00 80 E8 4D 94 00 00 00 00 60 95 52 94 00 00 00 00 00 9C 15 8F 00 80 00 00 00 00 60 C7 31 94 00 00 00 00 60 C7 31 94 JUN 93
4F 00 00 00 00 00 00 00 00 24 87 00 00 00 00 60 95 52 94 00 00 00 00 20 1B 58 94 00 00 00 00 00 B8 30 8F 00 80 00 00 00 00 50 C9 31 94 00 00 00 00 50 C9 31 94 JUL 93
AUG 93
4F 00 00 00 00 00 00 00 00 24 87 00 00 00 00 40 6F 5C 94 00 00 00 00 80 1C 60 94 00 00 00 00 00 50 6B 8E 00 80 00 00 00 00 10 CD 31 94 00 00 00 00 10 CD 31 94 SEP 93
4E 00 00 00 00 00 00 00 00 24 87 00 00 00 00 80 1C 60 94 00 00 00 00 E0 FA 62 94 00 00 00 00 00 98 37 8E 00 80 00 00 00 00 00 CF 31 94 00 00 00 00 00 CF 31 94 OCT 93
4F 00 00 00 00 00 00 00 00 24 87|00 00 00 00 E0 FA 62 94|00 00 00 00 E0 FA 62 94|00 00 00 00 00 00 00 00|00 80|00 00 00 00 30 EB 31 94|00 00 00 00 F0 D0 31 94 NOV 93
DEC 93
R# Name Cd last read this read Gal used recheck read date