Excel 365
Distribute work sequentially over 3 shifts.
One formula.
https://www.mediafire.com/file/jpnad4azcs56ha2/11_28_22.xlsx/file
Calculating in QUERY
sefi evenor
1
Reputation point
query excel
Need help calculating in QUERY.
I want to calculate a column that will give me a planned production quantity for the shift.
I have the possible/maximum output in each shift. And I have total demand.
The goal is to split the demand into shifts.. possible between 1-3 shifts.
(In Excel the calculation simply activates a reduction).
Thanks
Sefi
3 answers
Sort by: Most helpful
-
Herbert Seidenberg 1,191 Reputation points
2022-11-28T17:41:27.323+00:00 -
sefi evenor 1 Reputation point
2022-11-26T14:54:47.23+00:00 Request to calculate/Compare data in 2 different row/
-
Emi Zhang-MSFT 21,706 Reputation points Microsoft Vendor
2022-11-28T09:31:36.047+00:00 How did you calculate the Column Production plan?