Compute For Staffing Requirement With Turnaround Time?
Dec 13, 2012how to compute for staffing requirement with turnaround time?
View 2 Replies
ADVERTISEMENT
How To Compute For Elapse Time Using Excel Formula
May 15, 2012I have some question regarding elapse time using excel formula.. Just want to compute for the total hours consume by a person per task assign base on 5 days,8 hours per day working schedule(Saturday and sunday is not included since it is the restday of the agent. Working hours is 8am to 5pm. 12pm -1pm is the time agents take there lunch.
See below example and expected Result:
AGENTSStart timeEnd timeExpected Result(hour)RemarksCHARICE5/14/12 8:00 AM5/14/12 3:00 PM6.00Result subracted by 1 1hr breakALICE5/15/12 8:00 AM5/17/12 3:00 PM22.00Result subracted by 3 1hr breakJAKE5/16/12 8:00 AM5/21/12 3:00 PM30.00Result subracted by 3 1hr break(Saturday and Sunday is not included(may19-20))JOHNNY5/14/12 8:00 AM5/17/12 3:00 PM30.00Result minus 4 1hr break
Calculate Time Elapsed And Compute Day Of Week Based On Date
May 27, 20141. Calculate the time that has elapsed between 2 times in both hours:min (hhmm) and total mins (mm)
2. Compute the day of the week (mon-fri) a particular date fell on. I really only need to know if the date fell on a weekday or weekend.
table { }td { padding: 0px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-size: 12pt; } 1= M-F
2=S-S
3. How to write an If statement that assign a value to time based off this chart:
table { }td { padding: 0px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-size: 12pt; } 1= AM (7-1459)
2=PM (15-2259)
3= MN (23-659)
Formula To Calculate Turnaround
Feb 25, 2008I am trying to calculate the number of items that took more than 5 days to complete.
The user enters the month and the year for which stats are required in G5 and G6, respectively (e.g., February and 2008). Both cells are formatted as General.
Column D contains the start dates, while column Q contains the completed dates.
I used the following formula but I am not getting the expected result:
PHP
=SUMPRODUCT(--(DATE(YEAR($D$10:$D$12),MONTH($D$10:$D$12),DAY($D$10:$D$12))>=DATE($G$6,CHOOSE(MATCH($G$5,{"January","February","March","April","May","June","July","August","September","October","November","December"},0),1,2,3,4,5,6,7,8,9,10,11,12),1)),--(DATE(YEAR($D$10:$D$12),MONTH($D$10:$D$12),DAY($D$10:$D$12))<=DATE($G$6,CHOOSE(MATCH($G$5,{"January","February","March","April","May","June","July","August","September","October","November","December"},0),1,2,3,4,5,6,7,8,9,10,11,12)+1,0)),--($D$10:$D$12<>""),--($Q$10:$Q$12<>""),--(DATE(YEAR($Q$10:$Q$12),MONTH($Q$10:$Q$12),DAY($Q$10:$Q$12))-DATE(YEAR($D$10:$D$12),MONTH($D$10:$D$12),DAY($D$10:$D$12))>5))
Linking 2 Spreadsheets To Get Turnaround Results
Jul 2, 2008I work in IT support for a company and mainly work on operating systems issues etc but not office suite issues...anyway, I have been asked if it is possible to link 2 speadsheets and compare the data to display a result...
....from what I have just briefly read, it is certainly possible to do this, but now I need to know how it can be done with our relevant information... as you can see in the following images.
We have a spreadsheet that pulls data out of a database to display all the people that have been issued with a certificate, and we also have a spreadsheet that is manualy entered on a daily basis for the received date of the application for the certificate.
So, in short, we have a received date and an entered date and we need to know the difference to ascertain our turnaround time. Obviously it will need to compare names for name and enter the received date and result next to each name, and if it cannot get a name match, then report an error advising which ones it could not find a match for etc...
Whew, what a long post (sorry), I hope that is clear enough....below are the different images of part of the sheets...
Excel 2007 :: Get Cell Color As Per Requirement?
Aug 11, 2014I want to be able to change a color of one cell according to color of another cell. suppose, cell A1 has text "apples" having red color. Now, if I enter text same as A1("apples") in another cell, say B1, then color of text entered in cell B1 should be red. I am using Excel 2007
View 3 Replies View RelatedChart For Requirement Versus Available Stocks Month Wise
Feb 19, 2014I want a chart for month wise requirement Vs available stocks to watch or plan for further purchases availability
Monthly Graph (Data file) is attached
Staffing Calculator
May 4, 2007I've been trying to create a Staffing calculator for a call center. Basically the calculator should be able to add up the number of agents for the next 18 intervals based on the login time that is entered by the user. I've just outlined the functioning below:
Suppose 10 agents login at 8 AM (thus logout at 5 PM), the intervals right from 8 AM till 5 PM should show up the 10 agents. Now suppose 10 more agents login at 9 AM, we would then have 20 agents logged in till 5 PM (since agents logged in at 8 will logout at 5) & the remaining 10 till 6 PM. Thus if we have 10 more agents logging in at 10:30, we will have 30 agents till 5 PM, 20 till 6 PM & 10 agents till 7:30 PM & so on. I have attached an excel file to explain the example & the way the calculator has to be built. It is preferrable that the cells containing the login time aren't fixed, but the user should be able to input any login time in any cell.
Creating A Staffing Board For Work
Jul 15, 2007I would like to create a new more effective quick staffing board for work.
Name Start Time Finish Time Break Allowance Break Time 8 (then time period from 6 till 2300
BUT when I enter say a shift of say 09:00 17:00 I need this time period to block out on the board, hard to explain ...
Staffing Per Interval Including Lunch Array
Jun 26, 2003I need to Find Out the Number of people staffed per interval I used to use a formula like this in order to calculate this it takes in to account Lunches.
=SUM(IF(A8>=$B$2:$B$6,IF(A8=$E$2:$E$6,IF(A8
Creating Staffing Schedules Based On Train Times
Jun 16, 2006Attached is a sample schedule form. I recived the data on the "Working" sheet in a Word file that is emailed monthly. THis shows a full month of arrival/Departure and passenger counts by Time of Day. I need to develop
1. a driver schedule that would indicate the time the driver needed to be at the station and how many passengers to collect. There could be both and arrival and a departure trip at the same time so this would also need to be considered. The sample data shows when passengers arrive and when they are expected to leave. Some will leave the day they arrive some the next day. Ideally I would like to be able to plan the number of trips to the station per day and at what times, whether it was an Arrival, Departure or a combo trip delivering departing passengers and collecting Arriving passengers on the same trip.
2. A housekeeping schedule also needs to be created showing how many rooms need to be available for passengers and at what times. It would also need to indicate if the passenger arrives and departs on the same day or if they stay over.
Compute The SCORE
Jan 20, 2009i was assigned to make a computation for our individual scores using this:
EMPLOYEES A-N
inputs:
SURVEY(0-100)
LH(lost hour)
AHT(average handling time)
compute for:
SCORE
RANK
the SCORE has a total of 100%
so to get the SCORE, each input gets a percentage: SURVEY=40% LH=30% AHT=30% then added.
but the thing is LH and AHT has an equivalent.
LH
0 to 1=100
1.1 to 2=90
2.1 to 3=80
3.1 to 4=70
4.1 to 5=60
5.1 above=20......
eXAMPLE:
EMPLOYEE A
SURVEY(0-100) = 33.00
LH(lost hour) = 12.00
AHT(average handling time) = 14.20
SCORE = CODE
RANK = CODE
now for the rank i just use the code =RANK(SCORE A, SCORE A:SCORE N)
im lost on how to compute the SCORE though coz i can just use =((SURVEY*40%)+(LH*30%)+(AHT*30%))
but the one that needs to be on the LH and AHT are the equivalents and not the inputs.
and there is 1st 2nd and 3rd place. the name of the top 3 employees should be shown under the table.
How To Key A Formula To Compute The Due Date
May 14, 2009I'd like to know how I go about to key a formula to compute the due date 30days after the invoice date and How to key a formula to determine hours worked.
View 14 Replies View RelatedFormula To Compute Commissions Paid
Jun 9, 2014I need to write a formula that will look at a number in a cell and compute an amount at 1% up to 55,000. Then anything above the 55,000 compute an amount at 3.25%. Then add the two together.
So a baseline of 55,000 at 1%. Then above the baseline 3.25%.
Copy Cell To New Workbook & Compute Sum
Nov 29, 2007I've attached a Screen Shot of the of 2 Workbook, named Installation Tailgate 2007v1.xlsm and new workbook and i've also attached the excel program itseff in zip.
Installation Tailgate 2007v1 workbook, have a 13 column and nth number of rows ( and will keep growing)
columns D & E are hidden
columns G, I, K, M are checkboxes
if the user clicks on the command button it will copy and paste the selected cells on new workbook
unchecked cells on Installation Tailgate 2007v1 workbook should have a "0.00" on Child workbook.
then compute the Sum of Columns C, D, E, F, G, the total should be on last of their row
Compute And Display Result In Cell
Sep 26, 2009I have 15*2,14*2,14.5 in cell A1 and would like this to be computed and its result (i.e 72.5) displayed in cell A2. See below for clearer picture:
A1 A2
15*2,14*2,14.5 72.5
Macro To Compute Data Using SUMMIF
Oct 5, 2011I have the following macro to compute data using SUMMIFS
Range("E" & finalrow + 9).Formula = "=SUM(SUMIFS(E8:E" & finalrow & ",F8:F" & finalrow & ",{""PSP101"",""PSP611"",""PSP140",""7*""}))"
The last line up code is mot working as I am tying to using a Wildcard for the last criteria
""7*""
Where text starting with a 7 appears in column F for eg 76601G, 75106K etc appears it must be included in the criteria
Full Code-below
Sub Totals()
finalrow = Range("A65536").End(xlUp).Row
Range("A" & finalrow + 3).Value = "Total Movement"
Range("E" & finalrow + 3).Formula = "=sum(E8:E" & finalrow & ")"
[Code]....
Compute Value Based On Multiple Cell
Jul 16, 2013I've been having a hard time with this i need a formula which will compute a value based on a multiple cell.
I have a cell (AQ) it contains the number of days a patient is in a center i need to countif the cell value is >=90 if it is it will then calculate the values in cell (AV) which is >- 1.4 and get the average of cells in AV.
Macro To Match 2 Tables And Compute Values
Jan 9, 2013I'm trying to make a macro that match table in sheet "Vocabulary" to the second table (columns Q,R,S,T) in sheet "Overview" and compute correct values in column U using weights from column F, sheet Vocabulary on values from a corresponding cell at column M, sheet Overview. The entries for every ISIN in the sheet Vocabulary are in no particular order and some positions from sheet Overview don't have to exist in Vocabulary at all (but I still need them to display in the table on the right to be able to make charts from summing these categories).
Portfolios.zip
How should the end result look like is displayed on the last sheet.
Compute T-test With Unequal Sample Sizes?
Oct 24, 2007using the ttest formula function
View 2 Replies View RelatedCalculator Compute Automatically After Inputting The Date
Apr 29, 2009i m making a very small calculator. It's a little hard to describe, but I need to look like the following
Let's say the individual got here on 1 Jan
Phase 1 is for days 1-14 last for 14 days
Phase 2 is for Day 15-35 last for 21 days
Phase 3 is day 36+
This is what I need it to look like: All the phase information will compute automatically after inputting the date arrived. In addition I would also like to be able to change one of the phase dates and the remainder of the phases compensate according to the newly entered date.
Date Arrived = 01 Jan 09
Phase 1 = 01jan09
Phase 2 = 04Feb09
Phase 3 = 05 Feb09
Compute Average Formula With Blank Cells
Jul 25, 2013Is it possible to show "0" zero in the total average column without inputing zeros in the blank cells in row B3:E3 & B4:E4? There are months we receive no boat & RV orders, so those months wll be zero most of the time. Instead of having #DIV/0! it show 0, without having to input zero in cells to compute the average.
A
B
C
D
E
F
1
Jan
Feb
Mar
April
Total Average
[Code] .......
Averagif/averageifs :: To Compute The Realised Profit Or Loss
Oct 25, 2008How to compute the realised Profit or Loss for each of the shares transacted for the year ended 31 December 2008 based on average cost of each share.
using AVERAGEIF, if appropriate. [Pls refer to the attachment.]
How To Use Countifs Function To Compute Month Of Year From Date Value
Aug 7, 2013I have a problem where there are 4 arguments passed to my COUNTIFS function to give me a total count i.e. "KP","James Report","Completed","Month"
Here is the Formula I used;
=COUNTIFS(Master!$B$2:$B$29,Picklist!$C$8,Master!$D$2:$D$29,B3,Master!$H$2:$H$29,Picklist!$C$2,Master!K2:K57,Picklist!E9 )
The last part of my formula is throwing an error "K2:K57"
What I should get in plain English.... "The number of 'James Report' 'Completed by 'KP' in 'August'. (Any specified month based on what comes from my "dates field" on my Master sheet.
I have got a field in my Master sheet with dates which I have transposed into the right month of the year using Month().
VBA- Write A Macro To Find The Similar Maturity, Compute The Returns
Feb 13, 2007I am working with financial data and am exposed to a problem that excel formula cannot solve. I am very new to VBA and would like some assistance please. I have in one excel column the list of maturities in dates eg. EN02, EN03, EN04 etc (EN=January). I have in another column the corresponding prices for these maturities. What I would like to do is compute the returns on similar maturities and paste the returns in the returns column. I can use a formula for this when the consecutive maturities are the same. The problem arises when I want excel to find the previous similar maturity, which may be 5 cells or so before. How do I write a macro to find the similar maturity, compute the returns and place that returns value in the returns column.
View 10 Replies View RelatedCompute The FuTure Date When Start Date,Lead Date,Weekly Offs,Leaves And Holidays
Nov 15, 2008First and foremost I would like to congragulate you on this wondeful piece of code in the below link...
The query was to get a future date excluding Fridays and Holidays...
http://www.excelforum.com/excel-work...rkingdays.html
I have a similar query and therefore I pasted this link...
I actually wanted to get a future date using a Dynamic two day off as my the offs keep on changing as well as incorporate Holidays and Leaves if any..
Now Holidays would be official Public Holidays and
Leaves would be taken by the employee..
The code needs to pick the Leaves + Holidays and different offs maybe even more than 2 offs...
Compute Values Sheet To Sheet.....
Jun 4, 2009how do you compute values from sheet to sheet. in other words, let's say you have a master sheet with all end values on it. how do you write a function that copies the value on another sheet. for example: a function located in a cell on Sheet 1 that always is the same value as a cell in Sheet 2, that sums up two columns on Sheet 2.
View 3 Replies View RelatedDisplay End Time Automatically Upon Entering Start Time And Time Usage
Dec 19, 2008I have a worksheet which contains START TIME in column A, then TIME USAGE in column B and END TIME in column C. User enters start time, followed by the number of time usage in minutes, how could i possibly display the end time automatically in this scenario? how do you add the entered time usage to the start time to display the end time? Say if I enter 1:00 AM at start time and 00:15 minutes on time usage, how can 1:15 AM be displayed on the end time automatically?
View 2 Replies View RelatedCalculate Time Between Start Time And End Time?
Feb 7, 2014the vendor has a 21 hr working window; start from 7am and goes until 4am; Mon to Fri.
Here is a scenario:
- i request for a product information from a vendor on 3-Feb-14 8:00am (Monday)
- he replies with all of the product info on 6-Feb-14 12:00pm (Thursday)
can you find the time in above scenario consideration the working window?
Here is another scenario:
- i request for a product information from a vendor on 6-Feb-14 8:00am (Thursday)
- he replies with all of the product info on 11-Feb-14 12:00pm (Tuesday)
- Sat & Sun are days off but keep in mind that my Friday shift ends on sat at 4am so the networdays formula wont work.
Add This Number To The Start Time, Factor In Break Minutes And Get To The Projected Completion Time
Mar 3, 2009I am trying to provide a tool for department leaders to monitor productivity for order processing in their departments. The variables I have are: Number of orders(variable), number of pickers (variable), start time(variable). Then, I know each order takes 1 picker 4 minutes to pick on average, and there are 45 minutes worth of breaks during the picking process. So after entering the variables I used =(((C3*4)/60)/D3) to come up with the time needed to process the orders. What I can't get to is how to add this number to the start time, factor in break minutes and get to the projected completion time. I have Excel 2003 at work. Clearly I need to take a class!
View 4 Replies View Related
