tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 128828d1321299203-vlookups-with-multiple-conditions-tracker-template
Sheet: Summary

2012 Tracker
All Other
POWDERS
 |  |  | GROSS SALES
Chocolate Powder 1 |  |  | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
Chocolate Powder 2
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Chocolate Powder 3
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Chocolate Powder 4
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
BARS
Chocolate Bar 1 |  |  | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 34
Chocolate Bar 2
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Chocolate Bar 3
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Chocolate Bar 4
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Chocolate Bar 5
 | 2012 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Plan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 LBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 S&OP |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 759842d1639757411-error-trapping-if-and-multiple-cells-must-all-have-error-sample-12-1-1-1-
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  |  | Expected Result
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | blank
5 | 5 | 5 | 5 | 5 |  | 5 | 5 | blank
 |  |  |  |  | asdf | 5 |  | blank
 |  |  |  |  |  |  |  | error
 |  |  |  |  |  |  |  | error
asdf | asdf | asdf | asdf | asdf | asdf | asdf | asdf | blank
asdf | asdf | asdf | af | adf | 0 | asdf | asdf | blank
0 | 0 | 0 | 0 | 0 | 0 | asdf |  | blank
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | blank
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | blank
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | blank
Spreadsheet: 7af1aebb-de05-4c0a-b920-4415cc11dd60
Sheet: BAd 363

COURSE ASSESSMENT MATRIX
COURSE: BAd 363 Business Finance
Objective | Assessment Method | Desired Result | Corrective Action
Analyze financial statements | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Construct financial forecasts for an organization | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Analyze a firm's use of combined leverage | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Solve problems using time value of money concepts | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Manage working capital | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Analyze long-term debt financial alternatives | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Determine optimal capital structure | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Spreadsheet: michael_maggi__26456__NYMEXWEEKLY
Sheet: SC

Week Ending: | 2001-11-16 00:00:00
 | Futures Settlement Prices
 | BRENT CRUDE OIL |  |  |  |  | Contract Symbol:  SC
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-11-12 00:00:00 | 2001-11-13 00:00:00 | 2001-11-14 00:00:00 | 2001-11-15 00:00:00 | 2001-11-16 00:00:00 | Interest
 | 2001-12-01 00:00:00 | 20.36 | 20.78 | 18.85 | 17.31 | 17.31 | 371
 | 2002-01-01 00:00:00 | 20.58 | 20.98 | 19.17 | 17.32 | 17.76 | 221
 | 2002-02-01 00:00:00 | 20.59 | 20.94 | 19.29 | 17.47 | 17.87 | 60
 | 2002-03-01 00:00:00 | 20.59 | 20.9 | 19.35 | 14.57 | 17.99 | 17
 | 2002-04-01 00:00:00 | 20.59 | 20.88 | 19.42 | 17.68 | 18.12 | 10
 | 2002-05-01 00:00:00 | 20.59 | 20.86 | 19.48 | 17.77 | 18.18 | 70
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 2227
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Brent Crude Oil
 | 5 Day Hist. Vol. |  |  | N\A
 | 20 Day Hist. Vol. |  |  | N\A
 | Implied Volatility-Options
 |  |  |  | Brent Crude Oil
 | At the Money Call & Put
 |  |  |  | N\A
 | MON | TUE | WED | THUR | FRI | Total
Volume | 345 | 135 | 783 | 44 | 0
Spreadsheet: 753694d1635650925-search-for-issue-numbers-comics-sample
Sheet: Sheet1

Superman | Type comic name in A1, search across     Row 1 for that title. | The Incredible Hulk | Wolverine | Superman
List |  | 46 | 85 | 77
all | List all issue numbers for that title starting in A2, going down. | 59 | 111 | 94
issue |  | 74 | 352 | 102
numbers |  | 98 | 389 | 111
in |  | 105 |  | 118
this column |  |  |  | 126
 |  |  |  | 127
