BEAP Data Management Tool User Guide
Contents
1. 120260368 633050 0 080 102605 SOMH 190RK0431 5505 0 JADUS 1102807005 3542 0 e 1aNROOTS BIOs Loot 13080140 63709 0 hove 1302C0012 837900 SLO TSP So O20 TIF 0M 5I Leb0S 1303000000 83803 0 L0906 1302KG0265 ooor 130280437 53804 0 S008 100d 1535555 e009 of 1020600530270 3342 130200077505001 34201 1902m06RR naai 31202 1302F0882212050 0 S344 10 A0TT 42 120700 JRH stinker 14402 130000612 63700 0 1 4403 130300015 53805 0 BEAP Data Management Tool User Guide doc Wistall secondary feeder bo Supply ine base Mole the cogs aseccaled wih his rame da action ia an allowance and wall nesedi install airefonditioning to the GEPS HV Svitohroom Replace LY Seiichi board to provide oomnpliant swilchgear stall air conditioning to the CEPS HV Swibohinoom instali Hy Logging on ihe Adeti Ring during flying exercises to obtain accurate uilizaiion Agures install Logging Miers on M substations with high ublitation figures during penods of ine of high usage 10 obtain d inglall Logging Meters on fie substations with high ublization figures during periods of bene of high usage 10 obtain d install Logging Meters on fhe substations wiih high utilization figures during periods of time of high usage to obtain 4 Retea and resti the RMU fuas or cun breskar settings bo match the size of franafommer installed Mote thai under Review afd rasel M RMU fuge Of Carol breaker setting bo maich tha site of brans2. Australian Government Department of Defence Defence Support Group BEAP DATA MANAGEMENT TOOL BEAP DATA TOOL USER GUIDE BASE ENGINEERING ASSESSMENT PROGRAM Date of Issue 23 March 2015 BEAP Data Management Tool User Guide doc Australian Government Department of Defence Defence Support Group Table of Contents Abbreviations Introduction Issues Register Input File 1 0 2 0 3 0 4 0 2 1 Issues Data Capture BEAP Data Tool 3 1 Reports 4 1 4 2 4 3 4 4 Appendix A BEAP Data Tool Process Flowchart Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Figure 9 Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Data Entry Edit Summary Tables Work Request List Issues Register Report Summary Table Pivot BEAP Data Tool Inputs Service Selection Sub Service Selection Next Available Issue Number Nominate Issue Number Alternative Issue Numbering Incorrect Sub Service Selection Start screen for the BEAP Data Tool Add Issues Register Input Data Navigation Pane BEAP Matching Screen Issue selection Work Request details Matching the Issue to a Defence asset Input Spatial Data Add new sub asset to the Defence database New asset numbering example Asset Risk assessment Navigation Pane Standard BEAP summary tables for use in the BEAP Report
3. 000 Future oe replace generators control system to upgrade to fully automated system 0902 U01 Electrical Reticulation Services Reale P2 Install HV rescue kits 2015 1 000 Future 0902 U01 Electrical Reticulation Services VEG P2 Install addiitonal LV load shedding 2015 1 640 000 Future 0902 U01 Electrical Reticulation Services KOMEN P2 Build separate LV HV transformer rooms with egress requirements met 2015 1 000 000 Future 0902 U01 Electrical Reticulation Services LE P2 Install insulation to exposed electrical connections 2015 6 000 Future 0902 U01 Electrical Reticulation Services lVery High P2 Install HV rescue kits 2015 13 500 Future 0902 U03 Water Reservoir MA P2 To provide better security and improved system redundancy in supply it is recommended 2015 60 000 Future the feasibility of one or more direct connections from the water supply tank feed lines direct to the water reticulation network be investigated and implemented if feasible 0902 U03 Water Reservoir KA P2 To provide better security and improved system redundancy in supply it is recommended 2015 170 000 Future the feasibility of installing a duplicate or standby DN375 main from the tanks to the reticulation network be investigated and implemented if feasible 0902 037 Base Pump Station Fire Booster Pump MESM P3 Multiple non conforming hydrants were also encountered Develop and execute a 2015 1 450 000 Future prioritized program of hydrant renewals
4. doc Base Engineering Assessment Program BEAP Data Management Tool User Guide Figure 12 Issue selection BEAP Service 8 sub service options BEAP Sub service Incoming Supply 1 issues listed for this sub service Issue Number 3 01 Issue 3 01 allocated to 0 asset records Refresh Issue 1 Site HV SLD shows incorrect old fuse sizes for the ring main feeders atthe Terminal Intake Substation Physical labelling atthe switchgear indicates a Data conflicting but correct size on one ofthe two feeders The other feeder is not Location Site HV SLD IBIS Asset 0763 20001 44391 0 CCC Risk Issue Type i b Provide Work request details for this Issue Step 7 1 Use the blue boxes in that section of this screen Figure 13 2 The first two boxes have drop down menus that provide a choice The remaining boxes are able to be edited directly 3 When all boxes are completed as required the purple Update Issue Record button should be clicked This will add the new or edited data to the Issue database 4 The priority rating of the issue is populated by the user at the time of entering the issue into the Issues Register Input spreadsheet and reflected in the BEAP Data tool Figure 13 Work Request details Update site HV SLD and install new copies in the site substations per the MIEE requirements for drawings and Update labelling on Irwin Barracks ri
5. insiaiiaaen of shrouding around exposed lve parts Mote this figuee in based c Replacement of aged banaionmers or AAAS of Shrouding auna eqposed ee parts Mole this figure is based Replacement of aged ranstormers or instalaion of shrouding around exposed H parts Mole this figure is based i Reglace ment of aged fansdomers or inslallstion of shrouding around exposed live parts Nole this igure is based Raslace ment of aged Ranstormners or insisEsien of shroudng around eeposed ive parma Mote this figure is based i ingtali re aringaishars Note ihis figur is based on 500 per a eded substation install Gre dringaiahets Note iis figure is Based on S500 per amimia puESATSA mgla Bre gatingueshers Mote thes Ague is based on API por atected substaton investigate i Fire Suppression is arequinement of the installation review building certification and identity which sul kreaigaie if Fire Duppression is a reguiremeni of he imglallalion review Building cerificabon and kient which awl inwestigate if Fire Suppression is a requirement of fie installation review building cechication amd identity which su Ieristigate If Fire Suppressaon is aneQuineMent of me installation bevie Guilin Cericabon amd bient whioh sul investigate if a Fire Risk Assessment was undertaken io remove fhis requiremend review building certification Hrer 0 08 0 05 0 02 Appendix A BEAP Data Tool Process Flowchart BEAP Data Tool Process Flowchart Defence ST
6. Asset O763 Z000744391 0 cecrisk Text Remaining Life Area EE Add Spatial data to existing Asset Latitude Longitude Label Start Point End Point Update Issue Record Likelihood of Failure Consequence of Failure 19 In this screen the user will a Select an Issue from the blue boxes in the top left of the screen Step 6 If the Issues Register Input spreadsheet has not been populated no issues will be available 1 2 Use the drop down menus available working down the three fields provided to get to a specific Issue number Figure 12 Click on the brown Refresh Data button when the correct Issue has been selected to repopulate the blue fields at the bottom of this part of the screen If this Issue has already been matched to an IBIS Asset the Asset identifier will appear in the white box Data will appear in the blue boxes taken from the Issue data entered originally in the Issues Register Input spreadsheet Press F2 or double click to edit in a field press enter when finished The blue Issue Type fields are used to provide a Category and a second if one is not sufficient for the selected Issue Both boxes have the same drop down list The second field is optional and is available for use if the Issue addresses more than one purpose or outcome An example of a selected issue record is shown in Figure 12 BEAP Data Management Tool User Guide
7. E EET 411 x 627 500 2 502 000 3 981 000 o 20 000 000 27 521 500 BEAP Data Management Tool User Guide doc Est Cost Oooo o T T T T e e ek Total Ni 8 7 26 8 J 14 Base Engineering Assessment Program BEAP Data Management Tool User Guide 4 2 Work Request List 28 This screen is navigated to from the Control screen Figure 8 It provides access to the standard Work Request list produced by the BEAP program Figure 21 29 The list may be printed as is or interrogated using the filters provided in the header row of the table 30 The Work Request List is also used to feed into IBIS Figure 21 Work Request list Work Request List 0902 037 Base Pump Station Fire Booster Pump uy High P2 The Fire Chief suspects the cause of the burst pipes is water hammer as a result of 2015 100 000 Future pump start up Engage water hammer consultants specialists to determine the underlying cause of these pipe bursts 0902 095 Substation 8 OLLE P2 Remove bee hive in substation brick cavity seal under window 2015 2 000 Future 0902 620 Raaf Ric Hv New Ceps Switchroom AtA lag P2 Replace 11kV Generators Archaic unreliable and unserviceable generators require 2015 3 600 000 Future Z manual intervention to synchronise and operate 0902 620 Raaf Ric Hv New Ceps Switchroom Very High P2 Detailed Cost benefit analysis to Install Castell keying system on existing generators or 2015 50
8. EP 1 Provide Directory which includes Issues Register Input File and BEAP Undertake site investigation Data File S IBIS SAMM S TEP 2 TEP 3 Populate Issues Register Input File EP 4 Inputs to BEAP Data Tool ST Open BEAP Data file STEP 5 Use Add Issues from Issues Register Input File button STEP 6 Select issue record STEP 7 If necessary make changes to 1 Location 2 Text 3 Issue Type 4 Solution 5 Comment 6 Remaining Life 7 Cost STEP 8b STEP 8a If no appropriate matched Match selected issue to a matched asset exists create a new Defence asset asset based on an existing asset BEAP Data Tool STEP 9 Assign spatial data if applicable STEP 10 Assign risk to matched issue STEP 12 Receive Summary Tables in report Work Request List Issues Register Report STEP 11 Copy tables for reports
9. When finished the purple Add this Asset and Match To Issue button should be clicked to update both databases match the new asset to the Issue and update spatial data if necessary BEAP Data Management Tool User Guide doc 10 Base Engineering Assessment Program BEAP Data Management Tool User Guide Figure 16 Add new sub asset to the Defence database is Add this Asset amp Match to Issue niqueAssetID O763 20007 44391 1 7 New assets created from existing assets appear from row number 3000 onwards in the In Use Asset Data worksheet which is a hidden worksheet of the BEAP Data Tool To easily identify new sub numbers a hyphen is placed after the existing asset number An example of a new asset is shown in Figure 17 Figure 17 New asset numbering example Retum to Control ee 0902 566 47004 12 902 Substation 27 r Ti ea 8 Since it is only possible to add new sub numbers the initial choice of the asset refer 19c will have to be the closest match that does actually have a SAMM number If there is not one available the BEAP Data Tool will indicate that a sub number cannot be created and the user will have to try another selection BEAP Data Management Tool User Guide doc 11 Base Engineering Assessment Program BEAP Data Management Tool User Guide f Add or update the Risk assessment for the asset Step 10 1 The user completes the risk assessment once the issue has been selected or w
10. Work Request list Issues Register Report Output Tab Summary table BEAP Data Management Tool User Guide doc oOo N NOORA O0OOMNDNN DNNN Base Engineering Assessment Program BEAP Data Management Tool User Guide DRAFT Abbreviations Description Abbreviation BEAP Base Engineering Assessment Program IBIS Interim Business Information System GEMS Garrison Estate Management System MCF Program Major Capital Facilities Program SAMM Strategic Asset Management Model BEAP Data Management Tool User Guide doc Base Engineering Assessment Program BEAP Data Management Tool User Guide 1 0 Introduction 1 This document refers to a Microsoft Excel workbook that was developed to link issues identified during a Base Engineering Assessment Program BEAP review of a base with existing Defence asset data in order to include the cost estimates for those issues in Defence s Major Capital Facilities MCF planning The tool has the capability to create new assets which are generated from existing asset ID when an exact match is not possible 2 To provide some context in terms of how the tool operates a process flowchart is shown in Appendix A This document should be read in conjunction with the BEAP Data Tool Process Flowchart The steps of the flowchart are referred to throughout the report to aid the user i e Step 2 3 Defence will provide a directory which will include the following files named accordingly to the base being asses
11. gitude values or assign a label 6 When finished the purple Add Spatial data button should be clicked to update both the Defence and the Issues databases Figure 15 Input Spatial Data Spatial Data Add Spatial data Latitude Longitude Label to existing asset Refresh Start Point Data End Point e Add anew asset to the Defence database for matching to an Issue Step 8b 1 If the existing Defence assets are too high a level to match to wigs E the Issue or if it is desired to add a series of segments to the r Defence asset database the BEAP Data Tool provides functionality to do so Figure 16 2 A new asset would be created when an issue has been identified for a non existent asset and hence a gap is identified in the existing asset data e g issue identified for substation 11 which doesn t exist in the asset data 3 New asset ID characteristics i e useful life value CF Figure 16 should be based on information from a number of sources including values in similar asset categories available GPS information site photos and engineering judgement 4 It is not possible to add an IBIS number or a SAMM number individually the only option available is to use an existing IBIS SAMM combination and add sub numbers New IBIS SAMM numbers are required to be created by Defence 5 The screen is pre populated with the next number available Data may be added to the blue boxes 6
12. hen reviewing an issue This is done in the last section of this screen Figure 18 2 Each choice is made via a drop menu attached to each box 3 For efficiency if the user has completed a risk assessment of an issue and wishes to replicate that assessment to another issue they can bulk edit using the Edit Issues Data button refer 16 e i e a risk assessment of one issue can be copied to another 4 When finished click the purple Update Issue data button Figure 18 Asset Risk assessment ai Update issue aaa Record Likelihood of Failure Consequence of Failure Rare 10 chance Rare 10 chance Rare 10 chance Rare 10 chance Rare 10 chance Rare 10 chance Rare 10 chance g Next Action There are three choices for the next action 1 Go back to the Issue Record section and select another Issue refer 17a 2 Edit the data showing for the selected Issue and Update Issue Record when finished or 3 Leave this screen to return to the Control screen by clicking the green Return to Control button at the top right of the screen 20 The BEAP Data tool should be saved using the Base Site Group name the default as provided by Defence BEAP Data Management Tool User Guide doc 12 Base Engineering Assessment Program BEAP Data Management Tool User Guide 4 0 Reports 21 Several reports are able to be produced from the BEAP Da
13. his example 3 010 has been entered as the Issue No Figure 5 Nominate Issue Number Electrical Electrical System Management e Amore detailed numbering process can be used as shown in cells B2 and B3 of Figure 6 Each time the same Service is selected i e Electrical the next number in the second decimal place will be shown i e if 3 010 3 011 and 3 012 has been used the next Electrical issue number will be shown as 3 02 It is up to the issue to continue with a more detailed numbering system or revert to the suggested issue number BEAP Data Management Tool User Guide doc Base Engineering Assessment Program BEAP Data Management Tool User Guide Figure 6 Alternative Issue Numbering l Sub Service A H LS Issue Na Service 1 ka a 3 010 Electrical Electrical System 2 Management 3 011 Electrical Electrical System Management Electrical HWV Intake amp Primary Switching Stations f If the user selects a Sub Service which is not related to the selected Service Figure 7 the Sub Service will be highlighted orange as a prompt for the user to correct the selection Figure 7 Incorrect Sub Service Selection A L a Issue Mn Serice Sub Service 3 010 Electrical Electrical System Management Wastewater g Columns E to M are required to be populated with data collected from the site investigations h CCC Risk column M allows the user to assig
14. including developing an infrastructure database to record age maintenance frequency and any other related issues 0902 037 Base Pump Station Fire Booster Pump P2 Re establishing a hydrant flushing program to flush sediments clear pipe biofilms and 2015 40 000 Future bring fresh water into low use parts of the system It will also give the on site plumbers the opportunity to continuously assess the condition of specific hydrants 31 When finished the orange Return to Control button can be clicked to return to the Control screen BEAP Data Management Tool User Guide doc Base Engineering Assessment Program 32 4 3 Issues Register Report 19 BEAP Data Management Tool User Guide 33 The issues register can be viewed by clicking on the orange issues register report button Figure 8 34 Data can be manually edited via the Edit Issues Data in Database button in Figure 8 Figure 22 Issues Register Tab AAF Richmond Issues Register Issue Ne 2gnicr 0 Robertson 1 inspected pit Barr 0 Robertson Gas Tank Rarracks 01 S Sata GFN BEAP Data Management Tool User Guide doc i years Bensi retordre and subsequent repavred The pipes should be monitored and replaced if the failure rate is deemed excessive Main fom C7 to OPS is overloaded Sitaton of open drain system Placaraing and signage atlaches to LP Gas tank was dady faded and unreadable inaccuracies anc Gefciancies in enginee
15. n a risk based on three drop down options 1 Low 2 Medium and 3 High Priority column L allows the user to assign a Priority based on five drop down options 1 P1 WHS Immediate 2 P2 Next FY 3 P3 1 5 Years 4 P4 6 10 Years and 5 P5 gt 10 Years j Cost column M allows the user to estimate the cost of the recommended action Costs must be entered as dollar values only rates may not be used Any text required to explain the cost estimate should be included in the Comments column k Where Spatial Data is available this should be entered in columns N to S There are two approaches available for the input of spatial data The first option is to capture both the start and finish latitude and longitude values The second option is to use GIS to create labels for assets which can be referred to during the site investigation to identify the location of the inspection Only one of the two options should be entered into the Issues Register Input spreadsheet After completion of the Issues Register Input spreadsheet the user should save the spreadsheet using the Base Site Group name as provided by Defence in preparation of input into the BEAP Data Collection Input and Analysis Tool BEAP Data Management Tool User Guide doc Base Engineering Assessment Program BEAP Data Management Tool User Guide 3 0 BEAP Data Tool 9 The purpose of the BEAP Data Tool is to match issues to Defence assets or create new asse
16. ng main feeders atthe Terminal Intake Substation to indicate clearly the fuse size for both feeders Risk consequence has been based on the possibility that an electrical problem causing serious harm might arise from the misinformation for the Intake Substation A more likely consequence would be that new equipment might be procured bought and installed that is not rated for the real fuse level leading to BEAP Data Management Tool User Guide doc Base Engineering Assessment Program BEAP Data Management Tool User Guide c Match the selected Issue to a Defence asset Step 8a 1 Use the dropdowns in the Match to Asset Data section of the screen to select the Asset that best matches the selected po Issue The drop drown lists are pre selected based on the eS Service that the current Issue relates to Note that there may not be a good match because the Asset list can be incomplete so the closest possible match should be made 2 The white boxes are populated with data from IBIS or SAMM that is associated with the selected asset Figure 14 Matching the Issue to a Defence asset Match to ASSET Data Base Irwin Barracks Asset Data IBIS Asset Type Asset Description 1 Asset ID 7 Useful Life Remaining Life Spatial Data Start Paint End Point Refresh Data Elec Supply 3 Asset Types Electrical Reticulation 3 Assets 0763 70001 44391 0 ene this A
17. ressed Step 5 This will clear the BEAP Data Tool of any existing data and automatically update it with current Issues Data Figure 9 Add Issues Register Input Data Issue Database Update Clicking this button will delete all existing data Issue Data Available for lt 2 choices corm BEAP Data Management Tool User Guide doc Base Engineering Assessment Program BEAP Data Management Tool User Guide 15 There are seven screens available in the Navigation pane of the BEAP Data Tool their labels indicate their purpose Figure 10 Navigation Pane Navigation Click button below to go to Report Edit Reference Data Go to Summary Table Pivot 16 Until all the Issues have been matched and the Work Request details added as necessary only the first button will be used the Go to Matching Data Entry Screen button 17 The remaining buttons have the following functions a Orange buttons enable reports to be produced discussed in Section 3 0 Reports b The Edit Reference Data button refers to the Reference worksheet which is a hidden tab in the BEAP Data Tool The Reference worksheet is a standardised list of assumptions and matching conventions as nominated by Defence these assumptions are able to be modified by the user if required be Defence c The Go to Summary Table Pivot button provides access to a summary pivot table of the contents of the BEAP Data Tool used for final quali
18. rical Manua HV Rings amp Interconnector Cables Manua Manua Manua Manua Manua Manua Manua entry entry entry entry entry entry entry entry 3 650 000 1 557 000 7 385 000 7 500 000 60 000 639 200 ll l i 10 000 60 000 15 800 2 109 000 1 558 250 8 524 250 3 508 500 81 300 Manual Manual Manual Manual Manual Manual Manual an 1 640 000 462 000 639 999 10 000 wo 1 021 500 2 740 000 2 878 500 417 650 6 312 500 23 152 500 4 298 999 432 650 When finished the orange Return to Control button can be clicked to return to the Control screen Standard BEAP summary tables for use in the BEAP Report Executive Summary Very High a s 5 23 152 500 20 534 175 1 152 500 16 353 040 17 835 10 855 000 72 065 050 No o o e ooo y ae 4 298 999 1 396 500 2 990 100 12 994 000 1 431 076 13 841 490 36 952 165 432 650 15 000 737 000 3 000 12 930 1 200 580 as ae sf o Est Cost assa 3 011 925 see a see es 1 293 260 2 239 420 22 245 895 6 2 3 12 73 81 19 110 58 1 075 000 7 375 000 7 505 000 3 575 000 642 999 5 088 400 a 25 261 399 ae a Sea ae ee 0 mo 25 261 a 18 306 250 1 361 600 19 205 000 158 651 4 250 000 68 542 900 a a SS Ge Pa EO
19. ring systems data Contained in GFIS Mes Uniinown of 35 mispected and assessed as unsermceatie and High Low SRAI FUSK ASSOSS ITO idee oo sted oldie os aoe e aJe Base Engineering Assessment Program 4 4 35 BEAP Data Management Tool User Guide Summary Table Pivot and filters can be applied using the drop down lists available 36 filters available can be selected for review Figure 23 Summary table RAAF Richmond BEAP Funding Recommended 3 million te 3323 S1Maa0TTa 2120 24M 10AT A210700 JISMA TAZ 191900 Return te Central iene COT Laer Install a dedicated POS network ingiali Re third generator ai the CEPS Replacement of HV Ring Cables 0 60 16 A summary table has been provided for review purposes This is a pivot table so a variety of selections The blue Refresh Pivot button should be clicked before using the table After that any combination of the 37 When finished the purple Return to Control button can be clicked to return to the Control screen a3 a 10242001819 12040 333 130ANTTE34170700 3336 130QM07 742120700 33 39 130QADT 4212070 0 S347 1302A0T 21207 OH S01 130d A20010331200 302 1302803845309 0 20201 1302m0808 4823 a30207 3130400117120010 3903 2 130DA0774 2120700 LOM 10RFOIsEaEND O 130200608 3823 0 53 0303 13020651 212080 0 DET 1102007 T 592061 0 SMO 140RD0012 5370040 Logo
20. sed a Base Name Issues Register Input xlsx e g Irwin Barracks Issues Register Input xlsx b Base Name Asset Data xlsx e g Irwin Barracks Asset Data xlsx c Base Name BEAP Data xlsm e g Irwin Barracks BEAP Data xlsm and d IFM Cost Structure xlsx 4 The interaction between the above files and the BEAP Data Tool is shown below in Figure 1 Figure 1 BEAP Data Tool Inputs 5 The BEAP Data Tool a loads data contained in the Issues Register Input spreadsheet which is populated by the site investigation team Step 3 b allows the user to update amend the Issues database Step 6 and 7 c enables each Issue to be matched with a Defence asset or anew SAMM asset to be created if a good match is not available or if the BEAP review has defined segments of an existing asset and identified issues with specific segments Step 8a b d enables Work Request data and Risk Assessments to be added to the Issue Record Step 7 and 10 e allows spatial data to be assigned to an issue Step 9 f produces a Work Request List Step 12 g produces a set of standard tables for use in BEAP Reports Step 12 and BEAP Data Management Tool User Guide doc Base Engineering Assessment Program BEAP Data Management Tool User Guide h includes a data summary file for the base in the format required for inclusion in the MCF planning process Step 14 2 0 Issues Register Input 6 Issue data is collected during the
21. site investigations which are undertaken as part of Phases 1 and 2 Without the population of the Issues Register Input file soreadsheet provided by Defence no issues are able to be loaded into the BEAP Data Tool 2 1 Issues Register Input Capture re The first step of the BEAP process is to undertake the site investigation on the nominated base Following the site investigation the Base Name Issues Register Input xlsx e g Irwin Barracks Issues Register Input xlsx is required to be populated Step 3 No columns or rows can be deleted in the Issues Register Input file 8 To input an issue into the Issues Register Input spreadsheet the following process should be followed a Select the nominated Service from the drop down list column C In this example Electrical has been selected Figure 2 Service Selection 1 3 01 Electrical b Select the required Sub Service from the drop down list column D In this example Electrical System Management has been selected Figure 3 Sub Service Selection Electrical Electrical System Management c Once the Service has been selected the next available issue number will be shown in column A In this example the next available issue number is 3 01 Figure 4 Next Available Issue Number Electrical Electrical System Management d The next available issue number should be entered into column B as the Issue No In t
22. sset 18 Value 3 980 153 Add Spatial data Latitude Longitude Label to existing Asset 3 The matching process is undertaken using judgement from the user with verification from the investigation team to ensure the issue has been matched to the correct IBIS SAMM asset The purple Click to Match button is clicked to match the current issue with the asset Note that if necessary a new asset can be created refer 19e if an exact match is unable to be found 4 The new or revised IBIS asset identifier will also appear in the white box near the bottom of the BEAP Issue Data section of the screen BEAP Data Management Tool User Guide doc Base Engineering Assessment Program BEAP Data Management Tool User Guide d Update spatial data for the asset Step 9 1 Spatial data should be captured wherever possible for all assets with an identified issue 2 Spatial data is either entered into the Issues Register Input spreadsheet which is loaded into the BEAP Data Tool or entered via the tool at the time of matching the asset 3 To check if spatial data has been pre populated in the Issues Data tool the brown Refresh Data button in the spatial data section should be clicked 4 If data already exists the boxes will show it and be recoloured white 5 If there is no existing data new spatial data or corrections can be added to this section The can enter the start and finish latitude and lon
23. ta Tool The reports are accessed by clicking on one of the three orange buttons in the navigation pane Figure 19 22 The Goto Summary Table Pivot button is provided to the user for review purposes as discussed in Section 4 4 Figure 19 Navigation Pane Navigation Click button below to go to Report Edit Reference Data Go to Summary Table Pivot BEAP Data Management Tool User Guide doc 13 Base Engineering Assessment Program BEAP Data Management Tool User Guide 4 1 Summary Tables 23 This screen is navigated to from the Control Screen Figure 8 24 Phase 3 reports Figure 20 It provides standard summary tables by Service and the table used in the Executive Summary of the BEAP 25 copied and pasted into the Phase 3 report The nominated service is selected from the drop down list The Executive Summary table can then be 26 the Part 1 Overview Report with the Capacity Condition and Compliance assessments to be manual entered In addition to the Executive Summary the table highlighted by the red box in Figure 20 should be copied to based on the outcome of the Phase 3 investigations 27 Figure 20 Service Incoming Supply Stations LV Switchboards Transformers Very High No Est Cost No Est Cost No Est Cost No Est Cost No Est Cost No Est Cost No Est Cost Est Cost Est Cost Intake amp Primary Switching Subs Ring Main Units amp Elect
24. tonmer inttalbed Mote Mai under Review and feel he AMU fie Of Grou bree Getting bo match ihe sine of ansiano ineetalbed Mote Mal winder Review and esel he RMU fuse or circu breaker settings bo maich the site of rangtermer installed Hote thal under Raptacement of enren sutelations hor egress compliance This would kwoke Gudding anew sutstation and rag Replacenvent of existing substations for egress compliance This would invote building a naw substation and lag Fla paneienn of disting Substations for Agras campia Thas would bob badag new substation and Stag Reptaceneenl of casting substaions tov egress compliance Ths would egies balding a new substabon and Hage Replacement of existing subglalions fot egress compliance This would ighe balding a new subslation amd vag Reptacemen of axisting substations fer egreas compliance Th s would invoke Suilding a new suestaton and stag Replacement of aged fransicamers or instalation of chroucing arcund exposed be parts Note this figure is based i Replace rent of aged Bansionmers Or Astaat of Shidudag Around eeposed live Paks Nols this Agure is based i Replacement of aped bansiormers oF instalation of shrowding around eqposed Be parts Mote this figure is based i Replacement of aged franaformers or instalation of shrouding around exposed bee parta Mole this figure is based i FRaplace ment of aged Panasemiere Of indian of BNrouGing around aptat be para Hole this figure ip based i Replacement of aged fanstonmers or
25. ts where required to add risk assessments for the Issues identified and to enable editing of recommendations and work requests arising from the Issues 10 The entry screen Figure 8 for the BEAP Data Tool provides data linking and update functions and navigation to other parts of the tool Figure 8 Start screen for the BEAP Data Tool BEAP Data Management Tool Version 2 02 Issue Database Update Clicking this button will delete all existing data Issue Data Available for RAAF Tindal 2 choices Serer Navigation Click button below to go to Report Edit Reference Data Go to Summary Table Pivot Asset Data Update Defence only Defence Data Available for RAAF Base Tindal 2 choices BEAP Tool Version control update 11 The coloured buttons execute macros which run the tool s functions 12 The Asset Data Update Defence only section can be edited by authorised personnel only When the user receives the BEAP Data Tool the Asset Data will have been pre populated 13 The blue box next to Issue Data Available for has a drop down list of Base options which are taken from the file named Base Name Issues Register Input xlsx e g Irwin Barracks Issues Register Input xlsx in the Directory There will only be one file using that naming convention present in the Directory provided by Defence 14 With the correct Base selected the Add Issues from Issues Register Input File button should be p
26. ty checking purposes d The Go to Matching Data Entry Screen takes the user to the matching screen Figure 11 e The Edit Issue Data in BEAP Database button allows the user to edit the Issues Register Input Data in the BEAP Data Tool This button is particularly useful when wanting to make bulk edits to existing issues or to copy the profile of one issue to another e g if you had multiple substations with an identical issue you could easily apply the risk assessment values to all the issues as opposed to having to do them individually in the Go to Matching Data Entry screen BEAP Data Management Tool User Guide doc Base Engineering Assessment Program BEAP Data Management Tool User Guide 3 1 Data Entry Edit 18 When the green Go to Matching Data Entry Screen navigation button is pressed the user will be presented with the Matching Screen Figure 11 BEAP Matching Screen Matching Screen Start with an Issue then choose an IBIS Asset BEAP Issue Data Press F2 or double click to edit in a field Press Enter when finished Match to ASSET Data Issue Record Asset Data BEAP Service 0 sub service options Base BEAP Sub service 893 issues listed for this sub service IBIS Asset Type _ 52 Asset Types Issue Number as Issue allocated to 1 asset records Asset Description 3306 Asset Refresh Data Asset iD Match the Issue to thisA t j Useful Lite an Value a BlS
Download Pdf Manuals
Related Search