Off topic: Screwing yourself with Excel formulae
Thread poster: Rod Walters

Rod Walters  Identity Verified
Japan
Local time: 18:22
Japanese to English
Jul 2, 2009

Last month, most of my work has been from one client, translating a big corporate report. A few files came every day, and I recorded the word count and fees in an Excel file as usual. And as the month progressed towards the last day and closing of accounts for the month, my mood became bleaker and bleaker. Gosh, this recession is really biting, I began to think. This is dire. At this rate, we won't be able to take a summer vacation at all.

But then just as I was about to send off the invoice, I glumly clicked through the Excel sheets looking for trivial mistakes. And found one!

At the beginning of the month I'd done a small job at a slightly discounted per character rate and forgotten to adjust the formula in subsequent cells to the full per word rate. Hence my projected income for this month was less than half of what it normally is.

Sometimes we think we're rather clever and that we've mastered equanimity to some degree. But something as insubstantial as an Excel formula can blow all of that away!


 

Derek Gill Franßen  Identity Verified
Germany
Local time: 11:22
German to English
+ ...
So, ... Jul 2, 2009

...do you get to take a vacation now that you've discovered the error?icon_wink.gif

 

Rod Walters  Identity Verified
Japan
Local time: 18:22
Japanese to English
TOPIC STARTER
I do Jul 2, 2009

Yes, thank you.

A modest trip is on the cards.


 

ViktoriaG  Identity Verified
Canada
Local time: 05:22
English to French
+ ...
You almost screwed yourself Jul 2, 2009

You only would have screwed yourself if you had used the faulty calculations to invoice the client. It only goes to say it is best to double-check things before sending them off. Like before you send off that big corporate report translation.

 


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


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

Screwing yourself with Excel formulae

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
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 »



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