Before each net
- Click CCARES Roll Call in the Start Menu or on the desktop.
- A small window shows each step while it downloads the newest roll call from cherokee-ares.org.
- The roll call opens in Excel as
CCARES-RollCall-Template-DD-Mon-YYYY.xlsminC:\CCARES Roll Calls. No "Enable Editing" bar and no blocked macros. - 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.
- 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
- It opens the roll call you already have for today. A roll call you have filled in is never replaced.
- If the website has a newer roll call since then (for example, a member was added), it asks:
Open Mine or Get the Newer One. The newer one is saved beside yours as
…-2.xlsm. - New Copy saves a fresh, empty roll call beside yours any time, for example for a second net that day.
- Each day gets its own file, so tomorrow starts fresh by itself. Old roll calls stay in the folder until you delete them.
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
- The folder
C:\CCARES Roll Calls(the app itself is in itsappfolder). - Excel trusts that folder, for your Windows user only. That is what lets the roll call's buttons and FCC lookup run. The app saves a roll call there only if it passes its safety check: the Cherokee ARES roll-call macros exactly, nothing added, nothing linked from outside.
- CCARES Roll Call shortcuts in the Start Menu and on the desktop.
Keep other Excel files out of C:\CCARES Roll Calls: Excel runs macros in that folder
without asking.
Problems
- "Couldn't download the roll call": check the internet connection and click the shortcut again. If you have a roll call from an earlier day, it opens that one meanwhile.
- "Didn't pass the safety check": the roll call on the website has changed in a way this version of the app
doesn't know yet. Usually Update Now fixes it; otherwise download the newest Roll Call App from the
training page and run its
install.batagain. - Excel still blocks the macros: on PCs managed by an employer, IT may have turned off trusted folders. The roll call still works by hand: type x under the mode on a station's row, and Ctrl+Shift+; for times.
- No name from the FCC: the lookup needs internet and Excel for Windows (2013 or later). Type the name in.
- Shortcut missing or Python moved: run
install.batfrom the Roll Call App download again. Your roll calls are kept. - Every run is written to
C:\CCARES Roll Calls\CCARES-RollCall.log, which helps when asking for help.
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.