egproject

datesheetmgmt will make the complete Matrix,Seating Plan,Attendance Sheets,DutyChart for a given examination.

Prequisites

• You must have Python 2.7 installed on your pc.
• You must have installed pip.

How to install Python 2.7

Click here to see how to install Python 2.7 64 bit version:

<https://youtu.be/vNVY2usdFs4>__

Click here to see how to install pip:

<https://youtu.be/vNVY2usdFs4>__

Suitable Platform

This software is written for Python 2.7 64-bit version.

Installation

This software is intended for Windows x64 platform.

Go to the terminal and type:

| pip install datesheetmgmt

Modules Required

You will need these modules before start installing this software:

• xlsxwriter for writing to xlsx files.
• xlrd for reading from xlsx files.
• openpyxl for reading from xlsx files.
• PIL for dealing with images.
• numpy
• Tkinter for making GUI.
• pandas for reading and writing xlsx files.
• ast
• itertools
• shutil
• time
• codecs
• random
• datetime
• re

How to install MODULES

Click here to see how to install different modules:

<https://youtu.be/7KTGnMZagCI>__

INPUT FILES REQUIRED

• datesheet.xlsx file which will contain information about the date,time,course code and programme.
• Multiple studentlist.xlsx files which will contain the student list.
• roomfile.xlsx which will contain room dimensions.
• LOGO.png file which will contain university LOGO.

How to make INPUT FILES

• How to make datesheet.xlsx
• How to make studentlist.xlsx
• How to make roomfile.xlsx