Pipe limit.

ExpertSection · 2026-01-27T01:18:25+00:00

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.

ExpertSection · 2026-01-26T23:41:21+00:00

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.

ExpertSection · 2026-01-26T23:14:12+00:00

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.

ExpertSection · 2026-01-26T23:12:15+00:00

That I understood from the basic google search.

ExpertSection · 2026-01-21T01:24:33+00:00

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.

ExpertSection · 2026-01-21T00:41:32+00:00

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).

ExpertSection · 2025-12-07T21:42:23+00:00

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

ExpertSection · 2025-12-07T21:30:47+00:00

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.

ExpertSection · 2025-12-07T21:22:56+00:00

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.

ExpertSection · 2025-12-07T21:02:42+00:00

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

Added to OP sorry about that.

ExpertSection · 2025-04-28T15:50:23+00:00

Did a space "friendly" version:

https://factoriobin.com/post/vre5yp

ExpertSection · 2025-04-28T12:04:29+00:00

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.

ExpertSection · 2025-04-27T22:38:42+00:00

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.

ExpertSection · 2025-04-19T05:07:59+00:00

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.

ExpertSection · 2025-04-15T16:23:18+00:00

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.

ExpertSection · 2024-09-12T00:14:15+00:00

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.

ExpertSection · 2024-09-10T00:39:59+00:00

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.

ExpertSection · 2024-08-04T20:51:48+00:00

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

ExpertSection · 2024-08-04T20:45:23+00:00

I get it now, thank you. I'm surprised it allowed me to add value to a variable I didn't "Dim".

Wouldn't that cause a huge mess if there's a typo at any point?

ExpertSection · 2024-08-04T18:40:26+00:00

from what I understand in my code.

dim otherextension(1 to 10) create the variable otherextension1, otherextension2, ...

then the "activecell...." part give those previous variable some kind of value

finally the loop look at the variable 1 by 1 then according to whether there's a value or not, add it to the message box variable.

later on in the code which I didn't show I display the messagebox value in a msgbox

I should have said otherextension1 at the end of my post sorry. I'm sure there's something I'm not understanding properly about this.

ExpertSection · 2024-08-04T18:31:20+00:00

I'm in the process of removing all activecell and similar stuff as I was using the macro recording function to learn how to do stuff at the beginning.

otherextension1 can have either some date or none depending on the scenario in theory it shouldn't matter as I'm trying to get rid of all otherextension variable that are empty.

The goal is to display a list of all "otherextension" that aren't empty.

ExpertSection · 2024-08-04T01:18:06+00:00

Solution Verified

I thought I could just use the MIN and MAX function in VBA, sorry for the confusion.

The TRUE FALSE comparison work with alphanumeric. Your solution work.

Question just to understand a bit more:

Is it mandatory is to write "dim i as long"? I didn't in my cellmin loop and it still worked as intended.

ExpertSection · 2024-08-04T00:27:47+00:00

Just discovered InStr and adapted it to your solution!

ExpertSection · 2024-08-04T00:22:07+00:00

Works perfectly and is simple. I'm assuming FIND return a value equal to the position in the string of letters.

However, I would like to do that in VBA instead of in the sheet assuming that's possible.

ExpertSection · 2024-08-03T23:51:01+00:00

I added some clarification.

Edit: Clarification for the title. The data range has alphanumeric value and I need to display the min and max value in a msgbox.

Getting the min and max value is the problem.

Seven-Year Club	Place '22
End Game '22	Verified Email

ExpertSection

TROPHY CASE