Find Jobs
Hire Freelancers

Google Sheet Chart Whiz

$30-250 USD

Fullført
Lagt ut over 5 år siden

$30-250 USD

Betalt ved levering
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.
Prosjekt-ID: 18203073

Om prosjektet

32 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
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 dynamic dashboards and Reports. I created a sample for your data an put dummy data for data set: [login to view URL] Please if you like and edit needed let me know, It can be connected to google sheet and update automatically when new data is added. you can replicate it using new data. I have completed many similar projects before, you can check some of my previous works here. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Please send me a message to discuss more. Thanks
$100 USD om 3 dager
4,9 (106 omtaler)
6,3
6,3
32 freelancers are bidding on average $153 USD for this job
Brukeravatar
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 or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Javascript, Visual Basic. Please ping me for more discussion.
$150 USD om 2 dager
4,9 (535 omtaler)
8,5
8,5
Brukeravatar
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 om 2 dager
4,9 (490 omtaler)
7,4
7,4
Brukeravatar
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 om 3 dager
5,0 (129 omtaler)
6,7
6,7
Brukeravatar
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 companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU, GOOGLE and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$500 USD om 3 dager
4,7 (96 omtaler)
7,0
7,0
Brukeravatar
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, Google sheet
$194 USD om 4 dager
4,7 (104 omtaler)
6,3
6,3
Brukeravatar
"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 working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$200 USD om 2 dager
4,9 (25 omtaler)
4,9
4,9
Brukeravatar
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 days. Thank you. You can also chat me up with your budget. Thank you
$150 USD om 3 dager
5,0 (7 omtaler)
3,1
3,1
Brukeravatar
Hello, I am Pooja Rohra, Computer Instructor and Manager in reputed firm. I have plenty of experience doing Ms office work. I have read your job post and feel fit for such job.
$155 USD om 3 dager
5,0 (2 omtaler)
2,7
2,7
Brukeravatar
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 previous company and I could deliver the charts you need in a very short amount of time. If you have any questions, please feel free to send me a message. I would very much appreciate if I could work with you on this project :)
$100 USD om 2 dager
5,0 (4 omtaler)
2,5
2,5
Brukeravatar
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 regards
$61 USD om 1 dag
5,0 (1 omtale)
0,6
0,6
Brukeravatar
I am excellent in preparing excel macros & vba & integration excel with system. I can automate your work in a very simple manner & make your business accurate & easy I am passionate about my work & I meet the deadlines on time. I am Hardworking & disciplined towards my job roles and I always look up to challenging new things.
$222 USD om 3 dager
0,0 (0 omtaler)
1,3
1,3
Brukeravatar
Dear Employer, Greetings. I have seen your job details as well as your attached file. I have previous experienced on data processing, MS excel, google spreadsheets, chard design. Please give me a chance to handle your job. Thank you. Regards, Mrikongkan Mondal
$133 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
""Dear Next Employer We will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar projects I've completed. Thanks""
$144 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi there! I am offering a job assistant for your business concentrating paper work reports. I provide good and quality service in terms of web research, appointment setter, posting ads and lead generation. I’m great in multitasking with a little amount of guideline so if you’re looking for reliable hardworking and detail oriented person feel free to message me so we can talk about the job and start working on it. Thank you.
$30 USD om 5 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I'm well known about excel data entry and also formula. I'm post graduate doing Masters in Accounting and also good knowledge about computer program like MS Word, Excel, PowerPoint, Internet, E-mail etc. I doing practical job a govt organization. My work experience is 13 years. I look forward for approval my bid.
$30 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
"Greetings! According to your stated project description you need an Google sheet and excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your requirements to start your project. I think no need to talk about the quality because I think provided work will proved it. I will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response. Best Regards."
$200 USD om 3 dager
5,0 (2 omtaler)
0,0
0,0
Brukeravatar
I am having experience of working as MIS expert in project planning and execution for one of the company based in India. If you wish i can some samples of charts and table templates prepared by me. Here task i have to complete is easy for me and i have completed such lot of task. As I am new here, I am willing to do this job at your price. please let me know any of your requirement.
$35 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 easily. I am hardworking too, i hope i will do this job better.
$155 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi this is Harish
$155 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Sir I'm a computer engineer. I'm a good learner or hard worker. This is the platform to exploring my self. In the word i'm not able to show my talent so give me a chance to prove myself I'm work in digital india data entry project. I'm also work in HTML for web deigning..
$155 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

AUSTRALIAs flagg
Potts Point, Australia
5,0
14
Betalingsmetode bekreftet
Medlem siden des. 4, 2012

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.