Spreadsheet: 886591d1736631250-power-query-onhand-calculation-sample-to-evaluate-hergp-
Sheet: FNDWRR

ORIGINAL |  |  |  |  |  |  |  | RESULT
ORGANIZATION | ITEM | ORDER TYPE | QUANTITY | COST | SUGG DUE DATE |  |  | ORGANIZATION | ITEM | ORDER TYPE | QUANTITY | COST | SUGG DUE DATE |  |  |  |  | ORGANIZATION | ITEM.1 | ORDER TYPE | QUANTITY | COST | SUGG DUE DATE.1 | OEM Qty.
A02:FAN | A | On Hand | 55.413 | 38.9 | 2025-01 |  |  | A02:FAN | A | On Hand | 55.413 | 38.9 | 2025-01 |  |  |  |  | A02:FAN | A | On Hand | 55.413 | 38.9 | 45658
A02:FAN | A | Work order demand | -56.24248 | 38.9 | 2025-01 |  |  | A02:FAN | A | Work order demand | -56.24248 | 38.9 | 2025-01 |  |  |  |  | A02:FAN | A | Work order demand | -56.24248 | 38.9 | 45658
A02:FAN | A | Intransit shipment | 100 | 38.9 | 2025-01 |  |  | A02:FAN | A | Intransit shipment | 100 | 38.9 | 2025-01 |  |  |  |  | A02:FAN | A | Intransit shipment | 100 | 38.9 | 45658
A02:FAN | A | Purchase order | 100 | 38.9 | 2025-02 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-01 |  |  |  |  | A02:FAN | A | OEM |  | 38.9 | 45658
A02:FAN | A | Work order demand | -49.14 | 38.9 | 2025-02 |  |  | A02:FAN | A | Purchase order | 100 | 38.9 | 2025-02 |  |  |  |  | A02:FAN | A | Purchase order | 100 | 38.9 | 45689
A02:FAN | A | Work order demand | -0.00504 | 38.9 | 2025-03 |  |  | A02:FAN | A | Work order demand | -49.14 | 38.9 | 2025-02 |  |  |  |  | A02:FAN | A | Work order demand | -49.14 | 38.9 | 45689
A02:FAN | A | Work order demand | -54.35724 | 38.9 | 2025-03 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-02 |  |  |  |  | A02:FAN | A | OEM |  | 38.9 | 45689
A02:FAN | A | Purchase order | 600 | 38.9 | 2025-04 |  |  | A02:FAN | A | Work order demand | -0.00504 | 38.9 | 2025-03 |  |  |  |  | A02:FAN | A | Work order demand | -0.00504 | 38.9 | 45717
A02:FAN | A | Work order demand | -51.324 | 38.9 | 2025-04 |  |  | A02:FAN | A | Work order demand | -54.35724 | 38.9 | 2025-03 |  |  |  |  | A02:FAN | A | Work order demand | -54.35724 | 38.9 | 45717
A02:FAN | A | Work order demand | -63.95144 | 38.9 | 2025-05 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-03 |  |  |  |  | A02:FAN | A | OEM |  | 38.9 | 45717
A02:FAN | A | Work order demand | -0.007 | 38.9 | 2025-06 |  |  | A02:FAN | A | Purchase order | 600 | 38.9 | 2025-04 |  |  |  |  | A02:FAN | A | Purchase order | 600 | 38.9 | 45748
A02:FAN | A | Work order demand | -20.82556 | 38.9 | 2025-06 |  |  | A02:FAN | A | Work order demand | -51.324 | 38.9 | 2025-04 |  |  |  |  | A02:FAN | A | Work order demand | -51.324 | 38.9 | 45748
A02:FAN | A | Purchase order | 700 | 38.9 | 2026-02 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-04 |  |  |  |  | A02:FAN | A | OEM |  | 38.9 | 45748
A02:FAN | B | On Hand | 61342 | 0.0501 | 2025-01 |  |  | A02:FAN | A | Work order demand | -63.95144 | 38.9 | 2025-05 |  |  |  |  | A02:FAN | A | Work order demand | -63.95144 | 38.9 | 45778
A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-01 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-05 |  |  |  |  | A02:FAN | A | OEM |  | 38.9 | 45778
A02:FAN | B | Work order demand | -89330 | 0.0501 | 2025-01 |  |  | A02:FAN | A | Work order demand | -0.007 | 38.9 | 2025-06 |  |  |  |  | A02:FAN | A | Work order demand | -0.007 | 38.9 | 45809
A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-02 |  |  | A02:FAN | A | Work order demand | -20.82556 | 38.9 | 2025-06 |  |  |  |  | A02:FAN | A | Work order demand | -20.82556 | 38.9 | 45809
A02:FAN | B | Work order demand | -93746 | 0.0501 | 2025-02 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-06 |  |  |  |  | A02:FAN | A | OEM |  | 38.9 | 45809
A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-03 |  |  | A02:FAN | A | Purchase order | 700 | 38.9 | 2026-02 |  |  |  |  | A02:FAN | A | Purchase order | 700 | 38.9 | 46054
A02:FAN | B | Work order demand | -92784 | 0.0501 | 2025-03 |  |  | A02:FAN | A | EOM |  | 38.9 | 2026-02 |  |  |  |  | A02:FAN | A | OEM |  | 38.9 | 46054
A02:FAN | B | Work order demand | -91675 | 0.0501 | 2025-04 |  |  | A02:FAN | B | On Hand | 61342 | 0.0501 | 2025-01 |  |  |  |  | A02:FAN | B | On Hand | 61342 | 0.0501 | 45658
A02:FAN | B | Planned order | 100000 | 0.0501 | 2025-04 |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-01 |  |  |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 45658
A02:FAN | B | Work order demand | -25 | 0.0501 | 2025-05 |  |  | A02:FAN | B | Work order demand | -89330 | 0.0501 | 2025-01 |  |  |  |  | A02:FAN | B | Work order demand | -89330 | 0.0501 | 45658
A02:FAN | B | Work order demand | -89063 | 0.0501 | 2025-05 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-01 |  |  |  |  | A02:FAN | B | OEM |  | 0.0501 | 45658
A02:FAN | B | Planned order | 100000 | 0.0501 | 2025-05 |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-02 |  |  |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 45689
A02:FAN | B | Work order demand | -73845 | 0.0501 | 2025-06 |  |  | A02:FAN | B | Work order demand | -93746 | 0.0501 | 2025-02 |  |  |  |  | A02:FAN | B | Work order demand | -93746 | 0.0501 | 45689
A02:FAN | C | On Hand | 6.7 | 63.77691 | 2025-01 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-02 |  |  |  |  | A02:FAN | B | OEM |  | 0.0501 | 45689
A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 2025-01 |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-03 |  |  |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 45717
A02:FAN | C | Work order demand | -5.45493 | 63.77691 | 2025-01 |  |  | A02:FAN | B | Work order demand | -92784 | 0.0501 | 2025-03 |  |  |  |  | A02:FAN | B | Work order demand | -92784 | 0.0501 | 45717
A02:FAN | C | Work order demand | -5.3418 | 63.77691 | 2025-02 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-03 |  |  |  |  | A02:FAN | B | OEM |  | 0.0501 | 45717
A02:FAN | C | Work order demand | -0.00054 | 63.77691 | 2025-03 |  |  | A02:FAN | B | Work order demand | -91675 | 0.0501 | 2025-04 |  |  |  |  | A02:FAN | B | Work order demand | -91675 | 0.0501 | 45748
A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 2025-03 |  |  | A02:FAN | B | Planned order | 100000 | 0.0501 | 2025-04 |  |  |  |  | A02:FAN | B | Planned order | 100000 | 0.0501 | 45748
A02:FAN | C | Work order demand | -5.8596 | 63.77691 | 2025-03 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-04 |  |  |  |  | A02:FAN | B | OEM |  | 0.0501 | 45748
A02:FAN | C | Work order demand | -5.5425 | 63.77691 | 2025-04 |  |  | A02:FAN | B | Work order demand | -25 | 0.0501 | 2025-05 |  |  |  |  | A02:FAN | B | Work order demand | -25 | 0.0501 | 45778
A02:FAN | C | Work order demand | -6.06348 | 63.77691 | 2025-05 |  |  | A02:FAN | B | Work order demand | -89063 | 0.0501 | 2025-05 |  |  |  |  | A02:FAN | B | Work order demand | -89063 | 0.0501 | 45778
A02:FAN | C | Work order demand | -0.00075 | 63.77691 | 2025-06 |  |  | A02:FAN | B | Planned order | 100000 | 0.0501 | 2025-05 |  |  |  |  | A02:FAN | B | Planned order | 100000 | 0.0501 | 45778
A02:FAN | C | Work order demand | -3.62166 | 63.77691 | 2025-06 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-05 |  |  |  |  | A02:FAN | B | OEM |  | 0.0501 | 45778
A02:FAN | D | On Hand | 8406 | 0.016 | 2025-01 |  |  | A02:FAN | B | Work order demand | -73845 | 0.0501 | 2025-06 |  |  |  |  | A02:FAN | B | Work order demand | -73845 | 0.0501 | 45809
A02:FAN | D | Work order demand | -3592 | 0.016 | 2025-01 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-06 |  |  |  |  | A02:FAN | B | OEM |  | 0.0501 | 45809
A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-02 |  |  | A02:FAN | C | On Hand | 6.7 | 63.77691 | 2025-01 |  |  |  |  | A02:FAN | C | On Hand | 6.7 | 63.77691 | 45658
A02:FAN | D | Work order demand | -5948 | 0.016 | 2025-02 |  |  | A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 2025-01 |  |  |  |  | A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 45658
A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-03 |  |  | A02:FAN | C | Work order demand | -5.45493 | 63.77691 | 2025-01 |  |  |  |  | A02:FAN | C | Work order demand | -5.45493 | 63.77691 | 45658
A02:FAN | D | Work order demand | -8088 | 0.016 | 2025-03 |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-01 |  |  |  |  | A02:FAN | C | OEM |  | 63.77691 | 45658
A02:FAN | D | Work order demand | -3436 | 0.016 | 2025-04 |  |  | A02:FAN | C | Work order demand | -5.3418 | 63.77691 | 2025-02 |  |  |  |  | A02:FAN | C | Work order demand | -5.3418 | 63.77691 | 45689
A02:FAN | D | Work order demand | -4524 | 0.016 | 2025-05 |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-02 |  |  |  |  | A02:FAN | C | OEM |  | 63.77691 | 45689
A02:FAN | D | Work order demand | -4732 | 0.016 | 2025-06 |  |  | A02:FAN | C | Work order demand | -0.00054 | 63.77691 | 2025-03 |  |  |  |  | A02:FAN | C | Work order demand | -0.00054 | 63.77691 | 45717
A02:FAN | D | Planned order | 10000 | 0.016 | 2025-06 |  |  | A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 2025-03 |  |  |  |  | A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 45717
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -5.8596 | 63.77691 | 2025-03 |  |  |  |  | A02:FAN | C | Work order demand | -5.8596 | 63.77691 | 45717
 |  |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-03 |  |  |  |  | A02:FAN | C | OEM |  | 63.77691 | 45717
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -5.5425 | 63.77691 | 2025-04 |  |  |  |  | A02:FAN | C | Work order demand | -5.5425 | 63.77691 | 45748
 |  |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-04 |  |  |  |  | A02:FAN | C | OEM |  | 63.77691 | 45748
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -6.06348 | 63.77691 | 2025-05 |  |  |  |  | A02:FAN | C | Work order demand | -6.06348 | 63.77691 | 45778
 |  |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-05 |  |  |  |  | A02:FAN | C | OEM |  | 63.77691 | 45778
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -0.00075 | 63.77691 | 2025-06 |  |  |  |  | A02:FAN | C | Work order demand | -0.00075 | 63.77691 | 45809
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -3.62166 | 63.77691 | 2025-06 |  |  |  |  | A02:FAN | C | Work order demand | -3.62166 | 63.77691 | 45809
 |  |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-06 |  |  |  |  | A02:FAN | C | OEM |  | 63.77691 | 45809
 |  |  |  |  |  |  |  | A02:FAN | D | On Hand | 8406 | 0.016 | 2025-01 |  |  |  |  | A02:FAN | D | On Hand | 8406 | 0.016 | 45658
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -3592 | 0.016 | 2025-01 |  |  |  |  | A02:FAN | D | Work order demand | -3592 | 0.016 | 45658
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-01 |  |  |  |  | A02:FAN | D | OEM |  | 0.016 | 45658
 |  |  |  |  |  |  |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-02 |  |  |  |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 45689
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -5948 | 0.016 | 2025-02 |  |  |  |  | A02:FAN | D | Work order demand | -5948 | 0.016 | 45689
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-02 |  |  |  |  | A02:FAN | D | OEM |  | 0.016 | 45689
 |  |  |  |  |  |  |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-03 |  |  |  |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 45717
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -8088 | 0.016 | 2025-03 |  |  |  |  | A02:FAN | D | Work order demand | -8088 | 0.016 | 45717
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-03 |  |  |  |  | A02:FAN | D | OEM |  | 0.016 | 45717
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -3436 | 0.016 | 2025-04 |  |  |  |  | A02:FAN | D | Work order demand | -3436 | 0.016 | 45748
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-04 |  |  |  |  | A02:FAN | D | OEM |  | 0.016 | 45748
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -4524 | 0.016 | 2025-05 |  |  |  |  | A02:FAN | D | Work order demand | -4524 | 0.016 | 45778
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-05 |  |  |  |  | A02:FAN | D | OEM |  | 0.016 | 45778
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -4732 | 0.016 | 2025-06 |  |  |  |  | A02:FAN | D | Work order demand | -4732 | 0.016 | 45809
 |  |  |  |  |  |  |  | A02:FAN | D | Planned order | 10000 | 0.016 | 2025-06 |  |  |  |  | A02:FAN | D | Planned order | 10000 | 0.016 | 45809
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-06 |  |  |  |  | A02:FAN | D | OEM |  | 0.016 | 45809