tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 703122d1604765181-calculate-cumulative-sums-and-obtain-highest-value-based-on-it-example1935-gk
Sheet: Data

Concatenate | Month | Agent | Data1 | Data2 |  |  | JUL
 | 2020 JUL | [NAME] | 9 | 481
 | 2020 JUL | [NAME] | 5 | 344 |  | Year and Month |  |  | Month Only |  |  | No criteria
 | 2020 JUL | [NAME] | 200 | 20 |  | Agent Name | Data 1 Value |  | Agent Name | Data 1 Value |  | Agent Name | Data 1 Value
 | 2020 JUL | Reeve | 8 | 85
 | 2020 JUL | [NAME] | 2 | 182
 | 2020 JUL | Clementine | 13 | 542
 | 2020 JUL | Brett | 10 | 211
 | 2020 JUL | Chase | 11 | 766
 | 2020 JUL | Sean | 12 | 1000
 | 2020 JUL | Olive | 13 | 324
 | 2020 JUL | [NAME] | 8 | 716
 | 2020 JUL | [NAME] | 26 | 1000000
 | 2020 JUL | TOTAL | 137 | 6890
 | 2019 AUG | [NAME] | 10 | 218
 | 2019 AUG | [NAME] | 3 | 227
 | 2019 AUG | [NAME] | 401 | 21
 | 2019 AUG | Reeve | 3 | 50
 | 2019 AUG | [NAME] | 3 | 132
 | 2019 AUG | Clementine | 6 | 347
 | 2019 AUG | Brett | 15 | 188
 | 2019 AUG | Chase | 8 | 827 |  |  | 1. get CUMULATIVE SUMS of each agent's Data1 value (except TOTAL), if "Month" column includes both the separate cell values H1 and J1
 | 2019 AUG | Sean | 6 | 2001 |  |  | 2. based on above, find the highest Data1 value of all agents, AND which agent achieved that
 | 2019 AUG | Olive | 6 | 357
 | 2019 AUG | [NAME] | 5 | 423 |  |  | The second requirement, is a slightly simpler version of the first, without the condition to match [NAME]
 | 2019 AUG | [NAME] | 15 | 392
 | 2019 AUG | TOTAL | 96 | 5366 |  |  | The third requirement, is a slightly simpler version of the first, without the condition to match both H1 or J1
 | 2018 JUL | [NAME] | 9 | 354
 | 2018 JUL | [NAME] | 3 | 320
 | 2018 JUL | [NAME] | 200 | 20
 | 2018 JUL | Reeve | 20 | 227 |  |  | It is preferred if no additional helper columns are used. The concatenate column already exists in the original table, and can be used if needed.
 | 2018 JUL | [NAME] | 1 | 320
 | 2018 JUL | Clementine | 9 | 454
 | 2018 JUL | Brett | 20 | 234
 | 2018 JUL | Chase | 22 | 857
 | 2018 JUL | Sean | 12 | 1000
 | 2018 JUL | Olive | 5 | 355
 | 2018 AUG | Sean | 5 | 436
 | 2018 JUL | [NAME] | 13 | 12
 | 2018 JUL | TOTAL | 140 | 6421
Spreadsheet: 686266d1594468180-identifying-trend-in-excel-and-display-trend-result-in-a-cell-final_10july20-sample
Sheet: final_m

