Spreadsheet: 144254d1330856854-index-match-index-formula-work-slow-book1_avk
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 |  | :40896::A002::::PG::F::122011::NAGAR::: | :40896::[PHONE]::122011::NAGAR: | :40896::A002::F::122011::NAGAR: | A002:OFF
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 |  | :40896::A002::::PG::OI::122011::NAGAR::: | :40896::[PHONE]::122011::NAGAR: | :40896::A002::OI::122011::NAGAR: | A002:OI
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 |  | :40291::A007::::PG::C::42010::NAGAR::: | :40291::[PHONE]::42010::NAGAR: | :40291::A007::C::42010::NAGAR: | A007:
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 |  | :40340::A008::::I::C::62010::NAGAR::: | :40340::[PHONE]::62010::NAGAR: | :40340::A008::C::62010::NAGAR: | A008:
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 |  | :40280::A010::::PG::F::42010::NAGAR::: | :40280::[PHONE]::42010::NAGAR: | :40280::A010::F::42010::NAGAR: | A010:OF
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 |  | :40280::A010::::PG::F::42010::NAGAR::: | :40280::[PHONE]::42010::NAGAR: | :40280::A010::F::42010::NAGAR: | A010:FF
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 |  | :40280::A010::::PG::F::42010::NAGAR::: | :40280::[PHONE]::42010::NAGAR: | :40280::A010::F::42010::NAGAR: | A010:FF
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 |  | :40280::A010::::PG::OI::42010::NAGAR::: | :40280::[PHONE]::42010::NAGAR: | :40280::A010::OI::42010::NAGAR: | A010:OI
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 |  | :40583::A011::::PG::F::22011::NAGAR::: | :40583::[PHONE]::22011::NAGAR: | :40583::A011::F::22011::NAGAR: | A011:OFF
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 |  | :40583::A011::::PG::OI::22011::NAGAR::: | :40583::[PHONE]::22011::NAGAR: | :40583::A011::OI::22011::NAGAR: | A011:OI
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 |  | :40415::A011::::PG::F::82010::NAGAR::: | :40415::[PHONE]::82010::NAGAR: | :40415::A011::F::82010::NAGAR: | A011:OFF
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 |  | :40415::A011::::PG::OI::82010::NAGAR::: | :40415::[PHONE]::82010::NAGAR: | :40415::A011::OI::82010::NAGAR: | A011:OI
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 |  | :40785::A017::::I::F::82011::NAGAR::: | :40785::[PHONE]::82011::NAGAR: | :40785::A017::F::82011::NAGAR: | A017:OF
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 |  | :40785::A017::::I::R::82011::NAGAR::: | :40785::[PHONE]::82011::NAGAR: | :40785::A017::R::82011::NAGAR: | A017:
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 |  | :40785::A017::::I::F::82011::NAGAR::: | :40785::[PHONE]::82011::NAGAR: | :40785::A017::F::82011::NAGAR: | A017:OF
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 |  | :40785::A017::::I::OI::82011::NAGAR::: | :40785::[PHONE]::82011::NAGAR: | :40785::A017::OI::82011::NAGAR: | A017:OI
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 |  | :40785::A017::::I::OI::82011::NAGAR::: | :40785::[PHONE]::82011::NAGAR: | :40785::A017::OI::82011::NAGAR: | A017:OI
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 |  | :40785::A017::::I::OI::82011::NAGAR::: | :40785::[PHONE]::82011::NAGAR: | :40785::A017::OI::82011::NAGAR: | A017:OI
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 |  | :40864::A018::::I::F::112011::NAGAR::: | :40864::[PHONE]::112011::NAGAR: | :40864::A018::F::112011::NAGAR: | A018:OF
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 |  | :40864::A018::::I::F::112011::NAGAR::: | :40864::[PHONE]::112011::NAGAR: | :40864::A018::F::112011::NAGAR: | A018:FF
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 |  | :40351::A018::::PG::F::62010::NAGAR::: | :40351::[PHONE]::62010::NAGAR: | :40351::A018::F::62010::NAGAR: | A018:OF
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 |  | :40351::A018::::PG::F::62010::NAGAR::: | :40351::[PHONE]::62010::NAGAR: | :40351::A018::F::62010::NAGAR: | A018:FF
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 |  | :40351::A018::::PG::F::62010::NAGAR::: | :40351::[PHONE]::62010::NAGAR: | :40351::A018::F::62010::NAGAR: | A018:FF
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 |  | :40351::A018::::PG::OI::62010::NAGAR::: | :40351::[PHONE]::62010::NAGAR: | :40351::A018::OI::62010::NAGAR: | A018:OI
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 |  | :40864::A021::::PG::A::112011::NAGAR::: | :40864::2H81132000::112011::NAGAR: | :40864::A021::A::112011::NAGAR: | A021:
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 |  | :40754::A021::::PG::R::72011::NAGAR::: | :40754::[PHONE]::72011::NAGAR: | :40754::A021::R::72011::NAGAR: | A021:
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 |  | :40697::A021::::I::F::62011::NAGAR::: | :40697::[PHONE]::62011::NAGAR: | :40697::A021::F::62011::NAGAR: | A021:OFF
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 |  | :40697::A021::::I::F::62011::NAGAR::: | :40697::[PHONE]::62011::NAGAR: | :40697::A021::F::62011::NAGAR: | A021:OF
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 |  | :40647::A021::::PG::X::42011::NAGAR::: | :40647::[PHONE]::42011::NAGAR: | :40647::A021::X::42011::NAGAR: | A021:0
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 |  | :40607::A021::::PG::C::32011::NAGAR::: | :40607::[PHONE]::32011::NAGAR: | :40607::A021::C::32011::NAGAR: | A021:
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 |  | :40607::A021::::PG::F::32011::NAGAR::: | :40607::[PHONE]::32011::NAGAR: | :40607::A021::F::32011::NAGAR: | A021:OFF
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 |  | :40607::A021::::PG::F::32011::NAGAR::: | :40607::[PHONE]::32011::NAGAR: | :40607::A021::F::32011::NAGAR: | A021:AF
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 |  | :40607::A021::::PG::OI::32011::NAGAR::: | :40607::[PHONE]::32011::NAGAR: | :40607::A021::OI::32011::NAGAR: | A021:OI
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 |  | :40329::A021::::PG::F::52010::NAGAR::: | :40329::[PHONE]::52010::NAGAR: | :40329::A021::F::52010::NAGAR: | A021:OFF
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 |  | :40329::A021::::PG::OI::52010::NAGAR::: | :40329::[PHONE]::52010::NAGAR: | :40329::A021::OI::52010::NAGAR: | A021:OI
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 |  | :40310::A021::::PG::F::52010::NAGAR::: | :40310::[PHONE]::52010::NAGAR: | :40310::A021::F::52010::NAGAR: | A021:OFF
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 |  | :40310::A021::::PG::OI::52010::NAGAR::: | :40310::[PHONE]::52010::NAGAR: | :40310::A021::OI::52010::NAGAR: | A021:OI