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

Rod Walters  Identity Verified
Japan
Local time: 23:28
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!


Direct link Reply with quote
 

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

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

Direct link Reply with quote
 

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

Yes, thank you.

A modest trip is on the cards.


Direct link Reply with quote
 

ViktoriaG  Identity Verified
Canada
Local time: 10:28
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.

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 »

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 »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



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