tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 277955d1384489238-need-help-sorting-data-sample
Sheet: city

PhoneNumber | FirstName | LastName | Address | City | State | [NAME] | [NAME] | Gender | Group | Date | TextMsg
12405953189 | [NAME] | [NAME] | False | False |  |  | [EMAIL]
12405652911 |  |  |  | Upper Marlboro | MD | 20772
12406015800 | [NAME] | South | 1805 Castle Way | Potomac | MD | 20854
12406016800 | [NAME] | Jones |  | Potomac | MD | 20854
12406016800 | [NAME] | Jones | 34 [NAME] | Potomac | VA | 20832 | [EMAIL] |  | Special Offers | 2013-08-19T19:21:44 | No Text
12406015800 | [NAME] | South | 29 Rolling High Way | Olney | MD | 20832 | [EMAIL] |  |  | 2013-08-19T19:21:44 | No Text
12404987136 | [NAME] | Smith | 19307 Any Drive Pl. | Montgomery Village | MD | 20886
12404987136 | [NAME] | Smith |  | Montgomery Village | MD | 20886 | [EMAIL] |  |  | 2012-11-18T16:48:55 | No Text
12405938400 | Kelly | [NAME] | 7891 Moontown Dr Apt B | Laurel | MD | 20723
12405953189 | [NAME] | [NAME] |  | Lanham | MD | 20706 | [EMAIL] |  |  | 2012-11-02T14:14:31 | No Text
12404987136 |  |  |  | Gaithersburg | MD | 20885
12405652588 | [NAME] | Adams | 4567 Main Circle Court Apt 101 | Forestville | MD | 20747
12407987034 |  |  |  | District Heights | MD
12405652588 |  |  |  | District Heights | MD | 20747
12405063883 | [NAME] | Jones | 123 Adams Dr | College Park | MD | 20740
12405063883 | [NAME] | Jones |  | Churchton | MD |  | [EMAIL]
12405652911 |  |  |  |  | NULL
12404987136 | [NAME] | Smith |  |  |  |  | [EMAIL]
12404987136 | [NAME] | Smith |  |  |  |  | [EMAIL]
12405063883 | [NAME] | Jones |  |  |  |  | [EMAIL] |  | Waitlist
12405652588
12405938400 | Kelly | [NAME] |  |  |  |  | [EMAIL]
12405938400 | Kelly | [NAME] |  |  |  |  | [EMAIL] |  | Premium Seating
12406015800
12406016800 |  |  |  |  |  |  |  |  | Premium Seating
Spreadsheet: 072ae97a-90af-46a2-afca-7389a6678e0a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-23 09:18:57.640000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.401 | 102.276 | 102.151 | 101.776
4.5 | 101.468 | 101.343 | 101.218 | 100.843 |  | Note: | Refer To Price [NAME]
4.375 | 100.719 | 100.594 | 100.469 | 100.094 |  |  | For all Price Adjs
4.25 | 100.123 | 99.998 | 99.873 | 99.248
4.125 | 99.255 | 99.13 | 99.005 | 98.38
4 | 98.216 | 98.091 | 97.966 | 97.341
3.875 | 97.151 | 97.026 | 96.901 | 96.276
3.75 | 96.276 | 96.151 | 96.026 | 95.401
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.437 | 102.312 | 102.187 | 101.812
3.75 | 101.965 | 101.84 | 101.715 | 101.34
3.625 | 101.561 | 101.436 | 101.311 | 100.936
3.5 | 101.006 | 100.881 | 100.756 | 100.381
3.375 | 100.276 | 100.151 | 100.026 | 99.401
3.25 | 99.525 | 99.4 | 99.275 | 98.65
3.125 | 98.947 | 98.822 | 98.697 | 98.072 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-05-07 09:18:57.640000
30 DAY | 2014-05-22 09:18:57.640000
45 DAY | 2014-06-06 09:18:57.640000
60 DAY | 2014-06-21 09:18:57.640000
90 DAY | 2014-07-21 09:18:57.640000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: louise_kitchen__22730__0202MarginRequirements
Sheet: Template

