tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 08d965d8-ecb6-4d22-896b-3f43437ef405
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/04/2013 | Men's Basketball | Fairmont State (exhibition) | 07:00 PM | W, 89-70
11/08/2013 | Men's Basketball | Mount St. Mary's | 08:00 PM | W, 77-62
11/12/2013 | Men's Basketball | at Virginia Tech | 01:00 PM | L, 82-87
11/17/2013 | Men's Basketball | Duquesne | 04:00 PM | W, 96-83
11/21/2013 | Men's Basketball | Georgia Southern | 07:00 PM | W, 101-68
11/23/2013 | Men's Basketball | Presbyterian | 01:30 PM | W, 88-55
11/26/2013 | Men's Basketball | vs. Old Dominion | 06:00 PM | W, 78-60
11/27/2013 | Men's Basketball | vs. Wisconsin | 09:30 PM | L, 63-70
12/02/2013 | Men's Basketball | Loyola | 07:00 PM | W, 96-47
12/05/2013 | Men's Basketball | at Missouri (Big 12/SEC Challenge) | 07:00 PM | L, 71-80
12/10/2013 | Men's Basketball | Gonzaga | 09:00 PM | L, 76-80
12/14/2013 | Men's Basketball | vs. [NAME] (Charleston, W.Va.) | 07:30 PM | W, 74-64
12/22/2013 | Men's Basketball | Purdue | 01:00 PM | L, 70-73
[NAME] | Men's Basketball | vs. William & Mary (Charleston, W.Va.) | 03:00 PM | W, 82-45
01/04/2014 | Men's Basketball | at TCU* | 04:00 PM | W, 74-69
01/06/2014 | Men's Basketball | at Texas Tech* | 07:00 PM | W, 89-86 (OT)
01/11/2014 | Men's Basketball | Oklahoma State* | 01:00 PM | L, 72-73
01/13/2014 | Men's Basketball | Texas* | 07:00 PM | L, 69-80
01/18/2014 | Men's Basketball | at Kansas State* | 01:30 PM | L, 56-78
01/22/2014 | Men's Basketball | Texas Tech* | 08:00 PM | W, 87-81
01/25/2014 | Men's Basketball | at Oklahoma State* | 02:00 PM | L, 75-81
[NAME] | Men's Basketball | at Baylor* | 07:00 PM | W, 66-64
02/01/2014 | Men's Basketball | Kansas State* | 01:30 PM | W, 81-71
02/05/2014 | Men's Basketball | Oklahoma* | 07:00 PM | W, 91-86 OT
02/08/2014 | Men's Basketball | at Kansas* | 04:00 PM | L, 69-83
02/10/2014 | Men's Basketball | Iowa State* | 07:00 PM | W, 102-77
02/15/2014 | Men's Basketball | at Texas* | 08:00 PM | L, 71-88
[NAME] | Men's Basketball | Baylor* | 01:30 PM | L, 75-88
[NAME] | Men's Basketball | at Iowa State* | 08:00 PM | L, 66-83
03/01/2014 | Men's Basketball | TCU* | 01:30 PM | W, 81-59
03/05/2014 | Men's Basketball | at Oklahoma* | 09:00 PM | L, 62-72
03/08/2014 | Men's Basketball | Kansas* | 12:00 PM | W, 92-86
03/13/2014 | Men's Basketball | vs. Texas (Phillips 66 Big 12 Championships) | 09:30 PM | L, 49-66
03/18/2014 | Men's Basketball | at Georgetown (NIT) | 07:00 PM | L, 65-77
Spreadsheet: 173875d1344829423-how-to-get-same-data-on-2-axis-one-expressed-as-seconds-and-the-other-as-minutes-test
Sheet: Sheet1

 | Days in month | series 1 | series 2 | series 3 | series 4 | series 5 | series 6 | series 7 | series 8 | dummy
