I have created an Excel SpreadSheet that compares the uploaded Merit Badge Counselor file to the resulting list downloaded from ScoutBook. It is attached below. The first sheet is where the data and action happens. The second sheet, “Instructions” tells you how to import the files and setup the compare.
Hope that you find it useful. One warning, the xls file contains a Macro that is used to count the number of words in the Badges list. Since the order of badges from ScoutBook is not sorted, I count the words to compare the upload and download. While not perfect, it normally catches dropped badges.
Hope you find it useful.
ScoutBook Upload Compare.xls (88 KB)