
Completed
Posted
Paid on delivery
I'm looking for a Google Sheets expert to create an automated spreadsheet template for inputting NHL scores. The spreadsheet should dynamically fill in data based on the scores I enter. Requirements: - Input NHL scores to auto-generate data - Track 8 specific categories for all teams: - Team record for over 1.5 and 2.5 goals per game - Goals given up: 1.5 and 2.5 - Game record for combined score over 3.5 and 4.5 - Game score under 7.5 - Team winning record when adding +2.5 goals to total per game - Team goals scored and given per game - Breakdown by team, home, away, and total - Ability to compare and contrast teams - Output should be organized in tables and charts Ideal skills: - Proficiency in Google Sheets - Experience with conditional formatting and data automation - Familiarity with sports statistics, preferably NHL
Project ID: 40762599
88 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
88 freelancers are bidding on average $125 USD for this job

Hello, I have carefully reviewed your project requirements for creating an automated NHL score tracker spreadsheet in Google Sheets. I understand the need for dynamically filling in data based on the scores entered. Let's chat and discuss it further. To handle your project, I will start with setting up input fields for NHL scores and creating formulas to auto-generate data for the 8 specific categories you mentioned. I will utilize Google Sheets' functions for calculations and conditional formatting to ensure data accuracy and visualization. Additionally, I will organize the output in tables and charts for easy comparison and analysis. The deliverables of this project will include an automated spreadsheet template that tracks NHL scores, team statistics, and game records efficiently. Before signing-off my bid, I would like to ask a question, i.e., how frequently do you need the data to be updated in the spreadsheet? Best Regards, Aneesa.
$100 USD in 1 day
7.2
7.2

Hello! I can build a Google Sheets template where entering NHL scores automatically updates team statistics, records, and comparisons. I will organize the data by team, home, away, and overall performance, covering all requested goal thresholds and winning records. I will use formulas, conditional formatting, and clear tables and charts to make the spreadsheet easy to update and analyze. I will also test it with sample NHL scores to verify the calculations and ensure the statistics update correctly when new results are entered.
$74 USD in 1 day
6.8
6.8

AVAILABLE TO START IMMEDIATELY. FREE SAMPLE PROVIDED.,,. I will build an automated Google Sheets template with advanced formulas and conditional formatting to track your 8 custom NHL metrics, complete with home/away breakdowns, team comparison tools, and dynamic charts. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$51 USD in 1 day
6.6
6.6

I got you! I can build your automated Google Sheets NHL score template so entered scores instantly update team records, home/away splits, totals, comparisons, tables, and charts. I’m ready to handle the formulas, conditional formatting, dashboards, and category logic exactly as needed. I’m young, a fast learner, available 24/7, and focused on making this clean and easy to use. Get the demo first before you pay. A couple quick questions: Will you enter scores manually game-by-game, or do you want import/API capability later? Also, should “+2.5 goals” be calculated against actual opponent score/spread for each game? Let’s chat and discuss the answers so I can start building the template. Kind regards, Haroon Z
$250 USD in 1 day
5.8
5.8

Hi, I'll build your NHL score tracker in Google Sheets so you only enter the game date, teams, and final scores. Everything else updates automatically, including all eight requested statistical categories. The workbook will include: • A simple game-entry sheet with dropdowns and duplicate-game checks. • Automatic calculations for goals over 1.5/2.5, goals conceded, combined scores over 3.5/4.5, under 7.5, adjusted +2.5 winning records, and goals scored/conceded averages. • Separate home, away, and overall records for every NHL team. • An interactive comparison dashboard with team selectors, charts, and conditional formatting. One important detail: I'll calculate each team's statistics from a single game log, preventing discrepancies between home, away, and overall totals. I have extensive experience in spreadsheet automation, formulas, data validation, and interactive dashboards. I can deliver the working template within 3 days, including sample games, formula testing, and a short usage guide. Visit my portfolio and client reviews: https://www.freelancer.com/u/AmazingEngr76386 For the +2.5 category, should the adjusted team score be compared against the opponent's actual final score? Adnan
$140 USD in 7 days
5.9
5.9

Hi, I am a Google Sheets developer with 8 years of rich experience in software development, with a background in sports stats trackers and spreadsheet automation. I am familiar with Google Sheets, QUERY, ARRAYFORMULA, COUNTIFS, Apps Script, conditional formatting, data visualization and web scraping. I can have this ready in a day, with one simple input tab where you enter the date, home team, away team and scores, and everything else updates on its own. Each team gets its over 1.5 and 2.5 goals record, goals allowed over 1.5 and 2.5, game totals over 3.5 and 4.5, under 7.5, its record with +2.5 goals added, and goals for and against per game, all split by home, away and total. A compare tab lets you pick any two teams from dropdowns and see them side by side with charts, and conditional formatting highlights the strongest and weakest numbers. If you'd like, I can also add an optional Apps Script button that pulls final scores from the NHL's public data so you don't have to type them. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
$250 USD in 7 days
5.9
5.9

