Table (active with formulas) Google Spreadsheet for the calculation of dates
The table should be based on real days in the calendar 2022-2026
The student pays every 4 weeks for 8 classes.The student takes 2 times a week (Tuesday and Thursday or Monday and Wednesday)
The first payment date for each student will be their own.For each student I want to see the dates (day, month, year) of payment for the following 8 classes, 16 classes, 24 classes and increasing by 3 years from the date of the first class.In the graph the number of lessons to be read must indicate the number of lessons not performed and for such number of lessons the date of the next payment is shifted.The example:
I indicate the date of the first class of the student in Graph 3, if all the lessons were held, then in Graph 4 must be 0 and automatically indicate in Graph 5 the date of the 8th class taking into account the date of the first class in Graph 3 and the number of lessons to be read from Graph 4.And this algorithm extends to the entire table for 3 years ahead.By default, the number of lessons to be read in the graph is 0 as soon as I change the number of lessons to be read in the graph to another number all the following dates of the lessons change.
Applications 1
Client's review of cooperation with Petro Shpak
Table (active with formulas) Google Spreadsheet for the calculation of datesQuick and quality, I recommend.
Freelancer's review of cooperation with Yury Shmidt
Table (active with formulas) Google Spreadsheet for the calculation of datesI recommend it.
The customer responds to the question immediately.
The task was not standard and was interesting.
-
4461 102 0 Good evening . I will be glad to help. I do everything quickly and efficiently!
-
564 5 1 Good morning, I can help you with this task and explain how the formulas will work whatever it is magic :)
upd . The solution is almost ready.
-
5894 345 0 I can implement a Google table with formulas that realizes the necessary calculations with dates.
-
421 13 0 Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
Connecting bots of telegram and e-mail to Google tables.
I will be happy to cooperate.
-
3621 113 7 1 Welcome to.
I have a great experience working with Google Sheets and Excel.
I also do scripts for the above-mentioned programs. I’ve done similar projects, there’s a solution.
Look at the portfolio and reviews.
Get acquainted with the project. Ready to help with the implementation.
Let’s talk about the details.
-
А если человек пропускает все 8 занятий, и еще пару недель? Какую дату или предупреждение выдавать?
-
Current freelance projects in the category PHP
Fix CLSIt is necessary to fix the Cumulative Layout Shift through code PageSpeed does not see this problem, but through Google Chrome, it is visible that there is a layout shift for the desktop version of the page According to Google Search, there is an error regarding the speed of… PHP, Web Programming ∙ 13 hours 48 minutes back ∙ 23 proposals |
Transfer the fully ready adaptive HTML5 structure to WordPress.
267 USD
I am looking for an experienced WordPress developer who can convert our meticulously prepared static HTML5/CSS3 code into a high-performance custom WordPress theme. The frontend is almost ready (about 99%): semantic markup, metadata, and multilingual structure (hreflang) are… Content Management Systems, PHP ∙ 16 hours 41 minutes back ∙ 59 proposals |
GoPos IntegrationHello, has anyone done an integration of GoPos with a custom website for a restaurant in Poland? I need help, their documentation is very sparse, there is only swagger and it lacks descriptions. https://app.gopos.io/doc/swagger-ui/index.html The essence is this: we used their… PHP, Web Programming ∙ 1 day 8 hours back ∙ 24 proposals |
Write meta data for ALT using AIA website on Laravel, the site has many images for which it is necessary to automatically generate correct semantic and relevant ALT descriptions for the images, with the possibility of verification. AI & Machine Learning, PHP ∙ 2 days 5 hours back ∙ 33 proposals |
A developer is needed to complete and integrate a project for automatic data collection and processing.
16 USD
The main part of the parser has already been implemented. The parser works in a Windows environment through Microsoft Edge: the site has anti-bot protection, so data collection is performed not through direct HTTP requests, but through a live browser session. The scripts control… PHP, Web Programming ∙ 2 days 11 hours back ∙ 24 proposals |