Help with Formula in Staffing Model
From: esi (haha_at_funny.com)
Date: 11/19/04
- Next message: Frank Kabel: "Re: Run a macro based on the value of a cell"
- Previous message: RMort: "How can I..."
- Next in thread: Casey: "Re: Help with Formula in Staffing Model"
- Reply: Casey: "Re: Help with Formula in Staffing Model"
- Reply: Andre Croteau: "Re: Help with Formula in Staffing Model"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 14:48:46 -0500
I have a staffing model which tells me by month how may employees I need for
our production line. I'm trying to setup a formula to identify the months
we need to hire. Here is my example
Month 11/1/2004 12/1/2004 1/1/2005 2/1/2005 3/1/2005 4/1/2005
5/1/2005 6/1/2005 7/1/2005 8/1/2005 9/1/2005 10/1/2005 11/1/2005 12/1/2005
Avg. FTE's Avg. FTE's Avg. FTE's Avg. FTE's Avg. FTE's Avg. FTE's Avg.
FTE's Avg. FTE's Avg. FTE's Avg. FTE's Avg. FTE's Avg. FTE's Avg. FTE's Avg.
FTE's
Data Entry units entered per hour 6.1 6.4 6.9 6.9 7.5 7.5 7.9 8.2 8.5
8.4 8.9 9.1 9.3 9.9
I wanted to use conditional formatting to tell me which months we need to
add a full fte. I would expect excel to shade 3/1/05, 7/1/05, and 12/5/05
I'm not sure how to set this up in excel. THanks
- Next message: Frank Kabel: "Re: Run a macro based on the value of a cell"
- Previous message: RMort: "How can I..."
- Next in thread: Casey: "Re: Help with Formula in Staffing Model"
- Reply: Casey: "Re: Help with Formula in Staffing Model"
- Reply: Andre Croteau: "Re: Help with Formula in Staffing Model"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|