<aside> 🚧 The assessment spreadsheet is under testing for now. We are still working on fine-tuning the formula. We strongly encourage you to use it as a reference and use your best judgment to assign the final score as you have been doing so far using Typeform estimation. Please share your feedback with us on the Reviewers’ Discord Channel when the score suggested by the spreadsheet strays too much from the score you consider would be fair.
</aside>
As a Reviewer, you want to be sure that the score you are assigning is fair and mirrors the actual level of the job in terms of quality and customer readiness. How to do that?
While reviewing, you have been remembering by heart the examples you wanted to include in the feedback or taking notes on a separate document. How to find a more efficient way?
To help you in this double challenge, we created an assessment spreadsheet you can use as both a reference to calculate the score to assign to the job you have reviewed AND a tool to take notes while reviewing.
Before, while correcting a file, I open a .txt document where I copy + correct every mistake + explain + write the corresponding paragraph from the guidelines. While doing the corrections now, I open the spreadsheet and I copy/paste every correction that counts in the spreadsheet. When I finish, I copy the whole spreadsheet, rename it "score", change the cells into numbers + add the number of words from the change report and I have the score. Also, if I hesitated between 2 scores, I would keep on reviewing several times as I want to avoid the situation where I'm giving an unfair score. Now, I don't have this situation anymore.
From a Lovely Reviewer from the Tribe 🥰
Let’s check together how to use the spreadsheet step by step.
Open the Google spreadsheet and make a copy to work on.
Change the word count of the file you have reviewed. You can find the word count in the Changes Report. The score is calculated by weighting the issues by severity against the total amount of words.
Insert the number of issues you spot per each category. You can use it as a tool to take your notes while reviewing.
Check the result the spreadsheet suggests to you.
Remember: you are the one making the decision on the final score to assign to the job. The spreadsheet calculation is just a reference to help you be fairer.
<aside> 😟 Files where customer requirements are not met should never be rated higher than a 3/5. This includes: failing to apply the correct CPL or CPS, failing to implement words from a glossary, and omission of verbatim or SDH elements, amongst other things. An accidental mistake can still warrant a 4/5, but if the requirements are continuously not met, a grade of max. 3/5 can be given.
</aside>
<aside> 💡 The spreadsheet replaces the Typeform you have been completing to receive the estimated score so far.
</aside>