set up a continuing roster?

how do i set up a continuing roster in excel, with names, months, dates?
0
petemack (3)
8/5/2005 1:36:04 PM
excel.misc 78881 articles. 5 followers. Follow

7 Replies
401 Views

Similar Articles

[PageSpeed] 8

You'll have to be  a little more specific as to what you want

--
neopolita

-----------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=61
View this thread: http://www.excelforum.com/showthread.php?threadid=39329

0
8/5/2005 3:27:50 PM
Hi

Are you talking a duty roster here?

If so, what type of shifts?  How many shifts per person per week/month?  
What hours are to be worked?

Is it a class roster?  How many periods per day?  What duration?  
-- 
j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa


"petemack" wrote:

> how do i set up a continuing roster in excel, with names, months, dates?
0
8/5/2005 3:55:05 PM

"Kassie" wrote:

> Hi
> 
> Are you talking a duty roster here?
> 
> If so, what type of shifts?  How many shifts per person per week/month?  
> What hours are to be worked?
> 
> Is it a class roster?  How many periods per day?  What duration?  
> -- 
> j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa
> 
> 
> "petemack" wrote:
> 
> > how do i set up a continuing roster in excel, with names, months, dates?

Hi Kassie,

yes it is a duty roster, can you send your email address to me and i will 
send you an example of what i mean and need??
0
petemack (3)
8/5/2005 5:34:02 PM
Just remove3 the "at" from atlantic.net
-- 
j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa


"petemack" wrote:

> 
> 
> "Kassie" wrote:
> 
> > Hi
> > 
> > Are you talking a duty roster here?
> > 
> > If so, what type of shifts?  How many shifts per person per week/month?  
> > What hours are to be worked?
> > 
> > Is it a class roster?  How many periods per day?  What duration?  
> > -- 
> > j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa
> > 
> > 
> > "petemack" wrote:
> > 
> > > how do i set up a continuing roster in excel, with names, months, dates?
> 
> Hi Kassie,
> 
> yes it is a duty roster, can you send your email address to me and i will 
> send you an example of what i mean and need??
0
8/5/2005 7:05:03 PM

"Kassie" wrote:

> Just remove3 the "at" from atlantic.net
> -- 
> j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa
> 
> 
> "petemack" wrote:
> 
> > 
> > 
> > "Kassie" wrote:
> > 
> > > Hi
> > > 
> > > Are you talking a duty roster here?
> > > 
> > > If so, what type of shifts?  How many shifts per person per week/month?  
> > > What hours are to be worked?
> > > 
> > > Is it a class roster?  How many periods per day?  What duration?  
> > > -- 
> > > j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa
> > > 
> > > 
> > > "petemack" wrote:
> > > 
> > > > how do i set up a continuing roster in excel, with names, months, dates?
> > 
> > Hi Kassie,
> > 
> > yes it is a duty roster, can you send your email address to me and i will 
> > send you an example of what i mean and need??


Sorry, i still dont get what you mean about your email address??

if i remove the "at" it wont send?

Pete
0
petemack (3)
8/5/2005 7:16:14 PM
j.kasselman@lantic.net
-- 
j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa


"petemack" wrote:

> 
> 
> "Kassie" wrote:
> 
> > Just remove3 the "at" from atlantic.net
> > -- 
> > j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa
> > 
> > 
> > "petemack" wrote:
> > 
> > > 
> > > 
> > > "Kassie" wrote:
> > > 
> > > > Hi
> > > > 
> > > > Are you talking a duty roster here?
> > > > 
> > > > If so, what type of shifts?  How many shifts per person per week/month?  
> > > > What hours are to be worked?
> > > > 
> > > > Is it a class roster?  How many periods per day?  What duration?  
> > > > -- 
> > > > j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa
> > > > 
> > > > 
> > > > "petemack" wrote:
> > > > 
> > > > > how do i set up a continuing roster in excel, with names, months, dates?
> > > 
> > > Hi Kassie,
> > > 
> > > yes it is a duty roster, can you send your email address to me and i will 
> > > send you an example of what i mean and need??
> 
> 
> Sorry, i still dont get what you mean about your email address??
> 
> if i remove the "at" it wont send?
> 
> Pete
0
8/5/2005 8:01:05 PM
Hi

Have you managed to sort your problem?  Haven't heard from you again?
-- 
j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa


"petemack" wrote:

