tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884955d1734357212-grading-matrix-sample_file_121424-2-
Sheet: Sample (2)

 | Metric 1 | Metric 2 | Metric 3 | Metric 4 | Metric 5 | Score
2024-12-08 00:00:00 | 1 | 1 | 1 | 1 | 1
2024-12-09 00:00:00 | 1 | 1 | 1 | 1 | 0
2024-12-10 00:00:00 | 1 | 1 | 1 | 0 | 0
2024-12-11 00:00:00 | 1 | 1 | 0 | 0 | 0
2024-12-12 00:00:00 | 0 | 0 | 0 | 0 | 0
2024-12-13 00:00:00
2024-12-14 00:00:00
Weekly Score |  |  |  |  |  |  | Sum of all the scores, on a scale of 1-100
Input Area
Scoring | Weight | Description
Metric 1 | 1 | Yes or No
Metric 2 | 1.25 | Yes or No
Metric 3 | 0.5 | Yes or No
Metric 4 | 1.25 | Yes or No
Metric 5 | 1 | Yes or No
Spreadsheet: 127740d1320517399-vlookup-query-vlookup-problem
Sheet: Data

GROUP | POS | SCORE
C | 1 | 80
C | 2 | 60
C | 3 | 40
1 | 1 | 60
1 | 2 | 40
1 | 3 | 20
2 | 1 | 40
2 | 2 | 20
2 | 3 | 10
3 | 1 | 20
3 | 2 | 10
3 | 3 | 5
Spreadsheet: 741927d1627410061-if-then-statement-with-great-than-and-less-than-if-then-less-great-forum
Sheet: Sheet1

MRN | Patient | Date | Dept | Provider/Resource | Appt Time | Type | Age (Years) | Age Bracket
1 | g | 2021-06-03 00:00:00 | RMGAIRAP [101224006] | 1 | 09:10:00 | OV [11700421] | 73 | 65andOlder
2 | a | 2020-07-23 00:00:00 | RMGAAG [101212001] | 2 | 09:30:00 | DOX/FT/SKY [117002527] | 17 | 0 to 18
3 | i | 2021-02-04 00:00:00 | RMGAILO [101201006] | 3 | 13:50:00 | NP [11700045] | 12 | 0 to 18
3 | j | 2020-12-14 00:00:00 | RMGAILO [101201006] | 4 | 08:30:00 | DOX/FT/SKY [117002527] | 53 | 19 to 64
4 | k | 2020-11-05 00:00:00 | RMGAILO [101201006] | 5 | 15:50:00 | Self RFL [11700291] | 53 | 19 to 64
5 | l | 2021-02-26 00:00:00 | RMGAAG [101212001] | 5 | 08:30:00 | O20 [11700552] | 60 | 19 to 64
Spreadsheet: 745187d1629799690-partial-match-between-two-lists-with-names-partial-match-sample
Sheet: Sheet1

 | Helper columns, can be hidden. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need formula | Need formula | Need Formula |  | Lookup table
 | % match-character length |  |  |  | 0.8 |  | 0.7 |  | 0.6 |  | 0.5 |  | Account Name 2 | Account No.
Account name | 0.8 |  |  |  | From left | From right | From left | From right | From left | From right | From left | From right |  |  |  | Partial Match | Account Name 2 | Account No. |  | Account name 2 | Account No.
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | [NAME] | 1 |  | [NAME] | 1
Academia LTD B.V |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Academia LTD BV | 2 |  | Academia LTD BV | 2
Åkes Værksted Hellerup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Aakes Vaerksted Hellerup | 3 |  | Aakes Vaerksted Hellerup | 3
Yrsted Hansi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | [NAME] | 4 |  | [NAME] | 4
Chocolate 123 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  | Yhanska 123 | 5
Tysale LTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Tysale LTD | 6 |  | Kjalovo ABC | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tysale LTD | 6
 |  |  |  |  | row index in lookup table
