Data Entry Template

Excel Template

Use this Excel Template to manually enter data from matches.

The template must be used in Excel, Google Sheets and LibreOffice may not work correctly.

Download and unzip the linked file.

The Most Updated File Is PINNED In

Complete instructions also available in the file.

After you have the match screenshots with required information, download one copy of the template.
Copy over the 'Horizontal' tab by holing CTRL and start entering the information, one match per tab.
When you complete entering information for that match, rename the tab to the MLN displayed in the top left corner (13 digit long number).
When finished with a tab, PLEASE Hardcode all values (copy and paste as values). Detailed instructions available in the file, and in an image down below.
Please wait and submit one file with all of the data for a period, instead of submiting one file per match.
Submissions go in this form here.

After completing data entry to a tab, follow these steps to hardcode the values so they don't accidentally change.

Select All
1. You can do this in multiple ways:
  1. Ctrl + A (Windows)
  2. Cmd + A (Mac)
  3. Click the down-right arrow on the far left of the formula bar. [Pictured as 1] (Both)
Copy
1. Again, multiple options:
  1. Ctrl + C (Windows)
  2. Cmd + C (Mac)
  3. Click the two pages of paper icon in the ribbon. [Pictured as 2] (Both)
Paste as Values
1. The alternative keystrokes for steps 3 on Windows are:
  1. Ctrl + A, Ctrl + A, Ctrl + C, Ctrl + V, Ctrl, V (Windows)
2. Or, click the little carret below the Paste Clipboard to open the paste menu. [Pictured as 3] (Both)
3. Then click the clipboard with "123" in the Paste Values section. [Pictured as 4] (Both)

Page updated

Google Sites

Report abuse