1 0 0 1 0 0 0 0 1 1 1 1 1 0 1 21.TSCTitle 29.TSCTitle 31.TSCTitle 22.TSCTitle 20.TSCTitle C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory3a_sort.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory3b_totalcalc.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory3c_unitsum.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory3d_avgmin.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory3e_ifstmt.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory3f_concatenation.camrec 17.TSCTitle 4 88 0 204373770 264040437 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 6 Untitled 0 4 87 0 143373770 213373770 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 5 Untitled 0 4 86 0 119373770 163373770 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 4 Untitled 0 4 85 0 72373770 134373770 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 3 Untitled 0 4 84 0 37373770 84373770 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 2 Untitled 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory3a_sort.camrec!Screen_Stream.avi 0 1 8 37373770 264040437 0 24 804 540 312000000 0 0 0 312000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 1 inventory3a_sort.camrec!Screen_Stream 0 18.TSCTitle 0 0 4 0 37373770 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 0 18 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory3b_totalcalc.camrec!Screen_Stream.avi 0 3 8 297042150 614375483 0 24 804 540 598000000 0 0 0 598000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 8 inventory3b_totalcalc.camrec!Screen_Stream 0 4 94 0 297042150 484375483 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 9 Untitled 0 4 95 0 474375483 513375483 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 10 Untitled 0 4 96 0 503375483 614375483 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 11 Untitled 0 24.TSCTitle 0 4 4 614375483 677692722 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 12 24 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory3c_unitsum.camrec!Screen_Stream.avi 0 5 8 677692722 1031692719 0 24 804 540 516000000 0 0 0 516000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 13 inventory3c_unitsum.camrec!Screen_Stream 0 4 97 0 687649397 984786787 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 14 Untitled 0 4 98 0 889404352 949404352 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 15 Untitled 0 4 131 0 2432725317 2680198284 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 31 Untitled 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory3e_ifstmt.camrec!Screen_Stream.avi 0 9 8 2432725317 3386725317 0 24 804 540 954000000 0 0 0 954000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 30 inventory3e_ifstmt.camrec!Screen_Stream 0 30.TSCTitle 0 8 4 2382725317 2432725317 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 29 30 0 27.TSCTitle 0 2 4 264040437 297042150 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 28 27 0 4 99 0 940642162 1030783352 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 16 Untitled 0 25.TSCTitle 0 6 4 1031692719 1096091312 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 17 25 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory3d_avgmin.camrec!Screen_Stream.avi 0 7 8 1096091312 2382725317 0 24 804 540 1310660000 24025995 0 24025995 1310660000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 18 inventory3d_avgmin.camrec!Screen_Stream 0 4 100 0 1096091312 1190164475 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 19 Untitled 0 4 101 0 1182779742 1532764452 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 20 Untitled 0 4 102 0 1522764452 1642605666 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 21 Untitled 0 4 103 0 1593376661 1668758336 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 22 Untitled 0 4 104 0 1679680472 1867518628 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 23 Untitled 0 4 105 0 1919823968 2055817852 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 24 Untitled 0 4 108 0 1862749162 2074124721 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 25 Untitled 0 4 109 0 2079816323 2197042270 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 26 Untitled 0 4 110 0 2187042270 2283346081 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 27 Untitled 0 4 141 0 3951699935 4112015238 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 43 Untitled 0 4 140 0 3837052670 3961699935 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 42 Untitled 0 4 139 0 3635973895 3847052670 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 41 Untitled 0 4 138 0 3538969781 3655973895 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 40 Untitled 0 4 137 0 3436725317 3548969781 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 39 Untitled 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory3f_concatenation.camrec!Screen_Stream.avi 0 11 8 3436725317 4128725317 0 24 804 540 692000000 0 0 0 692000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 38 inventory3f_concatenation.camrec!Screen_Stream 0 32.TSCTitle 0 10 4 3386725317 3436725317 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 37 32 0 4 136 0 3220505156 3370629591 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 36 Untitled 0 4 135 0 3093310174 3230505156 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 35 Untitled 0 4 134 0 2993949211 3113310174 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 34 Untitled 0 4 133 0 2899683682 3013949211 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 33 Untitled 0 4 132 0 2660198284 2919683682 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 32 Untitled 0 0 1 0 1 0 0x00000000 1.00 154 540 157 804 40 25 10 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\sb100\sa100\f0\fs32 Highlight rows 2 - 21 by placing your cursor on the # 2\f1\fs24 \par \pard\qc\cf1\f2\fs28\par } 1 68.00 127.00 271.00 181.00 10000000 37000000 10000000 10000000 Arrow 1 1 1 84 2 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 2 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 40 25 10 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\qc\f0\fs32 Scroll down and then hold the shift key and click the number 21.\f1\par } 1 63.00 79.00 402.00 220.00 45000000 87000000 10000000 10000000 Arrow 1 1 1 85 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 2 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 190 540 193 804 120 15 65 30 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\qc\f0\fs32 Choose data, and then sort\par } 1 322.00 21.00 462.00 136.00 92000000 116000000 10000000 10000000 Curved Arrow 3 1 1 86 2 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_3.png 0xFF000000 0xFFFFFFFF 4 100 100 0 1 1 1 1 1 1 1 Curved Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 40 10 25 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs28 Sort by: category\par Then by: Item#\par and then hit OK\fs24\par } 1 89.00 152.00 227.00 219.00 116000000 166000000 10000000 10000000 Arrow 4 1 1 87 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 0 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 113 540 224 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs28 If your first row sorted in with the numbers, choose edit, undo and be sure to start without row 1 selected. \par } 1 390.00 223.00 263.00 182.00 177000000 226666667 10000000 0 Filled Rounded Rectangle 5 1 1 88 2 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 182 540 263 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs32 Place your cursor under the "total value" heading. Type = and then then click on the quantity in that row, and then type * and then click on the unit value in that row, and then press . \f1\fs24\par \pard\f2\fs28\par } 1 377.00 278.00 419.00 183.00 10000000 187333333 10000000 0 Filled Rounded Rectangle 5 8 1 94 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 183 540 419 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs24 Right click on that cell and choose copy. \par \par \pard\f1\fs32\par } 1 377.00 278.00 419.00 183.00 187333333 216333333 10000000 0 Filled Rounded Rectangle 6 8 1 95 2 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 183 540 419 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs24 Highlight that cell and then hit shift and highlight the last total value cell so that all the total value cells are highlighted. Right click and choose paste. \par \pard\f1\par } 1 377.00 278.00 419.00 183.00 216333333 317333333 10000000 0 Filled Rounded Rectangle 7 8 1 96 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 183 540 419 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs32 Place your cursor below the last quantity. Press the sum button (which looks like a Greek E) and then press Enter.\par (You must be ON the cell with the whole box highlighted, not IN the cell with the blinking cursor.)\f1\fs24\par \pard\f2\par } 1 401.00 209.00 349.00 251.00 19956675 307094065 10000000 0 Filled Rounded Rectangle 20 13 1 97 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 183 540 349 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs32\'b7 Highlight that cell \par \'b7 Choose format / cells\f1\fs24\par \par \pard\f2\fs32\par } 1 401.00 277.00 349.00 183.00 221711630 271711630 10000000 0 Filled Rounded Rectangle 9 13 1 98 2 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 183 540 349 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs32\'b7 Choose borders\par \'b7 Hit the double line tool\par \'b7 Click on the line above the box \f1\fs24\par \pard\f2\fs32\par } 1 10.00 162.00 249.00 251.00 272949440 353090630 10000000 0 Filled Rounded Rectangle 10 13 1 99 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 251 540 249 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs32 Start by just writing average and minimum\par } 1 10.00 162.00 249.00 251.00 34025995 118099158 10000000 0 Filled Rounded Rectangle 11 18 1 100 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 251 540 249 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs32 - Place your cursor in the cell under total quantity\par - Insert / function / statistical / AVERAGE \f1\fs24\par \pard\f2\fs32\par } 1 0.00 237.00 250.00 146.00 120714425 460699135 10000000 0 Filled Rounded Rectangle 12 18 1 101 2 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 146 540 250 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs32 Now, with this Function Argument dialog, click on D2 and drag down to D21.\par } 1 0.00 237.00 250.00 145.00 460699135 570540349 10000000 0 Filled Rounded Rectangle 13 18 1 102 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 146 540 250 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs32 Now, press enter to keep it.\par \par } 1 0.00 392.00 250.00 70.00 531311344 596693019 10000000 0 Filled Rounded Rectangle 14 18 1 103 2 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 70 540 250 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs32 Calculate the minimum quantity by placing your cursor in the cell under average quantity. Insert / function / statistical / MINIMUM\f1\fs24 \par \pard\f2\fs32\par } 1 5.00 159.00 250.00 211.00 617615155 795453311 10000000 0 Filled Rounded Rectangle 15 18 1 104 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 145 540 250 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs32 Again, with this Function Argument dialog showing, click on D2 and drag down to D21.\par } 1 0.00 237.00 250.00 145.00 857758651 983752535 10000000 0 Filled Rounded Rectangle 16 18 1 105 2 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 146 540 250 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs32 Now, press enter to keep it.\par \par } 1 0.00 392.00 250.00 70.00 800683845 1002059404 10000000 0 Filled Rounded Rectangle 14 (1) 18 1 108 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 70 540 250 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs32 Copy these functions to the unit value and total value columns by highlighting the two cells you just created and right click Choose copy \par \pard\f1\par } 1 0.00 250.00 250.00 212.00 1017751006 1124976953 10000000 0 Filled Rounded Rectangle 18 18 1 109 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 212 540 250 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs32 Highlight the cells under unit value and total value and right click and press paste. \f1\fs24\par \pard\f2\fs32\par } 1 0.00 250.00 250.00 212.00 1124976953 1211280764 10000000 0 Filled Rounded Rectangle 19 18 1 110 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 154 540 157 804 40 10 25 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs24 Insert / Function / Logical and double click IF \par \pard\f1\fs28\par } 1 89.00 152.00 227.00 219.00 10000000 237472967 10000000 10000000 Arrow 20 30 1 131 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 0 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 154 540 157 804 40 10 25 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs24 The logical test is "Is the quantity more than 1?" \par So, click on D2 and then type > 1\par \pard\f1\fs28\par } 1 89.00 152.00 227.00 219.00 237472967 476958365 10000000 10000000 Arrow 21 30 1 132 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 0 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 154 540 157 804 40 10 25 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs24 Now, type what you want to show when the answer to the question is true - Type "Yes"\par } 1 185.00 47.00 227.00 219.00 476958365 571223894 10000000 10000000 Arrow 22 30 1 133 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 0 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 154 540 157 804 40 10 25 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs24 And now, type what you want to show when the answer to the question is false - Type "No" \par Then Press OK\par } 1 197.00 81.00 227.00 219.00 571223894 670584857 10000000 10000000 Arrow 23 30 1 134 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 0 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 251 540 349 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs24 Now you want to copy this formula from this one cell, to all the others, and Excel will properly adjust the formula to look at the quantity in the correct row. \par } 1 106.00 217.00 349.00 251.00 670584857 797779839 10000000 0 Filled Rounded Rectangle 25 30 1 135 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 251 540 349 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs24 See how the No changes automatically to a Yes when the quantity changes to a number greater than 1.\par } 1 105.00 329.00 349.00 85.00 797779839 937904274 10000000 0 Filled Rounded Rectangle 25 30 1 136 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 85 540 349 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs40 type the following: \b\i = "I have " &\b0\i0\line Some places to go wrong:\par \fs32 If you forget the "=", it wont work at all\par If you forget the space after have before the ", it will show I have2 \fs36 instead of I have 2.\par If you forget the quotes, it will not work.\par If you forget the ampersand (& - shift / 7), it will not work\par \pard\f1\fs24\par } 1 37.00 236.00 698.00 300.00 10000000 112244464 10000000 0 Filled Rounded Rectangle 26 38 1 137 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 154 540 157 804 10 40 40 25 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs24 While still in the formula, after the &, click on the quantity. It will know that you want that cell in your formula. If you forgot the = sign in the beginning, this wont work.\par } 1 64.00 249.00 428.00 258.00 112244464 209248578 10000000 10000000 Arrow 28 38 1 138 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 3 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 300 540 698 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs36 Now finish by typing \b\i & " of " &\b0\i0 and then hitting the first item cell. (See that every "term" is separated by an &.)\par } 1 386.00 291.00 388.00 195.00 209248578 410327353 10000000 0 Filled Rounded Rectangle 29 38 1 139 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 196 540 388 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs36 Now, copy this formula to all the cells below it, and Excel will kindly move all the cell references in the formula down one line, so that each formula deals with its own row. \par } 1 137.00 255.00 388.00 196.00 410327353 524974618 10000000 0 Filled Rounded Rectangle 29 38 1 140 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x00FFFFFF 1.00 196 540 388 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\f0\fs36 See how changing the quantity or item changes the sentence automatically.\par } 1 137.00 326.00 388.00 125.00 524974618 675289921 10000000 0 Filled Rounded Rectangle 30 38 1 141 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\Program Files\TechSmith\Camtasia Studio 3\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 0x000003E9 11 Sort by Category and then by number 1 0 0 6306163 0x000003EE 12 Calculate the total value as quantity * unit value 1 0 28 0 0x000003EC 13 Total the quantity and total value columns with a double bar above them 1 0 12 0 0x000003ED 14 Calculate the average and minimum for quantity, unit value and total value: 1 0 17 0 0x000003EA 15 If Statement More than 1 1 0 29 0 0x000003EB 16 - Sentence about an item - concatenate text 1 0 37 0 1 0 0 0 16666668 0 0 1 1 0 226666667 295333332 0 0 0 0 0 37373770 50000000 2 0 3 0 0 0 86000001 0 0 3 1 0 317333333 511999999 0 0 4 0 0 27039262 50000000 2 0 5 0 0 329333333 468666668 0 0 5 1 0 324000000 346666668 0 0 2 0 0 33001713 50000000 2 0 6 0 0 33085478 50000000 2 31 16 - Sentence about an item - concatenate text 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\qc\f0\fs48 Now, type what you want to show when the answer to the question is true - Type "Yes"\par \par Just as you use formulas to add numbers, you can use formulas to put text together. In this case, you will be putting together the words "I have" plus the quantity plus the word of and then the item. \par \par Instead of using the + sign, you will use the concatenation sign (& - which is Shift / 7).\par } 10.00 10.00 784.00 520.00 1 1 804 540 30 15 If Statement More than 1 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\sb100\sa100\f0\fs48 Under "More than 1", use an if statement to show "yes" if the quantity is more than one and "no" otherwise. (Do not just type in yes and no into the cells, and be sure at least one turns out to be yes and another no.) \par \par An If Statement is a function with 3 parts:\par --- the question (Is the value in the quantity cell more than 1?\par -- what to show if the answer is yes\par --- what to show if the answer is no\par \par Remember to start on the cell where you want the answer to show.\f1\fs24\par \pard\qc\cf1\f0\fs48\par } 10.00 10.00 784.00 520.00 1 1 804 540 29 15 If Statement More than 1 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\sb100\sa100\f0\fs48 Under "More than 1", use an if statement to show "yes" if the quantity is more than one and "no" otherwise. (Do not just type in yes and no into the cells, and be sure at least one turns out to be yes and another no.) \par \par An If Statement is a function with 3 parts:\par --- the question (Is the value in the quantity cell more than 1?\par -- what to show if the answer is yes\par --- what to show if the answer is no\par \par Remember to start on the cell where you want the answer to show.\f1\fs24\par \pard\qc\cf1\f0\fs48\par } 10.00 10.00 784.00 520.00 1 1 804 540 27 12 Calculate the total value as quantity * unit value 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Arial;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\sb100\sa100\qc\cf1\f0\fs72 Calculate the total value as quantity * unit value \par \pard\qc\f1\fs36\par } 10.00 10.00 784.00 520.00 1 1 804 540 18 11. Sort by Category and then by number 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red255\green255\blue255;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs36 Sort by Category and then by number\cf2\par } 10.00 10.00 620.00 460.00 1 1 640 480 17 Sort by Category and then by number 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red255\green255\blue255;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs36 Sort by Category and then by number\cf2\par } 10.00 10.00 620.00 460.00 1 1 640 480 20 Calculate the total value as quantity * unit value 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Arial;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\sb100\sa100\qc\cf1\f0\fs72 Calculate the total value as quantity * unit value \par \pard\qc\f1\fs36\par } 10.00 10.00 784.00 520.00 1 1 804 540 21 13. Total the quantity and total value columns with a double bar above them 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\sb100\sa100\cf1\f0\fs72 Total the quantity and total value columns with a double bar above them \par \pard\qc\par } 10.00 10.00 784.00 520.00 1 1 804 540 22 Calculate the average and minimum for quantity, unit value and total value: 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\sb100\sa100\cf1\f0\fs72 Calculate the average and minimum for quantity, unit value and total value:\par \pard\qc\par } 10.00 10.00 784.00 520.00 1 1 804 540 24 13 Total the quantity and total value columns with a double bar above them 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\sb100\sa100\cf1\f0\fs72 Total the quantity and total value columns\par and put a double bar above them \par A total at the bottom of a column is really a sum function. Always start a function on the cell you want the result to show.\par \pard\qc\par } 10.00 10.00 784.00 520.00 1 1 804 540 25 14 Calculate the average and minimum for quantity, unit value and total value: 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\sb100\sa100\cf1\f0\fs72 Calculate the average and minimum for quantity, unit value and total value:\par \fs40\par Note: To use a function, you first put your cursor where you want the function to go, and then insert the function and then select the other cells the function looks at ... START IN THE CELL WHERE YOU WANT THE NUMBER TO APPEAR.\par Good luck. (It will start soon.) \fs72\par \pard\qc\par } 10.00 10.00 784.00 520.00 1 1 804 540 32 16 - Sentence about an item - concatenate text 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\i\f0\fs40 Under "Sentence about item", create a concatenation of "I have " + quantity + " of " + long description\i0\fs48\par \pard Just as you use formulas to add numbers, you can use formulas to put text together. In this case, you will be putting together the words "I have" plus the quantity plus the word of and then the item. \par \par Instead of using the + sign, you will use the concatenation sign (& - which is Shift / 7).\par } 10.00 10.00 784.00 520.00 1 1 804 540 32 0 0 1