Find Jobs
Hire Freelancers

Google Sheet Chart Whiz

$30-250 USD

Abgeschlossen
Veröffentlicht vor mehr als 5 Jahren

$30-250 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 18203073

Über das Projekt

32 Vorschläge
Remote Projekt
Aktiv vor 5 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 in 3 Tagen
4,9 (106 Bewertungen)
6,3
6,3
32 Freelancer bieten im Durchschnitt $153 USD für diesen Auftrag
Avatar des Nutzers
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 in 2 Tagen
4,9 (535 Bewertungen)
8,5
8,5
Avatar des Nutzers
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 Tagen
4,9 (490 Bewertungen)
7,4
7,4
Avatar des Nutzers
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 Tagen
5,0 (129 Bewertungen)
6,7
6,7
Avatar des Nutzers
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 in 3 Tagen
4,7 (96 Bewertungen)
7,0
7,0
Avatar des Nutzers
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 in 4 Tagen
4,7 (104 Bewertungen)
6,3
6,3
Avatar des Nutzers
"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 in 2 Tagen
4,9 (25 Bewertungen)
4,9
4,9
Avatar des Nutzers
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 in 3 Tagen
5,0 (7 Bewertungen)
3,1
3,1
Avatar des Nutzers
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 in 3 Tagen
5,0 (2 Bewertungen)
2,7
2,7
Avatar des Nutzers
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 in 2 Tagen
5,0 (4 Bewertungen)
2,5
2,5
Avatar des Nutzers
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 in 1 Tag
5,0 (1 Bewertung)
0,6
0,6
Avatar des Nutzers
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 in 3 Tagen
0,0 (0 Bewertungen)
1,3
1,3
Avatar des Nutzers
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 in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
""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 in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
"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 in 3 Tagen
5,0 (2 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi this is Harish
$155 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von AUSTRALIA
Potts Point, Australia
5,0
14
Zahlungsmethode verifiziert
Mitglied seit Dez. 4, 2012

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.