tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683775d1592934482-merge-cells-merge-cells
Sheet: Sheet1

Item Description | WBS Charge Code | Subsystem | Milestone | Start Date | Start Date2 | Procurement Type | FY20 OCT | [NAME] | FY20 DEC | FY20 JAN | FY20 FEB | FY20 MAR | FY20 APR | FY20 MAY | FY20 [NAME] | FY20 JUL | FY20 AUG | FY20 SEP | FY20 YEAR | FY21 OCT | FY21 NOV | FY21 DEC | FY21 JAN | FY21 FEB | FY21 MAR | FY21 APR | FY21 MAY | FY21 JUN | FY21 JUL | FY21 AUG | FY21 SEP | FY21 YEAR | FY22 OCT | FY22 NOV | FY22 DEC | FY22 JAN | FY22 FEB | FY22 MAR | FY22 APR | FY22 MAY | FY22 JUN | FY22 JUL | FY22 AUG | FY22 SEP | FY22 YEAR | FY23 OCT | FY23 NOV | FY23 DEC | FY23 JAN | FY23 FEB | FY23 MAR | FY23 APR | FY23 MAY | FY23 JUN | FY23 JUL | FY23 AUG | FY23 SEP | FY23 YEAR | Grand Total
Description 1 | WBS1 |  | Milestone 3 | 2019-10-01 00:00:00 | 2021-09-30 00:00:00 | Obligation |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Description 1 | WBS1 |  | Milestone 3 | 2019-10-01 00:00:00 | 2021-09-30 00:00:00 | Cost |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Description 2 | WBS2 |  | Milestone 3 | 2019-10-01 00:00:00 | 2021-09-30 00:00:00 | Obligation |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Description 2 | WBS2 |  | Milestone 3 | 2019-10-01 00:00:00 | 2021-09-30 00:00:00 | Cost |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Description 3 | WBS3 |  | Milestone 3 | 2019-10-01 00:00:00 | 2021-09-30 00:00:00 | Obligation |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Description 3 | WBS3 |  | Milestone 3 | 2019-10-01 00:00:00 | 2021-09-30 00:00:00 | Cost |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 759480d1639570490-need-multiple-values-from-lookup-value-book2
Sheet: Lookup values

Emp Number | Emp Name | Cost center | STAFFING PERCENTAGE
128745 | [NAME] | T85755 | 100
128791 | [NAME] | T82301 | 50
128791 | [NAME] | T82302 | 50
128792 | Deepak Dalal | T82289 | 99
128792 | Deepak Dalal | T82290 | 1
128793 | [NAME] | T82289 | 50
128793 | [NAME] | T82290 | 50
128794 | [NAME] | T82295 | 50
128794 | [NAME] | T82296 | 50
Spreadsheet: 707237d1607113443-index-match-formula-not-working-properly-from-data-in-pivot-tables-help-november-mileage-and-fuel
Sheet: SUMMARY

Truck | 01 |  |  | 1022 |  |  | 2907 |  |  | 667896 |  |  | 7006 |  |  | 73 |  |  | 88
State | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER | [NAME] | GALLONS | REEFER
AL
AR
AZ
CA
CO
CT
DE
FL
GA
IA
ID
IL
IN
KS
KY
LA
MA
MD
ME
MI
MN
MO
MS
MT
NC
ND
NE
NH
NJ
NM
NV
NY
OH
OK
OR
PA
RI
SC
SD
TN
TX
UT
VA
VT
WA
WI
WV
WY
Spreadsheet: 164151d1340659536-sort-array-of-dates-into-single-column-datesamplemalina
Sheet: manual

