AU2009240774B2

AU2009240774B2 - Materials management system and method

Info

Publication number: AU2009240774B2
Application number: AU2009240774A
Authority: AU
Inventors: Kashif Saleem
Original assignee: Trackem Ip Pty Ltd
Current assignee: Trackem Ip Pty Ltd
Priority date: 2008-04-21
Filing date: 2009-04-21
Publication date: 2012-03-01
Anticipated expiration: 2029-04-21
Also published as: AU2009240774A1; WO2009129563A1; US20110037764A1; US8830239B2

Abstract

A materials management system (10) comprises a materials database (12) for storing information relating to the nature, identity and location of each item of material on a site. A mobile data processing device (14) is provided, having a data scanner (16) for scanning machine-readable identification information provided in an identification tag attached to an item of material. A GPS receiver (18) is operatively connected to the mobile data processing device (12) for obtaining the GPS coordinates of the item of material. The mobile data processing device (14) transmits the GPS coordinates and the identification information to the materials database (12) so that the location of each item of material on site can be tracked. The materials database (12) can be accessed online from anywhere in the world via satellite link (20) (or internet) using any suitable desktop personal computer (22). The materials management system has particular application to a construction site, and sites where intrinsically safe systems are required.

Description

WO 2009/129563 PCT/AU2009/000491 "MATERIALS MANAGEMENT SYSTEM AND METHOD" Field of the Invention 5 The present invention relates to a system and method of materials management on a site and relates particularly, though not exclusively to such a system and method for managing materials for a construction site (onsite and offsite). Background to the Invention 10 In large building projects a failure to keep track of construction materials is a major contributor to cost-overruns and construction delays. Construction materials may be delivered on time to the site, but when the time comes to install the materials it can sometimes be difficult to locate the materials in the lay-down yard. The time taken trying to locate the materials consumes 15 precious labour time, and in a worse case scenario a failure to locate the materials requiring re-ordering and delivery adds further unnecessary costs and delays to completion of the project. Therefore it is desirable to have a system and method of managing all phases of the material handling process, from procurement, expedition and transport through to onsite arrival, storage 20 and installation. The present invention was developed with a view to providing a system and method of materials management which facilitates tracking the location of each item of material offsite and on site from the time of arrival to installation. Although the invention will be described with particular reference to 25 construction sites, it will be appreciated that the invention has wider application to tracking the location of items of material on other sites. References to prior art in this specification are provided for illustrative purposes only and are not to be taken as an admission that such prior art is part of the common general knowledge in Australia or elsewhere.

-2 Summary of the Invention According to one aspect of the present invention there is provided a materials management system for a site, the system comprising: a materials database for storing information relating to the nature, identity and 5 location of each item of material on a site; a software module for colour-coding each item on the site in a 3D model of the site, the software module monitoring the database and, as a status of an item changes in the database, changing the colour of the item in the 3D model to give an immediate visual indication of the current status of the item; 10 and, a mobile data processing device having a data scanner for scanning machine-readable information, including identification information, provided in an identification tag attached to an item of material, and a GPS receiver operatively connected to the mobile data processing device for obtaining the 15 GPS coordinates of the item, the mobile data processing device transmitting the GPS coordinates and the identification information to the materials database whereby, in use, the status of each item of material on site can be tracked. In one embodiment the mobile data processing device is a handheld device. 20 Preferably the mobile data processing device is a handheld personal digital assistant (PDA). Advantageously the data scanner provided in connection with the mobile data processing device is a barcode scanner. Alternatively the data scanner provided in connection with the mobile data processing device is an RFID tag scanner. 25 In one embodiment the mobile data processing device is an intrinsically safe handheld device. Preferably the mobile data processing device is a handheld personal digital assistant (PDA). Advantageously the data scanner provided in connection with the mobile data processing device is an intrinsically safe barcode scanner. Alternatively the data scanner provided in connection with 30 the mobile data processing device is an intrinsically safe RFID tag scanner. Amended Sheet

IPEA/AU

-3 In one embodiment the GPS receiver is operatively connected to the mobile data processing device by means of a wireless communications link. In an alternative embodiment the GPS receiver is integrated and hardwired into the mobile data processing device. 5 Advantageously the data scanner provided in connection with the mobile data processing device is capable of- scanning additional machine-readable information provided in the identification tag attached to an item of material, such additional machine-readable information relating to the ongoing maintenance of the item.. 10 Preferably the system further comprises one or more sensing devices provided in connection with the item of material for sensing a condition of the item, the sensing device being electronically coupled to the identification tag, wherein information relating to the condition of the item can be stored in the identification tag for maintenance purposes. In one embodiment the 15 identification tag is an RFID tag. Preferably the system further comprises a document control database in which identification information for any documents associated with an item recorded in the materials database is stored. Advantageously the system further comprises a progress control database in 20 which the progress of each item in the materials database is controlled according to applicable "Rules of Credit." Typically electronic tick sheets which. are linked to the materials database may be used in this regard. According to another aspect of the present invention there is provided a method of managing materials on a site, the method comprising the steps of: 25 applying an identification tag to each item of material on a site, the tag containing machine-readable information, including identification information identifying the item of material; providing a materials database for storing information relating to the nature, identity and location of each item of material on a site; Amended Sheet

