srinivasan1129
New Member
- Joined
- Apr 20, 2011
- Messages
- 13
| S.No | Year | Name / Number | Rationcard Number | Application_id | Caste | Village | Applied Area(Ha) | Irrigation Type | MI Company |
| 1 | 2017-2018 | Jem | 521037 | 00878539-2017-18 | Other Caste | Srirangarajapuram | 0.7 | Drip | EPC Industries Ltd., |
| 2 | 2017-2018 | Ketty | 571480 | 00905816-2017-18 | Other Caste | Theiyar | 0.88 | Drip | Nagarjuna Fertilizer & Chemicals Ltd |
| 3 | 2017-2018 | Luck | 571347 | 00921926-2017-18 | Other Caste | Theiyar | 0.79 | Sprinkler | Nagarjuna Fertilizer & Chemicals Ltd |
| 4 | 2017-2018 | Mery | 537428 | 01530818-2017-18 | Other Caste | Magamayithirumani | 1 | Sprinkler | EPC Industries Ltd., |
| 5 | 2017-2018 | Putnik | 543199 | 01605283-2017-18 | Other Caste | Theiyar | 1 | Drip | Nagarjuna Fertilizer & Chemicals Ltd |
| 6 | 2017-2018 | Sunday | 570559 | 01606482-2017-18 | Other Caste | Pappanallur | 0.75 | Sprinkler | Nagarjuna Fertilizer & Chemicals Ltd |
| 7 | 2017-2018 | But | 953692 | 01607776-2017-18 | Other Caste | Korakottai | 1.65 | Drip | Nagarjuna Fertilizer & Chemicals Ltd |
| 8 | 2017-2018 | Kentlee | 571347 | 03371669-2017-18 | Other Caste | Theiyar | 0.81 | Drip | Nagarjuna Fertilizer & Chemicals Ltd |
| 9 | 2017-2018 | Hatsun | 46757 | 03383408-2017-18 | Other Caste | Thennathur | 0.35 | Drip | Nagarjuna Fertilizer & Chemicals Ltd |
| 10 | 2017-2018 | Agromen | 536558 | 03386639-2017-18 | Other Caste | Korakottai | 1.04 | Drip | Nagarjuna Fertilizer & Chemicals Ltd |
| 1 | 2018-2019 | James | 123456 | 21353831-2018-19 | Other Caste | Padur | 1.02 | Sprinkler | Flowtech Power |
| 2 | 2018-2019 | David | 12341 | 21515761-2018-19 | Other Caste | Pennatagaram | 1.2 | Sprinkler | Flowtech Power |
| 3 | 2018-2019 | Jery | 12412 | 21637704-2018-19 | Other Caste | Singampoondi | 0.9 | Sprinkler | Nagarjuna Fertilizer & Chemicals Ltd |
| 4 | 2018-2019 | Ken | 1412 | 21826259-2018-19 | Other Caste | Kothandapuram | 0.8 | Sprinkler | Nagarjuna Fertilizer & Chemicals Ltd |
| 5 | 2018-2019 | Mike | 12412 | 21966642-2018-19 | Other Caste | Arunthodu | 0.92 | Drip | Roots Irrigation Ltd. |
| 6 | 2018-2019 | Watson | 14214 | 22571350-2018-19 | Other Caste | Padur | 0.77 | Sprinkler | EPC Industries Ltd., |
| 7 | 2018-2019 | Ebi | 1421 | 22576376-2018-19 | Other Caste | Mazhaiyur | 0.895 | Sprinkler | EPC Industries Ltd., |
| 8 | 2018-2019 | Emy | 1241 | 22872902-2018-19 | Other Caste | Ramasamuthuram | 0.545 | Sprinkler | EPC Industries Ltd., |
| 9 | 2018-2019 | Kiya | 1421 | 23268903-2018-19 | Other Caste | Ponnur | 1.27 | Sprinkler | EPC Industries Ltd., |
<tbody>
</tbody>
I want to look up colunm by column and find text and number to arrive the following report can any one help me...
| Irrigation type | Company | Nagarjuna | EPC | Premier | Roots | Jain | Rivilus | Flowtech | Netafim | Total | |||||||||
| Application Count | Applied Area (Ha.) | Application Count | Applied Area (Ha.) | Application Count | Applied Area (Ha.) | Application Count | Applied Area (Ha.) | Application Count | Applied Area (Ha.) | Application Count | Applied Area (Ha.) | Application Count | Applied Area (Ha.) | Application Count | Applied Area (Ha.) | Application Count | Applied Area (Ha.) | ||
| Total | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |||
| Drip | Mr. Salesman A | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | ||
| Mr. Salesman B | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | |||
| Mr. Salesman C | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | |||
| Drip Total | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
| Sprinkler | Mr. Salesman A | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | ||
| Mr. Salesman B | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | |||
| Mr. Salesman C | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | |||
| Sprnkler Total | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
| Raingun | Mr. Salesman A | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | ||
| Mr. Salesman B | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | |||
| Mr. Salesman C | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | 1 | 1.00 | |||
| Raingun Total | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
<tbody>
</tbody>
Salesman A has Following villages Theiyar, Korakottai
Salesman B has Following Villages Padur Singampoondi
Salesman C has follwoing Villages Kodandapuram, Arunthodu, Ponnur
Pls help in this regard
