Închis

Finetune an existing Google Sheets Document plus develop a dashboard

I have created a document in Google Sheets that is made up of multiple worksheets. I need this to be further developed by someone with a higher capaability than what i have. The following needs to be acheived:

[1] to Understand the existing formulaes used and if there are better alternatives then to rewrite these. The aim here is to ensure robustness of the calculations and to improve any processing speed.

[2] The design currently allows for a budget to be created for a fixed 12-month period. We need to change this to a rolling 12-month period

[3] To be able to add additional input lines by selecting an 'Add Line' icon. Currently we have to insert a line and then re-write formulaes to allow for the additional lines added.

[4] Monthly P&L data is currently pasted into the document every month from Xero (accounting programme). We need to be able to do this less manually. If you are unfamiliar with Xero, it is a relatively easy programme to allow for this type of feature. I believe there are many apps available to facilitate this.

[5] Need to develop a dashboard to improve the read out of the data. Dashboard to be developed in Google dashboards and ideally this would be displayed in another php built programme/website.

In order to correctly understand this project we will need to talk it through. I am only interested is Freelancers who are already familiar and have expertise with Google Sheets and DataStudio. Preferably also have experience with capturing information directly from Xero.

I have written numerous notes in the document explaining requirements.

To add to this: Would also like to add some forecasting features that are not currently built into the worksheet.

Aptitudini: Google Sheets, Data Visualization, PHP

Vezi mai multe: google plus develop, find a programmer to develop google sheets and other, google sheets pull data from another document, google sheets dashboard addon, dynamic dashboard in google sheets, free google sheets dashboard template, project dashboard google sheets, google sheets dashboard example, google sheets conditional formatting custom formula multiple conditions, project management dashboard google sheets, how to create dashboard in google sheets, google sheets social media dashboard, how to create a dashboard in google sheets, google sheets dashboard, google sheets api dashboard, google sheets kpi dashboard, google sheets plus minus button, hr dashboard google sheets, google sheets mobile dashboard, excel dashboard multiple worksheets

Despre angajator:
( 0 recenzii ) Helensville, New Zealand

ID Proiect: #29968168

19 freelanceri licitează în medie 1395$ pentru acest proiect

(45 recenzii)
6.9
(81 recenzii)
6.8
P0L

(34 recenzii)
6.0
(15 recenzii)
6.1
aleksandrskvor

[login to view URL] for your posting. I am web expert with 7+ years experience in development. PHP, Google Sheets and Data Visualization are my professional skills and I am very familiar on it. Please check my profile in your fr Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 12 zile
(19 recenzii)
5.8
shashank9090

Hello, I have read your job "Finetune an existing Google Sheets Document plus develop a dashboard" We are a team of expert web and mobile app developers who can develop any module/functionality from scratch. Technolo Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 10 zile
(18 recenzii)
5.5
writingapp

Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 1 day

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD în 1 zi
(40 recenzii)
5.4
(16 recenzii)
4.8
Digiexpert90

Hello Hiring Manager, I read your job descriptions carefully, I am very interesting in your job of Finetune an existing Google Sheets Document plus develop a dashboard I have the enough experience and good project don Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 7 zile
(3 recenzii)
4.4
(4 recenzii)
4.3
EuSopht

Hello Sir, Luckily, we have high expertise in google sheets, data visualization and Xero integrations. We can work for you to enhance the sheets and can also integrate xero to get the records on monthly/weekly basis a Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 30 zile
(3 recenzii)
3.6
aruls1962

I am engineer with a lot of of experience in the manufacturing industry. I have been developing systems from the ground up in Google Sheets for the last 7 years. You can read about the complete Human Resource Manageme Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 7 zile
(8 recenzii)
3.4
Raik03

Hello. I'm PHP/Python/React/Vue/Angular expert. I've gone through your job description very carefully, so I think that this is the perfect fit for my skill sets. Because I have already built a large number of websites. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 7 zile
(4 recenzii)
3.1
kingqueen369

Hi, Greetings! ✅checked your project details : Finetune an existing Google Sheets Document plus develop a dashboard ✅Completed Time : 24 hours or your requirement deadline . I would like to work on your project and wa Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 2 zile
(5 recenzii)
3.1
radmirziyatdinov

Hello, how are you? I read your requirement carefully. I am a full experienced web and mobile app developer of over 10 years experiences. I have perfect skills and experiences of developing this kind of mobile apps by Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 7 zile
(0 recenzii)
0.0
sgrisin659

Hi, I am a data engineer/master. I have a vast experience of 10 years with python. My major is web scraping ,data entry,data mining, data analysis and visualization. I can use selenium,beautiful soup,lxml, scrapy an Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 7 zile
(0 recenzii)
0.6
elky01

✋ Hi I am a web & mobile developer with ⭐ 5 years ⭐ of experience.  I can deliver quality products to tight deadlines.  I'm interested to hear more about the projects If you award me the project I'd be very happy to d Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 20 zile
(0 recenzii)
0.0
anushka03367

Hello, I have read your job post and I am interested in the same. I have a B. Tech (Computer Science) and MBA from the very best universities in the country with an acceptance rate of 0.01% of the applicants. I have b Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 7 zile
(0 recenzii)
0.0
nsprudhvi

I've worked on designing dashboards for multiple clients integrating Google APIs and Analytics. Most-customized dashboards which are considered as Best-Cas-Practice for my clients.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% NZD în 7 zile
(0 recenzii)
0.0