I would suggest 4 levers of matching 80, 70, 60 , 50%, and check from the left and from the right, with helper columns.
It works for:
"Academia LTD B.V" vs "Academia LTD BV" : 80% from the left
"Åkes Værksted Hellerup" vs "Aakes Vaerksted Hellerup" : 70% from the right
But, it does not work for:
"Jakobs North West" vs "[NAME]" : not match from left or right
In case you only want it up to 70%, just delete 60% and 50%
Spreadsheet: 00eff674-be24-453c-b7f0-5c3c0d5fd27b
Sheet: RETIREMENT PLANS

RETIRE_PLAN | EPR_REDUCE | REDUCTION |  | WORKSHEET RANGE NAMES | RANGE
1 | 1 |  |  | RET_PLAN | A:1-C:15
2 | 0.827443 |  |  | RET_CODE | A:2-A:15
3 | 1
5 | 1 |  |  | ANNUAL UPDATES:
6 | 1 |  |  | Update the EPR reduction factor in the EPR_REDUCE column.
7 | 1
8 | 0.88594
G | 1
B | 1
D | 0.88594
C | 1
4 | 1
A | 1
F | 1
Spreadsheet: 702701d1604491530-returning-the-latest-status-example
Sheet: Sheet1

Service ID | DTL-Invoice line item | [NAME] service start date | [NAME] service end date | dtl - service status |  |  |  | Service ID | Status | [NAME] service start date | [NAME] service end date
Broadband |  |  |  |  |  |  |  | Broadband | Active | 2017-12-27 00:00:00
T.V |  |  |  |  |  |  |  | Broadband | Ceased | 2018-03-23 00:00:00 | 2018-03-23 00:00:00
Landline |  |  |  |  |  |  |  | T.V | Active | 2017-04-18 00:00:00
Mobile |  |  |  |  |  |  |  | T.V | Ceased | 2018-03-23 00:00:00 | 2018-03-23 00:00:00
Alarm |  |  |  |  |  |  |  | Landline | Active | 2020-07-10 00:00:00
 |  |  |  |  |  |  |  | Landline | Ceased | 2017-07-02 00:00:00 | 2017-07-02 00:00:00
 |  |  |  |  |  |  |  | Mobile | Active | 2020-07-09 00:00:00
 |  |  |  |  |  |  |  | Mobile | Ceased | 2018-05-01 00:00:00 | 2018-05-01 00:00:00
 |  |  |  |  |  |  |  | Alarm | Active | 2020-07-10 00:00:00
 |  |  |  |  |  |  |  | Alarm | Ceased | 2018-05-01 00:00:00 | 2018-05-01 00:00:00
Spreadsheet: 101038d1299191668-sorting-pivot-table-by-show-value-as-pivot-sorting-example
Sheet: Pivot

