
Now, we have a real map to track your progress on Working all States. Worked All States v1.0 Tanner, W9TWJ, uses the power of Microsoft Excel 2016 to break the boundaries of just arranging squares to look like the U.S. As an added benefit, the map includes the name of the person I worked in the grid square (1) to remind of who to be thankful for, and (2) to let others know who is or has operated from a needed grid square. This map helps keep track of the chase to confirm all 488 maidenhead grid squares in the Continental United States – The GridMaster Award.
#Us grid mapping manual#
GridMaster Map v1.0 Where it all began – just a fancy coloring book, with 100% manual input. In addition to color coded grid squares and station worked, the legend tabulates totals by type for chasing the GridMaster Award, as well as VUCC. The main GridMaster Map worksheet captures inputs from one of three supporting worksheets (Confirmed in LoTW, Confirmed by QSL, and Worked Unconfirmed) and displays them appropriately on the GridMaster Map. GridMaster Map v2.0 In v2.0, Chris, K7TAB, has transformed my original map – a manual input, Excel coloring book – into a more sophisticated, semi-automated, GridMaster tracking tool. Second is the “Roved” tab, which will highlight grids you have activated in red. The first is “Sked” tab to post upcoming rover announcements for grids you need, which will post the rover’s call sign in the grid on the GridMaster Map. All three grids have 1-km spacing and are projected to the DNAG projection (spherical transverse mercator, central meridian of 100 o W, base latitude of 0 o, scale factor of. GridMaster Map v2.1 Gridmaster Map with Roving-Sked-Hero In v2.1, Chris, K7TAB, adds two additional features to the semi-automated GridMaster Map. Details on the data processing and compilation procedures used to produce the grids are described in the booklet that accompanies the North American magnetic anomaly map. GridMaster Map v2.2 An informally (limited) released version of GridMaster Map, where Chris, K7TAB, adds two tabs to track the total confirmed grids by operator from information entered to generate the GridMaster Map. GridMaster Map v2.3 In v2.2, Tanner, W9TWJ, streamlines the unreleased features of v2.2, to add the ability to generate a report the total grids confirmed by operator, including operators who have operated with more than one call sign. I only hope that it helps you as much as it helps me.
#Us grid mapping free#
Nothing proprietary here, so feel free to use it as you would like. Don’t ask me how I came up with this last tip. Just be sure to re-protect the sheet once you are done editing.
#Us grid mapping password#
Should you need to modify it, the password is either amsat or AMSAT.

Note: Certain worksheets are protected to prevent accidental overwrite of formulas and conditional formatting. Please click the link below for the latest version of GridMaster Map, or one of the other links for previous versions, as well as the Worked All States Map.

