Greeting community,
I need help designing an app. The goal is to have the PM select a project and allocate the number of hours needed for the year based on the labor category.
And the data be appended to existing records. Attempted to create an excel table to create the app however not finding the right structure to build it out. This is how I envisioned the interface to be. However, being new to the tool I'm not sure how the entries would be captured or appended to an excel file.
Any suggestions greatly appreciated
| Year | Project | Labor Cat | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| 2023 | Project A | ENG-A | 12 | 0 | 15 | 20 | 30 | 40 | 50 | 60 | 70 | 0 | 0 | 10 |
| 2023 | Project A | ENG-B | 5 | 8 | 3 | |||||||||
| 2023 | Project A | PM-A | 10 | 85 | 4 | |||||||||
| 2023 | Project A | PM-B | 5 | 54 | 4 | 423 | ||||||||
| 2023 | Project A | QA | 10 | 54 | 85 | |||||||||
| 2023 | Project A | TC-A | 45 | 7 | ||||||||||
| 2023 | Project A | TC-B | 34 | 0.5 | 45 | |||||||||
| 2023 | Project A | TC-C | 43 | 45 | 3 | 378 | ||||||||
| 2023 | Project B | ENG-A | 5 | 21 | 1 | |||||||||
| 2023 | Project B | ENG-B | 47 | |||||||||||
| 2023 | Project B | PM-A | 43 | 453 | 34 | |||||||||
| 2023 | Project B | PM-B | 532 | 45 | 53 | 34 | 3 | |||||||
| 2023 | Project B | QA | 41 | |||||||||||
| 2023 | Project B | TC-A | 58 | 43 | 5 | |||||||||
| 2023 | Project B | TC-B | 2 | 43 | 85 | |||||||||
| 2023 | Project B | TC-C | 2 | 5 |

Report
All responses (
Answers (