tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 51968d1251609693-subtracting-hours-in-a-work-schedule-laura-test-for-schedule-formula
Sheet: Sheet2

STORE 3
DATE
EMPLOYEE | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | MONDAY | TUESDAY
DARCELL | 9:00-4:00 | 9:00-4:00 | 9:00-4:00 | 9:00-4:00 | 9:00-4:00 | 9:00-4:00 | 41.99999999999999
 | 6.999999999999999 | 6.999999999999999 | 6.999999999999999 | 6.999999999999999 | 6.999999999999999 | 6.999999999999999
CLINTON | 9:00-4:00 | 9:00-4:00 | 9:00-4:00 | 9:00-4:00 | 9:00-4:00 | 9:00-4:00 | 41.99999999999999
 | 6.999999999999999 | 6.999999999999999 | 6.999999999999999 | 6.999999999999999 | 6.999999999999999 | 6.999999999999999
LAURA | 2:15-9:15 | 9:00-3:00 |  |  |  | 0:00-0:00 | 41.99999999999999
CATHERINE | 2:15-9:15
TERENCE
NICK
LYNN
BILL
Spreadsheet: 717584d1612753536-conditional-formatting-multiple-ranges-tabs-conditional-formatting-multiple-rules-referencing-separate-sheet-fayecattini-
Sheet: Year View

YEAR | Project | CALENDAR
JANUARY |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
FEBRUARY |  | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00
[NAME] |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
APRIL |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
MAY |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME] |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
JULY |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
AUGUST |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
SEPTEMBER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
OCTOBER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
NOVEMBER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
DECEMBER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 491758d1480618410-is-there-a-sort-order-that-puts-blank-cells-at-the-top-sort
Sheet: Sheet1

data | Helper
a
b
c
f
x
a
m
c
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 22056
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 2015
Index Tranche | Asia | <100
 | Europe | 462
 | North America | 121
Index | Asia | 271
 | Europe | 5865
 | North America | 4486
TOTAL |  | 35276
Estimated swap transaction volumes, week ending February 8, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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 Data Dictionary for product 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: 708233d1607684765-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: PORTUGAL

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 157920d1337928478-text-results-with-two-conditions-lookup-with-two-conditions-davzx_book1_25may12_01
Sheet: Sheet1

Date | W.O. | Shift | Engineer
2012-01-01 00:00:00 | 1 | I | [NAME]
2012-01-01 00:00:00 | 1 | I | [NAME]
2012-01-01 00:00:00 | 1 | I | [NAME]
2012-01-01 00:00:00 | 1 | I | [NAME]
2012-01-01 00:00:00 | 1 | I | [NAME]
2012-01-01 00:00:00 | 1 | II | [NAME]
2012-01-01 00:00:00 | 1 | II | [NAME]
2012-01-01 00:00:00 | 1 | II | [NAME]
2012-01-01 00:00:00 | 1 | III | [NAME]
2012-01-01 00:00:00 | 1 | III | [NAME]
2012-01-02 00:00:00 | 1 | I | Vito
2012-01-02 00:00:00 | 1 | I | Vito
2012-01-02 00:00:00 | 2 | II | [NAME]
2012-01-02 00:00:00 | 2 | II | [NAME]
2012-01-02 00:00:00 | 2 | III | Filip
2012-01-03 00:00:00 | 2 | I | [NAME]
2012-01-03 00:00:00 | 3 | II | [NAME]
2012-01-03 00:00:00 | 3 | II | [NAME]
2012-01-03 00:00:00 | 3 | III | [NAME]
2012-01-03 00:00:00 | 3 | III | [NAME]
Spreadsheet: 14171b74-2c38-4ff8-9006-7bbb27cdc5c8
Sheet: Mathematics