FUTURES MARGIN REQUIREMENTS
2002-02-04 00:00:00
2002-02-01 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc |  |  |  | 0
ADM INVESTOR |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
BANK ONE |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
CARR FUTURES (NG) |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
CARR FUTURES INC. |  |  |  | 0
CREDIT SUISSE FIRST BOSTON |  |  |  | 0
EDF MAN
FIMAT |  |  |  | 0
HSBC - US$ |  |  |  | 0
HSBC - Canadian | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
JP Morgan |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
PARIBAS |  |  |  | 0
PRUDENTIAL SI |  |  |  | 0
REFCO, INC |  |  |  | 0
R J O'BRIEN |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
SAUL STONE & COMPANY |  |  |  | 0
SMITH BARNEY, INC |  |  |  | 0
SMITH BARNEY, INC  (Financial) | 0 |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 122911 | 120605 | 50961 | 53638
2 | 145284 | 108474 | 50999 | 88318
3 | 146493 | 108474 | 50983 | 88239
4 | 151669 | 118425 | 44619 | 78318
5 | 117062 | 79555 | 1308 | 38315
6 | 148786 | 84605 | 9713 | 73318
7 | 122811 | 114605 | 30005 | 38318
8 | 133311 | 105004 |  | 40816
9 | 142548 | 132998 | 38291 | 48318
10 | 141287 | 132998 | 40004 | 48318
11 | 129046 | 118196 | 37928 | 48177
12 | 125667 | 87865 | 221 | 37474
13 | 121878 | 53172 | 1 | 68265
14 | 117664 | 53077 |  | 63264
15 | 135506 | 93618 |  | 38265
16 | 128015 | 147738 | 28796 | 38318
17 | 126287 | 147012 | 29394 | 2
18 | 146693 | 144266 | 63511 | 56424
19 | 140264 | 71828 | 929 | 52111
20 | 113588 | 65289 |  | 31550
21 | 128624 | 90753 | 50700 | 90893
22 | 111047 | 109220 | 33652 | 38268
23 | 143024 | 141109 | 56005 | 52123
24
25
26
27
28
29
30
31
 |  |  |  | 2001-05-31 00:00:00 |  |  | 237513.04
 |  |  |  | 2001-06-23 00:00:00
Spreadsheet: 137c0375-df17-40d9-b15d-77752b78e791
Sheet: Sheet1

Unnamed: 0 | 2013 - Biweekly Timesheet Schedule | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  |  |  | Timesheets
 |  |  | Period |  | Due by 12 noon
 | Pay Dates |  | Ending |  | in payroll office
 | 2013-01-11 00:00:00 |  | 2013-01-05 00:00:00 |  | 2013-01-04 00:00:00
 | 2013-01-25 00:00:00 |  | 2013-01-19 00:00:00 |  | 2013-01-18 00:00:00
 | 2013-02-08 00:00:00 |  | 2013-02-02 00:00:00 |  | 2013-02-01 00:00:00
 | 2013-02-22 00:00:00 |  | 2013-02-16 00:00:00 |  | 2013-02-15 00:00:00
 | 2013-03-08 00:00:00 |  | 2013-03-02 00:00:00 |  | 2013-03-01 00:00:00
 | 2013-03-22 00:00:00 |  | 2013-03-16 00:00:00 |  | 2013-03-15 00:00:00
 | 2013-04-05 00:00:00 |  | 2013-03-30 00:00:00 |  | 2013-03-28 00:00:00 | *
 | 2013-04-19 00:00:00 |  | 2013-04-13 00:00:00 |  | 2013-04-12 00:00:00
 | 2013-05-03 00:00:00 |  | 2013-04-27 00:00:00 |  | 2013-04-26 00:00:00
 | 2013-05-17 00:00:00 |  | 2013-05-11 00:00:00 |  | 2013-05-10 00:00:00
 | 2013-05-31 00:00:00 |  | 2013-05-25 00:00:00 |  | 2013-05-24 00:00:00
 | 2013-06-14 00:00:00 |  | 2013-06-08 00:00:00 |  | 2013-06-07 00:00:00
 | 2013-06-28 00:00:00 |  | 2013-06-22 00:00:00 |  | 2013-06-21 00:00:00
 | 2013-07-11 00:00:00 | *** | 2013-07-06 00:00:00 |  | 2013-07-03 00:00:00 | *
 | 2013-07-25 00:00:00 | *** | 2013-07-20 00:00:00 |  | 2013-07-18 00:00:00 | ***
 | 2013-08-09 00:00:00 |  | 2013-08-03 00:00:00 |  | 2013-08-02 00:00:00
 | 2013-08-23 00:00:00 |  | 2013-08-17 00:00:00 |  | 2013-08-16 00:00:00
 | 2013-09-06 00:00:00 |  | 2013-08-31 00:00:00 |  | 2013-08-30 00:00:00
 | 2013-09-20 00:00:00 |  | 2013-09-14 00:00:00 |  | 2013-09-13 00:00:00
 | 2013-10-04 00:00:00 |  | 2013-09-28 00:00:00 |  | 2013-09-27 00:00:00
 | 2013-10-18 00:00:00 |  | 2013-10-12 00:00:00 |  | 2013-10-11 00:00:00
 | 2013-11-01 00:00:00 |  | 2013-10-26 00:00:00 |  | 2013-10-25 00:00:00
 | 2013-11-15 00:00:00 |  | 2013-11-09 00:00:00 |  | 2013-11-08 00:00:00
 | 2013-11-26 00:00:00 | *(11/29/13) | 2013-11-23 00:00:00 |  | 2013-11-15 00:00:00 | * BY 5PM
 | 2013-12-13 00:00:00 |  | 2013-12-07 00:00:00 |  | 2013-12-06 00:00:00
 | 2013-12-20 00:00:00 | *(12/27/13) | 2013-12-21 00:00:00 |  | 2013-12-12 00:00:00 | * BY 5PM
 | *EARLY PAYDATES/DUE DATES DUE TO HOLIDAY
 | **SUBJECT TO CHANGE
 | ***Summer Friday's Off
 | ^THIS PAYROLL WILL BE PAID EARLY WITH ALL DEDUCTIONS TAKEN OUT
