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).


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,689 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Herbert Seidenberg 1,191 Reputation points

    Excel 365
    Distribute work sequentially over 3 shifts.
    One formula.

    1 person found this answer helpful.

  2. sefi evenor 1 Reputation point

    Request to calculate/Compare data in 2 different row/


  3. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor


    How did you calculate the Column Production plan?

    0 comments No comments