tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 160733d1339177448-excel-2007-look-up-question-lookup-from-multiple-tabs
Sheet: Occurance List

Summary Sheet Click [NAME] to link to their detailed data |  |  |  |  | [NAME]
 |  |  |  |  | 103
Name | # of Occurances | Corrective Action Step | WITHOUT tabs entering in a range |  | 108
[NAME] Doe #1 |  |  |  |  | 109
[NAME] Doe #2 |  |  |  |  | 110
[NAME] Doe #3
[NAME] Doe #4
[NAME] Doe #5
[NAME] Doe #6
[NAME] Doe #7
[NAME] Doe #8
[NAME] Doe #9
[NAME] Doe #10
[NAME] Doe #11
[NAME] Doe #12
[NAME] Doe #13
[NAME] Doe #14
[NAME] Doe #15
[NAME] Doe #16
[NAME] Doe #17
[NAME] Doe #18
[NAME] Doe #19
Spreadsheet: 90023d1289791360-min-max-and-name-range-book2
Sheet: Sheet1

 | A | B | C
1 | Name | Date | Series
2 | AAC | 2010-10-31 00:00:00 | 1.5
3 |  | 2010-09-30 00:00:00 | 1.54
4 |  | 2010-08-31 00:00:00 | 1.63
5 |  | 2010-07-31 00:00:00 | 1.5
Spreadsheet: 295460d1391704547-find-in-range-from-a-range-help
Sheet: Sheet1

Shift | Description | Hours |  |  | Shift1 | Shift2 | Shift3 | Shift4 | Shift5 | Shift6
A | 8:00 - 4:00 | 7.5 |  | 2013-12-30 00:00:00 | V | A | F | C | V | C |  | <----- This is where I would like to see a 1 or a 0
B | 8:30 - 4:30 | 7.5 |  | 2013-12-31 00:00:00 | V | A | F | C | V | C
C | 9:00 - 5:00 | 7.5 |  | 2014-01-01 00:00:00 | B | A | D | C | B | A
D | 9:30 - 5:30 | 7.5 |  | 2014-01-02 00:00:00 | B | A | C | V | F | B
E | 10:00 - 6:00 | 7.5 |  | 2014-01-03 00:00:00 | B | T | C | V | F | B
F | 11:00 - 7:00 | 7.5 |  | 2014-01-06 00:00:00 | B | A | F | T | F | B
G | 3:00 -7:00 | 4 |  | 2014-01-07 00:00:00 | B | A | O | C | F | B
H | 1:00 - 5:00 | 4 |  | 2014-01-08 00:00:00 | B | A | F | C | F | B
I | 1:00 - 7:00 | 6 |  | 2014-01-09 00:00:00 | B | A | O | C | F | B
J | 12:30 - 5:00 | 4.5 |  | 2014-01-10 00:00:00 | F | A | L | C | B | B
K | 1:30 - 7:00 | 5.5 |  | 2014-01-13 00:00:00 | F | A | F | C | B | A
L | 2:00 - 7:00 | 5 |  | 2014-01-14 00:00:00 | F | A | O | C | B | A
Spreadsheet: 858491d1707159552-looking-for-ideas-to-organize-information-so-pivot-tables-will-work-draft-ruby9c-
Sheet: Sheet1

 | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 |  | Name | Course Name | Credit hours | Date Completed |  | Courses |  | Name | Name 4
Basic Courses |  |  |  |  |  |  |  |  |  |  |  |  | Basic 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Basic 2 |  | Course Name | Sum of Credit hours | Sum of Date Completed
Basic 1 |  |  |  |  |  |  |  |  |  |  |  |  | Advanced 1 |  | Basic 1 | 6 | 2024-02-04 00:00:00
credit hours | 6 | 6 | 6 | 6 |  |  |  |  |  |  |  |  | Extra 1 |  | Basic 2 | 2 | 2024-02-05 00:00:00
date completed | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | Advanced 1 | 2 | 2024-02-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra 1 | 8 | 2024-02-05 00:00:00
Basic 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 18 | 2396-05-25 00:00:00
credit hours |  | 2 | 2 | 2 | 2 | 2
date completed |  | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00
Advanced Courses
Advanced 1
credit hours |  | 2 | 2 | 2
date completed |  | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00
Extra Courses
Extra 1
credit hours | 8 | 8 | 8 | 8 | 8 | 8
date completed | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00
Total Credit Hours | 14 | 18 | 18 | 18 | 10 | 10
Spreadsheet: 717160d1612516577-functions-to-cleanse-data-to-a-specific-format-bazlurgan-dummy-workbook-3
Sheet: Sheet1

