tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 540139d1506543499-charts-automatically-updating-when-pasting-information-into-excel-copy-of-8
Sheet: Sheet1

Clinic Number | Clinic Name | Machine Number | Machine Serial Number | Resolution Date | Hours Worked
B503 | Test Clinic | 7 | PH 7400 | 09/15/2017 | 1
B503 | Test Clinic | 7 | PH 7400 | 09/15/2017 | 1
B503 | Test Clinic | 8 | PH 7404 | 09/18/2017
B503 | Test Clinic | 8 | PH 7404 | 09/18/2017
B503 | Test Clinic | 8 | PH 7404 | 09/08/2017 | 500
B503 | Test Clinic | 8 | PH 7404 | 09/08/2017 | 500
B503 | Test Clinic | 9 | PH 7406 | 09/21/2017 | 1
B503 | Test Clinic | 102 | 102test | 09/16/2017
Test Clinic Total |  | 1019.8
Grand Total |  | 1019.8
Spreadsheet: 875891d1722517703-lottery-tracker-needed-number-test
Sheet: Sheet1

Game | #1 | #2 | #3 | #4 | #5 | #6 | # [NAME] | PB Matched |  | Check number | #1 | #2 | #3 | #4 | #5 | PB |  | # | [NAME] |  | # | [NAME]
1 |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 1 | 52 | 41 | 3 |  | 1 |  |  | 1
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 2
3 |  |  |  |  |  |  |  |  |  | Match? | 1 | 2 | 3 | 4 | 5 | PB |  | 3 |  |  | 3
4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | 5
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 6
7 |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  | 7
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 8
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 - Q5 tells you if you matched? | 16 |  |  | 16 |  |  | n
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 105197d1302627299-transfer-data-from-master-sheet-to-different-sheets-sample
Sheet: History Test

 | 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
