tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 49937d1249369417-working-out-hours-between-days-copy-of-sh5
Sheet: SH5

 |  |  |  |  | SH 5-1
DATE | TIME | HOURS | WATER DROP | OVER ALL  HOURS | OVER ALL WATER DROP
2009-07-06 00:00:00 | 10:00:00 | - | - | -
2009-07-08 00:00:00 | 07:00:00 | 3 | 170 |  | 170
2009-07-09 00:00:00 | 07:00:00 |  | 70 |  | 240
2009-07-10 00:00:00 | 07:00:00 |  | 80 |  | 320
2009-07-11 00:00:00 | 07:00:00 |  | 65 |  | 385
2009-07-14 00:00:00 | 21:00:00 |  | 195 |  | 580
2009-07-15 00:00:00 | 07:00:00 |  | 10 |  | 590
2009-07-15 00:00:00 | 19:00:00 |  | 20 |  | 610
2009-07-16 00:00:00 | 08:00:00 |  | 20 |  | 630
2009-07-17 00:00:00 | 07:00:00 |  | 45 |  | 675
2009-07-19 00:00:00 | 17:00:00 |  | 90 |  | 765
2009-07-20 00:00:00 | 21:00:00 |  | 30 |  | 795
2009-07-21 00:00:00 | 21:15:00 |  | 30 |  | 825
2009-07-22 00:00:00 | 20:50:00 |  | 25 |  | 850
TOTAL |  | 3
Spreadsheet: 0030a257-b5e4-4071-b438-414670fefe9d
Sheet: TABLE

#1 Access | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Gender | # | % | # | % | # | % | # | % | # | % | # | % | %
Female |  |  |  |  |  |  |  |  |  |  | 425726
Male |  |  |  |  |  |  |  |  |  |  | 411136
Unknown |  |  |  |  |  |  |  |  |  |  | 0
Total
click here for graph
 | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Ethnicity | # | % | # | % | # | % | # | % | # | % | # | % | %
White |  |  |  |  |  |  |  |  |  |  | 398271
Hispanic |  |  |  |  |  |  |  |  |  |  | 318674
African American |  |  |  |  |  |  |  |  |  |  | 43085
Asian |  |  |  |  |  |  |  |  |  |  | 21251
Native American |  |  |  |  |  |  |  |  |  |  | 6071
Filipino |  |  |  |  |  |  |  |  |  |  | 23365
Pacific Islander |  |  |  |  |  |  |  |  |  |  | 2305
Multi-Race |  |  |  |  |  |  |  |  |  |  | 22553
Unknown |  |  |  |  |  |  |  |  |  |  | 1287
click here for graph
 | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Age | # | % | # | % | # | % | # | % | # | % | # | % | %
<18 |  |  |  |  |  |  |  |  |  |  | 245217
18 & 19 |  |  |  |  |  |  |  |  |  |  | 25706
20 to 24 |  |  |  |  |  |  |  |  |  |  | 52893
25 to 29 |  |  |  |  |  |  |  |  |  |  | 52166
30 to 34 |  |  |  |  |  |  |  |  |  |  | 52145
35 to 39 |  |  |  |  |  |  |  |  |  |  | 55384
40 to 49 |  |  |  |  |  |  |  |  |  |  | 116401
50 + |  |  |  |  |  |  |  |  |  |  | 236950
Unknown |  |  |  |  |  |  |  |  |  |  | 0
Average Age | 27.08580473951301 |  | 26.74092167399446 |  | 26.80841198873986 |  | 26.61666200205243 |  | 26.21942624578122
Median Age | 22 |  | 22 |  | 22 |  | 22 |  | 22
click here for graph
 | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Riverside County |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 ACS* |  | Recent AY
DSPS | # | % | # | % | # | % | # | % | # | % | # | % | #
Disabilities |  |  |  |  |  |  |  |  |  |  | 105412
 |  |  |  |  |  |  |  |  |  |  | 1299857