> 
> 
> "Kassie" wrote:
> 
> > Just remove3 the "at" from atlantic.net
> > -- 
> > j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa
> > 
> > 
> > "petemack" wrote:
> > 
> > > 
> > > 
> > > "Kassie" wrote:
> > > 
> > > > Hi
> > > > 
> > > > Are you talking a duty roster here?
> > > > 
> > > > If so, what type of shifts?  How many shifts per person per week/month?  
> > > > What hours are to be worked?
> > > > 
> > > > Is it a class roster?  How many periods per day?  What duration?  
> > > > -- 
> > > > j.kasselman@atlantic.net.remove_2nd_at.  Randburg, Gauteng, South Africa
> > > > 
> > > > 
> > > > "petemack" wrote:
> > > > 
> > > > > how do i set up a continuing roster in excel, with names, months, dates?
> > > 
> > > Hi Kassie,
> > > 
> > > yes it is a duty roster, can you send your email address to me and i will 
> > > send you an example of what i mean and need??
> 
> 
> Sorry, i still dont get what you mean about your email address??
> 
> if i remove the "at" it wont send?
> 
> Pete
0
8/7/2005 7:14:01 PM
Reply:

Similar Artilces:

Offline setting in Outlook 2002
Running a laptop with Windows XP SP1 & Outlook 2002. Outlook is configured as a MAPI client (for use w/ Exchange 2000 server). User also has an .ost file configured locally on the laptop. The laptop is often connected to the corporate network via VPN using a Cisco VPN client. From time to time, while connected via VPN, Outlook goes into Offline mode. Restarting Outlook does not result in the program coming out of Offline status. I've found that the only way to resolve this issue is for the user to log off/on again and restart Outlook. At present, I've configured Outloo...

Find and Replace against set of rules in 2nd table/worksheet
Looking for a tool, or code that does the following. Edit [partial cell data] in Sheet1, if [partial cell data] meets criteria in Sheet2, COL1. Sheet2, COL2 has the REPLACE WITH information. Presently there are 59 criteria on Sheet 2, and I have to perform this against 19 sites. So doing this manual via Find and Replace takes forever. VBA code, or something similar would be great. (Wanted to write an Update Query Access, but Access sent me here.) Thanks in Advance TBL1 COL1 Mari Johnson Jim Evans Charles Stanley Jerry Straight TBL2 COL1 COL2 Mari Mary Straight Strait See,...

I need help with printer settings in Vista
In XP, I used to be able to go into options and tell it to use print settings from document or from printer, and if I used a template for a specialty paper(i.e.: Avery 2-up postcard), it would print out correctly. I am now using Vista w/Office 2003 & an HP Officejet 7310, and I can't get anything to print right. I am using a Publisher Template to print out my business cards on micro-perfed business card stock (2 across & 5 down), but no matter how I change the background size, change margins on the Layout Guide or Page Settings, it prints slightly off. My business cards ...

Setting CStatic object Bacgroung color!
Hello, I have a frame built using CStatic. How can i set the color inside my frame. I do not like the gray color. Thank you in advance >I have a frame built using CStatic. > >How can i set the color inside my frame. I do not like the gray color. Have you tried handling the WM_CTLCOLORSTATIC message? Dave -- MVP VC++ FAQ: http://www.mvps.org/vcfaq ...

how to set variable in Work space of VC++
Hello I am stuck in the problem that while i compiled my program through command prompt ,I took following steps..... I set the variable like set ND_MIC_GUI=true nmake /af makex86.mak now i want to repeat the same procedure in work space how i will set this variable in work space of VC++(version 6.0) As i have made check if my .c file like # if ND_MIC_GUI so please guide me how to do that. Reply me as soon as possible Thx in advance It appears that you are setting an environment variable. If thats true, I dont think this can be done witin workspace. You can set it for the system before you...

I cant set up my email!
Hi, i have ms office 2003 on my computer, and i am unable to get the 'send' function because i cannot find the tool to set up an email address. Its not under the 'tools' bar up top. Is there another place for it? I tried using the help function in the program and it told me it would be there. why if i have the 2003 office version wouldnt it show up there? Please help me. "H. Hegland" wrote in message news:7AFD0560-64CE-40C7-BF82-61D60B26B6A6@microsoft.com... > Hi, i have ms office 2003 on my computer, and i am unable to get the > 'send' > ...

Setting a reference to a libray in code
Hi I am trying to reset references to Excel and Word from Access 2007 i.e. code developed on 2007 with office 2007 but when dstributed to users the reference is broken because they are on say office 2000. I have read the link provided in previous posts on this subject but it doesnt seem to be of any help to me. What i do is look through the references to see if any are broken (i already know the excel one is though by looking at tools > references) so For each ref in References if ref.isbroken then 'fix the reference end if next I was then going to fix the br...

