MSExcel. Use barcode scanner to take attendance.
$250-750 NZD
K zaplacení v momentě doručení
I am a secondary school teacher.
Using a Barcode scanner, I would like to be able to take the attendance of large groups with their ID cards.
I found an amazing spreadsheet that was freely shared on [login to view URL] It was created by hiker95 and here is the link to it.
[login to view URL]
This sheet enables a barcode scanner to input an ID number into A1 and then a date and time is stamped alongside the respective person to which has that respective ID number relates to. After each number is processed, A1 is cleared and re-selected ready for the next entry.
I would like a modified version that allows for two columns of barcodes to be checked against. This is because the group of people I'm currently trying to track attendance of have one or two different ID cards they could use.
I would also like each new date that scanning place, an automatic column to be created with only the time stamped under the respective date alongside the correct person. If the date already exists, it simply puts in the correct time of scan eg. 2:45pm underneath the date, beside the respective ID holder. However, if the date hasn't yet been used yet, then it creates a new column on the right with that date listed at the top, and then the time at the bottom.
I would also like a column to tally the amount of attendances.
If there is any ID code that is not recognised, I would like the unknown fields to be filled with question marks like "???". This way, I can search up the ID's information later, and then fill in the fields that are missing. I would still like the time to be stamped however and the barcode recorded.
I have attached a picture of the proposed spreadsheet.
Identifikační číslo projektu: #5540239
O projektu
Uděleno uživateli:
Hi, My name is Jon and I will be happy to help you with this project. Please feel free to message me if you have any questions
10 Freelnceři na tento projekt zveřejňují nabídky v průměru $367
Hi sir, I understood the project need and all the requirements of this project and i'm sure i can do this task perfectly. Sir i need Maximum 5 days to complete this project perfectly :) Regards, Yogesh
Consider it done, I'm a 12 year experienced VBA, I will deliver a high quality result to your project, please take a minute to review my profile and see what other employers are saying about my past work... you could b Další
Hello, I'm sure i can make our spreadsheet as you want it to be, but the issue is time. Please contact me and let me now what is your dead line for this project. Best regards
I'll cut out all of the copied and pasted filler you are probably tired of reading from other bidders. The bottom line is that I know exactly how to create your check in sheet to your specs. I'm a certified Excel Další