tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 637399d1565886692-football-score-predictor-similar-to-super-6-but-with-10-fixtures-a-week-predictor-2019-20-v1
Sheet: WEEKS 3 -56

WEEK 3 | 20TH - 26TH AUGUST 2019
HOME TEAM | AWAY TEAM | SCORE PREDICTION |  | RESULT |  | POINTS
ASTON VILLA | EVERTON
NORWICH | CHELSEA
LIVERPOOL | ARSENAL
BOURNEMOUTH | MAN CITY
TOTTENHAM | NEWCASTLE
DERBY | BRISTOL CITY
WEST BROM | READING
CHARLTON | BRENTFORD
STOKE | LEEDS
SWANSEA | BIRMINGHAM
WEEK 4 | 27TH AUGUST - 2ND SEPTEMBER 2019
HOME TEAM | AWAY TEAM | SCORE PREDICTION |  | RESULT |  | POINTS
SOUTHAMPTON | MAN UTD
CHELSEA | SHEFF UTD
CRYSTAL PALACE | ASTON VILLA
WIGAN | BARNSLEY
MAN CITY | BRIGHTON
BRISTOL CITY | MIDDLESBROUGH
LEEDS | SWANSEA
BURNLEY | LIVERPOOL
EVERTON | WOLVES
ARSENAL | TOTTENHAM
WEEK 5 | 3RD - 9TH SEPTEMBER 2019
HOME TEAM | AWAY TEAM | SCORE PREDICTION |  | RESULT |  | POINTS
Spreadsheet: 239100d1369825059-program-to-generate-sales-production-and-stock-data-in-one-sheet-stock2
Sheet: Stock

Item Code | Opening Stock
 |  | Production | Sales | Stock | Production | Sales | Stock | Production | Sales | Stock | Production | Sales | Stock | Production | Sales | Stock | Production | Sales | Stock | Production | Sales | Stock
(blank) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G'day,  The supply of data was a bit over the place in regards of date range so I had to expand the range to a large one so you can see it work.  So its entirely up to you, if you like to manage the data daily, weekly, monthly or even quarterly.    To reduce manual work ? That's what I love about excel, I've made my excel workbook reduce hours and stress in my line of work.
Coller-Old
MIX
SOLID
2.5F/21
2.5F/22
2.5R/41
2.5R/42
2.5R/46
2.5R/47
2.5R/48
3.0F/61
3.0F/62
3.0F/63
3.0R/81
3.0R/82
3.0R/83
3.0R/84
3.0R/90
3.0R/91
3.5F/101
3.5F/104
3.5F/107
3.5R/121
3.5R/124
3.5R/126
4.0F/141
4.0F/142
4.0F/143
4.0F/144
4.0F/145
4.0F/146
4.0F/147
4.0F/149
4.0F/152
4.0F/153
4.0F/155
4.0R/162
4.0R/163
4.0R/164
4.0R/166
4.0R/168
4.0R/171
4.0R/173
4.0R/174
4.0R/176
4.0R/177
4.0R/178
4.0R/179
4.0R/180
4.5F/181
4.5F/182
4.5F/186
4.5R/202
4.5R/203
4.5R/205
4.5R/210
5.0F/221
5.0F/223
5.0F/225
5.0F/226
5.0F/227
5.0F/229
5.0F/230
5.0F/231
5.0F/232
5.0F/233
5.0F/234
5.0F/235
5.0F/236
5.0F/238
5.0F/239
5.0R/242
5.0R/243
5.0R/244
5.0R/245
5.0R/246
5.0R/247
5.0R/250
5.0R/251
5.5F/261
5.5F/262
5.5F/263
5.5R/276
5.5R/277
5.5R/279
6.0F/291
6.0F/292
6.0F/293
6.0F/294
6.0R/301
6.0R/302
6.0R/304
6.0R/305
6.0R/307
6.0R/308
6.5F/316
6.5R/326
6.5R/327
7.0F/336
7.0F/337
7.0F/338
7.0F/339
7.0R/346
7.0R/348
7.0R/350
7.0R/351
8.0F/356
8.0F/357
8.0F/358
8.0F/359
8.0R/368
8.0R/369
8.0R/370
9.0F/376
9.0F/377
9.0F/378
9.0F/379
9.0F/380
9.0F/381
9.0R/386
9.0R/387
9.0R/388
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: handicaps

