tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854565d1704388250-simplifying-complex-formula-test-gk3-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1,2 | 4,9,19,25 | 4,10,14,22 | 4,13,19,23 | 4,17,19,24 | 1,14,23,24 |  |  | 1,2 | 4,9,19,25 | 4,10,14,22 | 4,13,19,23 | 4,17,19,24 | 1,14,23,24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 25 | 0 | 9 | 35 |  |  | 3 | 6 | 25 | 0 | 9 | 35
y/n | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z
y | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0
y | 10 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2
n | 12 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
y | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
y | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
n | 18 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
n | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2
y | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2
y | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22
y | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2
y | 20 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22
y | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22
n | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2
y | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0
y | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0
y | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0
y | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0
Spreadsheet: 142659d1329946751-drop-down-lists-and-hyperlinks-to-other-sheets-sample-sheet
Sheet: BEL

Community Code: | BEL
Community Name: | BEL-TRALEE
County: | BOONE
City/Township: | UNION |  | Requirements
 |  | Builder: | 0
 |  | Developer: | 0
 |  | Community: | 0
 |  | HOA: | 0
 |  | PUD: | 0
 |  | City/Twp.: | Front Yard: 40 ft. Side Yard: min 7 ft.  Total Side:15 ft.    Rear Yard: 30 ft.
 |  | County: | 0
 |  | State: | [NAME] is required with four or more risers  8' and 9' garage doors allowed
Spreadsheet: 308952d1396497422-how-to-sum-data-using-a-x-axis-critieria-and-a-y-axis-critieria-book1
Sheet: Sheet1

 | one | two | trhee | four | five
a | 1 | 2 | 3 | 4 | 5
b | 6 | 7 | 8 | 9 | 10
c
a
b
c
 | a | b | c
one
two
three
four
five
Spreadsheet: jeffrey_a_shankman__13966__MgmtSum-Q401-Global-102601
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIVATE & CONFIDENTIAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4th QTR 2001 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT |  |  |  | Change - Fav / (Unfav)
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Margin | Expenses (1) | Total
Crude & Products
Coal / Emissions
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight
LNG
Puerto Rico
Japan
Drift
Finance and Structuring
Credit Reserve |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0
Office of the Chairman
Overview
Subtotal Commercial
Financing Related |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  | 0
Group Cost |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0
Support Cost Allocated to Teams |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0
Other Interest Related Charges |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Capital Charge Offset |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Global Markets EBIT
Interest Expense/(Income) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Global Markets Pre-tax Income
(1) Includes direct and allocated expenses
Spreadsheet: 171639d1343811206-change-data-to-number-format-sample-data
Sheet: Sheet

Num | Amount
1 | 5.50
1 | 4.90
1 | 4.25
1 | 5.10
1 | 2.50
1 | 2.60
1 | 0.20
1 | 15.35
1 | 2.65
1 | 1.00
1 | 0.10
2 | 1.00
2 | 2.00
2 | 0.75
2 | 3.60
2 | 4.95
2 | 1.25
2 | 10.80
2 | 2.25
2 | 13.65
2 | 12.40
2 | 0.50
2 | 2.30
3 | 3.00
3 | 0.20
3 | 0.75
3 | 10.75
3 | 2.00
3 | 0.30
3 | 0.55
3 | 2.95
3 | 0.20
3 | 7.85
3 | 1.00
3 | 0.75
4 | 4.25
4 | 2.25
4 | 2.75
4 | 1.25
4 | 2.50
4 | 1.75
4 | 3.25
4 | 1.55
4 | 1.15
4 | 2.10
4 | 1.25
4 | 4.30
5 | 2.65
5 | 3.35
5 | 3.05
5 | 2.75
5 | 3.30
5 | 6.50
5 | 11.25
5 | 2.05
5 | 4.90
5 | 6.25
5 | 4.55
5 | 7.75
6 | 12.50
6 | 1.50
6 | 5.90
6 | 2.75
6 | 1.95
6 | 2.00
6 | 1.05
7 | 3.10
7 | 3.30
7 | 4.60
7 | 0.15
7 | 3.00
7 | 0.30
7 | 5.25
7 | 0.50
7 | 2.50
7 | 10.40
7 | 4.50
7 | 0.75
8 | 10.90
8 | 3.05
8 | 0.10
8 | 4.25
8 | 1.50
8 | 3.05
9 | 1.00
9 | 0.75
9 | 1.25
9 | 0.90
9 | 7.20
9 | 3.45
9 | 1.25
9 | 1.25
9 | 2.35
10 | 0.75
10 | 0.30
10 | 0.40
10 | 3.70
10 | 1.25
10 | 0.30
10 | 0.50
10 | 5.10
10 | 7.25
10 | 4.40
10 | 5.70
10 | 14.70
11 | 1.00
11 | 10.45
11 | 11.25
11 | 0.05
11 | 0.50
11 | 2.20
11 | 7.30
11 | 2.20
11 | 6.60
11 | 1.10
11 | 9.05
11 | 7.05
12 | 1.25
12 | 0.30
12 | 2.00
12 | 5.65
12 | 4.75
12 | 4.35
12 | 5.10
12 | 7.20
12 | 1.65
12 | 10.00
12 | 0.20
12 | 12.35
13 | 2.25
13 | 2.25
13 | 1.15
13 | 0.25
13 | 3.40
13 | 2.50
13 | 0.10
13 | 0.75
13 | 0.10
13 | 5.80
13 | 2.80
13 | 7.20
Spreadsheet: kay_mann__19199__501D5A Transfer Price w CALME Actuals
Sheet: New 501D Transfer

