I’ve a table calles modules, all my modules for university are stored there. They had a start-date, a assignment-date and a number of days, I’ll need to prepare for the assignment
And i have a second table with my learning content for the modul, like 500 sides, 25 videos, …
now I try to write a formula, that calculates my workload for each module per week.
calculate how many weeks I have: startdate- date of assignment - preparing time / 7 → weeks I have for preparation → weeks
after that, I would like to calculate how much pages/videos I have to prepare each week
and finally I would add this as a row in a table called events:
week 1: startdate, 200/weeks pages, 25/weeks videos
week 2: startdate+7 200/weeks pages, 25/weeks videos
I hope, I could describe, what I want to do.
I am really new at coda, thats why I#m struggling to put these all together in one formula