2012-01-01 00:00:00 | 31 | 96 | 88 | 92 |  |  |  | 45 | 273 | 5.3
2012-02-01 00:00:00 | 29 | 96 | 88 | 92 |  |  |  | 43 | 272 | 5.25
2012-03-01 00:00:00 | 31 | 96 | 88 | 92 |  |  |  | 20 | 261 | 4.683333333333334
2012-04-01 00:00:00 | 30 | 96 | 88 | 92 |  |  |  | 46 | 269 | 5.25
2012-05-01 00:00:00 | 31 | 96 | 88 | 92 |  |  |  | 32 | 275 | 5.116666666666666
2012-06-01 00:00:00 | 30 | 96 | 88 | 92 | 10 | 15 | 97 | 67 | 281 | 7.416666666666667
2012-07-01 00:00:00 | 31 | 96 | 88 | 92 | 14 | 11 | 96.96774193548387 | 94 | 288 | 7.982795698924732
2012-08-01 00:00:00 | 31
2012-09-01 00:00:00 | 30
2012-10-01 00:00:00 | 31
2012-11-01 00:00:00 | 30
2012-12-01 00:00:00 | 31
Spreadsheet: 846612d1697750537-dynamic-list-based-on-multiple-criteria-sample-book-6-
Sheet: Sheet1

CM | Name | Result | Follow Up Month | Result | Follow Up Month | Result | Follow Up Month | Result | Follow Up Month | Result | Follow Up Month
[NAME] | [NAME] |  | January
[NAME] | [NAME] |  |  |  |  |  |  |  | February |  | March
Janelle | [NAME] |  | January
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  | March
[NAME] | Elijah |  |  |  | March |  | January
Janelle | [NAME] |  | February |  |  |  |  |  |  |  | May
[NAME] | [NAME] |  |  |  |  |  | May |  | May
[NAME] | Lucas |  |  |  |  |  |  |  |  |  | March
Janelle | [NAME] |  |  |  | March
[NAME] | Theodore |  | February |  | March |  | April |  | April
[NAME] | Olivia |  |  |  |  |  |  |  |  |  | April
Janelle | Emma |  |  |  |  |  |  |  | April
[NAME] | Charlotte |  | February
[NAME] | Amelia |  |  |  |  |  | January |  |  |  | March
Janelle | Sophia |  |  |  | February
[NAME] | [NAME]
[NAME] | Ava |  |  |  |  |  |  |  | March
Janelle | [NAME] |  | May |  | May
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  | April
[NAME] | Luna
 | [NAME] | January | February | March | April | May
Spreadsheet: 113061d1309008006-show-me-the-oldest-date-and-adjacent-cell-contents-copy-of-csedate
Sheet: Sheet2

Display Inventory List |  | Date: | 2011-06-25 00:00:00
Asset Tag # | Date purchased | Years in Service | Serial No. | Type | Manufacturer | Model | Vendor | Building | Room/Area | Purchase Price | End of Service
0701212 | 2008-01-01 00:00:00 | 1 years 0 days (OOS) | 2452435 | Computer | Dell | 123 | MMS | Johns Hall | AAA | 1000 | 2009-01-01 00:00:00
0701213 | 1919-01-01 00:00:00 | 92 years 5 months 24 days | 245768 | Display | Sony | 456 | Whitlock | Johns Hall | BBB | 1000
0701214 | 1950-01-01 00:00:00 | 61 years 5 months 24 days | 984562 | Display | Phillips | 789 | MMS | Furman [NAME] | CCC | 1000
0701215 | 1903-01-01 00:00:00 | 108 years 5 months 24 days | 67898 | Computer | Dell | 123 | Whitlock | PAC | DDD | 1000
0701216 | 2008-02-01 00:00:00 | #N/A | 2452435 | Computer | Dell | 123 | MMS | Johns Hall | AAA | 1000 | 2005-02-02 00:00:00
0701217 | 1919-01-01 00:00:00 | 92 years 5 months 24 days | 245768 | Display | Sony | 456 | Whitlock | Johns Hall | BBB | 1000
0701218 | 1950-01-01 00:00:00 | 61 years 5 months 24 days | 984562 | Display | Phillips | 789 | MMS | Furman [NAME] | CCC | 1000
0701219 | 1903-01-01 00:00:00 | 108 years 5 months 24 days | 67898 | Computer | Dell | 123 | Whitlock | PAC | DDD | 1000
 |  | The oldest computer STILL IN SERVICE is: |  |  |  |  |  |  | 2 Oldest Intalls STILL IN SERVICE | 1/1/1903 (0701215)
 |  | 1906-01-02 00:00:00 | <<[NAME] must be entered using Control+Shift+Enter |  |  |  |  |  |  | 1/1/1903 (0701219)
 |  |  | For some reason when I moved your formula to this cell I can't get it to work -the date is incorrect now.
 |  | Ideally I'd like to merge these two formulas somehow so that I can show the "Ten newest installations still in service" and the  "Ten oldest installations still in service".  So the results would look like the info to the right.  It's based on whether or not there is a date in the L column (would this use the LARGE and SMALL functions?) -->
 |  |  |  |  |  |  |  |  | 2 Neweset installs STILL in service | 2/1/2008 (070 1216)
 |  |  |  |  |  |  |  |  |  | 1/1/2008 (0701212)
 |  | #N/A | I can't figure out how to properly syntax this now that I've switched the date / asset tag columns.  The asset is a unique indentifier so I moved it far left.