IPEA/AU

-4 scanning an identification tag attached to an item of material on site to read the machine-readable information; obtaining the current GPS coordinates of the item; transmitting the current GPS coordinates and the identification information to 5 the materials database; updating the status of the item in the database based on the current GPS coordinates and identification information; providing a 3D model of the site; and, changing the colour of the item shown in the 3D model based on the current 10 status of the item according to the update information in the materials database whereby, in use, the status of each item of material on site can be tracked. Preferably the method comprises the further steps of: storing additional machine-readable information in the identification tag, 15 including information relating to the ongoing maintenance of the item in the identification tag; transmitting the additional information to the materials database; and, updating a maintenance log for the item in the database whereby, in use, the ongoing maintenance of each item of material on site can be tracked. 20 Advantageously the additional information stored in the identification tag also includes information relating to the progress of the item in the various stages of construction. Preferably the information relating to the progress of the item is transmitted to and recorded in a progress control database, in which the progress of each item in the materials database is controlled according to 25 applicable "Rules of Credit." According to a still further aspect of the present invention there is provided a method of updating a materials database for a materials management system, the method comprising the steps of: Amended Sheet

IPEA/AU

-5 retrieving a material item record stored in the materials database upon receiving identification information scanned from an identification tag attached to an item of material; generating and displaying an update screen for the material item record 5 wherein, in use, an operator can input update information for the material item record, including the current GPS coordinates of the item of material; updating the material item record in the materials database with the update information; providing a 3D model of 'a site where the item of material is to be installed; 10 and, changing the colour of the item shown in the 3D model based on the current status of the item according to the update information in the updated material item record of the materials database. Preferably the method of updating a materials database further comprises, in 15 the case where a material item entry cannot be retrieved from the materials database based on the scanned identification information, the steps of: generating and displaying a search screen wherein, is use, an operator can specify a Mark No for the material item; searching the materials database for all items having the specified Mark 20 No; displaying the search list for all items with the specified Mark No wherein, in use, an operator can select an item from the search list; and, retrieving a material item record stored in the materials database corresponding to the item selected by the operator. 25 Preferably the method of updating a materials database further comprises, in the case where no items having the specified Mark No can be retrieved from the materials database or where none of the items with the specified Mark No corresponds to the material item, the steps of: Amended Sheet

IPEA/AU

-6 generating and displaying a screen that enables the operator to create a new record in the materials database for the specified Mark No or material item; and, storing the.new record in the materials database. 5 Advantageously the method of updating a materials database further comprises the steps of providing an associated progress control database; creating suitable "Rules of Credit" for controlling the progress of an item of material in the progress control database; 10 assigning a "Rule of Credit" to each item in the materials database; and progressing each item in the progress control database according to the applicable "Rule of Credit." According to a further aspect of the present invention there is provided a materials management system for a construction site, the system comprising: 15 a materials database for storing information relating to the-nature, identity and location of each item of material on the construction site; a software module for colour-coding each item on the site in a 3D model of the construction site, the software module monitoring the database and, as a status of an item changes in the database, changing the colour of the item in 20 the 3D model to give an immediate visual indication of the current status of the item; and, a mobile data processing device having a data scanner for scanning machine-readable information, including identification information, provided in an identification tag attached to an item of material, and a GPS receiver 25 operatively connected to the mobile data processing device for obtaining the GPS coordinates of the item, the mobile data processing device transmitting the GPS coordinates and the identification information to the materials database whereby, in use, the status of each item of material on, the construction site can be tracked. Amended Sheet

IPEA/AU