Mathematics GRAD Retest Raw to Scale Score Table (2013)
Scale Score by Test Form
Raw Score | Form A | Form B | Form C | Form D | Form E | Form F
0 | 15 | 15 | 15 | 15 | 15 | 15
1 | 15 | 15 | 15 | 15 | 15 | 15
2 | 15 | 15 | 15 | 15 | 15 | 15
3 | 15 | 15 | 15 | 15 | 15 | 15
4 | 15 | 15 | 15 | 15 | 15 | 15
5 | 15 | 15 | 15 | 15 | 15 | 15
6 | 15 | 15 | 15 | 15 | 15 | 15
7 | 15 | 15 | 15 | 15 | 15 | 15
8 | 15 | 15 | 15 | 15 | 15 | 15
9 | 16 | 15 | 15 | 15 | 15 | 15
10 | 20 | 19 | 15 | 16 | 19 | 18
11 | 24 | 23 | 19 | 21 | 24 | 21
12 | 26 | 27 | 22 | 24 | 27 | 24
13 | 29 | 29 | 25 | 27 | 30 | 26
14 | 31 | 31 | 27 | 29 | 32 | 29
15 | 32 | 33 | 30 | 31 | 34 | 30
16 | 34 | 34 | 32 | 33 | 35 | 32
17 | 36 | 36 | 33 | 35 | 37 | 34
18 | 37 | 37 | 35 | 37 | 38 | 36
19 | 38 | 39 | 37 | 38 | 40 | 37
20 | 40 | 40 | 38 | 40 | 41 | 39
21 | 41 | 41 | 40 | 41 | 42 | 40
22 | 42 | 42 | 41 | 42 | 43 | 42
23 | 44 | 44 | 43 | 44 | 45 | 43
24 | 45 | 45 | 44 | 45 | 46 | 44
25 | 46 | 46 | 46 | 46 | 47 | 46
26 | 47 | 47 | 47 | 48 | 48 | 47
27 | 49 | 48 | 48 | 50 | 49 | 49
28 | 50 | 50 | 50 | 51 | 50 | 50
29 | 51 | 51 | 51 | 52 | 52 | 52
30 | 53 | 52 | 53 | 54 | 53 | 53
31 | 54 | 53 | 54 | 55 | 54 | 55
32 | 56 | 55 | 56 | 57 | 56 | 57
33 | 57 | 56 | 58 | 59 | 57 | 58
34 | 59 | 58 | 60 | 60 | 59 | 60
35 | 61 | 60 | 62 | 62 | 61 | 62
36 | 63 | 62 | 64 | 65 | 64 | 65
37 | 66 | 64 | 67 | 67 | 67 | 68
38 | 69 | 68 | 71 | 71 | 71 | 72
39 | 76 | 74 | 78 | 78 | 79 | 78
40 | 85 | 85 | 85 | 85 | 85 | 85
End of Worksheet
Spreadsheet: 886329d1736351826-robust-index-match-w-non-tabular-data-test-file-1-etaf
Sheet: Sales Report

 |  |  |  | 68 | 67 | 66 | 65 | 64 | 63 | 62 | 61 | 60 | 59 | 58 | 57 | 56 | 55 | 54 | 53 | 52 | 51 | 50 | 49 | 48 | 47 | 46 | 45 | 44 | 43 | 42 | 41 | 40 | 39 | 38 | 37 | 36 | 35 | 34 | 33 | 32 | 31 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16
 |  |  |  |  | 2025-01-18 00:00:00 | 2025-01-11 00:00:00 | 2025-01-04 00:00:00 | 2024-12-28 00:00:00 | 2024-12-21 00:00:00 | 2024-12-14 00:00:00 | 2024-12-07 00:00:00 | 2024-11-30 00:00:00 | 2024-11-23 00:00:00 | 2024-11-16 00:00:00 | 2024-11-09 00:00:00 | 2024-11-02 00:00:00 | 2024-10-26 00:00:00 | 2024-10-19 00:00:00 | 2024-10-12 00:00:00 | 2024-10-05 00:00:00 | 2024-09-28 00:00:00 | 2024-09-21 00:00:00 | 2024-09-14 00:00:00 | 2024-09-07 00:00:00 | 2024-08-31 00:00:00 | 2024-08-24 00:00:00 | 2024-08-17 00:00:00 | 2024-08-10 00:00:00 | 2024-08-03 00:00:00 | 2024-07-27 00:00:00 | 2024-07-20 00:00:00 | 2024-07-13 00:00:00 | 2024-07-06 00:00:00 | 2024-06-29 00:00:00 | 2024-06-22 00:00:00 | 2024-06-15 00:00:00 | 2024-06-08 00:00:00 | 2024-06-01 00:00:00 | 2024-05-25 00:00:00 | 2024-05-18 00:00:00 | 2024-05-11 00:00:00 | 2024-05-04 00:00:00 | 2024-04-27 00:00:00 | 2024-04-20 00:00:00 | 2024-04-13 00:00:00 | 2024-04-06 00:00:00 | 2024-03-30 00:00:00 | 2024-03-23 00:00:00 | 2024-03-16 00:00:00 | 2024-03-09 00:00:00 | 2024-03-02 00:00:00 | 2024-02-24 00:00:00 | 2024-02-17 00:00:00 | 2024-02-10 00:00:00 | 2024-02-03 00:00:00 | 2024-01-27 00:00:00
