Job charge calculator utility?
Thread poster: Soluna

Soluna
English to German
Dec 11, 2006

Hi

Using Trados, I often have to calculate invoice amounts based on my rate per thousand and then applying percentage discounts for 100%, fuzzy etc. Does anyone know of a way of automating this process somewhat so that my calculator doesn't get overworked? I am thinking maybe of an Excel routine (but I know next to nothing about calculations in Excel) or a little custom utility.

There must be thousands of us doing these calculations every day, so I don't want to reinvent the wheel.

Thanks
Dagmar


Direct link Reply with quote
 
Helen Filippou
Local time: 11:24
English to Spanish
+ ...
Formulas in Excel Dec 11, 2006

Hi Dagmar

If I am not misunderstanding your concern, I would think that you need an Excel sheet with formulas in the cells, so that your calculations will be automatic.

However, in order to explain to you what type of formulas you will need and how to express them in excel, I would need an example.

If you want to pursue this, please email me at eleni412006@yahoo.ca and I would be pleased to help if I can.

Good luck
Elena


Direct link Reply with quote
 

Soluna
English to German
TOPIC STARTER
We have it! Dec 12, 2006

Okay, with the help of Elena and a good friend, we have made an Excel sheet which will allow us to cut and paste data directly from a Trados analysis log file and automatically work out the charge for each translation file.

If you want a copy, please contact me in the usual way. It will probably need a bit of tinkering with to fit your exact requirements (eg the percentages awarded for each match type will change according to the client, no doubt).

Dagmar


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Job charge calculator utility?

Advanced search







memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search