Transfer Price for 501D Turbines |  |  | Prior to 1/1/01 | After 1/1/01
 |  | Projected Interest Rate (Annual) | 0.065 | 0.09
As of |  | Projected Interest Rate (Daily)
 |  | Total Facility Amount
2001-06-30 00:00:00 |  | Basis | 365
 |  | Date | Drawdown % | Drawdown Amount | Accrued Interest | Balance
Milestone Payment |  | 1998-12-14 00:00:00 |  | 1208942
Accrued Interest | 12/14/98 -12/28/99 | 1999-12-28 00:00:00
Milestone Payment |  | 1999-12-28 00:00:00 |  | 1328
Accrued Interest | 12/29/98 - 4/14/99 | 1999-04-14 00:00:00
Milestone Payment |  | 1999-04-14 00:00:00 |  | 2418050
Milestone Payment |  | 1999-04-14 00:00:00 |  | 2408700
Accrued Interest | 4/15/99 - 5/13/99 | 1999-05-13 00:00:00
Milestone Payment |  | 1999-05-13 00:00:00 |  | 2408700
Accrued Interest | 5/14/99 - 5/25/99 | 1999-05-25 00:00:00
Milestone Payment |  | 1999-05-25 00:00:00 |  | 2408700
Accrued Interest | 5/26/99 - 7/15/99 | 1999-07-15 00:00:00
Milestone Payment |  | 1999-07-15 00:00:00 |  | 1806525
Accrued Interest | 7/16/99 -8/13/99 | 1999-08-13 00:00:00
Milestone Payment |  | 1999-08-13 00:00:00 |  | 1806525
Milestone Payment |  | 1999-08-13 00:00:00 |  | 1204350
Accrued Interest | 8/14/99 - 10/15/99 | 1999-10-15 00:00:00
Milestone Payment |  | 1999-10-15 00:00:00 |  | 1204350
Milestone Payment |  | 1999-10-15 00:00:00 |  | 1204350
Accrued Interest | 10/16/99 - 11/18/99 | 1999-11-18 00:00:00
Milestone Payment |  | 1999-11-18 00:00:00 |  | 602175
Accrued Interest | 11/19/99 - 12/20/99 | 1999-12-20 00:00:00
Milestone Payment |  | 1999-12-20 00:00:00 |  | 602175
Accrued Interest | 12/21/99 - 12/23/99 | 1999-12-23 00:00:00
Milestone Payment |  | 1999-12-23 00:00:00 |  | 651854
Accrued Interest | 12/24/99 - 1/26/00 | 2000-01-26 00:00:00
Milestone Payment |  | 2000-01-26 00:00:00 |  | 602175
Accrued Interest | 1/27/00 - 3/02/00 | 2000-03-02 00:00:00
Milestone Payment |  | 2000-03-02 00:00:00 |  | 602175
Accrued Interest | 3/03/00 - 4/07/00 | 2000-04-07 00:00:00
Milestone Payment |  | 2000-04-07 00:00:00 |  | 602175
Accrued Interest | 4/08/00 - 6/16/00 | 2000-06-16 00:00:00
Milestone Payment |  | 2000-06-16 00:00:00 |  | 1204350
Accrued Interest | 6/17/00 - 9/30/00 | 2000-09-30 00:00:00
Accrued Interest | 10/1/00 - 12/31/00 | 2000-12-31 00:00:00 |  |  | 299843.1362555811
Accrued Interest | 1/1/01 - 1/29/01 | 2001-01-29 00:00:00 |  |  |  |  | 25175551.73205
Accrued Interest | 1/30/01 - 6/30/01 | 2001-06-30 00:00:00
Milestone Payment |  | 2001-06-30 00:00:00
Column Totals
Ending Balance
Total per Turbine
1 Assume 6.5%/p.a. flat interest rate prior to 1/1/01 and 9.0%/p.a. flat interest rate after 1/1/01. |  |  |  |  | CALME Calculated Payoff Amount as of 1/29/01
2 Assume contract price includes $419,000 change order. |  |  |  |  | Transfer Price [NAME] as of 1/29/01
 |  |  |  |  | [NAME]
