Here’s a quick hack that I’ve put together to help Translation Project Managers (TPMs) figure out quickly the number of resources (translators and reviewers) they’ll need for a project’s given deadline and word count.
Usually, TPMs have to calculate these numbers manually. For small projects this isn’t a concern, but for larger ones things get quite complicated leading to extra time spent on laboring over the math instead of kicking off the project.
The primary project values provided by a client are:
- Start Date
- End Date
- Word Count
These values are enough for calculating the number of translators and reviewers a TPM will need for the project, but I’ve taken it a bit further with my tool and have added the ability to specify an average translator/reviewer daily word output, as well as whether these resources will be working on weekends too. This extra information allows for more refined results.
Thus, along with the 3 values mentioned further above, I’ve added these as well:
- Single translator’s average daily output (in words)
- Single reviewer’s average daily output (in words)
- Will resources work weekends too?
With all the above information at hand, it’s now possible to calculate the number of resources required.
First, we need to come up with the actual days available for completing the project, since this number will allow us to proceed with the remaining number crunching. This is easily done by subtracting the end date from the start date:
Project Duration = End Date - Start Date
Next, to calculate the number of translators the project will need we have to apply 2 division operations; the first divides the project word count by the project duration, and the second divides the outcome of the first division by the single translator’s average daily output. All this could seem confusing, so let’s see how it’s expressed when using simple math:
The same logic is also applied to calculate the number of required reviewers:
To create the tool, I chose to use spreadsheet software (i.e. Microsoft Excel, LibreOffice Calc etc.) which is available on all operating systems. This means that you can easily run this tool just by opening it up in your favorite spreadsheet application. Here’s a screenshot of it with some demo data:
You can download the Translation Project Resource Planner by clicking on this link: Download