HANDICAPS
PLAYER | Exact Offical | Adjustment | Playing | Official |  | PLAYER | Handicaps
 | Handicap |  | Handicap | Handicap |  |  | Exact | Adjust | UnOff | Off
Spreadsheet: 871603d1718037556-time-intelligence-calculation-formula-for-prepaid-and-income2
Sheet: Data

Item amount | From Date | To Date | Reporting Date
12000 | 2024-04-10 00:00:00 | 2024-10-20 00:00:00 | 2024-05-01 00:00:00
24000 | 2024-08-31 00:00:00 | 2025-03-31 00:00:00 | 2024-06-01 00:00:00
36000 | 2024-02-15 00:00:00 | 2026-03-31 00:00:00 | 2024-06-01 00:00:00
48000 | 2024-08-11 00:00:00 | 2025-03-31 00:00:00 | 2024-04-01 00:00:00
60000 | 2024-07-15 00:00:00 | 2025-04-29 00:00:00 | 2024-05-01 00:00:00
Spreadsheet: 217594d1362120140-index-match-to-return-values-to-compare-sampla-spreadsheet-for-ibvestment-values
Sheet: Sheet1

Investment | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00
Inv 1 | 10000 | 12000 | 13000 | 14000 | 15000 | 16000
Inv 2 | 1000 | 1500 | 2000 | 1500 | 2100 | 2300
Inv 3 | 500 | 600 | 700 | 750 | 750 | 800
Inv 4 | 25 | 23 | 13 | 15 | 18 | 12
Inv 5 | 8000 | 8100 | 7900 | 7800 | 7600 | 7500
 | Results - I want to be able to select different dates to show results here of have the data in another sheet
 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 |  | Difference | %Change
Inv 1 | 10000 | 14000
Inv 2 | 1000 | 1500
Inv 3 | 500 | 750
Inv 4 | 25 | 15
Inv 5 | 8000 | 7800
Spreadsheet: 1dab41f3-4ee3-4cea-a4e5-665b5b791aab
Sheet: Operating Costs

Service Center Calculations
ANNUAL BUDGETED OPERATING COSTS
Purpose: To detail non-salary and non-equipment costs associated with the service center services
Sheet Instructions
Fill in only the yellow highlighted areas
You may insert additional lines as necessary.
 |  | SERVICE 1 |  | SERVICE 2
Travel
Description | Annual Amt | % | Amount | % | Amount
 | 0 |  |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | Totals
 |  | SERVICE 1 |  | SERVICE 2
Operating Expenses
Description | Annual Amt | % | Amount | % | Amount
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 | Totals
 |  | SERVICE 1 |  | SERVICE 2
Equipment < $5,000*
Description | Annual Amt | % | Amount | % | Amount
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | Totals
Equipment >$5,000 - See next worksheet
Spreadsheet: 831037d1685367351-match-and-sum-match-and-sum2
Sheet: Sheet2

Case1
Magh | Ma-45 | [NAME] |  |  |  |  | 64
Magh | Ma-49 | [NAME] |  |  |  |  | 75
Magh | Ma-54 | [NAME] |  |  |  |  | 88
Case2
Magh | Ma-45 | [NAME] |  |  |  |  |  |  | 64 |  |  |  | 500
Magh | Ma-49 | [NAME] |  |  |  |  |  |  | 75 |  |  |  | 300
Magh | Ma-54 | [NAME] |  |  |  |  |  |  | 88 |  |  |  | 450
Case3
Magh | Ma-45 | [NAME] | 2023.5.26 |  | 4626
Magh | Ma-49 | [NAME] | 2023.5.24 |  | 846
Magh | Ma-54 | [NAME] | 2023.5.27 |  | 342
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 11c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency Basis | 19 | 9 | 41 | 80 | 176 | 129 | 129 | 15 | 598
Cross-Currency Fixed-Fixed | 15 | 1 | 10 | 7 | 13 | 13 | 22 | 0 | 81
Cross-Currency Fixed-Float | 35 | 0 | 60 | 73 | 50 | 46 | 4 | 0 | 268
TOTAL | 69 | 10 | 111 | 160 | 239 | 188 | 155 | 15 | 947
Spreadsheet: 168708d1342547217-is-this-pivot-table-possible-pivot-table
Sheet: Sheet4