Spreadsheet: 836000d1689030360-multicriteria-lookup-needed-accruallookupsample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Desired
 | Lookup Table |  |  |  | Actual Data |  |  |  | Results
 | PTO |  | Accrual |  | Employee | PTO | Actual |  | Accrual
 | Plan | Tenure | Factor |  | ID | Plan | Tenure |  | Factor
 | 26 | 0 | 0.14231 |  | A | 26 | 0.42 |  | 0.14231
 | 31 | 1 | 0.12308 |  | B | 26 | 4.8 |  | 0.14231 | 0.14231
 | 31 | 5 | 0.14231 |  | C | 31 | 0.6 |  | 0 | 0
 | 36 | 1 | 0.10385 |  | D | 31 | 1.8 |  | 0.12308 | 0.12308
 | 36 | 5 | 0.12308 |  | E | 31 | 5.9 |  | 0.14231 | 0.14231
 | 36 | 10 | 0.14231 |  | F | 36 | 0.27 |  | 0 | 0
 |  |  |  |  | G | 36 | 2.9 |  | 0.10385 | 0.10385
 |  |  |  |  | H | 36 | 5.4 |  | 0.12308 | 0.12308
 |  |  |  |  | J | 36 | 9.9 |  | 0.12308 | 0.12308
 |  |  |  |  | K | 36 | 10.5 |  | 0.14231 | 0.14231
 | Need to find the accrual factor in the lookup table where the plan in column G is the same as column B
 | AND the last match where actual tenure in column H is > than the tenure in column C
 | If it's not found then return 0
Spreadsheet: 166423d1341583354-copy-cell-data-from-one-w-sheet-to-another-with-unused-cells-left-blank-book1example
Sheet: Sheet2

Place Name | Date
Spreadsheet: 724905d1616438017-use-datedif-to-count-the-total-between-days-in-a-range-example-1-
Sheet: Sheet2

 |  | TODAYS DATE
Completed Date | Due Date
 | 2020-12-20 00:00:00
 | 2021-03-01 00:00:00
 | 2021-03-10 00:00:00
 | 2021-01-20 00:00:00
 | 2021-02-10 00:00:00
 | 2021-02-25 00:00:00
 | 2021-02-25 00:00:00
 | 2021-03-01 00:00:00
 | 2021-02-15 00:00:00
 | 2021-03-02 00:00:00
 | 2021-03-01 00:00:00
 |  | looking for this --->
 |  | record set changes offten more or less
Spreadsheet: 783887d1655275994-pick-unique-values-from-column-list-count-fruit-aligw
Sheet: Sheet1