Service Area Comparison Data from MSJC official [NAME] codes in the 2010 Census Data.
* note: DSPS comparison data is from the 2010 ACS for Riverside County, disability count for ages 18 to 64
http://www.census.gov/acs/www/about_the_survey/american_community_survey/
Spreadsheet: 838441d1691009740-excel-calander-employee-absence-schedule12023
Sheet: September

 | Absence Type Key | AL | Annual Leave |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | September | Dates of Absence
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Days | AL | Personal | Sick
 | [NAME]
 | [NAME]
 | Alsop
 | [NAME]
 | [NAME]
 | Avery
 | Bailey
 | [NAME]
 | [NAME]
 | Bell
 | Berry
 | Black
 | Blake
 | Bond
 | Bower
 | [NAME]
 | Buckland
 | Burgess
 | Butler
 | Cameron
 | Campbell
 | [NAME]
 | Chapman
 | Churchill
 | [NAME]
 | Clarkson
 | [NAME]
 | Cornish
 | [NAME]
 | Davies
 | [NAME]
 | [NAME]
 | [NAME]
 | Dyer
 | Edmunds
 | [NAME]
 | Ferguson
 | Fisher
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Glover
 | [NAME]
 | Grant
 | Gray
 | Greene
 | [NAME]
 | Hardacre
 | [NAME]
Spreadsheet: 72001d1272670307-excel-2007-changing-quantity-according-to-pack-size-sample
Sheet: Sheet1

PLU | pack size | qty
456 | 12 | 0.006
478 | 24 | 0.012
489 | 12 | 1
490 | 12 | 0.009
491 | 6 | 0.005
492 | 24 | 2.002
493 | 12 | 0.001 |  |  |  | OUTPUT Total should be like this
494 | 24 | 0.004 |  |  |  | PLU | pack size | Total QTY | Calculation
495 | 12 | 0.007 |  |  |  | 494 | 24 | 1.002 | (.004+.022)
496 | 12 | 0.001 |  |  |  | 491 | 6 | 1.003 | (0.005+0.004)
497 | 12 | 0.007 |  |  |  | 493 | 12 | 0.01 | (0.001+0.009)
498 | 12 | 0.005
499 | 12 | 0.004
500 | 24 | 0.011
501 | 24 | 0.006
502 | 24 | 1
503 | 12 | 0.004
504 | 6 | 0.005
504 | 6 | 0.003
504 | 6 | 0.002
504 | 6 | 0.004
494 | 24 | 0.022
491 | 6 | 0.004
493 | 12 | 0.009
Spreadsheet: 844155d1695922186-creating-a-table-with-variable-values-based-on-dropdown-selection-copy-of-sample-data-stdar2-
Sheet: Sheet2

 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | Vendor 1 | 10 | 12 | 18 | 19 |  |  | Material 1 | 10 | 40 | 70 | 100
 |  | Vendor 2 | 10 | 10 | 10 | 10 |  |  | Material 2 | 20 | 50 | 80 | 110
 |  | Vendor 3 | 11 | 11 | 11 | 11 |  |  | Material 3 | 30 | 60 | 90 | 20
 |  |  |  |  |  |  |  |  | Material | Material 3 | The table values would change based on the drop down selections
 |  |  |  |  |  |  |  |  | Vendor | Vendor 2
 |  | Car 1 |  |  |  |  |  |  | Car | Car 2
 | Demand Plan |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA | 10 |  |  |  |  |  |  | Q1 | Q2 | Q3 | Q4
 |  | CANADA | 20 |  |  |  |  |  | USA
 |  | Mexico | 30 |  |  |  |  |  | CANADA
 |  |  |  |  |  |  |  |  | Mexico
 |  | Car 2
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA
 |  | CANADA |  |  |  |  |  |  | Car 1
 |  | Mexico |  |  |  |  |  |  |  | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 4 | Total
 |  |  |  |  |  |  |  |  | Material 1 | 10 | 40 | 70 | 100
 |  | Car 3 |  |  |  |  |  |  | Material 2 | 50 | 80 | 90 | 220
 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  | Material 3 | 145 | 175 | 185 | 315
 |  | USA
 |  | CANADA |  |  |  |  |  |  | Car 2
 |  | Mexico |  |  |  |  |  |  |  | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 4 | Total
 |  |  |  |  |  |  |  |  | Material 1 | 25 | 100 | 175 | 250
 |  |  |  |  |  |  |  |  | Material 2 | 125 | 200 | 225 | 550
 |  |  |  |  |  |  |  |  | Material 3 | 362.5 | 437.5 | 462.5 | 787.5
 |  |  |  |  |  |  |  |  | Car 3
 |  |  |  |  |  |  |  |  |  | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 4 | Total
 |  |  |  |  |  |  |  |  | Material 1 | 6.25 | 25 | 43.75 | 62.5
 |  |  |  |  |  |  |  |  | Material 2 | 31.25 | 50 | 56.25 | 137.5
 |  |  |  |  |  |  |  |  | Material 3 | 90.625 | 109.375 | 115.625 | 196.875
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Novasports (Greece)

