Excel File (Google Sheets) with calculation of earnings per month per employee
- or -
Post a project like this2673
$$
- Posted:
- Proposals: 13
- Remote
- #1376946
- Awarded
Data Entry,CAD, Sketchup, Adobe PDF, Data research, PDF Interactive Forms, Adobe Photoshop, Book Scanning in JPEG or .tif format
Thane
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
excel spreadsheet developper, online researcher, english to french translator
Douala
126714034224773285074066513004491336198134942014119391419711142014214386871440148
Description
Experience Level: Intermediate
I need an Excel File of my monthly projects where I can get a calculation of the amount in dollars a freelancer will be paid at the end of the month.
You can view the sample sheet we currently use to follow projects.
A line contains the name of the employee (drop-down list), the Word count he has to translate, the Word count of fuzzy matches (at a different rate than the New word count)
I need each line to automatically calculate the amount by employee's name ( drop-down list) so that at the end of the month I automatically get the total earned by employee.
I'd like 12 identical sheets (one for each month) and only one sheet showing the earnings calculation by month by employee (so 13 sheets total).
If at all possible, I'd also like to be able to keep track of trends of word count by clients/day/weeks/months too, but that's not the priority.
One thing worth nothing, we use Google Sheets online, not Microsoft Excel desktop.
That's it for this project, I await your proposals
JS
Josie S.
100% (10)Projects Completed
11
Freelancers worked with
11
Projects awarded
33%
Last project
11 Dec 2016
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi i am Ahmad and interested in your good job.
Please may you clarify that how much you would be paid ...?
i-e per word translated or 500 words or more etc.
246569
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies