{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["Instructions ","Key","BM","Req","A&D","Impl","Test","Deploy","PM","Env & CM"],"not_rendered":{"external_links":1,"defined_names":29},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions ","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"merged":[[2,0,2,1],[4,0,4,1]],"flags":["formulas_cached_only"]}
["Purpose of this Workbook"]
[]
["This workbook lists every work product to be produced by the project.  It is intended to be a one-stop-shop for team members to quickly identify what work products need to be produced, where they are kept, if and how they are reviewed, etc.  Specific guidance on how to produce most work products are included in the Rational Unified Process.  This information can be located quickly from the links found on the Development Case work product template in the RUP or by searching the RUP for the name of the work product."]
[]
["This workbook is a key document used in audits of the project, especially ISO 9001:2000 audits.  It is important that the information it contains is accurate for the project."]
[]
["Hints and Tips for Using this Workbook"]
[]
["1.","Refer to the Key tab for an explanation of the columns and values used in those columns."]
[]
["2.","Customize the Rows You See:  To enable filtering by contents of the data in the columns, select the blank row at the bottom of the header and choose: Data/Filter->Auto Filter.  The user can then choose what rows in the spreadsheet he wants to see."]
[]
["3.","Customize the Columns You See:  You can hide columns temporarily that you are not interested in seeing.  Select the column, right click, and choose Hide.  To unhide, select the columns that surround the hidden column and choose Unhide."]
[]
["4.","To keep the heading rows visible as you scroll through a table, select the first row below the header and choose:  Window/Freeze Panes."]
[]
["5.","Offer a Drop-Down List of Choices:  To offer a specific list of choices for a particular cell, choose Data/Validation… and specify List.  Enter cell choices, separated by commas."]
[]
["6.","Include a space in an empty cell that follows a column you'd like to narrow down without text spilling into the empty cell.  This trick has often been used in the Location/Tool column to allow the WP Kind column to be made narrow."]
[]
["Document Control Details"]
[]
[null,"This workbook is part of the Development Case for this project.  It is reviewed and approved as part of that document.  See the Development Case for review and approval details."]
[]
["Instructions for Completing this Workbook "]
[]
["1.","Modify the columns of the spreadsheet to suit the needs of your  project.  "]
[]
["2.","This  spreadsheet template includes typical values for many of the cells.  Each project should update the values in the spreadsheet to suit their project. Update the Instructions and Key as needed, also."]
[]
["3.","This workbook is completed in conjunction with the Development Case.  The two documents are considered to be one document.  They must be kept consistent with one another."]