-7 In one embodiment the mobile data processing device is a handheld device. Preferably the mobile data processing device is a handheld personal digital assistant (PDA). Advantageously the data scanner provided in connection with the mobile data processing device is a barcode scanner. Alternatively the 5 data scanner provided in connection with the mobile data processing device is an RFID tag scanner. 10 Throughout the specification, unless-the context requires otherwise, the word "comprise" or variations such as "comprises" or "comprising", will be understood to imply the inclusion of a stated integer or group of integers but not the exclusion of any other integer or group of integers. Likewise the word "preferably" or variations such as "preferred", will be understood to imply that 15 a stated integer or group of integers is desirable but not essential to the working of the invention. Brief Description of the Drawings The nature of the invention will be better understood from the following detailed description of several specific embodiments of system and method of 20 materials management, given by way of example only, with reference to the accompanying drawings, in which: Figure 1 illustrates a preferred embodiment of a system for managing materials on a site; Figure 2 is a flow chart illustrating a preferred embodiment of a method 25 of managing materials on site employing the system of Figure 1; Figure 3 is a flow chart illustrating a preferred embodiment of the process of updating information in a materials database provided in the system of Figure 1; Amended Sheet

IPEA/AU

WO 2009/129563 PCT/AU2009/000491 -8 Figure 4(a), (b), (c), (d) and (e) are screen shots of a various screens typically displayed on a preferred embodiment of a mobile data processing device employed in the system of Figure 1; 5 Figure 5 (a) is a flow chart illustrating a preferred method of updating a materials database using 3D Software; Figure 5 (b) is an example of a 3D model of a construction site showing various items colour-coded according to their current status in the materials database provided in the system of Figure 1; 10 Figure 6 illustrates schematically a preferred embodiment of a document control database associated with the system of Figure 1; Figure 7 is a flow chart illustrating the process of updating a progress control database associated with the system of Figure 1; Figure 8 is a screen shot of a preferred embodiment of a progress 15 control screen employed in connection with the progress control database of Figure 7; Figure 9 is a flow chart illustrating a process flow (batch mode) showing how a user can update the information on various devices and can then upload the information using a docking system; and 20 Figure 10 is a flow chart illustrating a process flow (safe mode). Detailed Description of Preferred Embodiments A preferred embodiment of materials management system 10 in accordance with the invention, as illustrated in Figure 1, comprises a materials database 25 12 for storing information relating to the nature, identity and location of each item of material on a site. The database 12 is preferably an SQL Server database system hosted on a web server operating with a Microsoft Windows operating system platform using the .NET Framework. SQL Server is a relational database management system (RDBMS) produced by Microsoft WO 2009/129563 PCT/AU2009/000491 -9 (Registered Trade Mark). Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL). SQL Server allows multiple clients to use the same database concurrently. As 5 such, it is able to control concurrent access to shared data; it will ensure data integrity when multiple clients update the same data, or clients attempt to read data that is in the process of being changed by another client. The system preferably further comprises a mobile data processing device 14 having a data scanner 16 for scanning machine-readable identification 10 information provided in an identification tag attached to an item of material. In this embodiment the identification tag is a machine-readable barcode printed on a label which is attached to the item of material. However any other suitable identification tag, with machine-readable identification information, may be employed, for example, a Radio Frequency Identification (RFID) tag. 15 In the illustrated embodiment the mobile data processing device 14 is a Symbol MC9090-S handheld mobile computer (PDA) manufactured by Motorola. The Symbol MC9090-S PDA uses the Microsoft Windows Mobile operating system and incorporates omnidirectional 1D and 2D image scanning data capture technology 16 suitable for reading barcode labels. The 20 MC9090-S PDA 14 is configured as a client of the SQL Server database system 12 and communicates with the database 12 using web services provided via mobile telephone coverage. A GPS receiver 18 is operatively connected to the mobile data processing device 12 for obtaining the GPS coordinates of the item of material. In this 25 embodiment the GPS receiver is a Bluetooth GPS receiver manufactured by Linkspoint which can be connected to any Bluetooth-enabled mobile device and is capable of providing the global positioning coordinates of a specific location with an accuracy of within 3-5 meters. The Linkspoint Bluetooth GPS receiver supports the Windows Mobile operating system and can be 30 operatively connected to the MC9090-S 14 using a Bluetooth wireless link. In an alternative embodiment (not illustrated) the GPS receiver chip set is integrated into the mobile data processing device 14 and is operatively connected thereto by hardwiring.