Spreadsheet: 881031d1728931691-if-formula-not-working-shipping-template
Sheet: Worksheet

 | Shipping Template - Exports |  |  |  |  | Cases per row |  |  | 11
 |  |  |  |  |  | $CAD to $USD |  |  | 1.3
 |  |  |  |  |  | $CAD to £GBP |  |  | 1.5
 |  |  | Units |  |  |  |  | Weight |  |  |  | DIMS |  |  |  |  |  |  |  |  | Value |  |  |  |  |  | Customs
 |  | Item | Qty of  Cases | Items per unit | Items Per Case | Total Items per Case | Item Total | Case  Weight |  | Total Weight All Cases |  | Case |  |  |  |  |  | Num of  Rows | Total Height  All Cases |  | Unit Value |  |  | Total Value |  |  | HS Code
 |  |  |  |  |  |  |  | ls | Kg | lbs | Kg | Inches |  |  | CM |  |  |  | Inch | CM | $CAD | $USD | £GBP | $CAD | $USD | £GBP | US | GB
 | 1 | Widget A | 66 | 1 | 12 |  |  | 12.41 | 5.63 |  |  | 14 | 11 | 8 |  |  |  |  |  |  | 10.2 |  |  |  |  |  | 3926.90.9985 | 3926 9097 90
 | 2 | Widget B | 20 | 2 | 6 |  |  |  |  |  |  | 14 | 11 | 8 |  |  |  |  |  |  | 20.4
 | 3 | Widget C |  |  |  |  |  |  |  |  |  | 14 | 11 | 8 |  |  |  |  |  |  | 12.6
 | 4 | Widget D |  |  |  |  |  |  |  |  |  | 14 | 11 | 8
 | 5 | Widget E
 | 6 | Widget F
 | 7 | Widget G
 | 8
 | 9
 | 10 | pallet |  |  |  |  |  | 25 |  |  |  | 48 | 40 | 6 |  |  |  |  | 6
Spreadsheet: 864001d1711373638-if-criteria-not-met-then-another-list-filter-mutiple-columns-based-on-criteria-6
Sheet: Sheet1

 |  | State | Color 1 | Color 2 | Color 3 | Color 4 |  | Colors if State selected |  | Colors (ALL) |  | Desired Outcome
 |  | GEORGIA | Red | Green |  |  |  |  |  | beige |  | Black
GEORGIA |  | GEORGIA | Yellow | Green |  | Gray |  | Gray |  | Black |  | Gray
 |  | MARYLAND |  | [NAME] |  |  |  | Green |  | blue |  | Green
 |  | GEORGIA | Gray | Yellow |  | Black |  | Orange |  | blue violet |  | Orange
 |  | FLORIDA |  | Maroon |  | Green |  | Red |  | [NAME] |  | Red
 |  | GEORGIA | Orange | Red | White |  |  | White |  | crimson |  | White
 |  | OHIO | Blue | Gray | Yellow | Gray |  | Yellow |  | [NAME] |  | Yellow
 |  |  |  |  |  |  |  |  |  | gold
 |  |  |  |  |  |  |  |  |  | gray
 |  |  |  |  |  |  |  |  |  | green
 |  |  |  |  |  |  |  |  |  | indigo
 |  |  |  |  |  |  |  |  |  | khaki
 |  |  |  |  |  |  |  |  |  | lavender
 |  |  |  |  |  |  |  |  |  | lime green
 |  |  |  |  |  |  |  |  |  | magenta
 |  |  |  |  |  |  |  |  |  | maroon
 |  |  |  |  |  |  |  |  |  | navy blue
 |  |  |  |  |  |  |  |  |  | olive
 |  |  |  |  |  |  |  |  |  | orange
 |  |  |  |  |  |  |  |  |  | pink
 |  |  |  |  |  |  |  |  |  | plum
 |  |  |  |  |  |  |  |  |  | purple
 |  |  |  |  |  |  |  |  |  | red
 |  |  |  |  |  |  |  |  |  | salmon
 |  |  |  |  |  |  |  |  |  | silver
 |  |  |  |  |  |  |  |  |  | sky blue
 |  |  |  |  |  |  |  |  |  | teal
 |  |  |  |  |  |  |  |  |  | violet
 |  |  |  |  |  |  |  |  |  | white
 |  |  |  |  |  |  |  |  |  | yellow