Count of Size
DOOR ELEVATION | DOOR FINISH | RATING | COMMENTS | Size | Total
D1 | P-10 | (blank) | (blank) | 3'-0" x 7'-0" | 3
 |  |  | (blank) Total |  | 3
 |  | (blank) Total |  |  | 3
 | P-10 Total |  |  |  | 3
 | P-11 | (blank) | (blank) | 3'-0" x 7'-0" | 1
 |  |  | (blank) Total |  | 1
 |  | (blank) Total |  |  | 1
 | P-11 Total |  |  |  | 1
 | P-13 | (blank) | (blank) | 3'-0" x 7'-0" | 3
 |  |  | (blank) Total |  | 3
 |  | (blank) Total |  |  | 3
 | P-13 Total |  |  |  | 3
 | P-3 | (blank) | (blank) | 3'-0" x 7'-0" | 1
 |  |  | (blank) Total |  | 1
 |  | (blank) Total |  |  | 1
 | [NAME] |  |  |  | 1
 | P-8 | 45 | CLOSER | 3'-0" x 7'-0" | 1
 |  |  | CLOSER Total |  | 1
 |  | 45 Total |  |  | 1
 | P-8 Total |  |  |  | 1
 | WD-1 | 45 | CLOSER | 3'-0" x 7'-0" | 6
 |  |  | CLOSER Total |  | 6
 |  | 45 Total |  |  | 6
 |  | (blank) | DOUBLE ACTING | 3'-0" x 7'-0" | 2
 |  |  | DOUBLE ACTING Total |  | 2
 |  |  | (blank) | 2'-0" x 7'-0" | 1
 |  |  |  | 3'-0" x 7'-0" | 39
 |  |  |  | 4'-0" x 7'-0" | 8
 |  |  |  | 4'-8" x 7'-0" | 2
 |  |  |  | 6'-0" x 7'-0" | 2
 |  |  | (blank) Total |  | 52
 |  | (blank) Total |  |  | 54
 | WD-1 Total |  |  |  | 60
D1 Total |  |  |  |  | 69
D-2 | MATCH HISTORIC | 45 | CLOSER; PUSH BAR EXIT, DOOR TO MATCH EXISTING | VIF x VIF | 1
 |  |  | CLOSER; PUSH BAR EXIT, DOOR TO MATCH EXISTING Total |  | 1
 |  | 45 Total |  |  | 1
 | MATCH HISTORIC Total |  |  |  | 1
D-2 Total |  |  |  |  | 1
D3 | P-8 | (blank) | (blank) | 3'-0" x 7'-0" | 2
 |  |  | (blank) Total |  | 2
 |  | (blank) Total |  |  | 2
 | P-8 Total |  |  |  | 2
D3 Total |  |  |  |  | 2
D4 | MATCH HISTORIC | (blank) | CARD READER; CLOSER | 3'-6" x 7'-0" | 1
 |  |  | CARD READER; CLOSER Total |  | 1
 |  | (blank) Total |  |  | 1
 | MATCH HISTORIC Total |  |  |  | 1
D4 Total |  |  |  |  | 1
D5 | F20 | (blank) | CLOSER | 6'-0" x 7'-0" | 2
 |  |  | CLOSER Total |  | 2
 |  | (blank) Total |  |  | 2
 | F20 Total |  |  |  | 2
D5 Total |  |  |  |  | 2
D6 | WD-1 | (blank) | (blank) | 3'-6" x 7'-0" | 1
 |  |  | (blank) Total |  | 1
 |  | (blank) Total |  |  | 1
 | WD-1 Total |  |  |  | 1
