ࡱ>  ~0}~z[@ Qbjbj44 "ViViQ@@@@@@@T (!lT\2!.$$$$%+-7777=D7Id\$-^R`\-@.%%..\@@$$\....@$@$7..7.0..r4o@@6$! j]Q .67\0\6Va.a6TT@@@@a@6 ........\\TTX D.TTX Excel Tutorial to Improve Your Efficiency Introduction Our purpose with this Excel tutorial is to illustrate some Excel tips that will dramatically improve your efficiency. We make no attempt to be as encyclopedic as some of the 800-page Excel manuals available. We concentrate on common tasks, not every last thing that can be done in Excel. Also, we presume that you have some Excel knowledge. We assume you know about rows and columns, values, labels, and formulas, relative and absolute addresses, and other basic Excel elements. If you know virtually nothing about Excel, you probably ought to work through an Excel for Dummies book and then work through this tutorial. The style of this tutorial should be easy to follow. Main topics appear in bold black type. Specific direction headings are in bright yellow, and these are followed by detailed directions in bright red. Additional comments about the directions appear in blue. A key feature of this tutorial is that we have embedded numerous sample Excel spreadsheets so that you can try out the directions right awaywithout switching into Excel. When you double-click on one of these spreadsheets, you launch Excel, and the spreadsheet comes alive. The menus and toolbars even change to those for Excel. By clicking outside one of these spreadsheets, youre back in Word. A few of the topics are best carried out on your own PC (as opposed to your schools networked PCs), and we havent included sample spreadsheets for these. The reason is that they change the way a specific copy of Excel is set up. If you do one of these exercises on your schools networked PCs, the chances are that they wont take effect, at least not permanently, because of the way Excel is set up on the network. These topics are preceded by asterisks. Try them on your own home PC, where you have complete control. The easiest way to maneuver around this tutorial is to take advantage of built-in bookmarks. Each main section is bookmarked. To go to any section, use Words Edit/Go To menu item, select Bookmark under Go To What, and choose from the drop-down list of bookmarks. You can do this at any time to find a topic you want to explore. In fact, try it right now to get a quick feel for the topics covered in this tutorial. Finally, we suggest that you save this fileRIGHT NOWas MyXLTutorial.doc (or some such name) and work with the copy. That way, if you mess anything up as you try the exercises, you can always go back and retrieve the original file (ExcelTutorial.doc). Have fun! Moving to the top of the sheet Often you want to reorient yourself by going back to the home position on the worksheet. To go to the top left of the sheet (cell A1): Press Ctrl-Home (both keys at once). Try it! EMBED Excel.Sheet.8 Using End-arrow key combinations To go to the end of a range (top, bottom, left, or right): Press the End key, then the appropriate arrow key. For example, press End and then right arrow to go to the right edge of a range. Try it! Starting at a corner (a bordered cell), move around to the other corners EMBED Excel.Sheet.8 The action of an End-arrow combination depends on where you start. It takes you to the last nonblank cell if you start in a nonblank cell. (If there arent any nonblank cells in that direction, it takes you to the far edge of the sheet.) If you start in a blank cell, it takes you to the first nonblank cell. Splitting the screen It is often useful to split the screen so that you can see more information. To split the screen vertically, horizontally, or both: Click on the narrow screen splitter bar just to the right of the bottom scroll bar (for vertical splitting) or just above the right-hand scroll bar (for horizontal splitting) and drag this to the left or down. Splitting gives you two panes (or four if you split in both directions). Once you have these panes, practice scrolling around in any of them, and see how the others react. Try it! Split the screen either way and then remove the split EMBED Excel.Sheet.8 Selecting a range Usually in Excel, you select a range and then do something to it (such as enter a formula in it, format it, delete its contents, and so on). Therefore, it is extremely important to be able to select a range efficiently. Its easy if the whole range appears on the screen, but its a bit trickier if you cant see the whole range. In the latter case the effect of dragging (the method most users try) can be frustratingthings scroll by too quickly. Try one of the methods below instead. To select a range that fits on a screen: Click on one corner of the range and drag to the opposite corner. Or: Click on one corner, hold down the Shift key, and click on the opposite corner. Try it! Select the range B2:D7. EMBED Excel.Sheet.8 To select a range doesnt fit on a screen: Click on one corner of the range, say, the upper left corner. Then, holding the Shift key down, use the End-arrow combinations (End and right arrow, then, if necessary, End and down arrow) to get to the opposite corner. Or: Split the screen so that one corner shows in one pane and the opposite corner shows in the other pane. Click on one corner, hold the Shift key down, and click on the opposite corner. Try it! Select the range B2:C100 or the range E2:N5. Try both of the methods suggested above. EMBED Excel.Sheet.8 Selecting more than one range Say you want to format more than one range in a certain way (as currency, for example). The quickest way is to select all ranges at once and then format them all at once. To select more than one range: Select the first range, press the Ctrl key, select the second range, press the Ctrl key, select the third range, and so on. For example, to select the ranges B2:D5 and F2:H5, click on B2, hold down the Shift key and click on D5 (so now the first range is selected), hold down the Ctrl key and click on F2, and finally hold down the Shift key and click on H5. Try it! Select all three numerical ranges shown. EMBED Excel.Sheet.8 Copying and pasting Copying and pasting (usually formulas) is one of the most frequently done tasks in Excel, and it can be a real time-waster if done inefficiently. Many people do it as follows. They select the range to be copied (often in an inefficient manner), then select the Edit/Copy menu item, then select the paste range (again, often inefficiently), and finally select the Edit/Paste menu item. There are much better ways to get the job done! To copy and paste using keyboard shortcuts: Select the copy range (using one of the efficient selection methods described above), press Ctrl-c (for copy), select the paste range (again, efficiently), and press Ctrl-v (for paste). The copy range will still have a dotted line around it. Press the Esc key to get rid of it. Try it! Copy the formula in cell C2 down through cell C8 using Ctrl-c and Ctrl-v. EMBED Excel.Sheet.8 To copy and paste using toolbar buttons: Proceed as above, but use the copy and paste toolbar buttons (on the top toolbar) instead of the Ctrl-c and Ctrl-v key combinations. Try it! Copy the formula in C2 down through cell C8 using the Copy and Paste buttons. EMBED Excel.Sheet.8 Buttons or key combinations? Its a matter of personal taste, but either is a lot quicker than menu choices! A frequent task is to enter a formula in one cell and copy it down a row or across a column. There are several very efficient ways to do this. To avoid copying and pasting altogether, use Ctrl-Enter: Starting with the top or left-hand cell, select the range where the results will go. (Use the selection methods described earlier, especially if this range is a long one.) Type in the formula, and press Ctrl-Enter instead of Enter. Try it! Fill up the range C2:C8 with Ctrl-Enter. EMBED Excel.Sheet.8 Pressing Ctrl-Enter enters what you typed in all of the selected cells (adjusted for relative addresses), so in general, it can be a real time saver. For example, it could be used to enter the number 10 in a whole range of cells. Just select the range, type 10, and press Ctrl-Enter. Try it! Fill up the range B2:D8 with the value 10 by using Ctrl-Enter. EMBED Excel.Sheet.8 To copy with the drag handle: Enter the formula in the top or left-hand cell of the intended range. Place the cursor on the drag handle at the lower right of this cell (the cursor becomes a plus sign), and drag this handle down or across to copy. Try it! Copy the formula in C2 down through C8 with the drag handle. EMBED Excel.Sheet.8 To copy by double-clicking on the drag handle: Enter the formula in the top or left-hand cell of the intended range. Double-click on the drag handle. This method uses Excels built-in intelligence, but it only works in certain situations. Lets say you have numbers in the range A3:B100. You want to enter a formula in cell C3 and copy it down to cell C100. Since this is a common thing to do, Excel does it for you if you double-click on the drag handle. It senses the filled-up range in column B and figures you want another filled-up range right next to it in column C. If there were no adjacent filled-up range, double-clicking on the drag handle wouldnt work. Try it! Copy the formula in C2 down through C8 by double-clicking the drag handle. EMBED Excel.Sheet.8 Copying and Pasting with the Special/Values option Often you have a range of cells that contains formulas, and you would like to replace the formulas with the values they produce. Usually, you paste these values onto the copy range, that is, you overwrite the formulas with values. However, you could also select another range for the paste range. To copy formulas and paste values: Select the range with formulas, press Ctrl-c to copy, and select the range where you want to paste the values (which could be the same as the copy range). Then (since there is no keyboard equivalent) select the Edit/Paste Special menu item, and select the Values option. Try it! Copy the range D2:D8 to itself, but paste values. EMBED Excel.Sheet.8 You might want to experiment with the other options on the Edit/Paste Special dialog box. For example, if you have a set of labels entered as a row and you want this same set of labels entered somewhere else as a column, try copying and pasting special with the Transpose option. Moving (cutting and pasting) Often you would like to move information from one place in the sheet to another. To move (cut and paste): Select the range to be cut, press Ctrl-x (for cutting), select the upper left corner of the paste range, and press Ctrl-v. As with copying and pasting, toolbar buttons can be used instead of key combinations, but either is more efficient than selecting menu items. Also, note that you only need to select the upper left cell of the paste range. Excel knows that the shape of the paste range is the same as the shape of the cut range. Try it! Move the range A2:C8 to the range D2:F8. (Watch how relative addresses affect the eventual formulas in column F.) EMBED Excel.Sheet.8 Using absolute/relative references Absolute and references are indicated in formulas by dollar signs or the lack of them, and they indicate what happens when you copy or move a formula to a range. You typically want some parts of the formula to stay fixed (absolute) and others to change relative to the cell position. This is a crucial concept for efficiency in spreadsheet operations, so you should take some time to understand it thoroughly. Here are two keys. (1) The dollar signs are relevant only for the purpose of copying or moving; they have no inherent effect on the formula. For example, the formulas =5*B3 and =5*$B$3 in cell C3, say, produce exactly the same result. Their difference is relevant only if cell C3 is copied or moved to some range. (2) There is never any need to type the dollar signs. This can be done with the F4 key. To make a cell reference absolute or mixed absolute/relative using the F4 key: Enter a cell reference such as B3 in a formula. Then press the F4 key. In fact, pressing the F4 key repeatedly cycles through the possibilities: B3 (neither row nor column fixed), then $B$3 (both column B and row 3 fixed), then B$3 (only row 3 fixed), then $B3 (only column B fixed), and back again to B3. Try it! Enter the appropriate formula in cell B7 and copy across to E7. (Scroll to the right to see the correct answer.) EMBED Excel.Sheet.8 Try it again! Enter one formula with appropriate absolute/relative addressing in cell C5 that can be copied to C5:F9. (Scroll to the right to see the correct answer.) EMBED Excel.Sheet.8 Inserting and deleting rows or columns Often you want to insert or delete rows or columns. Note that deleting a row or column is not the same as clearing the contents of a row or column, that is, making all of its cells blank. Deleting means wiping it out completely. To insert one or more blank rows: Click on a row number and drag down as many rows as you want to insert, and then press Alt-i and then r (the menu equivalent of Insert/Row). The rows you insert are inserted above the first row you selected. For example, if you select rows 8 through 11 and then insert, four blank rows will be inserted between the old rows 7 and 8. Try it! Insert blank rows for the data for Feb, Apr, and May. EMBED Excel.Sheet.8 Columns are inserted in the same way, except that the key sequence is Alt-i and then c. Try it! Insert blank columns for sales reps Baker, Miller, and Smith (so that the sales reps are in alphabetical order from left to right). EMBED Excel.Sheet.8 To delete one or more rows: Click on a row number and drag down as many rows as you want to delete, and then press Alt-e and then d (the menu equivalent of Edit/Delete). Columns are deleted in exactly the same way. Try it! The company no longer carries products K322 and R543, so get rid of their rows. EMBED Excel.Sheet.8 Filling a series Say you want to fill column A, starting in cell A2, with the values 1, 2, and so on up to 1000. There is an easy way. To fill a column range with a series: Enter the first value in the first cell (1 in cell A2). With the cursor in the starting cell (A2), use the menu item Edit/Fill/Series to obtain a dialog box. Change the Row setting to Column, make sure the Type setting is Linear, make sure 1 is in the Step Value box, enter the final value (1000) in the Stop Value box, and click on OK. As you can guess from this dialog box, many other options are possible. Dont be afraid to experiment with them. Try it! The series of days in column A should go from 1 to 25, in column D it should go from 26 to 50. EMBED Excel.Sheet.8 Using the summation button The SUM function is used so often to sum across rows or columns that a toolbar button (the S button) is available to automate the procedure. To illustrate its use, suppose you have a table of numbers in the range B3:E7. You want the row sums to appear in the range F3:F7, and you want the column sums to appear in the range B8:E8. Its easy. To produce row and column sums with the summation button: Select the range(s) where you want the sums (F3:F7 and B8:E8remember how to select multiple ranges), and click on the summation button. Note that if you select multiple cells, you get the sums automatically. If you select a single cell (such as when you have a single column of numbers to sum), youll be shown the sum formula for your approval and youll have to press Enter to actually enter it. Why does Excel do it this wayyour guess is as good as ours! Try it! Use the summation button to fill in the row and column sums. EMBED Excel.Sheet.8 Using range names Range names are extremely useful for making your formulas more understandable. After all, which formula makes more sense: =B20-B21 or =Revenue-Cost? Efficient use of range names takes some experience, but here are a few useful tips. To create a range name: Select a range that you want to name. Then type the desired range name in the upper left name box on the screen. (This box is just above the column A heading. It usually shows the cell address, such as E13, where the cursor is.) You could go through the Insert/Name/Define menu item, but typing in the name box is quicker and more intuitive. By the way, range names are not case sensitive. For example, Revenue, revenue, and REVENUE can be used interchangeably. Try it! Name the rectangular range containing the numbers Data. EMBED Excel.Sheet.8 To delete a range name: Use the Insert/Name/Define menu item. This shows a list of all range names in your workbook. Click on the one you want to delete, and then click on the delete button. Try it! The numerical range is currently named Data. Delete this range name and then rename the range Database. EMBED Excel.Sheet.8 Suppose you have the labels Revenue, Cost, and Profit in cells A20, A21, and A22, and you would like the cells B20, B21, and B22 (which will contain the values of revenue, cost, and profit) to have these range names. Heres how to do it quickly. To create range names from adjacent labels: Select the range consisting of the labels and the cells to be named (A20:B22). Then use the Insert/Name/Create menu item, make sure the appropriate box (in this case, Left Column) is checked, and click on OK. Excel tries (usually successfully) to guess where the labels are that you want to use as range names. If it guesses incorrectly, you can always override its guess. Try it! Name the ranges A3:A8, B3:B8, and so on according to the labels in row 2. EMBED Excel.Sheet.8 Sometimes you have entered a formula using cell addresses, such as =B20-B21. Later, you name B20 as Revenue and B21 as Cost. The formula does not change to =Revenue-Cost automatically. However, you can make it change (and hence become more readable). To apply range names to an existing formula: Select the cell (or range of cells) with the formula(s). Then use the Insert/Name/Apply menu item, highlight any relevant range names for the formula(s) involved, and click on OK. Try it! Apply the names of the cells B2 and B3 to the formulas in row 7. EMBED Excel.Sheet.8 To see a list of all range names and check which ranges they apply to: Click on the down arrow at the right of the name box, and click on any of the range names you see. That range will then be selected automatically. Try it! There are five named ranges below. Locate them. EMBED Excel.Sheet.8 Sometimes it is straightforward to use range names in formulas. For example, if B20 is named Revenue and B21 is named Cost, then entering the formula =Revenue-Cost in, say, cell B22 is a natural thing to do. But consider this situation. The range B3:B14 contains revenues for each of 12 months, and its range name is Revenues. Similarly, C3:C14 contains costs, and its range name is Costs. For each month you want that months revenue minus cost in the appropriate cell in column D. You will get it correct if you select the range D3:D14, type the formula =Revenues-Costs, and press Ctrl-Enter. If you click on any cell in this range, youll see the formula =Revenues-Costs. This can be confusing. How does Excel know that the formula in D3, for example, is really =B3-C3? Lets just say that its smart enough to figure this out. If it confuses you, however, you can always enter =B3-C3 and copy it down. Then youre safe, but youve lost the advantage of range names! Try it! Enter the formula for all of D3:D14 using range names. (If you like, calculate profits again in column E in the usual way, without range names.) EMBED Excel.Sheet.8 Useful functions There are many useful functions in Excel. You should become familiar with the ones most useful to you (for example, financial analysts should learn the financial functions), but here are a few everyone should know. (By the way, we capitalize the names of these functions just for emphasis. However, they are not case sensitive. You can enter SUM or sum, for example, with the same result.) To use the SUM function: Enter the formula =SUM(range), where range is any range. This sums the numerical values in the range. Actually, it is possible to include more than one range in a SUM formula, so long as they are separated by commas. (This can also be done with the COUNT, COUNTA, AVERAGE, MAX, and MIN functions discussed below.) For example, =SUM(B5,C10:D12,Revenues) is allowable (where Revenues is a name for some range). The result is the sum of the numerical values in all of these ranges combined. Note that if any cells in any of these ranges contain a label (not a number), it is ignored in the sum. Try it! Use the SUM function in cell B10 to calculate the total of all costs. EMBED Excel.Sheet.8 To use the COUNT function: Enter the formula =COUNT(range), where range is any range. This produces the number of numerical values in the range. There is a similar function, COUNTA, which counts all of the cells, numerical or otherwise, in the range(s). For example, if cells A1, A2, and A3 contain Month, 1, and 2, respectively, then =COUNT(A1:A3) yields 2, whereas =COUNTA(A1:A3) yields 3. Try it! Use the COUNT and COUNTA functions to fill in cells E1 and E2. Note that there are students below the visible portion of the spreadsheet. EMBED Excel.Sheet.8 To use the AVERAGE function: Enter the formula =AVERAGE(range) where range is any range. This produces the average of the numerical values in the range. Be aware that the AVERAGE function ignores labels and blank cells in the average. So, for example, if the range C3:C50 includes scores for students on a test, but cells C6 and C32 are blank because these students havent yet taken the test, then =AVERAGE(C3:C50) averages only the scores for the students who took the test. (It doesnt automatically average in zeroes for the two who didnt take the test.) Try it! Use the AVERAGE function to calculate the averages in cells B1 and B2. (For B2, youll have to replicate the exam scores in column C and make some changes.) EMBED Excel.Sheet.8 To use MAX and MIN functions: Enter the formula =MAX(range) or =MIN(range) where range is any range. These produce the obvious results: the maximum (or minimum) value in the range. Try it! Use the MAX and MIN functions to fill in the range B8:C9. For example, you want the values $2300 and $3600 in cells B8 and C9. EMBED Excel.Sheet.8 Using the paste function (fx) button in the top toolbar If you havent used this button, you should give it a try. It not only lists all of the functions available in Excel (by category), but it also leads you through the use of them. As an example, suppose you know there is an Excel function that does net present value, but youre not sure what its name is or how to use it. You could proceed as follows. To use the paste function wizard: Select a blank cell where you want the function to go. Press the fx button and click on the category that seems most appropriate (Financial in this case). Scan through the list for a likely candidate and select it (try NPV). At this point you can get help, or you can press the Next button and enter the appropriate arguments for the function (discount rate and one or more ranges of values). Try it! Use the function wizard to help you determine the function in cell B6. Use the range names in cells B3 through B5 for improved readability. (Scroll to the right to see the correct formula.) EMBED Excel.Sheet.8 Using IF functions IF functions are very useful, and they vary from simple to very complex. Well provide a few examples. To enter a basic IF function: Enter the formula =IF(condition,expression1,expression2), where condition is any condition that is either true or false, expression1 is the value of the formula if the condition is true, and expression2 is the value of the formula if the condition is false. A simple example is =IF(A1<5,10,NA). Note that if either of the expressions is a label (as opposed to a numerical value), it should be enclosed in double quotes. Try it! Enter appropriate IF formulas in columns C and D. (Scroll to the right to see the correct answer.) EMBED Excel.Sheet.8 Sometimes IF functions are nested. For example, there might be three possibilities, depending on whether the value in cell A1 is negative, zero, or positive. A nested IF formula could then be used as follows. To use nested IF functions: Enter the formula =IF(condition1,expression1,IF(condition2,expression2,expression3)). If condition1 is true, the relevant value is expression1. Otherwise, we check condition2. If it is true, the relevant value is expression2. Otherwise, the relevant value is expression3. An example is =IF(A1<0,10,IF(A1=0,20,30)). Suppose this formula is entered in cell B2. Then if A1 contains a negative number, B2 contains 10. Otherwise, if A1 contains 0, B2 contains 20. Otherwise (meaning that A1 must contain a positive value), B2 contains 30. Try it! Use a nested IF function to fill in the grades in column C. (Scroll to the right to see the correct answer.) EMBED Excel.Sheet.8 Sometimes more complex conditions (AND or OR conditions) are useful in IF functions. These are not difficult once you know the syntax. To use an AND condition in an IF function: Enter the formula =IF(AND(condition1,condition2),expression1,expression2). This results in expression1 if both condition1 and condition2 are true. Otherwise, it results in expression2. Note the syntax. The keyword AND is followed by the conditions, separated by a comma and enclosed within parentheses. Of course, more than two conditions could be included in the AND. Try it! Use an IF function with an AND condition to fill in the bordered range. (Scroll to the right to see the correct answer - note the double quotes for labels.) EMBED Excel.Sheet.8 To use an OR condition in an IF function: Enter the formula =IF(OR(condition1,condition2),expression1,expression2). This results in expression1 if either condition1 or condition2 is true (or if theyre both true). Otherwise, it results in expression2. Again, more than two conditions could be included in the OR. Try it! Use an IF function with an OR condition to fill in the bonuses in column F. (Scroll to the right to see the correct answer.) EMBED Excel.Sheet.8 Using lookup functions Lookup tables are useful when you want to compare a particular value to a set of values, and depending on where your value falls, assign a given answer. For example, you might have a tax table that shows, for any gross adjusted income, what the corresponding tax is. There are two versions of lookup tables, vertical (VLOOKUP) and horizontal (HLOOKUP). Since they are virtually identical except that vertical goes down whereas horizontal goes across, well only discuss the VLOOKUP function. The VLOOKUP function takes three arguments: (1) the value to be compared, (2) a table of lookup values, with the values to be compared against always in the leftmost column, and (3) the column number of the lookup table where you find the answer. Since the VLOOKUP function is often copied down a column, it is usually necessary to make the second argument an absolute reference, and this is accomplished most easily by giving the lookup table a range name such as LookupTable. (Range names are always treated as absolute references.) The only requirement of a lookup table is that the values in the first column (the comparison column) must be sorted in ascending order. Lets say you want to assign letter grades to students based on a straight scale: below 60, an F: at least 60 but below 70, a D; at least 70 but below 80, a C; at least 80 but below 90, a B; and 90 or above, an A. The spreadsheet sample below shows how you would set this up. The comparison column in the lookup table starts at 0 (the lowest grade possible), then records the cutoff scores 60 through 90. The lookup table in the range E2:F6 is range-named LookupTable. The typical formula in cell C2 (which is copied down column C) is =VLOOKUP(B2,LookupTable,2). This compares the value in B2 (67) to the values in column E and chooses the largest value less than or equal to it. This is 60. Then since the last argument in the VLOOKUP function is 2, the score reported in C2 comes from the second column of the lookup table next to 60, namely, D. EMBED Excel.Sheet.8 To use a VLOOKUP function: Create a lookup table with at least two columns, where the values in the first column are in ascending order, and (for best results) give the table range a range name. Then enter the formula =VLOOKUP(value,lookup table,column #), as described above. Try it! Enter a lookup table in columns E and F, and VLOOKUP functions in column C. Assume there is a quantity discount policy in force: for orders less than 300 units, the unit price is $3; for orders of at least 300 units but less than 400, the unit price is $2.50; for orders of 400 units or more, the unit price is $2. (Scroll to the right to see the correct answer.) EMBED Excel.Sheet.8 Using data tables Data tables, also called what-if tables, allow you to see very quickly how one or more outputs change as one or two key inputs change. There are two types of data tables: one-way tables and two-way tables. A one-way table has one input and any number of outputs. A two-way table has two inputs but only one output. Well demonstrate both types. To illustrate, suppose Mr. Jones buys a new car for $20,000, makes a $5,000 down payment, and finances the remaining amount over the next 36 months at an 8.5% annual interest rate. There are at least two outputs that might be of interest: the monthly payment and the total interest paid. These are affected by at least two inputs: the amount of the down payment and the annual interest rate. Lets first look at a simple one-way data table, where we see how a single output, monthly payment, varies as the annual interest rate varies. This is shown in the following spreadsheet. EMBED Excel.Sheet.8 To create the above table (which we already did): Enter the formula for the output in cell E3. (Since the monthly payment was calculated with the PMT function in cell B7, simply enter =B7 in cell E3.) Starting in cell D4, enter any sequence of interest rates. Select the entire table, that is, the range D3:E8. Finally, use the Data/Table menu item and enter B4 as the column input cell. (There is no row input cell, so leave it blank.) What happens when you do this? Excel takes each interest rate in column D, substitutes it into the column input cell you designated (cell B4), recalculates the formula in cell E3 (the one we colored gray for emphasis) with this new interest rate, and records the answer in the data table. We use a column input cell because the possible inputs (interest rates) are listed in a column. We can also capture more than one output in a one-way data table. An example appears below, where the single input is still the interest rate, but there are two outputs: monthly payment and total interest paid. This table is formed exactly as before except that the table range is now D3:F8. EMBED Excel.Sheet.8 Try it! Create a one-way data table that shows the monthly payments and the total interest paid for each term (value in cell B5) from 12 to 48 in increments of 12. (Scroll to the right for the correct answer.) EMBED Excel.Sheet.8 Two-way tables allow you to vary two inputs, one along a row and one along a column, and capture a single output in the body of the table. The following spreadsheet illustrates this, where we vary the annual interest rate and the amount of the down payment. The single output is the monthly payment. EMBED Excel.Sheet.8 To create the above table (which we already did): Enter the formula (=B7) for the single output in the upper left corner (cell D2) of the data table. (Again, we colored this cell gray for emphasis.) Enter any sequence of down payments to the right of this and any sequence of interest rates below this. Finally, select the entire data table range, D2:G7, use the Data/Table menu item, enter B2 as the row input cell, and enter B4 as the column input cell. Note that B2 is the row input cell because various down payments are entered in a row (E2:G2). Similarly, B4 is the column input cell because interest rates are entered in a column. Excel substitutes each down payment into cell B2, each interest rate into cell B4, calculates the formula in cell D2, and records the answer (monthly payment) in the body of the table. Try it! Create a two-way data table that shows the total interest paid for each term from 12 to 48 in increments of 12, and each down payment from $3000 to $5000 in increments of $1000. Put down payments along the side, terms along the top. (Scroll to the right for the correct answer.) EMBED Excel.Sheet.8 *Recording simple macros into Personal.xls Macros are sets of instructions (programs) that automate various tasks in Excel. Microsoft has developed a programming language, Visual Basic for Applications, or VBA, that can be used to develop macros in Excel and other Microsoft Office applications. It takes some time to learn this language, but you dont need to learn it to record simple macros and then use them. This can be very handy for automating tasks that you do frequently. In fact, once youve recorded a useful macro, you can even assign it to a button that you can place in a toolbar. Then every time you want to perform the task (run the macro), all you have to do is click on the button. This section will illustrate the procedure. Heres a neat example. Suppose there are many times youd like to place a blue border around a range. Wouldnt it be nice to simply select the range (or ranges), click on a button, and have the blue border(s) appear? The procedure, which only ever has to be done once on a given PC, is as follows: Select any range. Turn on the macro recorder (with the Tools/Record Macro/Record New Macro menu item). Give the macro a suggestive name, such as BlueBorder, in the Macro Name box, and then click on the Options button to obtain a dialog box. Under the Store In section, click on Personal Macro Workbook and then click on OK. This stores your macro in a file called Personal.xls, which is stored in your XLStart directory so that it always opens when you open Excel. (It is usually stored as a hidden file, so that you dont actually see it. But its there, and all of the macros in it are available to you at any time.) Note: You probably will not be allowed to do this in your school's lab. But it should work fine on your own PC. The recorder is now running, so anything you do is being recordedso be careful. Go through the procedure of putting a blue border around the range you selected. (To do this, use the Format/Cells menu item, click on the Borders tab, and make the obvious selections to get a blue outline border.) Once youve got the blue border, click on the black square stop button thats floating somewhere on the screen. This turns off the recorder. To check whether the macro is working correctly, select any range and run the macro. To run it, use the Tools/Macro menu item, click on the macro name you just recorded, and click on the Run button. You should get a blue border around the selection. (Actually, try running it with more than one range selected. You should get a blue border around each selected range. This makes the macro even more useful!) Try it! Record a macro called BlueBorder and then test it out. Note: In step 4 above, choose the This Workbook option instead of the Personal Macro Workbook option. It will work better for this demo. EMBED Excel.Sheet.8 Try it again! A common task is to copy a range of formulas onto itself, but to replace the formulas with values. (Remember the Paste Special/Values option?) Record a macro called Special that does this, using the formulas in column C when you do the recording. Then try out your macro with the formulas in column D. (Again, choose the This Workbook option instead of the Personal Macro Workbook option for this demo.) EMBED Excel.Sheet.8 *Customizing toolbars Excel provides several toolbars. Two of these, the Standard and Formatting toolbars, appear by default when you open Excel. Each of the buttons on these toolbars has a macro assigned to it, so that when you click on the button, some useful task is carried out. You might not know, however, that there are several other toolbars you can make visible at any time. In addition, there are a number of preprogrammed buttons that you can add to any of the toolbars, and you can delete any of the standard buttons you never use. You can even form your own toolbars and customized buttons (that run your own macros), and its all quite easy. This section will explain how. To see a list of toolbars and show or hide any of them: Put the cursor over any toolbar and right click. Youll see a list of toolbars. Click on any to place checks next to those you want to show or remove checks next to those you want to hide. To add preprogrammed buttons to any of the built-in toolbars (or delete any buttons): Put the cursor over any toolbar and right click. Choose the Customize option at the bottom and then click on the Commands tab in the resulting dialog box. Youll see a list of categories and buttons. Click on any category and then click on any button. Youll see a short description of what this button does at the bottom of the dialog box. If youd like to have this button on a toolbar, simply drag it to the toolbar. Similarly, if there is any button on a toolbar that you never use, simply drag it off the toolbar to delete it. To add your own button (with your own macro) to a toolbar: Lets say youve recorded the macro BlueBorder (as above) and you now want to attach it to a button that youll place on a toolbar. Put the cursor over any toolbar, right click, choose the Customize option, and click on the Commands tab. Scroll down the list of categories until you get to the Macros category, and click on it. Youll see a generic "happy face" button that doesn't have any preprogrammed macro attached to it. This button for your use! Click on it and drag it up to a toolbar. Now right click on your new button (with the Customize dialog box still open) to see a menu. Click on Assign Macro, and then select BlueBorder from the list of macros shown. This assigns your macro to the button. At this point you probably want a more suggestive picture (icon) on your new button. You have two options. The first is to right click on the button (with the Customize dialog box still open) and select the Edit Button Image menu item. This takes you to a paint program where you can paint the image you want (such as a blue rectangular border). Alternatively, you can borrow an image and then modify it. To do this, right click on a button whose image you want to borrow and select the Copy Button Image menu item. Then right click on your new button and select the Paste Button Image menu item. Finally, right click again on your new button, select the Edit Button Image menu item, and modify the image as you like. (Note: If youd like to mimic the image of a button that shows in the Customize dialog box but isnt yet on a toolbar, youll need to drag this to a toolbar first. You can always drag it off after youve copied its image.) Finally, right click on the button and type Blue Outline Border next to the Name: menu item. This creates a "tool tip" for your button. From then on, when you put your cursor over the button, you'll see this tool tip. To create a new toolbar (that will probably contain your customized buttons): Put the cursor over any toolbar, right click, choose Customize, click on the Toolbars tab, and click on the New button. This allows you to create a new toolbar with a name you can choose. From that point your new toolbar is just like any of the ones that came with Excel. You can show it or hide it, and you can add buttons to it. In fact, it starts out empty, so you will have to add buttons to it to make it useful. If you mess up, or if you don't need your new toolbar any longer, just go to Customize and the Toolbars tab, select your toolbar, and click on Delete. *Setting the default number of sheets in a new workbook Excels default number of worksheets in a workbook is 3. (Who knows why!) Usually, you need only 1, and the extra blank sheets just take up wasted memory on your hard drive when you save the file. To change the default number of sheets in a new workbook: Use Tools/Options, click on the General tab, and change the Sheets in New Workbook setting to a smaller number, probably 1. *7 ! y } 69w GH !45679<Apq  ־֮־֞։~~։hT B6B*]phhT BB*phjhT BB*Uphjfq; hT BB*UVphjgq; hT BB*UVphjhT BB*UphhT B6B*]phhT BB*ph *hT B hT B6]hT B hT B5\hT B5CJ \aJ 1*7 D Qw H 89q $a$QQU <o$a$$a$PU  »¶®®›¶®®{k^{j"hT BB*Uphjcq; hT BB*UVphjhT BB*Uphj hT BUjdq; hT BUVjhT BUhT B6B*]phhT BB*ph *hT B hT B6]hT B hT B5\jhT BB*Uphjeq; hT BB*UVphjhT BB*UphhT BB*ph$<!!!i""####/#0#1#2#4#\#]#8$9$:$;$N$O$P$Q$R$S$$$$ԷԚ}pj#hT BB*Uphj_q; hT BB*UVphjhT BB*Uphj`q; hT BB*UVphjlhT BB*Uphjbq; hT BB*UVphjhT BB*UphhT BB*phhT B6B*]ph *hT BhT B hT B5\hT BB*ph,o!!i""##3#4#]##9$:$R$S$$R%%u&&&&''($a$$2%6%R%%%&&&&&&&&&'&('((()(<(=(>(?(A(^(_()))))))))))4*5*?,,,,,}ݺpjhT BB*Uphjm3hT BB*Uphj\q; hT BB*UVphjhT BB*Uphj.hT BUj]q; hT BUVhT BB*phj(hT BUj^q; hT BUVjhT BUhT B6B*]phhT BB*ph *hT B hT B6]hT B,'(((@(A(_(<))))))5*A,,,,,,.2.B/}/~///00181$a$,,,,,,,.1.2.|/}/~//////00001718112g3h3i3j3}3~33333w5{5666½µ½µ}pii hT B6]jBhT BB*UphjYq; hT BB*UVphj=hT BB*UphjZq; hT BB*UVphhT B6B*]phhT BB*ph *hT BhT B hT B5\jhT BB*Uphjx8hT BB*Uphj[q; hT BB*UVphhT BB*ph)8112h3i33336'7q7]8888899999::p;2<q<r<<<$a$6&7'7q7[888888888899999999995:8::::p;0<p<q<r<s<<<<<<澱桔vijzShT BB*UphjUq; hT BB*UVph hT B6] hT B5\jMhT BB*UphjVq; hT BB*UVphjGhT BB*UphjWq; hT BB*UVphjhT BB*UphhT B6B*]phhT BB*phhT BB*phhT B *hT B'<<q====d>>>>>>_??@KAAAAAAAD{DEKFFFFF$a$<<p=q=r=s========>>>>>>>>>>_???@IAAAAAAAAAAABBADzD{D൭䞑tlhT BOJQJjXdhT BB*UphjRq; hT BB*UVphjhT BB*UphhT BB*ph hT B5\j^hT BUjSq; hT BUV *hT BjXhT BUjTq; hT BUVjhT BUhT BhT B6B*]phhT BB*phhT BB*ph*{DDDEEJFFFFFFFFFFFGGGHIIIIIIIIIIJ J$K%K&K'K:K;KK?K6LbL4MM-N.NFNGNEOrO(PrPsP$a$=K?K6LaLbLLL4MMM,N-N.N/NBNCNDNENNNEOqOrOqPrPsPtPPPPPPPPQQQQQQQQQUۜ|thT BB*phjąhT BUjKq; hT BUVjhT BB*UphjLq; hT BB*UVphjhT BB*Uph hT B6]j6zhT BUjMq; hT BUVjhT BUhT BB*phhT B6B*]ph *hT BhT BhT BB*ph+sPPPPhQQQQQfTU,V-VEVHVYVWWcXRZZZZZZM[F\\\$a$UUU+V,V-V.VAVBVCVDVHVYVWWWWWXX!X&XcXYYPZZZZZZZZZZZZZZZ[M[ºճլէ䟔ٟwjjhT BB*UphjIq; hT BB*UVphjhT BB*UphhT B6B*]phhT BB*ph *hT B hT B6] hT B5\j-hT BUjJq; hT BUVjhT BUhT BhT B6B*]phhT BB*phhT BB*phhT B6B*]ph)M[D\\\\\\\\\\]]+]0]8]=]n]w]]%__________```"`,`1`9`>`&a'a(a)aa?aAa[a\a]ayabbb@cAcBcReSeTeUeheiejekemeeefff%f&f1f2f=fFfOfffffg gghhhh׾ޮޮޑ׾ޮޮޮޮޮޮ޾|ޮtjhT BUhT BB*phjfhT BB*UphjDq; hT BB*UVphhT B6B*H*]phhT B6B*]ph *hT BhT BhT B56H*\]hT B56\] hT B5\hT BB*phjhT BB*UphjhT BB*Uph-ghh5h6h i&i:jEkkkkk]llCmmnnnnnooppppp$a$h1h2h3h4h i%i&iq; hT BUV hT B6] hT B5\jhT BUj?q; hT BUVhT BB*ph *hT BjhT BUj@q; hT BUVjhT BUhT BhT B6B*]phhT BB*ph7prt!wxxxxxyG{H{`{a{s{|Z~/0bm$a$yyyyF{G{H{I{\{]{^{_{a{s{~~+,-.0abm~贬쟔艁vnj$hT BUj9q; hT BUVjhT BUj:q; hT BUVhT B6B*]phhT BB*ph *hT BjYhT BUj?@ATUVWYЋ֋txyz{89:;NĹĹ̮Ĕ̮̮jhT BUj6q; hT BUV hT B5\jhT BUj7q; hT BUVhT B6B*]phhT B6B*]phhT BB*phhT BB*ph *hT Bj%hT BUj8q; hT BUV hT B6]hT BjhT BU/Džȅ?@XYGtێeVyz9 & F $a$9:RSi BWqw֡\ѧԨPQ$a$NOPQSi ABWpqw[\ЧѧӨԨPQ̽ٳhT B56\] hT B6]hT BB*phhT BB*ph *hT B hT B5\hT BjhT BUjFhT BUj5q; hT BUV P/ =!"#$%Dd  J  C A? "2P>1CfoR,D&`!$>1CfoRȈD ^xڵJPsnRNAU Xl! r}GpܩGr0nLIz~77)B{6 ̶*K<_|i*C= jGj͌ڱ3|sʺ[z?͹{<®F~xy 'a-#ǣpԚ^[wëɴ5J<\ӆ>}9hwll*=n}b ՠRdڿ[+s>t{eEŽo(f0C?S\r?(g;ӖTWVm1.%elr@I=K E2ŚSJRw.T(T"dMEjJIUUU2(ô6C3(ô6Cx b*#*߯&LQLIEfC#S=R=QjTL*UԌLT3梚3 բ/{^-ߏMSu uDd OA >  # A"2mmzo'TI >2&`!mmzo'TI >X@BAnxڕAhGǿyN4IS0|JFSc) ћA--HCP<%^ }C^Ƀ Fz͊]fv{>q騪XZּ;_ܑ{fs6qD_蕍^/%cttNLLI;55em۵GgϞKKKv~~Zg@O=>yu$ġģ$4!ߘ3Ϙ?c*H<P<P<P<Ш)x ő#G.\ġģ$ h!h+033'/5j \9 󣃂(F s A!0PXp.J[<:8@A:8@A\A܎=q_/˔CqJ9P 5EcN9h}E=x]wr^p.//k׮7nMC#cS3s/oy{CˆA8щ@d&kTcx-)eHe ƶHɔUg=V}ԘrtԊU^T<'XkR{=S=y-^S[;Zu(i%oh1>Wؗ+4)iw[I1îCuuIVLõ\ \rkuk.&Vņk%VZ]+ Zr[uuHVFed.=s0u3p6ZSވܕӦPn^{dP/{[;s''q7b<`t|ǟgŸ}o=ڷa)vye;WUS,הeP8*J$x,]<޾4jiU|_5жϗf*JlR.5wDEjqv\.㜪(8\nzxEٮ2lZ. R+; zƇ蟢}Dd O >  # A"2DžgR)L/&`!DžgR)L/t@BAxڝOHGXКb-C@g]MOB Xh.'Rh"z ΩR*I˥:gTx@"M޺ǝ|; j#j* H$FR< _(lф+)!a}W5TZFko$immSvww˞Y,eSSSr||\eW%_$3icWѶm!940"P@40@ `{ !~GIA h`RЁ4t0 (l540B. (䢐B. @ h`RЁ@P@4014a &c 845҈qd)h@y8G*0 8>t:[q43  A0 @)td401t[aOċ"F80 :bk `IC h`2ЁVchq4l}=:;tNJ"ڒrggGʽ=cypp %?ۧoWc_ 89I;E`[p|`tS~;QIhvo趫8y!Vs+QcBǣ]_puΞ:Gh{.u6еڥ ud~ _~_ϩDS'WIM9ws]Ō+(e\5ȸk:5q)R.qUd\޵Zθw\θֽk=׵q ױc!#WջjUZqOsWk,5qUf\5+)?dד~WoнOJ;gUP(^haq:6e+8>e jqy#;qdRJkC6 VBm.ymG$B4z*#}RRC4jIPs5D#P!Xo2Q$QIQ0+a2"RCu\bwZct g*j.ƅRzn1X%ߨPs1»v+#$1\Vz+IrЈSZa4"}_pD6<霵 iowv=cf:׋-B)P8>{­MeyLKe}..Yl'x-ޅ+0ޅg{߽:І%q&x,ō]Go^k񵤻oE=GW z_4v7Wt;p|Iҏ!DG  # A"2|LǗȣI{l (_Q&`!W|LǗȣI{l (x @BA%xڝ  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstvwxyz{|Root Entry Fpw]QData uWordDocument"ObjectPoolPq]Qpw]Q_998994279 FPq]Q@x]QOle PIC LMETA     !"#$%&'()*+,-./012345689:;<=?BCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghiklmopqruwxyz{|}~Lh.O  h. l     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial---'-- -   !E !E !E !E !E? !EA :2 E"Down in the midst of the worksheet    --4 '0U :  PRINT 7CompObj>fObjInfo @WorkbookA.  ''  '  '  Arialn- :2 "Down in the midst of the worksheet   $     ' FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q A@\pChris Albright Ba=4"=-- <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  8 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`Sheet1`iZ*Great - you're back in a familiar location"Down in the midst of the worksheet  A@  dMbP?_*+%&A Page &PMODT2 on SOB_NCR:d,,ODT2 on SOB_NCR\\SOB-NW1\ODT2 ,,"d,,??U  D>@7 Oh+'08@Xp Chris AllbrightChris AlbrightMicrosoft Excel@i3Q՜.+,0 PXt | SummaryInformation( jDocumentSummaryInformation8n_998994278 F@x]Q0,{]QOle s9Indiana Universityh Sheet1  Worksheets)F! _910622874Lh.OA  =B= = <X@"1PIC tLBook vMETA TPRINT Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   @  [Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U  bb P%bPPP Pb  @???@@@@$@@@$@$@$@@"@@@@@@@@?@ @"@$@"""""">  h. &     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-##- !#-55- !5-FF- !F-WW- !W-hh- !h-yy- !y-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-  !@" !@4 !" !$ !@ !"? !$ !@ ! ! !? ! !@"A !@4A !@A !@A-'- Arial--"Systemn-'-- Arial-  2 $8 2 $1 2 $71 2 $w1 2 65 2 65 2 677 2 6w6 2 G10 2 G5 2 G73 2 Gp10 2 X10 2 X10 2 X75 2 Xw9 2 i5 2 i4 2 i73 2 iw4 2 z7 2 z4 2 z75 2 zw1 2 2 2 8 2 79 2 p10--4 '    !"#$%&'()*+,-./012356789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdfijlmnqstuvwxyz{|}~0 P    """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' ' !-  !i ! ! ! !i  !  !  ! -'- Arial--"Systemn-'-- Arial---'-- o  2 nY8 2 n+1 2 n1 2 n1--'--   2 Y5 2 +5 2 7 2 6 2 B10 2 +5 2 3 2 10 2 B10 2 10 2 5 2 9 2 BY5 2 B+4 2 B3 2 B4--'-- v  2 uY7 2 u+4 2 u5 2 u1--'-- --'--   2 Y2 2 +8 2 9 2 10--'-- !  !?i !?it !?i !?i--'-- --'-- !  !? !?t !? !?--4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightCompObjfObjInfoSummaryInformation(DocumentSummaryInformation8 Chris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910629011Lh.O  _998994277 F0,{]Q0,{]QOle  9PIC LBook  =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U  bbbGbbbbO$@S@R@J@@W@(@$"@C@@@R@C@$>@?@B@X@$@$F@A@@X@@@$A@7@&@E@J@$T@F@:@P@1@$@@*@K@?@J@$P@K@X@@U@(((((((]j <@LScreen splitter barsq]*@@]* @>  0U        """)))UUUMMMBBB999|PP3f333f3333f3fffMETA pPRINT4 CompObj efObjInfogh. 4     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 p77 2 74 2 52 2 093 2 p12 2 #w9 2 #38 2 #4 2 #073 2 #p38 2 4p30 2 431 2 437 2 4098 2 4p10 2 Ep45 2 E35 2 E3 2 E098 2 Ep33 2 Vp34 2 V23 2 V11 2 V043 2 Vp52 2 gp80 2 g45 2 g26 2 g064 2 gp17 2 xp33 2 x13 2 x55 2 x031 2 xp53 2 p64 2 55 2 99 2 75 2 p87-- "- -  !G !}Z-  ZEYF %2 F Screen splitter bars ---'-- -  - >k  $ eq $-- -4 'fff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial!-  2 8p77 2 8B74 2 852 2 893 2 812 2 l9 2 lB38 2 l+4 2 l73 2 l38 2 p30 2 B31 2 37 2 98 2 10 2 p45 2 B35 2 +3 2 98 2 33 2 p34 2 B23 2 11 2 43 2 52 2 <p80 2 <B45 2 <26 2 <64 2 <17 2 pp33 2 pB13 2 p55 2 p31 2 p53 2 p64 2 B55 2 99 2 5 2 87-'- -'-  - "--  !A  !- %2 Screen splitter bars    "---'---  -  $c 47 $w---4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qSummaryInformation(!hDocumentSummaryInformation8k_9989942766& F0,{]Q0,{]QOle o9Oh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910629482PIC #%pLBook r=META $(t PRINTLh.O  =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U ֳ7Wb"@@$@?@ @ @?$@@@@@??@$@@ d>  h. 6     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 w9 2 2 2 10 2 #w1 2 #3 2 #8 2 4w8 2 41 2 410 2 Ew7 2 E5 2 E4 2 Vw5 2 V1 2 V1 2 gw5 2 g10 2 g7--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-  2 89 2 8Y2 2 810 2 l1 2 lY3 2 l+8 2 8 2 Y1 2 10 2 7 2 Y5 2 +4 2 5 2 Y1 2 +1 2 <5 2 <B10 2 <+7-'- -4'gD FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AllbrightMicrosoft Excel՜.+,08CompObj'*fObjInfoSummaryInformation()+DocumentSummaryInformation8@ \d l Indiana University Sheet1  Worksheets)F! _910629588Lh.O  h.     _9989942750 F0,{]Q0,{]QOle 9PIC -/LBook  =B=0 =X;8X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U dn7WbEPEP @    EPbb @@B@*@"@*@@"@"@@"@@ @@B@@&@(@@&@@@@@ ?@B?@"@&@(@?@&@"@ @ @@B"@*@?@(@@*@?@@ @@ @@ @@ @@   @@   ?@   @?   @ @   @@  @@ @@ @@@@@@?@@@@@@@?@@ @@@ @ @@@@@@@@ @@@ @?Dlffff66666666666!n7"W#$b%&'EP(EP)@*+,-./01234567EPb89b:;<=>?@!@@"@@#?@$@ @%@@& @@'@@(@@)@@*@@+@@,@@- @@.?@/@?0?@1 @@2@@3??4@?5@@6@@7?@8@@9@@:?@;@@<@@=@?>@??@ @@@@D@lAn7BWCDbEFGEPHEPI@JKLMNOPQRSTUVWEPbXYbZ[\]^_`A@@B@@C@@D@@E@@F@@G @@H?@I@@J@@K@@L@ @M@@N@@O@@P@@Q?@R@@S@@T @@U@@V@@W @@X??Y@@Z@@[@?\@@]@@^@?_ @?`@ @D@lan7bWca@@b@@c@? ~(>  META .2L PRINT$CompObj14GfObjInfoI      !"#%&'()*+,-./0123456789:;<=>?@ABCDEFHKLNOPSUVWXYZ[\]^_`abcdefghijklmnopqrtuvwxyz{|}~ """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 w6 2 3 2 77 2 p13 2 9 2 #w7 2 #2 2 #75 2 #w6 2 #11 2 4w1 2 43 2 471 2 4w2 2 49 2 Ew6 2 E4 2 E79 2 Ep13 2 E1 2 Vw4 2 V4 2 gw2 2 g7 2 xw2 2 x4 2 w2 2 2 2 w8 2 6--4 '0U Z     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-  2 86 2 8Y3 2 87 2 813 2 89 2 l7 2 lY2 2 l5 2 l6 2 l11 2 1 2 Y3 2 1 2 2 2 9 2 6 2 Y4 2 9 2 13 2 1 2 4 2 Y4 2 <2 2 <Y7 2 p2 2 pY4 2 2 2 Y2 2 8 2 Y6-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  WSummaryInformation(35JDocumentSummaryInformation8M_998994274@,: F0,{]Q0,{]QOle Q9orksheets)F! _910629985Lh.O  =B= =\ <X@"11Arial11Arial11Arial11Arial11Arial"$"#,##0_);PIC 79RLBook TMETA 8<s PRINT\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U  bb&WWb$@*@@"@?"@(@@@@?? @(@ .@@*@@$@d666&&>  h. C     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 p10 2 13 2 77 2 w9 2 #w1 2 #9 2 #012 2 #w7 2 4w5 2 44 2 471 2 4w1 2 E76 2 Ep12 2 V015 2 Vw2 2 13 2 4 2 010--4 '0U         * 3!"#$%&'()+,-2./014AH56789:;<=>?@BCDSEFGI[JKLMNOPQRTUVZWXY\fn]^_`abcdeghiyjklmopqrstuvwxz{|}~ """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-  2 8p10 2 8B13 2 87 2 89 2 l1 2 lY9 2 l12 2 l7 2 5 2 Y4 2 1 2 1 2 6 2 12 2 15 2 2 2 B13 2 +4 2 10-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qCompObj;>fObjInfoSummaryInformation(=?DocumentSummaryInformation8Oh+'008PhChris AllbrightChris AllbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets_998994272D F0,{]Q0,{]QOle 9PIC ACLBook )F! _910630129Lh.O  =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&Wb@@"@ DD@?@@@?@?@@@@x9 >  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3META BF8 PRINT#CompObjEHBfObjInfoD      !"$%&'()*+,-./0123456789:;<=>?@ACFGIJKNPQRSTUVWXYZ[\]^_`abcdefghijklmopqrstuvwxyz{|}~ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 73 2 w3 2 9 2 #74 2 #w1 2 472 2 4w3 2 E72 2 Ew1 2 V75 2 Vw1 2 g74 2 gw2 2 x73 2 xw5--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-  2 83 2 83 2 8Y9 2 l4 2 l1 2 2 2 3 2 2 2 1 2 5 2 1 2 <4 2 <2 2 p3 2 p5-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft ExcelSummaryInformation(GIEDocumentSummaryInformation8H_998994271r"N F0,{]Q0}]QOle L9՜.+,08@ \d l Indiana Universityf Sheet1  Worksheets)F! _910630158Lh.O  =B= PIC KMMLBook OMETA LPn8 PRINT=\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&Wb?@@ DD@?@@?@@@@@?@x9 >  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 71 2 w3 2 3 2 #74 2 #w1 2 475 2 4w5 2 E71 2 Ew4 2 V73 2 Vw3 2 g73 2 gw5 2 x71 2 xw5--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial!-"Systemn-'-  Arial-  2 81 2 83 2 8Y3 2 l4 2 l1 2 5 2 5 2 1 2 4 2 3 2 3 2 <3 2 <5 2 p1 2 p5-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qCompObjORfObjInfoSummaryInformation(QSDocumentSummaryInformation8Oh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets_998994270X F0}]Q0}]QOle 9PIC UWLBook )F! _910630186Lh.O  =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWb@@"@?@"@@@@@ @@@"@&x]piP,@TFormula should multiply the value in column A by the corresponding value in column BK/T>  h. X     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ffMETA VZPRINT&h CompObjY\PfObjInfoR      !"#$%'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOQTUWXY\^_`abcdefghijklmnopqrstuvwxyz{|~333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 76 2 w2 2 #79 2 #w1 2 474 2 4w9 2 E77 2 Ew6 2 V72 2 Vw3 2 g78 2 gw5 2 x73 2 xw9-- "- -  !G+ !p -  p)o*  +2 * Formula should multiply   -2 ; the value in column A by   02 L the corresponding value in 2 ] column B  ---'-- -  - - -4 '0U 0      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial!-  2 86 2 82 2 l9 2 l1 2 4 2 9 2 7 2 6 2 2 2 3 2 <8 2 <5 2 p3 2 p9-'- -'-  - "--  !i !Wi-WiaT`i+2 iFormula should multiply $    $   -2 ithe value in column A by      $   02 ithe corresponding value in       2 icolumn B $  "---'---  ---4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana SummaryInformation([]SDocumentSummaryInformation8V_998994269hTb F0}]Q0}]QOle ZUniversity Sheet1  WorksheetsLh.O#  =B= =z <X@"1Arial1Arial1Arial1PIC _a[LBook ]META `d}l PRINTPArial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   @   @   @   Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb bGbbbbo         >  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-##- !#-44- !4-EE- !E-VV- !V-gg- !g-xx- !x-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-  !z? !x !A !A-'- Arial--"Systemn-'-- Arial---4 '0     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' ' -  !v5 !v-'- Arial!--"Systemn-'-- Arial---'--   !w5 !w5F--4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightfMicrosoft Excel՜.+,08CompObjcffObjInfoSummaryInformation(egDocumentSummaryInformation8@ \d l Indiana University Sheet1  Worksheets)F! _910630209Lh.O  =B= =\ <X@"1_998994268l F0}]Q0}]QOle 9PIC ikLBook Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWb$@@Q@ DD@"@@"@@?@ @ @$@$@@x9 >  h.      """)))UUUMMMBBB999|PPMETA jn@ PRINT&CompObjmpEfObjInfoG      !"#$%'()*+,-./0123456789:;<=>?@ABCDFIJLMNQSTUVWXYZ[\]^_`abcdefghijklmnoprstuvwxyz{|}~3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 010 2 w7 2 70 2 #76 2 #w9 2 474 2 4w9 2 E75 2 Ew1 2 V72 2 Vw8 2 g78 2 gp10 2 x010 2 xw7--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-  2 810 2 87 2 8B70 2 l6 2 l9 2 4 2 9 2 5 2 1 2 2 2 8 2 <8 2 <p10 2 p10 2 p7-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qSummaryInformation(oqHDocumentSummaryInformation8K_998994267^v F0}]Q0}]QOle O9Oh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910630226PIC suPLBook RMETA txq< PRINTLh.O  =B= =\ <X@"1)Arial1)Arial1)Arial1)Arial1)Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWb@ @L@ DD@?$@@@?@@@ @@ @x9 >  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 77 2 w8 2 56 2 #72 2 #w1 2 4010 2 4w2 2 E74 2 Ew1 2 V74 2 Vw5 2 g73 2 gw8 2 x77 2 xw8--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-  2 87 2 88 2 8B56 2 l2 2 l1 2 10 2 2 2 4 2 1 2 4 2 5 2 <3 2 <8 2 p7 2 p8-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08CompObjwzfObjInfoSummaryInformation(y{DocumentSummaryInformation8@ \d l Indiana University Sheet1  Worksheets)F! _884684367Lh.O  =B= =\ <X@"1_998994266 F0}]Q0}]QOle 9PIC }LBook :dArial1dArial1dArial1dArial1dArial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet 4 in DSM Plus@w XX@MSUDNHP LaserJet 4 Plus;d "dXX??U bb&WW[b??? DD@@@ DD"@@F@ DD@@<@ DD @ @P@ DD @$@T@ DD@@E@ DDx999999>  h. T    META ~ PRINT" CompObjCfObjInfoE      !#$%&'()*+,-./0123456789:;<=>?@ABDGHJKLOQRSTUVWXYZ[\]^_`abcdefghijklmnoprstuvwxyz{|}~  """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 w1 2 1 2 1 2 #w2 2 #3 2 #6 2 4w9 2 45 2 445 2 Ew7 2 E4 2 E28 2 Vw8 2 V8 2 V64 2 gw8 2 g10 2 g80 2 xw7 2 x6 2 x42--4 '0(     J  """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' I ' [ ' I Arial-"Systemn-'- I Arial-  2 1. 2 1. 2 Z1. 2 2. 2 3. 2 Z6. 2 `9. 2 `5. 2 `,45.. 2 7. 2 4. 2 ,28.. 2 :8. 2 :8. 2 :,64.. 2 8. 2 10.. 2 ,80.. 2 7. 2 6. 2 ,42..-'- [ -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrighteSummaryInformation(FDocumentSummaryInformation8I_998994265| F0}]Q ]QOle M9Chris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910630265Lh.O  PIC NLBook P:META q PRINT  =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWb@@@ DD@@<@ DD@@2@ DD@"@;@ DD@@E@ DD@@B@ DD?@@ DDx999999>  h. S     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 72 2 w3 2 6 2 #77 2 #w4 2 #28 2 473 2 4w6 2 418 2 E73 2 Ew9 2 E27 2 V76 2 Vw7 2 V42 2 g76 2 gw6 2 g36 2 x71 2 xw4 2 x4--4 '0U       """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  ArialE-"Systemn-'-  Arial-  2 82 2 83 2 8Y6 2 l7 2 l4 2 lB28 2 3 2 6 2 B18 2 3 2 9 2 B27 2 6 2 7 2 B42 2 <6 2 <6 2 <B36 2 p1 2 p4 2 pY4-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qCompObjfObjInfoSummaryInformation(DocumentSummaryInformation8Oh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University! Sheet1  Worksheets)F! _910630284_998994263 F ]Q ]QOle 9PIC LBook l L;2z#  =B= =;z <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0                + ) , *  #    $ @ $  $  Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} m}  bb&WW  Fixed cost~ I@  Fixed cost~ I@  Variable cost~ @  Variable cost~ @  Month Jan Feb Mar Apr  Month Jan Feb Mar AprUnits producedl@@h@l@ p@ Units producedl@@h@l@ p@ Total cost   Total cost$ @DDD$`{@DDD$@DDD$@DDDPz> " ;2      """)))UUUMMMBBB999|PP3f333f3333f3fffMETA L PRINT2 CompObj]fObjInfo_      !"#$%&'()*+,-./013456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\^abdefiklmnopqrstuvwxyz{|}~fff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-gg- !g-yy- !y-- !-- !-- !-ee- !e-- !-- !-%%- !%-ee- !e-- !-- !-  !fd !hd !ff !xf-'- Arial--"Systemn-'-- Arial- 2  Fixed cost 2 $502 # Variable cost  2 #$22 EMonth  2 EJan 2 EFeb 2 E Mar  2 EOApr 2 VUnits produced  2 V224 2 V194 2 V228 2 VN2582 h Total cost--4 '4 C   < """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' ?' E-  !H9R !HpR-'- ?Arialj--"Systemn-'-- ?Arial- 2 8 Fixed cost   2 8$502 l Variable cost    2 l$22 Month#  2 Jan 2 Feb 2 tMar# 2 MApr--'-- ;; 2  Units produced   2 224 2 194 2 w228 2 I258--'-- ?--'-- r;? 2 > Total cost   --'-- ?--'-- E  !?9J !?9--4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qSummaryInformation(`DocumentSummaryInformation8c_998994262J F ]Q ]QOle g9Oh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910679617PIC hLBook j META 0PRINT Lh.O#  =B= =z <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0.00                + ) , *     $ @ $  $  $ @ $  $  $ @ $  $  !Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WW!bb @8Table of revenues for various unit prices and units sold"  Units sold   Units sold   I@Y@b@i@  I@Y@b@i@ Unit price~  @  Unit price~   @ Pd@ D@ D  Pt@ D@ D  x~@ D@ D P@ D@D ~  @ ~   @ e@ D@ D  u@ D@ D  h@ D@ D @ D@D ~ @ ~  @ pg@ D@ D  pw@ D@ D  @ D@ D p@ D@D ~ @ ~  @ i@ D@ D  y@ D@ D  @ D@ D @ D@D ~ @ ~  @ j@ D@ D  z@ D@ D  @ D@ D @ D@D jdf>  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-EE- !E-VV- !V-gg- !g-xx- !x-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-  !XD !VF !D !-'- Arial--"Systemn-'-- Arial--   !? !A ! ! ! ! ! ! [2 8Table of revenues for various unit prices and units sold2 # Units sold  2 450 2 4100 2 4)150 2 4i2002 F Unit price 2 F^$3.252 W^$3.502 h^$3.752 y^$4.002 ^$4.25--4 '0 c      !"#$%&'()*+,-./123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdfghijklmnopqrstuvwxyz{|}~  """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' ' -  !H !H-'- Arial!--"Systemn-'-- Arial- [2  8Table of revenues for various unit prices and units sold              2 l Units sold   --'--   2 B50 2 100 2 150 2 200--'--  2 Unit price  2 6$3.25 2 6$3.50 2 ?6$3.75 2 s6$4.00 --'--  2 6$4.25 --'-- --'--   ! !--4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightCompObjfObjInfoSummaryInformation(DocumentSummaryInformation8 Chris AlbrighteMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  WorksheetsLh.O  _998994261 F ]Q ]QOle  PIC LBook  =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0 "$"#,##0.0 "$"#,##0.00                + ) , *    #  Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WW Month Price Units soldRevenue Jan@Y@r@ DD Mar @I@Pd@ DD Jun @i@@ DD s<KHH>  META 0 PRINTexCompObjfObjInfoh.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-  2 Month 2 `Price 2  Units sold 2 Revenue  2 #Jan2 #^$3.00 2 #1002 #$300.00 2 4Mar 2 4^$3.25 2 4502 4$162.50 2 EJun2 E^$3.50 2 E2002 E$700.00--4 '0U 8     """)))UUUMMMBBB999|PP 3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial!- 2 8 Month# 2 8>Price 2 8 Units sold   2 8Revenue 2 l Jan2 l6$3.00  2 l+1002 l$300.00  2 Mar#2 6$3.25  2 B502 $162.50  2 Jun2 6$3.50  2 +2002 $700.00 -'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  WSummaryInformation(DocumentSummaryInformation8_998994260 F ]Q ]QOle 9orksheets)F! _910630335L2  =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);PIC LBook dMETA D PRINT\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0 "$"#,##0.0 "$"#,##0.000.0%                + ) , *  #   A   Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} m bb&WW Sales repAllison JonesTaylorCommission rateS㥫?~ @jt? SalesL@p@@ CommissionP@ DD`@ DD׆@ DD <KM-> " 2      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-ll- !l-- !-- !-,,- !,-ll- !l-- !-- !-'- Arial--"Systemn-'-- Arial-  2  Sales rep 2 Allison 2 Jones2 Taylor2 #Commission rate   2 #5.4% 2 #6.5% 2 # 4.3% 2 4Sales 2 4|$15,0002 4$12,0002 4$17,0002 E Commission   2 E$810 2 E$780 2 E$731--4 '5U V    S """)))UUUMMMBBB999|PP3f333f3333f3fff                   ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u w x y z { | } ~  fff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  R' \'  RArial-"Systemn-'-  RArial- 2 8 Sales rep  2 8Allison 2 8Jones2 8^Taylor 2 l Commission rate$$     2 l5.4% % 2 l6.5% % 2 lt4.3% %2 Sales 2 $15,000 2 k$12,000 2 =$17,000 2 Commission$$   2 $810 2 $780 2 w$731-'- \-4' FMicrosoft Excel WorksheetBiCompObj fObjInfo SummaryInformation( DocumentSummaryInformation8 ff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910630373L 2k  =B= =,\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);_998994259 F ]Q ]QOle  9PIC  LBook      &/ !"#$%')(*.+,-0<C123456789:;=>?P@ABDYEFGHIJKLMNOQRSXTUVWZfi[\]^_`abcdeghj{klmnopqrstuvwxyz|}~\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0.00                + ) , *  #    Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} I bb&WWb Product Code Units sold Unit price J645b@.@ K322`q@1@ L254x@9@ M332*@>@ R543n@@ S654s@A@xN00000> "  2    META ? PRINTv CompObj fObjInfo   """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-dd- !d-- !-- !-$$- !$-dd- !d-- !-- !-'- Arial!--"Systemn-'-- Arial-  2  Product Code  2 h Units sold 2  Unit price  2 #J645 2 #1482 #$15.00 2 4K322  2 42782 4$17.50 2 EL254 2 E3842 E$25.00 2 VM332  2 V132 V$30.50 2 gR543  2 g2472 g$22.40 2 xS654  2 x3152 x$35.00--4 '4U     9  """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  8' B'  8Arial-"Systemn-'-  8Arial- 2 8 Product Code 2 8^ Units sold   2 85 Unit price   2 l J645 2 l1482 lh$15.00  2 K322 2 2782 h$17.50  2 L254 2 3842 h$25.00  2  M332# 2 132 h$30.50  2 < R543 2 <2472 <h$22.40  2 p S654 2 p3152 ph$35.00 -'- B-4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightSummaryInformation( DocumentSummaryInformation8 _998994258 F ]Q X]QOle  9Chris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910630402Lh.O  PIC  LBook  ~ META  l PRINT  =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0                + ) , *  #    ~Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWbbP      D@@PPb@bbbb Day Sales Day Sales~ `l@ ~ d@~ c@ ~ Z@~ a@ ~ o@~  `@ ~ @\@~ Y@ ~ @g@~ ]@ ~ _@~ p@ ~ p@~ [@ ~ r@ ~ @j@ ~ q@ ~ @]@ ~ q@ ~ j@ ~ l@ ~ b@ ~ q@ ~ l@ ~  e@~  n@ ~ p@~ p@ ~  q@~ l@ ~ `@~ _@ ~ q@~ n@ ~ r@~ `i@ ~ o@~ i@ ~ \@~ g@ ~ f@~ p@ ~ 0p@~ r@ ~  g@~ e@ ~ @]@~  e@ ~ l@8J444444444444444*********>  h.                              ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 9 < = ? @ A D F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e g h i j k l m n o p q r s t u v w x y z { | } ~   """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial!-   2 'Day 2 ]Sales  2 Day 2 Sales  2 b$227 2 "$167 2 #b$157 2 #"$107 2 4b$143 2 4"$255 2 Eb$129 2 E"$113 2 Vb$102 2 V"$186 2 gb$116 2 g"$124 2 xb$269 2 x"$271 2 b$111 2 "$288 2 b$210 2 "$273--4 '0U i     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial!-  2 Day2 6Sales  2 Day2 Sales  2 8B$227 2 8$167 2 lB$157 2 l$107 2 B$143 2 $255 2 B$129 2 $113 2 B$102 2 $186 2 <B$116 2 <$124 2 pB$269 2 p$271 2 B$111 2 $288 2 B$210 2 $273-'- -4'CompObj8 fObjInfo: SummaryInformation(; DocumentSummaryInformation8>  FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910630425Lh.O#  =B= =z <X@"1Arial1Arial1Arial1_998994257 F X]Q X]QOle B 9PIC C LBook E Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   @   @   @   Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb &g! WWW!I@W@.@@B@@@D@*@T@=@V@@R@P@G@@@C@&@@T@4d"""">  h. }    META f  PRINT CompObj fObjInfo   """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-##- !#-44- !4-EE- !E-VV- !V-gg- !g-yy- !y-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-  !X"? !V$? !"A !xA-'- Arial--"Systemn-'-- Arial-  2 $p51 2 $94 2 $15 2 $77 2 5p37 2 56 2 52 2 5041 2 Fp13 2 F83 2 F29 2 F088 2 Wp73 2 W64 2 W46 2 W032 2 hp38 2 h11 2 h3 2 h080--4 '0     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' ' -  !Hi !Hp-'- Arial--"Systemn-'-- Arial-  2 op51 2 oB94 2 o15 2 o7 2 p37 2 Y6 2 +2 2 41 2 p13 2 B83 2 29 2 88 2 p73 2 B64 2 46 2 32--'-- r?  2 >p38 2 >B11 2 >+3 2 >80--'-- --'--   !i !i--4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft ExcelSummaryInformation( DocumentSummaryInformation8 _998994255 F X]Q X]QOle  9՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910689458Lh.O  =B= PIC  LBook  META  PRINT' T =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWb$Q@?@"@@Q@@$.@R@G@U@;@$,@H@9@C@T@$D@E@4@R@T@$<@R@>@W@R@$D@L@V@@V@@R@$<@@T@E@@T@N@x((((((>  h.                              ! " # $ % & ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L N Q R T U V Y [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y { | } ~   """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 p71 2 31 2 9 2 069 2 w5 2 #p15 2 #74 2 #46 2 #084 2 #p27 2 4p14 2 449 2 425 2 4038 2 4p83 2 Ep40 2 E43 2 E20 2 E075 2 Ep83 2 Vp28 2 V72 2 V30 2 V092 2 Vp75 2 gp41 2 g56 2 g90 2 g089 2 gp73 2 xp28 2 x81 2 x43 2 x081 2 xp61--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-  2 8p71 2 8B31 2 8+9 2 869 2 85 2 lp15 2 lB74 2 l46 2 l84 2 l27 2 p14 2 B49 2 25 2 38 2 83 2 p40 2 B43 2 20 2 75 2 83 2 p28 2 B72 2 30 2 92 2 75 2 <p41 2 <B56 2 <90 2 <89 2 <73 2 pp28 2 pB81 2 p43 2 p81 2 p61-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qCompObjM fObjInfoO SummaryInformation(P DocumentSummaryInformation8S Oh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910689491_998994254 F X]Q X]QOle W 9PIC X LBook Z Lh.O  =B=Sheet1'Data; =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWb$.@U@I@D@5@$O@2@$@?"@$,@J@0@2@@P@$@V@V@<@R@@$.@<@L@W@@$=@V@U@Y@T@$$@T@Y@@P@@x((((((>  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3META z PRINT T CompObj fObjInfo  ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 p15 2 86 2 50 2 041 2 p21 2 #p63 2 #18 2 #10 2 #71 2 #w9 2 4p14 2 452 2 416 2 4018 2 4p65 2 Ep89 2 E88 2 E28 2 E072 2 Ew7 2 Vp15 2 V28 2 V57 2 V092 2 Vw2 2 gp29 2 g90 2 g86 2 g)100 2 gp83 2 xp10 2 x82 2 x100 2 x065 2 xw4--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  ArialE-  2 8p15 2 8B86 2 850 2 841 2 821 2 lp63 2 lB18 2 l10 2 l1 2 l9 2 p14 2 B52 2 16 2 18 2 65 2 p89 2 B88 2 28 2 72 2 7 2 p15 2 B28 2 57 2 92 2 2 2 <p29 2 <B90 2 <86 2 <100 2 <83 2 pp10 2 pB82 2 p100 2 p65 2 p4-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana SummaryInformation( DocumentSummaryInformation8 _998994253: F X]Q X]QOle  University Sheet1  WorksheetsLh.O  =B= =\ <X@"1Arial1Arial1Arial1PIC  LBook  ? META  lPRINTD                           ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k m p q s t u x z { | } ~  Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0 "$"#,##0.0 "$"#,##0.00                + ) , *  #      Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U  bb&WWbb Month UnitsSold UnitPriceRevenue JanY@?@_@ DD Febb@?pg@ DD Mari@a@q@ DD Aprl@a@ t@ DD Mayi@?r@ DD Junr@? |@ DDNHHHHHH>  h. 2     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-  2 Month 2 F UnitsSold  2  UnitPrice  2 Revenue  2 #Jan 2 #i1002 #$1.252 #$125.00 2 4Feb 2 4i1502 4$1.252 4$187.50 2 EMar  2 Ei2002 E$1.402 E$280.00 2 VApr  2 Vi2302 V$1.402 V$322.00 2 gMay  2 gi2002 g$1.502 g$300.00 2 xJun 2 xi3002 x$1.502 x$450.00--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial- 2 8 Month# 2 8 UnitsSold  2 8 UnitPrice  2 8Revenue 2 l Jan 2 lY1002 l$1.25 2 l$125.00  2 Feb 2 Y1502 $1.25 2 $187.50  2 Mar# 2 Y2002 $1.40 2 $280.00  2  Apr 2 Y2302 $1.40 2 $322.00  2 < May# 2 <Y2002 <$1.50 2 <$300.00  2 p Jun 2 pY3002 p$1.50 2 p$450.00 -'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'00CompObjl fObjInfon SummaryInformation(o DocumentSummaryInformation8r 8PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910630284L;2z _998994252 F X]Q X]QOle v 9PIC w LBook y l =B= =;z <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0                + ) , *  #    $ @ $  $  Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} m}  bb&WW  Fixed cost~ I@  Fixed cost~ I@  Variable cost~ @  Variable cost~ @  Month Jan Feb Mar Apr  Month Jan Feb Mar AprUnits producedl@@h@l@ p@ Units producedl@@h@l@ p@ Total cost   Total cost$ @DDD$`{@DDD$@DDD$@DDDPz> " ;2      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ffMETA  d PRINT CompObj fObjInfo 333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-ee- !e-- !-- !-%%- !%-ee- !e-- !-- !-'- Arial--"Systemn-'-- Arial-  2  Fixed cost 2 $502 # Variable cost  2 #$22 EMonth  2 EJan 2 EFeb 2 E Mar  2 EOApr 2 VUnits produced  2 V224 2 V194 2 V228 2 VN2582 g Total cost 2 g$498 2 g$438 2 g$506 2 gG$566--4 '4U e    < """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' ?' E' ?Arial-"Systemn-'- ?Arial- 2 8 Fixed cost   2 8$502 l Variable cost    2 l$22 Month#  2 Jan 2 Feb 2 tMar# 2 MApr2  Units produced   2 224 2 194 2 w228 2 I2582 < Total cost   2 <$498 2 <$438 2 <`$506 2 <2$566-'- E-4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qSummaryInformation( DocumentSummaryInformation8 _998994251 F X]Q Ʉ]QOle  9                       ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q s t u v w x y z { | } ~  Oh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910630568?h%Uϼ5FTQg!)ܝDMC, EP cR.m+H4uҘ*BL ̻@t̝7'ȤȻc"S2QbI:ŕΎ>|BM=5xĂtP  `5Ԃ4r[ą}!_*50 b8{P 4E#5s E3p]SeM7fkk]sxxh9991gggSy q&^kh5j2 Dۉj=\tAl{8̚uCW)ݷZB]^t  # A"2EFIb pf&`!EFIb pP @BAZxڝ?h%Uϼ5FTQg!)H&kLCR$+VZDImcan4J, p̼yo22w~s~眹Iȸ#"2abXJZ֞:(kЉA5C!كЃxPK,X@e-,8 ,8 VC/AeO\ꥩAA:gZ:XpAA<:XpAht|sp_ͷrlnnNcΎ9<<4؜Ssvvf...g7ƙhxBˋޤXhQ r/z5Q |"NiӋmiN0U $)Vdē󌅻]v;ξY=IEy^#猽<{^յW$ohg|I|Iei{i랤~W;ڍv͕FWJkZmt\ѵڨltF:itujntm\.\\ѵڭYk;W,FWVsu\7*irT+]5W]Y+mt~%k4)oYzI~O>}GI_?~Qd_Ik/H'QJZQ,LGIH?V}yRT^)s/V"|E)r߫^GSQmB{ P竮j;Vf^(5Q*Y+s_̽PQs[W}|PyP_1WߜQ|ܖ7{Koqu/(Dd O >  # A"2DQJk=@z, r&`!jDQJk=@z, ɔ @BA8xڝ=h%Uϼ|aK(쳐 L.lXm, nAn L$lcan4J, py//s3wL""#LhG8Fa2adWs'W;{<afu$ Uy.o| 3==mfff쬙3nϛ^g666ښYYY1UfCs(_?1/^jRbRXt8txt9?%JQ,8 ,8 ,8 ,8AS4pAARK-Z,XjA <(E EFc7)oI}Ͽlp]Y\i_ _"Sc Uk?ZJt~D-=wa@I꘩Jk/T<+- (eE +ʃ*杘<_jꚖ/kzT\+O.Gt&䮔`r=<_cDd O >  # A"2fڨ4B-2B&`!:ڨ4B-2< @BAxڝ?hdU{&k]Ev,$"bȖ`]PaVxUH*`mcan4J, ps33/ys3Ȝ3"7e:i$UU1LjyO|2d[/֑$%y=)B 31\f~~z=`M7KKKf0 fVVV~}SW/ŋCOLFqxLLxPxPxPx0@`2gȟ?3 Ģġģ4h<(XjbRK-``qh`(8ryr*k88掺u1Ah`Cw8k<(G[GQt :=|s<57p\6Dd O >  # A"2f^!(kB#&`!:^!(k< @BAxڝ1hdEǿLrV`[ Iq.\8 ! {ų )tW`il,5f1U `a߼v/~fkdNd2iK#QUywL|2ٓfk/}y׃E!o|XY;??oݮ]XX٥%Ɔ][[+++V̭>x`k~W/ٳCmFq<Ll<P<P<P<8@<`2gȟ? ġģ$4j(8jqQG-CqChC !(xsr*kxx枺<=u1Qshb8(H@WGQt:|s5ĚgkC b蠌ţ$Di4jvB,Sj`)5sţ$4jFN=h\1/8~+w vkk؃o=99^\\X}~&O|8_k^h=vNl"F5ʞRY.0=,ucWwVG݋'+V^^fԌFk=U9U5vvVqvWrVǯS7o M{>ckw6^c3^WީVq7&]dDd O >   # A "2sXVՖ(O&O(&`!GXVՖ(O&@BAxڝOlTUϛ2- i4ƅDy 6nJԸ1)ԑŸ!,ILHJD.X6.a#+$19~}34߼{9yg }!-5 qTU #<[I+;3ֺ)!Fd?YGob/&@/kbx13>>n&&&̞={L5fvv;v̘)_?nW?bRbRXt8txt9g?%JQ,8 ,8 ,8 ,8AS4pAARK-Z,XjA <(E )V2ԕ;*?`ʧVV//-_<':ە\;?aFE3jS'Mq;޷￲ 3S[c?]_dlDd O# >   # A " 2RT 7\=WCf..&`!&T 7\=WCfp @BAh$xڕ1H%GǿYGO+r"X\'X A[I@" hBM# 6Wz{)RĩŁ$fevog~qX5΄TU,#kިΙɪ+ٮ<3Cު+zEoP&eYJ[)z*cttԎNc'&&vvzz.--E;??oggg~]X}w6_v68H.6(C(G(H@h!B19sɟ[ 5ED8jqQtp!8tp!x4p!t@A <95|bM=5AqĂstP  4ւ5r;}!_+50 9P 5E#4sE3x]kWVVښذ[[[vC{ttdɉ=;;V_ʣGy Z󡽁&N1V n5{Ǩ~zSz"unӏm6v_Uj=czQW݋'T+n];f Fǣ=T]95 vvD ?z_DxntĘˮjuM5\35ikյp-'rkZMVjõ\뭮k36[] vrmiu4\FukttU$W*2VWpIois Wr͵"VWpUJ룎ׅ+ɤ# ((e0&c:r-Kmd"SJ>"WIy*xe?O3 u߁zh.zѴ=ޑW~.Q:*ߎ^R Dd O >   # A " 2y% }U3&`!M% }D @BAxڝ?hG߮FبRAʱ)B)piE $!$!VB! ΅D NnRDSKMT0@$RDāov{Z-(Yng~~ݽDE'Dx*\0GIb&id&ݑJ_#IK^zR'b̌5sssf~~z=`Y[[3+++fii7̾|kjżxo~(΂ b  _LF3gFA2tXt8txtMK-Z,Xjb,8 ,8  ,8 xPE^C.ONe GQ#.5h lAgxm` A'Րs!P B |hAA,`m8txt(:X ܖ3q\ȗeJ Xtr;8txtM{ k>E{ṚY__7lll-gvww9<<4GGG؜3/Og|sE֓aXLC+[ITCx)uUvGLœ ]g8=t}3IU+EǓ+wvW}z}=OF9qCNh{UM]gMN.N<*Μ;jr~5JR4KE;)3EWk:]Y˵]Ֆ]NWe;]Dנ5h6kӵrr.rmGvkJd9~^/Grѕw򖫈U\oT>i+;]-W]y+o*:]'[~^jՓ~/?Ec7⯖ 4}?L>&.gu$+O&//3ȝ+o- oMke'2׈z!݆RX,611wJs;*1wJs?*Eco>jwkQ]yNM_o#_ G]Dd O >   # A " 2u$YC nY"Q8&`!I$YC nY"@ @BAxڝMh$E_O*F%Žaaw;q-x ,5xDP*.xSqAm* Hz/L! _G$ho_ƯIdZd 8LQQU1Lrq$lgW%c($U/Y5ȪIwᚚ2횹93??ozYXX0~߬Ul@6w5l??0?|ĤgIŤ``q`` sā/&%J)S ):XpAA,:XpAA:XpAA<:XpAhK-Z,XjԂxPxxP<(!'#cˑQs46qS6xtE~tPEנ݃j9SCsO>4 X6ԁX:XpAA<:XpAAZAFn˙p.KSAAR:wX:XpAA<:XpAhtܽ5x=\ͷrlll``6777{{{csrrb7|3EVS,vB+Y*fo%_T_26ul{$̙u?衫IRE\!.w/:]X{k7c{ѳd4:\uX䔶WԶn|6-e܉ZƙK1$sۋ5u%jN$\t5\itZVZՏ~p貭.p k4\[ѵj\tVkvkյp%?+W|^#O,VWpѕKJ\}EJkʢ+kue W]y~7EO-{O?|x&eb:>tz??ʸ+f]agz\]5e&ũݛyE}>jeP(Tʏ[z{2FY(n-ʝwзXE }U+-(ÕJa#atDT5vh$(,䶔ou}_ xט])Dd O >   # A " 2'hIKuHs=&`!k'hIKuH @BA9xڝ?h$Uykpk!)2ILre@6XDP 6ڄBuW`pb0NS8 <̾f2]d|}/ȸ#"2^0GIKU02ɫ+=y 1z37_pI+A<ɲL331䤙2fffƴm3;;k:Y__7fyy7=C?yy#R$Ēđē4!|1)맬~Q,8 ,8 ,8 ,8!S2pAARK-Z,Xj! <(% <# <('DװgMu@玺;✣̒ 8zP) >xPO6_D5A5هPgB X悵rP  `5B2ֶ zi9xP@ڎe,,8 ,8!S2t{>E{u5?aݮ2;;;#s||lNNN9??7F_55hy D/^{J/bg63Faڄ?{Z+e|7gG|œէiJ)_$Y ZhvJ6ZiZZV:4Zee-[6ZݚFkfhFլh6Z5+y]$^z5ZE+k%IF%MVJ幢hԬ^zVfe-/[iѓ~/>SymqM'Vbȵ ߰du=Jk2|&^n'R?yZK^\I*JRXi%)Ř̗r%)29Phީ$77t}PzKiL&ʤ/+D  # A" 25V+qǺTݿ=YoB&`!g5V+qǺTݿ=Y @BA5xڝ=h%Uϼ|aK(쳐[l&&!) ˳  OblB!p-T0A4Xm,̭T)`;@t?ϙ;oN&IGc"S2QbJZցߘ)SO``q``  "Z,XjbR :XpAA,:XpAXpAA<:8 \< .G~G]9k,ك2N AA]NO &iڏ?e]Άz Uu[|e&-L"y\ Sts%PRT(]JZD*$xZ,}ҍkOJ{0ۨ6JJmTwKҀҍOJ[\kZۥ/]>/}TӨTxzr_r09;~ giDd z# >  # A"26,*2qd|uH&`! ,*2qd|uP Fh$xڕMhUG}|MӢJq! R. ih&S4EqJBpEV]i+y RENs?&#W wgws}ܛDFEp hl%5UC$۳s-eWk(Vy$ ch }C~3>>n&&&䤙2z8p4 3;;k=jfff~f sO15<~|Ϭxͤ$gIŤ``q`` }6ā6&%~J)S ):XpAA,:XpAA:XpAA<:XpAh%K.\,XrxPxxP<(!'2#ߑ}46Aixm` AgZ]7*]7\VV+f6GlZժt\jW}IڟT+늮fjEWs]j'o>?q[{mzwKWeʂ' t+ëKKmYWv{QKY>7w^n4wfZŕg2W+<^vu-k4Hd.HcܜsfpgyUw6vZ'y|3;\]oý}A}->`dXʂlYW8(CٵR5ӏ7OH={?[2Q8ӏ\X.̲Vc=??Ӝ7E&*;,ezP[7ӫHRBq>]Z;mn/Z~cJnyE߻h7˽Dd O# >  # A"2S8ݼ(|uӥ4/M&`!'8ݼ(|uӥ44@BAh$xڕOhTGo31MAɖu[(9(gh=5z6iPIklR(RI(S/BH\CuzR҃~{ogw}7w~7Ȉ!2XAbh^KjhmM$^˜OGkEYtZ~o=5<>=__+u\?;R_]\8S|yœYt䐄 {&P3ŨԼ7TwN{HƳ_/!25/?LM}Ⱦ=읜,WީByG]G?#}JQ~y#ݳok"w觝ѷ {&ޯ:=yOno<쟮Dd O >  # A"2@m1y;:ۼS&`!@m1y;:ۼ @BAxڝOh\Uϛk#mjɪ$i^dKE1h.Ap1. BP-dbqaݘU `w{s'7/|ysI""Cc2\ab^KjD9|BM35xĂtP  `5Ԃ4r[ąs!_*5 *5qšģ4hFNkX1.^|#gʊiZfkklooGk>}j̋/їݯEǚ_Z xvZh"ӛjdzRYzݦ[1 S&t?衫 IRD-_!w/:;kc{`tC:紽uĹy;@8s</w.w_Ӥ$EMI' 1zt+]+ҕ\rrՌfYr貕.[rUj\vvU\u?W\,kp$qjGW.:թtuJ.I'*rug++]%W;ڕvՉN;?'eO{ҏ?quZ"ñ'UIV͛ke=X ;N__+[f"';ߌ|c'r|D+W?Z !b"77ؼqq2B"l/}~+-~&sćywu]F2DUq>i4b=׽uf<'fϧLW7"\/ױb ;eflKR/|c+-u3=hݿz/I'߾IsåDd  >  # A"2mRخO &<Ăa <(xPVC-Aܖ;q^ȗJ Xv8`lk؃1/~5s%lVWWݻw۷̓ÇǏͳgύx*7n|xE4|DE)&ZLj;bO)E,Mц1Nz=tB}4`+v׻O;N.ڞa$*z yJ+jjVmV*e: -k|Y:_q{y5JV4JV'e!_INSSI7\RkTjQ5US٤*[S-'rjZKFZM5\Mu3n6nTt絻5(yZOFzMK^WS*ՑIUy6+nMT덪TFU]=NOggN.U|ju.^Y<3'EЖ a]du]몺[ ]wKq3Kg>c//b5g٥y_o1Č,,PkǺ|:}Xxb}>G ssKK /ĊvHRe<䱉C}$y||xlcy `u+ndwo#M9V1wʘ9EXdY~Oz+o䩚筬*~cORGWͶoGMDd k >  # A"2#X0fp^&`!X0fp }FxڝMG_~ n" t";=1F/I$2^%8F0԰r\K@HaKrY/ (9DbWQ= &^U&2-2vwBdkc+iZ&ٖ[I+id[/H|rX.:۪|)333cfggܜٹsif޽sQs_.=qܗo]5O7?pägIŤ``q`` }6ā6&eSO?5 Ģġģ4h<(XjbRK-``qh`(8̩p;r廓>w E{P)^AA<:l~tPEנ݃jϳa>O &<ĂtP  `5Ԃ4 |i@<(Uj@gn݃xPxР)s:^Ccx.qq5nsid]fn޼iݻgܹc|h=zd>}j?n^xa3ukxY4|yѢE<)p;j8/fgJq^ēe)c#&a΄SNܽ/IBkʼn'gswpڎxNq1:\eX͉c/)JZɏ˸643c|}ټjM5?j%kIntk4FWZscc5W?~e6l͵]Kzt]ot]\tFnGF+A|F_##at ]Úk-]k5מtI\ȆuEנ55lt kZkt#S^L%O^:y]dI=R'VT.q#źʪuHuUi~e&ΖΘugz41_=W8>׬H¹+w]x~2Ocw}vܙel=obtv{Ō37|po/ֲg"i3]-2vU3vcC{#2/2~u'+JeOҴpn)Fll遑->uwU[uwGdZd  # A"2:qF'W8gd&`!:qF'W8gp @BAkxڝAH\GǿQSCc<@pћ{ފXȔBC@Arh UZ6RO)T}O~ffvȐHODKMa(eٽԲpm[^&}ʜ1$꼴:Vn[[D 6###fttԌzn&&&YZZ2 fnn-=9:3?|ܤgIŤ``q`` }6ā6&%J)S ):XpAA,:XpAA:XpAA<:XpAhK-Z,XjԂxPxxP<(!'2#ˑQ}46Aixm` AgO &  # A"2Tݧi5qW ݞ?i&`!Tݧi5qW ݞ? @BAh$xڕ?hGߜF(`J X6K{WY(3)2v 8. Uap" $ܤIqN"nJ""|7޼{w22&2In aK#RUy=L+3ڑf[9yD_)rvGW~}_,Q;>>n'&&䤝իvmmͮإ%_u^bɷ6G٧Oٝoیx x x x xq΁xd~gVA2tp!8tp!xtp!tp!FMCG-Z8jqx x  x <PEAZ5u@  # A"2Fr$YIہbko&`!Fr$YIہb @BAxڝOhUyiђS$B[ X(H>T z 9-a{`߹S ??oL&ՁΛ{ow~ɜgDtO8a.ads/w{n6y$ q2.b2䷉|Y3??o⢹pfii+Wm3~96z/_?b?o~)΂ b  ؘ9sύ``q``  "Z,XjbR :XpAA,:XpAXpAA<:8 \< kG]Ah`Cg8k<(G[GQt :=|}<5<{jC bkC蠌šģDj4h BWᨢy^;sQh{yn{u.JgNG}}YZ_\is_NYӂdeM ğIb~r;]+Oӕ\rr˵\;&tٖk\NרON~u\u+nun\l)ҝc8Ɲq5IIkrIUݩ+:][-8Ɲq5IIsƞsOo}{ɏ_řS7Yg|ΜZ V֬Fvz]3/+3W亄rUO\=-a=jewSF9LMo Q Z̰و^hڠ1k1`Xbյs䛍bX{1XkeF\sl5kx̱YʽZk1G\ba#z+:VẔ^br]+ߏacSֱ[\kGۭr4bB?rIoƳ{Dd O >  # A"2B0Md7"(t&`!B0Md7"( @BAxڝ?hGߞG(`%F* ҭ]4ԚHI@K#T\$&E<ĕ 1q囝ќW >ooޛۧBfENqRLuc fӨ訪Fx:wNugsG']9f)oXփa}1dHP ̌3faa={t]h˗ͅ L7+f_1w5l?7wiJbJXt8txtk6ā6$I%K %:XpAA,:XpAA:XpAA<:XpAhK-Z,XjԂxPxxP<(!'2#Q#.9k,ك2. VAA]NO &cui*ue_t:?Occzɺ&Y_K|,F*;\:Mcma.R\^iL{αVẔk1rc֋LTJ?VkXδ8j/r-!c^Z'\i#bބsu^z>IlٶOb=b~aKQ l \;̞\-VFdZظWٳ1^R{;&y^MZYx+錼쯤kv<!Dd O >  # A"28秜; 1:zz&`! 秜; 1:p@BAxڝOhTGo31h\eޢ$ Wm&l,16z^ބ0-T=zK=yPJ-g˓+y7cȈ@kHd 6 QPU1LFvm$hO9bI[nq[O^fttԌq~l6ÇM1sssɓF?=}<]2O>4waRbRXt8txt{6ā6&%?%?%?%?5 Ģġģ4h<(XzbҋK/``qh`(8<ǽ/G/j,PՃ2N f AՐه!كЃ' <( }2xPxPEtРm4Uz<(Uz@'qšģ4hF5 q|+̹sꪹv횹yywyyyyyyW֭owEךZ )OF8 Dݻj8/vegJq^ēe)k+8d܄S=*HAgͧ'͘;?ųMFUVd<{N|u'?.J4мlڏK4&I[~W3fŕFWZJ+蚩uT\Ժ:.[jtֺV+uurj]]k]+Duzkp$ɺ]ZWEWի$ߨU>ٰ蚮uMW\ֺW/zW?5?~ӉL4dI}1ӏNN lNq eA5K[ą8YƵsV$^V&NH,_woXH>_kS/foPIC  LBook  s META < X PRINTr Lh.O  =B=Sheet1(Data1;(Data2;, Data2Sub1;, Data2Sub2;, RowOfJunk;   =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   ASheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWbb P     ~ @R@@<@ ~ W@=@$@ ~ ?@C@A@ ~ N@@D@ ~ H@F@@ ~ 6@(@F@ ~ C@@5@ ~ V@ ~ X@  Junk Junk Junk Junk Junk Junk Junk Junk Junk Junk Junk~ [@  ~ F@  ~ ;@  ~ *@  ~ U@ ~ H@ "JJJJJJJJ000000>  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-   2 p73 2 4 2 028 2 #p92 2 #29 2 #010 2 4p31 2 438 2 4035 2 Ep60 2 E2 2 E040 2 Vp49 2 V45 2 V75 2 gp22 2 g12 2 g044 2 xp39 2 x6 2 x021 2 p88 2 p98 2 Junk 2 Junk 2 CJunk 2 Junk--4 '0U _     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3 ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-  2 8p73 2 8+4 2 828 2 lp92 2 l29 2 l10 2 p31 2 38 2 35 2 p60 2 +2 2 40 2 p49 2 45 2 5 2 <p22 2 <12 2 <44 2 pp39 2 p+6 2 p21 2 p88 2 p98 2 Junk 2 RJunk 2 $Junk 2 Junk-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qCompObj fObjInfo SummaryInformation( DocumentSummaryInformation8 Oh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets_998994250  F Ʉ]Q Ʉ]QOle  9PIC    LBook  )F! _910630604Lh.O  =B=Sheet1(Costs; +Revenues;  =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0                + ) , *  #    Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bbPbPPPPb b  b  Revenues CostsProfits@@@@ @h@ @@@@@y@@p@@@@ @@  @@  h@@@  @@@  P@@ 8 >  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3META   PRINTCompObj %fObjInfo'      !"#$&)*,-.13456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]_`abcdefghijklmnopqrstuvwxyz{|}~ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-  2 FRevenues 2 Costs 2 Profits 2 #W$1,6002 #$1,4002 4W$2,0002 4$1,8002 EW$2,1002 E$1,8002 VW$2,9002 V$2,800 2 gb$500 2 g$4002 xW$1,7002 x$1,5002 W$2,0002 $1,9002 W$2,5002 $2,300--4 '0U w     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial- 2 8Revenues2 8Costs 2 8Profits 2 l$1,600 2 l$1,400 2 $2,000 2 $1,800 2 $2,100 2 $1,800 2 $2,900 2 $2,800  2 <B$500 2 <$4002 p$1,700 2 p$1,500 2 $2,000 2 $1,900 2 $2,500 2 $2,300 -'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qSummaryInformation((DocumentSummaryInformation8+_998994249& F Ʉ]Q Ʉ]QOle /9Oh+'008PhChris Albright)Chris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University3 Sheet1  Worksheets)F! _910630630PIC 0LBook 2 META ^PRINT L/  =B= =\ <X@"16Arial16Arial16Arial16Arial16Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0                + ) , *    #  ~Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U}   bb&WWb bC;Table of costs for units produced in one month (along side),$for use in another month (along top) Feb Mar Apr May Jan4̰@ A? AA48@ A? AA4@ A? AA4 @ A? AA Feb4|@ A? AA4@ A? AA4d@ A? AA Mar 4@ A? AA4@ A? AA Apr 4 @A? AA  Total cost =YBFW> " /           ,@!"#$%&'()*+-.9G012345678:;<=>?AUBCDEFHIJRKLMNOPQS\TVeWXYZ[]_^`sabcdfvghijklmnopqrtuw}xyz{| """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-  - ! -MM- !M-- !-- !-'- Arial--"Systemn-'-- Arial--   !? !A ! ! ! ! !  ! !L !N `2 ;Table of costs for units produced in one month (along side)   !? !A ! ! ! ! =2 $for use in another month (along top)  2 4uFeb 2 4Mar  2 4Apr  2 42May  2 EJan2 Ed$4,3002 E$3,1002 E$3,4002 E$$5,900 2 VFeb2 V$5,5002 V$6,4002 V$$6,500 2 gMar 2 g$6,8002 g$$6,400 2 xApr 2 x$$5,9002  Total cost--4 ',2U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial= -"Systemn-'-  Arial- `2  ;Table of costs for units produced in one month (along side)           $     =2 8 $for use in another month (along top)      $     2 Feb 2 SMar# 2 ,Apr 2 May# 2 Jan2 J$5,000 2 $5,500 2 $4,400 2 $3,900  2  Feb2 $6,100 2 $5,400 2 $4,700  2 < Mar#2 <$4,300 2 <$6,900  2 p Apr2 p$4,900 2  Total cost   -'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qCompObjfObjInfoSummaryInformation(DocumentSummaryInformation8Oh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets_998994247  F Ʉ]Q Ʉ]QOle 9PIC LBook ^)F! _910630713L,A  ,      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  #  [Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} I } $ }  Ibb&WWb  b [  bbD@@PPb@bbbb Student ID Exam scoreNumber enrolled@O@Number who took exam@@R@ @R@ ~ &@Absent @@S@ @L@ i@P@ @V@  @@S@  @T@  @Q@  @R@  I@R@ @T@ @Q@ @U@H@@S@@Q@|@U@~ N@Absent@T@@@T@@U@@Q@@S@@@T@@X@v@R@@S@d@P@ػ@@V@D}lQ@$$.$$$$$$$$$$$  bb!&"WW#$%b&'()*b+[,-b.b/D@0@1P2Pb3@456bb7b8b9:;<=>? @Q@!@@S@~ "P@"Absent#D@T@$0@R@%h@U@&@R@'@U@(ܪ@@S@)@@R@*@R@+@S@,Ӹ@T@-@@S@.~@R@/@@S@0Z@Q@1)@Q@2}@Q@3ڼ@S@4@Y@R@5@T@6@@R@7H@N@8;@O@9@Q@: @W@;l@@U@<@@S@=T@S@>ȼ@U@?@T@DJl @bbA&BWWCDEbFGH@@T@A@S@B*@@V@Cs@R@D@@Q@E"@P@F@Q@G@T@HX@N@z> " META "D PRINT  CompObj!$.fObjInfo0     !"#$%&'()*+,-/23567:<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwyz{|}~333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-HH- !H-- !-- !-nn- !n-- !-'- Arial--"Systemn-'-- Arial-  2  Student ID  2 U Exam score  2 Number enrolled   2 *3416 2 62%2 Number who took exam    2 #*6125 2 #73 2 4*1535 2 474 2 E*23232 EKAbsent  2 V1577 2 V77 2 g*9044 2 g57 2 x*8403 2 x67 2 *5892 2 90 2 *4242 2 77--4 '.U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial- 2 ! Student ID  2   Exam score$ 2 Number enrolled$   2 83416 2 862%2 8Number who took exam$   $ 2 l6125 2 l73 2 1535 2 74 2 23232 Absent 2 577 2 77 2 <9044 2 <57 2 p8403 2 p67 2 5892 2 90 2 4242 2 77-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AllbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  WorksheetsSummaryInformation(#%1DocumentSummaryInformation84_9989942460* F Ʉ]Q Ʉ]QOle 89)F! _910683532Lz* z*      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ffPIC ')9LBook /8META (,;PRINTx =B= =v<X@"1@Arial1@Arial1@Arial1@Arial1@Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  # )  oSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} m}  } $  Ab@b&WWb   b b bD@@PPbbbbb;3Average exam score (for students who took the exam):2Average exam score (if absent students get zeroes) Student ID Exam score@Q@_@R@A@T@@O@@R@~ @ Absent ַ@@U@ v@Q@ @P@ s@R@@@T@@R@@T@@@R@@O@@T@@V@@Q@a@@R@@Q@L@Q@پ@Q@@T@d@S@@R@@@T@@S@@T@BXIH,  bb!&"WW#$%b&'()*b+b,-./bD@0@1P2Pb3456bb7b8b9:;<=>? ɽ@P@!@P@")@W@#|@R@$4@@Q@%x@@U@&G@S@'@@T@~ (@(Absent)4@@S@*@Q@+5@Q@,O@@Q@-@@R@.B@N@/Է@S@0X@R@1R@P@2@O@3@@S@4@V@56@@T@6@U@7a@S@8@@S@9f@@T@~ :@:Absent;h@@R@<@T@=@M@>J@R@?Dz@R@DTl  @bb@E@S@*> " 333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -55- !5-hh- !h-yy- !y-- !-- !-- !-- !-- !-- !-- !-- !-- !-- !-ZZ- !Z-- !-'- Arial--"Systemn-'-- Arial---'-- 5  $2 Average exam score  "2 (for students who  2 %took the exam) --'-- --'-- h6 $2 6Average exam score  %2 G(if absent students 2 X get zeroes)--'--  2 z Student ID  2 z Exam score   2 c1533 2 68 2 c8031 2 74 2 c9859 2 80 2 c9106 2 63 2 c3535 2 72 2 c81922 Absent --4 ',h Y   F """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' E' O' EArial!-"Systemn-'- EArial--'-  $2 Average exam score  $  *2 > (for students who took        2 r the exam)  $-'- E-'- > $2 Average exam score  $  +2 (if absent students get       2  zeroes)-'- E 2 v Student ID  2 v Exam score$  2 F1533 2 68 2 F8031 2 74 2 F9859 2 80 2 FF9106 2 F63 2 zF3535 2 z72 2 F81922 Absent -'- O-4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightCompObj+.fObjInfoSummaryInformation(-/DocumentSummaryInformation8Chris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  WorksheetsLh.O  _9989942454 F Ʉ]Q Ʉ]QOle PIC 13LMETA lh. 1     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-  2  Sales rep 2 WAllison 2 Baker 2 Jones2 Miller 2 \Smith 2 Taylor2 # Jan sales2 #W$3,7002 #$2,4002 #$2,3002 #$3,0002 #W$3,8002 #$3,7002 4 Feb sales2 4W$2,6002 4$2,2002 4$2,4002 4$2,8002 4W$3,6002 4$2,3002 gF Min sales 2 g Max sales  2 xJan 2 Feb--4 '0U 3    ''  '  '  Arialn- 2 8 Sales rep  2 8"Allison 2 8BakePRINT26pCompObjfObjInfo58Workbook7 r2 8Jones2 8Miller# 2 8ySmith$ 2 8CTaylor 2 l Jan sales  2 l$3,700 2 l$2,400 2 l$2,300 2 l$3,000 2 lg$3,800 2 l9$3,700 2 Feb sales  2 $2,600 2 $2,200 2 $2,400 2 $2,800 2 g$3,600 2 9$2,300 2 < Min sales#   2 < Max sales#   2 p Jan 2  Feb' FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q A@\pChris Albright       !"#$%&'()*+,-./1235678;=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefgijklmnopqrstuvwxyz{|}~ Ba=4 =-[ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0                + ) , *  #   8 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`]Sheet1`i Sales repAllisonBakerJonesMillerSmithTaylor Jan sales Feb sales Min sales Max salesJanFeb X A@  dMbP?_*+%&A Page &PMODT2 on SOB_NCR:d,,ODT2 on SOB_NCR\\SOB-NW1\ODT2 ,,"d,,??U         *@@@p@@@ *P@0@@@ @@       db<<8$>@7 SummaryInformation(790DocumentSummaryInformation84_998994244b> F Ʉ]Q]QOle 99Oh+'08@Xp Chris AlbrightChris AlbrightMicrosoft Excel@LR՜.+,0 PXt | Indiana Universityh Sheet1  Worksheets)F! _910685470L=)a#  =B=Sheet1* AnnualRate:E) Principal:E$Term: ="z <X@"PIC ;=:LBook < META <@hx PRINT 1QArial1QArial1QArial1QArial1QArial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *        @    ,Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} m   bb &  g!  W! WW d91Payments for Mr. Jones, who just bought a new car Amount financed~ L@ Annual interest ratebX9ȶ?PaymentL lU}@6CF CFC'FB;( Term (number of months financed)~ B@@8Note that the PMT function is in the financial category. Monthly paymentE=In general, it has 5 arguments, but the last two are optional >6and aren't needed here. There is a minus sign next to <+Principal because it is paid, not received."* xYCf> " =)      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-VV- !V-hh- !h-yy- !y-- !-- !-- !-- !-- !-NN- !N-- !-  !U !W  !@U !@g-'- Arial--"Systemn-'-- Arial--   ! ! !  ! Q2 1Payments for Mr. Jones, who just bought a new car     2 #Amount financed 02 #$15,000%2 4Annual interest rate 2 48.90% 72 E Term (number of months financed)    2 E362 WMonthly payment  --4 '\+ t    """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' "' (-  ! !<-'- "Arial--"Systemn-'-- "Arial- Q2  1Payments for Mr. Jones, who just bought a new car$   #       2 l Amount financed$ c2 l$15,000 %2 Annual interest rate    2 8.90% %--'--  72 Term (number of months financed)$ $  $   2 C36--'-- "--'-- >  2  Monthly payment#   $ --'-- "--'-- (  !? !?u--4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightMicrosoft ExcelCompObj?BfObjInfoSummaryInformation(ACDocumentSummaryInformation8՜.+,08@ \d l Indiana University Sheet1  WorksheetsL/!  =B= _998994243H F]Q]QOle PIC EGLBook        !"#$%&'()*+,-./012478:;<?ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnpqrstuvwxyz{|}~=\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  #  [Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} m} $ } } I} $   bb & WW   b  QIFor each product, if the end inventory is less than or equal to 50 units, MEenough units are ordered to bring stock back up to 200; otherwise, no )!units of that product are ordered Product End inventory!Order placed (yes or no)?# of units ordered   Order placed?  # ordered?Y@ 7 `!D2  yes noBno9  #D2  D B@D@ 7 ` !D2  yes noByes9 d@ #D2  D B@4@ 7 ` !D2  yes noByes9 f@ #D2  D B@Q@ 7 ` !D2  yes noBno9  #D2  D BHuqM> " V2U x  META FJXPRINT CompObjIL3fObjInfo5 / '     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-44- !4-- !-##- !#-- !-- !-'- Arial--"Systemn-'-- Arial--   !3 !5 ! ! !" !$ ! ! u2 IFor each product, if the end inventory is less than or equal to 50 units,  !3 !5 ! ! !" !$ ! ! o2 Eenough units are ordered to bring stock back up to 200; otherwise, no   !#3 !#5 !# !# 92 #!units of that product are ordered2 EProduct 2 E9 End inventory -2 EOrder placed (yes or no)? "2 E(# of units ordered 2 V+1 2 Vr100 2 g+2 2 gy40 2 x+3 2 xy20 2 +4 2 y70--4 '   """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial--'- 4 u2  IFor each product, if the end inventory is less than or equal to 50 units,                -'-   o2 8 Eenough units are ordered to bring stock back up to 200; otherwise, no                 92 l !units of that product are ordered      2 Product 2 End inventory  -2 Order placed (yes or no)?!     "2 # of units ordered     2 1 2 w100 2 <2 2 <40 2 p3 2 p20 2 4 2 70-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightSummaryInformation(KM6DocumentSummaryInformation89_998994242XDR F]Q]QOle =Chris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  WorksheetsLh.O  PIC OQ>LBook @ META PTLPRINTo =B= =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  #  [Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U  bb &  g!  W WW d P bbVNEach student gets an A (if score is 90 or above), S for satisfactory (if score UMif 60 or above but less than 90) or U for unsatisfactory if score is below 60 Student Score Grade   Grade?Q@ O  9DZ A%D< S U"BS@W@ O  9DZ A%D< S U"BA@K@ O  9DZ A%D< S U"BU@T@ O  9DZ A%D< S U"BS@N@ O  9DZ A%D< S U"BS @V@  O 9D Z A%D < S U"BAOzy`>  0U   h. !     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial--   !? !A ! ! ! ! ! ! !? !A ! ! |2 NEach student gets an A (if score is 90 or above), S for satisfactory (if score     !? !A ! ! ! ! ! ! !? !A ! ! {2 Mif 60 or above but less than 90) or U for unsatisfactory if score is below 60  2 4Student 2 4\Score 2 4Grade  2 E71 2 Ep70 2 V72 2 Vp95 2 g73 2 gp55 2 x74 2 xp80 2 75 2 p60 2 76 2 p90--4 '   """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial- |2  NEach student gets an A (if score is 90 or above), S for satisfactory (if score                    {2 8 Mif 60 or above but less than 90) or U for unsatisfactory if score is below 60                   2 <Student  2 1Score2 Grade! 2 1 2 p70 2 2 2 p95 2 <3 2 <p55 2 p4 2 pp80 2 5 2 p60 2 6 2 p90-'- -4' FMicrosoft Excel WorksheetBiCompObjSVfObjInfoSummaryInformation(UWDocumentSummaryInformation8ff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  WorksheetsLh.O#  =B= =z <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);_998994240\ F]Q]QOle PIC Y[LBook W \("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  # #0 @ #0 @ #0 @  Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} $ }  }   bb &  g!  W! WW d P bb QIInvestor sells stock only if its price has gone up three consecutive days #(including the current day)  Day Price changeSell (yes or no)?   Sell?~ ? Up ~ @ Down ~ @ Up N 蠙8DUp DUp DUp B$ Yes NoBNo~ @ Up N  8DUp DUp DUp B$ Yes NoBNo~ @ Up N  8DUp DUp DUp B$ Yes NoBYes~ @ Down  N  8DUp DUp D Up B$ Yes NoBNosEm8:> " h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3META Z^PRINT CompObj]`AfObjInfoC      !"#$%&'()*+,-./0123456789:;<=>?@BEFHIJMOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-gg- !g-xx- !x-- !-- !-- !-GG- !G-- !-- !-@@- !@-- !-- !-  !Gf !Eh !ff !f-'- Arial--"Systemn-'-- Arial--   !F !H ! ! ! ! !? !A ! ! u2 IInvestor sells stock only if its price has gone up three consecutive days  !F !H--'-- "  02 (including the current day)--'--   2 4.Day 2 4L Price change !2 4Sell (yes or no)?  2 E>1 2 EUp  2 V>2 2 VxDown   2 h>3 2 hUp  2 y>4 2 yUp  2 >5 2 Up  2 >6 2 xDown  --4 '0     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' ' -  !O9 !O -'- Arial--"Systemn-'-- Arial- u2  IInvestor sells stock only if its price has gone up three consecutive days                  02 8 (including the current day)       2 Day2  Price change  !2 Sell (yes or no)?    2 1 2 Up--'-- ;  2 2 2 Down--'--   2 ?3 2 ?Up 2 s4 2 sUp 2 5 2 Up--'--   2 6 2 Down--'-- --'--   !9 !9G--4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08SummaryInformation(_aDDocumentSummaryInformation8G_998994239Nf F]Q]QOle K9@ \d l Indiana University Sheet1  Worksheets)F! _910686987Lh.O  =B= =\ <X@"1PIC ceLLBook N; META dhPRINT Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  #   oSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U  bb & WW   b  b PPCAny student who scores at least 95 on any of the exams gets a bonus&) )!which is 1% of their total score. StudentExam 1Exam 2Exam 3Exam 4 Bonus   Bonus$?U@T@T@T@ b LD_ D_ D_ D_ B%{Gz?%in B$@@S@R@R@@X@ b  @ LD_ D_ D_ D_ B%{Gz?%in B$@T@W@S@R@ b RQ @ LD_ D_ D_ D_ B%{Gz?%in B$@T@U@X@V@ b > ףp= @ LD_ D_ D_ D_ B%{Gz?%in B$@S@W@@T@S@ b  LD_ D_ D_ D_ B%{Gz?%in B$ @R@T@T@R@  b  LD _ D _ D _ D _ B%{Gz?% in BvO>  0U   h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-Arial---   !? !A ! ! ! ! ! ! !? !A ! !--'-- --  @2 &Any student who scores at least 95 on  - 2 any-.2  of the exams gets a bonus --'--    !? !A ! ! 92 !which is 1% of their total score.  2 4Student 2 4QExam 1  2 4Exam 2  2 4Exam 3  2 4Exam 4  2 4YBonus  2 E71 2 Ep87 2 E83 2 E83 2 E080 2 V72 2 Vp77 2 V72 2 V74 2 V097 2 g73 2 gp80 2 g95 2 g79 2 g075 2 x74 2 xp82 2 x87 2 x96 2 x088 2 75 2 p78 2 94 2 81 2 079 2 76 2 p75 2 83 2 80 2 072- -4 '   """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial-Arial---'- 4-- @2  &Any student who scores at least 95 on          - 2 any-.2  of the exams gets a bonus   $    -'-   92 8 !which is 1% of their total score.   %       2 <Student  2 Exam 1$ 2 Exam 2$ 2 Exam 3$ 2 Exam 4$ 2 qBonus 2 1 2 p87 2 B83 2 83 2 80 2 2 2 p77 2 B72 2 74 2 97 2 <3 2 <p80 2 <B95 2 <79 2 <75 2 p4 2 pp82 2 pB87 2 p96 2 p88 2 5 2 p78 2 B94 2 81 2 79 2 6 2 p75 2 B83 2 80 2 72-'- -4' FMicrosoft Excel WorksheetBiCompObjgjfObjInfoSummaryInformation(ikDocumentSummaryInformation8ff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910766210Lh.O  =B=Sheet1. LookupTable; =\ <X@"1Arial1Arial1Ari_998994238p F]Q]QOle 9PIC moLBook x al1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  #  Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bbW @Student Score Grade Lookup table?P@0pD# ,lBfD~  F@R@0D# ,lBfC~ N@ D@@S@0yD# ,lBfC~ Q@ C@Q@0yD# ,lBfC~ T@ B@P@0yD# ,lBfD~ V@ A@@T@0yD# ,lBfB @@W@0yD# ,lBfA  @M@0y D# ,lBfF  "@V@0 y D # ,lBfA avvvvvaaa>  h. \     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3META nrPRINT% CompObjqtMfObjInfoO      !"#$&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLNQRTUVY[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-  2 Student 2 \Score 2 Grade -  !? !A 2  Lookup table 2 71 2 p67 2 D 2 70 2 vF 2 #72 2 #p72 2 #C 2 #060 2 #uD 2 473 2 4p77 2 4C 2 4070 2 4uC 2 E74 2 Ep70 2 EC 2 E080 2 EuB 2 V75 2 Vp66 2 VD 2 V090 2 VuA 2 g76 2 gp81 2 gB 2 x77 2 xp93 2 xA 2 78 2 p59 2 F 2 79 2 p90 2 A --4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  ArialT-"Systemn-'-  Arialn- 2 <Student  2 1Score2 Grade!2 R Lookup table   2 81 2 8p67 2 8RD 2 80 2 8F 2 l2 2 lp72 2 lRC 2 l60 2 lD 2 3 2 p77 2 RC 2 70 2 C 2 4 2 p70 2 RC 2 80 2 B 2 5 2 p66 2 RD 2 90 2 A 2 <6 2 <p81 2 <TB 2 p7 2 pp93 2 pTA 2 8 2 p59 2 VF 2 9 2 p90 2 TA-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qSummaryInformation(suPDocumentSummaryInformation8S_998994237lz F]Q]QOle W9Oh+'008PhChris AlbrighteChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910767017PIC wyXLBook Z( META x| PRINThLh.O  =B=Sheet1)LTable; =\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0 "$"#,##0.00                + ) , *  #      Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&g! WWWdbPOrder # Units sold Total cost   Total cost  Lookup table?Pw@ 5 $@ D# &BfD @@}@ 5 @ D# &BfD r@@@|@ 5 @ D# &BfD y@@@{@ 5 @ D# &BfD  @m@ 5 P@ D# &BfD  @u@ 5 D@ D# &BfD  @u@ 5 @ D# &BfD   @`i@ 5 @D# &BfD  i}}}}>  h. w     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff   $ ! "#%;F&'()*4,-./012356789:<=>E?@ABCDGSVHIJKLMNOPQRTUWnrXYZ[\g^_`abcdefhijklmoqpsytuvwx{|}~333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-  2 Order # 2 D Units sold 2  Total cost 2 71 2 i373 2 #72 2 #i475 2 473 2 4i459 2 E74 2 Ei441 2 V75 2 Vi238 2 g76 2 gi349 2 x77 2 xi344 2 78 2 i203--4 '0U /     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial!- 2 >Order #! 2  Units sold   2  Total cost   2 81 2 8Y373 2 l2 2 lY475 2 3 2 Y459 2 4 2 Y441 2 5 2 Y238 2 <6 2 <Y349 2 p7 2 pY344 2 8 2 Y203-'- -4'  FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08CompObj{~fObjInfoSummaryInformation(}DocumentSummaryInformation8@ \d l Indiana University Sheet1  Worksheets)F! _910768588L:5-  =B= = \ <X@"1_998994236 F]Q]QOle 9PIC LBook        !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJLOPRSTWYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0% "$"#,##0.00                + ) , *         #  D    Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} $}  }  } I bb&g! WWWdb Price of car~ @ Data table  Down payment~ @ Interest rateMonthly paymentAmount financedL@ DD ZX5}@DAnnual interest rate~ !@~  @T@K`}@6}@Number of payments~ B@~  @lQp|}@ ~ !@ZX5}@Monthly payment+ZX5}@D DDB;~ !@' }@Total interest paid$0e~@terDDD~ "@}@Qdjyc=> " 7U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3META PRINT CompObjKfObjInfoM:5      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-- !-- !-- !-WW- !W-- !-- !- !l"W-'- Arial--"Systemn-'-- Arial-  2  Price of car 2 $20,0002  Data table 2  Down payment   2 $5,0002  Interest rate2 \Monthly payment  2 #Amount financed 02 #$15,00002 #$473.51%2 4Annual interest rate 2 48.50% 2 408.00% 2 4$470.05"2 ENumber of payments    2 E362 E08.25% 2 E$471.782 V08.50% 2 V$473.512 gMonthly payment  t2 g$473.512 g08.75% 2 g$475.25$2 xTotal interest paid2 x $2,046.472 x09.00% 2 x$477.00--4 'ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' -  !5ajh-'-  Arial--"Systemn-'--  Arial- 2  Price of car   *s2 $20,000 2 c Data table     2 8 Down payment $ ^s2 8$5,000 2 8 Interest rate    2 8Monthly payment#   $ 2 l Amount financed$ s2 l$15,000 2 l$473.51 %2 Annual interest rate    2 8.50% %2 8.00% %2 *$470.05 "2 Number of payments$  $  2 S362 8.25% %2 *$471.78 2 8.50% %2 *$473.51 2 < Monthly payment#   $ bs2 <$473.51 2 <8.75% %2 <*$475.25 $2 p Total interest paid     s2 p $2,046.47  2 p9.00% %2 p*$477.00 --'-- --4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightSummaryInformation(NDocumentSummaryInformation8Q_998994234v F]Q]QOle U9Chris AlbrightLMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910769781L6  PIC VLBook X META +PRINT  =B= =!\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0%                + ) , *         #  D  Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} $} I } m} I  bb&g! WWWdb Price of car~ @ Data table  Down payment~ @InterestMonthly paymentTotal interestAmount financedL@ DD ZX5}@D0e~@DAnnual interest rate~ !@~  @T@K`}@6}@B@Number of payments~ B@~  @lQp|}@J@ ~ !@ZX5}@0e~@Monthly payment+ZX5}@D DDB;~ !@' }@0z@Total interest paid$0e~@DDD~ "@}@R@Ty\> " 9U   6      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-- !-- !-- !-GG- !G-- !-- !- !"G-'- Arial--"Systemn-'-- Arial-  2  Price of car 2 $20,0002   Data table 2  Down payment   2 $5,0002 Interest2 MMonthly payment  2 Total interest2 #Amount financed 02 #$15,00002 #$473.510 2 # $2,046.47%2 4Annual interest rate 2 48.50% 2 4 8.00% A2 4$470.05A 2 4 $1,921.64"2 ENumber of payments    2 E362 E 8.25% R2 E$471.78R 2 E $1,983.982 V 8.50% c2 V$473.51c 2 V $2,046.472 gMonthly payment  t2 g$473.512 g 8.75% t2 g$475.25t 2 g $2,109.09$2 xTotal interest paid2 x $2,046.472 x 9.00% 2 x$477.00 2 x $2,171.86--4 '   """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' -  !5j4-'-  Arial!--"Systemn-'--  Arial- 2  Price of car   *z2 $20,000 2 j Data table   2 8 Down payment $ ^z2 8$5,000 2 8Interest   2 8OMonthly payment#   $ 2 8Total interest    2 l Amount financed$ z2 l$15,000 2 l$473.51 2 l $2,046.47  %2 Annual interest rate    2 8.50% %2 8.00% %2 $470.05 2  $1,921.64  "2 Number of payments$  $  2 Z362 8.25% %2 $471.78 2  $1,983.98  2 8.50% %.2 $473.51 .2  $2,046.47  2 < Monthly payment#   $ bz2 <$473.51 2 <8.75% %b2 <$475.25 b2 < $2,109.09  $2 p Total interest paid     z2 p $2,046.47  2 p9.00% %2 p$477.00 2 p $2,171.86  --'-- --4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qCompObjfObjInfoSummaryInformation(DocumentSummaryInformation8Oh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets_998994233 F]Q]QOle PIC LBook * LV/  =B= =\ <X@"18Arial18Arial18Arial18Arial18Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0% "$"#,##0.00                + ) , *         #  D  D    Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} $} I } $ } m } }    bb & WW   b  b Price of car~ @   Data table   Down payment~ @   Term Monthly payment Total interestAmount financedL@ DD  ZX5}@D 0e~@ DAnnual interest rate~ !@ ~  (@ [/q@ 6 @ М(|܅@ Number of payments~ B@ ~  8@ WKUN@  +P@  ~  B@ ZX5}@  0e~@ Monthly payment+ZX5}@D DDB; ~  H@ T$—w@  ٌu@ Total interest paid$0e~@ DDD dj> " V/      """)))UUUMMMBBB999|PP3f333f3333f3fffMETA  PRINT3h CompObjYfObjInfo[      !"#$%&'()*+,-./012456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXZ]^`abeghijklmnopqrstuvwxyz{|}~fff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-- !-- !-- !-GG- !G-- !-- !-'- Arial--"Systemn-'-- Arial-  2  Price of car 2 $20,0002  Down payment   2 $5,0002 #Amount financed 02 #$15,000%2 4Annual interest rate 2 48.50% "2 ENumber of payments    2 E362 gMonthly payment  t2 g$473.51$2 xTotal interest paid2 x $2,046.47--4 '1U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial!-"Systemn-'-  Arial- 2  Price of car   *z2 $20,000 2 8 Down payment $ ^z2 8$5,000 2 l Amount financed$ z2 l$15,000 %2 Annual interest rate    2 8.50% %"2 Number of payments$  $  2 Z362 < Monthly payment#   $ bz2 <$473.51 $2 p Total interest paid     z2 p $2,046.47  -'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08SummaryInformation(\DocumentSummaryInformation8__998994232 F]Q]QOle c9@ \d l Indiana University Sheet1  Worksheets)F! _910770243L(6  =B= =u!\ <X@"1PIC dLBook f META ]PRINTLArial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0%                + ) , *          D  Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} I}   bb&WWbb Price of car~ @%Data table of monthly payment  Down payment~ @ZX5}@menD@@@p@Amount financedL@ DD~  @Y V@6 T@K`}@NXk{@Annual interest rate~ !@~  @} s@lQp|}@]5{@Number of payments~ B@~ !@Oo!J@ZX5}@eA {@ ~ !@ HT@' }@X {@Monthly payment+ZX5}@D DDB;~ "@G@}@}#{@Total interest paid$0e~@DDDij{> " 8U "    (6 p      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  -   "-  "- ! -- !-'-   - - ! -"" - ! "-33 - ! 3-DD - ! D-UU - ! U-ff - ! f-ww - ! w- - ! - - ! - - ! -- !-- !-  - ! -KK- !K-- !-- !-  - ! - !A -'-  Arial--"Systemn-'--  Arial-  2  Price of car 2 $20,000-  !J !L ! ! 32 Data table of monthly payment   2  Down payment   2 $5,000E2 $473.512 ^$4,0002 $5,0002 $6,0002 #Amount financed 02 #$15,0002 #$8.00% 02 #W$501.3802 #$470.0502 #$438.71%2 4Annual interest rate 2 48.50% 2 4$8.25% A2 4W$503.23A2 4$471.78A2 4$440.33"2 ENumber of payments    2 E362 E$8.50% R2 EW$505.08R2 E$473.51R2 E$441.952 V$8.75% c2 VW$506.94c2 V$475.25c2 V$443.572 gMonthly payment  t2 g$473.512 g$9.00% t2 gW$508.80t2 g$477.00t2 g$445.20$2 xTotal interest paid2 x $2,046.47--4 ' """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' -  !56o-'-  Arial--"Systemn-'--  Arial- 2  Price of car   *2 $20,000 32 wData table of monthly payment     $   $ 2 8 Down payment $ ^2 8$5,000 ^+2 8$473.51 ^2 8~$4,000 ^2 8P$5,000 ^2 8"$6,000 2 l Amount financed$ 2 l$15,000 2 l8.00% %2 lg$501.38 2 l9$470.05 2 l $438.71 %2 Annual interest rate    2 8.50% %2 8.25% %2 g$503.23 2 9$471.78 2 $440.33 "2 Number of payments$  $  2 g362 8.50% %2 g$505.08 2 9$473.51 2 $441.95 2 8.75% %.2 g$506.94 .2 9$475.25 .2  $443.57 2 < Monthly payment#   $ b2 <$473.51 2 <9.00% %b2 <g$508.80 b2 <9$477.00 b2 < $445.20 $2 p Total interest paid     2 p $2,046.47  --'-- --4'CompObjfObjInfoSummaryInformation(DocumentSummaryInformation8 FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrighteChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910770243L/  =B= =u!\ <X@"1Arial1Arial1Arial1_998994231 F]Q]QOle 9PIC LBook       !"#$%&'()*+,-./0123456789:;<=>?@ABCEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghiknoqrsvxyz{|}~Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0%                + ) , *          D  Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U} I}   bb&WWbb Price of car~ @%Data table of monthly payment  Down payment~ @ZX5}@menD@@@p@Amount financedL@ DD~  @Y V@6 T@K`}@NXk{@Annual interest rate~ !@~  @} s@lQp|}@]5{@Number of payments~ B@~ !@Oo!J@ZX5}@eA {@ ~ !@ HT@' }@X {@Monthly payment+ZX5}@D DDB;~ "@G@}@}#{@Total interest paid$0e~@DDDij{> " /      """)))UUUMMMBBB999|PPMETA   PRINTDh CompObjjfObjInfol3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-- !-- !-  - ! -KK- !K-- !-- !-'- Arial--"Systemn-'-- Arial-  2  Price of car 2 $20,0002  Down payment   2 $5,0002 #Amount financed 02 #$15,000%2 4Annual interest rate 2 48.50% "2 ENumber of payments    2 E362 gMonthly payment  t2 g$473.51$2 xTotal interest paid2 x $2,046.47--4 '1U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial- 2  Price of car   *2 $20,000 2 8 Down payment $ ^2 8$5,000 2 l Amount financed$ 2 l$15,000 %2 Annual interest rate    2 8.50% %"2 Number of payments$  $  2 g362 < Monthly payment#   $ b2 <$473.51 $2 p Total interest paid     2 p $2,046.47  -'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrighteChris AlbrightMicrosoft ExcelSummaryInformation(mDocumentSummaryInformation8p_998994230 F]Q]QOle t՜.+,08@ \d l Indiana University Sheet1  WorksheetsLh.O  =B= PIC uLBook w META  PRINT=\ <X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *   GSheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U >  h.      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial---4 '0U A     """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial--'- -4'CompObjfObjInfoSummaryInformation(DocumentSummaryInformation8 FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qOh+'008PhChris AlbrightChris AlbrightMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  Worksheets)F! _910774498Lh.O  =B= =\ <X@"1oArial1oArial1oArial1_998994229 F]Q]QOle 9PIC LBook #       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklnqrtuvxyz{|}~oArial1oArial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  #  [Sheet1 =  dMbP?_*+%&APage &PMHP LaserJet IIP@g,,@MSUDHP LaserJet IIPd "d,,??U bb&WWbbPValue 1Value 2 SumProduct@$@!1@ %ՁQ@ DD@@!@ %Ձ(@ DD@@!"@ %Ձ2@ DD@@!@ %Ձ@ DD@"@!(@ %Ձ;@ DD@@!"@ %Ձ4@ DD @@!$@ %Ձ0@ DD@?!@ %Ձ@ DDH^^^^^^^>  h.     META PRINTGt CompObjmfObjInfoo """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -   "- "- !-- !-'-  -- !-""- !"-33- !3-DD- !D-UU- !U-ff- !f-ww- !w-- !-- !-- !-@@- !@-- !-- !-- !-@@- !@-- !-- !-'- Arial--"Systemn-'-- Arial-  2 Value 1 2 RValue 2  2 Sum  2 Product  2 77 2 p10 2 17 2 70 2 #74 2 #w3 2 #7 2 #12 2 476 2 4w3 2 49 2 418 2 E72 2 Ew3 2 E5 2 E6 2 V73 2 Vw9 2 V12 2 V27 2 g74 2 gw5 2 g9 2 g20 2 x78 2 xw2 2 x10 2 x16 2 76 2 w1 2 7 2 6--4 '0U      """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  '  ' '  Arial-"Systemn-'-  Arial- 2 >Value 1  2 Value 2   2 Sum$2 Product 2 87 2 8p10 2 8B17 2 870 2 l4 2 l3 2 lY7 2 l12 2 6 2 3 2 Y9 2 18 2 2 2 3 2 Y5 2 +6 2 3 2 9 2 B12 2 27 2 <4 2 <5 2 <Y9 2 <20 2 p8 2 p2 2 pB10 2 p16 2 6 2 1 2 Y7 2 +6-'- -4' FMicrosoft Excel WorksheetBiff5Excel.Sheet.89qSummaryInformation(pDocumentSummaryInformation8s1TableaSummaryInformation(wOh+'008PhChris AlbrighteChris AlbrighteMicrosoft Excel՜.+,08@ \d l Indiana University Sheet1  WorksheetsOh+'0Dd z >  # A"22tm3cIqlyD&`!tm3cIqlyh FxڝOlTEo;KTI/V+p > ALL$\I%j^I5g=i"Gȉb"DL~~f{Cw||ͼ}f2*2puHdLkFS+kZ&Fֈ#+r'rt<jZ6Vښ&r_ 3>>n&''Ԕ6fڵ˴Z-377g׺\rZs]N˵}L~584INZOZzkgVvfujdþ]j:թuu\ɵ^FSC-jҏ>X:5Z~V4I%RgFO.?"n >C^*uu!2gיuN,]A&]/7̎#/F ZGIv\]%c&E "Cs Ȧx9e\ckH>A/ŹL߉3KeQ?,iN-vfiG''Gc̤u23G-꛳"~v_ޣOíe`éN;c*jr$O u_țȾ}Ov]|7"e<(7h׳iDd O >  # A"20pw#lM7-&`!0pw#lM7-\ @BAyxڝMh$E_O*_k6Bfn1f/B`AZD]U!ۂ(O{asr1` UwOM'/]f$QD`Cx h% U$Wk#id3cmy 0z-s>gISNqv{WX 366fĄ4fLMMlM6EݻfO65j=3?ؤgIŤ``q`` LJ)SFARtXt8txtMK-Z,Xjb,8 ,8  ,8 xPE^C.ONe Gǽ.G~G]sՠY4!eģ򣃂(xTC>9|BM35xĂtP  `5Ԃ4r[ąs!_*5p*5qšģ4hFNkX1/p|'7Y[[3fsso9::2'''cy[hx@^h5B+HTCx))Emz0aBJ$Et|يYv=W=MՋyuَsev.N4;<Μ;|gn4.IQ8ft5k]͊+֕V\KѵTZVkֵRq貵.[qEZkڈZFպ\ŵ][+y]I:թuu*ntuk]݊KD%uLi_ѵPZ:թuu*ntuk]_4I?'tJײUzI|󇟾<.guqrq]×Td0F y;[($DGٞ-kǙ6.kwf o:Sro:_ro:[ϖrg^lZ5_NupΖzpΜъv?ã[K'U/7SϴKكdX3I[3_Vfzߡ+M/.= :{QlDd O >  # A"2yArٸCq&`!yArٸC @BA|xڝOh\Eo3WSLڒS$Bڗz )h M5< Bʈ"*f 9P  Vvgyg7ߙe7ADHoEza0eٽTPeS&=͜0$Woԛzh4KCP 2###fttԌjjMV3fvvLOOntaȧ淝ͣG;o,8 ,8 ,8 ,8 ,8ρ8~)FARtXt8txtMK.\,Xrb,8 ,8  ,8 xPE^Z598;]fq=( ~ l>:(k݃jXsa=O!'<롁kC蠴šģDj4hm9΅TɁ>xPڎ-,8 ,8AS4tܽ9x=W\4feeŬum3c/yE mvZbJT{>Q ⩬4E,j[>FM:_衪+I|:]xg6c6y]kyZݓLE99ͳc']y;@qy_\N3I90NIFWU-JK]i5]s]RWeK]ZRJ]kE+uk#6J]W"3:I]誗W#F%I|2W+rb_5S)U/u Ft5J]ʇqwk>|w3jfiO*-^z_nyuu/̫^go~9yMhҍ%Qg3rs fџ<nݴ׳x٘-k\zD~+>->_<=/u_gmtVlWNT="L#wgb5s/gvﺧ3_r@H;  # A"2)Pq7t.ݐ&`!)Pq7t.&CfxڝOh\Et6Zr] H% b[q5n6!:$o= ֓m}1IАرcZʱ19==-k<ź>}#͟,U>|/ᦌP@( HA h`Ё tGC40qc"䏐?B#ɀ"@ `@ :P@d40Ѐ0 REZjQE@ `@ :P@HC h`2Ё0 40lsdƽF]5=l5 (q~`2ЁC 6Al>lM=5 `@ @)[td401tՐ['Q H1jWcЁ trj\ 5v_,rvvVɍ y-#||||;ۏ5~q2&=)& ( 8)yOiGQiOTqB$Vs+QWtjvQў茶4/^C1=WS:\;.pP'{|?{>mwM#$F$tUuUW]Q+ \BB\tRޥr]*pyZk-pK{uu׻.Agl:i6k3׵vk7׵EytyW-U \޵ \޵Jg^;~ӹ[ߟ&.ƋB5jCd]ɺ)*:9mݽ.f=||Ę f/1ޘEߵz |O\n-,WTkڜhq5z1WoVZFZrf}ռRYklU&qLb׋?һݑL.ݨSRK9ؗr/`_ؗ, \nخ՛έ:;"3Ojm%gRX՗bS?-\$G?7P}D'&ƣSϐq['D=Ij?w)ѓYΤydIWݯvֺWNdyn{_Jׇx[OrkHνܩ7@'|^{} dDd A >  # A"2-zE'B@1V 3&`!zE'B@1VH >xڝOhTGo31ҤĕR,fƘc%XYuǖjId-^D `s9P笗P_?m^6l_7I" |7$2*5zыj*v&m-%3cr?'q:juV.?B Ȉ3frr޽4 ~n͑#GܜѯV8aɷGg{?]71YpAb11XpAA,q8`llLL1cFAb` ∃ FڨtmܵUkpUڟ?gƇK NW,T?ZqEYHuC3u;+u=*׵5E2IؽQz'W.,L}4_G1 kۉ3?]\Վ=EKv: K.tI=k~Bg}[>H[ӇJFo$֡fŞȮ^gS+_Lu^;\;3qV[S͸lc 2iǒS2-e9ge9e;jk:g6/gíqY}9Mkz\73uڢY;^wDH_.yB_5қX~Dd >  # A"2}eہ`5/rY&`!Qeہ`5/r ;@#xڵMhWϼܘcBa=1IVGܫ("4^*gMJlT[G}?k\fJY>2 ^QYwYmy,Vx8`~9_U>{>_#I/z8c{yKz7Q? QSt^Op8q%-u(2Z.yH;L'۬=SN5/~l-TcmdYO*҃RzɢJY+yF⏙F/Uj[3)>lT-]}dZ7̱=o.EDd a# >   # A "2VgmME=b&`!ZVgmME=| 9h$(xڕAlUǿ}@MOhUMޔŤ#Yp]ݦi^8p($&$/\8 ŋ<n9qhBLx{3ow]7ݍdXà( QTpΉb3u:bo5[Ɔl!DАUjrrRݻWe555:v옚QUNTkew?j*8 ,H"* ,8 Xp 4@,:h0`cbIȟ?!BD94@4:h0`t`5,8ԢESM-ZA DĠEC\9 y@ dž uqyMq-8 ^`Xti~tp yx,},5,=5X}A ,8 Xp 󵠃5=1/KG 5۰A ,8 Xp^sh4sp}qcީoe:sZ^^V.]R׮]SwQoVT=R?VO>UϞ=SqUqV#MތHEXYګM+D &_uZGU%sy²opӵ-J\,NmGE+rKr5K4N]Zc]*u{\Ip%}]Ixp::\Nkkǵ\+}]+=urzp]\7n">wzGδ]kW:v}]'z\k׵leNHAeiO=VΣxjzj8z^ejqrQn}4dc,P(ج.H-+m[KWYF57cgct-Xzt>uccon9deeZk.ƺވgxy،֗7J\.* x*+4s\GŠΗre8+:+|n߻R J\3F:|+OP'qӘ#13jKZڨrJ:f.+-JgL+x7*g?3Xߪ--6⺎b©lЫ^3v@$լW/1c;d[&eA]?sBDd! > ! # A!" 2-o۝};X7oon@DcDh@f&BPL^PX'֓z2XONvwwi]'$I155%ő#GD\333baaA?^9sF |] >}#o,~x辸u!9 Ѐ"@ H H$P@a(sD&B#ď? (H H$P@`(Ұ Ѐa hH"\$rE"\`( Ѐl@4`@v a h64b2PH\!/ yG66 G Zi@a2;`@ ;;qԀӨI&x /;`I$P@a(b؁d 쀍 %jL]/9h$#[cL v 0 ;@ 6T8j6s/lzluQqEĵkč7ĝ;wΎxx?O>Ϟ= ݼ-^ubZcɀt+t|v,`6K񚒬ne6o~0-̪ YUd$fg0 +hDm׵n{{Rb]-Vx6 'S)|>])b?X+ YL,~NNNNNNNNidwZqwJs՛WlZ/%SKFr?/հ[]1j{NDlZgK ]m:R:R:R:RAGJǕ ̳]`I2O躕g肍\&>ts/<އj^q\[ēp|1od5\y1r2d_1JJeүܤxw)X&K;]{ZM[ˉ,,U^Wy]Mf69絙xU1oHٕ|<_~^?n0bDdO > " # A""!2aMȏ]QVTd`!aMȏ]QVTP@BArxڝAhGJr]joOnYpS\F9hkK|1-P0Lzɡ-& /=s/ɇ)ԡjhKvg[=I}Dԓ#\=`[^I%7{E#]h)<]#yk$Fi6IrFW__CCCbxxXb(DTsssڵkbzzZ7!}-o,~?Y<~(XN4D$P@$a(R Ѐi؁ hQ@GbX?`@!@4`@v 0 ;@ Hll P@DH"D,H;@ H`(Ұ4`@ P@YKcM R+ĥB\&aB+h4@F5`6iYO#4փ h$|&M v 0 ;@ $X`llX[L90 Ɉvp׀&;@ Hll Tk6s &/lrlfw4*D^b{{[=qtt$ɉ8==/^/_ꌞ>X㍓'VșR@4Mx#)I]mZ`X *%`Z*:km{}\-|4;F e/)k];֩ڍ˥ Gsѹ?/i\6yILCﶓg|ҪU3UEGZU լUffUɪJV%3UQխ;-Tm9*eU*SՎUdvG3ygGڪU52U Gմfȳ(/KؗUdfUêjZU3SA*5G[-m$fi{\q~VVb ]y͸q=q=ۈgq|_8e1^u|:>OϾÎ9xN*˫uq2k~:z5;ԘV!iѮ'h(CnGc[g1ovG;skh öh:]~c}Kb_o{L.[dk1 b5u/^:V|xMZGTדkz=i52_qEKH_/#_Nk}DdO# > # # A#""2(=f;q;ƹ`!(=f;q;@BAh$xڥOhTGo31`R ڲ`i}ZRk W q' M7MLn/R= aC=RӃzsK=yJJ-L??oXo373/ 1$SKgFB+*9DRѮXJɕҶ܎h8ҏDȾY4Mi֔~},UcccjbbBݻWU*599ՙ3gԉ'ԑ#Gٳ|Ny]5$F ,8 Xp 49b&3~1nj+F ,8 Xp 4"\4hrE :h0`ht`4``qh`:?eLGq@ 熼 ✣F8Zpc蠓8tu9ZpΏg?%e|Ă>tpŠE ,8\y5sb0^;r,8 G t`5Ƙuѯku}jmmM]|Y]~]ݹsGݺuKݻwOݿ_=x@=zH=yD={Lƍoxc͗.;iUC%_ D'goEzJRSz*Kڴb#(R2|iJ>EY|zQ]i]j߫nGӊHyc>yLKs*g;\tm2܉K&4S=yQNyQ~&$r#~wҌ|L\BW%犃+.t9TpMr.tM\s5W˹փkеs] ++9fpm6suu3TدW•k36 ]9Dو\+mױ:V:s5Qj\jQM?i`߷x1IyZzP^T!_P9[b7gK4BǗfE\ӎ0N;JsRK%ew^עC^i?OsY.ŏa.br1.E1Gޘ㹘s1_Dݿ%fdi]WbLsRmq +jy~^[U˫+jyvVή,\/lob]e c*3>ZV@2~[^ Vp|_n i\w~d%uZjjs0󻺼\ Aԛh!y;y`6ȯeGId#Nee9byF^f_֖&&{sgtHIy?yyeg|)V/(2e=Z׊b|7C!jO,p'j+z/d'V; {eGo#]/T҉DdO > $ # A$"#2VIjy<C2C`!*Ijy<C@BAxڥOhW&l*9[ƅxPL⺧ƠG"z3M ћ <*C}^ROB)4CE_oޛ73b ̛}{&U_ 5|+03 DF|grUލ9_F :o~"z]LMM={F!'ıchZ? >~\y04j05íA#4R:Ft 0 H ɦ耍s̼ _1j=ЀIF Б[M :@ $P@6CCNf Y6klM?i8uzʕ+ƍݻÇѣGӧٳg_n͛_m'6okb`wssw)'Kz$50%̩ܽnN.h ‰G/'Zwù۟}ou/FW]ΎcT۾/mK?'Ɖm_gGTTG w5Qj\wE:]GJ]G %Z*u-\һdK\=ꕺzUZZp)R.Up[[W@ ~. ٯ~_p kP\wTPJz2RB~_p kPJz|LOϯ..'OOIJqb>Gk6nzF^.3|]׃|]C\_ ǐTc;A^fⲽI㮎k~\+zp]ݕvX> ϴ1d}B<-K V^7/U;Yؿ;Yؿؿ4؊gcߋVoeJ gsSz>w%=UՍcg[lUs++P8Gx's{b|$: g܊vX/i4l^4R3fmmN|Ffr5k{EYmk6t0N L.Cs6 ͹f3i3.C$ce45\VVi aGm$2n$j6C`Vst(peQגY:Thn sYͭLVsch6]>j3ɐ!+dj.ìM}ٳbnzvΪoK"DdO > % # A%"$2ubV8, NQ+`!IbV8, N@BAxڝAhTGǿĦX lx/RAx֌Z =l/7 xh UڃОzX/=9륞<RCyo<7ݝd2!2rtLd(LQRU1LrqmedFQ8"d׍O8Iדo=bxI355e֭[M6;v0faat:w:dʗ揻brbrXt8txt9S?~NQ,8 ,8 ,8 ,8AS4pAAҋK/^,XzA <(E ZLFk9]C.\e\kɵZr]JKKC.\\7FƐ+~_Ywuzkt\OT֕\!W7\FWu7֟ZI?i(3ӤTdV}OVW>e܆u} d33*j^=b*{iF^1G:ZZe(e&؅1*g%;7VZd|YPfj1;21{{={{}y5ԣgy>[eu>;}6fGK1lʾTe/ )}O~}ߑڮWQeL=̾?e?MOv}'c~Wo..D_'.D_ۗ|oO,?ZuZUkzկQ~en8^ kDdO > & # A&"%2I~6oJ;2`!I~6oJ; @BA{xڝ=hGލ,ۨr|* C=EV41$֘cHq)bL" &)\87)&\D 2)"ocjAO;f)1fwX 5k(iF&y77FdX&MFgοYGzŠWL5fbbLNNgϚVefffL1W\1f~~W=Wm?yrR$ <(#xPO,8a΁8Oɟ?%j$%xPK,8 8XpAAbŤFh"D5wRYtR[IN9x*|W݋'d+VڙN3zTT7u>'{ug]vwف:s</w:x.w;Xӄ$EMI? AW+ZVŕFWZJ+Zu-U\Ժ:.[W7nŵ]͊EuQt=u=Yׅ#ޯ'o\պzW?~%ID%uɁ}EBkEWիկuO$nyO%זo_+ nOfh}ƭ/N>cv6X׃F+3S/Ht㓵֦jfH153En~i?[ݸ2Hj0˴d.;,K m.rPfBFeT(/vT^. kr6*ʋBQT.w~PEݨl(KQyayJw\~Q9/ g7?/oDd- > ' # A'"&2#E7ggGg~ x1`!E7ggGg~ x1JxڕOhTG͚&1 -v]аsT⡇^ aH6WV`zhTl ҹmJ{z{sK=yDC)7f}E7|;y~l*D۩/$|@I%kq`xraݱoCѭuXw7&3A1<<,Į]DTbaaAϋGY >~\ܧ~Ǐ~*"@ (" ЀIā h@4`@q dž(㍉0#aH0q 0 8@ BH H#$P@61F (" /^$Hx"q 0 8@ H!$P@ h1f3Ɯ1pKa~_ǕML"UF;V=ЀiāG0 FMjl3Ic0 \ 8`I!$P@(bādq&%D}|Q{ cn6)ā h4@4`c0U<6ܛ~(ͦ׮]n<>=O<ϟ?/^_:yŮ&ӡ)Dԋz+K$(R4&LIET>.]Px .9k4۳'㼳m=C5kWݴү yk?ٕvKj;= S< #J8SURRE^ejΫ2Us)ՂW-dR*U2S%SW53U͔W]T]IWLJnxՍLՍ*^q^"=-]R/R%=-I::R;;)U&0R%=ɛiV-^$~nJC`+mё2?xE?tQ[OK2u5+)z ש4ӵ,y\h ׶ul_M8+К6Fremg[m֋窗Vj/<]rohS1vڽ~Z|VmyJv;WO/%ݛEYYPoRZ?]; 2{swϮyoϓd/8{z&LQm8g3_rq}C ^sp#};8 ( # A("'2dƠ y(rz,`R`!XdƠ y(rz,L&xڕOhTGefcj v]"MH"*kIɦĕU(A<*^C/=-Tйz PJ-Lfn{6|;o/k<GO> nJ)b1{~dK9oC֭kvfoh-Kb0aB;vͱYvIVVjӧ# |{  9b@  ;@  ;@  ;@ ǂ Å ?@8@8@H8@H8@m 6  q‘ G.p‘ $P8$ @  ;@HJǒ0@@y  *mp@a@˵HI v*R::x9$@ 6  8y$` $a `\\`JcM^ p$PB#U1 HIHMWG/JﱾsαVŮ_nݺ>|666Ǐٓ'OӧO٫Wׯznx>@ٛS} *ǞR_{MLw_tW1g̠Gۻ:a6}m}0y|D˹uv*Q?m=:\}u^mwN9lN9'U2t NUHUbTUSM;tj:sT\LŝxLrVS;zj=N%RU"TwRUwb*j{Vw1UƋT/M=iN9թTթjө6SU1Ր4U$:}(wo@?n4X[r=?{_f}oWb>;++^w^63evңqbӫ VA }C?cfߑRzewO׏tY7kYìdrks^i5_֮,MuwW.!!v\*:<xM4f^ F+KW$\T\FWoF4kKEsc]ǜZ^hb֘_@ջ݊jm3L%$E}ϋzwy"(VFݬ˻?`>/Nj剮hYFu-ƥEȯ֚gׂA;0bt y<-u=5O::KR%)Wg9sxul8^Nz K7b<=w##g\3J3v]ʼnĺθf: ɄL.~%a]];x];xYXgΟtga!: Z҉nJڕV)6] JGKbP2*(xg{} U34WO5WvESkjQ;7o1f짝5wB:Dd > ) # A)"(2oQ @=~Kh`!CQ @=~ BxڝAhTWϛd2V6P6JTF_uYIq"YKsmL$BlY prt㦛.MEkʅ *]Tp8y`—wy?{d < Z%U$dJRɞTnɽdюL7q$ r1X.&hU~\ 1flll߾uw^333cͱcѣG~l @?n>}`~I)΂I ba <(x0gClcROɟ?5 b <(xP,8 ;XpAM "Z,XjbR vX`q ⱃ א˓S;rwŜ6qS6x`AA;=|}<5<{j ֆ:2,8 ;XpAA;X ` 6r[ą}!_*50 bqa <(x`Sltܽc8 gṚd9yYZZ2/_6ׯ_77o6>4?6O<1Ϟ=3/^0/_4ܸ=hx@ISLTB+f%_lzJ/bgY6r*u:'Ily0z{U1W u׶޷ѽ;\,C;9m/,έ[u+oq%mhg؏%q}J{4*IQ(n|zU}4RUڧRTj&fJU3}*UTeTKQTZSDJjOʕ\fT,US%r)~^/y $>YS݉;;}jQU2UɚxT/US]++}QuTyi>Y=` ,J?T_dr228?w7Rhe>h42j]-o)O-,^o5ֺ<7 w2Oݱwdw{SX…V{εf[1V2P0q|:u~o6yo@?Z{ >RuDd > * # A*")2zq-P>si`!zq-P>s @(LxڕAhWǿ}1j66"0fc$Ԧm[e@ =Ex*k{l.P7fwgFo7f78OT8>=ߎW)E #] AoCmF_`3:ڢ߶_ç !6<}~ H@p  p  p  p J Ȱ0~0(p  p  p  p Jl@  ∅#X8bህ#HqH@6(@v   ^KbM9$p.qGm6(h  ;H8J^Oz=tL51H@8` c@@Rt,mX&BB 8(@\!رQ1 HIHM5R9p}Qs}]o;s `W\a7odV=xmooǏ'OgϞ/^/_29ݹsxR@E'q(U³t(=%$&Lw_tW1ykAaԥHm>˵{O]9=G9ds^kW7f‚?Uɴ.v4DN2)>UrU* WT3V5Ij>W5Rq*RmXFj#jUWsUWS*aU"W%R{Vu/Wu/r𞎟͌U+{%QjTE'VGƞωnσèn ]l4GrXC6V<l*}X%Y|#ꀝY̚ae}+7ގI}?>eOWѸX[Yn4 ͑Zoh1fѳleK&JGոt=m=I=oYkos>(f˨ь1<ᕫ]Ls4՘yq2)GogǯasDd > + # A+"*2rRq%jdsN`!FRq%jds xBxڝAhTWϛd2&Fm`m#EPD벒$EhTڀHI.EE ` "vѹkʅ *]Tjケq ߼{;97L"5C"[d"Pb\I*ٕݙ/HtkZ1X+&`]a3::jٵkff~~͙'NǏlS|ejy&8 zTKU>UUi*SFljO5U>*[}ըZ-UFR>*Wr}QuTuO=my $^P]jFj$)SulNFR>յV֧jGUTչmi[Y\8/?~G}!ߖE'J[%i~C3uu=魫ӧ{179ْGZY<ӘXgVj ʹ.BuV䑩SSSWgW./5Wk]#=&B 3!|wV|ٚͅYbZJYʳLU&ؗLcgl^Z8?l5V[+ F-F(D^lkVVfEQч>qc%܎b.ֺlX[c$֧G7v\Ss'/wviJG+ԹNMKuϧDVF]XX<ߧjQE QD2{'>zhXoȟa9(?/Z{ XMDdO > , # A,"+2htV2bh_O`!htV2bh_O @BAxڝ1h%U}M4†]REa_#)-Ő6 ^B 86!`nb0NSX W8~wfݼLV̽s{s̋|;+xF޽UnP?Ys7KSTU%ox9Ғ_^^Яh777_]]MC${G/ӟDPB|"(H@ $C  9A)_ AH"(H@ $C  % H@-Zj Ԃ"(H@$A A@ "\JNcH - # A-",2'3= f̉`!'3= f̉@BAxڝMhWϼܘS0V>% $PI"W kxx݈pwB? -M7]<7]4wӍnʅ FPj}7s7% sHd\[1 cqTU #[I+3ږ73sH|Wt^'z/{b8FGGĄ4SSSninVWWY\\4yښy _?l[)SO``q``  "^,Xzb :XpAA,:XpAXpAA<:8 ZJGǵ/G}G_\s֠Y4!eģꣃ(xTC=:zBO5=xꡁĂtP  `54j[ąu^*=p *=Sqšģ4hFMks E3ᾚo9t:ƍΝ;fww옇GǏOgϞ/^}'w~k 5hqQsgWo'a8)~wnS6G Ny7zUr$)g݋O2vcq{2z(ơǶԔg;ޫ2DzT3ݿ.Ӥ$EO4^bntk4FWZsDJkZFze6lՉNSs݌5.r5Vtm5jDukp$NՍn[s\7*irw*󊮥FRՍn[s*lSܟ޽yḛG,e|j}鵋W<Ё b_af+Qγjl\yro~ 1Ubfb&osW̻v6߿=9sXsTzmP>;#^-TL[l'ls)iEq"l?\tE4WdZLgf+`E|F'(:͎Tم~Ojt5_QgwTYE3;^(jOzRnVk^WϏSuL^7ؾw{e , H T ` lxExcel tools to demonstratexceChris Allbrighthrihri Normal.dotiFWI2IMicrosoft Word 10.0@@7hR޻@HSQ@HSQd՜.+,0 hDocumentSummaryInformation8DCompObjjp  Indiana University"Q{ Excel tools to demonstrate Title  FMicrosoft Word Document MSWordDocWord.Document.89q      !"#$J@J Normal x7$8$CJ_HaJmH sH tH DAD Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List Q*7DQ  w H  8 9 q QU <oi34]9:RSRu' ( @ A _ >?@@@@@ AA%B&B>B?B6CbC4DD-E.EFEGEEFrF(GrGsGGGGhHHHHHfKL,M-MEMHMYMNNcORQQQQQQMRFSSSSSTT'VVVVVWW'X(X@XAXyXYY[S\T\l\m\S0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000<;0@*S<;0<;0$,6<{D=KUM[=ahmyNQUYZ\^`bceghjlmopso'(81<FsP\gp9QVX[]_adfiknqrQW 4 6 /1:NP( < > !!!$$$~'''i+}++000111r444r555666999===@@@&B:BXT\h\j\_1_3_bbbeeegggoooHr\r^rv+v-vzzz{{{|||@TVz:NPQ:::::::::::::::::::::::::::::::::::::::::::::8@0(  B S  ?Q< IntroductionMoveToTopOfWorksheetEndArrowCombinations _910622874 SplitScreen _910629011 SelectRange _910629482 _910629588SelectMultipleRanges _910629985 CopyPaste _910630129 _910630158 _910630186 _910630209 _910630226CopyPasteSpecialValues _884684367CutPaste _910630265AbsoluteRelativeRefs _910630284 _910679617InsertRowsColumnsDeleteRowsColumns _910630335 _910630373 FillSeries _910630402SummationButton _910630425 RangeNames _910689458 _910689491 _910630568 _910630604 SumFunction CountFunctionAverageFunctionMaxMinFunctions _910630630 _910630713 _910683532 _910684233FunctionWizard _910685470 IF_Functions _910686987LookupFunctions _910766210 _910767017 DataTables _910768588 _910769781 _910770243 RecordMacro _910774498CustomizeToolbarDefaultNumberSheets* q :!$$~'(i++0111r56699==@&BH-MHMHMHMHMQSV(XAXT\m\ggoHrarvz|Y:SS  !"#$%&'()*+,-./0123456789:;* q :!$$~'(i++0111r56699==@&BH-MHMHMHMHMQSV(XAXT\m\ggoHrarvz|Y:SSChris AlbrightFWIK4>e,4oc*hhh^h`OJQJ^Jo(h88^8`OJQJ^Jo(oh^`OJQJ^Jo(h  ^ `OJQJ^Jo(h  ^ `OJQJ^Jo(ohxx^x`OJQJ^Jo(hHH^H`OJQJ^Jo(h^`OJQJ^Jo(oh^`OJQJ^Jo(@h8^8`.hhh^h`.h88^8`.hL^`L.h  ^ `.h  ^ `.hxLx^x`L.hHH^H`.h^`.hL^`L. =>e>eH>>e>>e>>eP?>e?>e(dK4o= @hh^h`OJQJ^Jo(T> @h8^8`.> @h8^8`.? @h8^8`.\? @h8^8`.? @h8^8`.4d @h8^8`.                  G !T B@hp LaserJet 1300 PCL 6Ne02:winspoolhp LaserJet 1300 PCL 6hp LaserJet 1300 PCL 6C odXer DINU"4IUPHdLetter [none] [none]Arial4Pd?DORPJR<Automatic>    j i k k m m hp LaserJet 1300 PCL 6C odXer DINU"4IUPHdLetter [none] [none]Arial4Pd?DORPJR<Automatic>    j i k k m m aI(:;Q`@`B`@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New;Wingdings"h:: dQ"dQ"$xx43H?G !Excel tools to demonstrateChris AllbrightFWI