Project translated automatically. Log in or register, to view the original Good day . The task for the Google table is as follows: At 1 number (12:00) of each new month, it is imperatively to compare the value of one column with the previous value, and to examine the difference in a separate place. Explain only the difference. For example: Start of the “150,000” On the 1 number (12:00) of the new month in the "175 000" Difference “+25 000” In the first tab for the result, fix "+25 000" After a month, on the 1st of the month at 12:00, we compare the value in a note, for example, "165 000" Difference “10000” In the second tab for the result, fix "10000" and so on. Name of the table - "Rental - Zhelezzo" Title of the book: “Rental” The initial data is “48422” Comparison of data H100 The first picture for the result is D144, the next is D145 and so on. New lines are periodically added from the top, so it is important that the formulas are automatically corrected in case of such adding (otherwise automatically)

Update #1 from 22 October 2022

Initial data recorded in the file - D144 Log in or register, to view the original

Update #2 from 24 October 2022

D144 is the number from which the first comparison starts. Comparative data (H100) is a measure of the result of which will be constantly compared to the previous value. ---- h100 is the result of different formulas, the amount that is in it will change, but the shell is constant (only it will move down when adding rows above) d144 - first hand-introduced result Then it must be d145 - and there the difference between h100 and d144 must be recorded at the time of the 1st number (12:00) of the new month. Afterwards d146 - and there the difference between h100 and d145 must be recorded at the time of the 1st number (12:00) of the new month. and so on. to test the principle you can fix the difference not once a month, and for example once a minute, and then manually change the h100 to simply test how the algorithm fixes the difference in each interval of time Log in or register, to view the original

Proposals 4 Discussions 3

Yuliya Karmazina

22 0

Projects 21
Rating -
Rating 340

Budget: 200 UAH Deadline: 1 day

Hello to you. Ready to perform the task. I will be happy to cooperate. turn to

Andrew Kr

Winning proposal

8 0

Projects 8
Rating -
Rating 270

Budget: 250 UAH Deadline: 1 day

Good day . I can do. I would look at the table as a whole. In general, the task is clear.

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

Viktor Biruk 20 October 2022

>>Формули/Макроси для Google Sheets (Excel)
Дуже помиляєтесь. Google Sheets - це не Excel! Кіт і собака теж схожі, але це геть різні тварини. Якщо задача тільки для Google-таблиць, приберіть із назви Excel, щоб не вводити в оману потенційних виконавців

Roman S. 20 October 2022

А может человеку не важно в каком офисном пакете будет реализовано. Хоть в опенофисе там тоже есть таблицы.
А по функционалу реализовать задачу не проблема в любом пакете

Viktor Biruk 21 October 2022

Написано ж:Задача для гугл таблиці наступна:

Add Comment

Current freelance projects in the category HTML & CSS

Layout of the main page

72 proposals 31 July

16 USD
Looking for a layout designer.

135 proposals 29 July

777 USD
Create a website on WP

Web Design 127 proposals 28 July

Not specified
Email designer / Layout designer

Email Marketing 53 proposals 27 July

111 USD
New adaptive HTML/CSS template for a large site with legacy code

71 proposals 27 July

Not specified

Dmitro Yarmolenko
Kyiv, Ukraine
Zhelezzo UA

Projects 89
Rating 5.0
Rating 1 281

Dmitro Yarmolenko

Andrew Kr

Yuliya Karmazina

Andrew Kr

Proposals are currently absent

Current freelance projects in the category HTML & CSS

Layout of the main page

Looking for a layout designer.

Create a website on WP

Email designer / Layout designer

New adaptive HTML/CSS template for a large site with legacy code