tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 224672d1364690783-months-after-formatting-color-bvj-
Sheet: Foglio1

Test date | date plus 30 days | PC date greater than test date + 30 | Test date is greater than TODAY() + 30
2013-02-14 00:00:00
2013-02-15 00:00:00
2013-02-16 00:00:00
2013-02-17 00:00:00
2013-02-18 00:00:00
2013-02-19 00:00:00
2013-02-20 00:00:00
2013-02-21 00:00:00
2013-02-22 00:00:00
2013-02-23 00:00:00
2013-02-24 00:00:00
2013-02-25 00:00:00
2013-02-26 00:00:00
2013-02-27 00:00:00
2013-02-28 00:00:00
2013-03-01 00:00:00
2013-03-02 00:00:00
2013-03-03 00:00:00
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
2013-03-09 00:00:00
2013-03-10 00:00:00
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
2013-03-16 00:00:00
2013-03-17 00:00:00
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
2013-03-23 00:00:00
2013-03-24 00:00:00
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
2013-03-30 00:00:00
2013-03-31 00:00:00
2013-04-01 00:00:00
2013-04-02 00:00:00
2013-04-03 00:00:00
2013-04-04 00:00:00
2013-04-05 00:00:00
2013-04-06 00:00:00
2013-04-07 00:00:00
2013-04-08 00:00:00
2013-04-09 00:00:00
2013-04-10 00:00:00
2013-04-11 00:00:00
2013-04-12 00:00:00
2013-04-13 00:00:00
2013-04-14 00:00:00
2013-04-15 00:00:00
2013-04-16 00:00:00
2013-04-17 00:00:00
2013-04-18 00:00:00
2013-04-19 00:00:00
2013-04-20 00:00:00
2013-04-21 00:00:00
2013-04-22 00:00:00
2013-04-23 00:00:00
2013-04-24 00:00:00
2013-04-25 00:00:00
2013-04-26 00:00:00
2013-04-27 00:00:00
2013-04-28 00:00:00
2013-04-29 00:00:00
2013-04-30 00:00:00
2013-05-01 00:00:00
2013-05-02 00:00:00
2013-05-03 00:00:00
2013-05-04 00:00:00
2013-05-05 00:00:00
2013-05-06 00:00:00
2013-05-07 00:00:00
2013-05-08 00:00:00
2013-05-09 00:00:00
2013-05-10 00:00:00
2013-05-11 00:00:00
2013-05-12 00:00:00
2013-05-13 00:00:00
2013-05-14 00:00:00
2013-05-15 00:00:00
2013-05-16 00:00:00
2013-05-17 00:00:00
2013-05-18 00:00:00
2013-05-19 00:00:00
2013-05-20 00:00:00
2013-05-21 00:00:00
2013-05-22 00:00:00
2013-05-23 00:00:00
Spreadsheet: 114340d1310090974-nested-ifs-or-array-logic_example
Sheet: List 2

Year | List 2
2005 | Prefix | Code | Description | P Rate | T Rate | Global Rate | Quantity | P Collections | T Collections | Global Collections | Total
 | P |  |  |  |  |  | 1
 | T |  |  |  |  |  | 2
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 1
Spreadsheet: 454451d1459848146-applying-filtering-on-data-validation-selection-copy-of-book1
Sheet: Data

