tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 127215d1320236976-multiple-cascading-dropdowns-dynamic-data-validation-list-using-index
Sheet: Categories

Category 1 | Category 2 | Category 3 | Category 4 | Category 5
Category1, Sub Category 1 | Category2, Sub Category 1 | Category3, Sub Category 1 | Category4, Sub Category 1 | Category5, Sub Category 1
Category1, Sub Category 2 | Category2, Sub Category 2 | Category3, Sub Category 2 | Category4, Sub Category 2 | Category5, Sub Category 2
Category1, Sub Category 3 | Category2, Sub Category 3 | Category3, Sub Category 3 | Category4, Sub Category 3 | Category5, Sub Category 3
Category1, Sub Category 4 | Category2, Sub Category 4 | Category3, Sub Category 4 |  | Category5, Sub Category 4
Category1, Sub Category 5 | Category2, Sub Category 5 | Category3, Sub Category 5 |  | Category5, Sub Category 5
Category1, Sub Category 6 |  | Category3, Sub Category 6 |  | Category5, Sub Category 6
Category1, Sub Category 7 |  |  |  | Category5, Sub Category 7
Category1, Sub Category 8
Spreadsheet: 828897d1683787945-nested-xlookup-formula-returns-value-error-copyplantmeasurements2023-v3-mo
Sheet: GrowthChart1

Company1-Cust3-'Red'-10-3PP-PW33 |  |  |  |  | <-Select crop from the drop-down menu
Plant Week
Pinch Week |  |  | Min Ht
Sell Week |  |  | [NAME]
Pot Size (in) |  |  | Curve | Standard | <-Select standard or late curve from the drop-down menu
Weeks After Pinch | Calendar Week | Avg Ht | Min Ht | [NAME] | Avg Ht for Company1-Cust3-'Red'-10-3PP-PW33 (should be) | When Company1-Cust3-'Red'-10-3PP-PW33 is selected in the drop down menu at the top, [NAME] should be 8.1, 8.7, 8.4.
 |  |  |  |  | 8.1 | I filtered the results on the Measurement tab for this specific crop.
1 |  | 8.7 |  |  | 8.7 | If you select other crops from the drop-down menu, you can see that the Avg Ht populates correctly.
2 |  | 8.4 |  |  | 8.4 | But when the Calendar week is a decimal point, the Avg Ht cells are blank.
3
4
5
6
7
8
9
10
11
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 41789 | 35858 | 30108 | 32000
2 | 37927 | 35858 | 30887 | 32000 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 32549 | 35858 | 32901 | 32000 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 30654 | 35620 | 34690 | 31782 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 33190 | 33700 | 30637 | 30158 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 31722 | 33700 | 34293 | 30158 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 31843 | 33700 | 34597 | 30158
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 460431.19
2002-01-07 00:00:00
CBS Volume
 |  |  | 41311
Spreadsheet: 879587d1727174969-grassroots-football-team-season-stat-tracker-gameday-stats
Sheet: GW 3

Date | 21st September 2024
Opponent
Competition
Home/Away | Home
Result | 4-1
Player Name | Started | Sub | Goals | Disallowed Goal | Pens | Overall Goals | Assists | Yellow | Red | [NAME] | Pen conceeded | MOTM | Clean Sheet | Fines | Fine Paid? (Y/N)
Player 1 | 1
Player 4 |  | 1
Player 6 | 1
Player 5 |  | 1 | 1
Player 2 | 1
Player 3 | 1
Player 8 |  | 1
Player 9 | 1
Player 7 |  | 1
Player 10 | 1 |  |  |  |  |  | 1
Player 11 | 1 |  |  |  |  |  | 1
Player 16 | 1 |  | 2 |  |  |  | 2 |  |  |  |  | 1
Player 13 | 1
Player 14 | 1 |  | 1
Player 15 | 1
Player 12 |  | 1
Spreadsheet: kim_ward__20763__EEI
Sheet: Master

POWER MASTER AGREEMENT INFORMATION SHEET
 |  | LEGAL CONTACT:
DATE: |  | EPMI CONTACT:
COUNTERPARTY: | Tucson Electric Power Company | CONTACT: | [NAME]
ADDRESS: |  | TITLE:
 |  | PHONE: | [PHONE]
 |  | FAX:
 |  | S&P RATING: | [NAME]