Reference mixed | reference cleansed
12A    00001234/D | A1234
1 A  1234 | A1234
A0001234 | A1234
2C0001234/E | C1234
C    0001234/E | C1234
3 B12345/D | B12345
1A 0000345/E | A345
Spreadsheet: 829127d1683939587-help-with-daily-schedule-with-auto-days-off-example-tennfox-
Sheet: Friday

 | Primary | Trainee |  | 2023-05-12 00:00:00 |  |  | Off
211
212
213
214
314
315
316
Spreadsheet: chris_germany__1952__MS150 Pledge Sheet
Sheet: 2002 Pledges

Houston - Austin   April 20-21, 2002
Rider's Name: | T PATRICK DENETSOSIE | [NAME]: | (1).[PHONE] |  | Pledge Total
Address: | 3400 TIMMONS LANE #66 | Evening Phone:
City/State/Zip | HOUSTON, TX, 77027 | [NAME]: | [EMAIL]
Sponsor Name | Address | Phone | Pledge Amount | Matching [NAME] | Total Received | Collected
[NAME] | 2701 Revere St. #221, Houston, TX  77098 | [PHONE] | 20 |  |  | 20
Spreadsheet: 101679d1299764499-help-with-formatting-example
Sheet: Sheet1

 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5
Employee 6
Employee 7
Employee 8
Employee 9
Employee 10
Spreadsheet: 805571d1668774202-cumulative-sum-with-condition-classeur
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 25 | Bauer Solar Glas-Glas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 | 39 | Bauer Solar Glas-Glas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 390 | 10 | JAM54S30-405
Spreadsheet: 803515d1667502680-count-duplicate-and-missing-names-in-other-sheets-main
Sheet: Main

THOMAS |  | duplicate | Missing
[NAME]
JACK
DANIEL
MATTHEW
RYAN
[NAME]
[NAME]
SAMUEL
JORDAN
ADAM
[NAME]
ALEXANDER
CHRISTOPHER
BENJAMIN
[NAME]
LIAM
JAKE
WILLIAM
ANDREW
GEORGE
LEWIS
[NAME]
[NAME]
[NAME]
[NAME]
NATHAN
CONNOR
[NAME]
HARRY
CALLUM
[NAME]
ASHLEY
BRADLEY
JACOB
KIERAN
SCOTT
SAM
[NAME]
[NAME]
[NAME]
NICHOLAS
[NAME]
[NAME]
MARK
SEAN
EDWARD
STEPHEN
RICHARD
ALEX
PETER
DOMINIC
JOE
REECE
[NAME]
RHYS
STEVEN
ANTHONY
CHARLIE
PAUL
CRAIG
JASON
DALE
ROSS
CAMERON
LOUIS
DEAN
CONOR
SHANE
ELLIOT
PATRICK
MAX
SHAUN
HENRY
SIMON
TIMOTHY
MITCHELL
BILLY
PHILIP
JOEL
JOSH
MARCUS
DYLAN
CARL
ELLIOTT
BRANDON
MARTIN
TOBY
STUART
GARETH
DANNY
CHRISTIAN
TOM
DECLAN
KARL
MOHAMMAD
MATHEW
JAY
OWEN
DARREN
REBECCA
LAUREN
JESSICA
CHARLOTTE
HANNAH
SOPHIE
AMY
EMILY
LAURA
EMMA
CHLOE
SARAH
LUCY
KATIE
BETHANY
JADE
MEGAN
[NAME]
RACHEL
SAMANTHA
DANIELLE
HOLLY
[NAME]
OLIVIA
STEPHANIE
[NAME]
VICTORIA
NATASHA
GEORGIA
ZOE
NATALIE
ELEANOR
SHANNON
PAIGE
GEORGINA
GEMMA
NICOLE
CHELSEA
KIRSTY
ALEXANDRA
MELISSA
JENNIFER
HAYLEY
LOUISE
KATHERINE
JODIE
GRACE
ANNA
MOLLY
AMBER
JASMINE
KAYLEIGH
KELLY
HARRIET
ASHLEIGH
CATHERINE
LEAH
NICOLA
FRANCESCA
NAOMI
KATE
[NAME]
CLAIRE
LEANNE
RACHAEL
ROSIE
AIMEE
ELLIE
SIAN
KIMBERLEY
LYDIA
HOLLIE
STACEY
BETHAN
AMELIA
[NAME]
[NAME]
HEATHER
LISA
HELEN
ELLA
ROBYN
CHANTELLE
ELLEN
DAISY
DEMI
COURTNEY
GABRIELLE
YASMIN
LILY
RHIANNON
MARIA
KERRY
IMOGEN
REBEKAH
[NAME]
CAITLIN
JEMMA
TONI
Spreadsheet: 714845d1611397951-trades-needed-in-sheet-2-testsubject
Sheet: Sheet1

