Percentage Not Calculating Correctly

TRAQ

New Member
Joined
May 29, 2008
Messages
5
I am having the hardest time understanding what is going on with my spreadsheet. I have a spreadsheet that is taking four different data inputs and adding them up to figure out what percentage of that work type as it relates to the average processing times. This is the formula that I am using for 510K the bottom

=((AK11/(AK14/'Workload Distribution'!F13))*(AK9)/(SUM(AK9:AN9)))

F13 being the average processing time of 5 hours.

What I don't understand is the second field for Internal Requests is:

=((AK11/(AL14/'Workload Distribution'!G13))*((AL9)/(SUM(AK9:AN9))))

The percentage that is coming out seems to be problem because when I manually put the percentage in it calculates fine. If I do not the values come out the same even though they are not. Can someone explain to me what I am doing wrong. Thank you very much.

<TABLE style="WIDTH: 203pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=270 border=0 x:str><COLGROUP><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 1pt; mso-width-source: userset; mso-width-alt: 36" width=1><TBODY><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl37 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 203pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: #ecf5d7" width=270 colSpan=5 height=22>May</TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>510k</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Internal Requests</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>EIR</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>PMA</TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40 x:num>18</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>3</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72 x:num>0</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>0</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Required Monthly Hours</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=269 colSpan=4 height=40 x:num="145.83333333333334">146</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Hours Logged by Work Type</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>510k</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Internal Requests</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>EIR</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>PMA</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40 x:num>90</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>9</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72 x:num>0</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>0</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Actions Needed by Work Type</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>510k</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Internal Requests</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>EIR</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>PMA</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40 x:num="11.166666666666668">11</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num="45.611111111111114">46</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72 x:num="48.611111111111114">49</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num="3.6458333333333335">4</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Break Down Total</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>Pages</TD><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Boxes</TD><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>Avg Page Total</TD><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Avg Box Total</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40 x:num>3020</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>930</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72 x:num="201.33333333333334">201</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>62</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Hourly Breakdown by Work Type</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>510k</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Internal Requests</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>EIR</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>PMA</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 21.95pt; mso-height-source: userset" height=29><TD class=xl35 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 21.95pt; BACKGROUND-COLOR: #fefcf2" height=29 x:num="6.9444444444444446">6.94</TD><TD class=xl35 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fefcf2" x:num="6.9444444444444446">6.94</TD><TD class=xl36 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fefcf2"></TD><TD class=xl26 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fefcf2" width=64></TD><TD class=xl30 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR></TBODY></TABLE>
 
Last edited:

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
I am having the hardest time understanding what is going on with my spreadsheet. I have a spreadsheet that is taking four different data inputs and adding them up to figure out what percentage of that work type as it relates to the average processing times. This is the formula that I am using for 510K the bottom

=((AK11/(AK14/'Workload Distribution'!F13))*(AK9)/(SUM(AK9:AN9)))

F13 being the average processing time of 5 hours.

What I don't understand is the second field for Internal Requests is:

=((AK11/(AL14/'Workload Distribution'!G13))*((AL9)/(SUM(AK9:AN9))))

The percentage that is coming out seems to be problem because when I manually put the percentage in it calculates fine. If I do not the values come out the same even though they are not. Can someone explain to me what I am doing wrong. Thank you very much.

<TABLE style="WIDTH: 203pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=270 border=0 x:str><COLGROUP><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 1pt; mso-width-source: userset; mso-width-alt: 36" width=1><TBODY><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD class=xl37 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 203pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: #ecf5d7" width=270 colSpan=5 height=22>May</TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>510k</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Internal Requests</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>EIR</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>PMA</TD><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40 x:num>18</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>3</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72 x:num>0</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>0</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Required Monthly Hours</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=269 colSpan=4 height=40 x:num="145.83333333333334">146</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Hours Logged by Work Type</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>510k</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Internal Requests</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>EIR</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>PMA</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40 x:num>90</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>9</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72 x:num>0</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>0</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Actions Needed by Work Type</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>510k</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Internal Requests</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>EIR</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>PMA</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40 x:num="11.166666666666668">11</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num="45.611111111111114">46</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72 x:num="48.611111111111114">49</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num="3.6458333333333335">4</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Break Down Total</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>Pages</TD><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Boxes</TD><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>Avg Page Total</TD><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Avg Box Total</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40 x:num>3020</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>930</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72 x:num="201.33333333333334">201</TD><TD class=xl29 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64 x:num>62</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl41 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; WIDTH: 202pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #cfcfcf" width=269 colSpan=4 height=40>Hourly Breakdown by Work Type</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: #fcfaf2" width=69 height=40>510k</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>Internal Requests</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=72>EIR</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fcfaf2" width=64>PMA</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR><TR style="HEIGHT: 21.95pt; mso-height-source: userset" height=29><TD class=xl35 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 21.95pt; BACKGROUND-COLOR: #fefcf2" height=29 x:num="6.9444444444444446">6.94</TD><TD class=xl35 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fefcf2" x:num="6.9444444444444446">6.94</TD><TD class=xl36 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fefcf2"></TD><TD class=xl26 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: #fefcf2" width=64></TD><TD class=xl30 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; WIDTH: 1pt; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: black" width=1></TD></TR></TBODY></TABLE>
;)
 
Upvote 0
Nice image. How does one connect the various pieces of what I assume are worksheet ranges to the formula you posted?
 
Upvote 0
Sorry about that. The horizontal axis columns are AK, AL, AM, AN and the vertical axis rows begin at 7 (MAY) and end at 23 (6.94). Hope this clarifies it for you. Thanks for the help.
 
Upvote 0
G13 is the number 3 which indicates the time it takes to complete one internal request action.
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,957
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top