logical functions
DESCRIPTION
Logical FunctionsTRANSCRIPT
Product Name Units Sold +/- % Decrease Flag
Chai 7% FALSE
Chang 2.9% FALSE
Aniseed Syrup 11.1% FALSE
Chef Anton's Cajun Seasoning 18.6% FALSE
Chef Anton's Gumbo Mix 14.1% FALSE
Grandma's Boysenberry Spread 12.0% FALSE
Uncle Bob's Organic Dried Pears -11.4% <<<<<<<<<<<
Northwoods Cranberry Sauce -2.6% <<
Mishi Kobe Niku -18.6% <<<<<<<<<<<<<<<<<<
Ikura 13.3% FALSE
Queso Cabrales 6.2% FALSE
Queso Manchego La Pastora 13.4% FALSE
Konbu 10.3% FALSE
Tofu 4.5% FALSE
Genen Shouyu -16.7% <<<<<<<<<<<<<<<<
Pavlova 12.7% FALSE
Alice Mutton 0.3% FALSE
Carnarvon Tigers -19.3% <<<<<<<<<<<<<<<<<<<
Teatime Chocolate Biscuits 8.1% FALSE
Sir Rodney's Marmalade 8.0% FALSE
Sir Rodney's Scones 6.8% FALSE
Gustaf's Knäckebröd -10.6% <<<<<<<<<<
Tunnbröd 14.0% FALSE
Guaraná Fantástica 16.9% FALSE
NuNuCa Nuß-Nougat-Creme 16.9% FALSE
Gumbär Gummibärchen -12.2% <<<<<<<<<<<<
Schoggi Schokolade 5.4% FALSE
Rössle Sauerkraut 1.9% FALSE
Thüringer Rostbratwurst 2.9% FALSE
Nord-Ost Matjeshering 3.7% FALSE
Gorgonzola Telino 17.0% FALSE
Mascarpone Fabioli 4.6% FALSE
Geitost 14.3% FALSE
Sasquatch Ale 1.0% FALSE
Steeleye Stout -17.6% <<<<<<<<<<<<<<<<<
Inlagd Sill 0.0% FALSE
Gravad lax 1.8% FALSE
Côte de Blaye 19.7% FALSE
Chartreuse verte 8.5% FALSE
Boston Crab Meat 12.1% FALSE
Jack's New England Clam Chowder -17.2% <<<<<<<<<<<<<<<<<
Singaporean Hokkien Fried Mee 5.4% FALSE
Ipoh Coffee -15.9% <<<<<<<<<<<<<<<
Gula Malacca 3.7% FALSE
Røgede sild -11.3% <<<<<<<<<<<
Spegesild 0.6% FALSE
Zaanse koeken 18.3% FALSE
Chocolade 12.2% FALSE
Maxilaku 5.0% FALSE
Valkoinen suklaa 15.5% FALSE
Manjimup Dried Apples 1.5% FALSE
Filo Mix 9.7% FALSE
Perth Pasties 18.3% FALSE
Tourtière 1.3% FALSE
Pâté chinois -3.8% <<<
Gnocchi di nonna Alice 10.9% FALSE
Ravioli Angelo 17.3% FALSE
Escargots de Bourgogne 9.5% FALSE
Raclette Courdavault 10.0% FALSE
Camembert Pierrot 13.2% FALSE
Sirop d'érable 10.3% FALSE
Tarte au sucre 15.1% FALSE
Vegie-spread -7.0% <<<<<<
Wimmers gute Semmelknödel 18.4% FALSE
Louisiana Fiery Hot Pepper Sauce 16.1% FALSE
Louisiana Hot Spiced Okra 2.3% FALSE
Laughing Lumberjack Lager -3.9% <<<
Scottish Longbreads 0.3% FALSE
Gudbrandsdalsost 11.0% FALSE
Outback Lager 2.5% FALSE
Fløtemysost 1.7% FALSE
Mozzarella di Giovanni 15.8% FALSE
Röd Kaviar -18.8% <<<<<<<<<<<<<<<<<<
Longlife Tofu 17.4% FALSE
Rhönbräu Klosterbier -10.8% <<<<<<<<<<
Lakkalikööri 2.5% FALSE
Original Frankfurter grüne Soße 16.8% FALSE
Product Name Units Sold +/- % Decrease Flag
Chai 7%
Chang 2.9%
Aniseed Syrup 11.1%
Chef Anton's Cajun Seasoning 18.6%
Chef Anton's Gumbo Mix 14.1%
Grandma's Boysenberry Spread 12.0%
Uncle Bob's Organic Dried Pears -11.4% <<<<<<<<<<<
Northwoods Cranberry Sauce -2.6% <<
Mishi Kobe Niku -18.6% <<<<<<<<<<<<<<<<<<
Ikura 13.3%
Queso Cabrales 6.2%
Queso Manchego La Pastora 13.4%
Konbu 10.3%
Tofu 4.5%
Genen Shouyu -16.7% <<<<<<<<<<<<<<<<
Pavlova 12.7%
Alice Mutton 0.3%
Carnarvon Tigers -19.3% <<<<<<<<<<<<<<<<<<<
Teatime Chocolate Biscuits 8.1%
Sir Rodney's Marmalade 8.0%
Sir Rodney's Scones 6.8%
Gustaf's Knäckebröd -10.6% <<<<<<<<<<
Tunnbröd 14.0%
Guaraná Fantástica 16.9%
NuNuCa Nuß-Nougat-Creme 16.9%
Gumbär Gummibärchen -12.2% <<<<<<<<<<<<
Schoggi Schokolade 5.4%
Rössle Sauerkraut 1.9%
Thüringer Rostbratwurst 2.9%
Nord-Ost Matjeshering 3.7%
Gorgonzola Telino 17.0%
Mascarpone Fabioli 4.6%
Geitost 14.3%
Sasquatch Ale 1.0%
Steeleye Stout -17.6% <<<<<<<<<<<<<<<<<
Inlagd Sill 0.0%
Gravad lax 1.8%
Côte de Blaye 19.7%
Chartreuse verte 8.5%
Boston Crab Meat 12.1%
Jack's New England Clam Chowder -17.2% <<<<<<<<<<<<<<<<<
Singaporean Hokkien Fried Mee 5.4%
Ipoh Coffee -15.9% <<<<<<<<<<<<<<<
Gula Malacca 3.7%
Røgede sild -11.3% <<<<<<<<<<<
Spegesild 0.6%
Zaanse koeken 18.3%
Chocolade 12.2%
Maxilaku 5.0%
Valkoinen suklaa 15.5%
Manjimup Dried Apples 1.5%
Filo Mix 9.7%
Perth Pasties 18.3%
Tourtière 1.3%
Pâté chinois -3.8% <<<
Gnocchi di nonna Alice 10.9%
Ravioli Angelo 17.3%
Escargots de Bourgogne 9.5%
Raclette Courdavault 10.0%
Camembert Pierrot 13.2%
Sirop d'érable 10.3%
Tarte au sucre 15.1%
Vegie-spread -7.0% <<<<<<
Wimmers gute Semmelknödel 18.4%
Louisiana Fiery Hot Pepper Sauce 16.1%
Louisiana Hot Spiced Okra 2.3%
Laughing Lumberjack Lager -3.9% <<<
Scottish Longbreads 0.3%
Gudbrandsdalsost 11.0%
Outback Lager 2.5%
Fløtemysost 1.7%
Mozzarella di Giovanni 15.8%
Röd Kaviar -18.8% <<<<<<<<<<<<<<<<<<
Longlife Tofu 17.4%
Rhönbräu Klosterbier -10.8% <<<<<<<<<<
Lakkalikööri 2.5%
Original Frankfurter grüne Soße 16.8%
Salesperson Target Sales Actual Sales Pct +/- Bonus
Nancy Davolio 250,000$ 259,875$ 4.0% 1,000$
Andrew Fuller 275,000$ 293,827$ 6.8% 1,000$
Janet Leverling 300,000$ 347,119$ 15.7% 10,000$
Margaret Peacock 200,000$ 189,345$ -5.3%
Steven Buchanan 200,000$ 209,283$ 4.6% 1,000$
Michael Suyama 225,000$ 222,384$ -1.2%
Robert King 300,000$ 299,550$ -0.2%
Laura Callahan 225,000$ 239,990$ 6.7% 1,000$
Anne Dodsworth 225,000$ 256,919$ 14.2% 10,000$
Poll Results — Question #1
Key: 1 = Strongly Disagree
2 = Disagree
3 = Neutral
4 = Agree
5 = Strongly Agree
Subject ID Age Response 18-34 35-49 50-64 65+
1 19 4 4
2 23 5 5
3 38 3 3
4 44 4 4
5 51 2 2
6 20 4 4
7 65 1 1
8 49 4 4
9 60 3 3
10 69 2 2
2004 EXPENSES
Advertising $4,600
Rent $2,100
Supplies $1,300
Salaries $16,000
Utilities $500
TOTAL $24,500 24500
2005 EXPENSES
Advertising $4,600
Rent $2,100
Supplies $1,300
Salaries
Utilities $500
TOTAL 8500
Bond Code Maturity Date Maturity Value Year Total Value
563469EM3 Sep 01, 2009 14,000$ 2009 36,000$
642866EX1 Jun 15, 2010 16,000$ 2010 46,000$
683234NX2 Nov 19, 2010 20,000$ 2011 45,000$
78009ZAE9 Apr 12, 2011 20,000$ 2012 45,000$
683234PQ5 Dec 02, 2009 10,000$ 2013 37,000$
07813ZAN4 Apr 12, 2009 12,000$ 2014 35,000$
135110AA2 Jun 30, 2012 15,000$ Total 244,000$
40975TAA1 May 31, 2011 10,000$
013014BS3 Jun 01, 2012 15,000$
683234NX2 Nov 19, 2010 10,000$
626209GC8 Jun 01, 2011 15,000$
683234RX8 Dec 02, 2014 20,000$
110709DG4 Aug 23, 2013 17,000$
110709DF6 Jun 09, 2014 15,000$
642866FB8 Dec 12, 2012 15,000$
110709DG4 Aug 23, 2013 20,000$
Maturity TableInvestment Maturity Dates and Future Values
Array Lookup
Account Number: 09-2111
In the List? TRUE First Row: 14
How Many Times? 2 Last Row: 22
Account Name
Account
Number
Invoice
Number
Invoice
Amount Due Date Date Paid
Days
Overdue
Emily's Sports Palace 08-2255 117316 1,584.20$ 22-Apr-04 55
Refco Office Solutions 14-5741 117317 303.65$ 23-Apr-04 54
Brimson Furniture 10-0009 117321 2,144.55$ 29-Apr-04 48
Katy's Paper Products 12-1212 117322 234.69$ 30-Apr-04 47
Door Stoppers Ltd. 01-0045 117324 101.01$ 6-May-04 41
Voyatzis Designs 14-1882 117325 1,985.25$ 6-May-04 41
Brimson Furniture 10-0009 117327 1,847.25$ 12-May-04 35
Door Stoppers Ltd. 01-0045 117328 58.50$ 13-May-04 34
O'Donoghue Inc. 09-2111 117329 1,234.56$ 14-May-04 33
Refco Office Solutions 14-5741 117330 456.78$ 14-May-04 33
Renaud & Son 07-0025 117331 565.77$ 19-May-04 30
Simpson's Ltd. 16-6658 117332 898.54$ 18-May-04 31
Door Stoppers Ltd. 01-0045 117333 1,685.74$ 22-May-04 27
Renaud & Son 07-0025 117335 3,005.14$ 24-May-04 25
Rooter Office Solvents 07-4441 117336 78.85$ 26-May-04 23
Emily's Sports Palace 08-2255 117337 4,347.21$ 29-May-04 20
O'Donoghue Inc. 09-2111 117338 2,144.55$ 29-May-04 20
Brimson Furniture 10-0009 117339 1,234.69$ 30-May-04 19
Katy's Paper Products 12-1212 117340 1,157.58$ 1-Jun-04 17
Real Solemn Officials 14-1882 117342 2,567.12$ 8-Jun-04 10
Refco Office Solutions 14-5741 117343 1,234.56$ 13-Jun-04 5
Brimson Furniture 10-0009 117344 875.50$ 13-Jun-04 5
Chimera Illusions 02-0200 117345 588.88$ 14-Jun-04 4
Meaghan Manufacturing 12-3456 117352 898.54$ 28-Jun-04 43
Page 9
Accounts Receivable Aging
Date: 21-Jun-04
Past Due (Days):Account
Number
Invoice
Number
Invoice
Date Due Date
Past
Due
Amount
Due 1-30 31-60
07-0001 1000 17-Apr-04 Monday May 17, 2004 35 2433.25 2433.25
07-0001 1025 5-May-04 Friday Jun 4, 2004 17 2151.20 2151.20
07-0001 1031 12-May-04 Friday Jun 11, 2004 10 1758.54 1758.54
07-0002 1006 27-Feb-04 Monday Mar 29, 2004 84 898.47
07-0002 1035 12-May-04 Friday Jun 11, 2004 10 1021.02 1021.02
07-0004 1002 17-Apr-04 Monday May 17, 2004 35 3558.94 3558.94
07-0005 1008 17-Feb-04 Thursday Mar 18, 2004 95 1177.53
07-0005 1018 4-May-04 Thursday Jun 3, 2004 18 1568.31 1568.31
08-0001 1039 15-Jan-04 Monday Feb 16, 2004 126 2958.73
08-0001 1001 17-Apr-04 Monday May 17, 2004 35 3659.85 3659.85
08-0001 1024 5-May-04 Friday Jun 4, 2004 17 565.00 565.00
Page 10
Accounts Receivable Aging
61-90 91-120 Over 120
898.47
1177.53
2958.73
Page 11