Prime [NAME] | Prime Item Desc | Data Type | Total to Date |  | 202452 | 202451 | 202450 | 202449 | 202448 | 202447 | 202446 | 202445 | 202444 | 202443 | 202442 | 202441 | 202440 | 202439 | 202438 | 202437 | 202436 | 202435 | 202434 | 202433 | 202432 | 202431 | 202430 | 202429 | 202428 | 202427 | 202426 | 202425 | 202424 | 202423 | 202422 | 202421 | 202420 | 202419 | 202418 | 202417 | 202416 | 202415 | 202414 | 202413 | 202412 | 202411 | 202410 | 202409 | 202408 | 202407 | 202406 | 202405 | 202404 | 202403 | 202402 | 202401
12345 | Orange Pen | POS Qty
12345 | Orange Pen | POS Sales
67890 | Blue Rock | POS Qty
67890 | Blue Rock | POS Sales
54321 | Apple Pie | POS Qty
54321 | Apple Pie | POS Sales
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -4662 | -5000
2 | -17042 | -16843
3 | -17090 | -16843
4 | -10627 | -10000
5
6
7 | -9835 | -9656
8
9 | -12907 | -13000
10 | -6318 | -6000
11 | -5383 | -4262
12
13
14
15 |  | 10000
16 | -12589
17 | -25789 | -25000
18 | -6724 | -6666
19 | -12435 | -12000
20 | -22170 | -22000
21
22
23
24
25
26 |  | -6000
27 | -37828 | -33834
28 | -3761 | -5760
29 | -12221 | -12131
30 | -12258 | -12131
31 | -5356 | -5000
2001-11-30 00:00:00 |  |  | -85517.91
2001-12-31 00:00:00
CBS Volume
 |  |  | -41313
Spreadsheet: rick_buy__32925__Group_Netco_MarketRisk
Sheet: Mexico

 | Mexico
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Annualized | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays | 0
 | Analyst & Assoicate | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense |  |  |  |  |  |  |  |  | 1.2
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 1
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 1
 |  |  |  |  |  |  |  |  | Director | 156000 | 1
 | Headcount |  |  | 16 | 3 |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | A&A Headcount |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Other Expense Calculation
ENAOUTTX | Outside Tax
ENAINSUR | Insurance |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
ENASYSDV | System Development |  |  |  |  |  |  |  |  |  | 3
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Outside Services | 338678
 | Other Expenses | 434791
Spreadsheet: 040b25af-05b7-4e5f-bb87-d54b94dbea84
Sheet: 113 Dallas County Proposed Menu

DeSoto Senior Activity Center
March 2013 |  |  |  | Friday
 |  |  |  | 2013-03-01 00:00:00
 |  |  |  | [NAME]
 |  |  |  | Black-Eyed Peas
 |  |  |  | Stewed Tomatoes
 |  |  |  | Dinner Roll
 |  |  |  | Pineapple Tidbits
 |  |  |  | Milk
 |  |  |  | Margarine
Monday | Tuesday | Wednesday | Thursday | Friday
2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00
Grilled [NAME] | Swedish Meatballs | Pulled [NAME] | [NAME] | [NAME] with Gravy
[NAME] | Orzo Pasta | Ranch Beans | Green Beans | Cornbread Dressing
Macaroni and Cheese | Peas and Carrots | Potato Salad | Dilled Carrots | Spring Vegetables
Country Vegetables | Multi Grain Bread | Hamburger Bun | Wheat Bread | Dinner Roll
Wheat Bread | Chocolate Chip Cookie | Fresh Orange | Fruited [NAME] | Butterscotch Pudding
Fresh Apple | Milk | Milk | Milk | Milk
Milk | Margarine |  | Margarine | Margarine
Margarine
Monday | Tuesday | Wednesday | Thursday | Friday
2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00
Western Baked Beef | Sliced [NAME] | Meatloaf | Sausage with White Beans
[NAME] | Swiss Cheese | Brown Gravy | Country Tomatoes
Country Vegetables | Lettuce and [NAME] | Whipped Potatoes | Spinach | Box
Wheat Bread | Cold Pickled Beets | Green Beans | Cornbread | Lunch
Fresh Orange | Hoagie Bun | Wheat Bread | Fresh Banana | 2% Milk
Milk | Fresh Apple | Birthday Cake | Milk
Margarine | Milk | Ice Cream | Margarine
 | Mayonnaise | Milk
