converting a report to excel

srinivasan1129

New Member
Joined
Apr 20, 2011
Messages
13
Sir,

I am really trying to hard to covert the report to excel. I got year wise 25 files for one village. similary i got 10 villages of the same kind.

i need to convert the attached report to excel. I changed the font to lucida console font size to 11. But still, as the report has many colunms as we go down i could not seperate it using text to clounms.

Could anyone have solution for this????


report as follows

Page No : 1
GOVERNMENT OF TAMILNADU
DEPARTMENT OF ECONOMICS & STATISTICS
VILLAGE - G RETURN
****************
Fasli : 1415 Year : 2005-2006
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village :NAICKENPALAYAM
FORM 1 / PART - I
General Details (as per A Register)
==========================================================================================
SlNo. Land Classification Area in Hec
==========================================================================================
1 Nansai 2.340
2 Punsai 905.580
3 Poramboke - Assessed Waste
-Nansai 0.120
-Punsai 5.135
Poramboke - Unassessed Waste
-Nansai
-Punsai 0.470
4 Forest
5 Grazing Land
6 Others 69.250
.....................................................................................
Total Geographical Area 982.895
.....................................................................................
==========================================================================================


ii. Crop Area Details
==========================================================================================
Current Fasli Last Fasli
------------------------------
As per Adangal Goshpara Irrigated Unirrigated Total Area
==========================================================================================
1 Total Area Cultivated under all crops 180.540 144.880 325.420 7115.000
2 Area cultivated under 1st Crop 180.540 144.880 325.420 7094.000
3 Area Cultivated more than once 0.000 0.000 0.000 21.000
==========================================================================================

Page No : 2
PART 2
Nine Fold Classification
==========================================================================================
AREA
---------------------
Sl.No Land Classification Current LastYear Diff. Perc.
==========================================================================================
a Forest 16505.000 -16505.000 -100.00
b Uncultivable Waste 78.860 1489.000 -1410.140 -94.70
c Non Agri Uses
-Building 55.630 3298.000 -3242.370 -98.31
-Roads 11.835 469.000 -457.165 -97.48
-Railway Lines 101.000 -101.000 -100.00
-Rivers
-Canals 34.395 471.000 -436.605 -92.70
-Check Dams 5.350 483.000 -477.650 -98.89
-Swamp Area
-Social Forest 1.000 -1.000 -100.00
-Others 95.765 3441.000 -3345.235 -97.22
________________________________________________
-Total 202.975 8264.000 -8061.025 -97.54
________________________________________________
d Cultivable Waste Land 303.000 -303.000 -100.00
e Permanent Pasture & Grass Land 173.000 -173.000 -100.00
f Misc. Tree Crops & Groves 19.870 618.000 -598.130 -96.78
g Current Fallow 302.540 1672.000 -1369.460 -81.91
h Other Fallow 53.230 3419.000 -3365.770 -98.44
i Net Cultivated Area 325.420 7094.000 -6768.580 -95.41
.....................................................................................
Total 982.895 39537.000 -38554.105 -97.51
.....................................................................................
==========================================================================================

Page No : 3
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
1 Paddy
-Kar /Kuruvai/Sornavari (High)
-Kar /Kuruvai/Sornavari (Local)
-Samba / Thaladi /Pisanam (High) 7.000 -7 -100
-Samba / Thaladi /Pisanam (Local)
-Navarai /kodai ( High)
-Navarai /kodai ( Local)
____________________________________________________________________
-Total - Paddy 7.000 -7 -100
____________________________________________________________________
2 Wheat
-Kharif ( High)
-Kharif ( Local)
-Rabi ( High)
-Rabi ( Local)
____________________________________________________________________
-Total - Wheat
____________________________________________________________________
3 Cholam
-Kharif ( High) 65.825 65.825 1952.000 -1886 -97
-Kharif ( Local)
-Rabi ( High) 1102.000 -1102 -100
-Rabi ( Local)
____________________________________________________________________
-Total - Cholam 65.825 65.825 3054.000 -2988 -98
____________________________________________________________________
4 Cumbu
-Kharif (High) 2.000 -2 -100
-Kharif (Local)
-Rabi (High)
-Rabi (Local)
____________________________________________________________________
-Total - Cumbu 2.000 -2 -100
____________________________________________________________________
5 Ragi
-Kharif ( High) 5.650 5.650 12.000 -6 -53
-Kharif ( Local)
-Rabi ( High) 29.000 -29 -100
-Rabi ( Local)
____________________________________________________________________
-Total - Ragi 5.650 5.650 41.000 -35 -86
____________________________________________________________________
6 Maize
-Kharif ( High) 2.500 2.500 69.000 -67 -96
-Kharif ( Local)
-Rabi ( High) 62.000 -62 -100
==============================================================================================================

