I am trying to automate an excel report. I need to be able to click 1 button on the "client report" worksheet, to run a report. The client report has formulas that returns data from the "Case Detail" worksheet.
Below are the 2 worksheets.
Below are the 2 worksheets.
| Excel 2012 | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
| 1 | Total Contracted SLA Calls | 215 | Total Contracted SLA, T&M, and Out of Scope Calls | 440 | ||||||||||||||
| 2 | Dedicated Sites 95% Target | Dedicated Sites All Service Request Break Out | ||||||||||||||||
| 3 | Total Calls | Missed SLA | Compliance | DT/LT | CTM | SERVER | OO SCOPE | ITC Grand Total | Overall SLA Attainment | |||||||||
| 4 | BAKERSFIELD | 11 | 0 | 100.00% | BAKERSFIELD | 9 | 7 | 2 | 12 | 30 | 100.00% | |||||||
| 5 | BELLAIRE | 10 | 0 | 100.00% | BELLAIRE/SUGAR LAND | 6 | 2 | 4 | 5 | 17 | ||||||||
| 6 | CONCORD | 2 | 0 | 100.00% | CONCORD | 2 | 1 | 0 | 2 | 5 | ||||||||
| 7 | COVINGTON | 9 | 0 | 100.00% | COVINGTON | 7 | 5 | 2 | 5 | 19 | ||||||||
| 8 | HOU150 | 101 | 0 | 100.00% | HOU150 | 69 | 45 | 32 | 53 | 199 | ||||||||
| 9 | LAFAYETTE | 16 | 0 | 100.00% | LAFAYETTE | 16 | 0 | 0 | 0 | 16 | ||||||||
| 10 | MIDLAND | 8 | 0 | 100.00% | MIDLAND | 8 | 3 | 0 | 0 | 11 | ||||||||
| 11 | PASCAGOULA | 1 | 0 | 100.00% | PASCAGOULA | 1 | 4 | 0 | 0 | 5 | ||||||||
| 12 | RICHMOND | 10 | 0 | 100.00% | RICHMOND | 9 | 8 | 1 | 10 | 28 | ||||||||
| 13 | SAN RAMON | 41 | 0 | 100.00% | SAN RAMON | 32 | 22 | 9 | 32 | 95 | ||||||||
| 14 | ||||||||||||||||||
| 15 | Total Dedicated | 209 | 0 | 100.00% | Total Dedicated | 159 | 97 | 50 | 119 | 425 | ||||||||
| 16 | ||||||||||||||||||
| 17 | Depot Sites 95% Target | Depot Sites All Service Request Break Out | ||||||||||||||||
| 18 | Total Calls | Missed SLA | Compliance | DT/LT | CTM | SERVER | OO SCOPE | ITC Grand Total | ||||||||||
| 19 | DEPOT San Ramon | 4 | 0 | 100.00% | DEPOT San Ramon | 4 | 1 | 0 | 0 | 5 | ||||||||
| 20 | ||||||||||||||||||
| 21 | Total Depot | 4 | 0 | 100.00% | Total Depot | 4 | 1 | 0 | 0 | 5 | ||||||||
| 22 | ||||||||||||||||||
| 23 | Dispatch Sites 85% Target | Dispatch Sites All Service Request Break Out | ||||||||||||||||
| 24 | Total Calls | Missed SLA | Compliance | DT/LT | CTM | SERVER | OO SCOPE | ITC Grand Total | ||||||||||
| 25 | MOON TOWNSHIP | 1 | 0 | 100.00% | Moon Township | 1 | 1 | 0 | 5 | 7 | ||||||||
| 26 | BREA/EL SEGUNDO | 0 | 0 | #DIV/0! | Brea/El Segundo | 0 | 0 | 0 | 2 | 2 | ||||||||
| 27 | HONOLULU | 1 | 0 | 100.00% | HONOLULU | 1 | 0 | 0 | 0 | 1 | ||||||||
| 28 | ||||||||||||||||||
| 29 | Total Dispatch | 2 | 0 | 100.00% | Total Dispatch | 2 | 1 | 0 | 7 | 10 | ||||||||
Client Report | ||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D1 | =SUM(B15+B21+B29) | |
| D4 | =(B4-C4)/B4 | |
| D5 | =(B5-C5)/B5 | |
| D6 | =(B6-C6)/B6 | |
| D7 | =(B7-C7)/B7 | |
| D8 | =(B8-C8)/B8 | |
| D9 | =(B9-C9)/B9 | |
| D10 | =(B10-C10)/B10 | |
| D11 | =(B11-C11)/B11 | |
| D12 | =(B12-C12)/B12 | |
| D13 | =(B13-C13)/B13 | |
| D15 | =(B15-C15)/B15 | |
| D19 | =(B19-C19)/B19 | |
| D21 | =(B21-C21)/B21 | |
| D25 | =(B25-C25)/B25 | |
| D26 | =(B26-C26)/B26 | |
| D27 | =(B27-C27)/B27 | |
| D29 | =(B29-C29)/B29 | |
| K1 | =SUM(K15+K21+K29) | |
| K4 | =SUM(G4:J4) | |
| K5 | =SUM(G5:J5) | |
| K6 | =SUM(G6:J6) | |
| K7 | =SUM(G7:J7) | |
| K8 | =SUM(G8:J8) | |
| K9 | =SUM(G9:J9) | |
| K10 | =SUM(G10:J10) | |
| K11 | =SUM(G11:J11) | |
| K12 | =SUM(G12:J12) | |
| K13 | =SUM(G13:J13) | |
| K15 | =SUM(K4:K13) | |
| K19 | =SUM(G19:J19) | |
| K21 | =K19 | |
| K25 | =SUM(G25:J25) | |
| K26 | =SUM(G26:J26) | |
| K27 | =SUM(G27:J27) | |
| K29 | =SUM(G29:J29) | |
| B4 | =SUM(G4,I4) | |
| B5 | =SUM(G5,I5) | |
| B6 | =SUM(G6,I6) | |
| B7 | =SUM(G7,I7) | |
| B8 | =SUM(G8,I8) | |
| B9 | =SUM(G9,I9) | |
| B10 | =SUM(G10,I10) | |
| B11 | =SUM(G11,I11) | |
| B12 | =SUM(G12,I12) | |
| B13 | =SUM(G13,I13) | |
| B15 | =SUM(G15)+I15 | |
| B19 | =SUM(G19,I19) | |
| B21 | =SUM(G21,I21) | |
| B25 | =SUM(G25,I25) | |
| B26 | =SUM(G26,I26) | |
| B27 | =SUM(G27,I27) | |
| B29 | =SUM(G29,I29) | |
| C4 | =COUNTIFS('Missed SLA'!H3:H17,"bakersfield",'Missed SLA'!G3:G17,"missed*") | |
| C5 | =COUNTIFS('Missed SLA'!H3:H17,"bellaire",'Missed SLA'!G3:G17,"missed*") | |
| C6 | =COUNTIFS('Missed SLA'!H3:H17,"concord",'Missed SLA'!G3:G17,"missed*") | |
| C7 | =COUNTIFS('Missed SLA'!H3:H17,"covington",'Missed SLA'!G3:G17,"missed*") | |
| C8 | =COUNTIFS('Missed SLA'!H3:H17,"hou150",'Missed SLA'!G3:G17,"missed*") | |
| C9 | =COUNTIFS('Missed SLA'!H3:H17,"lafayette",'Missed SLA'!G3:G17,"missed*") | |
| C10 | =COUNTIFS('Missed SLA'!H3:H17,"midland",'Missed SLA'!G3:G17,"missed*") | |
| C11 | =COUNTIFS('Missed SLA'!H3:H17,"pascagoula",'Missed SLA'!G3:G17,"missed*") | |
| C12 | =COUNTIFS('Missed SLA'!H3:H17,"richmond",'Missed SLA'!G3:G17,"missed*") | |
| C13 | =COUNTIFS('Missed SLA'!H3:H17,"san ramon",'Missed SLA'!G3:G17,"missed*") | |
| C15 | =SUM(C4:C14) | |
| C19 | =COUNTIFS('Missed SLA'!H3:H17,"san ramon/dp",'Missed SLA'!G3:G17,"missed*") | |
| C21 | =SUM(C19) | |
| C25 | =COUNTIFS('Missed SLA'!H3:H17,"moon township",'Missed SLA'!G3:G17,"missed*") | |
| C26 | =COUNTIFS('Missed SLA'!H3:H17,"*Segundo",'Missed SLA'!G3:G17,"missed*") | |
| C27 | =COUNTIFS('Missed SLA'!H3:H17,"honolulu",'Missed SLA'!G3:G17,"missed*") | |
| C29 | =SUM(C25:C28) | |
| G4 | =COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G5 | =COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G6 | =COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G7 | =COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G8 | =COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G9 | =COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G10 | =COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G11 | =COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G12 | =COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G13 | =COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G15 | =SUM(G4:G13) | |
| G19 | =COUNTIFS('Case Detail'!AR:AR,"san ramon/dp",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"san ramon/dp",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"san ramon/dp",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16")+COUNTIFS('Case Detail'!AR:AR,"san ramon/dp",'Case Detail'!AN:AN,"US DEPOT SAN RAMON 2/0/NBD 3C") | |
| G21 | =G19 | |
| G25 | =COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G26 | =COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G27 | =COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US DT/LT MANN M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US DT/LT MANN HUB 9/0/27")+COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US DT/LT DISP MF 8-5 2/0/16") | |
| G29 | =SUM(G25:G28) | |
| H4 | =COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H5 | =COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H6 | =COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H7 | =COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H8 | =COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H9 | =COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H10 | =COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H11 | =COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H12 | =COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H13 | =COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H15 | =SUM(H4:H13) | |
| H19 | =COUNTIFS('Case Detail'!AR:AR,"San Ramon/Dp",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"San Ramon/Dp",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"San Ramon/Dp",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"San Ramon/Dp",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H21 | =H19 | |
| H25 | =COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H26 | =COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H27 | =COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US T&M NON TX DISP M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US T&M NON-TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US T&M TX M-F 8-5")+COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US T&M TX ONLY DISP M-F 8-5") | |
| H29 | =SUM(H25:H28) | |
| I4 | =COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I5 | =COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I6 | =COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I7 | =COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I8 | =COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I9 | =COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I10 | =COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I11 | =COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I12 | =COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I13 | =COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I15 | =SUM(I4:I13) | |
| I19 | =COUNTIFS('Case Detail'!AR:AR,"san ramon/Dp",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"san ramon/Dp",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"san ramon/Dp",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"san ramon/Dp",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I21 | =I19 | |
| I25 | =COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I26 | =COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I27 | =COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US SER DISP 5X9 M-F 8-5 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US SER DISP SITE 7X24 2/0/8")+COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US SER MANN 5X9 M-F 8-5 1/0/4")+COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US SER MANN SITE 7X24 1/0/4") | |
| I29 | =SUM(I25:I28) | |
| J4 | =COUNTIFS('Case Detail'!AR:AR,"bakersfield",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J5 | =COUNTIFS('Case Detail'!AR:AR,"bellaire",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J6 | =COUNTIFS('Case Detail'!AR:AR,"concord",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J7 | =COUNTIFS('Case Detail'!AR:AR,"covington",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J8 | =COUNTIFS('Case Detail'!AR:AR,"hou150",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J9 | =COUNTIFS('Case Detail'!AR:AR,"lafayette",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J10 | =COUNTIFS('Case Detail'!AR:AR,"midland",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J11 | =COUNTIFS('Case Detail'!AR:AR,"pascagoula",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J12 | =COUNTIFS('Case Detail'!AR:AR,"richmond",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J13 | =COUNTIFS('Case Detail'!AR:AR,"san ramon",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J15 | =SUM(J4:J13) | |
| J19 | =COUNTIFS('Case Detail'!AR:AR,"san ramon/dp",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J21 | =J19 | |
| J25 | =COUNTIFS('Case Detail'!AR:AR,"moon township",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J26 | =COUNTIFS('Case Detail'!AR:AR,"*Segundo",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J27 | =COUNTIFS('Case Detail'!AR:AR,"honolulu",'Case Detail'!AN:AN,"US OUT OF SCOPE M-F 8-5") | |
| J29 | =SUM(J25:J28) | |
| P4 | =(D1-C15-C21-C29)/D1 | |
| Excel 2012 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | |||
| 1 | SLA Phone Made/Miss | SLA Phone Reason | SLA Repair Actual Comp Date | SLA Repair Commit Type | SLA Repair Desc | SLA Repair Duration | SLA Repair Made/Miss. | Contract Site Support Prog Desc | Contract Support Prog | Cust Site Address1 | Cust Site City | Cust Site ID | Support Area | ||
| 2 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 145 S STATE COLLEGE | BREA | S10981874 | Brea/El Segundo | ||||
| 3 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 324 W EL SEGUNDO BLVD | EL SEGUNDO | S10981888 | Brea/El Segundo | ||||
| 4 | Yes | Fulfilled | 5/1/2015 11:43:00 AM | SLA-Repair | 8 Hour Resolution | 3540 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 5 | Yes | Fulfilled | 5/4/2015 10:35:00 AM | SLA-Repair | 8 Hour Resolution | 2520 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 6 | Yes | Fulfilled | 5/5/2015 3:38:00 PM | SLA-Repair | 8 Hour Resolution | 1680 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 7 | Yes | Fulfilled | 5/7/2015 3:42:00 PM | SLA-Repair | 8 Hour Resolution | 2340 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 205 HOLIDAY BLVD | COVINGTON | S11312172 | Lafayette | ||
| 8 | Yes | Fulfilled | 5/8/2015 11:06:00 AM | SLA-Repair | 8 Hour Resolution | 540 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 9 | Yes | Fulfilled | 5/7/2015 3:45:00 PM | SLA-Repair | 8 Hour Resolution | 2640 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 10 | Yes | Fulfilled | 5/5/2015 3:41:00 PM | SLA-Repair | 8 Hour Resolution | 1740 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 11 | Yes | Fulfilled | 5/6/2015 11:41:00 AM | SLA-Repair | 8 Hour Resolution | 3600 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 12 | Yes | Fulfilled | 5/12/2015 10:47:00 AM | SLA-Repair | 8 Hour Resolution | 1020 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 13 | Yes | Fulfilled | 5/12/2015 11:11:00 AM | SLA-Repair | 8 Hour Resolution | 2160 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 14 | Yes | Fulfilled | 5/13/2015 2:20:00 PM | SLA-Repair | 8 Hour Resolution | 600 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 15 | Yes | Fulfilled | 5/12/2015 2:29:00 PM | SLA-Repair | 8 Hour Resolution | 1020 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 16 | Yes | Fulfilled | 5/20/2015 4:03:00 PM | SLA-Repair | 8 Hour Resolution | 8641 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 17 | Yes | Fulfilled | 4/14/2015 11:44:00 AM | SLA-Repair | 8 Hour Resolution | 3360 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 3940 VEROT SCHOOL RD | YOUNGSVILLE | S10982155 | Lafayette | ||
| 18 | Yes | Fulfilled | 5/20/2015 11:53:00 AM | SLA-Repair | 8 Hour Resolution | 1860 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 5750 JOHNSTON ST | LAFAYETTE | S10981689 | Lafayette | ||
| 19 | Yes | Fulfilled | 5/26/2015 11:30:00 AM | SLA-Repair | 8 Hour Resolution | 2340 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 2219 WEST PARK AVE | SCHRIEVER | S11326612 | Lafayette | ||
| 20 | Yes | Fulfilled | 5/27/2015 6:14:00 AM | SLA-Repair | 4 Hour Resolution | 0 | Yes | US SERVER MANNED SITE 5X9 MONDAY-FRIDAY 8AM-5PM 1 HOUR CONTACT/4 HOUR REPAIR | US SER MANN 5X9 M-F 8-5 1/0/4 | 10550 RICHMOND AVE | HOUSTON | S11113420 | Bellaire | ||
| 21 | No | Not Specified | Not Specified | Not Specified | No | US TIME & MATERIAL NON TEXAS SITES MONDAY-FRIDAY 8AM-5PM NO SLA | US T&M NON-TX M-F 8-5 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||||
| 22 | No | Not Specified | Not Specified | Not Specified | No | US TIME & MATERIAL NON TEXAS SITES MONDAY-FRIDAY 8AM-5PM NO SLA | US T&M NON-TX M-F 8-5 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||||
| 23 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||||
| 24 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||||
| 25 | Yes | Fulfilled | 5/5/2015 8:35:00 PM | SLA-Repair | 8 Hour Resolution | 14847 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||
| 26 | Yes | Fulfilled | 4/29/2015 12:42:00 PM | SLA-Repair | 4 Hour Resolution | 1440 | Yes | US SERVER MANNED SITE 5X9 MONDAY-FRIDAY 8AM-5PM 1 HOUR CONTACT/4 HOUR REPAIR | US SER MANN 5X9 M-F 8-5 1/0/4 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||
| 27 | Yes | Fulfilled | 4/28/2015 4:46:00 PM | SLA-Repair | 8 Hour Resolution | 6120 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||
| 28 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||||
| 29 | No | Not Specified | Not Specified | Not Specified | No | US TIME & MATERIAL NON TEXAS SITES MONDAY-FRIDAY 8AM-5PM NO SLA | US T&M NON-TX M-F 8-5 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||||
| 30 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||||
| 31 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||||
| 32 | No | Not Specified | Not Specified | Not Specified | No | US TIME & MATERIAL NON TEXAS SITES MONDAY-FRIDAY 8AM-5PM NO SLA | US T&M NON-TX M-F 8-5 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||||
| 33 | Yes | Fulfilled | 5/11/2015 8:05:00 PM | SLA-Repair | 8 Hour Resolution | 2173 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||
| 34 | Yes | Fulfilled | 5/11/2015 7:34:00 PM | SLA-Repair | 8 Hour Resolution | 29400 | No | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||
| 35 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||||
| 36 | No | Not Specified | Not Specified | Not Specified | No | US TIME & MATERIAL NON TEXAS SITES MONDAY-FRIDAY 8AM-5PM NO SLA | US T&M NON-TX M-F 8-5 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||||
| 37 | No | Not Specified | Not Specified | Not Specified | No | US TIME & MATERIAL NON TEXAS SITES MONDAY-FRIDAY 8AM-5PM NO SLA | US T&M NON-TX M-F 8-5 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||||
| 38 | Yes | Fulfilled | 5/15/2015 11:25:00 AM | SLA-Repair | Not Specified | 6732 | Yes | US DESKTOP/LAPTOP MANNED SITE MONDAY-FRIDAY 8AM-5PM 2 HOUR CONTACT/8 HOUR REPAIR | US DT/LT MANN M-F 8-5 2/0/8 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||
| 39 | No | Not Specified | Not Specified | Not Specified | No | US OUT OF SCOPE MONDAY-FRIDAY 8AM-5PM | US OUT OF SCOPE M-F 8-5 | 100 CHEVRON WAY | RICHMOND | S10981900 | Richmond | ||||
| 40 | No | Not Specified | Not Specified | Not Specified | No | US TIME & MATERIAL NON TEXAS SITES MONDAY-FRIDAY 8AM-5PM NO SLA | US T&M NON-TX M-F 8-5 | 841 CHEVRON WAY | RICHMOND | S10981885 | Richmond | ||||
Case Detail | |||||||||||||||
