Google Sheet Chart Whiz

We have a report that we have generated with around 3500 rows of data. These are shifts that our workers have worked. We want to be able to have a Google Sheet where we import data like this each week and it populates predetermined charts and graphs.

I need someone who is at super advanced Google Sheet skills to be able to create a template spreadsheet so that we data dump into sheet 1, and then all beautiful charts are created on subsequent tabs/sheets.

This reporting has a column called "State". The State defines a company level. Therefore, we want to create the below reports at Total Company (Both States) and then at each Company (SA and NSW)

1. Total Number of Shifts per day as line graph (show SA and NSW as separate lines and a combined total line)

2. Total Number of Shifts per Activity (pie chart, one for SA, one for NSW and one combined)

3. For top 5 Customers for each State (with the most shifts) create chart for each customer showing number of shifts on each Jobsite

4. For top 5 Customers for each State (with the most shifts) create chart for each customer showing number of shifts for each activity

5. Average Rating: Table showing average rating of worker for each customer

6. Worker Feedback: Table for top 5 customers in each state showing worker feedback for each shift.

Example data attached (except for Rating and Worker Feedback) - assume the Rating is numerical between 0 - 7 for each shift and assume Worker Feedback is text for each shift. Will be available to successful candidate.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Javascript, Visual Basic

Veja mais: google sheets chart types, comparison chart google sheets, google charts, how to make a graph in google docs, 3d chart google sheets, how to label legend in google sheets, how to add text to legend in google sheets, how to make a line graph in google sheets, google finance chart creator, google candlestick chart source flex, google finance chart, google finance chart flex, google finance chart clone, flash google analytics chart, google bsb chart, google financial chart flash, google stock chart javascript, google finance chart flex source code, google finance chart javascript, google finance chart adobe flex

Acerca do Empregador:
( 3 comentários ) Potts Point, Australia

ID do Projeto: #18203073

Concedido a:


Hi, I am expert in Excel, Access VBA, MySQL, Google Sheet and Power BI. I can database and can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time dyna Mais

$100 USD em 3 dias
(57 Comentários)

33 freelancers estão ofertando em média $154 para esse trabalho


I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Mais

$150 USD in 2 dias
(326 Comentários)

Dear client Thanks for the nice description of the scope of work. I can do this for you at ease. I will build a dashboard for you with all the requirements you mentioned. kindly contact me. Roy

$200 USD in 2 dias
(293 Comentários)

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Mais

$500 USD in 3 dias
(68 Comentários)

Sir, I am well versed in these kind of jobs and can do your project as per requirement. ***I am ready to start Waiting to hear from you. with thanks and regards Relevant Skills and Experience Data entry, Goog Mais

$194 USD in 4 dias
(103 Comentários)

Hello, I am experienced excel/google sheet expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$200 USD in 3 dias
(64 Comentários)

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Mais

$200 USD in 2 dias
(23 Comentários)

Hello! I have understood your requirements and I can create a google sheet that auto-generates all the charts when you paste data into sheet 1. Please award the project to me and I can complete the task using 2 - 3 day Mais

$150 USD in 3 dias
(7 Comentários)

Hello, I use excel effectively in my day to day job. I can provide you with an effective and efficient solution. Happy to discuss. Please refer following to know who we are and what we do. Thank you. We are Mais

$111 USD in 3 dias
(6 Comentários)

Hello there! I'm incredibly proficient with google sheets and know most, if not all, of the functions and scripts that go along with it. I've been working with google sheets to create a centralized database for my prev Mais

$100 USD in 2 dias
(2 Comentários)

Dear Sir, Greetings, we are group of people efficient in advanced excel, google sheets, data scabbing etc. We welcome you to talk over chat and discuss. we promise you to deliver this work on time. Thanks and Mais

$61 USD em 1 dia
(1 Comentário)

I have worked a lot with google spreadsheets, even my personal business KPIs are implemented up there. I hope you will find the best solution for you, and can have some quality result.

$120 USD in 2 dias
(0 Comentários)
$155 USD in 3 dias
(0 Comentários)

Hi there, This project is quite similar to other tasks that I am often performing in my regular job. I am a strategic transport modeler from Melbourne. When I am not using specialised software, most of what I do is Mais

$180 USD in 2 dias
(0 Comentários)
$150 USD in 3 dias
(0 Comentários)

HI , Please assign this project to me I have the experiance to hande those kind of projects Thanks, Saurabh 889212770

$166 USD in 2 dias
(0 Comentários)

Hi Sir I'm waiting to complete your task Relevant Skills and Experience Content writing blog designer website designer software developer virtual assistant

$155 USD in 3 dias
(0 Comentários)

I have hands on experience in Google Sheets and can complete the requested work as soon as possible with high accuracy

$155 USD in 3 dias
(0 Comentários)

I'm good in excel to generate report with chart, pie, pivot table.

$155 USD in 5 dias
(0 Comentários)

16 years experience in software development and quality assurance.

$155 USD in 3 dias
(0 Comentários)

Hey! I want to do this job. I hope my work will be beneficial for you. I have good command on MS office. Can you please hire me? Relevant Skills and Experience I have basic knowledge of MS excel,can also input data ea Mais

$155 USD in 3 dias
(0 Comentários)