Date Loan Matures | IPTD | Payment due dates | Dates Payments were received | Dates interest rate changed | default date | Date when loan balance changed |  | Payoff Calculations
2013-02-15 00:00:00 | 2010-11-02 00:00:00 | 2010-12-05 00:00:00 | 2010-12-05 00:00:00 | 2010-12-03 00:00:00 | 2011-02-06 00:00:00 | 2010-11-06 00:00:00 |  | Date | description
 |  | 2011-01-05 00:00:00 | 2011-01-07 00:00:00 | 2011-01-09 00:00:00 |  | 2010-11-22 00:00:00 |  | 2010-11-02 00:00:00 | IPTD
 |  | 2011-02-05 00:00:00 | 2011-02-03 00:00:00 | 2011-02-01 00:00:00 |  | 2010-12-01 00:00:00 |  | 2010-11-06 00:00:00 | Date when loan balance changed
 |  |  |  | 2011-03-01 00:00:00 |  |  |  | 2010-11-22 00:00:00 | Date when loan balance changed
 |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Date when loan balance changed
 |  |  |  |  |  |  |  | 2010-12-03 00:00:00 | Dates interest rate changed
 |  |  |  |  |  |  |  | 2010-12-05 00:00:00 | Payment due dates
 |  |  |  |  |  |  |  | 2010-12-05 00:00:00 | Dates Payments were received
 |  |  |  |  |  |  |  | 2011-01-05 00:00:00 | Payment due dates
 |  |  |  |  |  |  |  | 2011-01-07 00:00:00 | Dates Payments were received
 |  |  |  |  |  |  |  | 2011-01-09 00:00:00 | Dates interest rate changed
 |  |  |  |  |  |  |  | 2011-02-01 00:00:00 | Dates interest rate changed
 |  |  |  |  |  |  |  | 2011-02-03 00:00:00 | Dates Payments were received
 |  |  |  |  |  |  |  | 2011-02-05 00:00:00 | Payment due dates
 |  |  |  |  |  |  |  | 2011-02-06 00:00:00 | default date
 |  |  |  |  |  |  |  | 2011-03-01 00:00:00 | Dates interest rate changed
 |  |  |  |  |  |  |  | 2013-02-15 00:00:00 | Date Loan Matures
I have the above set of date columns |  |  |  |  |  |  |  | the dates need to automatically end up sorted as above
Spreadsheet: 174028d1344889260-searching-for-times-by-date-and-person-sample-data
Sheet: Bruce

Date | Expected Login | Actual Login | Difference | Expected Logout | Actual Logout | Difference
2012-08-06 00:00:00 | 08:00:00 |  |  | 17:00:00
2012-08-07 00:00:00 | 08:00:00 |  |  | 17:00:00
2012-08-08 00:00:00 | 08:00:00 |  |  | 17:00:00
2012-08-09 00:00:00 | 08:00:00 |  |  | 17:00:00
2012-08-10 00:00:00 | 08:00:00 |  |  | 17:00:00
Spreadsheet: 0442c9f2-30dc-4cc0-8949-0c2e0acac3ed
Sheet: Invsigtns, Exams, and Commits

 |  | Pre-Sentence Investigation Reports (I.C. 19-2524) |  |  | Designated Examinations  by Ordering County |  |  |  |  | Civil Commitments (I.C. 66-329)  by Ordering County
 |  | Monthly | SFY2014 |  | Monthly County Total | Monthly Regional Total | SFY2014 County Total | SFY2014 Regional Total |  | Monthly County Total | Monthly Regional Total | SFY2014 County Total | SFY2014 Regional Total
Region 1 | Benewah | 5 | 10 |  | 5 |  | 7
 | [NAME] |  |  |  | 3 |  | 21 |  |  | 1 |  | 8
 | Boundary
 | Kootenai |  |  |  | 47 |  | 215 |  |  | 6 |  | 27
 | Shoshone |  |  |  |  |  | 9 |  |  |  |  | 1
Region 2 | Clearwater | 2 | 7 |  | 2 |  | 7 |  |  | 1 |  | 3
 | Idaho |  |  |  | 1 |  | 6 |  |  |  |  | 2
 | Latah |  |  |  | 6 |  | 23 |  |  |  |  | 8
 | Lewis |  |  |  |  |  | 2
 | Nez Perce |  |  |  | 11 |  | 48 |  |  | 1 |  | 5
