Capstone: Revenue by Client & Language Pair, Effective Hourly Rate & a Client Chart
This lesson is part of the course
In this lesson
You summarise four months of jobs by client and language pair with SUMIFS, calculate the effective revenue per hour for each client and chart the revenue by client.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Units of Work: Words, Characters, Standard Lines & Text Expansion Locked
- Weighted Word Counts: Repetitions, Fuzzy Matches & a Discount Grid Locked
- Setting Your Rate: Income Target, Billable Hours & the Rate per Word Locked
- Throughput & Delivery: Words per Day, WORKDAY Delivery Dates & Rush Fees Locked
- Minimum Fees, Post-Editing & Proofreading: What Each Service Earns per Hour Locked
- Agency vs Direct Clients: Payment Terms, Days Late & the Agency Margin Locked
- The Localisation Quote: Languages × Weighted Words, Layout Pages & a Project Fee Locked
- Capstone: Revenue by Client & Language Pair, Effective Hourly Rate & a Client Chart Locked