Systematize the table in Excel and build graphs
Employer
[no-member:pro]Dmitry[/no-member:pro]
Project parameters
Type of cooperationOne-time project
SectionTexts and translation
Prepaymentprepayment is possible
Payment methodsBank transfer
Acceptance of requestsfrom Jan 17, 2022 until Jan 22, 2022
Project description
Offering extra earnings. You need to organize the table in Excel and build graphs. What is the essence: there is a chatbot (for example, in a telegram), in it a person sends an emoji for convenience, and then it is all recorded automatically in a single Google table. The ultimate goal is to build graphs. Schedules for 1 day, for a week, for a month, for 3 months and for 6 months. Then, using these graphs, you can track the dependence of one metric on another. To build graphs, the table must be systematized and brought into a single form.
From messages filter emoji, copy together with the dates in a separate sheet and change the value to 1, format make a number.
Here, a person filled in his data for six months. What is in the data: smoking (how many people smoked per day), training (running, rocking, tennis), if you read this message, please report it, then the toilet, sex, the amount of water you drank (!), meditation is also sometimes there. And of course, how many times did a person eat in a day?
The ultimate goal is to build graphs. Schedules for 1 day, for a week, for a month, for 3 months and for 6 months.
To build graphs, the table must be systematized and brought into a single form.
For example, there is the smoking tab.
There is only a toilet, sex, training, drinks, the amount of water drunk and finish smoking, there are not all dates.
From messages filter emoji, copy together with the dates in a separate sheet and change the value to 1, format make a number.
Here, a person filled in his data for six months. What is in the data: smoking (how many people smoked per day), training (running, rocking, tennis), if you read this message, please report it, then the toilet, sex, the amount of water you drank (!), meditation is also sometimes there. And of course, how many times did a person eat in a day?
The ultimate goal is to build graphs. Schedules for 1 day, for a week, for a month, for 3 months and for 6 months.
To build graphs, the table must be systematized and brought into a single form.
For example, there is the smoking tab.
There is only a toilet, sex, training, drinks, the amount of water drunk and finish smoking, there are not all dates.
