roster

I'm in the process of redoing a dashboard and I've gotten the main layout done as well as all of the formulas. One of the things I'm running in to is a problem updating tables across multiple sheets. Here's the predicament: - The main sheet holds a list of names broken down into 6 different...

I would like to display only certain .xl files, eg *roster*.xls* I have tried both sides of the filter and the best I get is all .xls*. Can I narrow it down to only files with roster in the name? ' Set up file listings FileInfo = "EXCELL files (*.xls*),*.xl*" ' Set Dialog Box caption...

Hi there I am currently using the following to calculate time range in one column: =IF(ISNUMBER(FIND("/",C5)),0.5+MOD(SUBSTITUTE(RIGHT(C5,5),"-","")-SUBSTITUTE(MID(C5,FIND("/",C5)+1,5),"-",""),-0.5),0)+0.5+MOD(SUBSTITUTE(MID(C5,FIND("-",C5)+1,5),"/","")-SUBSTITUTE(LEFT(C5,5),"-",""),-0.5)...

Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas already set on 2 separate sheets that calculate the amount of people toward the manager ID and subtract in another column by total of unexcused from the...

Hi everyone, I am new to the forum and while I enjoy using excel (2010), I am still very much a novice. I would truly appreciate some help designing a summary attendance sheet that would pull information from across sheets for each individual class. Here is what ideally I would need for it...

Greetings, This particular problem has been perplexing me for a few years now. The process I require seems such a likely candidate for automation in some way, but my knowledge gap means that it has always been a tedious manual procedure. I'm using Excel 2007. Please consider the following...

Dear Excel Community, I run an events company operating Christmas grottos throughout the UK. Key to what we do is the rostering of staff. I have an Excel template, into which on the first tab I put the opening hours of grottos and it will populate the correct shift patterns for Santa and his...

I have with me a table (duty roster) which shows a column showing each days of the month, and then for the row headings the name of about 15 soldiers. Every day there will be one person on duty (with one cell labelled as "1") and one on reserved (with one cell named as "R"). Some of them will...

I have a list of 214 names in column A. Column B has a room number that students belong in next to each name. I need to create a list of names for each room number in columns C, D and E. When I put a number in column B next to the name of a student in column A how can I get the lists to populate...

Hi guy im trying to create a roster 14 days on and 7 days off can anyone help me basically i should drag the formula and it will show 7 consecutive blank cells if 14 days passed and so on as u can see in the table. This is being used in the mines it would really help you if you say you know...

Hi, I am trying to make a database for a school, to make an automated roster. There are four entities: Teachers: t1-Jones, t2-Smith, t3-Paddington, t4-..... Classes: c1-YearOne, c2-YearTwo, c3-YearThree, c4-..... Subjects: s1-English, s2-Math, s3-Grammar, s4-..... Hours per class per teacher...

Dear Friends, I've just a Tast of Excel and not much of an Advance user. I've a Problem I wanna ask you guys. Theres this weekly Roster which is shared to our team by the Roster making team. The Roster follows certain pattern that is there are like for example 5 Teams working in a Unit...

<link rel="File-List" href="file:///C:%5CUsers%5CJonathon%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CJonathon%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping"...

Hi there. I have the following arrangement (although it's much larger with 30 categories across and a day for every year downwards): <TABLE style="WIDTH: 202pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=269><COLGROUP><COL style="WIDTH: 58pt; mso-width-source...

Hi all, this is my first post and I could really use some help on this one... I write a weekly schedule with in times for an AM shift and a PM shift. The number of people on each shift vary from day to day and week to week. Weekly schedule looks like...

Hi all, This is my first post to this forum. Hope i get some valuable replies here. :) I am trying to create a simple BiWeekly roster (extendable to Monthly) for my workflow support team using either VBA or worksheet functions though i am not able to proceed further than the design...