tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814203d1674226592-substitute-array-particular-element-index-array-x-y-substitute-array-element
Sheet: Feuil1

initial array
 | b | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | b | c
z | d | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z | d | e
f | g | h |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f | g | h
expected array |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | b | c
 | b | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e | d | e
e | d | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f | g | h
f | g | h
Spreadsheet: 877976d1724922498-need-help-to-create-a-excel-sheet-for-calculating-average-annual-mileage-ptls-kilometers-2-365-aligw
Sheet: Sheet1

 | Car 1 | km | total distance | avarage per month | avarage yearly
 | 2022-06-07 00:00:00 | 104687
 | 29.08.2024 | 204561 |  | =D7/F6 | =G6*12months
 | = number of months between 07.06.2022 and 29.08.2024 around 24,8months?
 | Car 2
 | 2022-06-07 00:00:00 | 104687 km
 | 29.08.2024 | 204561 km
 | Number of months |  | (26,8 or something?)
 | total distance
 | avarage per month |  | (=totaldistance/26,8months)
 | avarage yearly |  | (=avarage month*12?)
 | 2022-06-07 00:00:00 | 29.08.2024 | = (number of months) Around 26,8months?
 | 104687 km | 204561 km | =(total distance)
Spreadsheet: 135012d1325758912-identify-cells-with-same-values-from-two-columns-book6
Sheet: Sheet1

col A | Col B | helper for both | helper for unique values in column A | helper for unique column B |  |  |  | values present in both columns | unique values in column A | unique values in column B
F1 | F1
F2 | F4
F3 | F5
F5 | F6
F11 | F8
Spreadsheet: 5d3f5a56-9fdf-478a-8c5b-ccb1b9e3a541
Sheet: ATTACHEMENT 3

ATTACHEMENT 3: Dip calculations and measurements for small section of [NAME]
 | Elevations |  |  | Line Segments
 | A | B | C | AB | BC | AC | AB' | DIP
RED | -3320 | -3321 | -3324 | 76 | 157 | 231 | 57.8 | 0.99
 | -3313 | -3318 | -3323 | 100 | 192 | 289 | 144.5 | 1.98
 | -3311 | -3316 | -3317 | 117 | 182 | 294 | 245 | 1.17
 | -3310 | -3314 | -3315 | 155 | 153 | 303 | 242.4 | 0.94
 | -3305 | -3307 | -3311 | 134 | 219 | 351 | 117 | 0.98
 | -3299 | -3302 | -3306 | 183 | 253 | 433 | 185.6 | 0.93
 | -3295 | -3298 | -3301 | 174 | 269 | 440 | 220 | 0.78
 | -3292 | -3296 | -3297 | 180 | 222 | 403 | 322.4 | 0.71
GREEN | -3237 | -3251 | -3278 | 134 | 313 | 298 | 101.8 | 7.83
 | -3225 | -3242 | -3267 | 136 | 267 | 285 | 115.4 | 8.38
 | -3204 | 3210 | -3211 | 43 | 59 | 57 | 48.9 | 7
 | -3201 | -3208 | -3212 | 43 | 61 | 62 | 39.5 | 10.06
 | -3259 | -3272 | -3283 | 98 | 238 | 207 | 112.1 | 6.61
 | -3249 | -3266 | -3266 | 189 | 238 | 99 | 99 | 9.74
 | -3237 | -3251 | -3257 | 92 | 157 | 152 | 106.4 | 7.5
 | -3229 | -3242 | -3249 | 132 | 178 | 111 | 72.2 | 10.21
BLUE | -3295 | -3310 | -3311 | 146 | 170 | 256 | 240 | 3.58
 | -3294 | -3296 | -3299 | 64 | 89 | 46 | 18.4 | 6.2
 | -3297 | -3300 | -3301 | 195 | 300 | 103 | 77.25 | 2.22
 | -3283 | -3285 | -3293 | 68 | 153 | 152 | 30.4 | 3.76
 | -3268 | -3271 | -3273 | 292 | 490 | 201 | 120.6 | 1.42
 | -3250 | -3254 | -3256 | 239 | 362 | 192 | 128 | 1.79
 | -3232 | -3234 | -3243 | 452 | 223 | 233 | 42.4 | 2.7
 | -3212 | -3218 | -3222 | 210 | 197 | 405 | 243 | 1.41
