Keep “Old Manifest” to allow easily cut and paste of applicants and VEs out of ET into a spreadsheet
I use the Old Manifest to populate my spreadsheets for my exams. I add all the VEs who have RSVPed to ET. Then go to the Old Manifest and copy/paste the VEs into a sheet. I copy the applicants into another sheet in the same work book. Those become the base for my session spreadsheet. Cut and paste from the browser works well and is quick. Download/export something, then open the PDF/file isn’t nearly as easy. As VEs crash my party, I can add them to the ET manifest and then pop over to Old Manifest to grab the VE info and pop it into my spreadsheet. I use the session stats to populate the expense report. Maybe the old manifest could be retained with a new title and purpose? Since I am using pieces of it for things, it need not be one page, but could be three different pages. Maybe something like quick view VE list, applicant list, or session stats.
Comments: 7
-
06 Jan, '21
Richard Bateman AdminWhat is the functionality that your spreadsheet provides that examtools doesn't? Not questioning the need, trying to understand it so that I can better understand how to solve the core problem -- because keeping the old manifest *is not going to happen*. That doesn't mean we can't find another (better!) way to solve your problem, but keeping that old code around just isn't a good idea for more reasons than I can conveniently list here.
-
06 Jan, '21
Heather KM6ZQBThe spreadsheet allows us to track both applicants and VEs as they arrive. We also use the spreadsheet to group VEs into rooms. I don’t share my spreadsheet with the regular VEs and it is for the main room staff mostly. Maybe pre-check. I use spreadsheet at the closing of my session to clean up my ET manifest. Remove VEs who RSVPed, but did not show. I also make notes about payment/waived, minors, coppa, special requests, needs, etc.
-
06 Jan, '21
Heather KM6ZQBI had 50 VEs in my last session and we really needed to be able to check in who was really there.
-
06 Jan, '21
n2ygkWhy not export the applicants list CSV to get them into your spreadsheet? The CSV has these columns:
"pin","firstname","middle","lastname","suffix","email","phone","frn","callsign","licenseClass","has_felony","created","finalized" -
06 Jan, '21
Heather KM6ZQBI do and that makes up the third tab of my workbook on which I keep track of payments. I only need the brief info which you include in the Old Manifest in a single tab.
-
06 Jan, '21
Richard BatemanThere are multiple ways we can approach this, but let's start with the simplest -- what is it that is easier to use with the old manifest which you don't have with the new one or doesn't work well with the new one?
-
06 Jan, '21
Heather KM6ZQBA list of VEs already in ET. The ability to cut and paste VE info quickly. If I could add one VE to my spreadsheet with cut and paste from ET. If I try it any other way, it doesn’t work as well. As I add VEs to the ET manifest, I can go grab the new info quickly and paste into the spreadsheet. Same with the last minute adds to the applicant roster. I end up with multiple exports of the applicant list for the same session.