Advanced Excel Data Processing Tool Development
Budget: ₹750 – ₹1,250 INR
Project Overview
We require an advanced Excel expert to build a survey data processing tool that:
Accepts bulk inputs for mixed question types (single/multi-select, rating scales).
Generates an auto-updating dashboard with visualizations (bar charts) and detailed tables.
Produces professional PDF reports.
Delivers zero-compromise quality (error-proof formulas, intuitive UI, print-perfect outputs).
Reference Survey: [Provided PDF] with 7 questions (confidence comparisons, effectiveness ratings, class types).
Core Requirements & Deliverables
1. Input System (Must-Have)
Bulk Response Entry:
Grid-based templates for each question type (e.g., numeric input for option counts like "CPR Class: 25 responses").
Data validation (number-only cells, dropdowns for ratings).
Support for:
Single-select (Q1, Q6, Q7).
Multi-select (Q2, Q3).
5-point scales (Q4, Q5).
2. Dashboard Engine (Critical)
Visualizations:
Dynamic bar charts for:
Confidence shift (side-by-side comparison of Q2 vs. Q3).
Training/instructor effectiveness (Q4, Q5).
Class type distribution (Q1).
Color-coded and labeled for immediate insights.
Summary Tables:
Response counts + auto-calculated percentages (e.g., "Very Confident: 15 (30%)").
Pre/post training analytics (Q2 vs. Q3).
3. Reporting Module (Non-Negotiable)
One-click PDF export with:
Print-optimized layout (headers/footers, logo support).
Embedded charts/tables.
4. Technical Standards
Automation: Formulas must auto-update dashboard/reports when inputs change.
Scalability: Design must allow future question additions.
Error Handling: Prevent #DIV/0!, overflow, or misalignment issues.
Ideal Candidate Profile
Skills & Experience (Non-Compromisable)
Proven Excel Mastery:
Advanced formulas (SUMPRODUCT, INDEX/MATCH, PivotTables).
Chart customization + conditional formatting.
VBA for PDF export (optional but preferred).
Portfolio: Demonstrable projects featuring:
Survey/data dashboards.
Automated reports.
Speed + Precision: Ability to deliver quickly without sacrificing accuracy.
Soft Skills
Responsive communication.
Proactive problem-solving (e.g., suggesting chart improvements).
We require an advanced Excel expert to build a survey data processing tool that:
Accepts bulk inputs for mixed question types (single/multi-select, rating scales).
Generates an auto-updating dashboard with visualizations (bar charts) and detailed tables.
Produces professional PDF reports.
Delivers zero-compromise quality (error-proof formulas, intuitive UI, print-perfect outputs).
Reference Survey: [Provided PDF] with 7 questions (confidence comparisons, effectiveness ratings, class types).
Core Requirements & Deliverables
1. Input System (Must-Have)
Bulk Response Entry:
Grid-based templates for each question type (e.g., numeric input for option counts like "CPR Class: 25 responses").
Data validation (number-only cells, dropdowns for ratings).
Support for:
Single-select (Q1, Q6, Q7).
Multi-select (Q2, Q3).
5-point scales (Q4, Q5).
2. Dashboard Engine (Critical)
Visualizations:
Dynamic bar charts for:
Confidence shift (side-by-side comparison of Q2 vs. Q3).
Training/instructor effectiveness (Q4, Q5).
Class type distribution (Q1).
Color-coded and labeled for immediate insights.
Summary Tables:
Response counts + auto-calculated percentages (e.g., "Very Confident: 15 (30%)").
Pre/post training analytics (Q2 vs. Q3).
3. Reporting Module (Non-Negotiable)
One-click PDF export with:
Print-optimized layout (headers/footers, logo support).
Embedded charts/tables.
4. Technical Standards
Automation: Formulas must auto-update dashboard/reports when inputs change.
Scalability: Design must allow future question additions.
Error Handling: Prevent #DIV/0!, overflow, or misalignment issues.
Ideal Candidate Profile
Skills & Experience (Non-Compromisable)
Proven Excel Mastery:
Advanced formulas (SUMPRODUCT, INDEX/MATCH, PivotTables).
Chart customization + conditional formatting.
VBA for PDF export (optional but preferred).
Portfolio: Demonstrable projects featuring:
Survey/data dashboards.
Automated reports.
Speed + Precision: Ability to deliver quickly without sacrificing accuracy.
Soft Skills
Responsive communication.
Proactive problem-solving (e.g., suggesting chart improvements).