Spreadsheet: 670305d1585828846-extracting-data-match-3-
Sheet: Sheet1

 |  |  | Data 1 | Result |  |  |  | Data 2
 |  |  | 8 |  |  |  | ADF | A75/7 | 1000
 |  |  | 2 |  |  |  |  | A75/10 | 634
 |  |  | 3 |  |  |  | RAM | A75/8 | 653
 |  |  | 10 |  |  |  | ABC | A75/7 | 2000
 |  |  | 7 |  | MULTIPLE |  | SHYAM | A75/461 | 653
 |  |  | 461 |  |  |  | [NAME] | A75/360 | 65
 |  |  | 256 |  |  |  |  | A75/12 | 46
 |  |  | 360 |  | [NAME] |  | [NAME] | A75/360 | 35
Spreadsheet: 47094d1246004068-copy-sheet-macro-test-results
Sheet: 1

 |  |  | A
 |  | Test Results | 2009-06-26 09:12:43
 |  | VO2 | 56
 |  | VJ | 65
 |  | 10m | 1.2
 |  | 30m | 3.9
 |  | Agility | 12
 | Strengths |  | Areas for improvement
 | VO2 |  | 10m
 | Agility |  | VJ
 |  |  | 30m
Spreadsheet: 469838d1468212834-extracting-embedded-pictures-nagar_college_data
Sheet: Report

Admission Form No | Student Photo
NC15001873
NC15000013
NC15001532
NC15000019
NC15001397
NC15001322
NC15000137
NC15003692
NC15000095
NC15000126
NC15000030
NC15000026
NC15002127
NC15001162
NC15001177
NC15001392
NC15000020
NC15001037
NC15001153
NC15001220
Spreadsheet: 877512d1724327463-match-data-of-vertical-column-to-horizontal-row-of-another-sheet-fa-test-2-
Sheet: P1

 |  | Nature | Main Group | Category |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID
 |  | Fixed Assets | Group A | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  | America | S-12 |  | 2081.04.25 |  |  | Google Inc |  | Black Apple | 25 | Pcs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5263
 |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | America | S-14 |  | 2081.04.06 |  |  | Amazon
 |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | America | S-19 |  | 2081.04.07 |  |  | Jhonson & Jhonson
 |  | Fixed Assets | Group A | Orange |  |  |  |  |  |  |  |  |  |  |  |  |  | UK | S-24 |  | 2081.04.08 |  |  | New Era |  | [NAME] | 100 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6356
 |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | America | S-36 |  | 2081.04.15
 |  | Fixed Assets | Group B | Jasmine |  |  |  |  |  |  |  |  |  |  |  |  |  | America | S-94 |  | 2081.04.28 |  |  | [NAME] |  | Home Grown | 256 | Bdl |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 526
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | America | S-154 |  | 2081.04.21
 |  | Fixed Assets | Group A | Grapes |  |  |  |  |  |  |  |  |  |  |  |  |  | UK | Bh-36 |  | 2081.05.26 |  |  | All the best |  | Imported | 85 | ctns |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Fixed Assets | Group C | Software |  |  |  |  |  |  |  |  |  |  |  |  |  | Russia | Asw-44 |  | 2084.04.09 |  |  | Microsoft Inc. |  | Bing | 1 | set |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 652
Spreadsheet: 881883d1730112934-duplicates-removal-in-excel-example
Sheet: Sheet1

