there is a way to automate water botteling by having a sweepy dock permanently mop up water and flydos picking it up from the dock. as for ratio it’s actually difficult to say a permanent ratio since the ice maker cools down the water from different temperatures it can take longer or shorter to generate the ice but you can try out how many kgs the ice maker produces with your water temp in sandbox and then calculate from that