Date | Price | Signal | Stop Loss Price | Fix sale point | Buy/sell | SL Price | Price
2010-11-10 00:00:00 | 6.55
2010-11-11 00:00:00 | 6.54 | Buy |  | Buy |  | 6.29
2010-11-15 00:00:00 | 6.59 |  |  | 0 |  | 6.29
2010-11-16 00:00:00 | 6.34 |  |  | 0 |  | 6.29
2010-11-22 00:00:00 | 6.54 |  |  | 0 |  | 6.29
2010-11-23 00:00:00 | 6.67 | Sell |  | Sell |  | 6.29
2010-11-24 00:00:00 | 6.47 |  |  | 0 |  | 6.29
2010-11-25 00:00:00 | 6.67 |  |  | 0 |  | 6.29
2010-11-26 00:00:00 | 6.4 | Buy |  | Buy |  | 6.15
2010-11-29 00:00:00 | 6.61 |  |  | 0 |  | 6.15
2010-11-30 00:00:00 | 6.01 |  |  | SellStop |  | 6.15
2010-12-01 00:00:00 | 6.67 | Sell |  | Sell |  | 6.15
2010-12-02 00:00:00 | 6.55 |  |  | 0 |  | 6.15
2010-12-06 00:00:00 | 6.61 |  |  | 0 |  | 6.15
2010-12-07 00:00:00 | 6.53 | Buy |  | Buy |  | 6.28
2010-12-08 00:00:00 | 6.86 |  |  | 0 |  | 6.28
2010-12-09 00:00:00 | 6.67 |  |  | 0 |  | 6.28
2010-12-10 00:00:00 | 6.59 | Sell |  | Sell |  | 6.28
2010-12-13 00:00:00 | 6.54 |  |  | 0 |  | 6.28
2010-12-14 00:00:00 | 6.54 |  |  | 0 |  | 6.28
Spreadsheet: 736609d1623763129-index-and-match-not-working-test-file
Sheet: Sheet2

Build Plan | Product | Part Number | 2021-05-01 00:00:00
 |  | 123 | 2402 | 1795 | 1967 | 2139 | 1949 | 2080
 |  | 456 | 150 | 130 | 316 | 362 | 357 | 332
 |  | 789 | 240 | 480 | 352 | 348 | 319 | 290
 |  | 101112 | 150 | 0 | 0 | 0 | 0 | 0
 |  | 131415 | 3 | 2 | 6 | 4 | 4 | 6
 |  | 144069 | 23 | 4 | 14 | 20 | 0 | 25
 |  | 156723 | 1 | 14 | 2 | 3 | 0 | 100
 |  | 169377 | 1042 | 663 |  | 1018 | 1179 | 743
 |  | 182031 | 157 | 135 | 194 | 179 | 150 | 137
 |  | 194685 | 42 | 160 | 208 | 275 | 315 | 219
 |  | 207339 | 10 | 0 | 4 | 5 | 5 | 11
 |  | 219993 | 20 | 13 | 10 | 12 | 13 | 22
 |  | 232647 | 38 | 7 | 20 | 25 | 25 | 10
 |  | 245301 | 1 | 5 | 5 | 7 | 6 | 5
 |  | 257955 | 68 | 125 | 79 | 40 | 67 | 62
 |  | 270609 | 0 | 0 | 0 | 0 | 0 | 1
 |  | 283263 | 14 | 43 | 107 | 44 | 37 | 36
 |  | 295917 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 308571 | 20 | 0 | 0 | 2 | 1 | 1
 |  | 321225 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 333879 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 346533 | 2 | 0 | 1 | 0 | 0 | 0
 |  | 359187 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 371841 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 384495 | 13 | 12 | 0 | 0 | 0 | 0
 |  | 397149 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 409803 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 422457 | 0 | 1 | 1 | 0 | 0 | 0
 |  | 435111 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 121198d1315918708-how-do-i-build-an-invoice-and-have-it-pull-data-from-excel-cheerforum