Partner Country | X | Y
Uzbekistan | 1 | 2
Switzerland | 5 | 2
Bosnia And Herzegovina | 5 | 6
Pakistan | 4 | 28
Italy | 3 | 2
Spain | 5 | 7
France | 21 | 8
Kuwait | 2 | 2
Kenya | 582 | 52
Italy | 52 | 2
Russian Federation | 3 | 8
Spreadsheet: 118051d1313411229-extracting-data-from-multiple-sheets-in-to-one-example-packing-list
Sheet: 1090

 | CLOTHING PACKING LIST
 | I EUROPE LTD
 | CUSTOMER NAME: |  |  | [NAME]
 | ADDRESS
 | ORDER NO. |  |  | UCLAW11 - 1090
 | INVOICE NO
 | AGENT NAME |  |  | [NAME]
 | REPEAT CONF. |  |  | 2011-07-15 00:00:00
 | CUST.PO
 | NO. OF CARTON |  |  | 1
 | STYLE | NO | CRTN NO | COLOUR | XS | S | M | L | XL | XXL | TOTAL | BX TOTAL
 | UCLG | RAYS-701 | 13270 | Peacoat | 0 | 0 | 0 | 2 | 2 | 2 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  | 6
Spreadsheet: 599609d1543221070-if-function-code
Sheet: Customer Data

 |  | Customer Service Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accumulator
[NAME]. No. |  | Customer | Site | Machine no. | Machine model |  | Running hrs per week | No. days per week | Throughput / week | [NAME] | Date Serviced | Next Service | Service Hrs | Service Agreement Date | Service Agreement Renewal Due | 60015593 | 60022338 | 60024223 | 60022621 | 176162 | 60021981 | 60022340 | 60022342 | 60015591 | 60015595 | 60018632 | 60018797 | 60009305 | 60025986 | 60025693 | 60025872 (CAT) | 60025883 (CAT) | [NAME] (CAT) | N05502362 (CAT) | 60025617 (CAT) | MM0415474 (CAT) | 60025568 (CAT) | 176162 (CAT) |  |  | M-60021521 | M-60022778
4353 | SUL | SUL | SUL1 | 4353 | 2x8 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 2 | 1 | 1 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000 | 4000
4354 | SUL | SUL | [NAME] | 4354 | 2x8 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 2 | 1 | 1 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | 300
5101 | AEL | AEL | AEL1 | 5101 | 1x8 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 1 | 1 | 1 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | 200
2064 | WTL | WTL | WTL1 | 2064 | 2x12 |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 2 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
3104 | WTL | WTL | WTL2 | 3104 | 2x8 |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 1 | 1 | 10 |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  | 1 | 40 | 1
4378 | WTL | WTL | WTL3 | 4378 | 2x9 |  | 100 | 5 |  |  |  |  |  |  |  | 1 | 2 | 2 | 1 | 1 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
4392 | EGG | EGG | EGG1 | 4392 | 2x8 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 2 | 1 | 1 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
Spreadsheet: 138558d1327712118-how-to-update-macro-to-repeat-through-the-entire-sheet-sample
Sheet: Data after running macro

Class of Trade Change Validation Report
From Date: 1/1/2012
End Date: 1/15/2012
Business Unit:
2012/Q1/01
[NAME] | BUNIT Name |  |  | BUNIT Start Date | BUNIT End Date | BUNIT Primary Id | BUNIT Default Address |  |  |  | Old COT Mod Date | Old COT | Old COT Start Date | Old COT End Date | Old COT Status | New COT Mod Date | New COT | New COT Start Date | New COT End Date | New COT Status | Has [NAME] based on Stlmnt Dt?
1741 | Department of Veterans Affairs |  |  | 1960-01-01 00:00:00 |  | AK3507994 | [NAME] , CT - 06067 |  |  |  | 2012-01-10 14:30:31 | VA | 1960-01-01 00:00:00 |  | SUP | 2012-01-10 14:30:31 | OGA | 1960-01-01 00:00:00 |  | ACT | Y
[NAME] | BUNIT Name |  |  | BUNIT Start Date | BUNIT End Date | BUNIT Primary Id | BUNIT Default Address |  |  |  | Old COT Mod Date | Old COT | Old COT Start Date | Old COT End Date | Old COT Status | New COT Mod Date | New COT | New COT Start Date | New COT End Date | New COT Status | Has [NAME] based on Stlmnt Dt?
9380 | SEARHC-Mt. Edgecumbe Hospital |  |  | 1960-01-01 00:00:00 |  | 940240J00 | [NAME] , AK - 99835 |  |  |  | 2012-01-09 12:26:33 | IHS | 1960-01-01 00:00:00 |  | SUP | 2012-01-09 12:26:33 | IH | 1960-01-01 00:00:00 |  | ACT | Y
Spreadsheet: 584397d1533151723-take-x-until-a-certain-value-is-met-then-take-100-billing-calculations-example
Sheet: Billing Period Totals

