Replacing formula with script

ステータス: Closed
賞金: €80
受け取ったエントリー: 8
優勝者: grantbradshaw

Winner

コンテスト概要

About Footway
Footway is a web-based platform for shoes that enables customers and manufacturers to meet. We want to make trends and collective knowledge visible to make the production of quality products even better. We believe the customers' values in quality, price and environment will be crucial for future products in fashion.

About the project
This Gsheet is our order template for purchase orders. Today the sheet is too slow because of all formulas, so the intention is to fasten the sheets.

Delivery
The results are to be presented in a Google spreadsheet in a copy of this file that you share with par.mosegaard@footway.com and take a print screen of the script text to upload as contest entry:
https://docs.google.com/spreadsheets/d/1jGS_jcTqOc8Gfzp-OLtbHFpOpWKJHY8hAG7xYJEAOCQ/edit?usp=sharing

Instructions
Create a script called “Sizes”
The script should replace the formulas function in section “Purchase Orders” in cells “I18:AB299” or as long there is data in column B

What we don’t want
We will reject any entries telling us you're working on the project. Only approved scripts in a shared GSheets will be accepted.

Feedback
We have very limited capacity to answer questions or give individual feedback during the project, instead we will give collective feedback - this will then hopefully help you get a better understanding of what we are looking for.

We are looking for long term collaboration with skilled GSheet scripters.