Software planning program for coatings5737227Abstract An interactive computer program for forecasting, prioritizing, planning and tracking paint, coating and lining maintenance work for the Facility assets of industrial and commercial complexes using an IBM compatible type computer. The assets include but are not limited to buildings, tanks, towers, structures, pools, docks and their sub components such as process piping, structure steel members, concrete floors, overhead cranes, blowers, pumps, motors, vehicle hoists, hardware, paneling, conduit, facades, exterior doors, interior doors, windows, and gutters that require painting over time. The novel invention uses a four step process. The first step is to break down the facility into asset groups, master components, and sub components. Second a condition survey of the master components and subcomponents is conducted followed by making work recommendations for each sub component. The third step is to develop coating system standards where coating systems, and cost data for the maintenance work is calculated. The fourth step covers work management which includes an assessment by sub component, recommendations are accepted and altered, costs are recalculated and various types of data operations are performed such as preparing management reports, historical data is reported and cost and schedule data is reported. Claims We claim: Description This invention relates to the strategic long term planning for the maintenance of paints, coatings and linings, and in particular to a novel computer program that anticipates future work requirements and costs associated with the recoating and repainting operations for industrial and commercial facilities such as but not limited to amusement parks, resorts, petroleum refineries, paper mills, power generating stations, municipal waste and water treatment systems, off shore oil drilling platforms, chemical processing plants, pharmaceutical plants, mineral processing facilities, cement plants, food and beverage preparation plants, ships, mines, office buildings, sports stadiums, automobile production and assembly plants, steel mills, electronic component manufacturing facilities, bakeries, manufacturing plants, agricultural production facilities, textile mills, lumber operations, printing and publishing plants, marinas, aircraft manufacturing plants, government aerospace facilities, railroad equipment manufacturing and repair facilities, pipelines and related equipment.
TABLE 1
______________________________________
Enter Master
Each master component is entered into the computer by its
Components
identification number. Also entered is a brief description of
140 the master component, the type of component it is
(decorative, facade, operational or structural), the date of
the entry, the criticality of the master component to the
desired operation of asset group (non-critical, moderate or
critical) and a notation as to location.
Enter Sub
Each sub component of each master component is entered
Components
into the computer by its identification number, under each
150 master component's identification number. The sub
component identification numbering system is a subset of
the master component's numbering system, which allows
for planning and prioritizing by both master component
relationships or by other broader relationships, such as
process systems. Also entered is a brief description of the
sub component, the date the sub component was created,
the substrate material (concrete, steel, aluminum, wood,
fiberglass, drywall, etc.), the criticality of the sub
component to the master component (non-critical,
moderate, critical), the total surface area of the sub
component which has been measured or calculated for each
sub component's parts and summarized as a total, the
elevation and location of the sub component. If a digitized
picture of the sub component is available, it may be
attached to this record at this time.
______________________________________
Referring to FIGS. 1A-1B, the Condition Survey Step 200 includes two substeps: Conduct Condition Survey 210 and Make Work Recommendations by Sub Components 220. Table 2 gives a detailed description of the implementation process for each of the two substeps 210.01-210.13 and 220.10-220.20 of Step 200. Step 200-Condition Survey
TABLE 2
______________________________________
Sub Step
Description
Implementation Process
______________________________________
Conduct Each sub component is visually inspected to rate and
Condition
record a number of physical attributes. This information
Survey is then input into the software program. The attributes
210 that are observed, rated and recorded are: 210.01-210.13
Exposure type
The sub component's exposure type is observed and
210.01 entered as atmospheric, ultraviolet, acidic, alkaline,
immersion, splash zone, salt spray and high temperature.
All that apply to this sub component are entered.
Operating
The sub component's operating environment is rated as
environment
one of the three types of operating environments-mild,
210.02 moderate or aggressive.
Substrate
The substrate condition of each sub component is rated as
condition
intact, superficial damage, structural damaged or
210.03 structurally failed.
Coating The coating integrity of the existing coating is rated as
integrity
excellent, good, fair or poor.
210.04
Select The location of the sub component is evaluated as to the
SubComponent
ability to be seen by the public. The ratings are hidden,
View210.05
visible and high profile.
Rate The overall appearance of the sub component is rated by
Appearance
the surveyor/inspector. The values of this attribute are
210.06 excellent, good, fair and poor.
Measure The adhesion of the existing coating to the substrate is
Adhesion rated as excellent, good, fair or poor. This rating can be
210.07 correlated with ASTM Adhesion Test Method D3359.
Defect Ratings
The sub component is inspected for any of 17 coating
210.08 defects. Once a defect is observed, it is rated as to its
frequency (minor, random, medium or extensive), its
possible consequences if left un repaired (aesthetic,
coating failure, structural collapse or creation of a safety
concern); the percentage of the sub component's area
(0-100%) that is affected by each observed defect is
measured and recorded
DFT (Dry Film
The dry film thickness of the existing coating is
Thickness)
measured using the appropriate test equipment. Several
210.09 representative measurements are made and recorded in
the DFT table to allow the software to calculate an
average coating thickness.
Hazardous
If the surveyor/inspector determines that a hazardous
Operations
material/condition may result for work on this sub
210.10 component-a notation is made as to the potential hazard
present.
Inspection
Based on the surveyors/inspectors observations and
Frequency
experience, the desired inspection frequency is selected
210.11 for this sub component-the choices are monthly, semi
annually and annually.
Survey/Inspect
Any comments that the surveyor/inspector feels
Comments appropriate are recorded at this time.
210.12
Assign picture
If a digitized photograph is available, it may be attached
210.13 to the record at this time.
Recommended
Based on the surveyors/inspectors observations and
work task 220
experience, a recommended work task may be made from
220.10 the following: inspect (sub component), touchup
(coating), re-coat (apply coating over the entire surface
area of the sub component), replace (coating) or (remove
and replace with) new construction
Application
Any conditions which are observed which, in the opinion
Cost of the surveyor/inspector, will raise the installation cost
Multipliers
of the coatings; is noted. The default conditions are
220.20 barricades, scaffolding, rigging, and confined space;
more can be added to accommodate each facility's
______________________________________
needs.
Referring FIGS. 1A-1B, the Coating System Standards Step 300 includes three substeps: Develop Coating Systems 310, Enter Cost Data 320 and Calculating Cost Per square Foot Applied 330. Table 3 gives a detailed description of the implementation process for each of the three substeps 310.01-310.11,320 and 330 of Step 300. Step 300-Coating Systems Standards
TABLE 3
______________________________________
Sub Step
Description
Implementation Process
______________________________________
Develop Coating systems are built to perform specific functions
Coating for each facility. The user enters the data based on
Systems 310
his/her experience and/or recommendations from
others.
Coating System
The user determines the number and name of each
Id 310.01 required coating system in advance of starting this sub
step. The system name should be descriptive of the
role the system will perform at the facility.
System A brief description of each system is entered to assist
Description
in identification.
310.02
Surface The various surface preparation methods that will be
Preparation
used, or can expected to be used at this facility are
Method 310.03
entered into the software. Each method is given a
unique description; the various attributes that are
researched and entered are: name of surface prepara-
tion method and the labor, material and equipment cost
per square foot to perform this method of surface
preparation.
Coating The various coating materials that will be used to build
Material Entry
the coating systems are entered. The materials are
310.04 selected based on recommendations of the coating
vendors, outside coating consultants, from the
experience of the coatings engineer at the facility or
from other sources. A unique material identification
number is given to each coating material entered. The
material identification number should be descriptive of
the material without being longer than 10 characters.
Other attributes of the coating material that are
researched and entered at this time are: manufacturer's
name, product name, generic type (alkyd, latex, epoxy
and polyurethane for example), percent solids by
volume, cost per gallon, recommended dry film
thickness range per coat of material and VOC's
(volatile organic compounds) in pounds per gallon.
Application
Various application methods are now entered into the
Method software. These methods can be based on the require-
310.05 ments of the coating materials previously entered, on
recommendations from outside sources or from the
experiences of the coating engineer at the facility. The
user is required to enter the application method name,
the estimated material transfer efficiency percentage
(the ratio of the amount of coating material that is
present at the start of the application method to the
amount of coating material that is deposited on the
substrate; expressed as a percentage), the labor and
equipment costs per square foot for this application
method.
Coating System
The coating system being built is identified as to its
Type 310.06
applicability to the facility's needs. All applications
that apply are selected from the following: touchup, re
coat, replace or new construction.
Coating System
The primary system purpose is selected from the
Purpose following: architectural, lining, protective coating,
310.07 sacrificial, decorative or other uses which may be user
defined.
Surface The required level of surface preparation for this
Preparation
system is chosen. Only one type of surface preparation
310.08 per coating system is allowed.
Material 1-
For the 1.sup.st material used, the design basis is chosen.
Design Basis
The design basis is simply the name given for a
310.09 specific coating material, such as Sherwin William's
Promar" 400 latex Eg-Shel Enamel, B20 W 400 Series
which is the "basis" of the design of this particular
system.
Number of Determine the number of coats of this material that
Coats 310.10
will be applied for this coating system and enter the
number in the software.
Application
Select the appropriate application method for this
Method 310.11
coating system from those previously entered.
See 310.05
Enter Cost Data
Enter Surface Preparation cost, coating material cost
320 (i.e. can of paint), and coating application cost (labor,
equipment to apply paint) into software. Surface
preparation cost includes Cost of material (i.e. sand for
sand blower), labor cost to install, and equipment cost
Calculate Cost
Calculate the cost per square foot applied and enter the
per Sq Ft 330
data into the computer.
______________________________________
Referring FIGS. 1A-1B, the Work Management Step 400 includes: Work Management Assessment By Sub Component 410, Accept or Alter Recommendations 420, Schedule Work By Sub Component 430, Calculate Costs 440, Data Operations 450, Management Reports 460, Report Historical Data 470 and Report Cost & Schedule Data 480. Table 4 gives a detailed description of each of the substeps 410-450 and reports 460-480. Step 400-Work Management
TABLE 4
______________________________________
Sub Step
Description
Implementation Process
______________________________________
Work Each sub component's condition and recommended
Management
work task is reviewed by either the administrator
Assessment By
or an engineering user.
Sub Component
410
Accept or Alter
Based on the expertise, experience and knowledge of
Recommend the facility's budgetary requirements, the administrator
420 or engineering user either accepts or alters the
inspector/surveyor's recommendations relating to each
sub component.
Schedule Work
Based on the expertise, experience and knowledge of
by Sub the facility's budgetary requirements and operational
Component requirements, the administrator or engineering user
430 schedules work on each of the sub components.
Calulate Costs
After the review and assessment process is complete,
440 the program automatically updates all calculated costs
(substep 320, 330) based on the recent inputted
information.
Data Operations
The administrator or engineering user performs
450 reporting, data analyzing and archiving operations
depending on the requirements of the facility. Data
operations include: management reports 460 and
prepare work packages 465, report historical data 470
analyze data 472 and project future trends 474, report
cost and schedule data 480, update projections 482 and
archive data 484
______________________________________
FIG. 2 illustrates a preferred computer equipment set-up 900 for using the novel four step implementation process 100, 200, 300 and 400 of FIGS. 1A-1B. A keyboard 910 can be used to input the facility breakdown data of step 100 and the condition survey data of step 200 onto a computer 930 such as but not limited to an IBM compatible 386SX processor, an IBM compatible 586, Macintosh Power PC and the like, with at least 4 megabytes minimum RAM, (8 recommended), a hard disk with 30 megabytes of available space with a color VGA monitor or high resolution monitor 920. The program running the computer 930 can be written in C++ Windows.TM., and the like. A preferred software algorithm flow chart for the computer program is described in reference to FIGS. 3A-3H. Computer 930 can perform calculations needed from steps 200, and the coating system standards 300. Final work management output step 400 can be displayed on conventional display screens 920 and output in hardcopy form at laser printer 400 such as but not limited a Hewlet Packard Printer 5M, 5ML, an ink jet or the like(dot matrix not recommended). FIG. 3A is a flow chart representation of Step 100 and part of step 200 of FIGS. 1A-1B. From start 10, defines and enters asset group data 110, defines and enters master component data 120, 140, defines and enters sub component data 130, 150. After which the program can prompt back whether any more asset groups are to be listed 190. If yes, box 110 is repeated, if no the program begins to conduct a condition survey by Sub component 210. Next the user selects the exposure type 210.01 from a menu which includes: atmospheric, ultraviolet, acidic, alkaline, immersion, splash zone, salt spray and high temperature. FIG. 3B is a flow chart representation of another portion of step 200 of FIGS. 1A-1B. The user next selects the operating environment 210.02 from the choices: mild, moderate or aggressive. The user then rates the substrate condition 210.03 from the choices: intact, superficial damage, structural damage and structurally failed. Next the existing coating integrity is rated 210.04 from the choices: excellent, good, fair and poor. The sub component visual view 210.05 is now selected such as hidden, visible and high profile. The user can then rate the visual appearance 210.06 from the choices: excellent, good, fair and poor. The adhesion of the current coating 210.07 can be measured using an ASTM D3359 X cut knife Adhesion Test where the user selects one of the choices: excellent, good, fair, and poor. FIG. 3C is a flow chart representation of another portion of step 200 of FIGS. 1A-1B. The user next selects the observed defects 210.08 from the choices: chalking, fading, mildew, dirt, blushing, discoloration, checking, alligatoring, delamination-intercoat, blistering-intercoat, pinholing, pinpoint rusting, general rusting, cracking, blistering to subsrate, flaking and peeling. The user inputs the measured dry film thickness value 210.09 measured by an Elcometer Model 211 Thickness Gauge. Next any observed hazardous conditions 210.10 such as lead or asbestos are input. The user next makes an inspection frequency recommendation 210.11 from the choices: monthly, semi annual, and annual. Next the surveyor/inspector can input comments 210.12 where the comments are regarding the sub component's condition such as exposure, etc. that are not part of the observed attributes. Next, a digitized photograph can be assigned 210.13 where the photograph can be scanned to produce a digital representation as part of the sub component record. FIG. 3D is a flow chart representation of another portion of step 200 and a portion of step 300 of FIGS. 1A-1B. The next input is where the user recommends the work task 220.10 from the choices: touchup, re-coat, replace, and new construction. Next, the application cost multipliers are recorded 220.20. These are specific problems that will increase the cost of maintenance such as barricades, scaffolding, rigging and confined space. The program prompts the user whether any more sub components are to be listed 290. If yes, substep 210 is repeated, if no, the coating systems step 300 begins where the program starts to develop coating systems 310. Next, a coating system ID is assigned 310.01 where a name or number is assigned that is descriptive of the systems used at this facility such as acrylic exterior touchup. Next a system description is entered 310.02 where a brief description is entered to assist in identification. For example: this is a single coat system based on Sherwin Williams.RTM. DTM(Direct-to-Metal) Acrylic coatings for use on steel, aluminum, galvanized and masonry. FIG. 3E is a flow chart representation of another portion of step 300 of FIGS. 1A-1B. The next step is for the user to select the surface preparation method 310.03 from hand tool cleaning, power tool cleaning, white metal blast cleaning, commercial blast cleaning, brush off blast cleaning, near white metal blast cleaning, and power tool cleaning to bare metal. Next the coating material information is entered 310.04. A unique material identification is entered such as name/number, manufacturers name, product name, generic type, percent solids by volume, cost per gallon, recommended dry film thickness range, and the volotile organic compounds. A prompt asks if another coating material exists 310.049. If yes substep 310.04 is repeated, if no then the user is asked to enter application method information 310.05. Here, a unique application method name is entered including the estimated material transfer efficiency percent, the estimated labor cost per square foot, and the estimated equipment cost per square foot. A prompt asks if there is another application method 310.059. If yes, then substep 310.05 is repeated, if no the next substep 310.07 occurs. FIG. 3F is a flow chart representation of the remaining portions of step 300 of FIGS. 1A-1B. The coating system purpose is entered 310.07 from choices such as architectural, lining, protective coating, sacrificial, and decorative. Next, the coating system type is entered 310.06 such as touchup, recoat, replace, and new construction. Next the material design basis is selected 310.08-310.09 from the choices: selected coating material (name/number) such as SW DTM acrylic primer/finish. Next the number of coats of material that are to be used such as one substep 310.10, as previously described in TABLE 3 shown above. Next, the desired application method is selected 310.11 for example: brush, roll and the like. The user is prompted whether there is another coating material 310.90. If yes then substep 310.08-310.09 is repeated, if no the cost data is entered 320 followed by the calculated cost per square foot 330. FIG. 3G is a flow chart representation of a portion of step 400 of FIGS. 1A-1B. The next step is for work management assessment by sub component 410. Next the user is asked whether to accept the work task recommendation 420. If no, the user is asked to select new work task recommendation 422 from: inspect, touchup, recoat and replace, and then passes to 424. If yes is the answer to box 420, then the program selects the coating system from those available 424. Next, the work status is selected 430 from the choices: forecast, planned, completed, and recommended. Next, the user is asked whether they accept the application cost multipliers 440 previously inputted. If no, then the user selects new application cost multipliers 442 from: barricades, scaffolding, rigging, and confined space, and then to box 444. If yes is the answer to box 440, then the estimated cost is reviewed 444. FIG. 3H is a flow chart representation of the remaining portion of step 400 of FIGS. 1A-1B. The next step is to enter the actual cost, if known 446. Comments of the user can be entered at substep 448. The user is prompted whether any more subcomponents are to be evaluated 449. If yes then substep 410 is repeated, if no then data operations 450 begins where management reports 460, historical data 470, cost and schedule data 480 can be output on screen or printed out, before the program ends at step 490. FIG. 4 illustrates an exemplary facility 600 having major components and subcomponents that can benefit from the subject invention. Referring to FIG. 4, a petroleum transportation facility includes major components such as a tank farm, control building, ship unloading dock and pumping yard. Each of the major components has subcomponents such as tank 1, tank 2 and the like. Tables 5 and 6 represents the data input for the FIG. 4 example of the asset group determination 110, and the master component 120, 140. Each of the defined asset groups, master components and sub components are entered into their respective forms. Tables 5 and 6 refer to the first step 100 of FIGS. 1A-1B.
TABLE 5
______________________________________
Attribute
Data Input Example
______________________________________
Asset Group
Each selected Asset Group is entered in the Asset Group
Determination
Creator with certain information-Example: Pumping
110 Yard, This asset group consists of the various tanks,
pumps and piping used to pump the oil from the tankers
to the Tank Farm. Created January 5, 1996
Master Each selected Master Component is entered in the Master
Component ID
Component Manager with certain information-Example:
120, 140 S. Pump Station, This master component consists of the
main pump, surge tank and transfer piping that pumps the
oil from the South Tanker Unloading Arm to the Tank
Farm.
______________________________________
Tables 7 and 8 represent step 200 of FIGS. 1A-1B using the FIG. 4 facility example. Each sub component is inspected and all sub component attributes and coating defects are noted in the appropriate locations on the Sub Component Evaluation Form.
TABLE 7
______________________________________
Attribute Data Input Example
______________________________________
Asset Group
None-select from those listed-Example Pumping Yard
210
Master None-select from those listed-Example N. Pump
Component ID
Station:
210
Sub Component
None-select from those listed-Example Transfer Pipe
ID 210
Date Inspected
Enter the date the sub component was inspected
210
Exposure Type
Select all that apply from those listed-Example:
210.01 weather, ultraviolet and salt spray
Operating Select from those listed-Example: mild
environment
210.02
Substrate Select from those listed-Example: superficial damage
condition
210.03
______________________________________
Table 9 represents step 300 of FIGS. 1A-1B using the FIG. 4 facility example. Coating systems are built for each asset groups use by entry of data into the Coating System Builder Form.
TABLE 9
______________________________________
Attribute
Data Input Example
______________________________________
Coating System
Enter a unique name/number combination to identify the
ID 310.01
coating system for easy recognition in future
use-Example: Acrylic Exterior Touchup
System Enter a brief description to assist in identifica-
Description
tion-Example: This is a single coat system based on
310.02 Sherwin William's DTM (Direct-To-Metal) Acrylic
coatings for use on steel, aluminum, galvanized and
masonry
Surface Enter the surface preparation method name, along with
Preparation
the labor, material and equipment cost per square foot to
Method 310.03
perform this particular method of surface prepara-
tion.-Example: SP2 Hand Tool Cleaning, $0.25, $0.05,
$0.05.
Coating Enter the coating material (s) unique name, along with
Material Entry
other attributes of that coating, such as manufacturer's
310.04 name, product name, generic type (alkyd, latex, epoxy
and polyurethane for example), percent solids by volume,
cost per gallon, recommended dry film thickness range
per coat of material and VOC's (volatile organic
compounds) in pounds per gallon-Example: SW DTM
Acrylic Primer/Finish, Sherwin-Williams, DTM Acrylic
Primer/Finish B66W1, acrylic, 46%, $23.75, 3.0 & 2.083
Application
Enter the application method (s) unique name, along with
Method other attributes of that method, such as transfer efficiency
310.05 percentage, labor and equipment costs per square foot for
each application method-Example: Brush, 90%, $0.35,
$0.05
Coating System
Enter the type (s) of uses that the coating system
Type 310.06
will have at this facility, enter all types that apply
to each system from those names in use at that
facility-Example: touchup, recoat, replace and new
construction
Coating System
Enter the primary system purpose from those names in
Purpose 310.07
use at this facility-Example: architectural
Surface Enter the required level of surface preparation for
Preparation
this system, only one method per coating system is
310.08 allowed-Example: SP2 Hand Tool Cleaning
Material 1-
Select from those listed, the name of the coating
Design Basis
material that is the basis of the design for this
310.09 particular coating system name-Example: SW DTM
Acrylic Primer/Finish
Number of
Determine the number of coats of this material that
Coats 310.10
will be included in this particular coating system
name-Example: 1
Application
Select from those application methods listed, the
Method 310.11
method to be used to apply the coat (s) chosen for
Material 1-Example: Brush
______________________________________
Table 10 represent step 400 of FIGS. 1A-1B using the FIG. 4 facility example. Each sub component's condition and recommended work task and coating system is reviewed and assessed by either the administrative or engineering user to verify that the recommendation conforms with the facility's asset maintenance plan.
TABLE 10
______________________________________
Attribute Data Input Example
______________________________________
Accept or Review each sub component's condition and work task
Change recommendation and either accept or change the work
Recommend task and coating system-Example: The sub component
410, 420 Transfer Pipe has a recommended work task of
touchup, using the coating system named Acrylic
Exterior. Based on the administrative or engineering
users knowledge and expertise, the recommendation is
changed from touchup to recoat, the coating system is
accepted.
Schedule Work
The schedule for the work task assigned to this sub
by Sub component is entered by the administrative or
Component engineering user-Example: The recoat of the Transfer
430 Pipe is scheduled for June 1996.
Calculate Costs
Based on the changed information input during the
440 Work Management Assessment Step, the computer
automatically updates the estimated cost to perform
the specified work task-Example: the cost data
associated with recoating the Transfer Pipe is now
used to calculate the estimated cost of this work.
Data Operations
The administrative or engineering user performs
450 various data manipulation operations to support the
strategic planning process-Example: an Executive
Summary report is printed which contains the Master
Component S. Pump Station, which in turn contains
the Sub Component Transfer Pipe. The Work Status of
this Sub Component is shown as recoat, the schedule
date is June 1996 and the estimated cost is $1,087.
______________________________________
FIG. 5 illustrates an exemplary executive summary-work managment output of Step 400. Although, the data operations substep 450 of FIG. 1B describes various types of outputs, the invention is not limited to these outputs. The invention can be used generate various types of reports such as but not limited to: Master Asset Lists, Master Asset Condition Summary, Work Management Report, Master Asset Planned Work & Summary, Master Asset or Subcomponent Priority Lists, Maintenance Activity by Master Asset List, Asset and Subcomponent Cost Data List, Maintenance Cost Data & Annual Summary List, Maintenance History List, Defect &Defect Cost Analysis List, Coating Use and Performance List, Maintenance & Safety Flags List, Condition Survey History List, and User Defined Lists. While the invention has been described, disclosed, illustrated and shown in various terms of certain embodiments or modifications which it has presumed in practice, the scope of the invention is not intended to be, nor should it be deemed to be, limited thereby and such other modifications or embodiments as may be suggested by the teachings herein are particularly reserved especially as they fall within the breadth and scope of the claims here appended.
|
Same subclass Same class Consider this |
||||||||||