Spreadsheet: 878233d1725294833-separate-letter-from-number-housenumber-map3-4-
Sheet: Blad1

address |  | street | number | letter added to number |  |  |  |  | number | letter added to number
perenlaan test 9a |  |  | 9a |  |  | 9 | a | perenlaan test | 9 | a
herken 47 |  | herken | 47 |  | herken | 47 |  | herken | 47
lkajsdf 8d |  | lkajsdf | 8d |  | lkajsdf | 8 | d | lkajsdf | 8 | d
jfjaja 99 zv |  | jfjaja | 99 zv |  | jfjaja | 99 | [NAME] | jfjaja | 99 | [NAME]
jkasldjfklsdaj 397b |  | jkasldjfklsdaj | 397b |  | jkasldjfklsdaj | 397 | b | jkasldjfklsdaj | 397 | b
Hello World 69 a |  | Hello World | 69 a |  | Hello World | 69 | a | Hello World | 69 | a
strasse grosse |  | strasse grosse |  |  | strasse grosse |  |  | strasse grosse
ThisStreet76 b |  | ThisStreet | 76 b |  | ThisStreet | 76 | b | ThisStreet | 76 | b
 |  |  | as you can see column D also contains a letter, I want the letters to appear in column E and only the number in column D.
Spreadsheet: d554741c-9d49-4146-bd85-d75f3ac2042a
Sheet: Sheet1

Unnamed: 0 | The University of Akron | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Corrective Action Form Instructions
 |  |  | Attendance Corrective Action |  |  |  |  |  | Performance Corrective Action
 | 1.  Be certain you are selecting the correct form.  These forms may be used for any union employee.  The menu options are above.
 | 2.  This Excel program is read-only.  You may rename the document you create and save it as an Excel file to your computer.  Do not save your reports to a shared drive.  Please exit the Corrective Action file when you are finished.
 | 3.  Do not forget to complete the "Improvement Required" section of the form prior to meeting with the employee.
 | 4.  You must administer corrective action in person with the employee.
 | 5.  Please sign the final printed report.  Retain a copy for your records.  Provide a copy to the employee and forward the orginial to Human Resources.
 | 6.  Any questions with regard to policy may be directed toward [NAME] at extension 8201.
 | [NAME]:
 | University Rules
 | Attendance & Punctuality Policy (Rule 3359-26-04)
Spreadsheet: 172211d1344026706-adding-reminders-tigeravatar-example-for-psilver1
Sheet: Bag 1

