Create a seat assigner with Excel and RFID

Anonymous
2020-04-16T23:26:27+00:00

Hi, 

Due to Covid19, we are tracking who sits with who in the cafeteria.

We have a simple Excel file that assigns a seat in the cafeteria to the employees based on the RFID. It is very simple, We have a Seat column with seats from 1-135, they scan their badge, the ID number appears on the ID column, then there is a name column with a Vlookup based on the ID that enters the name of the employee and that is it. 

The issue we have is that, sometimes it assigns a seat that is still taken. I cannot think of a way in which the employee scans their badge again and the record is deleted from the seat number so that it is now free for someone else :S and doing that without losing the original records of where the person sat. 

Any ideas would be highly appreciatted

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2020-04-23T05:33:48+00:00

@ Debbie.

I have no scanners here, so I typed in the ID numbers

1- Before the start

The SCAN sheet will look like this, The scanner will be focused on cell C3 Named range ScanID 

2- After the first 10 scan (employees)

After the first 10 scan (employees) on each sheet 

RECORD/TRACKING before any check-out.

3- After some of the staff check out

Conditional Formatting is applied to cells 

the ones in Yellow shows those who are taking more than 30 min in their lunchtime and obviously haven't been checked out.

Hope this helps

Regards

Jeovany

Was this answer helpful?

4 people found this answer helpful.
0 comments

50 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2020-05-11T15:14:44+00:00

    Thank you both for your responses! I really am thankful

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-05-08T09:53:30+00:00

    @ Rohn

    That is exactly what I meant, 

    English is not my native language, I was struggling with the correct way to say that. LoL

    Thank you, for your input.

    Regards.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-05-08T02:25:34+00:00

    From the health point of view amid the COVID-19, what's the point to track some employees and not others. In the unfortunate event of a COVID positive case, you won't even have the names of those Visitors/Contractors".

    So the spreadsheet will have no meaning then.

    Jeovany made a very good point about needing unique ID's to track people in case of an outbreak.

    .

    But, he forgot, that is not the intent of this spreadsheet. It only enforces physical separation. But since the sheet does not keep historical information, it is useless for contact tracking.

    .

    In other words, maybe this is the point where you should ask your managers if that is what they want to do. The app would then have to be extended to keep historical information

    .

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-05-07T22:30:23+00:00

    Yes, for some reason it was telling me the features were not available, but i switched accounts and was able to download and open in Excel. Thanks!

    I'm glad you did get it to work.

    I'm willing to help you at any time, so don't hesitate to contact us.

    Unfortunately, your bosses asked you to do something that is not only in their hands to be solved but is their duty.

    From the health point of view amid the COVID-19, what's the point to track some employees and not others. In the unfortunate event of a COVID positive case, you won't even have the names of those Visitors/Contractors".

    So the spreadsheet will have no meaning then.

    But anyway I hope you will get soon the help from them as well as you get it from this community.

    Regards,

    Stay safe, Stay healthy

    Was this answer helpful?

    0 comments