Swap Numerator/Denominator in Dashboard
Budget: ₹600 – ₹1,500 INR
I’ve built a small PHP-based dashboard with a drag-and-drop builder that ingests an uploaded Excel file, parses the data, and shows a numeric progress report in a standard table. Three columns are calculated on upload; in the 2nd and 3rd columns I accidentally coded the division the wrong way around, so each cell is currently denominator ÷ numerator.
The task is simple: open the existing PHP processing script (it relies on PhpSpreadsheet for the import) and swap the operands so the result becomes numerator ÷ denominator in both affected columns. Nothing else in the file structure or layout should change—the table must still render exactly as it does now and continue updating automatically whenever a new Excel sheet is uploaded.
Acceptance criteria
• Column 2 and Column 3 values show the corrected division on page reload.
• Uploading a fresh Excel file reproduces the correct result without manual fixes.
• No regression in the other column or overall dashboard styling.
The task is simple: open the existing PHP processing script (it relies on PhpSpreadsheet for the import) and swap the operands so the result becomes numerator ÷ denominator in both affected columns. Nothing else in the file structure or layout should change—the table must still render exactly as it does now and continue updating automatically whenever a new Excel sheet is uploaded.
Acceptance criteria
• Column 2 and Column 3 values show the corrected division on page reload.
• Uploading a fresh Excel file reproduces the correct result without manual fixes.
• No regression in the other column or overall dashboard styling.