{"sheet":"Key","index":1,"n_rows":46,"n_cols":4,"rows_kept":46,"merged":[[2,2,2,3],[3,0,3,1],[3,2,3,3],[4,2,4,3],[5,0,5,1],[5,2,5,3],[6,0,10,0],[11,0,11,1],[11,2,11,3],[12,0,22,0],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,0,23,1],[23,2,23,3],[24,2,24,3],[25,0,25,1],[25,2,25,3],[26,0,35,0],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,0,36,1],[36,2,36,3],[38,0,38,1],[38,2,38,3],[39,0,44,0],[39,1,39,3],[45,0,45,1],[45,2,45,3]],"flags":["formulas_cached_only"]}
["KEY to the Columns and Values within Columns on work product Sheets"]
[]
["Column","Value","Meaning"]
["Work Product",null,"Add any additional work products that will  be produced by the project.  Do not remove any work products from the list.  Instead, identify those by marking the Doing column with No."]
[null,"various","For more information on the specific work product, use the Search feature in RUP to search for the work product name."]
["RUP Phases\nI, E, C, T",null,"Document the state of the work product at the end of each phase.  The phases are the standard RUP phases of:  Inception (I), Elaboration (E), Construction (C), and Transition (T).  "]
[null,"p","Preliminary","The work product is initially created and contains high-level content based on the best available information.  The work product does not require approval."]
[null,"c","Complete","The work product contains all necessary content appropriate for this phase of the development project and is documented at the proper level for the intended reviewers and/or approvers.  "]
[null,"r","Revised as needed","The work product is reviewed and revised as appropriate.  If a work product is revised, re-approval is obtained if the work product has a designated approver."]
[null,"t","Transitory","The work product is created and used, but it is considered transitory and is therefore not kept up-to-date.  It can be discarded when no longer needed and it not preserved with the project."]
[null,"n","As Needed","The work product is used in the phase as needed.  This means it may or may not even be created or updated.  work products used throughout the project are also designated with N."]
["Source Process Delta",null,"These sections identify the differences from the identified source process"]
[null,"Src (source)","Identify the source of the work product.  You may add additional work products to the list.  Add additional values to this key to identify the source for these work products."]
[null,"RUP","This work product is identified in RUP."]
[null,"SUG","This is a suggested addition to the RUP work products.  It is often used by projects.  [Suggest:  change this identifier to one this is appropriate to your project.  Work Products identified as SUG can be deleted from the spreadsheet if they are not needed by your project.]"]
[null,"[your choice]","[Identify additional sources requiring work products that are additional to those identified by RUP]"]
[null,"Doing","Indicates whether the work product is produced by the project or not.  For those work products not produced, include the reason for not producing the work product in the Comments column.  Documenting the reason is especially important for required work products."]
[null,"Yes","The work product is produced."]
[null,"No","The work product is not produced."]
[null,"Deviation","Indicates whether or not the work product deviates from the source process."]
[null,"Yes","The work product deviates from the source process.  The comment field identifies the deviation."]
[null,"No","The work product is unchanged from the source process."]
[null,"n/a","The work product is not being produced."]
["Domain",null,"RUP associates work products with domains.  This column identifies the RUP domain for the work product."]
[null,"see RUP","Except for Env & CM, the tabs of this workbook are the domains, so for many tabs this column provides redundant information. However, you may want to redefine the tabs and rearrange the work products onto your own tabs. In that case, the domain column will be helpful.\n"]
["WP Kind",null,"RUP associates work products with Work Product Kinds.  This column identifies the RUP work product kind for the work product."]
[null,"Assess","Assessment work products"]
[null,"Concept","Concept work products"]
[null,"Data","Project Data work products"]
[null,"Infra","Infrastructure work products"]
[null,"Model","Model work products"]
[null,"M Elem","Model Element work products"]
[null,"Plan","Plan work products"]
[null,"Process","Process work products"]
[null,"Solution","Solution work products (includes both product source, test data and source, product deliverables)"]
[null,"Spec","Specification work products"]
["Template/Example/Tool",null,"Document which template is used to produce this work product.  In some cases, a particular tool directs the information collected, so no template is used.  Where a specific template is not available, an example might be helpful."]
[null,"RUP","[Suggest: Provide a link to the project's published site here.]","The template that is supplied in RUP is used. Use the Search facility of RUP to locate the template."]
["Review Details",null,"Specifies the type of review held and identifies the reviewers and approvers by role. Note that optional reviewers are invited to the review, but they are not required to participate.\nFor details on the types of review, see the guidelines on Review Levels in the Rational Unified Process."]
[null,"Type of Review"]
[null,null,"Formal-External","The work product is part of the delivery at a specific milestone and requires some form of approval by the customer, the sponsor, or some other external stakeholder."]
[null,null,"Formal-Internal","The work product is formally reviewed internally by the project."]
[null,null,"Informal","The work product is reviewed, but not formally approved.  Records are not required to be maintained.  "]
[null,null,"None","No review is planned."]
[null,null,"n/a","Review of the work product is not appropriate.  The work product may be validated by testing, or it may be a work product that makes no sense to review, such as a review record."]
["Comments",null,"This column is for the project to use as desired  For required work products not produced, provide the reason for not producing them. Comments of the form [blue text] are instructions for the person completing the spreadsheet and may be removed."]

