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>
=((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: