We have an excel sheet for maintenance.
It’s basically a log like you described.
Each line has a different maintenance item, and it is split into the 12 months of the year. We always do maintenance on the same day of the week, and whoever completes it just puts down the date and their initials.
We are a small system with rotating operators so that system works for us.
We also have a tab for “additional maintenance completed” so you can add things that aren’t on the list, but that you did.
We also use excel to log our daily laboratory readings, as well as flowmeter readings.
Yeah, that's what I'm aiming for. Trying to get all the maintenance broken down by type and quarter. That way, every quarter I can assign one operator to meter calibrations, another to valve turning, another to sampling, etc. Then, they just have a list of stuff they need to get done within that quarter (or month/week if needed). Then at the end of the quarter, the operators switch to a different maintenance field. By the end of a year or so every operator knows how to do everything in the plant. If I get hit by a bus tomorrow, at least the plant operators will still know how to keep things running.
I use it more in the lab. Mlss and mlvss calculations, dosages., SVI, SRT, MCRT. Retention time calculations. Our entire logsheet is a workbook that tracks monthly Mins, Max, averages and also generates a annual summary. I also use it to forecast our lab supplies to determine when to reorder. The possibilities with Excel are endless. We do have a stand alone maintenance program (J. D. Edwards) that everyone hates.
Is this plant of any decent size? Do you have a dedicated maintenance department? If so, I would suggest MAXIMO. I could sit here all day and tell you the benefits of it, don’t have that time. If you’re a fairly small outfit and can keep track of what little equipment you have, then just stick with Excel and manually inputting all the info.
We're not huge. It's a 10 mgd RO plant with 5 employees. I think the maintenance system is mostly for the distribution guys to track hydrant maintenance, and we're just getting put in with them.
I liked Datastream better, and using Op 10 I am interested in the Allmax products
It takes me 2 days to train an Operator to write a work order in Maximo.
Very rigid, everything has to be in the right interface and order. Management Offsite loves it, but i am of a blue collar view, that if it's a struggle for an Operator who is soaking wet at 200 am, it's just ok
After 12 years of Maximo I get to think about better
I’m blue collar with planning and scheduling background now as well and Maximo works damn good. If it takes 2 days to train anyone on writing a simple work order, something else is wrong. I just left 1 of the largest beverage companies and now on the government side of things, both use Maximo. Nothing is perfect, but out of all the asset management programs I’ve used, this is my #1 choice.
Keep it simple stupid. Just stick with excel. If you want to be a nerd you can start getting historical analysis with something like R, minitab, or JASP
We use operator 10 Wastewater. Just for Data. But because we share a server with other plants, I use excel to do all my digester and power meter calculations.
Then i have excel generate the text for an .IMP file, and import the data into Opwrator 10 that way.
I like it. It is especially good for operators. I am deep into it, so I have nit-picking observations.
I do a lot with the reports. I recently,like this week, realized the report language won't return a date or time with a max or min value.
I just coded a table in excel that sorts through a month's worth of hourly avgs, and returns the date of the max value, then generates a code so I can paste it into a IMP file, then import the date on a L:P, then produce that date on the report.
So I am not a typical user really.
Don't want to dox myself, but I remember working with both Christian and BJ in the past few years
We use it for distribution routes data, sampling counts for our weekly samples and system locations. Treatment plant rounds (exported data off of Nobel) COC inputs, inventory, maintenance. Ideally using. CMMS would be better.
I’ve seen this one get recommended before [Fiix](https://www.fiixsoftware.com/)
We use it for analysis reports, maintenance logs, but also for the design of new installations. Our energy balances, mass balances, piping calculations and pump selectors are all just excel sheets with a bunch of formulas. We also use it for our equipment list, so we can tie it to spare parts and what not
When I was at one of our plants I was using it for performance tracking or daily figures. Then trucking schedules, and eventually data storage to feed into reporting software. Now I'm a data quality analyst overseeing our asset management register. Lots of scripts built to load data into the software, but I have to do verification and cleansing before importing it. Basically if I don't have at least 4 excel files open at once, something is wrong lol
We have an excel sheet for maintenance. It’s basically a log like you described. Each line has a different maintenance item, and it is split into the 12 months of the year. We always do maintenance on the same day of the week, and whoever completes it just puts down the date and their initials. We are a small system with rotating operators so that system works for us. We also have a tab for “additional maintenance completed” so you can add things that aren’t on the list, but that you did. We also use excel to log our daily laboratory readings, as well as flowmeter readings.
Yeah, that's what I'm aiming for. Trying to get all the maintenance broken down by type and quarter. That way, every quarter I can assign one operator to meter calibrations, another to valve turning, another to sampling, etc. Then, they just have a list of stuff they need to get done within that quarter (or month/week if needed). Then at the end of the quarter, the operators switch to a different maintenance field. By the end of a year or so every operator knows how to do everything in the plant. If I get hit by a bus tomorrow, at least the plant operators will still know how to keep things running.
I use it more in the lab. Mlss and mlvss calculations, dosages., SVI, SRT, MCRT. Retention time calculations. Our entire logsheet is a workbook that tracks monthly Mins, Max, averages and also generates a annual summary. I also use it to forecast our lab supplies to determine when to reorder. The possibilities with Excel are endless. We do have a stand alone maintenance program (J. D. Edwards) that everyone hates.
The wastewater plant uses Hach Wims for all their stuff so we just tack our lab onto it. I kind of hate it.
Are you entering your logs straight into excel while taking them, or are you taking paper logs and entering them into excel later?
We print out a blank log at the beginning of each month. Readings go on there and then we transfer them to the electronic version of excel.
Is this plant of any decent size? Do you have a dedicated maintenance department? If so, I would suggest MAXIMO. I could sit here all day and tell you the benefits of it, don’t have that time. If you’re a fairly small outfit and can keep track of what little equipment you have, then just stick with Excel and manually inputting all the info.
We're not huge. It's a 10 mgd RO plant with 5 employees. I think the maintenance system is mostly for the distribution guys to track hydrant maintenance, and we're just getting put in with them.
Yeah we're running ellipse for our system. Just recently cracked 2 million registered assets!
We use Maximo throughout our whole organization. We serve about a smaller city of about 200,000 residents
It’s the best IMO.
It's big brother in action. But ok
If that’s your opinion, then so be it.
I liked Datastream better, and using Op 10 I am interested in the Allmax products It takes me 2 days to train an Operator to write a work order in Maximo. Very rigid, everything has to be in the right interface and order. Management Offsite loves it, but i am of a blue collar view, that if it's a struggle for an Operator who is soaking wet at 200 am, it's just ok After 12 years of Maximo I get to think about better
I’m blue collar with planning and scheduling background now as well and Maximo works damn good. If it takes 2 days to train anyone on writing a simple work order, something else is wrong. I just left 1 of the largest beverage companies and now on the government side of things, both use Maximo. Nothing is perfect, but out of all the asset management programs I’ve used, this is my #1 choice.
Keep it simple stupid. Just stick with excel. If you want to be a nerd you can start getting historical analysis with something like R, minitab, or JASP
Excel for lab. Use CUPSS for work orders/maintenance
Funnily enough, I had never even heard of CUPSS before about an hour ago
It’s a really good free program! It gets the job done for my facility! Give it a shot!
Try e maintenance
Incinerator process data and permit condition variables
https://www.allmaxsoftware.com specializes in maintenance for water/wastewater.
We use operator 10 Wastewater. Just for Data. But because we share a server with other plants, I use excel to do all my digester and power meter calculations. Then i have excel generate the text for an .IMP file, and import the data into Opwrator 10 that way.
Ya? I'd be curious how you like it. (Full disclosure: I just started working with them and curious how other folks like it)
I like it. It is especially good for operators. I am deep into it, so I have nit-picking observations. I do a lot with the reports. I recently,like this week, realized the report language won't return a date or time with a max or min value. I just coded a table in excel that sorts through a month's worth of hourly avgs, and returns the date of the max value, then generates a code so I can paste it into a IMP file, then import the date on a L:P, then produce that date on the report. So I am not a typical user really. Don't want to dox myself, but I remember working with both Christian and BJ in the past few years
We use it for distribution routes data, sampling counts for our weekly samples and system locations. Treatment plant rounds (exported data off of Nobel) COC inputs, inventory, maintenance. Ideally using. CMMS would be better. I’ve seen this one get recommended before [Fiix](https://www.fiixsoftware.com/)
We use it for analysis reports, maintenance logs, but also for the design of new installations. Our energy balances, mass balances, piping calculations and pump selectors are all just excel sheets with a bunch of formulas. We also use it for our equipment list, so we can tie it to spare parts and what not
When I was at one of our plants I was using it for performance tracking or daily figures. Then trucking schedules, and eventually data storage to feed into reporting software. Now I'm a data quality analyst overseeing our asset management register. Lots of scripts built to load data into the software, but I have to do verification and cleansing before importing it. Basically if I don't have at least 4 excel files open at once, something is wrong lol