I'm in the process of writing another NXDN calculator in Excel that will hopefully be customizable depending on the date that you enter into it. I took WX4JCW's info on his sheet,as well as the other information I've found here. The problems that I kept coming up with is that nothing seems to follow the standard settings. So in my program, you enter 2 known channel numbers and their frequencies, and it will give you the Step Size as well as the Base Frequency, and then entering a NXDN channel number will display the frequency for that channel, even displays 10 lower and 10 higher than the entered channel.
I would also like to have where you can enter a frequency, and given the base, step size, and frequency, I would like it to find the Channel number.
I know the formula to find the Frequency is this:
Freq = Base + ((Channel - 1) * Step Size)
I'm hoping someone that is good in algabra can come up with a formula from the above that will let you have the Freq, Base, and Step Size and display Channel. Any takers!?!?!?!
Edit: Also if you do come up with the formula, maybe you know enough about excel to send me the formula that will work in excel!