Systematize the table in Excel and build graphs

Дмитрий
1

Дмитрий

no recommendations
no complaints
Project title: Systematize the table in Excel and build graphs
Type of cooperation: One-time project
Section: Texts and translation
Prepayment: prepayment is possible
Payment methods: Bank transfer
Acceptance of requests: from until 2022-01-22

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.
Project author
Дмитрий