Calculating in QUERY

sefi evenor 1 Reputation point
2022-11-25T11:54:56.773+00:00

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

3 answers

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

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

    1 person found this answer helpful.

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

    Request to calculate/Compare data in 2 different row/

    264395-calculate-shift-producion.pdf


  3. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor
    2022-11-28T09:31:36.047+00:00

    264697-image.png

    How did you calculate the Column Production plan?

    0 comments No comments