Project translated automatically. Log in or register, to view the original There is a Google table: HTTPS://docs.google.com/spreadsheets/d/1M2GsCEoxb51wOlv_bJYn9HfldHZusHV116Oipd0nqE/edit#gid=844360844 There are a few lists, namely: Working lists , Brands with years - a list indicating the year of production for each model accordingly There is a script that performs the following action: 1 .In the BT x Guangzhou Zengcheng District list, the O2 cell will take the first value "S5" 2ndGoing on the brands with years will find the value of "S5", take the value of the year to which he corresponds "2017-2022" ThreeIn the BT x Guangzhou Zengcheng District list, the P2 cell will create a type record: "2017-2022 Audi S5," where: "2017-2022" - the value found in the brand list by car model "Audi" - value from the cell D2 leaf BT x Kubay Design “S5” and the model accordingly After this cycle should be repeated for all models in the E2 cell. In order to get a type record in F2: 2017–2022 Audi S5 1999-2004 Audi S6 2011–2022 Audi A6 2010–2022 Audi A7 2012–2017 Audi S7 ... I repeat, it is already implemented. Two things need to be done: 1. in the table R is the range of years, it is the limits of years for each model in a specific cell, for example In R2 2012-2022, that is, when performing the previous script in the cell E2, the values (or to be replaced) must fall into the values of the range. 2017-2022 Audi S5 will remain unchanged 1999-2004 Audi S6 - will not be added as the nni first or second value does not fit under the 2012-2022 range 2011-2022 Audi A6 - will be replaced by 2012-2022 Audi A6 - as in the "filter range begins with 2012" 2010-2022 Audi A7 - will be replaced by 2012-2022 Audi A7 - the same 2012-2017 Audi S7 - remains unchanged After the formation of the cell E2 type, add a function that propulses these values by dividing them by columns year start - year end - brand - model 2017–2022 Audi S5 1999-2004 Audi S6 2011–2022 Audi A6 2010–2022 Audi A7 2012–2017 Audi S7

Proposals 2

Oleg Stasiv

Winning proposal

107 0

Budget: 1300 UAH Deadline: 3 days

Make the table available.
I ask for a request...

sent his request.

It will be easier to evaluate the task and call the price.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Viktor Kurgak
Poltava, Ukraine
Ai-Ti

Projects 32
Rating 5.0
Rating 948

Screenshot for Google spreadsheets, selection and composition of values

Client's review of cooperation with Oleg Stasiv

Screenshot for Google spreadsheets, selection and composition of values

4.8

Viktor Kurgak

Freelancer's review of cooperation with Viktor Kurgak

Screenshot for Google spreadsheets, selection and composition of values

5.0

Oleg Stasiv

Oleg Stasiv

Proposals are currently absent

Current freelance projects in the category Javascript and Typescript

Development of Telegram Mini App (RPG Game)

Automation of creating vertical videos of one type using a plugin in After Effects.

Development of a Tampermonkey script for automating responses in the internal CRM via the OpenAI API.