Novasports (Greece)
Date | Channel | Start (Local) | End (Local) | Notes
2010-11-21 00:00:00 | Novasports 4 | 16:00:00 | 18:00:00 | Round [NAME] (Singles)
2010-11-21 00:00:00 | Novasports 4 | 22:00:00 | 00:00 (22/11) | Round [NAME] (Singles)
2010-11-22 00:00:00 | Novasports 4 | 16:00:00 | 18:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | Novasports 4 | 22:00:00 | 00:00 (23/11) | Round [NAME] (Singles)
2010-11-23 00:00:00 | Novasports 4 | 16:00:00 | 18:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | Novasports 4 | 22:00:00 | 00:00 (24/11) | Round [NAME] (Singles)
2010-11-24 00:00:00 | Novasports 4 | 16:00:00 | 18:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | Novasports 4 | 22:00:00 | 00:00 (25/11) | Round [NAME] (Singles)
2010-11-25 00:00:00 | Novasports 4 | 16:00:00 | 18:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | Novasports 4 | 22:00:00 | 00:00 (26/11) | Round [NAME] (Singles)
2010-11-26 00:00:00 | Novasports 4 | 16:00:00 | 18:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | Novasports 4 | 22:00:00 | 00:00 (27/11) | Round [NAME] (Singles)
2010-11-27 00:00:00 | Novasports 4 | 16:00:00 | 18:45:00 | Semi-Final 1 - Live (Singles)
2010-11-27 00:00:00 | Novasports 4 | 22:00:00 | 00:00 (28/11) | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | Novasports 4 | 19:30:00 | 22:30:00 | Singles Final - Live
Spreadsheet: 680513d1591066905-is-it-possible-to-use-imported-queries-in-normal-formula-bar-without-load-to-worksheet-ef-master
Sheet: Item

KODE | NAMA | SATUAN | KATEGORI | ITEM USED FREQ IN KOEF
MTRL-000001 | DOLKEN KAYU 8-10/400 CM | BATANG | MATERIAL
MTRL-000002 | SEMEN PORTLAND | KG | MATERIAL
MTRL-000003 | PASIR BETON | M3 | MATERIAL
MTRL-000004 | KORAL BETON | M3 | MATERIAL
MTRL-000005 | KAYU 5/7 | M3 | MATERIAL
MTRL-000006 | PAKU 2" – 5" | KG | MATERIAL
MTRL-000007 | RESIDU | LITER | MATERIAL
[NAME] | SENG GELOMBANG | LEMBAR | MATERIAL
MTRL-000009 | MENI BESI | LITER | MATERIAL
MTRL-000010 | KAWAT DURI | M1 | MATERIAL
UPAH-L.01 | PEKERJA | ORANG HARI | UPAH
UPAH-L.02A | TUKANG KAYU | ORANG HARI | UPAH
UPAH-L.03 | KEPALA TUKANG | ORANG HARI | UPAH
UPAH-L.04 | MANDOR | ORANG HARI | UPAH
Spreadsheet: 116019d1311501109-pivot-table-logic-without-the-pivot-table-prod_planning
Sheet: Data

 | Planificare productie 2011
 |  |  | Laser |  |  | Rqstd capacity |  |  | 0
 |  |  |  |  |  | capacity Load | 8h |  | 0
 |  |  |  |  |  | capacity Load | 10h |  | 0
 |  |  | Welding |  |  | Rqstd capacity |  |  | 0 | 5 | 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
 |  |  |  |  |  | capacity Load | 8h |  | 0 | 0.004934859849980261 | 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
 |  |  |  |  |  | capacity Load | 10h |  | 0 | 0.003947887879984209 | 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
 |  |  |  |  |  |  |  |  | IANUARIE |  |  |  | FEBRUARIE |  |  |  | MARTIE |  |  |  | APRILIE |  |  |  | MAI |  |  |  |  | IUNIE |  |  |  | IULIE |  |  |  |  | AUGUST |  |  |  | SEPTEMBRIE |  |  |  | OCTOMBRIE |  |  |  |  | NOIEMBRIE |  |  |  | DECEMBRIE |  |  |  | IANUARIE 2012
