tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 847865d1698698328-indirect-formula-to-place-images-vehicle-class-indirect-formula-003
Sheet: IMAGE PLACEMENT FORMULA

 | Key | Named [NAME] | Cell Values | Display the correct image in Cell E3 using an INDIRECT formula |  | The formula is based on the following criteria:
 | #[NAME]! | A_KEY | This is the C Key |  | Cell E3 image is correct but it should be the only Cell containing an image in [NAME] | IF [NAME] is "This is the A Key" then [NAME] in E3 |  |  |  | A | Motorcycles - 2 axles - 3 tires
 | #[NAME]! | [NAME] | This is the B Key |  |  | IF [NAME] is "This is the B Key" then [NAME] in E3 |  |  |  | B | Passenger Cars - 2 axles - can have 1 or 2 axle trailers
 | #[NAME]! | C_KEY | This is the C Key |  |  | IF [NAME] is "This is the C Key" then Display C_Key in E3 |  |  |  | C | Pickups, Panels, Vans - 2 axles - 4-tire single units - Can have 1 or 2 axle trailers
 | #[NAME]! | D_KEY | This is the D Key |  |  | IF [NAME] is "This is the D Key" then Display D_Key in E3 |  |  |  | D | Buses - 2 or 3 axles - full length
 | #[NAME]! | E_KEY | This is the E Key |  |  | IF [NAME] is "This is the E Key" then Display E_Key in E3 |  |  |  | E | Single Unit 2-axle Trucks - 2 axles - 6 tires (dual rear tires - single unit)
 | #[NAME]! | F_KEY | This is the F Key |  |  | IF [NAME] is "This is the F Key" then Display F_Key in E3 |  |  |  | F | Single Unit 3-axle Trucks - 3 axles - single unit
 | #[NAME]! | G_KEY | This is the A Key |  |  | IF [NAME] is "This is the G Key" then Display G_Key in E3 |  |  |  | G | Single Unit 4 or More-axle Trucks - 4 or more axles - single unit
 | #[NAME]! | H_KEY | This is the H Key |  |  | IF [NAME] is "This is the H Key" then [NAME] in E3 |  |  |  | H | Single Trailer 3 or 4 axle Trucks - 3 or 4 axles - single trailer
 | #[NAME]! | I_KEY | This is the I Key |  |  | IF [NAME] is "This is the I Key" then Display I_Key in E3 |  |  |  | I | Single Trailer 5 axle trucks - 5 axles - single trailer
 | #[NAME]! | J_KEY | This is the J Key |  |  | IF [NAME] is "This is the J Key" then Display J_Key in E3 |  |  |  | J | Single Trailer 6 or More axle Trucks - 6 or more axles - single trailer
 | #[NAME]! | [NAME] | This is the K Key |  |  | IF [NAME] is "This is the K Key" then [NAME] in E3 |  |  |  | K | Multi-Trailer 5 or Less-axle Trucks - 5 or less axles - multiple trailers
 | #[NAME]! | L_KEY | This is the L Key |  |  | IF [NAME] is "This is the L Key" then Display L_Key in E3 |  |  |  | L | Multi-Trailer 6 axle trucks - 6 axles - multiple trailers
 | #[NAME]! | [NAME] | This is the M Key |  |  | IF [NAME] is "This is the M Key" then Display M_Key in E3 |  |  |  | M | Multi-Trailer 7 or More-axle Trucks - 7 or more axles - multiple trailers
 | #[NAME]! | N_KEY | This is the N Key |  |  | IF [NAME] is "This is the N Key" then Display N_Key in E3 |  |  |  | N | Pedal Bike - Pedal bikes are categorized as Bicycle on Road.
Spreadsheet: 799895d1665391295-case-sensitive-with-match-while-using-arrays-help_glenn
Sheet: help

