PDA

View Full Version : Scheduling Software/Excel Template/Etc



Bryan G.
11-09-2011, 04:06 AM
Hey guys I have some basic excel knowledge but I am looking for a template or software that I can input my employee names, there hours or better yet time in and time out and hours are calculated, pay rate and I will get daily totals from each that will be added up per day and if those totals can link to add up for the week, great. If you guys know where to look or have a template I would be appreciative. My time is really tight right now and I am having trouble searching or learning it all right now myself.

Thanks, Regards

Bryan

echerub
11-09-2011, 07:15 AM
You can do this step by step in Excel. You can have the following fields running from column A to whatever:
A - Employee, B - Date, C - Start, D - End, E - Weekstart, F - Hours

You type in A, B, C, D each day and for each employee. In Column E you would type in the first date for the first day of the week. You can then just copy this value for all entries that week. Column F would be =hours(D2-C2), and copy that as needed.

Are you familiar with pivot tables? You can then go Data -> Pivot Tables, grab data from $A:$E, yes there's a header row, put the pivot table in a new sheet, and then grab the following:

Employee, Weekstart on the left, Hours Worked in the main "body" of the table.

That ought to do it. This is just off the top of my head, but this ought to do the trick.

echerub
11-09-2011, 04:12 PM
Bryan, let me know your email addy by PM. I whipped up an Excel file that ought to do the trick for you. It's pretty much as above, but with a few tweaks. Nothing super-fancy, but it'll do the basics.

BTW, I forgot to add in the bit about hourly rate and pay above, but it's in the workbook that I put together.

Eamon Burke
11-09-2011, 08:44 PM
Dang, you excel wizard, you!

echerub
11-09-2011, 09:18 PM
I spend a bit more time than I'd like working with Excel :) On the other hand, maybe I'm a sucker for punishment because there's a "Information Dashboards" online course for Excel that I'm thinking of paying for...

kalaeb
11-09-2011, 10:49 PM
Ditto, Bryan pm me your email and I will send you the scheduling template I use.

echerub
11-09-2011, 11:39 PM
And if it's one that you're already using, there's a good chance it's a more polished one than what I put together ;)

TB_London
11-10-2011, 07:29 PM
Haha, I was planning on putting one together over the weekend as well, chance to learn some new excel skills without just creating dummy spreadsheets without a purpose. I'm used to analysing data rather than creating it.
Will be interesting to see what other people come up with, I have a tendency to make everything massively formula driven, but then when they break nobody knows how to fix it. Keeping it simple, yet doing everything neatly will take me a bit of experimenting, but will be a good learning curve

echerub
11-10-2011, 07:51 PM
I tend to do a lot of formulas as well - but really, that's what Excel is made for. The challenge for us is to make the interface for everyone else as easy as possible - something that I find can take at least as much effort as creating the rest of the structure to begin with.

Chef Niloc
11-11-2011, 10:35 AM
Give me your email and I'll send you the one I use

Chef Niloc
11-11-2011, 10:39 AM
O and for all of you that find the formulas a PATFA , try numbers for Mac much easer to use.

echerub
11-11-2011, 01:33 PM
Actually, the formulas are the fun part for me :D

Particularly things like VLOOKUP, IF(whatever), and for presentation purposes, conditional formating. Kinda like working with different ingredients to create something I can picture in my mind beforehand.