tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 685479d1594036615-list-most-frequently-occurring-strings-n-most-repetitive-words-in-a-sheet-range-sample
Sheet: TargetSheet

Scenario (1) in the same sheet
Enter the number of last most frequent words (n): | 3
Results:
dog | 6
tree | 4
[NAME] | 3 |  | [NAME]
paper | 3 |  | dog
 |  |  | [NAME]
 |  |  | tree |  | dog
"If results are in the same page the yellow range should not be considered in the counting." |  |  | cat
 |  |  | cat |  |  |  | Title1 | Title2 | Title3
For your help the reptition of cell strings are liste here and this part is not needed for result: |  |  |  |  | paper |  | paper
 |  |  |  |  |  |  | tree | tree1
dog | 6 |  |  | paper2 |  |  | dog
tree | 4 |  |  |  |  |  | dog |  | dog
[NAME] | 3 |  |  |  |  |  | cat2 | [NAME] | tree
paper | 3
cat | 2
cat2 | 2
paper2 | 1 |  |  |  | Row Labels
 |  |  |  |  | cat2
 |  |  |  |  | tree
 |  |  |  |  | dog
 |  |  |  |  | paper
 |  |  |  |  | Grand Total
Spreadsheet: 801323d1666172457-merging-3-sheets-to-one-then-using-filter-function-example-attached-excel-help-4
Sheet: Michael

85% Zoom | Requsition Updates - Michael
 | Employee Details |  |  |  |  |  |  |  |  | Ad Details |  |  |  |  |  |  |  |  |  | Onboarding Progress |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status
 | Name | Position | State | Clinic | Hiring Manger | Entity | Employment Type | Requisition Type |  | Job Ad ID | Quantity | Number of Relists | Posted | Check In | [NAME] | Listing Type | Status | Potential Candidates |  | SharePoint Created | Resume Uploaded | [NAME] | [NAME] | PEM Sent D&A Booked | PEM Determination | D&A Determination | AHPRA Registration | [NAME] | Contract Details From HM | Contract Drafted | [NAME] by HM | Flare Uploaded | [NAME] | Litmos User Form | Litmos Welcome | Job Adder Updated | SharePoint Folder Moved |  | Complete % | Completed |  |  |  |  |  | Duration from Ad (Days)
 | 1 | MR | NSW |  |  |  | PPT | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 2 | MR | NSW |  |  |  | PPT | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 3 | PM | WA |  |  |  | PFT | New Hire |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 4 | RN | QLD |  |  |  | PPT | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 5 | OHN | VIC |  |  |  | PPT | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 6 | Physiotherapist | SA |  |  |  | PPT/PFT | New Hire |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 7 | OHN | SA |  |  |  | PPT | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 8 | MR | NSW |  |  |  | PPT | Variation |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | 9 | Contact [NAME] | SA |  |  |  | PFT | New Hire |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