{"sheet":"BM","index":2,"n_rows":15,"n_cols":17,"rows_kept":15,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,15]],"flags":["formulas_cached_only"]}
[null,"RUP Phases",{"$nulls":3},"Source Process Delta",null,null," ",null," ",null,"Review Details",{"$nulls":3}," "]
["RUP Work Product","I","E","C","T","Src","Doing","Deviation","Domain","WP Kind","Location/ Tool","Template/ Example/ Tool","Type","Required Reviewers","Optional Reviewers","Approver(s)","Comments"]
[]
["Business Analysis Model","c","r",null,null,"RUP"," ",null,"BM","Model"," "]
["Business Architectural Proof-of-Concept","c","r",null,null,"RUP"," ",null,"BM","Concept"," "," "]
["Business Architecture Document","c","r",null,null,"RUP"," ",null,"BM","Spec"," ","RUP"]
["Business Deployment Model","c","r",null,null,"RUP"," ",null,"BM","Model"," "]
["Business Design Model","c","r",null,null,"RUP"," ",null,"BM","Model"," "," "]
["Business Glossary","c","r",null,null,"RUP"," ",null,"BM","Spec"," ","RUP"]
["Business Goals","c","r",null,null,"RUP"," ",null,"BM","Spec"]
["Business Rules","c","r",null,null,"RUP"," ",null,"BM","Spec"]
["Business Use-Case Model","c","r",null,null,"RUP"," ",null,"BM","Model"," ","RUP"]
["Business Vision","c","r",null,null,"RUP"," ",null,"BM","Spec",null,"RUP"]
["Supplementary Business Specification","c","r",null,null,"RUP"," ",null,"BM","Spec",null,"RUP"]
["Target Organization Assessment","c"," ",null,null,"RUP"," ",null,"BM","Assess"," ","RUP"]

{"sheet":"Req","index":3,"n_rows":14,"n_cols":17,"rows_kept":14,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,15]],"flags":["formulas_cached_only"]}
[null,"RUP Phases",{"$nulls":3},"Source Process Delta",null,null," ",null," ",null,"Review Details",{"$nulls":3}," "]
["RUP Work Product","I","E","C","T","Src","Doing","Deviation","Domain","WP Kind","Location/ Tool","Template/ Example/ Tool","Type","Required Reviewers","Optional Reviewers","Approver(s)","Comments"]
[]
["Glossary","p","c",null,null,"RUP"," ",null,"Req","Spec",null,"RUP"]
["Requirements Attributes (Repository)","c"," ",null,null,"RUP"," ",null,"Req ","Data"," ",null,"n/a"]
["Requirements Management Plan ","c","r","r","r","RUP"," ",null,"Req","Plan"," ","RUP"]
["Software Requirements","n","n","n","n","RUP"," ",null,"Req","Spec"," ",null,"n/a"]
["SRS: Software Requirements Specification","p","c","r",null,"RUP"," ",null,"Req","Spec"," ","RUP"]
["SRS: Supplementary Specifications","p","c","r",null,"RUP"," ",null,"Req","Spec"," "]
["SRS: Use Cases","p","80%c","c",null,"RUP"," ",null,"Req","M Elem"," ","RUP"]
["SRS: Use-Case Model","p","p","c",null,"RUP"," ",null,"Req","Model"," "," "]
["Stakeholder Requests","c","r"," ",null,"RUP"," ",null,"Req","Spec"," ",null,"n/a"]
["Storyboard","p","c",null,null,"RUP"," ",null,"Req","Model"," ","RUP"]
["Vision","p","c",null,null,"RUP"," ",null,"Req","Concept"," ","RUP"]