CODE | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | TREND | SPARKLINES
ADAN | 0.47 | 0.45 | 0.43 | DOWN
AMAR | 0.5 | 0.49 | 0.51 | NONE
AMBU | 0.59 | 0.52 | 0.45 | DOWN
APOL | 0.48 | 0.48 | 0.46 | NONE
ASHO | 0.68 | 0.67 | 0.65 | DOWN
ASIA | 0.57 | 0.63 | 0.62 | NONE
AURO | 0.6 | 0.59 | 0.75 | NONE
BAJA | 0.4 | 0.44 | 0.44 | NONE
BALK | 0.49 | 0.53 | 0.54 | UP
BANK | 0.59 | 0.57 | 0.53 | DOWN
BEL | 1.01 | 0.9 | 0.84 | DOWN
BHEL | 0.75 | 0.75 | 0.76 | NONE
BIOC | 0.45 | 0.5 | 0.5 | NONE
BOSC | 0.54 | 0.57 | 0.57 | NONE
BRIT | 0.78 | 0.73 | 0.64 | DOWN
CADI | 0.51 | 0.52 | 0.54 | UP
CANB | 0.61 | 0.58 | 0.51 | DOWN
CENT | 0.51 | 0.38 | 0.37 | DOWN
CIPL | 0.33 | 0.34 | 0.33 | NONE
DABU | 0.35 | 0.33 | 0.31 | DOWN
DRRE | 0.49 | 0.5 | 0.51 | UP
EICH | 0.97 | 0.89 | 0.93 | NONE
EQUI | 0.45 | 0.45 | 0.36 | NONE
ESCO | 0.92 | 1 | 0.97 | NONE
FEDE | 0.54 | 0.49 | 0.49 | NONE
GLEN | 0.81 | 0.81 | 0.83 | NONE
GRAS | 0.69 | 0.71 | 0.61 | NONE
HAVE | 0.68 | 0.68 | 0.7 | NONE
HERO | 0.91 | 0.76 | 0.74 | DOWN
IDEA | 0.73 | 0.68 | 0.66 | DOWN
INDI | 0.86 | 0.75 | 0.75 | NONE
JIND | 0.62 | 0.68 | 0.82 | UP
MANA | 0.72 | 0.73 | 0.73 | NONE
MARU | 0.68 | 0.62 | 0.56 | DOWN
NEST | 0.39 | 0.38 | 0.37 | DOWN
PAGE | 0.7 | 0.63 | 0.63 | NONE
RECL | 0.63 | 0.61 | 0.6 | DOWN
SIEM | 0.29 | 0.26 | 0.24 | DOWN
TITA | 0.75 | 0.73 | 0.57 | DOWN
TORN | 0.49 | 0.47 | 0.47 | NONE
ULTR | 0.45 | 0.48 | 0.42 | NONE
VOLT | 0.4 | 0.39 | 0.41 | NONE
Spreadsheet: 492604d1481178062-prepare-summary-by-using-formulas-sample-report
Sheet: SUMMARY

Month | Area | Gender | Total
Jan | Hyd | F | 259509
Jan | Hyd | M | 290664
Jan | Khm | F | 288385
Jan | Khm | M | 257111
Jan | Vij | F | 195711
Jan | Vij | M | 297139
Jan | [NAME] | F | 253393
Jan | [NAME] | M | 273053
Jan | Wgl | F | 225782
Jan | Wgl | M | 305043
Feb | Hyd | F | 223161
Feb | Hyd | M | 288367
Feb | Khm | F | 277573
Feb | Khm | M | 256615
Feb | Vij | F | 210944
Feb | Vij | M | 289574
Feb | [NAME] | F | 248160
Feb | [NAME] | M | 250622
Feb | Wgl | F | 226936
Feb | Wgl | M | 288437
Mar | Hyd | F | 210402
Mar | Hyd | M | 319245
Mar | Khm | F | 285417
Mar | Khm | M | 231833
Mar | Vij | F | 224234
Mar | Vij | M | 309077
Mar | [NAME] | F | 214455
Mar | [NAME] | M | 250842
Mar | Wgl | F | 228335
Mar | Wgl | M | 308908
Apr | Hyd | F | 236804
Apr | Hyd | M | 292955
Apr | Khm | F | 271506
Apr | Khm | M | 250070
Apr | Vij | F | 207865
Apr | Vij | M | 336774
Apr | [NAME] | F | 238352
Apr | [NAME] | M | 277974
Apr | Wgl | F | 249478
Apr | Wgl | M | 306941
May | Hyd | F | 209113
May | Hyd | M | 285679
May | Khm | F | 275257
May | Khm | M | 263788
May | Vij | F | 187587
May | Vij | M | 283325
May | [NAME] | F | 217023
May | [NAME] | M | 243688
May | Wgl | F | 228241
May | Wgl | M | 295500
Jun | Hyd | F | 234991
Jun | Hyd | M | 351549
Jun | Khm | F | 296763
Jun | Khm | M | 247375
Jun | Vij | F | 194625
Jun | Vij | M | 291258
Jun | [NAME] | F | 248631
Jun | [NAME] | M | 231728
Jun | Wgl | F | 241492
Jun | Wgl | M | 282600
Spreadsheet: 0568f68f-7664-4ba4-84f2-f302e1b2dd73
Sheet: Sheet1