setting up default checkbook ID's
When I navigate to: Transactions>Financial>Bank Deposit> ...I have to always select the checkbook ID. How do I default it to a particular checking account? The only way to do this is either using VBA or Dex. Kind Regards Eddie Fourie MBS Specialist (Available for outsourced projects) -----Original Message----- From: michael@nyresume.com [mailto:michaelnyresumecom@discussions.microsoft.com] Posted At: Monday, November 28, 2005 12:10 AM Posted To: microsoft.public.greatplains Conversation: setting up default checkbook ID's Subject: setting up default checkbook ID's When ...

How can I set defaults for the Search options in SmartList?
Hi, I have a group of users that most of the time use the same column name and filter value to do searches on SmartLists. For example: Column Name= Customer Name and Filter = contains. Is there a way to set those values as the default so users dont have to pick those every time they are going to do a search on a SmartList? Thanks, Hector Yes, it's called a SmartList favorite. Once you have entered the filtering criteria and executed your search, click on the Favorites button on the SmartList toolbar and enter a name for the search, for example "Customer contains XYZ"....

Easily limit/set security for specific metrics on home page
Owner does not want users to see the "Gross Profit past 12 months" metrics. One option is to remove security to the GL_Inquiry_Current_Summary and the SOP_Document_Inquiry windows. The users need access to the SOP Document Inquiry window in order to do their job so this is not feasible. Another option is to remove the metrics from their home page then remove security to customize their home page. This defeats the purpose of having a customizable home page. Field level security is available but too expensive. It would be nice to set security by metrics or at least have...

testing account settings
I am adding an email account and I go to tools and account settings and put in all my info and then click "test account settings" and this message comes up.. "Log onto incoming mail server (POP3): Your e-mail server rejected your login. Verify your user name and password in your account properties. Under Tools, click E-mail accounts. The server responded: -ERR authorization failed" I looked at my user name and password and everything matches up. Any suggestions on what to do? "Stephanie" <Stephanie@discussions.microsoft.com> wrote in message new...

Date set to Execution Time -> Wrong Time?
If set up a Workflow Rule which sets a Date Time field to equal the Execution Date Time of when the Workflow Rule executes. This works fine for the Date but gets the Time completely wrong. When the rule runs at 4PM, the time is set to 5AM (not PM!). If the rule runs at 9AM, the time is set to 10AM. I've checked all the obvious causes - i.e. the Timezone of the Server, Organisation Settings and the Timezone of the Crm Administrator Account; all of which are set correctly. Has anyone else seen a similar problem? Kind Regards, Paul. ...

How to set up different headers on pages
I'm new to Publisher 2k3 and need little help. I've set up the fixed elements on master page header, but there is some page dependent content I want to put in the header. How? Please help. You can have multiple Master Pages in Publisher. About using master pages http://office.microsoft.com/en-us/assistance/HP010036031033.aspx Apply master pages to publication pages http://office.microsoft.com/en-us/assistance/HP010046181033.aspx -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Outlook Netscape Import" <OutlookNet...

HELP.....Setting up Outlook express again
I've just installed everything on my computer again and im having trouble with outlook express. its asking for my incoming and outgoing server names and i have no idea what they are or where i get them, so i can access or set my account up again. if anyone knows can they please help me thanks!!!! you can reach me at : bl182ink@hotmail.com Amanda Arbuckle what type of account? who is the email provider? have you checked their website for assistance? -- "Amanda" <bl182ink@hotmail.com> wrote in message news:A37A86BC-5E22-4B1F-B6E3-9459C70971C1@microsoft.com... > I...

Canadian Mortgage Set Up in Money
I have the MS Money 2006 Standard Edition - Has anyone successfully set up a Canadian Mortgage account in Money - any help would be appreciated! rate=4.2%, Amort=300 months, Freq=monthly rate=calculated half-yearly Thanks ...

Setting up data in a collapsed format
How do I take data where data is the same in Column A for Rows 1-18 and I want to collapse those rows where a + sign would appear when they are collapsed a - sign when they are not. Any ideas? Cliff, I used the macro recorder to get this Range("A1:A18").Select Selection.Rows.Group ActiveSheet.Outline.ShowLevels RowLevels:=1 This can be simplified to Range("A1:A18").Rows.Group ActiveSheet.Outline.ShowLevels RowLevels:=1 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mail...

