Excelp

A software to automate some of the tasks "not" already included in Microsoft Excel. This can be used by teachers teaching finance (to check the solution sheets of students on-the-go), by researchers (to cumulate the data collected from different sources into one sheet), by Data Scientists (to create 3D Pie-Charts for better visualisation of data).

Installations

sudo -H pip install openpyxl

Results

For Automatic Invigilation

Checking if two excel sheets are same or not - Can be used by teachers to match answer script with the solution sheets of different students. The output as shown in picture will show which cells are different and in which sheets exactly. The output will also tell if the student has given incomplete assignment (less number of sheets or less number of entries).

• The Original Excel sheet (orig)

• The Excel sheet to compare (comp)

• The Final result (terminal-window)

For Easy Compilation of Independently Collected Datasets

If data had been collected by independent researchers (all stored in different excel sheets). Microsoft Excel supports merging different different Excel files to different sheets in same Excel file. This function enables cummulating data from different sheets into the main (first) sheet.

• The Sheet1 of Excel file (main sheet)

• The Sheet2 of Excel file (to-be-merged sheet)

• The Final Merged Excel file (main sheet)

For 3-D Visualisation of Data

To allow better data visualisation, the user may use the software to create 3D Pie-charts.

• The Final Excel file (after appending the created Pie-chart to the end of data)

Contributor

• Pranav Dixit - Github - Linkedin