Partno | Alt. Partno
#25-211 | 1159A
#25-211 | 12115C
#25-211 | J1211A
1159A | #25-211
1159A | 12115C
1159A | J1211A
12115C | J1211A
12115C | #25-211
12115C | 1159A
J1211A | 12115C
J1211A | #25-211
J1211A | 1159A
Spreadsheet: d8767249-7cce-47a2-bf2b-6fb3ad673c95
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7981 | 10276 | Lino | [NAME] | ITA | 182 | 00:37:53 | 00:00:00 | 00:44:27 | 00:00:00 | 00:55:59 | 1 | 02:18:19
Spreadsheet: 75242d1275825410-pivot-table-calculations-731929
Sheet: Sheet2

 | Values
Row Labels | Sum of HAS_LYD | Sum of HAS_TYD | Sum of Unit%
AL0 | 32 | 22 | 0.6875 |  |  | 32 | 22
AZ0 | 9 | 5 | 0.5555555555555556 |  |  | 46549.55714285714 | 30350
CA1 | 10 | 7 | 0.7
CO0 | 144 | 119 | 0.8263888888888888
GA0 | 34 | 19 | 0.5588235294117647
IA0 | 103 | 93 | 0.9029126213592233
ID0 | 46 | 38 | 0.8260869565217391
IN0 | 16 | 13 | 0.8125
KY0 | 2 | 1 | 0.5
LA0 | 13 | 7 | 0.5384615384615384
MN0 | 26 | 18 | 0.6923076923076923
MO0 | 13 | 5 | 0.3846153846153846
MS0 | 7 | 4 | 0.5714285714285714
MT0 | 7 | 4 | 0.5714285714285714
NC0 | 43 | 29 | 0.6744186046511628
OH1 | 22 | 15 | 0.6818181818181818
OH2 | 1 | 0 | 0
OK0 | 23 | 14 | 0.6086956521739131
OR0 | 17 | 10 | 0.5882352941176471
TN0 | 27 | 20 | 0.7407407407407407
TX0 | 23 | 21 | 0.9130434782608695
TX1 | 20 | 12 | 0.6
TX2 | 75 | 57 | 0.76
TX3 | 70 | 54 | 0.7714285714285715
TX4 | 6 | 6 | 1
TX5 | 6 | 4 | 0.6666666666666666
TX6 | 10 | 3 | 0.3
TXS | 21 | 16 | 0.7619047619047619
UT0 | 22 | 14 | 0.6363636363636364
VA1 | 3 | 1 | 0.3333333333333333
WA0 | 5 | 3 | 0.6
WI0 | 46 | 39 | 0.8478260869565217
WV0 | 6 | 5 | 0.8333333333333334
WY0 | 4 | 3 | 0.75
Grand Total | 912 | 681 | 0.7467105263157895
Spreadsheet: 473790d1470401790-getting-a-status-change-protocol
Sheet: START

 |  | Test protocol
Client: | Client name
Project: | Project name
Status on # | Section | Ready for testing |  | Test status |  | Notes
1 | General | Not yet |  | Not ready
2 | Module 1 | Yes, please do |  | All done
3 | Module 2 | Not yet |  | Not ready
4 | Module 3 | Yes, please do |  | All done
5 | Module 4 | Not yet |  | Not ready
6 | Module 5 | Not yet |  | Not ready
7 | Module 6 | Not yet |  | Not ready
8 | Module 7 | Not yet |  | Not ready
9 | Module 8 | Not yet |  | Not ready
10 | Module 9 | Not yet |  | Not ready
11 | Module 10 | Not yet |  | Not ready
Spreadsheet: darrell_schoolcraft__7224__saledoc12_1TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2001-11-28 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 12/01/01-12/31/01 |  |  | FAX Number:
Total Quantity |  |  | 10000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | [NAME].01
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
12/1/2001 | 2001-12-31 00:00:00 | 310000 |  | 10000 |  | 10000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58646 |  | 10000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: sally_beck__33971__ScheduleC-Daily0301
Sheet: Schedule C - Daily for Mar 2001

 |  |  |  |  | Schedule C Daily Report
