Spreadsheet: 81730d1281898887-sumproduct-formula-calculate-just-like-marathon-race-part_data_analysis_customerwise
Sheet: FY0910

INVNO | DATE | CODE | OADATE | NAME | DELNO | DELDT | ENGNO | SOADT | OANO | EDONO | MDDEL | PARTNO | QTY | PRICE | DISC | HANDLING | VAT | SERIES | TP | AM | DAM | DAMT | [NAME] | TAM | VAMT | AMT | month&year | sp | br
1090 | 2009-04-01 00:00:00 | 4027 |  | 3A CHEMI PVT LTD |  |  |  |  | PG | 6R | CASH | [PHONE] | 2 | 366.22 |  |  | 12.5 | F | TI | 732.44 | 0 | 732.44 | 0 | 732.44 | 91.56 | 824 | 42009 |  | MIDC
1090 | 2009-04-01 00:00:00 | 4027 |  | 3A CHEMI PVT LTD |  |  |  |  | PG | 6R | CASH | [PHONE] | 1 | 183.11 |  |  | 12.5 | F | TI | 183.11 | 0 | 183.11 | 0 | 183.11 | 22.89 | 206 | 42009 |  | MIDC
1090 | 2009-04-01 00:00:00 | 4027 |  | 3A CHEMI PVT LTD |  |  |  |  | PG | 6R | CASH | [PHONE] | 1 | 3128.89 |  |  | 12.5 | OI | TI | 3128.89 | 0 | 3128.89 | 0 | 3128.89 | 391.11 | 3520 | 42009 |  | MIDC
2828 | 2009-04-04 00:00:00 | A0004 |  | A.A. ENERGY |  |  | VO.5003/0900094 |  | PG | K | CREDIT | KV00430300 | 3 | 1183.11 |  |  | 4 | F | TI | 3549.33 | 0 | 3549.33 | 0 | 3549.33 | 141.97 | 3691 | 42009 |  | NGP
2828 | 2009-04-05 00:00:00 | A0004 |  | A.A. ENERGY |  |  | VO.5003/0900094 |  | PG | K | CREDIT | KV01100100 | 2 | 1345.78 |  |  | 4 | F | TI | 2691.56 | 0 | 2691.56 | 0 | 2691.56 | 107.66 | 2799 | 42009 |  | NGP
2828 | 2009-04-06 00:00:00 | A0004 |  | A.A. ENERGY |  |  | VO.5003/0900094 |  | PG | K | CREDIT | KV25062000 | 2 | 515.56 |  |  | 4 | F | TI | 1031.12 | 0 | 1031.12 | 0 | 1031.12 | 41.24 | 1072 | 42009 |  | NGP
3135 | 2009-04-07 00:00:00 | A0004 |  | A.A. ENERGY |  |  | V0.5003\0900094 |  | PG | K | CREDIT | KV00430300 | 2 | 1183.11 |  |  | 4 | F | TI | 2366.22 | 0 | 2366.22 | 0 | 2366.22 | 94.65 | 2461 | 42009 |  | AKL
3135 | 2009-04-08 00:00:00 | A0004 |  | A.A. ENERGY |  |  | V0.5003\0900094 |  | PG | K | CREDIT | KV01100100 | 1 | 1345.78 |  |  | 4 | F | TI | 1345.78 | 0 | 1345.78 | 0 | 1345.78 | 53.83 | 1400 | 42009 |  | NGP
3135 | 2009-04-09 00:00:00 | A0004 |  | A.A. ENERGY |  |  | V0.5003\0900094 |  | PG | K | CREDIT | KV05050200 | 2 | 2384.89 |  |  | 4 | F | TI | 4769.78 | 0 | 4769.78 | 0 | 4769.78 | 190.79 | 4961 | 42009 |  | NGP
3135 | 2009-04-10 00:00:00 | A0004 |  | A.A. ENERGY |  |  | V0.5003\0900094 |  | PG | K | CREDIT | KV05050300 | 2 | 1596.44 |  |  | 4 | F | TI | 3192.88 | 0 | 3192.88 | 0 | 3192.88 | 127.72 | 3321 | 42009 |  | AMRT
3135 | 2009-04-01 00:00:00 | A0004 |  | A.A. ENERGY |  |  | V0.5003\0900094 |  | PG | K | CREDIT | KV25062000 | 1 | 515.56 |  |  | 4 | F | TI | 515.56 | 0 | 515.56 | 0 | 515.56 | 20.62 | 536 | 42009 |  | NGP
2828 | 2009-04-02 00:00:00 | A0004 |  | A.A. ENERGY |  |  | VO.5003/0900094 |  | PG | K | CREDIT | [PHONE] | 1 | 2035.55 |  |  | 4 | OI | TI | 2035.55 | 0 | 2035.55 | 0 | 2035.55 | 81.42 | 2117 | 42009 |  | NGP
2828 | 2009-04-03 00:00:00 | A0004 |  | A.A. ENERGY |  |  | VO.5003/0900094 |  | PG | K | CREDIT | [PHONE] | 3 | 3128.88 |  |  | 4 | OI | TI | 9386.64 | 0 | 9386.64 | 0 | 9386.64 | 375.47 | 9762 | 42009 |  | NGP
3135 | 2009-04-04 00:00:00 | A0004 |  | A.A. ENERGY |  |  | V0.5003\0900094 |  | PG | K | CREDIT | [PHONE] | 1 | 2035.55 |  |  | 4 | OI | TI | 2035.55 | 0 | 2035.55 | 0 | 2035.55 | 81.42 | 2117 | 42009 |  | NGP
3135 | 2009-04-05 00:00:00 | A0004 |  | A.A. ENERGY |  |  | V0.5003\0900094 |  | PG | K | CREDIT | [PHONE] | 5 | 3128.88 |  |  | 4 | OI | TI | 15644.4 | 0 | 15644.4 | 0 | 15644.4 | 625.78 | 16270 | 42009 |  | NGP
1168 | 2009-04-06 00:00:00 | A0004 |  | A.A.ENERGY |  |  | KV.5003/0900094 |  | PG | K | CREDIT | KV00430300 | 2 | 1183.11 |  |  | 12.5 | F | TI | 2366.22 | 0 | 2366.22 | 0 | 2366.22 | 295.78 | 2662 | 42009 |  | NGP
1168 | 2009-04-07 00:00:00 | A0004 |  | A.A.ENERGY |  |  | KV.5003/0900094 |  | PG | K | CREDIT | KV01100100 | 1 | 1345.78 |  |  | 12.5 | F | TI | 1345.78 | 0 | 1345.78 | 0 | 1345.78 | 168.22 | 1514 | 42009 |  | NGP
1168 | 2009-04-08 00:00:00 | A0004 |  | A.A.ENERGY |  |  | KV.5003/0900094 |  | PG | K | CREDIT | KV25062000 | 1 | 515.56 |  |  | 12.5 | F | TI | 515.56 | 0 | 515.56 | 0 | 515.56 | 64.45 | 580 | 42009 |  | NGP
1461 | 2009-04-09 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV00430300 | 2 | 1183.11 |  |  | 12.5 | F | TI | 2366.22 | 0 | 2366.22 | 0 | 2366.22 | 295.78 | 2662 | 42009 |  | NGP
1461 | 2009-04-10 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV01100100 | 1 | 1345.78 |  |  | 12.5 | F | TI | 1345.78 | 0 | 1345.78 | 0 | 1345.78 | 168.22 | 1514 | 42009 |  | NGP
1461 | 2009-04-01 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV25062000 | 1 | 515.56 |  |  | 12.5 | F | TI | 515.56 | 0 | 515.56 | 0 | 515.56 | 64.45 | 580 | 42009 |  | NGP
1971 | 2009-04-02 00:00:00 | A0004 |  | A.A.ENERGY |  |  | [NAME] |  | PG | K | CREDIT | KV00430300 | 2 | 1183.11 |  |  | 12.5 | F | TI | 2366.22 | 0 | 2366.22 | 0 | 2366.22 | 295.78 | 2662 | 42009 |  | NGP
1971 | 2009-04-03 00:00:00 | A0004 |  | A.A.ENERGY |  |  | [NAME] |  | PG | K | CREDIT | KV01100100 | 1 | 1345.78 |  |  | 12.5 | F | TI | 1345.78 | 0 | 1345.78 | 0 | 1345.78 | 168.22 | 1514 | 42009 |  | NGP
1971 | 2009-04-04 00:00:00 | A0004 |  | A.A.ENERGY |  |  | [NAME] |  | PG | K | CREDIT | KV25062000 | 1 | 515.56 |  |  | 12.5 | F | TI | 515.56 | 0 | 515.56 | 0 | 515.56 | 64.45 | 580 | 42009 |  | MIDC
1971 | 2009-04-05 00:00:00 | A0004 |  | A.A.ENERGY |  |  | [NAME] |  | PG | K | CREDIT | KV05050200 | 1 | 2384.89 |  |  | 12.5 | F | TI | 2384.89 | 0 | 2384.89 | 0 | 2384.89 | 298.11 | 2683 | 42009 |  | MIDC
1971 | 2009-04-06 00:00:00 | A0004 |  | A.A.ENERGY |  |  | [NAME] |  | PG | K | CREDIT | KV05050300 | 1 | 1596.44 |  |  | 12.5 | F | TI | 1596.44 | 0 | 1596.44 | 0 | 1596.44 | 199.56 | 1796 | 42009 |  | MIDC
2247 | 2009-04-07 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV00430300 | 2 | 1183.11 |  |  | 12.5 | F | TI | 2366.22 | 0 | 2366.22 | 0 | 2366.22 | 295.78 | 2662 | 42009 |  | NGP
2247 | 2009-04-08 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV01100100 | 1 | 1345.78 |  |  | 12.5 | F | TI | 1345.78 | 0 | 1345.78 | 0 | 1345.78 | 168.22 | 1514 | 42009 |  | NGP
2247 | 2009-04-09 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV25062000 | 1 | 515.56 |  |  | 12.5 | F | TI | 515.56 | 0 | 515.56 | 0 | 515.56 | 64.45 | 580 | 42009 |  | NGP
2483 | 2009-04-10 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV00430300 | 2 | 1183.11 |  |  | 4 | F | TI | 2366.22 | 0 | 2366.22 | 0 | 2366.22 | 94.65 | 2461 | 42009 |  | NGP
2483 | 2009-04-01 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV01100100 | 1 | 1345.78 |  |  | 4 | F | TI | 1345.78 | 0 | 1345.78 | 0 | 1345.78 | 53.83 | 1400 | 42009 |  | NGP
2483 | 2009-04-02 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV05050200 | 2 | 2384.89 |  |  | 4 | F | TI | 4769.78 | 0 | 4769.78 | 0 | 4769.78 | 190.79 | 4961 | 42009 |  | NGP
2483 | 2009-04-03 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV05050300 | 2 | 1596.44 |  |  | 4 | F | TI | 3192.88 | 0 | 3192.88 | 0 | 3192.88 | 127.72 | 3321 | 42009 |  | NGP
2483 | 2009-04-04 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | KV25062000 | 1 | 515.56 |  |  | 4 | F | TI | 515.56 | 0 | 515.56 | 0 | 515.56 | 20.62 | 536 | 42009 |  | NGP
1168 | 2009-04-05 00:00:00 | A0004 |  | A.A.ENERGY |  |  | KV.5003/0900094 |  | PG | K | CREDIT | [PHONE] | 2 | 3128.88 |  |  | 12.5 | OI | TI | 6257.76 | 0 | 6257.76 | 0 | 6257.76 | 782.22 | 7040 | 42009 |  | NGP
1461 | 2009-04-06 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | [PHONE] | 2 | 3128.88 |  |  | 12.5 | OI | TI | 6257.76 | 0 | 6257.76 | 0 | 6257.76 | 782.22 | 7040 | 42009 |  | NGP
1971 | 2009-04-07 00:00:00 | A0004 |  | A.A.ENERGY |  |  | [NAME] |  | PG | K | CREDIT | [PHONE] | 2 | 3128.88 |  |  | 12.5 | OI | TI | 6257.76 | 0 | 6257.76 | 0 | 6257.76 | 782.22 | 7040 | 42009 |  | NGP
2247 | 2009-04-08 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | [PHONE] | 2 | 3128.88 |  |  | 12.5 | OI | TI | 6257.76 | 0 | 6257.76 | 0 | 6257.76 | 782.22 | 7040 | 42009 |  | NGP
2483 | 2009-04-09 00:00:00 | A0004 |  | A.A.ENERGY |  |  |  |  | PG | K | CREDIT | [PHONE] | 2 | 3128.88 |  |  | 4 | OI | TI | 6257.76 | 0 | 6257.76 | 0 | 6257.76 | 250.31 | 6508 | 42009 |  | NGP