Screenshot for Google spreadsheets, selection and composition of values
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
Client's review of cooperation with Oleg Stasiv
Screenshot for Google spreadsheets, selection and composition of valuesThe project is done in accordance with the TZ, provided the necessary directions, the performance is pleased, I recommend!
Freelancer's review of cooperation with Viktor Kurgak
Screenshot for Google spreadsheets, selection and composition of valuesI am pleased with the collaboration with Victor.
I recommend !
-
3676 107 0 Make the table available.
I ask for a request...
sent his request.
It will be easier to evaluate the task and call the price.
Current freelance projects in the category Javascript and Typescript
Website design updateIt is necessary to update the design of the existing website using HTML, CSS, JS: refresh the appearance, make it modern and responsive for mobile devices. Smooth animations and interactive elements need to be added. HTML & CSS, Javascript and Typescript ∙ 13 hours 54 minutes back ∙ 67 proposals |
Consultation and audit of the current project on Odoo 19 Community EditionWe are looking for an Odoo Developer — a solo developer with experience in Odoo 19 Community Edition, including using Claude Code. We need a specialist who has successfully implemented projects in Odoo and practical experience in development using Claude Code. Important: we only… C & C++, Javascript and Typescript ∙ 19 hours 33 minutes back ∙ 5 proposals |
Online clothing storeNeed a developer for an online clothing store Looking for an experienced developer to create a full-fledged online clothing store with a drop model of sales. What needs to be done: 6 pages: home, product, cart, checkout, account, admin panel Login via Google account Cart and… HTML & CSS, Javascript and Typescript ∙ 2 days 16 hours back ∙ 98 proposals |
Full-stack development — Amazon PPC Dashboard (Stage 1)Need a full-stack developer with experience working with Amazon API to implement Stage 1 of the internal PPC dashboard. The project is real, the data is live, everything is ready to start. Frontend prototype (5 pages, React + TypeScript): WHAT IS ALREADY READY — Frontend… Javascript and Typescript, Web Programming ∙ 5 days 3 hours back ∙ 32 proposals |
Development of a photo book and photo frame constructor websiteProject Goal A modern website needs to be developed for ordering photo books, photo frames, and other personalized photo products. The main task of the project is to provide the client with the ability to independently create a ready-made layout of the product directly on the… Javascript and Typescript, Web Programming ∙ 6 days 19 hours back ∙ 99 proposals |