Google sheet speed optimize

Închis Postat la acum 7 ani S-au achitat serviciile după ce au fost prestate

$30-250 USD

S-au achitat serviciile după ce au fost prestate

Închis S-au achitat serviciile după ce au fost prestate

I'm looking for Google Sheet/Excel Expert to solve my "Inventory Sheet" speed. I need to speed this thing up at least 100x times which mean it needs smarter algorithm to run for the same result.

You can see the sheet here: https://docs.google.com/spreadsheets/d/1HJvWljyRgWWiDAIZkc7UYnCDsXjkoTdLjTnJwwH89bo/edit#gid=230492099

Explanation:

This sheet is mainly collecting all product inventory in the company. It has 2 types of product:

Type 1. Product with serial number; imagine an iPhone 7 Black 64GB. Each one will have different serial number. This will be track in Sheet 1 - Tracking and all report will be calculated in Sheet 3 - Report.

Type 2. Product without serial number; imagine pens. All Black ball point pen with 0.5 mm. head will be counted together. This will be track in Sheet 2 - Tracking No SN and all report will be in Sheet 4 - Report no S/N.

Requirement:

Optimize sheet calculation speed at least 100x times when it get data input. It is possible to suggest better data input method.

Excel

ID Proiect: #13008522

Detalii despre proiect

11 propuneri Proiect la distanță Activ acum 7 ani

Vrei să câştigi ceva bani?

Avantajele licitațiilor de pe Freelancer.com

Setează-ți bugetul și intervalul de timp
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte

11 freelanceri plasează o ofertă medie de 142$ pentru proiect

Fotografia de profil a utilizatorului cgullapalli
cgullapalli

Hi, I am good at Google sheet and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work Mai multe

$250 USD în 3 zile
(1164 recenzii)
8.4
Fotografia de profil a utilizatorului P0L
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD în 1 zi
(486 recenzii)
8.0
Fotografia de profil a utilizatorului asifdwan
asifdwan

Hi there! I am an expert on any data entry jobs and I’ve lot of experience on this type projects.. I’m ready to start it right away. I look forward to hearing from you. Regards

$155 USD în 3 zile
(248 recenzii)
7.2
Fotografia de profil a utilizatorului mdkass
mdkass

Hello, I can make an add-on inside the google spreadsheet to enter data, or a Google web app to submit date into the spreadsheet. regarding the speed could you please where is the slowness in this report? Regard Mai multe

$100 USD în 3 zile
(8 recenzii)
4.3
Fotografia de profil a utilizatorului Gathix444
Gathix444

Dear Client, Thanks for the opportunity to bid on this project. I’ve read your brief on the project and is ready to go for it. I’ve done work on data gathering, data analysis, web researching, data entry and transla Mai multe

$155 USD în 3 zile
(17 recenzii)
4.1
Fotografia de profil a utilizatorului poldialcalay
poldialcalay

Hello. Could you have a quick chat session with me? I would like to understand your project in more detail and so adjust my bid based on the information that you can provide. I have a video in my profile showing the f Mai multe

$200 USD în 15 zile
(10 recenzii)
4.0
Fotografia de profil a utilizatorului nolinocum
nolinocum

A proven track record of efficiency and accuracy in managing multiple functions, solving problems, maintaining confidentiality and producing quality work. Strong background in performing data entry processes into prede Mai multe

$155 USD în 3 zile
(0 recenzii)
0.0
Postează un proiect similar