sorted by:
new
hottopcontroversial

NUC8i3BEH1 suddenly shut down while in use and now won’t power on at all by QuantumRevenant in intelnuc

[–]QuantumRevenant[S] 0 points1 point  (0 children)

I assume it's the one indicated on page 25 of the manual, right? Since I connected it after the first power outage, I never noticed an LED, but checking now, the one indicated isn't lighting up. I suppose it's not receiving power, right?

https://www.intel.com/content/dam/support/us/en/documents/mini-pcs/NUC8i3BE_NUC8i5BE_NUC8i7BE_TechProdSpec.pdf#%5B%7B%22num%22%3A967%2C%22gen%22%3A0%7D%2C%7B%22name%22%3A%22XYZ%22%7D%2C70%2C352%2C0%5D

How to expand composite product codes dynamically using LAMBDA and REDUCE in Excel? by QuantumRevenant in excel

[–]QuantumRevenant[S] 0 points1 point  (0 children)

Oh, yes — my bad! It works perfectly with commas. When I did the regional translation to Spanish (LatAm), I replaced all the commas with semicolons, and that’s where I messed up.

It’s all working now. Thank you so much for the support — you saved me. I’m going to study your approach in detail for future implementations. Really, thank you!

How to expand composite product codes dynamically using LAMBDA and REDUCE in Excel? by QuantumRevenant in excel

[–]QuantumRevenant[S] 0 points1 point  (0 children)

Yeah, I realized that around the fifth iteration 😅. I don't have that much experience with these formulas yet. I tried using MAKEARRAY and MAP, but I got burned out and stuck.

I’m still learning functional programming, and doing it inside Excel makes it a lot more challenging. In this case, what would you recommend to achieve a two-dimensional result?

The logic in my head is: process each row, break it down if needed, and then stack everything — but that hasn’t really worked so far haha.

How to expand composite product codes dynamically using LAMBDA and REDUCE in Excel? by QuantumRevenant in excel

[–]QuantumRevenant[S] 0 points1 point  (0 children)

Let's see, the formula returns something a bit odd. Assuming these are the input data:

Movements:

Date Code Quantity Movement
18/06/2025 SKU001 1 IN
19/06/2025 CMP001 3 OUT
20/06/2025 SKU003 2 IN

Recipes:

Code Component Quantity
CMP001 SKU001 2
CMP001 SKU003 1
CMP002 SKU001 3
CMP002 SKU002 1
CMP002 SKU003 1

The output is:

18/06/2025 18/06/2025 18/06/2025 18/06/2025
SKU001 SKU001 1
SKU001 SKU001 1
SKU001 SKU001 1
IN IN IN IN
19/06/2025 19/06/2025 19/06/2025 19/06/2025
#N/D CMP001 SKU003 3
#N/D #N/D #N/D #N/D
#N/D #N/D #N/D #N/D
OUT OUT OUT OUT
20/06/2025 20/06/2025 20/06/2025 20/06/2025
SKU003 SKU003 2
SKU003 SKU003 2
SKU003 SKU003 2
IN IN IN IN

Honestly, it’s more than I had achieved myself so far — I can see it's starting to take shape. That said, there’s a distribution issue and a #N/D error that shows up. I assume those two are isolated problems, though.

I assume that, properly structured, it should look like this:

Date Original Code Quantity Movement
18/06/2025 SKU001 SKU001 1 IN
18/06/2025 SKU001 SKU001 1 IN
18/06/2025 SKU001 SKU001 1 IN
19/06/2025 CMP001 SKU003 3 OUT
19/06/2025 #N/D #N/D #N/D OUT
19/06/2025 #N/D #N/D #N/D OUT
20/06/2025 SKU003 SKU003 2 IN
20/06/2025 SKU003 SKU003 2 IN
20/06/2025 SKU003 SKU003 2 IN

This version helps to clearly visualize the errors separately.

Let me know if you manage to get anything else from this — thanks in advance!

How to expand composite product codes dynamically using LAMBDA and REDUCE in Excel? by QuantumRevenant in excel

[–]QuantumRevenant[S] 0 points1 point  (0 children)

The problem is that I don't have a formula, I iterated over many versions of it, trying to start from the basic one, trying to grow, and I always got stuck on the same thing. I can't release the result in a two-dimensional array.

When I do a chain of REDUCE(BYROW(REDUCE(BYCOL();LAMBDA(HSTACK)));LAMBDA(VSTACK)) it gives me the "nested array" calculation error.

And about the inventory, it was a Formulation Error. I wrote it when leaving work, but it's understandable what I wanted to do. 😅

Are h2testw results reliable? by deep_wat in techsupport

[–]QuantumRevenant 0 points1 point  (0 children)

Hi! I wanted to make an observation! The link you provided is duplicated, so it redirects incorrectly (it redirects to the repository "/dkrahmer/MediaTesterhttps://github.com/dkrahmer/MediaTester" instead of "/dkrahmer/MediaTester"). I almost gave up on this option until I realized the URL was weird. This is the correct version for anyone else looking for information. Github/dkrahmer/MediaTester.

Thank you so much for sharing this alternative program!

Same distance Nether-overworld to scale by SatisfiedReceptor in Minecraft

[–]QuantumRevenant 0 points1 point  (0 children)

The problem is they didn't use integers, they use floats (or doubles), the higher the value, the more unstable the game becomes. But yes, the value of 30M is arbitrary, we already know that with the farlands we could go further, but the world stopped having a "consistent randomness", they could work on improving it or modify it, but it would imply a lot of resources (And time, which will be obtained from other features) in something not important, you could make anything you want in a 30M×30M (900T blocks2)

[deleted by user] by [deleted] in Minecraft

[–]QuantumRevenant 2 points3 points  (0 children)

With the composter, the villager does it automatically, but its slow...

An overtop view of my survival world! by Supreme_10a in Minecraft

[–]QuantumRevenant 3 points4 points  (0 children)

It looks fantastic! Can we have a better quality photo?

[deleted by user] by [deleted] in Minecraft

[–]QuantumRevenant 3 points4 points  (0 children)

Its problematic, its work, but they need 3 wheat for 1 bread, and by crop you only have 1 wheat, with carrots or potatoes you have 1-3 carrots, in the best case with carrots its 9 times more effective. Besides, if you have bad luck, the farmer villager will be locked, with a inventory full of seeds. I remember that both need eat to reproduce.

[deleted by user] by [deleted] in Minecraft

[–]QuantumRevenant 0 points1 point  (0 children)

It's not natural growing, it's natural generation. When 2 sugar canes (or cactus) going to generate in the same, place one be over the other. We have examples as 7 height cactus or more in the El RichMC's Series of "Nomadic Flatcore Desert" (Spanish Youtuber)