Generate Survey Number-Wise Correlation Statement for Village Adangal/Pahani Data

How to Use the Generate Survey Number-Wise Correlation Statement for Village Adangal/Pahani Data Tool

This tool is designed to generate correlation statement from an uploaded Excel file containing survey data, such as land records for farmers. The correlation statement is based on unique farmer identifiers and the corresponding survey numbers. Follow the steps below to use the tool effectively:

Step 1: Upload the Excel File

• Click on the “Choose File” button to upload the Excel file containing the land records.
• The file should be in .xlsx format.

Step 2: Select the Relevant Columns

• Survey Number Column (only survey number without subdivisions): Select the column in the uploaded file that contains the survey numbers. Only the main survey number (without subdivisions) should be used for correlation.

• Unique Number Column: Choose the column that contains unique identifiers for the farmer (e.g., Khata Number or a similar unique number).

• Extent Column (to sum up farmer’s extent): Select the column that contains the extent of land holdings, which will be summed up for each farmer.

• Concatenate Column (Optional): If necessary, you can choose an additional column to concatenate non-unique values, such as land details or other non-unique identifiers. This will combine values into a single entry, separated by commas.

Step 3: Define the Survey Number Range

• Enter Survey Number Range (e.g., 1-10): Provide the range of survey numbers you wish to process. For example, entering 1-10 will include all survey numbers from 1 to 10 in the statement.

Step 4: Generate the Correlation Statement

• Once all the columns are selected and the survey number range is entered, click on the “Generate Correlation Statement” button.
• The tool will process the data and generate a correlation statement table.

Step 5: Export the Results

• After the correlation statement is generated, you can export the results:
  • Export to Excel: Click the “Export to Excel” button to download the correlation statement as an Excel file.
  • Export to CSV: Click the “Export to CSV” button to download the correlation statement as a CSV file.

Important Notes:

• Make sure the survey numbers are listed in the correct format and match the range you wish to analyze.
• If no valid survey numbers are entered in the specified range, the tool will not display any data.
• Ensure that the file is structured properly with headers so that columns can be mapped correctly.