Spreadsheet: 77824d1278328431-random-number-from-table-random20test
Sheet: TEST

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 2 |  |  | 5 |  |  |  | 9
 | 2 |  |  | 5 |  |  | 8
 | 2 |  |  |  | 6
 |  |  |  |  | 6 | 7
 |  | 3 | 11 |  | 6 | 7
2 |  | 3 |  |  | 6 | 7
 |  | 3 |  |  |  | 7
 |  |  |  |  |  |  |  |  | 10
1st [NAME]:J9 |  |  | 2nd [NAME]:J9 |  |  | 3rd [NAME]:J9
 | 8 |  | 6 |  |  | 11 |  | ok
Spreadsheet: 132934d1324041695-if-or-and-formula-issue-sample_iforand
Sheet: Quota (2012)

Period Bonus & Commission Calculator (Re-entering Extended Ramp-up Plan)
Note: Fill in the Yellow Areas Only |  |  |  |  |  |  |  |  |  |  |  | Sales Rep: | <NAME>
FYI: Your tenure selection sequence is out of synch (see red cell below).
PERIOD INFORMATION |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
# of Weeks in Period |  | 0 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 5
12 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Effective tenure (Months) |  | 0 | 12+ | 12+ | 12+ | 12+ | 12+ | 12+ | 12+ | 12+ | 12+ | 12+ | 12+
Avg. NAR / week quota |  | 0 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Spreadsheet: 47107d1246017352-sum-of-income-by-month-final-file
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Sum of each month only if there is a complete date.
 |  |  | Order No. | Order Amount £ | Date Ordered | Date Complete |  |  | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00
 |  |  | 1 | 50 | 2009-01-01 00:00:00 | 2008-02-01 00:00:00 |  |  | 50 | 45 | 0 | 112 | 80 | 222
 |  |  | 2 | 60 | 2009-01-03 00:00:00 |  | REVISED FORMULA |  | 50 | 45 | 0 | 112 | 80 | 222
 |  |  | 3 | 112 | 2009-01-22 00:00:00 | 2009-02-22 00:00:00
 |  |  | 4 | 35 | 2009-02-02 00:00:00 | 2009-03-02 00:00:00
 |  |  | 5 | 45 | 2009-02-13 00:00:00 | 2008-03-01 00:00:00
 |  |  | 6 | 50 | 2009-03-03 00:00:00 | 2009-04-03 00:00:00
 |  |  | 7 | 60 | 2009-03-05 00:00:00 | 2009-04-05 00:00:00
 |  |  | 8 | 112 | 2009-03-12 00:00:00 | 2009-04-12 00:00:00
 |  |  | 9 | 35 | 2009-03-25 00:00:00
 |  |  | 10 | 45 | 2009-03-27 00:00:00
Spreadsheet: 740688d1626456721-wanting-the-unit-type-of-the-set-of-data-to-be-copied-next-to-all-of-the-quantities-example3-edit
Sheet: Sheet1

