Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Post your project for free and start receiving proposals from freelancers within minutes after publication!

Screenshots for Google Sheets

Databases & SQL, Javascript and Typescript

3 out of 3

closed without completion

publication
open for proposals
closed without completion

Project translated automatically. Log in or register, to view the original

Catalogue and Group List - these group letters contain the basic data for further calculations Catalogue - indicated the basic data for calculations, in particular, the maximum number of hours of study 1 student per day and the condition of allocation of the maximum number of hours per day F2:F6, G2:G6.The comments show the logic of calculating the number of instructors and vehicles per group with max.The number of students.The group list is automated (election of the J6 category, date of completion of the study depending on the selected E25 category).It needs to be automated: 1.Maximum number of students (Catalogue G2:G6) starting from line 11 depending on category (Catalogue A2:A6).That is, when selecting the category A1 from the list in J6, a table in the lines 11-20 must be formed to enter the corresponding data.The 2ndThe number of filled cells in the number A starting with the number A11 must be formed automatically and the number of filled cells in the number B starting with the number B11 must be formed automatically.The number of teachers and transportation will be selected manually depending on the actual number of students in the group.Individual card (here specifically referred to is the card of the ICA1)- you need to automatize:1.Creating the number of cards depending on the number of students in the group (List of the group from 1 to the maximum of the group defined by category Catalogue N2:N6) with filling the student's name, No group, date of start of classes, date of completion of classes, name of the teacher(s), transportation(s).The filling of a column A starting from the period 30, in the A30 date must correspond to the start date of classes (Group List, C25).According to the A column, the working days dates are filled with the starting-end class range (Group List, C25, E25), the number of working days of training for the category is constant and is in the D2:D6 Catalogue.Driving schedule - automated: category, Groups, date of start of classes, date of completion of classes - the data is copied from the Group List.It needs to be automated: 1.Filling a column B starting from the line 13, in B13 the date must correspond to the start date of classes (Group List, C25).According to the column B, the working days are filled with the starting-end-time range (Group List, C25, E25), according to the number of full time in the table is equal to the number of working days.Date and number of working days B13:B:28=ikA1 B30:B45.2. The number of filled cells in the number A starting with the number A13 must be formed automatically and pass the number of filled cells in the number B starting with the number B13.3. Filling cells in line 12 starting with C12 students' names from the group list, the number of filled cells and, according to the table limit, corresponds to the number of students in the group list.Filling the cells in the working days range - the name of the student hours of each student in the format 00:00-00:00 in the working time from 6:00 to 22:00 from the letter IKA1 D30:D45 - in this range has already been calculated the number of hours of study 1 student per day and this number of hours is constant.Example: 5th day of study (term 34, 35 ICA1), the student can take up to 4 hours/day, 4 instructors work in two changes and 2 TZ in two changes.The number of hours that the instructors can work on this day is 32.One student takes 3.2 hours/day (limit not exceeded) on 2 subjects: Theme 3 and Theme 4.That is, on this day all 10 students from the group can take the training but at a different time, which needs to be divided by driving schedule.Link to the table : https://docs.google.com/spreadsheets/d/1WM4WkbqPnDflhJfRlIR08OiVluz-S3DYuIfzDzI0Y2E/edit?usp=sharing
by P.S. Please send suggestions to those who can complete the task in 3-4 days.I will not pay the commission, I will be able to pay the commission after the task is performed.

Proposals 1

45 USD

Oleh Patrushev

45 USD

Hello to you! I can try to do. The time is a week. Eat if it is interesting.

Show original

Translate

3 October 2023, 12:53

Current freelance projects in the category Databases & SQL

Need a 1C specialist for refinements and development. I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 19 hours 21 minutes back ∙ 9 proposals
Restoring Instagram after a ban On March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 1 day 6 hours back ∙ 4 proposals
CRM system for Railway Logistics Creation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day 18 hours back ∙ 39 proposals
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C: 45 USD Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 4 days 13 hours back ∙ 16 proposals	45 USD
Accounting, planning, and sales system for a mushroom farm 602 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 ∙ 6 days 17 hours back ∙ 58 proposals	602 USD

Mykola Yashchenko

Kyiv 1

Screenshots for Google Sheets

Current freelance projects in the category Databases & SQL

Need a 1C specialist for refinements and development.

Restoring Instagram after a ban

CRM system for Railway Logistics

Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:

Accounting, planning, and sales system for a mushroom farm