Spreadsheet: kate_symes__19038__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-04-05 00:00:00 |  | 200.55 | 5984 | 102.44 | 2408
 | 2001-04-04 00:00:00 |  | 199.23 | 4384 | 103.75 | 2232 | 148.64 | 1692 | 81.66 | 1580
 | 2001-04-03 00:00:00 |  | 188.58 | 4064 | 116.57 | 1632 | 117.12 | 1130 | 85.69 | 262
 | 2001-04-02 00:00:00 |  | 238.59 | 1024 | 150.88 | 912 | 137.01 | 2361 | 111.15 | 1000
 | 2001-04-01 00:00:00 |  | 180 | 800 | 107 | 600 | 148.11 | 1110 | 121.38 | 1200
 | 2001-03-31 00:00:00 |  | 154.62 | 624 | 95.02 | 1832 | 208.73 | 2005 | 132.05 | 925
 | 2001-03-30 00:00:00 |  | 154.62 | 624 | 94.91 | 1832 | 157.25 | 2240 | 118.11 | 1415
 | 2001-03-29 00:00:00 |  | 150.35 | 1824 | 96.1 | 1672 | 134.29 | 2045 | 98.07 | 1330
 | 2001-03-28 00:00:00 |  | 133.2 | 3328 | 74.97 | 1544 | 115.44 | 1399 | 82.09 | 1685
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.87 | 1232 | 119.31 | 1428 | 71.55 | 1817
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
Spreadsheet: 96597d1295969076-how-do-i-look-at-a-date-and-take-off-a-percentage-solution
Sheet: Sheet1

T1
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995
One | 456 | 654
Two |  |  | 423 | 32
Three |  |  |  |  | 456
Four |  |  |  | 235 |  | 211
Five | 123 | 456 | 21 | 321 | 12 | 213
T2
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995
 | 0.018 | 0.02 | 0.014 | 0.014 | 0.023 | 0.01
T3
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995
One | 447.792 | 640.92 | 0 | 0 | 0 | 0
Two | 0 | 0 | 417.078 | 31.552 | 0 | 0
Three | 0 | 0 | 0 | 0 | 445.512 | 0
Four | 0 | 0 | 0 | 231.71 | 0 | 208.89
Five | 120.786 | 446.88 | 20.706 | 316.506 | 11.724 | 210.87
 | After and including year 1992 look at value in T1 and look at % in T2. Then take related percent off the value.
 | Example/expected answer in red.
Spreadsheet: 207741d1358535761-comparing-two-rows-and-highlighting-different-cells-sample-solution-
Sheet: Sample

ID | Code | Date | Association | Start Date | End Date | First Code | Amount | Recurring  Amount
B 101201 | 47 | 2013-02-07 00:00:00 | Y | 2013-02-07 00:00:00 | 2050-12-31 00:00:00 | 625 | 30 | 30
B 101201 | 10 | 2013-03-07 00:00:00 | Y | 2013-02-07 00:00:00 | 1999-01-01 00:00:00 | 1981 | 31 | 31
Spreadsheet: 75532cf7-b7ad-468f-ab6d-f0b229bedebf
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (6 [NAME]):
 | 1 Applikationen 1.1 [NAME] 1.1.5 Altlastenanalytik
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | [NAME] | Frankreich | [NAME] | 27106 | [NAME]
2 | GERSTEL GmbH & Co. [NAME] | Deutschland | Mülheim an der Ruhr | 45473 | A1.323/424
3 | LECO Instrumente GmbH | Deutschland | Mönchengladbach | 41199 | A1.324
4 | Parr Instrument (Deutschland) GmbH | Deutschland | Frankfurt | 60439 | A2.226
5 | Shimadzu Deutschland GmbH | Deutschland | Duisburg | 47269 | [NAME]
6 | Thermo Scientific | Deutschland | Dreieich | 63303 | B1.101/202
Spreadsheet: 167531d1342019192-finding-the-closest-match-between-two-columns-within-a-given-range-7912test30min
Sheet: Sheet3