WO 2009/129563 PCT/AU2009/000491 - 10 Being a web-based system, the materials database 12 can be accessed online from anywhere in the world via satellite link 20 (or internet) using any suitable desktop personal computer 22 or laptop personal computer (not 5 shown). The personal computer is typically connected to the web using a broadband connection via a router 24 and enables the user to access various reporting functions provided with the materials database software to analyse, manage and document construction progress. A preferred method of managing materials on a construction site will now be 10 described with reference to Figure 2. When an item of construction material, for example, a steel beam, first arrives on site, a barcode label is applied to the item, indicated as step 100. The materials may already have been entered into the materials database, for example, at the time of procurement, and each type of material given a unique Mark No. If there is more than item 15 of the same type of material, each item receives a unique barcode, even though they may all have the same Mark No. The bar-coded items are then scanned using the PDA 14, indicated as step 102. The PDA 14 then communicates with the materials database 12 and checks if this bar-coded item already appears in the database 12. This query is 20 indicated in Figure 2 as step 104. If the item does not appear in the database a new entry can be made in the database 12 via the PDA 14, indicated as step 106. If the item is found in the database 12, the PDA 14 then obtains the GPS coordinates from the associated GPS receiver 18, indicated as step 108. When the longitudinal and latitudinal GPS coordinates are obtained, this 25 information is then transmitted to the materials database 12, indicated as step 110, and the materials database 12 is updated with the new coordinates, indicated as step 112. Other information relating to the item may be updated in the database 12 via the PDA 14, for example, if the item has been installed the date of installation. 30 A preferred method of updating an item or creating a new item in the database 12 using the PDA 12 will now be described in more detail with reference to Figures 3 and 4. The user scans the barcode on an item using WO 2009/129563 PCT/AU2009/000491 - 11 the data scanner 16 provided in connection with the PDA 14, indicated as step 114 in Figure 3. If for some reason the barcode label will not scan, the user can also enter the barcode No. manually via the PDA keypad. This query 5 is indicated as step 116 in Figure 3. If the barcode is found and it's a good read then the PDA displays the Update Item Screen, indicated as step 124. If the barcode is not found (bad read) then the PDA 14 displays the Search Screen, indicated as step 118 in Figure 3. A sample screen shot of the Search Screen is shown in Figure 4(a). When the "Search" button is pressed, 10 the PDA 14 sends a query to the database 12 to find the matching Mark Nos. This query is indicated as step 119 Figure 3. If no matching Mark Nos are found, the system displays the Create New Equipment/Mark No Screen, indicated as step 126 in Figure 3. If any matching Mark Nos are found, the PDA then displays the search list for the matching Mark Nos on the PDA 14, 15 indicated as step 120 in Figure 3. A screen shot of a typical search list in a "Select Mark No Screen" from which a user can select the desired Mark No is shown in Figure 4(b). The user looks for the desired Equipment/Mark No on the screen and selects the desired Mark No (e.g. by clicking on the Mark No on the screen). The 20 system then queries the database 12 for all the items relating to that Mark No, indicated as step 121 in Figure 3. If no items are found, the system displays the Create New Equipment/Mark No Screen, indicated as step 126 in Figure 3. If any items relating to that Mark No are found, the list of items is displayed on the PDA 14, indicated as step 122 in Figure 3. A screen shot of a typical 25 search list in a "Select Item Screen" from which a user can select the desired item is shown in Figure 4(c). When the user selects the desired item from the list, the system then displays the Update Item Screen, indicated as step 124 in Figure 3. A screen shot of a typical Update Item Screen is shown in Figure 4(d). The following items will 30 populate according to the information in the database for that item: 1. Mark No 2. Short Description of item 3. Barcode No WO 2009/129563 PCT/AU2009/000491 - 12 4. Status 5. Wt (KG) 6. Received Date 5 7. Issue Date 8. Install Date 9. GRL/Location 10. GPS Longitudinal coordinate 11. GPS Latitudinal coordinate 10 The following fields are read only: Mark No, Short Desc, Status, and Wt (KG) The following fields are read and write: Barcode, Received Date, Issue Date, Install Date, GRL/Location, GPS Long, GPS Lat. The user can then update the required fields via the PDA 14 and the updated 15 information is then transmitted to the materials database 12. For example the No printed on the barcode label can be entered into the Barcode field. When the "Save" button is clicked the item is automatically undated in the database 12. In this way the location, status and physical attributes of each item of construction material on the site can be updated. 20 In order to create a new entry in the database 12 for a new item of Equipment/Mark No, the Create New Equipment/Mark No Screen is displayed, indicated as step 126 in Figure 3. A screen shot of a typical Create New Equipment/Mark No Screen is shown in Figure 4(e). This screen displays the Equipment Fields from an Equipment table provided in the 25 database 12. The user enters the following fields to create new items 1. Mark No 2. Short Desc 3. Category (Drop Down) 4. Wt (Kg) 30 5. Qty (integer) The functionality of the buttons provided on the PDA screen is as follows: Create Button: when the Create button is pressed 35 1) the system should add the Mark No Details in the Equipment table and 2) the number of items should be created for that Mark No in the item table according to the Qty. a. E.g. if user enters Qty = 10 for mark no SB200-01-1001-NP it should create 10 items associated to Mark No SB200-01 -1001 40 NP Mark Nos are unique so no duplicates should be created.