Department of Public Safety Division of Homeland Security | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Reimbursement Request Form
IMPORTANT: If you are requesting a cash advance, please send the Cash Advance Request Form.
Sub-grantee: |  | Address:
Grant Program: |  | Grant #:
Prepared By: |  | Award Period:
Phone: |  | Reimbursement Number:
[NAME]: |  | Date of Request:
1.  Total Award Amount |  |  | 1.  Total Match Required
2.  Expenditures - Total of This Request (automatically totaled from Project Detail Sheets) |  | 0 | 2.  Total Match of This Request (automatically totaled from Project Detail Sheets) | 0
3.  Total Amount of Grant $ [NAME] to Date
4.  Total Amount of Previous Requests, Not Yet Received
5.  Total Expenditures to Date (excluding Match)                    (total of lines 2, 3, 4) |  | 0 | 5.  Total Match to Date
6.  [NAME] (line 1 - line 5) |  | 0
PLEASE [NAME]) TO SHOW ACTUAL EXPENDITURES
I certify that all expenses were incurred for purposes of the grant, and that all expenditures listed in this report have been paid and are on file in the office record, available for review or audit. I further certify that any reported match is from non-federal sources and is not being used to meet the match requirement for any other federal grant.
HLS Coordinator's Printed Name |  | Fiscal Officer's Printed Name
HLS Coordinator's Signature |  | Fiscal Officer's Signature
Date: |  | Date:
CDHS Use Only:
Yes          No    Required Quarterly Financial and Narrative Reports have been submitted to date.
Yes          No    Reported Expenditures justify this REIMBURSEMENT request amount.
Amount Requested in line #2 above is       Approved         Modified to $_________             Denied
If modified/denied, reason:
CDHS' Representative Signature:                                                                        Date:
Please Submit Two Signed Forms with Original Signatures
Spreadsheet: 28812d1223371934-graph-merged-cells-without-graphing-gaps-or-spaces-657625a
Sheet: Sheet1

2008-09-14 00:00:00 | 178 | 3491 |  | 3491 | 3
2008-09-15 00:00:00 | 997 |  |  | 2852
2008-09-16 00:00:00 | 397 |  |  | 3323
2008-09-17 00:00:00 | 50 |  |  | 0
2008-09-18 00:00:00 | 717 |  |  | 0
2008-09-19 00:00:00 | 528 |  |  | 0
2008-09-20 00:00:00 | 625 |  |  | 0
2008-09-21 00:00:00 | 497 | 2852 |  | 0
2008-09-22 00:00:00 | 966 |  |  | 0
2008-09-23 00:00:00 | 243 |  |  | 0
2008-09-24 00:00:00 | 245 |  |  | 0
2008-09-25 00:00:00 | 227 |  |  | 0
2008-09-26 00:00:00 | 197 |  |  | 0
2008-09-27 00:00:00 | 476 |  |  | 0
2008-09-28 00:00:00 | 12 | 3323 |  | 0
2008-09-29 00:00:00 | 40 |  |  | 0
2008-09-30 00:00:00 | 945 |  |  | 0
2008-01-10 00:00:00 | 910 |  |  | 0
2008-02-10 00:00:00 | 559 |  |  | 0
2008-03-10 00:00:00 | 587 |  |  | 0
2008-04-10 00:00:00 | 270 |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: 48045d1247225790-update-spreadsheet-by-1-year-date-change
Sheet: Lookup Table