UNMATCH:
grade | location |  |  | label | value
A | US |  |  | location | MX
A | DE |  |  | grade | a
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US |  |  | client_type | D
A | DE
A | MX
B | FR |  | should be 8
B | DE
D | MX
A | FR
B | US
Spreadsheet: 737940d1624690756-rank-according-to-their-average-sales-if-active-activeranksample-ans
Sheet: Sheet1

=IFERROR(IF($J5,"ACTIVE",(RANK(G5,$G$5:$J$20),"")))
 | Photographer Bonus Qualified
 | # | UNIQUE | RANK | REV | Sessions | Average | Photographer | SITE | STATUS | Weekly Target | STATUS
 | 1 | 37987.250001 |  | 37987.25 | 14 | 2713.375 | [NAME] | S | ACTIVE | 10 | ACTIVE
 | 2 | 54637.160002 |  | 54637.16 | 22 | 2483.507272727273 | Hana | M | ACTIVE | 10 | ACTIVE
 |  |  |  | 37838.68 | 5 | 7567.736 | Haze | B | INACTIVE | 10 | INACTIVE
 | 3 | 27435.820003 |  | 27435.82 | 4 | 6858.955 | [NAME] | S | ACTIVE | 10 | ACTIVE
 | 4 | 3918.850004 |  | 3918.85 | 0 |  | Juan | M | ACTIVE | 10 | ACTIVE
 | 5 | 5e-06 |  | 0 | 0 |  | Kylie | B | ACTIVE | 10 | ACTIVE
 | 6 | 65740.140006 |  | 65740.14 | 19 | 3460.007368421052 | [NAME] | S | ACTIVE | 10 | ACTIVE
 | 7 | 46384.67000700001 |  | 46384.67000000001 | 21 | 2208.79380952381 | [NAME] | M | ACTIVE | 10 | ACTIVE
 | 8 | 4000.000008 |  | 4000 | 0 |  | Mireia | M | ACTIVE | 10 | ACTIVE
 | 9 | 23020.000009 |  | 23020 | 14 | 1644.285714285714 | [NAME] | S | ACTIVE | 10 | ACTIVE
 | 10 | 15356.29001 |  | 15356.29 | 3 | 5118.763333333333 | Satomi | M | ACTIVE | 10 | ACTIVE
 | 11 | 41913.63001099999 |  | 41913.63 | 13 | 3224.125384615385 | Seiya | S | ACTIVE | 10 | ACTIVE
 | 12 | 102936.390012 |  | 102936.39 | 20 | 5146.8195 | [NAME] | M | ACTIVE | 10 | ACTIVE
 | 13 | 12546.720013 |  | 12546.72 | 7 | 1792.388571428572 | Stelios | S | ACTIVE | 10 | ACTIVE
 | 14 | 38123.210014 |  | 38123.21 | 9 | 4235.912222222222 | Tash | S | ACTIVE | 10 | ACTIVE
 | 15 | 53851.54001499999 |  | 53851.53999999999 | 12 | 4487.628333333333 | [NAME] | M | ACTIVE | 10 | ACTIVE
