Exhibit B1-94 Jun0104 Undertaking Vol 14 Pg 2401 JIESC
Contents
1. Hafal E lee g Ceia i iiai ae ukiy f Saep y l gal E ag Figure 40 Clearly describe the possible consequences or hazard that may occur 1f the project is not completed Enter in k the cost that will be incurred as a result of the consequences occurring as identified in item 1 O Select the box with the label that suitably describes the probability of the hazard occurring in the next year The probability value associated with the label can be displayed as shown in Figure 39 Project Evaluation Tool User Manual Page 43 e Function Button Summary Help Clear S 3 To execute the help routine which displays general information on project drivers parameters and formulae utilized in the program To print the information driver sheet currently displayed To quit the program The program will provide an opportunity to save the project data displayed before initiating program shutdown To save the project data displayed in the database summary To display the database summary The program will provide an opportunity to save the project data displayed before leaving the information data entry sheets To clear the contents of all information data entry sheets for entering data another evaluation The program will provide an opportunity to save the project data displayed before clearing the sheets In saving the project data the program will determine if a dupl2. Deetipion of baretin Project Prior E TE 7 Pete uf After Selecting the cell press the Shift and F2 keys together Cal Hote Leed by the Gent ap fu mealing and et the pumi of vad does wm the dal se Also awed bp thee progam Lor schepltang the pojeli when ereoking the deletes change Func been im the databace IMPORTANT I The project wi waise Project Evaluation Tool User Manual Page 15 e General program information is also available by using the Bera button When the EA button is selected a dialog box as shown in Figure 13 will be displayed showing a list of topics which can be individually selected and displayed Project Evaluation Tool User Manual Page 16 Egidii Regon _ Ente a descophon for be pre Pragi Dessa de e Engtreegpisenper __ mmmmn ProeetGoet perf a EPa pecdectis comelec enter direc perais On EF ha el ba realized ILS Jute ESAk reducedmatierepce elt 222r C Dp tevmehkoe of bere fits PROJECT EVALUATION TOOL HELP THE OBJECTIVE OF THIS PAOGAAM IS TO ASSESS THE PRIORITY OF A PROJECT BY COMPARING THE POSSIBLE FINANCIAL COMSEQUENCE IN DEFERRING THE PROJECT BY ONE YEAR RISE COST TO THE SAVING ACHIEVED BY THE DEFERRAL FOR MORE INFORMATION SELECT THE APPROPRIATE TOPIC AND CLICK DN DE f BASIC FORMULAE C PRJECT DRIVER CATEGORIES C HAZARD DOST C EQUIPMENT OVERLOAD DRIVER C UNACCEPTABLE REL
3. Herora Eecel PETWFILE 415 12 nl Encian Dione Sumi 7 L ges Sele thee ppe Cl ure ke preg giai O Enter the lollovang Expected underage valje praats ofa 120 wok bagel Gy Humber of days peryearundevottage org gt CG joe Humber of custo nees forlaj by iarba emmssmmsssnz A Liaj ae TOM Egimykd atthe customer serice enbarce pon Or Votan Flicker probla select tha fee of customers afacted lithe mr Subahan Far al O a Power Quality Grier Fisk Col kijescscs DU Projact Priority Indicator seen III Figure 34 Identify the type of power quality problem by selecting the appropriate box The program will adjust the sheet layout accordingly to display the data required to evaluate the problem For the type of power quality problem identified in item 1 the program will automatically display a target or threshold value The expected undervoltage value entered in item 3 is compared to the target to verify if a problem exists and to evalute the severity of the problem which will be reflected m the calculated risk cost value The expected value must be less than the target value for the program to generate a power quality risk cost The target value is based on CSA standard C235 Enter the expected undervoltage value in volts on a 120 volt base that the system or customers will be subjected to without the project completed Enter the number of days per year that the undervoltage oc
4. Selec the ype of unesccepisols poeer quel ey TTT vermoe 1 underectiaye Vonage ficher E termonce 7 vetage imbalance rier the joling COLETE Esperi vahage THO in parcari Minitar ui a toi par Tiere PP err EETA O O Humter of customers afected be hamiioniia J DF Loma wegen or Mota Flicker enablers alad tha pe of customer afacthd Litem mr Sukam han Far al Power Quality Crier Fisk Col kiescccs DU Projact Priority Indicate vd Figure 36 Identify the type of power quality problem by selecting the appropriate box The program will adjust the sheet layout accordingly to display the data required to evaluate the problem For the type of power quality problem identified in item 1 the program will automatically display a target or threshold value The expected Total Harmonic Distortion THD value entered in item 3 is compared to the target to verify if a problem exists and to evaluate the severity of the problem which will be reflected in the calculated risk cost value The expected value must be greater than the target value for the program to generate a power quality risk cost The target value is based on IEEE standard 519 Enter the expected Total Harmonic Distortion THD in percent that the system or customers will be subjected to without the project completed Enter the number of days per year that the harmonic problem occurs Even if the problem occurs only briefly in a day the day shoul
5. approval in step 4 and that scope and cost have not strayed If the project is lt 300k the Capital Program Leader approves and if gt 300k the Capital Program Leader sends to the Planning Manager and recommends approval Project Evaluation Tool Program PET User Manual Prepared by Power Softech International Inc 12296 Aurora Street Maple Ridge British Columbia Canada V2X OR For BC Hydro Distribution Engineering amp Planning October 1999 WY Power Softech International Inc Power Softech International Inc does not warrant that the functions contained in the program described herein will meet particular requirements or that the operation of the program will be uninterrupted or error free In no event will Power Softech International Inc be liable for any damages including but not limited to loss of data loss of profits loss of savings loss sustained by third parties or any other incidental or consequential damages arising out of the use or inability to use the program even if Power Softech International Inc or its distributor have been advised of the possibility of such damages Power Softech International Inc will also not be held responsible for any alterations or changes to the program or associated documentation and the subsequent consequences due to those changes Contents Introduction System Requirements Installing the Program Getting Started Program Interface General Cell Notes amp Help Fu
6. the install procedure will examine the hard drive s of the PC on which it is being installed to determine if there is a previous installation the message Checking system please wait is displayed The procedure will detect if the program file PET XLM is present and determine the path for the file If the file is detected the procedure will display the path for the existing installation and allow the files to be overwritten if desired see Figure 1 If the files are not to be overwritten an alternate path can be entered For a specified alternate path if the entered path does not exist the program will create the folder directory before proceeding with the installation previous version exists Select Nest to overwrite the existing files located as per a the path shown Of enter a new path then select Nests to continue with the Installation lt Back neo Cancel Figure 1 e Ifa previous installation is not detected the procedure will recommend a default path If desired an alternate path can be entered instead of using the default If the entered path does not exist the program will create the folder directory before proceeding with the installation Project Evaluation Tool User Manual Page 3 The procedure will also display the option for having a shortcut for starting PET placed on the desktop as shown in Figure 2 When this option is displayed select Yes to have the shortcut installed
7. Col pre EngineenPianeyers l Project Cost ei cr NY Wiha projectis comte enis direct bane dn kai el bestoen up TRC Mees rede ee lei ee SIE Dpscnpi po of tenens EE Eed LC Note Indicators ale Li General Trakai See f Poss Gum sae Leit zeien Z Eege 7 a Figure 10 Project Evaluation Tool User Manual Page 13 There are two ways of displaying a cell note Method 1 Point to the cell and the cell note will pop up on the sheet displaying the information as shown in Figure 11 In some cases it may appear that the entire note is not visible For those cases use Method 2 to display the cell note DF Me rozolt Eer PET WFILE_ 1S P Ki D Sakta Fagin Emir a dostrigpthon tor Pa pr TT Engineer Planner Project Gigt a eee gi Fal il ee pete acad era rita rice Used by Hie og am hor sarling arid Geecheg Heeb runner of vakirerogs ithe databace Also used by the program lor identilyeng Ihe piast Praject Priortty Indicator IMPORTANT ii Tie pajaci id yaus mt be arem ke La ELD Eanan Project Evaluation Tool User Manual Page 14 Method 2 Select the cell and press the Shift and F2 keys together as shown in Figure 12 Excel PETS FOLEALS WIES Saieta Hagin Enig a gaecription forthe promact Penjar Demem eee T a gt Com lenhe Erdteepaue I A Frae cotas EH FT Pes ery eel rE corinne eles dire deeg Ge K that wall Se ren Tan
8. Gubdatug Name C 100 MOLE HOUSE CHE Twenp C AH SIN HEEE C CHIEF LAKE C AMAHSH C COLEBANE To return to the previous men Check the DE bulton bo conte C ALBERTA POWER C DAWSON CREEK chek the Cancel button C ABAHIM LAKE C DEASE LAKE C ATLIN C DANA C RABINE C EDDONTENNAJON C BEAVERLEY CTY C FIRTH LAKE C BELLA BELLA C FOOTHILLS C BURNS LAKE C FORT NELSON When the substation is selected as per item 1 the program will place the SAIDI target for the station in the space provided The value is automatically extracted from a database file installed with the program Note that the target value can be overwritten if desired The program will also enter a value from the substation database for the average value of SAIDI for the station selected This value is for the entire station and may not be the appropriate value for the customers affected by the project since the project may affect only a small portion of the customer connected to the station The value should be changed as required to reflect the impact on the customers affected With the project completed and in service enter an expected value for SAIDI for the customers affected The value entered is compared to the value in item 3 in evaluating the reliability risk cost Note that if the value entered is less than the target value item 2 then the risk cost is based on the improvement to the target value Improvement below the target 1s not considered of any valu
9. Metz Hoth SL H L E M Eeiprt te mt D D O D Click on Ware the desired ara escugnn fir ihe pret Cy J option box Eninbedrlanner Progen Los es Ethe project ts competed antes direct benefits dp ke that wll be realized Oo reded losses duced mainienance gl lees Js Description of banaits Project Priocity Indicator Select one of the leftmost cells for entering data Figure 8 Project Evaluation Tool User Manual Page 11 e If an attempt is made to enter data into a cell other than one that will accept data an error message will be displayed as shown in Figure 9 D Hitara Excel PETwEE ALS Fu Seles Pe Fedin C Enter a description forthe project EngheedPinner ooa Projeni Coed Mih m Eha projectis completed enter direct benefis Op KE that well be realzed 16 duked iagt edule mamnleeanrge al 4z L D zcegtvn of bereits giereg fT Data entry attempted in unauthorized cell A Locked cells cannot be chamged Lox pel Figure 9 Project Evaluation Tool User Manual Page 12 Cell Notes amp Help Function To assist in entering data the program uses cell notes to provide information on data requirements Cells which contain notes are indicated by a small rectangle at the upper right hand corner of the cells as shown in Figure 10 Micierelt Face PET WRILE XLS Select gp Region Enie a dpzcrphon for ha proc
10. User Manual Page 49 Save Note that if any projects are deleted for the deletion to be permanent the function button must be selected Otherwise the project will not be deleted and the next time the database is accessed the project will still be present This does not apply using the change option When the change option is selected the project information is displayed in the Data Entry sheets If changes are made to the data the changes must be saved using the data entry sheet see button with the overwrite option selected from the dialog box that will be displayed The changes will be permanent in the database Project Evaluation Tool User Manual Page 50 e Adding a Project e When viewing the database a project evaluation can be added by selecting the L IER function button When the button is selected the program will display the Data Entry sheets the General Information sheet will be initially displayed for entering an evaluation The evaluation can be saved to the database by using the button in the Data Entry sheets Project Evaluation Tool User Manual Page 51 e Function Button Summary Sort To sort the database summary records Options are provided for sorting the Data records i e selection of sorting key and sorting order eee To print the database summary Summary Delete Change To delete or change a project evaluation Select a cell in the row of the project a Project desired and click on this function
11. be sorted using the Fa function button When the button is selected a dialog box will be displayed with sorting options that can be selected as shown in Figure 43 PROJECT EVALUATION TOOL PET x Figure 43 Project Evaluation Tool User Manual Page 47 e Printing e By selecting the kel function button the information in the database can be printed When the button is selected a dialog box will be displayed with options that can be selected see Figure 44 PROJECT EYALUATION TOOL PET x Sg Figure 44 Project Evaluation Tool User Manual Page 48 e Deleting or Changing a Project Delete Change A project within the database can be deleted or changed using the function button First select a cell within the row of the project to be deleted or changed and then select the function button as shown in Figure 45 EF Hes Excel PETSUMAY XLS Selecta cell in the row of the project and click on the Delete Change_a Project butto Figure 45 PHUJELT EYALLA IOR TOOL PET a THE FOLLOWING PROJECT HAS BEEN SELECTED FOR CHANGING OF DELETING PROJECT ID i PRMECT GES CAIFTION Sample project to d usirate the a ue of the hurcteen buttoms DO TOU WISH TO CHANGE OR DELETE THIS PROJECT 7 fe CHANGE DELETE After making a selection click on the OK button to continue To retum ia vimming lha dalakaso okok an tho Canos bution Project Evaluation Tool
12. button The option for deleting or changing the project evaluation will be displayed Save Summary To save any changes i e sorting or deleting of records made to the database summary Add a To create and add a new project evaluation The information data entry sheets Project will be displayed for creating a new evaluation After entering the required data the evaluation can be added to the database summary by using the Save button in the information data entry sheets oa To quit the program Project Evaluation Tool User Manual Page 52 Summary of Steps for Entering a Project Evaluation 10 11 12 Start the PET program by selecting the Programs menu item DEP Tools PET Vx x or by selecting the desktop shortcut labeled PET Vx x In the second dialog box displayed select the option Evaluate a new project Begin entering project data in the General Information data entry sheet Enter data into other data entry driver sheets as required Once all data entry is complete print the data entry sheets or the Priority Statistics if desired by using the function button Save Save the evaluation to the database by selecting the function button in one of the data entry sheets To enter another evaluation select the function button to clear the data entry sheets and then enter data into the sheets print and save the data etc To view the data in the database select the function button to go t
13. close followed by a dialog boxes which requires the user to select the appropriate options select by clicking on on the desired button using the mouse to proceed with the program operation Note that the introductory screen will also advise as to the version number of the program For more information on the dialog boxes displayed refer to the section Program Interface amp Operation Note If you are using Excel 97 the dialog box shown in Figure 3 may be displayed upon starting the program after the opening introductory screen If this dialog box is displayed you must click on Enable Macros for the program to be initiated Hranzalt F eral TOTE CNS Oey contain Auses hat could be harmful to your opu Tf wou are cure this mobba E fron a brushed source kk Enable Macon F wou are nok sure and vant to prevent Aire macros from sagte chek Ces Harras Tel Me More Figure Project Evaluation Tool User Manual Page 5 Program Interface amp Operation e General The program uses dialog boxes for presenting information and user selectable options Spreadsheet layouts are used for entering data and presenting results Within the spreadsheet layouts function buttons are available for selection to allow the user to perform specific operations necessary for evaluating and saving a project and printing the results When the program is started see Getting Started for information on starting the program a series
14. to quit the program SS i t select the Continue button Continue mue Figure 18 In the event that the evaluation data has not been saved the Save button can be selected to save the data before the program is shutdown Note that if the Save button is selected the program will verify that the project ID for the evaluation to be saved does not already exist in the database If a duplicate does not exist the program will save the evaluation display a message advising of this as per Figure 15 and then proceed with shutting down the program after the message has been cleared If the program detects that a duplicate project ID does exist the program will display a message as shown in Figure 19 PROJECT E YALUATION TOOL WARHING UI THE DATABASE CONTAINS A PROJECT WITH THE SAME PROJECT ID AS THE ONE TO BE SAYED THE PROJECT ID MUST BE UNIQUE II Please select one of the following options OVERWRITE the existing entry in the database SAVE WITH A NEW PROJECT ID DO NOT SAYE AND OVERWRITE Hote To save the project as a new entry in the database select the second option and enter a project ID value for the entry After selecting an option above select the OK button Project Evaluation Tool User Manual Page 21 Figure 19 A unique project ID must be entered if the data is to be saved without overwriting an existing database entry In Figure 19 the second option will allow a new project ID to be ent
15. Do you wish to have a shortcut placed on the desktop for starting PET Figure 2 When the installation procedure is complete a Programs menu item called DEP Tools will have been created containing a program submenu item labeled PET Vx x Note that the version number Vx x is indicated in the label for the program submenu item If you select this program submenu item the program will start Alternatively if the shortcut has been installed on the desktop select the shortcut to start the program Note The program submenu item and shortcut are linked to the file PET XLM which is associated with the Excel program If your Windows environment has been customized such that the association between the Excel program and Excel files is broken you must run the Project Evaluation Tool from within Excel by opening the file PET XLM i e start Excel and then use Excel s File Open menu command to open the file PET XLM which will start the program Project Evaluation Tool User Manual Page 4 Getting Started To start the program select the program submenu item from the Programs Menu select Start Programs DEP Tools PET or use the desktop shortcut if it was installed If your Windows environment has been customized such that the association between the Excel program and Excel files is broken you must run the program from within Excel by opening the file PET XLM When the program starts an introductory screen will appear and automatically
16. EXHIBIT _B1 94 BC HYDRO UNDERTAKING BC HYDRO REVENUE REQUIREMENT HEARING 2004 05 AND 2005 06 HEARING DATE June 1 2004 TRANSCRIPT REFERENCE Volume 14 Page 2401 REQUESTOR JIESC QUESTION Please provide a copy of the manual as referred to in B1 59 for the process of filling out PET project evaluation tool RESPONSE Distribution uses the Project Evaluation Tool PET for prioritizing system improvement capital expenditures Pet was developed internally at BC Hydro It has been reviewed by EPRI and is considered a leading edge tool It provides valuations for key performance drivers and considers the risk of project deferral The tool has been updated three times in five years and training is provided regularly to those who use it last training October 2003 A copy of the PET Manual is attached PET is part of a comprehensive and well established planning process that determines the requirements for capital investment Specifically there are several levels of review and approval as described below Step 1 Engineering reviews the system constraint evaluates solution options recommends an option and determines a Project Priority Indicator PPI using the Project Evaluation Tool PET This is submitted to Distribution s Area Capacity Planner Step 2 The Area Capacity Planner reviews the project submission This review will determine if the best solution option has been submitted and verify the details submitted Inpu
17. IABILITY DAIVER C UMACCEPTABLE POWER QUALITY DAIVER C REGULATORY OF LEGAL REQUIFREMEMT DRIVER CONTINUE SELECT A TOPIC AND CLICK ON THE OK BUTTON OF TO EXIT THIS HELP FUNCTION CLICK OM THE Cancel BUTTON Figure 13 Project Evaluation Tool User Manual Page 17 e Saving Evaluations After all data has been entered the evaluation can be saved to the database for future review by selecting any one of the buttons in the data entry sheets During the process of saving the evaluation the program will verify that the project ID for the evaluation to be saved does not already exist in the database The project ID must be unique If an entry in the database with the same project ID is detected a dialog box with options will be displayed as shown in Figure 14 PROJECT E YALUATION TOOL WARNING I THE DATABASE CONTAINS A PROJECT WITH THE SAME PROJECT ID AS THE ONE TO BE SAYED THE PROJECT ID MUST BE UNIQUE II Please select one of the following options OVERWRITE the existing entry in the database DO NOT SAVE AND OVERWAITE return to the project data entry sheet Hote To save the project as a new entry in the database return to the project data entry sheet change the project id and then save the project After selecting an option above select the OK button Figure 14 If a duplicate project ID is not detected the project data will be saved in the database and a message
18. ION TOOL N WARNING THE CLEAR BUTTON IS DESIGNED TO CLEAR THE WORKSHEET TEMPLATES OF ALL ENTERED DATA be IN PREPARATION FOR ENTERING DATA FOR ANOTHER PROJECT li gea do nol eich to chaar the iemplate li gow sich to peed eth the claar lundin Figure 26 Project Evaluation Tool User Manual Page 24 e The summary database can be accessed at any time by selecting the Summary function button When the button is selected a dialog box will be displayed as shown in Figure 27 with an option for saving the evaluation if necessary PROJECT EVALUATION TOOL Figure 27 Project Evaluation Tool User Manual Page 25 e General Information Data Entry Sheet EP Miciasalt Eer PETWFILE 5 z Ke Se D emm me Oo OOO o O Rot Figure 28 For the five categories listed select the region where the project is located by clicking on the appropriate box Clearly describe the project Enter information about the project objective and scope such that the project can be easily identified and recalled if saved to the database The project ID can be any sequence of characters but the value must be unique Enter the appropriate cost centre for the project Enter the name or initials of the individual responsible for the project and the project evaluation Enter the cost for the project in k i e Entered Value Cost in Dollars 1000 If the project is completed enter a value fo
19. ah poor cueio mes Irmecheee De Age petal elt I Vea Wi O o Reiahiiy Ceker Riak Gislinn den Propect Frioriby lmdicater Pe tT mmm 2 ____ Figure 30 The program provides the ability to extract SAIDI statistics on a substation basis which can be used in calculating the reliability risk cost By selecting the Substation button in the data entry sheet the program will display a list of regions as shown in Figure 31 from which the desired region can be selected Note that the default is the previously selected region in the General Information sheet Project Evaluation Tool User Manual Page 29 HIMMEL TI EVALUATION TO Figure After selecting the region an alphabetical listing of the substations for the selected region will be displayed as per the example shown in Figure 32 If the number of substations is too large to be displayed in one dialog box Page Down and Page Up buttons are made available to access all of the stations When the substation is selected the substation name will be automatically placed in the space provided in the Reliability Driver data entry sheet Note that the substation name can be overwritten if desired Project Evaluation Tool User Manual Page 30 PRI WELT EVALUATION TUUL Region Selected Honthem Select a substation from the following het IF the substation desmed is mot shown eciect Page Down to display addibonal selections if there are any Subtialon Name
20. aluation Tool Program requires Microsoft Excel which is used to generate the interface Excel is used to direct program operation control the display perform printing operations and calculations To run the program Microsoft Excel 5 or higher is required e For the program installation 1 0 MB of hard drive space is required Additional hard drive space is required if project evaluations are saved to the database e System requirements memory and CPU are determined by the requirements for running the operating system i e Windows 95 and the version of Excel being used e The program was designed for optimal viewing with a resolution of 800x600 or higher Viewing at lower resolution is permissible however portions of the input spreadsheet layouts may require using the keyboard arrow or page down up keys to access all parts of the sheets When displaying the database summary the use of the arrow and page down up keys will be required to view all database information or use the window scrolling bars Project Evaluation Tool User Manual Page 2 Installing the Program e Torun the PET program the computer must have Microsoft Excel 5 or higher installed Installation Steps e With Microsoft Windows running as the operating system insert the program diskette in a drive i e a drive e Select Start Run assumes Windows 95 98 or Windows NT is the operating system e Type a install and select OK e During the installation
21. alure would oru himir maliari brian Tubu han Eural 0 0 O o Safety Drvar Pisk Cost hfj sss sss ss Prajact Prinity bedicater zess o e rava Estate Powe Guay Sately Figure 38 OC Select the box with the label that suitably describes the probability of the equipment failing and posing a safety hazard during the next year The probability value associated with the label can be displayed as shown in Figure 39 Select the type of area which suitably describes where the equipment failure would occur Project Evaluation Tool User Manual Page 41 PE pei an ee a ee ey rer D I bbi ig Janey Wee ei wger O O Click on the descr on the description to ce the probability Gate iD var Flick Copien T Projed Priority indicamr 2 j PROJECT EVALUATION Figure 39 Project Evaluation Tool User Manual Page 42 e Legal amp Regulatory Driver Data Entry Sheet The legal amp regulatory data entry sheet is intended for situations involving trespass relocation requests etc BF Microzolt Face PETWFILE WLS Enter thee fod bow reg D scrpton oi Pazar u6 possible consequence H nothing Estimated cost F havand occurs Ce fi Hine project dots mot proceed Sport the probability of tie Parad occurring durie the mai yea De mpen Wary Lik ey Lech lirikat viy Unik iy LJ LI L O Legal amp Regulators Orieer Riek Gogl kih ze Project Priority ladica of O O
22. as shown in Figure 15 will be displayed Note that when an evaluation is saved to the database the record is permanent unless otherwise deleted using the database function buttons Oe the database file is also saved when the evaluation is written to the database file PROJECT E YALUATION TOOL AN THE PROJECT EYALUATION HAS BEEN SAYED TO THE DATABASE Click on the OF button to continue Project Evaluation Tool User Manual Page 18 Figure 15 e Program Shutdown e There are several ways of shutting down the program One alternative is using the program function button which is explicitly designed for shutting down the program A button 1s available in each of the data entry sheets and in the database summary e If the one of the buttons in the data entry sheets is selected the program will display a dialog box see Figure 16 warning about saving the current evaluation and providing an option to do so before shutting down the program PROJECT E YALUATION TOOL AN WARRING YOU ARE QUITTING THE PROGRAM If you have not saved this evaluation and wish to do so select the Save button to save the evaluation If you wish to quit the program re i t select the Continue button Continue mue Figure 16 e Jf the Save button is selected in Figure 16 the program will verify that the project ID for the evaluation to be saved does not already exist in the database If a duplicate does not exist the program will sa
23. ata entry sheet change the project id and then save the project After selecting an option above select the OF button Figure 24 If a duplicate project ID is not detected the project data will be saved in the database and a message as shown in Figure 25 will be displayed Note that when an evaluation is saved to the database the record is permanent unless otherwise deleted using the database L 279 I function button 1 e the database file is also saved when the evaluation is written to the database file PROJECT EVALUATION TOOL AN THE PROJECT EYALUATION HAS BEEN SAVED TO THE DATABASE Click on the OF button to continue Figure 25 Project Evaluation Tool User Manual Page 23 After completing the evaluation for a project and if necessary saving the evaluation to the database if the data for another evaluation is to be entered the button should be selected The button will clear all previously entered data and initialize all options to their default values Note that when the clear button is selected a dialog box will be displayed as shown in Figure 26 requesting confirmation to proceed with the clearing operation D Miciasalt Excel ae TE ANE m s FM Soki the Fagin Emi a daae notion tar Pa pec ect Engineer Planner Project Cist ah mee o O Fhe pmid is completed enler drect Genet On kar Pehl be realized la edited lissek pret maNga etc Cescmppbon of berets DOE CT EVALUAT
24. curs Even if the undervoltage occurs only briefly in a day the day should be included Enter the number of customers affected by the undervoltage Project Evaluation Tool User Manual Page 35 As an alternative or in addition to item 5 enter in kVA the load for the customers affected The load is used to determine an equivalent number of customers which is compared to the actual number entered in item 5 the maximum of the two values is used for the number of customers Not applicable to undervoltage power quality problems Project Evaluation Tool User Manual Page 36 Voltage Flicker BF Microzolt Eed PETWFILE WLS ey EI el e Selec the ype of unecceplsols poeer gueli O TTT vermoe 0 underecttiaye El vonage Ficker Harmonies TT wahige imibaiarse niler Feiolkreenp om af 334 Zereun ofetiiaga Akker in parcari Humber of das D r yaar Nkat jia seeren CG joe Humbro cunhimnees afecicd by sella Daf meee ees CG OF Liaj aifoctad GEI lumber af dicks ees por ie EE Ce LOJ Far oia Flicker prob lere select ha ps vi customer affected Beete Gual Dior Risk Cos kiesss2 Project Priority indicated 222222 A Figure 35 will adjust the sheet layout accordingly to display the data required to evaluate the problem For the type of power quality problem identified in item 1 the program will automatically display a target or threshold value The expected flicker value entered in item 3 is compare
25. d be included Enter the number of customers affected by the harmonics Project Evaluation Tool User Manual Page 39 As an alternative or in addition to item 5 enter in kVA the load for the customers affected The load is used to determine an equivalent number of customers which is compared to the actual number entered in item 5 the maximum of the two values is used for the number of customers Not applicable to harmonic power quality problems Project Evaluation Tool User Manual Page 40 e Voltage Imbalance BR Microsoft Ers PETWPRILE 3 Select the ppe o pg piah pragi iil By owerwutage _ Undervottage TT vonage Heche Enter the follovang Empia phate H PAm Wa ees va ep YE bh ete Calculled Se oes es WE Sort Motte Flicker prablemi select tha eps of customer diacen litem or Subar ban Far al O E Power Quality Ciar Risk Cosi kijescscs DU Preject Priority Indicate 7 Identify the type of power quality problem by selecting the appropriate box The program will adjust the sheet layout accordingly to display the data required to evaluate the problem For the type of power quality problem identified in item 1 the program will automatically display a target or threshold value The calculate voltage imbalance value shown in item 3 is compared to the target to verify if a problem exists and to evaluate the severity of the problem which will be reflected in the calculated risk cost value The exp
26. d to the target to verify if a problem exists and to evaluate the severity of the problem which will be reflected in the calculated risk cost value The expected value must be greater than the target value for the program to generate a power quality risk cost The target value is based on the BCH flicker curve Note that the target value may change as items 6 and 8 are entered Enter the expected voltage flicker value in percent that the system or customers will be subjected to without the project completed Enter the number of days per year that flicker events occur Even if flicker occurs only once in a day the day should be included Enter the number of customers affected by the voltage flicker Identify the type of power quality problem by selecting the appropriate box The program Project Evaluation Tool User Manual Page 37 O Enter the number of flicker events that occur on average per day As an alternative or in addition to item 5 enter in KVA the load for the customers affected The load is used to determine an equivalent number of customers which is compared to the actual number entered in item 5 the maximum of the two values is used for the number of customers From the two options available select the box which most suitably describes the type of customers affected by the voltage flicker problem Project Evaluation Tool User Manual Page 38 Harmonics EP Micrasolt Esc PETWFILE WLS
27. e Enter the number of customers affected by the project Project Evaluation Tool User Manual Page 31 As an alternative or in addition to item 5 enter in kVA the load for the customers affected The load is used to determine an equivalent number of customers which is compared to the actual number entered in item 5 the maximum of the two values is used for the number of customers Indicate if essential or high priority customers are involved e hospital critical medical or process load etc If at least one essential customer is involved select Yes otherwise select No Project Evaluation Tool User Manual Page 32 e Power Quality Driver Data Entry Sheet There are five types of power quality that can be considered When the type of power quality problem is selected the program will adjust the data entry parameters appropriately e Overvoltage EF Micrazolt Face PETWFRILE tg Be E3 P Selec the hype of uneccepteole poeer ougl e D erori TT gndessepage Vota Picker TT Harmonica TT vettage trbatance Enter tes following Target is 1A wuts Eapentod meriang value De erte op a 3 20 von bade oo LG 4 Les Liaj sengen ZEshmakd atte Casio perira aniar poiri Far Voie Flicker proble select he bet of cuime affected lirihan or Sauherhan Far al m c Pree Quality Dior Fisk Goal kiesss2 Project Priocity edit Afen Identify the type of power quality problem by selecting the ap
28. ected value must be greater than the target value for the program to generate a power quality risk cost Enter the expected phase to ground voltages Va Vb and Vc in volts that the system or customers will be subjected to without the project completed Based on the values entered in item 3 the program will calculate and display the resultant voltage imbalance in percent Enter the number of days per year that voltage imbalance occur Even if the imbalance occurs only briefly in a day the day should be included Project Evaluation Tool User Manual Page 41 O Enter the number of customers affected by the voltage imbalance As an alternative or in addition to item 5 enter in KVA the load for the customers affected The load is used to determine an equivalent number of customers which is compared to the actual number entered in item 5 the maximum of the two values is used for the number of customers Not applicable to voltage imbalance power quality problems Project Evaluation Tool User Manual Page 42 e Safety Driver Data Entry Sheet e The safety driver data entry sheet is intended for situations involving equipment conditions or failures that pose a safety hazard a Mecrasoll Eecel PETWRILE 15 the project does nod proceed select the probability of egipen falure GOouUTIng dunia he rer yes Diah Wery Likely L heck Unhkik ery Unii Ho Occumence SHer ihe bpe of area where the equpmentf
29. ered directly so the project evaluation can be saved If this option is selected the program will again verify if a duplicate ID exists Ifa duplicate does exist the program will display a dialog box shown in Figure 20 note that the overwrite option will not be available at this stage PROJECT EVALUATION TOOL WARNING THE DATABASE CONTAINS A PROJECT WITH THE SAME PROJECT ID AS THE ONE ENTERED THE PROJECT ID MUST BE UNIQUE II Please select one of the following options IS SAVE WITH A DIFFERENT PROJECT ID C DO NOT SAVE AND OVERWRITE After selecting an option above select the OK button Figure 20 In the event that the first option in Figure 20 is selected but a project ID is not entered the program will display the dialog box shown in Figure 21 PROJECT EVALUATION TOOL WARHING FI THE PROJECT ID CANNOT BE ELAHK PLEASE RE ENTER THE PROJECT ID OR SELECT THE OPTION TO QUIT THE PROGRAM Please select one of the following options RE ENTER THE PROJECT ID C DO NOT SAVE AND OVERWRITE Project Evaluation Tool User Manual Page 22 Figure 21 Project Evaluation Tool User Manual Page 23 Data Entry Sheets For entering data to evaluate a project six data entry sheets are available Data entry will begin with the General Information sheet as shown in Figure 22 this sheet will be the first sheet displayed when a new project is to be entered or when an existing project is to be reviewed or changed The
30. icate project ID exists in the database If a duplicate ID exists the program will display a message and provide options i e for overwriting the database entry or changing the ID The programwill not permit duplicate ID entries The project ID must be unique Project Evaluation Tool User Manual Page 44 Database Summary e The database contains the data entered and calculated results for any project evaluations that are saved using the sxe function button e The information in the database is stored in blocks based on the data entry sheets as shown in Figure 41 Each line of data represents a project evaluation General Equipment Reliability Power Safety Legal amp Priority Information Overload Driver Data Quality Driver Data Regulatory Statistics Driver Data Driver Data Driver Data Figure 41 e Vertical and horizontal scrolling bars are available for accessing the blocks of data see Figure 42 GE Hinos Eoy PETSUMPY XLS Par ES Figure 42 EU Persum Project Evaluation Tool User Manual Page 45 e When scrolling vertically the column titles are frozen or locked so that they always remain displayed e When scrolling horizontally a portion of the General Information Region Project ID Project Description Cost Centre Engineer Planner and Project Cost is frozen or locked so that it is always displayed Project Evaluation Tool User Manual Page 46 e Sorting e The database records can
31. nction Saving Evaluations Program Shutdown Data Entry Sheets General Information Data Entry Sheet Equipment Overload Driver Data Entry Sheet Reliability Driver Data Entry Sheet Power Quality Driver Data Entry Sheet Overvoltage Undervoltage Voltage Flicker Harmonics Voltage Imbalance Safety Driver Data Entry Sheet Legal amp Regulatory Driver Data Entry Sheet Function Button Summary 11 15 16 20 25 26 28 31 31 33 35 37 39 41 43 44 Database Summary Sorting Printing Deleting or Changing a Project Adding a Project Function Button Summary Summary of Steps for Entering a Project Evaluation 45 47 48 49 51 52 53 Project Evaluation Tool User Manual Introduction e This manual is intended to provide information on the use and application of the Project Evaluation Tool PET program Included is information on the program installation procedure the program interface starting the program program function routines how to enter data for a project evaluation how to access the data in the summary database how to display and print results e In an effort to include all related information in a particular section some of the information may appear more that once within the manual Where this has not been practical references to related or pertinent sections are indicated Project Evaluation Tool User Manual Page 1 System Requirements e The Project Ev
32. o the database Sort With the database displayed select the function button to sort the database entries and the Print function button to print the contents of the database Delete Change Use the function button to delete an evaluation or to change the values in an evaluation Add a Use the function button to prepare another evaluation which can then be saved to the Sav database using the data entry function button Shutdown the program by selecting the function button Project Evaluation Tool User Manual Page 53
33. of Excel dialog boxes are used to present information and provide options to the user After the initial opening display showing the program title version number credits etc the dialog box shown in Figure 4 will be displayed followed by the dialog box in Figure 5 The dialog box option in Figure 5 Review the project database can be chosen if project evaluations have been previously entered and saved to the database and the user desires to review these evaluations e for printing changing etc Refer to the section Database Summary for more information if this option is selected Otherwise the option Evaluate a new project should be selected PROJECT EVALUATION TODI PET bjective of this program ir to evaluate the acherred with the dee a To contmue click on the OE button To ext the progam click on the Cancel button Figure Project Evaluation Tool User Manual Page 6 PROJECT EVALUATION TOOL PET x Figure e As shown in the preceding dialog boxes Cancel buttons are provided for returning to the previous menu or dialog box Note that in selecting the Cancel button in the dialog box shown in Figure 4 the program will be shutdown In Figure 5 if the option Evaluate a new project is selected the dialog box in Figure 6 will be displayed The dialog box lists the drivers that can be used in evaluating a project and explains that the first information sheet to be displayed for en
34. other five data entry sheets correspond to the five project drivers which define system problem situations or conditions below the level of desired performance standards The driver data entry sheets can be displayed by selecting the desired sheet tab or by selecting the appropriate scrolling button see Figure 22 Scrolling Buttons BF Mere Excel PE TWFELE 15 A EN Kizir u Select Fe Region C Im Enie a descripton rtia projeti Ze Frajeri Das Cost Gentes Engmean anne Projet Gogi hfj eee Eha prajectis compleied eer direct bennett dn KE that well be realzed ue AGU Be see rop nanieance a lt Dzczgclkon of fenetiz sheet tabs Horizontal Scrolling Bar Vertical Scrolling Bar Figure 22 Project Evaluation Tool User Manual Page 20 Project Evaluation Tool User Manual Page 21 As data is entered into each of the sheets the program determines the associated costs and a value will appear for the Project Priority Indicator PPI Note that the PPI will only appear after the project cost and information for assessing a risk cost have been entered The PPI will be displayed at the bottom of each sheet As more driver sheets are completed the PPI value will change accordingly In addition to the six data entry sheets a seventh sheet labeled Priority Statistics is available for display as
35. pability enter 100 i e 100 Note that the equipment maximum loading capability is the product of the nameplate rating and the percent overload capability Enter in kVA the equipment expected loading for the forthcoming year The value should be the forecast normalized value If the expected equipment load entered in item 4 is due to the occurrence of a system contingency 1 e cable failure line outage etc enter the probability of the contingency Project Evaluation Tool User Manual Page 27 occurring in the next year The probability value must be expressed in perunit Oe between 0 and 1 If a contingency is not involved leave the cell blank interpreted as 1 0 or enter 1 0 If the project is deferred enter the restoration costs in k that may be incurred due to the equipment overload or failure Note that the cost must not be duplicated in any of the other driver sheets Project Evaluation Tool User Manual Page 28 e Reliability Driver Data Entry Sheet BF Muere Excel PE TWAFELE SLS Qutege Des Por ihe Hjalmar Wieb fy the graer eelectine apienenale suisia on be ditking on the ubslebortf Bayan Be biii Substation fm e substation selected Tanai EA g based on sub sialon Herind 222222222 Wid the project the ger Sg Glanz duration per Gusinener GADD ome LG nrs i defeu kode is for tha substebon seleced shoves PAM Petrol eee ame eae ie aoe pet Cuslurteg CAC ex 3 an ksenia or m
36. propriate box The program will adjust the sheet layout accordingly to display the data required to evaluate the problem For the type of power quality problem identified in item 1 the program will automatically display a target or threshold value The expected overvoltage value entered in item 3 is compared to the target to verify if a problem exists and to evaluate the severity of the problem which will be reflected in the calculated risk cost value The expected value must be greater than the target value for the program to generate a power quality risk cost The target value is based on CSA standard C235 Enter the expected overvoltage value in volts on a 120 volt base that the system or Project Evaluation Tool User Manual Page 33 customers will be subjected to without the project completed Enter the number of days per year that the overvoltage occurs Even if the overvoltage occurs only briefly in a day the day should be included Enter the number of customers affected by the overvoltage As an alternative or in addition to item 5 enter in kVA the load for the customers affected The load is used to determine an equivalent number of customers which is compared to the actual number entered in item 5 the maximum of the two values is used for the number of customers Not applicable to overvoltage power quality problems Project Evaluation Tool User Manual Page 34 e Undervoltage rr i
37. r the total direct benefits that will be achieved for the first year of service Any benefit included must not be duplicated in any of the other driver sheet Clearly identify and describe the type of benefits two lines available for entry Project Evaluation Tool User Manual Page 26 e Equipment Overload Driver Data Entry Sheet Mecroralt Eecel PETWRILE XLS O QO pelt he bp o equipenent ane k of feng miha Trinti mer Regulator Reiner Sectanialicer oO Oo Oo O oee Ener he folowing dala tor fe ecuigerenii Hameed ming of ihe Gripp In k Cou i kKagdpgceabifk in oin amgeclae ronn Eaperked pajlaj l om WW cee r ihe hazant dee io sem coningescy Le cable fake line otaga etc enier he probate ts cit ff FOr gen ey Case erry Pee Mel Le pete Dane 1 om prec i deferred erie the emneepency resioraton coe hal sould be incurred due to the hazard ocounng during fie need year kb Equipment Cvarioad Cewer Rik Coat kite Project Priority Indicate gt Identify the type of equipment at risk of being overloaded by clicking on the appropriate box Ifthe type of equipment is not listed select Other and describe the equipment type in the space provided Enter in KVA the nameplate or full load rating of the equipment identified in item 1 Enter the equipment overload capability as a percentage of the nameplate rating If the equipment does not have overload ca
38. shown in Figure 23 The Priority Statistics sheet displays a summary of the calculated costs used to produce the PPI values Note that all benefits and cost entered and calculated are annual costs expected for the forthcoming year S Microsolt Excel PETWRILE SLS Figari fm eer ss e Cosi Cmim Eromgertisoer Papert Cog ioe Frojact Da scripaicm Rise Cost EF Uber Benes Baie nl reece diver reek oa Relatelite di rite d DE 22212222 gt Saey Saree nk EQS mettre teeter rte enn be L ns amp Fraguiatory dever risk LOS wmgsmmssmn r Totali of rik OED mema 2 ee ee Propect Priority Indicator Project Evaluation Tool User Manual Page 22 Once all project data has been entered the data and results can be saved to the database by selecting the ES function button The program will verify that the project ID does not already exist in the database The project ID must be unique If an entry in the database with the same project ID 1s detected a dialog box with options will be displayed as shown in Figure 24 PROJECT E YALUATION TOOL WARNING I THE DATABASE CONTAINS A PROJECT WITH THE SAME PROJECT ID AS THE ONE TO BE SAYED THE PROJECT ID MUST BE UNIQUE II Please select one of the following options OVERWRITE the existing entry in the database DO NOT SAVE AND OVERWAITE return to the project data entry sheet Hote To save the project as a new entry in the database return to the project d
39. t to the PET will also be checked and verified to ensure a valid PPI The Area Capacity Planner makes his her recommendation to the Capital Program Leader During the annual planning cycle September December the Capital Program Leader meets with each Field Service Engineer and Area Capacity Planner to review each project in person The Distribution Engineering Manager Distribution Planning Manager and Strategic Planner may also attend Step 3 Projects recommended by the Area Capacity Planner are reviewed by the Capital Program Leader again Details are reviewed with particular focus on the project description The PPI score is examined as it compares to other projects submitted The project scope and cost are further reviewed Step 4 Projects gt 300k are sent to the Planning Manager for budget approval Projects lt 300k are budget approved by the Capital Program Leader from highest PPI to lowest PPI subject to budget constraints This is done both at a geographic area level and at a total program level Projects with PPI below 10 are unlikely to be funded regardless of budget constraints Field Service Engineers are given an opportunity to make a pitch for one project over another if PPI scores are close Step 5 Engineering completes detailed design and estimate and submits project electronically through the estimating system to the Capital Program Leader for approval Capital Program Leader verifies the project has received budget
40. tering data will be the General Information sheet Project Evaluation Tool User Manual Page 7 PROJECT E YALUATION TOOL PET x Figure Sg Project Evaluation Tool User Manual Page 8 e Upon selecting the OK button in Figure 6 the General Information data entry layout will be displayed as shown in Figure 7 Scrolling Buttons BF Micrerelt Excel PE TWFELE XLS S EH Selec Fe Region _ Enie a description rtia projeti Engr eebisongr x Freri Cost Kipe Eha prajectis compleed ender direct benett dn KE that well be realized e AGU pg see rop rmpmlpeonrg a Uu Dzczgclkon of benetiz Horizontal Scrolling Bar Vertical Scrolling Bar Sheet tabs Figure 7 e The General Information sheet is one of six sheets available for entering data Although there are a total of seven sheets as shown on the sheet tab labels the last sheet labeled Priority Statistics does not require any data entry This sheet provides statistics on the information entered into the other six sheets The General Information sheet should be completed first followed by the entering of data into the other sheets as required The other five sheets in which data can be entered correspond to Project Evaluation Tool User Manual Page 9 the drivers which define system problem situations or conditions below the level of required performance standards While data can be entered into more than one of the driver shee
41. ts for multi driven projects it 1s recommended to first enter data for the driver for which the deviation from the performance standard is the greatest This will provide a quick indication of the relative priority of the project The other driver sheets can be completed if necessary Each of the sheets can be individually accessed by either selecting the appropriate scrolling button or by selecting the desired sheet tab at the bottom of the window For more information on a particular sheet refer to the section titled Data Entry Sheets For all of the sheets including the database summary vertical and horizontal scrolling bars are available and can be used if required see Figure 7 In addition to the scrolling buttons function buttons are available for performing specific operations The function buttons are available on all seven sheets For more information about the buttons refer to the section titled Data Entry Sheets Data is entered into the sheets by selecting the appropriate option box displayed or by typing information into the bordered cells refer to Figure 8 In cases where more that one cell is hi lighted with a border the leftmost cell is the position to select for entering data Where two lines of a block of cells are hi lighted the leftmost cell of the each line can be selected for entering of data Project Evaluation Tool User Manual Page 10 ATERT Feel PE TW FILE X15 Legal Fieg P Stats F
42. ve the evaluation After saving the evaluation information the message shown in Figure 15 will be displayed When the OK button for the dialog box shown in Figure 15 is selected the program will automatically proceed with shutting down the program Project Evaluation Tool User Manual Page 19 e An alternative for shutting down the program is to select click on the window exit button SI in the upper right hand corner of the window being displayed as shown in Figure 17 Note that in Figure 17 there are two exit buttons one for the Excel window and one for the program data entry sheet window Either button can be used to initiate shutdown The exit button for the database summary window can also be used to initiate shutdown Egipti ine Figon ses Ente a descephon for be project Preqec Uess Cost Cen Engien liner Froierl cogi n oe EPa poectis compel eted amer dred berais On kF thaistil be realized e reduced loee6 reduced maintenance atc Demergtion of bere fits Wl aj viel General Figure 17 Project Evaluation Tool User Manual Page 20 e If an exit button SI is selected while a data entry sheet is being displayed the program will display the dialog box shown in Figure 18 PROJECT EYALUATION TOOL IN WARHIHG YOU ARE QUITTING THE PROGRAM If you have not saved this evaluation and wish to do so select the Save button to save the evaluation If you wish
Download Pdf Manuals
Related Search