Spreadsheet: 884203d1733279775-looking-for-best-formula-to-explode-boms-test-bom-expo-1-
Sheet: Example

[NAME]
Item |  |  |  | Count | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
TEST2 |  |  |  | 100 | 365100
Test3 |  |  |  | 100 | 200000
TEST1 |  |  |  | 120 | 254880
[NAME] | UNITID_Assy | UNITID_Child | PerAssemblyQty | TopAssemblyQty | Manual Calc'd
TEST2
R1471 | M | [NAME] | 0.045 | 0.0054
R1682 | M | [NAME] | 0.0001 | 1.2e-05
R3217 | M | [NAME] | 0.015454 | 0.001854
R621 | M | [NAME] | 0.006707 | 0.000805
R4774 | M | [NAME] | 0.04 | 0.0048
K677 | M | [NAME] | 0.022335 | 0.00268
R1302 | M | [NAME] | 0.107143 | 0.012857
R214 | M | [NAME] | 0.283784 | 0.034054
R2557 | M | [NAME] | 0.042 | 0.00504
R289 | M | [NAME] | 0.0525 | 0.0063
R675 | M | [NAME] | 0.106061 | 0.012727
R965 | M | [NAME] | 0.0525 | 0.0063
R270 | M | M | 1 | 0.12
R145 | M | [NAME] | 0.01375 | 0.00165
R626 | M | [NAME] | 0.03 | 0.0036
PL228007-A | EA | M | 0.001 | 1
P464 | EA | M | 0.001 | 1
P124 | EA | M | 0.001 | 1
PB267 | EA | ea | 0.041667 | 0.041667
WF274 | EA | M | 0.12 | 120
TEST1
K405 | M | [NAME] | 0.012 | 0.0012
R3597 | M | [NAME] | 0.021031 | 0.002103
R364 | M | [NAME] | 0.027442 | 0.002744
R366 | M | [NAME] | 0.037797 | 0.00378
[NAME] | M | [NAME] | 0.012427 | 0.001243
R5808 | M | [NAME] | 0.029153 | 0.002915
[NAME] | M | [NAME] | 0.018122 | 0.001812
R6179 | M | [NAME] | 0.009838 | 0.000984
R694 | M | [NAME] | 0.012984 | 0.001298
R774 | M | [NAME] | 0.017604 | 0.00176
R3636 | M | M | 1 | 0.1
K360 | M | [NAME] | 0.03825 | 0.003825
K368 | M | [NAME] | 0.03262 | 0.003262
R2225 | M | [NAME] | 0.057472 | 0.005747
R355 | M | [NAME] | 0.093243 | 0.009324
R358 | M | [NAME] | 0.010356 | 0.001036
R363 | M | [NAME] | 0.033137 | 0.003314
R3642 | M | [NAME] | 0.05799 | 0.005799
R4118 | M | [NAME] | 0.01398 | 0.001398
R6121 | M | [NAME] | 0.027442 | 0.002744
R6123 | M | [NAME] | 0.047117 | 0.004712
PL228174-A | EA | M | 0.001 | 1
P462 | EA | M | 0.001 | 1
P124 | EA | M | 0.001 | 1
PB153 | EA | ea | 0.05 | 0.05
B3886 | EA | M | 0.1 | 100
Consolidated Requirements
[NAME] | UNITID_Assy | UNITID_Child | PerAssemblyQty | TopAssemblyQty
R1682 | M | [NAME] | 0.0001 | 1.2e-05
R3217 | M | [NAME] | 0.015454 | 0.001854
R621 | M | [NAME] | 0.006707 | 0.000805
R4774 | M | [NAME] | 0.04 | 0.0048
K677 | M | [NAME] | 0.022335 | 0.00268
R1302 | M | [NAME] | 0.107143 | 0.012857
R214 | M | [NAME] | 0.283784 | 0.034054
R2557 | M | [NAME] | 0.042 | 0.00504
R289 | M | [NAME] | 0.0525 | 0.0063
R675 | M | [NAME] | 0.106061 | 0.012727
R965 | M | [NAME] | 0.0525 | 0.0063
R270 | M | M | 1 | 0.12
R145 | M | [NAME] | 0.01375 | 0.00165
R626 | M | [NAME] | 0.03 | 0.0036
PL228007-A | EA | M | 0.001 | 1
P464 | EA | M | 0.001 | 1
P124 | EA | M | 0.001 | 1
PB267 | EA | ea | 0.041667 | 0.041667
WF274 | EA | M | 0.12 | 120
K405 | M | [NAME] | 0.012 | 0.0012
R3597 | M | [NAME] | 0.021031 | 0.002103
R364 | M | [NAME] | 0.027442 | 0.002744
R366 | M | [NAME] | 0.037797 | 0.00378
[NAME] | M | [NAME] | 0.012427 | 0.001243
R5808 | M | [NAME] | 0.029153 | 0.002915
[NAME] | M | [NAME] | 0.018122 | 0.001812
R6179 | M | [NAME] | 0.009838 | 0.000984
R694 | M | [NAME] | 0.012984 | 0.001298
R774 | M | [NAME] | 0.017604 | 0.00176
R3636 | M | M | 1 | 0.1
K360 | M | [NAME] | 0.03825 | 0.003825
K368 | M | [NAME] | 0.03262 | 0.003262
R2225 | M | [NAME] | 0.057472 | 0.005747
R355 | M | [NAME] | 0.093243 | 0.009324
R358 | M | [NAME] | 0.010356 | 0.001036
R363 | M | [NAME] | 0.033137 | 0.003314
R3642 | M | [NAME] | 0.05799 | 0.005799
R4118 | M | [NAME] | 0.01398 | 0.001398
R6121 | M | [NAME] | 0.027442 | 0.002744
R6123 | M | [NAME] | 0.047117 | 0.004712
PL228174-A | EA | M | 0.001 | 1
P462 | EA | M | 0.001 | 1
PB153 | EA | ea | 0.05 | 0.05
B3886 | EA | M | 0.1 | 100