Script to find values and calculate payroll
$30-250 USD
Paid on delivery
in Numbers i need a script to search each employees data and subtotal for 2 pay rates depending on certain words in each line as long as the pay column is not 0.
Then on a new tab but same worksheet, list the name, total for each employee and grand total for all employees.
Basically, if the dollar column is not 0, check for certain words to add to either 'admin' or 'teaching' subtotals. list the subtotals at the end of each employee by adding 2 rows. Then add subtotals on a new tab for totals and grand total.
Deadline: up to August 25th
Project ID: #34385292
About the project
Awarded to:
9 freelancers are bidding on average $136 for this job
Hey employer, I hold a Master's degree in Economics and statistics making me a suitable person for your project " Script to find values and calculate payroll ". I have more than 3 years of professional experience in s More
Hi I am an Engineering undergraduate experienced in data analysis and data processing. I can create you a script to find values and calculate payroll as per your requirement. Please message so we can further discuss Th More