Comanda productie | Data expeditie | Descriere | Referinta piesa | Cantitate | Timp / operatie | Operatie | Te | [NAME] | W01 | W02 | [NAME] | W04 | [NAME] | W06 | W07 | W08 | W09 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25 | W26 | [NAME] | W28 | W29 | W30 | W31 | W32 | W33 | [NAME] | W35 | W36 | W37 | W38 | W39 | W40 | W41 | W42 | W43 | W44 | W45 | W46 | W47 | [NAME] | [NAME] | W50 | W51 | W52
FPO20058 | 2011-03-18 00:00:00 | #N/A | TT59443 B | 20 | 0.0003 | LASER | 0
FPO21139 | 2011-04-13 00:00:00 | #N/A | BA490316 C | 70 | 0.00025 | INDOIRE | 0 |  | 10
[NAME] | 2011-03-17 00:00:00 | #N/A | CN56514 | 50 | 0.00523 | SUDURA | 0.3 |  |  | 5
[NAME] | 2011-05-03 00:00:00 | #N/A | CNV55527 | 50 | 0 | SUDURA | 0
FPO26023 | 2011-04-11 00:00:00 | #N/A | VE52685 C | 20 | 0 | LASER | 0
FPO21202 | 2011-03-17 00:00:00 | #N/A | VE56145 | 20 | 0.01091 | LASER | 0.2
FPO21199 | 2011-03-17 00:00:00 | #N/A | VE56182 | 40 | 0.05378 | Peinture | 2.2
FPO22266 | 2011-03-17 00:00:00 | #N/A | BA393558 E | 5 | 0 | SUDURA | 0
FPO20689 | 2011-03-28 00:00:00 | #N/A | BA393655 F | 42 | 0.0083 | LASER | 0.3
Spreadsheet: 76700d1277215951-solved-with-sumif-do-i-use-hlookup-and-vlookup-2examplefile
Sheet: Month 2

date | category | description | cost |  |  | 82
2010-01-01 00:00:00 | winkin | this | 20
2010-01-01 00:00:00 | blinkin | not | 15
2010-01-22 00:00:00 | nod | not | 20
2010-01-01 00:00:00 | winkin | this won't | 60
2010-01-01 00:00:00 | blinkin | not | 15
2010-01-22 00:00:00 | nod | not | 20
2010-01-01 00:00:00 | winkin | this is | 2
Spreadsheet: 88765d1288623712-finding-similarity-in-two-lists-comparelists
Sheet: Sheet1

Data 1 | Found in Sheet2
Data 2 | Found in Sheet2
Data 3 | Found in Sheet2
Data 4
Data 5
Data 6
Data 7 | Found in Sheet2
Data 8 | Found in Sheet2
Data 9 | Found in Sheet2
Data 10 | Found in Sheet2
Data 11
Data 12
Data 13
Data 14
Data 15 | Found in Sheet2
Data 16
Data 17
Data 18
Data 19
Data 20
Data 21 | Found in Sheet2
Data 22 | Found in Sheet2
Data 23 | Found in Sheet2
Data 24 | Found in Sheet2
Data 25 | Found in Sheet2
Data 26 | Found in Sheet2
Data 27 | Found in Sheet2
Data 28 | Found in Sheet2
Data 29 | Found in Sheet2
Data 30 | Found in Sheet2
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 28554 | 33234 | 33359 | 35317
2 | 15625 | 16488 | 35760 | 37983 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 28573 | 29845 | 33221 | 34952 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 25755 | 30000 | 32149 | 33000 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 28747 | 27000 | 29943 | 29000 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 |  |  |  |  |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  | 441785.89 |  | 100797.53
2001-09-05 00:00:00
CBS Volume
 |  |  | 69826
Spreadsheet: robin_rodrigue__33276__Kathy
Sheet: YTD Recon

 |  |  |  |  |  |  |  |  |  |  |  | MTD
 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | TOTAL
