Sign up Calendar Latest Topics Donate
 
 
 


Reply
  Author   Comment  
MarkL

Avatar / Picture

Sr. Member
Registered:
Posts: 1,121
Reply with quote  #1 
Hi There has anyone used anything like heat map software to create info grams for giving overviews of the condition of customers machines? I do a lot of monthly surveying and use a two pronged approach of
1. A general report  with the machines in need of looking at on a pdf format which the customer distributes to his fitters/maintenance staff.
2. An excel sheet which I call the 'machine status matrix' which is a month on month color coded map of green,yellow and red squares to indicate the current condition of the machines and the maint manager normally keeps this as an over view to the plant history etc. The thing is I am Kinda looking for some sort of excel Macro or dedicated data mining software which can possibly turn the information into a heat map,

On the whole is a kinda pet project at the moment and I have seen snazzy info-grams used for indicating machine severity eyc and wanted to try and emulate something similar.
Edwin

Avatar / Picture

Sr. Member
Registered:
Posts: 131
Reply with quote  #2 
What is it that you want to do? Make the data you have allready in Excel into a graphic or something else? I don't quite get it.
__________________
= Cost Effective Asset Management =
MarkL

Avatar / Picture

Sr. Member
Registered:
Posts: 1,121
Reply with quote  #3 
Yes more or less Edwin, I have seen something similar done lately to have as a priority indicator if you get me? the darkest red item is the most critical and the greenest items are ok and need no actions, something which can be done on a monthly basis or as per report,
I presume you report with the standard reporting module on @ptitude Analyst? i.e. add notes to machines when analyzing the data and then generate a report with the built in templates??
Edwin

Avatar / Picture

Sr. Member
Registered:
Posts: 131
Reply with quote  #4 
No. I import last measurement dates from @ptitude into an excel file with vba. It is a file that generates nice route reports with a line per equipment. On each line I can write comments manually and afterwards generate a pdf file of this report. In this file I also have an overview tab to see what routes are ready and how fast the were analized.

I can do nice things with excel and even more combined with vba. So if you need help let me know.

__________________
= Cost Effective Asset Management =
MarkL

Avatar / Picture

Sr. Member
Registered:
Posts: 1,121
Reply with quote  #5 
Thats Interesting Edwin, is the VBA a separate software or a skf product?
Edwin

Avatar / Picture

Sr. Member
Registered:
Posts: 131
Reply with quote  #6 
VBA, or visual basic for applications, is embedded in excel (and also in other office programs). You can write scripts with it to do anything within your files and even outside it. Maybe you know macros in excel. That is a simplified method to create vba scripts.
Need some experience to program it. But since I grew up with the first generations of home computers (like commodore 64 [wink] ) I am familiar with programming in Basic and it looks a lot like it.


__________________
= Cost Effective Asset Management =
MarkL

Avatar / Picture

Sr. Member
Registered:
Posts: 1,121
Reply with quote  #7 
Ah right!,, wow I have to look at excel more, do you use the numerical output from the CSv export from aptitude? Or output from analyst do you use ?
Edwin

Avatar / Picture

Sr. Member
Registered:
Posts: 131
Reply with quote  #8 

I use a report from aptitude with only two things in it: machine name and last measurement date. That html file data is imported to the excel by pushing a button and selecting that file to open.
Was a hell of a job to get it all working perfect, but now it is used by 4 people for more than 3 years.


__________________
= Cost Effective Asset Management =
gtipredictive

Member
Registered:
Posts: 6
Reply with quote  #9 
Heat maps can be pretty valuable to visualize the data being captured. It can also remind you to reassess thresholds for green, yellow, and red. If a machine has been in the red far past what would be expected then perhaps that machine's profile could use an adjustment to its thresholds.

Our approach to heat mapping at GTI looks at the data in a special algorithm that incorporates the rate of failure along with its current health. Our map helps to visualize assets to be aware of even if currently they are in the green, because that asset's readings indicate it is going to rapidly degress into the yellow and fail at a faster rate than say a current yellow asset that isn't showing signs of as rapid of a health degradation.

We do all of this computation with our web application and let the servers do the heavy lifting. I think a heat map is a great tool and something that can be a real eye opener for planning maintenance prior to failure.
MarkL

Avatar / Picture

Sr. Member
Registered:
Posts: 1,121
Reply with quote  #10 
This is an old topic I started a few months ago, I'm still curious to any links to some sort of report writing software where I can input text and images in fields and then click 'generate' André it can spit out a HTML or word document. Currently I find the software I use isn't great as I can only add photos and thermal image after I generate the canned report, I tend to write my reports in a table basis with a headings of Machine, Findings, severity, craft, and recommendation, columns, then I have to tag image a onto the end of it.

Any suggestion would be helpful, I found some entries on the amp site but most are large enterprise wide software aimed at in house program smith more so than something suiting a small service provider.

Regards,
Mark.
RustyCas

Avatar / Picture

Admin
Registered:
Posts: 1,810
Reply with quote  #11 
Mark, have you ever looked at something like FileMaker Pro?  I haven't used database software in years, but once upon a time I used a database program (can't recall what it was) to do reports.  I had a lot of fields that I'd fill in, and then I would use the report writer to build templates that would just extract the data I wanted to use in the report.  You could likely get the heatmap you want that way, using a calculated field in the report, based on the value of a field in your database.

The advantage of this approach is that you could include as much information as you wanted in your database, and generate different types of reports, depending on who they were going to.  I have never used the CSI report functions because they don't present the information the way I'd like.


__________________
"The trend is your friend"
MarkL

Avatar / Picture

Sr. Member
Registered:
Posts: 1,121
Reply with quote  #12 
Thanks, Rusty,
I haven't heard of it but I will look into it and see what its like.
Yeah you pretty much hit the nail on the head.
RustyCas

Avatar / Picture

Admin
Registered:
Posts: 1,810
Reply with quote  #13 
If I were starting my business over, I would use something like this to record all my observations, "calls", notes, machine history, machine info (speed, bearings, gearing, etc), so that I could generate reports any way I desired.  For instance, every "call" with "bearings, internal looseness", or "loose base bolts", etc.

This would allow me to develop statistics for my "body of work" (22 years) across all my customer databases.  Such information could easily form the basis for a profitable consultancy in machinery reliability as I enter my golden years.  I would encourage you, if you are just starting out, to consider how you might "capture" your experience over the years, so you know 'why' you think as you do, and whether or not your thinking is valid.  

I think I "know" a lot of things about machinery, but do I really?  How do I know for sure?


__________________
"The trend is your friend"
MarkL

Avatar / Picture

Sr. Member
Registered:
Posts: 1,121
Reply with quote  #14 
Rusty That's along the lines of what I want to do, I have been collecting technical references on pretty much everything related to my field the last 6 years and use ...yes Evernote again... to collect and file them under various sections, I want to have a database of my reporting work to reference back on as well, we generate an excel matrix table with comments on the reports per machine per month as a quick access and a pdf detailed document to circulate to the mechanics etc, I know little about databases but I image if I can tap into the excel data I have, I could start something, the comments are inserted as comments in the cells of excel sheet and each of my customers has one, then the cell is coloured according to the machines severity at the time of survey.
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.