AikiWeb Aikido Forums

AikiWeb Aikido Forums (
-   General (
-   -   Attendance Tracking revisited (

LinTal 11-28-2011 04:29 AM

Attendance Tracking revisited
Hi guys,

I've been playing around with our member/visitor tracking system, thought someone might find this useful. There have been a few posts out there about tracking attendance and assets for different classes, there are some really amazing websites like Open Black Belt, The Dojo Manager and My Attendance Tracker. Sometimes, though, it's more convenient to have it tailored to needs as they change.

I hope this works when it's exported, let me know if it doesn't; it's a pretty simple spreadsheet made on Google Docs:

It's designed so that you just fill out a form after every class. (I know this works on an iPhone as well as a laptop, what about other phone types?) It updates the database itself and automatically appends new numbers into the graph. You can find that form here, feel free to try it out and then swap to the spreadsheet database and graph to see your responses tack on:

The form also carries out its own analytics, separate to any graphs you create from the data. You can find that in the menu under Tools>Form>Show Summary of Responses. In here it also compares attendance by student which might be useful if your aikido style grades by days at training.

(I'm pretty sure you can save it as a copy as it is with a Google Docs account. Let me know if not and I'll keep tweaking for a solution.)

lbb 11-28-2011 07:06 AM

Re: Attendance Tracking revisited
I made another one, for excel, that has some bells and whistles. You can insert a "test date" column, and depending on whether that column indicates that a person has tested, you either reset their hours or keep the total going forward. The "hours toward next test" field also has conditional formatting, so when the student has achieved the number of hours it shows in green and when they're getting close, it shows in amber. I don't think google spreadsheets can do all that I'm doing in this spreadsheet, but I'll share the excel with anyone who wants.

LinTal 11-28-2011 12:08 PM

Re: Attendance Tracking revisited
Wow, cool idea! I'd love a copy if you don't mind, I'd love to see how you did that (I think I just put all that in the too-hard basket). My email's here.

Would you mind if I integrate it with the one we use and the template above, or bits of it, if at all possible? I figure that between everyone on the forum we can make an uber-tracker. :) Does it need alot of formula insight to maintain?

Abasan 11-29-2011 06:09 PM

Re: Attendance Tracking revisited
Nice going...

LinTal 11-30-2011 04:48 AM

Re: Attendance Tracking revisited
Just an update; the graph sheet in the spreadsheet isn't showing up on an iPhone (what about other phones?), but can be seen when using a computer. Separate to that, the analytics section does allow graph viewing regardless. The form itself shows better promise for a mobile; use your phone to find the form web address, type 30 secs to 1.5 min, submit. It's worked so far, has anyone without a google docs account had a go?

All times are GMT -6. The time now is 05:13 PM.

Powered by: vBulletin
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.