Established: January, 1958 an ARRL Affiliated Club since 1961
"Whiskey 8 Quack Quack Quack"
Meets at: James P. Capitan Center, Lower Level; 149 E. Corunna Ave.; Corunna, MI 48817 Monthly: 2nd Tuesday @ 7:00 PM
Club station located in the James P. Capitan Center - Lower Level.
Grid Square EN72wx Latitude: 42.9819 N Longitude: -84.1164 W Alitude: 760 ft.
Quickly Find Something! Select your Search Range ~ either choice opens in a new Window.
For most of the 'what if' calculation requirements in the amateur radio field it is very hard to get better then using 'Excel Worksheets' (Copyright by Microsoft). The ability to modify input values and immediately see the resulting output values is great for the hobbyist. To that end here are some workseets for you to download, modify and use. If you have comments on these or suggested improvements please send feedback.
In general input values will be set up in a 'blue shaded' or 'Yellow shaded' cell(s) for ease of identification. You may study and modify as you wish. General practice is to keep a backup of the file - BEFORE - you modify values. if you 'over write' a cell that contains intermediate values or formulas, then the sheet will stop working properly. Recovery can become difficult, unless you have a 'backup' copy or come back for a new download.
Sheets were created in Microsoft Office 16 (2019) version.
Microsoft Excel can make many simple transmission line calculations very easy. The following worksheet assumes lossless transmission lines and operations at low SWR conditions. Results will depart from these calculations as you leave these assumptions. Use at your own risk and make sure results apply to your situation. The sheet can easily be modified to your exact needs. Input areas are 'shaded blue' and you can freely change values to fit your needs. It can replace a Smith Chart for calculations included.
The Transmission Line Calculation worksheet is divided into several functional areas. Inputs will be on the left side of the sheet and results for that function will be to the right.
List of Calculations available:Tab # One ~ Resonance & Stubs
Many popular coaxial cable types listed with physical values -- look for those velocity factor values needed in the 'Resonance & Stubs' tab.
If you use Microsoft Excel and want to have your own 'Beam Headings' calculator try out our spreadsheet. The sheet can easily be modified to your exact location to meet your needs. It is setup for printing a list to many DX locations
INSTRUCTIONS are contained on a tab in the worksheet.
Do run most digital modes you will be required to have an accurate time measurement on your computer system. If you use the 'standard Windows' setup you will fail ! So let's modify your computer time settings to get time updates from a valid public time server.
Lets initially test your computer as is to see how it is doing. Open any web browser. In the URL address field enter: time.is
What is your time comparison to the time.is site? It is under the 'Your time' above the clock. So lets change your system time server update to get a more accurate time.
Go to: Meinberg NTP Download Software and select 'NTP for Windows XP and newer, with IPv6 support'. This is currently v.4.2.8p11 (May, 2018). I suggest you make a directory on your C: drive called 'tools' and run the program and install it into the tools subdirectory.
Create a an initial configuration by checking the tick box. IMPORTANT: Choose the correct location in the drop down list, I use 'North America/United States'. Tick the box for 'fast initial sync mode' (uses a 'burst mode'). In the next box use the 'system' type and continue. Defaults work for all the other settings. Finish the installation and exit.
On Windows 10 (and newer), that should be all that is required. Some older versions require you to go into Control Panel and then time setting and turn off the Internet Time Synchronization.
Let's run the time.is check again. If it is still running in your browser, hit 'F5' to reload the page. Your time should now be more accurate and it will automatically update to keep it accurate in the future (assuming you have an internet connetion, as that is how it updates). My systems run within a few hundredths of a second while connected and a few tenths of a second for short times when I do not have the internet connections available.
Your computer system time will now be accurate enough to work with the digital mode software you choose.
Marine Traffic Link Dec 8 2018