WO 2009/129563 PCT/AU2009/000491 - 13 Search Button: When the search button is pressed 1) the system should display "Select Item Screen" (see Figure 4(c)) for 5 that Mark No. Using the preferred method and system 10 of materials management described above the location, status and physical attributes of each item of construction material on the site can be updated and tracked at any point 10 during its construction lifecycle. For example, when queried on a hypothetical material xxO1 the system confirms that the item has been ordered, provides a docket number, the date of arrival on site and its precise weight. A user entering the Mark No xxO1 into the system will see that the material in question has arrived and is located in the lay-down yard at the coordinates 15 34.45 N and 34.31 E. A query on Mark No xx03 will reveal that the material has been installed and 90% completed, and so on. The system is designed to handle large volumes of data and supports many simultaneous users whilst maintaining a fast response and high degree of accuracy. The system provides a variety of custom options that can be 20 tailored to the intended end-user application, and it is also very easy to set up and use. It requires minimal IT support, since the PDA software is run from one small file which can be emailed to the client for immediate use. A minimum amount of training is required before a user is up and running. In the case where barcode labels are used for storing machine-readable 25 identification information the tracking of the material item typically ends when the item has been installed and construction is finished. However in the case where the machine-readable identification information is stored in an active device such as, for example, a Radio Frequency Identification (RFID) tag, the possibility exists of extending the tracking of the item for maintenance 30 purposes. The materials management system 10 can then be employed for monitoring the ongoing maintenance of equipment or plant on a construction or mine site. This may be particularly advantageous where various types of sensing device may be electronically coupled to the RFID tag. For example, the RFID tag may be electronically coupled to a temperature 35 sensing device, a corrosion detecting device, a pressure sensor or a strain WO 2009/129563 PCT/AU2009/000491 -14 gauge. Sensing information from the sensing device may be stored in the RFID tag to be collected during periodic maintenance surveys of the installation or equipment. The RFID tag may also store the date when the last 5 maintenance check was done and when the next maintenance check is due. A temperature sensor may, for example, be used to monitor the temperature of a pipe carrying process fluids. Alternatively, or in addition, a strain gauge may monitor the stresses applied to a beam or a welded joint on the beam. This kind of information is valuable for the ongoing safety and maintenance of 10 the installation, and by logging this information electronically in the RFID tag it can be periodically accessed by maintenance workers using a handheld PDA 14. The logged data is then uploaded to the corresponding record for that material item in the materials database 12, from where it can be analysed and appropriate maintenance action taken if necessary. 15 Advantageously a plug-in software module has been designed for the materials management system that enables it to be integrated with NavisWorks 3D modelling software developed by Autodesk. Each item on the construction site is colour-coded in a 3D model of the construction site. As the status of the item changes in the database with each update, so the colour of 20 the item in the 3D model also changes to give an immediate visual indication of the current status of the item. The numbers of statuses and names of these statuses can be changed according to the particular needs of the user. Figure 5(a) is a flow chart illustrating the function of the database plug-in which operates with the 3D modelling software to provide a visual indication 25 of the current status of each item of material on the construction site. At 200 the 3D modelling software loads the database plug-in which then provides an operational link with the materials database 12. Each item in the 3D model of the construction site 70 is given a unique id code (corresponding to the item id or barcode applied to the item of material on the construction site). At step 30 201 the plug-in compares the unique id of each item in the 3D model with the item id or barcode in the materials database 12, and when a match is found it updates the colour of the item in the 3D model at step 202 according to the current status of the item in the database.

WO 2009/129563 PCT/AU2009/000491 -15 At step 203 a user can also manually update the colour of an item in the 3D model. In that case the plug-in updates the database at 204 based on the changes made to the 3D model. Typically, an item in the 3D model coloured 5 yellow has been received on the building site, but not yet issued for construction. Once it has been issued for construction (as updated in the database) the colour is changed to green. If an item has not yet been installed (according to the database) it is coloured red; however once it has been installed it is coloured blue. Hence by looking at the 3D model it is possible to 10 see immediately the current status of each item on the construction site. Figure 5 (b) shows an example of a drawing of a 3D model 70 of a construction site in which various items are colour-coded according to the their current status in the materials database. When an item, for example a window frame 72 with Mark No: SP-1234, is due on site it may be shown 15 coloured red in the 3D model. Hence anyone viewing the 3D model can immediately see that all the items coloured red in the model are due on site but have not yet arrived. When an item arrives the materials database 12 is updated in the manner described above. Fields updated in the database 12 typically include the Received Date, Received By, Docket No, Location, and 20 GPS coordinates. If a date is entered in the Received Date field, then the colour of the item in the 3D model is automatically changed to yellow. When the item is issued on site, the following fields are typically updated: Issue Date, Issued By, Location, and GPS coordinates. If a date is entered in the Issue Date field, then the colour of the item in the 3D model is 25 automatically changed to green. This immediately provides a visual indication to a viewer of the 3D model that the window frame 72 with Mark No SP-1234 has arrived and been issued on site. When the window frame 72 is installed the following fields typically are updated in the database 12: Install Date, Installed By, Location, and GPS coordinates. Once again, if a date is entered 30 into the Install Date field, then the colour of the window frame 72 in the 3D model is automatically changed to blue.