{"sheet":"A&D","index":4,"n_rows":13,"n_cols":17,"rows_kept":13,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,15]],"flags":["formulas_cached_only"]}
[null,"RUP Phases",{"$nulls":3},"Source Process Delta",null,null," ",null," ",null,"Review Details",{"$nulls":3}," "]
["RUP Work Product","I","E","C","T","Src","Doing","Deviation","Domain","WP Kind","Location/ Tool","Template/ Example/ Tool","Type","Required Reviewers","Optional Reviewers","Approver(s)","Comments"]
[]
["Analysis Model",null,"p","c",null,"RUP"," ",null,"A&D","Model"," "," "]
["Architectural Proof-of-Concept","p","c",null,null,"RUP"," ",null,"A&D","Concept"," "," "]
["Data Model",null,"c","r",null,"RUP"," ",null,"A&D","Model"," "," "]
["Deployment Model",null,"p","c",null,"RUP"," ",null,"A&D","Model"," "," "]
["Design Model",null,"p","c",null,"RUP"," ",null,"A&D","Model"," "]
["Navigation Map","p","c","r",null,"RUP"," ",null,"A&D","Model"," "," "]
["Reference Architecture","p","c",null,null,"RUP"," ",null,"A&D","Concept"," "," "]
["Service Model","p","c","r",null,"RUP"," ",null,"A&D","Model"]
["Software Architecture Document",null,"c",null,null,"RUP"," ",null,"A&D","Spec"," ","RUP"]
["User-Interface Prototype","p","c",null,null,"RUP"," ",null,"A&D","Concept","  "," "]

{"sheet":"Impl","index":5,"n_rows":13,"n_cols":17,"rows_kept":13,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,15]],"flags":["formulas_cached_only"]}
[null,"RUP Phases",{"$nulls":3},"Source Process Delta",null,null," ",null," ",null,"Review Details",{"$nulls":3}," "]
["RUP Work Product","I","E","C","T","Src","Doing","Deviation","Domain","WP Kind","Location/ Tool","Template/ Example/ Tool","Type","Required Reviewers","Optional Reviewers","Approver(s)","Comments"]
[]
["Build",{"$nulls":3},"c","RUP"," ",null,"Impl","Solution"," "," ","n/a"]
["Developer Test","p","c","c","n","RUP"," ",null,"Impl","Solution"," "]
["Implementation Elements","p","c","c","r","RUP","n"," ","Impl","Solution",{"$nulls":6},"[You may prefer to itemize the specific types of implementation elements your project has.  Several typical ones are included as SUG source.]"]
["Implementation Element: Product Samples",null,"p","c",null,"SUG"," ",null,"Impl","Solution"," "," "]
["Implementation Subsystem",null,"c",null,null,"RUP","n"," ","Impl","M Elem"]
["Implementation Element: Source Code",null,"p","c","c","RUP",null,null,"Impl","Solution"," "," "]
["Implementation Model",null,"c","r",null,"RUP"," ",null,"Impl","Model"]
["Integration Build Plan",null,"p","c",null,"RUP"," ",null,"Impl","Plan"," ","RUP","n/a"]
["Test Stubs","c","c","c",null,"RUP","n"," ","Impl","Solution"]
["Testability Elements","p","c","c","r","RUP","n"," ","Impl","Solution"]

