Comprehensive Cricket Schedule Creation
Budget: $14 – $30 NZD
I need a Google Sheets expert to help me put together an extensive and detailed cricket schedule for the upcoming English summer season.
Tasks Include:
- Including International, Domestic, and Club tournaments and teams in the schedule
- Organizing fixtures based on the date
Additional Details:
- Each fixture should have comprehensive information about the venue
- Match timings should be included
- Broadcast details for each match should be provided
Ideal Skills:
- Proficiency in Google Sheets
- Knowledge of cricket and its various tournaments
- Attention to detail to ensure that all necessary information is included
- Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Data Entry Expert for Cricket Schedule
**Objective:**
Create a comprehensive cricket schedule for the English summer season using Google Sheets. The schedule should include fixtures for various tournaments and teams, organized by date and start time.
**Scope:**
The schedule should cover the following:
1. England Men
2. England Women
3. England Disability
4. Vitality County Championship
5. Vitality Blast
6. Metro Bank One Day Cup
7. Charlotte Edwards Cup
8. Rachael Heyhoe Flint Trophy
10. The Hundred
**Details to Include:**
For each match, include the following columns:
- Date
- Match Number
- Teams (Example: Team A vs Team B)
- Match Format (Example: T20, ODI, Test, League 100)
- International or Domestic
- UK Start Time
- New Zealand Start Time
- Stadium Name
- City
- Distance from Sidcup, UK (as per the provided Google Maps link)
**Instructions:**
1. **Data Entry:**
- Gather fixtures from reliable sources such as:
- [ECB Official Site](https://www.ecb.co.uk/)
- [Cricbuzz Schedule](https://www.cricbuzz.com/cricket-schedule/series)
- Ensure the data is accurate and up-to-date.
2. **Formatting:**
- Organize matches by date and start time.
- Clearly distinguish between different tournaments and formats.
- Use separate sheets for each tournament if necessary, but ensure a master sheet includes all fixtures.
3. **Time Conversion:**
- Convert match start times to both UK and New Zealand time zones.
4. **Stadium Information:**
- Include the stadium name and city where each match is being played.
- Use the provided Google Maps link to determine the distance from Sidcup, UK, to each stadium.
- Include this distance in the relevant column.
5. **Google Sheets Setup:**
- Create a well-structured and easy-to-navigate Google Sheets document.
- Ensure all columns are labeled clearly and the data is sorted correctly.
- Share the final document with [Your Email Address].
**Deliverables:**
- A Google Sheets document containing the complete cricket schedule.
- The sheet must be shared with edit access to [Your Email Address].
**Columns to Include in the Google Sheet:**
- Date
- Match Number
- Teams
- Match Format
- International or Domestic
- UK Start Time
- New Zealand Start Time
- Stadium Name
- City
- Distance from Sidcup, UK
**Skills Required:**
- Proficiency in Google Sheets.
- Attention to detail and accuracy in data entry.
- Ability to convert time zones.
- Basic understanding of cricket formats and fixtures.
**Deadline:**
Please complete and submit the Google Sheets document by [Specify Deadline].
**Additional Information:**
- Reference link for distance calculation: [Google Maps Link](https://www.google.com/maps/place/Sidcup,+UK/@51.4327371,0.0328949,12z/data=!3m1!4b1!4m6!3m5!1s0x47d8a9343780a7a9:0x2c313ce242546dff!8m2!3d51.4264863!4d0.1009392!16zL20vMG5jM3Y?entry=ttu)
Please confirm your availability and estimated time to complete this task. Feel free to ask if you have any questions or need further clarification. Thank you!
If you're a cricket enthusiast with excellent data entry skills, I'd love to hear from you.
Tasks Include:
- Including International, Domestic, and Club tournaments and teams in the schedule
- Organizing fixtures based on the date
Additional Details:
- Each fixture should have comprehensive information about the venue
- Match timings should be included
- Broadcast details for each match should be provided
Ideal Skills:
- Proficiency in Google Sheets
- Knowledge of cricket and its various tournaments
- Attention to detail to ensure that all necessary information is included
- Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Data Entry Expert for Cricket Schedule
**Objective:**
Create a comprehensive cricket schedule for the English summer season using Google Sheets. The schedule should include fixtures for various tournaments and teams, organized by date and start time.
**Scope:**
The schedule should cover the following:
1. England Men
2. England Women
3. England Disability
4. Vitality County Championship
5. Vitality Blast
6. Metro Bank One Day Cup
7. Charlotte Edwards Cup
8. Rachael Heyhoe Flint Trophy
10. The Hundred
**Details to Include:**
For each match, include the following columns:
- Date
- Match Number
- Teams (Example: Team A vs Team B)
- Match Format (Example: T20, ODI, Test, League 100)
- International or Domestic
- UK Start Time
- New Zealand Start Time
- Stadium Name
- City
- Distance from Sidcup, UK (as per the provided Google Maps link)
**Instructions:**
1. **Data Entry:**
- Gather fixtures from reliable sources such as:
- [ECB Official Site](https://www.ecb.co.uk/)
- [Cricbuzz Schedule](https://www.cricbuzz.com/cricket-schedule/series)
- Ensure the data is accurate and up-to-date.
2. **Formatting:**
- Organize matches by date and start time.
- Clearly distinguish between different tournaments and formats.
- Use separate sheets for each tournament if necessary, but ensure a master sheet includes all fixtures.
3. **Time Conversion:**
- Convert match start times to both UK and New Zealand time zones.
4. **Stadium Information:**
- Include the stadium name and city where each match is being played.
- Use the provided Google Maps link to determine the distance from Sidcup, UK, to each stadium.
- Include this distance in the relevant column.
5. **Google Sheets Setup:**
- Create a well-structured and easy-to-navigate Google Sheets document.
- Ensure all columns are labeled clearly and the data is sorted correctly.
- Share the final document with [Your Email Address].
**Deliverables:**
- A Google Sheets document containing the complete cricket schedule.
- The sheet must be shared with edit access to [Your Email Address].
**Columns to Include in the Google Sheet:**
- Date
- Match Number
- Teams
- Match Format
- International or Domestic
- UK Start Time
- New Zealand Start Time
- Stadium Name
- City
- Distance from Sidcup, UK
**Skills Required:**
- Proficiency in Google Sheets.
- Attention to detail and accuracy in data entry.
- Ability to convert time zones.
- Basic understanding of cricket formats and fixtures.
**Deadline:**
Please complete and submit the Google Sheets document by [Specify Deadline].
**Additional Information:**
- Reference link for distance calculation: [Google Maps Link](https://www.google.com/maps/place/Sidcup,+UK/@51.4327371,0.0328949,12z/data=!3m1!4b1!4m6!3m5!1s0x47d8a9343780a7a9:0x2c313ce242546dff!8m2!3d51.4264863!4d0.1009392!16zL20vMG5jM3Y?entry=ttu)
Please confirm your availability and estimated time to complete this task. Feel free to ask if you have any questions or need further clarification. Thank you!
If you're a cricket enthusiast with excellent data entry skills, I'd love to hear from you.