ENTITY TYPE: | Corporation | MOODY'S RATING: | nr
 |  | FITCH IBC | BB-
TYPE OF AGREEMENT:
Bilateral (Purch & Sale) | X | Power Marketing
Unilateral - EPMI Purch only |  | Industrial Producer - EPMI Purch only
Unilateral - EPMI Sale only
Transaction Specific
TRANSACTION TENOR LIMITS | open
COVER PROVISIONS
(Failure to Deliver/Receive) | X
STANDARD TRIGGER EVENTS
Non-Payment | X
Representations | X
Other Covenants | X
Bankruptcy | X
TERMS SPECIFIC TO: | COUNTERPARTY | EPMI
COLLATERAL THRESHOLD | See Below | See Below | USD
Applies to [NAME] to Market only
Applies to MTM and [NAME] | X | X
Collateral Multiple | 250000 | 250000 | USD
COLLATERAL THRESHOLD TYPE
In a form acceptable...
Cash | X | X
US Treasuries
Letter of Credit | X | X
ADDITIONAL TRIGGER EVENTS
Cross Default 3rd Party Debt: | X | X
-Counterparty | 10000000
-Guarantor |  | 100000000
Material Adverse Change:
-Counterparty | X
-Guarantor |  | X
Non-Specific | X
-Bilateral
-Unilateral | X
Debt Ratings Change | X | X
-Below S&P or Moody's | [NAME] | [NAME]
-Type of debt | Senior Unsecured Debt | Senior Unsecured Debt
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net Worth
-Fixed Charge Coverage
-Interest Coverage
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
Ownership Change
-Less than 51% owned by:
COLLATERAL TYPE
In a form and amount acceptable
to non-defaulting party | X | X
Other
GUARANTOR BREACH
GUARANTOR (RATING) |  | Enron Corp. (BBB+/Baa1)
$ LIMIT |  | 25000000
Incorporation State:
FINANCIAL STATEMENTS
-Counterparty | X
-Guarantor |  | X
-Parent
OTHER COMMENTS:
Collateral Threshold based on S&P Sr. Unsecured ratings: |  | Counterparty / EPMI
 | BBB- or above | $15MM / $45MM
 | BB & BB+ | $10MM / $30MM
 | B+ & BB- | $8.5MM / $25MM
 | Below B- | $0 / $0
CREDIT REVIEW  PREPARED BY: |  | [NAME] | 5-7712
Spreadsheet: 453536d1459353439-index-match-indirect-indirect-index-match
Sheet: sheet!1

 |  |  |  |  |  |  |  |  |  |  |  |  | Day
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 4
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 5
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 7
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 8
 | 1. Select worksheet from DropList in C6. |  |  |  |  |  |  |  |  |  |  |  | Day 9
 | 1. Select Day from DropList in C9. |  |  |  |  |  |  |  |  |  |  |  | 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
Spreadsheet: 090fe72a-e999-4ede-8e0f-4fc36b46bbfb
Sheet: Sheet1

 |  | IMPERIAL VALLEY COLLEGE
 |  | WOMEN'S BASKETBALL ROSTER
 |  | 2012-2013
 | NAME | # | YR | Pos | HT | High School
 | [NAME] | 3 | Fr | G/F | 5'9 | Cibola HS
 | [NAME] | 1 | Fr | G | 5'6 | Calexico HS
 | [NAME] | 23 | So | G | 5'3 | Calexico HS
 | [NAME] | 22 | So | G/F | 5'4 | Brawley Union HS
 | [NAME] | 11 | Fr | G | 5'7 | Calexico HS
 | [NAME] | 5 | Fr | F | 5'9 | Imperial HS
 | [NAME] | 30 | So | G/F | 5'4 | [NAME]
 | [NAME] | 4 | So | F/C | 5'10 | Imperial HS
 | [NAME] | 34 | So | F/C | 6'2 | Brawley Union HS
 | Head Coach |  |  |  | [NAME]
 | Assistant Coach |  |  |  | [NAME]
 | Assistant Coach |  |  |  | [NAME]
 | Assistant Coach
 | Athletic Trainer
 | Athletic Director
 | Visit us at: | www.imperial.edu
 | Follow us on Facebook @  IVC Athletics
