It needed to calculate the number of words required (allowing for three differing methods by which the user could submit their text) and to also take into consideration over 300 languages, all of which can be translated into any other language, with each combination providing a different price point.
Not only can the user select up to five language combinations, but the quote system also needed to calculate an additional “advanced service level” (whereby the translators offer additional services) as well as the standard metric.
I designed and implemented the MySQL database, as well as the PHP code that runs the system and the final front-end layout.
A lot of creative thinking was required; the system I created allows for a variety of needs, methods of input, and tens of thousands of language combinations. The user can submit either a word-count, paste their text for an automatic count, or even upload files directly to get their quote.
And of course all this information is packaged up, emailed back to the user and the company, and is also maintained in a custom-built administration system I created for them.
One of the things I’m proudest about with this system is that the company came to me with a concept, which together we fleshed out into something that has revolutionised how they work.