Hi Allen, I will build an automated Google Sheet that, when you enter NHL scores, instantly calculates the eight requested categories, breaks down stats by team, home and away, and creates tables and charts. I’ll deliver the complete template in 3 days for $150. Ready to send a sample layout now—shall we begin? Thanks, Waiting for your response in chat! Best Regards.
$140 USD in 3 days
5.5
5.5

Hi, I got that you are looking for a Google Sheets expert to create an automated spreadsheet template for inputting NHL scores. This is what I can help you with, let's chat. My approach is to utilize advanced conditional formatting and data automation techniques within Google Sheets to ensure that the spreadsheet dynamically fills in data based on the scores entered. By leveraging my expertise in sports statistics and proficiency in Google Sheets, I will track and analyze the 8 specific categories for all teams as outlined in your requirements. The outcome will be an organized display of tables and charts that allow for easy comparison and contrast of teams across various metrics. As final deliverables, you will receive a fully automated NHL score tracker spreadsheet that efficiently tracks and analyzes team performance based on the specified categories. One thing I'd like to confirm before we start: Do you have any specific preferences for how the data should be visually represented in the tables and charts? Looking forward to discussing this project further. Regards, Imran
$90 USD in 1 day
5.6
5.6

Hello, I'm Denis, a full-stack developer, and I have built data dashboards that turn raw game statistics into organized, filterable views that teams use to make decisions. You need a Google Sheets template that lets you enter NHL scores and automatically calculates eight performance metrics for every team—things like records against goal thresholds, home and away splits, and adjusted scoring rates. The spreadsheet should organize these into comparable tables and charts so you can spot patterns quickly. I would start by setting up the input sheet where you enter scores, then build the calculation layer with formulas that track each metric across the eight categories. Next, I would create separate summary tables broken down by team, home, away, and total, then add charts that let you compare teams side by side. The whole thing would be organized so you can add new games without touching the formulas. The main challenge is keeping the formulas clean and fast as the data grows. I would use helper columns and named ranges to make calculations reliable and easy to update later. One thing to confirm early: whether you want live data pulled from an NHL API or if you will always enter scores manually, since that changes the architecture. I can start working right away. Let's connect and discuss the details. Thanks, Denis.
$30 USD in 2 days
5.5
5.5

As an experienced data professional for over 9 years, I utilize my computer science background to bring precision and automation to every project I undertake. Browsing through your needs for a Google Sheets expert, my skills in data processing and visualization, combined with extensive experience working with Excel, make me the perfect fit for this NHL Score Tracker Spreadsheet project you have. I am proficient with Google Sheets and can create a robust, automated spreadsheet template that'll dynamically fill in the data based on the scores you input. My understanding of conditional formatting and data automation aligns flawlessly with your requirement for tracking eight specific categories per team. Additionally, my familiarity with sports statistics bolsters my ability to organize the output in tables and charts, providing a comprehensive breakdown by team, home, away, and total. What sets me apart is not just technical proficiency but also an aim to build solutions that generate valuable insights. My proficiency with advanced web research techniques and data mining could help expand this project further if needed. I assure you my work will be accurate, timely delivered, and aligned with your vision. Let me use my proficiency in Python-Based Data Collection as well on this project to ensure its efficiency and efficacy.
$150 USD in 3 days
5.5
5.5

Hi, I can build an automated Google Sheets template that calculates NHL team statistics from entered game scores. I’ll organize the data by team, home, away, and overall performance, with formulas, conditional formatting, comparison tables, and charts for easy analysis. I’m experienced in data management, spreadsheet organization, and automation. I’ll structure the workbook so new scores update the statistics automatically and make it easy to compare teams. I’m happy to discuss your preferred layout and start with a sample structure for your review. Thank you!
$140 USD in 3 days
5.0
5.0

Hi there, I can build an automated Google Sheets NHL statistics tracker where entering game scores updates team records, goals scored and conceded, over/under percentages, and the +2.5 goals adjustment metric automatically. I’ll organize the data by team, home, away, and overall performance, with comparison tables, conditional formatting, and interactive charts. I’ll ensure the formulas are accurate, easy to maintain, and ready for new game entries. Best Regards, Avinash
$100 USD in 7 days
4.4
4.4

Hello, I've carefully reviewed your requirements and understand your goal of creating an automated Google Sheets template for tracking and comparing NHL team statistics based on entered game scores. I have experience with Google Sheets automation, formulas, data analysis, and visualization, and I'm available to start immediately. In my opinion, the key challenge is ensuring every statistic updates accurately without manual calculations. I'd create a simple score-entry sheet connected to automated tables using COUNTIFS, SUMIFS, and ARRAYFORMULA. The dashboard will track all eight categories, including goal thresholds, adjusted winning records, and goals scored and conceded, with separate home, away, and overall statistics. I'll also include team comparison charts, conditional formatting, and a clean, easy-to-use layout. I have two quick questions: • Will you enter scores manually, or would you prefer automatic NHL score imports? • Should the statistics cover the current season only or multiple seasons? I'd be glad to discuss the details and can start immediately. Best regards, Carlos.
$50 USD in 3 days
4.0
4.0

