Excel VSWR Spreadsheets

Message Topic Search Topic Options Post Reply Create New Topic Printable Version

   Excel Spreadsheets for UK & USA VSWR Values etc. 
The first file is for VSWR values of 1-2:1 Ratio.
The second file is an updated file which covers 1-30:1 VSWR Ratio & Includes VSWR dB.

Note: Both files have protection on them, I used my callsign GM0URD upper or lower case.
          You will have to remove this protection in Excel if you wish to transfer these files
          to a docked PDA device on your computer if you are using one, for the Windows
          PC to PDA file conversion to work correctly.

The Excel Sheet protection is only there to stop you from deleting entries by mistake.

uploads/17/VSWR_1-2_to_1.xls 

uploads/17/Conversion_of_VSWR_to_Return_Loss.xls

Edited by GM0URD - 24 Jun 2008 at 8:14pm

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version
GM0URD Members Profile Send Private Message Find Members Posts Add to Buddy List Member Joined: 29 Jan 2008 Location: Dunfermline Online Status: Offline Posts: 15	Quote Reply Topic: Excel VSWR Spreadsheets Posted: 22 Jun 2008 at 12:45pm
	Excel Spreadsheets for UK & USA VSWR Values etc. The first file is for VSWR values of 1-2:1 Ratio. The second file is an updated file which covers 1-30:1 VSWR Ratio & Includes VSWR dB. Note: Both files have protection on them, I used my callsign GM0URD upper or lower case. You will have to remove this protection in Excel if you wish to transfer these files to a docked PDA device on your computer if you are using one, for the Windows PC to PDA file conversion to work correctly. The Excel Sheet protection is only there to stop you from deleting entries by mistake. uploads/17/VSWR_1-2_to_1.xls uploads/17/Conversion_of_VSWR_to_Return_Loss.xls Edited by GM0URD - 24 Jun 2008 at 8:14pm

GM4WZG Members Profile Send Private Message Find Members Posts Add to Buddy List RAYNET&KARS member Joined: 22 Jan 2008 Location: Dalgety Bay Online Status: Offline Posts: 236	Quote Reply Posted: 24 Jun 2008 at 6:17pm
	Thanks for this - it has certainly taught me something - I never knew the Americans had a different measurement for VSWR ! On a technical point - its interesting to see the the loss figures but there must be some assumptions behind these because doesn't transmission loss depend on quite a few factors ? I guess these figures are for otherwise perfect transmission lines ? That kind of begs another question, because I always thought that if you had perfect transmission line, it probably wouldn't make any difference what the SWR was on it - you'd still have perfection. Lots of food for thought - I'm off to my ARRL handbook to check a few things out !! 73 Bernie Edited by GM4WZG - 24 Jun 2008 at 6:17pm