_   4444 _ _____ _  _ AC>N@XEE(waaa_E _E _E _E _E _E% _E     _E_E% " ANS_INFOPRTtta a ANS_KEEPDATAt  ANS_MACROPRT1tz z ANS_MACROPRT2t{ { ANS_MACROPRT3t| | ANS_SWAPDATAtC C ANS_UPDDATAt  BACKGRNDTAt%% BCK_COLTAt-- BCK_LOOPTAt(( CHT_PRINTAt00 CLEAN_LISTt CLEAN_LOOPt CURR_SCENtvv DATA_01Nt  DATA_02Nt  DATA_03Nt DATA_04Nt! DATA_05Nt%& DATA_06Nt  DATA_07Nt  DATA_08Nt! DATA_09Nt%& DATA_10Nt/1 DATA_11Nt33 DATA_12Nt33 DATA_13Nt33 DATA_14Nt33 DATA_15Nt DATA_16Nt DEL_SCENARIOt DLG_INFOPRTt^^ DLG_KEEPDATAt DLG_KHELPTAt DLG_MACPRINTtww DLG_PERSONALt DLG_SAMPLE1txx DLG_SAMPLE2t DLG_SWAPDATAt@@ DLG_UPDDATAt DLG_UPDSCAtJJ DLG_UPDUNAtSS D_VERSIONSt FRM_UPDSCtMM INFORMATIONt INFO_ABOUTtKK INFO_CONVENTION INFO_CURR_PRTNKK INFO_LISTPRTNUZ INFO_NOTESFXN INFO_OVERVIEWN;; INFO_PRINTEWN99 INFO_STEPSEWNoo INFO_TIPSEWN INFO_TOPICEWN\\ INF_ABOU_RANGEMY INF_CONVENTION INF_NOTE_RANGE' INF_OVER_RANGE=G INF_STEP_RANGEq INF_TIPS_RANGE KEEPDATARANGE K_EXISTSRANGE K_HELPSRANGE K_LIMITRANGE K_UPDATERANGE K_VERSIONSNGE LIST_ADDRNGE LIST_RNGNGE MACROSGNGE MACROS_RANGEE MACRO_HIDEEE`` MACRO_PRINTEii MACRO_SHOWE]] NOTES FIELDSE NOTES_FIELDSE NOTES_SHOWSEdd NO_UPDATESE>> PERSONALIZEE PREV_SCENEEuu PROJECTNEE RESECTNEE RES_INFOPRTE_ _ RES_KEEPDATAE  RES_MACROPRTEx x RES_SAMPLE1Ey y RES_SAMPLE2E  RES_SWAPDATAEA A RES_UPDDATAE  RES_UPDSCAEK K RES_UPDUNAET T RNG_NAMEAE RNG_NUMAE RN_TABLEAE RN_TABLE_RANGE] SAMPDATARANGEhh SAMP_RESTOREEqq SCENARIO_LIST' SHEET_RANGET4 SHT_PRINTET SWAPDATAET TABLE_CONTENTS UPDATEONTENTS)) UPDATE_LISTTS' UPDATE_LOOPTS88 UPDATE_POSTTS77 UPDATE_TESTTS22 UPDUN_TESTTS UPPER_LEFTTSSS UP_EXISTINGTS UP_UNNAMEDTS ZM_ALLMEDTS ZM_NRMLEDTS ZM_RESTORETS ZM_SCRNRETS   ZM_TABLEETS ZOOM_RTNETS ZOOM_TESTTS \0M_TESTTS G?TESTTS! GSTESTTS XSTESTTS' G9TESTTS G:TESTTS G?TESTTS GFTESTTS GGTESTTS CBCOPYTTS%& DF0PYTTS DS0PYTTS' DSKPYTTS' RN0PYTTS RS0PYTTSPX!   ?? @VName8LBLBq+q+q+ Net Present ValueCHART 1bq+q+q+ Year Net Present Value Net Present ValueVNOTE Payback occurs after all investments have been made, and the NPV is positive. 6Contents6CW 6Project6CW 6Chart6_CW 6Macros6Information6"CW  Arial! Arial"  Arial#  Arial%%Times New Roman&  Arial MT' Arial(  Arial MT)  Arial*  Arial+ Arial-  Arial.  Arial/ Arial0 Arial1  Arial2 Arial3  Arial4 Arial5  Arial6 Arial7  Arial8 Arial9 Arial: Arial; Arial MT< Arial>  Arial?  Arial@  ArialB ArialC  ArialD ArialE  Arial MTF ArialG ArialH  Arial%ITimes New RomanJ ArialK ArialL  ArialM ArialN Arial MTO  ArialP ArialQ GillSansR ArialT  ArialU ArialV  ArialW ArialX  ArialY  Arial!?) #?9NC)_: <3 <3 "'3_  _!?">#4$?%6&;'?()+ *&+3_ ,>-__.C/I 0*2) 3!94#5)6C 7C8? 93:5;J <1=H>F?_@7A2BCC8D!E9F!9G<H99IJ@L?M%QK R?UC_ZT[U \ <] ^B _D `K a b) c" dOeFfF gG hHi jGkG lF mH o qH rt. 4 ' 94 )!9+"P9"""(_ """. V " " . ? ""+".!! __ W <X <X X_ Y_ " X_ X" @ X."&& Q_ &"2@@STYL1Y Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefinedq0*q0*wdWF|P1* 3*L1*DD 3*L(4*MLLLLLLLL)))-)LLLh5*_@@@(@(@@@(@)@@)@@@@)@) @@@*@)@@@@*@* @@@'@*@@@@"@+@@+@@@@"@+@@+@@    @@"@+@@+@@ @@:;@@@;  @;@ @#@ ```````` ` ` ` ` ` `` ` ~@@'@@( @@@,@@"@@"@@@"@@""@@"@"& @##@"@ @##@&@@"#@"@@@"#@ &  @"$@"@ @"$@  "     "@"%"@@$@$@$@$@$@"@%"@%@@%@$%@@%@$@"@%$%$@#@@$$@@$@#$@@$$@@$@ ``````` ` ` ` ` ``````````"````````` ! ""$@#"&$"@"@$@"@"@)%"@"@2@$"@"@2@"@&%')("@"@&@$"@"@&@"@))"@"@@&@$"@"@@&@"@)*"@"@@&@$"@"@@&@"@+*&,"&@$"@@&@"@-""@.'/'@@"0"@@"1"@@""@"2""@")3@"@y@"@"@y@"@&4''@"'@'@'@"@PQRQSRTSUTVUWVXWYXZY[Z]P^[_^`_a`bacbdcedfegfhgjkjlkmlnmonpoqprqsrtsv]wtxwyxzy{z|{}|~}~v `!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4` ~@@' ~@@'@ @@         @@@ @@@ @@@   @@@    @``````` ` ` ` ` ``````````````````` `! "!#"$#%$&%'&(')(*)+*,+-.,/0.102132435465768/97:9;@@@ @ <;=<>=?>@?!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4`5`6`7`8`9`:`;`<`=`>`?`@`A@BACBDCEDFEGFHGIHJ@@@  K@@ @ LIMLNMONPOQPR@@ @@ @ S@@@ @ TRU@ V@@ WVXWYXZY[Z\-]:^@@ _@@ @ @ @`^A`B`C`D`E`F`G`H`I`J`K`L`M`N`O`P`Q`R`S`T`U`V`W`X`Y`Z`[`\`]`^`_```a@@ @  @b@@ @ cbdce`f]g8hfi@@@ jikjlkmlnmonphqprqsrtsu\vuwtxey_zx{d|{}|~}zwa`b`c`d`e`f`g`h`i`j`k`l`m`n`o`p`q`r`s`t`u`v`w`x`y`z`{`|`}`~```y~g@@@@ ````````````````````````````````   @@ @@  @@@```````````````````````````````ao````````````````````````````````@@@ ````````````````````````````````@@@            ```````` ` ` ` ` ``````````````````` `! "!#"$#%$&%'&()(*)+,+-,.*/.0/102132435465768798:9;:<;=<>v?=@!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4`5`6`7`8`9`:`;`<`=`>`?`@`AB@C@@ @ @DEDFEGFHBI?JHKALJMGNMONPOQLRISQTKUSVPWVXWYXZU[R\][^]_^`_A`B`C`D`E`F`G`H`I`J`K`L`M`N`O`P`Q`R`S`T`U`V`W`X`Y`Z`[`\`]`^`_```a`bac\dbedfegfh@@@@@igjikjlkmlnmonpoqprqsrtsutvuwZxTywz{z|{}Y~}yva`b`c`d`e`f`g`h`i`j`k`l`m`n`o`p`q`r`s`t`u`v`w`x`y`z`{`|`}`~```  @@ @@ @@  @ @@"@ @@ ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `````````````@@ @@ @@ @  @c @ @ @ @!@ @ @ @ @ ```````````````````````` ```````` ``````````@@@@```````````````````` @ @``````` ````````````````````````` @@          ```````` ` ` ` ` ``````````````````` `! "!#"$#%$&%'&(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?>@?!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4`5`6`7`8`9`:`;`<`=`>`?`@`A@BACBDCEDFEGFHGIHJIKJLKMLNMtA`B`C`D`E`F`G`H`I`J`K`L`M`N` ~@'@@ @@ @@@ @ @ @ @ @ @@@ @ @ @@ @ @ @@ @ @      @@@ @     @@ @ @@ ! "!#"$#%$&%'& ```@@@``` ` ` ` ` ```````@@@@ @!@"@#@$@%@&@'@(')(*)+*,+-,.-/.0/102132435465768798:9;@@<@@= >@ @!?@@@@A@BAC@@DBEDFEGF(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@; `<@=`> ?`@`A`B`C`D`E`F`G`H@@@ IJIKJLKMLNMONPOQPRQSRTSUTVUWVXWYXZY[Z\[]\^]_^`_a`bacbdcedfegfH@I@J@K@L@M@N@O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@^@_@`@a@b@c@d@e@f@g@hgihjikjlkmlnm opnq@r@ @@s@@t@@@u@@@vtwuxvyxzw{y|z}{~}~ph@i@j@k@l@m@n@o @p@q`r s`t`u`v`w`x`y`z`{`|`}`~```@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @qrs@@@@@|@` `````````````````@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@`@"@@@@@@@ ```````````@@@@@@@@@@@@@@@@@@@@          @@@ @@! "!#@@$"%$&%'#@ @ @ @ @ @@@@@@@@@@@@@@ @@` ` `!`"`#`$`%`&`'`()(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?>@?A@BACBDCEDFEGF(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@@@A@B@C@D@E@F@G@HGIHJIKLJM=N>O@!P @@!@ QPR @@ SRTSUTV @@ WUXWYXZL[Z\[]\^]_^`_a`bacbdcedfegfH@I@J@K @L@M`N O`P`Q`R`S`T`U`V`W`X`Y`Z@[@\@]@^@_@`@a@b@c@d@e@f@g@hgihjikjlkmlnmonpoqprqsrtsutvuwvxwyxzy{z|{}|~}h@i@j@k@l@m@n@o@p@q@r@s@t@u@v@w@x@y@z@{@|@}@~@@@@@ ~@@'-^Project Investment Analysis SmartMaster^Table of Contents9^Click a tab or a button to use a SmartMaster sheet.'  'Sheet'Description%tCSheetnamel Project0'Analyze the value of two capital projects. 'Chart9'See a comparison of the two competing projects and 5 'associated net present values and payoffs here. 'Information? 'Help, tips, and details on file sharing, conventions, and& 'macros used in this SmartMaster.!^Project Investment Analysis'Project 1: 'Project 2: 'Description of Project 1'Description of Project 2! 'Justification for Project 1! 'Justification for Project 2^Cash Flow by Year^Cash Flow by Year^Project 1^Project 2^Investment^Cash Flow^Investment^Cash Flow@ @>@ @` @` @ @ @ @ @ @ @ @ @ @ @ @ @@ @@ @ ` @ ` @! @ ! @ !#'Cash flows at the start/end!#'Cash flows at the start/end $'of period (1=start, 0=end)$ $'of period (1=start, 0=end)$%'Cost of Capital%'Cost of Capital&'Discount Rate&'Discount Rate('Net Present ValueC(pC&&$z@<<@123>>NPV2(;(('Net Present ValueC(\C&&$z@<<@123>>NPV2(;()'Profitability Indexo)F>NPV2(&!$z@<<@123>>NPV2(;))'Profitability Indexo)C&&!$z@<<@123>>NPV2(&!$z@<<@123>>NPV2(;)*'Internal Rate of Return0*SC!R  Y;**'Internal Rate of Return3*C!R &Y;*+'Modified IRRJ+~C(%&$z@<<@123>>MIRR2(;++'Modified IRRJ+@^C(%&$z@<<@123>>MIRR2(;+,'Payback Period8,SC   T No Payback  T;,No Payback,'Payback Period 8,0C   T No Payback  T;,No Payback /'Summary4'Prepared By 4"Date4'Approved By 4"Date'SCREEN-ADJUST 'CODE'DESCRIPTION'\0'{ZOOM_TEST})'; Senses screen resolution and sets0'{Let ZM_NRML;@Vlookup(ZM_SCRN;ZM_TABLE;1)}$'; view preferences accordingly/'{Let ZM_ALL;@Vlookup(ZM_SCRN;ZM_TABLE;2)}.'{Set "Window-Custom-Zoom";ZM_NRML}{Quit}'ZOOM_TEST>'{If @Info("Screen-Width")<=640}{Let ZM_SCRN;640}{Return}> '{If @Info("Screen-Width")<=800}{Let ZM_SCRN;800}{Return}@ '{If @Info("Screen-Width")<=1024}{Let ZM_SCRN;1024}{Return} '{Let ZM_SCRN;1280}{Return} 'ZM_SCRN  "NORMAL"FULL PAGE'ZM_TABLE@@T\ 'ZOOM FACTOR 'CODE'DESCRIPTION'ZOOM_RTN-'{Set "Window-Custom-Zoom";ZM_ALL}{Quit})'; Sets view to display entire sheet 'ZM_NRML'; Preferred zoom setting 'ZM_ALL@'; View entire sheet'ZM_RESTORE:'{Set "Window-Custom-Zoom";ZM_NRML}{R}{L}{HOME}{Quit}'; Resets view to normal'PRINT SHEET 'CODE'DESCRIPTION'SHT_PRINTH'{Set "Print-Range";SHEET_RANGE}{Set "Print-Footer-Center-Text";""}'; Prints spreadsheet pageF'{Set "Print-Orientation";"Portrait"}{Set "Print-Fit-Page";"Yes"}$'{Set "Print-Margin-Top";".75"}C '{Set "Print-Margin-Left";".5"}{Set "Print-Margin-Right";".5"}'!'{Set "Print-Margin-Bottom";".25"}&"'{BACKGRND 0}{Print?}{BACKGRND 2} #'{Quit}%'BACKGRND%'{Define BCK_COL:V}-%'; Sets / Resets light yellow background&'{Let RNG_NUM;1}{BCK_LOOP}('BCK_LOOP>('{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+)'{If 1-@Isrange(@@(RNG_NAME))}{Return},*'{Style-Interior BCK_COL;;;;;+RNG_NAME}.+'{Let RNG_NUM;RNG_NUM+1}{Branch BCK_LOOP} -'BCK_COL-/'PRINT CHART /'CODE/'DESCRIPTION0'CHT_PRINTD0'{Select "CHART 1";;"Chart"}{Set "Print-Footer-Center-Text";""}50': Selects chart, sets orientation and margins, G1'{Set "Print-Orientation";"Landscape"}{Set "Print-Fit-Page";"Yes"}$1': and invokes the Print dialog$2'{Set "Print-Margin-Top";".75"}E3'{Set "Print-Margin-Left";".75"}{Set "Print-Margin-Right";".75"}'4'{Set "Print-Margin-Bottom";".25"}$5'{Print?}{Edit-Goto "Chart:A1"} 6'{Quit}8'PRINT INFORMATION 8'CODE8'DESCRIPTION9'INFO_PRINT9'{Define INFO_TOPIC:V}09'; Prints Topics from the Information sheet:'{Dialog DLG_INFOPRT};'{If RES_INFOPRT=0}{Quit}*<'{Set "Print-Footer-Center-Text";"^"})='{Set "Print-Centered";"Horizontal"}F>'{Set "Print-Orientation";"Portrait"}{Set "Print-Size";"Fit-All"}#?'{Set "Print-Margin-Top";".5"}C@'{Set "Print-Margin-Left";".5"}{Set "Print-Margin-Right";".5"}'A'{Set "Print-Margin-Bottom";".25"}&B'{Let UPPER_LEFT;@Info("Origin")}'C'{If ANS_INFOPRT=0}{INFO_CURR_PRT}?D'{If ANS_INFOPRT}{Select @Vlookup(INFO_TOPIC;INFO_LIST;1)}E'{Style-Interior 0}F'{Print?}G'{Style-Interior 2}H'{Edit-Goto +UPPER_LEFT} I'{Quit}K'INFO_CURR_PRTK'{Select INF_OVER_RANGE})K'; Prints all Information sheet text$L'{Select-Append INF_STEP_RANGE}$M'{Select-Append INF_TIPS_RANGE}$N'{Select-Append INF_CONVENTION}$O'{Select-Append INF_NOTE_RANGE}$P'{Select-Append INF_ABOU_RANGE}Q'{Return}S'UPPER_LEFTS'$E:$A$60U'INFO_LISTUU'INF_OVER_RANGE U'; Information sheet rangesVV'INF_STEP_RANGEWW'INF_TIPS_RANGEXX'INF_CONVENTIONY Y'INF_NOTE_RANGEZ Z'INF_ABOU_RANGE\'INFO_TOPIC\^'DLG_INFOPRT ^'DIALOG^'InfoPrint_p__~_|_0_T_'""_'""#_ '"Select Information to Print"_  `'FONT` `'"Helv"aaavaa(a@a'"button"a'"Current topic"a a bb*bpbb*b@b'"button"b'"All topics"b b cccPccc@c'"button" c'"OK"c dd,dPddd@d'"button"d'"Cancel"d e'END DIALOGg'SAMPLE DATA g'CODEg'DESCRIPTIONh'SAMPDATA=h'{Let CURR_SCEN;@Scenariolast(@Cellpointer("Filename"))}9h'; Displays Sample data, preserving existing entries5i'{If @Iserr(CURR_SCEN)}{Let CURR_SCEN;"unnamed"}:j'{If @Exact(CURR_SCEN;"sample")}{Branch SAMP_RESTORE}k'{Dialog DLG_SAMPLE1}l'{If RES_SAMPLE1=0}{Quit}m'{Let PREV_SCEN;CURR_SCEN}n'{UPDATE}*o'{Scenario-Show "sample"}{Calc}{Quit}q'SAMP_RESTOREq'{Dialog DLG_SAMPLE2}q'; Restores previous datar'{If RES_SAMPLE2=0}{Quit}+s'{Scenario-Show PREV_SCEN}{Calc}{Quit}u'PREV_SCEN u'unnamedv'CURR_SCEN v'samplex'DLG_SAMPLE1 x'DIALOG x'Sample1ypyyfyxy`yty'""y'""y '"Sample Data"y  z'FONTz z'"Helv"{{{{0{{@{'"static"m{'"You can use a set of sample data to see how this SmartMaster works. You can restore the data that is"{ |||P|||@|'"button" |'"OK"| }},}P}}}@}'"button"}'"Cancel"} ~~8~~4~~@~'"static"W~'"currently in this SmartMaster by clicking the Sample Data button a second time."~ 'END DIALOG'DLG_SAMPLE2 'DIALOG 'Sample2pdx`T'""'"" '"Sample Data"  'FONT '"Helv"0@'"static"['"Restore the data that was in this SmartMaster before you displayed the sample data?" P@'"button" '"OK" ,P@'"button"'"Cancel" 'END DIALOG'KEEP DATA 'CODE'DESCRIPTION'KEEPDATAG'{If @Count(SCENARIO_LIST)=@Rows(SCENARIO_LIST)-1}{Branch K_LIMIT}&'; Stores user-data in a scenario'{Dialog DLG_KEEPDATA}'{If RES_KEEPDATA=0}{Quit}*'{If RES_KEEPDATA=3}{Branch K_UPDATE}('{If RES_KEEPDATA=4}{Branch K_HELP}'{If @Length(@S(ANS_KEEPDATA))<1}{Alert "To create a scenario, you must enter a scenario name. Press OK to return to the Keep Data dialog box."}{Branch KEEPDATA}Z'{If 1-@Iserr(@Scenarioinfo("Creator";@Lower(@Trim(ANS_KEEPDATA))))}{Branch K_EXISTS}3'{Scenario-Create @Lower(@Trim(ANS_KEEPDATA))}!'{Let RNG_NUM;1}{K_VERSIONS}>'{Put SCENARIO_LIST;0;@Count(SCENARIO_LIST);ANS_KEEPDATA}1'{Scenario-Show @Lower(@Trim(ANS_KEEPDATA))}'{Calc}{Return}'K_UPDATE&'{CLEAN_LIST}{Dialog DLG_UPDDATA}#'; Check for deleted scenarios'{If ANS_UPDDATA<0}{Quit}'{If RES_UPDDATA=0}{Quit}H'{Scenario-Delete @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}H'{Scenario-Create @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}"'{Let RNG_NUM;1}{UP_EXISTING}L'{Scenario-Show @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}{Quit}'CLEAN_LIST'{Blank ANS_SWAPDATA}'CLEAN_LOOP3'{If ANS_SWAPDATA>@Count(UPDATE_LIST)}{Return}'{If 1-@Iserr(@Scenarioinfo("Creator";@Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))))}{Let ANS_SWAPDATA;ANS_SWAPDATA+1}{Branch CLEAN_LOOP}U'{Recalc LIST_RNG}{Edit-Copy +LIST_RNG}{Recalc LIST_ADDR}{Edit-Paste +LIST_ADDR}'{Branch CLEAN_LOOP}'UP_EXISTING>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}Q'{Version-Delete +RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}Q'{Version-Create +RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}'{Scenario-Add-Version @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)));;+RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}1'{Let RNG_NUM;RNG_NUM+1}{Branch UP_EXISTING} 'K_HELP'{Dialog DLG_KHELP}'{Branch KEEPDATA} 'K_LIMIT'{Alert +"The maximum number of "&@String(@Count(SCENARIO_LIST);0)&" scenarios is in use. You must delete a scenario before creating a new one."} '{Quit}'K_EXISTSw'{Alert +""""&@Lower(@Trim(ANS_KEEPDATA))&""" already exists. Please use another scenario name."}{Branch KEEPDATA}'K_VERSIONS>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}<'{Version-Create +RNG_NAME;@Lower(@Trim(ANS_KEEPDATA))}_'{Scenario-Add-Version @Lower(@Trim(ANS_KEEPDATA));;+RNG_NAME;@Lower(@Trim(ANS_KEEPDATA))}0'{Let RNG_NUM;RNG_NUM+1}{Branch K_VERSIONS} 'RNG_NUM"'RNG_NAME 'DATA_17'DLG_KEEPDATA 'DIALOG'KeepDatap(@'""'"" '"Keep Data"  'FONT '"Helv">@ '"edit"'"" (P@'"button" '"OK" (DP@'"button"'"Cancel" ($P@'"button"'"Update..." (hP@'"button" '"Help" @$@'"static"E'"You can create a new scenario or update an existing scenario." 0@'"static"y'"This SmartMaster can keep more than one set of data in this file. Each set of data you keep is called a scenario." l@'"static"*'"Enter a name for the new scenario:" 'END DIALOG'DLG_UPDDATA 'DIALOG 'UpdateplH'""'"" '"Update"  'FONT '"Helv"H`RFB@'"listbox"'""  'UPDATE_LIST0@'"static"['"Select the scenario you want to update with the data currently in this SmartMaster." , P@'"button" '"OK" ,,P@'"button"'"Cancel" 'END DIALOG'DLG_KHELP 'DIALOG 'KHELPp*@d'""'"" '"Keep Data Help"  'FONT '"Helv"(P@'"button" '"OK" T@'"static"'For more information on using Version Manager to create scenarios and share information, search on "Version Manager" in Help. 'END DIALOG'SWAP DATA 'CODE'DESCRIPTION'SWAPDATA''{CLEAN_LIST}{Dialog DLG_SWAPDATA}3'; Switches to a scenario selected by the user'{If ANS_SWAPDATA<0}{Quit}'{If RES_SWAPDATA=0}{Quit}.'{If RES_SWAPDATA=3}{Branch DEL_SCENARIO}='{Let CURR_SCEN;@Scenariolast(@Cellpointer("Filename"))}5'{If @Iserr(CURR_SCEN)}{Let CURR_SCEN;"unnamed"}''{If CURR_SCEN<>"unnamed"}{UPDATE}%'{If CURR_SCEN="unnamed"}{UPDUN}I'{Scenario-Show @Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}C'{If @Scenariolast(@Cellpointer("Filename"))<>"-blank-"}{Quit}<'{Scenario-Delete "unnamed"}{Scenario-Create "unnamed"}F'{Let RNG_NUM;1}{UP_UNNAMED}{Scenario-Show "unnamed"}{Calc}{Quit} 'UPDUN'{Dialog DLG_UPDUN}'{If RES_UPDUN=3}{Quit} '{If RES_UPDUN=1}{KEEPDATA}'{Let RES;1}{Return}'UP_UNNAMED>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}*'{Version-Delete +RNG_NAME;"unnamed"}*'{Version-Create +RNG_NAME;"unnamed"};'{Scenario-Add-Version "unnamed";;+RNG_NAME;"unnamed"}0'{Let RNG_NUM;RNG_NUM+1}{Branch UP_UNNAMED}'LIST_RNG;CSheet'lCol'lRow'lC ..Sheet'lCol'lRow'l'RD:B264..D:B264'LIST_ADDRL24CSheet'lCol'lRow'lC  D:B263 'RES'DEL_SCENARIO'{If ANS_SWAPDATA<1}{Alert "The scenario named ""-Blank-"" cannot be deleted. This scenario is used to clear data from the SmartMaster and create a blank, unnamed scenario."}{Branch SWAPDATA}k'{Alert +"Delete """&@Index(SCENARIO_LIST;0;ANS_SWAPDATA)&""" scenario?";2;"Stop";RES}{If 1-RES}{Quit}K'{Scenario-Delete @Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}!'{Let RNG_NUM;1}{D_VERSIONS}Y'{If ANS_SWAPDATA=@Count(SCENARIO_LIST)-1}{Recalc LIST_ADDR}{Blank +LIST_ADDR}{Quit},'{Recalc LIST_RNG}{Edit-Copy +LIST_RNG}/'{Recalc LIST_ADDR}{Edit-Paste +LIST_ADDR} '{Quit}'D_VERSIONS>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}T'{Version-Delete +RNG_NAME;@Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}0'{Let RNG_NUM;RNG_NUM+1}{Branch D_VERSIONS}'SCENARIO_LIST '-Blank-@&d'UPDATE_LISTt'' < Blank Cell. To increase limit, 1) place cell pointer on blank cell, and 2) insert as many rows as you like. )'UPDATE3)'{Let RNG_NUM;1}{Blank NO_UPDATE}{UPDATE_TEST}*'{If NO_UPDATE}{Return}-+'{If @Exact(CURR_SCEN;"sample")}{Return};,'{If @Exact(CURR_SCEN;"unnamed")}{UPDATE_POST}{Return}*-'{Recalc FRM_UPDSC}{Dialog DLG_UPDSC}.'{If RES_UPDSC=3}{Quit}#/'{If RES_UPDSC=1}{UPDATE_POST}0'{Return}2'UPDATE_TEST>2'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}<3'{If 1-@Isrange(@@(RNG_NAME))}{Let NO_UPDATE;1}{Return}84'{If @Iserr(@Versioncurrent(@@(RNG_NAME)))}{Return}15'{Let RNG_NUM;RNG_NUM+1}{Branch UPDATE_TEST}7'UPDATE_POST*7'{Version-Update +RNG_NAME;CURR_SCEN}8'UPDATE_LOOP8'{Let RNG_NUM;RNG_NUM+1}>9'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+:'{If 1-@Isrange(@@(RNG_NAME))}{Return}D;'{If @Iserr(@Versioncurrent(@@(RNG_NAME)))}{Branch UPDATE_POST}<'{Branch UPDATE_LOOP}>'NO_UPDATE>@'DLG_SWAPDATA @'DIALOG@'SwapDataApA AjAHAAA'""A'""A '"Swap Data"A A 'RES_SWAPDATA B'FONTB B'"Helv"CC4CCtCRFCB@C'"listbox"C'""C C 'SCENARIO_LISTC C 'ANS_SWAPDATADDDD$DD@D'"static"CD'"Select the scenario you want to swap into this SmartMaster."D E,E EPEEE@E'"button" E'"OK"E F,F,FPFFF@F'"button"F'"Cancel"F G,GTGPGGG@G'"button"G'"Delete"G H'END DIALOGJ'DLG_UPDSC J'DIALOG J'Update1KpKKKbKhKtK'""K'""K '"Update Scenario"K  L'FONTL L'"Helv"MM MMXMM@M'"static"RM /C:The scenario named "v" has changed. Update "v?">MThe scenario named "sample" has changed. Update "sample?"M NNNPNNN@N'"button" N'"Yes"N OO$OPOOO@O'"button" O'"No"O PPNPPPPP@P'"button"P'"Cancel"P Q'END DIALOGS'DLG_UPDUN S'DIALOG S'unnamedTpTTTxTTtT'""T'""T '"Update Scenario"T  U'FONTU U'"Helv"VVVV6VV@V'"static"CV'"The current scenario is unnamed. Assign a name and keep it?"V WWWPWWW@W'"button" W'"Yes"W XX$XPXXX@X'"button" X'"No"X YYNYPYYY@Y'"button"Y'"Cancel"Y Z'END DIALOG\'SHOW MACROS \'CODE\'DESCRIPTION]'MACRO_SHOW]'{Show-Sheets MACROS:A1}%]'; Show / Hide this Macros sheet!^'{Edit-Goto MACROS:A1}{Quit}`'MACRO_HIDE#`'{Home}{Hide-Sheets MACROS:A1}&a'{Edit-Goto INFORMATION:A1}{Quit}c'SHOW NOTES FIELDS c'CODEc'DESCRIPTIONd'NOTES_SHOWd'{Show-Sheets MACROS:A1}'d'; Navigate to the Notes/FX fieldse'{Edit-Goto NOTES_FIELDS}&f'{Edit-Goto "NOTES FIELDS"}{Quit}h'PRINT MACROS h'CODEh'DESCRIPTIONi'MACRO_PRINTi'{Dialog DLG_MACPRINT})i'; Print sections of the macro sheetj'{If RES_MACROPRT=0}{Quit}]k'{If ANS_MACROPRT1}{Set "Print-Range";MACROS_RANGE}{Set "Print-Orientation";"Landscape"}\l'{If ANS_MACROPRT2}{Set "Print-Range";NOTES FIELDS}{Set "Print-Orientation";"Portrait"}^m'{If ANS_MACROPRT3}{Set "Print-Range";RN_TABLE_RANGE}{Set "Print-Orientation";"Portrait"})n'{Set "Print-Centered";"Horizontal"}*o'{Set "Print-Footer-Center-Text";"^"}&p'{Set "Print-Size";"Fit-Columns"}#q'{Set "Print-Margin-Top";".5"}Cr'{Set "Print-Margin-Left";".5"}{Set "Print-Margin-Right";".5"}'s'{Set "Print-Margin-Bottom";".25"}t'{Print?} u'{Quit}w'DLG_MACPRINT w'DIALOGw'MacPrintxpx xx|x0xTx'""x'""#x '"Select Information to Print"x  y'FONTy y'"Helv"zzzvzz(z@z'"button"z'"Macros"z {{{{{*{@{'"button"{'"Notes Fields"{ ||4|||,|@|'"button"|'"Range Name Table"| }}}P}}}@}'"button" }'"OK"} ~~,~P~~~@~'"button"~'"Cancel"~ 'END DIALOG'END OF MACROS'Cash Flow Table"CF-Inv, P1"CF-Inv, P2    !!!!^End of Period^End of Period^Start of Period^Start of Period^Use in Graph^Use in Graph^Payback Period^NPV of CF, P1^NPV of CF, P2^NPV of CF, P1^NPV of CF, P2^NPV of CF, P1^NPV of CF, P2^ST payback 1 ^ST payback 2 ^LT payback 1 ^LT payback 2@ @7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;.1   ;;. 1   ;;) S  ;)   S   ;` @7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S   T  ;: ? S   T   ; @7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S ?  T  ;: ? S ?  T   ; @7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S ?  T  ;: ? S ?  T   ; @7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S ?  T  ;: ? S ?  T   ; @ 7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S ?  T  ;: ? S ?  T   ; @ 7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S ?  T  ;: ? S ?  T   ; @7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S ?  T  ;: ? S ?  T   ;@ @7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S ?  T  ;: ? S ?  T   ;` @7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;: S ?  T  ;: ? S ?  T   ; @7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(7&z@<<@123>>NPV2(7&z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;  7& z@<<@123>>NPV2(7& z@<<@123>>NPV2(&$ ;&$ ;5 $  ; ;5  $  ; ;  'NOTES FIELDS'Num_User_Scenarios'R'Current_Scenario7FilenameOz@<<@123>>SCENARIOLAST('Project_Name_1vCo 'NPV_1C( 'PI_1`C) 'IRR_1wC* 'MIRR_1tC+'Payback_1C ,No Payback'Project_Name_2Co 'NPV_2C( 'PI_2]C) 'IRR_2C* 'MIRR_2ZC+'Payback_20C ,No Payback'Prepared_BypC33o'Prepared_Date3'ANS_INFOPRT'D:L98..D:L98'ANS_KEEPDATA'D:L193..D:L193'ANS_MACROPRT1'D:L379..D:L379'ANS_MACROPRT2'D:L380..D:L380'ANS_MACROPRT3'D:L381..D:L381'ANS_SWAPDATA'D:L324..D:L324'ANS_UPDDATA'D:L206..D:L206'BACKGRND'D:B38..D:B38 'BCK_COL'D:B46..D:B46'BCK_LOOP'D:B41..D:B41'CHT_PRINT'D:B49..D:B49'CLEAN_LIST'D:B160..D:B160'CLEAN_LOOP'D:B161..D:B161'CURR_SCEN'D:B119..D:B119 'DATA_01'B:B7..B:B11 'DATA_02'B:B14..B:B18 'DATA_03'B:B24..B:B24 'DATA_04'B:C24..B:D34 'DATA_05'B:D38..B:D39 'DATA_06'B:G7..B:G11 'DATA_07'B:G14..B:G18 'DATA_08'B:H24..B:I34 'DATA_09'B:I38..B:I39 'DATA_10'B:C48..B:C50 'DATA_11'B:B52..B:B52 'DATA_12'B:D52..B:D52 'DATA_13'B:G52..B:G52 'DATA_14'B:I52..B:I52 'DATA_15'B:H4..B:H4 'DATA_16'B:C4..B:C4'DEL_SCENARIO'D:B249..D:B249'DLG_INFOPRT'D:B95..D:B95 'DLG_KEEPDATA 'D:B190..D:B190 'DLG_KHELP 'D:B212..D:B212 'DLG_MACPRINT 'D:B376..D:B376 'DLG_PERSONAL 'D:B389..D:B389 'DLG_SAMPLE1 'D:B121..D:B121'DLG_SAMPLE2'D:B130..D:B130'DLG_SWAPDATA'D:B321..D:B321'DLG_UPDDATA'D:B203..D:B203'DLG_UPDSC'D:B331..D:B331'DLG_UPDUN'D:B340..D:B340'D_VERSIONS'D:B258..D:B258'FRM_UPDSC'D:I334..D:I334'INFORMATION'E:A1..E:A1'INFO_ABOUT'E:A329..E:A329'INFO_CONVENTION'E:A223..E:A223'INFO_CURR_PRT'D:B76..D:B76'INFO_LIST'D:B86..D:C91'INFO_NOTESFX'E:A281..E:A281'INFO_OVERVIEW'E:A60..E:A60'INFO_PRINT'D:B58..D:B58'INFO_STEPS'E:A112..E:A112'INFO_TIPS'E:A168..E:A168'INFO_TOPIC'D:B93..D:B93 'INF_ABOU_RANGE 'E:B331..E:H343!'INF_CONVENTION!'E:B229..E:H241"'INF_NOTE_RANGE"'E:B283..E:H293#'INF_OVER_RANGE#'E:B62..E:H72$'INF_STEP_RANGE$'E:B114..E:H129%'INF_TIPS_RANGE%'E:B170..E:H185&'KEEPDATA&'D:B139..D:B139''K_EXISTS''D:B179..D:B179 ('K_HELP('D:B173..D:B173 )'K_LIMIT)'D:B176..D:B176*'K_UPDATE*'D:B152..D:B152+'K_VERSIONS+'D:B181..D:B181,'LIST_ADDR,'D:B246..D:B246-'LIST_RNG-'D:B245..D:B245 .'MACROS.'D:A1..D:A1/'MACROS_RANGE/'D:A3..D:L4060'MACRO_HIDE0'D:B353..D:B3531'MACRO_PRINT1'D:B362..D:B3622'MACRO_SHOW2'D:B350..D:B3503'NOTES FIELDS3'D:A444..D:B4594'NOTES_FIELDS4'D:A442..D:A4425'NOTES_SHOW5'D:B357..D:B3576'NO_UPDATE6'D:B319..D:B3197'PERSONALIZE7'D:B387..D:B3878'PREV_SCEN8'D:B118..D:B118 9'PROJECT9'B:A1..B:A1 :'RES:'D:B247..D:B247;'RES_INFOPRT;'D:L96..D:L96<'RES_KEEPDATA<'D:L191..D:L191='RES_MACROPRT='D:L377..D:L377>'RES_SAMPLE1>'D:L122..D:L122?'RES_SAMPLE2?'D:L131..D:L131@'RES_SWAPDATA@'D:L322..D:L322A'RES_UPDDATAA'D:L204..D:L204B'RES_UPDSCB'D:L332..D:L332C'RES_UPDUNC'D:L341..D:L341D'RNG_NAMED'D:B188..D:B188 E'RNG_NUME'D:B187..D:B187F'RN_TABLEF'D:A489..D:A489G'RN_TABLE_RANGEG'D:A490..D:B606H'SAMPDATAH'D:B105..D:B105I'SAMP_RESTOREI'D:B114..D:B114J'SCENARIO_LISTJ'D:B263..D:B296K'SHEET_RANGEK'B:B2..B:J53L'SHT_PRINTL'D:B30..D:B30M'SWAPDATAM'D:B220..D:B220N'TABLE_CONTENTSN'A:A1..A:A1 O'UPDATEO'D:B298..D:B298P'UPDATE_LISTP'D:B264..D:B296Q'UPDATE_LOOPQ'D:B313..D:B313R'UPDATE_POSTR'D:B312..D:B312S'UPDATE_TESTS'D:B307..D:B307 T'UPDUNT'D:B233..D:B233U'UPPER_LEFTU'D:B84..D:B84V'UP_EXISTINGV'D:B166..D:B166W'UP_UNNAMEDW'D:B238..D:B238 X'ZM_ALLX'D:B25..D:B25 Y'ZM_NRMLY'D:B24..D:B24Z'ZM_RESTOREZ'D:B27..D:B27 ['ZM_SCRN['D:B14..D:B14\'ZM_TABLE\'D:B16..D:D19]'ZOOM_RTN]'D:B22..D:B22^'ZOOM_TEST^'D:B9..D:B9_'\0_'D:B4..D:B4^Information ^Index(^Click a button to go to a subject. 'Subject'Description'Overview1'General information about this SmartMaster. 'Steps)'Procedures to use this SmartMaster. 'Tips/ 'Helpful hints for using this SmartMaster. 'Conventions6 'Details on conventions used in this SmartMaster.'Notes/FX Enabling3'Description of Notes/FX and available fields. 'Macros;'Individual macro commands and their descriptions used'in this SmartMaster. 'About:'Information about the developer of this SmartMaster.2>^Overview: The Project Evaluation SmartMasterj@'The Project Evaluation SmartMaster examines two competing investments using net present value (NPV),wA'internal rate of return (IRR), modified internal rate of return (MIRR), profitability index (PI), accounting rate#B'of return (ARR), and payback.rD'All entries in the sheet should be positive. Interest rates are calculated on an annual basis. Cash flows iE'are assumed to occur at the beginning of the period, for a maximum of 10 future periods. To see a FF'visual comparison of the two investments, see the Chart sheet. 5r^Steps: Using the Project Evaluation SmartMasterPt'1. Enter the project names in the description column of the Project sheet.-v'2. Enter a description of each project.ux'3. Enter all investment data for each project in the "Investment" column of the respective "Cash Flow by Year" y' table.r{'4. Enter all cash flows you expect each project to generate. You can enter actual cash flows as they occur.l}'5. In the summary section located at the bottom of the Project sheet, enter your own notes about the j~' comparison of the two competing projects, for example why one was selected over the other, or an :' explanation of underlying assumptions or figures. ^Tipsp' Cells B:D37 and B:I37 determine whether cash flows are calculated based on the beginning or end of thex' period. By default, these cells are set to a value of 1 (one), to calculate cash flows at the beginning of thep' period. This convention is common among popular financial calculators. To calculate cash flows at thet' end of the period, change the value in these cells to 0 (zero). This is consistent with the conventions of#' earlier releases of 1-2-3.u' Profitability Index is the measurement of total dollars returned as compared to the total dollars invested.D' The higher the resulting number, the better the investment.y' If @IRR cannot approximate the result after 30 calculation iterations, the result is ERR. For more information7' on using @IRR, search on "@Functions" in Help.V' Don't forget to include tax savings on depreciation as a positive cash flow.N' Most analysts prefer NPV as the preferred measurement for projects.^Conventions'Cell Typesi'Shaded cells are data entry areas. Outlined cells contain formulas that are automatically computed.'Printing.'All forms print in portrait orientation. 'Dates!'Enter the date as MM/DD/YY.*^Using this SmartMaster with Notes/FXn 'Notes/FX lets you exchange data between applications by embedding the data as an object in a Notes form.p!'In 1-2-3, the range called "Notes Fields" can be made available to Notes for exchanging data between Notes"'and the spreadsheet. i$'This SmartMaster contains fields that can be used for Notes/FX applications. To see the range namedp%'"Notes Fields," click on the Notes Fields button. For more information about using Notes/FX, see the Notes&'documentation.N^About this SmartMasteriP'This SmartMaster was developed by Lotus in cooperation with KMT Software, Inc. KMT Software is the mQ'developer of several add-on products that are marketed under the Lotus name through Lotus Selects. KMT nR'Software has worked closely with Lotus to develop the Lotus SmartMaster Collection for 1-2-3 Release 5, gS'a collection of dozens of additional SmartMaster templates. The Lotus SmartMaster Collection for fT'1-2-3 Release 5 includes SmartMaster templates to help you manage your business as well as your %U'personal planning and finances.kW'To order or learn more about the Lotus SmartMaster Collection for 1-2-3 Release 5, in the U.S. pleaseLX'call Lotus Selects at 1-800-635-6887. In Canada, call 1-800-GO-LOTUS.-U_ ArialSWISSSWISSSWISSSWISSSWISSSWISSSWISS      O=G4!*@Jq'MY|^|5 _-oZ/j(5 u|xd2.' >{Home}{Edit-Goto Project:A1}8 .*5 u|xd2.+ >"{Home}{Edit-Goto INFORMATION:A1} 8  .*5 2u|xd2.% >{Home}{Edit-Goto Chart:A1}8 .*5 _{oZaJ?Ov?yx<< '@#5 K5x6C# Keep Data{Branch KEEPDATA}q F5 ž x^C# Swap Data{Branch SWAPDATA} wF5 z  xUC"Chart{Edit-goto CHART:A1}  8)5 c]jxIC. Information{Edit-Goto Information:A1} K5 63xIC% Sample Data{Branch SAMPDATA} qR5 j_fxd2CZoom{Branch ZOOM_RTN}  *5 QQDyxeR(Restore Zoom{Branch ZM_RESTORE}' o-oQ 5 7^Pgxw'+0"Tips{Edit-Goto INFO_TIPS}"^$#5 8e| xUC Print{Branch SHT_PRINT}8 9)? _www3 Vx hCHART 1CHART 1ddDF|2b"DF|2bh@A(D? Ov?X x<<D,5  L Vx6C# Keep Data{Branch KEEPDATA} F5 *b$x^C# Swap Data{Branch SWAPDATA} }F5 +*DxUC1Print%{SELECT "CHART 1";;"CHART"}{PRINT} K.5 ,ldpxIC. Information{Edit-Goto Information:A1}Q wK5 .$ :"xIC% Sample Data{Branch SAMPDATA} T5 0n|xd2CZoom{Branch ZOOM_RTN}w  +5 1 xe/(Restore Zooma{Branch ZM_RESTORE}  aK5  {LwZaEV2?Ov x<<>*Z*5  {LwZaEV2?Ovd)x/><<K(]'5 !z x"UC"Print{Branch MACRO_PRINT} "15 "3&Vx/>IC' Hide Macros{Branch MACRO_HIDE} "T5 &Rx/>UC-Range Name Table{Edit-Goto RN_TABLE} !p5 '|:x/>UCGNotes Fields 4{Edit-Goto NOTES_FIELDS}{Edit-Goto "NOTES FIELDS"} d!Q5  |_1ZaE\? Ov x<<>*Z*5 $zUxO0I)' Information{Branch MACRO_HIDE} #N5 ( xO0U)"Print{Branch MACRO_PRINT} ,#,5 /D 5 xO0UCReturn to Macros{Home}2 #l5 #zUxO0I)' Information{Branch MACRO_HIDE} #N5 ) xO0U)"Print{Branch MACRO_PRINT} ,#,5 -A  xO0U)Return to Macros{Home}> #k4   =H 4  q4  4  (4  "MZ"4  885 _޸|wZa& A/5 u|xd2.$ >{Edit-Goto INFO_OVERVIEW}8 .*5 _8fN xZaE;<$<?OvIxw<<;$;'@5 _8f֋ wZaEop$5?Ov˞CRxw<<oo&A5 _8f֋ wZaE$55 _8f֋ wZaE$5?Ov?CRVxw<< &A5 $m=C(xwUC.Notes Fields{Home}{Branch NOTES_SHOW}  y*5 _8f֋ wZaEKL$5?Ov͞CRVxw<<KK&A5 %pxo&)5Go to Project Analysis{Home}{Edit-Goto B:A1}5 u|xd2.! >{Edit-Goto INFO_STEPS}8 .*5  u|xd2.  >{Edit-Goto INFO_TIPS} 8  .*5 u|xd2.# >{Edit-Goto INFO_NOTESFX}8 .*5 u|xd2.$ >{Home}{Branch MACRO_SHOW}8 .*5 u|xd2.! >{Edit-Goto INFO_ABOUT}8 .*5 }6#xoUCPrint{INFO_PRINT 1}; ; *5 a~k xod2C Information Index{Home};X ; i5 xoIC3Return to Project AnalysisA{Edit-Goto B:A1}; ;X 5  }6#xoUCPrint{INFO_PRINT 2}o o *5 a~k xod2C Information Index{Home}oX o i5 xoIC3Return to Project AnalysisA{Edit-Goto B:A1}o oX ?Ov?x<<(<#5 };#xUCPrint{INFO_PRINT 3}  )5 y~kigxd2C Information Index{Home}?  k5 >xIC3Return to Project AnalysisA{Edit-Goto B:A1} ? 5 }6#xoUCPrint{INFO_PRINT 5}  *5 a~k xod2C Information Index{Home}X  i5 xoIC3Return to Project AnalysisA{Edit-Goto B:A1} X 5 }6#xoUCPrint{INFO_PRINT 6}K K *5 a~k xod2C Information Index{Home}KX K i5 xoIC3Return to Project AnalysisA{Edit-Goto B:A1}K KX 5 3u|xd2.& >{Edit-Goto INFO_CONVENTION} 8  .*? OvHx<<  ?*5 4T~v;qjGxUCPrint{INFO_PRINT 4}*5 57Sxd2C Information Index{Home}?k5 6*ixIC3Return to Project AnalysisA{Edit-Goto B:A1}?? _++ %+UtUse this SmartMaster to help you choose between two projects based on the analysis of the two competing investments.Analyze Competing Projects Scott TuckerALIASDefaultALIAS Erin LimanLotus NotesELIMANLAN Manager Paul MoodyLotus NotesErin LimanALIAS"Scott TuckerLotus NotesJeff KahnLotus Notes! SmartMasterLotus Notes) Karen Vona McIntyreLotus Notes/l׍u@C:\SM4\BALSHEET.WK4m ar@D:\DARWIN\WORK\KMT2\BALSHEET.WK4@43F2?j/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: UUUUU@D:\DARWIN\WORK\/B:\NEW_BAL.WK4J DOfq@B:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: Ε$s@D:\DARWIN\WORK\/B:\NEW_BAL.WK4J !-Cs@B:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: SY܏+@D:\DARWIN\WORK\/A:\NEW_BAL.WK4J I+@A:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: F+@D:\DARWIN\WORK\/A:\NEW_BAL.WK4K ףp= +@A:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL2.WK4< :b߱ي/@D:\DARWIN\WORK\K/A:\NEW_BAL2.WK4L 5F/@A:\NEW_BAL2.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL2.WK4<  \/@D:\DARWIN\WORK\K/A:\NEW_BAL2.WK4< G;6v0@C:\123R4W\PROGRA/A:\BALSHEET.WK4? Qߦz0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< - {0@I:\KMT\BALSHEET./A:\BALSHEET.WK4? 7&{0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< 8e|{0@I:\KMT\BALSHEET./A:\BALSHEET.WK4? y@Ε0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< xV40@I:\KMT\BALSHEET./A:\BALSHEET.WK4E =e1@A:\BALSHEET.WK4/D:\DARWIN\WORK\NEW_SM.WK4T T`w1@D:\DARWIN\WORK\NEW_SM.WK4/D:\DARWIN\WORK\KMT2\NEW_SM.WK4@ A01@D:\DARWIN\WORK\KMT/I:\KMT\NEW_SM.WK4? SA@A:\PAUL.WK4/D:\DARWIN\WORK\PAUL.WK44 A@D:\DARWIN\WO/B:\PAUL.WK4? RA@B:\PAUL.WK4/D:\DARWIN\WORK\PAUL.WK44 l(B@D:\DARWIN\WO/A:\PAUL.WK4? ]B@A:\PAUL.WK4/C:\123R4W\WORK\PAUL.WK4Y """""B@D:\CSERVE\DOWNLOAD\PAUL.WK4/D:\FORMS\SSPC\SHEETS\AUTOZOOM.WK4O ŝ ND@D:\FORMS\SSPC\SHEETS\A)/D:\FORMS\SM_MAS02.WK4G 贁N D@D:\FORMS\SM_MAS02.WK4/D:\FORMS\SM_MAS03.WK4E y58O@C:\DATA\SM_MAS03.WK4/C:\DATA\SM_MAS04.WK4G yKs¦R@D:\FORMS\SM_MAS04.WK4/D:\FORMS\SM_MAS05.WK4G djR@D:\FORMS\SM_MAS05.WK4/D:\FORMS\SM_MAS06.WK4G bR@D:\FORMS\SM_MAS06.WK4/D:\FORMS\SM_MAS07.WK4G n;S@D:\FORMS\SM_MAS07.WK4/D:\FORMS\SM_MAS08.WK4S oi^S@D:\FORMS\SM_MAS08.WK4/D:\FORMS\SSPC\SHEETS\SM_MAS09.WK4_ ħS@D:\FORMS\SSPC\SHEETS\SM_MAS09.WK4/D:\FORMS\SSPC\SHEETS\SM_MAS10.WK4W tľX@D:\FORMS\SM_MASTR\INVOICE.WK4/D:\FORMS\SM_MASTR\INVOIC2.WK4W lUJd@D:\FORMS\SM_MASTR\INVOICE.WK4/D:\FORMS\SM_MASTR\INVOIC3.WK4U Sd@C:\DATA\SM_MASTR\INVOIC3.WK4/C:\DATA\SM_MASTR\INVOIC4.WK4U ~9xf@C:\DATA\SM_MASTR\INVOIC4.WK4/C:\DATA\SM_MASTR\INVOIC5.WK4V  f@C:\DATA\SM_MASTR\INVOIC6.WK7/C:\DATA\SM_MASTR\SHELL.WK4D vsi@A:\SHELL.WT4/C:\RAPTOR\MASTERS\SHELL.WT48 Ukטp@C:\RAPTOR\MASx/A:\SHELL.WT4Q 8Z~@C:\DATA\SMASTER\SHELL.WT4/C:\DATA\SMASTER\PROJECT.WT4? rE.@A:\PROJECT.W02 E$2G?/A:\JEFF.WK44 =@A:\JEFF.WK4/A:\JEFF2.WK4A Sd@A:\JEFF2.WK4/C:\RAPTOR\WORK\JEFF2.WK4P  @C:\RAPTOR\WORK\JEFF2.WK4/C:\RAPTOR\MASTERS\JEFF3.WK4U BS@C:\RAPTOR\MASTERS\JEFF3.WK4/C:\RAPTOR\MASTERS\PROJECT.WT4T $~@D:\JEFF\PROJECT.WT4/D:\FEDERALW\93\DATABASE\FILE0001.WK4e MG;6@D:\FEDERALW\93\DATABASE\FILE0001.WK4/D:\FEDERALW\93\DATABASE\PROJECT1.WK4U F b@C:\RAPTOR\WORK\PROJECT1.WK4/C:\RAPTOR\MASTERS\PROJECT.WT4X pHm@C:\RAPTOR\MASTERS\PROJECT.WT4/C:\RAPTOR\ADD_PERS\PROJECT.WT4f +Hm@C:\RAPTOR\ADD_PERS\PROJECT.WT4JNh2zMvKN/C:\RAPTOR\MASTERS\PROJECT.WT4L 'I@C:\RAPTOR\MASTE=?=A#H2U =/A:\PROJECT.WT4H -@A:\PROJECT.WT4/C:\RAPTOR\MASTERS\PROJECT.WT4O rq}@E:\GOLDSM\PROJECT.WT4/E:\123R4W\MASTERS\PROJECT.WT4P @E:\SMASTER\PROJECT.WT4/C:\RAPTOR\MASTERS\PROJECT.WT4Y )F @E:\GOLDSM\WO_SELEC\PROJECT.WT4/E:\123R4W\MASTERS\PROJECT.WT4` Ro@M:\GOLD_FIL\SMASTER\OLD\PROJECT.(6o^/M:\GOLD_FIL\SMASTER\PROJECT.WT4"%DATA_09unnamed sampleDATA_09%sampleDATA_09Sample Data3 ~@sampleDATA_09sample %5 &' testDATA_09/@testDATA_09test % &I -blank-DATA_09%-blank-DATA_09Blank Data5'Tk׶~@-blank-DATA_09-blank- % & unnamedDATA_095rE.@unnamedDATA_09unnamed % & DATA_08 sampleDATA_08%sampleDATA_08Sample Data3 ~@sampleDATA_08sample   ]     N      !   C ] } ] ' p c   ! testDATA_08/@testDATA_08test   ]     N      !   C ] } ] ' p c   ! -blank-DATA_08%-blank-DATA_08Blank Data5'Tk׶~@-blank-DATA_08-blank-            !            !  unnamedDATA_085rE.@unnamedDATA_08unnamed            !            !"DATA_16unnamed sampleDATA_16%sampleDATA_16Sample Data3ϕ$~@sampleDATA_16sample "'Three-ringed Velicopator testDATA_16/@testDATA_16test "'Three-ringed Velicopator -blank-DATA_16%-blank-DATA_16Blank Data54ض~@-blank-DATA_16-blank-  unnamedDATA_165rE.@unnamedDATA_16unnamed " DATA_07unnamed sampleDATA_07%sampleDATA_07Sample Data3 ~@sampleDATA_07sample 7 'Increased capacity and flexibility for future 'contract changes.    testDATA_07/@testDATA_07test 7 'Increased capacity and flexibility for future 'contract changes.    -blank-DATA_07%-blank-DATA_07Blank Data5'Tk׶~@-blank-DATA_07-blank-       unnamedDATA_075rE.@unnamedDATA_07unnamed      "DATA_06unnamed sampleDATA_06%sampleDATA_06Sample Data3|~@sampleDATA_06sample 7'Modification of existing MeloFractor machine.       testDATA_06/@testDATA_06test 7'Modification of existing MeloFractor machine.       -blank-DATA_06%-blank-DATA_06Blank Data5!N&ֶ~@-blank-DATA_06-blank-        unnamedDATA_065rE.@unnamedDATA_06unnamed       "3DATA_14unnamed sampleDATA_14%sampleDATA_14Sample Data3Pa~@sampleDATA_14sample 3 testDATA_14/@testDATA_14test 3 -blank-DATA_14%-blank-DATA_14Blank Data54ض~@-blank-DATA_14-blank- 3 unnamedDATA_145rE.@unnamedDATA_14unnamed 3"%DATA_05unnamed sampleDATA_05%sampleDATA_05Sample Data3|~@sampleDATA_05sample- GW@sampleDATA_05- a ` @sampleDATA_05 % &  testDATA_05/@testDATA_05test % &  -blank-DATA_05%-blank-DATA_05Blank Data5!N&ֶ~@-blank-DATA_05-blank- % & unnamedDATA_055rE.@unnamedDATA_05unnamed % &"DATA_15unnamed sampleDATA_15%sampleDATA_15Sample Data3ϕ$~@sampleDATA_15sample "'Turbo-thrust Rack Feeder testDATA_15/@testDATA_15test "'Turbo-thrust Rack Feeder -blank-DATA_15%-blank-DATA_15Blank Data54ض~@-blank-DATA_15-blank-  unnamedDATA_155rE.@unnamedDATA_15unnamed  DATA_04 sampleDATA_04%sampleDATA_04Sample Data3|~@sampleDATA_04sample- a ` @sampleDATA_04  '          !     # > @ p @   ! testDATA_04/@testDATA_04test   '          !     # > @ p @   ! -blank-DATA_04%-blank-DATA_04Blank Data5 ն~@-blank-DATA_04-blank-            !            !  unnamedDATA_045-؂-@unnamedDATA_04unnamed            !            !"3DATA_12unnamed sampleDATA_12%sampleDATA_12Sample Data3Pa~@sampleDATA_12sample3 @ testDATA_12/@testDATA_12test3 @ -blank-DATA_12%-blank-DATA_12Blank Data5.؂-ض~@-blank-DATA_12-blank- 3 unnamedDATA_125rE.@unnamedDATA_12unnamed 3"DATA_03unnamed sampleDATA_03%sampleDATA_03Sample Data3|~@sampleDATA_03sample  > testDATA_03/@testDATA_03test  > -blank-DATA_03%-blank-DATA_03Blank Data5 ն~@-blank-DATA_03-blank-  > unnamedDATA_035-؂-@unnamedDATA_03unnamed  >"3DATA_13unnamed sampleDATA_13%sampleDATA_13Sample Data3Pa~@sampleDATA_13sample 3 testDATA_13/@testDATA_13test 3 -blank-DATA_13%-blank-DATA_13Blank Data5.؂-ض~@-blank-DATA_13-blank- 3 unnamedDATA_135rE.@unnamedDATA_13unnamed 3" DATA_02unnamed sampleDATA_02%sampleDATA_02Sample Data3N~@sampleDATA_02sample - 'Reduced cost of goods and increased 'productivity.    testDATA_02/@testDATA_02test - 'Reduced cost of goods and increased 'productivity.    -blank-DATA_02%-blank-DATA_02Blank Data5 ն~@-blank-DATA_02-blank-       unnamedDATA_025-؂-@unnamedDATA_02unnamed      "/DATA_10unnamed sampleDATA_10%sampleDATA_10Sample Data3 ~@sampleDATA_10sample `/'Though slightly riskier, the ThrockMarvin device, Project 1, provides a better return. 50'I recommend we proceed with the investment. 1 testDATA_10/@testDATA_10test `/'Though slightly riskier, the ThrockMarvin device, Project 1, provides a better return. 50'I recommend we proceed with the investment. 1 -blank-DATA_10%-blank-DATA_10Blank Data5.؂-ض~@-blank-DATA_10-blank- / 0 1 unnamedDATA_105rE.@unnamedDATA_10unnamed / 0 1"DATA_01unnamed sampleDATA_01%sampleDATA_01Sample Data3N~@sampleDATA_01sample 3'Purchase and installation of ThrockMarvin 0'Inc.'s state-of-the-art manuafacturing 'equipment.     testDATA_01/@testDATA_01test 3'Purchase and installation of ThrockMarvin 0'Inc.'s state-of-the-art manuafacturing 'equipment.     -blank-DATA_01%-blank-DATA_01Blank Data5$ն~@-blank-DATA_01-blank-        unnamedDATA_015-؂-@unnamedDATA_01unnamed       "3DATA_11unnamed sampleDATA_11%sampleDATA_11Sample Data3Pa~@sampleDATA_11sample 3'Vince Axlmeier testDATA_11/@testDATA_11test 3'Vince Axlmeier -blank-DATA_11%-blank-DATA_11Blank Data5.؂-ض~@-blank-DATA_11-blank- 3 unnamedDATA_115rE.@unnamedDATA_11unnamed 3sample4sampleOriginal SmartMaster sample data set)N~@samplesample# N~@sample# N~@sample# |~@sample# |~@sample# |~@sample# |~@sample# ~@sample# ~@sample# ~@sample# ~@sample# Pa~@sample# Pa~@sample# Pa~@sample# Pa~@sample# ϕ$~@sample# ϕ$~@sample9samplesampleScott TuckerLotus NotesDATA_019samplesampleScott TuckerLotus NotesDATA_029samplesampleScott TuckerLotus NotesDATA_039samplesampleScott TuckerLotus NotesDATA_049samplesampleScott TuckerLotus NotesDATA_059samplesampleScott TuckerLotus NotesDATA_069samplesampleScott TuckerLotus NotesDATA_079samplesampleScott TuckerLotus NotesDATA_089samplesampleScott TuckerLotus NotesDATA_099samplesampleScott TuckerLotus NotesDATA_109samplesampleScott TuckerLotus NotesDATA_119samplesampleScott TuckerLotus NotesDATA_129samplesampleScott TuckerLotus NotesDATA_139samplesampleScott TuckerLotus NotesDATA_149samplesampleScott TuckerLotus NotesDATA_159samplesampleScott TuckerLotus NotesDATA_16-blank-4-blank-Original SmartMaster blank data set+$ն~@-blank--blank-$  ն~@-blank-$  ն~@-blank-$  ն~@-blank-$ !N&ֶ~@-blank-$ !N&ֶ~@-blank-$ !N&ֶ~@-blank-$ 'Tk׶~@-blank-$ 'Tk׶~@-blank-$ 'Tk׶~@-blank-$ .؂-ض~@-blank-$ .؂-ض~@-blank-$ .؂-ض~@-blank-$ 4ض~@-blank-$ 4ض~@-blank-$ 4ض~@-blank-$ :b߱ٶ~@-blank-;-blank--blank-Scott TuckerLotus NotesDATA_01;-blank--blank-Scott TuckerLotus NotesDATA_02;-blank--blank-Scott TuckerLotus NotesDATA_03;-blank--blank-Scott TuckerLotus NotesDATA_04;-blank--blank-Scott TuckerLotus NotesDATA_05;-blank--blank-Scott TuckerLotus NotesDATA_06;-blank--blank-Scott TuckerLotus NotesDATA_07;-blank--blank-Scott TuckerLotus NotesDATA_08;-blank--blank-Scott TuckerLotus NotesDATA_09;-blank--blank-Scott TuckerLotus NotesDATA_10;-blank--blank-Scott TuckerLotus NotesDATA_11;-blank--blank-Scott TuckerLotus NotesDATA_12;-blank--blank-Scott TuckerLotus NotesDATA_13;-blank--blank-Scott TuckerLotus NotesDATA_14;-blank--blank-Scott TuckerLotus NotesDATA_15;-blank--blank-Scott TuckerLotus NotesDATA_16unnamed+-؂-@unnamedunnamed$ -؂-@unnamed$ -؂-@unnamed$ -؂-@unnamed$ -؂-@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed$ rE.@unnamed9unnamedunnamedErin LimanLotus NotesDATA_019unnamedunnamedErin LimanLotus NotesDATA_029unnamedunnamedErin LimanLotus NotesDATA_039unnamedunnamedErin LimanLotus NotesDATA_049unnamedunnamedErin LimanLotus NotesDATA_059unnamedunnamedErin LimanLotus NotesDATA_069unnamedunnamedErin LimanLotus NotesDATA_079unnamedunnamedErin LimanLotus NotesDATA_089unnamedunnamedErin LimanLotus NotesDATA_099unnamedunnamedErin LimanLotus NotesDATA_109unnamedunnamedErin LimanLotus NotesDATA_119unnamedunnamedErin LimanLotus NotesDATA_129unnamedunnamedErin LimanLotus NotesDATA_139unnamedunnamedErin LimanLotus NotesDATA_149unnamedunnamedErin LimanLotus NotesDATA_159unnamedunnamedErin LimanLotus NotesDATA_16CR3CR3 PropertyDoc Info CommentsDoc Info Creation DateDoc Info Editing TimeDoc Info Last Revision DateDoc Info ObjectDoc Info PropertyDoc Info TitleFM3FM3 PropertyWK3WK3 Property  tL Z,g cZ,'V R  Tx T T T T1! ƭ C ح  TX CMHdrtL