Item | Expiration Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bag 1
Item 01 | 2012-08-14 00:00:00
Item 02 | 2012-08-07 00:00:00
Item 03 | 2012-08-17 00:00:00
Item 04 | 2012-08-06 00:00:00
Item 05 | 2012-08-08 00:00:00
Item 06 | 2012-08-13 00:00:00
Item 07 | 2012-08-06 00:00:00
Item 08 | 2012-08-13 00:00:00
Item 09 | 2012-08-09 00:00:00
Item 10 | 2012-08-06 00:00:00
Item 11 | 2012-08-06 00:00:00
Item 12 | 2012-08-05 00:00:00
Item 13 | 2012-08-05 00:00:00
Item 14 | 2012-08-07 00:00:00
Item 15 | 2012-08-14 00:00:00
Item 16 | 2012-08-08 00:00:00
Item 17 | 2012-08-17 00:00:00
Item 18 | 2012-08-14 00:00:00
Item 19 | 2012-08-17 00:00:00
Item 20 | 2012-08-17 00:00:00
Spreadsheet: 768712d1645097148-count-different-type-of-text-and-give-me-text-and-sum-of-numbers-copy-of-count_something
Sheet: STATE

STATE(TERRITORY)
AL | Alabama
AK | Alaska
AZ | Arizona
AR | Arkansas
AS | American Samoa
CA | California
CO | Colorado
CT | Connecticut
DE | Delaware
DC | District of Columbia
FL | Florida
GA | Georgia
GU | Guam
HI | Hawaii
ID | Idaho
IL | Illinois
IN | Indiana
IA | Iowa
KS | Kansas
KY | Kentucky
LA | Louisiana
ME | Maine
MD | Maryland
MA | Massachusetts
MI | Michigan
MN | Minnesota
MS | Mississippi
MO | Missouri
MT | Montana
NE | Nebraska
NV | Nevada
NH | New Hampshire
NJ | New Jersey
NM | New Mexico
NY | New York
NC | North Carolina
ND | North Dakota
CM | Northern Mariana Islands
OH | Ohio
OK | Oklahoma
OR | Oregon
PA | Pennsylvania
PR | Puerto Rico
RI | Rhode Island
SC | South Carolina
SD | South Dakota
TN | Tennessee
TX | Texas
TT | Trust Territories
UT | Utah
VT | Vermont
VA | Virginia
VI | Virgin Islands
WA | Washington
WV | West Virginia
WI | Wisconsin
WY | Wyoming
Spreadsheet: 840001d1692354865-producing-a-table-from-data-on-another-sheet-within-a-specific-time-frame-test2
Sheet: Sheet2

Workload
Job Number | Status | Project Name | Current LBE | Finish | DLA | Estimating Status
10001 | Live Tender | X1 | 1000000 | 2023-04-13 00:00:00 | 2023-09-12 00:00:00 | Ready for Review
10001 | Live Tender | X2 | 1000000 | 2023-07-27 00:00:00 | 2023-08-16 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X3 | 1000000 | 2023-07-28 00:00:00 | 2023-08-17 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X4 | 1000000 | 2023-07-28 00:00:00 | 2023-08-15 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X5 | 1000000 | 2023-08-04 00:00:00 | 2023-09-07 00:00:00 | Not Started
10001 | Live Tender | X6 | 1000000 | 2023-08-11 00:00:00 | 2023-08-24 00:00:00 | In Progress
10001 | Live Tender | X7 | 1000000 | 2023-08-11 00:00:00 | 2023-08-24 00:00:00 | In Progress
Spreadsheet: 271092d1381821976-excel-formula-for-percentage-completion-my-sheet1
Sheet: Sheet1

 |  | Item | Total |  | Items started |  |  |  |  |  | Items completed |  |  |  |  |  | Items Inprogress
 |  |  |  |  | 2013-07-05 00:00:00 |  | 2013-07-12 00:00:00 |  | 2013-08-02 00:00:00 |  | 2013-08-23 00:00:00 |  | 2013-08-30 00:00:00 |  | 2013-09-06 00:00:00 |  | 2013-10-04 00:00:00 |  | 2013-10-11 00:00:00
 |  |  | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual
 |  | Pencils | 10 | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 7 | 7
 |  | Erasers | 10 | 10 | 1 | 1 | 1 | 1 | 5 | 5 | 3 | 3 | 4 | 4 | 4 | 4 | 1 | 2 | 0 | 0
 |  | pens | 27 | 27 | 13 | 13 | 14 | 14 | 19 | 19 | 15 | 15 | 16 | 16 | 16 | 16 | 0 | 0 | 0 | 0
 |  | Text books | 10 | 10 |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 2 | 2
 |  | graph sheets | 24 | 24 | 4 | 4 | 7 | 7 | 10 | 10 | 9 | 9 | 10 | 10 | 10 | 10 | 9 | 9 | 9 | 9
 |  | leads | 8 | 8 | 1 | 1 | 1 | 1 | 3 | 3 | 1 | 1 | 2 | 2 | 2 | 2 | 5 | 5 | 5 | 5
 |  | cards | 9 | 9 | 1 | 1 | 1 | 1 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  | Total | 98 | 98 | 20 | 20 | 25 | 25 | 41 | 41 | 30 | 30 | 35 | 35 | 35 | 35 | 22 | 23 | 26 | 26
 |  | [NAME]:
 |  | 1) Items completed / # forecast (total planned)=
 |  | 2) # Items started /# forecast (toatal items planned): =
 |  | 3) Actual # Items completed as per today / weeks since start of items: =
