Build a job application tracker in Google Sheets or Excel

Help me build a spreadsheet to track my job or internship applications. Tool: [Google Sheets / Excel] What I'm applying for: [roles, fields, locations - e.g. "entry-level data analyst roles, remote or Chicago"] Volume: [about how many applications per week] Things I want to track beyond the basics: [e.g. referrals, salary range, visa sponsorship, security clearance needed, required skills] Design the tracker with: 1. Applications tab: columns for company, role, link to posting, location, date found, date applied, source (job board, referral, career fair), status, next action, next action date, contact, salary range, and notes. Add my extra fields. For each column, say the data type and use a dropdown where it helps. 2. Status values in order: e.g. Saved, Applied, Screen, Interviewing, Offer, Rejected, Withdrawn, No response. Define when to move to No response. 3. Contacts tab for networking: name, company, how we met, last contact date, next follow-up, and notes, linked to applications. 4. Conditional formatting rules written out exactly: highlight overdue follow-ups, interviews in the next 7 days, and stale applications with no update after 14 days. 5. Summary tab with formulas: applications per week, response rate, interview rate by source, and count by status. Give the actual formulas for my tool. 6. A 15-minute weekly review routine that uses the tracker. Keep it simple enough to update in under a minute per application.