Billing Period | Cumulative Total Collected |  |  |  | 2018-01-01 00:00:00 |  | 2018-02-01 00:00:00 |  | 2018-03-01 00:00:00 |  | 2018-04-01 00:00:00 |  | 2018-05-01 00:00:00 |  | 2018-06-01 00:00:00 |  | 2018-07-01 00:00:00 |  | 2018-08-01 00:00:00 |  | 2018-09-01 00:00:00 |  | 2018-10-01 00:00:00 |  | 2018-11-01 00:00:00 |  | 2018-12-01 00:00:00 |  | 2019-01-01 00:00:00 |  | 2019-02-01 00:00:00 |  | 2019-03-01 00:00:00 |  | 2019-04-01 00:00:00 |  | 2019-05-01 00:00:00 |  | 2019-06-01 00:00:00 |  | 2019-07-01 00:00:00 |  | 2019-08-01 00:00:00 |  | 2019-09-01 00:00:00 |  | 2019-10-01 00:00:00 |  | 2019-11-01 00:00:00 |  | 2019-12-01 00:00:00
2018-01-01 00:00:00
2018-02-01 00:00:00
2018-03-01 00:00:00
2018-04-01 00:00:00
2018-05-01 00:00:00
2018-06-01 00:00:00
2018-07-01 00:00:00
2018-08-01 00:00:00
2018-09-01 00:00:00
2018-10-01 00:00:00
2018-11-01 00:00:00
2018-12-01 00:00:00
2019-01-01 00:00:00
2019-02-01 00:00:00
2019-03-01 00:00:00
2019-04-01 00:00:00
2019-05-01 00:00:00
2019-06-01 00:00:00
2019-07-01 00:00:00
2019-08-01 00:00:00
2019-09-01 00:00:00
2019-10-01 00:00:00
2019-11-01 00:00:00
2019-12-01 00:00:00
2020-01-01 00:00:00
2020-02-01 00:00:00
2020-03-01 00:00:00
2020-04-01 00:00:00
2020-05-01 00:00:00
2020-06-01 00:00:00
2020-07-01 00:00:00
2020-08-01 00:00:00
2020-09-01 00:00:00
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
Spreadsheet: john_griffith__16099__1_18_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG G2 | 225 | 21 | 22.5 | 70.7 | 75.8 | 10.36 | 2002-01-18 13:25:00
 | NG H2 | 225 | 36 | 37 | 62.5 | 64.2 | 8.96 | 2002-01-18 13:25:00
 | NG J2 | 225 | 39.5 | 40.5 | 52.2 | 53.5 | 7.48 | 2002-01-18 13:25:00
 | NG K2 | 235 | 46 | 46.5 | 48.2 | 48.7 | 7.16 | 2002-01-18 13:25:00
 | NG M2 | 240 | 50 | 52 | 44.5 | 46.3 | 6.85 | 2002-01-18 13:25:00
 | NG N2 | 250 | 57.5 | 60 | 44.7 | 46.7 | 7.18 | 2002-01-18 13:25:00
 | NG Q2 | 255 | 64.5 | 67 | 45.2 | 47 | 7.39 | 2002-01-18 13:25:00
 | NG U2 | 255 | 70.5 | 72.5 | 45.9 | 47.2 | 7.46 | 2002-01-18 13:25:00
 | NG V2 | 255 | 76 | 78.5 | 46.7 | 48.3 | 7.62 | 2002-01-18 13:25:00
 | NG X2 | 275 | 87.5 | 89 | 47.2 | 48 | 8.23 | 2002-01-18 13:25:00
 | [NAME] | 300 | 99 | 101 | 46.9 | 47.8 | 8.93 | 2002-01-18 13:25:00
 | NG F3 | 305 | 107 | 109.5 | 47.9 | 49 | 9.29 | 2002-01-18 13:25:00
 | NG H3 |  |  |  |  |  |  | 2002-01-14 14:57:00
 | NG M3 |  |  |  |  |  |  | 2002-01-07 10:05:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 1

 | Jul 12 | Jul 19 | Jul 26 | Aug 2 | Aug 9
Total Interest Rate* | 407544951 | 409603188 | 415233742 | 416033383 | 418052416
Cleared** | 199995874 | 202237153 | 206005881 | 207531819 | 208635320
Uncleared | 207549077 | 207366035 | 209227861 | 208501563 | 209417096
Total Cross-Currency | 16388810 | 16351629 | 16491326 | 16487218 | 16590667
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 16388810 | 16351629 | 16491326 | 16487218 | 16590667
Total Credit | 20551759 | 20494037 | 20664345 | 20832727 | 20886911
Cleared | 2924048 | 2920233 | 2949205 | 2963811 | 2950751
Uncleared | 17627711 | 17573804 | 17715140 | 17868916 | 17936160
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 447576520 | 449539854 | 455480413 | 456444328 | 458620994
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared 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: 878995d1726405896-auto-number-generate-with-conditions-tps_srno_1509
Sheet: Data_Entry

Data Entry Area
 |  |  |  |  |  |  |  |  |  | Calculated Value |  |  |  |  |  |  |  |  | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(R6="","",AGGREGATE(15,6,tbl_Data_1[Rank]/(tbl_Data_1[Attribute]="Return Dt")/(tbl_Data_1[Deno]=A6),1))
Deno | Colour | Column12 | Column13 | Column14 | Column5 | Column4 | Column3 | [NAME] | Column1 | [NAME] | Column9 | Column10 | Column11 | Column8 | Column6 | Column2 | Return Dt | Column7 | Return SrNo |  | Actual Return SrNo
111 | A |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(R6="","",AGGREGATE(15,6,tbl_Data_1[Rank]/(tbl_Data_1[Attribute]="Return Dt")/(tbl_Data_1[Value]=R6),1))
222 | B |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  | 4 | Since, A7 is changed even though R6 & R7 is same
111 | C |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | 6
444 | C |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | 7
444 | D |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | 7
555 | A |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | 8 | Since, A11 is changed even though R8,R9, R10,R11 is same DATE
 |  |  |  |  |  |  |  |  |  | This is OK |  |  |  |  |  |  |  |  | This is Not OK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Can I cange the numbering pattern from a particular point , say start no is from 15 onwaards
Spreadsheet: 879626d1727198343-change-contents-of-a-cell-based-on-another-cell-test-sheet
Sheet: Sheet1

Intake | First Name | Surname | [NAME] | 2024-11-05 00:00:00 | 2024-11-07 00:00:00 | 2024-11-19 00:00:00 | 2024-12-10 00:00:00
Active | [NAME] | Bloggs |  | 1 |  |  | 1
Active | [NAME] | [NAME] |  |  | 1 | 1 | 1
Active | [NAME] | Potter |  | 1 |  |  | 1
Leaver | [NAME] | Tyson |  |  |  | 1 | 1
Spreadsheet: 751145d1633935124-year-to-date-sales-computation-assistance-request-ytd-2021-sales
Sheet: Sheet1

channeltype |  | 2021-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 | nsales_dist | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 % |  | A2021 | T2021 | A2020 | A2019 | [NAME] | Grw 2021 vs 2020 % | Grw 2021 vs 2019 %
E-Commerce | ECOM | 301669.3 | 123456 | 45178.74 | 0 |  |  |  | 282812.6800000001 | 123456 | 78976.65 | 0 |  |  |  | 418663.86 | 123456 | 22310.5 | 0 |  |  |  |  | 123456 |  |  |  |  |  | 212569.51 | 123456 | 29659.75 | 0 |  |  |  | 284524.51 | 123456 | 254361.34 | 0 |  |  |  | 306306.85 | 123456 | 201183.92 | 0 |  |  |  | 293563.25 | 123456 | 246834.97 | 0 |  |  |  | 450596.47 | 123456 | 283983.34 | 0 |  |  |  | 0 | 123456 | 283139.85 | 7317 |  |  |  | 0 | 123456 | 259730.49 | 161138.4 |  |  |  | 0 | 123456 | 780767.1900000001 | 144500.1
E-Commerce Total | ECOM
Spreadsheet: 726837d1617530228-data-selection-in-a-row-can-variable-as-per-data-availability-book22
Sheet: Sheet1

 |  |  |  | a | b | c | d | e | f | g | h | i | j | k | l
 |  |  |  |  | a | k | b | j | c | i | d | h | e | g | f
Spreadsheet: 797485d1663920249-return-sum-of-occurances-of-a-list-of-letters-excel-forum-23-sept
Sheet: Sheet1

 |  |  |  |  | formula downwards
 |  |  |  | a | 3
 |  |  |  | a | 3
 |  |  |  | a | 3
 |  |  |  | b | 4
 |  |  |  | b | 4
 |  |  |  | b | 4
 |  |  |  | b | 4
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | r | 10
 |  |  |  | k | 5
 |  |  |  | k | 5
 |  |  |  | k | 5
 |  |  |  | k | 5
 |  |  |  | k | 5
Spreadsheet: 39705d1237994192-break-individual-letters-between-underscores-into-single-columns-1301_abcd_cc-example-47
Sheet: Sheet2

1304DP_CVDA2_CC_ | C | V | D | A2 |  |  |  |  | C | V | D | £
1304EP_CVDa2_CC_ | C | V | D | A2 |  |  |  |  | C | V | D | £
1400BR_CV_O_ | C | V |  |  |  |  |  |  | C | V
1610__RA_
1610_a2ghx_RA_ | A2 | G | H | X |  |  |  |  | £ | G | H | X
1610_aghx_RA_ | A | G | H | X |  |  |  |  | A | G | H | X
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 837658d1690330033-count-functions-example
Sheet: Sheet1

Week | Day | Date | Staff | Staff | Staff | Staff | Staff |  | Notes
1 | Sat | 2023-04-01 00:00:00 |  | A/L
 | Sun | 2023-04-02 00:00:00 |  |  |  |  |  |  |  |  | False | True
 | Mon | 2023-04-03 00:00:00 |  | TTH T3 | TTH T3 |  |  |  |  |  | True | False
 | Tue | 2023-04-04 00:00:00 |  | TTH T3 | TTH T3 |  |  |  |  |  | True | False
 | Wed | 2023-04-05 00:00:00 |  | TTH T3 | TTH T3 |  |  |  |  |  | True | False
 | Thu | 2023-04-06 00:00:00 |  | TTH T3 | TTH T3 |  |  |  |  |  | True | False
 | Fri | 2023-04-07 00:00:00 |  |  |  |  |  |  |  |  | False | False
2 | Sat | 2023-04-08 00:00:00 | N/A |  | F/S |  |  |  |  |  | True | True
 | Sun | 2023-04-09 00:00:00 |  | TQS NIGHT |  |  |  |  |  |  | False | True
 | Mon | 2023-04-10 00:00:00 |  | TQS |  |  |  |  |  |  | False | False
 | Tue | 2023-04-11 00:00:00 |  | TQS |  |  |  |  |  |  | False | False
 | Wed | 2023-04-12 00:00:00 |  |  |  |  |  |  |  |  | False | False
 | Thu | 2023-04-13 00:00:00 |  |  | [NAME] |  |  |  |  |  | True | False
 | Fri | 2023-04-14 00:00:00 |  |  | [NAME] |  |  |  |  |  | True | False
