9 6 1579 16 16 158 16 27 16 08 16 19 1588 16 01 1579

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 5.59 15.82 16 .23 15.9 5 15.9 5 16 .04 15.4 3 15.6 3 15.87 15.6 7 15.77 15.53 15.22 15.23 14 .83 14 .59 14 .34 14 .31 14 .4 1 14 .52 15.4 9 15.4 9 15.6 6 15.9 16 .28 16 .29 15.88 16 .39 16 .02 15.9 8 16 .17 16 .34 16 .56 16 .4 1 16 .82 17.22 17.74 17.9 2 17.7 17.52 17.76 17.6 18.05 18.24 18.23 18.33 18.54 18.4 18.56 18.6 1 18.52 18.4 2 18.6 9 18.82 18.82 18.6 2 18.52 18.8 18.74 18.7 18.58 18.39 18.4 5 18.4 3 18.6 9 18.72 18.85 18.9 1 18.8 18.56 18.74 18.6 2 18.4 4 18.6 8 18.9 5 19 .08 19 .06 19 .15 19 .08 18.9 1 19 18.89 18.9 6 18.81 18.6 9 18.26 18.6 1 18.87 18.88 18.9 7 19 .4 2 19 .6 2 19 .9 9 20.03 20.04 19 .9 19 .9 19 .6 8 19 .6 1 19 .88 19 .87 19 .84 19 .78 19 .9 19 .85 19 .79 19 .57 19 .33 19 .04 18.58 18.85 19 .14 18.72 18.74 19 .18 18.9 4 18.9 8 19 .2 18.9 1 19 .37 19 .29 19 .4 5 19 .6 1 19 .4 1 19 .6 3 19 .6 19 .4 4 19 .18 19 .16 19 .09 18.75 18.9 3 18.85 18.4 4 18.24 18.84 18.72 18.79 18.9 6 19 .02 19 .02 19 .09 19 .04 19 .19 18.88 18.9 3 18.38 18 18.09 18.72 18.84 19 .04 18.9 5 19 .32 19 .21 19 .55 19 .83 19 .58 19 .83 19 .9 3 19 .53 19 .81 19 .52 19 .8 20.13 20.2 20.84 20.4 9 20.4 3 20.33 20 20.04 19 .6 2 19 .6 8 19 .4 4 19 .77 19 .59 19 .72 19 .84 19 .8 19 .87 20.09 19 .9 7 20 20.56 20.9 2 20.8 20.75 On Your Own 4 Please perform the following: Write a function to populate the Category column in the Transactions Table below. Note: the aging date cell is named date_asof Note: the categories Table is named tbl_cat Note: the transaction Table is named tbl_data Settings Aging date 3/31/2014 Categories Days Open Category 0 0-30 31 31-60 61 61-90 91 91+ Transactions ID CustID 45469 UPS102 50716 SAT017 46060 RAM101 46756 QEX711 48250 HBC160 50520 DOP090 46136 QCM550 50624 PBS408 49109 PBS408 45192 LHC001 47507 RAM101 48845 GRA182 50168 LHC001 49124 HBC160 46492 QCM550 50054 QCM550 50614 ATM201 45667 STR202 49561 SAT017 45379 DIG290 50313 NEW011 45419 POL412 50087 RAM101 46556 GRA182 47934 EBD220 49417 QCM550 Date 2/8/2014 2/27/2014 9/15/2013 1/1/2014 8/17/2013 8/6/2013 3/18/2014 2/28/2014 10/12/2013 2/10/2014 2/18/2014 2/26/2014 3/6/2014 10/11/2013 2/6/2014 2/1/2014 9/23/2013 11/2/2013 9/28/2013 3/24/2014 10/19/2013 3/6/2014 9/23/2013 3/9/2014 11/26/2013 3/31/2014 Amount Category 12196 10249 11529 4512 6016 13602 6590 3700 4275 7683 19364 1693 12807 14712 7067 18084 2277 19343 8767 8369 2766 18004 4240 6311 10328 1968 On Your Own 5 Please perform the following: Name the Aging date input cell: date_aging. Ensure the user enters a date greater than...
View Full Document

Ask a homework question - tutors are online