Hello CB,
I am working a festival down here in DC and one of my jobs is to handle radio tracking and they are Motorola XPR 3500e series walkies. Now my boss wants me to digitalize tracking them. So here is what I came up with so far. Each radio has a S/N on the back of each and we do have a bar code scanner which does scan the S/N nicely into a excel spreadsheet. So I printed out a sign out sheet for the radios just to get some basic information from the person signing out the radio (Name, contact #, time/date..etc.) I would then take that information and type it information into the excel spreadsheet. The S/N will just be scanned into the spreadsheet. We will have about 50 or so radios out and about during the festival.
Short version of steps to sign out (example)
1. Susan fills out sign out info (Name,date, time, contact #)
2. I give them Radio # F3717
3. I upload info in the spreadsheet
4. We can now track that Susan has radio F3717 and how to contact her if we need back.
Just looking for Suggestion/discussion points to see if this is as good as I think it is or if someone else has done something like this and can give me a few pointers.
Thanks,
J
I am working a festival down here in DC and one of my jobs is to handle radio tracking and they are Motorola XPR 3500e series walkies. Now my boss wants me to digitalize tracking them. So here is what I came up with so far. Each radio has a S/N on the back of each and we do have a bar code scanner which does scan the S/N nicely into a excel spreadsheet. So I printed out a sign out sheet for the radios just to get some basic information from the person signing out the radio (Name, contact #, time/date..etc.) I would then take that information and type it information into the excel spreadsheet. The S/N will just be scanned into the spreadsheet. We will have about 50 or so radios out and about during the festival.
Short version of steps to sign out (example)
1. Susan fills out sign out info (Name,date, time, contact #)
2. I give them Radio # F3717
3. I upload info in the spreadsheet
4. We can now track that Susan has radio F3717 and how to contact her if we need back.
Just looking for Suggestion/discussion points to see if this is as good as I think it is or if someone else has done something like this and can give me a few pointers.
Thanks,
J