Page No : 4
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Rabi ( Local)
____________________________________________________________________
-Total - Maize 2.500 2.500 131.000 -129 -98
____________________________________________________________________
7 Thinai
-Kharif ( High)
-Kharif ( Local) 1.000 -1 -100
-Rabi ( High)
-Rabi ( Local)
____________________________________________________________________
-Total - Thinai 1.000 -1 -100
____________________________________________________________________
8 Varagu
-Kharif ( High)
-Kharif ( Local)
-Rabi ( High)
-Rabi ( Local)
____________________________________________________________________
-Total - Varagu
____________________________________________________________________
9 Samai
-Kharif ( High)
-Kharif ( Local) 1.000 -1 -100
-Rabi ( High)
-Rabi(Local)
____________________________________________________________________
-Total - Samai 1.000 -1 -100
____________________________________________________________________
10 Kudiraivali
-Kharif ( High)
-Kharif ( Local)
-Rabi ( High)
-Rabi ( Local)
____________________________________________________________________
-Total - Kudiraivali
____________________________________________________________________
11 Pani Varagu
-Kharif ( High)
-Kharif ( Local)
-Rabi ( High)
-Rabi ( Local)
____________________________________________________________________
-Total - Pani Varagu
____________________________________________________________________
.........................................................................................................
Total - Cereals 2.500 71.475 73.975 3237.000 -3163 -98
.........................................................................................................
1 Bengal Gram
-Kharif
-Rabi 68.000 -68 -100
____________________________________________________________________
-Total 68.000 -68 -100
____________________________________________________________________
==============================================================================================================

Page No : 5
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
2 Red Gram
-Kharif 9.000 -9 -100
-Rabi 7.000 -7 -100
____________________________________________________________________
-Total 16.000 -16 -100
____________________________________________________________________
3 Black Gram
-Kharif 0.700 0.700 21.000 -20 -97
-Rabi 6.000 -6 -100
____________________________________________________________________
-Total 0.700 0.700 27.000 -26 -97
____________________________________________________________________
4 Green Gram
-Kharif 1.900 1.900 28.000 -26 -93
-Rabi 23.000 -23 -100
____________________________________________________________________
-Total 1.900 1.900 51.000 -49 -96
____________________________________________________________________
5 Horse Gram
-Kharif 1.000 1.000 9.000 -8 -89
-Rabi 39.000 -39 -100
____________________________________________________________________
-Total 1.000 1.000 48.000 -47 -98
____________________________________________________________________
6 Mochai
-Kharif
-Rabi
____________________________________________________________________
-Total
____________________________________________________________________
7 Cow Pea
-Kharif 5.000 5.000 66.000 -61 -92
-Rabi 60.000 -60 -100
____________________________________________________________________
-Total 5.000 5.000 126.000 -121 -96
____________________________________________________________________
8 Avarai
-Kharif 55.290 55.290 70.000 -15 -21
-Rabi 98.000 -98 -100
____________________________________________________________________
-Total 55.290 55.290 168.000 -113 -67
____________________________________________________________________
9 Nari Payiru
-Kharif
-Rabi
____________________________________________________________________
-Total
____________________________________________________________________
10 Kal Payiru
-Kharif
-Rabi
____________________________________________________________________
-Total
____________________________________________________________________
11 Peas
-Kharif
-Rabi
____________________________________________________________________
-Total
____________________________________________________________________
.........................................................................................................
Total - Pulses 63.890 63.890 504.000 -440 -87
.........................................................................................................
==============================================================================================================

