tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 881547d1729624424-help-automating-dates-and-data-across-multiple-sheets-excel-2016-test-attendance-calendar
Sheet: 2025

 | 2 |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 2
22 |  |  | 2025 |  |  |  |  |  |  |  | 18
16 |  |  | [NAME] |  |  |  |  |  |  |  | 14
16 |  |  |  |  |  |  |  |  |  |  | 10.5
15 |  | JAN | JANUARY |  |  |  |  |  |  |  | 12
12 |  |  | S | M | T | W | T | F | S |  | 10
1900-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1900-01-10 00:00:00
8 |  | A2
9 |  |  |  |  |  |  |  |  |  |  | 9
10 |  | C-CSS3
9 |  |  |  |  |  |  |  |  |  |  | 9
10 |  | W-LT3
9 |  |  |  |  |  |  |  |  |  |  | 9
1900-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1900-01-10 00:00:00
8
9 |  |  |  |  |  |  |  |  |  |  | 9
10
9 |  |  |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e9 FORMULA
9 |  |  |  |  |  |  |  |  |  |  | 9
1900-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1900-01-10 00:00:00
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | E8="",(TRANSPOSE(D9)),
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (IF((D9)="B1","B2",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="B2","A1",
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="A1","A2",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="A2","B3",
1900-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1900-01-10 00:00:00 |  |  |  |  |  |  |  | IF((D9)="B3","B4",
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="B4","A3",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="A3","A4",
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="A4","A5",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="A5","B5",
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="A5","B5",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="B5","B6",
1900-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1900-01-10 00:00:00 |  |  |  |  |  |  |  | IF((D9)="B6","A6",
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="A6","A7",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="A7","B7",
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="B7","B8",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="B8","B9",
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="B9","A8",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="A8","A9",
1900-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1900-01-10 00:00:00 |  |  |  |  |  |  |  | IF((D9)="A9","B10",
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="B10","B11",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="B11","A10",
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="A10","A11",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="A11","A12",
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF((D9)="A12","B12",
9 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | IF((D9)="B12","B13",
Spreadsheet: 467271d1466629708-range-formula-help-needed-copy-of-book6
Sheet: Sheet1

Frame Family | Pole | Motor Type | HP Family | Median of  Total Hours (based on spec.) | Count of Order# | Average of Median
500 | 2-Pole | [NAME] | 700 | 1.307 | 1 | 1.307
 |  |  |  | 1.7945 | 2 | 1.7945
 |  |  |  | 2.127 | 1 | 2.127
 |  |  |  | 2.708 | 1 | 2.708
 |  | Vented Core | 700 | 1.1765 | 2 | 1.1765
 |  |  |  | 1.641 | 3 | 1.641
 |  |  |  | 1.744 | 2 | 1.744
 |  |  |  | 2.668 | 6 | 2.668
 |  |  |  | 6.559 | 3 | 6.559
 |  |  | 1250 | 2.297 | 2 | 2.297
 |  |  |  | 2.471 | 1 | 2.471
 |  |  |  | 2.616 | 6 | 2.616
 |  |  |  | 6.093 | 3 | 6.093
 | 4-Pole | Vented Core | 700 | 0.603 | 2 | 0.603
 |  |  |  | 1.3755 | 2 | 1.3755
 |  |  |  | 3.598 | 3 | 3.598
 |  |  |  | 5.116 | 1 | 5.116
 | 6-Pole | Vented Core | 700 | 2.678 | 1 | 2.678
 |  |  |  | 3.85 | 1 | 3.85
 | 8-Pole | Vented Core | 700 | 1.551 | 1 | 1.551
580 | 10-Pole | Vented Core | 700 | 2.77 | 1 | 2.77
 | 2-Pole | [NAME] | 700 | 0.585 | 1 | 0.585
 |  |  |  | 1.49 | 1 | 1.49
 |  |  |  | 1.7855 | 2 | 1.7855
 |  |  |  | 1.83 | 1 | 1.83
 |  |  |  | 2.251 | 1 | 2.251
 |  |  | 1250 | 0.923 | 1 | 0.923
 |  | Vented Core | 700 | 0.939 | 1 | 0.939
 |  |  |  | 1.605 | 1 | 1.605
 |  |  | 1250 | 0.579 | 1 | 0.579
 |  |  |  | 0.772 | 3 | 0.7719999999999999
 |  |  |  | 3.059 | 1 | 3.059
 |  |  |  | 6.2645 | 2 | 6.2645
 |  |  | 3000 | 1.074 | 4 | 1.074
 |  |  |  | 1.453 | 3 | 1.453
 |  |  |  | 1.551 | 15 | 1.550999999999999
 |  |  |  | 2.101 | 11 | 2.101
 |  |  |  | 2.341 | 3 | 2.341
 |  |  |  | 2.537 | 6 | 2.536999999999999
 | 4-Pole | Vented Core | 700 | 1.324 | 1 | 1.324
 |  |  | 1250 | 2.629 | 1 | 2.629
 |  |  |  | 4.409000000000001 | 1 | 4.409000000000001
 |  |  | 3000 | 2.141 | 1 | 2.141
 |  |  |  | 2.467 | 1 | 2.467
 | 6-Pole | Vented Core | 700 | 2.3305 | 2 | 2.3305
 |  |  | 1250 | 1.234 | 1 | 1.234
 |  |  |  | 2.205 | 1 | 2.205
 |  |  |  | 2.407 | 2 | 2.407
 |  |  | 3000 | 2.445 | 1 | 2.445
 | 8-Pole | Vented Core | 700 | 6.596 | 1 | 6.596
 |  |  | 1250 | 3.637 | 1 | 3.637
630 | 4-Pole | Vented Core | 18000 | 3.034 | 1 | 3.034
 |  |  |  | 3.873 | 1 | 3.873
680 | 2-Pole | Vented Core | 700 | 1.117 | 1 | 1.117
 |  |  | 3000 | 0.969 | 1 | 0.969
 |  |  |  | 1.396 | 1 | 1.396
 |  |  |  | 1.566 | 2 | 1.566
 |  |  |  | 2.694 | 1 | 2.694
 |  |  |  | 2.999 | 1 | 2.999
 |  |  | 18000 | 2.364 | 1 | 2.364
 |  |  |  | 4.645 | 1 | 4.645
 | 6-Pole | Vented Core | 3000 | 3.6485 | 4 | 3.6485
 | 8-Pole | Vented Core | 3000 | 6.182 | 1 | 6.182
710 | 12-Pole | Vented Core | 18000 | 0.663 | 1 | 0.663
800 | 2-Pole | Vented Core | 3000 | 2.227 | 3 | 2.227
 |  |  | 18000 | 3.179 | 1 | 3.179
 |  |  |  | 3.197 | 1 | 3.197
 |  |  |  | 3.44 | 1 | 3.44
 | 4-Pole | Vented Core | 18000 | 3.039 | 1 | 3.039
 |  |  |  | 3.821 | 1 | 3.821
 | 8-Pole | Vented Core | 3000 | 2.564 | 2 | 2.564
 |  |  |  | 11.804 | 1 | 11.804
Spreadsheet: 137322d1327062814-sumifs-duplicate-criteria-range-query-sumifs-funny
Sheet: Sheet1

Month | Days of Rain |  | Season | Month |  |  | Select Month/Season
January | 20 |  | Winter | November |  |  | December |  | If I select "Winter" from drop down the sumifs function doesn't seem to work….
February | 18 |  |  | December |  |  |  |  | I'm assuming this is something to do with the criteria ranges being the same??
March | 18 |  |  | January |  |  | Days of Rain
April | 13 |  |  | February
May | 12 |  | Spring | March
June | 18 |  |  | April
July | 8 |  |  | May
August | 12 |  | Summer | June
September | 10 |  |  | July
October | 15 |  |  | August
November | 17 |  | Autumn | September
December | 13 |  |  | October
Winter
Spreadsheet: 676977d1589124034-combine-different-formula-in-one-pq-filtered-unique-list-aligw
Sheet: RAMS

Column1 | step 1 | step 2 | step3 | step 4 |  | Step 4 Results
Crucial 16GB DDR4-2400 SODIMM |  |  |  |  |  | Crucial 16GB DDR4-2400 SODIMM
Crucial 8GB DDR4-3200 SODIMM |  |  |  |  |  | Crucial 8GB DDR4-3200 SODIMM
Crucial 16GB DDR4-3200 SODIMM |  |  |  |  |  | Crucial 16GB DDR4-3200 SODIMM
Crucial 4GB DDR4-2400 SODIMM |  |  |  |  |  | Crucial 4GB DDR4-2400 SODIMM
Crucial 4GB DDR4-3200 SODIMM |  |  |  |  |  | Crucial 4GB DDR4-3200 SODIMM
Crucial 4GB DDR4-2666 SODIMM |  |  |  |  |  | Crucial 4GB DDR4-2666 SODIMM
Crucial 32[NAME] (2 x 16GB) DDR4-2666 SODIMM
[NAME] • CL=17 • Dual Ranked • x8 based • Unbuffered • NON-ECC • DDR4-2400 • 1.2V • 2048Meg x 64 •
Crucial 16GB DDR4-2400 SODIMM
Crucial 16[NAME] (2 x 8GB) DDR4-2666 SODIMM
Crucial 8GB DDR4-3200 SODIMM
Crucial 16[NAME] (2 x 8GB) DDR4-3200 SODIMM
step 1 | get value if Column A contains "Crucial" and "DDR" but exclude "KIT".
step 2 | get all the data of column B removing all blanks
step 3 | remove the duplicate of column C.
step 4 | get all the data of column D removing all blanks
Spreadsheet: 121040d1315797268-read-another-sheet-nfl-football-schedule-2011-2012
Sheet: Week 11

Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New York Jets
Denver Broncos
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Tampa Bay Buccaneers
Green Bay Packers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Carolina Panthers
Detroit Lions
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
[NAME]
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Tennessee Titans
Atlanta Falcons
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Oakland Raiders
Minnesota Vikings
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Buffalo Bills
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Dallas Cowboys
Washington Redskins
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Cincinnati Bengals
Baltimore Ravens
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Arizona Cardinals
San Francisco 49ers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
[NAME]
St. Louis Rams
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
San Diego Chargers
Chicago Bears
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Philadelphia Eagles
New York Giants
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Kansas City Chiefs
New England Patriots
Teams on Bye
Indianapolis Colts
New Orleans Saints
Pittsburgh Steelers
Houston Texans
Spreadsheet: 92220865-ed77-487b-96dc-e9baeb9d3ccc
Sheet: V

Car Make/Model/Year | Volume Number
Vauxhall (British)
1930 | 248 (+) no. 2
[NAME]
1911 | 45 (+) no. 6
1918; 1919---repair manual; 1920—repair manual | 120 (+) no. 3, 5, 6
1920---repair manual & parts list | 191 no. 19
1921 | 226 no. 7
1922---repair manual | 120 no. 7
1922---repair manual & parts list | 191 no. 20
Victor. Overman Auto Co.
1901 | 52 no. 20
Viking. Olds Motor Works
1930 | 245 (+) no. 10
Vinot. Vinot Cars Limited (London)
1912 | 42 no. 1
Vogue
1920---parts list | 119 no. 3
1921 | 121 (+) no. 2
Spreadsheet: 466358d1466148365-holiday-nigh-shift-time-sheet-computation-sample-632016
Sheet: Sheet1

ACCOUNT | EMPLOYEE # | EMPLOYEE NAME | BASIC SALARY | HOURLY RATE | FIXED ALLOWANCE
CUTOFF
2016-01-01 00:00:00
START DATE | END DATE | SCHEDULE |  | TIME IN | TIME OUT | REMARKS |  | LATE MINUTES | UNDERTIME | #DAYS RWD | RWD HRS | RWD ND HRS | REG OT | REG OT ND | RDOT | RDOT ND | RDOT EX | RDLHOT | RDLHOTND | RDLHOT EX
Spreadsheet: 794325d1661979498-forecast-a-date-when-average-value-reaches-a-known-value-in-excel-projected-fleet-renewal-with-average-kms
Sheet: Sheet1

 |  |  | MM/DD/YY |  |  |  |  | 805000
Unit # | Year | Make | In-Service Date | Warranty Start Date | Warranty End Date | Current Odometer | Average Monthly KM's | Projected replacement @ 805,000kms
101 | 2021 | Western Star | 2020-12-01 00:00:00 |  |  | 302037
102 | 2021 | Western Star | 2020-12-10 00:00:00 |  |  | 372465
103 | 2021 | Western Star | 2021-12-21 00:00:00 |  |  | 363834
105 | 2021 | Western Star | 2021-01-05 00:00:00 |  |  | 432624
106 | 2021 | Western Star | 2021-01-05 00:00:00 |  |  | 388879
107 | 2021 | Western Star | 2021-10-16 00:00:00 |  |  | 223169
108 | 2022 | Freightliner | 2021-10-30 00:00:00 |  |  | 317280
109 | 2022 | Freightliner | 2021-11-02 00:00:00 |  |  | 221415
110 | 2022 | Freightliner | 2022-01-10 00:00:00 |  |  | 155314
111 | 2022 | Freightliner | 2022-01-10 00:00:00 |  |  | 184565
112 | 2022 | Freightliner | 2022-01-14 00:00:00 |  |  | 164971
113 | 2022 | Mack | 2022-01-26 00:00:00 |  |  | 143381 |  | `
114 | 2022 | Freightliner | 2022-01-25 00:00:00 |  |  | 172808
115 | 2022 | Freightliner | 2022-01-26 00:00:00 |  |  | 176711
116 | 2022 | Freightliner | 2022-02-08 00:00:00 |  |  | 240597
117 | 2022 | Freightliner | 2022-02-13 00:00:00 |  |  | 133578
118 | 2022 | Western Star | 2022-03-07 00:00:00 |  |  | 50993
119 | 2022 | Western Star | 2022-03-07 00:00:00 |  |  | 92322
Spreadsheet: 96616d1295978180-skip-weekend-days-on-production-roster-roster
Sheet: What I want it to do.

 | FFS Operator
 | Manual Operator
 | [NAME]
 | [NAME] (FFS Assist,  Forkhoist)
 | Office, Loading
 | 2nd Shift FFS Operator
 | 2nd [NAME] (FFS Assist,  Forkhoist)
 | 2nd Shift Manual Operator
 |  | 38000 | 38000 |  |  |  |  |  |  |  |  |  |  |  |  | 20900 | 20900
 |  | 5500 | 5500 |  |  |  |  |  | 3250 | 3250
 | Days for Production
 |  |  | hrs per day | target | bgs per day
 | Production Hours |  | 9 | 190
 |  |  | 9 | 50
 |  |  | 9 | 3
 |  |  |  |  |  |  |  |  |  |  | FFS Operator | Kalanga
 |  |  |  |  |  |  |  |  |  |  | Manual/Bulk Bags | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Forklift/Floater | Paea/Colin
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Temp
 |  |  |  |  |  |  |  |  |  |  | Office | Paea/Colin
 |  |  |  |  |  |  |  |  |  |  | PGTS | [NAME]
 |  |  |  |  |  |  |  |  |  |  | PGTS | Temp
Spreadsheet: 1820fc93-5deb-49ce-a748-a53673ebd4ff
Sheet: Sheet1

Adults 18 Year and Over Who received Some Type of Dental Care in the Past Year, by Race, Ethnicity, and Sexual Orientation, Maine, 2006, 2008, 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 |  | Yes |  |  |  |  |  |  | No
 |  | Unweighted Number |  | Weighted Number |  | % | LCL | UCL | Unweighted Number |  | Weighted Number |  | % | LCL | UCL
Race and Ethnicity
 | American Indian or Alaskan Native, non-Hispanic | 77 |  | 15999 |  | 55.28229999999999 | 45.517128 | 65.04754 | 78 |  | 12941 |  | 44.7177 | 34.95246 | 54.48287200000001
 | Black only, non-Hispanic | DNR |  | DNR |  | DNR | DNR | DNR | DNR |  | DNR |  | DNR | DNR | DNR
 | Hispanic | 126 |  | 24396 |  | 64.9502 | 55.736656 | 74.16381 | 63 |  | 13165 |  | 35.0498 | 25.83619 | 44.263344
 | Multiracial, non-Hispanic | 93 |  | 15992 |  | 59.3805 | 49.93047199999999 | 68.83046 | 75 |  | 10939 |  | 40.6195 | 31.16954 | 50.069528
 | Other race, non-Hispanic | DNR |  | DNR |  | DNR | DNR | DNR | DNR |  | DNR |  | DNR | DNR | DNR
 | White only, non-Hispanic | 12605 |  | 2072891 |  | 69.7149 | 68.786587 | 70.643142 | 5437 |  | 900494 |  | 30.2851 | 29.356858 | 31.213413
Sexual Orientation
 | Heterosexual or straight | 12552 |  | 2084227 |  | 69.4813 | 68.552816 | 70.409688 | 5470 |  | 915470 |  | 30.5187 | 29.590312 | 31.447184
 | Homosexual or gay or lesbian | 183 |  | 27934 |  | 67.2176 | 58.667329 | 75.76783999999999 | 78 |  | 13623 |  | 32.7824 | 24.23216 | 41.332671
 | Bisexual | DNR |  | DNR |  | DNR | DNR | DNR | DNR |  | DNR |  | DNR | DNR | DNR
 | Other | DNR |  | DNR |  | DNR | DNR | DNR | DNR |  | DNR |  | DNR | DNR | DNR
Data Source: Behavioral Risk Factor Surveillance System Includes visits to a dental helath provider for any reason  %= Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage
DNR: Data note reliable. Data are not shown if the unweighted sample size for the denominator was < 50 or the Confidence Interval half-width was > 10, as they do not meet standards for statistical reliability.
Spreadsheet: 792244d1660808452-find-detail-value-according-to-customer-code-find-detail-value-according-to-customer-code-fix
Sheet: Sheet1

Time | Invoice | Customer code | Name | Product |  | Result
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | Bánh quy |  |  |  | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 8 | 8 | 8 | 9 | 9 | 9
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] |  | Customer code | Name | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] socola |  | [NAME] | [NAME] | [NAME] | 3 | 8 | A03100 | 4 | 8 | A04100 | 3 | 16 | A06100 | 6 | 37 | A01200 | 1 | 10 | A02200 | 1 | 1 | A03200 | 1 | 10 | A12200 | 1 | 1 | A15200 | 1 | 10
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa | [NAME] ngọt |  | KH009 | Anh Hòa | A09100 | 3 | 7 | A05100 | 2 | 13 | A11200 | 1 | 10 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa | Bánh sữa
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa | [NAME]
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | [NAME] ngọt
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | [NAME] socola
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh láng
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | [NAME] ngọt
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | [NAME]
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | Bánh nhân
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa | Bánh nhân
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa | Bánh sữa
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa | Bánh sữa
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh quy
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh quy
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | [NAME] ngọt
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | [NAME] ngọt
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh dứa
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh nhân
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh chíp
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh bông lan
2022-02-01 00:00:00 | A01200 | [NAME] | [NAME] | Bánh gối
2022-02-02 00:00:00 | A02200 | [NAME] | [NAME] | [NAME] ngọt
2022-02-03 00:00:00 | A03200 | [NAME] | [NAME] | Bánh sữa
2022-02-05 00:00:00 | A11200 | KH009 | Anh Hòa | Bánh côcla
2022-02-12 00:00:00 | A12200 | [NAME] | [NAME] | [NAME] ngọt
2022-02-15 00:00:00 | A15200 | [NAME] | [NAME] | Bánh sữa
Spreadsheet: 867266d1714117365-complex-transpose-problem-transpose-wip-aligw
Sheet: Sheet1

Item | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 10
aaa | 10 | 9 | 8 |  |  |  |  |  |  | aaa | 9
bbb | 15 |  |  |  |  |  |  |  |  | aaa | 8
[NAME] | 20 | 18 | 16 | 15 | 14 |  |  |  |  | aaa
ddd | 10 | 8 | 6 | 5 | 4 |  |  |  |  | aaa
eee | 30 | 25 | 22 |  |  |  |  |  |  | bbb | 15
 |  |  |  |  |  |  |  |  |  | bbb
 |  |  |  |  |  |  |  |  |  | bbb
 |  |  |  |  |  |  |  |  |  | bbb
 |  |  |  |  |  |  |  |  |  | bbb
 |  |  |  |  |  |  |  |  |  | [NAME] | 20
 |  |  |  |  |  |  |  |  |  | [NAME] | 18
 |  |  |  |  |  |  |  |  |  | [NAME] | 16
 |  |  |  |  |  |  |  |  |  | [NAME] | 15
 |  |  |  |  |  |  |  |  |  | [NAME] | 14
 |  |  |  |  |  |  |  |  |  | ddd | 10
 |  |  |  |  |  |  |  |  |  | ddd | 8
 |  |  |  |  |  |  |  |  |  | ddd | 6
 |  |  |  |  |  |  |  |  |  | ddd | 5
 |  |  |  |  |  |  |  |  |  | ddd | 4
 |  |  |  |  |  |  |  |  |  | eee | 30
 |  |  |  |  |  |  |  |  |  | eee | 25
 |  |  |  |  |  |  |  |  |  | eee | 22
 |  |  |  |  |  |  |  |  |  | eee
 |  |  |  |  |  |  |  |  |  | eee
Spreadsheet: 135323d1325935086-display-annual-leave-dates-by-employee-2012-staff-planner-test
Sheet: PLANNER 

ID | First name | Department |  | Leave Is Tracked As | Annual Leave Total Entitlement | Annual Leave taken |  | [NAME] As | [NAME] days | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F
 |  |  |  |  |  |  | Remaining Annual Leave |  |  | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00
1 | sean | 0 |  | Days | 25 | 0 | 25 | Days | 0 |  |  |  |  |  |  |  |  |  | hh | hh | h
2 | [NAME] | 0 |  | Days | 25 | 0 | 25 | Days | 0 | h |  | h |  | h | h | h | h | h
3 | [NAME] | 0 |  | Days | 25 | 0 | 25 | Days | 0
4 | wayne | 0 |  | Days | 34 | 19 | 15 | Days | 0 | h | h | h | h | h | h |  |  | h | h | h | h
5 | bob | 0 |  | Days | 25 | 0 | 25 | Days | 0
6 | [NAME] | 0 |  | Days | 34 | 0 | 34 | Days | 0
7 | Mark | 0 |  | Days | 34 | 0 | 34 | Days | 0 |  |  | hh |  |  | h |  |  |  | hh |  |  |  | hh
8 | [NAME] | 0 |  | Days | 34 | 0 | 34 | Days | 0
9 | [NAME] | 0 |  | Days | 34 | 0 | 34 | Days | 0 |  |  |  | h | h |  | h |  |  | h | h
10 | [NAME] | 0 |  | Days | 34 | 0 | 34 | Days | 0
11 | Stuart | 0 |  | Days | 25 | 0 | 25 | Days | 0 |  |  |  |  |  |  | h | h | h | h | hh | h
12 | [NAME] | 0 |  | Days | 25 | 0 | 25 | Days | 0 |  |  |  | h
13 | [NAME] | 0 |  | Days | 25 | 0 | 25 | Days | 0
14 | [NAME] | 0 |  | Days | 34 | 0 | 34 | Days | 0 |  |  |  |  |  | h |  |  | hh |  |  | h
15 | Reece | 0 |  | Days | 34 | 0 | 34 | Days | 0
16 | Stand | 0 |  | Days | 34 | 0 | 34 | Days | 0
 | enter id no |  |  | dates booked
Spreadsheet: 718572d1613207641-adding-cells-except-blanks-journey-logtesting
Sheet: Sheet1

 | Date:
 | Aircraft Registration
 | Pilot in Command
 | FROM | TO | OFF BLOCK | TAKE OFF | LAND | ON BLOCK | End HOBBS | # of Landings | # of Starts | Flight Conditions | Diversion Miles
 |  |  |  |  |  |  | 4 days, 4:00:00 |  |  |  | WX | ATC
 |  |  |  | 11:30:00 | 12:30:00
 |  |  |  | 09:00:00 | 16:00:00
 |  |  |  | 07:30:00 | 19:45:00
 |  |  |  | 10:00:00 | 15:00:00
 |  |  |  |  |  | Totals
 | Trend Data
 | Torque | ITT | Np | Ng | Wf | Oil PSI | Oil Temp | OAT | PA | IAS
 | Note:
Spreadsheet: 136114d1326410952-text-data-manipulation-from-different-dumps-text-data-manipulation
Sheet: Sheet1

[NAME] we receive data | Personnel Number |  |  | Personnel_Number
[NAME] | 333 |  |  | Smith_0333
[NAME] | 1234 |  |  | UmberGreen_1234
[NAME] | 5678 |  |  | Grey_5678
All in One |  |  |  | in_One
[NAME] 0333 |  |  |  | Smith_0333
[NAME] 1234 |  |  |  | UmberGreen_1234
[NAME] 5678 |  |  |  | Grey_5678
Forename | Middle | Surname | Personnel Number | Personnel_Number
[NAME] |  | Smith | 333 | Smith_0333
[NAME] |  | Umber-Green | 1234 | UmberGreen_1234
[NAME] | R | Grey | 5678 | Grey_5678
Spreadsheet: 716061d1612005537-google-sheets-trying-to-make-a-matrix-with-1-and-0-based-on-3-different-tabs-in-the-sheet-vh-test-matrix-1-
Sheet: Customer-Quality

Customer A | Customer B | Customer C | Customer D | Customer E | Customer F | Customer G | Customer H | Customer I | Customer J
20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 70
51 | 51 | 51 | 51 | 51 | 51 | 51 | 51 | 71
52 | 52 | 52 | 52 | 52 | 52 | 52 | 52
53 | 53 | 53 | 53 | 53 | 53 | 53 | 53
54 | 54 | 54 | 54 | 54 | 54 | 54 | 54
70 | 70 | 70 | 70 |  | 70
71 | 71 | 71 | 71 |  | 71
Spreadsheet: 833638d1687164704-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-cf-updated-fvf-weight-tracker-2023-1-aligw-
Sheet: Data Sheet

Week Date | 2023-06-18 00:00:00
 |  |  |  |  | Current |  |  |  | Peak | Additional Goals Entry
Name | Team | Starting Weight | Starting Height | Starting BMI | Weekly Result (+/-) | Weekly BMI | Overall (+/-) | Overall %age Lost | Peak %age Lost | Hat-Trick | Tracked Food? | POTW | Milestone Hit? | [NAME] (1st week)? | [NAME]? | Lost Weight? | Individual Goals For/Against | 2023-05-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | POTW awarded | (enter Y if Peak passes 5/10/15% on weigh in) | Between 18.5 and 24.9 |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
[NAME] | White | 129 | 180 |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 130 | 130 | 130 | 129.2 | 127.9 | 127.2