Spreadsheet: 744362d1629201513-vlookup-help-trying-to-add-data-to-1-column-if-2-other-columns-match-example-worksheet
Sheet: Sheet1

 |  |  |  |  | Parlour ([NAME]) - DO NOT USE |  | Aluminium | 10 person
 |  |  |  |  | Music Room (Lower Ground) - DO NOT USE |  | Argon | 8 person
 |  |  |  |  | Drawing Room - DO NOT USE |  | Argon +Barium | 16 person
 |  |  |  |  | Gold XL (Lower Ground) |  | Arsenic | 8 person
 |  |  |  |  | Platinum (Lower Ground) |  | Barium | 8 person
 |  |  |  |  | Aluminium (Lower Ground) |  | Barium+ Cobalt | 18 person
 |  |  |  |  | Copper (Lower Ground) |  | [NAME] | 8 person
 |  |  |  |  | Library (Lower Ground) - DO NOT USE |  | Bismuth | 12 person
 |  |  |  |  | Music Room (Lower Ground) - DO NOT USE |  | Bridge | 5 person
 |  |  |  |  | Iron (1st Floor) - DO NOT USE |  | Canal | 10 person
 |  |  |  |  | Drawing Room - DO NOT USE |  | Carbon | 8 person
 |  |  |  |  | Parlour ([NAME]) - DO NOT USE |  | Cellar | 12 person
 |  |  |  |  | Library (Lower Ground) - DO NOT USE |  | Cerium | 12 person
 |  |  |  |  | Music Room (Lower Ground) - DO NOT USE |  | Cobalt | 10 person
 |  |  |  |  | Dining Room (Ground Floor) - DO NOT USE |  | Cobalt XL (Argon, Barium, Cobalt) | 26 Person
 |  |  |  |  |  |  | Copper | 8 person
 |  |  |  |  |  |  | Diamond | 18 person
 |  |  |  |  |  |  | [NAME] | 10 person
 |  |  |  |  |  |  | Dining Room | 10 person
 |  |  |  |  |  |  | Drawing Room | 10 person
Spreadsheet: 30343d1225819752-count-number-of-items-with-a-and-b-book2
Sheet: Sheet1

 | AREA | TYPE |  |  | COUNT
 | NORTH | WIN |  |  | NORTH WIN
 | NORTH | LOSE |  |  | NORTH LOSE
 | NORTH | DRAW |  |  | NORTH DRAW
 | SOUTH | WIN
 | SOUTH | LOSE
 | EAST | DRAW
 | EAST | WIN
 | WEST | LOSE
 | NORTH | LOSE
 | WEST | LOSE
 | SOUTH | DRAW
 | EAST | WIN
 | EAST | WIN
Spreadsheet: 017dbe97-1476-45b9-b170-c0c74b9cc5cc
Sheet: Sheet1

OEA-Affiliated Higher Education Institutions, 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Institution | IPEDS ID | Unit | Unit [NAME] | Year Elected | 2-or 4-Yr. | # of Campuses
Columbus State Community College, OH | 202222 | Faculty | 310 | 2001 | 2 | 2
Edison Community College, OH | 202648 | Faculty | 33 | 1985 | 2 | 1
Hocking College, OH | 203155 | Faculty | 105 | 1986 | 2 | 1
Hocking College, OH (SSP) | 203155 | Support Staff | 50 | 1986 | 2 | 1
Jefferson Community College, OH | 203331 | Faculty | 40 | 1985 | 2 | 1
Jefferson Community College, OH (SSP) | 203331 | Support Staff | 22 | 1987 | 2 | 1
Lakeland Community College, OH | 203599 | Faculty | 128 | 1978 | 2 | 1
Northwest State Community College, OH | 204440 | Faculty | 56 | 1986 | 2 | 1
Northwest State Community College, OH (SSP) | 204440 | Support Staff | 53 | 1986 | 2 | 1
Shawnee State University, OH | 205443 | Faculty | 149 | 1975 | 4 | 1
Southern State Community College, OH | 205966 | Faculty | 58 | 1985 | 2 | 6
Youngstown State University, OH (AP) | 206695 | Administrative/Professional | 157 | 1986 | 4 | 1
Youngstown State University, OH | 206695 | Faculty | 414 | 1972 | 4 | 1
Youngstown State University, OH (SSP) | 206695 | Support Staff | 397 | 1985 | 4 | 1
 |  |  | 1972
Unit [NAME] confirmation: | 2010-01-11 00:00:00
Membership Report #: | 1401 Electoral HE Count ([NAME] by Local)
Spreadsheet: 792444d1660908440-formula-with-multiple-matches-training-example-v2
Sheet: Feb 2023

