Google sheet speed optimize
$30-250 USD
Paid on delivery
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.
Project ID: #13008522
About the project
11 freelancers are bidding on average $142 for this job
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 More
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.
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
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 More