CCARES Roll Call

Gets the newest Cherokee ARES roll call and opens it in Excel, with Check In and the FCC lookup working.

Before each net

  1. Click CCARES Roll Call in the Start Menu or on the desktop.
  2. A small window shows each step while it downloads the newest roll call from cherokee-ares.org.
  3. The roll call opens in Excel as CCARES-RollCall-Template-DD-Mon-YYYY.xlsm in C:\CCARES Roll Calls. No "Enable Editing" bar and no blocked macros.
  4. Run the net: type a callsign in Find call and press Enter, or click ✔ Check In. Now fills in the start and close times. Visitors' names and locations fill in from the FCC.
  5. Save as you go (Ctrl+S). When the net is done, the workbook's Email tab shows who to send it to.

What the window tells you

✔Done. On a normal day the window closes by itself a few seconds after Excel opens.
–Skipped, for example "couldn't check for a newer one" when the website didn't answer. Nothing to do.
!Needs a look: a newer roll call or a newer app is on the website. It asks what you want to do.
✖Something failed. The message says why and what to try.

The steps: Excel trusts the roll-call folder · this app is up to date · the roll call is downloaded · it passes the safety check · it is saved (or today's is already there) · it opens in Excel.

Running it again the same day

App updates

Each run checks the website for a newer version of this app. If there is one, the window says so and offers Update Now (a few seconds; your roll calls aren't touched) or Not Now (it asks again next time).

Updates are signed by the Cherokee ARES Manager maintainer. The app installs one only if the signature and every file check out; anything else is ignored.

What it changes on your PC

Keep other Excel files out of C:\CCARES Roll Calls: Excel runs macros in that folder without asking.

Problems

Remove

Double-click C:\CCARES Roll Calls\app\uninstall.bat. Excel stops trusting the folder and the shortcuts are removed. Your roll calls stay; delete the folder yourself if you don't need them.