Google Spreadsheets Dashboard

$15-25 USD / hour

Teljesítve

Kiadva ekkor:

több mint 3 évvel ezelőtt

$15-25 USD / hour

Hello,   We are using two Google Spreadsheets to run our proxy business where each Spreadsheet has a bunch of individuals sheets that we manually update and some sheets are dynamically updated by grabbing information from our other spreadsheet or different sheets within the same spreadsheet. What we are looking for is someone that can build us a fancy dashboard where we can easily view some data from our spreadsheet that is dynamically updated as data is entered by our staff throughout the day. Some of the items we are looking for on the dashboard which would be dynamically updated as data is entered into the original Google Sheet would be… 1. Idle Proxy Licenses 2. Proxies Ending Today 3. 1Day + 12Hr Ending Today 4. Total Projected Idles Today 5. Gross Revenue (Current + Trending Over Time) 6. Profit (Current + Trending Over Time) 7. 50/50 Cut (Current + Trending Over Time) 8. Cash Balance (Current + Trending Over Time) 9. Currently Active “12Hr Orders” 10. Currently Active “24Hr Orders” 11. Currently Active “Monthly” “Weekly” and “Single-Locations” with revenue for each of those 3 items listed. We want another sheet (or page...etc) where we can see hourly snapshots of our gross revenue, profits, 50/50 splits, and idle proxies where we can see a nice graph to view hourly trends over time. Your dashboard will need to capture and chart this data every 60 minutes. Here are censored copies of our two datasheets we use to give you the best understanding of what we currently have and how one pulls data from another sheet or the other spreadsheet…etc  [login to view URL] [login to view URL] Sample Dashboards we like: [login to view URL] [login to view URL] Sample Dashboards we do NOT like: [login to view URL] [login to view URL] We want our dashboard to either be in Google Sheets or some other secure page/app where only authorized users can access and we would like for it to be mobile-friendly. Freelancer should be experienced with building custom dashboards and working with advanced Google Sheets data. Please send us examples of dashboards you have already created. We tend to ignore bids that appear to be copy & pasted and highly prefer bids where it shows that you took the time to read our project, view the sample data, and spend at least a few minutes giving us a custom bid. Looking forward to working with you!

Projektazonosító: 27058801

A projektről

22 ajánlat

Távolról teljesíthető projekt

Aktiválva: 4 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@dvcontact

$0 USD 40 napon belül

5,0

(43 értékelés)

6,4

22 szabadúszó adott átlagosan $22 USD/óra összegű árajánlatot erre a munkára

@schoudhary1553

Hi, Greetings! ✅checked your project details: Google Spreadsheets Dashboard ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. 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. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast

$25 USD 40 napon belül

5,0

(299 értékelés)

8,0

@tangramua

Hello, Our team has a huge experience in JavaScript, Data Processing, Excel VBA, Excel Macros, Google Sheets, as a result, we can successfully complete this project. Having the required skills, we will be glad to help you. We have 20 years of strong experience in outsourced web development, software development, managed services, and we provide 24/7 technical support. As well as we guarantee Canadian quality. Please, review our profile to find detailed information about our company and our portfolio. Feel free to contact us and discuss all the details. Best regards, Sales department Tangram Canada Inc.

$25 USD 5 napon belül

5,0

(19 értékelés)

5,6

@CeMaGaRa

Hi there. I am very interested in your project. I have powerful skills in d3.js and data visualization. I have developed many dashboards with complex analysis charts using d3.js. Please check my portfolio and client feedback. Let's discuss for your detail. Regards. Cesar.

$20 USD 40 napon belül

4,8

(15 értékelés)

5,3

@PKonstiantyn

@@@@ Hello! @@@@ My name is konstiatyn who is professional in Visual Basic, Data Processing, Data Entry and Excel. I am very interested in your project”Google Spreadsheets Dashboard”. I have gone through your description carefully and understand what u need. I have ever done similar project. I’ll never let u down and waste your golden time. I don’t also bid on any projects which I am not sure to do. Please ping me to discuss in detail over chat. Best regards.

$20 USD 40 napon belül

4,9

(10 értékelés)

4,4

@tdream92

Hi I have read your requirements carefully as well as URL and i can implements all according to your requirements perfectly I have talented skills with Excel VBA and Google Sheets, Google Sheets API etc and i have done many projects before If you want i will share my work for your consideration Let's discuss more for your project I will work very harder for your project Tahnk you

$15 USD 40 napon belül

4,8

(7 értékelés)

4,4

@RavenSolutions

