Forum Discussion
Combining Linear/Nonlinear Budgets
My current data assumes that every "Task" has a linear budget. Some of the tasks do not. Below is an example of the tables I'm working with. The Budget Table gives the budget linearly, regardless o...
Task Table
| Task | Task Level 1 | Task Level 2 | Task Level 3 |
| 1.2 | 1 | 1.2 | |
| 1.3.2 | 1 | 1.3 | 1.3.2 |
| 2.1.2 | 2 | 2.1 | 2.1.2 |
| 2.2.3 | 2 | 2.2 | 2.2.3 |
| 2.3 | 2 | 2.3 | |
| 3.1.2 | 3 | 3.1 | 3.1.2 |
Linearity Table
| Task | Category | Linearity | LinearityKey |
| 1.2 | A | Linear | 1.2A |
| 1.2 | D | Nonlinear | 1.2D |
| 1.3.2 | B | Nonlinear | 1.3.2B |
| 2.1.2 | C | Linear | 2.1.2C |
| 2.2.3 | A | Linear | 2.2.3A |
| 2.3 | D | Linear | 2.3D |
| 3.1.2 | A | Nonlinear | 3.1.2A |
Nonlinear Budget Table
| Task | Category | First Day of Month | DateKey | Budget % |
| 1.2 | D | 2022-07-04 | 20220701 | 0.25 |
| 1.2 | D | 2022-08-01 | 20220801 | 0.5 |
| 1.2 | D | 2022-09-01 | 20220801 | 0.25 |
| 1.3.2 | B | 2022-07-04 | 20220701 | 0.125 |
| 1.3.2 | B | 2022-08-01 | 20220801 | 0.125 |
| 1.3.2 | B | 2022-09-01 | 20220801 | 0.75 |
| 3.1.2 | A | 2022-07-04 | 20220701 | 0.7 |
| 3.1.2 | A | 2022-08-01 | 20220801 | 0 |
| 3.1.2 | A | 2022-09-01 | 20220801 | 0.3 |
Dates
| Date | DateKey | Day | Month | Year |
| 2022-07-04 | 20220704 | 4 | 7 | 2022 |
| 2022-07-15 | 20220715 | 15 | 7 | 2022 |
| 2022-07-29 | 20220729 | 29 | 7 | 2022 |
| 2022-08-01 | 20220801 | 1 | 8 | 2022 |
| 2022-08-15 | 20220815 | 15 | 8 | 2022 |
| 2022-08-31 | 20220831 | 31 | 8 | 2022 |
| 2022-09-01 | 20220901 | 1 | 9 | 2022 |
| 2022-09-15 | 20220915 | 15 | 9 | 2022 |
| 2022-09-30 | 20220930 | 31 | 9 | 2022 |
Note: In the Budget Table and Dates table there is usually every work day of the month, I summarized by putting the first work day, the 15th and the last work day.
To not exceed max characters, I'll respond with the Budget Table and what I'm looking for in the next comment(s).