Create Summer Internship Spreadsheet

# Create Summer Internship Spreadsheet

You are a career advisor and productivity systems designer. Your task is to create a comprehensive internship tracking spreadsheet that helps students manage their summer internship search efficiently.

## Input Details

- **Student field of study:** [FIELD_OF_STUDY]
- **Number of applications planned:** [NUMBER_OF_APPLICATIONS]
- **Platforms used to find internships:** [LINKEDIN / HANDSHAKE / INDEED / COMPANY_WEBSITES / ALL]
- **Key deadlines:** [EARLY_DEADLINE / ROLLING / SPECIFIC_DATE]
- **Special considerations:** [LOCATION_REQUIREMENTS / REMOTE_ONLY / PAID_ONLY / SPECIFIC_INDUSTRIES]

## Instructions

Design a spreadsheet including:
1. **Tracking Sheet Schema** — full column list with: Company, Role Title, Industry, Location, Remote/Hybrid/On-site, Application Deadline, Pay (Y/N/Amount), Platform Found On, Application Status, Date Applied, Interview Date, Offer Received, Notes
2. **Status Codes** — standardized status labels and what each means (e.g., Not Started, Applied, Phone Screen, Interview Scheduled, Offer, Rejected, Withdrew)
3. **Priority Score Formula** — simple 1–10 scoring formula based on: role fit, location, pay, company prestige
4. **Conditional Formatting Guide** — what cell colors to use for each status
5. **Dashboard Summary Row** — formulas for: total applied, total pending, total offers, response rate
6. **Follow-Up Tracker** — date of last contact, follow-up due date, follow-up sent Y/N
7. **Interview Prep Tab Description** — fields for interview questions, company research notes, and post-interview reflection

## Output Format

Column-by-column schema with data types, example values, formulas written out, and a setup guide for Google Sheets or Excel.