Spreadsheet: 770795d1646253591-working-time-directive-calculations-timesheet2
Sheet: 07-2-22

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | S Whyte / S Rudden
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | [NAME]
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | total from last week | total leave taken
 | [NAME] |  | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] | 14 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  | TR | 7.5 |  |  |  | 0 |  |  | AL
 | [NAME] | 18 | 7.5 | 0.5 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  | 8 |  | 8
 | [NAME] | 15.5 | 7.5 | -7.5 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 0 | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 7.5 |  |  |  | 7 |  |  |  | 7 |  | 7
 | [NAME] | 25 | 7.5 |  |  | TR | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 22 | 7.5 |  |  |  | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK
 | [NAME] | 26 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 7 |  |  |  | 8 |  | 8
 | Vacant Post | 8.5 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 85782d1285815096-counting-weeknumber-weeknum
Sheet: Sheet2

COMPLETION
FOCUS | ACTUAL | STATUS
2010-11-12 00:00:00 | 2010-09-27 00:00:00 | Completed
2010-11-01 00:00:00 |  | not this week
2010-11-09 00:00:00 |  | not this week
2010-10-23 00:00:00 |  | not this week
2010-10-23 00:00:00 |  | not this week
2010-11-09 00:00:00 |  | not this week
2010-11-27 00:00:00 |  | not this week
2010-11-01 00:00:00 |  | not this week
2010-10-30 00:00:00 |  | not this week
2010-10-30 00:00:00 |  | not this week
2010-11-16 00:00:00 |  | not this week
2010-10-02 00:00:00 |  | not this week
2010-10-03 00:00:00 |  | not this week
2010-11-06 00:00:00 |  | not this week
2010-09-30 00:00:00 |  | not this week
Spreadsheet: f65fda5b-32e6-4bc9-953e-04e75cde1c28
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
260020 | 30407 | [NAME] | Bishop | GBR | 23 | 00:00:00 | 00:00:00 | 00:12:10 | 00:01:01 | 00:16:47 | 1 | 00:29:56
260020 | 29802 | Martin | Matusek | SVK | 29 | 00:00:00 | 00:00:00 | 00:12:16 | 00:01:06 | 00:17:01 | 2 | 00:30:22
260020 | 19427 | Matija | Meden | SLO | 24 | 00:00:00 | 00:00:00 | 00:12:01 | 00:01:14 | 00:17:10 | 3 | 00:30:25
260020 | 39973 | [NAME] | [NAME] | GBR | 28 | 00:00:00 | 00:00:00 | 00:12:18 | 00:01:22 | 00:17:45 | 4 | 00:31:24
260020 | 69993 | [NAME] | Brunovsky | SVK | 27 | 00:00:00 | 00:00:00 | 00:12:39 | 00:01:07 | 00:18:06 | 5 | [NAME]
260020 | 43403 | [NAME] | Canzian [NAME] | BRA | 26 | 00:00:00 | 00:00:00 | 00:13:03 | 00:01:18 | 00:17:50 | 6 | 00:32:10
260020 | 21890 | Cameron | Todd | NZL | 22 | 00:00:00 | 00:00:00 | 00:12:36 | 00:01:09 | 00:19:02 | 7 | 00:32:46
Spreadsheet: vkaminski__40842__665 Team Project--Tracy Pan Part 1
Sheet: 1. Black-Sholes

Formula 1.6 Black-Sholes Fomula for European Options
 |  |  |  |  | Put-Call Parity
 |  |  |  |  |  |  |  | =
 |  | 0.25 |  | Inputs |  |  |  |  | Inputs
 | t | 0 |  |  |  | t
 | T | 0.5 |  |  |  | T
 | r | 0.05 |  |  |  | r
 | b | 0.05 |  |  |  | b
 | S | 100 |  |  |  | S
 | K | 100 |  |  |  | K
 | d1 |  |  |  |  | d1
 | N(d1) |  |  |  |  | N(-d1)
 | d2 |  |  |  |  | d2
 | N(d2) |  |  |  |  | N(-d2)
 | c(t,T) |  |  | Value |  | p(t,T) |  |  | Value