Sum of Spend | Status
Row Labels | Preferred | Non-Preferred | Grand Total
Subject 1 | 0.961551985831827 | 0.03844801416817296 | 1
Subject 10 | 0.9247709882634265 | 0.07522901173657338 | 1
Subject 11 | 0.9402753308142888 | 0.05972466918571128 | 1
Subject 12 | 0.9014827432885923 | 0.09851725671140772 | 1
Subject 13 | 0.5092083808313455 | 0.4907916191686545 | 1
Subject 14 | 0.767933154260059 | 0.232066845739941 | 1
Subject 15 | 0.985914061790463 | 0.01408593820953708 | 1
Subject 16 | 0.1109762112335316 | 0.8890237887664684 | 1
Subject 17 | 0.899895987931633 | 0.1001040120683671 | 1
Subject 18 | 0.8019285057305027 | 0.1980714942694973 | 1
Subject 19 | 0.4182782745370006 | 0.5817217254629994 | 1
Subject 2 | 0.8821077089982615 | 0.1178922910017385 | 1
Subject 20 | 0.976194556053222 | 0.02380544394677794 | 1
Subject 21 | 0.4144722512728543 | 0.5855277487271457 | 1
Subject 22 | 0.7732866740647951 | 0.2267133259352049 | 1
Subject 23 | 0.6169408884033969 | 0.3830591115966031 | 1
Subject 24 | 0.9063324670068718 | 0.09366753299312833 | 1
Subject 25 | 0.8478846330008731 | 0.1521153669991269 | 1
Subject 26 | 0.4311070052142473 | 0.5688929947857527 | 1
Subject 27 | 1 | 0 | 1
Subject 28 | 0.8983310735576325 | 0.1016689264423675 | 1
Subject 29 | 0.4855771747339156 | 0.5144228252660844 | 1
Subject 3 | 0.7969779615044746 | 0.2030220384955252 | 1
Subject 30 | 0.9573143942547662 | 0.04268560574523379 | 1
Subject 31 | 0.2971221288414986 | 0.7028778711585014 | 1
Subject 32 | 0.3554062342705647 | 0.6445937657294353 | 1
Subject 33 | 0.1359914224492944 | 0.8640085775507057 | 1
Subject 34 | 0.9866298585395743 | 0.01337014146042571 | 1
Subject 35 | 0.2544130463357439 | 0.7455869536642561 | 1
Subject 36 | 1 | 0 | 1
Subject 4 | 0.8743165925381542 | 0.1256834074618458 | 1
Subject 5 | 0.9895987497334912 | 0.01040125026650889 | 1
Subject 6 | 0.8345429676814051 | 0.1654570323185949 | 1
Subject 7 | 0.97038441214921 | 0.02961558785079003 | 1
Subject 8 | 0.8927681089338249 | 0.1072318910661751 | 1
Subject 9 | 0.5560997147345856 | 0.4439002852654143 | 1
Grand Total | 0.8575905631838142 | 0.1424094368161857 | 1
Spreadsheet: 021ac26a-0ec0-49f9-858f-38cd54f8548d
Sheet: Sheet1

STATE OF ILLINOIS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
VILLAGE OF HOFFMAN ESTATES
TABULATION OF BIDS
2011 WS CONCRETE SITE RESTORATION
County:  [NAME] |  |  |  | Date:  February 9, 2011 |  |  | Landmark Contractors, Inc. |  | Globe Construction |  | Strada Construction Co.
Municipality or Road District: |  |  |  | Time: 10:00 a.m. |  |  | 11916 [NAME] |  | 1781 Armitage Ct. |  | 1742 [NAME].
 | [NAME] |  |  | Attended by: [NAME] |  |  | Huntley, IL 60142 |  | Addison, IL 60101 |  | Addison, IL 60101
Section:
Estimate $
Proposal Guarantee: |  |  |  |  |  |  | [NAME] |  | [NAME] |  | [NAME]
Terms:
Items |  |  | Delivery |  | Unit | Quantity | Unit Price | Total | Unit Price | Total | Unit Price | Total
2011 Services
Sidewalk Removal/Replacement |  |  |  |  | square feet | 1750 | 18.75 | 32812.5 | 8.5 | 14875 | 7.25 | 12687.5
Curb/Gutter Removal/Replacement |  |  |  |  | [NAME] | 250 | 98.5 | 24625 | 65 | 16250 | 28 | 7000
6" Driveway Pavement Removal/Replacement |  |  |  |  | square yards | 250 | 225 | 56250 | 79 | 19750 | 64 | 16000
 |  |  | Total Bid |  |  |  |  | 113687.5 |  | 50875 |  | 35687.5
 |  |  | Total Bid
Spreadsheet: 677861d1589556416-formula-to-count-names-against-other-names-template
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Processor |  | Reviewer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roman | Avijit | Fazle
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Roman |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Avijit |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Tanvir |  | [NAME] |  |  | Tanvir
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Avijit |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Avijit |  |  | Mehedi
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Avijit
 |  |  |  |  |  |  |  |  |  |  |  |  | Tanvir |  | Avijit
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Avijit
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Avijit
 |  |  |  |  |  |  |  |  |  |  |  |  | Mehedi |  | Avijit
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Tanvir |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Mehedi |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Mehedi |  | Roman
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Roman
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Avijit
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Roman
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Roman
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Avijit
Spreadsheet: 762779d1641813545-how-to-use-if-or-something-else-to-insert-a-value-based-on-percentage-of-change-file1
Sheet: Sheet1