{"sheet":"Test","index":6,"n_rows":19,"n_cols":17,"rows_kept":19,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,15]],"flags":["formulas_cached_only"]}
[null,"RUP Phases",{"$nulls":3},"Source Process Delta",null,null," ",null," ",null,"Review Details",{"$nulls":3}," "]
["RUP Work Product","I","E","C","T","Src","Doing","Deviation","Domain","WP Kind","Location/ Tool","Template/ Example/ Tool","Type","Required Reviewers","Optional Reviewers","Approver(s)","Comments"]
[]
["Iteration Test Plans","c","c","c","c","SUG"," ",null,"Test","Plan"," ","RUP"]
["Master Test Plan","c","r","r",null,"SUG"," ",null,"Test","Plan"," ","RUP"]
["Test Automation Architecture",null,"c",null,null,"RUP"," ",null,"Test","Spec"," "," "]
["Test Case","n","c","c",null,"RUP"," ",null,"Test","Spec"," "," "]
["Test Data","c","c","c",null,"RUP"," ",null,"Test","Solution"," "," "]
["Test Environment Configuration","p","c",null,null,"RUP"," ",null,"Test","Infra"]
["Test Evaluation Summary",{"$nulls":4},"RUP"," ",null,"Test","Assess"," ","RUP","n/a"]
["Test Ideas List","t","t","t",null,"RUP"," ",null,"Test","Concept"," "," ","n/a"]
["Test Interface Specification","p","c",null,null,"RUP"," ",null,"Test","Spec"]
["Test Log","t","t","t",null,"RUP"," ",null,"Test","Data"," "," ","n/a"]
["Test Plan (s)","c","c","c",null,"RUP"," ",null,"Test",null," ","RUP (Master/Iter)",{"$nulls":4},"[You may prefer to itemize the specific types of test plans your project has.  Several typical ones are included as SUG source.]"]
["Test Results","c","c","c","c","RUP"," ",null,"Test","Data"," "," ","n/a"]
["Test Script","n","c","c",null,"RUP"," ",null,"Test","Solution"," "," "]
["Test Strategy","p","c","r","r","RUP"," ",null,"Test","Concept"," ","RUP"]
["Test Suite",null,"p","c",null,"RUP"," ",null,"Test","Solution"," "," "]
["Workload Analysis Model",null,"p","c",null,"RUP"," ",null,"Test","Model"," "," "]

{"sheet":"Deploy","index":7,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,15]],"flags":["formulas_cached_only"]}
[null,"RUP Phases",{"$nulls":3},"Source Process Delta",null,null," ",null," ",null,"Review Details",{"$nulls":3}," "]
["RUP Work Product","I","E","C","T","Src","Doing","Deviation","Domain","WP Kind","Location/ Tool","Template/ Example/ Tool","Type","Required Reviewers","Optional Reviewers","Approver(s)","Comments"]
[]
["Guide:  Manual Styleguide","c","r",null,null,"RUP"," ",null,"Deploy","Process"," "]
["Product: Artwork",{"$nulls":3},"c","RUP"," ",null,"Deploy","Solution"," "," "]
["Product: Bill of Materials","n","n","n","n","RUP"," ",null,"Deploy","Solution"]
["Product: Deployment Unit",null,null,"p","c","RUP"," ",null,"Deploy","Solution"," ",null,"n/a",{"$nulls":3},"tested, not reviewed"]
["Product: Installation Artifacts",null,"c","c","c","RUP"," ",null,"Deploy","Solution"," "," ","n/a",{"$nulls":3},"tested, not reviewed"]
["User Support Material: Product Publications",null," p","p","c","SUG"," "," ","Deploy","Solution"," "," "]
["User Support Material: Release Notes",{"$nulls":3},"c","RUP"," ",null,"Deploy","Solution"," "," "]
["User Support Material: Training Materials",null,null,"p","c","RUP"," ",null,"Deploy","Solution"," "," "]
["User Support Material: Help Text",null," ","p","c","RUP"," ",null,"Deploy","Solution"," "," "]

{"sheet":"PM","index":8,"n_rows":26,"n_cols":17,"rows_kept":26,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,15]],"flags":["formulas_cached_only"]}
[null,"RUP Phases",{"$nulls":3},"Source Process Delta",null,null," ",null," ",null,"Review Details",{"$nulls":3}," "]
["RUP Work Product","I","E","C","T","Src","Doing","Deviation","Domain","WP Kind","Location/ Tool","Template/ Example/ Tool","Type","Required Reviewers","Optional Reviewers","Approver(s)","Comments"]
[]
["Business Case","c","r","r","r","RUP"," ",null,"PM","Assess"," ","RUP"]
["Deployment Plan",null,"c","r",null,"RUP"," ",null,"PM","Plan"," "]
["Issues List","c","r","r","r","RUP"," ",null,"PM","Data"," ",null,"n/a"]
["Iteration Assessments","c","c","c","c","RUP"," ",null,"PM","Assess"," ","RUP","n/a"]
["Iteration Plan","c","c","c",null,"RUP"," ",null,"PM","Plan"," ","RUP"]
["Project Measurements","n","n","n","n","RUP"," ",null,"PM","Data"," ",null,"n/a"]
["Review Records","n","n","n","n","RUP"," ",null,"PM","Data"," ",null,"n/a"]
["Risk List","c","r","r","r","RUP"," ",null,"PM","Data"," ","RUP","n/a"]
["SDP: Measurement Plan","c","r","r","r","RUP"," ",null,"PM","Plan"," ","RUP"]
["SDP: Problem Resolution Plan","c"," ",null,null,"RUP"," ",null,"PM","Plan"," ","RUP"]
["SDP: Product Acceptance Plan","c"," "," ",null,"RUP"," ",null,"PM","Plan"," ","RUP"]
["SDP: Quality Assurance Plan","p","c","r","r","RUP"," ",null,"PM","Plan"," "]
["SDP: Risk Management Plan",null,"c",null,null,"RUP"," ",null,"PM","Plan"," ","RUP"]
["SDP: Software Development Plan","p","c","r","r","RUP"," ",null,"PM","Plan"," ","RUP"]
["Status Assessments","n","n","n","n","RUP"," ",null,"PM","Assess"," ",null,"n/a"]
["Work Order","n","n","n","n","RUP"," ",null,"PM","Data"," ",null,"n/a"]
[]
[]
[]
[]
[]
["NOTE:  For Test Plans, see the Test tab."]
["SDP = Software Development Plan"]

{"sheet":"Env & CM","index":9,"n_rows":19,"n_cols":17,"rows_kept":19,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,15]],"flags":["formulas_cached_only"]}
[null,"RUP Phases",{"$nulls":3},"Source Process Delta",null,null," ",null," ",null,"Review Details",{"$nulls":3}," "]
["RUP Work Product","I","E","C","T","Src","Doing","Deviation","Domain","WP Kind","Location/ Tool","Template/ Example/ Tool","Type","Required Reviewers","Optional Reviewers","Approver(s)","Comments"]
[]
["Change Requests","n","n","n","n","RUP","no",null,"CM","Data"," "," ","n/a"]
["Configuration Audit Findings",{"$nulls":3},"c","RUP"," ",null,"CM","Assess"," ",null,"n/a"]
["Configuration Management Plan","c",{"$nulls":3},"RUP"," ",null,"CM","Plan"," ","RUP"]
["Development Infrastructure","c",{"$nulls":3},"RUP"," ",null,"Env","Infra",null,null,"n/a"]
["Development Infrastructure: Tools","c","n",null,null,"RUP"," ",null,"Env","Infra"]
["Development Organization Assessment","n","n","n","n","RUP"," ",null,"Env","Assess"," ","RUP","n/a"]
["Development Process: Development Case","c","r","r",null,"RUP"," ",null,"Env","Process"," ","RUP"]
["Development Process: Tailored Delivery Process","c","r",null,null,"RUP"," ",null,"Env","Process"," "]
["Guide:  Design Guidelines","p","c","r",null,"RUP"," ",null,"Env","Process"," ","RUP"]
["Guide:  Other Project-Specific Guidelines","p","c","r",null,"RUP"," ",null,"Env","Process"," ",{"$nulls":5},"[Specify each additional guideline]"]
["Guide:  Programming Guidelines","p","c","r",null,"RUP"," ",null,"Env","Process"," ","RUP"]
["Guide:  Test Guidelines","p","c","r",null,"RUP"," ",null,"Env","Process"," ","RUP"]
["Guide:  Use-Case Modeling Guidelines","c","r",null,null,"RUP"," ",null,"Env","Process"," ","RUP"]
["Project Repository","c",{"$nulls":3},"RUP"," ",null,"CM","Infra"," "," ","n/a"]
["Project-Specific Templates","p","c","r",null,"RUP"," ",null,"Env","Process"," "]
["Workspace","n","n","n","n","RUP"," ",null,"CM","Infra",null,"RUP"]