Spreadsheet: 29046d1223706124-two-dimensional-help-jg-master
Sheet: BR-Sun

 |  |  |  |  |  |  |  |  |  | # in class
 | RODEO:  MSLBRA
 | DATE:
 | DIVISION:  Jr. Girls
 | EVENT:  [NAME]
 | PERFORMANCE: Rodeo #1
 | Secretary's Signature:
 | # | NAME | HOMETOWN | OFFICIAL TIME | BACK UP TIME | PENALTY AND COMMENT | TOTAL | PLACE | Pts
 | 6431 | CallieRuth Bridgforth | Anywhere, NY |  |  |  |  | 1 | 74 | Jr. Girls Barrels-Sunday
 | --- | #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
 | --- | #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: 750383d1633430576-discerning-between-partial-text-and-frequency-counting-data-sample-forum
Sheet: Sheet1

TEKST | Mentions of adenoma via formula | Mentions of no adenoma via formula | Actual amount of adenoma | Actual amount of no adenoma
1: adenoma 2: no adenoma 3: no polyp or adenoma 4: adenoma 5: adenoma |  |  | 3 | 2
1: adenoma 2: adenoma 3: adenoma 4: no adenoma 5: no adenoma or polyp |  |  | 3 | 2
1: adenoma |  |  | 1 | 0
1: no adenoma |  |  | 0 | 1
1: no polyp no adenoma |  |  | 0 | 1
1: adenoma 2: no adenoma |  |  | 1 | 1
adenoma |  |  | 1 | 0
1:no adenoma, 2: adenoma |  |  | 1 | 1
1:No adenoma 2:no adenoma or polyp 3: no polyp or adenoma |  |  | 0 | 3
Spreadsheet: 858077d1706853289-problemas-com-segmenta-o-devolu__o-x-novas-loca__es-teste-dash_24-teste-ii
Sheet: Planilha1

Meses | Soma de VALOR DEVOLVIDO
jan | 66526.46
fev | 34869.44
[NAME] | 85248.34999999999
abr | 85405.62
mai | 73702.48
jun | 63778.16
jul | 56587.53
ago | 91073.97
set | 87998.77
out | 68132.54000000001
nov | 117135.14
dez | 159929.48
Total Geral | 990387.9399999998
Spreadsheet: 868862d1715592982-counting-new-record-years-correctly-dividend2-1-
Sheet: Sheet1

Year: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Dividend | 1 | 2 | 3 | 2 | 3 | 4 | 2 | 3 | 3 | 5 | 5
Years of new record dividend
 | 1 | 2 | 3 | 2 | 3 | 4 | 2 | 3 | 3 | 5 | 5
With the above dataset how is how I want it to be: |  | 1 | 2 |  |  | 3 |  |  |  | 4
If there is no data or 0 in B8, then I want the first record year to be in year 3
Can you please help me writing the correct formula for achieving this?
Spreadsheet: 874009d1720578973-how-to-drag-down-the-date-in-dd-mm-yy-format-how-to-drag-the-date-down_100724
Sheet: loan 130821-1L

loan amount & date | pay date | amt to sala | amt to interest | balance |  | date in date format dd-mm-yyyy
100000 | 110921 | 3000 | 1000
2021-08-13 00:00:00 | 91021 | 3000 | 970
 | 131121 | 3000 | 940
 | 111221 | 3000 | 910
 | 150122 | 3000 | 880
 | 120222 | 3000 | 850
 | 120322 | 3000 | 820 |  |  |  |  |  |  | fomula | result
 | 160422 | 3000 | 190
 | 210522 | 3000 | 760 |  |  |  |  |  |  | '=LEFT(B4,2)&"-"&RIGHT(B4,2) | 13-21
 | 130622 | 3000 | 730
 | 160722 | 3000 | 700 |  |  |  |  |  |  | =LEFT(B4,2)&"-"&RIGHT(B4,2)&"-"
 | 200822 | 3000 | 670
 | 170922 | 3000 | 640 |  |  |  |  |  |  | '=[NAME])
 | 221022 | 3000 | 610
 | 191122 | 3000 | 580
 | 171222 | 3000 | 550 |  |  |  |  |  |  |  | if I drag down
 | 210123 | 3000 | 520 |  |  |  |  |  |  |  | if I drag down
 | 180223 | 3000 | 490 |  |  |  |  |  |  |  | if I drag down
 | 180323 | 3000 | 460 |  |  |  |  |  |  |  | if I drag down
 | 180423 | 3000 | 430 |  |  |  |  |  |  |  | if I drag down
 | 200523 | 3000 | 400
 | 170623 | 3000 | 370
 | 150723 | 3000 | 340
 | 180823 | 3000 | 310
 | 160923 | 3000 | 280
 | 211023 | 3000 | 250
 | 181123 | 3000 | 220
 | 161223 | 3000 | 190
 | 200124 | 3000 | 160
 | 180224 | 3000 | 130
 | 160324 | 3000 | 100
 | 200424 | 3000 | 70 |  |  |  |  |  |  |  |  |  |  | l
 | 250524 | 4000 | 40
 | to get row 1 as freezed click on row 2 cell a2 and go to tools view freeze panes. Done.   100724