Project No | Year | Item No | Item No | Item Description | Item Description/Job | Date | Unit/Quantity |  | Bid
=============== | 2015 | 203-01597 |  |  | Potholing |  | Hour |  | ==============
STA 340A-017 | 2015 |  |  |  | Job 1 | 05/21/15 | 50 |  | 200
ER R400-325 | 2015 |  |  |  | Job 2 | 05/28/15 | 40 |  | 225
NHPP 076A-008 | 2015 |  |  |  | Job 3 | 05/28/15 | 100 |  | 185
FSA0703-413 | 2015 |  |  |  | Job 4 | 05/28/15 | 10 |  | 175
FSA145A-057 | 2015 |  |  |  | Job 5 | 05/28/15 | 40 |  | 350
NH0341-081 | 2015 |  |  |  | Job 6 | 06/04/15 | 80 |  | 200
FSA 0703-411 | 2015 |  |  |  | Job 7 | 06/11/15 | 40 |  | 250
SHE165A-012 | 2015 |  |  |  | Job 8 | 06/11/15 | 6 |  | 200
ITSSW01-536 | 2015 |  |  |  | Job 9 | 06/18/15 | 200 |  | 150
SHE151A-008 | 2015 |  |  |  | Job 10 | 06/25/15 | 40 |  | 390
SHE172A-018 | 2015 |  |  |  | Job 11 | 06/25/15 | 20 |  | 250
=============== | 2015 | 202-00001 |  |  | Rem Structure |  | Each |  | ==============
CR600-409 | 2015 |  |  |  | Job 1 | 04/30/15 | 6 |  | 500
IM0762-049 | 2015 |  |  |  | Job 2 | 05/07/15 | 169 |  | 350
SHE172A-018 | 2015 |  |  |  | Job 3 | 06/25/15 | 1 |  | 1000
Spreadsheet: 887585d1737825155-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Nov

 |  |  | 2025-10-27 00:00:00 | 2025-10-28 00:00:00 | 2025-10-29 00:00:00 | 2025-10-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-01 00:00:00
 |  |  | 2025-11-03 00:00:00 | 2025-11-04 00:00:00 | 2025-11-05 00:00:00 | 2025-11-06 00:00:00 | 2025-11-07 00:00:00 | 2025-11-08 00:00:00
 |  |  | 2025-11-10 00:00:00 | 2025-11-11 00:00:00 | 2025-11-12 00:00:00 | 2025-11-13 00:00:00 | 2025-11-14 00:00:00 | 2025-11-15 00:00:00
 |  |  | 2025-11-17 00:00:00 | 2025-11-18 00:00:00 | 2025-11-19 00:00:00 | 2025-11-20 00:00:00 | 2025-11-21 00:00:00 | 2025-11-22 00:00:00
 |  |  | 2025-11-24 00:00:00 | 2025-11-25 00:00:00 | 2025-11-26 00:00:00 | 2025-11-27 00:00:00 | 2025-11-28 00:00:00 | 2025-11-29 00:00:00
 |  |  | 2025-12-01 00:00:00 | Notes
Spreadsheet: 774564d1648546512-returning-the-average-of-cells-that-match-a-criteria-test-4-
Sheet: Sheet2

 | Role/Department: | Role 1 | Role 1 | Role 3 | Role 2 | Role 1 | Role 3 | Role 4 | Role 1
 | Individual Initials | Initial 1 | Initial 2 | Initial 3 | Initial 4 | Initial 5 | Initial 6 | Initial 7 | Initial 8
 | Test 1 | 2 | 1 | 1 | 2 | 2 | 1 | 1 | 1
 | Test 2 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1
 | Test 3 | 2 | 1 | 1 | 1 | 4 | 1 | 1 | 2
 | Test 4 | 1 | 1 | 1 | 1 | 5 | 1 | 1 | 1
 | Test 5 | 1 | 1 | 1 | 1 | 5 | 1 | 1 | 1
Spreadsheet: 489465d1479272896-take-data-from-one-column-and-add-to-an-existing-column-take-data-from-one-column-and-add-to-an-existing-column
Sheet: Sheet1

Category | Manager | Category2 | Manager |  |  |  |  |  |  |  |  | CategoryManager
blue | [NAME] | white | Fred |  |  |  |  |  |  |  |  | blueBill
black | [NAME] | blue | [NAME] |  |  |  |  |  |  |  |  | blackTom
green | [NAME] | gray | [NAME] |  |  |  |  |  |  |  |  | greenJoe
 |  |  |  |  |  |  |  |  |  |  |  | whiteFred
 |  |  |  |  |  |  |  |  |  |  |  | blueTom
 |  |  |  |  |  |  |  |  |  |  |  | grayJerry
Spreadsheet: 778377d1651041830-xlookup-or-what-formula-with-multiple-column-on-lookup-array-xlookup-question
Sheet: Sheet1