Title
 | Height (m)
Distance (km) | 2 | 4.6 | 5.8 | 7.3 | 8.9 | 10
71.3 | 1.9124 | 1.9441 | 1.976 | 2.0081 | 2.0405 | 2.0683
60.4 | 1.9023 | 1.9337 | 1.9654 | 1.9974 | 2.0296 | 2.0621
56 | 1.8923 | 1.9235 | 1.9551 | 1.9869 | 2.019 | 2.0513
51.3 | 1.8824 | 1.9136 | 1.945 | 1.9766 | 2.0085 | 2.0406
42.3 | 1.8728 | 1.9038 | 1.935 | 1.9665 | 1.9982 | 2.0302
35.7 | 1.8634 | 1.8942 | 1.9253 | 1.9566 | 1.9882 | 2.02
23.8 | 1.8541 | 1.8848 | 1.9157 | 1.9469 | 1.9783 | 2.0099
15.9 | 1.845 | 1.8756 | 1.9063 | 1.9373 | 1.9686 | 2.0001
12.7 | 1.8361 | 1.8665 | 1.8971 | 1.928 | 1.9591 | 1.9904
5.2 | 1.8274 | 1.8576 | 1.8881 | 1.9188 | 1.9497 | 1.9809
1 | 1.8188 | 1.8488 | 1.8792 | 1.9097 | 1.9405 | 1.9716
5.2
12.7
15.9
23.8
35.7
42.3
51.3
56
60.4
71.3
 |  |  |  | #N/A
Spreadsheet: 105818d1303117294-display-data-from-1-sheet-to-another-sheet-automatically-sample-1000-
Sheet: Aintree

[NAME]
2:00  Aintree | [NAME] | Hurdle | 0 | 0
2:30  Aintree | [NAME] | Hurdle | 0 | 0
3:05  Aintree | [NAME] | Chase | 0 | 0
3:40  Aintree | [NAME] | chase | 0 | 0
4:15  Aintree | [NAME] | Chase | 0 | 0
4:50  [NAME] | [NAME] | Chase | 0 | 0
5:25  Aintree | [NAME] | Hurdle | 0 | 0
2:00  Aintree | [NAME] | Hurdle | 0 | 0
2:30  Aintree | [NAME] | Chase | 123 | -100
3:05  Aintree | [NAME] | Chase | -100 | -100
3:40  Aintree | [NAME] | Chase | 0 | 0
4:15  Aintree | [NAME] | Hurdle | 0 | 0
4:50  [NAME] | [NAME] | Hurdle | 0 | 0
5:25  Aintree | [NAME] | flat | 0 | 0
Spreadsheet: a092c8d2-950a-4d48-a794-e241bb960e1f
Sheet: Sheet1

ADVANCED MICRO DEVICES INC | Unnamed: 1 | Unnamed: 2
10-K
02/19/2010
MANAGEMENT’S DISCUSSION AND ANALYSIS
PART I | PART I | 1
ITEM 1. | BUSINESS | 1
ITEM 1A. | RISK FACTORS | 18
ITEM 1B. | UNRESOLVED STAFF COMMENTS | 34
ITEM 2. | PROPERTIES | 34
ITEM 3. | LEGAL PROCEEDINGS | 35
ITEM 4. | SUBMISSION OF MATTERS TO A VOTE OF SECURITY HOLDERS | 37
PART II | PART II | 38
ITEM 5. | MARKET FOR REGISTRANT S COMMON EQUITY, RELATED STOCKHOLDER MATTERS AND ISSUER PURCHASES OF EQUITY SECURITIES | 38
ITEM 6. | SELECTED FINANCIAL DATA | 40
ITEM 7. | MANAGEMENT S DISCUSSION AND ANALYSIS OF FINANCIAL CONDITION AND RESULTS OFOPERATIONS | 42
ITEM 7A. | QUANTITATIVE AND QUALITATIVE DISCLOSURE ABOUT MARKET RISK | 73
ITEM 8. | FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA | 77
ITEM 9. | CHANGES IN AND DISAGREEMENTS WITH ACCOUNTANTS ON ACCOUNTING AND FINANCIAL DISCLOSURE | 134
ITEM 9A. | CONTROLS AND PROCEDURES | 134
ITEM 9B. | OTHER INFORMATION | 134
PART III | PART III | 135
ITEM 10. | [NAME], EXECUTIVE OFFICERS AND CORPORATE GOVERNANCE | 135
ITEM 11. | EXECUTIVE COMPENSATION | 135
ITEM 12. | SECURITY OWNERSHIP OF CERTAIN BENEFICIAL OWNERS AND MANAGEMENT AND RELATED STOCKHOLDERMATTERS | 135
ITEM 13. | CERTAIN RELATIONSHIPS AND RELATED TRANSACTIONS AND DIRECTOR INDEPENDENCE | 135
ITEM 14. | PRINCIPAL ACCOUNTANT FEES AND SERVICES | 135
PART IV | PART IV | 136
ITEM 15. | EXHIBITS, FINANCIAL STATEMENT SCHEDULES | 136
SIGNATURES | SIGNATURES | 144
Spreadsheet: 714498d1611246408-generate-sequence-number-based-on-nth-order-sample-7-
Sheet: Sheet1