Spreadsheet: 532437d1502281237-help-with-a-formula-for-populating-a-rota-with-names-blank-template-rota
Sheet: Hours

 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Hours worked |  | MANAGER USE ONLY
2017 |  |  |  |  |  |  |  |  |  | A/L | S/L | TOIL WORKED | TOIL TAKEN
A | 7.30-10 |  | W | W |  | W | W
B | W | 7.30-10 | W | W | W
C |  | W | W | W |  | W | W
D | 7.30-10 | W | W |  |  | W | W
[NAME] | 2-10.30 | W | W | W | W
F | W | W |  |  | W | W | W
G | 4-9 | W |  | W | W | W
H | N | N | N | N
 | 10 | 10 | 10 | 10
I |  | W | W |  | W | W
J | W | W | W |  |  | W | W
K | W | W | W | W | W
L |  |  | W | W | W | W | W
1 (35) | W | W | W |  |  | W | W
2 (35) | W | W | W | W |  |  | W
3 (35) |  | W | W | W | W | W
4 (35) | W | W | W | W | W
M
N
O
P
Q
R
S
T
U
V
W
Spreadsheet: 858139d1706889245-how-to-stop-count-once-a-certain-value-has-been-reached-example-result-2-personas-under-6-payments-aligw
Sheet: Example

Persona ID | Period | Absent | Pay
1234 | [NAME] | 1 | 324
12345 | [NAME] | 0 | 0
1234 | Feb20 | 1 | 5324
12345 | Feb20 | 0 | 0
1234 | Mar20 | 1 | 4234
12345 | Mar20 | 0 | 0
1234 | Apr20 | 1 | 234234
12345 | Apr20 | 0 | 0
1234 | May20 | 1 | 543543
12345 | May20 | 0 | 0
1234 | Jun20 | 1 | 2354
12345 | Jun20 | 0 | 0
1234 | Jul20 | 1 | 0
12345 | Jul20 | 0 | 0
1234 | Aug20 | 1 | 0
12345 | Aug20 | 0 | 0
1234 | Sep20 | 0 | 0
12345 | Sep20 | 0 | 645
1234 | Oct20 | 0 | 0
12345 | Oct20 | 0 | 0
1234 | Nov20 | 0 | 0
12345 | Nov20 | 0 | 0
1234 | Dec20 | 0 | 0
12345 | Dec20 | 0 | 534
1234 | Jan21 | 1 | 0
12345 | Jan21 | 0 | 4
1234 | Feb21 | 1 | 0
12345 | Feb21 | 0 | 5634
1234 | Mar21 | 0 | 0
12345 | Mar21 | 0 | 7645
1234 | Apr21 | 0 | 0
12345 | Apr21 | 0 | 0
1234 | May21 | 0 | 0
12345 | May21 | 0 | 0
1234 | Jun21 | 1 | 0
12345 | Jun21 | 0 | 0
1234 | [NAME] | 0 | 0
12345 | [NAME] | 1 | 6534
1234 | Aug21 | 1 | 0
12345 | Aug21 | 1 | 5465
1234 | Sep21 | 0 | 0
12345 | Sep21 | 1 | 6354
1234 | Oct21 | 0 | 654
12345 | Oct21 | 1 | 0
1234 | Nov21 | 0 | 6534
12345 | Nov21 | 1 | 6534
1234 | Dec21 | 0 | 0
12345 | Dec21 | 1 | 6435
1234 | [NAME] | 0 | 0
12345 | [NAME] | 1 | 6534
1234 | Feb22 | 0 | 0
12345 | Feb22 | 0 | 456
1234 | Mar22 | 0 | 0
12345 | Mar22 | 0 | 5436
1234 | Apr22 | 0 | 0
12345 | Apr22 | 0 | 543
1234 | May22 | 0 | 0
12345 | May22 | 0 | 765
1234 | [NAME] | 0 | 0
12345 | [NAME] | 0 | 0
1234 | [NAME] | 1 | 0
12345 | [NAME] | 0 | 0
1234 | Aug22 | 1 | 0
12345 | Aug22 | 1 | 54
1234 | Sep22 | 1 | 543
12345 | Sep22 | 1 | 543
1234 | Oct22 | 1 | 432
12345 | Oct22 | 1 | 543
1234 | Nov22 | 1 | 4234
12345 | Nov22 | 1 | 543
1234 | Dec22 | 1 | 5435
12345 | Dec22 | 1 | 4532
Persona ID | Result | AliGW | AliGW (again)
1234 | Under 6 payments
12345
Spreadsheet: 801252d1666144169-sorting-of-rows-belonging-to-one-of-four-hierarchical-levels-sorting-of-four-levels2
Sheet: Sample data