Region 3 | Adams | 19 | 47 |  | 1 |  | 5 |  |  | 1 |  | 1
 | Canyon |  |  |  | 75 |  | 312 |  |  | 9 |  | 49
 | Gem |  |  |  | 7 |  | 18 |  |  |  |  | 1
 | Owyhee
 | Payette |  |  |  |  |  | 8
 | Washington |  |  |  | 3 |  | 11 |  |  |  |  | 2
Region 4 | [NAME] | 1 | 17 |  | 159 |  | 585 |  |  | 26 |  | 140
 | Boise |  |  |  | 1 |  | 2
 | Elmore |  |  |  | 6 |  | 14 |  |  | 1 |  | 4
 | Valley
Region 5 | Blaine | 7 | 27 |  | 3 |  | 12 |  |  |  |  | 1
 | [NAME] |  |  |  |  |  | 3
 | Cassia |  |  |  | 4 |  | 15 |  |  | 1 |  | 5
 | Gooding |  |  |  | 1 |  | 9 |  |  |  |  | 3
 | [NAME] |  |  |  | 1 |  | 12 |  |  | 1 |  | 1
 | Lincoln |  |  |  | 2 |  | 5
 | Minidoka |  |  |  | 1 |  | 14 |  |  |  |  | 3
 | [NAME] |  |  |  | 27 |  | 104 |  |  | 2 |  | 9
Region 6 | Bannock | 2 | 21 |  | 19 |  | 91 |  |  | 6 |  | 39
 | Bear Lake |  |  |  |  |  | 2 |  |  |  |  | 2
 | [NAME] |  |  |  |  |  | 1
 | Franklin |  |  |  | 1 |  | 5 |  |  |  |  | 1
 | Oneida |  |  |  |  |  | 1
 | Power |  |  |  | 1 |  | 3 |  |  |  |  | 2
Region 7 | Bingham | 8 | 27 |  | 7 |  | 43 |  |  | 2 |  | 21
 | [NAME] |  |  |  | 18 |  | 70 |  |  | 7 |  | 29
 | [NAME]
 | [NAME]
 | Custer |  |  |  |  |  | 3 |  |  |  |  | 1
 | Fremont |  |  |  | 2 |  | 3 |  |  | 1 |  | 1
 | [NAME] |  |  |  | 2 |  | 8 |  |  | 1 |  | 1
 | Lemhi |  |  |  |  |  | 3 |  |  |  |  | 1
 | [NAME] |  |  |  | 3 |  | 8 |  |  |  |  | 2
 | Teton |  |  |  |  |  | 3 |  |  |  |  | 1
Unknown |  |  |  |  |  |  | 2
Statewide
 |  | October 192524 | FY 192524
 |  | 2 | 22
 |  | 4 | 12
 |  | 10 | 67
 |  | 17 | 85
 |  | 7 | 33
 |  | 8 | 45
 |  | 13 | 63
 |  | 61 | 327
Spreadsheet: 0d1a0d6e-9d7f-452d-9e9b-9f4e20145760
Sheet: Page 1

 | Permit No.: | WQ0034380 |  | Facility Name: |  | Sanderson Farms WWTF |  |  |  |  |  | County: |  | Lenoir |  | Month: |  |  |  | Year:
 |  | Field Name: |  | 1A |  | Field Name: |  | 1B |  | Field Name: |  | 2A |  | Field Name: |  | 2B |  | Field Name: |  | 3A
 |  | Area (acres): |  | 22.4 |  | Area (acres): |  | 8.81 |  | Area (acres): |  | 22.4 |  | Area (acres): |  | 10.4 |  | Area (acres): |  | 24
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
Spreadsheet: 2d7a4021-7f57-490d-90e5-9b238ceb73ea
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of May 11-17
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2008-05-12 00:00:00 | 2008-05-12 00:00:00 | 2008-05-12 00:00:00 | 2008-05-12 00:00:00 | 2008-05-12 00:00:00 | 2008-05-12 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2008-05-12 00:00:00 | 2008-05-12 00:00:00 | 2008-05-12 00:00:00 | 2008-05-12 00:00:00 | 2008-05-12 00:00:00 | 2008-05-12 00:00:00
 | Top (A) | 10471 | 17500 | 74116 | 10453 | 17220 | 31043
 | Center (A) | 10436 | 17450 | 73973 | 10421 | 17194 | 30752
 | Flat (A) | 10451 | 17506 | 74131 | 10448 | 17191 | 30900
 | Left  (A) | 10458 | 17460 | 74140 | 10452 | 17195 | 31047
 | Right (A) | 10451 | 17473 | 74187 | 10452 | 17213 | 31007
 | Average (A) | 10453 | 17478 | 74109 | 10445 | 17203 | 30950
 | [NAME]  (A) | 13 | 24 | 81 | 14 | 13 | 126
 | Comments