3 | Sat | 2023-04-15 00:00:00 | A/L | TQS NIGHT |  |  |  |  |  |  | False | True
 | Sun | 2023-04-16 00:00:00 |  | TQS NIGHT |  |  |  |  |  |  | False | True
 | Mon | 2023-04-17 00:00:00 |  | TQS NIGHT | 7OAKS TNL DN |  |  |  |  |  | True | False
 | Tue | 2023-04-18 00:00:00 |  | TQS NIGHT | Sevenoaks Down |  |  |  |  |  | True | False
 | Wed | 2023-04-19 00:00:00 |  | 7OAKS TNL DN | 7OAKS TNL DN |  |  |  |  |  | True | False
 | Thu | 2023-04-20 00:00:00 |  | Rest - Double weekend | 7OAKS TNL DN |  |  |  |  |  | True | False
 | Fri | 2023-04-21 00:00:00 |  |  |  |  |  |  |  |  | False | False
4 | Sat | 2023-04-22 00:00:00 |  | N/A |  |  |  |  |  |  | False | True
 | Sun | 2023-04-23 00:00:00 | N/A | A/L |  |  |  |  |  |  | False | True
 | Mon | 2023-04-24 00:00:00 |  |  |  |  |  |  |  |  | False | False
 | Tue | 2023-04-25 00:00:00 |  |  |  |  |  |  |  |  | False | False
 | Wed | 2023-04-26 00:00:00 |  |  |  |  |  |  |  |  | False | False
 | Thu | 2023-04-27 00:00:00 |  | AL? |  |  |  |  |  |  | False | False
 | Fri | 2023-04-28 00:00:00 |  |  |  |  |  |  |  |  | False | False
 |  |  | Weekends Worked | Weekends Worked | Weekends Worked | Weekends Worked | Weekends Worked
Spreadsheet: 867164d1714045439-using-sum-formula-ignoring-spaces-calculate-with-out-calculating-blank
Sheet: Sheet1

 |  | 837.5
 |  | 625
 |  | 1187.5
 |  | 975
 |  | 462.5
 |  | 612.5
 |  | 525
 |  | 725
 |  | 912.5
 |  | 1662.5
 |  | 1262.5
 |  | 912.5
 |  | 537.5
 |  | 1025
 |  | 1300
 |  | 2212.5
 |  | 2212.5
 |  | 1712.5
 |  | 2087.5
 |  | 1412.5
 |  | 2525
 |  | 2462.5
 |  | 425
 |  | 287.5
 |  | 225
 |  | 325
 |  | 337.5
 |  | 412.5
 |  | 225
 |  | 162.5
 |  | 387.5
 |  | 825
 |  | 1262.5
 |  | 775
 |  | 500
 |  | 512.5
 |  | 412.5
 |  | 662.5
 |  | 1600
 |  | 2087.5
 |  | 1062.5
 |  | 1437.5
 |  | 1787.5
 |  | 1025
 |  | 2600
 |  | 1950
 |  | 1425
 |  | 562.5
 |  | 712.5
 |  | 1175
 |  | 987.5
 |  | 425
 |  | 300
 |  | 437.5
 |  | 612.5
 |  | 2275
 |  | 900
 |  | 500
 |  | 687.5
 |  | 1525
 |  | 787.5
 |  | 2612.5
 |  | 3412.5
 |  | 1650
 |  | 2100
 |  | 1375
 |  | 1837.5
 |  | 1250
 |  | 2062.5
Spreadsheet: 583890d1532720653-count-function-with-multiple-qualifying-criteria-fruit
Sheet: Sheet1