Date | CustomerNum | Last | First | PurchaseNum | OrderSeq
2021-01-05 00:00:00 | 12345A | [NAME] | Action | 11567893
2021-01-05 00:00:00 | 12345A | [NAME] | Action | 11567893
2021-01-10 00:00:00 | 12345A | [NAME] | Action | 50087451
2021-01-10 00:00:00 | 12345A | [NAME] | Action | 50087451
2021-01-20 00:00:00 | 12345A | [NAME] | Action | 600986744
2021-01-12 00:00:00 | 56473C | Smith | [NAME] | 30918372
2021-01-12 00:00:00 | 56473C | Smith | [NAME] | 55552101
2021-01-01 00:00:00 | 98761A | Jones | [NAME] | 13685483
2021-01-01 00:00:00 | 98761A | Jones | [NAME] | 13685483
2021-01-15 00:00:00 | 98761A | Jones | [NAME] | 55489342
2021-01-15 00:00:00 | 98761A | Jones | [NAME] | 55489342
 |  |  |  |  | Looking to have order sequence generated by formula
Spreadsheet: 817889d1676487530-get-filter-function-working-in-data-validation-filter-data-validation-in-table
Sheet: Sheet1

Employee Roster | Active | Location |  |  |  | Project | Location | Resource Name |  |  |  | [NAME] that Returns the results I want in the drop-down
No |  |  |  |  |  | Client 1 | Onshore |  |  |  |  |  | =FILTER(emplRoster[Employee Roster],((emplRoster[Location]=H2)+(emplRoster[Location]=""))*(emplRoster[Active]<>"No"))
TBD |  |  |  |  |  | Client 1 | LATAM |  |  |  |  | TBD
Aarod |  | Onshore |  |  |  | Client 1 | India |  |  |  |  | Aarod
[NAME] |  | Onshore |  |  |  | Client 2 | Onshore |  |  |  |  | [NAME]
[NAME] |  | LATAM |  |  |  |  | LATAM |  |  |  |  | [NAME]
[NAME] |  | Onshore |  |  |  | Client 3 | India |  |  |  |  | [NAME]
Felipe |  | LATAM |  |  |  |  | LATAM |  |  |  |  | [NAME]
[NAME] | No | Onshore |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  | Onshore |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  | Onshore |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  | Onshore |  |  |  | How can I put the formula on the right (or something like it) into each cell of the Resource Name column so that the Data Validation drop-down only shows the resources assigned to a location (@Location in the table above)?
[NAME] | No | Onshore
[NAME] |  | Onshore
[NAME] |  | Onshore
Siri |  | India
Tarun |  | India
Spreadsheet: 46732d1245674120-world-time-converter-world-time-simple-
Sheet: Sheet1

 | Country | GMT Ofset
 | Cape Verde Islands | -1 |  |  | Home Zone | London |  | SET YOUR HOME TIME ZONE HERE!
 | London | 0
 | Colorado | -7 |  |  | GMT |  |  | GMT Calculated From Your Home Zone
 |  |  |  |  | 1 | Cape Verde Islands
 |  |  |  |  |  | Colorado