Trainer | 2023-02-01 00:00:00 | 2023-02-02 00:00:00 | 2023-02-03 00:00:00 | 2023-02-06 00:00:00 | 2023-02-07 00:00:00 | 2023-02-08 00:00:00 | 2023-02-09 00:00:00 | 2023-02-10 00:00:00 | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-15 00:00:00 | 2023-02-16 00:00:00 | 2023-02-17 00:00:00 | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-02-22 00:00:00 | 2023-02-23 00:00:00 | 2023-02-24 00:00:00 | 2023-02-27 00:00:00 | 2023-02-28 00:00:00 | Training days | AL | Personal | Development
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Clive Barber
[NAME]
[NAME]
[NAME]
[NAME] R
[NAME]
Jan Nascimento
[NAME]
[NAME]
[NAME]
Clare Hazelwood
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Enforcement
Spreadsheet: 377912d1424203234-formula-to-highlight-cell-based-on-two-variables-current-rvt-students-tester
Sheet: Master

Current RVT Students - 15'-2016
 |  |  | 1st Year Courses |  |  |  |  |  |  |  | 2nd Year Courses |  |  |  |  |  |  | Last Semester Taken | Help Cell | Courses  Completed | Date of  Graduation
Last Name | First Name | ID # | AGAN 1 | AGAN 2 | [NAME] 51 | AGHE 54 | AGHE 64 | AGHE 79 | AGHE 86 | AGLI 96 | AGHE 62A | AGHE 62B | AGHE 84B | AGHE 65 | AGHE 60 | AGHE 61 | AGHE 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall
Spreadsheet: 823953d1680207798-matching-two-columns-and-returning-the-third-s666-pq-matching-two-columns-and-returning-the-third-v2
Sheet: Merge1

Date | Type | Description | Value | Category
2023-02-28 00:00:00 |  | Before UKI T/A DIRECTLINE | -20 | me
2023-03-01 00:00:00 |  | Text before UKI T/A DIRECTLINE and after | -10 | wife
2023-03-01 00:00:00 |  | Before UKI T/A DIRECTLINE | -20 | me
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE | -40 | extra
2023-03-02 00:00:00 |  | Savings Account | -50 | To Savings
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE After | -30 | dog
2023-03-03 00:00:00 |  | SAVINGS ACCOUNT | 60 | From Savings
2023-03-04 00:00:00 |  | before BRITISH GAS after | -20 | me
2023-03-05 00:00:00 |  | WATER | -150 | Energy
2023-03-09 00:00:00 |  | 09MAR23 CD , TESCO STORES 2167, | 12.45
2023-03-10 00:00:00 |  | CD , TESCO STORES 1234 | 14.2
2023-03-16 00:00:00 |  | 16MAR23 , AMZNMKTPLACE, AMAZON.CO.UK | 22.22
2023-03-18 00:00:00 |  | 18MAR23 CD , SAINSBURYS S/MKTS , LONDON | 13.2
Spreadsheet: 133020d1324090828-populating-a-table-from-a-dynamic-list-selection-populating-a-table-from-a-dynamic-list-selection
Sheet: Sheet2

Hook Selection | Date Selection |  | X | Y | Z
Hook -003 | 2011-04-11 00:00:00 | b
 |  | x
 |  | x2
 |  | [NAME]
 |  | y
 |  | xy
 |  | y2
 |  | y3
 |  | z
 |  | xz
 |  | yz
 |  | z2
 |  | z3