Page No : 6
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
1 Spices & Condiments
-Arecanut 5.230 5.230 59.000 -54 -91
-Cardamom
-Chillies 12.000 -12 -100
-Garlic
-Ginger
-Pepper
-Nutmeg 0.100 0.100
-Cloves & Cinnamon
-Fennel ( Peruncheeragam)
-Dill ( Vendhayam)
-Curry Leaves 1.600 1.600 82.000 -80 -98
-Mint
-Coriander 0.400 0.400 6.000 -6 -93
-Turmeric 9.300 9.300 55.000 -46 -83
-Tamarind 5.300 5.300 22.000 -17 -76
-Mustard
.........................................................................................................
Total - Spices & Condiments 16.630 5.300 21.930 236.000 -214 -91
.........................................................................................................
1 Sugar Crops
-Planted 9.880 9.880 188.000 -178 -95
-Ratoon 137.000 -137 -100
____________________________________________________________________
-Total 9.880 9.880 325.000 -315 -97
____________________________________________________________________
2 Palmyrah 1.000 -1 -100
.........................................................................................................
Total - Sugar Crops 9.880 9.880 326.000 -316 -97
.........................................................................................................
1 Fresh Fruits
-Banana 14.845 14.845 425.000 -410 -97
-Mango 6.415 6.415 58.000 -52 -89
-Jack Fruit 1.000 -1 -100
-Pine Apple
-Guava 2.165 2.165 14.000 -12 -85
-Grapes 13.000 -13 -100
-Pear (Sappota) 0.855 0.855 6.000 -5 -86
-Papaya 0.200 0.200 6.000 -6 -97
==============================================================================================================

Page No : 7
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Pomegranate 0.005 0.005 5.000 -5 -100
-Apple
-Plums
-Water Melon
-Musk Melon
-Naval
-Seetha 0.300 0.300 1.000 -1 -70
-Athi
-Berikai
-Mangusthan
-Vilambazham
-Elandhai
-Peach
-Strawberry
-Remton
-Kamala
.........................................................................................................
Total - Fresh Fruits 22.620 2.165 24.785 529.000 -504 -95
.........................................................................................................
1 Citrus Fruits
-Orange 0.050 0.050 1.000 -1 -95
-Lemon 0.005 0.005 3.000 -3 -100
-Lichi ( Kichili)
-Santra ( Sathukudi) 0.100 0.100
-Amla (Nelli) 1.005 1.005 7.000 -6 -86
-Narthai
-Bublimas
-Kolumichai
-Kozhinji
.........................................................................................................
Total - Citrus Fruits 0.155 1.005 1.160 11.000 -10 -89
.........................................................................................................
1 Dry Fruits
-Cashew Nut 2.000 -2 -100
.........................................................................................................
Total - Fruits 22.775 3.170 25.945 542.000 -516 -95
.........................................................................................................
1 Vegetables
-Potato - Kharif
==============================================================================================================

Page No : 8
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Potato -Rabi
____________________________________________________________________
-Potato -Total
____________________________________________________________________
-Tapioca 0.400 0.400 25.000 -25 -98
-Sweet Potato
-Yam
-Carrot
-Beet Root 1.000 -1 -100
-Karunai
-Colacassia ( Chepankizhangu)
-Onion - Kharif 0.300 0.300 4.000 -4 -93
-Onion - Rabi
____________________________________________________________________
-Onion - Total 0.300 0.300 4.000 -4 -93
____________________________________________________________________
-Brinjal 0.300 0.300 40.000 -40 -99
-Ladies Finger 3.540 3.540 30.000 -26 -88
-Lablab
-Cabbage
-Tomato 4.000 4.000 47.000 -43 -91
-Pumpkin 0.400 0.400 21.000 -21 -98
-Snake Guord 7.000 -7 -100
-Ribbed Gourd 1.000 -1 -100
-Bottle Gourd
-Biiter Gourd 8.000 -8 -100
-Ash Gourd 7.000 -7 -100
-Cucumber 4.000 -4 -100
-Beans
-Karamani
-Drum Stick 0.420 0.420 4.000 -4 -90
-Cauli Flower 1.000 -1 -100
-Raddish 2.000 -2 -100
-Greens - Mulai Keerai 2.000 -2 -100
==============================================================================================================