Deposit | 100
Rate | 0.015
Units | 0.01 | 0.1
 |  |  | Transaction No. | Deposit | Rate | Final Deposit | Units
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
Spreadsheet: 155783d1337037661-help-with-my-fantasy-result-prediction-spreadsheet-it-cant-work-out-0-0-scorelines-srs-draft-2
Sheet: Table

 |  |  |  |  |  |  | Result Table (to date)
Name | Points |  |  |  |  |  | Rank |  | Points |  |  |  |  |  |  |  | Rank | Points
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 100
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 80
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 0
Spreadsheet: larry_campbell__21310__LFC0700V1
Sheet: NJN E

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
NJN | E | 2000 |  | PICATINNY |  | dth | 10 |  |  |  |  | Picatinny Arsenal
NJN | E | 2000 |  | PRESS PLANT |  | dth | 11000 |  |  |  |  | Main Plant & Press Plant
NJN | E | 2000 |  | PRESS PLANT-F |  | dth | 600 |  |  |  |  | McWilliams Forge - Firm
NJN | E | 2000 |  | STARWOOD |  | dth | 1100 |  |  |  |  | Starwood Hotels
Spreadsheet: 196242d1353931678-formula-for-highest-score-determined-by-sum-of-scores-sample-workbook
Sheet: Tabelle1

 | List of Top Students
 | Class 1
 |  |  | Sum scores |  |  | Sum scores |  |  | Sum scores
 |  | 72 | 170 |  | 80 | 139 |  | 48 | 112
 |  | Math |  |  | Math |  |  | History
 | Class2
 |  | Name | Sum scores |  | Name | Sum scores |  | Name | Sum scores
 |  | Math |  |  | Math |  |  | History
Spreadsheet: 137392d1327087720-timesheet-needs-hours-to-repeat-have-used-sum-if-to-get-total-criterial-sumtest
Sheet: Sheet1

