attendance

First, this is long, but I want to be as descriptive as possible. This modeling is explores using basic attendance data to enrich decisions (which folks to call to keep attendance up). THE PROBLEM/QUESTION: I need help in #excel.I'm using MS Office 2013 and want to model attendance records...

Hi all I'm trying to create a macro to basically record attendances at meetings. So far, my macro opens the right sheet of a different book, enters the names on the left most column, the date at the top of the next available row, and deletes any duplicated names. What I want to be able to...

I run a sporting club of about 80 people of whom 40 may be in attendance on any one night. I would like to have a form that displays every members name and a tickbox ( or something similar) next to it, so I can simply tick off the members as they come in ( or they can tick their own name)...

Hi, This is my fist post on here, I have tried searching for a previous thread on this topic but cannot find on. I am trying to create a 'simple' spreadsheet which will allow me to check how many children are going to be attending my nursery and split them into the different age bands. The...

Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I am very new to access, with moderate experience with VBA in excel. In Access I am trying to create an Attendance database for a group I help out with. Below is a schematic of what I am trying to...

Hi, I'm developing a spreadsheet through Google Docs that lists students in attendance per day of class (by date). The prerequisite for assessment is a certain number of days in class that increases as your level does. Would it be possible to make a formula that counts occurances attached to...

i am preparing an attendance tracker in excel 2007. In a company the login time is 10 am. and as per the time their status should get updated 10:00am - 10:15am - late 10:15am - 11:30am - Permission 11:30am - 3:00pm - halfday 3:00pm onward - fullday off or leave i have been able to use 2 nested...

I am making an attendance template that will record the login/logout time of each employee. Each employee has their own file which is linked to a summary file that collates all the information for all employees. My problem is that not all workstations are set in the same region. Meaning...

Another day, another project! I am creating an attendance sheet db in which a user will be able to see the info for a particular group and edit the attendance (via checkboxes at this time) for 12-13 weeks. The number of weeks could vary in the future, so not sure how to take that into account...

Hi I'm new to this forum and am asking for some advise for a spreadsheet for school attendance. The students have the option to come to a class or not There are approx. 20 different subject classes a day There are 4 periods a day There are approx. 100 students There are about 20 different...

I am stuck trying to track attendance for Practice and Games for my girls softball team. I would like to track the current % based on where we are in the season. We start with 6 practices and then go into a 12 game season.

Hope someone can help with this problem. I need to be able to count the number of "P"'s or "A"'s, etc, after a name. And the name can appear several times on many rows. For example: The top group sums the number of times the different letters appear next to the names below. <TABLE...

Hi, We have been running an event for students, there have been 6 and there will be a total of 8 of them. The first one had 610 students, then 902, 1358, 1260, 1601, 1457. I can't figure out how to chart the average growth, the growth from event to event and how to project the number of the...

So far I've been unable to get help with this and am hoping to find it here. I am using the following formula to calculate points for the first 90 day period(first 90 rows). IF(H4="","",IF(W4="","",IF(H4>0,IF(W4>0,IF(B4-$B$4<=90,SUM($H$4:H4)))))) Beginning with the 91st row(actual row 94)...