Order Date | Fruit | Quantity |  |  |  | Date | Fruit | Total Quantity per day
2022-06-14 00:00:00 | Apple | 2 |  |  |  |  | Apple
2022-06-14 00:00:00 | Apple | 3 |  |  |  | 2022-06-14 00:00:00 | Orange
2022-06-14 00:00:00 | Orange | 4 |  |  |  | 2022-06-13 00:00:00 | Apple
2022-06-13 00:00:00 | Apple | 2 |  |  |  | 2022-06-12 00:00:00 | Apple
2022-06-12 00:00:00 | Apple | 4 |  |  |  | 2022-06-12 00:00:00 | Orange
2022-06-12 00:00:00 | Orange | 3 |  |  |  | 2022-06-11 00:00:00 | Apple
2022-06-11 00:00:00 | Apple | 1 |  |  |  | 2022-06-10 00:00:00 | Apple
2022-06-10 00:00:00 | Apple | 2
2022-06-10 00:00:00 | Apple | 3
Spreadsheet: 864995d1712116638-sum-single-vs-combined-cell-values-test2
Sheet: Sheet1

Group | Area | Total/group
A1 | 10 |  | so im looking for a formula that can sum up  values until the group changes. So it would sum the values that belong to the same group
A1 | 20
A2 | 10
A3 | 30
A4 | 5
A4 | 10
A4 | 5
A5 | 10
A6 | 5
A7 | 10
A7 | 10
A8 | 5
A9 | 10
Spreadsheet: 624744d1558048733-help-calendar-correction-employee-absence-schedule-current
Sheet: June 1

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | January | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee 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 | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 |  |  |  | V | V | V | V |  |  |  |  |  |  | V |  |  | s | s |  | p |  | s | s | p | p | p |  |  | p
 |  |  |  |  |  | S | S |  |  |  |  | P |  |  |  |  |  |  |  |  | S |  |  | v |  | V | V | V
 |  |  |  | P | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s |  |  |  | s | s | s | s | s | S
 |  |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  | V | V | V
 |  | v | v | v |  |  |  |  |  |  |  |  |  | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | V
 |  |  |  |  |  | v
Spreadsheet: 216056d1361567476-how-to-generate-multiple-statements-from-single-table-excel-sample-file
Sheet: Datasheet

CS | DATE | Therapist Code | Therapist First Name | Therapist Surname | CLIENT FIRST | CLIENT SURNAME | FULL NAME |  | Product | Gross £ | VAT | NET | Commission | Tip
CS | 2013-01-08 00:00:00 | JA1 | Jessica | Aiken | [NAME] | Reilly |  | m1 | Massage | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 10
CS | 2013-01-09 00:00:00 | JA1 | Jessica | Aiken | [NAME] | Gilchrist |  | HN1 | Hair & Nails | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-01-23 00:00:00 | KJ1 | [NAME] | Jones | [NAME] | Kapshaw |  | HN1 | Hair & Nails | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-01-20 00:00:00 | TM1 | Trevor | McGuiness | [NAME] | Bourne |  | m1 | Massage | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-01-19 00:00:00 | JS1 | [NAME] | [NAME] | [NAME] | Olsom |  | C1 | Cut | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-01-04 00:00:00 | AS1 | [NAME] | Smith | [NAME] | Reilly |  | m1 | Massage | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 20
CS | 2013-01-04 00:00:00 | AS1 | [NAME] | Smith | [NAME] | Reilly |  | m1 | Massage | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-01-11 00:00:00 | AS1 | [NAME] | Smith | [NAME] | Reilly |  | m1 | Massage | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-02-11 00:00:00 | AS1 | [NAME] | Smith | [NAME] | Reilly |  | m1 | Massage | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 15
CS | 2013-02-15 00:00:00 | AS1 | [NAME] | Smith | Nikki | Jefferies |  | HN1 | Hair & Nails | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-01-15 00:00:00 | AS1 | [NAME] | Smith | Nikki | Jefferies |  | HN1 | Hair & Nails | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-01-18 00:00:00 | AS1 | [NAME] | Smith | [NAME] | Reilly |  | m1 | Massage | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-02-18 00:00:00 | AS1 | [NAME] | Smith | [NAME] | Reilly |  | m1 | Massage | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
CS | 2013-01-19 00:00:00 | MW1 | Mark | [NAME] | [NAME] | Olsom |  | C1 | Cut | 80 | 13.33333333333334 | 66.66666666666666 | 39.99999999999999 | 0
Spreadsheet: 886032d1735978123-lookup-value-in-table-from-text-string-containing-those-values-and-redundant-information-get-model-code
Sheet: Sheet1

