New DX Report Experiment

For those interested in DX - submit your VHF-LO band skip and tropospheric ducting reception reports and comments here.

Post Reply
Message
Author
User avatar
Scott
Site Administrator
Posts: 7474
Joined: 18 Aug 2005 12:00
Location: Cape Cod, Massachusetts
Contact:

New DX Report Experiment

#1 Post by Scott » 06 Oct 2016 20:02

I have a new experiment I'd like to try out for those of you that enjoy the DX spotting we do during tropo band openings. It's a relatively simple setup using Google Forms and Google Spreadsheets. The nice thing about this from my standpoint is that it doesn't add to the already hefty database being used for the forums, and it's a pretty simple thing to set up and use. I've tested it from an end-user standpoint and it seems to be accessible and working fine.

To post DX reports and view the list, registered/approved users may access the DX drop-down option on the menu-bar. This is not visible to guests.

Things I need to improve/learn:

1. How to sort the spreadsheet so the latest hits show at the top. There are scripts that describe how to make it work but I'm trying to wrap what's left of my brain around what exactly needs to be done to accomplish it. In the meantime anyone can sort the database by any of the fields by clicking on the header's down arrow.

2. How to retain the amount of characters to the right of the decimal point for both frequency and tone columns. For either it's not the end of the world, for PL entries of say 123.0 it's only showing 123.

If those of you that post DX data could please give this a shot I'd appreciate it. Suggestions (to include telling me to pound sand) are as always welcome. :)
Scott

User avatar
ecps92
Wiki Administrator
Posts: 4784
Joined: 07 Dec 2005 19:26
Location: South Shore, MA
Contact:

#2 Post by ecps92 » 07 Oct 2016 06:46

For the Data, generally you should be able to set (Like in Excel) the format of the Cell.
Instead of Numeric/Number, change the PL field to be TEXT and the PL and Freq issues would be eliminated
Bill Dunn N1KUG
Cruise Ship Frequencies
http://scanmaritime.com

"The tougher it is to find a frequency, the more it makes me want to work to find it. - I've learned to use the SEARCH Button"

User avatar
Scott
Site Administrator
Posts: 7474
Joined: 18 Aug 2005 12:00
Location: Cape Cod, Massachusetts
Contact:

#3 Post by Scott » 07 Oct 2016 09:04

ecps92 wrote:For the Data, generally you should be able to set (Like in Excel) the format of the Cell.
Instead of Numeric/Number, change the PL field to be TEXT and the PL and Freq issues would be eliminated
No worky. In Excel I format the cells in a column as a number and run the places to the right of the decimal point out to 5. Works like a champ. I do this with Excel when I update the NE FCC Database.

There are some quirks with the spreadsheets in Google. I'm still trying to figure out the script that puts the newest report at the top without the user having to re-sort it. Overall it works pretty good, and it would be nice if it actually gets used by someone other than me. It's nice to be able to copy/paste the format into DX report threads.
Scott

User avatar
Scott
Site Administrator
Posts: 7474
Joined: 18 Aug 2005 12:00
Location: Cape Cod, Massachusetts
Contact:

#4 Post by Scott » 07 Oct 2016 22:28

Fixed spreadsheet to show newest posts at top. Still working on frequency and tone issues.
Scott

N1TUI

Adding places after the decimal point

#5 Post by N1TUI » 18 Nov 2016 09:43

Scott SNE Webmaster wrote:Fixed spreadsheet to show newest posts at top. Still working on frequency and tone issues.
I have had success adding places after the decimal point in excel by:
Selecting the cell or column
Right click and go to Format Cells
Select Numbers
Increase the Decimal places to 4 (or what ever you prefer)
Click on OK to save the change

Hopefully, the existing cells with the additional places will display correctly.

Edit: I guess I should have looked at it first. It looks like you got it.

Regards


Frank

Post Reply