⚠️ If you're not happy, you don’t pay. ⚠️ Hi Client, thank you for checking my proposal and sharing the detailed project brief. I can build your automated NHL score tracking spreadsheet using Google Sheets with a user-friendly and dynamic design. I will deliver: - Automated input fields for NHL scores that populate data in real-time - Tracking for team records across 8 specific categories - Custom formulas for goals per game, game records, and team comparisons - Organized tables and charts for clear visualization - Conditional formatting for enhanced data readability You will also receive: - A user guide for easy navigation - Ongoing support for any adjustments I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag Pipal
$150 USD in 14 days
3.8
3.8

Hello. Creating an automated NHL score tracker in Google Sheets requires precise formula logic to handle various game conditions and dynamically generate statistical breakdowns. I will design a robust Google Sheet template that allows manual score input and automatically calculates all 8 specified categories (over/under goals, game record, etc.) for each team, broken down by home, away, and total. This includes implementing conditional formatting for clear visualization and setting up comparative tables and charts. If you later require automated data fetching, I can develop a Python script to seamlessly integrate NHL scores directly into the sheet. I can deliver this Google Sheet template within 2-3 days for $190. Do you have a specific format for score input, or can I define one for optimal spreadsheet design? Best regards, Yevhen.
$190 USD in 2 days
3.8
3.8

==== Hi - Truong here ==== "AUTOMATED NHL SCORE TRACKER IN GOOGLE SHEETS" - you need instant team stats and clear home/away comparisons from each score entered. I’d build a game-entry sheet linked to formula-driven team summaries, tracking all requested goal thresholds, records, and charts without manual recalculation. Should the tracker start with this season’s games or include historical NHL results too? Looking forward to work with you.
$250 USD in 7 days
3.7
3.7

Hi There, Hope you are well. I am experienced in creating automated Google Sheets templates for NHL scores, with a focus on inputting data and tracking specific categories for all teams. Proficient in Google Sheets, I excel in conditional formatting, data automation, and sports statistics analysis, ensuring organized output in tables and charts for easy comparison and contrast. Thanks in advance for the opportunity to working with you. Best Regards, Serazum
$55 USD in 1 day
4.7
4.7

Hello, I can build an automated Google Sheets NHL tracker that transforms entered game scores into clear team statistics, comparisons, and visual insights. I’ll create a structured game-entry sheet and formula-driven analysis tables to calculate all eight requested categories, including goal thresholds, combined totals, adjusted winning records, and goals scored/conceded per game. Home, away, and overall records will be separated so you can compare teams consistently. I’ll add conditional formatting, validation rules, team filters, and charts, with formulas designed to update automatically as new results are entered. I’ll also test the calculations against sample NHL scores and document how to maintain the template. Estimated delivery is 2 days for $170, assuming the required categories and scoring rules are confirmed at kickoff. M1: $70 — Sheet structure and scoring formulas, Day 1 M2: $100 — Team comparisons, charts, testing, and handover, Day 2 Looking forward to working with you. Thanks!
$170 USD in 2 days
3.3
3.3

I’d build this as a live statistical dashboard, not just a spreadsheet of NHL scores. You enter each game’s date, home team, away team, and final score, and the sheet automatically updates all eight statistical categories, with separate home, away, and overall records for every team. I’d organize the workbook into three parts: a game-entry sheet, a team statistics table with formula-driven calculations, and a comparison dashboard with charts and conditional formatting. I’d also make the calculations easy to audit so you can verify how each record is derived. Before building, I’d clarify one detail: for the “winning record when adding +2.5 goals to total per game” metric, what exactly counts as a win? I want to make sure the formula matches your intended betting or scoring logic. Do you have an existing spreadsheet or a sample of the output you want? I can use it to define the formulas and build the template around your exact requirements.
$140 USD in 7 days
3.2
3.2

>>>>>Hi there!<<<<< The +2.5 goals adjustment is an unusual detail here; the formulas need to handle it consistently across team, home, away, and total views. I've built data automation in Node.js and CRM integrations where records must accumulate correctly instead of being overwritten. I'd first define the calculation rules, then build and test the formulas against sample scores before adding comparison tables and charts. Should the stats update from scores entered manually, or from imported game data? Ricardo
$230 USD in 3 days
3.2
3.2

Longmont, United States
Payment method verified
Member since Oct 11, 2026
$700 USD
₹750-1250 INR / hour
$2-8 USD / hour
$30-250 USD
₹12500-37500 INR
₹750-1250 INR / hour
₹12500-37500 INR
$8-15 USD / hour
₹750-1250 INR / hour
₹12500-37500 INR
$30-250 USD
$14-30 NZD
$30-250 USD
₹12500-37500 INR
$700 USD
₹400-750 INR / hour
₹600-1500 INR
₹12500-37500 INR
₹1500-12500 INR
$30-250 USD