Raw Data List |  |  |  | Table (in separate tab of constants)
Description | Returned code |  |  | Lookup Value | Code to return
Caramel IceCream made of whatever | CO |  |  | Fudge | SW
Apple fudge and other things | SW |  |  | IceCream | CO
Socket and other detail wrench | HA |  |  | Items | OT
Other Items in a lengthy description | OT |  |  | Wrench | HA
2000 more rows of model descriptions | etc
All rows are expected to be represented in the summary list of about 20 codes - so many multiple occurrences of return code in raw data list
Spreadsheet: 854187d1704158551-function-to-track-gain-loss-for-weight-bf-bmi-bone-mass-etc-body-measurement-tracker
Sheet: Sheet1

DATE | WEIGHT | BF % | MUSCLE % | PROTEIN MASS lbs | B M I | BONE MASS lbs | VISCERAL INDEX | FAT MASS | METABOLIC AGE
2024-01-01 00:00:00 | 190.5 | 30.8 | 65.5 | 28.4 | 27.6 | 7.1 | 9 | 58.6 | 59
2024-01-15 00:00:00
2024-02-01 00:00:00
2024-02-15 00:00:00
2024-03-01 00:00:00
2024-03-15 00:00:00
2024-04-01 00:00:00
GOAL | 155 | 0.23 | <70 | <45 | <22 | >5.7 | 9 | <55 | <55
DIFFERENCE | + / - Weight | + / - BF% |  |  | + / - BMI |  |  | + / - Fat Mass
^^^^^Enter formulas here w/red as a loss in weight and black for a gain, using the start weight at 01/01/2024 as the constant.^^^^^
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.18.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-18 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 0 | 1 | 0 | 1 | 1 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 22 | 0 | 4 | 1 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 16 | 0 | 5 | 1 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 2 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0 | ABC
 | Total Holds MID |  |  | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-18 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 9 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 22 | 0 | 4 | 1 | 0 | 0 | 2 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 4 | 2 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 9 | 0 | 4 | 0 | 2 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 2 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 1 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0 | 1 to admit
 | Total House Census
Spreadsheet: 786833d1657482580-formulas-in-excel-for-checking-specific-days-in-month-counting-them-excel_for_correction
Sheet: Summary

LP | Name and Surname | Dates for day of week | Count of days | Which day | Month
1 | [NAME] Johnson1 | 4.07, 11.07, 18.07, 25.07 | 4 | Monday | July
2 | [NAME] | 5.07, 12.07, 19.07, 26.07 | 4 | Tuesday | July
3 | [NAME] Johnson3 | 6.07, 13.07, 20.07, 27.07 | 4 | Wednesday | July
4 | [NAME] Johnson4 | 7.07, 14.07, 21.07, 28.07 | 4 | Thursday | July
5 | [NAME] Johnson5 | 1.07, 8.07, 15.07, 22.07, 29.07 | 5 | Friday | July
6 | [NAME] Johnson6 | 2.07, 9.07, 16.07, 23.07, 30.07 | 5 | Saturday | July
Spreadsheet: 879510d1727089717-sort-funtion-sample-file
Sheet: Data

Doc Date | Delivered Date |  |  | required |  | sort
2024-04-01 00:00:00
2024-04-03 00:00:00 |  |  |  |  |  | 2024-04-03 00:00:00
2024-04-06 00:00:00 | 2024-04-07 00:00:00 |  |  |  |  | 2024-04-06 00:00:00
2024-04-06 00:00:00 |  |  |  |  |  | 2024-04-07 00:00:00
2024-04-08 00:00:00 | 2024-04-09 00:00:00 |  |  |  |  | 2024-04-08 00:00:00
2024-04-08 00:00:00 |  |  |  |  |  | 2024-04-09 00:00:00
2024-04-12 00:00:00 |  |  |  |  |  | 2024-04-12 00:00:00
2024-04-12 00:00:00 |  |  |  |  |  | 2024-04-12 00:00:00
Spreadsheet: 867772d1714566753-generate-numbers-demo
Sheet: Sheet1