Per Houston***
TERM | 3938764.42192036 | 7816866.58030592 | 3834132.56916904 | 1607896.29481687 | 9987260.38045156 | -1351716.56960818 | -7305940.51499303 | 4239209.00131895 | -2582956.060938584 | -3204784.199715213 | -10695182.33843841 | 10343351.75597447 |  | 16626901.32026375
CASH | -2124611.87417905 | 1889245.63210472 | 2426372.25289896 | 2695721.36412306 | 2996711.39064763 | 1625743.05725873 | 2634193.17977841 | 875397.4802724306 | 3573322.944497603 | 687968.3281069371 | 2562997.857869264 | 7269333.517356077 |  | 27112395.13073477
TOTAL
Per Canada
Total Term | 2355424.313703521 | 6237803.581497932 | 2877353.735002021 | 1526752.294816868 | 9987140.380451558 | -1350811.569608179 | -7219437.51499303 | 4239225.001318946 | -2582775.947722142 | -3204404.199715213 | -10696202.33843841 | 11052148.17907678 |  | 13222215.91539065
Total Cash | -2117923.446289062 | 1892104.454566867 | 2406637.023393873 | 2721312.586616726 | 3758853.208417242 | 1629502.459124545 | 1907272.381464948 | 868873.3855922908 | 3620730.44826768 | 693071.0909741863 | 2562997.857869263 | 2879575.619089202 |  | 22823007.06908776
TOTAL
[NAME]
Term
Cash
TOTAL
***Houston Values EXCLUDE Originations
Spreadsheet: 270281d1381427639-duplicates-within-a-date-rage-example
Sheet: Sheet1

Unique Close | Sales Owner and Customer | [NAME] | Customer Close | Close date
1 | [NAME] xyz | [NAME] | 12345678 - Customer xyz | 2013-07-15 00:00:00
1 | [NAME] | [NAME] | 78987654 - ABC Inc | 2013-05-01 00:00:00
1 | [NAME] xyz | [NAME] | 12345678 - Customer xyz | 2013-07-30 00:00:00
1 | [NAME] | [NAME] | 78987654 - ABC Inc | 2013-10-01 00:00:00
Spreadsheet: 34635d1231953878-find-last-entry-on-calendar-calendar
Sheet: Employee 1

Employee: | [NAME] |  |  |  |  |  |  |  | 2009
 | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T
January |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
February |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
March |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
April |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
May |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
June | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
July |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
August |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
September |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
October |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
November |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
December |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  | Key |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual Allocation (Days) |  |  |  |  | 25 |  |  |  |  |  | Sick Days |  |  |  |  | 0
 |  |  | Full Day Holiday |  |  |  | = | FDH | Unpaid Holiday |  |  |  | = | UPH |  |  | Days taken |  |  |  |  | 0 |  |  |  |  |  | Unpaid Days |  |  |  |  | 0
 |  |  | Half Day Holiday |  |  |  | = | HDH | Compassionate |  |  |  | = | C |  |  | Number of days left |  |  |  |  | 25 |  |  |  |  |  | Compassionate Days |  |  |  |  | 0
 |  |  | Sick |  |  |  | = | S | Bank Holiday |  |  |  | = | BH |  |  | Annual Bank Holidays |  |  |  |  | 0
Spreadsheet: 689159d1596148255-search-with-some-sort-of-combination-find-and-mark-12data8500rows
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
HE | HO | HE | HE | LO | LE | ME | ME | MO | HE | HO | HE
LO | LO | LE | ME | ME | HE | HO | HO | HO | HE | LE | MO
HO | HE | LE | HE | MO | HE | HE | HE | HE | MO | ME | HE
LO | LO | HE | LO | MO | HE | HE | LO | MO | HE | HO | HE
ME | MO | HE | ME | HE | LO | LO | HE | HE | HE | LO | HE
HO | HO | HE | HE | LO | LO | HE | ME | HE | HE | ME | LO
HE | HE | LO | HE | HO | HE | LO | HE | HE | HE | HE | HE
LO | MO | LE | LO | LO | ME | HE | HE | LO | LO | HE | HO
HE | HE | HE | HO | HO | HE | ME | LO | LO | HE | ME | LO
ME | HE | HE | LO | LO | HE | HE | HO | HE | LO | HE | HO
LO | ME | HE | LO | MO | LE | LO | LO | ME | HE | LO | LO
HO | HE | ME | HE | HE | HE | HO | HO | HE | ME | HO | HO
LO | HE | HE | ME | HE | HE | LO | LO | HE | HE | LO | LO
HE | LO | HE | HE | HE | HE | HE | HE | LO | HE | HE | HE
LO | LO | HE | ME | HE | LO | LO | LO | LE | LO | LO | HE
HO | HE | LO | HE | HE | HE | HE | LO | HE | HO | ME | LO
LO | ME | HE | HE | LO | ME | LO | HE | HE | LO | HE | HE
HO | HE | ME | LO | LE | HO | HE | ME | LO | LE | HE | HO
LO | HE | HE | HO | HE | LO | HE | HE | HO | HE | ME | LO
MO | LE | LO | LO | HE | MO | LE | LO | LO | HE | HE | HO
 |  |  |  |  |  |  |  | Say for example row 12 repeats as is, same order, 4 times in 8500 rows, and a cell that marks/counts it.
