Google Sheets Automation for Production Tracking

I'm looking for a Google Sheets expert to develop a production tracking sheet for my manufacturing business. The sheet needs to be highly functional and user-friendly.

Key requirements:
- Automated calculations: To reduce manual entry and errors.
- Customizable templates: So I can adjust as needed.
- Real-time data updates: To monitor production status live.

Ideal skills and experience:
- Proficiency in Google Sheets, especially in automation and template customization.
- Experience in creating production tracking tools.
- Strong attention to detail and problem-solving skills.

Please include relevant experience in your application.