Automatic sequence roster, formula required

Trying to design a sequence roster that varies according to input eg Justin needs 12/11 off, max 40 hrs a week, certain people can only do certain shifts, Lauren worked last Saturday so off this saturday. I think I have most of the information on the spreadsheet its just a matter of working out a formula.

Tried to incorporate Sequence.xls without success. I can see it work but cant understand how.

hi,
Have you tried searching the forum or googling?

You may find that someone is able to help quite quickly if you attach a small sample workbook that shows your attempts so far & explains what you'd like to see as the expected result. To attach a file in this forum you can use the paperclip above the message box or the "manage attachments" below the message box (note the size limits for uploading).

If you'd like to pay someone, I think (I'm not 100% sure...) that you should post your question in the below section of the forum - note that you'll need to include more detail to allow anyone to understand the scope/time that may be required:
http://www.excelforum.com/commercial-services-exchange/

hth
Rob

edit: attachments to OP's file appeared when my screen refreshed after posting a request for attachments to be provided - therefore request deleted.

Rob

hi,

Sorry I don't have the time to understand all the logic and provide a final solution for you at the moment (maybe this weekend?) - so hopefully someone else can help you before then...?

However, I will try & explain why the below returns a TRUE value.

Originally Posted by mr63249

b5=IF(Info!$A$13="Sharon",Info!$C$13)=IF(Info!$A$14="Sharon",Info!$C$14)

returns true value? shouldnt it be false

This formula has an equal sign in the middle (coloured orange in above quote) which effectively makes it a comparison of the results of the 2 IF statements ie:

Please Login or Register  to view this content.

evaluates to

Please Login or Register  to view this content.

which finally evaluates from False=False to B5=TRUE

hth
Rob

Originally Posted by broro183

hi,

Sorry I don't have the time to understand all the logic and provide a final solution for you at the moment (maybe this weekend?) - so hopefully someone else can help you before then...?

However, I will try & explain why the below returns a TRUE value.


This formula has an equal sign in the middle (coloured orange in above quote) which effectively makes it a comparison of the results of the 2 IF statements ie:

Please Login or Register  to view this content.

evaluates to

Please Login or Register  to view this content.

which finally evaluates from False=False to B5=TRUE

hth
Rob

Thankyou for your reply. So do I change the equal sign to somehting else so the value will return false, if so I am only new so I may seem a litle stupid. But hey I guess thats why Im here get help from experts