Page No : 9
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Kothavarai 3.000 -3 -100
-Kovakai
-Noolkol
-Greens- Agathi Keerai
-Seeni Avarai
-Athalaikai
-Mushroom
-Green Peas
-Glykose
-Chow Chow
-Siru Kizhangu
.........................................................................................................
Total - Vegetables 8.940 0.420 9.360 207.000 -198 -95
.........................................................................................................
1 Cotton - Kharif
-RCH 2
-RCH 32
-RCH PT
-MCU 7
-MCU 4
-MCU 5 ( ilavam) 1.700 1.700 4.000 -2 -58
-MCU 8
-DCH 32
-LRA 5166
-ICA 21
-MCS
-BTC
-SVPR 2
-K 11
-Karunganni - K6
-Karunganni - Ordinary
-Suvin
-Uppam
==============================================================================================================

Page No : 10
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Lakshmi
-Varalakshmi
-B. T. Cotton
-Sujatha
-Bramma
-Rajath
-Supria
____________________________________________________________________
-Total 1.700 1.700 4.000 -2 -58
____________________________________________________________________
1 Cotton - Rabi
-RCH 2
-RCH 32
-RCH PT
-MCU 7
-MCU 4
-MCU 5 ( ilavam) 38.000 -38 -100
-MCU 8
-DCH 32
-LRA 5166
-ICA 21
-MCS
-BTC
-SVPR 2
-K 11
-Karunganni - K6
-Karunganni - Ordinary
-Suvin
-Uppam
-Lakshmi
-Varalakshmi
-B. T. Cotton
-Sujatha
==============================================================================================================

Page No : 11
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Bramma
-Rajath
-Supria
____________________________________________________________________
-Total 38.000 -38 -100
____________________________________________________________________
.........................................................................................................
Total - Cotton 1.700 1.700 42.000 -40 -96
.........................................................................................................
2 Jute (Bengal Karkora Variety)
3 Mesta
4 Sunhemp
-Fibre
-Seed
____________________________________________________________________
-Total
____________________________________________________________________
.........................................................................................................
Total - Non Food Crops 1.700 1.700 42.000 -40 -96
.........................................................................................................
1 Ground Nut
-Kharif 17.000 -17 -100
-Rabi
____________________________________________________________________
-Total 17.000 -17 -100
____________________________________________________________________
2 Gingelly
-Kharif 11.000 -11 -100
-Rabi
____________________________________________________________________
-Total 11.000 -11 -100
____________________________________________________________________
3 Coconut 117.385 117.385 1650.000 -1533 -93
4 Soya Beans
5 Mustard
6 Sun Flower
-Kharif 3.000 -3 -100
-Rabi
____________________________________________________________________
-Total 3.000 -3 -100
____________________________________________________________________
7 Palm Oil
8 Puskani
.........................................................................................................
Total - Food Oil Crops 117.385 117.385 1681.000 -1564 -93
.........................................................................................................
1 Castor 15.000 -15 -100
2 Jatropha 46.000 -46 -100
3 Olive Seed
4 Niger Seed
==============================================================================================================

Page No : 12
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
5 Neem 0.120 0.120 10.000 -10 -99
6 Elluppai
7 Uchen
8 Punnai
.........................................................................................................
Total - Non Food Oil Crops 0.120 0.120 71.000 -71 -100
.........................................................................................................
.........................................................................................................
Total - Oil Seed Crops - 117.385 0.120 117.505 1752.000 -1634 -93
.........................................................................................................
1 Dye Crops
-Avuri
-Anoda
-Nilavagai
.........................................................................................................
Dye - Total
.........................................................................................................
1 Medicinial Crops
-Tobacco
-Coffee 0.130 0.130 1.000 -1 -87
-Tea
-India Jute
-Abini
-Koina
-Betal Wine 2.000 -2 -100
-Chenna
-Nithya Kalyani 1.000 -1 -100
-Samanthi (Medicinal)
-Kandangkathri
-Palm Rose
-Cocoa 0.200 0.200 1.000 -1 -80
-Vanila Beans 1.000 -1 -100
-Thulasi
-Acorus ( Vasambu)
-Colius
-Omam
-Musili
-Soliyasis
==============================================================================================================

