Table With Excel – TWE 2.0 User Manual
Contents
1. rr 34 dede eee A RE 36 36 37 ADDITIONADIEUNCITIONS5 ES ne de UE 40 SNOW cocon 40 Cle en eU D rS 40 Rename worksheets in 41 41 ADO EE RR 41 OR IT 43 SON AL 43 INTRODUCTION TWE 2 0 Microsoft Excel 15 very popular spreadsheet software It 15 widely used in education in scientific research in managing financial activities Nowadays the common versions of Microsoft Excel are version 2000 and 2003 The functions of these versions are very powerful and include enormous functions and possibilities Scientists and engineers use Microsoft Excel to record and keep observed data And further use Excel to summarize and analyze these data During the data processes manipulation of tables such as merging tables splitting tables eliminating duplicates format conversion and so on is an indispensable activity And more Excel users in financial institutions use Excel to hold financial information in addition to their central database Even they use Excel to do2. 24 B C D E G H 1 Method Subject Location Varl Vara Vars 2 1 1 1 0 524343 0 7704 5638 1 5506 0 203596 3 1 2 1 0 595447 0 5884 5825 1 7069 0 248157 4 1 3 1 0 232049 0 766 4472 2 2761 2 824783 5 1 4 1 0 538529 0 9802 445 1 1 7331 1 149754 5 2 1 1 0 466725 0 4266 4925 1 7677 0 231655 n 2 2 1 0 923816 0 7853 505 6 1 8844 0 488239 8 2 3 1 0 410683 0 6802 4848 1 9999 0 564656 d 2 4 1 0 191769 0 6905 659 6 1 7355 0 945062 10 3 1 1 0 727671 0 5865 489 4 1 9589 0 347008 11 3 2 1 1 429947 0 9517 458 3 1 9713 1 17619 12 3 3 1 5 52189 0 6916 452 3 1 57 1 306973 13 3 4 1 0 683888 0 7946 591 4 2 0426 0 524486 14 4 1 1 1 194396 0 778 501 6 2 1454 0 857254 15 4 2 1 0 890543 0 6648 436 1 5656 0 469556 16 4 3 1 0 747811 0 6571 569 1 1 535 0 522967 17 4 4 1 0 600701 0 7101 552 8 1 557 0 589226 Figure 32 Right click the TWE icon in the system tray area Click Stack tables from the TWE context menu to open the Stack tables dialog window see Figure 33 Select the Table_Examples xls workbook in the workbook dropdown list box Select Locationl in the worksheet list box and click the Add button to add available data range in this sheet to the selected range list box Select Location2 in the worksheet list box and click the Add button to add available data range in this sheet to the selected range list box Now the selected range list box has two data ranges Make sure the Simp
3. tsar intestins 11 T E ems 11 Mark CUP 12 WIIG Re EM 13 Extract duplicate TOWS ane tr 14 MERGING AND SPLITTING TABLE vestes tesssosius sese 16 DDBP Cable sens ep UM ERE LM 16 rene E terete ne metre d und rer 16 17 cue tenon dae autem 18 S aur 19 Example teat iu a 20 Stack S 21 ONEIN E iUic a cease sre E UC 21 Example cmc A de 25 Example 2 Sfack by matching column Hes rset 25 de 27 OVNI 28 Example Match one column and copy a different column 29 TABLE TRANSPOSITION Re e I tee 3 mor E 31 yu 31 Examples 32 SO ADR 33 34
4. Table With Excel TWE 2 0 User Manual COPYRIGHT 2005 2009 ZHANSHAN DONG TABLE OF CONTENTS INSEODUGTION TO TWE nn al abi ne M M ae ie en 1 se sia OLI NT td 1 ARE INSTALLATIONS ee ee cu 2 Hardware and SOntw are Tedgulte IMC IIS uuo darn 2 Iristall E WE LOMME SSD EEG eoo o erronea enar etnia adusque net ea e cece eu 2 Microsoft Net Framework Redistribution Package 2 IR T 3 Stabe tne hace 3 Context THOTIU e e 3 An Overview of the TWE functions 4 Sphtttne and metere he da ae etre 4 Transposrtiomn OF LADIES 4 Working with duplicates column format and worksheet name 4 BS DENIED E S TUM 5 ATroyetyiew or atypical LWE Alone historien sete be pg uus 5 WORKING WMITHD A TAFORMA Ti anu 8 Conver data Format TO n meri C nine none 9 Convert Gala FORMACIO LCS anette E 9 Convert Gala een ed Send dian dd ele en 10 MANIPULATION OF DUPLICATE ROW S
5. 1 2 2 0 14 0 67 616 50 1 92 1 65 20 1 3 2 2 12 0 71 415 50 1 82 0 33 21 1 4 F 0 90 0 57 442 00 2 21 1 60 22 2 1 2 0 55 0 81 568 00 1 75 0 20 23 2 2 2 0 48 0 53 536 40 1 46 0 53 24 2 3 2 0 63 0 61 321 00 1 97 1 44 25 2 4 2 1 12 0 51 499 50 1 42 0 40 26 3 1 2 0 91 1 33 547 60 2 28 0 47 2 3 2 2 1 05 1 26 583 90 1 94 0 60 28 3 3 2 0 83 159 579 60 2 67 0 70 29 3 4 2 0 77 128 549 40 2 13 0 56 30 4 1 2 0 44 1 47 659 10 2 74 0 21 31 4 2 2 1 15 1 45 629 90 1 56 0 81 32 4 3 2 1 02 1 10 554 70 2 46 0 56 4 4 2 1 08 1 56 583 10 2 31 0 67 34 1 1 3 0 66 1 23 637 70 1 81 0 43 Ex 1 2 3 D 72 1 25 595 60 2 68 0 35 36 1 3 3 0 94 1 46 593 80 2 47 0 56 ai 1 4 3 0 83 1 11 620 40 1 30 0 50 38 2 1 3 0 94 1 16 594 00 2 97 0 40 39 2 2 3 0 32 1 29 556 50 2 36 0 49 40 2 3 3 1 04 1 38 553 40 1 50 0 51 41 2 4 3 0 68 1 35 618 70 1 37 0 38 42 3 1 3 0 68 139 594 60 2 70 0 36 43 3 2 3 0 73 1 22 601 10 1 67 1 02 Figure 22 Here are the detailed steps 1 Right click the TWE icon in the system tray area 2 Click Split a table from the TWE context menu to open the Split table dialog window see Figure 23 3 Select the Table Examples xls workbook in the workbook dropdown list box 218 4 Select the FullList2 worksheet in worksheet dropdown list box 5 Select all columns in the Copy Columns list box 6 Select Location column in the Filter Columns list box The completed dialog window looks like Figure 23 7 Click the OK button to
6. 1 2 7111 05 135 7105 7105 71205 7 13 05 7 9 05 7 9 05 21 138 1 2 7 9 05 7 9 05 719105 7 15 05 7 9 05 79 05 76 05 7605 7 18 05 22 155 1 2 7713 05 76 05 1305 7305 7 13 05 7 27 05 FADS 7305 7 3 05 23 172 1 2 5 7 20 05 75 05 7 20 05 7 20 05 7 18 05 7 18 05 FAAS 719 05 7 20 05 Figure 46 1 Right click the TWE icon E in the system tray area 2 Click Table to list from TWE context menu to open the Table to list dialog window see Figure 47 Select Table_Examples xls from the workbook dropdown list box Select FullTable from the worksheet dropdown list box Select the first three columns that 15 ID Location and Block in the Copy Columns list box Select the next 10 columns following Block that is 1 710 in the Iranspose Columns list box Enter Samples in the index title text box Enter Dates in the value title text box 3 4 5 6 7 8 9 Click the button to proceed After process 15 done a new table Figure 48 1s generated It includes five columns The first three columns were copied from the original table The fourth column includes column titles of Columns 1 7 10 in the original table The fifth column includes values from the Column 1 10 in the original table Table to list Worksheets Workbook Table_Examples xls v Refresh New Sheet Name Data sheet FullT able
7. 23 11 44AM Figure 3 Split 4 Table Extract Table Stack Tables Join Tables Table To List List To Table List To Counts Handle Duplicates Format Columns Rename Sheets Open Excel File Excel Information Help About Quit Figure 4 An overview of the TWE functions Splitting and merging tables four functions in this category are related to splitting large tables into small tables or merging small tables into a large one Split a table Split a large table to small ones according to criteria you create Extract a table Extract rows from a large table based on criteria you create and form a new table Stack tables Stack merge as many tables as you want to a large table You can choose to simply stack tables and stack tables by match column titles Join tables Join merge data from two tables based on match criteria you create Transposition of tables three functions in this category are related to reshape the Excel tables Table to list Transpose a horizontal table into a vertical list by straightening selected columns List to table Transpose a vertical list to a horizontal table by splitting a selected value column based on a selected title column List to counts Transpose a vertical list to a horizontal table filled with counts of items appearing in a selected column Working with duplicates column format and worksheet name Handle duplicates Mark and extract duplicate or unique row
8. 452 30 1 57 1 31 133 4 1 0 68 0 79 591 40 2 04 0 52 14 4 1 1 1 19 078 501 50 2 15 0 86 15 4 2 1 0 89 0 66 436 00 1 57 0 47 16 4 3 1 0 75 0 66 569 10 1 54 0 52 17 4 4 1 0 60 0 71 552 80 1 55 0 59 Figure 28 Stack tables This function provides two solutions to combine large number of small tables into large table Overview From the TWE context menu click Stack tables to open Stack tables dialog window see Figure 29 This dialog window has more unique elements Worksheets 22 area 15 at top of dialog window and Output area in the middle There is no separate Column area Worksheets area includes workbook dropdown list at top a worksheet list box and column list box on the left two check boxes and three buttons and a selected range list box on the right You can use the workbook dropdown list to select a workbook from all available workbooks You can use Refresh button on the right side to update workbooks dropdown list Once workbook 15 selected all worksheets of the selected workbook are shown in the worksheet list box The active worksheet is automatically selected in the worksheet list box columns of the selected worksheet are also listed and selected in the column list box To add data tables to the selected range list box you have to select a worksheet and select consecutive columns you want to be copied to the large table Then click the Add button in the midd
9. of the Worksheets area There is a Refresh button in this frame If there are workbooks created or opened after the dialog window is opened you have to click this button to update the workbook dropdown list Column area includes two parts Columns to be formatted and Format to Columns to be formatted list box allows you select columns that you want to convert their format You can select one or more columns That totally depends on your needs The Format to frame includes three exclusive options Numeric Text and Date and a dropdown list box The dropdown list box is only enabled when the 9 Text option is selected The dropdown list includes three items Do nothing Upper Lower It provides a way to convert any text in the selected columns to the upper or lower case If the column s you select has merged cells that span more than one column you could receive the following error message Figure 10 Just simply click the Ok button to continue your work Error Cannot change part of a merged cell Please check the data range and make sure there are no merged cells Figure 10 Convert data format to numeric To convert data format to Numeric format the detailed steps are the following The completed Format columns dialog window 15 similar to Figure 9 1 2 3 4 5 6 Right click TWE icon in the system tray area Click Format columns from the TWE context menu to op
10. select a comparison operator from the drop down list box in the middle TWE provides 6 comparison operators that is gt gt lt lt and lt gt Finally you select a value from the drop down list box on the right TWE automatically generated a value list whenever you select a column from the drop down list box on the left After you complete the above steps click the Add button in the middle of the frame A criterion will be added to the filter criteria list box Since TWE does not validate the criteria you add you have to make sure the added criteria are valid by yourself If a criterion is not valid you can select it in the filter criteria list box and click the 20 Delete button to erase it You can always erase all added criteria by clicking the Clear button Example Figure 26 shows a table including 8 columns Now we want to extract a subset of rows based on a filter criterion created on the Location column B C I F G H 1 Method subject Location Yarl Vara Varo 2 1 1 1 0 62 077 563 80 1 55 0 20 3 1 2 1 0 60 0 69 562 50 1 71 0 25 4 1 3 1 0 23 D 77 447 20 2 28 2 82 5 1 4 1 0 54 0 98 445 10 1 73 1 15 6 2 1 1 0 47 0 43 492 60 1 77 0 23 2 2 1 0 92 0 79 505 60 1 88 0 49 8 2 3 1 0 41 0 68 494 80 2 00 0 56 z 2 4 1 0 19 069 559 60 1 74 0 95 10 3 1 1 0 73 0 59 489 40 1 96 0 35 11 d 2 1 1 43 0 95 458 30 1 97 1 18 iz 3 3 1 5 75 0 69 452 30 1 57 1 31 13 3 4 1 0 68 0 79 591 40 2 04 0
11. table including six columns in which there are two recorded dates for 10 samples of each subject a combination of the first three columns What we want to do is to transpose the recorded dates into horizontal columns for each subject For demonstration purpose we pick the column with Datel as its column title to 35 transpose to horizontal columns So here the title column 15 Subsample column and the value column is the Datel column The first three columns will be copied to the new table to identify a subject 1 2 3 4 5 6 7 8 B C D E 1 ID Location Block subsmapl Datel Date2 2 94 9 1 7 11 05 3 84 1 9 2 4 94 1 9 3 7 9 05 7 9 05 5 94 1 9 4 b 94 1 9 5 7 12 05 7 12 05 7 94 1 9 6 B 94 1 9 7 7 9 05 9 94 1 9 8 7 9 05 10 94 1 9 9 7 11 05 11 94 1 9 10 7 12 05 12 9 1 9 1 7 11 05 7 9 05 HH 1 9 2 7 11 05 7 11 05 14 9 1 9 3 7 12 05 15 9 1 9 4 7 11 05 7 12 05 16 9 1 9 5 7 18 05 1 7 15 05 179 1 9 6 7 9 05 7 9 05 18 9 1 9 7 7 11 05 7 12 05 19 9 1 9 8 7 13 05 7 1 05 20 9 1 9 9 7 9 05 7 9 05 21 9 1 9 10 7 9 05 7 13 05 22 179 1 9 1 7 9 05 7 15 05 23 179 1 9 2 7 18 05 7 27 05 24 179 1 d 3 7 18 05 7 21 05 Figure 50 Right click the TWE icon in the system tray area Click List to table from the TWE context menu to open the List to table dialog window see Figure 51 Select Table Examples xls from the workbook dropdown list box Select FullList1 from the work
12. 0 522967 17 4 4 1 0 600701 D 7101 552 8 1 557 0 589226 18 1 1 2 0 550766 0 6965 5746 2 4116 0 451956 19 1 2 0 137476 0 6655 616 5 1 9159 1 65164 20 1 3 2 2 118214 0 705 4155 1 8158 0 334834 21 1 4 2 0 895797 0 5718 442 2 2128 1 597544 22 2 1 2 0 553415 0 8091 568 1 7493 0 197852 23 2 2 2 0 481611 0 5338 536 4 1 4599 0 533531 24 2 3 2 0 627646 0 6132 321 1 9665 1 438943 E 2 4 2 1 124343 0 5054 4995 1 4162 0 401493 26 3 1 2 0 912434 1 3303 647 6 2 2807 0 46756 27 3 2 2 1 04641 1 2629 583 8 1 9362 0 601172 28 3 3 2 0 627496 1 5935 5798 2 6683 0 696669 29 3 4 2 0 768827 1 277 5494 2 1292 0 56376 30 4 1 2 0 438704 1 4662 659 1 2 7441 0 213942 31 4 2 2 1 15324 1 4481 529 8 1 5604 0 811985 32 4 3 2 1 018388 1 1049 5547 2 4555 0 560414 4 4 2 1 082312 1 5597 583 1 2 3143 0 571188 Figure 34 Example 2 Stack by matching column titles Figure 35 and Figure 36 are two tables including observed data from two locations The first table has two observed variables and the second one has three observed variables different from the two variables in the first table We do not want to mix up different variables into same columns and also do not want to lose location information Stacking tables by matching column titles that TWE provides can easily merge them together For demonstration purpose the detailed steps are given below 1 2 3 4 5 6 7 26 B C D E 1 Method Subject Location 2 1 1 1 0 524343 0 770
13. 1 05 Name19 Aj TABLE TRANSPOSITION Microsoft Excel provides a transposition function If you use special paste dialog window you can select Transpose at the bottom of the window By using this function you can transpose selected range from vertical to horizontal or vice versa However if you want to keep partial information of a table untouched and transpose several data columns such as Columns D M in a table like Figure 46 Excel cannot really help you TWE table transposition functions are designed for this purpose Table to list This function provides a solution to transpose a horizontal table we call it a table here and thereafter to a vertical table we call it a list here and thereafter Overview From the TWE context menu click Table to list to open the Table to list dialog window see Figure 45 Worksheets area is at the top of the dialog window and Column area in the middle E Table to list Worksheets Workbook lU ENSE Befesh Data sheet Location v Without head row Selected range Copy Columns Transpose Columns Index title Value title Start time End time Duration Bee Figure 45 Worksheets area allows you to select a workbook from the available workbook list and a worksheet from the selected workbook It also allows you to optionally select Without head row and Selected range The available data range in the A1 format is shown at th
14. 12 05 7 18 05 7 3 05 7 9 05 E 2 7 13 05 7 9 05 7 9 05 7 15 05 7 3 05 7 11 05 7 1 05 7 11 05 77 05 7 12 05 7 11 05 7 9 05 7 11 05 Selected range 1 375 Match Columns Without head row Refresh ID ID FullT able ID Add Clear 10 10 y FullT able ID v End 4 13 PM Figure 4 F G 3 4 771105 7 13 05 7 05 7 3 05 7 9 05 7 79 05 7713 05 7 13 05 719 05 7 1 05 7A1 05 7 11 05 7 13 05 7A1 05 7 11 05 7 05 7 79 05 7 16 05 7 05 7 6 05 7 9 05 7 79 05 72005 7 11 05 Figure 44 Duration 0 25s ome H 5 7 11 05 7 13 05 7 9 05 7 9 05 7 3 05 7 11 05 7 11 05 7 13 05 7 11 05 7 18 05 7 9 05 7 12 05 6 7 11 05 7 13 05 7 3 05 7 13 05 7 1 05 7 9 05 7 11 05 7 9 05 7 9 05 7 9 05 7 23 05 7 15 05 7 11 05 7 7 11 05 7 11 05 7 9 05 7 13 05 7 3 05 7 9 05 7 1 05 7 9 05 7 9 05 7 16 05 7 9 05 7 11 05 K 7 13 05 7 12 05 7 9 05 7 12 05 7 12 05 7 9 05 7 9 05 7 12 05 7 47 05 7 9 05 7 9 05 8 shown in Figure 44 has one more column on the right side of the table L 3l 7 13 05 7 12 05 7 3 05 7 13 05 7 9 05 7 13 05 7 11 05 7 9 05 7 9 05 7 9 05 7 11 05 M 10 7 12 05 Name18 7 19 05 Name35 7 13 05 52 7 9 05 Nameb9 7 11 05 Name86 7 18 05 103 Name120 7 17 05 Name137 Name154 7 17 05 Name171 7 9 05 Name2 7 1
15. 2 3 2 321 1 9665 1 438943 25 2 4 2 499 5 14162 0 401493 26 3 1 2 547 6 22807 0 46758 27 3 2 2 5839 1 9382 0 601172 28 3 3 2 5798 2 6683 0 696689 29 3 4 2 5494 2 1292 0 56376 30 4 2 6591 27441 0 213942 31 4 2 2 629 9 1 5604 0 811985 32 4 3 2 5547 24555 0 560414 33 4 4 2 5831 23143 0 671188 Figure 38 Join tables This function provides a solution to combine information from two tables horizontally It 15 different from the Stack tables function because the Stack tables function combines tables vertically The Join tables function combines two tables by matching values of the selected columns in each row You can match as many columns in two tables as you want and copy selected or all columns from one table to the other table It can be used in the following situations Fulfill the match and lookup worksheet functions Excel provides 28 Combine information from two different tables to generate large table Check if particular entries in one table are exist in the other table Overview From the TWE context menu click Join tables to open the Join tables dialog window see Figure 39 This dialog window has more unique elements Worksheets area is at the top of the dialog window There are two sets of worksheet selection controls The set on the left side 15 for selection of the source worksheet and the set on the right side for selection of the destination worksheet To be aware that the two tables are not ne
16. 4 3 1 2 1 0 585447 0 6884 4 1 3 1 0 232049 0 766 5 1 4 1 0 538528 0 9802 6 2 1 1 0 466725 0 4266 7 2 2 1 0 923818 0 7853 8 2 3 1 0 410683 0 6802 9 2 4 1 0 191769 0 6905 10 3 1 1 0 727671 0 5865 11 3 2 1 1 428947 0 9517 12 3 3 1 5752189 0 6916 13 3 4 1 583888 0 7946 14 4 1 1 1 184396 0 776 15 4 2 1 0 890543 0 6646 15 4 3 1 0 747811 0 6571 17 4 4 1 0 600701 0 7101 Figure 35 B C SS F 1 Method Subject Location Vars Vard Varo 2 1 1 2 574b 2 4116 0 451958 d 1 2 2 6185 1 9159 1 65164 4 1 3 2 4155 1 6158 0 334834 5 1 4 2 442 2 2128 1 597544 6 2 1 2 568 1 7493 0 197852 2 2 2 536 4 1 4599 0 533531 8 2 3 2 321 1 9665 1 438943 2 4 2 4995 1 4162 0 401493 10 3 1 2 547 6 2 2807 0 46758 11 3 2 2 583 9 1 9382 0 601172 12 3 3 2 5798 2 6683 0 696689 13 3 4 2 5494 2 1292 0 56376 14 4 1 2 659 1 2 7441 0 213942 15 4 2 2 629 9 1 5604 0 811985 16 4 3 2 5547 2 4555 0 560414 17 4 4 2 583 1 2 3143 0 571188 Figure 36 Right click the TWE icon E in the system tray area Click Stack tables from the TWE context menu to open the Stack tables dialog window see Figure 37 Select the Table Examples xls workbook in the workbook dropdown list box Select Location in the worksheet list box and click Add button to add available data range in this sheet to the selected range list box Select Location2 in the worksheet list box and click Add button to add available data range in this sheet to the selected
17. 52 14 4 1 1 1 19 0 76 501 60 2 15 0 86 15 4 2 1 0 89 066 436 00 1 57 0 47 16 4 3 1 0 75 0 66 569 10 1 54 0 52 17 4 4 1 0 60 0 71 552 80 1 56 0 59 18 1 1 2 0 55 090 574 60 2 41 0 45 19 1 2 2 0 14 0 67 616 50 1 92 1 65 20 1 3 2 2 12 0 71 415 50 1 82 0 33 21 1 4 2 0 90 0 57 442 00 2 21 1 50 22 2 1 2 0 55 0 81 568 00 1 75 0 20 23 2 2 2 0 48 0 53 536 40 1 46 0 53 24 2 3 2 0 63 0 61 321 00 1 97 1 44 25 2 4 2 1 12 0 51 499 50 1 42 0 40 26 3 1 2 0 91 133 547 60 2 28 0 47 27 3 2 2 1 05 1 26 583 90 1 94 0 60 28 3 3 2 0 83 1 58 579 80 2 67 0 70 29 3 4 2 0 77 1 29 549 40 2 13 0 56 30 4 1 2 0 44 1 47 659 10 2 74 0 21 31 4 2 2 1 15 1 45 529 90 1 56 0 81 32 4 3 2 1 02 1 10 554 70 2 46 0 56 33 4 4 2 1 08 155 583 10 2 31 0 67 34 1 1 3 0 66 1 23 637 70 1 81 0 43 35 1 2 3 0 72 1 25 59560 2 68 0 35 36 1 3 3 0 94 1 46 593 80 2 47 0 56 37 1 4 3 0 83 1 11 620 40 1 30 0 50 38 2 1 3 0 94 1 15 594 00 2 97 0 40 33 2 2 3 0 32 1 29 556 50 2 36 0 49 40 2 3 3 1 04 1 38 553 40 1 50 0 51 41 2 4 3 0 68 1 35 616 70 1 37 0 38 42 3 1 3 0 68 1 38 594 60 2 70 0 36 43 3 2 3 0 73 1 22 601 10 1 87 1 02 Figure 26 Here are detailed steps 1 Right click the TWE icon E in the system tray area 2 Click Extract a table from the TWE context menu to open the Extract table dialog window see Figure 27 3 Select the Table Examples xls workbook in the workbook dropdown list box 4 Select the FullList2 worksheet in the worksheet dropdown list box 5 Select all column
18. 72 05 713 05 7 1705 7905 7 05 7 16 05 7 16 05 11 26 1 g 71905 7905 7 9 05 7806 717 05 79 05 715 05 72005 7905 7 9 05 12 145 1 g 711 05 7 9 05 7 1305 7 13 05 7 13 05 7 16 05 7 9 05 7 13 05 7 1 05 13 50 1 16 7 2005 7 1705 7 20 05 7 20 05 7 6 05 7 21 05 7 1705 7A7 05 71605 7 9 05 14 67 1 16 7 6 05 7 6 05 7 6 05 7 16 05 7 20 05 7 16 05 7 19 05 7 16 05 7 16 05 7 17 05 15 33 1 16 7 6 05 7 19 05 7 16 05 7 16 05 7 16 05 7 1605 7 16 05 7 16 05 7 17 05 7 20 05 16 186 1 16 7 21 05 7 20 05 7 20 05 7 7 05 7 20 05 7 20 05 7 20 05 7 7 05 7905 7 6 05 17 101 1 16 7 20 05 79 05 717 05 7 1705 7905 7 1705 7905 7905 7905 7905 18 118 1 16 7 2 05 7 20 05 7 3 05 7 1205 7 3 05 71205 7 2 05 7 9 05 7 2 05 19 152 1 16 7 1 05 7 205 7 105 7 1 05 7 12 05 7 11 05 7 1 05 7 1 05 7 1 05 20 135 1 16 7 11 05 7 1 05 7 9 05 7 1 05 7 9 05 7 9 05 7105 7 9005 71105 21 84 1 16 712005 7 1205 7905 72 05 7 9005 7905 7 1205 7 905 7 9 05 22 169 1 16 71805 7 18 05 7 8 05 7 1805 7 18 05 7 18 05 7 16 05 7 16 05 7 18 05 7 22 05 23 16 1 16 7 2 05 7806 7 9 05 7 1205 7 2 05 7 2 05 71205 7 12 05 24 44 1 10 7 2 05 7 905 7105 71105 7105 7 1205 7 12 05 7 1 05 7 16 05 7 11 05 25 10 1 10 7 1 05 7 1205 79 05 7 1 05 7 3 05 7 1 05 7 3 05 7 16 05 7 13 05 26 78 1 10 71905 71 05 7 7 05 7905 7 1175 7905 7 9005 7 205 7 9005 7 18 05 27 146 1 10 7 1 05 7 1105 7905 7 11 05 7 105 7 1105 7 11 05 7 11 05 Figure 52 List to coun
19. Close Figure 7 Functional area Column Area 15 used to select copy columns filter columns matching criteria and so on There are a lot of variations in this area Most dialog windows have copy columns Some dialog windows have filter columns We will give detail description of this area when we introduce individual functions Functional area C Time Area is used to display data processing time It shows start and end time in HH MM format and total time duration in seconds Once data process is complete processing time will show in this area Therefore it tells you that program has completed data process when all three fields are filled This 15 one way to know whether the program is processing data Functional area D Button Area includes buttons It usually includes and Close buttons Click the Ok button to trigger the data processing Click the Close button to close the dialog window TWE has several message windows Figure 8 shows a very popular one It will pop up whenever there are not enough data rows in the selected data range What you can do 1s to either select a different worksheet with enough data or select a large range of data in the current worksheet TWE will not allow you do any thing if you do not select enough data Other message windows only show up in specific situations We will describe them in appropriate sections Figure 8 WORKING WITH DATA FORMAT It is not uncommon that Exce
20. Selected range 1 0376 Copy Columns Transpose Columns Column Column Index 5 amples co IM amp Cr _ Value title Dates Start time 5 45 PM End time 5 45 PM Duration 0 6875s cose Figure 47 B C D 1 JID Location Block Samples Dates gt 1 1 1 7 11 05 om 1 1 2 7 13 05 4 1 1 1 3 7 11 05 5 1 1 1 4 7 13 05 6 1 1 1 5 7 11 05 z 1 1 1 6 7 11 05 8 1 1 1 7 7 1 05 1 1 8 7 13 05 10 1 1 1 9 7 13 05 11 1 1 1 10 12 18 1 1 1 7 11 05 13 18 1 1 2 7 9 05 14 18 1 1 3 7 9 05 15 18 1 1 4 7 13 05 16 18 1 1 5 7 13 05 17 18 1 1 6 7 13 05 18 18 1 1 ri 7 1 05 19 18 1 1 8 7 12 05 20 18 1 1 9 7 12 05 21 18 1 1 10 7 12 05 Figure 48 List to table This function provides a solution to transpose a vertical list to a horizontal table It exactly does a reverse operation of the Table to list function described in the previous section 34 Overview Example From the TWE context menu click List to table to open the List to table dialog window see Figure 49 Worksheets area 15 at the top of the dialog window and Column area in the middle Worksheets area allows you to select a workbook from all available workbooks and a worksheet from the selected workbook It also allows you optionally to select Without head row and Selected range The available data range in the A1 format is shown at the bottom of the Wo
21. The completed Format columns dialog window 15 similar to Figure 12 1 Right click the TWE icon in the system tray area 2 Click Format columns from TWE context menu to open the Format columns dialog window 3 Select a workbook and a worksheet that you want to work with 4 Select one or more columns in the Columns to be formatted list box 5 Choose the Date option in the Format to frame 6 Click the button to convert the selected columns to Date format E Format columns Worksheets Workbook Table_Examples xls v Refresh Data sheet FullListl v Without head row Selected range 1 F3741 Columns to be formatted Location Block Subsmaple Datel Date2 Duration Format to C Numeric C Test Date Close Figure 12 11 MANIPULATION OF DUPLICATE ROWS A large number of people use Microsoft Excel to manage their database They keep a lot of information in different spreadsheets Since Excel does not have appropriate mechanisms to avoid redundant data in a spreadsheet It is not uncommon that there are duplicate rows in a spreadsheet If a spreadsheet only includes dozens of rows it is easy to eliminate redundant rows by carefully check and compare values in different rows But when a spreadsheet includes thousands of rows the job becomes tedious and prone to errors TWE provides a powerful tool to deal with problems related to d
22. all three check boxes Click the button to proceed After the process is done a new table Figure 56 is generated E List to counts Worksheets Workbook Table_Examples xls Refresh New Sheet Name Data sheet FullListl v Without head row Selected range 1 F3741 Copy Columns List Column ID Datel Location Data Format Date M Non zero value M Cumulative counts M No duplicates Start time 5 52 PM End time 5 52 PM Duration 1 421875s Case Figure 55 RC ae EE icin ai ae eee N P eo ID Location Block 7 9 05 7 11 05 7 12 05 7 13 05 7 16 05 7 17 05 7 18 05 7 19 05 7 20 05 7 21 05 7 22 05 7 23 05 7 25 05 7 27 05 8 1 05 c to n 10 94 1 9 1 2 9 1 9 3 7 8 9 10 179 1 9 1 10 43 1 9 5 6 10 60 1 9 4 9 10 128 1 9 1 2 3 6 8 9 10 111 1 9 2 3 5 162 1 9 8 9 10 77 1 9 3 4 6 8 10 26 1 9 8 10 145 1 9 1 3 8 9 50 1 16 1 6 9 67 1 16 7 8 10 33 1 16 8 10 185 1 16 1 2 4 9 101 1 16 5 9 10 118 1 16 1 6 8 9 152 1 16 9 135 1 16 4 9 84 1 16 6 3 169 1 16 9 16 1 16 2 8 44 1 10 1 9 10 1 10 1 4 5 8 78 1 10 5 7 8 10 146 1 10 1 8 163 1 10 2 7 61 1 10 3 4 5 8 10 27 1 10 3 5 7 Figure 56 40 ADDITIONAL FUNCTIONS TWE provides some additional functions as described below in detail Show Excel status Figure 57 15 an example of the Current Status of Excel dialog window In this dialog wind
23. anspose the recorded dates into a vertical column for each subject Microsoft Excel does not provide a way to do that easily By using TWE s table to list function the process 15 pretty simple B C D E F G H J K E M 1 ID Location Block 1 2 3 4 5 5 7 8 9 10 2 1 1 1 7271105 7305 71 05 7305 7105 7105 7105 7305 73 05 3 18 1 1 7 11 05 7 9 05 7 05 71305 7305 7305 71 05 72 05 71205 7 2 05 4 35 1 1 7 9 05 7 9 05 7 9 05 7 9 05 7 9 05 7 9 05 7 9 05 7 9 05 7 05 7 19 05 5 52 1 1 7305 7765 7 13 05 73 5 7 05 7305 7305 7205 7305 73 5 6 69 1 1 7 11 05 7 9 05 7 05 7 11 05 719105 7 11 05 719105 7 12 05 7 9 05 7 9405 Bb 1 1 7 11 05 7105 71 05 71 5 7 9 05 7 9 05 719105 7305 7 1 05 8 103 1 1 2771105 7 11 05 771305 7 11 05 7 11 05 71 05 7 11 05 7 18 05 9 120 1 1 71105 7105 71105 7105 7 1 05 7 9 05 10 137 1 1 7105 7 1705 7 9 05 05 7 13 05 7 9 05 7 9 05 7 9 05 7 05 7 7 05 11 154 1 1 74205 7 12 05 7 16 05 7 11 05 7 9 05 705 7 12 05 12 171 1 1 7805 7 11 05 7 05 7605 7805 7 2305 7 16 05 77 5 7 05 7 7 05 T 2 1 2 7 9 05 7 9 05 7 9 05 7 9 05 719105 7 5 05 7 9 05 7 9 05 7 9 05 7 9 05 14 18 1 2 71905 771105 7 1205 7105 74205 74105 711 05 71905 771105 7 1 05 ila 36 1 2 7h1 05 72 05 7 1 05 7 9 05 7 05 7205 7 1305 742 05 15 53 1 2 719105 75 05 7 9 05 7 9 05 19105 771105 7 1305 72 05 19105 7 1 05 17 70 1 2 13 05 7205 713 05 7 05 78 05 7605 7 5 05 7 95 72 05 712 05 18 87 1 2 7A2 05 742 705 71 05 7 95 7 12 05 7 9 05 7905 712 05 7305 7 7 05 19 104 1 2 711105 7105 7 1 05 20 121
24. bination of the first three columns What we want to do 15 to transpose the recorded dates into frequency of dates horizontally The first three columns will be copied to the new table to identify a subject And the Datel column will be the Value column 1 2 3 4 5 6 7 8 9 38 B C D E F 1 ID Location Block subsmapl Date Date2 2 94 1 9 1 105 3 94 1 9 2 4 94 1 9 3 7 9 05 7 9 05 5 94 1 9 4 6 94 1 9 5 7 12 05 7 12 05 7 94 1 9 6 94 1 9 7 7 9 05 9 94 1 9 8 7 9 05 10 94 1 9 d 7 1 05 11 94 1 9 10 7 2 05 12 9 1 9 1 7 11 05 7 9 05 13 9 1 9 2 7 11 05 7 1 05 14 9 1 9 3 7 12 05 15 9 1 9 4 7 11 05 7 12 05 16 9 1 9 5 78505 7 16 05 17 9 1 9 6 7 9 05 7 9 05 18 9 1 9 7 7 11 05 72 05 19 9 1 9 8 7 13 05 7 11 05 209 1 9 9 7 9 05 7 9 05 E 1 9 10 7 9 05 7 13 05 22 179 1 9 1 7 9 05 7 16 05 23 179 1 9 2 7 18 05 7 27 05 24 179 1 9 3 7 18 05 7 21 05 Figure 54 Right click the TWE icon E in the system tray area Click List to table from the TWE context menu to open the List to table dialog window see Figure 55 Select Table Examples xls from the workbook dropdown list box Select FullList1 from the worksheet dropdown list box Select the first three columns that 1s ID Location and Block in the Copy Columns list box Select Datel column in the Value Column dropdown list box Select Date from data format dropdown list box Select
25. cessarily within one workbook or Excel file they can be in two different Excel files TWE provides total flexibility to your work Columns area includes a Copy Columns list box and Match Columns frame copy columns are from the source worksheet The selected columns in the Copy Columns list box will be copy to the destination worksheet based on the match columns you select in the Match Columns list box In the Match Columns frame you can select a column of the source worksheet in the bottom left drop down list box and a column of the destination worksheet in the bottom right drop down list box Once you select both columns you can click the Add button right above the drop down lists A match column entry will be inserted into the match columns list box You can add as many as match columns criteria as you want as long as they are not conflict with each other Es Join tables Worksheets Source Destination pd bogie Table Examples v Table Examples xls w Refresh Worksheet Location2 Location Without head row Without head row Selected range Selected range AT H1 AT H1 Copy Columns Match Columns Location2 Method Location2 Subject Location2 Location Location2 Var1 Locationz Var4 Location2 Var5 Add Location2 MetF jLocation2 Metr Duration Figure 39 If you do not create any match criteria before you click the Ok button you will get the follo
26. e bottom of the Worksheets area There is a Refresh button in this area If there are workbooks created or opened after the dialog window is opened you have to click this button to update workbook dropdown list Otherwise TWE does not know there are new workbooks available or workbooks closed So you 140 should click Refresh button whenever available workbooks changes In addition there is a new sheet name textbox You can optionally enter name for the new sheet Column area includes two parts Copy Columns and Columns Copy Columns list box allows you select columns that you want to copy to the destination sheet and they will be repeated as same number of times as the number of selected transpose columns By default only is the first column selected in both Copy Columns and Transpose Columns list boxes You usually select two sets of columns without overlap in these two list boxes unless you want bizarre results The column titles of selected transpose columns will be transposed to vertical and repeated again and again you should give this column a name by filling the index title textbox The values of selected transpose columns will be straightened vertically You can give this column a name by filling the value title textbox Example Figure 46 15 a table including up to ten recorded dates for each subject a combination of the first three columns What we want to do is to tr
27. en the Format columns dialog window Select a workbook and a worksheet that you want to work with Select one or more columns in the Columns to be formatted list box Choose the Numeric option in the Format to frame Click the button to convert the selected columns to numeric format Convert data format to text To convert data format to Text format in upper case the detailed steps are the following The completed Format columns dialog window is similar to Figure 11 1 2 3 4 5 6 T Right click the TWE icon E in the system tray area Click Format columns from the TWE context menu to open the Format columns dialog window Select a workbook and a worksheet that you want to work with Select one or more columns in the Columns to be formatted list box Choose the Text option in the Format to frame Select Upper in the letter case dropdown list Click the button to convert the selected columns to text format in upper case E Format columns Worksheets 10 Workbook T able Examples sls v Befresh Data sheet Without head row Selected range 1 F3741 Columns to be formatted Eel Location Block Subsmaple Datel Date Duration Format to Numeric Text Date ETT v Close Figure 11 Convert data format to date To convert data format to Date format the detailed steps are the following
28. ense and entered it the About TWE 2 0 dialog window looks like Figure 60 If you are trying the software you will get a dialog window like Figure 61 42 About TWE 2006 TWE 2006 Version 1 0 1 0 100 99 Copyright 2005 2006 Sunfine Data Co right reserved Visit us at www sunfinedata com Licensed copy Max users 1 TWE 2006 Version 1 0 1 0 100 99 Copyright 2005 2006 Sunfine Data Co All right reserved Visit us at www sunfinedata com Evaluation copy 15 days left Enter Register Figure 61 You can click Buy button in this window to go to TWE website and buy a license directly Once you get your license code through email you can click the Enter button in this window to enter the license code When you open the About TWE 2 0 dialog window next time it will look like Figure 60 43 Q amp A Software version 1 How can I upgrade to a new version From time to time we will have new updated version of TWE released You can visit our website www sunfinedata com to check if there is one available for you You can directly download it from our website to your computer and install it 2 Do you have version in my language Currently TWE is only available in English language If there are a lot of requests in your language we will consider translating TWE to your language Please let us know if you are interested in TWE 1n a different language Report bug
29. fault way There are more clicks and types TWE provides a convenient solution to achieve an easy and fast way Figure 59 shows the Rename Worksheets dialog window At the top of the window you can select a workbook that you want to work with Once a workbook 15 selected all worksheets in the workbook will be shown in the middle panel of the window There are a check box and a text box related to each worksheet You can directly change a worksheet name by modifying text in text boxes Once text in a text box 15 changed the checkbox will be automatically checked Of course you can deselect the check box even if you change the text in the text box After you change the names of the worksheets you want you can simply click button to rename worksheets Is that simple Again click Refresh button to reflect the current available workbooks in the workbook dropdown list E Rename Worksheets Workbook Table Examples xls Location Location2 Location Location FullList2 FullList2 DuplicateRows D uplicateR ows FullT able Full able Start time End time Duration Refresh Close Figure 59 Help Click Help menu item in the TWE context menu to open TWE user manual in a separate window About TWE Directly click About menu item in the TWE context menu or click the TWE icon in the system tray the About TWE 2 0 dialog window will open If you already purchased a lic
30. igure 42 tables dialog window see Figure 43 3 source worksheet 4 as the destination worksheet 5 Right click the TWE icon in the system tray Click the Join tables menu item in the TWE context menu to open the Join In the Copy Column list box select ID Name 7 9 05 7 12 05 7 13 05 7 11 05 7 9 05 7 11 05 7 9 05 7 12 05 7 13 05 29 M 10 7 12 05 7 19 05 7 11 05 7 18 05 7 7 05 7 17 05 7 9 05 7 11 05 7 11 05 7 12 05 7 17 05 Select Table Examples xls for the source workbook and ID T2 for the Select Table Examples xls for the destination workbook and FullTable T1 30 6 Add a match columns as ID ID Full Table ID in the Match Columns frame see Figure 43 7 Click the button to proceed Once job is complete the joined table 161 e In NI Le pw wn 13 1 18 35 52 69 96 103 120 137 154 171 19 B Location i gt gt gt gt S C Block E Join tables Worksheets Workbook Source Destination Table_Examples xls Table Examples ls w Worksheet Copy Columns v FullT abl amp wv Without head row Selected range 1 8188 ID ID ID Name Start 4 13 PM D 7 11 05 7 11 05 7 9 05 7 13 05 7 1 05 1 7 11 05 7 11 05 7 11 05 7 1 05 7
31. l files include data in text format even though the values are numeric The text format of numeric values 15 usually generated by applications other than Microsoft Excel If you want to manipulate these data numerically Excel does not have any response In these situations you have to turn to the Text to column function in the Data menu of Microsoft Excel You can use this function convert your data in text format into numeric format column by column Of course it is easy to write a VBA subroutine to do the tedious repeated work However VBA is relatively slow comparing with other compiled executable applications TWE provides a complete solution to solve the issue You can convert the data format from text to numeric and vice versa Overview Click Format columns menu item in the TWE context menu to open the Format columns dialog window see Figure 9 E Format columns Worksheets Workbook Examples xls m Refresh Data sheet FullList1 m Without head row Selected range 1 F3741 Columns to be formatted Format to Numeric Location Block Text Subsmaple Datel Date Date Duration Close Figure 9 Worksheets area allows you to select a workbook from available workbook list and a worksheet from the selected workbook It also allows you optionally to select Without head row and Selected range The available data range in the Al format is shown at the bottom
32. le stack option selected Click the button to proceed After the process is done a new table Figure 34 is generated This table simply stacks the two selected tables one over another 125 Stack tables Worksheets Workbook Table Examples xls v Refresh Without head row Location FullList2 Selected range Duplicates Full able AT HT D Table 2 41 lt a Dutput New sheet name Simple stack C Stack by matching column titles Start 11 46 End 11 46 Duration 0 484375s Close Figure 33 D E A B C E G H 1 Method Subject Location Vara Vard Varo D 1 1 1 0 524343 0 7704 5638 1 5506 0 203596 3 1 2 1 0 595447 0 6884 5825 1 7069 0 245157 4 1 3 1 0 232049 0 766 4472 2 2761 2 824783 5 1 4 1 0 538529 0 9802 445 1 1 7331 1 149754 6 2 1 1 0 466725 0 4288 4926 1 767 0 231655 2 2 1 0 923818 0 7653 505 6 1 8944 0 488238 8 2 3 1 0 410663 0 6802 484 8 1 9999 0 564656 H 2 4 1 0 191769 0 6905 5596 1 7355 0 945062 10 3 1 1 0 727671 0 5665 489 4 1 9569 0 347008 11 3 2 1 1 429947 0 9517 4583 1 9713 1 17819 d 3 1 5 752189 0 6916 452 3 1 57 1 306973 13 J 4 1 0 683898 0 7946 591 4 2 0426 0 524466 14 4 1 1 1 194396 0 778 501 6 2 1454 0 857254 15 4 2 1 0 890543 0 6646 436 1 5656 0 469556 16 4 3 1 0 747811 0 6571 569 1 1 535
33. le to add the selected data range to the selected range list box For some tables you might want to use a selected data range other than all available data in the worksheet In that case just check the Selected range option before you click the Add button By using the Delete and Clear buttons to delete selected data ranges or erase all data ranges in the selected range list box Output area includes a textbox for entering new sheet name and two option buttons If you d like to provide a sheet name for the new worksheet you can optionally enter the sheet name in the text box If you leave it empty TWE will create a new worksheet by using the Excel default sheet name The two option buttons are Simple stack and Stack by matching column titles If you select Simple stack option all selected data ranges will simply stack one over another into the new worksheet If you select Stack by matching column titles option all selected data ranges will stack one over another by matching their column titles To be aware that the total number of unique columns in the resultant table is limited by Microsoft Excel itself The current limit of total number of columns is 255 23 Stack tables Worksheets Workbook 58 Refresh Without head row Selected range AT H1 New sheet name Simple stack C Stack by matching column titles Start time End time Duration Bee Figure 29 If you did
34. not add any data range to the selected data range list box you will get a message box like Figure 30 after you click the Ok button Figure 30 Example 1 Simple stack Figure 31 and Figure 32 are two tables including observed data from two locations Of course we can merge two tables by copying one table and pasting it to another This is easy because we only have two tables How about we have dozens of tables It will be a tedious and error prone procedure The Simple stack method TWE provides can easily merge many tables just like a breeze For demonstration purpose the detailed steps are given below B C D E G H 1 Method Subject Location Vara arg Varo z 1 1 2 0 550766 0 8965 574b 2 4116 0 451958 3 1 2 2 0 137476 0 6655 518 5 1 9159 1 65164 4 1 3 2 2 118214 0 705 4155 1 6158 0 334634 5 1 4 2 0 895797 0 5718 442 2 2128 1 597544 6 2 1 2 0 553415 0 8091 568 1 7493 0 197852 7 2 2 2 0 481611 0 5338 536 4 1 4599 0 533531 8 2 3 2 0 627646 0 6132 321 1 9665 1 438943 H 2 4 2 1 124343 0 5054 4995 1 4162 0 401493 10 3 1 2 0 912434 1 3303 547 6 2 2807 0 46758 11 3 2 2 1 04641 1 2629 5839 1 9382 0 601172 Mz 3 3 2 0 627496 1 5935 5798 2 6683 0 696699 13 3 4 2 0 768827 1 277 5494 2 1292 0 56376 14 4 1 2 0 438704 1 4662 659 1 2 7441 0 213942 15 4 2 2 1 15324 1 4491 6299 1 5604 0 811995 16 4 E 2 1 018389 1 1049 5547 2 4555 0 560414 17 4 4 2 1 082312 1 5597 583 1 2 3143 0 571188 Figure 31 1 2 3 4 5 6 T
35. og window see Figure 25 Es Extract table Worksheets Workbook Refresh aet c mt Data sheet Location v Without head row Selected range Copy Columns Filter Columns Add Delete Clear Method Start time End time Duration dee Figure 25 Worksheets area lets you select a workbook and a worksheet from the selected workbook You also have the flexibility to select with or without column title row and current used range or selected range as the data for processing Once you make all these choices the data range will show in the Al format There is a new sheet name textbox in this area You can optionally enter a sheet name for the extracted data table Column area includes two parts The Copy Columns list box on the left side allows you select columns to be copied to the new worksheet If there are data rows available in the selected worksheet all columns in the Copy Columns list box will be automatically selected when a worksheet is selected The Filter Columns frame on the right side allows you create filter criteria This frame includes a filter criteria list box at the top three buttons in the middle and three drop down list boxes at the bottom You can use the three drop down list boxes to create criteria The first drop down listbox on the left holds all available columns You can select a column you want to create a criterion based on it Then you can
36. olumns the Filter Columns list box 7 Select Extract unique rows and deselect other checkboxes in the Output frame The completed dialog window looks like Figure 17 8 Click the Ok button to proceed After the all fields in the time area filled the newly generated unique contact list looks like Figure 18 _14 Handle duplicates W orksheets Workbook Table Examples sls v Refresh Data sheet DuplicateRows E Without head row Selected range AT D5 Copy Columns Filter Columns Phone Phone Mobile Mobile Email Email Output Mark duplicate rows V Extract duplicate rows Extract unique rows Start 2 23 PM End 2 23 PM Duration 0 21875s Dk Close Figure 17 B C D 1 Phone Mobile Email 2 Julie 151523235 152523222 julie company com 3 151523235 152523232 mat company com 4 Mark 132323222 132322222 mark company com Figure 18 Extract duplicate rows If you want to know exactly what information is redundant in a table the best way is to extract all duplicate information and put into a new table Then you can check them in detail TWE provides a complete solution for this purpose Here are the detailed steps 1 Right click the TWE icon E in the system tray area 2 Click Handle duplicates from TWE context menu to open the Handle duplicates dialog window 3 Select the Table Examples xls workbook in the workb
37. ook dropdown list box 4 Select the DuplicateRows worksheet in the worksheet dropdown list box 5 Select all columns in the Copy Columns list box 6 Select Name and Phone columns in the Filter Columns list box 7 Select Extract duplicate rows and deselect the other check boxes in the Output frame The completed dialog window looks like Figure 19 8 Click button to proceed After all fields in the time area filled the newly generated duplicate list looks like Figure 20 Handle duplicates W orksheets Workbook Table Examples sls Refresh Data sheet DuplicateRows Without head row Selected range 1 D5 Copy Columns Filter Columns Mark duplicate rows Extract duplicate rows Extract unique rows Start 2 23 PM End 2 23 PM Duration 0 21875s Ok Close Figure 19 B C A D E 1 Name IPhone Mobile Email 2 Julie 151523235 151523232 julie company com 2 Figure 20 15 Some other software requires that tables with duplicate rows should be sorted first TWE can handle duplicates efficiently in an unsorted table So it is not necessary to sort tables you are working with first and then apply appropriate TWE functions to it _16 MERGING AND SPLITTING TABLE When we use Excel to process data we often come across the following situations For example large tables need to be broken into several small tables acco
38. ooks worksheets and column title row and selected range and display currently selected data range information 6 If an instance of Microsoft Excel 15 not running before a function is executed a new instance of Microsoft Excel will be started and a blank Excel window will pop up If an instance of Microsoft Excel 15 already running workbook dropdown list s is filled with all available workbooks The active workbook 15 selected automatically The worksheets dropdown list is filled with all available worksheets of the current selected workbook The active worksheet is selected in the worksheets dropdown box By default the two check boxes are not selected Based on your situation you can select one or both of them By selecting Without head row check box TWE fills corresponding column list boxes with column titles in Column A format see Figure 6 Ex Split table Ex Split table Worksheets Worksheets Workbook Table Examples sls Refresh Workbook Table Examples sls Refresh Data sheet v Data sheet FullListl v Without head row M Without head row Selected range Selected range 41 F3741 41 F3741 0 Column Location Column B Column B Block Column C Column C Subsmaple Column D Column D Datel Datel Column Column E BEIC Column Column Start time End time Duration Start time End time Duration cu c
39. ow the number of open workbooks the name of the active workbook the number of worksheets in the active workbook the active worksheet in the active workbook and active cell in the active worksheet are shown If there 15 no open workbook the number of open workbooks will be zero and all other properties show as not available N A E Current Status of Excel Number of open workbooks Active workbook Number of worksheets Active worksheet Active cell Figure 57 Open Excel files Figure 58 is a typical Open Excel File dialog window It is used to open Excel files if you like Since the TWE application can be started even Microsoft Excel is not running you may like open Excel files before you use other functions This function is provided for your convenience Open Excel File Look in B My Documents 3 ae My Music J My Pictures My Recent Videos Documents Desktop My Documents My Computer 9155 My Network File name Wi Places Files of type Excel file xls Cancel Figure 58 41 By using this open file dialog you can open files with file extensions of XLS CSV and TXT data files will be opened in Microsoft Excel Some extra work may be needed when you open text file in Microsoft Excel Rename worksheets in batch If you rename worksheets very often or have a large number of worksheets needed to be renamed you may already feel tired of the Excel de
40. ox data format dropdown list box and three check boxes The Copy Columns list box allows you select columns that you want to copy to the destination sheet As 37 default only is the first column selected in the Copy Columns list box You can select a set of columns in the Copy columns list box and one column from the Value Column list box Then you can select data format of the value column There are four choices String Numeric Time and Date The three check boxes are optional If you do not want any values equal to zero shown in the final table select Non zero value You also have a choice to calculate cumulative counts the counts accumulate from the left to right the final table To do that simply select Cumulative counts check box Once the Cumulative counts check box is selected the No duplicates check box becomes enabled If you select it the final table does not include duplicate values in each row E List to counts Worksheets Workbook Table_Examples xls v Refresh New Sheet Name Data sheet FullListl v Without head row Selected range 1 F3741 Copy Columns Value Column Img 10 Location Data Format String Non zero value Cumulative counts m Start time End time Duration es Figure 53 Example Figure 54 1s a table including six columns in which there are two columns of recorded dates for 10 samples of each subject a com
41. proceed After the process 1s done there are three new tables Figure 24 generated Each of them includes data from one location E Split table Worksheets Workbook Table_Examples xls v Refresh Data sheet FullList2 v Without head row Selected range 1 H43 Copy Columns Filter Columns Method 5 s Start 5 56 PM End 5 56 PM Duration 1 28125s case Figure 23 Table Examples xls Group Read Only C D E E G Location Var3 Var4 553 80 582 50 447 20 445 10 492 50 505 60 484 80 559 60 489 40 458 30 452 30 591 40 501 60 436 00 569 10 552 80 1 2 1 3 1 4 1 1 1 2 1 3 1 4 1 1 1 2 1 3 1 4 1 1 1 2 1 3 1 4 1 18 19 4 MID Sheete Sheet5 X Sheet4 Locations Sheet3 Sheet2 Figure 24 If the columns you select as the filter columns have a lot of unique combinations of values there will be a large number of new tables generated by TWE It might take a fairly long time to generate all the tables Once all tables are generated you may have difficulty to handle them So you have to be clearly aware what you are going to do when you split a large table Extract table This function provides a solution for extracting a subset of rows from a large table by applying a set of user defined filter criteria _19 Overview From the TWE context menu click Extract table to open the Extract table dial
42. range list box Now the selected range list box has two data ranges Make sure the Stack by matching column titles option selected Click the button to proceed After the process 1s done a new table Figure 38 1s generated You can see the two tables stacked together without messing variables up DU Stack tables Worksheets Workbook Table E xamples xls v Refresh ICT NEN Without head row Location FullList2 Selected range Duplicates E FullT able ALFI Sheet Add Delete Clear T able_Examples xls Location 41 Table Examples xls Location2 A1 Dutput New sheet name C Simple stack Stack by matching column titles Start 11 55 4M End 11 55 Duration 0 375s Close Figure 37 D E A B C G H 1 Method PSubject Location Vara Varo 2 1 1 0 624343 07704 3 1 2 1 0 695447 0 6884 4 1 3 1 0 232049 0 766 5 1 4 1 0 538529 0 9802 2 1 1 0 466725 0 4288 7 2 2 1 0 923818 0 7853 2 3 1 0 410683 0 6802 9 2 4 1 0 191769 0 6905 10 3 1 0 727671 0 5865 11 3 2 1 1 429947 0 9517 12 3 3 1 5752189 0 6916 13 3 4 1 0 683888 0 7946 14 4 1 1 1 194396 0 778 15 4 2 1 0 890543 0 6648 1 4 3 1 0 747811 0 6571 17 4 4 1 0600701 0 7101 18 1 1 2 5746 2 4116 0 451958 19 2 2 6185 1 9159 1 65164 20 3 2 4155 1 8158 0 334834 21 4 2 442 2 2128 1 597544 22 2 1 2 568 1 7493 0 197852 23 2 2 2 535 4 1 4599 0 533531 24
43. rding to a set of rules or criteria And furthermore merging two or more tables together to generate a large one is also very common Microsoft Excel does not provide appropriate tools to solve these difficult situations What can we do now Many Excel users usually turn to VBA macros The problem related to VBA macros is slow speed limited control and so on TWE provide a suite of solutions to solve all these situations TWE provides two functions related to splitting tables and other two related to merging tables Split table This function provides a solution for splitting a large table to many small ones based on a set of user defined criteria Overview From the TWE context menu click Split a table to open the Split table dialog window see Figure 21 E Split table Worksheets Workbook Table Examples xls v Data sheet FullT able v Without head row Selected range 41 0376 Copy Columns Filter Columns Location Block 1 CD CO 74 CD Cn 4 Co Start time End time Duration Ok Close Figure 21 Worksheets area allows you select a workbook and a worksheet from the selected workbook You also have the flexibility to select with or without column title row and current used range or selected range as data for processing Once you make all these choices the data range will show in the Al format _17 Column area includes two parts The Copy Column
44. rksheets frame There 15 a Refresh button in this area If there are workbooks created or opened after the dialog window 15 opened you have to click this button to update workbook dropdown list Otherwise TWE does not know there are new workbooks available or workbooks closed So you should click the Refresh button whenever available workbooks changes In addition you can optionally provide a name for the new worksheet by entering it in the new sheet name textbox Column area includes three list boxes Copy Columns Title Column and Value Column list boxes Copy Columns list box allows you select columns that you want to copy to the destination sheet As default only 15 the first column selected in Copy Columns Title Column and Value Column list boxes You can select a set of columns in Copy columns list box and one column from both Title Column and Column list boxes TWE does not validate your selection of columns You have to make sure that the selection of columns in the list boxes makes sense E List to table Worksheets Workbook Table Examples sls Refresh New Sheet Name Data sheet FullList1 v Without head row Selected range AT F3741 Copy Columns Transpose Columns Title Column Location Location Block Subsmaple Value Column Location Block Subsmaple Start time End time Duration ee Figure 49 Figure 50 15 a
45. s list box on the left allows you to select columns to be copied to the new worksheet The Filter Columns list box on the right allows you select columns serving as filters If there are data rows available in the selected worksheet all columns in the Copy Columns list box and the first column in the Filter Columns list box will be automatically selected when a worksheet is selected If you select more than one column in the Filter Columns list box TWE will split table based on the unique combinations of values in all selected columns Example Figure 22 shows a table including 8 columns Now we want to split the table into small ones in which each table only includes data from one location That 15 the large table will be splitted by the Location column A B C D E F G H 1 Method subject Location Var Vara Varo E 1 1 1 0 62 077 563 80 1 55 0 20 3 1 2 1 0 60 0 69 562 50 1 71 0 25 4 1 3 1 0 23 D 77 447 20 2 28 2 82 5 1 4 1 0 54 0 95 445 10 1 73 1 15 6 2 1 1 0 47 043 492 60 1 77 0 23 iP 2 2 1 0 92 079 505 60 1 88 0 49 8 2 3 1 0 41 0 68 484 80 2 00 0 56 2 4 1 0 19 069 559 60 1 74 0 95 10 3 1 1 0 73 0 59 469 40 1 96 0 35 11 3 2 1 1 43 095 458 30 1 97 1 18 12 3 3 1 6 78 069 452 30 1 57 1 31 13 3 4 1 0 68 0 79 591 40 2 04 0 52 14 4 1 1 1 19 078 501 50 2 15 0 86 15 4 Z 1 0 59 0 66 436 00 1 57 0 47 16 4 3 1 0 75 0 66 569 10 1 54 0 52 17 4 4 1 0 60 0 71 552 80 1 56 0 59 18 1 1 2 0 55 090 574 60 2 41 0 45 13
46. s 1 What should I do when an error window pops up If you encounter an error unexpected error message please press Alt PrtScr to copy the error message dialog window and send it along with the data set to us support sunfinedata com Please describe the situation in detail in your email
47. s based on a set of selected columns or all columns in a table _5 Format columns Convert data format of the selected columns batch The function is more powerful and convenient than Text to columns in the Tools menu of Microsoft Excel Rename worksheets Rename worksheets in batch It largely improves the worksheet rename function that Microsoft Excel provides Other functions Open Excel files It is similar to the Excel open file function Excel information It simply shows the current status of Microsoft Excel Help It opens the TWE help files About It shows information of the TWE application You can use this dialog window to enter your license code Quit By clicking this menu item the TWE application will quit completely An overview of a typical TWE dialog Most of the TWE dialog windows share similarities To avoid redundant description of TWE dialog windows a general description of a typical TWE dialog window 15 given below Figure 5 15 a typical TWE dialog window that includes four functional areas E Join tables Worksheets Source Destination Table Sees Table_Examples xls w Refresh Worksheet Sheetl Sheet v Without hes Without head row Selected range Selected range 49 1 449 Copy Columns Match Columns Sheet Adding Help To Sheett Adding v Sheetl Adding Figure 5 Functional area A Worksheets is used to select workb
48. s in the Copy Columns list box 6 Select the Location list item in the column dropdown list box at the bottom left of the Filter Columns frame 7 Select the operator in the operator dropdown list box in the middle of the Filter Columns frame 22 8 Select 1 in the value dropdown list box in the bottom right of the Filter Columns frame 9 Click the Add button to add the filter criterion to the list box above it The completed dialog window looks like Figure 27 10 Click the OK button to proceed After the process 1s done there 1s a new table Figure 28 generated that includes all data from the Location 1 Extract table Worksheets Workbook Table_Examples xls l Refresh New Sheet Name Data sheet FullList2 m Without head row Selected range 1 H43 Copy Columns Filter Columns Location 1 Add Delete Clear Location Start 9 19 End 9 19 Duration 0 55 Figure 27 A B C D E F G H 1 Method ESubject Location Vara Vard Varo 2 j1 1 1 0 62 077 563 80 1 55 0 20 m 2 1 0 60 0 69 582 50 1 71 0 25 41 3 1 0 23 077 447 20 2 28 2 82 E 4 1 0 54 0 98 445 10 1 73 1 15 6 2 1 1 0 47 043 492 60 1 77 0 23 2 2 1 0 92 0 79 505 60 1 88 0 49 8 2 3 1 0 41 0 68 484 80 2 00 0 56 m2 4 1 0 19 0 69 559 60 1 74 0 95 103 1 1 0 73 0 59 489 40 1 96 0 35 13 2 1 1 43 0 95 458 30 1 97 1 18 12 3 1 5 75 0 69
49. sheet dropdown list box Select the first three columns that is ID Location and Block in the Copy Columns list box Select Subsmaple column in the Title Column list box Select Datel column in the Value Column list box Click the button to proceed After the process is done a new table Figure 52 is generated E List to table Worksheets Workbook Table Examples xls Refresh New Sheet Name Data sheet Without head row Selected range A1 F3741 Copy Columns Transpose Columns Title Column ID F l Location Location Block Block Subsmaple Datel Datel _ Date2 Value Column Bock Subsmaple Date Start time End time Duration Bee Figure 51 36 A B C D E F G H J K L M 1 ID Location Block 1 2 3 4 5 ri 8 9 10 2 94 1 7 9 05 7 12 05 3 9 1 g 7 1 05 7 11 05 7 1205 7 11 05 7 18 05 7905 7 11 05 7 1305 7905 7 9 05 4 179 1 5 7 05 7 1805 7 8 05 7 1805 7 1805 7 8 05 7 20 05 7 18 05 7 20 05 7 20 05 5 43 1 5 79005 7 1805 79 05 7 1805 7 1805 7 6 05 79 05 7 1805 7 9005 7 9 05 60 1 9 7 305 7 9 05 7 5 7 1705 71605 7905 7905 7 1305 7905 7 13 05 7 128 1 7 7 05 7 305 7 305 7905 7 1205 7 1105 772205 7605 7 16 05 7 13 05 8 111 1 9 7 105 71705 7A705 7905 7 9 05 9 162 1 7905 7 9 05 742405 7 1105 7 905 7905 7806 71805 7905 7 12 05 10 77 1 5 7 20 05 7A305 7 2 05
50. some financial analyses risk evaluation and so on in all Excel 15 one of common software package used daily in financial institutions The users also encounter the table manipulation problem Table manipulation is a common issue for all Excel users So how to help Excel users automate the table manipulation How can we release Excel users from the tedious activities This 15 the initial motivation to develop Table with Excel TWE The goal is to create a running fast easy to use and flexible Windows NET application Table with Excel TWE can help Excel users at all levels to deal with tables The functions TWE provides can be broken to four groups The first group includes four functions related to merging and splitting tables They are Split a table Extract a table Stack tables and Join tables The second group includes functions related to transposition of tables that 1s conversion of horizontal tables to vertical tables and vice versa They are Table to list List to table and List to counts The third group includes a function to handle duplicates format columns and rename worksheets in batch The forth group includes all other functions related to open Excel files display Excel status open the TWE PDF help file show TWE version and copyright information and quit the application TWE 15 developed based on Microsoft NET Framework It 15 a standalone Windows application TWE application icon stays in the Windows system tra
51. stribution Package latest version If this link does not work please visit www microsoft com and search for Framework and follow relevant link s to download Microsoft Net Framework redistribution package QUICK START Start the application To start TWE you can Click the TWE icon El on your desktop Once TWE 15 started a dialog window Figure 1 shows the software version copyright web address and license information of the TWE application If you have registered your copy and have license code please enter your license code by click Enter button in this window If you do not have license code please click Register button to visit http www sunfinedata com twe register html and register your copy of TWE based on your needs E About TWE 2006 TWE 2006 Version 1 0 1 0 100 99 Copyright C 2005 2006 Sunfine Data Co All right reserved Visit us at www sunfinedata com Evaluation copy 15 days left Enter Register Figure 1 If an instance of TWE 15 running you will get a message say The application 15 already running See Figure 2 Figure 2 Context menu When TWE 18 running its icon m stays in the Windows system tray In Figure 3 the first application icon on the left 15 the TWE icon context menu see Figure 4 pops up by right clicking the icon From the context menu you can access all TWE functions An overview of the TWE functions is provided in the next sections
52. t DuplicateRows v Without head row Selected range AT D5 Copy Columns Filter Columns Phone Phone Mobile Mobile Email Email Output M Mark duplicate rows Extract duplicate rows Extract unique rows Start time End time Duration Ok Close Figure 15 B 1 Phone Mobile Email 2 Julie 15152323333 15252322222 julie company com 3 15152323334 15252323222 mat company com 4 Mark 13232322222 13232222222 mark company com 5 any com Figure 16 You should be aware that the values in the mobile column are different for the two Julie entries Even though the second Julie entry was still highlighted The reason for that is we only used the first two columns Name and Phone as the filter columns If we use all columns as filter columns we will not find any duplicate rows Extract unique rows Very often is it necessary to extract all unique rows from a table with duplicate rows TWE provides a complete solution for this purpose Here are the detailed steps 1 Right click the TWE icon in the system tray area 2 Click Handle duplicates from the TWE context menu to open the Handle duplicates dialog window 3 Select the Table Examples xls workbook in the workbook dropdown list box 4 Select the DuplicateRows worksheet in the worksheet dropdown list box 5 Select all columns in the Copy Columns list box 6 Select Name and Phone c
53. ts This is an advanced function It provides a comprehensive solution to transpose a vertical list to a horizontal table The differences between this function and List to table are that it count the frequency of each value appears for each subject and report the frequency or accumulative frequency to a horizontal table The title row of the transposed counts is a set of all unique values in the value column Overview From the TWE context menu click List to table to open the List to table dialog window see Figure 53 Worksheets area is at the top of the dialog window and Column area in the middle Worksheets area allows you to select a workbook from all available workbooks and a worksheet from the selected workbook It also allows you to optionally select Without head row and Selected range The available data range in A1 format is shown at the bottom of the Worksheets frame There is a Refresh button in this area If there are workbooks created or opened after the dialog window is opened you have to click this button to update the workbook dropdown list Otherwise TWE does not know there are new workbooks available or workbook closed So you should click the Refresh button whenever available workbooks changes In addition you can optionally provide a name for the new sheet by filling the new sheet name textbox Column area includes Copy Columns list box Value Column dropdown list b
54. u Figure 6 By default TWE automatically use the used range in the selected worksheet as data range You can manually select a range and check the Selected range check box Then TWE will use the range you select see Figure 7 This dramatically increases the flexibility of the software There is a Refresh button in this area If there are workbooks created or opened after the dialog window 15 opened you have to click this button to update the workbook dropdown list Otherwise TWE does not know there are new workbooks available or workbooks closed So you should click the Refresh button whenever available workbooks changes In addition some dialog windows include a textbox that allows users to enter a sheet name The user provided name will be used to name the new sheet created by the function Ex Table to list Ex Table to list Worksheets Worksheets Workbook Table Examples xs Workbook able xamples xls v Refresh New Sheet Name Data sheet v Data sheet FullList1 v Selected Mange Selected a A1 F31 Copy Columns Transpose Columns Copy Columns Transpose Columns Location Location Location Black Location Block Block Block Subset Same Datel Datel Date Date Dale2 Date2 Index title Index title Value title Value title Start time End time Duration Start time End time Duration Close
55. uplicate rows Overview From the TWE context menu click Handle duplicates to open the Handle duplicates dialog window see Figure 13 Worksheets area lets you select a workbook and a worksheet from the selected workbook You also have the flexibility to select with or without column title row and current used range or selected range as data for processing Once you make all these choices the data range will show in the A1 format Column area includes two parts The Columns list box on the left allows you select columns to be copied to the new worksheet The Filter Columns list box on the right allows you select columns serving as filters In other word only will the selected columns in the Filter Columns list box be used to find duplicate rows If there are data rows available in the selected worksheet the columns in the Copy Columns list box and the Filter Columns list box will be automatically selected Output area has three check boxes mark duplicate rows extract duplicate rows and extract unique rows Depending what you want to pursue you can select one or more of three options De Handle duplicates W orksheets Workbook MELER ENAERS Befresh Data sheet Location Without head row Selected range AT H1 Copy Columns Filter Columns Method Subject Location Dutput Mark duplicate rows Extract duplicate rows M Extract unique rows Start time End time D
56. uration Ok Close Figure 13 Mark duplicate rows Figure 14 is a contact list There are duplicate names in the list We want to highlight the duplicate entries in the list A B E D E 1 Phone Mobile Email 2 Julie 15152323333 15252322222 julie company com 3 15152323334 15252323222 mati company com 4 Mark 13232322222 13232222222 markt company com 5 Julie 15152323333 15152323221 julie company com Figure 14 Here are the steps 1 2 3 4 5 6 T 8 Right click the TWE icon in the system tray area Click Handle duplicates from the TWE context menu to open the Handle duplicates dialog window Select the Table Examples xls workbook in the workbook dropdown list box Select the DuplicateRows worksheet in the worksheet dropdown list box Select all columns in the Copy Columns list box Select Name and Phone columns in the Filter Columns list box That means we consider a row 15 duplicate row if its values in the Name and Phone column are identical to those of another row appearing before it Select Mark duplicate rows and deselect other checkboxes in the Output frame The completed dialog window looks like Figure 15 Click the Ok button to proceed After the all fields in the time area filled the contact list looks like Figure 16 _13 Handle duplicates W orksheets Workbook Table Examples sls Refresh Data shee
57. wing error message Figure 40 The message just reminders you to create at least one matching criteria Figure 40 Match one column and copy a different column We have two tables The first table see Figure 41 includes individual observations of experimental subject that 15 the combination of the first three columns ID Location and Block The second table T2 see Figure 42 includes lookup table of ID and name Now we want to insert name in T2 into T1 based on ID values in both tables A B 1 JID Location Block 2 1 1 1 E 18 1 1 4 35 1 1 5 52 1 1 5 69 1 1 86 1 1 8 103 1 1 9 120 1 1 10 137 1 1 11 154 1 1 l2 171 1 1 13 2 1 2 14 19 1 2 15 36 1 2 16 53 1 2 70 1 2 18 87 1 2 Here the detail steps 1 2 7 13 05 7 12 05 7 12 05 7 12 05 E G H 3 4 5 71 05 7 4305 7 11 05 7 9 05 7305 7 3 05 7 9 05 7 9 05 7 9 05 7 13 05 7 13 05 7 9 05 7 905 7 11 05 7 9 05 7 1 05 7 11 05 73 5 7 11 05 71 05 7 1 05 7 11 05 7 9 05 7 9 05 7 13 05 7 45 05 7 11 05 7S5 75605 7 8 05 7 9 05 7 9 05 7 9 05 7 2 05 7 1 05 7 12 05 7 11 05 7 9 05 7 9 05 7 9 05 7 9 05 7 9 05 7 13 05 7 05 7 18 05 7 11 05 7 05 7 12 05 Figure 41 A B 1 ID Name 2 1 3 2 Name2 4 3 Name3 E 4 4 6 5 Names 9 9 6 10 9 9 11 10 10 12 11 Name11 13 12 Name12 14 13 Name13 15 14 14 15 15 15 15 15 18 17 1 F
58. y once it starts functions will be explained in detail in this manual Most time one or two examples will be presented to demonstrate the functionality of each function Main features e Format tables e Split Merge tables Transpose tables e Manipulate duplicates e Other auxiliary functions SOFTWARE INSTALLATION Hardware and software requirements Hardware 1 IBM Compatible PC 2 Intel Pentium 4 and equivalent 3 Hard disk space 5 MB Software 1 OS Windows 2000 XP Vista or later version 2 NET Microsoft Net Framework redistribution package up to version 3 5 3 Microsoft Excel 2000 2003 2007 or later version Install TWE from setup file TWE is a green software all files are packed into a zip file After you download the zip file all you have to do 15 to unzip the file to a folder you choose and then make a shortcut to point to twe exe file in the folder Then you can use it with no problem To put a shortcut to Desktop select the twe exe first and right click the mouse to open the context menu and select Send To gt Desktop create shortcut You are all set now Microsoft Framework Redistribution Package This application 1s a Net application It needs Microsoft Net to run After you install the program you should make sure that your machine has Microsoft Net Framework Redistribution Package installed If not please go to www microsoft com to download the Microsoft NET Framework Redi
Download Pdf Manuals
Related Search