How subhrajit-mandal/top-sheet-automation works
This is a single-script application for preparing class top sheets from an Excel marks workbook. Its principal workflow reads student records, then either generates sheets from a template or completes student-submitted sheets, distributing marks by the template’s question sections and producing documents, PDFs, and a report. The README documents the major capabilities; the source excerpt is partial, so internal call ownership cannot be verified and the graph groups responsibilities implemented in the same script rather than implying separate modules.
Main entry points: generate_top_sheets.py Generate sheets · config.json Exam configuration
Components 19
Inputs and rules
- Marks workbook
- Word template
- Submitted sheets
- Exam configuration
config.json - Run settings
generate_top_sheets.py
Sheet processing
- Student records
generate_top_sheets.py - Input validation
generate_top_sheets.py - Run mode
generate_top_sheets.py - Question sections
generate_top_sheets.py - Question marks
generate_top_sheets.py - Generate sheets
generate_top_sheets.py - Complete submissions
generate_top_sheets.py - Typed signature
generate_top_sheets.py - Official seal
generate_top_sheets.py
Outputs and integrations
- Completed DOCX
generate_top_sheets.py - PDF export
generate_top_sheets.py - Word or LibreOffice
- Run report CSV
generate_top_sheets.py
Other components
- Operator
Connections 26
- Operator → Marks workbook: selects
README.md - Operator → Word template: selects
README.md - Operator → Submitted sheets: selects
README.md - Operator → Run settings: sets values
README.md - Marks workbook → Student records: reads records
README.md - Student records → Input validation: validates
README.md - Exam configuration → Input validation: defines rules
README.md - Operator → Run mode: chooses mode
README.md - Word template → Question sections: provides rows
README.md - Question sections → Question marks: sets constraints
README.md - Student records → Question marks: supplies totals
README.md - Student records → Generate sheets: supplies details
README.md - Word template → Generate sheets: provides layout
README.md - Question marks → Generate sheets: provides marks
README.md - Student records → Complete submissions: matches rolls
README.md - Submitted sheets → Complete submissions: provides sheets
README.md - Question marks → Complete submissions: provides marks
README.md - Generate sheets → Typed signature: adds signature
README.md - Generate sheets → Completed DOCX: produces
README.md - Complete submissions → Completed DOCX: saves
README.md - Operator → Official seal: selects optionally
README.md - Official seal → Completed DOCX: stamps optionally
README.md - Completed DOCX → PDF export: exports
README.md - PDF export → Word or LibreOffice: uses
README.md - Complete submissions → Run report CSV: records statuses
README.md - Generate sheets → Run report CSV: records results
README.md