Calculating in QUERY

asked 2022-11-25T11:54:56.773+00:00
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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,333 questions
{count} votes

3 answers

Sort by: Most helpful
  1. answered 2022-11-28T17:41:27.323+00:00
    Herbert Seidenberg 1,106 Reputation points

    Excel 365
    Distribute work sequentially over 3 shifts.
    One formula.
    https://www.mediafire.com/file/jpnad4azcs56ha2/11_28_22.xlsx/file


  2. answered 2022-11-26T14:54:47.23+00:00
    sefi evenor 1 Reputation point

    Request to calculate/Compare data in 2 different row/

    264395-calculate-shift-producion.pdf


  3. answered 2022-11-28T09:31:36.047+00:00
    Emi Zhang-MSFT 10,516 Reputation points Microsoft Employee

    264697-image.png

    How did you calculate the Column Production plan?

    No comments