D6 Total |  |  |  |  | 1
EXIST. | EXIST. | 45 | CLOSER | EXIST. x EXIST. | 7
 |  |  | CLOSER Total |  | 7
 |  |  | CLOSER; LEVER HANDLE | EXIST. x EXIST. | 1
 |  |  | CLOSER; LEVER HANDLE Total |  | 1
 |  | 45 Total |  |  | 8
 |  | (blank) | LEVER HANDLE | EXIST. x EXIST. | 1
 |  |  | LEVER HANDLE Total |  | 1
 |  |  | [NAME]; CLOSER | EXIST. x EXIST. | 3
 |  |  | [NAME]; CLOSER Total |  | 3
 |  |  | PUSH BAR EXIT | EXIST. x EXIST. | 1
 |  |  | PUSH BAR EXIT Total |  | 1
 |  |  | (blank) | EXIST. x EXIST. | 4
 |  |  | (blank) Total |  | 4
 |  | (blank) Total |  |  | 9
 | EXIST. Total |  |  |  | 17
 | MATCH HISTORIC | (blank) | PUSH BAR EXIT | EXIST. x EXIST. | 1
 |  |  | PUSH BAR EXIT Total |  | 1
 |  | (blank) Total |  |  | 1
 | MATCH HISTORIC Total |  |  |  | 1
EXIST. Total |  |  |  |  | 18
Grand Total |  |  |  |  | 94
Spreadsheet: 103c269e-1d5f-4656-b17b-ef30c1cd1351
Sheet: Sheet1

APPENDIX C EXTENSION OF MODEL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
C.1. Technical Insolvency
Under technical insolvency, the barrier level is set equal to the strike rate (face value of debt)
AB = Multiple of X, where multiple is = 1
AB = X
Example (American-Style barrier):
Assumptions:
1) zero time-value of money
2) 50% probability in each node
3) Equity holders have an incentive to hold on to the assets of the firm for as long as possible, which means they will only exercise (down-and-out call option)  at maturity
4) Assets are transferred immediately upon default (put is exercised immediately when barrier is triggered and the option is "in the money")
Strike price (X) = | 81
Barrier level (AB) = | 81
Path of asset values
 |  |  |  |  |  |  |  |  |  | Calculations:
 | Period 0 |  | Period 1 |  | Period 2 |  | Period 3
 |  |  |  |  |  |  |  |  |  | Payoff table and its probabilities
 |  |  |  |  |  |  | 130 |  |  | C = Call, X = Strike Price, P = Put, S = Asset value
 |  |  |  |  |  |  |  |  |  | C | X | P | S | Probability
 |  |  |  |  | 120 |  |  |  |  | 49 | 81 | 0 | 130 | 0.125
 |  |  |  |  |  |  |  |  |  | 29 | 81 | 0 | 110 | 0.375
 |  |  | 110 |  |  |  | 110 |  |  | 9 | 81 | 0 | 90 | 0.25
 |  |  |  |  |  |  |  |  |  | 0 | 81 | 1 | 80 | 0.25
 | 100 |  |  |  | 100
 |  |  |  |  |  |  |  |  |  | C0 = 0.125*49+0.375*29+.25*9 = |  |  | 19.25
 |  |  | 90 |  |  |  | 90 |  |  | P0 = 0.25*1 = | 0.25
 |  |  |  |  | 80 |  |  |  |  | X = | 81
 |  |  |  |  |  |  | 70 |  |  | S0 = 19.25 + 81 - 2.5 = |  | 100
 |  |  |  |  |  |  |  |  |  | C0 = Price of down-and-out
 |  |  |  |  |  |  |  |  |  | P0 = Price of down-and-in put
 |  |  |  |  |  |  |  |  |  | S0 = Value of the firm (asset value)