Page No : 13
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Black Thulasi
-Sweet Thulasi
-Rosemary
-Katrazhai
-Konnoli Poo
-Medicinal Grass
-Mozhi kizhangu
-Surkuppai
-Visa Vellari
-Kanvazhi Kizhangu
-Senduppul
-Vaasanaipul
-Sandol
-Manjiyam
-Maasuka
-Gwalior
-Thailaapul
-Salvetra
-Geegeeba
-Chitydora
-Gerenium
Vagai
.........................................................................................................
Total - Medicinal Crops 0.330 0.330 6.000 -6 -95
.........................................................................................................
1 Fodder
-Cholam
-Elephant Grass 45.000 -45 -100
-Suba Grass 13.000 -13 -100
-Giniya Grass 0.230 0.230
-Korai Grass
-Minni
-Feeder Grass
==============================================================================================================

Page No : 14
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Kudhirai Masaal 20.000 -20 -100
-Naripayir
-Sinai pul
.........................................................................................................
Total - Fodder Crops 0.230 0.230 78.000 -78 -100
.........................................................................................................
1 Green Manure Crops
-Sunhemp 1.000 -1 -100
-Pillipayiru
-Kulanji
-Indigo
-Denja
-Degabagera
-Susbenia
-Thakkai Poondu
-Sivundal
-Kollu
-Thakka
-Kulamarum
-Netti
.........................................................................................................
Total - Manure Crops 1.000 -1 -100
.........................................................................................................
1 Flowers
-Rose 17.000 -17 -100
-Jasmine 0.400 0.400 66.000 -66 -99
-Mullai 0.100 0.100 21.000 -21 -100
-Jadhi Malli 9.000 -9 -100
-Crossadra 3.000 -3 -100
-Samanthi 6.000 -6 -100
-Sevanthi 6.000 -6 -100
-Arali 1.000 -1 -100
-Kozhi Kondai 6.000 -6 -100
-Sendu Malli 3.000 -3 -100
-Mary Gold
-Anthoorium
==============================================================================================================

Page No : 15
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Champangi 17.000 -17 -100
-Kakada
-Sendu Malli
-Vaadaa Malli
-Alli
-Deliba
-Chembaruthi
-Kaanthal
-Pichi
-Kethi
-Marugu
-Crotons
-Senbagam 3.000 -3 -100
-Thazhambu
-Chinthamani
Lotus
Thulasi
.........................................................................................................
Total - Flowers 0.500 0.500 158.000 -158 -100
.........................................................................................................
1 Misc Non Food Crops
-Ucalyptus
-Casuarina
-Bamboo
-Teak Wood
-Babol
-Mongium
-Semmaram
-Poovarasu
-Thothakathi
-Ayini
-Alpesia
-Seemai Karuvel
==============================================================================================================

Page No : 16
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Semmanchedi
-Vaasaaka
-Kadambu
-Udai
-Pungam
-Pean
-Silver Oak
-Maanji
-Venvel
-Veli Karuvai
-Masa Vembu
-Karuvel
-Vembu
-Orcha
____________________________________________________________________
-Total - Grove Varieties
____________________________________________________________________
-Rubber
-Lemon Grass
-Mulberry 12.000 -12 -100
-Korai
-Elavan / Ulagu 0.175 0.175 14.000 -14 -99
-Theekuchi
-Kadukkai
-Eetti
-Kaimaruba Sinaakka
-Sivandal
-Kunguliyum
-Vadachi
-Aalam
-Oosi ilai
-Sorkam
==============================================================================================================

