Spreadsheet: 144014d1330679308-index-match-index-formula-work-slow-index_match_index
Sheet: DATA

REF | TDATE | CMNO | OADATE | BNA | DELNO | DELDT | ENGNO | SOADT | OANO | EDONO | MDDEL | PARTNO | QTY | PRICE | DISC | SUBSERIES | VAT | SERIES | TP | AM | DAM | DAMT | [NAME] | TAM | VAMT | AMT | month&year | sp | br | DIST | KEYADD | KEYADD_PARTWISE | [NAME] | OIL_FILTER
1989 | 2011-12-19 00:00:00 | A002 |  | A.A. ENGINEERS |  |  |  |  | PG |  | CASH | [PHONE] | 1 | 184.89 |  | OFF | 12.5 | F | TI | 184.89 | 0 | 184.89 | 0 | 184.89 | 23.11 | 208 | 122011 | F | NAGAR
1989 | 2011-12-19 00:00:00 | A002 |  | A.A. ENGINEERS |  |  |  |  | PG |  | CASH | [PHONE] | 1 | 1480 |  | OI | 12.5 | OI | TI | 1480 | 0 | 1480 | 0 | 1480 | 185 | 1665 | 122011 | OI | NAGAR
0204 | 2010-04-23 00:00:00 | A007 |  | [NAME] |  |  |  |  | PG | 4R | CASH | [PHONE] | 2 | 609.78 |  |  | 12.5 | C | TI | 1219.56 | 0 | 1219.56 | 0 | 1219.56 | 152.45 | 1372 | 42010 | SPARE | NAGAR
0671 | 2010-06-11 00:00:00 | A008 |  | AAGLE SOMNATH |  |  |  |  | I | 4R | CASH | [PHONE] | 1 | 1195.56 |  |  | 12.5 | C | TI | 1195.56 | 0 | 1195.56 | 0 | 1195.56 | 149.45 | 1345 | 62010 | SPARE | NAGAR
0034 | 2010-04-12 00:00:00 | A010 |  | R N AALPE |  |  |  |  | PG |  | CASH | [PHONE] | 1 | 366.22 |  | OF | 12.5 | F | TI | 366.22 | 0 | 366.22 | 0 | 366.22 | 45.78 | 412 | 42010 | F | NAGAR
0034 | 2010-04-12 00:00:00 | A010 |  | R N AALPE |  |  |  |  | PG |  | CASH | [PHONE] | 1 | 88.89 |  | FF | 12.5 | F | TI | 88.89 | 0 | 88.89 | 0 | 88.89 | 11.11 | 100 | 42010 | F | NAGAR
0034 | 2010-04-12 00:00:00 | A010 |  | R N AALPE |  |  |  |  | PG |  | CASH | [PHONE] | 1 | 97.78 |  | FF | 12.5 | F | TI | 97.78 | 0 | 97.78 | 0 | 97.78 | 12.22 | 110 | 42010 | F | NAGAR
0034 | 2010-04-12 00:00:00 | A010 |  | R N AALPE |  |  |  |  | PG |  | CASH | [PHONE] | 1 | 2035.5 |  | OI | 12.5 | OI | TI | 2035.5 | 0 | 2035.5 | 0 | 2035.5 | 254.44 | 2290 | 42010 | OI | NAGAR
2388 | 2011-02-09 00:00:00 | A011 |  | ABASAHEB KAKDE MAHAVIDYALAYA |  |  |  |  | PG |  | CREDIT | [PHONE] | 1 | 176 |  | OFF | 12.5 | F | TI | 176 | 0 | 176 | 0 | 176 | 22 | 198 | 22011 | F | NAGAR
2388 | 2011-02-09 00:00:00 | A011 |  | ABASAHEB KAKDE MAHAVIDYALAYA |  |  |  |  | PG |  | CREDIT | [PHONE] | 1 | 1352.89 |  | OI | 12.5 | OI | TI | 1352.89 | 0 | 1352.89 | 0 | 1352.89 | 169.11 | 1522 | 22011 | OI | NAGAR
1234 | 2010-08-25 00:00:00 | A011 |  | ABASAHEB KAKDE MAHAVIDYALAYA |  |  |  |  | PG |  | CREDIT | [PHONE] | 1 | 163.56 |  | OFF | 12.5 | F | TI | 163.56 | 0 | 163.56 | 0 | 163.56 | 20.45 | 184 | 82010 | F | NAGAR
1234 | 2010-08-25 00:00:00 | A011 |  | ABASAHEB KAKDE MAHAVIDYALAYA |  |  |  |  | PG |  | CREDIT | [PHONE] | 2 | 840 |  | OI | 12.5 | OI | TI | 1680 | 0 | 1680 | 0 | 1680 | 210 | 1890 | 82010 | OI | NAGAR
1166 | 2011-08-30 00:00:00 | A017 |  | ABHAYKUMAR MACHINERY CO. |  |  |  |  | I |  | CREDIT | [PHONE] | 3 | 84.44 | 10 | OF | 12.5 | F | TI | 253.32 | 25.33 | 227.99 | 0 | 227.99 | 28.5 | 256 | 82011 | F | NAGAR
1166 | 2011-08-30 00:00:00 | A017 |  | ABHAYKUMAR MACHINERY CO. |  |  |  |  | I |  | CREDIT | [PHONE] | 3 | 877.33 | 10 |  | 12.5 | R | TI | 2631.99 | 263.2 | 2368.79 | 0 | 2368.79 | 296.1 | 2665 | 82011 | SPARE | NAGAR
1167 | 2011-08-30 00:00:00 | A017 |  | ABHAYKUMAR MACHINERY CO. |  |  |  |  | I |  | CREDIT | [PHONE] | 5 | 379.56 | 10 | OF | 12.5 | F | TI | 1897.8 | 189.78 | 1708.02 | 0 | 1708.02 | 213.5 | 1922 | 82011 | F | NAGAR
1167 | 2011-08-30 00:00:00 | A017 |  | ABHAYKUMAR MACHINERY CO. |  |  |  |  | I |  | CREDIT | [PHONE] | 4 | 989.33 | 10 | OI | 12.5 | OI | TI | 3957.32 | 395.73 | 3561.59 | 0 | 3561.59 | 445.2 | 4007 | 82011 | OI | NAGAR
1167 | 2011-08-30 00:00:00 | A017 |  | ABHAYKUMAR MACHINERY CO. |  |  |  |  | I |  | CREDIT | [PHONE] | 5 | 2431.11 | 10 | OI | 12.5 | OI | TI | 12155.55 | 1215.56 | 10939.99 | 0 | 10939.99 | 1367.5 | 12307 | 82011 | OI | NAGAR
1167 | 2011-08-30 00:00:00 | A017 |  | ABHAYKUMAR MACHINERY CO. |  |  |  |  | I |  | CREDIT | [PHONE] | 2 | 3738.67 | 10 | OI | 12.5 | OI | TI | 7477.34 | 747.73 | 6729.61 | 0 | 6729.61 | 841.2 | 7571 | 82011 | OI | NAGAR
1719 | 2011-11-17 00:00:00 | A018 |  | ABHIKALP INFRASTRATURE |  |  |  |  | I |  | CREDIT | [PHONE] | 1 | 379.56 | 0 | OF | 12.5 | F | TI | 379.56 | 0 | 379.56 | 0 | 379.56 | 47.45 | 427 | 112011 | F | NAGAR
1719 | 2011-11-17 00:00:00 | A018 |  | ABHIKALP INFRASTRATURE |  |  |  |  | I |  | CREDIT | [PHONE] | 1 | 218.67 | 0 | FF | 12.5 | F | TI | 218.67 | 0 | 218.67 | 0 | 218.67 | 27.33 | 246 | 112011 | F | NAGAR
0755 | 2010-06-22 00:00:00 | A018 |  | ABHIKALP INFRASTRATURE |  |  |  |  | PG |  | CREDIT | [PHONE] | 1 | 77.33 |  | OF | 12.5 | F | TI | 77.33 | 0 | 77.33 | 0 | 77.33 | 9.67 | 87 | 62010 | F | NAGAR
0755 | 2010-06-22 00:00:00 | A018 |  | ABHIKALP INFRASTRATURE |  |  |  |  | PG |  | CREDIT | [PHONE] | 1 | 88.89 |  | FF | 12.5 | F | TI | 88.89 | 0 | 88.89 | 0 | 88.89 | 11.11 | 100 | 62010 | F | NAGAR
0755 | 2010-06-22 00:00:00 | A018 |  | ABHIKALP INFRASTRATURE |  |  |  |  | PG |  | CREDIT | [PHONE] | 1 | 97.78 |  | FF | 12.5 | F | TI | 97.78 | 0 | 97.78 | 0 | 97.78 | 12.22 | 110 | 62010 | F | NAGAR
0755 | 2010-06-22 00:00:00 | A018 |  | ABHIKALP INFRASTRATURE |  |  |  |  | PG |  | CREDIT | [PHONE] | 2 | 1258.66 |  | OI | 12.5 | OI | TI | 2517.32 | 0 | 2517.32 | 0 | 2517.32 | 314.67 | 2832 | 62010 | OI | NAGAR
1715 | 2011-11-17 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS |  |  |  |  | PG |  | CREDIT | 2H81132000 | 1 | 5770.67 | 5 |  | 12.5 | A | TI | 5770.67 | 288.53 | 5482.14 | 0 | 5482.14 | 685.27 | 6167 | 112011 | SPARE | NAGAR
0982 | 2011-07-30 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS |  |  |  |  | PG | 4R | CREDIT | [PHONE] | 1 | 173.33 | 0 |  | 12.5 | R | TI | 173.33 | 0 | 173.33 | 0 | 173.33 | 21.67 | 195 | 72011 | SPARE | NAGAR
0511 | 2011-06-03 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS |  |  |  |  | I | RB | CREDIT | [PHONE] | 1 | 176 | 0 | OFF | 12.5 | F | TI | 176 | 0 | 176 | 0 | 176 | 22 | 198 | 62011 | F | NAGAR
0511 | 2011-06-03 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS |  |  |  |  | I | RB | CREDIT | [PHONE] | 1 | 208 | 0 | OF | 12.5 | F | TI | 208 | 0 | 208 | 0 | 208 | 26 | 234 | 62011 | F | NAGAR
0072 | 2011-04-14 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS |  |  |  |  | PG | 4R | CREDIT | [PHONE] | 6 | 282 | 0 | 0 | 12.5 | X | TI | 1692 | 0 | 1692 | 0 | 1692 | 211.5 | 1904 | 42011 | SPARE | NAGAR
2571 | 2011-03-05 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS,PUNE |  |  |  |  | PG | RB | CREDIT | [PHONE] | 1 | 654.22 |  |  | 12.5 | C | TI | 654.22 | 0 | 654.22 | 0 | 654.22 | 81.78 | 736 | 32011 | SPARE | NAGAR
2571 | 2011-03-05 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS,PUNE |  |  |  |  | PG | RB | CREDIT | [PHONE] | 1 | 176 |  | OFF | 12.5 | F | TI | 176 | 0 | 176 | 0 | 176 | 22 | 198 | 32011 | F | NAGAR
2571 | 2011-03-05 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS,PUNE |  |  |  |  | PG | RB | CREDIT | [PHONE] | 1 | 558.22 |  | AF | 12.5 | F | TI | 558.22 | 0 | 558.22 | 0 | 558.22 | 69.78 | 628 | 32011 | F | NAGAR
2571 | 2011-03-05 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS,PUNE |  |  |  |  | PG | RB | CREDIT | [PHONE] | 1 | 3391.11 |  | OI | 12.5 | OI | TI | 3391.11 | 0 | 3391.11 | 0 | 3391.11 | 423.89 | 3815 | 32011 | OI | NAGAR
0592 | 2010-05-31 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS,PUNE |  |  |  |  | PG | 4R | CREDIT | [PHONE] | 1 | 163.56 |  | OFF | 12.5 | F | TI | 163.56 | 0 | 163.56 | 0 | 163.56 | 20.45 | 184 | 52010 | F | NAGAR
0592 | 2010-05-31 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS,PUNE |  |  |  |  | PG | 4R | CREDIT | [PHONE] | 2 | 840 |  | OI | 12.5 | OI | TI | 1680 | 0 | 1680 | 0 | 1680 | 210 | 1890 | 52010 | OI | NAGAR
0378 | 2010-05-12 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS,PUNE |  |  |  |  | PG | 4R | CREDIT | [PHONE] | 1 | 163.56 |  | OFF | 12.5 | F | TI | 163.56 | 0 | 163.56 | 0 | 163.56 | 20.45 | 184 | 52010 | F | NAGAR
0378 | 2010-05-12 00:00:00 | A021 |  | ACCURATE POWER SYSTEMS,PUNE |  |  |  |  | PG | 4R | CREDIT | [PHONE] | 2 | 840 |  | OI | 12.5 | OI | TI | 1680 | 0 | 1680 | 0 | 1680 | 210 | 1890 | 52010 | OI | NAGAR