CORPORATE SECURITIES AND CDS VALUATIONS:
Value of Equity = Value of down-and-out call option = |  |  |  |  |  | 19.25 |  |  |  | Put-Call parity = C0 + X = P0 + S0
Value of Debt = Risk-free component - Risky component |  |  |  |  |  |  |  |  |  | 19.25 + 81 = 0.25 +100 |  | Thus, put-call parity holds
Risk-free component = face value of debt = strike price = |  |  |  |  |  | 81
Risky Component = down-and-in put = Value of CDS position |  |  |  |  |  | 0.25
Value of Risky Debt = Face Value of debt + Short down-and-in Put = |  |  |  |  |  | 80.75
100 = Value of assets = Value of equity + Value of risky debt = $12.50 + $87.50 = |  |  |  |  |  | 100
Spreadsheet: 0bd5c96c-3f7e-4a78-ad8f-81f791edd190
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259475 | 73758 | Lana | Spencieri | BRA |  | 00:15:03 | 00:01:06 | 00:33:50 | 00:00:38 | 00:24:00 | 1 | 01:14:38
259475 | 45660 | [NAME] | Paz | BRA |  | 00:16:31 | 00:01:10 | 00:34:20 | [NAME] | 00:25:20 | 2 | [NAME]
259475 | 50627 | Luana | [NAME] | BRA |  | 00:16:56 | 00:01:02 | 00:33:59 | 00:00:41 | 00:26:57 | 3 | 01:19:37
259475 | 63921 | Flavia | Rezende | BRA |  | [NAME] | 00:01:00 | 00:36:53 | 00:00:44 | 00:30:10 | 4 | 01:25:16
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: MiVida_Rich

 | Mi Vida/Richardson Gas Treating
 | POI 500607 - Delhi/No Pyote
Day | Measured | Scheduled
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
2001-11-30 00:00:00 |  |  | -188011.52
2001-11-30 00:00:00
CBS Volume
 |  |  | -44184
Spreadsheet: 1338adbb-aa5d-4a8f-b2fd-077ed1535500
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5894 | 32652 | [NAME] | Fisher | USA | 1019 | 00:14:45 | 00:02:41 | 00:34:46 | 00:03:41 | 00:29:10 | 1 | 01:25:03
Spreadsheet: 89267d1289018491-data-by-month-hourcount
Sheet: Sheet3

September | October | November
Spreadsheet: 187275d1350397108-how-to-return-a-value-from-mutliple-tabs-with-data-sets-salary-1
Sheet: Location 4

Location 4
Grade | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8 | Step 9 | Step 10
1 | 21504 | 22223 | 22938 | 23649 | 24365 | 24785 | 25492 | 26204 | 26232 | 26899
2 | 24179 | 24753 | 25553 | 26232 | 26527 | 27307 | 28087 | 28868 | 29648 | 30428
3 | 26381 | 27260 | 28139 | 29019 | 29898 | 30777 | 31657 | 32536 | 33415 | 34295
4 | 29615 | 30602 | 31589 | 32576 | 33563 | 34550 | 35536 | 36523 | 37510 | 38497
5 | 33134 | 34238 | 35342 | 36446 | 37550 | 38654 | 39758 | 40862 | 41966 | 43070
6 | 36934 | 38165 | 39396 | 40627 | 41857 | 43088 | 44319 | 45550 | 46781 | 48012
7 | 41043 | 42412 | 43780 | 45149 | 46517 | 47886 | 49255 | 50623 | 51992 | 53360
8 | 45454 | 46969 | 48484 | 49999 | 51513 | 53028 | 54543 | 56057 | 57572 | 59087
9 | 50204 | 51877 | 53550 | 55223 | 56896 | 58569 | 60242 | 61915 | 63587 | 65260
10 | 55287 | 57130 | 58973 | 60817 | 62660 | 64503 | 66346 | 68190 | 70033 | 71876
11 | 60742 | 62766 | 64791 | 66815 | 68839 | 70864 | 72888 | 74913 | 76937 | 78962
12 | 72805 | 75232 | 77658 | 80085 | 82512 | 84938 | 87365 | 89792 | 92218 | 94645
13 | 86575 | 89461 | 92346 | 95232 | 98118 | 101003 | 103889 | 106775 | 109660 | 112546
14 | 102306 | 105715 | 109125 | 112535 | 115945 | 119355 | 122765 | 126175 | 129585 | 132995
15 | 120341 | 124352 | 128364 | 132375 | 136386 | 140398 | 144409 | 148421 | 152432 | 155500
Spreadsheet: 865090d1712160813-return-date-for-multiple-payments-for-multiple-invoices-excel-work-file-ans3
Sheet: Sheet1

