E
e j ronin
I'm not normally an Excell user, and the main reason I am right now i
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 dat
entered on the weekly schedule and auto schedules a 30 min lunch in th
middle of their shift with out overlapping 2 employee lunches in th
same time slot.
B.) Weekly schedule
with takes data from the employee database to autofill the employe
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 hav
working in any given 30 min. I.E. if I have three employees on at 12:3
and one of them leaves at 1:00 I should be able to se that at 12:3
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 pla
and tel you the % to goal or %+/- from LY. I addition will calculat
the units per transaction based on the nuber of items vs. trans.
already calcultes for the week and month plus will tell me in $ what i
needed to meet plan.
E.)Weekly call in
Built to use the mgr schedule input from the weekly schedule from
week ahead to report to the DM when his Store mgrs are in store. I als
have it set up to inclue weekly number totals and averages an
calculate total manhours used in the past week (including OT).
F.)Employee Aval.
Basic Input data taken from employee applications stating when they ca
and can not work. Used in conjunction with the weekly scedule as to no
accidentally schedule an employee on a day they may have school or
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 pla
with let me know.
Thanks,
Shaw
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 dat
entered on the weekly schedule and auto schedules a 30 min lunch in th
middle of their shift with out overlapping 2 employee lunches in th
same time slot.
B.) Weekly schedule
with takes data from the employee database to autofill the employe
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 hav
working in any given 30 min. I.E. if I have three employees on at 12:3
and one of them leaves at 1:00 I should be able to se that at 12:3
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 pla
and tel you the % to goal or %+/- from LY. I addition will calculat
the units per transaction based on the nuber of items vs. trans.
already calcultes for the week and month plus will tell me in $ what i
needed to meet plan.
E.)Weekly call in
Built to use the mgr schedule input from the weekly schedule from
week ahead to report to the DM when his Store mgrs are in store. I als
have it set up to inclue weekly number totals and averages an
calculate total manhours used in the past week (including OT).
F.)Employee Aval.
Basic Input data taken from employee applications stating when they ca
and can not work. Used in conjunction with the weekly scedule as to no
accidentally schedule an employee on a day they may have school or
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 pla
with let me know.
Thanks,
Shaw