Code | EmpID | Fname | Mname | Lname | Dept | [NAME] | sumproduct | [NAME]
1 | 22094 | Mark |  | [NAME] | AUI | 64
4 | 22094 | Mark |  | [NAME] | AUI | 8
7 | 22094 | Mark |  | [NAME] | AUI | 8
1 | 22244 | [NAME] | C | [NAME] | AUI | 66.67
4 | 22244 | [NAME] | C | [NAME] | AUI | 8
7 | 22244 | [NAME] | C | [NAME] | AUI | 8
1 | 22909 | [NAME] |  | Smith | ISG | 63.12
4 | 22909 | [NAME] |  | Smith | ISG | 16
7 | 22909 | [NAME] |  | Smith | ISG | 8
1 | 24721 | Anne |  | Heath | AIC | 51.25
4 | 24721 | Anne |  | Heath | AIC | 24
7 | 24721 | Anne |  | Heath | AIC | 8
1 | 24749 | Mark |  | Palmer | ISG | 72.78
4 | 24749 | Mark |  | Palmer | ISG | 8
7 | 24749 | Mark |  | Palmer | ISG | 8
1 | 28189 | [NAME] |  | [NAME] | AUI | 78
7 | 28189 | [NAME] |  | [NAME] | AUI | 8
1 | 47744 | Kathy |  | Bailey | AIC | 81
7 | 47744 | Kathy |  | Bailey | AIC | 8
1 | 48071 | Penny |  | Childress | AUI | 69.25
4 | 48071 | Penny |  | Childress | AUI | 8
7 | 48071 | Penny |  | Childress | AUI | 8
1 | 49667 | [NAME] |  | Camp | Jr | 72.6
7 | 49667 | [NAME] |  | Camp | Jr | 8
1 | 62976 | Scott |  | Moody | AUI | 68.02
4 | 62976 | Scott |  | Moody | AUI | 4.07
7 | 62976 | Scott |  | Moody | AUI | 8
1 | 66289 | Scott | N | [NAME] | AIC | 72
7 | 66289 | Scott | N | [NAME] | AIC | 8
1 | 66376 | Peggy |  | Ford | ISG | 43.7
4 | 66376 | Peggy |  | Ford | ISG | 33.72
7 | 66376 | Peggy |  | Ford | ISG | 8
1 | 80459 | Becki |  | Gardner | MIG SC | 71.13
4 | 80459 | Becki |  | Gardner | MIG SC | 8
7 | 80459 | Becki |  | Gardner | MIG SC | 8
1 | 85330 | Sandra | H | Major | AUI | 73.38
7 | 85330 | Sandra | H | Major | AUI | 8
1 | 118071 | [NAME] | [NAME] | Morrison | ITP | 61.77
4 | 118071 | [NAME] | [NAME] | Morrison | ITP | 16
7 | 118071 | [NAME] | [NAME] | Morrison | ITP | 8
1 | 132861 | [NAME] |  | Byrd | AUI | 53.97
4 | 132861 | [NAME] |  | Byrd | AUI | 24
7 | 132861 | [NAME] |  | Byrd | AUI | 8
1 | 133126 | [NAME] | D | Compton | ISG | 69.58
4 | 133126 | [NAME] | D | Compton | ISG | 11.68
7 | 133126 | [NAME] | D | Compton | ISG | 8
1 | 137752 | [NAME] |  | Neel | AUI | 80.88
7 | 137752 | [NAME] |  | Neel | AUI | 8
1 | 138422 | [NAME] | B | Crownover | AUI | 39.57
4 | 138422 | [NAME] | B | Crownover | AUI | 32
7 | 138422 | [NAME] | B | Crownover | AUI | 8
1 | 150264 | Joel | C | Ammons | ISG | 81
7 | 150264 | Joel | C | Ammons | ISG | 8
1 | 155841 | [NAME] |  | Parraga | AIC | 75.83
7 | 155841 | [NAME] |  | Parraga | AIC | 8
1 | 157510 | Fred |  | [NAME] | AUI | 87.07
4 | 157510 | Fred |  | [NAME] | AUI | 3.5
7 | 157510 | Fred |  | [NAME] | AUI | 8
1 | 165945 | [NAME] |  | [NAME] | AIC | 63
4 | 165945 | [NAME] |  | [NAME] | AIC | 16
7 | 165945 | [NAME] |  | [NAME] | AIC | 8
1 | 170775 | Yolanda |  | Smith | USA | 64
4 | 170775 | Yolanda |  | Smith | USA | 8
7 | 170775 | Yolanda |  | Smith | USA | 8
1 | 174142 | Rex | A | Lynch | MRA | 74.48
7 | 174142 | Rex | A | Lynch | MRA | 8
1 | 178972 | [NAME] | K | Seagroves | USA | 82.03
7 | 178972 | [NAME] | K | Seagroves | USA | 8
Spreadsheet: louise_kitchen__22553__Hot List Update 07-17-01 - Management
Sheet: Storage +50

Deal Description Sheet - 7/17/01
Storage
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Big Red-1 | Bieniawski | Halliburton Energy Services | Origination credit from [NAME].  [NAME] would manage HES' 100-150,000 MMBtu of flowing supply. | 75 | 2001-07-11 00:00:00 | 0.5 | 2001-08-01 00:00:00 | Met with SVP.  [NAME] and list of due diligence items,
Big Red-2 | Bieniawski | Halliburton Energy Services | Manage HES' commodity position derived from storage capacity assigned by Northern Natural as payment for HES services. | 500 | 2001-07-11 00:00:00 | 0.5 | 2001-08-01 00:00:00 | HES' wants to begin promoting product to its customers.
Blowfish | Rainer | Dow Chemical, OxyChem, or Texas Brine | Sale of 330-acre tract of land at Napoleonville salt dome, LA | 1500 | 2001-06-22 00:00:00 | 1 | 2001-09-01 00:00:00 | Texas Brine has verbally expressed interest in the land, meeting scheduled for 7/20/01.  In process of obtaining bid or confirmation of interest from Dow.
Spreadsheet: 816229d1675435647-vacation-time-vacation-time-calculator
Sheet: Wayne Joseph

