Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoKarim, as a followup to Don's post, what are you hoping to happen with the available capacity after the project is entered? Are you expecting it to decrease?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
KarimGawish
6 years agoQrew Member
I think I should have another column with the decreased capacity.
I think I didn't describe the problem properly, I'll try to describe it in a better way.
Let's say we manufacture chairs, we receive projects daily, each project has a set number of chairs.
Each employee can make 3 chairs per day, everyday they're at the office.
When I receive a project request to make 25 chairs from Feb 23 to Feb 26, I want my total capacity for those days calculated and the number of chairs required deducted sequentially from the daily capacity and stored in the sheet.
In the screenshot I wrote the numbers I expect the formula to provide.
The following assumptions stand:
- Projects are First come first serve basis - hence sequential deductions
- "Chairs" are identical to each other, and all employees have the same capacity to make 3 chairs every single day at the office. Projects differ in the amount of chairs only.
I appreciate your help since I've been stuck here for some time.
------------------------------
Karim Gawish
------------------------------
I think I didn't describe the problem properly, I'll try to describe it in a better way.
Let's say we manufacture chairs, we receive projects daily, each project has a set number of chairs.
Each employee can make 3 chairs per day, everyday they're at the office.
When I receive a project request to make 25 chairs from Feb 23 to Feb 26, I want my total capacity for those days calculated and the number of chairs required deducted sequentially from the daily capacity and stored in the sheet.
In the screenshot I wrote the numbers I expect the formula to provide.
- 23rd we'll do 9 chairs, so ending capacity is 0
- 24th we'll do 9 chairs, ending capacity is 0
- 25th we'll do the remaining 7 chairs, ending capacity is 2
- 26th will remain unchanged since we finished the project the day earlier.
The following assumptions stand:
- Projects are First come first serve basis - hence sequential deductions
- "Chairs" are identical to each other, and all employees have the same capacity to make 3 chairs every single day at the office. Projects differ in the amount of chairs only.
I appreciate your help since I've been stuck here for some time.
------------------------------
Karim Gawish
------------------------------