Page No : 17
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================
-Palmarosa
Batham
Vagai
Sandal
Kondrai
Illupai
____________________________________________________________________
-Total - Other Varieties 0.175 0.175 26.000 -26 -99
____________________________________________________________________
.........................................................................................................
Total - Misc Non Food Crops 0.175 0.175 26.000 -26 -99
.........................................................................................................
==============================================================================================================

Page No : 18
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 3
CROP WISE AREA DETAILS
==============================================================================================================
Current Fasli
-------------
Sl.No Crop Details Irrigated Unirrigated Total Last Fasli Diff. Perc.
==============================================================================================================

CONSOLIDATION REPORT

1 Total of Non - Food Crops 119.815 0.625 120.440 2063.000 -1943 -94
2 Total of Food Crops 60.725 144.255 204.980 5052.000 -4847 -96
3 Total of Food and Non-Food Crops 180.540 144.880 325.420 7115.000 -6790 -95
4 Net Area Cultivated 180.540 144.880 325.420 7094.000 -6769 -95
5 Area Cultivated more than once 0.000 0.000 0.000 21.000 -6790 -32331
==============================================================================================================

Page No : 19
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village Name :NAICKENPALAYAM
PART 4
SOURCE WISE IRRIGATION DETAILS
======================================================================================================================
Current Fasli
------------------------------------------------------------------------------
Nansai Punsai Govt Poramboke Total
SNo Irrigation Source Gross Net Gross Net Gross Net Gross Net
======================================================================================================================
1 Canals
-Govt
-Private
__________________________________________________________________________________
-Total
__________________________________________________________________________________
2 Ponds / Tank
-Govt
-Private
__________________________________________________________________________________
-Total
__________________________________________________________________________________
3 Tube Well / Bore Well
-Govt
( incl. all types of Tube Wells)
-Private 51.57 51.57 51.57 51.57
__________________________________________________________________________________
-Total 51.57 51.57 51.57 51.57
__________________________________________________________________________________
4 Open Well
-Govt
-Private 0.83 0.83 128.14 128.14 128.97 128.97
__________________________________________________________________________________
-Total 0.83 0.83 128.14 128.14 128.97 128.97
__________________________________________________________________________________
.................................................................................................................
Total (Tube+Open Well) 0.83 0.83 179.71 179.71 180.54 180.54
.................................................................................................................
5 Suppl. Irrigation Wells
-Govt
-Private
__________________________________________________________________________________
-Total
__________________________________________________________________________________
6 Other Irrigation Sources
-Govt
-Private
__________________________________________________________________________________
-Total
__________________________________________________________________________________
.................................................................................................................
Total (excl Suppl Wells) 0.83 0.83 179.71 179.71 180.54 180.54
.................................................................................................................
======================================================================================================================

Page No : 20
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village :NAICKENPALAYAM
PART 5
NUMBER OF IRRIGATING WELLS
===========================================================================================================================
Among Good Condition
--------------------
As in Dug in In Good Irrigating Suppl.
Sno Types of Well Last Fasli Curr. Fasli Total Not in use Condition Wells Wells
===========================================================================================================================
1 Tube Wells
-Govt
-Private 62 0 62 0 62 62 0
____________________________________________________________________________________
-Total 62 0 62 0 62 62 0
____________________________________________________________________________________
2 Bore Wells
-Govt
-Private
____________________________________________________________________________________
-Total
____________________________________________________________________________________
3a Dug Bore Wells (Masonry)
-Govt
-Pvt 28 0 28 0 28 28 0
____________________________________________________________________________________
-Total 28 0 28 0 28 28 0
____________________________________________________________________________________
3b Dug Bore Wells (Non Masonry)
-Govt
-Pvt
____________________________________________________________________________________
-Total
____________________________________________________________________________________
......................................................................................................................
Total ( 3a+3b) 28 0 28 0 28 28 0
......................................................................................................................
4 Filter Point Wells
-Govt
-Pvt
____________________________________________________________________________________
-Total
____________________________________________________________________________________
5 Artesian Wells
-Govt
-Pvt
____________________________________________________________________________________
-Total
____________________________________________________________________________________
6a Dugged Open Wells(Masonry)
-Govt
-Pvt 102 0 102 0 102 102 0
____________________________________________________________________________________
-Total 102 0 102 0 102 102 0
____________________________________________________________________________________
6b Dugged Open Wells(Non Masonry)
-Govt
-Pvt 77 0 77 0 77 77 0
____________________________________________________________________________________
-Total 77 0 77 0 77 77 0
____________________________________________________________________________________
......................................................................................................................
Total ( 6a + 6b) 179 0 179 0 179 179 0
......................................................................................................................
......................................................................................................................
Total 269 0 269 0 269 269 0
......................................................................................................................
===========================================================================================================================