Spreadsheet: 717254d1612542821-allocating-multiple-quantities-items-into-multiple-pots-based-on-cost-book5
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Basket Types
Type A | 6 | 8B |  |  |  |  | apples | bananas | oranges | melon |  | Type A | Type B | Type C | Type D | Type E
Type B | 7 | 8O |  |  |  | day 1 | 18 | 15 | 10 | 5
Type C | 5 | 2B + 2O |  |  |  | day 2
Type D | 4 | 4A+2O |  |  |  | day 3
Type E | 12 | 18A + 6M + 2O |  |  |  | day 4
 |  |  |  |  |  | day 5
 |  |  |  |  |  | day 6
 |  |  |  |  |  | day 7
 |  |  |  |  |  | day 8
 |  |  |  |  |  | day 9
 |  |  |  |  |  | day 10
 |  |  |  |  |  | day 11
 |  |  |  |  |  | day 12
 |  |  |  |  |  | day 13
 |  |  |  |  |  | day 14
 |  |  |  |  |  | day 15
 |  |  |  |  |  | day 16
 |  |  |  |  |  | day 17
 |  |  |  |  |  | day 18
 |  |  |  |  |  | day 19
 |  |  |  |  |  | day 20
 |  |  |  |  |  | day 21
 |  |  |  |  |  | day 22
 |  |  |  |  |  | day 23
 |  |  |  |  |  | day 24
 |  |  |  |  |  | day 25
 |  |  |  |  |  | day 26
 |  |  |  |  |  | day 27
 |  |  |  |  |  | day 28
 |  |  |  |  |  | day 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basket Totals
Spreadsheet: 37540d1235581319-conditional-formatting-comparing-data-in-pivot-table-pivot_table
Sheet: PIVOT_TABLE

 |  |  |  |  |  |  | END RESULT AFTER FORMATTING
 |  | Values |  |  |  |  |  |  | Values
PRODUCT FAMILY | PRODUCT | Sum of STOCK | Sum of SALES |  |  |  | PRODUCT FAMILY | PRODUCT | Sum of STOCK | Sum of SALES
FRUIT | APPLE | 100 | 150 |  |  |  | FRUIT | APPLE | 100 | 150
 | BANANA | 200 | 10 |  |  |  |  | BANANA | 200 | 10
 | ORANGE | 50 | 7 |  |  |  |  | ORANGE | 50 | 7
FRUIT Total |  | 350 | 167 |  |  |  | FRUIT Total |  | 350 | 167
MISC | MILK | 10 | 28 |  |  |  | MISC | MILK | 10 | 28
 | VODKA | 500 | 50 |  |  |  |  | VODKA | 500 | 50
MISC Total |  | 510 | 78 |  |  |  | MISC Total |  | 510 | 78
VEGETABLE | CARROT | 30 | 2 |  |  |  | VEGETABLE | CARROT | 30 | 2
 | ONION | 30 | 15 |  |  |  |  | ONION | 30 | 15
 | PATATO | 30 | 20 |  |  |  |  | PATATO | 30 | 20
VEGETABLE Total |  | 90 | 37 |  |  |  | VEGETABLE Total |  | 90 | 37
Grand Total |  | 950 | 282 |  |  |  | Grand Total |  | 950 | 282
Spreadsheet: 55438d1255547080-date-references-copy2-of-powertrain-predictor-working_oct2009
Sheet: TransMeter

COMPONENT | CPARTNO | CUSAGE | MILEAGE | Jan 00 | Jan 01 | Jan 02 | Jan 03 | 39908 | 39909 | 39910 | 39911 | 39912 | 39913 | 39914 | 39915 | 39916 | 39917 | 39918 | 39919 | 39920 | 39921 | 39922 | 39923 | 39924 | 39925 | 39926 | 39927 | 39928 | 39929 | 39930 | 39931 | 39932 | 39933 | 39934 | 39935 | 39936 | 39937 | 39938 | 39939 | 39940 | 39941 | 39942 | 39943 | 39944 | 39945 | 39946 | 39947 | 39948 | 39949 | 39950 | 39951 | 39952 | 39953 | 39954 | 39955 | 39956 | 39957 | 39958 | 39959 | 39960 | 39961 | 39962 | 39963
 | 13801555 | 25681 | 326911
 | 13801500 | 94983 | 325125
Spreadsheet: 879785d1727341234-dont-duplicate-scores-in-a-row-when-conditional-formatting-sample-sheet_format-duplicates-
Sheet: Sheet1