Sheet: TINY Tuition

TINY | 2010-09-01 00:00:00 |  |  |  | 2010-10-01 00:00:00 |  |  |  | 2010-11-01 00:00:00 |  |  |  | 2010-12-01 00:00:00 |  |  |  | 2011-01-01 00:00:00 |  |  |  | 2011-02-01 00:00:00 |  |  |  | 2011-03-01 00:00:00 |  |  |  | 2011-04-01 00:00:00 |  |  |  | 2011-05-01 00:00:00 |  |  |  | 2011-06-01 00:00:00 |  |  |  | 2011-07-01 00:00:00
 |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date |  | Late | CK# | Date
Spreadsheet: 8809e7f5-dfea-4cd3-b28d-6397b34de4d3
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43572820 | 2014-10-14 02:31:49 | AXIS | 1 | 5 | 3 | 335648 | Buidheo | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43573121 | 2014-10-14 02:50:03 | ALLIES | 0 | 3 | 5 | 335648 | Buidheo | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43628651 | 2014-10-18 07:01:12 | ALLIES | 0 | 3 | 5 | 1007284 | Temple58 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43628822 | 2014-10-18 07:24:53 | AXIS | 1 | 5 | 1 | 1007284 | Temple58 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43642782 | 2014-10-19 06:25:35 | ALLIES | 0 | 2 | 5 | 603439 | MickeyScott01 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43642903 | 2014-10-19 06:51:13 | AXIS | 1 | 5 | 4 | 603439 | MickeyScott01 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
Spreadsheet: 541447d1507295361-convert-with-dashes-add_dash
Sheet: Sheet1

 | P-008037
 | P26903
 | P77897
 | P2070
 | P2048
 | P4551
 | W2059:001
 | W2044:001
 | W1169:001
 | W1779:001
 | P-1969
 | P-4623
 | P4768
 | P4084
Spreadsheet: c6730dcc-e75d-43e7-b993-4e4ee5d660d3
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/02/2013 | Wrestling | Gardner-Webb (UVA Duals) | W, 24-14
11/02/2013 | Wrestling | [NAME] (UVA Duals) | W, 46-0
11/02/2013 | Wrestling | at Virginia (UVA Duals) | L, 41-6
11/09/2013 | Wrestling | at Mercyhurst Laker Open | Results
11/15/2013 | Wrestling | at Iowa State | L, 22-12
11/15/2013 | Wrestling | Midland | W, 34-6
11/16/2013 | Wrestling | [NAME] (Ames, Iowa) | Results
11/23/2013 | Wrestling | Navy Classic | 9th/14
12/07/2013 | Wrestling | Drexel ([NAME]) | W, 25-8
12/07/2013 | Wrestling | VMI ([NAME]) | W, 38-3
12/07/2013 | Wrestling | [NAME] ([NAME]) | W, 27-3
12/08/2013 | Wrestling | at Indiana ([NAME]) | W, 22-21
12/08/2013 | Wrestling | Northern Colorado ([NAME]) | W, 35-4
12/22/2013 | Wrestling | Tournament of Champions (Reno, Nev.) | All Day
01/04/2014 | Wrestling | Lock Haven | 7 p.m.
01/10/2014 | Wrestling | NC State | 7:30 p.m.
01/18/2014 | Wrestling | Oklahoma State | 7:30 p.m.
02/01/2014 | Wrestling | Pittsburgh | 7 p.m.
02/06/2014 | Wrestling | Oklahoma | 7 p.m.
02/07/2014 | Wrestling | [NAME] | 7:30 p.m.
02/14/2014 | Wrestling | Clarion University (Beauty and Beast) | 6 p.m.
02/16/2014 | Wrestling | at Ohio | 2 p.m.
[NAME] | Wrestling | at Edinboro | 7 p.m.
03/08/2014 | Wrestling | Big 12 Tournament (Norman, Okla.) | All Day
03/20/2014 | Wrestling | [NAME] (Oklahoma City) | All Day
Spreadsheet: 734587d1622246738-link-one-workbook-to-another-but-then-link-cells-in-same-workbook-and-create-text-entry-pin-list-example
Sheet: Pin numbers