Portfolio | Date Entered | Book Name |  | Explanation | Amount  Into Prudency ($US) | Amount Released From Prudency ($US) | Spot Rate** | In CDN Funds
Power East | 2001-03-01 00:00:00 | LT-NENG |  | Due to an invalid prior day change to an asian option | -656213
Power West | 2001-03-02 00:00:00 | LTNW |  | Deal 3689.03 uncertain of counter party's status regarding swaption. | 26212029
Gas - West | 2001-03-05 00:00:00 | ST-NW (NP15) |  | Release of temporary Sched. C taken on 2/27/2001 |  | 1237848
Gas - West | 2001-03-05 00:00:00 | ST-NW (NP15) |  | Release of temporary Sched. C taken on 2/28/2001 |  | -952272
Power East | 2001-03-09 00:00:00 | LT-NENG |  | Released of above mentioned item |  | 656123
Power East | 2001-03-13 00:00:00 | ST-PJM |  | Deals incorrectly put into Enpower. | -310000
Power East | 2001-03-15 00:00:00 | ST-PJM |  | Released of above mentioned item |  | 310000
Gas - Mgmt | 2001-03-21 00:00:00 | MGMT |  |  | -40000000
Total
Spreadsheet: 730720d1619875222-date-formatting-book1
Sheet: Sheet1

1 | 2 | 3 | 4 | 5
Activity name | Duration | Start Date | Finish Date | [NAME]
Pour 1 | 6w 3d | 2021-04-13 00:00:00 | 2021-04-26 00:00:00
Pour 2 | 2w | 2021-04-22 00:00:00 | 2021-04-28 00:00:00
Pour 3 | 1w | 2021-04-26 00:00:00 | 2021-04-30 00:00:00
Pour 4 | 1w | 2021-04-29 00:00:00 | 2021-05-06 00:00:00
Pour 5 | 1w | 2021-05-05 00:00:00 | 2021-05-11 00:00:00
Pour 6 | 1w | 2021-05-07 00:00:00 | 2021-05-13 00:00:00
Spreadsheet: 876315d1722999025-attendance-tracking-with-occurrence-points-over-6-month-rolling-period-attendance-tracker
Sheet: Attendance

Name | Date | Reason
Name1 | 2024-07-25 00:00:00 | Tardy
Name1 | 2024-07-01 00:00:00 | NCNS
Name1 | 2024-06-03 00:00:00 | Late Return
[NAME] | 2024-08-01 00:00:00 | Vacation
Name3 | 2024-03-01 00:00:00 | Sick
Name4 | 2024-04-01 00:00:00 | Unexcused
Name5 | 2024-05-01 00:00:00 | Sick
Name3 | 2024-07-01 00:00:00 | Vacation
Name4 | 2024-05-03 00:00:00 | Sick
Spreadsheet: 266487d1379625219-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-countyfipscode1
Sheet: WASHINGTON-46

 | COUNTY | CODE
 | Adams | 1
 | Asotin | 3
 | [NAME] | 5
 | Chelan | 7
 | Clallam | 9
 | [NAME] | 11
 | Columbia | 13
 | Cowlitz | 15
 | [NAME] | 17
 | [NAME] | 19
 | Franklin | 21
 | [NAME] | 23
 | Grant | 25
 | Grays Harbor | 27
 | Island | 29
 | [NAME] | 31
 | King | 33
 | Kitsap | 35
 | Kittitas | 37
 | [NAME] | 39
 | Lewis | 41
 | Lincoln | 43
 | Mason | 45
 | Okanogan | 47
 | Pacific | 49
 | Pend Oreille | 51
 | Pierce | 53
 | San Juan | 55
 | Skagit | 57
 | Skamania | 59
 | Snohomish | 61
 | Spokane | 63
 | [NAME] | 65
 | Thurston | 67
 | Wahkiakum | 69
 | Walla Walla | 71
 | Whatcom | 73
 | Whitman | 75
 | Yakima | 77