Customer Reference | Customer Name | Type | Quote Ref
TG001 | Mr [NAME] | Int | ??????
pulled from list on another tab | Pulled from col a via index match | Select from drop down
 |  | codes below
 |  | INT | [NAME]
 |  | FIRE | F101
 |  | VSS | C101
 |  | ACCESS | D101
 |  | AUTO | G101
Spreadsheet: 2ce0f1de-d68f-449e-8b4e-2b71f3862b43
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6457.0 International Trade Price Indexes, Australia
 | Table 16. Import Price Index: BEC Category, Index Numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  Food and beverages ; |  |  | Original | A2298159L | 1983-06-01 00:00:00 | 2012-09-01 00:00:00 | 118 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Industrial supplies, n.e.s. ; |  |  | Original | A2298162A | 1983-06-01 00:00:00 | 2012-09-01 00:00:00 | 118 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  [NAME] and lubricants ; |  |  | Original | [NAME] | 1983-06-01 00:00:00 | 2012-09-01 00:00:00 | 118 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Capital goods, and parts and accessories thereof ; |  |  | Original | A2298168R | 1983-06-01 00:00:00 | 2012-09-01 00:00:00 | 118 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Transport equipment, and parts and accessories thereof ; |  |  | Original | A2298171C | 1983-06-01 00:00:00 | 2012-09-01 00:00:00 | 118 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Consumer goods n.e.s. ; |  |  | Original | [NAME] | 1983-06-01 00:00:00 | 2012-09-01 00:00:00 | 118 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 291088d1390154183-locating-a-row-in-a-table-of-data-based-on-specified-parameters-locating-a-row-in-a-table-of-data-based-on-specified-parameters
Sheet: Sheet1

 |  |  |  | Interested in 2 formulas:
 |  |  |  | (1) Looking only at the dates in column C, a formula that tells me in which row the first or second or nth event occurs regardless of who responsible
 |  |  |  | (2) Looking at who is responsible for the event [Column B], a formula for identifying the first or second or nth event that is attributable to person A
 | RESPONSIBLE PERSON? | DATE OF EVENT?
 | A | 2014-02-01 00:00:00
 | A | 2014-02-17 00:00:00
 | B | 2014-02-18 00:00:00
 | C | 2014-02-21 00:00:00
 | A | 2014-02-27 00:00:00
 | B | 2014-03-02 00:00:00
 | B | 2014-03-03 00:00:00
 | C | 2014-03-07 00:00:00
 | A | 2014-03-09 00:00:00
 | B | 2014-03-11 00:00:00
 | C | 2014-03-12 00:00:00
 | B | 2014-03-19 00:00:00
 | A | 2014-03-21 00:00:00
Spreadsheet: 128146d1320817724-summarising-data-from-multiple-worksheets-example-file
Sheet: Plant B

 |  | Budget | Current Month | Year to Date | Commitments
 | Salaries | 100000 | 5000 | 50000 | 50000
 | Maintenance | 50000 | 2000 | 40000 | 10000
 | Electricity | 20000 | 1000 | 15000 | 4000
 | Stationery | 2000 | 100 | 1000 | 500
 | Postage | 1500 | 50 | 750 | 400
 | Total Costs
Spreadsheet: 811802d1672801251-auto-date-and-day-with-highlighting-sundays-and-perhaps-holidays-auto-date
Sheet: Monatsabrechnung

[NAME]
!! [NAME] WERDEN !! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
Tag |  |  | 2022-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summe | Sonntage Feiertage
[NAME] |  |  | 40
[NAME]
Bilanz
Spreadsheet: 169203d1342725363-creating-a-data-summary-from-a-matrix-example
Sheet: Schedule

 | Mon | [NAME] | Weds | Thurs | Fri
Tyler | 30 |  | 60 |  | 15
[NAME] | 15 | 60 | 30
[NAME] |  | 30 |  | 60 | 15
Enrique |  | 45 | 60 | 15
[NAME] | 60 |  | 60 |  | 60
[NAME] | 45 | 30 |  |  | 15
[NAME] |  | 45 | 45 | 30