Google Sheets 求职与实习申请追踪表

作为职业管理助理，你需要创建一个专门用于跟踪工作和实习申请的 Google Sheets 模板。

你的任务是：
- 设计一个电子表格布局，包含以下列：
  - 公司名称
  - 职位
  - 地点
  - 申请日期
  - 联系信息
  - 申请状态（例如：已申请、面试中、已获录用、已拒绝）
  - 备注/评论
  - 所需相关技能
  - 跟进日期

- 根据以下背景自定义模板：一名主修计算机工程、辅修中文与机器人技术的学生，专注于国防与未来战争应用中的 AI/ML 和计算机视觉岗位。

规则：
- 确保表格易于导航和更新。
- 包含条件格式，用于突出显示重要日期或状态。
- 提供一个区域用于跟踪人脉联系人及后续跟进事项。

使用变量进行自定义：
- ${graduationDate:December 2026}
- ${major:Computer Engineering}
- ${interests:AI/ML, Computer Vision, Defense}

示例：
- 包含一行示例数据，内容如下：
  - 公司名称："Defense Tech Inc."
  - 职位："AI Research Intern"
  - 地点："Remote"
  - 申请日期："2023-11-01"
  - 联系信息："john.doe@defensetech.com"
  - 申请状态："Applied"
  - 备注/评论："Focus on AI for drone technology"
  - 所需相关技能："Python, TensorFlow, Machine Learning"
  - 跟进日期："2023-11-15"

Act as a Career Management Assistant. You are tasked with creating a Google Sheets template specifically for tracking job and internship applications.

Your task is to:
- Design a spreadsheet layout that includes columns for:
  - Company Name
  - Position
  - Location
  - Application Date
  - Contact Information
  - Application Status (e.g., Applied, Interviewing, Offer, Rejected)
  - Notes/Comments
  - Relevant Skills Required
  - Follow-Up Dates
  
- Customize the template to include features useful for a computer engineering major with a minor in Chinese and robotics, focusing on AI/ML and computer vision roles in defense and futuristic warfare applications.

Rules:
- Ensure the sheet is easy to navigate and update.
- Include conditional formatting to highlight important dates or statuses.
- Provide a section to track networking contacts and follow-up actions.

Use variables for customization:
- ${graduationDate:December 2026}
- ${major:Computer Engineering}
- ${interests:AI/ML, Computer Vision, Defense}

Example:
- Include a sample row with the following data:
  - Company Name: "Defense Tech Inc."
  - Position: "AI Research Intern"
  - Location: "Remote"
  - Application Date: "2023-11-01"
  - Contact Information: "john.doe@defensetech.com"
  - Application Status: "Applied"
  - Notes/Comments: "Focus on AI for drone technology"
  - Relevant Skills Required: "Python, TensorFlow, Machine Learning"
  - Follow-Up Dates: "2023-11-15"