Cooper | 77 | 80 | 99
Janice | 95 | 80 | 85 | 77
Spreadsheet: 106410d1303663632-project-sales-based-on-known-awards-amount-over-time-pyojext-sales
Sheet: Sheet2

 | Total Sales | 150000
 | Periods (Months | 9
 | Distributer | 18
 | Adjustment | 6.313751761862358 | By [NAME]
 | Calculated total | 149999.99
 | Jan | 7341.52 | 1
 | Feb | 13964.41 | 2
 | Mar | 19220.35 | 3
 | Apr | 22594.88 | 4
 | May | 23757.67 | 5
 | Jun | 22594.88 | 6
 | Jul | 19220.35 | 7
 | Aug | 13964.41 | 8
 | Sep | 7341.52 | 9 |  |  |  |  | 15
Spreadsheet: 772086d1647001886-gantt-chart-with-predecessors-project-schedule
Sheet: Sheet2

Area 1
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 2
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 3
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 4
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 5
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 6
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 7
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 8
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 9
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 10
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 11
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 12
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 13
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 14
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 15
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 16
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 17
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 18
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 19
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 20
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 21
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 22
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 23
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 24
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 25
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 26
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 27
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 28
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 29
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 30
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 31
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 32
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 33
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 34
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Area 35
 | Task 1
 | Task 2
 | Task 3
 | Task 4
 | Task 5
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: HLAD

Old course number | New course number
HLAD-301 | HLAD-3101
HLAD-302 | HLAD-3102
HLAD-303 | HLAD-3103
HLAD-304 | HLAD-3104
HLAD-325 | HLAD-3105
HLAD-335 | HLAD-3106
HLAD-340 | HLAD-3107
HLAD-401 | HLAD-4101
HLAD-450 | HLAD-4108
HLAD-455 | HLAD-4105
HLAD-460 | HLAD-4104
HLAD-465 | HLAD-4103
HLAD-468 | HLAD-4901
HLAD-470 | HLAD-4001
HLAD-480 | [NAME]
HLAD-490 | HLAD-4099
HLAD-502 | HLAD-4106
HLAD-503 | HLAD-4107
HLAD-520 | HLAD-5101
HLAD-525 | HLAD-5102
HLAD-530 | HLAD-5103
HLAD-582 | HLAD-5001
HLAD-630 | HLAD-6001
HLAD-700 | HLAD-7101
HLAD-701 | HLAD-7102
HLAD-702 | HLAD-7103
HLAD-703 | HLAD-7104
HLAD-705 | HLAD-7105
HLAD-713 | HLAD-7106
HLAD-715 | HLAD-7107
HLAD-718 | HLAD-7108
HLAD-725 | HLAD-7109
HLAD-740 | HLAD-7110
HLAD-745 | HLAD-7111
HLAD-755 | HLAD-7112
HLAD-801 | HLAD-8100
HLAD-806 | HLAD-8101
HLAD-820 | HLAD-8102
HLAD-823 | HLAD-8103
HLAD-833 | HLAD-8104
HLAD-835 | HLAD-8105
HLAD-837 | HLAD-8106
HLAD-846 | HLAD-8107
HLAD-850 | HLAD-8108
HLAD-855 | [NAME]
HLAD-865 | HLAD-8902
HLAD-870 | HLAD-8109
HLAD-880 | [NAME]
HLAD-890 | HLAD-8111
Spreadsheet: 274823d1383230390-reference-sheet-in-workbook-to-use-dependent-drop-down-lists-equipment-and-cost-estimate-testing-2
Sheet: Summary

[NAME] |  | PRICE | UNIT | MATERIAL | MATERIAL | LABOR | LABOR | UNINC. MATL | UNINC. MATL
EQUIPMENT |  |  |  | UNIT COST | TOTAL | UNIT COST | TOTAL | UNIT COST | TOTAL | TOTAL
TOTAL
 | =INDEX('Piping and Fitting'!$B$3:$B$1000,MATCH('Piping and Fitting'!G3,'Piping and Fitting'!$A$3:$A$1000,0)):INDEX('Piping and Fitting'!$B$3:$B$1000,MATCH('Piping and Fitting'!G3,'Piping and Fitting'!$A$3:$A$1000,0)+COUNTIF('Piping and Fitting'!$A$3:$A$1000,'Piping and Fitting'!G3)-1)
 |  | PRICE | UNIT | MATERIAL | MATERIAL | LABOR | LABOR | UNINC. MATL | UNINC. MATL
INTERCONNECT TUBING & VALVES |  |  |  | UNIT COST | TOTAL | UNIT COST | TOTAL | UNIT COST | TOTAL | TOTAL
8'' x | [NAME], SS, Schedule 5
2'' | Pipe, SS, Schedule 5
4'' | Tubing, SS, 304L, Bright Annealed
2'' | Pipe, SS, Schedule 5
4'' | Pipe, SS, Schedule 10
1/4'' | Tubing, Copper, Type K
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.5 | 48 | 58 | 28
TOTAL
Spreadsheet: 855691d1705193660-add-year-in-an-if-statement-payments-example-1-
Sheet: Sheet1

 | Due Date | Cycle |  | New Due Date
 | 2024-10-09 00:00:00 | M
 | 2024-01-12 00:00:00 | Y |  | 2025-01-12 00:00:00
 | 2024-01-12 00:00:00 | M
 | 1900-01-12 00:00:00 | M
 | 2024-01-14 00:00:00 | M
 | 2024-12-12 00:00:00 | Q |  | 2024-03-12 00:00:00
 | 2024-01-29 00:00:00 | M
 | 2024-01-30 00:00:00 | M
 | 2024-01-31 00:00:00 | Q
Spreadsheet: 747876d1631745279-how-to-have-excel-count-the-lengths-of-continuous-ranges-how-to-have-excel-count-the-lengths-of-continuous-ranges
Sheet: Sheet1

220.74 | 1 |  | 8 |  |  | All_Num | =Sheet1!$A$1:INDEX(Sheet1!$A:$A,MATCH(1E+307,Sheet1!$A:$A))
222.42
221.52
224.78
221.77
223.39
226.62
228.43
-208.12 |  |  | 1
-198.12 |  |  | 18
-197.47
-194.96
-196.59
-195
-192.05
-192.91
-195.55
-195.91
-194.07
-186.09
-187.77
-181.58
-189.63
-198.39
-202.46
-205.08
-200.46
180.16 |  |  | 8
178.22
174.22
173.55
174.5
176.12
175.71
169.63
140.61 |  |  | 7
140.11
141.61
142.37
136.6
137.53
143
124.63 |  |  | 24
125.15
115.84
124.52
123.61
127.95
133.96
138.32
137.05
132.98
144.88
141.32
143.45
149.15
148.18
148.95
153.18
149.5
152.4
147.53
142.52
144.28
135.81
136.55
128.5 |  |  | 6
131.91
135.22
134.75
136.12
132.67
132.48 |  |  | 4
132.21
129.45
131.27
134.27 |  |  | 4
134.15
134.09
135.01
Spreadsheet: 76818d1277303951-copy-and-paste-question-example
Sheet: Chopped Up Long Data Close

[NAME] | -0.05 |  |  |  |  | 1 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 4
Trailing Stop | 0.02 |  |  |  |  | New Rating | Old Rating |  |  |  | New Rating | Old Rating |  |  |  | New Rating | Old Rating |  |  |  | New Rating | Old Rating |  |  |  | New Rating | Old Rating
Lock In Profit | 0.03 |  |  |  |  | Buy | Initiating |  |  |  | Buy | Neutral |  |  |  | Buy | Sell |  |  |  | Neutral | Initiating |  |  |  | Neutral | Sell |  |  | 1 | Buy | Initiating
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Buy | Neutral
Average Return | #N/A |  |  |  | Average Return | #N/A |  |  |  | Average Return | #N/A |  |  |  | Average Return | #N/A |  |  |  | Average Return | #N/A |  |  |  | Average Return | #N/A |  |  |  | 3 | Buy | Sell
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Neutral | Initiating
Ticker | % Return | Ticker | % Return |  | Ticker | % Return | Ticker | % Return |  | Ticker | % Return | Ticker | % Return |  | Ticker | % Return | Ticker | % Return |  | Ticker | % Return | Ticker | % Return |  | Ticker | % Return | Ticker | % Return |  | 5 | Neutral | Sell
Ticker | BB Ticker | Long/Short | New Rating | Old Rating | U/D Before ERN? | U/D After ERN? | Earnings Date | Date | Comment | Pair |  | 5 Day % ∆ | 30 Day % ∆ |  |  | Day 1 | Day 2 | Day 3 | 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
STOP
STOP
[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Formula 2
Spreadsheet: 136611d1326741386-multiple-ifs-with-text-labels-book2
Sheet: Sheet1

Result | Ideal result | Check | Previus Check |  | 1-2 days1hour | OK
1hour | 2hours | Wrong | WRONG |  | 1-2 days2hours | OK |  | Result (possible scenarios) | Ideal result (possible scenarios)
2hours | 1hour | OK |  |  | 1hour1hour | OK |  | not produced | 1hour
 |  |  |  |  | 2hours1hour | OK |  | 1hour | 2hours
 |  |  |  |  | 2hours2hours | OK |  | 2hours | 1-2 days
 |  |  |  |  | 1-2 days1-2 days | OK |  | 1-2 days
 |  |  |  |  | 1-2 daysnot produced | Wrong
 |  |  |  |  | 1hour1-2 days | Wrong
 |  |  |  |  | 1hour2hours | Wrong
 |  |  |  |  | 1hournot produced | Wrong
 |  |  |  |  | 2hours1-2 days | Wrong
 |  |  |  |  | 2hoursnot produced | Wrong
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending November 16, by product type and tenor (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 690200d1596941710-create-combinations-and-count-them-create-combinations-and-count
Sheet: Sheet1

 |  |  | Data |  |  |  |  |  | Result
 |  |  | Order # | Item #1 | Item #2 | Item #3 |  |  | Combination | Count
 |  |  | 1045 | A | B |  |  |  | AB or BA | 2
 |  |  | 1046 | C | B | A |  |  | AC or CA | 2
 |  |  | 1047 | D | E |  |  |  | BC or CB | 1
 |  |  | 1048 | F | G | B |  |  | DE or ED | 1
 |  |  | 1049 | A | C |  |  |  | FG or GF | 1
 |  |  |  |  |  |  |  |  | GB or BG | 1
 |  |  |  |  |  |  |  |  | BF or FB | 1
Spreadsheet: 890014d1741126131-array-formula-to-replace-in-line-formula-wrestling
Sheet: Contents

 |  | Behind The Scenes |  | Cartoon |  | Deleted Scene |  | Event |  | Extra Scene |  | Interview |  | Movie |  | Post-Show |  | Pre-Show |  | Press Conferance |  | Show |  | Trailer
 |  | # | GB | # | GB | # | GB | # | GB | # | GB | # | GB | # | GB | # | GB | # | GB | # | GB | # | GB | # | GB
*Collaborations | *Collaborations
All Elite Wrestling | AEW
All Japan Pro Wrestling | AJPW
American Wrestling Association | AWA
[NAME] | CMLL
DEFY Wrestling | DEFY
Dramatic Dream Team Pro-Wrestling | DDT
Duke City Championship Wrestling | DCCW
Eastern Championship Wrestling | ECW*
Evolve | EVOLVE
Extreme Championship Wrestling | ECW
Future Stars of Wrestling | FSW
Game Changer Wrestling | GCW
[NAME] | Greektown
Hoodslam | Hoodslam
House of Glory Wrestling | HOG
Insane Championship Wrestling | ICW
International Wrestling Revolution Group | IWRG
Jersey Championship Wrestling | JCW*
Juggalo Championship Wrestling | JCW
Lucha Underground | Lucha Underground
Lutte 07 | Lutte 07
Major League Wrestling | MLW
Michoacan Pro Wrestling | MPW*
Micro Championship Wrestling | MCW
Mid-Atlantic Championship Wrestling | MACW
[NAME] | MPW
Mystery Wrestling | MW
National Wrestling Alliance | NWA
New Japan Pro Wrestling | NJPW
Next Level Pro Wrestling | NLPW
NORTH Wrestling | NCL
Ohio Valley Wrestling | OVW
Power Pro Wrestling | PPW
Primos Premier Pro Wrestling | PPPW
Pro Gay Wrestling | PGW
Pro Wrestling 4 U | PW4U
Pro Wrestling Revolver | WR Revolver
Progress Wrestling | Progress
Qatar Pro Wrestling | QPW
Reality of Wrestling | ROW
Ring Of Honor | [NAME]
Santino Bros. Wrestling | SB.W
Shimmer Women Athletes | SHIMMER
Smoky Mountain Wrestling | SMW
Strong Classic Wrestling | SCW
Sumo | Sumo
Tokyo [NAME] | TJWP
Total Non-Stop Action | TNA
UK Wrestling | UKW
Underworld Wrestling | UW
United States Wrestling Association | USWA
Universal Wrestling Federation | UWF
Westside Xtreme Wrestling | wXw
Women of Wrestling | WOW
World Championship Wrestling | WCW
World Class Championship Wrestling | WCCW
World of Sport Wrestling | WOSW
World Wonder Ring Stardom | ST★RDOM
World Wrestling Entertainment | WWE
Wrestling Evolution | WE
Wrestling Society X | WSX
True Grit Wrestling | TGW
Spreadsheet: john_griffith__15751__10_16_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 260 | 32 | 33.5 | 93.3 | 97.7 | 15.61 | 2001-10-16 14:47:00
 | NG Z1 | 285 | 57 | 59 | 74.4 | 77 | 13.56 | 2001-10-16 14:47:00
 | NG F2 | 305 | 78.5 | 79 | 74 | 74.5 | 14.24 | 2001-10-16 14:47:00
 | NG G2 | 305 | 86.5 | 89.5 | 67.7 | 70.1 | 13.21 | 2001-10-16 14:47:00
 | NG H2 | 300 | 85 | 88 | 60.2 | 62.4 | 11.56 | 2001-10-16 14:47:00
 | NG J2 | 285 | 76 | 80 | 51.6 | 54.4 | 9.5 | 2001-10-16 14:47:00
 | NG K2 | 290 | 79 | 82 | 48.5 | 50.4 | 9.02 | 2001-10-16 14:47:00
 | NG M2 | 295 | 84 | 87 | 47 | 48.7 | 8.87 | 2001-10-16 14:47:00
 | NG N2 | 300 | 87 | 91 | 45.3 | 47.4 | 8.74 | 2001-10-16 14:47:00
 | NG Q2 | 300 | 94 | 98 | 46.5 | 48.5 | 8.96 | 2001-10-16 14:47:00
 | NG U2 | 300 | 101 | 103.5 | 47.6 | 48.8 | 9.09 | 2001-10-16 14:47:00
 | NG V2 | 305 | 102 | 108 | 45.4 | 48.1 | 8.96 | 2001-10-16 14:47:00
 | [NAME] | 340 | 124 | 133 | 46.1 | 49.5 | 10.22 | 2001-10-16 14:47:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 826379d1681978018-conditional-formatting-by-month-pieceinc
Sheet: Sheet1

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Spreadsheet: 739852d1626010341-selecting-cells-to-sum-based-on-last-occurring-incidence-of-criteria-mock-up-scenario-for-formula
Sheet: mock up scenario

Date | Person | Status | value |  |  | expected result
2021-01-01 00:00:00 | Person 1 | start | 1 |  |  | 1
2021-01-02 00:00:00 | Person 1 | include | 2 |  |  | 2
2021-01-03 00:00:00 | Person 1 | include | 2 |  |  | 3
2021-01-04 00:00:00 | Person 1 | end | 3 |  |  | 4
2021-01-05 00:00:00 | Person 1 |  |  |  |  | blank
2021-01-02 00:00:00 | Person 2 | start | 1 |  |  | 1
2021-01-03 00:00:00 | Person 2 | include | 2 |  |  | 2
2021-01-04 00:00:00 | Person 2 | include | 2 |  | This cell should calculate from D9 to D11 | 3
2021-01-05 00:00:00 | Person 2 | end | 3 |  |  | 4
2021-01-03 00:00:00 | Person 2 |  |  |  |  | blank
2021-01-04 00:00:00 | Person 2 |  |  |  |  | blank
2021-01-05 00:00:00 | Person 2 | start | 1 |  | This cell should only calculate D15 | 1
2021-01-06 00:00:00 | Person 2 | include | 2 |  |  | 2
2021-01-07 00:00:00 | Person 2 | end | 3 |  |  | 3
2021-01-08 00:00:00 | Person 2 |  |  |  |  | blank
2021-01-09 00:00:00 | Person 2 | start | 1 |  |  | 1
2021-01-10 00:00:00 | Person 2 | end | 3 |  | This cell should only calculate from D19 to D20 | 2
2021-01-04 00:00:00 | Person 3 | start | 1 |  |  | 1
2021-01-05 00:00:00 | Person 3 | include | 2 |  |  | 2
2021-01-06 00:00:00 | Person 3 | include | 2 |  |  | 3
2021-01-07 00:00:00 | Person 3 | include | 2 |  |  | 4
2021-01-05 00:00:00 | Person 3 | end | 3 |  |  | 5
2021-01-06 00:00:00 | Person 3 | start | 1 |  |  | 1
2021-01-07 00:00:00 | Person 3 | include | 2 |  |  | 2
2021-01-08 00:00:00 | Person 3 | include | 2 |  |  | 3
2021-01-09 00:00:00 | Person 3 | end | 3 |  | example: The formula in this cell should start calculation from D26 only (the last "START" status for this person) and finish D29 and ignore all previous records for this person and any other person | 4
2021-01-10 00:00:00 | Person 4 | start | 1 |  |  | 1
2021-01-11 00:00:00 | Person 4 | include | 2 |  |  | 2
2021-01-07 00:00:00 | Person 4 | include | 2 |  |  | 3
2021-01-08 00:00:00 | Person 4 | include | 2 |  |  | 4
2021-01-09 00:00:00 | Person 4 | include | 2 |  |  | 5
2021-01-10 00:00:00 | Person 4 | end | 3 |  |  | 6
2021-01-11 00:00:00 | Person 4 |  |  |  |  | blank
2021-01-12 00:00:00 | Person 4 |  |  |  |  | blank
2021-01-13 00:00:00 | Person 4 | start | 1 |  |  | 1
2021-01-14 00:00:00 | Person 4 | include | 2 |  |  | 2
2021-01-15 00:00:00 | Person 4 | end | 3 |  |  | 3
Spreadsheet: 97704d1296817587-sorting-duplicated-data-with-excel-list
Sheet: Sheet1

CODES | LEADING | KEY |  |  |  | UNIQUE LIST OF LEADING EXTRACTED USING ADVANCED FILTER ON COL B
AP001A | AP001 | AP001-1 |  |  |  | AP001 | AP001A | AP001B | AP001C | AP001D
AP001B | AP001 | AP001-2 |  |  |  | [NAME] | AP234A | AP234B
AP001C | AP001 | AP001-3 |  |  |  | AP123 | AP123A | AP123B | AP123C
AP234A | [NAME] | AP234-1 |  |  |  | AX123 | AX123A | AX123B | AX123C | AX123G | AX123H | AX123I | AX123A | AX123D | AX123E | AX123F
AP234B | [NAME] | AP234-2
AP123A | AP123 | AP123-1
AP123B | AP123 | AP123-2
AP001D | AP001 | AP001-4
AX123A | AX123 | AX123-1
AX123B | AX123 | AX123-2
AX123C | AX123 | AX123-3
AX123G | AX123 | AX123-4
AX123H | AX123 | AX123-5
AX123I | AX123 | AX123-6
AX123A | AX123 | AX123-7
AX123D | AX123 | AX123-8
AX123E | AX123 | AX123-9
AX123F | AX123 | AX123-10
AP123C | AP123 | AP123-3
Spreadsheet: f73c6b98-b04d-47cf-880c-e0e9a922f19a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TIMG | Test | TIMG | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
TIMG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TIMG | Result | TIMG | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6265-3