Exposure | Date (Exposure) | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.0s | 1.6s | 3.0s x2 | 1.0s | 1.6s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00 | 2008-05-15 00:00:00
 | Top (H/V) (um) | 1 / 1 | 1 / 1.5 | 2 / 2 | 1 / 1 | 1 / 1.5 | 2 / 2
 | Center (H/V) (um) | 1 / 1 | 1 / 1.5 | 2 / 2 | 1 / 1 | 1.5 / 1.5 | 1.5 / 2
 | Flat (H/V) (um) | 1 / 1 | 1 / 1 | 2 / 1.5 | 1 / 1 | 1.5 / 1.5 | 2 / 2
 | Left (H/V) (um) | 1 / 1 | 1 / 1.5 | 2 / 2 | 1 / 1 | 1 / 1.5 | 2 / 2
 | Right (H/V) (um) | 1 / 1 | 1 / 1.5 | 2 / 2 | 1 / 1 | 1 / 1.5 | 2 / 2
 | Comments
Spreadsheet: 5019af0f-9aa5-4443-83df-66b748f49a10
Sheet: Inter-District Goal 1

 |  |  | Integration Revenue Budget Worksheet
 |  |  |  |  | FY14
 |  |  |  | Inter-District Budget: Goal 1
District Number: |  |  |  | District Name:
Please insert Inter-district integration goal #1 from your district's desegregation plan:
Line Item Description |  | UFARS | Code | (Required) |  | Budgeted Amount |  | Actual Expenditures
 |  |  |  |  |  |  |  | Resubmit this form with
Provide a short description |  |  |  |  |  | Provide the total amount |  | the actual FY14
of the expenditure. |  | ORG | PROG | FIN | OBJ | budgeted for this line item |  | expenditures by 12/1/14.
TOTAL
PARTICIPATION INFORMATION |  |  |  |  |  | Projected (7/1/13) |  | Actual
 |  |  |  |  |  | Students | Staff | Students | Staff
Participation from Racially Isolated District (RI):
Participation from Your District (if not the RI):
Participation from Other Member Districts:
Total Program Participation:
Notes or Comments:
Spreadsheet: 859209d1707671951-how-to-display-record-of-last-10-games-nhl-schedule-sample
Sheet: Sheet1

 | Home |  |  |  |  |  | Visitor
Date | Team | Score | OT | RW | ROW | W/L/OTL | Score | OT | RW | ROW | W/L/OTL | Team |  |  | Carolina Hurricanes
2023-10-10 00:00:00 | Tampa Bay Lightning | 5 |  | x | x |  | 3 |  |  |  |  | Carolina Hurricanes
 | Pittsburgh Penguins | 2 |  |  |  |  | 4 |  | x | x |  | Chicago Blackhawks
 | [NAME] Knights | 4 |  | x | x |  | 1 |  |  |  |  | Carolina Hurricanes
2023-10-11 00:00:00 | Carolina Hurricanes | 5 |  | x | x |  | 3 |  |  |  |  | Ottawa Senators
 | Toronto Maple Leafs | 6 |  |  |  |  | 5 | x |  |  |  | [NAME]
 | [NAME] | 3 |  | x | x |  | 1 |  |  |  |  | Chicago Blackhawks
 | Carolina Hurricanes | 5 |  | x | x |  | 3 |  |  |  |  | Winnipeg Jets
 | Los Angeles Kings | 2 |  |  |  |  | 5 |  | x | x |  | Carolina Hurricanes
 | Carolina Hurricanes | 8 |  | x | x |  | 1 |  |  |  |  | Edmonton Oilers