Monday | Tuesday | Wednesday | Thursday | Friday
2013-03-18 00:00:00 | 2013-03-19 00:00:00 | 2013-03-20 00:00:00 | 2013-03-21 00:00:00 | 2013-03-22 00:00:00
[NAME] | Cheesy [NAME] | [NAME] | [NAME] | Turkey Gumbo
[NAME] | [NAME] | Lettuce and [NAME] | Oven Roasted Potatoes | [NAME]
Glazed Carrots | Stewed Tomatoes | Mexican [NAME] | Cold Pickled Beets | [NAME]
Wheat Bread | Multi Grain Bread | [NAME] | Biscuit | [NAME]
Fresh Apple | Fruited [NAME] | Apple Crisp | Fresh Banana | Oatmeal Cookie
Milk | Milk | Milk | Milk | Milk
Margarine | Margarine | Taco Sauce | Margarine | Ranch Salad Dressing
Monday | Tuesday | Wednesday | Thursday | Friday
2013-03-25 00:00:00 | 2013-03-26 00:00:00 | 2013-03-27 00:00:00 | 2013-03-28 00:00:00 | 2013-03-29 00:00:00
Meatballs with Gravy | [NAME] | Breaded Chicken Tenders | Chili with Beans
[NAME] | Black-Eyed Peas | Whipped Potatoes | [NAME] | Good Friday
Broccoli | Stewed Tomatoes | Green Beans | Parsleyed Carrots | Holiday
Wheat Bread | Wheat Bread | Wheat Bread | [NAME]
Fresh Orange | Sliced Peaches | Fruited Orange Gelatin | Fresh Banana | Center Closed
Milk | Milk | Milk | Milk
Margarine |  | Margarine
Activities and services at this Center are equally accessible to all persons who are age 50 and over regardless of race, color, national origin, religious affiliation, handicap or impairment.  A donation of $1.00 is suggested for meal participants 60+ and their spouse otherwise the cost is $6.00 per meal.  Meals must be ordered by noon two days in advance by calling [PHONE].
Spreadsheet: 843544d1695326250-creating-a-table-with-variable-values-based-on-dropdown-selection-sample-data-
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | Vendor 1 | 10 | 12 | 18 | 19 |  |  | Material 1 | 10 | 11 | 18 | 12
 |  | Vendor 2 | 10 | 10 | 10 | 10 |  |  | Material 2 | 6.23 | 6.5 | 6.8 | 6.2
 |  | Vendor 3 | 11 | 11 | 11 | 11 |  |  | Material 3 | 55 | 15 | 32 | 41
 |  |  |  |  |  |  |  |  | Material | Material 1 | The table values would change based on the drop down selections
 |  |  |  |  |  |  |  |  | Vendor | Vendor 2
 |  | Car 1 |  |  |  |  |  |  | Car | Car 1
 | Demand Plan |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA | 10 | 10 | 10 | 10 |  |  |  | Q1 | Q2 | Q3 | Q4
 |  | CANADA | 20 | 20 | 20 | 20 |  |  | USA
 |  | Mexico | 30 | 30 | 30 | 30 |  |  | CANADA | X | X | X | X
 |  |  |  |  |  |  |  |  | Mexico | X | X | X | X
 |  | Car 2
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA | 10 | 10 | 10 | 10
 |  | CANADA | 20 | 20 | 20 | 20
 |  | Mexico | 30 | 30 | 30 | 30
 |  | Car 3
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA | 10 | 10 | 10 | 10
 |  | CANADA | 20 | 20 | 20 | 20
 |  | Mexico | 30 | 30 | 30 | 30
Spreadsheet: 182883d1348648188-problem-with-sum-on-multiple-vlkoopups-food
Sheet: Food