Spreadsheet: 733539d1621610628-sum-with-duplicates-dates-and-max-classeur2
Sheet: Feuil1

Phase | Clients | End date | Sq meters
Current OA | Client 1 | 2025-03-31 00:00:00 | 1256
Current OA | Client 2 | 2027-03-31 00:00:00 | 474.8
Current OA | Client 3 | 2022-10-31 00:00:00 | 1443.2
Current OA | Vacant | 2025-03-31 00:00:00 | 1263.8
Current OA | Parking | 2046-03-31 00:00:00 | 0
Current OA | Locaux entrepreneur immobilier | 2046-03-31 00:00:00 | 78.9
As Is Renewal | Client 6 | 2025-03-31 00:00:00 | 1443.2
As Is Renewal | Vacant | 2025-03-31 00:00:00 | 2397 |  | Duplicates
As Is Renewal | Vacant | 2046-03-31 00:00:00 | 2764.2
Fit up 100% | Client 1 | 2035-03-31 00:00:00 | 1256
Fit up 100% | Client 2 | 2037-03-31 00:00:00 | 474.8
Fit up 100% | Client 3 | 2035-03-31 00:00:00 | 1076
Current lease | Private client 4 | 2024-03-31 00:00:00 | 1133.2
Current lease | Private client 5 | 2023-11-30 00:00:00 | 0
What I need :
As Is Renewal | 1443,20+2764,20 | [NAME] that gives the addition of sq meter for this phase, but if there are any duplicates, the formula must only take into account the latest date.
 |  | Note that the phases will not be sorted all the time.
Current OA
Fit up 100% |  |  | No problem with these because there will never be duplicates.
Current lease
Spreadsheet: 768529d1645015501-textjoin-concat-a-list-of-emails-if-they-are-in-a-specific-group-for-office-2016-match-emailv2
Sheet: Sheet1

Group Name | [NAME] | Helper? | . | Group Name | Email-Address
EDK34 | [EMAIL] |  | . | AAB10
HHJ23 | [EMAIL] |  | . | CDD45
EDK34 | [EMAIL] |  | . | EDK34
HHJ23 | [EMAIL] |  | . | HHJ23
CDD45 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
CDD45 | [EMAIL] |  | .
CDD45 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
CDD45 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
CDD45 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
CDD45 | [EMAIL] |  | .
AAB10 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
CDD45 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
CDD45 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
EDK34 | [EMAIL] |  | .
HHJ23 | [EMAIL] |  | .
Spreadsheet: 63369d1264280997-excel-2008-value-results-from-xl-bug-beta_budgetmaster
Sheet: Summary

 |  |  |  |  | Budget | [NAME] |  |  |  | Budget | [NAME]