Spreadsheet: 20981bb5-f646-43e2-9557-e8fc06a049e7
Sheet: 2006-07

Table T1
UK Domiciled Student Numbers by Ethnic Group
Ethnic Group | Undergraduate | Graduate | Total
Asian or Asian British
- Bangladeshi | 138 | 24
- Indian | 1033 | 278
- Pakistani | 257 | 64
- Other | 470 | 112
Subtotal
Black or Black British
- African | 249 | 106
- Caribbean | 50 | 34
- Other | 18 | 8
Subtotal
Chinese
Chinese | 357 | 107
Subtotal
Mixed
- White and Asian | 182 | 40
- White and Black African | 29 | 12
- White and Black Caribbean | 38 | 12
- Other | 159 | 43
Subtotal
White
- British | 4605 | 2174
- Irish | 62 | 86
- Irish Traveller | 0 | 0
- Scottish | 27 | 38
[NAME] (not used for applicants after 2000) | 130 | 190
- Other | 344 | 471
Subtotal
Other
Other Ethnic Background | 225 | 82
Information Refused | 62 | 39
Not Known | 227 | 676
Subtotal
Total
The information in this table is concerned with those students whose domicile at the time of application is within the UK.
Spreadsheet: 658013d1579122262-index-and-match-fill-table-with-unique-values-index-match-issue-example
Sheet: Placements

 | Placements
 | Contract ID | First Name | Last Name | Start Date | End Date | Day Rate
 | 1 | [NAME] | Smith | 2019-01-01 00:00:00 | 2019-03-31 00:00:00 | 400 |  | <<< This is what I would like it to look like
 | 3 | [NAME] | Smith | 2019-04-01 00:00:00 | 31/06/2019 | 400
 | 4 | [NAME] | Dough | 2019-04-01 00:00:00 | 31/06/2019 | 550
 | 5 | [NAME] | Smith | 2019-07-01 00:00:00 | 2019-09-30 00:00:00 | 400
 | Contract ID | First Name | Last Name | Start Date | End Date | Day Rate |  | <<< This is my code result
Spreadsheet: 880619d1728439189-need-a-column-to-list-values-related-to-another-column-realtrac_report-n8hrv-
Sheet: RTR

NEW Work Session REPORT
Session End | Job Number | Employee Name | Scrap | Job Closed
09/17/2024 11:20 AM | 24J20839 | Hopp, Autumn | 0 | True
09/17/2024 11:20 AM | 24J20839 | Hopp, Autumn | 0 | True
09/17/2024 11:20 AM | 24J20839 | Hopp, Autumn | 0 | True
09/19/2024 07:48 AM | 24J20840 | Dickinson, [NAME] | 0 | False
09/18/2024 04:28 PM | 24J20840 | Dickinson, [NAME] | 0 | False
09/25/2024 08:21 AM | 24J20841 | Stange, Darrel | 0 | False
09/24/2024 03:26 PM | 24J20841 | Stange, Darrel | 0 | False
09/24/2024 11:00 AM | 24J20841 | Stange, Darrel | 0 | False
09/24/2024 07:31 AM | 24J20841 | Stange, Darrel | 0 | False
09/18/2024 12:44 PM | 24J20842 | Dickinson, [NAME] | 0 | False
09/18/2024 12:11 PM | 24J20842 | Dickinson, [NAME] | 0 | False
09/18/2024 11:00 AM | 24J20842 | Dickinson, [NAME] | 0 | False
09/18/2024 08:15 AM | 24J20842 | Dickinson, [NAME] | 0 | False
09/25/2024 11:20 AM | 24J20845 | Hopp, Autumn | 0 | True
09/25/2024 11:20 AM | 24J20845 | Hopp, Autumn | 0 | True
09/25/2024 11:20 AM | 24J20845 | Hopp, Autumn | 0 | True
09/25/2024 11:22 AM | 24J20850 | Hopp, Autumn | 0 | True
09/25/2024 11:22 AM | 24J20850 | Hopp, Autumn | 0 | True
09/25/2024 11:22 AM | 24J20850 | Dickinson, [NAME] | 0 | True
09/25/2024 11:22 AM | 24J20850 | Stange, Darrel | 0 | True