Year | Period Number | Billed Balance | Payment Total | Paid in Full (Y/N) | # of Payments | Payment Date | Days to Pay |  |  | Invoice Periond Information
2024 | 10 | 42484.35 |  | Yes |  |  |  |  |  | Period | Begin Date | End Date | Billing Date | Payment Due Date
2024 | 11 | 40076.92 |  | Yes |  |  |  |  |  | 10 | 2024-01-30 00:00:00 | 2024-02-05 00:00:00
2024 | 12 | 39273.91 |  | Yes |  |  |  |  |  | 11 | 2024-02-06 00:00:00 | 2024-02-12 00:00:00
2024 | 13 | 40331.66 |  | Yes |  |  |  |  |  | 12 | 2024-02-13 00:00:00 | 2024-02-19 00:00:00
 |  | Exact Match on Payment |  |  |  |  |  |  |  | 13 | 2024-02-20 00:00:00 | 2024-02-26 00:00:00
 |  | [NAME] | PAYMENT_AMT
 |  | 2024-02-08 00:00:00 | -42484.35
 |  | 2024-02-15 00:00:00 | -40076.92
 |  | 2024-02-22 00:00:00 | -39273.91
 |  | 2024-02-29 00:00:00 | -40331.66
 |  | 2024-03-07 00:00:00 | -46740.46
 |  | 2024-03-14 00:00:00 | -43275.51
 |  | 2024-03-21 00:00:00 | -47508.06
 |  | 2024-03-28 00:00:00 | -46796.76
 |  |  | Need Payment Total Formula to Pull as well |  |  | Desired Payment Date W/O Formula
Year | Period Number | Billed Balance | Payment Total | Paid in Full (Y/N) | # of Payments | Payment Date | Days to Pay |  |  | expected
2024 | 10 | 42484.35 | -42484.35 | Yes |  |  |  |  |  | 2024-02-15 00:00:00
2024 | 11 | 40076.92 | -40076.92 | Yes |  |  |  |  |  | 2024-02-22 00:00:00
2024 | 12 | 39273.91 | -39273.91 | Yes |  |  |  |  |  | 2024-03-14 00:00:00
2024 | 13 | 40331.66 | -40331.66 | Yes |  |  |  |  |  | 2024-03-28 00:00:00
 |  | Making Partial Payments
 |  | [NAME] | PAYMENT_AMT
 |  | 2024-02-08 00:00:00 | -40000
 |  | 2024-02-15 00:00:00 | -2484.35
 |  | 2024-02-22 00:00:00 | -40076.92
 |  | 2024-02-29 00:00:00 | -5000
 |  | 2024-03-07 00:00:00 | -10000
 |  | 2024-03-14 00:00:00 | -24273.91
 |  | 2024-03-21 00:00:00 | -20000
 |  | 2024-03-28 00:00:00 | -20331.66
Spreadsheet: 703452d1605007399-comparing-json-data-in-two-rows-for-every-set-of-id-sample-data-2
Sheet: Input 

Billid | Ctextid | [NAME] | user
2132 | 91156 | [   {     "description": "fabula ",     "dCode": "8901",     "CodeId": "90001",     "messages": [       ""     ],     "Number": 1   },   {     "description": "EXper ",     "dCode": "9034",     "CodeId": "88343",     "messages": [       ""     ],     "Number": 2   } ] | amt1
2132 | 91156 | [   {     "description": "fabula ",     "dCode": "8901",     "CodeId": "90001",     "messages": [       ""     ],     "Number": 1   },   {     "description": "EXper ",     "dCode": "9034",     "CodeId": "88343",     "messages": [       ""     ],     "Number": 2   } ] | all1
5678 | 99344 | [   {     "description": "TORYA ",     "dCode": "99002",     "CodeId": "988332",     "messages": [       ""     ],     "Number": 1   },   {     "description": "triact ",     "dCode": "90774",     "CodeId": "7800034",     "messages": [       ""     ],     "Number": 2   } ] | [NAME]
5678 | 99344 | [   {     "description": "TORYA ",     "dCode": "99002",     "CodeId": "988332",     "messages": [       ""     ],     "Number": 1   },   {     "description": "triact ",     "dCode": "90974",     "CodeId": "78034",     "messages": [       ""     ],     "Number": 2   } ] | jk2
Spreadsheet: 858277d1707011092-shorten-formula-book2
Sheet: Sheet1