Password Required when setting up a new user
When I am setting up new users in Great Plains using the menu path Tools/Setup/System/User, I am prompted to enter a password. When I enter the SA or DYNSA password, I am allowed to continue. Otherwise, the password fails. My question is: Is this a configuration setting or do I always have to enter a password here. Are there any other (ie less powerful) passwords I can use? My idea scenario is to setup one individual as the Great Plains administrator (with the lowest security possible to perform user setup and maintenace) and have that user do all user setup and maintenance and hope...

How to copy the current company setting to a new company?
Hello, I am trying to creat a second company into GP7.5, and I have a problem now. Finance department hopes I could copy the setting from the first one to the new one, since all the setup was manually done before, and it was real time-cosuming. So if anyone knows how to achieve it, please let me know. Thanks in advance. Zach You can dts all of the Financial setup tables from the existing company to the new one. Customer source should have a tk with all of the tables that need to be copied. "Zach" wrote: > Hello, > I am trying to creat a second company into G...

Currency Settings
I have created a report using VBA and Excel OLAP cube. Some of the metrics on the report are currency numbers and are to be reported in USD so I have formatted them accordingly using format ( e.g. "$ #,##0.00"). Some of the users in Germany who use decimal (.) as separator between numbers are not able to see the format correctly. I hope they use comma in place of decimal and decimal in place of commas as we normally do. Also other users in Europe see Pound or Euro sign instead of dollar. My report is being used in many geographies and I have to use $ which every body should be able t...

Counting Cells that are not continuous
Here's my dilema. In my spreadsheet I'm trying to calculate the values for all th variables located in the ranges, C2:R2, C3:R3,C4:R4, C5:R5, C6:R6 C7:R7, C8:R8, C9:R9, C10:R:10, C11:R11, C12:R12, C13:R13, C14:R14 C15:R15, C16:R16, C17:R17. However, within each of these ranges, I onl want to count the specific cells within this range that meet the give criteria of containing a value of 3. The specific cells are E2, I2, N2, P2; E3, I3, N3, P3; E4, I4, N4, P4 E5, I5, N5, P5; E6, I6, N6, P6; ..........E17, I17, N17, P17. Now th COUNTIF function would count all 17 cells and find those ...

how can i set this to save atomaticly
please tell me how to make this save my work automaticly. In Publisher 2000 you can have it "remind you to save" automatically. Tools, Options, User Assistance -- Don Vancouver, USA "MUCCA" <MUCCA@discussions.microsoft.com> wrote in message news:2BAE6F82-16EF-4F34-8866-9BE66333656A@microsoft.com... > please tell me how to make this save my work automaticly. MUCCA wrote: > please tell me how to make this save my > work automaticly. =================================== This? Are you referring to Microsoft Publisher? Which version? -- John Inzer retu...

Is it possible to set a slide transition that mimics turning page
I've been asked for help in setting up a PPT presentation to have slide transitions that mimic turning pages. I have seen this done using Keynote on a Mac but the software being used for this presentation is PowerPoint. Any ideas on if this is available or where I may find a download to add to my library? Thanks. MaryAnn PowerPoint 2007 The setting I use to achieve that is:- Animations tab / Transitions to This Slide group / Wipes / Strips Left-Up If my comments have helped please hit Yes. Thanks. "MeyerMA3" wrote: > I've been ask...

Transfering Mail & account settings
Hello, I recently dual booted my PC with 2000 pro and XP pro. I need some help in transfering my mail, address book, and outlook settings from 2000 pro to XP pro. The system has one 80 gig harddrive partitioned in two (2). Can you help with this. I would be most greatful. Thanks ...

Setting the Default font for Headers and footers in Excel 2002
I have a user who wants to know how to change the default font for headers/footers in Excel XP. I tried changing the font in each and saving the file as a template called 'Book' in the XLStart directory but that didn't work. Any ideas? She also wants to know how to set the default font for PowerPoint XP. Thanks! ...

Function to set Date
Hi, I would like to know how to set below equation:- to set the 1-week (i.e Monday) prior to a specific date: e.g. 2009/11/24, i would like to have the output = 2009/11/16 e.g. 2009/12/31, output = 2009/12/21 -- J Hi, Try this. Cell B16 holds the specific date =B16-7-CHOOSE(WEEKDAY(B16-7,2),0,1,2,3,4,5,6) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "J" <J@discussions.microsoft.com> wrote in message news:A97DB69C-680E-4A4E-95C9-F731BE3BE9D4@microsoft.com... > Hi, > > I would like to know how to set below eq...