Pos'n | Name | Ort 03/04 | TW 10/04 | Elt 17/04 | G-V 24/04 | [NAME] | Cor 08/05 | Ram 15/05 | TW 22/05 | [NAME] | [NAME] | Spa 12/06 | TW 19/06 | Rut 25/06 | TW 03/07 | Woo 10/07 | Pid 17/07 | Tho 24/07 | Sto 31/07 | Oun 07/08 | Elt 14/08 | TW 21/08 | Ort 28/08 | Played | Total Best 10 | Total | Ave | Low | 11th Best
1 | Player 1 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34
2 | Player 2 | 22 | 23 | 24 | 22 | 23 | 24 | 25 | 26 | 28 | 31 | 31 | 31 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
3 | Player 3 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 34 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44
4 | Player 4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 13 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
5 | Player 5 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 34 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44
6 | Player 6 | 31 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 22 | 22 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10
7 | Player 7 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45
 | AVERAGE
Spreadsheet: 36873d1234847038-excel-2007-how-do-i-reference-a-min-value-in-another-spreadsheet-discrete-measures
Sheet: SL

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 722713d1615384401-difference-between-dates-in-days-when-one-date-is-blank-calculate-days-to-resolution
Sheet: Sample

Opened | Resolved | Aging
2021-01-10 08:15:13 | 2021-01-11 14:45:33
2021-01-10 09:31:11 | 2021-01-11 04:41:28
2021-01-10 10:49:25 | 2021-01-13 11:15:37
2021-01-10 20:19:23 | 2021-01-13 13:52:40
2021-01-10 21:19:08
2021-01-11 01:21:01 | 2021-01-13 12:36:15
2021-01-11 02:02:50 | 2021-02-16 05:32:36
2021-01-11 04:02:23 | 2021-01-11 06:03:27
2021-01-11 08:22:40 | 2021-01-11 14:59:16
2021-01-11 08:44:45 | 2021-01-14 08:48:35
2021-01-11 08:46:10 | 2021-02-16 05:33:22
2021-01-11 09:04:18 | 2021-01-14 07:30:42
2021-01-11 09:47:22 | 2021-01-11 10:46:42
2021-01-11 09:48:36
2021-01-11 09:51:34 | 2021-01-14 09:11:30
2021-01-11 11:30:44 | 2021-01-11 17:55:54
2021-01-11 12:05:50 | 2021-02-16 05:34:12
2021-01-11 12:08:31 | 2021-01-13 17:48:15
2021-01-11 12:55:17 | 2021-01-14 14:39:35
2021-01-11 13:48:32
2021-01-11 14:05:04
2021-01-11 14:07:38
2021-01-11 14:29:42
2021-01-11 15:46:12 | 2021-01-12 14:14:49
2021-01-11 15:51:15 | 2021-01-13 07:03:43
2021-01-11 16:22:45 | 2021-01-13 17:05:58
2021-01-11 17:00:18 | 2021-01-12 01:42:40
2021-01-11 17:12:34
2021-01-11 17:51:44 | 2021-01-19 14:27:19
2021-01-11 19:15:43 | 2021-01-13 13:55:50
2021-01-12 02:42:15 | 2021-01-13 17:38:17
2021-01-12 06:22:06 | 2021-01-13 17:41:54
2021-01-12 07:06:00 | 2021-01-19 11:15:49
2021-01-12 12:38:13
2021-01-12 12:45:04 | 2021-01-12 15:38:25
2021-01-12 13:26:06 | 2021-02-16 05:34:54
2021-01-12 13:29:10 | 2021-01-19 20:31:03
2021-01-25 12:50:36 | 2021-03-06 11:45:56
2021-01-25 14:10:18 | 2021-03-04 02:19:26
Spreadsheet: 837429d1690178837-need-a-formula-that-adds-interval-to-last-visit-date-sample40
Sheet: Sheet1

 |  | Table 1 |  |  | Table 2
 |  | Last Visit | Category |  | Category | Interval | Interval2
 |  | 2023-06-17 00:00:00 | AB |  | AB | 2 | Month
 |  | 2023-07-09 00:00:00 | AVB |  | AVB | 3 | Month
 |  | 2023-07-13 00:00:00 | SYT |  | SYT | 1 | Year
 |  |  |  |  | Table 3
 |  |  |  |  | Due Date
 |  |  |  |  | Category | Due Date
 |  |  |  |  | AB | 2023-08-17 00:00:00
 |  |  |  |  | AVB | 2023-10-09 00:00:00 | 2023-10-09 00:00:00
 |  |  |  |  | SYT | 2024-07-13 00:00:00 | 2024-07-13 00:00:00
