Skip to content

Instantly share code, notes, and snippets.

@eduard-un

eduard-un/Automated Stats.markdown

Last active July 14, 2022 08:47
Show Gist options
  • Save eduard-un/e28786b6a7afef23d9cc7bff861e9bd7 to your computer and use it in GitHub Desktop.
Save eduard-un/e28786b6a7afef23d9cc7bff861e9bd7 to your computer and use it in GitHub Desktop.
Download ZIP
How the automated stats works
Raw
Automated Stats.markdown

Strucutre of the files

  1. Master File
  2. Weekly Klaus Score
  3. Monthly Klaus Score
  4. Teammate Template

Master file

In the master file, there are 3 main columns

  • column 1 and column 2 - it contains the Tracker main file ID and the Sheet name coresponding to each week
  • column 4 and column 4 - it contains the TrustPilor main file ID and the Sheet name coresponding to each week
  • column 5 and column 6 - it contains the Weekly Klaus File and the Sheet name coresponding to each week
File ID for the Tracker Sheet Name from Tacker for the week File ID for the TP File Sheet Name from TP File for the week File ID for MHT Sheet Name from Klaus file for the week Teammate's Name
Type in the Tracker's File ID Manualy type the Sheet name for each week from the Tracker File Type in the TrustPilot's File ID Type in the Sheet name for each week from the main TP file Type in the Weekly Klaus File ID Type in the Sheet name for each week from the Weekly Klaus file Teammate's name

Weekly Klaus Score

It will contain a Sheet for each week we do Klaus Reviews. Once the Klaus reviews are done for a particular week, we can export the stats from Klaus as an .xls file and import it to the Sheet coresponding to that particular week. Once that is done, we take the Sheet's name and put it into the Master File in the column named Sheet Name for MHT

Monthly Klaus Score

In this file, into a separate Sheet, coresponding to each month, we can export each month stats from Kalus and import it into this file/sheet.

Teammate Template

Besides the reqular Sheets, there is one custom Sheet called Extras - this sheet doesn't require any edits. Its sould purpose is so that it grabs certain details from the other files, so that the vlookup function can work properly. Sadly the Google Spreedsheet doesn't allow us to use nested importrange functions - that's why we need to use that extra Sheet called Extras. In the Extras sheet, we also have to add the Teammate's name, exactly as it appears in the Tracker File

How it Works

First you will have to enter the name for the teammate, in the Teammate Tempalte file in P2 for example for Drin I will have to type in Drin Loxha - the name should be exactly the same as in the Tracker file.

The only file you will find your editing each week will be the Master file where for each columns:

  • Sheet name for the Week (B2 - B51)
  • Sheet name from TP File (D2 - D51)
  • Sheet name from MHT file (F2 - F51)

You will have to enter the sheet name coresponding to a paticular week from the coresponded main files:

  • Tracker file
  • TrusTPilot stats file
  • Klaus Weekly file
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment