Spreadsheet: 66950d1267619691-trim-test
Sheet: Indent,PO TAT

 |  |  |  |  |  | You can either obtain the data from Oracle xml report Average TAT for Indents and POs or obtain the data from excel sheets or manual ledgers maintained at the Circles. (Take the data from the same source from which you prepare your COR/FRM presentations a
 |  |  | Only for that respective month. Values for individual Indent,PO
 | Circle | WB
 | Indent No | Capex/Opex | TAT for Indent Approval |  |  | PO No | Capex/Opex | TAT for PO Creation | TAT for PO Approval | Total TAT for PO
 | 12809100549 | OPEX | 1 |  |  | 12809400451 | OPEX | 11 | 0 | #N/A
 | 12809100488 | OPEX | 3 |  |  | 12809400374 | OPEX | 38 | 0 | #N/A
 | 12809100611 | OPEX | 1 |  |  | 12809400512 | OPEX | 5 | 0 | #N/A
 | 12809100614 | OPEX | 1 |  |  | 12809400513 | OPEX | 3 | 0 | #N/A
 | 12809100580 | OPEX | 5 |  |  | 12809400463 | OPEX | 2 | 0 | #N/A
 | 12809100595 | OPEX | 0 |  |  | 12809400490 | OPEX | 4 | 0 | #N/A
 | 12809100609 | OPEX | 0 |  |  | 12809400496 | OPEX | 2 | 0 | #N/A
 | 12809100649 | OPEX | 1 |  |  | 12809400530 | OPEX | 0 | 0 | #N/A
 | 12809100629 | OPEX | 3 |  |  | 12809400531 | OPEX | 0 | 0 | #N/A
 | 12809100451 | CAPEX | 41 |  |  | 12809400453 | CAPEX | 2 | 0 | #N/A
 | 12809100442 | CAPEX | 27 |  |  | 12809400444 | CAPEX | 20 | 0 | #N/A
 | 12809100643 | OPEX | 2 |  |  | 12809400529 | OPEX | 0 | 0 | #N/A
 | 12809100537 | CAPEX | 7 |  |  | 12809400441 | CAPEX | 21 | 0 | #N/A
 | 12809100610 | OPEX | 1 |  |  | 12809400507 | OPEX | 5 | 0 | #N/A
 | 12809100590 | OPEX | 2 |  |  | 12809400384 | OPEX | 0 | 0 | #N/A
 | 12809100513 | OPEX | 27 |  |  | 12809400473 | OPEX | 3 | 0 | #N/A
 | 12809100595 | OPEX | 0 |  |  | 12809400488 | OPEX | 4 | 0 | #N/A
 | 12809100594 | OPEX | 0 |  |  | 12809400483 | OPEX | 4 | 0 | #N/A
 | 12809100601 | OPEX | 3 |  |  | 12809400495 | OPEX | 2 | 0 | #N/A
 | 12809100591 | OPEX | 2 |  |  | 12809400500 | OPEX | 7 | 0 | #N/A
 | 12809100621 | OPEX | 0 |  |  | 12809400525 | OPEX | 7 | 0 | #N/A
 | 12809100531 | OPEX | 42 |  |  | 12809400526 | OPEX | 1 | 0 | #N/A
 | 12809100457 | CAPEX | 48 |  |  | 12809400501 | CAPEX | 17 | 0 | #N/A
 | 12809100366 | CAPEX | 64 |  |  | 12809400503 | CAPEX | 38 | 0 | #N/A
 | 12809100581 | OPEX | 8 |  |  | 12809400493 | OPEX | 7 | 0 | #N/A
 | 12809100610 | OPEX | 1 |  |  | 12809400504 | OPEX | 5 | 0 | #N/A
 | 12809100610 | OPEX | 1 |  |  | 12809400505 | OPEX | 5 | 0 | #N/A
 | 12809100610 | OPEX | 1 |  |  | 12809400506 | OPEX | 5 | 0 | #N/A
 | 12809100611 | OPEX | 1 |  |  | 12809400510 | OPEX | 5 | 0 | #N/A
 | 12809100611 | OPEX | 1 |  |  | 12809400511 | OPEX | 5 | 0 | #N/A
 | 12809100615 | OPEX | 1 |  |  | 12809400515 | OPEX | 3 | 0 | #N/A
 | 12809100551 | OPEX | 19 |  |  | 12809400477 | OPEX | 3 | 0 | #N/A
 | 12809100574 | OPEX | 6 |  |  | 12809400475 | OPEX | 3 | 0 | #N/A
 | 12809100594 | OPEX | 0 |  |  | 12809400485 | OPEX | 4 | 0 | #N/A
 | 12809100573 | OPEX | 12 |  |  | 12809400499 | OPEX | 2 | 0 | #N/A
 | 12809100602 | OPEX | 7 |  |  | 12809400521 | OPEX | 4 | 0 | #N/A
 | 12809100621 | OPEX | 0 |  |  | 12809400524 | OPEX | 7 | 0 | #N/A
 | 12809100497 | CAPEX | 1 |  |  | 12809400409 | CAPEX | 43 | 0 | #N/A
 | 12809100613 | OPEX | 2 |  |  | 12809400517 | OPEX | 3 | 0 | #N/A
 | 12809100639 | OPEX | 3 |  |  | 12809400527 | OPEX | 0 | 0 | #N/A
 | 12809100625 | OPEX | 6 |  |  | 12809400533 | OPEX | 0 | 0 | #N/A
 | 12809100537 | CAPEX | 7 |  |  | 12809400431 | CAPEX | 11 | 0 | #N/A
 | 12809100484 | OPEX | 0 |  |  | 12809400354 | OPEX | 51 | 0 | #N/A
 | 12809100616 | OPEX | 1 |  |  | 12809400514 | OPEX | 3 | 0 | #N/A
 | 12809100620 | OPEX | 0 |  |  | 12809400515 | OPEX | 3 | 0 | #N/A
 | 12809100548 | OPEX | 1 |  |  | 12809400384 | OPEX | 20 | 0 | #N/A
 | 12809100592 | OPEX | 1 |  |  | 12809400465 | OPEX | 0 | 0 | #N/A
 | 12809100609 | OPEX | 0 |  |  | 12809400497 | OPEX | 2 | 0 | #N/A
 | 12809100572 | OPEX | 12 |  |  | 12809400498 | OPEX | 2 | 0 | #N/A
 | 12809100632 | CAPEX | 3 |  |  | 12809400535 | CAPEX | 0 | 0 | #N/A
 | 12809100454 | CAPEX | 43 |  |  | 12809400454 | CAPEX | 1 | 0 | #N/A
 | 12809100582 | CAPEX | 4 |  |  | 12809400461 | CAPEX | 2 | 0 | #N/A
 | 12809100570 | OPEX | 8 |  |  | 12809400456 | OPEX | 0 | 0 | #N/A
 | 12809100585 | OPEX | 4 |  |  | 12809400464 | OPEX | 2 | 0 | #N/A
 | 12809100593 | OPEX | 1 |  |  | 12809400467 | OPEX | 0 | 0 | #N/A
 | 12809100559 | OPEX | 17 |  |  | 12809400476 | OPEX | 1 | 0 | #N/A
 | 12809100611 | OPEX | 1 |  |  | 12809400520 | OPEX | 6 | 0 | #N/A
 | 12809100645 | OPEX | 2 |  |  | 12809400528 | OPEX | 0 | 0 | #N/A
 | 12809100624 | OPEX | 5 |  |  | 12809400523 | OPEX | 1 | 0 | #N/A
 | 12809100563 | CAPEX | 13 |  |  | 12809400478 | CAPEX | 6 | 0 | #N/A
 | 12809100526 | CAPEX | 1 |  |  | 12809400452 | CAPEX | 18 | 0 | #N/A
 | 12809100575 | CAPEX | 5 |  |  | 12809400460 | CAPEX | 2 | 0 | #N/A
 | 12809100464 | CAPEX | 39 |  |  | 12809400469 | CAPEX | 10 | 0 | #N/A
 | 12809100454 | CAPEX | 43 |  |  | 12809400471 | CAPEX | 9 | 0 | #N/A
 | 12809100648 | OPEX | 2 |  |  | 12809400532 | OPEX | 0 | 0 | #N/A
 | 12809100556 | OPEX | 5 |  |  | 12809400450 | OPEX | 6 | 0 | #N/A
 | 12809100611 | OPEX | 1 |  |  | 12809400509 | OPEX | 5 | 0 | #N/A
 | 12809100476 | OPEX | 10 |  |  | 12809400384 | OPEX | 35 | 0 | #N/A
 | 12809100595 | OPEX | 0 |  |  | 12809400487 | OPEX | 4 | 0 | #N/A
 | 12809100595 | OPEX | 0 |  |  | 12809400489 | OPEX | 4 | 0 | #N/A
 | 12809100595 | OPEX | 0 |  |  | 12809400491 | OPEX | 4 | 0 | #N/A
 | 12809100595 | OPEX | 0 |  |  | 12809400492 | OPEX | 4 | 0 | #N/A
 | 12809100594 | OPEX | 0 |  |  | 12809400479 | OPEX | 4 | 0 | #N/A
 | 12809100594 | OPEX | 0 |  |  | 12809400481 | OPEX | 4 | 0 | #N/A
 | 12809100480 | CAPEX | 5 |  |  | 12809400447 | CAPEX | 36 | 0 | #N/A
 | 12809100512 | CAPEX | 27 |  |  | 12809400458 | CAPEX | 0 | 0 | #N/A
 | 12809100577 | OPEX | 5 |  |  | 12809400468 | OPEX | 2 | 0 | #N/A
 | 12809100554 | OPEX | 5 |  |  | 12809400449 | OPEX | 6 | 0 | #N/A
 | 12809100571 | OPEX | 8 |  |  | 12809400462 | OPEX | 2 | 0 | #N/A
 | 12809100593 | OPEX | 1 |  |  | 12809400466 | OPEX | 0 | 0 | #N/A
 | 12809100583 | OPEX | 4 |  |  | 12809400470 | OPEX | 3 | 0 | #N/A
 | 12809100594 | OPEX | 0 |  |  | 12809400486 | OPEX | 4 | 0 | #N/A
 | 12809100594 | OPEX | 0 |  |  | 12809400480 | OPEX | 4 | 0 | #N/A
 | 12809100594 | OPEX | 0 |  |  | 12809400482 | OPEX | 4 | 0 | #N/A
 | 12809100597 | OPEX | 0 |  |  | 12809400494 | OPEX | 6 | 0 | #N/A
 | 12809100596 | OPEX | 0 |  |  | 12809400494 | OPEX | 6 | 0 | #N/A
 | 12809100621 | OPEX | 0 |  |  | 12809400518 | OPEX | 5 | 0 | #N/A
 | 12809100611 | OPEX | 1 |  |  | 12809400519 | OPEX | 6 | 0 | #N/A
 | 12809100626 | OPEX | 4 |  |  | 12809400534 | OPEX | 0 | 0 | #N/A
 | 12809100483 | OPEX | 0 |  |  | 12809400354 | OPEX | 51 | 0 | #N/A
 | 12809100622 | OPEX | 0 |  |  | 12809400516 | OPEX | 3 | 0 | #N/A
 | 12809100587 | OPEX | 1 |  |  | 12809400457 | OPEX | 0 | 0 | #N/A
 | 12809100598 | OPEX | 0 |  |  | 12809400472 | OPEX | 1 | 0 | #N/A
 | 12809100594 | OPEX | 0 |  |  | 12809400484 | OPEX | 4 | 0 | #N/A
 | 12809100491 | CAPEX | 44 |  |  | 12809400502 | CAPEX | 2 | 0 | #N/A
 | 12809100447 | CAPEX | 41 |  |  | 12809400455 | CAPEX | 3 | 0 | #N/A
 | 12809100543 | CAPEX | 5 |  |  | 12809400439 | CAPEX | 16 | 0 | #N/A
 | 12809100471 | CAPEX | 40 |  |  | 12809400469 | CAPEX | 9 | 0 | #N/A