230 | 400000000000
340 | 10
560 | 570
780 | 60
10 | 560
30 | 220
80 | 210
400000000000 | 340
330 | 540
Spreadsheet: eccac8c4-b40e-4362-bb31-6ea208b0abe3
Sheet: ME

 | Maine
 |  | 0-4 | 5-9 | 10-14 | 15-19 | 20-24 | 25-29 | 30-34 | 35-39 | 40-44 | 45-49 | 50-54 | 55-59 | 60-64 | 65-69 | 70-74 | 75-79 | 80-84 | 85+ | Total
Female
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2015
2020
2025
2030
Male
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2015
2020
2025
2030
Total
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2015
2020
2025
2030
Spreadsheet: 779133d1651596335-formula-that-recognizes-the-amount-of-days-in-a-month-as-we-pull-data-recognize-days-in-month
Sheet: 610202 (March)

Month: | 2022-03-01 00:00:00
Acct Number: | 610202
Rate: | 0.002
 | Total Amount
 | Balance
 | 610202 | Rate |  | Earnings
Total
Average
Spreadsheet: 65820d1266477630-lookup-formula-demo
Sheet: GH

Name | Birthday |  |  | Address | phone | Start date
 |  |  |  | Job | Cell | Quit Date
MrA | 1976 | Jan | 12 | Don't know street | 55223222 | 2007-03-02 00:00:00
 |  |  |  | Secretary | 905555221
MrB | 1978 | Mar | 23 | Have not a clue Rd | 22555 | 2008-04-06 00:00:00
 |  |  |  | Manager | 905555221
MrC | 1979 | Apr | 24 | Wouldn't know how to to get there Street | 552222552 | 2010-01-02 00:00:00
 |  |  |  | sales clerk | 905555221
Spreadsheet: 887252d1737495417-streamlining-data-collection-for-making-tables-and-charts-example
Sheet: Drop Down Tables

 | Vehicle |  | Destinations
 | Car 1 |  | Location 1
 | Car 2 |  | Location 2
 | Car 3 |  | Location 3
 | Van 1 |  | Location 4
 | Van 2 |  | Location 5
 | Truck1 |  | Location 6
 | Truck 2 |  | Location 7
 | Truck 3 |  | Location 8
 | Bus 1 |  | Location 9
 | Big Bus 1 |  | Location 10
 | Big Bus 2 |  | Location 11
 |  |  | Location 12
 |  |  | Location 13
 |  |  | Location 14
 |  |  | Location 15
Spreadsheet: 4e3b9a6c-6e8d-4447-8085-9e991cac5ea1
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
FONG | Test | FONG | Onion IgG | Onion IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. |  | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FONG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FONG | Result | FONG | Onion IgG | Onion IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 700667d1603285438-solved-very-newbie-troubles-timesheet-timesheet-template
Sheet: TIMESHEET

 | CONSULTANT NAME | MONTH/YEAR
Activity |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fri | Sa | Su | Total
 |  | 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 |  |  |  |  |  | Task | Billable
PROJECT 1
 | Project Meetings  (Standup, Status, Steerco, etc.) |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4
 | Project Management (PMO, Status Report, Monitor, etc.)
 | Project Workshops (Team, One-One, etc.)
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
PROJECT 2
 | Project Meetings  (Standup, Status, Steerco, etc.) |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2
 | Project Management (PMO, Status Report, Monitor, etc.)
 | Project Workshops (Team, One-One, etc.)
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
PROJECT 3
 | Project Meetings  (Standup, Status, Steerco, etc.) |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2
 | Project Management (PMO, Status Report, Monitor, etc.)
 | Project Workshops (Team, One-One, etc.)
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
 | Task/Activity  - xxxxx
Other
 | Other General, [NAME], emails etc.
 | Task/Activity  - xxxxx
 | Travel |  | 4 |  |  |  | 4 |  |  | 4 |  |  |  | 4 |  |  | 4 |  |  |  | 4
 | DAILY TOTALS:
 | WEEKLY TOTALS:
 | FORECAST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8