Spreadsheet: 873693d1720203996-workday-and-networkday-formula-tracking-log-book1
Sheet: Holidays

2024-07-04 00:00:00 | Independence Day
2024-09-02 00:00:00 | Labor Day
2024-10-14 00:00:00 | Columbus Day
2024-11-11 00:00:00 | Veterans Day
2024-11-28 00:00:00 | Thanksgiving Day
2024-12-25 00:00:00 | Christmas Day
2025-01-01 00:00:00 | New Years Day
2025-01-20 00:00:00 | [NAME], Jr. Day
2025-02-17 00:00:00 | Presidents Day
2025-05-26 00:00:00 | Memorial Day
2025-06-19 00:00:00 | Juneteenth National Independence Day
2024-07-04 00:00:00 | Independence Day
2025-09-01 00:00:00 | Labor Day
2025-10-13 00:00:00 | Columbus Day
2025-11-11 00:00:00 | Veterans Day
2025-11-27 00:00:00 | Thanksgiving Day
2025-12-25 00:00:00 | Christmas Day
Spreadsheet: 586881d1534706474-basketball-table-and-best-second-places-womens-eb-qualifier-tables
Sheet: Sheet1

Name | GP | W | D | L | GF | GA | [NAME] | PTS | [NAME] | Rank
Spain
Slovenia
Czech Republic
Russia
France
Belgium
Ukraine
Italy
Hungary
Turkey
Sweden
Slovakia
Montenegro
Great Britain
Israel
Bosnia
Belarus
Greece
Croatia
Lithuania
Portugal
Poland
Estonia
Iceland
Romania
Albania
Germany
Netherlands
Bulgaria
Switzerland
Finland
Macedonia
Spreadsheet: 772293d1647183334-need-help-with-making-excel-choose-from-variables-calculator
Sheet: Gruppe 1

 |  |  | A | B | C | D | E | F
 | Cross sections |  | 40 | 80 | 120 | 160 | 200 | 240
 | Up to 500m |  | 4.34 | 5.76 | 6.87 | 8.02 | 9.2 | 10.34
 | Between 500-1500meters |  | 3.36 | 4.37 | 5.27 | 6.13 | 7.02 | 7.89
 | Between 1500-3000 meters |  | 3.01 | 3.95 | 4.75 | 5.54 | 6.35 | 7.14
 | over  3000 meters |  | 2.85 | 3.71 | 4.43 | 5.21 | 5.95 | 6.69
Cross sections | 40 |  | 4.34 | price for each meter
Meters of cross section |  |  | 500 | meters
Price= Cross section and meters
Spreadsheet: 99621d1298238133-find-the-max-and-return-value-from-other-column-max
Sheet: Sheet1

Name | Out | Count |  |  | Name | Sum | MAX
[NAME] | [NAME] | 7 |  |  | [NAME] | 10 | 7 | [NAME]
[NAME] | Internal Lead | 1 |  |  | Shane | 27 | 8 | Internal Lead
[NAME] | Pending Calls | 0 |  |  | [NAME] | 25 | 9 | Inbound Calls
[NAME] | [NAME] outs | 1
[NAME] | Inbound Calls | 1
[NAME] | Referrals | 0
Shane | [NAME] | 1
Shane | Internal Lead | 8
Shane | Pending Calls | 3
Shane | [NAME] outs | 4
Shane | Inbound Calls | 5
Shane | Referrals | 6
[NAME] | [NAME] | 1
[NAME] | Internal Lead | 2
[NAME] | Pending Calls | 3
[NAME] | [NAME] outs | 4
[NAME] | Inbound Calls | 9
[NAME] | Referrals | 6
Spreadsheet: 295571d1391725854-sorting-data-in-excel-excel-example-with-only-first-instance-being-displayed
Sheet: Sheet1

