Home

EconExpert-MAESTRO Electronic Databook User`s Manual

1. A G C 1 EconExpert WIND V14 7060 Copyright 2005 2010 CEI Inc All Rights Reserved i TABLE 6 Revenue and Recoveries Click Here to 2 REFRESH 5 ITC Grant Training Case Mican 4 August 30 2010 5 Total Project Base Year 6 Year of Operation 2010 1 2 3 7 Year 2011 2012 2013 P Months of Operation During Year 2 12 12 14 Effective Annual Capacity Factor of Initial Gross Capacity i 3 5 5 6 34 5 34 5 15 Wind Project Capacity After Losses MW 94 36 94 36 04 36 04 36 16 Calculated Energy Production After Generation Losses MWh PTS 6 484 227 54 035 324 211 324 211 7 Net Energy Delivered After All Losses MWh 6 484 227 54 035 324 211 324 211 18 13 PPA Terms Months Applied During Each Year of Operation Term Years 20 PPA 1 Term 1 Contract 1 15 2 12 12 T PFA 2 Term Contract 2 5 E 2D PPA 3 Term3 0 4 Term 11 01 11 10 31 26 15 Year Term 43 _ 44 Party 1 Full Year 4 663 170 54 035 324 211 324 211 45 Customer 2 s reo eee aioe ee 46 Customer 3 7 Se ee ea ea 47 Customer 4 i ii ean To 45 PPA 1 Total Annual Power Sold MWh 4 063 170 54 035 324 211 324 211 43 PPA Net Electric Sales Price Term 5 years Contract 2 Term 14 04 26 10 34 34 5 Year Term so MWh Figure 95 Revenue Report Generated Using the Results Linking Wizard The Results Import Wizard is an automated tool used to define data in linked models that it is desired to import into the MAESTRO As described prev
2. ITC Grant Training Case NPY Period to Track Year 10 2nd IRRJNPY Period to Track Year 15 3rd IRR NPY Period to Track Year 20 Short Cut A Figure 43 Multi Input Linking Wizard Selection of individual variable b Group of variables in a section Section 2 2 Production Profiles based on MET Data ig Potential Gross Energy Production P60 MWH yr 385 400 l ig Potential Gross Energy Production P75 MWH yr 368 422 Wind Rating Scenario 1 P50 2 P60 3 P75 4 P90 5 P95 6 P99 3B E Potential Gross Energy Production P90 MWH yr 329 748 Potential Gross Energy Production P95 MWH yr 309 963 Potential Gross Eneroy Production PSO MVWH yr i 470 000 Potential Gross Energy Production P60 MVWH yr 385 400 Potential Gross Energy Production P75 MWH yr 368 427 Potential Gross Energy Production P90 MWH yr 329 748 Potential Gross Energ Production P95 MWH yr 309 963 Fotental Gross Energy Froducton F99 MWH Figure 44 Multi Input Linking Wizard Selection of group of variables c All variables or only variables that are already populated Short Cut A Figure 45 Multi Input Linking Wizard Selected of all or only populated variables 3 Use Append to List to insert any highlighted items on the left to the bottom of the list on the right and Remove from List to remove items previously added NOTE Allinputs will be imported into the
3. Next Form Select Cases Exit Wizard Step 1 Click here to select or to change the source file that the reports will be generated From click here to select another File Custom reports can be produced reports can be produced using the right hand section of this form by 1 Selecting the Report to Add 2 Editing the Report using the Wizard to indicate how individual lines in the report should be processed and formatted i e added averaged title row etc and 3 Running the Report EconExpert Electronic Databook User s Manual Page 72 IMPORTANT Please note that when creating custom reports the source report MUST meet the following criteria e Data is oriented in rows e The Titles Data Names and Descriptions for each row of data appears in Column B e Yearly Monthly or Quarterly data must be oriented in columns with the first period of data in Column E and subsequent periods in successive columns to the right e Data must not extend beyond column HY and Columns IA and IB must be available and unprotected Columns IA and IB are where the EconExpert Maestro Data Reporting Wizard will insert indices to establish how to process the data in the report For additional questions regarding how to use this Custom Report Wizard please contact CEI EconExpert Electronic Databook User s Manual Page 73 Saving MAESTRO Spreadsheets During the term of your license you may save and reuse installed copies of fully fun
4. By clicking on the button provided on the bottom of the License Sheet in the EconExpert Model User ACCEPTS or DECLINES acceptance of the terms of this Software License Agreement ifthe License is declined the EconExpert Mode will not be fully installed and should not be used Have Read and DECLINE the t f the f i ACCEPT the terms of the foregoing 1e terms of the foregoing EconExpert Software License Agreement Click Here to Decline and Close Model EconExpert Software License Agreement Click Here to Accept and Enable the Model
5. Electronic Databook User s Manual Page 71 EconExpert Maestro includes an automated wizard that will also allow you to 1 Build a Consolidated Report 2 Show Deltas Between 2 Cases or 3 Show Each Line Item from Each Case These custom reports can be generated by clicking on the Consolidate or Compare Cases button on the Scenario Results Table Wizard When you do this the Consolidate or Compare Case User form is displayed Consolidate or Compare Cases Copyright 2009 2010 CEI Inc All Rights Reserved Step 1 Select the EconExpert EconExpert WIND Proforma 14 7060 8 2010 ob xls Select Add Custom Report Source R workbook to create reports from wo jamal Edit Custom Report Step 2 Select the type of reports you want to process Select All EconExpert Reports Delete A Custom Report Reports E T3 Construction E T7A Cash Aow Unlevered Delete ALL Custom HINTS ET Operating Costs E T9 Sources Uses I Select All Custom Reports E 15 Debt Service W 110 Maintenance r Custom Reports lf 16 Revenues W 111 Book Financials E T Cash How Levered W 112 Dollars per MWH Step 3 What action would you like to perform with the selected reports Step 5 What do you want to name the file es Step 4 Specify the destination folder for the Change final reports Lee Step 6 Discount Rate used for consolidation Po 2 Step 7 Discount Date used for consolidation MMDD YYYY
6. NOTE Results from linked models must be logged in the current spreadsheet by running the Compute Results macros This field shows the last date and time that the Compute Results macro was run for each case e Source Model This is the name of the Target Model that results were computed from e Model Type This is the type of from one of the following Classes EconExpert WIND EconExpert EP EconExpert DG EconExpert PV EconExpert CP EconExpert lAT MAESTRO or Other User Custom Model VVVVVV VV EconExpert Electronic Databook User s Manual Page 57 e Source Description This is the name of the case identified in the source model Global Input Assumptions sheet if applicable e Scenario Description This is the description provided in the Global Input Assumptions sheet e Target Model Version The is the CEI designated Version Number of the Target Model if applicable e Scenario Results Table The Scenario Results Table allows the user to log results derived from Multiple Scenarios into the MAESTRO Since results displayed in the target linked workbooks can only display one result at a time it is necessary to store results from multiple cases on this sheet as values IMPORTANT The Scenario Results Table displays results from Linked Workbooks as values not as updating formulas As a result if input assumptions to a specific scenario are changed the Scenario Results Table MUST be imported in order to be update
7. Notes The title is normiilly located to the left of the data cell you selected fg EconExpert WIND Proforma V Version created last time the 11 24 AM Monday July 26 2 Table 1 GLOBAL INPUTS Green Indicates Input Cells Name of File CaAEconExpett No Annual Inputs Used Description x fxg EconExpert MAESTRO V14 5 Version created last time the 3 25 AM Tuesday August 10 7 a CU e e Ieee S Ti jal Term of PPA a Tz 73 Turbine apd Wind Project Gross Capacity Section 2 a0 a AI ating a2 of Turbines 83 Turbine 2 Rating Bd of Turbines aT Total of Turbines BS Turbine and Wind Project Gross Capacity 53 Average Turbine Capacity Figure 55 Single Custom Input Linking Wizard Select the title of the input cell Once you have selected the title you will be given the option of confirming it or entering it manually EconExpert Maestro Electronic Databook Copy ight 2010 CEI Inc All Ri The description and units identifiers that you have selected for this cell are of Turbines Is that OK If you enter no then you will be prompted to edit this title or to enter an alternate title manually Figure 56 Custom Single Input Linking Wizard Confirm selection of variable The MAESTRO will automatically insert the formula reference in the target input cell and will reformat that cell to pink identifying that a cell has been linked EconExpert
8. Protect Sheet Assumptions Results Table Figure 34 Other macro buttons on the Global Input Assumptions sheet e Refresh MAESTRO Menu The Refresh Menu button is on the top of every sheet of the model This button replaces and updates the MAESTRO menu with a new one linked to that respective copy of the model You can refresh the menu any time This macro button will re enable the model under a valid license and will point the Maestro Menu to the active Maestro model e Unprotect or Protect Sheet The Global Inputs Assumptions sheet is protected but without a password Users can unprotect this sheet by clicking on this button allowing you to reformat cells on the sheet You can unprotect this sheet and reformat cells as desired however it is recommended that you not insert or delete or column s rows on this sheet as such can interfere with the sheets macros If you need to make these kinds of changes please contact CEI and we can provide you with instructions on how to properly make these types of modifications without disrupting the performance of the MAESTRO model Sheets can also be protected or unprotected from the MAESTRO Command Menu e Go to Grid Input Assumptions This takes you to the Grid Input Assumptions sheet which can also be accessed under navigate on the command menu or by clicking on the tab with the same name e Go to Scenario Results Table which can also be accessed under navigate on the command menu or by clicking on the
9. Select the type of reports you would like to use EconExpert Electronic Databook User s Manual Page 62 Step 2 Select the type of reports you want to process Select All EconExpert Reports Reports T3 Construction T7A Cash Flow Unlevered T4 Operating Costs T9 Sources Uses T5 Debt Service T10 Maintenance T Revenues Tii Book Financials T7 Cash How Levered Ti Dollars per MWH Figure 87 Consolidate or Compare Cases Wizard Select type of reports 3 Select the action you would like to perform consolidate compare or show list items Step 3 What action would you like to 1 en perform with the selected reports Build a Consolidated Report Figure 88 Consolidate or Compare Cases Wizard Select action 4 Select the folder in which to save the generated reports Step 4 Specify the destination folder for the C EconExpert Reports Change Dest final reports Folder Figure 89 Consolidate or Compare Cases Wizard Select destination folder 5 Specify the name of the report file Step 5 What do you want to name the file ConsolidatedWindReportAugust Figure 90 Consolidate or Compare Cases Wizard Select name of report file 6 EconExpert MAESTRO will calculate new IRRs NPVs Coverage Ratios etc for the consolidated cases Enter the discount rate to be used for the new calculations Step 6 Discount Rate used for consolidation FFM Figure 91 Consolidate or Compare Cases Wizard S
10. Subscriptions To purchase Maestro or to extend your license please contact Competitive Energy Insight via email or phone Subscription rates are available upon request Subscribers will be provided with software training user support and access to all updates issued during the term of their Software License Prior to using the model all users of the MAESTRO model will be required to acknowledge their acceptance of the MAESTRO Software License Agreement Please see Section IV Getting Started of this manual for additional information regarding the Software License A copy of the License is included on the License Sheet in the model and in the Appendix of this User s Manual If you open EconExpert when your current license is within twenty one days of expiration the model will notify you that your license is about to expire The EconExpert Help Menu includes an automated feature that allows you to extend the period of a license by entering a License Extension Code which can be provided by CEI By contacting CEI and entering the necessary codes your license term can be extended at any time In the event that your installation of MAESTRO experiences problems this feature may also be used to revalidate a current license If you forward copies of MAESTRO to others who do not have an active license CEI can temporarily enable the model as Fully Functional on any computer If others attempt to open a model you have sent them and they are not authoriz
11. ZONEALARM gg Protection Actety y ote status ICI Private Brower D IH Figure 8 Software License Accept continue to registration DAJ iF Deals CEJ iP dvisor 1 Snapfish by HP Web Mice Gallen REGISTER If you select Yes you will be taken to the CEI website to fill in the registration page fr H E met Pages Safety s Tonk i SOFTWARE DEMIS PRODUCTS LPR MAHLALS EOWALOAD TO SUPPRESS HOT EMOUCH SYSTEM RESOURCES MESSAGE SUPPORT REGISTER LOGE if you have a valid Goense bo one ar mere of ihe EconEpert models and hove mot aready registered your daflen Henie complete he brie fone below Bele that simply registering A not enable the so hware on pour cemmuler iL wil ch be aceia y bo gel Beene Codes from CLI bot this wil greatty achitate the licensing Process Tou may clove Ubi browser winder if you have ready registered for more mtormation pease contact CFl at Mj HR eR 0771 The Fd ter mni be enlered eaackly at yom aberar e ix Ce wi be Behe on our congona This Reguired ifori can Ger feud by opening any licensed coy of the Coonixpert model and selecting Econkxpert baip About Doom apert Tron che Loc part cammand memi bregaire fetes Pease check your ftenved produs tsi iF FeonFapert Painerih ni Mace lt EoonmEagert AAESTAO Electronic Dalabaok F Coontepert wind F Foor apari Pi E Deonbogert De for PY S BeanFupert Ce for CHE EoomEagrerl EP F Coont
12. swith Macros Windows EconExpert Maestro Electronic Databook Copyright 200 input GoTo Grid Go To Scenario ona Tab Selection Tab _ Results Table Start Year in Number Format YYYY Scenarios Figure 78 Grid Input Wizard Enter data into table Once all the data is populated select Click to Proceed to Step 7 Match Scenarios with the Correct Cases Step 7 Match Scenarios with the Correct Case i Results Table List of Input Parameters and their Units unis ff After Tax Dividends flow Medium si High Cid ha Variable 2 Variable 3 Variable 4 Variable 5 Figure 79 Grid Input Wizard Select desired scenario for each case On the Grid Selection sheet select the scenario that is desired for each case from the drop down list next to each case Once a scenario is selected for each case Click to Proceed to Step 8 Link Data to an Open EconExpert Model EconExpert Electronic Databook User s Manual Page 55 i T _ Step 8 of Grid Wizard Grid Input Linking Form Copyright 2007 2010 CE Inc All Rights Reserved wi a List of Input Parameters and their Units a After Tax Dividends 24 Variable 2 Figure 80 Grid Input Wizard Select data line Select the data line that contains the scenario selections and then CLICK HERE to proceed to Step 9 and Select the Grid Linking Location On the Annual Inputs worksheet of the linked model select the first data cell i
13. Codes from CEI Once entered the codes will fully enable the use of MAESTRO on that computer for the subject license period Also the MAESTRO does not have the Enable model option however the model will not link to other workbooks and will not assimilate results from other workbooks unless the subject license is valid EconExpert Electronic Databook User s Manual Page 21 Developer Add Ins Ej Conditional Formatting 3 Insert E AF Fo a B Format as Table 3 Delete Sort amp Find amp Cell Styles Ee Format lt 27 Filter Select Styles Cells Editing Refresh MAESTRO Menu Go To Go To Global Input Grid Input Assumptions Assumptions GoTo Scenano Results Table Congratulations You are now ready to use MAESTRO NOTE EconExpert will create the folder C EconExpert Files This is where the now installed model will be saved and where you will also save all other Add Ins to EconExpert such as sensitivity charts and databases where applicable Note also that when you run the models in the future you will be able to rename the models you create and save them to any folder or storage media All will run on the licensed PC Multi License Installation The file name extension on the Multi License Installer MLI file is dxe so that the tool will not be blocked by your firewall In order to use this file it will be necessary to change the extension to exe This file will provide you with
14. Command Menu e Recalculate Any 1 Case This button will direct the MAESTRO to cycle through the selected scenario listed in the Global Input Assumptions sheet and to document and update all of the desired results as values for the scenario included in the MAESTRO e Recalculate ALL Cases This button will direct the MAESTRO to cycle through all of the scenarios listed in the Global Input Assumptions sheet and to sequentially document and update all of the desired results as values for all of the scenarios included in the MAESTRO e Select Workbook to Import Data From The button allows you to select the source file that the reports will be generated from e Consolidate or Compare Cases This option allows you to consolidate the results of multiple cases compare the differences between two cases or show each line item from multiple cases Using the Consolidate or Compare Cases wizard you can use pre defined reports Details on this wizard are described later in this manual The wizard can also be accessed from Electronic Data Book Menu gt Data Management and EDB Import gt Results Reporting gt Consolidate or Compare Cases NOTE The custom report creation feature is not available in the current version of MAESTRO e Goto Global Input Assumptions Tab This takes you to the Global Input Assumptions sheet e Goto Grid Input Assumptions Tab This takes you to the Grid Input Assumptions sheet e Scenario Description This row provides
15. Data Book Menu gt Input and Results Linking Wizards gt Results Import Wizard The example shown here is for linking the capacity input to the EconExpert WIND model but is representative of the procedure followed for any EconExpert workbook Results Import Wizard Form 1 When you select the wizard from any of the options described above the first Results Import Wizard Form 1 will appear EconExpert HELP PRINT ka Refresh eulte Linkine MYSTRO Menu Menu i Select Workbook to EconExpert WIND Proforma V14 7060 20 10 ob xls bh ects Fam Gol 4 z j Global DO NOT MANUALLY ADD OR DELETE R _Assumpti COLUMNS ON THIS SHEET Scenario D fernton a sceonarif tumber Descriptions of Recorded Results g and their Units Figure 96 Results Import Wizard Form 1 5 B Simply click on any cell in a row on the Scenario Results Table that you would like EconExpert MAESTRO to import data into If desired you can allow the EconExpert MAESTRO to find the first empty row that follows the last input on the sheet or you can manually select that row as described above in this paragraph When you have identified the desired row click on the macro button labeled Select the data line on the Scenario Results Table that you want to use and Click Here MAESTRO will log the row number to record results to NOTE As indicated above prior to importing results into the MAESTRO from a Results Workbo
16. E LETITE ETE a Variable 1 fs Variable 2 Variable 3 Variable 4 Variable 5 Variable 6 Variable 7 Variable amp i Existing Grid Variable or Start with a new Variable IA Innit VAsigargA Calart warinhla ar rrasata AALALA la irid Input Wizard Select variable or create new variable If you choose to create a new variable you will be prompted for the name 1 Input the Cigciirn 79 Crie lnnrt Alisard Natfina naw uariahla Figure 73 Grid In put VWizar d Define new variable Next enter a description for each individual scenario you would like to create EconExpert Electronic Databook User s Manual Page 53 NOTE You can create up to 15 individual scenarios Data for each scenario should be entered directly in columns E CU of the Grid Input Assumptions sheet Column E corresponds to the earliest year month or quarter in a scenario with columns to the right representing the next respective period 2 Input he o Descriptions of Each Scenario are a mere Delete Selected Row Figure 74 Grid Input Wizard Scenario descriptions The third step is to specify the time period for the multiple scenario stream 3 Does this input use annual monthly or quarterly values Annu Starting Year 2011 Monthly Starting with Date Monthly or Annual or Quarterly Starting with the value 1 Quarterly Starting on Date Figure 75 Grid Input Wizard Selection of time period NOTE
17. Menu Commands B4 fe 1 A i G F G H 1 EconExpert Maestro Electronic Databook Copyright 2005 2010 CEI Inc All Rights Reserved V 14 54 0 2 Scenario Number Selected Base Scenario 1 i 2 a Unprotect or Protect Sheet Refresh MYSTRO Menu Case 1 GoTo Global Go To 5 Input Asumptions Scenario Results Case 2 7 item Label Base Scenario Values Value _ Deta Delta Vaue Delta xDe 8 IRR Leveraged 0 20 0 20 0 0 0 08 0 12 160 9 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 H n r 0 0 5 2 0 0 Figure 84 Scenario vs Base Case Comparisons The results on this table can be linked to custom sheets added by the user to the MAESTRO together with plots and other information to document results in any custom format that Excel can accommodate EconExpert Electronic Databook User s Manual Page 61 e gm Ileingw thn fnncer P atana nr Onmnasaran fi ancnc Aligrnr N Using the Consolidate or Compare Cases Wizard Al The Consolidate and Compare Cases wizard allows you to consolidate the results of multiple scenarios or compare the differences between two cases from a specified source file You can generate pre defined reports or create custom reports by following the steps outlined below Consolidate or Compare Cases Copyright 2009 2010 CE Inc All Rights Reserved Step 1 Select the EconExpert EconExpert WVIND Proforma V14 7060 2010 ob x
18. Please Enter the User Name you would like to use 8 Characters Minimum Your First and Last Name ts an acceptable choice Figure 4 Enter your User Name EconExpert Electronic Databook User s Manual Page 4 EconExpert Maest Please Enter the Name of the Company you work for Energy Production Inc Figure 5 Enter your Company Name 7 The greeting screen appears acknowledging successful extension of the license EconExpert Installer Copynght 2007 2009 CEI Inc All Rights Reserved Hello John Roberts of Energy Production Inc The Current Date is 07 29 2010 Your License Expiration has been updated until 09 30 2010 IMPORTANT NOTE To use EconExpert under this renewed license you must first acknowledge that you have read and accepted the software license by clicking on the button labeled I Have Read and Accept the Terms of the EconExpert Software License Agreement located at the end of the software license Figure 6 MAESTRO greeting screen 8 Click OK 9 The License Agreement acceptance screen appears please read the terms of the license carefully and then select Have Read and I ACCEPT the EconExpert Software License EconExpert Electronic Databook User s Manual Page 5 econExpert MAESTRO V14 54 0 6 2 2010 ob Compatibility Mode Microsoft Excel non commercial us Home Insert Page Layout Formulas Data Review View Developer Add Ins w Electronic Data Book Menu w Menu Commands a a IMP
19. Select annual to specify years starting with the first year of the earliest case Select monthly to specify a date to begin a monthly table Other options include quarterly or a generic type that could be either quarterly monthly or annual but starts with a 1 instead of a date The fourth and final step is to select Submit data and navigate to the spreadsheet to input the data strips directly 2a Sie eee Figure 76 Grid Input Wizard Submit variable data Next you will be prompted for the preferred number formatting of the scenario data EconExpert Electronic Databook User s Manual Page 54 Step 5 Declare Formatting Copyright 2010 CEI Inc All Rights Reserved Instructions First highlight the range on the sheet you want to format and select the preferred number formatting Note If desired you can protect the sheet and format manually from the Excel Menu Number 0 No Decimal Places Currency 0 No Decimal Places Percent 0 No Decimal Places Number 0 0 One Decimal Place Currency 0 00 Two Decimal Places M Percent 0 00 Number 0 00 Two Decimal Places Number 0 000 Three Decimal Places Click to Proceed to Step Click to Go Back to Steps 1 4 i a Select the Grid Variables Figure 77 Grid Input Wizard Select number formatting Select the appropriate format and then Click to Proceed to Step 6 Enter the Scenario Data You will then enter the data into the table A b aa J os
20. a 6 digit code Contact CEI by telephone at 858 566 0221 and provide the code We will then provide you with a 6 digit response code to finalize the installation on your computer Save the Multi License Installer as it can be used later to repair your installation should a problem arise EconExpert Electronic Databook User s Manual Page 22 Competive Energy Insight Inc 858 566 0221 waw CElnsightcom Info CEInsight com EconExpert Multi License Installer Provided Originally to inita Ramnani of for CEI Support Only Par EP WIND PY CP DG DGPY IAT lATW IATP ES EDB through 9 30 2010 Contact CEI at 8581 566 0221 for Codes Please provide the following Access Code to CEI 421296 CEI will then provide you with a License Code to 123456 Enable your EconExpert License Install EconE xpert Cancel Hotice EconExpert is protected by copyright law and international treaties Unauthorized use reproduction or distribution may result in severe cryil and criminal penalties and will be prosectued to the maximum extent possible under the law rir rr Copyright 2006 2006 Competitive Energy Insight Ine All Rights Reserved A EconExpert Electronic Databook User s Manual Page 23 The MAESTRO Command Menu MAESTRO includes a Custom Command Menu that in Excel 2002 or 2003 appears on the Excel Menu Bar to the right of or below the Excel s menu Help Option In Excel 2007 2010 the EconExpert menu
21. a common folder so that you can most easily maintain the integrity of the linked workbooks When linking from single inputs to the Global Input Assumptions sheet the formula format that EconExpert Maestro uses is as follows OFFSET Top Left Corner of Data Table Line Number on Global Input Assumptions Sheet Case Number where the path and filename are surrounded by square brackets 4 the sheet name and cell address are separated by an exclamation mark and the path filename and sheet name are surrounded by single quotes Using this technique inputs listed in the MAESTRO can be continuously linked or joined to other workbooks that the MAESTRO is linked to These links can be automatically established using the Maestro Global Input Wizards or can be set up manually by copying and pasting the correct formula into any unprotected cell in an Excel Workbook Hazards to be Aware of When Linking Workbooks IMPORTANT Some hazards to be aware of when linking workbooks Inputs entered in the MAESTRO will only be refreshed in a target workbook when the target workbooks and MAESTRO are opened at the same time Changes made to target workbooks that are linked to the MAESTRO should only be made when then linked MAESTRO is also opened otherwise it is possible that links between the models can be corrupted IMPORTANT When renaming linked workbooks be sure that the links are updated in all of the related
22. but without a password Users can unprotect this sheet by clicking on this button allowing you to reformat cells on the sheet You can unprotect this sheet and reformat cells as desired however it is recommended that you not insert or delete or columns or rows on this sheet as such can interfere with the sheets macros If you need to make these kinds of changes please contact CEI and we can provide you with instructions on how to properly make these types of modifications without disrupting the performance of the MAESTRO model Sheets can also be protected or unprotected from the MAESTRO Command Menu e Grid Input Wizard The Grid Input Wizard guides you through the setup of the Grid Input Assumptions and Grid Selection Sheets This option will be described in detail e Reformat a Range This allows you to select a range of rows and reformat the data e Goto Global Input Assumptions Tab This takes you to the Global Input Assumptions sheet e Go to Grid Selection Tab This takes you to the Grid Selection sheet e Go to Scenario Results Table This takes you to the Scenario Results Table sheet e The Grid Selection Sheet The Grid Selection sheet allows you to assign alternative scenarios that have been linked to other models Grid Inputs are typically associated strips of Annual Quarterly or Monthly Scenarios where the objective is to associate alternate streams of data to different cases The following is a screen shot of the Grid Select
23. of the current annual subscription fee for one user that was most recently paid by Licensee This limitation of liability shall apply to all claims made by Licensee or its affiliates without regard to which other provisions of this Agreement have been breached or have proved to be ineffective 11 Copyright Notice The Model and accompanying documentation are protected by copyright law and international treaties The Model and accompanying documentation include copyright notices prominently displayed in the Model on reports generated and produced by the Model and in the User s Manual Use of the Model outside of the License term is expressly prohibited For information regarding the Model please contact Competitive Energy Insight Inc 12025 Blue Diamond Cout San Diego CA 92131 Telephone 8538 566 0221 Fax 558 566 0287 Email Info CE Insight com Website http www CE Insight com EconExpert Electronic Databook User s Manual Page 4 12 Jurisdiction This Agreement shall be governed by and interpreted in accordance with the laws of the State of California without reference to its rules on conflicts of laws The sole jurisdiction and venue for any litigation arising out of this Agreement shall be an appropriate federal or state court in California San Diego County 13 Entire Agreement This Agreement and any other addenda hereto that have been signed by CEI and Licensee contain the entire Agreement between the parties h
24. or Protect Sheet The Grid Selection sheet is protected but without a password Users can unprotect this sheet by clicking on this button allowing you to reformat cells on the sheet You can unprotect this sheet and reformat cells as desired however it is recommended that you not insert or delete or column s rows on this sheet as such can interfere with the sheets macros If you need to make these kinds of changes please contact CEI and we can provide you with instructions on how to properly make these types of modifications without disrupting the performance of the MAESTRO model Sheets can also be protected or unprotected from the MAESTRO Command Menu e Grid Input Wizard The Grid Input Wizard guides you through the setup of the Grid Input Assumptions and Grid Selection sheets This option will be described in detail e Update Grid References This updates the references made to the variables and their associated scenarios from the Grid Input Assumptions sheet e Link Grid Inputs This updates the data from the selected case on the Grid Selection sheet to the Annual Inputs sheet of the linked model e Reformat a Range This allows you to select a range of rows and reformat the data e Goto Grid Input Assumptions Tab This takes you to the Grid Input Assumptions sheet e Go to Scenario Results Table This takes you to the Scenario Results Table sheet Using the Grid Input Wizard Select Grid Input Wizard to setup the Grid Input Assumptio
25. represents a unique Variable that can be linked Each row represents a Scenario associated with that Variable that can be selected corresponding to a Case in the Grid Selection sheet The individual case to populate linked workbooks can be selected by entering the number of the case in Cell D1 in the Global Input Assumptions sheet EconExpert Electronic Databook User s Manual Page 48 The following is a screen shot of the Grid Input Assumptions sheet and a description of the individual controls a A EE or Reformat a Scenarios Coven of sii ha Bo Po ho Pm mee mete fs ete ce es ck REN Belalai e TI igure 65 Grid Input Assumptions sheet 3 Figure 66 Selected Case Number e Case Selected in Global Inputs Assumptions Sheet Cell E1 in the sheet shows which scenario is currently selected in cell D1 of the Global Input Assumptions sheet This determines the individual case used to populate linked workbooks Pe Unprotect or Reformat a i Go To Scenario IAESTRO Menu E e Tep Spee Sete Results Table Figure 67 Other macro buttons on the Grid Input Assumptions sheet e Refresh MAESTRO Menu The Refresh Menu button is on the top of every sheet of the model This button replaces and updates the MAESTRO menu with a new one linked to that respective copy of the model EconExpert Electronic Databook User s Manual Page 49 e Unprotect or Protect Sheet The Grid Inputs Assumptions sheet is protected
26. selected as yet Select OK and the following dialog will be displayed NOTICE The Batch Input Linking Wizard ts currently pointed to a model that is not open in Excel Please select one of the options below Select a File to Link to that is Already Opened in Excel Open a New File to Link To Figure 39 Multi Input Linking Wizard Link to new file or one that is already opened Click on Open a New File to Link To if you want to link to an unopened model or click on Select a File to Link to that is Already Opened in Excel in order to a currently open model EconExpert Electronic Databook User s Manual Page 36 Batch EconExpert Global Input Linking Wizard Copyright 2010 CEI Inc All Rights Reserved Select Inputs From EconExpert to Model in Maestro Databook WARNING No Model Linked Please open a target workbook and select it Enter the Source Model that you want to Import Results from Cancel The BATCH EconExpert Global Linking Wizard consists of the following steps 1 Select a model you would like to import data from and the following dialog will be displayed Batch EconExpert Global Input Linking Wizard Select Inputs From EconExpert to Model in Maestro Databook 1 Select A Model Current Model EconExpert WIND Current File Name 2 Select Input Sections one at a time then select section variables to link Ignore Blank Fields Select All Listed Below Section
27. tab with the same name This takes you to the Scenario Results Table sheet Run SINGLEICUSTOM Input Linking Wizard Run BATCH EE GLOBAL INPUT Linking Wizard Figure 35 Linking Wizard buttons on the Global Input Assumptions sheet e Run SINGLE CUSTOM Input Linking Wizard This option allows you to link individual inputs from any spreadsheet to the electronic databook one at time This feature is described in detail in the following section s and can be used to link to any input in any spreadsheet e Run BATCH EE GLOBAL INPUT Linking Wizard EconExpert Electronic Databook User s Manual Page 33 This option allows you to link batches of variables to the located in EconExpert Global Inputs Sheets to the electronic databook This feature is described in detail in the following section s This Wizard is preconfigured to recognize all of the Global Inputs in the various EconExpert Financial Models e Scenario Name Each populated column in the Global Input Assumptions Sheet MUST be assigned a Scenario Name This name is used by the MAESTRO to designate labels for the respective scenarios Add Row s Delete a Row Reformat a Range Hide Unused Rows Show ALL Rows Figure 36 Row management buttons on the Global Input Assumptions sheet e Adda Row s When adding a row please make sure that the linked worksheets are open Also save the updated databook and worksheets e Delete a Row When deleting a ro
28. the terms of this Acreement If you can not agree to the terms of this Agreement please press the DECLINE button below and destroy the software and all accompanying items including printed materials and packaging if applicable l Description of the Model The EconExpert EFlectronic Databook is an add in spreadsheet designed to assist users with the managing and comparing scenarios developed in other EconExpert Models The Electromc Data Book requires the installation and use of Microsoft Excel for which Licensee must possess a valid license Licensee and Licensee s authorized users of the Model must use software and hardware that satisfy the minimum requirements specified in the EconExpert LP Model s User s Manual 2 License Rights This Agreement provides Licensee with a limited nonexclusive nontransferable license right to install and to use the FconExpert EFlectronic Data Book on specific desktop and laptop computers in combination with valid licenses to one or more of the tools in the FconExpert suite of models which include EconExpert DG EconExpert IAT EconExpert WIND and EconExpert LP Authorized Computers and to distribute the EconExpert Electronic Databook to others for Viewing Purposes Only Neither Licensee nor its Authorized Users may sublicense assign or transfer the license granted hereunder to any third party and any attempt at any such sublicense assignment or transfer is void Licensee and its Authorized Users may n
29. to be Fully Functional on a new user s computer by obtaining the proper License Extension Codes from CEI which can be provided to new Authorized Licensees as described when the Model is opened on an unauthorized computer in the EconExpert HELP Menu and in the EconExpert LP User s Manual 0 3 Reserved 0 4 Sharing of Printed Reports Generated by the Model The Model includes preprogrammed algorithms accessible through the Model s Command Menu that will generate printed copies of reports which contain only the values generated by a specific case and contain no formulas capable of analyzing other cases with the Model Users may share with third parties such printed Values Only copies of the Model that have been generated using macros that are accessed by the Model s Command Menu No other form of printed copies may be shared with third parties who do not have a current and valid license to the Model All such printed copies shall include the EconExpert trademark and copyright notices as provided by CEI m the Model and on all reports generated using the Model 10 Limitation of Liability Inno event shall Competitive Energy Insight Inc its owners employees affiliates representatives or assigns be lable for indirect incidental consequential special or punitive damages or for loss of profits or sales in connection with the use ofthe Model In addition CET s total aggregate lability to Licensee under this Agreement shall not exceed the amount
30. 4 Append gt to List gt lt Remove lt from List Short Cut A Select All Populated Variables in All Sections Short Cut B Select All Variables in All Sections Help Copyright 2010 CEI Inc All Rights Reserved 3 Add or remove variables from vour list Cancel and Close EconExpert WIND Proforma V14 7060 2010 ob xbk Section 4 Economic Factors List of All Variables to be Linked Section 4 Economic Factors Base Year YYYY 2010 Discount Date MM DD YY 07 01 10 GMP Escalation Rate 2 5 Discount Rate for Leveraged 10 0 Discount Rate for Unleveraged 8 0 Interest Rate on Escrowed Funds 6 5 0 Income Taxes and Investment Tax Credits Grants Enter TRUE for Cash Grant FALSE for ITC 1 Federal ITC 30 0 Federal ITC applied to of Capital 95 0 Federal ITC Date Realized 12 31 2011 State ITC State ITC applied to of Capital Step 1 Click here to select the model you want to create reports from The name and type of model will be displayed to the right nput LINK iS WIZdiG CICC VdlidDICs 2 The variables you want to list in the databook can be selected using several methods a Individual variable in a section EconExpert Electronic Databook User s Manual Page 37 Section 1 1 2nd IRR NPV Period to Track Year 15 Case Description
31. ARTICULAR PURPOSE OR THAT THE MODEL OR THE RESULTS THEREFROM SHALL BE ERROR FREE CHECK YOUR WORE THE RESULTS GENERATED BY THIS MODEL ARE YOUR RESPONSIBILITY 6 Techmeal Assistance Licensee and its Authorized Users shall be entitled to 30 days of free techiuical assistance applied only to the mstallation and use of the Models which will be provided via phone Internet or e mail dwmeg the first 30 days of an mitial subscription period Technical assistance beyond this 30 day period or any on site technical assistance shall be provided at the discretion of CEI and may be billed to chent at CEI s then current consulting rates for technical assistance EconExpert Electronic Databook User s Manual Page 3 7 Installation of the Model The electronic software provided by CEI under this Agreement will be subject to a limited installation period after which the software provided may not install properly on the User s Computer s Ifappropriate CEI can provide replacement electronic copies of the software during the period of this Agreement with a new authorized period of installation S Inputs Examples and Derivative Works The Model includes sections that have been designated as Unprotected where Authorized Users may input data or may perform custom analyses using the results generated within the Model both of which analyses and generated results are defined as and described in this Agreement as Derivative Works Users may only ma
32. EconExpert MAESTRO Messages and Warnings Enable All EconExpert MAESTRO Messages and Warnings Use this option to toggle the appearance of certain messages such as Welcome Enable Model Warnings License Expiration etc e Enable MAESTRO Module EconExpert Electronic Databook User s Manual Page 27 Use this option to enable the MAESTRO content after the model is saved EconExpert Electronic Databook User s Manual Page 28 Worksheet Tabs Tabs at the bottom of the spreadsheet identify the various worksheets and tables in the MAESTRO model All can be accessed from the Navigate feature on the MAESTRO Command Menu Worksheets are organized into the following categories Administrative Inputs Results Reporting Analysis Administrative Sheets These sheets provide the user information about the model holding bins and other information that support the use of the model e MAESTRO License The License Sheet provides the Software License Agreement MAESTRO may only be used under the terms of the applicable License Agreement and the user must acknowledge their acceptance of those terms in order to enable the model The terms of the software license should be read carefully BEFORE using the model Prior to the first use of the model the user must accept the license agreement by clicking on the button labeled I Have Read and Accept to the Terms of the MAESTRO License located at the end of the License Agreement e Title Sheet T
33. Electronic Databook User s Manual Page 45 You will then be returned to the Global Input Assumptions sheet in the MAESTRO and asked _EconExpert Maestro Electronic Databook Copyright 2005 2010 CEI Inc All Ri Do you want to enter the current input value 65 for the current variable that was in EconExpert WIND Proforma V14 7060 2010 ob xls cell Table 1 Wind Global Inputs DS82 as the scenario input for Casel In EconExpert MAESTRO Figure 57 Custom Single Input Linking Wizard Base Case Assumption EconExpert will advise you of the current value of the Target Input i e 65 Wind Turbines and ask you if you want to use that same value for the base Scenario Select Yes if you want to accept it and that value will be entered for Case 1 in the MAESTRO An input box will appear asking you to provide the name and units for the target input cell Enter the name of the cell and units of the cell that you want to link to Next MAESTRO will ask if you want to link the same input to another workbook EconExpert Maestro Electronic Databook Copyright 2005 2010 CEI Inc All Ri W Do you want to use from the EconExpert MAESTRO Global Input Assumptions Row 9 asa link to another workbook Yes Mo Figure 58 Custom Single Input Linking Wizard Link to another workbook If you select Yes then you will be prompted to select the input cell in the other workbook EconExpert Electronic Databook
34. Expert will now load 5 The installation of MAESTRO will proceed MAESTRO will be saved to your C EconExpert Files Settings for use of the model will be initiated Next the following screen will appear EconExpert Installer Copynght 2007 2009 CEI Inc All Rights Reserved Hello John Roberts of Energy Production Inc The Current Date ts 07 29 2010 Your License Expiration has been updated until 09 30 2010 IMPORTANT NOTE To use EconExpert under this renewed license you must first acknowledge that you have read and accepted the software license by clicking on the button labeled I Have Read and Accept the Terms of the EconExpert Software License Agreernent located at the end of the software license Figure 19 Copyright screen NOTE Please read this Copyright Notice carefully Note that this screen will also advise you of the current date and on what date your license to use the software will expire 6 Select OK NOTE The Recalculation Feature on Excel will be set to Automatic This is the recommended setting for MAESTRO A notice about providing copies of MAESTRO to others will be displayed 7 Select OK 8 MAESTRO will be initialized In the upper left hand corner of the spreadsheet the message will appear MAESTRO is Initializing Please Wait The Initialization Procedure will occur every time that you open the model MAESTRO will automatically check its setup to ensure that all of its internal settings are set
35. F ss After Tax XIRR Mid Year SENSITIVIMES ue o o e ECES Umeveraged gec 10 64 workbook Figure 97 Results Import Wizard Form 2 MAESTRO will then ask you for the label and units of the target Result Data EconExpert Electronic Databook User s Manual Page 67 Table 1 GLOBAL INPUTS Green Indicates Input Cells Name of File C EconExpert Files No Annual Inputs Used Description TERM USED FOR After Tax AIRR Mid Year SENSITIVITIES i Project Schedule Seq Choose Fiscal or Calend Enter Parameter Description and Units K starts Jan 1 Start Date of Discount G Endar MMDD YYY No of Months Until Com Commercial Operation S47 Project Life Years 321 Retirement Date ERR Leveraged 4 Figure 98 Results Import Wizard Select description and units NOTE The specific result will not be populated in the Scenario Results Table at this time Data is populated into the Scenario Results Table in batch form all results for a single case or all results for all cases The wizard is used only for the purposes of setting up the results fields that the user wishes to document in the MAESTRO You will then be returned to the Scenario Results Table in the MAESTRO and MAESTRO will insert the correct Formula Link for the input into column B You will then be asked if you want to link repeat the process and to import another result Error EconExpert Electronic Dat
36. ORTANT PLEASE READ THE TERMS OF YOUR SOFTWARE LICENSE Print License See Bottom of Sheet to Accept By clicking on the button provided on the bottom of the License Sheet in the EconExpert Model Use ACCEPTS or DECLINES acceptance of the terms of this Software License Agreement If the License i declined the EconExpert Model will not be fully installed and should not be used Have Read and ACCEPT the terms of the foregoing EconExpert Software License Agreement Click Here to Accept and Enable the Model DECLINE the terms of the foregoing EconExpert Software License Agreement Click Here to Decline and Close Model Figure 7 EconExpert MAESTRO license agreement 10 The next screen confirms your license and gives you the option of registering your software NOTE You can choose to register the software at this time by selecting Yes If you would prefer to register at a later time you can do so by selecting Add Ins gt Electronic Data Book Menu gt Software Licensing and Registration gt Register Your Software EconExpert Electronic Databook User s Manual Page 6 _ Please Register Your Software Software License Accepted If you have not done so already please register your software with CEI If you have already registered your license and have not changed the Name or Company Name on your installation you can skip this step Do you want to continue with the software registration 11 ee
37. S i Restart your computer Settings for Windows 7 Similar in Vista See note at end of Section Select Start Button Select Control Panel In the Search Control Panel box on the top right enter User Account Controls Hit Enter Click on the text on the left titled Action Center Change User Account Control settings Drag the slider down to Never Notify IMPORTANT Windows will tell you this is Not Recommended CEI does not believe that this introduces any substantive risks to your computer but if you ot a Pe E should be aware that you do this at your own risk What you are doing here is authorizing yourself to have the rights to install software on this computer This slider must be set to and remain in the setting Never Notify for EconExpert to open and function properly EconExpert Electronic Databook User s Manual Page 11 Choose when to be notified about changes to your computer User Account Control helps prevent potentially harmful programs from making changes to your computer Tell me more about User Account Control settings Always notify lt Never notify me when Programs try to install software or make changes to my computer I make changes to Windows settings i Not recommended Choose this only if you need to use programs that are not certified for Windows 7 because they do not support User Account Control Never notify Ps ZS os EEE Figure 11 Control Panel User A
38. User s Manual Page 46 Select the Input Cell that you want to link to in ANOTHER Workbook CLICK HERE Notes 1 TA EEA kbook use Nine 4 option on the Excel Menu Figure 59 Custom Single Input Linking Wizard Selection of cell in another workbook If you select No then the MAESTRO will ask you if you want to link another Input Figure 60 Custom Single Input Linking Wizard Link a New Input If you select Yes then the Wizard will repeat the process from the beginning If you No the Wizard will close in this case yielding the following input in the MAESTRO which shows in input assumption of 65 Wind Turbines for Case 1 for the Number of Wind Turbines The process can be repeated for up to 400 inputs Go To Grid Input Go To Scenario MAESTRO Menu Protect Sheet Assumptions Results Table 5 Do Not Manually Add or Delete Rows Scenario Number General Instructions gt cenario Name gt Run SINGLECUSTOM Input Linking Wizard ee eee a Scenario Name in Each Run BATCH EE GLOBAL INPUT Linking Wizard Scenario Used Please Read These Instructions gt HOTE The Input Wizard is Currently Pointed to the File before ao these features eli HO EconEzpert WinhD Proforma 14 7060 2010 HO_zis Figure 61 MAESTRO Case 1 populated with of Turbines EconExpert Electronic Databook User s Manual Page 47 Turbine and Wind Project Gross Capacity Section 2 Turbine 1 Rating 1 of Turbines Turb
39. WIND three hypothetical cases are presented These cases are intended only for the purposes of illustrating the methodology of using the MAESTRO and do not necessarily represent a practical or meaningful result Recall that the cases loaded into the Global Input Assumptions sheet were as follows k a 7 h J m i HT r n T g a z ag om i as a 1EX AEST RO V14 54 0 2010 ob Compatibility Mode un Home Insert Page Layout Formulas Data Review View Developer Add Ins mii HE Ruler Formula Bar al pe a Split J View Side by 5i a Gridlines Headings i Hide EH synchronous Si Page Fage Break Custom Full Zoom 100 Zoom to New Arrange Freeze wae Layout Preview Views Screen _ Message Bar Selection Window All Panes __ Unhide 14 Reset Window Workbook Views Show Hide Zoom B9 Hof Turbines Window General Instructions gt Scenario Name gt Run SINGLECUSTOM Input Linking Wizard Tou MUST Entar a Scenario Name in Each Scenario Used NOTE The Input Wizard is Currently Pointed to the File HO EconEzpert WwiND Proforma 14 7060 27010 Figure 101 Results Import Wizard Assignment of Inputs Results calculated for these cases can be logged by Clicking on the macro button located in cell F3 of the Scenario Results Table Recalculate ALL Cases Or Clicking on the Electronic Data Book Menu gt Data Management and EDB Import gt Results Reporting gt and th
40. __Model the Future the Future a Xpert f vesso Maestro OZA Competitive Energy Insight Inc Universal Financial Models EconExpert MAESTRO Electronic Databook User s Manual Published September 29 2010 Competitive Energy Insight Inc 12025 Blue Diamond Court San Diego CA 92131 858 566 0221 T 858 566 0287 F info CElInsight com www cCElnsight com Notices Copyright Notice The EconExpert MAESTRO Electronic Databook MAESTRO and its accompanying documentation are protected by copyright law and international treaties The MAESTRO model documentation and reports generated by the model include prominently displayed Copyright Notices Unauthorized use modification reverse engineering reproduction or distribution of the MAESTRO model or any portion of it may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under the law All users are required to comply with the terms of the Software License Agreement included with the model Changing Your Computer s Clock If you make changes to the setting of the clock on your computer particularly if you set the clock backwards after you have installed MAESTRO or forwards beyond the end of your authorized license period an error will be produced when the MAESTRO model is opened While Excel can be closed and reopened normally MAESTRO will not function properly if it is reopened after such invalid clock s
41. a Book Copyright 2005 2008 CEI Inc All Rights Reserved x Do you want to link another result Figure 99 Results Import Wizard Link another result Select Yes to repeat the process to log additional results to be imported Select No to end the process and to prepare for the data import In this case logging only the IRR will yield the following result in the MAESTRO EconExpert Electronic Databook User s Manual Page 68 AAESTR 14 54 2010 ob Compatibility Mode Ai oft Exc vercial L q g Pee Sa ia Side p uaj Synchronous Scrolling New Arrange Freeze oz Save Switch Selection Window All Panes C Unhide Reset Window Position Workspace Windows 7 a Lt Ruler Formula Bar Gridlines Headings Page Page Break Custom Full Layout Preview Views Screen _ Message Bar Workbook Views C E Refresh aeee Linking MYSTRO Menu Wizard EconExpert WIND Proforma V14 7060 2010 ob xis mamaria onto coro Protect Sheet hey i Cone Global Input np DO NOT MANUALLY ADD OR DELETE ROWS OR TE or Assumptions Tab Assumptions Tab Rang ALL Cases Scenario Number Number 1s Descriptions of Recorded Results and their Units IRR Leveraged eS Figure 100 Results Import Wizard Logging Results EconExpert Electronic Databook User s Manual Page 69 Importing Results into the MAESTRO You are now ready to import and document results into the MAESTRO model For the selected case using EconExpert
42. afe to disable macros but if the macros are legitimate you might lose some Functionality Enable Macros More Infa Figure 12 Microsoft Excel Enable Macros Screen Excel 2007 2010 If you are using Excel 2007 2010 in order to properly access EconExpert please do the following 1 Open Excel 2007 2010 2 Select the Office Button on the top left corner of your screen 3 Select the button labeled Excel Options on the bottom right of the dialog box EconExpert Electronic Databook User s Manual Page 13 Recent Documents Send I E Excel Options OX Erit Excel Figure 13 Excel Office Dialog screen select Excel Options 4 Select the check box Show Developer tab in the Ribbon on the Popular tab Change the most popula options in Excel Proofing Top options for working with Excel Formulas Save Show Mini Toolbar on selection D Enable Live Preview Advanced n Show Developer tab in the Ribbon i Customize Add Ins Trust Center Resources Figure 14 Excel Options gt Popular select Show Developer tab in the Ribbon EconExpert Electronic Databook User s Manual Page 14 5 Select OK 6 Under the Developer tab select Macro Security 7 D a Map Properties p Import N Ss GA View Code pa Expansion Packs lt r Export Insert Design Mode l Run Dialog Refresh Data Figure 15 Developer gt Macro Security 7 Select Disable all macros
43. apert CF SERVE A Deonboert 1 7 for CHP S feon eper T far PY EconEaperAT fur WHO Figure 9 Software registration page on the CEI website D Your iame John Roberts Company Energy Production Inc S imal A Gdress mha robes Gennngy production cam Phone Humber Ezi 123 456 7850 T111 Comment or Special intiructhons htemet Protected Mode GH ii 12 The next screen confirms the completion of your installation and gives you the option of viewing a tutorial NOTE You can choose to view the tutorial at this time by selecting Yes If you would prefer to view the tutorial at a later time you can do so by selecting Add Ins gt Electronic Data Book Menu gt MAESTRO Help gt Tutorial EconExpert Electronic Databook User s Manual Page EconExpert Maestro Electronic Databook Copyright 2005 2010 CE Inc All Ri Congratulations the installation has been successfully COMPLETED Would You Like to View the EconExpert MAESTRO Tutorial No Figure 10 Installation complete continue to tutorial 13 MAESTRO will initialize and be ready for use Other previously saved copies and versions of MAESTRO will also open during the new license term System Requirements MAESTRO is a Microsoft Excel spreadsheet that has been complemented with sophisticated Visual Basic macros to add flexibility and functionality While the spreadsheet will work effectively with a wide variety of computer hard
44. ccount Control Settings screen set to Never Notify 7 Close the Control Panel 8 Restart you computer NOTE In Microsoft Vista the equivalent setting is to unselect the User Account Control Checkbox 4 Make the appropriate changes to Excel as directed below based on the version of Excel you are using Excel 2002 2003 IMPORTANT MAESTRO must be run with Macros Enabled Microsoft Excel Versions 2002 and later include a Security Setting that can prevent the user from opening spreadsheets that contain macros If this Security is set to HIGH then you will not be permitted to open MAESTRO with Macros Enabled 1 Prior to opening MAESTRO you may want to check this setting on your version of Excel To do so select Tools gt Macro gt Security from the Excel Command Menu EconExpert Electronic Databook User s Manual Page 12 2 On the Security Level Tab the settings selection should be MEDIUM or LOW The MEDIUM Setting will continue to provide you with the warning message concerning spreadsheets that contain macros 3 Open the extracted xls MAESTRO file with Excel Also it is recommended that no other worksheets be opened when you are installing MAESTRO If your security level setting is set to MEDIUM as discussed above Microsoft Excel will now provide you with a warning which is similar to Microsoft Excel Ed C Econ Expert Financial Model v2 0 8L5 contains macros Macros may contain viruses Itis always s
45. correctly when you start work EconExpert Electronic Databook User s Manual Page 17 9 EconExpert Electronic Databook User s Manual Finally another important message advising you that prior to using the model you must acknowledge that you accept the terms of the Software License Agreement This is required to enable MAESTRO s linking of calculations You will be required to acknowledge your Agreement with the Software License each time you install the model on an authorized computer and each time you renew your license to the model If desired you may print the license by clicking on either of the Print License buttons at the top of the Screen If you read the license on your monitor be sure to scroll down the screen and read ALL of the applicable license terms A copy of the MAESTRO Software License is also included in the Appendix to this User s Manual At the conclusion of the Software License you will be provided with the option to ACCEPT or DECLINE the MAESTRO Software License Agreement READ THIS LICENSE CAREFULLY as by accepting it you will be legally bound to its conditions PLEASE NOTE THAT THE MODEL WILL NOT FUNCTION PROPERLY UNLESS YOU CHOOSE TO ACCEPT THE AGREEMENT A26 z f EEAS E ae ee eee eee 1 IMPORTANT PLEASE READ THE TERMS OF YOUR SOFTWARE LICENSE ae The EconExpert Electronic Data Book by Print License Competitive Ene Insi Inc SOFTWARE LICENSE AGREEMENT 7 15 Indemnification Lice
46. cssecccsssccccsecccesececescecceseceeenececsecessenceseesecessuecessuaceesuaess i Use of MAESTRO with Macros Enabled icinccacteccsictscyarceutsscsesnteonnsanthactiatesewieaisncsensieeonsantbassbeheeueese i Product Warranty and Warranty Limitations ssesseseessseesssereseresseressereserrserresrersseressereseereseerss ji OVENY EWN io is ioe cis cw E E TEE E E E EE E T E E 1 TIPO CUI OM p EPAIA EA AA E A T E A A A E E N A E A T 1 SUD SCIOTO 1G eea NE E EENE A ETE NEET 2 LICENSE EXCISION aerer erias r a nE E EEEE OER 3 SVStem REgUIeMmMeNTS ssrin EN TEE PRE EA T E EA AT RAA 8 HAO WATO cotar AEn a E E EEA A E E E AAA ATE AE A 8 SO WNO a E E E E E E E 8 Getting Started Installing MAESTRO ccccscsccscscccsccscsccccccscsccscecscsceccecscncescececscesescecces 10 Sne License NSE AION sess camea arsravccecdncscasansodeanaventacassoasasecancsaniseneinansuaniaossesavesaranesanseeentserreen 10 Multi License Installaatio Mennes EEEE sesuaananednpotencseauanacaraosseameusees 22 The MAESTRO Command Menu sesesesesesssesesecssesssscesssssesececececesesesssecscesesececesesesessseseseses 24 Enable MAESTRO Electronic Databook cccescccsssecccssececesceceesececeecesauecessuneeeeeaeceseuseesseaess 25 PA IE Soares cia cn 6 E E E A E E E yaa A E A EAT 25 Input Linking and Results Reporting WizardS ccccccssecccessecceesececesececaueceeseseceeeaecesaueeeeseaees 27 Data Management and MAESTRO IMport ccccccssecccsecece
47. ctioning MAESTRO models as you would save any other Excel Spreadsheet To do so simply use the Excel Save or Save As selections on the Excel Command Menu The Spreadsheets you save will only work on computers that have authorized installations of MAESTRO If a saved copy of MAESTRO is provided to other parties who do not have a valid license they will be prompted to contact CEI to obtain License Codes to enable the model By entering these codes the models you send them can be fully enabled and users who receive and license MAESTRO from files shared by others will experience the same full functionality of the model as you will IMPORTANT The copyright provisions of your license expressly prohibit you from providing your original Installation Copy of MAESTRO to others Your name and license number are stamped on the model If you have multiple instances of the model opened the menu can be synchronized with the active version by selecting the Refresh Menu button that appears at the top of each sheet Customizing MAESTRO One of the many advantages of MAESTRO is the flexibility it offers allowing you to accurately custom model virtually any project You can insert a new sheet into the model To do this right click on any of the Sheet Tabs and select Insert Worksheet from the Excel right click menu NOTE Be careful not to create Circular Calculations using these approaches CEI also provides financial modeling and model customizati
48. d and so to reflect any input changes The method for updating the Scenario Results Table is provided below IMPORTANT Inthe current version of the MAESTRO while inputs in the MAESTRO can be linked to several workbooks results for the Scenarios listed in the MAESTRO must reside in a single workbook This means that when accessing several workbooks from the MAESTRO results must be consolidated into a single workbook for logging in the MAESTRO This will be explained further below H16 oa fe A c D E F G J K EconExpert Maestro Electronic Databook Copyright 2005 2010 CEI Inc All Rights Reserved V 14 54 0 i Refresh Add Results Linking MYSTRO Menu Row s Wizard Select Workbook to Import Data From Unprotect or Delete a Recalculate GoTo To Protect Sheet Row Any 1 Case Global Input rid Input Consolidate or DO NOT MANUALLY ADD OR DELETE ROWS OR Cana Assumptions Tab Assumptions Tab COLUMNS ON THIS SHEET Reformat a Recalculate pa 5 Range ALL Cases Cases Scenario Description oa 6 7 a E E ed ee ee es ee ee ee ees es ee ee ee Descriptions of Recorded Results 8 and their Units 3 Figure 82 The Scenario Results Table Key Sections of the Scenario Results Table are described below e Name of Results Workbook EconExpert Electronic Databook User s Manual Page 58 Cell C3 on the Scenario Results Table provides the name of the single Results Workbook that a copy of the MAESTRO can impo
49. databook as values Any formula links will be converted into their current values Figure 46 Multi Input Linking Wizard Append variable to list or remove variable from list EconExpert Electronic Databook User s Manual Page 38 4 When you are ready to populate the Global Input Assumptions worksheet with the selected variables click on this button If there are already inputs listed in the Global Input Assumptions sheet the following dialog will be displayed There are already inputs listed in the Global Input Assumptions Sheet Select to CLEAR All Current Entries to APPEND the New Entries to the bottom of the List or to INSERT or REPLACE the data into a selected case leaving data in other cases unchanged IMPORTANT NOTE if you select Option 3 data for all other cases MUST already be in the correct rows on the Global Input Assumptions Sheet to ABORT the linking process and check current inputs Data will be imported to Databook as Values Figure 47 Multi Input Linking Wizard Selection of variable placement Select the appropriate option and click OK Note that Option 1 will clear all current data on the Global Input Assumptions Tab Options 2 and 3 will allow you to add input data from an existing model to input data already present in Maestro either below or to the right or existing inputs IMPORTANT NOTE When adding data please be aware that all data in any row on the Global I
50. ectly link that cell and the third option will allow you to to check each cell individually and to decide whether or not to directly link it to Maestro or not Once the linking is completed the following dialog will be displayed EconExpert Electronic Databook User s Manual Page 40 en p r 05 2010 CEI Inc All Ri i The Electronic Databook has been successfully linked to EconExpert WIND Proforma V14 060 2010 ob xls The current data in the model ts loaded in Scenario 1 IMPORTANT NOTES 1 Remember that you may want to Lock the cells in the linked workbook to avoid accidentally overwriting the links You can do thes from the UTILITIES MENU in the Linked Workbook If you do accidentally overwrite a link it can be re linked using the Single Custom Input Linking Wizard 2 It is also very important to note that all inputs will be imported into the databook as values Any formula links that you have previously established in Global Inputs in the linked model have been converted to their current values Figure 49 Multi Input Linking Wizard Linking successful to specified scenario Select OK The following screen shows Case 1 of the Global Input Assumptions sheet populated with values from the chosen workbook P z P r m FE er ea Section 4 Economic Factors gt to List gt Base Year YYYY 2010 Discount Date MM DDYYY 07 01 10 GNP Escalation Rate 2 5 Disc
51. ed they will be advised how to contact CEI to obtain the needed codes Without these codes unauthorized copies of the model will not function properly Once the authorized codes are received from CEI and entered copies of MAESTRO will function on the authorized computer during the authorized license period EconExpert Electronic Databook User s Manual Page 2 License Extension 1 From the Electronic Data Book Menu gt Software Licensing and Registration select Extend your License Codes Required from CEI 2 The following screen appears STOP HERE A current license to the EconExpert MAESTRO Electronic Databook can be obtained by entering codes provided to you on the phone by CE Inc If your installation has become corrupted you may also repair it using this option To authorize a license please provide the following information to CEL Original Licensed User John Roberts Current Expiration Date 09 30 2010 Computer Clock Setting 07 29 2010 4 13 PM Your Access Code 81018 Notice This spreadsheet is protected by copyright law and international treaties Unauthorized use reproduction or distribution of this spreadsheet or any portion of it may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under the law Figure 1 Information for obtaining authorization code from CEI 3 Contact CEI by telephone at 858 566 0221 and provide the requested information from the above
52. elect new discount rate 7 EconExpert MAESTRO will calculate new IRRs NPVs Coverage Ratios etc for the consolidated cases Enter the discount date to be used for the new calculations Step 7 Discount Date used for consolidation MM DD YYYY Figure 92 Consolidate or Compare Cases Wizard Select new discount date 8 Continue by selecting Next Form Select Cases EconExpert Electronic Databook User s Manual Page 63 Figure 93 Consolidate or Compare Cases Wizard Go to select cases 9 The next screen will prompt you to select the cases to consolidate compare Consolidate or Compare Step 5 Copyright 2009 2010 CEI Inc All Rights Reseved O o EconExpert WIND Proforma V14 7060 2010 ob xis Report Mode Build a Consolidated Report Number of Reports 1 Step 8 Select cases to be used Select All Cases E iv eee S 15 Case 15 iv 2 Case 2 Case 16 V 3 Case3 Case 17 4 case 4 v 18 Case 18 5 Case5 Case 19 lv Ceres iv 20 Case 20 lv 7 Case7 Case 21 iv 8 Case 8 9 Case 9 E 10 Case 10 M 11 Case 11 iv 12 Case 12 lv 13 Case 13 14 Case 14 Back to Previous Form hich cases to perform the report on Note that if you are running a comparison ONLY TWO CASES should can be selected i EE Figure 94 Consolidate or Compare Cases Wizard Select cases 10 Select Run Reports to generate the Revenues Table EconExpert Electronic Databook User s Manual Page 64
53. en selecting Compute an Individual Results Case To import and document results for only the current selected Scenario into the Scenario Results Table EconExpert Electronic Databook User s Manual Page 70 Compute All Results Cases To import and document log results for all of the indicated scenarios into Scenario Results Table IMPORTANT In all cases the results will be imported and updated as values such that when alternative scenarios are selected on the Input Assumptions Sheet the respective results will not change If inputs for any scenario are later changed the results must be updated by this procedure in order to be current The example below shows how the IRR for the project life will be documented when the Compute All Results Cases macro is executed GA tal ata Ms econExpert MAESTRO W14 54 0 6 oo Home Insert Page Layout Formulas Data Review View Developer Add ins EconExpert HELP PRINT k LITILITIES NAVIGATE wy Electronic Data Book Menu vw SENSITIVITIES 7 ENABLE WIND MODEL Menu Commands Refresh MYSTRO Menu EconExpent WiIND Proforma V14 7060 27010 ob xls Unprotect or Clete Recalculate Protect Sheet tO Any 1 Case DO NOT MANUALLY ADD OR DELETE ROWS OR COLUMNS ON THIS SHEET Scenario Description M 1 a a 2 i a 3 C Scenario Number Number 4 2 Descriptions of Recorded Results and their Units Figure 102 Results Import Wizard Import of Results EconExpert
54. ereto with respect to the subject matter hereof and supersede any and all prior understandings correspondence and Agreements oral or written between the parties with respect thereto No change amendment or modification of this Agreement shall be valid or binding upon the parties unless such change amendment or modification shall be in writing and duly executed by both parties 14 Survival In the event of termination or expiration of this Agreement the obligations of Sections 3 Termination 5 Warranty 10 Limitation of Liability 11 Copyright Notice 12 Jurisdiction 15 Indemnification and 16 Attorneys Fees shall survive such termination or expiration 15 Indemnification Licensee shall indemnify defend and hold CEI harmless from any and all third party claims demands suits and actions alleging injury to persons damage to property or other loss or lability resulting from Licensee s use of the Model l Attorneys Fees The prevailing party in any dispute mediation arbitration or litigation concerning this Agreement shall be entitled to receive from the other party its attorneys fees and costs Incwred in connection therewith 17 Successors and Assigns Subject to the prohibition on Licensee s assignment this Agreement and all of the provisions hereof shall be binding upon and inure to the benefit of the parties hereto and their respective successors and permitted assicns
55. es demand load profiles hourly ambient weather conditions and facility operating characteristics EconExpert MAESTRO m an Electronic Databook for integrated analysis of multiple scenarios or projects based in your own custom models or in EconExpert Models With this tool users can perform tasks like consolidation of multiple projects into portfolio analysis providing consolidated expense debt revenue and book and cash financial statements and develop comparisons of complex and distinct scenarios contracting analysis and risk analysis integrating one or more of the EconExpert models described above For the calendar year 2010 CEI is providing the MAESTRO Databook for free with any subscription for 2 or more of the EconExpert models above Most features of the EconExpert Partnerships and EconExpert MAESTRO will work with your own in house custom models or with any of the EconExpert Project Financial Models described above The following is a schematic of the software suite The EconExpert Modeling Suite For All Renewable or Fossil Project Investment Analysis Vertical Project Partnership and Interval Models Financial Models Leasing Modules Electric Power Wholesale Wind EconExpert EconExpert Solar Photovoltaics IAT for WIND WIND Solar Thermal EconExpert Land Fill Gas Natural Gas PV Clean Coal IGCC EconExpert Nuclear Power Electric Power Retail Behind the Meter EconExpert EconExpert Sma
56. ettings have been made If you encounter a problem related to the setting of your computer clock as it relates to MAESTRO please contact CEI to discuss measures to repair your valid installation of the model Use of MAESTRO with Macros Enabled In order to properly install and use MAESTRO the Macros Enabled option for Microsoft Excel MUST be selected The model will not function properly without Macros Enabled Microsoft Excel Versions 2002 and later include a Security Setting that can prevent the user from opening spreadsheets that contain macros If this Security Setting is set to disallow macros then you will not be permitted to open MAESTRO or any other spreadsheet with the Macros functioning Prior to opening MAESTRO you may want to check this setting on your versions of Excel and Windows Specific settings for Windows Vista Windows 2007 and later may also be required for installation of EconExpert on your computer Please contact CEI regarding these settings EconExpert Electronic Databook User Guide Page i Product Warranty and Warranty Limitations Read the Software License Agreement SLA which is included as Click Wrap with the EconExpert models You are bound by the terms of the SLA As indicated in the SLA User s of MAESTRO and all EconExpert projects indemnify Competitive Energy Insight Inc against any and all problems damages liabilities or claims or other violation that might arise in association with any use o
57. ew Developer Add Ins w Electronic Data Book Menu vv 7 ee Se 1 General aac Scenario Name gt Run SINGLECUSTOM Input Linking Wizard Tou MUST Enter a Scenario Name in Each Scenario Used Please Read These Instructions gt NOTE The Input Wizard is i Currently Pointed to the File before using these features dd Rows Delete a Row Jefi ta Rangi NO EconEspert WIND di Ii F i Shows i a I Proforma 14 7060 2010 Figure 33 Selected Scenario Input Cell the column with the Selected Scenario is highlighted in yellow e Selected Case or Scenario Cell D2 in this sheet shows which scenario is currently selected Each column in the Global Input Assumptions Sheet represents a Case or Scenario This determines which group of inputs is currently populated into the spreadsheets that are linked to the MAESTRO When you change the entry in this cell the respective Case Number Column in the MAESTRO will highlight in yellow indicating that that is the selected scenario and the associated linked inputs will be updated to reflect that scenario This is the only sheet where the user can select or change the active Scenario number Other sheets reflect this cell by reference EconExpert Electronic Databook User s Manual Page 32 e Scenario Number Row 5 in the sheet lists the respective scenario numbers each column representing a different scenario Refresh Unprotect or Go To Grid Input Go To Scenario MAESTRO Menu
58. f the MAESTRO model by the Licensee Competitive Energy Insight Inc makes no warranties or representations with respect to the accuracy or fitness for purpose with respect to the use or application of the model except that Competitive Energy Insight will make reasonable efforts to correct defects in the model after they are identified and will promptly provide paid Licensees with updates containing such corrections when they are available These reasonable efforts to correct defects in the model do not apply to Derivative Works developed by Users of the model CEI assumes no responsibility for or obligation relative to the performance of or defects in Microsoft Excel EXCEPT FOR THE WARRANTIES AND REPRESENTATIONS EXPRESSLY SET FORTH HEREIN COMPETITIVE ENERGY INSIGHT INC DISCLAIMS ANY AND ALL WARRANTIES AND REPRESENTATIONS EXPRESS OR IMPLIED WITH RESPECT TO THE MODEL AND ITS CONFORMITY TO ANY SPECIFICATIONS OR DESCRIPTION INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY FITNESS FOR A PARTICULAR PURPOSE OR THAT THE MODEL OR THE RESULTS THEREFROM SHALL BE ERROR FREE The SLA shall take precedence over any references to terms referenced in this document EconExpert Electronic Databook User Guide Page ii CONTENTS NOCES inc cparctencsecsevacensneevapecsavavennstecenesresiesvateswoneenereseansenachanhecasensnss cussion toasasariseneneversesusenonsetes i COPAS NUNOC oirir E E E A i Changing Your Computer s ClOCK ccc
59. hat will require users to update to the newest version V14 of EconExpert Maestro and all other EconExpert Models tis STRONGLY recommended that you import work from all prior versions of EconExpert Maestro into this latest Version 14 54 0 to maintain forward compatibility Older versions can be archived and you will be able to access them under a valid license but they will NOT be forward compatible with the new functionality After importing it may be preferable but not mandatory to delete older versions to avoid confusion The import can be accomplished using the UTILTOES Import Data option on the EconExpert Maestro Menu which will guide you through the import process If you have questions please contact CEI at 858 566 0221 Do you want to continue to display this message in the future Figure 25 Forward compatibility instructions If you no longer want to view this message select No and the message will be suppressed in all versions of EconExpert on that computer 14 The model has been fully initialized and is ready for use You will now be transferred to the MAESTRO Title Screen NOTE Copies of the spreadsheet will not work properly on computers that do not have licensed authorized installations If you forward copies of the model to others who do not have an active license or you try to use the model on another computer that copy of the model can be enabled by obtaining the appropriate License Authorization
60. he Title Sheet includes the MAESTRO and CEI Logos and notification of the product copyright Contact information for CEI is also provided Clicking on the Logo on the title sheet will link you to the CEI website www CElInsight com e Workbooks this MAESTRO is Linked To This sheet lists all of the workbooks the EconExpert Electronic Databook is currently linked to Input Sheets These sheets enable the user to link workbooks and link formulas in Excel The Global Input Assumptions Sheet The Global Input Assumptions Sheet is the first interface point in the MAESTRO This sheet is used to direct the MAESTRO what individual data inputs you want to send link to other spreadsheets which can include any EconExpert model or your own custom spreadsheets EconExpert Electronic Databook User s Manual Page 29 The Global Input Assumptions Sheet can be populated manually or using the Single or Batch Input Linking Wizards The MAESTRO utilizes Single and Batch workbook linking to associate inputs listed in the MAESTRO with other target soreadsheets The Batch wizards are preconfigured to interface automatically with the Global Input Sheets in the various EconExpert Financial models The Single Inout Wizard can be used to link inputs to any target spreadsheet NOTE In order for Links to work properly the MAESTRO module and all linked workbooks must be simultaneously opened It is highly recommended that you save all linked workbooks and Maestro in
61. he project developer and asset manager is to understand the dynamics phased projects and or portfolios of multiple assets Each individual analysis may have its own transaction specific characteristics including schedules system sizing and performance terms for contracts purchase of feedstocks and sale of products financing project life schedule and other considerations MAESTRO allows the user to roll up analyses of phased or individual transactions into a consolidated analysis providing consolidated data inputs and results EconExpert Electronic Databook User s Manual Page 1 e Side by Side Spreadsheet Comparisons Maestro will also allow you to combine multiple cases that reside in different spreadsheets or cases into a side by side comparison This User s Manual has been developed to assist you in getting started using MAESTRO and to provide supporting documentation in the event that questions might arise as you use it The User s Manual is complemented by Help features in the model and a Tutorial that can be accessed directly from the MAESTRO model s Command Menu As a registered user you can also contact CEI for support anytime you have questions Competitive Energy Insight would greatly appreciate your feedback and comments on MAESTRO and our other software products and we are committed to both updating and improving the models to include additional functionality that is important and valuable to the energy industry
62. ine 2 Rating of Turbines Total of Turbines Turbine and Wind Project Gross Capacity Average Turbine Capacity Figure 62 Linked Model Case 1 Linked cell in pink Alternate assumptions for plant capacity can now be entered in successive columns and the linked Workbook will be populated with the alternate assumptions if that case is selected in the Selected Scenario box per the example below l Ld Refresh Unprotect or Go To Grid Input Go To Scenario MAESTRO Menu Protect Sheet Assumptions Results Table General Instructions Scenario Name gt gt ke as oe Tou MUST Enter Run SINGLE CUSTOM Input Linking Wizard i a Scenario Name in Each Scenario Used Please Read These Instructions gt gt detainee TUE pie iana l Currently Pointed to the File before using these features Add Row ls Delete a Row Reformat a Range NO EconEzpert WiIND Proforma 14 7060 7010 Hide Unused Rows Show ALL Rows List of Input Parameters and their Units Turbine Model Turbine 1 Rating of Turbines Turbine 2 Rating Of Turbines Total of Turbines Turbine and Wind Project Gross Capacity Average Turbine Capacity Figure 64 Linked Model Case 2 Linked cell in pink e The Grid Input Assumptions sheet The Grid Input Assumptions sheet allows you to link Scenarios containing multiple inputs such as Annual Inputs Monthly Inputs Data Conversion Inputs etc to other workbooks Each of the Section Groups below
63. ing A not enable the so hware on pour cemmuler iL wil ch be aceia y bo gel Beene Codes from CLI bot this wil greatty achitate the licensing Process Tou may clove Ubi browser winder if you have ready registered for more mtormation pease contact CFl at Mj HR eR 0771 The Fd ter mni be enlered eaackly at yom aberar e ix Ce wi be Behe on our congona This Reguired ifori can Ger feud by opening any licensed coy of the Geonkapert model and selecting Econkapert raip About Doon apert Tran the Doon part cammand memi bregaire fetes Pease check your ftenved produs tsi iF FeonFapert Paninerih ni Mc lt EoonmEagert AAESTAO Electronic Dalabaok F Coontapert WiMp F Foor apari Pi lt Ceoonbepert D tor PY S BeanFupert Ce for CHE EoomEagrerl EP F Coontepert cP SERVE Looniiqnertial tor CHP S Eeo eper T far PY lt EconEaperAT far WHO fr mo Paget Safety s Took i D Your iame John Roberts Company Energy Production Inc S imal A Gdress mha robes Gennngy production cam Phone Humber Ezi 123 456 7850 Wit Comment or Special Ineirud tear BP bntemiet Prstected Mode GH a 11 The next screen confirms the completion of your installation and gives you the option of viewing a tutorial NOTE You can choose to view the tutorial at this time by selecting Yes This is highly recommended for new users and will take approximately 15 to 20 minutes If you would prefer to vie
64. ink can be broken Good Practices Rule When Using Links Repeating the Important note just above the safest way to ensure that all Links are correctly maintained is to save each of the workbooks twice cycling through the workbooks in sequence i e save workbooks 1 2 3 in order and then save workbooks 1 2 3 in order again Repeating the save in this manner will ensure that all paths and file names are recorded across ALL linked workbooks IMPORTANT Only ONE scenario the selected from the MAESTRO will be populated into a target linked workbook at a time Updating results for multiple scenarios or cases requires running one of the reporting tools included on the Scenario Results Table Cell D1 in the Global Input Assumptions Sheet described below provides the Scenario Number for the current or active linked case Results populated in Linked Workbooks will typically only reflect inputs from that Selected Scenario The Selected Scenario is identified input ONLY on the Global Inputs Assumptions Sheet Other references to the Selected Scenario in MAESTRO are linked to this input location This is described further below Description of Controls The following is a screen shot of the Global Input Assumptions sheet and descriptions of the individual controls EconExpert Electronic Databook User s Manual Page 31 onExpert MAESTRO V14 54 0 6 2 2010 ob Compatibility Home Insert Page Layout Formulas Data Review Vi
65. ion sheet and a description of the individual controls EconExpert Electronic Databook User s Manual Page 50 El Y 5cenario __No Instructions Unprotect or Protect Sheet MYSTRO Menu Selected Case Grid Input Wizard Link Grid Inputs Update Grid References 9 Wariablet o O 10 11 Variable 3 12 Variable 4 13 Variable 5 14 Variable 6 15 Variable T 16 17 Variable 10 49 Wariahlo 44 Figure 68 Grid Selection sheet Instructions Selected Case gt Case Number Figure 69 Selected Case Number e Selected Case List of Input Parameters and their Units ee GoTo Grid Input GoTo Scenario Assumptions Results Table Cell E1 in the sheet shows which scenario is currently selected in cell D1 of the Global Input Assumptions sheet This determines the individual case used to populate linked workbooks This cell should not be modified Refresh Unprotect or MYSTRO Menu Protect Sheet Grid Input Wizard Link Grid Inputs a Reformat a GoTo Grid Input Update Grid References tee PE Figure 70 Macro buttons on the Grid Selection sheet e Refresh MAESTRO Menu EconExpert Electronic Databook User s Manual Golo Scenario Results Table Page 51 The Refresh Menu button is on the top of every sheet of the model This button replaces and updates the MAESTRO menu with a new one linked to that respective copy of the model e Unprotect
66. iously all results imported into the MAESTRO Scenario Results Table must be reside in a single workbook This means that while you can have inputs from the Global Input Assumptions sheet linked to multiple workbooks it will be necessary for you to consolidate all of the combined results that you want to import into the MAESTRO into one file This can be done by setting up one or a series of tables into one of the target models or even in a new and separate workbook as long as they all reside in one file If you have questions about this please contact CEI IMPORTANT The Results Import Wizard sets up results for importing But specific results will not be populated in the Scenario Results Table from the Results Import Wizard Data is populated into the Scenario Results Table in batch form all results for a single case or all results for all cases The wizard is used only for the purposes of setting up the results fields that the user wishes to document in the MAESTRO Prior to identifying any results that will be imported into the MAESTRO it will be necessary to have the MAESTRO opened and to have opened the Results model that you want to import the data from as well as all other spreadsheets that the MAESTRO model has inputs linked to The Results Import Wizard can be initiated by e Clicking on the macro button located in the Scenario Results Table or EconExpert Electronic Databook User s Manual Page 65 e Selecting Electronic
67. its Grants Enter TRUE for Cash Grant FALSE for ITC Federal ITC Federal ITC applied to Figure 51 Multi Input Linking Wizard variables updated In this manner multiple scenarios can be populated from the same or different workbooks Using the Custom Single Input Linking Wizard Use the Custom Single Input Linking Wizard to link to any worksheet one value at a time When you select the Run SINGLE CUSTOM Input Linking Wizard the following dialog appears Enter the Case Number 1 40 that you want to populate the data to Leave Blank to Cancel Figure 52 Custom Single Input Linking Wizard Select target case number EconExpert Electronic Databook User s Manual Page 42 Select the case number you would like to populate with the values from the chosen worksheet and then click OK You will then be prompted to either select the data line you would like to use or for MAESTRO to find an empty row A3 mA oB e SS ls Refresh Go To Grid Input Go Td Scenario MAESTRO Menu _Protect Sheet Assumptions Results Table Do Not Manually Add or Delete Rows ario Number ly i General Instructions gt Scenario Mame gt Tou MUST Enter a Scenaro Name Case 1 in Each Scenario Used Run SINGLEICUSTOM Input Linking Wizard MOTE The Input Wizard is Currently Pointed to the File 4 Run BATCH EE GLOBAL INPUT Linking Wizard Please Read These Instructions gt gt befo
68. k multiple inputs or scenario strips to other workbooks The Grid Input Wizard will guide you through the Grid Input Assumptions and Grid Selections Sheets Examples of scenario inputs include alternative forward price curves escalation curves performance curves etc These types of inputs are typically used in the Annual Inputs Monthly Inputs or Data Conversion Sheets in the EconExpert financial models e Grid Selection The Grid Selection sheet allows you to assign the alternative scenarios populated on the Grid Assumptions Sheet to individual cases that have been linked to other models e List of Scenarios This sheet lists all of the cases or scenarios saved in the current MAESTRO model e Scenario Results Table This sheet is where results from the respective scenarios are documented and accessed from a list of specific results targeted by the user Using wizards the user can select which results to link to Since Maestro is only actively linked to one e Scenario vs Base Case This sheet provides a comparison of any selected case with all of the other cases modeled e Software License Agreement This displays the MAESTRO Software License Agreement User s of the model are obligated to comply with the terms of the Software License Agreement e Title Sheet This is the sheet in the model that includes the blue EconExpert logo The user can obtain CEI contact information and can link directly to the CEI website by clicking on the EconExpe
69. ke changes to the Model in such designated Unprotected areas or by inserting worksheets in the model and such changes are only for the use of Licensees and Authorized Users of the Model CEI provides no warranties relative to such Derivative Works of the Model or relative to Licensee s or Authorized Users application of such Derivative Works Inputs examples and descriptions provided by CEI in the Model are provided for example purposes only and CEI makes no representations or warranties with respect to the accuracy of such inputs examples or descriptions 9 Sharing of Electronic Copies of the Model and Printed Materials Generated by the Model Electronic copies of the Model and printed materials generated by the Model may be generated and shared with third parties ONLY as specified below All Electronic Copies of the Model and Printed Materials must include the original Copyright notices provided by CEI 9 1 Saving of Electronic Copies of the Model Users may make save and reuse electronic copies of the Model as required for use on the Authorized Computers or as otherwise designated in writing by CEI 9 2 Sharing of fully functional Electronic Copies of the Model Users may share electronic copies of the Model with others including third parities who have a cmrent and valid License with CEI for the Model but such Electronic Copies will not work properly on computers that are not Licensed and Authorized by CEI The shared copies can be made
70. license and gives you the option of registering your software NOTE You can choose to register the software at this time by selecting Yes If you would prefer to register at a later time you can do so by selecting Add Ins gt Electronic Data Book Menu gt Software Licensing and Registration gt Register Your Software Page 18 2E Please Register Your Softwa E Software License Accepted If you have not done so already please register your software with CEI If you have already registered your license and have not changed the Name or Company Name on your installation you can skip this step Do you want to continue with the software registration Figure 21 Software License Accepted continue with registration 10 If you select Yes you will be taken to the CEI website to fill in the registration page lt 2 ZOWEALARM g Frotection Actty DA Ste Status C Prate browser iM Snaohch by HP D c F gt coann OEE qa Frome ig 2B Suggerted Sites w ge HP See What Hot ge HP Gimes jE Web Slice Gallery ee i CEs OVEEWIEW SOFTWARE DEMIS PRODUCTS LPR MAHLALS EOWALOAD TO SUPPRESS HOT EMOUCH SYSTEM RESOURCES MESSAGE SUPPORT REGISTER LOGE Figure 22 Registration page on CEI website REGISTER if you have a valid Goense bo one ar mere of ihe EconEpert models and hove mot aready registered your daflen Henie complete he brie fone below Bele that simply register
71. ll Solar PV or Wind IAT for PV Wind MDG for PV Wind Combine Heat and Power e Fuel Cells EconExpert EconExpert IAT for CHP DG for CHP Specialty and Commodity Products tli hihi Ethanol Biodiesel EconExpert Bio Chemicals Hydrogen Sulfur e All Refining Applications Electronic Databook Portfolios Analysis Multiple Scenarios Feonk xpert Partnershops and EconExpert WLAESTRO wall work with your own in house custom models or with amy of the EconExpert Project Financial Models described above Your In House Klodels EconExpert Electronic Databook User s Manual Page 2 IMPORTANT PLEASE READ THE TERMS OF YOUR SOFTWARE LICENSE FconExpert Maestro Electronic Databook Copyright 2005 2010 CEI Inc All Rights Reserved V 14 54 0 z The EconExpert Electromc Data Book by Print License Competitive Energy Insight Inc See Bottom of Sheet to Accept SOFTWARE LICENSE AGREEMENT ead Carefully Before Using his Software Before the installation of this software can be completed you must accept the terms of the License Agreement the Agreement below by clicking on the THAVE READ AND ACCEPT button at the end of this Agreement ff you do not accept the License Agreement terms you are not authorized to use the EconExpert Model This is a legal agreement between you the Licensee either an individual or an entity as the original purchaser and CEI By pressing the ACCEPT button below you agree to be bound by
72. ll rows used or not e List of Input Parameters and Their Units Starting on Row 8 of the MAESTRO is where the user assigns the input categories that the model will link to other EconExpert models In column B the user provides the name of the input and the units it is expressed in In column D the user assigns the assumptions that will apply to each input and scenario Multi and Single Input Linking Wizards IMPORTANT Prior to linking EconExpert MAESTRO Electronic Databook to any other models it will be necessary to have the MAESTRO opened and enabled and to have opened and enabled any copies of other spreadsheets that you wish to link the model to Inputs can be linked manually by copying the formula provided in Cell B1 to any other spreadsheet and then by editing the RN at the end of the formula with the respective Row Number in the Global Input Assumptions Sheet Or links can be established automatically using the Multi or Single Input Linking Wizards The Input Linking Wizards are automated tools used to establish links between the MAESTRO inputs sheet and the respective models you want to link to The Input Linking Wizards can be initiated by e Clicking on the macro buttons located in cell B6 of the Global Input Assumptions sheet or e Selecting the Electronic Data Book Menu gt Input and Results Linking Wizards gt BATCH EconExpert Input Linking Wizard or SINGLE CUSTOM Input Linking Wizard option on the Custom Command Me
73. ls Select Add Custom Report workbook to create reports from L eli Edit Custom Report Step 2 Select the type of reports you want to process Select All EconExpert Reports Deele A sion Repi Reports T3 Construction T7A Cash Flow Unlevered Delete ALL Custom Reports T4 Operating Costs T9 Sources Uses Select All Custom Reports T5 Debt Service T10 Maintenance Custom Reports T6 Revenues T11 Book Financials T7 Cash How Levered T12 Dollars per MWH Step 3 What action would you like to Buid a Consoidated Report perform with the selected reports Build a Consolidated Report ha Step 4 Specify the destination folder for the pg EPSL final reports k Step 6 Discount Rate used for consolidation 0 Step 7 Discount Date used for consolidation MM DD YYYY Next Form Select Cases Exit Wizard Help Step 1 Click here to select or to change the source file that the reports will be generated from dick here to select another file mma OF fAnKncAlAata ne annara Cacac IMAN aapa Figure 85 Consolidate or Compare Cases Wizard 1 Select the name the workbook to use as the source for the reports To change the currently selected workbook click on Select Source Workbook ANITA yA f 1 Step 1 Select the EconExpert EconExpert WIND Proforma V14 7060 2010 ob xls Select Source workbook to create reports from Workbook Loata ar famnarn fiacac Aligard Calart wusanrlrhan ynsolidate or Compare Cases Wizard Select workbook 2
74. n the row of inputs that you want to link to in this case it is 2011 LS E F E i i Step 9 Grid Linking Location Grid Input ng Form Copyright 2007 2010 CH Inc Ite Align Gro Year of Operation Year Operational Months 2012 12 Additional Tax Deductions for non cash income Ent dditive to Table 1 Wind Global Input Applied to State and Federal Taxes S000 E eae ges Federal Production Tax Credits 000 State Production Tax Credits 3000 of After Tax Income Paid as Dividends to Shareholders Entries are additive to Table 1 wind Global Inputs 5 Atter Tax Income Paid as Dividends to Shareholders Entries are additive to Table 1 wind Global Inputs EconExpert Electronic Databook User s Manual Page 56 Report Sheets The MAESTRO includes the following Reports Sheets List of Scenarios This sheet provides a list of all current Scenarios logged in the model Columns in this sheet include c6 ae fi 4 B Refresh o To Scenario MYSTRO Menu A P Tab esults Table 1 Either No Files or Unrecognized Files are L ed in this Database 2 EconExpert Maestro Electronic Databook Copyright 2005 2010 CEI Inc All Rights Reserved V 14 54 0 Figure 81 List of Scenarios sheet e Scenario This column corresponds to the numbers identified in the Global Input Assumptions sheet e Date Logged This is the date that the last results were logged for each scenario
75. nputs Assumptions sheet MUST be assigned to the same variable in a linked model This REFERENTIAL INTEGRITY is critical to the proper functioning of Maestro IF you have questions please contact CEI EconExpert Electronic Databook User s Manual Page 39 IMPORTANT NOTE Cells that are to be linked using the Wizard must have the Protection Attribute set to OFF When electing to link to a model it is possible the input cells you select to link to will have formulas in them i e depending variables In this case it may be that the user would like to leave those formulas intact If any of the selected variables is a formula the following message will be displayed WARNING Dependent Variables Found Copynght 2010 CEI Inc All Rights Reserved Important Warning One or more formulas have been found in input cells of the workbook you are linking to The current cell address with this condition is D 164 with the formula VEAR NOW Please select the appropriate option below Continue AND ont CHECK AND VERIFY EACH REPLACE ALL formula or link formulas or links found as it is found and Relationships will be lost acide link by link Figure 48 Multi Input Linking Wizard Selection of formula linking method Select the first option to replace all formulas or links found with their corresponding values when linking to Maestro The second option to leave all the formulas intact and will not dir
76. ns and Grid Selection sheets you can choose to Exit Wizard at any time EconExpert Electronic Databook User s Manual Page 52 Grid Wizard for Annual or Monthly Inputs Copyright 2010 CH Inc All Rights Reserved Select Existing Grid Variable or Start with a new Variable Select a Variable from the Drop Down List r Create a New Variable 1 Input the a PAER ic Dividends se Descriptions of Each Scenario Low Delete Selected Row Medium High 3 Does this input use annual monthly or quarterly values po 4 Submit data and navigate to the spreadsheet to ee input the data strips directly Monthly Starting with Date Monthly or Annual or Quarterly Starting with the value 1 Exit Wizard Quarterly Starting on Date Help You may start by selecting a variable that is currently listed on the Grid Input Assumptions Sheet These variables are all presented as tithes of the respective sections on this sheet each with up to 15 alternative scenarios assigned to it Figure 71 Grid Input Wizard First select a variable currently defined on the Grid Input Assumptions sheet These are existing titles on the sheet each with 15 possible scenarios If you do not want to use an existing variable you can choose to create a new variable Grid Wizard for Annual or Monthly Inputs Copynght 2010 CH Inc All Rights Reserved lt a 28 f Select a Variable from the Drop Down List TF Or
77. nsee shall indemnify defend and hold CEI harmless from any and all third party claims demands suits and actions alleging injury to persons damage to property or other loss or liability resulting from Licensee s use of the Model 16 Attorneys Fees The prevailing party in any dispute mediation arbitration or litigation concerning this Agreement shall be entitled to receive from the other party its attorneys fees and costs incurred in connection therewith 17 Successors and Assigns Subject to the prohibition on Licensee s assignment this Agreement and all of the provisions hereof shall be binding upon and inure to the benefit of the parties hereto and their respective successors and permitted assigns By clicking on the button provided on the bottom of the License Sheet in the EconExpert Model User ACCEPTS or DECLINES acceptance of the terms of this Software License Agreement If the License is _ declined the EconExpert Model will not be fully installed and should not be used 27 Have Read and DECLINE the terms of the foregoing ACCEPT the terms of the foregoing EconExpert Software License Agreement EconExpert Software License Agreement Click Here to Decline and Close Model Click Here to Accept and Enable the Model ss Ss B 8 4 4 gt EDB License AEH Workbooks this EDB is Linked To InputAssumptions _ lt List of Cases Scen 4 Ready Figure 20 EDD License Agreement The next screen confirms your
78. nu The example shown here is for linking the capacity input to the EconExpert WIND model but is representative of the procedure followed for any EconExpert workbook Using the Multi Input Linking Wizard To link to multiple inputs click on the Run BATCH EE GLOBAL INPUT Linking Wizard macro button on the Global Input Assumptions worksheet or select the Electronic Data Book Menu gt Input and Results Linking Wizards gt BATCH EconExpert Input Linking Wizard menu option If there are no workbooks currently open the following message will be displayed EconExpert Electronic Databook User s Manual Page 35 i r ae EconExpert Maestro Electronic Databook Copyright 2005 2010 CEI Inc All Ri Ee There is no open workbook to link to Please open the target model that you want to link to and then reinitiate the Wizard Note that it s recommened that the Target Model be resident in the same folder that the actrve copy of EconExpert MAESTRO ts in Figure 37 Multi Input Linking Wizard No open workbook notification Click OK and open the model you would like link to EconExpert Maestro Electronic Databook Copyright 2005 2010 CEI Inc All Ri mes _ EconExpert Maestro has not yet been pointed to the workbook that you want to link inputs to On the next form please select whether you want to open a new model or link to a that is already opened Figure 38 Multi Input Linking Wizard Workbook not
79. ok it will be necessary to have the MAESTRO opened and to have opened any copies of other spreadsheets that you wish to link the model to If no appropriate models are opened MAESTRO will advise you that that is the case in which event you should Exit the Wizard and open the appropriate model s The Results Import Wizard Form 2 will appear Results Import Wizard Form 2 EconExpert Electronic Databook User s Manual Page 66 For the first result the user must select the Results Model using the Window option on the Excel menu bar and then selecting the Results Sheet and ultimately the Results Cell On successive passes the MAESTRO will automatically select the correct results Workbook Next the user should select the target cell in the Results Model that it is desired to import from This can be any cell in any workbook Then click on the Select the Data RESULTS Cell that you want to Import Data From and then button Select the target input cell you want to import data from and then click on the button shown above to accept that cell entry Select the Data stent taal arog pl peat mare aay aoe a Click Here Important Note When you REPORT RESULTS All Results must be consolidated from a single Current ses oe is eens WIND Proforma V14 7060 2010 ob xk Gre di l C Name of File rt Filesi EconEspert WIND Proforma Y14 7060 2010 ol 25 r o Annual Inputs U Description a ITC Grant Training Case TERM USEDFOR _T
80. on services For information please contact us at the address shown on the cover page of this manual EconExpert Electronic Databook User s Manual Page 74 Appendices Overview of CEI s EconExpert Software Suite Competitive Energy Insight CEI established in 1997 has developed a suite of mature and highly advanced software products for the analysis of investments in renewable energy central power stations commodity liquid and gaseous products and combined heat and power We both license these models for your direct use and use them broadly in our project development consulting practice serving as a bench to support your in house team All of the EconExpert tools are Excel based making them completely customizable auditable and adding all of the features of Excel to EconExpert s powerful features and architecture Importantly the EconExpert Models are far more than spreadsheets Behind each model is powerful Visual Basic programming that provides highly advanced menu wizard driven functionality taking Excel and your analysis capability to a completely new level Standardized accurate and applicable from simple screening to bank quality investment grade analysis of virtually any project investment acquisition or divestiture EconExpert has been applied to literally billions of dollars of energy project investments including on site generation applications renewable energy projects and large multi hundred million dollar central powe
81. or Compare Cases WIZAIA cscccseseccneeseeesesececeseceeenseeessecssessessenses 62 Using the Results LINKING Wizara iseina AN E 65 Creating New Reports using the Consolidation Compare Wizard ccccccsscseeeeeeeeeeessseeeeees 72 Saving MAESTRO Spreadsheets sesessesessecessecessscecesoecesoesesoecesoecesoscessscoesssoecesoecescesssseseeoes 74 CUSTOMIZING MAESTRO cccscivcacccicciacevcccanccusscacasvansasuevevsaauccacseiscscseuniawancassaseredaaseaveanaeseusnaaseaeis 74 PROC CICS S crain a E tues ncuvenanatcuiun en a N 1 TM Overview of CEl s EconExpert Software Suite cccccccssccccsececessececeseceeseeceseeseceseeecesseecessees 1 MAESTRO SONMWArE LICENS Eisenia atte A A Gustecotates wctesnaneetacwa deus tat carat 3 EconExpert Electronic Databook User Guide Page iv Overview Introduction Thank you for choosing the EconExpert MAESTRO Electronic Databook MAESTRO a member of the family of EconExpert suite of financial analysis tools MAESTRO developed by Competitive Energy Insight Inc CEI a California Corporation with offices in San Diego has evolved as part of the EconExpert modeling suite first introduced in 1997 as a tool first used extensively in CEl s private consulting practice in support of Fortune 500 clients and smaller entities to evaluate opportunities for development and acquisition of energy projects MAESTRO can be used efficiently and effectively by project developers utilities equipment s
82. ot copy distribute modify reverse engineer or create Derivative Works as hereinafter defined except as expressly authorized by this Agreement and the Model Authorized Users are authorized to use the Model only on the computers specified in writing fax or email by CEI and the list of such computers shall only be modified with documented approval by CEI which may be by written agreement fax or email 3 Termination In the event of a breach of this Agreement by Licensee CEI may termimate this Agreement Upon termination or expiration of the term of this Agreement Licensee s and Authorized Users license to the Model shall termimate At the end of the term of this license or upon its earher termination unless this Agreement is extended by a witten faxed or emailed notice provided by CEI Licensee shall destroy all electrome copies of the Model Licensee for itself for its Parents for its Affihates and for its Subsidiaries Licensee and or Affihates hereby agrees and stipulates that m the event that Licensee and or Affihates shall violate the terms of the Agreement Licensee and or Affihates shall be jomtly and severally be hable to CEI and CEI shall be entitled to damages and any and all equitable relef available to it at law or equity Licensee for itself and for Licensee and or Affiliates hereby agrees and stipulates that m the event of a violation of the Agreement CEI shall be entitled to receive appropriate restraining orders and nyunc
83. ount Rate for Leveraged 10 0 Discount Rate for Unleveraged 8 0 Interest Rate on Escrowed Funds 5 0 lt from List Short Cut A Income Taxes and Investment Tax Credits Grants Enter TRUE for Cash Grant FALSE for ITC 1 Federal ITC 30 0 Federal ITC applied to of Capital 95 0 Federal ITC Date Realized 12 31 2011 State ITC Yo State ITC applied to of Capital Percent Reduction to Apply to PTCs of PTC Base Year YYYY 2010 Discount Date MM OD YYYY 07 01 10 GNP Escalation Rate 2 5 Discount Rate for Leveraged 10 0 Discount Rate for Unleveraged 8 0 Interest Rate on Escrowed Funds 5 0 Income Taxes and Investment Tax Credits Grants Enter TRUE for Cash Grant FALSE for ITC 1 Federal ITC 30 0 Federal ITC applied to of Capital 95 0 Federal ITC Date Realized 12 31 2011 State ITC State ITC applied to of Capital EconExpert Electronic Databook User s Manual 4 Finished Adding Variables Continue to Link to Workbook Import Values Figure 50 Multi Input Linking Wizard Selected variables Page 41 Scenario Number Scenario Name gt You MUST Enter a Scenario Name in Each Scenario Used HOTE The Input Wizard is Currently Pointed to the File EconEzpert WIND Proforma 14 7060 2010 obzis tion 4 Economic Facto Income Taxes and Investment Tax Cred
84. password Users can unprotect this sheet by clicking on this button allowing you to reformat cells on the sheet You can unprotect this sheet and reformat cells as desired however all linked sheets should be open when doing so to preserve the accuracy of the sheets macros If you require any clarification please consult with CEI and we can provide you with instructions on how to properly make these types of modifications without disrupting the performance of the MAESTRO model Sheets can also be protected or unprotected from the MAESTRO Command Menu e Add Row s The Add Row s button adds row s to the Scenario Results Table All linked sheets should be open before adding row s You will be prompted for the number of rows you would like to add beginning at the first row in the range allowed by MAESTRO e Delete a Row The Delete a Row button deletes a row from the Scenario Results Table All linked sheets should be open before deleting a row Select the row you would like to delete and then click the Delete a Row button You will be asked to confirm the deletion e Reformat a Range EconExpert Electronic Databook User s Manual Page 59 This allows you to select a range of rows and reformat the data e Results Linking Wizard The Results Linking Wizard is an automated tool for importing results from the Results Workbook Details on this wizard are described later in the User s Manual The wizard can also be accessed from the MAESTRO
85. r station investments For more information on CEI please visit http www CElnsight com where you can view flash demos of our software CEl s financial analysis suite includes the following TM EconExpert Partnerships and Leases for evaluation of Tax Equity Partnerships and certain Leasing Structures based on projects analyzed in your own in house custom models or with any of the EconExpert Project Financial Models described below TM EconExpert WIND for Wind Farm projects that sell wholesale energy TM EconExpert EP for wholesale Electric Power including solar thermal biofuel landfill gas fossil and other thermal based electric power projects TM EconExpert Nuclear for wholesale Nuclear Based Electric Power EconExpert PV for wholesale large solar Photovoltaic projects TM TM TM EconExpert DG EconExpert DG for PV or Wind and EconExpert DG for Solar Thermal are for Distributed Generation Behind the Meter applications utility tariff analysis and energy savings applications TM EconExpert CP for Commodity Products including ethanol biodiesel synthetic natural gas refining and coal gasification liquefaction applications EconExpert Electronic Databook User s Manual Page 1 EconExpert IAT _ EconExpert lAT for py and EconExpert lAT for WIND for Interval Analysis of Combined Heat and Power Photovoltaics and Wind projects Simulate time of production analysis of energy sales as a function of interval energy pric
86. re using these features ee Add Row s Delete a Row Reformat a Range NO Eocene er WIND Proforma 14 7060 2010 Hide Unused Rows Show ALL Rows Figure 53 Single Custom Input Linking Wizard Select empty row Simply click on any cell in a row on the Inputs Assumptions Sheet that you would like EconExpert to use for the respective Scenario Input Assumption If desired EconExpert MAESTRO will find the first empty row for you When you have identified the desired row click on the macro button labeled Se ect the data line on the MAESTRO Global Input Assumptions Sheet that you want to use and Click Here MAESTRO will log the row number RN to place in the linking formula NOTE As indicated above prior to linking MAESTRO to any other models it will be necessary to have the MAESTRO opened and enabled and to have opened and enabled any copies of other spreadsheets that you wish to link the model to MAESTRO will find then find an open workbook to link to If there are multiple workbooks opened it will find the most recently linked model EconExpert Electronic Databook User s Manual Page 43 Next select the target input cell you want to link to and then click on the button shown above to accept that cell entry In this case the user has selected the Number of Wind Turbines at the Site NOTE This can be any unprotected cell in any workbook If MAESTRO has not opened the correct input sheet for you you ma
87. received a previously installed copy of MAESTRO from another user or a copy of the model from CEI that is not configured to automatically install and that you would like to enable that copy of the model using License Codes provided by CEI If this is the case please refer to Section I on Page 11 of the User s Manual for instructions on how to enable any copy of the model on a new user s computer 1 Copy the original installation file onto your C drive preferably into a new folder named C EconExpert Files NOTE Installation of the model MUST be initiated from your C drive 2 Unzip the zip file provided by CEI onto your C drive to the xls version of the file The Initial Installation File you receive from CEI will only enable the use of the model for a limited period usually 10 14 days If you have purchased an extended period license to use the MAESTRO model CEI will provide you with the necessary authorization codes to fully enable your use of the model for the subscribed license period please see the License Extension section for instructions on extending your license 3 Once the installation file has been extracted make the appropriate changes as follows Settings for Windows Vista 1 Select Start Button EconExpert Electronic Databook User s Manual Page 10 Select Control Panel Select User Account Controls Click on the Radio Button to Disable User Account Controls Accept and Close the Control Panel eS S
88. rt logo EconExpert Electronic Databook User s Manual Page 26 Input Linking and Results Reporting Wizards The Input Linking and Results Reporting Wizards are used to link or join MAESTRO with other spreadsheets The Wizards are described later in the User s Manual in detail Data Management and MAESTRO Import As titled the Data Management feature on the menu is used to manage data in the MAESTRO This includes o Deleting old cases purging o Importing of data from earlier versions of Maestro into the newest and latest version and o Reporting of results in the model after respective scenarios are set up using the Wizards Sheet Protection Most of the individual sheets in the MAESTRO model are protected but without passwords These sheets can be unprotected or protected as a group using the menu option They can be individually unprotected or protected using the macro buttons at the top of the applicable sheets Software Licensing and Registration This feature is used to enable or extend your MAESTRO License MAESTRO Help Using this menu you can enable or disable certain EconExpert MAESTRO messages You can also access the tutorial MAESTRO Special Functions Complementing the Command Menu and macro buttons located throughout the model certain features available through EconExpert s Visual Basic can be accessed by right clicking on the mouse The EconExpert MAESTRO Special Functions are e Suppress Certain
89. rt results from The entry in this cell can be entered manually by listing the path and file name of the file that contains results that are to be documented in the MAESTRO or using the Results Import Wizard As described in the note above all results imported into the MAESTRO Scenario Results Table must reside in a single workbook This means that if while you can have inputs from the Global Input Assumptions Sheet linked to multiple workbooks it will be necessary for you to consolidate all of the combined results that you want to import into the MAESTRO into one file This can be done by setting up one or a series of tables into one of the target models or even in a new and separate workbook as long as they all reside in one file If you have questions about this please contact CEI Refresh Add Results Linking MTsTAoO Menu Rowls Wizard Select Workbook to Import Data From Unprotect or Delete a Recalculate GoTo GoTo ect Shee ow a Global Input Grid Input aul i wt SSE Consolidate or Assumptions Tab Assumptions Tab Reformat a Recalculate Compare Range ALL Cases Cases Figure 83 Scenario Results Table macro buttons e Refresh MAESTRO Menu The Refresh MAESTRO Menu button is on the top of every sheet of the model This button replaces and updates the MAESTRO menu with a new one linked to that respective copy of the model e Unprotect or Protect Sheet The Scenario Results Table is protected but without a
90. screen NOTE Response codes provided by CEI must be used immediately as they are specific to your computer s date and time 4 After you have received an extension code from CEI click OK The extension code screen appears EconExpert Electronic Databook User s Manual Page 3 Enter Authorized Extension Code Provided by CEI Usually Three 5 Character Segments Separated by Spaces The Code is Case Sensitive and MUST match exactly KRA RHA AHH KHR Figure 2 Enter the extension code original dialog 5 Enter the 15 18 character code provided to you by CEI then click OK NOTE The License Extension Code is comprised of three sets of 5 character segments each separated by a single space The code is case sensitive and must match the authorized code exactly If it does not match you will be prompted up to 3 times for the correct code All letters must be entered in CAPS Enter Authorized Extension Code Provided by CEI Usually Three 5 Character Segments Separated by spaces The Code is Case Sensitive and MUST match exactly UXAWW 68624 GO060 Figure 3 Enter the extension code provided by CEI 6 Enter your user name and the name of your company and then click OK NOTE The user name is usually your first and last name This name must be at least 8 characters long It will appear on the Program Greeting each time you open MAESTRO The company name will appear on all printed reports generated by the model
91. ssceccesececeeeceseescessesceesenecessuecessenees 2 MEPE UO eRe eee EA ee een ree eee 27 Software Licensing ANG REGIST ATION ccsassssseessscesvarteastacusasas easssnoestsucesvavicusaestsevas eusdsaoeritetedeanedes 27 DOPE STO HO casa ec eee pent E N EA E E E EE 27 The MAESTRO Special Functions sessesessessssecessecesoecescecessecessececosoecsecesesceseesesesoecsesseseseeoeeee 27 WOKSNCEL TADS aoisean EEEE 29 aea EA E lt 1 E E E A E A E ee E ee ee 29 MMAESTRO FCG Carrere senna race ence EEEE EA TAE TEE A 29 I E E og PEE NAE A EEE EA E EA E AEA E ee T 29 e Workbooks this MAESTRO is Linked TO ssscccseseccceseceecesecccesececuseceeenseseasesssseceseseees 29 AROLD SINC E E E E E A E E ese rence A E E 29 The Global Input Assumptions Sheet ccccscecsseseccoseccncnsccccesscccssseneusscceuseceseusseneussess 29 Multi and Single Input Linking Wizards scccccseseccceseccceeseeeceseccenseseausesseusecseausessausesesenseees 35 The Grid Input Assumptions sheli espesie nE EEEE 48 e cae 0 ew cd eC On NOTE en ne Pe N AE EE EEE E 50 USING TNC Grid INDUE WIZGIG vavcv snes snstnentoasendociewaedadeneountxswalndadousesdoesensaeadeneoudeicwaledstersendoesewsberts 52 REDOR ONEC 5c pene oe ee ee ree 57 ISCO SCC TOS aaa E E E E E E E AEN I 57 EconExpert Electronic Databook User Guide Page iii SCCAGTIO RESUITS TODO aruni a a eels ect dave eee ew ees 58 SCCHONOVS BOSC COSC inns r A T 61 Using the Consolidate
92. that while use of the MAESTRO software has been successfully demonstrated with the listed systems the configuration of individual systems or networks might be a factor in the successful installation of this software If problems arise please contact CEI and we can assist you with the installation EconExpert Electronic Databook User s Manual Page 9 Getting Started Installing MAESTRO Single License Installation For licensed users of EconExpert a file will be provided to you by email or can be downloaded with approval codes from our website Note that the installation of the model MUST be initiated from your C drive and the installation file MUST NOT have the READ ONLY attribute selected The original file provided to you will be EconExpert MAESTRO Electronic Databook Installation File V xxx Your Name Your Company zip Installation Copies should ONLY be provided by CEI Inc and under the terms of the License Agreement you are NOT permitted to provide your Installation Copy of the model to others You will only need to open this file one time as an installed copy of the model will be saved you re the directory C EconExpert Files which the model will automatically add to your C Drive EconExpert MAESTRO Electronic Databook User s Manual PDF This User s Manual can be downloaded from the CEI website www CElnsight com as an Acrobat PDF file which can be viewed and printed using Adobe Acrobat It is possible that you
93. the description of each scenario provided in Row 6 on the Input Assumptions Sheet e Scenario Number This row provides the designated number of each scenario e Enter Formula Link to Any Model Leave Blank to SKIP EconExpert Electronic Databook User s Manual Page 60 This column is where formulas are entered that identify for the MAESTRO model where to find the desired result to be imported The formulas in this column are provided as formula links that can be manually entered or can be automatically loaded using the Results Import Wizard Rows left blank can be used as separators between data groups The user can also enter formulas in individual rows that perform custom computations on the Scenario Results Table e Descriptions of Recorded Results and Their Units This column is used to document the names and units of the respective results that will be imported into the MAESTRO Scenario vs Base Case Results against any base case can be compared using the Scenario vs Base Case sheet The desired Base Case scenario is selected by entering the Scenario Number in cell B4 All other cases will be compared against the selected case ACTER OB 4 54 0 6 2 2010 ob Compatibility Mode Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer Add Ins EconExpert HELP PRINT Z UTILITIES NAVIGATE w Electronic Data Book Menu w 7 SENSITIVITIES ENABLE WIND MODEL
94. tions restramimeg and enjomme Licensee and or Affiliates from any and all acts m violation of the Agreement as well as any damages that may be suffered by CEI as a result of any such violation 4 License Fees and Term Fees for use of and the term of license of the Model are on a periodic subscription basis The fees payable under this Agreement have been set forth in a separate written faxed or emailed communication between CEI and Licensee usually by Invoice 5 Warranty CEI makes no warranties or representations with respect to the accuracy use or application of the Model nor any technical assistance provided by CEI to Licensee or Authorized Users except that CEI will make reasonable efforts to correct defects in the Model after they are identified and will promptly provide Licensee with updates containing such corrections as CEI deems appropriate when they are available These reasonable efforts to correct defects in the Model do not apply to Derivative Works developed by Users of the Model and CEI assumes no responsibility for or obligation relative to the performance of or defects in Microsoft Excel EXCEPT FOR THE WARRANTIES AND REPRESENTATIONS EXPRESSLY SET FORTH HEREIN COMPETITIVE ENERGY INSIGHT INC DISCLAIMS ANY AND ALL WARRANTIES AND REPRESENTATIONS EXPRESS OR IMPLIED WITH RESPECT TO THE MODEL AND ITS CONFORMITY TO ANY SPECIFICATIONS OR DESCRIPTION INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY FITNESS FOR A P
95. uppliers consultants banks and others in the industry to evaluate study make informed decisions on structure contracts and track the economics of energy investments The key to MAESTRO and its sister financial models is the architecture which allows you to study any project through the models input sheets Built in menus wizards automated functions sensitivities tornado diagrams graphics and on line help features will further assist you in evaluating opportunities and producing reports that clearly and accurately support the conclusions you reach The MAESTRO is a Master Controller that allows users of EconExpert and any other spreadsheets to perform the following actions e Spreadsheet Management Over time you will accumulate a library of many spreadsheets on your hard drive MAESTRO can be used to consolidate organize and catalogue those spreadsheets and their corresponding inputs e Scenario Analysis In Excel a typical way that many user s perform analysis of alternative Cases or Scenarios is to save multiple copies of spreadsheets onto their hard drive with each spreadsheet containing a different set of inputs and each labeled with a specific name and stored in a folder somewhere on their computer or network The MAESTRO can be used to save inputs and results from multiple scenarios in a single workbook and to run automated comparisons against different cases e Consolidation Portfolio Analysis A major challenge for t
96. w please make sure that the linked worksheets are open Also save the updated databook and worksheets If you delete a row it might be necessary to go to any linked model and delete the associated link Warning PLEASE DO NOT MANUALLY ADD OR DELETE ROWS OR COLUMNS ON THIS OR ANY OTHER SHEET IN THE MAESTRO MODEL AS SUCH WILL DISRUPT THE PERFORMANCE OF MAESTRO Where appropriate CEI has included automated routines that perform the addition or deletion of rows to MAESTRO Tables that include all of the necessary configurational features necessary to preserve MAESTRO Functionality e Reformat a Range This allows you to select a range of rows and reformat the data NOTE If desired it is OK to unprotect and manually reformat cells using the cells formatting features on the Excel Command Manu on sheets in MAESTRO that are protected without passwords as long as you DO NOT CHANGE CELL FORMATS TO LOCKED and DO NOT CHANGE CONDITIONAL FORMATTING OR DATA VALIDATION SETTINGS e Hide Unused Rows This option allows you to hide all the input rows that are not currently being used When executed options will be also provided to show or hide titles associated with individual sections of the Linked Global Inputs Sheet EconExpert Electronic Databook User s Manual Page 34 NOTE If desired it is OK to manually hide or unhide rows on any of the MAESTRO Sheets that are protected without a Password e Show ALL Rows This allows you to display a
97. w the tutorial at a later time you can do so by selecting Add Ins gt Electronic Data Book Menu gt MAESTRO Help gt Tutorial EconExpert Electronic Databook User s Manual Page 19 aestro Electronic Databook i Pl 2005 Congratulations the installation has been successfully COMPLETED Would You Like to View the EconExpert MAESTRO Tutorial Figure 23 Installation successful continue to tutorial 12 The MAESTRO will also prompt you with a screen indicating which other workbooks the model is linked to as applicable If you are opening a fresh copy of the MAESTRO the model will indicate that it is not currently linked to any other workbooks EconExpert Maestro Global Input Assumptions Table ts not currently linked to Inputs in any other workbooks EconExpert MAESTRO Scenario Results Table is not currently linked to results in any other workbooks Figure 24 Linking status with other workbooks 13 The newest version of EconExpert V14 will inform you of the need of updating all your previous EconExpert Models to maintain forward compatibility To continue to display the message at each start up select Yes otherwise select No EconExpert Electronic Databook User s Manual Page 20 IMPORTANT EconExpert Message PLEASE READ gt ji Effective with Version 14 4444 of EconExpert new functionality has f been introduced including interoperability with Office 2010 and other EconExpert Models t
98. ware operating systems and versions of Microsoft Excel the following minimum system requirements are recommended Hardware 512 MB or more of Random Access Memory RAM A graphics capable display with setting of at least 800 x 600 Pixels and preferably 1024 x 768 Pixels A graphics capable printer At least 100 MB of available storage on you C hard drive for spreadsheet storage This memory is needed for the initial installation only After the installation is completed the model can be saved and operated on the installed PC from any local or network drive Software Windows XP Windows Vista Windows 7 or later Operating Systems including most international language versions Microsoft Office Excel 2002 2003 2007 2010 Recommended Winzip or the equivalent for decompressing the original files Recommended but not required In many cases it will be desirable to zip spreadsheets before attaching them to emails Typical EconExpert Models are 4 12 MB unzipped and 1 3 MB zipped EconExpert Electronic Databook User s Manual Page 8 CEI usually issues EconExpert files by email attachment or download These files are typically compressed using WinZip a utility that compresses files for more efficient saving and transport via email To view the User s Manual or to install MAESTRO you must first decompress the files WinZip also typically accompanies Microsoft Windows operating systems It should be noted
99. will appear under the Add Ins option on the ribbon bar The MAESTRO Command Menu provides you with control of the MAESTRO model s Wizards and Special Functions The menu will be added to the Excel Menu bar each time that you open the MAESTRO model and will be deleted each time you close it If you become locked up in Windows when MAESTRO is opened it is possible that the menu will appear when you reopen Excel even if EconExpert is not opened To delete the extraneous menu simply reopen and then close the MAESTRO model ad Microsoft Excel a Databook V9 43 NO xIs SWISS 1 Eja ee Edit View Insert Format Tools Data Scenario Master Window Help Sasae me Jlar z SZ ae on 1e B34 fhe Website http Awww CElnsight cam 34 Fii i Home Insert Fage Layout i i EconExpert HELP PRINT UTILITIES NAVIGATE ENABLE WIND MODEL Menu Commands Figure 29 Excel 2007 2010 MAESTRO Menu When you click on the MAESTRO command menu you will reveal the sub menu options EconExpert Electronic Databook User s Manual Page 24 Enable Maestro Electronic Databook Navigate Input and Results Linking Wizards Data Management and EDE Import Sheet Protection Software Licensing and Registration EconExpert MAESTRO Electronic Databook Help Figure 30 The MAESTRO Sub Menu Enable MAESTRO Electronic Databook Before using the EconExpert Databook models the content has to be enabled under an authori
100. with notification 8 Select Trust access to the VBA project object model Trusted Publishers Trusted Locations a a For macros in documents not in a trusted location Add ins Disable all macros without notification Disable all macros with notification Activex Settings Disable all macros except digitally signed macros Enable all macros not recommended potentially dangerous code can run Message Bar Develo Macro Setti External Content 2 l TA i ngs Privacy Options Trust access to the VBA project object model Figure 16 Developer gt Macro Security 9 Open the extracted xls MAESTRO file with Excel 10 Once the model is open select Options EconExpert Electronic Databook User s Manual Page 15 a Me 4 Figure 17 Security Warning Macros have been disabled Options 11 Select Enable this content Macro Macros have been disabled Macros might contain viruses or other security hazards Do not enable this content unless you trust the source of this file Warning It is not possible to determine that this content came from a trustworthy More information File Path C EconExpert Files EconExpert MAESTRO V14 54 0 6 2 2010 ob xls a from unknown content recommended Open the Trust Center Figure 18 Security Warning Macros have been disabled Options gt Enable this content EconExpert Electronic Databook User s Manual Page 16 12 Econ
101. workbooks The safest way to ensure that all Links are correctly maintained is to save each of the workbooks twice cycling through the workbooks in sequence i e save workbooks 1 2 3 in order and then save workbooks 1 2 3 in order again Repeating the save in this manner will ensure that all paths and file names are recorded across ALL linked workbooks EconExpert Electronic Databook User s Manual Page 30 Examples that will result in corruption of links include e A manual change or overwrite of a linked formula Changing the formula of a link will change its calculated result e Insertion of a row or column in the target model If an inserted row or column results in a change in the cell address of a linked cell Excel will only recognize the associated link changes if both the MAESTRO and Target Workbook s are both open when the row insertion or deletion is made and will only remember the changes if both the MAESTRO and Target Workbook s are saved after the changes are made e Changing the name of a Linked Workbook Since Links between workbooks are tied to specific workbook names changing the name of a workbook or resaving the workbook to a different name will change the link If the MAESTRO and Target Workbook s are not both saved in a manner that includes the changed path folder and filename information then the next time that the workbooks are reopened the link formulas will not contain the correct information and the l
102. y manually select the correct workbook and worksheet Input Linking Wizard Form 2 Copyright 2007 2010 CEI Inc All Rights Reserved 28 Step 2 Select the Input Cell in the Workbook that you want to link to and then CLICK HERE Notes i To link to a different workbook use the Window option on the By cel Menu Linked Cells will be reshaded as Pink Available files 22 x EconExpert WIND Proforma V Table 4 GLOBAL INPUTS Version created last time the 11 24 AM Monday July 26 2 Green Indicates Input Cells ae No Annual Inputs Used Description fe EconExpert 4MAESTRO V14 5 26 di p Hescription Version created last time the dame of File C EconEzpert Fil S25 AM Tuesday August 10 a Terma S eed ee m Total Potential Term of PPA D 72 73 a0 1 Turbine 1 Rating 3 p KW 62 of Turbines i C a3 Turbine 2 Rating i aoe 7 KW a4 of Turbines b Saaz ar Total of Turbines a o 68 Turbine and Wind Project Gross Capacity kW 6a Average Turbine Capacity KW Figure 54 Single Custom Input Linking Wizard Select cell to link to The next dialog will prompt you for the title of the input cell EconExpert Electronic Databook User s Manual Page 44 Input Linking Wizard Form 3 Copyright 2007 2010 CEL Inc All Rights Reserved Step 3 Select the TITLE of the input cell in the workbook that you are linking to and then CLICK HERE
103. zed license Navigate Navigate is an automated GOTO that will take you directly to the various reports and report sections in the MAESTRO model As an alternative to the conventional approach of selecting worksheet tabs located on the bottom of the Excel Screen and then manually scrolling around the sheet in the model the Navigate Menu can be used to view a particular report or section of a report in the model Options provided on this menu include Global Input Assumptions Grid Input Assumptions Grid Selection List of Scenarios Scenario Results Table Scenario vs Base Case Software License Agreement Tithe Sheet Figure 31 The MAESTRO Sub Menu e Global Input Assumptions EconExpert Electronic Databook User s Manual Page 25 The Global Input Assumptions sheet allows you to link individual inputs from the databook into other workbooks Each column in this sheet represents a case project or scenario Cell D1 on this sheet is where the user can select the number of the case used to populate the linked workbooks The Single and Batch Input Linking Wizards provide an automated way to link inputs in the EconExpert MAESTRO to other models Examples of individual inputs include a cost item and its associated escalation rate a fixed interest rate or a discount rate These types of inputs are typically used in the Global Inputs Sheet in the EconExpert financial models e Grid Input Assumptions The Grid Input Assumptions sheet allows you lin

EconExpert-MAESTRO Electronic Databook User`s Manual

Contents

Download Pdf Manuals

Related Search

Related Contents