I have a humanitarian project - I feed high school students, but I need to streamline the processes a bit, as there is sometimes chaos. Therefore, I am looking for a solution that will satisfy everyone: both the parents and me.
We have a Google spreadsheet where parents of students from 11 different classes enter their data. They order lunches in the cafeteria today for tomorrow. They are currently working in a shared spreadsheet and often accidentally edit their neighbor's data, and then someone is left without lunch :-(
It is necessary to divide it into 11 tables (one for each class accordingly) with the ability to provide access to each class, some password, or a link to their class (this needs to be thought through).
After the parents edit the information in their respective class, the information automatically changes in the general summary table.
It is also desirable to make it so that the data in the summary table does not change after locking the cells for editing. Currently, every morning at 9:00 AM, I lock the current day for editing, as after 9:00 AM, it is not possible to order lunch (the kitchen won't have time to prepare). But I also don't want parents to accidentally change something in their tables after 9:00 AM, which would change the order in the general file.
I am attaching a copy of the table with a separate link.
https://docs.google.com/spreadsheets/d/1_oUlSwrrAJ2jBop1Oq8vFktay1tQ-XM1e3AWK1YWmqM/edit?usp=sharing

Proposals 2

Volodymyr S.

9 1

Budget: 2000 UAH Deadline: 3 days

Good afternoon! Having reviewed your project, I am ready to start working on it. Let's discuss the details for the best result.

Tetyana S.

Winning proposal

75 4

Budget: 1000 UAH Deadline: 7 days

Good day! I have a lot of experience working with ET, including Google Sheets, so I can complete the task you set quickly (I can start right now), and most importantly - with quality! Feel free to reach out!

Current freelance projects in the category Data Parsing

Parsing the product catalog into a universal Excel/XML (UA/RU) for Prom.ua, Khoroshop, and other CMS.

48 proposals 4 August

Not specified
Collection of phone numbers from olx.pl

37 proposals 3 August

Not specified
Autoria Parser

74 proposals 2 August

Not specified
Reddit API

Web Programming 30 proposals 30 July

Not specified
Website parsing, bypassing Akamai protection

Python 47 proposals 30 July

Not specified

Dmitry Kolosovsky
Kyiv, Ukraine
ТОВ ГЛОБАЛ ПОСТ ЕКСПРЕС

Projects 48
Rating 5.0
Rating 2 180

Dmitry Kolosovsky

Tetyana S.

Volodymyr S.

Tetyana S.

Proposals are currently absent

Current freelance projects in the category Data Parsing

Parsing the product catalog into a universal Excel/XML (UA/RU) for Prom.ua, Khoroshop, and other CMS.

Collection of phone numbers from olx.pl

Autoria Parser

Reddit API

Website parsing, bypassing Akamai protection