NON-BILLABLE
 | Leave
 | Sick
 | Other xx
Spreadsheet: 738564d1625120773-return-multiple-rows-based-on-multiple-criteria-exampledata-ans
Sheet: Sheet1

Property Code | Dateof Occupancy | Dateof Termination | Address1 | Tenure Type |  |  |  |  | Property Code | Dateof Occupancy | Dateof Termination | Address1 | Tenure Type
ABC_001 | 2019-04-14 00:00:00 |  | Flat 1 | [NAME]
ABC_001 | 2018-10-07 00:00:00 | 2019-04-14 00:00:00 | Flat 1 | [NAME]
[NAME] | 2021-01-13 00:00:00 |  | Flat 2 | Tenant
[NAME] | 2019-11-11 00:00:00 | 2021-01-13 00:00:00 | Flat 2 | [NAME]
[NAME] | 2019-03-15 00:00:00 | 2019-11-11 00:00:00 | Flat 2 | Tenant
[NAME] | 2018-10-07 00:00:00 | 2018-10-24 00:00:00 | Flat 2 | [NAME]
ABC_003 | 2019-05-14 00:00:00 |  | Flat 3 | Tenant
ABC_003 | 2018-10-30 00:00:00 | 2019-05-14 00:00:00 | Flat 3 | [NAME]
ABC_003 | 2018-10-07 00:00:00 | 2018-10-30 00:00:00 | Flat 3 | [NAME]
ABC_004 | 2019-04-08 00:00:00 |  | Flat 4 | Tenant
ABC_004 | 2018-10-07 00:00:00 | 2019-04-08 00:00:00 | Flat 4 | [NAME]
ABC_005 | 2019-05-02 00:00:00 |  | Flat 5 | Tenant
ABC_005 | 2019-04-14 00:00:00 | 2019-05-02 00:00:00 | Flat 5 | [NAME]
ABC_005 | 2018-10-07 00:00:00 | 2019-04-14 00:00:00 | Flat 5 | [NAME]
 | Becomes
Property Code | Dateof Occupancy | Dateof Termination | Address1 | Tenure Type |  |  |  |  | Assuming the dates are in decending order for each property code as in the given data.
ABC_001 | 2019-04-14 00:00:00 |  | Flat 1 | [NAME]
[NAME] | 2021-01-13 00:00:00 |  | Flat 2 | Tenant
[NAME] | 2019-11-11 00:00:00 | 2021-01-13 00:00:00 | Flat 2 | [NAME]
ABC_003 | 2019-05-14 00:00:00 |  | Flat 3 | Tenant
ABC_003 | 2018-10-30 00:00:00 | 2019-05-14 00:00:00 | Flat 3 | [NAME]
ABC_004 | 2019-04-08 00:00:00 |  | Flat 4 | Tenant
ABC_004 | 2018-10-07 00:00:00 | 2019-04-08 00:00:00 | Flat 4 | [NAME]
ABC_005 | 2019-05-02 00:00:00 |  | Flat 5 | Tenant
ABC_005 | 2019-04-14 00:00:00 | 2019-05-02 00:00:00 | Flat 5 | [NAME]
Spreadsheet: 92363a0f-22e4-4ffa-b356-3213fb53ee7c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42240797 | 2014-07-10 14:18:23 | ALLIES | 0 | 4 | 6 | 942409 | Cambrone40 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42241011 | 2014-07-10 14:46:00 | AXIS | 1 | 6 | 2 | 942409 | Cambrone40 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42253015 | 2014-07-11 12:29:09 | ALLIES | 1 | 10 | 7 | 1531011 | Spernatz34 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42253568 | 2014-07-11 12:58:28 | AXIS | 1 | 10 | 6 | 1531011 | Spernatz34 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42259223 | 2014-07-11 21:32:16 | ALLIES | 1 | 10 | 5 | 1591724 | Gladiatore | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42259759 | 2014-07-11 22:02:54 | AXIS | 1 | 6 | 3 | 763309 | witty671 | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
42260032 | 2014-07-11 22:29:07 | AXIS | 1 | 6 | 3 | 252161 | Tripehound | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42260368 | 2014-07-11 22:47:33 | ALLIES | 1 | 6 | 0 | 252161 | Tripehound | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42260559 | 2014-07-11 23:07:12 | AXIS | 1 | 6 | 2 | 1044721 | doro4ever | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42274397 | 2014-07-12 22:14:57 | AXIS | 1 | 10 | 5 | 601280 | player601280 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42274680 | 2014-07-12 22:37:51 | ALLIES | 0 | 6 | 10 | 601280 | player601280 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42274969 | 2014-07-12 22:52:17 | AXIS | 1 | 6 | 4 | 601280 | player601280 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42275121 | 2014-07-12 23:02:33 | ALLIES | 0 | 2 | 6 | 601280 | player601280 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42275235 | 2014-07-12 23:29:00 | AXIS | 1 | 6 | 5 | 1603899 | Unrealik263 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42275515 | 2014-07-12 23:43:11 | ALLIES | 1 | 6 | 2 | 1603899 | Unrealik263 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42419757 | 2014-07-23 10:24:37 | ALLIES | 1 | 4 | 0 | 1503257 | noixcoco | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42419819 | 2014-07-23 10:31:10 | AXIS | 1 | 4 | 1 | 1503257 | noixcoco | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42420052 | 2014-07-23 11:23:37 | ALLIES | 1 | 10 | 5 | 796863 | ardenn | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42420275 | 2014-07-23 12:02:22 | AXIS | 0 | 8 | 10 | 796863 | ardenn | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 32344d1228457278-highlighting-the-odd-value-in-a-column-flowers
Sheet: Sheet1

