NRL Tipping Excel Template – Free Tracker (2026)
5
Free download
Projects & Planning
Download template
Backyard cricket Excel - Free template
Track backyard cricket matches, batting, bowling and player statistics with four practical Excel sheets for Australian games.
This backyard cricket Excel scorecard records match details, batting and bowling figures, results and player statistics. It includes Match Summary, Scorecard, Player Statistics and Instructions sheets, with prepared rows for up to 100 matches and 100 scorecard entries.
Enter the players, runs, balls, boundaries, wickets and bowling figures in the pale-yellow input cells. Formulas calculate strike rates, boundary runs, dismissal flags, economy rates, legal balls, bowling impact and career summaries, so you can settle the score without doing the maths on the back of an esky.
The workbook suits a casual Australia Day match, a family cricket day or a backyard competition. It is an informal scoring tool rather than an official Cricket Australia record, as noted on the Instructions sheet.
The key benefits of this Excel template
- Record up to 100 match entries in the Match Summary register, including venue, city, event, overs and result.
- Capture batting figures for runs, balls faced, fours, sixes, wickets lost and dismissal method.
- Calculate boundary runs automatically using fours at 4 runs and sixes at 6 runs.
- Track bowling overs, maidens, runs conceded, wickets, wides and no-balls.
- Show calculated strike rates, economy rates, legal balls and bowling impact without manual formulas.
- Compare player totals, averages, highest scores, wickets and boundary percentages across recorded scorecard rows.
- Review total runs and wickets in two Player Statistics charts and compare match outcomes in Match Summary charts.
Step-by-step guide
- Open the Instructions sheet first and note that pale-yellow cells are for entry while formula cells should not be overwritten.
- On Match Summary, enter the selected match details such as Match ID, date, venue, city, event, overs per innings, teams, toss decision and status. Use DD/MM/YYYY for the date.
- On Scorecard, enter one row for each batter and bowler. Record runs, balls faced, fours, sixes and wickets lost for batting, then overs, maidens, runs conceded, wickets, wides and no-balls for bowling.
- Use the dropdowns for toss decision, match status, dismissal method and Player of Match. Enter overs in cricket notation, so 4.2 means four overs and two legal balls.
- Check the calculated columns for strike rate, boundary runs, dismissal flag, economy rate, legal balls and bowling impact. Correct the input rather than replacing a formula.
- Enter the match totals and details in the Match Summary register so the calculated result can show which team won or whether the game was tied.
- Review Player Statistics after recording matches. The sheet summarises the named players and updates its runs, wickets, ratings and charts from the Scorecard range.
What is included
Match Summary includes Match ID, date, venue, city, event, overs, teams, toss details, status, team runs and calculated result.
Scorecard has batting columns from Player through Dismissal Flag and bowling columns from Bowler through Bowling Impact.
Dropdown validation supports Bat or Field, four match statuses, six dismissal options and Yes or No for Player of Match.
Calculated batting outputs include Boundary Runs and a Dismissal Flag showing Out or Not out.
Calculated bowling outputs include Economy Rate, Legal Balls and a Standard or Strong Bowling Impact label.
Player Statistics uses VLOOKUP, COUNTIF, SUMIF and AVERAGEIF formulas to summarise prepared player rows.
Four charts are included: match team-run and result summaries on Match Summary, plus total runs and wickets on Player Statistics.
Who uses a backyard cricket scorecard in Australia
A backyard cricket scorecard is useful when a casual game has more players, innings or bragging rights than one person can remember. A parent organising a family cricket day in Melbourne, a housemate running a summer series in Sydney or a volunteer keeping score for a neighbourhood challenge can use the workbook to keep the result straight.
Image 1 shows the Match Summary sheet. Its left-hand area holds the selected match information, while the register from column J records Match ID, Match Date, Venue, City, Competition/Event, Overs per Innings, teams, toss details, status, team scores and Calculated Result. The prepared register runs from row 4 to row 103, giving 100 match rows.
From one game to a home competition
For a 10-over match, the captain might enter 113 for Harbour Hitters and 98 for Garden Strikers. The result formula then returns the batting team as winner when the two team-run cells are complete. A second 8-over game could finish 86 to 91, while equal scores such as 102 and 102 return Match tied.
This is particularly handy when a backyard series has several venues and dates. Instead of relying on a group-chat message, you can filter your own notes by match ID, city or event and keep the scorecard beside the season history.
Recording the players during the game
Image 2 shows the Scorecard sheet with batting fields such as Runs, Balls Faced, Fours, Sixes and How Out, followed by bowling fields including Overs, Maidens, Runs Conceded, Wickets, Wides and No-Balls. The prepared scoring range covers rows 2 to 101, or 100 player entries.
For example, Jack can be recorded with 31 runs from 18 balls, four fours and one six. The workbook calculates 22 boundary runs, while the Player Statistics sheet can later total his performances across the scorecard range.
Cricket scoring conventions the workbook applies
This workbook is designed for informal backyard scoring, not official competition administration. The Instructions sheet specifically says it does not replace official competition scoring or Cricket Australia match records, so agree house rules before the first ball, particularly around catches, retired batters, last-player-standing rules and whether wides count towards an innings total.
Use cricket overs notation
Image 4 explains that 4.2 means four completed overs and two balls, not 4.2 decimal overs. This distinction matters because six legal balls make an over. If a bowler delivers one wide, the ball count should not increase even though the score does. Enter the agreed figures consistently in Overs, Wides, No-Balls and Legal Balls-related inputs.
For a simple example, a bowler entering 2.3 has delivered 15 legal balls. If the scorecard records 2.3 as a normal decimal and somebody later treats it as 2.3 overs, economy comparisons can be distorted. The workbook's bowling calculations are only as reliable as the figures entered.
Match dates and status
Use the Australian date format DD/MM/YYYY, such as 18/01/2026. Match Summary provides status choices of Scheduled, In progress, Completed and Abandoned, while the toss decision uses Bat or Field. These dropdowns keep a register consistent when several people enter matches.
The workbook calculates a result when both team-run cells are present. If Team 1 scores 113 and Team 2 scores 98, the difference is 15 runs; if both scores are 102, the formula displays Match tied. It does not apply a formal competition points system, Duckworth-Lewis-Stern method or Cricket Australia rules engine.
Where backyard scorecards go wrong during a match
The most common scoring failures happen in the few seconds after a wicket or boundary, when everyone is arguing about whether the ball was legal. If a scorer enters 18 runs from 14 balls but forgets one four, the player's boundary total and boundary percentage will be wrong even though the innings total still looks plausible.
Overs are not ordinary decimals
Entering 4.5 as four overs and five balls creates a cricketing impossibility: an over has six legal balls, so the notation should move from 4.5 to 5.0. A team scoring 10 runs from a bowler's 1.2 should be assessed over eight legal balls, not 1.2 decimal overs. That difference can materially change a casual comparison of economy rates.
Dismissal and bowling entries get mixed up
The Scorecard has separate batting and bowling sections on the same row area. A batter's wickets lost input is not the same thing as the bowler's wickets column. If Liam is entered as run out, the bowling team's wicket total should not automatically be credited to the bowler unless your agreed backyard rules say it should.
Wides and no-balls are another trap. Adding a wide to Runs Conceded but also counting it as a legal ball understates the bowler's economy and over progress. The Instructions sheet tells you to record these figures consistently, and the calculated Legal Balls and Bowling Impact outputs depend on that discipline.
Finally, overwriting a formula with a score can quietly damage later summaries. For instance, replacing the formula in Boundary Runs with 20 may look harmless for one player, but it stops the workbook responding when the fours or sixes are corrected. Keep the input cells for facts and leave calculated cells alone.
Make the cricket spreadsheet part of game day
The easiest routine is to nominate one scorer before the toss and keep the laptop or tablet beside the boundary, away from the drinks table. Enter batting figures at the end of each over and confirm the score with both captains before starting the next over.
A practical scoring routine
- Set up the Match Summary before play, including the Match ID, date, teams, venue and overs. For example, use BYC-2026-004 for the fourth match in a home series.
- Enter player rows during the innings, then check runs, balls and wickets before the next batter arrives.
- At the innings break, review wides, no-balls and bowler figures against the verbal score. A two-minute check is cheaper than reconstructing 10 overs later.
- After the match, set the status to Completed and enter both team totals so the calculated result can be checked.
Image 3 shows Player Statistics, where the prepared rows summarise named players from the Scorecard using formulas. If Jack plays three matches and scores 31, 12 and 27, the sheet totals 70 runs and calculates an average from the available innings. Its charts give a quick visual comparison of total runs and wickets.
When Excel stops being enough
This template suits a small home competition and 100 prepared scorecard entries. If you are running hundreds of games, need simultaneous mobile scoring, official league points, player registration or live sharing, a dedicated cricket scoring platform will be more practical than extending a workbook manually.
Frequently asked questions about this template
Download
File format
Excel (.xlsx)
Compatible software
Excel, Google Sheets, LibreOffice
Price
Free