PIN | UPC | person |  | Manager | Company | Start / Finish date | History of Transfer | current or F | Comments
4 | CH000002 | [NAME] | Hanssen | MH | Karmik pty ltd | 2020-12-02 00:00:00
323 | CH000001 | Belinda | Hanssen | MH | BHC Australia Pty Ltd | 2020-12-02 00:00:00
3072 | CH000006 | Jonathon | Moore | [NAME] | Superior Plumbing | 2021-01-11 00:00:00 | ex [NAME] | P/T
11124 | CH000003 | [NAME] | Druart | MH | Construct | 2021-03-04 00:00:00
10400 | CH000005 | [NAME] | Shackleton | MH | Construct | 2021-04-15 00:00:00
11145 | CH000004 | [NAME] | Townsend | MH | Train and Retain | 2021-05-03 00:00:00 |  | P/T
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: ESPN Star Sports (India)

ESPN Star Sports (India)
Date | Start (IST) | End (IST) | Notes
2010-11-21 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 19:30:00 | 21:30:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 01:30:00 | 03:30:00 | Round [NAME] (Singles)
2010-11-28 00:00:00 | 01:30:00 | 03:30:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | 03:30:00 | 05:00:00 | Semi-Final 2 - Same Day Delay (Singles)
2010-11-28 00:00:00 | 23:00:00 | 01:00 (29/11) | Final - Live
Spreadsheet: 756035d1637248842-vlookup-returning-values-with-the-most-recent-date-test-sheet
Sheet: Sheet1

Sheet one |  |  | Sheet two
W/O No. | Order ready by |  | WO Number | Due Date
48483 |  |  | 48483 | 2021-11-15 00:00:00
48568 |  |  | 48483 | 2021-11-22 00:00:00
48569 |  |  | 48483 | 2021-12-22 00:00:00 | Longest due date for 48483
48570 |  |  | 48483 | 2021-12-06 00:00:00
48571 |  |  | 48483 | 2021-12-06 00:00:00
48572 |  |  | 48483 | 2021-12-06 00:00:00
48573 |  |  | 48483 | 2021-12-06 00:00:00
 |  |  | 48483 | 2021-12-06 00:00:00
 |  |  | 48483 | 2021-12-06 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48569 | 2021-11-23 00:00:00
 |  |  | 48569 | 2021-11-23 00:00:00
 |  |  | 48570 | 2021-12-20 00:00:00
 |  |  | 48570 | 2021-12-20 00:00:00
 |  |  | 48570 | 2021-11-17 00:00:00
 |  |  | 48570 | 2021-12-20 00:00:00
 |  |  | 48573 | 2021-12-16 00:00:00
 |  |  | 48573 | 2021-12-20 00:00:00
Spreadsheet: 2ea05987-195a-4962-8fcb-943bf0ed6a1b
Sheet: Sheet1

Andreasen | Nancie | AEA 1
Awtry | [NAME] | AEA 13
[NAME] | Emily | Phoenix Alliance
Cassidy | Melody | AEA 10
Compton | [NAME] | AEA 14
Eidahl | [NAME] | Principal, Evans Middle School, [NAME]
Finnegan | [NAME] | AEA 13
Glackin | Doug | Principal, Nodaway Valley Middle School
Hall | Bev | Council Bluffs CSD
Hamer | [NAME] | Sioux City CSD
[NAME] | Deb | Department of Education
Hockenberry | [NAME] | AEA 13
House | Molly | Des Moines Public Schools
[NAME] | [NAME] | Des Moines Public Schools
Learn | Kathy | Davenport CSD
[NAME] | [NAME] | NWAEA
Martens | Rita | Department of Education
McCune | Teresa | Department of Education
[NAME] | [NAME] | Principal, [NAME], Council Bluffs CSD
Ohl | [NAME] | AEA 8
Opperman | Dixie | AEA 1
Ortgiesen | Margie | AEA 267
[NAME] | [NAME] | AEA 10
Petersen | [NAME] | Principal, East Middle School, Sioux City CSD
Pinion | [NAME] | Superintendent, [NAME]
Polich | Mark | [NAME], [NAME]
Reese | [NAME] | Department of Education
Richardson | [NAME] | AEA 11
Schmitz | [NAME] | Principal, [NAME] High School
Schons | Barb | AEA 8
Squires | Deb | Department of Education
Steingreaber | Kristen | AEA 15
Stimmel | BJ | AEA 16
Stos | [NAME] | AEA 9
Wagoner | Bridgette | [NAME], UNI
Wells | Barb | AEA 267
[NAME] | Becky | AEA 267
Youngers | Sara | NWAEA
Spreadsheet: 09fe1b17-9541-4a15-a8af-fe8b018654c2
Sheet: FV

