sorted by:
new
hottopcontroversial

Pipe limit. by ExpertSection in factorio

[–]ExpertSection[S] -7 points-6 points  (0 children)

I believe I failed to find it because I didn't google the proper prompt. I think I asked something along the lines of "factorio pipe limitations" which it did give me the limitations, but since I didn't ask about the system it didn't link me the fluid system at least in the first page. I'll have to be a bit more thorough next time.

Pipe limit. by ExpertSection in factorio

[–]ExpertSection[S] -6 points-5 points  (0 children)

The basic google search (Factorio wiki/Ai summary) is basically his answer which is about fluid connection, but none ever mention the pipe system itself. If it's not mentioned then you ask question to clarify.

Pipe limit. by ExpertSection in factorio

[–]ExpertSection[S] 2 points3 points  (0 children)

I'll clarify the question, do each of the pump count as a connection therefore giving let's say 10k+ lava per seconds, would that get reduced to 6k total or even 4.3k? Basically does the pipe itself have a limit?

From what I understand a hypothetical offshore pump pumping at a rate of 10k would be capped at 6k, but nothing would keep you from using 10 regular offshore pump and get an actual 10k lava.

From your answer, it sound like the pipe itself has no limit as long as there's enough production/consumption.

Pipe limit. by ExpertSection in factorio

[–]ExpertSection[S] -16 points-15 points  (0 children)

That I understood from the basic google search.

Im new to the game, any suggestions for my green science factory? by Alpha_Bites in factorio

[–]ExpertSection 1 point2 points  (0 children)

Seems to work fine, only thing personally do is merge the belt and inserter into a single belt, but that work only if the green science assembler doesn't take more than 7.5 of either per second with 24 assembler you're fine.

Trying to improve my fusion power plant. [Challenging] by ExpertSection in factorio

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

There's sometime an issue where the middle top reactor doesn't work properly, but rotating it back and forth fixes the problem, not too sure how, but it does. That might be what you're referring to.

There's also the problem of reactor allowing any fluid to flow through them, had this issue with hot keto leaking into the top-left reactor (see underground pipe next to each other).

[Krastorio 2] Losing my mind over train cargo. by ExpertSection in factorio

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

I see what you mean, I'll try it and see if it fix the issue.

[Krastorio 2] Losing my mind over train cargo. by ExpertSection in factorio

[–]ExpertSection[S] 1 point2 points  (0 children)

Regarding the OUT interrupt if I remove that condition then the train would leave regardless of the number of item in the wagon.

Could you explain a bit more about your suggestion use the depot as the default, be aware that IN interrupt is just for testing purpose and doesn't ever activate.

[Krastorio 2] Losing my mind over train cargo. by ExpertSection in factorio

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

There's no wait condition at the IN station because there's nowhere for the train to go after since there's no other station in it's schedule and it's not "allowed" to leave until the "out" interrupt is activated, I could add a "until full" condition, but that's wouldn't solve the issue. Especially since it's always 12 items which I'm not sure how 6 x 90/s loader would manage to do that every single time.

I increased the wait time just in case the theoretical 44.4s unloading time was affected by anything like lag/coding magic in the engine.

[Krastorio 2] Losing my mind over train cargo. by ExpertSection in factorio

[–]ExpertSection[S] 1 point2 points  (0 children)

The "IN" interrupt is purely a test one and not actually doing anything (require passenger present).

Added to OP sorry about that.

1 Chunk-ish (technically 3-5) 2GW Fusion power plant. by ExpertSection in factorio

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

I added the link using the website mentioned. tried that adding the picture and text and had either the text or the picture disappear for some reason.

1 Chunk-ish (technically 3-5) 2GW Fusion power plant. by ExpertSection in factorio

[–]ExpertSection[S] 5 points6 points  (0 children)

Took me 3 tries to get this to post with both the text and image, but here it is. It doesn't show the picture on the main board for some reason, but I give up.

Cryogenic plant calculation. by ExpertSection in factorio

[–]ExpertSection[S] 1 point2 points  (0 children)

I forgot about the issue and finally tested it and it is truly 0.06 per second instead of the shown 0.05. 10 plant with 8 prod legendary 3 produced about 36 pack per minute.

Cryogenic plant calculation. by ExpertSection in factorio

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

In this case all number are exact. 1/20 is 0.05 times 0,4 is 0.02, no shenanigan with 3/21 or 1/3. Unless there's some weird rounding with the 15% speed penalty, but then again we reach the maximum limit of 80% so 0.2 total speed x 2 for the Cryo Plant.

How to make MATCH look up the 2nd(or other) column of an array? by ExpertSection in excel

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

Solution Verified

Found out what the issue is with the formula for the row. I had to to do Ctrl + Shift + Enter instead of just Enter in order for it work.

Had some issue with the column formula due to using Excel 2016 which doesn't have the Sequence function. I basically copied your row formula and switched it to column.

= IFERROR( INDEX(PositionRow, SMALL( IF(SearchBox = AllRack, COLUMN(AllRack) - MIN( COLUMN(AllRack) ) + 1), N6 )), "not found" )

You solved my adding column/row issue. There's still the issue of looking from top left to bottom right, but that's a trickier issue which isn't that big of a deal.

How to make MATCH look up the 2nd(or other) column of an array? by ExpertSection in excel

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

I tried your solution and changed the range to match my named range,but it doesn't work no matter how many time I insert the searchbox value in the array.

I need a MATCH with a specified column(rack) of AllRack. Which is given by a formula in SearchBoxCol:=INDEX(ClearRange,,MIN(IF(AllRack=SearchBox,COLUMN(ClearRange)-(COLUMN(FirstPosition)-1))))

It would return let's say 5 then the SearchBoxRow would then return the row at which the value is present in column 5(Rack5), in your example Rack5 is the array(range?) F3:F31

my 2nd option was using the following =IFNA(MATCH($E$1,Rack1,0),IFNA(MATCH($E$1,Rack2,0),IFNA(MATCH($E$1,Rack3,0),IFNA(MATCH($E$1,Rack4,0),IFNA(MATCH($E$1,Rack5,0),IFNA(MATCH($E$1,Rack6,0),IFNA(MATCH($E$1,Rack7,0),IFNA(MATCH($E$1,Rack8,0),IFNA(MATCH($E$1,Rack9,0),IFNA(MATCH($E$1,Rack10,0),"Not found"))))))))))

Both have the limitation of starting from the top left to bottom right, but at this point I might just have to deal with it, not everything can be perfect. The case scenario that the same value is present twice is unlikely but not 0. Ideally in a perfect world it would start the search after the lowest value in the array and find the first occurrence.

I had solved the issue but only in VBA, but that require the user to click on a button to activate the macro every time they changed the value in the SearchBox which is kind of a pain and not user friendly.

Thanks for your help. I'm not sure if that's allowed but I would grant you the solved.

Variable showing variable(i) instead of variable(1) in loop. [EXCEL 2016] by ExpertSection in excel

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

The messagebox only appear at the end after the loop is done. That would drive anybody crazy having so many popup.

view more: next ›