WO 2009/129563 PCT/AU2009/000491 - 16 Advantageously the materials management system 10 also includes a document control database 76 which is integrated with the materials database 12. A typical process of associating a document that relates to an item 5 recorded in the materials database 12 is illustrated schematically in Figure 6. When a transmittal 78 is received from a client, an outside contractor, other staff or a user, it may have attachments, including drawings, emails, CDs, and/or other documents which relate to an item recorded in the database 12. Each document is given a barcode or RFID tag which is scanned with the 10 handheld PDA 14 and recorded in the document control database 76 on the server. If an RFID tag is used, identification information relating to the document is stored on the RFID tag as well. A screen is generated by the software for display on the PDA 14 or an a desktop PC 22 connected to the system 10 (see Figure 1), in which 15 identification information relating to the document appears and in which the document can be associated by the user with the corresponding item in the materials database 12 by its Mark No and Item No. In this way documents which relate to a piece of equipment or an item in the materials database 12 can remain associated with that item throughout its life cycle. 20 Advantageously the materials management system may also incorporate a progress control database 80 for monitoring the progress of construction on a construction site. Figure 7 is a flow chart illustrating the process of updating a progress control database 80, which is linked to the materials database 14 of Figure 1. "Rules of Credit" are created and entered at 128 into the system 10. 25 A "Rule of Credit" is the rule an item or piece of equipment received on site must follow in order to progress during the construction phase. Each item recorded in the database 14 is assigned a "Rule of Credit". Each item received on site is then progressed according to the applicable "Rule of Credit." Progress of each item or piece of equipment is recorded and can be 30 monitored using a special grid, unlike Excel, thus avoiding data entry, etc. Typically electronic tick sheets which are linked to the materials database may be used to assist in this regard.

WO 2009/129563 PCT/AU2009/000491 - 17 A user employs the progress control database (PCDB) 80 to update the materials database 12 as follows. At 130 the item is located in the PCDB and when found its progress is updated by the user selecting the appropriate tick 5 box/check box or other method of data input at 132. The system then calculates the progress according to the applicable "Rule of Credit" at 134, and the materials database 12 is updated accordingly at 136. Figure 8 is a screen shot of a preferred embodiment of the Progress Control Screen for the progress control database 80. The barcode or RFID tag on 10 each item is used to monitor the progress and to update the database as described above. In the case of RFID tags, information concerning the progress of the item can also be stored on the tag. As can be seen in Figure 8, the Progress Control Screen includes a number of columns relating to each stage in the construction phase of an item or piece of equipment according to 15 its "Rule of Credit". In this case, a number of C3 Columns are listed by item Nos in the far left column. The first item has progressed all the way to completion (100%), through the Preassembly/Installed, Secured/Final Alignment, Grouting (if applicable) and Punchlist Complete stages. The second item in the screen shot is 85% completed; only the final stage 20 (Punchlist Complete) has not been completed. The Progress Control Database 80 thus enables the project manager to see at a glance at what stage of construction each item in the materials database 12 is at. Also the Progress Control Database 80 provides a reference for the construction managers to control the progress of construction, since an item 25 cannot be progressed in the database unless it is progressed according to the applicable "Rule of Credit." The Progress Control Database 80 thus adds a further useful tool to the materials management system 10 for managing the movement, installation and commissioning of all material items on a site during all phases of construction. 30 The materials management system of the invention has particular application to a construction site since it is relatively easy to use and can readily be operated from a remote location. In view of the large area covered by some WO 2009/129563 PCT/AU2009/000491 - 18 construction sites such as mine sites the management system of the invention is particularly useful in such applications. For example in Figure 7, the user creates the following rules of credit 5 (Preassembly = 30%; Secured 45%; Grouting 10%; Punch list complete 15%). The user then searches for a column tag no/mark no DST-07305200-2. PCDB then displays all the items/barcodes associated to DST-07305200-2 (Figure 8). User then selects the appropriate tick box for example in item no 120608111633 all the tick boxes for preassembly = 30%, secured 45%, 10 grouting 10%, punch list complete 15% are selected 132. PCDB then calculates the progress and in this instance it is 100% 134. Once confirmed by the user the system then updates the database 136. The materials management system of the invention can work in a batch mode when there is no wireless connection or network available. This is ideal for 15 remote sites where there is no IT or communication infrastructure is available. The user can update the information on mobile computers/PDA/handheld devices and then can upload the information using a docking system (see Figure 9). The materials management system of the invention can work on sites where intrinsically safe environment is required (eg Oil and Gas fields). 20 In this case intrinsically safe PDAs or mobile devices will be used in the fields and the system will run in a batch mode (see Figure 10). The materials management system of the invention will also work if there is no identification tag on an item. This is because the system can interrogate or query the database using the Mark no or Tag no which is stamped on the 25 item. This is ideal for sites where the items or equipments are coming from area (eg overseas) where it is not feasible to attach a tag to an item. Now that a preferred embodiment of the system and method of materials management have been described in detail, it will be apparent that the embodiment provides a number of advantages over the prior art, including the 30 following: WO 2009/129563 PCT/AU2009/000491 -19 (i) It helps to avoid costly down-times by providing up-to-date tracking and management of all items of construction material on a site. (ii) It is easy to use and the handheld PDA facilitates rapid, real time 5 updating of information in the database. (iii) It is readily scalable to suit any sized project and is fully compatible with other commonly used in-house software systems. (iv) It provides increased productivity onsite due to up-to-date information on material delivery, movement and inventory. 10 (v) It enables increased productivity for procurement staff and material controllers by minimising the risk of mistakes and reducing the requirements for double entry of data. (vi) It provides useful plug-in tools to facilitate visual representation of progress on site using 3D modelling software and a Progress 15 Control Database It will be readily apparent to persons skilled in the relevant arts that various modifications and improvements may be made to the foregoing embodiments, in addition to those already described, without departing from the basic inventive concepts of the present invention. For example, instead of the 20 MC9090-S PDA a GPS-enabled Blackberry, iPhone or any Windows mobile base device such as Imate JasJam, could be used as the mobile data processing device. Therefore, it will be appreciated that the scope of the invention is not limited to the specific embodiments described and is to be determined from the appended claims.