[NAME] | APPLES | MONDAY | 43 |  |  | Fred | Bananas | Sunday
PETER | ORANGES | TUESDAY | 21 |  |  | [NAME] | Pears | Saturday
[NAME] | MANGOS | THURSDAY | 33 |  |  | [NAME] | Oranges | Tuesday
 |  | J5  The criteria is met and it returns the value of 21.
 |  | I need it to return the value if criteria is met, and it DOESN’T exist already
 |  | In this example, the criteria is ORANGES and 2/5/2024
2014-02-12 00:00:00 | [NAME] | 22.98 | Apples |  |  | 2024-01-13 00:00:00 | [NAME] | 29.34 | Peaches
2024-03-04 00:00:00 | [NAME] | 34.63 | Apples |  |  | 2026-01-26 00:00:00 | [NAME] | 15.63 | Pears
2024-02-05 00:00:00 | Mark | 28.22 | Apples |  |  | 2024-02-05 00:00:00 | Mark | 28.22 | Apples
2024-04-04 00:00:00 | Fred | 11.99 | Oranges |  |  | 2024-02-05 00:00:00 | [NAME] | 52.23 | Oranges
2024-02-05 00:00:00 | [NAME] | 52.23 | Oranges |  |  |  |  |  |  |  | So the formula in yellow box should search the array A19:D24 for 2/5/24 and Oranges
2024-02-05 00:00:00 | [NAME] | 7.99 | Oranges |  |  |  |  |  |  |  | And return the value that meets the criteria but doesn't already exist in the g19:j24 array.
 |  |  |  |  |  |  |  |  |  |  | In this case, it should return 7.99.
Spreadsheet: 691319d1597645453-formula-for-the-inverse-of-sumif-required-formula
Sheet: Planning Sheet

 | Planning Sheet
 | Shipment Date | Order Number | Article | [NAME] | Production Qty | [NAME]
 | 2020-01-01 00:00:00 | 1234 | ABC | 25000 | 25000
 | 2020-02-01 00:00:00 | 1234 | ABC | 25000 | 25000
 | 2020-03-01 00:00:00 | 1234 | ABC | 25000 | 10000
 | 2020-04-01 00:00:00 | 1234 | ABC | 25000
 | 2020-01-01 00:00:00 | 5678 | DEF | 25000 | 25000
 | 2020-02-01 00:00:00 | 5678 | DEF | 25000 | 20000
 | 2020-03-01 00:00:00 | 5678 | DEF | 25000 | 0
Spreadsheet: 0f6955f3-dba0-4cb2-b4da-e930abd1900d
Sheet: TeamScoresSB1

Place | Team | Score
1 | Claymont | 224.5
2 | [NAME] | 196
3 | CVCA | 182.5
4 | [NAME] | 170
5 | Marysville | 138.5
6 | Lake | 118
7 | Hoover | 115.5
8 | [NAME] | 97
9 | Wapakoneta | 97
10 | West Branch | 93.5
11 | [NAME] | 90
12 | Riverside | 89
13 | Boardman | 88
14 | Walsh | 87.5
15 | Olentangy | 84
16 | Loudonville | 80
17 | [NAME] | 78
18 | Mentor | 77.5
19 | Poland | 73.5
20 | Sidney | 73.5
21 | [NAME] | 71.5
22 | Miami Trace | 70
23 | Field | 69.5
24 | [NAME] | 68
25 | Eaton | 63.5
26 | Kenton Ridge | 63.5
27 | Strongsville | 59
28 | Dover | 56
29 | Austintown | 54.5
30 | West Holmes | 51.5
31 | Carrollton | 50
32 | Southeast | 48
33 | Fairless | 46
34 | Northwest | 45.5
35 | New Oxford | 44
36 | [NAME] | 43
37 | Clearfork | 37.5
38 | Alliance | 31.5
39 | Mansfield | 31
40 | Mayfield | 31
41 | Louisville | 28.5
42 | Streetsboro | 21
43 | Liberty | 19
44 | Piqua | 11
Spreadsheet: 773521d1647893606-vlookup-and-if-functions-example-v2
Sheet: Total Hours

 |  |  | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