Spreadsheet: 806951d1669692890-overtime-hours-with-rules-and-limits-vlookup-for-overtime-hrs
Sheet: OT HOURS

NAME | DAY | IN | OUT | HRS | Vlookup True |  |  |  | OT HRS
DOE, [NAME] | 6 | 15:00:00 | 22:10:00 |  |  |  |  |  | Rule: | 3 hours, with 1 hour required break after every 3 hours, not more than 12 hours
 | 10 | 12:00:00 | 19:30:00
 | 11 | 16:00:00 | 19:15:00
 | 12 | 16:00:00 | 19:20:00 |  |  |  | Lookup Table |  | CONDITION | RESULT
 | 13 | 17:00:00 | 22:35:00 |  |  |  | 0 | 0 | IF <=3 | AS IS
 | 14 | 14:20:00 | 19:45:00 |  |  |  | 3 | 0 | IF >3, <=4 | 3 HOURS (that is, 4 hours less 1 hour break)
 | 17 | 16:00:00 | 18:30:00 |  |  |  | 4 | 1 | IF >4, <=7 | LESS ONE HOUR
 | 18 | 17:00:00 | 20:00:00 |  |  |  | 7 | 1 | IF >7, <=8 | 6 HOURS (that is, 8 hours less 2 hours break)
 | 19 | 15:00:00 | 19:51:00 |  |  |  | 8 | 2 | IF >8, <=11 | LESS TWO HOURS
 | 20 | 17:00:00 | 20:00:00 |  |  |  | 12 | 3 | IF >11, <=12 | 9 HOURS (that is, 12 hours less 3 hours break)
 | 24 | 15:01:00 | 20:00:00 |  |  |  |  |  | IF >12 | 12 HOURS (maximum allowed amount)
 | 25 | 15:00:00 | 18:06:00
 | 26 | 13:28:00 | 18:08:00
 | 27 | 15:00:00 | 18:41:00
 | 28 | 17:14:00 | 20:00:00
Spreadsheet: 788571d1658549007-sumifs-for-ltm-revenue-over-unique-customer-book1
Sheet: Calculation

InvoiceDate | Invoice Amount | Customer Name |  |  | 2022-05-01 00:00:00
2021-01-04 00:00:00 | 0 | Illinois Eye Center |  | Clean Customer Name | 2022
2021-01-21 00:00:00 | 600 | Illinois Eye Center |  | Illinois Eye Center |  | --> Should not be zero here
2021-01-21 00:00:00 | 0 | Illinois Eye Center |  | [NAME] |  | --> Should not be zero here
2021-02-11 00:00:00 | 195.6 | Illinois Eye Center
2021-02-24 00:00:00 | 864 | Illinois Eye Center
2021-02-24 00:00:00 | 284.7 | Illinois Eye Center
2022-04-14 00:00:00 | 719.2 | Illinois Eye Center
2022-05-18 00:00:00 | 495 | Illinois Eye Center
2022-05-18 00:00:00 | 899 | Illinois Eye Center
2021-01-04 00:00:00 | 132 | [NAME]
2022-07-14 00:00:00 | 95 | [NAME]
Spreadsheet: judy_townsend__17724__Spinnake03-002 Revision_1
Sheet: BRAZ 368

 | SPINNAKER EXPLORATION COMPANY, L.L.C.
 | BRAZOS 368
 | BASELOAD VOLUME:
 | EXCESS VOLUME ABOVE:
 | BASELOAD MINIMUM: |  |  |  | VOLUME | HSC |  |  | BTU
 |  |  |  |  | BELOW | GAS DAILY |  |  | FACTOR
 |  | ACTUALS - | BASELOAD | EXCESS | BASELOAD | MID POINT $ |  | KEEP WHOLE | of
 |  | [ASSUME MO TOTAL/DAYS] |  | VOLUME | MINIMUM | LESS $0.08 |  | AMOUNT | 1.023929
 | 2001-03-01 00:00:00 | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 |  | 595.387096
 | avg
 |  |  | CHECK
 |  | BASELOAD  $ AMOUNT
 |  | EXCESS $ AMOUNT
 |  | KEEP WHOLE AMOUNT