participant | when t2 | t2 correct |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
607 | 1 | 1 |  | participant | t2_correct_lag_1 | t2_correct_lag_2 | t2_correct_lag_3 | [NAME] | t2_correct_lag_5 | t2_correct_lag_6 | t2_correct_lag_7 | t2_correct_lag_8
607 | 2 | 1 |  | 607
607 | 3 | 1 |  | 607
607 | 4 | 1 |  | 209
607 | 5 | 0 |  | 209
607 | 6 | 1
607 | 7 | 0
607 | 8 | 1
607 | 7 | 1
607 | 4 | 0
607 | 5 | 1
607 | 8 | 1
607 | 2 | 1
607 | 1 | 0
607 | 6 | 1
607 | 3 | 0
209 | 1 | 1
209 | 2 | 1
209 | 3 | 1
209 | 4 | 1
209 | 5 | 0
209 | 6 | 0
209 | 7 | 0
209 | 8 | 1
209 | 7 | 1
209 | 4 | 1
209 | 5 | 1
209 | 8 | 0
209 | 2 | 1
209 | 1 | 0
209 | 3 | 1
209 | 6 | 1
Spreadsheet: 870206d1716761193-grabbing-data-from-a-data-table-between-2-dates-excel-2010-ben-solution
Sheet: Sheet1

Occurrences | Date | Start Time | End Time | # of Counties | Counties | Length | [NAME] | Deaths | Injuries | Rating |  |  | Begin Date | 2024-05-01 00:00:00 | End Date | 2024-05-31 00:00:00
Spreadsheet: 300184d1393409182-single-formula-for-counting-in-the-range-single-formula-for-counting-without-extra-columns2
Sheet: Sheet1

Date |  |  |  |  |  | Season |  | result should be
2014-12-24 00:00:00 |  |  |  |  |  | Winter |  | 5
2007-05-04 00:00:00 |  |  |  |  |  | Spring |  | 3
2008-09-12 00:00:00 |  |  |  |  |  | Summer |  | 5
2014-11-01 00:00:00 |  |  |  |  |  | Fall |  | 6
2014-01-11 00:00:00
2014-05-10 00:00:00
2014-09-08 00:00:00
2014-10-18 00:00:00
2012-09-17 00:00:00
2014-03-03 00:00:00
2013-01-15 00:00:00 |  |  |  | Some like this formula?
2014-07-27 00:00:00
2014-02-11 00:00:00 |  |  |  | =COUNTIF($A$2:$A$20;LOOKUP(A2:A20;DATE(YEAR(A2);{0;3;6;9;12};{21;21;21;23;21});{"winter";"spring";"summer";"autmn";"winter"}))
2014-11-17 00:00:00
2013-09-23 00:00:00
2014-12-09 00:00:00 |  |  |  | =SUMPRODUCT(0+LOOKUP(A$2:A$20;DATE(YEAR(A2);{0;3;6;9;12};{21;21;21;23;21});{"winter";"spring";"summer";"fall";"winter"}=G2))
2014-07-17 00:00:00
2014-12-17 00:00:00
2010-05-12 00:00:00
Spreadsheet: 63231d1264156425-compare-and-copy-rows-memsample-2009_10
Sheet: Current