Indicatie per dag |  |  |  | Maandag | Eiwit | Koolh | Vet | KC |  | Dinsdag | Eiwit | Koolh | Vet | KC |  | Woensdag | Eiwit | Koolh | Vet | KC |  | Donderdag | Eiwit | Koolh | Vet | KC |  | Vrijdag | Eiwit | Koolh | Vet | KC |  | Zaterdag | Eiwit | Koolh | Vet | KC |  | Zondag | Eiwit | Koolh | Vet | KC
 |  |  |  | Ontbijt |  |  |  |  |  | Ontbijt |  |  |  |  |  | Ontbijt |  |  |  |  |  | Ontbijt |  |  |  |  |  | Ontbijt |  |  |  |  |  | Ontbijt |  |  |  |  |  | Ontbijt
Ontbijt
Tussendoor
Lunch
Diner |  |  |  | Tussen |  |  |  |  |  | Tussen |  |  |  |  |  | Tussen |  |  |  |  |  | Tussen |  |  |  |  |  | Tussen |  |  |  |  |  | Tussen |  |  |  |  |  | Tussen
Laat
Nodig:
 |  |  |  | Lunch |  |  |  |  |  | Lunch |  |  |  |  |  | Lunch |  |  |  |  |  | Lunch |  |  |  |  |  | Lunch |  |  |  |  |  | Lunch |  |  |  |  |  | Lunch
 |  |  |  | Diner |  |  |  |  |  | Diner |  |  |  |  |  | Diner |  |  |  |  |  | Diner |  |  |  |  |  | Diner |  |  |  |  |  | Diner |  |  |  |  |  | Diner
 |  |  |  | Laat |  |  |  |  |  | Laat |  |  |  |  |  | Laat |  |  |  |  |  | Laat |  |  |  |  |  | Laat |  |  |  |  |  | Laat |  |  |  |  |  | Laat
 |  |  |  | Totalen |  |  |  |  |  | Totalen |  |  |  |  |  | Totalen |  |  |  |  |  | Totalen |  |  |  |  |  | Totalen |  |  |  |  |  | Totalen |  |  |  |  |  | Totalen
Spreadsheet: 44849d1243582488-date-minus-a-date-formula-test
Sheet: Sheet1

Woodworth | [NAME] | Yes | 2009-05-15 00:00:00 | 2010-05-15 00:00:00 | 365 Days Overdue
[NAME] | Helen | Yes | 2007-09-12 00:00:00 | 2008-09-12 00:00:00 | 366 Days Overdue | Overdue
[NAME] | [NAME] | Yes | 2009-01-06 00:00:00 | 2010-01-06 00:00:00 | 365 Days Overdue
[NAME] | Helen | Yes | 2007-09-12 00:00:00 | 2008-09-12 00:00:00 | 366 Days Overdue | Overdue
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
ANALYSIS OF OTHER DEFERRED CREDITS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-99 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash (Pd) / Rec'd |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 794567d1662121785-need-a-formula-to-return-an-array-prior-to-dynamic-array-functions-cannnot-do-it-excel-help-array-predynamic
Sheet: Sheet1

 |  |  |  | [NAME] | FreqCode | SumCheck | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00 | 2022-01-23 00:00:00 | 2022-01-24 00:00:00 | 2022-01-25 00:00:00 | 2022-01-26 00:00:00
 |  |  |  | Phone bill due (BECU) | EW | 52 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  | Rent paid ([NAME]) | E2W | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  | Car Loan due ([NAME]) | EM | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Truck Loan paid ([NAME]) | E2M | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Visa bill due (BECU) | EQ | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | MC bill due ([NAME]) | 2Y | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Gas bill paid (BECU) | 1Y | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Electricity due (BECU) | 1D | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Date | 2022-01-10 00:00:00
 | Result I want as a returned array: |  |  | Phone bill due (BECU) |  | Basically, I want a formula that finds the column using H1:AG1 to find the date that matches C11, then in that column
 |  |  |  | Rent paid ([NAME]) |  | find all rows with a 1 (there are three) and pull the contents of column E that match those rows.
 |  |  |  | Car Loan due ([NAME])
 |  |  |  |  |  | I can do this easily with dynamic array formula:
 |  |  |  |  |  | Rent paid ([NAME])
 |  |  |  |  |  | Car Loan due ([NAME])
 |  |  |  |  |  | But how can this easily be done prior to dynamic array formulas like FILTER?