Group | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10
Group A | Apple | Apricots | Avocado | Acerola | Artichoke | Asparagus | Arrowroot | Amaranth | Arugula | [NAME]
Group B | [NAME] | Blackberries | Blackcurrant | Breadfruit | Bamboo | Bean | Beets | Bell pepper | Black radish | Black eyed pea
Group C | Canteloupe | Carambola | Cherimoya | Cherries | Clementine | Coconut | Cherries | Cabbage | Cactus | [NAME]
 |  | Item | Cherries | <- Variable
 |  | Group |  | <- Formula (but instead of column B, needs to be column B:K
Spreadsheet: 546740d1510174251-vlookup-between-sheets-to-give-different-code-dates-example-spreadsheet
Sheet: 9 Column

 | Date Produced: |  |  | 2017-11-02 00:00:00
 | Date Code: |  |  |  |  |  |  |  |  |  | 9
 | Product: |  |  |  |  |  |  |  | Best By: |  |  | ( |  | days) | Line #:_________
 | Item Number: |  |  | 87654321 |  |  |  | BAD COLUMN COUNT, USE:
 | Flavor/Color OK: (YES/NO)_________ |  |  |  |  |  |  |  |  |  |  |  | LINE SUPERVISOR:________________________
 | Time |  |  |  |  |  |  |  |  |  |  | Inspected By | Corrective Actions
 | 08:00:00 |  | ERROR |  |  |  |  | ERROR
 | 09:00:00 |  | ERROR |  |  |  |  | ERROR
 | 10:00:00 |  | ERROR |  |  |  |  | ERROR
 | 11:00:00 |  | ERROR |  |  |  |  | ERROR
 | 12:00:00 |  | ERROR |  |  |  |  | ERROR
 | 13:00:00 |  | ERROR |  |  |  |  | ERROR
 | 14:00:00 |  | ERROR |  |  |  |  | ERROR
 | 15:00:00 |  | ERROR |  |  |  |  | ERROR
 | 16:00:00 |  | ERROR |  |  |  |  | ERROR
 | 17:00:00 |  | ERROR |  |  |  |  | ERROR
 | 18:00:00 |  | ERROR |  |  |  |  | ERROR
 | 19:00:00 |  | ERROR |  |  |  |  | ERROR
 | 20:00:00 |  | ERROR |  |  |  |  | ERROR
 | 21:00:00 |  | ERROR |  |  |  |  | ERROR
 | 22:00:00 |  | ERROR |  |  |  |  | ERROR
 | 23:00:00 |  | ERROR |  |  |  |  | ERROR
 | 1900-01-01 00:00:00 |  | ERROR |  |  |  |  | ERROR
 | 1900-01-01 01:00:00 |  | ERROR |  |  |  |  | ERROR
 | 1900-01-01 02:00:00 |  | ERROR |  |  |  |  | ERROR
 | Comments:
Spreadsheet: 801788d1666369400-find-minimum-value-multiple-criteria-tax-brackets-minimum
Sheet: Sheet1

Province | Bracket 1 | Bracket 2 | Bracket 3 | Bracket 4 | Bracket 5 | Bracket 6 | Bracket 7 | Bracket 8
AB | 0 | 131220 | 157464 | 209952 | 314928
BC | 0 | 43070 | 86141 | 98901 | 120094 | 162832 | 227091
MB | 0 | 34431 | 74416
NB | 0 | 44887 | 89775 | 145955 | 166280
NL | 0 | 39147 | 78294 | 139780 | 195693 | 250000 | 500000 | 1000000
NS | 0 | 29590 | 59180 | 93000 | 150000
NT | 0 | 45462 | 90927 | 147826
NU | 0 | 47862 | 95724 | 155625
ON | 0 | 46226 | 92454 | 150000 | 220000
PE | 0 | 31984 | 63969
SK | 0 | 46773 | 133638
YT | 0 | 50197 | 100392 | 155625 | 500000
Desired Output
Province | Amt | Minimum value
AB | 250000 | 209952
NL | 207500 | 195693
SK | 20000 | 0
YT | 750000 | 500000
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -13559 | -14000
2 | -13675 | -14000
3 | -13732 | -14000
4 | -13318 | -14000
5 | -14017 | -14000
6 | -13620 | -14000
7 | -13282 | -14000
8 | -13676 | -14000
9 | -13585 | -14000
10 | -13644 | -14000
11 | -13501 | -14000
12 | -15295 | -14000
13 | -14142 | -14000
14 | -14021 | -14000
15 | -14016 | -14000
16 | -12589 | -14000
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -15514.53
2002-01-16 00:00:00
CBS Volume
 |  |  | 5596
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 10c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, February 15 weekly snapshot, by product type and major currency (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 866156d1713115831-finding-partial-match-in-databse-with-filter-and-xloopup-testsheet-database-v2
Sheet: Sheet1

 | Explanation
 | In Range B7:B9 you can select a filter (list) you want to use as filter. In this case either Hobbies or Interests.
 | In range C7:C9 you can type in which hobby or interest you are looking for.
 | Filter (list) | Criteria (freefill) |  | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List |  | All_Hobbies | All_Interests
 | Hobby_List | Bowling |  | [NAME] | Tennis | Hockey |  | Reading |  | Tennis | Reading
 | Interest_List | Walking |  | [NAME] | Bowling | n/a |  | Bowling |  | Bowling | Bowling
 |  |  |  | [NAME] | n/a | n/a |  | Traveling |  | Baseball | Traveling
 |  |  |  | Rachel | Bowling | Baseball |  | Walking |  | Hockey | Walking
 |  |  |  |  |  |  |  |  |  | Darts
 | In the table below the people that meet all the requirement you are filtering for will pop-up. |  |  |  |  |  |  |  |  | n/a
 | Matches
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 |  | Bowling | n/a | Bowling n/a | Bowling
 | Rachel | Bowling | Baseball | Bowling Baseball | Walking
 | ISSUE:
 | The freefill values in C7:C9 need to be an EXACT (undesired) match with [NAME]:H9 instead of a PARTIAL (desired) match to have the people show up in the above table. Typing in 'Bowling n/a' in C7 will show [NAME].
 | GOAL:
 | Desired result when typing in 'Bowling; in C6: |  |  |  |  |  | =IF(AND(B5="";C5="");"Please use at least one filter.";IF(AND(B5<>"";C5="");"Please select a criteria for your filter.";FILTER(Database!N2:CW2;(XLOOKUP(B$5;Database!M1:CW1;Database!M2:CW2)=C5)*(XLOOKUP(B$6;Database!M1:CW1;Database!M2:CW2)=C6)*(XLOOKUP(B$7;Database!M1:CW1;Database!M2:CW2)=C7)*(XLOOKUP(B$8;Database!M1:CW1;Database!M2:CW2)=C8)*(XLOOKUP(B$9;Database!M1:CW1;Database!M2:CW2)=C9)*(XLOOKUP(B$10;Database!M1:CW1;Database!M2:CW2)=C10)*(XLOOKUP(B$11;Database!M1:CW1;Database!M2:CW2)=C11)*(XLOOKUP(B$12;Database!M1:CW1;Database!M2:CW2)=C12)*(XLOOKUP(B$13;Database!M1:CW1;Database!M2:CW2)=C13)*(XLOOKUP(B$14;Database!M1:CW1;Database!M2:CW2)=C14)*(XLOOKUP(B$15;Database!M1:CW1;Database!M2:CW2)=C15)*(XLOOKUP(B$16;Database!M1:CW1;Database!M2:CW2)=C16)*(XLOOKUP(B$17;Database!M1:CW1;Database!M2:CW2)=C17)*(XLOOKUP(B$18;Database!M1:CW1;Database!M2:CW2)=C18)*(XLOOKUP(B$19;Database!M1:CW1;Database!M2:CW2)=C19)*(XLOOKUP(B$20;Database!M1:CW1;Database!M2:CW2)=C20)*(XLOOKUP(B$21;Database!M1:CW1;Database!M2:CW2)=C21)*(XLOOKUP(B$22;Database!M1:CW1;Database!M2:CW2)=C22)*(XLOOKUP(B$23;Database!M1:CW1;Database!M2:CW2)=C23);"No Influencers have been found that meet your criteria. Consider widening your filter selection.")))
 | Matches
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 | [NAME] | Bowling | n/a | Bowling n/a | Bowling
 | Rachel | Bowling | Baseball |  | Walking