Claims

1. A materials management system for a site, the system comprising: a materials database for storing information relating to the nature, identity and 5 location of each item of material on a site; a software module for colour-coding each item on the site in a 3D model of the site, the software module monitoring the database and, as a status of an item changes in the database, changing the colour of the item in the 3D model to give an immediate visual indication of the current status of the item; 10 and, a mobile data processing device having a data scanner for scanning machine-readable information, including identification information, provided in an identification tag attached to an item- of material, and a GPS receiver operatively connected to the mobile data processing device for obtaining the 15 GPS coordinates of the item, the mobile data processing device transmitting the GPS coordinates and the identification information to the materials database whereby, in use, the status of each, item of material on site can be tracked.

2. A materials management system for a site as defined in claim 1, wherein 20 the mobile data processing device is a handheld device.

3. A materials management system for a site as defined in claim 1, wherein the mobile data processing device is a handheld personal digital assistant (PDA).

4. A materials management system for a site as defined in any one of claims 25 1 to 3, wherein the mobile data processing device communicates with the materials database via mobile telephone coverage.

5. A materials management system for a site as defined in any one of claims 1 to 4, wherein the data scanner provided in connection with the mobile data processing device is a barcode scanner. Amended Sheet IPEA/AU -21

6. A materials management system for a site as defined in any one of claims 1 to 4, wherein the data scanner provided in connection with the mobile data processing device is an RFID tag scanner.

7. A materials management system for a site as defined in any one of claims 5 1 to 6, wherein the GPS receiver is operatively connected to the mobile data processing device by means of a wireless communications link.

8. A materials management system for a site as defined in any one of claims 1 to 6, wherein the GPS receiver is integrated and hardwired into the mobile data processing device. 10

9. A materials management system for a site as defined in any one of claims 1 to 8, wherein the data scanner provided in connection with the mobile data processing device is capable of scanning additional machine-readable information provided in the identification tag attached to an item of material, such additional machine-readable information relating to the ongoing 15 maintenance of the item.

10. A materials management system for a site as defined in any one of claims 1 to 9, wherein the system further comprises one or more sensing devices provided in connection with the item of material for sensing a condition of the item, the sensing device being electronically coupled to the identification-tag, 20 wherein information relating to the condition of the item can be stored in the identification tag for maintenance purposes.

11. A materials management system for a site as defined in any one of claims 1 to 10, wherein the identification tag is an RFID tag.

12. A materials management system for a site as defined in any one of claims 25 1 to 11, wherein the system further comprises a document control database in which identification information for any documents associated with an item recorded in the materials database is stored.

