Google Sheets/Google App Scripts - Improving Spreadsheets Performance

We are currently using Google Sheet as a positions dashboard; we basically have a theoretical working solution, but it’s simply performing too slow. So we are currently looking for an individual with the skills and knowledge of Google Sheet and Google App Scripts. The job will require the individual to rewrite our logic from using formulas into Google Apps Scripts, removing any volatile functions and formulas (such as ImportRange etc.) and avoiding any long calculation chains, in order to optimise the Spreadsheets performance.

If you have expertise in the field and are interested in the position please answer the questions below. Please note only those that answer the questions will be considered.

1. How much experience do you have in this area of expertise?

2. Have you done any projects Google Sheets and Google App Scripts before?

3. If you could use a better solution to meeting the projects goals, what would it be and why?

4. What will be some methods you will use to reduce performance issues, eg. slow loading spreadsheets?

Taidot: Google Sheets, Komentosarjan asennus, Excel, Google Docs

Näytä lisää: google app scripts, app scripts for google sites, app scripts in google sites, google sites app scripts, google sites app scripts examples, how to sort in google sheets app, how to search in google sheets app, insert image google sheets app, google sheets app, creating an app database that works with google sheets, how to use google sheets app, how much is google sheets app, open link in google sheets app, google sheets app sort multiple columns, google sheets app sort range, text to columns google sheets app, how to freeze cells in google sheets app, google app scripts templates, scan to google sheets app, print from google sheets app

Tietoa työnantajasta:
( 2 arvostelua ) Wellington, New Zealand

Projektin tunnus: #28267769

11 freelanceria on tarjonnut keskimäärin $162 tähän työhön

(61 arvostelua)

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

$240 NZD 3 päivässä
(67 arvostelua)

Hello, I have done lots of project in google app script and google sheet automation. If you want to check then you can see in my profile reviews for that. We can remove some extra defining var and much more. But i can Lisää

$100 NZD 4 päivässä
(5 arvostelua)

Hi, I read your project brief. I'm listing below answers to your questions. A1 -> I have more than 2 years of experience in writing Google Apps Scripts for G Suite Apps specifically for Google Sheets. My experience in Lisää

$125 NZD 3 päivässä
(2 arvostelua)

I am an engineer with 35 years experience in the manufacturing industries. 1. How much experience do you have in this area of expertise? 35 years in the IT field. I have 7 years experience in google sheets and app sc Lisää

$140 NZD 7 päivässä
(3 arvostelua)

Hi there, I have good experience in google app scripts. 1. I have more than 1.5 years of experience in writing Google Apps Scripts 2. I have done many Google Apps Scripts based on different projects. 3. I am thinking Lisää

$160 NZD 1 päivässä
(1 arvostelu)

Hi I have expertise in excel and can help you in completing your project successfully. I have experience on 1) Creating Excel Dashboard 2) Creating macros using Visual studios 3) Google spreadsheets for customised Lisää

$140 NZD 7 päivässä
(3 arvostelua)

Hello, To answer your questions: 1. EXPERIENCE: 4 years into VBA coding for excel, 4 years in Google sheets and 6 months for Google scripts ( I am constantly learning with challenging projects.) 2. PAST PROJECTS: Yes, Lisää

$100 NZD 5 päivässä
(1 arvostelu)

I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, data scraping, virtual assistant. I hope your kind response.

$100 NZD 7 päivässä
(0 arvostelua)

Hi oh cool !! Nice request we really happy to see your request I've properly checked and understand exactly what you need, we are team and of course we are over 5 years of experience in the field so been here you are i Lisää

$278 NZD 3 päivässä
(0 arvostelua)

Hello, i have been a power user of google sheets for the past three years and Google App Script for a year now. I recently concluded a project where i had to fetch emails of job interview applicants after they summite Lisää

$200 NZD 7 päivässä
(0 arvostelua)