Page No : 21
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village :NAICKENPALAYAM
PART 6
NUMBER OF CANALS, KANMAI AND TANKS
==========================================================================================
As in Dug in
Sno Irrigation Source Last Fasli Curr. Fasli Total
==========================================================================================
1 Canals
-Govt- No.
-Govt-Length(Km)
-Pvt-No
-Pvt-Length(Km)
________________________________________________
-Total ( Nos.)
________________________________________________
2 Kanmai / Tanks/Ponds(Ayacut)
-> 40 Hec. - Govt
-> 40 Hec. - Pvt
-< 40 Hec. - Govt
-< 40 Hec. - Pvt
________________________________________________
-Total
________________________________________________
3 Water Bodies
==========================================================================================

Page No : 22
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village :NAICKENPALAYAM
PART 7
NUMBER OF WELLS USED IN HOUSEHOLDS & INDUSTRIES
====================================================================================================================================
As in Dug in Not In Good Elec. Diesel Cattle Man
Sno Types of Well Last Fasli Curr. Fasli Total in use Condition Pumpsets Pumpsets Powered Power Others Total
====================================================================================================================================
1 House Hold Usage
-Tube Wells 13 0 13 0 13 10 0 0 3 0 13
-Bore Wells
-Dug Bore Wells
-Filter Point Wells
-Artesian Wells
-Dug Open Wells 12 0 12 0 12 5 0 0 7 0 12
________________________________________________________________________________________________________
-Total 25 0 25 0 25 15 0 0 10 0 25
________________________________________________________________________________________________________
2 Industrial Usage
-Tube Wells
-Bore Wells
-Dug Bore Wells
-Filter Point Wells
-Artesian Wells
-Dug Open Wells
________________________________________________________________________________________________________
-Total
________________________________________________________________________________________________________
====================================================================================================================================

Page No : 23
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village :NAICKENPALAYAM
PART 8
MODE OF PUMPING FROM WELLS USED IN IRRIGATION
INDEPENDENT AYACUT WELLS
=======================================================================================================================
Irrigated Area Mode of Pumping
-------------- --------------------------------------------------

Elec. Diesel Cattle Man Wells Not Total
Sno Types of Well Gross Net Pumpsets Pumpsets Powered Power Others in Use Wells
=======================================================================================================================
1 Tube Wells
-Govt
-Private 51.570 51.570 62 0 0 0 0 0 62
___________________________________________________________________________________________
-Total 51.570 51.570 62 0 0 0 0 0 62
___________________________________________________________________________________________
2 Bore Wells
-Govt
-Private
___________________________________________________________________________________________
-Total
___________________________________________________________________________________________
3 Dug Bore Wells
-Govt
-Private 8.000 8.000 28 0 0 0 0 0 28
___________________________________________________________________________________________
-Total 8.000 8.000 28 0 0 0 0 0 28
___________________________________________________________________________________________
4 Filter Point Wells
-Govt
-Private
___________________________________________________________________________________________
-Total
___________________________________________________________________________________________
5 Artesian Wells
-Govt
-Private
___________________________________________________________________________________________
-Total
___________________________________________________________________________________________
..................................................................................................................
Total ( 1 to 5 ) 59.570 59.570 90 0 0 0 0 0 90
..................................................................................................................
6 Dug Open Wells
-Govt
-Private 120.970 120.970 179 0 0 0 0 0 179
___________________________________________________________________________________________
-Total 120.970 120.970 179 0 0 0 0 0 179
___________________________________________________________________________________________
..................................................................................................................
Total ( 1 to 6 ) 180.540 180.540 269 0 0 0 0 0 269
..................................................................................................................
=======================================================================================================================