13. A materials management system for a site as defined in any one of claims 1 to 12, wherein the system further comprises a progress control database in Amended Shet IPEA/AU -22 which the progress of each item in the materials database is controlled according to applicable "Rules of Credit."

14. A materials management system for a site as defined in claim 13, wherein electronic tick sheets linked to the materials database. 5

15. A method of managing materials on a site, the method comprising the steps of: applying an identification tag to each item of material on a site, the tag containing machine-readable information, including identification information identifying the item of material; 10 providing a materials database for storing information relating to the nature, identity and location of each item of material on a site; scanning an identification tag attached to an item of material on site to read the machine-readable information; obtaining the current GPS coordinates of the item; 15 transmitting the current GPS coordinates and the identification information to the materials database; updating the status of the item in the database based on the current GPS coordinates and identification information; providing a 3D model of the site; and, 20 changing the colour of the item shown in the 3D model based on the current status of the item according to the update information in the materials database whereby, in use, the status of each item of material on site can be tracked.

16. A method of managing materials on a site as defined in claim 15, wherein 25 the method comprises the further steps of: storing additional machine-readable information in the identification tag, including information relating to the ongoing maintenance of the item in the identification tag; Amended Sheet IPEA/AU -23 transmitting the additional information to the materials database; and, updating a maintenance log for the item in the database whereby, in use, the ongoing maintenance of each item of material on site can be tracked.

17. A method of managing materials on a site as defined in claim 16, wherein 5 the additional information stored in the identification tag also includes information relating to the progress of the item in the various -stages of construction.

18. A method of managing materials on a site as defined in claim 17, wherein the information relating to the progress of the item is transmitted to and 10 recorded in a progress control database, in which the progress of each item in the materials database is controlled according to applicable "Rules of Credit."

19. A method of updating a materials database for a materials management system, the method comprising the steps of: retrieving a material item record stored in the materials database upon 15 receiving identification information scanned from an identification tag attached to an item of material; generating and displaying an update screen for the material item record wherein, in use, an operator can input update information for the material item record, including the current GPS coordinates of the item of material; 20 updating the material item record in the materials database with the update information; providing a 3D model of a site where the item of material is to be installed; and, changing the colour of the item shown in the 3D model based on the current -25 status of the item according-to the update.information in the updated material item record of the materials database.

20. A method of updating a materials database as defined in claim 19, wherein the method of updating a materials database further comprises, in Amended Sheet IPEA/AU -24 the case where a material item entry cannot be retrieved from the materials database based on the scanned identification information, the steps of: generating and displaying a search screen wherein, is use, an operator can specify a Mark No for the material item; 5 searching the materials database for all items having the specified Mark No; displaying the search list for all items with the specified Mark No wherein, in use, an operator can select an item from the search list; and, retrieving a material item record stored in the materials database 10 corresponding to the item selected by the operator.

21. A method of updating a materials database as defined in claim 20, wherein the method of updating a materials database further comprises, in the case where no items having the specified Mark No can be retrieved from the materials database or where none of the items with the specified Mark No 15 corresponds to the material item, the steps of: generating and displaying a screen that enables the operator to create a new record in the materials database for the specified Mark No or material item; and, storing the new record in the materials database. 20

22. A method of updating a materials database as defined in any one of claims 19 to 21, further comprising the steps of: providing an associated progress control database; creating suitable "Rules of Credit" for controlling the progress of an item of material in the progress control database; '25 - assigning a "Rule of Credit" to each item in the materials database; and progressing each item in the progress control database according to the applicable "Rule of Credit." Amended Sheet IPEA/AU - 25

23. A materials management system for a construction site, the system comprising: a materials database for storing information relating to the nature, identity and location of each item of material on the construction site; 5 a software module for colour-coding each item on the site in a 3D model of the construction site, the software module monitoring the database and, as a status of an item changes in the database, changing the colour of the item in the 3D model to give an immediate visual indication of the current status of the item; and, 10 a mobile data processing device having a data scanner for scanning machine-readable information, including identification information, provided in an identification tag attached to an item of material, and a GPS receiver operatively connected to the mobile data processing device for obtaining the GPS coordinates of the item, the mobile data processing device transmitting 15 the GPS coordinates and the identification information to the materials database whereby, in use, the status of each item of material on the construction site can be tracked.

24. A materials management system for a site substantially as herein described with reference to and as illustrated in any one or more of the 20 accompanying drawings.

25. A method of managing materials on a site substantially as herein described with reference to and as illustrated in any one or more of the accompanying drawings.

26. A method of updating a materials database for a materials management 25 system.substantially as herein described with reference to and as illustrated in any one or more of the accompanying drawings. Amended Sheet IPEA/AU