MSExcel. Use barcode scanner to take attendance.

Dokončeno Zveřejněno Mar 10, 2014 K zaplacení v momentě doručení
Dokončeno 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.

Excel Microsoft

Identifikační číslo projektu: #5540239

O projektu

10 nabídek Projekt na dálku Aktivní Mar 11, 2014

Uděleno uživateli:

zExcel

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

$288 NZD za 2 dní
(254 recenzí)
7.6

10 Freelnceři na tento projekt zveřejňují nabídky v průměru $367

raghubhai90

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

$500 NZD za 5 dní
(64 Recenzí)
6.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Další

$350 NZD za 10 dní
(127 Recenzí)
6.3
XeeChaun

Hello Sir. it's a pleasure meeting a teacher here. I have worked a lot with excel automation and barcode stuff. I can provide you a sophisticated solution for this requirement. this is how I would like to do it: I Další

$300 NZD za 6 dní
(9 Recenzí)
5.2
hieutc

Hi, I could do this work for you. I just have some questions 1. If in one day, a person is scanned more than one, (i.e. at 2PM and 4PM) which should the script do: Overwrite the date with the new time, or create a Další

$300 NZD za 3 dní
(7 Recenzí)
4.2
CARLOSHUGGINS

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ší

$260 NZD za 3 dní
(4 Recenzí)
3.5
bogdanmurasan

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

$500 NZD za 10 dní
(0 Recenzí)
0.0
cwigginton

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ší

$555 NZD za 10 dní
(0 Recenzí)
0.0