Forum Discussion
Excel Help - Student Attendance
I've attached a three week version, 5-day weeks only, and you should always make sure to enter a Monday date. I skip over the Saturday and Sunday in the two weekends in the middle of this span of days.
Have you tested adding a full data set? Even a full weeks worth of data?
The only odd thing I notice in your video is what I've captured in this screen grab
It's odd that the date and time are appearing as strings of hashmarks for that one column, but not the adjacent one. Making me wonder if somehow the data are not in consistent formats. Are you copying this from a CSV file? What you sent me, I believe, were always XLS or XLSX files. If it's a CSV file, try importing it to the Excel format first before copying.
Two suggestions:
- Keep separate workbooks for each of your several classes.
- Eliminate from the workbook's raw data sheet all but columns A through I (those aren't used in the summary calculations).
See the attached to see how the latter operates, and try copying and pasting in just those first 9 columns from your incoming data sheets,
I have tried a couple of times now and have done a speed test, and have a great connection & it's not wanting to import more data (the longest I've waited is about 10 minutes). I still don't have a ton imported - only about 1/8 of what I need at this point in the year, and this has to last me through January, as far as data imported. It may be just too much data to handle.
- We could limit the columns imported to just the ones used in the summary, but that’s its own complication. Let’s see when you’ve got a good connection, etc.
Or do a different workbook for each class.