I am seeking an experienced spreadsheet developer (proficient in Google Sheets and/or Excel) to create a comprehensive job search tracker that will be used by my career coaching clients. The tracker should be dynamic, visually appealing, and easy to use, with automated calculations, filtering options, and actionable insights.
The ideal candidate has expertise in:
Building custom dashboards with formulas and charts.
Designing user-friendly interfaces with dropdowns, conditional formatting, and instructions.
Automating reports and summaries for better data analysis.
Integrating features that support month-by-month breakdowns and progress tracking.
Key Deliverables
Master Tracker with the following tabs:
Job Applications:
Fields: Job Title, Company, Job Description Link, Application Date, Status (dropdown), Recruiter Contact, Notes, Follow-Up Date, and Next Steps.
Status Dropdown Options: Applied, Interviewing, Rejected, Offer, Follow-Up Required, No Response.
Automated features to track overdue follow-ups and next steps.
Networking Outreach:
Fields: Name, Role, Company, LinkedIn/Email, Initial Contact Date, Follow-Up Dates, Outcome (dropdown), Notes, and Next Steps.
Outcome Dropdown Options: No Response, Follow-Up Sent, Connection Made, Referral Given.
Automated follow-up reminders.
Interviews:
Fields: Job Title, Company, Interview Stage, Interviewer Name(s), Interview Date, Outcome (dropdown), Feedback, Follow-Up Sent, and Notes.
Outcome Dropdown Options: Passed, Failed, Awaiting Feedback.
Target Companies:
Fields: Company Name, Industry, Size, Why This Company?, Roles of Interest, Contacts at the Company, Current Job Openings, Application Link, and Notes.
Metrics Dashboard:
Automatically calculates:
Total Applications Sent
Total Networking Contacts
Responses Received (applications that progressed to “Interviewing”)
Interviews Secured
Offers Received
Conversion Rates:
Applications → Interviews (%)
Networking → Interviews (%)
Interviews → Offers (%)
Weekly and monthly totals.
Includes visual graphs for progress tracking.
Monthly Progress:
Filters and analyzes data by month.
Shows totals and conversion rates for the selected month.
Weekly Goals Tracker:
Tracks weekly targets for applications, networking, and follow-ups.
Includes conditional formatting to highlight completed goals.
Wins Tracker:
Space to log daily/weekly wins and reflections.
Instructions:
Simple step-by-step guide on how to use each tab.
Required Features
Dropdown Menus:
For fields like Status, Outcome, etc., to ensure consistent data entry.
Conditional Formatting:
Highlight overdue follow-ups or completed tasks.
Dynamic Filters and Pivot Tables:
Enable month-by-month and week-by-week analysis.
Automated Charts and Visuals:
Bar/pie charts showing progress, trends, and conversion rates.
User-Friendly Design:
Clean, easy-to-read layout.
Space for notes and reflections.
Scalability:
Designed to handle multiple entries and large datasets.
Additional Notes
Ease of Use:
The tracker will be shared with clients, so it must be intuitive and require minimal setup or troubleshooting on their part.
Automation:
Formulas should dynamically update metrics based on the data entered.
Dropdowns should standardize inputs to prevent errors.
Delivery:
Final product must be delivered in Google Sheets format.
Include a brief guide or video walkthrough for how to use the tracker.
