You need to write Google Apps Script for tables.
The group list is partially automated (the group selection, the date of completion of the study depending on the group selected), the maximum number of students (students in the group) depending on the category, and the number of teachers depending on the number of students.Chart - partially automated (election of category, Groups, date of start of classes, date of completion of classes, working class days are formed by a copy of the formula), you need to automatize : determination of working class days depending on the selected category, hours of study of each student on working days (from the calculation of 2 hours per student for one day, 8 hours per group for one day if the group has one teacher, if the teachers two -16 hours per group for one working day) in the format 00:00-00:00 in working time from 8:00 to 17:00
Individual card - you need to create a number of cards (but one letter or create separate letters) depending on the number of students in the group, fill out the dates in which the student was taught from the schedule.Access to the table here https://docs.google.com/spreadsheets/d/1kpFRDixU8HoCkn4xo3fRdukOYfODLiPUfAgvWuJ0FDM/edit?usp=sharing
-
3 days44 USD
981 17 0 3 days44 USD
Good day !
Ready to complete your project after a small clarification.
-
1 day44 USD
3668 107 0 1 day44 USD
I suggest you do this not using a formula, but writing a special macro.
Press the button and everything will be filled and the cards will be created.
Makros is a more reliable formula.
-
10 days44 USD
957 19 0 10 days44 USD
Good day . Ready to help with your project. Everything you need is automated. Experience with similar projects.
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
600 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 1 day 10 hours back ∙ 51 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 1 day 10 hours back ∙ 11 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 1 day 23 hours back ∙ 9 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 2 days 4 hours back ∙ 11 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 3 days 3 hours back ∙ 24 proposals |
Kyiv