Need to use data from spreadsheets to create a summary spreadsheet

Closed - This job posting has been filled and work has been completed.
Data Science & Analytics Quantitative Analysis Posted 1 year ago

Hourly Job

Hours to be determined
Less than 1 month

Entry Level

I am looking for freelancers with the lowest rates


I have spreadsheets with data I need to be compiled into one main spreadsheet and then the data needs to be shown as different metrics on a dashboard.

Each spreadsheet is a separate job with an expense summary with three different tabs and there is information in each tab that will need to be extracted job reimbursed expenses, payroll, total expenses.

I have a current template of the summary page tab, but would like there to also be a dashboard to show current expense vs income (by job and total (able to separate by dates) and be able to show cost per job, etc.

There will also be additional metrics that I will provide that will need to be added.

I would prefer either there to be a macros or scripts written to automate the process once I can add a new excel sheet of data. Must be able to work with me on making this easy to change and easy to add more metrics.

Please show me that you are able to do this with a previous example of spreadsheet done. I will have additional jobs as such which will require help as well.

About the Client

(5.00) 4 reviews

United States
Industry 10:28 AM

12 Jobs Posted
59% Hire Rate, 1 Open Job

$2,400 Total Spent
7 Hires, 2 Active

$8.14/hr Avg Hourly Rate Paid
244 Hours

Member Since Feb 12, 2014