How albertsolomon/project_ot works
Project Overtime records overtime details in month-specific JSON and edits an Excel workbook. The visible user workflow prompts for a month and sheet, checks the worksheet’s job description, inserts a row, and saves a month-named workbook. A separate synchronization routine reads JSON records and attempts worksheet updates. Settings select the month; rules and job-title helpers are also present. The README provides no further capability detail, and the template and output directories are not in the tree; the graph shows only relationships visible in the sampled source.
Main entry points: run.py Prompt and export · lang.py Record and data helpers · syncronize.py JSON synchronization · ot.py Worksheet operations
Components 10
Overtime records
- Record and data helpers
src/lang.py - Monthly JSON records
data/july.json
Workbook handling
- Prompt and export
src/run.py - JSON synchronization
src/syncronize.py - Worksheet operations
src/ot.py
Configuration
- Month settings
utils/settings.json - Overtime rules
utils/rules.json
Other components
- Operator
- Excel template
- Exported workbook
Connections 11
- Operator → Prompt and export: enters details
src/run.py - Prompt and export → Record and data helpers: imports helpers
src/run.py - Prompt and export → Worksheet operations: checks and inserts
src/run.py - Prompt and export → Excel template: loads template
src/run.py - Prompt and export → Exported workbook: saves workbook
src/run.py - JSON synchronization → Record and data helpers: reads records
src/syncronize.py - JSON synchronization → Worksheet operations: checks and inserts
src/syncronize.py - JSON synchronization → Excel template: loads template
src/syncronize.py - Record and data helpers → Monthly JSON records: writes records
src/lang.py - Record and data helpers → Month settings: reads month
src/lang.py - Record and data helpers → Overtime rules: reads and updates
src/lang.py