Where To Start

%3CLINGO-SUB%20id%3D%22lingo-sub-3009639%22%20slang%3D%22en-US%22%3EWhere%20To%20Start%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3009639%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20want%20to%20start%20working%20on%20a%20file%20with%20very%20specific%20needs.%20I%20don't%20need%20you%20to%20guide%20me%20through%20every%20step.%20I%20just%20want%20some%20assistance%20regarding%20which%20functions%20to%20use%20so%20I%20can%20tinker%20with%20them%20my%20self.%20I'm%20familiar%20with%20VBA%20and%20many%20Excel%20functions.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ESo%20here%20it%20goes%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20file%20will%20assign%20Lunch%20times%20for%203%20different%20shifts%20for%20specific%20intervals%20and%20for%20each%20interval%20there%20will%20be%20a%20maximum%20number%20requirement.%20So%2C%20if%20the%20maximum%20number%20is%20achieved%2C%20proceed%20to%20next%20interval.%20On%20top%20of%20that%2C%20it%20will%20need%20to%20base%20the%20preferences%20of%20employees%20all%20of%20which%20will%20be%20hard-coded%20in%20a%20sheet.%20Employee%20names%20will%20be%20entered%20in%20a%20table%20for%20that%20specific%20shift.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ETo%20dive%20further%20into%20it%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EWe%20have%203%20different%20shifts%3A%20morning%2C%20mid%20and%20night.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EFor%20morning%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Elet's%20say%20lunch%20hours%20start%20at%2011%3A00%20and%20the%20hard-coded%20number%20for%20that%20interval%20will%20be%203%20employees%20and%20for%20argument's%20sake%20Employee%201%20and%202%20prefer%20to%20take%20their%20lunch%20at%20that%20interval%20whereas%20employee%203%20and%204%20prefer%2015%3A00%20which%20again%20will%20be%20hard-coded.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20if%20the%20employee%20has%20no%20preference%2C%20we%20will%20just%20need%20to%20avoid%20assigning%20them%20to%20the%20same%20interval%20as%20yesterday%20which%20will%20still%20be%20present%20in%20the%20sheet.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20hope%20I'm%20clear%20enough.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIf%20you%20could%20point%20me%20towards%20where%20to%20start%2C%20I'd%20be%20really%20grateful.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EKind%20regards.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3009639%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hello,


I want to start working on a file with very specific needs. I don't need you to guide me through every step. I just want some assistance regarding which functions to use so I can tinker with them my self. I'm familiar with VBA and many Excel functions.


So here it goes:


The file will assign Lunch times for 3 different shifts for specific intervals and for each interval there will be a maximum number requirement. So, if the maximum number is achieved, proceed to next interval. On top of that, it will need to base the preferences of employees all of which will be hard-coded in a sheet. Employee names will be entered in a table for that specific shift.


To dive further into it;


We have 3 different shifts: morning, mid and night.


For morning


let's say lunch hours start at 11:00 and the hard-coded number for that interval will be 3 employees and for argument's sake Employee 1 and 2 prefer to take their lunch at that interval whereas employee 3 and 4 prefer 15:00 which again will be hard-coded.

 

Also, if the employee has no preference, we will just need to avoid assigning them to the same interval as yesterday which will still be present in the sheet.


I hope I'm clear enough.


If you could point me towards where to start, I'd be really grateful.


Kind regards.

1 Reply

@kheldar 

I don't know in advance whether I can help you, but I know that it is very difficult for you to get feedback with this approach.

With your permission, if I can recommend you, please always add specific information about your Excel version and operating system to your concerns.

As well as, if possible or necessary (sure in your case), a file (without sensitive data).

Information on where the file is, such as OneDrive or SharePoint, is of advantage.

 In this way, you will come up with a proposed solution much faster and more precisely.

This also makes it much easier for the helpers to provide the help that they would like to offer you.

It helps both :).

 

Here is a link with information on how you can quickly find a solution that is most suitable for you.

Welcome to your Excel discussion space!

 

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)