Spreadsheet: 839434d1691981788-modify-formulas-to-calculate-overtime-when-40hrs-are-not-worked-time-card-sample-with-expected-values
Sheet: Sheet1

 | Day | Holiday | Stat | Start | End | Total Hrs Wrkd | REG | TAH | DT | A
 | Sun |  |  | 08:00:00 | 20:00:00 | 12 | 8 | 4 |  |  | lost 4 Dt and 4 Tah because employee was sick (did not accumulate 40 hrs during reg work week)
 | Mon |  |  | 08:00:00 | 18:00:00 | 10 |  | 4 | 6
 | Tue |  |  | sick |  |  |  |  |  |  | employee called in sick
 | Wed | y |  | holidays |  |  |  |  |  |  | employee booked a holiday day
 | Thu |  |  | 08:00:00 | 15:00:00 | 7 | 7 |  |  | y | left early with permission
 | Fri |  |  | 08:00:00 | 22:00:00 | 14 | 8 | 4 | 2
 | Sat |  | y | 08:00:00 | 18:00:00 | 10 |  | 10 |  |  | worked a  stat day  so all hours are paid at TAH
 | Total
Spreadsheet: 856883d1706051709-transfer-copy-data-to-other-sheet-excel-problem-transfer-data-to-sheet_rev2
Sheet: Result

[NAME] TOOL REPLACED PARTS  2024
NO | [NAME] TOOL P/N | PROJECT/CUSTOMER | [NAME] TOOL TYPE | LINE | PARTS REPLACED | DATE
1 | 10.0774-7410.1 Coreline 2 | MANDO/RENAULT | CORE SENSOR | Coreline-2 | Ejector pin | 2024-01-02 00:00:00
2 | 06.2108-3627.2 | MMC SUV/MPV | SENSOR HEAD MOLD | 3 | Ejector pin 1x | 2024-01-07 00:00:00
3 | 10.0774-4803.2 L22 | RENAULT 52 | CONNECTOR MOLD | 22 | Ejector 4x170 x6 , 5x170 2x , 6x170 1x | 2024-01-08 00:00:00 |  | From "Repair Sheet"
4 | 10.0774-7410.1 Coreline 2 | MANDO/RENAULT | CORE SENSOR | Coreline-2 | down holder cylinder ln59 | 2024-01-11 00:00:00
5 | 10.0774-7410.1 Coreline 2 | MANDO/RENAULT | CORE SENSOR | Coreline-2 | nozzle ejector pin . 1 pc | 2023-12-30 00:00:00
6 | KIA - JA GROMMET  FR RH/LH MOLD | KIA - JA | GROMMET [NAME] | 2 | nozzle in nozzle 3 | 2024-01-15 00:00:00
7 | KIA - JA GROMMET RR [NAME] | KIA - JA | GROMMET [NAME] |  |  | 2024-01-04 00:00:00
8 | 25.0770-3140.2 | MMC SUV/MPV | CONNECTOR MOLD |  |  | 2024-01-04 00:00:00 |  | From "Level 2 Sheet"
9 | 10.0774-7421.1/7410.1 Coreline 1 | MANDO/RENAULT | CORE SENSOR |  |  | 2024-01-04 00:00:00
10 | 10.0711-6512.4 | RENAULT 52 (RA GEN3) | SENSOR HEAD MOLD |  |  | 2024-01-04 00:00:00
Spreadsheet: 752592d1634841379-circular-reference-issue-copy-of-excel-employee-vacation-sheet-2021-prototype
Sheet: Sep

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative A; Approved
Compressed Day Off
Assignment / Left
Half Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
September | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
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 |  | Replaced by:
Cramm,[NAME]
[NAME], [NAME]
SARRETTE, [NAME]
BERNS, [NAME]
ST-ILMA, [NAME]
NAULT, Thérèse
BRAZEAU, [NAME]
FOURNIER, [NAME]
JAMSHAID, Omer
JANCZYSZYN, [NAME]
MILLETTE, [NAME]
ZNACK, Stéphane
REDBURN, [NAME]
BRADFORD, [NAME]
CASGRAIN, Sylvain
EUSTACE, Scott
LEVESQUE, [NAME]
ZEGROUR, [NAME]
MEDEIROS, Martin
MURPHY, [NAME]
DUGAS, [NAME]
[NAME], [NAME]
SCHNEIDER, [NAME]
FOOKSMAN, Ilona
FOURNIER, [NAME]
[NAME], Tanya
MOLLOY, [NAME]
OSMAN, Mahdi
OSMANOVIC, [NAME]
STYLES, [NAME]
BOOKER, [NAME]
FORTIER, Christine
LOEPPKY, [NAME]
MACPHAIL, [NAME]
Éric Mainville
[NAME]
[NAME]
September Total