Re: Personell Coverage in a timesheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Norman Harker (njharker_at_optusnet.com.au)
Date: 03/20/04 

Date: Sat, 20 Mar 2004 11:43:21 +1100

Hi Shawn!

We need more information on the layout and entries that you have in
*** C. 

-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"e j ronin >" <<e.j.ronin.13e4zu@excelforum-nospam.com> wrote in
message news:e.j.ronin.13e4zu@excelforum-nospam.com...
> I'm not normally an Excell user, and the main reason I am right now
is
> so that I can cut my paperwork back by 6 hours a week.
>
> I have constructed a spreadsheet that contains 6 worksheets.
>
> A.) Daily Action Plan
> Tells the shift manager who works when on a daily basis using data
> entered on the weekly schedule and auto schedules a 30 min lunch in
the
> middle of their shift with out overlapping 2 employee lunches in the
> same time slot.
>
>
> B.) Weekly schedule
> with takes data from the employee database to autofill the employee
> names and keep them from being scheduled outside of their avail.
>
> C.) Employee Coverage
> I want it to display in increments of 30 min how many employees I
have
> working in any given 30 min. I.E. if I have three employees on at
12:30
> and one of them leaves at 1:00 I should be able to se that at 12:30
> there is a number three in the space but at 1 only a number 2.
>
> D.) Sales and Banking logs that track last years sales, this years
plan
> and tel you the % to goal or %+/- from LY. I addition will calculate
> the units per transaction based on the nuber of items vs. trans. I
> already calcultes for the week and month plus will tell me in $ what
is
> needed to meet plan.
>
> E.)Weekly call in
> Built to use the mgr schedule input from the weekly schedule from a
> week ahead to report to the DM when his Store mgrs are in store. I
also
> have it set up to inclue weekly number totals and averages and
> calculate total manhours used in the past week (including OT).
>
> F.)Employee Aval.
> Basic Input data taken from employee applications stating when they
can
> and can not work. Used in conjunction with the weekly scedule as to
not
> accidentally schedule an employee on a day they may have school or a
> second job.
>
>
> My question is this:
>
> How do I do C?
> Is there a more efficient step scale for the sheets?
>
> Please bear in mind that all except C are done and work near
perfetly.
> I'm working bugs out. If anyone needs a copy of these sheets to play
> with let me know.
>
>
> Thanks,
>
> Shawn
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
Quantcast