2023-10-12 00:00:00 | Buffalo Sabres | 1 |  |  |  |  | 5 |  | x | x |  | New York Rangers
 | Carolina Hurricanes | 2 |  |  |  |  | 4 |  | x | x |  | Philadelphia Flyers
 | New Jersey Devils | 4 |  | x | x |  | 3 |  |  |  |  | Detroit Red Wings
 | Dallas Stars | 2 |  |  |  |  | 1 | x |  |  |  | St. Louis Blues
 | Carolina Hurricanes | 2 |  | x | x |  | 0 |  |  |  |  | Florida Panthers
 | Carolina Hurricanes | 3 |  | x | x |  | 0 |  |  |  |  | [NAME]
 | San Jose Sharks | 1 |  |  |  |  | 4 |  | x | x |  | Carolina Hurricanes
2023-10-13 00:00:00 | New Jersey Devils | 3 | x |  |  |  | 4 |  |  |  |  | Carolina Hurricanes
Spreadsheet: 290767d1389970537-dealing-with-lists-where-the-number-of-records-change-offset-example-1-
Sheet: Sheet3 - Calculations

 |  |  |  | Key field for Green | Key field for Blue | Key field match | Name match | Address match
Spreadsheet: 636604d1565375671-help-calendar-correction-employee-absence-schedule-current-6-5-19
Sheet: September

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | September | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  |  |  | Vacation Days Taken/Year | Vacation  Days Taken/Month | Days Picked Up/Month | Sick Days/Month
 | [NAME]
 | Lynda
 | [NAME]
 | Heather |  |  |  | p
 | [NAME]
 | Emili |  | v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p
 | Amber |  |  | v | v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v | v
 | Meredith |  | v
 | Julie
Spreadsheet: 776543d1649780562-automatic-ranking-standings-bouwcenter-poule-f1-2022-v1a
Sheet: Results Sprint

Results sprintraces
King of speed |  |  | King of speed |  |  | King of speed
1 |  |  | 1 |  |  | 1
2 |  |  | 2 |  |  | 2
3 |  |  | 3 |  |  | 3
4 |  |  | 4 |  |  | 4
5 |  |  | 5 |  |  | 5
6 |  |  | 6 |  |  | 6
7 |  |  | 7 |  |  | 7
8 |  |  | 8 |  |  | 8
Spreadsheet: 878533d1725630434-retrieve-a-teams-home-and-away-match-from-a-table-of-teams-home-away_example
Sheet: Sheet1

 | home | away | home | away | home | away | home | away | home | away | home | away | home | away | home | away |  | Team 1 | Home | Away
