Script to find values and calculate payroll

Completed Posted 1 year ago Paid on delivery
Completed 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

Applescript Data Processing Data Analytics Database Programming Scripting

Project ID: #34385292

About the project

9 proposals Remote project Active 1 year ago

Awarded to:

(65 Reviews)
6.6

9 freelancers are bidding on average $136 for this job

monicawriter99

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

$115 USD in 2 days
(11 Reviews)
4.6
sambestsolutions

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

$140 USD in 7 days
(7 Reviews)
3.3