81620
18734
53323
72215
83100
62075
91626
45472
91982
76672
1866
20279
73336
2610
1712
94023
27235
83589
22772
8880
95131
19193
2528
88055
22613
26616
40523
3679
4288
44757
5257
55942
61003
61896
16988
26670
76205
69692
57704
33933
20666
18711
20943
60809
33248
33982
10713
82376
Spreadsheet: 85387d1285443742-populate-a-cell-based-on-a-date-range-copy-of-populatebydaterange-1
Sheet: Sheet1

Activity | start_date | end_date | Week ending
 |  |  | 2010-07-07 00:00:00 | 2010-07-14 00:00:00 | 2010-07-21 00:00:00 | 2010-07-28 00:00:00 | 2010-08-04 00:00:00 | 2010-08-11 00:00:00 | 2010-08-18 00:00:00 | 2010-08-25 00:00:00 | 2010-09-01 00:00:00 | 2010-09-08 00:00:00
Activity 1 | 2010-07-12 00:00:00 | 2010-08-03 00:00:00 |  | x | x | x
Activity 2 | 2010-07-13 00:00:00 | 2010-07-15 00:00:00 |  | x
Activity 3 | 2010-08-02 08:00:00 | 2010-08-11 17:00:00 |  |  |  |  | x
Activity 4 | 2010-09-15 00:00:00 | 2010-12-16 17:00:00
Activity 5 | 2010-09-15 00:00:00 | 2010-12-16 17:00:00
Activity 6 | 2010-12-17 08:00:00 | 2010-12-20 17:00:00
Activity 7 | 2010-12-21 08:00:00 | 2010-12-28 17:00:00
Activity 8 | 2010-12-23 08:00:00 | 2010-12-29 17:00:00
Activity 9 | 2010-12-29 08:00:00 | 2010-12-30 17:00:00
Activity 10 | 2010-12-30 08:00:00 | 2010-12-30 17:00:00
Spreadsheet: 23972d1213887422-vlookup-problem-diesel-backup
Sheet: Day2

 |  |  |  | Net Costs Available
 |  |  | Date: | 2008-06-10 00:00:00
Town 1 | P1 | P2 | P3 | P4 | P5 | P6
Company 1 | 2.97 | 0 | 0 | 0 | 0 | 0
Company 2 | 0 | 0 | 0 | 0 | 0 | 0
Company 3 | 0 | 0 | 0 | 0 | 0 | 0
Company 4 | 0 | 0 | 0 | 0 | 0 | 0
Company 5 | 0 | 0 | 0 | 0 | 0 | 0
Company 6 | 0 | 0 | 0 | 0 | 0 | 0
Company 7 | 0 | 0 | 0 | 0 | 0 | 0
Company 8 | 0 | 0 | 0 | 0 | 0 | 0
Company 9 | 0 | 0 | 0 | 0 | 0 | 0