Yo! I have went through about your project Google Spreadsheets Dashboard I am skilled in Google Sheets, JavaScript, Data Processing, Excel Macros and Excel VBA, so I'am totally sure I can deliver Your project ! Please send a message to discuss more regarding this project. Thank you

$15 USD 40 napon belül

5,0

(2 értékelés)

3,8

@sg11513

Hi, Greetings! I can get you the dashboard you like. I have experienced Tableau and Database Visualization , I have done many assignments in PowerBI and Tableau. recently I have done similar assignment for one of our USA real estate client. I create for your business in power BI or i would suggest latest Tableu technology. I have 12 years of experience in Power BI, Business Intelligence and 4 years in Tableau. Worked on many projects in MNCs like ZARA and H&M. I know both Tableau desktop and server, along with Tableau I have experience in SSRS, SSAS , SSIS plus almost all type of excel reports. I can help you to create sales dashoboards for your business. Can we discuss more details on chat? Best Regards Sanju Gupta

$20 USD 40 napon belül

4,8

(9 értékelés)

3,9

@webanis

Hello! I am very interested in your post project. I am really looking for this kind of project for a long time in freelancer since i have rich experience on it. I think this project is very suitable for me and i am sure i can give you good result . If you award me for your project, you will get good result . looking forward to work with you. thanks regards

$20 USD 40 napon belül

5,0

(11 értékelés)

3,4

@minayzaw

Hi, how are you? I just read your job posting and checked Google sheets, images. It sounds like you need an expert to build automated Google sheets data update module and dashboard. I have a background in Google sheets, Google docs api, data visualization, dashboard development etc. Data visualization using D3 js and statistical dashboard are what I specialize in. I highly recommend to build web based dashboard which has secure authentication. If you give me mockup design, I will give you high secure, user friendly dashboard what you want. If you want to collaborate with me lets discuss it in mode detail over the chat. Best regards, Min N.

$20 USD 40 napon belül

5,0

(1 értékelés)

2,3

@KennethLubaton

Hi, I'm Kenneth Neil Lubaton, and I would like to apply for the job posted. I worked from the Philippines (UTC+8). I started working as an online freelancer/virtual assistant back in 2015. I have been working as freelancer for more than 5 years now and I have already established a remote working environment. I have worked for a Debt Settlement Company from US and dealt with legal document processing and collection, so as to updating our CRM (Salesforce) with the relative legal status. I also have these roles with them, I'm a Payment Specialist doing outbound calls to schedule payments for the settlement agreement with creditors. I am also a Correspondence & Legal Document Processing - Assistant Team Leader in which I managed receiving and associating documents that were requested to our clients. Email handling, data entry and all around document processing were also my previous duties. As an experienced freelancer, I am keen to details, which is significant to my previous job for it involves review of settlement documents that even difference in payment dates, and variance in amounts up to the centavo level are considered crucial. What sets me apart from other Virtual Assistants is my passion for excellence. This passion is vital to the success of your overall business goals. I am detail oriented, makes my involved with the company's decision making, explore every roles that I could extend my service.

$20 USD 40 napon belül

0,0

(0 értékelés)

0,0

@anugris

I'm interested your project l. I can be administration support and I can fast to do your project. I can achieve the result that your asking for.

$15 USD 48 napon belül

0,0

(0 értékelés)

0,0

@khairulbasar1

Hi, This very interesting project. Let me clear you your dashboard choice perfectly fine and I can tell you I would love to make you such dashboard - either in googlesheet or in webpage (html/csss) though Google App Script - a feature within googel sheet available for such perpose. I am currently involved in such project where dynamic data fetching from different website, of spreadhseet thorugh API. I will love to collaborate with you - hope this will continue for long time. Your Invitation over a private chat would be highly appreciated.

$20 USD 40 napon belül

0,0

(0 értékelés)

1,0

@pwilsonqld

Software bridging Solutions would utilise Google forms or Jotforms for data entry in conjunction with Google sheets for the response sheet (Database Sheet). Database sheets would be protected and dashboards to query the databases and form url links for data editing directly from the dashboard. Separate secure dashboards for each staff member customised for each person with only the data requirements needed for each individual The issue l see with the way you are populating your spreadsheets cell by cell is the potential to overwrite by mistake and the limitation because you cannot query the data and edit from the query on the fly as needed. Using query in sheets, data can be manipulated. Dynamic search fields can be set-up based on any search criteria. Forms for data entry would provide automation to populate response sheets. Using query with importrange we can create a one to many relationship with all sheets and data with edit function across all queries and data is updated live, safely and across all dashboards as needed.

$56 USD 20 napon belül