Sick Time Calculated
Employee Name |  |  |  |  | Date of Hire | 2023 Used Sick Time | Previous Year Carry Over
[NAME] |  |  |  |  |  |  | 0
Payroll Week | Sunday-Saturday | Vacation | Holiday | Hours Worked | Weekly Total | [NAME] | Total Accrued Sick | Sick Used | Sick Available
Week Ending | 2023-01-07 00:00:00 |  | 8 | 29.48
Week Ending | 2023-01-14 00:00:00 |  | 8 | 30.1
Week Ending | 2023-01-21 00:00:00 |  |  | 39.17
Week Ending | 2023-01-28 00:00:00 |  |  | 39.51
Week Ending | 2023-02-04 00:00:00 |  |  | 38.07
Week Ending | 2023-02-11 00:00:00
Week Ending | 2023-02-18 00:00:00
Week Ending | 2023-02-25 00:00:00
Week Ending | 2023-03-04 00:00:00
Week Ending | 2023-03-11 00:00:00
Week Ending | 2023-03-18 00:00:00
Week Ending | 2023-03-25 00:00:00
Week Ending | 2023-04-01 00:00:00
Week Ending | 2023-04-08 00:00:00
Week Ending | 2023-04-15 00:00:00
Week Ending | 2023-04-22 00:00:00
Week Ending | 2023-04-29 00:00:00
Week Ending | 2023-05-06 00:00:00
Week Ending | 2023-05-13 00:00:00
Week Ending | 2023-05-20 00:00:00
Week Ending | 2023-05-27 00:00:00
Week Ending | 2023-06-03 00:00:00
Week Ending | 2023-06-10 00:00:00
Week Ending | 2023-06-17 00:00:00
Week Ending | 2023-06-24 00:00:00
Week Ending | 2023-07-01 00:00:00
Week Ending | 2023-07-08 00:00:00
Week Ending | 2023-07-15 00:00:00
Week Ending | 2023-07-22 00:00:00
Week Ending | 2023-07-29 00:00:00
Week Ending | 2023-08-05 00:00:00
Week Ending | 2023-08-12 00:00:00
Week Ending | 2023-08-19 00:00:00
Week Ending | 2023-08-26 00:00:00
Week Ending | 2023-09-02 00:00:00
Week Ending | 2023-09-09 00:00:00
Week Ending | 2023-09-16 00:00:00
Week Ending | 2023-09-23 00:00:00
Week Ending | 2023-09-30 00:00:00
Week Ending | 2023-10-07 00:00:00
Week Ending | 2023-10-14 00:00:00
Week Ending | 2023-10-21 00:00:00
Week Ending | 2023-10-28 00:00:00
Week Ending | 2023-11-04 00:00:00
Week Ending | 2023-11-11 00:00:00
Week Ending | 2023-11-18 00:00:00
Week Ending | 2023-11-25 00:00:00
Week Ending | 2023-12-02 00:00:00
Week Ending | 2023-12-09 00:00:00
Week Ending | 2023-12-16 00:00:00
Week Ending | 2023-12-23 00:00:00
Week Ending | 2023-12-30 00:00:00
Spreadsheet: 63830d1264699936-countifs-for-dates-testdata
Sheet: Sheet1

Date Opened | Closed Date | Verification Date
2010-01-06 00:00:00
2009-11-02 00:00:00 | 2009-11-02 00:00:00
2010-01-17 00:00:00 | 2010-01-01 00:00:00 | 2010-01-27 00:00:00
2010-01-06 00:00:00
2009-11-02 00:00:00
2010-01-17 00:00:00
2010-01-06 00:00:00 | 2009-08-15 00:00:00 | 2010-01-10 00:00:00
2009-11-02 00:00:00 | 2009-11-16 00:00:00 | 2009-12-31 00:00:00
2010-01-17 00:00:00 | 2010-01-22 00:00:00
2010-01-06 00:00:00
Spreadsheet: 144513d1331019098-generate-report-of-count-of-unique-occurences-of-data-for-each-column-copy_sales
Sheet: results

5 |  |  |  | 2
JAN |  |  |  | FEB
Unique | Count | Total |  | Unique | Count | Total
1 | 4 | 4 |  | 1 | 8 | 8
2 | 4 | 8 |  | 2 | 10 | 20
3 | 4 | 12
6 | 1 | 6
9 | 1 | 9
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: 8

Name | lbs | oz | Oz (total) | Points
 | 0 | 2
 | 14 | 12
 | 10 | 7
 | 27 | 0
 | 19 | 12
 | 6 | 10
 | 0 | 0
 | 18 | 12
 | 3 | 0
 | 0 | 8
 | 6 | 2
 | 5 | 4
 | 0 | 3
 | 35 | 0
 | 7 | 4
 | 0 | 0
 | 5 | 3
Spreadsheet: 798394d1664460666-sort-of-a-countif-but-not-sample-data-for-forum
Sheet: Sheet1

Sheet 1 |  |  |  |  |  |  | Sheet 2
Property Reference | Date Property Was Built | 30 Days After Property Was Built | 60 Days After Property Was Built | Number of Repairs 30 Days After Property Was Built | Number of Repairs 60 Days After Property Was Built |  | Property Reference | Date Repair was Carried Out
1 | 2010-01-01 00:00:00 |  |  |  |  |  | 1 | 2010-01-01 00:00:00
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
Spreadsheet: 765979d1643708740-sumifs-with-date-and-time-criteria-rainfall-test-2-aligw
Sheet: Rainfall Data

 |  |  |  |  |  | Date | Rainfall
2019-05-02 00:00:00 | 16:55:31 | 0.2
2019-05-02 00:00:00 | 16:56:32 | 0.2
2019-05-02 00:00:00 | 16:57:06 | 0.2
2019-05-02 00:00:00 | 16:57:46 | 0.2
2019-05-02 00:00:00 | 16:58:11 | 0.2
2019-05-02 00:00:00 | 16:58:45 | 0.2
2019-05-02 00:00:00 | 17:00:01 | 0.2
2019-05-02 00:00:00 | 17:02:02 | 0.2
2019-05-02 00:00:00 | 17:08:57 | 0.2
2019-05-02 00:00:00 | 20:53:59 | 0.2
2019-05-02 00:00:00 | 20:57:34 | 0.2
2019-05-02 00:00:00 | 21:04:00 | 0.2
2019-05-03 00:00:00 | 10:04:11 | 0.2
2019-05-03 00:00:00 | 10:14:01 | 0.2
2019-05-03 00:00:00 | 10:47:34 | 0.2
2019-05-03 00:00:00 | 12:12:37 | 0.2
2019-05-03 00:00:00 | 20:11:27 | 0.2
2019-05-04 00:00:00 | 06:01:35 | 0.2
2019-05-04 00:00:00 | 12:33:01 | 0.2
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 10c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | 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 | N/A | N/A
Estimated net notional amount outstanding, August 16 weekly snapshot, by product type and major currency (millions of USD), cleared swaps only, all participant types and tenors.
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 currency 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: 887596d1737839952-filter-filter
Sheet: Sumário

RESP: | João
Nº | ITENS | DATA | RESP | JAN | FEV | MAR | ABR | MAI | JUN | JUL | AGO | SET | OUT | NOV | DEZ
 | A | 2025-01-01 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
3 | B | 2025-01-03 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
4 | B | 2025-01-04 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
2 | B | 2025-01-02 00:00:00 | João | 7 | 8 | 9 | 10 | 11 | 12
5 | E | 2025-01-05 00:00:00 | João | 7 | 8 | 9 | 10 | 11 | 12
6 | F | 2025-01-06 00:00:00 | João | 7 | 8 | 9 | 10 | 11 | 12
7 | G | 2025-01-07 00:00:00 | João | 7 | 8 | 9 | 10 | 11 | 12
8 | H | 2025-01-08 00:00:00 | João | 7 | 8 | 9 | 10 | 11 | 12