Page No : 24
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village :NAICKENPALAYAM
PART 8
MODE OF PUMPING FROM WELLS USED IN IRRIGATION
INDEPENDENT AYACUT WELLS
========================================================================================================================
Irrigated Area Mode of Pumping
-------------- --------------------------------------------------

Elec. Diesel Cattle Man Wells Not Total
Sno Types of Well Gross Net Pumpsets Pumpsets Powered Power Others in Use Wells
========================================================================================================================
1 Tube Wells
-Govt
-Private 51.570 0.000 0 0 0 0 0 0 0
___________________________________________________________________________________________
-Total 51.570 0.000 0 0 0 0 0 0 0
___________________________________________________________________________________________
2 Bore Wells
-Govt
-Private
___________________________________________________________________________________________
-Total
___________________________________________________________________________________________
3 Dug Bore Wells
-Govt
-Private 8.000 0.000 0 0 0 0 0 0 0
___________________________________________________________________________________________
-Total 8.000 0.000 0 0 0 0 0 0 0
___________________________________________________________________________________________
4 Filter Point Wells
-Govt
-Private
___________________________________________________________________________________________
-Total
___________________________________________________________________________________________
5 Artesian Wells
-Govt
-Private
___________________________________________________________________________________________
-Total
___________________________________________________________________________________________
..................................................................................................................
Total ( 1 to 5 ) 59.570 0.000 0 0 0 0 0 0 0
..................................................................................................................
6 Dug Open Wells
-Govt
-Private 120.970 0.000 0 0 0 0 0 0 0
___________________________________________________________________________________________
-Total 120.970 0.000 0 0 0 0 0 0 0
___________________________________________________________________________________________
..................................................................................................................
Total ( 1 to 6 ) 180.540 0.000 0 0 0 0 0 0 0
..................................................................................................................
========================================================================================================================

Page No : 25
District : COIMBATORE Block : PERIYANAICKENPALAYAM
Village :NAICKENPALAYAM
PART 9
AREA WISE IRRIGATION DETAILS - ANNEXURE 2 D
==========================================================================================================================
Area Irrigated in Current Fasli
------------------------------------------------------------
Number Area Nansai Punsai Poramboke Total
SNo Irrigation Source Gross Net Gross Net Gross Net Gross Net Gross Net Gross Net
==========================================================================================================================
1a River Irrigation Project
-River / River Canals
-Irrigated by Dams
-Kanmai to Canals
____________________________________________________________________________________________
-Total
____________________________________________________________________________________________
1b River Irrigation Project
-River / River Canals
-Irrigated by Dams
-Kanmai to Canals
____________________________________________________________________________________________
-Total
____________________________________________________________________________________________
.....................................................................................................................
Total (River Irrigation )
.....................................................................................................................
2a Kanmai(Ayacut)- >40 Hec.
-Govt
-Pvt
____________________________________________________________________________________________
-Total
____________________________________________________________________________________________
2b Kanmai(Ayacut)- <40 Hec.
-Govt
-Pvt
____________________________________________________________________________________________
-Total
____________________________________________________________________________________________
.....................................................................................................................
Total ( Kanmai )
.....................................................................................................................
3 Other Irrigation Sources
==========================================================================================================================
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
in all honesty, I'm not sure that this can be imported into excel beyond the simple line by line, to make it useful, I would have to say I think it is a case of knowing the subject well, creating a series of meaningful headers, so that in the future it is possible to evaluate the contained data. You could have a workbook for each district, and sheets for each village. The key words will make it harder to understand. As a report, simply printed out and in hand is probably more useful as a reference
 
Upvote 0

Forum statistics

Threads
1,214,840
Messages
6,121,895
Members
449,058
Latest member
Guy Boot

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top