1001 | [NAME], [NAME] | Total Hours:
2403 | Doe, [NAME] | Total Hours:
2050 | Fisher, Mary | Total Hours:
1920 | [NAME], [NAME] | Total Hours:
 | *[NAME] should pull Row15 from the "By [NAME]"
 | *Doe should be Row30 from the "By Employee" tab
Spreadsheet: 694486d1599642836-how-to-count-repeating-purchase-from-different-year-testrpt
Sheet: 2017

No | Name | Product
1 | Adam | PS4
2 | Adam | USB
3 | [NAME] | USB
4 | [NAME] | [NAME]
5 | Dio | KEYBOARD
6 | [NAME] | [NAME]
7 | [NAME] | HEADPHONE
8 | Lex | PS4
9 | [NAME] | PS4
10 | Broly | PS4
Spreadsheet: 168776d1342573543-max-value-in-table-if-variable-condition-met-pt-excel-max-if-problem-1-
Sheet: Max If Problem

The Problem - finding a formula for column D
I’m using Excel 2007, under Windows 7
Date | Person | Sales | Highest Sales for the Day | % of Highest Sales of the Day (Col C / Col D) |  | Column D Desired Result |  | [NAME] showing [NAME] by Date |  |  | Filtered Lists
2012-01-01 00:00:00 | [NAME] | 70 |  |  |  | 70
2012-01-01 00:00:00 | [NAME] | 70 |  |  |  | 70 |  | Row Labels | [NAME] |  | Date
2012-01-01 00:00:00 | [NAME] | 50 |  |  |  | 70 |  | 2012-01-01 00:00:00 | 70 |  | 2012-01-01 00:00:00
2012-01-01 00:00:00 | [NAME] | 40 |  |  |  | 70 |  | 2012-01-02 00:00:00 | 35 |  | 2012-01-02 00:00:00
2012-01-01 00:00:00 | [NAME] | 30 |  |  |  | 70 |  | 2012-01-03 00:00:00 | 20 |  | 2012-01-03 00:00:00
2012-01-01 00:00:00 | [NAME] | 20 |  |  |  | 70 |  | Grand Total | 70
2012-01-01 00:00:00 | [NAME] | 10 |  |  |  | 70
2012-01-02 00:00:00 | [NAME] | 5 |  |  |  | 35
2012-01-02 00:00:00 | [NAME] | 10 |  |  |  | 35
2012-01-10 00:00:00 | [NAME] | 15 |  |  |  | 35 |  |  |  |  | Formula create lists
2012-01-02 00:00:00 | [NAME] | 20 |  |  |  | 35
2012-01-02 00:00:00 | [NAME] | 25 |  |  |  | 35
2012-01-02 00:00:00 | [NAME] | 30 |  |  |  | 35
2012-01-02 00:00:00 | [NAME] | 35 |  |  |  | 35
2012-01-03 00:00:00 | [NAME] | 10 |  |  |  | 20
2012-01-03 00:00:00 | [NAME] | 10 |  |  |  | 20
2012-01-03 00:00:00 | [NAME] | 10 |  |  |  | 20
2012-01-03 00:00:00 | [NAME] | 20 |  |  |  | 20
2012-01-03 00:00:00 | [NAME] | 10 |  |  |  | 20
2012-01-03 00:00:00 | [NAME] | 10 |  |  |  | 20
2012-01-07 00:00:00 | [NAME] | 10 |  |  |  | 20