Spreadsheet: d5c2b80a-7e46-48d9-9a7e-9a476e112794
Sheet: Sheet1

Klass | S.nr | [NAME] | [NAME] | Efternamn | Nat | Klubb | Anmälare | Transp. | Märke | Mc-modell
250 SP | 11 | B | Pär | [NAME] | S | [NAME] |  |  | Aprilia | RS250
250 SP | 14 | B | Filip | Backlund | S | SMK Västerås | Svenska Roadracingfabriken |  | Aprilia | RS250
250 SP | 15 | B | Kicki | Söderström | S | Karlskoga MF |  |  | Aprilia | RS250
250 SP | 16 | A | Christian | Lebel | S | [NAME] |  |  | Aprilia | RS250
250 SP | 20 | A | Anders | [NAME] | S | [NAME] |  |  | Aprilia | RS250
250 SP | 22 | A | Henrik | Ohlsson | S | Falkenberg |  |  | Aprilia | RS250
250 SP | 27 | B | Dennis | Bjerke | S | Västra MK |  |  | Aprilia | RS
250 SP | 33 | B | [NAME] | Lindén | S | Karlskoga Ms |  |  | Aprilia | RS250
250 SP | 36 | B | [NAME] | Kvist | S | Norra Roadracing Sällskapet |  |  | [NAME] | RGV
250 SP | 38 | B | [NAME] | Eriksson | S | [NAME] |  |  | Aprilia | RS250
250 SP | 42 | B | Magnus | [NAME] | S | [NAME] |  |  | Aprilia | RS 250
250 SP | 45 | A | [NAME] | Dahlgren | S | LMS |  |  | Aprilia | RS250
250 SP | 52 | B | Per Erik | [NAME] | S | Karlskoga MF |  |  | Aprilia | SP
250 SP | 64 | B | [NAME] | Abrahamsson | S | [NAME]
250 SP | 65 | B | [NAME] | v Platen | S | [NAME]
250 SP | 66 | B | Torleif | Paulsson | S | [NAME] |  |  | Aprilia | RS250
250 SP | 71 | B | Lars | Lüdke | S | FMCK Stockholm |  |  | Aprilia | RS250
250 SP | 72 | B | Kjell-Åke | Andersson | S | LMS |  |  | Aprilia | RS250
250 SP | 74 | A | Patrik | Svensson | S | LMS |  |  | [NAME] | RGV
250 SP | 79 | B | Therése | Scherp | S | Karlskoga MF |  |  | Aprilia | RS 250
250 SP | 80 | A | [NAME] | Nordin | S | ÖMCC | Team Örnfrakt |  | Aprilia | RS250
250 SP | 83 | B | Gunnar | Palmqvist | S | Bollnäs MCK |  |  | Aprilia | RS
250 SP | 85 | B | [NAME] | Toldnes | S | LMS | SMC racing |  | Aprilia | RS250
250 SP | 92 | B | Marcus | Nilsson | S | Västra MK |  |  | Aprilia | RS250
250 SP | 98 | A | Henrik | Persson | S | SMCC-Sundsvall |  |  | [NAME] | RGV 250 SP
250 SP | 99 | B | [NAME] | Håkansson | S | [NAME] |  |  | Aprilia | RS250
Spreadsheet: 296959d1392238994-importing-excel-sheet-fields-into-separate-excel-based-invoice-sample_invoice
Sheet: Sheet1

 |  |  | [NAME]
 |  |  |  |  | Invoice # | 163687-M
 |  |  |  |  | Invoice Date | 2013-10-01 00:00:00
 |  |  |  |  | Due Date | Upon Receipt
 | Invoice To: |  |  |  | Equipment Location:
 | Accounts Payable |  |  |  | Name
 | Name |  |  |  | Business
 | Business |  |  |  | Addresss
 | Address |  |  |  | City, State, Zip
 | City, State, Zip