jo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Agreement approved
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEM Booked and [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Agreement approved
Spreadsheet: kevin_hyatt__19642__SD Volumes
Sheet: Capacity

Sun Devil Power Generators
 |  |  | In-Service |  | MMBtu/d | Sun Devil
Developer | Plant | [NAME]. Mw | Date | Status | Gas Demand | Est. Demand
AZ Public Service | W Phoenix | 366 | old | Operating | 97262
AZ Public Service | W Phoenix | 120 | 2001-06-01 00:00:00 | Operating | 20736
SRP | [NAME] | 600 | old | Operating | 97600 | 30000
Duke | Arlington Valley | 550 | 2002-06-01 00:00:00 | Under Construction | 125000 | 50000
Pinnacle West | Redhawk | 1160 | 2002-06-01 00:00:00 | Under Construction | 210000 | 100000
Sempra Energy | Mesquite | 1300 | 2003-01-01 00:00:00 | Under Construction | 220490 | ??
Panda Energy | Gila Bend | 2300 | 2003-03-01 00:00:00 | Under Construction | 390098 | 100000
PG&E | Harquahala Valley | 1083 | 2003-06-01 00:00:00 | Under Construction | 178825 | ??
Dynegy, Xcel, SRP | [NAME] | 265 | 2003-06-01 00:00:00 | Advanced [NAME] | 45315 | 20000
Pinnacle West | West Phoenix | 500 | 2003-06-01 00:00:00 | Under Construction | 86352 | 50000
PPL | Sundance | 600 | 2002-06-01 00:00:00 | Early Development | 90000
Energy Dev Group | Gallup | 1200 | 2004-07-01 00:00:00 | Early Development | 216000 | 216000
Spreadsheet: 691712d1597840153-help-with-vlookup-and-index-match-not-returning-all-unique-values-book1
Sheet: Sheet1

What results should be | Current results
50200-TLA-20-CL1 | 50200-TLA-20-CL1
50200-TLA-20-BK | 50200-TLA-20-BK
50200-TLA-A510-20 | 50200-TLA-A510-20
50200-TLA-A510-20-W | 50200-TLA-A510-20-W
BE200-TLA-A000 | BE200-TLA-A000
BE200-TLA-R000 | BE300-TLA-A000
BE300-TLA-A000 | 50200-TLA-A530-M1
BE300-TLA-R000 | 50200-TLA-A53
50200-TLA-A530-M1
50200-TLA-R530-M1
50200-TLA-A53
50200-TLA-R53 | The current results of my vlookup formulas do not have all unique values.
Spreadsheet: 6f443707-210a-43e5-8651-4729478cc604
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
FFIBR | Test | FFIBR | [NAME] | [NAME], P | Radial Immunodiffusion | Light blue-top (citrate) tube: LgtBlu |  |  | 0.5 | mL | Draw blood in a light blue-top (citrate) tube(s). Separate and submit 0.5 mL citrate plasma frozen.  NOTE: Separate specimens must be submitted when multiple tests are ordered. | 0.1 mL | Specimens other than	Plasma Anticoagulants other than	Sodium citrate Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | 201-454 mg/dL   Interpretive note: Differentiation of congenital from acquired defects of fibrinogen requires clinical correlation. Fibrinogen antigen data should be compared with functional fibrinogen activity on the same sample for evaluation of afibrinogenemia, hypofibrinogenemia and dysfibrinogenemia.   Test Performed by: BloodCenter of Wisconsin                                       638 N. 18th Street                                       Milwaukee, WI 53233-2121 | Varies | 7 - 10 days | 9 - 12 days | 1 | 85385 |  |  |  |  | Bloodcenter of Wisconsin, Inc.
FFIBR | [NAME] | NACIT | [NAME] |  |  |  | Frozen
FFIBR | Result | Z2054 | [NAME], P | [NAME], P | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 58924d1259199778-summarizing-data-example
Sheet: Sheet1

CUSTOMER | ITEM1 | ITEM2 | ITEM3 | ITEM4
[NAME] | STAPLER | PAPER
SUZY B GOOD | PAPER | STAPLER
SUZY B GOOD | ERASER | PEN
[NAME] | NOTEPAD | STAPLER
SUZY B GOOD | NOTEPAD | STAPLER
[NAME] | PAPER
[NAME] | PAPER CLIP | NOTEPAD
[NAME] | SCISSORS
ANON Y MOUSE | STAPLER | SCISSORS
[NAME] | ERASER | PENCIL | PEN | MOUSEPAD
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2001 |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2010 |  | 12-31-2015 |  | 12-31-2020 |  | after 12-31-2020 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 880699d1728551085-populate-names-of-people-running-the-same-course-on-any-given-date-samplequery
Sheet: Schedule

NAME | 2024-09-16 00:00:00 | 2024-09-17 00:00:00 | 2024-09-18 00:00:00 | 2024-09-19 00:00:00 | 2024-09-20 00:00:00 | 2024-09-23 00:00:00 | 2024-09-24 00:00:00 | 2024-09-25 00:00:00 | 2024-09-26 00:00:00 | 2024-09-27 00:00:00 | 2024-09-30 00:00:00 | 2024-10-01 00:00:00 | 2024-10-02 00:00:00 | 2024-10-03 00:00:00 | 2024-10-04 00:00:00
 | 2024-09-16 00:00:00 | 2024-09-17 00:00:00 | 2024-09-18 00:00:00 | 2024-09-19 00:00:00 | 2024-09-20 00:00:00 | 2024-09-23 00:00:00 | 2024-09-24 00:00:00 | 2024-09-25 00:00:00 | 2024-09-26 00:00:00 | 2024-09-27 00:00:00 | 2024-09-30 00:00:00 | 2024-10-01 00:00:00 | 2024-10-02 00:00:00 | 2024-10-03 00:00:00 | 2024-10-04 00:00:00
TRAINERS
[NAME] | Design | Annual Leave | Non Working Day | Annual Leave | Design | Design | Design | Non Working Day | Design | Design | BOR C01 | BOR C01 | Non Working Day | BOR C01 | BOR C01
[NAME] | NET Induction | NET C03 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C01/C02 SDW 1 W 6 | NET C03 W 3 | NET C04 W 3 | NET C04 W 3 | NET C04 W 3 | NET C04 W 3
[NAME] | NET Induction | NET C04 W 1 | NET C04 W 1 | NET C04 W 1 | NET C04 W 1 | NET C04 W 2 | NET C04 W 2 | NET C04 W 2 | MT C02 | MT C02 | NET C04 W 3 | NET C04 W 3 | NET C04 W 3 | NET C04 W 3 | NET C04 W 3
[NAME] | NET C03 W 1 | Absent | Absent | Non Working Day | Non Working Day | NET C04 W 2 | NET C04 W 2 | NET C04 W 2 | Non Working Day | Non Working Day | NET C04 W 3 | NET C04 W 3 | NET C04 W 3 | Non Working Day | Non Working Day
[NAME] | NET C03 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C01/C02 SDW 1 W 6 | NET C03 W 3 | NET C03 W 3 | NET C03 W 3 | NET C03 W 3 | NET C03 W 3
Viola Fuss | NET C04 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C03 W 3 | NET C03 W 3 | NET C03 W 3 | NET C03 W 3 | NET C03 W 3
[NAME] | NET C04 W 1 | NET C03 W 1 | NET C03 W 1 | NET C03 W 1 | Annual Leave | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | Non Working Day | Annual Leave | Annual Leave | Annual Leave | Annual Leave | Non Working Day
[NAME] | NET C04 W 1 | NET C04 W 1 | Non Working Day | NET C04 W 1 | NET C04 W 1 | NET C04 W 2 | NET C04 W 2 | Non Working Day | NET C04 W 2 | NET C04 W 2 | BOR C01 | BOR C01 | Non Working Day | BOR C01 | BOR C01
Ophelia Payne | NET Induction | NET C04 W 1 | NET C04 W 1 | NET C04 W 1 | NET C04 W 1 | NET C04 W 2 | NET C04 W 2 | NET C04 W 2 | NET C04 W 2 | NET C04 W 2 | BOR C01 | BOR C01 | BOR C01 | BOR C01 | BOR C01
[NAME] | NET C03 W 1 | NET C03 W 1 | Non Working Day | NET C03 W 1 | NET C03 W 1 | Induction | Induction | Induction | MT C02 | MT C02 | BOR C01 | BOR C01 | BOR C01 | BOR C01 | BOR C01
[NAME] | NET C03 W 1 | NET C03 W 1 | NET C04 W 1 | NET C04 W 1 | NET C04 W 1 | NET C03 W 2 | NET C03 W 2 | NET C03 W 2 | NET C04 W 2 | NET C04 W 2 | NET C04 W 3 | NET C03 W 3 | NET C04 W 3 | NET C04 W 3 | BOR C01
Spreadsheet: 676322d1588757584-bill-amount-automatically-changing-depending-on-which-month-year-selected-finances
Sheet: Main Sheet

[NAME] | May |  | [NAME] (Manual Payment) | Planned £ | Actual £ |  | [NAME] (DD Payment) | Planned £ | Actual £
[NAME] | 2020 |  |  | 125 |  |  | Home Insurance | 0
Yearly | 25000 |  |  |  |  |  |  | 25
Monthly |  |  | Water | 30 |  |  | TV, Talk & Broadband | 50
Tax | 100 |  |  |  |  |  | TV Licence | 12
National Insurance | 110 |  | Diesel | 50 |  |  | [NAME] | 11
Pension | 110 |  | Electric | 60 |  |  | Mobile Phone Joint Bill | 30
Rebates | 0 |  | Gas | 30 |  |  |  | 15
[NAME] |  |  | Savings | 100 |  |  | Netflix | 11.99
 |  |  | Trust Fund | 50 |  |  |  | 62
Bills Total |  |  | Loan Repay | 50 |  |  |  | 30
Leftover After Bills |  |  | Store Card | 0
 |  |  | Credit Card | 0
 |  |  | [NAME] | 20
 |  |  | Total |  |  |  | Total
 |  |  | Left To Pay |  |  |  | Left To Pay
Spreadsheet: 017a395b-425c-4fce-8526-867f69a8dc1d
Sheet: masked_gender

DIST_OF_RES_IRN | gender | read_result | math_result | sci_result
043489 | Female | 66.2 | 35.8 | 13.2
043497 | Female | NC | NC | NC
043513 | Female | 93.8 | 18.8 | 6.25
043711 | Female | 63.3 | 36.7 | 6.67
043752 | Female | 67.2 | 38.7 | 7.15
043794 | Female | 84.6 | 46.2 | 7.69
043802 | Female | 67.2 | 42.1 | 16
043844 | Female | 66.4 | 38.6 | 14.7
043901 | Female | 79.4 | 35.3 | 23.5
043919 | Female | 73.7 | 21.1 | 21.1
043943 | Female | NC | NC | NC
043950 | Female | 73.9 | 40.5 | 9.8
044222 | Female | 78.9 | 64.9 | 17.5
044263 | Female | 72.1 | 42.3 | 14.4
044297 | Female | 82 | 60.4 | 26.6
044305 | Female | 76.5 | 43.1 | 27.5
044339 | Female | NC | NC | NC
044404 | Female | 72.7 | 43.2 | 4.55
044412 | Female | 76.9 | 61.5 | 26.9
044669 | Female | NC | NC | NC
044677 | Female | NC | NC | NC
044743 | Female | 64.3 | 42.9 | 7.14
044800 | Female | 86.7 | 50 | 20
044818 | Female | 68.9 | 37.2 | 14.2
044909 | Female | 68.7 | 40 | 18.2
044990 | Female | 54.1 | 32.4 | 18.9
045005 | Female | 71.9 | 56.3 | 31.3
045070 | Female | NC | NC | NC
045161 | Female | 71.6 | 48.1 | 21.9
045179 | Female | NC | NC | NC
046979 | Female | NC | NC | NC
048686 | Female | 81.8 | 54.5 | 13.6
048694 | Female | 92.9 | 57.1 | 21.4
049288 | Female | NC | NC | NC
050013 | Female | NC | NC | NC
050195 | Female | 77.8 | 51.1 | 24.4
043489 | Male | 63.3 | 38.6 | 19
043513 | Male | 50 | 10 | 10
043711 | Male | 51.7 | 30 | 3.33
043752 | Male | 60.6 | 41.4 | 9.17
043794 | Male | NC | NC | NC
043802 | Male | 65 | 50.6 | 18.7
043844 | Male | 57.5 | 38.8 | 17.7
043901 | Male | 78.6 | 50 | 35.7
043919 | Male | 68.8 | 25 | 18.8
043943 | Male | NC | NC | NC
043950 | Male | 63 | 50 | 12.3
044222 | Male | 68.1 | 63.8 | 24.5
044263 | Male | 61.7 | 52.3 | 23.4
044297 | Male | 82.6 | 62.9 | 33.3
044305 | Male | 87.1 | 67.7 | 38.7
044404 | Male | 57.8 | 37.8 | 11.1
044412 | Male | 65.1 | 62.8 | 32.6
044669 | Male | NC | NC | NC
044677 | Male | NC | NC | NC
044743 | Male | 60 | 25 | 0
044800 | Male | 88.9 | 74.1 | 25.9
044818 | Male | 63.1 | 42 | 15.3
044909 | Male | 63.8 | 46.3 | 23.1
044990 | Male | 63.6 | 40.9 | 9.09
045005 | Male | 60.7 | 46.4 | 25
045070 | Male | NC | NC | NC
045161 | Male | 64.3 | 42.9 | 25.6
045179 | Male | NC | NC | NC
046979 | Male | NC | NC | NC
048686 | Male | 56.5 | 47.8 | 17.4
048694 | Male | NC | NC | NC
049288 | Male | NC | NC | NC
050195 | Male | 73.8 | 60.7 | 21.3
043802 | Missing Gender | NC | NC | NC
043844 | Missing Gender | NC | NC | NC
044909 | Missing Gender | NC | NC | NC
048686 | Missing Gender | NC | NC | NC
Spreadsheet: 492744d1481231599-regression-in-excel-regression-pcb-
Sheet: Sheet1

 |  |  | a | b | c
 |  |  | 0.001119448483894002 | 4.699450786184087 | 4.699440156036674
 |  |  | T=A*N^B*N^C | delta
 | 1 | 10
 | 2 | 50
 | 3 | 500
 | 4 | 2000
 | 5 | 8000
 | 6 | 20000
 | 7 | 100000
 |  |  | Sum:
 | 1
 | 1.1
 | 1.2
 | 1.3
 | 1.4
 | 1.5
 | 1.6
 | 1.7
 | 1.8
 | 1.9
 | 2
 | 2.1
 | 2.2
 | 2.3
 | 2.4
 | 2.5
 | 2.6
 | 2.7
 | 2.8
 | 2.9
 | 3
 | 3.1
 | 3.2
 | 3.3
 | 3.4
 | 3.5
 | 3.6
 | 3.7
 | 3.8
 | 3.9
 | 4
 | 4.1
 | 4.2
 | 4.3
 | 4.4
 | 4.5
 | 4.6
 | 4.7
 | 4.8
 | 4.9
 | 5
 | 5.1
 | 5.2
 | 5.3
 | 5.4
 | 5.5
 | 5.6
 | 5.7
 | 5.8
 | 5.9
 | 6
 | 6.1
 | 6.2
 | 6.3
 | 6.4
 | 6.50000000000001
 | 6.6
 | 6.7
 | 6.80000000000001
 | 6.90000000000001
 | 7.00000000000001
 | 7.10000000000001
 | 7.20000000000001
 | 7.30000000000001
 | 7.40000000000001
 | 7.50000000000001
Spreadsheet: 853920d1703866120-sorting-data-with-date-range-in-ascending-order-tc-sort-by-dates-testing-03
Sheet: Sheet1

 | From | 2026-01-20 00:00:00 |  | Till | 2027-06-27 00:00:00
S/N | Operator | Broker | Vessel | Delivery date | Date of declaration | Other remarks |  | Vessel AAD should not  appear on cell (F5) as the date range not matching.
S/N | Operator | Broker | Vessel | Delivery date | Date of declaration | Other remarks
 | EIG | IGK | ABC | 21/08/2021 | 2031-06-22 00:00:00 | 22 Jun 2031 is a Sunday
 | EIG | IGK | DEF | 14/11/2021 | 2031-09-15 00:00:00
 | EIG | IGK | GHI | 13/01/2022 | 2031-11-14 00:00:00
 | EIG | TLA | JKL | 17/03/2022 | 2025-11-17 00:00:00
 | EIG | TLA | MNO | 2022-10-05 00:00:00 | 2027-09-01 00:00:00 | 9 Jan 2027 is a Saturday
 | EIG | TLA | PQR | 30/08/2022 | 2027-04-30 00:00:00
 | EIG | KEO | STU | 2021-07-06 00:00:00 | 2026-08-04 00:00:00
 | EIG | KEO | VWX | 28/05/2021 | 2028-03-29 00:00:00
 | EIG | KEO | ZYA | 2021-07-06 00:00:00 | 2028-08-04 00:00:00 | 8 Apr is a Saturday
 | EIG | KEO | AAb | 24/10/2022 | 2027-07-26 00:00:00
 | EIG | KEO | AAC | 21/03/2023 | 2023-01-21 00:00:00
 | EIG | KEO | AAD | 15/05/2023 | 2023-03-15 00:00:00
 | EIG | KEO | AAE | 2023-04-09 00:00:00 | 2028-04-03 00:00:00
 | EIG | KEO | AAF | 27/11/2023 | 2028-05-27 00:00:00
 | EIG | YUT | AAG | 30/06/2022 | 2027-03-30 00:00:00
 | EIG | HMD | AAH | 30/10/2023 | 2026-07-30 00:00:00
 | EIG | HMD | AAI | 29/09/2023 | 2026-09-29 00:00:00
 | EIG | TLA | AAJ | 19/08/2023 | 2026-06-20 00:00:00
Spreadsheet: 125890d1319347109-using-first-drop-down-list-to-consolidate-data-in-second-drop-down-list-sample
Sheet: Data

 |  |  |  | C | F | S |  | C | F | S
Apple | C |  |  |  |  |  |  |  |  |  |  |  |  | None
Dogwood | C
Locust | C
Palm | C
Pear | C
Pine | C
Willow | C
Maple | F
Oak | F
Redwood | F
Birch | S
Cyprus | S
Fir | S
Spreadsheet: 548646d1511255583-extract-data-in-excel-test-for-excel-forum
Sheet: Sheet1

DATA FILE LIKE THIS
No. | NAME | Sanc Amount | Sanc Date | Exp Date |  | WANT CHANGES LIKE THIS
 |  | Disb Amount | Disb Date | Overdue Date |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | Instalment Amount | Inst Date | Date |  | No. | NAME | Sanc Amount | Sanc Date | Exp Date | Disb Amount | Disb Date | Overdue Date | Instalment Amount | Inst Date | Date
10-810-7 | THE FRAGILE INTERNATIONAL | 310000 | 05-12-2002 | 05-03-2013 |  |  | THE FRAGILE INTERNATIONAL | 310000 | 05-12-2002 | 05-03-2013 | 310000 | 05-12-2002 | 30-06-1999 | 2585 | 27-09-2008
 |  | 310000 | 05-12-2002 | 30-06-1999 |  | 10-810-17 | IMPEX TRADING CO | 900000 | 09-11-2009 | 09-12-2016 | 900000 | 09-11-2009 | 24-04-2014 | 16619 | 09-01-2010
 |  | 2585 | 27-09-2008 |  |  | 11-805-4 | PAGNASARE DESIGNERS | 200000 | 27-06-2013 | 27-06-2018 | 200000 | 27-06-2013 | 05-11-2015 | 4758 | 27-07-2013
10-810-17 | IMPEX TRADING CO | 900000 | 09-11-2009 | 09-12-2016
 |  | 900000 | 09-11-2009 | 24-04-2014
 |  | 16619 | 09-01-2010
11-805-4 | PAGNASARE DESIGNERS | 200000 | 27-06-2013 | 27-06-2018 | Column No. | NEW RESULTS
 |  | 200000 | 27-06-2013 | 05-11-2015 |  | 1 | 2 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 3 | 4
 |  | 4758 | 27-07-2013 |  |  | OK | OK | Exp Date | Disb Amount | Disb Date | Overdue Date | Instalment Amount | Inst Date | Date | Sanc Amount of NEXT RECORD | Sanc Date of NEXT RECORD
Spreadsheet: 706290d1606592018-moving-multiple-rows-from-one-column-to-multiple-columns-example
Sheet: Sheet1

Route 01 |  |  |  | Route 01 | Route 02
118 Hillcrest Drive  Concord VA 24538 |  |  |  | 118 Hillcrest Drive  Concord VA 24538 | 1016 MAIN STREET LYNCHBURG VA 24504
1812 Bedford Ave Lynchburg VA 24504 |  |  |  | 1812 Bedford Ave Lynchburg VA 24504 | 1101 Madison St Lynchburg VA 24504
235 EVERGREEN AVE APPOMATTOX VA 24522 |  |  |  | 235 EVERGREEN AVE APPOMATTOX VA 24522 | 163 Second St Amherst VA 24521
297 Bible Baptist Road Appomattox VA 24522 |  |  |  | 297 Bible Baptist Road Appomattox VA 24522 | 1692 S Coolwell Rd Madison Heights VA 24572
335 [NAME] 24588 |  |  |  | 335 [NAME] 24588 | 173 BROCKMAN PARK DRIVE AMHERST VA 24521
377 [NAME] Drive Rustburg VA 24588 |  |  |  | 377 [NAME] Drive Rustburg VA 24588 | 186 Dillard Rd Madison Heights VA 24572
403 Court St Appomattox VA 24522 |  |  |  | 403 Court St Appomattox VA 24522 | 220 Amelon Expressway Madison Heights VA 24572
4320 Pumping Station Rd Appomattox VA 24522 |  |  |  | 4320 Pumping Station Rd Appomattox VA 24522 | 350 S [NAME] 131 Amherst VA 24521
664 Village Hwy Rustburg VA 24588 |  |  |  | 664 Village Hwy Rustburg VA 24588 | 4545 South Amherst [NAME] Heights VA 24572
825 [NAME] Street  Lynchburg VA 24504 |  |  |  | 825 [NAME] Street  Lynchburg VA 24504 | 621 Court Street, Lynchburg VA 24504
9339 Village Highway Concord VA 24538 |  |  |  | 9339 Village Highway Concord VA 24538 | 621 Dillard Rd Madison Heights VA 24572
State Route 691, Appomattox VA 24522 |  |  |  | State Route 691, Appomattox VA 24522 | 801 Ebenezer Road Amherst VA 24521
Route 02
1016 MAIN STREET LYNCHBURG VA 24504
1101 Madison St Lynchburg VA 24504
163 Second St Amherst VA 24521
1692 S Coolwell Rd Madison Heights VA 24572
173 BROCKMAN PARK DRIVE AMHERST VA 24521
186 Dillard Rd Madison Heights VA 24572
220 Amelon Expressway Madison Heights VA 24572
350 S [NAME] 131 Amherst VA 24521
4545 South Amherst [NAME] Heights VA 24572
621 Court Street, Lynchburg VA 24504
621 Dillard Rd Madison Heights VA 24572
801 Ebenezer Road Amherst VA 24521
Spreadsheet: geir_solberg__11268__EPE_SEP_2001
Sheet: TALLY SHEET

TOTAL SCHEDULED MWh FOR SEP (01)
2001-08-01 00:00:00
2001-08-02 00:00:00
2001-08-03 00:00:00
2001-08-04 00:00:00
2001-08-05 00:00:00
2001-08-06 00:00:00
2001-08-07 00:00:00
2001-08-08 00:00:00
2001-08-09 00:00:00
2001-08-10 00:00:00 |  |  |  |  |  |  | TOTAL SCHEDULED AMOUNT
2001-08-11 00:00:00
2001-08-12 00:00:00 |  |  |  |  |  |  | SCHEDULING FEE |  |  | 0.25
2001-08-13 00:00:00
2001-08-14 00:00:00 |  |  |  |  |  |  | SEPTEMBER ANNUITY AMOUNT
2001-08-15 00:00:00
2001-08-16 00:00:00 |  |  |  |  |  |  | ENPOWER ANNUITY NUMBER FOR SHORT TERM WEST SERVICES
2001-08-17 00:00:00 |  |  |  |  |  |  | ENPOWER ANNUITY NUMBER FOR SHORT TERM HOURLY SERVICES
2001-08-18 00:00:00
2001-08-19 00:00:00
2001-08-20 00:00:00
2001-08-21 00:00:00
2001-08-22 00:00:00
2001-08-23 00:00:00
2001-08-24 00:00:00
2001-08-25 00:00:00
2001-08-26 00:00:00
2001-08-27 00:00:00
2001-08-28 00:00:00
2001-08-29 00:00:00
2001-08-30 00:00:00
2001-08-31 00:00:00