n | 180 |  | month | net worth at the end of the month |  | Intrinsic
P | 400000 |  | 0
X | 800 |  | 1
F |  |  | 2
rate | 0.005 |  | 3
(1 + rate)^n |  |  | 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
 |  |  | 32
 |  |  | 33
 |  |  | 34
 |  |  | 35
 |  |  | 36
 |  |  | 37
 |  |  | 38
 |  |  | 39
 |  |  | 40
 |  |  | 41
 |  |  | 42
 |  |  | 43
 |  |  | 44
 |  |  | 45
 |  |  | 46
 |  |  | 47
 |  |  | 48
 |  |  | 49
 |  |  | 50
 |  |  | 51
 |  |  | 52
 |  |  | 53
 |  |  | 54
 |  |  | 55
 |  |  | 56
 |  |  | 57
 |  |  | 58
 |  |  | 59
 |  |  | 60
 |  |  | 61
 |  |  | 62
 |  |  | 63
 |  |  | 64
 |  |  | 65
 |  |  | 66
 |  |  | 67
 |  |  | 68
 |  |  | 69
 |  |  | 70
 |  |  | 71
 |  |  | 72
 |  |  | 73
 |  |  | 74
 |  |  | 75
 |  |  | 76
 |  |  | 77
 |  |  | 78
 |  |  | 79
 |  |  | 80
 |  |  | 81
 |  |  | 82
 |  |  | 83
 |  |  | 84
 |  |  | 85
 |  |  | 86
 |  |  | 87
 |  |  | 88
 |  |  | 89
 |  |  | 90
 |  |  | 91
 |  |  | 92
 |  |  | 93
 |  |  | 94
 |  |  | 95
 |  |  | 96
 |  |  | 97
 |  |  | 98
 |  |  | 99
 |  |  | 100
 |  |  | 101
 |  |  | 102
 |  |  | 103
 |  |  | 104
 |  |  | 105
 |  |  | 106
 |  |  | 107
 |  |  | 108
 |  |  | 109
 |  |  | 110
 |  |  | 111
 |  |  | 112
 |  |  | 113
 |  |  | 114
 |  |  | 115
 |  |  | 116
 |  |  | 117
 |  |  | 118
 |  |  | 119
 |  |  | 120
 |  |  | 121
 |  |  | 122
 |  |  | 123
 |  |  | 124
 |  |  | 125
 |  |  | 126
 |  |  | 127
 |  |  | 128
 |  |  | 129
 |  |  | 130
 |  |  | 131
 |  |  | 132
 |  |  | 133
 |  |  | 134
 |  |  | 135
 |  |  | 136
 |  |  | 137
 |  |  | 138
 |  |  | 139
 |  |  | 140
 |  |  | 141
 |  |  | 142
 |  |  | 143
 |  |  | 144
 |  |  | 145
 |  |  | 146
 |  |  | 147
 |  |  | 148
 |  |  | 149
 |  |  | 150
 |  |  | 151
 |  |  | 152
 |  |  | 153
 |  |  | 154
 |  |  | 155
 |  |  | 156
 |  |  | 157
 |  |  | 158
 |  |  | 159
 |  |  | 160
 |  |  | 161
 |  |  | 162
 |  |  | 163
 |  |  | 164
 |  |  | 165
 |  |  | 166
 |  |  | 167
 |  |  | 168
 |  |  | 169
 |  |  | 170
 |  |  | 171
 |  |  | 172
 |  |  | 173
 |  |  | 174
 |  |  | 175
 |  |  | 176
 |  |  | 177
 |  |  | 178
 |  |  | 179
 |  |  | 180