Person | Ate | Column1 | [NAME] | Apple | Orange | Fruit |  | People who ate fruit |  |  | Fruit |  |  | Given banana, apple, orange are all considered fruit
Person A | pizza, salads |  |  |  |  |  |  |  |  |  | banana |  |  | Find the headcount of people who ate fruit
Person B | burger, banana |  |  |  |  |  |  |  |  |  | apple |  |  | Person B, C, E all ate fruit, so answer should be 3
Person C | apple, orange |  |  |  |  |  |  |  |  |  | orange
Person D | sandwich
Person E | pizza, orange
Spreadsheet: 471223d1468928065-data-sorting-in-large-excel-datasheet-sample-file
Sheet: Sheet2

id | [NAME] | LogFC dataset1 | LogFC dataset2 | LogFC dataset3 | sample1 | [NAME] | sample2 | sample4 | sample5
c48746_g1_i1 | AT3G48000
c39011_g1_i1 | AT3G55410
c52131_g1_i1 | AT3G48000
c52131_g1_i2 | AT1G23800
c36910_g1_i1 | AT1G20630
c41114_g1_i1 | AT1G44170
c41146_g1_i1 | AT5G48230
c28263_g1_i1 | AT1G21430
c37028_g1_i1 | AT3G55410
c57779_g1_i1 | AT1G20630
c43690_g1_i4 | AT1G74100
c43690_g1_i2 | AT1G74100
c49224_g2_i1 | AT2G30770
c37719_g1_i1 | AT5G25620
c52423_g1_i4 | AT3G48000
c49224_g2_i6 | AT2G30770
c41383_g1_i1 | AT5G48230
c52423_g1_i2 | AT3G48000
Spreadsheet: 832321d1686257740-conditional-formatting-not-following-rules-format-error
Sheet: Chart for slides

 | Cluster 01
 | P&L | FY23 ACT | FY23 Plan | Better/ (Worse) |  | FY24 Plan | Growth |  | FY23  Act Q1 | FY24 Plan Q1 | Growth
 | Net Sales ($[NAME])
 | Avg Weekly Sales |  | 75210 |  |  |  |  |  |  | 79711
 | Restaurant Ebitda $ ($Ms)
 | Restaurant Ebitda %
 | Cost | FY23 ACT | FY23 Plan | Better/ (Worse) |  | FY24 Plan | Growth |  | FY23  Act Q1 | FY24 Plan Q1 | Growth
 | Prime Cost % |  | 0.644
 | [NAME] % |  | 0.342
 | Labor % |  | 0.302
 | Restaurant Expense %
 | Labor Hrs vs Silver | -45.3 | -13.8 |  |  |  |  |  | -12
 | Note: % Growth compared to FY23 Actuals.
 | Focus | FY23 ACT | FY23 Plan | Better/ (Worse) |  | FY24 Plan | Growth |  | FY23  Act Q1 | FY24 Plan Q1 | Growth
 | Off Premise
 | # of Orders
 | Net Sales $ ($Ms)
 | Net Sales % |  | 0.25 |  |  |  |  |  |  | 0.25
 | Dissatisfaction %
 | [NAME] % |  |  |  |  | 0.1 |  |  |  | 0.1
 | [NAME] KPIs | FY23 ACT | FY23 Plan | Better/ (Worse) |  | FY24 Plan | Growth |  | FY23  Act Q1 | FY24 Plan Q1 | Growth
 | QSC |  | 0.85 |  |  | 0.85 |  |  |  | 0.85
 | Guest Complaints |  | 0.0002 |  |  | 0.0002 |  |  | 0.0003 | 0.0002
 | Mystery Shop |  | 0.85 |  |  | 0.85 |  |  |  | 0.85
 | Black Box - Intent to Return
 | Note: % Growth compared to FY23 Actuals. Note: FY23 Actuals are YTD average.