Spreadsheet: 801858d1666438014-how-do-i-apply-rows-of-many-formulas-to-a-list-of-many-words-hd
Sheet: Sheet1

[CITY] restaurant | london
restaurant in [CITY] | berlin |  |  | restaurant in london
fine dining [CITY] | tokyo |  |  | fine dining london
[CITY] cuisine | munich |  |  | london cuisine
 | madrid |  |  | berlin restaurant
 | lisbon |  |  | restaurant in berlin
 | jakarta |  |  | fine dining berlin
 | barcelona |  |  | berlin cuisine
 |  |  |  | tokyo restaurant
 |  |  |  | restaurant in tokyo
 |  |  |  | fine dining tokyo
 |  |  |  | tokyo cuisine
 |  |  |  | munich restaurant
 |  |  |  | restaurant in munich
 |  |  |  | fine dining munich
 |  |  |  | [NAME]
 |  |  |  | madrid restaurant
 |  |  |  | restaurant in madrid
 |  |  |  | fine dining madrid
 |  |  |  | madrid cuisine
 |  |  |  | lisbon restaurant
 |  |  |  | restaurant in lisbon
 |  |  |  | fine dining lisbon
 |  |  |  | [NAME]
 |  |  |  | jakarta restaurant
 |  |  |  | restaurant in jakarta
 |  |  |  | fine dining jakarta
 |  |  |  | jakarta cuisine
 |  |  |  | barcelona restaurant
 |  |  |  | restaurant in barcelona
 |  |  |  | fine dining barcelona
 |  |  |  | [NAME]
Spreadsheet: 112068d1308238019-format-for-logical-formula-based-on-certain-conditions-trip-budget
Sheet: Lookup List

IFA Staff | IFA Client | Expense
Blake | [NAME] | Transportation
[NAME] | [NAME] | Flight
[NAME] | [NAME] | Food
[NAME] | [NAME] | Tickets
 | [NAME] | Hotel
 | [NAME]
 | [NAME]
 | Adrian Clayborn
 | [NAME]
 | [NAME]
 | [NAME]
 | PJ Hill
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Logan Payne
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 703539d1605035052-extract-rows-from-table-that-match-criteria-in-one-column-team-book-example
Sheet: Master

 | Name | [NAME] | Phone | Team
 | [NAME] |  | 1231231234 | Ushers
 | [NAME] |  | 1111111111 | Ushers
 | Mark |  | 2222222222 | Ushers, Safety
 | [NAME] |  | 3333333333 | Prayer Partners, Ushers
 | [NAME] |  | 4444444444 | Prayer Partners
 | Timothy |  | 5555555555 | Safety
 | [NAME] |  | 6666666666 | Safety, Ushers
 | [NAME] |  | 7777777777 | Prayer Partners
 | [NAME] |  | 8888888888 | Prayer Partners
 | [NAME] |  | 9999999999 | Safety