2024-09-19 00:00:00 | 1 | 16 | 2 | 15 | 3 | 14 | 4 | 13 | 5 | 12 | 6 | 11 | 7 | 10 | 8 | 9 |  |  | 1 | 16
2024-09-26 00:00:00 | 16 | 9 | 10 | 8 | 11 | 7 | 12 | 6 | 13 | 5 | 14 | 4 | 15 | 3 | 1 | 2 |  |  | 1 | 2
2024-10-03 00:00:00 | 2 | 16 | 3 | 1 | 4 | 15 | 5 | 14 | 6 | 13 | 7 | 12 | 8 | 11 | 9 | 10 |  |  | 3 | 1
2024-10-10 00:00:00 | 16 | 10 | 11 | 9 | 12 | 8 | 13 | 7 | 14 | 6 | 15 | 5 | 1 | 4 | 2 | 3 |  |  | 1 | 4
2024-10-17 00:00:00 | 3 | 16 | 4 | 2 | 5 | 1 | 6 | 15 | 7 | 14 | 8 | 13 | 9 | 12 | 10 | 11 |  |  | 5 | 1
2024-10-24 00:00:00 | 16 | 11 | 12 | 10 | 13 | 9 | 14 | 8 | 15 | 7 | 1 | 6 | 2 | 5 | 3 | 4 |  |  | etc
2024-10-31 00:00:00 | 4 | 16 | 5 | 3 | 6 | 2 | 7 | 1 | 8 | 15 | 9 | 14 | 10 | 13 | 11 | 12
2024-11-07 00:00:00 | 16 | 12 | 13 | 11 | 14 | 10 | 15 | 9 | 1 | 8 | 2 | 7 | 3 | 6 | 4 | 5
2024-11-14 00:00:00 | 5 | 16 | 6 | 4 | 7 | 3 | 8 | 2 | 9 | 1 | 10 | 15 | 11 | 14 | 12 | 13
2024-11-21 00:00:00 | 16 | 13 | 14 | 12 | 15 | 11 | 1 | 10 | 2 | 9 | 3 | 8 | 4 | 7 | 5 | 6
2024-11-28 00:00:00 | 6 | 16 | 7 | 5 | 8 | 4 | 9 | 3 | 10 | 2 | 11 | 1 | 12 | 15 | 13 | 14
2024-12-05 00:00:00 | 16 | 14 | 15 | 13 | 1 | 12 | 2 | 11 | 3 | 10 | 4 | 9 | 5 | 8 | 6 | 7
2024-12-12 00:00:00 | 7 | 16 | 8 | 6 | 9 | 5 | 10 | 4 | 11 | 3 | 12 | 2 | 13 | 1 | 14 | 15
2024-12-19 00:00:00 | 16 | 15 | 1 | 14 | 2 | 13 | 3 | 12 | 4 | 11 | 5 | 10 | 6 | 9 | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
2025-01-02 00:00:00 | 8 | 16 | 9 | 7 | 10 | 6 | 11 | 5 | 12 | 4 | 13 | 3 | 14 | 2 | 15 | 1
2025-01-09 00:00:00 | 16 | 1 | 15 | 2 | 14 | 3 | 13 | 4 | 12 | 5 | 11 | 6 | 10 | 7 | 9 | 8
2025-01-16 00:00:00 | 9 | 16 | 8 | 10 | 7 | 11 | 6 | 12 | 5 | 13 | 4 | 14 | 3 | 15 | 2 | 1
2025-01-23 00:00:00 | 16 | 2 | 1 | 3 | 15 | 4 | 14 | 5 | 13 | 6 | 12 | 7 | 11 | 8 | 10 | 9
2025-01-30 00:00:00 | 10 | 16 | 9 | 11 | 8 | 12 | 7 | 13 | 6 | 14 | 5 | 15 | 4 | 1 | 3 | 2
2025-02-06 00:00:00 | 16 | 3 | 2 | 4 | 1 | 5 | 15 | 6 | 14 | 7 | 13 | 8 | 12 | 9 | 11 | 10
2025-02-13 00:00:00 | 11 | 16 | 10 | 12 | 9 | 13 | 8 | 14 | 7 | 15 | 6 | 1 | 5 | 2 | 4 | 3
2025-02-20 00:00:00 | 16 | 4 | 3 | 5 | 2 | 6 | 1 | 7 | 15 | 8 | 14 | 9 | 13 | 10 | 12 | 11
2025-02-27 00:00:00 | 12 | 16 | 11 | 13 | 10 | 14 | 9 | 15 | 8 | 1 | 7 | 2 | 6 | 3 | 5 | 4
2025-03-06 00:00:00 | 16 | 5 | 4 | 6 | 3 | 7 | 2 | 8 | 1 | 9 | 15 | 10 | 14 | 11 | 13 | 12
2025-03-13 00:00:00 | 13 | 16 | 12 | 14 | 11 | 15 | 10 | 1 | 9 | 2 | 8 | 3 | 7 | 4 | 6 | 5
2025-03-20 00:00:00 | 16 | 6 | 5 | 7 | 4 | 8 | 3 | 9 | 2 | 10 | 1 | 11 | 15 | 12 | 14 | 13
2025-03-27 00:00:00 | 14 | 16 | 13 | 15 | 12 | 1 | 11 | 2 | 10 | 3 | 9 | 4 | 8 | 5 | 7 | 6
2025-04-03 00:00:00 | 16 | 7 | 6 | 8 | 5 | 9 | 4 | 10 | 3 | 11 | 2 | 12 | 1 | 13 | 15 | 14
2025-04-10 00:00:00 | 15 | 16 | 14 | 1 | 13 | 2 | 12 | 3 | 11 | 4 | 10 | 5 | 9 | 6 | 8 | 7
2025-04-17 00:00:00 | 16 | 8 | 7 | 9 | 6 | 10 | 5 | 11 | 4 | 12 | 3 | 13 | 2 | 14 | 1 | 15
Spreadsheet: 148315d1333353286-vlookup-return-multiple-values-into-separate-cells-example3
Sheet: Sheet3