Start table (randomly sorted) |  |  | Desired result |  |  | Solution
Parent level | Level |  | Parent level | Level |  | Grand-grand-grandparent level of row | Grand-grandparent level of row | Grandparent level of row | Parent level of row | Child level of row | Column1 | 1st generation | 2nd generation | 3rd generation | 4th generation | 5th generation | Column2 | Parent level | Child level
A.01 | B.01 |  |  | A.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A.01
A.01 | B.02 |  | A.01 | B.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | A.01 | B.01
B.01 | C.01 |  | B.01 | C.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | B.01 | C.01
B.01 | C.02 |  | C.01 | D.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | C.01 | D.01
B.01 | C.03 |  | C.01 | D.02 |  |  |  |  |  |  |  |  |  |  |  |  |  | C.01 | D.02
B.02 | [NAME] |  | B.01 | C.02 |  |  |  |  |  |  |  |  |  |  |  |  |  | B.01 | C.02
B.02 | [NAME] |  | C.02 | D.03 |  |  |  |  |  |  |  |  |  |  |  |  |  | C.02 | D.03
B.02 | C.06 |  | C.02 | D.04 |  |  |  |  |  |  |  |  |  |  |  |  |  | C.02 | D.04
C.01 | D.01 |  | B.01 | C.03 |  |  |  |  |  |  |  |  |  |  |  |  |  | B.01 | C.03
C.01 | D.02 |  | C.03 | D.05 |  |  |  |  |  |  |  |  |  |  |  |  |  | C.03 | D.05
C.02 | D.03 |  | C.03 | D.06 |  |  |  |  |  |  |  |  |  |  |  |  |  | C.03 | D.06
C.02 | D.04 |  | A.01 | B.02 |  |  |  |  |  |  |  |  |  |  |  |  |  | A.01 | B.02
C.03 | D.05 |  | B.02 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | B.02 | [NAME]
C.03 | D.06 |  | [NAME] | D.07 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | D.07
[NAME] | D.07 |  | [NAME] | D.08 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | D.08
[NAME] | D.08 |  | B.02 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | B.02 | [NAME]
[NAME] | D.09 |  | [NAME] | D.09 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | D.09
[NAME] | D.10 |  | [NAME] | D.10 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | D.10
C.06 | D.11 |  | B.02 | C.06 |  |  |  |  |  |  |  |  |  |  |  |  |  | B.02 | C.06
C.06 | [NAME] |  | C.06 | D.11 |  |  |  |  |  |  |  |  |  |  |  |  |  | C.06 | D.11
 | A.01 |  | C.06 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | C.06 | [NAME]
 |  |  | Level | Letter in example
 |  |  | Level 1 | A
 |  |  | Level 2 | B
 |  |  | Level 3 | C
 |  |  | Level 4 | D
Spreadsheet: a9503bd6-2a62-402b-9d3d-4353fb740ecd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4355 | 13651 | Martin | Falch | AUT | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:40:33
4355 | 22817 | [NAME] | Basilio | POR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 03:00:55
Spreadsheet: 472217d1469488257-is-there-a-formula-that-can-help-adjust-a-budgeted-allocation-cumulative-spend
Sheet: Budget by month

 | start date |  | 2017-08-01 00:00:00
 | Number of months |  | 22
 | Total Budget |  | 1234567
 |  | Spend | Cumulative spend