First Name | Surname | Name | Paid To | [NAME] | EA Reg | Card | Amt Paid | [NAME] | Date Paid | Address1 | Address2 | Address4 | PostCode | London | [NAME] | Home Tel No | Work Tel No | Mobile | Sex | DOB | Age | Class | Cl aim | Compete | UK tax [NAME] | Born In | Nationality | Joined | 1st Claim Club | 2nd Claim/Other clubs | 2010-01-22 00:00:00
[NAME] | Doe | [NAME] | 2009 | 1153 | 2808075 |  | 20 | ch | 2009-01-07 00:00:00 | 46 long Parade | limehouse | London | ABC 123 |  | [EMAIL] | [PHONE] |  |  | m | 1957-01-17 00:00:00 | 53 | full | 2nd | n | y | [NAME] | irish | 2003 | hhh
[NAME] | [NAME] | [NAME]  smith | 2009 | 1154 |  | y | 20 | ch | 2008-12-03 00:00:00 | 5 Oak tree crescent | copse hill | hants | ABC 124 | 22 | [EMAIL] |  | [PHONE] | 8900 104143 | m | 1966-01-18 00:00:00 | 44 | full | 1st | y | y | York | British | 2006
[NAME] | [NAME] | [NAME][NAME] | 2010 | 1158 | 2808050 | done | 20 | ca | 0101/10 | 16 letsbe avenue | hark | London | dfe 654 |  | [EMAIL] | 206 123 000 | [PHONE] | 8901 104143 | m | 1956-02-18 00:00:00 | 53 | full | 1st | y | y | London | British | 2007
Ajay Kumar | [NAME] | Ajay Kumar  patel | 2010 | 1167 | 2808072 | done | 20 | ca | 2010-01-20 00:00:00 | 65 chestnut Vale | East brightwich | London | ABC 126 |  | [EMAIL] | [PHONE] |  | 8902 104143 | m | 1969-11-30 00:00:00 | 40 | full | 1st | y | y | London | British | 2007
Clare | ash | Clare  ash | 2009 | 1172 | 2716779 |  | 20 | ch | 2008-12-01 00:00:00 | 9 mousegrove Road | hamville | surrey | ABC 127 | 45 | [EMAIL] |  | [PHONE] | 8903 104143 | f | 1963-12-26 00:00:00 | 46 | full | 1st | y | n | Beckenham | British | 2007 |  | lockdale
Hugh | fourway | Hugh  fourway | 2010 | 1173 | 2456780 | done | 20 | ch | 2010-01-20 00:00:00 | 2 Asylum Road | pickam | London | ABC 128 |  | [EMAIL] | [PHONE] | [PHONE] |  | m | 1954-05-01 00:00:00 | 55 | full | 1st | y | y | London | British | 2007
mary | lamb | [NAME] | 2010 | 1174 |  | y | 20 | ch | 2010-01-21 00:00:00 | 4  the close | west down | london | ABC 129 |  | no email |  |  | 07903 232323 | f | 1970-08-23 00:00:00 | 39 | full | 1st | y | y | Leeds | British | 2010
Spreadsheet: 723cb0ee-d24d-41f8-8f7f-7e5b845e2c9f
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
44416629 | 2014-12-12 23:06:42 | ALLIES | 1 | 6 | 5 | 578329 | Valentin de Ramillies | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
44416841 | 2014-12-12 23:21:44 | AXIS | 1 | 6 | 4 | 578329 | Valentin de Ramillies | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
44417014 | 2014-12-12 23:36:13 | ALLIES | 1 | 6 | 5 | 578329 | Valentin de Ramillies | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
44417177 | 2014-12-12 23:47:31 | AXIS | 0 | 0 | 6 | 578329 | Valentin de Ramillies | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
44417341 | 2014-12-13 00:11:33 | ALLIES | 1 | 6 | 4 | 578329 | Valentin de Ramillies | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44417577 | 2014-12-13 00:26:36 | AXIS | 0 | 3 | 6 | 578329 | Valentin de Ramillies | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44459236 | 2014-12-15 21:27:28 | AXIS | 1 | 6 | 1 | 243336 | Philoo | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
44459640 | 2014-12-15 21:48:36 | ALLIES | 0 | 5 | 6 | 243336 | Philoo | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
44515598 | 2014-12-19 23:53:28 | AXIS | 1 | 6 | 4 | 615831 | cedroxx | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44515893 | 2014-12-20 00:11:00 | ALLIES | 1 | 6 | 4 | 615831 | cedroxx | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44530080 | 2014-12-20 23:18:12 | AXIS | 0 | 3 | 6 | 764776 | PurpleBadger | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
44530265 | 2014-12-20 23:36:40 | ALLIES | 1 | 6 | 4 | 764776 | PurpleBadger | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith