Functionality of DP Manager<\/em> requires that it be run on a Windows computer and with macros enabled.\u00a0 While it is possible your settings allow macros automatically, this often is not the case, at least the first time you open the file.\u00a0 You enable macros when, upon opening the DP Manager<\/em> file, the top of the window shows a yellow bar with the message \u201cSECURITY WARNING\u00a0 Some active content has been disabled.\u00a0 Click for more details.\u201d and a button labeled \u201cEnable Content\u201d.\u00a0 You SHOULD<\/em> click the Enable Content button.<\/strong><\/span><\/p>\n If you are trying to work with the file on the M-Drive, you cannot run macros due to university IT security settings that cannot be worked around (you get a red\/pink bar waring when opening the file).\u00a0 You just need to work with the file on your computer, whoever is working on it.\u00a0 If you still get the noted pink\/red bar, it probably thinks it is downloaded from the internet and thus Windows<\/em> is applying its default of protecting you from potential viruses.\u00a0 Close the DP Manager<\/em> file, right-click on the file and select Properties from the drop-down menu.\u00a0 Then check the Unblock<\/strong> checkbox and then Save<\/strong>.\u00a0 Now open the DP Manager file and it should be fine.\u00a0 If not, please contact the program director.<\/span><\/p>\n Each worksheet is protected.\u00a0 The Start Here!<\/em> sheet has a password and there is no need to unprotect it.\u00a0 All other worksheets are protected with no password.\u00a0 The protection is set to minimize the risk of inadvertent corruption of formulas and\/or formatting.\u00a0 Any cells where you must or may enter something are unlocked.\u00a0 Any sheets where sorting is appropriate have been provided with a \u201cSort\u201d button (up-and-right from the table, set on a light-blue background) that will correctly sort the correct region.\u00a0 If you find you need to unprotect a sheet, go ahead, but you are encouraged to re-protect it (and with no password<\/em><\/strong>) after you are done doing whatever it is you think you need to do with the protection turned off.\u00a0 Again, I cannot think of a need to unprotect it.<\/p>\n Further, in order to maintain integrity of references in formulas (many you do not see), it is really important to NOT<\/em><\/strong><\/p>\n \u201cCutting\u201d in Excel<\/em> makes Excel<\/em> think the cell<\/em><\/strong> actually moved, not just its contents\u2026 that there is now nothing in the old location for some other formula to reference.\u00a0 The formulas behind the scenes have been developed to be robust to this issue, but nothing is perfect.\u00a0 So, take care and with \u201cdesign for robustness\u201d combined with your \u201ccare-in-cutting\u201d you will reduce the risk of experiencing issues.\u00a0 This is especially important in regard to deleting rows<\/strong>; it is not robust to that and cannot be practically made such.\u00a0 The smart borders (see next subsection) will handle table sizing, so there is never a need to delete rows.<\/p>\n A second really important consideration is citing sources.\u00a0 Any graphical images you use from sources (e.g., in the morphological chart (the Functional-Level Concepts<\/em> sheet)) should be referenced by citation number (e.g., [FML##] or [TEAM##]) in your TAD<\/em><\/strong> reference list.<\/p>\n To reduce your workload in formatting and managing sheet protections for hiding and showing unused rows or columns, the \u201cConditional Formatting\u201d capability in Excel<\/em> has been used to provide table borders that will size dynamically to encompass only the amount of entries in the respective table.<\/p>\n Every sheet has a pair of buttons (up-and-right from the table) that will copy the table to the clipboard for pasting in another destination (e.g., Google Docs<\/em> or Slides<\/em>).\u00a0 Using these buttons is not only EASIER<\/em><\/strong> than manually selecting, but also<\/strong>:<\/p>\n There is a button that grabs just the table, and another that includes also the title above it; the latter is useful in cases where a table caption is not typical (like in a presentation slide).<\/p>\n The Start Here!<\/em> Sheet is where you are always taken upon opening (if macros are enabled).\u00a0 It has two inputs (the light-yellow cells).<\/p>\n The first input is the number of end-user use cases.\u00a0 There can be up to three (3).\u00a0 Choose the appropriate number from the drop-down list.\u00a0 Some sheets are not needed if you have only one or two use cases.\u00a0 Other sheets have multiple versions that are sized\/configured for the number of use cases.\u00a0 Having the correct number of end-user use cases entered will allow the sheets to provide guidance on whether it is a sheet to be using or not.\u00a0 More is stated on this subject below (Section 4, Other Color-Coded Guidance).<\/p>\n The second input is the starting number for system-level concepts.\u00a0 When you get to a second round of concept generation and assessment, you will make a copy of your original DP Manager<\/em> file and begin working with that.<\/strong>\u00a0 If you had, for instance, four system-level concepts in the first round, by setting this input to 5 will number (in sheet titles, etc.) starting at 5, not 1.\u00a0 Correctly continuing this in subsequent rounds will assure system-level concepts are uniquely numbered across all rounds, not simply within each round.\u00a0 As a final note on second rounds, after making a copy of the previous round DP Manager<\/em> file, all upfront information (e.g., engineering requirements, functions, function-level concepts) are already there.\u00a0 All you need to do is go and clear out the information from the previous round in the System-Level Concept Data and Assessment (SLC#D<\/em> and SLC#A#<\/em>) sheets.\u00a0 Hint<\/em>:<\/strong>\u00a0 If you do this house cleaning (clear-out) at the end of your first round, then make a \u201cmaster\u201d copy of that file for use in future rounds, you save yourself the work of clearing out all the System-Level Concept Data and Assessment sheets in subsequent rounds.<\/p>\n Smart shading is employed by way of \u201cConditional Formatting.\u201d\u00a0 It is intended to give guidance on entry of data toward assuring that inputs are entered into the correct locations and in a correct sequence.<\/p>\n Input cell shading is for guidance during information\/data input.\u00a0 It is NOT<\/em> intended to show when you present your tables.<\/strong>\u00a0 As such, the copy buttons will automatically turn it off and back on.\u00a0 The \u201cToggle Shading\u201d button can be used to manually turn it on and off, for instance for a quick look at what the table looks like without the shading turned on.<\/p>\n Errors in entry cells are indicated by changing the background (cell fill color) to red and the text to bold white.\u00a0 One case happens (as a result of not implementing more involved VBA\/macros to more elegantly handle the situation) where changes in data entered on earlier sheets affects data already entered in these subject cells on later sheets.\u00a0 The two cases are:<\/p>\n Note that error formatting does not<\/em> get turned off when toggling smart shading to off.<\/strong><\/p>\n Light yellow is used for cells where inputting information is optional.\u00a0 It is optional either because more data\/entries in the list re not needed, but allowable, or the cell can be left blank as a valid condition\/entry.<\/p>\n Cells that require input of information are pink (light red).\u00a0 Sometimes this is because there is a minimum amount of required information (e.g., you must have at least one engineering constraint, one engineering objective, and one main system function), or that once an optional piece of information is added additional information is then required (e.g., for each engineering constraint\/objective or main system function name that is added, the rest of the information on that row is then required).<\/p>\n Additional guidance is provided in orange-shaded<\/strong><\/span> cells in the top row on most sheets to indicate if the sheet is to be used or not, and if it is to be used it may indicate how much (more) data a table can accept.<\/p>\n Windows<\/sub><\/em> is a registered trademark of Microsoft Corporation. <\/p>\n","protected":false},"excerpt":{"rendered":" 1\u00a0\u00a0\u00a0\u00a0 Overview Functionality of DP Manager requires that it be run on a Windows computer and with macros enabled.\u00a0 While it is possible your settings allow macros automatically, this often is not the case, at least the first time you open the file.\u00a0 You enable macros when, upon opening the DP Manager file, the top […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/posts\/102"}],"collection":[{"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/comments?post=102"}],"version-history":[{"count":21,"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/posts\/102\/revisions"}],"predecessor-version":[{"id":2771,"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/posts\/102\/revisions\/2771"}],"wp:attachment":[{"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/media?parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/categories?post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/me.sites.mtu.edu\/meemscd\/wp-json\/wp\/v2\/tags?post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}1.1\u00a0\u00a0\u00a0 Sheet Protection<\/h3>\n
1.2\u00a0\u00a0\u00a0 Important<\/span><\/h3>\n
\n
1.3\u00a0\u00a0\u00a0 Smart Borders<\/h3>\n
1.4\u00a0\u00a0\u00a0 Copy and Paste to Other Docs\/Destinations<\/h3>\n
\n
2\u00a0\u00a0\u00a0\u00a0 Start Here! Inputs<\/h2>\n
3\u00a0\u00a0\u00a0\u00a0 Input Cell Smart Shading<\/h2>\n
3.1\u00a0\u00a0\u00a0 Errors<\/h3>\n
\n
3.2\u00a0\u00a0\u00a0 Optional Inputs<\/h3>\n
3.3\u00a0\u00a0\u00a0 Required Inputs<\/h3>\n
4\u00a0\u00a0\u00a0\u00a0 Other Color-Coded Guidance<\/h2>\n
\n
\nGoogle Docs<\/em> and Google Slides<\/em> are trademarks of Google LLC.<\/sub><\/p>\n\n\n
\n \u00a9 2017, William J. Endres<\/td>\n Updated October 26, 2022<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n