Forum Home
PC World Chat
Thread ID: 67836	2006-04-07 08:01:00	Complicated Maths modelling question	John W (523)	PC World Chat

Post ID	Timestamp	Content	User
444754	2006-04-07 08:01:00	Hi there A few years back I created a spreadsheet for the Industry I as involved in. At the start of the shift, you entered in the pond levels, flows through irrigation races etc which then produced expected lake levels in hourly increments for the next 8 to 12hrs. This was on a series of cascading ponds but there were variations in drawoff which could lead to irrigation races or ponds exceeding designed guidelines. I had control of the irrigation flows and the resultant pond levels but there were minimium flows you had to meet. This was very easy to do, but I was always stumped when the projected pond level of say a mid steam pond came to upper or lower level limit, then I would have to manually reduce or start a flow to ensure no operational breach took place. Then, on the week I was due to leave, an engineer was designing a mathmatical model that would/could taper each flow as the ponds came up to a boundary and start filling or emptying as required. Complicating matters, we had a certain amount of water to move per shift. This process is now computerised and I was laid off before it was fully commissioned. So, whats the branch of maths that was/would have been used to calculate and manipulate water flows as described above. Thanks....... John in Mosgiel.	John W (523)
444755	2006-04-07 08:28:00	Just my thoughts (albeit without industry experience) : the branch of maths could be statistics for looking at historical / projected usage and then logic / control tests to trigger gates when low / high pond marks were met. Unless I'm misunderstanding your question...... A	andrew93 (249)
444756	2006-04-07 10:38:00	You right I guess, my work was just a straight line progression, up or down. The version that replaced me was able to taper off, hold level or put in negative values to bring about a downhill trend. That part I couldnt understand. Cheers......John.	John W (523)
1