Spreadsheet: 662957d1581852446-finding-clashes-in-a-table-for-forum
Sheet: Sheet1

Name | A2;Art and Design ; Fine Art | A2;Biology | A2;Business Studies | A2;Chemistry | A2;Computing | A2;Drama And Theatre Studies | A2;DT Product Design | A2;Economics | A2;Eng Lang and Lit | A2;English Literature | A2;Film Studies | A2;French | A2;Geography | A2;History | A2;Mathematics (Further) | A2;Mathematics | A2;Music | A2;Physical Education | A2;Physics | A2;Religious Studies | A2;Spanish
Pupil 1 |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
Pupil 2 |  | Y |  | Y |  |  |  |  |  |  |  | Y |  |  |  | Y
Pupil 3 |  |  |  |  |  |  |  |  | Y |  |  |  |  | Y |  |  |  |  |  | Y
Pupil 4 |  |  | Y |  |  |  |  | Y |  |  |  |  |  |  |  | Y
Pupil 5 |  | Y |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
Pupil 6 |  |  |  | Y |  |  |  |  |  |  |  |  |  |  | Y | Y |  |  | Y
Pupil 7 |  |  |  |  |  |  |  |  | Y |  |  |  | Y |  |  |  |  | Y
Pupil 8 |  |  | Y |  |  |  | Y | Y
Pupil 9 |  |  | Y |  |  |  |  |  |  |  | Y |  |  |  |  | Y
Pupil 10 |  |  |  |  |  |  |  |  | Y |  |  |  | Y |  |  |  |  |  |  | Y
Pupil 11 |  |  |  |  |  |  |  |  | Y |  |  |  |  | Y |  |  |  |  |  | Y
Pupil 12 |  | Y | Y
Pupil 13 |  |  |  |  | Y |  |  |  |  |  |  |  | Y |  | Y | Y |  |  | Y
Pupil 14 |  | Y |  | Y |  |  |  |  |  |  |  | Y
Pupil 15 |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
Pupil 16 |  |  |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |  |  | Y
Pupil 17 |  | Y |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
Pupil 18 |  | Y |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  | Y
Pupil 19 |  |  |  |  | Y |  |  |  |  |  | Y |  |  |  |  | Y
Pupil 20 |  |  | Y |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  | Y
Pupil 21 |  |  |  | Y |  |  |  | Y |  |  |  |  |  |  |  | Y |  |  | Y
Pupil 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  | Y
Pupil 23 |  |  |  | Y |  |  |  |  |  | Y |  |  |  | Y
Pupil 24 |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  | Y
Pupil 25 |  |  |  |  | Y |  |  | Y |  |  |  | Y |  |  |  | Y
Pupil 26 |  | Y |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
Pupil 27 |  | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  | Y
Pupil 28 |  | Y |  | Y |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y
Pupil 29 |  | Y |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
Pupil 30 |  |  | Y |  |  |  | Y |  |  |  | Y
Pupil 31 |  | Y |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
Pupil 32 |  | Y |  | Y |  |  |  |  |  | Y |  |  |  |  |  |  |  |  | Y
Spreadsheet: 740502d1626359112-excel-formula-to-examine-3-values-then-take-4th-value-and-populate-another-sheet-my-sample
Sheet: RAW Data

SITE_DESC | Region | DEVICE | VIDEO_SERVICE | CARES Essential Internet | CARES Starter Internet | CBI Home Office - CHSI Feature Pack | CBI Telework - CHSI Feature Pack | Connect2Compete Internet | Cox Internet - Seasonal | EOL CMD-EL DOCSIS RF Tollgrade | Essential Internet
Cleveland | Northeast | BYOD | N | 1 |  |  |  | 6 | 50 |  | 1575
Cleveland | Northeast | BYOD | Y |  |  |  |  |  |  |  | 815
Cleveland | Northeast | PW6 | N |  |  |  |  |  |  |  | 542
Cleveland | Northeast | PW6 | N |  |  |  |  |  |  |  | 642 | These two need to be added and the sum entered into H5 on breakout tab