1
Spreadsheet: 213348d1360453096-data-validation-question-dynamic-validation-lists
Sheet: Sheet2

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME]
H1_Item 1 | H2_Item 1 | H3_Item 1 | H4_Item 1 | H5_Item 1 | H6_Item 1 | H7_Item 1
H1_Item 2 | H2_Item 2 | H3_Item 2 | H4_Item 2 | H5_Item 2 | H6_Item 2 | H7_Item 2
H1_Item 3 | H2_Item 3 | H3_Item 3 | H4_Item 3 | H5_Item 3 | H6_Item 3 | H7_Item 3
H1_Item 4 | H2_Item 4 | H3_Item 4 | H4_Item 4 | H5_Item 4 | H6_Item 4 | H7_Item 4
H1_Item 5 | H2_Item 5 |  | H4_Item 5 | H5_Item 5 | H6_Item 5
 | H2_Item 6 |  | H4_Item 6 |  | H6_Item 6
 | H2_Item 7 |  | H4_Item 7 |  | H6_Item 7
 |  |  | H4_Item 8 |  | H6_Item 8
 |  |  | H4_Item 9
Spreadsheet: 34534d1231842446-vlook-up-for-finding-2-same-items-vlookup-querry-cc
Sheet: Sheet2

 |  |  |  | box a | Number of boxes | final list | final number |  | box a | Number of boxes
 |  |  |  | 58 | 6 | 17 | 36 |  | 17 | 4
 |  |  |  | 57 | 2 | 18 | 2 |  |  | 36
 |  |  |  | 78 | 9 | 19 | 29 |  | 18 | 2
 |  |  |  | 77 | 16 | 28 | 60 |  |  | 5
 |  |  |  | 76 | 18 | 29 | 29 |  |  | 12
 |  |  |  | 67 | 49 | 30 | 48 |  | 19 | 9
 |  |  |  | 66 | 6 | 31 | 13 |  |  | 29
 |  |  |  | 57 | 8 | 40 | 27 |  | 28 | 60
 |  |  |  | 56 | 13 | 41 | 37 |  | 29 | 29
 |  |  |  | 55 | 15 | 42 | 10 |  |  | 33
 |  |  |  | 46 | 11 | 45 | 6 |  | 30 | 48
 |  |  |  | 45 | 6 | 46 | 11 |  | 31 | 13
 |  |  |  | 75 | 14 | 50 | 1 |  | 40 | 27
 |  |  |  | 74 | 2 | 51 | 5 |  | 41 | 37
 |  |  |  | 65 | 2 | 54 | 2 |  |  | 50
 |  |  |  | 64 | 9 | 55 | 15 |  | 42 | 10
 |  |  |  | 56 | 23 | 56 | 13 |  | 45 | 6
 |  |  |  | 55 | 41 | 57 | 2 |  | 46 | 11
 |  |  |  | 54 | 2 | 58 | 6 |  | 50 | 1
 |  |  |  | 19 | 29 | 64 | 9 |  | 51 | 5
 |  |  |  | 18 | 2 | 65 | 2 |  | 54 | 2
 |  |  |  | 51 | 5 | 66 | 6 |  | 55 | 15
 |  |  |  | 42 | 10 | 67 | 49 |  |  | 41
 |  |  |  | 41 | 37 | 74 | 2 |  | 56 | 13
 |  |  |  | 31 | 13 | 75 | 14 |  |  | 23
 |  |  |  | 30 | 48 | 76 | 18 |  | 57 | 2
 |  |  |  | 29 | 29 | 77 | 16 |  |  | 8
 |  |  |  | 19 | 9 | 78 | 9 |  | 58 | 6
 |  |  |  | 18 | 2 |  |  |  | 64 | 9
 |  |  |  | 18 | 12 |  |  |  | 65 | 2
 |  |  |  | 17 | 36 |  |  |  | 66 | 6
 |  |  |  | 51 | 5 |  |  |  | 67 | 49
 |  |  |  | 50 | 1 |  |  |  | 74 | 2
 |  |  |  | 41 | 50 |  |  |  | 75 | 14
 |  |  |  | 40 | 27 |  |  |  | 76 | 18
 |  |  |  | 29 | 33 |  |  |  | 77 | 16
 |  |  |  | 28 | 60 |  |  |  | 78 | 9
 |  |  |  | 18 | 5 |  |  |  | (blank) | 669
 |  |  |  | 17 | 4 |  |  |  | Grand Total
 |  |  |  |  | 669