Billing Period |  | Qty | Product | Serial # | Description | Net Amount
10/1/2013-9/30/2014 |  | 1 | CX-30-MT | 60612327274 | 1 Year Advance Exchange Maintenance | 85
 |  |  |  |  | Subtotal
 |  |  |  |  | Tax
 |  |  |  |  | Grand Total Due
 |  |  |  | TO ENSURE PROPER CREDIT, PLEASE RETURN THIS PORTION WITH YOUR PAYMENT
Mail Payment to: |  |  |  |  | Invoice # | 163687-M
 |  |  |  |  | Invoice Date | 2013-10-01 00:00:00
 |  |  |  |  | Terms | 100% Net Due
 |  |  |  |  | Balance Due
 |  |  | To Pay By Credit Card, PayPal, ACH - Please Call
Spreadsheet: ed3113d6-bc00-45a1-9149-e68f963e34e4
Sheet: Sheet1

NORTH SUBURBAN LADIES TENNIS ASSOCIATION INC. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
ADDITIONAL REGISTRATION FORM
 | NOTE 1. |  | Requests for additional registration must be sent to the
 |  |  | Assistant Secretary: - |  |  | [NAME]
 |  |  |  |  |  | 47 [NAME]
 |  |  |  |  |  | Strathmore 3041
 | Before being considered a player must play 3 matches as an emergency and all scores
 | and positions played for each team member must be listed below.
 | An emergency player cannot play a 4th match until an extra reqistration is applied for and granted.
 | All additional registrations are considered prior to monthly meeting (Normally 1st Monday of month)
 | Additional Reqistration close prior to the 4th last match of the season.
 | If an additional registration is required for a team with more than 7 players the registration will
 | not be considered unless one of the other players is delisted.
 | Clubs are also reminded  that an emergency player cannot improve the team. If an emergency
 | player is found to have strengthened the team their games will be forfeited.
 | Name of Club……………………………… |  |  |  |  |  | DATE…………………………..
 | Player's Name………………………………………..
 | Section Requested……………………………………..
 | Previous N.S.L.T.A.Section …………………………………………… |  |  |  |  | Season/Year  played…………………….
 | Other Competition Experience………………………………………………………..
 | Reason for additional Registration…………………………………………………………………….
 | …………………………………………………………………………………………………………….
 | Player to be delisted………..……………………………………….Reason………………………...
 | Signed………………………………………………….. (Club Secretary)
 | Match | Player's |  | Other Players scores
 | Date | Position | Score | Position | Score | Position | Score | Position | Score | Position | Score
1
2
3
 | eg:- | 3 | 15 - 19 | 1 | 21 - 13 | 2 | 19 - 17 | 4 | 13 - 20 | 5 | 17 - 15
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
 | OFFICE USE ONLY
 | Total Scores | Position | Score | Position | Score | Position | Score | Position | Score | Position | Score
 | Plus/            Minus
 | Registration Approved  Date…………………… |  |  |  |  |  | Registration Denied Date……………..
 | Master [NAME] …………………………. |  |  |  |  |  | Reason………………………………….
 | Section Secretary Advised……………………. |  |  |  |  |  | Club Advised……………………………
 |  |  |  |  |  |  | Any further action………………………
Spreadsheet: 793608d1661576498-group-by-year-and-quarter-from-dynamic-array-date-sequence-year-and-quarter-dynamic
Sheet: Sheet1

2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 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
 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 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
 |  |  | Desired Result
 |  |  |  |  |  |  |  |  |  |  |  | Dynamic Range
2022 |  | 2023 |  |  |  | 2024
Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3
 |  | 2023 |  |  |  | 2024
Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3
Assume if in the future, data has dates that starts below
 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00
 |  |  | Desired Result
2022 | 2023 |  |  |  | 2024
Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2
 | 2023 |  |  |  | 2024
Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2