products_id | products_model
21527 | 5810
21528 | 5810
21529 | 5810
21530 | 5811
21531 | 5811
21532 | 5811
21533 | 5812
21534 | 5812
21535 | 5813
21536 | 5813
Spreadsheet: 859319d1707743628-counting-occurrences-in-months-book-1
Sheet: Sheet1 (2)

 |  |  |  | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  |  | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-12-31 00:00:00 | 2025-02-28 00:00:00
 |  |  | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 1 | 1 |  | 1 | 3 |  | 1 | 1
 |  |  | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 2 |  |  | 1 |  | 1 | 1
 |  |  | Area 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 3 |  | 1 |  |  |  |  |  | 1 | 1
 |  |  |  | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  |  | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00
 |  |  | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 1 | 1 | 2 |  |  | 1
 |  |  | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 2 | 1 |  | 1 | 1
 |  |  | Area 3
 |  |  | Scheme Pin | Description |  | Manager | Start Date | End Date | Duration | 24-25 Budget | Stage | Funding | Area
 |  |  | 612021 | Descrption A |  | [NAME] A | 2024-04-01 00:00:00 |  |  |  | Stage 3 |  | Area 1
 |  |  | 612678 | Descrption B |  | [NAME] | 2024-04-02 00:00:00 |  |  |  | Stage 3 |  | Area 2
 |  |  | 612662 | Descrption C |  | [NAME] C | 2024-02-05 00:00:00 |  |  |  | Stage 2 |  | Area 3
 |  |  | 613228 | Descrption D |  | [NAME] | 2024-05-06 00:00:00 |  |  |  | Stage 3 |  | Area 1
 |  |  | 566234 | Descrption E |  | [NAME] | 2024-05-05 00:00:00 |  |  |  | Stage 3 |  | Area 1
 |  |  | 614526 | Descrption F |  | [NAME] | 2024-05-31 00:00:00 |  |  |  | Stage 0 |  | Area 1
 |  |  | 614527 | Descrption G |  | [NAME] | 2024-06-06 00:00:00 |  |  |  | Stage 3 |  | Area 2
 |  |  | 601143 | Descrption H |  | [NAME] | 2024-07-09 00:00:00 |  |  |  | Stage 3 |  | Area 2
 |  |  | 600717 | Descrption I |  | [NAME] I | 2024-07-10 00:00:00 |  |  |  | Stage 0 |  | Area 1
 |  |  | 562650 | Descrption J |  | [NAME] J | 2024-12-12 00:00:00 |  |  |  | Stage 2 |  | Area 3
 |  |  | 615154 | Descrption K |  | [NAME] | 2024-01-01 00:00:00 |  |  |  | Stage 0 |  | Area 1
 |  |  | 614422 | Descrption L |  | [NAME] | 2025-02-03 00:00:00 |  |  |  | Srage 3 |  | Area 3
 |  |  | 614500 | Descrption M |  | [NAME] | 2024-08-09 00:00:00 |  |  |  | Stage 3 |  | Area 1