Frequency Database and RDS Log - SQLite comparison

What you need to run the software
DaveB
Posts: 78
Joined: Sat Sep 05, 2020 10:32 am

Re: Frequency Database and RDS Log - SQLite comparison

#11

Unread post by DaveB »

G0OFE wrote: Fri Aug 20, 2021 3:50 pm
Need a new column with a formula - e.g A2/1000000 - it's what I did.
I knew that! :D But it is a bit more subtle than that because I've a number of frequencies offset by 13 kHz to improve RDS detection next to strong locals. It will probably be easier to change these frequencies in favourites to use the offset filter setting.
I aalso need to check I haven't accidentally got one lot of frequencies imported as text and ended up with a data type mismatch - it won't be the first time!

Incidentally you shouldn't need a new column, you could use a formula within the vlookup function
eg =vlookup((A1*10^-6);'table'A1:B100);1,0). That's the formula I use in another table where one set of frequency data is in Hz and the other set of data is MHz.

User avatar
G0OFE
Posts: 435
Joined: Thu Aug 06, 2020 7:33 am
Location: Sunny Sunny Bournemouth IO90BR
Contact:

Re: Frequency Database and RDS Log - SQLite comparison

#12

Unread post by G0OFE »

Ah. Knew there might be a less clunky way of doing it!
Jim, Bournemouth IO90BR
Image

Post Reply