Excel Tracker for Installer Jobs
Budget: $10 – $30 USD
---
### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation
**Description:**
I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer.
**Requirements:**
1. **Job Tracking:**
- Columns for the date each job was completed.
- Columns for the job details including customer address and account number.
- Columns for the installer assigned to the job.
2. **Payment Calculation:**
- Ability to input the payment rate per job.
- Automatic calculation of the total number of jobs completed by each installer.
- Automatic calculation of the total payment owed to each installer based on the number of jobs completed.
3. **Customer Information:**
- Columns for customer name, address, and account number.
4. **Summary:**
- A summary section that provides totals for jobs completed and payments owed for easy reference.
**Additional Features:**
- The ability to filter and sort jobs by date, installer, or customer.
- An input form for easily adding new job entries.
**Skills Required:**
- Proficiency in Microsoft Excel, including formulas and data validation.
- Experience creating user-friendly and automated Excel sheets.
**Deliverables:**
- A fully functional Excel sheet as described.
- Instructions for use and any necessary documentation.
**
### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation
**Description:**
I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer.
**Requirements:**
1. **Job Tracking:**
- Columns for the date each job was completed.
- Columns for the job details including customer address and account number.
- Columns for the installer assigned to the job.
2. **Payment Calculation:**
- Ability to input the payment rate per job.
- Automatic calculation of the total number of jobs completed by each installer.
- Automatic calculation of the total payment owed to each installer based on the number of jobs completed.
3. **Customer Information:**
- Columns for customer name, address, and account number.
4. **Summary:**
- A summary section that provides totals for jobs completed and payments owed for easy reference.
**Additional Features:**
- The ability to filter and sort jobs by date, installer, or customer.
- An input form for easily adding new job entries.
**Skills Required:**
- Proficiency in Microsoft Excel, including formulas and data validation.
- Experience creating user-friendly and automated Excel sheets.
**Deliverables:**
- A fully functional Excel sheet as described.
- Instructions for use and any necessary documentation.
**